What everyone’s looking at.

Single audit summary records from the Federal Audit Clearinghouse (FAC) for entities expending $750,000 or more in federal awards. Each row is one audit engagement: the auditee (name, EIN, UEI, address), the auditor firm, fiscal year dates, total federal expenditures, audit opinions, internal control findings, and material noncompliance disclosures. Covers audits accepted by the FAC from 2016 through the most recent quarterly data release. Join to fac/federal-awards on `report_id` for program-level expenditure detail, and to fac/audit-findings on `report_id` for specific finding records.

Monthly housing market statistics for ~930 U.S. Metropolitan Statistical Areas (MSAs), compiled by Redfin from MLS and public record data. Covers median sale price, median list price, price per square foot, homes sold, pending sales, new listings, inventory, months of supply, days on market, sale-to-list ratio, and share of homes sold above list, broken out by property type (all residential, single family, condo/co-op, townhouse, multi-family) and by seasonal adjustment. Each row is one metro/property-type/seasonal-adjustment combination for one calendar month. Coverage starts January 2012 and updates monthly.

Monthly U.S. national housing market metrics from Redfin's Data Center, covering January 2012 to present. Includes median sale price, median list price, price per square foot, homes sold, pending sales, new listings, inventory, months of supply, median days on market, sale-to-list ratio, the share of homes sold above list price, price drops, and homes going off market within two weeks. Broken out by property type (all residential, single family, condo/co-op, townhouse, multi-family, single-unit) and by seasonal adjustment, with month-over-month and year-over-year change columns for every metric.

Occupational Employment and Wage Statistics (OEWS) provides employment and wage estimates for over 800 occupations at the national, state, and metropolitan area levels. Essential for labor market analysis, wage benchmarking, and workforce planning.

Individual audit findings from single audits submitted to the Federal Audit Clearinghouse. Each row is one finding: whether it involves material weakness, modified opinion, questioned costs, significant deficiency, or repeat findings from prior audits. Covers audits accepted from 2016 through the most recent quarterly release (~674K rows). Join to fac/single-audits on `report_id` for auditee details, and to fac/federal-awards on `report_id` + `award_reference` to see which federal program the finding applies to.

Campaign contributions reported to the Texas Ethics Commission (TEC), covering all electronically filed political contributions in Texas since July 2000. Includes contributor name, employer, occupation, amount, date, and recipient filer (candidate/PAC). Concatenated from ~50 numbered CSV files within the TEC daily bulk download ZIP. Updated daily.

Labor Force Statistics from the Current Population Survey (CPS). Includes civilian labor force, employment, unemployment, unemployment rate, labor force participation rate, and employment-population ratio. National data by demographics, industry, occupation, and other characteristics.

American Time Use Survey (ATUS) measures the amount of time people spend doing various activities such as paid work, childcare, volunteering, and socializing. The only federal survey providing comprehensive data on the full range of nonmarket activities, from household work to leisure. Published annually since 2003.

School-level gifted and talented (GT) program enrollment from the U.S. Department of Education's Civil Rights Data Collection (CRDC). Covers all public K-12 schools nationwide, collected biennially. Includes total GT enrollment by sex, racial/ethnic breakdowns, English learner status, and IDEA (disability) status per school. Values of -9 indicate suppressed or inapplicable data (e.g., schools without a GT program report -9 for all enrollment fields). These are exposed as-is in the raw data; the `with-program` and `illinois-with-program` views null them out so aggregations are accurate. To join with Illinois state data: match `lea_name` + `sch_name` against `isbe/report-card` (school_name + district) or `isbe/sat-scores`. COMBOKEY is the NCES standard identifier but ISBE uses RCDTS codes, so name-matching is the practical join path for IL equity analysis. Coverage: 2015-16, 2017-18, 2020-21, 2021-22 collections (~360,000 school-year records). 2013-14 data exists but uses a different XLSX format with an extra disclosure column; it can be added later.

State and Area Employment, Hours, and Earnings from the Current Employment Statistics (CES) survey. Provides monthly estimates of employment, hours, and earnings for states and metropolitan areas by industry sector.

