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 = "NZ004D" 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
8672456 8672456 20251201143219_yPtOI NZ004D 2025-12-03T14:15:36.277Z 2025-12-06T14:31:57.701Z
8672423 8672423 20251201142708_laBfj NZ004D 2025-12-03T14:15:33.845Z 2025-12-06T14:31:55.946Z
8672356 8672356 20251201142003_Gbtz3 NZ004D 2025-12-03T14:15:20.375Z 2025-12-06T14:31:52.814Z
8642132 8642132 20251128153429_c6Wly NZ004D 2025-11-30T14:17:36.320Z 2025-12-06T14:53:19.103Z
8642004 8642004 20251128152452_mYETh NZ004D 2025-11-30T14:17:14.368Z 2025-12-06T14:53:12.572Z
8641769 8641769 20251128151234_3GxTL NZ004D 2025-11-30T14:16:58.920Z 2025-12-06T14:52:49.635Z
8641754 8641754 20251128151135_Nhs2L NZ004D 2025-11-30T14:16:48.128Z 2025-12-06T14:52:49.231Z
8641733 8641733 20251128151033_sMaK7 NZ004D 2025-11-30T14:16:45.303Z 2025-12-06T14:52:47.221Z
8628995 8628995 20251128133224_jKWBv NZ004D 2025-11-29T14:07:39.942Z 2025-12-06T14:52:21.209Z
8628830 8628830 20251128131218_oC1Nc NZ004D 2025-11-29T14:07:12.142Z 2025-11-29T14:07:12.142Z
8627916 8627916 20251128115150_GjmrN NZ004D 2025-11-29T14:04:54.055Z 2025-12-06T14:51:27.649Z
8627524 8627524 20251128110959_efqu2 NZ004D 2025-11-29T14:03:53.547Z 2025-12-06T14:51:19.679Z
8627361 8627361 20251128105324_7a84U NZ004D 2025-11-29T14:03:25.150Z 2025-12-06T14:51:16.939Z
8626719 8626719 20251128092718_35fY4 NZ004D 2025-11-29T14:01:18.874Z 2025-12-06T14:50:41.342Z
8626644 8626644 20251128091458_IZMQl NZ004D 2025-11-29T14:01:05.770Z 2025-12-06T14:50:39.593Z
8620999 8620999 20251126141247_N4UON NZ004D 2025-11-28T14:14:30.711Z 2025-12-05T15:02:39.563Z
8619598 8619598 20251126103123_BgZ65 NZ004D 2025-11-28T14:09:40.205Z 2025-12-05T15:01:02.586Z
8619538 8619538 20251126102447_87sBt NZ004D 2025-11-28T14:09:20.134Z 2025-12-05T15:01:01.124Z
8619252 8619252 20251126093715_6tCtp NZ004D 2025-11-28T14:08:07.327Z 2025-12-05T15:00:54.590Z
8619144 8619144 20251126091809_el340 NZ004D 2025-11-28T14:07:36.810Z 2025-12-05T15:00:50.469Z
8618021 8618021 20251127111510_uwf82 NZ004D 2025-11-28T14:03:10.800Z 2025-12-06T14:58:28.611Z
8617917 8617917 20251127105330_gYSnn NZ004D 2025-11-28T14:02:47.861Z 2025-12-06T14:58:26.715Z
8617733 8617733 20251127102633_xwxRk NZ004D 2025-11-28T14:02:08.395Z 2025-12-06T14:58:20.907Z
8617721 8617721 20251127102140_6Xo3g NZ004D 2025-11-28T14:02:05.777Z 2025-12-06T14:58:20.202Z
8617705 8617705 20251127101903_a0L33 NZ004D 2025-11-28T14:02:01.916Z 2025-12-06T14:58:19.822Z
8617559 8617559 20251127095152_plZqI NZ004D 2025-11-28T14:01:18.302Z 2025-12-06T14:58:11.570Z
8617545 8617545 20251127095016_2exze NZ004D 2025-11-28T14:01:14.148Z 2025-12-06T14:58:10.813Z
8617477 8617477 20251127094049_dgwbb NZ004D 2025-11-28T14:00:57.215Z 2025-12-06T14:58:07.311Z
8604675 8604675 20251120092141_iGxwg NZ004D 2025-11-26T15:02:38.444Z 2025-11-28T14:58:48.993Z
8562061 8562061 20251121133104_KEo52 NZ004D 2025-11-23T14:04:28.400Z 2025-11-30T15:03:22.672Z
8562056 8562056 20251121133023_Ub3sY NZ004D 2025-11-23T14:04:28.018Z 2025-11-30T15:03:22.654Z
8561966 8561966 20251121131757_qmf73 NZ004D 2025-11-23T14:04:14.758Z 2025-11-30T15:03:18.924Z
8561902 8561902 20251121131209_rsF9J NZ004D 2025-11-23T14:04:04.557Z 2025-11-30T15:03:14.132Z
8561593 8561593 20251121123148_GnTQT NZ004D 2025-11-23T14:03:08.641Z 2025-11-30T15:03:03.709Z
8561589 8561589 20251121123133_L5GPH NZ004D 2025-11-23T14:03:08.044Z 2025-11-30T15:03:03.509Z
8561580 8561580 20251121123026_YuMa0 NZ004D 2025-11-23T14:03:07.065Z 2025-11-30T15:03:03.097Z
8561421 8561421 20251121121337_6JIuX NZ004D 2025-11-23T14:02:40.919Z 2025-11-30T15:02:57.104Z
8561259 8561259 20251121115538_2u7Ut NZ004D 2025-11-23T14:02:12.689Z 2025-11-30T15:02:52.464Z
8560851 8560851 20251121111007_pG05b NZ004D 2025-11-23T14:01:07.076Z 2025-11-30T15:02:40.433Z
8554624 8554624 20251120102441_bSmin NZ004D 2025-11-22T14:35:38.272Z 2025-11-28T14:58:54.989Z
8554594 8554594 20251120101625_lFKOZ NZ004D 2025-11-22T14:35:36.235Z 2025-11-28T14:58:53.616Z
8554537 8554537 20251120100312_SdPR4 NZ004D 2025-11-22T14:35:32.668Z 2025-11-28T14:58:52.789Z
8554513 8554513 20251120100109_xdYlM NZ004D 2025-11-22T14:35:31.684Z 2025-11-28T14:58:52.315Z
8554289 8554289 20251120091936_sFJXc NZ004D 2025-11-22T14:34:59.183Z 2025-11-28T14:58:48.858Z
8544772 8544772 20251120153140_5tv0v NZ004D 2025-11-22T14:08:50.004Z 2025-11-29T14:53:51.297Z
8544733 8544733 20251120152951_L8Klq NZ004D 2025-11-22T14:08:45.817Z 2025-11-29T14:53:51.005Z
8544617 8544617 20251120152404_LqOR5 NZ004D 2025-11-22T14:08:29.750Z 2025-11-29T14:53:48.361Z
8544515 8544515 20251120151600_FIal6 NZ004D 2025-11-22T14:08:06.893Z 2025-11-29T14:53:46.957Z
8544512 8544512 20251120151600_F0PWA NZ004D 2025-11-22T14:08:06.482Z 2025-11-29T14:53:46.953Z
8544491 8544491 20251120151517_aOyqR NZ004D 2025-11-22T14:08:03.850Z 2025-11-29T14:53:46.926Z
8544195 8544195 20251120145718_1IlkB NZ004D 2025-11-22T14:07:13.248Z 2025-11-29T14:53:41.969Z
8544055 8544055 20251120144437_BwMwE NZ004D 2025-11-22T14:06:51.476Z 2025-11-29T14:53:36.771Z
8543995 8543995 20251120144058_2idhb NZ004D 2025-11-22T14:06:45.035Z 2025-11-29T14:53:36.073Z
8543931 8543931 20251120143456_j5swC NZ004D 2025-11-22T14:06:29.161Z 2025-11-29T14:53:31.924Z
8543825 8543825 20251120142804_trjk2 NZ004D 2025-11-22T14:06:15.677Z 2025-11-29T14:53:30.945Z
8543724 8543724 20251120141837_3EGWP NZ004D 2025-11-22T14:05:55.006Z 2025-11-29T14:53:28.923Z
8543054 8543054 20251120132226_FxwlO NZ004D 2025-11-22T14:03:57.207Z 2025-11-29T14:53:17.745Z
8543038 8543038 20251120132129_gV7UX NZ004D 2025-11-22T14:03:55.362Z 2025-11-29T14:53:17.657Z
8542617 8542617 20251120123319_Ceze2 NZ004D 2025-11-22T14:02:40.207Z 2025-11-29T14:53:13.473Z
8542594 8542594 20251120122939_sTF1h NZ004D 2025-11-22T14:02:37.965Z 2025-11-29T14:53:13.418Z
8542555 8542555 20251120122533_Y5CDP NZ004D 2025-11-22T14:02:29.853Z 2025-11-29T14:53:12.806Z
8542491 8542491 20251120122017_wIID6 NZ004D 2025-11-22T14:02:19.478Z 2025-11-29T14:53:12.447Z
8542446 8542446 20251120121522_s0sIq NZ004D 2025-11-22T14:02:12.750Z 2025-11-29T14:53:12.076Z
8542221 8542221 20251120114634_FWCIp NZ004D 2025-11-22T14:01:34.781Z 2025-11-29T14:53:08.319Z
8542161 8542161 20251120114015_Et3qZ NZ004D 2025-11-22T14:01:24.142Z 2025-11-29T14:53:06.687Z
8542145 8542145 20251120113846_2exKm NZ004D 2025-11-22T14:01:21.807Z 2025-11-29T14:53:06.438Z
8541756 8541756 20251120104231_FUn9s NZ004D 2025-11-22T14:00:19.918Z 2025-11-29T14:52:52.703Z
8532235 8532235 20251119154747_Y05aF NZ004D 2025-11-21T14:07:35.779Z 2025-11-28T14:53:54.987Z
8501231 8501231 20251116103826_XRZUj NZ004D 2025-11-18T14:47:17.701Z 2025-11-24T15:06:26.610Z
8501129 8501129 20251116102714_J3TJy NZ004D 2025-11-18T14:47:13.993Z 2025-11-24T15:06:22.197Z
8501035 8501035 20251116101415_EmzoJ NZ004D 2025-11-18T14:47:11.223Z 2025-11-24T15:06:10.408Z
8500853 8500853 20251116095435_TLqK2 NZ004D 2025-11-18T14:46:40.753Z 2025-11-24T15:06:01.721Z
8500825 8500825 20251116095001_03Y7q NZ004D 2025-11-18T14:46:39.625Z 2025-11-24T15:06:00.883Z
8500709 8500709 20251116093618_HLOp9 NZ004D 2025-11-18T14:46:29.577Z 2025-11-24T15:05:55.837Z
8489237 8489237 20251116154222_KoPaC NZ004D 2025-11-18T14:09:14.849Z 2025-11-25T15:07:21.819Z
8489190 8489190 20251116153740_REes6 NZ004D 2025-11-18T14:09:08.300Z 2025-11-25T15:07:14.168Z
8489105 8489105 20251116152920_wVrAi NZ004D 2025-11-18T14:08:41.304Z 2025-11-25T15:07:08.141Z
8488947 8488947 20251116151315_Nlngh NZ004D 2025-11-18T14:08:06.492Z 2025-11-25T15:07:00.144Z
8488930 8488930 20251116151211_hShaO NZ004D 2025-11-18T14:08:03.653Z 2025-11-25T15:06:59.939Z
8488870 8488870 20251116150604_4z6oB NZ004D 2025-11-18T14:07:53.334Z 2025-11-25T15:06:58.200Z
8488798 8488798 20251116150050_d7vPe NZ004D 2025-11-18T14:07:36.123Z 2025-11-25T15:06:54.897Z
8488786 8488786 20251116150029_4EJxS NZ004D 2025-11-18T14:07:33.088Z 2025-11-25T15:06:53.574Z
8488759 8488759 20251116145807_12LIe NZ004D 2025-11-18T14:07:27.465Z 2025-11-25T15:06:53.385Z
8488641 8488641 20251116144804_eIr9E NZ004D 2025-11-18T14:07:12.281Z 2025-11-25T15:06:51.885Z
8488613 8488613 20251116144353_tesms NZ004D 2025-11-18T14:07:09.790Z 2025-11-25T15:06:51.425Z
8488594 8488594 20251116144307_doRAN NZ004D 2025-11-18T14:07:02.557Z 2025-11-25T15:06:51.285Z
8488551 8488551 20251116143933_q80qy NZ004D 2025-11-18T14:06:51.495Z 2025-11-25T15:06:50.685Z
8488459 8488459 20251116142634_fWNex NZ004D 2025-11-18T14:06:33.528Z 2025-11-25T15:06:47.916Z
8488424 8488424 20251116142504_SAfTL NZ004D 2025-11-18T14:06:27.978Z 2025-11-25T15:06:47.588Z
8488344 8488344 20251116141834_wLrEe NZ004D 2025-11-18T14:06:11.225Z 2025-11-25T15:06:46.590Z
8488182 8488182 20251116140432_iDz5b NZ004D 2025-11-18T14:05:40.721Z 2025-11-25T15:06:41.544Z
8488151 8488151 20251116140002_OKrxr NZ004D 2025-11-18T14:05:31.964Z 2025-11-25T15:06:41.150Z
8488143 8488143 20251116135906_T2LXD NZ004D 2025-11-18T14:05:30.746Z 2025-11-25T15:06:41.036Z
8487776 8487776 20251116132823_iYDTy NZ004D 2025-11-18T14:04:21.291Z 2025-11-25T15:06:25.829Z
8487752 8487752 20251116132714_31p5G NZ004D 2025-11-18T14:04:15.370Z 2025-11-25T15:06:25.681Z
8487685 8487685 20251116131914_64dNL NZ004D 2025-11-18T14:04:06.927Z 2025-11-25T15:06:24.803Z
8487541 8487541 20251116130306_g4Rml NZ004D 2025-11-18T14:03:36.786Z 2025-11-25T15:06:17.185Z
8487469 8487469 20251116125400_1PD1w NZ004D 2025-11-18T14:03:26.407Z 2025-11-25T15:06:15.132Z
8487448 8487448 20251116125013_YVf69 NZ004D 2025-11-18T14:03:20.891Z 2025-11-25T15:06:13.557Z
8487441 8487441 20251116125013_52TM8 NZ004D 2025-11-18T14:03:17.805Z 2025-11-25T15:06:13.534Z

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