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,277 rows where station_code = "UK00CJ" 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
8683033 8683033 20251203061925_yqy3q UK00CJ 2025-12-04T14:18:27.419Z 2025-12-05T14:23:05.247Z
8682626 8682626 20251203055246_3CAR3 UK00CJ 2025-12-04T14:17:44.390Z 2025-12-05T14:22:45.520Z
8682614 8682614 20251203055122_9P72z UK00CJ 2025-12-04T14:17:42.832Z 2025-12-05T14:22:44.883Z
8682519 8682519 20251203054332_ulq3c UK00CJ 2025-12-04T14:17:20.613Z 2025-12-05T14:22:41.381Z
8682454 8682454 20251203053724_8Epgu UK00CJ 2025-12-04T14:17:14.325Z 2025-12-05T14:22:38.989Z
8682430 8682430 20251203053224_pQEGa UK00CJ 2025-12-04T14:17:10.018Z 2025-12-05T14:22:37.370Z
8682387 8682387 20251203052433_Qumjx UK00CJ 2025-12-04T14:17:04.461Z 2025-12-05T14:22:33.830Z
8682126 8682126 20251203045316_O5TIF UK00CJ 2025-12-04T14:16:28.900Z 2025-12-05T14:22:15.243Z
8682107 8682107 20251203045158_c7ApH UK00CJ 2025-12-04T14:16:27.786Z 2025-12-05T14:22:14.926Z
8681905 8681905 20251203042638_EFCpq UK00CJ 2025-12-04T14:15:58.932Z 2025-12-05T14:22:06.733Z
8681866 8681866 20251203041627_B39UB UK00CJ 2025-12-04T14:15:48.867Z 2025-12-05T14:22:04.557Z
8681610 8681610 20251203033041_VQR9Y UK00CJ 2025-12-04T14:15:08.007Z 2025-12-05T14:21:43.482Z
8681547 8681547 20251203032509_9r2Eu UK00CJ 2025-12-04T14:15:02.688Z 2025-12-05T14:21:41.182Z
8681467 8681467 20251203031359_JRl1s UK00CJ 2025-12-04T14:14:45.941Z 2025-12-05T14:21:38.319Z
8681153 8681153 20251203022842_dqb6G UK00CJ 2025-12-04T14:13:57.612Z 2025-12-05T14:21:18.834Z
8681080 8681080 20251203021808_q7Rf7 UK00CJ 2025-12-04T14:13:41.460Z 2025-12-05T14:21:15.055Z
8681057 8681057 20251203021735_Xp32t UK00CJ 2025-12-04T14:13:39.669Z 2025-12-05T14:21:13.747Z
8680934 8680934 20251203015657_2ci8e UK00CJ 2025-12-04T14:13:24.337Z 2025-12-05T14:21:07.951Z
8680925 8680925 20251203015321_0y5O0 UK00CJ 2025-12-04T14:13:22.498Z 2025-12-05T14:21:07.289Z
8680881 8680881 20251203013928_p3268 UK00CJ 2025-12-04T14:13:10.524Z 2025-12-05T14:21:05.571Z
8680773 8680773 20251203011601_4rmcP UK00CJ 2025-12-04T14:12:53.560Z 2025-12-05T14:21:00.319Z
8680640 8680640 20251203005108_wBBXe UK00CJ 2025-12-04T14:12:30.972Z 2025-12-05T14:20:50.327Z
8668125 8668125 20251130061300_Qi18J UK00CJ 2025-12-02T14:42:03.149Z 2025-12-05T14:45:43.720Z
8663753 8663753 20251130214801_vS5g3 UK00CJ 2025-12-02T14:19:01.987Z 2025-12-05T14:34:30.795Z
8663649 8663649 20251130211425_Vf2iO UK00CJ 2025-12-02T14:18:39.339Z 2025-12-05T14:34:26.802Z
8663605 8663605 20251130210743_oXQ9d UK00CJ 2025-12-02T14:18:33.596Z 2025-12-05T14:34:25.703Z
8663548 8663548 20251130210155_GcDdx UK00CJ 2025-12-02T14:18:26.703Z 2025-12-05T14:34:23.871Z
8663546 8663546 20251130210155_tlhN7 UK00CJ 2025-12-02T14:18:26.334Z 2025-12-05T14:34:23.775Z
8663251 8663251 20251130202426_5X4GU UK00CJ 2025-12-02T14:17:53.238Z 2025-12-05T14:34:03.252Z
8662733 8662733 20251130192414_wt3sy UK00CJ 2025-12-02T14:16:25.366Z 2025-12-05T14:33:45.663Z
8662683 8662683 20251130192008_umyNp UK00CJ 2025-12-02T14:16:17.629Z 2025-12-05T14:33:43.289Z
8662553 8662553 20251130190909_wyxPg UK00CJ 2025-12-02T14:15:52.240Z 2025-12-05T14:33:28.564Z
8662191 8662191 20251130181632_uGQg0 UK00CJ 2025-12-02T14:14:39.414Z 2025-12-05T14:33:11.551Z
8661976 8661976 20251130173856_YEai6 UK00CJ 2025-12-02T14:13:46.568Z 2025-12-05T14:32:44.482Z
8657859 8657859 20251130061300_fUrG7 UK00CJ 2025-12-01T14:34:43.770Z 2025-12-01T14:35:23.441Z
8657836 8657836 20251130061105_U9pvH UK00CJ 2025-12-01T14:34:42.674Z 2025-12-05T14:45:42.170Z
8657540 8657540 20251130055146_qj3lN UK00CJ 2025-12-01T14:34:32.542Z 2025-12-05T14:45:33.065Z
8656953 8656953 20251130052028_qI00i UK00CJ 2025-12-01T14:33:49.767Z 2025-12-05T14:45:23.873Z
8654251 8654251 20251130030538_S92VP UK00CJ 2025-12-01T14:25:01.580Z 2025-12-05T14:43:51.922Z
8653293 8653293 20251130020816_2CMPo UK00CJ 2025-12-01T14:23:10.981Z 2025-12-05T14:43:27.154Z
8653098 8653098 20251130015554_LndcX UK00CJ 2025-12-01T14:22:48.160Z 2025-12-05T14:43:03.413Z
8651932 8651932 20251130003519_2282i UK00CJ 2025-12-01T14:20:17.354Z 2025-12-05T14:42:11.708Z
8651395 8651395 20251129233616_Lk10g UK00CJ 2025-12-01T14:18:58.328Z 2025-12-05T14:41:56.933Z
8651237 8651237 20251129231043_ggaH0 UK00CJ 2025-12-01T14:18:27.391Z 2025-12-05T14:41:52.604Z
8651177 8651177 20251129225745_GSrRv UK00CJ 2025-12-01T14:18:16.813Z 2025-12-05T14:41:51.148Z
8651106 8651106 20251129224244_cLFCu UK00CJ 2025-12-01T14:18:01.124Z 2025-12-05T14:41:49.105Z
8650824 8650824 20251129213659_pkT4X UK00CJ 2025-12-01T14:17:15.733Z 2025-12-05T14:41:20.085Z
8650811 8650811 20251129213405_Hlw3x UK00CJ 2025-12-01T14:17:13.445Z 2025-12-05T14:41:18.135Z
8650747 8650747 20251129212046_oMrpb UK00CJ 2025-12-01T14:17:04.664Z 2025-12-05T14:41:16.271Z
8650592 8650592 20251129204649_Scwul UK00CJ 2025-12-01T14:16:33.664Z 2025-12-05T14:41:11.639Z
8650524 8650524 20251129203440_RhhFv UK00CJ 2025-12-01T14:16:23.035Z 2025-12-05T14:41:09.592Z
8650482 8650482 20251129202803_ArQpP UK00CJ 2025-12-01T14:16:18.142Z 2025-12-05T14:41:08.760Z
8645455 8645455 20251128221530_PYkxX UK00CJ 2025-11-30T14:23:45.478Z 2025-12-05T14:50:39.321Z
8644876 8644876 20251128200845_2rrTH UK00CJ 2025-11-30T14:22:49.021Z 2025-12-05T14:50:28.493Z
8644097 8644097 20251128185701_Bu8Tb UK00CJ 2025-11-30T14:21:19.940Z 2025-12-05T14:50:16.138Z
8643895 8643895 20251128183640_34YfI UK00CJ 2025-11-30T14:20:47.399Z 2025-12-05T14:49:59.047Z
8643808 8643808 20251128182821_LZkxl UK00CJ 2025-11-30T14:20:42.390Z 2025-12-05T14:49:47.529Z
8643775 8643775 20251128182557_3jxNy UK00CJ 2025-11-30T14:20:40.173Z 2025-12-05T14:49:46.536Z
8625518 8625518 20251126023326_3c3Vq UK00CJ 2025-11-28T14:34:31.166Z 2025-12-04T15:09:31.032Z
8622111 8622111 20251126175152_VNthS UK00CJ 2025-11-28T14:17:43.512Z 2025-12-05T15:02:52.386Z
8616504 8616504 20251126060331_YCTZA UK00CJ 2025-11-27T14:31:14.216Z 2025-12-04T15:11:40.135Z
8616481 8616481 20251126060212_CkC2a UK00CJ 2025-11-27T14:31:13.302Z 2025-12-04T15:11:39.888Z
8616223 8616223 20251126054722_MYiNN UK00CJ 2025-11-27T14:30:57.731Z 2025-12-04T15:11:37.041Z
8615638 8615638 20251126051207_sWntr UK00CJ 2025-11-27T14:30:03.737Z 2025-12-04T15:11:31.043Z
8615253 8615253 20251126045205_jq3wf UK00CJ 2025-11-27T14:29:22.621Z 2025-12-04T15:11:27.091Z
8614847 8614847 20251126043058_iUJ3M UK00CJ 2025-11-27T14:28:37.189Z 2025-12-04T15:11:14.287Z
8614677 8614677 20251126042326_DuhfC UK00CJ 2025-11-27T14:28:27.050Z 2025-12-04T15:10:57.689Z
8614628 8614628 20251126042122_z5R1J UK00CJ 2025-11-27T14:28:08.318Z 2025-12-04T15:10:56.835Z
8614603 8614603 20251126042003_2WoD6 UK00CJ 2025-11-27T14:28:04.806Z 2025-12-04T15:10:53.764Z
8614546 8614546 20251126041745_RT5GU UK00CJ 2025-11-27T14:28:02.301Z 2025-12-04T15:10:50.913Z
8614120 8614120 20251126035214_Cpda4 UK00CJ 2025-11-27T14:27:14.847Z 2025-12-04T15:10:22.248Z
8613782 8613782 20251126033352_lZNSe UK00CJ 2025-11-27T14:26:30.848Z 2025-12-04T15:09:51.720Z
8613654 8613654 20251126032749_xxo2h UK00CJ 2025-11-27T14:26:20.549Z 2025-12-04T15:09:50.128Z
8613375 8613375 20251126031512_VkfE2 UK00CJ 2025-11-27T14:25:44.590Z 2025-12-04T15:09:39.940Z
8612709 8612709 20251126024248_iqiqr UK00CJ 2025-11-27T14:24:29.908Z 2025-12-04T15:09:33.029Z
8612483 8612483 20251126023327_lsz0i UK00CJ 2025-11-27T14:24:15.449Z 2025-12-04T15:09:31.069Z
8611784 8611784 20251126015948_vgAMw UK00CJ 2025-11-27T14:22:48.658Z 2025-12-04T15:09:24.094Z
8611650 8611650 20251126015347_0PjEC UK00CJ 2025-11-27T14:22:23.553Z 2025-12-04T15:09:23.053Z
8611034 8611034 20251126011737_3PKSi UK00CJ 2025-11-27T14:21:07.049Z 2025-12-04T15:08:49.591Z
8610346 8610346 20251126003849_Xla80 UK00CJ 2025-11-27T14:19:54.768Z 2025-12-04T15:08:04.343Z
8608670 8608670 20251125223541_uOlwk UK00CJ 2025-11-27T14:16:31.572Z 2025-12-04T15:07:47.662Z
8605793 8605793 20251125170928_bsT80 UK00CJ 2025-11-27T14:07:55.238Z 2025-12-04T15:05:43.231Z
8603361 8603361 20251125060023_dHzBf UK00CJ 2025-11-26T14:27:22.880Z 2025-12-02T15:09:35.477Z
8592229 8592229 20251124061048_Jg211 UK00CJ 2025-11-25T14:26:04.993Z 2025-12-02T15:13:02.478Z
8592015 8592015 20251124053251_iMjYR UK00CJ 2025-11-25T14:25:44.199Z 2025-12-02T15:13:01.404Z
8591927 8591927 20251124051540_3dMJX UK00CJ 2025-11-25T14:25:20.937Z 2025-12-02T15:13:01.010Z
8591831 8591831 20251124050501_8EbRn UK00CJ 2025-11-25T14:25:12.663Z 2025-12-02T15:13:00.691Z
8591753 8591753 20251124045048_EmVJX UK00CJ 2025-11-25T14:25:04.277Z 2025-12-02T15:13:00.325Z
8591633 8591633 20251124043747_1Agog UK00CJ 2025-11-25T14:24:40.659Z 2025-12-02T15:12:59.741Z
8591550 8591550 20251124042428_mked1 UK00CJ 2025-11-25T14:24:32.039Z 2025-12-02T15:12:59.341Z
8591263 8591263 20251124035625_LJrRh UK00CJ 2025-11-25T14:23:48.410Z 2025-12-02T15:12:57.668Z
8591178 8591178 20251124035219_dfXv7 UK00CJ 2025-11-25T14:23:43.070Z 2025-12-02T15:12:57.276Z
8591152 8591152 20251124035027_jG42k UK00CJ 2025-11-25T14:23:41.679Z 2025-12-02T15:12:57.248Z
8591058 8591058 20251124034015_Tizac UK00CJ 2025-11-25T14:23:31.724Z 2025-12-02T15:12:56.827Z
8590900 8590900 20251124032616_S8dNq UK00CJ 2025-11-25T14:23:01.333Z 2025-12-02T15:12:56.039Z
8590816 8590816 20251124031502_pK4FR UK00CJ 2025-11-25T14:22:51.517Z 2025-12-02T15:12:55.595Z
8590548 8590548 20251124025216_nK02S UK00CJ 2025-11-25T14:22:12.380Z 2025-12-02T15:12:50.001Z
8590160 8590160 20251124022655_fkNrT UK00CJ 2025-11-25T14:21:29.952Z 2025-12-02T15:12:43.057Z
8589747 8589747 20251124015126_IWkfl UK00CJ 2025-11-25T14:20:28.550Z 2025-12-02T15:12:35.401Z
8589651 8589651 20251124014513_nOATT UK00CJ 2025-11-25T14:20:17.471Z 2025-12-02T15:12:33.070Z

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