컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| v0Qkbtohy0TsbDU07hhN | 사진 | Red peppers | NULL | Red peppers | media/jungnamyong/original/v0Qkbtohy0TsbDU07hhN.jpg | 1946 | media/jungnamyong/thumbs/v0Qkbtohy0TsbDU07hhN.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_78_Red peppers_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 |
| uYtHiXbUTT-Oi-ZwPvJr4w | 사진 | 1915년 한인사회 축하행사에 참여한 국민군단의 시가행진. Xander Cintron-Chai 앨범. | Xander Cintron-Chai | NULL | media/roberta-jang/original/pnWcvcdewQTGaIKwSo3c.jpg | NULL | media/roberta-jang/thumbs/pnWcvcdewQTGaIKwSo3c.jpg | media/roberta-jang/thumbs/pnWcvcdewQTGaIKwSo3c.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/pnWcvcdewQ | 1915 | NULL | NULL | 1 | 0 | 0 | NULL |
| UYOUiU6yQTSk3AhTkGt3sA | 사진 | 미국 정부는 해외여행에 제한 규정을 두었다. 최은희(Eunhi Choy Kim)는 1935년 하와이로 돌아왔는데, 미국 내의 재류외국인은 고용기회를 지키기 위하여 재입국허가증을 발 | 최은희, 김영내 | NULL | media/roberta-jang/original/qe55qrDuYId1HJaELW15.jpg | NULL | media/roberta-jang/thumbs/qe55qrDuYId1HJaELW15.jpg | media/roberta-jang/thumbs/qe55qrDuYId1HJaELW15.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/qe55qrDuYI | 1935 | NULL | NULL | 2 | 0 | 0 | NULL |
| UwYBQK67RHiKsACWzZiq7A | 사진 | 한인 기독교회. 1938년. 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/7P0aex6lES4VGydS9Aq9.jpg | NULL | media/roberta-jang/thumbs/7P0aex6lES4VGydS9Aq9.jpg | media/roberta-jang/thumbs/7P0aex6lES4VGydS9Aq9.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/7P0aex6lES | 1938 | NULL | NULL | 1 | 0 | 0 | NULL |
| UusfBWWbReyiAK2g8Iyz3g | 사진 | 이민 초기 한인노동자의 생활도구 Early immigrant kitchenware | 이민 초기 한인노동자의 생활도구 | NULL | media/roberta-jang/original/oxXpcAov739aQGajcWAL.jpg | NULL | media/roberta-jang/thumbs/oxXpcAov739aQGajcWAL.jpg | media/roberta-jang/thumbs/oxXpcAov739aQGajcWAL.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/ICACikXqDz | NULL | 그들의 발자취 | 39 | A pictorial history of the Japanese in Hawaii 1885-1924 | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/oxXpcAov73 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| uT0tejERR2ZtZqxiwCg9 | 사진 | two cars and a streetcar on the road | NULL | Seoul - two cars and a streetcar on the road | media/jungnamyong/original/uT0tejERR2ZtZqxiwCg9.jpg | 1945 | media/jungnamyong/thumbs/uT0tejERR2ZtZqxiwCg9.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #6_113_Seoul - two cars and a streetcar on the road_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 |
| UT044PsaRPiDPXGqBIaxog | NULL | 지영회씨 표창장 (1950) Presidential Citation issued by President Syngman Rhee | 지영회 | NULL | media/roberta-jang/original/6PNShqItrankXWNf0PfE.jpg | 1950년 | media/roberta-jang/thumbs/6PNShqItrankXWNf0PfE.jpg | media/roberta-jang/thumbs/6PNShqItrankXWNf0PfE.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 209 | Mrs. Agnes Rho Chun 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/6PNShqItra | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| uSIWb3N25SJza9ankrNk | 사진 | Drying rice | NULL | Drying rice_ | media/jungnamyong/original/uSIWb3N25SJza9ankrNk.jpg | NULL | media/jungnamyong/thumbs/uSIWb3N25SJza9ankrNk.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_53_Drying rice_.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 |
| uS5PrBTuRY-tHqFon9Ol6w | NULL | 성공회 부인회（1920년경） Women's Auxiliary of St. Luke’s Church | 성공회 부인회, Women's Auxiliary of St. Luke’s Church | NULL | media/roberta-jang/original/tcJZVTcllNeutwgiLBQl.jpg | NULL | media/roberta-jang/thumbs/tcJZVTcllNeutwgiLBQl.jpg | media/roberta-jang/thumbs/tcJZVTcllNeutwgiLBQl.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 144 | Dr. Jackie Youn^ 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/tcJZVTcllN | 1920 | NULL | 1920년경 | 2 | 0 | 0 | NULL |
| uRACybRxSAaJQeQCT5sWQA | NULL | 1916년 사진훈인으로 맺어진 조문칠과 심영신씨 가정이 30여년 후 이민3대의 대가족을 이루었다. (1949) Mr. & Mrs. Moon Chil (Young Sin) Cho m | 조문칠, 심영신 | NULL | media/roberta-jang/original/S7SGolYSSWOPj7jQC1M0.jpg | NULL | media/roberta-jang/thumbs/S7SGolYSSWOPj7jQC1M0.jpg | media/roberta-jang/thumbs/S7SGolYSSWOPj7jQC1M0.jpg | 조문칠,심영신 | 2025-07-14 00:00:00 | 조문칠,심영신 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 55 | Rev .T.Samuel Lee 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/S7SGolYSSW | 1916 | NULL | NULL | 2 | 1 | 1 | NULL |
| uNwXeqpCTbW.t.T12do2Dg | NULL | 와히아와 한인기독교회, 박동안 목사 시무식 Wahiawa Korean Christian Church, Rev. Dong An Park | 박동안 목사 | NULL | media/roberta-jang/original/FFvH7ZDNWRGJesCzOQLs.jpg | NULL | media/roberta-jang/thumbs/FFvH7ZDNWRGJesCzOQLs.jpg | media/roberta-jang/thumbs/FFvH7ZDNWRGJesCzOQLs.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 167 | 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/FFvH7ZDNWR | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| unBIsj3FR5qlReBuhGjs4A | 사진 | 한인 감리교회 센터 교회와 회관. 교구목사관이 새로 지어졌다. 1922년경. 제1연합감리교회 컬렉션. | 한인 감리교회, 제1연합감리교회 | NULL | media/roberta-jang/original/ZIh3G6c8Kizxr6gZMSZg.jpg | NULL | media/roberta-jang/thumbs/ZIh3G6c8Kizxr6gZMSZg.jpg | media/roberta-jang/thumbs/ZIh3G6c8Kizxr6gZMSZg.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/ZIh3G6c8Ki | 1922 | NULL | 1922년경 | 2 | 0 | 0 | NULL |
| UMzUcijlRg-1tjqINuFNBw | NULL | 제일한인감리교회 임원(1948) 2. 장형신，3. 문또라，4. 최영기, 5. 최순경，6. 김서을, 7. 안장호 목사 8. 홍치범 목사，9. 김병율， 10. 정의조 목사 13. 한명 | 장형신, 문또라, 최영기, 최순경, 김서을, 안장호, 홍치범, 김병율, 정의조, 한명교, 한 그레이스, 정월라, 황혜수, 정 에스터, 황사용, 오정자, 김이제, 최은희, 민찬호 | NULL | media/roberta-jang/original/zIXkmzE60ToEhsTpacDP.jpg | NULL | media/roberta-jang/thumbs/zIXkmzE60ToEhsTpacDP.jpg | media/roberta-jang/thumbs/zIXkmzE60ToEhsTpacDP.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 122 | Mr. Young Ok Kang Collection | 2025-09-14 05:59:58 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/zIXkmzE60T | NULL | NULL | NULL | 19 | 1 | 1 | NULL |
| uMtPzFq9TMSHFNPwLRLKMA | 사진 | 호놀롤루 예술 아카데미에 참가한 한인들의 야외공연. 1953년경. Geraldine Ome 앨범. | Geraldine Ome | NULL | media/roberta-jang/original/VZb6DUy4ldTAvpSn3arn.jpg | NULL | media/roberta-jang/thumbs/VZb6DUy4ldTAvpSn3arn.jpg | media/roberta-jang/thumbs/VZb6DUy4ldTAvpSn3arn.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/VZb6DUy4ld | 1953 | NULL | 1953년경 | 1 | 0 | 0 | NULL |
| UMN8VQtySLiRcKh.WDeDIw | NULL | 성누가교회 팔라마 채플시절 （1924-1951） St. Luke’s，Palama Chapel period | 성누가교회, 팔라마 채플 | NULL | media/roberta-jang/original/BezWvvR0uJsQWouWj03i.jpg | NULL | media/roberta-jang/thumbs/BezWvvR0uJsQWouWj03i.jpg | media/roberta-jang/thumbs/BezWvvR0uJsQWouWj03i.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 147 | 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/BezWvvR0uJ | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| Um4d00rQRGagePzcdRs6XQ | NULL | 국민부인회 (1931) Korean Women’s Society celebrating March 1st Movement | 국민부인회 | NULL | media/roberta-jang/original/lfMEgcwoGIkpRej1sNrj.jpg | NULL | media/roberta-jang/thumbs/lfMEgcwoGIkpRej1sNrj.jpg | media/roberta-jang/thumbs/lfMEgcwoGIkpRej1sNrj.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/T8YrQj3T9s | NULL | 그들의 발자취 | 90 | Mrs. Joyce Lee | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/lfMEgcwoGI | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| ulkWInxMTymswLaOaxnYBQ | 사진 | 한라 함 공연. 1950년대경. 한라 함 스튜디오 컬렉션. | 한라 함 | NULL | media/roberta-jang/original/lLsbSoXiCzjjtfyUO5AT.jpg | NULL | media/roberta-jang/thumbs/lLsbSoXiCzjjtfyUO5AT.jpg | media/roberta-jang/thumbs/lLsbSoXiCzjjtfyUO5AT.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/lLsbSoXiCz | 1950 | 1950년대 | NULL | 1 | 0 | 0 | NULL |
| uk4WA10VSq6QuPBR1hXK3Q | 사진 | 보성회(Po Sung Hoi). 하와이 대학교에서 처음으로 만들어진 한인 여대생 단체. 앞줄 왼쪽에서 첫번째 Gladys Lee, 세 번째 사라 서(Sarah Sur), 네 번째 | Gladys Lee, 사라 서(Sarah Sur), Agnes Inn, Annie Kim, Sylvia Moon, Miriam Kang, 엘라 양(Ella Yang), Elaine | NULL | media/roberta-jang/original/8dpRfCTgfyqMqXyAqIi2.jpg | NULL | media/roberta-jang/thumbs/8dpRfCTgfyqMqXyAqIi2.jpg | media/roberta-jang/thumbs/8dpRfCTgfyqMqXyAqIi2.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/8dpRfCTgfy | 1934 | NULL | NULL | 11 | 0 | 0 | NULL |
| UjkQwpZcRIicb5PE2KfrOA | 사진 | 정진오와 가족.왼쪽부터, 앤나(Anna, 어머니), 아그네스(Agnes), 덕홍(Duk Hong), 두옥, 정진오. 1910년경. 정남영(Nam Young Chung) 앨범. | 정진오, 앤나, 아그네스, 덕홍, 두옥, 정남용 | NULL | media/roberta-jang/original/RBfOGFQ41PVnpGOIv1uL.jpg | NULL | media/roberta-jang/thumbs/RBfOGFQ41PVnpGOIv1uL.jpg | media/roberta-jang/thumbs/RBfOGFQ41PVnpGOIv1uL.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-31 23:25:12 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/RBfOGFQ41P | 1910 | NULL | 1910년경 | 6 | 0 | 0 | NULL |
| uIZ1Ee0zRGumhog.YxLAOQ | 사진 | 조지아의 임두화(Doo Wha Lim). 1925년경. 차이석 앨범. | 임두화 | NULL | media/roberta-jang/original/fG2mGMo2LFyGMpjLCHjx.jpg | NULL | media/roberta-jang/thumbs/fG2mGMo2LFyGMpjLCHjx.jpg | media/roberta-jang/thumbs/fG2mGMo2LFyGMpjLCHjx.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/fG2mGMo2LF | 1925 | NULL | 1925년경 | 1 | 1 | 0 | NULL |