participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,269 rows where station_code = "UK007U" 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 |
---|---|---|---|---|---|
5431627 | 5431627 | 20241029013849_t92oO | UK007U | 2024-10-31T12:20:26.838Z | 2024-11-06T14:27:24.274Z |
5429619 | 5429619 | 20241028194134_8OupK | UK007U | 2024-10-31T12:16:49.736Z | 2024-11-06T14:27:16.674Z |
5423062 | 5423062 | 20241026015012_Pkuv1 | UK007U | 2024-10-30T12:24:15.918Z | 2024-11-03T14:27:33.846Z |
5410642 | 5410642 | 20241027052531_2yEQL | UK007U | 2024-10-29T12:18:01.853Z | 2024-11-04T14:29:05.187Z |
5410537 | 5410537 | 20241027051649_kMZ98 | UK007U | 2024-10-29T12:17:57.728Z | 2024-11-04T14:29:04.736Z |
5409312 | 5409312 | 20241027041040_kPa89 | UK007U | 2024-10-29T12:17:16.192Z | 2024-11-04T14:29:01.517Z |
5409259 | 5409259 | 20241027040735_CKqZO | UK007U | 2024-10-29T12:17:14.337Z | 2024-11-04T14:29:01.440Z |
5409162 | 5409162 | 20241027040335_t2uFM | UK007U | 2024-10-29T12:17:09.339Z | 2024-11-04T14:29:01.230Z |
5408223 | 5408223 | 20241027031708_Lug15 | UK007U | 2024-10-29T12:16:17.587Z | 2024-11-04T14:28:59.008Z |
5408152 | 5408152 | 20241027031142_IB6ey | UK007U | 2024-10-29T12:16:12.462Z | 2024-11-04T14:28:58.935Z |
5408147 | 5408147 | 20241027031142_2Iczn | UK007U | 2024-10-29T12:16:12.105Z | 2024-11-04T14:28:58.920Z |
5408121 | 5408121 | 20241027031041_wPLCQ | UK007U | 2024-10-29T12:16:09.123Z | 2024-11-04T14:28:58.883Z |
5407968 | 5407968 | 20241027030048_OBkfw | UK007U | 2024-10-29T12:15:55.977Z | 2024-11-04T14:28:58.535Z |
5407964 | 5407964 | 20241027030033_2mrzP | UK007U | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407208 | 5407208 | 20241027022623_M1x4l | UK007U | 2024-10-29T12:15:16.929Z | 2024-11-04T14:28:57.239Z |
5406832 | 5406832 | 20241027020212_iXR1P | UK007U | 2024-10-29T12:14:47.863Z | 2024-11-04T14:28:56.490Z |
5406661 | 5406661 | 20241027015232_Svpm6 | UK007U | 2024-10-29T12:14:29.584Z | 2024-11-04T14:28:55.980Z |
5406123 | 5406123 | 20241027011754_A24cT | UK007U | 2024-10-29T12:13:52.832Z | 2024-11-04T14:28:55.149Z |
5405837 | 5405837 | 20241027010247_3H2ma | UK007U | 2024-10-29T12:13:21.456Z | 2024-11-04T14:28:54.421Z |
5405781 | 5405781 | 20241027005742_yi0HO | UK007U | 2024-10-29T12:13:16.503Z | 2024-11-04T14:28:54.229Z |
5405733 | 5405733 | 20241027005456_qMKxR | UK007U | 2024-10-29T12:13:10.965Z | 2024-11-04T14:28:54.123Z |
5404630 | 5404630 | 20241026234105_8I0kh | UK007U | 2024-10-29T12:11:47.007Z | 2024-11-04T14:28:51.446Z |
5404468 | 5404468 | 20241026232939_9d72X | UK007U | 2024-10-29T12:11:31.528Z | 2024-11-04T14:28:51.080Z |
5403399 | 5403399 | 20241026215123_OROH7 | UK007U | 2024-10-29T12:09:27.240Z | 2024-11-04T14:28:48.692Z |
5403313 | 5403313 | 20241026213952_kKfwS | UK007U | 2024-10-29T12:09:21.394Z | 2024-11-04T14:28:48.295Z |
5398830 | 5398830 | 20241026033159_tE9sf | UK007U | 2024-10-28T12:19:35.734Z | 2024-11-03T14:27:38.273Z |
5398702 | 5398702 | 20241026032031_zgOZc | UK007U | 2024-10-28T12:19:28.874Z | 2024-11-03T14:27:37.861Z |
5398658 | 5398658 | 20241026031527_wJf9P | UK007U | 2024-10-28T12:19:27.034Z | 2024-11-03T14:27:37.508Z |
5398594 | 5398594 | 20241026031039_vPqh5 | UK007U | 2024-10-28T12:19:23.570Z | 2024-11-03T14:27:36.886Z |
5398560 | 5398560 | 20241026030757_BGq41 | UK007U | 2024-10-28T12:19:21.872Z | 2024-11-03T14:27:36.791Z |
5398395 | 5398395 | 20241026025248_voi50 | UK007U | 2024-10-28T12:19:13.789Z | 2024-11-03T14:27:36.238Z |
5398310 | 5398310 | 20241026024334_hfdyl | UK007U | 2024-10-28T12:19:10.556Z | 2024-11-03T14:27:35.881Z |
5398158 | 5398158 | 20241026023042_BytYc | UK007U | 2024-10-28T12:19:03.288Z | 2024-11-03T14:27:35.595Z |
5397958 | 5397958 | 20241026021030_HujPY | UK007U | 2024-10-28T12:18:52.437Z | 2024-11-03T14:27:34.697Z |
5397939 | 5397939 | 20241026020820_37YQT | UK007U | 2024-10-28T12:18:51.553Z | 2024-11-03T14:27:34.614Z |
5397615 | 5397615 | 20241026014323_9073P | UK007U | 2024-10-28T12:18:30.272Z | 2024-11-03T14:27:33.607Z |
5397432 | 5397432 | 20241026012935_CIamg | UK007U | 2024-10-28T12:18:21.704Z | 2024-11-03T14:27:32.913Z |
5397397 | 5397397 | 20241026012513_qNFwW | UK007U | 2024-10-28T12:18:19.510Z | 2024-11-03T14:27:32.774Z |
5397106 | 5397106 | 20241026010214_K1z5C | UK007U | 2024-10-28T12:18:08.205Z | 2024-11-03T14:27:32.033Z |
5396999 | 5396999 | 20241026005514_5o4vq | UK007U | 2024-10-28T12:18:01.791Z | 2024-11-03T14:27:31.659Z |
5396979 | 5396979 | 20241026005415_7NryW | UK007U | 2024-10-28T12:18:01.532Z | 2024-11-03T14:27:31.612Z |
5396901 | 5396901 | 20241026004441_nsLYm | UK007U | 2024-10-28T12:17:58.970Z | 2024-11-03T14:27:31.303Z |
5396691 | 5396691 | 20241026002254_lZXQk | UK007U | 2024-10-28T12:17:53.273Z | 2024-11-03T14:27:30.695Z |
5396655 | 5396655 | 20241026001954_3IKcj | UK007U | 2024-10-28T12:17:52.154Z | 2024-11-03T14:27:30.546Z |
5396513 | 5396513 | 20241026000909_4Av2F | UK007U | 2024-10-28T12:17:47.664Z | 2024-11-03T14:27:30.041Z |
5395471 | 5395471 | 20241025224529_QuhbH | UK007U | 2024-10-28T12:16:17.758Z | 2024-11-03T14:27:25.602Z |
5395418 | 5395418 | 20241025224211_yDCjj | UK007U | 2024-10-28T12:16:13.230Z | 2024-11-03T14:27:25.510Z |
5395406 | 5395406 | 20241025224037_62B3v | UK007U | 2024-10-28T12:16:12.873Z | 2024-11-03T14:27:25.455Z |
5395228 | 5395228 | 20241025222327_rMGyt | UK007U | 2024-10-28T12:16:02.027Z | 2024-11-03T14:27:24.352Z |
5394457 | 5394457 | 20241025203805_D4jmY | UK007U | 2024-10-28T12:14:43.132Z | 2024-11-03T14:27:21.270Z |
5394299 | 5394299 | 20241025201138_UUmU1 | UK007U | 2024-10-28T12:14:20.837Z | 2024-11-03T14:27:20.749Z |
5385054 | 5385054 | 20241024214150_hloQx | UK007U | 2024-10-27T12:18:17.625Z | 2024-11-02T12:28:29.015Z |
5384972 | 5384972 | 20241024212616_wYWSY | UK007U | 2024-10-27T12:18:05.456Z | 2024-11-02T12:28:28.820Z |
5384940 | 5384940 | 20241024211837_3nj2N | UK007U | 2024-10-27T12:18:00.858Z | 2024-11-02T12:28:28.746Z |
5378021 | 5378021 | 20241024052400_4aHkL | UK007U | 2024-10-26T12:22:52.883Z | 2024-11-01T12:27:03.228Z |
5377984 | 5377984 | 20241024052142_IQBWk | UK007U | 2024-10-26T12:22:51.580Z | 2024-11-01T12:27:03.212Z |
5377430 | 5377430 | 20241024045022_sQud5 | UK007U | 2024-10-26T12:22:36.970Z | 2024-11-01T12:27:02.427Z |
5377329 | 5377329 | 20241024044440_3UfJw | UK007U | 2024-10-26T12:22:34.191Z | 2024-11-01T12:27:02.379Z |
5377143 | 5377143 | 20241024043451_ZsXrl | UK007U | 2024-10-26T12:22:28.349Z | 2024-11-01T12:27:02.207Z |
5377109 | 5377109 | 20241024043338_TePMA | UK007U | 2024-10-26T12:22:26.552Z | 2024-11-01T12:27:02.178Z |
5376721 | 5376721 | 20241024041053_ShnqJ | UK007U | 2024-10-26T12:22:11.343Z | 2024-11-01T12:27:01.752Z |
5376332 | 5376332 | 20241024035143_bp2d3 | UK007U | 2024-10-26T12:21:58.063Z | 2024-11-01T12:27:01.502Z |
5375434 | 5375434 | 20241024031328_gi3x9 | UK007U | 2024-10-26T12:21:25.775Z | 2024-11-01T12:27:00.688Z |
5375380 | 5375380 | 20241024031036_AmH53 | UK007U | 2024-10-26T12:21:22.693Z | 2024-11-01T12:27:00.658Z |
5375250 | 5375250 | 20241024030424_ICS5r | UK007U | 2024-10-26T12:21:17.354Z | 2024-11-01T12:27:00.461Z |
5375045 | 5375045 | 20241024025445_33A4J | UK007U | 2024-10-26T12:21:10.481Z | 2024-11-01T12:27:00.127Z |
5374744 | 5374744 | 20241024024159_53M30 | UK007U | 2024-10-26T12:21:00.154Z | 2024-11-01T12:26:59.558Z |
5374619 | 5374619 | 20241024023706_Jeq2M | UK007U | 2024-10-26T12:20:54.836Z | 2024-11-01T12:26:59.520Z |
5374203 | 5374203 | 20241024021540_7l0IG | UK007U | 2024-10-26T12:20:39.161Z | 2024-11-01T12:26:58.758Z |
5374145 | 5374145 | 20241024021211_AyF24 | UK007U | 2024-10-26T12:20:37.801Z | 2024-11-01T12:26:58.709Z |
5373777 | 5373777 | 20241024015343_fnvMb | UK007U | 2024-10-26T12:20:25.558Z | 2024-11-01T12:26:58.475Z |
5373182 | 5373182 | 20241024012721_2qfqe | UK007U | 2024-10-26T12:20:01.006Z | 2024-11-01T12:26:58.157Z |
5372661 | 5372661 | 20241024010056_3W6y7 | UK007U | 2024-10-26T12:19:36.784Z | 2024-11-01T12:26:57.801Z |
5372220 | 5372220 | 20241024003900_yq8BJ | UK007U | 2024-10-26T12:19:15.166Z | 2024-11-01T12:26:57.312Z |
5371975 | 5371975 | 20241024002537_5lal4 | UK007U | 2024-10-26T12:19:01.543Z | 2024-11-01T12:26:57.041Z |
5371958 | 5371958 | 20241024002435_b2OOG | UK007U | 2024-10-26T12:19:00.077Z | 2024-11-01T12:26:57.012Z |
5366268 | 5366268 | 20241024001312_xzEvH | UK007U | 2024-10-25T12:18:19.983Z | 2024-11-01T12:26:56.824Z |
5365856 | 5365856 | 20241023235305_l8pcX | UK007U | 2024-10-25T12:18:09.195Z | 2024-11-01T12:26:56.453Z |
5365807 | 5365807 | 20241023235015_PPJeE | UK007U | 2024-10-25T12:18:07.934Z | 2024-11-01T12:26:56.437Z |
5365440 | 5365440 | 20241023233314_PisR0 | UK007U | 2024-10-25T12:17:58.058Z | 2024-11-01T12:26:56.131Z |
5365107 | 5365107 | 20241023231430_IU9Mb | UK007U | 2024-10-25T12:17:46.199Z | 2024-11-01T12:26:55.877Z |
5365032 | 5365032 | 20241023231113_cYrLp | UK007U | 2024-10-25T12:17:43.743Z | 2024-11-01T12:26:55.832Z |
5364653 | 5364653 | 20241023224511_LebCS | UK007U | 2024-10-25T12:17:28.339Z | 2024-11-01T12:26:55.284Z |
5364131 | 5364131 | 20241023220857_oYs2G | UK007U | 2024-10-25T12:17:10.131Z | 2024-11-01T12:26:54.556Z |
5363711 | 5363711 | 20241023213657_4n2vH | UK007U | 2024-10-25T12:16:37.063Z | 2024-11-01T12:26:53.542Z |
5363554 | 5363554 | 20241023212206_6rDg0 | UK007U | 2024-10-25T12:16:22.540Z | 2024-11-01T12:26:53.367Z |
5363091 | 5363091 | 20241023202533_UjkF0 | UK007U | 2024-10-25T12:15:28.164Z | 2024-11-01T12:26:52.839Z |
5362912 | 5362912 | 20241023201108_sfTO5 | UK007U | 2024-10-25T12:15:16.911Z | 2024-11-01T12:26:52.520Z |
5362806 | 5362806 | 20241023200208_Gw1OH | UK007U | 2024-10-25T12:15:09.014Z | 2024-11-01T12:26:52.452Z |
5361118 | 5361118 | 20241023175051_PbqRX | UK007U | 2024-10-25T12:12:21.387Z | 2024-11-01T12:26:49.312Z |
5350887 | 5350887 | 20241022223757_LX3ZJ | UK007U | 2024-10-24T12:16:44.912Z | 2024-10-31T12:29:58.988Z |
5349336 | 5349336 | 20241022194520_HoWt9 | UK007U | 2024-10-24T12:13:29.497Z | 2024-10-31T12:29:55.096Z |
5349203 | 5349203 | 20241022193405_ElWHi | UK007U | 2024-10-24T12:13:18.396Z | 2024-10-31T12:29:54.843Z |
5345148 | 5345148 | 20241022051557_pnb22 | UK007U | 2024-10-23T12:19:07.665Z | 2024-10-30T12:26:52.235Z |
5344069 | 5344069 | 20241022040407_FKTQa | UK007U | 2024-10-23T12:18:22.147Z | 2024-10-30T12:26:50.913Z |
5343026 | 5343026 | 20241022030111_MMzed | UK007U | 2024-10-23T12:17:32.298Z | 2024-10-30T12:26:49.154Z |
5342722 | 5342722 | 20241022024158_jGcX7 | UK007U | 2024-10-23T12:17:17.225Z | 2024-10-30T12:26:48.841Z |
5340997 | 5340997 | 20241022010747_aGvXB | UK007U | 2024-10-23T12:15:09.645Z | 2024-10-30T12:26:46.504Z |
5340685 | 5340685 | 20241022004233_AT3vD | UK007U | 2024-10-23T12:14:47.887Z | 2024-10-30T12:26:46.179Z |
5340463 | 5340463 | 20241022001637_Y2JpX | UK007U | 2024-10-23T12:14:33.968Z | 2024-10-30T12:26:45.900Z |
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);