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 = "NZ002T" 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
8685144 8685144 20251204152823_sd53m NZ002T 2025-12-05T14:05:45.963Z 2025-12-05T14:05:45.963Z
8685138 8685138 20251204152705_tOfQ6 NZ002T 2025-12-05T14:05:45.565Z 2025-12-05T14:05:45.565Z
8685037 8685037 20251204150504_8ULLW NZ002T 2025-12-05T14:05:28.041Z 2025-12-05T14:05:28.041Z
8685028 8685028 20251204150317_UQrpi NZ002T 2025-12-05T14:05:26.744Z 2025-12-05T14:05:26.744Z
8684928 8684928 20251204143728_PJEl3 NZ002T 2025-12-05T14:05:02.344Z 2025-12-05T14:05:02.344Z
8684915 8684915 20251204143436_G2Bqq NZ002T 2025-12-05T14:05:00.712Z 2025-12-05T14:05:00.712Z
8684904 8684904 20251204143136_BIHDf NZ002T 2025-12-05T14:04:58.868Z 2025-12-05T14:04:58.868Z
8684868 8684868 20251204142538_YmJdO NZ002T 2025-12-05T14:04:45.756Z 2025-12-05T14:04:45.756Z
8684760 8684760 20251204141051_GkP8q NZ002T 2025-12-05T14:04:32.729Z 2025-12-05T14:04:32.729Z
8684745 8684745 20251204140641_1Baiw NZ002T 2025-12-05T14:04:30.865Z 2025-12-05T14:04:30.865Z
8684694 8684694 20251204135242_fGCBW NZ002T 2025-12-05T14:04:17.898Z 2025-12-05T14:04:17.898Z
8684671 8684671 20251204134734_eqJQd NZ002T 2025-12-05T14:04:12.040Z 2025-12-05T14:04:12.040Z
8684600 8684600 20251204132129_NhN0L NZ002T 2025-12-05T14:04:00.533Z 2025-12-05T14:04:00.533Z
8684563 8684563 20251204131515_stFWs NZ002T 2025-12-05T14:03:46.135Z 2025-12-05T14:03:46.135Z
8684532 8684532 20251204130620_S2ULI NZ002T 2025-12-05T14:03:38.937Z 2025-12-05T14:03:38.937Z
8684493 8684493 20251204125311_P9KdP NZ002T 2025-12-05T14:03:31.242Z 2025-12-05T14:03:31.242Z
8684374 8684374 20251204122223_iu8Fd NZ002T 2025-12-05T14:02:51.192Z 2025-12-05T14:02:51.192Z
8684364 8684364 20251204122101_d77Q7 NZ002T 2025-12-05T14:02:49.565Z 2025-12-05T14:02:49.565Z
8684235 8684235 20251204113849_zXsra NZ002T 2025-12-05T14:02:15.630Z 2025-12-05T14:02:15.630Z
8684188 8684188 20251204111909_W85lI NZ002T 2025-12-05T14:02:08.801Z 2025-12-05T14:02:08.801Z
8684160 8684160 20251204110248_2K5st NZ002T 2025-12-05T14:02:04.150Z 2025-12-05T14:02:04.150Z
8684063 8684063 20251204103046_qtId3 NZ002T 2025-12-05T14:01:42.406Z 2025-12-05T14:01:42.406Z
8683997 8683997 20251204100605_42tun NZ002T 2025-12-05T14:01:30.413Z 2025-12-05T14:01:30.413Z
8683975 8683975 20251204095322_J8Pb4 NZ002T 2025-12-05T14:01:25.062Z 2025-12-05T14:01:25.062Z
8677722 8677722 20251203120229_HU0v8 NZ002T 2025-12-04T14:02:23.786Z 2025-12-05T14:14:34.932Z
8677614 8677614 20251203110359_47DWI NZ002T 2025-12-04T14:01:58.710Z 2025-12-05T14:14:34.897Z
8677583 8677583 20251203105407_ZDunq NZ002T 2025-12-04T14:01:50.711Z 2025-12-05T14:14:34.887Z
8677572 8677572 20251203104943_iFXpK NZ002T 2025-12-04T14:01:48.508Z 2025-12-05T14:14:34.884Z
8677551 8677551 20251203104253_3EpuH NZ002T 2025-12-04T14:01:42.550Z 2025-12-05T14:14:34.877Z
8642150 8642150 20251128153520_Gs4Lb NZ002T 2025-11-30T14:17:37.312Z 2025-12-05T14:48:56.498Z
8642103 8642103 20251128153215_gJhuy NZ002T 2025-11-30T14:17:24.040Z 2025-12-05T14:48:55.825Z
8642100 8642100 20251128153212_DecGE NZ002T 2025-11-30T14:17:23.644Z 2025-12-05T14:48:55.742Z
8642092 8642092 20251128153111_3DBGb NZ002T 2025-11-30T14:17:21.965Z 2025-12-05T14:48:55.603Z
8641869 8641869 20251128151728_elVjy NZ002T 2025-11-30T14:17:05.699Z 2025-12-05T14:48:52.517Z
8641861 8641861 20251128151720_KQdxT NZ002T 2025-11-30T14:17:05.384Z 2025-12-05T14:48:52.493Z
8641777 8641777 20251128151322_m7fwC NZ002T 2025-11-30T14:17:00.182Z 2025-12-05T14:48:51.688Z
8641762 8641762 20251128151143_QXFH2 NZ002T 2025-11-30T14:16:51.951Z 2025-12-05T14:48:51.468Z
8641758 8641758 20251128151136_mzps4 NZ002T 2025-11-30T14:16:49.442Z 2025-12-05T14:48:51.377Z
8641742 8641742 20251128151107_Djwxi NZ002T 2025-11-30T14:16:45.829Z 2025-12-05T14:48:51.105Z
8641484 8641484 20251128145556_Iu3P3 NZ002T 2025-11-30T14:16:27.596Z 2025-12-05T14:48:41.778Z
8641437 8641437 20251128145307_jXEG2 NZ002T 2025-11-30T14:16:24.196Z 2025-12-05T14:48:39.104Z
8640688 8640688 20251129153008_zJPVd NZ002T 2025-11-30T14:09:16.268Z 2025-12-05T14:39:25.265Z
8640622 8640622 20251129150938_2gIlX NZ002T 2025-11-30T14:08:58.360Z 2025-12-05T14:39:22.446Z
8640614 8640614 20251129150641_12w6d NZ002T 2025-11-30T14:08:56.739Z 2025-12-05T14:39:21.790Z
8640593 8640593 20251129145841_xTqV5 NZ002T 2025-11-30T14:08:54.360Z 2025-12-05T14:39:21.185Z
8640562 8640562 20251129145137_77BkA NZ002T 2025-11-30T14:08:49.003Z 2025-11-30T14:08:49.003Z
8640432 8640432 20251129141845_IiOJE NZ002T 2025-11-30T14:08:24.115Z 2025-12-05T14:39:14.193Z
8640398 8640398 20251129140720_IX5Z8 NZ002T 2025-11-30T14:08:16.338Z 2025-12-05T14:39:12.515Z
8640267 8640267 20251129131925_2o8Ch NZ002T 2025-11-30T14:07:42.176Z 2025-12-05T14:39:07.322Z
8640216 8640216 20251129130731_52Nhf NZ002T 2025-11-30T14:07:33.358Z 2025-12-05T14:38:52.619Z
8639758 8639758 20251129115539_w5sTR NZ002T 2025-11-30T14:05:58.106Z 2025-12-05T14:38:30.709Z
8639714 8639714 20251129114948_mqbrh NZ002T 2025-11-30T14:05:51.297Z 2025-12-05T14:38:29.633Z
8639537 8639537 20251129111742_WyiiC NZ002T 2025-11-30T14:05:14.726Z 2025-12-05T14:38:24.504Z
8639475 8639475 20251129110933_2e2hw NZ002T 2025-11-30T14:05:06.438Z 2025-12-05T14:38:23.082Z
8639442 8639442 20251129110623_e5ENd NZ002T 2025-11-30T14:04:57.361Z 2025-12-05T14:38:22.265Z
8639355 8639355 20251129105852_gCLwj NZ002T 2025-11-30T14:04:39.909Z 2025-12-05T14:38:18.871Z
8639217 8639217 20251129104324_WP8qA NZ002T 2025-11-30T14:04:09.990Z 2025-12-05T14:37:59.061Z
8639154 8639154 20251129103330_k8Oqs NZ002T 2025-11-30T14:03:58.768Z 2025-12-05T14:37:57.331Z
8639043 8639043 20251129101946_CpLmO NZ002T 2025-11-30T14:03:35.139Z 2025-12-05T14:37:52.148Z
8638911 8638911 20251129100336_7M2cp NZ002T 2025-11-30T14:02:52.224Z 2025-12-05T14:37:47.403Z
8630047 8630047 20251127132251_Os4mO NZ002T 2025-11-29T14:11:15.758Z 2025-12-05T14:54:25.147Z
8629885 8629885 20251128144309_uBAZY NZ002T 2025-11-29T14:09:16.375Z 2025-12-05T14:48:26.207Z
8629857 8629857 20251128144128_qK40U NZ002T 2025-11-29T14:09:14.333Z 2025-12-05T14:48:23.019Z
8629828 8629828 20251128144034_ZDafU NZ002T 2025-11-29T14:09:04.221Z 2025-12-05T14:48:22.496Z
8629811 8629811 20251128144004_yW2B2 NZ002T 2025-11-29T14:09:02.271Z 2025-12-05T14:48:21.998Z
8629748 8629748 20251128143551_u2qIg NZ002T 2025-11-29T14:08:58.566Z 2025-11-29T14:08:58.566Z
8629709 8629709 20251128143100_fWrgc NZ002T 2025-11-29T14:08:54.934Z 2025-12-05T14:48:09.363Z
8629563 8629563 20251128141847_TE4YH NZ002T 2025-11-29T14:08:42.222Z 2025-12-05T14:48:06.563Z
8629493 8629493 20251128141137_4C2AI NZ002T 2025-11-29T14:08:29.362Z 2025-12-05T14:48:05.526Z
8629477 8629477 20251128140959_6vAV2 NZ002T 2025-11-29T14:08:28.074Z 2025-12-05T14:48:04.858Z
8629436 8629436 20251128140810_RW2Mu NZ002T 2025-11-29T14:08:23.087Z 2025-12-05T14:48:00.441Z
8629417 8629417 20251128140537_ytXy1 NZ002T 2025-11-29T14:08:21.804Z 2025-12-05T14:47:59.940Z
8629243 8629243 20251128135317_x6a8m NZ002T 2025-11-29T14:08:10.690Z 2025-11-29T14:08:10.690Z
8629224 8629224 20251128135046_ozPaW NZ002T 2025-11-29T14:08:09.416Z 2025-12-05T14:47:57.508Z
8629184 8629184 20251128134737_J5KzM NZ002T 2025-11-29T14:08:05.302Z 2025-12-05T14:47:56.925Z
8629164 8629164 20251128134708_RFjCE NZ002T 2025-11-29T14:07:56.388Z 2025-11-29T14:07:56.388Z
8629126 8629126 20251128134418_Gg533 NZ002T 2025-11-29T14:07:52.317Z 2025-12-05T14:47:55.794Z
8629050 8629050 20251128134046_GLRyt NZ002T 2025-11-29T14:07:45.519Z 2025-12-05T14:47:54.787Z
8629043 8629043 20251128133920_ZKheZ NZ002T 2025-11-29T14:07:44.828Z 2025-12-05T14:47:54.606Z
8628921 8628921 20251128132531_wzAzS NZ002T 2025-11-29T14:07:32.338Z 2025-12-05T14:47:52.898Z
8628667 8628667 20251128130311_j32b0 NZ002T 2025-11-29T14:06:55.979Z 2025-12-05T14:47:48.323Z
8628451 8628451 20251128124607_ztumf NZ002T 2025-11-29T14:06:19.784Z 2025-11-29T14:06:19.784Z
8627414 8627414 20251128105633_PX3AT NZ002T 2025-11-29T14:03:29.945Z 2025-12-05T14:46:58.842Z
8619915 8619915 20251126111439_drl3r NZ002T 2025-11-28T14:10:58.633Z 2025-12-05T15:01:11.514Z
8619526 8619526 20251126102410_VPY4j NZ002T 2025-11-28T14:09:18.868Z 2025-12-05T15:01:01.006Z
8619382 8619382 20251126100036_tR2nK NZ002T 2025-11-28T14:08:39.742Z 2025-12-05T15:00:57.440Z
8619310 8619310 20251126094841_KjR1s NZ002T 2025-11-28T14:08:19.730Z 2025-12-05T15:00:55.982Z
8619303 8619303 20251126094737_qtSoR NZ002T 2025-11-28T14:08:18.608Z 2025-12-05T15:00:55.894Z
8619186 8619186 20251126092359_Rz29B NZ002T 2025-11-28T14:07:44.073Z 2025-12-05T15:00:52.819Z
8618945 8618945 20251127150247_pI9qC NZ002T 2025-11-28T14:06:31.913Z 2025-12-05T14:54:46.823Z
8618935 8618935 20251127145328_RzjCx NZ002T 2025-11-28T14:06:29.731Z 2025-12-05T14:54:44.233Z
8618933 8618933 20251127145149_N3Xx3 NZ002T 2025-11-28T14:06:29.145Z 2025-12-05T14:54:44.091Z
8618924 8618924 20251127144628_43hRN NZ002T 2025-11-28T14:06:26.809Z 2025-12-05T14:54:39.353Z
8618919 8618919 20251127144526_WNmGR NZ002T 2025-11-28T14:06:26.433Z 2025-12-05T14:54:39.088Z
8618917 8618917 20251127144448_xNkkj NZ002T 2025-11-28T14:06:25.933Z 2025-12-05T14:54:38.945Z
8618907 8618907 20251127143732_GZQK1 NZ002T 2025-11-28T14:06:23.533Z 2025-12-05T14:54:31.547Z
8618900 8618900 20251127143513_hYjC9 NZ002T 2025-11-28T14:06:20.252Z 2025-12-05T14:54:30.942Z
8618888 8618888 20251127142926_Zb2oA NZ002T 2025-11-28T14:06:12.457Z 2025-12-05T14:54:28.867Z
8618880 8618880 20251127142715_vimv7 NZ002T 2025-11-28T14:06:10.838Z 2025-12-05T14:54:28.743Z
8618866 8618866 20251127142033_okPCr NZ002T 2025-11-28T14:06:06.482Z 2025-12-05T14:54:28.219Z

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