컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| tSvq8.GyQaGxpzQOxv7F0w | Youn, Myeng Sun | 37 | 37세 | widower | Pyeng Sook Chang | 10/17/1904 | Doric | 윤명선 | NULL | 윤Myeng Sun | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 윤명순,윤명신 | 92 | NULL | NULL | NULL | 1904-10-17 | NULL | NULL | 2958 | Youn | 윤 | Myeng Sun | 명선 | 37 | 6 | |||||||||||||||||
| tsV8xf36QVG7hO5.3ZioyA | Pak, Chang Kiu, daughter (Ar Hi) | 1 | 1세 | single | Sang Im Dong | 11/2/1904 | Manchuria | 박창규 | NULL | 박daughter (Ar Hi) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박창기,박창구 | 90 | 딸 | Ar Hi | 아희 | 1904-11-02 | NULL | NULL | 1663 | Pak | 박 | Chang Kiu | 창규 | 1 | 12 | |||||||||||||||||
| TsMVnnEVROWK07hwm.j8gw | Kim, Do Ra | 50 | 50세 | married | Nam Chang Dong | 10/17/1904 | Doric | 김도라 | NULL | 김Do Ra | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김도래,김도락 | 88 | 가장 | NULL | 김도라의 처(부인), 김도라의 처(부인), 김순학(아들), 김춘여(딸), 김순학(딸) | 1904-10-17 | NULL | NULL | 457 | Kim | 김 | Do Ra | 도라 | 50 | 6 | |||||||||||||||||
| tSgYXA0xTbOyRQgz.0in.g | Im, Doo Wha | 20 | 20세 | single | Dal Kook Chai | 5/8/1905 | Siberia | 임두화 | NULL | 임Doo Wha | 2025-09-14 05:57:43 | 2025-12-10 04:34:46 | 임도화,임두하 | 90 | 가장 | NULL | 임두화의 처(부인), 임광목(딸) | 1905-05-08 | NULL | NULL | 1091 | Im | 임 | Doo Wha | 두화 | 20 | 17 | |||||||||||||||||
| TSFXSniiSh2NfQ7Qz7ze5g | Kim, Dong Suk, wife | 26 | 26세 | married | Tai Koo | 7/8/1904 | Mongolia | 김처 | 김처 | NULL | 김wife | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-07-08 | NULL | NULL | 471 | Kim | 김 | Dong Suk | 처 | 26 | 14 | ||||||||||||||||
| ts8h3f1fSiytiRpJfS5kig | Pok, No Hun | 38 | 38세 | married | An Pyun | 12/28/1903 | Coptic | 복노훈 | NULL | PokNo Hun | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박노훈,복노흔 | 85 | NULL | NULL | NULL | 1903-12-28 | NULL | NULL | 177 | Pok | 복 | No Hun | 노훈 | 38 | 4 | |||||||||||||||||
| Ts5DiMx0SI26AYCkE-a1dw | Moon, Soon Soh | 27 | 27세 | married | Ko San Dong | 1/26/1905 | Korea | 문순소 | NULL | 문Soon Soh | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 문순서,문순수 | 88 | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 2957 | Moon | 문 | Soon Soh | 순소 | 27 | 9 | |||||||||||||||||
| TS1jODYZRmOrD64eu-F9mA | Ye, Pyeng Doo | 19 | 19세 | single | Tai Pyeng Dong | 1/26/1905 | Korea | 이평두 | NULL | 예Pyeng Doo | 2025-09-14 05:57:46 | 2025-12-10 04:33:41 | 예평도,예병두 | 87 | 가장 | NULL | 이평두의 처(부인), 이평두의 처(부인), 이평두의 처(부인), 이평두의 자(아들), 이평두의 자(아들), 이평두의 자(아들), 이평두의 녀(딸) | 1905-01-26 | NULL | NULL | 762 | Ye | 이 | Pyeng Doo | 평두 | 19 | 9 | |||||||||||||||||
| tRmDOOLPT-ym3XDaEFyGPg | Whang, Ki Man | 19 | 19세 | single | Soo Kol | 3/31/1905 | Manchuria | 황기만 | 황기만 | NULL | 황Ki Man | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-03-31 | NULL | NULL | 2956 | Whang | 황 | Ki Man | 기만 | 19 | 12 | ||||||||||||||||
| TrlP6aqyROOYKV8suoxPwA | Ye, Soh Man | 23 | 23세 | single | Che Choo | 4/30/1903 | Nippon Maru | 이소만 | NULL | 예Soh Man | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예서만,예소민 | 85 | NULL | NULL | NULL | 1903-04-30 | NULL | NULL | 460 | Ye | 이 | Soh Man | 소만 | 23 | 15 | |||||||||||||||||
| trIhsVWYRQyFn-xrpfLgyw | Pak, Dong Eun, brother (Dong Choon) | 18 | 18세 | single | Duk Eun Dong | 10/17/1904 | Doric | 박동은 | NULL | 박brother (Dong Choon) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박동언,박동운 | 92 | 형제 | Dong Choon | 동춘 | 1904-10-17 | NULL | NULL | 1098 | Pak | 박 | Dong Eun | 동은 | 18 | 6 | |||||||||||||||||
| tRgGS4IPRHKJfhOz5PjX2g | Pong, Youn Hyuk | 27 | 27세 | married | Kyo Dong | 11/2/1904 | Manchuria | 방윤혁 | NULL | PongYoun Hyuk | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 봉윤혁,방윤익 | 88 | NULL | NULL | NULL | 1904-11-02 | NULL | NULL | 150 | Pong | 방 | Youn Hyuk | 윤혁 | 27 | 12 | |||||||||||||||||
| TRg1dGwiQnuSjt2guKzD-g | Hong, Choon Ye | 11 | 11세 | single | Nam Yang | 11/2/1903 | Korea | 홍춘예 | 홍춘예 | NULL | 홍Choon Ye | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-11-02 | NULL | NULL | 158 | Hong | 홍 | Choon Ye | 춘예 | 11 | 9 | ||||||||||||||||
| TrBP.HGyTLyJ1buZL3fWQw | Son, Dai Kil | 23 | 23세 | single | Pil Dong | 11/2/1904 | Manchuria | 손대길 | NULL | 손Dai Kil | 2025-09-14 05:57:45 | 2025-12-10 04:34:46 | 손대걸,손태길 | 90 | 가장 | NULL | 손대길의 처(부인), 손창희(딸) | 1904-11-02 | NULL | NULL | 347 | Son | 손 | Dai Kil | 대길 | 23 | 12 | |||||||||||||||||
| TRacfszYRr6divTRZ8xCIw | Young, Dai Pong, son 1 (Yan Chi) | 9 | 9세 | single | Fusan | 11/18/1903 | Hongkong Maru | 양대봉 | NULL | Youngson 1 (Yan Chi) | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 영대봉,량대봉 | 80 | 아들 | Yan Chi | 연치 | 1903-11-18 | NULL | NULL | 16 | Young | 양 | Dai Pong | 대봉 | 9 | 8 | |||||||||||||||||
| TRa04zqmRdK5ImmPKXwcZg | Ye, Ik Min | 23 | 23세 | married | San Wha, Pio So Tong | 7/8/1904 | Mongolia | 이익민 | 이익민 | NULL | 예Ik Min | 2025-09-14 05:57:46 | 2025-12-10 04:32:54 | NULL | NULL | 가장 | NULL | 이익민의 처(부인), 이익민의 처(부인) | 1904-07-08 | NULL | NULL | 1899 | Ye | 예 | Ik Min | 익민 | 23 | 14 | ||||||||||||||||
| tr-9QPkvQCOVsZ1Iqt4mUw | Son, Sung Woon | 22 | 22세 | widower | Choong Dori | 3/10/1905 | China | 손성운 | NULL | 손Sung Woon | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 손성원,손승운 | 95 | NULL | NULL | NULL | 1905-03-10 | NULL | NULL | 2955 | Son | 손 | Sung Woon | 성운 | 22 | 3 | |||||||||||||||||
| tQVtvR.tRwmqJdkgk7ZXYw | Pak, Chang Sik | 27 | 27세 | married | Sai Ri Won | 2/2/1905 | Coptic | 박창식 | 박창식 | NULL | 박Chang Sik | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 2954 | Pak | 박 | Chang Sik | 창식 | 27 | 4 | ||||||||||||||||
| tQMhdxInQmiU.uBJ7AIlbQ | Oh, Heum Choon | 16 | 16세 | single | Pook Mom Kol | 11/18/1904 | Korea | 오흠춘 | NULL | 오Heum Choon | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 오흠준,오흥춘 | 85 | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 2953 | Oh | 오 | Heum Choon | 흠춘 | 16 | 9 | |||||||||||||||||
| tqLyg9UST.atFjR1jjch2g | Kim, Chun Son | 30 | 30세 | widower | Kwang Choo | 3/4/1904 | Siberia | 김춘손 | NULL | 김Chun Son | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김천손,김춘선 | 92 | NULL | NULL | NULL | 1904-03-04 | NULL | NULL | 153 | Kim | 김 | Chun Son | 춘손 | 30 | 17 |