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 = "NZ002K" 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
8689356 8689356 20251205152737_OmeB6 NZ002K 2025-12-06T14:08:00.443Z 2025-12-06T14:08:00.443Z
8689352 8689352 20251205152533_3Fmsi NZ002K 2025-12-06T14:07:58.450Z 2025-12-06T14:07:58.450Z
8689309 8689309 20251205151009_9xodT NZ002K 2025-12-06T14:07:49.843Z 2025-12-06T14:07:49.843Z
8689280 8689280 20251205145904_ZV0Aw NZ002K 2025-12-06T14:07:43.798Z 2025-12-06T14:07:43.798Z
8689204 8689204 20251205144355_r9bc0 NZ002K 2025-12-06T14:07:22.577Z 2025-12-06T14:07:22.577Z
8689142 8689142 20251205142549_Aso13 NZ002K 2025-12-06T14:07:12.525Z 2025-12-06T14:07:12.525Z
8689137 8689137 20251205142431_yT7JP NZ002K 2025-12-06T14:07:11.559Z 2025-12-06T14:07:11.559Z
8689134 8689134 20251205142321_wBKMf NZ002K 2025-12-06T14:07:11.053Z 2025-12-06T14:07:11.053Z
8689079 8689079 20251205140429_heeRb NZ002K 2025-12-06T14:06:58.694Z 2025-12-06T14:06:58.694Z
8688839 8688839 20251205125938_M4ar9 NZ002K 2025-12-06T14:05:58.965Z 2025-12-06T14:05:58.965Z
8688726 8688726 20251205123010_dgV7z NZ002K 2025-12-06T14:05:35.308Z 2025-12-06T14:05:35.308Z
8688712 8688712 20251205122850_D5G0i NZ002K 2025-12-06T14:05:34.067Z 2025-12-06T14:05:34.067Z
8688535 8688535 20251205115733_r3JLb NZ002K 2025-12-06T14:04:52.317Z 2025-12-06T14:04:52.317Z
8688482 8688482 20251205114140_H9II6 NZ002K 2025-12-06T14:04:43.823Z 2025-12-06T14:04:43.823Z
8688466 8688466 20251205113929_TBpcp NZ002K 2025-12-06T14:04:41.380Z 2025-12-06T14:04:41.380Z
8688405 8688405 20251205112637_pIyzr NZ002K 2025-12-06T14:04:28.220Z 2025-12-06T14:04:28.220Z
8688380 8688380 20251205112110_IKfgE NZ002K 2025-12-06T14:04:18.739Z 2025-12-06T14:04:18.739Z
8688320 8688320 20251205110545_cgks9 NZ002K 2025-12-06T14:04:05.470Z 2025-12-06T14:04:05.470Z
8688193 8688193 20251205104428_mwaec NZ002K 2025-12-06T14:03:37.010Z 2025-12-06T14:03:37.010Z
8687926 8687926 20251205094640_FHuh3 NZ002K 2025-12-06T14:02:25.937Z 2025-12-06T14:02:25.937Z
8687901 8687901 20251205093712_Rjt0j NZ002K 2025-12-06T14:02:19.281Z 2025-12-06T14:02:19.281Z
8685210 8685210 20251204154223_5oIgm NZ002K 2025-12-05T14:06:11.817Z 2025-12-06T14:18:00.704Z
8685148 8685148 20251204153006_Fqavc NZ002K 2025-12-05T14:05:46.660Z 2025-12-06T14:18:00.686Z
8684964 8684964 20251204144805_BlLhs NZ002K 2025-12-05T14:05:09.288Z 2025-12-06T14:18:00.638Z
8684893 8684893 20251204142803_43T8i NZ002K 2025-12-05T14:04:54.740Z 2025-12-06T14:18:00.619Z
8684857 8684857 20251204142426_o3Rzl NZ002K 2025-12-05T14:04:44.553Z 2025-12-06T14:18:00.612Z
8684818 8684818 20251204141614_d5R26 NZ002K 2025-12-05T14:04:37.799Z 2025-12-06T14:18:00.603Z
8684778 8684778 20251204141249_uy4LY NZ002K 2025-12-05T14:04:34.262Z 2025-12-06T14:18:00.596Z
8684724 8684724 20251204140006_t9PIW NZ002K 2025-12-05T14:04:27.805Z 2025-12-06T14:18:00.586Z
8684625 8684625 20251204132758_DQfm6 NZ002K 2025-12-05T14:04:04.668Z 2025-12-06T14:18:00.561Z
8684508 8684508 20251204130037_j0iAK NZ002K 2025-12-05T14:03:34.478Z 2025-12-06T14:18:00.531Z
8684409 8684409 20251204123129_vjXqL NZ002K 2025-12-05T14:03:01.323Z 2025-12-06T14:18:00.502Z
8684333 8684333 20251204120813_YkXDp NZ002K 2025-12-05T14:02:45.129Z 2025-12-06T14:18:00.480Z
8684303 8684303 20251204120006_tt4D4 NZ002K 2025-12-05T14:02:40.502Z 2025-12-06T14:18:00.472Z
8684208 8684208 20251204112919_0igA9 NZ002K 2025-12-05T14:02:11.148Z 2025-12-06T14:18:00.441Z
8684193 8684193 20251204111936_zKFVH NZ002K 2025-12-05T14:02:09.247Z 2025-12-06T14:18:00.438Z
8684171 8684171 20251204111040_M9E97 NZ002K 2025-12-05T14:02:05.634Z 2025-12-06T14:18:00.434Z
8684144 8684144 20251204105518_OWOdS NZ002K 2025-12-05T14:02:01.831Z 2025-12-06T14:18:00.427Z
8684137 8684137 20251204105518_V99EZ NZ002K 2025-12-05T14:02:01.583Z 2025-12-06T14:18:00.426Z
8684117 8684117 20251204105015_O0OBg NZ002K 2025-12-05T14:01:59.142Z 2025-12-06T14:18:00.421Z
8684022 8684022 20251204101644_i9EiW NZ002K 2025-12-05T14:01:34.783Z 2025-12-06T14:18:00.397Z
8683960 8683960 20251204094830_09H9O NZ002K 2025-12-05T14:01:22.436Z 2025-12-06T14:18:00.381Z
8683908 8683908 20251204092017_DDRAR NZ002K 2025-12-05T14:01:02.890Z 2025-12-06T14:18:00.365Z
8672787 8672787 20251201151801_5cfW4 NZ002K 2025-12-03T14:16:27.209Z 2025-12-06T14:32:20.747Z
8672664 8672664 20251201150228_xukR0 NZ002K 2025-12-03T14:16:07.310Z 2025-12-06T14:32:06.902Z
8672519 8672519 20251201144031_S3O9I NZ002K 2025-12-03T14:15:50.059Z 2025-12-06T14:32:00.197Z
8672492 8672492 20251201143710_n1kBy NZ002K 2025-12-03T14:15:39.916Z 2025-12-06T14:31:59.359Z
8672379 8672379 20251201142223_UtmPb NZ002K 2025-12-03T14:15:29.604Z 2025-12-06T14:31:53.569Z
8672373 8672373 20251201142135_83zCM NZ002K 2025-12-03T14:15:28.380Z 2025-12-06T14:31:53.373Z
8672320 8672320 20251201141635_5bNcF NZ002K 2025-12-03T14:15:17.663Z 2025-12-06T14:31:51.819Z
8672300 8672300 20251201141151_AvPBi NZ002K 2025-12-03T14:15:15.354Z 2025-12-06T14:31:51.266Z
8672282 8672282 20251201140932_WvoE0 NZ002K 2025-12-03T14:15:12.722Z 2025-12-06T14:31:50.598Z
8672261 8672261 20251201140821_jskXJ NZ002K 2025-12-03T14:15:11.440Z 2025-12-06T14:31:50.111Z
8672255 8672255 20251201140821_Syjkh NZ002K 2025-12-03T14:15:11.113Z 2025-12-06T14:31:50.041Z
8672209 8672209 20251201140249_oV1rZ NZ002K 2025-12-03T14:15:00.778Z 2025-12-06T14:31:48.750Z
8672107 8672107 20251201135325_smPHM NZ002K 2025-12-03T14:14:42.865Z 2025-12-06T14:31:45.403Z
8672029 8672029 20251201134105_VbOL7 NZ002K 2025-12-03T14:14:32.686Z 2025-12-06T14:31:41.904Z
8671822 8671822 20251201130321_I1cNm NZ002K 2025-12-03T14:13:53.211Z 2025-12-06T14:31:21.079Z
8671755 8671755 20251201125531_YJRyR NZ002K 2025-12-03T14:13:38.793Z 2025-12-06T14:31:18.602Z
8671658 8671658 20251201124636_oJi2a NZ002K 2025-12-03T14:13:16.206Z 2025-12-06T14:31:14.990Z
8671439 8671439 20251201121931_tUXTn NZ002K 2025-12-03T14:12:31.211Z 2025-12-06T14:31:06.768Z
8671382 8671382 20251201121148_F7Pmn NZ002K 2025-12-03T14:12:18.882Z 2025-12-06T14:30:57.454Z
8671349 8671349 20251201120527_qJvp1 NZ002K 2025-12-03T14:12:14.339Z 2025-12-06T14:30:56.454Z
8671294 8671294 20251201115315_b2ImH NZ002K 2025-12-03T14:12:05.122Z 2025-12-06T14:30:51.154Z
8671174 8671174 20251201113208_SX1Kx NZ002K 2025-12-03T14:11:40.459Z 2025-12-06T14:30:46.345Z
8671075 8671075 20251201111048_73gR6 NZ002K 2025-12-03T14:11:13.220Z 2025-12-06T14:30:42.641Z
8671054 8671054 20251201110839_eWl5M NZ002K 2025-12-03T14:11:10.701Z 2025-12-06T14:30:41.554Z
8671049 8671049 20251201110808_33uOB NZ002K 2025-12-03T14:11:10.202Z 2025-12-06T14:30:41.384Z
8670928 8670928 20251201104659_KaR31 NZ002K 2025-12-03T14:10:45.021Z 2025-12-06T14:30:36.828Z
8670907 8670907 20251201104454_Q0E6l NZ002K 2025-12-03T14:10:41.264Z 2025-12-06T14:30:34.316Z
8670872 8670872 20251201103546_kUieF NZ002K 2025-12-03T14:10:36.639Z 2025-12-06T14:30:28.379Z
8670863 8670863 20251201103531_IXByK NZ002K 2025-12-03T14:10:36.166Z 2025-12-06T14:30:28.310Z
8670759 8670759 20251201100835_Q39Gb NZ002K 2025-12-03T14:10:01.480Z 2025-12-06T14:30:20.930Z
8670649 8670649 20251201095152_vV4jI NZ002K 2025-12-03T14:09:38.978Z 2025-12-06T14:30:14.048Z
8670577 8670577 20251201093201_7Zvtw NZ002K 2025-12-03T14:09:23.054Z 2025-12-06T14:30:10.159Z
8661066 8661066 20251130143820_SCxVm NZ002K 2025-12-02T14:10:15.301Z 2025-12-06T14:37:36.729Z
8661039 8661039 20251130142901_6nv38 NZ002K 2025-12-02T14:10:10.281Z 2025-12-06T14:37:35.970Z
8660844 8660844 20251130140149_7r3XE NZ002K 2025-12-02T14:09:28.261Z 2025-12-06T14:37:27.644Z
8660801 8660801 20251130135309_nVUP4 NZ002K 2025-12-02T14:09:13.141Z 2025-12-06T14:37:26.193Z
8660786 8660786 20251130135224_ZfAzl NZ002K 2025-12-02T14:09:11.186Z 2025-12-06T14:37:25.997Z
8642300 8642300 20251128154900_AlqRt NZ002K 2025-11-30T14:17:45.624Z 2025-12-06T14:53:29.965Z
8642247 8642247 20251128154405_xn3Ta NZ002K 2025-11-30T14:17:42.690Z 2025-12-06T14:53:26.648Z
8641847 8641847 20251128151652_NPk2C NZ002K 2025-11-30T14:17:04.967Z 2025-12-06T14:52:58.707Z
8641747 8641747 20251128151129_lFAkx NZ002K 2025-11-30T14:16:46.478Z 2025-12-06T14:52:49.167Z
8641706 8641706 20251128150848_u2Np5 NZ002K 2025-11-30T14:16:43.704Z 2025-12-06T14:52:45.331Z
8641691 8641691 20251128150708_V6SLY NZ002K 2025-11-30T14:16:42.923Z 2025-12-06T14:52:45.230Z
8641578 8641578 20251128145935_OPl7b NZ002K 2025-11-30T14:16:33.406Z 2025-12-06T14:52:39.208Z
8640517 8640517 20251129144103_3A1qo NZ002K 2025-11-30T14:08:37.000Z 2025-12-06T14:44:37.138Z
8639751 8639751 20251129115415_KYlJj NZ002K 2025-11-30T14:05:57.589Z 2025-12-06T14:43:49.837Z
8639617 8639617 20251129113144_qBA2K NZ002K 2025-11-30T14:05:36.183Z 2025-11-30T14:05:36.183Z
8639550 8639550 20251129111903_nmwZT NZ002K 2025-11-30T14:05:16.964Z 2025-12-06T14:43:44.421Z
8639494 8639494 20251129111254_3X8YR NZ002K 2025-11-30T14:05:08.780Z 2025-12-06T14:43:42.874Z
8639456 8639456 20251129110817_3TMZg NZ002K 2025-11-30T14:05:03.691Z 2025-12-06T14:43:42.371Z
8639450 8639450 20251129110753_Zg6Wa NZ002K 2025-11-30T14:04:58.823Z 2025-12-06T14:43:41.916Z
8639128 8639128 20251129103158_asnHE NZ002K 2025-11-30T14:03:49.208Z 2025-12-06T14:43:32.967Z
8629620 8629620 20251128142502_sVVWu NZ002K 2025-11-29T14:08:47.372Z 2025-12-06T14:52:30.624Z
8629546 8629546 20251128141805_u25Sd NZ002K 2025-11-29T14:08:36.706Z 2025-12-06T14:52:29.374Z
8629510 8629510 20251128141257_PEgiN NZ002K 2025-11-29T14:08:30.257Z 2025-12-06T14:52:28.779Z
8629459 8629459 20251128140916_ed9HC NZ002K 2025-11-29T14:08:24.898Z 2025-12-06T14:52:27.903Z
8629367 8629367 20251128140149_9Nv5p NZ002K 2025-11-29T14:08:18.644Z 2025-12-06T14:52:26.669Z

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