participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,558 rows where station_code = "KR003M" 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 |
---|---|---|---|---|---|
5561032 | 5561032 | 20241120173116_3e7zk | KR003M | 2024-11-21T14:10:23.102Z | 2024-11-21T14:10:23.102Z |
5561028 | 5561028 | 20241120171415_lqKEh | KR003M | 2024-11-21T14:10:22.004Z | 2024-11-21T14:10:22.004Z |
5560827 | 5560827 | 20241120143631_fK4Kz | KR003M | 2024-11-21T14:09:49.120Z | 2024-11-21T14:09:49.120Z |
5560678 | 5560678 | 20241120135510_mNlsn | KR003M | 2024-11-21T14:09:24.968Z | 2024-11-21T14:09:24.968Z |
5560487 | 5560487 | 20241120125806_4sk3b | KR003M | 2024-11-21T14:08:56.849Z | 2024-11-21T14:08:56.849Z |
5560463 | 5560463 | 20241120125408_wreiN | KR003M | 2024-11-21T14:08:54.700Z | 2024-11-21T14:08:54.700Z |
5560054 | 5560054 | 20241120115150_jtxvg | KR003M | 2024-11-21T14:07:56.813Z | 2024-11-21T14:07:56.813Z |
5559977 | 5559977 | 20241120114032_blkRz | KR003M | 2024-11-21T14:07:47.597Z | 2024-11-21T14:07:47.597Z |
5559727 | 5559727 | 20241120110838_7xe45 | KR003M | 2024-11-21T14:07:04.120Z | 2024-11-21T14:07:04.120Z |
5556181 | 5556181 | 20241119202833_KAHqT | KR003M | 2024-11-20T14:07:33.843Z | 2024-11-21T14:18:53.506Z |
5556170 | 5556170 | 20241119202650_mgTv5 | KR003M | 2024-11-20T14:07:32.185Z | 2024-11-21T14:18:53.503Z |
5556147 | 5556147 | 20241119202202_uWXO0 | KR003M | 2024-11-20T14:07:28.211Z | 2024-11-21T14:18:53.495Z |
5556056 | 5556056 | 20241119193300_pqt9m | KR003M | 2024-11-20T14:07:15.823Z | 2024-11-21T14:18:53.458Z |
5555991 | 5555991 | 20241119185209_qlRjF | KR003M | 2024-11-20T14:07:11.406Z | 2024-11-21T14:18:53.424Z |
5555963 | 5555963 | 20241119182943_vK6Kz | KR003M | 2024-11-20T14:07:08.892Z | 2024-11-21T14:18:53.412Z |
5555886 | 5555886 | 20241119172031_hVotQ | KR003M | 2024-11-20T14:07:00.754Z | 2024-11-21T14:18:53.373Z |
5555832 | 5555832 | 20241119165835_KDbjH | KR003M | 2024-11-20T14:06:51.018Z | 2024-11-21T14:18:53.362Z |
5555825 | 5555825 | 20241119165519_ChP8y | KR003M | 2024-11-20T14:06:47.700Z | 2024-11-21T14:18:53.360Z |
5555823 | 5555823 | 20241119165447_BKUgP | KR003M | 2024-11-20T14:06:46.683Z | 2024-11-21T14:18:53.359Z |
5555799 | 5555799 | 20241119164041_gv0dB | KR003M | 2024-11-20T14:06:42.745Z | 2024-11-21T14:18:53.355Z |
5555753 | 5555753 | 20241119153827_2G5Dr | KR003M | 2024-11-20T14:06:32.276Z | 2024-11-21T14:18:53.342Z |
5555735 | 5555735 | 20241119151846_XwdWR | KR003M | 2024-11-20T14:06:30.231Z | 2024-11-21T14:18:53.338Z |
5555160 | 5555160 | 20241119115758_mmYTO | KR003M | 2024-11-20T14:04:34.940Z | 2024-11-21T14:18:53.214Z |
5555142 | 5555142 | 20241119115551_q9JCB | KR003M | 2024-11-20T14:04:32.960Z | 2024-11-21T14:18:53.211Z |
5552285 | 5552285 | 20241118201432_klJFY | KR003M | 2024-11-19T14:06:14.714Z | 2024-11-21T14:20:20.040Z |
5552260 | 5552260 | 20241118200056_gr23J | KR003M | 2024-11-19T14:06:11.664Z | 2024-11-21T14:20:19.446Z |
5552249 | 5552249 | 20241118194833_rvVc1 | KR003M | 2024-11-19T14:06:10.295Z | 2024-11-21T14:20:19.158Z |
5552241 | 5552241 | 20241118193645_2Xk5J | KR003M | 2024-11-19T14:06:09.653Z | 2024-11-21T14:20:19.010Z |
5552131 | 5552131 | 20241118182846_1ePZh | KR003M | 2024-11-19T14:06:02.359Z | 2024-11-21T14:20:16.224Z |
5552122 | 5552122 | 20241118182732_AlRjP | KR003M | 2024-11-19T14:06:01.979Z | 2024-11-21T14:20:16.045Z |
5552114 | 5552114 | 20241118182408_bnYqW | KR003M | 2024-11-19T14:06:01.431Z | 2024-11-21T14:20:15.903Z |
5552109 | 5552109 | 20241118182232_malcB | KR003M | 2024-11-19T14:06:01.126Z | 2024-11-21T14:20:15.817Z |
5552094 | 5552094 | 20241118181108_oSO7G | KR003M | 2024-11-19T14:06:00.625Z | 2024-11-21T14:20:15.081Z |
5552064 | 5552064 | 20241118174321_JEBy3 | KR003M | 2024-11-19T14:05:58.798Z | 2024-11-21T14:20:13.450Z |
5552011 | 5552011 | 20241118170813_Hw3dG | KR003M | 2024-11-19T14:05:54.029Z | 2024-11-21T14:20:10.266Z |
5551968 | 5551968 | 20241118162417_79pLy | KR003M | 2024-11-19T14:05:51.041Z | 2024-11-21T14:20:08.900Z |
5550272 | 5550272 | 20241118095745_o5VAo | KR003M | 2024-11-19T14:02:01.480Z | 2024-11-21T14:19:12.276Z |
5547937 | 5547937 | 20241117203919_o1Gj4 | KR003M | 2024-11-18T14:06:50.752Z | 2024-11-21T14:21:57.251Z |
5547817 | 5547817 | 20241117195125_NlVPs | KR003M | 2024-11-18T14:06:40.872Z | 2024-11-21T14:21:53.614Z |
5547795 | 5547795 | 20241117194848_pJFKA | KR003M | 2024-11-18T14:06:33.539Z | 2024-11-21T14:21:53.159Z |
5544053 | 5544053 | 20241113193733_VfoFm | KR003M | 2024-11-16T14:09:57.400Z | 2024-11-21T14:25:09.294Z |
5544045 | 5544045 | 20241113183808_zo1Tn | KR003M | 2024-11-16T14:09:52.410Z | 2024-11-21T14:25:08.593Z |
5534831 | 5534831 | 20241113195902_EukKc | KR003M | 2024-11-14T14:05:32.497Z | 2024-11-21T14:25:10.170Z |
5534807 | 5534807 | 20241113193733_Yqneq | KR003M | 2024-11-14T14:05:29.500Z | 2024-11-15T14:08:54.243Z |
5534780 | 5534780 | 20241113191251_Bac3T | KR003M | 2024-11-14T14:05:22.586Z | 2024-11-21T14:25:08.893Z |
5526710 | 5526710 | 20241112100507_6x0U3 | KR003M | 2024-11-13T14:03:59.284Z | 2024-11-21T14:25:37.392Z |
5524887 | 5524887 | 20241109163313_1BjPi | KR003M | 2024-11-12T14:19:38.424Z | 2024-11-18T14:26:21.521Z |
5522639 | 5522639 | 20241110204957_4ygt7 | KR003M | 2024-11-12T14:13:50.005Z | 2024-11-19T14:22:04.871Z |
5522602 | 5522602 | 20241110204131_DC6xf | KR003M | 2024-11-12T14:13:43.846Z | 2024-11-19T14:22:04.543Z |
5522568 | 5522568 | 20241110203247_CxGgy | KR003M | 2024-11-12T14:13:37.232Z | 2024-11-19T14:22:04.027Z |
5522525 | 5522525 | 20241110201917_TVakx | KR003M | 2024-11-12T14:13:28.910Z | 2024-11-19T14:22:03.461Z |
5522468 | 5522468 | 20241110200710_WUuCB | KR003M | 2024-11-12T14:13:18.775Z | 2024-11-19T14:22:02.571Z |
5522295 | 5522295 | 20241110193921_HDTJ9 | KR003M | 2024-11-12T14:13:03.033Z | 2024-11-19T14:21:59.925Z |
5522212 | 5522212 | 20241110192609_sr7zR | KR003M | 2024-11-12T14:12:58.138Z | 2024-11-19T14:21:59.438Z |
5522153 | 5522153 | 20241110191416_0hwjq | KR003M | 2024-11-12T14:12:54.047Z | 2024-11-19T14:21:58.799Z |
5522080 | 5522080 | 20241110190320_3b5EF | KR003M | 2024-11-12T14:12:43.010Z | 2024-11-19T14:21:57.577Z |
5521991 | 5521991 | 20241110184418_9tGo3 | KR003M | 2024-11-12T14:12:23.059Z | 2024-11-19T14:21:56.671Z |
5521930 | 5521930 | 20241110183635_oQec3 | KR003M | 2024-11-12T14:12:11.837Z | 2024-11-19T14:21:56.212Z |
5521865 | 5521865 | 20241110182659_N551e | KR003M | 2024-11-12T14:12:04.944Z | 2024-11-19T14:21:55.835Z |
5521859 | 5521859 | 20241110182344_Q9uS4 | KR003M | 2024-11-12T14:12:04.632Z | 2024-11-19T14:21:55.815Z |
5521679 | 5521679 | 20241110175535_7sY98 | KR003M | 2024-11-12T14:11:50.122Z | 2024-11-19T14:21:54.226Z |
5521547 | 5521547 | 20241110173043_wv99t | KR003M | 2024-11-12T14:11:33.226Z | 2024-11-19T14:21:53.453Z |
5521528 | 5521528 | 20241110172626_4P00h | KR003M | 2024-11-12T14:11:28.178Z | 2024-11-19T14:21:53.290Z |
5521233 | 5521233 | 20241110163142_GMZlg | KR003M | 2024-11-12T14:10:39.290Z | 2024-11-19T14:21:50.558Z |
5521178 | 5521178 | 20241110161915_oZ2qY | KR003M | 2024-11-12T14:10:35.279Z | 2024-11-19T14:21:49.877Z |
5521082 | 5521082 | 20241110155636_M8WX7 | KR003M | 2024-11-12T14:10:25.472Z | 2024-11-19T14:21:48.227Z |
5521053 | 5521053 | 20241110155142_gLabQ | KR003M | 2024-11-12T14:10:19.572Z | 2024-11-19T14:21:47.996Z |
5520949 | 5520949 | 20241110153040_wnZok | KR003M | 2024-11-12T14:09:51.972Z | 2024-11-19T14:21:46.363Z |
5520942 | 5520942 | 20241110152941_q8mw3 | KR003M | 2024-11-12T14:09:51.457Z | 2024-11-19T14:21:46.325Z |
5508309 | 5508309 | 20241109160236_0wLCs | KR003M | 2024-11-10T14:07:26.184Z | 2024-11-18T14:26:21.084Z |
5508250 | 5508250 | 20241109152916_HPm60 | KR003M | 2024-11-10T14:07:18.938Z | 2024-11-18T14:26:20.379Z |
5508185 | 5508185 | 20241109150058_6gE2Y | KR003M | 2024-11-10T14:07:13.233Z | 2024-11-18T14:26:19.793Z |
5508180 | 5508180 | 20241109150058_v9W41 | KR003M | 2024-11-10T14:07:13.060Z | 2024-11-18T14:26:19.775Z |
5508144 | 5508144 | 20241109144359_xkwSW | KR003M | 2024-11-10T14:07:09.036Z | 2024-11-18T14:26:19.302Z |
5508126 | 5508126 | 20241109143708_cd1cr | KR003M | 2024-11-10T14:07:06.657Z | 2024-11-18T14:26:19.074Z |
5508045 | 5508045 | 20241109134856_XGU1o | KR003M | 2024-11-10T14:06:43.247Z | 2024-11-18T14:26:18.078Z |
5508041 | 5508041 | 20241109134813_c9eof | KR003M | 2024-11-10T14:06:42.246Z | 2024-11-18T14:26:18.077Z |
5507999 | 5507999 | 20241109133551_2hgJ5 | KR003M | 2024-11-10T14:06:37.813Z | 2024-11-18T14:26:17.919Z |
5507992 | 5507992 | 20241109133526_6otzv | KR003M | 2024-11-10T14:06:37.461Z | 2024-11-18T14:26:17.894Z |
5503004 | 5503004 | 20241107202640_DRIJa | KR003M | 2024-11-09T14:12:18.297Z | 2024-11-16T14:28:01.815Z |
5502676 | 5502676 | 20241107193120_3G9mB | KR003M | 2024-11-09T14:11:57.588Z | 2024-11-16T14:27:58.357Z |
5502408 | 5502408 | 20241107182508_4HLuK | KR003M | 2024-11-09T14:11:16.346Z | 2024-11-16T14:27:55.343Z |
5502305 | 5502305 | 20241107175935_Mbiu3 | KR003M | 2024-11-09T14:11:08.823Z | 2024-11-16T14:27:53.140Z |
5502297 | 5502297 | 20241107175913_WApUZ | KR003M | 2024-11-09T14:11:08.502Z | 2024-11-16T14:27:52.940Z |
5502283 | 5502283 | 20241107175600_BzY5d | KR003M | 2024-11-09T14:11:07.715Z | 2024-11-16T14:27:52.669Z |
5502094 | 5502094 | 20241107172055_H4J6a | KR003M | 2024-11-09T14:10:56.467Z | 2024-11-16T14:27:50.480Z |
5502006 | 5502006 | 20241107165146_YhPJx | KR003M | 2024-11-09T14:10:49.499Z | 2024-11-16T14:27:49.433Z |
5501946 | 5501946 | 20241107164353_0zsW8 | KR003M | 2024-11-09T14:10:47.129Z | 2024-11-16T14:27:49.244Z |
5501848 | 5501848 | 20241107161305_G0eSd | KR003M | 2024-11-09T14:10:32.909Z | 2024-11-16T14:27:48.707Z |
5501834 | 5501834 | 20241107161112_UgO1K | KR003M | 2024-11-09T14:10:31.761Z | 2024-11-16T14:27:48.677Z |
5501766 | 5501766 | 20241107154044_cVukD | KR003M | 2024-11-09T14:10:19.988Z | 2024-11-16T14:27:48.014Z |
5501664 | 5501664 | 20241107150553_vziMw | KR003M | 2024-11-09T14:10:10.422Z | 2024-11-16T14:27:44.465Z |
5501623 | 5501623 | 20241107145042_0Fxbi | KR003M | 2024-11-09T14:10:07.819Z | 2024-11-16T14:27:43.651Z |
5501610 | 5501610 | 20241107144421_brgUc | KR003M | 2024-11-09T14:10:07.049Z | 2024-11-16T14:27:43.573Z |
5501603 | 5501603 | 20241107144150_p4mj7 | KR003M | 2024-11-09T14:10:06.422Z | 2024-11-16T14:27:43.425Z |
5501599 | 5501599 | 20241107143741_4q5sU | KR003M | 2024-11-09T14:10:05.857Z | 2024-11-16T14:27:43.254Z |
5501372 | 5501372 | 20241107124006_CW2Ey | KR003M | 2024-11-09T14:09:17.926Z | 2024-11-16T14:27:36.332Z |
5501300 | 5501300 | 20241107115355_kVGWB | KR003M | 2024-11-09T14:09:04.575Z | 2024-11-16T14:27:33.724Z |
5501259 | 5501259 | 20241107113045_nFjDM | KR003M | 2024-11-09T14:09:00.285Z | 2024-11-16T14:27:33.243Z |
5499769 | 5499769 | 20241108131943_6ok2Q | KR003M | 2024-11-09T14:04:55.845Z | 2024-11-17T14:23:15.896Z |
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);