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 = "NZ002Z" 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
8685163 8685163 20251204153120_gS9Ys NZ002Z 2025-12-05T14:05:51.069Z 2025-12-05T14:05:51.069Z
8685153 8685153 20251204153014_79dQM NZ002Z 2025-12-05T14:05:46.960Z 2025-12-05T14:05:46.960Z
8685134 8685134 20251204152534_W0Tw0 NZ002Z 2025-12-05T14:05:45.220Z 2025-12-05T14:05:45.220Z
8685119 8685119 20251204152058_33RW1 NZ002Z 2025-12-05T14:05:43.026Z 2025-12-05T14:05:43.026Z
8685081 8685081 20251204151424_3ZrJt NZ002Z 2025-12-05T14:05:37.368Z 2025-12-05T14:05:37.368Z
8684972 8684972 20251204144914_f1VMN NZ002Z 2025-12-05T14:05:10.066Z 2025-12-05T14:05:10.066Z
8684959 8684959 20251204144523_XtoOm NZ002Z 2025-12-05T14:05:08.609Z 2025-12-05T14:05:08.609Z
8684902 8684902 20251204143122_F2Uf5 NZ002Z 2025-12-05T14:04:58.496Z 2025-12-05T14:04:58.496Z
8684755 8684755 20251204141010_7zIQT NZ002Z 2025-12-05T14:04:32.345Z 2025-12-05T14:04:32.345Z
8684629 8684629 20251204133010_TSUbd NZ002Z 2025-12-05T14:04:05.107Z 2025-12-05T14:04:05.107Z
8684529 8684529 20251204130447_nvxS5 NZ002Z 2025-12-05T14:03:38.381Z 2025-12-05T14:03:38.381Z
8684485 8684485 20251204125242_t8rqp NZ002Z 2025-12-05T14:03:30.032Z 2025-12-05T14:03:30.032Z
8684284 8684284 20251204115553_noorF NZ002Z 2025-12-05T14:02:36.915Z 2025-12-05T14:02:36.915Z
8684252 8684252 20251204114648_or7c5 NZ002Z 2025-12-05T14:02:22.666Z 2025-12-05T14:02:22.666Z
8684225 8684225 20251204113424_ljAfr NZ002Z 2025-12-05T14:02:13.346Z 2025-12-05T14:02:13.346Z
8683979 8683979 20251204095742_f89Yp NZ002Z 2025-12-05T14:01:26.283Z 2025-12-05T14:01:26.283Z
8683947 8683947 20251204094445_LxxGN NZ002Z 2025-12-05T14:01:19.245Z 2025-12-05T14:01:19.245Z
8683938 8683938 20251204093837_yd5og NZ002Z 2025-12-05T14:01:10.710Z 2025-12-05T14:01:10.710Z
8678219 8678219 20251203153143_W2WG4 NZ002Z 2025-12-04T14:03:53.238Z 2025-12-05T14:14:35.155Z
8678185 8678185 20251203152217_YNhEt NZ002Z 2025-12-04T14:03:45.406Z 2025-12-05T14:14:35.143Z
8677638 8677638 20251203111558_SLTwt NZ002Z 2025-12-04T14:02:06.755Z 2025-12-05T14:14:34.904Z
8677300 8677300 20251203083148_KOXnx NZ002Z 2025-12-04T14:00:40.196Z 2025-12-05T14:14:34.793Z
8670897 8670897 20251201104137_CBqkf NZ002Z 2025-12-03T14:10:39.391Z 2025-12-05T14:23:54.871Z
8670752 8670752 20251201100739_HyA4S NZ002Z 2025-12-03T14:09:59.503Z 2025-12-05T14:23:47.951Z
8670738 8670738 20251201100628_ZVUvo NZ002Z 2025-12-03T14:09:57.776Z 2025-12-05T14:23:47.413Z
8670212 8670212 20251202152529_0xMIQ NZ002Z 2025-12-03T14:07:27.225Z 2025-12-05T14:18:31.554Z
8661581 8661581 20251130160509_RXSZm NZ002Z 2025-12-02T14:12:05.622Z 2025-12-05T14:32:23.615Z
8661546 8661546 20251130154617_Fgu75 NZ002Z 2025-12-02T14:11:58.987Z 2025-12-05T14:32:07.850Z
8661540 8661540 20251130154512_yCp72 NZ002Z 2025-12-02T14:11:57.097Z 2025-12-05T14:32:07.575Z
8661446 8661446 20251130152341_lalns NZ002Z 2025-12-02T14:11:30.203Z 2025-12-05T14:32:01.354Z
8661428 8661428 20251130151930_22pDq NZ002Z 2025-12-02T14:11:28.002Z 2025-12-05T14:32:00.788Z
8661399 8661399 20251130151634_0AhuH NZ002Z 2025-12-02T14:11:22.292Z 2025-12-05T14:31:59.718Z
8661277 8661277 20251130150535_mhu1C NZ002Z 2025-12-02T14:11:00.849Z 2025-12-05T14:31:56.019Z
8661227 8661227 20251130150140_5b22V NZ002Z 2025-12-02T14:10:53.417Z 2025-12-05T14:31:54.295Z
8661192 8661192 20251130145716_dUKBX NZ002Z 2025-12-02T14:10:41.581Z 2025-12-05T14:31:52.808Z
8661172 8661172 20251130145356_6NUat NZ002Z 2025-12-02T14:10:36.970Z 2025-12-05T14:31:52.001Z
8661097 8661097 20251130144208_2ulxC NZ002Z 2025-12-02T14:10:23.607Z 2025-12-05T14:31:49.593Z
8661076 8661076 20251130144036_wlh71 NZ002Z 2025-12-02T14:10:17.453Z 2025-12-05T14:31:49.000Z
8661047 8661047 20251130143102_DFJgi NZ002Z 2025-12-02T14:10:11.770Z 2025-12-05T14:31:47.609Z
8660983 8660983 20251130142305_Rvygt NZ002Z 2025-12-02T14:09:53.716Z 2025-12-05T14:31:44.904Z
8660978 8660978 20251130142135_H5Nkw NZ002Z 2025-12-02T14:09:53.133Z 2025-12-05T14:31:44.785Z
8660947 8660947 20251130141756_pPhuz NZ002Z 2025-12-02T14:09:47.971Z 2025-12-05T14:31:43.758Z
8660793 8660793 20251130135256_bKPTi NZ002Z 2025-12-02T14:09:12.285Z 2025-12-05T14:31:25.817Z
8660777 8660777 20251130134931_DoTKq NZ002Z 2025-12-02T14:09:09.223Z 2025-12-05T14:31:25.187Z
8660653 8660653 20251130132453_TUuqz NZ002Z 2025-12-02T14:08:40.695Z 2025-12-05T14:31:18.176Z
8660583 8660583 20251130130907_JYajz NZ002Z 2025-12-02T14:08:20.478Z 2025-12-05T14:31:15.465Z
8660466 8660466 20251130125550_ar03l NZ002Z 2025-12-02T14:07:57.148Z 2025-12-05T14:31:11.423Z
8660383 8660383 20251130124411_HslET NZ002Z 2025-12-02T14:07:42.427Z 2025-12-05T14:31:08.003Z
8660375 8660375 20251130124315_z4b3x NZ002Z 2025-12-02T14:07:40.887Z 2025-12-05T14:31:07.537Z
8641895 8641895 20251128151830_6pugO NZ002Z 2025-11-30T14:17:07.245Z 2025-12-05T14:48:52.815Z
8641882 8641882 20251128151808_gklTk NZ002Z 2025-11-30T14:17:06.723Z 2025-12-05T14:48:52.706Z
8641826 8641826 20251128151551_RSBU6 NZ002Z 2025-11-30T14:17:02.987Z 2025-12-05T14:48:52.109Z
8641722 8641722 20251128151006_27fev NZ002Z 2025-11-30T14:16:44.945Z 2025-12-05T14:48:50.895Z
8641660 8641660 20251128150531_TPT20 NZ002Z 2025-11-30T14:16:38.469Z 2025-12-05T14:48:50.129Z
8641463 8641463 20251128145441_8JvEA NZ002Z 2025-11-30T14:16:25.582Z 2025-12-05T14:48:39.694Z
8640707 8640707 20251129153224_9eRfk NZ002Z 2025-11-30T14:09:18.514Z 2025-12-05T14:39:26.059Z
8640574 8640574 20251129145445_CBx8u NZ002Z 2025-11-30T14:08:51.108Z 2025-12-05T14:39:20.009Z
8640553 8640553 20251129144858_SkDq8 NZ002Z 2025-11-30T14:08:47.959Z 2025-12-05T14:39:19.444Z
8640504 8640504 20251129143810_OgItw NZ002Z 2025-11-30T14:08:34.070Z 2025-12-05T14:39:16.800Z
8640486 8640486 20251129143444_AD2EA NZ002Z 2025-11-30T14:08:31.670Z 2025-12-05T14:39:16.415Z
8640470 8640470 20251129142932_R7erV NZ002Z 2025-11-30T14:08:29.110Z 2025-12-05T14:39:15.765Z
8640422 8640422 20251129141627_A95v7 NZ002Z 2025-11-30T14:08:19.610Z 2025-12-05T14:39:13.632Z
8640226 8640226 20251129131032_TbLC1 NZ002Z 2025-11-30T14:07:34.883Z 2025-12-05T14:38:59.748Z
8640194 8640194 20251129130416_2B6MF NZ002Z 2025-11-30T14:07:30.759Z 2025-12-05T14:38:50.704Z
8640177 8640177 20251129130210_DAhX7 NZ002Z 2025-11-30T14:07:28.434Z 2025-11-30T14:07:28.434Z
8640174 8640174 20251129130158_JQ24N NZ002Z 2025-11-30T14:07:28.042Z 2025-11-30T14:07:28.042Z
8640114 8640114 20251129125215_pzpbS NZ002Z 2025-11-30T14:07:11.911Z 2025-12-05T14:38:44.280Z
8640037 8640037 20251129124205_KsBIL NZ002Z 2025-11-30T14:06:57.063Z 2025-12-05T14:38:42.267Z
8639999 8639999 20251129123843_dW22M NZ002Z 2025-11-30T14:06:51.923Z 2025-12-05T14:38:41.236Z
8639996 8639996 20251129123713_l8XVY NZ002Z 2025-11-30T14:06:50.840Z 2025-12-05T14:38:40.827Z
8639975 8639975 20251129123528_Vpr0p NZ002Z 2025-11-30T14:06:47.584Z 2025-12-05T14:38:39.726Z
8639938 8639938 20251129122749_O8flR NZ002Z 2025-11-30T14:06:33.522Z 2025-12-05T14:38:37.299Z
8629892 8629892 20251128144327_YRU1A NZ002Z 2025-11-29T14:09:17.117Z 2025-12-05T14:48:27.120Z
8629839 8629839 20251128144058_Fdm1f NZ002Z 2025-11-29T14:09:09.370Z 2025-12-05T14:48:22.593Z
8629817 8629817 20251128144014_JeWRO NZ002Z 2025-11-29T14:09:02.544Z 2025-12-05T14:48:22.128Z
8629798 8629798 20251128143840_Y3IBI NZ002Z 2025-11-29T14:09:01.295Z 2025-12-05T14:48:20.543Z
8629706 8629706 20251128143052_BGpdy NZ002Z 2025-11-29T14:08:54.563Z 2025-12-05T14:48:09.314Z
8629675 8629675 20251128142805_K7Vhs NZ002Z 2025-11-29T14:08:51.984Z 2025-12-05T14:48:08.953Z
8629665 8629665 20251128142730_0YbjO NZ002Z 2025-11-29T14:08:51.164Z 2025-12-05T14:48:08.877Z
8629649 8629649 20251128142716_Lb3Sh NZ002Z 2025-11-29T14:08:50.444Z 2025-12-05T14:48:08.784Z
8629582 8629582 20251128141952_7Xy77 NZ002Z 2025-11-29T14:08:43.538Z 2025-12-05T14:48:06.940Z
8629301 8629301 20251128135827_VESov NZ002Z 2025-11-29T14:08:15.442Z 2025-12-05T14:47:58.578Z
8629252 8629252 20251128135359_TNl8p NZ002Z 2025-11-29T14:08:11.961Z 2025-12-05T14:47:57.947Z
8629136 8629136 20251128134436_UGGNH NZ002Z 2025-11-29T14:07:53.129Z 2025-12-05T14:47:55.970Z
8629098 8629098 20251128134345_whjxe NZ002Z 2025-11-29T14:07:51.082Z 2025-12-05T14:47:55.336Z
8628761 8628761 20251128130859_1WnNy NZ002Z 2025-11-29T14:07:03.705Z 2025-12-05T14:47:49.634Z
8628746 8628746 20251128130740_oSxkP NZ002Z 2025-11-29T14:07:02.079Z 2025-12-05T14:47:49.492Z
8628591 8628591 20251128125816_fUF3I NZ002Z 2025-11-29T14:06:48.941Z 2025-12-05T14:47:46.676Z
8628553 8628553 20251128125649_aYuZT NZ002Z 2025-11-29T14:06:37.849Z 2025-12-05T14:47:45.640Z
8628494 8628494 20251128124931_Vewv5 NZ002Z 2025-11-29T14:06:26.137Z 2025-12-05T14:47:43.919Z
8628442 8628442 20251128124453_SDSuc NZ002Z 2025-11-29T14:06:18.311Z 2025-12-05T14:47:42.978Z
8628403 8628403 20251128124301_gmkVL NZ002Z 2025-11-29T14:06:13.609Z 2025-12-05T14:47:42.358Z
8628345 8628345 20251128123643_ihw6F NZ002Z 2025-11-29T14:05:56.637Z 2025-12-05T14:47:41.351Z
8627984 8627984 20251128120121_6V8CK NZ002Z 2025-11-29T14:05:02.770Z 2025-12-05T14:47:11.437Z
8627849 8627849 20251128114509_mI3Xp NZ002Z 2025-11-29T14:04:37.328Z 2025-12-05T14:47:07.323Z
8626537 8626537 20251128085701_dJVKa NZ002Z 2025-11-29T14:00:40.334Z 2025-12-05T14:46:12.819Z
8620881 8620881 20251126135032_NEv3e NZ002Z 2025-11-28T14:14:17.921Z 2025-12-05T15:02:38.422Z
8620874 8620874 20251126134915_aqHFt NZ002Z 2025-11-28T14:14:17.178Z 2025-12-05T15:02:38.345Z
8620250 8620250 20251126120437_sCGYY NZ002Z 2025-11-28T14:12:06.541Z 2025-12-05T15:01:34.348Z
8620197 8620197 20251126115836_IVXKc NZ002Z 2025-11-28T14:11:59.769Z 2025-12-05T15:01:33.146Z

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