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.2. Modified 2022-08-09T16:57:45
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
- current_expense_18. Current Expense file for academic year 2018
- current_expense_19. Current Expense file for academic year 2019
- current_expense_20. Current Expense file for academic year 2020
- 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.
License
The source data, from the California Department of Education, does not
explicitly reference a license, but since the top-level website for California
indicates that data published on the State of California website is
generally in the public domain, we assume it is in
the public domain. Derived data included in this package is also in the public domain. Metadata in this package ( contained in the metadata.csv file ) is
derived from metadata for the source package, and is also in the public domain.
Programs used for data transformation (contained in the notebooks directory), are Copyright 2021 Civic Knowledge, and
are relased under the Creative Commons Attribution-ShareAlike 4.0 International
License.
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://library.metatab.org/cde.ca.gov-current_expense-1.2.2.csv
- csv http://library.metatab.org/cde.ca.gov-current_expense-1.2.2.csv
- source https://github.com/metatab-packages/cde.ca.gov-current_expense.git
Accessing Data in Vanilla Pandas
import pandas as pd
current_expense_98_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_98.csv')
current_expense_99_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_99.csv')
current_expense_00_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_00.csv')
current_expense_01_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_01.csv')
current_expense_02_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_02.csv')
current_expense_03_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_03.csv')
current_expense_04_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_04.csv')
current_expense_05_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_05.csv')
current_expense_06_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_06.csv')
current_expense_07_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_07.csv')
current_expense_08_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_08.csv')
current_expense_09_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_09.csv')
current_expense_10_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_10.csv')
current_expense_11_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_11.csv')
current_expense_12_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_12.csv')
current_expense_13_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_13.csv')
current_expense_14_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_14.csv')
current_expense_15_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_15.csv')
current_expense_16_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_16.csv')
current_expense_17_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_17.csv')
current_expense_18_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_18.csv')
current_expense_19_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_19.csv')
current_expense_20_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/current_expense_20.csv')
combined_current_expense_df = pd.read_csv('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2/data/combined_current_expense.csv')Accessing Package in Metapack
import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-current_expense-1.2.2.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()
current_expense_18_df = pkg.resource('current_expense_18').dataframe()
current_expense_19_df = pkg.resource('current_expense_19').dataframe()
current_expense_20_df = pkg.resource('current_expense_20').dataframe()
combined_current_expense_df = pkg.resource('combined_current_expense').dataframe()