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 = "NZ0036" 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
9270628 9270628 20260128161510_NCbQG NZ0036 2026-01-29T14:13:03.742Z 2026-01-29T14:13:03.742Z
9270176 9270176 20260128150547_nXx2f NZ0036 2026-01-29T14:11:11.487Z 2026-01-29T14:11:11.487Z
9270149 9270149 20260128150236_ogKps NZ0036 2026-01-29T14:11:06.801Z 2026-01-29T14:11:06.801Z
9270044 9270044 20260128145026_fAr5n NZ0036 2026-01-29T14:10:43.539Z 2026-01-29T14:10:43.539Z
9270035 9270035 20260128145019_OISQU NZ0036 2026-01-29T14:10:42.259Z 2026-01-29T14:10:42.259Z
9269985 9269985 20260128144046_jHFHS NZ0036 2026-01-29T14:10:26.908Z 2026-01-29T14:10:26.908Z
9269512 9269512 20260128132856_2tmi5 NZ0036 2026-01-29T14:08:20.831Z 2026-01-29T14:08:20.831Z
9269405 9269405 20260128131256_Gv3ul NZ0036 2026-01-29T14:07:52.461Z 2026-01-29T14:07:52.461Z
9269319 9269319 20260128130214_I55vX NZ0036 2026-01-29T14:07:27.623Z 2026-01-29T14:07:27.623Z
9269245 9269245 20260128125024_YcajY NZ0036 2026-01-29T14:07:05.843Z 2026-01-29T14:07:05.843Z
9268667 9268667 20260128110009_iQh93 NZ0036 2026-01-29T14:04:17.137Z 2026-01-29T14:04:17.137Z
9268472 9268472 20260128102651_zYYTK NZ0036 2026-01-29T14:03:16.742Z 2026-01-29T14:03:16.742Z
9268340 9268340 20260128095355_Sy9RW NZ0036 2026-01-29T14:02:30.031Z 2026-01-29T14:02:30.031Z
9265915 9265915 20260127161607_WXRPa NZ0036 2026-01-28T14:11:45.036Z 2026-01-29T14:30:24.737Z
9265691 9265691 20260127154924_PzL5m NZ0036 2026-01-28T14:11:00.477Z 2026-01-29T14:30:24.655Z
9261638 9261638 20260126123755_wR2j0 NZ0036 2026-01-27T14:04:48.607Z 2026-01-29T14:32:45.325Z
9261149 9261149 20260126100241_n3W0n NZ0036 2026-01-27T14:02:13.549Z 2026-01-29T14:31:59.611Z
9256837 9256837 20260125104024_yoGWm NZ0036 2026-01-26T14:02:12.258Z 2026-01-29T14:36:26.528Z
9256770 9256770 20260125102320_KkEyk NZ0036 2026-01-26T14:01:54.797Z 2026-01-29T14:36:23.462Z
9256608 9256608 20260125093023_ChKHN NZ0036 2026-01-26T14:00:56.848Z 2026-01-29T14:36:11.916Z
9253724 9253724 20260124140228_A87jf NZ0036 2026-01-25T14:04:06.385Z 2026-01-29T14:41:19.644Z
9253528 9253528 20260124122929_hRYgP NZ0036 2026-01-25T14:03:11.758Z 2026-01-29T14:40:55.612Z
9253479 9253479 20260124120705_X2L48 NZ0036 2026-01-25T14:02:57.065Z 2026-01-29T14:40:52.524Z
9250494 9250494 20260123153552_8292X NZ0036 2026-01-24T14:03:14.859Z 2026-01-29T14:45:41.051Z
9250485 9250485 20260123153217_c2coc NZ0036 2026-01-24T14:03:10.666Z 2026-01-29T14:45:38.396Z
9250482 9250482 20260123153038_UYaQo NZ0036 2026-01-24T14:03:09.994Z 2026-01-29T14:45:38.284Z
9250264 9250264 20260123115748_5cTwp NZ0036 2026-01-24T14:02:01.153Z 2026-01-29T14:45:11.476Z
9250183 9250183 20260123105800_KKtR0 NZ0036 2026-01-24T14:01:35.844Z 2026-01-29T14:45:04.138Z
9250159 9250159 20260123105412_g512c NZ0036 2026-01-24T14:01:30.012Z 2026-01-29T14:45:02.684Z
9250156 9250156 20260123105048_i5u31 NZ0036 2026-01-24T14:01:29.355Z 2026-01-29T14:45:02.571Z
9250130 9250130 20260123103724_42Mp8 NZ0036 2026-01-24T14:01:20.089Z 2026-01-29T14:45:01.004Z
9250056 9250056 20260123100020_ptztq NZ0036 2026-01-24T14:00:54.096Z 2026-01-29T14:44:56.220Z
9246995 9246995 20260121161002_GbL2f NZ0036 2026-01-23T14:08:43.153Z 2026-01-29T14:55:36.960Z
9216126 9216126 20260116115308_5c2FQ NZ0036 2026-01-17T14:27:59.626Z 2026-01-24T15:15:34.493Z
9216115 9216115 20260116115204_xIz97 NZ0036 2026-01-17T14:27:57.909Z 2026-01-24T15:15:33.491Z
9216101 9216101 20260116114946_LDPvL NZ0036 2026-01-17T14:27:55.969Z 2026-01-24T15:15:28.139Z
9216030 9216030 20260116114255_fZqqw NZ0036 2026-01-17T14:27:40.450Z 2026-01-24T15:15:23.851Z
9215909 9215909 20260116112355_2vP93 NZ0036 2026-01-17T14:27:13.747Z 2026-01-24T15:15:17.234Z
9215794 9215794 20260116110151_Mm0e4 NZ0036 2026-01-17T14:26:52.584Z 2026-01-24T15:15:13.447Z
9215714 9215714 20260116105034_j9hrI NZ0036 2026-01-17T14:26:39.591Z 2026-01-24T15:15:10.609Z
9215703 9215703 20260116104852_sZq24 NZ0036 2026-01-17T14:26:37.606Z 2026-01-24T15:15:10.135Z
9215687 9215687 20260116104609_2Ph7I NZ0036 2026-01-17T14:26:34.609Z 2026-01-24T15:15:09.275Z
9215628 9215628 20260116103738_oX829 NZ0036 2026-01-17T14:26:19.447Z 2026-01-24T15:15:05.660Z
9215451 9215451 20260116101418_x3HYJ NZ0036 2026-01-17T14:25:36.235Z 2026-01-24T15:14:52.047Z
9215015 9215015 20260116085944_wDjva NZ0036 2026-01-17T14:24:05.770Z 2026-01-24T15:14:26.888Z
9211036 9211036 20260116150911_264BO NZ0036 2026-01-17T14:03:58.307Z 2026-01-25T14:57:16.743Z
9210981 9210981 20260116142200_0H2jZ NZ0036 2026-01-17T14:03:40.934Z 2026-01-25T14:57:13.353Z
9210970 9210970 20260116142043_Zj08D NZ0036 2026-01-17T14:03:37.193Z 2026-01-25T14:57:13.060Z
9210961 9210961 20260116141747_0eXKe NZ0036 2026-01-17T14:03:35.859Z 2026-01-25T14:57:12.907Z
9210924 9210924 20260116140709_M1gAa NZ0036 2026-01-17T14:03:25.038Z 2026-01-25T14:57:11.786Z
9210913 9210913 20260116140331_CMuHh NZ0036 2026-01-17T14:03:23.683Z 2026-01-25T14:57:11.615Z
9210910 9210910 20260116140252_UeIXe NZ0036 2026-01-17T14:03:23.004Z 2026-01-25T14:57:11.533Z
9210822 9210822 20260116132600_oB332 NZ0036 2026-01-17T14:02:58.788Z 2026-01-25T14:57:08.710Z
9210796 9210796 20260116131705_LH6BG NZ0036 2026-01-17T14:02:52.443Z 2026-01-25T14:57:01.912Z
9210639 9210639 20260116124744_gHO1f NZ0036 2026-01-17T14:02:06.910Z 2026-01-25T14:56:50.037Z
9210630 9210630 20260116124500_2t8R5 NZ0036 2026-01-17T14:02:03.702Z 2026-01-25T14:56:49.660Z
9210439 9210439 20260116122035_0gc4X NZ0036 2026-01-17T14:00:59.167Z 2026-01-25T14:56:43.202Z
9210378 9210378 20260116121201_BLcK2 NZ0036 2026-01-17T14:00:36.199Z 2026-01-25T14:56:41.303Z
9205612 9205612 20260112142852_6C007 NZ0036 2026-01-15T14:33:54.438Z 2026-01-21T15:02:27.808Z
9193153 9193153 20260112134207_sBLwp NZ0036 2026-01-13T14:30:17.658Z 2026-01-20T15:27:01.294Z
9193078 9193078 20260112133457_Dly2l NZ0036 2026-01-13T14:30:07.047Z 2026-01-20T15:26:58.486Z
9192933 9192933 20260112131609_83TLe NZ0036 2026-01-13T14:29:41.181Z 2026-01-20T15:26:39.683Z
9192612 9192612 20260112124737_v72HA NZ0036 2026-01-13T14:28:51.535Z 2026-01-20T15:26:27.126Z
9192317 9192317 20260112122324_dSEj7 NZ0036 2026-01-13T14:28:03.974Z 2026-01-20T15:26:18.313Z
9192298 9192298 20260112122127_sLuhN NZ0036 2026-01-13T14:28:01.029Z 2026-01-20T15:26:17.464Z
9191706 9191706 20260112113540_c5NCz NZ0036 2026-01-13T14:26:13.283Z 2026-01-20T15:25:44.167Z
9191633 9191633 20260112112700_vzZyb NZ0036 2026-01-13T14:25:56.319Z 2026-01-20T15:25:41.275Z
9191586 9191586 20260112112246_RA8w5 NZ0036 2026-01-13T14:25:48.664Z 2026-01-20T15:25:39.583Z
9191225 9191225 20260112104854_QbGhu NZ0036 2026-01-13T14:24:46.454Z 2026-01-20T15:25:15.188Z
9191203 9191203 20260112104542_QbWc3 NZ0036 2026-01-13T14:24:41.424Z 2026-01-20T15:25:14.463Z
9190873 9190873 20260112100841_Ao1K2 NZ0036 2026-01-13T14:23:43.101Z 2026-01-20T15:24:52.457Z
9190844 9190844 20260112100433_GydPb NZ0036 2026-01-13T14:23:36.594Z 2026-01-20T15:24:51.471Z
9190794 9190794 20260112095903_pLwd9 NZ0036 2026-01-13T14:23:29.953Z 2026-01-20T15:24:48.642Z
9190642 9190642 20260112093315_BK7GR NZ0036 2026-01-13T14:22:56.762Z 2026-01-20T15:24:41.664Z
9190593 9190593 20260112092622_3aXD0 NZ0036 2026-01-13T14:22:49.429Z 2026-01-20T15:24:40.095Z
9187114 9187114 20260111151511_0ddHf NZ0036 2026-01-13T14:05:32.154Z 2026-01-20T15:20:00.941Z
9186813 9186813 20260112154403_AlWTD NZ0036 2026-01-13T14:03:37.204Z 2026-01-13T14:03:37.204Z
9186648 9186648 20260112151436_92rkw NZ0036 2026-01-13T14:02:50.646Z 2026-01-21T15:02:49.110Z
9186405 9186405 20260112143139_As91s NZ0036 2026-01-13T14:01:48.331Z 2026-01-21T15:02:28.314Z
9186359 9186359 20260112142617_9K3cH NZ0036 2026-01-13T14:01:36.615Z 2026-01-21T15:02:23.029Z
9186346 9186346 20260112142330_nWK5w NZ0036 2026-01-13T14:01:31.344Z 2026-01-21T15:02:22.606Z
9185683 9185683 20260111123132_DnS3u NZ0036 2026-01-12T14:25:37.015Z 2026-01-19T15:21:19.146Z
9185651 9185651 20260111122200_bSrlA NZ0036 2026-01-12T14:25:24.402Z 2026-01-19T15:21:14.767Z
9185313 9185313 20260111135434_9ocZ1 NZ0036 2026-01-12T14:23:01.276Z 2026-01-19T15:22:05.557Z
9185229 9185229 20260111133109_ema6L NZ0036 2026-01-12T14:22:49.712Z 2026-01-19T15:21:58.976Z
9185199 9185199 20260111132504_aQgPs NZ0036 2026-01-12T14:22:43.516Z 2026-01-19T15:21:56.928Z
9185090 9185090 20260111130603_g2EUZ NZ0036 2026-01-12T14:22:27.954Z 2026-01-19T15:21:48.865Z
9184872 9184872 20260111123149_WuLJG NZ0036 2026-01-12T14:21:48.113Z 2026-01-19T15:21:19.512Z
9184846 9184846 20260111122804_W2aDS NZ0036 2026-01-12T14:21:44.381Z 2026-01-12T14:21:44.381Z
9184789 9184789 20260111122007_bzUvm NZ0036 2026-01-12T14:21:35.446Z 2026-01-19T15:21:13.631Z
9184754 9184754 20260111121554_O74nj NZ0036 2026-01-12T14:21:31.380Z 2026-01-19T15:21:12.020Z
9184566 9184566 20260111115141_lbBhF NZ0036 2026-01-12T14:21:03.672Z 2026-01-19T15:21:04.518Z
9184336 9184336 20260111111409_C42Ps NZ0036 2026-01-12T14:20:17.399Z 2026-01-19T15:20:33.954Z
9184266 9184266 20260111110242_F95uH NZ0036 2026-01-12T14:20:08.800Z 2026-01-19T15:20:31.079Z
9184206 9184206 20260111105621_iIEE2 NZ0036 2026-01-12T14:19:56.790Z 2026-01-19T15:20:27.302Z
9184040 9184040 20260111103806_QiT8m NZ0036 2026-01-12T14:19:32.631Z 2026-01-19T15:20:20.326Z
9183980 9183980 20260111103219_ABJ1t NZ0036 2026-01-12T14:19:20.388Z 2026-01-19T15:20:18.562Z
9183958 9183958 20260111103119_LWcOX NZ0036 2026-01-12T14:19:17.787Z 2026-01-19T15:20:17.892Z
9183866 9183866 20260111102338_iOCax NZ0036 2026-01-12T14:19:04.131Z 2026-01-19T15:20:15.057Z
9183831 9183831 20260111102049_b81Vt NZ0036 2026-01-12T14:18:56.835Z 2026-01-19T15:20:13.547Z

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