California School District Links to US Census

Links between CDS codes, NCES codes and school district geoids in the US census

sandiegodata.org-sd_demo_links-ca-4

Resources

ca_sd_links. Links between NCES, CDS and Geoids for California school districts

Documentation

Links between three identification codes for California districts:

CD Codes, the County/District codes used in most CDE data files.
NCES, codes used by the National Center for Educational Statistics
Census geoids, codes used in the US Census and American Community Survey.

This linkage file can be used to connect data fiels from the California Department of education to US Census demographics.

Versions

Initial version
Added county codes
Fixed datatype ( to string ) for county codes
Update to get FIPS codes to have 3 digits.

Contacts

Wrangler
Eric Busboom, Civic Knowledge

Packages

zip http://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.zip
s3 s3://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.csv
csv http://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.csv
source https://github.com/metatab-packages/cde.ca.gov.git

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.zip')

# Create Dataframes

ca_sd_links_df = pkg.resource('ca_sd_links').dataframe()

Data Dictionary

ca_sd_links

Column Name	Data Type	Description
nces_code	integer	NCES code for district
geoid	string	Census Geoid for district
cd_code	integer	California County/District code
district_name	text	Census name for district
sd_type	string	Type of district: Elementary (elem), Secondary (sec) or Unified (uni)
notary_county_code	string	California Notary / Secretary of State county code
fips_county_code	string	US Census county / FIPS code.

References

Urls used in the creation of this data package.

census://2015/5/CA/sdelm/B01003. Census elementary school districts for California
census://2015/5/CA/sdsec/B01003. Census secondary school districts for California
census://2015/5/CA/sduni/B01003. Census unified school districts for California
metapack+http://library.metatab.org/sandiegodata.org-county_codes-ca.csv#ca_county_codes. Noarty and Census county codes for California
metapack+http://library.metatab.org/cde.ca.gov-schools-1.zip#public_schools. California public schools
metapack+http://library.metatab.org/cde.ca.gov-schools-1.zip#school_districts. California school districts

Last Modified 2019-08-08T20:18:28

Packages

zip http://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.zip
s3 s3://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.csv
csv http://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.csv
source https://github.com/metatab-packages/cde.ca.gov.git

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiegodata.org-sd_demo_links-ca-4.zip')

# Create Dataframes

ca_sd_links_df = pkg.resource('ca_sd_links').dataframe()