컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a.0lk-9sSRQS6SzBSRRYTWg | 사진 | 한국 해방운동을 지원한 호머 헐버트와 하와이에서 건너온 3명의 한인 학생들. 왼쪽부터, 북아메리카 한인학생연합의 회장인 이병두(William Pyong Doo Lee), 양유찬(Y | 호머 헐버트, 이병두, 양유찬, 김계봉, 김영기. | NULL | media/roberta-jang/original/uqtTZ5BAXs1MnUWyBeF5.jpg | NULL | media/roberta-jang/thumbs/uqtTZ5BAXs1MnUWyBeF5.jpg | media/roberta-jang/thumbs/uqtTZ5BAXs1MnUWyBeF5.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/uqtTZ5BAXs | 1920 | NULL | 1920년경 | 5 | 0 | 0 | NULL |
| a.-QTrTMOTra8eNi6lIcneg | 사진 | 미국 세관이 발급해준 출입허가증. | 이 문장에는 이름이 포함되어 있지 않습니다. | 이민 한인들을 돕기 위해 샌프란시스코 엔젤 아일랜드(Angel Island)로 들어와도 좋다는 허가증이다. 1933년경. 백일규는 그 당시 국민회(KNA) 회장이었다. Mabel | media/roberta-jang/original/Bm76x9OXWQVPDtUSR52J.jpg | NULL | media/roberta-jang/thumbs/Bm76x9OXWQVPDtUSR52J.jpg | media/roberta-jang/thumbs/Bm76x9OXWQVPDtUSR52J.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:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/Bm76x9OXWQ | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| a-kJKAPpCSPOPXI9TLFPAGw | 사진 | 호놀롤루의 감리교회 앞에 서 있는 한국인들. 1904년경. | 한국인들 | NULL | media/roberta-jang/original/WHML37wNL1NAbybjl35z.jpg | NULL | media/roberta-jang/thumbs/WHML37wNL1NAbybjl35z.jpg | media/roberta-jang/thumbs/WHML37wNL1NAbybjl35z.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/WHML37wNL1 | 1904 | NULL | 1904년경 | 1 | 0 | 0 | NULL |
| a-1Ekka9dRkGFrOyFzUrruQ | NULL | 재미한족연합위원회 별보(1946) Special issue newsletter of the United Korean Committee in America | 재미한족연합위원회 | NULL | media/roberta-jang/original/HDl81LahtPFKt5rAzDW2.jpg | NULL | media/roberta-jang/thumbs/HDl81LahtPFKt5rAzDW2.jpg | media/roberta-jang/thumbs/HDl81LahtPFKt5rAzDW2.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 73 | Independence Hall of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/HDl81LahtP | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| a-0ZvB.-PSASM1xnDxa2iAw | NULL | 호항(호놀룰루) 한인기독교회 신도 일동(1938) Honolulu Korean Christian Church congregation | 호항(호놀룰루) 한인기독교회 신도 일동 | NULL | media/roberta-jang/original/NMfgJqZlsk3vsaiw8ukg.jpg | NULL | media/roberta-jang/thumbs/NMfgJqZlsk3vsaiw8ukg.jpg | media/roberta-jang/thumbs/NMfgJqZlsk3vsaiw8ukg.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/Rzkg7SQrQq | NULL | 그들의 발자취 | 161 | 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/NMfgJqZlsk | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 9yr8uxrS2CHpTYZripcJ | 사진 | People winnowing rice | NULL | People winnowing rice | media/jungnamyong/original/9yr8uxrS2CHpTYZripcJ.jpg | NULL | media/jungnamyong/thumbs/9yr8uxrS2CHpTYZripcJ.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_68_People winnowing rice.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 |
| 9xNaB3xeTIOBDDc168qUiA | 사진 | 정두옥(Doo Ok Chung)의 미국 귀화증. 1961년 3월 16일. 제2차 세계대전 이후 나이가 많은 하와이 한인들은 한국을 방문하고 싶은 마음에 귀화 신청을 많이 하였다. | 정두옥 | NULL | media/roberta-jang/original/FkpsXzIHzxC3V5wmjpx1.jpg | NULL | media/roberta-jang/thumbs/FkpsXzIHzxC3V5wmjpx1.jpg | media/roberta-jang/thumbs/FkpsXzIHzxC3V5wmjpx1.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:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/FkpsXzIHzx | 1961 | NULL | NULL | 1 | 0 | 1 | NULL |
| 9v4e2yHnTdi0FCckTidPTQ | 사진 | 최정애 군정여권，하와이 출신 군정외무부 부장서리 월터 정 싸인 (1943) Passport issued to Mrs. Chung Ai Choy by United States Arm | 최정애, 월터 정 | NULL | media/roberta-jang/original/3MfhwuH5iA6WYfkj3GRC.jpeg | NULL | media/roberta-jang/thumbs/3MfhwuH5iA6WYfkj3GRC.jpeg | media/roberta-jang/thumbs/3MfhwuH5iA6WYfkj3GRC.jpeg | 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/GiAL2aiewR | NULL | 그들의 발자취 | 22 | 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/3MfhwuH5iA | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| 9NoIjrr7QpCBbAooontb-w | 사진 | 카우아이 그로브 농장(Grove Farm)의 농장 숙소. 1924년 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/V8jtHP0kseEtDRETenP3.jpg | NULL | media/roberta-jang/thumbs/V8jtHP0kseEtDRETenP3.jpg | media/roberta-jang/thumbs/V8jtHP0kseEtDRETenP3.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:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/V8jtHP0kse | 1924 | NULL | NULL | 1 | 0 | 0 | NULL |
| 9nkzG4jITc2OKvVJ..hPTw | 사진 | 농장마을 공동빨래터에서 세탁하는 여인，에바농장(1908) Ewa Plantation community laundry -Mrs. Kelly Yoon Ock.Kim Collection | 에바농장, Mrs. Kelly Yoon Ock. Kim | NULL | media/roberta-jang/original/50tg2mVwHVTKult1njJ8.jpg | NULL | media/roberta-jang/thumbs/50tg2mVwHVTKult1njJ8.jpg | media/roberta-jang/thumbs/50tg2mVwHVTKult1njJ8.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/MhnFFn1d0J | NULL | 그들의 발자취 | 36 | 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/50tg2mVwHV | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| 9mr5xXXThAdpLkEouJ4Y | 사진 | NULL | NULL | NULL | media/salome-choehan/original/9mr5xXXThAdpLkEouJ4Y.jpg | NULL | media/salome-choehan/thumbs/9mr5xXXThAdpLkEouJ4Y.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #03_ 00012.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 |
| 9I9sbVGbRxObYy1KmlUDew | 사진 | 목사 부인인 하젤 박 정(Hazel Pahk Chung, 중앙 오른쪽)이 지도한 한인 감리교회의 요리실습반. Elsie Park(중앙 왼쪽), 시계 방향으로 왼쪽에서 네 번째가 K | 하젤 박 정, Elsie Park, Katherine Kim, Katherine Lee, Agnes Pahk Kwon, Victoria Shin, 강영옥. | NULL | media/roberta-jang/original/ybeMCvdozCLWUp5PJTIm.jpg | NULL | media/roberta-jang/thumbs/ybeMCvdozCLWUp5PJTIm.jpg | media/roberta-jang/thumbs/ybeMCvdozCLWUp5PJTIm.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:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/ybeMCvdozC | NULL | NULL | NULL | 7 | 0 | 0 | NULL |
| 9g9A9Tt4CPcBNp2nv1cX | 사진 | NULL | NULL | NULL | media/salome-choehan/original/9g9A9Tt4CPcBNp2nv1cX.jpg | NULL | media/salome-choehan/thumbs/9g9A9Tt4CPcBNp2nv1cX.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_00002.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 |
| 98OpI3h3Qt-XlZNyAc5JcA | NULL | 그리스도연합감리교회(Christ United Methodist Church) 해외에 설립된 초창기 한인교회, 에바한인 감리교회, 초대목사 김영식 （1905.4,30 창 립＞한인이민 | 김영식, 임정수, 김이제, 민잔호 | NULL | media/roberta-jang/original/0XEUUwJ3JE55s9INgjm2.jpg | NULL | media/roberta-jang/thumbs/0XEUUwJ3JE55s9INgjm2.jpg | media/roberta-jang/thumbs/0XEUUwJ3JE55s9INgjm2.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/GaTBJcIFLr | NULL | 그들의 발자취 | 111 | Mr. Young Ok Kang Collection | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/0XEUUwJ3JE | 1905 | NULL | NULL | 4 | 1 | 1 | NULL |
| 97d4fec8-76a0-4b44-bdd1-d52a6a218a7b | PDF 색인 | Esther Park Papers (박에스더 문서) | 박에스더 (Esther Park, 1902-1986, YWCA), 박정수 (Chong Soo Park, 부친), 김활란 (Helen Kim, 한국YWCA, Mid-Pacific I | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-012. 23페이지. | NULL | 1930s-1990s | NULL | NULL | Hyun, family, photo, National Association, citizenship, school, Korean, Hawaii, mission, Honolulu, u | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/012-Esther-Park-Collection-List-2020. | NULL | NULL | document | 하와이대 한국학연구소 | NULL | NULL | 2026-01-01 07:08:40 | 2026-01-01 09:43:09 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| 8Wh3gCUGnqz8T0DKuNPM | 사진 | people at a market | NULL | Seoul - people at a market_ | media/jungnamyong/original/8Wh3gCUGnqz8T0DKuNPM.jpg | NULL | media/jungnamyong/thumbs/8Wh3gCUGnqz8T0DKuNPM.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #2_22_Seoul - people at a market_.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 |
| 8qKCSU6ESWO1ywDOFCRZIA | NULL | 교회건축기금 마련운동 Building Fund Campaign of Olive United Methodist Church | Olive United Methodist Church | NULL | media/roberta-jang/original/zzPUTtSaftAIvrpZ0mFb.jpg | NULL | media/roberta-jang/thumbs/zzPUTtSaftAIvrpZ0mFb.jpg | media/roberta-jang/thumbs/zzPUTtSaftAIvrpZ0mFb.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/cz3HZpFiz2 | NULL | 그들의 발자취 | 135 | 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/zzPUTtSaft | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 8oot30xMQM2-heMTjEGlQQ | 사진 | 일요일 외출 허가를 받고 나가는 병사들. 1916년. 천안 독립기념관. | 병사들 | NULL | media/roberta-jang/original/bd3SRbRTij0skK9hnFXI.jpg | NULL | media/roberta-jang/thumbs/bd3SRbRTij0skK9hnFXI.jpg | media/roberta-jang/thumbs/bd3SRbRTij0skK9hnFXI.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/bd3SRbRTij | 1916 | NULL | NULL | 1 | 0 | 0 | NULL |
| 8NZOWUyvHTJkZJkZ2x9V | 사진 | A farm village | NULL | A farm village | media/jungnamyong/original/8NZOWUyvHTJkZJkZ2x9V.jpg | 1945 | media/jungnamyong/thumbs/8NZOWUyvHTJkZJkZ2x9V.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_32_A farm 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 |
| 8nF95re4T0a6YYueJOaXHg | NULL | 빅아일랜드 이승만박사 숙소(1925 —1929) Dr. Rhee's residence on the Big Island, Charcoal Production Period. | 이승만박사 | NULL | media/roberta-jang/original/51ft0HeS85sLeK4cUpmn.jpg | NULL | media/roberta-jang/thumbs/51ft0HeS85sLeK4cUpmn.jpg | media/roberta-jang/thumbs/51ft0HeS85sLeK4cUpmn.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/nXI8FwKdve | NULL | 그들의 발자취 | 84 | Korea Times 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/51ft0HeS85 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |