Baselight
Sign In

Pittsburgh American Community Survey Census Data 2014 - Sex By Occupation

Allegheny County / City of Pittsburgh / Western PA Regional Data Center

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9

Loading...
Loading...

About this Dataset

Pittsburgh American Community Survey Census Data 2014 - Sex By Occupation

Occupation describes the kind of work a person does on the job. Occupation data were derived from answers to questions 45 and 46 in the 2015 American Community Survey (ACS). Question 45 asks: “What kind of work was this person doing?” Question 46 asks: “What were this person’s most important activities or duties?”

These questions were asked of all people 15 years old and over who had worked in the past 5 years. For employed people, the data refer to the person’s job during the previous week. For those who worked two or more jobs, the data refer to the job where the person worked the greatest number of hours. For unemployed people and people who are not currently employed but report having a job within the last five years, the data refer to their last job.

These questions describe the work activity and occupational experience of the American labor force. Data are used to formulate policy and programs for employment, career development, and training; to provide information on the occupational skills of the labor force in a given area to analyze career trends; and to measure compliance with antidiscrimination policies. Companies use these data to decide where to locate new plants, stores, or offices.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:03.579581
Tags: acs, american-community-survey, census, demographics, education, employment, language, occupation, poverty, public-assistance, race, retirement, salaries, salary, schools, sex, snap, social-security, survey, vacancy, welfare

Tables

Sex By Occupation, All Races

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_all_races
  • 230.74 kB
  • 91 rows
  • 148 columns
