컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | NULL |
| srt0s7LkmhVPaf4jajxp | 사진 | A farm field | NULL | A farm field | media/jungnamyong/original/srt0s7LkmhVPaf4jajxp.jpg | NULL | media/jungnamyong/thumbs/srt0s7LkmhVPaf4jajxp.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #1_13_A farm field.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 |
| 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 | NULL |
| 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 | NULL |
| Skwdq8vOxrJzO8hx15Wl | 사진 | General Lerch & acar | General Lerch | General Lerch & acar | media/jungnamyong/original/Skwdq8vOxrJzO8hx15Wl.jpg | 1945 | media/jungnamyong/thumbs/Skwdq8vOxrJzO8hx15Wl.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_54_General Lerch & acar_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 |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| sIqpnBDaTn6Y.stxq6kPZQ | 사진 | 도산 안창호의 장손 로버트 안(Robert Ahn, 중앙), 로버트의 아내 헬렌(Helen, 왼쪽), 어머니 글래디스 김 안(Gladys Kim Ahn)은 하와이에 살고 있다. 2 | 로버트 안 (Robert Ahn), 헬렌 (Helen), 글래디스 김 안 (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 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/cBGuiOzilL | 2000 | NULL | NULL | 3 | 0 | 0 | NULL |
| sevtNfcRejxzgCxzoF5I | 사진 | NULL | NULL | NULL | media/salome-choehan/original/sevtNfcRejxzgCxzoF5I.jpg | NULL | media/salome-choehan/thumbs/sevtNfcRejxzgCxzoF5I.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00017.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 |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| RZjD.zD5Qryn63H1J8LyAA | 사진 | 국민회. '민중승리축하' 기념촬영. 1932년 4월. 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/66WmCnbPq9hxfseuVOdm.jpg | NULL | media/roberta-jang/thumbs/66WmCnbPq9hxfseuVOdm.jpg | media/roberta-jang/thumbs/66WmCnbPq9hxfseuVOdm.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/66WmCnbPq9 | 1932 | NULL | NULL | 1 | 0 | 0 | NULL |
| rxCMitD8SQaL6dxMr3bacQ | 사진 | 사진 신부들. 하와이 호놀롤루에 새로 도착한 사진 신부들로, 사진 신랑들이 일하고 있는 이웃 섬으로 흩어지기 전에 촬영하였다. 앞줄 왼쪽에서 두 번째 손효순(Hyo Soon Sho | 손효순, 조보배, 유복순, 박영진 | NULL | media/roberta-jang/original/AoDbRKUOIRQ0OuAO0pQ3.jpg | NULL | media/roberta-jang/thumbs/AoDbRKUOIRQ0OuAO0pQ3.jpg | media/roberta-jang/thumbs/AoDbRKUOIRQ0OuAO0pQ3.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/AoDbRKUOIR | 1913 | NULL | 1913년경 | 4 | 0 | 0 | NULL |
| rwpQ8Ff3Qe6Dbp1Z-DlQ0A | NULL | 국민군단 훈련지의 현재 모습(1992) Ahuimanu Subdivision where Korean Liberation Army Camp existec -Korea Central | 국민군단, 한국광복군 | NULL | media/roberta-jang/original/ec4TaDDxiyaItxSSbACG.jpg | NULL | media/roberta-jang/thumbs/ec4TaDDxiyaItxSSbACG.jpg | media/roberta-jang/thumbs/ec4TaDDxiyaItxSSbACG.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/mRB161z0WO | NULL | 그들의 발자취 | 71 | 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/ec4TaDDxiy | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| RVJNEOB0QKGK7fbmP3Pwgg | 사진 | 콜로라도주 크레이튼(Creighton)의 한인농업회사(Korean Algricultural Copertaion). 농업회사의 대표 안재창(Chai Chang Ahn, 모자를 쓰지 | 안재창 | NULL | media/roberta-jang/original/xIExQm105Z5iEN5gdxld.jpg | NULL | media/roberta-jang/thumbs/xIExQm105Z5iEN5gdxld.jpg | media/roberta-jang/thumbs/xIExQm105Z5iEN5gdxld.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:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/xIExQm105Z | 1919 | NULL | 1919년경 | 1 | 1 | 0 | NULL |
| ruXJHZseSw-hRtCd9vtjLg | 사진 | 조지 오웬 상사. 오운(Cloud Owen)의 아들로 1951년 한국전쟁 중에 중공군 포로들과 함께 촬영한 사진. 조지 오웬 앨범. | 조지 오웬, 오운 | NULL | media/roberta-jang/original/Bv4p0tLRNaiU6CnrSHU2.jpg | NULL | media/roberta-jang/thumbs/Bv4p0tLRNaiU6CnrSHU2.jpg | media/roberta-jang/thumbs/Bv4p0tLRNaiU6CnrSHU2.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/Bv4p0tLRNa | 1951 | NULL | NULL | 2 | 0 | 0 | NULL |