Data source: Big Local News · About: Big Local

29,595 rows where state = "NM" sorted by hispanic descending

View and edit SQL

grade

year

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
2961009 NM     school 3500840 58   ELIDA 350084000256 48 ELIDA HIGH Public - High School Regular School No High 07 12 2021   pk_12_total 65 * 8   * *     *   *                             75 65   8                                       75
2961098 NM     school 3501110 43   GALLUP 350111000299 34 CATHERINE A. MILLER ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 8   293 *     *   *                             302     8   293                                   302
2961233 NM     school   17   LAS CRUCES   993 HOSPITALIZED Off-Site - Central Office           2021   pk_12_total * * 8   * *     *   *                             12     8                                       12
2961327 NM     school 3501830 14   MELROSE 350183000898 93 MELROSE JUNIOR Public - Junior High Regular School No Middle 07 08 2021   pk_12_total 43 * 8   * *     *   *                             53 43   8                                       53
2961506 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   pk_12_total * * 8   * *     *   *                             12     8                                       12
2960752 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public - High School Regular School No Other PK 12 2021   pk_12_total 286 57 798   114 *     *   71                             1379 286 57 798   114           71                       1379
2555493 NM     school 3502370 71   SANTA FE 350237000535 11 EL CAMINO REAL ACADEMY COMMUNITY Public Regular School No Elementary PK 08 2020   pk_12_total 37 * 795   * *     *   *                             836 37   795                                       836
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
2960638 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total 243 34 79   * *     11   55                             429 243 34 79           11   55                       429
2961447 NM     school 3502250 4   ROSWELL 350225000826 9 SIDNEY GUTIERREZ MIDDLE Charter - Middle School Regular School Yes Elementary KG 08 2021   pk_12_total 107 * 79   * *     *   *                             196 107   79                                       196
2961538 NM     school 3502520 76   TAOS 350252000790 4 ARROYO DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total 31 * 79   * *     *   6                             121 31   79               6                       121
2555092 NM     school 3501080 19   GADSDEN 350108000631 52 GADSDEN MIDDLE Public Regular School No Middle 07 08 2020   pk_12_total 10 * 778   * *     *   *                             790 10   778                                       790
2960855 NM     school 3500180 87   BELEN 350018000140 26 BELEN HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 214 13 773   24 *     *   *                             1028 214 13 773   24                                   1028
2554628 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public Alternative School No High 10 12 2020   pk_12_total 48 * 77   * *     *   7                             141 48   77               7                       141
2555409 NM     school 3502160 79   QUESTA 350216000804 1 ALTA VISTA ELEMENTARY Public Regular School No Elementary PK 03 2020   pk_12_total * * 77   * *     *   *                             87     77                                       87
2960685 NM     school 3500060 1   ALBUQUERQUE 350006001133 952 COYOTE WILLOW FAMILY SCHOOL Public - Elementary School Alternative School No Elementary KG 08 2021   pk_12_total 143 * 77   * *     *   *                             229 143   77                                       229
2961024 NM     school 3500900 55   ESPANOLA 350090000685 142 LOS NINOS ELEMENTARY Public - Elementary School Regular School No Elementary PK KG 2021   pk_12_total * * 77   * *     *   *                             82     77                                       82
2961154 NM     school 3501200 5   HAGERMAN 350120000341 56 HAGERMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 23 * 77   * *     *   *                             101 23   77                                       101
2554855 NM     school 3500180 87   BELEN 350018000140 26 BELEN HIGH Public Regular School No High 09 12 2020   pk_12_total 203 14 767   21 *     *   *                             1011 203 14 767   21                                   1011
2555024 NM     school 3500900 55   ESPANOLA 350090000268 50 ESPANOLA VALLEY HIGH Public Regular School No High 09 12 2020   pk_12_total 29 * 761   73 9     *   *                             875 29   761   73 9                                 875
2554829 NM     school 3500116 511   ALMA D'ARTE CHARTER 350011600900 1 ALMA D'ARTE CHARTER Charter Regular School Yes High 09 12 2020   pk_12_total 49 6 76   * *     *   *                             132 49 6 76                                       132
2555110 NM     school 3501110 43   GALLUP 350111001027 3 CHIEF MANUELITO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 10 * 76   476 *     *   8                             575 10   76   476           8                       575
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
2555574 NM     school 3502580 13   TEXICO 350258000590 163 TEXICO MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 67 * 76   * *     *   *                             149 67   76                                       149
2555583 NM     school 3502610 73   TRUTH OR CONS. 350261000435 60 SIERRA ELEMENTARY Public Regular School No Elementary 04 05 2020   pk_12_total 109 * 76   * *     *   *                             190 109   76                                       190
2960689 NM     school 3500060 1   ALBUQUERQUE 350006000273 900 DESERT WILLOW FAMILY SCHOOL Public - Elementary School Alternative School No Elementary KG 08 2021   pk_12_total 182 * 76   * 7     *   23                             291 182   76     7         23                       291
2961042 NM     school 3500990 65   FARMINGTON 350099000281 17 APACHE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pk_12_total 41 * 76   298 *     *   24                             444 41   76   298           24                       444
2961261 NM     school 3501530 69   LAS VEGAS CITY 350153000863 3 LVCS EARLY CHILDHOOD Public - Elementary School Regular School No Elementary KG KG 2021   pk_12_total * * 76   * *     *   *                             83     76                                       83
2961330 NM     school 3501980 78   MESA VISTA 350198000475 119 MESA VISTA HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 9 * 76   * *     *   *                             87 9   76                                       87
2961450 NM     school 3502250 4   ROSWELL 350225000696 132 UNIVERSITY HIGH Public - High School Alternative School No High 09 12 2021   pk_12_total 23 * 76   * *     *   *                             102 23   76                                       102
2961575 NM     school 3502670 47   TULAROSA 350267000604 163 TULAROSA ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   pk_12_total 51 * 76   56 *     *   *                             190 51   76   56                                   190
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
2554806 NM     school 3500060 1   ALBUQUERQUE 350006001047 492 TONY HILLERMAN MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pk_12_total 312 27 752   39 *     *   74                             1229 312 27 752   39           74                       1229
2961476 NM     school 3502370 71   SANTA FE 350237000535 11 EL CAMINO REAL ACADEMY COMMUNITY Public - Elementary School Regular School No Elementary PK 08 2021   pk_12_total 26 * 752   * *     *   *                             781 26   752                                       781
2555051 NM     school 3500990 65   FARMINGTON 350099000281 17 APACHE ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 46 * 75   315 *     *   33                             473 46   75   315           33                       473
2555385 NM     school 3500014 93   NM SCHOOL FOR THE DEAF 350001400972 150 NM SCHOOL FOR THE DEAF State Supported Special Education School No Other PK 12 2020   pk_12_total 33 * 75   16 *     *   *                             132 33   75   16                                   132
2960856 NM     school 3500180 87   BELEN 350018000848 1 BELEN INFINITY HIGH Public - High School Alternative School No High 09 12 2021   pk_12_total 25 * 75   * *     *   *                             105 25   75                                       105
2960932 NM     school 3500420 53   CHAMA 350042000192 36 CHAMA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 75   * *     *   *                             87     75                                       87
2961340 NM     school 3501860 44   MORA 350186000784 1 LAZARO LARRY GARCIA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 75   * *     *   *                             80     75                                       80
2961082 NM     school 3501080 19   GADSDEN 350108000631 52 GADSDEN MIDDLE Public - Middle School Regular School No Middle 07 08 2021   pk_12_total 11 * 744   * *     *   *                             758 11   744                                       758
2554627 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 12 2020   pk_12_total 21 * 74   * *     *   *                             103 21   74                                       103
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
2555166 NM     school 3501200 5   HAGERMAN 350120000341 56 HAGERMAN MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 74   * *     *   *                             99     74                                       99
2555218 NM     school 3500166 560   LA ACADEMIA DOLORES HUERTA 350016600901 1 LA ACADEMIA DOLORES HUERTA Charter Regular School Yes Middle 06 08 2020   pk_12_total * * 74   * *     *   *                             76     74                                       76
2961556 NM     school 3502580 13   TEXICO 350258000589 162 TEXICO HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 86 * 74   * *     *   *                             163 86   74                                       163
2555070 NM     school 3500990 65   FARMINGTON 350099001119 180 SAN JUAN COLLEGE HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total 125 * 73   62 13     *   14                             291 125   73   62 13         14                       291
2555073 NM     school 3501020 59   FLOYD 350102000294 53 FLOYD ELEMENTARY Public Regular School No Elementary PK 04 2020   pk_12_total 32 * 73   * *     *   *                             107 32   73                                       107
2555086 NM     school 3501080 19   GADSDEN 350108001131 61 CHAPARRAL ON-TRACK PREK CENTER Public Regular School No Prekindergarten PK PK 2020   pk_12_total * * 73   * *     *   *                             74     73                                       74
2555327 NM     school 3501740 31   LOVINGTON 350174000796 4 NEW HOPE ALTERNATIVE HIGH Public Alternative School No High 09 12 2020   pk_12_total 31 * 73   * *     *   *                             106 31   73                                       106
2960762 NM     school   1   ALBUQUERQUE   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total 70 * 73   * *     *   8                             158 70   73               8                       158
2961010 NM     school 3500900 55   ESPANOLA 350090000259 5 ABIQUIU ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   pk_12_total 6 * 73   * *     *   *                             84 6   73                                       84
2961283 NM     school 3501650 41   LOS ALAMOS 350165001122 79 TOPPER FRESHMAN ACADEMY Public - High School Regular School No Secondary 09 09 2021   pk_12_total 171 * 73   * 13     *   11                             276 171   73     13         11                       276
2555438 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pk_12_total 334 31 728   60 *     *   69                             1240 334 31 728   60           69                       1240
2961018 NM     school 3500900 55   ESPANOLA 350090000268 50 ESPANOLA VALLEY HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 21 * 727   77 12     *   *                             844 21   727   77 12                                 844
2960702 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public - High School Regular School No Other PK 12 2021   pk_12_total 716 * 722   66 55     *   103                             1694 716   722   66 55         103                       1694
2555342 NM     school 3501980 78   MESA VISTA 350198000474 47 EL RITO ELEMENTARY Public Regular School No Elementary PK 03 2020   pk_12_total * * 72   * *     *   *                             78     72                                       78
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
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
2961249 NM     school 3501500 17   LAS CRUCES 350150000455 144 SIERRA MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 124 16 713   * *     9   12                             886 124 16 713           9   12                       886
2960994 NM     school 3500690 42   DEMING 350069001023 7 RED MOUNTAIN MIDDLE Public - Middle School Regular School No Middle 07 08 2021   pk_12_total 92 16 711   * 10     *   *                             833 92 16 711     10                                 833
2555344 NM     school 3501980 78   MESA VISTA 350198000475 119 MESA VISTA HIGH Public Regular School No High 09 12 2020   pk_12_total 12 * 71   * *     *   *                             85 12   71                                       85
2960630 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter - High School Regular School Yes Other KG 12 2021   pk_12_total 30 * 71   * *     *   *                             111 30   71                                       111
2960706 NM     school 3500060 1   ALBUQUERQUE 350006000055 596 FREEDOM HIGH Public - High School Alternative School No High 09 12 2021   pk_12_total 23 * 71   15 *     *   *                             117 23   71   15                                   117
2961060 NM     school 3500990 65   FARMINGTON 350099001119 180 SAN JUAN COLLEGE HIGH SCHOOL Public - High School Regular School No High 09 12 2021   pk_12_total 127 * 71   55 13     *   17                             286 127   71   55 13         17                       286
2961270 NM     school 3501620 29   LORDSBURG 350162000423 60 DUGAN-TARANGO MIDDLE Public - Middle School Regular School No Middle 07 08 2021   pk_12_total * * 71   * *     *   *                             77     71                                       77
2961552 NM     school 3502550 35   TATUM 350255000585 162 TATUM ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total 83 * 71   * *     *   *                             155 83   71                                       155
2555261 NM     school 3501500 17   LAS CRUCES 350150000455 144 SIERRA MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 144 22 705   10 *     *   10                             902 144 22 705   10           10                       902
2961424 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 304 30 705   49 *     *   56                             1159 304 30 705   49           56                       1159
2961358 NM     school 3500160 554   NEW MEXICO CONNECTIONS ACADEMY 350016001096 1 NEW MEXICO CONNECTIONS ACADEMY Charter - High School Regular School Yes Other 04 12 2021   pk_12_total 419 35 703   55 *     *   57                             1289 419 35 703   55           57                       1289
2555588 NM     school 3502640 49   TUCUMCARI 350264000599 164 TUCUMCARI HIGH Public Regular School No High 09 12 2020   pk_12_total 172 8 70   * *     *   *                             254 172 8 70                                       254
2961063 NM     school 3501020 59   FLOYD 350102000294 53 FLOYD ELEMENTARY Public - Elementary School Regular School No Elementary PK 04 2021   pk_12_total 31 * 70   * *     *   *                             104 31   70                                       104
2961207 NM     school 3500166 560   LA ACADEMIA DOLORES HUERTA 350016600901 1 LA ACADEMIA DOLORES HUERTA Charter - Middle School Regular School Yes Middle 06 08 2021   pk_12_total * * 70   * *     *   *                             71     70                                       71
2554866 NM     school 3500210 61   BERNALILLO 350021000147 16 ALGODONES ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total * * 7   151 *     *   *                             163     7   151                                   163
2554921 NM     school 3500390 67   CENTRAL CONS. 350039000947 24 KIRTLAND PRE-K EARLY Public Regular School No Prekindergarten PK PK 2020   pk_12_total 19 * 7   70 *     *   *                             99 19   7   70                                   99
2554926 NM     school 3500390 67   CENTRAL CONS. 350039000684 126 NEWCOMB MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total * * 7   176 *     *   *                             188     7   176                                   188
2554928 NM     school 3500390 67   CENTRAL CONS. 350039000187 75 OJO AMARILLO ELEMENTARY Public Regular School No Elementary PK 06 2020   pk_12_total * * 7   351 *     *   17                             378     7   351           17                       378
2555132 NM     school 3501110 43   GALLUP 350111000662 130 RAMAH HIGH Public Regular School No High 06 12 2020   pk_12_total 28 * 7   135 *     *   *                             175 28   7   135                                   175
2555150 NM     school 3501170 88   GRANTS 350117001153 60 GCCS EARLY COLLEGE HIGH SCHOOL Public Regular School No High 09 12 2020   pk_12_total * * 7   16 *     *   *                             26     7   16                                   26
2555154 NM     school 3501170 88   GRANTS 350117000330 57 LAGUNA-ACOMA HIGH Public Regular School No High 09 12 2020   pk_12_total * * 7   185 *     *   *                             196     7   185                                   196
2555532 NM     school   23   SILVER CITY   997 MISC PRIVATE Private           2020   pk_12_total 28 * 7   * *     *   *                             36 28   7                                       36
2555559 NM     school   76   TAOS   992 MISC PRESCHOOL PROGRAM Off-Site           2020   pk_12_total 15 * 7   * *     *   *                             23 15   7                                       23
2960922 NM     school 3500390 67   CENTRAL CONS. 350039000182 114 NASCHITTI ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 7   73 *     *   *                             83     7   73                                   83
2960926 NM     school 3500390 67   CENTRAL CONS. 350039000184 152 NIZHONI ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 7   262 *     *   20                             292     7   262           20                       292
2960927 NM     school 3500390 67   CENTRAL CONS. 350039000187 75 OJO AMARILLO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pk_12_total * * 7   294 *     *   19                             321     7   294           19                       321
2961005 NM     school 3500810 54   DULCE 350081000716 50 DULCE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total * * 7   117 *     *   *                             126     7   117                                   126
2961025 NM     school   55   ESPANOLA   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pk_12_total * * 7   * *     *   *                             11     7                                       11
2961101 NM     school 3501110 43   GALLUP 350111000300 38 CROWNPOINT ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pk_12_total * * 7   311 *     *   *                             324     7   311                                   324
2961435 NM     school 3502250 4   ROSWELL 350225000513 130 GODDARD HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 400 23 698   * 19     *   *                             1145 400 23 698     19                                 1145
2555000 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   pk_12_total 15 * 69   * *     *   *                             85 15   69                                       85
2961590 NM     school 3501560 68   WEST LAS VEGAS 350156000412 125 TONY SERNA JR. ELEMENTARY Public - Elementary School Regular School No Elementary 04 04 2021   pk_12_total * * 69   * *     *   *                             75     69                                       75
2960740 NM     school 3500060 1   ALBUQUERQUE 350006000698 525 LA CUEVA HIGH Public - High School Regular School No High 09 12 2021   pk_12_total 777 * 689   34 158     *   102                             1784 777   689   34 158         102                       1784
2961215 NM     school 3501500 17   LAS CRUCES 350150000765 2 CAMINO REAL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pk_12_total 249 23 687   6 12     10   14                             1001 249 23 687   6 12     10   14                       1001
2554730 NM     school 3500060 1   ALBUQUERQUE 350006000812 445 JIMMY CARTER MIDDLE Public Regular School No Middle 06 08 2020   pk_12_total 55 24 686   39 *     *   8                             817 55 24 686   39           8                       817
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
2554906 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter Regular School Yes Other KG 11 2020   pk_12_total 463 20 682   38 *     *   56                             1265 463 20 682   38           56                       1265
2555313 NM     school 3501680 86   LOS LUNAS 350168000989 17 VALENCIA HIGH Public Regular School No High 09 12 2020   pk_12_total 211 7 682   34 *     *   13                             948 211 7 682   34           13                       948
2554875 NM     school 3500210 61   BERNALILLO 350021000151 127 PLACITAS ELEMENTARY Public Regular School No Elementary PK 05 2020   pk_12_total 58 6 68   6 *     *   *                             141 58 6 68   6                                   141
2554946 NM     school 3500510 84   CLAYTON 350051000203 39 CLAYTON HIGH Public Regular School No High 09 12 2020   pk_12_total 51 * 68   * *     *   *                             125 51   68                                       125
2555027 NM     school 3500900 55   ESPANOLA 350090000271 59 HERNANDEZ ELEMENTARY Public Regular School No Elementary KG 06 2020   pk_12_total * * 68   * *     *   *                             78     68                                       78
2555539 NM     school 3502460 74   SOCORRO 350246000568 79 MIDWAY ELEMENTARY Public Regular School No Elementary KG 05 2020   pk_12_total 27 * 68   * *     *   *                             97 27   68                                       97

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