Loading... 
CREATE TABLE sex_by_occupation_all_races (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations:,
  "margin_of_error_male_management_business_science_and_a_db4a520a" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations:,
  "estimate_male_management_business_science_and_arts_occ_08e31583" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "margin_of_error_male_management_business_science_and_a_ef79e501" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "estimate_male_management_business_science_and_arts_occ_6aba6776" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "margin_of_error_male_management_business_science_and_a_474409a5" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "estimate_male_management_business_science_and_arts_occ_58edbed9" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "margin_of_error_male_management_business_science_and_a_3ccebbd1" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "estimate_male_management_business_science_and_arts_occ_9c2bb5b4" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "margin_of_error_male_management_business_science_and_a_de127ba8" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "estimate_male_management_business_science_and_arts_occ_a52d6ecc" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "margin_of_error_male_management_business_science_and_a_f12ee9d6" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "estimate_male_management_business_science_and_arts_occ_0f35d750" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "margin_of_error_male_management_business_science_and_a_1277edf0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "estimate_male_management_business_science_and_arts_occ_3d09ea4e" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "margin_of_error_male_management_business_science_and_a_40a86b36" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "estimate_male_management_business_science_and_arts_occ_1169c959" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "margin_of_error_male_management_business_science_and_a_f14400d3" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "estimate_male_management_business_science_and_arts_occ_52b81a7d" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "margin_of_error_male_management_business_science_and_a_853ef091" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "estimate_male_management_business_science_and_arts_occ_b2932a1e" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations,
  "margin_of_error_male_management_business_science_and_a_252c3e5f" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations,
  "estimate_male_management_business_science_and_arts_occ_44add988" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Education, Training, And Library Occupations,
  "margin_of_error_male_management_business_science_and_a_02d1a2c8" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Education, Training, And Library Occupations,
  "estimate_male_management_business_science_and_arts_occ_ee8e93bc" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Arts, Design, Entertainment, Sports, And Media Occupations,
  "margin_of_error_male_management_business_science_and_a_a4ee9b0e" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Arts, Design, Entertainment, Sports, And Media Occupations,
  "estimate_male_management_business_science_and_arts_occ_62275451" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations:,
  "margin_of_error_male_management_business_science_and_a_6a01a5d0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations:,
  "estimate_male_management_business_science_and_arts_occ_f331d6bd" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Diagnosing And Treating Practitioners And Other Technical Occupations,
  "margin_of_error_male_management_business_science_and_a_4f6fac93" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Diagnosing And Treating Practitioners And Other Technical Occupations,
  "estimate_male_management_business_science_and_arts_occ_70dac197" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Technologists And Technicians,
  "margin_of_error_male_management_business_science_and_a_acaa595c" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Technologists And Technicians,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations:,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations:,
  "estimate_male_service_occupations_healthcare_support_o_0a021731" DOUBLE  -- Estimate; Male: - Service Occupations: - Healthcare Support Occupations,
  "margin_of_error_male_service_occupations_healthcare_su_5babcada" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Healthcare Support Occupations,
  "estimate_male_service_occupations_protective_service_o_daa4ce99" DOUBLE  -- Estimate; Male: - Service Occupations: - Protective Service Occupations:,
  "margin_of_error_male_service_occupations_protective_se_54a57fa4" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Protective Service Occupations:,
  "estimate_male_service_occupations_protective_service_o_aefa04b9" DOUBLE  -- Estimate; Male: - Service Occupations: - Protective Service Occupations: - Fire Fighting And Prevention, And Other Protective Service Workers Including Supervisors,
  "margin_of_error_male_service_occupations_protective_se_ce60726c" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Protective Service Occupations: - Fire Fighting And Prevention, And Other Protective Service Workers Including Supervisors,
  "estimate_male_service_occupations_protective_service_o_77a73da8" DOUBLE  -- Estimate; Male: - Service Occupations: - Protective Service Occupations: - Law Enforcement Workers Including Supervisors,
  "margin_of_error_male_service_occupations_protective_se_d9807f79" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Protective Service Occupations: - Law Enforcement Workers Including Supervisors,
  "estimate_male_service_occupations_food_preparation_and_8a0d85aa" DOUBLE  -- Estimate; Male: - Service Occupations: - Food Preparation And Serving Related Occupations,
  "margin_of_error_male_service_occupations_food_preparat_66eedfea" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Food Preparation And Serving Related Occupations,
  "estimate_male_service_occupations_building_and_grounds_eb514494" DOUBLE  -- Estimate; Male: - Service Occupations: - Building And Grounds Cleaning And Maintenance Occupations,
  "margin_of_error_male_service_occupations_building_and__179b33e7" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Building And Grounds Cleaning And Maintenance Occupations,
  "estimate_male_service_occupations_personal_care_and_se_bb25655c" DOUBLE  -- Estimate; Male: - Service Occupations: - Personal Care And Service Occupations,
  "margin_of_error_male_service_occupations_personal_care_230446b2" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Personal Care And Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations:,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations:,
  "estimate_male_sales_and_office_occupations_sales_and_r_25e4e92a" DOUBLE  -- Estimate; Male: - Sales And Office Occupations: - Sales And Related Occupations,
  "margin_of_error_male_sales_and_office_occupations_sale_314807e8" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations: - Sales And Related Occupations,
  "estimate_male_sales_and_office_occupations_office_and__0093e4d6" DOUBLE  -- Estimate; Male: - Sales And Office Occupations: - Office And Administrative Support Occupations,
  "margin_of_error_male_sales_and_office_occupations_offi_3a19023d" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations: - Office And Administrative Support Occupations,
  "estimate_male_natural_resources_construction_and_maint_db526eae" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations:,
  "margin_of_error_male_natural_resources_construction_an_f8445317" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations:,
  "estimate_male_natural_resources_construction_and_maint_31742cd5" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations: - Farming, Fishing, And Forestry Occupations,
  "margin_of_error_male_natural_resources_construction_an_2e4e674f" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations: - Farming, Fishing, And Forestry Occupations,
  "estimate_male_natural_resources_construction_and_maint_60f504b0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations: - Construction And Extraction Occupations,
  "margin_of_error_male_natural_resources_construction_an_d8c2192e" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations: - Construction And Extraction Occupations,
  "estimate_male_natural_resources_construction_and_maint_c57b20e7" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations: - Installation, Maintenance, And Repair Occupations,
  "margin_of_error_male_natural_resources_construction_an_b760fe5d" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations: - Installation, Maintenance, And Repair Occupations,
  "estimate_male_production_transportation_and_material_m_f7ee0198" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations:,
  "margin_of_error_male_production_transportation_and_mat_9743e710" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations:,
  "estimate_male_production_transportation_and_material_m_2217dc69" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations: - Production Occupations,
  "margin_of_error_male_production_transportation_and_mat_b43c4914" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations: - Production Occupations,
  "estimate_male_production_transportation_and_material_m_355845cd" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations: - Transportation Occupations,
  "margin_of_error_male_production_transportation_and_mat_36492500" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations: - Transportation Occupations,
  "estimate_male_production_transportation_and_material_m_8b8ad761" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations: - Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_15e65d20" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations: - Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_35086808" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations:,
  "margin_of_error_female_management_business_science_and_7933eaab" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations:,
  "estimate_female_management_business_science_and_arts_o_26bd5bc7" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "margin_of_error_female_management_business_science_and_dbfd8605" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "estimate_female_management_business_science_and_arts_o_8b006706" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "margin_of_error_female_management_business_science_and_548d9401" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "estimate_female_management_business_science_and_arts_o_e4022d09" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "margin_of_error_female_management_business_science_and_95880986" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "estimate_female_management_business_science_and_arts_o_85771c0f" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "margin_of_error_female_management_business_science_and_9ea7df2a" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "estimate_female_management_business_science_and_arts_o_5706d644" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "margin_of_error_female_management_business_science_and_dac5a9f7" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "estimate_female_management_business_science_and_arts_o_93e36a61" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "margin_of_error_female_management_business_science_and_534e3975" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "estimate_female_management_business_science_and_arts_o_b9f167a2" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "margin_of_error_female_management_business_science_and_19e3059d" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "estimate_female_management_business_science_and_arts_o_dead2250" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "margin_of_error_female_management_business_science_and_f064f872" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "estimate_female_management_business_science_and_arts_o_36f54ecd" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "margin_of_error_female_management_business_science_and_00dc7e78" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "estimate_female_management_business_science_and_arts_o_52916c8f" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations,
  "margin_of_error_female_management_business_science_and_72242112" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations
);

