home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,098 rows where station_code = "US002W" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
8677424 8677424 20251203095203_ddQm8 US002W 2025-12-04T14:01:10.345Z 2025-12-05T14:14:34.837Z
8677414 8677414 20251203094252_MyS2n US002W 2025-12-04T14:01:07.715Z 2025-12-05T14:14:34.833Z
8677383 8677383 20251203092935_sTQ3u US002W 2025-12-04T14:00:59.634Z 2025-12-05T14:14:34.822Z
8677373 8677373 20251203092435_NbLQn US002W 2025-12-04T14:00:57.261Z 2025-12-05T14:14:34.818Z
8677341 8677341 20251203085557_iuPPS US002W 2025-12-04T14:00:50.244Z 2025-12-05T14:14:34.807Z
8677304 8677304 20251203083242_rwUaR US002W 2025-12-04T14:00:41.021Z 2025-12-05T14:14:34.794Z
8677296 8677296 20251203082810_MPUqV US002W 2025-12-04T14:00:39.268Z 2025-12-05T14:14:34.791Z
8677237 8677237 20251203073758_PvpaZ US002W 2025-12-04T14:00:27.234Z 2025-12-05T14:14:34.772Z
8677206 8677206 20251203071231_KBqVS US002W 2025-12-04T14:00:21.755Z 2025-12-05T14:14:34.764Z
8677161 8677161 20251203065541_OcWaX US002W 2025-12-04T14:00:10.615Z 2025-12-05T14:14:34.743Z
8677005 8677005 20251202063801_n5ncb US002W 2025-12-03T14:26:04.224Z 2025-12-05T14:29:18.166Z
8669549 8669549 20251202112952_FkhzO US002W 2025-12-03T14:04:29.924Z 2025-12-05T14:17:30.063Z
8669161 8669161 20251202102450_9PTz1 US002W 2025-12-03T14:02:45.973Z 2025-12-05T14:16:55.712Z
8669146 8669146 20251202101936_N6eQp US002W 2025-12-03T14:02:43.412Z 2025-12-05T14:16:54.627Z
8669133 8669133 20251202101712_xg329 US002W 2025-12-03T14:02:41.546Z 2025-12-05T14:16:53.719Z
8668908 8668908 20251202092136_Ts91s US002W 2025-12-03T14:01:34.519Z 2025-12-05T14:16:00.671Z
8668888 8668888 20251202091800_qoysA US002W 2025-12-03T14:01:32.268Z 2025-12-05T14:15:49.487Z
8668874 8668874 20251202091555_2H2WW US002W 2025-12-03T14:01:31.076Z 2025-12-05T14:15:46.864Z
8668740 8668740 20251202084629_YnFaY US002W 2025-12-03T14:00:59.946Z 2025-12-05T14:15:09.946Z
8668672 8668672 20251202081752_dVOaS US002W 2025-12-03T14:00:48.032Z 2025-12-05T14:14:56.632Z
8660272 8660272 20251130121848_r5dHW US002W 2025-12-02T14:07:11.265Z 2025-12-05T14:31:01.951Z
8659741 8659741 20251130111144_rcwsZ US002W 2025-12-02T14:05:12.134Z 2025-12-05T14:30:30.142Z
8659317 8659317 20251130100844_5MEA9 US002W 2025-12-02T14:03:28.701Z 2025-12-05T14:30:01.570Z
8659063 8659063 20251130092718_3keZi US002W 2025-12-02T14:02:25.126Z 2025-12-05T14:29:51.568Z
8658988 8658988 20251130091530_SwP00 US002W 2025-12-02T14:02:03.352Z 2025-12-05T14:29:48.701Z
8658977 8658977 20251130091135_buSa2 US002W 2025-12-02T14:01:59.387Z 2025-12-05T14:29:47.953Z
8658631 8658631 20251126082002_pjA4x US002W 2025-12-01T15:06:19.079Z 2025-12-04T15:12:01.835Z
8658349 8658349 20251127014957_2Bajz US002W 2025-12-01T14:57:51.484Z 2025-12-05T15:04:11.792Z
8658347 8658347 20251127012631_cPfR3 US002W 2025-12-01T14:57:49.103Z 2025-12-05T15:04:04.914Z
8658343 8658343 20251126115308_oXfXg US002W 2025-12-01T14:55:27.187Z 2025-12-05T15:01:31.438Z
8658337 8658337 20251126104117_dZ2al US002W 2025-12-01T14:54:40.302Z 2025-12-05T15:01:04.048Z
8658335 8658335 20251126104025_Dktn7 US002W 2025-12-01T14:54:40.172Z 2025-12-05T15:01:03.923Z
8658325 8658325 20251126092759_hWf1t US002W 2025-12-01T14:54:16.464Z 2025-12-05T15:00:53.478Z
8658323 8658323 20251126092715_Uxr0L US002W 2025-12-01T14:54:14.505Z 2025-12-05T15:00:53.379Z
8593570 8593570 20251125115819_WUMgx US002W 2025-11-26T14:02:35.050Z 2025-12-04T15:05:20.139Z
8593295 8593295 20251125105918_a32RQ US002W 2025-11-26T14:01:41.040Z 2025-12-04T15:05:15.404Z
8583923 8583923 20251123101549_Suv9B US002W 2025-11-25T14:04:36.319Z 2025-12-02T15:09:44.298Z
8582903 8582903 20251123090614_o19KC US002W 2025-11-24T14:34:36.507Z 2025-12-01T15:22:29.296Z
8582792 8582792 20251123083209_J10gA US002W 2025-11-24T14:34:30.880Z 2025-12-01T15:22:27.948Z
8582267 8582267 20251123050839_9wkDP US002W 2025-11-24T14:33:26.646Z 2025-12-01T15:22:20.803Z
8582245 8582245 20251123045759_Tlu6O US002W 2025-11-24T14:33:25.229Z 2025-12-01T15:22:20.061Z
8582191 8582191 20251123043454_iqA7V US002W 2025-11-24T14:33:21.853Z 2025-12-01T15:22:18.309Z
8581777 8581777 20251123021904_1oMcS US002W 2025-11-24T14:32:37.415Z 2025-12-01T15:21:34.299Z
8581744 8581744 20251123020252_dOiyr US002W 2025-11-24T14:32:35.710Z 2025-12-01T15:21:27.375Z
8581138 8581138 20251122095403_ACqNt US002W 2025-11-24T14:29:35.196Z 2025-11-30T15:07:21.758Z
8580962 8580962 20251122091013_DWL2d US002W 2025-11-24T14:29:09.084Z 2025-11-30T15:07:17.203Z
8580775 8580775 20251122072550_FC1fz US002W 2025-11-24T14:28:54.462Z 2025-11-30T15:07:11.307Z
8580765 8580765 20251122072054_cekXE US002W 2025-11-24T14:28:53.681Z 2025-11-30T15:07:11.243Z
8575216 8575216 20251122115841_Qc203 US002W 2025-11-24T14:02:28.895Z 2025-12-01T15:18:05.389Z
8574705 8574705 20251122102753_BOdYx US002W 2025-11-24T14:00:42.427Z 2025-12-01T15:17:23.980Z
8574469 8574469 20251122065821_bkwSZ US002W 2025-11-23T14:43:36.804Z 2025-11-23T14:43:36.804Z
8574149 8574149 20251122051729_RvOMQ US002W 2025-11-23T14:42:25.533Z 2025-11-30T15:06:59.956Z
8573931 8573931 20251122044309_rbyzX US002W 2025-11-23T14:42:07.670Z 2025-11-30T15:06:51.030Z
8573611 8573611 20251122034341_UuQ6M US002W 2025-11-23T14:41:26.215Z 2025-11-30T15:06:32.818Z
8573562 8573562 20251122033253_8K3XD US002W 2025-11-23T14:41:17.490Z 2025-11-30T15:06:30.887Z
8573465 8573465 20251122031705_1yKF3 US002W 2025-11-23T14:41:12.523Z 2025-11-30T15:06:28.025Z
8573374 8573374 20251122030135_i2jmU US002W 2025-11-23T14:41:08.591Z 2025-11-30T15:06:19.554Z
8573271 8573271 20251122024924_xl4wa US002W 2025-11-23T14:41:03.607Z 2025-11-30T15:06:13.346Z
8573045 8573045 20251122022157_b9nCD US002W 2025-11-23T14:40:41.281Z 2025-11-30T15:06:08.928Z
8573031 8573031 20251122021946_4jN04 US002W 2025-11-23T14:40:40.635Z 2025-11-30T15:06:08.844Z
8529671 8529671 20251119102223_8xBOF US002W 2025-11-20T14:45:11.784Z 2025-11-27T15:13:36.341Z
8529527 8529527 20251119092500_2gRDD US002W 2025-11-20T14:45:00.635Z 2025-11-27T15:13:32.170Z
8517781 8517781 20251118120459_ooMTX US002W 2025-11-20T14:01:15.645Z 2025-11-27T15:10:50.609Z
8516944 8516944 20251118091540_2YN9Z US002W 2025-11-19T14:42:18.522Z 2025-11-26T15:08:11.699Z
8516664 8516664 20251118080527_pveZh US002W 2025-11-19T14:42:07.486Z 2025-11-26T15:08:08.695Z
8516659 8516659 20251118080451_PF1p0 US002W 2025-11-19T14:42:07.411Z 2025-11-26T15:08:08.671Z
8516505 8516505 20251118071914_NZ0Gu US002W 2025-11-19T14:41:39.288Z 2025-11-26T15:08:07.975Z
8516316 8516316 20251118062200_061A2 US002W 2025-11-19T14:40:49.896Z 2025-11-26T15:08:06.875Z
8515431 8515431 20251118042559_iGDSY US002W 2025-11-19T14:39:45.715Z 2025-11-26T15:08:00.991Z
8515190 8515190 20251118035714_K9lbH US002W 2025-11-19T14:39:01.703Z 2025-11-26T15:07:59.563Z
8501477 8501477 20251116110535_6E3CB US002W 2025-11-18T14:47:26.062Z 2025-11-24T15:06:37.272Z
8501281 8501281 20251116104232_wdZ5g US002W 2025-11-18T14:47:18.967Z 2025-11-24T15:06:27.989Z
8501261 8501261 20251116103929_4ddoa US002W 2025-11-18T14:47:18.613Z 2025-11-24T15:06:27.804Z
8500242 8500242 20251116082055_zwOkc US002W 2025-11-18T14:45:45.760Z 2025-11-24T15:05:37.084Z
8500108 8500108 20251116074057_NkECf US002W 2025-11-18T14:45:32.220Z 2025-11-24T15:05:31.858Z
8499201 8499201 20251117064253_qgLGe US002W 2025-11-18T14:34:13.684Z 2025-11-25T15:11:07.704Z
8498902 8498902 20251117034022_urfbI US002W 2025-11-18T14:32:10.971Z 2025-11-25T15:09:49.976Z
8486162 8486162 20251115111955_YwLpG US002W 2025-11-17T14:34:12.252Z 2025-11-23T15:20:24.819Z
8484731 8484731 20251115100227_K1Rn2 US002W 2025-11-17T14:32:55.978Z 2025-11-23T15:19:47.005Z
8484356 8484356 20251115093726_JZRS6 US002W 2025-11-17T14:32:45.277Z 2025-11-23T15:19:34.773Z
8483435 8483435 20251115082900_Q6qtb US002W 2025-11-17T14:31:41.317Z 2025-11-23T15:18:54.743Z
8483292 8483292 20251115081929_D2BZv US002W 2025-11-17T14:31:15.430Z 2025-11-23T15:18:46.972Z
8483198 8483198 20251115080803_EXpwJ US002W 2025-11-17T14:31:04.567Z 2025-11-23T15:18:44.902Z
8483064 8483064 20251115075027_KTDjM US002W 2025-11-17T14:30:59.033Z 2025-11-23T15:18:41.085Z
8482992 8482992 20251115073753_yIrvs US002W 2025-11-17T14:30:55.928Z 2025-11-23T15:18:39.414Z
8482883 8482883 20251115071801_rLxys US002W 2025-11-17T14:30:49.906Z 2025-11-23T15:18:30.568Z
8482701 8482701 20251115064625_ADxaq US002W 2025-11-17T14:30:23.683Z 2025-11-23T15:18:24.607Z
8482454 8482454 20251116065224_Ws1OV US002W 2025-11-17T14:23:31.559Z 2025-11-24T15:05:28.306Z
8482409 8482409 20251116063737_DFFLe US002W 2025-11-17T14:23:13.784Z 2025-11-24T15:05:27.583Z
8482400 8482400 20251116063712_xTixx US002W 2025-11-17T14:23:13.092Z 2025-11-24T15:05:27.515Z
8481339 8481339 20251116024259_HCE19 US002W 2025-11-17T14:20:43.172Z 2025-11-24T15:05:02.328Z
8481292 8481292 20251116022532_usdrR US002W 2025-11-17T14:20:37.250Z 2025-11-17T14:34:35.692Z
8470722 8470722 20251115053403_nU2ns US002W 2025-11-16T14:23:32.847Z 2025-11-23T15:18:18.413Z
8470099 8470099 20251115041640_q0Kfs US002W 2025-11-16T14:22:01.970Z 2025-11-23T15:18:00.288Z
8469648 8469648 20251115031334_kEKei US002W 2025-11-16T14:20:46.559Z 2025-11-23T15:17:53.284Z
8469304 8469304 20251115023110_SHDb6 US002W 2025-11-16T14:19:55.287Z 2025-11-23T15:17:38.307Z
8462128 8462128 20251114105601_AbIJI US002W 2025-11-15T14:25:36.096Z 2025-11-22T15:24:03.952Z
8461287 8461287 20251114090225_iIZ6k US002W 2025-11-15T14:24:06.544Z 2025-11-22T15:23:16.811Z
8461115 8461115 20251114084041_TlKcO US002W 2025-11-15T14:23:37.820Z 2025-11-22T15:23:10.650Z
8460826 8460826 20251114080059_fWPMX US002W 2025-11-15T14:22:55.165Z 2025-11-22T15:22:49.436Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network