Unique cross-system NSWERS student identifier. Carried from source records or membership assignments and used as the student-level join key.
K-12 school_year_ending from k12_students for the school-year geography record.
Educational service unit joined by county_district and school_year_ending.
First two characters of k12_students.county_district, converted to integer.
K-12 county_district code from k12_students.
Composite school identifier CONCAT(county_district, ‘-‘, school).
Nebraska legislative district returned by the GIS lookup for the composite school; -1 marks a failed lookup.
State Board of Education district from the loader’s embedded county-district lookup; -1 marks an unmapped district.
High-school state. The active loader hardcodes NE for K-12 source rows.
Community college service area looked up from the source County reference table by county number; empty string when unknown.
Latitude returned by the geocoder for the student’s school-year address, rounded to two decimals.
Longitude returned by the geocoder for the student’s school-year address, rounded to two decimals.
Geocoder match rating returned for the student’s school-year address.
Census tract identifier returned by the geocoder for the student’s school-year address.
University of Nebraska Board of Regents district from GIS using latitude/longitude when available, otherwise school; -1 marks a failed lookup.
