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

411 rows where station_code = "NZ005S" 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
9270607 9270607 20260128161109_MFZ6B NZ005S 2026-01-29T14:12:59.987Z 2026-01-29T14:12:59.987Z
9270584 9270584 20260128160739_zNFmK NZ005S 2026-01-29T14:12:51.501Z 2026-01-29T14:12:51.501Z
9270403 9270403 20260128154352_zb2vz NZ005S 2026-01-29T14:12:09.361Z 2026-01-29T14:12:09.361Z
9270378 9270378 20260128154057_3uPDJ NZ005S 2026-01-29T14:11:59.041Z 2026-01-29T14:11:59.041Z
9270286 9270286 20260128152654_uiTSE NZ005S 2026-01-29T14:11:34.331Z 2026-01-29T14:11:34.331Z
9270180 9270180 20260128150600_euhRA NZ005S 2026-01-29T14:11:12.373Z 2026-01-29T14:11:12.373Z
9270029 9270029 20260128144940_e2VyS NZ005S 2026-01-29T14:10:41.152Z 2026-01-29T14:10:41.152Z
9270007 9270007 20260128144320_iMXI8 NZ005S 2026-01-29T14:10:36.919Z 2026-01-29T14:10:36.919Z
9269832 9269832 20260128141926_LvMGz NZ005S 2026-01-29T14:09:47.761Z 2026-01-29T14:09:47.761Z
9269739 9269739 20260128140416_XTJCN NZ005S 2026-01-29T14:09:22.558Z 2026-01-29T14:09:22.558Z
9269721 9269721 20260128135955_HCSJl NZ005S 2026-01-29T14:09:14.482Z 2026-01-29T14:09:14.482Z
9269706 9269706 20260128135822_Oi3uY NZ005S 2026-01-29T14:09:08.712Z 2026-01-29T14:09:08.712Z
9269658 9269658 20260128135113_GedDu NZ005S 2026-01-29T14:08:59.317Z 2026-01-29T14:08:59.317Z
9269550 9269550 20260128133150_Hgnn2 NZ005S 2026-01-29T14:08:27.238Z 2026-01-29T14:08:27.238Z
9269534 9269534 20260128132957_sW7vn NZ005S 2026-01-29T14:08:23.996Z 2026-01-29T14:08:23.996Z
9269367 9269367 20260128130749_wrvYi NZ005S 2026-01-29T14:07:35.246Z 2026-01-29T14:07:35.246Z
9269365 9269365 20260128130651_8wkZq NZ005S 2026-01-29T14:07:34.691Z 2026-01-29T14:07:34.691Z
9269359 9269359 20260128130548_UVjyB NZ005S 2026-01-29T14:07:33.198Z 2026-01-29T14:07:33.198Z
9269193 9269193 20260128124431_5czQ3 NZ005S 2026-01-29T14:06:56.507Z 2026-01-29T14:06:56.507Z
9269118 9269118 20260128123216_Fz1qU NZ005S 2026-01-29T14:06:35.360Z 2026-01-29T14:06:35.360Z
9269036 9269036 20260128120703_n3uZT NZ005S 2026-01-29T14:06:06.582Z 2026-01-29T14:06:06.582Z
9268964 9268964 20260128115328_MO8Uc NZ005S 2026-01-29T14:05:44.830Z 2026-01-29T14:05:44.830Z
9268887 9268887 20260128113818_Cnj3s NZ005S 2026-01-29T14:05:19.018Z 2026-01-29T14:05:19.018Z
9268838 9268838 20260128113134_Nce10 NZ005S 2026-01-29T14:05:07.926Z 2026-01-29T14:05:07.926Z
9268790 9268790 20260128112243_UrcPx NZ005S 2026-01-29T14:04:52.989Z 2026-01-29T14:04:52.989Z
9268463 9268463 20260128102439_9DUhV NZ005S 2026-01-29T14:03:14.146Z 2026-01-29T14:03:14.146Z
9261957 9261957 20260126145805_JeTQp NZ005S 2026-01-27T14:06:46.253Z 2026-01-29T14:33:20.448Z
9253832 9253832 20260124150639_XBCXS NZ005S 2026-01-25T14:04:36.419Z 2026-01-29T14:41:40.452Z
9253794 9253794 20260124144143_Mpcof NZ005S 2026-01-25T14:04:26.971Z 2026-01-29T14:41:30.814Z
9253759 9253759 20260124142538_1QJo1 NZ005S 2026-01-25T14:04:16.010Z 2026-01-29T14:41:25.011Z
9253606 9253606 20260124130033_GbWcL NZ005S 2026-01-25T14:03:29.646Z 2026-01-29T14:41:02.504Z
9250491 9250491 20260123153447_Y1MkP NZ005S 2026-01-24T14:03:12.971Z 2026-01-29T14:45:40.642Z
9250471 9250471 20260123152446_abE3b NZ005S 2026-01-24T14:03:07.134Z 2026-01-29T14:45:37.743Z
9250418 9250418 20260123143132_Gwi90 NZ005S 2026-01-24T14:02:50.682Z 2026-01-29T14:45:32.429Z
9250080 9250080 20260123100651_90ewM NZ005S 2026-01-24T14:01:02.165Z 2026-01-29T14:44:57.449Z
9246033 9246033 20260122160430_uBPqJ NZ005S 2026-01-23T14:04:26.954Z 2026-01-29T14:50:38.136Z
9245883 9245883 20260122151410_xHw6f NZ005S 2026-01-23T14:03:56.312Z 2026-01-29T14:50:20.581Z
9245853 9245853 20260122150208_hIPpJ NZ005S 2026-01-23T14:03:42.843Z 2026-01-29T14:50:18.212Z
9245657 9245657 20260122133548_IiRRz NZ005S 2026-01-23T14:02:53.681Z 2026-01-29T14:49:53.510Z
9245622 9245622 20260122132329_Jrwzb NZ005S 2026-01-23T14:02:39.115Z 2026-01-29T14:49:51.393Z
9245610 9245610 20260122132157_TK1fA NZ005S 2026-01-23T14:02:36.972Z 2026-01-23T14:02:36.972Z
9245561 9245561 20260122130523_UGWcd NZ005S 2026-01-23T14:02:23.847Z 2026-01-29T14:49:47.260Z
9245512 9245512 20260122125113_OtEvt NZ005S 2026-01-23T14:02:15.746Z 2026-01-29T14:49:45.029Z
9245441 9245441 20260122122536_Ghouy NZ005S 2026-01-23T14:01:58.070Z 2026-01-29T14:49:39.969Z
9245299 9245299 20260122114226_SWWa3 NZ005S 2026-01-23T14:01:23.245Z 2026-01-29T14:49:22.435Z
9245206 9245206 20260122111345_9Xf4p NZ005S 2026-01-23T14:01:01.562Z 2026-01-29T14:49:14.533Z
9245176 9245176 20260122105525_fFPzL NZ005S 2026-01-23T14:00:52.325Z 2026-01-23T14:00:52.325Z
9245153 9245153 20260122103820_WZ40d NZ005S 2026-01-23T14:00:48.388Z 2026-01-29T14:49:05.243Z
9245107 9245107 20260122101356_MyJnk NZ005S 2026-01-23T14:00:34.888Z 2026-01-23T14:00:34.888Z
9245090 9245090 20260122100707_brq2u NZ005S 2026-01-23T14:00:28.774Z 2026-01-29T14:48:57.454Z
9245070 9245070 20260122095224_RqKw2 NZ005S 2026-01-23T14:00:23.356Z 2026-01-29T14:48:55.835Z
9219446 9219446 20260117103408_yv847 NZ005S 2026-01-18T14:16:28.026Z 2026-01-25T14:59:27.894Z
9185456 9185456 20260111111229_IGNy2 NZ005S 2026-01-12T14:24:57.068Z 2026-01-19T15:20:33.402Z
9184662 9184662 20260111120514_Jw3p8 NZ005S 2026-01-12T14:21:14.073Z 2026-01-19T15:21:07.334Z
9184154 9184154 20260111104851_xeMEV NZ005S 2026-01-12T14:19:48.200Z 2026-01-19T15:20:25.117Z
9183599 9183599 20260111094929_GQ9se NZ005S 2026-01-12T14:18:17.323Z 2026-01-19T15:19:47.253Z
9183550 9183550 20260111094228_JC0lr NZ005S 2026-01-12T14:18:06.536Z 2026-01-19T15:19:45.456Z
9183478 9183478 20260111093408_JsZII NZ005S 2026-01-12T14:17:53.634Z 2026-01-12T14:17:53.634Z
9173602 9173602 20260109150209_XRCMa NZ005S 2026-01-10T14:18:13.938Z 2026-01-17T15:26:54.045Z
9173565 9173565 20260109145104_ni93E NZ005S 2026-01-10T14:18:04.309Z 2026-01-17T15:26:50.522Z
9173547 9173547 20260109144020_GEUzm NZ005S 2026-01-10T14:17:57.481Z 2026-01-17T15:26:48.566Z
9173326 9173326 20260109133828_f1tC4 NZ005S 2026-01-10T14:17:04.621Z 2026-01-17T15:26:38.897Z
9173253 9173253 20260109132724_5mm0a NZ005S 2026-01-10T14:16:51.945Z 2026-01-17T15:26:24.716Z
9172942 9172942 20260109123220_NwCuF NZ005S 2026-01-10T14:15:30.158Z 2026-01-17T15:26:08.850Z
9172894 9172894 20260109122307_QW7zS NZ005S 2026-01-10T14:15:19.445Z 2026-01-17T15:26:06.832Z
9172549 9172549 20260109110428_r0siZ NZ005S 2026-01-10T14:13:51.038Z 2026-01-17T15:25:40.401Z
9172437 9172437 20260109104023_8FWhF NZ005S 2026-01-10T14:13:20.116Z 2026-01-17T15:25:33.570Z
9172432 9172432 20260109104014_AlQoi NZ005S 2026-01-10T14:13:19.182Z 2026-01-17T15:25:33.386Z
9172417 9172417 20260109103615_UEXDl NZ005S 2026-01-10T14:13:15.891Z 2026-01-17T15:25:29.518Z
9172170 9172170 20260109092009_td8bc NZ005S 2026-01-10T14:12:03.522Z 2026-01-17T15:25:10.132Z
9170480 9170480 20260109153026_9lyC2 NZ005S 2026-01-10T14:00:48.734Z 2026-01-18T15:06:24.216Z
9170423 9170423 20260109151252_Cz2ci NZ005S 2026-01-10T14:00:27.467Z 2026-01-18T15:06:20.376Z
9170411 9170411 20260109151139_NnYIR NZ005S 2026-01-10T14:00:24.041Z 2026-01-18T15:06:20.088Z
9169487 9169487 20260108144324_USJMB NZ005S 2026-01-09T14:13:40.565Z 2026-01-16T15:14:02.067Z
9169478 9169478 20260108144232_m3ox5 NZ005S 2026-01-09T14:13:39.206Z 2026-01-16T15:14:01.595Z
9169455 9169455 20260108143706_BDC6h NZ005S 2026-01-09T14:13:36.442Z 2026-01-16T15:13:59.540Z
9169444 9169444 20260108143004_Y9ZFS NZ005S 2026-01-09T14:13:35.091Z 2026-01-16T15:13:58.950Z
9169286 9169286 20260108140304_Ezk2a NZ005S 2026-01-09T14:13:11.456Z 2026-01-16T15:13:49.218Z
9168952 9168952 20260108125321_He2d0 NZ005S 2026-01-09T14:12:26.313Z 2026-01-16T15:13:23.066Z
9168890 9168890 20260108123633_79KuA NZ005S 2026-01-09T14:12:17.344Z 2026-01-16T15:13:18.742Z
9168809 9168809 20260108122232_LBaPp NZ005S 2026-01-09T14:12:03.731Z 2026-01-16T15:13:08.343Z
9168788 9168788 20260108121751_F4rk7 NZ005S 2026-01-09T14:12:00.874Z 2026-01-16T15:13:04.598Z
9168778 9168778 20260108121223_y0t2X NZ005S 2026-01-09T14:11:59.584Z 2026-01-16T15:13:03.278Z
9168659 9168659 20260108115313_c3bZm NZ005S 2026-01-09T14:11:42.257Z 2026-01-16T15:12:56.732Z
9168330 9168330 20260108103850_ylg2g NZ005S 2026-01-09T14:10:52.441Z 2026-01-16T15:12:30.693Z
9168035 9168035 20260108093120_AJTUx NZ005S 2026-01-09T14:10:10.682Z 2026-01-16T15:12:15.527Z
9168018 9168018 20260108092351_gu512 NZ005S 2026-01-09T14:10:06.031Z 2026-01-16T15:12:14.649Z
9165931 9165931 20260108153917_qh4cp NZ005S 2026-01-09T14:00:23.955Z 2026-01-17T15:22:44.588Z
9165278 9165278 20260107152401_7mbW3 NZ005S 2026-01-08T14:15:55.315Z 2026-01-13T15:05:38.041Z
9165166 9165166 20260107151320_Rl3sm NZ005S 2026-01-08T14:15:35.031Z 2026-01-13T15:05:31.999Z
9165119 9165119 20260107150740_wQe8U NZ005S 2026-01-08T14:15:28.342Z 2026-01-13T15:05:29.574Z
9164926 9164926 20260107144515_I3uyr NZ005S 2026-01-08T14:14:49.316Z 2026-01-13T15:05:19.956Z
9164923 9164923 20260107144459_KruhZ NZ005S 2026-01-08T14:14:48.645Z 2026-01-13T15:05:19.543Z
9164876 9164876 20260107143944_l78jM NZ005S 2026-01-08T14:14:37.743Z 2026-01-13T15:05:09.837Z
9164859 9164859 20260107143211_oXGvE NZ005S 2026-01-08T14:14:31.371Z 2026-01-13T15:05:08.630Z
9164831 9164831 20260107143114_2AiPQ NZ005S 2026-01-08T14:14:28.518Z 2026-01-13T15:05:07.539Z
9164765 9164765 20260107142301_YYwd5 NZ005S 2026-01-08T14:14:16.837Z 2026-01-13T15:05:02.764Z
9164646 9164646 20260107135831_hzM3c NZ005S 2026-01-08T14:13:54.603Z 2026-01-13T15:04:56.211Z
9164551 9164551 20260107134310_ZhxEs NZ005S 2026-01-08T14:13:34.209Z 2026-01-13T15:04:51.299Z
9164474 9164474 20260107132546_nbRO3 NZ005S 2026-01-08T14:13:17.297Z 2026-01-13T15:04:39.030Z

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