Nonprofit Wage And Equity Survey - Position-Level Cohort Data - FY23
City of San Francisco
@usgov.city_of_san_francisco_nonprofit_wage_and_equity_survey_9ddaa04d
City of San Francisco
@usgov.city_of_san_francisco_nonprofit_wage_and_equity_survey_9ddaa04d
A. SUMMARY This dataset is a cleaned and anonymized version of survey data gathered in FY23 from nonprofits who contract with the City and County of San Francisco. Each row is one employee (representing one filled position), and data includes wages, position detail, position requirements, and demographic information as supplied by the person's employing organization. B. HOW THE DATASET IS CREATED This dataset was generated through conducting a two-tiered survey gathering data on organizational characteristics and position-level data from nonprofits who contract with the City and County of San Francisco in FY23. The survey was fielded in October and November of 2022. 152 nonprofits provided organizational-level data and summary data about their workforce. 29 of those organizations (referred to as "Cohort Organizations") provided additional position-level wage, demographic, and position-requirement data for each worker employed by their organization. This dataset includes position-level data from the cohort organizations. For further details on survey methodology, please review page 39 of the Nonprofit Wage and Equity Survey report, linked below in "Related Reports." C. UPDATE PROCESS Data is a one-time survey and will not update. D. HOW TO USE THIS DATASET Review code book, attached in the "About this Dataset" section. E. RELATED REPORTS This dataset informs the Nonprofit Wage and Equity Survey Report, released by the Controller's Office in April 2023. Nonprofit Wage and Equity Survey F. RELATED DATASETS This dataset is one of two datasets of survey data from the Nonprofit Wage and Equity Survey (FY23). Organization-level data can be viewed on the Open Data Portal. Nonprofit Wage and Equity Survey - Organization-Level Survey Data - FY23
Organization: City of San Francisco
Last updated: 2023-07-01T14:48:55.748719
Tags: nonprofit
CREATE TABLE table_1 (
"record_id" BIGINT,
"jobcategory" VARCHAR,
"jobcat_miscdirect_subcat" VARCHAR,
"jobcatgen" VARCHAR,
"fte" VARCHAR,
"hourlywage" VARCHAR,
"wage_range" VARCHAR,
"benefits" VARCHAR,
"raceethnicity" VARCHAR,
"gender" VARCHAR,
"age_range" VARCHAR,
"sexualorientation" VARCHAR,
"reqadvdegree" VARCHAR,
"reqbilingual" VARCHAR,
"reqhours" VARCHAR,
"org_primeservicearea" VARCHAR,
"org_orgsize2" VARCHAR,
"data_as_of" VARCHAR,
"data_loaded_at" VARCHAR
);Anyone who has the link will be able to view this.