participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,539 rows where station_code = "UK008T" 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 |
---|---|---|---|---|---|
5423003 | 5423003 | 20241027033823_BrBn3 | UK008T | 2024-10-30T12:22:58.721Z | 2024-11-04T14:29:00.325Z |
5418736 | 5418736 | 20241027214639_qqIbB | UK008T | 2024-10-30T12:16:02.591Z | 2024-11-05T14:27:11.016Z |
5418462 | 5418462 | 20241027205247_1WfDe | UK008T | 2024-10-30T12:15:42.754Z | 2024-11-05T14:27:10.083Z |
5418125 | 5418125 | 20241027195709_3UmAx | UK008T | 2024-10-30T12:14:57.697Z | 2024-11-05T14:27:09.199Z |
5417999 | 5417999 | 20241027193913_ZrTVJ | UK008T | 2024-10-30T12:14:43.804Z | 2024-11-05T14:27:08.834Z |
5410543 | 5410543 | 20241027051716_2ffzo | UK008T | 2024-10-29T12:17:57.831Z | 2024-11-04T14:29:04.803Z |
5410525 | 5410525 | 20241027051628_JiLam | UK008T | 2024-10-29T12:17:57.483Z | 2024-11-04T14:29:04.730Z |
5410388 | 5410388 | 20241027051052_4qk7q | UK008T | 2024-10-29T12:17:55.061Z | 2024-11-04T14:29:04.493Z |
5410350 | 5410350 | 20241027050732_zafP6 | UK008T | 2024-10-29T12:17:53.806Z | 2024-11-04T14:29:04.414Z |
5409975 | 5409975 | 20241027044630_VpkuQ | UK008T | 2024-10-29T12:17:45.190Z | 2024-11-04T14:29:03.166Z |
5409885 | 5409885 | 20241027043935_RBUSX | UK008T | 2024-10-29T12:17:43.297Z | 2024-11-04T14:29:02.847Z |
5409543 | 5409543 | 20241027042423_EM54p | UK008T | 2024-10-29T12:17:29.341Z | 2024-11-04T14:29:01.947Z |
5409496 | 5409496 | 20241027042217_aIykT | UK008T | 2024-10-29T12:17:26.710Z | 2024-11-04T14:29:01.915Z |
5409444 | 5409444 | 20241027041830_tIy3I | UK008T | 2024-10-29T12:17:24.251Z | 2024-11-04T14:29:01.741Z |
5409313 | 5409313 | 20241027041040_kPa89 | UK008T | 2024-10-29T12:17:16.192Z | 2024-11-04T14:29:01.517Z |
5409260 | 5409260 | 20241027040735_CKqZO | UK008T | 2024-10-29T12:17:14.337Z | 2024-11-04T14:29:01.440Z |
5409091 | 5409091 | 20241027035945_g4d8o | UK008T | 2024-10-29T12:17:05.273Z | 2024-11-04T14:29:01.042Z |
5408939 | 5408939 | 20241027035043_EEvAM | UK008T | 2024-10-29T12:16:57.712Z | 2024-11-04T14:29:00.847Z |
5408508 | 5408508 | 20241027032818_k9kCr | UK008T | 2024-10-29T12:16:33.563Z | 2024-11-04T14:28:59.580Z |
5408456 | 5408456 | 20241027032750_OBiFX | UK008T | 2024-10-29T12:16:31.339Z | 2024-11-04T14:28:59.509Z |
5408349 | 5408349 | 20241027032304_6oxSO | UK008T | 2024-10-29T12:16:24.485Z | 2024-11-04T14:28:59.244Z |
5408091 | 5408091 | 20241027030717_WO83A | UK008T | 2024-10-29T12:16:05.240Z | 2024-11-04T14:28:58.843Z |
5408066 | 5408066 | 20241027030530_deLch | UK008T | 2024-10-29T12:16:03.711Z | 2024-11-04T14:28:58.749Z |
5408060 | 5408060 | 20241027030513_4CLDQ | UK008T | 2024-10-29T12:16:03.400Z | 2024-11-04T14:28:58.747Z |
5407969 | 5407969 | 20241027030048_OBkfw | UK008T | 2024-10-29T12:15:55.978Z | 2024-11-04T14:28:58.535Z |
5407965 | 5407965 | 20241027030033_2mrzP | UK008T | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407328 | 5407328 | 20241027023140_0D39A | UK008T | 2024-10-29T12:15:20.987Z | 2024-11-04T14:28:57.339Z |
5406877 | 5406877 | 20241027020604_jFPhF | UK008T | 2024-10-29T12:14:52.345Z | 2024-11-04T14:28:56.541Z |
5406687 | 5406687 | 20241027015356_gDssW | UK008T | 2024-10-29T12:14:32.240Z | 2024-11-04T14:28:56.033Z |
5405762 | 5405762 | 20241027005551_3TGSo | UK008T | 2024-10-29T12:13:13.244Z | 2024-11-04T14:28:54.154Z |
5405350 | 5405350 | 20241027002923_N3J0M | UK008T | 2024-10-29T12:12:50.675Z | 2024-11-04T14:28:53.318Z |
5405307 | 5405307 | 20241027002753_DuxbX | UK008T | 2024-10-29T12:12:49.022Z | 2024-11-04T14:28:53.268Z |
5405147 | 5405147 | 20241027001553_rKOVQ | UK008T | 2024-10-29T12:12:32.800Z | 2024-11-04T14:28:52.726Z |
5405033 | 5405033 | 20241027000946_K376n | UK008T | 2024-10-29T12:12:18.766Z | 2024-11-04T14:28:52.602Z |
5404972 | 5404972 | 20241027000348_MIR12 | UK008T | 2024-10-29T12:12:12.248Z | 2024-11-04T14:28:52.463Z |
5404899 | 5404899 | 20241026235956_WLvJt | UK008T | 2024-10-29T12:12:06.111Z | 2024-11-04T14:28:52.384Z |
5404853 | 5404853 | 20241026235704_UUM28 | UK008T | 2024-10-29T12:12:03.209Z | 2024-11-04T14:28:52.210Z |
5404849 | 5404849 | 20241026235657_GGxDS | UK008T | 2024-10-29T12:12:02.844Z | 2024-11-04T14:28:52.202Z |
5404835 | 5404835 | 20241026235536_sSovp | UK008T | 2024-10-29T12:12:00.851Z | 2024-11-04T14:28:52.174Z |
5404511 | 5404511 | 20241026233229_n25yi | UK008T | 2024-10-29T12:11:38.849Z | 2024-11-04T14:28:51.271Z |
5404381 | 5404381 | 20241026232145_gArhC | UK008T | 2024-10-29T12:11:16.746Z | 2024-11-04T14:28:50.826Z |
5403910 | 5403910 | 20241026224510_atRJZ | UK008T | 2024-10-29T12:10:26.912Z | 2024-11-04T14:28:50.002Z |
5395803 | 5395803 | 20241025231053_2y3ah | UK008T | 2024-10-28T12:16:52.627Z | 2024-11-03T14:27:26.700Z |
5395670 | 5395670 | 20241025230345_265KH | UK008T | 2024-10-28T12:16:38.056Z | 2024-11-03T14:27:26.383Z |
5395629 | 5395629 | 20241025230014_j0iQn | UK008T | 2024-10-28T12:16:34.345Z | 2024-11-03T14:27:26.298Z |
5395401 | 5395401 | 20241025224035_XthSJ | UK008T | 2024-10-28T12:16:12.668Z | 2024-11-03T14:27:25.452Z |
5395318 | 5395318 | 20241025223222_i2uyi | UK008T | 2024-10-28T12:16:07.284Z | 2024-11-03T14:27:25.017Z |
5394645 | 5394645 | 20241025210154_9Xbfn | UK008T | 2024-10-28T12:15:09.402Z | 2024-11-03T14:27:21.962Z |
5387214 | 5387214 | 20241025021233_6n3WQ | UK008T | 2024-10-27T12:21:00.567Z | 2024-11-02T12:28:32.231Z |
5387197 | 5387197 | 20241025021000_p06A4 | UK008T | 2024-10-27T12:20:59.324Z | 2024-11-02T12:28:32.202Z |
5387182 | 5387182 | 20241025020812_wAgzs | UK008T | 2024-10-27T12:20:58.951Z | 2024-11-02T12:28:32.197Z |
5387173 | 5387173 | 20241025020749_U34Ok | UK008T | 2024-10-27T12:20:58.036Z | 2024-11-02T12:28:32.170Z |
5387168 | 5387168 | 20241025020743_aCFaz | UK008T | 2024-10-27T12:20:57.952Z | 2024-11-02T12:28:32.170Z |
5387145 | 5387145 | 20241025020630_r5cPu | UK008T | 2024-10-27T12:20:56.065Z | 2024-11-02T12:28:32.156Z |
5386989 | 5386989 | 20241025014704_xkJ9j | UK008T | 2024-10-27T12:20:46.009Z | 2024-11-02T12:28:31.792Z |
5386778 | 5386778 | 20241025012428_G8F23 | UK008T | 2024-10-27T12:20:27.276Z | 2024-11-02T12:28:31.576Z |
5386710 | 5386710 | 20241025011805_IceNN | UK008T | 2024-10-27T12:20:20.680Z | 2024-11-02T12:28:31.503Z |
5386551 | 5386551 | 20241025010057_3sS9I | UK008T | 2024-10-27T12:20:10.244Z | 2024-11-02T12:28:31.335Z |
5386464 | 5386464 | 20241025004546_O5D8O | UK008T | 2024-10-27T12:20:06.578Z | 2024-11-02T12:28:31.265Z |
5386346 | 5386346 | 20241025002759_mOXIH | UK008T | 2024-10-27T12:20:00.978Z | 2024-11-02T12:28:31.104Z |
5386271 | 5386271 | 20241025002058_GYJdd | UK008T | 2024-10-27T12:19:58.119Z | 2024-11-02T12:28:30.910Z |
5386252 | 5386252 | 20241025001801_dKJcs | UK008T | 2024-10-27T12:19:56.958Z | 2024-11-02T12:28:30.877Z |
5386177 | 5386177 | 20241025001148_jxwvP | UK008T | 2024-10-27T12:19:54.033Z | 2024-11-02T12:28:30.825Z |
5386062 | 5386062 | 20241024235903_pL2CD | UK008T | 2024-10-27T12:19:48.219Z | 2024-11-02T12:28:30.652Z |
5386027 | 5386027 | 20241024235423_LicKM | UK008T | 2024-10-27T12:19:46.365Z | 2024-11-02T12:28:30.590Z |
5385991 | 5385991 | 20241024235200_T8B9W | UK008T | 2024-10-27T12:19:43.877Z | 2024-11-02T12:28:30.562Z |
5385882 | 5385882 | 20241024233951_DCYQn | UK008T | 2024-10-27T12:19:34.429Z | 2024-11-02T12:28:30.443Z |
5385737 | 5385737 | 20241024232305_gkBON | UK008T | 2024-10-27T12:19:20.209Z | 2024-11-02T12:28:30.128Z |
5385667 | 5385667 | 20241024231626_38ejW | UK008T | 2024-10-27T12:19:15.364Z | 2024-11-02T12:28:30.024Z |
5385363 | 5385363 | 20241024223035_LtXUl | UK008T | 2024-10-27T12:18:47.820Z | 2024-11-02T12:28:29.669Z |
5385332 | 5385332 | 20241024222534_P0iOX | UK008T | 2024-10-27T12:18:45.279Z | 2024-11-02T12:28:29.558Z |
5384508 | 5384508 | 20241024201525_K0Ycc | UK008T | 2024-10-27T12:17:08.750Z | 2024-11-02T12:28:27.259Z |
5384385 | 5384385 | 20241024200115_HQEcr | UK008T | 2024-10-27T12:17:00.112Z | 2024-11-02T12:28:27.112Z |
5378022 | 5378022 | 20241024052400_4aHkL | UK008T | 2024-10-26T12:22:52.883Z | 2024-11-01T12:27:03.228Z |
5377912 | 5377912 | 20241024051740_HIpBz | UK008T | 2024-10-26T12:22:49.730Z | 2024-11-01T12:27:03.161Z |
5377761 | 5377761 | 20241024050757_s0IkZ | UK008T | 2024-10-26T12:22:46.430Z | 2024-11-01T12:27:02.774Z |
5377712 | 5377712 | 20241024050528_jlCVj | UK008T | 2024-10-26T12:22:44.700Z | 2024-11-01T12:27:02.727Z |
5377458 | 5377458 | 20241024045147_3i9zj | UK008T | 2024-10-26T12:22:37.423Z | 2024-11-01T12:27:02.446Z |
5377221 | 5377221 | 20241024043923_4cqNt | UK008T | 2024-10-26T12:22:31.534Z | 2024-11-01T12:27:02.329Z |
5377144 | 5377144 | 20241024043451_ZsXrl | UK008T | 2024-10-26T12:22:28.349Z | 2024-11-01T12:27:02.207Z |
5376871 | 5376871 | 20241024042013_nqbi4 | UK008T | 2024-10-26T12:22:15.230Z | 2024-11-01T12:27:01.902Z |
5376853 | 5376853 | 20241024041927_bOcas | UK008T | 2024-10-26T12:22:14.869Z | 2024-11-01T12:27:01.898Z |
5376667 | 5376667 | 20241024040729_uHMrJ | UK008T | 2024-10-26T12:22:10.168Z | 2024-11-01T12:27:01.737Z |
5376529 | 5376529 | 20241024035905_uuXRi | UK008T | 2024-10-26T12:22:04.607Z | 2024-11-01T12:27:01.589Z |
5376513 | 5376513 | 20241024035826_lnRsN | UK008T | 2024-10-26T12:22:03.701Z | 2024-11-01T12:27:01.583Z |
5376448 | 5376448 | 20241024035548_8MEn1 | UK008T | 2024-10-26T12:22:02.569Z | 2024-11-01T12:27:01.560Z |
5376416 | 5376416 | 20241024035412_pH6us | UK008T | 2024-10-26T12:22:01.920Z | 2024-11-01T12:27:01.532Z |
5376153 | 5376153 | 20241024034337_gNRdN | UK008T | 2024-10-26T12:21:52.383Z | 2024-11-01T12:27:01.414Z |
5376117 | 5376117 | 20241024034203_MWHfE | UK008T | 2024-10-26T12:21:51.716Z | 2024-11-01T12:27:01.395Z |
5376040 | 5376040 | 20241024033902_o50Wi | UK008T | 2024-10-26T12:21:48.093Z | 2024-11-01T12:27:01.342Z |
5375697 | 5375697 | 20241024032502_xhTI2 | UK008T | 2024-10-26T12:21:35.803Z | 2024-11-01T12:27:01.164Z |
5375610 | 5375610 | 20241024032124_fR7St | UK008T | 2024-10-26T12:21:33.073Z | 2024-11-01T12:27:01.106Z |
5375580 | 5375580 | 20241024032028_8a9bA | UK008T | 2024-10-26T12:21:32.002Z | 2024-11-01T12:27:00.937Z |
5375576 | 5375576 | 20241024032018_EdaAg | UK008T | 2024-10-26T12:21:31.963Z | 2024-11-01T12:27:00.935Z |
5375407 | 5375407 | 20241024031147_ZgQsq | UK008T | 2024-10-26T12:21:23.686Z | 2024-11-01T12:27:00.666Z |
5375004 | 5375004 | 20241024025221_v7T8A | UK008T | 2024-10-26T12:21:09.223Z | 2024-11-01T12:27:00.111Z |
5374607 | 5374607 | 20241024023630_84qXv | UK008T | 2024-10-26T12:20:54.673Z | 2024-11-01T12:26:59.517Z |
5374079 | 5374079 | 20241024020853_ojzPR | UK008T | 2024-10-26T12:20:36.583Z | 2024-11-01T12:26:58.691Z |
5374035 | 5374035 | 20241024020647_0C2uc | UK008T | 2024-10-26T12:20:35.187Z | 2024-11-01T12:26:58.640Z |
5373825 | 5373825 | 20241024015546_XsvAy | UK008T | 2024-10-26T12:20:26.895Z | 2024-11-01T12:26:58.513Z |
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);