컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ylO4EIQWRyepHVpc0kqW2A | 사진 | 이대순(Dai Soon)과 차순남 부부와 자녀들. 앤드류(Andrew), 안젤린(Angeline), 토마스(Thomas). 1923년경. 이 부부는 한국으로 돌아가기 위하여 하와이 | 이대순, 차순남, 앤드류, 안젤린, 토마스. | NULL | media/roberta-jang/original/sYSlY09Ir8ZuBqo2yQUa.jpg | NULL | media/roberta-jang/thumbs/sYSlY09Ir8ZuBqo2yQUa.jpg | media/roberta-jang/thumbs/sYSlY09Ir8ZuBqo2yQUa.jpg | 이대순,차순남 | 2025-07-10 00:00:00 | 이대순,차순남 | 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/sYSlY09Ir8 | 1923 | NULL | 1923년경 | 5 | 1 | 0 | NULL |
| YL9vs1fjT1uRQ2UDLKObgQ | 사진 | 최두환(Doo Whan Choy)과 아들. 1925년경. 김영내(Edward Young Nai Kim) 앨범. | 최두환, 김영내 | NULL | media/roberta-jang/original/LG80Q5rfafExZfzae2XQ.jpg | NULL | media/roberta-jang/thumbs/LG80Q5rfafExZfzae2XQ.jpg | media/roberta-jang/thumbs/LG80Q5rfafExZfzae2XQ.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/LG80Q5rfaf | 1925 | NULL | 1925년경 | 2 | 0 | 0 | NULL |
| YJMNJZtVSOSTQ8685OT4Dw | NULL | 이승만 초대대통령을 방문한 하와이 교포들(1959) Hawaiian Korean Home Tour Team visiting President Syngman Rhee’s office | 이승만 | NULL | media/roberta-jang/original/nfH2XTNlc4oxfjSof5tC.jpg | NULL | media/roberta-jang/thumbs/nfH2XTNlc4oxfjSof5tC.jpg | media/roberta-jang/thumbs/nfH2XTNlc4oxfjSof5tC.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/viqkUvNeXd | NULL | 그들의 발자취 | 201 | Mr Donald Kim 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/nfH2XTNlc4 | NULL | NULL | NULL | 1 | 0 | 1 | NULL |
| yGZed3DcQYqQIbigelg66w | 사진 | 한국 해군이 카피올라니(Kapiolani) 공원에서 공연을 하고 있다. 1985년. 『코리아타임스』. | 카피올라니, 코리아타임스 | NULL | media/roberta-jang/original/s62uUiYee2Ri3F1Sv8fD.jpg | NULL | media/roberta-jang/thumbs/s62uUiYee2Ri3F1Sv8fD.jpg | media/roberta-jang/thumbs/s62uUiYee2Ri3F1Sv8fD.jpg | 김이제 | 2025-04-19 00:00:00 | 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/s62uUiYee2 | 1985 | NULL | NULL | 2 | 0 | 0 | NULL |
| YfWxt2QTSdSOPrPB9oHnIA | 사진 | 앞줄 왼쪽부터, 홍인표(In Pyo Hong), 도산 안창호, 정원명(Won Myung Chung), 뒷줄 왼쪽에서 첫번째가 안원규(Won Kiu Ahn), 두 번째가 이내수(Na | 홍인표, 도산 안창호, 정원명, 안원규, 이내수 | NULL | media/roberta-jang/original/ZuwikCSqbasHchPnCneq.jpg | NULL | media/roberta-jang/thumbs/ZuwikCSqbasHchPnCneq.jpg | media/roberta-jang/thumbs/ZuwikCSqbasHchPnCneq.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:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/ZuwikCSqba | 1915 | NULL | NULL | 5 | 1 | 1 | NULL |
| yFuzyD6mTTm6zvpt37cwGQ | 사진 | 한국인들이 포함된 와이파후의 사탕수수 농장 파업 지지자들. 1990년경. 비숍 박물관. | 한국인들 | NULL | media/roberta-jang/original/rA1AnOMxdZ4TK9aX9o2f.jpg | NULL | media/roberta-jang/thumbs/rA1AnOMxdZ4TK9aX9o2f.jpg | media/roberta-jang/thumbs/rA1AnOMxdZ4TK9aX9o2f.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/rA1AnOMxdZ | 1990 | NULL | 1990년경 | 1 | 0 | 0 | NULL |
| yBdKZmNff9mFjsaJ7DsO | 사진 | Incheon market place | NULL | Incheon market place | media/jungnamyong/original/yBdKZmNff9mFjsaJ7DsO.jpg | 1946 | media/jungnamyong/thumbs/yBdKZmNff9mFjsaJ7DsO.jpg | NULL | NULL | NULL | Incheon | NULL | NULL | #5_87_Incheon market place_1946.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 |
| yAN0ElkxR0y4LcumA0n7uQ | 사진 | 1927년에서 1929년까지 사용되었던 힐로(Hilo)의 동지촌 숯가마. 1973년경. 『 코리아타임스』. | 힐로(Hilo) | NULL | media/roberta-jang/original/wmteYNEkvlwfxIb1X7ke.jpg | NULL | media/roberta-jang/thumbs/wmteYNEkvlwfxIb1X7ke.jpg | media/roberta-jang/thumbs/wmteYNEkvlwfxIb1X7ke.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:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/wmteYNEkvl | 1927 | NULL | 1927년경 | 1 | 0 | 0 | NULL |
| Y1ilLAHRNx9rxkhdRIwk | 사진 | NULL | NULL | NULL | media/salome-choehan/original/Y1ilLAHRNx9rxkhdRIwk.jpg | NULL | media/salome-choehan/thumbs/Y1ilLAHRNx9rxkhdRIwk.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00011.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 |
| Y.-3qSNMTMC2fWIeAkymIQ | 사진 | 전익서와 아내. 1919년경. Robin Lee 앨범. | 전익서, Robin Lee | NULL | media/roberta-jang/original/AWuhaHPROKE1B8FYpkH9.jpg | NULL | media/roberta-jang/thumbs/AWuhaHPROKE1B8FYpkH9.jpg | media/roberta-jang/thumbs/AWuhaHPROKE1B8FYpkH9.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/AWuhaHPROK | 1919 | NULL | 1919년경 | 2 | 1 | 1 | NULL |
| XYhge-n6SWKcGfpB8DOW0g | 사진 | 해당화 크럽，해방후 평화부인들로 구성된 문화단체，한라배 함여사와 자리를 같이 했다.（1951） Hae-dang Hwa Club of Peace Brides with Halla Pa | 해당화 크럽, 한라배 함여사 | NULL | media/roberta-jang/original/QOclQTRyUskePkW3ujFQ.jpeg | NULL | media/roberta-jang/thumbs/QOclQTRyUskePkW3ujFQ.jpeg | media/roberta-jang/thumbs/QOclQTRyUskePkW3ujFQ.jpeg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | 1951-07-10 00:00:00 | NULL | NULL | 그들의 발자취 | 21 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:49 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/QOclQTRyUs | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| xx3-2rRIT6KWAA.UDZhzug | 사진 | 노희창(Hee Chan Rho)이 동지식산회사의 주식을 구입하여 그 회사에 투자하였다는 것을 증명하는 영수증. 총재 이승만, 사장 신성일, 재무위원 안영찬(Young Chan Ah | 노희창, 이승만, 신성일, 안영찬, 아그네스 노 천 | NULL | media/roberta-jang/original/pHSOP5f18987wawmU0H0.jpg | NULL | media/roberta-jang/thumbs/pHSOP5f18987wawmU0H0.jpg | media/roberta-jang/thumbs/pHSOP5f18987wawmU0H0.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/pHSOP5f189 | 1927 | NULL | NULL | 5 | 1 | 1 | NULL |
| xwoxXFrST1qnvXMyUv2HBw | 사진 | 이승만. 천안 독립기념관 컬렉션. | 이승만 | NULL | media/roberta-jang/original/e13uVtsjNcnQzFxzPE6I.jpg | NULL | media/roberta-jang/thumbs/e13uVtsjNcnQzFxzPE6I.jpg | media/roberta-jang/thumbs/e13uVtsjNcnQzFxzPE6I.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/e13uVtsjNc | NULL | NULL | NULL | 1 | 0 | 1 | NULL |
| xuyaITOkS6KS0TM9ryBfrw | NULL | 형제클럽 모의결혼식, 황혜수 연줄 (1927) Wedding day performed by Hyung Jay Club, Advisor Dr. Ha Soo Whang | 황혜수 | NULL | media/roberta-jang/original/2UhkXQl2WPNXkQAlIsNB.jpg | NULL | media/roberta-jang/thumbs/2UhkXQl2WPNXkQAlIsNB.jpg | media/roberta-jang/thumbs/2UhkXQl2WPNXkQAlIsNB.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 190 | Bishop Museum | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/2UhkXQl2WP | NULL | NULL | NULL | 1 | 0 | 1 | NULL |
| XU.8SH8VSCePBp-r-hN4-w | 사진 | 김순신과 가족. | 김순신 | 왼쪽부터, 글래디스(Gladys (Ahn)), 형기(Hyung Kee, 아버지), 순신, 해리(Harry). 1920년경. 글래디스 김 안 앨범. 장로교 선교사인 김순신은 한국에 | media/roberta-jang/original/4U1YEa0xzwKjXiQfIqGx.jpg | NULL | media/roberta-jang/thumbs/4U1YEa0xzwKjXiQfIqGx.jpg | media/roberta-jang/thumbs/4U1YEa0xzwKjXiQfIqGx.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:49 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/4U1YEa0xzw | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| xRzOLcKhSEGPKgDKhet1hQ | 사진 | 사관생도 헨리 리(Henry T. L. Lee). 1930년. 한인 사진첩(Korean Alliance Album)과 줄리아 장 정(Julia Chang Chung) 컬렉션. | 헨리 리, 줄리아 장 정 | NULL | media/roberta-jang/original/7fU1m7DFGk4T6RwNqYcJ.jpg | NULL | media/roberta-jang/thumbs/7fU1m7DFGk4T6RwNqYcJ.jpg | media/roberta-jang/thumbs/7fU1m7DFGk4T6RwNqYcJ.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/7fU1m7DFGk | 1930 | NULL | NULL | 2 | 0 | 0 | NULL |
| XQzKCQ12SZKfxprJiLD7Rw | 사진 | 교민단(KRA)이 인계받은 국민회(KNA) 장부. 1921년. 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/DAKkg68Va7QKQS1PM5yf.jpg | NULL | media/roberta-jang/thumbs/DAKkg68Va7QKQS1PM5yf.jpg | media/roberta-jang/thumbs/DAKkg68Va7QKQS1PM5yf.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/DAKkg68Va7 | 1921 | NULL | NULL | 1 | 0 | 0 | NULL |
| xqV.XHWLQWOAD3cc56a3TA | 사진 | 교민단의 마지막 임원들. 앞줄 왼쪽에서 두 번째가 안영찬(부회장), 세 번째가 손덕인(회장), 뒷줄 왼쪽에서 두 번째가 김현구(, 간사). 1930년경. 『코리아타임스 』. 교민 | 안영찬, 손덕인, 김현구 | NULL | media/roberta-jang/original/MVvqpMboMBgAoeNh7zE6.jpg | NULL | media/roberta-jang/thumbs/MVvqpMboMBgAoeNh7zE6.jpg | media/roberta-jang/thumbs/MVvqpMboMBgAoeNh7zE6.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/MVvqpMboMB | 1930 | NULL | 1930년경 | 3 | 1 | 1 | NULL |
| XPwNZWAyRcKZ6ZsLZTTIwQ | 사진 | 오장익(Chang Ick Oh)의 결혼 피로연. 하와이 힐로 근처의 오노메아(Onomea) 사탕수수 농장의 사택. 1923년. 로버타 장 컬렉션. | 오장익, 로버타 장 | NULL | media/roberta-jang/original/vBGRpZCleQ4NjEJ91dNn.jpg | NULL | media/roberta-jang/thumbs/vBGRpZCleQ4NjEJ91dNn.jpg | media/roberta-jang/thumbs/vBGRpZCleQ4NjEJ91dNn.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/vBGRpZCleQ | 1923 | NULL | NULL | 2 | 0 | 0 | NULL |
| xmNOQUE1RiekmNl6lrojcg | NULL | 한인기독교회 3.1 절기념 연례 피크닉 (1937) Honolulu Korean Christian Church annual picnic commemorating March 1 In | 한인기독교회 | NULL | media/roberta-jang/original/xtyheWq2UjzVKuoyb1M1.jpg | NULL | media/roberta-jang/thumbs/xtyheWq2UjzVKuoyb1M1.jpg | media/roberta-jang/thumbs/xtyheWq2UjzVKuoyb1M1.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 158 | Mr. Young Ok Kang Collection | 2025-09-14 05:59:58 | 2025-12-06 11:09:49 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/xtyheWq2Uj | NULL | NULL | NULL | 1 | 0 | 0 | NULL |