컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| eQrMw9tURDWonHEHv0j7pQ | 사진 | 남경식(Kyung Sik Nam) 가족. 왼쪽부터, 조셉(Joseph), 이인옥(In Ok Lee), 프랭크(Frank), 해리(Harry), 루비(Ruby), 로버트(Robert | 남경식, 조셉, 이인옥, 프랭크, 해리, 루비, 로버트 | NULL | media/roberta-jang/original/s9IGCw4Bme4ytT8bjDmh.jpg | NULL | media/roberta-jang/thumbs/s9IGCw4Bme4ytT8bjDmh.jpg | media/roberta-jang/thumbs/s9IGCw4Bme4ytT8bjDmh.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/s9IGCw4Bme | 1930 | NULL | 1930년경 | 7 | 0 | 0 | NULL |
| ePWYkepdQ.W8KJovd6j1CQ | NULL | 한국선교회, 회장 : 문또라 Korean Missionary Society, Chairwomen Dora Moon | 문또라 (Dora Moon) | NULL | media/roberta-jang/original/OFZDMaGhJJwJ5ClJzyvn.jpg | NULL | media/roberta-jang/thumbs/OFZDMaGhJJwJ5ClJzyvn.jpg | media/roberta-jang/thumbs/OFZDMaGhJJwJ5ClJzyvn.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 121 | 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/OFZDMaGhJJ | NULL | NULL | NULL | 1 | 0 | 1 | NULL |
| eP2I4WuB3XqKRgO5thjT | 사진 | Sorghum | NULL | Sorghum | media/jungnamyong/original/eP2I4WuB3XqKRgO5thjT.jpg | NULL | media/jungnamyong/thumbs/eP2I4WuB3XqKRgO5thjT.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #6_106_Sorghum.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 |
| EoEQUTcLQ86UB7-3qnDaOQ | NULL | Y.M.C.A. 야간학교(1921) Y.M.C.A. Night School | Y.M.C.A. | NULL | media/roberta-jang/original/FlCn8v2xRYLjURjIxv2f.jpg | NULL | media/roberta-jang/thumbs/FlCn8v2xRYLjURjIxv2f.jpg | media/roberta-jang/thumbs/FlCn8v2xRYLjURjIxv2f.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 185 | 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/FlCn8v2xRY | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| EMmEDsN2QcijT734WvKHAQ | NULL | 호놀룰루 한인감리교회(담임목사 민찬호)는 1906년 미감리교선교회의 도움으로 펀치볼 스트릿에 있는 일본 기숙학교(후에 밀스고등학교) 부지를 사들여 교회와 한인기숙학교 건물로 사용하 | 민찬호, 존슨, 조원시, George Heber Jones, G. Jones | NULL | media/roberta-jang/original/LTgxErz83oJjWZSIvJPI.jpg | NULL | media/roberta-jang/thumbs/LTgxErz83oJjWZSIvJPI.jpg | media/roberta-jang/thumbs/LTgxErz83oJjWZSIvJPI.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 113 | 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/LTgxErz83o | 1906 | NULL | NULL | 5 | 0 | 1 | NULL |
| eMhVkzJyTI2cbPUZ1YJGRg | NULL | 속지 | 속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 188 | NULL | 2025-09-14 05:59:58 | 2026-01-19 08:25:19 | NULL | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| eMaX2SGZlUptDC6dPTOz | 사진 | Phosphate fertilizer | NULL | Phosphate fertilizer | media/jungnamyong/original/eMaX2SGZlUptDC6dPTOz.jpg | NULL | media/jungnamyong/thumbs/eMaX2SGZlUptDC6dPTOz.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #6_103_Phosphate fertilizer.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 |
| EM2v7H-cTOaz1BN6Nz-K5w | 사진 | 구미위원부가 판매한 공채의 영수증. 1922. Mildred Chun Thomas 앨범. | Mildred Chun Thomas | NULL | media/roberta-jang/original/HaBteZGsSEpQdsTstSRh.jpg | NULL | media/roberta-jang/thumbs/HaBteZGsSEpQdsTstSRh.jpg | media/roberta-jang/thumbs/HaBteZGsSEpQdsTstSRh.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/HaBteZGsSE | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| eEVzh5Z2TzicgqeFHVtb8w | 사진 | 마조리 김 리. 1954년경. 안젤린 리(Angeline Lee) 앨범. | 마조리 김 리, 안젤린 리 | NULL | media/roberta-jang/original/k5xmJVHI96hoirG2f8HA.jpg | NULL | media/roberta-jang/thumbs/k5xmJVHI96hoirG2f8HA.jpg | media/roberta-jang/thumbs/k5xmJVHI96hoirG2f8HA.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/k5xmJVHI96 | 1954 | NULL | 1954년경 | 2 | 0 | 0 | NULL |
| EDps.Wd5QQynOWBmSSzL5g | NULL | 새해를 맞아 교인들이 한데모여 떡을 만들고 있다. 제일한인감리교회 (1952) Making Dduk (rice cake) for New Year’s Day at the First | 제일한인감리교회 | NULL | media/roberta-jang/original/wcWhSzST2tnXQ3N4RAue.jpg | NULL | media/roberta-jang/thumbs/wcWhSzST2tnXQ3N4RAue.jpg | media/roberta-jang/thumbs/wcWhSzST2tnXQ3N4RAue.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/eCXn6cbM8A | NULL | 그들의 발자취 | 124 | Pev. T. 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/wcWhSzST2t | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| ec8ba3b5-5a76-4d27-8c3f-649b59ec58c6 | PDF 색인 | Susan Chun Lee Family Papers | Susan C. Lee (이수산), Samuel C. Lee, Rose A. Lee, Henry D. Lee, You K. Sung, 한인감리교회, 호놀룰루 한인사회 | 하와이대학교 한국학연구소 특별컬렉션. 참조번호: AM-014. 48페이지. | NULL | 1900s-1990s | NULL | NULL | Hyun, photo, immigration, school, Syngman Rhee, family, correspondence, sugar, Methodist, photograph | NULL | NULL | NULL | NULL | NULL | NULL | https://park.cartooncampus.com/kimmigration/media/hawaii-uh-ks/014-Susan-Chun-Lee-Family-Papers-List | NULL | NULL | document | 하와이대 한국학연구소 | NULL | NULL | 2026-01-01 07:08:41 | 2026-01-01 07:41:49 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | NULL |
| eBP3dMmuRyi3N0N0CA1o | 사진 | NULL | NULL | NULL | media/salome-choehan/original/eBP3dMmuRyi3N0N0CA1o.jpg | NULL | media/salome-choehan/thumbs/eBP3dMmuRyi3N0N0CA1o.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 00004.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 |
| e9slLjHnVFXLpcy78gvx | 사진 | An old woman, threshing rice | NULL | An old woman, threshing rice | media/jungnamyong/original/e9slLjHnVFXLpcy78gvx.jpg | NULL | media/jungnamyong/thumbs/e9slLjHnVFXLpcy78gvx.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #5_91_An old woman, threshing 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 |
| e6afjVYMS2W6WZJzFyRMvw | NULL | 하와이 땅에 새로운 삶의 터전을 마련한 이민선조들은 자라나는 2세들을 남부럽지 않게 성장시키기 위해 각고의 노력을 아끼지 않았다. 한인기독교회 주일학교 어린이들의 밝은 모습에서 오 | 이민선조들 | NULL | media/roberta-jang/original/MyvjtfUOmZ21jGd1jutH.jpg | NULL | media/roberta-jang/thumbs/MyvjtfUOmZ21jGd1jutH.jpg | media/roberta-jang/thumbs/MyvjtfUOmZ21jGd1jutH.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 157 | Dr. Alice Yun Cha. Collection | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/MyvjtfUOmZ | 1926 | NULL | 1926년경 | 1 | 0 | 0 | NULL |
| e4lUS1amQFK7vmewRUdnwQ | 사진 | 한인 감리교회. 1933년. 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/2tFmNYDGVjJePp7rjy9e.jpg | NULL | media/roberta-jang/thumbs/2tFmNYDGVjJePp7rjy9e.jpg | media/roberta-jang/thumbs/2tFmNYDGVjJePp7rjy9e.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/2tFmNYDGVj | 1933 | NULL | NULL | 1 | 0 | 0 | NULL |
| E1e2KVGiQKCx-HbyshaatA | NULL | 1924년 도착한 서복덕씨 자매 （오른쪽） ，서복덕씨는 한인기독교회와 동지회 발전에 기여하였다. Bok Dok Sur and sister arrived in 1924 | 서복덕씨, Bok Dok Sur | NULL | media/roberta-jang/original/AyiwIe710ymsRXKc135p.jpg | NULL | media/roberta-jang/thumbs/AyiwIe710ymsRXKc135p.jpg | media/roberta-jang/thumbs/AyiwIe710ymsRXKc135p.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 54 | 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/AyiwIe710y | 1924 | NULL | NULL | 2 | 0 | 0 | NULL |
| dWqvpwV5QI24.TA9UYEXng | NULL | 면(전) 댄，추복등씨 결혼사진(1924) Mr. & Mrs. Dan (Phyllis Bok Dung) Dunn | 댄, 추복등씨 | NULL | media/roberta-jang/original/Vi5ZdFcVVkH4cHWcLNMu.jpg | NULL | media/roberta-jang/thumbs/Vi5ZdFcVVkH4cHWcLNMu.jpg | media/roberta-jang/thumbs/Vi5ZdFcVVkH4cHWcLNMu.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/kuSWAvCfB5 | NULL | 그들의 발자취 | 52 | Dr Jackie Young 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/Vi5ZdFcVVk | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| DvLQuABCLCNVv6UnApR0 | 사진 | 4-H Club Fair | Club Fair | 4-H Club Fair | media/jungnamyong/original/DvLQuABCLCNVv6UnApR0.jpg | NULL | media/jungnamyong/thumbs/DvLQuABCLCNVv6UnApR0.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #1_16_4-H Club Fair.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 |
| dsQAEB6fTIKKwA7bUoHtNg | 사진 | 강영옥, 최인호(In Ho Choi), 차승현(Sung Hyun Cha). 1918년. Richard Lee와 Annie Lee Tom 앨범. | 강영옥, 최인호, 차승현, Richard Lee, Annie Lee Tom | NULL | media/roberta-jang/original/DQunfE2ZgBI0GTOFa1Nq.jpg | NULL | media/roberta-jang/thumbs/DQunfE2ZgBI0GTOFa1Nq.jpg | media/roberta-jang/thumbs/DQunfE2ZgBI0GTOFa1Nq.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/DQunfE2ZgB | 1918 | NULL | NULL | 5 | 0 | 0 | NULL |
| Ds.TGgi-SuWUPhaNWM836Q | 사진 | 국민군단은 파인애플을 재배하기 위해 토지를 경작하였다, 1941년경. 앞줄 왼쪽에서 두 번째 안원규, 세 번째 박용만. 천안 독립기념관 컬렉션. | 안원규, 박용만 | NULL | media/roberta-jang/original/pzg0SuAQaBl4pEeelMUv.jpg | NULL | media/roberta-jang/thumbs/pzg0SuAQaBl4pEeelMUv.jpg | media/roberta-jang/thumbs/pzg0SuAQaBl4pEeelMUv.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/pzg0SuAQaB | 1941 | NULL | 1941년경 | 2 | 1 | 1 | NULL |