Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by ccd_school_high_grade descending

View and edit SQL

grade

year

  • 2017 · 12,058
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
1293524 IN     school 1800360 365   Bartholomew Con School Corp 180036002506 354 Richard L Johnson Early Educ Cntr   Regular School No Elementary PK PK 2017   pk_12_total 69.0 1.0 33.0 1.0   3.0         2.0   60.0 49.0     0.0             13.0   109.0 69 1 33 1   3         2   60 49     0       13   109
1293525 IN     school 1800360 365   Bartholomew Con School Corp 180036002506 354 Richard L Johnson Early Educ Cntr   Regular School No Elementary PK PK 2017   pre_kindergarten                         60.0 49.0                       109.0                         60 49                 109
1295432 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002472 1994 CA Early Learning Center   Regular School No Elementary PK PK 2017   pk_12_total 59.0 12.0 2.0     2.0         11.0   57.0 29.0     0.0             55.0   86.0 59 12 2     2         11   57 29     0       55   86
1295433 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002472 1994 CA Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         57.0 29.0                       86.0                         57 29                 86
1295660 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002505 2291 Early Childhood Center   Regular School No Elementary PK PK 2017   pk_12_total 27.0                       19.0 8.0     0.0             15.0   27.0 27                       19 8     0       15   27
1295661 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303002505 2291 Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         19.0 8.0                       27.0                         19 8                 27
1295729 IN     school 1806390 2865   Marion Community Schools 180639002396 2370 Marion Early Childhood Ed Cntr   Regular School No Elementary PK PK 2017   pk_12_total 178.0 78.0 31.0     3.0         60.0   174.0 176.0     0.0             66.0   350.0 178 78 31     3         60   174 176     0       66   350
1295730 IN     school 1806390 2865   Marion Community Schools 180639002396 2370 Marion Early Childhood Ed Cntr   Regular School No Elementary PK PK 2017   pre_kindergarten                         174.0 176.0                       350.0                         174 176                 350
1296434 IN     school 1801020 3305   Brownsburg Community School Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No Elementary PK PK 2017   pk_12_total 187.0 20.0 15.0     13.0         12.0   144.0 103.0     0.0             116.0   247.0 187 20 15     13         12   144 103     0       116   247
1296435 IN     school 1801020 3305   Brownsburg Community School Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         144.0 103.0                       247.0                         144 103                 247
1296593 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Elementary PK PK 2017   pk_12_total 123.0 7.0 2.0     2.0         4.0   83.0 55.0     0.0             54.0   138.0 123 7 2     2         4   83 55     0       54   138
1296594 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Elementary PK PK 2017   pre_kindergarten                         83.0 55.0                       138.0                         83 55                 138
1296960 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471002598 3078 Huntington Schools Preschool   Regular School No Elementary PK PK 2017   pk_12_total 91.0   2.0     2.0             53.0 42.0     0.0             59.0   95.0 91   2     2             53 42     0       59   95
1296961 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471002598 3078 Huntington Schools Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten                         53.0 42.0                       95.0                         53 42                 95
1297196 IN     school 1806120 3995   Madison Consolidated Schools 180612001092 3327 Madison Early Childhood Center   Regular School No Elementary PK PK 2017   pk_12_total 75.0 1.0   1.0   1.0         1.0   36.0 43.0     0.0             20.0   79.0 75 1   1   1         1   36 43     0       20   79
1297197 IN     school 1806120 3995   Madison Consolidated Schools 180612001092 3327 Madison Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         36.0 43.0                       79.0                         36 43                 79
1297307 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Elementary PK PK 2017   pk_12_total 85.0 1.0 4.0     6.0     1.0   1.0   52.0 46.0     0.0             49.0   98.0 85 1 4     6     1   1   52 46     0       49   98
1297308 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Elementary PK PK 2017   pre_kindergarten                         52.0 46.0                       98.0                         52 46                 98
1298163 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Elementary PK PK 2017   pk_12_total 2.0 533.0 10.0               2.0   270.0 277.0     0.0             70.0   547.0 2 533 10               2   270 277     0       70   547
1298164 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Elementary PK PK 2017   pre_kindergarten                         270.0 277.0                       547.0                         270 277                 547
1298673 IN     school 1806570 4925   Michigan City Area Schools 180657001156 4829 Niemann Elementary School   Regular School No Elementary PK PK 2017   pk_12_total 27.0 12.0 6.0               3.0   39.0 9.0     0.0             38.0   48.0 27 12 6               3   39 9     0       38   48
1298674 IN     school 1806570 4925   Michigan City Area Schools 180657001156 4829 Niemann Elementary School   Regular School No Elementary PK PK 2017   pre_kindergarten                         39.0 9.0                       48.0                         39 9                 48
1298987 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Elementary PK PK 2017   pk_12_total 216.0 41.0 44.0               24.0   199.0 126.0     0.0             154.0   325.0 216 41 44               24   199 126     0       154   325
1298988 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         199.0 126.0                       325.0                         199 126                 325
1299505 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Elementary PK PK 2017   pk_12_total 97.0 122.0 54.0 1.0   2.0         51.0   186.0 141.0     0.0             68.0   327.0 97 122 54 1   2         51   186 141     0       68   327
1299506 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         186.0 141.0                       327.0                         186 141                 327
1299563 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No Elementary PK PK 2017   pk_12_total 30.0 27.0 23.0               2.0   56.0 26.0     0.0             81.0   82.0 30 27 23               2   56 26     0       81   82
1299564 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No Elementary PK PK 2017   pre_kindergarten                         56.0 26.0                       82.0                         56 26                 82
1300118 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No Elementary PK PK 2017   pk_12_total 15.0 88.0 18.0               2.0   69.0 54.0     0.0             21.0   123.0 15 88 18               2   69 54     0       21   123
1300119 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         69.0 54.0                       123.0                         69 54                 123
1300511 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948000261 6144 Edgewood Early Childhood Center   Regular School No Elementary PK PK 2017   pk_12_total 84.0 2.0 5.0               1.0   52.0 40.0     0.0             31.0   92.0 84 2 5               1   52 40     0       31   92
1300512 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948000261 6144 Edgewood Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         52.0 40.0                       92.0                         52 40                 92
1300762 IN     school 1802460 5855   Crawfordsville Community Schools 180246000285 6305 Anna Willson School   Regular School No Elementary PK PK 2017   pk_12_total 100.0 1.0 38.0               2.0   84.0 57.0     0.0             66.0   141.0 100 1 38               2   84 57     0       66   141
1300763 IN     school 1802460 5855   Crawfordsville Community Schools 180246000285 6305 Anna Willson School   Regular School No Elementary PK PK 2017   pre_kindergarten                         84.0 57.0                       141.0                         84 57                 141
1302275 IN     school 1810290 7205   South Bend Community School Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No Elementary PK PK 2017   pk_12_total   21.0 4.0               6.0   13.0 18.0     0.0             3.0   31.0   21 4               6   13 18     0       3   31
1302276 IN     school 1810290 7205   South Bend Community School Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         13.0 18.0                       31.0                         13 18                 31
1302352 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Elementary PK PK 2017   adult                         39.0 15.0                       54.0                         39 15                 54
1302353 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Elementary PK PK 2017   pk_12_total 59.0 118.0 57.0     2.0         18.0   162.0 92.0     8.0             133.0   254.0 59 118 57     2         18   162 92     8       133   254
1302354 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         123.0 77.0                       200.0                         123 77                 200
1302882 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Elementary PK PK 2017   pk_12_total 179.0 27.0 37.0     5.0         12.0   186.0 74.0     0.0             250.0   260.0 179 27 37     5         12   186 74     0       250   260
1302883 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Elementary PK PK 2017   pre_kindergarten                         186.0 74.0                       260.0                         186 74                 260
1303237 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Elementary PK PK 2017   pk_12_total 341.0 76.0 32.0 2.0   3.0         38.0   339.0 153.0     0.0             279.0   492.0 341 76 32 2   3         38   339 153     0       279   492
1303238 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         339.0 153.0                       492.0                         339 153                 492
1303691 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Elementary PK PK 2017   pk_12_total 52.0 2.0   2.0   1.0         5.0   44.0 18.0     0.0             60.0   62.0 52 2   2   1         5   44 18     0       60   62
1303692 IN     school 1812390 8130   Warrick County School Corp 181239002512 8779 Warrick County Preschool   Special Education School No Elementary PK PK 2017   pre_kindergarten                         44.0 18.0                       62.0                         44 18                 62
1293198 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2017   kindergarten                         41.0 35.0                       76.0                         41 35                 76
1293199 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2017   pk_12_total 85.0 79.0 30.0 3.0   3.0     2.0   24.0   108.0 118.0     8.0             15.0   226.0 85 79 30 3   3     2   24   108 118     8       15   226
1293200 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2017   pre_kindergarten                         67.0 83.0                       150.0                         67 83                 150
1293345 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2017   kindergarten                         66.0 54.0                       120.0                         66 54                 120
1293346 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2017   pk_12_total 95.0 73.0 43.0 1.0   9.0     3.0   17.0   132.0 109.0     13.0             38.0   241.0 95 73 43 1   9     3   17   132 109     13       38   241
1293347 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2017   pre_kindergarten                         66.0 55.0                       121.0                         66 55                 121
1298480 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2017   kindergarten                         142.0 146.0                       288.0                         142 146                 288
1298481 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2017   pk_12_total 241.0 21.0 49.0 1.0   4.0         11.0   170.0 157.0     5.0             65.0   327.0 241 21 49 1   4         11   170 157     5       65   327
1298482 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2017   pre_kindergarten                         28.0 11.0                       39.0                         28 11                 39
1299087 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2017   kindergarten                         225.0 241.0                       466.0                         225 241                 466
1299088 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2017   pk_12_total 423.0 71.0 65.0 2.0   5.0         43.0   315.0 294.0     39.0             97.0   609.0 423 71 65 2   5         43   315 294     39       97   609
1299089 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2017   pre_kindergarten                         90.0 53.0                       143.0                         90 53                 143
1299182 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2017   kindergarten                         473.0 465.0                       938.0                         473 465                 938
1299183 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2017   pk_12_total 350.0 557.0 321.0 3.0   17.0     1.0   106.0   699.0 656.0     211.0             174.0   1355.0 350 557 321 3   17     1   106   699 656     211       174   1355
1299184 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2017   pre_kindergarten                         226.0 191.0                       417.0                         226 191                 417
1292926 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   adult                         2.0 1.0                       3.0                         2 1                 3
1292927 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_10                         46.0 55.0                       101.0                         46 55                 101
1292928 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_11                         48.0 33.0                       81.0                         48 33                 81
1292929 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_12                         45.0 57.0                       102.0                         45 57                 102
1292930 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_9                         42.0 49.0                       91.0                         42 49                 91
1292931 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   pk_12_total 358.0   9.0 2.0   8.0         1.0   183.0 195.0     8.0             28.0   378.0 358   9 2   8         1   183 195     8       28   378
1292932 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_10                         95.0 85.0                       180.0                         95 85                 180
1292933 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_11                         70.0 76.0                       146.0                         70 76                 146
1292934 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_12                         94.0 88.0                       182.0                         94 88                 182
1292935 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_9                         85.0 98.0                       183.0                         85 98                 183
1292936 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   pk_12_total 571.0 6.0 88.0 8.0   6.0         12.0   344.0 347.0     3.0             62.0   691.0 571 6 88 8   6         12   344 347     3       62   691
1292954 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_10                         37.0 42.0                       79.0                         37 42                 79
1292955 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_11                         41.0 50.0                       91.0                         41 50                 91
1292956 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_12                         51.0 47.0                       98.0                         51 47                 98
1292957 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_9                         57.0 44.0                       101.0                         57 44                 101
1292958 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   pk_12_total 310.0 2.0 43.0 3.0   6.0         5.0   186.0 183.0     10.0             36.0   369.0 310 2 43 3   6         5   186 183     10       36   369
1292982 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_10                         298.0 300.0                       598.0                         298 300                 598
1292983 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_11                         292.0 279.0                       571.0                         292 279                 571
1292984 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_12                         305.0 282.0                       587.0                         305 282                 587
1292985 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_9                         301.0 291.0                       592.0                         301 291                 592
1292986 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   pk_12_total 1911.0 134.0 117.0 5.0   94.0     2.0   85.0   1196.0 1152.0     5.0             201.0   2348.0 1911 134 117 5   94     2   85   1196 1152     5       201   2348
1293053 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_10                         269.0 323.0                       592.0                         269 323                 592
1293054 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_11                         299.0 281.0                       580.0                         299 281                 580
1293055 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_12                         248.0 258.0                       506.0                         248 258                 506
1293056 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   grade_9                         285.0 317.0                       602.0                         285 317                 602
1293057 IN     school 1808250 225   Northwest Allen County Schools 180825001414 91 Carroll High School   Regular School No High 09 12 2017   pk_12_total 1984.0 51.0 88.0 4.0   68.0     1.0   84.0   1101.0 1179.0     7.0             227.0   2280.0 1984 51 88 4   68     1   84   1101 1179     7       227   2280
1293094 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_10                         3.0 2.0                       5.0                         3 2                 5
1293095 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_11                         8.0 4.0                       12.0                         8 4                 12
1293096 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_12                         3.0 1.0                       4.0                         3 1                 4
1293097 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_8                         2.0 1.0                       3.0                         2 1                 3
1293098 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_9                         1.0 0.0                       1.0                         1 0                 1
1293099 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   pk_12_total 9.0 9.0 1.0     1.0         5.0   17.0 8.0     0.0             11.0   25.0 9 9 1     1         5   17 8     0       11   25
1293100 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_10                         230.0 205.0                       435.0                         230 205                 435
1293101 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_11                         234.0 201.0                       435.0                         234 201                 435
1293102 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_12                         205.0 196.0                       401.0                         205 196                 401
1293103 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   grade_9                         193.0 208.0                       401.0                         193 208                 401
1293104 IN     school 1803630 235   Fort Wayne Community Schools 180363000550 101 North Side High School   Regular School No High 09 12 2017   pk_12_total 763.0 353.0 258.0 8.0   115.0     2.0   173.0   862.0 810.0     94.0             331.0   1672.0 763 353 258 8   115     2   173   862 810     94       331   1672
1293105 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_10                         240.0 234.0                       474.0                         240 234                 474
1293106 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_11                         223.0 232.0                       455.0                         223 232                 455
1293107 IN     school 1803630 235   Fort Wayne Community Schools 180363000556 102 R Nelson Snider High School   Regular School No High 09 12 2017   grade_12                         227.0 224.0                       451.0                         227 224                 451

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