participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,216 rows where station_code = "UK002L" 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 |
---|---|---|---|---|---|
5565182 | 5565182 | 20241120040045_TMN0l | UK002L | 2024-11-21T14:18:38.969Z | 2024-11-21T14:18:54.170Z |
5565109 | 5565109 | 20241120035217_U14eM | UK002L | 2024-11-21T14:18:31.049Z | 2024-11-21T14:18:54.156Z |
5564994 | 5564994 | 20241120034407_HAfR2 | UK002L | 2024-11-21T14:18:18.510Z | 2024-11-21T14:18:54.136Z |
5564876 | 5564876 | 20241120033423_gAe5H | UK002L | 2024-11-21T14:18:11.309Z | 2024-11-21T14:18:54.117Z |
5564470 | 5564470 | 20241120025913_nSexN | UK002L | 2024-11-21T14:17:39.629Z | 2024-11-21T14:18:54.047Z |
5564167 | 5564167 | 20241120023500_XJRtT | UK002L | 2024-11-21T14:17:15.410Z | 2024-11-21T14:18:53.995Z |
5564093 | 5564093 | 20241120022833_sBY62 | UK002L | 2024-11-21T14:17:08.830Z | 2024-11-21T14:18:53.979Z |
5563874 | 5563874 | 20241120021140_WVpx0 | UK002L | 2024-11-21T14:16:52.554Z | 2024-11-21T14:18:53.935Z |
5563764 | 5563764 | 20241120020258_la1xX | UK002L | 2024-11-21T14:16:42.070Z | 2024-11-21T14:18:53.913Z |
5563556 | 5563556 | 20241120014152_5t7Ly | UK002L | 2024-11-21T14:16:18.956Z | 2024-11-21T14:18:53.876Z |
5563450 | 5563450 | 20241120013114_JVMNY | UK002L | 2024-11-21T14:16:07.113Z | 2024-11-21T14:18:53.857Z |
5563442 | 5563442 | 20241120013102_xXW1g | UK002L | 2024-11-21T14:16:06.967Z | 2024-11-21T14:18:53.857Z |
5563432 | 5563432 | 20241120012944_m541u | UK002L | 2024-11-21T14:16:06.396Z | 2024-11-21T14:18:53.855Z |
5563412 | 5563412 | 20241120012851_WFfzp | UK002L | 2024-11-21T14:16:03.971Z | 2024-11-21T14:18:53.851Z |
5563379 | 5563379 | 20241120012346_aBu72 | UK002L | 2024-11-21T14:16:01.608Z | 2024-11-21T14:18:53.845Z |
5563369 | 5563369 | 20241120012200_fKrR3 | UK002L | 2024-11-21T14:16:00.099Z | 2024-11-21T14:18:53.842Z |
5563206 | 5563206 | 20241120010500_639EG | UK002L | 2024-11-21T14:15:40.430Z | 2024-11-21T14:18:53.808Z |
5563129 | 5563129 | 20241120005526_CAZr3 | UK002L | 2024-11-21T14:15:37.681Z | 2024-11-21T14:18:53.794Z |
5563012 | 5563012 | 20241120004319_Kq6vH | UK002L | 2024-11-21T14:15:31.932Z | 2024-11-21T14:18:53.776Z |
5562996 | 5562996 | 20241120003918_6oeFp | UK002L | 2024-11-21T14:15:31.395Z | 2024-11-21T14:18:53.774Z |
5562287 | 5562287 | 20241119231956_wMUFy | UK002L | 2024-11-21T14:14:40.461Z | 2024-11-21T14:18:53.662Z |
5561254 | 5561254 | 20241119192208_zGINx | UK002L | 2024-11-21T14:12:50.249Z | 2024-11-21T14:18:53.450Z |
5558564 | 5558564 | 20241120063658_AlWB6 | UK002L | 2024-11-21T14:03:42.017Z | 2024-11-21T14:03:42.017Z |
5558549 | 5558549 | 20241120062814_tB1y9 | UK002L | 2024-11-21T14:03:37.516Z | 2024-11-21T14:03:37.516Z |
5558480 | 5558480 | 20241120061246_BdTAg | UK002L | 2024-11-21T14:03:24.090Z | 2024-11-21T14:03:24.090Z |
5558462 | 5558462 | 20241120060816_P3a1z | UK002L | 2024-11-21T14:03:20.150Z | 2024-11-21T14:03:20.150Z |
5558321 | 5558321 | 20241120055620_Z41y0 | UK002L | 2024-11-21T14:03:01.887Z | 2024-11-21T14:03:01.887Z |
5558226 | 5558226 | 20241120054705_3mcvY | UK002L | 2024-11-21T14:02:48.255Z | 2024-11-21T14:02:48.255Z |
5558194 | 5558194 | 20241120054408_2muyW | UK002L | 2024-11-21T14:02:41.588Z | 2024-11-21T14:02:41.588Z |
5558187 | 5558187 | 20241120054250_KVjLt | UK002L | 2024-11-21T14:02:40.472Z | 2024-11-21T14:02:40.472Z |
5557849 | 5557849 | 20241120051833_h72xo | UK002L | 2024-11-21T14:01:56.466Z | 2024-11-21T14:01:56.466Z |
5557281 | 5557281 | 20241120043343_2dc4O | UK002L | 2024-11-21T14:00:22.536Z | 2024-11-21T14:00:22.536Z |
5557173 | 5557173 | 20241119041940_wF07Q | UK002L | 2024-11-20T14:12:24.916Z | 2024-11-21T14:20:48.847Z |
5554120 | 5554120 | 20241119061809_gJrgp | UK002L | 2024-11-20T14:00:47.840Z | 2024-11-21T14:18:52.982Z |
5554061 | 5554061 | 20241119055842_ECL0m | UK002L | 2024-11-20T14:00:37.215Z | 2024-11-21T14:18:52.968Z |
5549468 | 5549468 | 20241117045952_lX8WH | UK002L | 2024-11-18T14:11:39.658Z | 2024-11-21T14:23:17.756Z |
5549438 | 5549438 | 20241117045448_TNuLU | UK002L | 2024-11-18T14:11:36.731Z | 2024-11-21T14:23:17.443Z |
5549425 | 5549425 | 20241117045006_7KFhI | UK002L | 2024-11-18T14:11:35.474Z | 2024-11-21T14:23:17.176Z |
5549307 | 5549307 | 20241117041744_2FD6C | UK002L | 2024-11-18T14:11:26.412Z | 2024-11-21T14:23:15.454Z |
5549200 | 5549200 | 20241117034639_S9IsN | UK002L | 2024-11-18T14:11:16.030Z | 2024-11-21T14:23:13.040Z |
5549073 | 5549073 | 20241117025824_tKKCn | UK002L | 2024-11-18T14:10:49.500Z | 2024-11-21T14:23:09.765Z |
5549059 | 5549059 | 20241117025551_fNvT8 | UK002L | 2024-11-18T14:10:48.073Z | 2024-11-21T14:23:09.690Z |
5549008 | 5549008 | 20241117024142_0xcbT | UK002L | 2024-11-18T14:10:38.243Z | 2024-11-21T14:23:08.199Z |
5548943 | 5548943 | 20241117022535_FjB69 | UK002L | 2024-11-18T14:10:31.488Z | 2024-11-21T14:23:06.861Z |
5548907 | 5548907 | 20241117021242_hFDo7 | UK002L | 2024-11-18T14:10:25.323Z | 2024-11-21T14:23:05.911Z |
5548869 | 5548869 | 20241117020338_RHtyK | UK002L | 2024-11-18T14:10:21.816Z | 2024-11-21T14:23:05.272Z |
5548822 | 5548822 | 20241117015128_y9BBm | UK002L | 2024-11-18T14:10:17.346Z | 2024-11-21T14:23:04.439Z |
5548752 | 5548752 | 20241117013136_pfu7d | UK002L | 2024-11-18T14:10:09.976Z | 2024-11-21T14:23:03.166Z |
5548672 | 5548672 | 20241117010236_P6SI5 | UK002L | 2024-11-18T14:09:49.352Z | 2024-11-21T14:23:01.800Z |
5548571 | 5548571 | 20241117002448_n9kSu | UK002L | 2024-11-18T14:09:30.854Z | 2024-11-21T14:22:59.481Z |
5548548 | 5548548 | 20241117001626_s5CBs | UK002L | 2024-11-18T14:09:26.770Z | 2024-11-21T14:22:58.674Z |
5548445 | 5548445 | 20241116233720_997Uz | UK002L | 2024-11-18T14:09:14.812Z | 2024-11-21T14:22:56.638Z |
5548276 | 5548276 | 20241116220336_neA11 | UK002L | 2024-11-18T14:08:38.458Z | 2024-11-21T14:22:52.907Z |
5548250 | 5548250 | 20241116215257_YKH7M | UK002L | 2024-11-18T14:08:33.791Z | 2024-11-21T14:22:51.677Z |
5548144 | 5548144 | 20241116201806_SojBK | UK002L | 2024-11-18T14:08:19.905Z | 2024-11-21T14:22:49.136Z |
5545576 | 5545576 | 20241117052745_nduXM | UK002L | 2024-11-18T14:00:20.757Z | 2024-11-21T14:20:54.282Z |
5545545 | 5545545 | 20241117051917_f0KD7 | UK002L | 2024-11-18T14:00:14.768Z | 2024-11-21T14:20:53.614Z |
5545199 | 5545199 | 20241116023108_kJYn6 | UK002L | 2024-11-17T14:04:05.619Z | 2024-11-21T14:23:44.673Z |
5545183 | 5545183 | 20241116021025_zV2AC | UK002L | 2024-11-17T14:04:00.728Z | 2024-11-21T14:23:44.469Z |
5543034 | 5543034 | 20241114181932_c39ZV | UK002L | 2024-11-16T14:05:23.948Z | 2024-11-21T14:24:21.749Z |
5543003 | 5543003 | 20241114174942_MqtRZ | UK002L | 2024-11-16T14:05:15.053Z | 2024-11-21T14:24:21.119Z |
5542991 | 5542991 | 20241114173720_y7oOA | UK002L | 2024-11-16T14:05:13.878Z | 2024-11-21T14:24:21.018Z |
5541883 | 5541883 | 20241114050314_4RgFC | UK002L | 2024-11-15T14:08:37.319Z | 2024-11-21T14:25:20.198Z |
5541774 | 5541774 | 20241114042744_Usf6z | UK002L | 2024-11-15T14:08:26.365Z | 2024-11-21T14:25:18.679Z |
5541762 | 5541762 | 20241114042223_LIaZw | UK002L | 2024-11-15T14:08:23.218Z | 2024-11-21T14:25:18.488Z |
5541733 | 5541733 | 20241114041503_ECgOC | UK002L | 2024-11-15T14:08:18.110Z | 2024-11-21T14:25:18.284Z |
5541704 | 5541704 | 20241114035926_YraoG | UK002L | 2024-11-15T14:08:12.993Z | 2024-11-21T14:25:18.196Z |
5541519 | 5541519 | 20241114022251_B4gw4 | UK002L | 2024-11-15T14:07:46.831Z | 2024-11-21T14:25:16.677Z |
5541506 | 5541506 | 20241114021502_T985U | UK002L | 2024-11-15T14:07:46.070Z | 2024-11-21T14:25:16.636Z |
5541413 | 5541413 | 20241114014050_HB9a9 | UK002L | 2024-11-15T14:07:35.757Z | 2024-11-21T14:25:15.556Z |
5541351 | 5541351 | 20241114005003_uj3jT | UK002L | 2024-11-15T14:07:30.083Z | 2024-11-21T14:25:14.692Z |
5539275 | 5539275 | 20241114060432_fJET1 | UK002L | 2024-11-15T14:00:33.891Z | 2024-11-21T14:23:53.553Z |
5539250 | 5539250 | 20241114055925_En9tj | UK002L | 2024-11-15T14:00:29.062Z | 2024-11-21T14:23:52.754Z |
5539243 | 5539243 | 20241114055734_tzwGl | UK002L | 2024-11-15T14:00:28.107Z | 2024-11-21T14:23:52.597Z |
5539208 | 5539208 | 20241114054932_2qkwS | UK002L | 2024-11-15T14:00:22.298Z | 2024-11-21T14:23:51.194Z |
5539143 | 5539143 | 20241114054010_cCg61 | UK002L | 2024-11-15T14:00:11.909Z | 2024-11-21T14:23:49.693Z |
5538958 | 5538958 | 20241113052452_x2Kl8 | UK002L | 2024-11-14T14:14:05.497Z | 2024-11-21T14:26:30.483Z |
5537704 | 5537704 | 20241113001416_5t3VT | UK002L | 2024-11-14T14:12:25.575Z | 2024-11-21T14:26:15.401Z |
5537517 | 5537517 | 20241112232932_aZce4 | UK002L | 2024-11-14T14:12:02.505Z | 2024-11-21T14:26:13.995Z |
5531306 | 5531306 | 20241112033135_BdMo9 | UK002L | 2024-11-13T14:15:33.988Z | 2024-11-20T14:26:10.191Z |
5531220 | 5531220 | 20241112032323_Dlabd | UK002L | 2024-11-13T14:15:26.063Z | 2024-11-20T14:26:08.604Z |
5530237 | 5530237 | 20241112020146_L4M70 | UK002L | 2024-11-13T14:14:04.217Z | 2024-11-20T14:25:55.920Z |
5529925 | 5529925 | 20241112012410_Dn77i | UK002L | 2024-11-13T14:13:24.034Z | 2024-11-20T14:25:51.069Z |
5529920 | 5529920 | 20241112012241_runMN | UK002L | 2024-11-13T14:13:23.430Z | 2024-11-20T14:25:51.014Z |
5529871 | 5529871 | 20241112011514_GK6a3 | UK002L | 2024-11-13T14:13:17.338Z | 2024-11-20T14:25:50.148Z |
5529709 | 5529709 | 20241112005805_rO5nG | UK002L | 2024-11-13T14:13:07.444Z | 2024-11-20T14:25:47.596Z |
5529607 | 5529607 | 20241112004220_3dSz2 | UK002L | 2024-11-13T14:13:01.603Z | 2024-11-20T14:25:46.753Z |
5529467 | 5529467 | 20241112002315_agHVp | UK002L | 2024-11-13T14:12:52.879Z | 2024-11-20T14:25:45.235Z |
5529412 | 5529412 | 20241112001556_Qy2x4 | UK002L | 2024-11-13T14:12:39.159Z | 2024-11-20T14:25:44.425Z |
5529378 | 5529378 | 20241112000906_uddbk | UK002L | 2024-11-13T14:12:28.861Z | 2024-11-20T14:25:43.657Z |
5529260 | 5529260 | 20241111235511_meVTf | UK002L | 2024-11-13T14:12:16.740Z | 2024-11-20T14:25:42.278Z |
5529183 | 5529183 | 20241111234338_32xSE | UK002L | 2024-11-13T14:12:12.029Z | 2024-11-20T14:25:41.572Z |
5528326 | 5528326 | 20241111202419_4nsme | UK002L | 2024-11-13T14:10:27.536Z | 2024-11-20T14:25:28.474Z |
5527593 | 5527593 | 20241111174445_rUSWu | UK002L | 2024-11-13T14:08:43.600Z | 2024-11-20T14:25:14.570Z |
5524510 | 5524510 | 20241111042408_abap2 | UK002L | 2024-11-12T14:17:30.278Z | 2024-11-19T14:22:21.822Z |
5523777 | 5523777 | 20241111022237_HfpDU | UK002L | 2024-11-12T14:16:12.804Z | 2024-11-19T14:22:14.899Z |
5523613 | 5523613 | 20241111015552_wXxKG | UK002L | 2024-11-12T14:16:03.799Z | 2024-11-19T14:22:13.790Z |
5523447 | 5523447 | 20241111012725_45TMJ | UK002L | 2024-11-12T14:15:38.385Z | 2024-11-19T14:22:12.322Z |
5523353 | 5523353 | 20241111010955_herTZ | UK002L | 2024-11-12T14:15:25.076Z | 2024-11-19T14:22:11.418Z |
5522973 | 5522973 | 20241110232048_zzbxX | UK002L | 2024-11-12T14:14:34.979Z | 2024-11-19T14:22:09.210Z |
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);