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

8,774 rows where station_code = "NZ002Q" 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
9270701 9270701 20260128163659_7RshP NZ002Q 2026-01-29T14:13:24.623Z 2026-01-29T14:13:24.623Z
9270630 9270630 20260128161510_ugdp3 NZ002Q 2026-01-29T14:13:04.213Z 2026-01-29T14:13:04.213Z
9270544 9270544 20260128155905_A23Xy NZ002Q 2026-01-29T14:12:43.387Z 2026-01-29T14:12:43.387Z
9270486 9270486 20260128155611_33by3 NZ002Q 2026-01-29T14:12:24.948Z 2026-01-29T14:12:24.948Z
9270450 9270450 20260128155105_RnKcL NZ002Q 2026-01-29T14:12:19.601Z 2026-01-29T14:12:19.601Z
9270261 9270261 20260128152307_khMC5 NZ002Q 2026-01-29T14:11:28.331Z 2026-01-29T14:11:28.331Z
9270193 9270193 20260128151319_LfTrb NZ002Q 2026-01-29T14:11:15.796Z 2026-01-29T14:11:15.796Z
9270128 9270128 20260128145833_0YH1e NZ002Q 2026-01-29T14:10:57.595Z 2026-01-29T14:10:57.595Z
9269896 9269896 20260128142959_IgGct NZ002Q 2026-01-29T14:10:08.837Z 2026-01-29T14:10:08.837Z
9269551 9269551 20260128133236_cjvsZ NZ002Q 2026-01-29T14:08:27.804Z 2026-01-29T14:08:27.804Z
9269516 9269516 20260128132856_rSkjF NZ002Q 2026-01-29T14:08:21.312Z 2026-01-29T14:08:21.312Z
9269474 9269474 20260128132530_Ro4Iw NZ002Q 2026-01-29T14:08:08.825Z 2026-01-29T14:08:08.825Z
9269462 9269462 20260128132040_o50Jq NZ002Q 2026-01-29T14:08:05.986Z 2026-01-29T14:08:05.986Z
9269308 9269308 20260128130046_TXC9g NZ002Q 2026-01-29T14:07:26.526Z 2026-01-29T14:07:26.526Z
9269280 9269280 20260128125612_YnisA NZ002Q 2026-01-29T14:07:21.598Z 2026-01-29T14:07:21.598Z
9269278 9269278 20260128125612_bEUHz NZ002Q 2026-01-29T14:07:21.054Z 2026-01-29T14:07:21.054Z
9269258 9269258 20260128125218_xC0Tc NZ002Q 2026-01-29T14:07:10.426Z 2026-01-29T14:07:10.426Z
9269249 9269249 20260128125025_Qtvvf NZ002Q 2026-01-29T14:07:06.260Z 2026-01-29T14:07:06.260Z
9269106 9269106 20260128122947_Kzfqx NZ002Q 2026-01-29T14:06:32.668Z 2026-01-29T14:06:32.668Z
9269058 9269058 20260128121514_96PRD NZ002Q 2026-01-29T14:06:13.568Z 2026-01-29T14:06:13.568Z
9268869 9268869 20260128113556_DrzzI NZ002Q 2026-01-29T14:05:15.898Z 2026-01-29T14:05:15.898Z
9268651 9268651 20260128105845_gdCnS NZ002Q 2026-01-29T14:04:14.567Z 2026-01-29T14:04:14.567Z
9268602 9268602 20260128105159_3Hu5B NZ002Q 2026-01-29T14:03:57.010Z 2026-01-29T14:03:57.010Z
9268534 9268534 20260128104322_bzc7L NZ002Q 2026-01-29T14:03:35.169Z 2026-01-29T14:03:35.169Z
9268492 9268492 20260128103117_gH3Tt NZ002Q 2026-01-29T14:03:22.681Z 2026-01-29T14:03:22.681Z
9268224 9268224 20260128092419_I15GC NZ002Q 2026-01-29T14:01:46.431Z 2026-01-29T14:01:46.431Z
9268220 9268220 20260128092408_9imPF NZ002Q 2026-01-29T14:01:45.298Z 2026-01-29T14:01:45.298Z
9265912 9265912 20260127161607_WXRPa NZ002Q 2026-01-28T14:11:45.035Z 2026-01-29T14:30:24.737Z
9265789 9265789 20260127160032_Q8NZk NZ002Q 2026-01-28T14:11:21.006Z 2026-01-29T14:30:24.677Z
9265729 9265729 20260127155354_MnyV7 NZ002Q 2026-01-28T14:11:10.512Z 2026-01-29T14:30:24.664Z
9265689 9265689 20260127154924_PzL5m NZ002Q 2026-01-28T14:11:00.477Z 2026-01-29T14:30:24.655Z
9265535 9265535 20260127153037_3FUcU NZ002Q 2026-01-28T14:10:28.777Z 2026-01-29T14:30:24.601Z
9265483 9265483 20260127152124_6bSdq NZ002Q 2026-01-28T14:10:21.262Z 2026-01-29T14:30:24.591Z
9265479 9265479 20260127152116_lJeDl NZ002Q 2026-01-28T14:10:20.648Z 2026-01-29T14:30:24.590Z
9265363 9265363 20260127150706_f4vs1 NZ002Q 2026-01-28T14:09:56.035Z 2026-01-29T14:30:24.534Z
9265357 9265357 20260127150445_kAQks NZ002Q 2026-01-28T14:09:55.075Z 2026-01-29T14:30:24.533Z
9265318 9265318 20260127145920_2Y1f3 NZ002Q 2026-01-28T14:09:49.065Z 2026-01-29T14:30:24.526Z
9264365 9264365 20260127120747_g5oes NZ002Q 2026-01-28T14:05:42.300Z 2026-01-29T14:30:20.878Z
9256684 9256684 20260125100012_MUe9g NZ002Q 2026-01-26T14:01:25.411Z 2026-01-29T14:36:16.376Z
9256666 9256666 20260125095712_Slq2r NZ002Q 2026-01-26T14:01:16.722Z 2026-01-29T14:36:15.363Z
9256618 9256618 20260125093110_ZLqbv NZ002Q 2026-01-26T14:00:58.558Z 2026-01-29T14:36:12.248Z
9253932 9253932 20260124160045_QN0Rc NZ002Q 2026-01-25T14:05:03.547Z 2026-01-29T14:41:50.608Z
9253929 9253929 20260124160011_m066B NZ002Q 2026-01-25T14:05:02.984Z 2026-01-29T14:41:50.498Z
9253859 9253859 20260124152055_su022 NZ002Q 2026-01-25T14:04:44.033Z 2026-01-29T14:41:43.518Z
9253721 9253721 20260124140228_A87jf NZ002Q 2026-01-25T14:04:06.385Z 2026-01-29T14:41:19.644Z
9253491 9253491 20260124121220_ZeyfU NZ002Q 2026-01-25T14:02:59.722Z 2026-01-29T14:40:53.291Z
9253422 9253422 20260124114158_3jHEp NZ002Q 2026-01-25T14:02:39.084Z 2026-01-29T14:40:48.712Z
9253394 9253394 20260124112957_LRoMO NZ002Q 2026-01-25T14:02:31.396Z 2026-01-29T14:40:46.780Z
9253227 9253227 20260124102037_3jvUu NZ002Q 2026-01-25T14:01:31.882Z 2026-01-29T14:40:29.084Z
9253176 9253176 20260124095423_wo35v NZ002Q 2026-01-25T14:01:08.638Z 2026-01-29T14:40:23.839Z
9249788 9249788 20260122084533_31LJa NZ002Q 2026-01-23T14:16:14.598Z 2026-01-29T14:58:55.469Z
9245685 9245685 20260122134505_ZXHz9 NZ002Q 2026-01-23T14:02:59.450Z 2026-01-29T14:49:57.311Z
9245478 9245478 20260122124009_TbZbU NZ002Q 2026-01-23T14:02:10.142Z 2026-01-29T14:49:43.104Z
9245467 9245467 20260122123710_pnZEE NZ002Q 2026-01-23T14:02:04.447Z 2026-01-29T14:49:42.240Z
9245409 9245409 20260122121744_J30Nq NZ002Q 2026-01-23T14:01:52.334Z 2026-01-29T14:49:32.244Z
9245373 9245373 20260122120319_xzhJ2 NZ002Q 2026-01-23T14:01:45.103Z 2026-01-29T14:49:28.905Z
9245345 9245345 20260122115505_AGLjb NZ002Q 2026-01-23T14:01:38.804Z 2026-01-29T14:49:25.155Z
9245075 9245075 20260122095640_e34TD NZ002Q 2026-01-23T14:00:25.125Z 2026-01-29T14:48:56.191Z
9225417 9225417 20260118094032_fi4rj NZ002Q 2026-01-19T14:28:54.614Z 2026-01-26T15:04:33.773Z
9225257 9225257 20260118085305_9U8Wp NZ002Q 2026-01-19T14:28:16.697Z 2026-01-26T15:04:16.353Z
9220945 9220945 20260118142217_bPb1g NZ002Q 2026-01-19T14:06:14.935Z 2026-01-27T14:59:47.697Z
9215685 9215685 20260116104609_2Ph7I NZ002Q 2026-01-17T14:26:34.609Z 2026-01-24T15:15:09.275Z
9215632 9215632 20260116103759_s9P05 NZ002Q 2026-01-17T14:26:20.081Z 2026-01-24T15:15:05.951Z
9215625 9215625 20260116103738_oX829 NZ002Q 2026-01-17T14:26:19.447Z 2026-01-24T15:15:05.660Z
9215550 9215550 20260116102959_2MY23 NZ002Q 2026-01-17T14:26:06.762Z 2026-01-24T15:15:03.033Z
9215534 9215534 20260116102602_552Pc NZ002Q 2026-01-17T14:26:03.564Z 2026-01-24T15:15:02.219Z
9215448 9215448 20260116101418_x3HYJ NZ002Q 2026-01-17T14:25:36.235Z 2026-01-24T15:14:52.046Z
9211007 9211007 20260116144439_K2yIw NZ002Q 2026-01-17T14:03:47.631Z 2026-01-25T14:57:14.668Z
9210930 9210930 20260116140754_u7bex NZ002Q 2026-01-17T14:03:27.131Z 2026-01-25T14:57:12.055Z
9205599 9205599 20260114121650_td0Id NZ002Q 2026-01-15T14:31:38.824Z 2026-01-22T15:11:15.678Z
9193152 9193152 20260112134207_sBLwp NZ002Q 2026-01-13T14:30:17.658Z 2026-01-20T15:27:01.294Z
9192013 9192013 20260112120004_MUi5q NZ002Q 2026-01-13T14:27:11.672Z 2026-01-20T15:25:56.553Z
9191508 9191508 20260112111510_02Ihn NZ002Q 2026-01-13T14:25:38.557Z 2026-01-20T15:25:36.789Z
9191404 9191404 20260112110401_hjIGu NZ002Q 2026-01-13T14:25:16.620Z 2026-01-20T15:25:23.843Z
9191214 9191214 20260112104550_KgSe0 NZ002Q 2026-01-13T14:24:44.655Z 2026-01-20T15:25:14.682Z
9190979 9190979 20260112102320_Ff4LV NZ002Q 2026-01-13T14:24:05.457Z 2026-01-20T15:25:06.404Z
9190560 9190560 20260112092256_mjQoU NZ002Q 2026-01-13T14:22:42.860Z 2026-01-20T15:24:39.258Z
9190495 9190495 20260112091301_XoYYl NZ002Q 2026-01-13T14:22:26.409Z 2026-01-20T15:24:35.902Z
9190469 9190469 20260112091051_3lWKX NZ002Q 2026-01-13T14:22:22.182Z 2026-01-20T15:24:34.620Z
9187212 9187212 20260111154146_TclhB NZ002Q 2026-01-13T14:06:10.688Z 2026-01-20T15:20:09.683Z
9187196 9187196 20260111153851_lsKSF NZ002Q 2026-01-13T14:06:06.373Z 2026-01-20T15:20:08.098Z
9186992 9186992 20260111143807_rBjC8 NZ002Q 2026-01-13T14:04:48.394Z 2026-01-20T15:19:41.824Z
9186989 9186989 20260111143807_viatU NZ002Q 2026-01-13T14:04:47.840Z 2026-01-20T15:19:41.548Z
9186175 9186175 20260112135624_u7Q52 NZ002Q 2026-01-13T14:00:40.959Z 2026-01-21T15:02:12.818Z
9185902 9185902 20260111135115_cLMOF NZ002Q 2026-01-12T14:26:15.733Z 2026-01-19T15:22:04.441Z
9185842 9185842 20260111132456_TX75s NZ002Q 2026-01-12T14:26:07.065Z 2026-01-19T15:21:56.824Z
9185567 9185567 20260111120142_giYVb NZ002Q 2026-01-12T14:25:12.749Z 2026-01-19T15:21:06.396Z
9184682 9184682 20260111120821_CSu5a NZ002Q 2026-01-12T14:21:18.004Z 2026-01-19T15:21:08.291Z
9184265 9184265 20260111110242_F95uH NZ002Q 2026-01-12T14:20:08.800Z 2026-01-19T15:20:31.079Z
9183979 9183979 20260111103219_ABJ1t NZ002Q 2026-01-12T14:19:20.388Z 2026-01-19T15:20:18.562Z
9183811 9183811 20260111101732_LiZrq NZ002Q 2026-01-12T14:18:52.905Z 2026-01-19T15:20:12.446Z
9183564 9183564 20260111094436_P1C3q NZ002Q 2026-01-12T14:18:11.391Z 2026-01-19T15:19:46.035Z
9183269 9183269 20260111090732_bXY3j NZ002Q 2026-01-12T14:17:19.643Z 2026-01-19T15:19:33.876Z
9183233 9183233 20260111090057_t708U NZ002Q 2026-01-12T14:17:14.298Z 2026-01-19T15:19:32.612Z
9179319 9179319 20260111154359_rbJF7 NZ002Q 2026-01-12T14:01:08.188Z 2026-01-20T15:20:10.074Z
9178924 9178924 20260110142913_jkfLL NZ002Q 2026-01-11T14:16:04.712Z 2026-01-18T15:11:24.658Z
9178784 9178784 20260110140946_IYRJs NZ002Q 2026-01-11T14:15:43.598Z 2026-01-18T15:11:17.074Z
9178764 9178764 20260110140504_SGYrs NZ002Q 2026-01-11T14:15:41.902Z 2026-01-18T15:11:16.122Z
9178720 9178720 20260110135048_PbjGZ NZ002Q 2026-01-11T14:15:36.184Z 2026-01-18T15:11:12.991Z
9178563 9178563 20260110132525_JxKNy NZ002Q 2026-01-11T14:15:13.697Z 2026-01-18T15:11:06.352Z

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