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

1,275 rows where station_code = "NZ005U" 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
9626780 9626780 20260408150342_7YVaY NZ005U 2026-04-09T12:09:10.208Z 2026-04-09T12:09:10.208Z
9626765 9626765 20260408150100_LANIy NZ005U 2026-04-09T12:09:08.606Z 2026-04-09T12:09:08.606Z
9626634 9626634 20260408142914_sz32p NZ005U 2026-04-09T12:08:48.900Z 2026-04-09T12:08:48.900Z
9626371 9626371 20260408134648_DauvQ NZ005U 2026-04-09T12:08:12.534Z 2026-04-09T12:08:12.534Z
9626298 9626298 20260408133926_FNYeo NZ005U 2026-04-09T12:07:55.724Z 2026-04-09T12:07:55.724Z
9626147 9626147 20260408131735_9oYft NZ005U 2026-04-09T12:07:40.773Z 2026-04-09T12:07:40.773Z
9626106 9626106 20260408131125_z2XNH NZ005U 2026-04-09T12:07:35.271Z 2026-04-09T12:07:35.271Z
9625901 9625901 20260408122303_BTFwd NZ005U 2026-04-09T12:07:04.723Z 2026-04-09T12:07:04.723Z
9625874 9625874 20260408121946_hJNuM NZ005U 2026-04-09T12:07:01.869Z 2026-04-09T12:07:01.869Z
9625831 9625831 20260408120030_gTz1b NZ005U 2026-04-09T12:06:51.234Z 2026-04-09T12:06:51.234Z
9605982 9605982 20260403133937_4A0m0 NZ005U 2026-04-04T12:04:45.412Z 2026-04-09T12:42:05.332Z
9605969 9605969 20260403133603_vwgTu NZ005U 2026-04-04T12:04:42.821Z 2026-04-09T12:42:05.099Z
9605903 9605903 20260403124331_ZsUSF NZ005U 2026-04-04T12:04:23.587Z 2026-04-09T12:42:03.313Z
9605898 9605898 20260403124331_PlBlI NZ005U 2026-04-04T12:04:23.138Z 2026-04-09T12:42:03.280Z
9605865 9605865 20260403122818_04l46 NZ005U 2026-04-04T12:04:13.535Z 2026-04-09T12:42:02.662Z
9605739 9605739 20260403114521_7mz8K NZ005U 2026-04-04T12:03:39.363Z 2026-04-09T12:41:30.356Z
9605399 9605399 20260403094512_DtCmY NZ005U 2026-04-04T12:02:03.475Z 2026-04-09T12:41:21.565Z
9605186 9605186 20260403073140_foocq NZ005U 2026-04-04T12:01:02.417Z 2026-04-09T12:41:16.311Z
9605142 9605142 20260403070510_Ygczr NZ005U 2026-04-04T12:00:53.551Z 2026-04-09T12:41:15.385Z
9603810 9603810 20260402124801_S9Lx7 NZ005U 2026-04-03T12:04:46.425Z 2026-04-09T12:44:09.743Z
9601675 9601675 20260401162823_h7yI8 NZ005U 2026-04-02T12:03:26.117Z 2026-04-09T12:45:33.313Z
9597936 9597936 20260330171820_qSRSV NZ005U 2026-03-31T12:07:18.472Z 2026-04-08T12:44:21.058Z
9597926 9597926 20260330171611_iXmv8 NZ005U 2026-03-31T12:07:17.501Z 2026-04-08T12:44:20.782Z
9597896 9597896 20260330171323_mnu1H NZ005U 2026-03-31T12:07:13.635Z 2026-04-08T12:44:19.928Z
9597859 9597859 20260330170946_dU4CC NZ005U 2026-03-31T12:07:08.076Z 2026-04-08T12:44:19.242Z
9597718 9597718 20260330165223_lGO34 NZ005U 2026-03-31T12:06:55.257Z 2026-04-08T12:44:16.044Z
9597708 9597708 20260330165055_kNRIb NZ005U 2026-03-31T12:06:54.128Z 2026-04-08T12:44:15.741Z
9597644 9597644 20260330164723_rN3HG NZ005U 2026-03-31T12:06:49.722Z 2026-04-08T12:44:12.726Z
9597576 9597576 20260330163622_XcMLz NZ005U 2026-03-31T12:06:39.301Z 2026-04-08T12:43:50.208Z
9597513 9597513 20260330162725_VStAC NZ005U 2026-03-31T12:06:30.743Z 2026-04-08T12:43:44.568Z
9597496 9597496 20260330162528_9BU9M NZ005U 2026-03-31T12:06:28.776Z 2026-04-08T12:43:44.184Z
9597462 9597462 20260330162215_mto2A NZ005U 2026-03-31T12:06:26.249Z 2026-04-08T12:43:43.572Z
9597375 9597375 20260330161126_42jDm NZ005U 2026-03-31T12:06:16.099Z 2026-04-08T12:43:41.471Z
9597236 9597236 20260330154708_dwMIF NZ005U 2026-03-31T12:06:00.185Z 2026-04-08T12:43:36.736Z
9596759 9596759 20260330135648_aX6k3 NZ005U 2026-03-31T12:04:54.907Z 2026-04-08T12:43:23.896Z
9596641 9596641 20260330133129_lcJA2 NZ005U 2026-03-31T12:04:39.128Z 2026-04-08T12:43:21.483Z
9596389 9596389 20260330122634_cZvfZ NZ005U 2026-03-31T12:04:08.938Z 2026-04-08T12:42:50.907Z
9596214 9596214 20260330114641_N88lA NZ005U 2026-03-31T12:03:44.545Z 2026-04-08T12:42:44.218Z
9596161 9596161 20260330113027_A5OWl NZ005U 2026-03-31T12:03:37.583Z 2026-04-08T12:42:42.818Z
9596029 9596029 20260330104516_YuL3i NZ005U 2026-03-31T12:03:10.282Z 2026-04-08T12:42:38.845Z
9595767 9595767 20260330083057_wcD5l NZ005U 2026-03-31T12:02:26.071Z 2026-04-08T12:42:31.485Z
9590148 9590148 20260328070517_4I5lt NZ005U 2026-03-29T12:02:06.546Z 2026-04-06T12:37:53.205Z
9587452 9587452 20260327125301_VPW7V NZ005U 2026-03-28T12:05:33.020Z 2026-04-05T12:34:26.972Z
9587430 9587430 20260327124013_oTQhw NZ005U 2026-03-28T12:05:29.723Z 2026-04-05T12:34:26.024Z
9587382 9587382 20260327122154_D2NCD NZ005U 2026-03-28T12:05:23.970Z 2026-04-05T12:34:24.456Z
9587272 9587272 20260327115808_QABwV NZ005U 2026-03-28T12:05:10.237Z 2026-04-05T12:34:10.885Z
9569612 9569612 20260322162404_4mBcp NZ005U 2026-03-24T12:21:29.183Z 2026-03-30T12:30:10.835Z
9569600 9569600 20260322162403_E6Lw8 NZ005U 2026-03-24T12:21:28.703Z 2026-03-30T12:30:10.753Z
9568980 9568980 20260322120459_CNxE5 NZ005U 2026-03-24T12:19:17.161Z 2026-03-30T12:29:14.028Z
9568947 9568947 20260322114106_TN3n5 NZ005U 2026-03-24T12:19:05.964Z 2026-03-30T12:29:10.932Z
9568773 9568773 20260323172153_VIvY8 NZ005U 2026-03-24T12:15:42.941Z 2026-03-31T12:28:42.249Z
9568641 9568641 20260323170815_pbJOA NZ005U 2026-03-24T12:15:26.526Z 2026-03-31T12:28:39.460Z
9568612 9568612 20260323170240_9rLoc NZ005U 2026-03-24T12:15:22.403Z 2026-03-31T12:28:38.649Z
9568139 9568139 20260323161604_1fgpi NZ005U 2026-03-24T12:14:36.919Z 2026-03-31T12:28:23.477Z
9568030 9568030 20260323160806_5lCwM NZ005U 2026-03-24T12:14:26.032Z 2026-03-31T12:28:21.920Z
9567150 9567150 20260323144625_mgOP6 NZ005U 2026-03-24T12:13:07.641Z 2026-03-31T12:28:09.301Z
9567084 9567084 20260323143757_BTXW8 NZ005U 2026-03-24T12:12:58.600Z 2026-03-31T12:28:08.185Z
9566995 9566995 20260323143145_MY9cf NZ005U 2026-03-24T12:12:50.143Z 2026-03-31T12:28:07.048Z
9566970 9566970 20260323143114_3VmH7 NZ005U 2026-03-24T12:12:47.214Z 2026-03-31T12:28:06.674Z
9566950 9566950 20260323142947_rHz3w NZ005U 2026-03-24T12:12:45.473Z 2026-03-31T12:28:06.363Z
9566640 9566640 20260323135837_xXRFF NZ005U 2026-03-24T12:12:14.001Z 2026-03-31T12:27:54.872Z
9566577 9566577 20260323135530_oegVC NZ005U 2026-03-24T12:12:08.482Z 2026-03-31T12:27:53.984Z
9566005 9566005 20260323125651_Anwor NZ005U 2026-03-24T12:11:11.674Z 2026-03-31T12:27:44.653Z
9565882 9565882 20260323124821_nSYTG NZ005U 2026-03-24T12:10:58.419Z 2026-03-31T12:27:42.774Z
9565680 9565680 20260323123259_2QEhU NZ005U 2026-03-24T12:10:38.218Z 2026-03-31T12:27:39.631Z
9565540 9565540 20260323121823_p3CFf NZ005U 2026-03-24T12:10:22.439Z 2026-03-31T12:27:37.248Z
9565526 9565526 20260323121638_irduP NZ005U 2026-03-24T12:10:20.946Z 2026-03-29T12:15:02.419Z
9565323 9565323 20260323120107_tr8NS NZ005U 2026-03-24T12:09:53.257Z 2026-03-31T12:27:33.278Z
9565167 9565167 20260323114800_iAtw5 NZ005U 2026-03-24T12:09:31.706Z 2026-03-29T12:14:56.635Z
9565141 9565141 20260323114633_m5iaX NZ005U 2026-03-24T12:09:28.602Z 2026-03-31T12:27:23.379Z
9565124 9565124 20260323114522_FYf4Z NZ005U 2026-03-24T12:09:26.807Z 2026-03-31T12:27:23.177Z
9564987 9564987 20260323113402_UVMCh NZ005U 2026-03-24T12:09:11.848Z 2026-03-31T12:27:20.332Z
9564921 9564921 20260323112304_tquP1 NZ005U 2026-03-24T12:09:01.873Z 2026-03-31T12:27:19.045Z
9564831 9564831 20260323111045_GYv2H NZ005U 2026-03-24T12:08:52.023Z 2026-03-31T12:27:16.065Z
9564752 9564752 20260323110626_TtAyq NZ005U 2026-03-24T12:08:44.810Z 2026-03-31T12:27:14.933Z
9564540 9564540 20260323104659_JYwmI NZ005U 2026-03-24T12:08:20.511Z 2026-03-31T12:27:11.225Z
9563923 9563923 20260323093404_tc7ir NZ005U 2026-03-24T12:07:00.250Z 2026-03-31T12:26:59.128Z
9563787 9563787 20260323090840_GorHN NZ005U 2026-03-24T12:06:43.263Z 2026-03-31T12:26:56.570Z
9563259 9563259 20260323074718_nVDHh NZ005U 2026-03-24T12:05:36.994Z 2026-03-31T12:26:39.336Z
9559369 9559369 20260321170158_VL89D NZ005U 2026-03-23T12:11:03.196Z 2026-03-29T12:20:38.206Z
9559214 9559214 20260321164702_7R4bR NZ005U 2026-03-23T12:10:58.000Z 2026-03-29T12:20:35.308Z
9559113 9559113 20260321163352_M1O5G NZ005U 2026-03-23T12:10:54.460Z 2026-03-29T12:20:34.083Z
9558842 9558842 20260321155402_L7Gj4 NZ005U 2026-03-23T12:10:36.768Z 2026-03-29T12:20:30.891Z
9558322 9558322 20260322162019_7jkbr NZ005U 2026-03-23T12:06:38.204Z 2026-03-30T12:30:10.500Z
9558189 9558189 20260322160311_2aq7N NZ005U 2026-03-23T12:06:28.725Z 2026-03-30T12:30:07.185Z
9558128 9558128 20260322155211_D59Q0 NZ005U 2026-03-23T12:06:26.190Z 2026-03-30T12:30:05.174Z
9558102 9558102 20260322154521_2U9uP NZ005U 2026-03-23T12:06:23.785Z 2026-03-30T12:30:04.443Z
9558087 9558087 20260322154211_WTxaw NZ005U 2026-03-23T12:06:22.951Z 2026-03-30T12:30:03.931Z
9558055 9558055 20260322153755_IA8iV NZ005U 2026-03-23T12:06:21.236Z 2026-03-30T12:30:02.676Z
9558045 9558045 20260322153513_Fi7xA NZ005U 2026-03-23T12:06:20.892Z 2026-03-30T12:30:02.324Z
9558018 9558018 20260322153230_K5IJU NZ005U 2026-03-23T12:06:19.771Z 2026-03-30T12:29:54.406Z
9558007 9558007 20260322153159_UyF7p NZ005U 2026-03-23T12:06:19.428Z 2026-03-30T12:29:54.277Z
9557960 9557960 20260322152359_cdcSW NZ005U 2026-03-23T12:06:17.383Z 2026-03-30T12:29:53.050Z
9557925 9557925 20260322151625_rf5or NZ005U 2026-03-23T12:06:15.903Z 2026-03-30T12:29:51.783Z
9557901 9557901 20260322151213_GOoDl NZ005U 2026-03-23T12:06:14.613Z 2026-03-30T12:29:50.969Z
9557819 9557819 20260322145838_49wZ0 NZ005U 2026-03-23T12:06:11.059Z 2026-03-30T12:29:48.286Z
9557695 9557695 20260322144228_IbV7N NZ005U 2026-03-23T12:06:05.444Z 2026-03-30T12:29:44.964Z
9557620 9557620 20260322143200_G5Cj3 NZ005U 2026-03-23T12:05:59.097Z 2026-03-30T12:29:43.159Z
9557615 9557615 20260322143111_Dcxl1 NZ005U 2026-03-23T12:05:58.973Z 2026-03-30T12:29:43.015Z
9557570 9557570 20260322142559_kP58J NZ005U 2026-03-23T12:05:56.702Z 2026-03-30T12:29:42.059Z

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