컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| tAT0W7BfT3ilapkl9BNKzg | 사진 | 프랭크 민(Frank Min). 민스 플라스틱스(Min's Plastics) 회사의 경영자. 『 호놀롤루 스타-불러틴』. 1950년대경. 민스 플라스틱스의 소유자이자 경영자였던 | 프랭크 민, 얼레인 민 | NULL | media/roberta-jang/original/92sLzXpcjv6a3BCizaoo.jpg | NULL | media/roberta-jang/thumbs/92sLzXpcjv6a3BCizaoo.jpg | media/roberta-jang/thumbs/92sLzXpcjv6a3BCizaoo.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/92sLzXpcjv | 1950 | 1950년대 | NULL | 2 | 0 | 0 |
| tasGbtYYR1GxUyZOEo7ILw | 사진 | 정운서(Woon Sur)와 정신실(Shin Sil Chung), 아들 월터(Walter Jhung). 1909년경. Bryson Jhung 앨범. | 정운서, 정신실, 월터, Bryson Jhung | NULL | media/roberta-jang/original/Pa1Tm7sgSI3bgHn8pgr3.jpg | NULL | media/roberta-jang/thumbs/Pa1Tm7sgSI3bgHn8pgr3.jpg | media/roberta-jang/thumbs/Pa1Tm7sgSI3bgHn8pgr3.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/Pa1Tm7sgSI | 1909 | NULL | 1909년경 | 4 | 0 | 0 |
| TaClGlOtSsmnUrHxoAzwOA | 사진 | 김찬제 2세 | 김찬제 | -6.25전쟁 참전,실종 | media/roberta-jang/original/GUDd5NupWOXkAFcMLiTY.jpeg | 정보가 부족하여 해당 연도를 추... | media/roberta-jang/thumbs/GUDd5NupWOXkAFcMLiTY.jpeg | media/roberta-jang/thumbs/GUDd5NupWOXkAFcMLiTY.jpeg | 김찬제(부),김이제(숙부) | 2025-03-09 00:00:00 | 김찬제(부),김이제(숙부) | 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/GUDd5NupWO | NULL | NULL | NULL | 1 | 1 | 0 |
| T1eH.BYRShOHIxseDo.sZA | 사진 | 호놀롤루 경찰국장 리 도나휴. 사진 신부인 Pil Duk Lee Donohue의 아들. 2001년경. 로버타 장 컬렉션. | 리 도나휴 | NULL | media/roberta-jang/original/FAf6tJ5hf0ynBQz61kLt.jpg | NULL | media/roberta-jang/thumbs/FAf6tJ5hf0ynBQz61kLt.jpg | media/roberta-jang/thumbs/FAf6tJ5hf0ynBQz61kLt.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/FAf6tJ5hf0 | 2001 | NULL | 2001년경 | 1 | 0 | 0 |
| t12lK-VkTf6d9AclB-a3jg | 사진 | 문종헌(홀아비)과 아이들, 토마스(Thomas), 대니얼(Daniel), 덕만(Duke Duk Man), 베아트리체(Beatrice). 1935년경. 메리 문 한(Mary Moon | 문종헌, 토마스, 대니얼, 덕만, 베아트리체, 메리 문 한. | NULL | media/roberta-jang/original/Hw7wEe93VsOcmDhgakwE.jpg | NULL | media/roberta-jang/thumbs/Hw7wEe93VsOcmDhgakwE.jpg | media/roberta-jang/thumbs/Hw7wEe93VsOcmDhgakwE.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/Hw7wEe93Vs | 1935 | NULL | 1935년경 | 6 | 0 | 0 |
| t.U5lTuGRX-S0F1ely1eKw | NULL | 제일한인감리교회 성가대，정의조 목사 시무식 (1948) The First Korean Methodist Church Choir | 제일한인감리교회 성가대, 정의조 목사 | NULL | media/roberta-jang/original/s45vljIk4tqlKDJ40wuH.jpg | NULL | media/roberta-jang/thumbs/s45vljIk4tqlKDJ40wuH.jpg | media/roberta-jang/thumbs/s45vljIk4tqlKDJ40wuH.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 121 | Mrs. Sarah Kim 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/s45vljIk4t | NULL | NULL | NULL | 2 | 0 | 0 |
| t.94ZJdxQsWtowVH8lxKrw | 사진 | 서울에서 일어난 만세운동. 1919년. 천안 독립기념관 컬렉션. | 서울, 1919년, 천안, 만세운동. | NULL | media/roberta-jang/original/IfmtONz8TVSHSzwi2MQv.jpg | NULL | media/roberta-jang/thumbs/IfmtONz8TVSHSzwi2MQv.jpg | media/roberta-jang/thumbs/IfmtONz8TVSHSzwi2MQv.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/IfmtONz8TV | 1919 | NULL | NULL | 4 | 0 | 0 |
| sTedBI7kTimzGH.WjiAZ9w | NULL | 연극공연을 마치고(연대미상) After the performance(Date Unknown) | 연극공연을 마치고 | NULL | media/roberta-jang/original/NuBPfIpWR06sbATQ4kgX.jpg | NULL | media/roberta-jang/thumbs/NuBPfIpWR06sbATQ4kgX.jpg | media/roberta-jang/thumbs/NuBPfIpWR06sbATQ4kgX.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/vj7jsuCTf6 | NULL | 그들의 발자취 | 191 | 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/NuBPfIpWR0 | NULL | NULL | NULL | 1 | 0 | 0 |
| sS2PBOufQk2lVwnM4luiGg | NULL | 천연희 할머니 (1993) Mrs. Yun Hee Chun Given (1993) | 천연희 할머니, Mrs. Yun Hee Chun | NULL | media/roberta-jang/original/pplT862vXo4evR8cPIbc.jpg | NULL | media/roberta-jang/thumbs/pplT862vXo4evR8cPIbc.jpg | media/roberta-jang/thumbs/pplT862vXo4evR8cPIbc.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 58 | 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/pplT862vXo | NULL | NULL | NULL | 2 | 0 | 0 |
| SlDNEFhkSKisHKDy.-yKLg | 사진 | 최초의 샌프란시스코 한인 감리교회. 이곳에서 공립협회가 탄생되었다. 1912년경. 신성려(Sonia Sunoo) 컬렉션. | 신성려(Sonia Sunoo) | NULL | media/roberta-jang/original/SX1zrApYyV1cqOHpzlOU.jpg | NULL | media/roberta-jang/thumbs/SX1zrApYyV1cqOHpzlOU.jpg | media/roberta-jang/thumbs/SX1zrApYyV1cqOHpzlOU.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/SX1zrApYyV | 1912 | NULL | 1912년경 | 1 | 0 | 0 |
| sKZt2P2NS06yzp1fF1A.Fg | 사진 | 제2차 세계대전 중 하와이에 수용된 한국인 포로들. 1944년경. 존 한(John Han) 앨범. | 존 한 (John Han) | NULL | media/roberta-jang/original/CbyGYusJKnz0nbf0dHmY.jpg | NULL | media/roberta-jang/thumbs/CbyGYusJKnz0nbf0dHmY.jpg | media/roberta-jang/thumbs/CbyGYusJKnz0nbf0dHmY.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/CbyGYusJKn | 1944 | NULL | 1944년경 | 1 | 0 | 0 |
| SKloODXhTk6fTvOeRXqkAg | 사진 | 보이스카웃 19지대 (1919) Korean Boy Scout Troop #19 - Bishop Museum ’ 185 | 보이스카웃 19지대 | NULL | media/roberta-jang/original/uFSaQhbC7aWLo8YarfJi.jpg | NULL | media/roberta-jang/thumbs/uFSaQhbC7aWLo8YarfJi.jpg | media/roberta-jang/thumbs/uFSaQhbC7aWLo8YarfJi.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/jZq1zvWY9j | NULL | 그들의 발자취 | 23 | 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/uFSaQhbC7a | NULL | NULL | NULL | 1 | 0 | 0 |
| SKjorxX.QL-oZXmRtwIBqQ | 사진 | 농장숙소 앞에서 부인들과 아이들，에바농장 (연도미상) In front of Ewa Plantation worker’s residence (Date Unknown) | 에바농장 | NULL | media/roberta-jang/original/4ZOOQNOqnYQ7O4y0yT8g.jpg | NULL | media/roberta-jang/thumbs/4ZOOQNOqnYQ7O4y0yT8g.jpg | media/roberta-jang/thumbs/4ZOOQNOqnYQ7O4y0yT8g.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/TWtuUt6oR8 | NULL | 그들의 발자취 | 40 | 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/4ZOOQNOqnY | NULL | NULL | NULL | 1 | 0 | 0 |
| SJ1im7KcRGOAbaH7d7g21w | NULL | 마을에서 함께 떠난 세명의 사진신부, 중앙 김차순 사진신부(1920) lhree Picture brides from the same village, Cha Soon Kim, cen | 김차순 | NULL | media/roberta-jang/original/rJxgwf7vHglJwY2iNp6z.jpg | NULL | media/roberta-jang/thumbs/rJxgwf7vHglJwY2iNp6z.jpg | media/roberta-jang/thumbs/rJxgwf7vHglJwY2iNp6z.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/XXfj9TFisF | NULL | 그들의 발자취 | 57 | 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/rJxgwf7vHg | NULL | NULL | NULL | 1 | 1 | 1 |
| SIZbzxzET8a59S.ljDbgQA | NULL | 하와이 대한인애국부인회 규정집 (1941) Constitution of Korean Women's Society | 하와이 대한인애국부인회 | NULL | media/roberta-jang/original/NHn6ak5LOViE84LFZd6o.jpg | NULL | media/roberta-jang/thumbs/NHn6ak5LOViE84LFZd6o.jpg | media/roberta-jang/thumbs/NHn6ak5LOViE84LFZd6o.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 96 | Independence Hall of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/NHn6ak5LOV | NULL | NULL | NULL | 1 | 0 | 0 |
| sIqpnBDaTn6Y.stxq6kPZQ | 사진 | 도산 안창호의 장손 로버트 안(Robert Ahn, 중앙), 로버트의 아내 헬렌(Helen, 왼쪽), 어머니 글래디스 김 안(Gladys Kim Ahn)은 하와이에 살고 있다. 2 | 1. 로버트 안 (Robert Ahn) 2. 헬렌 (Helen) 3. 글래디스 김 안 (Gladys Kim Ahn) | NULL | media/roberta-jang/original/cBGuiOzilL05gOvO8UmT.jpg | NULL | media/roberta-jang/thumbs/cBGuiOzilL05gOvO8UmT.jpg | media/roberta-jang/thumbs/cBGuiOzilL05gOvO8UmT.jpg | 오성진 (Chris Sung Jin Oh) | 2025-04-19 00:00:00 | NULL | NULL | NULL | NULL | 오성진 (Chris Sung Jin Oh) | 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/cBGuiOzilL | 2000 | NULL | NULL | 3 | 0 | 0 |
| SeAGb4YkTK6d.oDdbV1VDQ | 사진 | 베타베타감마회. 왼쪽부터 시계방향으로, Rachel Han, Jane Kim, Jackie Young, Frances Pai, Frances Shim, Beverly Song. 1 | Rachel Han, Jane Kim, Jackie Young, Frances Pai, Frances Shim, Beverly Song | NULL | media/roberta-jang/original/NgDvxrzZ4rsnzzmksVUR.jpg | NULL | media/roberta-jang/thumbs/NgDvxrzZ4rsnzzmksVUR.jpg | media/roberta-jang/thumbs/NgDvxrzZ4rsnzzmksVUR.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/NgDvxrzZ4r | 1953 | NULL | NULL | 6 | 0 | 0 |
| scGw2zkpSJeBsQTHS8nl1g | 사진 | 최초의 한인 교사 노라 박 채, 최초의 한인 간호사 캐티 하. 1926년경. Xander Cintron-Chai 앨범. | 노라 박 채, 캐티 하, Xander Cintron-Chai | NULL | media/roberta-jang/original/WMI9KMmIAooiEaQXzZEQ.jpg | NULL | media/roberta-jang/thumbs/WMI9KMmIAooiEaQXzZEQ.jpg | media/roberta-jang/thumbs/WMI9KMmIAooiEaQXzZEQ.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/WMI9KMmIAo | 1926 | NULL | 1926년경 | 3 | 0 | 0 |
| S6G9GNsMRTS4utX4LtZ.5A | NULL | 하와이 한인이민 50주년 기념식에 참석차 하와이를 함태영 부통령이 한인기독교회를 방문하였다(1953) Korean Vice-President Tai Yong Hohm visited | 함태영 | NULL | media/roberta-jang/original/R0HLOTvylQGmjqV5wYmR.jpg | NULL | media/roberta-jang/thumbs/R0HLOTvylQGmjqV5wYmR.jpg | media/roberta-jang/thumbs/R0HLOTvylQGmjqV5wYmR.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 199 | 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/R0HLOTvylQ | NULL | NULL | NULL | 1 | 0 | 0 |
| s.hVWKFFRgqGr.zVG7CAsA | NULL | 코리언 유니버시티 클럽 (Korean University Club) 앞줄 왼쪽부터 마가렛 권 배，황혜수，매리 신 리, 뒷줄 가운데 강영각 Front row(L to R): Marg | 마가렛 권 배, 황혜수, 매리 신 리, 강영각 | NULL | media/roberta-jang/original/45UOFOtESnowyGAA6WaU.jpg | NULL | media/roberta-jang/thumbs/45UOFOtESnowyGAA6WaU.jpg | media/roberta-jang/thumbs/45UOFOtESnowyGAA6WaU.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 105 | Mr. Young Ok Kang Collection | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/45UOFOtESn | NULL | NULL | NULL | 4 | 0 | 1 |