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

2,381 rows where station_code = "NZ005M" 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
9265385 9265385 20260127151030_lytAS NZ005M 2026-01-28T14:10:00.969Z 2026-01-29T14:30:24.538Z
9265347 9265347 20260127150345_KMb2l NZ005M 2026-01-28T14:09:53.429Z 2026-01-29T14:30:24.531Z
9265078 9265078 20260127141356_1aTTA NZ005M 2026-01-28T14:08:57.097Z 2026-01-29T14:30:24.432Z
9264928 9264928 20260127133830_71REb NZ005M 2026-01-28T14:08:18.172Z 2026-01-29T14:30:24.394Z
9264887 9264887 20260127132915_cOKMT NZ005M 2026-01-28T14:08:07.024Z 2026-01-29T14:30:24.320Z
9264857 9264857 20260127132454_8WaNf NZ005M 2026-01-28T14:08:00.107Z 2026-01-29T14:30:24.314Z
9264567 9264567 20260127124718_3DaOk NZ005M 2026-01-28T14:06:42.353Z 2026-01-29T14:30:24.220Z
9264535 9264535 20260127124347_FtSNz NZ005M 2026-01-28T14:06:36.070Z 2026-01-29T14:30:24.197Z
9264406 9264406 20260127121509_CovEr NZ005M 2026-01-28T14:05:56.730Z 2026-01-29T14:30:21.197Z
9264333 9264333 20260127120132_JZjow NZ005M 2026-01-28T14:05:32.806Z 2026-01-29T14:30:20.856Z
9264028 9264028 20260127105938_Vv3h1 NZ005M 2026-01-28T14:04:00.262Z 2026-01-29T14:30:20.006Z
9263984 9263984 20260127104911_ox5gS NZ005M 2026-01-28T14:03:46.165Z 2026-01-29T14:30:19.984Z
9263926 9263926 20260127104348_gXe72 NZ005M 2026-01-28T14:03:33.434Z 2026-01-29T14:30:19.971Z
9263901 9263901 20260127103840_9dZrt NZ005M 2026-01-28T14:03:27.944Z 2026-01-29T14:30:19.958Z
9263746 9263746 20260127100327_JfgXd NZ005M 2026-01-28T14:02:34.631Z 2026-01-29T14:30:18.924Z
9263741 9263741 20260127100239_rwJOm NZ005M 2026-01-28T14:02:33.422Z 2026-01-29T14:30:18.923Z
9233489 9233489 20260120160042_28aBC NZ005M 2026-01-21T14:05:57.659Z 2026-01-29T15:01:23.666Z
9233478 9233478 20260120155628_CO9dM NZ005M 2026-01-21T14:05:53.746Z 2026-01-29T15:01:23.041Z
9233470 9233470 20260120154236_tEiwI NZ005M 2026-01-21T14:05:52.050Z 2026-01-29T15:01:20.664Z
9233461 9233461 20260120154221_g3qhA NZ005M 2026-01-21T14:05:51.434Z 2026-01-29T15:01:20.562Z
9233238 9233238 20260120135038_nLGmA NZ005M 2026-01-21T14:04:55.359Z 2026-01-29T15:00:51.086Z
9233193 9233193 20260120133526_6xtlI NZ005M 2026-01-21T14:04:49.413Z 2026-01-29T15:00:48.754Z
9233092 9233092 20260120131953_sA7pu NZ005M 2026-01-21T14:04:29.516Z 2026-01-29T15:00:44.941Z
9232998 9232998 20260120130345_AEN26 NZ005M 2026-01-21T14:04:11.227Z 2026-01-29T15:00:34.575Z
9232709 9232709 20260120121202_tgp8Q NZ005M 2026-01-21T14:02:56.180Z 2026-01-29T14:59:59.537Z
9231915 9231915 20260119101452_jX3c7 NZ005M 2026-01-20T14:34:46.673Z 2026-01-27T15:07:05.598Z
9227369 9227369 20260119155701_StBf6 NZ005M 2026-01-20T14:07:58.172Z 2026-01-28T14:56:17.088Z
9227363 9227363 20260119155607_TnfXr NZ005M 2026-01-20T14:07:56.735Z 2026-01-28T14:56:16.448Z
9227242 9227242 20260119151615_ubGUg NZ005M 2026-01-20T14:07:18.234Z 2026-01-28T14:56:00.581Z
9227117 9227117 20260119143743_l1CBd NZ005M 2026-01-20T14:06:39.862Z 2026-01-28T14:55:52.156Z
9227105 9227105 20260119143730_whkcd NZ005M 2026-01-20T14:06:38.386Z 2026-01-28T14:55:51.788Z
9227061 9227061 20260119141838_85xwr NZ005M 2026-01-20T14:06:22.904Z 2026-01-28T14:55:49.502Z
9226875 9226875 20260119132123_BysQX NZ005M 2026-01-20T14:05:28.808Z 2026-01-28T14:55:33.180Z
9226863 9226863 20260119132059_7JkGL NZ005M 2026-01-20T14:05:26.490Z 2026-01-28T14:55:32.890Z
9226554 9226554 20260119121907_qRxHt NZ005M 2026-01-20T14:03:52.332Z 2026-01-28T14:55:14.093Z
9226462 9226462 20260119120624_2Mduc NZ005M 2026-01-20T14:03:23.445Z 2026-01-28T14:55:02.936Z
9226257 9226257 20260119113505_2TS6n NZ005M 2026-01-20T14:02:04.982Z 2026-01-28T14:54:50.930Z
9226243 9226243 20260119113247_t6k2d NZ005M 2026-01-20T14:02:01.041Z 2026-01-28T14:54:50.062Z
9225725 9225725 20260118104530_m4GSF NZ005M 2026-01-19T14:30:00.081Z 2026-01-26T15:04:42.978Z
9225681 9225681 20260118104005_fWG5a NZ005M 2026-01-19T14:29:47.623Z 2026-01-26T15:04:41.656Z
9225460 9225460 20260118095405_0QD0Q NZ005M 2026-01-19T14:29:01.915Z 2026-01-26T15:04:35.066Z
9225454 9225454 20260118094724_rhjj0 NZ005M 2026-01-19T14:28:59.994Z 2026-01-26T15:04:34.771Z
9225400 9225400 20260118093937_Jp3Tp NZ005M 2026-01-19T14:28:53.465Z 2026-01-26T15:04:33.372Z
9221549 9221549 20260118155646_j1DMo NZ005M 2026-01-19T14:08:19.673Z 2026-01-27T15:00:31.353Z
9221226 9221226 20260118150640_DZjgf NZ005M 2026-01-19T14:07:08.115Z 2026-01-27T14:59:57.884Z
9221202 9221202 20260118150134_0UFPy NZ005M 2026-01-19T14:07:02.666Z 2026-01-27T14:59:56.798Z
9221082 9221082 20260118144858_alL1u NZ005M 2026-01-19T14:06:43.800Z 2026-01-27T14:59:52.751Z
9221069 9221069 20260118144520_Agr0W NZ005M 2026-01-19T14:06:42.576Z 2026-01-27T14:59:52.520Z
9221043 9221043 20260118144507_3uG6j NZ005M 2026-01-19T14:06:40.215Z 2026-01-27T14:59:52.047Z
9221010 9221010 20260118144231_yEGKz NZ005M 2026-01-19T14:06:27.073Z 2026-01-27T14:59:50.518Z
9220959 9220959 20260118142353_ST4M2 NZ005M 2026-01-19T14:06:16.539Z 2026-01-27T14:59:47.955Z
9220869 9220869 20260118140702_M3vsu NZ005M 2026-01-19T14:05:53.588Z 2026-01-27T14:59:32.915Z
9220707 9220707 20260118133035_wEb9V NZ005M 2026-01-19T14:05:16.455Z 2026-01-27T14:59:25.291Z
9220648 9220648 20260118131827_4MXXo NZ005M 2026-01-19T14:05:05.565Z 2026-01-27T14:59:23.808Z
9220392 9220392 20260118124502_W0MJt NZ005M 2026-01-19T14:04:00.722Z 2026-01-27T14:59:13.650Z
9220321 9220321 20260118123833_ULw2s NZ005M 2026-01-19T14:03:47.557Z 2026-01-27T14:59:01.667Z
9220047 9220047 20260118115715_Rst3a NZ005M 2026-01-19T14:02:20.394Z 2026-01-27T14:58:47.255Z
9219849 9219849 20260118113038_rIcEz NZ005M 2026-01-19T14:01:13.697Z 2026-01-27T14:58:36.134Z
9219238 9219238 20260117093642_PPuLk NZ005M 2026-01-18T14:15:34.560Z 2026-01-25T14:59:08.032Z
9193518 9193518 20260113154658_v2JPk NZ005M 2026-01-14T14:01:57.164Z 2026-01-22T15:06:23.753Z
9193096 9193096 20260112133612_al02H NZ005M 2026-01-13T14:30:09.255Z 2026-01-20T15:26:59.214Z
9193033 9193033 20260112132829_x5R08 NZ005M 2026-01-13T14:30:01.473Z 2026-01-20T15:26:56.920Z
9192759 9192759 20260112125745_86enP NZ005M 2026-01-13T14:29:11.145Z 2026-01-20T15:26:32.060Z
9192729 9192729 20260112125603_pug01 NZ005M 2026-01-13T14:29:06.935Z 2026-01-20T15:26:31.091Z
9192697 9192697 20260112125342_c1td8 NZ005M 2026-01-13T14:29:03.659Z 2026-01-20T15:26:30.224Z
9192688 9192688 20260112125337_rpiof NZ005M 2026-01-13T14:29:03.171Z 2026-01-20T15:26:30.076Z
9192567 9192567 20260112124442_qi0L9 NZ005M 2026-01-13T14:28:41.684Z 2026-01-20T15:26:25.876Z
9192528 9192528 20260112124015_o9ySu NZ005M 2026-01-13T14:28:34.285Z 2026-01-20T15:26:24.551Z
9192465 9192465 20260112123656_oMdZH NZ005M 2026-01-13T14:28:26.192Z 2026-01-20T15:26:22.786Z
9192102 9192102 20260112120533_W5rLD NZ005M 2026-01-13T14:27:26.608Z 2026-01-20T15:25:59.193Z
9192085 9192085 20260112120436_a4xBZ NZ005M 2026-01-13T14:27:23.631Z 2026-01-20T15:25:58.467Z
9191848 9191848 20260112114702_pRfFj NZ005M 2026-01-13T14:26:40.203Z 2026-01-20T15:25:48.578Z
9191321 9191321 20260112105741_rrcXH NZ005M 2026-01-13T14:25:03.052Z 2026-01-20T15:25:20.206Z
9191302 9191302 20260112105655_BwL2c NZ005M 2026-01-13T14:25:01.266Z 2026-01-20T15:25:18.521Z
9191297 9191297 20260112105628_3V3K8 NZ005M 2026-01-13T14:25:00.782Z 2026-01-20T15:25:18.399Z
9191259 9191259 20260112104953_34IMx NZ005M 2026-01-13T14:24:53.854Z 2026-01-20T15:25:16.215Z
9191167 9191167 20260112104151_F4NYD NZ005M 2026-01-13T14:24:35.968Z 2026-01-20T15:25:12.792Z
9191127 9191127 20260112103540_4a79a NZ005M 2026-01-13T14:24:30.494Z 2026-01-20T15:25:11.328Z
9191105 9191105 20260112103302_QwQf0 NZ005M 2026-01-13T14:24:26.466Z 2026-01-20T15:25:10.153Z
9191041 9191041 20260112102838_CQjgm NZ005M 2026-01-13T14:24:14.288Z 2026-01-20T15:25:07.865Z
9190943 9190943 20260112101701_C8IzK NZ005M 2026-01-13T14:23:57.884Z 2026-01-20T15:25:04.513Z
9190833 9190833 20260112100353_BSJBX NZ005M 2026-01-13T14:23:35.053Z 2026-01-20T15:24:51.116Z
9190813 9190813 20260112100140_YgYyQ NZ005M 2026-01-13T14:23:32.551Z 2026-01-20T15:24:50.362Z
9186860 9186860 20260112155148_k8rVY NZ005M 2026-01-13T14:03:44.907Z 2026-01-21T15:03:04.559Z
9186757 9186757 20260112153234_q9JYN NZ005M 2026-01-13T14:03:22.446Z 2026-01-21T15:02:56.636Z
9186719 9186719 20260112152644_UVnuw NZ005M 2026-01-13T14:03:13.779Z 2026-01-21T15:02:55.435Z
9186624 9186624 20260112151056_zKhzs NZ005M 2026-01-13T14:02:45.513Z 2026-01-21T15:02:48.486Z
9186594 9186594 20260112150059_gUaIW NZ005M 2026-01-13T14:02:39.252Z 2026-01-21T15:02:45.324Z
9186583 9186583 20260112145934_siH5c NZ005M 2026-01-13T14:02:37.618Z 2026-01-21T15:02:44.725Z
9186521 9186521 20260112144935_jOJhC NZ005M 2026-01-13T14:02:20.539Z 2026-01-21T15:02:41.005Z
9186516 9186516 20260112144910_12MYj NZ005M 2026-01-13T14:02:19.539Z 2026-01-21T15:02:40.325Z
9186289 9186289 20260112140934_3D9kB NZ005M 2026-01-13T14:01:13.565Z 2026-01-21T15:02:17.517Z
9186227 9186227 20260112140019_K2Rm2 NZ005M 2026-01-13T14:00:53.684Z 2026-01-21T15:02:13.419Z
9186197 9186197 20260112135835_blAad NZ005M 2026-01-13T14:00:46.535Z 2026-01-21T15:02:12.976Z
9186121 9186121 20260112135119_P8xU4 NZ005M 2026-01-13T14:00:22.810Z 2026-01-21T15:02:12.203Z
9185372 9185372 20260111140945_OYvqN NZ005M 2026-01-12T14:23:08.784Z 2026-01-19T15:22:27.558Z
9185286 9185286 20260111134823_QcXGQ NZ005M 2026-01-12T14:22:57.457Z 2026-01-19T15:22:03.560Z
9185278 9185278 20260111134650_A4cSg NZ005M 2026-01-12T14:22:56.594Z 2026-01-19T15:22:02.320Z
9185233 9185233 20260111133331_krGpo NZ005M 2026-01-12T14:22:50.418Z 2026-01-19T15:21:59.580Z
9185149 9185149 20260111131142_dd692 NZ005M 2026-01-12T14:22:34.982Z 2026-01-19T15:21:52.297Z

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