컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| kOkDVi1sQOe1o0-B1w19GA | 사진 | 1903년 1월 13일 2살난 큰딸을 데리고 첫 이민선 S. S. Gaelic호에 몸을 실은 김치원씨 가족이 어느덧 대가족이 되었다. (연도미상) & Mrs. Chee Won (E | 김치원, 엘리자베스 한 | NULL | media/roberta-jang/original/zYpKvSWR1nKMPuGdRCqu.jpeg | NULL | media/roberta-jang/thumbs/zYpKvSWR1nKMPuGdRCqu.jpeg | media/roberta-jang/thumbs/zYpKvSWR1nKMPuGdRCqu.jpeg | 김치원 | 2025-07-15 00:00:00 | 김치원 | NULL | NULL | NULL | NULL | NULL | NULL | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/F5V2iHADAs | false | 그들의 발자취 | 15 | Dr. Jackie Young 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/zYpKvSWR1n | 1903 | NULL | NULL | 2 | 1 | 0 | NULL |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| kL33yTCJdRuhF9dK92kT | 사진 | NULL | NULL | Farmers in a field mom's relatives | media/jungnamyong/original/kL33yTCJdRuhF9dK92kT.jpg | NULL | media/jungnamyong/thumbs/kL33yTCJdRuhF9dK92kT.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_48_Farmers in a field mom's relatives.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 |
| 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 | NULL |
| 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 | NULL |
| KfhwapRpDDuY9uyhmoC0 | 사진 | 4-H Club Fair - A gate with stone walls | Club Fair | 4-H Club Fair - A gate with stone walls | media/jungnamyong/original/KfhwapRpDDuY9uyhmoC0.jpg | NULL | media/jungnamyong/thumbs/KfhwapRpDDuY9uyhmoC0.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #1_4_4-H Club Fair - A gate with stone walls.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 |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| kbtg7gSNGJXj5thAjxHV | 사진 | A farm village | NULL | A farm village | media/jungnamyong/original/kbtg7gSNGJXj5thAjxHV.jpg | NULL | media/jungnamyong/thumbs/kbtg7gSNGJXj5thAjxHV.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_62_A farm village.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 |
| 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 | NULL |
| 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 | NULL |
| 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 | NULL |
| k98BiA18qA6yCgwJficB | 사진 | NULL | NULL | NULL | media/salome-choehan/original/k98BiA18qA6yCgwJficB.jpg | NULL | media/salome-choehan/thumbs/k98BiA18qA6yCgwJficB.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00012.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 |