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 = "NZ003C" 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
9270616 9270616 20260128161328_HVUXp NZ003C 2026-01-29T14:13:02.076Z 2026-01-29T14:13:02.076Z
9270604 9270604 20260128161109_LTH7i NZ003C 2026-01-29T14:12:56.257Z 2026-01-29T14:12:56.257Z
9270582 9270582 20260128160739_zNFmK NZ003C 2026-01-29T14:12:51.501Z 2026-01-29T14:12:51.501Z
9270498 9270498 20260128155625_jB3oL NZ003C 2026-01-29T14:12:26.823Z 2026-01-29T14:12:26.823Z
9270398 9270398 20260128154229_qGzVK NZ003C 2026-01-29T14:12:06.620Z 2026-01-29T14:12:06.620Z
9269930 9269930 20260128143244_fCDGK NZ003C 2026-01-29T14:10:15.275Z 2026-01-29T14:10:15.275Z
9269831 9269831 20260128141926_LvMGz NZ003C 2026-01-29T14:09:47.761Z 2026-01-29T14:09:47.761Z
9269763 9269763 20260128141001_4HtxC NZ003C 2026-01-29T14:09:32.769Z 2026-01-29T14:09:32.769Z
9269741 9269741 20260128140416_T2Hrq NZ003C 2026-01-29T14:09:23.117Z 2026-01-29T14:09:23.117Z
9269708 9269708 20260128135822_M3cpk NZ003C 2026-01-29T14:09:09.232Z 2026-01-29T14:09:09.232Z
9269653 9269653 20260128135113_OedGd NZ003C 2026-01-29T14:08:58.707Z 2026-01-29T14:08:58.707Z
9269351 9269351 20260128130403_wXb5d NZ003C 2026-01-29T14:07:31.572Z 2026-01-29T14:07:31.572Z
9269338 9269338 20260128130321_RQd97 NZ003C 2026-01-29T14:07:29.785Z 2026-01-29T14:07:29.785Z
9269335 9269335 20260128130314_zWEtF NZ003C 2026-01-29T14:07:29.237Z 2026-01-29T14:07:29.237Z
9269222 9269222 20260128124612_os2YS NZ003C 2026-01-29T14:07:02.451Z 2026-01-29T14:07:02.451Z
9269217 9269217 20260128124611_rVKGG NZ003C 2026-01-29T14:07:01.849Z 2026-01-29T14:07:01.849Z
9269195 9269195 20260128124432_6HF5v NZ003C 2026-01-29T14:06:56.886Z 2026-01-29T14:06:56.886Z
9269173 9269173 20260128124126_NG3dz NZ003C 2026-01-29T14:06:52.991Z 2026-01-29T14:06:52.991Z
9269102 9269102 20260128122733_ITjjZ NZ003C 2026-01-29T14:06:31.308Z 2026-01-29T14:06:31.308Z
9268987 9268987 20260128115724_zghWs NZ003C 2026-01-29T14:05:51.972Z 2026-01-29T14:05:51.972Z
9268911 9268911 20260128114306_roqnR NZ003C 2026-01-29T14:05:27.247Z 2026-01-29T14:05:27.247Z
9268889 9268889 20260128113818_2Qsfr NZ003C 2026-01-29T14:05:19.767Z 2026-01-29T14:05:19.767Z
9268718 9268718 20260128110710_Fq9GC NZ003C 2026-01-29T14:04:32.649Z 2026-01-29T14:04:32.649Z
9268408 9268408 20260128100729_VZ7FN NZ003C 2026-01-29T14:02:51.332Z 2026-01-29T14:02:51.332Z
9262093 9262093 20260126160239_JH0hi NZ003C 2026-01-27T14:07:31.781Z 2026-01-29T14:33:39.812Z
9261927 9261927 20260126144442_PMnab NZ003C 2026-01-27T14:06:30.898Z 2026-01-29T14:33:17.467Z
9253854 9253854 20260124151746_opF2Y NZ003C 2026-01-25T14:04:42.662Z 2026-01-29T14:41:43.174Z
9253744 9253744 20260124142053_VOHeP NZ003C 2026-01-25T14:04:13.187Z 2026-01-29T14:41:23.128Z
9253680 9253680 20260124134004_XTRE8 NZ003C 2026-01-25T14:03:55.797Z 2026-01-29T14:41:16.227Z
9253604 9253604 20260124130033_GbWcL NZ003C 2026-01-25T14:03:29.646Z 2026-01-29T14:41:02.504Z
9253530 9253530 20260124123010_e0Vfs NZ003C 2026-01-25T14:03:12.641Z 2026-01-29T14:40:55.758Z
9253427 9253427 20260124114228_aHC3N NZ003C 2026-01-25T14:02:40.631Z 2026-01-29T14:40:48.983Z
9253399 9253399 20260124113054_wwgu6 NZ003C 2026-01-25T14:02:32.820Z 2026-01-29T14:40:46.999Z
9253201 9253201 20260124100918_gFAJ4 NZ003C 2026-01-25T14:01:17.704Z 2026-01-29T14:40:26.410Z
9250492 9250492 20260123153504_c5WpO NZ003C 2026-01-24T14:03:13.804Z 2026-01-29T14:45:40.914Z
9250409 9250409 20260123142659_N2l0e NZ003C 2026-01-24T14:02:47.151Z 2026-01-29T14:45:31.773Z
9250405 9250405 20260123142508_wp9RD NZ003C 2026-01-24T14:02:45.551Z 2026-01-29T14:45:31.367Z
9250350 9250350 20260123133412_KJr83 NZ003C 2026-01-24T14:02:28.516Z 2026-01-29T14:45:25.734Z
9250076 9250076 20260123100651_CJJhG NZ003C 2026-01-24T14:01:01.295Z 2026-01-29T14:44:57.283Z
9249999 9249999 20260123093359_PmkJP NZ003C 2026-01-24T14:00:32.949Z 2026-01-29T14:44:47.119Z
9249960 9249960 20260123091540_zm399 NZ003C 2026-01-24T14:00:21.014Z 2026-01-29T14:44:45.153Z
9249941 9249941 20260123090425_j9P0w NZ003C 2026-01-24T14:00:13.852Z 2026-01-29T14:44:43.986Z
9246031 9246031 20260122160430_uBPqJ NZ003C 2026-01-23T14:04:26.953Z 2026-01-29T14:50:38.136Z
9245982 9245982 20260122155444_Nn2c5 NZ003C 2026-01-23T14:04:12.436Z 2026-01-29T14:50:28.445Z
9245918 9245918 20260122152931_gQ67C NZ003C 2026-01-23T14:04:01.904Z 2026-01-29T14:50:22.527Z
9245906 9245906 20260122152425_oAGn9 NZ003C 2026-01-23T14:04:00.104Z 2026-01-29T14:50:21.781Z
9245882 9245882 20260122151410_xHw6f NZ003C 2026-01-23T14:03:56.312Z 2026-01-29T14:50:20.581Z
9245871 9245871 20260122150629_cvAis NZ003C 2026-01-23T14:03:48.422Z 2026-01-29T14:50:19.437Z
9245860 9245860 20260122150405_2rTEt NZ003C 2026-01-23T14:03:46.322Z 2026-01-29T14:50:18.664Z
9245707 9245707 20260122135628_duoZd NZ003C 2026-01-23T14:03:04.093Z 2026-01-29T14:49:58.813Z
9245687 9245687 20260122134511_Oboy3 NZ003C 2026-01-23T14:02:59.842Z 2026-01-29T14:49:57.405Z
9245655 9245655 20260122133548_IiRRz NZ003C 2026-01-23T14:02:53.681Z 2026-01-29T14:49:53.510Z
9245608 9245608 20260122132157_TK1fA NZ003C 2026-01-23T14:02:36.972Z 2026-01-23T14:02:36.972Z
9245603 9245603 20260122132117_Bq3H2 NZ003C 2026-01-23T14:02:35.927Z 2026-01-29T14:49:50.428Z
9245583 9245583 20260122131304_7Bh61 NZ003C 2026-01-23T14:02:28.215Z 2026-01-29T14:49:49.050Z
9245559 9245559 20260122130523_UGWcd NZ003C 2026-01-23T14:02:23.846Z 2026-01-29T14:49:47.260Z
9245557 9245557 20260122130444_nGDcs NZ003C 2026-01-23T14:02:23.347Z 2026-01-29T14:49:46.951Z
9245546 9245546 20260122125845_1WBqB NZ003C 2026-01-23T14:02:20.727Z 2026-01-29T14:49:46.106Z
9245538 9245538 20260122125712_TLV89 NZ003C 2026-01-23T14:02:19.490Z 2026-01-29T14:49:45.707Z
9245504 9245504 20260122124908_KR405 NZ003C 2026-01-23T14:02:14.554Z 2026-01-29T14:49:44.672Z
9245486 9245486 20260122124409_Pnjbm NZ003C 2026-01-23T14:02:11.166Z 2026-01-29T14:49:43.502Z
9245227 9245227 20260122112112_gEyvn NZ003C 2026-01-23T14:01:08.161Z 2026-01-29T14:49:16.201Z
9245204 9245204 20260122111345_9Xf4p NZ003C 2026-01-23T14:01:01.562Z 2026-01-29T14:49:14.533Z
9245173 9245173 20260122105525_fFPzL NZ003C 2026-01-23T14:00:52.325Z 2026-01-23T14:00:52.325Z
9245171 9245171 20260122105258_5qnnd NZ003C 2026-01-23T14:00:51.833Z 2026-01-29T14:49:10.939Z
9245151 9245151 20260122103820_WZ40d NZ003C 2026-01-23T14:00:48.388Z 2026-01-29T14:49:05.243Z
9245136 9245136 20260122102916_2PQA0 NZ003C 2026-01-23T14:00:45.312Z 2026-01-29T14:49:03.883Z
9245105 9245105 20260122101356_MyJnk NZ003C 2026-01-23T14:00:34.888Z 2026-01-23T14:00:34.888Z
9245053 9245053 20260122094442_sdP8v NZ003C 2026-01-23T14:00:18.626Z 2026-01-29T14:48:54.116Z
9197259 9197259 20260113103852_TL7tw NZ003C 2026-01-14T14:22:09.224Z 2026-01-21T15:06:15.939Z
9196854 9196854 20260113091525_bFaSQ NZ003C 2026-01-14T14:20:20.570Z 2026-01-21T15:06:01.152Z
9187188 9187188 20260111153604_x5H1t NZ003C 2026-01-13T14:06:02.082Z 2026-01-20T15:20:06.794Z
9187087 9187087 20260111150705_aayFw NZ003C 2026-01-13T14:05:23.385Z 2026-01-20T15:19:58.704Z
9187017 9187017 20260111144452_U3mV8 NZ003C 2026-01-13T14:04:56.752Z 2026-01-20T15:19:53.076Z
9186947 9186947 20260111142920_J2agy NZ003C 2026-01-13T14:04:26.048Z 2026-01-20T15:19:36.905Z
9185947 9185947 20260111140007_COGSi NZ003C 2026-01-12T14:26:22.221Z 2026-01-19T15:22:07.889Z
9185689 9185689 20260111123210_gb8y6 NZ003C 2026-01-12T14:25:40.094Z 2026-01-19T15:21:19.728Z
9185641 9185641 20260111122028_tgG1S NZ003C 2026-01-12T14:25:23.371Z 2026-01-19T15:21:13.891Z
9185626 9185626 20260111121622_djZ24 NZ003C 2026-01-12T14:25:19.836Z 2026-01-19T15:21:12.157Z
9185482 9185482 20260111111937_9tTTV NZ003C 2026-01-12T14:25:02.818Z 2026-01-19T15:20:54.992Z
9184152 9184152 20260111104851_xeMEV NZ003C 2026-01-12T14:19:48.200Z 2026-01-19T15:20:25.117Z
9184110 9184110 20260111104536_UMwLa NZ003C 2026-01-12T14:19:42.709Z 2026-01-19T15:20:22.881Z
9184082 9184082 20260111103905_T2BR3 NZ003C 2026-01-12T14:19:37.655Z 2026-01-19T15:20:21.335Z
9183597 9183597 20260111094929_GQ9se NZ003C 2026-01-12T14:18:17.323Z 2026-01-19T15:19:47.253Z
9183589 9183589 20260111094808_qgSK6 NZ003C 2026-01-12T14:18:15.548Z 2026-01-19T15:19:47.033Z
9183540 9183540 20260111094053_gGNJw NZ003C 2026-01-12T14:18:04.397Z 2026-01-19T15:19:45.035Z
9173600 9173600 20260109150209_XRCMa NZ003C 2026-01-10T14:18:13.937Z 2026-01-17T15:26:54.045Z
9173590 9173590 20260109145741_Y26Ut NZ003C 2026-01-10T14:18:11.829Z 2026-01-17T15:26:53.612Z
9173562 9173562 20260109145104_ni93E NZ003C 2026-01-10T14:18:04.308Z 2026-01-17T15:26:50.522Z
9173473 9173473 20260109142250_Z6z2q NZ003C 2026-01-10T14:17:45.158Z 2026-01-17T15:26:45.053Z
9173424 9173424 20260109140750_oXvG7 NZ003C 2026-01-10T14:17:29.043Z 2026-01-17T15:26:42.794Z
9173377 9173377 20260109135309_gIzBa NZ003C 2026-01-10T14:17:21.163Z 2026-01-17T15:26:41.279Z
9173321 9173321 20260109133828_f1tC4 NZ003C 2026-01-10T14:17:04.621Z 2026-01-17T15:26:38.897Z
9173315 9173315 20260109133820_3hYI3 NZ003C 2026-01-10T14:17:03.979Z 2026-01-17T15:26:38.611Z
9173190 9173190 20260109131924_BSFAW NZ003C 2026-01-10T14:16:38.636Z 2026-01-17T15:26:22.793Z
9173180 9173180 20260109131706_CjBkp NZ003C 2026-01-10T14:16:34.793Z 2026-01-17T15:26:22.383Z
9172940 9172940 20260109123220_NwCuF NZ003C 2026-01-10T14:15:30.158Z 2026-01-17T15:26:08.850Z
9172892 9172892 20260109122307_QW7zS NZ003C 2026-01-10T14:15:19.444Z 2026-01-17T15:26:06.832Z
9172880 9172880 20260109122116_Icsjo NZ003C 2026-01-10T14:15:14.168Z 2026-01-17T15:26:06.408Z
9172765 9172765 20260109114950_sbv23 NZ003C 2026-01-10T14:14:42.602Z 2026-01-17T15:25:51.731Z

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