USAID's Collecting Taxes Database (CTD) is a compilation of international statistics about taxation designed to provide policymakers, practitioners, and researchers with the means to conduct analysis on domestic revenue mobilization (DRM). It is part of a wider agenda of the international community to help countries strengthen their tax systems and mobilize domestic revenue. The CTD includes information on tax performance and tax administration variables for 200 countries and territories. USAID plans to update the CTD annually. The CTD comprises a set of 30 indicators divided into three main categories -- (1) Tax Rates and Structure; (2) Tax Performance; and (3) Tax Administration -- and includes information on 200 national tax systems. The tax administration indicators examine the main features of the revenue authority.

Key information about United States Tax Revenue

• US Tax Revenue was reported at 510.819 USD bn in Jan 2025.
• This records an increase from the previous figure of 451.093 USD bn for Dec 2024.
• US Tax Revenue data is updated monthly, averaging 107.897 USD bn from Dec 1967 to Jan 2025, with 686 observations.
• The data reached an all-time high of 851.434 USD bn in Apr 2022 and a record low of 10.507 USD bn in Oct 1968.
• US Tax Revenue data remains active status in CEIC and is reported by CEIC Data.
• The data is categorized under World Trend Plus’s Global Economic Monitor – Table: Tax Revenue: USD: Monthly.

CEIC calculates monthly Tax Revenue as the sum of Individual Income Taxes, Corporation Income Taxes, Social Insurance Taxes, Excise Tax, Estate and Gift Taxes and Customs Duties. The Bureau of the Fiscal Service provides Tax Revenue in USD.

