컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| aEnBWthdRVaEjvvFnP8zsQ | Chung, Won Chai | 24 | 24세 | married | Pang Kol | 2/13/1905 | Siberia | 정원재 | 정원재 | 정원 Chai | 충북 진천군 덕산면 상수리 방골 | 2025-06-03 00:00:00 | 정원재 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/CrOJjqGJAf | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 961 | Chung | 정 | Won Chai | 원재 | 24 | 17 | |||||||||||||
| aEfInWSlTyCwc.p-LT0mDw | Han, Kyeng Soh | 22 | 22세 | single | Sam Wha | 1/16/1904 | Korea | 한경서 | NULL | 한Kyeng Soh | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한경소,한경서 | 88 | NULL | NULL | NULL | 1904-01-16 | NULL | NULL | 213 | Han | 한 | Kyeng Soh | 경서 | 22 | 9 | |||||||||||||||||
| AefHqoCZRpeAg4hE2JI7ng | Ye, Mal Yong | 22 | 22세 | single | Cha Chun Dong | 11/2/1904 | Manchuria | 이말용 | NULL | 예Mal Yong | 2025-09-14 05:57:46 | 2025-12-10 04:33:32 | 예말룡,예말영 | 87 | 가장 | NULL | 이말용의 처(부인), 이화옥(딸), 이화옥(딸) | 1904-11-02 | NULL | NULL | 960 | Ye | 이 | Mal Yong | 말용 | 22 | 12 | |||||||||||||||||
| aEeBzh9XRxaD.j5CLffWgQ | Oh, Moo Sung, son 2 | 4 | 4세 | single | Kam San | 1/26/1905 | Korea | 오자2 | 오자2 | NULL | 오son 2 | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | 아들 | NULL | NULL | 1905-01-26 | NULL | NULL | 959 | Oh | 오 | Moo Sung | 자2 | 4 | 9 | ||||||||||||||||
| AeDkV45bQ2iWoPYdu9PoUA | Chun, Kyung Nak, daughter | 2 | 2세 | single | Seoul | 5/6/1904 | Doric | 전녀 | 전녀 | NULL | 전daughter | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | 딸 | NULL | NULL | 1904-05-06 | NULL | NULL | 18 | Chun | 전 | Kyung Nak | 녀 | 2 | 6 | ||||||||||||||||
| AeBCk8AYT5iLiOgVFtxdiQ | Pak, Chung Han | 26 | 26세 | single | Seoul | 1/9/1904 | America Maru | 박정한 | 박정한 | NULL | 박Chung Han | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 박의선(부인) | 1904-01-09 | NULL | NULL | 18 | Pak | 박 | Chung Han | 정한 | 26 | 1 | ||||||||||||||||
| Ae9u.iylRUKj-B9wNp74Ig | Youn, Chong Keun | 19 | 19세 | widower | Ham Sil | 12/28/1903 | Coptic | 윤종근 | 윤종근 | NULL | 윤Chong Keun | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-12-28 | NULL | NULL | 958 | Youn | 윤 | Chong Keun | 종근 | 19 | 4 | ||||||||||||||||
| adz-7n3VQm6NTTm8KGzIMQ | An, Do Heung | 20 | 20세 | single | Won San | 10/5/1903 | Siberia | 안도흥 | NULL | 안Do Heung | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 안도형,안도헝 | 90 | NULL | NULL | NULL | 1903-10-05 | NULL | NULL | 160 | An | 안 | Do Heung | 도흥 | 20 | 17 | |||||||||||||||||
| aDCqy9G9Q5CwNXeb0lwwxg | Soh, Kwan Ye | 22 | 22세 | single | Pak Sil | 5/18/1905 | Mongolia | 서관예 | 서관예 | NULL | 서Kwan Ye | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-05-18 | NULL | NULL | 957 | Soh | 서 | Kwan Ye | 관예 | 22 | 14 | ||||||||||||||||
| AD1rR.A0TZ-5RMeqk75k.g | Ye, Pyeng Choon, sister (Ai Ki) | 11 | 11세 | single | Ka Myen Li | 4/13/1905 | Korea | 이평춘 | NULL | 예sister (Ai Ki) | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예펑춘,예병춘 | 88 | 자매 | Ai Ki | 아기 | 1905-04-13 | NULL | NULL | 956 | Ye | 이 | Pyeng Choon | 평춘 | 11 | 9 | |||||||||||||||||
| AcN9oi5DSWKpIMYxMYOSSQ | Kim, Sang Yun, wife (Pau See) | 37 | 37세 | married | Chemulpo | 3/30/1903 | Gaelic | 김상윤 | NULL | 김wife (Pau See) | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김상운,김상연 | 90 | 부인 | Pau See | 박시 | 1903-03-30 | NULL | NULL | 42 | Kim | 김 | Sang Yun | 상윤 | 37 | 7 | |||||||||||||||||
| aCE0QazQRryE41y.yFdpkA | Kang, Tai Suk | 35 | 35세 | married | Koo Yong Dong | 8/22/1904 | Coptic | 강태숙 | 강태숙 | NULL | 강Tai Suk | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-08-22 | NULL | NULL | 955 | Kang | 강 | Tai Suk | 태숙 | 35 | 4 | ||||||||||||||||
| aCaslu0fSZiI6TnKVe9FsQ | Chung, Nam Do | 27 | 27세 | single | Chip Mok Dong | 2/2/1905 | Coptic | 정남도 | 정남도 | NULL | 정Nam Do | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 954 | Chung | 정 | Nam Do | 남도 | 27 | 4 | ||||||||||||||||
| aC0CV9HtRrmEM-ppkCIU7A | No, Soo Myeng | 22 | 22세 | single | Dong Oh Ri | 4/13/1905 | Korea | 노수명 | NULL | NoSoo Myeng | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 노수멍,노수맹 | 88 | NULL | NULL | NULL | 1905-04-13 | NULL | NULL | 953 | No | 노 | Soo Myeng | 수명 | 22 | 9 | |||||||||||||||||
| ABqOomEIS5a8hHGhnbT6CQ | Ye, Choon Kil | 33 | 33세 | married | Sam Chuk | 3/30/1903 | Gaelic | 이춘길 | NULL | 예Choon Kil | 2025-09-14 05:57:46 | 2025-12-06 16:53:31 | 예춘킬,예천길 | 90 | 가장 | NULL | 이영화(부인), 이민식(부인) | 1903-03-30 | NULL | NULL | 952 | Ye | 이 | Choon Kil | 춘길 | 33 | 7 | |||||||||||||||||
| abNJMhwZS8qqbDgtz9nsBA | Kim, Won Po | 31 | 31세 | widower | Cho Choong Li | 1/6/1905 | Doric | 김원포 | NULL | 김Won Po | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김원보,김완포 | 90 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 951 | Kim | 김 | Won Po | 원포 | 31 | 6 | |||||||||||||||||
| aBKzBG9GT.u9L.oBhX6vnQ | Han, Doo Sam | 19 | 19세 | single | An Pyen | 7/11/1904 | America Maru | 한두삼 | NULL | 한Doo Sam | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한도삼,한두참 | 92 | NULL | NULL | NULL | 1904-07-11 | NULL | NULL | 950 | Han | 한 | Doo Sam | 두삼 | 19 | 1 | |||||||||||||||||
| aBHHJlxrQ0CIWTI773Fv8A | Whang, Seung Mo | 19 | 19세 | married | Kwang Ju | 2/18/1904 | Doric | 황승모 | 황승모 | NULL | 황Seung Mo | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-02-18 | NULL | NULL | 949 | Whang | 황 | Seung Mo | 승모 | 19 | 6 | ||||||||||||||||
| abFwkL10TnW2cerjs.r0sg | Cha, Chei Man | 21 | 21세 | widower | Chun Sa Chang | 11/18/1904 | Korea | 차제만 | NULL | 차Chei Man | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 차채만,차체만 | 87 | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 948 | Cha | 차 | Chei Man | 제만 | 21 | 9 | |||||||||||||||||
| aAXri.GXSqakTpzGqiNCIw | Ye, Won Joon, daughter (Whah Sil) | 7 | 7세 | single | Pyeng Yang | 1/9/1904 | America Maru | 이원준 | NULL | 예daughter (Whah Sil) | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예원존,예완준 | 88 | 딸 | Whah Sil | 화실 | 1904-01-09 | NULL | NULL | 58 | Ye | 이 | Won Joon | 원준 | 7 | 1 |