{
    "name": "San Antonio Mixed Beverage Receipts API",
    "description": "Alcohol sales reported by every mixed-beverage permit holder in Bexar County, Texas, by month and by ZIP code, with a disclosure floor and the reporting artefacts stated rather than hidden.",
    "meta": {
        "built": "2026-08-27T23:45:05+00:00",
        "window": {
            "from": "2007-01",
            "to": "2026-07",
            "months": 235
        },
        "excluded_partial": [
            {
                "m": "2026-08",
                "filings": 8,
                "median_filings": null,
                "reason": "Still being filed. Excluded so the series does not show reporting lag as a collapse."
            }
        ],
        "source": {
            "name": "Texas Comptroller of Public Accounts - Mixed Beverage Gross Receipts",
            "dataset": "https://data.texas.gov/d/naix-2893",
            "api": "https://data.texas.gov/resource/naix-2893.json",
            "county_code_used": "015",
            "county_code_note": "Comptroller county numbering, which is alphabetical. Bexar is 015. Bexar's FIPS code, 029, selects Calhoun County in this dataset and returns a full plausible result with no error."
        }
    },
    "headline": {
        "complete_months": 235,
        "venues": 4634,
        "receipts_usd": 11788320088,
        "covid": {
            "pre_month": "2020-02",
            "pre_receipts": 60682757,
            "pre_venues": 1213,
            "trough_month": "2020-04",
            "trough_receipts": 2987421,
            "trough_venues": 1221,
            "drop_pct": 95.1,
            "venue_change_pct": 0.7
        },
        "what_that_shows": "Receipts fell 95.1% between 2020-02 and 2020-04 while the number of filing permit holders changed by 0.7%. The revenue stopped; the businesses, on this record, did not."
    },
    "endpoints": [
        {
            "href": "https://brandshyp.org/api/v1/mixed-beverage",
            "returns": "This discovery document"
        },
        {
            "href": "https://brandshyp.org/api/v1/mixed-beverage/summary",
            "returns": "Citywide totals and the drink mix with its coverage rate"
        },
        {
            "href": "https://brandshyp.org/api/v1/mixed-beverage/months",
            "returns": "The full monthly series, complete months only"
        },
        {
            "href": "https://brandshyp.org/api/v1/mixed-beverage/zips",
            "returns": "Per-ZIP over the trailing window, above the disclosure floor"
        },
        {
            "href": "https://brandshyp.org/api/v1/mixed-beverage/quality",
            "returns": "What will make you wrong. Read this one first."
        },
        {
            "href": "https://brandshyp.org/api/v1/mixed-beverage/summary.csv",
            "returns": "The whole cube as tidy CSV"
        },
        {
            "href": "https://brandshyp.org/api/v1/mixed-beverage/openapi.json",
            "returns": "OpenAPI 3.1 description"
        }
    ],
    "openapi": "https://brandshyp.org/api/v1/mixed-beverage/openapi.json",
    "documentation": "https://brandshyp.org/san-antonio-bar-revenue/",
    "caveats": {
        "gross_receipts": "These are gross receipts reported by holders of a TABC mixed-beverage permit. They are revenue, not profit, and they cover alcohol sales only.",
        "permit_universe": "A venue without a mixed-beverage permit does not appear at all. Absence from this dataset is not evidence that a business does not exist.",
        "not_a_denominator": "This is not a population denominator. Receipts measure commercial and nightlife activity, not residents or daytime population, and dividing another statistic by them will mislead.",
        "disclosure_floor": "ZIP codes reporting fewer than 5 permit holders are withheld, because at that size a ZIP total is one identifiable company's revenue. Their dollars remain in the citywide totals.",
        "partial_months": "The most recent months are excluded until filings stop arriving. A partial month looks like a collapse and is not one.",
        "mix_coverage": "The drink-type breakdown is reported by only some filers, so its percentages are computed over a subset of dollars and are published beside that subset's coverage rate.",
        "county_code": "County selection uses Comptroller numbering, in which Bexar is 015. Bexar's FIPS code selects a different county in this dataset without raising an error."
    }
}