컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| qhDJsdNARZOXpRzc9UWdiQ | Chung, Woon Heui | 28 | 28세 | married | Fusan | 10/15/1903 | Coptic | 정운희 | NULL | 정Woon Heui | 2025-09-14 05:57:43 | 2025-12-10 04:59:17 | 정운휘,정운흥 | 85 | 가장 | NULL | 정운희의 처(부인), 정운희의 처(부인), 정씨의 자(아들) | 1903-10-15 | NULL | NULL | 16 | Chung | 정 | Woon Heui | 운희 | 28 | 4 | |||||||||||||||||
| qh4FgnIcTYi.EQ3hCOP3Fw | Chung, Pyeng Sup | 35 | 35세 | married | Kang Dong | 7/18/1904 | China | 정평섭 | NULL | 정Pyeng Sup | 2025-09-14 05:57:43 | 2025-12-10 04:59:17 | 정평습,정병섭 | 85 | 가장 | NULL | 정평섭의 처(부인), 정씨의 자(아들), 정씨의 녀(딸) | 1904-07-18 | NULL | NULL | 478 | Chung | 정 | Pyeng Sup | 평섭 | 35 | 3 | |||||||||||||||||
| qgXTVQxsSF2v-7ZJTtP1Yw | Song, Chi Soon, son | 11 | 11세 | single | Yer San | 8/11/1904 | Siberia | 송치순 송진구,김정윤 알프레드 송 | 송진구 | 송자 | 2025-07-11 00:00:00 | 송치순 | 송진구,김정윤 | 알프레드 송 | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | 아들 | NULL | NULL | 1904-08-11 | NULL | NULL | 2083 | Song | 송 | Chi Soon | 진구 | 11 | 17 | |||||||||||||
| QgWUqHByS5-6WZJdewhcww | Min, Kyeng Hak | 24 | 24세 | widower | Seoul | 2/8/1904 | China | 민경학 | 민경학 | NULL | 민Kyeng Hak | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-02-08 | NULL | NULL | 18 | Min | 민 | Kyeng Hak | 경학 | 24 | 3 | ||||||||||||||||
| qGoJRyM3QCuuaOLDS6VG1g | Choi, In Sung | 20 | 20세 | married | Seoul | 9/21/1903 | Doric | 최인성 | NULL | 최In Sung | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최인승,최인순 | 92 | NULL | NULL | NULL | 1903-09-21 | NULL | NULL | 18 | Choi | 최 | In Sung | 인성 | 20 | 6 | |||||||||||||||||
| QGjPQ.8MQ6mw2b5Dz8HzVw | Oh, Choon Ye | 33 | 33세 | widower | Sang Choo | 12/28/1903 | Siberia | 오춘예 | 오춘예 | NULL | 오Choon Ye | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-12-28 | NULL | NULL | 105 | Oh | 오 | Choon Ye | 춘예 | 33 | 17 | ||||||||||||||||
| QG-pGsZnQA69UgloKD9KQw | Pak, Young Sik | 21 | 21세 | married | Bi Youl | 7/11/1904 | America Maru | 박영식 | 박영식 | NULL | 박영식 | 2025-09-14 05:57:45 | 2025-12-10 04:59:27 | NULL | NULL | 가장 | NULL | 박영식의 처(부인), 박씨의 자(아들), 박씨의 녀2(딸), 박씨의 녀1(딸) | 1904-07-11 | NULL | NULL | 2644 | Pak | 박 | Young Sik | 영식 | 21 | 1 | ||||||||||||||||
| QFXCm2EwTbyySsWF-jgUnA | Her, Seung Chun | 24 | 24세 | widower | Sin Chun Keri | 4/13/1905 | Korea | 허승춘 | NULL | HerSeung Chun | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 허승천,허성춘 | 88 | NULL | NULL | NULL | 1905-04-13 | NULL | NULL | 2643 | Her | 허 | Seung Chun | 승춘 | 24 | 9 | |||||||||||||||||
| Qfp4hwUxTcGyhGbHYuo6kA | Um, Sung Kook | 22 | 22세 | widower | Ko Sung | 12/5/1903 | Doric | 엄성국 | 엄성국 | NULL | 엄Sung Kook | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-12-05 | NULL | NULL | 424 | Um | 엄 | Sung Kook | 성국 | 22 | 6 | ||||||||||||||||
| QFfj2ILJSGWdk9lg1S.4wQ | Chang, Hoo Suk | 30 | 30세 | married | Dong moon Li | 4/24/1905 | Coptic | 장후석 | NULL | 장Hoo Suk | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 장호석,장후숙 | 85 | NULL | NULL | NULL | 1905-04-24 | NULL | NULL | 1190 | Chang | 장 | Hoo Suk | 후석 | 30 | 4 | |||||||||||||||||
| QFeTmpZpTG-jxzRq3sRknQ | Im, Young Wha, wife | 18 | 18세 | married | In Chun | 2/18/1904 | Doric | 임처 | 임처 | NULL | 임wife | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-02-18 | NULL | NULL | 81 | Im | 임 | Young Wha | 처 | 18 | 6 | ||||||||||||||||
| QFALJ7rSRheyQI91us7aug | Kim, Kook Sun, wife | 22 | 22세 | married | Sam Ka | 9/16/1904 | Gaelic | 김처 | 김처 | NULL | 김wife | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1904-09-16 | NULL | NULL | 2001 | Kim | 김 | Kook Sun | 처 | 22 | 7 | ||||||||||||||||
| Qf5Kdt3uTkqxL3YQXmGAew | Choi, Duk Sung | 34 | 34세 | married | Seoul, Pak Ton | 5/20/1904 | Siberia | 최덕성 | NULL | 최Duk Sung | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최덕승,최덕순 | 92 | NULL | NULL | NULL | 1904-05-20 | NULL | NULL | 2642 | Choi | 최 | Duk Sung | 덕성 | 34 | 17 | |||||||||||||||||
| qezSeJ1WQomwRu4wdhJL5A | Pak, Keun Saing | 29 | 29세 | single | Chong Dong | 2/2/1905 | Coptic | 박근생 | NULL | 박Keun Saing | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박근상,박근성 | 90 | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 420 | Pak | 박 | Keun Saing | 근생 | 29 | 4 | |||||||||||||||||
| qExe.QzETMGkmkuWILA46A | Song, Soo Kwan | 22 | 22세 | married | Choo Ham | 5/29/1905 | China | 송수관 | NULL | 송Soo Kwan | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 송수간,송수광 | 90 | NULL | NULL | NULL | 1905-05-29 | NULL | NULL | 2308 | Song | 송 | Soo Kwan | 수관 | 22 | 3 | |||||||||||||||||
| qETXCfXJRt6yh.iF2nRrqg | Cho, Ik Sun | 27 | 27세 | married | Chemulpo | 1/13/1903 | Gaelic | 조익선 | 조익선 | 조익선 | 2025-04-18 00:00:00 | 조익선 | 2025-09-14 05:57:43 | 2025-12-10 04:59:17 | NULL | NULL | 가장 | NULL | 조익선의 처(부인), 조익선의 처(부인), 조씨의 자(아들), 조씨의 자(아들), 조녀(딸) | 1903-01-13 | NULL | NULL | 42 | Cho | 조 | Ik Sun | 익선 | 27 | 7 | |||||||||||||||
| QeSJum7kRVeKq4YSPfvQQw | Chung, Nok Sun | 28 | 28세 | married | Pyeng Yang | 9/21/1903 | Doric | 정녹순 | NULL | 정Nok Sun | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 정록순,정녹선 | 85 | NULL | NULL | NULL | 1903-09-21 | NULL | NULL | 58 | Chung | 정 | Nok Sun | 녹순 | 28 | 6 | |||||||||||||||||
| QeduGcYsQKOV2m98giwscw | Ye, Chang Suk | 30 | 30세 | married | Seoul, Cho Dong | 6/1/1904 | Coptic | 이창숙 | 이창숙 | NULL | 예Chang Suk | 2025-09-14 05:57:46 | 2025-12-10 04:32:54 | NULL | NULL | 가장 | NULL | 이창숙의 처(부인), 이창석(부인), 이창숙의 처(부인), 이창석(딸), 이승민(자매) | 1904-06-01 | NULL | NULL | 594 | Ye | 예 | Chang Suk | 창숙 | 30 | 4 | ||||||||||||||||
| QDZ0WGIRTeqhAC7XaeyUeA | Choi, Yong Whan | 38 | 38세 | widower | Sam Im Dong | 3/10/1905 | China | 최용환 | NULL | 최Yong Whan | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최용완,최룡환 | 90 | NULL | NULL | NULL | 1905-03-10 | NULL | NULL | 2641 | Choi | 최 | Yong Whan | 용환 | 38 | 3 | |||||||||||||||||
| QDR2aWcDSQiSMu0r046vDQ | Nam, Deuk Do | 40 | 40세 | widower | Seoul, To Tong | 6/1/1904 | Coptic | 남득도 | NULL | 남Deuk Do | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 남덕도,남득두 | 85 | NULL | NULL | NULL | 1904-06-01 | NULL | NULL | 2640 | Nam | 남 | Deuk Do | 득도 | 40 | 4 |