컬럼 구조
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(10)
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)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| wFrFSE3RQvS8OEPFmCQy6Q | NULL | 속지 | 속지 | NULL | NULL | NULL | glide:mesh,속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 196 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | NULL | NULL | NULL | NULL | 1 | 0 | 0 |
| 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 |
| 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 |
| WC4Nm432TkWvnXqYgKH9XQ | 사진 | 최춘열(Choon Yer Choi)과 아이들. 뒷줄 왼쪽부터, 최은희(Eunhi Choy Kim), 김진호(Chin Ho Kim), 최두환(Doo Whan Choy), 최두욱(Do | 1. 최춘열 2. 최은희 3. 김진호 4. 최두환 5. 최두욱 6. 헬렌 최 7. 프리실라 최 8. 마르타 최 9. 김영내 | 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 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/6k50fyoOI2 | 1910 | NULL | 1910년경 | 9 | 1 | 1 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| vZBb9zyLStqZftvj8fP1Sw | NULL | 텍스트 | 죄송하지만, 제공된 텍스트에서 이름을 추출하려면 구체적인 내용이 필요합니다. 텍스트를 제공해주시면 도움을 드리겠습니다. | NULL | NULL | NULL | glide:mesh,텍스트 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 82 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | NULL | NULL | NULL | NULL | 2 | 0 | 0 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| vtuK2HiFTICXN.jJ7yhzyA | 사진 | 제 1회 한인의 날 기념행사. 1915년. Arthur Park 사진. | Arthur Park | NULL | media/roberta-jang/original/pwypizjlRTW33tuBrEX9.jpg | NULL | media/roberta-jang/thumbs/pwypizjlRTW33tuBrEX9.jpg | media/roberta-jang/thumbs/pwypizjlRTW33tuBrEX9.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/pwypizjlRT | 1915 | NULL | NULL | 1 | 0 | 0 |