About this Dataset

Student Enrollment 2009-10 School Year

This file includes enrollment data from 2009-10 school year. Data is disaggregated by school, district, and the state level and includes counts of students by the following groups: grade level, gender, race/ethnicity, and student programs and special characteristics. Please review the notes below for more information.
Organization: State of Washington
Last updated: 2020-11-10T17:21:05.514609
Tags: 2010, enrollment, k-12, ospi, student

Tables

Table 1

@usgov.state_of_washington_student_enrollment_2009_10_school_year.table_1

771.88 kB
19,488 rows
43 columns

CREATE TABLE table_1 (
  "schoolyear" TIMESTAMP,
  "organizationlevel" VARCHAR,
  "county" VARCHAR,
  "esdname" VARCHAR,
  "esdorganizationid" DOUBLE,
  "districtcode" DOUBLE,
  "districtname" VARCHAR,
  "districtorganizationid" DOUBLE,
  "schoolcode" DOUBLE,
  "schoolname" VARCHAR,
  "schoolorganizationid" DOUBLE,
  "currentschooltype" VARCHAR,
  "gradelevel" VARCHAR,
  "all_students" BIGINT,
  "female" BIGINT,
  "gender_x" BIGINT,
  "male" BIGINT,
  "american_indian_alaskan_native" BIGINT  -- American Indian/ Alaskan Native,
  "asian" BIGINT,
  "black_african_american" BIGINT  -- Black/ African American,
  "hispanic_latino_of_any_race_s" BIGINT  -- Hispanic/ Latino Of Any Race(s),
  "native_hawaiian_other_pacific_islander" BIGINT  -- Native Hawaiian/ Other Pacific Islander,
  "two_or_more_races" BIGINT,
  "white" BIGINT,
  "english_language_learners" BIGINT,
  "foster_care" BIGINT,
  "homeless" BIGINT,
  "low_income" BIGINT,
  "migrant" BIGINT,
  "military_parent" BIGINT,
  "mobile" BIGINT,
  "section_504" BIGINT,
  "students_with_disabilities" BIGINT,
  "non_english_language_learners" BIGINT,
  "non_foster_care" BIGINT,
  "non_homeless" BIGINT,
  "non_low_income" BIGINT,
  "non_migrant" BIGINT,
  "non_military_parent" BIGINT,
  "non_mobile" BIGINT,
  "non_section_504" BIGINT,
  "students_without_disabilities" BIGINT,
  "dataasof" VARCHAR
);