participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,520 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 |
---|---|---|---|---|---|
5570022 | 5570022 | 20241120182347_Y829O | UK00CE | 2024-11-22T14:14:45.554Z | 2024-11-22T14:19:21.847Z |
5569963 | 5569963 | 20241120181219_30dAF | UK00CE | 2024-11-22T14:14:41.191Z | 2024-11-22T14:19:21.838Z |
5565241 | 5565241 | 20241120040636_2SP33 | UK00CE | 2024-11-21T14:18:43.392Z | 2024-11-22T14:21:44.633Z |
5565205 | 5565205 | 20241120040305_Mbd73 | UK00CE | 2024-11-21T14:18:40.697Z | 2024-11-22T14:21:43.798Z |
5565015 | 5565015 | 20241120034448_q3Yl7 | UK00CE | 2024-11-21T14:18:19.748Z | 2024-11-22T14:21:40.291Z |
5564910 | 5564910 | 20241120033817_asmSZ | UK00CE | 2024-11-21T14:18:14.909Z | 2024-11-22T14:21:39.500Z |
5564623 | 5564623 | 20241120031419_gRTAw | UK00CE | 2024-11-21T14:17:53.371Z | 2024-11-22T14:21:34.429Z |
5564466 | 5564466 | 20241120025859_J0mxx | UK00CE | 2024-11-21T14:17:39.439Z | 2024-11-22T14:21:32.542Z |
5564229 | 5564229 | 20241120024052_kYeBY | UK00CE | 2024-11-21T14:17:20.741Z | 2024-11-22T14:21:29.099Z |
5563951 | 5563951 | 20241120021824_JMW0w | UK00CE | 2024-11-21T14:16:59.951Z | 2024-11-22T14:21:25.600Z |
5563728 | 5563728 | 20241120015945_00giz | UK00CE | 2024-11-21T14:16:36.131Z | 2024-11-22T14:21:21.485Z |
5563673 | 5563673 | 20241120015644_giLEd | UK00CE | 2024-11-21T14:16:33.528Z | 2024-11-22T14:21:20.676Z |
5563593 | 5563593 | 20241120014846_qSMa2 | UK00CE | 2024-11-21T14:16:25.722Z | 2024-11-22T14:21:19.469Z |
5563480 | 5563480 | 20241120013347_mM2vH | UK00CE | 2024-11-21T14:16:09.962Z | 2024-11-22T14:21:16.704Z |
5563333 | 5563333 | 20241120011805_juhuF | UK00CE | 2024-11-21T14:15:54.827Z | 2024-11-22T14:21:13.147Z |
5563082 | 5563082 | 20241120004820_5Za7d | UK00CE | 2024-11-21T14:15:34.886Z | 2024-11-22T14:21:09.329Z |
5562895 | 5562895 | 20241120002403_0EGvs | UK00CE | 2024-11-21T14:15:26.386Z | 2024-11-22T14:21:05.895Z |
5562671 | 5562671 | 20241120000303_2SduA | UK00CE | 2024-11-21T14:15:15.997Z | 2024-11-22T14:21:01.939Z |
5562489 | 5562489 | 20241119234338_7vitt | UK00CE | 2024-11-21T14:14:59.862Z | 2024-11-22T14:20:59.302Z |
5562326 | 5562326 | 20241119232215_TLRFU | UK00CE | 2024-11-21T14:14:42.094Z | 2024-11-22T14:20:55.898Z |
5562272 | 5562272 | 20241119231841_RDA4I | UK00CE | 2024-11-21T14:14:39.542Z | 2024-11-22T14:20:54.934Z |
5562246 | 5562246 | 20241119231600_UtJs0 | UK00CE | 2024-11-21T14:14:35.908Z | 2024-11-22T14:20:54.545Z |
5562239 | 5562239 | 20241119231549_CoOTg | UK00CE | 2024-11-21T14:14:35.477Z | 2024-11-22T14:20:54.500Z |
5562100 | 5562100 | 20241119225935_EmdPQ | UK00CE | 2024-11-21T14:14:24.501Z | 2024-11-22T14:20:52.677Z |
5561647 | 5561647 | 20241119212443_JB2fU | UK00CE | 2024-11-21T14:13:39.594Z | 2024-11-22T14:20:42.520Z |
5561641 | 5561641 | 20241119212442_s9uv1 | UK00CE | 2024-11-21T14:13:39.403Z | 2024-11-22T14:20:42.498Z |
5561609 | 5561609 | 20241119211252_NWJ3R | UK00CE | 2024-11-21T14:13:33.842Z | 2024-11-22T14:20:41.715Z |
5561541 | 5561541 | 20241119205651_UWJkk | UK00CE | 2024-11-21T14:13:25.791Z | 2024-11-22T14:20:39.919Z |
5561423 | 5561423 | 20241119202905_2KR7m | UK00CE | 2024-11-21T14:13:15.388Z | 2024-11-22T14:20:35.813Z |
5557923 | 5557923 | 20241120052334_4L1Ez | UK00CE | 2024-11-21T14:02:03.954Z | 2024-11-22T14:19:21.146Z |
5557862 | 5557862 | 20241120052107_r8073 | UK00CE | 2024-11-21T14:01:58.141Z | 2024-11-22T14:19:21.139Z |
5557810 | 5557810 | 20241120051338_57azv | UK00CE | 2024-11-21T14:01:48.612Z | 2024-11-22T14:19:21.131Z |
5557693 | 5557693 | 20241120050451_2LZXa | UK00CE | 2024-11-21T14:01:30.810Z | 2024-11-22T14:19:21.112Z |
5557686 | 5557686 | 20241120050450_0csWC | UK00CE | 2024-11-21T14:01:30.512Z | 2024-11-22T14:19:21.111Z |
5557594 | 5557594 | 20241120045918_90liC | UK00CE | 2024-11-21T14:01:17.992Z | 2024-11-22T14:19:21.097Z |
5557524 | 5557524 | 20241120045330_4QRnY | UK00CE | 2024-11-21T14:01:05.173Z | 2024-11-22T14:19:21.084Z |
5557357 | 5557357 | 20241120044003_ucuow | UK00CE | 2024-11-21T14:00:35.753Z | 2024-11-22T14:19:21.057Z |
5532673 | 5532673 | 20241112054955_GfT8G | UK00CE | 2024-11-13T14:17:08.246Z | 2024-11-20T14:26:25.538Z |
5532623 | 5532623 | 20241112054437_LYIkN | UK00CE | 2024-11-13T14:17:03.777Z | 2024-11-20T14:26:25.171Z |
5532525 | 5532525 | 20241112053337_REb4U | UK00CE | 2024-11-13T14:16:57.162Z | 2024-11-20T14:26:24.159Z |
5531114 | 5531114 | 20241112031510_3UDCM | UK00CE | 2024-11-13T14:15:15.554Z | 2024-11-20T14:26:07.976Z |
5531068 | 5531068 | 20241112031008_2oDeT | UK00CE | 2024-11-13T14:15:07.580Z | 2024-11-20T14:26:06.942Z |
5531057 | 5531057 | 20241112030941_DnhA8 | UK00CE | 2024-11-13T14:15:06.746Z | 2024-11-20T14:26:06.803Z |
5530698 | 5530698 | 20241112023817_KZO0v | UK00CE | 2024-11-13T14:14:28.049Z | 2024-11-20T14:26:02.613Z |
5530656 | 5530656 | 20241112023659_ou9RS | UK00CE | 2024-11-13T14:14:26.431Z | 2024-11-20T14:26:02.319Z |
5530484 | 5530484 | 20241112022257_2Zxhe | UK00CE | 2024-11-13T14:14:18.205Z | 2024-11-20T14:26:00.672Z |
5530445 | 5530445 | 20241112021819_8yAYO | UK00CE | 2024-11-13T14:14:15.649Z | 2024-11-20T14:26:00.136Z |
5530404 | 5530404 | 20241112021544_DTd7b | UK00CE | 2024-11-13T14:14:13.964Z | 2024-11-20T14:25:58.469Z |
5530338 | 5530338 | 20241112020932_C22LS | UK00CE | 2024-11-13T14:14:09.775Z | 2024-11-20T14:25:57.258Z |
5530320 | 5530320 | 20241112020725_fPTJd | UK00CE | 2024-11-13T14:14:08.326Z | 2024-11-20T14:25:56.883Z |
5530289 | 5530289 | 20241112020545_lXy0h | UK00CE | 2024-11-13T14:14:06.998Z | 2024-11-20T14:25:56.572Z |
5530251 | 5530251 | 20241112020153_75BbG | UK00CE | 2024-11-13T14:14:04.463Z | 2024-11-20T14:25:56.109Z |
5530146 | 5530146 | 20241112014947_WKusm | UK00CE | 2024-11-13T14:13:58.545Z | 2024-11-20T14:25:54.852Z |
5530130 | 5530130 | 20241112014926_uIWV9 | UK00CE | 2024-11-13T14:13:58.093Z | 2024-11-20T14:25:54.797Z |
5530079 | 5530079 | 20241112013959_C7nco | UK00CE | 2024-11-13T14:13:48.793Z | 2024-11-20T14:25:54.076Z |
5530053 | 5530053 | 20241112013807_Njehl | UK00CE | 2024-11-13T14:13:44.807Z | 2024-11-20T14:25:53.478Z |
5529947 | 5529947 | 20241112012754_p42i7 | UK00CE | 2024-11-13T14:13:27.682Z | 2024-11-20T14:25:51.340Z |
5529726 | 5529726 | 20241112010024_SfLKs | UK00CE | 2024-11-13T14:13:07.996Z | 2024-11-20T14:25:47.713Z |
5529525 | 5529525 | 20241112003018_oICpu | UK00CE | 2024-11-13T14:12:56.382Z | 2024-11-20T14:25:45.992Z |
5529016 | 5529016 | 20241111231858_4r3Y3 | UK00CE | 2024-11-13T14:11:57.769Z | 2024-11-20T14:25:38.577Z |
5528983 | 5528983 | 20241111231447_IIVBr | UK00CE | 2024-11-13T14:11:53.820Z | 2024-11-20T14:25:38.297Z |
5528033 | 5528033 | 20241111191907_dmK5d | UK00CE | 2024-11-13T14:09:43.482Z | 2024-11-20T14:25:24.251Z |
5527629 | 5527629 | 20241111175441_VCFg9 | UK00CE | 2024-11-13T14:08:47.918Z | 2024-11-20T14:25:15.179Z |
5525688 | 5525688 | 20241112060645_ORdFb | UK00CE | 2024-11-13T14:00:20.935Z | 2024-11-21T14:25:25.402Z |
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 |
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);