컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| iLQrrt0OTIuCGWTe2n57Qw | NULL | 문대양 주대법원장의 외할아버지 이만기씨 가족사진 Hon. Chief Justice Ronald Moon's grandfather Man Kee Lee and family | 문대양, 이만기, Ronald Moon | NULL | media/roberta-jang/original/mPLsCNxSIOnMHcZHETlx.jpg | NULL | media/roberta-jang/thumbs/mPLsCNxSIOnMHcZHETlx.jpg | media/roberta-jang/thumbs/mPLsCNxSIOnMHcZHETlx.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 42 | Daisy Choi 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/mPLsCNxSIO | NULL | NULL | NULL | 3 | 1 | 0 | NULL |
| ilfVnxtURru3Zr69.3Ddkg | 사진 | 한국에 머문 국제 외교관들과 호레이스 알렌 박사(중앙). 1899년경. 천안 독립기념관 컬렉션. | 호레이스 알렌 박사 | NULL | media/roberta-jang/original/s9mnuKdXiC5m0nzq4oJo.jpg | NULL | media/roberta-jang/thumbs/s9mnuKdXiC5m0nzq4oJo.jpg | media/roberta-jang/thumbs/s9mnuKdXiC5m0nzq4oJo.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/s9mnuKdXiC | 1899 | NULL | 1899년경 | 1 | 0 | 0 | NULL |
| iKKn8Iz5SQOE.7ty2Qh68g | 사진 | 대한항공 858기 폭파사건을 규탄하는 시위. 1986년. 『 코리아타임스』. | 대한항공 858기 폭파사건 | NULL | media/roberta-jang/original/Q2CpueRBPgEuCDMKGCtg.jpg | NULL | media/roberta-jang/thumbs/Q2CpueRBPgEuCDMKGCtg.jpg | media/roberta-jang/thumbs/Q2CpueRBPgEuCDMKGCtg.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/Q2CpueRBPg | 1986 | NULL | NULL | 1 | 0 | 0 | NULL |
| ikeynV.mQXerOhFociopLw | NULL | 한라 배 함 여사 (1950) Halla Pai Huhm | 한라 배 함 여사 (Halla Pai Huhm) | NULL | media/roberta-jang/original/FjytPxA2UbzTi23s0ZNZ.jpg | NULL | media/roberta-jang/thumbs/FjytPxA2UbzTi23s0ZNZ.jpg | media/roberta-jang/thumbs/FjytPxA2UbzTi23s0ZNZ.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 195 | Dr. Alice Yun Chai 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/FjytPxA2Ub | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| ijSvxK18QHGF0RZ9CdxUPg | 사진 | 와이파후 한인 감리교회 집회. 김이제(Yee Chai Kim) 목사(왼쪽 끝). 1906년. 민병용 컬렉션. | 김이제 | NULL | media/roberta-jang/original/5FUcFohsROKwNxFq3D40.jpg | NULL | media/roberta-jang/thumbs/5FUcFohsROKwNxFq3D40.jpg | media/roberta-jang/thumbs/5FUcFohsROKwNxFq3D40.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/5FUcFohsRO | 1906 | NULL | NULL | 1 | 1 | 0 | NULL |
| IhOInI5FTUCseEwpzSvDQQ | NULL | 대한민국 공채 Certificate of Indebtedness | 대한민국 | NULL | media/roberta-jang/original/DXnFgU2wUPTco7VHpMVA.jpg | NULL | media/roberta-jang/thumbs/DXnFgU2wUPTco7VHpMVA.jpg | media/roberta-jang/thumbs/DXnFgU2wUPTco7VHpMVA.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/JqON5N2iu3 | NULL | 그들의 발자취 | 205 | 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/DXnFgU2wUP | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| igsPiNCG2EZjjAKoswW2 | 사진 | a farmer in a field | NULL | Rice harvest - a farmer in a field_ | media/jungnamyong/original/igsPiNCG2EZjjAKoswW2.jpg | NULL | media/jungnamyong/thumbs/igsPiNCG2EZjjAKoswW2.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_28_Rice harvest - a farmer in a 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 |
| igPGnAhkibSlIjTUhAtL | 사진 | NULL | NULL | NULL | media/salome-choehan/original/igPGnAhkibSlIjTUhAtL.jpg | NULL | media/salome-choehan/thumbs/igPGnAhkibSlIjTUhAtL.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 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 |
| iFOx0kilSy2ehD2vI0Ce0Q | 사진 | 한인 기독교회는 해방후 최초로 하와이로 유학온 학생들을 환영하였다. (1947) First Korean students to arrive in 1947, after the libe | Unknown, Chang Kyo Kim, Bok Cha Kim, Veronica Park, Samuel Lee, Choun Yung Lee | NULL | media/roberta-jang/original/ZUJeiswZaN9BoMKkRrnm.jpg | NULL | media/roberta-jang/thumbs/ZUJeiswZaN9BoMKkRrnm.jpg | media/roberta-jang/thumbs/ZUJeiswZaN9BoMKkRrnm.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 31 | Rev. T. Samuel Lee 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/ZUJeiswZaN | NULL | NULL | NULL | 6 | 0 | 0 | NULL |
| iFapT3iaTV2zCPhpNNUeEw | NULL | 한인 2세 델타클럽 (1992년 창립) Delta Club - Dr Won Sik You Collection 1. Paul Young 2. James Yue 3. Harry Cho | Paul Young, James Yue, Harry Cho, William Choi, Flora Choi, Matthew Pyun, Unknown, Won Sik You, Koni | NULL | media/roberta-jang/original/dAqyqw4jzL5nxa5GBZzY.jpg | NULL | media/roberta-jang/thumbs/dAqyqw4jzL5nxa5GBZzY.jpg | media/roberta-jang/thumbs/dAqyqw4jzL5nxa5GBZzY.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 107 | 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/dAqyqw4jzL | 1992 | NULL | NULL | 17 | 0 | 0 | NULL |
| iCXvfrjE9IhQPiWIg4K2 | 사진 | Buck wheat | NULL | Buck wheat | media/jungnamyong/original/iCXvfrjE9IhQPiWIg4K2.jpg | NULL | media/jungnamyong/thumbs/iCXvfrjE9IhQPiWIg4K2.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_79_Buck wheat.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 |
| Ic-L6GnhRhWsT7j.FkKg2g | NULL | 고 홍치호씨가 기증한 종각의 모습 Bell donated by the late Mr. Chi Ho Hong | 홍치호 | NULL | media/roberta-jang/original/ajXZwQLv0WojMPIO4znV.jpg | NULL | media/roberta-jang/thumbs/ajXZwQLv0WojMPIO4znV.jpg | media/roberta-jang/thumbs/ajXZwQLv0WojMPIO4znV.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 148 | Dr. 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/ajXZwQLv0W | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| IAFaP1hGQ6iWTo0C3Grz0A | NULL | 독립금 공고서, 재미한족연합위원회 의사부 Financial report of the United Korean Committee in America | 독립금 공고서, 재미한족연합위원회 | NULL | media/roberta-jang/original/LNqLLlLtUXczVXJSoKwE.jpg | NULL | media/roberta-jang/thumbs/LNqLLlLtUXczVXJSoKwE.jpg | media/roberta-jang/thumbs/LNqLLlLtUXczVXJSoKwE.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/jLlW8i7so3 | NULL | 그들의 발자취 | 79 | independence Holl 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/LNqLLlLtUX | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| i8WorUXzQcaXPeFFyjOosQ | 사진 | 하와이 힐로. | 하와이 힐�� | 왼쪽부터, 김영신(Young Sin Kim)과 김명근(Myong Kun Kim, 자매), 살로메 김(Solome Kim, 김영신의 딸), 박종수(Chong Soo Park), An | media/roberta-jang/original/rOakS6uBl0Mg5CpoxUl8.jpg | NULL | media/roberta-jang/thumbs/rOakS6uBl0Mg5CpoxUl8.jpg | media/roberta-jang/thumbs/rOakS6uBl0Mg5CpoxUl8.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:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/rOakS6uBl0 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| I8iYHTA8RaWjimyuwVcv1A | NULL | 사진신부 정영옥，1918년 사진결혼 이민 Mrs. Young Ok Chung | 정영옥, Young Ok Chung | NULL | media/roberta-jang/original/CI7Z9dU0F5f2Xi6s7a6K.jpg | NULL | media/roberta-jang/thumbs/CI7Z9dU0F5f2Xi6s7a6K.jpg | media/roberta-jang/thumbs/CI7Z9dU0F5f2Xi6s7a6K.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/5FOSRQrWU3 | NULL | 그들의 발자취 | 56 | 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/CI7Z9dU0F5 | 1918 | NULL | NULL | 2 | 0 | 0 | NULL |
| I8B4x6H1QgmhMPBZue-ZUA | NULL | 한인이민초 헌신적인 교역자들의 노력으로 한인들의 신앙이 불타기 시작했다. 민찬호, 홍치범 목사 가족(연도미상) Christianity spread among the early Ko | 민찬호, 홍치범 | NULL | media/roberta-jang/original/0vfgREbrmojyQPqHGCop.jpg | NULL | media/roberta-jang/thumbs/0vfgREbrmojyQPqHGCop.jpg | media/roberta-jang/thumbs/0vfgREbrmojyQPqHGCop.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/H8O0yGmIK9 | NULL | 그들의 발자취 | 43 | Dr Thomas Min 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/0vfgREbrmo | NULL | NULL | NULL | 2 | 1 | 1 | NULL |
| I2F6mjOpvNZFHP2x87xL | 사진 | US Army Headquarter | Military Govermment Building | US Military Govermment Building-US Army Headquarter | media/jungnamyong/original/I2F6mjOpvNZFHP2x87xL.jpg | 1946 | media/jungnamyong/thumbs/I2F6mjOpvNZFHP2x87xL.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #1_5_US Military Govermment Building-US Army Headquarter_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 |
| i0QbNzxxBcrH2YfiQ1Oz | 사진 | friends (8 people) | Hawaii Korean | Hawaii Korean US soldiers - friends (8 people) | media/jungnamyong/original/i0QbNzxxBcrH2YfiQ1Oz.jpg | NULL | media/jungnamyong/thumbs/i0QbNzxxBcrH2YfiQ1Oz.jpg | NULL | NULL | NULL | Hawaii | NULL | NULL | #6_120_Hawaii Korean US soldiers - friends (8 people).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 |
| hZbg6eGHTjy2bLhkiOrTJQ | NULL | 올리브 연합감리교회 주일학교 교사들(1954) Sunday School of Olive United Methodist Church | 올리브 연합감리교회 주일학교 교사들 | NULL | media/roberta-jang/original/lqETsBEP7FROcj30WOZl.jpg | NULL | media/roberta-jang/thumbs/lqETsBEP7FROcj30WOZl.jpg | media/roberta-jang/thumbs/lqETsBEP7FROcj30WOZl.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/yfMIHR8aTQ | NULL | 그들의 발자취 | 134 | Olive United Methodist Church 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/lqETsBEP7F | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| hyTWnNCy5nIGClZKa6CK | 사진 | Niagara falls | NULL | Niagara falls | media/jungnamyong/original/hyTWnNCy5nIGClZKa6CK.jpg | NULL | media/jungnamyong/thumbs/hyTWnNCy5nIGClZKa6CK.jpg | NULL | NULL | NULL | Niagara | NULL | NULL | #3_50_Niagara falls.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 |