f33pull: A function to import and process F33 data

Description Usage Arguments Format Value Note Source See Also Examples

View source: R/f33pull.R

Description

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

Usage

1
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

1
2
3
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.