participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,335 rows where station_code = "KR002C" 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 |
---|---|---|---|---|---|
5097096 | 5097096 | 20240912143601_RrYyI | KR002C | 2024-09-16T12:16:44.856Z | 2024-09-16T12:17:32.030Z |
5097089 | 5097089 | 20240912143127_RSs8M | KR002C | 2024-09-16T12:16:44.700Z | 2024-09-16T12:17:32.028Z |
5084270 | 5084270 | 20240912190420_4AiEQ | KR002C | 2024-09-16T12:01:44.378Z | 2024-09-16T12:17:04.213Z |
5084093 | 5084093 | 20240912180606_SuWYy | KR002C | 2024-09-16T12:01:07.919Z | 2024-09-16T12:17:04.090Z |
5084067 | 5084067 | 20240912175917_qZoRs | KR002C | 2024-09-16T12:01:03.675Z | 2024-09-16T12:17:04.074Z |
5084058 | 5084058 | 20240912175536_SMEE5 | KR002C | 2024-09-16T12:01:01.637Z | 2024-09-16T12:17:04.067Z |
5063202 | 5063202 | 20240909201635_uBqYM | KR002C | 2024-09-14T12:13:40.205Z | 2024-09-16T12:19:42.662Z |
5063091 | 5063091 | 20240909194922_321Pu | KR002C | 2024-09-14T12:13:26.315Z | 2024-09-16T12:19:41.597Z |
5063030 | 5063030 | 20240909194047_Hfm3S | KR002C | 2024-09-14T12:13:20.226Z | 2024-09-16T12:19:41.374Z |
5062947 | 5062947 | 20240909191757_7wFub | KR002C | 2024-09-14T12:13:06.749Z | 2024-09-16T12:19:40.567Z |
5062844 | 5062844 | 20240909183951_SgBkr | KR002C | 2024-09-14T12:12:57.764Z | 2024-09-16T12:19:39.805Z |
5062633 | 5062633 | 20240909175106_ynnaI | KR002C | 2024-09-14T12:12:38.887Z | 2024-09-16T12:19:38.251Z |
5062626 | 5062626 | 20240909175022_YLW0p | KR002C | 2024-09-14T12:12:38.357Z | 2024-09-16T12:19:38.219Z |
5062605 | 5062605 | 20240909174627_9SD4Z | KR002C | 2024-09-14T12:12:36.506Z | 2024-09-16T12:19:38.012Z |
5062503 | 5062503 | 20240909173414_EUNo2 | KR002C | 2024-09-14T12:12:29.773Z | 2024-09-16T12:19:37.595Z |
5061999 | 5061999 | 20240909163149_22esD | KR002C | 2024-09-14T12:11:43.334Z | 2024-09-16T12:19:35.047Z |
5061857 | 5061857 | 20240909161158_TeX39 | KR002C | 2024-09-14T12:11:33.648Z | 2024-09-16T12:19:34.342Z |
5061789 | 5061789 | 20240909155942_3udG9 | KR002C | 2024-09-14T12:11:24.722Z | 2024-09-16T12:19:33.855Z |
5061650 | 5061650 | 20240909153640_IMH53 | KR002C | 2024-09-14T12:11:05.999Z | 2024-09-16T12:19:32.928Z |
5061070 | 5061070 | 20240909140401_d93G6 | KR002C | 2024-09-14T12:10:13.099Z | 2024-09-16T12:19:28.955Z |
5060934 | 5060934 | 20240909132757_oC4eZ | KR002C | 2024-09-14T12:09:56.624Z | 2024-09-16T12:19:28.310Z |
5051476 | 5051476 | 20240907173239_HsQ8H | KR002C | 2024-09-13T12:14:18.296Z | 2024-09-16T12:21:00.549Z |
5050485 | 5050485 | 20240907152515_y20cL | KR002C | 2024-09-13T12:13:33.457Z | 2024-09-16T12:20:57.812Z |
5050290 | 5050290 | 20240907150424_kozuQ | KR002C | 2024-09-13T12:13:22.664Z | 2024-09-16T12:20:56.927Z |
5050138 | 5050138 | 20240907143817_sekd5 | KR002C | 2024-09-13T12:13:11.439Z | 2024-09-16T12:20:56.420Z |
5045896 | 5045896 | 20240908195657_jTluh | KR002C | 2024-09-13T12:05:19.739Z | 2024-09-16T12:20:27.955Z |
5045785 | 5045785 | 20240908192046_AbUr8 | KR002C | 2024-09-13T12:04:56.784Z | 2024-09-16T12:20:27.408Z |
5045728 | 5045728 | 20240908183009_BEhGD | KR002C | 2024-09-13T12:04:48.325Z | 2024-09-16T12:20:27.074Z |
5045669 | 5045669 | 20240908174201_9vYv3 | KR002C | 2024-09-13T12:04:39.801Z | 2024-09-16T12:20:26.562Z |
5045641 | 5045641 | 20240908173535_zgxaD | KR002C | 2024-09-13T12:04:31.482Z | 2024-09-16T12:20:26.427Z |
5045486 | 5045486 | 20240908171037_HKsyc | KR002C | 2024-09-13T12:04:13.786Z | 2024-09-16T12:20:25.941Z |
5045465 | 5045465 | 20240908170741_bmAab | KR002C | 2024-09-13T12:04:11.473Z | 2024-09-16T12:20:25.878Z |
5045190 | 5045190 | 20240908163144_Qv4T9 | KR002C | 2024-09-13T12:03:39.138Z | 2024-09-16T12:20:24.936Z |
5044803 | 5044803 | 20240908154451_EXyG4 | KR002C | 2024-09-13T12:02:58.303Z | 2024-09-16T12:20:23.548Z |
5044745 | 5044745 | 20240908153917_kMlf2 | KR002C | 2024-09-13T12:02:53.166Z | 2024-09-16T12:20:23.489Z |
5044397 | 5044397 | 20240908145606_peyLV | KR002C | 2024-09-13T12:02:06.963Z | 2024-09-16T12:20:21.850Z |
5044026 | 5044026 | 20240908135838_kGVtb | KR002C | 2024-09-13T12:01:16.668Z | 2024-09-16T12:20:19.709Z |
5043765 | 5043765 | 20240908130308_NF9cA | KR002C | 2024-09-13T12:00:35.449Z | 2024-09-16T12:20:18.798Z |
5042450 | 5042450 | 20240907114116_I00pj | KR002C | 2024-09-12T12:17:11.709Z | 2024-09-16T12:20:52.948Z |
5036874 | 5036874 | 20240905143818_HTe9e | KR002C | 2024-09-12T12:13:56.675Z | 2024-09-14T12:22:53.524Z |
5036696 | 5036696 | 20240905141503_DS5z3 | KR002C | 2024-09-12T12:13:52.550Z | 2024-09-14T12:22:53.110Z |
5036589 | 5036589 | 20240905135711_WSe76 | KR002C | 2024-09-12T12:13:49.551Z | 2024-09-14T12:22:52.606Z |
5036430 | 5036430 | 20240905133320_5v88t | KR002C | 2024-09-12T12:13:41.498Z | 2024-09-14T12:22:52.436Z |
5036231 | 5036231 | 20240905130012_3dMlt | KR002C | 2024-09-12T12:13:30.223Z | 2024-09-14T12:22:52.119Z |
5035997 | 5035997 | 20240905122518_tcz23 | KR002C | 2024-09-12T12:13:16.602Z | 2024-09-14T12:22:51.755Z |
5018668 | 5018668 | 20240904192745_j93AC | KR002C | 2024-09-10T12:11:10.071Z | 2024-09-13T12:19:48.455Z |
5018654 | 5018654 | 20240904192356_Z171j | KR002C | 2024-09-10T12:11:07.830Z | 2024-09-13T12:19:48.439Z |
5018643 | 5018643 | 20240904192048_R2y12 | KR002C | 2024-09-10T12:11:05.067Z | 2024-09-13T12:19:48.390Z |
5018594 | 5018594 | 20240904190654_gFS75 | KR002C | 2024-09-10T12:10:57.642Z | 2024-09-13T12:19:48.273Z |
5018492 | 5018492 | 20240904182418_mx3mH | KR002C | 2024-09-10T12:10:42.737Z | 2024-09-13T12:19:47.963Z |
5018480 | 5018480 | 20240904182018_slLPz | KR002C | 2024-09-10T12:10:41.730Z | 2024-09-13T12:19:47.952Z |
5018453 | 5018453 | 20240904181256_qKVuO | KR002C | 2024-09-10T12:10:38.796Z | 2024-09-13T12:19:47.918Z |
5018440 | 5018440 | 20240904180720_ttLWB | KR002C | 2024-09-10T12:10:37.129Z | 2024-09-13T12:19:47.896Z |
5018407 | 5018407 | 20240904175712_UpGSZ | KR002C | 2024-09-10T12:10:34.503Z | 2024-09-13T12:19:47.781Z |
5018347 | 5018347 | 20240904174552_GKuAB | KR002C | 2024-09-10T12:10:29.742Z | 2024-09-13T12:19:47.647Z |
5018318 | 5018318 | 20240904174009_SSjcr | KR002C | 2024-09-10T12:10:26.114Z | 2024-09-13T12:19:47.568Z |
5018117 | 5018117 | 20240904171205_d9rui | KR002C | 2024-09-10T12:10:01.377Z | 2024-09-13T12:19:47.211Z |
5016913 | 5016913 | 20240904151043_oX2OX | KR002C | 2024-09-10T12:08:30.821Z | 2024-09-13T12:19:46.444Z |
5016775 | 5016775 | 20240904145134_eu43t | KR002C | 2024-09-10T12:08:16.320Z | 2024-09-13T12:19:46.302Z |
5016083 | 5016083 | 20240904132919_lG97c | KR002C | 2024-09-10T12:07:19.586Z | 2024-09-13T12:19:45.195Z |
5016015 | 5016015 | 20240904131933_reazf | KR002C | 2024-09-10T12:07:12.247Z | 2024-09-13T12:19:45.131Z |
5016013 | 5016013 | 20240904131842_ijTTY | KR002C | 2024-09-10T12:07:11.779Z | 2024-09-13T12:19:45.126Z |
5015908 | 5015908 | 20240904130033_ggjNQ | KR002C | 2024-09-10T12:06:58.147Z | 2024-09-13T12:19:44.925Z |
5015898 | 5015898 | 20240904125609_RLh3d | KR002C | 2024-09-10T12:06:57.067Z | 2024-09-13T12:19:44.844Z |
5015731 | 5015731 | 20240904122022_olT9n | KR002C | 2024-09-10T12:06:42.159Z | 2024-09-13T12:19:44.627Z |
5015167 | 5015167 | 20240905143818_oG4if | KR002C | 2024-09-10T12:04:37.358Z | 2024-09-11T12:16:31.410Z |
5015012 | 5015012 | 20240905141503_bbyEh | KR002C | 2024-09-10T12:04:23.629Z | 2024-09-11T12:16:31.351Z |
5014897 | 5014897 | 20240905135711_2An4I | KR002C | 2024-09-10T12:04:12.511Z | 2024-09-11T12:16:31.318Z |
5014750 | 5014750 | 20240905133320_H3pQU | KR002C | 2024-09-10T12:03:46.335Z | 2024-09-14T12:22:52.441Z |
5014556 | 5014556 | 20240905130012_0vrrN | KR002C | 2024-09-10T12:03:26.940Z | 2024-09-11T12:16:31.202Z |
5014328 | 5014328 | 20240905122518_NY2RF | KR002C | 2024-09-10T12:02:47.433Z | 2024-09-11T12:16:31.124Z |
5007031 | 5007031 | 20240903194840_VkzcX | KR002C | 2024-09-09T12:05:20.701Z | 2024-09-12T12:19:11.158Z |
5006997 | 5006997 | 20240903194211_mnEkS | KR002C | 2024-09-09T12:05:18.579Z | 2024-09-12T12:19:11.042Z |
5006934 | 5006934 | 20240903193221_zbKS6 | KR002C | 2024-09-09T12:05:13.885Z | 2024-09-12T12:19:10.897Z |
5006888 | 5006888 | 20240903192151_mO3UQ | KR002C | 2024-09-09T12:05:10.980Z | 2024-09-12T12:19:10.774Z |
5006885 | 5006885 | 20240903191912_WhBj4 | KR002C | 2024-09-09T12:05:10.777Z | 2024-09-12T12:19:10.773Z |
5006765 | 5006765 | 20240903185231_B2lnN | KR002C | 2024-09-09T12:05:01.869Z | 2024-09-12T12:19:09.451Z |
5006665 | 5006665 | 20240903181935_VaHom | KR002C | 2024-09-09T12:04:52.273Z | 2024-09-12T12:19:09.161Z |
5006563 | 5006563 | 20240903175317_Dd510 | KR002C | 2024-09-09T12:04:46.171Z | 2024-09-12T12:19:08.749Z |
5006284 | 5006284 | 20240903171110_UyUlc | KR002C | 2024-09-09T12:04:28.993Z | 2024-09-12T12:19:08.076Z |
5006091 | 5006091 | 20240903165343_21HUD | KR002C | 2024-09-09T12:04:19.944Z | 2024-09-12T12:19:07.628Z |
5006017 | 5006017 | 20240903164426_or335 | KR002C | 2024-09-09T12:04:16.804Z | 2024-09-12T12:19:07.235Z |
5005953 | 5005953 | 20240903163801_VGGDG | KR002C | 2024-09-09T12:04:14.169Z | 2024-09-12T12:19:07.115Z |
5005848 | 5005848 | 20240903162242_ceXzr | KR002C | 2024-09-09T12:04:09.781Z | 2024-09-12T12:19:06.965Z |
5005772 | 5005772 | 20240903160941_2rqGE | KR002C | 2024-09-09T12:04:03.561Z | 2024-09-12T12:19:06.611Z |
5005738 | 5005738 | 20240903160203_WVhql | KR002C | 2024-09-09T12:04:00.879Z | 2024-09-12T12:19:06.522Z |
5005620 | 5005620 | 20240903154545_PH4qL | KR002C | 2024-09-09T12:03:51.721Z | 2024-09-12T12:19:06.255Z |
5005580 | 5005580 | 20240903153956_xvldZ | KR002C | 2024-09-09T12:03:49.506Z | 2024-09-12T12:19:06.207Z |
5005516 | 5005516 | 20240903152703_3HOhu | KR002C | 2024-09-09T12:03:47.081Z | 2024-09-12T12:19:06.121Z |
5005497 | 5005497 | 20240903152031_30yIy | KR002C | 2024-09-09T12:03:45.750Z | 2024-09-12T12:19:06.034Z |
5005312 | 5005312 | 20240903145309_ZPti8 | KR002C | 2024-09-09T12:03:36.011Z | 2024-09-12T12:19:05.710Z |
5005201 | 5005201 | 20240903142914_GMcWJ | KR002C | 2024-09-09T12:03:26.374Z | 2024-09-12T12:19:05.455Z |
5004780 | 5004780 | 20240903123859_t8cZ0 | KR002C | 2024-09-09T12:03:02.282Z | 2024-09-12T12:19:03.973Z |
5004761 | 5004761 | 20240903123044_ROjq0 | KR002C | 2024-09-09T12:03:00.207Z | 2024-09-12T12:19:03.754Z |
5004430 | 5004430 | 20240903112753_NZxNk | KR002C | 2024-09-09T12:02:41.833Z | 2024-09-12T12:19:02.095Z |
5004368 | 5004368 | 20240903112051_6kosH | KR002C | 2024-09-09T12:02:38.705Z | 2024-09-12T12:19:01.787Z |
4988123 | 4988123 | 20240901195859_82bXP | KR002C | 2024-09-07T12:06:52.913Z | 2024-09-10T12:19:12.775Z |
4988004 | 4988004 | 20240901193730_28ILm | KR002C | 2024-09-07T12:06:39.901Z | 2024-09-10T12:19:12.217Z |
4987974 | 4987974 | 20240901193035_qpUCr | KR002C | 2024-09-07T12:06:37.663Z | 2024-09-10T12:19:12.149Z |
4987860 | 4987860 | 20240901190752_ivxIT | KR002C | 2024-09-07T12:06:24.980Z | 2024-09-10T12:19:11.651Z |
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);