컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| hhQDaiONSxqkqVQ4OszJjw | Um, Yong Surp | 32 | 32세 | married | Sul To | 3/30/1904 | Korea | 엄용섭 | NULL | 엄Yong Surp | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 엄용습,엄룡섭 | 85 | NULL | NULL | NULL | 1904-03-30 | NULL | NULL | 1774 | Um | 엄 | Yong Surp | 용섭 | 32 | 9 | |||||||||||||||||
| hHPVvgzAT.WrXGwWBFHXwA | An, Chun Seung | 22 | 22세 | single | 인천 | 4/14/1903 | China | 안춘승 | 안춘승 | 2025-03-03 00:00:00 | 안Chun Seung | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-04-14 | NULL | NULL | 188 | An | 안 | Chun Seung | 춘승 | 22 | 3 | ||||||||||||||||
| hHmilMnlQSCrEbw1Bd82tw | Pak, Kyeng Choon | 25 | 25세 | single | Koon Reun, So Chun | 5/20/1904 | Siberia | 박경춘 | 박경춘 | NULL | 박Kyeng Choon | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 박애라(아들) | 1904-05-20 | NULL | NULL | 1773 | Pak | 박 | Kyeng Choon | 경춘 | 25 | 17 | ||||||||||||||||
| hHjmoQwDRwib4xUAqC3jNw | Kang, Young Seung | 18 | 18세 | married | Ye Hyen | 6/13/1905 | Doric | 강영승 박원신 | 강영승 | 강영승 | 2025-03-30 00:00:00 | 강영승 박원신 | 애국지사 | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 박원신(부인), 강영승(어머니), 강영승(형제), 강영승(자매) | 1905-06-13 | NULL | NULL | 463 | Kang | 강 | Young Seung | 영승 | 18 | 6 | ||||||||||||||
| hHi9u8VZSyi7HnpDUi8rpg | Kim, Young Sik, daughter (Sung Yea) | 6 mo | 6 mo세 | single | Sin Chon Dong | 5/18/1905 | Mongolia | 김영식 | NULL | 김daughter (Sung Yea) | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김영직,김용식 | 90 | 딸 | Sung Yea | 성여 | 1905-05-18 | NULL | NULL | 598 | Kim | 김 | Young Sik | 영식 | NULL | 14 | |||||||||||||||||
| hhhMO.68TI2LaxjZ309Hlg | Ye, Il Whan | 23 | 23세 | married | Yong Soo Pyeng | 4/24/1905 | Coptic | 이일환 | NULL | 예Il Whan | 2025-09-14 05:57:46 | 2025-12-10 04:33:32 | 예일완,예일한 | 85 | 가장 | NULL | 염덕연(부인), 이일환의 처(부인), 염덕윤(아들) | 1905-04-24 | NULL | NULL | 1772 | Ye | 이 | Il Whan | 일환 | 23 | 4 | |||||||||||||||||
| hhhjyFZTQoGDhg-BwcTPyA | Ye, Chung Woo | 33 | 33세 | married | Eun Chai Dong | 2/25/1905 | Mongolia | 이정우 | 이정우 | NULL | 예Chung Woo | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | 가장 | NULL | 이삼수(부인), 이선기(부인) | 1905-02-25 | NULL | NULL | 1771 | Ye | 예 | Chung Woo | 정우 | 33 | 14 | ||||||||||||||||
| hhGx2usITeqVjRCAuyo59A | Song, Young Kyerl | 24 | 24세 | married | Che The Perl | 11/18/1904 | Korea | 송영걸 | NULL | 송Young Kyerl | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 송영결,송영철 | 80 | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 1770 | Song | 송 | Young Kyerl | 영걸 | 24 | 9 | |||||||||||||||||
| hhGELqctSr-zR1y2PLDKzA | Chang, Han Young | 21 | 21세 | single | Chun Dong | 1/26/1905 | Korea | 장한영 | NULL | 장Han Young | 2025-09-14 05:57:42 | 2025-12-06 16:53:31 | 장한용,장항영 | 90 | 가장 | NULL | 장군배(어머니) | 1905-01-26 | NULL | NULL | 52 | Chang | 장 | Han Young | 한영 | 21 | 9 | |||||||||||||||||
| HH4nPHkLTWi9D.qBWjRFcg | Ye, Se Won | 24 | 24세 | widower | Jei Choo | 11/2/1903 | Korea | 이세원 | NULL | 예Se Won | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예서원,예세완 | 85 | NULL | NULL | NULL | 1903-11-02 | NULL | NULL | 146 | Ye | 이 | Se Won | 세원 | 24 | 9 | |||||||||||||||||
| hh1QpVOQTsyMt--bGQs.Bw | Chun, Hern Yong | 27 | 27세 | married | Sin Duk Li | 1/6/1905 | Doric | 전헌용 | NULL | 전Hern Yong | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 천헌용,전현용 | 80 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 1769 | Chun | 전 | Hern Yong | 헌용 | 27 | 6 | |||||||||||||||||
| Hh-F5j45QqGvLO1sfm0jlQ | Cho, Young Ok | 27 | 27세 | widower | Chei Nai | 5/18/1905 | Mongolia | 조영옥 | 조영옥 | NULL | 조Young Ok | 2025-09-14 05:57:43 | 2025-12-10 04:34:41 | NULL | NULL | 가장 | NULL | 조영옥의 처(부인), 조원두(어머니), 조원두(딸), 조원두(자매) | 1905-05-18 | NULL | NULL | 1768 | Cho | 조 | Young Ok | 영옥 | 27 | 14 | ||||||||||||||||
| HgZJeCbLSiKbhMkBcghDtA | Han, Yong Sung | 20 | 20세 | married | Sang Hai | 11/18/1904 | Korea | 한용성 | NULL | 한Yong Sung | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한룡성,한용승 | 90 | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 1767 | Han | 한 | Yong Sung | 용성 | 20 | 9 | |||||||||||||||||
| HGvN9UqNSOWhvRE4nMfJVg | Song, Sun Wook | 27 | 27세 | married | An Ark | 4/14/1903 | China | 송선욱 | NULL | 송Sun Wook | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 송선운,송선우 | 85 | NULL | NULL | NULL | 1903-04-14 | NULL | NULL | 180 | Song | 송 | Sun Wook | 선욱 | 27 | 3 | |||||||||||||||||
| Hgvigmw8Q0atNOfmawZ7Ew | Im, Keun Pok | 17 | 17세 | single | Chung Choo | 9/21/1903 | Doric | 임근복 | NULL | 임Keun Pok | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 임근박,임근봉 | 85 | NULL | NULL | NULL | 1903-09-21 | NULL | NULL | 23 | Im | 임 | Keun Pok | 근복 | 17 | 6 | |||||||||||||||||
| HGv4sI5uS6GVr30z4mL7ew | Pak, Duk Soon, daughter 3 | 1 | 1세 | single | In Chun | 3/30/1904 | Korea | 박녀3 | 박녀3 | NULL | 박daughter 3 | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | 딸 | NULL | NULL | 1904-03-30 | NULL | NULL | 81 | Pak | 박 | Duk Soon | 녀3 | 1 | 9 | ||||||||||||||||
| HGu7DgzcQiOB9SmqUkEXfg | Yang, Kook Hyen | 40 | 40세 | widower | Sa Ker Ri | 1/26/1905 | Korea | 양국현 | NULL | 양Kook Hyen | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 양국헌,양국형 | 85 | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 306 | Yang | 양 | Kook Hyen | 국현 | 40 | 9 | |||||||||||||||||
| HGot2UY-RkCzx3pmI.mszw | Ye, Man Yong | 28 | 28세 | married | Ong Sing Kol | 3/10/1905 | China | 이만용 | 이만용 | NULL | 예Man Yong | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | 가장 | NULL | 이만용(부인), 이만용(자매) | 1905-03-10 | NULL | NULL | 1371 | Ye | 예 | Man Yong | 만용 | 28 | 3 | ||||||||||||||||
| hgipeqnyQzWFAFMOdaxA6w | Koon, Choon Kiu | 40 | 40세 | widower | Choo Nam | 12/9/1904 | Mongolia | 구춘규 | NULL | KoonChoon Kiu | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 구춘기,구천규 | 80 | NULL | NULL | NULL | 1904-12-09 | NULL | NULL | 1096 | Koon | 구 | Choon Kiu | 춘규 | 40 | 14 | |||||||||||||||||
| hGhpedmASGiwca-XoECJ9A | Chang, Won Yer, wife | 27 | 27세 | married | Pam Ye | 6/1/1904 | Coptic | 장처 | 장처 | NULL | 장wife | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-06-01 | NULL | NULL | 553 | Chang | 장 | Won Yer | 처 | 27 | 4 |