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

181 rows where station_code = "NZ006N" 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
9609084 9609084 20260330174545_LdLN7 NZ006N 2026-04-05T12:25:00.061Z 2026-04-08T12:44:25.172Z
9609069 9609069 20260331150215_OxDft NZ006N 2026-04-05T12:20:05.885Z 2026-04-09T12:46:49.315Z
9609065 9609065 20260331103358_YqimX NZ006N 2026-04-05T12:19:21.315Z 2026-04-09T12:46:39.708Z
9609063 9609063 20260331093132_D9b9A NZ006N 2026-04-05T12:19:16.397Z 2026-04-09T12:46:38.687Z
9609059 9609059 20260331081522_3ugmR NZ006N 2026-04-05T12:19:07.077Z 2026-04-09T12:46:37.108Z
9609045 9609045 20260402104509_TV43a NZ006N 2026-04-05T12:14:12.469Z 2026-04-10T12:34:03.300Z
9568158 9568158 20260323161630_ZXUyI NZ006N 2026-03-24T12:14:38.270Z 2026-03-31T12:28:23.777Z
9568122 9568122 20260323161527_vZGtV NZ006N 2026-03-24T12:14:35.862Z 2026-03-31T12:28:23.265Z
9567561 9567561 20260323152959_OZ8O0 NZ006N 2026-03-24T12:13:46.938Z 2026-03-31T12:28:15.810Z
9567367 9567367 20260323151010_GeUQM NZ006N 2026-03-24T12:13:28.114Z 2026-03-24T12:24:25.266Z
9566797 9566797 20260323141346_Bbv0y NZ006N 2026-03-24T12:12:27.166Z 2026-03-31T12:28:04.326Z
9566616 9566616 20260323135717_X7W42 NZ006N 2026-03-24T12:12:12.725Z 2026-03-31T12:27:54.713Z
9566501 9566501 20260323134643_vxthx NZ006N 2026-03-24T12:11:58.556Z 2026-03-31T12:27:52.907Z
9566236 9566236 20260323131611_CB37r NZ006N 2026-03-24T12:11:28.811Z 2026-03-31T12:27:47.430Z
9566172 9566172 20260323131019_8DGoe NZ006N 2026-03-24T12:11:24.894Z 2026-03-31T12:27:46.814Z
9566072 9566072 20260323130326_MpaaY NZ006N 2026-03-24T12:11:18.435Z 2026-03-31T12:27:45.732Z
9559493 9559493 20260321173027_ZMmfh NZ006N 2026-03-23T12:11:07.909Z 2026-03-29T12:20:39.977Z
9559365 9559365 20260321170144_LvPfH NZ006N 2026-03-23T12:11:03.045Z 2026-03-29T12:20:38.169Z
9559319 9559319 20260321165624_2tw5N NZ006N 2026-03-23T12:11:01.616Z 2026-03-29T12:20:37.501Z
9559129 9559129 20260321163829_RZWNi NZ006N 2026-03-23T12:10:55.120Z 2026-03-29T12:20:34.355Z
9559114 9559114 20260321163352_M1O5G NZ006N 2026-03-23T12:10:54.460Z 2026-03-29T12:20:34.083Z
9559099 9559099 20260321163056_6C973 NZ006N 2026-03-23T12:10:53.930Z 2026-03-29T12:20:33.975Z
9557155 9557155 20260322130448_LpFa3 NZ006N 2026-03-23T12:05:38.888Z 2026-03-30T12:29:30.170Z
9556728 9556728 20260322112507_dfyAB NZ006N 2026-03-23T12:05:09.227Z 2026-03-30T12:29:09.111Z
9556715 9556715 20260322112414_V9VYh NZ006N 2026-03-23T12:05:08.718Z 2026-03-30T12:29:08.845Z
9556321 9556321 20260322100224_JSk5a NZ006N 2026-03-23T12:04:39.416Z 2026-03-30T12:28:57.423Z
9556293 9556293 20260322095854_v6HeS NZ006N 2026-03-23T12:04:37.789Z 2026-03-30T12:28:56.835Z
9556208 9556208 20260322093310_S7qsB NZ006N 2026-03-23T12:04:28.654Z 2026-03-30T12:28:47.432Z
9556161 9556161 20260322092807_HROti NZ006N 2026-03-23T12:04:25.455Z 2026-03-30T12:28:46.224Z
9555996 9555996 20260322090028_5zBST NZ006N 2026-03-23T12:04:14.245Z 2026-03-30T12:28:41.208Z
9555699 9555699 20260322073119_MGRh0 NZ006N 2026-03-23T12:03:47.271Z 2026-03-30T12:28:32.387Z
9549767 9549767 20260320153659_BbzZ1 NZ006N 2026-03-22T12:24:27.723Z 2026-03-28T12:36:20.536Z
9549354 9549354 20260320144950_k3f15 NZ006N 2026-03-22T12:23:53.732Z 2026-03-28T12:36:01.630Z
9549306 9549306 20260320144712_uuszt NZ006N 2026-03-22T12:23:51.476Z 2026-03-28T12:36:01.387Z
9549047 9549047 20260321165728_kdh0x NZ006N 2026-03-22T12:16:28.183Z 2026-03-29T12:20:37.736Z
9548976 9548976 20260321161947_fYjYD NZ006N 2026-03-22T12:16:20.812Z 2026-03-29T12:20:33.176Z
9548917 9548917 20260321154703_Pw69D NZ006N 2026-03-22T12:16:10.134Z 2026-03-29T12:20:30.243Z
9548655 9548655 20260321152307_tzTfj NZ006N 2026-03-22T12:15:46.327Z 2026-03-29T12:20:27.803Z
9548113 9548113 20260321143337_8Mis0 NZ006N 2026-03-22T12:14:54.523Z 2026-03-29T12:20:24.021Z
9548108 9548108 20260321143302_uDKhX NZ006N 2026-03-22T12:14:54.216Z 2026-03-29T12:20:24.004Z
9548023 9548023 20260321142545_ei09G NZ006N 2026-03-22T12:14:45.468Z 2026-03-29T12:20:23.363Z
9547874 9547874 20260321140436_B9Rrl NZ006N 2026-03-22T12:14:26.332Z 2026-03-29T12:20:22.074Z
9547835 9547835 20260321140335_KiAei NZ006N 2026-03-22T12:14:22.869Z 2026-03-29T12:20:21.665Z
9547732 9547732 20260321135440_74Os2 NZ006N 2026-03-22T12:14:11.220Z 2026-03-29T12:20:16.612Z
9547668 9547668 20260321135009_sDuYa NZ006N 2026-03-22T12:14:04.611Z 2026-03-22T12:27:38.515Z
9547656 9547656 20260321134827_7XCGH NZ006N 2026-03-22T12:14:02.901Z 2026-03-29T12:20:11.016Z
9547419 9547419 20260321132633_oFXTw NZ006N 2026-03-22T12:13:37.351Z 2026-03-29T12:20:09.373Z
9547273 9547273 20260321131225_piyOm NZ006N 2026-03-22T12:13:19.024Z 2026-03-29T12:20:08.275Z
9547120 9547120 20260321125414_1DvHi NZ006N 2026-03-22T12:13:02.485Z 2026-03-29T12:20:07.036Z
9546922 9546922 20260321124032_c5b6I NZ006N 2026-03-22T12:12:40.062Z 2026-03-29T12:20:05.294Z
9546395 9546395 20260321115713_E9AHC NZ006N 2026-03-22T12:11:38.907Z 2026-03-29T12:20:00.626Z
9546339 9546339 20260321115457_qwCcI NZ006N 2026-03-22T12:11:31.216Z 2026-03-29T12:19:55.137Z
9546170 9546170 20260321114150_2gVST NZ006N 2026-03-22T12:11:12.195Z 2026-03-29T12:19:48.083Z
9545791 9545791 20260321110635_m0rwW NZ006N 2026-03-22T12:10:16.148Z 2026-03-29T12:19:43.287Z
9545291 9545291 20260321102008_eKlnn NZ006N 2026-03-22T12:09:03.731Z 2026-03-29T12:19:38.842Z
9545087 9545087 20260321100018_3RXEU NZ006N 2026-03-22T12:08:34.434Z 2026-03-29T12:19:36.862Z
9539933 9539933 20260319110448_JdKUn NZ006N 2026-03-21T12:25:18.989Z 2026-03-27T12:41:46.979Z
9539771 9539771 20260320164424_Eb1wh NZ006N 2026-03-21T12:20:10.993Z 2026-03-28T12:36:31.740Z
9539567 9539567 20260320151914_Qbnbm NZ006N 2026-03-21T12:19:45.084Z 2026-03-28T12:36:07.351Z
9539536 9539536 20260320151221_ZTM7S NZ006N 2026-03-21T12:19:41.613Z 2026-03-28T12:36:05.772Z
9539511 9539511 20260320150015_AyNfC NZ006N 2026-03-21T12:19:39.104Z 2026-03-28T12:36:04.334Z
9539501 9539501 20260320145941_sPnMO NZ006N 2026-03-21T12:19:38.122Z 2026-03-28T12:36:04.114Z
9539367 9539367 20260320143653_s180l NZ006N 2026-03-21T12:19:24.620Z 2026-03-28T12:35:59.876Z
9538878 9538878 20260320135331_0QSLd NZ006N 2026-03-21T12:18:32.415Z 2026-03-28T12:35:54.177Z
9538747 9538747 20260320134216_tIx6J NZ006N 2026-03-21T12:18:15.445Z 2026-03-28T12:35:52.034Z
9538371 9538371 20260320125413_SeXEc NZ006N 2026-03-21T12:17:34.936Z 2026-03-28T12:35:47.415Z
9538329 9538329 20260320125216_6nWbo NZ006N 2026-03-21T12:17:30.768Z 2026-03-28T12:35:46.982Z
9537609 9537609 20260320115002_aqVJD NZ006N 2026-03-21T12:16:05.680Z 2026-03-28T12:35:27.637Z
9536868 9536868 20260320103927_BliLB NZ006N 2026-03-21T12:14:34.087Z 2026-03-28T12:35:17.777Z
9536608 9536608 20260320101029_bgJDF NZ006N 2026-03-21T12:13:53.169Z 2026-03-28T12:35:04.522Z
9536517 9536517 20260320100103_loYne NZ006N 2026-03-21T12:13:40.379Z 2026-03-28T12:35:02.996Z
9536217 9536217 20260320092305_Peks0 NZ006N 2026-03-21T12:12:49.777Z 2026-03-28T12:34:58.614Z
9536209 9536209 20260320092243_2G2KO NZ006N 2026-03-21T12:12:48.865Z 2026-03-28T12:34:58.554Z
9536195 9536195 20260320092218_Sy2vp NZ006N 2026-03-21T12:12:47.378Z 2026-03-21T12:30:05.764Z
9528990 9528990 20260318170259_5roDu NZ006N 2026-03-20T12:22:40.546Z 2026-03-26T12:38:41.456Z
9528804 9528804 20260318164653_QFpUW NZ006N 2026-03-20T12:22:31.886Z 2026-03-26T12:38:38.238Z
9528498 9528498 20260318162014_2dG7d NZ006N 2026-03-20T12:22:20.035Z 2026-03-26T12:38:36.563Z
9528457 9528457 20260318161618_vlKp4 NZ006N 2026-03-20T12:22:17.428Z 2026-03-26T12:38:36.291Z
9528445 9528445 20260318161534_LnVPA NZ006N 2026-03-20T12:22:17.345Z 2026-03-26T12:38:36.238Z
9528330 9528330 20260318160733_MTe38 NZ006N 2026-03-20T12:22:12.920Z 2026-03-26T12:38:35.421Z
9527999 9527999 20260318153246_jkALo NZ006N 2026-03-20T12:21:51.937Z 2026-03-26T12:38:32.456Z
9527951 9527951 20260318153057_qxKfH NZ006N 2026-03-20T12:21:50.073Z 2026-03-26T12:38:32.252Z
9527902 9527902 20260318152351_Kucpp NZ006N 2026-03-20T12:21:47.365Z 2026-03-26T12:38:31.890Z
9527831 9527831 20260318151802_ZFxzP NZ006N 2026-03-20T12:21:45.710Z 2026-03-26T12:38:31.661Z
9527471 9527471 20260318144310_rA6B2 NZ006N 2026-03-20T12:21:18.671Z 2026-03-26T12:38:28.745Z
9527206 9527206 20260318141611_M59kW NZ006N 2026-03-20T12:21:04.949Z 2026-03-26T12:38:26.781Z
9526922 9526922 20260318133544_TBDpX NZ006N 2026-03-20T12:20:44.863Z 2026-03-26T12:38:24.618Z
9526755 9526755 20260319173841_xejPQ NZ006N 2026-03-20T12:15:35.162Z 2026-03-27T12:42:30.598Z
9526613 9526613 20260319170734_2aYFI NZ006N 2026-03-20T12:15:23.519Z 2026-03-27T12:42:28.447Z
9526574 9526574 20260319165901_7cy1t NZ006N 2026-03-20T12:15:21.160Z 2026-03-27T12:42:27.502Z
9526325 9526325 20260319162657_AjsRT NZ006N 2026-03-20T12:15:06.458Z 2026-03-27T12:42:25.142Z
9526314 9526314 20260319162516_LPYLt NZ006N 2026-03-20T12:15:05.769Z 2026-03-27T12:42:25.067Z
9526132 9526132 20260319160518_26Yzo NZ006N 2026-03-20T12:14:51.653Z 2026-03-27T12:42:23.412Z
9525906 9525906 20260319153222_NiC7b NZ006N 2026-03-20T12:14:40.565Z 2026-03-27T12:42:21.037Z
9525735 9525735 20260319151026_GEgqQ NZ006N 2026-03-20T12:14:28.141Z 2026-03-27T12:42:19.363Z
9525124 9525124 20260319132758_dinnZ NZ006N 2026-03-20T12:13:50.291Z 2026-03-27T12:41:59.978Z
9525118 9525118 20260319132616_1H3Mk NZ006N 2026-03-20T12:13:49.938Z 2026-03-27T12:41:59.826Z
9525013 9525013 20260319130908_PgrbJ NZ006N 2026-03-20T12:13:45.406Z 2026-03-27T12:41:58.968Z
9524913 9524913 20260319125418_S4ngQ NZ006N 2026-03-20T12:13:39.397Z 2026-03-27T12:41:58.158Z
9524625 9524625 20260319121838_BkDdK NZ006N 2026-03-20T12:13:16.537Z 2026-03-27T12:41:54.720Z

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