Data source: Big Local News · About: Big Local

14,695 rows where state = "NV" sorted by ccd_school_low_grade

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
1878601 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_1   1.0 1.0                   2.0                         2   1 1                   2                   2
1878602 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_3 1.0   1.0                   2.0                         2 1   1                   2                   2
1878603 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_4     2.0               1.0   3.0                         3     2               1   3                   3
1878604 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_5 2.0 1.0 2.0                   5.0                         5 2 1 2                   5                   5
1878605 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_6 2.0                       2.0                         2 2                       2                   2
1878606 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_7 1.0                         1.0                       1 1                         1                 1
1878607 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_8 3.0                   1.0   3.0 1.0                       4 3                   1   3 1                 4
1878608 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_9 2.0   2.0                   1.0 3.0                       4 2   2                   1 3                 4
1878609 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_10 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1878610 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_11 3.0 1.0                 1.0   3.0 2.0                       5 3 1                 1   3 2                 5
1878611 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   grade_12 7.0   3.0     1.0             8.0 3.0                       11 7   3     1             8 3                 11
1879747 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 01 12 2019   k_12_total 22.0 3.0 12.0   0.0 1.0       0.0 3.0   30.0 11.0                       41 22 3 12   0 1       0 3   30 11                 41
1706759 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2020   grade_2 158.0 9.0 73.0   16.0 3.0       2.0 10.0   141.0 130.0                       271 158 9 73   16 3       2 10   141 130                 271
1706760 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2020   grade_3 144.0 1.0 56.0   16.0 3.0       4.0 22.0   128.0 118.0                       246 144 1 56   16 3       4 22   128 118                 246
1710391 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_2 1.0 1.0 1.0                   3.0                         3 1 1 1                   3                   3
1710392 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_3 1.0                       1.0                         1 1                       1                   1
1710393 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_4 1.0   1.0               1.0   3.0                         3 1   1               1   3                   3
1710394 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_5     2.0               1.0   3.0                         3     2               1   3                   3
1710395 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_6 2.0 1.0 3.0                   6.0                         6 2 1 3                   6                   6
1710396 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_7 1.0                       1.0                         1 1                       1                   1
1710397 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_8 2.0 1.0 1.0                   3.0 1.0                       4 2 1 1                   3 1                 4
1710398 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_9 4.0   1.0               1.0   5.0 1.0                       6 4   1               1   5 1                 6
1710399 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_10 2.0   2.0                   3.0 1.0                       4 2   2                   3 1                 4
1710400 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_11 2.0                         2.0                       2 2                         2                 2
1710401 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   grade_12 3.0         1.0         1.0   4.0 1.0                       5 3         1         1   4 1                 5
1710955 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2020   k_12_total 302.0 10.0 129.0   32.0 6.0       6.0 32.0 0.0 269.0 248.0                       517 302 10 129   32 6       6 32 0 269 248                 517
1711578 NV     school 3200480 16   Washoe 320048000766 16917 Turning Point   Alternative School No Other 02 12 2020   k_12_total 19.0 3.0 11.0   0.0 1.0       0.0 4.0 0.0 32.0 6.0                       38 19 3 11   0 1       0 4 0 32 6                 38
1839257 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2021   grade_2 136 2 54   8 3       3 10   110 106   0.0                   216 136 2 54   8 3       3 10   110 106   0             216
1839258 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2021   grade_3 142 7 66   14 2       2 8   133 108   0.0                   241 142 7 66   14 2       2 8   133 108   0             241
1842897 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_3 1 1 1   0 0       0 0   3 0   0.0                   3 1 1 1   0 0       0 0   3 0   0             3
1842898 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_4 0 0 3   0 0       0 0   3 0   0.0                   3 0 0 3   0 0       0 0   3 0   0             3
1842899 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_5 2 0 1   0 0       0 1   4 0   0.0                   4 2 0 1   0 0       0 1   4 0   0             4
1842900 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_6 2 1 2   0 0       0 1   6 0   0.0                   6 2 1 2   0 0       0 1   6 0   0             6
1842901 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_7 1 0 1   0 0       0 0   2 0   0.0                   2 1 0 1   0 0       0 0   2 0   0             2
1842902 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_8 1 0 0   0 0       0 0   1 0   0.0                   1 1 0 0   0 0       0 0   1 0   0             1
1842903 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_9 4 0 0   0 0       0 0   1 3   0.0                   4 4 0 0   0 0       0 0   1 3   0             4
1842904 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_10 5 0 0   0 0       0 1   5 1   0.0                   6 5 0 0   0 0       0 1   5 1   0             6
1842905 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_11 4 0 2   0 0       0 0   4 2   0.0                   6 4 0 2   0 0       0 0   4 2   0             6
1842906 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   grade_12 5 0 1   0 0       0 0   4 2   0.0                   6 5 0 1   0 0       0 0   4 2   0             6
1843481 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2021   k_12_total 278 9 120   22 5       5 18   243 214   0.0                   457 278 9 120   22 5       5 18   243 214   0             457
1844110 NV     school 3200480 16   Washoe County 320048000766 16917 Turning Point   Alternative School No Other 02 12 2021   k_12_total 25 2 11   0 0       0 3   33 8   0.0                   41 25 2 11   0 0       0 3   33 8   0             41
1874955 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2019   grade_2 147.0 3.0 62.0   18.0 2.0       4.0 20.0   140.0 116.0                       256 147 3 62   18 2       4 20   140 116                 256
1874956 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2019   grade_3 145.0 8.0 49.0   15.0 5.0       1.0 12.0   129.0 106.0                       235 145 8 49   15 5       1 12   129 106                 235
1874959 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 02 06 2019   grade_3 2.0                       2.0                         2 2                       2                   2
1874960 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 02 06 2019   grade_4 151.0 7.0 66.0   11.0 3.0       1.0 16.0   138.0 117.0                       255 151 7 66   11 3       1 16   138 117                 255
1874961 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 02 06 2019   grade_5 164.0 9.0 62.0   21.0 1.0       2.0 14.0   152.0 121.0                       273 164 9 62   21 1       2 14   152 121                 273
1874962 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 02 06 2019   grade_6 1.0                         1.0                       1 1                         1                 1
1879128 NV     school 3200030 1   Churchill 320003000004 1205 Best ES   Regular School No Elementary 02 03 2019   k_12_total 292.0 11.0 111.0   33.0 7.0       5.0 32.0   269.0 222.0                       491 292 11 111   33 7       5 32   269 222                 491
1879130 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 02 06 2019   k_12_total 318.0 16.0 128.0   32.0 4.0       3.0 30.0   292.0 239.0                       531 318 16 128   32 4       3 30   292 239                 531
1706764 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 03 06 2020   grade_3     1.0                     1.0                       1     1                     1                 1
1706765 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 03 06 2020   grade_4 152.0 11.0 46.0   12.0 6.0       1.0 12.0   121.0 119.0                       240 152 11 46   12 6       1 12   121 119                 240
1706766 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 03 06 2020   grade_5 155.0 9.0 65.0   14.0 5.0         16.0   143.0 121.0                       264 155 9 65   14 5         16   143 121                 264
1706767 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 03 06 2020   grade_6 1.0   1.0                   2.0                         2 1   1                   2                   2
1708950 NV     school 3200060 2   Clark 320006000807 2939 Juvenile Det ES   Alternative School No Elementary 03 05 2020   grade_5   1.0                     1.0                         1   1                     1                   1
1709631 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2020   grade_3 5.0   1.0                   5.0 1.0                       6 5   1                   5 1                 6
1709632 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2020   grade_4 1.0 1.0 1.0                   2.0 1.0                       3 1 1 1                   2 1                 3
1709633 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2020   grade_5 1.0   3.0   1.0               2.0 3.0                       5 1   3   1               2 3                 5
1710423 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2020   grade_3 2.0   3.0                   3.0 2.0                       5 2   3                   3 2                 5
1710424 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2020   grade_4 4.0   2.0                   5.0 1.0                       6 4   2                   5 1                 6
1710425 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2020   grade_5 2.0   1.0                   1.0 2.0                       3 2   1                   1 2                 3
1710957 NV     school 3200030 1   Churchill 320003000431 1207 Numa   Regular School No Elementary 03 06 2020   k_12_total 308.0 20.0 113.0   26.0 11.0       1.0 28.0 0.0 266.0 241.0                       507 308 20 113   26 11       1 28 0 266 241                 507
1711324 NV     school 3200060 2   Clark 320006000807 2939 Juvenile Det ES   Alternative School No Elementary 03 05 2020   k_12_total 0.0 1.0 0.0   0.0 0.0       0.0 0.0 0.0 1.0 0.0                       1 0 1 0   0 0       0 0 0 1 0                 1
1711453 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2020   k_12_total 7.0 1.0 5.0   1.0 0.0       0.0 0.0 0.0 9.0 5.0                       14 7 1 5   1 0       0 0 0 9 5                 14
1711582 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2020   k_12_total 8.0 0.0 6.0   0.0 0.0       0.0 0.0 0.0 9.0 5.0                       14 8 0 6   0 0       0 0 0 9 5                 14
1839261 NV     school 3200030 1   Churchill 320003000431 1207 Numa ES   Regular School No Elementary 03 06 2021   grade_3 1 0 2   0 0       0 0   1 2   0.0                   3 1 0 2   0 0       0 0   1 2   0             3
1839262 NV     school 3200030 1   Churchill 320003000431 1207 Numa ES   Regular School No Elementary 03 06 2021   grade_4 144 2 55   18 2       3 24   129 119   0.0                   248 144 2 55   18 2       3 24   129 119   0             248
1839263 NV     school 3200030 1   Churchill 320003000431 1207 Numa ES   Regular School No Elementary 03 06 2021   grade_5 151 4 47   10 5       1 13   115 116   0.0                   231 151 4 47   10 5       1 13   115 116   0             231
1842145 NV     school 3200360 12   Nye 320036000852 12609 Pathways ES   Alternative School No Elementary 03 05 2021   grade_3 1 0 0   0 0       0 0   1 0   0.0                   1 1 0 0   0 0       0 0   1 0   0             1
1842146 NV     school 3200360 12   Nye 320036000852 12609 Pathways ES   Alternative School No Elementary 03 05 2021   grade_4 4 1 0   0 0       0 0   4 1   0.0                   5 4 1 0   0 0       0 0   4 1   0             5
1842147 NV     school 3200360 12   Nye 320036000852 12609 Pathways ES   Alternative School No Elementary 03 05 2021   grade_5 1 1 0   0 0       0 0   1 1   0.0                   2 1 1 0   0 0       0 0   1 1   0             2
1842927 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2021   grade_3 5 0 1   0 0       0 0   5 1   0.0                   6 5 0 1   0 0       0 0   5 1   0             6
1842928 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2021   grade_4 2 0 1   0 0       0 0   3 0   0.0                   3 2 0 1   0 0       0 0   3 0   0             3
1842929 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2021   grade_5 3 0 2   0 0       0 0   4 1   0.0                   5 3 0 2   0 0       0 0   4 1   0             5
1842930 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2021   grade_6 3 0 0   0 0       0 0   1 2   0.0                   3 3 0 0   0 0       0 0   1 2   0             3
1843483 NV     school 3200030 1   Churchill 320003000431 1207 Numa ES   Regular School No Elementary 03 06 2021   k_12_total 296 6 104   28 7       4 37   245 237   0.0                   482 296 6 104   28 7       4 37   245 237   0             482
1843983 NV     school 3200360 12   Nye 320036000852 12609 Pathways ES   Alternative School No Elementary 03 05 2021   k_12_total 6 2 0   0 0       0 0   6 2   0.0                   8 6 2 0   0 0       0 0   6 2   0             8
1844113 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2021   k_12_total 13 0 4   0 0       0 0   13 4   0.0                   17 13 0 4   0 0       0 0   13 4   0             17
1877821 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2019   grade_4     2.0                     2.0                       2     2                     2                 2
1878632 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2019   grade_3 4.0   3.0                   5.0 2.0                       7 4   3                   5 2                 7
1878633 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2019   grade_4 2.0   1.0                   1.0 2.0                       3 2   1                   1 2                 3
1878634 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2019   grade_6 3.0   3.0                   5.0 1.0                       6 3   3                   5 1                 6
1879077 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Elementary 03 06 2019   grade_4 54.0 4.0 18.0   2.0 45.0         17.0   68.0 72.0                       140 54 4 18   2 45         17   68 72                 140
1879078 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Elementary 03 06 2019   grade_5 53.0 5.0 15.0     44.0       2.0 15.0   67.0 67.0                       134 53 5 15     44       2 15   67 67                 134
1879079 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Elementary 03 06 2019   grade_6 50.0 8.0 15.0     35.0       5.0 16.0   62.0 67.0                       129 50 8 15     35       5 16   62 67                 129
1879624 NV     school 3200360 12   Nye 320036000852 12609 Pathways Elem ALT   Alternative School No Elementary 03 05 2019   k_12_total 0.0 0.0 2.0   0.0 0.0       0.0 0.0   0.0 2.0                       2 0 0 2   0 0       0 0   0 2                 2
1879751 NV     school 3200510 17   White Pine 320051000254 17103 Baker ES   Regular School No Elementary 03 06 2019   k_12_total 9.0 0.0 7.0   0.0 0.0       0.0 0.0   11.0 5.0                       16 9 0 7   0 0       0 0   11 5                 16
1879806 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Elementary 03 06 2019   k_12_total 157.0 17.0 48.0   2.0 124.0       7.0 48.0   197.0 206.0                       403 157 17 48   2 124       7 48   197 206                 403
1709036 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_8 3.0                       2.0 1.0                       3 3                       2 1                 3
1709037 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_9     1.0                   1.0                         1     1                   1                   1
1709038 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_10 1.0                       1.0                         1 1                       1                   1
1709039 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   grade_11 1.0                       1.0                         1 1                       1                   1
1710908 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Middle 04 06 2020   grade_4 50.0 6.0 19.0     44.0       1.0 16.0   74.0 62.0                       136 50 6 19     44       1 16   74 62                 136
1710909 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Middle 04 06 2020   grade_5 47.0 4.0 19.0   2.0 46.0         20.0   68.0 70.0                       138 47 4 19   2 46         20   68 70                 138
1710910 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Middle 04 06 2020   grade_6 50.0 4.0 17.0     41.0       1.0 13.0   60.0 66.0                       126 50 4 17     41       1 13   60 66                 126
1711341 NV     school 3200090 3   Douglas 320009000764 3901 Douglas ALT ALT   Alternative School No Other 04 12 2020   k_12_total 5.0 0.0 1.0   0.0 0.0       0.0 0.0 0.0 5.0 1.0                       6 5 0 1   0 0       0 0 0 5 1                 6
1711643 NV     school 3200001 87   Coral Academy of Science Las Vegas 320000100894 87314 CASLV Windmill   Regular School Yes Middle 04 06 2020   k_12_total 147.0 14.0 55.0   2.0 131.0       2.0 49.0 0.0 202.0 198.0                       400 147 14 55   2 131       2 49 0 202 198                 400
1841547 NV     school 3200090 3   Douglas 320009000764 3901 Douglas Alternative   Alternative School No Other 04 12 2021   grade_8 1 0 0   1 0       0 1   2 1   0.0                   3 1 0 0   1 0       0 1   2 1   0             3
1841548 NV     school 3200090 3   Douglas 320009000764 3901 Douglas Alternative   Alternative School No Other 04 12 2021   grade_10 1 0 0   1 0       0 0   1 1   0.0                   2 1 0 0   1 0       0 0   1 1   0             2
1841549 NV     school 3200090 3   Douglas 320009000764 3901 Douglas Alternative   Alternative School No Other 04 12 2021   grade_11 2 0 0   1 0       0 0   3 0   0.0                   3 2 0 0   1 0       0 0   3 0   0             3
1843073 NV     school 3200001 50   Amplus 320000100848 50431 Amplus Durango   Regular School Yes Other 04 12 2021   grade_4 57 48 37   0 38       9 9   101 97   0.0                   198 57 48 37   0 38       9 9   101 97   0             198

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