컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GiYX5rouT-GLR-uNSOb-SA | 사진 | 교민단이 프린세스 극장에서 개최한 도산 안창호 환영회. 1924년. 천윤희(Yin Hee Chun Given) 앨범. | 천윤희 | NULL | media/roberta-jang/original/W9P0aqJy0j5p6fbY7uCg.jpg | NULL | media/roberta-jang/thumbs/W9P0aqJy0j5p6fbY7uCg.jpg | media/roberta-jang/thumbs/W9P0aqJy0j5p6fbY7uCg.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/W9P0aqJy0j | 1924 | NULL | NULL | 1 | 0 | 0 | NULL |
| GDnjWX6qSHWjJijcncsmAw | 사진 | 김윤종(Yoon Chong KimhaeKim), 김윤국(Yoon Kuk Kim), 노디김(Nodie Dora Kim (Sohn), 서 있는 사람). 1910년경. 위니프레드 리 남 | 김윤종, 김윤국, 노디김, 위니프레드 리 남바 | NULL | media/roberta-jang/original/Y97IZg5ZatGXqYNi52l5.jpg | NULL | media/roberta-jang/thumbs/Y97IZg5ZatGXqYNi52l5.jpg | media/roberta-jang/thumbs/Y97IZg5ZatGXqYNi52l5.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/Y97IZg5Zat | 1910 | NULL | 1910년경 | 4 | 0 | 0 | NULL |
| gBO3omvvUrHYFVGCRvy3 | 사진 | A farm field | NULL | A farm field | media/jungnamyong/original/gBO3omvvUrHYFVGCRvy3.jpg | NULL | media/jungnamyong/thumbs/gBO3omvvUrHYFVGCRvy3.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_71_A farm 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 |
| GB1AMDrWjVcDTYdGsvUZ | 사진 | NULL | NULL | NULL | media/salome-choehan/original/GB1AMDrWjVcDTYdGsvUZ.jpg | NULL | media/salome-choehan/thumbs/GB1AMDrWjVcDTYdGsvUZ.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00019.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 |
| G7os1bIVTbeorfvyak1SrA | NULL | 이민초기 감리교회 성직자들의 연차모임(1907). 뒷줄 왼쪽부터 최진태, 김예채, 김유순, 신홍근, 앞줄 왼쪽부터 성명미상, 김영식, 홍치범, 민찬호 Korean Pastors i | 최진태, 김예채, 김유순, 신홍근, 성명미상, 김영식, 홍치범, 민찬호 | NULL | media/roberta-jang/original/kNdY9OkqSxvNKQRlxVsq.jpg | NULL | media/roberta-jang/thumbs/kNdY9OkqSxvNKQRlxVsq.jpg | media/roberta-jang/thumbs/kNdY9OkqSxvNKQRlxVsq.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/uH6Ztl3pVT | NULL | 그들의 발자취 | 114 | 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/kNdY9OkqSx | NULL | NULL | NULL | 8 | 1 | 1 | NULL |
| G5CPqfhoRnmWBNM8iAkoqA | NULL | 케아모쿠 스트릿 현 그리스도 연합감리교회 주차장에 있었던 구교회 전경, 1층은 교회, 2층은 교육관, 3층은 목사관저로 이용(1948-1950) Old church of Chris | 케아모쿠 스트릿 현 그리스도 연합감리교회 | NULL | media/roberta-jang/original/gbvxzZOO50fEiHveomck.jpg | NULL | media/roberta-jang/thumbs/gbvxzZOO50fEiHveomck.jpg | media/roberta-jang/thumbs/gbvxzZOO50fEiHveomck.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 123 | Rev，T. Samuel Lee 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/gbvxzZOO50 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| G4icYED0QqGsvcZz3Yv3Sw | 사진 | 에스더 림 엄이 연출하고 졸업반 여학생들이 참여한 연극. 루즈벨트 스쿨(Roosbelt School) 강당에서 공연하였다. 왼쪽부터, 박금우(Kuem-mu Park), 군복을 입은 | 박금우, 윌라 문 정, 김순례 | NULL | media/roberta-jang/original/zOl0m8C6DkXVKQrLOEfB.jpg | NULL | media/roberta-jang/thumbs/zOl0m8C6DkXVKQrLOEfB.jpg | media/roberta-jang/thumbs/zOl0m8C6DkXVKQrLOEfB.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/zOl0m8C6Dk | 1958 | NULL | 1958년경 | 3 | 0 | 1 | NULL |
| g2WAzJrmR0mUZWJESGkSnA | NULL | 마우이 한인감리교회 임준호 목사 가족(1927) Rev. Joon Ho Im and his family | 임준호 목사 | NULL | media/roberta-jang/original/9REwSibsSMSaTdgIVcoW.jpg | NULL | media/roberta-jang/thumbs/9REwSibsSMSaTdgIVcoW.jpg | media/roberta-jang/thumbs/9REwSibsSMSaTdgIVcoW.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/igut86tAXI | NULL | 그들의 발자취 | 138 | 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/9REwSibsSM | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| g2jXP09tRwupTK.LTNUmEA | NULL | Can someone identify this picture ? | NULL | NULL | media/roberta-jang/original/4gkaO29RtpC2tC1d4Q27.jpg | NULL | media/roberta-jang/thumbs/4gkaO29RtpC2tC1d4Q27.jpg | media/roberta-jang/thumbs/4gkaO29RtpC2tC1d4Q27.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/M5QORjgZ5p | NULL | 그들의 발자취 | 176 | Mrs. Agnes Pho Chun | 2025-09-14 05:59:58 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/4gkaO29Rtp | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| g-ZpLL-eTE6FNy52jwCNOA | 사진 | 메리 애기 김(Mary Ae Gee Kim)과 가족. | 메리 애기 김 | 앞줄 왼쪽부터, 로지(Rosie), 베티(Betty), 루스(Ruth), 빌(Beill), 뒷줄 왼쪽부터, 클라라(Clara), 관열(Kwan Yer, 메리 애기 김의 두 번째 남 | media/roberta-jang/original/tHofLTkUI7cfAgedsyL9.jpg | NULL | media/roberta-jang/thumbs/tHofLTkUI7cfAgedsyL9.jpg | media/roberta-jang/thumbs/tHofLTkUI7cfAgedsyL9.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/tHofLTkUI7 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| G-RVbn4jTAaaF.rTMyO7vQ | NULL | 대한인부인구제회에서 주최한 해외 한족대표 초대연 (1944) Korean Women's Relief Society invited representatives of Overseas | 대한인부인구제회, Korean Women's Relief Society | NULL | media/roberta-jang/original/Eard55TkA0iBydTyLG3X.jpg | NULL | media/roberta-jang/thumbs/Eard55TkA0iBydTyLG3X.jpg | media/roberta-jang/thumbs/Eard55TkA0iBydTyLG3X.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/HOMbxA7w24 | NULL | 그들의 발자취 | 98 | 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/Eard55TkA0 | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| fzF7oi5VSROTOmiCbz37mw | 사진 | 전경무. 재미한족연합위원회 홍보분과 위원장. 1940년대경. 민병용 컬렉션. | 전경무 | NULL | media/roberta-jang/original/CwXdaKZNAl9HH9cu1ZKW.jpg | NULL | media/roberta-jang/thumbs/CwXdaKZNAl9HH9cu1ZKW.jpg | media/roberta-jang/thumbs/CwXdaKZNAl9HH9cu1ZKW.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/CwXdaKZNAl | 1940 | 1940년대 | NULL | 1 | 0 | 1 | NULL |
| Fzd27tVWTD2uKrs3eLNRHQ | 사진 | 오운. 조미구락부의 설립자이자 회장. 1930년경. 조지 오웬(George Owen)앨범. | 오운, 조지 오웬 | NULL | media/roberta-jang/original/zKSIhEHHc7ZEpkOGfmML.jpg | NULL | media/roberta-jang/thumbs/zKSIhEHHc7ZEpkOGfmML.jpg | media/roberta-jang/thumbs/zKSIhEHHc7ZEpkOGfmML.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:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/zKSIhEHHc7 | 1930 | NULL | 1930년경 | 2 | 0 | 0 | NULL |
| FXwFY487TxKX2WLcSEvY8Q | 사진 | 콜로아 오락회관. 1924년. 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/zoOKn7XgEHGkOsdX37Vw.jpg | NULL | media/roberta-jang/thumbs/zoOKn7XgEHGkOsdX37Vw.jpg | media/roberta-jang/thumbs/zoOKn7XgEHGkOsdX37Vw.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/zoOKn7XgEH | 1924 | NULL | NULL | 1 | 0 | 0 | NULL |
| fWPY4YtLSTOFMVmdAY5YHQ | 사진 | 푸우누이(Puunui)에 있던 한인기독학원(KCI) 건물 중 하나. 1923년. 민병용 컬렉션. | 민병용 | NULL | media/roberta-jang/original/Y7CqQGhd1RYXnRfE6PvU.jpg | NULL | media/roberta-jang/thumbs/Y7CqQGhd1RYXnRfE6PvU.jpg | media/roberta-jang/thumbs/Y7CqQGhd1RYXnRfE6PvU.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/Y7CqQGhd1R | 1923 | NULL | NULL | 1 | 0 | 0 | NULL |
| fUC8Fp5Uxi4Ys45BiyT7 | 사진 | NULL | Korean Nurses | NULL | media/salome-choehan/original/fUC8Fp5Uxi4Ys45BiyT7.jpg | NULL | media/salome-choehan/thumbs/fUC8Fp5Uxi4Ys45BiyT7.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #3_H-100_O_Korean Nurses - JOEL PAHK 1 to r back row Eun Hae, Salome Choi Han, Alice Kim Chur 1 to | 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 |
| FTBtcV8RS56HkJyItl1k3Q | 사진 | 파인애플 농장에서 (연도미상) At the Pineapple Plantation (Date Unknown) | 파인애플 농장에서 | NULL | media/roberta-jang/original/biPAUgr1LYSd7asCXBMD.jpg | NULL | media/roberta-jang/thumbs/biPAUgr1LYSd7asCXBMD.jpg | media/roberta-jang/thumbs/biPAUgr1LYSd7asCXBMD.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/MqMAxgP1TF | NULL | 그들의 발자취 | 32 | Dr Samuel Lee 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/biPAUgr1LY | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| frIXw-GsTPaSI14oNYHQJQ | 사진 | 1941년 한길수가 디자인한 샌프란시스코의 시가행진 장식차. 장식차 위에 서 있는 노인이 양주은(Choo Eun Yang)이다. 그는 1898년에 하와이에 도착하여 1900년 즈음 | 양주은, 안형주 | NULL | media/roberta-jang/original/8A4g3Tb2tKxGYnWubNE6.jpg | NULL | media/roberta-jang/thumbs/8A4g3Tb2tKxGYnWubNE6.jpg | media/roberta-jang/thumbs/8A4g3Tb2tKxGYnWubNE6.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/8A4g3Tb2tK | 1941 | NULL | NULL | 2 | 0 | 0 | NULL |
| FNUpbeW8QWm3Ah1gFulQTQ | NULL | 대한부인구제회 단기 Korean Women’s Relief Society's flag | 대한부인구제회 단기 | NULL | media/roberta-jang/original/Jcad06OoEfmitqAVDauh.jpg | NULL | media/roberta-jang/thumbs/Jcad06OoEfmitqAVDauh.jpg | media/roberta-jang/thumbs/Jcad06OoEfmitqAVDauh.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/j7LQMr8YML | NULL | 그들의 발자취 | 93 | Korea Times 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/Jcad06OoEf | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| FNMbm8WrQVG8swC4B7O63g | 사진 | 1908년 3월 24일 샌프란시스코에서 한국인 2명이 더램 화이트 스티븐스를 저격하였다. 『샌프란시스코 크로니클(San Francisco Chronicle)』. | 더램 화이트 스티븐스 | NULL | media/roberta-jang/original/Y07TDc2TbSDVHKd5CdBC.jpg | NULL | media/roberta-jang/thumbs/Y07TDc2TbSDVHKd5CdBC.jpg | media/roberta-jang/thumbs/Y07TDc2TbSDVHKd5CdBC.jpg | NULL | 2025-04-17 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | 1908-03-24 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/Y07TDc2TbS | 1908 | NULL | NULL | 1 | 0 | 0 | NULL |