컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| GX-aYyagRV2G5E9nGExjIA | NULL | 한인중앙학원 첫 졸업생 기념사진, 펀치볼 스트릿 한인존 (1912: The first Korean graduates, 6th grade, from Korean Central Ins | 1. 김잔제 (Chan Jay Kim) 2. 김개봉 (Gay Bong Kim) 3. 박관두 (Kwan Doo Park) 4. 김성현 (Sung Hyun Kim) 5. 양유찬 (Yo | 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 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/CGsvldzF9p | NULL | NULL | NULL | 6 | 0 | 0 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| g2jXP09tRwupTK.LTNUmEA | NULL | Can someone identify this picture ? | 죄송하지만, 이미지를 인식하거나 분석하는 기능은 제공되지 않습니다. 도움이 필요하시면 이미지에 대한 설명을 해주시면 더 도움을 드릴 수 있습니다. | 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 | 2025-12-06 11:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/4gkaO29Rtp | NULL | NULL | NULL | 2 | 0 | 0 |