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

6,771 rows where station_code = "UK006L" 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
8682187 8682187 20251203045737_34jmg UK006L 2025-12-04T14:16:34.879Z 2025-12-06T14:28:49.226Z
8682130 8682130 20251203045320_WsvPL UK006L 2025-12-04T14:16:29.342Z 2025-12-06T14:28:47.354Z
8682114 8682114 20251203045258_Aw61c UK006L 2025-12-04T14:16:28.044Z 2025-12-06T14:28:46.985Z
8681833 8681833 20251203041407_lQ33d UK006L 2025-12-04T14:15:42.954Z 2025-12-06T14:28:32.995Z
8681732 8681732 20251203035126_rkDC0 UK006L 2025-12-04T14:15:27.698Z 2025-12-06T14:28:27.581Z
8681688 8681688 20251203034807_pScL3 UK006L 2025-12-04T14:15:15.481Z 2025-12-06T14:28:25.340Z
8681603 8681603 20251203032940_lq2zC UK006L 2025-12-04T14:15:07.376Z 2025-12-06T14:28:20.046Z
8681485 8681485 20251203031550_T7BtP UK006L 2025-12-04T14:14:48.595Z 2025-12-06T14:28:14.060Z
8681406 8681406 20251203030522_Kha4g UK006L 2025-12-04T14:14:39.745Z 2025-12-06T14:28:06.205Z
8681346 8681346 20251203025746_JAM4x UK006L 2025-12-04T14:14:32.161Z 2025-12-06T14:28:03.987Z
8681266 8681266 20251203025131_ClqEi UK006L 2025-12-04T14:14:13.923Z 2025-12-06T14:27:58.707Z
8676599 8676599 20251202060704_2I4GT UK006L 2025-12-03T14:25:21.152Z 2025-12-06T14:35:24.417Z
8676452 8676452 20251202055315_g4Ivq UK006L 2025-12-03T14:25:13.099Z 2025-12-06T14:35:21.882Z
8676305 8676305 20251202054523_MYtSy UK006L 2025-12-03T14:25:01.699Z 2025-12-06T14:35:19.958Z
8675809 8675809 20251202051530_NIBeK UK006L 2025-12-03T14:24:16.363Z 2025-12-06T14:35:00.655Z
8675743 8675743 20251202051218_RyOBY UK006L 2025-12-03T14:24:13.604Z 2025-12-06T14:34:59.480Z
8675560 8675560 20251202045633_0g8Ha UK006L 2025-12-03T14:23:51.596Z 2025-12-06T14:34:56.343Z
8675508 8675508 20251202045107_vcp34 UK006L 2025-12-03T14:23:48.675Z 2025-12-06T14:34:55.069Z
8675126 8675126 20251202040334_abF74 UK006L 2025-12-03T14:23:05.569Z 2025-12-06T14:34:30.479Z
8674979 8674979 20251202034523_I3f7Z UK006L 2025-12-03T14:22:47.505Z 2025-12-06T14:34:26.375Z
8674971 8674971 20251202034519_a42MO UK006L 2025-12-03T14:22:47.350Z 2025-12-06T14:34:26.301Z
8674873 8674873 20251202033543_3zk3u UK006L 2025-12-03T14:22:39.988Z 2025-12-06T14:34:21.874Z
8674797 8674797 20251202032748_B3lMQ UK006L 2025-12-03T14:22:26.282Z 2025-12-06T14:34:19.533Z
8674704 8674704 20251202031041_Wfl7t UK006L 2025-12-03T14:22:13.958Z 2025-12-06T14:34:16.202Z
8674445 8674445 20251202022457_m79hg UK006L 2025-12-03T14:21:39.005Z 2025-12-06T14:34:09.332Z
8674434 8674434 20251202022429_jtmem UK006L 2025-12-03T14:21:38.128Z 2025-12-06T14:34:09.069Z
8674374 8674374 20251202021337_rXUfK UK006L 2025-12-03T14:21:33.124Z 2025-12-06T14:34:07.044Z
8661868 8661868 20251130172558_VZXTq UK006L 2025-12-02T14:13:27.984Z 2025-12-06T14:38:40.106Z
8661783 8661783 20251130171132_gSbPV UK006L 2025-12-02T14:13:01.891Z 2025-12-06T14:38:31.963Z
8658308 8658308 20251127225900_34njE UK006L 2025-12-01T14:50:45.917Z 2025-12-06T15:01:42.009Z
8655902 8655902 20251130042408_RUocl UK006L 2025-12-01T14:27:39.506Z 2025-12-06T14:49:29.026Z
8655847 8655847 20251130042046_TKwdn UK006L 2025-12-01T14:27:32.709Z 2025-12-06T14:49:28.498Z
8654769 8654769 20251130033222_o6RNp UK006L 2025-12-01T14:25:59.666Z 2025-12-06T14:48:48.158Z
8654147 8654147 20251130030122_P3pIF UK006L 2025-12-01T14:24:54.890Z 2025-12-06T14:48:38.156Z
8653868 8653868 20251130024512_aP2Fx UK006L 2025-12-01T14:24:24.380Z 2025-12-06T14:48:33.872Z
8653723 8653723 20251130023759_RtHpr UK006L 2025-12-01T14:24:07.736Z 2025-12-06T14:48:31.061Z
8653378 8653378 20251130021317_HXdn0 UK006L 2025-12-01T14:23:18.998Z 2025-12-06T14:47:56.880Z
8653272 8653272 20251130020509_Ufqfg UK006L 2025-12-01T14:23:08.572Z 2025-12-06T14:47:52.551Z
8653124 8653124 20251130015922_l3bSW UK006L 2025-12-01T14:22:51.679Z 2025-12-06T14:47:50.582Z
8653009 8653009 20251130015056_uzveL UK006L 2025-12-01T14:22:38.430Z 2025-12-06T14:47:47.589Z
8652980 8652980 20251130014859_jkAJM UK006L 2025-12-01T14:22:36.502Z 2025-12-06T14:47:47.281Z
8652820 8652820 20251130013640_gvUad UK006L 2025-12-01T14:22:10.334Z 2025-12-06T14:47:42.938Z
8652660 8652660 20251130012633_PA0ew UK006L 2025-12-01T14:21:56.191Z 2025-12-06T14:47:40.709Z
8652563 8652563 20251130012106_yu2iw UK006L 2025-12-01T14:21:41.541Z 2025-12-06T14:47:39.456Z
8651936 8651936 20251130003522_jrk2G UK006L 2025-12-01T14:20:17.796Z 2025-12-06T14:46:56.446Z
8644394 8644394 20251128192444_GknT0 UK006L 2025-11-30T14:21:56.746Z 2025-12-06T14:54:41.715Z
8643824 8643824 20251128182920_n2BGH UK006L 2025-11-30T14:20:42.895Z 2025-12-06T14:54:21.436Z
8643487 8643487 20251128180115_Qqu25 UK006L 2025-11-30T14:20:05.321Z 2025-12-06T14:53:50.077Z
8642955 8642955 20251128170730_ihQ9r UK006L 2025-11-30T14:19:03.259Z 2025-12-06T14:53:38.418Z
8637365 8637365 20251128053328_9wAT0 UK006L 2025-11-29T14:27:07.114Z 2025-12-06T15:03:59.316Z
8637244 8637244 20251128051925_IsUr3 UK006L 2025-11-29T14:27:00.378Z 2025-12-06T15:03:57.985Z
8634172 8634172 20251128002943_Sk2Xq UK006L 2025-11-29T14:20:51.999Z 2025-12-06T15:01:51.996Z
8634089 8634089 20251128002107_s4t9h UK006L 2025-11-29T14:20:42.313Z 2025-12-06T15:01:51.349Z
8633865 8633865 20251128000017_lPu02 UK006L 2025-11-29T14:20:27.042Z 2025-12-06T15:01:49.018Z
8633706 8633706 20251127234640_1MA2I UK006L 2025-11-29T14:20:07.005Z 2025-12-06T15:01:48.022Z
8633358 8633358 20251127230647_rPhRA UK006L 2025-11-29T14:19:29.510Z 2025-12-06T15:01:43.075Z
8633286 8633286 20251127225900_WQh42 UK006L 2025-11-29T14:19:22.092Z 2025-12-06T15:01:41.984Z
8633148 8633148 20251127224403_SvM83 UK006L 2025-11-29T14:19:08.052Z 2025-12-06T15:01:40.515Z
8625525 8625525 20251126024151_NBhvg UK006L 2025-11-28T14:34:34.801Z 2025-12-04T15:09:32.773Z
8616463 8616463 20251126060137_jRsdU UK006L 2025-11-27T14:31:12.674Z 2025-12-04T15:11:39.731Z
8616430 8616430 20251126055957_0JbGr UK006L 2025-11-27T14:31:11.429Z 2025-12-04T15:11:39.476Z
8616055 8616055 20251126053426_fwCiL UK006L 2025-11-27T14:30:23.856Z 2025-12-04T15:11:34.896Z
8615298 8615298 20251126045446_aOgUb UK006L 2025-11-27T14:29:25.387Z 2025-12-04T15:11:27.524Z
8615158 8615158 20251126044648_xjb22 UK006L 2025-11-27T14:29:16.827Z 2025-12-04T15:11:26.328Z
8614235 8614235 20251126040030_qVYak UK006L 2025-11-27T14:27:41.587Z 2025-12-04T15:10:33.401Z
8614078 8614078 20251126035010_XubZt UK006L 2025-11-27T14:27:11.637Z 2025-12-04T15:10:17.804Z
8613979 8613979 20251126034501_tpMc8 UK006L 2025-11-27T14:27:02.354Z 2025-12-04T15:10:02.249Z
8613766 8613766 20251126033324_vPNwd UK006L 2025-11-27T14:26:29.875Z 2025-12-04T15:09:51.547Z
8612966 8612966 20251126025741_CvIbb UK006L 2025-11-27T14:25:03.206Z 2025-12-04T15:09:36.160Z
8612814 8612814 20251126024839_q2Tce UK006L 2025-11-27T14:24:51.255Z 2025-12-04T15:09:34.442Z
8612656 8612656 20251126024137_h44Z0 UK006L 2025-11-27T14:24:26.337Z 2025-12-04T15:09:32.548Z
8612508 8612508 20251126023435_CKRbu UK006L 2025-11-27T14:24:16.906Z 2025-12-04T15:09:31.232Z
8611584 8611584 20251126015219_b9P6s UK006L 2025-11-27T14:22:20.976Z 2025-12-04T15:09:22.797Z
8610613 8610613 20251126005935_Z5O9t UK006L 2025-11-27T14:20:26.797Z 2025-12-04T15:08:19.967Z
8610214 8610214 20251126003051_2rVGf UK006L 2025-11-27T14:19:35.629Z 2025-12-04T15:08:03.400Z
8610157 8610157 20251126002713_u4CBN UK006L 2025-11-27T14:19:31.522Z 2025-12-04T15:08:02.927Z
8609998 8609998 20251126001657_5CoUE UK006L 2025-11-27T14:19:20.865Z 2025-12-04T15:07:58.886Z
8609110 8609110 20251125231434_lUsLo UK006L 2025-11-27T14:17:34.851Z 2025-12-04T15:07:51.624Z
8609091 8609091 20251125231407_INhiU UK006L 2025-11-27T14:17:33.170Z 2025-12-04T15:07:51.430Z
8608948 8608948 20251125225914_b98ik UK006L 2025-11-27T14:17:05.573Z 2025-12-04T15:07:50.064Z
8608719 8608719 20251125223834_3QzsJ UK006L 2025-11-27T14:16:35.328Z 2025-12-04T15:07:48.013Z
8607951 8607951 20251125213915_yeUKu UK006L 2025-11-27T14:14:59.145Z 2025-12-04T15:07:39.440Z
8606531 8606531 20251125191118_3flXA UK006L 2025-11-27T14:10:29.420Z 2025-12-04T15:06:46.664Z
8604426 8604426 20251124015744_NCGo3 UK006L 2025-11-26T14:35:22.914Z 2025-12-02T15:12:37.052Z
8602471 8602471 20251125045808_Pir97 UK006L 2025-11-26T14:26:02.048Z 2025-12-02T15:09:31.083Z
8601445 8601445 20251125034728_u33lH UK006L 2025-11-26T14:23:59.315Z 2025-12-02T15:09:09.231Z
8601298 8601298 20251125034404_i6F64 UK006L 2025-11-26T14:23:53.676Z 2025-12-02T15:09:07.210Z
8601179 8601179 20251125033743_FCgUd UK006L 2025-11-26T14:23:46.512Z 2025-12-02T15:09:05.415Z
8601112 8601112 20251125033444_FyTic UK006L 2025-11-26T14:23:42.560Z 2025-12-02T15:08:59.479Z
8598843 8598843 20251125013105_bA3MK UK006L 2025-11-26T14:19:58.334Z 2025-12-02T15:08:09.623Z
8598363 8598363 20251125005217_7rpsE UK006L 2025-11-26T14:18:41.407Z 2025-12-02T15:07:53.230Z
8597973 8597973 20251125002435_3Njfy UK006L 2025-11-26T14:17:57.900Z 2025-12-02T15:07:43.806Z
8597370 8597370 20251124232803_22Uqh UK006L 2025-11-26T14:16:43.567Z 2025-12-02T15:07:30.338Z
8596774 8596774 20251124220455_obaF4 UK006L 2025-11-26T14:15:17.735Z 2025-12-02T15:07:12.725Z
8596708 8596708 20251124215825_bRA2r UK006L 2025-11-26T14:15:10.559Z 2025-12-02T15:07:07.440Z
8596320 8596320 20251124204420_zWKNP UK006L 2025-11-26T14:14:12.768Z 2025-12-02T15:06:53.433Z
8595778 8595778 20251124182625_45bJd UK006L 2025-11-26T14:12:28.567Z 2025-12-02T15:06:10.346Z
8595750 8595750 20251124181739_yYe2H UK006L 2025-11-26T14:12:22.841Z 2025-12-02T15:06:08.626Z
8595719 8595719 20251124180608_Mc2c4 UK006L 2025-11-26T14:12:17.781Z 2025-12-02T15:06:06.249Z
8592196 8592196 20251124060224_HvQ1p UK006L 2025-11-25T14:26:01.554Z 2025-12-02T15:13:02.287Z

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