WordPress report data inventory

A compact map of the SQLite database behind the WordPress Community & Adoption Health report. Use this to see what data is already stored, what local source files are hashed, and which source areas remain partial.

Tables

110SQLite tables in the report database.

Local sources

21Imported files with SHA-256 hashes.

Tickets/issues

97.1kCore Trac tickets plus Gutenberg issues.

Pull requests

12.1kwordpress-develop GitHub PR records.

Integrity

okSQLite integrity check result.

Tracker and PR data

The strongest evidence in the report: direct project workload and participation history.

core_tickets

Rows65.0k

Core Trac ticket rows.

core_events

Rows76.6k

Core Trac event rows.

gutenberg_issues

Rows32.1k

Gutenberg GitHub issue rows.

github_prs

Rows12.1k

wordpress-develop pull request rows.

classification_trend

Rows716

Quarterly classification rows.

contributor_retention_cohorts

Rows164

First-seen contributor cohorts and next-four-quarter return rates.

External signal families

These tables keep ticket activity separate from ecosystem, adoption, and demand signals.

market_share

W3Techs all-site and CMS-share trend rows.

http_archive_*

Origin counts, tracked-share trend, rank tiers, and Core Web Vitals.

builtwith_*

Current new-site proxy, tier snapshot, and ecommerce history.

wporg_ecosystem_stats_snapshot

Current WordPress.org WordPress, PHP, and database-version active-install shares.

make_core_*

Make/Core posts, comments, dev notes, authors, and release tags.

core_release_*

Core release archive, credits, committers, and tag-to-tag compare summaries.

major_plugin_*

Major plugin installs, historical snapshots, support counts, and two-year download activity.

plugin_directory_activity_*

Current WordPress.org plugin browse samples plus derived quarterly added and updated plugin counts.

plugin_search_snapshot

Current WordPress.org plugin search-result counts and top matching plugins by category.

theme_search_snapshot

Current WordPress.org theme search-result counts and top matching themes by site category.

packagist_package_snapshot

Current Composer package downloads, favorites, dependents, and release timestamps.

github_repo_search_snapshot

Current GitHub repository-search totals and top matching repositories for selected WordPress ecosystem topics.

remotive_*

Current Remotive job snapshot with term summaries and matching rows.

Refresh this inventory

Run this after the report database changes so table counts, source hashes, and partial-source gaps stay synchronized with SQLite.

Check the database sqlite3 community_health.sqlite "PRAGMA integrity_check; SELECT count(*) FROM sqlite_master WHERE type='table';"

Regenerate the inventory python3 make_data_inventory.py

Publish with the report

cp data_inventory.html make_data_inventory.py decision_brief.html make_decision_brief.py progress_summary.html make_progress_summary.py work_so_far.html make_work_so_far.py project_load.html make_project_load_report.py market_position.html make_market_position_report.py new_site_choice.html make_new_site_choice_report.py search_interest.html make_search_interest_report.py developer_interest.html make_developer_interest_report.py job_demand.html make_job_demand_report.py support_load.html make_support_load_report.py contributor_depth.html make_contributor_depth_report.py ecosystem_activity.html make_ecosystem_activity_report.py source_gap_plan.html make_source_gap_plan.py goal_audit.html make_goal_audit.py refresh_report_artifacts.py /Users/admin/sqlite-database-integration-pages/wordpress-community-health/

Full table list

Generated from sqlite_master; row counts are current for this local database.

attention_demand_summary5 rows

builder_momentum_summary5 rows

builtwith_new_site_snapshot5 rows

builtwith_technology_history172 rows

builtwith_technology_snapshots2 rows

builtwith_tier_share_snapshot5 rows

category_open_backlog_summary26 rows

classification_summary_core4 rows

classification_summary_gutenberg11 rows

classification_trend716 rows

closure_age_summary127 rows

contributor_concentration_summary6 rows

contributor_depth_buckets24 rows

contributor_retention_cohorts164 rows

core_events76.6k rows

core_quarterly94 rows

core_release_committer_counts1,105 rows

core_release_committers39 rows

core_release_credits39 rows

core_releases50 rows

core_reopen_quarterly94 rows

core_response_metrics13.1k rows

core_response_quarterly22 rows

core_tickets65.0k rows

decision_question_evidence8 rows

directory_activity_snapshots1 rows

directory_snapshots2 rows

ecommerce_platform_share_quarterly184 rows

enterprise_vip_case_studies44 rows

fttf_contributors975 rows

fttf_pledges280 rows

fttf_snapshots1 rows

github_pr_quarterly94 rows

