컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| UMzUcijlRg-1tjqINuFNBw | NULL | 제일한인감리교회 임원(1948) 2. 장형신，3. 문또라，4. 최영기, 5. 최순경，6. 김서을, 7. 안장호 목사 8. 홍치범 목사，9. 김병율， 10. 정의조 목사 13. 한명 | 1. 장형신 2. 문또라 3. 최영기 4. 최순경 5. 김서을 6. 안장호 7. 홍치범 8. 김병율 9. 정의조 10. 한명교 11. 한 그레이스 12. 정월라 13. 황혜수 14 | 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 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/zIXkmzE60T | NULL | NULL | NULL | 19 | 1 | 1 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/RBfOGFQ41P | 1910 | NULL | 1910년경 | 6 | 0 | 0 |
| 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 |
| uI0oA7hHRkikncONXF.BPw | 사진 | 피아니스트이자 작곡가인 강영각이 이끈 디누바 한인 밴드 (Dinuba Korean Band). 1910년대경. 안형주(Henry Hyung-ju Ahn) 컬렉션. | 강영각, 안형주 | NULL | media/roberta-jang/original/EbGBJnBDbOkP6UWaploU.jpg | NULL | media/roberta-jang/thumbs/EbGBJnBDbOkP6UWaploU.jpg | media/roberta-jang/thumbs/EbGBJnBDbOkP6UWaploU.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:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/EbGBJnBDbO | 1910 | 1910년대 | NULL | 2 | 0 | 1 |
| Uhye92gjTgaFWAP9eqzlaw | NULL | 호놀룰루 시가지를 행진하는 국민군단의 모습 (1917) A procession of soldiers from the Korean Liberation Army, Honolulu | 호놀룰루 시가지를 행진하는 국민군단의 모습 (1917) | NULL | media/roberta-jang/original/JAuYEZPBcxwVb9wt208j.jpg | NULL | media/roberta-jang/thumbs/JAuYEZPBcxwVb9wt208j.jpg | media/roberta-jang/thumbs/JAuYEZPBcxwVb9wt208j.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/gRkIjlyzqf | NULL | 그들의 발자취 | 69 | Mr. Young Ok Kang 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/JAuYEZPBcx | NULL | NULL | NULL | 1 | 0 | 0 |
| uhV6nHkbRM-IDL0E8eIWcg | 사진 | 박덕순(Duk Soon Park)과 마르타 한 박(Martha Hahn Pahk) 가족. | 박덕순, 마르타 한 박 | 왼쪽부터, 왈라스(Wallace), 덕순, 애니(Annie), 아그네스(Agnes,앉아있는 아이), 노라(Nora), 로즈(Rose), 하젤(Hazel), 마르타, 스텔라(Stel | media/roberta-jang/original/bfMPBgIhNhxLwgsR7RNQ.jpg | NULL | media/roberta-jang/thumbs/bfMPBgIhNhxLwgsR7RNQ.jpg | media/roberta-jang/thumbs/bfMPBgIhNhxLwgsR7RNQ.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/bfMPBgIhNh | NULL | NULL | NULL | 2 | 1 | 0 |
| Uh2PNimPSLGORNw1hJ5Rbg | 사진 | 동지회가 한인 기독교회에 재집결하였다. 1930년. 강영옥(Young Ok Kang) 컬렉션. | 강영옥 | NULL | media/roberta-jang/original/VUjiUfQScQwnzshJvwIK.jpg | NULL | media/roberta-jang/thumbs/VUjiUfQScQwnzshJvwIK.jpg | media/roberta-jang/thumbs/VUjiUfQScQwnzshJvwIK.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/VUjiUfQScQ | 1930 | NULL | NULL | 1 | 0 | 0 |
| uFmPAa2DSHSZqgHFDz1R.w | NULL | 한 살로에 부동산 중개인 자격증(1949) The Real Estate License Commission of the Territory of Hawaii | 한 살로 | NULL | media/roberta-jang/original/vmn8Mxp7rietcOBMTBui.jpg | NULL | media/roberta-jang/thumbs/vmn8Mxp7rietcOBMTBui.jpg | media/roberta-jang/thumbs/vmn8Mxp7rietcOBMTBui.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 206 | Mrs. Salome Choi Han 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/vmn8Mxp7ri | NULL | NULL | NULL | 1 | 0 | 0 |
| uetE6n3QSjqaZALQOeUo8Q | NULL | 김신라, 1922년 하와이 도작, 당시 19세 김종환씨와 사진결혼, 슬하에 2남3녀를 두었다. 김신라 사진신부는 자기개발을 위하여 학업을 게을리 하지 않았다. (1945) Sill | 김신라, 김종환 | NULL | media/roberta-jang/original/Ods5xE71duHcq39kiuHd.jpg | NULL | media/roberta-jang/thumbs/Ods5xE71duHcq39kiuHd.jpg | media/roberta-jang/thumbs/Ods5xE71duHcq39kiuHd.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 53 | Mrs Silla Kim Collection | 2025-09-14 05:59:58 | 2025-12-06 11:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/Ods5xE71du | 1922 | NULL | NULL | 2 | 0 | 0 |