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 | Packages | Documentation| Contacts| References| Data Dictionary

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

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

Contacts

Packages

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 NameData TypeDescription
nces_codeintegerNCES code for district
geoidstringCensus Geoid for district
cd_codeintegerCalifornia County/District code
district_nametextCensus name for district
sd_typestringType of district: Elementary (elem), Secondary (sec) or Unified (uni)
notary_county_codestringCalifornia Notary / Secretary of State county code
fips_county_codestringUS 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

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()