github_pr_review_comments33.3k rows

github_pr_review_comments_quarterly31 rows

github_prs12.1k rows

github_repo_interest_snapshot5 rows

github_repo_search_snapshot6 rows

gutenberg_issues32.1k rows

gutenberg_issues_jsonl32.1k rows

gutenberg_quarterly21 rows

gutenberg_timeline_metrics32.1k rows

gutenberg_timeline_quarterly38 rows

hn_hiring_demand_summary5 rows

hn_hiring_wordpress_quarterly58 rows

http_archive_adoption_monthly385 rows

http_archive_cwv_monthly2,695 rows

http_archive_quarterly_detected_origin_change125 rows

http_archive_rank_adoption_snapshot22 rows

http_archive_site_creation_adoption_monthly1,382 rows

http_archive_tracked_share_monthly385 rows

http_archive_tracked_share_quarterly130 rows

maintainer_participation_quarterly75 rows

major_plugin_download_daily10.9k rows

major_plugin_download_quarterly135 rows

major_plugin_install_history120 rows

major_plugin_install_snapshot15 rows

make_core_comment_quarterly74 rows

make_core_comments34.4k rows

make_core_dev_note_quarterly55 rows

make_core_dev_note_releases12 rows

make_core_dev_note_tags15 rows

make_core_dev_notes622 rows

make_core_posts6,523 rows

market_share174 rows

new_site_choice_summary6 rows

npm_wordpress_downloads_monthly624 rows

npm_wordpress_downloads_quarterly208 rows

open_backlog_age_summary12 rows

packagist_package_snapshot11 rows

plugin_directory_activity_quarterly2 rows

plugin_directory_activity_sample13.3k rows

plugin_maintenance_summary1 rows

plugin_search_snapshot9 rows

plugin_stale_popular_sample41 rows

remoteok_job_signal_snapshot9 rows

remoteok_matching_jobs_snapshot15 rows

remotive_job_signal_snapshot9 rows

remotive_matching_jobs_snapshot23 rows

search_query_intent_summary7 rows

search_query_suggestions70 rows

source_files21 rows

source_gaps5 rows

stack_overflow_tag_quarterly303 rows

support_forum_activity_monthly7 rows

support_forum_age_buckets6 rows

support_forum_archive_snapshots135 rows

support_forum_forum_summary10 rows

support_forum_snapshot_summary1 rows

support_forum_topics1,315 rows

support_forum_unanswered_by_forum10 rows

support_forum_view_snapshots4 rows

theme_directory_activity_sample900 rows

theme_search_snapshot9 rows

translation_core_dev_status202 rows

translation_locale_snapshot202 rows

translation_snapshots1 rows

wikimedia_pageviews_monthly792 rows

wikimedia_pageviews_quarterly264 rows

wordcamp_quarterly80 rows

wordcamp_yearly22 rows

wordcamps1,458 rows

wordpress_jobs_board_category_snapshots61 rows

wordpress_jobs_board_quarterly_categories199 rows

wordpress_jobs_board_quarterly_snapshots30 rows

wordpress_jobs_board_snapshots10 rows

wp_event_activity_quarterly5 rows

wp_event_snapshots1 rows

wp_events293 rows

wporg_ecosystem_stats_snapshot105 rows

Hashed local sources

The database stores full SHA-256 values. This page shows shortened hashes to keep the inventory readable.

builtwith_new_site_snapshot

Rows5

Hash prefix2ee9e5f3b9d5

/Users/admin/wordpress_community_health/builtwith_new_site_snapshot.csv

classification_summary_core

Rows4

Hash prefix93a56754f3eb

/Users/admin/sqlite-database-integration-pages/wordpress-ticket-classification/classification_summary_core.csv

classification_summary_gutenberg

Rows11

Hash prefixbf55ecc265ab

/Users/admin/sqlite-database-integration-pages/wordpress-ticket-classification/classification_summary_gutenberg.csv

classification_trend

Rows716

Hash prefix0984ed9fe68d

/Users/admin/sqlite-database-integration-pages/wordpress-ticket-classification/classification_trend_quarterly.csv

core_events

Rows76.6k

Hash prefix8876306517a9

/Users/admin/wordpress_core_issue_analysis/raw/trac_ticket_events.csv

core_quarterly

Rows94

Hash prefix8621dd71a95a

/Users/admin/wordpress_core_issue_analysis/quarterly_metrics.csv

core_response_metrics

Rows13.1k

Hash prefixbae42ebffdfa

/Users/admin/wordpress_community_health/core_response_metrics.jsonl

