Data source: Big Local News · About: Big Local

4,935 rows where state = "NV" and year = 2021 sorted by district_state_id

View and edit SQL

year

  • 2021 · 4,835
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
1841976 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_7 16 0 3   0 0       0 0   12 7   0.0                   19 16 0 3   0 0       0 0   12 7   0             19
1841977 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_8 13 0 4   0 0       0 0   11 6   0.0                   17 13 0 4   0 0       0 0   11 6   0             17
1841978 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_9 17 0 2   2 0       2 1   10 14   0.0                   24 17 0 2   2 0       2 1   10 14   0             24
1841979 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_10 16 0 5   0 0       0 0   7 14   0.0                   21 16 0 5   0 0       0 0   7 14   0             21
1841980 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_11 19 0 3   0 0       0 0   11 11   0.0                   22 19 0 3   0 0       0 0   11 11   0             22
1841981 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   grade_12 20 0 5   0 0       1 1   20 7   0.0                   27 20 0 5   0 0       1 1   20 7   0             27
1841982 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   kindergarten 12 0 1   0 0       0 0   6 7   0.0                   13 12 0 1   0 0       0 0   6 7   0             13
1841983 NV     school 3200300 10   Lyon 320030000180 10603 Yerington HS   Regular School No High 09 12 2021   grade_9 31 0 41   15 1       0 7   45 50   0.0                   95 31 0 41   15 1       0 7   45 50   0             95
1841984 NV     school 3200300 10   Lyon 320030000180 10603 Yerington HS   Regular School No High 09 12 2021   grade_10 34 0 41   15 0       1 3   49 45   0.0                   94 34 0 41   15 0       1 3   49 45   0             94
1841985 NV     school 3200300 10   Lyon 320030000180 10603 Yerington HS   Regular School No High 09 12 2021   grade_11 52 0 37   12 1       1 1   47 57   0.0                   104 52 0 37   12 1       1 1   47 57   0             104
1841986 NV     school 3200300 10   Lyon 320030000180 10603 Yerington HS   Regular School No High 09 12 2021   grade_12 40 0 33   13 0       0 6   42 50   0.0                   92 40 0 33   13 0       0 6   42 50   0             92
1841987 NV     school 3200300 10   Lyon 320030000180 10603 Yerington HS   Regular School No High 09 12 2021   ungraded 1 0 2   0 0       0 0   1 2   0.0                   3 1 0 2   0 0       0 0   1 2   0             3
1841988 NV     school 3200300 10   Lyon 320030000310 10604 Dayton HS   Regular School No High 09 12 2021   grade_9 108 1 46   3 3       3 3   93 74   0.0                   167 108 1 46   3 3       3 3   93 74   0             167
1841989 NV     school 3200300 10   Lyon 320030000310 10604 Dayton HS   Regular School No High 09 12 2021   grade_10 107 0 51   1 2       1 6   79 89   0.0                   168 107 0 51   1 2       1 6   79 89   0             168
1841990 NV     school 3200300 10   Lyon 320030000310 10604 Dayton HS   Regular School No High 09 12 2021   grade_11 119 2 46   3 2       1 4   97 80   0.0                   177 119 2 46   3 2       1 4   97 80   0             177
1841991 NV     school 3200300 10   Lyon 320030000310 10604 Dayton HS   Regular School No High 09 12 2021   grade_12 110 1 46   2 1       1 3   83 81   0.0                   164 110 1 46   2 1       1 3   83 81   0             164
1841992 NV     school 3200300 10   Lyon 320030000310 10604 Dayton HS   Regular School No High 09 12 2021   ungraded 2 1 1   1 0       0 0   5 0   0.0                   5 2 1 1   1 0       0 0   5 0   0             5
1841993 NV     school 3200300 10   Lyon 320030000555 10605 Silver Stage HS   Regular School No High 09 12 2021   grade_9 56 1 17   1 0       1 7   42 41   0.0                   83 56 1 17   1 0       1 7   42 41   0             83
1841994 NV     school 3200300 10   Lyon 320030000555 10605 Silver Stage HS   Regular School No High 09 12 2021   grade_10 62 0 11   1 2       2 8   51 35   0.0                   86 62 0 11   1 2       2 8   51 35   0             86
1841995 NV     school 3200300 10   Lyon 320030000555 10605 Silver Stage HS   Regular School No High 09 12 2021   grade_11 55 1 18   0 0       0 7   46 35   0.0                   81 55 1 18   0 0       0 7   46 35   0             81
1841996 NV     school 3200300 10   Lyon 320030000555 10605 Silver Stage HS   Regular School No High 09 12 2021   grade_12 54 1 12   2 0       1 3   37 36   0.0                   73 54 1 12   2 0       1 3   37 36   0             73
1841997 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   grade_8 0 1 0   0 0       0 0   1 0   0.0                   1 0 1 0   0 0       0 0   1 0   0             1
1841998 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   grade_9 1 1 1   0 0       0 0   3 0   0.0                   3 1 1 1   0 0       0 0   3 0   0             3
1841999 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   grade_10 1 0 0   1 0       0 2   3 1   0.0                   4 1 0 0   1 0       0 2   3 1   0             4
1842000 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   grade_11 0 0 1   0 0       0 0   1 0   0.0                   1 0 0 1   0 0       0 0   1 0   0             1
1842001 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   grade_12 0 0 2   0 0       0 0   2 0   0.0                   2 0 0 2   0 0       0 0   2 0   0             2
1842002 NV     school 3200300 10   Lyon 320030000860 10907 Lyon Adult Ed   Alternative School No Adult Education AE AE 2021   adult 4 0 0   1 0       0 1   3 3   0.0                   6 4 0 0   1 0       0 1   3 3   0             6
1843935 NV     school 3200300 10   Lyon 320030000174 10201 Dayton ES   Regular School No Elementary PK 06 2021   k_12_total 276 2 109   8 10       1 27   234 199   0.0                   433 276 2 109   8 10       1 27   234 199   0             433
1843936 NV     school 3200300 10   Lyon 320030000179 10202 Yerington ES   Regular School No Elementary PK 04 2021   k_12_total 199 0 178   32 2       0 27   223 215   0.0                   438 199 0 178   32 2       0 27   223 215   0             438
1843937 NV     school 3200300 10   Lyon 320030000175 10203 Fernley ES   Regular School No Elementary PK 04 2021   k_12_total 235 8 107   17 9       6 44   219 207   0.0                   426 235 8 107   17 9       6 44   219 207   0             426
1843938 NV     school 3200300 10   Lyon 320030000299 10205 Silver Stage ES   Regular School No Elementary PK 04 2021   k_12_total 269 6 41   3 2       1 14   185 151   0.0                   336 269 6 41   3 2       1 14   185 151   0             336
1843939 NV     school 3200300 10   Lyon 320030000704 10206 East Valley ES   Regular School No Elementary PK 04 2021   k_12_total 312 6 125   14 5       3 48   244 269   0.0                   513 312 6 125   14 5       3 48   244 269   0             513
1843940 NV     school 3200300 10   Lyon 320030000386 10208 Dayton Intermediate   Regular School No Middle 07 08 2021   k_12_total 298 2 96   6 1       2 26   218 213   0.0                   431 298 2 96   6 1       2 26   218 213   0             431
1843941 NV     school 3200300 10   Lyon 320030000387 10209 Cottonwood ES   Regular School No Elementary PK 04 2021   k_12_total 366 3 149   15 8       2 31   295 279   0.0                   574 366 3 149   15 8       2 31   295 279   0             574
1843942 NV     school 3200300 10   Lyon 320030000450 10210 Sutro ES   Regular School No Elementary PK 06 2021   k_12_total 218 1 126   0 2       3 20   194 176   0.0                   370 218 1 126   0 2       3 20   194 176   0             370
1843943 NV     school 3200300 10   Lyon 320030000746 10211 Riverview ES   Regular School No Elementary PK 06 2021   k_12_total 255 4 90   1 3       4 23   205 175   0.0                   380 255 4 90   1 3       4 23   205 175   0             380
1843944 NV     school 3200300 10   Lyon 320030000312 10302 Yerington Intermediate   Regular School No Middle 05 08 2021   k_12_total 176 1 168   33 1       0 26   191 214   0.0                   405 176 1 168   33 1       0 26   191 214   0             405
1843945 NV     school 3200300 10   Lyon 320030000311 10303 Fernley Intermediate   Regular School No Middle 05 08 2021   k_12_total 372 9 166   21 7       2 43   318 302   0.0                   620 372 9 166   21 7       2 43   318 302   0             620
1843946 NV     school 3200300 10   Lyon 320030000424 10304 Silver Stage MS   Regular School No Middle 05 08 2021   k_12_total 216 2 64   2 1       1 29   167 148   0.0                   315 216 2 64   2 1       1 29   167 148   0             315
1843947 NV     school 3200300 10   Lyon 320030000810 10305 Silverland MS   Regular School No Middle 07 08 2021   k_12_total 394 7 186   28 12       6 39   347 325   0.0                   672 394 7 186   28 12       6 39   347 325   0             672
1843948 NV     school 3200300 10   Lyon 320030000176 10601 Fernley HS   Regular School No High 09 12 2021   k_12_total 768 13 312   52 18       12 34   640 569   0.0                   1209 768 13 312   52 18       12 34   640 569   0             1209
1843949 NV     school 3200300 10   Lyon 320030000178 10602 Smith Valley Combined   Regular School No Other PK 12 2021   k_12_total 177 0 40   2 0       4 3   114 112   0.0                   226 177 0 40   2 0       4 3   114 112   0             226
1843950 NV     school 3200300 10   Lyon 320030000180 10603 Yerington HS   Regular School No High 09 12 2021   k_12_total 158 0 154   55 2       2 17   184 204   0.0                   388 158 0 154   55 2       2 17   184 204   0             388
1843951 NV     school 3200300 10   Lyon 320030000310 10604 Dayton HS   Regular School No High 09 12 2021   k_12_total 446 5 190   10 8       6 16   357 324   0.0                   681 446 5 190   10 8       6 16   357 324   0             681
1843952 NV     school 3200300 10   Lyon 320030000555 10605 Silver Stage HS   Regular School No High 09 12 2021   k_12_total 227 3 58   4 2       4 25   176 147   0.0                   323 227 3 58   4 2       4 25   176 147   0             323
1843953 NV     school 3200300 10   Lyon 320030000768 10902 Eagle Ridge HS   Alternative School No High 07 12 2021   k_12_total 2 2 4   1 0       0 2   10 1   0.0                   11 2 2 4   1 0       0 2   10 1   0             11
1843434 NV     school 3200001 101   Nevada Rise Academy 320000100917 101101 NV Rise CS   Regular School Yes Elementary KG 03 2021   grade_1 7 24 57   0 2       4 8   46 56   0.0                   102 7 24 57   0 2       4 8   46 56   0             102
1843435 NV     school 3200001 101   Nevada Rise Academy 320000100917 101101 NV Rise CS   Regular School Yes Elementary KG 03 2021   grade_2 7 20 40   1 1       1 8   41 37   0.0                   78 7 20 40   1 1       1 8   41 37   0             78
1843436 NV     school 3200001 101   Nevada Rise Academy 320000100917 101101 NV Rise CS   Regular School Yes Elementary KG 03 2021   grade_3 8 19 24   1 0       1 6   28 31   0.0                   59 8 19 24   1 0       1 6   28 31   0             59
1843437 NV     school 3200001 101   Nevada Rise Academy 320000100917 101101 NV Rise CS   Regular School Yes Elementary KG 03 2021   kindergarten 9 21 44   0 3       2 12   45 46   0.0                   91 9 21 44   0 3       2 12   45 46   0             91
1844181 NV     school 3200001 101   Nevada Rise Academy 320000100917 101101 NV Rise CS   Regular School Yes Elementary KG 03 2021   k_12_total 31 84 165   2 6       8 34   160 170   0.0                   330 31 84 165   2 6       8 34   160 170   0             330
1843438 NV     school 3200001 102   Nevada Prep 320000100929 102100 NV Prep CS   Regular School Yes Other 04 12 2021   grade_4 2 2 14   0 0       0 0   11 7   0.0                   18 2 2 14   0 0       0 0   11 7   0             18
1843439 NV     school 3200001 102   Nevada Prep 320000100929 102100 NV Prep CS   Regular School Yes Other 04 12 2021   grade_5 3 8 22   0 1       1 0   15 20   0.0                   35 3 8 22   0 1       1 0   15 20   0             35
1843440 NV     school 3200001 102   Nevada Prep 320000100929 102100 NV Prep CS   Regular School Yes Other 04 12 2021   grade_6 2 4 32   0 2       0 0   20 20   0.0                   40 2 4 32   0 2       0 0   20 20   0             40
1843441 NV     school 3200001 102   Nevada Prep 320000100929 102100 NV Prep CS   Regular School Yes Other 04 12 2021   grade_7 7 15 41   0 0       0 0   26 37   0.0                   63 7 15 41   0 0       0 0   26 37   0             63
1843442 NV     school 3200001 102   Nevada Prep 320000100929 102100 NV Prep CS   Regular School Yes Other 04 12 2021   grade_8 8 9 71   0 0       1 1   39 51   0.0                   90 8 9 71   0 0       1 1   39 51   0             90
1844182 NV     school 3200001 102   Nevada Prep 320000100929 102100 NV Prep CS   Regular School Yes Other 04 12 2021   k_12_total 22 38 180   0 3       2 1   111 135   0.0                   246 22 38 180   0 3       2 1   111 135   0             246
1843443 NV     school 3200001 103   Nevada State High School III 320000100928 103101 NSHS III Sunrise   Regular School Yes High 11 12 2021   grade_11 6 8 16   1 0       0 5   11 25   0.0                   36 6 8 16   1 0       0 5   11 25   0             36
1843444 NV     school 3200001 103   Nevada State High School III 320000100928 103101 NSHS III Sunrise   Regular School Yes High 11 12 2021   grade_12 6 12 37   0 1       1 4   22 39   0.0                   61 6 12 37   0 1       1 4   22 39   0             61
1844183 NV     school 3200001 103   Nevada State High School III 320000100928 103101 NSHS III Sunrise   Regular School Yes High 11 12 2021   k_12_total 12 20 53   1 1       1 9   33 64   0.0                   97 12 20 53   1 1       1 9   33 64   0             97
1843445 NV     school 3200001 104   Nevada State High School II 320000100924 104101 NSHS II Meadowood   Regular School Yes High 11 12 2021   grade_11 20 0 4   1 2       1 5   12 21   0.0                   33 20 0 4   1 2       1 5   12 21   0             33
1843446 NV     school 3200001 104   Nevada State High School II 320000100924 104101 NSHS II Meadowood   Regular School Yes High 11 12 2021   grade_12 21 0 4   0 5       1 4   10 25   0.0                   35 21 0 4   0 5       1 4   10 25   0             35
1844184 NV     school 3200001 104   Nevada State High School II 320000100924 104101 NSHS II Meadowood   Regular School Yes High 11 12 2021   k_12_total 41 0 8   1 7       2 9   22 46   0.0                   68 41 0 8   1 7       2 9   22 46   0             68
1843447 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_1 42 20 58   1 6       2 20   61 88   0.0                   149 42 20 58   1 6       2 20   61 88   0             149
1843448 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_2 23 10 36   1 4       2 11   41 46   0.0                   87 23 10 36   1 4       2 11   41 46   0             87
1843449 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_3 26 10 34   0 4       2 6   50 32   0.0                   82 26 10 34   0 4       2 6   50 32   0             82
1843450 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_4 26 13 37   1 7       0 6   42 48   0.0                   90 26 13 37   1 7       0 6   42 48   0             90
1843451 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_5 33 8 38   1 7       0 6   46 47   0.0                   93 33 8 38   1 7       0 6   46 47   0             93
1843452 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_6 31 6 31   3 7       4 9   43 48   0.0                   91 31 6 31   3 7       4 9   43 48   0             91
1843453 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_7 11 4 11   0 1       0 3   19 11   0.0                   30 11 4 11   0 1       0 3   19 11   0             30
1843454 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   grade_8 6 6 12   0 1       0 3   16 12   0.0                   28 6 6 12   0 1       0 3   16 12   0             28
1843455 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   kindergarten 63 10 65   0 11       4 16   84 85   0.0                   169 63 10 65   0 11       4 16   84 85   0             169
1844185 NV     school 3200001 105   Signature Preparatory 320000100938 105101 Signature Prep CS   Regular School Yes Elementary KG 08 2021   k_12_total 261 87 322   7 48       14 80   402 417   0.0                   819 261 87 322   7 48       14 80   402 417   0             819
1843456 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   grade_1 67 0 20   5 2       1 8   55 48   0.0                   103 67 0 20   5 2       1 8   55 48   0             103
1843457 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   grade_2 59 2 21   2 3       1 7   55 40   0.0                   95 59 2 21   2 3       1 7   55 40   0             95
1843458 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   grade_3 75 0 16   3 3       0 6   45 58   0.0                   103 75 0 16   3 3       0 6   45 58   0             103
1843459 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   grade_4 54 2 23   5 1       0 5   51 39   0.0                   90 54 2 23   5 1       0 5   51 39   0             90
1843460 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   grade_5 47 2 18   3 0       1 9   42 38   0.0                   80 47 2 18   3 0       1 9   42 38   0             80
1843461 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   grade_6 45 1 15   0 0       0 2   39 24   0.0                   63 45 1 15   0 0       0 2   39 24   0             63
1843462 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   grade_7 37 0 9   0 1       0 6   27 26   0.0                   53 37 0 9   0 1       0 6   27 26   0             53
1843463 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   kindergarten 66 4 20   2 1       0 5   46 52   0.0                   98 66 4 20   2 1       0 5   46 52   0             98
1844186 NV     school 3200001 106   Pinecrest Academy of Northern Nevada 320000100953 106101 Pinecrest Northern NV   Regular School Yes Elementary KG 07 2021   k_12_total 450 11 142   20 11       3 48   360 325   0.0                   685 450 11 142   20 11       3 48   360 325   0             685
1843464 NV     school 3200001 107   Explore Academy 320000100952 107101 Explore ACAD   Regular School Yes Middle 06 09 2021   grade_6 28 12 11   0 2       0 0   24 29   0.0                   53 28 12 11   0 2       0 0   24 29   0             53
1843465 NV     school 3200001 107   Explore Academy 320000100952 107101 Explore ACAD   Regular School Yes Middle 06 09 2021   grade_7 14 6 10   0 0       1 1   14 18   0.0                   32 14 6 10   0 0       1 1   14 18   0             32
1843466 NV     school 3200001 107   Explore Academy 320000100952 107101 Explore ACAD   Regular School Yes Middle 06 09 2021   grade_8 12 8 8   0 1       2 0   17 14   0.0                   31 12 8 8   0 1       2 0   17 14   0             31
1843467 NV     school 3200001 107   Explore Academy 320000100952 107101 Explore ACAD   Regular School Yes Middle 06 09 2021   grade_9 14 1 4   0 0       1 0   15 5   0.0                   20 14 1 4   0 0       1 0   15 5   0             20
1844187 NV     school 3200001 107   Explore Academy 320000100952 107101 Explore ACAD   Regular School Yes Middle 06 09 2021   k_12_total 68 27 33   0 3       4 1   70 66   0.0                   136 68 27 33   0 3       4 1   70 66   0             136
1843468 NV     school 3200001 108   Girls Athletic Leadership School 320000100954 108101 GALS   Regular School Yes Middle 06 07 2021   grade_6 6 11 40   0 0       1 3   0 61   0.0                   61 6 11 40   0 0       1 3   0 61   0             61
1843469 NV     school 3200001 108   Girls Athletic Leadership School 320000100954 108101 GALS   Regular School Yes Middle 06 07 2021   grade_7 0 7 23   0 4       1 0   0 35   0.0                   35 0 7 23   0 4       1 0   0 35   0             35
1844188 NV     school 3200001 108   Girls Athletic Leadership School 320000100954 108101 GALS   Regular School Yes Middle 06 07 2021   k_12_total 6 18 63   0 4       2 3   0 96   0.0                   96 6 18 63   0 4       2 3   0 96   0             96
1842003 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   grade_1 25 0 10   0 0       1 4   18 22   0.0                   40 25 0 10   0 0       1 4   18 22   0             40
1842004 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   grade_2 22 1 5   1 0       0 4   12 21   0.0                   33 22 1 5   1 0       0 4   12 21   0             33
1842005 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   grade_3 39 0 8   1 0       0 3   30 21   0.0                   51 39 0 8   1 0       0 3   30 21   0             51
1842006 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   grade_4 31 1 6   0 0       0 2   18 22   0.0                   40 31 1 6   0 0       0 2   18 22   0             40
1842007 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   grade_5 24 1 8   2 0       0 5   20 20   0.0                   40 24 1 8   2 0       0 5   20 20   0             40
1842008 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   grade_6 25 0 4   1 0       0 2   16 16   0.0                   32 25 0 4   1 0       0 2   16 16   0             32
1842009 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   kindergarten 22 2 6   3 1       0 1   19 16   0.0                   35 22 2 6   3 1       0 1   19 16   0             35
1842010 NV     school 3200330 11   Mineral 320033000811 11201 Hawthorne ES   Regular School No Elementary PK 06 2021   pre_kindergarten 23 0 5   0 0       0 3   15 16   0.0                   31 23 0 5   0 0       0 3   15 16   0             31
1842011 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2021   grade_1 0 0 2   5 0       0 0   6 1   0.0                   7 0 0 2   5 0       0 0   6 1   0             7
1842012 NV     school 3200330 11   Mineral 320033000184 11202 Schurz ES   Regular School No Elementary PK 06 2021   grade_2 0 0 2   10 0       0 1   6 7   0.0                   13 0 0 2   10 0       0 1   6 7   0             13

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