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
Data Dictionary
current_expense_98 | current_expense_01 | current_expense_03 | current_expense_11 | combined_current_expensecurrent_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()