컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| kOJ4822HSNCRPa6dQuRlAA | 사진 | 김순건의 집조(執照, 대한제국 여권). Edmund Whang 앨범. | 김순건, Edmund Whang | NULL | media/roberta-jang/original/pAjYGLHJlnW7XJCLvP2s.jpg | NULL | media/roberta-jang/thumbs/pAjYGLHJlnW7XJCLvP2s.jpg | media/roberta-jang/thumbs/pAjYGLHJlnW7XJCLvP2s.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/pAjYGLHJln | NULL | NULL | NULL | 2 | 1 | 0 |
| kO0JlhabTKeU0JPVkgoFZQ | NULL | 대한부인구제회 회원들을 위한 영어학습시간 Korean Women's Relief Society English class | 대한부인구제회 | NULL | media/roberta-jang/original/YDF9l6RECH1ag9zHC5le.jpg | NULL | media/roberta-jang/thumbs/YDF9l6RECH1ag9zHC5le.jpg | media/roberta-jang/thumbs/YDF9l6RECH1ag9zHC5le.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/IShY9WfxO4 | NULL | 그들의 발자취 | 101 | 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/YDF9l6RECH | NULL | NULL | NULL | 1 | 0 | 0 |
| KO.MgvVuTdiDeYK4SYT5PQ | 사진 | 한인이민들이 상권을 장악하고 있는 인터내셔날 마켓. 플레이스 전경 International Market Place (Waikiki) | 한인이민들, 인터내셔날 마켓, 플레이스 | NULL | media/roberta-jang/original/nJKaagBXOciWkDtI5YtF.jpg | NULL | media/roberta-jang/thumbs/nJKaagBXOciWkDtI5YtF.jpg | media/roberta-jang/thumbs/nJKaagBXOciWkDtI5YtF.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 34 | 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/nJKaagBXOc | NULL | NULL | NULL | 3 | 0 | 0 |
| kmnSCk51RQu3fnGD8ArzdQ | NULL | 하와이 한인이민90주년 이민선조를 위한 기도회에 참석한 김성수 한국성공회 대주교，맨 오른쪽(1993) Archbishop Simon Kim of Korea visits St. Lu | 김성수, Simon Kim | NULL | media/roberta-jang/original/GtIIewanAgFWfFP9Zpkg.jpg | NULL | media/roberta-jang/thumbs/GtIIewanAgFWfFP9Zpkg.jpg | media/roberta-jang/thumbs/GtIIewanAgFWfFP9Zpkg.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 153 | Korea Central Daily 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/GtIIewanAg | NULL | NULL | NULL | 2 | 1 | 0 |
| kMezB8HuRVm5JiyaUBLFPw | 사진 | 국제시장의 한국인 매장. 1980년대경. 『코리아타임스 』. | 이름: 코리아타임스 | NULL | media/roberta-jang/original/6It12e2zVeOxAp0BiXkZ.jpg | NULL | media/roberta-jang/thumbs/6It12e2zVeOxAp0BiXkZ.jpg | media/roberta-jang/thumbs/6It12e2zVeOxAp0BiXkZ.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/6It12e2zVe | 1980 | 1980년대 | NULL | 1 | 0 | 0 |
| KlFRA4fpS6yCA92l32f2lA | 사진 | 고덕화씨 집조 (여권)，대한제국 수민원 총재 정1품 민영흰. 발행，광무 7년 (1903) Imperial Korean Government Passport issued to Mr. | 고덕화 | NULL | media/roberta-jang/original/FNlgNilUTTCO8ii3Hg3N.jpeg | NULL | media/roberta-jang/thumbs/FNlgNilUTTCO8ii3Hg3N.jpeg | media/roberta-jang/thumbs/FNlgNilUTTCO8ii3Hg3N.jpeg | 고덕화 | 2025-07-09 00:00:00 | 고덕화 | NULL | NULL | NULL | NULL | NULL | 1903-01-09 00:00:00 | NULL | false | 그들의 발자취 | 16 | 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/FNlgNilUTT | NULL | NULL | NULL | 1 | 1 | 1 |
| kIJ09jH-R9eFdaItnqEHmQ | 사진 | 미스 코리아나 미인대회. 왼쪽부터, Annette Ok Hee Lee, Lucille Chung, Danny Kaleikini, In Ja No(미스 코리아나), Vernalynn | Annette Ok Hee Lee, Lucille Chung, Danny Kaleikini, In Ja No, Vernalynn Kim | NULL | media/roberta-jang/original/Envpi3aVduFWtr8fqiOe.jpg | NULL | media/roberta-jang/thumbs/Envpi3aVduFWtr8fqiOe.jpg | media/roberta-jang/thumbs/Envpi3aVduFWtr8fqiOe.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:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/Envpi3aVdu | 1904 | NULL | NULL | 5 | 0 | 0 |
| KhQBhc-6RPSRx.Kx7P5dAA | NULL | 성누가교회, 팔라마 채플의 제단모습 Palama Chapel of St Luke’s Church -Dr. Samuel Lee Collection | 성누가교회, 팔라마 채플 | NULL | media/roberta-jang/original/JjYF3qoq5iAJndg34ccw.jpg | NULL | media/roberta-jang/thumbs/JjYF3qoq5iAJndg34ccw.jpg | media/roberta-jang/thumbs/JjYF3qoq5iAJndg34ccw.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 148 | 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/JjYF3qoq5i | NULL | NULL | NULL | 2 | 0 | 0 |
| KFdp.bf9SQulta97ew0CnA | NULL | 한인여자학원 (1915) 이승만 박사는 1916년 한인여자학원을 한인여자성경학원으로 바꾸고 국어와 영어를 가르졌다. 한인기독학원의 전신 Korean Girls Seminary, t | 이승만 | NULL | media/roberta-jang/original/AsP0r019D4YU8GGDWV27.JPG | NULL | media/roberta-jang/thumbs/AsP0r019D4YU8GGDWV27.JPG | media/roberta-jang/thumbs/AsP0r019D4YU8GGDWV27.JPG | NULL | 2025-07-08 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 172 | Bishop Museum | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/AsP0r019D4 | 1915 | NULL | NULL | 1 | 0 | 1 |
| kEZYv88LSLCkPRcK3CKGtQ | NULL | 주선모씨 징집영장(1918) Military service induction notice issued to Mr. Sun Mo Choo | 주선모 | NULL | media/roberta-jang/original/rAH3R6cEWhbXcDSZnJhK.jpg | NULL | media/roberta-jang/thumbs/rAH3R6cEWhbXcDSZnJhK.jpg | media/roberta-jang/thumbs/rAH3R6cEWhbXcDSZnJhK.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/CLXlhAFChT | NULL | 그들의 발자취 | 208 | Mrs. Agnes Pho Chun 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/rAH3R6cEWh | NULL | NULL | NULL | 1 | 1 | 0 |
| kdQRKI2JSr-6TEzWK4.2YQ | NULL | 하와이 부인구제회중앙부의 한국구제사업 회비납부 계약서，계약인 심영신，재무 윤순이 (1947) Korean Women’s Relief Society contribution pledg | 심영신, 윤순이 | NULL | media/roberta-jang/original/2M4PDO9thjHQGrj8YEoK.jpg | NULL | media/roberta-jang/thumbs/2M4PDO9thjHQGrj8YEoK.jpg | media/roberta-jang/thumbs/2M4PDO9thjHQGrj8YEoK.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/0iUBWQi6b5 | NULL | 그들의 발자취 | 96 | Independence Holl of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/2M4PDO9thj | NULL | NULL | NULL | 2 | 0 | 1 |
| kdKusk86S1eZdtebpKg9wg | 사진 | 이동진 목사 부부와 전쟁고아 양녀 유니스 내원 (1959) Rev. & Mrs. T. Samuel Lee and Eunice Nae Won Lee, a war orphan | 이동진 목사 부부, 전쟁고아 유니스 내원 | NULL | media/roberta-jang/original/fwOkiIBKblkZYRr8pqjb.jpg | NULL | media/roberta-jang/thumbs/fwOkiIBKblkZYRr8pqjb.jpg | media/roberta-jang/thumbs/fwOkiIBKblkZYRr8pqjb.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 33 | Rev. Samuel Lee 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/fwOkiIBKbl | NULL | NULL | NULL | 2 | 0 | 0 |
| kbrdBKtOR-qzx6yPXCqVwQ | 사진 | Theresa Soo Chun Kim. 조 김치 공장의 여사장. 1940년대. 앤드류 김 앨범. | Theresa Soo Chun Kim, 조 김치 공장의 여사장, 앤드류 김. | NULL | media/roberta-jang/original/KqSXwkm1kXcC6RhsNxIO.jpg | NULL | media/roberta-jang/thumbs/KqSXwkm1kXcC6RhsNxIO.jpg | media/roberta-jang/thumbs/KqSXwkm1kXcC6RhsNxIO.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/KqSXwkm1kX | 1940 | 1940년대 | NULL | 3 | 0 | 0 |
| KbPlU8yjRzunwZ1ZHrz2Vw | 사진 | 한국에 잇는 아들이 하와이에 있는 아버지에게 보낸 편지. '사랑하는 아버님'이라는 글로 시작된다. 1925년. 익명의 기증자. | 아버님 | NULL | media/roberta-jang/original/paGUc6DxNQmNnIW15Erk.jpg | NULL | media/roberta-jang/thumbs/paGUc6DxNQmNnIW15Erk.jpg | media/roberta-jang/thumbs/paGUc6DxNQmNnIW15Erk.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:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/paGUc6DxNQ | 1925 | NULL | NULL | 1 | 0 | 0 |
| KaYFLeoMQLqeO71xI1s86Q | 사진 | 와이알루아의 푸우이키(Puuiki) 묘지. 하와이 초기 한인 묘지. 안형주(Henry Hyung-ju Ahn) 컬렉션. | 안형주(Henry Hyung-ju Ahn) | NULL | media/roberta-jang/original/toyP4S3i9z4Z9TtIAZO3.jpg | NULL | media/roberta-jang/thumbs/toyP4S3i9z4Z9TtIAZO3.jpg | media/roberta-jang/thumbs/toyP4S3i9z4Z9TtIAZO3.jpg | 김춘경 | 2025-07-08 00:00:00 | 김춘경 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 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/toyP4S3i9z | NULL | NULL | NULL | 1 | 0 | 0 |
| k8zs-Xb9Q8mio7lXVGDMdA | 사진 | 제2차 세계대전 이후 제2차 이민 행렬에 합류하여 미국으로 이주한 한인 노인들이 하와이 100주년 기념식에서 여유 있게 즐기고 있다. 왼쪽부터, 정영해(Young Hae Chung | 정영해, 정영희, 박진영, 김연구 | NULL | media/roberta-jang/original/O9MB1n3u9DLtrLjByd4k.jpg | NULL | media/roberta-jang/thumbs/O9MB1n3u9DLtrLjByd4k.jpg | media/roberta-jang/thumbs/O9MB1n3u9DLtrLjByd4k.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:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/O9MB1n3u9D | 2002 | NULL | NULL | 4 | 1 | 0 |
| K8KT.qsyTZ2u80jB6ZSldg | NULL | 호놀룰루에서 개최된 "해외한족대회 재미통합한국위원회”(1943) 1. 손성운，2. 도진호, 3. 던경무, 4. 김현구, 5. 김영기，6. 김원용, 7.심영신，8. 안원규，9. 이원 | 1. 손성운 2. 도진호 3. 던경무 4. 김현구 5. 김영기 6. 김원용 7. 심영신 8. 안원규 9. 이원순 10. 조병요 11. 민함나 | NULL | media/roberta-jang/original/p7Pt69JpEPEqBXbXSg75.jpg | NULL | media/roberta-jang/thumbs/p7Pt69JpEPEqBXbXSg75.jpg | media/roberta-jang/thumbs/p7Pt69JpEPEqBXbXSg75.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/6rPHkg0RtW | NULL | 그들의 발자취 | 77 | 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/p7Pt69JpEP | NULL | NULL | NULL | 11 | 1 | 1 |
| k6sjhkCbRMaq7yU-nl2MZg | 사진 | 이경호(Benedict Kyong Ho)와 박태윤(Anna Tai Yun Park Lee). 1917년. Lucille Lee Kang 앨범. | 이경호, 박태윤, Lucille Lee Kang | NULL | media/roberta-jang/original/nZgBQBE2nbnNhpA2uH1S.jpg | NULL | media/roberta-jang/thumbs/nZgBQBE2nbnNhpA2uH1S.jpg | media/roberta-jang/thumbs/nZgBQBE2nbnNhpA2uH1S.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/nZgBQBE2nb | 1917 | NULL | NULL | 3 | 1 | 0 |
| K6iMkNZ-RWeGgILQ116t0A | NULL | 그리스도연합감리교회 창립90주년 기념사진전 개막식(1993) Photo exhibition opening ceremony commemorating 90th anniversary o | 그리스도연합감리교회 | NULL | media/roberta-jang/original/yjkYSulZ3UQn4NiqfV5z.jpg | NULL | media/roberta-jang/thumbs/yjkYSulZ3UQn4NiqfV5z.jpg | media/roberta-jang/thumbs/yjkYSulZ3UQn4NiqfV5z.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 128 | Korea Central Daily 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/yjkYSulZ3U | NULL | NULL | NULL | 1 | 0 | 0 |
| k5gwj8-dQP6GgdF-0CY5uQ | 사진 | '윗교회' 한인 기독교회. 1928년. 메리 문 한(Mary Moon Han) 앨범. | 메리 문 한 (Mary Moon Han) | NULL | media/roberta-jang/original/VKryyx5QM7vC7XTbj2mM.jpg | NULL | media/roberta-jang/thumbs/VKryyx5QM7vC7XTbj2mM.jpg | media/roberta-jang/thumbs/VKryyx5QM7vC7XTbj2mM.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/VKryyx5QM7 | 1928 | NULL | NULL | 1 | 0 | 0 |