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

9,599 rows where station_code = "NZ002Q" 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
9627475 9627475 20260408175523_iwHVu NZ002Q 2026-04-09T12:11:09.295Z 2026-04-09T12:11:09.295Z
9626839 9626839 20260408151319_pisqf NZ002Q 2026-04-09T12:09:17.650Z 2026-04-09T12:09:17.650Z
9626607 9626607 20260408142709_V9Hka NZ002Q 2026-04-09T12:08:46.781Z 2026-04-09T12:08:46.781Z
9626340 9626340 20260408134459_wB1Dp NZ002Q 2026-04-09T12:08:10.755Z 2026-04-09T12:08:10.755Z
9625982 9625982 20260408124645_s8RYV NZ002Q 2026-04-09T12:07:14.631Z 2026-04-09T12:07:14.631Z
9625929 9625929 20260408122623_FM9ys NZ002Q 2026-04-09T12:07:07.800Z 2026-04-09T12:07:07.800Z
9625845 9625845 20260408120619_q2sYu NZ002Q 2026-04-09T12:06:58.795Z 2026-04-09T12:06:58.795Z
9625562 9625562 20260408112003_Htv2R NZ002Q 2026-04-09T12:05:58.916Z 2026-04-09T12:05:58.916Z
9625450 9625450 20260408105510_rCj9N NZ002Q 2026-04-09T12:05:34.781Z 2026-04-09T12:05:34.781Z
9610357 9610357 20260405165724_fyStQ NZ002Q 2026-04-06T12:07:19.129Z 2026-04-09T12:36:45.253Z
9610316 9610316 20260405161042_nQzLY NZ002Q 2026-04-06T12:06:59.230Z 2026-04-09T12:36:43.768Z
9610288 9610288 20260405155337_NZHs8 NZ002Q 2026-04-06T12:06:52.991Z 2026-04-09T12:36:43.070Z
9610256 9610256 20260405152802_p033T NZ002Q 2026-04-06T12:06:43.427Z 2026-04-09T12:36:41.754Z
9610151 9610151 20260405135914_m7p6K NZ002Q 2026-04-06T12:06:05.280Z 2026-04-09T12:36:37.653Z
9610055 9610055 20260405121401_zZiIm NZ002Q 2026-04-06T12:05:27.137Z 2026-04-09T12:36:19.799Z
9609696 9609696 20260405092057_L5VX2 NZ002Q 2026-04-06T12:03:22.544Z 2026-04-09T12:36:05.149Z
9609615 9609615 20260405084022_zmcJX NZ002Q 2026-04-06T12:02:55.710Z 2026-04-09T12:36:02.647Z
9609575 9609575 20260405082540_zzZeD NZ002Q 2026-04-06T12:02:41.267Z 2026-04-09T12:36:01.483Z
9609062 9609062 20260331093132_D9b9A NZ002Q 2026-04-05T12:19:16.397Z 2026-04-09T12:46:38.687Z
9609058 9609058 20260331081522_3ugmR NZ002Q 2026-04-05T12:19:07.066Z 2026-04-09T12:46:37.108Z
9606340 9606340 20260403171837_B4U7q NZ002Q 2026-04-04T12:06:31.123Z 2026-04-09T12:42:14.580Z
9605971 9605971 20260403133605_m6zxi NZ002Q 2026-04-04T12:04:43.394Z 2026-04-09T12:42:05.205Z
9605962 9605962 20260403133149_PNaCm NZ002Q 2026-04-04T12:04:39.689Z 2026-04-09T12:42:04.898Z
9605812 9605812 20260403120945_s3ASu NZ002Q 2026-04-04T12:04:01.416Z 2026-04-09T12:41:54.094Z
9605775 9605775 20260403120133_6q2uo NZ002Q 2026-04-04T12:03:53.442Z 2026-04-09T12:41:31.375Z
9605761 9605761 20260403115508_lR8Dl NZ002Q 2026-04-04T12:03:48.391Z 2026-04-09T12:41:31.035Z
9605677 9605677 20260403112641_y4qD3 NZ002Q 2026-04-04T12:03:26.531Z 2026-04-09T12:41:29.270Z
9605497 9605497 20260403102556_Ma6Eu NZ002Q 2026-04-04T12:02:37.112Z 2026-04-09T12:41:23.679Z
9605402 9605402 20260403094829_gGDQB NZ002Q 2026-04-04T12:02:07.925Z 2026-04-09T12:41:21.679Z
9605372 9605372 20260403091916_0DNSM NZ002Q 2026-04-04T12:01:56.660Z 2026-04-09T12:41:20.945Z
9605367 9605367 20260403091147_A2m9R NZ002Q 2026-04-04T12:01:55.299Z 2026-04-09T12:41:20.836Z
9605277 9605277 20260403082046_oa4b1 NZ002Q 2026-04-04T12:01:32.009Z 2026-04-09T12:41:18.830Z
9605180 9605180 20260403073139_1332G NZ002Q 2026-04-04T12:01:01.436Z 2026-04-09T12:41:16.282Z
9605133 9605133 20260403070409_U4jDI NZ002Q 2026-04-04T12:00:52.523Z 2026-04-09T12:41:15.172Z
9605130 9605130 20260403070108_oxH4a NZ002Q 2026-04-04T12:00:51.988Z 2026-04-09T12:41:15.098Z
9598958 9598958 20260331093911_y2jKg NZ002Q 2026-04-01T12:01:46.644Z 2026-04-09T12:46:38.906Z
9598867 9598867 20260331081525_dl4YH NZ002Q 2026-04-01T12:01:21.781Z 2026-04-09T12:46:37.167Z
9598791 9598791 20260331071608_NnrcS NZ002Q 2026-04-01T12:01:06.284Z 2026-04-09T12:46:35.806Z
9597381 9597381 20260330161159_VW39k NZ002Q 2026-03-31T12:06:17.193Z 2026-04-08T12:43:41.691Z
9595726 9595726 20260330081545_fxvmh NZ002Q 2026-03-31T12:02:18.514Z 2026-04-08T12:42:30.476Z
9591591 9591591 20260328172147_Mv7Rf NZ002Q 2026-03-29T12:04:40.348Z 2026-04-06T12:39:24.682Z
9591541 9591541 20260328170402_nciH7 NZ002Q 2026-03-29T12:04:34.150Z 2026-04-06T12:39:22.111Z
9591406 9591406 20260328162423_o1i0R NZ002Q 2026-03-29T12:04:21.998Z 2026-04-06T12:39:14.328Z
9591386 9591386 20260328161342_wzJGv NZ002Q 2026-03-29T12:04:20.397Z 2026-04-06T12:39:13.511Z
9591379 9591379 20260328160902_12NzM NZ002Q 2026-03-29T12:04:19.853Z 2026-04-06T12:39:13.176Z
9591357 9591357 20260328155307_QjlKc NZ002Q 2026-03-29T12:04:18.097Z 2026-04-06T12:39:12.238Z
9591322 9591322 20260328153424_o7xvE NZ002Q 2026-03-29T12:04:15.001Z 2026-04-06T12:39:10.876Z
9591246 9591246 20260328150006_F7LMH NZ002Q 2026-03-29T12:04:05.325Z 2026-04-06T12:39:07.669Z
9591206 9591206 20260328142534_lRddr NZ002Q 2026-03-29T12:04:00.693Z 2026-04-06T12:39:05.400Z
9591143 9591143 20260328134715_8QARZ NZ002Q 2026-03-29T12:03:55.161Z 2026-04-06T12:39:02.825Z
9591048 9591048 20260328124736_A94ui NZ002Q 2026-03-29T12:03:42.947Z 2026-04-06T12:38:48.428Z
9590535 9590535 20260328095226_2eZLj NZ002Q 2026-03-29T12:02:52.349Z 2026-04-06T12:38:22.926Z
9588026 9588026 20260327173252_D8JaN NZ002Q 2026-03-28T12:06:58.142Z 2026-04-05T12:35:04.804Z
9588023 9588023 20260327173120_6y9nq NZ002Q 2026-03-28T12:06:57.603Z 2026-04-05T12:35:04.645Z
9587926 9587926 20260327165406_2plof NZ002Q 2026-03-28T12:06:44.335Z 2026-04-05T12:34:59.808Z
9587910 9587910 20260327164947_SsMiF NZ002Q 2026-03-28T12:06:42.269Z 2026-04-05T12:34:58.714Z
9587738 9587738 20260327152937_hpQjg NZ002Q 2026-03-28T12:06:14.016Z 2026-04-05T12:34:39.291Z
9587732 9587732 20260327152456_CLxs4 NZ002Q 2026-03-28T12:06:13.345Z 2026-04-05T12:34:38.972Z
9587696 9587696 20260327151007_dtNT8 NZ002Q 2026-03-28T12:06:09.493Z 2026-04-05T12:34:37.668Z
9587581 9587581 20260327142030_RDcTJ NZ002Q 2026-03-28T12:05:51.572Z 2026-04-05T12:34:32.430Z
9587572 9587572 20260327141340_m957C NZ002Q 2026-03-28T12:05:50.760Z 2026-04-05T12:34:32.066Z
9587544 9587544 20260327135312_C9z2o NZ002Q 2026-03-28T12:05:47.053Z 2026-04-05T12:34:30.823Z
9587535 9587535 20260327135019_BI08j NZ002Q 2026-03-28T12:05:45.958Z 2026-04-05T12:34:30.503Z
9587501 9587501 20260327133226_6Hf8y NZ002Q 2026-03-28T12:05:41.291Z 2026-04-05T12:34:29.118Z
9587491 9587491 20260327132805_X7W3A NZ002Q 2026-03-28T12:05:40.031Z 2026-04-05T12:34:28.777Z
9587463 9587463 20260327130010_dkSh1 NZ002Q 2026-03-28T12:05:33.966Z 2026-04-05T12:34:27.403Z
9587445 9587445 20260327125057_0tsJD NZ002Q 2026-03-28T12:05:31.971Z 2026-04-05T12:34:26.703Z
9587077 9587077 20260327110456_e4vNF NZ002Q 2026-03-28T12:04:44.042Z 2026-04-05T12:34:01.002Z
9587063 9587063 20260327110142_ASWR3 NZ002Q 2026-03-28T12:04:42.269Z 2026-04-05T12:34:00.529Z
9587057 9587057 20260327110010_rkQ2O NZ002Q 2026-03-28T12:04:41.987Z 2026-04-05T12:34:00.397Z
9586736 9586736 20260327092111_khIak NZ002Q 2026-03-28T12:03:53.184Z 2026-04-05T12:33:39.788Z
9586630 9586630 20260327084814_wUlW9 NZ002Q 2026-03-28T12:03:35.938Z 2026-04-05T12:33:33.304Z
9586584 9586584 20260327083349_t0dT2 NZ002Q 2026-03-28T12:03:29.761Z 2026-04-05T12:33:31.696Z
9586490 9586490 20260327080128_7m3kt NZ002Q 2026-03-28T12:03:15.959Z 2026-04-05T12:33:27.878Z
9583631 9583631 20260326164452_2TrDi NZ002Q 2026-03-27T12:09:21.626Z 2026-04-04T12:41:28.928Z
9569227 9569227 20260322141749_sQNl7 NZ002Q 2026-03-24T12:20:14.586Z 2026-03-30T12:29:40.090Z
9569205 9569205 20260322140840_p3JtX NZ002Q 2026-03-24T12:20:06.571Z 2026-03-30T12:29:38.864Z
9569201 9569201 20260322140419_3YNN2 NZ002Q 2026-03-24T12:20:05.466Z 2026-03-30T12:29:38.337Z
9568779 9568779 20260322075426_2q4JA NZ002Q 2026-03-24T12:17:52.915Z 2026-03-30T12:28:34.636Z
9568774 9568774 20260322073419_hJQ9c NZ002Q 2026-03-24T12:17:48.800Z 2026-03-30T12:28:32.653Z
9568399 9568399 20260323164049_yJi7t NZ002Q 2026-03-24T12:15:03.907Z 2026-03-31T12:28:28.699Z
9568117 9568117 20260323161527_vZGtV NZ002Q 2026-03-24T12:14:35.862Z 2026-03-31T12:28:23.265Z
9567937 9567937 20260323160130_6r49S NZ002Q 2026-03-24T12:14:18.850Z 2026-03-31T12:28:20.891Z
9567140 9567140 20260323144547_CSbYN NZ002Q 2026-03-24T12:13:06.093Z 2026-03-31T12:28:09.012Z
9566887 9566887 20260323142338_ZoE9r NZ002Q 2026-03-24T12:12:39.800Z 2026-03-31T12:28:05.734Z
9566794 9566794 20260323141346_Bbv0y NZ002Q 2026-03-24T12:12:27.166Z 2026-03-31T12:28:04.326Z
9566614 9566614 20260323135717_X7W42 NZ002Q 2026-03-24T12:12:12.725Z 2026-03-31T12:27:54.713Z
9566554 9566554 20260323135318_Fg3nw NZ002Q 2026-03-24T12:12:04.663Z 2026-03-31T12:27:53.713Z
9566427 9566427 20260323133614_tLz98 NZ002Q 2026-03-24T12:11:50.795Z 2026-03-31T12:27:51.820Z
9566232 9566232 20260323131611_CB37r NZ002Q 2026-03-24T12:11:28.772Z 2026-03-31T12:27:47.430Z
9566229 9566229 20260323131610_NfJsM NZ002Q 2026-03-24T12:11:28.339Z 2026-03-31T12:27:47.392Z
9566069 9566069 20260323130326_MpaaY NZ002Q 2026-03-24T12:11:18.435Z 2026-03-31T12:27:45.732Z
9566034 9566034 20260323130059_I6z6b NZ002Q 2026-03-24T12:11:14.658Z 2026-03-31T12:27:45.075Z
9565496 9565496 20260323121402_a2NOu NZ002Q 2026-03-24T12:10:17.913Z 2026-03-31T12:27:36.534Z
9564853 9564853 20260323111330_Um8ca NZ002Q 2026-03-24T12:08:54.097Z 2026-03-31T12:27:16.500Z
9564710 9564710 20260323110341_GMy0P NZ002Q 2026-03-24T12:08:38.135Z 2026-03-31T12:27:14.130Z
9563859 9563859 20260323092212_TJbW2 NZ002Q 2026-03-24T12:06:52.684Z 2026-03-31T12:26:58.075Z
9563613 9563613 20260323085036_6UZE8 NZ002Q 2026-03-24T12:06:24.037Z 2026-03-31T12:26:48.039Z
9559360 9559360 20260321170144_LvPfH NZ002Q 2026-03-23T12:11:03.045Z 2026-03-29T12:20:38.169Z
9559315 9559315 20260321165624_2tw5N NZ002Q 2026-03-23T12:11:01.616Z 2026-03-29T12:20:37.501Z

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