컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HJZXuykGQa6Zb-Fd1P3nYQ | Kil, Seung Chai | 31 | 31세 | married | Hong Chun | 12/28/1903 | Coptic | 길승채 | NULL | KilSeung Chai | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 길승체,길승재 | 85 | NULL | NULL | NULL | 1903-12-28 | NULL | NULL | 311 | Kil | 길 | Seung Chai | 승채 | 31 | 4 | |||||||||||||||||
| hJWJQU9iTp-QGVuD2hjyLw | Ye, Chang Keun, son (Myen Sik) | 10 | 10세 | single | Dooi Deul Eui | 3/31/1905 | Manchuria | 이창근 | NULL | 예son (Myen Sik) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 예창긴,예창건 | 85 | 아들 | Myen Sik | 면식 | 1905-03-31 | NULL | NULL | 1785 | Ye | 이 | Chang Keun | 창근 | 10 | 12 | |||||||||||||||||
| HjWjdBH-TUi2QvacEl0R2w | Son, Kyeng Choon | 31 | 31세 | widower | Man Suk Li | 5/18/1905 | Mongolia | 손경춘 | 손경춘 | NULL | 손Kyeng Choon | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-05-18 | NULL | NULL | 1784 | Son | 손 | Kyeng Choon | 경춘 | 31 | 14 | ||||||||||||||||
| HJUOoPUiT3uchK8ymyVfoQ | Ye, Sun You | 27 | 27세 | married | Pap Won | 10/1/1904 | America Maru | 이순유 | NULL | 예Sun You | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예선유,예순구 | 80 | NULL | NULL | NULL | 1904-10-01 | NULL | NULL | 1783 | Ye | 이 | Sun You | 순유 | 27 | 1 | |||||||||||||||||
| hjONdusoTOSkw-vpN-jl3Q | Pak, Myeng Choon, brother (Chum Pa We) | 10 | 10세 | single | Eun Sung Ri | 11/18/1904 | Korea | 박명춘 | NULL | 박brother (Chum Pa We) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박명천,박명준 | 85 | 형제 | Chum Pa We | 춤파위 | 1904-11-18 | NULL | NULL | 1189 | Pak | 박 | Myeng Choon | 명춘 | 10 | 9 | |||||||||||||||||
| hjEXh5r3TWuVYvxdzpgD-A | Kim, In Soo | 27 | 27세 | married | Yong In | 4/26/1904 | China | 김인수 | 김인수 | NULL | 김인수 | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 김송의(부인), 김송의(어머니) | 1904-04-26 | NULL | NULL | 629 | Kim | 김 | In Soo | 인수 | 27 | 3 | ||||||||||||||||
| hjAUsB1tR4-Jf73YHYkmzA | Youn, Ke Ho | 24 | 24세 | widower | Pyeng Yang | 9/21/1903 | Doric | 윤기호 | NULL | 윤Ke Ho | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 윤기혹,윤계호 | 85 | NULL | NULL | NULL | 1903-09-21 | NULL | NULL | 58 | Youn | 윤 | Ke Ho | 기호 | 24 | 6 | |||||||||||||||||
| Hj4PoF26QSax4WR1XDHgHQ | Han, In Soon | 28 | 28세 | single | So Chun Ker Ri | 10/6/1904 | China | 한인순 | NULL | 한In Soon | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한인선,한인준 | 90 | NULL | NULL | NULL | 1904-10-06 | NULL | NULL | 1782 | Han | 한 | In Soon | 인순 | 28 | 3 | |||||||||||||||||
| hJ0XFXQAQxmsrWUFx2XD9A | Im, Young Dal, wife | 40 | 40세 | married | Chang Im | 8/22/1904 | Coptic | 임처 | 임처 | NULL | 임wife | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-08-22 | NULL | NULL | 1327 | Im | 임 | Young Dal | 처 | 40 | 4 | ||||||||||||||||
| hiZfOccXQ0aJdVisY8HmxQ | Kim, Seh Ryong, wife (Ye) | 34 | 34세 | married | Soh Chon | 9/5/1904 | Korea | 김세룡 | NULL | 김wife (Ye) | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김세용,김서룡 | 85 | 부인 | Ye | 예 | 1904-09-05 | NULL | NULL | 1781 | Kim | 김 | Seh Ryong | 세룡 | 34 | 9 | |||||||||||||||||
| hiyiIR-MRHOm9v3TADR-8g | Kim, You Sung | 35 | 35세 | widower | In Chun | 4/30/1903 | Nippon Maru | 김유성 | NULL | 김You Sung | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김구성,김유승 | 90 | 가장 | NULL | 김유성의 처(부인) | 1903-04-30 | NULL | NULL | 81 | Kim | 김 | You Sung | 유성 | 35 | 15 | |||||||||||||||||
| hilKpyAtSFypcN.QCgTdaw | Oh, Chang Hoon | 20 | 20세 | single | Yong Kang | 7/30/1904 | Doric | 오창훈 | NULL | 오Chang Hoon | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 오창운,오창헌 | 90 | NULL | NULL | NULL | 1904-07-30 | NULL | NULL | 173 | Oh | 오 | Chang Hoon | 창훈 | 20 | 6 | |||||||||||||||||
| Hih-k310R-m14j6LWA97ZQ | Chang, Young Kui | 26 | 26세 | married | Wool Kwang Li | 5/18/1905 | Mongolia | 장영규 | NULL | 장Young Kui | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 장영기,장영구 | 85 | NULL | NULL | NULL | 1905-05-18 | NULL | NULL | 1780 | Chang | 장 | Young Kui | 영규 | 26 | 14 | |||||||||||||||||
| hIGdZ98-SzK2TBNB3prllA | Son, Kyeng Choon | 35 | 35세 | widower | Kang Chin | 7/30/1904 | Doric | 손경춘 | 손경춘 | NULL | 손Kyeng Choon | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-07-30 | NULL | NULL | 1779 | Son | 손 | Kyeng Choon | 경춘 | 35 | 6 | ||||||||||||||||
| hIFo4c5WTh2dHncVb6mtrA | Soh, Pong Soon | 23 | 23세 | single | San Im Dong | 11/18/1904 | Korea | 서봉순 | NULL | 서Pong Soon | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 서방순,서풍순 | 85 | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 816 | Soh | 서 | Pong Soon | 봉순 | 23 | 9 | |||||||||||||||||
| HI88FRViRf6vG0viPUhYWA | Pak, Seung Dal | 20 | 20세 | single | Ka We Kea | 6/25/1904 | Gaelic | 박승달 | NULL | 박Seung Dal | 2025-09-14 05:57:45 | 2025-12-10 04:34:46 | 박승단,박성달 | 85 | 가장 | NULL | 박승달의 처(부인), 박한용(형제) | 1904-06-25 | NULL | NULL | 1778 | Pak | 박 | Seung Dal | 승달 | 20 | 7 | |||||||||||||||||
| Hi40Ege9SuyU2gdShFBEuQ | Song, Chi Sam | 40 | 40세 | married | Soo Yang Li | 5/8/1905 | Siberia | 송치삼 | 송치삼 | NULL | 송Chi Sam | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-05-08 | NULL | NULL | 1579 | Song | 송 | Chi Sam | 치삼 | 40 | 17 | ||||||||||||||||
| hHZUyFB.TRestxd80oTdjQ | Sin, Dai Soo | 35 | 35세 | widower | Dong Li | 2/13/1905 | Siberia | 신대수 | NULL | 신Dai Soo | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 신태수,신대주 | 85 | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 1777 | Sin | 신 | Dai Soo | 대수 | 35 | 17 | |||||||||||||||||
| hhzf0ZvfTlGKqcISoHr1VA | Chung, Young Soo | 20 | 20세 | widower | Dong Am | 2/2/1905 | Coptic | 정영수 | 정영수 | NULL | 정영수 | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 1776 | Chung | 정 | Young Soo | 영수 | 20 | 4 | ||||||||||||||||
| HHwadXOaSLiFFhSswKGalA | Paik, Sang Keun | 31 | 31세 | married | Choong San Li | 5/18/1905 | Mongolia | 백상근 | NULL | PaikSang Keun | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 백상긴,백상건 | 90 | NULL | NULL | NULL | 1905-05-18 | NULL | NULL | 1775 | Paik | 백 | Sang Keun | 상근 | 31 | 14 |