컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a.33bML39TDuqErJTPvo5FA | NULL | 외국인 등록증 Specimen form - alien registration | 외국인 등록증 | NULL | media/roberta-jang/original/E5mraTSWlDmahbhCaXmH.jpg | NULL | media/roberta-jang/thumbs/E5mraTSWlDmahbhCaXmH.jpg | media/roberta-jang/thumbs/E5mraTSWlDmahbhCaXmH.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 202 | 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/E5mraTSWlD | NULL | NULL | NULL | 1 | 0 | 0 |
| a.2F2N-EQTnqbb1U2a8T7qw | NULL | 박용만장군 (1914년경) Mr. Yong Man Park riding his horse (Circa 1914) | 박용만장군 | NULL | media/roberta-jang/original/6jIvuXXYYMpbJwPhKB0s.jpg | NULL | media/roberta-jang/thumbs/6jIvuXXYYMpbJwPhKB0s.jpg | media/roberta-jang/thumbs/6jIvuXXYYMpbJwPhKB0s.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/imrvpTvv9x | NULL | 그들의 발자취 | 68 | Independence Hall of Korea | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/6jIvuXXYYM | 1914 | NULL | 1914년경 | 1 | 0 | 0 |
| a.0s2tGgMT-KWr0QtwaRKVw | 사진 | 1923년에 발급된 출생증명서. 정기화(Charles Ki Wha Chung) 앨범. | Charles Ki Wha Chung | NULL | media/roberta-jang/original/8326XYosf9RFzNERk36c.jpg | NULL | media/roberta-jang/thumbs/8326XYosf9RFzNERk36c.jpg | media/roberta-jang/thumbs/8326XYosf9RFzNERk36c.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/8326XYosf9 | 1923 | NULL | NULL | 1 | 0 | 0 |
| a.0lk-9sSRQS6SzBSRRYTWg | 사진 | 한국 해방운동을 지원한 호머 헐버트와 하와이에서 건너온 3명의 한인 학생들. 왼쪽부터, 북아메리카 한인학생연합의 회장인 이병두(William Pyong Doo Lee), 양유찬(Y | 호머 헐버트, 이병두, 양유찬, 김계봉, 김영기. | NULL | media/roberta-jang/original/uqtTZ5BAXs1MnUWyBeF5.jpg | NULL | media/roberta-jang/thumbs/uqtTZ5BAXs1MnUWyBeF5.jpg | media/roberta-jang/thumbs/uqtTZ5BAXs1MnUWyBeF5.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/uqtTZ5BAXs | 1920 | NULL | 1920년경 | 5 | 0 | 0 |
| a.-QTrTMOTra8eNi6lIcneg | 사진 | 미국 세관이 발급해준 출입허가증. | 이 문장에는 이름이 포함되어 있지 않습니다. | 이민 한인들을 돕기 위해 샌프란시스코 엔젤 아일랜드(Angel Island)로 들어와도 좋다는 허가증이다. 1933년경. 백일규는 그 당시 국민회(KNA) 회장이었다. Mabel | media/roberta-jang/original/Bm76x9OXWQVPDtUSR52J.jpg | NULL | media/roberta-jang/thumbs/Bm76x9OXWQVPDtUSR52J.jpg | media/roberta-jang/thumbs/Bm76x9OXWQVPDtUSR52J.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/Bm76x9OXWQ | NULL | NULL | NULL | 1 | 0 | 0 |
| a-kJKAPpCSPOPXI9TLFPAGw | 사진 | 호놀롤루의 감리교회 앞에 서 있는 한국인들. 1904년경. | 한국인들 | NULL | media/roberta-jang/original/WHML37wNL1NAbybjl35z.jpg | NULL | media/roberta-jang/thumbs/WHML37wNL1NAbybjl35z.jpg | media/roberta-jang/thumbs/WHML37wNL1NAbybjl35z.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/WHML37wNL1 | 1904 | NULL | 1904년경 | 1 | 0 | 0 |
| a-1Ekka9dRkGFrOyFzUrruQ | NULL | 재미한족연합위원회 별보(1946) Special issue newsletter of the United Korean Committee in America | 재미한족연합위원회 | NULL | media/roberta-jang/original/HDl81LahtPFKt5rAzDW2.jpg | NULL | media/roberta-jang/thumbs/HDl81LahtPFKt5rAzDW2.jpg | media/roberta-jang/thumbs/HDl81LahtPFKt5rAzDW2.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 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/HDl81LahtP | NULL | NULL | NULL | 1 | 0 | 0 |
| a-0ZvB.-PSASM1xnDxa2iAw | NULL | 호항(호놀룰루) 한인기독교회 신도 일동(1938) Honolulu Korean Christian Church congregation | 호항(호놀룰루) 한인기독교회 신도 일동 | NULL | media/roberta-jang/original/NMfgJqZlsk3vsaiw8ukg.jpg | NULL | media/roberta-jang/thumbs/NMfgJqZlsk3vsaiw8ukg.jpg | media/roberta-jang/thumbs/NMfgJqZlsk3vsaiw8ukg.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/Rzkg7SQrQq | NULL | 그들의 발자취 | 161 | 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/NMfgJqZlsk | NULL | NULL | NULL | 1 | 0 | 0 |
| 9xNaB3xeTIOBDDc168qUiA | 사진 | 정두옥(Doo Ok Chung)의 미국 귀화증. 1961년 3월 16일. 제2차 세계대전 이후 나이가 많은 하와이 한인들은 한국을 방문하고 싶은 마음에 귀화 신청을 많이 하였다. | 정두옥 | NULL | media/roberta-jang/original/FkpsXzIHzxC3V5wmjpx1.jpg | NULL | media/roberta-jang/thumbs/FkpsXzIHzxC3V5wmjpx1.jpg | media/roberta-jang/thumbs/FkpsXzIHzxC3V5wmjpx1.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/FkpsXzIHzx | 1961 | NULL | NULL | 1 | 0 | 1 |
| 9v4e2yHnTdi0FCckTidPTQ | 사진 | 최정애 군정여권，하와이 출신 군정외무부 부장서리 월터 정 싸인 (1943) Passport issued to Mrs. Chung Ai Choy by United States Arm | 최정애, 월터 정 | NULL | media/roberta-jang/original/3MfhwuH5iA6WYfkj3GRC.jpeg | NULL | media/roberta-jang/thumbs/3MfhwuH5iA6WYfkj3GRC.jpeg | media/roberta-jang/thumbs/3MfhwuH5iA6WYfkj3GRC.jpeg | 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/GiAL2aiewR | NULL | 그들의 발자취 | 22 | 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/3MfhwuH5iA | NULL | NULL | NULL | 2 | 0 | 0 |
| 9NoIjrr7QpCBbAooontb-w | 사진 | 카우아이 그로브 농장(Grove Farm)의 농장 숙소. 1924년 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/V8jtHP0kseEtDRETenP3.jpg | NULL | media/roberta-jang/thumbs/V8jtHP0kseEtDRETenP3.jpg | media/roberta-jang/thumbs/V8jtHP0kseEtDRETenP3.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/V8jtHP0kse | 1924 | NULL | NULL | 1 | 0 | 0 |
| 9nkzG4jITc2OKvVJ..hPTw | 사진 | 농장마을 공동빨래터에서 세탁하는 여인，에바농장(1908) Ewa Plantation community laundry -Mrs. Kelly Yoon Ock.Kim Collection | 에바농장, Mrs. Kelly Yoon Ock. Kim | NULL | media/roberta-jang/original/50tg2mVwHVTKult1njJ8.jpg | NULL | media/roberta-jang/thumbs/50tg2mVwHVTKult1njJ8.jpg | media/roberta-jang/thumbs/50tg2mVwHVTKult1njJ8.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/MhnFFn1d0J | NULL | 그들의 발자취 | 36 | 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/50tg2mVwHV | NULL | NULL | NULL | 2 | 0 | 0 |
| 9I9sbVGbRxObYy1KmlUDew | 사진 | 목사 부인인 하젤 박 정(Hazel Pahk Chung, 중앙 오른쪽)이 지도한 한인 감리교회의 요리실습반. Elsie Park(중앙 왼쪽), 시계 방향으로 왼쪽에서 네 번째가 K | 하젤 박 정, Elsie Park, Katherine Kim, Katherine Lee, Agnes Pahk Kwon, Victoria Shin, 강영옥. | NULL | media/roberta-jang/original/ybeMCvdozCLWUp5PJTIm.jpg | NULL | media/roberta-jang/thumbs/ybeMCvdozCLWUp5PJTIm.jpg | media/roberta-jang/thumbs/ybeMCvdozCLWUp5PJTIm.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:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/ybeMCvdozC | NULL | NULL | NULL | 7 | 0 | 0 |
| 98OpI3h3Qt-XlZNyAc5JcA | NULL | 그리스도연합감리교회(Christ United Methodist Church) 해외에 설립된 초창기 한인교회, 에바한인 감리교회, 초대목사 김영식 （1905.4,30 창 립＞한인이민 | 김영식, 임정수, 김이제, 민잔호 | NULL | media/roberta-jang/original/0XEUUwJ3JE55s9INgjm2.jpg | NULL | media/roberta-jang/thumbs/0XEUUwJ3JE55s9INgjm2.jpg | media/roberta-jang/thumbs/0XEUUwJ3JE55s9INgjm2.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/GaTBJcIFLr | NULL | 그들의 발자취 | 111 | 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/0XEUUwJ3JE | 1905 | NULL | NULL | 4 | 1 | 1 |
| 8qKCSU6ESWO1ywDOFCRZIA | NULL | 교회건축기금 마련운동 Building Fund Campaign of Olive United Methodist Church | Olive United Methodist Church | NULL | media/roberta-jang/original/zzPUTtSaftAIvrpZ0mFb.jpg | NULL | media/roberta-jang/thumbs/zzPUTtSaftAIvrpZ0mFb.jpg | media/roberta-jang/thumbs/zzPUTtSaftAIvrpZ0mFb.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/cz3HZpFiz2 | NULL | 그들의 발자취 | 135 | 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/zzPUTtSaft | NULL | NULL | NULL | 1 | 0 | 0 |
| 8oot30xMQM2-heMTjEGlQQ | 사진 | 일요일 외출 허가를 받고 나가는 병사들. 1916년. 천안 독립기념관. | 병사들 | NULL | media/roberta-jang/original/bd3SRbRTij0skK9hnFXI.jpg | NULL | media/roberta-jang/thumbs/bd3SRbRTij0skK9hnFXI.jpg | media/roberta-jang/thumbs/bd3SRbRTij0skK9hnFXI.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/bd3SRbRTij | 1916 | NULL | NULL | 1 | 0 | 0 |
| 8nF95re4T0a6YYueJOaXHg | NULL | 빅아일랜드 이승만박사 숙소(1925 —1929) Dr. Rhee's residence on the Big Island, Charcoal Production Period. | 이승만박사 | NULL | media/roberta-jang/original/51ft0HeS85sLeK4cUpmn.jpg | NULL | media/roberta-jang/thumbs/51ft0HeS85sLeK4cUpmn.jpg | media/roberta-jang/thumbs/51ft0HeS85sLeK4cUpmn.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/nXI8FwKdve | NULL | 그들의 발자취 | 84 | 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/51ft0HeS85 | NULL | NULL | NULL | 1 | 0 | 0 |
| 8l4AXYgsSuelsPkwlgvMWg | 사진 | 강영각(Donald Young Gak Kang, 오른쪽 끝에 서 있는 사람), 안창호(Chang Ho Ahn) 목사(오른쪽에서 두번째, 서 있는 사람), 정기화(Charles Ki | 강영각, 안창호, 정기화 | NULL | media/roberta-jang/original/15DcJGypz27hsKRN4CGk.jpg | NULL | media/roberta-jang/thumbs/15DcJGypz27hsKRN4CGk.jpg | media/roberta-jang/thumbs/15DcJGypz27hsKRN4CGk.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/15DcJGypz2 | 1930 | NULL | NULL | 3 | 0 | 1 |
| 8btgweCjTKi9r-yDzby17A | 사진 | 윌라(Wihla (Chung))와 도라 김 문. 1915년경. 민병용 컬렉션. | 윌라, 도라 김, 민병용 | 도라 김 문은 감리교회의 도움으로 딸, 윌라와 함께 왔다. 어머니와 딸 모두 선교 사업에 전념하였다. | media/roberta-jang/original/jERwlhopH9IGfjYMU7ZZ.jpg | NULL | media/roberta-jang/thumbs/jERwlhopH9IGfjYMU7ZZ.jpg | media/roberta-jang/thumbs/jERwlhopH9IGfjYMU7ZZ.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/jERwlhopH9 | 1915 | NULL | 1915년경 | 3 | 0 | 0 |
| 8BDJxN5AToW4KEywHKCwdQ | 사진 | 홍치범(Chi Pum Hong)과 애굔 김 홍(Agyon Kim Hong). 1910년대경. 천안 독립기념관 컬렉션. | 홍치범, 애굔 김 홍 | NULL | media/roberta-jang/original/DNMMirBQa7IuyUPwgFot.jpg | NULL | media/roberta-jang/thumbs/DNMMirBQa7IuyUPwgFot.jpg | media/roberta-jang/thumbs/DNMMirBQa7IuyUPwgFot.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/DNMMirBQa7 | 1910 | 1910년대 | NULL | 2 | 1 | 1 |