core_response_quarterly

Rows22

Hash prefixc7684084b6b9

/Users/admin/wordpress_community_health/core_response_quarterly.csv

core_tickets

Rows65.0k

Hash prefixc16d29ed7334

/Users/admin/wordpress_core_issue_analysis/raw/trac_tickets.csv

github_pr_quarterly

Rows94

Hash prefixcbf81b574ff0

/Users/admin/wordpress_core_issue_analysis/github_pr_quarterly.csv

github_prs

Rows12.1k

Hash prefixd8994070e068

/Users/admin/wordpress_core_issue_analysis/raw/github_wordpress_develop_prs.jsonl

gutenberg_issues

Rows32.1k

Hash prefix30f3c5170c31

/Users/admin/gutenberg_issue_analysis/issues_inventory.csv

gutenberg_issues_jsonl

Rows32.1k

Hash prefix5e5403452e76

/Users/admin/gutenberg_issue_analysis/raw/issues_inventory.jsonl

gutenberg_quarterly

Rows21

Hash prefix810760643677

/Users/admin/gutenberg_issue_analysis/quarterly_metrics.csv

gutenberg_timeline_metrics

Rows32.1k

Hash prefix8353b10b4e7c

/Users/admin/wordpress_community_health/gutenberg_issue_timeline_metrics.jsonl

gutenberg_timeline_quarterly

Rows38

Hash prefixba193efb87db

/Users/admin/wordpress_community_health/gutenberg_timeline_quarterly.csv

http_archive_site_creation_adoption_monthly

Rows1,382

Hash prefix68a5f065fa59

/Users/admin/wordpress_community_health/http_archive_site_creation_adoption_monthly.csv

support_forum_archive_snapshots

Rows135

Hash prefixeb555b2c594c

/Users/admin/wordpress_community_health/support_forum_archive_snapshots.csv

support_forum_forum_summary

Rows10

Hash prefix84973e52d2c8

/Users/admin/wordpress_community_health/support_forum_forum_summary.csv

support_forum_topics

Rows1,315

Hash prefix0307cf0110fe

/Users/admin/wordpress_community_health/support_forum_topics.jsonl

support_forum_view_snapshots

Rows4

Hash prefixcf6bc9cc705e

/Users/admin/wordpress_community_health/support_forum_view_snapshots.csv

Partial-source gaps stored in SQLite

partial Developer Interest Proxy Best next source

Stack Exchange API question totals, Wikimedia Pageviews API, npm package downloads, GitHub PR/repository/topic/review activity, and broader developer-community sources

Current coverage

Quarterly Stack Overflow tag volume, Wikimedia pageviews, npm @wordpress package downloads, Packagist Composer package snapshots, wordpress-develop PR and line review-comment activity, GitHub repository interest and topic-search snapshots, and a compact attention/demand summary are included as public attention and contribution proxies; they do not measure general search-query interest.

partial Job Demand Best next source

Hacker News monthly Who is hiring? threads, Remote OK and Remotive current jobs, plus hiring-platform exports

Current coverage

HN Who is hiring WordPress/WooCommerce, PHP, and agency/studio mention counts, Remote OK and Remotive current remote-job term counts, annual and quarterly WordPress Jobs board open-listing snapshots, a compact proxy-direction summary, and a job-demand companion view are included; broader multi-year labor-market demand still needs a hiring-platform time series.

partial New Site Share History Best next source

BuiltWith historical trends or HTTP Archive cohort queries

Current coverage

Current report includes BuiltWith current Net New Pipeline, HTTP Archive monthly origin counts, quarterly derived tracked-share history, quarter-over-quarter detected-origin change proxies, broader site-creation mode signals, builder momentum summaries, rank-tier detected-origin adoption, a compact new-site choice summary, and a dedicated new-site choice companion view; not a multi-year first-published-site cohort.

partial Search Interest Best next source

Google Trends or another search-interest provider

Current coverage

Wikimedia Pageviews API quarterly article-view trends, Stack Overflow tag-volume context, a current Google autocomplete suggestion snapshot, a compact attention/demand summary, and a search-interest companion view are included as public-interest and query-intent proxies; true search-volume history still needs Google Trends or another search provider.

partial Support Forum History Best next source

Historical WordPress.org support forum topic/reply export

Current coverage

Current report includes public support queue snapshots, quarterly Internet Archive support-view estimates from 2018 onward, resolved/unresolved/no-reply summaries, last-activity buckets, forum-level unanswered summaries, a support-load companion view, and major-plugin support-thread totals; not a full long-term topic/reply history.