컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| akqNeh6HQwGH4yWN-06NEA | 사진 | 알 장. 종군사진가로 한국전쟁을 사진으로 기록하여 훈장을 받았다. 1953년경. 알 장 사진. | 알 장 | NULL | media/roberta-jang/original/sVvl07ZoxjKR92EIogtM.jpg | NULL | media/roberta-jang/thumbs/sVvl07ZoxjKR92EIogtM.jpg | media/roberta-jang/thumbs/sVvl07ZoxjKR92EIogtM.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 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/sVvl07Zoxj | 1953 | NULL | 1953년경 | 1 | 0 | 0 | NULL |
| akJqsSueS4KqTrsARY0jSg | 사진 | 알리이올라니 공립학교(Aliiolani Public School) 옆 카이무키의 한인기독학원. 민찬호 목사도 함께 사진촬영을 하였다. 1920-21년경. 살로메 한(Salome H | 알리이올라니 공립학��, 민찬호 목사, 살로메 한 | NULL | media/roberta-jang/original/KR8qgYl7TGFIKAuMlCmb.jpg | NULL | media/roberta-jang/thumbs/KR8qgYl7TGFIKAuMlCmb.jpg | media/roberta-jang/thumbs/KR8qgYl7TGFIKAuMlCmb.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/KR8qgYl7TG | NULL | NULL | NULL | 3 | 0 | 0 | NULL |
| AkC6ftacvalzqRQVc0Oy | 사진 | NULL | NULL | NULL | media/salome-choehan/original/AkC6ftacvalzqRQVc0Oy.jpg | NULL | media/salome-choehan/thumbs/AkC6ftacvalzqRQVc0Oy.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 00018.JPG | NULL | NULL | NULL | NULL | unidentified | 살로메최한 | NULL | JOEL PAHK | 2025-12-31 11:41:10 | 2025-12-31 11:41:10 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| ahp2miDESyi8oVfe6x51-g | NULL | 하와이 기록영화 무궁화동산 촬영장에서 (1947—8) 제작 : 도진호. 사진 : 조지 타하라, 감독 : 안철영，해설 : 이상억, 이준영 (농과대 유학생) “The Garden of | 도진호, 안철영, 이상억, 이준영, Chui Young Ahn, Chin Ho Tough, George Tahara, Samuel Lee, Choon Young Lee | NULL | media/roberta-jang/original/3Ensymq7aqkbADxO29nl.jpg | NULL | media/roberta-jang/thumbs/3Ensymq7aqkbADxO29nl.jpg | media/roberta-jang/thumbs/3Ensymq7aqkbADxO29nl.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/wfHRbfi1cA | NULL | 그들의 발자취 | 194 | Dr. Samuel Lee 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/3Ensymq7aq | NULL | NULL | NULL | 9 | 0 | 0 | NULL |
| AH0kVsblRy-LBdMcS82BPA | 사진 | 젊은 한인 1.5세들의 지도자이자 상담자였던(Tai Sung Lee). 왼쪽부터 시계방향으로, 이태성, 황준태(Joon Tai Whang), 에밀리 신 황(Emily Shin Wh | Tai Sung Lee, 이태성, 황준태(Joon Tai Whang), 에밀리 신 황(Emily Shin Whang), 메리 리(Mary Lee), Richard Lee, Anni | NULL | media/roberta-jang/original/TUmag5VY0InKs9j9qTlM.jpg | NULL | media/roberta-jang/thumbs/TUmag5VY0InKs9j9qTlM.jpg | media/roberta-jang/thumbs/TUmag5VY0InKs9j9qTlM.jpg | NULL | 2025-04-18 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/TUmag5VY0I | 1919 | NULL | 1919년경 | 7 | 0 | 1 | NULL |
| acCzED-2S7ubs9Guj0ORfg | NULL | 호놀룰루 한인기독교회 찬양대, 지휘:남패니(1938) Honolulu Korean Christian Church Choir, Director : Miss Fannie Nahm | 남패니 (Miss Fannie Nahm) | NULL | media/roberta-jang/original/mwWpIe2LVTLk82bpdzoD.jpg | NULL | media/roberta-jang/thumbs/mwWpIe2LVTLk82bpdzoD.jpg | media/roberta-jang/thumbs/mwWpIe2LVTLk82bpdzoD.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/ix2L6uA75J | NULL | 그들의 발자취 | 163 | 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/mwWpIe2LVT | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| A9TSjGxZikwsIPfzqrrh | 사진 | NULL | NULL | Two woman on the road in Mokp'o - Mom's village | media/jungnamyong/original/A9TSjGxZikwsIPfzqrrh.jpg | 1945 | media/jungnamyong/thumbs/A9TSjGxZikwsIPfzqrrh.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_36_Two woman on the road in Mokp'o - Mom's village_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 |
| a496e90c-78ab-4d11-999e-83a90a1c3bf9 | PDF 색인 | Arthur Lynn Becker Papers | Arthur Lynn Becker (백아덕, 선교사), 유억겸 (Yu Uk-kyom, 교육자), 평양숭실, 숭실과학 | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-008.5. 151페이지. | NULL | 1900s-1960s | NULL | NULL | Hyun, McCune, school, college, family, military, Methodist, Honolulu, university, Presbyterian, Kore | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/008.5-ALB-finding-aid_2024.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 |
| A2Qxz0TOWgr1mYrTAIk7 | 사진 | NULL | NULL | NULL | media/salome-choehan/original/A2Qxz0TOWgr1mYrTAIk7.jpg | NULL | media/salome-choehan/thumbs/A2Qxz0TOWgr1mYrTAIk7.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #03_ 00008.JPG | NULL | NULL | NULL | NULL | unidentified | 살로메최한 | NULL | JOEL PAHK | 2025-12-31 11:41:10 | 2025-12-31 11:41:10 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| A1u8TyN5Yusnq7i0qMdB | 사진 | NULL | NULL | NULL | media/salome-choehan/original/A1u8TyN5Yusnq7i0qMdB.jpg | NULL | media/salome-choehan/thumbs/A1u8TyN5Yusnq7i0qMdB.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 00008.JPG | NULL | NULL | NULL | NULL | unidentified | 살로메최한 | NULL | JOEL PAHK | 2025-12-31 11:41:10 | 2025-12-31 11:41:10 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| a.ViMBPwdT-y-rbVpyDDaIQ | 사진 | 텍스트 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 28 | NULL | 2025-09-14 05:59:58 | 2026-01-19 08:25:19 | NULL | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| a.uZ90oFrSxS8YXuG2eDskw | NULL | 올리브 연합감리교회 주일학교 (1945) Olive United Methodist Church, Wahiawa | 올리브 연합감리교회 | NULL | media/roberta-jang/original/ebxMbD5pRckHMISt5chC.jpg | NULL | media/roberta-jang/thumbs/ebxMbD5pRckHMISt5chC.jpg | media/roberta-jang/thumbs/ebxMbD5pRckHMISt5chC.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 132 | 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/ebxMbD5pRc | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| a.rl6AohNQQWZulH0xeC3Mg | 사진 | 호놀롤루의 밀러 스트리트에 설립된 최초의 합성협회 본부. 1907년. 천안 독립기념관 컬렉션. | 밀러 스트리트 | NULL | media/roberta-jang/original/R9U0RffF3LLnGSWkwGqD.jpg | NULL | media/roberta-jang/thumbs/R9U0RffF3LLnGSWkwGqD.jpg | media/roberta-jang/thumbs/R9U0RffF3LLnGSWkwGqD.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/R9U0RffF3L | 1907 | NULL | NULL | 1 | 0 | 0 | NULL |
| a.P0bPvmoTQGtDshTNSjPHw | 사진 | 새 이민을 맞이하는 선착 이민들(1904) Earlier immigrants greet new arrivals | 선착 이민들 | NULL | media/roberta-jang/original/djRgPikig78oxt5vPssy.jpg | NULL | media/roberta-jang/thumbs/djRgPikig78oxt5vPssy.jpg | media/roberta-jang/thumbs/djRgPikig78oxt5vPssy.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 29 | 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/djRgPikig7 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| a.oeHB8VSoS3Nc2awsG5sg | NULL | 우리는 진구 (W20) Picture brides with their children | 진구 | NULL | media/roberta-jang/original/VEN3B03o2UiwNXPeTbNP.jpg | NULL | media/roberta-jang/thumbs/VEN3B03o2UiwNXPeTbNP.jpg | media/roberta-jang/thumbs/VEN3B03o2UiwNXPeTbNP.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/31fLyzDPQl | NULL | 그들의 발자취 | 54 | Mrs. Yun Hee Chun Given | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/VEN3B03o2U | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| a.LMb9iyFQu6TakVr8IGzwQ | NULL | 성누가교회, 성엘리자베스 성당시절 (1907—1923)의 성가대 (1920) St. Elizabeth^ period Choir | 성누가교회, 성엘리자베스 성당 | NULL | media/roberta-jang/original/MjTLmWdDPSBEY1krlJ0W.jpg | NULL | media/roberta-jang/thumbs/MjTLmWdDPSBEY1krlJ0W.jpg | media/roberta-jang/thumbs/MjTLmWdDPSBEY1krlJ0W.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 145 | 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/MjTLmWdDPS | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| a.I9ehVHaTBKWdIC-tgYK6g | 사진 | 라나킬라(LanaKila) 한인노인회의 표어는 '우리는 즐긴다, 우리는 배운다, 우리는 봉사한다'이다. 노인회 회장 토니 리(Toni Lee)는 '우리는 건강을 지킨다'를 덧붙였다 | 라나킬라, 토니 리 | NULL | media/roberta-jang/original/i32Buv44ZNwPEQdBmCNQ.jpg | NULL | media/roberta-jang/thumbs/i32Buv44ZNwPEQdBmCNQ.jpg | media/roberta-jang/thumbs/i32Buv44ZNwPEQdBmCNQ.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 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/i32Buv44ZN | 1999 | NULL | 1999년경 | 2 | 0 | 0 | NULL |
| a.33bML39TDuqErJTPvo5FA | NULL | 외국인 등록증 Specimen form - alien registration | 외국인 등록증 | NULL | media/roberta-jang/original/E5mraTSWlDmahbhCaXmH.jpg | NULL | media/roberta-jang/thumbs/E5mraTSWlDmahbhCaXmH.jpg | media/roberta-jang/thumbs/E5mraTSWlDmahbhCaXmH.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 202 | 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/E5mraTSWlD | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| a.2F2N-EQTnqbb1U2a8T7qw | NULL | 박용만장군 (1914년경) Mr. Yong Man Park riding his horse (Circa 1914) | 박용만장군 | NULL | media/roberta-jang/original/6jIvuXXYYMpbJwPhKB0s.jpg | NULL | media/roberta-jang/thumbs/6jIvuXXYYMpbJwPhKB0s.jpg | media/roberta-jang/thumbs/6jIvuXXYYMpbJwPhKB0s.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/imrvpTvv9x | NULL | 그들의 발자취 | 68 | Independence Hall of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/6jIvuXXYYM | 1914 | NULL | 1914년경 | 1 | 0 | 0 | NULL |
| a.0s2tGgMT-KWr0QtwaRKVw | 사진 | 1923년에 발급된 출생증명서. 정기화(Charles Ki Wha Chung) 앨범. | Charles Ki Wha Chung | NULL | media/roberta-jang/original/8326XYosf9RFzNERk36c.jpg | NULL | media/roberta-jang/thumbs/8326XYosf9RFzNERk36c.jpg | media/roberta-jang/thumbs/8326XYosf9RFzNERk36c.jpg | NULL | 2025-04-18 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/8326XYosf9 | 1923 | NULL | NULL | 1 | 0 | 0 | NULL |