컬럼 구조
id varchar(50)
category varchar(50)
title varchar(500)
names_extracted text
overview text
image_source_2 varchar(500)
photo_year varchar(20)
thumbnail_1 varchar(500)
thumbnail_2 varchar(500)
tags_combined text
update_date datetime
tag_first varchar(100)
video_link varchar(500)
tag_second varchar(100)
additional_info text
tag_third varchar(100)
file_link varchar(500)
creation_date datetime
image_source_1 varchar(500)
private_check varchar(20)
source varchar(200)
page_no varchar(50)
source_2 varchar(200)
created_at timestamp
updated_at timestamp
google_url_backup varchar(500)
photo_year_parsed int
photo_decade varchar(10)
photo_date_approx varchar(20)
person_count int
has_ship_link tinyint(1)
has_patriot_link tinyint(1)
runway_video_url varchar(500)
| id | category | title | names_extracted | overview | image_source_2 | photo_year | thumbnail_1 | thumbnail_2 | tags_combined | update_date | tag_first | video_link | tag_second | additional_info | tag_third | file_link | creation_date | image_source_1 | private_check | source | page_no | source_2 | created_at | updated_at | google_url_backup | photo_year_parsed | photo_decade | photo_date_approx | person_count | has_ship_link | has_patriot_link | runway_video_url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7gNjzr5XRimYZkxZYVojZw | NULL | 하와이 대한인국민회 총회관, 룩 애비뉴(1948-현재) New Headquarters of Kook Min Hur at Rooke Ave. -Korea Times Collectio | 하와이 대한인국민회 총회관 | NULL | media/roberta-jang/original/n8m1rbbfIdviyYjmCqMC.jpg | NULL | media/roberta-jang/thumbs/n8m1rbbfIdviyYjmCqMC.jpg | media/roberta-jang/thumbs/n8m1rbbfIdviyYjmCqMC.jpg | NULL | 2025-07-15 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/NAWTDF39mB | NULL | 그들의 발자취 | 73 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/n8m1rbbfId | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 7Dq-JvDBTnanZOwfLx1ZgQ | 사진 | 하젤(Hazel), 셀라, 마가렛(Margaret), 천진화. 1918년경. 아그네스 노 천 앨범. | 하젤, 셀라, 마가렛, 천진화, 아그네스 | NULL | media/roberta-jang/original/pMS95EZPMFAzVx72PxmV.jpg | NULL | media/roberta-jang/thumbs/pMS95EZPMFAzVx72PxmV.jpg | media/roberta-jang/thumbs/pMS95EZPMFAzVx72PxmV.jpg | NULL | 2025-04-16 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/pMS95EZPMF | 1918 | NULL | 1918년경 | 5 | 0 | 1 | NULL |
| 75rP.9V4QvSFZnecaiOm5A | 사진 | 김종림은 캘리포니아주 윌로우스에 한인비행대를 만들었다. 1920년대경. 민병용 컬렉션. | 김종림, 민병용 | NULL | media/roberta-jang/original/shDzuqTruwrx7aGxdjkJ.jpg | NULL | media/roberta-jang/thumbs/shDzuqTruwrx7aGxdjkJ.jpg | media/roberta-jang/thumbs/shDzuqTruwrx7aGxdjkJ.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/shDzuqTruw | 1920 | 1920년대 | NULL | 2 | 0 | 0 | NULL |
| 73wl2HHDQvybU-aDbAIwoA | 사진 | 미 태평양육군단이 후원하여 한국을 방문하는 제1차 한인협회 친선사절단. 한국의 2성 장군과 미국의 호위단과 함께 촬영한 사진이다. 왼쪽에서 첫번째가 허버트 최(Herbert Cho | 허버트 최 (Herbert Choy), 장원배 (Robert Won Bae Chang), 리처드 유 (Richard You), 바바라 김 야마시타 (Barbara Kim Yamas | NULL | media/roberta-jang/original/y7UmNtoGfi0vET768GFj.jpg | NULL | media/roberta-jang/thumbs/y7UmNtoGfi0vET768GFj.jpg | media/roberta-jang/thumbs/y7UmNtoGfi0vET768GFj.jpg | NULL | 2025-04-19 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/y7UmNtoGfi | 1961 | NULL | NULL | 4 | 1 | 0 | NULL |
| 72oEkc.XRjmmGPeQtuk28w | 사진 | 이정설(Chung Sur)과 이신실(Shin Sil Lee)가족. 아이들 왼쪽부터, 찰스(Charles(Charlie)), 로이(Roy), 애나벨(Annabelle). 1915년경 | 이정설, 이신실, 찰스, 로이, 애나벨, 신시아 최 옹. | NULL | media/roberta-jang/original/hLKUJRJuNT7wian46eLa.jpg | NULL | media/roberta-jang/thumbs/hLKUJRJuNT7wian46eLa.jpg | media/roberta-jang/thumbs/hLKUJRJuNT7wian46eLa.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/hLKUJRJuNT | 1915 | NULL | 1915년경 | 6 | 0 | 0 | NULL |
| 7253fbc6-d4db-41bb-8f7e-9e46760b198f | PDF 색인 | George McAfee McCune Papers | George McAfee McCune (1908-1948, 한국학자/외교관), 이승만 (Syngman Rhee), 김규식 (Kimm Kiusic), 조병옥 (Cho Byung-ok | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-008.2. 155페이지. | NULL | 1920s-1948 | NULL | NULL | McCune, photo, school, Syngman Rhee, college, family, correspondence, military, photograph, Honolulu | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/008.2-GM-McCune-Paper-Finding-aid_202 | NULL | NULL | document | 하와이대 한국학연구소 | NULL | NULL | 2026-01-01 07:08:39 | 2026-01-01 07:41:49 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 6zHzbjWETBua1q1MEtL5-g | NULL | 한인록, 재미한족연합위원회 발행(1942) Registration of Korean Residents compiled by the United Korean Committee in | 한인록 | NULL | media/roberta-jang/original/OBceZwAc1izJ9QOYjtPS.jpg | NULL | media/roberta-jang/thumbs/OBceZwAc1izJ9QOYjtPS.jpg | media/roberta-jang/thumbs/OBceZwAc1izJ9QOYjtPS.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 80 | Dr Anna Chung | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/OBceZwAc1i | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 6TbeeDrlRba4S4W8C7z4ow | 사진 | 차이석. 그의 사촌과 사촌의 아내(뒤). 1920년경. Mabel Paik Meu 앨범. | 차이석, Mabel Paik Meu | NULL | media/roberta-jang/original/uJRWhCSfQGwrVMg7OGq3.jpg | NULL | media/roberta-jang/thumbs/uJRWhCSfQGwrVMg7OGq3.jpg | media/roberta-jang/thumbs/uJRWhCSfQGwrVMg7OGq3.jpg | NULL | 2025-04-16 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/uJRWhCSfQG | 1920 | NULL | 1920년경 | 2 | 0 | 0 | NULL |
| 6RKYyLRRBn6cFNPspgoJ | 사진 | Soy beans | NULL | Soy beans | media/jungnamyong/original/6RKYyLRRBn6cFNPspgoJ.jpg | NULL | media/jungnamyong/thumbs/6RKYyLRRBn6cFNPspgoJ.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #6_107_Soy beans.JPG | NULL | NULL | NULL | NULL | unidentified | 정남용 | NULL | NULL | 2025-12-31 11:41:10 | 2025-12-31 23:12:04 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 6p5RfBphRBSTrnBvHrgZvw | 사진 | 국민회 회원증명서. Mildred Chun Thomas 앨범. | Mildred Chun Thomas | NULL | media/roberta-jang/original/jM4RUdZsr2oWKPy4kDAL.jpg | NULL | media/roberta-jang/thumbs/jM4RUdZsr2oWKPy4kDAL.jpg | media/roberta-jang/thumbs/jM4RUdZsr2oWKPy4kDAL.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/jM4RUdZsr2 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 6mD0ULhBQPWjj8S4RJQWrA | NULL | 해방후에도 조국돕기에 앞장선 전후 부인구제회 (1946) Tons of relief goods ready to ship to Korea, Korean Women*s Relief S | 전후 부인구제회 | NULL | media/roberta-jang/original/LloO1TDLSlNI2nTQNIKT.jpg | NULL | media/roberta-jang/thumbs/LloO1TDLSlNI2nTQNIKT.jpg | media/roberta-jang/thumbs/LloO1TDLSlNI2nTQNIKT.jpg | NULL | 2025-07-13 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/4NuAsSA3Kn | NULL | 그들의 발자취 | 102 | Mrs Phyllis Dunn Collection | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/LloO1TDLSl | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 6c72d962-44f4-431d-81ac-744c48ef5cfb | PDF 색인 | Robert A. Kinney Collection | Robert A. Kinney (한국전문가), 백낙준 (L. George Paik, 연세대 총장), 강용흘 (Younghill Kang, 작가), 김활란 (Helen Kim), J | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-009. 19페이지. | NULL | 1945-1953 | NULL | NULL | military, Korean, Hawaii, mission, university, Presbyterian, Kinney, letter, education, Korea, war, | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/009-Robert-A-Kinney-Collection-List-2 | NULL | NULL | document | 하와이대 한국학연구소 | NULL | NULL | 2026-01-01 07:08:40 | 2026-01-01 07:41:49 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 67e987cc-0a81-42be-bc32-b026747562ca | PDF 색인 | William E. Henthorn Papers | William E. Henthorn (1928-1993, 한국학자), Forrest R. Pitts | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-004. 9페이지. | NULL | 1950s-1990s | NULL | NULL | photo, military, Korean, Hawaii, Honolulu, university, Korea | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/004-William-E-Henthorn-List2021.pdf | NULL | NULL | document | 하와이대 한국학연구소 | NULL | NULL | 2026-01-01 07:08:39 | 2026-01-01 07:26:28 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 5uOOjcH8Tmyd2JOF2aHxGw | NULL | 구 동지회 건물，킹 스트릿 (1993) Former Dongji Hoi Building on King Street, Honolulu | 동지회 | NULL | media/roberta-jang/original/1VSzy9hKNkSKJCvam6dj.jpg | NULL | media/roberta-jang/thumbs/1VSzy9hKNkSKJCvam6dj.jpg | media/roberta-jang/thumbs/1VSzy9hKNkSKJCvam6dj.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 87 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/1VSzy9hKNk | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 5udwmePFSYiRdKWdrWtmRQ | 사진 | 야구 영웅 위인선과 김원도. 사라 리(Sarah Lee) 앨범. | 야구 영웅 위인선, 김원도, 사라 리(Sarah Lee) | NULL | media/roberta-jang/original/nJyPYAGsfKB1UWypZ7j5.jpg | NULL | media/roberta-jang/thumbs/nJyPYAGsfKB1UWypZ7j5.jpg | media/roberta-jang/thumbs/nJyPYAGsfKB1UWypZ7j5.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/nJyPYAGsfK | NULL | NULL | NULL | 3 | 0 | 0 | NULL |
| 5s2OYEjDTsScqwIvKeNIPA | 사진 | 이종님(Chong Nim Lee Char)과 딸 제시(Jessie (Song)). 1915sus. 제시(Jessie Char Song) 앨범. | 이종님, 제시 | NULL | media/roberta-jang/original/20GxertiCWgdhHfAWbBT.jpg | NULL | media/roberta-jang/thumbs/20GxertiCWgdhHfAWbBT.jpg | media/roberta-jang/thumbs/20GxertiCWgdhHfAWbBT.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/20GxertiCW | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| 5OY6RglTb34ZzXkmJ0Nx | 사진 | An boat at low tide, Incheon | NULL | An boat at low tide, Incheon | media/jungnamyong/original/5OY6RglTb34ZzXkmJ0Nx.jpg | 1945 | media/jungnamyong/thumbs/5OY6RglTb34ZzXkmJ0Nx.jpg | NULL | NULL | NULL | Incheon | NULL | NULL | #1_1_An boat at low tide, Incheon_1945.JPG | NULL | NULL | NULL | NULL | unidentified | 정남용 | NULL | NULL | 2025-12-31 11:41:10 | 2025-12-31 23:12:04 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 5mPh1JhGFJwgMVUMTSio | 사진 | a lake | NULL | Seoul city park - a lake | media/jungnamyong/original/5mPh1JhGFJwgMVUMTSio.jpg | NULL | media/jungnamyong/thumbs/5mPh1JhGFJwgMVUMTSio.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #2_24_Seoul city park - a lake.JPG | NULL | NULL | NULL | NULL | unidentified | 정남용 | NULL | NULL | 2025-12-31 11:41:10 | 2025-12-31 23:12:04 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 5m0y7cC5QlKDWqAKyUOCuw | 사진 | 1909년 감리교회 총회. 한일합동 연례총회는 대부분 한인지역에서 진행되었다. 1909년 한국인과 일본인 간의 대립이 절정에 달했다. 민병용 컬렉션. | 민병용 | NULL | media/roberta-jang/original/7arAKA352RlwwMg7QCCg.jpg | NULL | media/roberta-jang/thumbs/7arAKA352RlwwMg7QCCg.jpg | media/roberta-jang/thumbs/7arAKA352RlwwMg7QCCg.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/7arAKA352R | 1909 | NULL | NULL | 1 | 0 | 0 | NULL |
| 5GmazKNzSA-EegkYHTARXQ | NULL | t수잔나 웨슬리 홈，감리교 선교사회기관，동양계 독신여성，어린이들이 보호받았다 뒷줄 오른쪽에서 세번째가 문또라 전도사와 월라 문 모녀(1903) Susannah Wesley Home | 수잔나 웨슬리, 문또라 전도사, 월라 문, 도라 문 | NULL | media/roberta-jang/original/TkJEDbfSJppdfY6D4haJ.jpg | NULL | media/roberta-jang/thumbs/TkJEDbfSJppdfY6D4haJ.jpg | media/roberta-jang/thumbs/TkJEDbfSJppdfY6D4haJ.jpg | NULL | 2025-07-15 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/MR9ppcXCfp | NULL | 그들의 발자취 | 129 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/TkJEDbfSJp | NULL | NULL | NULL | 4 | 0 | 0 | NULL |