participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,306 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 |
---|---|---|---|---|---|
5565233 | 5565233 | 20241120040621_4BKbv | UK007U | 2024-11-21T14:18:43.384Z | 2024-11-22T14:21:44.623Z |
5564798 | 5564798 | 20241120032749_Ai3zc | UK007U | 2024-11-21T14:18:04.717Z | 2024-11-22T14:21:36.644Z |
5564359 | 5564359 | 20241120024929_d4dgR | UK007U | 2024-11-21T14:17:30.099Z | 2024-11-22T14:21:30.834Z |
5564090 | 5564090 | 20241120022802_6GTcR | UK007U | 2024-11-21T14:17:08.765Z | 2024-11-22T14:21:26.899Z |
5563991 | 5563991 | 20241120022111_87ITy | UK007U | 2024-11-21T14:17:02.987Z | 2024-11-22T14:21:26.071Z |
5562749 | 5562749 | 20241120000736_tfowD | UK007U | 2024-11-21T14:15:19.848Z | 2024-11-22T14:21:03.392Z |
5562635 | 5562635 | 20241119235932_FwDVt | UK007U | 2024-11-21T14:15:14.486Z | 2024-11-22T14:21:01.389Z |
5558417 | 5558417 | 20241120060314_22QhC | UK007U | 2024-11-21T14:03:13.513Z | 2024-11-22T14:19:21.226Z |
5558278 | 5558278 | 20241120055139_S2cac | UK007U | 2024-11-21T14:02:55.231Z | 2024-11-22T14:19:21.203Z |
5558258 | 5558258 | 20241120054954_SUK0A | UK007U | 2024-11-21T14:02:52.628Z | 2024-11-22T14:19:21.200Z |
5558237 | 5558237 | 20241120054723_ix68h | UK007U | 2024-11-21T14:02:49.471Z | 2024-11-22T14:19:21.197Z |
5558142 | 5558142 | 20241120054046_2VdIJ | UK007U | 2024-11-21T14:02:35.908Z | 2024-11-22T14:19:21.184Z |
5557947 | 5557947 | 20241120052450_WNgq4 | UK007U | 2024-11-21T14:02:07.259Z | 2024-11-22T14:19:21.150Z |
5557681 | 5557681 | 20241120050450_dphM1 | UK007U | 2024-11-21T14:01:30.168Z | 2024-11-22T14:19:21.110Z |
5557588 | 5557588 | 20241120045909_ut2Fp | UK007U | 2024-11-21T14:01:17.183Z | 2024-11-22T14:19:21.096Z |
5557554 | 5557554 | 20241120045644_TX4xS | UK007U | 2024-11-21T14:01:10.181Z | 2024-11-22T14:19:21.090Z |
5557540 | 5557540 | 20241120045406_5jqaA | UK007U | 2024-11-21T14:01:07.127Z | 2024-11-22T14:19:21.087Z |
5557411 | 5557411 | 20241120044403_LB6MW | UK007U | 2024-11-21T14:00:44.283Z | 2024-11-22T14:19:21.065Z |
5557408 | 5557408 | 20241120044403_gbtcp | UK007U | 2024-11-21T14:00:43.795Z | 2024-11-22T14:19:21.064Z |
5557309 | 5557309 | 20241120043531_ICooJ | UK007U | 2024-11-21T14:00:28.541Z | 2024-11-22T14:19:21.050Z |
5532225 | 5532225 | 20241112045305_LtPMK | UK007U | 2024-11-13T14:16:28.513Z | 2024-11-20T14:26:21.157Z |
5532181 | 5532181 | 20241112044732_7W4pb | UK007U | 2024-11-13T14:16:25.057Z | 2024-11-20T14:26:20.701Z |
5532126 | 5532126 | 20241112043915_pK3NG | UK007U | 2024-11-13T14:16:20.319Z | 2024-11-20T14:26:19.004Z |
5532070 | 5532070 | 20241112043421_M6RBh | UK007U | 2024-11-13T14:16:15.125Z | 2024-11-20T14:26:18.346Z |
5531689 | 5531689 | 20241112040005_ItT5h | UK007U | 2024-11-13T14:15:50.803Z | 2024-11-20T14:26:13.469Z |
5531245 | 5531245 | 20241112032517_MOtZC | UK007U | 2024-11-13T14:15:31.493Z | 2024-11-20T14:26:09.472Z |
5531183 | 5531183 | 20241112031946_322V2 | UK007U | 2024-11-13T14:15:22.748Z | 2024-11-20T14:26:08.481Z |
5531180 | 5531180 | 20241112031946_FZDJw | UK007U | 2024-11-13T14:15:22.566Z | 2024-11-20T14:26:08.467Z |
5531103 | 5531103 | 20241112031407_43hig | UK007U | 2024-11-13T14:15:13.343Z | 2024-11-20T14:26:07.859Z |
5531028 | 5531028 | 20241112030741_feUNx | UK007U | 2024-11-13T14:15:04.738Z | 2024-11-20T14:26:06.511Z |
5530961 | 5530961 | 20241112030248_G2ZE8 | UK007U | 2024-11-13T14:14:55.364Z | 2024-11-20T14:26:05.676Z |
5530770 | 5530770 | 20241112024607_zRy2e | UK007U | 2024-11-13T14:14:36.662Z | 2024-11-20T14:26:03.289Z |
5530691 | 5530691 | 20241112023807_9HB72 | UK007U | 2024-11-13T14:14:27.855Z | 2024-11-20T14:26:02.599Z |
5530681 | 5530681 | 20241112023745_kV3Kb | UK007U | 2024-11-13T14:14:27.576Z | 2024-11-20T14:26:02.577Z |
5530494 | 5530494 | 20241112022351_Itng3 | UK007U | 2024-11-13T14:14:18.755Z | 2024-11-20T14:26:00.822Z |
5530124 | 5530124 | 20241112014805_Jumwk | UK007U | 2024-11-13T14:13:57.762Z | 2024-11-20T14:25:54.704Z |
5529325 | 5529325 | 20241112000133_hqUF4 | UK007U | 2024-11-13T14:12:22.228Z | 2024-11-20T14:25:42.831Z |
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 |
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);