County Transportation Profiles
County Transportation Profiles
By Bureau of Transportation Statistics
County Transportation Profile Statistics
Product type
Dataset
Update frequency
Annually
Updated
Oct 16, 2022
Delivery method
Download
Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.
Dataset file name: County_Transportation_Profiles.csv
Key Statistics
Total records
3,142
Missing values
0.905%
Duplicate rows
0%
Columns
Columns
22
Categorical
1
Numeric
20
Date/time
0
Correlations
Correlations
17
Correlated columns
Number of resident workers who commute within county and Number of residents, Number of workers from other counties who commute to work in the county and Number of business establishments, Number of resident workers who work at home and Number of resident workers who commute within county, Number of workers from other counties who commute to work in the county and Number of resident workers who commute to work in other counties, Number of resident workers who commute within county and Number of resident workers, Number of workers from other counties who commute to work in the county and Number of residents, County FIPS and State FIPS, Number of resident workers who commute to work in other counties and Number of residents, Number of residents and Number of business establishments, Number of resident workers who commute to work in other counties and Number of resident workers, Number of resident workers who work at home and Number of business establishments, Number of resident workers and Number of business establishments, Number of resident workers who work at home and Number of residents, Number of resident workers and Number of residents, Number of workers from other counties who commute to work in the county and Number of resident workers, Number of resident workers who work at home and Number of resident workers, Number of resident workers who commute within county and Number of business establishments
Column name | Type | Unique values | Min value | Max value |
---|---|---|---|---|
State FIPS | numeric | 51 | 1 | 56 |
County FIPS | numeric | 3,142 | 1001 | 56045 |
Non-Commercial -Civil Public Use Airports and Seaplane base | numeric | 21 | 0 | 48 |
Primary and Commercial Airports | numeric | 8 | 0 | 8 |
Number of Bridges | numeric | 586 | 1 | 3889 |
Number of business establishments | numeric | 1,748 | 4 | 275316 |
Non-Commercial -Other Aerodromes | numeric | 49 | 0 | 163 |
Percent of resident workers who commute by transit | numeric | 2,571 | 0 | 0.6176063 |
% of Poor Condition Bridges | numeric | 1,817 | 0 | 0.6666667 |
Number of workers from other counties who commute to work in the county | numeric | 2,771 | 8 | 628360 |
Number of resident workers who work at home | numeric | 818 | 4 | 239520 |
Number of resident workers | numeric | 2,558 | 40 | 4591360 |
Number of resident workers who commute within county | numeric | 2,303 | 30 | 4248855 |
Total Docks | numeric | 49 | 0 | 101 |
Number of resident workers who commute to work in other counties | numeric | 2,662 | 0 | 609108 |
Route miles of freight railroad | numeric | 1,110 | 0.1 | 816.1 |
Number of residents | numeric | 2,885 | 75 | 10057155 |
Total Marinas | numeric | 3 | 0 | 3 |
% of Medium to Fair Condition Bridges | numeric | 1,817 | 0.33333334 | 1 |
Route miles of passenger railroad and rail transit | numeric | 488 | 0 | 431.5 |
State Name | categorical | 51 | 4 | 20 |
County Name | text | 1,877 | 10 | 33 |