컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DSRKp3mTQuKgS4KxjZHugw | You, Duk Pil, wife | 29 | 29세 | married | Ka Pyeng | 5/20/1904 | Siberia | 유처 | 유처 | NULL | 유wife | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-05-20 | NULL | NULL | 846 | You | 유 | Duk Pil | 처 | 29 | 17 | ||||||||||||||||
| DSnWzte5Rz2Mfcz4.vH0pA | Ye, Choong Yerp | 23 | 23세 | married | Soh Chung Li | 4/13/1905 | Korea | 이충엽 | 이충엽 | NULL | 예충엽 | 2025-09-14 05:57:46 | 2025-12-10 04:32:54 | NULL | NULL | 가장 | NULL | 이경엽(부인), 이충엽의 처(부인), 이충엽의 처(부인), 이평춘(어머니), 이응목(아들), 이응목(아들), 이평춘(자매), 이채경(자매) | 1905-04-13 | NULL | NULL | 335 | Ye | 예 | Choong Yerp | 충엽 | 23 | 9 | ||||||||||||||||
| dSmAyTDQT7GGbNT-CtCicg | Choi, Sung Moon | 29 | 29세 | widower | An Hyup | 2/18/1904 | Doric | 최성문 | 최성문 | NULL | 최Sung Moon | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-02-18 | NULL | NULL | 1356 | Choi | 최 | Sung Moon | 성문 | 29 | 6 | ||||||||||||||||
| DSkezFJNShCCs-uMGcQkTQ | Han, Sang Ye | 26 | 26세 | single | Chin Choo | 3/4/1904 | Siberia | 한상예 | 한상예 | NULL | 한Sang Ye | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-03-04 | NULL | NULL | 404 | Han | 한 | Sang Ye | 상예 | 26 | 17 | ||||||||||||||||
| DsIDKdQFRiCh0I1zmwLlQQ | Kim, Che Sun | 40 | 40세 | married | Nam Yang | 4/14/1903 | China | 김제선 | NULL | 김Che Sun | 2025-09-14 05:57:44 | 2025-12-10 04:59:17 | 김채선,김재선 | 85 | 가장 | NULL | 김응섭(부인), 김종옥(부인), 김혼석(부인), 김인수(아들), 김씨의 자(아들), 김종옥(딸) | 1903-04-14 | NULL | NULL | 158 | Kim | 김 | Che Sun | 제선 | 40 | 3 | |||||||||||||||||
| DSi7vqsdSEm7OTKK2ikxaw | Chang, Woo Sang, aunt (Dong Ye) | 40 | 40세 | widow | An Dong | 6/1/1904 | Coptic | 장우상 | NULL | 장aunt (Dong Ye) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 장우삼,장우산 | 88 | NULL | Dong Ye | 동예 | 1904-06-01 | NULL | NULL | 769 | Chang | 장 | Woo Sang | 우상 | 40 | 4 | |||||||||||||||||
| DsguWKbvRPSX0C.tt9W0kA | Kong, Myeng Woon, wife | 22 | 22세 | married | Sin Sang Li | 5/29/1905 | China | 공명운 | NULL | Kongwife | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 공명윤,공맹운 | 85 | 부인 | NULL | NULL | 1905-05-29 | NULL | NULL | 779 | Kong | 공 | Myeng Woon | 명운 | 22 | 3 | |||||||||||||||||
| dsG3eankQ9WcV4WV4XKLfw | Ye, Ok Soon | 21 | 21세 | single | Chi Kok | 3/10/1905 | China | 이옥순 | NULL | 예Ok Soon | 2025-09-14 05:57:46 | 2025-12-06 16:53:31 | 예옥선,예억순 | 90 | 가장 | NULL | 이만용(부인), 이만용(자매) | 1905-03-10 | NULL | NULL | 1355 | Ye | 이 | Ok Soon | 옥순 | 21 | 3 | |||||||||||||||||
| DsFmNLBkTiqIO7d9VZVMGA | Ye, Kwi Pong | 26 | 26세 | single | Kwang Chung Dong | 2/2/1905 | Coptic | 이귀봉 | NULL | 예Kwi Pong | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예규봉,예귀방 | 80 | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 1354 | Ye | 이 | Kwi Pong | 귀봉 | 26 | 4 | |||||||||||||||||
| dsb2RmbES3KvQOE95nI9tA | Ye, Duk Soon, wife | 40 | 40세 | married | Young Choo Dong | 5/18/1905 | Mongolia | 이처 | 이처 | NULL | 예wife | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | 부인 | NULL | NULL | 1905-05-18 | NULL | NULL | 77 | Ye | 예 | Duk Soon | 처 | 40 | 14 | ||||||||||||||||
| drW-jVtJQIOln1RNea9yRw | Youn, Kei Hong | 22 | 22세 | single | Se Kol | 4/17/1904 | America Maru | 윤계홍 | NULL | 윤Kei Hong | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 윤기홍,윤게홍 | 85 | NULL | NULL | NULL | 1904-04-17 | NULL | NULL | 1353 | Youn | 윤 | Kei Hong | 계홍 | 22 | 1 | |||||||||||||||||
| dRoIibR5RXCctI5yvroUUA | Kim, Chai Seun | 25 | 25세 | married | Kim Hai | 1/9/1904 | America Maru | 김재선 | NULL | 김Chai Seun | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김채선,김재성 | 85 | NULL | NULL | NULL | 1904-01-09 | NULL | NULL | 144 | Kim | 김 | Chai Seun | 재선 | 25 | 1 | |||||||||||||||||
| drL21oM2QV2yRC8y0eJ13A | Choi, Yer Sam | 32 | 32세 | married | Pak Moo Kol | 9/16/1904 | Gaelic | 최여삼 | NULL | 최Yer Sam | 2025-09-14 05:57:43 | 2025-12-10 04:34:46 | 최여상,최열삼 | 75 | 가장 | NULL | 최여삼의 처(부인) | 1904-09-16 | NULL | NULL | 1214 | Choi | 최 | Yer Sam | 여삼 | 32 | 7 | |||||||||||||||||
| dRkza1KvS2GW9JOKkhW.-g | Kim, Hyuk Nak | 26 | 26세 | single | Chin Choo | 12/28/1903 | Siberia | 김혁낙 | NULL | 김Hyuk Nak | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김혁락,김혁노 | 90 | 가장 | NULL | 김혁낙의 처(부인) | 1903-12-28 | NULL | NULL | 404 | Kim | 김 | Hyuk Nak | 혁낙 | 26 | 17 | |||||||||||||||||
| dre5D8tKTLiVl7avl5ysqQ | Chung, Pong Yong | 23 | 23세 | single | Oh Yang San | 1/6/1905 | Doric | 정봉용 | NULL | 정Pong Yong | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 정방용,정풍용 | 88 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 1352 | Chung | 정 | Pong Yong | 봉용 | 23 | 6 | |||||||||||||||||
| DRCJxeNLRNyGORUWw4hZgg | Chun, Nak Chung, wife (Ruch) | 19 | 19세 | married | Duk Won | 3/4/1904 | Siberia | 전낙정 | NULL | 전wife (Ruch) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 천낙정,전락정 | 82 | 부인 | Ruch | 룩 | 1904-03-04 | NULL | NULL | 863 | Chun | 전 | Nak Chung | 낙정 | 19 | 17 | |||||||||||||||||
| dR46Xm6HT9OdDH30ITKcWQ | Choo, Duk Eun | 21 | 21세 | single | Kwang Choo | 4/30/1903 | Nippon Maru | 주덕은 | NULL | ChooDuk Eun | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 추덕은,주득은 | 85 | NULL | NULL | NULL | 1903-04-30 | NULL | NULL | 153 | Choo | 주 | Duk Eun | 덕은 | 21 | 15 | |||||||||||||||||
| dqzaEroVRAWhYsoiXVqRJw | Son, Chang Son | 21 | 21세 | single | Hool Yern Ap | 12/9/1904 | Mongolia | 손창선 | NULL | 손Chang Son | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 손창손,손장선 | 88 | NULL | NULL | NULL | 1904-12-09 | NULL | NULL | 1351 | Son | 손 | Chang Son | 창선 | 21 | 14 | |||||||||||||||||
| DqvhZIheTrmvbyFRJENQxw | Im, Dai Young, son (Whang Yong) | 10 | 10세 | single | Woo Keun Ye | 3/31/1905 | Manchuria | 임대영 | NULL | 임son (Whang Yong) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 임다영,임태영 | 85 | 아들 | Whang Yong | 황용 | 1905-03-31 | NULL | NULL | 1277 | Im | 임 | Dai Young | 대영 | 10 | 12 | |||||||||||||||||
| dQNxO7CBSoa9MlvC5e-feA | Kang, Duk No | 40 | 40세 | married | Ham Dai Ri | 11/24/1904 | Gaelic | 강덕노 | NULL | 강Duk No | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 강덕로,강득노 | 90 | NULL | NULL | NULL | 1904-11-24 | NULL | NULL | 1350 | Kang | 강 | Duk No | 덕노 | 40 | 7 |