Data source: Big Local News · About: Big Local

14,925 rows where state = "NM" and year = 2020 sorted by white descending

View and edit SQL

year

  • 2020 · 14,925
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
2554719 NM     school 3500060 1   ALBUQUERQUE 350006000063 520 HIGHLAND HIGH Public Regular School No High 09 12 2020   pk_12_total 98 100 818   86 *     *   38                             1163 98 100 818   86           38                       1163
2554961 NM     school 3500570 12   CLOVIS 350057000214 58 HIGHLAND ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 98 11 182   * *     *   11                             306 98 11 182               11                       306
2555249 NM     school 3501500 17   LAS CRUCES 350150000388 86 LYNN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 98 35 483   17 8     *   *                             645 98 35 483   17 8                                 645
2555386 NM     school 3500106 504   NORTH VALLEY CHARTER 350010600873 1 NORTH VALLEY ACADEMY Charter Regular School Yes Elementary PK 08 2020   pk_12_total 98 * 385   * *     *   *                             497 98   385                                       497
2555457 NM     school 3502250 4   ROSWELL 350225000518 36 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 98 13 441   * *     *   *                             557 98 13 441                                       557
2554678 NM     school 3500060 1   ALBUQUERQUE 350006001081 706 CORAL COMMUNITY CHARTER Charter Regular School Yes Not applicable N N 2020   pk_12_total 97 10 115   8 *     *   18                             251 97 10 115   8           18                       251
2555185 NM     school 3501260 33   HOBBS 350126000353 72 MILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 97 16 268   * *     *   9                             394 97 16 268               9                       394
2554831 NM     school 3500131 525   AMY BIEHL CHARTER HIGH SCHOOL 350013100810 1 AMY BIEHL CHARTER HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pk_12_total 96 11 180   10 *     *   *                             305 96 11 180   10                                   305
2554823 NM     school 3500060 1   ALBUQUERQUE 350006000124 385 ZIA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 95 10 137   18 *     *   18                             283 95 10 137   18           18                       283
2555047 NM     school 3500960 32   EUNICE 350096000622 50 EUNICE HIGH Public Regular School No High 09 12 2020   pk_12_total 95 * 132   * *     *   *                             230 95   132                                       230
2555569 NM     school 3502550 35   TATUM 350255000585 162 TATUM ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 95 * 76   * *     *   *                             175 95   76                                       175
2554635 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 94 21 35   * 11     *   29                             194 94 21 35     11         29                       194
2554724 NM     school 3500060 1   ALBUQUERQUE 350006000067 276 INEZ ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 93 16 205   25 *     *   11                             357 93 16 205   25           11                       357
2554891 NM     school 3500300 20   CARLSBAD 350030001109 35 CARLSBAD EARLY COLLEGE HIGH Public Regular School No High 09 12 2020   pk_12_total 93 * 105   * 8     *   *                             214 93   105     8                                 214
2554676 NM     school 3500060 1   ALBUQUERQUE 350006000042 241 COMANCHE ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 92 16 195   48 *     *   11                             367 92 16 195   48           11                       367
2555008 NM     school 3500790 60   DORA 350079000250 44 DORA ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 92 * 33   * *     *   *                             134 92   33                                       134
2555052 NM     school 3500990 65   FARMINGTON 350099000282 19 BLUFFVIEW ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 92 * 138   132 *     *   30                             395 92   138   132           30                       395
2555252 NM     school 3501500 17   LAS CRUCES 350150001063 15 MESA MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 91 15 619   7 *     *   9                             750 91 15 619   7           9                       750
2554796 NM     school 3500060 1   ALBUQUERQUE 350006000110 357 SOMBRA DEL MONTE ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 90 21 186   25 *     *   19                             351 90 21 186   25           19                       351
2554721 NM     school   1   ALBUQUERQUE   998 HOMEBOUND Off-Site           2020   pk_12_total 9 * 22   * *     *   *                             36 9   22                                       36
2554740 NM     school 3500060 1   ALBUQUERQUE 350006000075 285 LA MESA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 9 28 358   26 *     *   8                             434 9 28 358   26           8                       434
2554978 NM     school 3500600 24   COBRE CONS. 350060000228 59 HURLEY ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 9 * 141   * *     *   *                             153 9   141                                       153
2555100 NM     school   19   GADSDEN   6 RTC-RESIDENTAL TRAINING CENTER Off-Site           2020   pk_12_total 9 * 12   * *     *   *                             22 9   12                                       22
2555194 NM     school 3501290 39   HONDO 350129000359 59 HONDO ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 9 * 61   * *     *   *                             71 9   61                                       71
2555454 NM     school   4   ROSWELL   997 MISC PRIVATE Private           2020   pk_12_total 9 * *   * *     *   *                             16 9                                           16
2554720 NM     school 3500060 1   ALBUQUERQUE 350006000064 273 HODGIN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 89 30 230   110 *     *   30                             493 89 30 230   110           30                       493
2555046 NM     school 3500960 32   EUNICE 350096000623 49 CATON MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 89 * 116   * *     *   *                             209 89   116                                       209
2554818 NM     school 3500060 1   ALBUQUERQUE 350006000119 570 WEST MESA HIGH Public Regular School No High 09 12 2020   pk_12_total 88 52 1451   99 *     *   41                             1745 88 52 1451   99           41                       1745
2555001 NM     school 3500690 42   DEMING 350069001023 7 RED MOUNTAIN MIDDLE Public Regular School No Middle 07 08 2020   pk_12_total 88 13 685   * 15     *   *                             805 88 13 685     15                                 805
2555174 NM     school 3501260 33   HOBBS 350126000345 28 BROADMOOR ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 88 12 290   * *     *   6                             397 88 12 290               6                       397
2555178 NM     school 3501260 33   HOBBS 350126001067 8 HEIZER MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pk_12_total 88 23 563   * *     *   *                             678 88 23 563                                       678
2555238 NM     school 3501500 17   LAS CRUCES 350150000383 51 FAIRACRES ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 88 * 351   * *     *   *                             450 88   351                                       450
2555573 NM     school 3502580 13   TEXICO 350258000589 162 TEXICO HIGH Public Regular School No High 09 12 2020   pk_12_total 88 * 72   * *     *   *                             165 88   72                                       165
2554903 NM     school 3500300 20   CARLSBAD 350030000174 144 JOE STANLEY SMITH ELEMENTARY Public Regular School No Elementary 01 05 2020   pk_12_total 86 * 255   * *     *   *                             350 86   255                                       350
2555405 NM     school 3502100 57   PORTALES 350210000417 160 VALENCIA ELEMENTARY Public Regular School No Elementary 03 04 2020   pk_12_total 85 11 245   * *     *   11                             357 85 11 245               11                       357
2555526 NM     school 3502430 23   SILVER CITY 350243000560 34 CLIFF HIGH Public Regular School No High 07 12 2020   pk_12_total 85 * 18   * *     *   *                             105 85   18                                       105
2554945 NM     school 3500510 84   CLAYTON 350051000200 37 ALVIS ELEMENTARY Public Regular School No Elementary PK 04 2020   pk_12_total 84 * 96   * *     *   *                             183 84   96                                       183
2555544 NM     school 3502460 74   SOCORRO 350246000571 160 SOCORRO HIGH Public Regular School No High 09 12 2020   pk_12_total 84 16 357   9 *     *   *                             473 84 16 357   9                                   473
2555577 NM     school 3500125 519   THE MASTERS PROGRAM 350012501069 1 THE MASTERS PROGRAM Charter Regular School Yes High 09 12 2020   pk_12_total 84 8 155   * 10     *   *                             263 84 8 155     10                                 263
2554688 NM     school 3500060 1   ALBUQUERQUE 350006000853 63 DIGITAL ARTS AND TECHNOLOGY Charter Regular School Yes High 09 12 2020   pk_12_total 83 * 163   11 8     *   8                             280 83   163   11 8         8                       280
2555133 NM     school 3501110 43   GALLUP 350111000312 134 RED ROCK ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 83 * 74   138 14     *   10                             321 83   74   138 14         10                       321
2555315 NM     school 3501710 21   LOVING 350171000442 85 LOVING ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 83 * 215   * *     *   *                             300 83   215                                       300
2554728 NM     school 3500060 1   ALBUQUERQUE 350006000053 258 JANET KAHN FINE ARTS ACADEMY Public Regular School No Elementary PK 05 2020   pk_12_total 82 18 238   67 *     *   27                             433 82 18 238   67           27                       433
2554913 NM     school 3500390 67   CENTRAL CONS. 350039000179 35 CENTRAL HIGH Public Regular School No High 09 12 2020   pk_12_total 82 * 47   582 *     *   11                             725 82   47   582           11                       725
2554990 NM     school 3500690 42   DEMING 350069000237 28 CHAPARRAL ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 82 * 282   * 15     *   *                             387 82   282     15                                 387
2555200 NM     school 3500179 573   HOZHO ACADEMY 350017901136 1 HOZHO ACADEMY Charter Regular School Yes Elementary KG 06 2020   pk_12_total 82 * 63   127 8     *   7                             292 82   63   127 8         7                       292
2555277 NM     school 3501590 51   LOGAN 350159000420 80 LOGAN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 82 * 27   * *     *   *                             112 82   27                                       112
2554738 NM     school 3500060 1   ALBUQUERQUE 350006000698 525 LA CUEVA HIGH Public Regular School No High 09 12 2020   pk_12_total 813 * 667   30 179     *   84                             1800 813   667   30 179         84                       1800
2554711 NM     school 3500060 1   ALBUQUERQUE 350006000058 413 GRANT MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 81 14 291   26 *     *   36                             461 81 14 291   26           36                       461
2554888 NM     school 3500270 40   CAPITAN 350027000544 36 CAPITAN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 81 * 35   * *     *   *                             121 81   35                                       121
2555054 NM     school 3500990 65   FARMINGTON 350099000693 38 ESPERANZA ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 81 * 226   179 *     *   24                             511 81   226   179           24                       511
2555127 NM     school 3501110 43   GALLUP 350111000768 73 MIYAMURA HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total 81 * 314   771 26     *   12                             1207 81   314   771 26         12                       1207
2555435 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public Alternative School No High 06 12 2020   pk_12_total 81 * 59   * *     *   *                             147 81   59                                       147
2555448 NM     school 3502250 4   ROSWELL 350225000509 44 EAST GRAND PLAINS ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 81 7 211   * *     *   *                             300 81 7 211                                       300
2555531 NM     school 3502430 23   SILVER CITY 350243000563 145 LA PLATA MIDDLE Public Regular School No Middle 07 09 2020   pk_12_total 81 * 253   6 *     *   8                             353 81   253   6           8                       353
2555541 NM     school 3502460 74   SOCORRO 350246000789 1 PARKVIEW ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 81 6 335   23 9     *   *                             457 81 6 335   23 9                                 457
2555437 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public Regular School No High 09 12 2020   pk_12_total 802 54 1447   81 44     8   122                             2558 802 54 1447   81 44     8   122                       2558
2554824 NM     school 3500060 1   ALBUQUERQUE 350006000125 388 ZUNI ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 80 * 182   20 8     *   6                             301 80   182   20 8         6                       301
2555015 NM     school 3500840 58   ELIDA 350084000255 47 ELIDA ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 80 * 12   * *     *   *                             94 80   12                                       94
2555069 NM     school 3500990 65   FARMINGTON 350099000740 148 ROCINANTE HIGH Public Alternative School No High 06 12 2020   pk_12_total 80 * 79   89 *     *   14                             263 80   79   89           14                       263
2555467 NM     school 3502250 4   ROSWELL 350225000525 175 WASHINGTON AVE ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 80 6 339   * *     *   *                             433 80 6 339                                       433
2554691 NM     school 3500060 1   ALBUQUERQUE 350006000047 249 DURANES ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 8 7 125   6 *     *   *                             147 8 7 125   6                                   147
2554739 NM     school 3500060 1   ALBUQUERQUE 350006000074 282 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 8 * 148   * *     *   *                             161 8   148                                       161
2555071 NM     school   65   FARMINGTON   8 SAN JUAN COUNTY JUVENILE SERVICE CENTER Off-Site           2020   pk_12_total 8 * 12   6 *     *   *                             27 8   12   6                                   27
2555090 NM     school 3501080 19   GADSDEN 350108001065 17 GADSDEN ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 8 * 440   * *     *   *                             449 8   440                                       449
2555172 NM     school 3501230 18   HATCH 350123000753 1 RIO GRANDE ELEMENTARY Public Regular School No Elementary 03 05 2020   pk_12_total 8 * 270   * *     *   *                             279 8   270                                       279
2555219 NM     school 3500155 546   LA TIERRA MONTESSORI SCHOOL 350015501084 1 LA TIERRA MONTESSORI SCHOOL OF THE ARTS AND SCIENCES Charter Regular School Yes Elementary KG 06 2020   pk_12_total 8 * 53   * *     *   *                             65 8   53                                       65
2555410 NM     school 3502160 79   QUESTA 350216000495 3 ALTA VISTA INTERMEDIATE Public Regular School No Middle 04 06 2020   pk_12_total 8 * 53   * *     *   *                             63 8   53                                       63
2554681 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter Regular School Yes Other KG 12 2020   pk_12_total 79 * 152   * 11     *   12                             260 79   152     11         12                       260
2555567 NM     school 3500127 521   TAOS INTEGRATED SCHOOL OF THE ARTS 350012701060 1 TAOS INTEGRATED SCHOOL OF ARTS Charter Regular School Yes Elementary KG 08 2020   pk_12_total 79 * 72   18 *     *   *                             173 79   72   18                                   173
2554879 NM     school 3500240 66   BLOOMFIELD 350024000155 25 BLANCO ELEMENTARY Public Regular School No Elementary 01 06 2020   pk_12_total 78 * 95   18 *     *   *                             197 78   95   18                                   197
2554951 NM     school 3500540 48   CLOUDCROFT 350054030005 42 CLOUDCROFT MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 78 * 23   * *     *   *                             104 78   23                                       104
2555245 NM     school 3501500 17   LAS CRUCES 350150000385 61 JORNADA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 78 9 442   * *     *   *                             538 78 9 442                                       538
2555267 NM     school 3501500 17   LAS CRUCES 350150000377 170 VISTA MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 78 15 573   * *     *   *                             679 78 15 573                                       679
2555505 NM     school 3502370 71   SANTA FE 350237000641 100 PINON ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 78 * 477   7 13     *   *                             583 78   477   7 13                                 583
2554700 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   pk_12_total 776 * 753   72 47     *   102                             1779 776   753   72 47         102                       1779
2554766 NM     school 3500060 1   ALBUQUERQUE 350006000920 98 MOUNTAIN MAHOGANY COMMUNITY SCHOOL Charter Regular School Yes Elementary KG 08 2020   pk_12_total 77 7 98   * *     *   14                             197 77 7 98               14                       197
2555459 NM     school 3502250 4   ROSWELL 350225000519 122 PARKVIEW EARLY LITERACY CENTER Public Regular School No Prekindergarten PK PK 2020   pk_12_total 77 * 239   * *     *   *                             326 77   239                                       326
2555537 NM     school 3502460 74   SOCORRO 350246000843 3 COTTONWOOD VALLEY CHARTER Charter Regular School Yes Elementary KG 08 2020   pk_12_total 77 * 82   * 6     *   *                             170 77   82     6                                 170
2554880 NM     school 3500240 66   BLOOMFIELD 350024000609 30 BLOOMFIELD EARLY CHILDHOOD CENTER Public Regular School No Elementary PK KG 2020   pk_12_total 76 * 127   84 *     *   *                             292 76   127   84                                   292
2555009 NM     school 3500790 60   DORA 350079000251 45 DORA HIGH Public Regular School No High 07 12 2020   pk_12_total 76 * *   * *     *   *                             109 76                                           109
2555309 NM     school 3501680 86   LOS LUNAS 350168000438 83 RAYMOND GABALDON ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total 76 * 322   7 *     *   6                             416 76   322   7           6                       416
2555557 NM     school 3502520 76   TAOS 350252000579 175 ENOS GARCIA ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 76 * 357   20 *     *   10                             470 76   357   20           10                       470
2555564 NM     school 3502520 76   TAOS 350252000817 5 TAOS MUNICIPAL CHARTER Charter Regular School Yes Elementary KG 08 2020   pk_12_total 76 * 126   * *     *   *                             212 76   126                                       212
2555423 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total 748 79 1376   117 *     *   125                             2484 748 79 1376   117           125                       2484
2555563 NM     school 3502520 76   TAOS 350252000584 164 TAOS MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 74 * 357   40 *     *   *                             482 74   357   40                                   482
2554725 NM     school 3500060 1   ALBUQUERQUE 350006001056 781 INTERNATIONAL SCHOOL AT MESA DEL SOL Charter Regular School Yes Other PK 12 2020   pk_12_total 73 6 246   6 *     *   7                             342 73 6 246   6           7                       342
2555325 NM     school 3501740 31   LOVINGTON 350174001044 83 LOVINGTON FRESHMAN ACADEMY Public Regular School No Secondary 09 09 2020   pk_12_total 73 * 239   * *     *   *                             320 73   239                                       320
2555482 NM     school 3502370 71   SANTA FE 350237000534 8 ACEQUIA MADRE ELEMENTARY Public Regular School No Elementary KG 06 2020   pk_12_total 73 * 66   * 7     *   *                             152 73   66     7                                 152
2555548 NM     school 3500137 531   SOUTHWEST SECONDARY LEARNING CENTER 350013700819 1 SOUTHWEST SECONDARY LEARNING CENTER Charter Regular School Yes High 09 12 2020   pk_12_total 73 * 100   7 *     *   *                             190 73   100   7                                   190
2554655 NM     school 3500060 1   ALBUQUERQUE 350006000028 329 ARROYO DEL OSO ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 72 * 206   34 19     *   24                             367 72   206   34 19         24                       367
2554812 NM     school 3500060 1   ALBUQUERQUE 350006000116 560 VALLEY HIGH Public Regular School No High 09 12 2020   pk_12_total 72 18 932   30 *     *   12                             1067 72 18 932   30           12                       1067
2554963 NM     school 3500570 12   CLOVIS 350057000210 66 JAMES BICKLEY ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 72 22 271   * *     *   *                             372 72 22 271                                       372
2555201 NM     school 3500141 535   J PAUL TAYLOR ACADEMY 350014101057 1 J PAUL TAYLOR ACADEMY Charter Regular School Yes Elementary KG 08 2020   pk_12_total 72 * 121   * *     *   *                             200 72   121                                       200
2554865 NM     school 3500180 87   BELEN 350018000867 6 THE FAMILY SCHOOL Public Alternative School No Elementary 01 08 2020   pk_12_total 71 * 92   * *     *   *                             174 71   92                                       174
2554661 NM     school 3500060 1   ALBUQUERQUE 350006000033 229 BELLEHAVEN ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 70 12 189   26 *     *   16                             319 70 12 189   26           16                       319
2555145 NM     school 3501140 15   GRADY 350114000325 55 GRADY ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 70 * 25   * *     *   *                             96 70   25                                       96
2555191 NM     school 3501260 33   HOBBS 350126000356 164 TAYLOR ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 70 13 322   * *     *   8                             420 70 13 322               8                       420
2555318 NM     school 3501740 31   LOVINGTON 350174000449 123 BEN ALEXANDER ELEMENTARY Public Regular School No Elementary 02 02 2020   pk_12_total 70 7 165   * *     *   *                             246 70 7 165                                       246
2555593 NM     school 3502670 47   TULAROSA 350267000968 160 TULAROSA INTERMEDIATE Public Regular School No Elementary 03 06 2020   pk_12_total 70 * 115   77 *     *   *                             269 70   115   77                                   269

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