Data source: Big Local News · About: Big Local

4,796 rows where state = "ID" and year = 2019 sorted by school_nces_id

View and edit SQL

grade

year

  • 2019 · 4,696
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
1306309 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   k_12_total 166 2 4   0 0     0   4   110 66             63         176 166 2 4   0 0     0   4   110 66         63       176
1306310 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200621 410 NORTHSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   kindergarten 18 1 0   0 0     0   1   12 8             *         20 18 1 0   0 0     0   1   12 8                 20
1306313 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_10 23 0 0   0 0     0   0   13 10             *         23 23 0 0   0 0     0   0   13 10                 23
1306314 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_11 21 0 0   0 1     0   0   11 11             *         22 21 0 0   0 1     0   0   11 11                 22
1306315 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_12 41 0 0   2 0     0   0   19 24             *         43 41 0 0   2 0     0   0   19 24                 43
1306316 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12.0 2019   grade_9 8 0 1   0 0     0   2   7 4             *         11 8 0 1   0 0     0   2   7 4                 11
1306317 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200691 1045 LAKE PEND OREILLE HIGH SCHOOL   Alternative School No High 09 12.0 2019   k_12_total 93 0 1   2 1     0   2   50 49             60         99 93 0 1   2 1     0   2   50 49         60       99
1306240 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 216 0 12   2 2     0   15   122 125             *         247 216 0 12   2 2     0   15   122 125                 247
1306241 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_8 219 1 14   4 1     0   18   137 120             *         257 219 1 14   4 1     0   18   137 120                 257
1306242 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   k_12_total 435 1 26   6 3     0   33   259 245             178         504 435 1 26   6 3     0   33   259 245         178       504
1309154 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_1 21 0 3   0 1     0   3   15 13             *         28 21 0 3   0 1     0   3   15 13                 28
1309155 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_10 31 0 4   0 0     0   0   13 22             14         35 31 0 4   0 0     0   0   13 22         14       35
1309156 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_11 24 3 2   0 0     0   2   17 14             12         31 24 3 2   0 0     0   2   17 14         12       31
1309157 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_12 26 2 3   0 3     0   1   18 17             7         35 26 2 3   0 3     0   1   18 17         7       35
1309158 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_2 24 0 3   0 1     0   1   19 10             10         29 24 0 3   0 1     0   1   19 10         10       29
1309159 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_3 24 0 4   0 1     0   1   20 10             17         30 24 0 4   0 1     0   1   20 10         17       30
1309160 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_4 26 0 1   0 0     1   1   12 17             9         29 26 0 1   0 0     1   1   12 17         9       29
1309161 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_5 27 1 3   0 1     0   1   21 12             11         33 27 1 3   0 1     0   1   21 12         11       33
1309162 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_6 26 0 2   0 2     0   1   12 19             16         31 26 0 2   0 2     0   1   12 19         16       31
1309163 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_7 28 0 2   0 0     0   1   15 16             15         31 28 0 2   0 0     0   1   15 16         15       31
1309164 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_8 28 0 2   0 0     0   0   16 14             12         30 28 0 2   0 0     0   0   16 14         12       30
1309165 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   grade_9 35 0 2   0 1     0   2   22 18             15         40 35 0 2   0 1     0   2   22 18         15       40
1309166 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   k_12_total 342 6 32   0 10     1   15   210 196             146         406 342 6 32   0 10     1   15   210 196         146       406
1309167 ID     school 1600003 451   VICTORY CHARTER SCHOOL, INC. 160000300858 868 VICTORY CHARTER SCHOOL   Regular School Yes Other PK 12.0 2019   kindergarten 22 0 1   0 0     0   1   10 14             *         24 22 0 1   0 0     0   1   10 14                 24
1309168 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_1 60 0 6   1 0     0   3   37 33             43         70 60 0 6   1 0     0   3   37 33         43       70
1309169 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_10 153 2 22   1 0     0   5   84 99             *         183 153 2 22   1 0     0   5   84 99                 183
1309170 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_11 127 2 19   2 2     2   0   50 104             67         154 127 2 19   2 2     2   0   50 104         67       154
1309171 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_12 109 3 19   1 3     0   1   55 81             60         136 109 3 19   1 3     0   1   55 81         60       136
1309172 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_2 51 0 9   1 1     0   2   32 32             41         64 51 0 9   1 1     0   2   32 32         41       64
1309173 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_3 72 0 11   0 0     0   2   45 40             58         85 72 0 11   0 0     0   2   45 40         58       85
1309174 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_4 66 0 16   1 0     0   2   47 38             50         85 66 0 16   1 0     0   2   47 38         50       85
1309175 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_5 99 0 6   1 0     1   9   55 61             75         116 99 0 6   1 0     1   9   55 61         75       116
1309176 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_6 121 2 15   3 1     0   5   74 73             83         147 121 2 15   3 1     0   5   74 73         83       147
1309177 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_7 157 0 24   0 1     0   6   87 101             110         188 157 0 24   0 1     0   6   87 101         110       188
1309178 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_8 207 3 28   1 2     1   5   109 138             143         247 207 3 28   1 2     1   5   109 138         143       247
1309179 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   grade_9 109 2 15   1 0     0   5   50 82             *         132 109 2 15   1 0     0   5   50 82                 132
1309180 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   k_12_total 1390 18 205   13 10     4   51   771 920             931         1691 1390 18 205   13 10     4   51   771 920         931       1691
1309181 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12.0 2019   kindergarten 59 4 15   0 0     0   6   46 38             49         84 59 4 15   0 0     0   6   46 38         49       84
1309182 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000401035 1302 INSIGHT SCHOOL OF IDAHO   Alternative School Yes High 08 12.0 2019   grade_10 32 0 5   1 0     0   1   20 19             *         39 32 0 5   1 0     0   1   20 19                 39
1309183 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000401035 1302 INSIGHT SCHOOL OF IDAHO   Alternative School Yes High 08 12.0 2019   grade_11 33 1 7   0 0     0   0   19 22             23         41 33 1 7   0 0     0   0   19 22         23       41
1309184 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000401035 1302 INSIGHT SCHOOL OF IDAHO   Alternative School Yes High 08 12.0 2019   grade_12 55 1 6   2 1     1   0   29 37             39         66 55 1 6   2 1     1   0   29 37         39       66
1309185 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000401035 1302 INSIGHT SCHOOL OF IDAHO   Alternative School Yes High 08 12.0 2019   grade_9 9 0 1   0 0     0   0   4 6             *         10 9 0 1   0 0     0   0   4 6                 10
1309186 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000401035 1302 INSIGHT SCHOOL OF IDAHO   Alternative School Yes High 08 12.0 2019   k_12_total 129 2 19   3 1     1   1   72 84             90         156 129 2 19   3 1     1   1   72 84         90       156
1309187 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000500862 870 RICHARD MCKENNA CHARTER SCHOOL - ONLINE   Regular School Yes High 09 12.0 2019   grade_10 10 0 2   0 0     1   3   6 10             *         16 10 0 2   0 0     1   3   6 10                 16
1309188 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000500862 870 RICHARD MCKENNA CHARTER SCHOOL - ONLINE   Regular School Yes High 09 12.0 2019   grade_11 34 0 4   0 1     0   3   21 21             *         42 34 0 4   0 1     0   3   21 21                 42
1309189 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000500862 870 RICHARD MCKENNA CHARTER SCHOOL - ONLINE   Regular School Yes High 09 12.0 2019   grade_12 33 1 7   2 0     0   7   22 28             *         50 33 1 7   2 0     0   7   22 28                 50
1309190 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000500862 870 RICHARD MCKENNA CHARTER SCHOOL - ONLINE   Regular School Yes High 09 12.0 2019   grade_9 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1309191 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000500862 870 RICHARD MCKENNA CHARTER SCHOOL - ONLINE   Regular School Yes High 09 12.0 2019   k_12_total 87 1 13   2 1     1   13   54 64             34         118 87 1 13   2 1     1   13   54 64         34       118
1309192 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501056 871 RICHARD MCKENNA CHARTER SCHOOL - ONLINE ALTERNATIVE   Alternative School Yes High 09 12.0 2019   grade_10 32 0 2   0 0     0   1   19 16             *         35 32 0 2   0 0     0   1   19 16                 35
1309193 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501056 871 RICHARD MCKENNA CHARTER SCHOOL - ONLINE ALTERNATIVE   Alternative School Yes High 09 12.0 2019   grade_11 38 0 13   1 0     0   3   20 35             16         55 38 0 13   1 0     0   3   20 35         16       55
1309194 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501056 871 RICHARD MCKENNA CHARTER SCHOOL - ONLINE ALTERNATIVE   Alternative School Yes High 09 12.0 2019   grade_12 96 1 20   3 1     0   7   52 76             41         128 96 1 20   3 1     0   7   52 76         41       128
1309195 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501056 871 RICHARD MCKENNA CHARTER SCHOOL - ONLINE ALTERNATIVE   Alternative School Yes High 09 12.0 2019   grade_9 6 0 0   0 0     0   0   2 4             *         6 6 0 0   0 0     0   0   2 4                 6
1309196 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501056 871 RICHARD MCKENNA CHARTER SCHOOL - ONLINE ALTERNATIVE   Alternative School Yes High 09 12.0 2019   k_12_total 172 1 35   4 1     0   11   93 131             70         224 172 1 35   4 1     0   11   93 131         70       224
1309197 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 3.0 2019   grade_1 18 1 5   0 0     0   0   12 12             8         24 18 1 5   0 0     0   0   12 12         8       24
1309198 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 3.0 2019   grade_2 22 0 2   0 0     0   0   18 6             5         24 22 0 2   0 0     0   0   18 6         5       24
1309199 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 3.0 2019   grade_3 20 0 4   0 0     0   0   13 11             5         24 20 0 4   0 0     0   0   13 11         5       24
1309200 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 3.0 2019   k_12_total 80 1 15   0 0     0   0   57 39             24         96 80 1 15   0 0     0   0   57 39         24       96
1309201 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 3.0 2019   kindergarten 20 0 4   0 0     0   0   14 10             6         24 20 0 4   0 0     0   0   14 10         6       24
1309202 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501108 1399 RICHARD MCKENNA CHARTER SCHOOL - ONSITE   Regular School Yes High 09 12.0 2019   grade_10 5 0 2   1 0     0   0   5 3             *         8 5 0 2   1 0     0   0   5 3                 8
1309203 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501108 1399 RICHARD MCKENNA CHARTER SCHOOL - ONSITE   Regular School Yes High 09 12.0 2019   grade_11 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10
1309204 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501108 1399 RICHARD MCKENNA CHARTER SCHOOL - ONSITE   Regular School Yes High 09 12.0 2019   grade_12 6 0 1   0 1     0   0   2 6             *         8 6 0 1   0 1     0   0   2 6                 8
1309205 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501108 1399 RICHARD MCKENNA CHARTER SCHOOL - ONSITE   Regular School Yes High 09 12.0 2019   grade_9 6 0 1   0 0     0   0   6 1             *         7 6 0 1   0 0     0   0   6 1                 7
1309206 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501108 1399 RICHARD MCKENNA CHARTER SCHOOL - ONSITE   Regular School Yes High 09 12.0 2019   k_12_total 26 0 5   1 1     0   0   19 14             11         33 26 0 5   1 1     0   0   19 14         11       33
1309207 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_1 24 0 0   0 0     0   2   14 12             9         26 24 0 0   0 0     0   2   14 12         9       26
1309208 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_2 21 0 3   0 0     0   1   18 7             11         25 21 0 3   0 0     0   1   18 7         11       25
1309209 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_3 23 0 2   0 1     0   4   12 18             13         30 23 0 2   0 1     0   4   12 18         13       30
1309210 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_4 24 0 3   0 0     0   5   19 13             9         32 24 0 3   0 0     0   5   19 13         9       32
1309211 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_5 27 0 2   0 0     0   3   12 20             10         32 27 0 2   0 0     0   3   12 20         10       32
1309212 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_6 24 0 0   0 2     0   1   15 12             6         27 24 0 0   0 2     0   1   15 12         6       27
1309213 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_7 21 0 2   2 0     0   2   17 10             9         27 21 0 2   2 0     0   2   17 10         9       27
1309214 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   grade_8 23 0 2   0 0     0   1   13 13             5         26 23 0 2   0 0     0   1   13 13         5       26
1309215 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   k_12_total 205 0 17   2 3     0   22   136 113             80         249 205 0 17   2 3     0   22   136 113         80       249
1309216 ID     school 1600006 454   ROLLING HILLS PUBLIC CHARTER SCHOOL, INC. 160000600863 574 ROLLING HILLS PUBLIC CHARTER   Regular School Yes Elementary KG 8.0 2019   kindergarten 18 0 3   0 0     0   3   16 8             8         24 18 0 3   0 0     0   3   16 8         8       24
1309217 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_1 73 1 10   0 4     0   7   53 42             21         95 73 1 10   0 4     0   7   53 42         21       95
1309218 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_10 55 1 4   0 0     0   1   28 33             13         61 55 1 4   0 0     0   1   28 33         13       61
1309219 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_11 31 1 5   1 2     0   0   17 23             *         40 31 1 5   1 2     0   0   17 23                 40
1309220 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_12 40 0 3   0 1     0   2   25 21             *         46 40 0 3   0 1     0   2   25 21                 46
1309221 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_2 70 2 15   0 5     0   3   52 43             13         95 70 2 15   0 5     0   3   52 43         13       95
1309222 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_3 83 0 7   0 3     0   3   46 50             17         96 83 0 7   0 3     0   3   46 50         17       96
1309223 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_4 80 3 10   0 3     1   3   45 55             12         100 80 3 10   0 3     1   3   45 55         12       100
1309224 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_5 92 2 9   0 3     0   4   52 58             16         110 92 2 9   0 3     0   4   52 58         16       110
1309225 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_6 76 2 9   0 2     0   1   42 48             20         90 76 2 9   0 2     0   1   42 48         20       90
1309226 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_7 77 0 8   0 3     0   3   33 58             15         91 77 0 8   0 3     0   3   33 58         15       91
1309227 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_8 75 0 10   0 3     0   6   47 47             17         94 75 0 10   0 3     0   6   47 47         17       94
1309228 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_9 60 0 5   0 1     0   3   40 29             7         69 60 0 5   0 1     0   3   40 29         7       69
1309229 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   k_12_total 894 13 99   1 34     2   37   527 553             169         1080 894 13 99   1 34     2   37   527 553         169       1080
1309230 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   kindergarten 82 1 4   0 4     1   1   47 46             12         93 82 1 4   0 4     1   1   47 46         12       93
1309231 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_1 28 0 1   0 0     0   0   15 14             8         29 28 0 1   0 0     0   0   15 14         8       29
1309232 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_2 25 0 3   0 0     0   1   14 15             *         29 25 0 3   0 0     0   1   14 15                 29
1309233 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_3 25 0 4   0 0     0   0   16 13             6         29 25 0 4   0 0     0   0   16 13         6       29
1309234 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_4 30 0 1   0 0     0   2   18 15             5         33 30 0 1   0 0     0   2   18 15         5       33
1309235 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_5 25 1 5   0 1     0   1   20 13             10         33 25 1 5   0 1     0   1   20 13         10       33
1309236 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_6 28 0 2   0 0     0   3   18 15             7         33 28 0 2   0 0     0   3   18 15         7       33
1309237 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_7 28 0 2   0 0     0   0   16 14             *         30 28 0 2   0 0     0   0   16 14                 30
1309238 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   grade_8 29 0 3   0 1     0   0   19 14             7         33 29 0 3   0 1     0   0   19 14         7       33
1309239 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   k_12_total 239 2 21   0 4     0   7   151 122             48         273 239 2 21   0 4     0   7   151 122         48       273
1309240 ID     school 1600008 456   FALCON RIDGE PUBLIC CHARTER SCHOOL, INC. 160000800865 576 FALCON RIDGE PUBLIC CHARTER   Regular School Yes Elementary PK 8.0 2019   kindergarten 21 1 0   0 2     0   0   15 9             *         24 21 1 0   0 2     0   0   15 9                 24
1308131 ID     school 1600009 287   TROY SCHOOL DISTRICT 160000900581 766 TROY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_1 18 0 1   0 0     0   0   12 7             6         19 18 0 1   0 0     0   0   12 7         6       19
1308132 ID     school 1600009 287   TROY SCHOOL DISTRICT 160000900581 766 TROY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_2 14 0 3   0 0     0   0   7 10             *         17 14 0 3   0 0     0   0   7 10                 17
1308133 ID     school 1600009 287   TROY SCHOOL DISTRICT 160000900581 766 TROY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2019   grade_3 22 0 0   0 0     0   0   13 9             10         22 22 0 0   0 0     0   0   13 9         10       22

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