컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bjV1kAn6TcG0ypVrn7-eRQ | Kim, Young Cho | 24 | 24세 | married | Yang Chi | 6/1/1904 | Coptic | 김영조 | NULL | 김Young Cho | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김용조,김영초 | 95 | 가장 | NULL | 김국경(부인), 김국경(딸) | 1904-06-01 | NULL | NULL | 1104 | Kim | 김 | Young Cho | 영조 | 24 | 4 | |||||||||||||||||
| bjQy4HRRQEKoGeVUMujeCg | Pak, Man Keum | 29 | 29세 | widower | Kong Choo | 5/6/1904 | Doric | 박만금 | NULL | 박Man Keum | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박만검,박만급 | 95 | NULL | NULL | NULL | 1904-05-06 | NULL | NULL | 176 | Pak | 박 | Man Keum | 만금 | 29 | 6 | |||||||||||||||||
| BJkZ3mKdQFmPcnvGXS13WQ | Ye, Kiu Surp | 40 | 40세 | widower | Sa Dong | 11/18/1904 | Korea | 이규섭 | NULL | 예Kiu Surp | 2025-09-14 05:57:46 | 2025-12-06 16:53:31 | 예기섭,예구섭 | 80 | 가장 | NULL | 이문일(형제) | 1904-11-18 | NULL | NULL | 62 | Ye | 이 | Kiu Surp | 규섭 | 40 | 9 | |||||||||||||||||
| bjjzMnEZSM6Fwk-9L1UX0A | Ye, Young Wha, wife (Wong, San Sui) | 28 | 28세 | married | Chuk Sung | 3/30/1903 | Gaelic | 이영화 | NULL | 예San Sui) | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예용화,예영와 | 85 | 부인 | Wong, San Sui | 왕산수 | 1903-03-30 | NULL | NULL | 865 | Ye | 이 | Young Wha | 영화 | 28 | 7 | |||||||||||||||||
| bjgyGXnbTtix.Hc8LuOzkQ | Han, Chai Myeng | 35 | 35세 | widower | Cho Dong | 12/9/1904 | Mongolia | 한재명 | NULL | 한Chai Myeng | 2025-09-14 05:57:43 | 2025-12-10 04:34:46 | 한채명,한차명 | 85 | 가장 | NULL | 한재명의 처(부인), 한기찬(아들), 한자2(아들) | 1904-12-09 | NULL | NULL | 515 | Han | 한 | Chai Myeng | 재명 | 35 | 14 | |||||||||||||||||
| BJEpGVXFS5ihJ0tNs91Rjg | An, Seung Ho | 23 | 23세 | married | Chang Chin | 5/20/1904 | Siberia | 안승호 | 안승호 | NULL | 안Seung Ho | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-05-20 | NULL | NULL | 1103 | An | 안 | Seung Ho | 승호 | 23 | 17 | ||||||||||||||||
| bjEmnItgTMyaUDItysdvmA | Ye, Chei He | 19 | 19세 | single | Na Choo, Yang Dong | 7/8/1904 | Mongolia | 이제희 | NULL | 예Chei He | 2025-09-14 05:57:46 | 2025-12-10 04:33:32 | 예최희,예재희 | 80 | 가장 | NULL | 이제희의 처(부인), 이제희의 처(부인) | 1904-07-08 | NULL | NULL | 1102 | Ye | 이 | Chei He | 제희 | 19 | 14 | |||||||||||||||||
| BjBW3OY8R3KnbPBOlLYUXQ | No, Myeng Soon, wife (Koli Ma) | 19 | 19세 | married | Sa Sul Mak | 4/10/1904 | Gaelic | 노명순 | NULL | Nowife (Koli Ma) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 노명선,노명신 | 90 | 부인 | Koli Ma | 골리마 | 1904-04-10 | NULL | NULL | 856 | No | 노 | Myeng Soon | 명순 | 19 | 7 | |||||||||||||||||
| Bj3t2ESVTPe7Urk17os7UA | Pak, Sung Min | 24 | 24세 | married | Eui Choo Moo Kol | 9/26/1904 | Mongolia | 박성민 | 박성민 | NULL | 박Sung Min | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 박종수 (부인 김씨)(부인), 박종수(아들), 박종수(아들), 박종수(딸) | 1904-09-26 | NULL | NULL | 1101 | Pak | 박 | Sung Min | 성민 | 24 | 14 | ||||||||||||||||
| bixSru6EQn6Vtkk2hPAsZQ | Kim, Dal Sung | 22 | 22세 | single | Masampo | 12/28/1903 | Siberia | 김달성 | NULL | 김Dal Sung | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김달승,김탈성 | 95 | 가장 | NULL | 김달성의 처(부인) | 1903-12-28 | NULL | NULL | 1100 | Kim | 김 | Dal Sung | 달성 | 22 | 17 | |||||||||||||||||
| bilr7PDCRJWH-HSRJCWqUQ | Pak, Youn Sup, son | 5 | 5세 | single | Seoul | 12/5/1903 | Doric | 박자 | 박자 | NULL | 박son | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | 아들 | NULL | NULL | 1903-12-05 | NULL | NULL | 18 | Pak | 박 | Youn Sup | 자 | 5 | 6 | ||||||||||||||||
| bIlqL1X3Q7O0kxhBEs-rOQ | Choi, In Sun | 23 | 23세 | single | Moon Sa Po | 5/8/1905 | Siberia | 최인선 | 최인선 | NULL | 최In Sun | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 최찬영(형제) | 1905-05-08 | NULL | NULL | 1099 | Choi | 최 | In Sun | 인선 | 23 | 17 | ||||||||||||||||
| bib54VM5R5CsAsHeg3.heg | Pak, Dong Eun, brother (Dong Choon) | 18 | 18세 | single | Duk Eun Dong | 11/2/1904 | Manchuria | 박동은 | NULL | 박brother (Dong Choon) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박동인,박동운 | 90 | 형제 | Dong Choon | 동춘 | 1904-11-02 | NULL | NULL | 1098 | Pak | 박 | Dong Eun | 동은 | 18 | 12 | |||||||||||||||||
| Bi8GL5fiTfmA1sWKcmaWLQ | Chung, Kyeng Chin | 21 | 21세 | widower | Kook Mal | 11/24/1904 | Gaelic | 정경진 | NULL | 정Kyeng Chin | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 정경친,정경천 | 90 | NULL | NULL | NULL | 1904-11-24 | NULL | NULL | 1097 | Chung | 정 | Kyeng Chin | 경진 | 21 | 7 | |||||||||||||||||
| bHxoPkGQSxuQdulyVCawOw | Im, Seung Keuk | 31 | 31세 | married | Choo Nam | 1/26/1905 | Korea | 임승극 | NULL | 임Seung Keuk | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 임승국,임승걱 | 90 | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 1096 | Im | 임 | Seung Keuk | 승극 | 31 | 9 | |||||||||||||||||
| Bhpfg1NuRY6gulvo3op64g | Hong, Pyeng Ik, father (In Sik) | 57 | 57세 | married | Choo Chun | 5/29/1905 | China | 홍평익 | NULL | 홍father (In Sik) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 홍병익,홍평일 | 90 | 아버지 | In Sik | 인식 | 1905-05-29 | NULL | NULL | 1095 | Hong | 홍 | Pyeng Ik | 평익 | 57 | 3 | |||||||||||||||||
| BHhBpz.HTQSpBJLJiRXjpA | Chung, Won Soh | 29 | 29세 | married | Koong Dong | 8/22/1904 | Coptic | 정원서 | NULL | 정Won Soh | 2025-09-14 05:57:43 | 2025-12-10 04:34:46 | 정원소,정완서 | 85 | 가장 | NULL | 정원서의 처(부인) | 1904-08-22 | NULL | NULL | 665 | Chung | 정 | Won Soh | 원서 | 29 | 4 | |||||||||||||||||
| bHEqrpXLQmCe7cD1XAq0vA | Chun, Chun Soh, daughter (Wan Mea) | 1 | 1세 | single | Koo Sung Li | 9/26/1904 | Mongolia | 전춘서 | NULL | 전daughter (Wan Mea) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 전춘소,천춘서 | 85 | 딸 | Wan Mea | 완매 | 1904-09-26 | NULL | NULL | 1094 | Chun | 전 | Chun Soh | 춘서 | 1 | 14 | |||||||||||||||||
| BGuZpAacRV-bBoSUanZt5A | Ye, Suk Man | 36 | 36세 | widower | Dol Moi | 1/6/1905 | Doric | 이숙만 | 이숙만 | NULL | 예Suk Man | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 1093 | Ye | 예 | Suk Man | 숙만 | 36 | 6 | ||||||||||||||||
| bgSp3uSyQ9uYtxqI3iY8lQ | Song, Chil Won, son 2 (Pong Cho) | 10 | 10세 | single | Man Chook Dong | 4/24/1905 | Coptic | 송칠원 | NULL | 송son 2 (Pong Cho) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 송칠완,송질원 | 90 | 아들 | Pong Cho | 봉조 | 1905-04-24 | NULL | NULL | 1092 | Song | 송 | Chil Won | 칠원 | 10 | 4 |