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 = "NZ003H" 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
9611878 9611878 20260331112542_EWH5o NZ003H 2026-04-06T12:27:23.942Z 2026-04-09T12:46:40.866Z
9610251 9610251 20260405152328_2gILD NZ003H 2026-04-06T12:06:42.128Z 2026-04-09T12:36:41.550Z
9610240 9610240 20260405151543_JmnMl NZ003H 2026-04-06T12:06:34.142Z 2026-04-09T12:36:41.203Z
9607439 9607439 20260404091506_Tz2Yu NZ003H 2026-04-05T12:02:18.052Z 2026-04-09T12:39:22.345Z
9605161 9605161 20260403072154_kMxrY NZ003H 2026-04-04T12:00:57.519Z 2026-04-09T12:41:15.854Z
9603711 9603711 20260402115729_g2jtr NZ003H 2026-04-03T12:04:16.959Z 2026-04-09T12:44:07.415Z
9603569 9603569 20260402110413_9qfHO NZ003H 2026-04-03T12:03:40.985Z 2026-04-09T12:44:04.140Z
9603510 9603510 20260402104540_I6Qi2 NZ003H 2026-04-03T12:03:18.391Z 2026-04-09T12:43:57.826Z
9603473 9603473 20260402103120_UgtO5 NZ003H 2026-04-03T12:03:10.699Z 2026-04-09T12:43:50.318Z
9603434 9603434 20260402101817_1PacD NZ003H 2026-04-03T12:03:04.422Z 2026-04-09T12:43:43.902Z
9603399 9603399 20260402100002_9ICjl NZ003H 2026-04-03T12:02:49.374Z 2026-04-09T12:43:33.979Z
9603380 9603380 20260402094633_n9D3G NZ003H 2026-04-03T12:02:44.839Z 2026-04-09T12:43:30.818Z
9603196 9603196 20260402084145_iL5SL NZ003H 2026-04-03T12:02:06.955Z 2026-04-09T12:43:22.837Z
9602201 9602201 20260331073944_1tfFu NZ003H 2026-04-02T12:05:44.725Z 2026-04-09T12:46:36.365Z
9600949 9600949 20260401092501_cfslz NZ003H 2026-04-02T12:01:03.578Z 2026-04-09T12:45:20.611Z
9600238 9600238 20260330160909_E6T3V NZ003H 2026-04-01T12:09:12.510Z 2026-04-08T12:43:41.171Z
9600231 9600231 20260330152252_xa1s3 NZ003H 2026-04-01T12:08:57.328Z 2026-04-08T12:43:33.654Z
9599810 9599810 20260331165905_NnPSn NZ003H 2026-04-01T12:04:55.851Z 2026-04-09T12:47:33.021Z
9599243 9599243 20260331131041_3mqBU NZ003H 2026-04-01T12:02:52.333Z 2026-04-09T12:46:44.591Z
9599121 9599121 20260331115152_PFDSF NZ003H 2026-04-01T12:02:26.956Z 2026-04-09T12:46:41.941Z
9599091 9599091 20260331113446_QF4RP NZ003H 2026-04-01T12:02:20.179Z 2026-04-09T12:46:41.336Z
9599066 9599066 20260331112302_sLnI5 NZ003H 2026-04-01T12:02:14.521Z 2026-04-09T12:46:40.744Z
9599061 9599061 20260331112056_JYIyp NZ003H 2026-04-01T12:02:13.890Z 2026-04-09T12:46:40.726Z
9599020 9599020 20260331104656_wuMzR NZ003H 2026-04-01T12:02:04.211Z 2026-04-09T12:46:40.008Z
9598997 9598997 20260331102919_sgaNw NZ003H 2026-04-01T12:01:58.626Z 2026-04-09T12:46:39.581Z
9598976 9598976 20260331101038_3mpVM NZ003H 2026-04-01T12:01:51.689Z 2026-04-09T12:46:39.236Z
9598949 9598949 20260331093132_sS34h NZ003H 2026-04-01T12:01:42.439Z 2026-04-09T12:46:38.674Z
9598860 9598860 20260331080102_dEHm0 NZ003H 2026-04-01T12:01:20.277Z 2026-04-09T12:46:36.873Z
9598852 9598852 20260331080102_cqQB7 NZ003H 2026-04-01T12:01:19.285Z 2026-04-09T12:46:36.847Z
9598833 9598833 20260331074549_r23AP NZ003H 2026-04-01T12:01:15.001Z 2026-04-09T12:46:36.600Z
9598023 9598023 20260330173233_ZFErl NZ003H 2026-03-31T12:07:28.041Z 2026-04-08T12:44:23.628Z
9598010 9598010 20260330173029_GXFvh NZ003H 2026-03-31T12:07:26.765Z 2026-04-08T12:44:23.237Z
9598002 9598002 20260330172806_Ni2IW NZ003H 2026-03-31T12:07:25.491Z 2026-04-08T12:44:22.796Z
9597959 9597959 20260330172310_4R8w5 NZ003H 2026-03-31T12:07:21.306Z 2026-04-08T12:44:21.621Z
9597872 9597872 20260330171156_3cq63 NZ003H 2026-03-31T12:07:09.889Z 2026-04-08T12:44:19.559Z
9597852 9597852 20260330170852_Dc8Oh NZ003H 2026-03-31T12:07:07.036Z 2026-04-08T12:44:18.836Z
9597806 9597806 20260330170038_CI2P8 NZ003H 2026-03-31T12:07:02.225Z 2026-04-08T12:44:17.907Z
9597787 9597787 20260330165952_giNR5 NZ003H 2026-03-31T12:07:00.415Z 2026-04-08T12:44:17.465Z
9597761 9597761 20260330165658_XrCpV NZ003H 2026-03-31T12:06:58.458Z 2026-04-08T12:44:16.729Z
9597533 9597533 20260330163141_BaB5E NZ003H 2026-03-31T12:06:33.404Z 2026-04-08T12:43:45.472Z
9597418 9597418 20260330161552_LQQX9 NZ003H 2026-03-31T12:06:21.888Z 2026-04-08T12:43:42.596Z
9597414 9597414 20260330161545_gBCaK NZ003H 2026-03-31T12:06:21.514Z 2026-04-08T12:43:42.534Z
9597326 9597326 20260330160358_eU3Ia NZ003H 2026-03-31T12:06:09.455Z 2026-04-08T12:43:40.445Z
9597212 9597212 20260330153458_qSkTd NZ003H 2026-03-31T12:05:55.299Z 2026-04-08T12:43:35.741Z
9597035 9597035 20260330150311_y8r71 NZ003H 2026-03-31T12:05:32.292Z 2026-04-08T12:43:31.149Z
9596268 9596268 20260330120023_MuZMh NZ003H 2026-03-31T12:03:54.103Z 2026-04-08T12:42:47.975Z
9596169 9596169 20260330113027_QCYwi NZ003H 2026-03-31T12:03:37.856Z 2026-04-08T12:42:42.928Z
9596106 9596106 20260330111145_TCiE5 NZ003H 2026-03-31T12:03:29.077Z 2026-04-08T12:42:41.527Z
9595976 9595976 20260330102227_TqAfI NZ003H 2026-03-31T12:03:02.488Z 2026-04-08T12:42:37.728Z
9595785 9595785 20260330083847_o34Sd NZ003H 2026-03-31T12:02:29.955Z 2026-04-08T12:42:32.206Z
9590446 9590446 20260328091340_sZcFP NZ003H 2026-03-29T12:02:40.880Z 2026-04-06T12:38:10.074Z
9590346 9590346 20260328082112_Sx2m2 NZ003H 2026-03-29T12:02:27.303Z 2026-04-06T12:38:02.297Z
9590322 9590322 20260328081431_Ko3BZ NZ003H 2026-03-29T12:02:25.010Z 2026-04-06T12:38:01.212Z
9590196 9590196 20260328073026_6BlhM NZ003H 2026-03-29T12:02:12.406Z 2026-04-06T12:37:55.933Z
9590169 9590169 20260328071856_9mgIK NZ003H 2026-03-29T12:02:08.687Z 2026-04-06T12:37:54.510Z
9568620 9568620 20260323170441_bX7mX NZ003H 2026-03-24T12:15:24.340Z 2026-03-31T12:28:38.887Z
9568617 9568617 20260323170351_82VcR NZ003H 2026-03-24T12:15:23.223Z 2026-03-31T12:28:38.858Z
9568524 9568524 20260323165211_SHLWS NZ003H 2026-03-24T12:15:14.228Z 2026-03-31T12:28:30.315Z
9568398 9568398 20260323164041_KNJyb NZ003H 2026-03-24T12:15:03.462Z 2026-03-24T12:24:25.450Z
9568386 9568386 20260323163935_0tPTl NZ003H 2026-03-24T12:15:02.842Z 2026-03-24T12:24:25.448Z
9568163 9568163 20260323161658_isVAQ NZ003H 2026-03-24T12:14:39.211Z 2026-03-31T12:28:23.906Z
9568119 9568119 20260323161527_vZGtV NZ003H 2026-03-24T12:14:35.862Z 2026-03-31T12:28:23.265Z
9568072 9568072 20260323161103_kHJ1J NZ003H 2026-03-24T12:14:28.844Z 2026-03-31T12:28:22.554Z
9567939 9567939 20260323160130_6r49S NZ003H 2026-03-24T12:14:18.850Z 2026-03-31T12:28:20.891Z
9567911 9567911 20260323155919_TRZFk NZ003H 2026-03-24T12:14:17.254Z 2026-03-31T12:28:20.458Z
9567720 9567720 20260323154311_TjbPh NZ003H 2026-03-24T12:14:00.941Z 2026-03-31T12:28:17.847Z
9567574 9567574 20260323153153_FCalj NZ003H 2026-03-24T12:13:48.108Z 2026-03-31T12:28:15.971Z
9567462 9567462 20260323151707_QpXFp NZ003H 2026-03-24T12:13:38.752Z 2026-03-31T12:28:14.317Z
9567414 9567414 20260323151410_ywyYW NZ003H 2026-03-24T12:13:32.014Z 2026-03-24T12:24:25.275Z
9567397 9567397 20260323151326_RVplk NZ003H 2026-03-24T12:13:31.015Z 2026-03-31T12:28:13.684Z
9567366 9567366 20260323151010_GeUQM NZ003H 2026-03-24T12:13:28.114Z 2026-03-24T12:24:25.266Z
9567154 9567154 20260323144626_r18GB NZ003H 2026-03-24T12:13:08.074Z 2026-03-31T12:28:09.370Z
9567143 9567143 20260323144547_CSbYN NZ003H 2026-03-24T12:13:06.093Z 2026-03-31T12:28:09.012Z
9566165 9566165 20260323131019_8DGoe NZ003H 2026-03-24T12:11:24.894Z 2026-03-31T12:27:46.814Z
9566106 9566106 20260323130421_90iw1 NZ003H 2026-03-24T12:11:20.914Z 2026-03-31T12:27:46.102Z
9565975 9565975 20260323125545_DsIcZ NZ003H 2026-03-24T12:11:07.582Z 2026-03-31T12:27:44.292Z
9564069 9564069 20260323095648_xFaMq NZ003H 2026-03-24T12:07:22.165Z 2026-03-31T12:27:01.945Z
9564006 9564006 20260323094839_nrPRW NZ003H 2026-03-24T12:07:10.701Z 2026-03-31T12:27:00.729Z
9563338 9563338 20260323080124_LKdh2 NZ003H 2026-03-24T12:05:46.647Z 2026-03-31T12:26:41.075Z
9563247 9563247 20260323074635_98M1Y NZ003H 2026-03-24T12:05:35.886Z 2026-03-31T12:26:39.212Z
9563226 9563226 20260323074405_Q3bnU NZ003H 2026-03-24T12:05:33.143Z 2026-03-31T12:26:38.817Z
9563177 9563177 20260323073013_Pliw0 NZ003H 2026-03-24T12:05:22.612Z 2026-03-31T12:26:37.518Z
9550497 9550497 20260320164424_kvczd NZ003H 2026-03-22T12:25:26.551Z 2026-03-28T12:36:31.754Z
9550422 9550422 20260320163724_SUU35 NZ003H 2026-03-22T12:25:14.241Z 2026-03-28T12:36:30.569Z
9550383 9550383 20260320163418_R9a6Q NZ003H 2026-03-22T12:25:12.344Z 2026-03-28T12:36:30.129Z
9550154 9550154 20260320161306_yMtgz NZ003H 2026-03-22T12:24:58.316Z 2026-03-28T12:36:27.703Z
9550085 9550085 20260320160708_6QJRl NZ003H 2026-03-22T12:24:54.632Z 2026-03-28T12:36:27.007Z
9550065 9550065 20260320160525_eoRk2 NZ003H 2026-03-22T12:24:53.561Z 2026-03-28T12:36:26.830Z
9549978 9549978 20260320155822_NQyjL NZ003H 2026-03-22T12:24:41.346Z 2026-03-28T12:36:25.306Z
9549865 9549865 20260320154915_tv3K0 NZ003H 2026-03-22T12:24:33.274Z 2026-03-28T12:36:22.790Z
9549848 9549848 20260320154825_GKqee NZ003H 2026-03-22T12:24:32.592Z 2026-03-28T12:36:22.427Z
9549750 9549750 20260320153351_HMc6m NZ003H 2026-03-22T12:24:26.369Z 2026-03-28T12:36:18.898Z
9549716 9549716 20260320152954_4V9Qb NZ003H 2026-03-22T12:24:24.273Z 2026-03-28T12:36:16.160Z
9549702 9549702 20260320152826_UNDhg NZ003H 2026-03-22T12:24:23.562Z 2026-03-28T12:36:14.541Z
9549456 9549456 20260320150013_QHcxi NZ003H 2026-03-22T12:24:00.876Z 2026-03-28T12:36:04.322Z
9549448 9549448 20260320145949_6rlAi NZ003H 2026-03-22T12:24:00.472Z 2026-03-28T12:36:04.154Z
9549303 9549303 20260320144712_uuszt NZ003H 2026-03-22T12:23:51.476Z 2026-03-28T12:36:01.387Z
9548045 9548045 20260321142735_0iIkr NZ003H 2026-03-22T12:14:48.039Z 2026-03-29T12:20:23.672Z
9545842 9545842 20260321111242_2vT4A NZ003H 2026-03-22T12:10:23.079Z 2026-03-29T12:19:44.944Z
9545794 9545794 20260321110706_y1edT NZ003H 2026-03-22T12:10:16.879Z 2026-03-29T12:19:44.407Z

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