enrollments

Data source: Big Local News · About: Big Local

11,966 rows where state = "IN" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 11,966 ✖
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
1918494 1918494 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_1                         42.0 43.0                       85.0                         42 43                 85
1918495 1918495 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_10                         38.0 62.0                       100.0                         38 62                 100
1918496 1918496 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_11                         30.0 34.0                       64.0                         30 34                 64
1918497 1918497 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_12                         35.0 18.0                       53.0                         35 18                 53
1918498 1918498 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_2                         50.0 47.0                       97.0                         50 47                 97
1918499 1918499 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_3                         51.0 50.0                       101.0                         51 50                 101
1918500 1918500 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_4                         46.0 38.0                       84.0                         46 38                 84
1918501 1918501 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_5                         44.0 46.0                       90.0                         44 46                 90
1918502 1918502 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_6                         53.0 49.0                       102.0                         53 49                 102
1918503 1918503 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_7                         46.0 50.0                       96.0                         46 50                 96
1918504 1918504 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_8                         57.0 57.0                       114.0                         57 57                 114
1918505 1918505 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_9                         58.0 52.0                       110.0                         58 52                 110
1918506 1918506 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   kindergarten                         44.0 50.0                       94.0                         44 50                 94
1918507 1918507 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   pk_12_total 2.0 1118.0 42.0               28.0   594.0 596.0     1.0         918.0   134.0   1190.0 2 1118 42               28   594 596     1     918 134   1190
1918903 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 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 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 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 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 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
1907040 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 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 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 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 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 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 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
1912122 1912122 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_1                         18.0 28.0                       46.0                         18 28                 46
1912123 1912123 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_2                         26.0 18.0                       44.0                         26 18                 44
1912124 1912124 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_3                         21.0 20.0                       41.0                         21 20                 41
1912125 1912125 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_4                         31.0 23.0                       54.0                         31 23                 54
1912126 1912126 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_5                         26.0 13.0                       39.0                         26 13                 39
1912127 1912127 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_6                         21.0 19.0                       40.0                         21 19                 40
1912128 1912128 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   kindergarten                         28.0 30.0                       58.0                         28 30                 58
1912129 1912129 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 7.0 248.0 60.0 2.0             5.0   171.0 151.0     18.0         284.0   74.0   322.0 7 248 60 2             5   171 151     18     284 74   322
1912358 1912358 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_1                         40.0 47.0                       87.0                         40 47                 87
1912359 1912359 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_2                         40.0 46.0                       86.0                         40 46                 86
1912360 1912360 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_3                         40.0 45.0                       85.0                         40 45                 85
1912361 1912361 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_4                         42.0 50.0                       92.0                         42 50                 92
1912362 1912362 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_5                         48.0 58.0                       106.0                         48 58                 106
1912363 1912363 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         30.0 31.0                       61.0                         30 31                 61
1912364 1912364 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 78.0 66.0 382.0     2.0     1.0   28.0   258.0 299.0     141.0         370.0   71.0   557.0 78 66 382     2     1   28   258 299     141     370 71   557
1912365 1912365 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 22.0                       40.0                         18 22                 40
1913266 1913266 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_1                         69.0 74.0                       143.0                         69 74                 143
1913267 1913267 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_2                         84.0 62.0                       146.0                         84 62                 146
1913268 1913268 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_3                         64.0 73.0                       137.0                         64 73                 137
1913269 1913269 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_4                         83.0 75.0                       158.0                         83 75                 158
1913270 1913270 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_5                         81.0 82.0                       163.0                         81 82                 163
1913271 1913271 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         104.0 97.0                       201.0                         104 97                 201
1913272 1913272 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 310.0 116.0 128.0     351.0         67.0   497.0 475.0     389.0         787.0   170.0   972.0 310 116 128     351         67   497 475     389     787 170   972
1913273 1913273 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 12.0                       24.0                         12 12                 24
1917061 1917061 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_1                         5.0 0.0                       5.0                         5 0                 5
1917062 1917062 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_10                         43.0 18.0                       61.0                         43 18                 61
1917063 1917063 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_11                         50.0 38.0                       88.0                         50 38                 88
1917064 1917064 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_12                         40.0 23.0                       63.0                         40 23                 63
1917065 1917065 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_2                         2.0 2.0                       4.0                         2 2                 4
1917066 1917066 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_3                         7.0 1.0                       8.0                         7 1                 8
1917067 1917067 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_4                         13.0 0.0                       13.0                         13 0                 13
1917068 1917068 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_5                         4.0 4.0                       8.0                         4 4                 8
1917069 1917069 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_6                         17.0 2.0                       19.0                         17 2                 19
1917070 1917070 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_7                         20.0 10.0                       30.0                         20 10                 30
1917071 1917071 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_8                         26.0 19.0                       45.0                         26 19                 45
1917072 1917072 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_9                         39.0 16.0                       55.0                         39 16                 55
1917073 1917073 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   pk_12_total 170.0 148.0 17.0 3.0             61.0   266.0 133.0     2.0         321.0   180.0   399.0 170 148 17 3             61   266 133     2     321 180   399
1913665 1913665 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   grade_10                         19.0 24.0                       43.0                         19 24                 43
1913666 1913666 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   grade_11                         29.0 36.0                       65.0                         29 36                 65
1913667 1913667 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   grade_12                         71.0 110.0                       181.0                         71 110                 181
1913668 1913668 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   grade_9                         7.0 11.0                       18.0                         7 11                 18
1913669 1913669 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   pk_12_total 209.0 55.0 23.0     2.0         18.0   126.0 181.0     6.0         40.0   30.0   307.0 209 55 23     2         18   126 181     6     40 30   307
1913080 1913080 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   grade_1                         39.0 33.0                       72.0                         39 33                 72
1913081 1913081 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   grade_2                         32.0 44.0                       76.0                         32 44                 76
1913082 1913082 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   grade_3                         36.0 24.0                       60.0                         36 24                 60
1913083 1913083 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   grade_4                         35.0 34.0                       69.0                         35 34                 69
1913084 1913084 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   grade_5                         47.0 28.0                       75.0                         47 28                 75
1913085 1913085 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         36.0 27.0                       63.0                         36 27                 63
1913086 1913086 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 334.0 20.0 22.0     9.0     1.0   29.0   225.0 190.0     13.0         144.0   76.0   415.0 334 20 22     9     1   29   225 190     13     144 76   415
1906991 1906991 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_1                         49.0 46.0                       95.0                         49 46                 95
1906992 1906992 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_2                         61.0 63.0                       124.0                         61 63                 124
1906993 1906993 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_3                         58.0 41.0                       99.0                         58 41                 99
1906994 1906994 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_4                         52.0 44.0                       96.0                         52 44                 96
1906995 1906995 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_5                         54.0 51.0                       105.0                         54 51                 105
1906996 1906996 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         47.0 45.0                       92.0                         47 45                 92
1906997 1906997 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 585.0 5.0 29.0 1.0   1.0         16.0   334.0 303.0     24.0         161.0   112.0   637.0 585 5 29 1   1         16   334 303     24     161 112   637
1906998 1906998 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         13.0 13.0                       26.0                         13 13                 26
1906999 1906999 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   adult                         1.0 1.0                       2.0                         1 1                 2
1907000 1907000 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_10                         38.0 42.0                       80.0                         38 42                 80
1907001 1907001 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_11                         51.0 56.0                       107.0                         51 56                 107
1907002 1907002 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_12                         39.0 44.0                       83.0                         39 44                 83
1907003 1907003 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_9                         50.0 33.0                       83.0                         50 33                 83
1907004 1907004 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   pk_12_total 334.0 2.0 10.0 1.0   5.0         3.0   179.0 176.0     6.0         75.0   20.0   355.0 334 2 10 1   5         3   179 176     6     75 20   355
1906987 1906987 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_6                         62.0 45.0                       107.0                         62 45                 107
1906988 1906988 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_7                         52.0 53.0                       105.0                         52 53                 105
1906989 1906989 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_8                         49.0 51.0                       100.0                         49 51                 100
1906990 1906990 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   pk_12_total 289.0 3.0 10.0     3.0         7.0   163.0 149.0     3.0         79.0   32.0   312.0 289 3 10     3         7   163 149     3     79 32   312
1907247 1907247 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_1                         21.0 28.0                       49.0                         21 28                 49
1907248 1907248 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_2                         22.0 24.0                       46.0                         22 24                 46
1907249 1907249 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_3                         27.0 24.0                       51.0                         27 24                 51
1907250 1907250 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_4                         20.0 18.0                       38.0                         20 18                 38
1907251 1907251 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_5                         21.0 33.0                       54.0                         21 33                 54
1907252 1907252 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         19.0 22.0                       41.0                         19 22                 41

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