컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RZjD.zD5Qryn63H1J8LyAA | 사진 | 국민회. '민중승리축하' 기념촬영. 1932년 4월. 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/66WmCnbPq9hxfseuVOdm.jpg | NULL | media/roberta-jang/thumbs/66WmCnbPq9hxfseuVOdm.jpg | media/roberta-jang/thumbs/66WmCnbPq9hxfseuVOdm.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/66WmCnbPq9 | 1932 | NULL | NULL | 1 | 0 | 0 |
| rxCMitD8SQaL6dxMr3bacQ | 사진 | 사진 신부들. 하와이 호놀롤루에 새로 도착한 사진 신부들로, 사진 신랑들이 일하고 있는 이웃 섬으로 흩어지기 전에 촬영하였다. 앞줄 왼쪽에서 두 번째 손효순(Hyo Soon Sho | 손효순, 조보배, 유복순, 박영진 | NULL | media/roberta-jang/original/AoDbRKUOIRQ0OuAO0pQ3.jpg | NULL | media/roberta-jang/thumbs/AoDbRKUOIRQ0OuAO0pQ3.jpg | media/roberta-jang/thumbs/AoDbRKUOIRQ0OuAO0pQ3.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/AoDbRKUOIR | 1913 | NULL | 1913년경 | 4 | 0 | 0 |
| rwpQ8Ff3Qe6Dbp1Z-DlQ0A | NULL | 국민군단 훈련지의 현재 모습(1992) Ahuimanu Subdivision where Korean Liberation Army Camp existec -Korea Central | 국민군단, 한국광복군 | NULL | media/roberta-jang/original/ec4TaDDxiyaItxSSbACG.jpg | NULL | media/roberta-jang/thumbs/ec4TaDDxiyaItxSSbACG.jpg | media/roberta-jang/thumbs/ec4TaDDxiyaItxSSbACG.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/mRB161z0WO | NULL | 그들의 발자취 | 71 | 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/ec4TaDDxiy | NULL | NULL | NULL | 2 | 0 | 0 |
| RVJNEOB0QKGK7fbmP3Pwgg | 사진 | 콜로라도주 크레이튼(Creighton)의 한인농업회사(Korean Algricultural Copertaion). 농업회사의 대표 안재창(Chai Chang Ahn, 모자를 쓰지 | 안재창 | NULL | media/roberta-jang/original/xIExQm105Z5iEN5gdxld.jpg | NULL | media/roberta-jang/thumbs/xIExQm105Z5iEN5gdxld.jpg | media/roberta-jang/thumbs/xIExQm105Z5iEN5gdxld.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/xIExQm105Z | 1919 | NULL | 1919년경 | 1 | 1 | 0 |
| ruXJHZseSw-hRtCd9vtjLg | 사진 | 조지 오웬 상사. 오운(Cloud Owen)의 아들로 1951년 한국전쟁 중에 중공군 포로들과 함께 촬영한 사진. 조지 오웬 앨범. | 조지 오웬, 오운 | NULL | media/roberta-jang/original/Bv4p0tLRNaiU6CnrSHU2.jpg | NULL | media/roberta-jang/thumbs/Bv4p0tLRNaiU6CnrSHU2.jpg | media/roberta-jang/thumbs/Bv4p0tLRNaiU6CnrSHU2.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/Bv4p0tLRNa | 1951 | NULL | NULL | 2 | 0 | 0 |
| rutoVyTFRxiVDL7CK7ehcw | 사진 | 현순 목사와 서울성가대. 서울. 1912년경. 데이비드 현 컬렉션. | 현순 목사, 서울성가대. | NULL | media/roberta-jang/original/HU3Xs9ZKlyPqXDmKcqzX.jpg | NULL | media/roberta-jang/thumbs/HU3Xs9ZKlyPqXDmKcqzX.jpg | media/roberta-jang/thumbs/HU3Xs9ZKlyPqXDmKcqzX.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/HU3Xs9ZKly | 1912 | NULL | 1912년경 | 2 | 0 | 0 |
| ruHpZe42SDWSZJjENOEIxg | 사진 | 남(Nahm) 자매. 패니(Fannie), 헬렌(Helen), 베르타(Bertha). 1914년경. 김영내(Edward Young Nai Kim) 앨범. | 남(Nahm), 패니(Fannie), 헬렌(Helen), 베르타(Bertha), 김영내(Edward Young Nai Kim) | NULL | media/roberta-jang/original/q0Y19OwPEq4DmIJR1YxA.jpg | NULL | media/roberta-jang/thumbs/q0Y19OwPEq4DmIJR1YxA.jpg | media/roberta-jang/thumbs/q0Y19OwPEq4DmIJR1YxA.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/q0Y19OwPEq | 1914 | NULL | 1914년경 | 5 | 0 | 0 |
| RtmGC1nLS.e9nPjZrurT5A | 사진 | 윤병구 목사. 1930년대경. Susan E. Yoon McDavid 컬렉션. | 윤병구 | NULL | media/roberta-jang/original/tyDixcLATZvktsdF7vID.jpg | NULL | media/roberta-jang/thumbs/tyDixcLATZvktsdF7vID.jpg | media/roberta-jang/thumbs/tyDixcLATZvktsdF7vID.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/tyDixcLATZ | 1930 | 1930년대 | NULL | 1 | 0 | 0 |
| RsV1aDXLRwW5ZZE2ab0BLg | NULL | 천연희 사진신부는 영어로 토를 달아 자녀들에게 한문공부를 시켰다. Mrs, Yun Hee Chun Given taught Chinese to her children | Yun Hee Chun | NULL | media/roberta-jang/original/CmbuV03DcWmqQODkZNwa.jpg | NULL | media/roberta-jang/thumbs/CmbuV03DcWmqQODkZNwa.jpg | media/roberta-jang/thumbs/CmbuV03DcWmqQODkZNwa.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/CmbuV03DcW | NULL | NULL | NULL | 1 | 0 | 0 |
| rscRhdGLQxq-BpYwcnd2Xw | 사진 | 농장에서 노동자들의 옷을 세탁하는 여성. 1924년경. 감리교회 사진. | 여성 | NULL | media/roberta-jang/original/YJFw1wQYTcLdV9rpqiSa.jpg | NULL | media/roberta-jang/thumbs/YJFw1wQYTcLdV9rpqiSa.jpg | media/roberta-jang/thumbs/YJFw1wQYTcLdV9rpqiSa.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/YJFw1wQYTc | 1924 | NULL | 1924년경 | 1 | 0 | 0 |
| rNyScewcTt6nVR3Pp3KQ0A | NULL | 정봉원씨 가족(1940) Mr. & Mrs. Bong Woon (Young Ok) Chung family 1st row(L to R): Ronald, Young Ok, Bong W | 정봉원, 영옥, 로널드, 리차드, 월터, 해리, 윌리엄, 로버트 | NULL | media/roberta-jang/original/xBOGQKzMtxiFsF59nsVr.jpg | NULL | media/roberta-jang/thumbs/xBOGQKzMtxiFsF59nsVr.jpg | media/roberta-jang/thumbs/xBOGQKzMtxiFsF59nsVr.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 56 | 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/xBOGQKzMtx | NULL | NULL | NULL | 8 | 0 | 0 |
| RNR7l4JsQWmXQDQ.4pzZNg | 사진 | 유동면 (Dong Men 혹은 Dong Myun)과 메리 유(Mary You) 가족. 왼쪽부터, 헨리(Henry), 멜빈(Melvin), 원영(Won young), 메리, 미니(M | 유동면, 메리 유, 헨리, 멜빈, 원영, 미니, 캐티, 원식, 리처드. E | NULL | media/roberta-jang/original/f2DwToVEY4A1ngxMqIVQ.jpg | NULL | media/roberta-jang/thumbs/f2DwToVEY4A1ngxMqIVQ.jpg | media/roberta-jang/thumbs/f2DwToVEY4A1ngxMqIVQ.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/f2DwToVEY4 | 1942 | NULL | 1942년경 | 9 | 1 | 1 |
| RkrW42N8Sn6uTV4NQtR-AA | NULL | 타이거스 클럽, 맥킨리 고등학교 Tigers Club Mckinley High School | 타이거스 클럽, 맥킨리 고등학교 | NULL | media/roberta-jang/original/3WJEaQWhwdAbdjWn5hgY.jpg | NULL | media/roberta-jang/thumbs/3WJEaQWhwdAbdjWn5hgY.jpg | media/roberta-jang/thumbs/3WJEaQWhwdAbdjWn5hgY.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 108 | Mrs. Sara Kim 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/3WJEaQWhwd | NULL | NULL | NULL | 2 | 0 | 0 |
| RkKG2qKzSrG.fm7wxv1GMg | NULL | 속지 | 속지 | NULL | NULL | NULL | glide:mesh,속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 168 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | NULL | NULL | NULL | NULL | 1 | 0 | 0 |
| Rgg9EFRORbWMTBsId5RLIA | NULL | 대한인국민회 하와이지방총회 회관，밀러 스트릿(19너-1949) Hecidquarters of Kook Min Hur at Miller St. | 대한인국민회 하와이지방총회 회관, 밀러 스트릿 | NULL | media/roberta-jang/original/BF507wHG7zVH0XPe9Hph.jpeg | NULL | media/roberta-jang/thumbs/BF507wHG7zVH0XPe9Hph.jpeg | media/roberta-jang/thumbs/BF507wHG7zVH0XPe9Hph.jpeg | NULL | 2025-07-08 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | 1914-07-08 00:00:00 | NULL | NULL | 그들의 발자취 | 73 | 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/BF507wHG7z | NULL | NULL | NULL | 2 | 0 | 0 |
| RcwuEzr3Q4aMkhiFYJoi1A | 사진 | 리처드 '반조 킹' 최(Richard'Banjo King' Choi), 강영각(Donald Young Gak Kang), 월터 정(Walter Jhung). 1930년대. Brys | 리처드 '반조 킹' 최, 강영각, 월터 정, Bryson Jhung | NULL | media/roberta-jang/original/3aFI4duv4UZOwskcSr4b.jpg | NULL | media/roberta-jang/thumbs/3aFI4duv4UZOwskcSr4b.jpg | media/roberta-jang/thumbs/3aFI4duv4UZOwskcSr4b.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/3aFI4duv4U | 1930 | 1930년대 | NULL | 4 | 0 | 1 |
| RC.NH-TSSKaHm7Y-g3-iJA | 사진 | 시베리아호. 오성진(Chris Sung Jin Oh) 컬렉션, 하와이주 사료보관소. | 오성진(Chris Sung Jin Oh) | NULL | media/roberta-jang/original/AyypKzbUX6cDBz1aicZ7.jpg | NULL | media/roberta-jang/thumbs/AyypKzbUX6cDBz1aicZ7.jpg | media/roberta-jang/thumbs/AyypKzbUX6cDBz1aicZ7.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/AyypKzbUX6 | NULL | NULL | NULL | 1 | 0 | 0 |
| r4J12q8KQvWLasQaHv00gw | NULL | 영남부인회 (Korean Young Nam Women’s Society) 영남부인회 (연도미상) The Korean Young Nam Women’s Society (Date Unk | 영남부인회 | NULL | media/roberta-jang/original/dSMT555aQPlW5Qcl5aB8.jpg | NULL | media/roberta-jang/thumbs/dSMT555aQPlW5Qcl5aB8.jpg | media/roberta-jang/thumbs/dSMT555aQPlW5Qcl5aB8.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/nYLQ4bsUJj | NULL | 그들의 발자취 | 103 | 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/dSMT555aQP | NULL | NULL | NULL | 1 | 0 | 0 |
| r2Ru.fq1SgOiVkZoTpFpUw | 사진 | 시베리아 최와 박진한(Jin Han Park) 결혼식. Sung Ok과 Maria Cho Choi의 딸인 시베리아는 1904년 시베리아호 선상에서 태어났다. 1922년. 클래런스 | 시베리아 최, 박진한, Sung Ok, Maria Cho Choi, 클래런스 최. | NULL | media/roberta-jang/original/dbBMQUIwwMITI6oRF2Qr.jpg | NULL | media/roberta-jang/thumbs/dbBMQUIwwMITI6oRF2Qr.jpg | media/roberta-jang/thumbs/dbBMQUIwwMITI6oRF2Qr.jpg | 최성옥시베리아 최 | 2025-07-11 00:00:00 | 최성옥 | 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/dbBMQUIwwM | 1904 | NULL | NULL | 5 | 0 | 0 |
| QXh1VBKkSQCwcyT-8UWn0g | NULL | 조선독립을 위하여 군관학교와 국민군단을 창설한 박용만 장군(1917) Mr. Yong Man Park, founder of Korean Military Academy and Lib | 박용만 | NULL | media/roberta-jang/original/xf2AqoBwOIDgBeNmOSxL.jpg | NULL | media/roberta-jang/thumbs/xf2AqoBwOIDgBeNmOSxL.jpg | media/roberta-jang/thumbs/xf2AqoBwOIDgBeNmOSxL.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 68 | Mr Young Ok Kang Collection | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/xf2AqoBwOI | NULL | NULL | NULL | 1 | 0 | 1 |