컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| xLYReF6nda3ISpx2N2zW | 사진 | A millet farm | NULL | A millet farm | media/jungnamyong/original/xLYReF6nda3ISpx2N2zW.jpg | NULL | media/jungnamyong/thumbs/xLYReF6nda3ISpx2N2zW.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_72_A millet farm.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 |
| xkT7Hw.nSleywDRVs6c19Q | 사진 | 1905년에 문을 연 한인 감리교회. 교회 건물은 하와이 선교회에서 빌렸다. 강영옥(Young Ok Kang)과 민병용 컬렉션. | 강영옥(Young Ok Kang) | NULL | media/roberta-jang/original/2J8PGaaKxCSfNXOhGyDG.jpg | NULL | media/roberta-jang/thumbs/2J8PGaaKxCSfNXOhGyDG.jpg | media/roberta-jang/thumbs/2J8PGaaKxCSfNXOhGyDG.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/2J8PGaaKxC | 1905 | NULL | NULL | 1 | 0 | 0 | NULL |
| XjYx5.IKTX2tNyUV7PInzg | 사진 | 대한민국 총영사관 표지판의 제막식을 하고 있는 총영사 김세원(Se Won Kim, 오른쪽 끝). 1961년경. 『 코리아타임스』. | 김세원 | NULL | media/roberta-jang/original/eaYdYpq2OQCfw8UfEMgq.jpg | NULL | media/roberta-jang/thumbs/eaYdYpq2OQCfw8UfEMgq.jpg | media/roberta-jang/thumbs/eaYdYpq2OQCfw8UfEMgq.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/eaYdYpq2OQ | 1961 | NULL | 1961년경 | 1 | 0 | 0 | NULL |
| XJB.FoHuQ5OOYU9GDAAh5A | 사진 | 범태평양회의에 파견된 대표단. 한국 서울 YMCA 사무총장 신흥우가 대표단을 이끌었다. 오른쪽에서 두 번째 송진우(Jin Woo Song). 1925년. 이태성(Tai Sung L | 신흥우, 송진우, 이태성 | NULL | media/roberta-jang/original/N2OVCW9FDvN8TmtBwsJU.jpg | NULL | media/roberta-jang/thumbs/N2OVCW9FDvN8TmtBwsJU.jpg | media/roberta-jang/thumbs/N2OVCW9FDvN8TmtBwsJU.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/N2OVCW9FDv | 1925 | NULL | NULL | 3 | 0 | 1 | NULL |
| XJ08tQcxoAp3YMza1ydV | 사진 | NULL | NULL | NULL | media/salome-choehan/original/XJ08tQcxoAp3YMza1ydV.jpg | NULL | media/salome-choehan/thumbs/XJ08tQcxoAp3YMza1ydV.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 00013.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 |
| Xi0fANLQ1zGOJx2z4yAr | 사진 | A Farm village | NULL | A Farm village | media/jungnamyong/original/Xi0fANLQ1zGOJx2z4yAr.jpg | NULL | media/jungnamyong/thumbs/Xi0fANLQ1zGOJx2z4yAr.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_73_A Farm village.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 |
| XHlbwFSLRyqilTo6nbPF4w | NULL | 한인기독교회 스쿨 스트릿 예배당 전경 Korean Christian Church at N. School Street, Honolulu | 한인기독교회, Korean Christian Church | NULL | media/roberta-jang/original/2TXRiACeWAtyewyOl8lt.jpg | NULL | media/roberta-jang/thumbs/2TXRiACeWAtyewyOl8lt.jpg | media/roberta-jang/thumbs/2TXRiACeWAtyewyOl8lt.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/zfuBs9qvH1 | NULL | 그들의 발자취 | 156 | 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/2TXRiACeWA | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| XHDlCbziRrijAFA.1HiHRQ | 사진 | 한인 성공회 부인회. 1920년경. 민병용 컬렉션. | 한인 성공회 부인회 | NULL | media/roberta-jang/original/r7wWQJC54BuPbxE7eg3h.jpg | NULL | media/roberta-jang/thumbs/r7wWQJC54BuPbxE7eg3h.jpg | media/roberta-jang/thumbs/r7wWQJC54BuPbxE7eg3h.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/r7wWQJC54B | 1920 | NULL | 1920년경 | 1 | 0 | 0 | NULL |
| xGWo.rfGSWaRaqJF7WxMRw | NULL | 한인기독학원 졸업앨범에서(연도미상) 중간 이승만 박사와 민찬호 목사 Korean Christian Institute graduation album pictures (Date Unk | 이승만, 민찬호 | NULL | media/roberta-jang/original/Svz2p1LKiqKqVK4UWAsD.jpg | NULL | media/roberta-jang/thumbs/Svz2p1LKiqKqVK4UWAsD.jpg | media/roberta-jang/thumbs/Svz2p1LKiqKqVK4UWAsD.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/xTUplVh0IM | NULL | 그들의 발자취 | 174 | Graduation Album of K.C | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/Svz2p1LKiq | NULL | NULL | NULL | 2 | 0 | 1 | NULL |
| XGpnmIwdSWmKKm8PZ2LH1g | NULL | 성누가교회 조광원 신부와 복사 （1930년경） Father Noah K. Cho and Acolytes, St. Luke's Church | 조광원 신부, Father Noah K. Cho | NULL | media/roberta-jang/original/XG1saGzrrrQVqtZSH1CM.jpg | NULL | media/roberta-jang/thumbs/XG1saGzrrrQVqtZSH1CM.jpg | media/roberta-jang/thumbs/XG1saGzrrrQVqtZSH1CM.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 146 | Mrs, Esther Kang | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/XG1saGzrrr | 1930 | NULL | 1930년경 | 2 | 0 | 0 | NULL |
| xGG.anKyS.KoDbY-MgtGnA | NULL | 국민회 회원록（호상부） List of membership of Kook Min Hur—Funeral Aid Club | 국민회 회원록 | NULL | media/roberta-jang/original/g1NiHvv94UZfQYOlMH6t.jpg | NULL | media/roberta-jang/thumbs/g1NiHvv94UZfQYOlMH6t.jpg | media/roberta-jang/thumbs/g1NiHvv94UZfQYOlMH6t.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/x7vDTyPPow | NULL | 그들의 발자취 | 74 | Independence Hall of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:09:49 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/g1NiHvv94U | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| xFmt3jdJRL2Kuj4V.n45pg | 사진 | 하동회(평화 신부). 왼쪽부터, 부회장 안복자(Bok Cha Ahn) 부인, 사무관 찰스 리 부인, 회장 남임수(Im Soo Nam) 부인, 고문 모지스 (에스더 림) 엄(Mose | 하동회, 안복자, 찰스 리, 남임수, 모지스, 에스더 림 엄. | NULL | media/roberta-jang/original/nIeSG0eqMoD6BdXEIxRt.jpg | NULL | media/roberta-jang/thumbs/nIeSG0eqMoD6BdXEIxRt.jpg | media/roberta-jang/thumbs/nIeSG0eqMoD6BdXEIxRt.jpg | NULL | 2025-04-19 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | 1953-03-03 00:00:00 | 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/nIeSG0eqMo | 1953 | NULL | NULL | 6 | 0 | 0 | NULL |
| XeleMjUFQjesb8PWe7hz-g | 사진 | 전쟁 신부들. 찰스 리(Charles Lee) 부부, 앨버트 최(Albert Choi) 부부, 존 한(John Han) 부부. 1948년. 존 한 앨범. | 찰스 리, 앨버트 최, 존 한 | NULL | media/roberta-jang/original/RXo20AVLbf0hDPg3q8gZ.jpg | NULL | media/roberta-jang/thumbs/RXo20AVLbf0hDPg3q8gZ.jpg | media/roberta-jang/thumbs/RXo20AVLbf0hDPg3q8gZ.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:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/RXo20AVLbf | 1948 | NULL | NULL | 3 | 0 | 0 | NULL |
| xEhyv3hvg38dhKRxmVbh | 사진 | A farm house with many piles of hay | NULL | A farm house with many piles of hay | media/jungnamyong/original/xEhyv3hvg38dhKRxmVbh.jpg | NULL | media/jungnamyong/thumbs/xEhyv3hvg38dhKRxmVbh.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_64_A farm house with many piles of hay.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 |
| XDzahTDcExqRHVc7PkYo | 사진 | a fruit market | NULL | Seoul - a fruit market | media/jungnamyong/original/XDzahTDcExqRHVc7PkYo.jpg | 1946 | media/jungnamyong/thumbs/XDzahTDcExqRHVc7PkYo.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #5_99_Seoul - a fruit market_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 |
| xdcX2QQxQBig2CAZpgbUdQ | 사진 | 최초의 한인소년기숙학교 졸업반. 왼쪽부터, 김찬제, 김계봉(Gay Bong Kim), 박관두, Y. S. Hong, 양유찬(You Chan Yang), 김성현(Sung Hyun K | 김찬제, 김계봉, 박관두, Y. S. Hong, 양유찬, 김성현 | NULL | media/roberta-jang/original/lvhrGlRi61kV0gIjzQY2.jpg | NULL | media/roberta-jang/thumbs/lvhrGlRi61kV0gIjzQY2.jpg | media/roberta-jang/thumbs/lvhrGlRi61kV0gIjzQY2.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/lvhrGlRi61 | 1910 | NULL | NULL | 6 | 1 | 0 | NULL |
| xdcMnec5SI6EjTUsTzPthw | NULL | 해외한족대회 대표들과 부인구제회 중앙총회(1942) Representatives of Overseas United Korean Committee and Korean Women’s | 해외한족대회 대표들과 부인구제회 중앙총회 | NULL | media/roberta-jang/original/stFbmf4TDLeXHSf1hsOc.jpg | NULL | media/roberta-jang/thumbs/stFbmf4TDLeXHSf1hsOc.jpg | media/roberta-jang/thumbs/stFbmf4TDLeXHSf1hsOc.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/6TrhNXR4MV | NULL | 그들의 발자취 | 97 | Independence Hall of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:09:49 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/stFbmf4TDL | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| XBj.WGCsR72mS1HJ-NZKfQ | NULL | 힐로 한인클럽(1927) Korean American Club of Hilo, Big Island | 힐로 한인클럽 | NULL | media/roberta-jang/original/GRGRAsoqAknHN0ujSrj5.jpg | NULL | media/roberta-jang/thumbs/GRGRAsoqAknHN0ujSrj5.jpg | media/roberta-jang/thumbs/GRGRAsoqAknHN0ujSrj5.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/58GoBJAoj4 | NULL | 그들의 발자취 | 109 | Dr Young Ki Han 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/GRGRAsoqAk | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| XapJkC7BTiOpofeq99fO3g | NULL | 마우이 국어학교(연도미상) Maui Korean School (Date Unknown) | 마우이 국어학교 | NULL | media/roberta-jang/original/YLLptlzFF2rKZllue36J.jpg | NULL | media/roberta-jang/thumbs/YLLptlzFF2rKZllue36J.jpg | media/roberta-jang/thumbs/YLLptlzFF2rKZllue36J.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 181 | 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/YLLptlzFF2 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| xAGUA3BzS6G9SMaAwMb7uw | 문서 | 초기 하와이 한인 천주교인의 실체와 활동 | "초기 하와이 한인 천주교인의 실체와 활동"에서 추출할 수 있는 이름은 없습니다. 문장에서 특정 인물이나 단체의 이름이 언급되지 않았습니다. 추가적인 정보나 문맥이 필요할 경우 말 | 하와이 초기 이민 신자들의 실체와 그들의 활동을 규명하고자 한다. 경향잡지, 서울교구연보, 하와이 지역의 세례대장에서 언급된 이름과 기존에 밝혀진 이민자 명단을 대조하여 초기 입국 | NULL | NULL | NULL | NULL | NULL | 2025-03-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/5v5fsqoSr4 | NULL | NULL | NULL | NULL | NULL | NULL | 2025-09-14 05:59:58 | 2026-01-19 08:25:19 | NULL | NULL | NULL | NULL | 1 | 0 | 0 | NULL |