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 = "NZ001P" 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
9603099 9603099 20260402074929_aI9o3 NZ001P 2026-04-03T12:01:44.646Z 2026-04-08T12:35:43.067Z
9599241 9599241 20260331131041_3mqBU NZ001P 2026-04-01T12:02:52.333Z 2026-04-08T12:40:09.207Z
9599069 9599069 20260331112938_kHzNC NZ001P 2026-04-01T12:02:15.267Z 2026-04-08T12:40:03.198Z
9597954 9597954 20260330172307_4eT02 NZ001P 2026-03-31T12:07:20.905Z 2026-04-08T12:44:21.568Z
9597915 9597915 20260330171512_ttJcl NZ001P 2026-03-31T12:07:16.854Z 2026-04-08T12:44:20.608Z
9597877 9597877 20260330171157_PqQfh NZ001P 2026-03-31T12:07:10.671Z 2026-04-08T12:44:19.759Z
9597815 9597815 20260330170112_4zjeR NZ001P 2026-03-31T12:07:02.996Z 2026-04-08T12:44:17.999Z
9597792 9597792 20260330170026_JG2ns NZ001P 2026-03-31T12:07:01.255Z 2026-04-08T12:44:17.619Z
9595756 9595756 20260330082150_D9wa7 NZ001P 2026-03-31T12:02:24.648Z 2026-04-08T12:42:31.307Z
9591382 9591382 20260328161259_8d3aE NZ001P 2026-03-29T12:04:20.158Z 2026-04-06T12:39:13.377Z
9568367 9568367 20260323163508_4DJDm NZ001P 2026-03-24T12:14:58.280Z 2026-03-31T12:28:28.386Z
9544198 9544198 20260321075740_a126x NZ001P 2026-03-22T12:06:04.611Z 2026-03-29T12:19:17.628Z
9539523 9539523 20260320150833_C0qe8 NZ001P 2026-03-21T12:19:40.618Z 2026-03-28T12:36:05.492Z
9536172 9536172 20260320092035_S8mNC NZ001P 2026-03-21T12:12:45.261Z 2026-03-28T12:34:58.335Z
9528711 9528711 20260318164052_SNRSy NZ001P 2026-03-20T12:22:28.288Z 2026-03-26T12:38:37.783Z
9526992 9526992 20260318134523_eOnZs NZ001P 2026-03-20T12:20:53.961Z 2026-03-26T12:38:25.232Z
9525929 9525929 20260319153355_WlONc NZ001P 2026-03-20T12:14:41.682Z 2026-03-27T12:42:21.273Z
9523236 9523236 20260319094145_LbjRz NZ001P 2026-03-20T12:11:07.481Z 2026-03-27T12:41:26.982Z
9522730 9522730 20260319084458_n3HG6 NZ001P 2026-03-20T12:10:16.883Z 2026-03-27T12:41:21.167Z
9522664 9522664 20260319083746_qR36U NZ001P 2026-03-20T12:10:12.205Z 2026-03-27T12:41:20.642Z
9513239 9513239 20260318084814_8Drd6 NZ001P 2026-03-19T12:14:44.950Z 2026-03-26T12:37:53.555Z
9512615 9512615 20260318071802_hNo94 NZ001P 2026-03-19T12:13:06.570Z 2026-03-26T12:37:47.296Z
9498674 9498674 20260316152010_7LYKf NZ001P 2026-03-17T12:14:16.759Z 2026-03-24T12:41:26.717Z
9498589 9498589 20260316151554_2RtME NZ001P 2026-03-17T12:14:10.217Z 2026-03-24T12:41:26.549Z
9498518 9498518 20260316151155_sG4LC NZ001P 2026-03-17T12:14:03.312Z 2026-03-24T12:41:26.334Z
9498402 9498402 20260316150112_y7nhO NZ001P 2026-03-17T12:13:52.346Z 2026-03-24T12:41:25.949Z
9496602 9496602 20260316115810_M9Isr NZ001P 2026-03-17T12:10:10.393Z 2026-03-24T12:41:20.443Z
9491393 9491393 20260315164143_rxuft NZ001P 2026-03-16T12:20:53.345Z 2026-03-23T12:22:39.332Z
9491279 9491279 20260315163205_cPLJ0 NZ001P 2026-03-16T12:20:42.613Z 2026-03-23T12:22:39.096Z
9491197 9491197 20260315161837_8Vrex NZ001P 2026-03-16T12:20:31.094Z 2026-03-23T12:22:38.809Z
9490942 9490942 20260315154731_z6Yy0 NZ001P 2026-03-16T12:20:02.468Z 2026-03-23T12:22:38.103Z
9490435 9490435 20260315145255_qv1I5 NZ001P 2026-03-16T12:19:07.694Z 2026-03-23T12:22:36.657Z
9459491 9459491 20260311133913_K96za NZ001P 2026-03-12T12:08:35.039Z 2026-03-19T12:45:10.654Z
9449720 9449720 20260309162230_lS3O4 NZ001P 2026-03-10T12:13:43.321Z 2026-03-17T12:42:30.901Z
9444942 9444942 20260308163028_erjes NZ001P 2026-03-09T12:12:18.646Z 2026-03-16T12:44:34.735Z
9444671 9444671 20260308150318_HMctn NZ001P 2026-03-09T12:11:30.950Z 2026-03-16T12:44:31.747Z
9444398 9444398 20260308134453_LEAwA NZ001P 2026-03-09T12:10:43.836Z 2026-03-16T12:44:29.050Z
9444367 9444367 20260308133832_p6Bz2 NZ001P 2026-03-09T12:10:39.281Z 2026-03-16T12:44:28.692Z
9443989 9443989 20260308121305_TC2dQ NZ001P 2026-03-09T12:09:38.045Z 2026-03-16T12:44:24.538Z
9439449 9439449 20260307134424_TDq2T NZ001P 2026-03-08T12:10:26.459Z 2026-03-15T12:41:42.712Z
9435610 9435610 20260306165427_39OEv NZ001P 2026-03-07T14:15:51.537Z 2026-03-14T12:40:37.077Z
9435347 9435347 20260306160426_FHkq0 NZ001P 2026-03-07T14:14:47.779Z 2026-03-14T12:40:32.433Z
9434886 9434886 20260306144700_n3x9g NZ001P 2026-03-07T14:13:20.558Z 2026-03-14T12:40:27.660Z
9433992 9433992 20260306121546_0Uvb1 NZ001P 2026-03-07T14:10:00.799Z 2026-03-14T12:40:02.953Z
9433859 9433859 20260306115917_GKgmK NZ001P 2026-03-07T14:09:33.203Z 2026-03-14T12:40:01.680Z
9432610 9432610 20260306081857_HD8qE NZ001P 2026-03-07T14:05:29.668Z 2026-03-14T12:39:34.313Z
9429358 9429358 20260305153112_58vvO NZ001P 2026-03-06T14:15:53.452Z 2026-03-13T12:35:31.533Z
9428017 9428017 20260305113304_kqrJ2 NZ001P 2026-03-06T14:11:24.409Z 2026-03-13T12:35:05.227Z
9427926 9427926 20260305111240_PdYSY NZ001P 2026-03-06T14:11:04.296Z 2026-03-13T12:35:04.463Z
9427400 9427400 20260305092034_PVZns NZ001P 2026-03-06T14:09:01.561Z 2026-03-13T12:34:58.307Z
9425185 9425185 20260303170422_O2cUT NZ001P 2026-03-05T14:14:13.467Z 2026-03-11T12:28:46.914Z
9424929 9424929 20260303151632_NP5S3 NZ001P 2026-03-05T14:13:37.172Z 2026-03-11T12:28:42.611Z
9424398 9424398 20260304170359_wUB35 NZ001P 2026-03-05T14:08:00.718Z 2026-03-12T12:33:25.193Z
9422117 9422117 20260303145419_OeEq3 NZ001P 2026-03-04T14:07:25.420Z 2026-03-11T12:28:41.700Z
9417178 9417178 20260302143311_KXx2Q NZ001P 2026-03-03T14:05:38.835Z 2026-03-10T12:36:25.420Z
9416772 9416772 20260302122159_uaaIG NZ001P 2026-03-03T14:04:38.885Z 2026-03-10T12:36:18.712Z
9416034 9416034 20260302081124_lj09B NZ001P 2026-03-03T14:02:33.025Z 2026-03-10T12:35:56.396Z
9414281 9414281 20260301162304_glO3M NZ001P 2026-03-02T14:04:18.766Z 2026-03-09T12:40:44.783Z
9414093 9414093 20260301155136_qvCkd NZ001P 2026-03-02T14:04:06.328Z 2026-03-09T12:40:32.701Z
9414016 9414016 20260301153933_DQYUg NZ001P 2026-03-02T14:04:02.216Z 2026-03-09T12:40:31.721Z
9413924 9413924 20260301151711_dMI7i NZ001P 2026-03-02T14:03:54.041Z 2026-03-09T12:40:29.443Z
9413891 9413891 20260301150435_Enocs NZ001P 2026-03-02T14:03:50.453Z 2026-03-09T12:40:28.644Z
9413466 9413466 20260301122010_IwGjm NZ001P 2026-03-02T14:03:17.859Z 2026-03-09T12:40:17.161Z
9413295 9413295 20260301110425_qA92H NZ001P 2026-03-02T14:03:01.415Z 2026-03-09T12:40:11.800Z
9413233 9413233 20260301103224_Xp4Mm NZ001P 2026-03-02T14:02:52.493Z 2026-03-09T12:40:10.057Z
9410996 9410996 20260228141128_MgS8W NZ001P 2026-03-01T14:04:21.183Z 2026-03-08T12:42:25.095Z
9410916 9410916 20260228134518_2VKzr NZ001P 2026-03-01T14:04:16.644Z 2026-03-08T12:42:23.194Z
9410848 9410848 20260228131745_UK9k6 NZ001P 2026-03-01T14:04:13.057Z 2026-03-08T12:42:21.870Z
9386645 9386645 20260224104629_d1dIJ NZ001P 2026-02-25T14:18:56.819Z 2026-03-04T14:18:04.140Z
9386172 9386172 20260224164503_oR26A NZ001P 2026-02-25T14:10:26.157Z 2026-03-04T14:19:09.773Z
9386032 9386032 20260224161916_boUSS NZ001P 2026-02-25T14:10:06.038Z 2026-03-04T14:18:52.324Z
9385365 9385365 20260224141537_UhuGi NZ001P 2026-02-25T14:08:24.027Z 2026-03-04T14:18:37.377Z
9385159 9385159 20260224133944_UHIvX NZ001P 2026-02-25T14:07:55.283Z 2026-03-04T14:18:34.060Z
9384991 9384991 20260224125528_CHlWO NZ001P 2026-02-25T14:07:26.732Z 2026-03-04T14:18:30.299Z
9384868 9384868 20260224124033_l8K2s NZ001P 2026-02-25T14:07:06.960Z 2026-03-04T14:18:28.314Z
9384613 9384613 20260224120004_bjk4X NZ001P 2026-02-25T14:06:21.892Z 2026-03-04T14:18:12.496Z
9384242 9384242 20260224104629_BHsjD NZ001P 2026-02-25T14:05:06.132Z 2026-03-04T14:18:04.090Z
9378225 9378225 20260222124650_qjJAX NZ001P 2026-02-24T14:17:52.077Z 2026-02-24T14:17:52.077Z
9377634 9377634 20260223162646_YWuE7 NZ001P 2026-02-24T14:14:01.169Z 2026-03-03T14:32:35.927Z
9377405 9377405 20260223162232_jJ2eO NZ001P 2026-02-24T14:13:43.871Z 2026-03-03T14:32:34.277Z
9377306 9377306 20260223161935_8ngh6 NZ001P 2026-02-24T14:13:35.970Z 2026-03-03T14:32:30.370Z
9377003 9377003 20260223160031_G2jHl NZ001P 2026-02-24T14:13:01.535Z 2026-03-03T14:32:19.128Z
9376730 9376730 20260223151414_CO8zh NZ001P 2026-02-24T14:12:26.170Z 2026-03-03T14:32:14.156Z
9376269 9376269 20260223134336_wWasG NZ001P 2026-02-24T14:11:16.236Z 2026-03-03T14:32:08.172Z
9376143 9376143 20260223132108_IJtzN NZ001P 2026-02-24T14:10:59.163Z 2026-03-03T14:32:06.127Z
9376072 9376072 20260223131024_uolox NZ001P 2026-02-24T14:10:48.472Z 2026-03-03T14:32:05.377Z
9376059 9376059 20260223130836_Y5WQd NZ001P 2026-02-24T14:10:44.328Z 2026-03-03T14:32:05.192Z
9375494 9375494 20260223113926_nMaOg NZ001P 2026-02-24T14:09:12.566Z 2026-03-03T14:31:47.675Z
9374858 9374858 20260223100138_2OPdR NZ001P 2026-02-24T14:07:18.410Z 2026-03-03T14:31:37.255Z
9374756 9374756 20260223094027_QQJae NZ001P 2026-02-24T14:06:58.807Z 2026-03-03T14:31:35.526Z
9374635 9374635 20260223091213_CmHnG NZ001P 2026-02-24T14:06:35.651Z 2026-03-03T14:31:33.471Z
9374630 9374630 20260223091213_hcvuM NZ001P 2026-02-24T14:06:35.254Z 2026-03-03T14:31:33.405Z
9370168 9370168 20260222163614_1hqsQ NZ001P 2026-02-23T14:15:36.041Z 2026-02-24T14:21:08.523Z
9368720 9368720 20260222143033_hmOkW NZ001P 2026-02-23T14:13:09.308Z 2026-02-24T14:19:07.941Z
9368446 9368446 20260222140211_ddJZz NZ001P 2026-02-23T14:12:37.458Z 2026-02-24T14:18:47.127Z
9368291 9368291 20260222134539_UN1xI NZ001P 2026-02-23T14:12:17.623Z 2026-02-24T14:18:30.992Z
9367739 9367739 20260222124106_LIs77 NZ001P 2026-02-23T14:11:08.173Z 2026-02-24T14:17:44.689Z
9367619 9367619 20260222122925_SiTx5 NZ001P 2026-02-23T14:10:49.530Z 2026-02-24T14:17:37.614Z
9367521 9367521 20260222121758_sZyzM NZ001P 2026-02-23T14:10:36.994Z 2026-02-24T14:17:30.994Z
9367409 9367409 20260222120603_6A2xz NZ001P 2026-02-23T14:10:21.417Z 2026-02-24T14:17:23.902Z

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