컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HbpajEGcS7G4cD1QYDnJzg | NULL | 꿈에 그리던 고국에서 (1923) In the Motherland | 고국 | NULL | media/roberta-jang/original/PVe1S61qNzBt17bC0jou.jpg | NULL | media/roberta-jang/thumbs/PVe1S61qNzBt17bC0jou.jpg | media/roberta-jang/thumbs/PVe1S61qNzBt17bC0jou.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 197 | 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/PVe1S61qNz | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| Ha2skBc93kmM9bqV0KIr | 사진 | NULL | At Incheon | At Incheon harbor - A woman leaning against a car, in front of a building.1945 | media/jungnamyong/original/Ha2skBc93kmM9bqV0KIr.jpg | NULL | media/jungnamyong/thumbs/Ha2skBc93kmM9bqV0KIr.jpg | NULL | NULL | NULL | Incheon | NULL | NULL | #1_2_At Incheon harbor - A woman leaning against a car, in front of a building.1945.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 |
| H0yiMfkASmWQw-dsjsDOaQ | 사진 | 국민회 본부 개관 기념식의 연단. 1915년. 천안 독립기념관 컬렉션. | 국민회 | NULL | media/roberta-jang/original/EqNskapz7ZLK7DrUzCZy.jpg | NULL | media/roberta-jang/thumbs/EqNskapz7ZLK7DrUzCZy.jpg | media/roberta-jang/thumbs/EqNskapz7ZLK7DrUzCZy.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:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/EqNskapz7Z | 1915 | NULL | NULL | 1 | 0 | 0 | NULL |
| GYugwjlnQ7GXPWcQi21cUw | NULL | 호항(호놀룰루) 한인기독교회 임원일동(1938) Honolulu Korean Christian Church board members | 호항(호놀룰루) 한인기독교회 임원일동 | NULL | media/roberta-jang/original/vHl1O9sqEVt0aUBES5Gi.jpg | NULL | media/roberta-jang/thumbs/vHl1O9sqEVt0aUBES5Gi.jpg | media/roberta-jang/thumbs/vHl1O9sqEVt0aUBES5Gi.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 162 | 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/vHl1O9sqEV | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| GYT2fAHdS7yqKeLNku-MGA | NULL | 살로메 한 여사와 한인양로원 노인들 Mrs. Salome Choi Han and the seniors in Korean Care Home 一 Mrs Salome Choi Han C | 살로메 한 Mrs. Salome Choi Han | NULL | media/roberta-jang/original/cFfelew1kmU1tgp7wSDE.jpg | NULL | media/roberta-jang/thumbs/cFfelew1kmU1tgp7wSDE.jpg | media/roberta-jang/thumbs/cFfelew1kmU1tgp7wSDE.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 165 | 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/cFfelew1km | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| gxCUAw6NSuyKi8J2qqoVow | NULL | 한국에서 중학교 과정을 마치고(1912, 16세) Photo taken with first graduation classmates in Korea. Yun Hee Chun Give | 윤희춘 | NULL | media/roberta-jang/original/KwhV5MWdOdfUsPhb64cX.jpg | NULL | media/roberta-jang/thumbs/KwhV5MWdOdfUsPhb64cX.jpg | media/roberta-jang/thumbs/KwhV5MWdOdfUsPhb64cX.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/KwhV5MWdOd | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| gxA6Yfpnvu3uWgQkERgu | 사진 | Soy beans on a farm | NULL | Soy beans on a farm_ | media/jungnamyong/original/gxA6Yfpnvu3uWgQkERgu.jpg | NULL | media/jungnamyong/thumbs/gxA6Yfpnvu3uWgQkERgu.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_43_Soy beans on a farm_.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 |
| GX-aYyagRV2G5E9nGExjIA | NULL | 한인중앙학원 첫 졸업생 기념사진, 펀치볼 스트릿 한인존 (1912: The first Korean graduates, 6th grade, from Korean Central Ins | 김잔제 (Chan Jay Kim), 김개봉 (Gay Bong Kim), 박관두 (Kwan Doo Park), 김성현 (Sung Hyun Kim), 양유찬 (You Chan Yang | NULL | media/roberta-jang/original/CGsvldzF9pxvmpSbNz5F.jpg | NULL | media/roberta-jang/thumbs/CGsvldzF9pxvmpSbNz5F.jpg | media/roberta-jang/thumbs/CGsvldzF9pxvmpSbNz5F.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/gbXnYQq4Cc | NULL | 그들의 발자취 | 171 | 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/CGsvldzF9p | NULL | NULL | NULL | 6 | 0 | 0 | NULL |
| GW8p.BxUQ5eYujFJ1rJk8g | NULL | 사진신랑이 한국의 신부감에게 보낸 사진(竹以) Exchange Photo of Picture Groom | 사진신랑, 신부감, 竹以 | NULL | media/roberta-jang/original/7pGmWowc0iOiBSIuNZtO.jpg | NULL | media/roberta-jang/thumbs/7pGmWowc0iOiBSIuNZtO.jpg | media/roberta-jang/thumbs/7pGmWowc0iOiBSIuNZtO.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/HOuennGrWV | NULL | 그들의 발자취 | 50 | Mrs. Rachel 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/7pGmWowc0i | NULL | NULL | NULL | 3 | 0 | 0 | NULL |
| GVPH3v.NSiyFQNvhMTndJw | 사진 | 이덕조(Durk Cho Lee)와 그의 아내. 1916년경. 앨버트 리(Albert Lee) 앨범. | 이덕조, 앨버트 리 | NULL | media/roberta-jang/original/3r8MFcsXRsKAHjmDkV2r.jpg | NULL | media/roberta-jang/thumbs/3r8MFcsXRsKAHjmDkV2r.jpg | media/roberta-jang/thumbs/3r8MFcsXRsKAHjmDkV2r.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/3r8MFcsXRs | 1916 | NULL | 1916년경 | 2 | 0 | 0 | NULL |
| gv1.w7YLS2uHVHf0EQdAqQ | 사진 | 사진 신부들. 김수연(Soo Yun Kim, 맨 왼쪽)과 이남수(Nam Soo Lee,맨 오른쪽). 1922년경. 윌리 리(Willie Lee) 앨범. | 김수연, 이남수, 윌리 리 | NULL | media/roberta-jang/original/F2bpJg89Q3cVEnFc1EfI.jpg | NULL | media/roberta-jang/thumbs/F2bpJg89Q3cVEnFc1EfI.jpg | media/roberta-jang/thumbs/F2bpJg89Q3cVEnFc1EfI.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/F2bpJg89Q3 | 1922 | NULL | 1922년경 | 3 | 1 | 0 | NULL |
| guhWO9CvYLaqNW62Rpud | 사진 | Seoul a man wearing a coat at a station | NULL | Seoul a man wearing a coat at a station | media/jungnamyong/original/guhWO9CvYLaqNW62Rpud.jpg | 1945 | media/jungnamyong/thumbs/guhWO9CvYLaqNW62Rpud.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #5_98_Seoul a man wearing a coat at a station_1945.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 |
| gtWvKNLJSduyz5.6xwSLdg | NULL | 펀치볼 지방회원 및 회비 납부현황 Membership fee book | 펀치볼 | NULL | media/roberta-jang/original/WEKgaIpm5Tj1ic0Rpeqt.jpg | NULL | media/roberta-jang/thumbs/WEKgaIpm5Tj1ic0Rpeqt.jpg | media/roberta-jang/thumbs/WEKgaIpm5Tj1ic0Rpeqt.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/OADtpSH3F8 | NULL | 그들의 발자취 | 72 | irideoendence Ho'l 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/WEKgaIpm5T | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| GTqHuhyvAsTMVfuZAFY8 | 사진 | NULL | NULL | An ox in a farm house - in front of mom's house_ | media/jungnamyong/original/GTqHuhyvAsTMVfuZAFY8.jpg | NULL | media/jungnamyong/thumbs/GTqHuhyvAsTMVfuZAFY8.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_38_An ox in a farm house - in front of mom's house_.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 |
| gQ9GUlNBLIMNVrZt5kUv | 사진 | NULL | NULL | NULL | media/salome-choehan/original/gQ9GUlNBLIMNVrZt5kUv.jpg | NULL | media/salome-choehan/thumbs/gQ9GUlNBLIMNVrZt5kUv.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00005.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 |
| go6FLyrJRDODXpZZpW1geg | 사진 | 와이파후에서 모쿨레이아로 가는 오하후(O'ahu) 철도 여객열차. | 모쿨레이아 | NULL | media/roberta-jang/original/fvlQbGre9J6XIjPHU0QG.jpg | NULL | media/roberta-jang/thumbs/fvlQbGre9J6XIjPHU0QG.jpg | media/roberta-jang/thumbs/fvlQbGre9J6XIjPHU0QG.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/fvlQbGre9J | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| GNzqFeAgRI6Mp3a.OqaxEA | NULL | 마우이 하나 한인감리교회 (1915) Korean MeThodist Church, Hana, Maul | 마우이 하나 한인감리교회 | NULL | media/roberta-jang/original/UrJuhf4d1eYSdelwbQWk.JPG | NULL | media/roberta-jang/thumbs/UrJuhf4d1eYSdelwbQWk.JPG | media/roberta-jang/thumbs/UrJuhf4d1eYSdelwbQWk.JPG | NULL | 2025-07-08 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 137 | Bishop Museum | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/UrJuhf4d1e | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| GLEAdtUSQSqMouIPpJDiYg | NULL | 이승만 박사가 설립하여 남녀공학으로 학제를 갖춘 한인기독학원, 와이알라에 알리이오라니 스쿨시대 (1918 —1921) 왼쪽에서 4번째 흰색양복을 입은 이가 교장 이승만. 건물 1충 | 이승만 | NULL | media/roberta-jang/original/HfgbedG2OkNe3xIS40UJ.jpg | NULL | media/roberta-jang/thumbs/HfgbedG2OkNe3xIS40UJ.jpg | media/roberta-jang/thumbs/HfgbedG2OkNe3xIS40UJ.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/QUHg4R45rE | NULL | 그들의 발자취 | 173 | 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/HfgbedG2Ok | NULL | NULL | NULL | 1 | 0 | 1 | NULL |
| gjQvt1AcRUqpviFuB1l8uQ | 사진 | 사진신부이야기 헤이즐 정 | 헤이즐 정 | NULL | media/roberta-jang/original/lyWud6eC5PfwLUzqC9IG.jpg | NULL | media/roberta-jang/thumbs/lyWud6eC5PfwLUzqC9IG.jpg | media/roberta-jang/thumbs/lyWud6eC5PfwLUzqC9IG.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 32 | Hazel Chung 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/lyWud6eC5P | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| GjooIB.5RC-lAsNE8aoUIg | NULL | 초기 한인감리교회 주일학교 교사(연도미상) Korean Methodist Church School Teachers (Date Unknown) | 한인감리교회 주일학교 교사 | NULL | media/roberta-jang/original/VCp4gvXeNdh7caASBI4l.jpg | NULL | media/roberta-jang/thumbs/VCp4gvXeNdh7caASBI4l.jpg | media/roberta-jang/thumbs/VCp4gvXeNdh7caASBI4l.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 119 | 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/VCp4gvXeNd | NULL | NULL | NULL | 1 | 0 | 0 | NULL |