컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| zCMytBz3Rfea-8YP7PlLZg | Kim, You Ho, son | 2 | 2세 | single | Chemulpo | 1/13/1903 | Gaelic | 김자 | 김자 | NULL | 김son | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | 아들 | NULL | NULL | 1903-01-13 | NULL | NULL | 42 | Kim | 김 | You Ho | 자 | 2 | 7 | ||||||||||||||||
| ZcHyseHVTuK7BeQSYGQGCA | Youn, Sang Poong, wife | 25 | 25세 | married | Nak Saing Li | 8/22/1904 | Coptic | 윤처 | 윤처 | NULL | 윤wife | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-08-22 | NULL | NULL | 79 | Youn | 윤 | Sang Poong | 처 | 25 | 4 | ||||||||||||||||
| zcBIsVPOR523k-z8lrUDNA | Ye, Young Paik | 27 | 27세 | widower | Ho Dong | 1/23/1904 | Gaelic | 이영백 | NULL | 예Young Paik | 2025-09-14 05:57:46 | 2025-12-06 16:53:31 | 예영박,예영배 | 85 | 가장 | NULL | 이기정(부인), 이기정(딸) | 1904-01-23 | NULL | NULL | 3423 | Ye | 이 | Young Paik | 영백 | 27 | 7 | |||||||||||||||||
| ZBXEusIjRi6BPz4qSJ6vvQ | Kang, Seung Yong | 40 | 40세 | widower | Kwang Chun | 2/13/1905 | Siberia | 강승용 | 강승용 | NULL | 강Seung Yong | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 1523 | Kang | 강 | Seung Yong | 승용 | 40 | 17 | ||||||||||||||||
| zbualx0MSweRePlH8xa1-A | Chai, Man Choon | 17 | 17세 | single | Pook Chon | 4/13/1905 | Korea | 채만춘 | NULL | ChaiMan Choon | 2025-09-14 05:57:42 | 2025-12-06 16:53:31 | 채만준,채만천 | 90 | 가장 | NULL | 채만수(부인), 채근열(부인), 채만수(어머니) | 1905-04-13 | NULL | NULL | 223 | Chai | 채 | Man Choon | 만춘 | 17 | 9 | |||||||||||||||||
| zbQ.-cI7QLGUmHadaMypkg | Han, Po You | 27 | 27세 | married | Dai Koo | 4/26/1904 | China | 한보유 | NULL | 한Po You | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한포유,한부유 | 85 | NULL | NULL | NULL | 1904-04-26 | NULL | NULL | 914 | Han | 한 | Po You | 보유 | 27 | 3 | |||||||||||||||||
| ZBN5DEe6T-yqRk3vABaICA | Im, Sa Won | 24 | 24세 | widower | Chong An | 11/18/1904 | Korea | 임사원 | NULL | 임Sa Won | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 임사웅,임사운 | 95 | NULL | NULL | NULL | 1904-11-18 | NULL | NULL | 3422 | Im | 임 | Sa Won | 사원 | 24 | 9 | |||||||||||||||||
| ZBIAktSITrKBZ7tGBnHwpw | Kim, Pang Woo | 28 | 28세 | widower | Mok Sang | 4/13/1905 | Korea | 김방우 | NULL | 김Pang Woo | 2025-09-14 05:57:44 | 2025-12-10 04:59:05 | 김방운,김봉우 | 90 | 가장 | NULL | 김치복(부인), 김씨 부인, 김기주(부인), 김영육(어머니), 김기주(아들), 김성배 아들 백용(아들), 김치화(아들), 김치복(딸) | 1905-04-13 | NULL | NULL | 3421 | Kim | 김 | Pang Woo | 방우 | 28 | 9 | |||||||||||||||||
| zBg22N.NQ1GRR4hDmeJrgA | Kim, Choon Sam | 29 | 29세 | married | Pook Chang Dong | 2/13/1905 | Siberia | 김춘삼 | 김춘삼 | NULL | 김Choon Sam | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 536 | Kim | 김 | Choon Sam | 춘삼 | 29 | 17 | ||||||||||||||||
| ZbfTUR4uRQ2vn7tW7vxbFA | Ye, Kong Sam, mother | 65 | 65세 | widow | Yang Duk | 2/18/1904 | Doric | 이공삼 | NULL | 예mother | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예곡삼,예광삼 | 85 | 어머니 | NULL | NULL | 1904-02-18 | NULL | NULL | 1675 | Ye | 이 | Kong Sam | 공삼 | 65 | 6 | |||||||||||||||||
| ZbC70Mv4Rh2z9-vhtwkefw | Kim, Chong Han | 31 | 31세 | married | Tong Sil | 6/25/1904 | Gaelic | 김종한 | 김종한 | NULL | 김Chong Han | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-06-25 | NULL | NULL | 3420 | Kim | 김 | Chong Han | 종한 | 31 | 7 | ||||||||||||||||
| Zb5yGvz0R8ypENpK9uPffw | Puen, Soon Yong | 30 | 30세 | married | Kang Wha | 4/14/1903 | China | 편순용 | NULL | PuenSoon Yong | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 변순용,표순용 | 80 | NULL | NULL | NULL | 1903-04-14 | NULL | NULL | 314 | Puen | 편 | Soon Yong | 순용 | 30 | 3 | |||||||||||||||||
| zB2o-mBwRNWtWaGHjBQx.g | Ye, Kyeng Sam | 30 | 30세 | married | Kal Pang Dong | 12/24/1904 | China | 이경삼 | 이경삼 | NULL | 예Kyeng Sam | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | NULL | NULL | NULL | 1904-12-24 | NULL | NULL | 3419 | Ye | 예 | Kyeng Sam | 경삼 | 30 | 3 | ||||||||||||||||
| zb0uXp1eRvmR08O-gjiDcA | Ye, Chang Paik | 23 | 23세 | single | Chul San, Tong Su Dong | 5/20/1904 | Siberia | 이창백 | NULL | 예Chang Paik | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | 예창박,예창배 | 85 | 가장 | NULL | 이창근(부인), 이춘익(부인), 이경식(부인), 이창근(아들), 이춘익(아들), 이창근(아들) | 1904-05-20 | NULL | NULL | 3418 | Ye | 이 | Chang Paik | 창백 | 23 | 17 | |||||||||||||||||
| zaOZ2g9gRMOyeU29xGEE2g | Pak, Eung Seh | 23 | 23세 | married | Chul Won | 3/30/1903 | Gaelic | 박응세 | NULL | 박Eung Seh | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박응석,박응서 | 95 | NULL | NULL | NULL | 1903-03-30 | NULL | NULL | 353 | Pak | 박 | Eung Seh | 응세 | 23 | 7 | |||||||||||||||||
| zaAPei3hStuq8nOwydD.0A | You, Ki Choon, daughter (Yern Chun) | 4 | 4세 | single | Dong Mer Ki | 12/9/1904 | Mongolia | 유기춘 | NULL | 유daughter (Yern Chun) | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 유기준,유기천 | 90 | 딸 | Yern Chun | 연춘 | 1904-12-09 | NULL | NULL | 1640 | You | 유 | Ki Choon | 기춘 | 4 | 14 | |||||||||||||||||
| Zaa4FUX8QamHp1R1VkNSiQ | Cho, Chong Che | 20 | 20세 | single | Kil Nam Ni | 4/17/1904 | America Maru | 조종제 | NULL | 조Chong Che | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 조정제,조종재 | 85 | NULL | NULL | NULL | 1904-04-17 | NULL | NULL | 3417 | Cho | 조 | Chong Che | 종제 | 20 | 1 | |||||||||||||||||
| zA6z1q7PSTOnJpwtInRpXw | Pak, Sung Sam | 37 | 37세 | widower | Ko Mo Dong | 3/31/1905 | Manchuria | 박성삼 | 박성삼 | NULL | 박Sung Sam | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 박동수 부인 복순예(부인), 박용암(부인), 박용암(아들), 박용암(아들) | 1905-03-31 | NULL | NULL | 3416 | Pak | 박 | Sung Sam | 성삼 | 37 | 12 | ||||||||||||||||
| Za6AqbXaTxiS-AIy.kusQQ | Hong, Pyeng Ik, son (Hak Sung) | 3 | 3세 | single | Choo Chun | 5/29/1905 | China | 홍평익 | NULL | 홍son (Hak Sung) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 홍병익,홍평직 | 85 | 아들 | Hak Sung | 학성 | 1905-05-29 | NULL | NULL | 1095 | Hong | 홍 | Pyeng Ik | 평익 | 3 | 3 | |||||||||||||||||
| za5e-HsgTc2ztxbGGqrPhw | Cho, In Soo | 40 | 40세 | widower | Chung Yang | 3/30/1903 | Gaelic | 조인수 | 조인수 | NULL | 조In Soo | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-03-30 | NULL | NULL | 3415 | Cho | 조 | In Soo | 인수 | 40 | 7 |