Current Expense of Education – SDRDL Data Repository

Calculation of current expense (cost) of education per average daily attendance (ADA) pursuant to Education Code Section 41372.

cde.ca.gov-current_expense-1.2.1. Modified 2021-03-11T00:49:21

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

current_expense_98. Current Expense file for academic year 1998
current_expense_99. Current Expense file for academic year 1999
current_expense_00. Current Expense file for academic year 2000
current_expense_01. Current Expense file for academic year 2001
current_expense_02. Current Expense file for academic year 2002
current_expense_03. Current Expense file for academic year 2003
current_expense_04. Current Expense file for academic year 2004
current_expense_05. Current Expense file for academic year 2005
current_expense_06. Current Expense file for academic year 2006
current_expense_07. Current Expense file for academic year 2007
current_expense_08. Current Expense file for academic year 2008
current_expense_09. Current Expense file for academic year 2009
current_expense_10. Current Expense file for academic year 2010
current_expense_11. Current Expense file for academic year 2011
current_expense_12. Current Expense file for academic year 2012
current_expense_13. Current Expense file for academic year 2013
current_expense_14. Current Expense file for academic year 2014
current_expense_15. Current Expense file for academic year 2015
current_expense_16. Current Expense file for academic year 2016
current_expense_17. Current Expense file for academic year 2017
combined_current_expense. Combined file, includes all years

Documentation

Calculation of current expense (cost) of education per average daily attendance.

This dataset includes one file for each of the source files, and one file with all other files combined. The combined file maps column names, because among the source fiels, there are 4 different column headers. No other processing is done.

Documentation Links

Contacts

Wrangler
Eric Busboom, Civic Knowledge

Data Dictionary

current_expense_98 | current_expense_01 | current_expense_03 | current_expense_11 | combined_current_expense

current_expense_98

Column Name	Data Type	Description
county	integer
district	string
lea_id	integer
expenditures	number
ada	number
cost_per_ada	number
lea_type	string

current_expense_01

Column Name	Data Type	Description
county	integer
lea_id	integer
district	string
expenditures	number
ada	integer
cost_per_ada	number
lea_type	string

current_expense_03

Column Name	Data Type	Description
county	integer
lea_id	integer
district	string
expenditures	number
ada	number
cost_per_ada	number
lea_type	string

current_expense_11

Column Name	Data Type	Description
county	integer
lea_id	integer
district	string
expenditures	number
ada	number
cost_per_ada	number
lea_type	string

combined_current_expense

Column Name	Data Type	Description
year	integer	Year of the original source file
county	integer	County FIPS number
district	string	District name
lea_id	integer	District code, the D part of the CDS code
expenditures	number	Total district expenditures (EDP 365), in current dollars.
ada	number	Average Daily attendance used for the cost per ada calculation
cost_per_ada	number	Cost per average daily attendance
lea_type	string	Type of district: High school Elementary or Unified

Packages

s3 s3://cde.metatab.org/cde.ca.gov-current_expense-1.2.1.csv
csv http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1.csv
source https://github.com/Metatab/metatab-packages.git

Accessing Data in Vanilla Pandas

import pandas as pd


current_expense_98_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_98.csv')
current_expense_99_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_99.csv')
current_expense_00_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_00.csv')
current_expense_01_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_01.csv')
current_expense_02_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_02.csv')
current_expense_03_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_03.csv')
current_expense_04_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_04.csv')
current_expense_05_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_05.csv')
current_expense_06_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_06.csv')
current_expense_07_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_07.csv')
current_expense_08_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_08.csv')
current_expense_09_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_09.csv')
current_expense_10_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_10.csv')
current_expense_11_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_11.csv')
current_expense_12_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_12.csv')
current_expense_13_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_13.csv')
current_expense_14_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_14.csv')
current_expense_15_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_15.csv')
current_expense_16_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_16.csv')
current_expense_17_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/current_expense_17.csv')
combined_current_expense_df =  pd.read_csv('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1/data/combined_current_expense.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://cde.metatab.org/cde.ca.gov-current_expense-1.2.1.csv')

# Create Dataframes
current_expense_98_df = pkg.resource('current_expense_98').dataframe()
current_expense_99_df = pkg.resource('current_expense_99').dataframe()
current_expense_00_df = pkg.resource('current_expense_00').dataframe()
current_expense_01_df = pkg.resource('current_expense_01').dataframe()
current_expense_02_df = pkg.resource('current_expense_02').dataframe()
current_expense_03_df = pkg.resource('current_expense_03').dataframe()
current_expense_04_df = pkg.resource('current_expense_04').dataframe()
current_expense_05_df = pkg.resource('current_expense_05').dataframe()
current_expense_06_df = pkg.resource('current_expense_06').dataframe()
current_expense_07_df = pkg.resource('current_expense_07').dataframe()
current_expense_08_df = pkg.resource('current_expense_08').dataframe()
current_expense_09_df = pkg.resource('current_expense_09').dataframe()
current_expense_10_df = pkg.resource('current_expense_10').dataframe()
current_expense_11_df = pkg.resource('current_expense_11').dataframe()
current_expense_12_df = pkg.resource('current_expense_12').dataframe()
current_expense_13_df = pkg.resource('current_expense_13').dataframe()
current_expense_14_df = pkg.resource('current_expense_14').dataframe()
current_expense_15_df = pkg.resource('current_expense_15').dataframe()
current_expense_16_df = pkg.resource('current_expense_16').dataframe()
current_expense_17_df = pkg.resource('current_expense_17').dataframe()
combined_current_expense_df = pkg.resource('combined_current_expense').dataframe()