participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,186 rows where station_code = "KR0037" 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 |
---|---|---|---|---|---|
5569602 | 5569602 | 20241121175221_XfQ03 | KR0037 | 2024-11-22T14:11:22.087Z | 2024-11-22T14:11:22.087Z |
5569595 | 5569595 | 20241121173724_RBYLv | KR0037 | 2024-11-22T14:11:21.308Z | 2024-11-22T14:11:21.308Z |
5569571 | 5569571 | 20241121165420_MniJc | KR0037 | 2024-11-22T14:11:17.912Z | 2024-11-22T14:11:17.912Z |
5569552 | 5569552 | 20241121162810_hwRQp | KR0037 | 2024-11-22T14:11:07.680Z | 2024-11-22T14:11:07.680Z |
5569540 | 5569540 | 20241121160832_MP9Wb | KR0037 | 2024-11-22T14:11:04.203Z | 2024-11-22T14:11:04.203Z |
5560677 | 5560677 | 20241120135510_mNlsn | KR0037 | 2024-11-21T14:09:24.968Z | 2024-11-22T14:19:21.711Z |
5555879 | 5555879 | 20241119171750_Mpglu | KR0037 | 2024-11-20T14:07:00.009Z | 2024-11-22T14:20:16.474Z |
5555845 | 5555845 | 20241119170026_0Dffc | KR0037 | 2024-11-20T14:06:56.239Z | 2024-11-22T14:20:15.972Z |
5551967 | 5551967 | 20241118162417_79pLy | KR0037 | 2024-11-19T14:05:51.041Z | 2024-11-22T14:22:13.314Z |
5551865 | 5551865 | 20241118152818_Gcb75 | KR0037 | 2024-11-19T14:05:44.486Z | 2024-11-22T14:22:12.791Z |
5551750 | 5551750 | 20241118150443_AyOih | KR0037 | 2024-11-19T14:05:23.007Z | 2024-11-22T14:22:12.360Z |
5551358 | 5551358 | 20241118131305_HLSH5 | KR0037 | 2024-11-19T14:04:35.108Z | 2024-11-22T14:22:10.332Z |
5546167 | 5546167 | 20241117093456_LaF33 | KR0037 | 2024-11-18T14:02:21.651Z | 2024-11-22T14:22:29.827Z |
5536530 | 5536530 | 20241112182529_uAsfc | KR0037 | 2024-11-14T14:10:10.074Z | 2024-11-21T14:26:01.953Z |
5534834 | 5534834 | 20241113201009_UqsJO | KR0037 | 2024-11-14T14:05:32.661Z | 2024-11-22T14:24:17.089Z |
5525295 | 5525295 | 20241106162837_3qDA7 | KR0037 | 2024-11-12T14:25:41.884Z | 2024-11-15T14:24:40.821Z |
5524886 | 5524886 | 20241109163313_1BjPi | KR0037 | 2024-11-12T14:19:38.424Z | 2024-11-18T14:26:21.520Z |
5521864 | 5521864 | 20241110182659_N551e | KR0037 | 2024-11-12T14:12:04.944Z | 2024-11-19T14:21:55.835Z |
5521750 | 5521750 | 20241110181103_TKQQt | KR0037 | 2024-11-12T14:11:55.914Z | 2024-11-19T14:21:54.742Z |
5521710 | 5521710 | 20241110180602_A5246 | KR0037 | 2024-11-12T14:11:52.519Z | 2024-11-19T14:21:54.485Z |
5521328 | 5521328 | 20241110165142_Nuks4 | KR0037 | 2024-11-12T14:10:49.643Z | 2024-11-19T14:21:51.842Z |
5521320 | 5521320 | 20241110165025_YPuXL | KR0037 | 2024-11-12T14:10:48.012Z | 2024-11-19T14:21:51.793Z |
5521177 | 5521177 | 20241110161915_oZ2qY | KR0037 | 2024-11-12T14:10:35.279Z | 2024-11-19T14:21:49.877Z |
5521167 | 5521167 | 20241110161827_Geuya | KR0037 | 2024-11-12T14:10:34.672Z | 2024-11-19T14:21:49.791Z |
5521098 | 5521098 | 20241110160212_TPOrC | KR0037 | 2024-11-12T14:10:27.635Z | 2024-11-19T14:21:48.440Z |
5508308 | 5508308 | 20241109160236_0wLCs | KR0037 | 2024-11-10T14:07:26.184Z | 2024-11-18T14:26:21.084Z |
5508271 | 5508271 | 20241109154348_9CSfZ | KR0037 | 2024-11-10T14:07:21.684Z | 2024-11-18T14:26:20.649Z |
5508184 | 5508184 | 20241109150058_6gE2Y | KR0037 | 2024-11-10T14:07:13.233Z | 2024-11-18T14:26:19.793Z |
5508179 | 5508179 | 20241109150058_v9W41 | KR0037 | 2024-11-10T14:07:13.060Z | 2024-11-18T14:26:19.775Z |
5508143 | 5508143 | 20241109144359_xkwSW | KR0037 | 2024-11-10T14:07:09.036Z | 2024-11-18T14:26:19.302Z |
5508027 | 5508027 | 20241109134420_S5FZy | KR0037 | 2024-11-10T14:06:41.343Z | 2024-11-18T14:26:18.063Z |
5501925 | 5501925 | 20241107163949_5i3B4 | KR0037 | 2024-11-09T14:10:45.856Z | 2024-11-16T14:27:49.100Z |
5501907 | 5501907 | 20241107163625_OLt9F | KR0037 | 2024-11-09T14:10:43.811Z | 2024-11-16T14:27:48.955Z |
5501864 | 5501864 | 20241107161928_KFRC4 | KR0037 | 2024-11-09T14:10:36.807Z | 2024-11-16T14:27:48.818Z |
5501833 | 5501833 | 20241107161112_UgO1K | KR0037 | 2024-11-09T14:10:31.761Z | 2024-11-16T14:27:48.677Z |
5501809 | 5501809 | 20241107155844_P5AQ7 | KR0037 | 2024-11-09T14:10:27.048Z | 2024-11-16T14:27:48.398Z |
5501780 | 5501780 | 20241107154329_LiB79 | KR0037 | 2024-11-09T14:10:22.433Z | 2024-11-16T14:27:48.255Z |
5501775 | 5501775 | 20241107154228_qb6F0 | KR0037 | 2024-11-09T14:10:21.679Z | 2024-11-16T14:27:48.185Z |
5501765 | 5501765 | 20241107154044_cVukD | KR0037 | 2024-11-09T14:10:19.988Z | 2024-11-16T14:27:48.013Z |
5501692 | 5501692 | 20241107151438_F1YnS | KR0037 | 2024-11-09T14:10:13.108Z | 2024-11-16T14:27:45.395Z |
5501568 | 5501568 | 20241107142449_3Aooh | KR0037 | 2024-11-09T14:10:02.170Z | 2024-11-16T14:27:42.774Z |
5501565 | 5501565 | 20241107142008_R3NHQ | KR0037 | 2024-11-09T14:10:01.160Z | 2024-11-16T14:27:42.616Z |
5501030 | 5501030 | 20241108190352_1Yl5R | KR0037 | 2024-11-09T14:07:34.965Z | 2024-11-17T14:23:32.152Z |
5500937 | 5500937 | 20241108182347_An67d | KR0037 | 2024-11-09T14:07:28.886Z | 2024-11-17T14:23:31.365Z |
5500894 | 5500894 | 20241108181343_JxXoI | KR0037 | 2024-11-09T14:07:26.457Z | 2024-11-17T14:23:31.079Z |
5500861 | 5500861 | 20241108180231_fpPmr | KR0037 | 2024-11-09T14:07:20.573Z | 2024-11-17T14:23:30.401Z |
5500746 | 5500746 | 20241108171543_uZ3pi | KR0037 | 2024-11-09T14:07:01.083Z | 2024-11-17T14:23:27.391Z |
5500710 | 5500710 | 20241108170519_s9Y7t | KR0037 | 2024-11-09T14:06:57.228Z | 2024-11-17T14:23:26.737Z |
5500647 | 5500647 | 20241108164248_Fz2kI | KR0037 | 2024-11-09T14:06:50.908Z | 2024-11-17T14:23:25.924Z |
5500638 | 5500638 | 20241108164117_SRxmS | KR0037 | 2024-11-09T14:06:50.372Z | 2024-11-17T14:23:25.870Z |
5500637 | 5500637 | 20241108164030_OOijD | KR0037 | 2024-11-09T14:06:50.202Z | 2024-11-17T14:23:25.781Z |
5500628 | 5500628 | 20241108162947_NBydS | KR0037 | 2024-11-09T14:06:49.296Z | 2024-11-17T14:23:24.721Z |
5500534 | 5500534 | 20241108160139_b2g3m | KR0037 | 2024-11-09T14:06:27.043Z | 2024-11-17T14:23:23.416Z |
5500377 | 5500377 | 20241108153033_1Aoep | KR0037 | 2024-11-09T14:06:11.503Z | 2024-11-17T14:23:22.360Z |
5500289 | 5500289 | 20241108151241_e3qSO | KR0037 | 2024-11-09T14:06:03.946Z | 2024-11-17T14:23:21.071Z |
5500251 | 5500251 | 20241108150835_vVkHT | KR0037 | 2024-11-09T14:06:01.223Z | 2024-11-17T14:23:20.419Z |
5499840 | 5499840 | 20241108134614_H3pi2 | KR0037 | 2024-11-09T14:05:03.223Z | 2024-11-17T14:23:16.397Z |
5494682 | 5494682 | 20241106164943_5xfTZ | KR0037 | 2024-11-08T14:08:20.278Z | 2024-11-15T14:24:41.189Z |
5494657 | 5494657 | 20241106163859_ubruo | KR0037 | 2024-11-08T14:08:15.323Z | 2024-11-15T14:24:40.923Z |
5494645 | 5494645 | 20241106163522_egktw | KR0037 | 2024-11-08T14:08:13.070Z | 2024-11-15T14:24:40.852Z |
5494619 | 5494619 | 20241106162130_R1nSO | KR0037 | 2024-11-08T14:08:03.670Z | 2024-11-15T14:24:40.506Z |
5488985 | 5488985 | 20241105173051_ZVOl1 | KR0037 | 2024-11-07T14:11:08.070Z | 2024-11-14T14:23:09.185Z |
5488858 | 5488858 | 20241105170701_t2FPP | KR0037 | 2024-11-07T14:10:43.556Z | 2024-11-14T14:23:08.117Z |
5488805 | 5488805 | 20241105165558_GsOfi | KR0037 | 2024-11-07T14:10:38.216Z | 2024-11-14T14:23:07.771Z |
5488750 | 5488750 | 20241105164525_phCoX | KR0037 | 2024-11-07T14:10:34.248Z | 2024-11-14T14:23:07.441Z |
5488691 | 5488691 | 20241105162327_Lq60Y | KR0037 | 2024-11-07T14:10:29.106Z | 2024-11-14T14:23:07.180Z |
5488619 | 5488619 | 20241105155844_PAi33 | KR0037 | 2024-11-07T14:10:22.611Z | 2024-11-14T14:23:06.809Z |
5488616 | 5488616 | 20241105155749_ch33t | KR0037 | 2024-11-07T14:10:22.280Z | 2024-11-14T14:23:06.803Z |
5488600 | 5488600 | 20241105155505_2DVsD | KR0037 | 2024-11-07T14:10:21.686Z | 2024-11-14T14:23:06.772Z |
5488581 | 5488581 | 20241105154901_Bk3Gz | KR0037 | 2024-11-07T14:10:20.865Z | 2024-11-14T14:23:06.747Z |
5488469 | 5488469 | 20241105150604_zVQ6W | KR0037 | 2024-11-07T14:09:57.300Z | 2024-11-14T14:23:05.718Z |
5488466 | 5488466 | 20241105150504_1dLij | KR0037 | 2024-11-07T14:09:56.975Z | 2024-11-14T14:23:05.714Z |
5488395 | 5488395 | 20241105142549_Xb8pv | KR0037 | 2024-11-07T14:09:48.946Z | 2024-11-14T14:23:05.370Z |
5487630 | 5487630 | 20241106173744_s3Q1V | KR0037 | 2024-11-07T14:06:21.184Z | 2024-11-15T14:24:43.757Z |
5487607 | 5487607 | 20241106173024_ohD2B | KR0037 | 2024-11-07T14:06:18.467Z | 2024-11-15T14:24:43.412Z |
5487557 | 5487557 | 20241106171025_V8P8x | KR0037 | 2024-11-07T14:06:13.060Z | 2024-11-15T14:24:42.407Z |
5487521 | 5487521 | 20241106165142_rMa82 | KR0037 | 2024-11-07T14:06:08.485Z | 2024-11-15T14:24:41.328Z |
5487479 | 5487479 | 20241106163501_jov6T | KR0037 | 2024-11-07T14:05:59.661Z | 2024-11-15T14:24:40.851Z |
5487450 | 5487450 | 20241106161844_32INy | KR0037 | 2024-11-07T14:05:49.416Z | 2024-11-15T14:24:40.505Z |
5487443 | 5487443 | 20241106161623_iyEXV | KR0037 | 2024-11-07T14:05:47.880Z | 2024-11-15T14:24:40.484Z |
5487226 | 5487226 | 20241106151811_oHOXf | KR0037 | 2024-11-07T14:05:13.491Z | 2024-11-15T14:24:38.240Z |
5487215 | 5487215 | 20241106151641_wTYkQ | KR0037 | 2024-11-07T14:05:11.799Z | 2024-11-15T14:24:38.193Z |
5487185 | 5487185 | 20241106151027_rkkp7 | KR0037 | 2024-11-07T14:05:07.831Z | 2024-11-15T14:24:38.017Z |
5487158 | 5487158 | 20241106145954_eF1os | KR0037 | 2024-11-07T14:05:03.689Z | 2024-11-15T14:24:37.596Z |
5486997 | 5486997 | 20241106141723_FJw6I | KR0037 | 2024-11-07T14:04:34.555Z | 2024-11-15T14:24:36.479Z |
5475431 | 5475431 | 20241103200518_NbiWP | KR0037 | 2024-11-05T14:13:31.864Z | 2024-11-12T14:27:58.556Z |
5473571 | 5473571 | 20241103143335_7k2OF | KR0037 | 2024-11-05T14:09:07.529Z | 2024-11-12T14:27:49.714Z |
5473491 | 5473491 | 20241103142331_V2igN | KR0037 | 2024-11-05T14:08:59.845Z | 2024-11-12T14:27:49.655Z |
5466813 | 5466813 | 20241102190247_7blr9 | KR0037 | 2024-11-04T14:09:53.210Z | 2024-11-11T14:22:43.580Z |
5466740 | 5466740 | 20241102184400_scpz9 | KR0037 | 2024-11-04T14:09:40.141Z | 2024-11-11T14:22:42.953Z |
5466608 | 5466608 | 20241102181632_KfxO2 | KR0037 | 2024-11-04T14:09:24.883Z | 2024-11-11T14:22:41.623Z |
5466479 | 5466479 | 20241102174929_tQR2W | KR0037 | 2024-11-04T14:08:57.363Z | 2024-11-11T14:22:41.068Z |
5466369 | 5466369 | 20241102172420_buOuI | KR0037 | 2024-11-04T14:08:42.673Z | 2024-11-11T14:22:40.656Z |
5466355 | 5466355 | 20241102172130_BXgvu | KR0037 | 2024-11-04T14:08:41.403Z | 2024-11-11T14:22:40.618Z |
5466295 | 5466295 | 20241102170549_E9Gv5 | KR0037 | 2024-11-04T14:08:33.886Z | 2024-11-11T14:22:40.130Z |
5466250 | 5466250 | 20241102165736_az34H | KR0037 | 2024-11-04T14:08:26.541Z | 2024-11-11T14:22:40.035Z |
5466223 | 5466223 | 20241102165338_u12zA | KR0037 | 2024-11-04T14:08:17.965Z | 2024-11-11T14:22:39.920Z |
5466141 | 5466141 | 20241102163347_7wQaF | KR0037 | 2024-11-04T14:08:05.348Z | 2024-11-11T14:22:39.256Z |
5466033 | 5466033 | 20241102160451_XNAbN | KR0037 | 2024-11-04T14:07:54.369Z | 2024-11-11T14:22:38.605Z |
5465913 | 5465913 | 20241102151555_QhBZb | KR0037 | 2024-11-04T14:07:22.621Z | 2024-11-11T14:22:36.281Z |
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);