TAAFT
Free mode
100% free
Freemium
Free Trial
Deals

Substrate

danielmiessler / Substrate

An Open-source Framework for Human Understanding, Meaning, and Progress.

815 113 Language: TypeScript License: MIT Updated: 1mo ago

README

# **Substrate** ### **Infrastructure for Human Knowledge & Progress** [![GitHub last commit](https://img.shields.io/github/last-commit/danielmiessler/Substrate?style=for-the-badge&logo=github)](https://github.com/danielmiessler/Substrate/commits/main) [![License: MIT](https://img.shields.io/badge/License-MIT-00ADD8.svg?style=for-the-badge)](https://opensource.org/licenses/MIT) [![Stars](https://img.shields.io/github/stars/danielmiessler/Substrate?style=for-the-badge&logo=github)](https://github.com/danielmiessler/Substrate/stargazers) [![TypeScript](https://img.shields.io/badge/TypeScript-007ACC?style=for-the-badge&logo=typescript&logoColor=white)](https://www.typescriptlang.org/) [![Bun](https://img.shields.io/badge/Bun-000000?style=for-the-badge&logo=bun&logoColor=white)](https://bun.sh)

What Is It โ€ข Data โ€ข Quick Start โ€ข Docs โ€ข Contribute โ€ข Roadmap


๐ŸŽฏ What Is Substrate?

