participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,455 rows where station_code = "UK008X" 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 |
---|---|---|---|---|---|
5570202 | 5570202 | 20241120190318_rWMRF | UK008X | 2024-11-22T14:15:00.651Z | 2024-11-22T14:19:21.880Z |
5570194 | 5570194 | 20241120190139_VUrD9 | UK008X | 2024-11-22T14:15:00.036Z | 2024-11-22T14:19:21.879Z |
5570133 | 5570133 | 20241120184910_TWQP0 | UK008X | 2024-11-22T14:14:54.400Z | 2024-11-22T14:19:21.868Z |
5570047 | 5570047 | 20241120182936_zfOy8 | UK008X | 2024-11-22T14:14:47.258Z | 2024-11-22T14:19:21.851Z |
5570033 | 5570033 | 20241120182640_kBOXE | UK008X | 2024-11-22T14:14:46.510Z | 2024-11-22T14:19:21.849Z |
5569945 | 5569945 | 20241120180150_XBCnn | UK008X | 2024-11-22T14:14:38.689Z | 2024-11-22T14:19:21.833Z |
5564641 | 5564641 | 20241120031503_WJmj2 | UK008X | 2024-11-21T14:17:54.762Z | 2024-11-22T14:21:34.535Z |
5564540 | 5564540 | 20241120030745_3Svql | UK008X | 2024-11-21T14:17:47.420Z | 2024-11-22T14:21:33.414Z |
5564429 | 5564429 | 20241120025723_V3rfT | UK008X | 2024-11-21T14:17:35.025Z | 2024-11-22T14:21:31.776Z |
5564300 | 5564300 | 20241120024647_ofLd1 | UK008X | 2024-11-21T14:17:26.387Z | 2024-11-22T14:21:30.183Z |
5564233 | 5564233 | 20241120024052_F3pwJ | UK008X | 2024-11-21T14:17:21.119Z | 2024-11-22T14:21:29.276Z |
5563979 | 5563979 | 20241120021933_lxIJ6 | UK008X | 2024-11-21T14:17:01.382Z | 2024-11-22T14:21:25.884Z |
5563137 | 5563137 | 20241120005608_vrAC0 | UK008X | 2024-11-21T14:15:37.746Z | 2024-11-22T14:21:09.935Z |
5563121 | 5563121 | 20241120005428_0MmQS | UK008X | 2024-11-21T14:15:37.406Z | 2024-11-22T14:21:09.868Z |
5563117 | 5563117 | 20241120005415_rN32y | UK008X | 2024-11-21T14:15:37.313Z | 2024-11-22T14:21:09.840Z |
5563104 | 5563104 | 20241120005255_SpSvv | UK008X | 2024-11-21T14:15:36.930Z | 2024-11-22T14:21:09.646Z |
5562986 | 5562986 | 20241120003609_uhhB1 | UK008X | 2024-11-21T14:15:30.769Z | 2024-11-22T14:21:07.463Z |
5562980 | 5562980 | 20241120003535_gKjM0 | UK008X | 2024-11-21T14:15:30.632Z | 2024-11-22T14:21:07.435Z |
5562767 | 5562767 | 20241120001011_bzvpf | UK008X | 2024-11-21T14:15:20.858Z | 2024-11-22T14:21:03.672Z |
5562735 | 5562735 | 20241120000600_3efoe | UK008X | 2024-11-21T14:15:18.670Z | 2024-11-22T14:21:03.082Z |
5562720 | 5562720 | 20241120000532_AMmcN | UK008X | 2024-11-21T14:15:18.079Z | 2024-11-22T14:21:02.847Z |
5562695 | 5562695 | 20241120000409_kYvs2 | UK008X | 2024-11-21T14:15:17.226Z | 2024-11-22T14:21:02.583Z |
5562539 | 5562539 | 20241119234903_NDZLV | UK008X | 2024-11-21T14:15:06.632Z | 2024-11-22T14:21:00.014Z |
5562341 | 5562341 | 20241119232748_gsc0w | UK008X | 2024-11-21T14:14:43.702Z | 2024-11-22T14:20:56.409Z |
5562251 | 5562251 | 20241119231605_1Ydoh | UK008X | 2024-11-21T14:14:36.362Z | 2024-11-22T14:20:54.546Z |
5562175 | 5562175 | 20241119230840_X7t8Y | UK008X | 2024-11-21T14:14:30.948Z | 2024-11-22T14:20:53.827Z |
5561945 | 5561945 | 20241119223838_cWhbF | UK008X | 2024-11-21T14:14:16.296Z | 2024-11-22T14:20:50.099Z |
5561941 | 5561941 | 20241119223631_eMMNm | UK008X | 2024-11-21T14:14:16.027Z | 2024-11-22T14:20:50.054Z |
5561913 | 5561913 | 20241119222847_Ty2v9 | UK008X | 2024-11-21T14:14:13.547Z | 2024-11-22T14:20:49.251Z |
5561819 | 5561819 | 20241119221347_AOuoL | UK008X | 2024-11-21T14:14:08.333Z | 2024-11-22T14:20:47.066Z |
5561779 | 5561779 | 20241119220551_aLMet | UK008X | 2024-11-21T14:14:04.592Z | 2024-11-22T14:20:45.888Z |
5561720 | 5561720 | 20241119215023_HX9Nr | UK008X | 2024-11-21T14:13:51.710Z | 2024-11-22T14:20:44.488Z |
5561660 | 5561660 | 20241119212806_htdDu | UK008X | 2024-11-21T14:13:41.423Z | 2024-11-22T14:20:42.634Z |
5561517 | 5561517 | 20241119205123_zBptH | UK008X | 2024-11-21T14:13:23.591Z | 2024-11-22T14:20:39.451Z |
5561469 | 5561469 | 20241119204240_EhpUm | UK008X | 2024-11-21T14:13:19.598Z | 2024-11-22T14:20:37.625Z |
5561378 | 5561378 | 20241119201929_hp9Eg | UK008X | 2024-11-21T14:13:11.078Z | 2024-11-22T14:20:34.008Z |
5561336 | 5561336 | 20241119195831_mzQ2r | UK008X | 2024-11-21T14:13:06.728Z | 2024-11-22T14:20:32.368Z |
5561266 | 5561266 | 20241119192510_RqJVD | UK008X | 2024-11-21T14:12:54.288Z | 2024-11-22T14:20:29.212Z |
5561238 | 5561238 | 20241119191505_pRdrh | UK008X | 2024-11-21T14:12:43.756Z | 2024-11-22T14:20:27.219Z |
5558430 | 5558430 | 20241120060344_X64I7 | UK008X | 2024-11-21T14:03:14.601Z | 2024-11-22T14:19:21.227Z |
5557798 | 5557798 | 20241120051207_YjHDn | UK008X | 2024-11-21T14:01:46.550Z | 2024-11-22T14:19:21.129Z |
5557736 | 5557736 | 20241120050906_tLQZv | UK008X | 2024-11-21T14:01:36.682Z | 2024-11-22T14:19:21.119Z |
5545058 | 5545058 | 20241115230115_0LjLt | UK008X | 2024-11-17T14:03:42.360Z | 2024-11-22T14:23:35.669Z |
5545052 | 5545052 | 20241115225356_P7Abs | UK008X | 2024-11-17T14:03:41.388Z | 2024-11-22T14:23:35.593Z |
5545030 | 5545030 | 20241115223339_140pI | UK008X | 2024-11-17T14:03:39.019Z | 2024-11-22T14:23:35.317Z |
5544976 | 5544976 | 20241115204754_sOqLx | UK008X | 2024-11-17T14:03:33.036Z | 2024-11-22T14:23:34.974Z |
5544964 | 5544964 | 20241115202200_XDDR9 | UK008X | 2024-11-17T14:03:32.229Z | 2024-11-22T14:23:34.537Z |
5541218 | 5541218 | 20241113200953_dsIim | UK008X | 2024-11-15T14:06:57.840Z | 2024-11-22T14:24:17.069Z |
5541192 | 5541192 | 20241113192257_1cxL2 | UK008X | 2024-11-15T14:06:52.401Z | 2024-11-22T14:24:16.453Z |
5541184 | 5541184 | 20241113185414_ZHH2T | UK008X | 2024-11-15T14:06:51.355Z | 2024-11-22T14:24:16.340Z |
5531854 | 5531854 | 20241112041322_XybJW | UK008X | 2024-11-13T14:15:59.016Z | 2024-11-20T14:26:15.276Z |
5531655 | 5531655 | 20241112035730_bPtix | UK008X | 2024-11-13T14:15:48.836Z | 2024-11-20T14:26:13.038Z |
5531505 | 5531505 | 20241112034419_bJZx1 | UK008X | 2024-11-13T14:15:43.042Z | 2024-11-20T14:26:11.844Z |
5531357 | 5531357 | 20241112033335_rzhbH | UK008X | 2024-11-13T14:15:35.512Z | 2024-11-20T14:26:10.456Z |
5531313 | 5531313 | 20241112033136_R6Kik | UK008X | 2024-11-13T14:15:34.155Z | 2024-11-20T14:26:10.346Z |
5531049 | 5531049 | 20241112030839_CPtWJ | UK008X | 2024-11-13T14:15:06.454Z | 2024-11-20T14:26:06.661Z |
5530878 | 5530878 | 20241112025657_rxk41 | UK008X | 2024-11-13T14:14:46.909Z | 2024-11-20T14:26:04.368Z |
5530308 | 5530308 | 20241112020721_64kxi | UK008X | 2024-11-13T14:14:08.048Z | 2024-11-20T14:25:56.826Z |
5530151 | 5530151 | 20241112015020_02zZW | UK008X | 2024-11-13T14:13:58.730Z | 2024-11-20T14:25:54.875Z |
5529728 | 5529728 | 20241112010044_QUDDL | UK008X | 2024-11-13T14:13:08.227Z | 2024-11-20T14:25:47.723Z |
5529620 | 5529620 | 20241112004431_5p4mm | UK008X | 2024-11-13T14:13:02.243Z | 2024-11-20T14:25:46.813Z |
5529561 | 5529561 | 20241112003514_aDMeq | UK008X | 2024-11-13T14:12:58.058Z | 2024-11-20T14:25:46.268Z |
5529546 | 5529546 | 20241112003306_borKW | UK008X | 2024-11-13T14:12:57.245Z | 2024-11-20T14:25:46.227Z |
5529463 | 5529463 | 20241112002229_B12OI | UK008X | 2024-11-13T14:12:52.604Z | 2024-11-20T14:25:45.233Z |
5529314 | 5529314 | 20241112000048_Dp53Y | UK008X | 2024-11-13T14:12:21.467Z | 2024-11-20T14:25:42.767Z |
5529074 | 5529074 | 20241111232525_DMIC8 | UK008X | 2024-11-13T14:12:02.689Z | 2024-11-20T14:25:39.461Z |
5528430 | 5528430 | 20241111204736_zqtWD | UK008X | 2024-11-13T14:10:37.652Z | 2024-11-20T14:25:30.536Z |
5528334 | 5528334 | 20241111202454_1tv5h | UK008X | 2024-11-13T14:10:27.953Z | 2024-11-20T14:25:28.539Z |
5528029 | 5528029 | 20241111191907_dmK5d | UK008X | 2024-11-13T14:09:43.482Z | 2024-11-20T14:25:24.251Z |
5527702 | 5527702 | 20241111181851_McCzA | UK008X | 2024-11-13T14:08:56.885Z | 2024-11-20T14:25:18.292Z |
5444492 | 5444492 | 20241031012558_2yC02 | UK008X | 2024-11-01T12:21:19.968Z | 2024-11-08T14:23:15.737Z |
5444299 | 5444299 | 20241031010540_vvAxm | UK008X | 2024-11-01T12:21:12.258Z | 2024-11-08T14:23:14.289Z |
5444292 | 5444292 | 20241031010528_ZzFGc | UK008X | 2024-11-01T12:21:12.158Z | 2024-11-08T14:23:14.282Z |
5440596 | 5440596 | 20241030223112_2scyg | UK008X | 2024-11-01T12:15:38.649Z | 2024-11-08T14:23:09.976Z |
5440441 | 5440441 | 20241030221300_bZf3w | UK008X | 2024-11-01T12:15:30.905Z | 2024-11-08T14:23:09.437Z |
5440416 | 5440416 | 20241030220853_1tx8l | UK008X | 2024-11-01T12:15:29.499Z | 2024-11-08T14:23:09.370Z |
5440356 | 5440356 | 20241030220212_DSR3I | UK008X | 2024-11-01T12:15:26.190Z | 2024-11-08T14:23:09.194Z |
5440314 | 5440314 | 20241030215554_ZwxHj | UK008X | 2024-11-01T12:15:21.835Z | 2024-11-08T14:23:08.939Z |
5440208 | 5440208 | 20241030214320_2wrRa | UK008X | 2024-11-01T12:14:58.164Z | 2024-11-08T14:23:07.709Z |
5440185 | 5440185 | 20241030213846_GVFSz | UK008X | 2024-11-01T12:14:56.183Z | 2024-11-08T14:23:07.676Z |
5440106 | 5440106 | 20241030212312_cPqJP | UK008X | 2024-11-01T12:14:50.416Z | 2024-11-08T14:23:07.350Z |
5440009 | 5440009 | 20241030210651_l7aCB | UK008X | 2024-11-01T12:14:44.277Z | 2024-11-08T14:23:06.789Z |
5433007 | 5433007 | 20241029054238_DpWzr | UK008X | 2024-10-31T12:21:42.717Z | 2024-11-06T14:27:29.600Z |
5432930 | 5432930 | 20241029051904_Yq71a | UK008X | 2024-10-31T12:21:39.264Z | 2024-11-06T14:27:29.325Z |
5432920 | 5432920 | 20241029051557_vzksp | UK008X | 2024-10-31T12:21:38.855Z | 2024-11-06T14:27:29.287Z |
5432884 | 5432884 | 20241029050615_EiyHx | UK008X | 2024-10-31T12:21:37.712Z | 2024-11-06T14:27:29.090Z |
5432809 | 5432809 | 20241029044303_wrtpT | UK008X | 2024-10-31T12:21:35.859Z | 2024-11-06T14:27:28.782Z |
5432684 | 5432684 | 20241029041630_jgIiI | UK008X | 2024-10-31T12:21:31.201Z | 2024-11-06T14:27:28.437Z |
5432651 | 5432651 | 20241029040908_wJHoF | UK008X | 2024-10-31T12:21:30.036Z | 2024-11-06T14:27:28.304Z |
5432618 | 5432618 | 20241029040451_5nk7f | UK008X | 2024-10-31T12:21:28.887Z | 2024-11-06T14:27:28.245Z |
5432574 | 5432574 | 20241029035426_Lh3QG | UK008X | 2024-10-31T12:21:27.410Z | 2024-11-06T14:27:27.958Z |
5432525 | 5432525 | 20241029034636_oGTD2 | UK008X | 2024-10-31T12:21:26.152Z | 2024-11-06T14:27:27.783Z |
5417781 | 5417781 | 20241027191232_Gz1bM | UK008X | 2024-10-30T12:14:27.701Z | 2024-11-05T14:27:08.255Z |
5417615 | 5417615 | 20241027185350_nnM0P | UK008X | 2024-10-30T12:13:59.783Z | 2024-11-05T14:27:07.802Z |
5417345 | 5417345 | 20241027181706_YFUT0 | UK008X | 2024-10-30T12:13:33.209Z | 2024-11-05T14:27:06.985Z |
5410842 | 5410842 | 20241027054026_oAmxG | UK008X | 2024-10-29T12:18:05.999Z | 2024-11-04T14:29:05.647Z |
5410548 | 5410548 | 20241027051723_5XDE3 | UK008X | 2024-10-29T12:17:57.937Z | 2024-11-04T14:29:04.806Z |
5410338 | 5410338 | 20241027050707_1K6eG | UK008X | 2024-10-29T12:17:53.420Z | 2024-11-04T14:29:04.346Z |
5410182 | 5410182 | 20241027045842_zgaZJ | UK008X | 2024-10-29T12:17:50.045Z | 2024-11-04T14:29:03.987Z |
5410052 | 5410052 | 20241027044921_a0NsN | UK008X | 2024-10-29T12:17:46.601Z | 2024-11-04T14:29:03.633Z |
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);