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

5,451 rows where station_code = "UK009M" 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
8683053 8683053 20251203062220_pC3qx UK009M 2025-12-04T14:18:30.112Z 2025-12-05T14:23:06.140Z
8682612 8682612 20251203055122_9P72z UK009M 2025-12-04T14:17:42.832Z 2025-12-05T14:22:44.883Z
8682326 8682326 20251203051614_p2XKk UK009M 2025-12-04T14:16:48.709Z 2025-12-05T14:22:24.405Z
8682275 8682275 20251203050752_0Wo2H UK009M 2025-12-04T14:16:43.190Z 2025-12-05T14:22:22.632Z
8682241 8682241 20251203050714_b3AGy UK009M 2025-12-04T14:16:40.519Z 2025-12-05T14:22:20.412Z
8682193 8682193 20251203050012_v6RcL UK009M 2025-12-04T14:16:35.819Z 2025-12-05T14:22:18.130Z
8682161 8682161 20251203045515_1ePVg UK009M 2025-12-04T14:16:31.821Z 2025-12-05T14:22:16.486Z
8682124 8682124 20251203045316_O5TIF UK009M 2025-12-04T14:16:28.900Z 2025-12-05T14:22:15.243Z
8681922 8681922 20251203042828_dvkc8 UK009M 2025-12-04T14:16:01.084Z 2025-12-05T14:22:08.058Z
8681863 8681863 20251203041627_B39UB UK009M 2025-12-04T14:15:48.867Z 2025-12-05T14:22:04.557Z
8681799 8681799 20251203040904_yPNtd UK009M 2025-12-04T14:15:37.771Z 2025-12-05T14:22:01.589Z
8681498 8681498 20251203031614_3wVKF UK009M 2025-12-04T14:14:49.122Z 2025-12-05T14:21:38.982Z
8681465 8681465 20251203031359_JRl1s UK009M 2025-12-04T14:14:45.941Z 2025-12-05T14:21:38.319Z
8681264 8681264 20251203025127_3qQMh UK009M 2025-12-04T14:14:13.572Z 2025-12-05T14:21:29.726Z
8681055 8681055 20251203021735_Xp32t UK009M 2025-12-04T14:13:39.669Z 2025-12-05T14:21:13.747Z
8680924 8680924 20251203015321_0y5O0 UK009M 2025-12-04T14:13:22.498Z 2025-12-05T14:21:07.289Z
8680880 8680880 20251203013928_p3268 UK009M 2025-12-04T14:13:10.524Z 2025-12-05T14:21:05.571Z
8680843 8680843 20251203012953_M99Xh UK009M 2025-12-04T14:13:03.811Z 2025-12-05T14:21:03.520Z
8680769 8680769 20251203011451_ZcvL3 UK009M 2025-12-04T14:12:53.198Z 2025-12-05T14:21:00.180Z
8663154 8663154 20251130201558_XrzL2 UK009M 2025-12-02T14:17:33.091Z 2025-12-05T14:33:58.608Z
8662939 8662939 20251130194905_3l0Te UK009M 2025-12-02T14:17:04.336Z 2025-12-05T14:33:53.266Z
8656913 8656913 20251130051728_2a1FR UK009M 2025-12-01T14:33:49.011Z 2025-12-05T14:45:23.242Z
8656556 8656556 20251130045901_ZCWIc UK009M 2025-12-01T14:28:44.629Z 2025-12-05T14:45:17.630Z
8655905 8655905 20251130042408_RUocl UK009M 2025-12-01T14:27:39.506Z 2025-12-05T14:44:40.968Z
8655474 8655474 20251130040324_mBruZ UK009M 2025-12-01T14:26:58.584Z 2025-12-05T14:44:34.148Z
8655251 8655251 20251130035034_aUEw7 UK009M 2025-12-01T14:26:41.545Z 2025-12-05T14:44:30.324Z
8655058 8655058 20251130034210_NHNlI UK009M 2025-12-01T14:26:19.485Z 2025-12-05T14:44:27.268Z
8650778 8650778 20251129212442_WmXrp UK009M 2025-12-01T14:17:08.137Z 2025-12-05T14:41:17.090Z
8650638 8650638 20251129205629_9EZTD UK009M 2025-12-01T14:16:46.434Z 2025-12-05T14:41:12.721Z
8649979 8649979 20251129185950_2f3nG UK009M 2025-12-01T14:14:37.245Z 2025-12-05T14:40:43.843Z
8645112 8645112 20251128203851_v0CzI UK009M 2025-11-30T14:23:04.163Z 2025-12-05T14:50:31.835Z
8645096 8645096 20251128203604_4VOCF UK009M 2025-11-30T14:23:02.921Z 2025-12-05T14:50:31.656Z
8645067 8645067 20251128203406_PBIft UK009M 2025-11-30T14:23:02.081Z 2025-12-05T14:50:31.524Z
8645032 8645032 20251128203024_DOR7M UK009M 2025-11-30T14:22:59.750Z 2025-12-05T14:50:30.989Z
8644827 8644827 20251128200235_Lb7Jz UK009M 2025-11-30T14:22:45.687Z 2025-12-05T14:50:27.624Z
8616121 8616121 20251126054108_CwNno UK009M 2025-11-27T14:30:33.174Z 2025-12-04T15:11:36.008Z
8615309 8615309 20251126045510_zlQjL UK009M 2025-11-27T14:29:26.233Z 2025-12-04T15:11:27.621Z
8615170 8615170 20251126044723_hAsJo UK009M 2025-11-27T14:29:17.683Z 2025-12-04T15:11:26.460Z
8615028 8615028 20251126044222_kgw3m UK009M 2025-11-27T14:28:54.590Z 2025-12-04T15:11:25.423Z
8614958 8614958 20251126043858_rPcTj UK009M 2025-11-27T14:28:46.014Z 2025-12-04T15:11:23.469Z
8614838 8614838 20251126043058_HLS7l UK009M 2025-11-27T14:28:36.870Z 2025-12-04T15:11:14.194Z
8614803 8614803 20251126042755_kz3BB UK009M 2025-11-27T14:28:34.358Z 2025-12-04T15:11:11.670Z
8614596 8614596 20251126042002_rqobg UK009M 2025-11-27T14:28:04.629Z 2025-12-04T15:10:53.748Z
8614363 8614363 20251126040810_zT23Z UK009M 2025-11-27T14:27:49.761Z 2025-12-04T15:10:39.881Z
8614308 8614308 20251126040330_jtByY UK009M 2025-11-27T14:27:45.615Z 2025-12-04T15:10:34.795Z
8614064 8614064 20251126034922_INPA2 UK009M 2025-11-27T14:27:10.873Z 2025-12-04T15:10:16.360Z
8613836 8613836 20251126033702_WKCE2 UK009M 2025-11-27T14:26:50.650Z 2025-12-04T15:09:52.517Z
8612468 8612468 20251126023326_l4u2U UK009M 2025-11-27T14:24:15.277Z 2025-12-04T15:09:31.047Z
8612417 8612417 20251126023020_qibrR UK009M 2025-11-27T14:24:07.622Z 2025-12-04T15:09:30.518Z
8612049 8612049 20251126021510_s2I5T UK009M 2025-11-27T14:23:21.115Z 2025-12-04T15:09:27.068Z
8610989 8610989 20251126011717_Ql2g8 UK009M 2025-11-27T14:21:02.068Z 2025-12-04T15:08:47.637Z
8610562 8610562 20251126005704_63OlL UK009M 2025-11-27T14:20:20.484Z 2025-12-04T15:08:14.103Z
8610393 8610393 20251126004106_MQx39 UK009M 2025-11-27T14:20:02.800Z 2025-12-04T15:08:04.908Z
8610290 8610290 20251126003656_hGz74 UK009M 2025-11-27T14:19:42.576Z 2025-12-04T15:08:03.918Z
8610287 8610287 20251126003656_ebNes UK009M 2025-11-27T14:19:42.413Z 2025-12-04T15:08:03.916Z
8610011 8610011 20251126001800_pmRjI UK009M 2025-11-27T14:19:22.043Z 2025-12-04T15:07:59.004Z
8609819 8609819 20251126000815_3ZIvG UK009M 2025-11-27T14:18:58.011Z 2025-12-04T15:07:57.548Z
8609291 8609291 20251125233050_Jwlix UK009M 2025-11-27T14:18:02.512Z 2025-12-04T15:07:53.266Z
8609054 8609054 20251125231038_eWBDY UK009M 2025-11-27T14:17:29.864Z 2025-12-04T15:07:50.997Z
8608843 8608843 20251125225349_rGOoX UK009M 2025-11-27T14:16:59.174Z 2025-12-04T15:07:49.394Z
8608831 8608831 20251125225106_qJgKQ UK009M 2025-11-27T14:16:57.418Z 2025-12-04T15:07:49.153Z
8608573 8608573 20251125222818_CeeqM UK009M 2025-11-27T14:16:19.427Z 2025-12-04T15:07:46.497Z
8607202 8607202 20251125202823_BNV9E UK009M 2025-11-27T14:12:52.633Z 2025-12-04T15:06:56.563Z
8606775 8606775 20251125193932_z2lbj UK009M 2025-11-27T14:11:22.351Z 2025-12-04T15:06:50.239Z
8605790 8605790 20251125170927_zHTsb UK009M 2025-11-27T14:07:54.820Z 2025-12-04T15:05:42.866Z
8603345 8603345 20251125055758_NiEFN UK009M 2025-11-26T14:27:21.982Z 2025-12-02T15:09:35.406Z
8603244 8603244 20251125055243_IbgRd UK009M 2025-11-26T14:27:16.562Z 2025-12-02T15:09:34.994Z
8603165 8603165 20251125054652_xKyNo UK009M 2025-11-26T14:27:11.092Z 2025-12-02T15:09:34.623Z
8602950 8602950 20251125053451_SNTV8 UK009M 2025-11-26T14:26:29.807Z 2025-12-02T15:09:33.644Z
8602668 8602668 20251125051230_PX2Eu UK009M 2025-11-26T14:26:13.668Z 2025-12-02T15:09:32.045Z
8602651 8602651 20251125051015_WFjyn UK009M 2025-11-26T14:26:12.573Z 2025-12-02T15:09:31.896Z
8602321 8602321 20251125044741_HSL8Q UK009M 2025-11-26T14:25:33.219Z 2025-12-02T15:09:30.464Z
8601694 8601694 20251125040942_JhTJN UK009M 2025-11-26T14:24:36.486Z 2025-12-02T15:09:18.827Z
8597243 8597243 20251124231616_NCcRW UK009M 2025-11-26T14:16:25.658Z 2025-12-02T15:07:27.368Z
8592049 8592049 20251124053642_53vpn UK009M 2025-11-25T14:25:47.912Z 2025-12-02T15:13:01.541Z
8591694 8591694 20251124044609_z2Dfa UK009M 2025-11-25T14:24:45.688Z 2025-12-02T15:12:59.938Z
8591655 8591655 20251124044125_pkKEH UK009M 2025-11-25T14:24:42.426Z 2025-12-02T15:12:59.807Z
8591328 8591328 20251124040437_nbr3B UK009M 2025-11-25T14:23:55.593Z 2025-12-02T15:12:57.991Z
8591250 8591250 20251124035533_hUnXX UK009M 2025-11-25T14:23:47.789Z 2025-12-02T15:12:57.559Z
8591202 8591202 20251124035259_9Tp9f UK009M 2025-11-25T14:23:44.631Z 2025-12-02T15:12:57.419Z
8590916 8590916 20251124032707_3p38K UK009M 2025-11-25T14:23:02.607Z 2025-12-02T15:12:56.157Z
8590475 8590475 20251124024445_b9IIE UK009M 2025-11-25T14:22:05.614Z 2025-12-02T15:12:47.871Z
8590249 8590249 20251124023120_lXDlB UK009M 2025-11-25T14:21:35.549Z 2025-12-02T15:12:44.072Z
8590234 8590234 20251124023035_RQhgo UK009M 2025-11-25T14:21:34.523Z 2025-12-02T15:12:43.920Z
8590217 8590217 20251124022927_BGbLl UK009M 2025-11-25T14:21:33.190Z 2025-12-02T15:12:43.332Z
8590171 8590171 20251124022732_iRCHS UK009M 2025-11-25T14:21:30.527Z 2025-12-02T15:12:43.102Z
8590110 8590110 20251124022248_F3xrH UK009M 2025-11-25T14:21:24.509Z 2025-12-02T15:12:42.441Z
8589960 8589960 20251124021104_mFUUx UK009M 2025-11-25T14:21:00.954Z 2025-12-02T15:12:40.596Z
8589473 8589473 20251124013705_Q0WAZ UK009M 2025-11-25T14:20:06.936Z 2025-12-02T15:12:31.306Z
8588955 8588955 20251124004731_5irem UK009M 2025-11-25T14:18:48.848Z 2025-12-02T15:12:03.076Z
8569710 8569710 20251121061040_Q246y UK009M 2025-11-23T14:32:25.547Z 2025-11-29T14:54:48.804Z
8569523 8569523 20251121060011_9yzfo UK009M 2025-11-23T14:32:18.431Z 2025-11-29T14:54:48.405Z
8568921 8568921 20251121054126_rzEyO UK009M 2025-11-23T14:31:48.427Z 2025-11-29T14:54:47.633Z
8568687 8568687 20251121053030_WvOvL UK009M 2025-11-23T14:31:19.385Z 2025-11-29T14:54:47.207Z
8566514 8566514 20251122005726_nbSDv UK009M 2025-11-23T14:16:28.522Z 2025-11-30T15:05:50.918Z
8566272 8566272 20251121235240_C9525 UK009M 2025-11-23T14:15:38.441Z 2025-11-30T15:05:40.488Z
8566237 8566237 20251121234223_i7inG UK009M 2025-11-23T14:15:33.575Z 2025-11-30T15:05:38.040Z
8565297 8565297 20251121201537_p3XxT UK009M 2025-11-23T14:12:57.296Z 2025-11-30T15:04:53.881Z
8564672 8564672 20251121185418_3hJfD UK009M 2025-11-23T14:11:29.936Z 2025-11-30T15:04:25.726Z
8559869 8559869 20251121042818_S2Irs UK009M 2025-11-22T14:42:06.080Z 2025-11-29T14:54:44.414Z

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