participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,031 rows where station_code = "UK003Y" 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 |
---|---|---|---|---|---|
5565402 | 5565402 | 20241120042318_aTjUq | UK003Y | 2024-11-21T14:18:48.078Z | 2024-11-21T14:18:54.204Z |
5565249 | 5565249 | 20241120040801_0Nlhr | UK003Y | 2024-11-21T14:18:43.892Z | 2024-11-21T14:18:54.180Z |
5565168 | 5565168 | 20241120035928_kwaNd | UK003Y | 2024-11-21T14:18:34.815Z | 2024-11-21T14:18:54.166Z |
5565151 | 5565151 | 20241120035721_5YBr7 | UK003Y | 2024-11-21T14:18:33.979Z | 2024-11-21T14:18:54.162Z |
5565141 | 5565141 | 20241120035640_BCjQl | UK003Y | 2024-11-21T14:18:33.820Z | 2024-11-21T14:18:54.162Z |
5564911 | 5564911 | 20241120033850_oLYLi | UK003Y | 2024-11-21T14:18:14.992Z | 2024-11-21T14:18:54.124Z |
5564671 | 5564671 | 20241120031814_zV0ON | UK003Y | 2024-11-21T14:17:57.060Z | 2024-11-21T14:18:54.081Z |
5564510 | 5564510 | 20241120030449_VROSs | UK003Y | 2024-11-21T14:17:44.436Z | 2024-11-21T14:18:54.053Z |
5564399 | 5564399 | 20241120025231_Rvoz9 | UK003Y | 2024-11-21T14:17:32.947Z | 2024-11-21T14:18:54.036Z |
5564390 | 5564390 | 20241120025216_7Xw20 | UK003Y | 2024-11-21T14:17:32.283Z | 2024-11-21T14:18:54.035Z |
5564367 | 5564367 | 20241120025003_9WlQq | UK003Y | 2024-11-21T14:17:30.998Z | 2024-11-21T14:18:54.031Z |
5564181 | 5564181 | 20241120023548_rvxQG | UK003Y | 2024-11-21T14:17:16.385Z | 2024-11-21T14:18:53.998Z |
5564009 | 5564009 | 20241120022316_UftIc | UK003Y | 2024-11-21T14:17:04.828Z | 2024-11-21T14:18:53.964Z |
5563928 | 5563928 | 20241120021657_hKzAn | UK003Y | 2024-11-21T14:16:59.251Z | 2024-11-21T14:18:53.949Z |
5563862 | 5563862 | 20241120021102_0LFyl | UK003Y | 2024-11-21T14:16:51.665Z | 2024-11-21T14:18:53.933Z |
5563806 | 5563806 | 20241120020535_lRDxZ | UK003Y | 2024-11-21T14:16:45.186Z | 2024-11-21T14:18:53.921Z |
5563646 | 5563646 | 20241120015430_O6XYk | UK003Y | 2024-11-21T14:16:31.604Z | 2024-11-21T14:18:53.895Z |
5563490 | 5563490 | 20241120013405_rGSAU | UK003Y | 2024-11-21T14:16:10.760Z | 2024-11-21T14:18:53.863Z |
5563437 | 5563437 | 20241120013014_UYaqJ | UK003Y | 2024-11-21T14:16:06.523Z | 2024-11-21T14:18:53.856Z |
5563279 | 5563279 | 20241120011411_nldKo | UK003Y | 2024-11-21T14:15:50.816Z | 2024-11-21T14:18:53.824Z |
5563242 | 5563242 | 20241120011029_IFqzH | UK003Y | 2024-11-21T14:15:44.628Z | 2024-11-21T14:18:53.815Z |
5563200 | 5563200 | 20241120010351_zx3Fn | UK003Y | 2024-11-21T14:15:40.250Z | 2024-11-21T14:18:53.806Z |
5563125 | 5563125 | 20241120005505_03M06 | UK003Y | 2024-11-21T14:15:37.548Z | 2024-11-21T14:18:53.794Z |
5563061 | 5563061 | 20241120004816_rqHn5 | UK003Y | 2024-11-21T14:15:34.305Z | 2024-11-21T14:18:53.785Z |
5562951 | 5562951 | 20241120003434_BjLPD | UK003Y | 2024-11-21T14:15:30.010Z | 2024-11-21T14:18:53.768Z |
5562939 | 5562939 | 20241120002958_xl9UL | UK003Y | 2024-11-21T14:15:28.277Z | 2024-11-21T14:18:53.764Z |
5562904 | 5562904 | 20241120002615_NrxiU | UK003Y | 2024-11-21T14:15:26.917Z | 2024-11-21T14:18:53.758Z |
5562785 | 5562785 | 20241120001231_GzsyU | UK003Y | 2024-11-21T14:15:21.977Z | 2024-11-21T14:18:53.739Z |
5562741 | 5562741 | 20241120000711_BDsSN | UK003Y | 2024-11-21T14:15:19.453Z | 2024-11-21T14:18:53.731Z |
5562366 | 5562366 | 20241119233112_3NebH | UK003Y | 2024-11-21T14:14:45.255Z | 2024-11-21T14:18:53.673Z |
5562292 | 5562292 | 20241119231956_clME5 | UK003Y | 2024-11-21T14:14:40.899Z | 2024-11-21T14:18:53.663Z |
5562281 | 5562281 | 20241119231951_0jSkf | UK003Y | 2024-11-21T14:14:40.153Z | 2024-11-21T14:18:53.661Z |
5562210 | 5562210 | 20241119230942_vfivv | UK003Y | 2024-11-21T14:14:32.536Z | 2024-11-21T14:18:53.649Z |
5561927 | 5561927 | 20241119223038_KVjAu | UK003Y | 2024-11-21T14:14:14.872Z | 2024-11-21T14:18:53.605Z |
5561827 | 5561827 | 20241119221514_CIGAA | UK003Y | 2024-11-21T14:14:08.992Z | 2024-11-21T14:18:53.588Z |
5561746 | 5561746 | 20241119215845_wRER8 | UK003Y | 2024-11-21T14:13:56.735Z | 2024-11-21T14:18:53.573Z |
5561725 | 5561725 | 20241119215116_Muxed | UK003Y | 2024-11-21T14:13:52.388Z | 2024-11-21T14:18:53.569Z |
5561688 | 5561688 | 20241119214056_G7WpM | UK003Y | 2024-11-21T14:13:45.748Z | 2024-11-21T14:18:53.562Z |
5561553 | 5561553 | 20241119210202_MfY5Q | UK003Y | 2024-11-21T14:13:27.330Z | 2024-11-21T14:18:53.537Z |
5561499 | 5561499 | 20241119205006_29Yyd | UK003Y | 2024-11-21T14:13:21.910Z | 2024-11-21T14:18:53.526Z |
5561364 | 5561364 | 20241119201242_uRG9k | UK003Y | 2024-11-21T14:13:09.582Z | 2024-11-21T14:18:53.486Z |
5561261 | 5561261 | 20241119192438_x7DM3 | UK003Y | 2024-11-21T14:12:52.362Z | 2024-11-21T14:18:53.452Z |
5561232 | 5561232 | 20241119191419_2SBbX | UK003Y | 2024-11-21T14:12:43.370Z | 2024-11-21T14:18:53.440Z |
5561228 | 5561228 | 20241119191127_jKOgr | UK003Y | 2024-11-21T14:12:42.554Z | 2024-11-21T14:18:53.439Z |
5561186 | 5561186 | 20241119185407_Fff9H | UK003Y | 2024-11-21T14:12:34.323Z | 2024-11-21T14:18:53.428Z |
5561169 | 5561169 | 20241119184908_B1FYX | UK003Y | 2024-11-21T14:12:32.393Z | 2024-11-21T14:18:53.423Z |
5561089 | 5561089 | 20241119180645_FTmFC | UK003Y | 2024-11-21T14:12:21.942Z | 2024-11-21T14:18:53.400Z |
5558540 | 5558540 | 20241120062705_PX2o4 | UK003Y | 2024-11-21T14:03:33.631Z | 2024-11-21T14:03:33.631Z |
5558526 | 5558526 | 20241120062202_pzJYZ | UK003Y | 2024-11-21T14:03:31.334Z | 2024-11-21T14:03:31.334Z |
5558386 | 5558386 | 20241120060139_ItavS | UK003Y | 2024-11-21T14:03:10.710Z | 2024-11-21T14:03:10.710Z |
5558300 | 5558300 | 20241120055255_bP7R8 | UK003Y | 2024-11-21T14:02:57.944Z | 2024-11-21T14:02:57.944Z |
5558240 | 5558240 | 20241120054816_x3Man | UK003Y | 2024-11-21T14:02:51.234Z | 2024-11-21T14:02:51.234Z |
5558173 | 5558173 | 20241120054212_4oc2A | UK003Y | 2024-11-21T14:02:39.462Z | 2024-11-21T14:02:39.462Z |
5557938 | 5557938 | 20241120052419_OP8bJ | UK003Y | 2024-11-21T14:02:06.207Z | 2024-11-21T14:02:06.207Z |
5557698 | 5557698 | 20241120050517_GLhx3 | UK003Y | 2024-11-21T14:01:32.054Z | 2024-11-21T14:01:32.054Z |
5557636 | 5557636 | 20241120050301_5KEsy | UK003Y | 2024-11-21T14:01:24.371Z | 2024-11-21T14:01:24.371Z |
5557366 | 5557366 | 20241120044111_M0LK2 | UK003Y | 2024-11-21T14:00:37.671Z | 2024-11-21T14:00:37.671Z |
5552985 | 5552985 | 20241117235525_9Xzjv | UK003Y | 2024-11-19T14:09:54.966Z | 2024-11-21T14:22:05.389Z |
5552964 | 5552964 | 20241117234755_4hzHo | UK003Y | 2024-11-19T14:09:53.783Z | 2024-11-21T14:22:05.209Z |
5552745 | 5552745 | 20241117210933_IYpwU | UK003Y | 2024-11-19T14:09:06.360Z | 2024-11-21T14:21:59.209Z |
5552517 | 5552517 | 20241117181559_IFBQ4 | UK003Y | 2024-11-19T14:08:26.523Z | 2024-11-21T14:21:45.940Z |
5548586 | 5548586 | 20241117002803_lcc89 | UK003Y | 2024-11-18T14:09:32.646Z | 2024-11-21T14:22:59.756Z |
5548533 | 5548533 | 20241117001039_l5ACv | UK003Y | 2024-11-18T14:09:25.224Z | 2024-11-21T14:22:58.537Z |
5548480 | 5548480 | 20241116234856_JbRhe | UK003Y | 2024-11-18T14:09:19.546Z | 2024-11-21T14:22:57.499Z |
5548343 | 5548343 | 20241116224239_olDQu | UK003Y | 2024-11-18T14:08:50.030Z | 2024-11-21T14:22:54.574Z |
5548327 | 5548327 | 20241116222836_1rx9s | UK003Y | 2024-11-18T14:08:46.533Z | 2024-11-21T14:22:54.050Z |
5548233 | 5548233 | 20241116214344_OKuvy | UK003Y | 2024-11-18T14:08:31.457Z | 2024-11-21T14:22:51.409Z |
5537016 | 5537016 | 20241112200647_9P4un | UK003Y | 2024-11-14T14:10:50.668Z | 2024-11-21T14:26:07.973Z |
5536986 | 5536986 | 20241112195933_x3Rkn | UK003Y | 2024-11-14T14:10:48.758Z | 2024-11-21T14:26:07.679Z |
5536816 | 5536816 | 20241112192025_gB88u | UK003Y | 2024-11-14T14:10:35.063Z | 2024-11-21T14:26:05.928Z |
5536513 | 5536513 | 20241112182314_4v06J | UK003Y | 2024-11-14T14:10:09.018Z | 2024-11-21T14:26:01.782Z |
5536472 | 5536472 | 20241112181016_ZoubE | UK003Y | 2024-11-14T14:10:01.803Z | 2024-11-21T14:26:01.223Z |
5531786 | 5531786 | 20241112040906_atty8 | UK003Y | 2024-11-13T14:15:55.054Z | 2024-11-20T14:26:14.329Z |
5531559 | 5531559 | 20241112034825_2LcNs | UK003Y | 2024-11-13T14:15:44.827Z | 2024-11-20T14:26:12.349Z |
5531431 | 5531431 | 20241112033905_I5rSH | UK003Y | 2024-11-13T14:15:39.169Z | 2024-11-20T14:26:11.261Z |
5531397 | 5531397 | 20241112033715_4UJyT | UK003Y | 2024-11-13T14:15:37.551Z | 2024-11-20T14:26:11.132Z |
5531350 | 5531350 | 20241112033259_iBI7F | UK003Y | 2024-11-13T14:15:35.472Z | 2024-11-20T14:26:10.452Z |
5530851 | 5530851 | 20241112025253_dgKqr | UK003Y | 2024-11-13T14:14:43.704Z | 2024-11-20T14:26:04.029Z |
5530835 | 5530835 | 20241112025134_ZroNL | UK003Y | 2024-11-13T14:14:42.787Z | 2024-11-20T14:26:03.976Z |
5530451 | 5530451 | 20241112021846_NWJT6 | UK003Y | 2024-11-13T14:14:16.201Z | 2024-11-20T14:26:00.206Z |
5530300 | 5530300 | 20241112020639_UDDIo | UK003Y | 2024-11-13T14:14:07.654Z | 2024-11-20T14:25:56.757Z |
5530096 | 5530096 | 20241112014309_oKyEJ | UK003Y | 2024-11-13T14:13:51.609Z | 2024-11-20T14:25:54.296Z |
5529963 | 5529963 | 20241112012939_pQEH8 | UK003Y | 2024-11-13T14:13:30.364Z | 2024-11-20T14:25:51.638Z |
5529540 | 5529540 | 20241112003248_71xjP | UK003Y | 2024-11-13T14:12:57.149Z | 2024-11-20T14:25:46.220Z |
5523564 | 5523564 | 20241111014631_DNeEO | UK003Y | 2024-11-12T14:16:00.590Z | 2024-11-19T14:22:13.355Z |
5523549 | 5523549 | 20241111014417_JXTJH | UK003Y | 2024-11-12T14:15:57.562Z | 2024-11-19T14:22:13.200Z |
5497886 | 5497886 | 20241107054949_66jT6 | UK003Y | 2024-11-08T14:14:29.027Z | 2024-11-15T14:25:06.586Z |
5497877 | 5497877 | 20241107054039_Oc9A1 | UK003Y | 2024-11-08T14:14:28.639Z | 2024-11-15T14:25:06.582Z |
5497835 | 5497835 | 20241107052923_yC719 | UK003Y | 2024-11-08T14:14:25.712Z | 2024-11-15T14:25:06.402Z |
5497823 | 5497823 | 20241107052331_hGOyG | UK003Y | 2024-11-08T14:14:25.217Z | 2024-11-15T14:25:06.371Z |
5400167 | 5400167 | 20241026054809_zM12p | UK003Y | 2024-10-28T12:20:25.275Z | 2024-11-03T14:27:41.451Z |
5399541 | 5399541 | 20241026043330_T2J2E | UK003Y | 2024-10-28T12:20:01.760Z | 2024-11-03T14:27:39.943Z |
5399218 | 5399218 | 20241026040219_cdA3y | UK003Y | 2024-10-28T12:19:51.594Z | 2024-11-03T14:27:39.253Z |
5399181 | 5399181 | 20241026035937_oYHlK | UK003Y | 2024-10-28T12:19:50.765Z | 2024-11-03T14:27:39.194Z |
5385320 | 5385320 | 20241024222452_FZqAg | UK003Y | 2024-10-27T12:18:44.490Z | 2024-11-02T12:28:29.545Z |
5385297 | 5385297 | 20241024222020_xbFCQ | UK003Y | 2024-10-27T12:18:42.754Z | 2024-11-02T12:28:29.535Z |
5384658 | 5384658 | 20241024203347_PTgnd | UK003Y | 2024-10-27T12:17:24.487Z | 2024-11-02T12:28:27.576Z |
5383791 | 5383791 | 20241024190039_aFpvY | UK003Y | 2024-10-27T12:16:09.938Z | 2024-11-02T12:28:26.343Z |
5383571 | 5383571 | 20241024183428_PrrJU | UK003Y | 2024-10-27T12:15:47.572Z | 2024-11-02T12:28:25.767Z |
5383434 | 5383434 | 20241024182103_raDWA | UK003Y | 2024-10-27T12:15:27.421Z | 2024-11-02T12:28:25.308Z |
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);