컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| x7arJMBRMWrlnJQiTttj | 사진 | NULL | NULL | NULL | media/salome-choehan/original/x7arJMBRMWrlnJQiTttj.jpg | NULL | media/salome-choehan/thumbs/x7arJMBRMWrlnJQiTttj.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 00019.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 |
| x6-eQaswQpG7tQqBvr3g3A | 사진 | 이동진 목사, 조지 섀넌 맥큔(오른쪽)과 그의 아내 헨렌 맥아피 맥큔(Helen McAfee McCune, 왼쪽). 1940년대경. | 이동진, 조지 섀넌 맥큔, 헨렌 맥아피 맥큔. | NULL | media/roberta-jang/original/PRXAaiH62QQuEOZ80OXN.jpg | NULL | media/roberta-jang/thumbs/PRXAaiH62QQuEOZ80OXN.jpg | media/roberta-jang/thumbs/PRXAaiH62QQuEOZ80OXN.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/PRXAaiH62Q | 1940 | 1940년대 | NULL | 3 | 1 | 0 | NULL |
| X2NYSrnRRymoMIiM-hiP8g | NULL | 마우이 스프롁클스빌 한인감리교회(연도미상) Korean Methodist Church Spreckelsville, Maui (Date unknown) | 마우이 스프롱클스빌 한인감리교회 | NULL | media/roberta-jang/original/c9byMTuFFyTtzzvTpLUr.jpg | NULL | media/roberta-jang/thumbs/c9byMTuFFyTtzzvTpLUr.jpg | media/roberta-jang/thumbs/c9byMTuFFyTtzzvTpLUr.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 136 | Dr. Alice Yun Chai 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/c9byMTuFFy | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| X.8RaNgJTd2Suhq5f85i.w | 사진 | 박성달(Sung Dal)과 김명남(Myong Nam Kim) 가족. 아들, 조셉(Joesph)과 존(John). 1920년경. 웨슬리 박(Wesley Park) 앨범. | 박성달, 김명남, 조셉, 존, 웨슬리 박 | NULL | media/roberta-jang/original/jH1nGCLucROaHZyIhzcj.jpg | NULL | media/roberta-jang/thumbs/jH1nGCLucROaHZyIhzcj.jpg | media/roberta-jang/thumbs/jH1nGCLucROaHZyIhzcj.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/jH1nGCLucR | 1920 | NULL | 1920년경 | 4 | 0 | 0 | NULL |
| wYEKoMMOQ0aYNrBa4YWVTw | 사진 | 캘리포니아주의 강해원(Hae Won Kang)과 김성권(Sung Kwon Kim) 가족. 김얼(Earl Kim), 김낙(Nark Kim), 김인(Yin Kim). 1926년경. 김 | 강해원, 김성권, 김얼, 김낙, 김인 | NULL | media/roberta-jang/original/1V12y8yO1WsqAxAhcdvT.jpg | NULL | media/roberta-jang/thumbs/1V12y8yO1WsqAxAhcdvT.jpg | media/roberta-jang/thumbs/1V12y8yO1WsqAxAhcdvT.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/1V12y8yO1W | 1926 | NULL | 1926년경 | 5 | 1 | 0 | NULL |
| WwgKWMUySi2fSnanLpnfkQ | NULL | 대한부인구제회(1939) Korean Women’s Relief Society | 대한부인구제회, Korean Women’s Relief Society | NULL | media/roberta-jang/original/ciQljzVckggNZESlAuoL.jpg | NULL | media/roberta-jang/thumbs/ciQljzVckggNZESlAuoL.jpg | media/roberta-jang/thumbs/ciQljzVckggNZESlAuoL.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/pTuIdC1BMx | NULL | 그들의 발자취 | 95 | 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/ciQljzVckg | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| WtIFPu9mrVESxzzQJ1Ny | 사진 | Mapo, Seoul - people at a market on Han River | NULL | Mapo, Seoul - people at a market on Han River_ | media/jungnamyong/original/WtIFPu9mrVESxzzQJ1Ny.jpg | NULL | media/jungnamyong/thumbs/WtIFPu9mrVESxzzQJ1Ny.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #2_23_Mapo, Seoul - people at a market on Han River_.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 |
| wtEhAQrzPCcEa3WoafGV | 사진 | NULL | NULL | Korean farm village - an ox in the middle ( Mom's home) | media/jungnamyong/original/wtEhAQrzPCcEa3WoafGV.jpg | NULL | media/jungnamyong/thumbs/wtEhAQrzPCcEa3WoafGV.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #6_117_Korean farm village - an ox in the middle ( Mom's home).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 |
| WSViqbYgSPSsCWRSEX5c4A | 사진 | 해체된 국민회 회원들이 개최한 도산 안창호 환영회. 1942년. 안수산 앨범. | 도산 안창호, 안수산 | NULL | media/roberta-jang/original/Zy5pMJhSN3XItpimRlO7.jpg | NULL | media/roberta-jang/thumbs/Zy5pMJhSN3XItpimRlO7.jpg | media/roberta-jang/thumbs/Zy5pMJhSN3XItpimRlO7.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/Zy5pMJhSN3 | 1942 | NULL | NULL | 2 | 0 | 0 | NULL |
| wrzfnyNAR8-Gqnf70homAA | NULL | 국민군단의 위용 (1914년경) Korean Liberation Army Camp (Circa 1914) | 국민군단 | NULL | media/roberta-jang/original/2bz0EICRDKWzlBOgrKWe.jpg | NULL | media/roberta-jang/thumbs/2bz0EICRDKWzlBOgrKWe.jpg | media/roberta-jang/thumbs/2bz0EICRDKWzlBOgrKWe.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/fSH2qDBK3Z | NULL | 그들의 발자취 | 71 | Dr Yong Ho Choe 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/2bz0EICRDK | 1914 | NULL | 1914년경 | 1 | 0 | 0 | NULL |
| Wr05QVV8SEGEW8QNQ5.Ofw | NULL | 두 가족용 노동자 숙소，에바농정 (1906) Ewa Plantation worker's quarters, two-family dwelling | 에바 | NULL | media/roberta-jang/original/w0Uwh2VBL8aqoExGdCkh.jpg | NULL | media/roberta-jang/thumbs/w0Uwh2VBL8aqoExGdCkh.jpg | media/roberta-jang/thumbs/w0Uwh2VBL8aqoExGdCkh.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 40 | Mr 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/w0Uwh2VBL8 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| wq-sSNLxQC-gzwAGCkXolg | 사진 | 국민회 회장인 존 현(John Hyun)이 한인노인회에게 환영인사를 하고 있다. 한인노인회는 1970년대와 1980년대 국민회 시설을 이용하여 활동을 하였다. 로버타 장 컬렉션. | 존 현 (John Hyun), 로버타 장 | NULL | media/roberta-jang/original/xqlruanvMcp6VCr7cobi.jpg | NULL | media/roberta-jang/thumbs/xqlruanvMcp6VCr7cobi.jpg | media/roberta-jang/thumbs/xqlruanvMcp6VCr7cobi.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 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/xqlruanvMc | 1970 | 1970년대 | NULL | 2 | 0 | 0 | NULL |
| WoH2gWAcR36MIr82y2oI9g | 사진 | 웨인 패터슨의 아메리카로 가는길 | 웨인 패터슨 | 웨인 패터슨의 "아메리카로 가는 길"은 하와이 한인 이민사를 다룬 중요한 저서입니다[4]. 이 책은 1896년부터 1910년까지의 한인들의 하와이 이민 역사를 상세히 다루고 있습니 | media/roberta-jang/original/jkumweXOZKQm4MO7HEbJ.jpeg | 0000년 | media/roberta-jang/thumbs/jkumweXOZKQm4MO7HEbJ.jpeg | media/roberta-jang/thumbs/jkumweXOZKQm4MO7HEbJ.jpeg | NULL | 2025-02-27 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/jkumweXOZK | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| WKvPDnGaQPaOP02RRLY8CA | 사진 | 한인상공회의소의 임원단. 1954년. 맨 왼쪽부터 시계방향으로, 클라라 안(Clara Ahn), 에스더 권(Esther Kwon), 회장 배의환(Edward Pai), 필립 신(P | 클라라 안, 에스더 권, 배의환, 필립 신, 임관희, 앤나 정, 허버트 민. | NULL | media/roberta-jang/original/IlrYLfJk7HO2NkSp62jJ.jpg | NULL | media/roberta-jang/thumbs/IlrYLfJk7HO2NkSp62jJ.jpg | media/roberta-jang/thumbs/IlrYLfJk7HO2NkSp62jJ.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/IlrYLfJk7H | 1954 | NULL | NULL | 7 | 0 | 0 | NULL |
| wHyBOpF3TYWOab7PwJq6WQ | NULL | 이용수씨 장례식 (1925) Funeral service of Yong Soo Lee (Sarah Lee Yang’s Grandfather), Hana, Maui | 이용수씨 | NULL | media/roberta-jang/original/IfmhmNVP77JXt8uRU2fI.jpg | NULL | media/roberta-jang/thumbs/IfmhmNVP77JXt8uRU2fI.jpg | media/roberta-jang/thumbs/IfmhmNVP77JXt8uRU2fI.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/Qq1Da8wFOF | NULL | 그들의 발자취 | 47 | 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/IfmhmNVP77 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| WHLestMtS-SngxXSEMxNxQ | 사진 | 서울의 탑골공원을 방문한 KCI 야구단. 1923년. 비숍 박물관. | KCI 야구단 | NULL | media/roberta-jang/original/45QGhmbJN1fDcwIoOIBL.jpg | NULL | media/roberta-jang/thumbs/45QGhmbJN1fDcwIoOIBL.jpg | media/roberta-jang/thumbs/45QGhmbJN1fDcwIoOIBL.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/45QGhmbJN1 | 1923 | NULL | NULL | 1 | 0 | 0 | NULL |
| wFrFSE3RQvS8OEPFmCQy6Q | NULL | 속지 | 속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 196 | NULL | 2025-09-14 05:59:58 | 2026-01-19 08:25:19 | NULL | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| WeYnjjDARuasbZspwt9mNg | 사진 | 조계남. 하와이 '사진 신부'의 아들. 1953년경. 알 장 사진. | 조계남 | NULL | media/roberta-jang/original/DDyVDeKSffhDUBO2yhXc.jpg | NULL | media/roberta-jang/thumbs/DDyVDeKSffhDUBO2yhXc.jpg | media/roberta-jang/thumbs/DDyVDeKSffhDUBO2yhXc.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/DDyVDeKSff | 1953 | NULL | 1953년경 | 1 | 0 | 0 | NULL |
| weXW5895fjvHeIx8HtdM | 사진 | parade | NULL | Seoul - parade | media/jungnamyong/original/weXW5895fjvHeIx8HtdM.jpg | 1946 | media/jungnamyong/thumbs/weXW5895fjvHeIx8HtdM.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #6_110_Seoul - parade_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 |
| wEX4Wn5tHKTJdT7FG0zQ | 사진 | spectators at a park | NULL | Seoul - spectators at a park | media/jungnamyong/original/wEX4Wn5tHKTJdT7FG0zQ.jpg | 1945 | media/jungnamyong/thumbs/wEX4Wn5tHKTJdT7FG0zQ.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #5_97_Seoul - spectators at a park_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 |