Employment-to-Population Ratio For USA (1979-2022)
Employment-to-Population Ratio for USA over time
@kaggle.asaniczka_employment_to_population_ratio_for_usa_1979_2023
Employment-to-Population Ratio for USA over time
@kaggle.asaniczka_employment_to_population_ratio_for_usa_1979_2023
This dataset provides comprehensive information about the employment-to-population ratio and the actual population in the United States, spanning from 1979 to 2022.
The employment-to-population ratio signifies the percentage of the civilian noninstitutional population that is employed.
If you find this dataset useful, please consider giving it an upvote! 😊💝
Poverty-Level Wages in the USA Dataset
Productivity and Hourly Compensation
Health Insurance Coverage in the USA
| Field | Description | Type |
|---|---|---|
| year | The year for which the data is recorded | int |
| all | Employment-to-population ratio for the entire population | float |
| 16-24 | Employment-to-population ratio for individuals aged 16-24 | float |
| 25-54 | Employment-to-population ratio for individuals aged 25-54 | float |
| 55-64 | Employment-to-population ratio for individuals aged 55-64 | float |
| 65+ | Employment-to-population ratio for individuals aged 65 years and older | float |
| less_than_hs | Employment-to-population ratio for individuals with less than a high school education | float |
| high_school | Employment-to-population ratio for individuals with a high school education | float |
| some_college | Employment-to-population ratio for individuals with some college education | float |
| bachelors_degree | Employment-to-population ratio for individuals with a bachelor's degree | float |
| advanced_degree | Employment-to-population ratio for individuals with an advanced degree | float |
| women | Employment-to-population ratio for women of all age groups | float |
| women_16-24 | Employment-to-population ratio for women aged 16-24 | float |
| women_25-54 | Employment-to-population ratio for women aged 25-54 | float |
| women_55-64 | Employment-to-population ratio for women aged 55-64 | float |
| women_65+ | Employment-to-population ratio for women aged 65 years and older | float |
| women_less_than_hs | Employment-to-population ratio for women with less than a high school education | float |
| women_high_school | Employment-to-population ratio for women with a high school education | float |
| women_some_college | Employment-to-population ratio for women with some college education | float |
| women_bachelors_degree | Employment-to-population ratio for women with a bachelor's degree | float |
| women_advanced_degree | Employment-to-population ratio for women with an advanced degree | float |
| men | Employment-to-population ratio for men of all age groups | float |
| men_16-24 | Employment-to-population ratio for men aged 16-24 | float |
| men_25-54 | Employment-to-population ratio for men aged 25-54 | float |
| men_55-64 | Employment-to-population ratio for men aged 55-64 | float |
| men_65+ | Employment-to-population ratio for men aged 65 years and older | float |
| men_less_than_hs | Employment-to-population ratio for men with less than a high school education | float |
| men_high_school | Employment-to-population ratio for men with a high school education | float |
| men_some_college | Employment-to-population ratio for men with some college education | float |
| men_bachelors_degree | Employment-to-population ratio for men with a bachelor's degree | float |
| men_advanced_degree | Employment-to-population ratio for men with an advanced degree | float |
| black | Employment-to-population ratio for individuals identifying as Black/African American of all age groups | float |
| black_16-24 | Employment-to-population ratio for individuals identifying as Black/African American aged 16-24 | float |
| black_25-54 | Employment-to-population ratio for individuals identifying as Black/African American aged 25-54 | float |
| black_55-64 | Employment-to-population ratio for individuals identifying as Black/African American aged 55-64 | float |
| black_65+ | Employment-to-population ratio for individuals identifying as Black/African American aged 65 years and older | float |
| black_less_than_hs | Employment-to-population ratio for individuals identifying as Black/African American with less than a high school education | float |
| black_high_school | Employment-to-population ratio for individuals identifying as Black/African American with a high school education | float |
| black_some_college | Employment-to-population ratio for individuals identifying as Black/African American with some college education | float |
| black_bachelors_degree | Employment-to-population ratio for individuals identifying as Black/African American with a bachelor's degree | float |
| black_advanced_degree | Employment-to-population ratio for individuals identifying as Black/African American with an advanced degree | float |
| black_women | Employment-to-population ratio for Black/African American women of all age groups | float |
| black_women_16-24 | Employment-to-population ratio for Black/African American women aged 16-24 | float |
| black_women_25-54 | Employment-to-population ratio for Black/African American women aged 25-54 | float |
| black_women_55-64 | Employment-to-population ratio for Black/African American women aged 55-64 | float |
| black_women_65+ | Employment-to-population ratio for Black/African American women aged 65 years and older | float |
| black_women_less_than_hs | Employment-to-population ratio for Black/African American women with less than a high school education | float |
| black_women_high_school | Employment-to-population ratio for Black/African American women with a high school education | float |
| black_women_some_college | Employment-to-population ratio for Black/African American women with some college education | float |
| black_women_bachelors_degree | Employment-to-population ratio for Black/African American women with a bachelor's degree | float |
| black_women_advanced_degree | Employment-to-population ratio for Black/African American women with an advanced degree | float |
| black_men | Employment-to-population ratio for Black/African American men of all age groups | float |
| black_men_16-24 | Employment-to-population ratio for Black/African American men aged 16-24 | float |
| black_men_25-54 | Employment-to-population ratio for Black/African American men aged 25-54 | float |
| black_men_55-64 | Employment-to-population ratio for Black/African American men aged 55-64 | float |
| black_men_65+ | Employment-to-population ratio for Black/African American men aged 65 years and older | float |
| black_men_less_than_hs | Employment-to-population ratio for Black/African American men with less than a high school education | float |
| black_men_high_school | Employment-to-population ratio for Black/African American men with a high school education | float |
| black_men_some_college | Employment-to-population ratio for Black/African American men with some college education | float |
| black_men_bachelors_degree | Employment-to-population ratio for Black/African American men with a bachelor's degree | float |
| black_men_advanced_degree | Employment-to-population ratio for Black/African American men with an advanced degree | float |
| hispanic | Employment-to-population ratio for individuals identifying as Hispanic of all age groups | float |
| hispanic_16-24 | Employment-to-population ratio for individuals identifying as Hispanic aged 16-24 | float |
| hispanic_25-54 | Employment-to-population ratio for individuals identifying as Hispanic aged 25-54 | float |
| hispanic_55-64 | Employment-to-population ratio for individuals identifying as Hispanic aged 55-64 | float |
| hispanic_65+ | Employment-to-population ratio for individuals identifying as Hispanic aged 65 years and older | float |
| hispanic_less_than_hs | Employment-to-population ratio for individuals identifying as Hispanic with less than a high school education | float |
| hispanic_high_school | Employment-to-population ratio for individuals identifying as Hispanic with a high school education | float |
| hispanic_some_college | Employment-to-population ratio for individuals identifying as Hispanic with some college education | float |
| hispanic_bachelors_degree | Employment-to-population ratio for individuals identifying as Hispanic with a bachelor's degree | float |
| hispanic_advanced_degree | Employment-to-population ratio for individuals identifying as Hispanic with an advanced degree | float |
| hispanic_women | Employment-to-population ratio for Hispanic women of all age groups | float |
| hispanic_women_16-24 | Employment-to-population ratio for Hispanic women aged 16-24 | float |
| hispanic_women_25-54 | Employment-to-population ratio for Hispanic women aged 25-54 | float |
| hispanic_women_55-64 | Employment-to-population ratio for Hispanic women aged 55-64 | float |
| hispanic_women_65+ | Employment-to-population ratio for Hispanic women aged 65 years and older | float |
| hispanic_women_less_than_hs | Employment-to-population ratio for Hispanic women with less than a high school education | float |
| hispanic_women_high_school | Employment-to-population ratio for Hispanic women with a high school education | float |
| hispanic_women_some_college | Employment-to-population ratio for Hispanic women with some college education | float |
| hispanic_women_bachelors_degree | Employment-to-population ratio for Hispanic women with a bachelor's degree | float |
| hispanic_women_advanced_degree | Employment-to-population ratio for Hispanic women with an advanced degree | float |
| hispanic_men | Employment-to-population ratio for Hispanic men of all age groups | float |
| hispanic_men_16-24 | Employment-to-population ratio for Hispanic men aged 16-24 | float |
| hispanic_men_25-54 | Employment-to-population ratio for Hispanic men aged 25-54 | float |
| hispanic_men_55-64 | Employment-to-population ratio for Hispanic men aged 55-64 | float |
| hispanic_men_65+ | Employment-to-population ratio for Hispanic men aged 65 years and older | float |
| hispanic_men_less_than_hs | Employment-to-population ratio for Hispanic men with less than a high school education | float |
| hispanic_men_high_school | Employment-to-population ratio for Hispanic men with a high school education | float |
| hispanic_men_some_college | Employment-to-population ratio for Hispanic men with some college education | float |
| hispanic_men_bachelors_degree | Employment-to-population ratio for Hispanic men with a bachelor's degree | float |
| hispanic_men_advanced_degree | Employment-to-population ratio for Hispanic men with an advanced degree | float |
| white | Employment-to-population ratio for individuals identifying as White of all age groups | float |
| white_16-24 | Employment-to-population ratio for individuals identifying as White aged 16-24 | float |
| white_25-54 | Employment-to-population ratio for individuals identifying as White aged 25-54 | float |
| white_55-64 | Employment-to-population ratio for individuals identifying as White aged 55-64 | float |
| white_65+ | Employment-to-population ratio for individuals identifying as White aged 65 years and older | float |
| white_less_than_hs | Employment-to-population ratio for individuals identifying as White with less than a high school education | float |
| white_high_school | Employment-to-population ratio for individuals identifying as White with a high school education | float |
| white_some_college | Employment-to-population ratio for individuals identifying as White with some college education | float |
| white_bachelors_degree | Employment-to-population ratio for individuals identifying as White with a bachelor's degree | float |
| white_advanced_degree | Employment-to-population ratio for individuals identifying as White with an advanced degree | float |
| white_women | Employment-to-population ratio for White women of all age groups | float |
| white_women_16-24 | Employment-to-population ratio for White women aged 16-24 | float |
| white_women_25-54 | Employment-to-population ratio for White women aged 25-54 | float |
| white_women_55-64 | Employment-to-population ratio for White women aged 55-64 | float |
| white_women_65+ | Employment-to-population ratio for White women aged 65 years and older | float |
| white_women_less_than_hs | Employment-to-population ratio for White women with less than a high school education | float |
| white_women_high_school | Employment-to-population ratio for White women with a high school education | float |
| white_women_some_college | Employment-to-population ratio for White women with some college education | float |
| white_women_bachelors_degree | Employment-to-population ratio for White women with a bachelor's degree | float |
| white_women_advanced_degree | Employment-to-population ratio for White women with an advanced degree | float |
| white_men | Employment-to-population ratio for White men of all age groups | float |
| white_men_16-24 | Employment-to-population ratio for White men aged 16-24 | float |
| white_men_25-54 | Employment-to-population ratio for White men aged 25-54 | float |
| white_men_55-64 | Employment-to-population ratio for White men aged 55-64 | float |
| white_men_65+ | Employment-to-population ratio for White men aged 65 years and older | float |
| white_men_less_than_hs | Employment-to-population ratio for White men with less than a high school education | float |
| white_men_high_school | Employment-to-population ratio for White men with a high school education | float |
| white_men_some_college | Employment-to-population ratio for White men with some college education | float |
| white_men_bachelors_degree | Employment-to-population ratio for White men with a bachelor's degree | float |
| white_men_advanced_degree | Employment-to-population ratio for White men with an advanced degree | float |
| total_population | Actual population count for the given year | int |
Photo by Cristian Tarzi on Unsplash
CREATE TABLE employment_to_population_1979_to_2022 (
"year" BIGINT,
"all" DOUBLE,
"n_16_24" DOUBLE -- 16-24,
"n_25_54" DOUBLE -- 25-54,
"n_55_64" DOUBLE -- 55-64,
"n_65" DOUBLE -- 65+,
"less_than_hs" DOUBLE,
"high_school" DOUBLE,
"some_college" DOUBLE,
"bachelors_degree" DOUBLE,
"advanced_degree" DOUBLE,
"women" DOUBLE,
"women_16_24" DOUBLE,
"women_25_54" DOUBLE,
"women_55_64" DOUBLE,
"women_65" DOUBLE -- Women 65+,
"women_less_than_hs" DOUBLE,
"women_high_school" DOUBLE,
"women_some_college" DOUBLE,
"women_bachelors_degree" DOUBLE,
"women_advanced_degree" DOUBLE,
"men" DOUBLE,
"men_16_24" DOUBLE,
"men_25_54" DOUBLE,
"men_55_64" DOUBLE,
"men_65" DOUBLE -- Men 65+,
"men_less_than_hs" DOUBLE,
"men_high_school" DOUBLE,
"men_some_college" DOUBLE,
"men_bachelors_degree" DOUBLE,
"men_advanced_degree" DOUBLE,
"black" DOUBLE,
"black_16_24" DOUBLE,
"black_25_54" DOUBLE,
"black_55_64" DOUBLE,
"black_65" DOUBLE -- Black 65+,
"black_less_than_hs" DOUBLE,
"black_high_school" DOUBLE,
"black_some_college" DOUBLE,
"black_bachelors_degree" DOUBLE,
"black_advanced_degree" DOUBLE,
"black_women" DOUBLE,
"black_women_16_24" DOUBLE,
"black_women_25_54" DOUBLE,
"black_women_55_64" DOUBLE,
"black_women_65" DOUBLE -- Black Women 65+,
"black_women_less_than_hs" DOUBLE,
"black_women_high_school" DOUBLE,
"black_women_some_college" DOUBLE,
"black_women_bachelors_degree" DOUBLE,
"black_women_advanced_degree" DOUBLE,
"black_men" DOUBLE,
"black_men_16_24" DOUBLE,
"black_men_25_54" DOUBLE,
"black_men_55_64" DOUBLE,
"black_men_65" DOUBLE -- Black Men 65+,
"black_men_less_than_hs" DOUBLE,
"black_men_high_school" DOUBLE,
"black_men_some_college" DOUBLE,
"black_men_bachelors_degree" DOUBLE,
"black_men_advanced_degree" DOUBLE,
"hispanic" DOUBLE,
"hispanic_16_24" DOUBLE,
"hispanic_25_54" DOUBLE,
"hispanic_55_64" DOUBLE,
"hispanic_65" DOUBLE -- Hispanic 65+,
"hispanic_less_than_hs" DOUBLE,
"hispanic_high_school" DOUBLE,
"hispanic_some_college" DOUBLE,
"hispanic_bachelors_degree" DOUBLE,
"hispanic_advanced_degree" DOUBLE,
"hispanic_women" DOUBLE,
"hispanic_women_16_24" DOUBLE,
"hispanic_women_25_54" DOUBLE,
"hispanic_women_55_64" DOUBLE,
"hispanic_women_65" DOUBLE -- Hispanic Women 65+,
"hispanic_women_less_than_hs" DOUBLE,
"hispanic_women_high_school" DOUBLE,
"hispanic_women_some_college" DOUBLE,
"hispanic_women_bachelors_degree" DOUBLE,
"hispanic_women_advanced_degree" DOUBLE,
"hispanic_men" DOUBLE,
"hispanic_men_16_24" DOUBLE,
"hispanic_men_25_54" DOUBLE,
"hispanic_men_55_64" DOUBLE,
"hispanic_men_65" DOUBLE -- Hispanic Men 65+,
"hispanic_men_less_than_hs" DOUBLE,
"hispanic_men_high_school" DOUBLE,
"hispanic_men_some_college" DOUBLE,
"hispanic_men_bachelors_degree" DOUBLE,
"hispanic_men_advanced_degree" DOUBLE,
"white" DOUBLE,
"white_16_24" DOUBLE,
"white_25_54" DOUBLE,
"white_55_64" DOUBLE,
"white_65" DOUBLE -- White 65+,
"white_less_than_hs" DOUBLE,
"white_high_school" DOUBLE,
"white_some_college" DOUBLE,
"white_bachelors_degree" DOUBLE
);Anyone who has the link will be able to view this.