Sex By Occupation, American Indian And Alaska Native Alone

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_american_indian_and_alaska_native_alone
  • 32.73 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_american_indian_and_alaska_native_alone (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Sex By Occupation, Asian Alone

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_asian_alone
  • 36.27 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_asian_alone (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Sex By Occupation, Black Or African American Alone

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_black_or_african_american_alone
  • 40.98 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_black_or_african_american_alone (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Sex By Occupation For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_for_the_full_time_year_round_civilia_5eb09330
  • 225.12 kB
  • 91 rows
  • 148 columns
Loading... 
CREATE TABLE sex_by_occupation_for_the_full_time_year_round_civilia_5eb09330 (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations:,
  "margin_of_error_male_management_business_science_and_a_db4a520a" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations:,
  "estimate_male_management_business_science_and_arts_occ_08e31583" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "margin_of_error_male_management_business_science_and_a_ef79e501" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "estimate_male_management_business_science_and_arts_occ_6aba6776" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "margin_of_error_male_management_business_science_and_a_474409a5" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "estimate_male_management_business_science_and_arts_occ_58edbed9" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "margin_of_error_male_management_business_science_and_a_3ccebbd1" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "estimate_male_management_business_science_and_arts_occ_9c2bb5b4" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "margin_of_error_male_management_business_science_and_a_de127ba8" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "estimate_male_management_business_science_and_arts_occ_a52d6ecc" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "margin_of_error_male_management_business_science_and_a_f12ee9d6" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "estimate_male_management_business_science_and_arts_occ_0f35d750" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "margin_of_error_male_management_business_science_and_a_1277edf0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "estimate_male_management_business_science_and_arts_occ_3d09ea4e" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "margin_of_error_male_management_business_science_and_a_40a86b36" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "estimate_male_management_business_science_and_arts_occ_1169c959" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "margin_of_error_male_management_business_science_and_a_f14400d3" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "estimate_male_management_business_science_and_arts_occ_52b81a7d" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "margin_of_error_male_management_business_science_and_a_853ef091" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "estimate_male_management_business_science_and_arts_occ_b2932a1e" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations,
  "margin_of_error_male_management_business_science_and_a_252c3e5f" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations,
  "estimate_male_management_business_science_and_arts_occ_44add988" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Education, Training, And Library Occupations,
  "margin_of_error_male_management_business_science_and_a_02d1a2c8" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Education, Training, And Library Occupations,
  "estimate_male_management_business_science_and_arts_occ_ee8e93bc" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Arts, Design, Entertainment, Sports, And Media Occupations,
  "margin_of_error_male_management_business_science_and_a_a4ee9b0e" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Arts, Design, Entertainment, Sports, And Media Occupations,
  "estimate_male_management_business_science_and_arts_occ_62275451" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations:,
  "margin_of_error_male_management_business_science_and_a_6a01a5d0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations:,
  "estimate_male_management_business_science_and_arts_occ_f331d6bd" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Diagnosing And Treating Practitioners And Other Technical Occupations,
  "margin_of_error_male_management_business_science_and_a_4f6fac93" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Diagnosing And Treating Practitioners And Other Technical Occupations,
  "estimate_male_management_business_science_and_arts_occ_70dac197" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Technologists And Technicians,
  "margin_of_error_male_management_business_science_and_a_acaa595c" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations: - Healthcare Practitioners And Technical Occupations: - Health Technologists And Technicians,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations:,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations:,
  "estimate_male_service_occupations_healthcare_support_o_0a021731" DOUBLE  -- Estimate; Male: - Service Occupations: - Healthcare Support Occupations,
  "margin_of_error_male_service_occupations_healthcare_su_5babcada" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Healthcare Support Occupations,
  "estimate_male_service_occupations_protective_service_o_daa4ce99" DOUBLE  -- Estimate; Male: - Service Occupations: - Protective Service Occupations:,
  "margin_of_error_male_service_occupations_protective_se_54a57fa4" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Protective Service Occupations:,
  "estimate_male_service_occupations_protective_service_o_aefa04b9" DOUBLE  -- Estimate; Male: - Service Occupations: - Protective Service Occupations: - Fire Fighting And Prevention, And Other Protective Service Workers Including Supervisors,
  "margin_of_error_male_service_occupations_protective_se_ce60726c" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Protective Service Occupations: - Fire Fighting And Prevention, And Other Protective Service Workers Including Supervisors,
  "estimate_male_service_occupations_protective_service_o_77a73da8" DOUBLE  -- Estimate; Male: - Service Occupations: - Protective Service Occupations: - Law Enforcement Workers Including Supervisors,
  "margin_of_error_male_service_occupations_protective_se_d9807f79" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Protective Service Occupations: - Law Enforcement Workers Including Supervisors,
  "estimate_male_service_occupations_food_preparation_and_8a0d85aa" DOUBLE  -- Estimate; Male: - Service Occupations: - Food Preparation And Serving Related Occupations,
  "margin_of_error_male_service_occupations_food_preparat_66eedfea" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Food Preparation And Serving Related Occupations,
  "estimate_male_service_occupations_building_and_grounds_eb514494" DOUBLE  -- Estimate; Male: - Service Occupations: - Building And Grounds Cleaning And Maintenance Occupations,
  "margin_of_error_male_service_occupations_building_and__179b33e7" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Building And Grounds Cleaning And Maintenance Occupations,
  "estimate_male_service_occupations_personal_care_and_se_bb25655c" DOUBLE  -- Estimate; Male: - Service Occupations: - Personal Care And Service Occupations,
  "margin_of_error_male_service_occupations_personal_care_230446b2" DOUBLE  -- Margin Of Error; Male: - Service Occupations: - Personal Care And Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations:,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations:,
  "estimate_male_sales_and_office_occupations_sales_and_r_25e4e92a" DOUBLE  -- Estimate; Male: - Sales And Office Occupations: - Sales And Related Occupations,
  "margin_of_error_male_sales_and_office_occupations_sale_314807e8" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations: - Sales And Related Occupations,
  "estimate_male_sales_and_office_occupations_office_and__0093e4d6" DOUBLE  -- Estimate; Male: - Sales And Office Occupations: - Office And Administrative Support Occupations,
  "margin_of_error_male_sales_and_office_occupations_offi_3a19023d" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations: - Office And Administrative Support Occupations,
  "estimate_male_natural_resources_construction_and_maint_db526eae" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations:,
  "margin_of_error_male_natural_resources_construction_an_f8445317" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations:,
  "estimate_male_natural_resources_construction_and_maint_31742cd5" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations: - Farming, Fishing, And Forestry Occupations,
  "margin_of_error_male_natural_resources_construction_an_2e4e674f" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations: - Farming, Fishing, And Forestry Occupations,
  "estimate_male_natural_resources_construction_and_maint_60f504b0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations: - Construction And Extraction Occupations,
  "margin_of_error_male_natural_resources_construction_an_d8c2192e" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations: - Construction And Extraction Occupations,
  "estimate_male_natural_resources_construction_and_maint_c57b20e7" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations: - Installation, Maintenance, And Repair Occupations,
  "margin_of_error_male_natural_resources_construction_an_b760fe5d" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations: - Installation, Maintenance, And Repair Occupations,
  "estimate_male_production_transportation_and_material_m_f7ee0198" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations:,
  "margin_of_error_male_production_transportation_and_mat_9743e710" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations:,
  "estimate_male_production_transportation_and_material_m_2217dc69" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations: - Production Occupations,
  "margin_of_error_male_production_transportation_and_mat_b43c4914" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations: - Production Occupations,
  "estimate_male_production_transportation_and_material_m_355845cd" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations: - Transportation Occupations,
  "margin_of_error_male_production_transportation_and_mat_36492500" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations: - Transportation Occupations,
  "estimate_male_production_transportation_and_material_m_8b8ad761" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations: - Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_15e65d20" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations: - Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_35086808" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations:,
  "margin_of_error_female_management_business_science_and_7933eaab" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations:,
  "estimate_female_management_business_science_and_arts_o_26bd5bc7" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "margin_of_error_female_management_business_science_and_dbfd8605" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations:,
  "estimate_female_management_business_science_and_arts_o_8b006706" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "margin_of_error_female_management_business_science_and_548d9401" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Management Occupations,
  "estimate_female_management_business_science_and_arts_o_e4022d09" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "margin_of_error_female_management_business_science_and_95880986" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Management, Business, And Financial Occupations: - Business And Financial Operations Occupations,
  "estimate_female_management_business_science_and_arts_o_85771c0f" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "margin_of_error_female_management_business_science_and_9ea7df2a" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations:,
  "estimate_female_management_business_science_and_arts_o_5706d644" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "margin_of_error_female_management_business_science_and_dac5a9f7" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Computer And Mathematical Occupations,
  "estimate_female_management_business_science_and_arts_o_93e36a61" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "margin_of_error_female_management_business_science_and_534e3975" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Architecture And Engineering Occupations,
  "estimate_female_management_business_science_and_arts_o_b9f167a2" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "margin_of_error_female_management_business_science_and_19e3059d" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Computer, Engineering, And Science Occupations: - Life, Physical, And Social Science Occupations,
  "estimate_female_management_business_science_and_arts_o_dead2250" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "margin_of_error_female_management_business_science_and_f064f872" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations:,
  "estimate_female_management_business_science_and_arts_o_36f54ecd" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "margin_of_error_female_management_business_science_and_00dc7e78" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Community And Social Service Occupations,
  "estimate_female_management_business_science_and_arts_o_52916c8f" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations,
  "margin_of_error_female_management_business_science_and_72242112" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations: - Education, Legal, Community Service, Arts, And Media Occupations: - Legal Occupations
);

Sex By Occupation, Native Hawaiian And Other Pacific Islander Alone

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_native_hawaiian_and_other_pacific_is_f5e95265
  • 32.07 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_native_hawaiian_and_other_pacific_is_f5e95265 (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Sex By Occupation, Some Other Race Alone

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_some_other_race_alone
  • 33.27 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_some_other_race_alone (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Sex By Occupation, Two Or More Races

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_two_or_more_races
  • 36.3 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_two_or_more_races (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Sex By Occupation, White Alone

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_white_alone
  • 43.16 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_white_alone (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Sex By Occupation, White, Not Hispanic Or Latino

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_8f4559b9.sex_by_occupation_white_not_hispanic_or_latino
  • 43.12 kB
  • 91 rows
  • 28 columns
Loading... 
CREATE TABLE sex_by_occupation_white_not_hispanic_or_latino (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- Estimate; Total:,
  "margin_of_error_total" DOUBLE  -- Margin Of Error; Total:,
  "estimate_male" DOUBLE  -- Estimate; Male:,
  "margin_of_error_male" DOUBLE  -- Margin Of Error; Male:,
  "estimate_male_management_business_science_and_arts_occupations" DOUBLE  -- Estimate; Male: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_male_management_business_science_and_a_b69ee3a0" DOUBLE  -- Margin Of Error; Male: - Management, Business, Science, And Arts Occupations,
  "estimate_male_service_occupations" DOUBLE  -- Estimate; Male: - Service Occupations,
  "margin_of_error_male_service_occupations" DOUBLE  -- Margin Of Error; Male: - Service Occupations,
  "estimate_male_sales_and_office_occupations" DOUBLE  -- Estimate; Male: - Sales And Office Occupations,
  "margin_of_error_male_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Male: - Sales And Office Occupations,
  "estimate_male_natural_resources_construction_and_maint_84f0a2e0" DOUBLE  -- Estimate; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_male_natural_resources_construction_an_ac06c3e6" DOUBLE  -- Margin Of Error; Male: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_male_production_transportation_and_material_m_725da68a" DOUBLE  -- Estimate; Male: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_male_production_transportation_and_mat_7ca02458" DOUBLE  -- Margin Of Error; Male: - Production, Transportation, And Material Moving Occupations,
  "estimate_female" DOUBLE  -- Estimate; Female:,
  "margin_of_error_female" DOUBLE  -- Margin Of Error; Female:,
  "estimate_female_management_business_science_and_arts_o_8c3e19a4" DOUBLE  -- Estimate; Female: - Management, Business, Science, And Arts Occupations,
  "margin_of_error_female_management_business_science_and_572309a1" DOUBLE  -- Margin Of Error; Female: - Management, Business, Science, And Arts Occupations,
  "estimate_female_service_occupations" DOUBLE  -- Estimate; Female: - Service Occupations,
  "margin_of_error_female_service_occupations" DOUBLE  -- Margin Of Error; Female: - Service Occupations,
  "estimate_female_sales_and_office_occupations" DOUBLE  -- Estimate; Female: - Sales And Office Occupations,
  "margin_of_error_female_sales_and_office_occupations" DOUBLE  -- Margin Of Error; Female: - Sales And Office Occupations,
  "estimate_female_natural_resources_construction_and_mai_412df715" DOUBLE  -- Estimate; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "margin_of_error_female_natural_resources_construction__47f035e2" DOUBLE  -- Margin Of Error; Female: - Natural Resources, Construction, And Maintenance Occupations,
  "estimate_female_production_transportation_and_material_1687e778" DOUBLE  -- Estimate; Female: - Production, Transportation, And Material Moving Occupations,
  "margin_of_error_female_production_transportation_and_m_1bb76a5f" DOUBLE  -- Margin Of Error; Female: - Production, Transportation, And Material Moving Occupations
);

Share link

Anyone who has the link will be able to view this.