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 = "NZ004B" 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
9270536 9270536 20260128155843_jA3eP NZ004B 2026-01-29T14:12:40.150Z 2026-01-29T14:12:40.150Z
9270505 9270505 20260128155652_L2ia3 NZ004B 2026-01-29T14:12:27.512Z 2026-01-29T14:12:27.512Z
9270463 9270463 20260128155303_qIBzs NZ004B 2026-01-29T14:12:20.445Z 2026-01-29T14:12:20.445Z
9270424 9270424 20260128154803_iUa22 NZ004B 2026-01-29T14:12:13.219Z 2026-01-29T14:12:13.219Z
9270333 9270333 20260128153238_t2uM6 NZ004B 2026-01-29T14:11:47.007Z 2026-01-29T14:11:47.007Z
9270251 9270251 20260128152023_CkuUd NZ004B 2026-01-29T14:11:24.261Z 2026-01-29T14:11:24.261Z
9270184 9270184 20260128150824_Cp1Nx NZ004B 2026-01-29T14:11:13.071Z 2026-01-29T14:11:13.071Z
9270053 9270053 20260128145058_Zs3KN NZ004B 2026-01-29T14:10:44.121Z 2026-01-29T14:10:44.121Z
9269962 9269962 20260128143755_bQosM NZ004B 2026-01-29T14:10:21.055Z 2026-01-29T14:10:21.055Z
9269901 9269901 20260128143032_HkgTi NZ004B 2026-01-29T14:10:09.439Z 2026-01-29T14:10:09.439Z
9269869 9269869 20260128142543_y0Cs4 NZ004B 2026-01-29T14:09:55.041Z 2026-01-29T14:09:55.041Z
9269429 9269429 20260128131625_RYQ7t NZ004B 2026-01-29T14:07:57.759Z 2026-01-29T14:07:57.759Z
9269120 9269120 20260128123306_d6lL5 NZ004B 2026-01-29T14:06:36.008Z 2026-01-29T14:06:36.008Z
9269069 9269069 20260128121754_uK7Ho NZ004B 2026-01-29T14:06:14.686Z 2026-01-29T14:06:14.686Z
9268875 9268875 20260128113653_rfw6q NZ004B 2026-01-29T14:05:16.505Z 2026-01-29T14:05:16.505Z
9268815 9268815 20260128112757_GMi3E NZ004B 2026-01-29T14:05:00.498Z 2026-01-29T14:05:00.498Z
9268809 9268809 20260128112459_YBbbn NZ004B 2026-01-29T14:04:59.123Z 2026-01-29T14:04:59.123Z
9268715 9268715 20260128110634_I87Zq NZ004B 2026-01-29T14:04:31.128Z 2026-01-29T14:04:31.128Z
9268690 9268690 20260128110253_rfD7u NZ004B 2026-01-29T14:04:21.792Z 2026-01-29T14:04:21.792Z
9268598 9268598 20260128105018_OurHo NZ004B 2026-01-29T14:03:55.383Z 2026-01-29T14:03:55.383Z
9268393 9268393 20260128100541_m3cCI NZ004B 2026-01-29T14:02:47.494Z 2026-01-29T14:02:47.494Z
9268391 9268391 20260128100539_L9tLJ NZ004B 2026-01-29T14:02:46.545Z 2026-01-29T14:02:46.545Z
9268270 9268270 20260128093610_V7jY2 NZ004B 2026-01-29T14:02:09.343Z 2026-01-29T14:02:09.343Z
9268214 9268214 20260128092309_wDKvl NZ004B 2026-01-29T14:01:42.773Z 2026-01-29T14:01:42.773Z
9268193 9268193 20260128091759_jb60b NZ004B 2026-01-29T14:01:37.013Z 2026-01-29T14:01:37.013Z
9268178 9268178 20260128090835_VG47j NZ004B 2026-01-29T14:01:32.850Z 2026-01-29T14:01:32.850Z
9268079 9268079 20260128084338_YGIgB NZ004B 2026-01-29T14:00:56.490Z 2026-01-29T14:00:56.490Z
9265992 9265992 20260127163011_hAN8g NZ004B 2026-01-28T14:12:00.678Z 2026-01-29T14:30:24.809Z
9265857 9265857 20260127160643_5s4wf NZ004B 2026-01-28T14:11:36.541Z 2026-01-29T14:30:24.693Z
9265847 9265847 20260127160325_sA2e4 NZ004B 2026-01-28T14:11:31.623Z 2026-01-29T14:30:24.691Z
9265811 9265811 20260127160130_EsNes NZ004B 2026-01-28T14:11:25.282Z 2026-01-29T14:30:24.681Z
9265746 9265746 20260127155621_aoHav NZ004B 2026-01-28T14:11:13.166Z 2026-01-29T14:30:24.667Z
9265673 9265673 20260127154753_PQHXR NZ004B 2026-01-28T14:10:56.370Z 2026-01-29T14:30:24.651Z
9265643 9265643 20260127154442_g5kRc NZ004B 2026-01-28T14:10:50.165Z 2026-01-29T14:30:24.641Z
9265556 9265556 20260127153219_t3Avc NZ004B 2026-01-28T14:10:33.857Z 2026-01-29T14:30:24.611Z
9265534 9265534 20260127153034_VytHo NZ004B 2026-01-28T14:10:28.371Z 2026-01-29T14:30:24.600Z
9265504 9265504 20260127152202_zxsrm NZ004B 2026-01-28T14:10:23.788Z 2026-01-29T14:30:24.594Z
9265500 9265500 20260127152200_g12Ku NZ004B 2026-01-28T14:10:23.151Z 2026-01-29T14:30:24.593Z
9265432 9265432 20260127151538_gFtgO NZ004B 2026-01-28T14:10:09.835Z 2026-01-29T14:30:24.549Z
9265413 9265413 20260127151241_nxJ5X NZ004B 2026-01-28T14:10:04.134Z 2026-01-29T14:30:24.544Z
9265312 9265312 20260127145917_tX8Sb NZ004B 2026-01-28T14:09:47.778Z 2026-01-29T14:30:24.524Z
9265302 9265302 20260127145813_EUpqd NZ004B 2026-01-28T14:09:45.823Z 2026-01-29T14:30:24.522Z
9265212 9265212 20260127143943_ngVsZ NZ004B 2026-01-28T14:09:30.992Z 2026-01-29T14:30:24.504Z
9265197 9265197 20260127143420_Xk2Sr NZ004B 2026-01-28T14:09:25.008Z 2026-01-29T14:30:24.498Z
9264020 9264020 20260127105842_OXC33 NZ004B 2026-01-28T14:03:59.061Z 2026-01-29T14:30:20.003Z
9263989 9263989 20260127104932_242Ak NZ004B 2026-01-28T14:03:49.827Z 2026-01-29T14:30:19.985Z
9261976 9261976 20260126150314_a373i NZ004B 2026-01-27T14:06:50.849Z 2026-01-29T14:33:21.675Z
9261074 9261074 20260126094451_0AVmy NZ004B 2026-01-27T14:01:45.957Z 2026-01-29T14:31:45.418Z
9261037 9261037 20260126093357_s6pic NZ004B 2026-01-27T14:01:35.582Z 2026-01-29T14:31:30.513Z
9257755 9257755 20260125154815_gsrET NZ004B 2026-01-26T14:07:36.771Z 2026-01-29T14:37:37.976Z
9257699 9257699 20260125152740_VfEIJ NZ004B 2026-01-26T14:07:19.507Z 2026-01-29T14:37:35.558Z
9257678 9257678 20260125152437_l2A30 NZ004B 2026-01-26T14:07:13.267Z 2026-01-29T14:37:34.581Z
9257656 9257656 20260125151606_jsqP9 NZ004B 2026-01-26T14:07:02.561Z 2026-01-29T14:37:33.169Z
9257470 9257470 20260125140018_zvAVI NZ004B 2026-01-26T14:05:48.901Z 2026-01-29T14:37:14.306Z
9257338 9257338 20260125125555_m1fAw NZ004B 2026-01-26T14:04:51.481Z 2026-01-29T14:37:06.214Z
9257278 9257278 20260125123958_iJHMc NZ004B 2026-01-26T14:04:33.165Z 2026-01-29T14:37:03.468Z
9257134 9257134 20260125120335_aeYJe NZ004B 2026-01-26T14:03:48.291Z 2026-01-29T14:36:50.392Z
9256640 9256640 20260125093850_jNmvQ NZ004B 2026-01-26T14:01:05.801Z 2026-01-29T14:36:13.431Z
9253903 9253903 20260124154056_tIW0B NZ004B 2026-01-25T14:04:55.310Z 2026-01-29T14:41:46.987Z
9253713 9253713 20260124135855_88rJT NZ004B 2026-01-25T14:04:04.096Z 2026-01-29T14:41:19.237Z
9253664 9253664 20260124132901_MCYQD NZ004B 2026-01-25T14:03:51.190Z 2026-01-29T14:41:14.374Z
9253663 9253663 20260124132759_OK3gY NZ004B 2026-01-25T14:03:50.216Z 2026-01-29T14:41:14.190Z
9253623 9253623 20260124131101_LppAl NZ004B 2026-01-25T14:03:36.601Z 2026-01-29T14:41:04.561Z
9253498 9253498 20260124121522_i951T NZ004B 2026-01-25T14:03:01.630Z 2026-01-29T14:40:53.849Z
9253464 9253464 20260124120257_nI3AB NZ004B 2026-01-25T14:02:54.404Z 2026-01-29T14:40:51.756Z
9252984 9252984 20260123084613_tbnE8 NZ004B 2026-01-24T14:18:05.493Z 2026-01-29T14:53:46.086Z
9250511 9250511 20260123155032_k3Zk2 NZ004B 2026-01-24T14:03:18.560Z 2026-01-29T14:45:43.983Z
9250504 9250504 20260123154500_F5MqH NZ004B 2026-01-24T14:03:16.659Z 2026-01-29T14:45:42.685Z
9250281 9250281 20260123120133_33uPi NZ004B 2026-01-24T14:02:05.159Z 2026-01-29T14:45:12.506Z
9250237 9250237 20260123111726_lxjF5 NZ004B 2026-01-24T14:01:51.700Z 2026-01-29T14:45:07.296Z
9250221 9250221 20260123110951_YlPlw NZ004B 2026-01-24T14:01:44.101Z 2026-01-29T14:45:06.367Z
9250180 9250180 20260123105710_Gyvtv NZ004B 2026-01-24T14:01:34.603Z 2026-01-29T14:45:03.781Z
9250134 9250134 20260123103847_Z2RAV NZ004B 2026-01-24T14:01:20.923Z 2026-01-29T14:45:01.157Z
9245120 9245120 20260122101743_vJXQ7 NZ004B 2026-01-23T14:00:41.250Z 2026-01-29T14:49:02.787Z
9245065 9245065 20260122095145_0k9Ym NZ004B 2026-01-23T14:00:22.745Z 2026-01-29T14:48:55.685Z
9245063 9245063 20260122095056_DtE4I NZ004B 2026-01-23T14:00:22.119Z 2026-01-29T14:48:55.328Z
9225599 9225599 20260118102052_33nV0 NZ004B 2026-01-19T14:29:32.368Z 2026-01-26T15:04:39.366Z
9216022 9216022 20260116114229_FV35x NZ004B 2026-01-17T14:27:39.715Z 2026-01-24T15:15:23.779Z
9215859 9215859 20260116111448_L9dsq NZ004B 2026-01-17T14:27:06.348Z 2026-01-24T15:15:15.560Z
9215846 9215846 20260116110928_8KZxe NZ004B 2026-01-17T14:27:04.326Z 2026-01-24T15:15:15.037Z
9215780 9215780 20260116110007_W2liJ NZ004B 2026-01-17T14:26:50.576Z 2026-01-24T15:15:13.090Z
9215610 9215610 20260116103516_hzA0C NZ004B 2026-01-17T14:26:16.003Z 2026-01-24T15:15:04.867Z
9215545 9215545 20260116102909_phNUb NZ004B 2026-01-17T14:26:05.062Z 2026-01-24T15:15:02.797Z
9215503 9215503 20260116102231_n4dO1 NZ004B 2026-01-17T14:25:51.639Z 2026-01-24T15:15:00.524Z
9215340 9215340 20260116095655_qJnIU NZ004B 2026-01-17T14:25:14.329Z 2026-01-24T15:14:42.013Z
9215323 9215323 20260116095423_u0Sa2 NZ004B 2026-01-17T14:25:10.653Z 2026-01-24T15:14:41.079Z
9215315 9215315 20260116095354_Y9TgM NZ004B 2026-01-17T14:25:09.826Z 2026-01-24T15:14:40.970Z
9215051 9215051 20260116090341_hh2YP NZ004B 2026-01-17T14:24:11.418Z 2026-01-24T15:14:28.033Z
9214926 9214926 20260116084652_kHJ9g NZ004B 2026-01-17T14:23:48.186Z 2026-01-24T15:14:23.166Z
9211085 9211085 20260116154458_vHSFj NZ004B 2026-01-17T14:04:14.173Z 2026-01-25T14:57:19.626Z
9211076 9211076 20260116153833_atNI0 NZ004B 2026-01-17T14:04:11.630Z 2026-01-25T14:57:19.109Z
9211068 9211068 20260116153228_hbLHo NZ004B 2026-01-17T14:04:08.487Z 2026-01-25T14:57:18.699Z
9211025 9211025 20260116150245_u0zPf NZ004B 2026-01-17T14:03:54.651Z 2026-01-25T14:57:16.216Z
9211012 9211012 20260116144925_LSgcN NZ004B 2026-01-17T14:03:51.101Z 2026-01-25T14:57:15.051Z
9210955 9210955 20260116141524_OXEXp NZ004B 2026-01-17T14:03:32.679Z 2026-01-25T14:57:12.631Z
9210919 9210919 20260116140627_vK6M5 NZ004B 2026-01-17T14:03:24.366Z 2026-01-25T14:57:11.678Z
9210901 9210901 20260116135525_CzRNA NZ004B 2026-01-17T14:03:21.562Z 2026-01-25T14:57:11.280Z
9210897 9210897 20260116135255_flYxp NZ004B 2026-01-17T14:03:20.749Z 2026-01-25T14:57:11.066Z
9210896 9210896 20260116135239_KSZhr NZ004B 2026-01-17T14:03:19.975Z 2026-01-25T14:57:10.980Z
9210887 9210887 20260116134637_3FeiW NZ004B 2026-01-17T14:03:15.028Z 2026-01-25T14:57:10.552Z

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