← back to Paul Conrad Archive
data/conrad.db
19316 lines
SQLite format 3 @ , � , .�� � �
�
�
6� �V�)�`k������� )= indexsqlite_autoindex_books_1books�##�itablecollectionscollectionsCREATE TABLE collections (
id INTEGER PRIMARY KEY, repository TEXT NOT NULL, name TEXT NOT NULL, identifier TEXT, url TEXT,
extent TEXT, date_range TEXT, level TEXT, notes TEXT, source_id TEXT,
UNIQUE (repository, name, identifier))5I# indexsqlite_autoindex_collections_1collections�5%%�-tablepublicationspublicationsCREATE TABLE publications (id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE, date_start TEXT, date_end TEXT,
classification TEXT, notes TEXT)7K% indexsqlite_autoindex_publications_1publications�K--�Itablecartoon_subjectscartoon_subjectsCREATE TABLE cartoon_subjects (cartoon_id INTEGER REFERENCES cartoons(id), subject_id INTEGER REFERENCES subjects(id),
PRIMARY KEY (cartoon_id, subject_id))?S- indexsqlite_autoindex_cartoon_subjects_1cartoon_subjectsf�tablesubjectssubjectsCREATE TABLE subjects (id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE)/C indexsqlite_autoindex_subjects_1subjects�A))�=tablecartoon_peoplecartoon_people
CREATE TABLE cartoon_people (cartoon_id INTEGER REFERENCES cartoons(id), person_id INTEGER REFERENCES people(id),
PRIMARY KEY (cartoon_id, person_id));
O) indexsqlite_autoindex_cartoon_people_1cartoon_people�
�mtablepeoplepeopleCREATE TABLE people (id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE, is_president INTEGER NOT NULL DEFAULT 0)+? indexsqlite_autoindex_people_1peoplea '+indexix_cs_cartooncartoon_sources
CREATE INDEX ix_cs_cartoon ON cartoon_sources(cartoon_id)�;++�-tablecartoon_sourcescartoon_sourcesCREATE TABLE cartoon_sources (
id INTEGER PRIMARY KEY,
cartoon_id INTEGER NOT NULL REFERENCES cartoons(id),
source_id TEXT NOT NULL REFERENCES sources(id),
repository TEXT, collection_name TEXT, identifier TEXT NOT NULL,
box TEXT, folder TEXT, page TEXT,
record_url TEXT, image_url TEXT, thumbnail_url TEXT,
local_image TEXT CHECK (local_image IS NULL), -- copyright rule: images are NEVER stored locally
access_level TEXT, rights_url TEXT, provenance TEXT, retrieved_at TEXT,
UNIQUE (source_id, identifier)
)=Q+ indexsqlite_autoindex_cartoon_sources_1cartoon_sources Z-yindexix_cartoons_grancartoonsCREATE INDEX ix_cartoons_gran ON cartoons(granularity)S-kindexix_cartoons_yearcartoonsCREATE INDEX ix_cartoons_year ON cartoons(year)�K�itablecartoonscartoonsCREATE TABLE cartoons (
id INTEGER PRIMARY KEY,
canonical_id TEXT NOT NULL UNIQUE,
creator TEXT NOT NULL DEFAULT 'Conrad, Paul, 1924-2010',
granularity TEXT NOT NULL CHECK (granularity IN ('item','folder','box_range')),
date_exact TEXT, date_start TEXT, date_end TEXT, year INTEGER,
date_is_estimate INTEGER NOT NULL DEFAULT 0,
title TEXT, caption TEXT, description TEXT, publication TEXT, syndicate TEXT,
medium TEXT, dimensions TEXT, signed_name TEXT, rights_text TEXT, copyright_holder TEXT,
notes TEXT,
merged_into INTEGER REFERENCES cartoons(id), -- NULL = canonical; else points at the canonical cartoon
created_at TEXT NOT NULL, updated_at TEXT NOT NULL
)/C indexsqlite_autoindex_cartoons_1cartoons�`�tablesourcessourcesCREATE TABLE sources (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
repository TEXT,
url TEXT,
classification TEXT CHECK (classification IN ('PUBLIC_API','PUBLIC_HTML','PUBLIC_IMAGE','METADATA_ONLY',
'PAYWALLED','PHYSICAL_ARCHIVE','REQUIRES_PERMISSION')),
status TEXT, -- worked | blocked | seed_only | not_attempted | partial
access_notes TEXT,
notes TEXT,
last_checked TEXT
)-A indexsqlite_autoindex_sources_1sources � ��������� � �-=� - �Q ?wichitaWichita State University Special Collections — MS 90-18Wichita State Universityhttps://archivesspace.wichita.edu/repositories/3/resources/166PHYSICAL_ARCHIVEItem-level ArchivesSpace records (Series 2, 1968-1971); originals viewable in Special Collections.2026-09-24T23:33:19+00:00�}
!�
7a3 � ?ohio_stateOhio State University — Billy Ireland Cartoon Library & MuseumOhio State Universityhttps://osucartoons.pastperfectonline.com/REQUIRES_PERMISSIONHolds Conrad material (per OSU catalog references) but the online collections database refuses automated access (HTTP 403). Request a metadata export from the Billy Ireland reference desk.2026-09-24T23:33:19+00:00�@
�1q#��?oacOnline Archive of California (Huntington finding aid host)Huntington Libraryhttps://oac.cdlib.org/findaid/ark:/13030/c8z03dxd/PUBLIC_HTMLworkedFinding aid only; no digitized Conrad items. Crawl-delay 5 honoured.OAC collection page parsed: 272.41 Linear Feet (285 boxes, 1 folder)2026-09-24T23:33:19+00:00�
{3�!�{�K?locLibrary of Congress — Prints & Photographs (JSON API)Library of Congresshttps://www.loc.gov/photos/?fa=contributor:conrad,%20paul&fo=jsonPUBLIC_APIworkedItem records online; many Conrad drawings are digitized but flagged 'May be restricted: Copyright ... Los Angeles Times' — view at loc.gov (link-out), reproduction needs permission.LOC book records by Conrad: 1; format endpoint found 17 Conrad ids; verified 64 item JSON records; /search + /pictures/search are robots-disallowed (not paged)2026-09-24T23:33:19+00:00�
!�1{-�s�C?huntingtonHuntington Library — Paul Conrad Papers (EAD finding aid)Huntington Libraryhttps://cinco-prd.s3.amazonaws.com/media/ead/conrad.xmlPHYSICAL_ARCHIVEworkedOriginals viewable in the Huntington reading room (reader credentials required). Public EAD lists box-level CON ranges only; the Huntington's internal item database is not public.EAD: 2844 components, 288 boxes, 206 original-drawing boxes; typo repairs: ['box 111: 4890-49152 -> 4890-4912', 'box 137: 5791-5834 -> 5791-5833']; https://catalog.huntington.org/record=b1768021: robots.txt disallows https://catalog.huntington.org/record=b1768021; https://www.huntington.org/verso/volunteering-decipher-paul-conrad: HTTP 429 at https://www.huntington.org/verso/volunteering-decipher-paul-conrad2026-09-24T23:33:19+00:00�yO}'�=�?seedSeed corpus (TK-12179, read-only)multiple/Users/macstudio3/Projects/paul-conrad-cartoons/researchMETADATA_ONLYworkedLocal cached metadata built by paul-conrad-cartoons/scripts/build-corpus.mjs; read-only.huntington_repairs=[{'box': '111', 'was': '4890-49152', 'now': '4890-4912'}, {'box': '137', 'was': '5791-5834', 'now': '5791-5833'}]2026-09-24T23:33:02+00:00� %� 1�'[ ?seed_catalogSeed: hand-built secondary-source catalog (data/cartoons.json)Secondary citation/Users/macstudio3/Projects/paul-conrad-cartoons/data/cartoons.jsonMETADATA_ONLYseed_onlyseed cache; provenance recorded per row2026-09-24T23:33:02+00:00�u'{3�-[ ?seed_syracuseSeed: Syracuse finding-aid cache (raw/syr.html, syr.md)Syracuse Universityhttps://library.syracuse.edu/digital/guides/c/conrad_p.htmPHYSICAL_ARCHIVEseed_onlyseed cache; provenance recorded per row2026-09-24T23:33:02+00:00�%�=� -[ ?seed_wichitaSeed: Wichita State ArchivesSpace cache (raw/wsu/*.md via r.jina.ai)Wichita State Universityhttps://archivesspace.wichita.edu/repositories/3/resources/166PHYSICAL_ARCHIVEseed_onlyseed cache; provenance recorded per row2026-09-24T23:33:02+00:00�_
m3{![ ?seed_locSeed: LOC P&P search cache (raw/loc-page-1.json)Library of Congresshttps://www.loc.gov/pictures/search/?q=Conrad%2C%20PaulPUBLIC_APIseed_onlyseed cache; provenance recorded per row2026-09-24T23:33:02+00:00�^
+]1q-[ ?seed_huntingtonSeed: Huntington EAD slots (corpus.json)Huntington Libraryhttps://oac.cdlib.org/findaid/ark:/13030/c8z03dxd/PHYSICAL_ARCHIVEseed_onlyseed cache; provenance recorded pe �* �"