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 = "NZ0037" 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
9270120 9270120 20260128145826_FL3k1 NZ0037 2026-01-29T14:10:56.336Z 2026-01-29T14:10:56.336Z
9269943 9269943 20260128143519_9U2LA NZ0037 2026-01-29T14:10:18.107Z 2026-01-29T14:10:18.107Z
9269871 9269871 20260128142546_Xndp1 NZ0037 2026-01-29T14:09:56.129Z 2026-01-29T14:09:56.129Z
9269753 9269753 20260128140907_enslc NZ0037 2026-01-29T14:09:30.889Z 2026-01-29T14:09:30.889Z
9269121 9269121 20260128123307_bv19U NZ0037 2026-01-29T14:06:36.529Z 2026-01-29T14:06:36.529Z
9268691 9268691 20260128110254_OFSGE NZ0037 2026-01-29T14:04:22.610Z 2026-01-29T14:04:22.610Z
9268668 9268668 20260128110009_iQh93 NZ0037 2026-01-29T14:04:17.137Z 2026-01-29T14:04:17.137Z
9268570 9268570 20260128104740_nshMf NZ0037 2026-01-29T14:03:50.659Z 2026-01-29T14:03:50.659Z
9268558 9268558 20260128104634_LrMIr NZ0037 2026-01-29T14:03:46.633Z 2026-01-29T14:03:46.633Z
9268525 9268525 20260128104052_ep7V8 NZ0037 2026-01-29T14:03:29.060Z 2026-01-29T14:03:29.060Z
9268451 9268451 20260128102219_uJHvN NZ0037 2026-01-29T14:03:11.288Z 2026-01-29T14:03:11.288Z
9268394 9268394 20260128100542_gcc2D NZ0037 2026-01-29T14:02:48.185Z 2026-01-29T14:02:48.185Z
9268327 9268327 20260128095042_nc1tO NZ0037 2026-01-29T14:02:24.495Z 2026-01-29T14:02:24.495Z
9268269 9268269 20260128093610_V7jY2 NZ0037 2026-01-29T14:02:09.343Z 2026-01-29T14:02:09.343Z
9268203 9268203 20260128091857_uDF6I NZ0037 2026-01-29T14:01:40.009Z 2026-01-29T14:01:40.009Z
9268197 9268197 20260128091759_Ikh3c NZ0037 2026-01-29T14:01:37.700Z 2026-01-29T14:01:37.700Z
9268080 9268080 20260128084339_NYQQR NZ0037 2026-01-29T14:00:57.309Z 2026-01-29T14:00:57.309Z
9265921 9265921 20260127161622_D2xm4 NZ0037 2026-01-28T14:11:46.743Z 2026-01-29T14:30:24.738Z
9264049 9264049 20260127110430_tY40i NZ0037 2026-01-28T14:04:08.371Z 2026-01-29T14:30:20.030Z
9261202 9261202 20260126102702_p6TeH NZ0037 2026-01-27T14:02:32.529Z 2026-01-29T14:32:04.083Z
9261192 9261192 20260126102204_Lj0Sv NZ0037 2026-01-27T14:02:26.841Z 2026-01-29T14:32:03.207Z
9261185 9261185 20260126101847_6F0Pn NZ0037 2026-01-27T14:02:24.228Z 2026-01-29T14:32:02.509Z
9261094 9261094 20260126095102_tQPvA NZ0037 2026-01-27T14:01:51.819Z 2026-01-29T14:31:52.227Z
9257399 9257399 20260125132132_PVfJw NZ0037 2026-01-26T14:05:24.024Z 2026-01-29T14:37:10.451Z
9257165 9257165 20260125121303_fDyAu NZ0037 2026-01-26T14:03:59.756Z 2026-01-29T14:36:51.821Z
9256771 9256771 20260125102320_KkEyk NZ0037 2026-01-26T14:01:54.797Z 2026-01-29T14:36:23.462Z
9256601 9256601 20260125091712_cMM0U NZ0037 2026-01-26T14:00:51.377Z 2026-01-29T14:36:11.498Z
9253779 9253779 20260124143438_sDRvd NZ0037 2026-01-25T14:04:23.255Z 2026-01-29T14:41:26.840Z
9253732 9253732 20260124140739_g6nYw NZ0037 2026-01-25T14:04:09.276Z 2026-01-29T14:41:21.031Z
9253726 9253726 20260124140335_F8zNt NZ0037 2026-01-25T14:04:07.233Z 2026-01-29T14:41:19.985Z
9253711 9253711 20260124135855_88rJT NZ0037 2026-01-25T14:04:04.096Z 2026-01-29T14:41:19.237Z
9253534 9253534 20260124123309_exgqo NZ0037 2026-01-25T14:03:13.290Z 2026-01-29T14:40:56.094Z
9253522 9253522 20260124122743_v4DaK NZ0037 2026-01-25T14:03:07.725Z 2026-01-29T14:40:55.177Z
9253512 9253512 20260124121938_L0CpB NZ0037 2026-01-25T14:03:04.518Z 2026-01-29T14:40:54.251Z
9252978 9252978 20260123084613_sfbU9 NZ0037 2026-01-24T14:18:05.168Z 2026-01-29T14:53:45.892Z
9252956 9252956 20260123083822_suy5s NZ0037 2026-01-24T14:18:00.045Z 2026-01-29T14:53:44.585Z
9250526 9250526 20260123161135_vAJXT NZ0037 2026-01-24T14:03:23.849Z 2026-01-29T14:45:53.709Z
9250512 9250512 20260123155032_laua6 NZ0037 2026-01-24T14:03:19.457Z 2026-01-29T14:45:44.113Z
9250275 9250275 20260123120133_NkvfC NZ0037 2026-01-24T14:02:04.356Z 2026-01-29T14:45:12.328Z
9250265 9250265 20260123115756_24wbU NZ0037 2026-01-24T14:02:01.732Z 2026-01-29T14:45:11.588Z
9250260 9250260 20260123115449_R3qOa NZ0037 2026-01-24T14:02:00.386Z 2026-01-29T14:45:11.242Z
9250201 9250201 20260123110336_7DSax NZ0037 2026-01-24T14:01:39.108Z 2026-01-29T14:45:05.234Z
9250176 9250176 20260123105710_Gyvtv NZ0037 2026-01-24T14:01:34.586Z 2026-01-29T14:45:03.781Z
9250145 9250145 20260123104455_dP3dX NZ0037 2026-01-24T14:01:26.251Z 2026-01-29T14:45:01.945Z
9250031 9250031 20260123095106_6ejai NZ0037 2026-01-24T14:00:43.841Z 2026-01-29T14:44:54.397Z
9249980 9249980 20260123092449_upuBe NZ0037 2026-01-24T14:00:26.587Z 2026-01-29T14:44:46.140Z
9216144 9216144 20260116115646_YFnqI NZ0037 2026-01-17T14:28:02.569Z 2026-01-24T15:15:39.441Z
9216131 9216131 20260116115435_hI9d3 NZ0037 2026-01-17T14:28:00.196Z 2026-01-24T15:15:34.689Z
9215936 9215936 20260116112639_JLa12 NZ0037 2026-01-17T14:27:17.934Z 2026-01-24T15:15:18.872Z
9215843 9215843 20260116110928_8KZxe NZ0037 2026-01-17T14:27:04.326Z 2026-01-24T15:15:15.037Z
9215819 9215819 20260116110411_UhH3X NZ0037 2026-01-17T14:27:00.060Z 2026-01-24T15:15:14.322Z
9215795 9215795 20260116110151_Mm0e4 NZ0037 2026-01-17T14:26:52.584Z 2026-01-24T15:15:13.447Z
9215779 9215779 20260116110007_W2liJ NZ0037 2026-01-17T14:26:50.576Z 2026-01-24T15:15:13.090Z
9215767 9215767 20260116105935_sH3a7 NZ0037 2026-01-17T14:26:48.709Z 2026-01-24T15:15:12.826Z
9215725 9215725 20260116105222_iAOnh NZ0037 2026-01-17T14:26:41.915Z 2026-01-24T15:15:11.270Z
9215715 9215715 20260116105034_j9hrI NZ0037 2026-01-17T14:26:39.591Z 2026-01-24T15:15:10.609Z
9215607 9215607 20260116103516_hzA0C NZ0037 2026-01-17T14:26:16.003Z 2026-01-24T15:15:04.867Z
9215513 9215513 20260116102311_cHeUx NZ0037 2026-01-17T14:25:57.404Z 2026-01-24T15:15:00.841Z
9215395 9215395 20260116100442_6tHQW NZ0037 2026-01-17T14:25:27.206Z 2026-01-24T15:14:44.160Z
9215338 9215338 20260116095655_qJnIU NZ0037 2026-01-17T14:25:14.329Z 2026-01-24T15:14:42.013Z
9215321 9215321 20260116095423_u0Sa2 NZ0037 2026-01-17T14:25:10.653Z 2026-01-24T15:14:41.079Z
9215314 9215314 20260116095354_Y9TgM NZ0037 2026-01-17T14:25:09.826Z 2026-01-24T15:14:40.970Z
9215016 9215016 20260116085944_wDjva NZ0037 2026-01-17T14:24:05.770Z 2026-01-24T15:14:26.888Z
9214949 9214949 20260116084954_52kom NZ0037 2026-01-17T14:23:55.466Z 2026-01-24T15:14:24.244Z
9211108 9211108 20260116155959_xzOuF NZ0037 2026-01-17T14:04:23.433Z 2026-01-25T14:57:21.491Z
9211100 9211100 20260116155719_A0gCQ NZ0037 2026-01-17T14:04:20.491Z 2026-01-25T14:57:21.046Z
9211056 9211056 20260116151854_eUjKX NZ0037 2026-01-17T14:04:05.957Z 2026-01-25T14:57:17.941Z
9211023 9211023 20260116150245_u0zPf NZ0037 2026-01-17T14:03:54.651Z 2026-01-25T14:57:16.216Z
9210996 9210996 20260116142924_oYkr2 NZ0037 2026-01-17T14:03:44.479Z 2026-01-25T14:57:13.794Z
9210990 9210990 20260116142751_LRCsd NZ0037 2026-01-17T14:03:42.853Z 2026-01-25T14:57:13.664Z
9210972 9210972 20260116142100_506uD NZ0037 2026-01-17T14:03:38.058Z 2026-01-25T14:57:13.161Z
9210953 9210953 20260116141524_OXEXp NZ0037 2026-01-17T14:03:32.679Z 2026-01-25T14:57:12.631Z
9210944 9210944 20260116141314_L3Sjx NZ0037 2026-01-17T14:03:29.353Z 2026-01-25T14:57:12.422Z
9210918 9210918 20260116140627_vK6M5 NZ0037 2026-01-17T14:03:24.366Z 2026-01-25T14:57:11.678Z
9210900 9210900 20260116135525_CzRNA NZ0037 2026-01-17T14:03:21.562Z 2026-01-25T14:57:11.280Z
9210885 9210885 20260116134637_3FeiW NZ0037 2026-01-17T14:03:15.028Z 2026-01-25T14:57:10.552Z
9210870 9210870 20260116134337_uq8Mx NZ0037 2026-01-17T14:03:12.774Z 2026-01-25T14:57:10.168Z
9210853 9210853 20260116133922_zECUS NZ0037 2026-01-17T14:03:10.362Z 2026-01-25T14:57:09.639Z
9210845 9210845 20260116133415_93Wv2 NZ0037 2026-01-17T14:03:05.751Z 2026-01-25T14:57:09.450Z
9210808 9210808 20260116132413_5OHGR NZ0037 2026-01-17T14:02:55.755Z 2026-01-25T14:57:08.209Z
9210790 9210790 20260116131648_t42WF NZ0037 2026-01-17T14:02:51.180Z 2026-01-25T14:56:59.029Z
9210766 9210766 20260116131347_wBV6M NZ0037 2026-01-17T14:02:43.103Z 2026-01-25T14:56:55.218Z
9210758 9210758 20260116130855_JB2kK NZ0037 2026-01-17T14:02:40.987Z 2026-01-25T14:56:54.685Z
9210743 9210743 20260116130544_3aGRp NZ0037 2026-01-17T14:02:35.598Z 2026-01-25T14:56:54.282Z
9210689 9210689 20260116125619_TCeii NZ0037 2026-01-17T14:02:21.966Z 2026-01-25T14:56:52.643Z
9210593 9210593 20260116123904_gt5f3 NZ0037 2026-01-17T14:01:54.090Z 2026-01-25T14:56:48.455Z
9210542 9210542 20260116123106_pS3EX NZ0037 2026-01-17T14:01:33.371Z 2026-01-25T14:56:46.252Z
9210506 9210506 20260116122631_uoCZr NZ0037 2026-01-17T14:01:19.215Z 2026-01-25T14:56:45.297Z
9210459 9210459 20260116122358_BTANR NZ0037 2026-01-17T14:01:06.590Z 2026-01-25T14:56:43.872Z
9210440 9210440 20260116122035_0gc4X NZ0037 2026-01-17T14:00:59.167Z 2026-01-25T14:56:43.202Z
9210305 9210305 20260116120008_R0B16 NZ0037 2026-01-17T14:00:11.036Z 2026-01-25T14:56:39.441Z
9205803 9205803 20260112121055_UxPy8 NZ0037 2026-01-15T14:49:38.667Z 2026-01-20T15:26:10.008Z
9193210 9193210 20260112091853_XIdce NZ0037 2026-01-13T14:30:41.976Z 2026-01-20T15:24:38.321Z
9193165 9193165 20260112134442_zFU9c NZ0037 2026-01-13T14:30:19.918Z 2026-01-20T15:27:01.802Z
9193141 9193141 20260112134144_LZIW3 NZ0037 2026-01-13T14:30:16.434Z 2026-01-20T15:27:00.945Z
9193137 9193137 20260112134114_TnBlO NZ0037 2026-01-13T14:30:15.775Z 2026-01-20T15:27:00.845Z
9193079 9193079 20260112133457_Dly2l NZ0037 2026-01-13T14:30:07.047Z 2026-01-20T15:26:58.486Z
9192837 9192837 20260112130609_YaST2 NZ0037 2026-01-13T14:29:27.796Z 2026-01-20T15:26:36.252Z
9192790 9192790 20260112130221_0gcVF NZ0037 2026-01-13T14:29:18.875Z 2026-01-20T15:26:33.421Z
9192700 9192700 20260112125427_mS26y NZ0037 2026-01-13T14:29:04.146Z 2026-01-20T15:26:30.263Z

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