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

5,540 rows where station_code = "NZ002D" 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
9270594 9270594 20260128160924_ImpKX NZ002D 2026-01-29T14:12:54.171Z 2026-01-29T14:12:54.171Z
9270563 9270563 20260128160159_2bzPs NZ002D 2026-01-29T14:12:46.940Z 2026-01-29T14:12:46.940Z
9270556 9270556 20260128160044_dja87 NZ002D 2026-01-29T14:12:45.380Z 2026-01-29T14:12:45.380Z
9270528 9270528 20260128155810_jrsJ2 NZ002D 2026-01-29T14:12:32.576Z 2026-01-29T14:12:32.576Z
9270520 9270520 20260128155725_zIdEw NZ002D 2026-01-29T14:12:31.602Z 2026-01-29T14:12:31.602Z
9270510 9270510 20260128155718_xgOeL NZ002D 2026-01-29T14:12:30.240Z 2026-01-29T14:12:30.240Z
9270502 9270502 20260128155652_L2ia3 NZ002D 2026-01-29T14:12:27.512Z 2026-01-29T14:12:27.512Z
9270410 9270410 20260128154541_1Prlx NZ002D 2026-01-29T14:12:10.746Z 2026-01-29T14:12:10.746Z
9270365 9270365 20260128153946_TGSio NZ002D 2026-01-29T14:11:57.274Z 2026-01-29T14:11:57.274Z
9270329 9270329 20260128153238_t2uM6 NZ002D 2026-01-29T14:11:47.007Z 2026-01-29T14:11:47.007Z
9270303 9270303 20260128152958_BZ6Ef NZ002D 2026-01-29T14:11:42.487Z 2026-01-29T14:11:42.487Z
9270245 9270245 20260128152023_CkuUd NZ002D 2026-01-29T14:11:24.261Z 2026-01-29T14:11:24.261Z
9270230 9270230 20260128151845_iBDIW NZ002D 2026-01-29T14:11:22.545Z 2026-01-29T14:11:22.545Z
9270225 9270225 20260128151823_VRFwi NZ002D 2026-01-29T14:11:21.944Z 2026-01-29T14:11:21.944Z
9270162 9270162 20260128150446_3w2gM NZ002D 2026-01-29T14:11:09.755Z 2026-01-29T14:11:09.755Z
9270064 9270064 20260128145132_veUaf NZ002D 2026-01-29T14:10:46.230Z 2026-01-29T14:10:46.230Z
9270047 9270047 20260128145058_Zs3KN NZ002D 2026-01-29T14:10:44.121Z 2026-01-29T14:10:44.121Z
9269968 9269968 20260128143811_ng788 NZ002D 2026-01-29T14:10:22.306Z 2026-01-29T14:10:22.306Z
9269840 9269840 20260128142311_dCQU7 NZ002D 2026-01-29T14:09:51.620Z 2026-01-29T14:09:51.620Z
9269762 9269762 20260128141001_4HtxC NZ002D 2026-01-29T14:09:32.769Z 2026-01-29T14:09:32.769Z
9269631 9269631 20260128134714_2A225 NZ002D 2026-01-29T14:08:54.308Z 2026-01-29T14:08:54.308Z
9269588 9269588 20260128133957_4qAYK NZ002D 2026-01-29T14:08:39.122Z 2026-01-29T14:08:39.122Z
9269443 9269443 20260128131858_P1520 NZ002D 2026-01-29T14:08:00.536Z 2026-01-29T14:08:00.536Z
9269333 9269333 20260128130314_zWEtF NZ002D 2026-01-29T14:07:29.236Z 2026-01-29T14:07:29.236Z
9269220 9269220 20260128124612_os2YS NZ002D 2026-01-29T14:07:02.451Z 2026-01-29T14:07:02.451Z
9269194 9269194 20260128124432_6HF5v NZ002D 2026-01-29T14:06:56.886Z 2026-01-29T14:06:56.886Z
9269006 9269006 20260128120025_v5vbG NZ002D 2026-01-29T14:06:00.456Z 2026-01-29T14:06:00.456Z
9268986 9268986 20260128115724_zghWs NZ002D 2026-01-29T14:05:51.972Z 2026-01-29T14:05:51.972Z
9268980 9268980 20260128115724_ugQy8 NZ002D 2026-01-29T14:05:50.769Z 2026-01-29T14:05:50.769Z
9268975 9268975 20260128115614_rBkA3 NZ002D 2026-01-29T14:05:49.599Z 2026-01-29T14:05:49.599Z
9268910 9268910 20260128114306_roqnR NZ002D 2026-01-29T14:05:27.247Z 2026-01-29T14:05:27.247Z
9268829 9268829 20260128113126_dyStx NZ002D 2026-01-29T14:05:06.749Z 2026-01-29T14:05:06.749Z
9268659 9268659 20260128110008_tCrC2 NZ002D 2026-01-29T14:04:16.544Z 2026-01-29T14:04:16.544Z
9268639 9268639 20260128105715_kKHbO NZ002D 2026-01-29T14:04:09.079Z 2026-01-29T14:04:09.079Z
9268513 9268513 20260128104051_ePKU4 NZ002D 2026-01-29T14:03:28.394Z 2026-01-29T14:03:28.394Z
9268257 9268257 20260128093249_ZUJ7l NZ002D 2026-01-29T14:02:06.059Z 2026-01-29T14:02:06.059Z
9268156 9268156 20260128090605_Onh32 NZ002D 2026-01-29T14:01:26.245Z 2026-01-29T14:01:26.245Z
9265875 9265875 20260127160938_6SM1C NZ002D 2026-01-28T14:11:39.037Z 2026-01-29T14:30:24.705Z
9265808 9265808 20260127160130_EsNes NZ002D 2026-01-28T14:11:25.282Z 2026-01-29T14:30:24.681Z
9265762 9265762 20260127155706_BnQKw NZ002D 2026-01-28T14:11:16.657Z 2026-01-29T14:30:24.670Z
9265725 9265725 20260127155337_IfKU8 NZ002D 2026-01-28T14:11:09.322Z 2026-01-29T14:30:24.662Z
9265704 9265704 20260127155027_sk9o1 NZ002D 2026-01-28T14:11:02.778Z 2026-01-29T14:30:24.658Z
9265655 9265655 20260127154547_YG9En NZ002D 2026-01-28T14:10:52.685Z 2026-01-29T14:30:24.647Z
9265486 9265486 20260127152137_HLKtJ NZ002D 2026-01-28T14:10:21.771Z 2026-01-29T14:30:24.591Z
9265297 9265297 20260127145813_EUpqd NZ002D 2026-01-28T14:09:45.823Z 2026-01-29T14:30:24.522Z
9265280 9265280 20260127145528_93wPr NZ002D 2026-01-28T14:09:44.610Z 2026-01-29T14:30:24.520Z
9265242 9265242 20260127144831_FUzGb NZ002D 2026-01-28T14:09:38.207Z 2026-01-29T14:30:24.513Z
9265206 9265206 20260127143813_jAAVj NZ002D 2026-01-28T14:09:28.287Z 2026-01-29T14:30:24.502Z
9265198 9265198 20260127143613_7ORjC NZ002D 2026-01-28T14:09:25.642Z 2026-01-29T14:30:24.499Z
9265194 9265194 20260127143420_Xk2Sr NZ002D 2026-01-28T14:09:25.007Z 2026-01-29T14:30:24.498Z
9265175 9265175 20260127143118_X62ga NZ002D 2026-01-28T14:09:20.502Z 2026-01-29T14:30:24.494Z
9265156 9265156 20260127142558_4O8Ww NZ002D 2026-01-28T14:09:15.044Z 2026-01-29T14:30:24.470Z
9265137 9265137 20260127142429_Y6wcY NZ002D 2026-01-28T14:09:11.806Z 2026-01-29T14:30:24.458Z
9265105 9265105 20260127141917_ZSLMQ NZ002D 2026-01-28T14:09:03.458Z 2026-01-29T14:30:24.449Z
9265007 9265007 20260127135434_KyL2j NZ002D 2026-01-28T14:08:36.003Z 2026-01-29T14:30:24.412Z
9264941 9264941 20260127133939_hO4Lu NZ002D 2026-01-28T14:08:19.702Z 2026-01-29T14:30:24.396Z
9264932 9264932 20260127133931_GDtEN NZ002D 2026-01-28T14:08:19.042Z 2026-01-29T14:30:24.395Z
9264869 9264869 20260127132646_m23Dn NZ002D 2026-01-28T14:08:02.955Z 2026-01-29T14:30:24.317Z
9264792 9264792 20260127131331_3w6cC NZ002D 2026-01-28T14:07:41.956Z 2026-01-29T14:30:24.293Z
9264780 9264780 20260127131045_9vP3P NZ002D 2026-01-28T14:07:35.948Z 2026-01-29T14:30:24.290Z
9264634 9264634 20260127125117_roMKc NZ002D 2026-01-28T14:06:58.447Z 2026-01-29T14:30:24.234Z
9264590 9264590 20260127124904_B4bCv NZ002D 2026-01-28T14:06:47.822Z 2026-01-29T14:30:24.225Z
9264554 9264554 20260127124531_MHfqx NZ002D 2026-01-28T14:06:39.529Z 2026-01-29T14:30:24.210Z
9264483 9264483 20260127123056_ivTDl NZ002D 2026-01-28T14:06:18.741Z 2026-01-29T14:30:24.183Z
9264478 9264478 20260127123044_tCmto NZ002D 2026-01-28T14:06:18.117Z 2026-01-29T14:30:24.182Z
9264432 9264432 20260127122100_02WUs NZ002D 2026-01-28T14:06:07.163Z 2026-01-29T14:30:21.707Z
9264400 9264400 20260127121415_1g7Uz NZ002D 2026-01-28T14:05:54.938Z 2026-01-29T14:30:21.196Z
9264391 9264391 20260127121149_DUjrB NZ002D 2026-01-28T14:05:49.414Z 2026-01-29T14:30:21.193Z
9264376 9264376 20260127120901_SRCPJ NZ002D 2026-01-28T14:05:45.080Z 2026-01-29T14:30:21.187Z
9261983 9261983 20260126150455_DaiKs NZ002D 2026-01-27T14:06:53.102Z 2026-01-29T14:33:22.318Z
9261926 9261926 20260126144442_PMnab NZ002D 2026-01-27T14:06:30.898Z 2026-01-29T14:33:17.467Z
9261256 9261256 20260126104932_0bQNQ NZ002D 2026-01-27T14:02:51.777Z 2026-01-29T14:32:08.599Z
9253074 9253074 20260124090320_smfHl NZ002D 2026-01-25T14:00:31.954Z 2026-01-29T14:40:13.695Z
9249940 9249940 20260123090425_j9P0w NZ002D 2026-01-24T14:00:13.852Z 2026-01-29T14:44:43.986Z
9246022 9246022 20260122160233_mfVvA NZ002D 2026-01-23T14:04:23.440Z 2026-01-29T14:50:36.840Z
9246005 9246005 20260122155849_ba4dt NZ002D 2026-01-23T14:04:19.427Z 2026-01-29T14:50:29.245Z
9246000 9246000 20260122155705_ZG3x9 NZ002D 2026-01-23T14:04:15.731Z 2026-01-29T14:50:29.145Z
9245964 9245964 20260122154936_valBj NZ002D 2026-01-23T14:04:10.016Z 2026-01-29T14:50:27.352Z
9245960 9245960 20260122154544_y3n3G NZ002D 2026-01-23T14:04:09.194Z 2026-01-23T14:04:09.194Z
9245947 9245947 20260122154219_y5WgC NZ002D 2026-01-23T14:04:07.444Z 2026-01-29T14:50:26.464Z
9245936 9245936 20260122153714_HyFMH NZ002D 2026-01-23T14:04:05.468Z 2026-01-29T14:50:25.863Z
9245925 9245925 20260122153552_dLsVj NZ002D 2026-01-23T14:04:03.602Z 2026-01-29T14:50:25.264Z
9245905 9245905 20260122152425_oAGn9 NZ002D 2026-01-23T14:04:00.104Z 2026-01-29T14:50:21.781Z
9245900 9245900 20260122152330_dawHP NZ002D 2026-01-23T14:03:59.368Z 2026-01-29T14:50:21.518Z
9227005 9227005 20260119135620_4YteU NZ002D 2026-01-20T14:06:10.327Z 2026-01-28T14:55:46.577Z
9227002 9227002 20260119135443_zc3qY NZ002D 2026-01-20T14:06:06.173Z 2026-01-28T14:55:46.391Z
9226946 9226946 20260119133440_DkgIT NZ002D 2026-01-20T14:05:48.340Z 2026-01-28T14:55:43.252Z
9219602 9219602 20260117111632_DgLbc NZ002D 2026-01-18T14:17:07.206Z 2026-01-25T14:59:33.102Z
9219325 9219325 20260117095706_cw2pa NZ002D 2026-01-18T14:15:56.447Z 2026-01-25T14:59:10.606Z
9219253 9219253 20260117094059_KOkZ3 NZ002D 2026-01-18T14:15:41.227Z 2026-01-25T14:59:08.740Z
9196853 9196853 20260113091525_bFaSQ NZ002D 2026-01-14T14:20:20.570Z 2026-01-21T15:06:01.152Z
9193098 9193098 20260112133646_hr4ts NZ002D 2026-01-13T14:30:10.033Z 2026-01-20T15:26:59.500Z
9193021 9193021 20260112132758_iiBhw NZ002D 2026-01-13T14:30:00.106Z 2026-01-20T15:26:56.548Z
9192964 9192964 20260112132043_Vn5kW NZ002D 2026-01-13T14:29:48.753Z 2026-01-20T15:26:46.563Z
9192889 9192889 20260112131302_25KVx NZ002D 2026-01-13T14:29:35.992Z 2026-01-20T15:26:38.544Z
9192817 9192817 20260112130437_FgH6o NZ002D 2026-01-13T14:29:21.735Z 2026-01-20T15:26:34.216Z
9192804 9192804 20260112130304_E6jhK NZ002D 2026-01-13T14:29:20.713Z 2026-01-20T15:26:33.970Z
9192775 9192775 20260112130044_jOTMe NZ002D 2026-01-13T14:29:14.404Z 2026-01-20T15:26:32.789Z
9192486 9192486 20260112123834_7DQ1r NZ002D 2026-01-13T14:28:28.326Z 2026-01-20T15:26:23.200Z
9192432 9192432 20260112123419_ey1Yu NZ002D 2026-01-13T14:28:20.798Z 2026-01-20T15:26:22.111Z

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