컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| wEJvCpAqH9kgf5otu9Xw | 사진 | NULL | NULL | NULL | media/salome-choehan/original/wEJvCpAqH9kgf5otu9Xw.jpg | NULL | media/salome-choehan/thumbs/wEJvCpAqH9kgf5otu9Xw.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #03_00001.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 |
| WCjDstGNQvWgOZi9QVLy8g | NULL | 올리브 연합감리교회 부인 봉사회 (1946) Women’s Society of Olive United Methodist Church | 올리브 연합감리교회 부인 봉사회 | NULL | media/roberta-jang/original/lcIeuOJTyWxipSHTaStJ.jpg | NULL | media/roberta-jang/thumbs/lcIeuOJTyWxipSHTaStJ.jpg | media/roberta-jang/thumbs/lcIeuOJTyWxipSHTaStJ.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/B3ngAhn5IN | NULL | 그들의 발자취 | 133 | 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/lcIeuOJTyW | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| WC4Nm432TkWvnXqYgKH9XQ | 사진 | 최춘열(Choon Yer Choi)과 아이들. 뒷줄 왼쪽부터, 최은희(Eunhi Choy Kim), 김진호(Chin Ho Kim), 최두환(Doo Whan Choy), 최두욱(Do | 최춘열, 최은희, 김진호, 최두환, 최두욱, 헬렌 최, 프리실라 최, 마르타 최, 김영내 | NULL | media/roberta-jang/original/6k50fyoOI2V06bmQJr12.jpg | NULL | media/roberta-jang/thumbs/6k50fyoOI2V06bmQJr12.jpg | media/roberta-jang/thumbs/6k50fyoOI2V06bmQJr12.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 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/6k50fyoOI2 | 1910 | NULL | 1910년경 | 9 | 1 | 1 | NULL |
| WAsXse2OTdWkiXxq9.Itbg | 사진 | 태극회 임원들. 왼쪽부터, 미키 손(Micky Shon), Harold Kim, 찰스 리(Charles Lee), 스미스 최(Smith Choi), 문덕만(Duke Duk Man | 미키 손, Harold Kim, 찰스 리, 스미스 최, 문덕만, 메리 문 한 | NULL | media/roberta-jang/original/x1AtN2bHE6iIUHBEwCFh.jpg | NULL | media/roberta-jang/thumbs/x1AtN2bHE6iIUHBEwCFh.jpg | media/roberta-jang/thumbs/x1AtN2bHE6iIUHBEwCFh.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/x1AtN2bHE6 | 1950 | NULL | 1950년경 | 6 | 0 | 0 | NULL |
| w8GIMgwqQCuAdScLmyAOLw | 사진 | 이태성과 릴리 박(Lily Pahk Lee). 1910년대경. Xander Cintron-Chai 앨범. | 이태성과 릴리 박(Lily Pahk Lee) | NULL | media/roberta-jang/original/yR5Y8TqnQ9fluouy24Ui.jpg | NULL | media/roberta-jang/thumbs/yR5Y8TqnQ9fluouy24Ui.jpg | media/roberta-jang/thumbs/yR5Y8TqnQ9fluouy24Ui.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/yR5Y8TqnQ9 | 1910 | 1910년대 | NULL | 1 | 0 | 0 | NULL |
| w7W5eryGSx2GRip0EHUzgA | NULL | 제일한인감리교회 (현 그리스도연합감리교회) 전시 적십자 봉사원 (1945) First Korean Methodist Church Surgical Dressing Group Amer | 제일한인감리교회, 그리스도연합감리교회, 적십자 봉사원, First Korean Methodist Church, American Red Cross, Hawaiian Chapter. | NULL | media/roberta-jang/original/fotAhgwCEatcLJ8HLQn0.jpg | NULL | media/roberta-jang/thumbs/fotAhgwCEatcLJ8HLQn0.jpg | media/roberta-jang/thumbs/fotAhgwCEatcLJ8HLQn0.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/z5aon6l2yf | NULL | 그들의 발자취 | 121 | 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/fotAhgwCEa | NULL | NULL | NULL | 6 | 0 | 0 | NULL |
| W7CP7JICS6awWPQ70uSPvg | 사진 | 1945년 한국으로 간 재미한족연합위원회 대표단. 앞줄 왼쪽부터, 유진석(David Chin Suk Youth), 안정송(Chung Song Ahn), 김원용(Warren Kim) | 유진석, 안정송, 김원용, 한시대, 박금우, 송종익, 안창호, 조제언, 정두옥, 최두욱, 전경무, 김성략, 김병연, 김호, 도진호 | NULL | media/roberta-jang/original/kQ1b1mWk7bxYGUsPKNMx.jpg | NULL | media/roberta-jang/thumbs/kQ1b1mWk7bxYGUsPKNMx.jpg | media/roberta-jang/thumbs/kQ1b1mWk7bxYGUsPKNMx.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/kQ1b1mWk7b | 1945 | NULL | NULL | 15 | 1 | 1 | NULL |
| W79G1VkAQBmL5vVfrR0O | 사진 | A mountain and a river in winter | NULL | A mountain and a river in winter | media/jungnamyong/original/W79G1VkAQBmL5vVfrR0O.jpg | NULL | media/jungnamyong/thumbs/W79G1VkAQBmL5vVfrR0O.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #1_11_A mountain and a river in winter.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 |
| W6Q3BzCoqCQHlpOXVgF7 | 사진 | a candy man with a cart | NULL | Seoul - a candy man with a cart | media/jungnamyong/original/W6Q3BzCoqCQHlpOXVgF7.jpg | NULL | media/jungnamyong/thumbs/W6Q3BzCoqCQHlpOXVgF7.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #5_88_Seoul - a candy man with a cart.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 |
| W6f-ZVQNR.KLDGcLRh4jzg | 사진 | 주영순, 신노순(No Soon Shin Choo, 어머니), 주영한. 1910년경. Il Dong Chey Park 앨범. | 주영순, 신노순, 주영한 | NULL | media/roberta-jang/original/8pmZ7sMD37itmkwP5QQ0.jpg | NULL | media/roberta-jang/thumbs/8pmZ7sMD37itmkwP5QQ0.jpg | media/roberta-jang/thumbs/8pmZ7sMD37itmkwP5QQ0.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/8pmZ7sMD37 | 1910 | NULL | 1910년경 | 3 | 0 | 0 | NULL |
| w4q1a7uOqAKhR9UF90uF | 사진 | Naktong River | Naktong River | Naktong River | media/jungnamyong/original/w4q1a7uOqAKhR9UF90uF.jpg | NULL | media/jungnamyong/thumbs/w4q1a7uOqAKhR9UF90uF.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_70_Naktong 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 |
| W1hH-hcHSvmfCh5wxrwaJw | 사진 | 당나귀가 끌던 트롤리 버스(1903) A mule-drawn tram car in front of Aliiolani Hale | Aliiolani Hale | NULL | media/roberta-jang/original/wAqTPo1NLEXsfdilb1WC.jpg | NULL | media/roberta-jang/thumbs/wAqTPo1NLEXsfdilb1WC.jpg | media/roberta-jang/thumbs/wAqTPo1NLEXsfdilb1WC.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 30 | Dr. Yong Ho Choe 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/wAqTPo1NLE | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| vZBb9zyLStqZftvj8fP1Sw | NULL | 텍스트 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 82 | NULL | 2025-09-14 05:59:58 | 2026-01-19 08:25:19 | NULL | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| VyN-wbObRT2VpwCW7k11lA | NULL | 밀스 고등학교 배구팀 (1916) The Volleyball Team of Mills School of the Mid—Pacific Institute | 밀스 고등학교 | NULL | media/roberta-jang/original/pPZoJ1iZdiOCVKu4qKba.jpg | NULL | media/roberta-jang/thumbs/pPZoJ1iZdiOCVKu4qKba.jpg | media/roberta-jang/thumbs/pPZoJ1iZdiOCVKu4qKba.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 183 | Mr. Kelly Yoon Ok Kim | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/pPZoJ1iZdi | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| VxGFhBUeSFeQLpgjtTZeRA | 사진 | 서대문. 전차. 1910년경. 민병용 컬렉션. | 서대문, 민병용 | NULL | media/roberta-jang/original/WbhstseeEvvvcW7aaVwE.jpg | NULL | media/roberta-jang/thumbs/WbhstseeEvvvcW7aaVwE.jpg | media/roberta-jang/thumbs/WbhstseeEvvvcW7aaVwE.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/WbhstseeEv | 1910 | NULL | 1910년경 | 2 | 0 | 0 | NULL |
| vXBjhHbNSraNLMFpjQzCdQ | 사진 | 전영택(Young Taik)과 양치수(Chee Soo Yang Chun), 첫째 유순(Yu Soon(Ahn)). 1918년경. Mildred Chun Thomas 앨범. | 전영택, 양치수, 유순, Mildred Chun Thomas | NULL | media/roberta-jang/original/YU1cGCvt5AcZnGgntp00.jpg | NULL | media/roberta-jang/thumbs/YU1cGCvt5AcZnGgntp00.jpg | media/roberta-jang/thumbs/YU1cGCvt5AcZnGgntp00.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/YU1cGCvt5A | 1918 | NULL | 1918년경 | 4 | 1 | 0 | NULL |
| vX7IH51FQySg.93hg4dO3w | 사진 | 한인 2세 형제의 가족. 이석준()과 이봉술(,서 있는 형제). 석준은 사진 신부와 결혼하였고, 봉술은 한인 2세 신부와 결혼하였다. 왼쪽부터, Joseph, David, Marg | 이석준, 이봉술, Joseph, David, Margaret, Hannah Park, Mildred, Jonah, Godfrey, Lucy, Walter, Howard, Ellen | NULL | media/roberta-jang/original/xNxBUXfgx7q1uXXkJITS.jpg | NULL | media/roberta-jang/thumbs/xNxBUXfgx7q1uXXkJITS.jpg | media/roberta-jang/thumbs/xNxBUXfgx7q1uXXkJITS.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/xNxBUXfgx7 | 1930 | NULL | 1930년경 | 14 | 0 | 0 | NULL |
| VwHxFLcY2QrB9dhPYSSj | 사진 | NULL | NULL | NULL | media/salome-choehan/original/VwHxFLcY2QrB9dhPYSSj.jpg | NULL | media/salome-choehan/thumbs/VwHxFLcY2QrB9dhPYSSj.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_H-100_K_Unidentified - 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 |
| VvBmbzk6SLis0mOrHJkwCg | NULL | 하와이 한인부인들은 1919년 3.1 운동 소식이 전해지자 조국의 독립운동을 체계적으로 지원하기 위해 구국단체를 조직하기 시작했다. (1919년경) Korean Women’s Or | 하와이 한인부인들 | NULL | media/roberta-jang/original/lO4vgYwzybzMDdytDIf9.jpg | NULL | media/roberta-jang/thumbs/lO4vgYwzybzMDdytDIf9.jpg | media/roberta-jang/thumbs/lO4vgYwzybzMDdytDIf9.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/XrkGiPxIVn | NULL | 그들의 발자취 | 92 | Bishop Museum | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/lO4vgYwzyb | 1919 | NULL | 1919년경 | 1 | 0 | 0 | NULL |
| Vu3gXnXoTHarJAf9mxWIGg | 사진 | 한국학연구소. 1998년경. 한국학연구소. | 한국학연구소 | NULL | media/roberta-jang/original/pOZuvtfvlvS6mrqzdDOS.jpg | NULL | media/roberta-jang/thumbs/pOZuvtfvlvS6mrqzdDOS.jpg | media/roberta-jang/thumbs/pOZuvtfvlvS6mrqzdDOS.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:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/pOZuvtfvlv | 1998 | NULL | 1998년경 | 1 | 0 | 0 | NULL |