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 = "UK0041" 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
8686333 8686333 20251203193519_gDdIT UK0041 2025-12-05T14:11:44.757Z 2025-12-05T14:14:35.367Z
8686161 8686161 20251203185513_zv2Cf UK0041 2025-12-05T14:11:09.585Z 2025-12-05T14:14:35.310Z
8686126 8686126 20251203184905_a0Yo2 UK0041 2025-12-05T14:11:06.352Z 2025-12-05T14:14:35.304Z
8686019 8686019 20251203181125_JKZRw UK0041 2025-12-05T14:10:43.889Z 2025-12-05T14:14:35.280Z
8685889 8685889 20251203172345_NDh7q UK0041 2025-12-05T14:10:23.893Z 2025-12-05T14:14:35.248Z
8682425 8682425 20251203053035_xteSJ UK0041 2025-12-04T14:17:09.390Z 2025-12-05T14:22:37.060Z
8682197 8682197 20251203050012_eysSq UK0041 2025-12-04T14:16:36.131Z 2025-12-05T14:22:18.183Z
8681832 8681832 20251203041407_lQ33d UK0041 2025-12-04T14:15:42.954Z 2025-12-05T14:22:03.334Z
8681760 8681760 20251203035647_bi89F UK0041 2025-12-04T14:15:31.470Z 2025-12-05T14:21:57.666Z
8681687 8681687 20251203034807_pScL3 UK0041 2025-12-04T14:15:15.481Z 2025-12-05T14:21:49.261Z
8681667 8681667 20251203034329_ATm82 UK0041 2025-12-04T14:15:13.140Z 2025-12-05T14:21:48.237Z
8681660 8681660 20251203034322_82xdb UK0041 2025-12-04T14:15:12.884Z 2025-12-05T14:21:48.062Z
8681458 8681458 20251203031203_kAjMs UK0041 2025-12-04T14:14:45.361Z 2025-12-05T14:21:37.895Z
8681393 8681393 20251203030313_AzjK2 UK0041 2025-12-04T14:14:37.145Z 2025-12-05T14:21:34.913Z
8681184 8681184 20251203023642_2kYlQ UK0041 2025-12-04T14:14:01.585Z 2025-12-05T14:21:25.573Z
8681124 8681124 20251203022606_yDy6a UK0041 2025-12-04T14:13:53.925Z 2025-12-05T14:21:17.403Z
8681077 8681077 20251203021808_q7Rf7 UK0041 2025-12-04T14:13:41.460Z 2025-12-05T14:21:15.055Z
8680954 8680954 20251203020219_53LnG UK0041 2025-12-04T14:13:26.218Z 2025-12-05T14:21:08.588Z
8680829 8680829 20251203012408_6geIg UK0041 2025-12-04T14:13:00.995Z 2025-12-05T14:21:02.560Z
8679031 8679031 20251202183834_dzyyX UK0041 2025-12-04T14:08:47.843Z 2025-12-05T14:19:17.172Z
8676431 8676431 20251202055207_MmdIZ UK0041 2025-12-03T14:25:12.459Z 2025-12-05T14:28:56.341Z
8676130 8676130 20251202053845_NKTYF UK0041 2025-12-03T14:24:44.835Z 2025-12-05T14:28:49.378Z
8674802 8674802 20251202032749_WIOGH UK0041 2025-12-03T14:22:26.471Z 2025-12-05T14:28:03.540Z
8662546 8662546 20251130190909_wyxPg UK0041 2025-12-02T14:15:52.189Z 2025-12-05T14:33:28.564Z
8662118 8662118 20251130180121_MzLhK UK0041 2025-12-02T14:14:22.347Z 2025-12-05T14:33:07.984Z
8657829 8657829 20251130061105_U9pvH UK0041 2025-12-01T14:34:42.673Z 2025-12-05T14:45:42.170Z
8657811 8657811 20251130061009_RyVs9 UK0041 2025-12-01T14:34:42.100Z 2025-12-05T14:45:41.888Z
8657774 8657774 20251130060809_7vVBo UK0041 2025-12-01T14:34:40.925Z 2025-12-05T14:45:36.703Z
8657523 8657523 20251130055059_E4Wha UK0041 2025-12-01T14:34:32.057Z 2025-12-05T14:45:32.895Z
8657155 8657155 20251130053213_2LOvZ UK0041 2025-12-01T14:33:56.520Z 2025-12-05T14:45:26.144Z
8657089 8657089 20251130052936_101eh UK0041 2025-12-01T14:33:54.132Z 2025-12-05T14:45:25.503Z
8657081 8657081 20251130052915_wt8fP UK0041 2025-12-01T14:33:53.777Z 2025-12-05T14:45:25.331Z
8656888 8656888 20251130051533_Nlcsd UK0041 2025-12-01T14:33:48.357Z 2025-12-05T14:45:23.015Z
8656676 8656676 20251130050601_MNGtd UK0041 2025-12-01T14:28:53.811Z 2025-12-05T14:45:19.930Z
8656472 8656472 20251130045657_WEu37 UK0041 2025-12-01T14:28:40.091Z 2025-12-05T14:45:16.547Z
8655642 8655642 20251130041032_qzGAS UK0041 2025-12-01T14:27:19.708Z 2025-12-05T14:44:36.675Z
8655177 8655177 20251130034740_3q2Pm UK0041 2025-12-01T14:26:37.212Z 2025-12-05T14:44:29.405Z
8655081 8655081 20251130034318_XEU8R UK0041 2025-12-01T14:26:22.386Z 2025-12-05T14:44:27.786Z
8655031 8655031 20251130034110_zS9us UK0041 2025-12-01T14:26:16.533Z 2025-12-05T14:44:26.970Z
8654422 8654422 20251130031503_lq7ve UK0041 2025-12-01T14:25:23.867Z 2025-12-05T14:43:55.521Z
8653601 8653601 20251130022900_pmPr6 UK0041 2025-12-01T14:23:46.089Z 2025-12-05T14:43:36.033Z
8653400 8653400 20251130021457_93gj2 UK0041 2025-12-01T14:23:21.155Z 2025-12-05T14:43:30.629Z
8653305 8653305 20251130020933_sdTHo UK0041 2025-12-01T14:23:12.308Z 2025-12-05T14:43:28.483Z
8653008 8653008 20251130015056_uzveL UK0041 2025-12-01T14:22:38.430Z 2025-12-05T14:42:59.070Z
8652468 8652468 20251130011105_BkZTH UK0041 2025-12-01T14:21:28.231Z 2025-12-05T14:42:45.208Z
8652448 8652448 20251130010925_PW4ed UK0041 2025-12-01T14:21:24.472Z 2025-12-05T14:42:44.714Z
8652101 8652101 20251130004738_LoXoP UK0041 2025-12-01T14:20:43.274Z 2025-12-05T14:42:20.800Z
8652024 8652024 20251130004144_igd3d UK0041 2025-12-01T14:20:29.684Z 2025-12-05T14:42:13.864Z
8651974 8651974 20251130003846_8hcKq UK0041 2025-12-01T14:20:22.820Z 2025-12-05T14:42:12.778Z
8650873 8650873 20251129214747_MW0fw UK0041 2025-12-01T14:17:25.466Z 2025-12-05T14:41:21.555Z
8650591 8650591 20251129204649_Scwul UK0041 2025-12-01T14:16:33.664Z 2025-12-05T14:41:11.639Z
8650111 8650111 20251129192554_NHOpu UK0041 2025-12-01T14:15:06.833Z 2025-12-05T14:40:56.784Z
8650063 8650063 20251129191503_8gPBm UK0041 2025-12-01T14:14:57.744Z 2025-12-05T14:40:54.342Z
8646145 8646145 20251129011238_63gts UK0041 2025-11-30T14:25:16.513Z 2025-12-05T14:51:34.089Z
8646120 8646120 20251129010838_vYK2c UK0041 2025-11-30T14:25:14.127Z 2025-12-05T14:51:33.519Z
8643822 8643822 20251128182920_n2BGH UK0041 2025-11-30T14:20:42.864Z 2025-12-05T14:49:47.729Z
8643781 8643781 20251128182634_qC23R UK0041 2025-11-30T14:20:40.709Z 2025-12-05T14:49:46.676Z
8634782 8634782 20251128011734_RCV3k UK0041 2025-11-29T14:22:03.318Z 2025-12-05T14:58:24.882Z
8616633 8616633 20251126061405_8VxTA UK0041 2025-11-27T14:31:23.589Z 2025-12-04T15:11:41.442Z
8616408 8616408 20251126055621_oqaFx UK0041 2025-11-27T14:31:09.787Z 2025-12-04T15:11:38.978Z
8615754 8615754 20251126051646_HFWUn UK0041 2025-11-27T14:30:08.621Z 2025-12-04T15:11:31.898Z
8615256 8615256 20251126045206_OC8gB UK0041 2025-11-27T14:29:22.920Z 2025-12-04T15:11:27.177Z
8613932 8613932 20251126034205_2aypq UK0041 2025-11-27T14:26:58.509Z 2025-12-04T15:09:53.802Z
8613751 8613751 20251126033321_uaNlR UK0041 2025-11-27T14:26:29.730Z 2025-12-04T15:09:51.522Z
8613607 8613607 20251126032523_fRpag UK0041 2025-11-27T14:26:17.258Z 2025-12-04T15:09:49.682Z
8613206 8613206 20251126030945_IzlBB UK0041 2025-11-27T14:25:30.938Z 2025-12-04T15:09:38.650Z
8613107 8613107 20251126030229_5eaga UK0041 2025-11-27T14:25:24.071Z 2025-12-04T15:09:37.286Z
8612693 8612693 20251126024213_ZOfdS UK0041 2025-11-27T14:24:28.561Z 2025-12-04T15:09:32.829Z
8612466 8612466 20251126023326_l4u2U UK0041 2025-11-27T14:24:15.277Z 2025-12-04T15:09:31.047Z
8612378 8612378 20251126022855_znrnj UK0041 2025-11-27T14:23:53.492Z 2025-12-04T15:09:30.263Z
8612265 8612265 20251126022354_3wDkW UK0041 2025-11-27T14:23:42.160Z 2025-12-04T15:09:28.803Z
8611448 8611448 20251126014319_0Mmf2 UK0041 2025-11-27T14:22:09.471Z 2025-12-04T15:09:20.324Z
8611158 8611158 20251126012548_sSxfL UK0041 2025-11-27T14:21:33.364Z 2025-12-04T15:08:54.848Z
8610993 8610993 20251126011730_fVLSl UK0041 2025-11-27T14:21:03.083Z 2025-12-04T15:08:48.093Z
8610518 8610518 20251126005149_9c94p UK0041 2025-11-27T14:20:16.076Z 2025-12-04T15:08:08.492Z
8610331 8610331 20251126003848_FD6XP UK0041 2025-11-27T14:19:50.905Z 2025-12-04T15:08:04.228Z
8610237 8610237 20251126003126_Vk3pt UK0041 2025-11-27T14:19:39.222Z 2025-12-04T15:08:03.604Z
8609987 8609987 20251126001656_yEh93 UK0041 2025-11-27T14:19:20.411Z 2025-12-04T15:07:58.856Z
8609857 8609857 20251126001042_hMVTF UK0041 2025-11-27T14:19:02.730Z 2025-12-04T15:07:57.786Z
8609598 8609598 20251125234913_p1qyt UK0041 2025-11-27T14:18:28.842Z 2025-12-04T15:07:55.574Z
8609559 8609559 20251125234738_PzVma UK0041 2025-11-27T14:18:24.282Z 2025-12-04T15:07:55.224Z
8609219 8609219 20251125232208_wRC2U UK0041 2025-11-27T14:17:47.672Z 2025-12-04T15:07:52.736Z
8608939 8608939 20251125225913_ruid2 UK0041 2025-11-27T14:17:05.183Z 2025-12-04T15:07:50.002Z
8608771 8608771 20251125224443_8RoDg UK0041 2025-11-27T14:16:50.232Z 2025-12-04T15:07:48.521Z
8608372 8608372 20251125221058_DT4BG UK0041 2025-11-27T14:15:47.556Z 2025-12-04T15:07:44.328Z
8608317 8608317 20251125220652_Vv5uJ UK0041 2025-11-27T14:15:41.155Z 2025-12-04T15:07:43.504Z
8608281 8608281 20251125220517_VYY1O UK0041 2025-11-27T14:15:39.122Z 2025-12-04T15:07:43.233Z
8607560 8607560 20251125210226_GvsZU UK0041 2025-11-27T14:13:57.163Z 2025-12-04T15:07:03.742Z
8607491 8607491 20251125205717_3UVr0 UK0041 2025-11-27T14:13:51.259Z 2025-12-04T15:07:02.893Z
8607102 8607102 20251125201247_UyrBJ UK0041 2025-11-27T14:12:24.975Z 2025-12-04T15:06:54.708Z
8606617 8606617 20251125191651_BHyDV UK0041 2025-11-27T14:10:45.854Z 2025-12-04T15:06:47.707Z
8606021 8606021 20251125173724_eMf0E UK0041 2025-11-27T14:08:36.515Z 2025-12-04T15:05:57.943Z
8604397 8604397 20251123233629_JszqU UK0041 2025-11-26T14:34:29.201Z 2025-12-02T15:11:38.886Z
8604369 8604369 20251123212053_qCtuU UK0041 2025-11-26T14:33:37.226Z 2025-12-02T15:11:07.358Z
8602777 8602777 20251125052100_LqInh UK0041 2025-11-26T14:26:20.199Z 2025-12-02T15:09:32.806Z
8602407 8602407 20251125045500_abMjf UK0041 2025-11-26T14:25:37.538Z 2025-12-02T15:09:30.816Z
8601978 8601978 20251125043043_AdP3H UK0041 2025-11-26T14:25:14.999Z 2025-12-02T15:09:29.032Z
8601435 8601435 20251125034724_Mlkb3 UK0041 2025-11-26T14:23:59.135Z 2025-12-02T15:09:09.225Z
8601335 8601335 20251125034445_gaCnv UK0041 2025-11-26T14:23:55.089Z 2025-12-02T15:09:07.752Z
8601272 8601272 20251125034250_3rWKN UK0041 2025-11-26T14:23:51.406Z 2025-12-02T15:09:06.455Z

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