participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,154 rows where station_code = "UK00BC" 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 |
---|---|---|---|---|---|
5133968 | 5133968 | 20240916042310_YEvo7 | UK00BC | 2024-09-19T12:17:14.523Z | 2024-09-19T12:17:14.523Z |
5133825 | 5133825 | 20240916040759_zX1NI | UK00BC | 2024-09-19T12:17:10.039Z | 2024-09-19T12:17:10.039Z |
5133774 | 5133774 | 20240916040459_6QbTj | UK00BC | 2024-09-19T12:17:07.501Z | 2024-09-19T12:17:07.501Z |
5133715 | 5133715 | 20240916035225_gJ1M7 | UK00BC | 2024-09-19T12:17:05.732Z | 2024-09-19T12:17:05.732Z |
5133685 | 5133685 | 20240916035019_gZBwP | UK00BC | 2024-09-19T12:17:05.213Z | 2024-09-19T12:17:05.213Z |
5133506 | 5133506 | 20240916033352_DmaLk | UK00BC | 2024-09-19T12:17:00.003Z | 2024-09-19T12:17:00.003Z |
5133454 | 5133454 | 20240916033115_QuT23 | UK00BC | 2024-09-19T12:16:57.046Z | 2024-09-19T12:16:57.046Z |
5133418 | 5133418 | 20240916032947_7LIC4 | UK00BC | 2024-09-19T12:16:56.221Z | 2024-09-19T12:16:56.221Z |
5133356 | 5133356 | 20240916032537_pPKM3 | UK00BC | 2024-09-19T12:16:55.146Z | 2024-09-19T12:16:55.146Z |
5133243 | 5133243 | 20240916031216_Py6bX | UK00BC | 2024-09-19T12:16:51.137Z | 2024-09-19T12:16:51.137Z |
5133145 | 5133145 | 20240916030148_31ILJ | UK00BC | 2024-09-19T12:16:45.587Z | 2024-09-19T12:16:45.587Z |
5133069 | 5133069 | 20240916025009_HCY9p | UK00BC | 2024-09-19T12:16:43.348Z | 2024-09-19T12:16:43.348Z |
5132829 | 5132829 | 20240916021859_cSIb1 | UK00BC | 2024-09-19T12:16:33.961Z | 2024-09-19T12:16:33.961Z |
5132426 | 5132426 | 20240916010512_5lgHa | UK00BC | 2024-09-19T12:16:12.018Z | 2024-09-19T12:16:12.018Z |
5129537 | 5129537 | 20240917040653_eQ8ua | UK00BC | 2024-09-19T12:11:47.573Z | 2024-09-19T12:11:47.573Z |
5129531 | 5129531 | 20240917040642_BTzLE | UK00BC | 2024-09-19T12:11:46.966Z | 2024-09-19T12:11:46.966Z |
5129279 | 5129279 | 20240917034447_B8XFi | UK00BC | 2024-09-19T12:11:25.328Z | 2024-09-19T12:11:25.328Z |
5129194 | 5129194 | 20240917033545_hH0PQ | UK00BC | 2024-09-19T12:11:22.818Z | 2024-09-19T12:11:22.818Z |
5128266 | 5128266 | 20240917011136_6GJGM | UK00BC | 2024-09-19T12:10:22.338Z | 2024-09-19T12:10:22.338Z |
5121928 | 5121928 | 20240914042121_Ge34S | UK00BC | 2024-09-18T12:11:03.077Z | 2024-09-19T12:20:02.520Z |
5121917 | 5121917 | 20240914042121_KCxWZ | UK00BC | 2024-09-18T12:11:03.012Z | 2024-09-19T12:20:02.510Z |
5121606 | 5121606 | 20240914041024_2woyK | UK00BC | 2024-09-18T12:10:58.859Z | 2024-09-19T12:20:02.183Z |
5121404 | 5121404 | 20240914035911_Tv6J3 | UK00BC | 2024-09-18T12:10:54.723Z | 2024-09-19T12:20:01.708Z |
5121182 | 5121182 | 20240914035440_zfJJC | UK00BC | 2024-09-18T12:10:52.106Z | 2024-09-19T12:20:01.464Z |
5120979 | 5120979 | 20240914034301_pu1Yj | UK00BC | 2024-09-18T12:10:48.931Z | 2024-09-19T12:20:01.080Z |
5120794 | 5120794 | 20240914033528_eFpzL | UK00BC | 2024-09-18T12:10:46.694Z | 2024-09-19T12:20:00.858Z |
5120783 | 5120783 | 20240914033522_Iae8b | UK00BC | 2024-09-18T12:10:46.657Z | 2024-09-19T12:20:00.856Z |
5120736 | 5120736 | 20240914033304_2dWFf | UK00BC | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120612 | 5120612 | 20240914032953_cRQIp | UK00BC | 2024-09-18T12:10:43.633Z | 2024-09-19T12:20:00.629Z |
5120567 | 5120567 | 20240914032801_Gq8pV | UK00BC | 2024-09-18T12:10:43.124Z | 2024-09-19T12:20:00.565Z |
5120070 | 5120070 | 20240914025821_3O2iZ | UK00BC | 2024-09-18T12:10:31.620Z | 2024-09-19T12:19:59.363Z |
5120017 | 5120017 | 20240914025625_lO87G | UK00BC | 2024-09-18T12:10:31.070Z | 2024-09-19T12:19:59.301Z |
5119956 | 5119956 | 20240914025435_342zJ | UK00BC | 2024-09-18T12:10:29.912Z | 2024-09-19T12:19:59.188Z |
5119716 | 5119716 | 20240914024413_3Swqf | UK00BC | 2024-09-18T12:10:24.383Z | 2024-09-19T12:19:58.781Z |
5119608 | 5119608 | 20240914023959_ZZWNM | UK00BC | 2024-09-18T12:10:22.569Z | 2024-09-19T12:19:58.560Z |
5119546 | 5119546 | 20240914023837_UfZw2 | UK00BC | 2024-09-18T12:10:22.187Z | 2024-09-19T12:19:58.485Z |
5119472 | 5119472 | 20240914023600_2u6WP | UK00BC | 2024-09-18T12:10:21.526Z | 2024-09-19T12:19:58.286Z |
5119419 | 5119419 | 20240914023143_BcW4W | UK00BC | 2024-09-18T12:10:20.841Z | 2024-09-19T12:19:58.123Z |
5119252 | 5119252 | 20240914021832_IPZrP | UK00BC | 2024-09-18T12:10:18.774Z | 2024-09-19T12:19:57.474Z |
5117348 | 5117348 | 20240915041928_38V2e | UK00BC | 2024-09-18T12:07:38.065Z | 2024-09-19T12:19:14.339Z |
5117056 | 5117056 | 20240915035814_CY30F | UK00BC | 2024-09-18T12:07:30.917Z | 2024-09-19T12:19:13.192Z |
5116694 | 5116694 | 20240915033705_tV0ex | UK00BC | 2024-09-18T12:07:16.862Z | 2024-09-19T12:19:12.048Z |
5116664 | 5116664 | 20240915033422_KaH04 | UK00BC | 2024-09-18T12:07:14.905Z | 2024-09-19T12:19:11.859Z |
5116638 | 5116638 | 20240915033351_xECED | UK00BC | 2024-09-18T12:07:13.849Z | 2024-09-19T12:19:11.749Z |
5116562 | 5116562 | 20240915033128_ritA0 | UK00BC | 2024-09-18T12:07:09.643Z | 2024-09-19T12:19:11.512Z |
5116547 | 5116547 | 20240915033128_j9tT2 | UK00BC | 2024-09-18T12:07:09.413Z | 2024-09-19T12:19:11.508Z |
5115972 | 5115972 | 20240915030149_3haUb | UK00BC | 2024-09-18T12:06:32.859Z | 2024-09-19T12:19:08.005Z |
5115809 | 5115809 | 20240915025401_fOiNa | UK00BC | 2024-09-18T12:06:24.114Z | 2024-09-19T12:19:07.364Z |
5115775 | 5115775 | 20240915025324_p4Xgj | UK00BC | 2024-09-18T12:06:23.629Z | 2024-09-19T12:19:07.304Z |
5115606 | 5115606 | 20240915024537_rYGdT | UK00BC | 2024-09-18T12:06:18.701Z | 2024-09-19T12:19:05.603Z |
5115576 | 5115576 | 20240915024434_7N2Sy | UK00BC | 2024-09-18T12:06:17.831Z | 2024-09-19T12:19:05.367Z |
5115485 | 5115485 | 20240915024134_YdZw3 | UK00BC | 2024-09-18T12:06:15.888Z | 2024-09-19T12:19:04.990Z |
5115367 | 5115367 | 20240915023445_i6H0A | UK00BC | 2024-09-18T12:06:11.730Z | 2024-09-19T12:19:04.066Z |
5115321 | 5115321 | 20240915023131_Iwwwa | UK00BC | 2024-09-18T12:06:10.554Z | 2024-09-19T12:19:03.871Z |
5115185 | 5115185 | 20240915022436_Gozdm | UK00BC | 2024-09-18T12:06:05.081Z | 2024-09-19T12:19:02.744Z |
5115063 | 5115063 | 20240915021611_mquuu | UK00BC | 2024-09-18T12:05:54.953Z | 2024-09-19T12:19:01.285Z |
5115039 | 5115039 | 20240915021449_91apG | UK00BC | 2024-09-18T12:05:51.494Z | 2024-09-19T12:19:01.184Z |
5114736 | 5114736 | 20240915015715_XXfVt | UK00BC | 2024-09-18T12:05:32.268Z | 2024-09-19T12:18:59.675Z |
5114499 | 5114499 | 20240915014441_aDP0R | UK00BC | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.559Z |
5113770 | 5113770 | 20240915011105_IiwPt | UK00BC | 2024-09-18T12:04:49.297Z | 2024-09-19T12:18:51.854Z |
5113719 | 5113719 | 20240915010850_9SAIe | UK00BC | 2024-09-18T12:04:46.143Z | 2024-09-19T12:18:51.778Z |
5113642 | 5113642 | 20240915010131_ao2gb | UK00BC | 2024-09-18T12:04:35.808Z | 2024-09-19T12:18:50.699Z |
5113621 | 5113621 | 20240915010050_dCSql | UK00BC | 2024-09-18T12:04:35.194Z | 2024-09-19T12:18:50.617Z |
5113364 | 5113364 | 20240915003928_6K3G8 | UK00BC | 2024-09-18T12:04:09.826Z | 2024-09-19T12:18:48.598Z |
5113284 | 5113284 | 20240915003517_LfTxr | UK00BC | 2024-09-18T12:04:05.540Z | 2024-09-19T12:18:48.353Z |
5113257 | 5113257 | 20240915003259_1dwE3 | UK00BC | 2024-09-18T12:04:04.682Z | 2024-09-19T12:18:48.268Z |
5113186 | 5113186 | 20240915002938_qXRQf | UK00BC | 2024-09-18T12:04:01.170Z | 2024-09-19T12:18:47.819Z |
5112992 | 5112992 | 20240915001109_JKPUo | UK00BC | 2024-09-18T12:03:49.893Z | 2024-09-19T12:18:46.235Z |
5112965 | 5112965 | 20240915001108_I3lqt | UK00BC | 2024-09-18T12:03:49.752Z | 2024-09-19T12:18:46.054Z |
5112840 | 5112840 | 20240914235929_Bsfpi | UK00BC | 2024-09-18T12:03:41.582Z | 2024-09-19T12:18:45.232Z |
5112773 | 5112773 | 20240914235234_rzWgt | UK00BC | 2024-09-18T12:03:29.895Z | 2024-09-19T12:18:44.449Z |
5112735 | 5112735 | 20240914234642_5yMMA | UK00BC | 2024-09-18T12:03:25.778Z | 2024-09-19T12:18:43.749Z |
5108085 | 5108085 | 20240913042229_1fef9 | UK00BC | 2024-09-17T12:13:30.314Z | 2024-09-19T12:20:47.836Z |
5108031 | 5108031 | 20240913042031_D9G3s | UK00BC | 2024-09-17T12:13:28.327Z | 2024-09-19T12:20:47.751Z |
5107825 | 5107825 | 20240913041144_1s6ON | UK00BC | 2024-09-17T12:13:24.221Z | 2024-09-19T12:20:47.577Z |
5107781 | 5107781 | 20240913040937_NdYVv | UK00BC | 2024-09-17T12:13:23.555Z | 2024-09-19T12:20:47.533Z |
5107602 | 5107602 | 20240913040418_nyTHn | UK00BC | 2024-09-17T12:13:17.709Z | 2024-09-19T12:20:47.295Z |
5107534 | 5107534 | 20240913035852_195hD | UK00BC | 2024-09-17T12:13:16.650Z | 2024-09-19T12:20:47.208Z |
5107330 | 5107330 | 20240913035244_r9TG4 | UK00BC | 2024-09-17T12:13:13.233Z | 2024-09-19T12:20:47.002Z |
5107231 | 5107231 | 20240913034718_Uop2i | UK00BC | 2024-09-17T12:13:10.883Z | 2024-09-19T12:20:46.917Z |
5107119 | 5107119 | 20240913034502_w3gxO | UK00BC | 2024-09-17T12:13:09.360Z | 2024-09-19T12:20:46.842Z |
5106826 | 5106826 | 20240913033542_dZVWo | UK00BC | 2024-09-17T12:13:02.125Z | 2024-09-19T12:20:46.448Z |
5106746 | 5106746 | 20240913033306_XUFcm | UK00BC | 2024-09-17T12:13:00.091Z | 2024-09-19T12:20:46.304Z |
5106672 | 5106672 | 20240913033153_vdvis | UK00BC | 2024-09-17T12:12:59.343Z | 2024-09-19T12:20:46.269Z |
5106096 | 5106096 | 20240913031041_Kn2zk | UK00BC | 2024-09-17T12:12:41.991Z | 2024-09-19T12:20:45.481Z |
5105786 | 5105786 | 20240913025820_kNv3a | UK00BC | 2024-09-17T12:12:28.806Z | 2024-09-19T12:20:44.875Z |
5105631 | 5105631 | 20240913025352_cZDk8 | UK00BC | 2024-09-17T12:12:24.023Z | 2024-09-19T12:20:44.761Z |
5105400 | 5105400 | 20240913024401_kQYZT | UK00BC | 2024-09-17T12:12:12.478Z | 2024-09-19T12:20:44.391Z |
5105390 | 5105390 | 20240913024341_ZdaEM | UK00BC | 2024-09-17T12:12:12.327Z | 2024-09-19T12:20:44.388Z |
5105321 | 5105321 | 20240913024136_GZ2H1 | UK00BC | 2024-09-17T12:12:09.274Z | 2024-09-19T12:20:44.284Z |
5105199 | 5105199 | 20240913023720_AH0tJ | UK00BC | 2024-09-17T12:12:02.316Z | 2024-09-19T12:20:44.109Z |
5105001 | 5105001 | 20240913022617_oROyY | UK00BC | 2024-09-17T12:11:48.840Z | 2024-09-19T12:20:43.394Z |
5104954 | 5104954 | 20240913022446_Dmclr | UK00BC | 2024-09-17T12:11:47.351Z | 2024-09-19T12:20:43.130Z |
5104852 | 5104852 | 20240913022156_n3Bko | UK00BC | 2024-09-17T12:11:45.409Z | 2024-09-19T12:20:43.058Z |
5104788 | 5104788 | 20240913022109_NoJDj | UK00BC | 2024-09-17T12:11:44.558Z | 2024-09-19T12:20:42.881Z |
5104427 | 5104427 | 20240913020751_1LqQv | UK00BC | 2024-09-17T12:11:35.075Z | 2024-09-19T12:20:41.463Z |
5104284 | 5104284 | 20240913020159_43ImQ | UK00BC | 2024-09-17T12:11:31.539Z | 2024-09-19T12:20:41.307Z |
5103819 | 5103819 | 20240913014047_z3EeP | UK00BC | 2024-09-17T12:11:11.587Z | 2024-09-19T12:20:40.580Z |
5103675 | 5103675 | 20240913013551_Kikf3 | UK00BC | 2024-09-17T12:11:07.705Z | 2024-09-19T12:20:40.421Z |
5103573 | 5103573 | 20240913013227_p597S | UK00BC | 2024-09-17T12:11:03.782Z | 2024-09-19T12:20:40.294Z |
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);