SF Employee Compensation

Explore Open Data from San Francisco

@kaggle.san_francisco_sf_employee_compensation

Table List

1 table(38.14 MB)

Employee Compensation

@kaggle.san_francisco_sf_employee_compensation.employee_compensation

38.14 MB
683277 rows
22 columns

organization_group_code Organization Group Code	job_family_code Job Family Code	job_code Job Code	year_type Year Type	year Year	organization_group Organization Group	department_code Department Code	department Department	union_code Union Code	union Union	job_family Job Family	job Job	employee_identifier Employee Identifier	salaries Salaries	other_salaries Other Salaries	total_salary Total Salary	retirement Retirement	health_and_dental Health And Dental	other_benefits Other Benefits	total_benefits Total Benefits	total_compensation Total Compensation
1	1000	1021	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IS Administrator 1	37730	57534.65		57534.65	11253.16	11961.34	4532.63	27747.13	85281.78
1	1000	1023	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IS Administrator 3	26574	57678.5		57678.5	10284.88	7176.8	4755.14	22216.82	79895.32
1	1000	1031	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IS Trainer-Assistant	8148	63532.93		63532.93	12495.83	12918.24	4702.71	30116.78	93649.71
1	1000	1054	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IS Business Analyst-Principal	27436	101274.51	-7058.59	94215.92	19644.45	12918.24	7458.76	40021.45	134237.37
1	1000	1062	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IS Programmer Analyst	37730	5084		5084	1083.9	956.91	387.5	2428.31	7512.31
1	1000	1064	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IS Prg Analyst-Principal	36223	34456		34456	7346	3827.63	2579.95	13753.58	48209.58
1	1000	1070	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IS Project Director	51426	139889		139889	26799.23	12918.24	9791.54	49509.01	189398.01
1	1000	1094	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Information Systems	IT Operations Support Admin IV	26574	46572		46572	9929.16	5741.44	3822.28	19492.88	66064.88
1	1200	1232	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Personnel	Training Officer	37983	84681.53		84681.53	16661.84	12918.24	6838.44	36418.52	121100.05
1	1600	1654	Calendar	2013	Public Protection	ADP	ADP Adult Probation	21	Prof & Tech Engineers - Miscellaneous, Local 21	Payroll, Billing & Accounting	Accountant III	16858	10611.01		10611.01	1879.2	1435.36	827.09	4141.65	14752.66


CREATE TABLE employee_compensation (
  "organization_group_code" BIGINT,
  "job_family_code" VARCHAR,
  "job_code" VARCHAR,
  "year_type" VARCHAR,
  "year" BIGINT,
  "organization_group" VARCHAR,
  "department_code" VARCHAR,
  "department" VARCHAR,
  "union_code" DOUBLE,
  "union" VARCHAR,
  "job_family" VARCHAR,
  "job" VARCHAR,
  "employee_identifier" BIGINT,
  "salaries" DOUBLE,
  "overtime" DOUBLE,
  "other_salaries" DOUBLE,
  "total_salary" DOUBLE,
  "retirement" DOUBLE,
  "health_and_dental" DOUBLE,
  "other_benefits" DOUBLE,
  "total_benefits" DOUBLE,
  "total_compensation" DOUBLE
);