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 = "HU0003" 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
9237143 9237143 20260120044132_dPSpR HU0003 2026-01-21T14:25:21.998Z 2026-01-28T15:00:59.867Z
9237053 9237053 20260120043152_9fKT0 HU0003 2026-01-21T14:25:02.273Z 2026-01-28T15:00:55.785Z
9236842 9236842 20260120040537_3fKQp HU0003 2026-01-21T14:24:20.529Z 2026-01-28T15:00:38.679Z
9236623 9236623 20260120034133_MEh2u HU0003 2026-01-21T14:23:33.847Z 2026-01-28T15:00:25.498Z
9236525 9236525 20260120033050_HF2g4 HU0003 2026-01-21T14:23:03.915Z 2026-01-28T15:00:07.441Z
9236443 9236443 20260120031741_foAv5 HU0003 2026-01-21T14:22:50.582Z 2026-01-28T15:00:00.787Z
9236183 9236183 20260120024450_3Tkfj HU0003 2026-01-21T14:21:54.078Z 2026-01-28T14:59:48.961Z
9235984 9235984 20260120022505_LvJMm HU0003 2026-01-21T14:21:09.672Z 2026-01-28T14:59:31.533Z
9235547 9235547 20260120013311_MZPu2 HU0003 2026-01-21T14:19:23.189Z 2026-01-28T14:59:01.939Z
9235361 9235361 20260120010156_RyMM3 HU0003 2026-01-21T14:18:42.177Z 2026-01-28T14:58:51.138Z
9235216 9235216 20260120004352_Zl7Pq HU0003 2026-01-21T14:17:56.258Z 2026-01-28T14:58:44.023Z
9234825 9234825 20260119233344_IQsxW HU0003 2026-01-21T14:16:24.765Z 2026-01-28T14:58:15.740Z
9234532 9234532 20260119220917_M5WKz HU0003 2026-01-21T14:15:02.766Z 2026-01-28T14:57:52.565Z
9234487 9234487 20260119215042_zmbq9 HU0003 2026-01-21T14:14:44.210Z 2026-01-28T14:57:49.976Z
9234463 9234463 20260119213641_WW59U HU0003 2026-01-21T14:14:34.474Z 2026-01-28T14:57:48.127Z
9234447 9234447 20260119213209_32Ayw HU0003 2026-01-21T14:14:30.662Z 2026-01-28T14:57:46.882Z
9234358 9234358 20260119205922_wC3Iq HU0003 2026-01-21T14:13:57.907Z 2026-01-28T14:57:32.960Z
9233928 9233928 20260119184940_7kHye HU0003 2026-01-21T14:11:25.498Z 2026-01-28T14:56:53.370Z
9233852 9233852 20260119182046_BFVX7 HU0003 2026-01-21T14:10:53.789Z 2026-01-28T14:56:47.541Z
9233842 9233842 20260119181459_VoDBp HU0003 2026-01-21T14:10:50.497Z 2026-01-28T14:56:46.283Z
9233824 9233824 20260119180946_GHJ4h HU0003 2026-01-21T14:10:46.060Z 2026-01-28T14:56:44.137Z
9233722 9233722 20260119172051_JsISj HU0003 2026-01-21T14:10:08.101Z 2026-01-28T14:56:25.787Z
9233718 9233718 20260119171848_RmWay HU0003 2026-01-21T14:10:07.068Z 2026-01-28T14:56:25.159Z
9230767 9230767 20260119050303_Q8TWb HU0003 2026-01-20T14:29:40.302Z 2026-01-27T15:05:25.412Z
9230621 9230621 20260119044106_eWBuq HU0003 2026-01-20T14:28:56.604Z 2026-01-27T15:05:17.157Z
9230541 9230541 20260119043155_N92CV HU0003 2026-01-20T14:28:26.806Z 2026-01-27T15:05:02.324Z
9230223 9230223 20260119034120_Acr1i HU0003 2026-01-20T14:26:41.857Z 2026-01-27T15:04:42.939Z
9230103 9230103 20260119032537_ajS7J HU0003 2026-01-20T14:25:58.492Z 2026-01-27T15:04:25.518Z
9230032 9230032 20260119031322_51cSi HU0003 2026-01-20T14:25:32.702Z 2026-01-27T15:04:21.326Z
9229811 9229811 20260119023952_YQOEu HU0003 2026-01-20T14:24:21.048Z 2026-01-27T15:03:57.823Z
9229753 9229753 20260119022805_udU3d HU0003 2026-01-20T14:24:04.511Z 2026-01-27T15:03:53.186Z
9229705 9229705 20260119022209_Kxi6A HU0003 2026-01-20T14:23:47.430Z 2026-01-27T15:03:50.612Z
9229398 9229398 20260119014002_nq90s HU0003 2026-01-20T14:22:21.473Z 2026-01-27T15:03:21.912Z
9229074 9229074 20260119004500_3f1zv HU0003 2026-01-20T14:20:51.738Z 2026-01-27T15:02:52.990Z
9229018 9229018 20260119003550_VcSQ9 HU0003 2026-01-20T14:20:37.934Z 2026-01-27T15:02:48.043Z
9228815 9228815 20260118235837_yagsV HU0003 2026-01-20T14:19:40.215Z 2026-01-27T15:02:37.188Z
9228800 9228800 20260118235420_PqfHh HU0003 2026-01-20T14:19:35.709Z 2026-01-27T15:02:36.102Z
9228692 9228692 20260118233339_pY7Sg HU0003 2026-01-20T14:19:01.230Z 2026-01-27T15:02:17.504Z
9228686 9228686 20260118233149_laOLs HU0003 2026-01-20T14:18:58.578Z 2026-01-27T15:02:17.078Z
9228554 9228554 20260118224945_AyjQ1 HU0003 2026-01-20T14:18:22.786Z 2026-01-27T15:02:07.309Z
9228535 9228535 20260118224445_MK3CT HU0003 2026-01-20T14:18:11.942Z 2026-01-27T15:02:06.180Z
9228516 9228516 20260118223855_qkwML HU0003 2026-01-20T14:18:06.571Z 2026-01-27T15:02:05.121Z
9228478 9228478 20260118223217_isxjw HU0003 2026-01-20T14:17:58.661Z 2026-01-27T15:02:03.455Z
9228459 9228459 20260118222825_NGi2W HU0003 2026-01-20T14:17:54.195Z 2026-01-27T15:02:02.487Z
9228415 9228415 20260118221423_w4PSE HU0003 2026-01-20T14:17:42.020Z 2026-01-27T15:01:59.844Z
9228403 9228403 20260118221055_3QXPq HU0003 2026-01-20T14:17:36.766Z 2026-01-27T15:01:59.004Z
9228334 9228334 20260118214429_tgQzi HU0003 2026-01-20T14:17:16.455Z 2026-01-27T15:01:54.511Z
9228233 9228233 20260118204913_2SAn8 HU0003 2026-01-20T14:16:46.631Z 2026-01-27T15:01:35.307Z
9228128 9228128 20260118195954_Sa3mx HU0003 2026-01-20T14:16:09.753Z 2026-01-27T15:01:28.096Z
9227965 9227965 20260118185507_tiIGt HU0003 2026-01-20T14:15:11.393Z 2026-01-27T15:01:08.140Z
9227931 9227931 20260118184627_YYqoS HU0003 2026-01-20T14:14:58.202Z 2026-01-27T15:01:04.067Z
9227927 9227927 20260118184127_s7CrP HU0003 2026-01-20T14:14:56.328Z 2026-01-27T15:01:03.838Z
9227861 9227861 20260118182149_Rhksm HU0003 2026-01-20T14:14:30.852Z 2026-01-27T15:00:59.300Z
9227854 9227854 20260118182014_DGgqL HU0003 2026-01-20T14:14:29.114Z 2026-01-27T15:00:58.890Z
9227806 9227806 20260118175511_TQdxP HU0003 2026-01-20T14:14:12.307Z 2026-01-27T15:00:54.505Z
9227750 9227750 20260118172610_Jbk3u HU0003 2026-01-20T14:13:47.425Z 2026-01-27T15:00:50.768Z
9227718 9227718 20260118165539_yIyXd HU0003 2026-01-20T14:13:28.238Z 2026-01-27T15:00:40.062Z
9223975 9223975 20260118030455_TT3TZ HU0003 2026-01-19T14:22:11.843Z 2026-01-26T15:02:46.817Z
9223945 9223945 20260118025820_CjbDG HU0003 2026-01-19T14:21:57.458Z 2026-01-26T15:02:43.199Z
9222689 9222689 20260117202038_zAYvC HU0003 2026-01-19T14:15:51.226Z 2026-01-26T15:01:17.432Z
9222472 9222472 20260117194503_v2i3s HU0003 2026-01-19T14:15:00.162Z 2026-01-26T15:00:55.233Z
9222452 9222452 20260117193839_k3Cp4 HU0003 2026-01-19T14:14:51.407Z 2026-01-26T15:00:54.522Z
9189556 9189556 20260112050719_Xz76f HU0003 2026-01-13T14:18:12.501Z 2026-01-20T15:23:18.551Z
9189490 9189490 20260112044449_HlUYW HU0003 2026-01-13T14:17:49.696Z 2026-01-20T15:23:14.682Z
9189442 9189442 20260112042804_B5MhO HU0003 2026-01-13T14:17:36.122Z 2026-01-20T15:23:10.417Z
9189431 9189431 20260112042444_Fg4JE HU0003 2026-01-13T14:17:33.659Z 2026-01-20T15:23:09.833Z
9189423 9189423 20260112042334_oVqlz HU0003 2026-01-13T14:17:32.128Z 2026-01-20T15:23:09.476Z
9189414 9189414 20260112042048_3dIlm HU0003 2026-01-13T14:17:30.317Z 2026-01-20T15:23:08.894Z
9189408 9189408 20260112041742_4IsQ9 HU0003 2026-01-13T14:17:28.678Z 2026-01-20T15:23:08.489Z
9189354 9189354 20260112040701_3ukpi HU0003 2026-01-13T14:17:10.289Z 2026-01-20T15:23:05.869Z
9189332 9189332 20260112040017_3GabK HU0003 2026-01-13T14:17:04.008Z 2026-01-20T15:23:04.657Z
9189326 9189326 20260112035943_IzYkM HU0003 2026-01-13T14:17:01.827Z 2026-01-20T15:23:04.207Z
9189308 9189308 20260112035601_Ot1xU HU0003 2026-01-13T14:16:57.239Z 2026-01-20T15:23:03.064Z
9189294 9189294 20260112035013_POIir HU0003 2026-01-13T14:16:49.726Z 2026-01-20T15:23:02.122Z
9189261 9189261 20260112034330_jB4G6 HU0003 2026-01-13T14:16:39.438Z 2026-01-20T15:23:00.485Z
9189188 9189188 20260112032405_lzL9k HU0003 2026-01-13T14:16:13.716Z 2026-01-20T15:22:46.389Z
9189178 9189178 20260112032346_447cM HU0003 2026-01-13T14:16:11.910Z 2026-01-20T15:22:45.980Z
9189159 9189159 20260112032008_ECkOa HU0003 2026-01-13T14:16:07.784Z 2026-01-20T15:22:45.073Z
9189151 9189151 20260112031455_Nm084 HU0003 2026-01-13T14:16:05.565Z 2026-01-20T15:22:44.587Z
9189114 9189114 20260112030537_Y2uEt HU0003 2026-01-13T14:15:50.565Z 2026-01-20T15:22:40.098Z
9189109 9189109 20260112030446_zQRAV HU0003 2026-01-13T14:15:49.052Z 2026-01-20T15:22:39.781Z
9189101 9189101 20260112030227_lyuUV HU0003 2026-01-13T14:15:46.893Z 2026-01-20T15:22:39.409Z
9189097 9189097 20260112030215_xcXvQ HU0003 2026-01-13T14:15:45.650Z 2026-01-20T15:22:39.177Z
9189044 9189044 20260112024249_boR1j HU0003 2026-01-13T14:15:30.286Z 2026-01-20T15:22:36.056Z
9188958 9188958 20260112022800_utj0M HU0003 2026-01-13T14:15:04.769Z 2026-01-20T15:22:31.908Z
9188928 9188928 20260112022331_M6v2G HU0003 2026-01-13T14:14:55.835Z 2026-01-20T15:22:30.204Z
9188926 9188926 20260112022240_743eT HU0003 2026-01-13T14:14:55.062Z 2026-01-20T15:22:29.921Z
9188794 9188794 20260112015134_tuCah HU0003 2026-01-13T14:14:18.847Z 2026-01-20T15:22:15.260Z
9188771 9188771 20260112014427_6TRkP HU0003 2026-01-13T14:14:10.567Z 2026-01-20T15:22:13.737Z
9188730 9188730 20260112013327_JYQJn HU0003 2026-01-13T14:13:57.068Z 2026-01-20T15:22:08.824Z
9188693 9188693 20260112011632_yq5dY HU0003 2026-01-13T14:13:44.821Z 2026-01-20T15:22:06.453Z
9188659 9188659 20260112010809_OtbnS HU0003 2026-01-13T14:13:31.929Z 2026-01-20T15:22:04.582Z
9188655 9188655 20260112010748_803g2 HU0003 2026-01-13T14:13:30.604Z 2026-01-20T15:22:04.266Z
9188576 9188576 20260112004701_uRpjm HU0003 2026-01-13T14:13:04.183Z 2026-01-20T15:22:00.225Z
9188572 9188572 20260112004413_9Wtgt HU0003 2026-01-13T14:13:03.002Z 2026-01-20T15:21:59.977Z
9188566 9188566 20260112004203_2He7Q HU0003 2026-01-13T14:13:01.026Z 2026-01-20T15:21:59.428Z
9188549 9188549 20260112003830_v1dx7 HU0003 2026-01-13T14:12:56.708Z 2026-01-20T15:21:58.515Z
9188533 9188533 20260112002801_XfI3s HU0003 2026-01-13T14:12:53.262Z 2026-01-20T15:21:57.689Z
9188513 9188513 20260112001724_9BtMd HU0003 2026-01-13T14:12:47.385Z 2026-01-20T15:21:56.465Z
9188511 9188511 20260112001513_XKCCD HU0003 2026-01-13T14:12:46.819Z 2026-01-20T15:21:56.358Z

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