컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TvB65QMyQoSMCSdNtMIYfQ | Chun, Eun Kum | 30 | 30세 | widower | Oh Kol | 11/2/1904 | Manchuria | 전은금 | NULL | 전Eun Kum | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 천은금,전은검 | 90 | NULL | NULL | NULL | 1904-11-02 | NULL | NULL | 2960 | Chun | 전 | Eun Kum | 은금 | 30 | 12 | |||||||||||||||||
| Tv7WoSIUT6-lA9meLC5MCA | Pai, Il Chin | 30 | 30세 | married | Fusan | 3/14/1904 | Coptic | 배일진 | NULL | PaiIl Chin | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | 백일진,배일천 | 88 | 가장 | NULL | 배일진(부인) | 1904-03-14 | NULL | NULL | 16 | Pai | 배 | Il Chin | 일진 | 30 | 4 | |||||||||||||||||
| TUWK1HLISXiLmQNnfaPObA | Cho, Chang Chin | 26 | 26세 | widower | Sang Ap | 9/26/1904 | Mongolia | 조창진 | NULL | 조Chang Chin | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | 조창친,조창천 | 90 | 가장 | NULL | 최상필(아버지) | 1904-09-26 | NULL | NULL | 1885 | Cho | 조 | Chang Chin | 창진 | 26 | 14 | |||||||||||||||||
| TUsNKnv1T4O0qGke2XcYjg | Soh, Kap Ye | 28 | 28세 | single | Sak Sil | 3/10/1905 | China | 서갑예 | NULL | 서Kap Ye | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 소갑예,서갑애 | 85 | NULL | NULL | NULL | 1905-03-10 | NULL | NULL | 2963 | Soh | 서 | Kap Ye | 갑예 | 28 | 3 | |||||||||||||||||
| tupjGxIzTiqoDXX46wCslg | Pak, Young Hoon | 20 | 20세 | married | Chung Teui | 3/10/1905 | China | 박영훈 | NULL | 박Young Hoon | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박용훈,박영흔 | 95 | NULL | NULL | NULL | 1905-03-10 | NULL | NULL | 2647 | Pak | 박 | Young Hoon | 영훈 | 20 | 3 | |||||||||||||||||
| tuN6iDtyR0S0M0CvKQDRCQ | Ye, Kyeng Chin | 38 | 38세 | widower | So Chung | 12/24/1904 | China | 이경진 | NULL | 예Kyeng Chin | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예경친,예경천 | 88 | NULL | NULL | NULL | 1904-12-24 | NULL | NULL | 642 | Ye | 이 | Kyeng Chin | 경진 | 38 | 3 | |||||||||||||||||
| TUIVeHLRQJCRgZatiLaM0Q | Son, Pa We | 26 | 26세 | single | Kang Kyeng Ye | 8/22/1904 | Coptic | 손파위 | NULL | 손Pa We | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 손파웨,손바위 | 75 | NULL | NULL | NULL | 1904-08-22 | NULL | NULL | 602 | Son | 손 | Pa We | 파위 | 26 | 4 | |||||||||||||||||
| TUdX1zQoQnG2C.dVn6c3AA | Ye, Won Ye | 24 | 24세 | single | Tul Yaoul | 4/10/1904 | Gaelic | 이원예 | 이원예 | NULL | 예Won Ye | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | NULL | NULL | NULL | 1904-04-10 | NULL | NULL | 2962 | Ye | 예 | Won Ye | 원예 | 24 | 7 | ||||||||||||||||
| tuBjM0pXQqKVsjeoA3YYIg | Suk, Choon Kook | 29 | 29세 | married | Puk Chuk Kyo | 12/24/1904 | China | 석춘국 | 석춘국 | NULL | 석Choon Kook | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-12-24 | NULL | NULL | 2961 | Suk | 석 | Choon Kook | 춘국 | 29 | 3 | ||||||||||||||||
| TU7qYROfS7K8.oX5H81IbA | Kim, Eung Sang | 34 | 34세 | widower | Chang Won | 7/18/1904 | China | 김응상 | NULL | 김Eung Sang | 2025-09-14 05:57:44 | 2025-12-10 04:59:17 | 김웅상,김은상 | 88 | 가장 | NULL | 김응상의 처(부인), 김씨의 자(아들), 김씨의 녀(딸) | 1904-07-18 | NULL | NULL | 686 | Kim | 김 | Eung Sang | 응상 | 34 | 3 | |||||||||||||||||
| TU3XxucHS22.Q5xcSZmodg | Pak, Dong Keun | 39 | 39세 | widower | Seoul | 9/21/1903 | Doric | 박동근 | 박동근 | NULL | 박Dong Keun | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-09-21 | NULL | NULL | 18 | Pak | 박 | Dong Keun | 동근 | 39 | 6 | ||||||||||||||||
| TtZWBHgYSgC3VKEajdg5BA | Chan, Tai Ho | 23 | 23세 | widower | Kang Neung | 3/4/1904 | Siberia | 찬태호 | 찬태호 | NULL | ChanTai Ho | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-03-04 | NULL | NULL | 1802 | Chan | 찬 | Tai Ho | 태호 | 23 | 17 | ||||||||||||||||
| TtxvCqSoR.entrx32am.Qg | Kim, Chang Soo | 34 | 34세 | widower | Chook DOng | 3/31/1905 | Manchuria | 김창수 | 김창수 | NULL | 김Chang Soo | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 김현중(부인), 김봉상(부인), 김봉상(아들), 김봉상(아들), 김봉상(아들) | 1905-03-31 | NULL | NULL | 636 | Kim | 김 | Chang Soo | 창수 | 34 | 12 | ||||||||||||||||
| TtwHYfFvSH-yvB7NJ..HPg | Pak, Byeng Won | 25 | 25세 | single | Won San | 12/28/1903 | Coptic | 박병원 | NULL | 박Byeng Won | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박병완,박변원 | 90 | NULL | NULL | NULL | 1903-12-28 | NULL | NULL | 160 | Pak | 박 | Byeng Won | 병원 | 25 | 4 | |||||||||||||||||
| tTP.rHTcRbWUyYRpGJNmlQ | Sim, Sang Moh | 20 | 20세 | single | Oh Kol | 3/31/1905 | Manchuria | 심상모 | NULL | 심Sang Moh | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 심상무,심상목 | 92 | NULL | NULL | NULL | 1905-03-31 | NULL | NULL | 2960 | Sim | 심 | Sang Moh | 상모 | 20 | 12 | |||||||||||||||||
| TTFAW6V6Sou0w8hfOZEnaQ | Kim, Yong Koo | 24 | 24세 | married | Ku Dong | 1/6/1905 | Doric | 김용구 | 김용구 | NULL | 김Yong Koo | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 2959 | Kim | 김 | Yong Koo | 용구 | 24 | 6 | ||||||||||||||||
| TTBNzUUAR4S5fLVU6lrNVA | Pail, Kyeng Soon, daughter (Ko Man) | 1 | 1세 | single | Wha Il Ri | 5/29/1905 | China | 백경순 | NULL | Paildaughter (Ko Man) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 백경선,백경신 | 85 | 딸 | Ko Man | 고만 | 1905-05-29 | NULL | NULL | 999 | Pail | 백 | Kyeng Soon | 경순 | 1 | 3 | |||||||||||||||||
| tt4k2L0eT0ym0U5vjeAiEw | Kim, Chan Ho | 20 | 20세 | married | Sook Chun | 7/11/1904 | America Maru | 김찬호 | 김찬호 | NULL | 김Chan Ho | 2025-09-14 05:57:44 | 2025-12-10 04:59:27 | NULL | NULL | 가장 | NULL | 김찬호의 처(부인), 김찬호의 처(부인), 김재근(어머니), 김씨의 자1(아들), 김씨의 자2(아들), 김씨의 자2(아들), 김씨의 자1(아들) | 1904-07-11 | NULL | NULL | 1855 | Kim | 김 | Chan Ho | 찬호 | 20 | 1 | ||||||||||||||||
| tT3l0NrqQhqlENrVIO2C8g | Whang, Chi Koo | 24 | 24세 | married | Chemulpo | 3/3/1903 | Coptic | 황치구 | 황치구 | NULL | 황Chi Koo | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-03-03 | NULL | NULL | 42 | Whang | 황 | Chi Koo | 치구 | 24 | 4 | ||||||||||||||||
| TsWIMkeBSC6TjRFUTVh5XA | Um, Seung Chool | 22 | 22세 | married | Choong Choo | 4/14/1903 | China | 엄승철 | NULL | 엄Seung Chool | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 음승철,엄성철 | 90 | NULL | NULL | NULL | 1903-04-14 | NULL | NULL | 363 | Um | 엄 | Seung Chool | 승철 | 22 | 3 |