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

5,054 rows where station_code = "NZ005N" 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
8685145 8685145 20251204152823_sd53m NZ005N 2025-12-05T14:05:45.963Z 2025-12-05T14:05:45.963Z
8685141 8685141 20251204152705_tOfQ6 NZ005N 2025-12-05T14:05:45.566Z 2025-12-05T14:05:45.566Z
8685040 8685040 20251204150504_8ULLW NZ005N 2025-12-05T14:05:28.041Z 2025-12-05T14:05:28.041Z
8685033 8685033 20251204150400_3TaeC NZ005N 2025-12-05T14:05:27.577Z 2025-12-05T14:05:27.577Z
8685031 8685031 20251204150317_UQrpi NZ005N 2025-12-05T14:05:26.744Z 2025-12-05T14:05:26.744Z
8685016 8685016 20251204150135_7p2Di NZ005N 2025-12-05T14:05:19.739Z 2025-12-05T14:05:19.739Z
8685004 8685004 20251204145519_nLmOB NZ005N 2025-12-05T14:05:18.546Z 2025-12-05T14:05:18.546Z
8685001 8685001 20251204145440_JeEUf NZ005N 2025-12-05T14:05:17.998Z 2025-12-05T14:05:17.998Z
8684931 8684931 20251204143728_PJEl3 NZ005N 2025-12-05T14:05:02.344Z 2025-12-05T14:05:02.344Z
8684830 8684830 20251204141643_aoT4e NZ005N 2025-12-05T14:04:38.339Z 2025-12-05T14:04:38.339Z
8684763 8684763 20251204141051_GkP8q NZ005N 2025-12-05T14:04:32.731Z 2025-12-05T14:04:32.731Z
8684736 8684736 20251204140400_AWZMY NZ005N 2025-12-05T14:04:29.124Z 2025-12-05T14:04:29.124Z
8684723 8684723 20251204140000_T3QCX NZ005N 2025-12-05T14:04:27.327Z 2025-12-05T14:04:27.327Z
8684707 8684707 20251204135629_EsmKy NZ005N 2025-12-05T14:04:20.446Z 2025-12-05T14:04:20.446Z
8684661 8684661 20251204134621_w8Xoc NZ005N 2025-12-05T14:04:09.667Z 2025-12-05T14:04:09.667Z
8684639 8684639 20251204133144_fIa4Y NZ005N 2025-12-05T14:04:05.767Z 2025-12-05T14:04:05.767Z
8684594 8684594 20251204132022_7MR4J NZ005N 2025-12-05T14:03:59.450Z 2025-12-05T14:03:59.450Z
8684566 8684566 20251204131515_stFWs NZ005N 2025-12-05T14:03:46.135Z 2025-12-05T14:03:46.135Z
8684382 8684382 20251204122348_6pFNG NZ005N 2025-12-05T14:02:52.358Z 2025-12-05T14:02:52.358Z
8684377 8684377 20251204122223_iu8Fd NZ005N 2025-12-05T14:02:51.192Z 2025-12-05T14:02:51.192Z
8684367 8684367 20251204122101_d77Q7 NZ005N 2025-12-05T14:02:49.565Z 2025-12-05T14:02:49.565Z
8684215 8684215 20251204112937_093a6 NZ005N 2025-12-05T14:02:11.482Z 2025-12-05T14:02:11.482Z
8684191 8684191 20251204111909_W85lI NZ005N 2025-12-05T14:02:08.801Z 2025-12-05T14:02:08.801Z
8684163 8684163 20251204110248_2K5st NZ005N 2025-12-05T14:02:04.150Z 2025-12-05T14:02:04.150Z
8684066 8684066 20251204103046_qtId3 NZ005N 2025-12-05T14:01:42.406Z 2025-12-05T14:01:42.406Z
8684047 8684047 20251204102924_ZQAO3 NZ005N 2025-12-05T14:01:37.797Z 2025-12-05T14:01:37.797Z
8678211 8678211 20251203152751_3eTHN NZ005N 2025-12-04T14:03:52.101Z 2025-12-05T14:14:35.150Z
8678200 8678200 20251203152505_MIjaD NZ005N 2025-12-04T14:03:47.557Z 2025-12-05T14:14:35.148Z
8678177 8678177 20251203151553_hAH22 NZ005N 2025-12-04T14:03:43.575Z 2025-12-05T14:14:35.135Z
8678171 8678171 20251203151304_8ATv3 NZ005N 2025-12-04T14:03:42.733Z 2025-12-05T14:14:35.134Z
8678160 8678160 20251203150740_79OY3 NZ005N 2025-12-04T14:03:40.786Z 2025-12-05T14:14:35.129Z
8678140 8678140 20251203150203_Z73Jh NZ005N 2025-12-04T14:03:37.885Z 2025-12-05T14:14:35.120Z
8678116 8678116 20251203145228_Y8HhR NZ005N 2025-12-04T14:03:34.148Z 2025-12-05T14:14:35.110Z
8678043 8678043 20251203141438_hS77x NZ005N 2025-12-04T14:03:18.071Z 2025-12-05T14:14:35.070Z
8678004 8678004 20251203135931_Yc9Z5 NZ005N 2025-12-04T14:03:11.052Z 2025-12-05T14:14:35.044Z
8677997 8677997 20251203135829_wZCIG NZ005N 2025-12-04T14:03:10.705Z 2025-12-05T14:14:35.042Z
8677989 8677989 20251203135703_3bMKM NZ005N 2025-12-04T14:03:10.074Z 2025-12-05T14:14:35.040Z
8677977 8677977 20251203134918_R5gxC NZ005N 2025-12-04T14:03:08.590Z 2025-12-05T14:14:35.032Z
8677963 8677963 20251203133938_bvUK0 NZ005N 2025-12-04T14:03:06.588Z 2025-12-05T14:14:35.025Z
8677944 8677944 20251203133131_CCOYd NZ005N 2025-12-04T14:03:04.332Z 2025-12-05T14:14:35.018Z
8677883 8677883 20251203125837_xe3AS NZ005N 2025-12-04T14:02:52.340Z 2025-12-05T14:14:34.996Z
8677870 8677870 20251203124926_Fw2cT NZ005N 2025-12-04T14:02:50.037Z 2025-12-05T14:14:34.991Z
8677860 8677860 20251203124752_303rF NZ005N 2025-12-04T14:02:48.692Z 2025-12-05T14:14:34.989Z
8677852 8677852 20251203124722_y7xHk NZ005N 2025-12-04T14:02:48.390Z 2025-12-05T14:14:34.988Z
8677845 8677845 20251203124502_k9Hdd NZ005N 2025-12-04T14:02:47.535Z 2025-12-05T14:14:34.986Z
8677841 8677841 20251203124446_R6h9s NZ005N 2025-12-04T14:02:47.126Z 2025-12-05T14:14:34.986Z
8677809 8677809 20251203123652_wxR8f NZ005N 2025-12-04T14:02:41.700Z 2025-12-05T14:14:34.975Z
8677802 8677802 20251203123645_ODMx4 NZ005N 2025-12-04T14:02:41.237Z 2025-12-05T14:14:34.975Z
8677774 8677774 20251203122812_2TaAz NZ005N 2025-12-04T14:02:31.243Z 2025-12-05T14:14:34.962Z
8677723 8677723 20251203120229_HU0v8 NZ005N 2025-12-04T14:02:23.786Z 2025-12-05T14:14:34.932Z
8669488 8669488 20251202112048_tEawE NZ005N 2025-12-03T14:04:08.596Z 2025-12-05T14:17:24.591Z
8668958 8668958 20251202094029_wVwKE NZ005N 2025-12-03T14:01:44.086Z 2025-12-05T14:16:23.785Z
8661476 8661476 20251130152934_SDLCI NZ005N 2025-12-02T14:11:36.073Z 2025-12-05T14:32:04.345Z
8661397 8661397 20251130151600_yvSey NZ005N 2025-12-02T14:11:18.495Z 2025-12-05T14:31:59.670Z
8661310 8661310 20251130150736_ZDv6x NZ005N 2025-12-02T14:11:03.791Z 2025-12-05T14:31:57.123Z
8661026 8661026 20251130142740_2R75e NZ005N 2025-12-02T14:10:03.200Z 2025-12-05T14:31:47.001Z
8660828 8660828 20251130135819_lGGFn NZ005N 2025-12-02T14:09:19.414Z 2025-12-05T14:31:27.323Z
8660722 8660722 20251130133915_pfXv3 NZ005N 2025-12-02T14:08:59.066Z 2025-12-05T14:31:21.126Z
8660627 8660627 20251130131821_WtpGq NZ005N 2025-12-02T14:08:34.984Z 2025-12-05T14:31:17.056Z
8660381 8660381 20251130124337_6h4dz NZ005N 2025-12-02T14:07:41.789Z 2025-12-05T14:31:07.805Z
8660291 8660291 20251130122412_qK1EB NZ005N 2025-12-02T14:07:14.295Z 2025-12-05T14:31:03.105Z
8660208 8660208 20251130120450_V3Gz9 NZ005N 2025-12-02T14:06:54.750Z 2025-12-05T14:30:48.878Z
8659298 8659298 20251130100500_uGe05 NZ005N 2025-12-02T14:03:24.527Z 2025-12-05T14:30:00.616Z
8659108 8659108 20251130093447_RfT8Z NZ005N 2025-12-02T14:02:35.725Z 2025-12-05T14:29:53.160Z
8642154 8642154 20251128153520_Gs4Lb NZ005N 2025-11-30T14:17:37.312Z 2025-12-05T14:48:56.498Z
8642101 8642101 20251128153212_DecGE NZ005N 2025-11-30T14:17:23.644Z 2025-12-05T14:48:55.742Z
8642095 8642095 20251128153111_3DBGb NZ005N 2025-11-30T14:17:21.965Z 2025-12-05T14:48:55.603Z
8641920 8641920 20251128151954_qPZb9 NZ005N 2025-11-30T14:17:09.138Z 2025-12-05T14:48:53.135Z
8641871 8641871 20251128151728_elVjy NZ005N 2025-11-30T14:17:05.699Z 2025-12-05T14:48:52.517Z
8641779 8641779 20251128151322_m7fwC NZ005N 2025-11-30T14:17:00.182Z 2025-12-05T14:48:51.688Z
8641759 8641759 20251128151136_mzps4 NZ005N 2025-11-30T14:16:49.442Z 2025-12-05T14:48:51.377Z
8641487 8641487 20251128145556_Iu3P3 NZ005N 2025-11-30T14:16:27.596Z 2025-12-05T14:48:41.778Z
8641435 8641435 20251128145306_wk5UO NZ005N 2025-11-30T14:16:23.915Z 2025-12-05T14:48:39.013Z
8641165 8641165 20251128135941_XTjfh NZ005N 2025-11-30T14:14:38.659Z 2025-12-05T14:47:58.988Z
8640534 8640534 20251129144445_fosUg NZ005N 2025-11-30T14:08:40.810Z 2025-12-05T14:39:18.617Z
8640412 8640412 20251129140834_kYpzM NZ005N 2025-11-30T14:08:17.706Z 2025-12-05T14:39:12.724Z
8640279 8640279 20251129132625_NRdWj NZ005N 2025-11-30T14:07:44.247Z 2025-12-05T14:39:07.815Z
8640218 8640218 20251129130845_qfjql NZ005N 2025-11-30T14:07:33.831Z 2025-12-05T14:38:52.903Z
8640202 8640202 20251129130459_Y3Jft NZ005N 2025-11-30T14:07:31.577Z 2025-11-30T14:07:31.577Z
8640057 8640057 20251129124322_zvYLI NZ005N 2025-11-30T14:06:59.398Z 2025-11-30T14:06:59.398Z
8629910 8629910 20251128144358_NAOcY NZ005N 2025-11-29T14:09:18.083Z 2025-12-05T14:48:29.663Z
8629861 8629861 20251128144128_qK40U NZ005N 2025-11-29T14:09:14.333Z 2025-12-05T14:48:23.019Z
8629813 8629813 20251128144004_yW2B2 NZ005N 2025-11-29T14:09:02.271Z 2025-12-05T14:48:21.998Z
8629728 8629728 20251128143305_PnTOh NZ005N 2025-11-29T14:08:56.235Z 2025-11-29T14:08:56.235Z
8629696 8629696 20251128142949_G3HsL NZ005N 2025-11-29T14:08:53.521Z 2025-12-05T14:48:09.205Z
8629635 8629635 20251128142531_liDOr NZ005N 2025-11-29T14:08:48.136Z 2025-12-05T14:48:08.369Z
8629566 8629566 20251128141847_TE4YH NZ005N 2025-11-29T14:08:42.222Z 2025-12-05T14:48:06.563Z
8629485 8629485 20251128141036_L3tfb NZ005N 2025-11-29T14:08:28.569Z 2025-12-05T14:48:05.382Z
8629480 8629480 20251128140959_6vAV2 NZ005N 2025-11-29T14:08:28.074Z 2025-12-05T14:48:04.858Z
8629468 8629468 20251128140932_tEVGd NZ005N 2025-11-29T14:08:25.549Z 2025-11-29T14:08:25.549Z
8629449 8629449 20251128140848_llGWL NZ005N 2025-11-29T14:08:24.068Z 2025-11-29T14:08:24.068Z
8629446 8629446 20251128140834_oNZFr NZ005N 2025-11-29T14:08:23.754Z 2025-12-05T14:48:01.058Z
8629419 8629419 20251128140537_ytXy1 NZ005N 2025-11-29T14:08:21.804Z 2025-12-05T14:47:59.940Z
8629334 8629334 20251128140037_Kq63V NZ005N 2025-11-29T14:08:16.980Z 2025-12-05T14:47:59.071Z
8629324 8629324 20251128135941_QMry8 NZ005N 2025-11-29T14:08:16.331Z 2025-11-29T14:08:16.331Z
8629186 8629186 20251128134737_J5KzM NZ005N 2025-11-29T14:08:05.302Z 2025-12-05T14:47:56.925Z
8629129 8629129 20251128134418_Gg533 NZ005N 2025-11-29T14:07:52.317Z 2025-12-05T14:47:55.794Z
8629093 8629093 20251128134307_smQ3w NZ005N 2025-11-29T14:07:50.781Z 2025-12-05T14:47:55.278Z
8629045 8629045 20251128133920_ZKheZ NZ005N 2025-11-29T14:07:44.829Z 2025-12-05T14:47:54.606Z
8628915 8628915 20251128132253_Si303 NZ005N 2025-11-29T14:07:31.126Z 2025-12-05T14:47:52.471Z

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