participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
390 rows where station_code = "UK008K" 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 |
---|---|---|---|---|---|
5129406 | 5129406 | 20240917035457_VPmvh | UK008K | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5122032 | 5122032 | 20240914042820_mJEfX | UK008K | 2024-09-18T12:11:05.022Z | 2024-09-19T12:20:02.705Z |
5121332 | 5121332 | 20240914035815_Xm2fk | UK008K | 2024-09-18T12:10:54.567Z | 2024-09-19T12:20:01.624Z |
5121238 | 5121238 | 20240914035618_03B7Q | UK008K | 2024-09-18T12:10:52.843Z | 2024-09-19T12:20:01.520Z |
5120291 | 5120291 | 20240914031222_xXJ8R | UK008K | 2024-09-18T12:10:36.715Z | 2024-09-19T12:19:59.849Z |
5107770 | 5107770 | 20240913040937_NdYVv | UK008K | 2024-09-17T12:13:23.553Z | 2024-09-19T12:20:47.532Z |
5106901 | 5106901 | 20240913033804_6bAi1 | UK008K | 2024-09-17T12:13:03.762Z | 2024-09-19T12:20:46.510Z |
5106553 | 5106553 | 20240913032846_X30ef | UK008K | 2024-09-17T12:12:57.187Z | 2024-09-19T12:20:46.174Z |
5105676 | 5105676 | 20240913025456_vtBVi | UK008K | 2024-09-17T12:12:25.624Z | 2024-09-19T12:20:44.792Z |
5104732 | 5104732 | 20240913021954_cot1K | UK008K | 2024-09-17T12:11:43.630Z | 2024-09-19T12:20:42.836Z |
5104447 | 5104447 | 20240913021014_RwRim | UK008K | 2024-09-17T12:11:35.522Z | 2024-09-19T12:20:41.482Z |
5103697 | 5103697 | 20240913013553_ejHYY | UK008K | 2024-09-17T12:11:07.997Z | 2024-09-19T12:20:40.422Z |
5103608 | 5103608 | 20240913013431_c3daU | UK008K | 2024-09-17T12:11:06.077Z | 2024-09-19T12:20:40.379Z |
5102118 | 5102118 | 20240914010628_RARmq | UK008K | 2024-09-17T12:06:49.360Z | 2024-09-19T12:19:52.501Z |
5101926 | 5101926 | 20240914005527_NzMrf | UK008K | 2024-09-17T12:06:24.077Z | 2024-09-19T12:19:51.861Z |
5101729 | 5101729 | 20240914004411_A1rfk | UK008K | 2024-09-17T12:06:10.254Z | 2024-09-19T12:19:51.321Z |
5097251 | 5097251 | 20240913003830_3xJ2D | UK008K | 2024-09-16T12:17:09.371Z | 2024-09-19T12:20:38.022Z |
5094677 | 5094677 | 20240912041435_23yq3 | UK008K | 2024-09-16T12:14:53.888Z | 2024-09-19T12:21:16.372Z |
5093862 | 5093862 | 20240912033956_1gjgJ | UK008K | 2024-09-16T12:14:26.918Z | 2024-09-19T12:21:15.699Z |
5093502 | 5093502 | 20240912032428_dsMTa | UK008K | 2024-09-16T12:14:19.073Z | 2024-09-19T12:21:15.387Z |
5092708 | 5092708 | 20240912025508_2E2zD | UK008K | 2024-09-16T12:14:02.367Z | 2024-09-19T12:21:14.426Z |
5092031 | 5092031 | 20240912023519_8Kpq9 | UK008K | 2024-09-16T12:13:38.403Z | 2024-09-19T12:21:13.603Z |
5091437 | 5091437 | 20240912020942_gADsK | UK008K | 2024-09-16T12:13:06.237Z | 2024-09-19T12:21:13.031Z |
5091025 | 5091025 | 20240912015545_2qpdO | UK008K | 2024-09-16T12:12:46.797Z | 2024-09-19T12:21:12.455Z |
5090484 | 5090484 | 20240912012733_SX3w8 | UK008K | 2024-09-16T12:12:21.535Z | 2024-09-19T12:21:11.339Z |
5090299 | 5090299 | 20240912012012_Rxaae | UK008K | 2024-09-16T12:12:11.822Z | 2024-09-19T12:21:11.170Z |
5089362 | 5089362 | 20240912003809_jofbv | UK008K | 2024-09-16T12:11:21.853Z | 2024-09-19T12:21:09.904Z |
5089323 | 5089323 | 20240912003526_qubeJ | UK008K | 2024-09-16T12:11:20.247Z | 2024-09-19T12:21:09.885Z |
5089225 | 5089225 | 20240912002914_HRtGL | UK008K | 2024-09-16T12:11:17.805Z | 2024-09-19T12:21:09.834Z |
5088697 | 5088697 | 20240913002128_494pi | UK008K | 2024-09-16T12:08:20.948Z | 2024-09-19T12:20:37.182Z |
5087806 | 5087806 | 20240912234445_WPLRd | UK008K | 2024-09-16T12:07:28.300Z | 2024-09-19T12:20:35.679Z |
5087622 | 5087622 | 20240912233719_xxsaK | UK008K | 2024-09-16T12:07:07.695Z | 2024-09-19T12:20:35.512Z |
5075860 | 5075860 | 20240912001008_0xdDz | UK008K | 2024-09-15T12:10:18.101Z | 2024-09-19T12:21:09.603Z |
5075572 | 5075572 | 20240911235536_iPQZY | UK008K | 2024-09-15T12:10:02.063Z | 2024-09-19T12:21:09.307Z |
5074985 | 5074985 | 20240911231953_RjUqL | UK008K | 2024-09-15T12:09:16.482Z | 2024-09-19T12:21:07.965Z |
5074476 | 5074476 | 20240911224013_BDj3o | UK008K | 2024-09-15T12:08:33.658Z | 2024-09-19T12:21:07.347Z |
4966458 | 4966458 | 20240811213010_vnIlC | UK008K | 2024-09-04T12:07:27.632Z | 2024-09-06T12:06:30.065Z |
4965922 | 4965922 | 20240811212058_Jlq9E | UK008K | 2024-09-04T12:07:09.609Z | 2024-09-06T12:06:07.975Z |
4937143 | 4937143 | 20240810214010_RnnNJ | UK008K | 2024-09-01T12:08:03.359Z | 2024-09-06T12:21:59.808Z |
4937122 | 4937122 | 20240810214010_bO71b | UK008K | 2024-09-01T12:08:03.269Z | 2024-09-06T12:21:59.705Z |
4936591 | 4936591 | 20240810212348_1cPRC | UK008K | 2024-09-01T12:07:37.422Z | 2024-09-06T12:21:41.274Z |
4903775 | 4903775 | 20240808031351_HNQUT | UK008K | 2024-08-28T12:19:54.813Z | 2024-08-28T12:19:54.813Z |
4903403 | 4903403 | 20240808025412_vNc42 | UK008K | 2024-08-28T12:19:38.288Z | 2024-08-28T12:19:38.288Z |
4902860 | 4902860 | 20240808023212_sfuih | UK008K | 2024-08-28T12:19:25.441Z | 2024-08-28T12:19:25.441Z |
4902374 | 4902374 | 20240808021017_rIrO3 | UK008K | 2024-08-28T12:19:16.510Z | 2024-08-28T12:19:16.510Z |
4902195 | 4902195 | 20240808020203_OsbD2 | UK008K | 2024-08-28T12:19:07.756Z | 2024-08-28T12:19:07.756Z |
4901853 | 4901853 | 20240808014917_0M56y | UK008K | 2024-08-28T12:18:53.702Z | 2024-08-28T12:18:53.702Z |
4901075 | 4901075 | 20240808010356_UQUUV | UK008K | 2024-08-28T12:18:33.048Z | 2024-08-28T12:18:33.048Z |
4884399 | 4884399 | 20240807031508_LL4mr | UK008K | 2024-08-20T12:15:34.419Z | 2024-08-27T12:16:11.589Z |
4730580 | 4730580 | 20240729001528_QvPgm | UK008K | 2024-08-01T12:01:33.757Z | 2024-08-06T12:14:37.307Z |
4729819 | 4729819 | 20240728225755_er6v8 | UK008K | 2024-07-31T12:13:58.808Z | 2024-08-05T12:20:32.876Z |
4729104 | 4729104 | 20240728223903_B0rPR | UK008K | 2024-07-31T12:13:41.542Z | 2024-08-05T12:20:30.842Z |
4728484 | 4728484 | 20240728222106_4oK8c | UK008K | 2024-07-31T12:13:28.113Z | 2024-08-05T12:20:30.072Z |
4727611 | 4727611 | 20240728214224_0F18n | UK008K | 2024-07-31T12:13:04.328Z | 2024-08-05T12:20:26.945Z |
4720214 | 4720214 | 20240728231825_MT6JH | UK008K | 2024-07-31T12:00:56.769Z | 2024-08-06T12:14:31.949Z |
4719751 | 4719751 | 20240728230528_9cEuT | UK008K | 2024-07-31T12:00:23.708Z | 2024-08-06T12:14:29.712Z |
4719607 | 4719607 | 20240728230038_u9SJW | UK008K | 2024-07-31T12:00:10.319Z | 2024-08-06T12:14:28.590Z |
4705111 | 4705111 | 20240727224651_vWNZj | UK008K | 2024-07-29T12:01:24.065Z | 2024-08-05T12:19:23.885Z |
4704887 | 4704887 | 20240727223101_wwiDd | UK008K | 2024-07-29T12:00:58.961Z | 2024-08-05T12:19:21.716Z |
4704628 | 4704628 | 20240727221447_dVjx8 | UK008K | 2024-07-29T12:00:40.306Z | 2024-08-05T12:19:18.073Z |
4704487 | 4704487 | 20240727220711_ujOwI | UK008K | 2024-07-29T12:00:28.641Z | 2024-08-05T12:19:16.823Z |
4695461 | 4695461 | 20240726215359_v2fpa | UK008K | 2024-07-28T12:01:12.093Z | 2024-08-04T12:19:07.001Z |
4641678 | 4641678 | 20240714005905_2JBG2 | UK008K | 2024-07-16T12:06:15.355Z | 2024-07-22T12:10:23.058Z |
4640728 | 4640728 | 20240713235147_s25m9 | UK008K | 2024-07-16T12:05:48.172Z | 2024-07-22T12:10:19.191Z |
4640152 | 4640152 | 20240713230827_X44ip | UK008K | 2024-07-16T12:05:33.592Z | 2024-07-22T12:10:16.276Z |
4627297 | 4627297 | 20240711221157_tc3BO | UK008K | 2024-07-14T12:08:03.198Z | 2024-07-20T12:13:13.867Z |
4619720 | 4619720 | 20240711004407_lqObG | UK008K | 2024-07-13T12:08:48.347Z | 2024-07-19T12:13:41.852Z |
4619457 | 4619457 | 20240711001523_WxOM0 | UK008K | 2024-07-13T12:08:37.943Z | 2024-07-19T12:13:40.977Z |
4619366 | 4619366 | 20240711000101_vRWYf | UK008K | 2024-07-13T12:08:32.353Z | 2024-07-19T12:13:40.752Z |
4619098 | 4619098 | 20240710232422_bCW2D | UK008K | 2024-07-13T12:08:23.488Z | 2024-07-19T12:13:40.327Z |
4594952 | 4594952 | 20240707223421_SXoEt | UK008K | 2024-07-10T12:10:39.271Z | 2024-07-15T12:12:24.518Z |
4553514 | 4553514 | 20240704005716_GrVaL | UK008K | 2024-07-06T12:02:05.009Z | 2024-07-12T12:08:53.585Z |
4553434 | 4553434 | 20240704005245_AaB0F | UK008K | 2024-07-06T12:01:59.916Z | 2024-07-12T12:08:53.515Z |
4553353 | 4553353 | 20240704004308_6APER | UK008K | 2024-07-06T12:01:51.024Z | 2024-07-12T12:08:53.438Z |
4544785 | 4544785 | 20240703230248_3LH2y | UK008K | 2024-07-05T12:01:10.326Z | 2024-07-12T12:08:52.198Z |
4544731 | 4544731 | 20240703224519_iJQSu | UK008K | 2024-07-05T12:01:07.044Z | 2024-07-12T12:08:52.117Z |
4521934 | 4521934 | 20240629015307_mDYO0 | UK008K | 2024-06-30T12:05:11.293Z | 2024-07-07T12:13:49.803Z |
4521167 | 4521167 | 20240629002754_1zBbA | UK008K | 2024-06-30T12:04:42.168Z | 2024-07-07T12:13:48.691Z |
4520021 | 4520021 | 20240628224855_oM36G | UK008K | 2024-06-30T12:03:39.612Z | 2024-07-07T12:13:46.603Z |
4504581 | 4504581 | 20240625234215_usupf | UK008K | 2024-06-27T12:03:51.215Z | 2024-07-04T12:08:51.813Z |
4504260 | 4504260 | 20240625225949_CDyHS | UK008K | 2024-06-27T12:03:26.904Z | 2024-07-04T12:08:49.457Z |
4501023 | 4501023 | 20240625002705_6VEfQ | UK008K | 2024-06-26T12:04:40.076Z | 2024-07-03T12:13:16.706Z |
4499993 | 4499993 | 20240624224836_5SJth | UK008K | 2024-06-26T12:03:42.367Z | 2024-07-03T12:13:10.491Z |
4499918 | 4499918 | 20240624224256_Exw70 | UK008K | 2024-06-26T12:03:39.901Z | 2024-07-03T12:13:09.967Z |
4499780 | 4499780 | 20240624222356_33FKC | UK008K | 2024-06-26T12:03:23.221Z | 2024-07-03T12:13:09.355Z |
4492659 | 4492659 | 20240621015610_577RO | UK008K | 2024-06-22T12:05:59.342Z | 2024-06-29T12:13:36.041Z |
4492062 | 4492062 | 20240620225110_rN2mf | UK008K | 2024-06-22T12:05:15.827Z | 2024-06-29T12:13:32.427Z |
4491994 | 4491994 | 20240620224113_Bi1mT | UK008K | 2024-06-22T12:05:13.913Z | 2024-06-29T12:13:32.301Z |
4488338 | 4488338 | 20240619223013_PruNK | UK008K | 2024-06-21T12:05:06.047Z | 2024-06-28T12:09:36.074Z |
4488300 | 4488300 | 20240619221354_vdSYl | UK008K | 2024-06-21T12:05:04.335Z | 2024-06-28T12:09:35.894Z |
4480874 | 4480874 | 20240617003231_LMQiL | UK008K | 2024-06-19T12:10:55.940Z | 2024-06-24T12:12:08.213Z |
4479210 | 4479210 | 20240618004412_hOHfN | UK008K | 2024-06-19T12:07:52.013Z | 2024-06-26T12:14:52.967Z |
4478937 | 4478937 | 20240617233659_syD16 | UK008K | 2024-06-19T12:07:21.473Z | 2024-06-26T12:14:48.577Z |
4478913 | 4478913 | 20240617233417_E05VZ | UK008K | 2024-06-19T12:07:20.806Z | 2024-06-26T12:14:48.251Z |
4474919 | 4474919 | 20240617010952_3cnL8 | UK008K | 2024-06-19T12:00:52.261Z | 2024-06-26T12:14:03.901Z |
4474546 | 4474546 | 20240618015409_y3ll6 | UK008K | 2024-06-19T12:00:09.356Z | 2024-06-27T12:10:58.552Z |
4455704 | 4455704 | 20240612231554_miJ72 | UK008K | 2024-06-14T12:01:04.217Z | 2024-06-21T12:11:29.374Z |
4455607 | 4455607 | 20240612225925_PjIpg | UK008K | 2024-06-14T12:00:58.894Z | 2024-06-21T12:11:28.897Z |
4449663 | 4449663 | 20240612014011_jQ9XO | UK008K | 2024-06-13T12:01:39.352Z | 2024-06-20T12:11:54.086Z |
4449515 | 4449515 | 20240612010803_OF3Xn | UK008K | 2024-06-13T12:01:27.781Z | 2024-06-20T12:11:52.854Z |
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);