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 = "NZ003H" 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
9270455 9270455 20260128155301_B3Tm2 NZ003H 2026-01-29T14:12:20.062Z 2026-01-29T14:12:20.062Z
9270445 9270445 20260128155000_p1xgq NZ003H 2026-01-29T14:12:17.747Z 2026-01-29T14:12:17.747Z
9270436 9270436 20260128154914_303Gp NZ003H 2026-01-29T14:12:15.862Z 2026-01-29T14:12:15.862Z
9270362 9270362 20260128153905_Bntg8 NZ003H 2026-01-29T14:11:53.306Z 2026-01-29T14:11:53.306Z
9270341 9270341 20260128153354_got3W NZ003H 2026-01-29T14:11:49.152Z 2026-01-29T14:11:49.152Z
9270321 9270321 20260128153109_7Ht6q NZ003H 2026-01-29T14:11:45.333Z 2026-01-29T14:11:45.333Z
9270290 9270290 20260128152803_CSDOt NZ003H 2026-01-29T14:11:39.245Z 2026-01-29T14:11:39.245Z
9270220 9270220 20260128151739_PX98F NZ003H 2026-01-29T14:11:20.901Z 2026-01-29T14:11:20.901Z
9270172 9270172 20260128150547_zw4vW NZ003H 2026-01-29T14:11:10.922Z 2026-01-29T14:11:10.922Z
9270150 9270150 20260128150236_ogKps NZ003H 2026-01-29T14:11:06.801Z 2026-01-29T14:11:06.801Z
9270036 9270036 20260128145019_OISQU NZ003H 2026-01-29T14:10:42.259Z 2026-01-29T14:10:42.259Z
9269885 9269885 20260128142858_tNcju NZ003H 2026-01-29T14:10:05.382Z 2026-01-29T14:10:05.382Z
9269818 9269818 20260128141730_CFpgr NZ003H 2026-01-29T14:09:44.507Z 2026-01-29T14:09:44.507Z
9269759 9269759 20260128140907_d6SDl NZ003H 2026-01-29T14:09:31.418Z 2026-01-29T14:09:31.418Z
9269693 9269693 20260128135503_73CHQ NZ003H 2026-01-29T14:09:05.573Z 2026-01-29T14:09:05.573Z
9269684 9269684 20260128135451_eRfj7 NZ003H 2026-01-29T14:09:04.026Z 2026-01-29T14:09:04.026Z
9269251 9269251 20260128125025_Qtvvf NZ003H 2026-01-29T14:07:06.260Z 2026-01-29T14:07:06.260Z
9268699 9268699 20260128110432_27TBP NZ003H 2026-01-29T14:04:24.656Z 2026-01-29T14:04:24.656Z
9268664 9268664 20260128110008_tCrC2 NZ003H 2026-01-29T14:04:16.544Z 2026-01-29T14:04:16.544Z
9268518 9268518 20260128104051_ePKU4 NZ003H 2026-01-29T14:03:28.394Z 2026-01-29T14:03:28.394Z
9268267 9268267 20260128093517_SyuZB NZ003H 2026-01-29T14:02:08.551Z 2026-01-29T14:02:08.551Z
9268103 9268103 20260128084955_C7h6F NZ003H 2026-01-29T14:01:06.984Z 2026-01-29T14:01:06.984Z
9268078 9268078 20260128084338_YGIgB NZ003H 2026-01-29T14:00:56.490Z 2026-01-29T14:00:56.490Z
9265805 9265805 20260127160126_G2zJK NZ003H 2026-01-28T14:11:23.888Z 2026-01-29T14:30:24.679Z
9265799 9265799 20260127160124_WdIX4 NZ003H 2026-01-28T14:11:22.558Z 2026-01-29T14:30:24.678Z
9264061 9264061 20260127110717_7uTA3 NZ003H 2026-01-28T14:04:10.889Z 2026-01-29T14:30:20.033Z
9257830 9257830 20260125160513_jwV1D NZ003H 2026-01-26T14:07:58.152Z 2026-01-29T14:37:43.710Z
9257751 9257751 20260125154813_XJVUb NZ003H 2026-01-26T14:07:36.131Z 2026-01-29T14:37:37.845Z
9257693 9257693 20260125152740_qDZ28 NZ003H 2026-01-26T14:07:18.644Z 2026-01-29T14:37:35.454Z
9257524 9257524 20260125141829_CtWQl NZ003H 2026-01-26T14:06:06.137Z 2026-01-29T14:37:25.579Z
9256870 9256870 20260125105131_GEFsg NZ003H 2026-01-26T14:02:24.773Z 2026-01-29T14:36:32.852Z
8689782 8689782 20251204084411_8IC1K NZ003H 2025-12-06T14:10:11.674Z 2025-12-13T16:02:58.595Z
8684895 8684895 20251204142803_43T8i NZ003H 2025-12-05T14:04:54.740Z 2025-12-13T16:03:26.491Z
8684100 8684100 20251204104254_0R64V NZ003H 2025-12-05T14:01:56.153Z 2025-12-13T16:03:15.146Z
8684056 8684056 20251204103034_R4UHB NZ003H 2025-12-05T14:01:39.420Z 2025-12-13T16:03:14.444Z
8684051 8684051 20251204103012_f2juJ NZ003H 2025-12-05T14:01:38.985Z 2025-12-13T16:03:14.369Z
8683912 8683912 20251204092032_3b3es NZ003H 2025-12-05T14:01:03.500Z 2025-12-13T16:03:06.898Z
8683904 8683904 20251204091947_pF3FT NZ003H 2025-12-05T14:01:02.424Z 2025-12-13T16:03:06.392Z
8683891 8683891 20251204091703_w36Aq NZ003H 2025-12-05T14:01:00.830Z 2025-12-13T16:03:04.659Z
8683865 8683865 20251204090711_Aunmq NZ003H 2025-12-05T14:00:55.799Z 2025-12-13T16:03:00.889Z
8683808 8683808 20251204083354_a3a2E NZ003H 2025-12-05T14:00:44.760Z 2025-12-13T16:02:58.343Z
8678128 8678128 20251203150042_FBiGI NZ003H 2025-12-04T14:03:36.244Z 2025-12-11T14:40:32.271Z
8672816 8672816 20251201152516_m311B NZ003H 2025-12-03T14:16:37.399Z 2025-12-10T14:38:07.332Z
8672771 8672771 20251201151704_2dx8p NZ003H 2025-12-03T14:16:24.876Z 2025-12-10T14:38:06.638Z
8672760 8672760 20251201151526_tQzbS NZ003H 2025-12-03T14:16:23.606Z 2025-12-10T14:38:06.516Z
8672723 8672723 20251201151051_YxAXP NZ003H 2025-12-03T14:16:19.511Z 2025-12-10T14:38:00.252Z
8672716 8672716 20251201151015_zFNTP NZ003H 2025-12-03T14:16:19.013Z 2025-12-10T14:37:59.774Z
8672675 8672675 20251201150507_xJNEb NZ003H 2025-12-03T14:16:08.818Z 2025-12-10T14:37:58.805Z
8672629 8672629 20251201145540_K58DD NZ003H 2025-12-03T14:16:01.187Z 2025-12-10T14:37:58.064Z
8672603 8672603 20251201145404_IWE3U NZ003H 2025-12-03T14:15:58.847Z 2025-12-10T14:37:57.820Z
8672592 8672592 20251201145054_smS3v NZ003H 2025-12-03T14:15:57.453Z 2025-12-10T14:37:57.534Z
8672529 8672529 20251201144153_G7aZn NZ003H 2025-12-03T14:15:50.446Z 2025-12-10T14:37:56.437Z
8672511 8672511 20251201143927_gGt7f NZ003H 2025-12-03T14:15:49.335Z 2025-12-10T14:37:56.026Z
8672304 8672304 20251201141151_AvPBi NZ003H 2025-12-03T14:15:15.354Z 2025-12-10T14:37:46.643Z
8672256 8672256 20251201140821_Syjkh NZ003H 2025-12-03T14:15:11.113Z 2025-12-10T14:37:46.131Z
8672211 8672211 20251201140249_oV1rZ NZ003H 2025-12-03T14:15:00.778Z 2025-12-10T14:37:45.386Z
8671573 8671573 20251201123534_nSFrV NZ003H 2025-12-03T14:13:02.375Z 2025-12-10T14:37:15.945Z
8670988 8670988 20251201105900_G078k NZ003H 2025-12-03T14:11:00.321Z 2025-12-10T14:37:04.918Z
8670762 8670762 20251201100835_Q39Gb NZ003H 2025-12-03T14:10:01.480Z 2025-12-10T14:36:45.304Z
8670492 8670492 20251201090904_P0Ogq NZ003H 2025-12-03T14:09:00.678Z 2025-12-10T14:36:38.081Z
8641877 8641877 20251128151752_MNdoE NZ003H 2025-11-30T14:17:06.372Z 2025-12-07T14:55:00.916Z
8641828 8641828 20251128151551_RSBU6 NZ003H 2025-11-30T14:17:02.987Z 2025-12-07T14:55:00.206Z
8641724 8641724 20251128151006_27fev NZ003H 2025-11-30T14:16:44.945Z 2025-12-07T14:54:58.791Z
8641662 8641662 20251128150531_TPT20 NZ003H 2025-11-30T14:16:38.469Z 2025-12-07T14:54:58.246Z
8641510 8641510 20251128145720_Ihqcx NZ003H 2025-11-30T14:16:29.655Z 2025-12-07T14:54:56.341Z
8639533 8639533 20251129111651_eCtAv NZ003H 2025-11-30T14:05:14.190Z 2025-12-08T14:50:32.572Z
8639424 8639424 20251129110456_NG30x NZ003H 2025-11-30T14:04:52.462Z 2025-11-30T14:04:52.462Z
8629849 8629849 20251128144112_2jWj8 NZ003H 2025-11-29T14:09:13.316Z 2025-12-07T14:54:31.939Z
8629841 8629841 20251128144058_Fdm1f NZ003H 2025-11-29T14:09:09.370Z 2025-12-07T14:54:31.872Z
8629834 8629834 20251128144044_GgSlZ NZ003H 2025-11-29T14:09:05.115Z 2025-12-07T14:54:31.803Z
8629782 8629782 20251128143809_49KCf NZ003H 2025-11-29T14:09:00.483Z 2025-12-07T14:54:31.080Z
8629771 8629771 20251128143743_SMEgB NZ003H 2025-11-29T14:08:59.992Z 2025-12-07T14:54:30.961Z
8629679 8629679 20251128142806_wGBvW NZ003H 2025-11-29T14:08:52.432Z 2025-12-07T14:54:28.825Z
8629651 8629651 20251128142716_Lb3Sh NZ003H 2025-11-29T14:08:50.444Z 2025-12-07T14:54:28.564Z
8629587 8629587 20251128142018_qGtmU NZ003H 2025-11-29T14:08:43.752Z 2025-12-07T14:54:24.861Z
8629535 8629535 20251128141755_dP6tg NZ003H 2025-11-29T14:08:32.003Z 2025-12-07T14:54:24.144Z
8629501 8629501 20251128141153_6Ktbc NZ003H 2025-11-29T14:08:29.742Z 2025-12-07T14:54:23.190Z
8629347 8629347 20251128140045_fWlNw NZ003H 2025-11-29T14:08:17.918Z 2025-12-07T14:54:20.178Z
8629199 8629199 20251128134901_tFmZB NZ003H 2025-11-29T14:08:06.578Z 2025-12-07T14:54:18.138Z
8629100 8629100 20251128134345_whjxe NZ003H 2025-11-29T14:07:51.082Z 2025-12-07T14:54:16.058Z
8629059 8629059 20251128134128_QI5VY NZ003H 2025-11-29T14:07:46.035Z 2025-12-07T14:54:15.484Z
8629011 8629011 20251128133453_G1aDv NZ003H 2025-11-29T14:07:41.404Z 2025-12-07T14:54:14.912Z
8628965 8628965 20251128133135_Eejce NZ003H 2025-11-29T14:07:38.172Z 2025-12-07T14:54:14.252Z
8628857 8628857 20251128131438_9IJZ1 NZ003H 2025-11-29T14:07:14.499Z 2025-12-07T14:54:10.758Z
8628716 8628716 20251128130602_6D5ZU NZ003H 2025-11-29T14:06:59.767Z 2025-12-07T14:53:48.902Z
8628685 8628685 20251128130526_iemvs NZ003H 2025-11-29T14:06:57.457Z 2025-11-29T14:06:57.457Z
8628634 8628634 20251128130123_ntUyU NZ003H 2025-11-29T14:06:52.941Z 2025-12-07T14:53:47.685Z
8628602 8628602 20251128125926_iwjG5 NZ003H 2025-11-29T14:06:50.351Z 2025-12-07T14:53:47.009Z
8628522 8628522 20251128125332_9Dt2n NZ003H 2025-11-29T14:06:29.474Z 2025-12-07T14:53:42.786Z
8628287 8628287 20251128123250_tSBlO NZ003H 2025-11-29T14:05:49.533Z 2025-12-07T14:53:37.831Z
8628122 8628122 20251128121531_tzCZ3 NZ003H 2025-11-29T14:05:31.118Z 2025-12-07T14:53:34.782Z
8628025 8628025 20251128120834_QBAs2 NZ003H 2025-11-29T14:05:08.166Z 2025-12-07T14:53:32.880Z
8628011 8628011 20251128120449_aKfa9 NZ003H 2025-11-29T14:05:06.426Z 2025-12-07T14:53:32.353Z
8627986 8627986 20251128120121_6V8CK NZ003H 2025-11-29T14:05:02.770Z 2025-12-07T14:53:31.698Z
8627962 8627962 20251128115751_wYpb5 NZ003H 2025-11-29T14:05:01.123Z 2025-12-07T14:53:31.249Z
8627941 8627941 20251128115426_OKGj2 NZ003H 2025-11-29T14:04:58.004Z 2025-12-07T14:53:30.872Z
8627907 8627907 20251128115059_XGswY NZ003H 2025-11-29T14:04:52.986Z 2025-12-07T14:53:30.010Z
8627851 8627851 20251128114509_mI3Xp NZ003H 2025-11-29T14:04:37.328Z 2025-12-07T14:53:28.809Z
8627834 8627834 20251128114338_2qmRL NZ003H 2025-11-29T14:04:35.986Z 2025-12-07T14:53:28.528Z
8627817 8627817 20251128113919_7uHH3 NZ003H 2025-11-29T14:04:34.048Z 2025-12-07T14:53:28.096Z

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