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 = "NZ004J" 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
8689792 8689792 20251204132134_UapsE NZ004J 2025-12-06T14:11:12.386Z 2025-12-06T14:18:00.554Z
8689235 8689235 20251205144831_38su3 NZ004J 2025-12-06T14:07:27.160Z 2025-12-06T14:07:27.160Z
8689232 8689232 20251205144800_pIYUH NZ004J 2025-12-06T14:07:26.495Z 2025-12-06T14:07:26.495Z
8689186 8689186 20251205144128_r0d3T NZ004J 2025-12-06T14:07:20.092Z 2025-12-06T14:07:20.092Z
8689084 8689084 20251205140702_MjIYx NZ004J 2025-12-06T14:06:59.114Z 2025-12-06T14:06:59.114Z
8689004 8689004 20251205134205_PywS9 NZ004J 2025-12-06T14:06:44.594Z 2025-12-06T14:06:44.594Z
8688995 8688995 20251205133959_2gi5a NZ004J 2025-12-06T14:06:42.979Z 2025-12-06T14:06:42.979Z
8688954 8688954 20251205132209_tWfoG NZ004J 2025-12-06T14:06:29.264Z 2025-12-06T14:06:29.264Z
8688880 8688880 20251205130608_6jonM NZ004J 2025-12-06T14:06:12.376Z 2025-12-06T14:06:12.376Z
8688875 8688875 20251205130546_ElU2A NZ004J 2025-12-06T14:06:11.812Z 2025-12-06T14:06:11.812Z
8688845 8688845 20251205130013_qmtYP NZ004J 2025-12-06T14:06:02.892Z 2025-12-06T14:06:02.892Z
8688642 8688642 20251205121700_EYcr2 NZ004J 2025-12-06T14:05:16.672Z 2025-12-06T14:05:16.672Z
8688553 8688553 20251205115936_6JTTF NZ004J 2025-12-06T14:04:55.893Z 2025-12-06T14:04:55.893Z
8688109 8688109 20251205102604_mp3aT NZ004J 2025-12-06T14:03:11.774Z 2025-12-06T14:03:11.774Z
8685203 8685203 20251204153908_Ts2Rl NZ004J 2025-12-05T14:06:10.631Z 2025-12-06T14:18:00.702Z
8685188 8685188 20251204153626_rTVbG NZ004J 2025-12-05T14:05:59.130Z 2025-12-06T14:18:00.696Z
8685131 8685131 20251204152517_ZYnX9 NZ004J 2025-12-05T14:05:44.882Z 2025-12-06T14:18:00.683Z
8685099 8685099 20251204151652_NS2tF NZ004J 2025-12-05T14:05:40.441Z 2025-12-06T14:18:00.673Z
8685073 8685073 20251204151227_2Wu8k NZ004J 2025-12-05T14:05:35.096Z 2025-12-06T14:18:00.666Z
8685008 8685008 20251204150116_D7egv NZ004J 2025-12-05T14:05:19.313Z 2025-12-06T14:18:00.649Z
8685005 8685005 20251204145924_v1ITM NZ004J 2025-12-05T14:05:18.991Z 2025-12-06T14:18:00.649Z
8684961 8684961 20251204144728_rcxT3 NZ004J 2025-12-05T14:05:08.885Z 2025-12-06T14:18:00.637Z
8684958 8684958 20251204144427_QNQqk NZ004J 2025-12-05T14:05:08.121Z 2025-12-06T14:18:00.636Z
8684956 8684956 20251204144400_7252S NZ004J 2025-12-05T14:05:07.718Z 2025-12-06T14:18:00.635Z
8684899 8684899 20251204143114_HY3Jt NZ004J 2025-12-05T14:04:57.904Z 2025-12-06T14:18:00.620Z
8684790 8684790 20251204141254_ZU6j0 NZ004J 2025-12-05T14:04:34.758Z 2025-12-06T14:18:00.597Z
8684255 8684255 20251204114710_bRcUp NZ004J 2025-12-05T14:02:22.958Z 2025-12-06T14:18:00.456Z
8684168 8684168 20251204110942_4ig73 NZ004J 2025-12-05T14:02:05.122Z 2025-12-06T14:18:00.433Z
8684129 8684129 20251204105410_Jlh1k NZ004J 2025-12-05T14:02:00.639Z 2025-12-06T14:18:00.424Z
8684103 8684103 20251204104254_0R64V NZ004J 2025-12-05T14:01:56.164Z 2025-12-06T14:18:00.417Z
8684085 8684085 20251204103603_HRBFJ NZ004J 2025-12-05T14:01:46.563Z 2025-12-06T14:18:00.412Z
8677790 8677790 20251203123433_k4QQk NZ004J 2025-12-04T14:02:39.350Z 2025-12-06T14:20:05.800Z
8677699 8677699 20251203115117_S7sfS NZ004J 2025-12-04T14:02:19.611Z 2025-12-06T14:19:58.149Z
8677630 8677630 20251203111258_pgLGB NZ004J 2025-12-04T14:02:05.699Z 2025-12-06T14:19:49.646Z
8677597 8677597 20251203105817_G7tLd NZ004J 2025-12-04T14:01:54.520Z 2025-12-06T14:19:42.856Z
8677590 8677590 20251203105550_qLTKx NZ004J 2025-12-04T14:01:52.623Z 2025-12-06T14:19:42.184Z
8672921 8672921 20251201154010_WNMwK NZ004J 2025-12-03T14:16:57.118Z 2025-12-06T14:32:27.201Z
8672904 8672904 20251201153713_to4Nu NZ004J 2025-12-03T14:16:53.283Z 2025-12-06T14:32:26.489Z
8672895 8672895 20251201153604_8W587 NZ004J 2025-12-03T14:16:52.478Z 2025-12-06T14:32:25.635Z
8672890 8672890 20251201153459_NmuwC NZ004J 2025-12-03T14:16:51.672Z 2025-12-06T14:32:25.228Z
8672886 8672886 20251201153439_jGO7f NZ004J 2025-12-03T14:16:51.408Z 2025-12-06T14:32:25.090Z
8672836 8672836 20251201152736_RWtdh NZ004J 2025-12-03T14:16:39.542Z 2025-12-06T14:32:22.250Z
8672276 8672276 20251201140913_qtnqn NZ004J 2025-12-03T14:15:12.012Z 2025-12-06T14:31:50.333Z
8672227 8672227 20251201140643_EOlUN NZ004J 2025-12-03T14:15:08.038Z 2025-12-06T14:31:49.196Z
8672176 8672176 20251201140011_r1up3 NZ004J 2025-12-03T14:14:53.892Z 2025-12-06T14:31:47.245Z
8672141 8672141 20251201135624_ALsbj NZ004J 2025-12-03T14:14:46.751Z 2025-12-06T14:31:46.250Z
8672080 8672080 20251201134750_olO4y NZ004J 2025-12-03T14:14:39.541Z 2025-12-06T14:31:44.082Z
8672038 8672038 20251201134404_RS65O NZ004J 2025-12-03T14:14:33.894Z 2025-12-06T14:31:42.446Z
8671947 8671947 20251201132923_jBLk3 NZ004J 2025-12-03T14:14:13.740Z 2025-12-06T14:31:30.413Z
8671815 8671815 20251201130211_Pz1pF NZ004J 2025-12-03T14:13:51.607Z 2025-12-06T14:31:20.566Z
8671641 8671641 20251201124500_kLDVs NZ004J 2025-12-03T14:13:13.403Z 2025-12-06T14:31:14.469Z
8671626 8671626 20251201124328_wVFoc NZ004J 2025-12-03T14:13:11.732Z 2025-12-06T14:31:14.057Z
8671562 8671562 20251201123340_I7dWX NZ004J 2025-12-03T14:12:59.056Z 2025-12-06T14:31:10.625Z
8671552 8671552 20251201123322_f52tV NZ004J 2025-12-03T14:12:58.516Z 2025-12-06T14:31:10.434Z
8671466 8671466 20251201122229_DM6j8 NZ004J 2025-12-03T14:12:42.029Z 2025-12-06T14:31:07.812Z
8671448 8671448 20251201122045_F8yO1 NZ004J 2025-12-03T14:12:39.967Z 2025-12-06T14:31:07.076Z
8671405 8671405 20251201121258_yynsk NZ004J 2025-12-03T14:12:24.386Z 2025-12-06T14:31:00.110Z
8671368 8671368 20251201120626_Pfc2A NZ004J 2025-12-03T14:12:16.107Z 2025-12-06T14:30:56.858Z
8671302 8671302 20251201115448_Zrcgo NZ004J 2025-12-03T14:12:05.980Z 2025-12-06T14:30:51.439Z
8671290 8671290 20251201115307_HQoQT NZ004J 2025-12-03T14:12:04.786Z 2025-12-06T14:30:51.057Z
8670568 8670568 20251201092847_vtQLk NZ004J 2025-12-03T14:09:16.898Z 2025-12-06T14:30:09.725Z
8670507 8670507 20251201091242_6Fo8R NZ004J 2025-12-03T14:09:03.575Z 2025-12-06T14:30:06.016Z
8661486 8661486 20251130153329_Yi1NE NZ004J 2025-12-02T14:11:37.956Z 2025-12-06T14:38:07.317Z
8661482 8661482 20251130153231_BLNSu NZ004J 2025-12-02T14:11:37.518Z 2025-12-06T14:38:07.262Z
8661437 8661437 20251130151955_F2f3f NZ004J 2025-12-02T14:11:28.893Z 2025-12-06T14:38:05.504Z
8661375 8661375 20251130151403_5DiSv NZ004J 2025-12-02T14:11:12.023Z 2025-12-06T14:38:03.545Z
8661362 8661362 20251130151316_8VFXe NZ004J 2025-12-02T14:11:11.323Z 2025-12-06T14:38:03.427Z
8661285 8661285 20251130150556_2hER7 NZ004J 2025-12-02T14:11:01.261Z 2025-12-06T14:38:01.033Z
8661169 8661169 20251130145351_s6TLE NZ004J 2025-12-02T14:10:36.346Z 2025-12-06T14:37:39.645Z
8661163 8661163 20251130145319_yL7IV NZ004J 2025-12-02T14:10:35.387Z 2025-12-06T14:37:39.275Z
8661149 8661149 20251130145021_f7G2k NZ004J 2025-12-02T14:10:32.765Z 2025-12-06T14:37:38.671Z
8660826 8660826 20251130135801_cSiXV NZ004J 2025-12-02T14:09:18.634Z 2025-12-06T14:37:26.971Z
8642205 8642205 20251128153804_2cU3R NZ004J 2025-11-30T14:17:40.131Z 2025-12-06T14:53:22.772Z
8642142 8642142 20251128153514_b2x6O NZ004J 2025-11-30T14:17:37.060Z 2025-12-06T14:53:20.707Z
8642036 8642036 20251128152705_zkR4D NZ004J 2025-11-30T14:17:16.229Z 2025-12-06T14:53:13.620Z
8642018 8642018 20251128152542_qxctT NZ004J 2025-11-30T14:17:15.237Z 2025-12-06T14:53:12.871Z
8641996 8641996 20251128152427_FeO0p NZ004J 2025-11-30T14:17:13.634Z 2025-12-06T14:53:12.309Z
8641951 8641951 20251128152141_lQlgW NZ004J 2025-11-30T14:17:11.072Z 2025-12-06T14:53:08.881Z
8641839 8641839 20251128151620_15iKC NZ004J 2025-11-30T14:17:03.711Z 2025-12-06T14:52:58.168Z
8641815 8641815 20251128151445_c39H4 NZ004J 2025-11-30T14:17:02.344Z 2025-12-06T14:52:55.846Z
8641587 8641587 20251128150022_V7T9C NZ004J 2025-11-30T14:16:33.749Z 2025-12-06T14:52:39.336Z
8641498 8641498 20251128145639_WlDEH NZ004J 2025-11-30T14:16:28.648Z 2025-12-06T14:52:38.001Z
8641496 8641496 20251128145639_r5UFi NZ004J 2025-11-30T14:16:28.476Z 2025-12-06T14:52:37.956Z
8640572 8640572 20251129145416_lCPDm NZ004J 2025-11-30T14:08:50.694Z 2025-11-30T14:08:50.694Z
8640550 8640550 20251129144850_GKSqB NZ004J 2025-11-30T14:08:47.489Z 2025-11-30T14:08:47.489Z
8640540 8640540 20251129144653_YW3Rx NZ004J 2025-11-30T14:08:45.723Z 2025-12-06T14:44:38.534Z
8640526 8640526 20251129144119_eOlSv NZ004J 2025-11-30T14:08:37.943Z 2025-12-06T14:44:37.207Z
8640516 8640516 20251129144022_bC31Z NZ004J 2025-11-30T14:08:36.210Z 2025-12-06T14:44:37.081Z
8640250 8640250 20251129131522_j3Qfa NZ004J 2025-11-30T14:07:37.672Z 2025-12-06T14:44:11.637Z
8640170 8640170 20251129130149_YtnUU NZ004J 2025-11-30T14:07:27.704Z 2025-11-30T14:07:27.704Z
8639118 8639118 20251129103010_rEQhR NZ004J 2025-11-30T14:03:47.333Z 2025-12-06T14:43:26.749Z
8638798 8638798 20251129094254_OBDMo NZ004J 2025-11-30T14:02:27.246Z 2025-12-06T14:43:01.059Z
8629968 8629968 20251128145107_OVx1W NZ004J 2025-11-29T14:09:23.239Z 2025-12-06T14:52:36.299Z
8629947 8629947 20251128144754_DZ2Ho NZ004J 2025-11-29T14:09:20.774Z 2025-12-06T14:52:35.980Z
8629930 8629930 20251128144548_pxqji NZ004J 2025-11-29T14:09:19.572Z 2025-11-29T14:09:19.572Z
8629795 8629795 20251128143825_gmb9Z NZ004J 2025-11-29T14:09:01.040Z 2025-11-29T14:09:01.040Z
8629471 8629471 20251128140932_iDwSr NZ004J 2025-11-29T14:08:26.633Z 2025-12-06T14:52:27.963Z
8629453 8629453 20251128140914_KSZ3a NZ004J 2025-11-29T14:08:24.451Z 2025-12-06T14:52:27.859Z
8629277 8629277 20251128135555_fpwME NZ004J 2025-11-29T14:08:14.071Z 2025-12-06T14:52:25.333Z
8629240 8629240 20251128135215_RCmjb NZ004J 2025-11-29T14:08:10.382Z 2025-12-06T14:52:24.693Z

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