Name: U.S Tourism From Year Between 2018 To 2023
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

U.S Tourism From Year Between 2018 To 2023

Dataset's Source:

https://www.bea.gov/data/special-topics/travel-and-tourism/tourism-satellite-accounts-data-sheets

In addition to new data for 2023, the U.S. Bureau of Economic Analysis (BEA) published updated national-level travel and tourism statistics from 2018 to 2022. The majority of the source data used in these updated and readily accessible statistics comes from the 2024 yearly update of BEA's National Economic Accounts, which includes the Industry Economic Accounts. One These enhancements enable the Travel and Tourism Satellite Account (TTSA) to more accurately represent the dynamics of this industry when combined with updated and new source data related to tourism. The International Trade Administration's National Travel and Tourism Office provides financing for BEA's Travel and Tourism Satellite Account.

Here are the column descriptions for each file:

Demand for Commodities by Type of Visitor.csv

Commodity: The type of good or service.

Total consumption: Overall consumption.

Resident households: Consumption by resident households.

Business: Consumption by businesses.

Government: Consumption by government.

Nonresidents: Consumption by nonresidents.

Total tourism demand: Total demand from tourism.

Nontourism demand: Demand not related to tourism.

Tourism commodity ratio: Ratio of tourism demand to total consumption.

Year: The year of the data.

Employment and Compensation of Employees by Industry.csv

Industry: The specific industry.

Total employment (thousands of employees): Total number of employees in thousands.

Compensation (millions of dollars): Employee compensation in millions of dollars.

Tourism industry ratio: Ratio of tourism employment to total employment.

Tourism employment (thousands of employees): Tourism-related employment in thousands.

Tourism compensation (millions of dollars): Tourism-related compensation in millions of dollars.

Average compensation per tourism employee: Average compensation for tourism employees.

Year: The year of the data.

Employment by Industry.csv

Industry: The specific industry.

Direct tourism employment: Employment directly related to tourism.

Total industry employment multiplier: Multiplier for total industry employment.

Total tourism-related employment: Total employment related to tourism.

Year: The year of the data.

Output and Value Added by Industry.csv

Industry: The specific industry.

Industry output: Total output of the industry.

Intermediate consumption: Goods and services consumed in the production process.

Value added: Value added by the industry.

Tourism industry ratio: Ratio of tourism output to total industry output.

Tourism output: Output related to tourism.

Tourism intermediate consumption: Intermediate consumption related to tourism.

Tourism value added: Value added related to tourism.

Year: The year of the data.

Output by Commodity.csv

Commodity: The type of good or service.

Domestic production at purchasers' prices: Domestic production valued at prices paid by purchasers.

Tourism commodity ratio: Ratio of direct tourism output to domestic production.

Direct tourism output: Output directly from tourism.

Total commodity output multiplier: Multiplier for total commodity output.

Total tourism-related output: Total output related to tourism.

Year: The year of the data.

Production of Commodities by Industry.csv

Commodity: The type of good or service being produced.

Industry-specific columns: Each column (e.g., Traveler accommodations, Food services) represents an industry and shows the production of the commodity by that industry.

Domestic production at producers' prices: Total domestic production valued at prices received by producers.

Year: The year of the data.

Real Tourism Output.csv

Commodity: The type of good or service.

Direct output (Millions of dollars): Direct output in millions of dollars.

Chain-type price index: Price index used for chaining.

Real output (Millions of chained (2017) dollars): Real output in millions of chained (2017) dollars.

Year: The year of the data.

Supply and Consumption of Commodities.csv

Domestic production at producers' prices: Domestic output at producers' prices.

Imports: Goods and services brought into the country.

Change in private inventories: Changes in private stock of goods.

Wholesale trade margins and transportation costs: Costs associated with wholesale trade and transportation.

Retail trade margins: Margins from retail trade.

Total supply at purchasers' prices: Total supply valued at prices paid by purchasers.

Intermediate: Intermediate consumption.

Personal consumption expenditures: Spending by households on goods and services.

Gross private fixed investment: Investment by private businesses.

Government final expenditures: Government spending.

Exports of goods and services: Goods and services sold to other countries.

Total consumption: Overall consumption.

Year: The year of the data.

Tables

Demand For Commodities By Type Of Visitor

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.demand_for_commodities_by_type_of_visitor

14.77 KB
168 rows
10 columns


CREATE TABLE demand_for_commodities_by_type_of_visitor (
  "commodity" VARCHAR,
  "total_consumption" BIGINT,
  "resident_households" BIGINT,
  "business" BIGINT,
  "government" BIGINT,
  "nonresidents" BIGINT,
  "total_tourism_demand" BIGINT,
  "nontourism_demand" BIGINT,
  "tourism_commodity_ratio" DOUBLE,
  "year" BIGINT
);

Employment And Compensation Of Employees By Industry

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.employment_and_compensation_of_employees_by_industry

13.15 KB
168 rows
8 columns


