enrollments

Data source: Big Local News · About: Big Local

84,143 rows where state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1160076 1160076 IN     school 1800360 365   Bartholomew Con School Corp 180036002506 354 Richard L Johnson Early Educ Cntr   Regular School No 1.0 PK PK 2015   pre_kindergarten                         47.0 57.0                       104.0                         47 57                 104
1160077 1160077 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         56.0 38.0                       94.0                         56 38                 94
1160078 1160078 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         51.0 46.0                       97.0                         51 46                 97
1160079 1160079 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         49.0 51.0                       100.0                         49 51                 100
1160080 1160080 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         54.0 44.0                       98.0                         54 44                 98
1160081 1160081 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         68.0 63.0                       131.0                         68 63                 131
1160082 1160082 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         55.0 64.0                       119.0                         55 64                 119
1160083 1160083 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         56.0 42.0                       98.0                         56 42                 98
1160084 1160084 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 505.0 12.0 162.0 5.0   114.0     1.0   32.0   449.0 382.0     134.0             101.0   831.0 505 12 162 5   114     1   32   449 382     134       101   831
1160085 1160085 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         60.0 34.0                       94.0                         60 34                 94
1160086 1160086 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   grade_1                         29.0 39.0                       68.0                         29 39                 68
1160087 1160087 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   grade_2                         45.0 37.0                       82.0                         45 37                 82
1160088 1160088 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   grade_3                         42.0 53.0                       95.0                         42 53                 95
1160089 1160089 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   grade_4                         26.0 45.0                       71.0                         26 45                 71
1160090 1160090 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   grade_5                         35.0 42.0                       77.0                         35 42                 77
1160091 1160091 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   grade_6                         43.0 31.0                       74.0                         43 31                 74
1160092 1160092 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   kindergarten                         45.0 35.0                       80.0                         45 35                 80
1160093 1160093 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   pk_12_total 438.0 6.0 89.0 5.0   11.0     1.0   21.0   278.0 293.0     48.0             65.0   571.0 438 6 89 5   11     1   21   278 293     48       65   571
1160094 1160094 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   pre_kindergarten                         13.0 11.0                       24.0                         13 11                 24
1160095 1160095 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         28.0 24.0                       52.0                         28 24                 52
1160096 1160096 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         27.0 29.0                       56.0                         27 29                 56
1160097 1160097 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         29.0 22.0                       51.0                         29 22                 51
1160098 1160098 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         24.0 28.0                       52.0                         24 28                 52
1160099 1160099 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         31.0 31.0                       62.0                         31 31                 62
1160100 1160100 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         24.0 29.0                       53.0                         24 29                 53
1160101 1160101 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         24.0 24.0                       48.0                         24 24                 48
1160102 1160102 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 346.0 3.0 27.0 3.0             15.0   199.0 195.0     18.0             36.0   394.0 346 3 27 3             15   199 195     18       36   394
1160103 1160103 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1160104 1160104 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_1                         65.0 63.0                       128.0                         65 63                 128
1160105 1160105 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_2                         55.0 52.0                       107.0                         55 52                 107
1160106 1160106 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_3                         47.0 52.0                       99.0                         47 52                 99
1160107 1160107 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_4                         44.0 48.0                       92.0                         44 48                 92
1160108 1160108 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_5                         47.0 40.0                       87.0                         47 40                 87
1160109 1160109 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_6                         40.0 47.0                       87.0                         40 47                 87
1160110 1160110 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   kindergarten                         67.0 53.0                       120.0                         67 53                 120
1160111 1160111 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   pk_12_total 534.0 33.0 85.0 4.0   18.0         46.0   365.0 355.0     55.0             118.0   720.0 534 33 85 4   18         46   365 355     55       118   720
1160112 1160112 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   grade_1                         28.0 37.0                       65.0                         28 37                 65
1160113 1160113 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   grade_2                         30.0 40.0                       70.0                         30 40                 70
1160114 1160114 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   grade_3                         32.0 35.0                       67.0                         32 35                 67
1160115 1160115 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   grade_4                         40.0 38.0                       78.0                         40 38                 78
1160116 1160116 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   grade_5                         27.0 28.0                       55.0                         27 28                 55
1160117 1160117 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   grade_6                         32.0 27.0                       59.0                         32 27                 59
1160118 1160118 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   kindergarten                         37.0 35.0                       72.0                         37 35                 72
1160119 1160119 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 397.0 13.0 47.0 2.0   10.0         24.0   238.0 255.0     26.0             84.0   493.0 397 13 47 2   10         24   238 255     26       84   493
1160120 1160120 IN     school 1800360 365   Bartholomew Con School Corp 180036000070 371 L F Smith Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 15.0                       27.0                         12 15                 27
1160121 1160121 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   grade_1                         32.0 18.0                       50.0                         32 18                 50
1160122 1160122 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   grade_2                         27.0 26.0                       53.0                         27 26                 53
1160123 1160123 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   grade_3                         23.0 25.0                       48.0                         23 25                 48
1160124 1160124 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   grade_4                         22.0 21.0                       43.0                         22 21                 43
1160125 1160125 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   grade_5                         26.0 20.0                       46.0                         26 20                 46
1160126 1160126 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   grade_6                         25.0 27.0                       52.0                         25 27                 52
1160127 1160127 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   kindergarten                         26.0 26.0                       52.0                         26 26                 52
1160128 1160128 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   pk_12_total 266.0 8.0 47.0     39.0     1.0   14.0   198.0 177.0     46.0             48.0   375.0 266 8 47     39     1   14   198 177     46       48   375
1160129 1160129 IN     school 1800360 365   Bartholomew Con School Corp 180036002492 375 CSA Fodrea Campus   Regular School No 1.0 PK 06 2015   pre_kindergarten                         17.0 14.0                       31.0                         17 14                 31
1160130 1160130 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   grade_1                         58.0 41.0                       99.0                         58 41                 99
1160131 1160131 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   grade_2                         44.0 43.0                       87.0                         44 43                 87
1160132 1160132 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   grade_3                         41.0 32.0                       73.0                         41 32                 73
1160133 1160133 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   grade_4                         49.0 34.0                       83.0                         49 34                 83
1160134 1160134 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   grade_5                         34.0 42.0                       76.0                         34 42                 76
1160135 1160135 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   grade_6                         30.0 24.0                       54.0                         30 24                 54
1160136 1160136 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   kindergarten                         46.0 41.0                       87.0                         46 41                 87
1160137 1160137 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   pk_12_total 353.0 6.0 235.0 3.0   5.0     1.0   9.0   330.0 282.0     147.0             51.0   612.0 353 6 235 3   5     1   9   330 282     147       51   612
1160138 1160138 IN     school 1800360 365   Bartholomew Con School Corp 180036000081 377 Taylorsville Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         28.0 25.0                       53.0                         28 25                 53
1160139 1160139 IN     school 1800360 365   Bartholomew Con School Corp 180036000063 390 Central Middle School   Regular School No 2.0 07 08 2015   grade_7                         183.0 205.0                       388.0                         183 205                 388
1160140 1160140 IN     school 1800360 365   Bartholomew Con School Corp 180036000063 390 Central Middle School   Regular School No 2.0 07 08 2015   grade_8                         206.0 205.0                       411.0                         206 205                 411
1160141 1160141 IN     school 1800360 365   Bartholomew Con School Corp 180036000063 390 Central Middle School   Regular School No 2.0 07 08 2015   pk_12_total 623.0 27.0 69.0 2.0   31.0         47.0   389.0 410.0     43.0             107.0   799.0 623 27 69 2   31         47   389 410     43       107   799
1160142 1160142 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         57.0 63.0                       120.0                         57 63                 120
1160143 1160143 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         62.0 70.0                       132.0                         62 70                 132
1160144 1160144 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         76.0 47.0                       123.0                         76 47                 123
1160145 1160145 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         66.0 62.0                       128.0                         66 62                 128
1160146 1160146 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         66.0 68.0                       134.0                         66 68                 134
1160147 1160147 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         66.0 62.0                       128.0                         66 62                 128
1160148 1160148 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         54.0 70.0                       124.0                         54 70                 124
1160149 1160149 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 609.0 17.0 79.0 8.0   174.0     1.0   28.0   461.0 455.0     127.0             91.0   916.0 609 17 79 8   174     1   28   461 455     127       91   916
1160150 1160150 IN     school 1800360 365   Bartholomew Con School Corp 180036000080 392 Southside Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         14.0 13.0                       27.0                         14 13                 27
1160151 1160151 IN     school 1800360 365   Bartholomew Con School Corp 180036000076 395 Northside Middle School   Regular School No 2.0 07 08 2015   grade_7                         192.0 192.0                       384.0                         192 192                 384
1160152 1160152 IN     school 1800360 365   Bartholomew Con School Corp 180036000076 395 Northside Middle School   Regular School No 2.0 07 08 2015   grade_8                         229.0 242.0                       471.0                         229 242                 471
1160153 1160153 IN     school 1800360 365   Bartholomew Con School Corp 180036000076 395 Northside Middle School   Regular School No 2.0 07 08 2015   pk_12_total 640.0 24.0 123.0 2.0   38.0         28.0   421.0 434.0     68.0             119.0   855.0 640 24 123 2   38         28   421 434     68       119   855
1160154 1160154 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2015   grade_10                         274.0 257.0                       531.0                         274 257                 531
1160155 1160155 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2015   grade_11                         217.0 248.0                       465.0                         217 248                 465
1160156 1160156 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2015   grade_12                         279.0 244.0                       523.0                         279 244                 523
1160157 1160157 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2015   grade_9                         273.0 252.0                       525.0                         273 252                 525
1160158 1160158 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No 3.0 09 12 2015   pk_12_total 1618.0 31.0 176.0 17.0   107.0         95.0   1043.0 1001.0     96.0             221.0   2044.0 1618 31 176 17   107         95   1043 1001     96       221   2044
1160159 1160159 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2015   grade_10                         202.0 181.0                       383.0                         202 181                 383
1160160 1160160 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2015   grade_11                         213.0 169.0                       382.0                         213 169                 382
1160161 1160161 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2015   grade_12                         205.0 167.0                       372.0                         205 167                 372
1160162 1160162 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2015   grade_9                         234.0 188.0                       422.0                         234 188                 422
1160163 1160163 IN     school 1800360 365   Bartholomew Con School Corp 180036000065 399 Columbus East High School   Regular School No 3.0 09 12 2015   pk_12_total 1346.0 36.0 80.0 6.0   29.0         62.0   854.0 705.0     35.0             189.0   1559.0 1346 36 80 6   29         62   854 705     35       189   1559
1160164 1160164 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         34.0 31.0                       65.0                         34 31                 65
1160165 1160165 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         42.0 32.0                       74.0                         42 32                 74
1160166 1160166 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         34.0 22.0                       56.0                         34 22                 56
1160167 1160167 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         24.0 35.0                       59.0                         24 35                 59
1160168 1160168 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         45.0 32.0                       77.0                         45 32                 77
1160169 1160169 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         42.0 34.0                       76.0                         42 34                 76
1160170 1160170 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1160171 1160171 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   pk_12_total 438.0 2.0 10.0     5.0         15.0   253.0 217.0     6.0             62.0   470.0 438 2 10     5         15   253 217     6       62   470
1160172 1160172 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000509 410 Hauser Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_10                         31.0 28.0                       59.0                         31 28                 59
1160173 1160173 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000509 410 Hauser Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         40.0 31.0                       71.0                         40 31                 71
1160174 1160174 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000509 410 Hauser Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_12                         30.0 28.0                       58.0                         30 28                 58
1160175 1160175 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000509 410 Hauser Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         29.0 28.0                       57.0                         29 28                 57

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