enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
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
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
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
1787370 1787370 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2018   pk_12_total 498.0 20.0 24.0 1.0   7.0         19.0   308.0 261.0     1.0         76.0   39.0   569.0 498 20 24 1   7         19   308 261     1     76 39   569
1787371 1787371 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2018   grade_6                         158.0 178.0                       336.0                         158 178                 336
1787372 1787372 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2018   grade_7                         179.0 161.0                       340.0                         179 161                 340
1787373 1787373 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2018   grade_8                         181.0 198.0                       379.0                         181 198                 379
1787374 1787374 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2018   pk_12_total 809.0 70.0 56.0 3.0   58.0     2.0   57.0   518.0 537.0     5.0         145.0   78.0   1055.0 809 70 56 3   58     2   57   518 537     5     145 78   1055
1787375 1787375 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_1                         42.0 32.0                       74.0                         42 32                 74
1787376 1787376 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_2                         36.0 38.0                       74.0                         36 38                 74
1787377 1787377 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_3                         40.0 27.0                       67.0                         40 27                 67
1787378 1787378 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_4                         25.0 33.0                       58.0                         25 33                 58
1787379 1787379 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   grade_5                         36.0 30.0                       66.0                         36 30                 66
1787380 1787380 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         35.0 36.0                       71.0                         35 36                 71
1787381 1787381 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 340.0 15.0 19.0 1.0   15.0         20.0   214.0 196.0     5.0         71.0   50.0   410.0 340 15 19 1   15         20   214 196     5     71 50   410
1787382 1787382 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_1                         40.0 30.0                       70.0                         40 30                 70
1787383 1787383 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_2                         34.0 34.0                       68.0                         34 34                 68
1787384 1787384 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_3                         34.0 42.0                       76.0                         34 42                 76
1787385 1787385 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_4                         32.0 35.0                       67.0                         32 35                 67
1787386 1787386 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2018   grade_5                         41.0 46.0                       87.0                         41 46                 87

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