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 = "NZ0040" 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
9270663 9270663 20260128161842_ZCecY NZ0040 2026-01-29T14:13:14.307Z 2026-01-29T14:13:14.307Z
9270531 9270531 20260128155810_jrsJ2 NZ0040 2026-01-29T14:12:32.576Z 2026-01-29T14:12:32.576Z
9270522 9270522 20260128155725_zIdEw NZ0040 2026-01-29T14:12:31.603Z 2026-01-29T14:12:31.603Z
9270514 9270514 20260128155718_xgOeL NZ0040 2026-01-29T14:12:30.241Z 2026-01-29T14:12:30.241Z
9270504 9270504 20260128155652_L2ia3 NZ0040 2026-01-29T14:12:27.512Z 2026-01-29T14:12:27.512Z
9270501 9270501 20260128155625_jB3oL NZ0040 2026-01-29T14:12:26.824Z 2026-01-29T14:12:26.824Z
9270462 9270462 20260128155303_qIBzs NZ0040 2026-01-29T14:12:20.445Z 2026-01-29T14:12:20.445Z
9270423 9270423 20260128154803_iUa22 NZ0040 2026-01-29T14:12:13.219Z 2026-01-29T14:12:13.219Z
9270370 9270370 20260128153946_TGSio NZ0040 2026-01-29T14:11:57.275Z 2026-01-29T14:11:57.275Z
9270332 9270332 20260128153238_t2uM6 NZ0040 2026-01-29T14:11:47.007Z 2026-01-29T14:11:47.007Z
9270306 9270306 20260128152958_BZ6Ef NZ0040 2026-01-29T14:11:42.487Z 2026-01-29T14:11:42.487Z
9270250 9270250 20260128152023_CkuUd NZ0040 2026-01-29T14:11:24.261Z 2026-01-29T14:11:24.261Z
9270228 9270228 20260128151823_VRFwi NZ0040 2026-01-29T14:11:21.944Z 2026-01-29T14:11:21.944Z
9270165 9270165 20260128150446_3w2gM NZ0040 2026-01-29T14:11:09.755Z 2026-01-29T14:11:09.755Z
9270068 9270068 20260128145132_veUaf NZ0040 2026-01-29T14:10:46.230Z 2026-01-29T14:10:46.230Z
9270051 9270051 20260128145058_Zs3KN NZ0040 2026-01-29T14:10:44.121Z 2026-01-29T14:10:44.121Z
9270031 9270031 20260128144940_CZ2bS NZ0040 2026-01-29T14:10:41.624Z 2026-01-29T14:10:41.624Z
9269961 9269961 20260128143755_bQosM NZ0040 2026-01-29T14:10:21.055Z 2026-01-29T14:10:21.055Z
9269932 9269932 20260128143244_fCDGK NZ0040 2026-01-29T14:10:15.275Z 2026-01-29T14:10:15.275Z
9269868 9269868 20260128142543_y0Cs4 NZ0040 2026-01-29T14:09:55.041Z 2026-01-29T14:09:55.041Z
9269710 9269710 20260128135851_HzYvU NZ0040 2026-01-29T14:09:09.743Z 2026-01-29T14:09:09.743Z
9269656 9269656 20260128135113_OedGd NZ0040 2026-01-29T14:08:58.707Z 2026-01-29T14:08:58.707Z
9269620 9269620 20260128134524_4JcjD NZ0040 2026-01-29T14:08:52.222Z 2026-01-29T14:08:52.222Z
9269353 9269353 20260128130403_wXb5d NZ0040 2026-01-29T14:07:31.573Z 2026-01-29T14:07:31.573Z
9269341 9269341 20260128130321_RQd97 NZ0040 2026-01-29T14:07:29.785Z 2026-01-29T14:07:29.785Z
9269078 9269078 20260128122010_aLRy5 NZ0040 2026-01-29T14:06:20.542Z 2026-01-29T14:06:20.542Z
9269067 9269067 20260128121754_uK7Ho NZ0040 2026-01-29T14:06:14.686Z 2026-01-29T14:06:14.686Z
9269027 9269027 20260128120339_FGkoC NZ0040 2026-01-29T14:06:04.959Z 2026-01-29T14:06:04.959Z
9269010 9269010 20260128120025_v5vbG NZ0040 2026-01-29T14:06:00.456Z 2026-01-29T14:06:00.456Z
9268989 9268989 20260128115724_zghWs NZ0040 2026-01-29T14:05:51.972Z 2026-01-29T14:05:51.972Z
9268927 9268927 20260128114449_bHyu6 NZ0040 2026-01-29T14:05:35.328Z 2026-01-29T14:05:35.328Z
9268832 9268832 20260128113126_dyStx NZ0040 2026-01-29T14:05:06.749Z 2026-01-29T14:05:06.749Z
9268813 9268813 20260128112757_GMi3E NZ0040 2026-01-29T14:05:00.498Z 2026-01-29T14:05:00.498Z
9268808 9268808 20260128112459_YBbbn NZ0040 2026-01-29T14:04:59.123Z 2026-01-29T14:04:59.123Z
9268714 9268714 20260128110634_I87Zq NZ0040 2026-01-29T14:04:31.128Z 2026-01-29T14:04:31.128Z
9268641 9268641 20260128105715_kKHbO NZ0040 2026-01-29T14:04:09.079Z 2026-01-29T14:04:09.079Z
9268597 9268597 20260128105018_OurHo NZ0040 2026-01-29T14:03:55.383Z 2026-01-29T14:03:55.383Z
9268455 9268455 20260128102219_SO7IV NZ0040 2026-01-29T14:03:11.849Z 2026-01-29T14:03:11.849Z
9268390 9268390 20260128100539_L9tLJ NZ0040 2026-01-29T14:02:46.545Z 2026-01-29T14:02:46.545Z
9268383 9268383 20260128100505_hq40T NZ0040 2026-01-29T14:02:45.160Z 2026-01-29T14:02:45.160Z
9268320 9268320 20260128094806_pSo6Z NZ0040 2026-01-29T14:02:22.179Z 2026-01-29T14:02:22.179Z
9268318 9268318 20260128094753_AN83M NZ0040 2026-01-29T14:02:21.208Z 2026-01-29T14:02:21.208Z
9268273 9268273 20260128093927_FbPY3 NZ0040 2026-01-29T14:02:10.127Z 2026-01-29T14:02:10.127Z
9268191 9268191 20260128091759_jb60b NZ0040 2026-01-29T14:01:37.012Z 2026-01-29T14:01:37.012Z
9268177 9268177 20260128090835_VG47j NZ0040 2026-01-29T14:01:32.850Z 2026-01-29T14:01:32.850Z
9268125 9268125 20260128085629_3JhDE NZ0040 2026-01-29T14:01:14.743Z 2026-01-29T14:01:14.743Z
9268123 9268123 20260128085507_ls7AK NZ0040 2026-01-29T14:01:13.485Z 2026-01-29T14:01:13.485Z
9268104 9268104 20260128084955_C7h6F NZ0040 2026-01-29T14:01:06.984Z 2026-01-29T14:01:06.984Z
9265877 9265877 20260127160938_6SM1C NZ0040 2026-01-28T14:11:39.037Z 2026-01-29T14:30:24.706Z
9265770 9265770 20260127155727_GbLlc NZ0040 2026-01-28T14:11:17.819Z 2026-01-29T14:30:24.671Z
9265745 9265745 20260127155621_aoHav NZ0040 2026-01-28T14:11:13.166Z 2026-01-29T14:30:24.667Z
9265672 9265672 20260127154753_PQHXR NZ0040 2026-01-28T14:10:56.370Z 2026-01-29T14:30:24.651Z
9265658 9265658 20260127154547_YG9En NZ0040 2026-01-28T14:10:52.686Z 2026-01-29T14:30:24.647Z
9265642 9265642 20260127154442_g5kRc NZ0040 2026-01-28T14:10:50.165Z 2026-01-29T14:30:24.641Z
9265412 9265412 20260127151241_nxJ5X NZ0040 2026-01-28T14:10:04.134Z 2026-01-29T14:30:24.544Z
9265301 9265301 20260127145813_EUpqd NZ0040 2026-01-28T14:09:45.823Z 2026-01-29T14:30:24.522Z
9265284 9265284 20260127145528_93wPr NZ0040 2026-01-28T14:09:44.610Z 2026-01-29T14:30:24.520Z
9265244 9265244 20260127144831_FUzGb NZ0040 2026-01-28T14:09:38.207Z 2026-01-29T14:30:24.513Z
9265207 9265207 20260127143813_jAAVj NZ0040 2026-01-28T14:09:28.287Z 2026-01-29T14:30:24.502Z
9265088 9265088 20260127141508_1gCMx NZ0040 2026-01-28T14:08:59.790Z 2026-01-29T14:30:24.434Z
9264392 9264392 20260127121149_DUjrB NZ0040 2026-01-28T14:05:49.414Z 2026-01-29T14:30:21.193Z
9261795 9261795 20260126132307_IGzcw NZ0040 2026-01-27T14:05:42.136Z 2026-01-29T14:33:03.256Z
9261792 9261792 20260126132037_nvFHv NZ0040 2026-01-27T14:05:40.962Z 2026-01-29T14:33:02.862Z
9261737 9261737 20260126130342_XpBRJ NZ0040 2026-01-27T14:05:18.569Z 2026-01-29T14:32:54.225Z
9261701 9261701 20260126125506_n9Q6I NZ0040 2026-01-27T14:05:11.695Z 2026-01-29T14:32:50.310Z
9261680 9261680 20260126124809_JBTPI NZ0040 2026-01-27T14:05:05.852Z 2026-01-29T14:32:48.311Z
9261655 9261655 20260126124216_sxrNs NZ0040 2026-01-27T14:04:52.406Z 2026-01-29T14:32:46.137Z
9261436 9261436 20260126113553_JSyNL NZ0040 2026-01-27T14:03:42.680Z 2026-01-29T14:32:24.486Z
9261398 9261398 20260126112751_xkicw NZ0040 2026-01-27T14:03:35.922Z 2026-01-29T14:32:16.166Z
9261393 9261393 20260126112558_fuinu NZ0040 2026-01-27T14:03:34.005Z 2026-01-29T14:32:15.815Z
9261385 9261385 20260126112105_JqEIO NZ0040 2026-01-27T14:03:31.792Z 2026-01-29T14:32:15.228Z
9261316 9261316 20260126110555_A2c8a NZ0040 2026-01-27T14:03:11.329Z 2026-01-29T14:32:11.731Z
9261278 9261278 20260126105739_Rhk90 NZ0040 2026-01-27T14:02:58.796Z 2026-01-29T14:32:09.681Z
9261257 9261257 20260126104932_0bQNQ NZ0040 2026-01-27T14:02:51.777Z 2026-01-29T14:32:08.599Z
9261204 9261204 20260126102702_p6TeH NZ0040 2026-01-27T14:02:32.530Z 2026-01-29T14:32:04.083Z
9261186 9261186 20260126101847_6F0Pn NZ0040 2026-01-27T14:02:24.228Z 2026-01-29T14:32:02.509Z
9261165 9261165 20260126100726_E7WrI NZ0040 2026-01-27T14:02:19.717Z 2026-01-29T14:32:00.905Z
9261110 9261110 20260126095356_H6MOe NZ0040 2026-01-27T14:01:55.610Z 2026-01-29T14:31:56.989Z
9261073 9261073 20260126094451_0AVmy NZ0040 2026-01-27T14:01:45.957Z 2026-01-29T14:31:45.418Z
9261052 9261052 20260126093815_IjZay NZ0040 2026-01-27T14:01:38.998Z 2026-01-29T14:31:33.907Z
9261036 9261036 20260126093357_s6pic NZ0040 2026-01-27T14:01:35.582Z 2026-01-29T14:31:30.513Z
9261000 9261000 20260126091635_nBVmJ NZ0040 2026-01-27T14:01:20.410Z 2026-01-29T14:31:19.687Z
9260939 9260939 20260126085224_2JMCy NZ0040 2026-01-27T14:01:01.308Z 2026-01-29T14:31:14.887Z
9257850 9257850 20260125162138_P4Xd5 NZ0040 2026-01-26T14:08:09.626Z 2026-01-29T14:37:44.711Z
9257824 9257824 20260125160425_GCtk2 NZ0040 2026-01-26T14:07:56.158Z 2026-01-29T14:37:43.412Z
9257817 9257817 20260125160140_EEJAr NZ0040 2026-01-26T14:07:50.637Z 2026-01-29T14:37:42.942Z
9257774 9257774 20260125155432_nTHJK NZ0040 2026-01-26T14:07:41.820Z 2026-01-29T14:37:39.195Z
9257758 9257758 20260125154921_tLBx3 NZ0040 2026-01-26T14:07:38.072Z 2026-01-29T14:37:38.314Z
9257713 9257713 20260125153526_08n8i NZ0040 2026-01-26T14:07:23.004Z 2026-01-29T14:37:36.454Z
9257698 9257698 20260125152740_VfEIJ NZ0040 2026-01-26T14:07:19.507Z 2026-01-29T14:37:35.558Z
9257677 9257677 20260125152437_l2A30 NZ0040 2026-01-26T14:07:13.267Z 2026-01-29T14:37:34.581Z
9257655 9257655 20260125151606_jsqP9 NZ0040 2026-01-26T14:07:02.561Z 2026-01-29T14:37:33.169Z
9257651 9257651 20260125151601_gMd5j NZ0040 2026-01-26T14:06:58.893Z 2026-01-29T14:37:32.997Z
9257649 9257649 20260125151527_1cMc9 NZ0040 2026-01-26T14:06:58.182Z 2026-01-29T14:37:32.859Z
9257641 9257641 20260125150834_taG9N NZ0040 2026-01-26T14:06:54.777Z 2026-01-29T14:37:32.083Z
9257600 9257600 20260125145224_C6tS7 NZ0040 2026-01-26T14:06:36.608Z 2026-01-29T14:37:29.790Z
9257590 9257590 20260125144814_vAnzg NZ0040 2026-01-26T14:06:32.999Z 2026-01-29T14:37:29.294Z
9257521 9257521 20260125141732_Ll2a6 NZ0040 2026-01-26T14:06:05.277Z 2026-01-29T14:37:25.424Z
9257483 9257483 20260125140321_WicC6 NZ0040 2026-01-26T14:05:55.773Z 2026-01-29T14:37:15.136Z
9257461 9257461 20260125135332_g0x1e NZ0040 2026-01-26T14:05:45.908Z 2026-01-29T14:37:13.654Z

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