컬럼 구조
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(10)
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)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| HYMZGx7aRb6ZrrbEsHANBg | 사진 | 1932년에 처음 발행된 동지회원증서(노희창). 아그네스 노 천 앨범. | 노희창, 아그네스 노 | NULL | media/roberta-jang/original/AWBkT46j8Tg5xGcJM8ej.jpg | NULL | media/roberta-jang/thumbs/AWBkT46j8Tg5xGcJM8ej.jpg | media/roberta-jang/thumbs/AWBkT46j8Tg5xGcJM8ej.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:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/AWBkT46j8T | 1932 | NULL | NULL | 2 | 0 | 0 |
| hYCIpA13T2Sy2smNhSSAOA | 사진 | 속지 | 속지 | NULL | NULL | NULL | glide:mesh,속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 35 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | NULL | NULL | NULL | NULL | 1 | 0 | 0 |
| HWLmNF1NQxaLUFLm9Nfw0g | 사진 | 한인 2세들의 시대. 『 한인학생연감(Korean Students' Annual.)』 결혼과 출산을 통해 한인사회에는 새로운 세대가 등장한다. 1938년. 줄리아 장 정(Julia | 줄리아 장 정(Julia Chang Chung) | NULL | media/roberta-jang/original/tlVYzxHotiHCSIROChCL.jpg | NULL | media/roberta-jang/thumbs/tlVYzxHotiHCSIROChCL.jpg | media/roberta-jang/thumbs/tlVYzxHotiHCSIROChCL.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:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/tlVYzxHoti | 1938 | NULL | NULL | 1 | 0 | 0 |
| hwA.CxyFSKemRRXbeWFn4Q | 사진 | 사진신부들에게 발급되었던 일제시대 여권(1918) Imperial Japanese Passport issued to Miss Soon Yon Kim | Miss Soon Yon Kim | NULL | media/roberta-jang/original/38HtQFzKLT3d6VwE4aLE.jpg | NULL | media/roberta-jang/thumbs/38HtQFzKLT3d6VwE4aLE.jpg | media/roberta-jang/thumbs/38HtQFzKLT3d6VwE4aLE.jpg | 김순연,김순년 | 2025-07-15 00:00:00 | 김순연,김순년 | NULL | NULL | NULL | NULL | NULL | NULL | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/9VTGnPACoJ | NULL | 그들의 발자취 | 29 | 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/38HtQFzKLT | NULL | NULL | NULL | 1 | 0 | 0 |
| HTU4fcXHTD6b2HQ5WPGKBg | 사진 | YMCA 한인 지부가 후원한 아버지와 아들을 위한 연회. 1920년경. 이태성 앨범. | 이태성 | NULL | media/roberta-jang/original/tDjt2yJLHgeTKL8lTNOR.jpg | NULL | media/roberta-jang/thumbs/tDjt2yJLHgeTKL8lTNOR.jpg | media/roberta-jang/thumbs/tDjt2yJLHgeTKL8lTNOR.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/tDjt2yJLHg | 1920 | NULL | 1920년경 | 1 | 0 | 1 |
| hsPJQkDZT6WixA957QNTaw | NULL | 카우아이 마카벨리 노동공립학교(연도미상) Kauai Makaweli Korean Public School (Date Unknown) | 카우아이 마카벨리 노동공립학교 | NULL | media/roberta-jang/original/2xirW3EhBC6CB2R2HVzU.jpg | NULL | media/roberta-jang/thumbs/2xirW3EhBC6CB2R2HVzU.jpg | media/roberta-jang/thumbs/2xirW3EhBC6CB2R2HVzU.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/WqlPckdyoj | NULL | 그들의 발자취 | 177 | 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/2xirW3EhBC | NULL | NULL | NULL | 1 | 0 | 0 |
| hRcdkEC8QUqaQivDJc2bdQ | 사진 | 국민회. 앞줄 왼쪽부터, 김상하(Sang Ha Kim), 회장 정원명(Won Myung Chung), 강영수(Yon Soo Kang), 뒷줄 왼쪽부터, 안원규(Won Kiu Ahn | 김상하, 정원명, 강영수, 안원규, 홍인표, 이내수, 승룡환, 정칠래, 민병용, 강영옥. | NULL | media/roberta-jang/original/zb88rmwnmlXcqxTpYRyl.jpg | NULL | media/roberta-jang/thumbs/zb88rmwnmlXcqxTpYRyl.jpg | media/roberta-jang/thumbs/zb88rmwnmlXcqxTpYRyl.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/zb88rmwnml | 1909 | NULL | NULL | 10 | 1 | 1 |
| hqnuvh43S.KLXuQZyKb2mw | NULL | 카피올라니공원 와이키키 셀 야외극장 개관기념공연에 참가한 한국민요대원 (1933) Korean Folk Song singing members at the Waikiki Shell | 1. Sook Cha Hong 2. Hee Kyong Kwon 3. Chung Song Ahn 4. Chum Soon Kim 5. Willa Chung 6. Do | NULL | media/roberta-jang/original/ICPRJVU1Yl26P5n6Rf2i.jpg | NULL | media/roberta-jang/thumbs/ICPRJVU1Yl26P5n6Rf2i.jpg | media/roberta-jang/thumbs/ICPRJVU1Yl26P5n6Rf2i.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 192 | 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/ICPRJVU1Yl | NULL | NULL | NULL | 9 | 0 | 0 |
| hNzg4WQDRziByiRVeswvQw | 사진 | 한국 전통의상을 입은 임관희(Kwan Hi Lim, 앞줄 중앙). 황혜수(Ha Soo Whang)가 준비한 '양반'을 묘사한 패션쇼가 YWCA에서 열렸다. 뒷줄 왼쪽에서 다섯 번 | 임관희, 황혜수, 천순호, 맥스 림 | NULL | media/roberta-jang/original/s91qzZO0H3q1Mq9ZHbRh.jpg | NULL | media/roberta-jang/thumbs/s91qzZO0H3q1Mq9ZHbRh.jpg | media/roberta-jang/thumbs/s91qzZO0H3q1Mq9ZHbRh.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/s91qzZO0H3 | 1953 | NULL | 1953년경 | 4 | 0 | 1 |
| hkOLq9rXRiimJgA.daXZ-A | 사진 | 염만석(Man Suk Yum). 샌프란시스코. 1918년경. 도라 염 김(Dora Yum Kim) 앨범. | 염만석, 도라 염 김 | NULL | media/roberta-jang/original/8P48Az03M11fm27MDuen.jpg | NULL | media/roberta-jang/thumbs/8P48Az03M11fm27MDuen.jpg | media/roberta-jang/thumbs/8P48Az03M11fm27MDuen.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/8P48Az03M1 | 1918 | NULL | 1918년경 | 2 | 0 | 0 |
| HjSWNf59QBauKg6OhXriAw | 사진 | 로희창 부부와 자녀들 금순, 옥순, 종선과 종헌(1920년경) Mr. & Mrs. Hee Chang(Young Hee Chee) Rho and children, Mrs. Flora | 로희창, 금순, 옥순, 종선, 종헌, Young Hee Chee Rho, Flora Kum Soon Park, Violet Ok Soon Cho, Chong Sun Rho, Cho | NULL | media/roberta-jang/original/8FMcMKDFAk8jcLPkLUn3.jpeg | NULL | media/roberta-jang/thumbs/8FMcMKDFAk8jcLPkLUn3.jpeg | media/roberta-jang/thumbs/8FMcMKDFAk8jcLPkLUn3.jpeg | 노희창,로희창 | 2025-07-10 00:00:00 | 노희창,로희창 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 24 | 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/8FMcMKDFAk | 1920 | NULL | 1920년경 | 11 | 0 | 0 |
| Hiqxm77fQR2AKhhFsw2jlQ | 사진 | 카와이아하오 여자학교의 한인 여학생들. 앞줄 중간 몰리 홍, 뒷줄 맨 오른쪽 애굔 김. 1908년. 민병용 컬렉션. | 몰리 홍, 애굔 김 | NULL | media/roberta-jang/original/QlkyQjrlhGNp1XAGjk8n.jpg | NULL | media/roberta-jang/thumbs/QlkyQjrlhGNp1XAGjk8n.jpg | media/roberta-jang/thumbs/QlkyQjrlhGNp1XAGjk8n.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:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/QlkyQjrlhG | 1908 | NULL | NULL | 2 | 0 | 0 |
| HGsBqgYNRHSWZVVRntoCSw | 사진 | 조미구락부 회원들. 1935년. 메리 문 한(Mary Moon Han) 앨범. | 메리 문 한(Mary Moon Han) | NULL | media/roberta-jang/original/K1MYEmqzSmUgpXRnPeJh.jpg | NULL | media/roberta-jang/thumbs/K1MYEmqzSmUgpXRnPeJh.jpg | media/roberta-jang/thumbs/K1MYEmqzSmUgpXRnPeJh.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:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/K1MYEmqzSm | 1935 | NULL | NULL | 1 | 0 | 0 |
| Hgn8QghJTdaQoVLlbbCBng | 사진 | Philo와 Ok Soon Owen 가족. 1997년경. Philo Owen 앨범. | Philo, Ok Soon Owen | NULL | media/roberta-jang/original/fcVZYx2pjtabuxc4Aj4C.jpg | NULL | media/roberta-jang/thumbs/fcVZYx2pjtabuxc4Aj4C.jpg | media/roberta-jang/thumbs/fcVZYx2pjtabuxc4Aj4C.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/fcVZYx2pjt | 1997 | NULL | 1997년경 | 2 | 0 | 0 |
| HFzwJrsPRVez9hn1hWNzNw | 사진 | 이태성(Tai Sung Lee)과 박종수(Chong Soo Park). 1920년대경. 이태성 앨범. | 이태성, 박종수 | NULL | media/roberta-jang/original/qeOMKjebw1RA4N6nJSmg.jpg | NULL | media/roberta-jang/thumbs/qeOMKjebw1RA4N6nJSmg.jpg | media/roberta-jang/thumbs/qeOMKjebw1RA4N6nJSmg.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/qeOMKjebw1 | 1920 | 1920년대 | NULL | 2 | 1 | 1 |
| HDnWzF4zQoGCszMckVEmlg | 사진 | 임준호 목사와 Mary Doh Lim 가족. 1910년대경. Ome Best 앨범. | 임준호, Mary Doh Lim | NULL | media/roberta-jang/original/bypLNyt1tSltTD8G6ld0.jpg | NULL | media/roberta-jang/thumbs/bypLNyt1tSltTD8G6ld0.jpg | media/roberta-jang/thumbs/bypLNyt1tSltTD8G6ld0.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/bypLNyt1tS | 1910 | 1910년대 | NULL | 2 | 1 | 0 |
| HBqpNJzlTQ66w-l3IzaZeg | NULL | 한인기독교히 (이승만 박사가 설립한 교회) 창립60주년 기념예배，김중기 목사 (1978). Korean Christian Church (Founder Dr. Syngman Rhee | 한인기독교히, 이승만, 김중기, Syngman Rhee | NULL | media/roberta-jang/original/a9BMMh59kLxQJMrIp0Cb.jpg | NULL | media/roberta-jang/thumbs/a9BMMh59kLxQJMrIp0Cb.jpg | media/roberta-jang/thumbs/a9BMMh59kLxQJMrIp0Cb.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 154 | 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/a9BMMh59kL | NULL | NULL | NULL | 4 | 0 | 1 |
| 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 |
| 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 |