enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1304414 1304414 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_1                         27.0 43.0                       70.0                         27 43                 70
1304415 1304415 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_10                         31.0 43.0                       74.0                         31 43                 74
1304416 1304416 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_11                         36.0 35.0                       71.0                         36 35                 71
1304417 1304417 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_12                         19.0 27.0                       46.0                         19 27                 46
1304418 1304418 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_2                         42.0 31.0                       73.0                         42 31                 73
1304419 1304419 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_3                         34.0 45.0                       79.0                         34 45                 79
1304420 1304420 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_4                         24.0 36.0                       60.0                         24 36                 60
1304421 1304421 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_5                         38.0 23.0                       61.0                         38 23                 61
1304422 1304422 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_6                         31.0 28.0                       59.0                         31 28                 59
1304423 1304423 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_7                         29.0 43.0                       72.0                         29 43                 72
1304424 1304424 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_8                         45.0 30.0                       75.0                         45 30                 75
1304425 1304425 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_9                         51.0 24.0                       75.0                         51 24                 75
1304426 1304426 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   kindergarten                         37.0 36.0                       73.0                         37 36                 73
1304427 1304427 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   pk_12_total 3.0 860.0 11.0 1.0             13.0   444.0 444.0     0.0             105.0   888.0 3 860 11 1             13   444 444     0       105   888
1304943 1304943 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   grade_1                         3.0 7.0                       10.0                         3 7                 10
1304944 1304944 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   kindergarten                         11.0 15.0                       26.0                         11 15                 26
1304945 1304945 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   pk_12_total 6.0 23.0 4.0               3.0   14.0 22.0     1.0             2.0   36.0 6 23 4               3   14 22     1       2   36
1292967 1292967 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_1                         33.0 22.0                       55.0                         33 22                 55
1292968 1292968 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_2                         47.0 38.0                       85.0                         47 38                 85
1292969 1292969 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_3                         39.0 50.0                       89.0                         39 50                 89
1292970 1292970 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_4                         60.0 47.0                       107.0                         60 47                 107
1292971 1292971 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_5                         53.0 45.0                       98.0                         53 45                 98
1292972 1292972 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         13.0 21.0                       34.0                         13 21                 34
1292973 1292973 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 376.0 8.0 20.0 1.0   38.0         25.0   245.0 223.0     1.0             16.0   468.0 376 8 20 1   38         25   245 223     1       16   468
1298094 1298094 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_1                         32.0 19.0                       51.0                         32 19                 51
1298095 1298095 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_2                         27.0 21.0                       48.0                         27 21                 48
1298096 1298096 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_3                         27.0 24.0                       51.0                         27 24                 51
1298097 1298097 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_4                         22.0 22.0                       44.0                         22 22                 44
1298098 1298098 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_5                         18.0 17.0                       35.0                         18 17                 35
1298099 1298099 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_6                         33.0 8.0                       41.0                         33 8                 41
1298100 1298100 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   kindergarten                         31.0 21.0                       52.0                         31 21                 52
1298101 1298101 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   pk_12_total 4.0 308.0 79.0               7.0   226.0 172.0     21.0             81.0   398.0 4 308 79               7   226 172     21       81   398
1298102 1298102 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         36.0 40.0                       76.0                         36 40                 76
1298395 1298395 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_1                         51.0 49.0                       100.0                         51 49                 100
1298396 1298396 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_2                         62.0 49.0                       111.0                         62 49                 111
1298397 1298397 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_3                         56.0 42.0                       98.0                         56 42                 98
1298398 1298398 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_4                         50.0 53.0                       103.0                         50 53                 103
1298399 1298399 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_5                         55.0 49.0                       104.0                         55 49                 104
1298400 1298400 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         43.0 47.0                       90.0                         43 47                 90
1298401 1298401 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 84.0 64.0 459.0           1.0   38.0   337.0 309.0     127.0             76.0   646.0 84 64 459           1   38   337 309     127       76   646
1298402 1298402 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         20.0 20.0                       40.0                         20 20                 40
1299306 1299306 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_1                         92.0 88.0                       180.0                         92 88                 180
1299307 1299307 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_2                         79.0 78.0                       157.0                         79 78                 157
1299308 1299308 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_3                         86.0 71.0                       157.0                         86 71                 157
1299309 1299309 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_4                         73.0 59.0                       132.0                         73 59                 132
1299310 1299310 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_5                         79.0 55.0                       134.0                         79 55                 134
1299311 1299311 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         76.0 76.0                       152.0                         76 76                 152
1299312 1299312 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 415.0 70.0 168.0 1.0   258.0         68.0   528.0 452.0     253.0             157.0   980.0 415 70 168 1   258         68   528 452     253       157   980
1299313 1299313 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         43.0 25.0                       68.0                         43 25                 68
1303144 1303144 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_1                         2.0 0.0                       2.0                         2 0                 2
1303145 1303145 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_10                         50.0 55.0                       105.0                         50 55                 105
1303146 1303146 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_11                         133.0 97.0                       230.0                         133 97                 230
1303147 1303147 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_12                         121.0 100.0                       221.0                         121 100                 221
1303148 1303148 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_2                         3.0 3.0                       6.0                         3 3                 6
1303149 1303149 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_3                         10.0 4.0                       14.0                         10 4                 14
1303150 1303150 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_4                         2.0 0.0                       2.0                         2 0                 2
1303151 1303151 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_5                         8.0 0.0                       8.0                         8 0                 8
1303152 1303152 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_6                         9.0 2.0                       11.0                         9 2                 11
1303153 1303153 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_7                         21.0 4.0                       25.0                         21 4                 25
1303154 1303154 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_8                         26.0 16.0                       42.0                         26 16                 42
1303155 1303155 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_9                         46.0 16.0                       62.0                         46 16                 62
1303156 1303156 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1303157 1303157 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   pk_12_total 394.0 212.0 12.0 4.0   2.0     1.0   104.0   432.0 297.0     6.0             207.0   729.0 394 212 12 4   2     1   104   432 297     6       207   729
1299699 1299699 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   grade_10                         4.0 24.0                       28.0                         4 24                 28
1299700 1299700 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   grade_11                         10.0 21.0                       31.0                         10 21                 31
1299701 1299701 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   grade_12                         38.0 76.0                       114.0                         38 76                 114
1299702 1299702 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   grade_9                         4.0 5.0                       9.0                         4 5                 9
1299703 1299703 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   pk_12_total 133.0 27.0 18.0     1.0         3.0   56.0 126.0     0.0             11.0   182.0 133 27 18     1         3   56 126     0       11   182
1299125 1299125 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   grade_1                         40.0 32.0                       72.0                         40 32                 72
1299126 1299126 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   grade_2                         42.0 32.0                       74.0                         42 32                 74
1299127 1299127 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   grade_3                         48.0 24.0                       72.0                         48 24                 72
1299128 1299128 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   grade_4                         28.0 40.0                       68.0                         28 40                 68
1299129 1299129 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   grade_5                         33.0 29.0                       62.0                         33 29                 62
1299130 1299130 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         41.0 31.0                       72.0                         41 31                 72
1299131 1299131 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 359.0 11.0 21.0 2.0   3.0     3.0   21.0   232.0 188.0     9.0             61.0   420.0 359 11 21 2   3     3   21   232 188     9       61   420
1292918 1292918 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_1                         54.0 40.0                       94.0                         54 40                 94
1292919 1292919 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_2                         53.0 52.0                       105.0                         53 52                 105
1292920 1292920 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_3                         63.0 38.0                       101.0                         63 38                 101
1292921 1292921 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_4                         51.0 52.0                       103.0                         51 52                 103
1292922 1292922 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_5                         50.0 51.0                       101.0                         50 51                 101
1292923 1292923 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         62.0 42.0                       104.0                         62 42                 104
1292924 1292924 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 566.0 8.0 25.0     4.0         9.0   335.0 277.0     22.0             88.0   612.0 566 8 25     4         9   335 277     22       88   612
1292925 1292925 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1292926 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 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 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 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 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 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
1292914 1292914 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 36.0                       86.0                         50 36                 86
1292915 1292915 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_7                         38.0 42.0                       80.0                         38 42                 80
1292916 1292916 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_8                         48.0 55.0                       103.0                         48 55                 103
1292917 1292917 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 253.0 3.0 6.0 1.0   3.0         3.0   136.0 133.0     5.0             16.0   269.0 253 3 6 1   3         3   136 133     5       16   269
1293182 1293182 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_1                         19.0 21.0                       40.0                         19 21                 40
1293183 1293183 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_2                         19.0 32.0                       51.0                         19 32                 51
1293184 1293184 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_3                         34.0 19.0                       53.0                         34 19                 53
1293185 1293185 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_4                         16.0 10.0                       26.0                         16 10                 26
1293186 1293186 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_5                         18.0 12.0                       30.0                         18 12                 30
1293187 1293187 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         17.0 27.0                       44.0                         17 27                 44
1293188 1293188 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 42.0 71.0 85.0     43.0         32.0   136.0 137.0     70.0             30.0   273.0 42 71 85     43         32   136 137     70       30   273

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