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

4,683 rows where station_code = "UK00C9" 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
9611604 9611604 20260405024651_ZgFsd UK00C9 2026-04-06T12:15:15.877Z 2026-04-06T12:16:14.831Z
9608689 9608689 20260404004459_3XJ50 UK00C9 2026-04-05T12:11:18.037Z 2026-04-06T12:20:30.849Z
9608627 9608627 20260404000215_UazG0 UK00C9 2026-04-05T12:11:01.941Z 2026-04-06T12:20:26.935Z
9608540 9608540 20260403233238_eK4nX UK00C9 2026-04-05T12:10:46.406Z 2026-04-06T12:20:19.282Z
9608406 9608406 20260403225849_ezHtU UK00C9 2026-04-05T12:10:22.106Z 2026-04-06T12:20:11.216Z
9608363 9608363 20260403223154_IERbU UK00C9 2026-04-05T12:10:14.199Z 2026-04-06T12:20:08.360Z
9608273 9608273 20260403212845_daQXC UK00C9 2026-04-05T12:09:52.668Z 2026-04-06T12:20:03.079Z
9608270 9608270 20260403212753_bhoYp UK00C9 2026-04-05T12:09:52.216Z 2026-04-06T12:20:02.880Z
9608237 9608237 20260403211108_s67Ww UK00C9 2026-04-05T12:09:38.784Z 2026-04-06T12:19:59.875Z
9608233 9608233 20260403210909_8sPq4 UK00C9 2026-04-05T12:09:38.122Z 2026-04-06T12:19:59.094Z
9604703 9604703 20260401235521_LRxQC UK00C9 2026-04-03T12:11:17.613Z 2026-04-06T12:26:12.639Z
9604701 9604701 20260401235416_UPyFW UK00C9 2026-04-03T12:11:17.194Z 2026-04-06T12:26:12.493Z
9604626 9604626 20260401222924_onYYC UK00C9 2026-04-03T12:10:54.891Z 2026-04-06T12:26:07.746Z
9598336 9598336 20260329224753_35yZg UK00C9 2026-03-31T12:10:20.906Z 2026-04-06T12:36:25.663Z
9594635 9594635 20260328233756_T23TM UK00C9 2026-03-30T12:10:00.965Z 2026-04-06T12:40:02.047Z
9594601 9594601 20260328232537_Kgmdm UK00C9 2026-03-30T12:09:56.613Z 2026-04-06T12:40:01.117Z
9590070 9590070 20260328044527_ZAn1i UK00C9 2026-03-29T12:01:57.056Z 2026-04-06T12:37:49.343Z
9589906 9589906 20260328041748_Cc0DN UK00C9 2026-03-29T12:01:43.027Z 2026-04-06T12:37:37.608Z
9589862 9589862 20260328041138_OPIPt UK00C9 2026-03-29T12:01:40.767Z 2026-04-06T12:37:36.457Z
9584455 9584455 20260325195533_3dO4p UK00C9 2026-03-27T12:15:21.225Z 2026-04-03T12:39:14.666Z
9581974 9581974 20260326041812_0hVeF UK00C9 2026-03-27T12:04:18.546Z 2026-04-04T12:39:33.556Z
9581342 9581342 20260326025512_RwB3s UK00C9 2026-03-27T12:02:47.794Z 2026-04-04T12:38:53.390Z
9571102 9571102 20260322234512_0WTgQ UK00C9 2026-03-24T12:24:20.552Z 2026-03-30T12:30:55.170Z
9570960 9570960 20260322232307_d6q3X UK00C9 2026-03-24T12:24:05.068Z 2026-03-30T12:30:52.832Z
9570947 9570947 20260322232024_Y3pV8 UK00C9 2026-03-24T12:24:03.971Z 2026-03-30T12:30:52.562Z
9561886 9561886 20260323005242_wf1z0 UK00C9 2026-03-24T12:01:30.932Z 2026-03-31T12:25:55.621Z
9561716 9561716 20260323003241_jeGQ1 UK00C9 2026-03-24T12:01:03.262Z 2026-03-31T12:25:51.702Z
9561503 9561503 20260322235400_K0W1Q UK00C9 2026-03-24T12:00:12.443Z 2026-03-31T12:25:45.469Z
9561472 9561472 20260321233804_NdLMi UK00C9 2026-03-23T12:12:20.021Z 2026-03-29T12:21:07.518Z
9561377 9561377 20260321232626_HG3c4 UK00C9 2026-03-23T12:12:17.714Z 2026-03-29T12:21:06.805Z
9560539 9560539 20260321213749_LQVKJ UK00C9 2026-03-23T12:11:51.209Z 2026-03-29T12:21:01.150Z
9560448 9560448 20260321212519_HJd0t UK00C9 2026-03-23T12:11:47.414Z 2026-03-29T12:21:00.298Z
9559850 9559850 20260321200157_nvpeH UK00C9 2026-03-23T12:11:31.979Z 2026-03-29T12:20:56.085Z
9555413 9555413 20260322044950_j56uh UK00C9 2026-03-23T12:03:24.467Z 2026-03-30T12:28:26.109Z
9554938 9554938 20260322034613_bBE3F UK00C9 2026-03-23T12:02:57.410Z 2026-03-30T12:28:11.854Z
9554458 9554458 20260322031131_kLynh UK00C9 2026-03-23T12:02:33.507Z 2026-03-30T12:28:04.198Z
9554160 9554160 20260322024407_AF82q UK00C9 2026-03-23T12:02:17.431Z 2026-03-30T12:27:59.451Z
9553990 9553990 20260322023008_IzhMY UK00C9 2026-03-23T12:02:04.925Z 2026-03-30T12:27:56.403Z
9553779 9553779 20260322021301_KfKho UK00C9 2026-03-23T12:01:51.339Z 2026-03-30T12:27:52.440Z
9553339 9553339 20260322013144_r1lAU UK00C9 2026-03-23T12:01:24.545Z 2026-03-30T12:27:39.556Z
9553112 9553112 20260322011453_o6HiA UK00C9 2026-03-23T12:01:13.814Z 2026-03-30T12:27:35.195Z
9552740 9552740 20260322003817_ASO9R UK00C9 2026-03-23T12:00:47.739Z 2026-03-30T12:27:29.313Z
9552636 9552636 20260322002508_ldDiX UK00C9 2026-03-23T12:00:38.504Z 2026-03-30T12:27:27.273Z
9542599 9542599 20260321002207_Akuld UK00C9 2026-03-22T12:00:55.143Z 2026-03-29T12:18:46.319Z
9542137 9542137 20260319224925_pO221 UK00C9 2026-03-21T12:29:42.149Z 2026-03-27T12:42:45.753Z
9542083 9542083 20260319224751_16XbN UK00C9 2026-03-21T12:29:39.503Z 2026-03-27T12:42:45.107Z
9542060 9542060 20260319224611_9M2Dw UK00C9 2026-03-21T12:29:38.571Z 2026-03-27T12:42:44.847Z
9541887 9541887 20260319220051_wevVD UK00C9 2026-03-21T12:29:28.037Z 2026-03-27T12:42:42.727Z
9541831 9541831 20260319215509_6OF3v UK00C9 2026-03-21T12:29:25.144Z 2026-03-27T12:42:42.255Z
9541699 9541699 20260319212814_7zp0Q UK00C9 2026-03-21T12:29:17.079Z 2026-03-27T12:42:40.927Z
9541564 9541564 20260319210409_Dq83P UK00C9 2026-03-21T12:29:10.709Z 2026-03-27T12:42:38.739Z
9541449 9541449 20260319203923_SJudG UK00C9 2026-03-21T12:28:56.901Z 2026-03-27T12:42:37.737Z
9535010 9535010 20260320050328_fpGpJ UK00C9 2026-03-21T12:09:28.784Z 2026-03-28T12:34:25.314Z
9534974 9534974 20260320045124_eSqhP UK00C9 2026-03-21T12:09:21.555Z 2026-03-28T12:34:24.446Z
9534960 9534960 20260320044806_YCvW5 UK00C9 2026-03-21T12:09:18.276Z 2026-03-28T12:34:24.130Z
9534928 9534928 20260320044141_2zApt UK00C9 2026-03-21T12:09:11.597Z 2026-03-28T12:34:23.604Z
9534838 9534838 20260320042917_8QcH7 UK00C9 2026-03-21T12:09:00.654Z 2026-03-28T12:34:22.750Z
9534804 9534804 20260320042631_Xrvxu UK00C9 2026-03-21T12:08:56.691Z 2026-03-28T12:34:22.308Z
9534704 9534704 20260320041421_MbJHE UK00C9 2026-03-21T12:08:40.909Z 2026-03-28T12:34:21.126Z
9534517 9534517 20260320035730_IrqqO UK00C9 2026-03-21T12:08:11.253Z 2026-03-28T12:34:18.995Z
9534451 9534451 20260320035016_cxtRV UK00C9 2026-03-21T12:08:02.008Z 2026-03-28T12:34:18.445Z
9534108 9534108 20260320032517_AlR3G UK00C9 2026-03-21T12:07:09.227Z 2026-03-28T12:34:13.813Z
9534007 9534007 20260320031709_ZJqrs UK00C9 2026-03-21T12:06:53.760Z 2026-03-28T12:34:03.539Z
9533965 9533965 20260320031119_HHPgA UK00C9 2026-03-21T12:06:46.441Z 2026-03-28T12:34:02.866Z
9533880 9533880 20260320030700_YpHUA UK00C9 2026-03-21T12:06:32.827Z 2026-03-28T12:34:01.801Z
9533766 9533766 20260320025607_xvsct UK00C9 2026-03-21T12:06:13.567Z 2026-03-28T12:34:00.303Z
9533395 9533395 20260320022732_d7Gf7 UK00C9 2026-03-21T12:05:20.535Z 2026-03-28T12:33:52.682Z
9533371 9533371 20260320022606_PR29b UK00C9 2026-03-21T12:05:16.562Z 2026-03-28T12:33:52.472Z
9533278 9533278 20260320022130_ITdtO UK00C9 2026-03-21T12:05:01.000Z 2026-03-28T12:33:51.382Z
9533037 9533037 20260320015206_toP6c UK00C9 2026-03-21T12:04:16.629Z 2026-03-28T12:33:47.959Z
9532747 9532747 20260320012124_8Kv65 UK00C9 2026-03-21T12:03:29.909Z 2026-03-28T12:33:35.719Z
9532694 9532694 20260320011800_i8ET1 UK00C9 2026-03-21T12:03:23.983Z 2026-03-28T12:33:35.202Z
9532559 9532559 20260320010632_S83TM UK00C9 2026-03-21T12:03:03.439Z 2026-03-28T12:33:33.875Z
9532476 9532476 20260320010112_2eq3v UK00C9 2026-03-21T12:02:51.606Z 2026-03-28T12:33:32.205Z
9532255 9532255 20260320004129_9r6Dk UK00C9 2026-03-21T12:02:10.589Z 2026-03-28T12:33:26.267Z
9532113 9532113 20260320002024_o3Mjw UK00C9 2026-03-21T12:01:44.584Z 2026-03-28T12:33:24.674Z
9532044 9532044 20260320001300_JDCMQ UK00C9 2026-03-21T12:01:33.726Z 2026-03-28T12:33:24.185Z
9531991 9531991 20260320000643_pqlgP UK00C9 2026-03-21T12:01:21.041Z 2026-03-28T12:33:23.443Z
9531916 9531916 20260320000138_2X9TG UK00C9 2026-03-21T12:01:11.219Z 2026-03-28T12:33:22.780Z
9531721 9531721 20260319233733_nHcjD UK00C9 2026-03-21T12:00:37.072Z 2026-03-28T12:33:20.716Z
9531472 9531472 20260318231449_wwXNi UK00C9 2026-03-20T12:25:19.877Z 2026-03-26T12:39:19.661Z
9531300 9531300 20260318225528_zAD88 UK00C9 2026-03-20T12:25:05.668Z 2026-03-26T12:39:18.641Z
9530809 9530809 20260318214448_cP823 UK00C9 2026-03-20T12:24:47.766Z 2026-03-26T12:39:15.705Z
9530640 9530640 20260318211944_Kqsq6 UK00C9 2026-03-20T12:24:33.709Z 2026-03-26T12:39:14.516Z
9521980 9521980 20260319050626_or1m8 UK00C9 2026-03-20T12:08:48.082Z 2026-03-27T12:41:12.368Z
9521753 9521753 20260319044135_5OE1t UK00C9 2026-03-20T12:08:30.115Z 2026-03-27T12:41:10.474Z
9521666 9521666 20260319043215_z2oYQ UK00C9 2026-03-20T12:08:21.979Z 2026-03-27T12:40:57.333Z
9521466 9521466 20260319041831_837jl UK00C9 2026-03-20T12:08:02.793Z 2026-03-27T12:40:54.962Z
9521264 9521264 20260319040102_ijFuB UK00C9 2026-03-20T12:07:46.375Z 2026-03-27T12:40:53.199Z
9521198 9521198 20260319035644_3YCBY UK00C9 2026-03-20T12:07:40.998Z 2026-03-27T12:40:52.478Z
9520645 9520645 20260319032943_FdXy3 UK00C9 2026-03-20T12:06:44.375Z 2026-03-27T12:40:45.863Z
9520582 9520582 20260319032642_NAR3e UK00C9 2026-03-20T12:06:35.838Z 2026-03-27T12:40:45.055Z
9520529 9520529 20260319032144_i8yKZ UK00C9 2026-03-20T12:06:30.189Z 2026-03-27T12:40:44.385Z
9520334 9520334 20260319031029_SmG3T UK00C9 2026-03-20T12:06:14.504Z 2026-03-27T12:40:42.094Z
9520304 9520304 20260319030937_L7mfQ UK00C9 2026-03-20T12:06:12.436Z 2026-03-27T12:40:41.874Z
9520200 9520200 20260319030208_1dm77 UK00C9 2026-03-20T12:05:57.571Z 2026-03-27T12:40:40.441Z
9519783 9519783 20260319023540_49dk7 UK00C9 2026-03-20T12:05:06.093Z 2026-03-27T12:40:35.531Z
9519611 9519611 20260319022227_Goir9 UK00C9 2026-03-20T12:04:44.310Z 2026-03-27T12:40:33.286Z
9519493 9519493 20260319021326_whGoJ UK00C9 2026-03-20T12:04:33.063Z 2026-03-27T12:40:31.764Z
9519370 9519370 20260319020524_FHams UK00C9 2026-03-20T12:04:22.587Z 2026-03-27T12:40:29.212Z

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