컬럼 구조
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ExhsqHPQRjm85Erlos8fmg | 사진 | 김순내(Hannah Kim Liu)의 세 아들 봉철(Pong Chul), 샘(Sam), 김봉수(Pong Soo Kim). 릴리하(Liliha) 버클 레인(Buckle Lane)의 | 김순내, 봉철, 샘, 김봉수. | NULL | media/roberta-jang/original/EssuvDySioYgGrTPWtsp.jpg | NULL | media/roberta-jang/thumbs/EssuvDySioYgGrTPWtsp.jpg | media/roberta-jang/thumbs/EssuvDySioYgGrTPWtsp.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/EssuvDySio | 1926 | NULL | NULL | 3 | 0 | 0 |
| EX-vVeECSjaqvMBeAZ4bJw | 사진 | 고종. 1900년경. | 고종 | NULL | media/roberta-jang/original/1G50R9djnh5t52NGa3xb.jpg | NULL | media/roberta-jang/thumbs/1G50R9djnh5t52NGa3xb.jpg | media/roberta-jang/thumbs/1G50R9djnh5t52NGa3xb.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/1G50R9djnh | 1900 | NULL | 1900년경 | 1 | 0 | 0 |
| ev9PSAOEQeyo4qbGi88MEQ | 사진 | 한미연합회의 유권자 등록. 왼쪽 앞이 유권자 등록 신청 진행자 Judy Park. 로스앤젤레스. 2000년. Charles Kim 컬렉션. | Judy Park, Charles Kim | NULL | media/roberta-jang/original/CDrwP41YZYO5hqZjzShY.jpg | NULL | media/roberta-jang/thumbs/CDrwP41YZYO5hqZjzShY.jpg | media/roberta-jang/thumbs/CDrwP41YZYO5hqZjzShY.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/CDrwP41YZY | 2000 | NULL | NULL | 2 | 0 | 0 |
| Etc9cGwhSDezsBObMsYd-A | NULL | “민중승리축하식' 대한인교민단(1932.4.19) Korean Community Association commemorating “Peoples Victory” | 민중승리축하식 대한인교민단 | NULL | media/roberta-jang/original/QBQPXMIOIE57lWpZJ2wQ.jpg | NULL | media/roberta-jang/thumbs/QBQPXMIOIE57lWpZJ2wQ.jpg | media/roberta-jang/thumbs/QBQPXMIOIE57lWpZJ2wQ.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 76 | 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/QBQPXMIOIE | NULL | NULL | NULL | 1 | 0 | 0 |
| erEQYj14TuuhHSBw-OCBNA | 사진 | 대한민국 독립 공채. 현순 목사가 구미위원부의 재무담당자로 기재되어있다. 1920년. 데이비드 현(David Hyun) 컬렉션. | 현순 목사, 데이비드 현(David Hyun) | NULL | media/roberta-jang/original/HRyAErRo00Bs9E81zDNk.jpg | NULL | media/roberta-jang/thumbs/HRyAErRo00Bs9E81zDNk.jpg | media/roberta-jang/thumbs/HRyAErRo00Bs9E81zDNk.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/HRyAErRo00 | 1920 | NULL | NULL | 2 | 0 | 0 |
| eQrMw9tURDWonHEHv0j7pQ | 사진 | 남경식(Kyung Sik Nam) 가족. 왼쪽부터, 조셉(Joseph), 이인옥(In Ok Lee), 프랭크(Frank), 해리(Harry), 루비(Ruby), 로버트(Robert | 남경식, 조셉, 이인옥, 프랭크, 해리, 루비, 로버트 | NULL | media/roberta-jang/original/s9IGCw4Bme4ytT8bjDmh.jpg | NULL | media/roberta-jang/thumbs/s9IGCw4Bme4ytT8bjDmh.jpg | media/roberta-jang/thumbs/s9IGCw4Bme4ytT8bjDmh.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/s9IGCw4Bme | 1930 | NULL | 1930년경 | 7 | 0 | 0 |
| ePWYkepdQ.W8KJovd6j1CQ | NULL | 한국선교회, 회장 : 문또라 Korean Missionary Society, Chairwomen Dora Moon | 문또라 (Dora Moon) | NULL | media/roberta-jang/original/OFZDMaGhJJwJ5ClJzyvn.jpg | NULL | media/roberta-jang/thumbs/OFZDMaGhJJwJ5ClJzyvn.jpg | media/roberta-jang/thumbs/OFZDMaGhJJwJ5ClJzyvn.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 121 | 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/OFZDMaGhJJ | NULL | NULL | NULL | 1 | 0 | 1 |
| EoEQUTcLQ86UB7-3qnDaOQ | NULL | Y.M.C.A. 야간학교(1921) Y.M.C.A. Night School | Y.M.C.A. | NULL | media/roberta-jang/original/FlCn8v2xRYLjURjIxv2f.jpg | NULL | media/roberta-jang/thumbs/FlCn8v2xRYLjURjIxv2f.jpg | media/roberta-jang/thumbs/FlCn8v2xRYLjURjIxv2f.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 185 | 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/FlCn8v2xRY | NULL | NULL | NULL | 1 | 0 | 0 |
| EMmEDsN2QcijT734WvKHAQ | NULL | 호놀룰루 한인감리교회(담임목사 민찬호)는 1906년 미감리교선교회의 도움으로 펀치볼 스트릿에 있는 일본 기숙학교(후에 밀스고등학교) 부지를 사들여 교회와 한인기숙학교 건물로 사용하 | 민찬호, 존슨, 조원시, George Heber Jones, G. Jones | NULL | media/roberta-jang/original/LTgxErz83oJjWZSIvJPI.jpg | NULL | media/roberta-jang/thumbs/LTgxErz83oJjWZSIvJPI.jpg | media/roberta-jang/thumbs/LTgxErz83oJjWZSIvJPI.jpg | NULL | 2025-07-11 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 113 | 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/LTgxErz83o | 1906 | NULL | NULL | 5 | 0 | 1 |
| eMhVkzJyTI2cbPUZ1YJGRg | NULL | 속지 | 속지 | NULL | NULL | NULL | glide:mesh,속지 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 188 | NULL | 2025-09-14 05:59:58 | 2025-12-06 11:09:48 | NULL | NULL | NULL | NULL | 1 | 0 | 0 |
| EM2v7H-cTOaz1BN6Nz-K5w | 사진 | 구미위원부가 판매한 공채의 영수증. 1922. Mildred Chun Thomas 앨범. | Mildred Chun Thomas | NULL | media/roberta-jang/original/HaBteZGsSEpQdsTstSRh.jpg | NULL | media/roberta-jang/thumbs/HaBteZGsSEpQdsTstSRh.jpg | media/roberta-jang/thumbs/HaBteZGsSEpQdsTstSRh.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:09:48 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/HaBteZGsSE | NULL | NULL | NULL | 1 | 0 | 0 |
| eEVzh5Z2TzicgqeFHVtb8w | 사진 | 마조리 김 리. 1954년경. 안젤린 리(Angeline Lee) 앨범. | 마조리 김 리, 안젤린 리 | NULL | media/roberta-jang/original/k5xmJVHI96hoirG2f8HA.jpg | NULL | media/roberta-jang/thumbs/k5xmJVHI96hoirG2f8HA.jpg | media/roberta-jang/thumbs/k5xmJVHI96hoirG2f8HA.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:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/k5xmJVHI96 | 1954 | NULL | 1954년경 | 2 | 0 | 0 |
| EDps.Wd5QQynOWBmSSzL5g | NULL | 새해를 맞아 교인들이 한데모여 떡을 만들고 있다. 제일한인감리교회 (1952) Making Dduk (rice cake) for New Year’s Day at the First | 제일한인감리교회 | NULL | media/roberta-jang/original/wcWhSzST2tnXQ3N4RAue.jpg | NULL | media/roberta-jang/thumbs/wcWhSzST2tnXQ3N4RAue.jpg | media/roberta-jang/thumbs/wcWhSzST2tnXQ3N4RAue.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/eCXn6cbM8A | NULL | 그들의 발자취 | 124 | Pev. 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/wcWhSzST2t | NULL | NULL | NULL | 1 | 0 | 0 |
| e6afjVYMS2W6WZJzFyRMvw | NULL | 하와이 땅에 새로운 삶의 터전을 마련한 이민선조들은 자라나는 2세들을 남부럽지 않게 성장시키기 위해 각고의 노력을 아끼지 않았다. 한인기독교회 주일학교 어린이들의 밝은 모습에서 오 | 이민선조들 | NULL | media/roberta-jang/original/MyvjtfUOmZ21jGd1jutH.jpg | NULL | media/roberta-jang/thumbs/MyvjtfUOmZ21jGd1jutH.jpg | media/roberta-jang/thumbs/MyvjtfUOmZ21jGd1jutH.jpg | NULL | 2025-07-12 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 157 | Dr. Alice Yun Cha. Collection | 2025-09-14 05:59:58 | 2025-12-06 11:10:31 | https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/ZtpsvjPXDAbQsOEnFWzB/pub/MyvjtfUOmZ | 1926 | NULL | 1926년경 | 1 | 0 | 0 |
| e4lUS1amQFK7vmewRUdnwQ | 사진 | 한인 감리교회. 1933년. 로버타 장 컬렉션. | 로버타 장 | NULL | media/roberta-jang/original/2tFmNYDGVjJePp7rjy9e.jpg | NULL | media/roberta-jang/thumbs/2tFmNYDGVjJePp7rjy9e.jpg | media/roberta-jang/thumbs/2tFmNYDGVjJePp7rjy9e.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/2tFmNYDGVj | 1933 | NULL | NULL | 1 | 0 | 0 |
| E1e2KVGiQKCx-HbyshaatA | NULL | 1924년 도착한 서복덕씨 자매 （오른쪽） ，서복덕씨는 한인기독교회와 동지회 발전에 기여하였다. Bok Dok Sur and sister arrived in 1924 | 서복덕씨, Bok Dok Sur | NULL | media/roberta-jang/original/AyiwIe710ymsRXKc135p.jpg | NULL | media/roberta-jang/thumbs/AyiwIe710ymsRXKc135p.jpg | media/roberta-jang/thumbs/AyiwIe710ymsRXKc135p.jpg | NULL | 2025-07-10 00:00:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 그들의 발자취 | 54 | 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/AyiwIe710y | 1924 | NULL | NULL | 2 | 0 | 0 |
| dWqvpwV5QI24.TA9UYEXng | NULL | 면(전) 댄，추복등씨 결혼사진(1924) Mr. & Mrs. Dan (Phyllis Bok Dung) Dunn | 댄, 추복등씨 | NULL | media/roberta-jang/original/Vi5ZdFcVVkH4cHWcLNMu.jpg | NULL | media/roberta-jang/thumbs/Vi5ZdFcVVkH4cHWcLNMu.jpg | media/roberta-jang/thumbs/Vi5ZdFcVVkH4cHWcLNMu.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/kuSWAvCfB5 | NULL | 그들의 발자취 | 52 | Dr Jackie Young 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/Vi5ZdFcVVk | NULL | NULL | NULL | 1 | 0 | 0 |
| dsQAEB6fTIKKwA7bUoHtNg | 사진 | 강영옥, 최인호(In Ho Choi), 차승현(Sung Hyun Cha). 1918년. Richard Lee와 Annie Lee Tom 앨범. | 강영옥, 최인호, 차승현, Richard Lee, Annie Lee Tom | NULL | media/roberta-jang/original/DQunfE2ZgBI0GTOFa1Nq.jpg | NULL | media/roberta-jang/thumbs/DQunfE2ZgBI0GTOFa1Nq.jpg | media/roberta-jang/thumbs/DQunfE2ZgBI0GTOFa1Nq.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/DQunfE2ZgB | 1918 | NULL | NULL | 5 | 0 | 0 |
| Ds.TGgi-SuWUPhaNWM836Q | 사진 | 국민군단은 파인애플을 재배하기 위해 토지를 경작하였다, 1941년경. 앞줄 왼쪽에서 두 번째 안원규, 세 번째 박용만. 천안 독립기념관 컬렉션. | 안원규, 박용만 | NULL | media/roberta-jang/original/pzg0SuAQaBl4pEeelMUv.jpg | NULL | media/roberta-jang/thumbs/pzg0SuAQaBl4pEeelMUv.jpg | media/roberta-jang/thumbs/pzg0SuAQaBl4pEeelMUv.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/pzg0SuAQaB | 1941 | NULL | 1941년경 | 2 | 1 | 1 |
| DnMnCSEhQxqRwqGF3QrAyQ | 사진 | 전명운과 그의 두 딸 마가렛 필즈 (표)(Margaret Fields (Pyo))와 로즈 마리 전 (리)(Rosemary Chun (Lee)). 전명운도 1905년 하와이에서 샌프 | 전명운, 마가렛 필즈, 로즈 마리 전 | NULL | media/roberta-jang/original/8lLLK7TM4O1YW6raBtJn.jpg | NULL | media/roberta-jang/thumbs/8lLLK7TM4O1YW6raBtJn.jpg | media/roberta-jang/thumbs/8lLLK7TM4O1YW6raBtJn.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/8lLLK7TM4O | 1905 | 1905년대 | NULL | 3 | 1 | 0 |