컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| rutoVyTFRxiVDL7CK7ehcw | 사진 | 현순 목사와 서울성가대. 서울. 1912년경. 데이비드 현 컬렉션. | 현순 목사, 서울성가대. | NULL | media/roberta-jang/original/HU3Xs9ZKlyPqXDmKcqzX.jpg | NULL | media/roberta-jang/thumbs/HU3Xs9ZKlyPqXDmKcqzX.jpg | media/roberta-jang/thumbs/HU3Xs9ZKlyPqXDmKcqzX.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/HU3Xs9ZKly | 1912 | NULL | 1912년경 | 2 | 0 | 0 | NULL |
| ruHpZe42SDWSZJjENOEIxg | 사진 | 남(Nahm) 자매. 패니(Fannie), 헬렌(Helen), 베르타(Bertha). 1914년경. 김영내(Edward Young Nai Kim) 앨범. | 남(Nahm), 패니(Fannie), 헬렌(Helen), 베르타(Bertha), 김영내(Edward Young Nai Kim) | NULL | media/roberta-jang/original/q0Y19OwPEq4DmIJR1YxA.jpg | NULL | media/roberta-jang/thumbs/q0Y19OwPEq4DmIJR1YxA.jpg | media/roberta-jang/thumbs/q0Y19OwPEq4DmIJR1YxA.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/q0Y19OwPEq | 1914 | NULL | 1914년경 | 5 | 0 | 0 | NULL |
| RtmGC1nLS.e9nPjZrurT5A | 사진 | 윤병구 목사. 1930년대경. Susan E. Yoon McDavid 컬렉션. | 윤병구 | NULL | media/roberta-jang/original/tyDixcLATZvktsdF7vID.jpg | NULL | media/roberta-jang/thumbs/tyDixcLATZvktsdF7vID.jpg | media/roberta-jang/thumbs/tyDixcLATZvktsdF7vID.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/tyDixcLATZ | 1930 | 1930년대 | NULL | 1 | 0 | 0 | NULL |
| RsV1aDXLRwW5ZZE2ab0BLg | NULL | 천연희 사진신부는 영어로 토를 달아 자녀들에게 한문공부를 시켰다. Mrs, Yun Hee Chun Given taught Chinese to her children | Yun Hee Chun | NULL | media/roberta-jang/original/CmbuV03DcWmqQODkZNwa.jpg | NULL | media/roberta-jang/thumbs/CmbuV03DcWmqQODkZNwa.jpg | media/roberta-jang/thumbs/CmbuV03DcWmqQODkZNwa.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 58 | 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/CmbuV03DcW | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| rscRhdGLQxq-BpYwcnd2Xw | 사진 | 농장에서 노동자들의 옷을 세탁하는 여성. 1924년경. 감리교회 사진. | 여성 | NULL | media/roberta-jang/original/YJFw1wQYTcLdV9rpqiSa.jpg | NULL | media/roberta-jang/thumbs/YJFw1wQYTcLdV9rpqiSa.jpg | media/roberta-jang/thumbs/YJFw1wQYTcLdV9rpqiSa.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/YJFw1wQYTc | 1924 | NULL | 1924년경 | 1 | 0 | 0 | NULL |
| Rs6tvXPvqtkMcIXQs9D2 | 사진 | Gourds on the roof | NULL | Gourds on the roof | media/jungnamyong/original/Rs6tvXPvqtkMcIXQs9D2.jpg | NULL | media/jungnamyong/thumbs/Rs6tvXPvqtkMcIXQs9D2.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_69_Gourds on the roof.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 |
| rpotedIyFUryXQH7kb3H | 사진 | A bride on Western style wedding dress & two kids on Korean traditional pink dress | NULL | A bride on Western style wedding dress & two kids on Korean traditional pink dress_ | media/jungnamyong/original/rpotedIyFUryXQH7kb3H.jpg | NULL | media/jungnamyong/thumbs/rpotedIyFUryXQH7kb3H.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_56_A bride on Western style wedding dress & two kids on Korean traditional pink dress_.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 |
| rNyScewcTt6nVR3Pp3KQ0A | NULL | 정봉원씨 가족(1940) Mr. & Mrs. Bong Woon (Young Ok) Chung family 1st row(L to R): Ronald, Young Ok, Bong W | 정봉원, 영옥, 로널드, 리차드, 월터, 해리, 윌리엄, 로버트 | NULL | media/roberta-jang/original/xBOGQKzMtxiFsF59nsVr.jpg | NULL | media/roberta-jang/thumbs/xBOGQKzMtxiFsF59nsVr.jpg | media/roberta-jang/thumbs/xBOGQKzMtxiFsF59nsVr.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 56 | 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/xBOGQKzMtx | NULL | NULL | NULL | 8 | 0 | 0 | NULL |
| RNR7l4JsQWmXQDQ.4pzZNg | 사진 | 유동면 (Dong Men 혹은 Dong Myun)과 메리 유(Mary You) 가족. 왼쪽부터, 헨리(Henry), 멜빈(Melvin), 원영(Won young), 메리, 미니(M | 유동면, 메리 유, 헨리, 멜빈, 원영, 미니, 캐티, 원식, 리처드. E | NULL | media/roberta-jang/original/f2DwToVEY4A1ngxMqIVQ.jpg | NULL | media/roberta-jang/thumbs/f2DwToVEY4A1ngxMqIVQ.jpg | media/roberta-jang/thumbs/f2DwToVEY4A1ngxMqIVQ.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/f2DwToVEY4 | 1942 | NULL | 1942년경 | 9 | 1 | 1 | NULL |
| RLwBNILUL04k8i1iEwFR | 사진 | NULL | NULL | Korean shopkeepers - Five men in front of a shop named “WASHINGTON” | media/jungnamyong/original/RLwBNILUL04k8i1iEwFR.jpg | NULL | media/jungnamyong/thumbs/RLwBNILUL04k8i1iEwFR.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #1_6_Korean shopkeepers - Five men in front of a shop named “WASHINGTON”.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 |
| RkrW42N8Sn6uTV4NQtR-AA | NULL | 타이거스 클럽, 맥킨리 고등학교 Tigers Club Mckinley High School | 타이거스 클럽, 맥킨리 고등학교 | NULL | media/roberta-jang/original/3WJEaQWhwdAbdjWn5hgY.jpg | NULL | media/roberta-jang/thumbs/3WJEaQWhwdAbdjWn5hgY.jpg | media/roberta-jang/thumbs/3WJEaQWhwdAbdjWn5hgY.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 108 | Mrs. Sara Kim 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/3WJEaQWhwd | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| RkKG2qKzSrG.fm7wxv1GMg | NULL | 속지 | 속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 168 | NULL | 2025-09-14 05:59:58 | 2026-01-19 08:25:19 | NULL | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| Rgg9EFRORbWMTBsId5RLIA | NULL | 대한인국민회 하와이지방총회 회관，밀러 스트릿(19너-1949) Hecidquarters of Kook Min Hur at Miller St. | 대한인국민회 하와이지방총회 회관, 밀러 스트릿 | NULL | media/roberta-jang/original/BF507wHG7zVH0XPe9Hph.jpeg | NULL | media/roberta-jang/thumbs/BF507wHG7zVH0XPe9Hph.jpeg | media/roberta-jang/thumbs/BF507wHG7zVH0XPe9Hph.jpeg | NULL | 2025-07-08 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | 1914-07-08 00:00:00 | NULL | NULL | 그들의 발자취 | 73 | 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/BF507wHG7z | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| rdP4ZR9Zq9DerxW6qfV3 | 사진 | Farmers cutting rice in a field | NULL | Farmers cutting rice in a field | media/jungnamyong/original/rdP4ZR9Zq9DerxW6qfV3.jpg | NULL | media/jungnamyong/thumbs/rdP4ZR9Zq9DerxW6qfV3.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_76_Farmers cutting rice 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 |
| RcwuEzr3Q4aMkhiFYJoi1A | 사진 | 리처드 '반조 킹' 최(Richard'Banjo King' Choi), 강영각(Donald Young Gak Kang), 월터 정(Walter Jhung). 1930년대. Brys | 리처드 '반조 킹' 최, 강영각, 월터 정, Bryson Jhung | NULL | media/roberta-jang/original/3aFI4duv4UZOwskcSr4b.jpg | NULL | media/roberta-jang/thumbs/3aFI4duv4UZOwskcSr4b.jpg | media/roberta-jang/thumbs/3aFI4duv4UZOwskcSr4b.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/3aFI4duv4U | 1930 | 1930년대 | NULL | 4 | 0 | 1 | NULL |
| RC.NH-TSSKaHm7Y-g3-iJA | 사진 | 시베리아호. 오성진(Chris Sung Jin Oh) 컬렉션, 하와이주 사료보관소. | 오성진(Chris Sung Jin Oh) | NULL | media/roberta-jang/original/AyypKzbUX6cDBz1aicZ7.jpg | NULL | media/roberta-jang/thumbs/AyypKzbUX6cDBz1aicZ7.jpg | media/roberta-jang/thumbs/AyypKzbUX6cDBz1aicZ7.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/AyypKzbUX6 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| rA390YdKeaktDeee6cnJ | 사진 | Two men, threshing rice with a pedal thresher | NULL | Two men, threshing rice with a pedal thresher_ | media/jungnamyong/original/rA390YdKeaktDeee6cnJ.jpg | NULL | media/jungnamyong/thumbs/rA390YdKeaktDeee6cnJ.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_33_Two men, threshing rice with a pedal thresher_.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 |
| r4J12q8KQvWLasQaHv00gw | NULL | 영남부인회 (Korean Young Nam Women’s Society) 영남부인회 (연도미상) The Korean Young Nam Women’s Society (Date Unk | 영남부인회 | NULL | media/roberta-jang/original/dSMT555aQPlW5Qcl5aB8.jpg | NULL | media/roberta-jang/thumbs/dSMT555aQPlW5Qcl5aB8.jpg | media/roberta-jang/thumbs/dSMT555aQPlW5Qcl5aB8.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/nYLQ4bsUJj | NULL | 그들의 발자취 | 103 | 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/dSMT555aQP | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| r2tAz5MfGZE5x0ttbt1l | 사진 | NULL | NULL | NULL | media/salome-choehan/original/r2tAz5MfGZE5x0ttbt1l.jpg | NULL | media/salome-choehan/thumbs/r2tAz5MfGZE5x0ttbt1l.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_H100-D_Waipio - JOEL PAHK.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 |
| r2Ru.fq1SgOiVkZoTpFpUw | 사진 | 시베리아 최와 박진한(Jin Han Park) 결혼식. Sung Ok과 Maria Cho Choi의 딸인 시베리아는 1904년 시베리아호 선상에서 태어났다. 1922년. 클래런스 | 시베리아 최, 박진한, Sung Ok, Maria Cho Choi, 클래런스 최. | NULL | media/roberta-jang/original/dbBMQUIwwMITI6oRF2Qr.jpg | NULL | media/roberta-jang/thumbs/dbBMQUIwwMITI6oRF2Qr.jpg | media/roberta-jang/thumbs/dbBMQUIwwMITI6oRF2Qr.jpg | 최성옥시베리아 최 | 2025-07-11 00:00:00 | 최성옥 | 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/dbBMQUIwwM | 1904 | NULL | NULL | 5 | 0 | 0 | NULL |