f33pull: A function to import and process F33 data

In edbuildr: Automated School District Data Download and Processing

Description

This function imports the US Census, Annual Survey of School System Finances (F33) data with standard EdBuild processing steps applied to revenues.

Usage

f33pull(data_year = "2019", path=NULL, additional_var=NULL, keep_calcs=FALSE)

Arguments

data_year	Four digit year of F33 data you would like to pull. Available for 2006-2019.
path	Path name of F33 file if data is stored on local computer. Defaults to NULL to pull in F33 data from EdBuild's server.
additional_var	List any additional F33 variables you would like to pull.
keep_calcs	Do you want to keep all of the variables used to calculate adjusted revenues? Defaults to FALSE.

Format

A data frame with 14 variables:

year

data year

State

State name

STATE_FIPS

State code

NCEISD

NCES school district ID

NAME

School district name

CONUM

County number

ENROLL

School district enrollment

TFEDREV

Total federal revenue- no EdBuild adjustments

LOCREV_adj

Local revenue - with EdBuild adjustments

LOCREV_adj_PP

Local revenue per pupil- with EdBuild adjustments

STREV_adj

State revenue - with EdBuild adjustments

STREV_adj_PP

State revenue per pupil - with EdBuild adjustments

STLOCREV_adj

State and local revenue - with EdBuild adjustments

STLOCREV_adj_PP

State and local revenue per pupil - with EdBuild adjustments

Value

A dataframe where each observation is a school district.

Note

The following processing was made to state and local revenues for each school district:

1. Revenues are multiplied by 1,000.

2. Sale of property (U11) is removed from local revenue.

3. Capital outlay and debt service programs (C11) is removed from state revenue.

4. In Arkansas, the Census state NCES local revenue (C24) is subtracted from state revenues and added to local revenues for all districts in the state.

5. In Texas, recapture, reported as payments to state governments (L12), is subtracted from local revenue.

6. Charter passthrough dollars, V92, is subtracted proportionately from state and local revenues since students attending charter schools are not included in F33 enrollment.

For full details about F33 processing please visit EdBuild's dividing lines map site.

Source

https://s3.amazonaws.com/data.edbuild.org/public/Raw+Data/F33/csv/2019.csv

See Also

f33pull_raw

Examples

f33_2019 <- f33pull(data_year="2019",
                    additional_var=c("V40", "TCAPOUT"),
                    keep_calcs=FALSE)

edbuildr documentation built on June 2, 2021, 5:07 p.m.