Data source: Big Local News · About: Big Local

29,565 rows where state = "AZ" and year = 2019 sorted by district_state_id

View and edit SQL

grade

year

  • 2019 · 29,535
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
565469 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   pre_kindergarten                                                   *                                              
565470 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   pre_kindergarten                                                   *                                              
565471 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   pre_kindergarten                                                   *                                              
565472 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   pre_kindergarten                                                   *                                              
567440 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   kindergarten                                                   *                                              
567441 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   kindergarten                                                   *                                              
567442 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   kindergarten                                                   *                                              
567443 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   kindergarten                                                   *                                              
569411 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_1                                                   *                                              
569412 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_1                                                   *                                              
569413 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_1                                                   *                                              
569414 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_1                                                   *                                              
571382 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_2                                                   *                                              
571383 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_2                                                   *                                              
571384 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_2                                                   *                                              
571385 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_2                                                   *                                              
573353 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_3                                                   *                                              
573354 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_3                                                   *                                              
573355 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_3                                                   *                                              
573356 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_3                                                   *                                              
575324 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_4                                                   *                                              
575325 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_4                                                   *                                              
575326 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_4                                                   *                                              
575327 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_4                                                   *                                              
577295 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_5                                                   *                                              
577296 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_5                                                   *                                              
577297 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_5                                                   *                                              
577298 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_5                                                   *                                              
579266 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_6                                                   *                                              
579267 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_6                                                   *                                              
579268 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_6                                                   *                                              
579269 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_6                                                   *                                              
581237 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_7                                                   *                                              
581238 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_7                                                   *                                              
581239 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_7                                                   *                                              
581240 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_7                                                   *                                              
583208 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_8                                                   *                                              
583209 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_8                                                   *                                              
583210 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_8                                                   *                                              
583211 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_8                                                   *                                              
585179 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_9                                                   *                                              
585180 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_9                                                   *                                              
585181 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_9                                                   *                                              
585182 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_9                                                   *                                              
587150 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_10                                                   *                                              
587151 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_10                                                   *                                              
587152 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_10                                                   *                                              
587153 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_10                                                   *                                              
589121 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_11                                                   *                                              
589122 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_11                                                   *                                              
589123 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_11                                                   12                                             12
589124 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_11                                                   13                                             13
591092 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   grade_12                                                   *                                              
591093 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   grade_12                                                   *                                              
591094 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   grade_12                                                   44                                             44
591095 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   grade_12                                                   64                                             64
593063 AZ     school 400163 10386   Coconino County Accommodation School District 40016301820 78915 Juvenile Detention   Regular School No Other 04 12 2019   pk_12_total * * *   * *     *   *   11 *     *             *   16                         11                   16
593064 AZ     school 400163 10386   Coconino County Accommodation School District 40016301821 79010 Jail - Coconino County Accommodation School District   Regular School No High 07 12 2019   pk_12_total * * *   * *     *   *   * *     *             *   *                                              
593065 AZ     school 400163 10386   Coconino County Accommodation School District 40016303138 81127 Tse'yaato' High School   Regular School No High 09 12 2019   pk_12_total * * *   53 *     *   *   29 29     *             *   58         53               29 29                 58
593066 AZ     school 400163 10386   Coconino County Accommodation School District 40016302429 85842 Ponderosa High School   Regular School No High 09 12 2019   pk_12_total 14 * 27   36 *     *   *   44 33     *             *   77 14   27   36               44 33                 77
566262 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   pre_kindergarten                                                   *                                              
568233 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   kindergarten                                                   148                                             148
570204 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_1                                                   143                                             143
572175 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_2                                                   136                                             136
574146 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_3                                                   126                                             126
576117 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_4                                                   129                                             129
578088 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_5                                                   120                                             120
580059 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_6                                                   130                                             130
582030 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_7                                                   *                                              
584001 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_8                                                   *                                              
585972 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_9                                                   *                                              
587943 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_10                                                   *                                              
589914 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_11                                                   *                                              
591885 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   grade_12                                                   *                                              
593856 AZ     school 400340 10760   Noah Webster Schools - Mesa 40034001940 10800 Noah Webster Schools- Mesa   Regular School Yes Elementary KG 06 2019   pk_12_total 496 30 328   * 15     *   56   451 481     24             75   932 496 30 328     15         56   451 481     24       75   932
565956 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   pre_kindergarten                                                   *                                              
567927 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   kindergarten                                                   *                                              
569898 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_1                                                   33                                             33
571869 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_2                                                   32                                             32
573840 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_3                                                   29                                             29
575811 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_4                                                   28                                             28
577782 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_5                                                   25                                             25
579753 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_6                                                   32                                             32
581724 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_7                                                   14                                             14
583695 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_8                                                   12                                             12
585666 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_9                                                   *                                              
587637 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_10                                                   *                                              
589608 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_11                                                   *                                              
591579 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   grade_12                                                   *                                              
593550 AZ     school 400165 10878   Keystone Montessori Charter School, Inc. 40016501755 10884 Keystone Montessori Charter School   Regular School Yes Other 01 09 2019   pk_12_total 121 * 48   * 16     *   17   108 99     *             37   207 121   48     16         17   108 99             37   207
566248 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   pre_kindergarten                                                   *                                              
568219 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   kindergarten                                                   *                                              
570190 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_1                                                   *                                              
572161 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_2                                                   *                                              
574132 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_3                                                   *                                              
576103 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_4                                                   *                                              
578074 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_5                                                   *                                              
580045 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_6                                                   *                                              
582016 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_7                                                   *                                              
583987 AZ     school 400204 10879   Mountain Rose Academy, Inc. 40020401962 10885 Mountain Rose Academy   Alternative School Yes High 09 12 2019   grade_8                                                   *                                              

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);