Game-by-game NFL results and schedules from 1999 to the present, maintained by the nflverse open-source community project. Each row is one game: final score, closing betting lines (spread, total, moneyline), starting quarterbacks, head coaches, referee, stadium, and weather at kickoff. Covers regular season and every playoff round (wild card, divisional, conference championship, Super Bowl). Rows for games not yet played (future schedule) carry team, date, and time but have null score, result, total, and overtime. spread_line and total_line follow the standard sportsbook convention: spread_line is the home team's line, so a negative value means the home team was favored; total_line is the combined over/under. result is home_score minus away_score, so a positive result means the home team won.

Modeled Wage Estimates from the National Compensation Survey. Provided annual estimates of average hourly wages for occupations by job characteristics (union status, work level, pay basis) and geographic area, combining OEWS and NCS data. Note: This program was discontinued in August 2024 with final 2023 estimates. Historical data remains available.

Line-item vendor payment transactions for California state government, published by the state's FI$Cal financial system as one CSV per department per fiscal year on the Open FI$Cal transparency portal. Each row is a single accounting transaction: department, vendor, account classification, fund, program, budget reference, and the monetary amount. This dataset is not a new state disclosure -- it is the state's own transaction-level transparency publication, unioned across all 188 departments and FY2016-FY2025 (1,230 department-fiscal-year files, ~40M rows, 10.7 GB) into one queryable table, rather than downloading one department-year CSV at a time from the portal. `department_name` is present on every row, so a department-level spending rollup is already available here (see the `by-department-year` view below) without also ingesting the state's separate ~125 GB department-spending file family, which carries a near-identical schema (columns suffixed `_1`/`_0`) but no vendor name and is not part of this dataset. This dataset is multi-source (one file per department-fiscal-year) and is not on an automatic sync schedule (`sync.interval: never`): the source is a fixed pointer CSV enumerating 1,230 files, and a new fiscal year means the pointer gains new rows that must be re-fetched and the `sources` list in this YAML regenerated, then a manual `POST /v1/datasets/ca-fiscal/vendor-transactions/refresh` triggered. Acceptance check for a full ingest: `SELECT COUNT(DISTINCT _source_url)` should equal 1230, and `SELECT COUNT(DISTINCT fiscal_year_begin)` should equal 10. A partial-success ingest (some department-year files failing to fetch) still reports `success=True` with a `"Partial success: N/M source(s) failed"` message rather than a hard failure, so the distinct-source-count check -- not the ingest exit status -- is what confirms full coverage.

Marital and Family Labor Force Statistics from the Current Population Survey. Provides annual data on employment status by marital status, presence and age of children, sex, race, and Hispanic origin. Tracks trends in dual-earner families, single-parent employment, and labor force participation by family structure.

School-level counts of students eligible for free or reduced-price meals under the National School Lunch Program, published annually by the California Department of Education from the CALPADS Fall 1 (Census Day) submission. One row per school per academic year, carrying enrollment, the free-meal-eligible count, and the unduplicated free-or-reduced-price (FRPM) count on two denominators: the K-12 population and the ages 5-17 population that federal Title I allocations use. FRPM eligibility is California's standard proxy for student poverty and the denominator that makes test-score, graduation, and accountability data interpretable, so this table is the poverty dimension that joins to the rest of the CDE data via the 14-digit CDS code. Covers 2011-12 through 2025-26. Two vintages are partial: 2011-12 publishes only the ages 5-17 denominator and no free-eligible rate, and 2012-13 leaves the counts blank at Provision 2/3 schools.

Union Affiliation data from the Current Population Survey (CPS). Provides annual statistics on union membership and representation rates by industry, occupation, demographics, and state. Key data for labor relations research and understanding collective bargaining coverage.

Local Area Unemployment Statistics (LAUS) provides monthly estimates of employment and unemployment for states, metropolitan areas, counties, and cities. Combines data from the Current Population Survey, Current Employment Statistics, and state unemployment insurance systems.

