컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d6cnD8qUR5WzUSCgRFYvWQ | 사진 | 라디오 한국 개국. 1977년. 『 코리아타임스』. | 라디오 한국 | NULL | media/roberta-jang/original/wKoxKq31ILSY01Qte9Lb.jpg | NULL | media/roberta-jang/thumbs/wKoxKq31ILSY01Qte9Lb.jpg | media/roberta-jang/thumbs/wKoxKq31ILSY01Qte9Lb.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/wKoxKq31IL | 1977 | NULL | NULL | 1 | 0 | 0 | NULL |
| D6b2Wt4ksoFPq8Ej136f | 사진 | A man making malt sugar | NULL | A man making malt sugar | media/jungnamyong/original/D6b2Wt4ksoFPq8Ej136f.jpg | NULL | media/jungnamyong/thumbs/D6b2Wt4ksoFPq8Ej136f.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_77_A man making malt sugar.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 |
| d550f030QKik-rrq1zMo9A | 사진 | 몰리 홍 (민)은 1913년 21세에 샌프란시스코의 감리교여자신학교(Methodist Deaconess Seminary)를 졸업하였다. 토마스 민 앨범. | 몰리 홍, 민, 토마스 민 | NULL | media/roberta-jang/original/j0h0VFIjGRUlHUqOmxG2.jpg | NULL | media/roberta-jang/thumbs/j0h0VFIjGRUlHUqOmxG2.jpg | media/roberta-jang/thumbs/j0h0VFIjGRUlHUqOmxG2.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/j0h0VFIjGR | 1913 | NULL | NULL | 2 | 0 | 0 | NULL |
| D4K2MeP8QGyg5RRIdyaT3w | NULL | 김장수씨 운전면허 (1921) Chauffeur's license issued to Mr. Chang Soo Kim, Lihue, Kauai - Mr Donald Kim Colle | 김장수 | NULL | media/roberta-jang/original/RNzIiwYwTEIu7tKccstN.jpg | NULL | media/roberta-jang/thumbs/RNzIiwYwTEIu7tKccstN.jpg | media/roberta-jang/thumbs/RNzIiwYwTEIu7tKccstN.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:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/RNzIiwYwTE | NULL | NULL | NULL | 1 | 1 | 0 | NULL |
| d48pA2FTT0K-lk5veomSTw | 사진 | 마우이의 한인 감리교회. 오른쪽 끝이 임준호(Choon Ho Lim) 목사. 에스더 림 엄(Esther Lim Ome) 앨범. | 임준호, 에스더 림 엄 | NULL | media/roberta-jang/original/7L0AProHoLffQhpuoZgd.jpg | NULL | media/roberta-jang/thumbs/7L0AProHoLffQhpuoZgd.jpg | media/roberta-jang/thumbs/7L0AProHoLffQhpuoZgd.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/7L0AProHoL | NULL | NULL | NULL | 2 | 1 | 0 | NULL |
| D3YCyTxZRqapTYzZkrgkfw | 사진 | 한국인 젊은이들을 위한 소풍. 누아누(Nuuanu) YMCA 건물 앞에서. 1920년대경. 이태성 앨범. | 이태성 | NULL | media/roberta-jang/original/LRYqN6wRi0GQ0btBfej0.jpg | NULL | media/roberta-jang/thumbs/LRYqN6wRi0GQ0btBfej0.jpg | media/roberta-jang/thumbs/LRYqN6wRi0GQ0btBfej0.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/LRYqN6wRi0 | 1920 | 1920년대 | NULL | 1 | 0 | 1 | NULL |
| d3ggYGWeSuWZnENpguJ4GQ | NULL | 한인기독학원 농구팀 (1923) Korean Christian Institute basketball team | 한인기독학원 | NULL | media/roberta-jang/original/5AhqvRAIFOOgfSj20dTd.jpg | NULL | media/roberta-jang/thumbs/5AhqvRAIFOOgfSj20dTd.jpg | media/roberta-jang/thumbs/5AhqvRAIFOOgfSj20dTd.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/BcktLpyqPC | NULL | 그들의 발자취 | 187 | Bishop Museum | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/5AhqvRAIFO | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| d24a6fd5-bdaf-44b0-8c33-26fde66eb6fa | PDF 색인 | Arthur L. Gardner Collection | Arthur L. Gardner, Henry C. Kim | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-003. 1페이지. | NULL | 1903-1930s | NULL | NULL | independence, Hyun, photo, Korean, Hawaii, Honolulu, university, Korea | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/003-Arthur-L-Gardner-Collection-List- | NULL | NULL | document | 하와이대 한국학연구소 | NULL | NULL | 2026-01-01 07:08:38 | 2026-01-01 07:26:28 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| CzbqKkMfHUIIkXnQ4chA | 사진 | NULL | NULL | NULL | media/salome-choehan/original/CzbqKkMfHUIIkXnQ4chA.jpg | NULL | media/salome-choehan/thumbs/CzbqKkMfHUIIkXnQ4chA.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 00017.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 |
| CYrFIroggrwVCPBFrTFw | 사진 | Boats and people, carrying sacks | NULL | Incheon-Boats and people, carrying sacks | media/jungnamyong/original/CYrFIroggrwVCPBFrTFw.jpg | NULL | media/jungnamyong/thumbs/CYrFIroggrwVCPBFrTFw.jpg | NULL | NULL | NULL | Incheon | NULL | NULL | #1_20_Incheon-Boats and people, carrying sacks.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 |
| CyEAdGN5RESjRDZ.B8JLpA | 사진 | 살로메 최 한(Salome Choi Han). 한인양로원의 책임자. 1960년대경. Stephanie Han 컬렉션. | 살로메 최 한 | NULL | media/roberta-jang/original/QNIIGkRSU0x5sRGQPtLi.jpg | NULL | media/roberta-jang/thumbs/QNIIGkRSU0x5sRGQPtLi.jpg | media/roberta-jang/thumbs/QNIIGkRSU0x5sRGQPtLi.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/QNIIGkRSU0 | 1960 | 1960년대 | NULL | 1 | 0 | 0 | NULL |
| CVMZ4fNQTH-o--mJ7PgyjQ | 사진 | 김찬제 2세. 한국전쟁 중에 실종되었다. Gordon Kim 앨범. | 김찬제, Gordon Kim | NULL | media/roberta-jang/original/9XGeHKDxeCk5JrqYBAnh.jpg | NULL | media/roberta-jang/thumbs/9XGeHKDxeCk5JrqYBAnh.jpg | media/roberta-jang/thumbs/9XGeHKDxeCk5JrqYBAnh.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/9XGeHKDxeC | NULL | NULL | NULL | 2 | 1 | 0 | NULL |
| ctOWzlImTNS3kPROc77uKA | NULL | 카우이섬 장금환씨 상업 라이센스 (1917) Merchandise license, County of Kauai | 장금환 | NULL | media/roberta-jang/original/DPLAtzvivNjHJZ05a3VY.jpg | NULL | media/roberta-jang/thumbs/DPLAtzvivNjHJZ05a3VY.jpg | media/roberta-jang/thumbs/DPLAtzvivNjHJZ05a3VY.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 203 | 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/DPLAtzvivN | NULL | NULL | NULL | 1 | 1 | 1 | NULL |
| ctl2SFzMQau3L5S-w.NT8Q | NULL | KYC 농구부(1919) Korean “Y” Club Members | KYC 농구부(1919) | NULL | media/roberta-jang/original/KGnSLNNL7MxHZx1GhWaC.jpg | NULL | media/roberta-jang/thumbs/KGnSLNNL7MxHZx1GhWaC.jpg | media/roberta-jang/thumbs/KGnSLNNL7MxHZx1GhWaC.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/QZIgP6jMzV | NULL | 그들의 발자취 | 186 | Bishop Museum | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/KGnSLNNL7M | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| CQX7gpX9R7SAUMswkgq52g | 사진 | 한인 기독교회 80주년 기념식에 참석한 한인 2세 클래런스(Clarence)와 에밀리 최(Emily Choi). 그들의 부모는 1903년과 1924년 사이에 이주한 초기 이민자들이 | 클래런스(Clarence), 에밀리 최(Emily Choi) | NULL | media/roberta-jang/original/WUsFquneDno37yAPB0Nd.jpg | NULL | media/roberta-jang/thumbs/WUsFquneDno37yAPB0Nd.jpg | media/roberta-jang/thumbs/WUsFquneDno37yAPB0Nd.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/WUsFquneDn | 1903 | NULL | NULL | 2 | 0 | 0 | NULL |
| CQ8boWT0QcqVjVp3wWSO1w | 사진 | 박용만. 천안 독립기념관 컬렉션. | 박용만 | NULL | media/roberta-jang/original/ZBMbeMI7cVJUg9M5UgVn.jpg | NULL | media/roberta-jang/thumbs/ZBMbeMI7cVJUg9M5UgVn.jpg | media/roberta-jang/thumbs/ZBMbeMI7cVJUg9M5UgVn.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/ZBMbeMI7cV | NULL | NULL | NULL | 1 | 0 | 1 | NULL |
| cPHOpYzIGKhcvOWGy2Dd | 사진 | A field with the sea | NULL | A field with the sea | media/jungnamyong/original/cPHOpYzIGKhcvOWGy2Dd.jpg | NULL | media/jungnamyong/thumbs/cPHOpYzIGKhcvOWGy2Dd.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_65_A field with the sea.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 |
| cOqG7uiFihh3mIBDmwam | 사진 | NULL | Emily Choi, Vineyard Camp | NULL | media/salome-choehan/original/cOqG7uiFihh3mIBDmwam.jpg | NULL | media/salome-choehan/thumbs/cOqG7uiFihh3mIBDmwam.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_H-100_B_Unidentified - friend of Emily Choi's mother Vineyard Camp #2 - JOEL PAHK.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 |
| cmLHlH6XRceB3Rh9YZ.igQ | 사진 | 장로교와 감리교 선교사들이 공동 작업을 통해 성경을 한국어로 번역하였다. 앞줄 왼쪽에서 두 번째, 호레이스 그랜트 언더우드(Horace Grant Underwood) 목사, 왼쪽에 | 호레이스 그랜트 언더우드, 조지 허버 존스 | NULL | media/roberta-jang/original/Ddxt1S0Pe4v4HjiRWMcm.jpg | NULL | media/roberta-jang/thumbs/Ddxt1S0Pe4v4HjiRWMcm.jpg | media/roberta-jang/thumbs/Ddxt1S0Pe4v4HjiRWMcm.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/Ddxt1S0Pe4 | 1907 | NULL | 1907년경 | 2 | 0 | 0 | NULL |
| cMHtIU7gRZCUcrB1f0wIFA | NULL | 국민군단의 군사시범，카할루(1916) Korean Liberation Army during a military exhibition, Kahaluu, Oahu | 국민군단, 카할루, Korean Liberation Army | NULL | media/roberta-jang/original/XUGQKgE0X59Jim6NrMVn.jpg | NULL | media/roberta-jang/thumbs/XUGQKgE0X59Jim6NrMVn.jpg | media/roberta-jang/thumbs/XUGQKgE0X59Jim6NrMVn.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 70 | Mf Young Ok Kang 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/XUGQKgE0X5 | NULL | NULL | NULL | 3 | 0 | 0 | NULL |