Data source: Big Local News · About: Big Local

12,062 rows where state = "IN" and year = 2016 sorted by district

View and edit SQL

grade

year

  • 2016 · 12,062
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
1292381 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_1                         33.0 22.0                       55.0                         33 22                 55
1292382 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_10                         27.0 32.0                       59.0                         27 32                 59
1292383 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_11                         21.0 27.0                       48.0                         21 27                 48
1292384 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_12                         20.0 17.0                       37.0                         20 17                 37
1292385 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_2                         28.0 39.0                       67.0                         28 39                 67
1292386 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_3                         27.0 36.0                       63.0                         27 36                 63
1292387 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_4                         33.0 24.0                       57.0                         33 24                 57
1292388 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_5                         30.0 26.0                       56.0                         30 26                 56
1292389 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_6                         36.0 24.0                       60.0                         36 24                 60
1292390 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_7                         42.0 24.0                       66.0                         42 24                 66
1292391 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_8                         43.0 20.0                       63.0                         43 20                 63
1292392 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_9                         25.0 39.0                       64.0                         25 39                 64
1292393 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   kindergarten                         27.0 36.0                       63.0                         27 36                 63
1292394 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   pk_12_total   732.0 17.0 1.0             8.0   392.0 366.0     0.0             90.0   758.0   732 17 1             8   392 366     0       90   758
1280852 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_6                         38.0 41.0                       79.0                         38 41                 79
1280853 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_7                         49.0 56.0                       105.0                         49 56                 105
1280854 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_8                         44.0 51.0                       95.0                         44 51                 95
1280855 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   pk_12_total 264.0 3.0 4.0 1.0   4.0         3.0   131.0 148.0     3.0             14.0   279.0 264 3 4 1   4         3   131 148     3       14   279
1280856 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         51.0 52.0                       103.0                         51 52                 103
1280857 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         64.0 38.0                       102.0                         64 38                 102
1280858 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         51.0 48.0                       99.0                         51 48                 99
1280859 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         50.0 51.0                       101.0                         50 51                 101
1280860 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         51.0 35.0                       86.0                         51 35                 86
1280861 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         56.0 37.0                       93.0                         56 37                 93
1280862 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 542.0 9.0 18.0     5.0         10.0   323.0 261.0     25.0             80.0   584.0 542 9 18     5         10   323 261     25       80   584
1280863 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   adult                         2.0 1.0                       3.0                         2 1                 3
1280864 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_10                         48.0 34.0                       82.0                         48 34                 82
1280865 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_11                         47.0 53.0                       100.0                         47 53                 100
1280866 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_12                         51.0 38.0                       89.0                         51 38                 89
1280867 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_9                         47.0 53.0                       100.0                         47 53                 100
1280868 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   pk_12_total 357.0 1.0 12.0 1.0         1.0   2.0   195.0 179.0     6.0             35.0   374.0 357 1 12 1         1   2   195 179     6       35   374
1286916 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_10                         78.0 65.0                       143.0                         78 65                 143
1286917 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_11                         59.0 66.0                       125.0                         59 66                 125
1286918 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_12                         58.0 64.0                       122.0                         58 64                 122
1286919 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_7                         57.0 60.0                       117.0                         57 60                 117
1286920 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_8                         68.0 52.0                       120.0                         68 52                 120
1286921 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_9                         60.0 66.0                       126.0                         60 66                 126
1286922 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   pk_12_total 694.0 1.0 39.0 1.0   2.0         16.0   380.0 373.0     9.0             94.0   753.0 694 1 39 1   2         16   380 373     9       94   753
1286923 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_3                         54.0 49.0                       103.0                         54 49                 103
1286924 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_4                         65.0 43.0                       108.0                         65 43                 108
1286925 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_5                         47.0 59.0                       106.0                         47 59                 106
1286926 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_6                         42.0 60.0                       102.0                         42 60                 102
1286927 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   pk_12_total 374.0 1.0 32.0               12.0   208.0 211.0     5.0             83.0   419.0 374 1 32               12   208 211     5       83   419
1286928 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   grade_1                         60.0 54.0                       114.0                         60 54                 114
1286929 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   grade_2                         57.0 49.0                       106.0                         57 49                 106
1286930 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   kindergarten                         45.0 41.0                       86.0                         45 41                 86
1286931 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   pk_12_total 295.0 1.0 15.0               15.0   173.0 153.0     2.0             55.0   326.0 295 1 15               15   173 153     2       55   326
1286932 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1286933 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2016   grade_10                         298.0 217.0                       515.0                         298 217                 515
1286934 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2016   grade_11                         206.0 236.0                       442.0                         206 236                 442
1286935 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2016   grade_12                         217.0 199.0                       416.0                         217 199                 416
1286936 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2016   grade_9                         271.0 208.0                       479.0                         271 208                 479
1286937 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2016   pk_12_total 1098.0 443.0 172.0 5.0   12.0     1.0   121.0   992.0 860.0     43.0             334.0   1852.0 1098 443 172 5   12     1   121   992 860     43       334   1852
1286938 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         33.0 23.0                       56.0                         33 23                 56
1286939 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         23.0 32.0                       55.0                         23 32                 55
1286940 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         29.0 25.0                       54.0                         29 25                 54
1286941 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         17.0 26.0                       43.0                         17 26                 43
1286942 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         22.0 17.0                       39.0                         22 17                 39
1286943 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         26.0 21.0                       47.0                         26 21                 47
1286944 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 126.0 98.0 26.0               44.0   150.0 144.0     4.0             67.0   294.0 126 98 26               44   150 144     4       67   294
1286945 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         93.0 61.0                       154.0                         93 61                 154
1286946 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         54.0 48.0                       102.0                         54 48                 102
1286947 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         64.0 51.0                       115.0                         64 51                 115
1286948 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         45.0 46.0                       91.0                         45 46                 91
1286949 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         32.0 39.0                       71.0                         32 39                 71
1286950 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         59.0 42.0                       101.0                         59 42                 101
1286951 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 386.0 132.0 52.0 2.0   2.0         60.0   347.0 287.0     11.0             137.0   634.0 386 132 52 2   2         60   347 287     11       137   634
1286952 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No 1.0 PK PK 2016   pk_12_total 232.0 45.0 41.0               25.0   206.0 137.0     0.0             137.0   343.0 232 45 41               25   206 137     0       137   343
1286953 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         206.0 137.0                       343.0                         206 137                 343
1286954 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         67.0 46.0                       113.0                         67 46                 113
1286955 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         72.0 51.0                       123.0                         72 51                 123
1286956 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         59.0 58.0                       117.0                         59 58                 117
1286957 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         53.0 48.0                       101.0                         53 48                 101
1286958 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         52.0 44.0                       96.0                         52 44                 96
1286959 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         56.0 37.0                       93.0                         56 37                 93
1286960 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 391.0 115.0 60.0     4.0         73.0   359.0 284.0     11.0             139.0   643.0 391 115 60     4         73   359 284     11       139   643
1286961 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2016   grade_6                         228.0 211.0                       439.0                         228 211                 439
1286962 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2016   grade_7                         236.0 200.0                       436.0                         236 200                 436
1286963 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2016   grade_8                         270.0 251.0                       521.0                         270 251                 521
1286964 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2016   pk_12_total 804.0 327.0 156.0 2.0   6.0         101.0   734.0 662.0     47.0             303.0   1396.0 804 327 156 2   6         101   734 662     47       303   1396
1286965 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         49.0 53.0                       102.0                         49 53                 102
1286966 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         52.0 44.0                       96.0                         52 44                 96
1286967 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         78.0 68.0                       146.0                         78 68                 146
1286968 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         55.0 41.0                       96.0                         55 41                 96
1286969 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         70.0 48.0                       118.0                         70 48                 118
1286970 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1286971 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 462.0 93.0 48.0 2.0   1.0         62.0   361.0 307.0     8.0             144.0   668.0 462 93 48 2   1         62   361 307     8       144   668
1286972 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         45.0 56.0                       101.0                         45 56                 101
1286973 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         62.0 41.0                       103.0                         62 41                 103
1286974 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         50.0 55.0                       105.0                         50 55                 105
1286975 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         48.0 53.0                       101.0                         48 53                 101
1286976 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         47.0 47.0                       94.0                         47 47                 94
1286977 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         47.0 44.0                       91.0                         47 44                 91
1286978 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 150.0 159.0 236.0               50.0   299.0 296.0     170.0             124.0   595.0 150 159 236               50   299 296     170       124   595
1286979 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         60.0 49.0                       109.0                         60 49                 109
1286980 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         50.0 49.0                       99.0                         50 49                 99
1286981 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         47.0 35.0                       82.0                         47 35                 82
1286982 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         37.0 41.0                       78.0                         37 41                 78
1286983 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         42.0 35.0                       77.0                         42 35                 77
1286984 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         59.0 65.0                       124.0                         59 65                 124

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