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 = "NZ003Y" 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
9270323 9270323 20260128153109_7Ht6q NZ003Y 2026-01-29T14:11:45.333Z 2026-01-29T14:11:45.333Z
9270271 9270271 20260128152315_c0tux NZ003Y 2026-01-29T14:11:30.016Z 2026-01-29T14:11:30.016Z
9270237 9270237 20260128151845_iBDIW NZ003Y 2026-01-29T14:11:22.545Z 2026-01-29T14:11:22.545Z
9270199 9270199 20260128151420_gblJ9 NZ003Y 2026-01-29T14:11:17.655Z 2026-01-29T14:11:17.655Z
9270173 9270173 20260128150547_zw4vW NZ003Y 2026-01-29T14:11:10.922Z 2026-01-29T14:11:10.922Z
9270127 9270127 20260128145826_2Npm8 NZ003Y 2026-01-29T14:10:56.995Z 2026-01-29T14:10:56.995Z
9270001 9270001 20260128144245_pzPgu NZ003Y 2026-01-29T14:10:29.513Z 2026-01-29T14:10:29.513Z
9269694 9269694 20260128135503_73CHQ NZ003Y 2026-01-29T14:09:05.573Z 2026-01-29T14:09:05.573Z
9269431 9269431 20260128131708_hnE3l NZ003Y 2026-01-29T14:07:58.412Z 2026-01-29T14:07:58.412Z
9269394 9269394 20260128131218_4rOKL NZ003Y 2026-01-29T14:07:49.989Z 2026-01-29T14:07:49.989Z
9269312 9269312 20260128130214_hRGts NZ003Y 2026-01-29T14:07:27.156Z 2026-01-29T14:07:27.156Z
9269295 9269295 20260128125810_S78w8 NZ003Y 2026-01-29T14:07:23.917Z 2026-01-29T14:07:23.917Z
9269289 9269289 20260128125809_Xpa3O NZ003Y 2026-01-29T14:07:22.823Z 2026-01-29T14:07:22.823Z
9269284 9269284 20260128125612_YnisA NZ003Y 2026-01-29T14:07:21.598Z 2026-01-29T14:07:21.598Z
9269081 9269081 20260128122033_PnwXw NZ003Y 2026-01-29T14:06:21.399Z 2026-01-29T14:06:21.399Z
9269062 9269062 20260128121514_96PRD NZ003Y 2026-01-29T14:06:13.568Z 2026-01-29T14:06:13.568Z
9269049 9269049 20260128121304_5BgoR NZ003Y 2026-01-29T14:06:09.799Z 2026-01-29T14:06:09.799Z
9268780 9268780 20260128111754_wfxIB NZ003Y 2026-01-29T14:04:50.573Z 2026-01-29T14:04:50.573Z
9268698 9268698 20260128110320_tCHP2 NZ003Y 2026-01-29T14:04:23.747Z 2026-01-29T14:04:23.747Z
9268665 9268665 20260128110008_tCrC2 NZ003Y 2026-01-29T14:04:16.544Z 2026-01-29T14:04:16.544Z
9268636 9268636 20260128105646_zCC9Q NZ003Y 2026-01-29T14:04:07.504Z 2026-01-29T14:04:07.504Z
9268588 9268588 20260128104800_jRx1Q NZ003Y 2026-01-29T14:03:52.991Z 2026-01-29T14:03:52.991Z
9268520 9268520 20260128104051_ePKU4 NZ003Y 2026-01-29T14:03:28.394Z 2026-01-29T14:03:28.394Z
9268468 9268468 20260128102543_5xaEp NZ003Y 2026-01-29T14:03:16.046Z 2026-01-29T14:03:16.046Z
9268283 9268283 20260128094447_dAaKE NZ003Y 2026-01-29T14:02:12.374Z 2026-01-29T14:02:12.374Z
9261498 9261498 20260126115827_dGvdB NZ003Y 2026-01-27T14:04:04.702Z 2026-01-29T14:32:36.130Z
9260912 9260912 20260126083705_iHop2 NZ003Y 2026-01-27T14:00:48.003Z 2026-01-29T14:31:13.232Z
9257634 9257634 20260125150601_YaJ27 NZ003Y 2026-01-26T14:06:51.914Z 2026-01-29T14:37:31.690Z
9253944 9253944 20260124160625_O1p6u NZ003Y 2026-01-25T14:05:06.320Z 2026-01-29T14:41:52.454Z
9253750 9253750 20260124142352_uJoni NZ003Y 2026-01-25T14:04:14.295Z 2026-01-29T14:41:23.931Z
9253682 9253682 20260124134313_Hkwwm NZ003Y 2026-01-25T14:03:56.559Z 2026-01-29T14:41:16.567Z
9253569 9253569 20260124124836_Ep1TC NZ003Y 2026-01-25T14:03:21.645Z 2026-01-29T14:40:58.298Z
9253529 9253529 20260124122929_hRYgP NZ003Y 2026-01-25T14:03:11.758Z 2026-01-29T14:40:55.612Z
9253523 9253523 20260124122743_v4DaK NZ003Y 2026-01-25T14:03:07.725Z 2026-01-29T14:40:55.178Z
9253152 9253152 20260124094426_WGwd2 NZ003Y 2026-01-25T14:00:57.540Z 2026-01-29T14:40:21.442Z
9253148 9253148 20260124094329_CrBjt NZ003Y 2026-01-25T14:00:56.890Z 2026-01-29T14:40:21.206Z
9253110 9253110 20260124092311_825mW NZ003Y 2026-01-25T14:00:44.797Z 2026-01-29T14:40:17.846Z
9253100 9253100 20260124091926_UPJG8 NZ003Y 2026-01-25T14:00:42.153Z 2026-01-29T14:40:15.271Z
9253065 9253065 20260124090220_q1JUl NZ003Y 2026-01-25T14:00:28.620Z 2026-01-29T14:40:13.408Z
9250518 9250518 20260123155300_D2obM NZ003Y 2026-01-24T14:03:21.345Z 2026-01-29T14:45:44.507Z
9250500 9250500 20260123153553_Vuj23 NZ003Y 2026-01-24T14:03:15.357Z 2026-01-29T14:45:41.178Z
9250273 9250273 20260123120038_5BwWJ NZ003Y 2026-01-24T14:02:03.601Z 2026-01-29T14:45:12.001Z
9250187 9250187 20260123105800_Clz4E NZ003Y 2026-01-24T14:01:36.142Z 2026-01-29T14:45:04.341Z
9250088 9250088 20260123101018_fypz1 NZ003Y 2026-01-24T14:01:04.365Z 2026-01-29T14:44:57.789Z
9250059 9250059 20260123100026_yQ9ow NZ003Y 2026-01-24T14:00:54.968Z 2026-01-29T14:44:56.322Z
9250038 9250038 20260123095330_f2o1g NZ003Y 2026-01-24T14:00:47.055Z 2026-01-29T14:44:54.883Z
9246558 9246558 20260121121341_jaE14 NZ003Y 2026-01-23T14:07:02.054Z 2026-01-29T14:54:39.780Z
9245967 9245967 20260122155038_mVonv NZ003Y 2026-01-23T14:04:10.382Z 2026-01-29T14:50:27.467Z
9245935 9245935 20260122153625_IcZuv NZ003Y 2026-01-23T14:04:04.642Z 2026-01-29T14:50:25.675Z
9245928 9245928 20260122153554_2hyAK NZ003Y 2026-01-23T14:04:03.903Z 2026-01-29T14:50:25.339Z
9245887 9245887 20260122151533_P2MKe NZ003Y 2026-01-23T14:03:57.227Z 2026-01-29T14:50:20.780Z
9245863 9245863 20260122150423_0r2L8 NZ003Y 2026-01-23T14:03:46.845Z 2026-01-29T14:50:18.950Z
9245751 9245751 20260122141111_NCgUs NZ003Y 2026-01-23T14:03:17.272Z 2026-01-29T14:50:08.303Z
9245747 9245747 20260122141052_oDSwV NZ003Y 2026-01-23T14:03:15.430Z 2026-01-29T14:50:08.201Z
9245415 9245415 20260122121818_yIjxv NZ003Y 2026-01-23T14:01:52.778Z 2026-01-29T14:49:32.356Z
9245387 9245387 20260122120824_qfIgK NZ003Y 2026-01-23T14:01:48.369Z 2026-01-29T14:49:29.953Z
9245267 9245267 20260122113214_nmcJo NZ003Y 2026-01-23T14:01:15.756Z 2026-01-29T14:49:19.469Z
9245047 9245047 20260122093758_UxMkR NZ003Y 2026-01-23T14:00:17.515Z 2026-01-29T14:48:53.602Z
9205605 9205605 20260114123744_lJi7w NZ003Y 2026-01-15T14:31:41.220Z 2026-01-22T15:11:17.483Z
9196792 9196792 20260113090442_1jHWA NZ003Y 2026-01-14T14:20:08.652Z 2026-01-21T15:05:56.655Z
9196775 9196775 20260113090240_dZUJm NZ003Y 2026-01-14T14:19:59.873Z 2026-01-21T15:05:48.921Z
9193384 9193384 20260113140906_0ivOg NZ003Y 2026-01-14T14:01:03.452Z 2026-01-22T15:06:15.554Z
9193160 9193160 20260112134238_tKxCz NZ003Y 2026-01-13T14:30:18.840Z 2026-01-20T15:27:01.558Z
9192974 9192974 20260112132216_L21iZ NZ003Y 2026-01-13T14:29:53.531Z 2026-01-20T15:26:50.495Z
9192934 9192934 20260112131609_83TLe NZ003Y 2026-01-13T14:29:41.181Z 2026-01-20T15:26:39.683Z
9192843 9192843 20260112130719_nrTz0 NZ003Y 2026-01-13T14:29:29.305Z 2026-01-20T15:26:36.730Z
9192177 9192177 20260112121056_jBYcA NZ003Y 2026-01-13T14:27:40.420Z 2026-01-20T15:26:12.032Z
9191887 9191887 20260112114902_U7Mi4 NZ003Y 2026-01-13T14:26:45.889Z 2026-01-20T15:25:50.276Z
9191789 9191789 20260112114534_kVmun NZ003Y 2026-01-13T14:26:24.171Z 2026-01-20T15:25:47.041Z
9187268 9187268 20260111155611_e9R4s NZ003Y 2026-01-13T14:06:28.747Z 2026-01-20T15:20:12.630Z
9187241 9187241 20260111155125_V68Hl NZ003Y 2026-01-13T14:06:22.043Z 2026-01-20T15:20:11.161Z
9187239 9187239 20260111155047_lKudH NZ003Y 2026-01-13T14:06:21.150Z 2026-01-20T15:20:10.868Z
9187227 9187227 20260111154818_QtgsU NZ003Y 2026-01-13T14:06:17.081Z 2026-01-20T15:20:10.513Z
9187207 9187207 20260111153953_xB37L NZ003Y 2026-01-13T14:06:09.173Z 2026-01-20T15:20:09.342Z
9187189 9187189 20260111153604_x5H1t NZ003Y 2026-01-13T14:06:02.082Z 2026-01-20T15:20:06.794Z
9187154 9187154 20260111152500_YXNhJ NZ003Y 2026-01-13T14:05:47.171Z 2026-01-20T15:20:03.618Z
9187123 9187123 20260111151916_vRINd NZ003Y 2026-01-13T14:05:38.170Z 2026-01-20T15:20:01.697Z
9187111 9187111 20260111151459_tZ3Eq NZ003Y 2026-01-13T14:05:31.269Z 2026-01-20T15:20:00.685Z
9187088 9187088 20260111150705_aayFw NZ003Y 2026-01-13T14:05:23.385Z 2026-01-20T15:19:58.704Z
9187080 9187080 20260111150259_C3QoC NZ003Y 2026-01-13T14:05:20.041Z 2026-01-20T15:19:57.860Z
9187052 9187052 20260111145350_zTk07 NZ003Y 2026-01-13T14:05:08.950Z 2026-01-20T15:19:55.674Z
9186984 9186984 20260111143528_BSNoS NZ003Y 2026-01-13T14:04:42.102Z 2026-01-20T15:19:40.034Z
9186963 9186963 20260111143234_moni2 NZ003Y 2026-01-13T14:04:32.307Z 2026-01-20T15:19:38.646Z
9186958 9186958 20260111143116_sFQSM NZ003Y 2026-01-13T14:04:29.739Z 2026-01-20T15:19:37.730Z
9186934 9186934 20260111142538_7AtKx NZ003Y 2026-01-13T14:04:20.420Z 2026-01-20T15:19:33.800Z
9186928 9186928 20260111142129_buW3F NZ003Y 2026-01-13T14:04:16.231Z 2026-01-20T15:19:33.112Z
9186915 9186915 20260111141903_hjAWM NZ003Y 2026-01-13T14:04:12.800Z 2026-01-20T15:19:32.319Z
9186898 9186898 20260111141555_EKmxg NZ003Y 2026-01-13T14:04:06.868Z 2026-01-20T15:19:30.396Z
9186125 9186125 20260112135133_qNO3V NZ003Y 2026-01-13T14:00:24.357Z 2026-01-21T15:02:12.240Z
9185987 9185987 20260111140830_crulh NZ003Y 2026-01-12T14:26:33.816Z 2026-01-19T15:22:23.269Z
9185933 9185933 20260111135705_Y3bx2 NZ003Y 2026-01-12T14:26:19.606Z 2026-01-19T15:22:06.830Z
9185891 9185891 20260111134457_qYBvg NZ003Y 2026-01-12T14:26:14.085Z 2026-01-19T15:22:02.240Z
9185873 9185873 20260111133253_KjZ72 NZ003Y 2026-01-12T14:26:10.943Z 2026-01-19T15:21:59.485Z
9185860 9185860 20260111132853_whxBO NZ003Y 2026-01-12T14:26:09.110Z 2026-01-19T15:21:58.731Z
9185845 9185845 20260111132504_Tt9NA NZ003Y 2026-01-12T14:26:07.448Z 2026-01-19T15:21:57.091Z
9185820 9185820 20260111131916_N0Dkb NZ003Y 2026-01-12T14:26:03.747Z 2026-01-19T15:21:54.220Z
9185768 9185768 20260111130604_9rN3C NZ003Y 2026-01-12T14:25:50.310Z 2026-01-19T15:21:48.998Z
9185759 9185759 20260111130438_3mYUj NZ003Y 2026-01-12T14:25:49.329Z 2026-01-19T15:21:48.288Z
9185748 9185748 20260111125649_F1Iin NZ003Y 2026-01-12T14:25:47.844Z 2026-01-19T15:21:45.753Z
9185728 9185728 20260111125352_jfKxu NZ003Y 2026-01-12T14:25:45.610Z 2026-01-19T15:21:44.480Z

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