Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by school_nces_id

View and edit SQL

grade

year

  • 2021 · 11,902
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
1930364 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_10                         24.0 19.0                       43.0                         24 19                 43
1930365 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_11                         26.0 18.0                       44.0                         26 18                 44
1930366 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_12                         18.0 20.0                       38.0                         18 20                 38
1930367 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_2                         30.0 26.0                       56.0                         30 26                 56
1930368 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_3                         21.0 34.0                       55.0                         21 34                 55
1930369 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_4                         28.0 27.0                       55.0                         28 27                 55
1930370 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_5                         24.0 27.0                       51.0                         24 27                 51
1930371 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_6                         28.0 28.0                       56.0                         28 28                 56
1930372 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_7                         24.0 31.0                       55.0                         24 31                 55
1930373 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_8                         20.0 34.0                       54.0                         20 34                 54
1930374 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_9                         27.0 31.0                       58.0                         27 31                 58
1930375 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   kindergarten                         27.0 27.0                       54.0                         27 27                 54
1930376 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   pk_12_total 194.0 75.0 350.0     4.0         51.0   321.0 353.0     172.0         552.0   86.0   674.0 194 75 350     4         51   321 353     172     552 86   674
1930276 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2021   grade_10                         40.0 55.0                       95.0                         40 55                 95
1930277 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2021   grade_11                         38.0 53.0                       91.0                         38 53                 91
1930278 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2021   grade_12                         38.0 52.0                       90.0                         38 52                 90
1930279 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2021   grade_9                         47.0 66.0                       113.0                         47 66                 113
1930280 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2021   pk_12_total 249.0 14.0 21.0 1.0   78.0         26.0   163.0 226.0     9.0         63.0   1.0   389.0 249 14 21 1   78         26   163 226     9     63 1   389
1930537 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   adult                         10.0 4.0                       14.0                         10 4                 14
1930538 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_1                         0.0 4.0                       4.0                         0 4                 4
1930539 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_10                         10.0 5.0                       15.0                         10 5                 15
1930540 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_11                         7.0 3.0                       10.0                         7 3                 10
1930541 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_12                         2.0 4.0                       6.0                         2 4                 6
1930542 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_2                         2.0 2.0                       4.0                         2 2                 4
1930543 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_3                         4.0 5.0                       9.0                         4 5                 9
1930544 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_4                         6.0 1.0                       7.0                         6 1                 7
1930545 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_5                         4.0 2.0                       6.0                         4 2                 6
1930546 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_6                         3.0 3.0                       6.0                         3 3                 6
1930547 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_7                         4.0 4.0                       8.0                         4 4                 8
1930548 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1930549 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_9                         6.0 5.0                       11.0                         6 5                 11
1930550 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   kindergarten                         3.0 3.0                       6.0                         3 3                 6
1930551 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   pk_12_total 65.0 23.0 17.0     2.0         7.0   66.0 48.0     4.0         112.0   105.0   114.0 65 23 17     2         7   66 48     4     112 105   114
1930552 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1930553 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   adult                         4.0 4.0                       8.0                         4 4                 8
1930554 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_1                         5.0 8.0                       13.0                         5 8                 13
1930555 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_10                         12.0 13.0                       25.0                         12 13                 25
1930556 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_11                         7.0 16.0                       23.0                         7 16                 23
1930557 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_12                         16.0 18.0                       34.0                         16 18                 34
1930558 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_2                         9.0 10.0                       19.0                         9 10                 19
1930559 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_3                         6.0 20.0                       26.0                         6 20                 26
1930560 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_4                         12.0 6.0                       18.0                         12 6                 18
1930561 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_5                         8.0 10.0                       18.0                         8 10                 18
1930562 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_6                         8.0 8.0                       16.0                         8 8                 16
1930563 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_7                         11.0 11.0                       22.0                         11 11                 22
1930564 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_8                         5.0 7.0                       12.0                         5 7                 12
1930565 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_9                         15.0 16.0                       31.0                         15 16                 31
1930566 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   kindergarten                         9.0 7.0                       16.0                         9 7                 16
1930567 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   pk_12_total 186.0 37.0 39.0     14.0     1.0   25.0   138.0 164.0     28.0         301.0   286.0   302.0 186 37 39     14     1   25   138 164     28     301 286   302
1930568 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   pre_kindergarten                         11.0 10.0                       21.0                         11 10                 21
1930426 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_1                         22.0 34.0                       56.0                         22 34                 56
1930427 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_10                         46.0 36.0                       82.0                         46 36                 82
1930428 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_11                         34.0 33.0                       67.0                         34 33                 67
1930429 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_12                         37.0 28.0                       65.0                         37 28                 65
1930430 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_2                         22.0 30.0                       52.0                         22 30                 52
1930431 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_3                         36.0 30.0                       66.0                         36 30                 66
1930432 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_4                         30.0 32.0                       62.0                         30 32                 62
1930433 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_5                         36.0 45.0                       81.0                         36 45                 81
1930434 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_6                         30.0 31.0                       61.0                         30 31                 61
1930435 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_7                         33.0 27.0                       60.0                         33 27                 60
1930436 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_8                         43.0 42.0                       85.0                         43 42                 85
1930437 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_9                         38.0 38.0                       76.0                         38 38                 76
1930438 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   kindergarten                         22.0 31.0                       53.0                         22 31                 53
1930439 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   pk_12_total 1.0 820.0 33.0               12.0   429.0 437.0     0.0         866.0   87.0   866.0 1 820 33               12   429 437     0     866 87   866
1930266 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_1                         42.0 38.0                       80.0                         42 38                 80
1930267 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_2                         32.0 46.0                       78.0                         32 46                 78
1930268 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_3                         25.0 40.0                       65.0                         25 40                 65
1930269 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_4                         31.0 43.0                       74.0                         31 43                 74
1930270 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_5                         41.0 39.0                       80.0                         41 39                 80
1930271 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_6                         33.0 45.0                       78.0                         33 45                 78
1930272 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_7                         38.0 40.0                       78.0                         38 40                 78
1930273 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   grade_8                         28.0 40.0                       68.0                         28 40                 68
1930274 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   kindergarten                         45.0 38.0                       83.0                         45 38                 83
1930275 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes Elementary KG 08 2021   pk_12_total 18.0 589.0 38.0 2.0   1.0         36.0   315.0 369.0     8.0         643.0   98.0   684.0 18 589 38 2   1         36   315 369     8     643 98   684
1930392 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2021   grade_6                         61.0 61.0                       122.0                         61 61                 122
1930393 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2021   grade_7                         61.0 63.0                       124.0                         61 63                 124
1930394 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2021   grade_8                         52.0 76.0                       128.0                         52 76                 128
1930395 IN     school 1800028 9400   KIPP Indy College Prep Middle 180002802136 5860 KIPP Indy College Prep Middle   Regular School Yes Middle 06 08 2021   pk_12_total 14.0 315.0 28.0     1.0         16.0   174.0 200.0     22.0         349.0   61.0   374.0 14 315 28     1         16   174 200     22     349 61   374
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
1919021 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_10                         326.0 309.0                       635.0                         326 309                 635
1919022 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_11                         334.0 324.0                       658.0                         334 324                 658
1919023 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_12                         302.0 275.0                       577.0                         302 275                 577
1919024 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_9                         304.0 329.0                       633.0                         304 329                 633
1919025 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   pk_12_total 1948.0 133.0 180.0 9.0   112.0     4.0   117.0   1266.0 1237.0     18.0         386.0   199.0   2503.0 1948 133 180 9   112     4   117   1266 1237     18     386 199   2503
1919037 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_6                         176.0 169.0                       345.0                         176 169                 345
1919038 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_7                         162.0 163.0                       325.0                         162 163                 325
1919039 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   grade_8                         173.0 180.0                       353.0                         173 180                 353
1919040 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2021   pk_12_total 711.0 114.0 73.0 2.0   64.0     5.0   54.0   511.0 512.0     19.0         214.0   73.0   1023.0 711 114 73 2   64     5   54   511 512     19     214 73   1023
1919013 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_1                         55.0 38.0                       93.0                         55 38                 93
1919014 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_2                         35.0 41.0                       76.0                         35 41                 76
1919015 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_3                         47.0 42.0                       89.0                         47 42                 89
1919016 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_4                         40.0 44.0                       84.0                         40 44                 84
1919017 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   grade_5                         50.0 42.0                       92.0                         50 42                 92
1919018 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2021   kindergarten                         50.0 43.0                       93.0                         50 43                 93

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