컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| jDOvKJ5PS4Wul1feH1ZoRA | 사진 | 윤병구(Peong Koo Yoon) 목사. 1920년대경. Susan E. Yoon McDavid 컬렉션. | 윤병구 | NULL | media/roberta-jang/original/gs85GFU3Uop6ql2Rp2kE.jpg | NULL | media/roberta-jang/thumbs/gs85GFU3Uop6ql2Rp2kE.jpg | media/roberta-jang/thumbs/gs85GFU3Uop6ql2Rp2kE.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/gs85GFU3Uo | 1920 | 1920년대 | NULL | 1 | 0 | 0 | NULL |
| JCriLRmECNxLE1ViGzS7 | 사진 | Seoul unloading firewood | NULL | Seoul unloading firewood | media/jungnamyong/original/JCriLRmECNxLE1ViGzS7.jpg | 1945 | media/jungnamyong/thumbs/JCriLRmECNxLE1ViGzS7.jpg | NULL | NULL | NULL | Seoul | NULL | NULL | #2_27_Seoul unloading firewood_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 |
| jAyFi9OZTJm0yAez2PF4dg | 사진 | 이승만이 이웃 섬에서 호놀롤루로 데려온 소녀들. 1914년경. 메리 홍 박(Mary Hong Park) 앨범. | 이승만, 메리 홍 박 | NULL | media/roberta-jang/original/4ywXBGF7LtvhICPnyUcY.jpg | NULL | media/roberta-jang/thumbs/4ywXBGF7LtvhICPnyUcY.jpg | media/roberta-jang/thumbs/4ywXBGF7LtvhICPnyUcY.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/4ywXBGF7Lt | 1914 | NULL | 1914년경 | 2 | 0 | 1 | NULL |
| J8ua3dLjQ6qlbF3HGyglyQ | 사진 | 현재의 한인양로원을 방문한 젊은이들. 2001년. Martha Chung 사진. | Martha Chung | NULL | media/roberta-jang/original/74GFim0VqlEnOB6vFXr0.jpg | NULL | media/roberta-jang/thumbs/74GFim0VqlEnOB6vFXr0.jpg | media/roberta-jang/thumbs/74GFim0VqlEnOB6vFXr0.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/74GFim0Vql | 2001 | NULL | NULL | 1 | 0 | 0 | NULL |
| J6-EEtnuTyymemGzWHqoHA | 영상 | 푸우위키 묘지를 지키는 이민3세대 제리추 | 제리추 | 할아버지 추승수는 이민선 1세대,한의사 출신. 어머니는 중국계. 자신의 가계도를 추적해서 그려냄 | media/roberta-jang/original/XBPhhamJhRP0K2o89ps3.jpeg | NULL | media/roberta-jang/thumbs/XBPhhamJhRP0K2o89ps3.jpeg | media/roberta-jang/thumbs/XBPhhamJhRP0K2o89ps3.jpeg | 추승수 | 2025-03-09 00:00:00 | 추승수 | https://youtu.be/ikv63M00wrI?si=vd39VSHHUvp0Yzdz | 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/XBPhhamJhR | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| j5iVq6zjSv6VgqcNCSsF7A | 사진 | 정양필은 네브래스카주의 한인소년병학교(Young Korean Military School)에 입교하였다. 왼쪽에서 첫번째가 홍승국(Seung Kook Hong), 여섯 번째가 이관 | 정양필, 홍승국, 이관수 | NULL | media/roberta-jang/original/h9ZFpXjx0Xkui27Q1n15.jpg | NULL | media/roberta-jang/thumbs/h9ZFpXjx0Xkui27Q1n15.jpg | media/roberta-jang/thumbs/h9ZFpXjx0Xkui27Q1n15.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/h9ZFpXjx0X | 1910 | NULL | 1910년경 | 3 | 1 | 0 | NULL |
| J.Yccv.AR9aU33LiwKo-4A | 사진 | 이승만과 프란체스카가 하와이로 돌아왔다. 『호놀롤루 애드버타이저 』 1960년 5월 29-29일자. | 이승만, 프란체스카 | NULL | media/roberta-jang/original/vvFJUdJ5c6UFYNIVfvRD.jpg | NULL | media/roberta-jang/thumbs/vvFJUdJ5c6UFYNIVfvRD.jpg | media/roberta-jang/thumbs/vvFJUdJ5c6UFYNIVfvRD.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:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/vvFJUdJ5c6 | 1960 | NULL | NULL | 2 | 0 | 1 | NULL |
| j-f1igNLQ3q4qd2M-Gkvmw | 사진 | 이태성(서 있는 사람)과 릴리 박(Lily Pahk Lee, 이태성 왼쪽에 앉아 있는 사람). 한국. 1932년경. Paula Kim Tadaki 앨범. | 이태성, 릴리 박 (Lily Pahk Lee) | NULL | media/roberta-jang/original/2e8Ubv8YBcxa1Og1gPfR.jpg | NULL | media/roberta-jang/thumbs/2e8Ubv8YBcxa1Og1gPfR.jpg | media/roberta-jang/thumbs/2e8Ubv8YBcxa1Og1gPfR.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/2e8Ubv8YBc | 1932 | NULL | 1932년경 | 2 | 0 | 1 | NULL |
| IzWxXoR.Q9GDn.lacW7n9Q | 사진 | 왼쪽부터, 안현경(Hyun Kyun Ahn), 도산 안창호, 홍한식 목사. 1915년. 안수산(Susan Ahn Cuddy) 앨범. 1915년 대립하는 두 파벌 모두 도산 안 | 안현경, 도산 안창호, 홍한식, 안수산 | NULL | media/roberta-jang/original/zhLtsz22EoHg3hn5HUwt.jpg | NULL | media/roberta-jang/thumbs/zhLtsz22EoHg3hn5HUwt.jpg | media/roberta-jang/thumbs/zhLtsz22EoHg3hn5HUwt.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/zhLtsz22Eo | 1915 | NULL | NULL | 4 | 1 | 1 | NULL |
| IYBFjqXOQn65s9X4a69FMA | NULL | 함호영씨 권사면허증 License for church work as exhorter | 함호영 | NULL | media/roberta-jang/original/3UknrpPznZDH3P4hPrsS.jpg | NULL | media/roberta-jang/thumbs/3UknrpPznZDH3P4hPrsS.jpg | media/roberta-jang/thumbs/3UknrpPznZDH3P4hPrsS.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 193 | 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/3UknrpPznZ | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| ixoUfgVuSIatF3x-7T6A6A | 사진 | 자유의 투사들. 앞쪽 오른쪽에서 두 번째 유동면(Dong Men You), 오른쪽에서 세 번째 안원규(Won Kiu Ahn), 뒷줄 오른쪽에서 세 번째 이호직(Ho Chik Lee | 유동면, 안원규, 이호직, 정두옥, 정남용 | NULL | media/roberta-jang/original/trUOtxYBNDyFjmmWB9GD.jpg | NULL | media/roberta-jang/thumbs/trUOtxYBNDyFjmmWB9GD.jpg | media/roberta-jang/thumbs/trUOtxYBNDyFjmmWB9GD.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-31 23:25:12 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/trUOtxYBND | 1908 | NULL | 1908년경 | 5 | 1 | 1 | NULL |
| IWA0fzKqT9-17PAe4ljAxw | NULL | 대한부인구제회(1952) Korean Women;s Relief Society -Mr. Donald Kim Collection | 대한부인구제회 (Korean Women's Relief Society) - Mr. Donald Kim | NULL | media/roberta-jang/original/VqzFpsK0fajDKQo2Z7AI.jpg | NULL | media/roberta-jang/thumbs/VqzFpsK0fajDKQo2Z7AI.jpg | media/roberta-jang/thumbs/VqzFpsK0fajDKQo2Z7AI.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 101 | 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/VqzFpsK0fa | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| IUbv8dEwTP-zOqeat24i-g | NULL | 고종황제 탄신 기념행사, 에바농장(1907) Emperor Kojong’s birthday celebration, Ewa Plantation | 고종황제, 에바농장 | NULL | media/roberta-jang/original/GIqe5Qqkc4zKyBAA9Ywg.jpg | NULL | media/roberta-jang/thumbs/GIqe5Qqkc4zKyBAA9Ywg.jpg | media/roberta-jang/thumbs/GIqe5Qqkc4zKyBAA9Ywg.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 41 | Mr. Young Ok Kang 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/GIqe5Qqkc4 | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| iu7c7hT-QFiu.tZP2Wu8PA | 사진 | 동지회의 임원들. 교민단이 해체된 직후 1930년에 동지회가 공식적으로 결성되었다. 왼쪽부터, 황원태(Won Tai Whang), 최성대(Sungdai Choi), 김학성(Hark | 황원태, 최성대, 김학성, 김유실, 김영기, 이승만, 강영복, 양유찬, 노디 김해김 손, 이원순, 전영복, 서기문 | NULL | media/roberta-jang/original/pTz4eCIstfILP57ezZic.jpg | NULL | media/roberta-jang/thumbs/pTz4eCIstfILP57ezZic.jpg | media/roberta-jang/thumbs/pTz4eCIstfILP57ezZic.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 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/pTz4eCIstf | 1930 | NULL | 1930년경 | 12 | 1 | 1 | NULL |
| IRh6nsFWTnWKJzpsbkHQYg | NULL | 동안클럽 (Dong Ahn Club) 동안클럽, 목쿨레아 수잔나 웨슬리 용에서 창립 5주년 기념식 (1932) Dong Ahn Club gathered at Mokuleia, Oa | 동안클럽 (Dong Ahn Club) | NULL | media/roberta-jang/original/nCwnZqfCKbb7oImUMfnP.jpg | NULL | media/roberta-jang/thumbs/nCwnZqfCKbb7oImUMfnP.jpg | media/roberta-jang/thumbs/nCwnZqfCKbb7oImUMfnP.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 104 | Alexander and Baldwin Inc 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/nCwnZqfCKb | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| iqTgHHb9Q-KHhp3JsmwIXg | 사진 | 아이네즈 공(Inez Kon(Pai)), 안숙진(Sook Chin Ahn Kong, 어머니), 존 공(John Kong). 금강산. 1935년. 아이네즈 공 배 앨범. | 아이네즈 공, 안숙진, 존 공 | NULL | media/roberta-jang/original/I8JLIuWokEG7EDWJJsFn.jpg | NULL | media/roberta-jang/thumbs/I8JLIuWokEG7EDWJJsFn.jpg | media/roberta-jang/thumbs/I8JLIuWokEG7EDWJJsFn.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/I8JLIuWokE | 1935 | NULL | NULL | 3 | 0 | 0 | NULL |
| ipPHPPxKLONzvVsesfGb | 사진 | NULL | Capital Building | In front of the Capital Building - A man riding a bike,and a car | media/jungnamyong/original/ipPHPPxKLONzvVsesfGb.jpg | 1945 | media/jungnamyong/thumbs/ipPHPPxKLONzvVsesfGb.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #1_3_In front of the Capital Building - A man riding a bike,and a car_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 |
| IPFf6RbRQniLGJl30js.mw | NULL | 체육대회를 마치고(1912) Picture taken at Boys Field Kauluwela | 체육대회 | NULL | media/roberta-jang/original/JkWhdoBMHQ1W2QjQVT4d.jpg | NULL | media/roberta-jang/thumbs/JkWhdoBMHQ1W2QjQVT4d.jpg | media/roberta-jang/thumbs/JkWhdoBMHQ1W2QjQVT4d.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 182 | Mr. Young Ok Kang 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/JkWhdoBMHQ | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| iODRzsOgLC5hI7dqCXKE | 사진 | People stacking rice | NULL | People stacking rice | media/jungnamyong/original/iODRzsOgLC5hI7dqCXKE.jpg | NULL | media/jungnamyong/thumbs/iODRzsOgLC5hI7dqCXKE.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #5_95_People stacking rice.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 |
| InpvXG8oTSK13G69lTJUww | NULL | 김온진 사진신부의 검역증 (1915) Inspection Card 一 Mrs. On Chin Kim Hong | 김온진 | NULL | media/roberta-jang/original/sltuGTudVl4P0GwxlgQq.jpg | NULL | media/roberta-jang/thumbs/sltuGTudVl4P0GwxlgQq.jpg | media/roberta-jang/thumbs/sltuGTudVl4P0GwxlgQq.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/1GnBImyV6J | NULL | 그들의 발자취 | 59 | 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/sltuGTudVl | NULL | NULL | NULL | 1 | 0 | 0 | NULL |