participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,336 rows where station_code = "KR000H" 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 |
---|---|---|---|---|---|
5583842 | 5583842 | 20241118175743_mh2hz | KR000H | 2024-11-23T14:25:04.638Z | 2024-11-23T14:25:04.638Z |
5583721 | 5583721 | 20241118114316_StPAb | KR000H | 2024-11-23T14:24:57.422Z | 2024-11-23T14:24:57.422Z |
5578807 | 5578807 | 20241121210423_3c2f2 | KR000H | 2024-11-23T14:17:34.586Z | 2024-11-23T14:21:24.916Z |
5578726 | 5578726 | 20241121205113_0GxAc | KR000H | 2024-11-23T14:17:30.892Z | 2024-11-23T14:21:24.899Z |
5578705 | 5578705 | 20241121204920_2gsOW | KR000H | 2024-11-23T14:17:29.864Z | 2024-11-23T14:21:24.894Z |
5578571 | 5578571 | 20241121202336_5UfKc | KR000H | 2024-11-23T14:17:23.010Z | 2024-11-23T14:21:24.867Z |
5578457 | 5578457 | 20241121195258_2YBzw | KR000H | 2024-11-23T14:17:16.871Z | 2024-11-23T14:21:24.842Z |
5578456 | 5578456 | 20241121195221_QO7l9 | KR000H | 2024-11-23T14:17:16.241Z | 2024-11-23T14:21:24.842Z |
5578396 | 5578396 | 20241121194119_dVb01 | KR000H | 2024-11-23T14:17:03.023Z | 2024-11-23T14:21:24.828Z |
5578274 | 5578274 | 20241121192045_wtl4x | KR000H | 2024-11-23T14:16:41.629Z | 2024-11-23T14:21:24.797Z |
5578075 | 5578075 | 20241121184806_LBjW8 | KR000H | 2024-11-23T14:16:27.041Z | 2024-11-23T14:21:24.755Z |
5578060 | 5578060 | 20241121184145_XKBbc | KR000H | 2024-11-23T14:16:25.999Z | 2024-11-23T14:21:24.751Z |
5577999 | 5577999 | 20241121182837_j3s3q | KR000H | 2024-11-23T14:16:22.070Z | 2024-11-23T14:21:24.736Z |
5577783 | 5577783 | 20241121175649_vkAFp | KR000H | 2024-11-23T14:16:00.790Z | 2024-11-23T14:21:24.688Z |
5577656 | 5577656 | 20241121173320_251PY | KR000H | 2024-11-23T14:15:37.990Z | 2024-11-23T14:21:24.652Z |
5577599 | 5577599 | 20241121172248_ohBOZ | KR000H | 2024-11-23T14:15:30.666Z | 2024-11-23T14:21:24.636Z |
5577506 | 5577506 | 20241121163843_kEWxA | KR000H | 2024-11-23T14:15:21.208Z | 2024-11-23T14:21:24.609Z |
5577499 | 5577499 | 20241121163235_c6Qnu | KR000H | 2024-11-23T14:15:20.113Z | 2024-11-23T14:21:24.603Z |
5577423 | 5577423 | 20241121155125_RlLHq | KR000H | 2024-11-23T14:15:12.109Z | 2024-11-23T14:21:24.571Z |
5577391 | 5577391 | 20241121153523_zJQZR | KR000H | 2024-11-23T14:15:08.388Z | 2024-11-23T14:21:24.549Z |
5559183 | 5559183 | 20241120093525_JHpmp | KR000H | 2024-11-21T14:05:33.300Z | 2024-11-23T14:22:09.621Z |
5556199 | 5556199 | 20241119204304_KEffO | KR000H | 2024-11-20T14:07:39.393Z | 2024-11-23T14:24:24.316Z |
5556192 | 5556192 | 20241119203457_Ur3BL | KR000H | 2024-11-20T14:07:38.950Z | 2024-11-23T14:24:24.154Z |
5556172 | 5556172 | 20241119202735_Bgo0u | KR000H | 2024-11-20T14:07:32.566Z | 2024-11-22T14:20:35.658Z |
5556150 | 5556150 | 20241119202246_BDBhK | KR000H | 2024-11-20T14:07:28.628Z | 2024-11-23T14:24:23.521Z |
5556122 | 5556122 | 20241119201259_9GU69 | KR000H | 2024-11-20T14:07:22.356Z | 2024-11-23T14:24:22.995Z |
5556088 | 5556088 | 20241119195402_ibXOh | KR000H | 2024-11-20T14:07:19.292Z | 2024-11-23T14:24:22.105Z |
5556061 | 5556061 | 20241119193858_2IrXa | KR000H | 2024-11-20T14:07:16.708Z | 2024-11-23T14:24:21.826Z |
5556049 | 5556049 | 20241119193246_n2Z08 | KR000H | 2024-11-20T14:07:15.573Z | 2024-11-23T14:24:21.734Z |
5556004 | 5556004 | 20241119190734_Lq6xg | KR000H | 2024-11-20T14:07:12.817Z | 2024-11-23T14:24:20.977Z |
5556000 | 5556000 | 20241119190723_ANE2L | KR000H | 2024-11-20T14:07:12.565Z | 2024-11-23T14:24:20.934Z |
5555955 | 5555955 | 20241119182109_iAp2s | KR000H | 2024-11-20T14:07:08.478Z | 2024-11-23T14:24:19.595Z |
5555056 | 5555056 | 20241119112814_Dfw7q | KR000H | 2024-11-20T14:04:20.327Z | 2024-11-23T14:24:11.056Z |
5554809 | 5554809 | 20241119104348_dgJbd | KR000H | 2024-11-20T14:03:21.551Z | 2024-11-23T14:24:08.604Z |
5552302 | 5552302 | 20241118202256_mu9ZQ | KR000H | 2024-11-19T14:06:19.271Z | 2024-11-23T14:25:05.751Z |
5552222 | 5552222 | 20241118192454_nKVeo | KR000H | 2024-11-19T14:06:08.458Z | 2024-11-23T14:25:05.226Z |
5552185 | 5552185 | 20241118190341_6ipnF | KR000H | 2024-11-19T14:06:06.291Z | 2024-11-23T14:25:05.109Z |
5552147 | 5552147 | 20241118183330_RVmO6 | KR000H | 2024-11-19T14:06:02.889Z | 2024-11-23T14:25:04.934Z |
5552124 | 5552124 | 20241118182754_EAaPZ | KR000H | 2024-11-19T14:06:02.109Z | 2024-11-23T14:25:04.813Z |
5552036 | 5552036 | 20241118172524_ddB3A | KR000H | 2024-11-19T14:05:57.024Z | 2024-11-23T14:25:04.313Z |
5551992 | 5551992 | 20241118165734_hvdc4 | KR000H | 2024-11-19T14:05:52.945Z | 2024-11-23T14:25:03.954Z |
5551950 | 5551950 | 20241118160703_7w5vh | KR000H | 2024-11-19T14:05:50.135Z | 2024-11-23T14:25:03.656Z |
5551807 | 5551807 | 20241118151934_dJD4D | KR000H | 2024-11-19T14:05:34.274Z | 2024-11-23T14:25:03.324Z |
5550055 | 5550055 | 20241118091923_56hFw | KR000H | 2024-11-19T14:01:30.989Z | 2024-11-23T14:24:52.834Z |
5547893 | 5547893 | 20241117202533_aIv6E | KR000H | 2024-11-18T14:06:48.430Z | 2024-11-23T14:25:26.739Z |
5547870 | 5547870 | 20241117201646_QSG7k | KR000H | 2024-11-18T14:06:46.922Z | 2024-11-23T14:25:26.612Z |
5547841 | 5547841 | 20241117200221_5NfWF | KR000H | 2024-11-18T14:06:43.883Z | 2024-11-23T14:25:26.498Z |
5547534 | 5547534 | 20241117174010_p23Jw | KR000H | 2024-11-18T14:06:01.244Z | 2024-11-23T14:25:23.573Z |
5547503 | 5547503 | 20241117172728_mRmg6 | KR000H | 2024-11-18T14:05:58.734Z | 2024-11-23T14:25:23.274Z |
5547298 | 5547298 | 20241117153125_iwxIy | KR000H | 2024-11-18T14:05:26.566Z | 2024-11-23T14:25:21.439Z |
5547046 | 5547046 | 20241117142735_A9DYi | KR000H | 2024-11-18T14:04:47.819Z | 2024-11-23T14:25:20.519Z |
5537039 | 5537039 | 20241112201132_o7w1t | KR000H | 2024-11-14T14:10:53.469Z | 2024-11-21T14:26:08.437Z |
5537001 | 5537001 | 20241112200306_SNtbj | KR000H | 2024-11-14T14:10:49.768Z | 2024-11-21T14:26:07.842Z |
5536994 | 5536994 | 20241112200115_bgBpA | KR000H | 2024-11-14T14:10:49.213Z | 2024-11-21T14:26:07.733Z |
5536988 | 5536988 | 20241112200007_yx3Rs | KR000H | 2024-11-14T14:10:48.974Z | 2024-11-21T14:26:07.727Z |
5536811 | 5536811 | 20241112191735_sjGQs | KR000H | 2024-11-14T14:10:34.492Z | 2024-11-21T14:26:05.820Z |
5536804 | 5536804 | 20241112191625_Bznhj | KR000H | 2024-11-14T14:10:34.140Z | 2024-11-21T14:26:05.814Z |
5536733 | 5536733 | 20241112185953_uzGqR | KR000H | 2024-11-14T14:10:30.867Z | 2024-11-21T14:26:05.289Z |
5536660 | 5536660 | 20241112184943_CrqRk | KR000H | 2024-11-14T14:10:26.211Z | 2024-11-21T14:26:04.355Z |
5536577 | 5536577 | 20241112183310_zrQ9Z | KR000H | 2024-11-14T14:10:21.394Z | 2024-11-21T14:26:03.374Z |
5536571 | 5536571 | 20241112183230_CkkdN | KR000H | 2024-11-14T14:10:20.740Z | 2024-11-21T14:26:03.318Z |
5536455 | 5536455 | 20241112180733_nr7gm | KR000H | 2024-11-14T14:09:59.963Z | 2024-11-21T14:26:01.085Z |
5536434 | 5536434 | 20241112175916_NpnqF | KR000H | 2024-11-14T14:09:55.804Z | 2024-11-21T14:26:00.918Z |
5536427 | 5536427 | 20241112175841_P9s1u | KR000H | 2024-11-14T14:09:53.767Z | 2024-11-21T14:26:00.862Z |
5536175 | 5536175 | 20241112160412_G2bCI | KR000H | 2024-11-14T14:09:17.109Z | 2024-11-21T14:25:57.231Z |
5536163 | 5536163 | 20241112155811_6um0S | KR000H | 2024-11-14T14:09:16.494Z | 2024-11-21T14:25:57.114Z |
5535834 | 5535834 | 20241112143608_3EGTm | KR000H | 2024-11-14T14:08:53.333Z | 2024-11-21T14:25:53.703Z |
5535825 | 5535825 | 20241112143411_m4ArX | KR000H | 2024-11-14T14:08:52.720Z | 2024-11-21T14:25:53.696Z |
5535667 | 5535667 | 20241112133528_02MTq | KR000H | 2024-11-14T14:08:19.172Z | 2024-11-21T14:25:51.096Z |
5535655 | 5535655 | 20241112133024_x7yqR | KR000H | 2024-11-14T14:08:16.722Z | 2024-11-21T14:25:50.874Z |
5535627 | 5535627 | 20241112131042_bErLZ | KR000H | 2024-11-14T14:08:11.840Z | 2024-11-21T14:25:50.758Z |
5535575 | 5535575 | 20241112125243_3UBWB | KR000H | 2024-11-14T14:08:08.175Z | 2024-11-21T14:25:50.209Z |
5535523 | 5535523 | 20241112124336_r4EL3 | KR000H | 2024-11-14T14:08:01.974Z | 2024-11-21T14:25:48.978Z |
5535475 | 5535475 | 20241112123503_GgDob | KR000H | 2024-11-14T14:07:58.948Z | 2024-11-21T14:25:48.565Z |
5535426 | 5535426 | 20241112122516_4HLlq | KR000H | 2024-11-14T14:07:55.323Z | 2024-11-21T14:25:48.003Z |
5534202 | 5534202 | 20241113111917_ZLeGl | KR000H | 2024-11-14T14:03:46.235Z | 2024-11-22T14:24:12.952Z |
5527213 | 5527213 | 20241111122207_2ZE5L | KR000H | 2024-11-13T14:07:00.198Z | 2024-11-20T14:24:54.549Z |
5522538 | 5522538 | 20241110202416_r8cpD | KR000H | 2024-11-12T14:13:31.815Z | 2024-11-19T14:22:03.548Z |
5522432 | 5522432 | 20241110200240_h4d0Y | KR000H | 2024-11-12T14:13:15.629Z | 2024-11-19T14:22:02.005Z |
5522424 | 5522424 | 20241110200019_qRNeh | KR000H | 2024-11-12T14:13:15.009Z | 2024-11-19T14:22:01.867Z |
5522277 | 5522277 | 20241110193332_mvyTK | KR000H | 2024-11-12T14:13:02.419Z | 2024-11-19T14:21:59.823Z |
5522270 | 5522270 | 20241110193230_3YntU | KR000H | 2024-11-12T14:13:01.933Z | 2024-11-19T14:21:59.804Z |
5522245 | 5522245 | 20241110193044_svXU2 | KR000H | 2024-11-12T14:13:00.434Z | 2024-11-19T14:21:59.717Z |
5522099 | 5522099 | 20241110190613_MziEe | KR000H | 2024-11-12T14:12:47.611Z | 2024-11-19T14:21:57.729Z |
5521975 | 5521975 | 20241110184158_u1Nrj | KR000H | 2024-11-12T14:12:20.603Z | 2024-11-19T14:21:56.488Z |
5521913 | 5521913 | 20241110183543_mSsm6 | KR000H | 2024-11-12T14:12:09.813Z | 2024-11-19T14:21:56.138Z |
5521370 | 5521370 | 20241110165831_imhBc | KR000H | 2024-11-12T14:10:55.476Z | 2024-11-19T14:21:52.352Z |
5521162 | 5521162 | 20241110161506_217eX | KR000H | 2024-11-12T14:10:34.289Z | 2024-11-19T14:21:49.486Z |
5521151 | 5521151 | 20241110161250_BjZc7 | KR000H | 2024-11-12T14:10:33.364Z | 2024-11-19T14:21:49.413Z |
5521119 | 5521119 | 20241110160452_gV5tq | KR000H | 2024-11-12T14:10:29.706Z | 2024-11-19T14:21:48.782Z |
5521107 | 5521107 | 20241110160405_q1WZ5 | KR000H | 2024-11-12T14:10:28.620Z | 2024-11-19T14:21:48.536Z |
5521044 | 5521044 | 20241110155039_tjd2M | KR000H | 2024-11-12T14:10:18.134Z | 2024-11-19T14:21:47.797Z |
5521032 | 5521032 | 20241110154859_rf3B0 | KR000H | 2024-11-12T14:10:15.957Z | 2024-11-19T14:21:47.714Z |
5521022 | 5521022 | 20241110154733_3m4M3 | KR000H | 2024-11-12T14:10:11.429Z | 2024-11-19T14:21:47.685Z |
5521002 | 5521002 | 20241110154248_F54Y3 | KR000H | 2024-11-12T14:10:03.021Z | 2024-11-19T14:21:47.321Z |
5520888 | 5520888 | 20241110151413_fKwPe | KR000H | 2024-11-12T14:09:41.854Z | 2024-11-19T14:21:45.225Z |
5520856 | 5520856 | 20241110150434_3LTSw | KR000H | 2024-11-12T14:09:37.719Z | 2024-11-19T14:21:44.733Z |
5520750 | 5520750 | 20241110141659_wpoo7 | KR000H | 2024-11-12T14:09:19.936Z | 2024-11-19T14:21:43.196Z |
5520713 | 5520713 | 20241110135311_LNv3Q | KR000H | 2024-11-12T14:09:04.407Z | 2024-11-19T14:21:42.304Z |
5520580 | 5520580 | 20241110123302_DuvHT | KR000H | 2024-11-12T14:08:43.131Z | 2024-11-19T14:21:39.162Z |
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);