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,232 rows where station_code = "NZ003Q" 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
8689407 8689407 20251205154847_JDFqp NZ003Q 2025-12-06T14:08:15.290Z 2025-12-06T14:08:15.290Z
8689403 8689403 20251205154715_qqtrd NZ003Q 2025-12-06T14:08:13.645Z 2025-12-06T14:08:13.645Z
8689368 8689368 20251205153222_INPjj NZ003Q 2025-12-06T14:08:07.611Z 2025-12-06T14:08:07.611Z
8689250 8689250 20251205145211_13Vl9 NZ003Q 2025-12-06T14:07:30.627Z 2025-12-06T14:07:30.627Z
8688899 8688899 20251205130847_mbLcA NZ003Q 2025-12-06T14:06:15.386Z 2025-12-06T14:06:15.386Z
8688163 8688163 20251205103827_Lav4w NZ003Q 2025-12-06T14:03:29.990Z 2025-12-06T14:03:29.990Z
8688145 8688145 20251205103357_S2kmY NZ003Q 2025-12-06T14:03:25.264Z 2025-12-06T14:03:25.264Z
8685084 8685084 20251204151439_EQS38 NZ003Q 2025-12-05T14:05:37.788Z 2025-12-06T14:18:00.670Z
8677301 8677301 20251203083148_KOXnx NZ003Q 2025-12-04T14:00:40.197Z 2025-12-06T14:18:59.257Z
8672436 8672436 20251201142805_uVkX3 NZ003Q 2025-12-03T14:15:34.272Z 2025-12-06T14:31:56.249Z
8672122 8672122 20251201135523_TzJoS NZ003Q 2025-12-03T14:14:44.929Z 2025-12-06T14:31:45.872Z
8670213 8670213 20251202152529_0xMIQ NZ003Q 2025-12-03T14:07:27.266Z 2025-12-06T14:24:54.588Z
8661582 8661582 20251130160509_RXSZm NZ003Q 2025-12-02T14:12:05.622Z 2025-12-06T14:38:13.546Z
8661522 8661522 20251130154214_dJ04K NZ003Q 2025-12-02T14:11:45.992Z 2025-12-06T14:38:08.897Z
8661228 8661228 20251130150140_5b22V NZ003Q 2025-12-02T14:10:53.417Z 2025-12-06T14:37:53.328Z
8661200 8661200 20251130145818_GL0tD NZ003Q 2025-12-02T14:10:43.379Z 2025-12-06T14:37:45.744Z
8661167 8661167 20251130145340_BDsfP NZ003Q 2025-12-02T14:10:35.874Z 2025-12-06T14:37:39.551Z
8661077 8661077 20251130144036_wlh71 NZ003Q 2025-12-02T14:10:17.453Z 2025-12-06T14:37:36.997Z
8661050 8661050 20251130143242_2TF7R NZ003Q 2025-12-02T14:10:12.369Z 2025-12-06T14:37:36.241Z
8661028 8661028 20251130142757_Xcb1p NZ003Q 2025-12-02T14:10:07.196Z 2025-12-06T14:37:34.649Z
8660680 8660680 20251130132959_gfRxj NZ003Q 2025-12-02T14:08:45.979Z 2025-12-06T14:37:22.821Z
8660654 8660654 20251130132453_TUuqz NZ003Q 2025-12-02T14:08:40.695Z 2025-12-06T14:37:22.074Z
8649055 8649055 20251129155424_ai3sr NZ003Q 2025-12-01T14:10:40.513Z 2025-12-06T14:44:47.223Z
8641936 8641936 20251128152050_a5imy NZ003Q 2025-11-30T14:17:10.309Z 2025-12-06T14:53:08.668Z
8640601 8640601 20251129145844_ZhMCm NZ003Q 2025-11-30T14:08:54.808Z 2025-12-06T14:44:39.736Z
8640575 8640575 20251129145445_CBx8u NZ003Q 2025-11-30T14:08:51.108Z 2025-12-06T14:44:39.127Z
8640554 8640554 20251129144858_SkDq8 NZ003Q 2025-11-30T14:08:47.959Z 2025-12-06T14:44:38.713Z
8640506 8640506 20251129143821_jp3am NZ003Q 2025-11-30T14:08:34.397Z 2025-12-06T14:44:36.611Z
8640455 8640455 20251129142448_drryQ NZ003Q 2025-11-30T14:08:27.262Z 2025-12-06T14:44:35.644Z
8640390 8640390 20251129140214_W9FRi NZ003Q 2025-11-30T14:08:14.545Z 2025-12-06T14:44:32.658Z
8640382 8640382 20251129135903_exlhP NZ003Q 2025-11-30T14:08:12.212Z 2025-12-06T14:44:32.533Z
8640326 8640326 20251129134647_H03z4 NZ003Q 2025-11-30T14:07:58.534Z 2025-12-06T14:44:31.046Z
8640317 8640317 20251129134330_ZdOOz NZ003Q 2025-11-30T14:07:54.073Z 2025-12-06T14:44:29.140Z
8640126 8640126 20251129125442_RIrHp NZ003Q 2025-11-30T14:07:19.748Z 2025-12-06T14:43:59.432Z
8629893 8629893 20251128144327_YRU1A NZ003Q 2025-11-29T14:09:17.117Z 2025-12-06T14:52:35.243Z
8629610 8629610 20251128142223_HX5dq NZ003Q 2025-11-29T14:08:45.964Z 2025-12-06T14:52:30.282Z
8629344 8629344 20251128140044_0t54w NZ003Q 2025-11-29T14:08:17.581Z 2025-12-06T14:52:26.472Z
8626334 8626334 20251126085718_oms3D NZ003Q 2025-11-28T14:38:49.491Z 2025-12-04T15:12:16.311Z
8621686 8621686 20251126160420_Y2PTk NZ003Q 2025-11-28T14:16:23.295Z 2025-12-05T15:02:46.881Z
8621472 8621472 20251126151834_bAa6R NZ003Q 2025-11-28T14:15:46.429Z 2025-12-05T15:02:44.534Z
8621380 8621380 20251126150336_709a3 NZ003Q 2025-11-28T14:15:36.042Z 2025-12-05T15:02:43.739Z
8621298 8621298 20251126145242_eR23V NZ003Q 2025-11-28T14:15:15.526Z 2025-12-05T15:02:42.819Z
8620860 8620860 20251126134606_yX2uT NZ003Q 2025-11-28T14:14:06.680Z 2025-12-05T15:02:38.180Z
8620693 8620693 20251126131701_zd599 NZ003Q 2025-11-28T14:13:43.764Z 2025-12-05T15:02:32.527Z
8620389 8620389 20251126122649_o3QAM NZ003Q 2025-11-28T14:12:37.071Z 2025-12-05T15:01:58.670Z
8620251 8620251 20251126120437_sCGYY NZ003Q 2025-11-28T14:12:06.541Z 2025-12-05T15:01:34.348Z
8619933 8619933 20251126111804_wGGvU NZ003Q 2025-11-28T14:11:01.259Z 2025-12-05T15:01:11.972Z
8619887 8619887 20251126111110_VDnjv NZ003Q 2025-11-28T14:10:52.232Z 2025-12-05T15:01:10.974Z
8619405 8619405 20251126100438_ieYxK NZ003Q 2025-11-28T14:08:43.370Z 2025-12-05T15:00:57.857Z
8619126 8619126 20251126091442_2gsqH NZ003Q 2025-11-28T14:07:32.176Z 2025-12-05T15:00:49.813Z
8618987 8618987 20251127155054_v5rbQ NZ003Q 2025-11-28T14:06:39.937Z 2025-12-06T14:59:02.035Z
8618949 8618949 20251127150400_IQMSg NZ003Q 2025-11-28T14:06:32.353Z 2025-12-06T14:58:59.536Z
8618872 8618872 20251127142241_5EFDE NZ003Q 2025-11-28T14:06:07.707Z 2025-12-06T14:58:56.006Z
8618857 8618857 20251127141756_mqLlf NZ003Q 2025-11-28T14:06:04.830Z 2025-12-06T14:58:55.421Z
8604625 8604625 20251124092645_gDTHc NZ003Q 2025-11-26T14:37:33.199Z 2025-12-02T15:13:07.610Z
8604620 8604620 20251124092546_ghnkc NZ003Q 2025-11-26T14:37:32.874Z 2025-12-02T15:13:07.566Z
8604566 8604566 20251124090111_hCJq0 NZ003Q 2025-11-26T14:37:27.272Z 2025-12-02T15:13:06.481Z
8604506 8604506 20251124081326_Bfksa NZ003Q 2025-11-26T14:37:20.588Z 2025-12-02T15:13:04.921Z
8595379 8595379 20251124152307_Uangc NZ003Q 2025-11-26T14:10:56.730Z 2025-12-02T15:05:54.503Z
8595180 8595180 20251124142802_CKU1y NZ003Q 2025-11-26T14:10:14.425Z 2025-12-02T15:05:41.611Z
8594555 8594555 20251124114554_w9yNv NZ003Q 2025-11-26T14:07:21.158Z 2025-12-02T15:05:33.027Z
8594495 8594495 20251124113106_EyW7q NZ003Q 2025-11-26T14:07:04.687Z 2025-12-02T15:05:32.289Z
8594226 8594226 20251124101528_aLAEY NZ003Q 2025-11-26T14:05:19.793Z 2025-12-02T15:05:27.854Z
8594202 8594202 20251124100503_s9QJz NZ003Q 2025-11-26T14:05:03.065Z 2025-12-02T15:05:27.266Z
8594199 8594199 20251124100502_FwRmE NZ003Q 2025-11-26T14:05:02.759Z 2025-12-02T15:05:27.189Z
8594031 8594031 20251125150729_sNePl NZ003Q 2025-11-26T14:04:13.578Z 2025-12-04T15:05:31.862Z
8593802 8593802 20251125125251_rTSPr NZ003Q 2025-11-26T14:03:24.988Z 2025-12-04T15:05:24.590Z
8593053 8593053 20251125094712_qsr0u NZ003Q 2025-11-26T14:00:40.762Z 2025-12-04T15:05:09.008Z
8585436 8585436 20251123154440_Ftu85 NZ003Q 2025-11-25T14:09:33.684Z 2025-12-02T15:09:57.839Z
8585318 8585318 20251123152241_OlVXf NZ003Q 2025-11-25T14:09:12.395Z 2025-12-02T15:09:56.723Z
8585273 8585273 20251123150657_IDSco NZ003Q 2025-11-25T14:09:01.561Z 2025-12-02T15:09:54.766Z
8585220 8585220 20251123145749_08yty NZ003Q 2025-11-25T14:08:55.449Z 2025-12-02T15:09:54.371Z
8585208 8585208 20251123145617_Spu5D NZ003Q 2025-11-25T14:08:54.458Z 2025-12-02T15:09:54.298Z
8585133 8585133 20251123144410_Wjr2Z NZ003Q 2025-11-25T14:08:45.425Z 2025-12-02T15:09:53.886Z
8585092 8585092 20251123143638_ajvum NZ003Q 2025-11-25T14:08:36.933Z 2025-12-02T15:09:53.648Z
8584893 8584893 20251123135226_U3gsN NZ003Q 2025-11-25T14:07:56.857Z 2025-12-02T15:09:52.638Z
8584855 8584855 20251123134235_B5pnf NZ003Q 2025-11-25T14:07:50.505Z 2025-12-02T15:09:52.369Z
8584819 8584819 20251123133305_SKX42 NZ003Q 2025-11-25T14:07:45.176Z 2025-12-02T15:09:52.072Z
8584803 8584803 20251123133010_rN86B NZ003Q 2025-11-25T14:07:41.946Z 2025-12-02T15:09:51.937Z
8584756 8584756 20251123132122_8a46p NZ003Q 2025-11-25T14:07:26.029Z 2025-12-02T15:09:51.633Z
8584590 8584590 20251123124612_iMYz6 NZ003Q 2025-11-25T14:06:54.147Z 2025-12-02T15:09:50.648Z
8584467 8584467 20251123122049_J8LxG NZ003Q 2025-11-25T14:06:27.588Z 2025-12-02T15:09:49.698Z
8584360 8584360 20251123115212_KcH1G NZ003Q 2025-11-25T14:06:06.904Z 2025-12-02T15:09:48.133Z
8584335 8584335 20251123114246_SAm3f NZ003Q 2025-11-25T14:05:56.466Z 2025-12-02T15:09:47.890Z
8584097 8584097 20251123105843_s4uvC NZ003Q 2025-11-25T14:05:19.075Z 2025-12-02T15:09:46.142Z
8584048 8584048 20251123104137_o2Bo6 NZ003Q 2025-11-25T14:05:09.345Z 2025-12-02T15:09:45.637Z
8583909 8583909 20251123101229_j23aX NZ003Q 2025-11-25T14:04:33.748Z 2025-12-02T15:09:44.135Z
8583898 8583898 20251123100711_RScHM NZ003Q 2025-11-25T14:04:25.736Z 2025-12-02T15:09:43.913Z
8575992 8575992 20251122135820_4Yi4V NZ003Q 2025-11-24T14:04:37.435Z 2025-12-01T15:18:32.298Z
8575944 8575944 20251122135440_iEL9t NZ003Q 2025-11-24T14:04:31.153Z 2025-12-01T15:18:31.835Z
8574632 8574632 20251122101447_xLvrK NZ003Q 2025-11-24T14:00:22.105Z 2025-12-01T15:17:17.540Z
8570623 8570623 20251121100131_PcCZz NZ003Q 2025-11-23T14:33:55.159Z 2025-11-29T14:55:07.883Z
8570530 8570530 20251121094234_4sanC NZ003Q 2025-11-23T14:33:49.753Z 2025-11-29T14:55:06.235Z
8570528 8570528 20251121094224_iAsjW NZ003Q 2025-11-23T14:33:49.663Z 2025-11-29T14:55:06.231Z
8570408 8570408 20251121091528_BvyYl NZ003Q 2025-11-23T14:33:40.947Z 2025-11-29T14:55:02.994Z
8570252 8570252 20251121084548_jnfZj NZ003Q 2025-11-23T14:33:12.707Z 2025-11-29T14:54:55.965Z
8570243 8570243 20251121084213_YJEvF NZ003Q 2025-11-23T14:33:12.097Z 2025-11-29T14:54:55.929Z
8570182 8570182 20251121082313_JKXeJ NZ003Q 2025-11-23T14:33:08.234Z 2025-11-29T14:54:55.238Z
8563389 8563389 20251121160345_0XzzZ NZ003Q 2025-11-23T14:08:07.501Z 2025-11-30T15:03:39.118Z
8563363 8563363 20251121155702_CCwRG NZ003Q 2025-11-23T14:08:04.284Z 2025-11-30T15:03:38.966Z

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