Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by ccd_school_lvl descending

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
1787460 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_10                         2.0 1.0                       3.0                         2 1                 3
1787461 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_11                         1.0 1.0                       2.0                         1 1                 2
1787462 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_8                         0.0 3.0                       3.0                         0 3                 3
1787463 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1787464 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   pk_12_total 8.0 1.0                     3.0 6.0     0.0         9.0   2.0   9.0 8 1                     3 6     0     9 2   9
1787465 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_10                         3.0 3.0                       6.0                         3 3                 6
1787466 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_11                         1.0 0.0                       1.0                         1 0                 1
1787467 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1787468 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   pk_12_total 5.0 1.0 1.0               1.0   5.0 3.0     1.0         4.0   5.0   8.0 5 1 1               1   5 3     1     4 5   8
1793921 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2018   grade_9                         579.0 599.0                       1178.0                         579 599                 1178
1793922 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2018   pk_12_total 359.0 406.0 324.0 2.0   6.0     1.0   80.0   579.0 599.0     138.0         918.0   170.0   1178.0 359 406 324 2   6     1   80   579 599     138     918 170   1178
1798476 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 09 2018   grade_9                         102.0 49.0                       151.0                         102 49                 151
1798477 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 09 2018   pk_12_total 49.0 55.0 26.0     6.0         15.0   102.0 49.0     6.0         88.0   22.0   151.0 49 55 26     6         15   102 49     6     88 22   151
1798485 IN     school 1800191 9035   Indiana Connections Career Academy 180019102631 7947 Indiana Connections Career Academy   Regular School Yes Secondary 09 11 2018   grade_10                         14.0 10.0                       24.0                         14 10                 24
1798486 IN     school 1800191 9035   Indiana Connections Career Academy 180019102631 7947 Indiana Connections Career Academy   Regular School Yes Secondary 09 11 2018   grade_11                         11.0 19.0                       30.0                         11 19                 30
1798487 IN     school 1800191 9035   Indiana Connections Career Academy 180019102631 7947 Indiana Connections Career Academy   Regular School Yes Secondary 09 11 2018   grade_9                         11.0 7.0                       18.0                         11 7                 18
1798488 IN     school 1800191 9035   Indiana Connections Career Academy 180019102631 7947 Indiana Connections Career Academy   Regular School Yes Secondary 09 11 2018   pk_12_total 53.0 4.0 7.0     2.0         6.0   36.0 36.0     1.0         28.0   13.0   72.0 53 4 7     2         6   36 36     1     28 13   72
1798495 IN     school 1800182 9050   Excel Center - Clarksville 180018202619 2006 Excel Center - Clarksville   Regular School Yes Secondary 11 11 2018   grade_11                         44.0 151.0                       195.0                         44 151                 195
1798496 IN     school 1800182 9050   Excel Center - Clarksville 180018202619 2006 Excel Center - Clarksville   Regular School Yes Secondary 11 11 2018   pk_12_total 119.0 37.0 18.0 3.0   3.0         15.0   44.0 151.0     6.0         60.0   6.0   195.0 119 37 18 3   3         15   44 151     6     60 6   195
1798497 IN     school 1800185 9055   Excel Center - Hammond 180018502624 2018 Excel Center - Hammond   Regular School Yes Secondary 10 11 2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1798498 IN     school 1800185 9055   Excel Center - Hammond 180018502624 2018 Excel Center - Hammond   Regular School Yes Secondary 10 11 2018   grade_11                         33.0 66.0                       99.0                         33 66                 99
1798499 IN     school 1800185 9055   Excel Center - Hammond 180018502624 2018 Excel Center - Hammond   Regular School Yes Secondary 10 11 2018   pk_12_total 25.0 36.0 35.0               4.0   34.0 66.0     2.0         74.0   2.0   100.0 25 36 35               4   34 66     2     74 2   100
1798539 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 09 2018   grade_9                         53.0 87.0                       140.0                         53 87                 140
1798540 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 09 2018   pk_12_total 33.0 80.0 9.0     4.0     1.0   13.0   53.0 87.0     5.0         91.0   24.0   140.0 33 80 9     4     1   13   53 87     5     91 24   140
1799000 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Secondary 07 11 2018   grade_10                         51.0 45.0                       96.0                         51 45                 96
1799001 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Secondary 07 11 2018   grade_11                         33.0 26.0                       59.0                         33 26                 59
1799002 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Secondary 07 11 2018   grade_7                         23.0 29.0                       52.0                         23 29                 52
1799003 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Secondary 07 11 2018   grade_8                         36.0 35.0                       71.0                         36 35                 71
1799004 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Secondary 07 11 2018   grade_9                         53.0 44.0                       97.0                         53 44                 97
1799005 IN     school 1800173 9770   Indianapolis Lighthouse East 180017302587 5524 Indianapolis Lighthouse East   Regular School Yes Secondary 07 11 2018   pk_12_total 10.0 325.0 23.0               17.0   196.0 179.0     6.0         375.0   85.0   375.0 10 325 23               17   196 179     6     375 85   375
1799278 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Secondary 07 10 2018   grade_10                         28.0 37.0                       65.0                         28 37                 65
1799279 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Secondary 07 10 2018   grade_7                         35.0 45.0                       80.0                         35 45                 80
1799280 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Secondary 07 10 2018   grade_8                         54.0 45.0                       99.0                         54 45                 99
1799281 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Secondary 07 10 2018   grade_9                         29.0 23.0                       52.0                         29 23                 52
1799282 IN     school 1800171 9980   Steel City Academy 180017102614 1113 Steel City Academy   Regular School Yes Secondary 07 10 2018   pk_12_total 3.0 272.0 7.0               14.0   146.0 150.0     3.0         296.0   55.0   296.0 3 272 7               14   146 150     3     296 55   296
1758131 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2019   grade_9                         672.0 591.0                       1263.0                         672 591                 1263
1758132 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2019   pk_12_total 331.0 453.0 394.0 2.0   5.0     1.0   77.0   672.0 591.0     162.0         1019.0   200.0   1263.0 331 453 394 2   5     1   77   672 591     162     1019 200   1263
1758285 IN     school 1804770 5385   Indianapolis Public Schools 180477002653 109 Thrival Academy   Regular School No Secondary 11 11 2019   grade_11                         23.0 27.0                       50.0                         23 27                 50
1758286 IN     school 1804770 5385   Indianapolis Public Schools 180477002653 109 Thrival Academy   Regular School No Secondary 11 11 2019   pk_12_total 3.0 31.0 12.0     3.0         1.0   23.0 27.0     6.0         30.0   5.0   50.0 3 31 12     3         1   23 27     6     30 5   50
1760270 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   grade_10                         98.0 138.0                       236.0                         98 138                 236
1760271 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   grade_11                         55.0 91.0                       146.0                         55 91                 146
1760272 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   grade_7                         152.0 160.0                       312.0                         152 160                 312
1760273 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   grade_8                         161.0 201.0                       362.0                         161 201                 362
1760274 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   grade_9                         165.0 221.0                       386.0                         165 221                 386
1760275 IN     school 1811730 6795   Union School Corporation 181173002666 7131 Indiana Digital JR and High School   Regular School No Secondary 07 11 2019   pk_12_total 1061.0 164.0 113.0 7.0   9.0         88.0   631.0 811.0     10.0         1019.0   291.0   1442.0 1061 164 113 7   9         88   631 811     10     1019 291   1442
1762695 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 10 2019   grade_10                         91.0 55.0                       146.0                         91 55                 146
1762696 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 10 2019   grade_9                         86.0 28.0                       114.0                         86 28                 114
1762697 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 10 2019   pk_12_total 87.0 91.0 56.0 1.0   6.0         19.0   177.0 83.0     10.0         157.0   43.0   260.0 87 91 56 1   6         19   177 83     10     157 43   260
1762803 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 10 2019   grade_10                         59.0 85.0                       144.0                         59 85                 144
1762804 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 10 2019   grade_9                         64.0 74.0                       138.0                         64 74                 138
1762805 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 10 2019   pk_12_total 57.0 165.0 36.0 1.0   3.0     1.0   19.0   123.0 159.0     13.0         174.0   47.0   282.0 57 165 36 1   3     1   19   123 159     13     174 47   282
1762819 IN     school 1800200 9190   Excel Center - Gary 180020002652 1024 Excel Center - Gary   Regular School Yes Secondary 11 11 2019   grade_11                         4.0 25.0                       29.0                         4 25                 29
1762820 IN     school 1800200 9190   Excel Center - Gary 180020002652 1024 Excel Center - Gary   Regular School Yes Secondary 11 11 2019   pk_12_total 4.0 23.0 2.0                   4.0 25.0     0.0         22.0   0.0   29.0 4 23 2                   4 25     0     22 0   29
1907160 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1907161 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_11                         1.0 0.0                       1.0                         1 0                 1
1907162 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1907163 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_9                         3.0 0.0                       3.0                         3 0                 3
1907164 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   pk_12_total 2.0 3.0 1.0                   6.0 0.0     0.0             2.0   6.0 2 3 1                   6 0     0       2   6
1912922 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_10                         9.0 4.0                       13.0                         9 4                 13
1912923 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_7                         14.0 13.0                       27.0                         14 13                 27
1912924 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_8                         15.0 8.0                       23.0                         15 8                 23
1912925 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_9                         10.0 5.0                       15.0                         10 5                 15
1912926 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   pk_12_total 38.0 24.0 7.0               9.0   48.0 30.0     1.0         67.0   16.0   78.0 38 24 7               9   48 30     1     67 16   78
1913555 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2020   grade_9                         664.0 606.0                       1270.0                         664 606                 1270
1913556 IN     school 1812810 5375   M S D Wayne Township 181281002122 5219 Ben Davis Ninth Grade Center   Regular School No Secondary 09 09 2020   pk_12_total 336.0 492.0 366.0 2.0   8.0     3.0   63.0   664.0 606.0     150.0         841.0   169.0   1270.0 336 492 366 2   8     3   63   664 606     150     841 169   1270
1916267 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_10                         3.0 0.0                       3.0                         3 0                 3
1916268 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_11                         4.0 1.0                       5.0                         4 1                 5
1916269 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_6                         2.0 0.0                       2.0                         2 0                 2
1916270 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_7                         1.0 0.0                       1.0                         1 0                 1
1916271 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1916272 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_9                         6.0 0.0                       6.0                         6 0                 6
1916273 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   pk_12_total 6.0 7.0 3.0               2.0   17.0 1.0     2.0         3.0   7.0   18.0 6 7 3               2   17 1     2     3 7   18
1918044 IN     school 1800211 8635   Purdue Polytechnic High Sch North 180021102685 7782 Purdue Polytechnic High Sch North   Regular School Yes Secondary 09 10 2020   grade_10                         13.0 4.0                       17.0                         13 4                 17
1918045 IN     school 1800211 8635   Purdue Polytechnic High Sch North 180021102685 7782 Purdue Polytechnic High Sch North   Regular School Yes Secondary 09 10 2020   grade_9                         35.0 12.0                       47.0                         35 12                 47
1918046 IN     school 1800211 8635   Purdue Polytechnic High Sch North 180021102685 7782 Purdue Polytechnic High Sch North   Regular School Yes Secondary 09 10 2020   pk_12_total 33.0 23.0 4.0     1.0         3.0   48.0 16.0     1.0         33.0   13.0   64.0 33 23 4     1         3   48 16     1     33 13   64
1918047 IN     school 1800209 8655   Excel Center - Bloomington 180020902675 4209 Excel Center - Bloomington   Regular School Yes Secondary 11 11 2020   grade_11                         39.0 87.0                       126.0                         39 87                 126
1918048 IN     school 1800209 8655   Excel Center - Bloomington 180020902675 4209 Excel Center - Bloomington   Regular School Yes Secondary 11 11 2020   pk_12_total 81.0 25.0 4.0 1.0   2.0     1.0   12.0   39.0 87.0     0.0         63.0   5.0   126.0 81 25 4 1   2     1   12   39 87     0     63 5   126
1918148 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 11 2020   grade_10                         81.0 27.0                       108.0                         81 27                 108
1918149 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 11 2020   grade_11                         80.0 38.0                       118.0                         80 38                 118
1918150 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 11 2020   grade_9                         89.0 47.0                       136.0                         89 47                 136
1918151 IN     school 1800183 9015   Purdue Polytechnic High School Ind 180018302632 4271 Purdue Polytechnic High School Ind   Regular School Yes Secondary 09 11 2020   pk_12_total 113.0 135.0 89.0     6.0         19.0   250.0 112.0     20.0         196.0   53.0   362.0 113 135 89     6         19   250 112     20     196 53   362
1918168 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Secondary 07 10 2020   grade_10                         44.0 27.0                       71.0                         44 27                 71
1918169 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Secondary 07 10 2020   grade_7                         67.0 69.0                       136.0                         67 69                 136
1918170 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Secondary 07 10 2020   grade_8                         77.0 74.0                       151.0                         77 74                 151
1918171 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Secondary 07 10 2020   grade_9                         58.0 53.0                       111.0                         58 53                 111
1918172 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Secondary 07 10 2020   pk_12_total 20.0 342.0 91.0               16.0   246.0 223.0     60.0         359.0   76.0   469.0 20 342 91               16   246 223     60     359 76   469
1918260 IN     school 1800206 9135   KIPP Indy Legacy High 180020602669 9138 KIPP Indy Legacy High   Regular School Yes Secondary 09 09 2020   grade_9                         72.0 53.0                       125.0                         72 53                 125
1918261 IN     school 1800206 9135   KIPP Indy Legacy High 180020602669 9138 KIPP Indy Legacy High   Regular School Yes Secondary 09 09 2020   pk_12_total 3.0 98.0 17.0               7.0   72.0 53.0     6.0         117.0   29.0   125.0 3 98 17               7   72 53     6     117 29   125
1918262 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 11 2020   grade_10                         57.0 72.0                       129.0                         57 72                 129
1918263 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 11 2020   grade_11                         56.0 75.0                       131.0                         56 75                 131
1918264 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 11 2020   grade_9                         43.0 46.0                       89.0                         43 46                 89
1918265 IN     school 1800187 9145   Riverside High School 180018702633 1122 Riverside High School   Regular School Yes Secondary 09 11 2020   pk_12_total 73.0 203.0 44.0     6.0     2.0   21.0   156.0 193.0     22.0         240.0   71.0   349.0 73 203 44     6     2   21   156 193     22     240 71   349
1919126 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1919127 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_11                         3.0 0.0                       3.0                         3 0                 3
1919128 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1919129 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1919130 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   pk_12_total 2.0 2.0 2.0                   6.0 0.0     0.0             1.0   6.0 2 2 2                   6 0     0       1   6
1922622 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1922623 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_11                         0.0 1.0                       1.0                         0 1                 1
1922624 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_5                         5.0 0.0                       5.0                         5 0                 5

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