Data, geospatial data resources, and the linked mapping tool and web services reflect data for two types of potentially qualifying energy communities: 1) Census tracts and directly adjoining tracts that have had coal mine closures since 1999 or coal-fired electric generating unit retirements since 2009. These census tracts qualify as energy communities. 2) Metropolitan statistical areas (MSAs) and non-metropolitan statistical areas (non-MSAs) that are energy communities for 2023 and 2024, along with their fossil fuel employment (FFE) status. Additional information on energy communities and related tax credits can be accessed on the Interagency Working Group on Coal & Power Plant Communities & Economic Revitalization Energy Communities website (https://energycommunities.gov/energy-community-tax-credit-bonus/). Use limitations: these spatial data and mapping tool may not be relied upon by taxpayers to substantiate a tax return position or for determining whether certain penalties apply and will not be used by the IRS for examination purposes. The mapping tool does not reflect the application of the law to a specific taxpayer’s situation, and the applicable Internal Revenue Code provisions ultimately control.

Find the original dataset here

Pandas EDA with Plotly using this dataset here

Paycheck Protection Program (PPP) Loan Data – Key Aspects

SBA Values Transparency, Protecting Taxpayer Funds, and Protecting Proprietary Information of Small Businesses

In releasing PPP loan data to the public, SBA is maintaining a balance between providing transparency to American taxpayers and protecting small businesses’ confidential business information, such as payroll, and personally identifiable information. Small businesses are the driving force of American economic stability and are essential to America’s economic rebound from the pandemic. SBA is committed to ensuring that any release of PPP loan data does not harm small businesses or their employees.

PPP Is A Delegated Loan Making Process

PPP loans are not made by SBA. PPP loans are made by lending institutions and then guaranteed by SBA. Accordingly, borrowers apply to lenders and self-certify that they are eligible for PPP loans. The self- certification includes a good faith certification that the borrower has economic need requiring the loan and a certification that the borrower has applied the affiliation rules and is a small business, among other certifications The lender then reviews the borrower’s application, and if all the paperwork is in order, approves the loan and submits it to SBA.

PPP Loan Data Is Not Indicative of Loan Forgiveness or Program Compliance

A small business or non-profit organization that is listed in the publicly released data has been approved for a PPP loan by a delegated lender. However, the lender’s approval does not reflect a determination by SBA that the borrower is eligible for a PPP loan or entitled to loan forgiveness. All PPP loans are subject to SBA review and all loans over $2 million will automatically be reviewed. The fact that a borrower is listed in the data as having a PPP loan does not mean that SBA has determined that the borrower complied with program rules or is eligible to receive a PPP loan and loan forgiveness. Further, a small business’s receipt of a PPP loan should not be interpreted as an endorsement of the small business’ business activity or business model.

Cancelled Loans Do Not Appear In The PPP Loan Data

The public PPP data includes only active loans. Loans that were cancelled for any reason are not included in the public data release.

PPP Loan Demographic Data Is Voluntarily Submitted

PPP loan data reflects the information borrowers provided to their lenders in applying for PPP loans. SBA can make no representations about the accuracy or completeness of any information that borrowers provided to their lenders. Not all borrowers provided all information. For example, approximately 75% of all PPP loans did not include any demographic information because that information was not provided by the borrowers. SBA is working to collect more demographic information from borrowers to better understand which small businesses are benefiting from PPP loans. The loan forgiveness application expressly requests demographic information for borrowers.

This dataset has been clipped to the Broward County extent from the Census dataset available through the United States Department of Treasury Community Development Financial Institutions (CDFI) Fund.

OPPORTUNITY ZONES RESOURCES: downloaded from Census : https://www.cdfifund.gov/Pages/Opportunity-Zones.aspx

The authority to implement IRC 1400Z-1 and 1400Z-2 has been delegated to the IRS. The CDFI Fund is supporting the IRS with the Opportunity Zone nomination and designation process under IRC 1400Z-1 only. In addition to an initial set of proposed regulations and guidance on how the Qualified Opportunity Zone (QOZ) tax benefits under IRC 1400Z-2 (including the certification of Qualified Opportunity Funds (QOFs) and eligible investments in QOZs) will be administered, Treasury and IRS have issued a second set of proposed regulations relating to gains that may be deferred as a result of a taxpayer's investment in a QOF, special rules for an investment in a QOF held by a taxpayer for at least 10 years, and updates to portions of previously proposed regulations under section 1400Z-2 to address various issues, including: the definition of “substantially all.” You may submit comments on the proposed regulations electronically via the Federal Rulemaking Portal at www.regulations.gov (IRS REG-115420-18 or IRS REG 120186-18).Concurrent with the second set of proposed regulations, Treasury and IRS published a request for information (RFI), asking for detailed comments regarding ways to assess QOF investments including asset class, identification of Qualified Opportunity Zones and the impact and outcomes on those Qualified Opportunity Zones. You may submit comments on the RIF electronically via the Federal Rulemaking Portal at www.regulations.gov (TREAS-DO-2019-0004). IRS also has posted a list of Frequently Asked Questions about Opportunity Zones on the irs.gov Tax Reform pages. You will want to monitor the Tax Reform page at the IRS website for additional Opportunity Zone information and other Tax Reform information. For any other questions, please call (800) 829-1040.

List of designated Qualified Opportunity Zones (QOZs): This spreadsheet was updated December 14, 2018, to include two additional census tracts in Puerto Rico that, based on 2012-2016 American Community Survey data, meet the statutory criteria for a Low-Income Community and are deemed as designated QOZs. Based on nominations of eligible census tracts by the Chief Executive Officers of each State, Treasury has completed its designation of Qualified Opportunity Zones. Each State nominated the maximum number of eligible tracts, per statute, and these designations are final. The statute and legislative history of the Opportunity Zone designations, under IRC § 1400Z, do not contemplate an opportunity for additional or revised designations after the maximum number of zones allowable have been designated in a State or Territory. Based on IRC 1400Z-1, designations are based upon the boundaries of the tract at the time of the designation in 2018, and do not change over the period of the designation, even if the boundaries of an individual census tract are redefined in future Census releases.

Source: United States Census Bureau

Effective Date:

Last Update:12/14/2018

Update Cycle: As needed, Census occurs once every decade

Issuer's Allocation Percentage for all corporations subject to taxes.

These reports are used by general corporations and unincorporated taxpayers to compute their investment allocation percentages, and by general corporation taxpayers to compute their allocated subsidiary capital. For 2006 and prior, the list include only corporations whose issuer's allocation percentages are known to be less than 100%. For 2007 and later, the lists include corporations whose issuer's allocation percentages are 100% or less.

Keyword counts from US Presidential State of the Union Addresses and Presidential Budget Messages. This was done using the Python scripts provided under https://github.com/JeremySilver/KeywordCountsPresidentialMessages. The raw text data is from The American Presidency Project (UCSB), with some Presidential Budget Messages being extracted from US Federal Budget documents available through FRASER (a digital library of U.S. economic, financial, and banking history) or, for the more recent documents the website of the White House.

The data headings are:

• pid: in most cases, this is the index for the text document as archived on The American Presidency Project website. In some cases, this was the filename of a plain-text file read directly.
• year: Year that the message was delivered.
• date: Date that the message was delivered.
• name: Name of the US President delivering the message.
• count_of_all_words: Count of all words in the document.
• count_of_keywords: Count of all keywords encountered in that document.
• Keyword specific columns - three per keyword. For example, for the 'energy' keyword, the 'energy' column gives the number of times the 'energy' keyword was counted in the message, 'energy_pct_of_keywords' gives this count as a percentage of all keywords, and 'energy_pct_of_all_words' gives this count as a percentage of all words

Below is the list of keywords that match when the search is applied to a dictionary file containing over 99,000 US English words.

• energy: 'energy'
• tax: 'nontaxable', 'overtax', 'overtaxed', 'overtaxes', 'overtaxing', 'surtax', 'surtaxed', 'surtaxes', 'surtaxing', 'surtaxs', 'tax', 'taxable', 'taxation', 'taxations', 'taxed', 'taxes', 'taxing', 'taxpayer', 'taxpayers', 'taxs'
• defense: 'defend', 'defense'
• education: 'education'
• employment: 'employ', 'employable', 'employe', 'employed', 'employee', 'employees', 'employer', 'employers', 'employes', 'employing', 'employment', 'employments', 'employs', 'underemployed', 'unemployable', 'unemployed', 'unemployeds', 'unemployment', 'unemployments'
• research: 'research', 'researched', 'researcher', 'researchers', 'researches', 'researching', 'researchs'
• shooting: 'shooting'
• space: 'space'
• nuclear: 'nuclear'
• natural resources: 'natural resources'
• racism: 'racism', 'civil rights'
• crime: 'crime', 'crimes', 'criminal', 'criminally', 'criminals', 'decriminalization', 'decriminalizations', 'decriminalize', 'decriminalized', 'decriminalizes', 'decriminalizing'
• environment: 'environment', 'environmental', 'environmentalism', 'environmentalisms', 'environmentalist', 'environmentalists', 'environmentally', 'environments'
• religion: 'faith', 'god', 'prayer', 'religion'
• health: 'health', 'healthful', 'healthfully', 'healthfulness', 'healthfulnesss', 'healthier', 'healthiest', 'healthily', 'healthiness', 'healthinesss', 'healths', 'healthy', 'unhealthful', 'unhealthier', 'unhealthiest', 'unhealthy'
• terror: 'terror', 'terrorism', 'terrorisms', 'terrorist', 'terrorists', 'terrorize', 'terrorized', 'terrorizes', 'terrorizing', 'terrors'
• war: 'war', 'warrior', 'warriors', 'wars'
• economy: 'economic', 'economical', 'economically', 'economics', 'economicss', 'economy', 'economys', 'microeconomics', 'microeconomicss', 'socioeconomic', 'uneconomic', 'uneconomical'
• jobs: 'jobs'
• business: 'agribusiness', 'agribusinesses', 'agribusinesss', 'business', 'businesses', 'businesslike', 'businessman', 'businessmans', 'businessmen', 'businesss', 'businesswoman', 'businesswomans', 'businesswomen'
• drugs: 'drugs', 'narcotics'
• inflation: 'inflation'
• climate: 'climate'
• science: 'science', 'sciences', 'scientific', 'scientifically', 'scientist', 'scientists'
• gun: 'gun', 'gunfire', 'gunman', 'guns', 'handgun', 'rifle', 'shotgun'
• tech: 'biotechnology', 'biotechnologys', 'technical', 'technological', 'technologically', 'technologies', 'technologist', 'technologists', 'technology', 'technologys'
• military: 'military'
• security: 'security'
• housing: 'housing'
• pollution: 'pollution'

The dictionary file used is a standard file among Linux systems, and the version used was provided with version 7.1-1 of the Ubuntu 'wamerican' package. Two extra phrases, which do not appear in the dictionary file, are added to the list: 'civil rights' (under the 'racism' keyword) and 'natural resources' (under the 'natural resources' theme).