TXLookupGitHub ↗

Sources & citations · the provenance ledger

Every dataset. Every column. Every dependency.

6,061 datasets indexed across 6 portals. 11 deeply curated with column-level glossaries. Every claim the agent makes routes back through this ledger — portal, dataset id, column definition, the SODA URL it ran.

6,061

Indexed datasets

11

Curated

6

Portals

36

Glossary terms

Portals

Six portals. Two API styles. Public data only.

Every dataset on this site comes from one of these public open-data portals. We never scrape or re-host — every query routes back to the portal as the source of truth.

  • City of Austin · Open Data Portal

    2,387

    data.austintexas.gov · Socrata SODA v2.1

    License: Public domain (City of Austin terms of use)

    Source data © City of Austin · used per public-records terms

    Visit portal ↗

  • Austin Data Hub

    1,333

    datahub.austintexas.gov · Socrata SODA v2.1

    License: Public domain (City of Austin)

    Source data © City of Austin · used per public-records terms

    Visit portal ↗

  • State of Texas · Open Data

    1,051

    data.texas.gov · Socrata SODA v2.1

    License: Public domain (Texas Public Information Act)

    Source data © State of Texas · used per Texas Public Information Act

    Visit portal ↗

  • City of Dallas · Open Data

    1,044

    www.dallasopendata.com · Socrata SODA v2.1

    License: Public domain (City of Dallas)

    Source data © City of Dallas · used per public-records terms

    Visit portal ↗

  • City of San Antonio · Open Data

    163

    data.sanantonio.gov · CKAN v3

    License: City of San Antonio open data terms

    Source data © City of San Antonio

    Visit portal ↗

  • City of Houston · Open Data

    83

    data.houstontx.gov · CKAN v3

    License: City of Houston open data terms

    Source data © City of Houston

    Visit portal ↗

Citations · the curated 11

Every dataset the agent deeply knows.

