컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a.lqeyl6MQiG6nUrdp0awzg | Song, Man Yer | 22 | 22세 | married | Owi Ter | 1/6/1905 | Doric | 송만여 | NULL | 송Man Yer | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 송만열,송만엽 | 85 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 890 | Song | 송 | Man Yer | 만여 | 22 | 6 | |||||||||||||||||
| a.lb2t3yQE-QzHPf5taq5g | Sin, Chung Kyun | 21 | 21세 | married | Mi Nam Ye | 1/26/1905 | Korea | 신충균 | NULL | 신Chung Kyun | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 신중균,신충근 | 90 | NULL | NULL | NULL | 1905-01-26 | NULL | NULL | 581 | Sin | 신 | Chung Kyun | 충균 | 21 | 9 | |||||||||||||||||
| a.KZ0Mh7cTrSIZFZ3.sM5mQ | Kim, Young Whan | 24 | 24세 | single | Younghung | 5/20/1904 | Siberia | 김영환 | NULL | 김Young Whan | 2025-09-14 05:57:44 | 2025-12-10 04:34:46 | 김영완,김영한 | 90 | 가장 | NULL | 김영환의 처(부인), 김진용(부인), 김택기(아들), 김진용(아들), 김진용(딸), 김진용(자매) | 1904-05-20 | NULL | NULL | 889 | Kim | 김 | Young Whan | 영환 | 24 | 17 | |||||||||||||||||
| a.KVVvjHsR2u5nzH4BfMkwA | Kim, Eun Sik | 28 | 28세 | married | 인천 | 4/26/1904 | China | 김은식 | 김은식 | 김은식 | 2025-04-18 00:00:00 | 김은식 | 2025-09-14 05:57:44 | 2025-12-06 16:53:31 | NULL | NULL | 가장 | NULL | 김송의(부인), 김송의(어머니) | 1904-04-26 | NULL | NULL | 188 | Kim | 김 | Eun Sik | 은식 | 28 | 3 | |||||||||||||||
| a.kRrZbG7Sdu9q5y5u0Sl-w | Paik, Youn Sang | 22 | 22세 | single | Yong Sang | 4/17/1904 | America Maru | 백윤상 | NULL | PaikYoun Sang | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 백운상,백윤산 | 90 | NULL | NULL | NULL | 1904-04-17 | NULL | NULL | 888 | Paik | 백 | Youn Sang | 윤상 | 22 | 1 | |||||||||||||||||
| a.kJCinN4RUK2zBXCLusgJw | Im, Chung Sook | 35 | 35세 | married | Ja Choo | 3/30/1903 | Gaelic | 임충숙 | NULL | 임Chung Sook | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 임충석,임중숙 | 90 | NULL | NULL | NULL | 1903-03-30 | NULL | NULL | 887 | Im | 임 | Chung Sook | 충숙 | 35 | 7 | |||||||||||||||||
| a.kGte-VUTAmfORVYiK3.Pg | Ye, Won Paik | 26 | 26세 | widower | Kei Dong | 3/31/1905 | Manchuria | 이원백 | NULL | 예Won Paik | 2025-09-14 05:57:46 | 2025-12-06 16:53:31 | 예원팔,예원박 | 85 | 가장 | NULL | 이창근(아들) | 1905-03-31 | NULL | NULL | 713 | Ye | 이 | Won Paik | 원백 | 26 | 12 | |||||||||||||||||
| a.JWxe5kQQJOCnbEK64QQVg | Ye, In Ker | 25 | 25세 | married | Da Dai | 3/10/1905 | China | 이인걸 | NULL | 예In Ker | 2025-09-14 05:57:46 | 2025-12-06 16:53:31 | 예인겸,예인검 | 85 | 가장 | NULL | 이만용(부인), 이만용(자매) | 1905-03-10 | NULL | NULL | 886 | Ye | 이 | In Ker | 인걸 | 25 | 3 | |||||||||||||||||
| a.jVZYOmQQ5q770vPYwlQXg | Pak, Pyerl Choong | 24 | 24세 | single | Soo Pyeng Li | 1/6/1905 | Doric | 박별중 | NULL | 박Pyerl Choong | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 박벽중,박평중 | 80 | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 885 | Pak | 박 | Pyerl Choong | 별중 | 24 | 6 | |||||||||||||||||
| a.Js1IpNISwuVzjycJQBfOw | Soh, Sang Keun, daughter (Kan Ani) | 1 | 1세 | single | Doon Chung Li | 2/2/1905 | Coptic | 서상근 | NULL | 서daughter (Kan Ani) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 소상근,서상긴 | 88 | 딸 | Kan Ani | 간아니 | 1905-02-02 | NULL | NULL | 646 | Soh | 서 | Sang Keun | 상근 | 1 | 4 | |||||||||||||||||
| a.jmoYiFNS2GFPpOQ8u9utw | Kim, Pong Kiu | 24 | 24세 | widower | Pang San | 1/26/1905 | Korea | 김봉규 | NULL | 김Pong Kiu | 2025-09-14 05:57:44 | 2025-12-10 04:59:17 | 김봉구,김방규 | 88 | 가장 | NULL | 김봉규의 처(부인), 김씨의 자(아들) | 1905-01-26 | NULL | NULL | 884 | Kim | 김 | Pong Kiu | 봉규 | 24 | 9 | |||||||||||||||||
| a.J-GfvsCRfKgS7xLWm8l.A | Ye, Eung Mok, son (Soo Nam) | 3 | 3세 | single | Sa San Dong | 4/13/1905 | Korea | 이응목 | NULL | 예son (Soo Nam) | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 예웅목,예응묵 | 85 | 아들 | Soo Nam | 수남 | 1905-04-13 | NULL | NULL | 403 | Ye | 이 | Eung Mok | 응목 | 3 | 9 | |||||||||||||||||
| a.IumGsrzSLGBEn4L0ETwhQ | You, Duk Cho | 38 | 38세 | married | Chang Won | 7/11/1904 | America Maru | 유덕조 | NULL | 유Duk Cho | 2025-09-14 05:57:46 | 2025-12-06 10:50:50 | 류덕조,유덕초 | 88 | NULL | NULL | NULL | 1904-07-11 | NULL | NULL | 686 | You | 유 | Duk Cho | 덕조 | 38 | 1 | |||||||||||||||||
| a.iO7Er3ZQ3SljBhDeHTyBA | Cho, Youn Yer | 28 | 28세 | married | Chong Kan Dong | 3/10/1905 | China | 조윤여 | NULL | 조Youn Yer | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 조윤열,조운여 | 85 | NULL | NULL | NULL | 1905-03-10 | NULL | NULL | 883 | Cho | 조 | Youn Yer | 윤여 | 28 | 3 | |||||||||||||||||
| a.ImY.ScQTHK6PVEGRjM.7A | Choi, Chai Duk | 29 | 29세 | widower | Sin Chun Dong | 10/6/1904 | China | 최채덕 | NULL | 최Chai Duk | 2025-09-14 05:57:43 | 2025-12-06 16:53:31 | 최체덕,최재덕 | 88 | 가장 | NULL | 최만흥(부인) | 1904-10-06 | NULL | NULL | 882 | Choi | 최 | Chai Duk | 채덕 | 29 | 3 | |||||||||||||||||
| a.i5smkbSSziftofFEJei4Q | Ha, Pan Kiu | 29 | 29세 | single | Chong Hyen | 2/13/1905 | Siberia | 하판규 | NULL | 하Pan Kiu | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 하반규,하판구 | 85 | NULL | NULL | NULL | 1905-02-13 | NULL | NULL | 881 | Ha | 하 | Pan Kiu | 판규 | 29 | 17 | |||||||||||||||||
| a.I4eqw3CT8i98oO7h1cCwg | Choi, Yong Sik | 24 | 24세 | married | Pong Wha Chai | 5/29/1905 | China | 최용식 | 최용식 | NULL | 최Yong Sik | 2025-09-14 05:57:43 | 2025-12-10 04:34:41 | NULL | NULL | 가장 | NULL | 최용식의 처(부인), 최용식의 처(부인) | 1905-05-29 | NULL | NULL | 880 | Choi | 최 | Yong Sik | 용식 | 24 | 3 | ||||||||||||||||
| a.I1fAj-mT9Chl1zEoeQnKw | No, Heung Keun, son 2 (Kum Dong) | 4 | 4세 | single | Oh Ma Tong | 3/30/1904 | Korea | 노흥근 | NULL | Noson 2 (Kum Dong) | 2025-09-14 05:57:45 | 2025-12-06 10:50:50 | 노흥긴,노흥건 | 88 | 아들 | Kum Dong | 금동 | 1904-03-30 | NULL | NULL | 879 | No | 노 | Heung Keun | 흥근 | 4 | 9 | |||||||||||||||||
| a.Hv8hhIrR0OhA8X1-AHpsg | Choi, Hak Sung | 33 | 33세 | widower | Pyerk-san | 12/24/1904 | China | 최학성 | NULL | 최Hak Sung | 2025-09-14 05:57:43 | 2025-12-06 10:50:50 | 최학승,최학송 | 92 | NULL | NULL | NULL | 1904-12-24 | NULL | NULL | 878 | Choi | 최 | Hak Sung | 학성 | 33 | 3 | |||||||||||||||||
| a.HudfzXzTd6ZPs.YzeuHIg | Kim, Eun Yerp | 25 | 25세 | single | Chak Keri | 1/6/1905 | Doric | 김은엽 | 김은엽 | NULL | 김Eun Yerp | 2025-09-14 05:57:44 | 2025-12-06 10:50:50 | NULL | NULL | NULL | NULL | NULL | 1905-01-06 | NULL | NULL | 877 | Kim | 김 | Eun Yerp | 은엽 | 25 | 6 |