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

513 rows where station_code = "NZ005T" 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
9270661 9270661 20260128161832_Ke2nk NZ005T 2026-01-29T14:13:13.867Z 2026-01-29T14:13:13.867Z
9270615 9270615 20260128161328_RFMAX NZ005T 2026-01-29T14:13:01.759Z 2026-01-29T14:13:01.759Z
9270560 9270560 20260128160044_dqWE9 NZ005T 2026-01-29T14:12:45.890Z 2026-01-29T14:12:45.890Z
9270495 9270495 20260128155625_hrOrN NZ005T 2026-01-29T14:12:25.974Z 2026-01-29T14:12:25.974Z
9270393 9270393 20260128154217_dUeiz NZ005T 2026-01-29T14:12:01.086Z 2026-01-29T14:12:01.086Z
9270388 9270388 20260128154156_YEEuR NZ005T 2026-01-29T14:12:00.539Z 2026-01-29T14:12:00.539Z
9270354 9270354 20260128153538_QwZ1T NZ005T 2026-01-29T14:11:51.465Z 2026-01-29T14:11:51.465Z
9270210 9270210 20260128151450_TaQn7 NZ005T 2026-01-29T14:11:19.425Z 2026-01-29T14:11:19.425Z
9270204 9270204 20260128151420_LVv0Y NZ005T 2026-01-29T14:11:18.161Z 2026-01-29T14:11:18.161Z
9270086 9270086 20260128145214_LGSv3 NZ005T 2026-01-29T14:10:48.381Z 2026-01-29T14:10:48.381Z
9270033 9270033 20260128144940_CZ2bS NZ005T 2026-01-29T14:10:41.624Z 2026-01-29T14:10:41.624Z
9270027 9270027 20260128144920_AvmgM NZ005T 2026-01-29T14:10:40.669Z 2026-01-29T14:10:40.669Z
9269942 9269942 20260128143512_eRJO2 NZ005T 2026-01-29T14:10:17.701Z 2026-01-29T14:10:17.701Z
9269611 9269611 20260128134446_w8Rev NZ005T 2026-01-29T14:08:50.612Z 2026-01-29T14:08:50.612Z
9269355 9269355 20260128130403_E3kme NZ005T 2026-01-29T14:07:31.986Z 2026-01-29T14:07:31.986Z
9269216 9269216 20260128124611_SnyEL NZ005T 2026-01-29T14:07:01.252Z 2026-01-29T14:07:01.252Z
9269088 9269088 20260128122129_OPnqi NZ005T 2026-01-29T14:06:27.058Z 2026-01-29T14:06:27.058Z
9268791 9268791 20260128112243_UrcPx NZ005T 2026-01-29T14:04:52.989Z 2026-01-29T14:04:52.989Z
9268540 9268540 20260128104339_VaQwK NZ005T 2026-01-29T14:03:36.004Z 2026-01-29T14:03:36.004Z
9261953 9261953 20260126145650_gHmxq NZ005T 2026-01-27T14:06:44.730Z 2026-01-29T14:33:20.161Z
9253402 9253402 20260124113054_wwgu6 NZ005T 2026-01-25T14:02:32.820Z 2026-01-29T14:40:47.000Z
9250474 9250474 20260123152927_2bWu2 NZ005T 2026-01-24T14:03:07.771Z 2026-01-29T14:45:37.825Z
9250001 9250001 20260123093359_PmkJP NZ005T 2026-01-24T14:00:32.949Z 2026-01-29T14:44:47.119Z
9249962 9249962 20260123091540_zm399 NZ005T 2026-01-24T14:00:21.021Z 2026-01-29T14:44:45.153Z
9245774 9245774 20260122142129_ss3Kf NZ005T 2026-01-23T14:03:27.412Z 2026-01-29T14:50:10.934Z
9245756 9245756 20260122141355_IqEZW NZ005T 2026-01-23T14:03:22.566Z 2026-01-29T14:50:08.831Z
9245726 9245726 20260122140330_m4SX9 NZ005T 2026-01-23T14:03:09.777Z 2026-01-29T14:50:00.303Z
9245721 9245721 20260122140134_iyBxr NZ005T 2026-01-23T14:03:07.384Z 2026-01-29T14:49:59.809Z
9245611 9245611 20260122132157_TK1fA NZ005T 2026-01-23T14:02:36.972Z 2026-01-23T14:02:36.972Z
9245506 9245506 20260122124908_KR405 NZ005T 2026-01-23T14:02:14.554Z 2026-01-29T14:49:44.672Z
9245321 9245321 20260122114546_UYyWZ NZ005T 2026-01-23T14:01:29.288Z 2026-01-29T14:49:23.809Z
9245132 9245132 20260122102434_Gy4J3 NZ005T 2026-01-23T14:00:44.182Z 2026-01-29T14:49:03.536Z
9210200 9210200 20260115122149_U870Q NZ005T 2026-01-16T14:19:01.232Z 2026-01-22T15:05:50.694Z
9186950 9186950 20260111142920_J2agy NZ005T 2026-01-13T14:04:26.048Z 2026-01-20T15:19:36.905Z
9185948 9185948 20260111140007_COGSi NZ005T 2026-01-12T14:26:22.221Z 2026-01-19T15:22:07.889Z
9184972 9184972 20260111124857_38SNY NZ005T 2026-01-12T14:22:06.510Z 2026-01-19T15:21:42.988Z
9184945 9184945 20260111124349_hn04Y NZ005T 2026-01-12T14:22:03.343Z 2026-01-19T15:21:42.029Z
9184855 9184855 20260111122822_weHKi NZ005T 2026-01-12T14:21:46.403Z 2026-01-19T15:21:18.639Z
9184795 9184795 20260111122028_tKfC5 NZ005T 2026-01-12T14:21:36.214Z 2026-01-19T15:21:14.051Z
9184765 9184765 20260111121723_61abF NZ005T 2026-01-12T14:21:33.031Z 2026-01-19T15:21:12.487Z
9184758 9184758 20260111121622_dDidQ NZ005T 2026-01-12T14:21:31.832Z 2026-01-19T15:21:12.226Z
9184613 9184613 20260111115702_lIsan NZ005T 2026-01-12T14:21:08.289Z 2026-01-19T15:21:05.569Z
9184609 9184609 20260111115642_UXM3r NZ005T 2026-01-12T14:21:07.588Z 2026-01-19T15:21:05.427Z
9183600 9183600 20260111094929_GQ9se NZ005T 2026-01-12T14:18:17.323Z 2026-01-19T15:19:47.253Z
9183552 9183552 20260111094344_HR32R NZ005T 2026-01-12T14:18:06.957Z 2026-01-19T15:19:45.708Z
9179207 9179207 20260111144124_82HEG NZ005T 2026-01-12T14:00:39.639Z 2026-01-20T15:19:52.267Z
9179197 9179197 20260111143639_Up2kf NZ005T 2026-01-12T14:00:38.167Z 2026-01-20T15:19:40.678Z
9179144 9179144 20260111142450_o7Ru0 NZ005T 2026-01-12T14:00:25.801Z 2026-01-20T15:19:33.585Z
9179132 9179132 20260111142034_r7S0X NZ005T 2026-01-12T14:00:23.452Z 2026-01-20T15:19:32.584Z
9174173 9174173 20260110154618_cGX2b NZ005T 2026-01-11T14:01:39.275Z 2026-01-19T15:14:39.345Z
9173566 9173566 20260109145104_ni93E NZ005T 2026-01-10T14:18:04.309Z 2026-01-17T15:26:50.522Z
9173516 9173516 20260109143135_SMAWv NZ005T 2026-01-10T14:17:51.363Z 2026-01-17T15:26:46.178Z
9173476 9173476 20260109142250_Z6z2q NZ005T 2026-01-10T14:17:45.158Z 2026-01-17T15:26:45.053Z
9173327 9173327 20260109133828_f1tC4 NZ005T 2026-01-10T14:17:04.621Z 2026-01-17T15:26:38.897Z
9173317 9173317 20260109133820_3hYI3 NZ005T 2026-01-10T14:17:03.979Z 2026-01-17T15:26:38.611Z
9173064 9173064 20260109125259_w223q NZ005T 2026-01-10T14:15:59.560Z 2026-01-17T15:26:13.875Z
9172943 9172943 20260109123220_NwCuF NZ005T 2026-01-10T14:15:30.158Z 2026-01-17T15:26:08.850Z
9172881 9172881 20260109122116_Icsjo NZ005T 2026-01-10T14:15:14.168Z 2026-01-17T15:26:06.408Z
9172849 9172849 20260109120919_D6t0M NZ005T 2026-01-10T14:15:05.904Z 2026-01-17T15:26:04.818Z
9172821 9172821 20260109120254_n8lgf NZ005T 2026-01-10T14:14:56.306Z 2026-01-17T15:26:03.583Z
9172433 9172433 20260109104014_AlQoi NZ005T 2026-01-10T14:13:19.182Z 2026-01-17T15:25:33.386Z
9172406 9172406 20260109103421_S01Ie NZ005T 2026-01-10T14:13:11.059Z 2026-01-17T15:25:25.033Z
9172311 9172311 20260109095924_2ENaK NZ005T 2026-01-10T14:12:44.058Z 2026-01-17T15:25:18.920Z
9172186 9172186 20260109092250_Yn9Wc NZ005T 2026-01-10T14:12:05.540Z 2026-01-17T15:25:10.630Z
9172171 9172171 20260109092009_td8bc NZ005T 2026-01-10T14:12:03.522Z 2026-01-17T15:25:10.132Z
9170546 9170546 20260109154012_blMBX NZ005T 2026-01-10T14:01:13.002Z 2026-01-18T15:06:27.442Z
9170523 9170523 20260109153600_nnmJ1 NZ005T 2026-01-10T14:01:02.003Z 2026-01-18T15:06:26.057Z
9170481 9170481 20260109153026_9lyC2 NZ005T 2026-01-10T14:00:48.734Z 2026-01-18T15:06:24.216Z
9170424 9170424 20260109151252_Cz2ci NZ005T 2026-01-10T14:00:27.467Z 2026-01-18T15:06:20.376Z
9170386 9170386 20260109150605_idm3p NZ005T 2026-01-10T14:00:12.205Z 2026-01-18T15:06:19.056Z
9169391 9169391 20260108142311_pJScD NZ005T 2026-01-09T14:13:28.198Z 2026-01-16T15:13:55.672Z
9168356 9168356 20260108104622_HguVn NZ005T 2026-01-09T14:10:56.613Z 2026-01-16T15:12:32.067Z
9168331 9168331 20260108103850_ylg2g NZ005T 2026-01-09T14:10:52.441Z 2026-01-16T15:12:30.693Z
9168314 9168314 20260108103501_VKAPC NZ005T 2026-01-09T14:10:50.510Z 2026-01-16T15:12:28.853Z
9168270 9168270 20260108102714_DoaO3 NZ005T 2026-01-09T14:10:44.329Z 2026-01-16T15:12:26.679Z
9168036 9168036 20260108093120_AJTUx NZ005T 2026-01-09T14:10:10.682Z 2026-01-16T15:12:15.527Z
9168019 9168019 20260108092351_gu512 NZ005T 2026-01-09T14:10:06.031Z 2026-01-16T15:12:14.649Z
9165373 9165373 20260107153439_OmEkA NZ005T 2026-01-08T14:16:14.395Z 2026-01-13T15:05:50.201Z
9165291 9165291 20260107152506_oTzD8 NZ005T 2026-01-08T14:15:56.751Z 2026-01-13T15:05:38.692Z
9165243 9165243 20260107152126_bEm7J NZ005T 2026-01-08T14:15:45.219Z 2026-01-13T15:05:36.452Z
9165114 9165114 20260107150733_rTHQK NZ005T 2026-01-08T14:15:25.863Z 2026-01-13T15:05:29.063Z
9165064 9165064 20260107150029_gnP6D NZ005T 2026-01-08T14:15:17.211Z 2026-01-13T15:05:27.091Z
9164887 9164887 20260107144015_z7i0e NZ005T 2026-01-08T14:14:38.206Z 2026-01-13T15:05:09.971Z
9164855 9164855 20260107143143_9jnEH NZ005T 2026-01-08T14:14:30.116Z 2026-01-13T15:05:08.068Z
9164811 9164811 20260107142736_RGd3V NZ005T 2026-01-08T14:14:24.454Z 2026-01-13T15:05:06.101Z
9164772 9164772 20260107142340_7KaHj NZ005T 2026-01-08T14:14:18.588Z 2026-01-13T15:05:03.257Z
9164753 9164753 20260107142024_770I2 NZ005T 2026-01-08T14:14:14.140Z 2026-01-13T15:05:01.700Z
9164707 9164707 20260107141118_3FsKu NZ005T 2026-01-08T14:14:03.912Z 2026-01-13T15:04:59.449Z
9164683 9164683 20260107140704_SJNo5 NZ005T 2026-01-08T14:13:59.686Z 2026-01-13T15:04:58.328Z
9164552 9164552 20260107134310_ZhxEs NZ005T 2026-01-08T14:13:34.209Z 2026-01-13T15:04:51.299Z
9164262 9164262 20260107124136_jiekJ NZ005T 2026-01-08T14:12:30.090Z 2026-01-13T15:04:22.914Z
9163978 9163978 20260107113455_l7HJ9 NZ005T 2026-01-08T14:11:21.845Z 2026-01-13T15:03:58.002Z
9157142 9157142 20260104152247_ZteAA NZ005T 2026-01-06T14:41:48.555Z 2026-01-12T15:12:54.074Z
9157060 9157060 20260104145154_2OtOO NZ005T 2026-01-06T14:41:37.467Z 2026-01-12T15:12:50.301Z
9157027 9157027 20260104144232_oIwBO NZ005T 2026-01-06T14:41:27.827Z 2026-01-12T15:12:47.751Z
9157003 9157003 20260104143450_lzRdq NZ005T 2026-01-06T14:41:23.738Z 2026-01-12T15:12:46.817Z
9156960 9156960 20260104142102_go9xV NZ005T 2026-01-06T14:41:18.657Z 2026-01-12T15:12:44.890Z
9156935 9156935 20260104141331_XtBHd NZ005T 2026-01-06T14:41:16.393Z 2026-01-12T15:12:44.049Z
9156849 9156849 20260104134356_1pUAK NZ005T 2026-01-06T14:40:58.198Z 2026-01-12T15:12:39.867Z
9156802 9156802 20260104131810_W3Pv2 NZ005T 2026-01-06T14:40:50.434Z 2026-01-12T15:12:37.750Z

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