participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,106 rows where station_code = "UK009L" 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 |
---|---|---|---|---|---|
5565078 | 5565078 | 20241120035033_rvX54 | UK009L | 2024-11-21T14:18:28.545Z | 2024-11-21T14:18:54.151Z |
5565042 | 5565042 | 20241120034535_3lqSv | UK009L | 2024-11-21T14:18:23.436Z | 2024-11-21T14:18:54.144Z |
5565009 | 5565009 | 20241120034424_49SUs | UK009L | 2024-11-21T14:18:19.115Z | 2024-11-21T14:18:54.139Z |
5564963 | 5564963 | 20241120034218_74CSR | UK009L | 2024-11-21T14:18:16.542Z | 2024-11-21T14:18:54.131Z |
5564896 | 5564896 | 20241120033724_RtyB2 | UK009L | 2024-11-21T14:18:14.276Z | 2024-11-21T14:18:54.122Z |
5564823 | 5564823 | 20241120032930_uefJG | UK009L | 2024-11-21T14:18:05.782Z | 2024-11-21T14:18:54.106Z |
5564631 | 5564631 | 20241120031501_QmlVv | UK009L | 2024-11-21T14:17:54.384Z | 2024-11-21T14:18:54.074Z |
5564589 | 5564589 | 20241120031131_8wxDl | UK009L | 2024-11-21T14:17:52.061Z | 2024-11-21T14:18:54.067Z |
5564547 | 5564547 | 20241120030747_TluGP | UK009L | 2024-11-21T14:17:47.687Z | 2024-11-21T14:18:54.059Z |
5564374 | 5564374 | 20241120025050_zzCsN | UK009L | 2024-11-21T14:17:31.153Z | 2024-11-21T14:18:54.032Z |
5564345 | 5564345 | 20241120024857_wVpgf | UK009L | 2024-11-21T14:17:28.232Z | 2024-11-21T14:18:54.026Z |
5564200 | 5564200 | 20241120023755_ECt7r | UK009L | 2024-11-21T14:17:18.107Z | 2024-11-21T14:18:54.003Z |
5564102 | 5564102 | 20241120022833_wJJzG | UK009L | 2024-11-21T14:17:09.904Z | 2024-11-21T14:18:53.980Z |
5564023 | 5564023 | 20241120022444_la2qe | UK009L | 2024-11-21T14:17:05.108Z | 2024-11-21T14:18:53.966Z |
5563734 | 5563734 | 20241120015950_5OPoV | UK009L | 2024-11-21T14:16:36.883Z | 2024-11-21T14:18:53.906Z |
5563716 | 5563716 | 20241120015944_DpvME | UK009L | 2024-11-21T14:16:35.920Z | 2024-11-21T14:18:53.904Z |
5563223 | 5563223 | 20241120010723_QtyUZ | UK009L | 2024-11-21T14:15:40.929Z | 2024-11-21T14:18:53.810Z |
5563160 | 5563160 | 20241120005916_dF3r2 | UK009L | 2024-11-21T14:15:38.705Z | 2024-11-21T14:18:53.800Z |
5562959 | 5562959 | 20241120003444_63lcx | UK009L | 2024-11-21T14:15:30.142Z | 2024-11-21T14:18:53.768Z |
5562923 | 5562923 | 20241120002908_94bJo | UK009L | 2024-11-21T14:15:27.663Z | 2024-11-21T14:18:53.762Z |
5562750 | 5562750 | 20241120000736_tfowD | UK009L | 2024-11-21T14:15:19.848Z | 2024-11-21T14:18:53.732Z |
5562586 | 5562586 | 20241119235326_HFuZ8 | UK009L | 2024-11-21T14:15:11.151Z | 2024-11-21T14:18:53.706Z |
5562578 | 5562578 | 20241119235306_Nak4W | UK009L | 2024-11-21T14:15:10.815Z | 2024-11-21T14:18:53.705Z |
5562393 | 5562393 | 20241119233355_M5NSf | UK009L | 2024-11-21T14:14:46.585Z | 2024-11-21T14:18:53.677Z |
5561881 | 5561881 | 20241119222414_lQ5vc | UK009L | 2024-11-21T14:14:12.193Z | 2024-11-21T14:18:53.598Z |
5561875 | 5561875 | 20241119222412_MgUPG | UK009L | 2024-11-21T14:14:11.927Z | 2024-11-21T14:18:53.598Z |
5561872 | 5561872 | 20241119222103_rra76 | UK009L | 2024-11-21T14:14:11.668Z | 2024-11-21T14:18:53.597Z |
5561751 | 5561751 | 20241119215957_yraov | UK009L | 2024-11-21T14:13:58.250Z | 2024-11-21T14:18:53.574Z |
5561712 | 5561712 | 20241119214742_utnXH | UK009L | 2024-11-21T14:13:49.583Z | 2024-11-21T14:18:53.567Z |
5561628 | 5561628 | 20241119212148_HRRBu | UK009L | 2024-11-21T14:13:37.993Z | 2024-11-21T14:18:53.551Z |
5561532 | 5561532 | 20241119205446_txdYY | UK009L | 2024-11-21T14:13:25.336Z | 2024-11-21T14:18:53.532Z |
5558225 | 5558225 | 20241120054647_t72WH | UK009L | 2024-11-21T14:02:47.759Z | 2024-11-21T14:02:47.759Z |
5558206 | 5558206 | 20241120054529_xVqf4 | UK009L | 2024-11-21T14:02:44.019Z | 2024-11-21T14:02:44.019Z |
5558166 | 5558166 | 20241120054136_fR05W | UK009L | 2024-11-21T14:02:38.617Z | 2024-11-21T14:02:38.617Z |
5558159 | 5558159 | 20241120054122_OMuy8 | UK009L | 2024-11-21T14:02:37.574Z | 2024-11-21T14:02:37.574Z |
5557935 | 5557935 | 20241120052413_cU6Ow | UK009L | 2024-11-21T14:02:05.737Z | 2024-11-21T14:02:05.737Z |
5557453 | 5557453 | 20241120044648_7bLRm | UK009L | 2024-11-21T14:00:55.081Z | 2024-11-21T14:00:55.081Z |
5557289 | 5557289 | 20241120043404_uUNLx | UK009L | 2024-11-21T14:00:23.577Z | 2024-11-21T14:00:23.577Z |
5545081 | 5545081 | 20241115234900_Ccmjg | UK009L | 2024-11-17T14:03:45.591Z | 2024-11-21T14:23:42.725Z |
5545080 | 5545080 | 20241115233555_QOieF | UK009L | 2024-11-17T14:03:45.289Z | 2024-11-21T14:23:42.703Z |
5545074 | 5545074 | 20241115233526_imC2T | UK009L | 2024-11-17T14:03:44.912Z | 2024-11-21T14:23:42.609Z |
5545045 | 5545045 | 20241115225329_NiRVF | UK009L | 2024-11-17T14:03:41.023Z | 2024-11-21T14:23:41.859Z |
5545016 | 5545016 | 20241115221152_ToncZ | UK009L | 2024-11-17T14:03:37.117Z | 2024-11-21T14:23:41.203Z |
5544998 | 5544998 | 20241115213449_IYU3K | UK009L | 2024-11-17T14:03:34.463Z | 2024-11-21T14:23:40.740Z |
5544969 | 5544969 | 20241115203746_ieq3E | UK009L | 2024-11-17T14:03:32.706Z | 2024-11-21T14:23:40.595Z |
5543470 | 5543470 | 20241115013715_97cn7 | UK009L | 2024-11-16T14:06:26.538Z | 2024-11-21T14:24:28.655Z |
5543399 | 5543399 | 20241115010341_nHjmM | UK009L | 2024-11-16T14:06:14.173Z | 2024-11-21T14:24:27.783Z |
5543392 | 5543392 | 20241115005617_Ps2AB | UK009L | 2024-11-16T14:06:13.506Z | 2024-11-21T14:24:27.758Z |
5543357 | 5543357 | 20241115003504_qX5qM | UK009L | 2024-11-16T14:06:08.730Z | 2024-11-21T14:24:26.825Z |
5541202 | 5541202 | 20241113192930_CKX1x | UK009L | 2024-11-15T14:06:54.903Z | 2024-11-21T14:25:09.128Z |
5531303 | 5531303 | 20241112032951_vHMQr | UK009L | 2024-11-13T14:15:33.501Z | 2024-11-20T14:26:10.169Z |
5531133 | 5531133 | 20241112031654_ihgH8 | UK009L | 2024-11-13T14:15:18.104Z | 2024-11-20T14:26:08.175Z |
5530992 | 5530992 | 20241112030429_hPE2K | UK009L | 2024-11-13T14:14:58.738Z | 2024-11-20T14:26:05.815Z |
5530873 | 5530873 | 20241112025649_bhCAO | UK009L | 2024-11-13T14:14:46.563Z | 2024-11-20T14:26:04.296Z |
5530778 | 5530778 | 20241112024610_EQxZ1 | UK009L | 2024-11-13T14:14:37.417Z | 2024-11-20T14:26:03.449Z |
5530761 | 5530761 | 20241112024446_pFr11 | UK009L | 2024-11-13T14:14:34.689Z | 2024-11-20T14:26:03.010Z |
5530465 | 5530465 | 20241112022046_r4b4r | UK009L | 2024-11-13T14:14:17.298Z | 2024-11-20T14:26:00.566Z |
5530377 | 5530377 | 20241112021332_33wys | UK009L | 2024-11-13T14:14:12.631Z | 2024-11-20T14:25:58.266Z |
5530192 | 5530192 | 20241112015507_pQPgu | UK009L | 2024-11-13T14:14:01.223Z | 2024-11-20T14:25:55.381Z |
5530188 | 5530188 | 20241112015441_Xsa7U | UK009L | 2024-11-13T14:14:01.032Z | 2024-11-20T14:25:55.370Z |
5530086 | 5530086 | 20241112014216_E4mSr | UK009L | 2024-11-13T14:13:50.362Z | 2024-11-20T14:25:54.272Z |
5529712 | 5529712 | 20241112005809_OzVIe | UK009L | 2024-11-13T14:13:07.674Z | 2024-11-20T14:25:47.656Z |
5529657 | 5529657 | 20241112005045_13g4Q | UK009L | 2024-11-13T14:13:04.735Z | 2024-11-20T14:25:47.186Z |
5529309 | 5529309 | 20241112000024_TINoe | UK009L | 2024-11-13T14:12:21.120Z | 2024-11-20T14:25:42.683Z |
5529275 | 5529275 | 20241111235706_FM2mS | UK009L | 2024-11-13T14:12:18.372Z | 2024-11-20T14:25:42.510Z |
5529157 | 5529157 | 20241111233849_FWfE7 | UK009L | 2024-11-13T14:12:09.554Z | 2024-11-20T14:25:40.840Z |
5529045 | 5529045 | 20241111232240_40XSz | UK009L | 2024-11-13T14:12:00.679Z | 2024-11-20T14:25:39.240Z |
5528942 | 5528942 | 20241111231058_WIEDE | UK009L | 2024-11-13T14:11:44.910Z | 2024-11-20T14:25:37.628Z |
5528884 | 5528884 | 20241111230042_PtACV | UK009L | 2024-11-13T14:11:35.266Z | 2024-11-20T14:25:36.954Z |
5528856 | 5528856 | 20241111225418_zUXW9 | UK009L | 2024-11-13T14:11:31.717Z | 2024-11-20T14:25:36.744Z |
5528844 | 5528844 | 20241111224941_udmX2 | UK009L | 2024-11-13T14:11:29.549Z | 2024-11-20T14:25:36.679Z |
5528829 | 5528829 | 20241111224803_LGUof | UK009L | 2024-11-13T14:11:28.659Z | 2024-11-20T14:25:36.402Z |
5528808 | 5528808 | 20241111224159_suo6e | UK009L | 2024-11-13T14:11:27.233Z | 2024-11-20T14:25:36.068Z |
5528726 | 5528726 | 20241111222454_5qpIT | UK009L | 2024-11-13T14:11:20.146Z | 2024-11-20T14:25:34.297Z |
5528632 | 5528632 | 20241111220159_FeRpn | UK009L | 2024-11-13T14:11:11.865Z | 2024-11-20T14:25:33.010Z |
5528525 | 5528525 | 20241111212245_BPSHE | UK009L | 2024-11-13T14:11:03.346Z | 2024-11-20T14:25:31.852Z |
5528445 | 5528445 | 20241111205503_9AApA | UK009L | 2024-11-13T14:10:40.702Z | 2024-11-20T14:25:30.712Z |
5528383 | 5528383 | 20241111203653_Ye3aN | UK009L | 2024-11-13T14:10:33.537Z | 2024-11-20T14:25:29.112Z |
5528257 | 5528257 | 20241111200534_U3Q07 | UK009L | 2024-11-13T14:10:20.708Z | 2024-11-20T14:25:27.391Z |
5528133 | 5528133 | 20241111194203_K2Wil | UK009L | 2024-11-13T14:09:59.045Z | 2024-11-20T14:25:25.489Z |
5528023 | 5528023 | 20241111191641_3Dllc | UK009L | 2024-11-13T14:09:42.816Z | 2024-11-20T14:25:24.197Z |
5527894 | 5527894 | 20241111185440_2nKg7 | UK009L | 2024-11-13T14:09:30.913Z | 2024-11-20T14:25:22.752Z |
5527877 | 5527877 | 20241111185021_I690c | UK009L | 2024-11-13T14:09:29.964Z | 2024-11-20T14:25:22.519Z |
5527760 | 5527760 | 20241111182824_0qI6X | UK009L | 2024-11-13T14:09:03.357Z | 2024-11-20T14:25:19.848Z |
5527668 | 5527668 | 20241111180630_5dRSF | UK009L | 2024-11-13T14:08:52.585Z | 2024-11-20T14:25:17.311Z |
5439810 | 5439810 | 20241030203401_I37v3 | UK009L | 2024-11-01T12:14:31.383Z | 2024-11-08T14:23:05.836Z |
5439801 | 5439801 | 20241030203329_rxcN1 | UK009L | 2024-11-01T12:14:30.836Z | 2024-11-08T14:23:05.829Z |
5439720 | 5439720 | 20241030202208_j2rh3 | UK009L | 2024-11-01T12:14:15.402Z | 2024-11-08T14:23:05.319Z |
5439709 | 5439709 | 20241030202109_Nr1Qd | UK009L | 2024-11-01T12:14:12.959Z | 2024-11-08T14:23:04.964Z |
5439380 | 5439380 | 20241030194941_C27WM | UK009L | 2024-11-01T12:13:46.080Z | 2024-11-08T14:23:03.205Z |
5418424 | 5418424 | 20241027204346_TjYFb | UK009L | 2024-10-30T12:15:40.384Z | 2024-11-05T14:27:09.998Z |
5417655 | 5417655 | 20241027185830_mWBlS | UK009L | 2024-10-30T12:14:07.930Z | 2024-11-05T14:27:08.060Z |
5417643 | 5417643 | 20241027185641_Rvq0c | UK009L | 2024-10-30T12:14:05.978Z | 2024-11-05T14:27:07.938Z |
5410272 | 5410272 | 20241027050500_GTyik | UK009L | 2024-10-29T12:17:52.120Z | 2024-11-04T14:29:04.277Z |
5410193 | 5410193 | 20241027045924_nrQwp | UK009L | 2024-10-29T12:17:50.511Z | 2024-11-04T14:29:04.035Z |
5409985 | 5409985 | 20241027044656_y5CLp | UK009L | 2024-10-29T12:17:45.296Z | 2024-11-04T14:29:03.171Z |
5409744 | 5409744 | 20241027043331_VxE3m | UK009L | 2024-10-29T12:17:39.900Z | 2024-11-04T14:29:02.428Z |
5409460 | 5409460 | 20241027041930_hQEPn | UK009L | 2024-10-29T12:17:25.074Z | 2024-11-04T14:29:01.831Z |
5409360 | 5409360 | 20241027041237_cBjbB | UK009L | 2024-10-29T12:17:17.701Z | 2024-11-04T14:29:01.599Z |
5409299 | 5409299 | 20241027041019_PAQMx | UK009L | 2024-10-29T12:17:15.280Z | 2024-11-04T14:29:01.495Z |
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);