Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2019 · 29,565
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
565387 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   pre_kindergarten                                                   *                                              
565388 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   60                                             60
565389 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   pre_kindergarten                                                   *                                              
565390 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   pre_kindergarten                                                   *                                              
565391 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   pre_kindergarten                                                   *                                              
565392 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   pre_kindergarten                                                   *                                              
565393 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   pre_kindergarten                                                   *                                              
567358 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   kindergarten                                                   62                                             62
567359 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   kindergarten                                                   43                                             43
567360 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   kindergarten                                                   *                                              
567361 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   kindergarten                                                   *                                              
567362 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   kindergarten                                                   78                                             78
567363 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   kindergarten                                                   52                                             52
567364 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   kindergarten                                                   89                                             89
569329 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_1                                                   68                                             68
569330 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_1                                                   45                                             45
569331 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_1                                                   *                                              
569332 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_1                                                   *                                              
569333 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_1                                                   94                                             94
569334 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_1                                                   66                                             66
569335 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_1                                                   87                                             87
571300 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_2                                                   60                                             60
571301 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_2                                                   44                                             44
571302 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_2                                                   *                                              
571303 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_2                                                   *                                              
571304 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_2                                                   74                                             74
571305 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_2                                                   55                                             55
571306 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_2                                                   83                                             83
573271 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_3                                                   69                                             69
573272 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_3                                                   51                                             51
573273 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_3                                                   *                                              
573274 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_3                                                   *                                              
573275 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_3                                                   84                                             84
573276 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_3                                                   79                                             79
573277 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_3                                                   93                                             93
575242 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_4                                                   72                                             72
575243 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_4                                                   43                                             43
575244 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_4                                                   *                                              
575245 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_4                                                   *                                              
575246 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_4                                                   92                                             92
575247 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_4                                                   85                                             85
575248 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_4                                                   89                                             89
577213 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_5                                                   83                                             83
577214 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_5                                                   48                                             48
577215 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_5                                                   *                                              
577216 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_5                                                   *                                              
577217 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_5                                                   87                                             87
577218 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_5                                                   85                                             85
577219 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_5                                                   89                                             89
579184 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_6                                                   91                                             91
579185 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_6                                                   67                                             67
579186 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_6                                                   *                                              
579187 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_6                                                   *                                              
579188 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_6                                                   85                                             85
579189 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_6                                                   87                                             87
579190 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_6                                                   79                                             79
581155 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_7                                                   *                                              
581156 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_7                                                   *                                              
581157 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_7                                                   *                                              
581158 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_7                                                   467                                             467
581159 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_7                                                   *                                              
581160 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_7                                                   *                                              
581161 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_7                                                   *                                              
583126 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_8                                                   *                                              
583127 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_8                                                   *                                              
583128 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_8                                                   *                                              
583129 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_8                                                   428                                             428
583130 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_8                                                   *                                              
583131 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_8                                                   *                                              
583132 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_8                                                   *                                              
585097 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_9                                                   *                                              
585098 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_9                                                   *                                              
585099 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_9                                                   509                                             509
585100 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_9                                                   *                                              
585101 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_9                                                   *                                              
585102 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_9                                                   *                                              
585103 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_9                                                   *                                              
587068 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_10                                                   *                                              
587069 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_10                                                   *                                              
587070 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_10                                                   477                                             477
587071 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_10                                                   *                                              
587072 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_10                                                   *                                              
587073 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_10                                                   *                                              
587074 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_10                                                   *                                              
589039 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_11                                                   *                                              
589040 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_11                                                   *                                              
589041 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_11                                                   433                                             433
589042 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_11                                                   *                                              
589043 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_11                                                   *                                              
589044 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_11                                                   *                                              
589045 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_11                                                   *                                              
591010 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_12                                                   *                                              
591011 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   grade_12                                                   *                                              
591012 AZ     school 400001 4244   Cave Creek Unified District 40000101204 5137 Cactus Shadows High School   Regular School No High 08 12 2019   grade_12                                                   464                                             464
591013 AZ     school 400001 4244   Cave Creek Unified District 40000101871 78911 Sonoran Trails Middle School   Regular School No Middle 06 08 2019   grade_12                                                   *                                              
591014 AZ     school 400001 4244   Cave Creek Unified District 40000101872 78912 Desert Willow Elementary School   Regular School No Elementary KG 06 2019   grade_12                                                   *                                              
591015 AZ     school 400001 4244   Cave Creek Unified District 40000102344 80056 Lone Mountain Elementary School   Regular School No Elementary KG 06 2019   grade_12                                                   *                                              
591016 AZ     school 400001 4244   Cave Creek Unified District 40000102484 87477 Horseshoe Trails Elementary School   Regular School No Elementary KG 06 2019   grade_12                                                   *                                              
592981 AZ     school 400001 4244   Cave Creek Unified District 40000100120 5134 Black Mountain Elementary School   Regular School No Elementary KG 06 2019   pk_12_total 419 * 61   * *     *   12   237 268     *             100   505 419   61               12   237 268             100   505
592982 AZ     school 400001 4244   Cave Creek Unified District 40000100616 5136 Desert Sun Academy   Regular School No Elementary PK 06 2019   pk_12_total 319 * 50   * *     *   16   222 179     *             118   401 319   50               16   222 179             118   401

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]);