participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
690 rows where station_code = "UK00CD" 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 |
---|---|---|---|---|---|
5410700 | 5410700 | 20241027052903_M1m7L | UK00CD | 2024-10-29T12:18:02.744Z | 2024-11-04T14:29:05.236Z |
5409591 | 5409591 | 20241027042722_QJHXP | UK00CD | 2024-10-29T12:17:31.883Z | 2024-11-04T14:29:01.968Z |
5409484 | 5409484 | 20241027042043_mwgwH | UK00CD | 2024-10-29T12:17:25.724Z | 2024-11-04T14:29:01.853Z |
5409048 | 5409048 | 20241027035711_CXkwG | UK00CD | 2024-10-29T12:17:03.308Z | 2024-11-04T14:29:00.993Z |
5408970 | 5408970 | 20241027035141_O3X66 | UK00CD | 2024-10-29T12:16:58.445Z | 2024-11-04T14:29:00.879Z |
5408303 | 5408303 | 20241027032207_Qopv8 | UK00CD | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5407440 | 5407440 | 20241027023700_3iYrH | UK00CD | 2024-10-29T12:15:24.742Z | 2024-11-04T14:28:57.570Z |
5406934 | 5406934 | 20241027021029_8YxqV | UK00CD | 2024-10-29T12:15:01.387Z | 2024-11-04T14:28:56.707Z |
5402717 | 5402717 | 20241026201632_GlOge | UK00CD | 2024-10-29T12:07:59.752Z | 2024-11-04T14:28:46.315Z |
5402679 | 5402679 | 20241026201324_3Z43O | UK00CD | 2024-10-29T12:07:56.615Z | 2024-11-04T14:28:46.088Z |
5402510 | 5402510 | 20241026194751_3613L | UK00CD | 2024-10-29T12:07:27.368Z | 2024-11-04T14:28:44.974Z |
5402480 | 5402480 | 20241026194141_DwF31 | UK00CD | 2024-10-29T12:07:22.501Z | 2024-11-04T14:28:44.742Z |
5399571 | 5399571 | 20241026043500_C44VJ | UK00CD | 2024-10-28T12:20:02.615Z | 2024-11-03T14:27:39.991Z |
5399344 | 5399344 | 20241026041140_R376e | UK00CD | 2024-10-28T12:19:55.327Z | 2024-11-03T14:27:39.506Z |
5399326 | 5399326 | 20241026041019_VVEFi | UK00CD | 2024-10-28T12:19:54.718Z | 2024-11-03T14:27:39.448Z |
5398373 | 5398373 | 20241026025047_KUrZ5 | UK00CD | 2024-10-28T12:19:13.032Z | 2024-11-03T14:27:36.138Z |
5397903 | 5397903 | 20241026020619_C4SMr | UK00CD | 2024-10-28T12:18:49.860Z | 2024-11-03T14:27:34.458Z |
5397633 | 5397633 | 20241026014401_WmO0e | UK00CD | 2024-10-28T12:18:30.447Z | 2024-11-03T14:27:33.622Z |
5397580 | 5397580 | 20241026014114_FHRGo | UK00CD | 2024-10-28T12:18:28.606Z | 2024-11-03T14:27:33.428Z |
5397529 | 5397529 | 20241026013752_5bShE | UK00CD | 2024-10-28T12:18:26.336Z | 2024-11-03T14:27:33.346Z |
5397481 | 5397481 | 20241026013301_J22ig | UK00CD | 2024-10-28T12:18:24.490Z | 2024-11-03T14:27:33.144Z |
5397476 | 5397476 | 20241026013248_pQQM4 | UK00CD | 2024-10-28T12:18:24.430Z | 2024-11-03T14:27:33.141Z |
5397468 | 5397468 | 20241026013143_eEpEZ | UK00CD | 2024-10-28T12:18:24.090Z | 2024-11-03T14:27:33.119Z |
5397461 | 5397461 | 20241026013130_9KjkZ | UK00CD | 2024-10-28T12:18:23.304Z | 2024-11-03T14:27:33.032Z |
5397380 | 5397380 | 20241026012420_u8aPb | UK00CD | 2024-10-28T12:18:18.751Z | 2024-11-03T14:27:32.758Z |
5397311 | 5397311 | 20241026011649_g33Cl | UK00CD | 2024-10-28T12:18:15.465Z | 2024-11-03T14:27:32.560Z |
5397249 | 5397249 | 20241026011311_udF3Z | UK00CD | 2024-10-28T12:18:13.062Z | 2024-11-03T14:27:32.433Z |
5396960 | 5396960 | 20241026004957_bYmW8 | UK00CD | 2024-10-28T12:18:00.673Z | 2024-11-03T14:27:31.545Z |
5396860 | 5396860 | 20241026004245_5IlXr | UK00CD | 2024-10-28T12:17:58.115Z | 2024-11-03T14:27:31.269Z |
5396784 | 5396784 | 20241026003248_AGjxn | UK00CD | 2024-10-28T12:17:55.540Z | 2024-11-03T14:27:30.888Z |
5396736 | 5396736 | 20241026002804_J27Ol | UK00CD | 2024-10-28T12:17:54.459Z | 2024-11-03T14:27:30.830Z |
5396535 | 5396535 | 20241026000955_0KhG3 | UK00CD | 2024-10-28T12:17:48.938Z | 2024-11-03T14:27:30.157Z |
5396500 | 5396500 | 20241026000809_cadJN | UK00CD | 2024-10-28T12:17:47.224Z | 2024-11-03T14:27:30.018Z |
5396482 | 5396482 | 20241026000636_1MjHf | UK00CD | 2024-10-28T12:17:45.605Z | 2024-11-03T14:27:29.966Z |
5395820 | 5395820 | 20241025231248_uGeg7 | UK00CD | 2024-10-28T12:16:55.082Z | 2024-11-03T14:27:26.785Z |
5395744 | 5395744 | 20241025230723_A3VDj | UK00CD | 2024-10-28T12:16:44.961Z | 2024-11-03T14:27:26.599Z |
5395395 | 5395395 | 20241025223936_PELed | UK00CD | 2024-10-28T12:16:12.021Z | 2024-11-03T14:27:25.423Z |
5395277 | 5395277 | 20241025222922_9Fo8Q | UK00CD | 2024-10-28T12:16:04.280Z | 2024-11-03T14:27:24.553Z |
5385186 | 5385186 | 20241024220336_UiDNZ | UK00CD | 2024-10-27T12:18:32.987Z | 2024-11-02T12:28:29.251Z |
5385046 | 5385046 | 20241024214042_FjZ7h | UK00CD | 2024-10-27T12:18:17.191Z | 2024-11-02T12:28:28.983Z |
5384950 | 5384950 | 20241024212057_UR2Q4 | UK00CD | 2024-10-27T12:18:02.604Z | 2024-11-02T12:28:28.778Z |
5383577 | 5383577 | 20241024183428_PrrJU | UK00CD | 2024-10-27T12:15:47.673Z | 2024-11-02T12:28:25.767Z |
5383534 | 5383534 | 20241024183025_DLq7v | UK00CD | 2024-10-27T12:15:42.109Z | 2024-11-02T12:28:25.737Z |
5383487 | 5383487 | 20241024182456_mKUPB | UK00CD | 2024-10-27T12:15:35.621Z | 2024-11-02T12:28:25.387Z |
5377999 | 5377999 | 20241024052245_J5e9b | UK00CD | 2024-10-26T12:22:52.499Z | 2024-11-01T12:27:03.220Z |
5377940 | 5377940 | 20241024051807_eLxdM | UK00CD | 2024-10-26T12:22:50.359Z | 2024-11-01T12:27:03.168Z |
5377895 | 5377895 | 20241024051628_rj81p | UK00CD | 2024-10-26T12:22:49.324Z | 2024-11-01T12:27:03.154Z |
5377646 | 5377646 | 20241024050148_gwgbN | UK00CD | 2024-10-26T12:22:43.046Z | 2024-11-01T12:27:02.691Z |
5377406 | 5377406 | 20241024044851_3sB7h | UK00CD | 2024-10-26T12:22:36.503Z | 2024-11-01T12:27:02.420Z |
5377310 | 5377310 | 20241024044311_yabLv | UK00CD | 2024-10-26T12:22:33.629Z | 2024-11-01T12:27:02.357Z |
5375816 | 5375816 | 20241024033153_E9mXE | UK00CD | 2024-10-26T12:21:40.768Z | 2024-11-01T12:27:01.210Z |
5375546 | 5375546 | 20241024031937_7wDJY | UK00CD | 2024-10-26T12:21:31.052Z | 2024-11-01T12:27:00.771Z |
5375011 | 5375011 | 20241024025230_p5XVt | UK00CD | 2024-10-26T12:21:09.642Z | 2024-11-01T12:27:00.113Z |
5374892 | 5374892 | 20241024024826_uGHrz | UK00CD | 2024-10-26T12:21:05.215Z | 2024-11-01T12:27:00.029Z |
5365792 | 5365792 | 20241023234937_F5n1X | UK00CD | 2024-10-25T12:18:07.670Z | 2024-11-01T12:26:56.413Z |
5365487 | 5365487 | 20241023233426_9aNDv | UK00CD | 2024-10-25T12:17:59.030Z | 2024-11-01T12:26:56.170Z |
5365011 | 5365011 | 20241023231004_SAWXg | UK00CD | 2024-10-25T12:17:43.568Z | 2024-11-01T12:26:55.829Z |
5364570 | 5364570 | 20241023223829_Q3TOu | UK00CD | 2024-10-25T12:17:25.075Z | 2024-11-01T12:26:55.221Z |
5364406 | 5364406 | 20241023222624_1OVvW | UK00CD | 2024-10-25T12:17:19.771Z | 2024-11-01T12:26:55.042Z |
5364337 | 5364337 | 20241023222135_3oynK | UK00CD | 2024-10-25T12:17:17.265Z | 2024-11-01T12:26:54.694Z |
5363280 | 5363280 | 20241023204211_WVDUy | UK00CD | 2024-10-25T12:15:50.198Z | 2024-11-01T12:26:53.014Z |
5363268 | 5363268 | 20241023204044_aP4ZA | UK00CD | 2024-10-25T12:15:49.121Z | 2024-11-01T12:26:53.011Z |
5362975 | 5362975 | 20241023201503_qmOvO | UK00CD | 2024-10-25T12:15:21.052Z | 2024-11-01T12:26:52.760Z |
5362578 | 5362578 | 20241023194401_7Su2p | UK00CD | 2024-10-25T12:14:46.197Z | 2024-11-01T12:26:52.051Z |
5356282 | 5356282 | 20241023052916_399lk | UK00CD | 2024-10-24T12:21:56.965Z | 2024-10-31T12:30:11.214Z |
5355523 | 5355523 | 20241023034747_Efikw | UK00CD | 2024-10-24T12:21:25.063Z | 2024-10-31T12:30:08.036Z |
5354375 | 5354375 | 20241023022300_79yd7 | UK00CD | 2024-10-24T12:20:30.419Z | 2024-10-31T12:30:05.687Z |
5354314 | 5354314 | 20241023021940_lyyM9 | UK00CD | 2024-10-24T12:20:27.976Z | 2024-10-31T12:30:05.636Z |
5354268 | 5354268 | 20241023021551_MPwK4 | UK00CD | 2024-10-24T12:20:25.220Z | 2024-10-31T12:30:05.562Z |
5354097 | 5354097 | 20241023020409_fvWAd | UK00CD | 2024-10-24T12:20:14.658Z | 2024-10-31T12:30:05.358Z |
5354024 | 5354024 | 20241023020012_MP5nt | UK00CD | 2024-10-24T12:20:09.421Z | 2024-10-31T12:30:05.274Z |
5353878 | 5353878 | 20241023015236_l0WwD | UK00CD | 2024-10-24T12:20:00.097Z | 2024-10-31T12:30:05.015Z |
5353803 | 5353803 | 20241023014910_J9JXb | UK00CD | 2024-10-24T12:19:56.844Z | 2024-10-31T12:30:04.840Z |
5353792 | 5353792 | 20241023014901_Vc69i | UK00CD | 2024-10-24T12:19:56.690Z | 2024-10-31T12:30:04.828Z |
5353637 | 5353637 | 20241023013635_lrfbm | UK00CD | 2024-10-24T12:19:49.866Z | 2024-10-31T12:30:04.433Z |
5353517 | 5353517 | 20241023012915_iQeIi | UK00CD | 2024-10-24T12:19:45.186Z | 2024-10-31T12:30:04.316Z |
5353480 | 5353480 | 20241023012731_zkWg1 | UK00CD | 2024-10-24T12:19:43.968Z | 2024-10-31T12:30:04.289Z |
5353247 | 5353247 | 20241023011700_srGHX | UK00CD | 2024-10-24T12:19:36.873Z | 2024-10-31T12:30:04.054Z |
5353193 | 5353193 | 20241023011352_YBql8 | UK00CD | 2024-10-24T12:19:34.922Z | 2024-10-31T12:30:03.985Z |
5352787 | 5352787 | 20241023004954_5bo6B | UK00CD | 2024-10-24T12:19:11.945Z | 2024-10-31T12:30:03.288Z |
5352461 | 5352461 | 20241023003319_4B0Yd | UK00CD | 2024-10-24T12:18:49.008Z | 2024-10-31T12:30:02.654Z |
5352373 | 5352373 | 20241023002939_XQkhQ | UK00CD | 2024-10-24T12:18:42.359Z | 2024-10-31T12:30:02.556Z |
5352301 | 5352301 | 20241023002519_cxgf7 | UK00CD | 2024-10-24T12:18:36.239Z | 2024-10-31T12:30:02.400Z |
5352219 | 5352219 | 20241023001829_f4xcd | UK00CD | 2024-10-24T12:18:32.180Z | 2024-10-31T12:30:02.302Z |
5351888 | 5351888 | 20241022235725_KBkTj | UK00CD | 2024-10-24T12:18:07.469Z | 2024-10-31T12:30:01.179Z |
5351730 | 5351730 | 20241022234938_hPCku | UK00CD | 2024-10-24T12:17:54.247Z | 2024-10-31T12:30:00.837Z |
5351716 | 5351716 | 20241022234827_s4SyG | UK00CD | 2024-10-24T12:17:52.875Z | 2024-10-31T12:30:00.812Z |
5351643 | 5351643 | 20241022234215_uuuSO | UK00CD | 2024-10-24T12:17:45.939Z | 2024-10-31T12:30:00.638Z |
5351599 | 5351599 | 20241022234000_g4Qvy | UK00CD | 2024-10-24T12:17:41.353Z | 2024-10-31T12:30:00.579Z |
5351312 | 5351312 | 20241022231553_MS87d | UK00CD | 2024-10-24T12:17:25.529Z | 2024-10-31T12:29:59.899Z |
5351202 | 5351202 | 20241022230510_C3twf | UK00CD | 2024-10-24T12:17:20.130Z | 2024-10-31T12:29:59.602Z |
5351073 | 5351073 | 20241022225400_bI2Zs | UK00CD | 2024-10-24T12:17:08.989Z | 2024-10-31T12:29:59.348Z |
5351052 | 5351052 | 20241022225116_GrALp | UK00CD | 2024-10-24T12:17:06.667Z | 2024-10-31T12:29:59.308Z |
5351033 | 5351033 | 20241022224936_Jo6Sy | UK00CD | 2024-10-24T12:17:04.636Z | 2024-10-31T12:29:59.286Z |
5350897 | 5350897 | 20241022223852_aXm2X | UK00CD | 2024-10-24T12:16:45.678Z | 2024-10-31T12:29:58.995Z |
5349943 | 5349943 | 20241022205232_TSmMS | UK00CD | 2024-10-24T12:14:53.910Z | 2024-10-31T12:29:57.009Z |
5349834 | 5349834 | 20241022203845_k2jWP | UK00CD | 2024-10-24T12:14:42.213Z | 2024-10-31T12:29:56.661Z |
5349805 | 5349805 | 20241022203624_2e3oC | UK00CD | 2024-10-24T12:14:39.366Z | 2024-10-31T12:29:56.544Z |
5348865 | 5348865 | 20241022190424_5H7Yh | UK00CD | 2024-10-24T12:12:26.734Z | 2024-10-31T12:29:53.868Z |
5339094 | 5339094 | 20241021214712_o10Tv | UK00CD | 2024-10-23T12:12:29.383Z | 2024-10-30T12:26:43.539Z |
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);