Substrate Introduction **[โ†’ Watch Introduction Video](https://www.youtube.com/watch?v=ky7ejowc_qY)** โ€ข **[โ†’ Read Blog Post](https://danielmiessler.com/blog/how-my-projects-fit-together)**

A Shared Foundation for Human Progress

Think of substrate as the base layerโ€”the common ground where we can all work together to understand problems and drive solutions forward. Instead of fragmented discussions and reinventing the wheel, Substrate gives us one place to:

  • Document problems โ†’ What's actually broken, with evidence
  • Track solutions โ†’ What works, what doesn't, with results
  • Connect progress โ†’ Link people, organizations, and projects actually moving things forward
  • Build on each other โ†’ Arguments and ideas that build on shared evidence
  • Measure outcomes โ†’ Did it work? What actually changed?

The Purpose: Accelerate Human Progress

We can't solve problems we don't understand. We can't build on solutions we can't find. Substrate provides:

  • ๐ŸŽฏ Shared understanding โ†’ One place to understand what's wrong and what works
  • ๐Ÿš€ Faster progress โ†’ Build on existing knowledge instead of starting over
  • ๐Ÿ“Š Evidence-based action โ†’ Ground decisions in authoritative data, not opinions
  • ๐Ÿ”— Connected knowledge โ†’ See how problems, solutions, people, and data interconnect
  • ๐ŸŒ Collective intelligence โ†’ Human insight + AI analysis working together toward progress

An open-source framework connecting 17+ knowledge components:

graph TB
    subgraph "๐ŸŒ The Substrate"
        A[๐Ÿงฉ Problems]
        B[๐Ÿ’ก Solutions]
        C[๐Ÿ“Š Data Sources]
        D[๐Ÿ—ฃ๏ธ Arguments]
        E[๐Ÿ“‹ Claims]
        F[๐Ÿ‘ฅ People]
        G[๐Ÿข Organizations]
        H[๐Ÿš€ Projects]
        I[๐Ÿ“ˆ Plans]
        J[๐ŸŽฏ Values]
        K[๐Ÿ’ญ Ideas]
    end

    L[๐Ÿ‘ค Human Contributors] --> A
    L --> B
    L --> D
    M[๐Ÿค– AI Analysis] --> A
    M --> B
    M --> D

    A -.connects to.-> B
    B -.connects to.-> C
    D -.connects to.-> C
    E -.connects to.-> C
    F -.connects to.-> G
    G -.connects to.-> H
    H -.connects to.-> B

    A --> N[๐Ÿ” Shared Understanding]
    B --> N
    C --> N
    D --> N

<table>
<tr>
<td width="50%">

๐Ÿ—๏ธ Structured Components

  • Problems - Documented challenges with evidence
  • Solutions - Proven approaches with results
  • Arguments - Reasoning chains with quality scores
  • Claims - Assertions linked to evidence
  • Plans - Actionable strategies with metrics
  • Ideas - Frameworks and concepts
  • People & Organizations - Who's working on what
  • Projects - Active initiatives with outcomes

</td>
<td width="50%">

๐Ÿ“Š Authoritative Data

  • 13 Data Sources across 100+ years
  • Library science methodology (8 dimensions)
  • Government agencies + verified databases
  • TypeScript automation with Bun runtime
  • Full documentation for every dataset
  • Free APIs with excellent access
  • Human wellbeing indicators beyond GDP
  • Real-time to annual update frequencies

</td>
</tr>
</table>


๐Ÿš€ What's New

[!TIP]
October 2025 - Massive Data Expansion!

We just added 8 authoritative data sources measuring human wellbeing beyond traditional economic metrics. Now track financial stress, health crises, social connection, worker agency, and environmental health.

<details>
<summary><strong>๐Ÿ“… Latest Updates (Click to expand)</strong></summary>

๐Ÿ”ฅ October 27, 2025 - Human Wellbeing Infrastructure

5 NEW US Wellbeing Data Sources:

Added Source What It Measures
๐Ÿ†• DS-00004 FRED Economic Wellbeing Debt stress, unemployment, inequality
๐Ÿ†• DS-00005 CDC WONDER Mortality Overdoses, suicides, deaths of despair
๐Ÿ†• DS-00006 Census ACS Social Living alone, commute times, isolation
๐Ÿ†• DS-00007 BLS JOLTS Labor Worker "permission to quit" index
๐Ÿ†• DS-00008 EPA Air Quality PM2.5, ozone, environmental health

Why This Matters:

"If we measure only GDP and unemployment, we will miss the slow-motion collapse of human thriving happening in plain sight."

These sources capture:

  • ๐Ÿ’ฐ Leading indicators - Financial stress predicts recessions
  • ๐ŸŽญ Behavioral truth - Actions reveal what surveys miss
  • ๐Ÿ—๏ธ Structural determinants - Air quality you can't "self-care" out of
  • ๐Ÿšจ Crisis detection - County-level suffering visibility
  • ๐Ÿ†“ Worker agency - Quit rate = economic freedom measure

October 25, 2025 - Core Data Updates

  • โœ… Pulitzer Prize, GDP, inflation data refreshed
  • โœ… Knowledge Worker Salaries validation completed

October 16-18, 2025 - Infrastructure

  • ๐Ÿ—๏ธ Library science methodology (8-dimension evaluation)
  • โšก TypeScript automation with auto-discovery
  • ๐Ÿ“Š Central logging and health monitoring
  • ๐Ÿ“š Complete documentation suite

<details>
<summary><strong>๐Ÿ“œ Previous Updates (Click to expand)</strong></summary>

September 2024 - Community Growth

  • โœ… Claims, Arguments, and Values frameworks
  • โœ… 6+ community contributors
  • โœ… 10+ merged pull requests
  • โœ… TELOS integration

August 2024 - Framework Expansion

  • โœ… Extended component types (Plans, Ideas, Models)
  • โœ… Improved documentation structure
  • โœ… Enhanced contribution guidelines

July 2024 - Foundation

  • โœ… Single-repo structure with 17+ object types
  • โœ… Core framework and documentation
  • โœ… Public launch with initial datasets
  • โœ… Community contribution framework

</details>


โ†’ View Full Changelog

</details>


๐Ÿ“Š Data & Evidence

[!NOTE]
All data sources include complete library science cataloging with 8-dimension evaluation: Authority, Currency, Objectivity, Accuracy, Methodology, Coverage, Reliability, and Provenance.

[!IMPORTANT]
We know data can be controversial. That's exactly why we:

  • ๐Ÿ“Š Collect from multiple sources - Cross-reference data from different authoritative providers
  • ๐Ÿ” Provide complete transparency - Every source fully documented with provenance, methodology, and limitations
  • ๐Ÿ“ Full logging - All data pulls logged with timestamps, source versions, and processing steps
  • ๐Ÿ”“ Open source everything - TypeScript update scripts show exactly how data is fetched and transformed

You can verify, audit, and challenge our data. That's the point.

Core Datasets (Data/)

Dataset Time Span Data Points Source Status
๐Ÿ‡บ๐Ÿ‡ธ US GDP 1929-2025 96 years + 314 quarters FRED/BEA โœ… Active
๐Ÿ’ต US Inflation 1947-2025 945 months FRED/BLS โœ… Active
๐Ÿฆ  Bay Area COVID Wastewater 2022-2025 161 weeks CDPH โœ… Active
๐Ÿ† Pulitzer Prize Winners 1918-2024 249 winners Wikidata โœ… Active
๐Ÿ’ผ Knowledge Worker Salaries Global Multi-region Research โœ… Active

Wellbeing Data Sources (Data-Sources/) ๐Ÿ†•

<details>
<summary><strong>๐ŸŒ Global Health & Development (Click to expand)</strong></summary>

ID Name Coverage Indicators Update
DS-00001 WHO Global Health Observatory 194 countries 2,000+ health indicators Quarterly
DS-00002 UN SDG Indicators 193 countries 231 SDG targets Biannual
DS-00003 World Bank Open Data Global Development metrics Varies

</details>

<details open>
<summary><strong>๐Ÿ‡บ๐Ÿ‡ธ US Human Wellbeing (October 2025)</strong></summary>

<table>
<tr>
<th width="15%">Source</th>
<th width="35%">Key Indicators</th>
<th width="30%">Why It Matters</th>
<th width="20%">Update Freq</th>
</tr>

<tr>
<td><strong>DS-00004</strong><br/><a href="./Data-Sources/DS-00004โ€”FRED_Economic_Wellbeing/">FRED Economic</a></td>
<td>
โ€ข Debt service ratio<br/>
โ€ข Credit card delinquency<br/>
โ€ข Financial stress index<br/>
โ€ข Underemployment (U-6)<br/>
โ€ข Consumer sentiment<br/>
โ€ข GINI inequality
</td>
<td>๐Ÿ’ฐ <strong>Economic Security Foundation</strong><br/>Debt >12% = stress, >14% = crisis. Leading indicator of recession.</td>
<td>Weekly to Annual</td>
</tr>

<tr>
<td><strong>DS-00005</strong><br/><a href="./Data-Sources/DS-00005โ€”CDC_WONDER_Mortality/">CDC WONDER</a></td>
<td>
โ€ข Drug overdose deaths<br/>
โ€ข Opioid-specific deaths<br/>
โ€ข Suicide rates<br/>
โ€ข All-cause mortality
</td>
<td>๐Ÿšจ <strong>Crisis Detection</strong><br/>Deaths of despair reveal community breakdown surveys miss. County-level visibility.</td>
<td>Annual (1-2yr lag)</td>
</tr>

<tr>
<td><strong>DS-00006</strong><br/><a href="./Data-Sources/DS-00006โ€”Census_ACS_Social_Wellbeing/">Census ACS</a></td>
<td>
โ€ข Living alone (isolation)<br/>
โ€ข Commute times (time poverty)<br/>
โ€ข No internet (digital divide)<br/>
โ€ข Household demographics
</td>
<td>๐Ÿค <strong>Social Connection</strong><br/>Structural isolation and time poverty constrain flourishing. Census tract granularity.</td>
<td>Annual</td>
</tr>

<tr>
<td><strong>DS-00007</strong><br/><a href="./Data-Sources/DS-00007โ€”BLS_JOLTS_Labor_Market/">BLS JOLTS</a></td>
<td>
โ€ข <strong>Quit rate</strong> (worker agency)<br/>
โ€ข Job openings<br/>
โ€ข Hire rate<br/>
โ€ข Layoff/discharge rate
</td>
<td>๐Ÿ†“ <strong>"Permission to Quit"</strong><br/>People only quit when they have options. Measures economic freedom and dignity.</td>
<td>Monthly</td>
</tr>

<tr>
<td><strong>DS-00008</strong><br/><a href="./Data-Sources/DS-00008โ€”EPA_Air_Quality_System/">EPA Air Quality</a></td>
<td>
โ€ข PM2.5 (particulate matter)<br/>
โ€ข Ozone (O3)<br/>
โ€ข SO2, CO, NO2<br/>
โ€ข AQI exceedances
</td>
<td>๐ŸŒซ๏ธ <strong>Environmental Health</strong><br/>You can't "self-care" out of breathing toxic air. Structural wellbeing constraint.</td>
<td>Real-time</td>
</tr>

</table>

</details>

Composite Wellbeing Indices

[!TIP]
Combine multiple data sources to create powerful wellbeing metrics:

  • ๐Ÿ’ธ Financial Stress Composite - Debt + delinquency + evictions + stress index
  • ๐Ÿšจ Crisis Alert Composite - Overdoses + suicides + long-term unemployment
  • ๐Ÿค Community Health Composite - Living alone + commute + digital divide (inverted)
  • ๐Ÿ†“ Worker Agency Index - Quit rate + job openings / unemployment
  • ๐ŸŒซ๏ธ Environmental Health Index - PM2.5 + ozone (inverted)

โ†’ Wellbeing Implementation Guide | โ†’ Data Directory


๐Ÿค– Human & AI Collaboration

Substrate provides the pieces. You and your AI create the connections.

<table>
<tr>
<td width="50%">

๐Ÿ‘ค Humans Contribute

  • Document problems and solutions
  • Add authoritative data sources
  • Create arguments and claims
  • Link entities explicitly
  • Validate AI suggestions
  • Rate quality of evidence

</td>
<td width="50%">

๐Ÿค– AI Analyzes

  • Scan thousands of components
  • Suggest relationships automatically
  • Detect patterns across datasets
  • Score argument quality
  • Find contradictions
  • Generate knowledge graphs

</td>
</tr>
</table>

Everything is designed for dual consumption:

  • โœ… Human-readable - Markdown and CSV anyone can open
  • โœ… Machine-parseable - Consistent formats AI can query
  • โœ… Fully documented - Complete methodology for every dataset
  • โœ… Linked with IDs - Unambiguous entity references

Use Cases

<details>
<summary><strong>๐Ÿ” OSINT & Investigation</strong></summary>

  • Cross-reference public records, corporate filings, government data
  • Link people โ†’ organizations โ†’ transactions โ†’ policies
  • Surface connections invisible in isolated databases
  • Build evidence chains from claims to verifiable records
  • Pattern detection for fraud, corruption, illicit networks

</details>

<details>
<summary><strong>๐Ÿ“Š Research & Analysis</strong></summary>

  • Track claims against authoritative data sources
  • Evaluate argument quality based on evidence backing
  • Compare solutions across different implementations
  • Measure progress toward stated goals with real metrics
  • Cross-correlate economic, health, social, environmental data

</details>

<details>
<summary><strong>๐ŸŒ Public Accountability</strong></summary>

  • Verify political claims against documented evidence
  • Track campaign promises โ†’ policy outcomes โ†’ measured results
  • Link donations โ†’ voting records โ†’ policy positions
  • Monitor government spending against stated objectives
  • Environmental justice analysis (who breathes toxic air?)

</details>


๐Ÿš€ Quick Start

View the Data (No Installation Required)

All datasets are available as CSV and Markdown files you can browse directly:

# Clone the repository
git clone https://github.com/danielmiessler/Substrate.git
cd Substrate

# Explore core datasets
ls Data/*/

# Explore wellbeing data sources
ls Data-Sources/*/

Run the Automation (Optional)

[!WARNING]
Requires Bun runtime. Install: curl -fsSL https://bun.sh/install | bash

# Install dependencies
bun install

# Update a specific dataset
cd Data/US-GDP
bun run update.ts

# Update a wellbeing source (requires API key)
export FRED_API_KEY="your_key_here"
cd Data-Sources/DS-00004โ€”FRED_Economic_Wellbeing
bun run update.ts

# Update all datasets
bun run scripts/update-all.ts

Get API Keys (Free)

Data Source Get Key Rate Limit
FRED Economic fred.stlouisfed.org/docs/api 120 req/min
Census ACS api.census.gov/data/key_signup 500 req/day
EPA Air Quality Email: [email protected] 10 req/min
BLS JOLTS bls.gov/developers/home 500 req/day
CDC WONDER No key required Fair use

โ†’ Complete Getting Started Guide | โ†’ Quick Reference


๐Ÿ’ก Contribute

[!IMPORTANT]
Anyone can submit components. No gatekeeping on ideasโ€”just structured formats.

What You Can Add

<table>
<tr>
<td width="33%">

๐Ÿ“‹ Problems

  • Water quality issues
  • Healthcare access gaps
  • Climate change impacts

๐Ÿ’ก Solutions

  • Filtration systems
  • Telemedicine networks
  • Infrastructure adaptation

๐Ÿ“ˆ Plans

  • Political platforms
  • Policy proposals
  • Action roadmaps

</td>
<td width="33%">

๐Ÿ—ฃ๏ธ Arguments

  • "This works because X, Y, Z"
  • "This failed due to A, B"
  • (We don't judgeโ€”community rates)

๐Ÿ“Š Data

  • Public records
  • Research datasets
  • Compiled statistics

๐Ÿ’ญ Ideas

  • Theoretical frameworks
  • Novel measurement approaches
  • Conceptual models

</td>
<td width="33%">

๐Ÿ‘ฅ People & Orgs

  • Researchers on problems
  • Organizations implementing
  • Projects with outcomes

๐Ÿ“ Metrics

  • Success criteria
  • Measurement frameworks
  • Progress indicators

๐ŸŽฏ Values

  • Guiding principles
  • Evaluation criteria

</td>
</tr>
</table>

How to Submit

  1. Fork the repository on GitHub
  2. Add your component in the appropriate directory (Problems/, Solutions/, etc.)
  3. Follow the format in that directory's README
  4. Submit a Pull Request

[!NOTE]
We're building a web interface to make this easier for non-technical contributors!

โ†’ Contribution Guidelines


๐Ÿ“š Documentation

<table>
<tr>
<td width="50%">

Getting Started

</td>
<td width="50%">

Technical

</td>
</tr>
</table>


๐Ÿ—บ๏ธ Roadmap

โœ… Completed

<details>
<summary><strong>Phase 1: Foundation (July 2024)</strong></summary>

  • โœ… Single-repo structure with 17+ object types
  • โœ… Core framework and documentation
  • โœ… Public launch with initial datasets
  • โœ… Community contribution framework

</details>

<details>
<summary><strong>Phase 2: Community (Aug-Sep 2024)</strong></summary>

  • โœ… Claims, Arguments, and Values frameworks
  • โœ… 6+ community contributors
  • โœ… 10+ merged pull requests
  • โœ… TELOS integration

</details>

<details open>
<summary><strong>Phase 3: Data Infrastructure (Oct 2025) ๐Ÿ”ฅ</strong></summary>

  • โœ… 13 authoritative data sources (5 core + 8 wellbeing)
  • โœ… Library science methodology (8-dimension evaluation)
  • โœ… TypeScript automation system with Bun runtime
  • โœ… 6,000+ lines of documentation across all sources
  • โœ… Comprehensive wellbeing indicators (economic, health, social, labor, environmental)
  • โœ… Free API access with rate limiting and retry logic

</details>

๐Ÿšง Planned

Phase 4: Enhanced Access (Q4 2025 - Q1 2026)

  • ๐ŸŽจ Web-based contribution interface (no coding required)
  • ๐Ÿ“Š Interactive data visualizations
  • ๐Ÿ”Œ RESTful API for programmatic access
  • ๐Ÿ“ฑ Mobile-friendly exploration

Phase 5: Dataset Expansion (2026)

  • ๐ŸŒ Additional international sources (UNICEF, OECD, IHME)
  • โšก Real-time data feeds integration
  • ๐Ÿ—ณ๏ธ Community-driven dataset requests
  • ๐Ÿค Partnerships with research institutions

Phase 6: Intelligence Layer (2026+)

  • ๐Ÿค– Automated relationship discovery
  • ๐Ÿ“ˆ Confidence scoring for AI-suggested links
  • ๐ŸŽฏ Pattern detection algorithms
  • ๐Ÿ”” Email/Slack notifications for data updates
  • ๐Ÿ“š Machine-readable catalog (DCAT/CKAN compliance)

๐Ÿ”— Integration with TELOS

Substrate provides evidence. TELOS provides intention.

<table>
<tr>
<th width="50%">TELOS (Goals & Strategy)</th>
<th width="50%">Substrate (Evidence & Solutions)</th>
</tr>
<tr>
<td>

  • Goals - What you want to achieve
  • Strategies - How you'll pursue it
  • Challenges - Obstacles you face
  • Metrics - Progress tracking

</td>
<td>

  • Problems - What stands in the way
  • Solutions - Proven approaches
  • Data - Measured evidence
  • Plans - Implementation roadmaps

</td>
</tr>
</table>

Together: Complete system for intention + evidence-based action.


๐Ÿ™ Credits

Created By

Daniel Miessler โ€ข July 2024

Twitter Follow
Newsletter

Special Thanks

Inspiration & Contributions:

  • Jonathan Dunn @xssdoctor - Similar vision and collaboration
  • Joel Parish - Structure wisdom and guidance
  • Joseph Thacker - Continuous flow of innovative ideas

Community Contributors:

@ThatNateGuy โ€ข @JaymanW โ€ข @karai114 โ€ข @DesertEaglePWN โ€ข @ktfth


๐Ÿ“„ License

MIT License - see the LICENSE file for details.


### **๐Ÿ“Š Repository Stats** **Data:** 13 sources โ€ข 1,700+ data points โ€ข 107-year span (1918-2025) **Code:** TypeScript automation โ€ข 6,000+ lines documentation โ€ข GitHub Actions **Community:** 6+ contributors โ€ข 10+ PRs merged โ€ข 17 object types --- **[โฌ† Back to Top](#substrate)** Built with โค๏ธ for human understanding and progress Powered by [TypeScript](https://www.typescriptlang.org/) โ€ข [Bun](https://bun.sh) โ€ข Open Data --- ## Star History [![Star History Chart](https://api.star-history.com/svg?repos=danielmiessler/Substrate&type=Date)](https://star-history.com/#danielmiessler/Substrate&Date)
0 AIs selected
Clear selection
#
Name
Task