컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Y4PHjJmaQ2O-88uQyYdJ4g | Im, Young Taik | 31 | 31세 | married | Ko Song Myen | 2/2/1905 | Coptic | 임영택 | NULL | 임Young Taik | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 임영탁,임용택 | 90 | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 3324 | Im | 임 | Young Taik | 영택 | 31 | 4 | |||||||||||||||||
| y4LD.KUnTn2cGAQqyEwUQw | Kim, Ye Jai, wife | 26 | 26세 | married | Chemulpo | 1/13/1903 | Gaelic | 김처 | 김처 | NULL | 김wife | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1903-01-13 | NULL | NULL | 42 | Kim | 김 | Ye Jai | 처 | 26 | 7 | ||||||||||||||||
| Y4kRQeuGTZquI39SzrRTSQ | Paik, Won Sun, wife | 24 | 24세 | married | Choo Ki Dong | 12/9/1904 | Mongolia | 백원선 | NULL | Paikwife | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 백원순,백원선 | 85 | 부인 | NULL | NULL | 1904-12-09 | NULL | NULL | 175 | Paik | 백 | Won Sun | 원선 | 24 | 14 | |||||||||||||||||
| y4GN6A6ETxizGCPd25lzQQ | Pak, Chan Kil | 24 | 24세 | single | An Sin Dong | 2/13/1905 | Siberia | 박찬길 | NULL | 박Chan Kil | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박찬걸,박찬칠 | 90 | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 3323 | Pak | 박 | Chan Kil | 찬길 | 24 | 17 | |||||||||||||||||
| y4cHnt0vRNyyKhVGJTPKkg | Chang, Young Whan | 37 | 37세 | widower | Seoul | 4/10/1904 | Gaelic | 장영환 | NULL | 장Young Whan | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 장영완,장용환 | 90 | NULL | NULL | NULL | 1904-04-10 | NULL | NULL | 18 | Chang | 장 | Young Whan | 영환 | 37 | 7 | |||||||||||||||||
| y3xYINwFQf-N2bL09BUCWA | An, Keum Nok | 24 | 24세 | single | In Mok | 2/13/1905 | Siberia | 안금녹 | NULL | 안Keum Nok | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 안금록,안검녹 | 80 | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 3322 | An | 안 | Keum Nok | 금녹 | 24 | 17 | |||||||||||||||||
| y3sFcOXWTAOkLYjELuKLPQ | Chang, Kyeng Sun | 21 | 21세 | single | Kyeng Sun, Pum Moon Toh | 6/25/1904 | Gaelic | 장경선 | 장경선 | NULL | 장Kyeng Sun | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-06-25 | NULL | NULL | 3321 | Chang | 장 | Kyeng Sun | 경선 | 21 | 7 | ||||||||||||||||
| Y3oSb6H-SnmbFAuc0UNx-A | Kim, Heung Chan | 24 | 24세 | married | Nam Moon An | 10/6/1904 | China | 김흥찬 | NULL | 김Heung Chan | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김흥찬,김흥천 | 90 | 가장 | NULL | 김귀부(아들) | 1904-10-06 | NULL | NULL | 2999 | Kim | 김 | Heung Chan | 흥찬 | 24 | 3 | |||||||||||||||||
| Y39TnZo7QLqER3fuyuHgWw | Moon, Young Ok, wife | 28 | 28세 | married | Ker Pyeng | 5/18/1905 | Mongolia | 문처 | 문처 | NULL | 문wife | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1905-05-18 | NULL | NULL | 1302 | Moon | 문 | Young Ok | 처 | 28 | 14 | ||||||||||||||||
| y2l9eBlIRdqpjsXAlwb0wQ | Pak, Heui Dak | 22 | 22세 | married | Sa Chik Kol | 1/26/1905 | Korea | 박희덕 | NULL | 박Heui Dak | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박희탁,박의덕 | 85 | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 3320 | Pak | 박 | Heui Dak | 희덕 | 22 | 9 | |||||||||||||||||
| Y1qu6EhmRuaPAQIJ76GiNQ | Ye, Choon Kyeng | 25 | 25세 | married | Oh Ri Dong | 2/25/1905 | Mongolia | 이춘경 | NULL | 예Choon Kyeng | 2025-09-14 05:57:46 | 2025-12-06 16:53:31 | 예준경,예천경 | 85 | 가장 | NULL | 이삼수(부인), 이선기(부인) | 1905-02-25 | NULL | NULL | 498 | Ye | 이 | Choon Kyeng | 춘경 | 25 | 14 | |||||||||||||||||
| Y1Q9n7HkSXm8HtEMTfBl3w | Kim, In Surp | 21 | 21세 | married | Sa San | 4/13/1905 | Korea | 김인섭 | NULL | 김In Surp | 2025-09-14 05:57:44 | 2025-12-10 04:59:05 | 김인습,김인수 | 85 | 가장 | NULL | 김치복(부인), 김씨 부인, 김기주(부인), 김영육(어머니), 김기주(아들), 김성배 아들 백용(아들), 김치화(아들), 김치복(딸) | 1905-04-13 | NULL | NULL | 1418 | Kim | 김 | In Surp | 인섭 | 21 | 9 | |||||||||||||||||
| Y1okMjhrQLqy57l3v.TMsQ | Moon, Yong Whan | 19 | 19세 | single | Il Dong | 4/24/1905 | Coptic | 문용환 | NULL | 문Yong Whan | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 문용완,문룡환 | 90 | NULL | NULL | NULL | 1905-04-24 | NULL | NULL | 229 | Moon | 문 | Yong Whan | 용환 | 19 | 4 | |||||||||||||||||
| y1Jbb2j1SL67I-EZ-UQYvw | Soon, Sang Heun | 28 | 28세 | widower | Chemulpo | 3/19/1903 | Korea | 순상흔 | NULL | SoonSang Heun | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 선상흔,순상헌 | 80 | NULL | NULL | NULL | 1903-03-19 | NULL | NULL | 42 | Soon | 순 | Sang Heun | 상흔 | 28 | 9 | |||||||||||||||||
| y0UqvcapTKqd8r8lGVfZEg | Pak, Myeng Oh | 24 | 24세 | married | Eun Koong Li | 1/6/1905 | Doric | 박명오 | NULL | 박Myeng Oh | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박명옥,박명호 | 85 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 3319 | Pak | 박 | Myeng Oh | 명오 | 24 | 6 | |||||||||||||||||
| y0MMFTfgQeSd79In2gr08Q | Kim, Hyeng Tai | 30 | 30세 | married | Yern Pong | 11/18/1904 | Korea | 김형태 | 김형태 | NULL | 김Hyeng Tai | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 2419 | Kim | 김 | Hyeng Tai | 형태 | 30 | 9 | ||||||||||||||||
| Y.KYaJxBRcyXDepbj1DWlQ | Kim, Sung Hai | 18 | 18세 | single | Pyeng Yang | 2/18/1904 | Doric | 김성해 | NULL | 김Sung Hai | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김성희,김성혜 | 90 | NULL | NULL | NULL | 1904-02-18 | NULL | NULL | 58 | Kim | 김 | Sung Hai | 성해 | 18 | 6 | |||||||||||||||||
| Y.AWMkcyRiCmji1rSph36w | Cho, Suk Choo | 38 | 38세 | widower | Seoul | 10/5/1903 | Siberia | 조석주 | NULL | 조Suk Choo | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 조석추,조석수 | 85 | NULL | NULL | NULL | 1903-10-05 | NULL | NULL | 18 | Cho | 조 | Suk Choo | 석주 | 38 | 17 | |||||||||||||||||
| Y.AFO9chQ.mpbBF32r9rFA | Whang, Moon Sung | 23 | 23세 | single | Oh Chung | 1/26/1905 | Korea | 황문성 | NULL | 황Moon Sung | 2025-09-14 05:57:45 | 2025-12-10 04:34:46 | 황문승,황문선 | 90 | 가장 | NULL | 황문성의 처(부인) | 1905-01-26 | NULL | NULL | 3318 | Whang | 황 | Moon Sung | 문성 | 23 | 9 | |||||||||||||||||
| Y-z5VixiT.CTEK909sxkFg | Kim, Hong Woon | 21 | 21세 | single | Hyeng Pong | 11/24/1904 | Gaelic | 김홍운 | NULL | 김Hong Woon | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김홍완,김홍원 | 85 | NULL | NULL | NULL | 1904-11-24 | NULL | NULL | 3317 | Kim | 김 | Hong Woon | 홍운 | 21 | 7 |