public_salaries
Data license: CC BY 4.0 · Data source: MyTown
3,539,791 rows
This data as json, CSV (advanced)
Suggested facets: updated_at (date)
| Link | rowid ▼ | muni_id | dataset_id | record_id | employee_name | job_title | department | base_pay | overtime | total_pay | year | redacted | source_domain | source_url | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | ca-sco-salaries | 0004393593ead05caba5 | Camp; Tempee Retiree U Exempt | Public Works | 81226.0 | 0.0 | 91720.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 2 | 2 | 1 | ca-sco-salaries | 0004b31b117d32b51f65 | Youth Outreach Worker I (Ft) | Parks/Rec & Neigh Serv P R N S | 47179.0 | 758.0 | 49148.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 3 | 3 | 1 | ca-sco-salaries | 00155b6c581403c1c91d | Police Officer | Police | 160056.0 | 120798.0 | 313145.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 4 | 4 | 1 | ca-sco-salaries | 001ad074eed35aec44f3 | Police Communication Spec Ft | Police | 33793.0 | 0.0 | 34960.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 5 | 5 | 1 | ca-sco-salaries | 001f352f5939bdd89135 | Division Manager | Housing | 211811.0 | 0.0 | 228714.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 6 | 6 | 1 | ca-sco-salaries | 002559478028d4162c65 | Recreation Leader Pt | Parks/Rec & Neigh Serv P R N S | 29033.0 | 0.0 | 29033.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 7 | 7 | 1 | ca-sco-salaries | 00271c80a3164aa471d0 | Recreation Leader Pt | Parks/Rec & Neigh Serv P R N S | 18244.0 | 1761.0 | 20005.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 8 | 8 | 1 | ca-sco-salaries | 00271dad6b85744afd4c | Recreation Leader Pt | Parks/Rec & Neigh Serv P R N S | 6248.0 | 0.0 | 6248.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 9 | 9 | 1 | ca-sco-salaries | 002794607f7629ede145 | Police Lieutenant | Police | 213067.0 | 100682.0 | 345639.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 10 | 10 | 1 | ca-sco-salaries | 0037862a445fec65cd5d | Staff Specialist | Public Works | 84812.0 | 0.0 | 84812.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 11 | 11 | 1 | ca-sco-salaries | 003806b5139ca5282df1 | Recreation Leader Pt | Parks/Rec & Neigh Serv P R N S | 27140.0 | 0.0 | 27140.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 12 | 12 | 1 | ca-sco-salaries | 00442411a5b671781a11 | Fire Fighter | Fire | 148894.0 | 93180.0 | 265333.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 13 | 13 | 1 | ca-sco-salaries | 004536bc56c96426627c | Development Specialist | Housing | 50418.0 | 0.0 | 51218.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 14 | 14 | 1 | ca-sco-salaries | 004c95202306ff29fff1 | Recreation Leader Pt | Parks/Rec & Neigh Serv P R N S | 6494.0 | 186.0 | 6680.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 15 | 15 | 1 | ca-sco-salaries | 0055fb6b0a46c1e63421 | Mef; Temp Employee U Pt | Parks/Rec & Neigh Serv P R N S | 26.0 | 0.0 | 26.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 16 | 16 | 1 | ca-sco-salaries | 0059d0ccfde8fd7cf4db | Council Comnrel Aide U Pt | City Council | 29790.0 | 0.0 | 29825.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 17 | 17 | 1 | ca-sco-salaries | 005a78156c311c18237c | Police Officer | Police | 160056.0 | 77628.0 | 261834.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 18 | 18 | 1 | ca-sco-salaries | 006541d1c81d7526f92b | Police Officer | Police | 152746.0 | 5341.0 | 171286.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 19 | 19 | 1 | ca-sco-salaries | 006a7e877b2b53b3eb45 | Senior Council Assistant U | City Council | 108120.0 | 0.0 | 115003.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 20 | 20 | 1 | ca-sco-salaries | 006f02b3604687f245af | Deputy Dir U | Airport | 238459.0 | 0.0 | 239605.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 21 | 21 | 1 | ca-sco-salaries | 0074173b308edd4acbc9 | Zoo Keeper Ft | Parks/Rec & Neigh Serv P R N S | 29508.0 | 2358.0 | 36094.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 22 | 22 | 1 | ca-sco-salaries | 0074e010cff0694544d0 | Accounting Tech | Parks/Rec & Neigh Serv P R N S | 100005.0 | 2791.0 | 103055.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 23 | 23 | 1 | ca-sco-salaries | 007878382c19d3d8882e | Fire Engineer | Fire | 165270.0 | 9387.0 | 182918.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 24 | 24 | 1 | ca-sco-salaries | 007b021ca57cee8ccdb7 | Police Officer | Police | 152405.0 | 137527.0 | 311680.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 25 | 25 | 1 | ca-sco-salaries | 007c8faff737fe2c967b | Senior Account Clerk | Police | 83090.0 | 0.0 | 83090.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 26 | 26 | 1 | ca-sco-salaries | 007ec98880477aa9dc24 | Community Services Aide Pt | Parks/Rec & Neigh Serv P R N S | 3159.0 | 132.0 | 3291.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 27 | 27 | 1 | ca-sco-salaries | 0083608a29c27313e36c | Recreation Leader Pt | Parks/Rec & Neigh Serv P R N S | 29804.0 | 372.0 | 30176.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 28 | 28 | 1 | ca-sco-salaries | 0089f8e1d94d4f75916b | Executive Assistant U | Auditor | 102785.0 | 0.0 | 109334.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 29 | 29 | 1 | ca-sco-salaries | 00b7eb37807709a4d335 | Library Page Pt | Library | 10607.0 | 0.0 | 10607.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 30 | 30 | 1 | ca-sco-salaries | 00b7fe67c16eb110f891 | Senior Executive Analyst U | City Manager | 125271.0 | 0.0 | 126437.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 31 | 31 | 1 | ca-sco-salaries | 00bbfe4570cd58b7df91 | Library Clerk | Library | 75566.0 | 0.0 | 75601.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 32 | 32 | 1 | ca-sco-salaries | 00bd20204926ba7b7155 | Administrative Assistant | Planning/Building/Code | 91150.0 | 0.0 | 91200.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 33 | 33 | 1 | ca-sco-salaries | 00bd25e5857c5ca1e811 | Literacy Program Specialist | Library | 97185.0 | 0.0 | 97185.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 34 | 34 | 1 | ca-sco-salaries | 00c7989ca1020dfc577b | Engineer II | Transportation | 110445.0 | 0.0 | 113121.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 35 | 35 | 1 | ca-sco-salaries | 00c88888874224715110 | Senior Analyst | Human Resources | 125270.0 | 0.0 | 125356.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 36 | 36 | 1 | ca-sco-salaries | 00d26cfde8064290a702 | Recreation Leader Pt | Parks/Rec & Neigh Serv P R N S | 140.0 | 0.0 | 140.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 37 | 37 | 1 | ca-sco-salaries | 00d57580682d5201f4bc | Zoo Curator | Parks/Rec & Neigh Serv P R N S | 55098.0 | 15137.0 | 105614.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 38 | 38 | 1 | ca-sco-salaries | 00d5d622e9a9636dbf61 | Mef; Tempee Retiree U Nx | Planning/Building/Code | 69033.0 | 0.0 | 69033.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 39 | 39 | 1 | ca-sco-salaries | 00d62a622d52eea94169 | Analyst II | Parks/Rec & Neigh Serv P R N S | 107946.0 | 6730.0 | 120444.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 40 | 40 | 1 | ca-sco-salaries | 00dd1d5cf5ca6acee127 | Deputy City Attorney I U | Attorney | 4846.0 | 0.0 | 14088.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 41 | 41 | 1 | ca-sco-salaries | 00ddd8ff445f7ee8195f | Police Officer | Police | 124762.0 | 16662.0 | 153668.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 42 | 42 | 1 | ca-sco-salaries | 00df4c063f2991ac0793 | Wastewater Facility Senior Engr | Environmental Services | 150912.0 | 0.0 | 152015.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 43 | 43 | 1 | ca-sco-salaries | 00f83db7dca68cbee17c | Unit 99; Student Intern U Pt | City Council | 9068.0 | 58.0 | 9126.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 44 | 44 | 1 | ca-sco-salaries | 00fefbeae67ebb427796 | Community Service Officer II | Police | 105990.0 | 3308.0 | 112065.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 45 | 45 | 1 | ca-sco-salaries | 010158c907dcdae6b33c | Building Inspect Combo Cert, Sr Ft | Planning/Building/Code | 158708.0 | 13015.0 | 174903.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 46 | 46 | 1 | ca-sco-salaries | 0109202b8192ad9d5333 | Police Recruit | Police | 53040.0 | 1647.0 | 56711.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 47 | 47 | 1 | ca-sco-salaries | 0115eece3e665b1f2bd8 | Library Clerk Pt | Library | 33028.0 | 0.0 | 33028.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 48 | 48 | 1 | ca-sco-salaries | 011dde70700a91e6ee85 | Planner IV | Planning/Building/Code | 143412.0 | 0.0 | 149715.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 49 | 49 | 1 | ca-sco-salaries | 0126df69773543037ff3 | Community Service Officer II | Police | 0.0 | 5.0 | 467.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 | |
| 50 | 50 | 1 | ca-sco-salaries | 012c3efac2f41751e8dd | Mef; Tempee Retiree U Nx | Police | 46398.0 | 0.0 | 46398.0 | 2024 | 1 | gcc.sco.ca.gov | https://gcc.sco.ca.gov/RawExport/2024_City.zip | 2026-08-01T07:33:37+00:00 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "public_salaries" ("muni_id", "dataset_id", "record_id", "employee_name", "job_title", "department", "base_pay", "overtime", "total_pay", "year", "redacted", "source_domain", "source_url", "updated_at");