Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2017 · 11,958
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
1296407 IN     school 1808100 3295   North West Hendricks Schools 180810002465 2684 Pittsboro Primary School   Regular School No Elementary PK 02 2017   kindergarten                         49.0 39.0                       88.0                         49 39                 88
1296408 IN     school 1808100 3295   North West Hendricks Schools 180810002465 2684 Pittsboro Primary School   Regular School No Elementary PK 02 2017   pk_12_total 272.0 5.0 3.0 1.0   1.0     1.0   4.0   165.0 122.0     3.0             50.0   287.0 272 5 3 1   1     1   4   165 122     3       50   287
1296409 IN     school 1808100 3295   North West Hendricks Schools 180810002465 2684 Pittsboro Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         12.0 4.0                       16.0                         12 4                 16
1297501 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2017   grade_1                         40.0 49.0                       89.0                         40 49                 89
1297502 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2017   grade_2                         56.0 42.0                       98.0                         56 42                 98
1297503 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2017   kindergarten                         69.0 46.0                       115.0                         69 46                 115
1297504 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2017   pk_12_total 283.0 2.0 13.0 1.0             3.0   165.0 137.0     0.0             54.0   302.0 283 2 13 1             3   165 137     0       54   302
1298030 IN     school 1802490 4660   Crown Point Community School Corp 180249000300 3854 Winfield Elementary School   Regular School No Elementary KG 02 2017   grade_1                         105.0 84.0                       189.0                         105 84                 189
1298031 IN     school 1802490 4660   Crown Point Community School Corp 180249000300 3854 Winfield Elementary School   Regular School No Elementary KG 02 2017   grade_2                         77.0 90.0                       167.0                         77 90                 167
1298032 IN     school 1802490 4660   Crown Point Community School Corp 180249000300 3854 Winfield Elementary School   Regular School No Elementary KG 02 2017   kindergarten                         73.0 64.0                       137.0                         73 64                 137
1298033 IN     school 1802490 4660   Crown Point Community School Corp 180249000300 3854 Winfield Elementary School   Regular School No Elementary KG 02 2017   pk_12_total 365.0 16.0 79.0 1.0   17.0         15.0   255.0 238.0     21.0             54.0   493.0 365 16 79 1   17         15   255 238     21       54   493
1298852 IN     school 1807860 5075   North Lawrence Com Schools 180786001345 4917 Parkview Primary School   Regular School No Elementary PK 02 2017   grade_1                         35.0 32.0                       67.0                         35 32                 67
1298853 IN     school 1807860 5075   North Lawrence Com Schools 180786001345 4917 Parkview Primary School   Regular School No Elementary PK 02 2017   grade_2                         34.0 37.0                       71.0                         34 37                 71
1298854 IN     school 1807860 5075   North Lawrence Com Schools 180786001345 4917 Parkview Primary School   Regular School No Elementary PK 02 2017   kindergarten                         48.0 24.0                       72.0                         48 24                 72
1298855 IN     school 1807860 5075   North Lawrence Com Schools 180786001345 4917 Parkview Primary School   Regular School No Elementary PK 02 2017   pk_12_total 233.0 2.0 16.0     2.0         8.0   156.0 105.0     1.0             93.0   261.0 233 2 16     2         8   156 105     1       93   261
1298856 IN     school 1807860 5075   North Lawrence Com Schools 180786001345 4917 Parkview Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         39.0 12.0                       51.0                         39 12                 51
1298872 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2017   grade_1                         68.0 54.0                       122.0                         68 54                 122
1298873 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2017   grade_2                         72.0 63.0                       135.0                         72 63                 135
1298874 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         61.0 52.0                       113.0                         61 52                 113
1298875 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 382.0 1.0 12.0 1.0   1.0         10.0   227.0 180.0     1.0             118.0   407.0 382 1 12 1   1         10   227 180     1       118   407
1298876 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         26.0 11.0                       37.0                         26 11                 37
1298963 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   grade_1                         53.0 43.0                       96.0                         53 43                 96
1298964 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   grade_2                         63.0 64.0                       127.0                         63 64                 127
1298965 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   kindergarten                         56.0 47.0                       103.0                         56 47                 103
1298966 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   pk_12_total 303.0 1.0 38.0               15.0   192.0 165.0     8.0             75.0   357.0 303 1 38               15   192 165     8       75   357
1298967 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten                         20.0 11.0                       31.0                         20 11                 31
1299034 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2017   grade_1                         61.0 74.0                       135.0                         61 74                 135
1299035 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2017   grade_2                         42.0 59.0                       101.0                         42 59                 101
1299036 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         70.0 51.0                       121.0                         70 51                 121
1299037 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 464.0 1.0 43.0 2.0   4.0     2.0   20.0   265.0 271.0     9.0             73.0   536.0 464 1 43 2   4     2   20   265 271     9       73   536
1299038 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         92.0 87.0                       179.0                         92 87                 179
1300468 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2017   grade_1                         62.0 61.0                       123.0                         62 61                 123
1300469 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2017   grade_2                         69.0 67.0                       136.0                         69 67                 136
1300470 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1300471 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 350.0 5.0 15.0               13.0   196.0 187.0     6.0             40.0   383.0 350 5 15               13   196 187     6       40   383
1300472 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         14.0 10.0                       24.0                         14 10                 24
1300499 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2017   grade_1                         73.0 71.0                       144.0                         73 71                 144
1300500 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2017   grade_2                         76.0 73.0                       149.0                         76 73                 149
1300501 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2017   kindergarten                         72.0 61.0                       133.0                         72 61                 133
1300502 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2017   pk_12_total 444.0 12.0 11.0 1.0             35.0   254.0 249.0     2.0             60.0   503.0 444 12 11 1             35   254 249     2       60   503
1300503 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No Elementary PK 02 2017   pre_kindergarten                         33.0 44.0                       77.0                         33 44                 77
1300523 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No Elementary KG 02 2017   grade_1                         122.0 83.0                       205.0                         122 83                 205
1300524 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No Elementary KG 02 2017   grade_2                         94.0 101.0                       195.0                         94 101                 195
1300525 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No Elementary KG 02 2017   kindergarten                         93.0 83.0                       176.0                         93 83                 176
1300526 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No Elementary KG 02 2017   pk_12_total 511.0 5.0 23.0 2.0   1.0     1.0   33.0   309.0 267.0     5.0             106.0   576.0 511 5 23 2   1     1   33   309 267     5       106   576
1300649 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000132 6217 Rogers Elementary School   Regular School No Elementary KG 02 2017   grade_1                         70.0 63.0                       133.0                         70 63                 133
1300650 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000132 6217 Rogers Elementary School   Regular School No Elementary KG 02 2017   grade_2                         68.0 59.0                       127.0                         68 59                 127
1300651 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000132 6217 Rogers Elementary School   Regular School No Elementary KG 02 2017   kindergarten                         65.0 54.0                       119.0                         65 54                 119
1300652 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000132 6217 Rogers Elementary School   Regular School No Elementary KG 02 2017   pk_12_total 269.0 13.0 17.0 1.0   54.0         25.0   203.0 176.0     53.0             32.0   379.0 269 13 17 1   54         25   203 176     53       32   379
1301749 IN     school 1803990 6755   Greencastle Community School Corp 180399000691 7105 Martha J Ridpath Elementary School   Regular School No Elementary KG 02 2017   grade_1                         27.0 34.0                       61.0                         27 34                 61
1301750 IN     school 1803990 6755   Greencastle Community School Corp 180399000691 7105 Martha J Ridpath Elementary School   Regular School No Elementary KG 02 2017   grade_2                         30.0 24.0                       54.0                         30 24                 54
1301751 IN     school 1803990 6755   Greencastle Community School Corp 180399000691 7105 Martha J Ridpath Elementary School   Regular School No Elementary KG 02 2017   kindergarten                         42.0 33.0                       75.0                         42 33                 75
1301752 IN     school 1803990 6755   Greencastle Community School Corp 180399000691 7105 Martha J Ridpath Elementary School   Regular School No Elementary KG 02 2017   pk_12_total 172.0 2.0 2.0     1.0         13.0   99.0 91.0     1.0             20.0   190.0 172 2 2     1         13   99 91     1       20   190
1301753 IN     school 1803990 6755   Greencastle Community School Corp 180399001625 7107 Deer Meadow Primary School   Regular School No Elementary PK 02 2017   grade_1                         56.0 41.0                       97.0                         56 41                 97
1301754 IN     school 1803990 6755   Greencastle Community School Corp 180399001625 7107 Deer Meadow Primary School   Regular School No Elementary PK 02 2017   grade_2                         43.0 33.0                       76.0                         43 33                 76
1301755 IN     school 1803990 6755   Greencastle Community School Corp 180399001625 7107 Deer Meadow Primary School   Regular School No Elementary PK 02 2017   kindergarten                         46.0 41.0                       87.0                         46 41                 87
1301756 IN     school 1803990 6755   Greencastle Community School Corp 180399001625 7107 Deer Meadow Primary School   Regular School No Elementary PK 02 2017   pk_12_total 305.0 2.0 4.0     10.0         3.0   183.0 141.0     10.0             70.0   324.0 305 2 4     10         3   183 141     10       70   324
1301757 IN     school 1803990 6755   Greencastle Community School Corp 180399001625 7107 Deer Meadow Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         38.0 26.0                       64.0                         38 26                 64
1301813 IN     school 1801770 6825   Randolph Central School Corp 180177000236 7133 O R Baker Elementary School   Regular School No Elementary PK 02 2017   grade_1                         36.0 41.0                       77.0                         36 41                 77
1301814 IN     school 1801770 6825   Randolph Central School Corp 180177000236 7133 O R Baker Elementary School   Regular School No Elementary PK 02 2017   grade_2                         47.0 53.0                       100.0                         47 53                 100
1301815 IN     school 1801770 6825   Randolph Central School Corp 180177000236 7133 O R Baker Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         36.0 47.0                       83.0                         36 47                 83
1301816 IN     school 1801770 6825   Randolph Central School Corp 180177000236 7133 O R Baker Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 275.0   11.0     1.0         17.0   142.0 162.0     4.0             97.0   304.0 275   11     1         17   142 162     4       97   304
1301817 IN     school 1801770 6825   Randolph Central School Corp 180177000236 7133 O R Baker Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         23.0 21.0                       44.0                         23 21                 44
1301869 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2017   grade_1                         82.0 83.0                       165.0                         82 83                 165
1301870 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2017   grade_2                         75.0 71.0                       146.0                         75 71                 146
1301871 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2017   kindergarten                         79.0 67.0                       146.0                         79 67                 146
1301872 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2017   pk_12_total 426.0 2.0 20.0     17.0         12.0   249.0 228.0     11.0             62.0   477.0 426 2 20     17         12   249 228     11       62   477
1301873 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         13.0 7.0                       20.0                         13 7                 20
1303840 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2017   grade_1                         77.0 60.0                       137.0                         77 60                 137
1303841 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2017   grade_2                         69.0 71.0                       140.0                         69 71                 140
1303842 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         65.0 70.0                       135.0                         65 70                 135
1303843 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 405.0 2.0 3.0     2.0         34.0   232.0 214.0     1.0             69.0   446.0 405 2 3     2         34   232 214     1       69   446
1303844 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         21.0 13.0                       34.0                         21 13                 34
1304021 IN     school 1811430 8535   Tri-County School Corporation 181143001848 3170 Tri-County Primary School   Regular School No Elementary KG 02 2017   grade_1                         24.0 22.0                       46.0                         24 22                 46
1304022 IN     school 1811430 8535   Tri-County School Corporation 181143001848 3170 Tri-County Primary School   Regular School No Elementary KG 02 2017   grade_2                         19.0 23.0                       42.0                         19 23                 42
1304023 IN     school 1811430 8535   Tri-County School Corporation 181143001848 3170 Tri-County Primary School   Regular School No Elementary KG 02 2017   kindergarten                         40.0 49.0                       89.0                         40 49                 89
1304024 IN     school 1811430 8535   Tri-County School Corporation 181143001848 3170 Tri-County Primary School   Regular School No Elementary KG 02 2017   pk_12_total 166.0 2.0 6.0 1.0         1.0   1.0   83.0 94.0     2.0             28.0   177.0 166 2 6 1         1   1   83 94     2       28   177
1304172 IN     school 1800177 9115   Kindezi Academy 180017702608 1118 Kindezi Academy   Regular School Yes Elementary KG 02 2017   grade_1                         26.0 20.0                       46.0                         26 20                 46
1304173 IN     school 1800177 9115   Kindezi Academy 180017702608 1118 Kindezi Academy   Regular School Yes Elementary KG 02 2017   grade_2                         27.0 30.0                       57.0                         27 30                 57
1304174 IN     school 1800177 9115   Kindezi Academy 180017702608 1118 Kindezi Academy   Regular School Yes Elementary KG 02 2017   kindergarten                         37.0 27.0                       64.0                         37 27                 64
1304175 IN     school 1800177 9115   Kindezi Academy 180017702608 1118 Kindezi Academy   Regular School Yes Elementary KG 02 2017   pk_12_total 4.0 147.0 14.0 1.0             1.0   90.0 77.0     10.0             14.0   167.0 4 147 14 1             1   90 77     10       14   167
1304323 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 02 2017   grade_1                         52.0 46.0                       98.0                         52 46                 98
1304324 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 02 2017   grade_2                         57.0 43.0                       100.0                         57 43                 100
1304325 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 02 2017   kindergarten                         56.0 51.0                       107.0                         56 51                 107
1304326 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 02 2017   pk_12_total 6.0 281.0 6.0           1.0   11.0   165.0 140.0     2.0             27.0   305.0 6 281 6           1   11   165 140     2       27   305
1304946 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 02 2017   grade_1                         43.0 35.0                       78.0                         43 35                 78
1304947 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 02 2017   grade_2                         35.0 40.0                       75.0                         35 40                 75
1304948 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 02 2017   kindergarten                         50.0 66.0                       116.0                         50 66                 116
1304949 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 02 2017   pk_12_total 33.0 156.0 67.0     7.0         6.0   128.0 141.0     48.0             22.0   269.0 33 156 67     7         6   128 141     48       22   269
1293457 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   grade_1                         99.0 97.0                       196.0                         99 97                 196
1293458 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   grade_2                         86.0 76.0                       162.0                         86 76                 162
1293459 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   grade_3                         96.0 77.0                       173.0                         96 77                 173
1293460 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   kindergarten                         100.0 74.0                       174.0                         100 74                 174
1293461 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   pk_12_total 642.0 8.0 26.0 2.0   4.0         23.0   381.0 324.0     7.0             47.0   705.0 642 8 26 2   4         23   381 324     7       47   705
1293680 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 03 2017   grade_1                         52.0 48.0                       100.0                         52 48                 100
1293681 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 03 2017   grade_2                         45.0 50.0                       95.0                         45 50                 95
1293682 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 03 2017   grade_3                         44.0 51.0                       95.0                         44 51                 95
1293683 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 03 2017   kindergarten                         52.0 46.0                       98.0                         52 46                 98
1293684 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 03 2017   pk_12_total 358.0 2.0 10.0 1.0   1.0         16.0   193.0 195.0     4.0             52.0   388.0 358 2 10 1   1         16   193 195     4       52   388
1293893 IN     school 1810680 815   Southeastern School Corp 181068002169 695 Thompson Elementary School   Regular School No Elementary KG 03 2017   grade_1                         42.0 46.0                       88.0                         42 46                 88

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