컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MTQs.8ARRCWFPy40AebzNg | NULL | 이승만 박사와 함께, 뒷줄 왼쪽에서 다섯번째가 홍치범 목요ᅡ(연도미상) Front row center: Dr. Syngman Rhee. Back row 5th from left t | 이승만, 홍치범 | NULL | media/roberta-jang/original/OXVVIo6nnCiKYUJ45dQ1.jpg | NULL | media/roberta-jang/thumbs/OXVVIo6nnCiKYUJ45dQ1.jpg | media/roberta-jang/thumbs/OXVVIo6nnCiKYUJ45dQ1.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 155 | 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/OXVVIo6nnC | NULL | NULL | NULL | 2 | 1 | 1 | NULL |
| mTQOEl6sRYyOcQXJFdeVmg | NULL | 사진신부가 하와이 신랑 후보에게 보낸 사진(1913) Exchange Photo of Picture Bride | 사진신부, 하와이 신랑 후보 | NULL | media/roberta-jang/original/aGpgWwa9NUBh63Jk9cXn.jpg | NULL | media/roberta-jang/thumbs/aGpgWwa9NUBh63Jk9cXn.jpg | media/roberta-jang/thumbs/aGpgWwa9NUBh63Jk9cXn.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/MDvvt0DpXF | 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/aGpgWwa9NU | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| mTCJIIUCRV-XnYQOGoxWBQ | 사진 | 이승만과 프란체스카 도너 리(꽃목걸이를 하고 서 있는 사람)가 하와이를 떠나 워싱턴으로 갔다. Ellen Lee Suhl 앨범. | 이승만, 프란체스카 도너 리, Ellen Lee Suhl | NULL | media/roberta-jang/original/PuIpBqpDSb1WcFlDJ2EW.jpg | NULL | media/roberta-jang/thumbs/PuIpBqpDSb1WcFlDJ2EW.jpg | media/roberta-jang/thumbs/PuIpBqpDSb1WcFlDJ2EW.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/PuIpBqpDSb | NULL | NULL | NULL | 3 | 0 | 1 | NULL |
| MQWEFFJ7QWKxSgywjzhF9w | 사진 | 쿠바의 한인학교. 1940년대경. Mabel Paik Meu 앨범. | Mabel Paik Meu | NULL | media/roberta-jang/original/dbTESVC7MTFF7wGKiWJY.jpg | NULL | media/roberta-jang/thumbs/dbTESVC7MTFF7wGKiWJY.jpg | media/roberta-jang/thumbs/dbTESVC7MTFF7wGKiWJY.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/dbTESVC7MT | 1940 | 1940년대 | NULL | 1 | 0 | 0 | NULL |
| Mq83kJ39DQmhQ20iXOvU | 사진 | Crops | NULL | Crops | media/jungnamyong/original/Mq83kJ39DQmhQ20iXOvU.jpg | NULL | media/jungnamyong/thumbs/Mq83kJ39DQmhQ20iXOvU.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_61_Crops.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 |
| Mq-8VCt0SRim-4Jg9PDadg | NULL | 이승만 박사 Dr. Syngman Rhee, | 이승만, Syngman Rhee | NULL | media/roberta-jang/original/rpMgcR2eE9llRHPFalnK.jpg | NULL | media/roberta-jang/thumbs/rpMgcR2eE9llRHPFalnK.jpg | media/roberta-jang/thumbs/rpMgcR2eE9llRHPFalnK.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 81 | 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/rpMgcR2eE9 | NULL | NULL | NULL | 2 | 0 | 1 | NULL |
| MP0qTKLbQa6s7GxxkOkLZw | 사진 | 한인여학원. 1917년. 비숍박물관. | 한인여학원 | NULL | media/roberta-jang/original/6ehW19LUbJmDrskrQJNU.jpg | NULL | media/roberta-jang/thumbs/6ehW19LUbJmDrskrQJNU.jpg | media/roberta-jang/thumbs/6ehW19LUbJmDrskrQJNU.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/6ehW19LUbJ | 1917 | NULL | NULL | 1 | 0 | 0 | NULL |
| momL-6SGRLeeTdfZtxkhMA | NULL | 김종수 선생님과 카우아이 리후에 한인학교 학생늘(1910-1911년경) Kauai Lihue Korean Day School. Teacher: Chong Soo Kim (Circa | 김종수, Kelly Yoon Ock Kim | NULL | media/roberta-jang/original/4lU4aWv0fPpftg7vwAkZ.jpg | NULL | media/roberta-jang/thumbs/4lU4aWv0fPpftg7vwAkZ.jpg | media/roberta-jang/thumbs/4lU4aWv0fPpftg7vwAkZ.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/0XPzpdzryG | NULL | 그들의 발자취 | 178 | 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/4lU4aWv0fP | 1910 | NULL | 1910년경 | 2 | 0 | 0 | NULL |
| MMzEyvi4cOBElln5WPjw | 사진 | NULL | NULL | NULL | media/salome-choehan/original/MMzEyvi4cOBElln5WPjw.jpg | NULL | media/salome-choehan/thumbs/MMzEyvi4cOBElln5WPjw.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 00013.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 |
| Mm3nXOsITrmG8nJnQKJ31A | NULL | 초대총장 이원철 박사가 이승만 대통령으로부터 교기를 받고 있다. Dr. Won Chui Lee (1st President of Inha) receives the school fla | 이원철, 이승만 | NULL | media/roberta-jang/original/ucXWDEIsPo5Txb7MDEuF.jpg | NULL | media/roberta-jang/thumbs/ucXWDEIsPo5Txb7MDEuF.jpg | media/roberta-jang/thumbs/ucXWDEIsPo5Txb7MDEuF.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 89 | 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/ucXWDEIsPo | NULL | NULL | NULL | 2 | 0 | 1 | NULL |
| MlkFW721VCmHJGpCbAEB | 사진 | A soldier on the veranda | NULL | A soldier on the veranda | media/jungnamyong/original/MlkFW721VCmHJGpCbAEB.jpg | NULL | media/jungnamyong/thumbs/MlkFW721VCmHJGpCbAEB.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #6_118_A soldier on the veranda.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 |
| mHvReDcWRNqrPBxo-.0ARA | NULL | 와히아와 한인기독교회(Wahiawa Korean Christian Church) 와히아와 한인기독교회 전신 237 Palm Street Wahiawa Korean Christian | 와히아와 한인기독교회, 와히아와 유나이티드 교회 | NULL | media/roberta-jang/original/L2MObScPSX2LWorD9q5L.jpg | NULL | media/roberta-jang/thumbs/L2MObScPSX2LWorD9q5L.jpg | media/roberta-jang/thumbs/L2MObScPSX2LWorD9q5L.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 166 | 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/L2MObScPSX | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| mhDECc6AQ5aAVdGTwiukMA | 사진 | 조나 리 상사가 재래시장에서 생선 장사를 하는 큰고모를 만났다. 조나 리 앨범. | 조나 리, 큰고모 | NULL | media/roberta-jang/original/MlczKhbeB0ALTafgfrCj.jpg | NULL | media/roberta-jang/thumbs/MlczKhbeB0ALTafgfrCj.jpg | media/roberta-jang/thumbs/MlczKhbeB0ALTafgfrCj.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:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/MlczKhbeB0 | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| Mg2pkoTmT5O2M4PYKlIUng | NULL | 대한인국민회 하와이지방총회 경축행사，포트 스트릿(1915년경) KookMin Hur Meeting at the Princess Theater on Fort St. (Circa 19 | Mrs. Yun Hee Chun | NULL | media/roberta-jang/original/OR2winAdOSa5JoopXnuP.jpg | NULL | media/roberta-jang/thumbs/OR2winAdOSa5JoopXnuP.jpg | media/roberta-jang/thumbs/OR2winAdOSa5JoopXnuP.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/5QWDNE2NuJ | NULL | 그들의 발자취 | 66 | 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/OR2winAdOS | 1915 | NULL | 1915년경 | 1 | 0 | 0 | NULL |
| mb-qBonHQiWggueLWtX0Kw | 사진 | 우정초(Chung Cho)와 홍봉윤(Mary Bong Yun Hong Woo) 가족. 아이들 왼쪽부터, 도라(Dora), 하라(Hara), 애미(Amy), 캐더린(Katherine | 우정초, 홍봉윤, 도라, 하라, 애미, 캐더린, 사라, 존, 조셉 | NULL | media/roberta-jang/original/KlqeuxtX4x1MRgGLCSXG.jpg | NULL | media/roberta-jang/thumbs/KlqeuxtX4x1MRgGLCSXG.jpg | media/roberta-jang/thumbs/KlqeuxtX4x1MRgGLCSXG.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/KlqeuxtX4x | 1924 | NULL | 1924년경 | 8 | 0 | 0 | NULL |
| m9Nay1SYjs0aZLVXBFdJ | 사진 | NULL | NULL | NULL | media/salome-choehan/original/m9Nay1SYjs0aZLVXBFdJ.jpg | NULL | media/salome-choehan/thumbs/m9Nay1SYjs0aZLVXBFdJ.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #2_ 00007.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 |
| m99gu8sMwLB5w9h8DPXE | 사진 | NULL | NULL | NULL | media/salome-choehan/original/m99gu8sMwLB5w9h8DPXE.jpg | NULL | media/salome-choehan/thumbs/m99gu8sMwLB5w9h8DPXE.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #03_ 00003.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 |
| m8DlUQUMaNZ8UOlRW96D | 사진 | NULL | NULL | Korean farm village - Mom's home | media/jungnamyong/original/m8DlUQUMaNZ8UOlRW96D.jpg | NULL | media/jungnamyong/thumbs/m8DlUQUMaNZ8UOlRW96D.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #6_116_Korean farm village - Mom's home.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 |
| M4pUcQoGR2Sk7IXK1bX.uA | 사진 | 대한부인구제회 회원들이 카피올라니 공원(Kapiolani Park)에서 행진하고 있다. 1921년 11월 11일. 안형주(Henry Hyung-ji Ahn) 컬렉션. | 안형주 | NULL | media/roberta-jang/original/9vFDxWNHCSDrCG7Go1EO.jpg | NULL | media/roberta-jang/thumbs/9vFDxWNHCSDrCG7Go1EO.jpg | media/roberta-jang/thumbs/9vFDxWNHCSDrCG7Go1EO.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/9vFDxWNHCS | 1921 | NULL | NULL | 1 | 0 | 0 | NULL |
| m24B9Dj7RlSWCkohnAwcYQ | NULL | “하와이 한인 사회평화를 힘쓰는 교류 동포 열정으로 삼일절을 경축하는 경황” 대한인교민단(1931.3.1) Korean Community Association commemorati | 대한인교민단 | NULL | media/roberta-jang/original/Xab1jrkYe9ZOqX71p07G.jpg | NULL | media/roberta-jang/thumbs/Xab1jrkYe9ZOqX71p07G.jpg | media/roberta-jang/thumbs/Xab1jrkYe9ZOqX71p07G.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/jxUmyLuhkJ | NULL | 그들의 발자취 | 75 | Independence Hall 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/Xab1jrkYe9 | NULL | NULL | NULL | 1 | 0 | 0 | NULL |