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 = "NZ0034" 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
8685214 8685214 20251204154437_jzOhq NZ0034 2025-12-05T14:06:12.596Z 2025-12-05T14:06:12.596Z
8685116 8685116 20251204152033_3yTQh NZ0034 2025-12-05T14:05:42.598Z 2025-12-05T14:05:42.598Z
8684858 8684858 20251204142426_o3Rzl NZ0034 2025-12-05T14:04:44.553Z 2025-12-05T14:04:44.553Z
8684792 8684792 20251204141346_2453K NZ0034 2025-12-05T14:04:35.135Z 2025-12-05T14:04:35.135Z
8684486 8684486 20251204125242_t8rqp NZ0034 2025-12-05T14:03:30.032Z 2025-12-05T14:03:30.032Z
8684013 8684013 20251204100847_gUgAi NZ0034 2025-12-05T14:01:33.022Z 2025-12-05T14:01:33.022Z
8683921 8683921 20251204092400_84j6P NZ0034 2025-12-05T14:01:04.902Z 2025-12-05T14:01:04.902Z
8683807 8683807 20251204083354_a3a2E NZ0034 2025-12-05T14:00:44.760Z 2025-12-05T14:00:44.760Z
8678243 8678243 20251203155316_IGo4h NZ0034 2025-12-04T14:04:01.895Z 2025-12-05T14:14:35.174Z
8677447 8677447 20251203100329_g2nUV NZ0034 2025-12-04T14:01:16.556Z 2025-12-05T14:14:34.845Z
8672813 8672813 20251201152500_VmnjK NZ0034 2025-12-03T14:16:36.894Z 2025-12-05T14:25:42.721Z
8672759 8672759 20251201151526_tQzbS NZ0034 2025-12-03T14:16:23.606Z 2025-12-05T14:25:41.323Z
8672715 8672715 20251201151015_zFNTP NZ0034 2025-12-03T14:16:19.013Z 2025-12-05T14:25:39.652Z
8672189 8672189 20251201140121_ZZm3J NZ0034 2025-12-03T14:14:55.201Z 2025-12-05T14:25:11.443Z
8672104 8672104 20251201135148_fxWc7 NZ0034 2025-12-03T14:14:42.496Z 2025-12-05T14:25:08.231Z
8672007 8672007 20251201133814_qXGP8 NZ0034 2025-12-03T14:14:29.180Z 2025-12-05T14:25:03.923Z
8671899 8671899 20251201131519_kR3dl NZ0034 2025-12-03T14:14:07.193Z 2025-12-05T14:24:58.857Z
8671050 8671050 20251201110808_33uOB NZ0034 2025-12-03T14:11:10.202Z 2025-12-05T14:24:04.235Z
8670887 8670887 20251201103708_IaBIg NZ0034 2025-12-03T14:10:38.391Z 2025-12-05T14:23:54.555Z
8670755 8670755 20251201100808_XkZth NZ0034 2025-12-03T14:10:00.139Z 2025-12-05T14:23:48.074Z
8670753 8670753 20251201100739_HyA4S NZ0034 2025-12-03T14:09:59.503Z 2025-12-05T14:23:47.951Z
8670731 8670731 20251201100439_21whC NZ0034 2025-12-03T14:09:56.831Z 2025-12-05T14:23:47.132Z
8670702 8670702 20251201100046_itezr NZ0034 2025-12-03T14:09:52.947Z 2025-12-05T14:23:45.857Z
8670561 8670561 20251201092528_2YojF NZ0034 2025-12-03T14:09:15.335Z 2025-12-05T14:23:31.920Z
8670534 8670534 20251201091903_I2pNh NZ0034 2025-12-03T14:09:07.846Z 2025-12-05T14:23:28.467Z
8670525 8670525 20251201091621_mxFCJ NZ0034 2025-12-03T14:09:06.219Z 2025-12-05T14:23:28.018Z
8670447 8670447 20251201085621_lDSN3 NZ0034 2025-12-03T14:08:51.575Z 2025-12-05T14:23:22.600Z
8670258 8670258 20251202154644_mDkuH NZ0034 2025-12-03T14:07:44.709Z 2025-12-05T14:18:34.088Z
8670242 8670242 20251202154041_vwxvi NZ0034 2025-12-03T14:07:36.276Z 2025-12-05T14:18:33.044Z
8661504 8661504 20251130153813_DKD48 NZ0034 2025-12-02T14:11:41.425Z 2025-12-05T14:32:05.601Z
8661429 8661429 20251130151930_22pDq NZ0034 2025-12-02T14:11:28.002Z 2025-12-05T14:32:00.788Z
8661193 8661193 20251130145716_dUKBX NZ0034 2025-12-02T14:10:41.581Z 2025-12-05T14:31:52.808Z
8648838 8648838 20251129134410_mfdmw NZ0034 2025-12-01T14:07:59.793Z 2025-12-05T14:39:10.029Z
8642302 8642302 20251128154900_AlqRt NZ0034 2025-11-30T14:17:45.624Z 2025-12-05T14:48:58.192Z
8642291 8642291 20251128154802_UCHKV NZ0034 2025-11-30T14:17:44.596Z 2025-12-05T14:48:58.064Z
8641896 8641896 20251128151830_6pugO NZ0034 2025-11-30T14:17:07.245Z 2025-12-05T14:48:52.815Z
8641723 8641723 20251128151006_27fev NZ0034 2025-11-30T14:16:44.945Z 2025-12-05T14:48:50.895Z
8641661 8641661 20251128150531_TPT20 NZ0034 2025-11-30T14:16:38.469Z 2025-12-05T14:48:50.129Z
8641464 8641464 20251128145441_8JvEA NZ0034 2025-11-30T14:16:25.582Z 2025-12-05T14:48:39.694Z
8640708 8640708 20251129153224_9eRfk NZ0034 2025-11-30T14:09:18.514Z 2025-12-05T14:39:26.059Z
8640670 8640670 20251129151927_7bT4l NZ0034 2025-11-30T14:09:12.478Z 2025-12-05T14:39:24.112Z
8640566 8640566 20251129145228_733bb NZ0034 2025-11-30T14:08:49.324Z 2025-11-30T14:08:49.324Z
8640499 8640499 20251129143711_nH5s1 NZ0034 2025-11-30T14:08:33.254Z 2025-12-05T14:39:16.681Z
8640494 8640494 20251129143649_QmeVr NZ0034 2025-11-30T14:08:32.451Z 2025-12-05T14:39:16.585Z
8640471 8640471 20251129142932_R7erV NZ0034 2025-11-30T14:08:29.110Z 2025-12-05T14:39:15.765Z
8640465 8640465 20251129142811_4QnzO NZ0034 2025-11-30T14:08:28.767Z 2025-12-05T14:39:15.745Z
8640460 8640460 20251129142635_BuRHN NZ0034 2025-11-30T14:08:27.943Z 2025-11-30T14:08:27.943Z
8640348 8640348 20251129135019_zZjrS NZ0034 2025-11-30T14:08:05.075Z 2025-12-05T14:39:10.819Z
8640318 8640318 20251129134410_XfkJ5 NZ0034 2025-11-30T14:07:56.928Z 2025-12-05T14:39:09.936Z
8640313 8640313 20251129134311_QqfwP NZ0034 2025-11-30T14:07:51.320Z 2025-12-05T14:39:09.735Z
8640298 8640298 20251129133423_3HXXx NZ0034 2025-11-30T14:07:47.134Z 2025-12-05T14:39:08.685Z
8640285 8640285 20251129132915_h3cDF NZ0034 2025-11-30T14:07:45.325Z 2025-12-05T14:39:08.004Z
8640227 8640227 20251129131032_TbLC1 NZ0034 2025-11-30T14:07:34.883Z 2025-12-05T14:38:59.748Z
8640018 8640018 20251129124049_AtMvQ NZ0034 2025-11-30T14:06:55.141Z 2025-12-05T14:38:41.950Z
8639398 8639398 20251129110215_vnTcl NZ0034 2025-11-30T14:04:46.978Z 2025-12-05T14:38:20.789Z
8638657 8638657 20251129092001_7PC2s NZ0034 2025-11-30T14:01:49.622Z 2025-12-05T14:37:38.754Z
8629848 8629848 20251128144112_2jWj8 NZ0034 2025-11-29T14:09:13.316Z 2025-12-05T14:48:22.886Z
8629818 8629818 20251128144014_JeWRO NZ0034 2025-11-29T14:09:02.544Z 2025-12-05T14:48:22.128Z
8629806 8629806 20251128144000_350Mi NZ0034 2025-11-29T14:09:01.866Z 2025-12-05T14:48:21.916Z
8629799 8629799 20251128143840_Y3IBI NZ0034 2025-11-29T14:09:01.295Z 2025-12-05T14:48:20.543Z
8629781 8629781 20251128143809_49KCf NZ0034 2025-11-29T14:09:00.483Z 2025-12-05T14:48:18.744Z
8629770 8629770 20251128143743_SMEgB NZ0034 2025-11-29T14:08:59.992Z 2025-12-05T14:48:18.342Z
8629678 8629678 20251128142806_wGBvW NZ0034 2025-11-29T14:08:52.432Z 2025-12-05T14:48:09.009Z
8629650 8629650 20251128142716_Lb3Sh NZ0034 2025-11-29T14:08:50.444Z 2025-12-05T14:48:08.784Z
8629586 8629586 20251128142018_qGtmU NZ0034 2025-11-29T14:08:43.752Z 2025-12-05T14:48:06.988Z
8629462 8629462 20251128140916_ed9HC NZ0034 2025-11-29T14:08:24.898Z 2025-12-05T14:48:04.612Z
8629396 8629396 20251128140432_cmhLt NZ0034 2025-11-29T14:08:20.746Z 2025-12-05T14:47:59.780Z
8629161 8629161 20251128134654_R4LPx NZ0034 2025-11-29T14:07:54.873Z 2025-12-05T14:47:56.644Z
8629137 8629137 20251128134436_UGGNH NZ0034 2025-11-29T14:07:53.129Z 2025-12-05T14:47:55.970Z
8629041 8629041 20251128133902_lVv6v NZ0034 2025-11-29T14:07:44.478Z 2025-11-29T14:07:44.478Z
8629018 8629018 20251128133534_O2e38 NZ0034 2025-11-29T14:07:42.063Z 2025-12-05T14:47:54.432Z
8628856 8628856 20251128131438_9IJZ1 NZ0034 2025-11-29T14:07:14.499Z 2025-12-05T14:47:51.175Z
8628809 8628809 20251128131107_mXD6t NZ0034 2025-11-29T14:07:10.483Z 2025-12-05T14:47:50.591Z
8628764 8628764 20251128130901_hsFjn NZ0034 2025-11-29T14:07:03.918Z 2025-12-05T14:47:49.683Z
8628762 8628762 20251128130859_1WnNy NZ0034 2025-11-29T14:07:03.705Z 2025-12-05T14:47:49.634Z
8628741 8628741 20251128130646_pLVtJ NZ0034 2025-11-29T14:07:01.800Z 2025-12-05T14:47:49.422Z
8628642 8628642 20251128130155_8x2Qe NZ0034 2025-11-29T14:06:53.289Z 2025-12-05T14:47:47.651Z
8628495 8628495 20251128124931_Vewv5 NZ0034 2025-11-29T14:06:26.137Z 2025-12-05T14:47:43.919Z
8628346 8628346 20251128123643_ihw6F NZ0034 2025-11-29T14:05:56.637Z 2025-12-05T14:47:41.351Z
8628121 8628121 20251128121531_tzCZ3 NZ0034 2025-11-29T14:05:31.118Z 2025-12-05T14:47:14.445Z
8628083 8628083 20251128121326_LqTBY NZ0034 2025-11-29T14:05:19.149Z 2025-12-05T14:47:13.732Z
8627850 8627850 20251128114509_mI3Xp NZ0034 2025-11-29T14:04:37.328Z 2025-12-05T14:47:07.323Z
8627514 8627514 20251128110819_zQjUE NZ0034 2025-11-29T14:03:51.980Z 2025-12-05T14:47:00.974Z
8627463 8627463 20251128110149_n0Hzr NZ0034 2025-11-29T14:03:36.218Z 2025-12-05T14:46:59.909Z
8627237 8627237 20251128103948_BYgeV NZ0034 2025-11-29T14:03:07.377Z 2025-12-05T14:46:56.244Z
8627162 8627162 20251128103118_53b62 NZ0034 2025-11-29T14:02:51.472Z 2025-12-05T14:46:54.344Z
8626940 8626940 20251128100111_q2CQt NZ0034 2025-11-29T14:02:07.115Z 2025-12-05T14:46:24.562Z
8620889 8620889 20251126135104_6Tjik NZ0034 2025-11-28T14:14:18.398Z 2025-12-05T15:02:38.492Z
8620882 8620882 20251126135032_NEv3e NZ0034 2025-11-28T14:14:17.921Z 2025-12-05T15:02:38.422Z
8620871 8620871 20251126134842_ySXDJ NZ0034 2025-11-28T14:14:16.832Z 2025-12-05T15:02:38.323Z
8619551 8619551 20251126102558_73j8g NZ0034 2025-11-28T14:09:22.584Z 2025-12-05T15:01:01.329Z
8618978 8618978 20251127152552_biT4B NZ0034 2025-11-28T14:06:37.726Z 2025-12-05T14:54:56.108Z
8618963 8618963 20251127151644_AIuZ5 NZ0034 2025-11-28T14:06:35.021Z 2025-12-05T14:54:51.680Z
8604593 8604593 20251124091008_2d3Af NZ0034 2025-11-26T14:37:29.985Z 2025-12-02T15:13:06.779Z
8604535 8604535 20251124084350_qWRbA NZ0034 2025-11-26T14:37:24.007Z 2025-12-02T15:13:05.692Z
8604524 8604524 20251124082606_9bsJP NZ0034 2025-11-26T14:37:22.278Z 2025-12-02T15:13:05.327Z
8604241 8604241 20251125090939_3qiFQ NZ0034 2025-11-26T14:28:50.131Z 2025-12-02T15:09:40.482Z
8595320 8595320 20251124150558_7bsPS NZ0034 2025-11-26T14:10:42.927Z 2025-12-02T15:05:52.261Z
8595313 8595313 20251124150313_2eNV2 NZ0034 2025-11-26T14:10:37.362Z 2025-12-02T15:05:52.115Z
8594299 8594299 20251124103418_VcsQO NZ0034 2025-11-26T14:05:47.363Z 2025-12-02T15:05:28.957Z

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