컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Qj2eAp3ySYaCjzKuCeJKvA | Kang, Chi Kun | 21 | 21세 | single | Yark Hyen | 12/9/1904 | Mongolia | 강치건 | 강치건 | NULL | 강Chi Kun | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-12-09 | NULL | NULL | 473 | Kang | 강 | Chi Kun | 치건 | 21 | 14 | ||||||||||||||||
| qiW-rN2nRIy85fsge9QM1A | Chung, Heung Sung | 21 | 21세 | widower | Choo Eurp | 1/6/1905 | Doric | 정흥성 | NULL | 정Heung Sung | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 정흥승,정흥순 | 88 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 2655 | Chung | 정 | Heung Sung | 흥성 | 21 | 6 | |||||||||||||||||
| qIVzDL0EQP-LQtuyyfoCog | Hong, In Taik, wife | 29 | 29세 | married | Pyeng Yang | 10/15/1903 | Coptic | 홍처 | 홍처 | NULL | 홍wife | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1903-10-15 | NULL | NULL | 58 | Hong | 홍 | In Taik | 처 | 29 | 4 | ||||||||||||||||
| QilE7kQQSNy3SFMZhZUj9g | Kim, Chong Pum | 27 | 27세 | single | Ar Dong | 1/26/1905 | Korea | 김종범 | 김종범 | NULL | 김Chong Pum | 2025-09-14 05:57:44 | 2025-12-10 04:59:17 | NULL | NULL | 가장 | NULL | 김종범의 처(부인), 김씨의 자(아들) | 1905-01-26 | NULL | NULL | 2654 | Kim | 김 | Chong Pum | 종범 | 27 | 9 | ||||||||||||||||
| QikSyA1JQ5mv22fmREXLmw | Im, Do Ik | 20 | 20세 | married | Pan Dai Mal | 4/13/1905 | Korea | 임도익 | 임도익 | NULL | 임Do Ik | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 임영목(부인) | 1905-04-13 | NULL | NULL | 2653 | Im | 임 | Do Ik | 도익 | 20 | 9 | ||||||||||||||||
| QiiLBaNsQRKBRtwAk4EkpQ | Pak, Chai Youn | 36 | 36세 | married | Pyeng Im | 3/10/1905 | China | 박재윤 | NULL | 박Chai Youn | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박채윤,박재연 | 88 | NULL | NULL | NULL | 1905-03-10 | NULL | NULL | 2076 | Pak | 박 | Chai Youn | 재윤 | 36 | 3 | |||||||||||||||||
| qIH1bYtCTaqgVhVRroKMvg | Chun, Im Si | 23 | 23세 | single | Ki Si Dong | 1/6/1905 | Doric | 천임시 | NULL | 전Im Si | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 전임시,천입시 | 75 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 2652 | Chun | 천 | Im Si | 임시 | 23 | 6 | |||||||||||||||||
| QiG3QCFJT.KAenSEz6nwPQ | Ye, Choon Sik | 21 | 21세 | single | Sang Kiu | 3/30/1904 | Korea | 이춘식 | 이춘식 | NULL | 예Choon Sik | 2025-09-14 05:57:46 | 2025-12-10 04:32:54 | NULL | NULL | 가장 | NULL | 이춘식의 처(부인), 이관실(아들) | 1904-03-30 | NULL | NULL | 2651 | Ye | 예 | Choon Sik | 춘식 | 21 | 9 | ||||||||||||||||
| qIFL8ltuTrKzikTFp3JUFg | Im, Who Dong | 18 | 18세 | single | Seoul | 3/4/1904 | Siberia | 임후동 | NULL | 임Who Dong | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 임호동,임우동 | 80 | NULL | NULL | NULL | 1904-03-04 | NULL | NULL | 18 | Im | 임 | Who Dong | 후동 | 18 | 17 | |||||||||||||||||
| QIe2LiOERzu0xu8LSKH5AQ | Won, Soon Deuk | 27 | 27세 | married | Yerfor Chon | 2/13/1905 | Siberia | 원순득 | NULL | 원Soon Deuk | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 원순덕,원순억 | 88 | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 2650 | Won | 원 | Soon Deuk | 순득 | 27 | 17 | |||||||||||||||||
| QI9FSSoeTeGK5EHH6Wxm3g | Kim, Hak Kiu | 26 | 26세 | married | Kei Dong | 10/6/1904 | China | 김학규 | NULL | 김Hak Kiu | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김학기,김학구 | 88 | 가장 | NULL | 김귀부(아들) | 1904-10-06 | NULL | NULL | 713 | Kim | 김 | Hak Kiu | 학규 | 26 | 3 | |||||||||||||||||
| Qi9akH-dQ-OCorErE3tdVg | Oh, Duk Kiu | 31 | 31세 | widower | Seoul | 8/11/1904 | Siberia | 오덕규 | NULL | 오Duk Kiu | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 오덕기,오덕구 | 88 | NULL | NULL | NULL | 1904-08-11 | NULL | NULL | 18 | Oh | 오 | Duk Kiu | 덕규 | 31 | 17 | |||||||||||||||||
| qhxX.WylSVCsPYyhTigjnQ | Hum, Chong Han | 22 | 22세 | widower | Chun Pa We | 11/2/1904 | Manchuria | 함종한 | NULL | HumChong Han | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 함중한,함종환 | 85 | NULL | NULL | NULL | 1904-11-02 | NULL | NULL | 2649 | Hum | 함 | Chong Han | 종한 | 22 | 12 | |||||||||||||||||
| QHvAW8dRReC3XDdkJjVX5w | Kim, Eung Soon | 36 | 36세 | widower | Sim Chong | 9/5/1904 | Korea | 김응순 | NULL | 김Eung Soon | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김응선,김웅순 | 90 | 가장 | NULL | 김응순의 처(부인), 김세룡(부인), 김응순의 처(부인), 김낙열(부인), 김세룡(아들), 김춘섭(아들), 김창근(딸), 김춘섭(딸), 김창근(딸), 김춘섭(딸), 김춘섭(딸), | 1904-09-05 | NULL | NULL | 2648 | Kim | 김 | Eung Soon | 응순 | 36 | 9 | |||||||||||||||||
| qhUFoahYQMSNwWL7NZb9HQ | Han, Soon Kyum | 23 | 23세 | married | Won Choo | 3/4/1904 | Siberia | 한순겸 | NULL | 한Soon Kyum | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한순검,한순금 | 85 | NULL | NULL | NULL | 1904-03-04 | NULL | NULL | 1070 | Han | 한 | Soon Kyum | 순겸 | 23 | 17 | |||||||||||||||||
| qhLSZjhBRk60Ur.MgDnOiA | Ye, Chang Suk, daughter (Kan Ani) | 8 | 8세 | single | Seoul, Cho Dong | 6/1/1904 | Coptic | 이창석 | NULL | 예daughter (Kan Ani) | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예창숙,예창순 | 85 | 딸 | Kan Ani | 간아니 | 1904-06-01 | NULL | NULL | 594 | Ye | 이 | Chang Suk | 창석 | 8 | 4 | |||||||||||||||||
| qHFdd23sTGeAIAh.kTGS7w | Kim, Young Choon | 20 | 20세 | married | Chung Teui | 3/10/1905 | China | 김영춘 | 김영춘 | NULL | 김Young Choon | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 김춘식(형제), 김수영(형제), 김세진(형제) | 1905-03-10 | NULL | NULL | 2647 | Kim | 김 | Young Choon | 영춘 | 20 | 3 | ||||||||||||||||
| QhEYz9sjQKCySW2tTPmJUA | Yang, Chang Kiu | 23 | 23세 | married | Woo Son | 7/8/1904 | Mongolia | 양창규 | NULL | 양Chang Kiu | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 양창기,양창구 | 88 | NULL | NULL | NULL | 1904-07-08 | NULL | NULL | 2646 | Yang | 양 | Chang Kiu | 창규 | 23 | 14 | |||||||||||||||||
| qHE1laopRcK3MjyTOEAIjg | Im, Eung Pin | 21 | 21세 | married | Dai Am Li | 3/31/1905 | Manchuria | 임응빈 | NULL | 임Eung Pin | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | 임응핀,임웅빈 | 80 | 가장 | NULL | 임대영(아들), 임대영(딸) | 1905-03-31 | NULL | NULL | 2146 | Im | 임 | Eung Pin | 응빈 | 21 | 12 | |||||||||||||||||
| qHdUApIrStSEi.WkyKPwEA | Nam, Suk Woo | 29 | 29세 | married | Pal Kak Chung | 4/24/1905 | Coptic | 남숙우 | 남숙우 | NULL | 남Suk Woo | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-04-24 | NULL | NULL | 2645 | Nam | 남 | Suk Woo | 숙우 | 29 | 4 |