One6Project Source Directory
Overview
This file is a structured catalog of the source corpus from /Volumes/Photo SSD/Dropbox/One6Project/. It documents what is in the corpus, where it came from, what shape it is in, and what aspects of the Patriot University knowledge base each component feeds. The corpus is the foundation of the Workstream-1 (Accountability KB) and Workstream-2 (research-document semantic search) work.
Status: Living document. Last updated 2026-05-06.
Scope: This file is internal-facing reference material describing where information comes from, not the substantive content. The substantive content lives in the rosters and deep profiles in accountability/ and in the research_documents PostgreSQL table once Workstream 2 is implemented.
Directory Layout
/Volumes/Photo SSD/Dropbox/One6Project/
├── A2Site/
│ ├── exports/
│ │ └── FullExport.csv (2.75MB; 25,419 rows; Solr index export)
│ └── home/pedro/
│ └── taxonomies/
│ ├── feedkeywords
│ ├── fox_hosts (161 names)
│ ├── oan_hosts (8 names)
│ ├── organizations (444 entries — SPLC + dark money + media)
│ ├── pacs (41 PACs)
│ ├── people (~570 names — combined roster)
│ ├── republican_people (94 names — coup-adjacent)
│ ├── republicans (79 names — J6-specific operative cluster)
│ ├── spls-cities.csv (SPLC tracked cities)
│ ├── spls-groups.csv (SPLC tracked hate groups)
│ ├── spls-states.csv (SPLC tracked states)
│ └── trump_donors (88 names — major Trump donors)
├── docs/ (Reference PDFs and OPMLs)
└── resources/ (Spreadsheets and ancillary data)
Component-by-Component Catalog
A2Site/exports/FullExport.csv (Document Corpus)
- Size: 2.75 MB; 25,419 rows + header
- Format: CSV with two columns:
path0_s(domain),id(URL) - Purpose: Solr index export from the original One6Project Solr instance; this is the master URL list of indexed sources
- Contains: Wikipedia entries on individuals/organizations/concepts; Stanford Encyclopedia of Philosophy entries; news articles; government-source URLs; SPLC profiles; Federal Register entries
- Use in Patriot University: Workstream 2 ingests this list to fetch and embed the actual content into PostgreSQL
research_documentstable; ID becomessource_id
A2Site/exports/FullExport.xlsx
- Size: 1.23 MB
- Format: Excel with same data as CSV plus richer metadata columns
- Use: Reference / verification
Taxonomies (A2Site/home/pedro/taxonomies/)
| File | Count | Description | Patriot KB output |
|---|---|---|---|
feedkeywords |
(varies) | RSS keyword list | (RSS reference; not indexed yet) |
fox_hosts |
161 | Fox News on-air personnel | Right-Wing Media Figures |
oan_hosts |
8 | OAN on-air personnel | Right-Wing Media Figures |
organizations |
444 | Hate groups, dark money, extremist networks | Extremist Organizations and Hate Groups (SPLC-Tracked) |
pacs |
41 | Political action committees | Trump-Aligned PACs and Super PACs |
people |
~570 | Combined roster (all categories) | Right-Wing Media Figures + others |
republican_people |
94 | Coup-adjacent operatives (broader) | January 6th Coup Plotters and Co-Conspirators + Trump-Aligned Republicans (Expanded MAGA Caucus) |
republicans |
79 | J6-specific operatives | January 6th Coup Plotters and Co-Conspirators |
spls-cities.csv |
(CSV) | SPLC-tracked cities | (geographic reference) |
spls-groups.csv |
(CSV) | SPLC-tracked hate groups | Extremist Organizations and Hate Groups (SPLC-Tracked) |
spls-states.csv |
(CSV) | SPLC-tracked states | (geographic reference) |
trump_donors |
88 | Trump’s major individual donors | Trump Mega-Donors and Funder Network |
docs/ (Reference Documents)
| File | Source / Author | Topic | Format |
|---|---|---|---|
Interim Staff Report FINAL.pdf |
January 6th Select Committee | Interim findings 2022 | |
The-January-6th-Hearings-A-Criminal-Evidence-Tracker-7th-ed.pdf |
Just Security / academic compilation | All J6-related criminal evidence | |
Lost Not Stolen--The.pdf |
Conservative election lawyers (Bauer, Coppolino, Danforth, Olson, Smith, etc.) | 2022 report finding no evidence of 2020 fraud | |
Investigation of Political Activities by Senior Trump Administration Officials During the 2020 Presidential Election.pdf |
Office of Special Counsel | Hatch Act investigation | |
The Authoritarian Playbook.pdf |
Protect Democracy | Authoritarianism marker framework | |
CIA Counterinsurgency Manual.pdf |
CIA / declassified | Background context for paramilitary movements | |
Pillars-of-Russia's-Disinformation-and-Propaganda-Ecosystem_08-04-20.pdf |
US State Department GEC | Russian disinformation infrastructure | |
RAND_RRA499-1/index.html |
RAND Corporation | Authoritarian movement analysis | HTML |
Wood-Decl.-Ex.-B.pdf |
Court filing | Legal exhibit | |
5bfed332-d350-47c0-8562-0137a4435c68.pdf |
Court filing | Legal exhibit | |
20-843_7j80.pdf |
SCOTUS docket | Legal filing | |
TOWARD_D.PDF |
(Unknown) | Reference | |
Community Meeting Toolkit for hosts.pdf |
Civic-engagement toolkit | Organizing reference | |
arizent feeds.opml |
OPML | RSS feed list (Arizent, business media) | XML/OPML |
one6 feeds.opml |
OPML | RSS feed list (one6 / political) | XML/OPML |
politics feeds.opml |
OPML | RSS feed list (politics) | XML/OPML |
candidates-2022-07-18T19 36 51.csv |
(FEC?) | 2022 candidate list | CSV |
CapitolHillSubset101321.xlsx |
(J6 dataset) | Capitol Hill defendant data subset | Excel |
ACS2021 Executive summary.pdf |
American Community Survey | Demographic context | |
CB-Insights_Insurtech-50-2022.xlsx |
CB Insights | Industry data (likely unrelated) | Excel |
Forrester_Predictions-2022-NA.pdf |
Forrester | Industry forecast (likely unrelated) | |
LiveRamp-logo-kit.zip |
LiveRamp | Brand asset (likely unrelated) | ZIP |
resources/ (Ancillary Data)
| File | Description |
|---|---|
CapitolHillSubset121421.xlsx |
Updated Capitol Hill subset (Dec 14, 2021) |
Jan6 County and State Data.xlsx |
County- and state-level Jan 6 participation data |
solrImports/
| File | Description |
|---|---|
Posts-Export-2022-January-3-2145.csv |
WordPress posts export (One6 site content) |
Workstream Mapping
Workstream 1 — Accountability KB
- Inputs:
taxonomies/,docs/reference PDFs,resources/Jan 6 data - Outputs: 8 grouped roster markdown files + 68 deep profiles + matrix
- Status: In progress (Phase A: rosters; Phase B/C/D: deep profiles)
Workstream 2 — Research Document Search
- Inputs:
A2Site/exports/FullExport.csv(URL list) - Pipeline: Fetch → parse → chunk → embed → upsert into
research_documents - Outputs: PostgreSQL
research_documentstable;GET /api/v1/research/searchendpoint - Status: Phase I (forthcoming)
Notes on Source Quality and Provenance
The One6Project corpus was assembled circa 2021-2022 and reflects that vintage:
- Wikipedia entries reflect 2021-2022 article state; some entries are now out of date. The Patriot University KB should re-fetch via the URL list during Workstream 2 ingestion to capture current state.
- SPLC tracking lists were current as of 2021; SPLC’s annual Year in Hate updates the canonical list. The Patriot University KB cross-references the most recent SPLC publication where group status has changed.
- The PDFs are largely time-stamped and remain authoritative for the events they document (2020-2022).
- Some files in
docs/are unrelated to political content (CB Insights, Forrester, LiveRamp) and were apparently mixed into the directory. These are excluded from the Patriot University ingestion.
Cross-References
- January 6th Coup Plotters and Co-Conspirators
- Trump Mega-Donors and Funder Network
- Trump-Aligned PACs and Super PACs
- Trump-Aligned Republicans (Expanded MAGA Caucus)
right-wing-media-figures.md- Extremist Organizations and Hate Groups (SPLC-Tracked)
- January 6 Capitol Attack Participants — Data Summary
- January 6 Investigation Resources
- Conflicts of Interest Matrix — Trump 2.0 Administration & Movement Network
