participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,012 rows where station_code = "UK009C" 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 |
---|---|---|---|---|---|
5134067 | 5134067 | 20240916044008_yAsSe | UK009C | 2024-09-19T12:17:17.855Z | 2024-09-19T12:17:17.855Z |
5133883 | 5133883 | 20240916041413_cwT13 | UK009C | 2024-09-19T12:17:12.026Z | 2024-09-19T12:17:12.026Z |
5133792 | 5133792 | 20240916040537_hv4M6 | UK009C | 2024-09-19T12:17:08.083Z | 2024-09-19T12:17:08.083Z |
5133756 | 5133756 | 20240916040308_1AvYm | UK009C | 2024-09-19T12:17:07.152Z | 2024-09-19T12:17:07.152Z |
5133555 | 5133555 | 20240916034009_tbzwd | UK009C | 2024-09-19T12:17:01.644Z | 2024-09-19T12:17:01.644Z |
5133470 | 5133470 | 20240916033130_5v03X | UK009C | 2024-09-19T12:16:57.404Z | 2024-09-19T12:16:57.404Z |
5133336 | 5133336 | 20240916032335_geFny | UK009C | 2024-09-19T12:16:54.445Z | 2024-09-19T12:16:54.445Z |
5133317 | 5133317 | 20240916032143_WhOs3 | UK009C | 2024-09-19T12:16:54.389Z | 2024-09-19T12:16:54.389Z |
5133277 | 5133277 | 20240916031739_7C8GB | UK009C | 2024-09-19T12:16:52.484Z | 2024-09-19T12:16:52.484Z |
5133248 | 5133248 | 20240916031230_utz8P | UK009C | 2024-09-19T12:16:51.182Z | 2024-09-19T12:16:51.182Z |
5133170 | 5133170 | 20240916030336_0Hf2T | UK009C | 2024-09-19T12:16:46.092Z | 2024-09-19T12:16:46.092Z |
5133153 | 5133153 | 20240916030238_SpvyD | UK009C | 2024-09-19T12:16:45.924Z | 2024-09-19T12:16:45.924Z |
5133018 | 5133018 | 20240916024227_DaFIN | UK009C | 2024-09-19T12:16:40.984Z | 2024-09-19T12:16:40.984Z |
5132960 | 5132960 | 20240916023523_R4lIZ | UK009C | 2024-09-19T12:16:38.923Z | 2024-09-19T12:16:38.923Z |
5132958 | 5132958 | 20240916023508_PtRVE | UK009C | 2024-09-19T12:16:38.853Z | 2024-09-19T12:16:38.853Z |
5132951 | 5132951 | 20240916023224_2jV13 | UK009C | 2024-09-19T12:16:38.493Z | 2024-09-19T12:16:38.493Z |
5132813 | 5132813 | 20240916021515_8gZYt | UK009C | 2024-09-19T12:16:33.366Z | 2024-09-19T12:16:33.366Z |
5132641 | 5132641 | 20240916014929_7Lp9y | UK009C | 2024-09-19T12:16:24.190Z | 2024-09-19T12:16:24.190Z |
5132515 | 5132515 | 20240916012407_8eWjT | UK009C | 2024-09-19T12:16:16.570Z | 2024-09-19T12:16:16.570Z |
5132474 | 5132474 | 20240916011528_gDqpw | UK009C | 2024-09-19T12:16:14.092Z | 2024-09-19T12:16:14.092Z |
5131741 | 5131741 | 20240915210020_HhUQK | UK009C | 2024-09-19T12:15:18.761Z | 2024-09-19T12:15:18.761Z |
5131443 | 5131443 | 20240915195545_SEOcv | UK009C | 2024-09-19T12:15:03.856Z | 2024-09-19T12:15:03.856Z |
5125907 | 5125907 | 20240918043235_Iu2LS | UK009C | 2024-09-19T12:04:31.760Z | 2024-09-19T12:06:42.105Z |
5125838 | 5125838 | 20240918040647_u2Yhj | UK009C | 2024-09-19T12:04:13.017Z | 2024-09-19T12:06:42.093Z |
5124830 | 5124830 | 20240917221516_T43hP | UK009C | 2024-09-19T12:01:39.114Z | 2024-09-19T12:06:41.940Z |
5124727 | 5124727 | 20240917215559_N7VCy | UK009C | 2024-09-19T12:01:25.584Z | 2024-09-19T12:06:41.929Z |
5124584 | 5124584 | 20240917212129_ihB7B | UK009C | 2024-09-19T12:01:10.517Z | 2024-09-19T12:06:41.914Z |
5124577 | 5124577 | 20240917211445_o8eGn | UK009C | 2024-09-19T12:01:09.643Z | 2024-09-19T12:06:41.913Z |
5124442 | 5124442 | 20240917202117_SRq2Q | UK009C | 2024-09-19T12:00:56.024Z | 2024-09-19T12:06:41.895Z |
5124340 | 5124340 | 20240917193536_eSk2u | UK009C | 2024-09-19T12:00:36.454Z | 2024-09-19T12:06:41.879Z |
5115301 | 5115301 | 20240915023127_M3S08 | UK009C | 2024-09-18T12:06:10.387Z | 2024-09-19T12:19:03.788Z |
5110388 | 5110388 | 20240911235129_4jDNQ | UK009C | 2024-09-17T12:16:28.636Z | 2024-09-19T12:21:09.239Z |
5107711 | 5107711 | 20240913040843_C1k02 | UK009C | 2024-09-17T12:13:22.109Z | 2024-09-19T12:20:47.477Z |
5107624 | 5107624 | 20240913040525_03EZb | UK009C | 2024-09-17T12:13:19.689Z | 2024-09-19T12:20:47.369Z |
5107618 | 5107618 | 20240913040444_l6iFC | UK009C | 2024-09-17T12:13:19.183Z | 2024-09-19T12:20:47.354Z |
5106879 | 5106879 | 20240913033731_OnzFn | UK009C | 2024-09-17T12:13:03.430Z | 2024-09-19T12:20:46.502Z |
5106681 | 5106681 | 20240913033221_VNeiw | UK009C | 2024-09-17T12:12:59.366Z | 2024-09-19T12:20:46.276Z |
5106394 | 5106394 | 20240913032338_JgxR7 | UK009C | 2024-09-17T12:12:52.845Z | 2024-09-19T12:20:46.043Z |
5105936 | 5105936 | 20240913030324_EPdV7 | UK009C | 2024-09-17T12:12:33.792Z | 2024-09-19T12:20:45.070Z |
5105875 | 5105875 | 20240913030123_MaHwe | UK009C | 2024-09-17T12:12:31.279Z | 2024-09-19T12:20:45.007Z |
5105234 | 5105234 | 20240913023839_ws9h5 | UK009C | 2024-09-17T12:12:04.986Z | 2024-09-19T12:20:44.159Z |
5105074 | 5105074 | 20240913022912_8OVX2 | UK009C | 2024-09-17T12:11:52.624Z | 2024-09-19T12:20:43.461Z |
5104965 | 5104965 | 20240913022500_v6miM | UK009C | 2024-09-17T12:11:47.657Z | 2024-09-19T12:20:43.142Z |
5104821 | 5104821 | 20240913022148_1xM2P | UK009C | 2024-09-17T12:11:45.170Z | 2024-09-19T12:20:42.918Z |
5104410 | 5104410 | 20240913020724_aCtMY | UK009C | 2024-09-17T12:11:34.712Z | 2024-09-19T12:20:41.449Z |
5104178 | 5104178 | 20240913015718_5uZh2 | UK009C | 2024-09-17T12:11:28.498Z | 2024-09-19T12:20:41.193Z |
5104153 | 5104153 | 20240913015553_CMFsl | UK009C | 2024-09-17T12:11:27.561Z | 2024-09-19T12:20:41.157Z |
5104143 | 5104143 | 20240913015511_PGrjF | UK009C | 2024-09-17T12:11:27.025Z | 2024-09-19T12:20:41.135Z |
5104121 | 5104121 | 20240913015322_T2yHo | UK009C | 2024-09-17T12:11:25.978Z | 2024-09-19T12:20:41.040Z |
5104054 | 5104054 | 20240913015011_H7FwX | UK009C | 2024-09-17T12:11:23.710Z | 2024-09-19T12:20:40.942Z |
5104004 | 5104004 | 20240913014710_Rac2v | UK009C | 2024-09-17T12:11:21.841Z | 2024-09-19T12:20:40.824Z |
5097396 | 5097396 | 20240913004503_V9g8l | UK009C | 2024-09-16T12:17:12.044Z | 2024-09-19T12:20:38.467Z |
5092301 | 5092301 | 20240912024210_4uGnz | UK009C | 2024-09-16T12:13:47.699Z | 2024-09-19T12:21:13.820Z |
5091250 | 5091250 | 20240912020329_4ElqR | UK009C | 2024-09-16T12:12:56.934Z | 2024-09-19T12:21:12.717Z |
5090033 | 5090033 | 20240912010718_oZHrf | UK009C | 2024-09-16T12:11:56.725Z | 2024-09-19T12:21:10.934Z |
5090005 | 5090005 | 20240912010611_z5v1o | UK009C | 2024-09-16T12:11:55.022Z | 2024-09-19T12:21:10.919Z |
5089923 | 5089923 | 20240912010253_rkNnV | UK009C | 2024-09-16T12:11:49.245Z | 2024-09-19T12:21:10.616Z |
5089896 | 5089896 | 20240912010133_XoceR | UK009C | 2024-09-16T12:11:48.655Z | 2024-09-19T12:21:10.608Z |
5089743 | 5089743 | 20240912005510_3Xbfw | UK009C | 2024-09-16T12:11:39.774Z | 2024-09-19T12:21:10.302Z |
5089444 | 5089444 | 20240912004208_euSb7 | UK009C | 2024-09-16T12:11:25.557Z | 2024-09-19T12:21:09.966Z |
5089121 | 5089121 | 20240912002637_8HVRz | UK009C | 2024-09-16T12:11:15.396Z | 2024-09-19T12:21:09.747Z |
5089027 | 5089027 | 20240912002040_D0CgS | UK009C | 2024-09-16T12:11:12.425Z | 2024-09-19T12:21:09.681Z |
5089017 | 5089017 | 20240912001948_wwVaC | UK009C | 2024-09-16T12:11:12.083Z | 2024-09-19T12:21:09.677Z |
5088818 | 5088818 | 20240913002803_D7kPJ | UK009C | 2024-09-16T12:08:31.666Z | 2024-09-19T12:20:37.309Z |
5088655 | 5088655 | 20240913002029_h3IXS | UK009C | 2024-09-16T12:08:18.472Z | 2024-09-19T12:20:37.109Z |
5088498 | 5088498 | 20240913001322_vZCEY | UK009C | 2024-09-16T12:08:06.077Z | 2024-09-19T12:20:36.967Z |
5087790 | 5087790 | 20240912234426_r3dPs | UK009C | 2024-09-16T12:07:27.329Z | 2024-09-19T12:20:35.674Z |
5087594 | 5087594 | 20240912233251_v8XIb | UK009C | 2024-09-16T12:07:05.518Z | 2024-09-19T12:20:35.476Z |
5087540 | 5087540 | 20240912233057_Z9CID | UK009C | 2024-09-16T12:07:03.092Z | 2024-09-19T12:20:35.283Z |
5087418 | 5087418 | 20240912232647_kEZSY | UK009C | 2024-09-16T12:06:55.583Z | 2024-09-19T12:20:34.822Z |
5087387 | 5087387 | 20240912232636_sjMe6 | UK009C | 2024-09-16T12:06:54.901Z | 2024-09-19T12:20:34.814Z |
5087260 | 5087260 | 20240912231838_8T3Yh | UK009C | 2024-09-16T12:06:49.401Z | 2024-09-19T12:20:34.498Z |
5087223 | 5087223 | 20240912231627_BIa4M | UK009C | 2024-09-16T12:06:47.584Z | 2024-09-19T12:20:34.206Z |
5087170 | 5087170 | 20240912231300_K54Hz | UK009C | 2024-09-16T12:06:44.436Z | 2024-09-19T12:20:34.098Z |
5087123 | 5087123 | 20240912230849_iiMFc | UK009C | 2024-09-16T12:06:40.099Z | 2024-09-19T12:20:34.036Z |
5086808 | 5086808 | 20240912225010_Zhm1v | UK009C | 2024-09-16T12:06:05.608Z | 2024-09-19T12:20:32.496Z |
5086765 | 5086765 | 20240912224803_EaqBn | UK009C | 2024-09-16T12:06:02.016Z | 2024-09-19T12:20:31.678Z |
5086656 | 5086656 | 20240912224453_aX94m | UK009C | 2024-09-16T12:05:56.537Z | 2024-09-19T12:20:31.487Z |
5086537 | 5086537 | 20240912223949_nIAn3 | UK009C | 2024-09-16T12:05:51.326Z | 2024-09-19T12:20:31.399Z |
5086399 | 5086399 | 20240912223222_clouS | UK009C | 2024-09-16T12:05:41.211Z | 2024-09-19T12:20:31.047Z |
5086323 | 5086323 | 20240912222835_qnhL6 | UK009C | 2024-09-16T12:05:35.020Z | 2024-09-19T12:20:30.882Z |
5086246 | 5086246 | 20240912222156_tTMnN | UK009C | 2024-09-16T12:05:25.279Z | 2024-09-19T12:20:30.700Z |
5085923 | 5085923 | 20240912215747_F0Rw8 | UK009C | 2024-09-16T12:05:02.865Z | 2024-09-19T12:20:29.793Z |
5085630 | 5085630 | 20240912213609_3Qqjd | UK009C | 2024-09-16T12:04:31.995Z | 2024-09-19T12:20:29.284Z |
5085527 | 5085527 | 20240912212453_BqznV | UK009C | 2024-09-16T12:04:21.239Z | 2024-09-19T12:20:28.987Z |
5085517 | 5085517 | 20240912212453_E49uV | UK009C | 2024-09-16T12:04:20.874Z | 2024-09-19T12:20:28.984Z |
5085473 | 5085473 | 20240912212149_PdRgM | UK009C | 2024-09-16T12:04:17.549Z | 2024-09-19T12:20:28.729Z |
5085397 | 5085397 | 20240912211848_Jqqyb | UK009C | 2024-09-16T12:04:14.083Z | 2024-09-19T12:20:28.613Z |
5085345 | 5085345 | 20240912211212_OpiRE | UK009C | 2024-09-16T12:04:07.225Z | 2024-09-19T12:20:28.487Z |
5085314 | 5085314 | 20240912210741_QGtSn | UK009C | 2024-09-16T12:03:56.884Z | 2024-09-19T12:20:28.408Z |
5085282 | 5085282 | 20240912210612_ZHC2N | UK009C | 2024-09-16T12:03:50.684Z | 2024-09-19T12:20:28.319Z |
5085214 | 5085214 | 20240912205951_l3Inw | UK009C | 2024-09-16T12:03:44.357Z | 2024-09-19T12:20:28.231Z |
5085131 | 5085131 | 20240912205117_UrcFj | UK009C | 2024-09-16T12:03:35.803Z | 2024-09-19T12:20:28.087Z |
5084805 | 5084805 | 20240912201609_TNfLu | UK009C | 2024-09-16T12:02:55.585Z | 2024-09-19T12:20:27.230Z |
5084778 | 5084778 | 20240912201434_heG3B | UK009C | 2024-09-16T12:02:54.281Z | 2024-09-19T12:20:27.223Z |
5084646 | 5084646 | 20240912200116_6hLYt | UK009C | 2024-09-16T12:02:43.537Z | 2024-09-19T12:20:26.736Z |
5080348 | 5080348 | 20240911035105_xeqiQ | UK009C | 2024-09-15T12:16:58.807Z | 2024-09-19T12:21:43.187Z |
5080262 | 5080262 | 20240911034454_QcMcC | UK009C | 2024-09-15T12:16:55.434Z | 2024-09-19T12:21:43.141Z |
5080238 | 5080238 | 20240911034323_iml67 | UK009C | 2024-09-15T12:16:54.803Z | 2024-09-19T12:21:43.135Z |
5080180 | 5080180 | 20240911034207_dhl82 | UK009C | 2024-09-15T12:16:53.389Z | 2024-09-19T12:21:43.122Z |
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);