CREATE TABLE employment_and_compensation_of_employees_by_industry (
  "industry" VARCHAR,
  "total_employment_thousands_of_employees" BIGINT,
  "compensation_millions_of_dollars" BIGINT,
  "tourism_industry_ratio" DOUBLE,
  "tourism_employment_thousands_of_employees" BIGINT,
  "tourism_compensation_millions_of_dollars" BIGINT,
  "average_compensation_per_tourism_employee" DOUBLE,
  "year" BIGINT
);

Employment By Industry

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.employment_by_industry

7.23 KB
168 rows
5 columns


CREATE TABLE employment_by_industry (
  "industry" VARCHAR,
  "direct_tourism_employment" BIGINT,
  "total_industry_employment_multiplier" DOUBLE,
  "total_tourism_related_employment" BIGINT,
  "year" BIGINT
);

Output And Value Added By Industry

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.output_and_value_added_by_industry

14.63 KB
168 rows
9 columns


CREATE TABLE output_and_value_added_by_industry (
  "industry" VARCHAR,
  "industry_output" BIGINT,
  "intermediate_consumption" BIGINT,
  "value_added" BIGINT,
  "tourism_industry_ratio" DOUBLE,
  "tourism_output" BIGINT,
  "tourism_intermediate_consumption" BIGINT,
  "tourism_value_added" BIGINT,
  "year" BIGINT
);

Output By Commodity

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.output_by_commodity

10.33 KB
150 rows
7 columns


CREATE TABLE output_by_commodity (
  "commodity" VARCHAR,
  "domestic_production_at_purchasers_prices" BIGINT,
  "tourism_commodity_ratio" DOUBLE,
  "direct_tourism_output" BIGINT,
  "total_commodity_output_multiplier" DOUBLE,
  "total_tourism_related_output" BIGINT,
  "year" DOUBLE
);

Production Of Commodities By Industry

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.production_of_commodities_by_industry

41.86 KB
228 rows
30 columns


CREATE TABLE production_of_commodities_by_industry (
  "commodity" VARCHAR,
  "traveler_accommodations" BIGINT,
  "nonfarm_residential_tenant_occupied_permanent_site" BIGINT,
  "food_services_and_drinking_places" BIGINT,
  "air_transportation" BIGINT,
  "rail_transportation" BIGINT,
  "water_transportation" BIGINT,
  "interurban_bus_transportation" BIGINT,
  "interurban_charter_bus_transportation" BIGINT,
  "urban_transit_systems_and_other_transportation" BIGINT,
  "taxi_service" BIGINT,
  "scenic_and_sightseeing_transportation" BIGINT,
  "automotive_equipment_rental_and_leasing" BIGINT,
  "automotive_repair_services" BIGINT,
  "parking_lots_and_garages" BIGINT,
  "toll_highways" BIGINT,
  "travel_arrangement_and_reservation_services" BIGINT,
  "motion_pictures_and_performing_arts" BIGINT,
  "spectator_sports" BIGINT,
  "participant_sports" BIGINT,
  "gambling" BIGINT,
  "all_other_recreation_and_entertainment" BIGINT,
  "petroleum_refineries" BIGINT,
  "industries_producing_nondurable_pce_commodities_exclud_a02ff95a" BIGINT,
  "wholesale_trade_and_transportation_services" BIGINT,
  "gasoline_service_stations" BIGINT,
  "retail_trade_services_excluding_gasoline_service_stations" BIGINT,
  "all_other_industries" BIGINT,
  "domestic_production_at_producers_prices" BIGINT,
  "year" BIGINT
);

Real Tourism Output

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.real_tourism_output

7.89 KB
150 rows
5 columns


CREATE TABLE real_tourism_output (
  "commodity" VARCHAR,
  "direct_output_millions_of_dollars" BIGINT,
  "chain_type_price_index" DOUBLE,
  "real_output_millions_of_chained_2017_dollars" BIGINT,
  "year" BIGINT
);

Supply And Consumption Of Commodities

@kaggle.aritra100_tourism_dataset_of_un_for_2018_to_2023.supply_and_consumption_of_commodities

22.55 KB
199 rows
15 columns


CREATE TABLE supply_and_consumption_of_commodities (
  "unnamed_0" VARCHAR,
  "domestic_production_at_producers_prices" DOUBLE,
  "imports" DOUBLE,
  "change_in_private_inventories" DOUBLE,
  "wholesale_trade_margins_and_transportation_costs" DOUBLE,
  "retail_trade_margins" DOUBLE,
  "total_supply_at_purchasers_prices" DOUBLE,
  "intermediate" VARCHAR,
  "unnamed_8" VARCHAR,
  "personal_consumption_expenditures" DOUBLE,
  "gross_private_fixed_investment" DOUBLE,
  "government_final_expenditures" DOUBLE,
  "exports_of_goods_and_services" DOUBLE,
  "total_consumption" DOUBLE,
  "unnamed_14" VARCHAR
);