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 = "HR000D" 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
9267767 9267767 20260127045031_ciVmh HR000D 2026-01-28T14:23:13.956Z 2026-01-29T14:35:41.215Z
9267431 9267431 20260127005550_KNL1n HR000D 2026-01-28T14:21:40.033Z 2026-01-29T14:35:00.240Z
9267413 9267413 20260127004135_3joc7 HR000D 2026-01-28T14:21:35.520Z 2026-01-29T14:34:58.590Z
9267406 9267406 20260127003151_Oqdy7 HR000D 2026-01-28T14:21:33.853Z 2026-01-29T14:34:57.910Z
9267373 9267373 20260127000807_w2nun HR000D 2026-01-28T14:21:22.095Z 2026-01-29T14:34:55.276Z
9252010 9252010 20260123002713_u7420 HR000D 2026-01-24T14:14:03.077Z 2026-01-29T14:52:23.811Z
9252001 9252001 20260123002703_97fEV HR000D 2026-01-24T14:13:58.570Z 2026-01-29T14:52:23.544Z
9248253 9248253 20260121223409_mUcu3 HR000D 2026-01-23T14:12:20.092Z 2026-01-29T14:57:10.313Z
9235496 9235496 20260120012351_xu87E HR000D 2026-01-21T14:19:06.228Z 2026-01-28T14:58:59.441Z
9235471 9235471 20260120011833_GEvM3 HR000D 2026-01-21T14:19:02.436Z 2026-01-28T14:58:57.050Z
9235431 9235431 20260120011234_szkFq HR000D 2026-01-21T14:18:53.006Z 2026-01-28T14:58:54.721Z
9235411 9235411 20260120010728_Kginx HR000D 2026-01-21T14:18:49.772Z 2026-01-28T14:58:53.722Z
9235287 9235287 20260120005051_t43iX HR000D 2026-01-21T14:18:23.177Z 2026-01-28T14:58:47.928Z
9235124 9235124 20260120003200_AjgWO HR000D 2026-01-21T14:17:40.506Z 2026-01-28T14:58:31.825Z
9235041 9235041 20260120001713_M2yZ5 HR000D 2026-01-21T14:17:16.023Z 2026-01-28T14:58:26.288Z
9234962 9234962 20260119235639_HJ0XM HR000D 2026-01-21T14:16:50.564Z 2026-01-28T14:58:22.551Z
9234919 9234919 20260119235154_vAgOL HR000D 2026-01-21T14:16:41.662Z 2026-01-28T14:58:20.933Z
9234721 9234721 20260119230636_Ciq3w HR000D 2026-01-21T14:15:53.512Z 2026-01-28T14:58:02.854Z
9234711 9234711 20260119230307_6iVKQ HR000D 2026-01-21T14:15:52.347Z 2026-01-28T14:58:02.303Z
9234687 9234687 20260119225645_3N3aH HR000D 2026-01-21T14:15:42.460Z 2026-01-28T14:58:00.020Z
9234627 9234627 20260119224110_5Ikp6 HR000D 2026-01-21T14:15:30.514Z 2026-01-28T14:57:57.422Z
9234596 9234596 20260119223447_s9V6m HR000D 2026-01-21T14:15:23.038Z 2026-01-28T14:57:55.932Z
9229301 9229301 20260119012636_0zdYA HR000D 2026-01-20T14:21:54.749Z 2026-01-27T15:03:16.353Z
9229269 9229269 20260119011522_OkzE0 HR000D 2026-01-20T14:21:46.115Z 2026-01-27T15:03:14.579Z
9229236 9229236 20260119011124_OPGl3 HR000D 2026-01-20T14:21:40.217Z 2026-01-27T15:03:13.275Z
9229116 9229116 20260119004934_JK3VM HR000D 2026-01-20T14:21:06.337Z 2026-01-27T15:02:55.487Z
9229110 9229110 20260119004934_NGPFl HR000D 2026-01-20T14:21:05.802Z 2026-01-27T15:02:55.365Z
9228962 9228962 20260119002521_3mQPo HR000D 2026-01-20T14:20:20.297Z 2026-01-27T15:02:45.387Z
9228950 9228950 20260119002430_6Buz1 HR000D 2026-01-20T14:20:17.403Z 2026-01-27T15:02:44.773Z
9228914 9228914 20260119001744_alvBU HR000D 2026-01-20T14:20:08.436Z 2026-01-27T15:02:42.728Z
9228560 9228560 20260118225402_TSpRA HR000D 2026-01-20T14:18:24.599Z 2026-01-27T15:02:07.891Z
9228351 9228351 20260118214805_R6Bm0 HR000D 2026-01-20T14:17:23.751Z 2026-01-27T15:01:55.566Z
9218196 9218196 20260117013951_Q8Zo4 HR000D 2026-01-18T14:10:58.058Z 2026-01-25T14:58:04.131Z
9218143 9218143 20260117010020_SvUpu HR000D 2026-01-18T14:10:41.730Z 2026-01-25T14:58:01.851Z
9218116 9218116 20260117001806_1nEwi HR000D 2026-01-18T14:10:33.276Z 2026-01-25T14:58:00.699Z
9218114 9218114 20260117001459_gVbwV HR000D 2026-01-18T14:10:32.554Z 2026-01-25T14:58:00.608Z
9189106 9189106 20260112030433_Su23P HR000D 2026-01-13T14:15:48.213Z 2026-01-20T15:22:39.618Z
9188763 9188763 20260112014125_Is4n4 HR000D 2026-01-13T14:14:07.998Z 2026-01-20T15:22:12.949Z
9188732 9188732 20260112013350_EyEgO HR000D 2026-01-13T14:13:57.675Z 2026-01-20T15:22:08.962Z
9188644 9188644 20260112010158_59b8y HR000D 2026-01-13T14:13:27.048Z 2026-01-20T15:22:03.497Z
9188624 9188624 20260112005931_4vdBA HR000D 2026-01-13T14:13:21.699Z 2026-01-20T15:22:02.495Z
9188620 9188620 20260112005920_lBrCM HR000D 2026-01-13T14:13:20.495Z 2026-01-20T15:22:02.285Z
9188586 9188586 20260112005019_dQKiU HR000D 2026-01-13T14:13:08.519Z 2026-01-20T15:22:00.692Z
9188487 9188487 20260112000203_gJdne HR000D 2026-01-13T14:12:34.765Z 2026-01-20T15:21:55.016Z
9188473 9188473 20260111235309_3jvnT HR000D 2026-01-13T14:12:29.783Z 2026-01-20T15:21:49.380Z
9188178 9188178 20260111211332_zYPyX HR000D 2026-01-13T14:10:52.726Z 2026-01-20T15:21:25.783Z
9188086 9188086 20260111201808_2Yk2m HR000D 2026-01-13T14:10:22.961Z 2026-01-20T15:21:11.939Z
9187739 9187739 20260111184127_P9YPk HR000D 2026-01-13T14:08:38.176Z 2026-01-20T15:20:43.552Z
9187648 9187648 20260111180708_7uyld HR000D 2026-01-13T14:08:14.123Z 2026-01-20T15:20:37.578Z
9187541 9187541 20260111174039_Ve3dV HR000D 2026-01-13T14:07:42.163Z 2026-01-20T15:20:32.595Z
9187535 9187535 20260111173918_ZSwdE HR000D 2026-01-13T14:07:40.477Z 2026-01-20T15:20:32.310Z
9181454 9181454 20260111014850_07yLK HR000D 2026-01-12T14:10:51.850Z 2026-01-19T15:17:20.223Z
9181382 9181382 20260111013515_3z3g2 HR000D 2026-01-12T14:10:36.257Z 2026-01-19T15:17:15.503Z
9181344 9181344 20260111012656_mdM3Y HR000D 2026-01-12T14:10:28.591Z 2026-01-19T15:17:13.709Z
9181324 9181324 20260111012131_ok6XJ HR000D 2026-01-12T14:10:22.323Z 2026-01-19T15:17:13.037Z
9181298 9181298 20260111011534_ms22v HR000D 2026-01-12T14:10:18.059Z 2026-01-19T15:17:11.830Z
9181279 9181279 20260111011317_3EXDE HR000D 2026-01-12T14:10:14.237Z 2026-01-19T15:17:10.881Z
9181256 9181256 20260111010902_QpIG1 HR000D 2026-01-12T14:10:08.503Z 2026-01-19T15:17:09.925Z
9181116 9181116 20260111002244_SWhxM HR000D 2026-01-12T14:09:37.210Z 2026-01-19T15:17:04.098Z
9180998 9180998 20260110234631_OnRJy HR000D 2026-01-12T14:09:10.937Z 2026-01-19T15:16:43.552Z
9180926 9180926 20260110232633_yPQ4r HR000D 2026-01-12T14:08:57.102Z 2026-01-19T15:16:39.211Z
9171524 9171524 20260108223839_wwRcE HR000D 2026-01-10T14:07:54.138Z 2026-01-17T15:24:05.224Z
9171522 9171522 20260108223713_x6Up9 HR000D 2026-01-10T14:07:53.213Z 2026-01-17T15:24:05.095Z
9171516 9171516 20260108223340_C3Sjw HR000D 2026-01-10T14:07:50.562Z 2026-01-17T15:24:04.771Z
9170872 9170872 20260108172646_WnmnQ HR000D 2026-01-10T14:03:49.647Z 2026-01-17T15:23:08.683Z
9170859 9170859 20260108172115_P3zwT HR000D 2026-01-10T14:03:44.611Z 2026-01-17T15:23:08.045Z
9115436 9115436 20251231050633_YHSvZ HR000D 2026-01-01T14:25:22.539Z 2026-01-08T15:10:47.613Z
9115187 9115187 20251231045157_SbU3n HR000D 2026-01-01T14:24:40.448Z 2026-01-08T15:10:31.239Z
9115180 9115180 20251231045141_074TH HR000D 2026-01-01T14:24:39.181Z 2026-01-01T14:57:54.029Z
9114988 9114988 20251231043907_Z7aAq HR000D 2026-01-01T14:24:04.298Z 2026-01-08T15:10:18.111Z
9114484 9114484 20251231041855_wHbho HR000D 2026-01-01T14:22:43.567Z 2026-01-08T15:09:50.808Z
9114445 9114445 20251231041735_Sd3af HR000D 2026-01-01T14:22:32.964Z 2026-01-08T15:09:48.640Z
9114443 9114443 20251231041735_P3YnR HR000D 2026-01-01T14:22:32.548Z 2026-01-08T15:09:48.486Z
9114423 9114423 20251231041556_akgFI HR000D 2026-01-01T14:22:27.416Z 2026-01-08T15:09:46.748Z
9114414 9114414 20251231041526_jz66f HR000D 2026-01-01T14:22:24.638Z 2026-01-08T15:09:45.702Z
9114216 9114216 20251231040709_CWHoG HR000D 2026-01-01T14:21:52.257Z 2026-01-08T15:09:36.494Z
9113829 9113829 20251231035028_iGbnI HR000D 2026-01-01T14:20:31.194Z 2026-01-08T15:09:11.461Z
9113622 9113622 20251231033951_dcyqd HR000D 2026-01-01T14:19:46.915Z 2026-01-08T15:08:54.288Z
9113563 9113563 20251231033643_SFTDm HR000D 2026-01-01T14:19:30.527Z 2026-01-08T15:08:50.031Z
9113305 9113305 20251231032210_cwZmn HR000D 2026-01-01T14:18:25.886Z 2026-01-08T15:08:38.716Z
9113287 9113287 20251231032052_312bH HR000D 2026-01-01T14:18:22.236Z 2026-01-08T15:08:38.175Z
9113233 9113233 20251231031728_Cr15p HR000D 2026-01-01T14:18:03.099Z 2026-01-08T15:08:35.807Z
9112953 9112953 20251231030201_ZS85p HR000D 2026-01-01T14:16:57.578Z 2026-01-08T15:08:15.492Z
9112911 9112911 20251231025903_DRxc7 HR000D 2026-01-01T14:16:45.343Z 2026-01-08T15:08:13.410Z
9112812 9112812 20251231025307_ZNNb9 HR000D 2026-01-01T14:16:24.217Z 2026-01-08T15:08:08.979Z
9112803 9112803 20251231025241_TlOvV HR000D 2026-01-01T14:16:22.871Z 2026-01-08T15:08:08.502Z
8283750 8283750 20251028035751_hDOqP HR000D 2025-10-29T12:45:06.941Z 2025-11-05T15:22:32.002Z
8050458 8050458 20251003003144_3ttdU HR000D 2025-10-04T12:41:30.279Z 2025-10-11T12:40:22.497Z
8050383 8050383 20251003000950_HvRhV HR000D 2025-10-04T12:41:11.146Z 2025-10-11T12:40:16.655Z
8050345 8050345 20251002235657_JngE8 HR000D 2025-10-04T12:41:04.462Z 2025-10-11T12:40:12.444Z
8050215 8050215 20251002232051_9zdIU HR000D 2025-10-04T12:40:41.195Z 2025-10-11T12:39:50.150Z
8042618 8042618 20251002032258_3jR54 HR000D 2025-10-03T12:38:37.792Z 2025-10-10T12:41:48.186Z
8042423 8042423 20251002030936_32pbY HR000D 2025-10-03T12:38:27.054Z 2025-10-03T12:38:27.054Z
8041920 8041920 20251002023319_AP0w2 HR000D 2025-10-03T12:37:25.478Z 2025-10-10T12:41:19.845Z
8041832 8041832 20251002022714_HIURj HR000D 2025-10-03T12:37:21.149Z 2025-10-10T12:41:16.761Z
8041667 8041667 20251002021721_CN1ys HR000D 2025-10-03T12:36:45.889Z 2025-10-10T12:41:12.707Z
8041543 8041543 20251002020934_T6Ewd HR000D 2025-10-03T12:36:32.127Z 2025-10-10T12:41:09.860Z
8040429 8040429 20251002004954_Ppd7d HR000D 2025-10-03T12:34:25.009Z 2025-10-10T12:40:26.588Z
8040378 8040378 20251002004413_ZqTvC HR000D 2025-10-03T12:34:14.578Z 2025-10-10T12:40:23.793Z
8040351 8040351 20251002004159_e7OEO HR000D 2025-10-03T12:34:12.961Z 2025-10-10T12:40:21.163Z

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