컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d6KO5qwnQe2IBw.0cakpiQ | Kim, Youn Kwan | 40 | 40세 | married | Won San | 3/30/1904 | Korea | 김윤관 | NULL | 김Youn Kwan | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김연관,김운관 | 90 | 가장 | NULL | 김윤관의 처(부인), 김윤관(부인), 김원칠(어머니), 김윤관(아들), 김윤관(아들) | 1904-03-30 | NULL | NULL | 160 | Kim | 김 | Youn Kwan | 윤관 | 40 | 9 | |||||||||||||||||
| d65ASGEqRU6q9kJNTQaKnw | Pak, Keun Young, son (Doo Chung) | 1 | 1세 | single | Poong Kil, San Ye Sil | 7/8/1904 | Mongolia | 박근영 | NULL | 박son (Doo Chung) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박근용,박긴영 | 85 | 아들 | Doo Chung | 두청 | 1904-07-08 | NULL | NULL | 974 | Pak | 박 | Keun Young | 근영 | 1 | 14 | |||||||||||||||||
| d5WsYbnnS6WSfkW-zMKc4g | Cho, Chun Yang | 20 | 20세 | single | Nam San Dong | 12/9/1904 | Mongolia | 조춘양 | NULL | 조Chun Yang | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 조춘용,조천양 | 90 | NULL | NULL | NULL | 1904-12-09 | NULL | NULL | 472 | Cho | 조 | Chun Yang | 춘양 | 20 | 14 | |||||||||||||||||
| D5ulO0CgRGKUAC6D7IiGjQ | Ye, Suk Keun | 33 | 33세 | married | Won Choo | 7/30/1904 | Doric | 이숙근 | 이숙근 | NULL | 예Suk Keun | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | NULL | NULL | NULL | 1904-07-30 | NULL | NULL | 1070 | Ye | 예 | Suk Keun | 숙근 | 33 | 6 | ||||||||||||||||
| d5RkIS7mQJCFuOJTNc-fsA | An, Kyo Chum, son (Chang Son) | 11 | 11세 | single | Sang Soo Koo Pak | 5/8/1905 | Siberia | 안교춤 | NULL | 안son (Chang Son) | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 안교춘,안교천 | 80 | 아들 | Chang Son | 창손 | 1905-05-08 | NULL | NULL | 318 | An | 안 | Kyo Chum | 교춤 | 11 | 17 | |||||||||||||||||
| D5J6xh2oR3eFhA8jSx1z.A | Yi, Hak Hyun | 20 | 20세 | single | Seoul | 3/19/1903 | Korea | 이학현 | NULL | 이Hak Hyun | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 이학헌,이학훈 | 95 | NULL | NULL | NULL | 1903-03-19 | NULL | NULL | 18 | Yi | 이 | Hak Hyun | 학현 | 20 | 9 | |||||||||||||||||
| D5IPp5C3Sj2Tp063ru0.dg | No, Hak Young | 22 | 22세 | widower | Chai Ryung | 12/5/1903 | Doric | 노학영 | NULL | NoHak Young | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 노학용,노학연 | 90 | NULL | NULL | NULL | 1903-12-05 | NULL | NULL | 508 | No | 노 | Hak Young | 학영 | 22 | 6 | |||||||||||||||||
| d5HwscpeRNechPDzOofcfQ | Koo, Cha Yerl | 24 | 24세 | married | Ok Soo Dong | 2/25/1905 | Mongolia | 구차열 | NULL | 구Cha Yerl | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 구자열,구채열 | 85 | NULL | NULL | NULL | 1905-02-25 | NULL | NULL | 1285 | Koo | 구 | Cha Yerl | 차열 | 24 | 14 | |||||||||||||||||
| d4VX4NDoQtWEmOfSJAW92Q | Ye, Yong Ser | 29 | 29세 | married | Suih Heung | 3/19/1903 | Korea | 이용서 | NULL | 예Yong Ser | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예룡서,예용석 | 85 | NULL | NULL | NULL | 1903-03-19 | NULL | NULL | 1284 | Ye | 이 | Yong Ser | 용서 | 29 | 9 | |||||||||||||||||
| D4qvjDdLQyeGUpHDlFOd.g | Yang, Kap Doo | 21 | 21세 | single | Kam Chun | 5/18/1905 | Mongolia | 양갑두 | NULL | 양Kap Doo | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 양갑도,양합두 | 90 | NULL | NULL | NULL | 1905-05-18 | NULL | NULL | 1283 | Yang | 양 | Kap Doo | 갑두 | 21 | 14 | |||||||||||||||||
| D4l0vruySUSzxVlUbnPoCw | Kang, Do Whan, son (Dong Paik) | 1 | 1세 | single | Sam Ni Dong | 9/5/1904 | Korea | 강도환 | NULL | 강son (Dong Paik) | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 강도완,강도관 | 90 | 아들 | Dong Paik | 동백 | 1904-09-05 | NULL | NULL | 492 | Kang | 강 | Do Whan | 도환 | 1 | 9 | |||||||||||||||||
| d4hgs.9TSPy74ZNPS0Edug | Nam, Pum Ye, brother (Kap Chool) | 12 | 12세 | single | Samka | 5/20/1904 | Siberia | 남품예 | NULL | 남brother (Kap Chool) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 남범예,남붐예 | 80 | 형제 | Kap Chool | 갑출 | 1904-05-20 | NULL | NULL | 1282 | Nam | 남 | Pum Ye | 품예 | 12 | 17 | |||||||||||||||||
| D4bmnZSiSDWKUGWtzilvNQ | Ye, Suk Koo | 24 | 24세 | single | An Dong | 7/8/1904 | Mongolia | 이숙구 | 이숙구 | NULL | 예Suk Koo | 2025-09-14 05:57:46 | 2025-12-10 04:32:54 | NULL | NULL | 가장 | NULL | 이숙구의 처(부인), 이숙구의 처(부인) | 1904-07-08 | NULL | NULL | 769 | Ye | 예 | Suk Koo | 숙구 | 24 | 14 | ||||||||||||||||
| D4ahtT7DS3yZz.wENxXRNg | Kim, Yang Nok | 33 | 33세 | widower | Hong Moon Keri | 3/31/1905 | Manchuria | 김양록 | 김양록 | 김야ng노k | 2025-04-01 00:00:00 | 김양록 | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 김현중(부인), 김봉상(부인), 김봉상(아들), 김봉상(아들), 김봉상(아들) | 1905-03-31 | NULL | NULL | 60 | Kim | 김 | Yang Nok | 양록 | 33 | 12 | |||||||||||||||
| d4-ubZIkQMmO2iX7J48CPA | An, Kei Wha | 40 | 40세 | widower | Pom Ark | 1/26/1905 | Korea | 안계화 | NULL | 안Kei Wha | 2025-09-14 05:57:42 | 2025-12-06 10:50:50 | 안게화,안기화 | 85 | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 192 | An | 안 | Kei Wha | 계화 | 40 | 9 | |||||||||||||||||
| D3ZDIj46SYOcafW9mbzNrg | Ye, Ki Eun | 38 | 38세 | married | Ko Sung | 2/18/1904 | Doric | 이기은 | 이기은 | NULL | 예Ki Eun | 2025-09-14 05:57:46 | 2025-12-10 04:31:20 | NULL | NULL | 가장 | NULL | 이병춘(부인), 이공삼(어머니), 이병춘(아들), 이병춘(아들), 이병춘(딸) | 1904-02-18 | NULL | NULL | 424 | Ye | 예 | Ki Eun | 기은 | 38 | 6 | ||||||||||||||||
| d3wToXSbTrayOu4IHFQAGA | Han, Pyeng Yong | 27 | 27세 | married | Eun San, Pan Chun Ye | 5/20/1904 | Siberia | 한평용 | NULL | 한Pyeng Yong | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한병용,한편용 | 90 | NULL | NULL | NULL | 1904-05-20 | NULL | NULL | 1281 | Han | 한 | Pyeng Yong | 평용 | 27 | 17 | |||||||||||||||||
| d3OiiTvYSteTD.LE3UOQ1A | Kim, Yern Soon | 22 | 22세 | single | Whang Suk | 1/6/1905 | Doric | 김연순 | NULL | 김Yern Soon | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | 김염순,김년순 | 85 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 1280 | Kim | 김 | Yern Soon | 연순 | 22 | 6 | |||||||||||||||||
| D2HgMPsHRbGCL22p2VTJ8w | Pak, Choong Won | 22 | 22세 | widower | Sin Young | 3/30/1903 | Gaelic | 박충원 | 박충원 | NULL | 박Choong Won | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1903-03-30 | NULL | NULL | 1279 | Pak | 박 | Choong Won | 충원 | 22 | 7 | ||||||||||||||||
| d2H11LWyQMmk.3xtP.U3dw | Han, Chi Choon, nephew (Ro, Chin Kook) | 11 | 11세 | single | Eun Sun Dong | 5/8/1905 | Siberia | 한치춘 | NULL | 한Chin Kook) | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 한지춘,한치천 | 85 | NULL | Ro, Chin Kook | 노진국 | 1905-05-08 | NULL | NULL | 155 | Han | 한 | Chi Choon | 치춘 | 11 | 17 |