CDC's Childhood Blood Lead Surveillance (CBLS) system: the number of children under 72 months of age tested for lead, and the number with confirmed blood lead levels (BLLs) at or above various thresholds, by state/jurisdiction and year, 1997-2022. State and local childhood lead poisoning prevention programs funded by CDC cooperative agreements are required to report; other jurisdictions report voluntarily. One row is a state-year, plus a "U.S. Totals" aggregate row per year. Three CDC-published tables are combined to build the full time range, since no single CDC file covers 1997-2022: 1997-2011 (a merged-cell Excel table, mechanically re-tiled into a local CSV -- see PROVENANCE.md), 2012-2016 (a cleaner CDC-published Excel table), and 2017-2022 (the current CDC file). All three report the same underlying CBLS program data; only the file format and column layout changed over time. The elevated-BLL threshold CDC uses has changed twice: >=10 ug/dL was the sole "level of concern" through 2011, CDC added a >=5 ug/dL reference value in 2012, and lowered it further to >=3.5 ug/dL in October 2021. This dataset reports whichever thresholds each era's source table actually published, leaving the rest null rather than estimating -- do not read a null as zero. Concretely: bll_ge_3_5/bll_3_5_to_5 are populated 2022 onward only; bll_ge_5/bll_5_to_10 are populated 2010 onward (present but sparse in 2010-2011, consistently populated 2012 onward); bll_ge_10 is populated for the full 1997-2022 range. The detailed BLL bands (10-<15, 15-<20, 20-<25, 25-<45, >=45 ug/dL) are populated for the full range; the 1997-2011 source reported the top band as two bins (45-69 and >=70 ug/dL) which are summed into bll_ge_45 to match the newer schema -- see PROVENANCE.md for the exact harmonization. Because the elevated-threshold definition changed mid-series, a raw year-over-year comparison of "percent elevated" before and after 2012 (or 2022) is comparing two different clinical definitions, not just a trend -- use bll_ge_10 for an apples-to-apples comparison across the entire 1997-2022 range, since it is the one threshold reported in every era. Important limitation, stated explicitly by CDC: this table is not a population-based estimate and cannot be used to compare states or generate national prevalence estimates. Testing is initiated by healthcare providers (not universal screening), programs report only children with a confirmed lab result, and jurisdictions vary widely in what they report - some years/states show markedly lower tested counts than the jurisdiction's own published surveillance data because CDC's national compilation reflects only what was submitted to the national system. NHANES is CDC's recommended source for representative national prevalence estimates.

Weekly and Hourly Earnings from the Current Population Survey (CPS). Provides median usual weekly earnings of full-time wage and salary workers by age, sex, race, Hispanic origin, and other characteristics. Published quarterly, this data is central to understanding wage trends and inequality.

Monthly housing market metrics (median sale price, inventory, days on market, sale-to-list ratio, and more) for individual US cities, broken out by property type. Sourced from Redfin's public data center, which aggregates MLS listing and sales data starting in 2012.

Campaign expenditures reported to the Texas Ethics Commission (TEC), covering all electronically filed political expenditures in Texas since July 2000. Includes payee name, amount, date, purpose, and the filer making the expenditure. Concatenated from ~50 numbered CSV files within the TEC daily bulk download ZIP. Updated daily.

Producer Price Index by Commodity classification. Measures price changes for goods at the commodity level (e.g., metals, chemicals, lumber) rather than by industry. Complements the industry-based PPI (pc series) with an alternative commodity-based view of producer price trends.

Business Employment Dynamics (BED) tracks gross job gains and losses at the establishment level. Measures job creation from opening and expanding establishments, and job destruction from closing and contracting ones. Quarterly data derived from the Quarterly Census of Employment and Wages.

Student financial aid data from the IPEDS Student Financial Aid survey covering every Title IV degree-granting institution in the United States. Includes counts and dollar amounts for institutional grants, federal Pell grants, other federal grants, state and local grants, federal student loans, and other loans. Also includes average net price by income quintile for first-time full-time students receiving grant or scholarship aid. One row per institution per academic year, 2009-10 through 2022-23. Joins to nces/ipeds on UNITID. Columns prefixed with "x" are IPEDS imputation flags (R=Reported, A=Not applicable, Z=Not reported, C=Corrected).