participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
952 rows where station_code = "KR001X" 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 |
---|---|---|---|---|---|
5124195 | 5124195 | 20240914160542_SWtM2 | KR001X | 2024-09-18T12:12:10.715Z | 2024-09-18T12:12:29.089Z |
5124137 | 5124137 | 20240914153619_tNBgj | KR001X | 2024-09-18T12:12:08.968Z | 2024-09-18T12:12:29.060Z |
5124129 | 5124129 | 20240914153136_EKYeW | KR001X | 2024-09-18T12:12:08.696Z | 2024-09-18T12:12:29.057Z |
5124098 | 5124098 | 20240914150535_iS34l | KR001X | 2024-09-18T12:12:07.370Z | 2024-09-18T12:12:29.041Z |
5098702 | 5098702 | 20240913190317_LdFx4 | KR001X | 2024-09-17T12:01:23.178Z | 2024-09-18T12:12:26.040Z |
5068998 | 5068998 | 20240910132022_DRJ0C | KR001X | 2024-09-14T12:19:23.605Z | 2024-09-18T12:15:26.972Z |
5062529 | 5062529 | 20240909173715_nSo7f | KR001X | 2024-09-14T12:12:31.271Z | 2024-09-18T12:15:11.437Z |
5062069 | 5062069 | 20240909164126_hWCCn | KR001X | 2024-09-14T12:11:47.567Z | 2024-09-18T12:15:10.359Z |
5061582 | 5061582 | 20240909152535_dAY13 | KR001X | 2024-09-14T12:10:58.987Z | 2024-09-18T12:15:09.686Z |
5061407 | 5061407 | 20240909150405_MtuHt | KR001X | 2024-09-14T12:10:47.859Z | 2024-09-18T12:15:09.087Z |
5061053 | 5061053 | 20240909135859_wVTdl | KR001X | 2024-09-14T12:10:10.531Z | 2024-09-18T12:15:07.939Z |
5059576 | 5059576 | 20240910180948_F2ghs | KR001X | 2024-09-14T12:06:29.847Z | 2024-09-18T12:14:32.511Z |
5059530 | 5059530 | 20240910180124_n5kAt | KR001X | 2024-09-14T12:06:19.270Z | 2024-09-18T12:14:32.266Z |
5059500 | 5059500 | 20240910175407_66V5Y | KR001X | 2024-09-14T12:06:14.203Z | 2024-09-18T12:14:32.225Z |
5058941 | 5058941 | 20240910170232_YzIXL | KR001X | 2024-09-14T12:04:54.707Z | 2024-09-18T12:14:30.798Z |
5058597 | 5058597 | 20240910162948_VgBuE | KR001X | 2024-09-14T12:04:06.378Z | 2024-09-18T12:14:29.767Z |
5058510 | 5058510 | 20240910161846_ml2rx | KR001X | 2024-09-14T12:03:49.588Z | 2024-09-18T12:14:29.510Z |
5058086 | 5058086 | 20240910154311_mWqta | KR001X | 2024-09-14T12:02:54.089Z | 2024-09-18T12:14:27.432Z |
5057937 | 5057937 | 20240910152836_8mFEJ | KR001X | 2024-09-14T12:02:27.118Z | 2024-09-18T12:14:26.680Z |
5057837 | 5057837 | 20240910151711_vWhYR | KR001X | 2024-09-14T12:02:12.597Z | 2024-09-18T12:14:26.240Z |
5057567 | 5057567 | 20240910145041_qV1aM | KR001X | 2024-09-14T12:01:27.202Z | 2024-09-18T12:14:23.833Z |
5057052 | 5057052 | 20240908120341_Nyymc | KR001X | 2024-09-13T12:17:44.280Z | 2024-09-16T12:21:28.720Z |
5056732 | 5056732 | 20240908111500_HSskc | KR001X | 2024-09-13T12:17:38.630Z | 2024-09-16T12:21:26.962Z |
5050624 | 5050624 | 20240907154850_2o2fB | KR001X | 2024-09-13T12:13:40.586Z | 2024-09-16T12:20:58.107Z |
5050305 | 5050305 | 20240907150623_D6kyl | KR001X | 2024-09-13T12:13:23.285Z | 2024-09-16T12:20:56.975Z |
5050297 | 5050297 | 20240907150513_gWevN | KR001X | 2024-09-13T12:13:22.962Z | 2024-09-16T12:20:56.970Z |
5050260 | 5050260 | 20240907150015_33wup | KR001X | 2024-09-13T12:13:21.148Z | 2024-09-16T12:20:56.828Z |
5045918 | 5045918 | 20240908200554_zU923 | KR001X | 2024-09-13T12:05:22.878Z | 2024-09-17T12:18:58.200Z |
5045908 | 5045908 | 20240908200335_srBqc | KR001X | 2024-09-13T12:05:21.611Z | 2024-09-17T12:18:58.169Z |
5045897 | 5045897 | 20240908195856_2rf9J | KR001X | 2024-09-13T12:05:20.122Z | 2024-09-17T12:18:58.086Z |
5045844 | 5045844 | 20240908194207_tJotG | KR001X | 2024-09-13T12:05:12.109Z | 2024-09-17T12:18:57.579Z |
5045750 | 5045750 | 20240908185050_yKYAB | KR001X | 2024-09-13T12:04:52.089Z | 2024-09-17T12:18:57.200Z |
5045718 | 5045718 | 20240908182654_KJOKd | KR001X | 2024-09-13T12:04:47.210Z | 2024-09-17T12:18:57.105Z |
5045690 | 5045690 | 20240908180822_RuftQ | KR001X | 2024-09-13T12:04:43.469Z | 2024-09-17T12:18:57.028Z |
5045547 | 5045547 | 20240908171914_wZWQB | KR001X | 2024-09-13T12:04:18.557Z | 2024-09-17T12:18:56.752Z |
5045240 | 5045240 | 20240908163919_DdLiO | KR001X | 2024-09-13T12:03:45.275Z | 2024-09-17T12:18:56.085Z |
5044720 | 5044720 | 20240908153252_15jqB | KR001X | 2024-09-13T12:02:50.630Z | 2024-09-17T12:18:54.894Z |
5044461 | 5044461 | 20240908150355_dpQQd | KR001X | 2024-09-13T12:02:13.634Z | 2024-09-17T12:18:54.446Z |
5044424 | 5044424 | 20240908145910_95ovB | KR001X | 2024-09-13T12:02:09.606Z | 2024-09-17T12:18:54.371Z |
5044093 | 5044093 | 20240908141231_QVYmx | KR001X | 2024-09-13T12:01:27.103Z | 2024-09-17T12:18:53.528Z |
5043346 | 5043346 | 20240907143702_3OXaA | KR001X | 2024-09-12T12:17:26.646Z | 2024-09-16T12:20:56.405Z |
5043240 | 5043240 | 20240907141305_eaKgl | KR001X | 2024-09-12T12:17:25.610Z | 2024-09-16T12:20:56.032Z |
5042971 | 5042971 | 20240907132318_cBEbs | KR001X | 2024-09-12T12:17:21.212Z | 2024-09-16T12:20:54.980Z |
5042857 | 5042857 | 20240907130100_WJx1E | KR001X | 2024-09-12T12:17:19.067Z | 2024-09-16T12:20:54.691Z |
5042722 | 5042722 | 20240907123133_Dalg8 | KR001X | 2024-09-12T12:17:17.213Z | 2024-09-16T12:20:53.986Z |
5018646 | 5018646 | 20240904192205_GqpuN | KR001X | 2024-09-10T12:11:05.988Z | 2024-09-13T12:19:48.393Z |
5018606 | 5018606 | 20240904190836_g0O29 | KR001X | 2024-09-10T12:10:58.562Z | 2024-09-13T12:19:48.301Z |
5018584 | 5018584 | 20240904185547_3uB3D | KR001X | 2024-09-10T12:10:54.902Z | 2024-09-13T12:19:48.181Z |
5018559 | 5018559 | 20240904184820_3tMf3 | KR001X | 2024-09-10T12:10:51.213Z | 2024-09-13T12:19:48.151Z |
5018516 | 5018516 | 20240904183041_3GNIk | KR001X | 2024-09-10T12:10:45.581Z | 2024-09-13T12:19:47.997Z |
5018503 | 5018503 | 20240904182823_ToQuS | KR001X | 2024-09-10T12:10:43.988Z | 2024-09-13T12:19:47.985Z |
5018398 | 5018398 | 20240904175603_Z54fZ | KR001X | 2024-09-10T12:10:33.920Z | 2024-09-13T12:19:47.753Z |
5018341 | 5018341 | 20240904174506_xZsLl | KR001X | 2024-09-10T12:10:29.356Z | 2024-09-13T12:19:47.609Z |
5018265 | 5018265 | 20240904173338_ICPR1 | KR001X | 2024-09-10T12:10:17.924Z | 2024-09-13T12:19:47.488Z |
5017911 | 5017911 | 20240904165257_7G7Zf | KR001X | 2024-09-10T12:09:44.661Z | 2024-09-13T12:19:47.129Z |
5017906 | 5017906 | 20240904165203_vo3b2 | KR001X | 2024-09-10T12:09:44.276Z | 2024-09-13T12:19:47.128Z |
5017725 | 5017725 | 20240904163630_eUN1b | KR001X | 2024-09-10T12:09:27.390Z | 2024-09-13T12:19:47.065Z |
5017596 | 5017596 | 20240904162323_vLK20 | KR001X | 2024-09-10T12:09:19.204Z | 2024-09-13T12:19:46.985Z |
5017590 | 5017590 | 20240904162250_yA8B0 | KR001X | 2024-09-10T12:09:18.831Z | 2024-09-13T12:19:46.983Z |
5017324 | 5017324 | 20240904155835_HRqbJ | KR001X | 2024-09-10T12:09:03.941Z | 2024-09-13T12:19:46.794Z |
5016835 | 5016835 | 20240904150121_nSx7m | KR001X | 2024-09-10T12:08:23.081Z | 2024-09-13T12:19:46.374Z |
5016777 | 5016777 | 20240904145135_EfWsA | KR001X | 2024-09-10T12:08:17.169Z | 2024-09-13T12:19:46.306Z |
5016630 | 5016630 | 20240904143335_9sP7f | KR001X | 2024-09-10T12:08:01.986Z | 2024-09-13T12:19:45.930Z |
5016317 | 5016317 | 20240904135951_gP7U3 | KR001X | 2024-09-10T12:07:41.135Z | 2024-09-13T12:19:45.488Z |
5016107 | 5016107 | 20240904133157_wAZY6 | KR001X | 2024-09-10T12:07:23.213Z | 2024-09-13T12:19:45.249Z |
5003086 | 5003086 | 20240904110915_30pdV | KR001X | 2024-09-09T12:01:19.453Z | 2024-09-13T12:19:43.343Z |
4996063 | 4996063 | 20240902183552_1tK9H | KR001X | 2024-09-08T12:04:20.116Z | 2024-09-11T12:20:50.857Z |
4994694 | 4994694 | 20240902145918_pREK3 | KR001X | 2024-09-08T12:02:51.753Z | 2024-09-11T12:20:37.397Z |
4994692 | 4994692 | 20240902145901_uUa3B | KR001X | 2024-09-08T12:02:51.595Z | 2024-09-11T12:20:37.290Z |
4994187 | 4994187 | 20240902124227_NWFpN | KR001X | 2024-09-08T12:02:18.584Z | 2024-09-11T12:20:31.432Z |
4994126 | 4994126 | 20240902122325_W3enF | KR001X | 2024-09-08T12:02:13.783Z | 2024-09-11T12:20:30.598Z |
4963260 | 4963260 | 20240811195221_XDl9l | KR001X | 2024-09-04T12:05:23.009Z | 2024-09-06T12:04:26.391Z |
4962753 | 4962753 | 20240811192100_N8duz | KR001X | 2024-09-04T12:04:50.274Z | 2024-09-06T12:04:01.166Z |
4962737 | 4962737 | 20240811192021_sgkdu | KR001X | 2024-09-04T12:04:49.529Z | 2024-09-06T12:04:00.567Z |
4962688 | 4962688 | 20240811191639_3itnt | KR001X | 2024-09-04T12:04:47.504Z | 2024-09-06T12:03:57.703Z |
4962682 | 4962682 | 20240811191624_SlYMY | KR001X | 2024-09-04T12:04:47.188Z | 2024-09-06T12:03:56.729Z |
4962633 | 4962633 | 20240811191343_dWqws | KR001X | 2024-09-04T12:04:44.731Z | 2024-09-06T12:03:54.422Z |
4962614 | 4962614 | 20240811191227_urrvq | KR001X | 2024-09-04T12:04:43.598Z | 2024-09-06T12:03:53.543Z |
4962505 | 4962505 | 20240811190358_RYqO0 | KR001X | 2024-09-04T12:04:36.305Z | 2024-09-06T12:03:49.092Z |
4962397 | 4962397 | 20240811185320_RKLpe | KR001X | 2024-09-04T12:04:28.713Z | 2024-09-06T12:03:44.803Z |
4962348 | 4962348 | 20240811185034_prVGn | KR001X | 2024-09-04T12:04:26.254Z | 2024-09-06T12:03:42.931Z |
4962320 | 4962320 | 20240811184858_ndB9J | KR001X | 2024-09-04T12:04:25.415Z | 2024-09-06T12:03:42.060Z |
4962211 | 4962211 | 20240811184153_cEfEn | KR001X | 2024-09-04T12:04:21.239Z | 2024-09-06T12:03:33.683Z |
4961850 | 4961850 | 20240811180955_S3d3I | KR001X | 2024-09-04T12:03:58.602Z | 2024-09-06T12:03:17.243Z |
4961741 | 4961741 | 20240811180029_wOB0H | KR001X | 2024-09-04T12:03:53.101Z | 2024-09-06T12:03:12.536Z |
4961595 | 4961595 | 20240811175128_yCXYD | KR001X | 2024-09-04T12:03:46.811Z | 2024-09-06T12:03:07.091Z |
4961411 | 4961411 | 20240811173922_FOVpJ | KR001X | 2024-09-04T12:03:36.072Z | 2024-09-06T12:02:56.223Z |
4961304 | 4961304 | 20240811173017_JSfQN | KR001X | 2024-09-04T12:03:27.729Z | 2024-09-06T12:02:51.584Z |
4961163 | 4961163 | 20240811172043_ZU0I7 | KR001X | 2024-09-04T12:03:20.888Z | 2024-09-06T12:02:45.967Z |
4960565 | 4960565 | 20240811163428_ILOnF | KR001X | 2024-09-04T12:02:42.937Z | 2024-09-06T12:02:16.242Z |
4960383 | 4960383 | 20240811162241_nwXp2 | KR001X | 2024-09-04T12:02:29.780Z | 2024-09-06T12:02:06.822Z |
4959926 | 4959926 | 20240811154920_lkNkP | KR001X | 2024-09-04T12:02:03.007Z | 2024-09-06T12:01:43.650Z |
4959898 | 4959898 | 20240811154748_rL8F2 | KR001X | 2024-09-04T12:02:01.909Z | 2024-09-06T12:01:42.406Z |
4959817 | 4959817 | 20240811154020_wT3ST | KR001X | 2024-09-04T12:01:57.455Z | 2024-09-06T12:01:38.889Z |
4959700 | 4959700 | 20240811152944_WWlRY | KR001X | 2024-09-04T12:01:49.705Z | 2024-09-06T12:01:32.438Z |
4959529 | 4959529 | 20240811151449_6KO7I | KR001X | 2024-09-04T12:01:39.775Z | 2024-09-06T12:01:21.330Z |
4959435 | 4959435 | 20240811150454_g1hNQ | KR001X | 2024-09-04T12:01:33.818Z | 2024-09-06T12:01:16.594Z |
4959414 | 4959414 | 20240811150304_sDJ2N | KR001X | 2024-09-04T12:01:32.665Z | 2024-09-06T12:01:15.724Z |
4959376 | 4959376 | 20240811145831_4lI3e | KR001X | 2024-09-04T12:01:29.869Z | 2024-09-06T12:01:13.700Z |
4959367 | 4959367 | 20240811145759_Gsa6n | KR001X | 2024-09-04T12:01:29.432Z | 2024-09-06T12:01:13.410Z |
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);