컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IWA0fzKqT9-17PAe4ljAxw | NULL | 대한부인구제회(1952) Korean Women;s Relief Society -Mr. Donald Kim Collection | 대한부인구제회 (Korean Women's Relief Society) - Mr. Donald Kim | NULL | media/roberta-jang/original/VqzFpsK0fajDKQo2Z7AI.jpg | NULL | media/roberta-jang/thumbs/VqzFpsK0fajDKQo2Z7AI.jpg | media/roberta-jang/thumbs/VqzFpsK0fajDKQo2Z7AI.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 101 | 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/VqzFpsK0fa | NULL | NULL | NULL | 1 | 0 | 0 |
| IUbv8dEwTP-zOqeat24i-g | NULL | 고종황제 탄신 기념행사, 에바농장(1907) Emperor Kojong’s birthday celebration, Ewa Plantation | 고종황제, 에바농장 | NULL | media/roberta-jang/original/GIqe5Qqkc4zKyBAA9Ywg.jpg | NULL | media/roberta-jang/thumbs/GIqe5Qqkc4zKyBAA9Ywg.jpg | media/roberta-jang/thumbs/GIqe5Qqkc4zKyBAA9Ywg.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 41 | 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/GIqe5Qqkc4 | NULL | NULL | NULL | 2 | 0 | 0 |
| iu7c7hT-QFiu.tZP2Wu8PA | 사진 | 동지회의 임원들. 교민단이 해체된 직후 1930년에 동지회가 공식적으로 결성되었다. 왼쪽부터, 황원태(Won Tai Whang), 최성대(Sungdai Choi), 김학성(Hark | 1. 황원태 2. 최성대 3. 김학성 4. 김유실 5. 김영기 6. 이승만 7. 강영복 8. 양유찬 9. 노디 김해김 손 10. 이원순 11. 전영복 12. 서기문 | NULL | media/roberta-jang/original/pTz4eCIstfILP57ezZic.jpg | NULL | media/roberta-jang/thumbs/pTz4eCIstfILP57ezZic.jpg | media/roberta-jang/thumbs/pTz4eCIstfILP57ezZic.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/pTz4eCIstf | 1930 | NULL | 1930년경 | 12 | 1 | 1 |
| IRh6nsFWTnWKJzpsbkHQYg | NULL | 동안클럽 (Dong Ahn Club) 동안클럽, 목쿨레아 수잔나 웨슬리 용에서 창립 5주년 기념식 (1932) Dong Ahn Club gathered at Mokuleia, Oa | 동안클럽 (Dong Ahn Club) | NULL | media/roberta-jang/original/nCwnZqfCKbb7oImUMfnP.jpg | NULL | media/roberta-jang/thumbs/nCwnZqfCKbb7oImUMfnP.jpg | media/roberta-jang/thumbs/nCwnZqfCKbb7oImUMfnP.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 104 | Alexander and Baldwin Inc 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/nCwnZqfCKb | NULL | NULL | NULL | 1 | 0 | 0 |
| iqTgHHb9Q-KHhp3JsmwIXg | 사진 | 아이네즈 공(Inez Kon(Pai)), 안숙진(Sook Chin Ahn Kong, 어머니), 존 공(John Kong). 금강산. 1935년. 아이네즈 공 배 앨범. | 아이네즈 공, 안숙진, 존 공 | NULL | media/roberta-jang/original/I8JLIuWokEG7EDWJJsFn.jpg | NULL | media/roberta-jang/thumbs/I8JLIuWokEG7EDWJJsFn.jpg | media/roberta-jang/thumbs/I8JLIuWokEG7EDWJJsFn.jpg | 공치순 | 2025-04-19 00:00:00 | 공치순 | 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/I8JLIuWokE | 1935 | NULL | NULL | 3 | 0 | 0 |
| IPFf6RbRQniLGJl30js.mw | NULL | 체육대회를 마치고(1912) Picture taken at Boys Field Kauluwela | 체육대회 | NULL | media/roberta-jang/original/JkWhdoBMHQ1W2QjQVT4d.jpg | NULL | media/roberta-jang/thumbs/JkWhdoBMHQ1W2QjQVT4d.jpg | media/roberta-jang/thumbs/JkWhdoBMHQ1W2QjQVT4d.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 182 | 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/JkWhdoBMHQ | NULL | NULL | NULL | 1 | 0 | 0 |
| InpvXG8oTSK13G69lTJUww | NULL | 김온진 사진신부의 검역증 (1915) Inspection Card 一 Mrs. On Chin Kim Hong | 김온진 | NULL | media/roberta-jang/original/sltuGTudVl4P0GwxlgQq.jpg | NULL | media/roberta-jang/thumbs/sltuGTudVl4P0GwxlgQq.jpg | media/roberta-jang/thumbs/sltuGTudVl4P0GwxlgQq.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/1GnBImyV6J | NULL | 그들의 발자취 | 59 | 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/sltuGTudVl | NULL | NULL | NULL | 1 | 0 | 0 |
| iLQrrt0OTIuCGWTe2n57Qw | NULL | 문대양 주대법원장의 외할아버지 이만기씨 가족사진 Hon. Chief Justice Ronald Moon's grandfather Man Kee Lee and family | 문대양, 이만기, Ronald Moon | NULL | media/roberta-jang/original/mPLsCNxSIOnMHcZHETlx.jpg | NULL | media/roberta-jang/thumbs/mPLsCNxSIOnMHcZHETlx.jpg | media/roberta-jang/thumbs/mPLsCNxSIOnMHcZHETlx.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 42 | Daisy Choi 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/mPLsCNxSIO | NULL | NULL | NULL | 3 | 1 | 0 |
| ilfVnxtURru3Zr69.3Ddkg | 사진 | 한국에 머문 국제 외교관들과 호레이스 알렌 박사(중앙). 1899년경. 천안 독립기념관 컬렉션. | 호레이스 알렌 박사 | NULL | media/roberta-jang/original/s9mnuKdXiC5m0nzq4oJo.jpg | NULL | media/roberta-jang/thumbs/s9mnuKdXiC5m0nzq4oJo.jpg | media/roberta-jang/thumbs/s9mnuKdXiC5m0nzq4oJo.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/s9mnuKdXiC | 1899 | NULL | 1899년경 | 1 | 0 | 0 |
| iKKn8Iz5SQOE.7ty2Qh68g | 사진 | 대한항공 858기 폭파사건을 규탄하는 시위. 1986년. 『 코리아타임스』. | 대한항공 858기 폭파사건 | NULL | media/roberta-jang/original/Q2CpueRBPgEuCDMKGCtg.jpg | NULL | media/roberta-jang/thumbs/Q2CpueRBPgEuCDMKGCtg.jpg | media/roberta-jang/thumbs/Q2CpueRBPgEuCDMKGCtg.jpg | 도로시, 김, 루디 | 2025-04-19 00:00:00 | 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/Q2CpueRBPg | 1986 | NULL | NULL | 1 | 0 | 0 |
| ikeynV.mQXerOhFociopLw | NULL | 한라 배 함 여사 (1950) Halla Pai Huhm | 한라 배 함 여사 (Halla Pai Huhm) | NULL | media/roberta-jang/original/FjytPxA2UbzTi23s0ZNZ.jpg | NULL | media/roberta-jang/thumbs/FjytPxA2UbzTi23s0ZNZ.jpg | media/roberta-jang/thumbs/FjytPxA2UbzTi23s0ZNZ.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 195 | Dr. Alice Yun Chai 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/FjytPxA2Ub | NULL | NULL | NULL | 1 | 0 | 0 |
| ijSvxK18QHGF0RZ9CdxUPg | 사진 | 와이파후 한인 감리교회 집회. 김이제(Yee Chai Kim) 목사(왼쪽 끝). 1906년. 민병용 컬렉션. | 김이제 | NULL | media/roberta-jang/original/5FUcFohsROKwNxFq3D40.jpg | NULL | media/roberta-jang/thumbs/5FUcFohsROKwNxFq3D40.jpg | media/roberta-jang/thumbs/5FUcFohsROKwNxFq3D40.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/5FUcFohsRO | 1906 | NULL | NULL | 1 | 1 | 0 |
| IhOInI5FTUCseEwpzSvDQQ | NULL | 대한민국 공채 Certificate of Indebtedness | 대한민국 | NULL | media/roberta-jang/original/DXnFgU2wUPTco7VHpMVA.jpg | NULL | media/roberta-jang/thumbs/DXnFgU2wUPTco7VHpMVA.jpg | media/roberta-jang/thumbs/DXnFgU2wUPTco7VHpMVA.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/JqON5N2iu3 | NULL | 그들의 발자취 | 205 | 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/DXnFgU2wUP | NULL | NULL | NULL | 1 | 0 | 0 |
| iFOx0kilSy2ehD2vI0Ce0Q | 사진 | 한인 기독교회는 해방후 최초로 하와이로 유학온 학생들을 환영하였다. (1947) First Korean students to arrive in 1947, after the libe | 1. Unknown 2. Chang Kyo Kim 3. Bok Cha Kim 4. Veronica Park 5. Samuel Lee 6. Choun Yung Le | NULL | media/roberta-jang/original/ZUJeiswZaN9BoMKkRrnm.jpg | NULL | media/roberta-jang/thumbs/ZUJeiswZaN9BoMKkRrnm.jpg | media/roberta-jang/thumbs/ZUJeiswZaN9BoMKkRrnm.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 31 | 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/ZUJeiswZaN | NULL | NULL | NULL | 6 | 0 | 0 |
| iFapT3iaTV2zCPhpNNUeEw | NULL | 한인 2세 델타클럽 (1992년 창립) Delta Club - Dr Won Sik You Collection 1. Paul Young 2. James Yue 3. Harry Cho | 1. Paul Young 2. James Yue 3. Harry Cho 4. William Choi 5. Flora Choi 6. Matthew Pyun 7. Unknown 8. | NULL | media/roberta-jang/original/dAqyqw4jzL5nxa5GBZzY.jpg | NULL | media/roberta-jang/thumbs/dAqyqw4jzL5nxa5GBZzY.jpg | media/roberta-jang/thumbs/dAqyqw4jzL5nxa5GBZzY.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 107 | 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/dAqyqw4jzL | 1992 | NULL | NULL | 17 | 0 | 0 |
| Ic-L6GnhRhWsT7j.FkKg2g | NULL | 고 홍치호씨가 기증한 종각의 모습 Bell donated by the late Mr. Chi Ho Hong | 홍치호 | NULL | media/roberta-jang/original/ajXZwQLv0WojMPIO4znV.jpg | NULL | media/roberta-jang/thumbs/ajXZwQLv0WojMPIO4znV.jpg | media/roberta-jang/thumbs/ajXZwQLv0WojMPIO4znV.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 148 | Dr. 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/ajXZwQLv0W | NULL | NULL | NULL | 1 | 0 | 0 |
| IAFaP1hGQ6iWTo0C3Grz0A | NULL | 독립금 공고서, 재미한족연합위원회 의사부 Financial report of the United Korean Committee in America | 독립금 공고서, 재미한족연합위원회 | NULL | media/roberta-jang/original/LNqLLlLtUXczVXJSoKwE.jpg | NULL | media/roberta-jang/thumbs/LNqLLlLtUXczVXJSoKwE.jpg | media/roberta-jang/thumbs/LNqLLlLtUXczVXJSoKwE.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/jLlW8i7so3 | NULL | 그들의 발자취 | 79 | independence Holl 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/LNqLLlLtUX | NULL | NULL | NULL | 2 | 0 | 0 |
| i8WorUXzQcaXPeFFyjOosQ | 사진 | 하와이 힐로. | 하와이 힐�� | 왼쪽부터, 김영신(Young Sin Kim)과 김명근(Myong Kun Kim, 자매), 살로메 김(Solome Kim, 김영신의 딸), 박종수(Chong Soo Park), An | media/roberta-jang/original/rOakS6uBl0Mg5CpoxUl8.jpg | NULL | media/roberta-jang/thumbs/rOakS6uBl0Mg5CpoxUl8.jpg | media/roberta-jang/thumbs/rOakS6uBl0Mg5CpoxUl8.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/rOakS6uBl0 | NULL | NULL | NULL | 1 | 0 | 0 |
| I8iYHTA8RaWjimyuwVcv1A | NULL | 사진신부 정영옥，1918년 사진결혼 이민 Mrs. Young Ok Chung | 정영옥, Young Ok Chung | NULL | media/roberta-jang/original/CI7Z9dU0F5f2Xi6s7a6K.jpg | NULL | media/roberta-jang/thumbs/CI7Z9dU0F5f2Xi6s7a6K.jpg | media/roberta-jang/thumbs/CI7Z9dU0F5f2Xi6s7a6K.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/5FOSRQrWU3 | NULL | 그들의 발자취 | 56 | 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/CI7Z9dU0F5 | 1918 | NULL | NULL | 2 | 0 | 0 |
| I8B4x6H1QgmhMPBZue-ZUA | NULL | 한인이민초 헌신적인 교역자들의 노력으로 한인들의 신앙이 불타기 시작했다. 민찬호, 홍치범 목사 가족(연도미상) Christianity spread among the early Ko | 민찬호, 홍치범 | NULL | media/roberta-jang/original/0vfgREbrmojyQPqHGCop.jpg | NULL | media/roberta-jang/thumbs/0vfgREbrmojyQPqHGCop.jpg | media/roberta-jang/thumbs/0vfgREbrmojyQPqHGCop.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/H8O0yGmIK9 | NULL | 그들의 발자취 | 43 | Dr Thomas Min 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/0vfgREbrmo | NULL | NULL | NULL | 2 | 1 | 1 |