These 11 datasets carry full schema knowledge — hand-picked SoQL, glossary entries per key column, locally-mirrored rows. Anything else from the 6,061-dataset universe is answered on demand: agent reads the schema live, plans a query, runs it.

  • Issued Construction Permits

    curated
    3syk-w9eu·data.austintexas.gov·Development Services Department·daily·2,354,632 rows

    Every construction permit issued by the City of Austin since the 1980s — type, address, contractor, status, value.

    Glossary · key columns

    permittype
    Short permit code (e.g. BP=Building, EP=Electrical, MP=Mechanical, PP=Plumbing).
    status_current
    Current state — Active, Final, Issued, Expired, Cancelled, Withdrawn, Hold.
    original_address1
    Street address as filed on the permit application.
    original_zip
    5-digit ZIP code where the permit was issued.
    issue_date
    Date the permit was officially issued by the city.
    work_class
    Specific work category — New, Addition, Remodel, Demolition.
    permit_class_mapped
    High-level category — Residential, Commercial, Mixed-Use, etc.
    contractor_company_name
    Contractor of record. Useful for contractor-by-volume rankings.
    total_job_valuation
    Declared dollar value of the work.
    Open in portal ↗SODA endpoint ↗Detail page →

  • Food Establishment Inspection Scores

    curated
    ecmv-9xxi·data.austintexas.gov·Austin Public Health·weekly·120,000+ rows

    Health-inspection scores and violations for Austin restaurants, food trucks, and grocery stores.

    Glossary · key columns

    restaurant_name
    Establishment name as registered with the health department.
    score
    Inspection score, 0-100. Below 70 is a failing grade in Austin.
    inspection_date
    Date the inspection was conducted.
    address
    Street address of the establishment (across multiple datasets).
    zip_code
    5-digit ZIP code (across multiple datasets).
    process_description
    Inspection type — Routine, Follow-up, Complaint-based, Pre-opening.
    Open in portal ↗SODA endpoint ↗Detail page →

  • Austin 311 Public Data

    curated
    xwdj-i9he·datahub.austintexas.gov·Communications & Public Information·daily·1,500,000+ rows

    Every non-emergency 311 call logged in Austin — pothole, graffiti, animal services, code complaints, by zip and department.

    Glossary · key columns

    sr_type_desc
    Service-request category — Loose Dog, Pothole, Code Violation, Bulk Trash, etc.
    sr_status_desc
    Status of the request — Open, Closed, In Progress, Cancelled.
    sr_location_zip_code
    ZIP code where the request was reported.
    sr_created_date
    When the resident filed the 311 request.
    sr_department_desc
    City department that owns the request (Watershed, Animal Services, etc.).
    sr_location
    — agent reads schema live
    Open in portal ↗SODA endpoint ↗Detail page →

  • Austin Code Complaint Cases

    curated
    6wtj-zbtb·data.austintexas.gov·Code Department·daily·300,000+ rows

    Active, closed, and pending building/zoning/STR code complaint cases — address, type, priority, department, and open date.

    Glossary · key columns

    case_type
    Violation category — Brush, Junk, Inoperable Vehicle, Substandard Structure.
    status
    Case state — Active, Pending, Closed.
    address
    Street address of the establishment (across multiple datasets).
    zip_code
    5-digit ZIP code (across multiple datasets).
    opened_date
    When the case was opened.
    priority
    Severity tier — numeric in Code Enforcement (lower = higher priority).
    department
    Owning department within Code Enforcement.
    Open in portal ↗SODA endpoint ↗Detail page →

  • Crime Reports

    curated
    fdj4-gpfu·data.austintexas.gov·Austin Police Department·weekly·2,000,000+ rows

    Reported crimes by type, location, and time. APD case-level data with UCR categories and clearance status.

    Glossary · key columns

    crime_type
    — agent reads schema live
    category_description
    — agent reads schema live
    location_type
    — agent reads schema live
    occ_date
    — agent reads schema live
    council_district
    — agent reads schema live
    clearance_status
    — agent reads schema live
    family_violence
    — agent reads schema live
    Open in portal ↗SODA endpoint ↗Detail page →

  • Austin Crash Report Data

    curated
    y2wy-tgr5·data.austintexas.gov·Austin Transportation·monthly·1,000+ rows

    All crash-level records — fatalities, serious injuries, pedestrian/bicycle/motorcycle breakdowns, speed limits, collision types.

    Glossary · key columns

    crash_fatal_fl
    — agent reads schema live
    death_cnt
    — agent reads schema live
    tot_injry_cnt
    — agent reads schema live
    rpt_street_name
    — agent reads schema live
    crash_speed_limit
    — agent reads schema live
    crash_timestamp
    — agent reads schema live
    pedestrian_death_count
    — agent reads schema live
    bicycle_death_count
    — agent reads schema live
    collsn_desc
    — agent reads schema live
    Open in portal ↗SODA endpoint ↗Detail page →

  • Active Franchise Tax Permit Holders

    curated
    9cir-efmm·data.texas.gov·Texas Comptroller of Public Accounts·quarterly·1,800,000+ rows

    Every active franchise tax permit holder in Texas — business name, city, zip, org type, county, right-to-transact status.

    Glossary · key columns

    taxpayer_name
    Registered business name.
    taxpayer_city
    City where the entity is registered.
    taxpayer_state
    — agent reads schema live
    taxpayer_zip
    ZIP code of registered address.
    taxpayer_organizational_type
    — agent reads schema live
    taxpayer_county_code
    Numeric county code; 227 = Travis County.
    responsibility_beginning_date
    Date the entity became responsible for franchise tax.
    Open in portal ↗SODA endpoint ↗Detail page →

  • Texas State Expenditures By County 2024

    curated
    2zpi-yjjs·data.texas.gov·Texas Comptroller of Public Accounts·monthly·100,000+ rows

    State of Texas spending by agency and major spending category — fiscal year 2024.

    Glossary · key columns

    fiscal_year
    — agent reads schema live
    agency_name
    — agent reads schema live
    major_spending_category
    — agent reads schema live
    amount
    — agent reads schema live
    Open in portal ↗SODA endpoint ↗Detail page →

  • Mixed Beverage Gross Receipts

    curated
    naix-2893·data.texas.gov·Texas Comptroller of Public Accounts·monthly·5,000,000+ rows

    Liquor, wine, beer, and cover-charge receipts reported by every mixed-beverage permit holder in Texas.

    Glossary · key columns

    location_name
    — agent reads schema live
    taxpayer_city
    City where the entity is registered.
    total_receipts
    — agent reads schema live
    liquor_receipts
    — agent reads schema live
    beer_receipts
    — agent reads schema live
    wine_receipts
    — agent reads schema live
    obligation_end_date_yyyymmdd
    — agent reads schema live
    Open in portal ↗SODA endpoint ↗Detail page →

  • Dallas Police Active Calls

    curated
    9fxf-t2tr·www.dallasopendata.com·Dallas Police Department·daily·60,000+ rows

    Live feed of active Dallas Police calls — incident type, division, priority, location, and status.

    Glossary · key columns

    division
    — agent reads schema live
    nature_of_call
    — agent reads schema live
    priority
    Severity tier — numeric in Code Enforcement (lower = higher priority).
    date
    — agent reads schema live
    block
    — agent reads schema live
    location
    — agent reads schema live
    beat
    — agent reads schema live
    status
    Case state — Active, Pending, Closed.
    Open in portal ↗SODA endpoint ↗Detail page →

  • Dallas 311 Service Requests

    curated
    gc4d-8a49·www.dallasopendata.com·Dallas 311 Customer Service·daily·1,200,000+ rows

    Every non-emergency 311 service request filed in Dallas — type, department, council district, status, response time.

    Glossary · key columns

    service_request_type
    — agent reads schema live
    department
    Owning department within Code Enforcement.
    city_council_district
    — agent reads schema live
    status
    Case state — Active, Pending, Closed.
    created_date
    When the Dallas 311 case was filed.
    priority
    Severity tier — numeric in Code Enforcement (lower = higher priority).
    Open in portal ↗SODA endpoint ↗Detail page →

Software dependencies

Built on open standards.

License & attribution

Code: MIT. Data: city + state public-records terms.

Code license

MIT License · Copyright (c) 2026 ATX-TXLookup contributors. See LICENSE for full terms.

Data attribution

All data is the property of its issuing agency, used under public-records terms. TXLookup does not claim ownership of any source data. Each portal is linked above with its specific license.