컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8l4AXYgsSuelsPkwlgvMWg | 사진 | 강영각(Donald Young Gak Kang, 오른쪽 끝에 서 있는 사람), 안창호(Chang Ho Ahn) 목사(오른쪽에서 두번째, 서 있는 사람), 정기화(Charles Ki | 강영각, 안창호, 정기화 | NULL | media/roberta-jang/original/15DcJGypz27hsKRN4CGk.jpg | NULL | media/roberta-jang/thumbs/15DcJGypz27hsKRN4CGk.jpg | media/roberta-jang/thumbs/15DcJGypz27hsKRN4CGk.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/15DcJGypz2 | 1930 | NULL | NULL | 3 | 0 | 1 | NULL |
| 8J6dHFg50GKUbkqU0DO5 | 사진 | A crowd of people | NULL | Seoul - A crowd of people | media/jungnamyong/original/8J6dHFg50GKUbkqU0DO5.jpg | NULL | media/jungnamyong/thumbs/8J6dHFg50GKUbkqU0DO5.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #1_9_Seoul - A crowd of 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 |
| 8dLOsInIRVJZe7GLH79e | 사진 | Railroads and a train | NULL | Taejon-Railroads and a train | media/jungnamyong/original/8dLOsInIRVJZe7GLH79e.jpg | NULL | media/jungnamyong/thumbs/8dLOsInIRVJZe7GLH79e.jpg | NULL | NULL | NULL | Taejon | NULL | NULL | #1_12_Taejon-Railroads and a train.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 |
| 8btgweCjTKi9r-yDzby17A | 사진 | 윌라(Wihla (Chung))와 도라 김 문. 1915년경. 민병용 컬렉션. | 윌라, 도라 김, 민병용 | 도라 김 문은 감리교회의 도움으로 딸, 윌라와 함께 왔다. 어머니와 딸 모두 선교 사업에 전념하였다. | media/roberta-jang/original/jERwlhopH9IGfjYMU7ZZ.jpg | NULL | media/roberta-jang/thumbs/jERwlhopH9IGfjYMU7ZZ.jpg | media/roberta-jang/thumbs/jERwlhopH9IGfjYMU7ZZ.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/jERwlhopH9 | 1915 | NULL | 1915년경 | 3 | 0 | 0 | NULL |
| 8BDJxN5AToW4KEywHKCwdQ | 사진 | 홍치범(Chi Pum Hong)과 애굔 김 홍(Agyon Kim Hong). 1910년대경. 천안 독립기념관 컬렉션. | 홍치범, 애굔 김 홍 | NULL | media/roberta-jang/original/DNMMirBQa7IuyUPwgFot.jpg | NULL | media/roberta-jang/thumbs/DNMMirBQa7IuyUPwgFot.jpg | media/roberta-jang/thumbs/DNMMirBQa7IuyUPwgFot.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/DNMMirBQa7 | 1910 | 1910년대 | NULL | 2 | 1 | 1 | NULL |
| 8aMopkKaSJSj86H-x9fMaQ | NULL | 백일잔치, 바쁜 이민생활중에도 자녀를 위한 가족의 전통은 잊지 않았다. 성공회(1936년경) Celebration of a Hundred Day Old Baby at St. Luk | 백일잔치 | NULL | media/roberta-jang/original/iHJXZHN9n1NfFJ8Gph3c.jpg | NULL | media/roberta-jang/thumbs/iHJXZHN9n1NfFJ8Gph3c.jpg | media/roberta-jang/thumbs/iHJXZHN9n1NfFJ8Gph3c.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 44 | Dr. Jackie Young Collection | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/iHJXZHN9n1 | 1936 | NULL | 1936년경 | 1 | 0 | 0 | NULL |
| 8ajsKPgbQL6Dw3pZlA4BTw | 사진 | 성 비오 10세 한인 가톨릭교회. 왼쪽부터, 안나 조(Anna Cho), 디콘 에드워드 조(Deacon Edward Cho), 세실리아 노(Cecilia Noh), 존 솔티스(Jo | 안나 조, 디콘 에드워드 조, 세실리아 노, 존 솔티스, 해리 황, 루시아 김 | NULL | media/roberta-jang/original/F86JPF4ikmSbXeA09KCE.jpg | NULL | media/roberta-jang/thumbs/F86JPF4ikmSbXeA09KCE.jpg | media/roberta-jang/thumbs/F86JPF4ikmSbXeA09KCE.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:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/F86JPF4ikm | 2002 | NULL | NULL | 6 | 0 | 0 | NULL |
| 8AjeSLGaDGQRUpGsvv3L | 사진 | 6 people 3 women and 3 men | NULL | 6 people 3 women and 3 men | media/jungnamyong/original/8AjeSLGaDGQRUpGsvv3L.jpg | NULL | media/jungnamyong/thumbs/8AjeSLGaDGQRUpGsvv3L.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #6_119_6 people 3 women and 3 men.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 |
| 89HYmZPmQEe6Ex1.ju7Bkg | 사진 | 하와이 100주년 기념식의 진행요원들. 왼쪽부터, Yusan Corwin, Chong Sun Scott. 2002년 4월 13일. Tad Tamura 사진. | Yusan Corwin, Chong Sun Scott | NULL | media/roberta-jang/original/M13hKCPHNI2w8Vwtsb6Y.jpg | NULL | media/roberta-jang/thumbs/M13hKCPHNI2w8Vwtsb6Y.jpg | media/roberta-jang/thumbs/M13hKCPHNI2w8Vwtsb6Y.jpg | 호레이스 알렌 박사 | 2025-04-19 00:00:00 | NULL | NULL | NULL | NULL | 호레이스 알렌 박사 | NULL | 2002-04-13 00:00:00 | 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/M13hKCPHNI | 2002 | NULL | NULL | 2 | 0 | 0 | NULL |
| 84k5RxteSve1AfAcDHLEjw | 사진 | 힐로의 한인기념묘지. 1998년경. 『 코리아타임스』. | 한인기념묘지 | NULL | media/roberta-jang/original/epAlM0wv9GC7RsfQEhiX.jpg | NULL | media/roberta-jang/thumbs/epAlM0wv9GC7RsfQEhiX.jpg | media/roberta-jang/thumbs/epAlM0wv9GC7RsfQEhiX.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/epAlM0wv9G | 1998 | NULL | 1998년경 | 1 | 0 | 0 | NULL |
| 7ZkWy6EsaqkoXGoSOFed | 사진 | A persimmon tree | NULL | A persimmon tree_ | media/jungnamyong/original/7ZkWy6EsaqkoXGoSOFed.jpg | NULL | media/jungnamyong/thumbs/7ZkWy6EsaqkoXGoSOFed.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_42_A persimmon tree_.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 |
| 7YUFMBR7RkmlkpfOEDfIqw | 사진 | 도산 안창호(앉아 있는 사람)와 정원명(Won Myung Chung). 날짜 미상. 안수산(Susan Ahn Cuddy) 앨범. | 도산 안창호, 정원명, 안수산 | NULL | media/roberta-jang/original/1QnMKRn6DzYTMbEDgLBu.jpg | NULL | media/roberta-jang/thumbs/1QnMKRn6DzYTMbEDgLBu.jpg | media/roberta-jang/thumbs/1QnMKRn6DzYTMbEDgLBu.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/1QnMKRn6Dz | NULL | NULL | NULL | 3 | 1 | 1 | NULL |
| 7x5nHJyoQgKDytdwhuskYg | 사진 | 양홍엽(Hung Yup)과 수잔나 곽 양(Susannah Kwak Yang) 가족. | 양홍엽, 수잔나 곽 양 | 앞줄 왼쪽부터, 엘렌(Ellen), 에드나(Edna), 수잔나 곽, 엘라(Ella), 양홍엽, 엘시(Elsie), 뒷줄 왼쪽부터, 제이 나단(Jay Nathan), 경나(Ada K | media/roberta-jang/original/Tg84IEbyF4FMHxR2YnOE.jpg | NULL | media/roberta-jang/thumbs/Tg84IEbyF4FMHxR2YnOE.jpg | media/roberta-jang/thumbs/Tg84IEbyF4FMHxR2YnOE.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/Tg84IEbyF4 | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| 7x2jXgVVS3eqcC6FIn4vVQ | NULL | 국민회 본부앞에서 (1921) 대한부인구제회는 1919년 4월 1일 조국에서 3.1 만세운동이 발생하자 조국광복운동을 조직적으로 후원하고 구제활동을 강화하기 위해 설립되었다. Th | 대한부인구제회 | NULL | media/roberta-jang/original/t3WUqUauC0Woy2Husiuz.jpg | NULL | media/roberta-jang/thumbs/t3WUqUauC0Woy2Husiuz.jpg | media/roberta-jang/thumbs/t3WUqUauC0Woy2Husiuz.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/o6cXFw7Br3 | NULL | 그들의 발자취 | 91 | Bishop Museum | 2025-09-14 05:59:58 | 2025-12-06 11:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/t3WUqUauC0 | 1921 | NULL | NULL | 1 | 0 | 0 | NULL |
| 7UaDunj.Rxar6gOHF5V-ug | NULL | 이승만 박사와 청년들 Dr. Syngman Rhee and Young people | 이승만, Syngman Rhee | NULL | media/roberta-jang/original/YfmWpu0GiU3w0OtxfErb.jpg | NULL | media/roberta-jang/thumbs/YfmWpu0GiU3w0OtxfErb.jpg | media/roberta-jang/thumbs/YfmWpu0GiU3w0OtxfErb.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/CfFi4xN5sL | NULL | 그들의 발자취 | 81 | Mr, Young Ok Kang 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/YfmWpu0GiU | NULL | NULL | NULL | 2 | 0 | 1 | NULL |
| 7Rfmn5ArRam4gqdSI9mfVg | 사진 | 이남수(Nam Soo Lee, 사진 신부)와 이동선(Dong Sun Lee)이 결혼 25주년을 기념하고 있다. 1947년. Willie Lee 앨범. | 이남수, 이동선, Willie Lee | NULL | media/roberta-jang/original/fxf5MkKjwTK90vxpGp2S.jpg | NULL | media/roberta-jang/thumbs/fxf5MkKjwTK90vxpGp2S.jpg | media/roberta-jang/thumbs/fxf5MkKjwTK90vxpGp2S.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/fxf5MkKjwT | 1947 | NULL | NULL | 3 | 1 | 0 | NULL |
| 7NLhPyeJQ1qjncxY8tAaWQ | 사진 | 한경선과 한한나(Hannah) 가족. | 한경선, 한한나 | 왼쪽부터, 스텔라(Stella), 한나, 존(John ,뒤), 리처드(Richard ,앞), 그레이스(Grace), 로버트(Robert,뒤), 경선, 엘리노어(Eleanor), 이 | media/roberta-jang/original/XKUOqQPUeTQxc7HWKIcA.jpg | NULL | media/roberta-jang/thumbs/XKUOqQPUeTQxc7HWKIcA.jpg | media/roberta-jang/thumbs/XKUOqQPUeTQxc7HWKIcA.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/XKUOqQPUeT | NULL | NULL | NULL | 2 | 1 | 1 | NULL |
| 7koPtdp3T-iT2jnsQMHp0w | NULL | 속지 | 속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 60 | NULL | 2025-09-14 05:59:58 | 2026-01-19 08:25:19 | NULL | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| 7KESXfswQE-0HUbVgzGEbw | 사진 | 필라델피아 독립선언 시가행진. 1919년. 민병용 컬렉션. | 민병용 | NULL | media/roberta-jang/original/f26X8VtQQm8zy8fQVAap.jpg | NULL | media/roberta-jang/thumbs/f26X8VtQQm8zy8fQVAap.jpg | media/roberta-jang/thumbs/f26X8VtQQm8zy8fQVAap.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/f26X8VtQQm | 1919 | NULL | NULL | 1 | 0 | 0 | NULL |
| 7HRpunEGRYKJF9dmgQluAQ | NULL | 그리스도연합감리교회 주일학교 (19<50년대) Christ United M삼hodist Church Sunday School (Circa I960) | 그리스도연합감리교회 | NULL | media/roberta-jang/original/ABntC63nfsuNfzcYW7iq.jpg | NULL | media/roberta-jang/thumbs/ABntC63nfsuNfzcYW7iq.jpg | media/roberta-jang/thumbs/ABntC63nfsuNfzcYW7iq.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 125 | Dr. Won Sik You 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/ABntC63nfs | NULL | NULL | NULL | 1 | 0 | 0 | NULL |