participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,456 rows where station_code = "UK00CE" 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 |
---|---|---|---|---|---|
5423005 | 5423005 | 20241027033823_BrBn3 | UK00CE | 2024-10-30T12:22:58.721Z | 2024-11-04T14:29:00.325Z |
5422984 | 5422984 | 20241027011550_xMiev | UK00CE | 2024-10-30T12:22:35.836Z | 2024-11-04T14:28:55.117Z |
5422940 | 5422940 | 20241026203110_xhN9q | UK00CE | 2024-10-30T12:22:00.848Z | 2024-11-04T14:28:46.638Z |
5418459 | 5418459 | 20241027205050_PTTRx | UK00CE | 2024-10-30T12:15:42.593Z | 2024-11-05T14:27:10.071Z |
5418126 | 5418126 | 20241027195709_3UmAx | UK00CE | 2024-10-30T12:14:57.697Z | 2024-11-05T14:27:09.199Z |
5418000 | 5418000 | 20241027193913_ZrTVJ | UK00CE | 2024-10-30T12:14:43.816Z | 2024-11-05T14:27:08.834Z |
5417812 | 5417812 | 20241027191553_NDpEC | UK00CE | 2024-10-30T12:14:29.639Z | 2024-11-05T14:27:08.334Z |
5417704 | 5417704 | 20241027190248_kZO4h | UK00CE | 2024-10-30T12:14:17.444Z | 2024-11-05T14:27:08.111Z |
5410748 | 5410748 | 20241027053357_oQ1Ry | UK00CE | 2024-10-29T12:18:04.086Z | 2024-11-04T14:29:05.376Z |
5410673 | 5410673 | 20241027052601_vi3x0 | UK00CE | 2024-10-29T12:18:02.217Z | 2024-11-04T14:29:05.206Z |
5410572 | 5410572 | 20241027051839_CHur0 | UK00CE | 2024-10-29T12:17:58.376Z | 2024-11-04T14:29:04.981Z |
5410545 | 5410545 | 20241027051716_2ffzo | UK00CE | 2024-10-29T12:17:57.831Z | 2024-11-04T14:29:04.803Z |
5410426 | 5410426 | 20241027051230_Jo7gt | UK00CE | 2024-10-29T12:17:55.605Z | 2024-11-04T14:29:04.567Z |
5410391 | 5410391 | 20241027051052_4qk7q | UK00CE | 2024-10-29T12:17:55.061Z | 2024-11-04T14:29:04.493Z |
5410356 | 5410356 | 20241027050747_xtoJc | UK00CE | 2024-10-29T12:17:54.033Z | 2024-11-04T14:29:04.419Z |
5410351 | 5410351 | 20241027050732_zafP6 | UK00CE | 2024-10-29T12:17:53.806Z | 2024-11-04T14:29:04.414Z |
5409887 | 5409887 | 20241027043935_RBUSX | UK00CE | 2024-10-29T12:17:43.298Z | 2024-11-04T14:29:02.847Z |
5409544 | 5409544 | 20241027042423_EM54p | UK00CE | 2024-10-29T12:17:29.341Z | 2024-11-04T14:29:01.947Z |
5409238 | 5409238 | 20241027040628_o1bfQ | UK00CE | 2024-10-29T12:17:13.158Z | 2024-11-04T14:29:01.388Z |
5409136 | 5409136 | 20241027040156_3QHjB | UK00CE | 2024-10-29T12:17:08.511Z | 2024-11-04T14:29:01.211Z |
5408509 | 5408509 | 20241027032818_k9kCr | UK00CE | 2024-10-29T12:16:33.563Z | 2024-11-04T14:28:59.580Z |
5408351 | 5408351 | 20241027032304_6oxSO | UK00CE | 2024-10-29T12:16:24.485Z | 2024-11-04T14:28:59.244Z |
5408092 | 5408092 | 20241027030717_WO83A | UK00CE | 2024-10-29T12:16:05.240Z | 2024-11-04T14:28:58.843Z |
5408069 | 5408069 | 20241027030530_deLch | UK00CE | 2024-10-29T12:16:03.711Z | 2024-11-04T14:28:58.749Z |
5407791 | 5407791 | 20241027025241_J3Qz3 | UK00CE | 2024-10-29T12:15:41.927Z | 2024-11-04T14:28:58.153Z |
5407661 | 5407661 | 20241027024640_qnBNB | UK00CE | 2024-10-29T12:15:33.303Z | 2024-11-04T14:28:58.019Z |
5407450 | 5407450 | 20241027023711_C7NjR | UK00CE | 2024-10-29T12:15:25.172Z | 2024-11-04T14:28:57.584Z |
5407331 | 5407331 | 20241027023140_0D39A | UK00CE | 2024-10-29T12:15:20.987Z | 2024-11-04T14:28:57.339Z |
5407087 | 5407087 | 20241027022136_WhoU4 | UK00CE | 2024-10-29T12:15:11.843Z | 2024-11-04T14:28:56.840Z |
5407043 | 5407043 | 20241027021808_nWuA4 | UK00CE | 2024-10-29T12:15:09.913Z | 2024-11-04T14:28:56.810Z |
5407016 | 5407016 | 20241027021639_ar5mh | UK00CE | 2024-10-29T12:15:08.709Z | 2024-11-04T14:28:56.775Z |
5406836 | 5406836 | 20241027020219_Cov2N | UK00CE | 2024-10-29T12:14:48.073Z | 2024-11-04T14:28:56.493Z |
5406534 | 5406534 | 20241027014244_c5t62 | UK00CE | 2024-10-29T12:14:18.041Z | 2024-11-04T14:28:55.841Z |
5406019 | 5406019 | 20241027011214_RRwA9 | UK00CE | 2024-10-29T12:13:48.051Z | 2024-11-04T14:28:54.885Z |
5405776 | 5405776 | 20241027005715_ezAS0 | UK00CE | 2024-10-29T12:13:15.522Z | 2024-11-04T14:28:54.182Z |
5405179 | 5405179 | 20241027002002_4685x | UK00CE | 2024-10-29T12:12:38.466Z | 2024-11-04T14:28:52.758Z |
5405148 | 5405148 | 20241027001553_rKOVQ | UK00CE | 2024-10-29T12:12:32.800Z | 2024-11-04T14:28:52.726Z |
5405107 | 5405107 | 20241027001346_BhzSC | UK00CE | 2024-10-29T12:12:27.672Z | 2024-11-04T14:28:52.681Z |
5405087 | 5405087 | 20241027001237_FwTiD | UK00CE | 2024-10-29T12:12:24.161Z | 2024-11-04T14:28:52.662Z |
5405034 | 5405034 | 20241027000946_K376n | UK00CE | 2024-10-29T12:12:18.766Z | 2024-11-04T14:28:52.602Z |
5404855 | 5404855 | 20241026235704_UUM28 | UK00CE | 2024-10-29T12:12:03.209Z | 2024-11-04T14:28:52.210Z |
5404383 | 5404383 | 20241026232145_gArhC | UK00CE | 2024-10-29T12:11:16.746Z | 2024-11-04T14:28:50.826Z |
5404240 | 5404240 | 20241026231116_rTsn3 | UK00CE | 2024-10-29T12:11:02.883Z | 2024-11-04T14:28:50.549Z |
5404220 | 5404220 | 20241026230945_88JPM | UK00CE | 2024-10-29T12:11:01.102Z | 2024-11-04T14:28:50.460Z |
5404165 | 5404165 | 20241026230338_0yKxW | UK00CE | 2024-10-29T12:10:57.297Z | 2024-11-04T14:28:50.392Z |
5404127 | 5404127 | 20241026230041_5n5Mx | UK00CE | 2024-10-29T12:10:54.861Z | 2024-11-04T14:28:50.344Z |
5404003 | 5404003 | 20241026225239_Xz8bw | UK00CE | 2024-10-29T12:10:46.897Z | 2024-11-04T14:28:50.194Z |
5403766 | 5403766 | 20241026222918_ZyTUf | UK00CE | 2024-10-29T12:10:12.428Z | 2024-11-04T14:28:49.566Z |
5403340 | 5403340 | 20241026214302_DCdy9 | UK00CE | 2024-10-29T12:09:22.991Z | 2024-11-04T14:28:48.382Z |
5403331 | 5403331 | 20241026214139_mQhTZ | UK00CE | 2024-10-29T12:09:22.232Z | 2024-11-04T14:28:48.365Z |
5402922 | 5402922 | 20241026204627_2JJ8H | UK00CE | 2024-10-29T12:08:36.208Z | 2024-11-04T14:28:46.986Z |
5402833 | 5402833 | 20241026203217_YgfW6 | UK00CE | 2024-10-29T12:08:25.554Z | 2024-11-04T14:28:46.643Z |
5402725 | 5402725 | 20241026201703_60aai | UK00CE | 2024-10-29T12:08:00.159Z | 2024-11-04T14:28:46.360Z |
5402605 | 5402605 | 20241026200406_4C2r1 | UK00CE | 2024-10-29T12:07:47.318Z | 2024-11-04T14:28:45.521Z |
5402454 | 5402454 | 20241026193916_qskDx | UK00CE | 2024-10-29T12:07:19.739Z | 2024-11-04T14:28:44.497Z |
5402254 | 5402254 | 20241026190615_7Ca0D | UK00CE | 2024-10-29T12:06:44.454Z | 2024-11-04T14:28:43.331Z |
5402171 | 5402171 | 20241026185249_IzSe8 | UK00CE | 2024-10-29T12:06:33.420Z | 2024-11-04T14:28:42.737Z |
5394918 | 5394918 | 20241025214357_iCsX3 | UK00CE | 2024-10-28T12:15:42.883Z | 2024-11-03T14:27:23.468Z |
5394630 | 5394630 | 20241025210028_gvRs8 | UK00CE | 2024-10-28T12:15:07.576Z | 2024-11-03T14:27:21.914Z |
5394585 | 5394585 | 20241025205320_czHtR | UK00CE | 2024-10-28T12:15:00.799Z | 2024-11-03T14:27:21.763Z |
5394391 | 5394391 | 20241025202609_L2i4x | UK00CE | 2024-10-28T12:14:33.729Z | 2024-11-03T14:27:21.126Z |
5386779 | 5386779 | 20241025012428_G8F23 | UK00CE | 2024-10-27T12:20:27.276Z | 2024-11-02T12:28:31.576Z |
5386638 | 5386638 | 20241025010732_rliWx | UK00CE | 2024-10-27T12:20:12.546Z | 2024-11-02T12:28:31.406Z |
5386552 | 5386552 | 20241025010057_3sS9I | UK00CE | 2024-10-27T12:20:10.244Z | 2024-11-02T12:28:31.336Z |
5386519 | 5386519 | 20241025005516_qCjz0 | UK00CE | 2024-10-27T12:20:08.974Z | 2024-11-02T12:28:31.301Z |
5386465 | 5386465 | 20241025004546_O5D8O | UK00CE | 2024-10-27T12:20:06.578Z | 2024-11-02T12:28:31.265Z |
5386328 | 5386328 | 20241025002619_vj7H7 | UK00CE | 2024-10-27T12:19:59.867Z | 2024-11-02T12:28:30.957Z |
5385364 | 5385364 | 20241024223035_LtXUl | UK00CE | 2024-10-27T12:18:47.820Z | 2024-11-02T12:28:29.669Z |
5385334 | 5385334 | 20241024222534_P0iOX | UK00CE | 2024-10-27T12:18:45.279Z | 2024-11-02T12:28:29.558Z |
5385128 | 5385128 | 20241024215511_AqKQd | UK00CE | 2024-10-27T12:18:26.734Z | 2024-11-02T12:28:29.165Z |
5378252 | 5378252 | 20241024053950_WiZvg | UK00CE | 2024-10-26T12:22:58.854Z | 2024-11-01T12:27:03.499Z |
5378227 | 5378227 | 20241024053803_07Q4B | UK00CE | 2024-10-26T12:22:58.349Z | 2024-11-01T12:27:03.475Z |
5378148 | 5378148 | 20241024053102_rPyVI | UK00CE | 2024-10-26T12:22:55.552Z | 2024-11-01T12:27:03.312Z |
5377965 | 5377965 | 20241024051955_I22xl | UK00CE | 2024-10-26T12:22:51.088Z | 2024-11-01T12:27:03.201Z |
5377920 | 5377920 | 20241024051741_G1cVQ | UK00CE | 2024-10-26T12:22:49.793Z | 2024-11-01T12:27:03.163Z |
5377910 | 5377910 | 20241024051736_eD92e | UK00CE | 2024-10-26T12:22:49.478Z | 2024-11-01T12:27:03.160Z |
5377822 | 5377822 | 20241024051240_G6IaF | UK00CE | 2024-10-26T12:22:47.731Z | 2024-11-01T12:27:03.078Z |
5377809 | 5377809 | 20241024051200_ls663 | UK00CE | 2024-10-26T12:22:47.509Z | 2024-11-01T12:27:03.070Z |
5377793 | 5377793 | 20241024051045_4E5zX | UK00CE | 2024-10-26T12:22:47.070Z | 2024-11-01T12:27:03.067Z |
5377715 | 5377715 | 20241024050528_jlCVj | UK00CE | 2024-10-26T12:22:44.700Z | 2024-11-01T12:27:02.727Z |
5377691 | 5377691 | 20241024050441_IF6h2 | UK00CE | 2024-10-26T12:22:43.770Z | 2024-11-01T12:27:02.721Z |
5377586 | 5377586 | 20241024045805_bHH5C | UK00CE | 2024-10-26T12:22:41.252Z | 2024-11-01T12:27:02.616Z |
5377555 | 5377555 | 20241024045658_pIuPJ | UK00CE | 2024-10-26T12:22:40.402Z | 2024-11-01T12:27:02.580Z |
5377281 | 5377281 | 20241024044143_cxYvk | UK00CE | 2024-10-26T12:22:32.964Z | 2024-11-01T12:27:02.345Z |
5377022 | 5377022 | 20241024042928_gXyn0 | UK00CE | 2024-10-26T12:22:23.045Z | 2024-11-01T12:27:02.126Z |
5376933 | 5376933 | 20241024042411_LoxCY | UK00CE | 2024-10-26T12:22:17.421Z | 2024-11-01T12:27:01.922Z |
5376879 | 5376879 | 20241024042015_KWw0a | UK00CE | 2024-10-26T12:22:15.232Z | 2024-11-01T12:27:01.902Z |
5376670 | 5376670 | 20241024040729_uHMrJ | UK00CE | 2024-10-26T12:22:10.169Z | 2024-11-01T12:27:01.737Z |
5376507 | 5376507 | 20241024035819_mteBH | UK00CE | 2024-10-26T12:22:03.526Z | 2024-11-01T12:27:01.580Z |
5376363 | 5376363 | 20241024035232_LfADh | UK00CE | 2024-10-26T12:21:59.089Z | 2024-11-01T12:27:01.511Z |
5376336 | 5376336 | 20241024035144_OGlfx | UK00CE | 2024-10-26T12:21:58.123Z | 2024-11-01T12:27:01.503Z |
5376301 | 5376301 | 20241024035020_doJWC | UK00CE | 2024-10-26T12:21:55.939Z | 2024-11-01T12:27:01.486Z |
5376273 | 5376273 | 20241024034821_ynV1V | UK00CE | 2024-10-26T12:21:55.222Z | 2024-11-01T12:27:01.477Z |
5376209 | 5376209 | 20241024034529_Poqkj | UK00CE | 2024-10-26T12:21:53.429Z | 2024-11-01T12:27:01.458Z |
5376020 | 5376020 | 20241024033759_Q7VvN | UK00CE | 2024-10-26T12:21:46.859Z | 2024-11-01T12:27:01.317Z |
5375929 | 5375929 | 20241024033548_mM3G3 | UK00CE | 2024-10-26T12:21:44.286Z | 2024-11-01T12:27:01.269Z |
5375874 | 5375874 | 20241024033413_m9mnq | UK00CE | 2024-10-26T12:21:42.672Z | 2024-11-01T12:27:01.242Z |
5375721 | 5375721 | 20241024032625_ZDdOl | UK00CE | 2024-10-26T12:21:36.047Z | 2024-11-01T12:27:01.169Z |
5375699 | 5375699 | 20241024032502_xhTI2 | UK00CE | 2024-10-26T12:21:35.803Z | 2024-11-01T12:27:01.164Z |
5375357 | 5375357 | 20241024030824_Slnz6 | UK00CE | 2024-10-26T12:21:21.596Z | 2024-11-01T12:27:00.632Z |
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);