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

4,532 rows where station_code = "NZ003G" 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
9625760 9625760 20260408114436_59HbH NZ003G 2026-04-09T12:06:36.715Z 2026-04-09T12:06:36.715Z
9611854 9611854 20260402083532_aLcPL NZ003G 2026-04-06T12:21:42.632Z 2026-04-09T12:43:22.351Z
9605561 9605561 20260403104159_Mc0qI NZ003G 2026-04-04T12:02:54.556Z 2026-04-09T12:41:25.190Z
9605369 9605369 20260403091147_A2m9R NZ003G 2026-04-04T12:01:55.299Z 2026-04-09T12:41:20.836Z
9599860 9599860 20260331170943_i3kJ0 NZ003G 2026-04-01T12:05:05.506Z 2026-04-09T12:47:52.860Z
9597532 9597532 20260330163141_BaB5E NZ003G 2026-03-31T12:06:33.389Z 2026-04-08T12:43:45.472Z
9594019 9594019 20260329174907_lTWkU NZ003G 2026-03-30T12:05:51.148Z 2026-04-07T12:27:42.966Z
9593981 9593981 20260329172625_RN258 NZ003G 2026-03-30T12:05:42.874Z 2026-04-07T12:27:41.759Z
9590552 9590552 20260328100204_MDTBs NZ003G 2026-03-29T12:02:53.983Z 2026-04-06T12:38:23.773Z
9586641 9586641 20260327085041_1cWvc NZ003G 2026-03-28T12:03:37.722Z 2026-04-05T12:33:35.391Z
9568729 9568729 20260323171630_FV2Jr NZ003G 2026-03-24T12:15:38.393Z 2026-03-24T12:24:25.516Z
9568642 9568642 20260323170823_Pt6yQ NZ003G 2026-03-24T12:15:26.943Z 2026-03-31T12:28:39.564Z
9566615 9566615 20260323135717_X7W42 NZ003G 2026-03-24T12:12:12.725Z 2026-03-31T12:27:54.713Z
9566234 9566234 20260323131611_CB37r NZ003G 2026-03-24T12:11:28.772Z 2026-03-31T12:27:47.430Z
9566071 9566071 20260323130326_MpaaY NZ003G 2026-03-24T12:11:18.435Z 2026-03-31T12:27:45.732Z
9563221 9563221 20260323074329_RpMGF NZ003G 2026-03-24T12:05:32.069Z 2026-03-31T12:26:38.660Z
9559206 9559206 20260321164639_apQst NZ003G 2026-03-23T12:10:57.679Z 2026-03-29T12:20:35.248Z
9558405 9558405 20260322163254_FR3hR NZ003G 2026-03-23T12:06:42.089Z 2026-03-30T12:30:12.473Z
9557918 9557918 20260322151522_n2VXp NZ003G 2026-03-23T12:06:15.787Z 2026-03-30T12:29:51.653Z
9557868 9557868 20260322150817_4274l NZ003G 2026-03-23T12:06:13.480Z 2026-03-30T12:29:50.530Z
9557717 9557717 20260322144545_D9DHN NZ003G 2026-03-23T12:06:06.904Z 2026-03-30T12:29:46.065Z
9557704 9557704 20260322144316_NuyO5 NZ003G 2026-03-23T12:06:06.011Z 2026-03-30T12:29:45.502Z
9557568 9557568 20260322142559_kP58J NZ003G 2026-03-23T12:05:56.702Z 2026-03-30T12:29:42.059Z
9557470 9557470 20260322141101_iGwIc NZ003G 2026-03-23T12:05:51.653Z 2026-03-30T12:29:39.023Z
9556868 9556868 20260322120018_524FD NZ003G 2026-03-23T12:05:17.840Z 2026-03-30T12:29:13.344Z
9556748 9556748 20260322113120_lSRwz NZ003G 2026-03-23T12:05:10.659Z 2026-03-30T12:29:09.755Z
9556683 9556683 20260322112158_OBah3 NZ003G 2026-03-23T12:05:07.003Z 2026-03-30T12:29:08.249Z
9556647 9556647 20260322111549_2oVZp NZ003G 2026-03-23T12:05:04.613Z 2026-03-30T12:29:06.900Z
9556518 9556518 20260322105431_c3zgA NZ003G 2026-03-23T12:04:53.157Z 2026-03-30T12:29:03.362Z
9556423 9556423 20260322103101_yHMIg NZ003G 2026-03-23T12:04:47.004Z 2026-03-30T12:29:00.376Z
9555994 9555994 20260322090028_5zBST NZ003G 2026-03-23T12:04:14.245Z 2026-03-30T12:28:41.208Z
9555946 9555946 20260322084813_Au5Cc NZ003G 2026-03-23T12:04:11.104Z 2026-03-30T12:28:39.953Z
9550808 9550808 20260320171251_j1PQd NZ003G 2026-03-22T12:25:46.217Z 2026-03-28T12:36:36.174Z
9550774 9550774 20260320171055_nlpK7 NZ003G 2026-03-22T12:25:43.567Z 2026-03-28T12:36:35.961Z
9550753 9550753 20260320171004_NzuYd NZ003G 2026-03-22T12:25:42.129Z 2026-03-28T12:36:35.756Z
9550749 9550749 20260320171000_179UV NZ003G 2026-03-22T12:25:41.629Z 2026-03-28T12:36:35.676Z
9550503 9550503 20260320164430_H2G6x NZ003G 2026-03-22T12:25:26.995Z 2026-03-28T12:36:31.871Z
9549849 9549849 20260320154855_uyYqN NZ003G 2026-03-22T12:24:32.824Z 2026-03-28T12:36:22.487Z
9548423 9548423 20260321150410_Pv9EM NZ003G 2026-03-22T12:15:24.372Z 2026-03-29T12:20:26.300Z
9548120 9548120 20260321143520_gCyAB NZ003G 2026-03-22T12:14:55.139Z 2026-03-29T12:20:24.063Z
9547833 9547833 20260321140335_KiAei NZ003G 2026-03-22T12:14:22.869Z 2026-03-29T12:20:21.665Z
9546950 9546950 20260321124311_p0y3R NZ003G 2026-03-22T12:12:42.521Z 2026-03-29T12:20:05.515Z
9546399 9546399 20260321115713_RZ1IQ NZ003G 2026-03-22T12:11:39.331Z 2026-03-29T12:20:00.704Z
9546332 9546332 20260321115353_AvDJl NZ003G 2026-03-22T12:11:30.815Z 2026-03-22T12:27:38.230Z
9546193 9546193 20260321114253_fkdhT NZ003G 2026-03-22T12:11:14.556Z 2026-03-22T12:27:38.203Z
9545902 9545902 20260321111943_hNEo2 NZ003G 2026-03-22T12:10:36.077Z 2026-03-22T12:27:38.140Z
9544566 9544566 20260321085448_EgTZV NZ003G 2026-03-22T12:07:10.416Z 2026-03-29T12:19:31.159Z
9544471 9544471 20260321084311_mTiO5 NZ003G 2026-03-22T12:06:55.167Z 2026-03-29T12:19:30.181Z
9544409 9544409 20260321083019_EVkD9 NZ003G 2026-03-22T12:06:41.951Z 2026-03-29T12:19:29.404Z
9544336 9544336 20260321082011_r8RHd NZ003G 2026-03-22T12:06:30.286Z 2026-03-29T12:19:28.505Z
9539371 9539371 20260320143712_JHe3x NZ003G 2026-03-21T12:19:24.880Z 2026-03-28T12:35:59.900Z
9538673 9538673 20260320133411_thfhM NZ003G 2026-03-21T12:18:08.860Z 2026-03-28T12:35:51.613Z
9538517 9538517 20260320131533_lL2YK NZ003G 2026-03-21T12:17:53.437Z 2026-03-28T12:35:49.354Z
9538113 9538113 20260320123605_mdT9G NZ003G 2026-03-21T12:17:07.043Z 2026-03-21T12:30:06.377Z
9536439 9536439 20260320095126_r2Ire NZ003G 2026-03-21T12:13:28.409Z 2026-03-21T12:30:05.843Z
9536330 9536330 20260320093440_QLtBI NZ003G 2026-03-21T12:13:07.210Z 2026-03-21T12:30:05.805Z
9535747 9535747 20260320082928_DDVto NZ003G 2026-03-21T12:11:45.652Z 2026-03-28T12:34:50.414Z
9529246 9529246 20260318173208_w2PTi NZ003G 2026-03-20T12:22:59.695Z 2026-03-26T12:38:52.138Z
9528739 9528739 20260318164140_dvOpR NZ003G 2026-03-20T12:22:29.399Z 2026-03-26T12:38:37.884Z
9528496 9528496 20260318162014_2dG7d NZ003G 2026-03-20T12:22:20.034Z 2026-03-26T12:38:36.563Z
9528185 9528185 20260318154811_F3Eq2 NZ003G 2026-03-20T12:21:58.912Z 2026-03-26T12:38:34.369Z
9527976 9527976 20260318153222_F8i3a NZ003G 2026-03-20T12:21:51.437Z 2026-03-26T12:38:32.448Z
9527950 9527950 20260318153057_qxKfH NZ003G 2026-03-20T12:21:50.073Z 2026-03-26T12:38:32.252Z
9527632 9527632 20260318150315_622WK NZ003G 2026-03-20T12:21:35.517Z 2026-03-26T12:38:30.160Z
9527186 9527186 20260318141340_33PEV NZ003G 2026-03-20T12:21:04.197Z 2026-03-26T12:38:26.683Z
9525862 9525862 20260319152657_1gFWv NZ003G 2026-03-20T12:14:38.978Z 2026-03-27T12:42:20.709Z
9525764 9525764 20260319151457_CQwN5 NZ003G 2026-03-20T12:14:31.423Z 2026-03-27T12:42:19.580Z
9525757 9525757 20260319151426_UYsxH NZ003G 2026-03-20T12:14:29.222Z 2026-03-27T12:42:19.540Z
9525732 9525732 20260319151026_GEgqQ NZ003G 2026-03-20T12:14:28.141Z 2026-03-27T12:42:19.363Z
9525534 9525534 20260319144949_s11aQ NZ003G 2026-03-20T12:14:18.500Z 2026-03-27T12:42:04.858Z
9525462 9525462 20260319143607_D0M2u NZ003G 2026-03-20T12:14:14.677Z 2026-03-27T12:42:03.943Z
9525436 9525436 20260319143141_E5Y7E NZ003G 2026-03-20T12:14:13.450Z 2026-03-27T12:42:03.737Z
9525429 9525429 20260319143110_Gib4s NZ003G 2026-03-20T12:14:12.889Z 2026-03-27T12:42:03.687Z
9525397 9525397 20260319142404_uItna NZ003G 2026-03-20T12:14:11.586Z 2026-03-27T12:42:03.428Z
9525297 9525297 20260319140650_N5H8m NZ003G 2026-03-20T12:14:06.895Z 2026-03-27T12:42:02.512Z
9525217 9525217 20260319135040_kLnx2 NZ003G 2026-03-20T12:13:58.656Z 2026-03-27T12:42:01.893Z
9525157 9525157 20260319133656_Ka4pG NZ003G 2026-03-20T12:13:52.790Z 2026-03-27T12:42:01.059Z
9525153 9525153 20260319133448_4t4TE NZ003G 2026-03-20T12:13:52.521Z 2026-03-27T12:42:01.004Z
9525050 9525050 20260319131352_nNXK4 NZ003G 2026-03-20T12:13:47.362Z 2026-03-27T12:41:59.350Z
9525011 9525011 20260319130908_PgrbJ NZ003G 2026-03-20T12:13:45.406Z 2026-03-27T12:41:58.968Z
9524898 9524898 20260319125236_PebuL NZ003G 2026-03-20T12:13:38.849Z 2026-03-27T12:41:58.097Z
9524879 9524879 20260319124713_FDKXo NZ003G 2026-03-20T12:13:37.398Z 2026-03-27T12:41:57.874Z
9524594 9524594 20260319121604_ed0Pv NZ003G 2026-03-20T12:13:11.380Z 2026-03-27T12:41:54.501Z
9524495 9524495 20260319120335_IIM8Z NZ003G 2026-03-20T12:13:03.665Z 2026-03-27T12:41:53.430Z
9524471 9524471 20260319120011_2MZMZ NZ003G 2026-03-20T12:13:02.544Z 2026-03-27T12:41:53.186Z
9524360 9524360 20260319114740_8ZXND NZ003G 2026-03-20T12:12:53.972Z 2026-03-27T12:41:51.828Z
9523070 9523070 20260319092414_iMZgT NZ003G 2026-03-20T12:10:50.087Z 2026-03-27T12:41:24.775Z
9522764 9522764 20260319085142_u3oxI NZ003G 2026-03-20T12:10:19.041Z 2026-03-27T12:41:21.428Z
9522721 9522721 20260319084405_zFxzu NZ003G 2026-03-20T12:10:16.052Z 2026-03-27T12:41:21.081Z
9515248 9515248 20260318130828_Ges53 NZ003G 2026-03-19T12:19:26.249Z 2026-03-26T12:38:22.999Z
9515239 9515239 20260318130819_qU5c2 NZ003G 2026-03-19T12:19:24.685Z 2026-03-26T12:38:22.917Z
9515222 9515222 20260318130656_3UguZ NZ003G 2026-03-19T12:19:23.237Z 2026-03-26T12:38:22.775Z
9515147 9515147 20260318125124_0w6IB NZ003G 2026-03-19T12:19:11.589Z 2026-03-19T12:27:30.879Z
9515061 9515061 20260318123512_1SPgt NZ003G 2026-03-19T12:18:57.752Z 2026-03-26T12:38:21.578Z
9515029 9515029 20260318123200_FAS6O NZ003G 2026-03-19T12:18:53.924Z 2026-03-26T12:38:21.249Z
9514721 9514721 20260318115939_F2sM5 NZ003G 2026-03-19T12:18:13.136Z 2026-03-26T12:38:18.874Z
9514671 9514671 20260318114907_rXc0J NZ003G 2026-03-19T12:18:06.187Z 2026-03-19T12:27:30.783Z
9514664 9514664 20260318114851_e2ssH NZ003G 2026-03-19T12:18:05.215Z 2026-03-26T12:38:18.151Z
9514469 9514469 20260318112959_tj82A NZ003G 2026-03-19T12:17:35.572Z 2026-03-26T12:38:16.648Z
9514000 9514000 20260318103326_8dC60 NZ003G 2026-03-19T12:16:38.723Z 2026-03-26T12:38:13.278Z

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