컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| WX7QgWgkRMy4iDCmWavxPA | Pai, Ki An | 31 | 31세 | single | Chin Ham | 5/6/1904 | Doric | 배기안 | NULL | PaiKi An | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 배기언,백기안 | 85 | NULL | NULL | NULL | 1904-05-06 | NULL | NULL | 506 | Pai | 배 | Ki An | 기안 | 31 | 6 | |||||||||||||||||
| wwYnBtiiRuufwGSmrgvm-g | Kim, Kyeng Kap | 25 | 25세 | single | No Wha | 2/2/1905 | Coptic | 김경갑 | NULL | 김Kyeng Kap | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | 김경각,김경합 | 88 | 가장 | NULL | 김봉춘(부인), 김도관(아들) | 1905-02-02 | NULL | NULL | 705 | Kim | 김 | Kyeng Kap | 경갑 | 25 | 4 | |||||||||||||||||
| wWyc7-rIQrGmlA5VVhpikA | Sin, Kong Sup | 31 | 31세 | widower | Nong Am | 7/8/1904 | Mongolia | 신공섭 | NULL | 신Kong Sup | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 신공습,신공십 | 85 | NULL | NULL | NULL | 1904-07-08 | NULL | NULL | 3227 | Sin | 신 | Kong Sup | 공섭 | 31 | 14 | |||||||||||||||||
| wWxvWtXwTz-peF1qc43Ewg | Pak, In Whan | 24 | 24세 | married | Sa Kok Li | 10/1/1904 | America Maru | 박인환 | NULL | 박In Whan | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박인완,박인한 | 90 | NULL | NULL | NULL | 1904-10-01 | NULL | NULL | 3226 | Pak | 박 | In Whan | 인환 | 24 | 1 | |||||||||||||||||
| WwsINZ2YQvemWppJDGVCig | Kim, Chun Yer, son (Kim, Ke Young) | 1 | 1세 | single | Ka Nap Dong | 11/2/1904 | Manchuria | 김춘열 | NULL | 김Ke Young) | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김춘엽,김춘여 | 75 | 아들 | Kim, Ke Young | 김, 계영 | 1904-11-02 | NULL | NULL | 600 | Kim | 김 | Chun Yer | 춘열 | 1 | 12 | |||||||||||||||||
| wwOFMcLDT2qwikWCpdrW2Q | Son, Chi Young | 26 | 26세 | single | Eui Sung | 2/8/1904 | China | 손치영 | NULL | 손Chi Young | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 손지영,손치용 | 88 | NULL | NULL | NULL | 1904-02-08 | NULL | NULL | 392 | Son | 손 | Chi Young | 치영 | 26 | 3 | |||||||||||||||||
| wwO7a4edSGKmEZkOwFYE8g | Choi, Choon Yer, son 3 (Pong Sin) | 6 | 6세 | single | Tong An | 6/1/1904 | Coptic | 최춘여 | NULL | 최son 3 (Pong Sin) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최춘염,최춘연 | 82 | 아들 | Pong Sin | 봉신 | 1904-06-01 | NULL | NULL | 152 | Choi | 최 | Choon Yer | 춘여 | 6 | 4 | |||||||||||||||||
| WWmxDxMHSE2p-t64TP2fFw | Pak, Han Yong, brother (Chung Deuk) | 11 | 11세 | single | Seoul, Cho Chon Kerl | 6/25/1904 | Gaelic | 박한용 | NULL | 박brother (Chung Deuk) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박한영,박한룡 | 89 | 형제 | Chung Deuk | 정득 | 1904-06-25 | NULL | NULL | 530 | Pak | 박 | Han Yong | 한용 | 11 | 7 | |||||||||||||||||
| wWku6eSeRT-NT.Sw.0fBCg | Chung, Chin Sang | 36 | 36세 | married | Ha Yang | 12/28/1903 | Siberia | 정진상 | NULL | 정Chin Sang | 2025-09-14 05:57:43 | 2025-12-10 04:59:17 | 정진성,정진삼 | 88 | 가장 | NULL | 정진상의 처(부인), 정씨의 자(아들) | 1903-12-28 | NULL | NULL | 1715 | Chung | 정 | Chin Sang | 진상 | 36 | 17 | |||||||||||||||||
| WwKBqZCQQe6NzqFu3sH3KA | Choo, Chung Soon | 20 | 20세 | married | Choo Soh | 12/9/1904 | Mongolia | 주정순 | NULL | ChooChung Soon | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 추정순,주충순 | 87 | NULL | NULL | NULL | 1904-12-09 | NULL | NULL | 3225 | Choo | 주 | Chung Soon | 정순 | 20 | 14 | |||||||||||||||||
| wwIAIwbyRninG5FfQJkYuA | Cho, Sung Chil | 23 | 23세 | married | Noo Kak Dong | 3/31/1905 | Manchuria | 조성칠 | NULL | 조Sung Chil | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 조성질,조승칠 | 90 | NULL | NULL | NULL | 1905-03-31 | NULL | NULL | 126 | Cho | 조 | Sung Chil | 성칠 | 23 | 12 | |||||||||||||||||
| WW7HDRiTQPGxn3JHEUCutw | Cho, Pong Sung | 21 | 21세 | widower | Sung Choo | 12/5/1903 | Doric | 조봉성 | NULL | 조Pong Sung | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 조봉승,조방성 | 89 | NULL | NULL | NULL | 1903-12-05 | NULL | NULL | 59 | Cho | 조 | Pong Sung | 봉성 | 21 | 6 | |||||||||||||||||
| WVRQ46ZcQEucl...8H1Djg | Pak, In Kiu, wife | 29 | 29세 | married | Sang Soo Koo Pak | 5/29/1905 | China | 박처 | 박처 | NULL | 박wife | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | 부인 | NULL | NULL | 1905-05-29 | NULL | NULL | 318 | Pak | 박 | In Kiu | 처 | 29 | 3 | ||||||||||||||||
| wvLDUsfjRQWFoi8klIbZeg | Im, Chung Soh | 36 | 36세 | married | Seoul | 4/14/1903 | China | 임정서 | NULL | 임Chung Soh | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 임정소,임충서 | 83 | NULL | NULL | NULL | 1903-04-14 | NULL | NULL | 18 | Im | 임 | Chung Soh | 정서 | 36 | 3 | |||||||||||||||||
| wvJYKE5xTWyq7VXP7ClQdw | Chun, Soon Pai | 27 | 27세 | married | Dong Mak | 2/2/1905 | Coptic | 전순배 | NULL | 전Soon Pai | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 천순배,전순백 | 86 | NULL | NULL | NULL | 1905-02-02 | NULL | NULL | 2929 | Chun | 전 | Soon Pai | 순배 | 27 | 4 | |||||||||||||||||
| WVg0oGACQgyOiQKWnCpn0A | Ye, Wo Ok | 24 | 24세 | married | Chun Dong | 9/5/1904 | Korea | 이우옥 | NULL | 예Wo Ok | 2025-09-14 05:57:46 | 2025-12-10 04:33:32 | 예우억,예우욱 | 82 | 가장 | NULL | 이우옥의 처(부인), 이기원(부인), 이중민(아들) | 1904-09-05 | NULL | NULL | 52 | Ye | 이 | Wo Ok | 우옥 | 24 | 9 | |||||||||||||||||
| wVa-UGSQSvuFf2arzXE2dA | Ye, Heung Tai | 23 | 23세 | married | Won Chung Li | 11/29/1904 | Siberia | 이흥태 | NULL | 예Heung Tai | 2025-09-14 05:57:46 | 2025-12-10 04:33:32 | 예흥택,예흥탁 | 89 | 가장 | NULL | 이흥태의 처(부인) | 1904-11-29 | NULL | NULL | 682 | Ye | 이 | Heung Tai | 흥태 | 23 | 17 | |||||||||||||||||
| WV98fcY3RFuPdgZWCCStbw | Chung, Won Myeng | 25 | 25세 | single | Pyeng Yang | 2/8/1904 | China | 정원명 | 정원 Myeng | 2025-03-11 00:00:00 | 정Won Myeng | 윌라 정의 남편, 초대 한인교회목사 | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-02-08 | NULL | NULL | 58 | Chung | 정 | Won Myeng | 원명 | 25 | 3 | |||||||||||||||
| Wv2uUJNuT3yCCka8Ml7FWA | Pak, Man Po | 30 | 30세 | married | Pa Choo | 10/5/1903 | Siberia | 박만보 | 박만 Po | 경기도 파주 | 2025-03-09 00:00:00 | 박Man Po | 1922년과 1923년 경향잡지 기부기록 | 2025-09-14 05:57:45 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 박연황(아들) | 1903-10-05 | NULL | NULL | 3224 | Pak | 박 | Man Po | 만보 | 30 | 17 | ||||||||||||||
| WV2cq8WeSdmNuUvohJE6IA | Pak, Hyeng Mo | 32 | 32세 | married | Hoi Yang | 3/4/1904 | Siberia | 박형모 | 박형모 | NULL | 박형모 | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1904-03-04 | NULL | NULL | 486 | Pak | 박 | Hyeng Mo | 형모 | 32 | 17 |