컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| uI0oA7hHRkikncONXF.BPw | 사진 | 피아니스트이자 작곡가인 강영각이 이끈 디누바 한인 밴드 (Dinuba Korean Band). 1910년대경. 안형주(Henry Hyung-ju Ahn) 컬렉션. | 강영각, 안형주 | NULL | media/roberta-jang/original/EbGBJnBDbOkP6UWaploU.jpg | NULL | media/roberta-jang/thumbs/EbGBJnBDbOkP6UWaploU.jpg | media/roberta-jang/thumbs/EbGBJnBDbOkP6UWaploU.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/EbGBJnBDbO | 1910 | 1910년대 | NULL | 2 | 0 | 1 | NULL |
| Uhye92gjTgaFWAP9eqzlaw | NULL | 호놀룰루 시가지를 행진하는 국민군단의 모습 (1917) A procession of soldiers from the Korean Liberation Army, Honolulu | 호놀룰루 시가지를 행진하는 국민군단의 모습 (1917) | NULL | media/roberta-jang/original/JAuYEZPBcxwVb9wt208j.jpg | NULL | media/roberta-jang/thumbs/JAuYEZPBcxwVb9wt208j.jpg | media/roberta-jang/thumbs/JAuYEZPBcxwVb9wt208j.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/gRkIjlyzqf | NULL | 그들의 발자취 | 69 | 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/JAuYEZPBcx | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| uhV6nHkbRM-IDL0E8eIWcg | 사진 | 박덕순(Duk Soon Park)과 마르타 한 박(Martha Hahn Pahk) 가족. | 박덕순, 마르타 한 박 | 왼쪽부터, 왈라스(Wallace), 덕순, 애니(Annie), 아그네스(Agnes,앉아있는 아이), 노라(Nora), 로즈(Rose), 하젤(Hazel), 마르타, 스텔라(Stel | media/roberta-jang/original/bfMPBgIhNhxLwgsR7RNQ.jpg | NULL | media/roberta-jang/thumbs/bfMPBgIhNhxLwgsR7RNQ.jpg | media/roberta-jang/thumbs/bfMPBgIhNhxLwgsR7RNQ.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/bfMPBgIhNh | NULL | NULL | NULL | 2 | 1 | 0 | NULL |
| Uh2PNimPSLGORNw1hJ5Rbg | 사진 | 동지회가 한인 기독교회에 재집결하였다. 1930년. 강영옥(Young Ok Kang) 컬렉션. | 강영옥 | NULL | media/roberta-jang/original/VUjiUfQScQwnzshJvwIK.jpg | NULL | media/roberta-jang/thumbs/VUjiUfQScQwnzshJvwIK.jpg | media/roberta-jang/thumbs/VUjiUfQScQwnzshJvwIK.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/VUjiUfQScQ | 1930 | NULL | NULL | 1 | 0 | 0 | NULL |
| UG5kGd2E3Nu8O3iTwfS0 | 사진 | Korean cantaloupe | NULL | Korean cantaloupe | media/jungnamyong/original/UG5kGd2E3Nu8O3iTwfS0.jpg | NULL | media/jungnamyong/thumbs/UG5kGd2E3Nu8O3iTwfS0.jpg | NULL | NULL | NULL | NULL | NULL | NULL | #4_67_Korean cantaloupe.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 |
| uFmPAa2DSHSZqgHFDz1R.w | NULL | 한 살로에 부동산 중개인 자격증(1949) The Real Estate License Commission of the Territory of Hawaii | 한 살로 | NULL | media/roberta-jang/original/vmn8Mxp7rietcOBMTBui.jpg | NULL | media/roberta-jang/thumbs/vmn8Mxp7rietcOBMTBui.jpg | media/roberta-jang/thumbs/vmn8Mxp7rietcOBMTBui.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 206 | Mrs. Salome Choi Han 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/vmn8Mxp7ri | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| uetE6n3QSjqaZALQOeUo8Q | NULL | 김신라, 1922년 하와이 도작, 당시 19세 김종환씨와 사진결혼, 슬하에 2남3녀를 두었다. 김신라 사진신부는 자기개발을 위하여 학업을 게을리 하지 않았다. (1945) Sill | 김신라, 김종환 | NULL | media/roberta-jang/original/Ods5xE71duHcq39kiuHd.jpg | NULL | media/roberta-jang/thumbs/Ods5xE71duHcq39kiuHd.jpg | media/roberta-jang/thumbs/Ods5xE71duHcq39kiuHd.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 53 | Mrs Silla Kim Collection | 2025-09-14 05:59:58 | 2025-12-06 11:10:30 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/Ods5xE71du | 1922 | NULL | NULL | 2 | 0 | 0 | NULL |
| UerqEPjESJ-aAiLl.3WCVw | 사진 | 사탕수수 노동자 모집 공고문. 1902년. 천안 독립기념관 컬렉션. | 사탕수수 노동자 모집 공고문 | NULL | media/roberta-jang/original/yWTPm0wtFbYbOywFvX5D.jpg | NULL | media/roberta-jang/thumbs/yWTPm0wtFbYbOywFvX5D.jpg | media/roberta-jang/thumbs/yWTPm0wtFbYbOywFvX5D.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/yWTPm0wtFb | 1902 | NULL | NULL | 1 | 0 | 0 | NULL |
| UAQVxW0-Q7-mJHgQlRW3Hg | 사진 | 농장 지배인 조지 렌튼과 함께 사진을 찍은 에와 공립 유치원생들. 1924년. 로버타 장 컬렉션. | 조지 렌튼, 에 | NULL | media/roberta-jang/original/unNmaO25TMZWpPwDADsQ.jpg | NULL | media/roberta-jang/thumbs/unNmaO25TMZWpPwDADsQ.jpg | media/roberta-jang/thumbs/unNmaO25TMZWpPwDADsQ.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/unNmaO25TM | 1924 | NULL | NULL | 1 | 0 | 0 | NULL |
| UajHodJhQAGM8TSShjVkZw | 사진 | 사탕수수 노동자 파업은 이 시기의 인구이동 통계에 큰 변화를 가져왔다. 1920년. 농장 숙소에서 쫓겨난 가족들이 호놀롤루로 모여들었다. 비숍 박물관. | 비숍 박물관 | NULL | media/roberta-jang/original/zcNTn1qmPOpACKnASX3W.jpg | NULL | media/roberta-jang/thumbs/zcNTn1qmPOpACKnASX3W.jpg | media/roberta-jang/thumbs/zcNTn1qmPOpACKnASX3W.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/zcNTn1qmPO | 1920 | NULL | NULL | 1 | 0 | 0 | NULL |
| u2T0xQhtROqKUNjbjUhgfA | NULL | 성공회 성누가교회 국어학교 학생일동(1928) St. Luke’s Church Korean Language School. Principals : Ik Sung Kim(1908), | Ik Sung Kim, Sang Ha Park, Sung Keun Kwon, John S. Park, P.Y. Cho, Noah K. Cho | NULL | media/roberta-jang/original/oxEOydR3Q4CD8xZwdNDJ.jpg | NULL | media/roberta-jang/thumbs/oxEOydR3Q4CD8xZwdNDJ.jpg | media/roberta-jang/thumbs/oxEOydR3Q4CD8xZwdNDJ.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 143 | NULL | 2025-09-14 05:59:58 | 2026-01-01 09:43:09 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/oxEOydR3Q4 | NULL | NULL | NULL | 6 | 0 | 0 | NULL |
| u1VsSmuWROKmOyxoDoWwDg | 사진 | 성화(Sung Wha)와 류석화(Suk Wha Lyu). 하와이 힐로. 1914년경. Marion Lyu Kim 앨범. | 성화, 류석화, Marion Lyu Kim | NULL | media/roberta-jang/original/ShwMJZMwJGZTZTdRkLMO.jpg | NULL | media/roberta-jang/thumbs/ShwMJZMwJGZTZTdRkLMO.jpg | media/roberta-jang/thumbs/ShwMJZMwJGZTZTdRkLMO.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/ShwMJZMwJG | 1914 | NULL | 1914년경 | 3 | 1 | 0 | NULL |
| u1IXVDBTS2G1GQ.3Vd6coA | 사진 | 하와이에서 서재필과 국민회 회원들이 함께 촬영한 사진. 흰색 양복을 입은 사람이 서재필, 왼쪽 끝 임준호(Choon Ho Lim) 목사, 나비매듭 리본을 단 원피스를 입고 있는 사 | 서재필, 임준호, 황혜수, 황사용, 최은희, 윌라 문 정, 정애영, 강영각, 김찬제. | NULL | media/roberta-jang/original/PopVLv0VtXA23fyO0L94.jpg | NULL | media/roberta-jang/thumbs/PopVLv0VtXA23fyO0L94.jpg | media/roberta-jang/thumbs/PopVLv0VtXA23fyO0L94.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/PopVLv0VtX | 1925 | NULL | NULL | 9 | 1 | 1 | NULL |
| Tz8Gx8Y6RbiZelZwvWU51A | NULL | 도로시 김 루디 | 도로시, 김, 루디 | 김경복의 셋째딸 | media/roberta-jang/original/4n7AWhdaosFVK0g14D5p.jpeg | 0000년 | media/roberta-jang/thumbs/4n7AWhdaosFVK0g14D5p.jpeg | media/roberta-jang/thumbs/4n7AWhdaosFVK0g14D5p.jpeg | 김경복,김옥희 | 2025-03-01 00:00:00 | 김경복,김옥희 | 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/4n7AWhdaos | NULL | NULL | NULL | 2 | 0 | 0 | NULL |
| tX6zGt7cQxCkCjaxx6CdHg | NULL | Mrs. Anita Choi의 4세대 (1992) 4 Generations of Anita Choi | Anita Choi | NULL | media/roberta-jang/original/iz7MAGG4esKfsk6HPQZt.jpg | NULL | media/roberta-jang/thumbs/iz7MAGG4esKfsk6HPQZt.jpg | media/roberta-jang/thumbs/iz7MAGG4esKfsk6HPQZt.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 45 | 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/iz7MAGG4es | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| tWSXAkkrT1mxp15LHosdNg | NULL | 국민회 하와이지방총회 창립회원0909년) 앞줄 왼쪽부터 박상하, 정원명(초대회장), 강용수(비서), 뒷줄 안원규(재무), 홍인표(비서), 이내수(부회장), 성용환(총무), 성명미상 | 박상하, 정원명, 강용수, 안원규, 홍인표, 이내수, 성용환, 성명미상. | NULL | media/roberta-jang/original/YLRom763v4psWgdgIYZt.jpg | NULL | media/roberta-jang/thumbs/YLRom763v4psWgdgIYZt.jpg | media/roberta-jang/thumbs/YLRom763v4psWgdgIYZt.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/4lJqMtqjP3 | NULL | 그들의 발자취 | 63 | Independence Hall of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:11:47 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/YLRom763v4 | 909 | NULL | NULL | 8 | 1 | 1 | NULL |
| TuUIqt3eRC60kJOi4cHxxg | 사진 | 하와이·오아후·아후이마누에 위치한 국민군단 훈련기지. 1915년경. | 아후이마누 | NULL | media/roberta-jang/original/R2B51jKkm38mF77GacL9.jpg | NULL | media/roberta-jang/thumbs/R2B51jKkm38mF77GacL9.jpg | media/roberta-jang/thumbs/R2B51jKkm38mF77GacL9.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/R2B51jKkm3 | 1915 | NULL | 1915년경 | 1 | 0 | 0 | NULL |
| tsKfijrdd5sj5HyntnsC | 사진 | Japanese wrecked submarine | NULL | Incheon - Japanese wrecked submarine | media/jungnamyong/original/tsKfijrdd5sj5HyntnsC.jpg | 1945 | media/jungnamyong/thumbs/tsKfijrdd5sj5HyntnsC.jpg | NULL | NULL | NULL | Incheon | NULL | NULL | #2_25_Incheon - Japanese wrecked submarine_1945.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 |
| TRJ.5J30SomFIbl.BVpuUw | NULL | 호나우나우 한인감리교회 헌당식，빅 아일랜드(1917) Korean Methodist Church, Honaunau, Big Island | 호나우나우 한인감리교회 | NULL | media/roberta-jang/original/YUr4S9GeRRxlJS1GpK6G.jpg | NULL | media/roberta-jang/thumbs/YUr4S9GeRRxlJS1GpK6G.jpg | media/roberta-jang/thumbs/YUr4S9GeRRxlJS1GpK6G.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 140 | Mrs. Corol Moisumurd 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/YUr4S9GeRR | NULL | NULL | NULL | 1 | 0 | 0 | NULL |
| tQL0I92Zxe8VkLJfTRnm | 사진 | NULL | NULL | NULL | media/salome-choehan/original/tQL0I92Zxe8VkLJfTRnm.jpg | NULL | media/salome-choehan/thumbs/tQL0I92Zxe8VkLJfTRnm.jpg | NULL | NULL | NULL | NULL | NULL | NULL | 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 |