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

1,845 rows where station_code = "NZ002U" 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
8685563 8685563 20251203150203_b13pv NZ002U 2025-12-05T14:09:11.282Z 2025-12-05T14:14:35.122Z
8685541 8685541 20251203143713_NNAaC NZ002U 2025-12-05T14:08:54.698Z 2025-12-05T14:14:35.097Z
8685139 8685139 20251204152705_tOfQ6 NZ002U 2025-12-05T14:05:45.566Z 2025-12-05T14:05:45.566Z
8685061 8685061 20251204150839_y3OKX NZ002U 2025-12-05T14:05:31.617Z 2025-12-05T14:05:31.617Z
8685038 8685038 20251204150504_8ULLW NZ002U 2025-12-05T14:05:28.041Z 2025-12-05T14:05:28.041Z
8685029 8685029 20251204150317_UQrpi NZ002U 2025-12-05T14:05:26.744Z 2025-12-05T14:05:26.744Z
8684929 8684929 20251204143728_PJEl3 NZ002U 2025-12-05T14:05:02.344Z 2025-12-05T14:05:02.344Z
8684905 8684905 20251204143136_BIHDf NZ002U 2025-12-05T14:04:58.868Z 2025-12-05T14:04:58.868Z
8684869 8684869 20251204142538_YmJdO NZ002U 2025-12-05T14:04:45.756Z 2025-12-05T14:04:45.756Z
8684828 8684828 20251204141643_aoT4e NZ002U 2025-12-05T14:04:38.339Z 2025-12-05T14:04:38.339Z
8684812 8684812 20251204141443_S2oOa NZ002U 2025-12-05T14:04:36.996Z 2025-12-05T14:04:36.996Z
8684761 8684761 20251204141051_GkP8q NZ002U 2025-12-05T14:04:32.729Z 2025-12-05T14:04:32.729Z
8684746 8684746 20251204140641_1Baiw NZ002U 2025-12-05T14:04:30.865Z 2025-12-05T14:04:30.865Z
8684721 8684721 20251204140000_T3QCX NZ002U 2025-12-05T14:04:27.326Z 2025-12-05T14:04:27.326Z
8684695 8684695 20251204135242_fGCBW NZ002U 2025-12-05T14:04:17.898Z 2025-12-05T14:04:17.898Z
8684687 8684687 20251204135200_yKLnw NZ002U 2025-12-05T14:04:16.956Z 2025-12-05T14:04:16.956Z
8684676 8684676 20251204134810_DMCRE NZ002U 2025-12-05T14:04:12.432Z 2025-12-05T14:04:12.432Z
8684672 8684672 20251204134734_eqJQd NZ002U 2025-12-05T14:04:12.040Z 2025-12-05T14:04:12.040Z
8684660 8684660 20251204134621_w8Xoc NZ002U 2025-12-05T14:04:09.667Z 2025-12-05T14:04:09.667Z
8684650 8684650 20251204134115_hzUon NZ002U 2025-12-05T14:04:07.564Z 2025-12-05T14:04:07.564Z
8684564 8684564 20251204131515_stFWs NZ002U 2025-12-05T14:03:46.135Z 2025-12-05T14:03:46.135Z
8684546 8684546 20251204130819_I1JGE NZ002U 2025-12-05T14:03:40.528Z 2025-12-05T14:03:40.528Z
8684533 8684533 20251204130620_S2ULI NZ002U 2025-12-05T14:03:38.937Z 2025-12-05T14:03:38.937Z
8684375 8684375 20251204122223_iu8Fd NZ002U 2025-12-05T14:02:51.192Z 2025-12-05T14:02:51.192Z
8684365 8684365 20251204122101_d77Q7 NZ002U 2025-12-05T14:02:49.565Z 2025-12-05T14:02:49.565Z
8684236 8684236 20251204113849_zXsra NZ002U 2025-12-05T14:02:15.630Z 2025-12-05T14:02:15.630Z
8684213 8684213 20251204112937_093a6 NZ002U 2025-12-05T14:02:11.482Z 2025-12-05T14:02:11.482Z
8684189 8684189 20251204111909_W85lI NZ002U 2025-12-05T14:02:08.801Z 2025-12-05T14:02:08.801Z
8684161 8684161 20251204110248_2K5st NZ002U 2025-12-05T14:02:04.150Z 2025-12-05T14:02:04.150Z
8684064 8684064 20251204103046_qtId3 NZ002U 2025-12-05T14:01:42.406Z 2025-12-05T14:01:42.406Z
8678209 8678209 20251203152751_3eTHN NZ002U 2025-12-04T14:03:52.101Z 2025-12-05T14:14:35.150Z
8678198 8678198 20251203152505_MIjaD NZ002U 2025-12-04T14:03:47.557Z 2025-12-05T14:14:35.147Z
8678159 8678159 20251203150740_79OY3 NZ002U 2025-12-04T14:03:40.786Z 2025-12-05T14:14:35.129Z
8678149 8678149 20251203150410_RX7Ed NZ002U 2025-12-04T14:03:38.911Z 2025-12-05T14:14:35.125Z
8678142 8678142 20251203150352_yeVzs NZ002U 2025-12-04T14:03:38.369Z 2025-12-05T14:14:35.124Z
8678138 8678138 20251203150203_Z73Jh NZ002U 2025-12-04T14:03:37.885Z 2025-12-05T14:14:35.120Z
8678132 8678132 20251203150137_YZQep NZ002U 2025-12-04T14:03:37.231Z 2025-12-05T14:14:35.119Z
8678114 8678114 20251203145228_Y8HhR NZ002U 2025-12-04T14:03:34.148Z 2025-12-05T14:14:35.110Z
8678087 8678087 20251203143712_S3IT3 NZ002U 2025-12-04T14:03:29.697Z 2025-12-05T14:14:35.096Z
8678081 8678081 20251203143712_xd5dA NZ002U 2025-12-04T14:03:29.410Z 2025-12-05T14:14:35.096Z
8677962 8677962 20251203133938_bvUK0 NZ002U 2025-12-04T14:03:06.588Z 2025-12-05T14:14:35.025Z
8677951 8677951 20251203133426_5qy43 NZ002U 2025-12-04T14:03:05.216Z 2025-12-05T14:14:35.021Z
8677943 8677943 20251203133131_CCOYd NZ002U 2025-12-04T14:03:04.332Z 2025-12-05T14:14:35.018Z
8677933 8677933 20251203132321_HM28R NZ002U 2025-12-04T14:03:02.915Z 2025-12-05T14:14:35.013Z
8677924 8677924 20251203131640_8BHe4 NZ002U 2025-12-04T14:02:59.965Z 2025-12-05T14:14:35.009Z
8677869 8677869 20251203124926_Fw2cT NZ002U 2025-12-04T14:02:50.037Z 2025-12-05T14:14:34.991Z
8677857 8677857 20251203124752_303rF NZ002U 2025-12-04T14:02:48.692Z 2025-12-05T14:14:34.989Z
8677851 8677851 20251203124722_y7xHk NZ002U 2025-12-04T14:02:48.390Z 2025-12-05T14:14:34.988Z
8677844 8677844 20251203124502_k9Hdd NZ002U 2025-12-04T14:02:47.535Z 2025-12-05T14:14:34.986Z
8677840 8677840 20251203124446_R6h9s NZ002U 2025-12-04T14:02:47.126Z 2025-12-05T14:14:34.986Z
8677829 8677829 20251203124330_m2khi NZ002U 2025-12-04T14:02:46.533Z 2025-12-05T14:14:34.984Z
8677801 8677801 20251203123645_ODMx4 NZ002U 2025-12-04T14:02:41.237Z 2025-12-05T14:14:34.975Z
8677468 8677468 20251203101357_62qKk NZ002U 2025-12-04T14:01:20.104Z 2025-12-05T14:14:34.851Z
8642151 8642151 20251128153520_Gs4Lb NZ002U 2025-11-30T14:17:37.312Z 2025-12-05T14:48:56.498Z
8642104 8642104 20251128153215_gJhuy NZ002U 2025-11-30T14:17:24.040Z 2025-12-05T14:48:55.825Z
8642093 8642093 20251128153111_3DBGb NZ002U 2025-11-30T14:17:21.965Z 2025-12-05T14:48:55.603Z
8642057 8642057 20251128152827_1O9zG NZ002U 2025-11-30T14:17:18.060Z 2025-12-05T14:48:54.975Z
8641870 8641870 20251128151728_elVjy NZ002U 2025-11-30T14:17:05.699Z 2025-12-05T14:48:52.517Z
8641862 8641862 20251128151720_KQdxT NZ002U 2025-11-30T14:17:05.384Z 2025-12-05T14:48:52.493Z
8641778 8641778 20251128151322_m7fwC NZ002U 2025-11-30T14:17:00.182Z 2025-12-05T14:48:51.688Z
8641763 8641763 20251128151143_QXFH2 NZ002U 2025-11-30T14:16:51.951Z 2025-12-05T14:48:51.468Z
8641743 8641743 20251128151107_Djwxi NZ002U 2025-11-30T14:16:45.829Z 2025-12-05T14:48:51.105Z
8641707 8641707 20251128150848_u2Np5 NZ002U 2025-11-30T14:16:43.704Z 2025-12-05T14:48:50.633Z
8641651 8641651 20251128150456_FB0b2 NZ002U 2025-11-30T14:16:37.671Z 2025-12-05T14:48:49.681Z
8641485 8641485 20251128145556_Iu3P3 NZ002U 2025-11-30T14:16:27.596Z 2025-12-05T14:48:41.778Z
8641479 8641479 20251128145556_MGJod NZ002U 2025-11-30T14:16:27.389Z 2025-12-05T14:48:41.222Z
8641278 8641278 20251128142057_cfItT NZ002U 2025-11-30T14:15:23.000Z 2025-12-05T14:48:07.168Z
8629908 8629908 20251128144358_NAOcY NZ002U 2025-11-29T14:09:18.083Z 2025-12-05T14:48:29.663Z
8629886 8629886 20251128144309_uBAZY NZ002U 2025-11-29T14:09:16.375Z 2025-12-05T14:48:26.207Z
8629858 8629858 20251128144128_qK40U NZ002U 2025-11-29T14:09:14.333Z 2025-12-05T14:48:23.019Z
8629829 8629829 20251128144034_ZDafU NZ002U 2025-11-29T14:09:04.221Z 2025-12-05T14:48:22.496Z
8629812 8629812 20251128144004_yW2B2 NZ002U 2025-11-29T14:09:02.271Z 2025-12-05T14:48:21.998Z
8629749 8629749 20251128143551_u2qIg NZ002U 2025-11-29T14:08:58.566Z 2025-11-29T14:08:58.566Z
8629710 8629710 20251128143100_fWrgc NZ002U 2025-11-29T14:08:54.934Z 2025-12-05T14:48:09.363Z
8629671 8629671 20251128142740_mNonN NZ002U 2025-11-29T14:08:51.635Z 2025-12-05T14:48:08.923Z
8629564 8629564 20251128141847_TE4YH NZ002U 2025-11-29T14:08:42.222Z 2025-12-05T14:48:06.563Z
8629494 8629494 20251128141137_4C2AI NZ002U 2025-11-29T14:08:29.362Z 2025-12-05T14:48:05.526Z
8629478 8629478 20251128140959_6vAV2 NZ002U 2025-11-29T14:08:28.074Z 2025-12-05T14:48:04.858Z
8629428 8629428 20251128140701_tmSxC NZ002U 2025-11-29T14:08:22.489Z 2025-12-05T14:48:00.211Z
8629418 8629418 20251128140537_ytXy1 NZ002U 2025-11-29T14:08:21.804Z 2025-12-05T14:47:59.940Z
8629357 8629357 20251128140128_yTLtz NZ002U 2025-11-29T14:08:18.481Z 2025-12-05T14:47:59.314Z
8629333 8629333 20251128140037_Kq63V NZ002U 2025-11-29T14:08:16.980Z 2025-12-05T14:47:59.071Z
8629328 8629328 20251128135955_jL0hr NZ002U 2025-11-29T14:08:16.659Z 2025-12-05T14:47:59.039Z
8629268 8629268 20251128135553_3GtMP NZ002U 2025-11-29T14:08:13.321Z 2025-12-05T14:47:58.089Z
8629244 8629244 20251128135317_x6a8m NZ002U 2025-11-29T14:08:10.690Z 2025-11-29T14:08:10.690Z
8629225 8629225 20251128135046_ozPaW NZ002U 2025-11-29T14:08:09.416Z 2025-12-05T14:47:57.508Z
8629127 8629127 20251128134418_Gg533 NZ002U 2025-11-29T14:07:52.317Z 2025-12-05T14:47:55.794Z
8629051 8629051 20251128134046_GLRyt NZ002U 2025-11-29T14:07:45.519Z 2025-12-05T14:47:54.787Z
8629044 8629044 20251128133920_ZKheZ NZ002U 2025-11-29T14:07:44.828Z 2025-12-05T14:47:54.606Z
8628994 8628994 20251128133224_jKWBv NZ002U 2025-11-29T14:07:39.942Z 2025-12-05T14:47:54.019Z
8628959 8628959 20251128133047_ycc3S NZ002U 2025-11-29T14:07:37.078Z 2025-12-05T14:47:53.649Z
8628922 8628922 20251128132531_wzAzS NZ002U 2025-11-29T14:07:32.338Z 2025-12-05T14:47:52.898Z
8628783 8628783 20251128131028_K833h NZ002U 2025-11-29T14:07:07.224Z 2025-12-05T14:47:50.271Z
8628668 8628668 20251128130311_j32b0 NZ002U 2025-11-29T14:06:55.979Z 2025-12-05T14:47:48.323Z
8628614 8628614 20251128125932_ihKmx NZ002U 2025-11-29T14:06:51.048Z 2025-11-29T14:06:51.048Z
8627415 8627415 20251128105633_PX3AT NZ002U 2025-11-29T14:03:29.958Z 2025-12-05T14:46:58.842Z
8627370 8627370 20251128105416_0SAQ0 NZ002U 2025-11-29T14:03:26.394Z 2025-12-05T14:46:58.263Z
8619718 8619718 20251126105100_5ekfi NZ002U 2025-11-28T14:10:04.185Z 2025-12-05T15:01:05.580Z
8619705 8619705 20251126104912_cvNZr NZ002U 2025-11-28T14:10:01.833Z 2025-12-05T15:01:05.100Z
8619527 8619527 20251126102410_VPY4j NZ002U 2025-11-28T14:09:18.869Z 2025-12-05T15:01:01.006Z

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