컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3ZnmFHwbSK6rxJ4H40AHfg | Choi, Wha Sam | 17 | 17세 | single | Ta Am Dong | 11/2/1904 | Manchuria | 최화삼 | NULL | 최Wha Sam | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | 최화심,최와삼 | 85 | 가장 | NULL | 최태진(아들), 최태진(딸) | 1904-11-02 | NULL | NULL | 351 | Choi | 최 | Wha Sam | 화삼 | 17 | 12 | |||||||||||||||||
| 3Zd-brj2RPm50De7rcyBZg | Soh, Cher Hong | 23 | 23세 | widower | Chun Nam | 1/23/1904 | Gaelic | 서철홍 | NULL | 서Cher Hong | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 서체홍,서철황 | 80 | NULL | NULL | NULL | 1904-01-23 | NULL | NULL | 350 | Soh | 서 | Cher Hong | 철홍 | 23 | 7 | |||||||||||||||||
| 3ympNfDeQiu-6Xyk9FQlJA | Kim, Keuk Choong | 24 | 24세 | married | Kaik Kui | 12/24/1904 | China | 김극중 | NULL | 김Keuk Choong | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김극충,김국중 | 85 | NULL | NULL | NULL | 1904-12-24 | NULL | NULL | 349 | Kim | 김 | Keuk Choong | 극중 | 24 | 3 | |||||||||||||||||
| 3YFNyEtER4KN-OAylsEioA | Kim, Sung Cho | 32 | 32세 | single | Doon Chun | 11/24/1904 | Gaelic | 김성조 | NULL | 김Sung Cho | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김성초,김승조 | 85 | NULL | NULL | NULL | 1904-11-24 | NULL | NULL | 348 | Kim | 김 | Sung Cho | 성조 | 32 | 7 | |||||||||||||||||
| 3YAItUb7SLeouycTbZHU5w | Cho, Young Chin | 31 | 31세 | widower | Pil Dong | 8/22/1904 | Coptic | 조영진 | NULL | 조Young Chin | 2025-09-14 05:57:43 | 2025-12-10 04:59:06 | 조용진,조영천 | 90 | 가장 | NULL | 최씨 부인, 조씨 부인 | 1904-08-22 | NULL | NULL | 347 | Cho | 조 | Young Chin | 영진 | 31 | 4 | |||||||||||||||||
| 3XM8MeBcQRS32uAyGk3haw | Kim, Chai Pong | 26 | 26세 | single | Soo Sung | 2/2/1905 | Coptic | 김재봉 | NULL | 김Chai Pong | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김채봉,김재방 | 85 | 가장 | NULL | 김봉춘(부인), 김도관(아들) | 1905-02-02 | NULL | NULL | 346 | Kim | 김 | Chai Pong | 재봉 | 26 | 4 | |||||||||||||||||
| 3xJkPYiwToCUUymbeJ3qGA | Kim, Chin Yong, son (Sang Ka Ma) | 1 | 1세 | single | Seoul, Myung Dong | 5/20/1904 | Siberia | 김진용 | NULL | 김son (Sang Ka Ma) | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김진룡,김찬용 | 85 | 아들 | Sang Ka Ma | 상가마 | 1904-05-20 | NULL | NULL | 215 | Kim | 김 | Chin Yong | 진용 | 1 | 17 | |||||||||||||||||
| 3X-PyAbeRyiDiF.QTQ6emQ | Pak, Seung Chai | 40 | 40세 | married | Seoul, You Dong | 5/20/1904 | Siberia | 박승채 | NULL | 박Seung Chai | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | 박승재,박승체 | 85 | 가장 | NULL | 박애라(아들) | 1904-05-20 | NULL | NULL | 345 | Pak | 박 | Seung Chai | 승채 | 40 | 17 | |||||||||||||||||
| 3WuZSD6ATQWHnfeFqjzthA | Song, In Sik | 34 | 34세 | married | San Dong | 1/26/1905 | Korea | 송인식 | 송인식 | NULL | 송In Sik | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 344 | Song | 송 | In Sik | 인식 | 34 | 9 | ||||||||||||||||
| 3WuoCr8XRVSawBIfNowbNQ | Han, Il Seung, wife | 32 | 32세 | married | Mi Ryong Do | 12/9/1904 | Mongolia | 한처 | 한처 | NULL | 한wife | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-12-09 | NULL | NULL | 343 | Han | 한 | Il Seung | 처 | 32 | 14 | ||||||||||||||||
| 3wtOiy29R.WbwV9lzALTnA | Choi, Choon Hyen | 36 | 36세 | widower | Kwang Choo | 7/30/1904 | Doric | 최춘현 | NULL | 최Choon Hyen | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최춘헌,최준현 | 85 | NULL | NULL | NULL | 1904-07-30 | NULL | NULL | 153 | Choi | 최 | Choon Hyen | 춘현 | 36 | 6 | |||||||||||||||||
| 3WT4wB9US8yolLtDZpg30w | Pak, Seung Keun, wife | 37 | 37세 | married | Won San | 2/8/1904 | China | 박처 | 박처 | NULL | 박wife | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-02-08 | NULL | NULL | 160 | Pak | 박 | Seung Keun | 처 | 37 | 3 | ||||||||||||||||
| 3WkRXSv2SQWazFs4w-zuSA | Kim, Heung Yong | 23 | 23세 | single | Chung Do, Koh Nap | 6/25/1904 | Gaelic | 김흥용 | NULL | 김Heung Yong | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김흥룡,김응용 | 90 | NULL | NULL | NULL | 1904-06-25 | NULL | NULL | 342 | Kim | 김 | Heung Yong | 흥용 | 23 | 7 | |||||||||||||||||
| 3Wfu-PeCT8KuCTdr0FoJkQ | Kang, Chin Oh | 18 | 18세 | widower | Fusan | 10/15/1903 | Coptic | 강진오 | NULL | 강Chin Oh | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 강진호,강진욱 | 85 | NULL | NULL | NULL | 1903-10-15 | NULL | NULL | 16 | Kang | 강 | Chin Oh | 진오 | 18 | 4 | |||||||||||||||||
| 3vzPlMZgSoenWkb5U9ClRg | Kim, Pyeng Cho | 37 | 37세 | widower | Ko Seung Ye | 3/31/1905 | Manchuria | 김평조 | NULL | 김Pyeng Cho | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김병조,김평초 | 85 | 가장 | NULL | 김현중(부인), 김봉상(부인), 김봉상(아들), 김봉상(아들), 김봉상(아들) | 1905-03-31 | NULL | NULL | 341 | Kim | 김 | Pyeng Cho | 평조 | 37 | 12 | |||||||||||||||||
| 3vr1LtMJRJGV1Tu0buVQGw | Choi, Ki Hong | 28 | 28세 | widower | Il Tong Me | 7/8/1904 | Mongolia | 최기홍 | NULL | 최Ki Hong | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최기홍,최기완 | 90 | NULL | NULL | NULL | 1904-07-08 | NULL | NULL | 340 | Choi | 최 | Ki Hong | 기홍 | 28 | 14 | |||||||||||||||||
| 3vNehbqSTeSWLO2upIBxYw | Kim, Chai Sin | 29 | 29세 | single | Mi Sol Ri | 5/29/1905 | China | 김재신 | NULL | 김Chai Sin | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김채신,김재선 | 85 | 가장 | NULL | 김재신의 처(부인), 김재신의 처(부인), 김재신의 처(부인), 김재신의 처(부인), 김태영(아들), 김원찬(아들), 김태영(아들), 김유성(딸), 김원찬(딸), 김중길(딸), 김 | 1905-05-29 | NULL | NULL | 339 | Kim | 김 | Chai Sin | 재신 | 29 | 3 | |||||||||||||||||
| 3Vc4Ho4gS1qJ9QVbGpCyGQ | Kim, Won Soh | 24 | 24세 | married | Chung Choo | 10/5/1903 | Siberia | 김원서 | NULL | 김Won Soh | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김원소,김원석 | 80 | NULL | NULL | NULL | 1903-10-05 | NULL | NULL | 23 | Kim | 김 | Won Soh | 원서 | 24 | 17 | |||||||||||||||||
| 3v4Dvhq9TI6nSKf8pjlvUA | Sin, Choong Hyen | 25 | 25세 | widower | Kang Sun Ching | 4/13/1905 | Korea | 신중현 | NULL | 신Choong Hyen | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 신충현,신중헌 | 85 | NULL | NULL | NULL | 1905-04-13 | NULL | NULL | 338 | Sin | 신 | Choong Hyen | 중현 | 25 | 9 | |||||||||||||||||
| 3UUDYbkkQFS1zVxjriBLJg | Pak, Sung Hwan | 24 | 24세 | widower | Pa Arp | 8/22/1904 | Coptic | 박성환 | 박성환 | NULL | 박Sung Hwan | 2025-09-14 05:57:45 | 2025-12-10 04:34:41 | NULL | NULL | 가장 | NULL | 박성환의 처(부인) | 1904-08-22 | NULL | NULL | 337 | Pak | 박 | Sung Hwan | 성환 | 24 | 4 |