컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| kOilzQcHQvKvm.SieiXmXQ | Kang, Young Ho | 23 | 23세 | married | Chun Won Kang Do | 2/2/1905 | Coptic | 강영호 | 강영호 | NULL | 강Young Ho | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 2102 | Kang | 강 | Young Ho | 영호 | 23 | 4 | ||||||||||||||||
| KoGC47e9T36ab8r75x7hfQ | Moon, Chin Ye | 24 | 24세 | single | Soh Kai Chin | 1/6/1905 | Doric | 문진예 | NULL | 문Chin Ye | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 문진여,문친예 | 85 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 2101 | Moon | 문 | Chin Ye | 진예 | 24 | 6 | |||||||||||||||||
| koenn72XQuq6vYhnmK.vfw | Kim, Pong Soon | 23 | 23세 | married | Seoul | 4/26/1904 | China | 김봉순 | NULL | 김Pong Soon | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김봉선,김방순 | 90 | 가장 | NULL | 김송의(부인), 김송의(어머니) | 1904-04-26 | NULL | NULL | 18 | Kim | 김 | Pong Soon | 봉순 | 23 | 3 | |||||||||||||||||
| KOEdGAxhQKSMENLoYer9xw | Hir, Cha Myeng | 28 | 28세 | married | Soo Sung Sang Don | 1/26/1905 | Korea | 허차명 | NULL | HirCha Myeng | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 허자명,김차명 | 75 | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 2100 | Hir | 허 | Cha Myeng | 차명 | 28 | 9 | |||||||||||||||||
| koblkZSISUqoGSXpohl0kA | Chun, Young Choon | 34 | 34세 | widower | Nereun Ma Dong | 1/26/1905 | Korea | 전영춘 | 전영춘 | NULL | 전Young Choon | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 2099 | Chun | 전 | Young Choon | 영춘 | 34 | 9 | ||||||||||||||||
| ko3G5mQgTFu5PXQskHuE5A | Kwen, Hong Youn | 32 | 32세 | married | Sam Chun Dong | 2/13/1905 | Siberia | 권홍윤 | NULL | KwenHong Youn | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 권홍연,권홍균 | 85 | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 841 | Kwen | 권 | Hong Youn | 홍윤 | 32 | 17 | |||||||||||||||||
| knXIng9hSC2qVWIr5zPsbw | Chai, Byung Hyun | 22 | 22세 | single | Soo An | 11/2/1903 | Korea | 채병현 | NULL | ChaiByung Hyun | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 채병헌,최병현 | 90 | NULL | NULL | NULL | 1903-11-02 | NULL | NULL | 1511 | Chai | 채 | Byung Hyun | 병현 | 22 | 9 | |||||||||||||||||
| knwupJhRRdeUDlhcLw6Npw | Son, Sei Youn | 33 | 33세 | married | Saik Dong | 12/9/1904 | Mongolia | 손세윤 | NULL | 손Sei Youn | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 손세연,손세윤 | 88 | NULL | NULL | NULL | 1904-12-09 | NULL | NULL | 2098 | Son | 손 | Sei Youn | 세윤 | 33 | 14 | |||||||||||||||||
| kNWd1psdR0qt0FRk9kg1gg | Choo, Chang Kook, daughter | 10 | 10세 | single | Cho San | 7/18/1904 | China | 주창국 | NULL | Choodaughter | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 추창국,주창걱 | 88 | 딸 | NULL | NULL | 1904-07-18 | NULL | NULL | 1492 | Choo | 주 | Chang Kook | 창국 | 10 | 3 | |||||||||||||||||
| Kn3WJHtMSd6NyMArd0XRqA | Kim, Ye Surp | 21 | 21세 | married | Kwan Dong | 4/24/1905 | Coptic | 김예섭 | NULL | 김Ye Surp | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김예습,김예십 | 85 | NULL | NULL | NULL | 1905-04-24 | NULL | NULL | 669 | Kim | 김 | Ye Surp | 예섭 | 21 | 4 | |||||||||||||||||
| KN-zLCpHTr2GSgITA-BfJg | Pak, Chi Soon | 33 | 33세 | widower | An San, Shi Goh | 6/25/1904 | Gaelic | 박치순 | NULL | 박Chi Soon | 2025-09-14 05:57:45 | 2025-12-10 04:34:46 | 박지순,박치선 | 90 | 가장 | NULL | 박치순의 처(부인), 박한용(형제) | 1904-06-25 | NULL | NULL | 2097 | Pak | 박 | Chi Soon | 치순 | 33 | 7 | |||||||||||||||||
| KmWNP-M-QVWDzi4DP9OIvg | Pak, Yong Chan | 27 | 27세 | married | Seoul | 4/30/1903 | Nippon Maru | 박용찬 | 박용찬 | NULL | 박Yong Chan | 2025-09-14 05:57:45 | 2025-12-10 04:34:41 | NULL | NULL | 가장 | NULL | 박용찬의 처(부인) | 1903-04-30 | NULL | NULL | 18 | Pak | 박 | Yong Chan | 용찬 | 27 | 15 | ||||||||||||||||
| kMUPK7veSAa1eUPjUv0wdA | Kim, Suk Choon | 28 | 28세 | married | Sai Nai | 5/18/1905 | Mongolia | 김숙춘 | 김숙춘 | NULL | 김Suk Choon | 2025-09-14 05:57:44 | 2025-12-10 04:34:41 | NULL | NULL | 가장 | NULL | 김숙춘의 처(부인), 김숙춘의 처(부인), 김숙춘의 처(부인), 김숙춘의 처(부인), 김숙춘의 처(부인), 김숙춘의 처(부인), 김경윤(어머니), 김용환(어머니), 김용환(아들), | 1905-05-18 | NULL | NULL | 1862 | Kim | 김 | Suk Choon | 숙춘 | 28 | 14 | ||||||||||||||||
| kmijAMC.Qtqnm3wKuXd34Q | Han, Kwang Choo | 30 | 30세 | widower | Soh Pyen Dong | 9/26/1904 | Mongolia | 한광주 | NULL | 한Kwang Choo | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한광추,한광초 | 88 | NULL | NULL | NULL | 1904-09-26 | NULL | NULL | 2096 | Han | 한 | Kwang Choo | 광주 | 30 | 14 | |||||||||||||||||
| KmHMcEpFTsK.yh9JNribhQ | Chang, Chung Sik | 30 | 30세 | single | Cho Rang | 1/6/1905 | Doric | 장성식 | 장성식 | 장정식 | 2025-07-12 00:00:00 | 장성식 | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 2095 | Chang | 장 | Chung Sik | 성식 | 30 | 6 | |||||||||||||||
| KmBA9jlqTfGLkF2M2bnUIg | Youn, Kong Duk | 25 | 25세 | single | Chemulpo | 1/23/1904 | Gaelic | 윤공덕 | NULL | 윤Kong Duk | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 윤공득,윤공독 | 88 | NULL | NULL | NULL | 1904-01-23 | NULL | NULL | 42 | Youn | 윤 | Kong Duk | 공덕 | 25 | 7 | |||||||||||||||||
| klZycMSsRmWCktOtKwhywQ | Kim, Man Soo | 29 | 29세 | widower | Poo Poong Dong | 9/16/1904 | Gaelic | 김만수 | 김만수 | NULL | 김만수 | 2025-09-14 05:57:44 | 2025-12-10 04:59:05 | NULL | NULL | 가장 | NULL | 김채순(부인), 김씨 부인, 김씨 부인, 김씨 부인, 김문숙(아들), 김문숙(아들), 김문숙 (아들 영봉)(아들), 김풍서(딸), 김풍서(딸) | 1904-09-16 | NULL | NULL | 2094 | Kim | 김 | Man Soo | 만수 | 29 | 7 | ||||||||||||||||
| kLW1s3fXRu-.wJOvrslNYQ | Choi, Il Sun | 36 | 36세 | widower | Dai Sam Li | 5/18/1905 | Mongolia | 최일선 | 최일선 | NULL | 최Il Sun | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-05-18 | NULL | NULL | 2093 | Choi | 최 | Il Sun | 일선 | 36 | 14 | ||||||||||||||||
| KLf-rIDfTDGFLy8ur33hFA | Ye, Pong Oh | 24 | 24세 | single | Koo Am | 5/29/1905 | China | 이봉오 | NULL | 예Pong Oh | 2025-09-14 05:57:46 | 2025-12-10 04:33:32 | 예봉우,예봉호 | 85 | 가장 | NULL | 이봉오의 처(부인), 이봉오의 처(부인), 이강화(아버지), 이순명(아들) | 1905-05-29 | NULL | NULL | 323 | Ye | 이 | Pong Oh | 봉오 | 24 | 3 | |||||||||||||||||
| KLA5jXwNTFuQIA0uKjuykA | Choi, Soon Kil | 32 | 32세 | widower | Don Pang Kol | 6/13/1905 | Doric | 최순길 | NULL | 최Soon Kil | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최순기,최순걸 | 90 | NULL | NULL | NULL | 1905-06-13 | NULL | NULL | 2092 | Choi | 최 | Soon Kil | 순길 | 32 | 6 |