Name: All Permitted Sales Tax Locations And Local Sales Tax Responsibility
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

All Permitted Sales Tax Locations And Local Sales Tax Responsibility

This file includes all sales tax outlets, and local tax responsibility, in Texas which have been active during the last four years. Inactive outlets will include an Out-of-Business date.
Organization: City of Austin
Last updated: 2023-08-25T21:59:42.908950
Tags: permit, permit-holders, sales-tax

Tables

Table 1

@usgov.city_of_austin_all_permitted_sales_tax_locations_and_l_9c527766.table_1

118.81 MB
1,409,948 rows
33 columns

CREATE TABLE table_1 (
  "taxpayer_number" BIGINT,
  "taxpayer_name" VARCHAR,
  "taxpayer_address" VARCHAR,
  "taxpayer_city" VARCHAR,
  "taxpayer_state" VARCHAR,
  "taxpayer_zip_code" VARCHAR,
  "taxpayer_zip_4" VARCHAR  -- Taxpayer ZIP +4,
  "taxpayer_county" BIGINT,
  "organization_type" VARCHAR,
  "location_number" BIGINT,
  "location_name" VARCHAR,
  "location_address_number" VARCHAR,
  "location_address_text" VARCHAR,
  "permit_date" TIMESTAMP,
  "jurisdiction_city" VARCHAR,
  "postal_city" VARCHAR,
  "location_state" VARCHAR,
  "location_zip_code" DOUBLE,
  "location_zip_4" DOUBLE  -- Location ZIP +4,
  "location_county" BIGINT,
  "naics_code" DOUBLE,
  "inside_outside_city_limits" VARCHAR,
  "city_tax_authority_id" DOUBLE,
  "mass_transit_authority_1_id" DOUBLE,
  "mass_transit_authority_2_id" DOUBLE,
  "county_authority_id" DOUBLE,
  "spd_1_authority_id" DOUBLE,
  "spd_2_authority_id" DOUBLE,
  "spd_3_authority_id" DOUBLE,
  "spd_4_authority_id" DOUBLE,
  "unique_authority_id" DOUBLE,
  "first_sales_date" TIMESTAMP,
  "out_of_business_date" TIMESTAMP
);