participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
829 rows where station_code = "UK00C9" sorted by created_at descending
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 |
---|---|---|---|---|---|
5133956 | 5133956 | 20240916041943_1M8xr | UK00C9 | 2024-09-19T12:17:13.936Z | 2024-09-19T12:17:13.936Z |
5133755 | 5133755 | 20240916040217_ygZwe | UK00C9 | 2024-09-19T12:17:07.115Z | 2024-09-19T12:17:07.115Z |
5133620 | 5133620 | 20240916034757_pF1kR | UK00C9 | 2024-09-19T12:17:04.032Z | 2024-09-19T12:17:04.032Z |
5133592 | 5133592 | 20240916034347_yD1uN | UK00C9 | 2024-09-19T12:17:02.662Z | 2024-09-19T12:17:02.662Z |
5133541 | 5133541 | 20240916033728_ZSHXx | UK00C9 | 2024-09-19T12:17:00.939Z | 2024-09-19T12:17:00.939Z |
5133372 | 5133372 | 20240916032738_ALLtX | UK00C9 | 2024-09-19T12:16:55.567Z | 2024-09-19T12:16:55.567Z |
5133361 | 5133361 | 20240916032711_nyjfs | UK00C9 | 2024-09-19T12:16:55.473Z | 2024-09-19T12:16:55.473Z |
5133300 | 5133300 | 20240916031952_x33a5 | UK00C9 | 2024-09-19T12:16:53.502Z | 2024-09-19T12:16:53.502Z |
5133278 | 5133278 | 20240916031739_7C8GB | UK00C9 | 2024-09-19T12:16:52.484Z | 2024-09-19T12:16:52.484Z |
5133218 | 5133218 | 20240916030722_sFNPr | UK00C9 | 2024-09-19T12:16:49.281Z | 2024-09-19T12:16:49.281Z |
5133186 | 5133186 | 20240916030517_Oo5MM | UK00C9 | 2024-09-19T12:16:47.734Z | 2024-09-19T12:16:47.734Z |
5133149 | 5133149 | 20240916030234_yK8Ag | UK00C9 | 2024-09-19T12:16:45.726Z | 2024-09-19T12:16:45.726Z |
5132969 | 5132969 | 20240916023747_fw1Qo | UK00C9 | 2024-09-19T12:16:39.606Z | 2024-09-19T12:16:39.606Z |
5132959 | 5132959 | 20240916023508_PtRVE | UK00C9 | 2024-09-19T12:16:38.853Z | 2024-09-19T12:16:38.853Z |
5132922 | 5132922 | 20240916022850_E6Oav | UK00C9 | 2024-09-19T12:16:35.911Z | 2024-09-19T12:16:35.911Z |
5132637 | 5132637 | 20240916014845_I49PP | UK00C9 | 2024-09-19T12:16:23.745Z | 2024-09-19T12:16:23.745Z |
5132346 | 5132346 | 20240916004313_5h5ze | UK00C9 | 2024-09-19T12:16:08.493Z | 2024-09-19T12:16:08.493Z |
5132129 | 5132129 | 20240915232941_OyhmO | UK00C9 | 2024-09-19T12:15:51.515Z | 2024-09-19T12:15:51.515Z |
5132125 | 5132125 | 20240915232703_278XQ | UK00C9 | 2024-09-19T12:15:51.368Z | 2024-09-19T12:15:51.368Z |
5132055 | 5132055 | 20240915225744_eOKkS | UK00C9 | 2024-09-19T12:15:46.649Z | 2024-09-19T12:15:46.649Z |
5132021 | 5132021 | 20240915224843_JvzYU | UK00C9 | 2024-09-19T12:15:43.933Z | 2024-09-19T12:15:43.933Z |
5129865 | 5129865 | 20240917044638_fk6yF | UK00C9 | 2024-09-19T12:12:11.261Z | 2024-09-19T12:12:11.261Z |
5129789 | 5129789 | 20240917042906_nevS9 | UK00C9 | 2024-09-19T12:12:04.758Z | 2024-09-19T12:12:04.758Z |
5129665 | 5129665 | 20240917042119_UWnWe | UK00C9 | 2024-09-19T12:12:00.122Z | 2024-09-19T12:12:00.122Z |
5129362 | 5129362 | 20240917035147_2hg6T | UK00C9 | 2024-09-19T12:11:32.359Z | 2024-09-19T12:11:32.359Z |
5129302 | 5129302 | 20240917034630_6Zgnr | UK00C9 | 2024-09-19T12:11:26.313Z | 2024-09-19T12:11:26.313Z |
5128932 | 5128932 | 20240917025710_dO20e | UK00C9 | 2024-09-19T12:11:07.994Z | 2024-09-19T12:11:07.994Z |
5128598 | 5128598 | 20240917020759_7vm3g | UK00C9 | 2024-09-19T12:10:46.472Z | 2024-09-19T12:10:46.472Z |
5128564 | 5128564 | 20240917020349_oJXd2 | UK00C9 | 2024-09-19T12:10:43.531Z | 2024-09-19T12:10:43.531Z |
5128424 | 5128424 | 20240917014109_8t1tx | UK00C9 | 2024-09-19T12:10:33.760Z | 2024-09-19T12:10:33.760Z |
5128261 | 5128261 | 20240917010944_y4nji | UK00C9 | 2024-09-19T12:10:21.933Z | 2024-09-19T12:10:21.933Z |
5128126 | 5128126 | 20240917004455_n4RJX | UK00C9 | 2024-09-19T12:10:07.447Z | 2024-09-19T12:10:07.447Z |
5127980 | 5127980 | 20240917001543_z3xIM | UK00C9 | 2024-09-19T12:09:51.875Z | 2024-09-19T12:09:51.875Z |
5127969 | 5127969 | 20240917001114_tyHjc | UK00C9 | 2024-09-19T12:09:49.525Z | 2024-09-19T12:09:49.525Z |
5127738 | 5127738 | 20240916231523_C4vek | UK00C9 | 2024-09-19T12:09:34.971Z | 2024-09-19T12:09:34.971Z |
5127577 | 5127577 | 20240916223009_dCnVN | UK00C9 | 2024-09-19T12:09:24.257Z | 2024-09-19T12:09:24.257Z |
5127309 | 5127309 | 20240916212130_LoVlA | UK00C9 | 2024-09-19T12:08:49.488Z | 2024-09-19T12:08:49.488Z |
5127237 | 5127237 | 20240916210113_k9M0R | UK00C9 | 2024-09-19T12:08:36.884Z | 2024-09-19T12:08:36.884Z |
5127193 | 5127193 | 20240916205107_WsenZ | UK00C9 | 2024-09-19T12:08:29.555Z | 2024-09-19T12:08:29.555Z |
5125151 | 5125151 | 20240918003320_5ZH52 | UK00C9 | 2024-09-19T12:02:24.057Z | 2024-09-19T12:06:41.982Z |
5125141 | 5125141 | 20240918002709_LJepw | UK00C9 | 2024-09-19T12:02:23.341Z | 2024-09-19T12:06:41.981Z |
5125053 | 5125053 | 20240917235057_vWFUY | UK00C9 | 2024-09-19T12:02:03.105Z | 2024-09-19T12:06:41.968Z |
5125050 | 5125050 | 20240917235024_lJLR6 | UK00C9 | 2024-09-19T12:02:02.599Z | 2024-09-19T12:06:41.967Z |
5125046 | 5125046 | 20240917234923_b4Xu6 | UK00C9 | 2024-09-19T12:02:01.460Z | 2024-09-19T12:06:41.966Z |
5124959 | 5124959 | 20240917230354_CpyXo | UK00C9 | 2024-09-19T12:01:51.273Z | 2024-09-19T12:06:41.956Z |
5124955 | 5124955 | 20240917230127_mRKp2 | UK00C9 | 2024-09-19T12:01:50.890Z | 2024-09-19T12:06:41.956Z |
5124949 | 5124949 | 20240917225608_CRlD2 | UK00C9 | 2024-09-19T12:01:50.474Z | 2024-09-19T12:06:41.955Z |
5124804 | 5124804 | 20240917220341_25iBX | UK00C9 | 2024-09-19T12:01:35.833Z | 2024-09-19T12:06:41.936Z |
5124793 | 5124793 | 20240917220112_DZ7h4 | UK00C9 | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124710 | 5124710 | 20240917215057_8SuHw | UK00C9 | 2024-09-19T12:01:21.598Z | 2024-09-19T12:06:41.927Z |
5124686 | 5124686 | 20240917214723_Gu1OG | UK00C9 | 2024-09-19T12:01:19.282Z | 2024-09-19T12:06:41.924Z |
5124573 | 5124573 | 20240917211327_fRJG0 | UK00C9 | 2024-09-19T12:01:09.248Z | 2024-09-19T12:06:41.912Z |
5124445 | 5124445 | 20240917202117_SRq2Q | UK00C9 | 2024-09-19T12:00:56.024Z | 2024-09-19T12:06:41.895Z |
5122141 | 5122141 | 20240914043824_gRWOa | UK00C9 | 2024-09-18T12:11:07.613Z | 2024-09-19T12:20:02.863Z |
5121865 | 5121865 | 20240914041723_hHZoX | UK00C9 | 2024-09-18T12:11:02.358Z | 2024-09-19T12:20:02.447Z |
5121615 | 5121615 | 20240914041027_ZjFMf | UK00C9 | 2024-09-18T12:10:58.865Z | 2024-09-19T12:20:02.185Z |
5116640 | 5116640 | 20240915033354_YOEmr | UK00C9 | 2024-09-18T12:07:14.186Z | 2024-09-19T12:19:11.804Z |
5116628 | 5116628 | 20240915033346_gv04B | UK00C9 | 2024-09-18T12:07:12.506Z | 2024-09-19T12:19:11.695Z |
5116252 | 5116252 | 20240915031804_0fR6w | UK00C9 | 2024-09-18T12:06:51.127Z | 2024-09-19T12:19:09.970Z |
5116079 | 5116079 | 20240915030714_6Cyyw | UK00C9 | 2024-09-18T12:06:37.765Z | 2024-09-19T12:19:08.416Z |
5115866 | 5115866 | 20240915025624_ZUmTm | UK00C9 | 2024-09-18T12:06:29.366Z | 2024-09-19T12:19:07.574Z |
5115726 | 5115726 | 20240915025047_8SkHQ | UK00C9 | 2024-09-18T12:06:22.019Z | 2024-09-19T12:19:06.513Z |
5115304 | 5115304 | 20240915023127_M3S08 | UK00C9 | 2024-09-18T12:06:10.388Z | 2024-09-19T12:19:03.788Z |
5115259 | 5115259 | 20240915022936_s2kn1 | UK00C9 | 2024-09-18T12:06:08.278Z | 2024-09-19T12:19:03.435Z |
5115025 | 5115025 | 20240915021429_Tw1L2 | UK00C9 | 2024-09-18T12:05:51.095Z | 2024-09-19T12:19:01.161Z |
5114960 | 5114960 | 20240915021010_SS8FK | UK00C9 | 2024-09-18T12:05:46.531Z | 2024-09-19T12:19:00.870Z |
5113747 | 5113747 | 20240915011104_fXah3 | UK00C9 | 2024-09-18T12:04:48.698Z | 2024-09-19T12:18:51.810Z |
5108282 | 5108282 | 20240913043838_875oU | UK00C9 | 2024-09-17T12:13:34.587Z | 2024-09-19T12:20:47.991Z |
5108133 | 5108133 | 20240913042431_77a6a | UK00C9 | 2024-09-17T12:13:30.924Z | 2024-09-19T12:20:47.857Z |
5107975 | 5107975 | 20240913041734_VcH2G | UK00C9 | 2024-09-17T12:13:26.559Z | 2024-09-19T12:20:47.703Z |
5107468 | 5107468 | 20240913035738_DTVj0 | UK00C9 | 2024-09-17T12:13:15.823Z | 2024-09-19T12:20:47.166Z |
5107342 | 5107342 | 20240913035258_hNvZE | UK00C9 | 2024-09-17T12:13:13.458Z | 2024-09-19T12:20:47.004Z |
5106947 | 5106947 | 20240913033935_mEuFX | UK00C9 | 2024-09-17T12:13:04.497Z | 2024-09-19T12:20:46.592Z |
5106086 | 5106086 | 20240913031003_YQISS | UK00C9 | 2024-09-17T12:12:41.862Z | 2024-09-19T12:20:45.476Z |
5105911 | 5105911 | 20240913030246_y664z | UK00C9 | 2024-09-17T12:12:32.462Z | 2024-09-19T12:20:45.047Z |
5105879 | 5105879 | 20240913030123_MaHwe | UK00C9 | 2024-09-17T12:12:31.279Z | 2024-09-19T12:20:45.007Z |
5105818 | 5105818 | 20240913025934_c76Lk | UK00C9 | 2024-09-17T12:12:29.925Z | 2024-09-19T12:20:44.965Z |
5105612 | 5105612 | 20240913025303_QHYDa | UK00C9 | 2024-09-17T12:12:23.394Z | 2024-09-19T12:20:44.720Z |
5105075 | 5105075 | 20240913022912_8OVX2 | UK00C9 | 2024-09-17T12:11:52.624Z | 2024-09-19T12:20:43.461Z |
5104827 | 5104827 | 20240913022148_1xM2P | UK00C9 | 2024-09-17T12:11:45.170Z | 2024-09-19T12:20:42.918Z |
5104589 | 5104589 | 20240913021608_X6kAk | UK00C9 | 2024-09-17T12:11:40.204Z | 2024-09-19T12:20:42.527Z |
5104586 | 5104586 | 20240913021556_ewyvg | UK00C9 | 2024-09-17T12:11:40.059Z | 2024-09-19T12:20:42.523Z |
5104327 | 5104327 | 20240913020509_RlMJz | UK00C9 | 2024-09-17T12:11:33.182Z | 2024-09-19T12:20:41.364Z |
5104247 | 5104247 | 20240913020031_nn23K | UK00C9 | 2024-09-17T12:11:30.646Z | 2024-09-19T12:20:41.281Z |
5104238 | 5104238 | 20240913020001_fng58 | UK00C9 | 2024-09-17T12:11:30.209Z | 2024-09-19T12:20:41.271Z |
5104179 | 5104179 | 20240913015718_5uZh2 | UK00C9 | 2024-09-17T12:11:28.498Z | 2024-09-19T12:20:41.193Z |
5104011 | 5104011 | 20240913014710_Rac2v | UK00C9 | 2024-09-17T12:11:21.845Z | 2024-09-19T12:20:40.824Z |
5100155 | 5100155 | 20240913225819_q2ipC | UK00C9 | 2024-09-17T12:04:04.135Z | 2024-09-19T12:19:47.049Z |
5099982 | 5099982 | 20240913222943_F9HlP | UK00C9 | 2024-09-17T12:03:47.544Z | 2024-09-19T12:19:46.633Z |
5097745 | 5097745 | 20240913010027_vBlOm | UK00C9 | 2024-09-16T12:17:14.276Z | 2024-09-19T12:20:38.928Z |
5097500 | 5097500 | 20240913005148_l6Qiu | UK00C9 | 2024-09-16T12:17:12.983Z | 2024-09-19T12:20:38.659Z |
5097372 | 5097372 | 20240913004424_PJOJd | UK00C9 | 2024-09-16T12:17:11.754Z | 2024-09-19T12:20:38.445Z |
5097296 | 5097296 | 20240913003832_Ye3ds | UK00C9 | 2024-09-16T12:17:09.388Z | 2024-09-19T12:20:38.026Z |
5097220 | 5097220 | 20240913003702_mc0UT | UK00C9 | 2024-09-16T12:17:08.445Z | 2024-09-19T12:20:37.911Z |
5094795 | 5094795 | 20240912042312_KQfgV | UK00C9 | 2024-09-16T12:14:58.643Z | 2024-09-19T12:21:16.432Z |
5094551 | 5094551 | 20240912040922_twCts | UK00C9 | 2024-09-16T12:14:51.122Z | 2024-09-19T12:21:16.244Z |
5093815 | 5093815 | 20240912033802_Iw2L3 | UK00C9 | 2024-09-16T12:14:26.053Z | 2024-09-19T12:21:15.670Z |
5093807 | 5093807 | 20240912033719_ta3i0 | UK00C9 | 2024-09-16T12:14:25.763Z | 2024-09-19T12:21:15.663Z |
5093800 | 5093800 | 20240912033642_heALU | UK00C9 | 2024-09-16T12:14:25.720Z | 2024-09-19T12:21:15.661Z |
5093488 | 5093488 | 20240912032416_GPhfk | UK00C9 | 2024-09-16T12:14:18.684Z | 2024-09-19T12:21:15.372Z |
Advanced export
JSON shape: default, array, newline-delimited
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);