participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,021 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 |
---|---|---|---|---|---|
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 |
5409081 | 5409081 | 20241027035918_Ss0G2 | UK009L | 2024-10-29T12:17:05.048Z | 2024-11-04T14:29:01.037Z |
5408670 | 5408670 | 20241027033536_LwT62 | UK009L | 2024-10-29T12:16:43.888Z | 2024-11-04T14:28:59.829Z |
5408530 | 5408530 | 20241027032916_HuYzR | UK009L | 2024-10-29T12:16:34.741Z | 2024-11-04T14:28:59.606Z |
5408314 | 5408314 | 20241027032209_2JJ6D | UK009L | 2024-10-29T12:16:22.104Z | 2024-11-04T14:28:59.079Z |
5408288 | 5408288 | 20241027032126_NTzP5 | UK009L | 2024-10-29T12:16:20.975Z | 2024-11-04T14:28:59.055Z |
5408219 | 5408219 | 20241027031655_u4K2R | UK009L | 2024-10-29T12:16:17.424Z | 2024-11-04T14:28:58.999Z |
5408072 | 5408072 | 20241027030532_rtsX5 | UK009L | 2024-10-29T12:16:03.739Z | 2024-11-04T14:28:58.750Z |
5407846 | 5407846 | 20241027025517_nXNAb | UK009L | 2024-10-29T12:15:48.501Z | 2024-11-04T14:28:58.242Z |
5407798 | 5407798 | 20241027025259_wtpJD | UK009L | 2024-10-29T12:15:42.036Z | 2024-11-04T14:28:58.156Z |
5407738 | 5407738 | 20241027025012_NZqUR | UK009L | 2024-10-29T12:15:36.713Z | 2024-11-04T14:28:58.089Z |
5407491 | 5407491 | 20241027023847_h52k1 | UK009L | 2024-10-29T12:15:26.761Z | 2024-11-04T14:28:57.768Z |
5407261 | 5407261 | 20241027022841_QfjO2 | UK009L | 2024-10-29T12:15:19.103Z | 2024-11-04T14:28:57.274Z |
5406541 | 5406541 | 20241027014252_swiOo | UK009L | 2024-10-29T12:14:18.548Z | 2024-11-04T14:28:55.842Z |
5406181 | 5406181 | 20241027012013_ViZe0 | UK009L | 2024-10-29T12:13:55.760Z | 2024-11-04T14:28:55.190Z |
5406132 | 5406132 | 20241027011826_AwXPw | UK009L | 2024-10-29T12:13:52.957Z | 2024-11-04T14:28:55.153Z |
5405977 | 5405977 | 20241027011126_7gWv5 | UK009L | 2024-10-29T12:13:42.790Z | 2024-11-04T14:28:54.803Z |
5405913 | 5405913 | 20241027010720_Zw4Tl | UK009L | 2024-10-29T12:13:32.374Z | 2024-11-04T14:28:54.601Z |
5405729 | 5405729 | 20241027005443_3f52Q | UK009L | 2024-10-29T12:13:10.863Z | 2024-11-04T14:28:54.119Z |
5405697 | 5405697 | 20241027005351_oqV7D | UK009L | 2024-10-29T12:13:09.984Z | 2024-11-04T14:28:53.918Z |
5405675 | 5405675 | 20241027005237_6cjxi | UK009L | 2024-10-29T12:13:09.047Z | 2024-11-04T14:28:53.887Z |
5405189 | 5405189 | 20241027002104_bppXB | UK009L | 2024-10-29T12:12:40.226Z | 2024-11-04T14:28:52.773Z |
5405120 | 5405120 | 20241027001428_SrH8F | UK009L | 2024-10-29T12:12:29.796Z | 2024-11-04T14:28:52.692Z |
5404770 | 5404770 | 20241026235130_gciNi | UK009L | 2024-10-29T12:11:56.832Z | 2024-11-04T14:28:51.925Z |
5404613 | 5404613 | 20241026234047_H30uQ | UK009L | 2024-10-29T12:11:46.007Z | 2024-11-04T14:28:51.410Z |
5404108 | 5404108 | 20241026225817_hOpOJ | UK009L | 2024-10-29T12:10:54.032Z | 2024-11-04T14:28:50.338Z |
5403952 | 5403952 | 20241026224815_POq5j | UK009L | 2024-10-29T12:10:36.195Z | 2024-11-04T14:28:50.071Z |
5403609 | 5403609 | 20241026221548_wu8lY | UK009L | 2024-10-29T12:10:01.829Z | 2024-11-04T14:28:49.325Z |
5402463 | 5402463 | 20241026193937_lb3Oc | UK009L | 2024-10-29T12:07:21.064Z | 2024-11-04T14:28:44.682Z |
5402380 | 5402380 | 20241026192444_MS5ox | UK009L | 2024-10-29T12:07:07.045Z | 2024-11-04T14:28:44.163Z |
5402355 | 5402355 | 20241026192204_DqKGZ | UK009L | 2024-10-29T12:07:04.266Z | 2024-11-04T14:28:43.945Z |
5402015 | 5402015 | 20241026182437_Npo1r | UK009L | 2024-10-29T12:06:04.078Z | 2024-11-04T14:28:41.575Z |
5395688 | 5395688 | 20241025230436_RabU3 | UK009L | 2024-10-28T12:16:39.604Z | 2024-11-03T14:27:26.422Z |
5385396 | 5385396 | 20241024223618_2Fmt2 | UK009L | 2024-10-27T12:18:50.324Z | 2024-11-02T12:28:29.705Z |
5383338 | 5383338 | 20241024180956_G1gOy | UK009L | 2024-10-27T12:15:16.222Z | 2024-11-02T12:28:24.959Z |
5355453 | 5355453 | 20241023034110_QDCpV | UK009L | 2024-10-24T12:21:21.291Z | 2024-10-31T12:30:07.698Z |
5353795 | 5353795 | 20241023014902_FexPK | UK009L | 2024-10-24T12:19:56.780Z | 2024-10-31T12:30:04.834Z |
5349125 | 5349125 | 20241022192710_PksZt | UK009L | 2024-10-24T12:13:11.545Z | 2024-10-31T12:29:54.607Z |
5349104 | 5349104 | 20241022192559_Szt4z | UK009L | 2024-10-24T12:13:10.598Z | 2024-10-31T12:29:54.589Z |
5349048 | 5349048 | 20241022192252_5bwNr | UK009L | 2024-10-24T12:13:01.228Z | 2024-10-31T12:29:54.519Z |
5334136 | 5334136 | 20241021020008_2e2J4 | UK009L | 2024-10-22T12:16:22.291Z | 2024-10-29T12:26:34.836Z |
5334013 | 5334013 | 20241021015040_2aX4A | UK009L | 2024-10-22T12:16:16.612Z | 2024-10-29T12:26:34.764Z |
5333807 | 5333807 | 20241021012724_wailF | UK009L | 2024-10-22T12:16:07.698Z | 2024-10-29T12:26:34.627Z |
5333593 | 5333593 | 20241021005808_yCjnB | UK009L | 2024-10-22T12:15:37.089Z | 2024-10-29T12:26:34.432Z |
5333377 | 5333377 | 20241021002601_8lurH | UK009L | 2024-10-22T12:15:15.950Z | 2024-10-29T12:26:34.310Z |
5333344 | 5333344 | 20241021001820_38Dtm | UK009L | 2024-10-22T12:15:13.164Z | 2024-10-29T12:26:34.295Z |
5321559 | 5321559 | 20241018051137_t9Mp1 | UK009L | 2024-10-19T12:07:48.463Z | 2024-10-26T12:27:56.968Z |
5321544 | 5321544 | 20241018051001_Bph0Y | UK009L | 2024-10-19T12:07:47.670Z | 2024-10-26T12:27:56.964Z |
5321428 | 5321428 | 20241018045032_K8LRg | UK009L | 2024-10-19T12:07:26.483Z | 2024-10-26T12:27:56.805Z |
5321304 | 5321304 | 20241018042710_RMtEn | UK009L | 2024-10-19T12:07:10.177Z | 2024-10-26T12:27:56.454Z |
5320141 | 5320141 | 20241018000658_QKeW9 | UK009L | 2024-10-19T12:04:42.912Z | 2024-10-26T12:27:54.085Z |
5320134 | 5320134 | 20241018000632_TZqpR | UK009L | 2024-10-19T12:04:42.241Z | 2024-10-26T12:27:54.055Z |
5303935 | 5303935 | 20241013035055_ocV2O | UK009L | 2024-10-14T12:17:38.688Z | 2024-10-21T12:24:22.104Z |
5301291 | 5301291 | 20241012230249_3KBfW | UK009L | 2024-10-14T12:15:14.830Z | 2024-10-21T12:23:57.322Z |
5301271 | 5301271 | 20241012230056_pg6K2 | UK009L | 2024-10-14T12:15:12.616Z | 2024-10-21T12:23:57.207Z |
5300938 | 5300938 | 20241012221146_9tW2E | UK009L | 2024-10-14T12:14:38.191Z | 2024-10-21T12:23:54.056Z |
5300723 | 5300723 | 20241012213205_l6oEE | UK009L | 2024-10-14T12:14:24.584Z | 2024-10-21T12:23:52.062Z |
5300660 | 5300660 | 20241012211540_zIf52 | UK009L | 2024-10-14T12:14:20.991Z | 2024-10-21T12:23:51.403Z |
5300561 | 5300561 | 20241012205316_YNWZr | UK009L | 2024-10-14T12:14:15.501Z | 2024-10-21T12:23:49.902Z |
5300467 | 5300467 | 20241012204106_GlXsL | UK009L | 2024-10-14T12:14:07.434Z | 2024-10-21T12:23:49.272Z |
5300460 | 5300460 | 20241012204106_YvF5V | UK009L | 2024-10-14T12:14:06.868Z | 2024-10-21T12:23:49.257Z |
5300434 | 5300434 | 20241012203924_YaHR6 | UK009L | 2024-10-14T12:14:04.573Z | 2024-10-21T12:23:49.077Z |
5299988 | 5299988 | 20241012195323_n0LwF | UK009L | 2024-10-14T12:13:22.484Z | 2024-10-21T12:23:45.442Z |
5299642 | 5299642 | 20241012191818_CNHB2 | UK009L | 2024-10-14T12:12:46.690Z | 2024-10-21T12:23:42.596Z |
5299556 | 5299556 | 20241012190541_pjGP0 | UK009L | 2024-10-14T12:12:30.382Z | 2024-10-21T12:23:41.569Z |
5299431 | 5299431 | 20241012184808_bPAG6 | UK009L | 2024-10-14T12:12:15.812Z | 2024-10-21T12:23:38.900Z |
5299408 | 5299408 | 20241012184516_ojbk2 | UK009L | 2024-10-14T12:12:14.789Z | 2024-10-21T12:23:38.646Z |
5299363 | 5299363 | 20241012183737_Fxwad | UK009L | 2024-10-14T12:12:12.297Z | 2024-10-21T12:23:37.835Z |
5294917 | 5294917 | 20241013050709_7uQDd | UK009L | 2024-10-14T12:00:37.293Z | 2024-10-22T12:24:06.601Z |
5294706 | 5294706 | 20241013044030_sSO9P | UK009L | 2024-10-14T12:00:10.892Z | 2024-10-22T12:24:04.656Z |
5281686 | 5281686 | 20241010191428_uJeiR | UK009L | 2024-10-12T12:14:31.814Z | 2024-10-19T12:27:35.870Z |
5281515 | 5281515 | 20241010184351_LUmGw | UK009L | 2024-10-12T12:14:16.058Z | 2024-10-19T12:27:34.032Z |
5263534 | 5263534 | 20241009045213_UHPSl | UK009L | 2024-10-10T12:01:14.733Z | 2024-10-18T12:21:35.291Z |
5263322 | 5263322 | 20241009040912_cRbRb | UK009L | 2024-10-10T12:00:32.335Z | 2024-10-18T12:21:32.369Z |
5263017 | 5263017 | 20241008025654_7pPQb | UK009L | 2024-10-09T12:16:35.789Z | 2024-10-16T12:21:21.181Z |
5262651 | 5262651 | 20241008020341_Mqz5Z | UK009L | 2024-10-09T12:16:04.093Z | 2024-10-16T12:21:19.557Z |
5262646 | 5262646 | 20241008020208_f0ET6 | UK009L | 2024-10-09T12:16:02.518Z | 2024-10-16T12:21:19.434Z |
5262639 | 5262639 | 20241008020146_rGjJ5 | UK009L | 2024-10-09T12:16:02.363Z | 2024-10-16T12:21:19.372Z |
5262614 | 5262614 | 20241008015824_8v8CM | UK009L | 2024-10-09T12:16:00.296Z | 2024-10-16T12:21:19.318Z |
5262346 | 5262346 | 20241008010904_8WmHD | UK009L | 2024-10-09T12:15:36.115Z | 2024-10-16T12:21:18.323Z |
5262233 | 5262233 | 20241008004214_vaOOM | UK009L | 2024-10-09T12:15:24.705Z | 2024-10-16T12:21:17.931Z |
5227920 | 5227920 | 20241004015558_pNhkt | UK009L | 2024-10-05T12:21:42.374Z | 2024-10-12T12:25:13.202Z |
5227885 | 5227885 | 20241004015301_VkNNj | UK009L | 2024-10-05T12:21:41.746Z | 2024-10-12T12:25:13.131Z |
5227880 | 5227880 | 20241004015226_OvOx5 | UK009L | 2024-10-05T12:21:41.679Z | 2024-10-12T12:25:13.127Z |
5227687 | 5227687 | 20241004013718_Z5zrU | UK009L | 2024-10-05T12:21:37.291Z | 2024-10-12T12:25:12.912Z |
5227464 | 5227464 | 20241004012539_bQkiv | UK009L | 2024-10-05T12:21:32.119Z | 2024-10-12T12:25:12.771Z |
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);