participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,316 rows where station_code = "UK003U" 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 |
---|---|---|---|---|---|
5133908 | 5133908 | 20240916041721_E4s3T | UK003U | 2024-09-19T12:17:12.837Z | 2024-09-19T12:17:12.837Z |
5133747 | 5133747 | 20240916040217_ygZwe | UK003U | 2024-09-19T12:17:07.115Z | 2024-09-19T12:17:07.115Z |
5133605 | 5133605 | 20240916034705_PIoWD | UK003U | 2024-09-19T12:17:03.786Z | 2024-09-19T12:17:03.786Z |
5133591 | 5133591 | 20240916034347_yD1uN | UK003U | 2024-09-19T12:17:02.662Z | 2024-09-19T12:17:02.662Z |
5133475 | 5133475 | 20240916033216_eymgK | UK003U | 2024-09-19T12:16:57.670Z | 2024-09-19T12:16:57.670Z |
5133363 | 5133363 | 20240916032738_ALLtX | UK003U | 2024-09-19T12:16:55.567Z | 2024-09-19T12:16:55.567Z |
5133312 | 5133312 | 20240916032117_7nvEr | UK003U | 2024-09-19T12:16:54.232Z | 2024-09-19T12:16:54.232Z |
5133244 | 5133244 | 20240916031230_utz8P | UK003U | 2024-09-19T12:16:51.182Z | 2024-09-19T12:16:51.182Z |
5133228 | 5133228 | 20240916030938_RGwCF | UK003U | 2024-09-19T12:16:50.451Z | 2024-09-19T12:16:50.451Z |
5133074 | 5133074 | 20240916025037_AK9tO | UK003U | 2024-09-19T12:16:43.532Z | 2024-09-19T12:16:43.532Z |
5132911 | 5132911 | 20240916022850_E6Oav | UK003U | 2024-09-19T12:16:35.910Z | 2024-09-19T12:16:35.910Z |
5132747 | 5132747 | 20240916020446_ly8Q6 | UK003U | 2024-09-19T12:16:30.753Z | 2024-09-19T12:16:30.753Z |
5132631 | 5132631 | 20240916014845_I49PP | UK003U | 2024-09-19T12:16:23.744Z | 2024-09-19T12:16:23.744Z |
5132510 | 5132510 | 20240916012313_h5psZ | UK003U | 2024-09-19T12:16:16.337Z | 2024-09-19T12:16:16.337Z |
5132013 | 5132013 | 20240915224843_JvzYU | UK003U | 2024-09-19T12:15:43.933Z | 2024-09-19T12:15:43.933Z |
5131928 | 5131928 | 20240915221745_JvuUl | UK003U | 2024-09-19T12:15:34.380Z | 2024-09-19T12:15:34.380Z |
5131448 | 5131448 | 20240915195630_lqQuV | UK003U | 2024-09-19T12:15:04.133Z | 2024-09-19T12:15:04.133Z |
5129705 | 5129705 | 20240917042425_VfQlK | UK003U | 2024-09-19T12:12:02.173Z | 2024-09-19T12:12:02.173Z |
5129642 | 5129642 | 20240917041634_t8e2f | UK003U | 2024-09-19T12:11:57.449Z | 2024-09-19T12:11:57.449Z |
5129471 | 5129471 | 20240917035950_aH681 | UK003U | 2024-09-19T12:11:41.322Z | 2024-09-19T12:11:41.322Z |
5129225 | 5129225 | 20240917033849_JFQoF | UK003U | 2024-09-19T12:11:23.653Z | 2024-09-19T12:11:23.653Z |
5129071 | 5129071 | 20240917031426_mei9A | UK003U | 2024-09-19T12:11:13.514Z | 2024-09-19T12:11:13.514Z |
5128899 | 5128899 | 20240917025239_9XJjF | UK003U | 2024-09-19T12:11:05.973Z | 2024-09-19T12:11:05.973Z |
5128776 | 5128776 | 20240917023459_iFqY0 | UK003U | 2024-09-19T12:11:01.267Z | 2024-09-19T12:11:01.267Z |
5128356 | 5128356 | 20240917013113_7lp2l | UK003U | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128293 | 5128293 | 20240917012201_PHVbY | UK003U | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128183 | 5128183 | 20240917010457_029vC | UK003U | 2024-09-19T12:10:19.784Z | 2024-09-19T12:10:19.784Z |
5127680 | 5127680 | 20240916225232_XdM57 | UK003U | 2024-09-19T12:09:31.439Z | 2024-09-19T12:09:31.439Z |
5127303 | 5127303 | 20240916212130_LoVlA | UK003U | 2024-09-19T12:08:49.488Z | 2024-09-19T12:08:49.488Z |
5127124 | 5127124 | 20240916202939_n3MFH | UK003U | 2024-09-19T12:08:16.253Z | 2024-09-19T12:08:16.253Z |
5126956 | 5126956 | 20240916200134_DfSMC | UK003U | 2024-09-19T12:07:48.716Z | 2024-09-19T12:07:48.716Z |
5124834 | 5124834 | 20240917221520_RcOc1 | UK003U | 2024-09-19T12:01:39.490Z | 2024-09-19T12:06:41.941Z |
5124755 | 5124755 | 20240917215748_Yi0FR | UK003U | 2024-09-19T12:01:32.616Z | 2024-09-19T12:06:41.932Z |
5124623 | 5124623 | 20240917213921_D2aqM | UK003U | 2024-09-19T12:01:14.480Z | 2024-09-19T12:06:41.919Z |
5124520 | 5124520 | 20240917205551_GBozT | UK003U | 2024-09-19T12:01:05.529Z | 2024-09-19T12:06:41.907Z |
5121993 | 5121993 | 20240914042433_zg0kx | UK003U | 2024-09-18T12:11:03.928Z | 2024-09-19T12:20:02.573Z |
5121622 | 5121622 | 20240914041042_HtKAC | UK003U | 2024-09-18T12:10:58.922Z | 2024-09-19T12:20:02.186Z |
5121610 | 5121610 | 20240914041027_ZjFMf | UK003U | 2024-09-18T12:10:58.865Z | 2024-09-19T12:20:02.185Z |
5120901 | 5120901 | 20240914034045_yYbUJ | UK003U | 2024-09-18T12:10:48.587Z | 2024-09-19T12:20:01.026Z |
5120620 | 5120620 | 20240914033018_Ulnqj | UK003U | 2024-09-18T12:10:43.873Z | 2024-09-19T12:20:00.633Z |
5120431 | 5120431 | 20240914032021_0w0mb | UK003U | 2024-09-18T12:10:39.800Z | 2024-09-19T12:20:00.207Z |
5120031 | 5120031 | 20240914025740_w5sTV | UK003U | 2024-09-18T12:10:31.118Z | 2024-09-19T12:19:59.306Z |
5119803 | 5119803 | 20240914025012_cKCvm | UK003U | 2024-09-18T12:10:27.213Z | 2024-09-19T12:19:58.959Z |
5119792 | 5119792 | 20240914025011_1QKB8 | UK003U | 2024-09-18T12:10:27.160Z | 2024-09-19T12:19:58.956Z |
5119768 | 5119768 | 20240914024845_eXMdp | UK003U | 2024-09-18T12:10:26.757Z | 2024-09-19T12:19:58.938Z |
5119679 | 5119679 | 20240914024404_FwclT | UK003U | 2024-09-18T12:10:24.054Z | 2024-09-19T12:19:58.732Z |
5116616 | 5116616 | 20240915033346_gv04B | UK003U | 2024-09-18T12:07:12.505Z | 2024-09-19T12:19:11.695Z |
5116271 | 5116271 | 20240915031959_WrKJe | UK003U | 2024-09-18T12:06:54.173Z | 2024-09-19T12:19:10.237Z |
5116102 | 5116102 | 20240915030837_gGs9x | UK003U | 2024-09-18T12:06:40.024Z | 2024-09-19T12:19:08.726Z |
5115987 | 5115987 | 20240915030242_kxnSo | UK003U | 2024-09-18T12:06:33.544Z | 2024-09-19T12:19:08.090Z |
5115539 | 5115539 | 20240915024428_CUS2m | UK003U | 2024-09-18T12:06:17.728Z | 2024-09-19T12:19:05.352Z |
5115436 | 5115436 | 20240915023811_ooyfj | UK003U | 2024-09-18T12:06:14.230Z | 2024-09-19T12:19:04.745Z |
5115258 | 5115258 | 20240915022936_s2kn1 | UK003U | 2024-09-18T12:06:08.278Z | 2024-09-19T12:19:03.434Z |
5113688 | 5113688 | 20240915010528_EGYaN | UK003U | 2024-09-18T12:04:40.025Z | 2024-09-19T12:18:51.281Z |
5113476 | 5113476 | 20240915005215_qlXTD | UK003U | 2024-09-18T12:04:22.737Z | 2024-09-19T12:18:49.587Z |
5113415 | 5113415 | 20240915004805_b42ud | UK003U | 2024-09-18T12:04:16.007Z | 2024-09-19T12:18:49.004Z |
5112371 | 5112371 | 20240914230622_sluI3 | UK003U | 2024-09-18T12:03:01.687Z | 2024-09-19T12:18:40.750Z |
5112299 | 5112299 | 20240914225223_Pdi0R | UK003U | 2024-09-18T12:02:58.951Z | 2024-09-19T12:18:40.427Z |
5112116 | 5112116 | 20240914221653_IlpIA | UK003U | 2024-09-18T12:02:48.815Z | 2024-09-19T12:18:38.503Z |
5112062 | 5112062 | 20240914220647_F1I22 | UK003U | 2024-09-18T12:02:45.252Z | 2024-09-19T12:18:37.782Z |
5107937 | 5107937 | 20240913041517_xTvtL | UK003U | 2024-09-17T12:13:26.077Z | 2024-09-19T12:20:47.638Z |
5107702 | 5107702 | 20240913040843_C1k02 | UK003U | 2024-09-17T12:13:22.109Z | 2024-09-19T12:20:47.477Z |
5107693 | 5107693 | 20240913040821_D5tXm | UK003U | 2024-09-17T12:13:21.635Z | 2024-09-19T12:20:47.461Z |
5107636 | 5107636 | 20240913040635_v4Zh3 | UK003U | 2024-09-17T12:13:20.210Z | 2024-09-19T12:20:47.387Z |
5107503 | 5107503 | 20240913035831_fqGqQ | UK003U | 2024-09-17T12:13:16.408Z | 2024-09-19T12:20:47.195Z |
5107465 | 5107465 | 20240913035738_DTVj0 | UK003U | 2024-09-17T12:13:15.823Z | 2024-09-19T12:20:47.166Z |
5107335 | 5107335 | 20240913035258_hNvZE | UK003U | 2024-09-17T12:13:13.458Z | 2024-09-19T12:20:47.003Z |
5107138 | 5107138 | 20240913034535_Nfjnq | UK003U | 2024-09-17T12:13:09.977Z | 2024-09-19T12:20:46.862Z |
5107042 | 5107042 | 20240913034223_r2lZE | UK003U | 2024-09-17T12:13:08.371Z | 2024-09-19T12:20:46.793Z |
5106869 | 5106869 | 20240913033731_OnzFn | UK003U | 2024-09-17T12:13:03.430Z | 2024-09-19T12:20:46.502Z |
5106331 | 5106331 | 20240913031943_2W008 | UK003U | 2024-09-17T12:12:50.341Z | 2024-09-19T12:20:45.912Z |
5106099 | 5106099 | 20240913031118_iWbfn | UK003U | 2024-09-17T12:12:42.289Z | 2024-09-19T12:20:45.494Z |
5105651 | 5105651 | 20240913025422_EJDL8 | UK003U | 2024-09-17T12:12:24.660Z | 2024-09-19T12:20:44.774Z |
5105604 | 5105604 | 20240913025303_QHYDa | UK003U | 2024-09-17T12:12:23.394Z | 2024-09-19T12:20:44.720Z |
5105527 | 5105527 | 20240913025045_RQ9P7 | UK003U | 2024-09-17T12:12:20.511Z | 2024-09-19T12:20:44.646Z |
5105148 | 5105148 | 20240913023245_ZwogZ | UK003U | 2024-09-17T12:11:59.119Z | 2024-09-19T12:20:44.000Z |
5105077 | 5105077 | 20240913022921_1BD9X | UK003U | 2024-09-17T12:11:52.740Z | 2024-09-19T12:20:43.466Z |
5105068 | 5105068 | 20240913022912_8OVX2 | UK003U | 2024-09-17T12:11:52.624Z | 2024-09-19T12:20:43.461Z |
5104810 | 5104810 | 20240913022148_1xM2P | UK003U | 2024-09-17T12:11:45.169Z | 2024-09-19T12:20:42.918Z |
5104398 | 5104398 | 20240913020713_qcrAj | UK003U | 2024-09-17T12:11:34.557Z | 2024-09-19T12:20:41.444Z |
5104339 | 5104339 | 20240913020545_oMvux | UK003U | 2024-09-17T12:11:33.793Z | 2024-09-19T12:20:41.419Z |
5104141 | 5104141 | 20240913015511_PGrjF | UK003U | 2024-09-17T12:11:27.025Z | 2024-09-19T12:20:41.135Z |
5104000 | 5104000 | 20240913014710_Rac2v | UK003U | 2024-09-17T12:11:21.840Z | 2024-09-19T12:20:40.824Z |
5103950 | 5103950 | 20240913014540_yI5mU | UK003U | 2024-09-17T12:11:20.413Z | 2024-09-19T12:20:40.686Z |
5103756 | 5103756 | 20240913013928_yELQC | UK003U | 2024-09-17T12:11:10.032Z | 2024-09-19T12:20:40.456Z |
5103622 | 5103622 | 20240913013439_UNbp7 | UK003U | 2024-09-17T12:11:06.422Z | 2024-09-19T12:20:40.385Z |
5099803 | 5099803 | 20240913220625_lZj2O | UK003U | 2024-09-17T12:03:35.758Z | 2024-09-19T12:19:45.957Z |
5099621 | 5099621 | 20240913214047_6Jcmp | UK003U | 2024-09-17T12:03:15.038Z | 2024-09-19T12:19:45.497Z |
5099310 | 5099310 | 20240913205849_FR81V | UK003U | 2024-09-17T12:02:44.751Z | 2024-09-19T12:19:44.456Z |
5098262 | 5098262 | 20240913012337_vixWd | UK003U | 2024-09-16T12:17:22.124Z | 2024-09-19T12:20:39.984Z |
5098182 | 5098182 | 20240913012113_r9smX | UK003U | 2024-09-16T12:17:21.527Z | 2024-09-19T12:20:39.830Z |
5098109 | 5098109 | 20240913011746_vT9vz | UK003U | 2024-09-16T12:17:19.603Z | 2024-09-19T12:20:39.680Z |
5097920 | 5097920 | 20240913010955_pmOEy | UK003U | 2024-09-16T12:17:16.922Z | 2024-09-19T12:20:39.199Z |
5097892 | 5097892 | 20240913010822_qc0wi | UK003U | 2024-09-16T12:17:16.398Z | 2024-09-19T12:20:39.168Z |
5097541 | 5097541 | 20240913005322_QMVyB | UK003U | 2024-09-16T12:17:13.363Z | 2024-09-19T12:20:38.713Z |
5097479 | 5097479 | 20240913004801_39kzU | UK003U | 2024-09-16T12:17:12.928Z | 2024-09-19T12:20:38.651Z |
5097271 | 5097271 | 20240913003832_Ye3ds | UK003U | 2024-09-16T12:17:09.387Z | 2024-09-19T12:20:38.025Z |
5097162 | 5097162 | 20240913003423_402hv | UK003U | 2024-09-16T12:17:06.499Z | 2024-09-19T12:20:37.743Z |
5094074 | 5094074 | 20240912034711_34Voe | UK003U | 2024-09-16T12:14:33.489Z | 2024-09-19T12:21:15.872Z |
5093885 | 5093885 | 20240912034021_Z334R | UK003U | 2024-09-16T12:14:27.026Z | 2024-09-19T12:21:15.707Z |
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);