enrollments

Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2018 · 12,019 ✖
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
1787287 1787287 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 51.0                       102.0                         51 51                 102
1787288 1787288 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_7                         49.0 33.0                       82.0                         49 33                 82
1787289 1787289 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_8                         41.0 42.0                       83.0                         41 42                 83
1787290 1787290 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   pk_12_total 251.0 3.0 10.0     2.0         1.0   141.0 126.0     1.0         63.0   16.0   267.0 251 3 10     2         1   141 126     1     63 16   267
1787323 1787323 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2018   grade_6                         43.0 53.0                       96.0                         43 53                 96
1787324 1787324 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2018   grade_7                         47.0 42.0                       89.0                         47 42                 89
1787325 1787325 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2018   grade_8                         58.0 51.0                       109.0                         58 51                 109
1787326 1787326 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2018   pk_12_total 238.0 3.0 42.0 1.0   5.0         5.0   148.0 146.0     17.0         131.0   35.0   294.0 238 3 42 1   5         5   148 146     17     131 35   294
1787291 1787291 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 42.0                       101.0                         59 42                 101
1787292 1787292 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_2                         52.0 42.0                       94.0                         52 42                 94
1787293 1787293 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_3                         56.0 50.0                       106.0                         56 50                 106
1787294 1787294 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_4                         63.0 38.0                       101.0                         63 38                 101
1787295 1787295 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 57.0                       108.0                         51 57                 108
1787296 1787296 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         59.0 63.0                       122.0                         59 63                 122
1787297 1787297 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 586.0 6.0 25.0 1.0   5.0         13.0   341.0 295.0     22.0         172.0   106.0   636.0 586 6 25 1   5         13   341 295     22     172 106   636
1787298 1787298 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         1.0 3.0                       4.0                         1 3                 4
1787299 1787299 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   adult                         1.0 0.0                       1.0                         1 0                 1
1787300 1787300 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_10                         41.0 53.0                       94.0                         41 53                 94
1787301 1787301 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_11                         45.0 53.0                       98.0                         45 53                 98
1787302 1787302 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_12                         50.0 33.0                       83.0                         50 33                 83
1787303 1787303 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_9                         49.0 53.0                       102.0                         49 53                 102
1787304 1787304 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   pk_12_total 356.0 1.0 9.0 1.0   6.0         5.0   186.0 192.0     9.0         86.0   21.0   378.0 356 1 9 1   6         5   186 192     9     86 21   378
1787327 1787327 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_10                         50.0 41.0                       91.0                         50 41                 91
1787328 1787328 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_11                         30.0 37.0                       67.0                         30 37                 67
1787329 1787329 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_12                         42.0 39.0                       81.0                         42 39                 81
1787330 1787330 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_9                         60.0 43.0                       103.0                         60 43                 103
1787331 1787331 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   pk_12_total 289.0 4.0 42.0 1.0   4.0         2.0   182.0 160.0     5.0         134.0   29.0   342.0 289 4 42 1   4         2   182 160     5     134 29   342
1787332 1787332 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_1                         60.0 41.0                       101.0                         60 41                 101
1787333 1787333 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_2                         49.0 54.0                       103.0                         49 54                 103
1787334 1787334 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_3                         41.0 42.0                       83.0                         41 42                 83
1787335 1787335 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_4                         39.0 49.0                       88.0                         39 49                 88
1787336 1787336 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_5                         53.0 48.0                       101.0                         53 48                 101
1787337 1787337 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         42.0 44.0                       86.0                         42 44                 86
1787338 1787338 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 526.0 4.0 76.0     5.0         11.0   326.0 296.0     65.0         268.0   140.0   622.0 526 4 76     5         11   326 296     65     268 140   622
1787339 1787339 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         42.0 18.0                       60.0                         42 18                 60
1787305 1787305 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_10                         83.0 91.0                       174.0                         83 91                 174
1787306 1787306 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_11                         91.0 89.0                       180.0                         91 89                 180
1787307 1787307 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_12                         75.0 71.0                       146.0                         75 71                 146
1787308 1787308 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_9                         86.0 88.0                       174.0                         86 88                 174
1787309 1787309 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   pk_12_total 558.0 9.0 82.0 5.0   4.0         16.0   335.0 339.0     3.0         232.0   56.0   674.0 558 9 82 5   4         16   335 339     3     232 56   674
1787310 1787310 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_5                         55.0 61.0                       116.0                         55 61                 116
1787311 1787311 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_6                         49.0 51.0                       100.0                         49 51                 100
1787312 1787312 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_7                         49.0 59.0                       108.0                         49 59                 108
1787313 1787313 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_8                         69.0 57.0                       126.0                         69 57                 126
1787314 1787314 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   pk_12_total 364.0 11.0 50.0 1.0   3.0     1.0   20.0   222.0 228.0     2.0         251.0   89.0   450.0 364 11 50 1   3     1   20   222 228     2     251 89   450
1787315 1787315 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_2                         71.0 52.0                       123.0                         71 52                 123
1787316 1787316 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_3                         62.0 66.0                       128.0                         62 66                 128
1787317 1787317 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_4                         58.0 67.0                       125.0                         58 67                 125
1787318 1787318 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   pk_12_total 301.0 13.0 39.0     3.0     2.0   18.0   191.0 185.0     0.0         251.0   81.0   376.0 301 13 39     3     2   18   191 185     0     251 81   376
1787319 1787319 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   grade_1                         51.0 56.0                       107.0                         51 56                 107
1787320 1787320 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         65.0 46.0                       111.0                         65 46                 111
1787321 1787321 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 222.0 13.0 35.0     1.0         17.0   148.0 140.0     1.0         191.0   50.0   288.0 222 13 35     1         17   148 140     1     191 50   288
1787322 1787322 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         32.0 38.0                       70.0                         32 38                 70
1787779 1787779 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_3                         99.0 96.0                       195.0                         99 96                 195
1787780 1787780 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_4                         97.0 88.0                       185.0                         97 88                 185
1787781 1787781 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_5                         111.0 92.0                       203.0                         111 92                 203
1787782 1787782 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   grade_6                         98.0 93.0                       191.0                         98 93                 191
1787783 1787783 IN     school 1802850 255   East Allen County Schools 180285002519 43 Prince Chapman Academy   Regular School No Elementary 03 06 2018   pk_12_total 63.0 240.0 111.0     308.0         52.0   405.0 369.0     243.0         695.0   70.0   774.0 63 240 111     308         52   405 369     243     695 70   774
1787340 1787340 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_1                         35.0 27.0                       62.0                         35 27                 62
1787341 1787341 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_2                         48.0 34.0                       82.0                         48 34                 82
1787342 1787342 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_3                         54.0 51.0                       105.0                         54 51                 105
1787343 1787343 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_4                         41.0 52.0                       93.0                         41 52                 93
1787344 1787344 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_5                         68.0 52.0                       120.0                         68 52                 120
1787345 1787345 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         22.0 26.0                       48.0                         22 26                 48
1787346 1787346 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 411.0 11.0 26.0 1.0   38.0         23.0   268.0 242.0     0.0         64.0   22.0   510.0 411 11 26 1   38         23   268 242     0     64 22   510
1787347 1787347 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   grade_1                         38.0 40.0                       78.0                         38 40                 78
1787348 1787348 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   grade_2                         44.0 39.0                       83.0                         44 39                 83
1787349 1787349 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   grade_3                         39.0 35.0                       74.0                         39 35                 74
1787350 1787350 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   grade_4                         54.0 31.0                       85.0                         54 31                 85
1787351 1787351 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   grade_5                         40.0 35.0                       75.0                         40 35                 75
1787352 1787352 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   kindergarten                         51.0 40.0                       91.0                         51 40                 91
1787353 1787353 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   pk_12_total 362.0 56.0 32.0 3.0   37.0     2.0   24.0   286.0 230.0     28.0         108.0   63.0   516.0 362 56 32 3   37     2   24   286 230     28     108 63   516
1787354 1787354 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2018   pre_kindergarten                         20.0 10.0                       30.0                         20 10                 30
1787355 1787355 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   grade_10                         293.0 295.0                       588.0                         293 295                 588
1787356 1787356 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   grade_11                         291.0 301.0                       592.0                         291 301                 592
1787357 1787357 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   grade_12                         296.0 275.0                       571.0                         296 275                 571
1787358 1787358 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   grade_9                         305.0 287.0                       592.0                         305 287                 592
1787359 1787359 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   pk_12_total 1905.0 121.0 103.0 7.0   115.0     2.0   90.0   1185.0 1158.0     10.0         272.0   205.0   2343.0 1905 121 103 7   115     2   90   1185 1158     10     272 205   2343
1787784 1787784 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   adult                         3.0 3.0                       6.0                         3 3                 6
1787785 1787785 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_10                         113.0 123.0                       236.0                         113 123                 236
1787786 1787786 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_11                         120.0 108.0                       228.0                         120 108                 228
1787787 1787787 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_12                         117.0 92.0                       209.0                         117 92                 209
1787788 1787788 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_7                         108.0 112.0                       220.0                         108 112                 220
1787789 1787789 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_8                         109.0 107.0                       216.0                         109 107                 216
1787790 1787790 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_9                         135.0 105.0                       240.0                         135 105                 240
1787791 1787791 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   pk_12_total 1199.0 26.0 52.0 3.0   33.0         42.0   705.0 650.0     16.0         224.0   75.0   1355.0 1199 26 52 3   33         42   705 650     16     224 75   1355
1787792 1787792 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2018   grade_4                         98.0 82.0                       180.0                         98 82                 180
1787793 1787793 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2018   grade_5                         92.0 96.0                       188.0                         92 96                 188
1787794 1787794 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2018   grade_6                         92.0 112.0                       204.0                         92 112                 204
1787795 1787795 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2018   pk_12_total 514.0 6.0 24.0 2.0   6.0         20.0   282.0 290.0     4.0         104.0   36.0   572.0 514 6 24 2   6         20   282 290     4     104 36   572
1787360 1787360 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_6                         109.0 119.0                       228.0                         109 119                 228
1787361 1787361 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_7                         108.0 120.0                       228.0                         108 120                 228
1787362 1787362 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_8                         132.0 118.0                       250.0                         132 118                 250
1787363 1787363 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   pk_12_total 594.0 15.0 49.0 2.0   17.0         29.0   349.0 357.0     3.0         111.0   60.0   706.0 594 15 49 2   17         29   349 357     3     111 60   706
1787364 1787364 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_1                         42.0 44.0                       86.0                         42 44                 86
1787365 1787365 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_2                         59.0 46.0                       105.0                         59 46                 105
1787366 1787366 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_3                         41.0 44.0                       85.0                         41 44                 85
1787367 1787367 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_4                         52.0 40.0                       92.0                         52 40                 92
1787368 1787368 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   grade_5                         57.0 40.0                       97.0                         57 40                 97
1787369 1787369 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   kindergarten                         57.0 47.0                       104.0                         57 47                 104

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