컬럼 구조
id varchar(50)
ship_manifest_name varchar(200)
arrival_age varchar(20)
age_display varchar(50)
marital_status varchar(50)
departure_residence varchar(200)
departure_date varchar(50)
ship_name varchar(100)
tags_combined text
korean_name varchar(100)
estimated_korean_name varchar(100)
hometown varchar(200)
last_update_time datetime
tag_1st_gen varchar(50)
relation_memo text
cemetery_name varchar(200)
image_additional_record varchar(500)
tag_2nd_gen varchar(50)
image_tombstone varchar(500)
image_family_photo varchar(500)
image_portrait varchar(500)
tag_3rd_gen varchar(50)
relation_history text
cemetery_joint_burial varchar(200)
tombstone_name varchar(200)
death_date varchar(50)
image_ship varchar(500)
birth_date varchar(50)
created_at timestamp
updated_at timestamp
name_alternatives varchar(500)
name_confidence tinyint unsigned
family_relation varchar(50)
family_member_name varchar(100)
family_member_korean text
departure_date_parsed date
birth_date_parsed date
death_date_parsed date
place_id int
surname_english varchar(50)
surname_korean varchar(20)
given_name_english varchar(100)
given_name_korean varchar(50)
age_numeric tinyint unsigned
ship_id int
| id | ship_manifest_name | arrival_age | age_display | marital_status | departure_residence | departure_date | ship_name | tags_combined | korean_name | estimated_korean_name | hometown | last_update_time | tag_1st_gen | relation_memo | cemetery_name | image_additional_record | tag_2nd_gen | image_tombstone | image_family_photo | image_portrait | tag_3rd_gen | relation_history | cemetery_joint_burial | tombstone_name | death_date | image_ship | birth_date | created_at | updated_at | name_alternatives | name_confidence | family_relation | family_member_name | family_member_korean | departure_date_parsed | birth_date_parsed | death_date_parsed | place_id | surname_english | surname_korean | given_name_english | given_name_korean | age_numeric | ship_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C4arhQc5ScWxr1HOJOByxg | Kim, Dong Hyun | 34 | 34세 | married | In Chun | 4/30/1903 | Nippon Maru | 김동현 | NULL | 김Dong Hyun | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김동헌,김동혼 | 95 | 가장 | NULL | 김동현의 처(부인) | 1903-04-30 | NULL | NULL | 81 | Kim | 김 | Dong Hyun | 동현 | 34 | 15 | |||||||||||||||||
| c4.fGKNSTCaN0UdtMxrJkA | Chun, Keung Moon, son (Law Mu) | 5 | 5세 | single | Chemulpo | 3/3/1903 | Coptic | 전경문 | NULL | 전son (Law Mu) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 천경문,전강문 | 85 | 아들 | Law Mu | 노무 | 1903-03-03 | NULL | NULL | 42 | Chun | 전 | Keung Moon | 경문 | 5 | 4 | |||||||||||||||||
| c3U8l75HRoW6gkCy6ukGCA | Suk, Sung Kook | 26 | 26세 | married | Sai Kol | 3/10/1905 | China | 석성국 | 석성국 | NULL | 석Sung Kook | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-03-10 | NULL | NULL | 1177 | Suk | 석 | Sung Kook | 성국 | 26 | 3 | ||||||||||||||||
| C3mppLtRTzypH5txOkLHbw | Chung, Man Sik | 27 | 27세 | single | Yang San, Ye Dong | 6/25/1904 | Gaelic | 정만식 | 정만식 | NULL | 정Man Sik | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-06-25 | NULL | NULL | 1176 | Chung | 정 | Man Sik | 만식 | 27 | 7 | ||||||||||||||||
| c3lG7LmZQ2G51szo6CORVw | Han, Man Kil | 21 | 21세 | single | Soh Chun | 4/30/1903 | Nippon Maru | 한만길 | NULL | 한Man Kil | 2025-09-14 05:57:43 | 2025-12-10 04:59:17 | 한만걸,한만결 | 95 | 가장 | NULL | 한만길의 처(부인), 한씨의 자(아들) | 1903-04-30 | NULL | NULL | 1175 | Han | 한 | Man Kil | 만길 | 21 | 15 | |||||||||||||||||
| c3KjQ-.qRJOJY7Zamw19uQ | Choi, Sa Kil | 40 | 40세 | widower | Pom Ark | 1/26/1905 | Korea | 최사길 | NULL | 최Sa Kil | 2025-09-14 05:57:43 | 2025-12-10 04:34:46 | 최사걸,최사결 | 90 | 가장 | NULL | 최사길의 처(부인), 최계문(어머니) | 1905-01-26 | NULL | NULL | 192 | Choi | 최 | Sa Kil | 사길 | 40 | 9 | |||||||||||||||||
| c3epVPbNSMWfX3SHpK0fBw | Im, Chi Ok | 21 | 21세 | single | Soh Sang | 6/13/1905 | Doric | 임치옥 | 임치옥 | NULL | 임Chi Ok | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 임봉조(형제) | 1905-06-13 | NULL | NULL | 1174 | Im | 임 | Chi Ok | 치옥 | 21 | 6 | ||||||||||||||||
| C33A-xxCRqWgSOWfUD2ayA | Choi, Ok In | 20 | 20세 | single | Chung San Nam Chil | 1/26/1905 | Korea | 최옥인 | 최옥인 | NULL | 최Ok In | 2025-09-14 05:57:43 | 2025-12-10 04:34:41 | NULL | NULL | 가장 | NULL | 최옥인의 처(부인), 최계문(어머니) | 1905-01-26 | NULL | NULL | 1173 | Choi | 최 | Ok In | 옥인 | 20 | 9 | ||||||||||||||||
| C2xy-K7dT6CIVWlcCNad2w | Kim, Young Youk, mother (Kan Di Aiki) | 40 | 40세 | widower | Sa San Dong | 4/13/1905 | Korea | 김영육 | NULL | 김mother (Kan Di Aiki) | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김영욱,김영옥 | 85 | 어머니 | Kan Di Aiki | 간디아이키 | 1905-04-13 | NULL | NULL | 403 | Kim | 김 | Young Youk | 영육 | 40 | 9 | |||||||||||||||||
| C2WSlclfSEqM0KGlchOJSQ | Pak, In Koo | 27 | 27세 | single | Nam Hai, Dai Cheong Chi | 6/25/1904 | Gaelic | 박인구 | 박인구 | NULL | 박In Koo | 2025-09-14 05:57:45 | 2025-12-10 04:34:41 | NULL | NULL | 가장 | NULL | 박인구의 처(부인), 박한용(형제) | 1904-06-25 | NULL | NULL | 1172 | Pak | 박 | In Koo | 인구 | 27 | 7 | ||||||||||||||||
| c2l0.M9GR4WKpyMnolCBXw | Kim, Sang Woon | 24 | 24세 | widower | Sha Soo Man Om | 6/1/1904 | Coptic | 김상운 | NULL | 김Sang Woon | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김상훈,김상운 | 95 | 가장 | NULL | 김국경(부인), 김국경(딸) | 1904-06-01 | NULL | NULL | 1171 | Kim | 김 | Sang Woon | 상운 | 24 | 4 | |||||||||||||||||
| c2ebq92STOqGdOWAO85FOw | Kang, Young Pok | 28 | 28세 | married | Chun Won | 2/25/1905 | Mongolia | 강영복 | NULL | 강Young Pok | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 강용복,강영박 | 90 | NULL | NULL | NULL | 1905-02-25 | NULL | NULL | 1170 | Kang | 강 | Young Pok | 영복 | 28 | 14 | |||||||||||||||||
| c1WlGgpYSSmofiO8-qqMrw | No, Heung Keun, daughter (Puh Chun) | 2 | 2세 | single | Oh Ma Tong | 3/30/1904 | Korea | 노흥근 | NULL | Nodaughter (Puh Chun) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 노홍근,노흥건 | 95 | 딸 | Puh Chun | 부춘 | 1904-03-30 | NULL | NULL | 879 | No | 노 | Heung Keun | 흥근 | 2 | 9 | |||||||||||||||||
| c1TTFyJYTha41yhAotxv-Q | Hong, Chong Chul | 27 | 27세 | married | Seoul | 10/5/1903 | Siberia | 홍종철 | 홍종철 | NULL | 홍Chong Chul | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-10-05 | NULL | NULL | 18 | Hong | 홍 | Chong Chul | 종철 | 27 | 17 | ||||||||||||||||
| c1INwQn9TtyQklktz6RnOQ | Cha, Kong Sam, wife (Pak Yul) | 27 | 27세 | married | Choi Huu | 5/20/1904 | Siberia | 차공삼 | NULL | 차wife (Pak Yul) | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 차공심,차공섭 | 90 | 부인 | Pak Yul | 박열 | 1904-05-20 | NULL | NULL | 1169 | Cha | 차 | Kong Sam | 공삼 | 27 | 17 | |||||||||||||||||
| C1FfneoxRZ-imGIDC5mQ3Q | Han, Chil Woon, wife | 30 | 30세 | married | Kyeng Sung | 4/10/1904 | Gaelic | 한처 | 한처 | NULL | 한wife | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-04-10 | NULL | NULL | 986 | Han | 한 | Chil Woon | 처 | 30 | 7 | ||||||||||||||||
| C0RtUrDYRFqlHz3JE9e1Uw | Choi, Kyeng Soo, wife | 29 | 29세 | married | Seoul | 9/16/1904 | Gaelic | 최처 | 최처 | NULL | 최wife | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-09-16 | NULL | NULL | 18 | Choi | 최 | Kyeng Soo | 처 | 29 | 7 | ||||||||||||||||
| C0BeplS3RH29PywIr6E2zQ | Hong, Young Sam | 29 | 29세 | married | Cho Ryang | 11/18/1904 | Korea | 홍영삼 | 홍영삼 | NULL | 홍Young Sam | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 251 | Hong | 홍 | Young Sam | 영삼 | 29 | 9 | ||||||||||||||||
| C0.QAbNGSYO0sT8P1WGwkQ | Kim, Choong Sam | 32 | 32세 | married | Yong Kang | 3/4/1904 | Siberia | 김충삼 | 김충삼 | NULL | 김Choong Sam | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-03-04 | NULL | NULL | 173 | Kim | 김 | Choong Sam | 충삼 | 32 | 17 | ||||||||||||||||
| C-.te-X0RPWmoGB7rgbH1w | Song, Chi Sung | 27 | 27세 | single | Surl Soo Dong | 11/24/1904 | Gaelic | 송치성 | NULL | 송Chi Sung | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 송지성,송치승 | 85 | NULL | NULL | NULL | 1904-11-24 | NULL | NULL | 1168 | Song | 송 | Chi Sung | 치성 | 27 | 7 |