Data source: Big Local News · About: Big Local

4,895 rows where state = "NV" and year = 2020 sorted by ccd_school_type descending

View and edit SQL

year

  • 2020 · 4,895
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
1707820 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_1 1.0   2.0               1.0   3.0 1.0                       4 1   2               1   3 1                 4
1707821 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_2   1.0 2.0               2.0   2.0 3.0                       5   1 2               2   2 3                 5
1707822 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_3 1.0 1.0 6.0     1.0             6.0 3.0                       9 1 1 6     1             6 3                 9
1707823 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_4 3.0 1.0 5.0                   4.0 5.0                       9 3 1 5                   4 5                 9
1707824 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_5 3.0 4.0 3.0                   4.0 6.0                       10 3 4 3                   4 6                 10
1707825 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_6 5.0 1.0 7.0     1.0         1.0   10.0 5.0                       15 5 1 7     1         1   10 5                 15
1707826 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_7 4.0 1.0 3.0     2.0       1.0 1.0   8.0 4.0                       12 4 1 3     2       1 1   8 4                 12
1707827 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_8 1.0 2.0 3.0               1.0   4.0 3.0                       7 1 2 3               1   4 3                 7
1707828 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_9 1.0   1.0               1.0   2.0 1.0                       3 1   1               1   2 1                 3
1707829 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_10 2.0 2.0 4.0     2.0       1.0     10.0 1.0                       11 2 2 4     2       1     10 1                 11
1707830 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_11 2.0 3.0 2.0                   4.0 3.0                       7 2 3 2                   4 3                 7
1707831 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   grade_12     4.0     1.0             1.0 4.0                       5     4     1             1 4                 5
1707832 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   kindergarten 1.0   3.0                   2.0 2.0                       4 1   3                   2 2                 4
1707833 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   pre_kindergarten 5.0 1.0 2.0     1.0       1.0     5.0 5.0                       10 5 1 2     1       1     5 5                 10
1707834 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   ungraded 4.0 3.0 12.0     1.0         1.0   9.0 12.0                       21 4 3 12     1         1   9 12                 21
1707912 NV     school 3200060 2   Clark 320006000797 2227 Early Childhood   Special Education School No Elementary PK KG 2020   pre_kindergarten 13.0 14.0 35.0     1.0         10.0   39.0 34.0                       73 13 14 35     1         10   39 34                 73
1708857 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_1     1.0                   1.0                         1     1                   1                   1
1708858 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_2 1.0 2.0 2.0                   5.0                         5 1 2 2                   5                   5
1708859 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_3     2.0     1.0             3.0                         3     2     1             3                   3
1708860 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_4 1.0 2.0 1.0                   4.0                         4 1 2 1                   4                   4
1708861 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_5 2.0 2.0 2.0     2.0       1.0     9.0                         9 2 2 2     2       1     9                   9
1708862 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_6 1.0 2.0 1.0                   4.0                         4 1 2 1                   4                   4
1708863 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_7 5.0 2.0 3.0               1.0   6.0 5.0                       11 5 2 3               1   6 5                 11
1708864 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_8 1.0 1.0 6.0     1.0             6.0 3.0                       9 1 1 6     1             6 3                 9
1708865 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_9 6.0 2.0 6.0               1.0   12.0 3.0                       15 6 2 6               1   12 3                 15
1708866 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_10 2.0 1.0 5.0     2.0         2.0   7.0 5.0                       12 2 1 5     2         2   7 5                 12
1708867 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_11 3.0 10.0 1.0             1.0 2.0   12.0 5.0                       17 3 10 1             1 2   12 5                 17
1708868 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   grade_12 3.0 3.0 3.0     2.0         1.0   8.0 4.0                       12 3 3 3     2         1   8 4                 12
1708869 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   ungraded 14.0 8.0 10.0     5.0         2.0   26.0 13.0                       39 14 8 10     5         2   26 13                 39
1708870 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_6 2.0 4.0 4.0     1.0         1.0   10.0 2.0                       12 2 4 4     1         1   10 2                 12
1708871 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_7 2.0 3.0 6.0     2.0             12.0 1.0                       13 2 3 6     2             12 1                 13
1708872 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_8 2.0 4.0 6.0                   6.0 6.0                       12 2 4 6                   6 6                 12
1708873 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_9 4.0 2.0 3.0               1.0   9.0 1.0                       10 4 2 3               1   9 1                 10
1708874 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_10 5.0 5.0 10.0     3.0         2.0   17.0 8.0                       25 5 5 10     3         2   17 8                 25
1708875 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_11 1.0 3.0 2.0     1.0             7.0                         7 1 3 2     1             7                   7
1708876 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   grade_12 2.0 1.0 5.0     1.0         1.0   7.0 3.0                       10 2 1 5     1         1   7 3                 10
1708877 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   ungraded 13.0 7.0 6.0     5.0         3.0   31.0 3.0                       34 13 7 6     5         3   31 3                 34
1708890 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_6 2.0 8.0 3.0               1.0   12.0 2.0                       14 2 8 3               1   12 2                 14
1708891 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_7 4.0 3.0 2.0               1.0   9.0 1.0                       10 4 3 2               1   9 1                 10
1708892 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_8 1.0 7.0                 1.0   8.0 1.0                       9 1 7                 1   8 1                 9
1708893 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_9 3.0 9.0 2.0                   11.0 3.0                       14 3 9 2                   11 3                 14
1708894 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_10 4.0 4.0 1.0                   8.0 1.0                       9 4 4 1                   8 1                 9
1708895 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_11 5.0 3.0 1.0               1.0   9.0 1.0                       10 5 3 1               1   9 1                 10
1708896 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   grade_12 2.0 3.0 2.0                   5.0 2.0                       7 2 3 2                   5 2                 7
1708897 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   ungraded 1.0                       1.0                         1 1                       1                   1
1708898 NV     school 3200060 2   Clark 320006000607 2917 Miley Achvmt ES   Special Education School No Elementary PK 05 2020   grade_2   3.0                     2.0 1.0                       3   3                     2 1                 3
1708899 NV     school 3200060 2   Clark 320006000607 2917 Miley Achvmt ES   Special Education School No Elementary PK 05 2020   grade_3 1.0 1.0 1.0               1.0   2.0 2.0                       4 1 1 1               1   2 2                 4
1708900 NV     school 3200060 2   Clark 320006000607 2917 Miley Achvmt ES   Special Education School No Elementary PK 05 2020   grade_4 3.0 7.0 2.0               2.0   13.0 1.0                       14 3 7 2               2   13 1                 14
1708901 NV     school 3200060 2   Clark 320006000607 2917 Miley Achvmt ES   Special Education School No Elementary PK 05 2020   grade_5 3.0 6.0 2.0               1.0   11.0 1.0                       12 3 6 2               1   11 1                 12
1708918 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_7                     2.0   1.0 1.0                       2                     2   1 1                 2
1708919 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_8 2.0 1.0                     3.0                         3 2 1                     3                   3
1708920 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_9 1.0 2.0                     2.0 1.0                       3 1 2                     2 1                 3
1708921 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_10     1.0               1.0   1.0 1.0                       2     1               1   1 1                 2
1708922 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_11 1.0                   1.0   1.0 1.0                       2 1                   1   1 1                 2
1708923 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   grade_12 2.0                       2.0                         2 2                       2                   2
1708945 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_1 1.0   1.0                   1.0 1.0                       2 1   1                   1 1                 2
1708946 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_2 1.0 1.0 1.0                   2.0 1.0                       3 1 1 1                   2 1                 3
1708947 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_3 1.0                         1.0                       1 1                         1                 1
1708948 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_4 2.0 2.0 7.0     1.0         1.0   11.0 2.0                       13 2 2 7     1         1   11 2                 13
1708949 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   grade_5 5.0 3.0                     7.0 1.0                       8 5 3                     7 1                 8
1709199 NV     school 3200120 4   Elko 320012000836 4904 Early Childhood S   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten 66.0   20.0   5.0           4.0   69.0 26.0                       95 66   20   5           4   69 26                 95
1709657 NV     school 3200390 13   Carson 320039000803 13205 Early Childhood   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten 38.0   21.0     1.0       1.0 2.0   40.0 23.0                       63 38   21     1       1 2   40 23                 63
1710376 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_1 3.0   2.0                   2.0 3.0                       5 3   2                   2 3                 5
1710377 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_2 1.0                         1.0                       1 1                         1                 1
1710378 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_3 4.0                   2.0   2.0 4.0                       6 4                   2   2 4                 6
1710379 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_4 2.0   3.0     1.0             5.0 1.0                       6 2   3     1             5 1                 6
1710380 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_5 6.0   1.0             2.0     7.0 2.0                       9 6   1             2     7 2                 9
1710381 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_6 3.0   1.0               1.0   5.0                         5 3   1               1   5                   5
1710382 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_7 2.0   3.0     1.0             3.0 3.0                       6 2   3     1             3 3                 6
1710383 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_8 1.0   3.0                   4.0                         4 1   3                   4                   4
1710384 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_9 4.0   2.0   1.0               4.0 3.0                       7 4   2   1               4 3                 7
1710385 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_10 3.0   3.0                   4.0 2.0                       6 3   3                   4 2                 6
1710386 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_11 4.0   4.0     1.0             7.0 2.0                       9 4   4     1             7 2                 9
1710387 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   grade_12 2.0 2.0 5.0                   7.0 2.0                       9 2 2 5                   7 2                 9
1710388 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   kindergarten     4.0     1.0             3.0 2.0                       5     4     1             3 2                 5
1710389 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   pre_kindergarten 3.0   4.0                   4.0 3.0                       7 3   4                   4 3                 7
1710390 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   ungraded 9.0   8.0                   13.0 4.0                       17 9   8                   13 4                 17
1710440 NV     school 3200510 17   White Pine 320051000776 17204 Early Childhood ES   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten 7.0   3.0                   7.0 3.0                       10 7   3                   7 3                 10
1711112 NV     school 3200060 2   Clark 320006000384 2215 Miller Sch   Special Education School No Other PK 12 2020   k_12_total 28.0 19.0 57.0   0.0 8.0       2.0 8.0 0.0 69.0 53.0                       122 28 19 57   0 8       2 8 0 69 53                 122
1711309 NV     school 3200060 2   Clark 320006000774 2910 Stewart Sch   Special Education School No Other PK 12 2020   k_12_total 39.0 35.0 43.0   0.0 13.0       2.0 9.0 0.0 103.0 38.0                       141 39 35 43   0 13       2 9 0 103 38                 141
1711310 NV     school 3200060 2   Clark 320006000108 2911 Variety School E SEC   Special Education School No High 06 12 2020   k_12_total 31.0 29.0 42.0   0.0 13.0       0.0 8.0 0.0 99.0 24.0                       123 31 29 42   0 13       0 8 0 99 24                 123
1711313 NV     school 3200060 2   Clark 320006000694 2916 Miley Achvmt SEC   Special Education School No High 06 12 2020   k_12_total 22.0 37.0 11.0   0.0 0.0       0.0 4.0 0.0 63.0 11.0                       74 22 37 11   0 0       0 4 0 63 11                 74
1711314 NV     school 3200060 2   Clark 320006000607 2917 Miley Achvmt ES   Special Education School No Elementary PK 05 2020   k_12_total 7.0 17.0 5.0   0.0 0.0       0.0 4.0 0.0 28.0 5.0                       33 7 17 5   0 0       0 4 0 28 5                 33
1711319 NV     school 3200060 2   Clark 320006000683 2927 Desert Willow   Special Education School No High 06 12 2020   k_12_total 6.0 3.0 1.0   0.0 0.0       0.0 4.0 0.0 10.0 4.0                       14 6 3 1   0 0       0 4 0 10 4                 14
1711323 NV     school 3200060 2   Clark 320006000619 2935 Variety School ES   Special Education School No Elementary PK 05 2020   k_12_total 10.0 6.0 9.0   0.0 1.0       0.0 1.0 0.0 21.0 6.0                       27 10 6 9   0 1       0 1 0 21 6                 27
1711577 NV     school 3200480 16   Washoe 320048000233 16911 Picollo Sch   Special Education School No Other PK 12 2020   k_12_total 44.0 2.0 39.0   1.0 4.0       2.0 3.0 0.0 66.0 29.0                       95 44 2 39   1 4       2 3 0 66 29                 95
1706758 NV     school 3200030 1   Churchill 320003000005 1202 Northside Early ES   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 76.0 4.0 43.0   1.0 3.0         9.0   76.0 60.0                       136 76 4 43   1 3         9   76 60                 136
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
1706761 NV     school 3200030 1   Churchill 320003000021 1206 Lahontan ES   Regular School No Elementary KG 02 2020   grade_1 148.0 2.0 59.0   10.0 2.0       1.0 13.0   114.0 121.0                       235 148 2 59   10 2       1 13   114 121                 235
1706762 NV     school 3200030 1   Churchill 320003000021 1206 Lahontan ES   Regular School No Elementary KG 02 2020   grade_2 1.0   2.0                   1.0 2.0                       3 1   2                   1 2                 3
1706763 NV     school 3200030 1   Churchill 320003000021 1206 Lahontan ES   Regular School No Elementary KG 02 2020   kindergarten 156.0 3.0 50.0   16.0 2.0       3.0 14.0   124.0 120.0                       244 156 3 50   16 2       3 14   124 120                 244
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
1706768 NV     school 3200030 1   Churchill 320003000003 1301 Churchill Co   Regular School No Middle 06 08 2020   grade_6 155.0 10.0 67.0   20.0 3.0       1.0 16.0   147.0 125.0                       272 155 10 67   20 3       1 16   147 125                 272
1706769 NV     school 3200030 1   Churchill 320003000003 1301 Churchill Co   Regular School No Middle 06 08 2020   grade_7 128.0 4.0 73.0   12.0 4.0         22.0   144.0 99.0                       243 128 4 73   12 4         22   144 99                 243
1706770 NV     school 3200030 1   Churchill 320003000003 1301 Churchill Co   Regular School No Middle 06 08 2020   grade_8 144.0 4.0 65.0   19.0 6.0       1.0 29.0   147.0 121.0                       268 144 4 65   19 6       1 29   147 121                 268
1706771 NV     school 3200030 1   Churchill 320003000001 1401 Churchill Co   Regular School No High 09 12 2020   grade_9 131.0 6.0 50.0   11.0 3.0         24.0   119.0 106.0                       225 131 6 50   11 3         24   119 106                 225

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