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

>10,000 rows count all where station_code = "NZ003U" 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
9269218 9269218 20260128124611_rVKGG NZ003U 2026-01-29T14:07:01.849Z 2026-01-29T14:07:01.849Z
9269092 9269092 20260128122213_35Vap NZ003U 2026-01-29T14:06:28.546Z 2026-01-29T14:06:28.546Z
9265895 9265895 20260127161111_WSdgw NZ003U 2026-01-28T14:11:41.985Z 2026-01-29T14:30:24.710Z
9265697 9265697 20260127154946_7HaHS NZ003U 2026-01-28T14:11:01.619Z 2026-01-29T14:30:24.657Z
9265675 9265675 20260127154815_8UCHK NZ003U 2026-01-28T14:10:56.969Z 2026-01-29T14:30:24.652Z
9265612 9265612 20260127153823_9uFWZ NZ003U 2026-01-28T14:10:43.958Z 2026-01-29T14:30:24.622Z
9265541 9265541 20260127153049_u0CtK NZ003U 2026-01-28T14:10:29.861Z 2026-01-29T14:30:24.602Z
9265529 9265529 20260127152456_Q0Fiy NZ003U 2026-01-28T14:10:27.839Z 2026-01-29T14:30:24.599Z
9265524 9265524 20260127152425_5HXWG NZ003U 2026-01-28T14:10:27.274Z 2026-01-29T14:30:24.598Z
9265445 9265445 20260127151634_z3srJ NZ003U 2026-01-28T14:10:11.653Z 2026-01-29T14:30:24.551Z
9265415 9265415 20260127151322_HdmZP NZ003U 2026-01-28T14:10:07.887Z 2026-01-29T14:30:24.545Z
9265398 9265398 20260127151204_5D5Kf NZ003U 2026-01-28T14:10:02.634Z 2026-01-29T14:30:24.541Z
9265359 9265359 20260127150652_gAQtc NZ003U 2026-01-28T14:09:55.564Z 2026-01-29T14:30:24.534Z
9265355 9265355 20260127150347_nR1xQ NZ003U 2026-01-28T14:09:54.487Z 2026-01-29T14:30:24.532Z
9265328 9265328 20260127150020_NdR9w NZ003U 2026-01-28T14:09:50.406Z 2026-01-29T14:30:24.527Z
9265322 9265322 20260127145939_RvdEC NZ003U 2026-01-28T14:09:49.746Z 2026-01-29T14:30:24.526Z
9265277 9265277 20260127145426_Lu5KI NZ003U 2026-01-28T14:09:43.907Z 2026-01-29T14:30:24.520Z
9265170 9265170 20260127142911_la7mv NZ003U 2026-01-28T14:09:19.205Z 2026-01-29T14:30:24.483Z
9265062 9265062 20260127141035_BqQtj NZ003U 2026-01-28T14:08:54.048Z 2026-01-29T14:30:24.429Z
9265057 9265057 20260127141018_ZIJqp NZ003U 2026-01-28T14:08:52.697Z 2026-01-29T14:30:24.428Z
9265050 9265050 20260127140551_eHn2P NZ003U 2026-01-28T14:08:50.490Z 2026-01-29T14:30:24.426Z
9265027 9265027 20260127135944_bhOiR NZ003U 2026-01-28T14:08:43.587Z 2026-01-29T14:30:24.419Z
9264966 9264966 20260127134306_oHIrl NZ003U 2026-01-28T14:08:25.733Z 2026-01-29T14:30:24.402Z
9264951 9264951 20260127134039_GhntP NZ003U 2026-01-28T14:08:21.214Z 2026-01-29T14:30:24.397Z
9264881 9264881 20260127132858_swdF3 NZ003U 2026-01-28T14:08:06.233Z 2026-01-29T14:30:24.319Z
9245511 9245511 20260122125113_OtEvt NZ003U 2026-01-23T14:02:15.746Z 2026-01-29T14:49:45.029Z
9245440 9245440 20260122122536_Ghouy NZ003U 2026-01-23T14:01:58.070Z 2026-01-29T14:49:39.969Z
9245298 9245298 20260122114226_SWWa3 NZ003U 2026-01-23T14:01:23.245Z 2026-01-29T14:49:22.435Z
9245269 9245269 20260122113247_Tqq2Y NZ003U 2026-01-23T14:01:16.070Z 2026-01-29T14:49:19.645Z
9233483 9233483 20260120155929_obULa NZ003U 2026-01-21T14:05:56.514Z 2026-01-29T15:01:23.430Z
9233437 9233437 20260120152104_KCokx NZ003U 2026-01-21T14:05:46.354Z 2026-01-29T15:01:17.509Z
9233432 9233432 20260120151455_FBsp2 NZ003U 2026-01-21T14:05:45.821Z 2026-01-29T15:01:16.980Z
9233424 9233424 20260120150845_Vg1Fb NZ003U 2026-01-21T14:05:44.219Z 2026-01-29T15:01:15.811Z
9233335 9233335 20260120144846_Qge0y NZ003U 2026-01-21T14:05:24.920Z 2026-01-29T15:01:01.206Z
9233331 9233331 20260120144608_PsTUz NZ003U 2026-01-21T14:05:23.804Z 2026-01-29T15:01:00.896Z
9233327 9233327 20260120144121_s3HNw NZ003U 2026-01-21T14:05:22.570Z 2026-01-29T15:01:00.691Z
9233317 9233317 20260120143740_Dn5xj NZ003U 2026-01-21T14:05:20.739Z 2026-01-29T15:00:59.541Z
9233289 9233289 20260120142534_Ff7IB NZ003U 2026-01-21T14:05:15.452Z 2026-01-29T15:00:55.481Z
9233245 9233245 20260120135237_s7SB8 NZ003U 2026-01-21T14:04:57.154Z 2026-01-29T15:00:51.474Z
9233149 9233149 20260120132905_xKGEM NZ003U 2026-01-21T14:04:44.542Z 2026-01-29T15:00:47.360Z
9233079 9233079 20260120131830_MAxXC NZ003U 2026-01-21T14:04:27.239Z 2026-01-29T15:00:44.506Z
9233044 9233044 20260120131254_bGspR NZ003U 2026-01-21T14:04:19.459Z 2026-01-29T15:00:40.135Z
9232973 9232973 20260120130043_UOtiW NZ003U 2026-01-21T14:04:01.482Z 2026-01-29T15:00:33.818Z
9232967 9232967 20260120125931_1fxdR NZ003U 2026-01-21T14:03:59.763Z 2026-01-29T15:00:33.111Z
9232839 9232839 20260120123542_ks206 NZ003U 2026-01-21T14:03:25.915Z 2026-01-29T15:00:18.999Z
9232685 9232685 20260120121025_j0Idv NZ003U 2026-01-21T14:02:52.755Z 2026-01-29T14:59:57.303Z
9232678 9232678 20260120120956_oLk5N NZ003U 2026-01-21T14:02:51.669Z 2026-01-29T14:59:56.976Z
9232614 9232614 20260120115759_y18Ki NZ003U 2026-01-21T14:02:34.691Z 2026-01-29T14:59:53.319Z
9232555 9232555 20260120114827_uGieU NZ003U 2026-01-21T14:02:21.928Z 2026-01-29T14:59:50.599Z
9232544 9232544 20260120114631_W5zIB NZ003U 2026-01-21T14:02:19.170Z 2026-01-29T14:59:49.698Z
9232514 9232514 20260120114116_U8sXM NZ003U 2026-01-21T14:02:06.797Z 2026-01-29T14:59:48.123Z
9232451 9232451 20260120113017_uZcp2 NZ003U 2026-01-21T14:01:55.911Z 2026-01-29T14:59:43.698Z
9231926 9231926 20260119101740_sfmlE NZ003U 2026-01-20T14:34:48.663Z 2026-01-27T15:07:06.171Z
9231845 9231845 20260119100315_zJEB1 NZ003U 2026-01-20T14:34:30.935Z 2026-01-27T15:07:02.169Z
9231828 9231828 20260119095856_5cyk2 NZ003U 2026-01-20T14:34:27.391Z 2026-01-27T15:07:01.424Z
9227333 9227333 20260119154320_s4gzx NZ003U 2026-01-20T14:07:48.278Z 2026-01-28T14:56:15.120Z
9227318 9227318 20260119153933_wKn1h NZ003U 2026-01-20T14:07:41.145Z 2026-01-28T14:56:14.248Z
9227283 9227283 20260119152627_2hyJx NZ003U 2026-01-20T14:07:31.611Z 2026-01-28T14:56:02.367Z
9227204 9227204 20260119150936_MCIV8 NZ003U 2026-01-20T14:07:08.270Z 2026-01-28T14:55:57.365Z
9227194 9227194 20260119150417_SjNrT NZ003U 2026-01-20T14:07:05.683Z 2026-01-28T14:55:56.545Z
9227191 9227191 20260119150359_uPsWB NZ003U 2026-01-20T14:07:04.999Z 2026-01-28T14:55:56.453Z
9227185 9227185 20260119150007_P860V NZ003U 2026-01-20T14:07:02.787Z 2026-01-28T14:55:56.090Z
9227167 9227167 20260119145540_I4jtE NZ003U 2026-01-20T14:06:55.251Z 2026-01-28T14:55:55.076Z
9227137 9227137 20260119144441_2TUR7 NZ003U 2026-01-20T14:06:44.373Z 2026-01-28T14:55:53.452Z
9227107 9227107 20260119143742_ai4IV NZ003U 2026-01-20T14:06:39.202Z 2026-01-28T14:55:52.044Z
9227074 9227074 20260119142340_ZTfMa NZ003U 2026-01-20T14:06:28.006Z 2026-01-28T14:55:50.193Z
9227045 9227045 20260119141315_U2aZO NZ003U 2026-01-20T14:06:19.617Z 2026-01-28T14:55:48.850Z
9226998 9226998 20260119135406_pz7s6 NZ003U 2026-01-20T14:06:04.891Z 2026-01-28T14:55:46.322Z
9226978 9226978 20260119134700_GhO7q NZ003U 2026-01-20T14:06:00.704Z 2026-01-28T14:55:45.449Z
9226976 9226976 20260119134634_bRNm5 NZ003U 2026-01-20T14:05:59.621Z 2026-01-28T14:55:45.297Z
9226973 9226973 20260119134549_bRWKo NZ003U 2026-01-20T14:05:58.726Z 2026-01-28T14:55:45.150Z
9226902 9226902 20260119132751_waEce NZ003U 2026-01-20T14:05:35.322Z 2026-01-28T14:55:34.295Z
9226813 9226813 20260119130926_WUWRO NZ003U 2026-01-20T14:05:07.815Z 2026-01-28T14:55:28.768Z
9226726 9226726 20260119125459_kKVoq NZ003U 2026-01-20T14:04:47.156Z 2026-01-28T14:55:24.139Z
9226699 9226699 20260119125002_cGMnq NZ003U 2026-01-20T14:04:37.087Z 2026-01-28T14:55:22.640Z
9226620 9226620 20260119123438_ViUL5 NZ003U 2026-01-20T14:04:12.059Z 2026-01-28T14:55:18.776Z
9226455 9226455 20260119120505_4UT4x NZ003U 2026-01-20T14:03:19.980Z 2026-01-28T14:55:02.206Z
9226363 9226363 20260119115039_aTmx8 NZ003U 2026-01-20T14:02:44.395Z 2026-01-28T14:54:56.623Z
9226360 9226360 20260119115029_zkzpb NZ003U 2026-01-20T14:02:43.405Z 2026-01-28T14:54:56.471Z
9226348 9226348 20260119114929_sSHkG NZ003U 2026-01-20T14:02:37.172Z 2026-01-28T14:54:56.057Z
9226345 9226345 20260119114911_wvbYg NZ003U 2026-01-20T14:02:36.274Z 2026-01-28T14:54:55.923Z
9226210 9226210 20260119112942_2D2cd NZ003U 2026-01-20T14:01:51.291Z 2026-01-28T14:54:48.421Z
9226082 9226082 20260119110325_25Wbc NZ003U 2026-01-20T14:01:00.967Z 2026-01-28T14:54:33.862Z
9226078 9226078 20260119110208_YVLT9 NZ003U 2026-01-20T14:00:58.775Z 2026-01-28T14:54:33.585Z
9225775 9225775 20260118105410_QYGZi NZ003U 2026-01-19T14:30:08.430Z 2026-01-26T15:04:44.593Z
9225750 9225750 20260118104845_Mj80p NZ003U 2026-01-19T14:30:03.755Z 2026-01-26T15:04:43.783Z
9225731 9225731 20260118104621_Qevkl NZ003U 2026-01-19T14:30:01.550Z 2026-01-26T15:04:43.273Z
9225651 9225651 20260118103506_lsR5p NZ003U 2026-01-19T14:29:41.759Z 2026-01-26T15:04:40.985Z
9225578 9225578 20260118101647_4F3Jh NZ003U 2026-01-19T14:29:28.772Z 2026-01-26T15:04:38.900Z
9225526 9225526 20260118100409_5Id4W NZ003U 2026-01-19T14:29:15.402Z 2026-01-26T15:04:37.250Z
9225438 9225438 20260118094520_eB2YP NZ003U 2026-01-19T14:28:57.440Z 2026-01-26T15:04:34.425Z
9225379 9225379 20260118093151_7fcd0 NZ003U 2026-01-19T14:28:48.830Z 2026-01-26T15:04:32.455Z
9221499 9221499 20260118154602_XlQJG NZ003U 2026-01-19T14:08:05.053Z 2026-01-27T15:00:28.250Z
9221497 9221497 20260118154556_ujOQJ NZ003U 2026-01-19T14:08:04.437Z 2026-01-27T15:00:27.965Z
9221493 9221493 20260118154528_0lc2O NZ003U 2026-01-19T14:08:03.194Z 2026-01-27T15:00:27.440Z
9221453 9221453 20260118154233_fEw6I NZ003U 2026-01-19T14:07:57.005Z 2026-01-27T15:00:23.423Z
9221376 9221376 20260118152926_3Ar6J NZ003U 2026-01-19T14:07:41.278Z 2026-01-27T15:00:08.053Z
9221363 9221363 20260118152711_fxvXp NZ003U 2026-01-19T14:07:39.395Z 2026-01-27T15:00:07.518Z
9221295 9221295 20260118151549_6f2dl NZ003U 2026-01-19T14:07:23.603Z 2026-01-27T15:00:00.713Z
9221271 9221271 20260118151225_2NMC7 NZ003U 2026-01-19T14:07:19.286Z 2026-01-27T14:59:59.671Z

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