John Baldo jbaldo
jbaldo
/ check_for_missing_codes.sql
Last active
February 24, 2023 18:38
OpenOUSD Annual Data Update
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| DISTINCT(site_code) from expenditures | |
| where year = 2021 AND | |
| site_code NOT IN (SELECT DISTINCT(code) from sites) | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "entries": [ | |
| { | |
| "sys": { | |
| "space": { | |
| "sys": { | |
| "type": "Link", | |
| "linkType": "Space", | |
| "id": "tqd0xcamk1ij" | |
| } |
jbaldo
/ measure_g_2013_14_treemap.csv
Last active
August 29, 2015 14:26
Measure G Treemap CSV Files
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| category | program | total | |
|---|---|---|---|
| 3901 - OTHER BENEFITS CERTIFICATED | 1112 - CLASS SIZE REDUCTION | 2757 | |
| 4310 - SUPPLIES | 1112 - CLASS SIZE REDUCTION | 4589 | |
| 3601 - WORKERS COMP CERTIFICATED | 1112 - CLASS SIZE REDUCTION | 138812 | |
| 1105 - TEACHERS SALARIES | 1112 - CLASS SIZE REDUCTION | 2397499 | |
| 3401 - HEALTH & WELFARE CERTIFICATED | 1112 - CLASS SIZE REDUCTION | 609042 | |
| 3301 - SOCSEC,MEDI,ALTSS CERTIFICATED | 1112 - CLASS SIZE REDUCTION | 36737 | |
| 3501 - ST UNEMPLOY INS CERTIFICATED | 1112 - CLASS SIZE REDUCTION | 1196 | |
| 3101 - STRS CERTIFICATED | 1112 - CLASS SIZE REDUCTION | 180308 | |
| 3201 - PERS CERTIFICATED | 1112 - CLASS SIZE REDUCTION | 6983 |