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

8,399 rows where station_code = "NZ004T" 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
9270664 9270664 20260128161842_ZCecY NZ004T 2026-01-29T14:13:14.307Z 2026-01-29T14:13:14.307Z
9270609 9270609 20260128161118_KgkcD NZ004T 2026-01-29T14:13:00.519Z 2026-01-29T14:13:00.519Z
9270538 9270538 20260128155857_0PuOI NZ004T 2026-01-29T14:12:41.580Z 2026-01-29T14:12:41.580Z
9270273 9270273 20260128152315_c0tux NZ004T 2026-01-29T14:11:30.016Z 2026-01-29T14:11:30.016Z
9270239 9270239 20260128151845_iBDIW NZ004T 2026-01-29T14:11:22.545Z 2026-01-29T14:11:22.545Z
9270074 9270074 20260128145132_P63LH NZ004T 2026-01-29T14:10:46.897Z 2026-01-29T14:10:46.897Z
9270054 9270054 20260128145058_Zs3KN NZ004T 2026-01-29T14:10:44.121Z 2026-01-29T14:10:44.121Z
9269923 9269923 20260128143215_6NeO2 NZ004T 2026-01-29T14:10:13.987Z 2026-01-29T14:10:13.987Z
9269810 9269810 20260128141624_yL7Vu NZ004T 2026-01-29T14:09:43.297Z 2026-01-29T14:09:43.297Z
9268194 9268194 20260128091759_jb60b NZ004T 2026-01-29T14:01:37.013Z 2026-01-29T14:01:37.013Z
9263991 9263991 20260127104932_242Ak NZ004T 2026-01-28T14:03:49.899Z 2026-01-29T14:30:19.985Z
9257775 9257775 20260125155432_nTHJK NZ004T 2026-01-26T14:07:41.820Z 2026-01-29T14:37:39.195Z
9257718 9257718 20260125154109_Zgu3o NZ004T 2026-01-26T14:07:25.160Z 2026-01-29T14:37:36.823Z
9257591 9257591 20260125144814_vAnzg NZ004T 2026-01-26T14:06:32.999Z 2026-01-29T14:37:29.294Z
9257331 9257331 20260125124915_fLWMl NZ004T 2026-01-26T14:04:46.379Z 2026-01-29T14:37:05.866Z
9257259 9257259 20260125123721_FzThG NZ004T 2026-01-26T14:04:28.694Z 2026-01-29T14:37:02.229Z
9257231 9257231 20260125122837_dfUQp NZ004T 2026-01-26T14:04:17.116Z 2026-01-29T14:37:00.461Z
9256803 9256803 20260125103349_FSh7t NZ004T 2026-01-26T14:02:05.750Z 2026-01-29T14:36:25.003Z
9256740 9256740 20260125101446_pkXn7 NZ004T 2026-01-26T14:01:41.787Z 2026-01-29T14:36:19.381Z
9256697 9256697 20260125100246_xtkjd NZ004T 2026-01-26T14:01:28.562Z 2026-01-29T14:36:17.092Z
9252950 9252950 20260123083408_NXQ1H NZ004T 2026-01-24T14:17:58.578Z 2026-01-29T14:53:43.962Z
9250478 9250478 20260123153001_yMwTm NZ004T 2026-01-24T14:03:08.436Z 2026-01-29T14:45:37.947Z
9250062 9250062 20260123100128_Xuyko NZ004T 2026-01-24T14:00:55.894Z 2026-01-29T14:44:56.549Z
9249972 9249972 20260123091737_43Em6 NZ004T 2026-01-24T14:00:23.511Z 2026-01-29T14:44:45.667Z
9245135 9245135 20260122102740_8vy5L NZ004T 2026-01-23T14:00:44.738Z 2026-01-29T14:49:03.746Z
9245123 9245123 20260122101939_retu2 NZ004T 2026-01-23T14:00:41.944Z 2026-01-29T14:49:02.946Z
9216068 9216068 20260116114651_SEAGR NZ004T 2026-01-17T14:27:47.798Z 2026-01-24T15:15:25.166Z
9216024 9216024 20260116114229_FV35x NZ004T 2026-01-17T14:27:39.715Z 2026-01-24T15:15:23.779Z
9215984 9215984 20260116113603_oljgm NZ004T 2026-01-17T14:27:33.084Z 2026-01-24T15:15:22.602Z
9215980 9215980 20260116113241_7MvwV NZ004T 2026-01-17T14:27:32.022Z 2026-01-24T15:15:22.453Z
9215931 9215931 20260116112559_LY2xf NZ004T 2026-01-17T14:27:17.295Z 2026-01-24T15:15:18.658Z
9215881 9215881 20260116112148_7fSnU NZ004T 2026-01-17T14:27:09.751Z 2026-01-24T15:15:16.308Z
9215861 9215861 20260116111448_L9dsq NZ004T 2026-01-17T14:27:06.348Z 2026-01-24T15:15:15.560Z
9215812 9215812 20260116110340_joqYP NZ004T 2026-01-17T14:26:59.147Z 2026-01-24T15:15:14.102Z
9215614 9215614 20260116103533_PMQmE NZ004T 2026-01-17T14:26:16.654Z 2026-01-24T15:15:05.002Z
9215152 9215152 20260116092810_J39yd NZ004T 2026-01-17T14:24:36.659Z 2026-01-24T15:14:32.793Z
9215053 9215053 20260116090341_hh2YP NZ004T 2026-01-17T14:24:11.418Z 2026-01-24T15:14:28.033Z
9211048 9211048 20260116151451_bMUFk NZ004T 2026-01-17T14:04:02.942Z 2026-01-25T14:57:17.408Z
9210907 9210907 20260116140008_8v9MU NZ004T 2026-01-17T14:03:22.328Z 2026-01-25T14:57:11.411Z
9210878 9210878 20260116134524_cO7N5 NZ004T 2026-01-17T14:03:13.372Z 2026-01-25T14:57:10.340Z
9210866 9210866 20260116134256_gDljO NZ004T 2026-01-17T14:03:12.032Z 2026-01-25T14:57:10.043Z
9210861 9210861 20260116134055_EAftL NZ004T 2026-01-17T14:03:11.268Z 2026-01-25T14:57:09.966Z
9210849 9210849 20260116133452_7hP14 NZ004T 2026-01-17T14:03:06.562Z 2026-01-25T14:57:09.577Z
9210841 9210841 20260116132942_As8Bd NZ004T 2026-01-17T14:03:05.089Z 2026-01-25T14:57:09.301Z
9210829 9210829 20260116132835_JqBzo NZ004T 2026-01-17T14:03:02.305Z 2026-01-25T14:57:09.017Z
9210728 9210728 20260116130332_JsSdQ NZ004T 2026-01-17T14:02:31.432Z 2026-01-25T14:56:53.773Z
9210563 9210563 20260116123708_q22Es NZ004T 2026-01-17T14:01:41.549Z 2026-01-25T14:56:47.465Z
9210494 9210494 20260116122623_QWayt NZ004T 2026-01-17T14:01:15.233Z 2026-01-25T14:56:44.939Z
9210472 9210472 20260116122421_8opvo NZ004T 2026-01-17T14:01:08.353Z 2026-01-25T14:56:44.220Z
9210367 9210367 20260116120952_yucFX NZ004T 2026-01-17T14:00:31.640Z 2026-01-25T14:56:40.977Z
9210331 9210331 20260116120252_EB3sF NZ004T 2026-01-17T14:00:16.858Z 2026-01-25T14:56:39.799Z
9210323 9210323 20260116120203_9p0Su NZ004T 2026-01-17T14:00:14.003Z 2026-01-25T14:56:39.600Z
9193088 9193088 20260112133537_bMySw NZ004T 2026-01-13T14:30:08.358Z 2026-01-20T15:26:58.930Z
9192977 9192977 20260112132216_L21iZ NZ004T 2026-01-13T14:29:53.531Z 2026-01-20T15:26:50.495Z
9192903 9192903 20260112131349_3sgOE NZ004T 2026-01-13T14:29:37.764Z 2026-01-20T15:26:38.935Z
9192846 9192846 20260112130719_nrTz0 NZ004T 2026-01-13T14:29:29.305Z 2026-01-20T15:26:36.730Z
9192652 9192652 20260112125036_E9aDG NZ004T 2026-01-13T14:28:58.809Z 2026-01-20T15:26:28.487Z
9192510 9192510 20260112123923_HxAvc NZ004T 2026-01-13T14:28:31.615Z 2026-01-20T15:26:23.935Z
9192358 9192358 20260112122653_VBe8O NZ004T 2026-01-13T14:28:09.621Z 2026-01-20T15:26:19.763Z
9192292 9192292 20260112122122_vNy6Y NZ004T 2026-01-13T14:28:00.528Z 2026-01-20T15:26:17.294Z
9192204 9192204 20260112121203_pBV40 NZ004T 2026-01-13T14:27:43.068Z 2026-01-20T15:26:14.401Z
9192126 9192126 20260112120658_4f6bY NZ004T 2026-01-13T14:27:32.525Z 2026-01-20T15:25:59.882Z
9192053 9192053 20260112120337_dOnsR NZ004T 2026-01-13T14:27:17.483Z 2026-01-20T15:25:57.759Z
9192001 9192001 20260112115847_zqe0l NZ004T 2026-01-13T14:27:09.863Z 2026-01-20T15:25:54.737Z
9191700 9191700 20260112113521_7LP75 NZ004T 2026-01-13T14:26:11.853Z 2026-01-20T15:25:43.865Z
9191328 9191328 20260112105805_nQnFZ NZ004T 2026-01-13T14:25:03.545Z 2026-01-20T15:25:20.332Z
9191213 9191213 20260112104549_zFXDr NZ004T 2026-01-13T14:24:44.065Z 2026-01-20T15:25:14.605Z
9191178 9191178 20260112104229_Hvkje NZ004T 2026-01-13T14:24:37.801Z 2026-01-20T15:25:13.283Z
9191098 9191098 20260112103244_u1tr7 NZ004T 2026-01-13T14:24:25.937Z 2026-01-20T15:25:09.938Z
9190818 9190818 20260112100150_9uxP9 NZ004T 2026-01-13T14:23:33.043Z 2026-01-20T15:24:50.459Z
9190654 9190654 20260112093347_ZLzno NZ004T 2026-01-13T14:22:57.938Z 2026-01-20T15:24:41.946Z
9190580 9190580 20260112092452_ymy3J NZ004T 2026-01-13T14:22:48.061Z 2026-01-20T15:24:39.775Z
9190480 9190480 20260112091114_QvvC7 NZ004T 2026-01-13T14:22:23.083Z 2026-01-20T15:24:34.940Z
9186822 9186822 20260112154711_CJmlK NZ004T 2026-01-13T14:03:39.521Z 2026-01-21T15:03:01.397Z
9185961 9185961 20260111140154_PfC9g NZ004T 2026-01-12T14:26:24.209Z 2026-01-19T15:22:08.453Z
9185919 9185919 20260111135247_eI3Ao NZ004T 2026-01-12T14:26:17.291Z 2026-01-19T15:22:05.081Z
9185886 9185886 20260111134410_av8VZ NZ004T 2026-01-12T14:26:13.054Z 2026-01-19T15:22:01.812Z
9185883 9185883 20260111134032_g1jya NZ004T 2026-01-12T14:26:12.729Z 2026-01-19T15:22:00.815Z
9185501 9185501 20260111112148_gPdjQ NZ004T 2026-01-12T14:25:03.891Z 2026-01-19T15:20:55.562Z
9185469 9185469 20260111111416_8Q6eW NZ004T 2026-01-12T14:25:00.820Z 2026-01-19T15:20:34.265Z
9184176 9184176 20260111105309_AZQoE NZ004T 2026-01-12T14:19:52.066Z 2026-01-12T14:19:52.066Z
9184165 9184165 20260111105021_KfZU7 NZ004T 2026-01-12T14:19:49.447Z 2026-01-19T15:20:25.616Z
9183622 9183622 20260111095415_03vWK NZ004T 2026-01-12T14:18:20.777Z 2026-01-19T15:19:48.116Z
9183461 9183461 20260111093140_fJwO2 NZ004T 2026-01-12T14:17:51.266Z 2026-01-19T15:19:40.375Z
9183232 9183232 20260111090009_C61s4 NZ004T 2026-01-12T14:17:13.783Z 2026-01-12T14:17:13.783Z
9179020 9179020 20260110133730_aOrAl NZ004T 2026-01-11T14:16:25.657Z 2026-01-18T15:11:10.089Z
9178962 9178962 20260110143512_Glyrr NZ004T 2026-01-11T14:16:07.966Z 2026-01-18T15:11:26.399Z
9178947 9178947 20260110143055_98YgL NZ004T 2026-01-11T14:16:06.627Z 2026-01-18T15:11:25.552Z
9178942 9178942 20260110143005_6igWo NZ004T 2026-01-11T14:16:06.363Z 2026-01-18T15:11:25.251Z
9178877 9178877 20260110142131_2gVh1 NZ004T 2026-01-11T14:15:55.357Z 2026-01-18T15:11:21.992Z
9178850 9178850 20260110142021_3x2v3 NZ004T 2026-01-11T14:15:50.977Z 2026-01-18T15:11:20.465Z
9178808 9178808 20260110141220_pifsS NZ004T 2026-01-11T14:15:45.629Z 2026-01-18T15:11:17.807Z
9178468 9178468 20260110131257_sJk3U NZ004T 2026-01-11T14:15:01.828Z 2026-01-18T15:10:52.378Z
9178380 9178380 20260110125928_zvqxt NZ004T 2026-01-11T14:14:42.804Z 2026-01-18T15:10:47.179Z
9178366 9178366 20260110125629_szJq8 NZ004T 2026-01-11T14:14:41.669Z 2026-01-18T15:10:46.487Z
9177553 9177553 20260110101654_0cY7Q NZ004T 2026-01-11T14:12:19.367Z 2026-01-18T15:09:48.325Z
9174351 9174351 20260109152950_X3Zm6 NZ004T 2026-01-11T14:02:27.381Z 2026-01-18T15:06:23.899Z
9174345 9174345 20260109151536_9LgZw NZ004T 2026-01-11T14:02:21.211Z 2026-01-18T15:06:21.000Z
9174335 9174335 20260109150806_3tj6i NZ004T 2026-01-11T14:02:16.030Z 2026-01-18T15:06:19.323Z
9174272 9174272 20260110160041_gC0Zt NZ004T 2026-01-11T14:01:57.910Z 2026-01-19T15:14:46.582Z

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