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

7,971 rows where station_code = "NZ004C" 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
9265871 9265871 20260127160813_n5KOO NZ004C 2026-01-28T14:11:37.973Z 2026-01-29T14:30:24.704Z
9265823 9265823 20260127160230_iUFMF NZ004C 2026-01-28T14:11:28.011Z 2026-01-29T14:30:24.684Z
9264957 9264957 20260127134111_AHHLF NZ004C 2026-01-28T14:08:22.503Z 2026-01-29T14:30:24.399Z
9264570 9264570 20260127124718_nnjbM NZ004C 2026-01-28T14:06:42.912Z 2026-01-29T14:30:24.221Z
9264497 9264497 20260127123542_iokFq NZ004C 2026-01-28T14:06:22.335Z 2026-01-29T14:30:24.187Z
9264385 9264385 20260127121035_OzJ94 NZ004C 2026-01-28T14:05:47.171Z 2026-01-29T14:30:21.192Z
9264205 9264205 20260127113742_utLXl NZ004C 2026-01-28T14:04:56.984Z 2026-01-29T14:30:20.541Z
9264102 9264102 20260127111430_YisrM NZ004C 2026-01-28T14:04:25.829Z 2026-01-29T14:30:20.052Z
9264031 9264031 20260127105938_V22il NZ004C 2026-01-28T14:04:01.103Z 2026-01-29T14:30:20.010Z
9264008 9264008 20260127105252_4Zrmm NZ004C 2026-01-28T14:03:55.178Z 2026-01-29T14:30:19.996Z
9263744 9263744 20260127100327_JfgXd NZ004C 2026-01-28T14:02:34.614Z 2026-01-29T14:30:18.924Z
9261992 9261992 20260126150715_aJQdh NZ004C 2026-01-27T14:06:55.259Z 2026-01-29T14:33:22.878Z
9261981 9261981 20260126150417_bcGwg NZ004C 2026-01-27T14:06:52.543Z 2026-01-29T14:33:22.089Z
9261955 9261955 20260126145724_N83a5 NZ004C 2026-01-27T14:06:45.477Z 2026-01-29T14:33:20.305Z
9261949 9261949 20260126145330_2zGfb NZ004C 2026-01-27T14:06:43.287Z 2026-01-29T14:33:19.512Z
9261931 9261931 20260126144505_CSKiN NZ004C 2026-01-27T14:06:32.572Z 2026-01-29T14:33:17.754Z
9261923 9261923 20260126144239_RmbzA NZ004C 2026-01-27T14:06:29.448Z 2026-01-29T14:33:17.008Z
9261864 9261864 20260126140332_wO0Zp NZ004C 2026-01-27T14:06:09.581Z 2026-01-29T14:33:11.657Z
9261854 9261854 20260126135527_uWSVY NZ004C 2026-01-27T14:06:06.503Z 2026-01-29T14:33:10.685Z
9261839 9261839 20260126135145_Tcjj6 NZ004C 2026-01-27T14:05:57.235Z 2026-01-29T14:33:07.064Z
9261837 9261837 20260126135114_Jw6KC NZ004C 2026-01-27T14:05:56.627Z 2026-01-29T14:33:06.936Z
9261802 9261802 20260126132542_Uxg2t NZ004C 2026-01-27T14:05:43.587Z 2026-01-29T14:33:03.576Z
9261774 9261774 20260126131617_fXnR3 NZ004C 2026-01-27T14:05:36.017Z 2026-01-29T14:32:57.152Z
9261760 9261760 20260126131101_y537u NZ004C 2026-01-27T14:05:27.047Z 2026-01-29T14:32:55.755Z
9261689 9261689 20260126124849_TrpkX NZ004C 2026-01-27T14:05:07.661Z 2026-01-29T14:32:48.641Z
9261641 9261641 20260126123800_UQF6I NZ004C 2026-01-27T14:04:49.178Z 2026-01-29T14:32:45.527Z
9261614 9261614 20260126123200_MtD9a NZ004C 2026-01-27T14:04:43.346Z 2026-01-29T14:32:43.824Z
9253026 9253026 20260119103450_5zEsR NZ004C 2026-01-24T14:56:40.975Z 2026-01-27T15:07:09.756Z
9253022 9253022 20260119143536_q0AL4 NZ004C 2026-01-24T14:38:12.840Z 2026-01-28T14:55:51.294Z
9253019 9253019 20260119130014_lVlWR NZ004C 2026-01-24T14:37:41.523Z 2026-01-28T14:55:25.460Z
9253016 9253016 20260119124043_yGtPD NZ004C 2026-01-24T14:37:27.913Z 2026-01-28T14:55:20.813Z
9253014 9253014 20260119122830_BfR0n NZ004C 2026-01-24T14:37:21.336Z 2026-01-28T14:55:16.321Z
9253011 9253011 20260119115731_ATBPx NZ004C 2026-01-24T14:37:04.608Z 2026-01-28T14:54:58.575Z
9250842 9250842 20260122160525_xLcBs NZ004C 2026-01-24T14:08:01.140Z 2026-01-29T14:50:38.468Z
9249927 9249927 20260119095631_NQu2k NZ004C 2026-01-23T14:35:42.499Z 2026-01-23T14:35:42.499Z
9225723 9225723 20260118104530_m4GSF NZ004C 2026-01-19T14:30:00.080Z 2026-01-26T15:04:42.978Z
9221573 9221573 20260118160428_1HoTh NZ004C 2026-01-19T14:08:22.069Z 2026-01-27T15:00:32.204Z
9221548 9221548 20260118155646_j1DMo NZ004C 2026-01-19T14:08:19.673Z 2026-01-27T15:00:31.353Z
9221538 9221538 20260118155142_J1Aw1 NZ004C 2026-01-19T14:08:13.353Z 2026-01-27T15:00:30.223Z
9221523 9221523 20260118155028_YpozX NZ004C 2026-01-19T14:08:11.254Z 2026-01-27T15:00:29.322Z
9221472 9221472 20260118154311_q3bTO NZ004C 2026-01-19T14:07:59.300Z 2026-01-27T15:00:25.221Z
9221462 9221462 20260118154306_V3mVn NZ004C 2026-01-19T14:07:58.178Z 2026-01-27T15:00:23.934Z
9221449 9221449 20260118154144_hF4q1 NZ004C 2026-01-19T14:07:56.450Z 2026-01-27T15:00:23.110Z
9221361 9221361 20260118152656_uP1wX NZ004C 2026-01-19T14:07:38.869Z 2026-01-27T15:00:07.325Z
9221344 9221344 20260118152354_yXxLb NZ004C 2026-01-19T14:07:32.872Z 2026-01-27T15:00:05.372Z
9221225 9221225 20260118150640_DZjgf NZ004C 2026-01-19T14:07:08.115Z 2026-01-27T14:59:57.884Z
9221201 9221201 20260118150134_0UFPy NZ004C 2026-01-19T14:07:02.666Z 2026-01-27T14:59:56.798Z
9221167 9221167 20260118145625_e1h2n NZ004C 2026-01-19T14:06:55.517Z 2026-01-27T14:59:55.660Z
9221081 9221081 20260118144858_alL1u NZ004C 2026-01-19T14:06:43.800Z 2026-01-27T14:59:52.751Z
9221067 9221067 20260118144520_Agr0W NZ004C 2026-01-19T14:06:42.576Z 2026-01-27T14:59:52.520Z
9220958 9220958 20260118142353_ST4M2 NZ004C 2026-01-19T14:06:16.539Z 2026-01-27T14:59:47.955Z
9220950 9220950 20260118142326_g3q4M NZ004C 2026-01-19T14:06:15.538Z 2026-01-27T14:59:47.824Z
9220814 9220814 20260118135549_30B3f NZ004C 2026-01-19T14:05:44.719Z 2026-01-27T14:59:31.119Z
9220799 9220799 20260118135227_w3U7v NZ004C 2026-01-19T14:05:42.040Z 2026-01-27T14:59:30.597Z
9220778 9220778 20260118134823_EJlBD NZ004C 2026-01-19T14:05:34.390Z 2026-01-27T14:59:28.140Z
9220705 9220705 20260118133035_wEb9V NZ004C 2026-01-19T14:05:16.455Z 2026-01-27T14:59:25.291Z
9220501 9220501 20260118130038_hZj9T NZ004C 2026-01-19T14:04:27.858Z 2026-01-27T14:59:17.715Z
9220455 9220455 20260118125300_ttfcB NZ004C 2026-01-19T14:04:17.335Z 2026-01-27T14:59:16.206Z
9220372 9220372 20260118124301_uvEMp NZ004C 2026-01-19T14:03:56.650Z 2026-01-27T14:59:02.917Z
9220029 9220029 20260118115640_PI9jL NZ004C 2026-01-19T14:02:16.940Z 2026-01-27T14:58:46.488Z
9219959 9219959 20260118114403_a9RTY NZ004C 2026-01-19T14:01:54.248Z 2026-01-27T14:58:43.912Z
9219847 9219847 20260118113038_rIcEz NZ004C 2026-01-19T14:01:13.697Z 2026-01-27T14:58:36.134Z
9219787 9219787 20260118111756_QJyXO NZ004C 2026-01-19T14:00:47.480Z 2026-01-27T14:58:31.049Z
9219732 9219732 20260118111149_H5qis NZ004C 2026-01-19T14:00:26.005Z 2026-01-27T14:58:28.451Z
9219695 9219695 20260118110742_80J8u NZ004C 2026-01-19T14:00:13.960Z 2026-01-27T14:58:27.267Z
9217256 9217256 20260117154707_cc408 NZ004C 2026-01-18T14:05:04.870Z 2026-01-26T15:00:03.487Z
9217203 9217203 20260117152219_s343H NZ004C 2026-01-18T14:04:48.451Z 2026-01-26T15:00:00.927Z
9217111 9217111 20260117143821_EKuRf NZ004C 2026-01-18T14:04:19.983Z 2026-01-26T14:59:56.906Z
9217109 9217109 20260117143642_LoFbp NZ004C 2026-01-18T14:04:19.323Z 2026-01-26T14:59:56.818Z
9217020 9217020 20260117141041_qKYkx NZ004C 2026-01-18T14:03:52.447Z 2026-01-26T14:59:52.851Z
9217016 9217016 20260117140758_RQXp2 NZ004C 2026-01-18T14:03:51.116Z 2026-01-26T14:59:52.656Z
9216985 9216985 20260117135459_FnlhD NZ004C 2026-01-18T14:03:42.119Z 2026-01-26T14:59:51.264Z
9216966 9216966 20260117134605_T23a0 NZ004C 2026-01-18T14:03:35.958Z 2026-01-26T14:59:47.582Z
9216951 9216951 20260117133400_3I1EH NZ004C 2026-01-18T14:03:29.599Z 2026-01-26T14:59:35.384Z
9211091 9211091 20260116155312_5R93Q NZ004C 2026-01-17T14:04:16.416Z 2026-01-25T14:57:20.536Z
9193428 9193428 20260113144248_59Joa NZ004C 2026-01-14T14:01:21.738Z 2026-01-22T15:06:18.120Z
9193117 9193117 20260112133825_dQ3Dm NZ004C 2026-01-13T14:30:12.064Z 2026-01-20T15:26:59.948Z
9193111 9193111 20260112133713_YAgWo NZ004C 2026-01-13T14:30:11.047Z 2026-01-20T15:26:59.725Z
9193094 9193094 20260112133612_al02H NZ004C 2026-01-13T14:30:09.255Z 2026-01-20T15:26:59.214Z
9192947 9192947 20260112131845_55wH2 NZ004C 2026-01-13T14:29:45.590Z 2026-01-20T15:26:40.361Z
9192686 9192686 20260112125337_rpiof NZ004C 2026-01-13T14:29:03.171Z 2026-01-20T15:26:30.075Z
9192659 9192659 20260112125117_CfOIv NZ004C 2026-01-13T14:28:59.766Z 2026-01-20T15:26:28.764Z
9192593 9192593 20260112124642_SQ2ni NZ004C 2026-01-13T14:28:47.407Z 2026-01-20T15:26:26.688Z
9192566 9192566 20260112124442_qi0L9 NZ004C 2026-01-13T14:28:41.684Z 2026-01-20T15:26:25.876Z
9192527 9192527 20260112124015_o9ySu NZ004C 2026-01-13T14:28:34.284Z 2026-01-20T15:26:24.551Z
9192464 9192464 20260112123656_oMdZH NZ004C 2026-01-13T14:28:26.192Z 2026-01-20T15:26:22.786Z
9192355 9192355 20260112122607_022cB NZ004C 2026-01-13T14:28:09.116Z 2026-01-20T15:26:19.644Z
9192215 9192215 20260112121246_LFEnR NZ004C 2026-01-13T14:27:44.313Z 2026-01-20T15:26:14.688Z
9192084 9192084 20260112120436_a4xBZ NZ004C 2026-01-13T14:27:23.631Z 2026-01-20T15:25:58.467Z
9192030 9192030 20260112120112_4ch89 NZ004C 2026-01-13T14:27:14.246Z 2026-01-20T15:25:57.093Z
9191907 9191907 20260112115033_eV6VC NZ004C 2026-01-13T14:26:48.588Z 2026-01-20T15:25:50.848Z
9191847 9191847 20260112114702_pRfFj NZ004C 2026-01-13T14:26:40.203Z 2026-01-20T15:25:48.578Z
9191649 9191649 20260112113155_rzYAc NZ004C 2026-01-13T14:25:58.396Z 2026-01-20T15:25:42.090Z
9191592 9191592 20260112112300_Fv53z NZ004C 2026-01-13T14:25:49.328Z 2026-01-20T15:25:39.765Z
9191320 9191320 20260112105741_rrcXH NZ004C 2026-01-13T14:25:03.051Z 2026-01-20T15:25:20.206Z
9191301 9191301 20260112105655_BwL2c NZ004C 2026-01-13T14:25:01.266Z 2026-01-20T15:25:18.521Z
9191257 9191257 20260112104953_34IMx NZ004C 2026-01-13T14:24:53.854Z 2026-01-20T15:25:16.215Z
9191166 9191166 20260112104151_F4NYD NZ004C 2026-01-13T14:24:35.968Z 2026-01-20T15:25:12.792Z
9191103 9191103 20260112103302_QwQf0 NZ004C 2026-01-13T14:24:26.466Z 2026-01-20T15:25:10.153Z
9191039 9191039 20260112102838_CQjgm NZ004C 2026-01-13T14:24:14.288Z 2026-01-20T15:25:07.865Z

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