Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by school

View and edit SQL

grade

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
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
1763494 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_1                         15.0 19.0                       34.0                         15 19                 34
1763495 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_2                         9.0 8.0                       17.0                         9 8                 17
1763496 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_3                         6.0 8.0                       14.0                         6 8                 14
1763497 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   kindergarten                         16.0 8.0                       24.0                         16 8                 24
1763498 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   pk_12_total 10.0 61.0 7.0               11.0   46.0 43.0     5.0         70.0   10.0   89.0 10 61 7               11   46 43     5     70 10   89
1799269 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   grade_1                         12.0 13.0                       25.0                         12 13                 25
1799270 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   grade_2                         5.0 7.0                       12.0                         5 7                 12
1799271 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   kindergarten                         19.0 24.0                       43.0                         19 24                 43
1799272 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   pk_12_total 6.0 58.0 6.0           1.0   9.0   36.0 44.0     1.0         63.0   8.0   80.0 6 58 6           1   9   36 44     1     63 8   80
1918903 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_1                         17.0 17.0                       34.0                         17 17                 34
1918904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_2                         18.0 22.0                       40.0                         18 22                 40
1918905 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_3                         9.0 8.0                       17.0                         9 8                 17
1918906 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_4                         9.0 5.0                       14.0                         9 5                 14
1918907 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   kindergarten                         33.0 26.0                       59.0                         33 26                 59
1918908 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   pk_12_total 11.0 123.0 8.0           1.0   21.0   86.0 78.0     7.0         123.0   15.0   164.0 11 123 8           1   21   86 78     7     123 15   164
1930901 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_1                         21.0 23.0                       44.0                         21 23                 44
1930902 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_2                         15.0 15.0                       30.0                         15 15                 30
1930903 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_3                         12.0 20.0                       32.0                         12 20                 32
1930904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_4                         8.0 9.0                       17.0                         8 9                 17
1930905 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_5                         6.0 4.0                       10.0                         6 4                 10
1930906 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   kindergarten                         18.0 10.0                       28.0                         18 10                 28
1930907 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   pk_12_total 14.0 119.0 10.0               18.0   80.0 81.0     6.0         91.0   23.0   161.0 14 119 10               18   80 81     6     91 23   161
1159515 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 28.0                       55.0                         27 28                 55
1159516 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         55.0 42.0                       97.0                         55 42                 97
1159517 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         57.0 47.0                       104.0                         57 47                 104
1159518 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         52.0 54.0                       106.0                         52 54                 106
1159519 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         59.0 64.0                       123.0                         59 64                 123
1159520 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         30.0 21.0                       51.0                         30 21                 51
1159521 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 431.0 10.0 24.0     41.0     2.0   28.0   280.0 256.0     3.0             11.0   536.0 431 10 24     41     2   28   280 256     3       11   536
1280905 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         42.0 27.0                       69.0                         42 27                 69
1280906 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         36.0 42.0                       78.0                         36 42                 78
1280907 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         60.0 46.0                       106.0                         60 46                 106
1280908 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         53.0 45.0                       98.0                         53 45                 98
1280909 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         49.0 50.0                       99.0                         49 50                 99
1280910 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         25.0 15.0                       40.0                         25 15                 40
1280911 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   pk_12_total 405.0 7.0 19.0     36.0     2.0   21.0   265.0 225.0     2.0             10.0   490.0 405 7 19     36     2   21   265 225     2       10   490
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 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 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 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 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 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 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
1751599 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_1                         34.0 26.0                       60.0                         34 26                 60
1751600 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_2                         44.0 40.0                       84.0                         44 40                 84
1751601 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_3                         53.0 39.0                       92.0                         53 39                 92
1751602 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 45.0                       101.0                         56 45                 101
1751603 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 49.0                       93.0                         44 49                 93
1751604 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         30.0 19.0                       49.0                         30 19                 49
1751605 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 402.0 6.0 19.0 1.0   27.0         24.0   261.0 218.0     1.0         72.0   16.0   479.0 402 6 19 1   27         24   261 218     1     72 16   479
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 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 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 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 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 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 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
1907040 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_1                         36.0 22.0                       58.0                         36 22                 58
1907041 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_2                         44.0 33.0                       77.0                         44 33                 77
1907042 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_3                         48.0 42.0                       90.0                         48 42                 90
1907043 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_4                         56.0 44.0                       100.0                         56 44                 100
1907044 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_5                         50.0 46.0                       96.0                         50 46                 96
1907045 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         22.0 26.0                       48.0                         22 26                 48
1907046 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 393.0 6.0 18.0 2.0   24.0         26.0   256.0 213.0     2.0         62.0   21.0   469.0 393 6 18 2   24         26   256 213     2     62 21   469
1919006 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_1                         24.0 31.0                       55.0                         24 31                 55
1919007 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_2                         36.0 29.0                       65.0                         36 29                 65
1919008 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_3                         52.0 32.0                       84.0                         52 32                 84
1919009 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 39.0                       91.0                         52 39                 91
1919010 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_5                         57.0 43.0                       100.0                         57 43                 100
1919011 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         22.0 20.0                       42.0                         22 20                 42
1919012 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 359.0 10.0 20.0 4.0   20.0         24.0   243.0 194.0     3.0         81.0   26.0   437.0 359 10 20 4   20         24   243 194     3     81 26   437
1164960 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         50.0 52.0                       102.0                         50 52                 102
1164961 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         52.0 57.0                       109.0                         52 57                 109
1164962 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         49.0 52.0                       101.0                         49 52                 101
1164963 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         41.0 48.0                       89.0                         41 48                 89
1164964 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         59.0 53.0                       112.0                         59 53                 112
1164965 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   kindergarten                         52.0 56.0                       108.0                         52 56                 108
1164966 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   pk_12_total 99.0 45.0 482.0 1.0         2.0   32.0   323.0 338.0     197.0             93.0   661.0 99 45 482 1         2   32   323 338     197       93   661
1164967 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         20.0 20.0                       40.0                         20 20                 40
1165869 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         89.0 68.0                       157.0                         89 68                 157
1165870 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         76.0 56.0                       132.0                         76 56                 132
1165871 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_3                         75.0 63.0                       138.0                         75 63                 138
1165872 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         62.0 51.0                       113.0                         62 51                 113
1165873 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_5                         82.0 70.0                       152.0                         82 70                 152
1165874 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         74.0 92.0                       166.0                         74 92                 166
1165875 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   pk_12_total 390.0 83.0 171.0 2.0   156.0         56.0   458.0 400.0     244.0             123.0   858.0 390 83 171 2   156         56   458 400     244       123   858
1164659 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         42.0 37.0                       79.0                         42 37                 79
1164660 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         27.0 33.0                       60.0                         27 33                 60
1164661 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         32.0 17.0                       49.0                         32 17                 49
1164662 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         32.0 19.0                       51.0                         32 19                 51
1164663 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   grade_5                         31.0 26.0                       57.0                         31 26                 57
1164664 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   kindergarten                         44.0 41.0                       85.0                         44 41                 85
1164665 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   pk_12_total 1.0 408.0 62.0               9.0   267.0 213.0     10.0             90.0   480.0 1 408 62               9   267 213     10       90   480
1164666 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         59.0 40.0                       99.0                         59 40                 99
1286048 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_1                         36.0 27.0                       63.0                         36 27                 63
1286049 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         27.0 33.0                       60.0                         27 33                 60
1286050 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_3                         26.0 29.0                       55.0                         26 29                 55
1286051 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_4                         19.0 15.0                       34.0                         19 15                 34
1286052 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         30.0 17.0                       47.0                         30 17                 47

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