컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cgNrdCQqQiaRgYsabwDr1A | Chun, Soon Yern | 28 | 28세 | widower | Suk Kyo | 11/24/1904 | Gaelic | 전순연 | NULL | 전Soon Yern | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 천순연,전순년 | 85 | NULL | NULL | NULL | 1904-11-24 | NULL | NULL | 309 | Chun | 전 | Soon Yern | 순연 | 28 | 7 | |||||||||||||||||
| cGkoUFnPTdWNOSrirJ7Arw | Song, Eung Wha | 30 | 30세 | married | Chemulpo | 3/30/1903 | Gaelic | 송응화 | NULL | 송Eung Wha | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 송웅화,송응와 | 85 | NULL | NULL | NULL | 1903-03-30 | NULL | NULL | 42 | Song | 송 | Eung Wha | 응화 | 30 | 7 | |||||||||||||||||
| cgiOf3JcQb2O9IzKBGWd4A | Kim, Heui Choong | 25 | 25세 | single | Ye Dong | 1/6/1905 | Doric | 김희중 | NULL | 김Heui Choong | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김희충,김희춘 | 85 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 239 | Kim | 김 | Heui Choong | 희중 | 25 | 6 | |||||||||||||||||
| CGEoEQHZRRKWf5vTfMeStA | Pak, Tai Keun | 21 | 21세 | married | Won San | 12/28/1903 | Coptic | 박태근 | 박태근 | NULL | 박Tai Keun | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-12-28 | NULL | NULL | 160 | Pak | 박 | Tai Keun | 태근 | 21 | 4 | ||||||||||||||||
| cg6D6hECRqGal8iSUqnR5w | Kang, Pyeng Hyeng | 26 | 26세 | married | Kang Kay, So Pu Moon | 5/20/1904 | Siberia | 강평형 | NULL | 강Pyeng Hyeng | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 강병형,강평헝 | 80 | NULL | NULL | NULL | 1904-05-20 | NULL | NULL | 1204 | Kang | 강 | Pyeng Hyeng | 평형 | 26 | 17 | |||||||||||||||||
| CFyIrIukTUSzpgG75kXW7A | Ih, Young Chin | 28 | 28세 | single | Hai Choo | 3/30/1904 | Korea | 이영진 | NULL | IhYoung Chin | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 이용진,이영천 | 90 | NULL | NULL | NULL | 1904-03-30 | NULL | NULL | 80 | Ih | 이 | Young Chin | 영진 | 28 | 9 | |||||||||||||||||
| CfpZ3qYgR9KnE5KrWDwgDg | Kong, Sung Won | 23 | 23세 | married | Chang Won | 2/18/1904 | Doric | 차옥금 Clara Kun Nai Kong | 공성원 | Kong성원 | 2025-03-09 00:00:00 | 차옥금 | 1931년 10월 4일생 딸의 13세때 세례기록 | Clara Kun Nai Kong | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-02-18 | NULL | NULL | 686 | Kong | 공 | Sung Won | 성원 | 23 | 6 | |||||||||||||
| CFi0CmBLShqjp92S07vOww | Chung, Hak Soo | 25 | 25세 | single | Choong Wha | 7/11/1904 | America Maru | 정학수 | 정학수 | NULL | 정Hak Soo | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-07-11 | NULL | NULL | 220 | Chung | 정 | Hak Soo | 학수 | 25 | 1 | ||||||||||||||||
| cfgqtJGlS7-wsJVzrLUN.Q | Sin, Soo | 30 | 30세 | married | Han Kang | 9/26/1904 | Mongolia | 신수 | 신수 | NULL | 신Soo | 2025-09-14 05:57:45 | 2025-12-10 04:59:06 | NULL | NULL | 가장 | NULL | 신수씨,예씨(부인), 신씨 부인, 신영균(아들), 신영균(아들) | 1904-09-26 | NULL | NULL | 1203 | Sin | 신 | Soo | 수 | 30 | 14 | ||||||||||||||||
| Cff31efmTGKaxZLCuSondg | Kim, Eung Chun | 25 | 25세 | married | Chei Choo | 1/9/1904 | America Maru | 김응춘 | NULL | 김Eung Chun | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김웅춘,김응천 | 90 | NULL | NULL | NULL | 1904-01-09 | NULL | NULL | 324 | Kim | 김 | Eung Chun | 응춘 | 25 | 1 | |||||||||||||||||
| cF5ksrwaSKKqSubapzUMJQ | Pak, Ki Man | 37 | 37세 | single | Pan Kool | 4/17/1904 | America Maru | 박기만 | 박기만 | NULL | 박Ki Man | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 박치영(부인), 박치영(딸), 박치영(딸) | 1904-04-17 | NULL | NULL | 1202 | Pak | 박 | Ki Man | 기만 | 37 | 1 | ||||||||||||||||
| CF521VsFRJetAcHegcunSA | Choi, Eung Ye | 26 | 26세 | widower | Pyeng Yang | 12/5/1903 | Doric | 최응예 | NULL | 최Eung Ye | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최웅예,최응예 | 85 | NULL | NULL | NULL | 1903-12-05 | NULL | NULL | 58 | Choi | 최 | Eung Ye | 응예 | 26 | 6 | |||||||||||||||||
| ceNeBRVHQ.GcsUmumdBknA | Ye, Nam Ye | 23 | 23세 | single | Non Mi | 3/10/1905 | China | 이남예 | 이남예 | NULL | 예Nam Ye | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | 가장 | NULL | 이만용(부인), 이만용(자매) | 1905-03-10 | NULL | NULL | 1201 | Ye | 예 | Nam Ye | 남예 | 23 | 3 | ||||||||||||||||
| ceJQHJW4TcSEaNmNrfs0xg | Han, Young Soon | 25 | 25세 | widower | Chang Pyeng Li | 3/31/1905 | Manchuria | 한영순 | NULL | 한Young Soon | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | 한영선,한용순 | 90 | 가장 | NULL | 한상운(부인), 한흥수(부인), 한흥수(아들), 한상운(딸), 한상운(딸) | 1905-03-31 | NULL | NULL | 1200 | Han | 한 | Young Soon | 영순 | 25 | 12 | |||||||||||||||||
| ceIz4Y6IT.y0YEZKUKTzzw | Kim, Pong Chool | 34 | 34세 | single | Wool San | 1/23/1904 | Gaelic | 김봉철 | NULL | 김Pong Chool | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김봉출,김방철 | 85 | 가장 | NULL | 김신우(부인), 김주노(부인), 김신우(아들), 김인복(딸) | 1904-01-23 | NULL | NULL | 513 | Kim | 김 | Pong Chool | 봉철 | 34 | 7 | |||||||||||||||||
| cEIqOyzERluSlOyAgSktJQ | Pak, Won Kil | 32 | 32세 | single | Sang Kyo Dong | 10/17/1904 | Doric | 박원길 | NULL | 박Won Kil | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | 박원걸,박원결 | 95 | 가장 | NULL | 박동은(형제) | 1904-10-17 | NULL | NULL | 1199 | Pak | 박 | Won Kil | 원길 | 32 | 6 | |||||||||||||||||
| CeE2oss1RJyAoddRtZbMew | An, Ark Poong | 30 | 30세 | widower | Par Young Dong | 7/8/1904 | Mongolia | 안악풍 | NULL | 안Ark Poong | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 안아풍,안약풍 | 75 | NULL | NULL | NULL | 1904-07-08 | NULL | NULL | 1198 | An | 안 | Ark Poong | 악풍 | 30 | 14 | |||||||||||||||||
| cEAx2hikTcCcgEGpJ1tiiQ | Cho, Chong Soon | 20 | 20세 | single | Chong Chung Poo | 1/26/1905 | Korea | 조종순 | NULL | 조Chong Soon | 2025-09-14 05:57:43 | 2025-12-10 04:59:06 | 조정순,조충순 | 90 | 가장 | NULL | 최씨 부인, 최계문(어머니) | 1905-01-26 | NULL | NULL | 1197 | Cho | 조 | Chong Soon | 종순 | 20 | 9 | |||||||||||||||||
| Ce5p2ZyiQaerW7jknlH9ig | Pak, Moon Hang | 32 | 32세 | widower | Da Dong | 4/17/1904 | America Maru | 박문항 | NULL | 박Moon Hang | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | 박문행,박문향 | 85 | 가장 | NULL | 박치영(부인), 박치영(딸), 박치영(딸) | 1904-04-17 | NULL | NULL | 1196 | Pak | 박 | Moon Hang | 문항 | 32 | 1 | |||||||||||||||||
| cdzI.p5SSK-HiuJdkKTmLQ | Whang, Ke Whan | 19 | 19세 | single | Seoul | 4/10/1904 | Gaelic | 황계환 | NULL | 황Ke Whan | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 황게환,황케환 | 85 | NULL | NULL | NULL | 1904-04-10 | NULL | NULL | 18 | Whang | 황 | Ke Whan | 계환 | 19 | 7 |