enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2017 · 12,058 ✖
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
1292914 1292914 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 36.0                       86.0                         50 36                 86
1292915 1292915 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_7                         38.0 42.0                       80.0                         38 42                 80
1292916 1292916 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_8                         48.0 55.0                       103.0                         48 55                 103
1292917 1292917 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 253.0 3.0 6.0 1.0   3.0         3.0   136.0 133.0     5.0             16.0   269.0 253 3 6 1   3         3   136 133     5       16   269
1292918 1292918 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_1                         54.0 40.0                       94.0                         54 40                 94
1292919 1292919 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_2                         53.0 52.0                       105.0                         53 52                 105
1292920 1292920 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_3                         63.0 38.0                       101.0                         63 38                 101
1292921 1292921 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_4                         51.0 52.0                       103.0                         51 52                 103
1292922 1292922 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_5                         50.0 51.0                       101.0                         50 51                 101
1292923 1292923 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         62.0 42.0                       104.0                         62 42                 104
1292924 1292924 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 566.0 8.0 25.0     4.0         9.0   335.0 277.0     22.0             88.0   612.0 566 8 25     4         9   335 277     22       88   612
1292925 1292925 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1292926 1292926 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   adult                         2.0 1.0                       3.0                         2 1                 3
1292927 1292927 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_10                         46.0 55.0                       101.0                         46 55                 101
1292928 1292928 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_11                         48.0 33.0                       81.0                         48 33                 81
1292929 1292929 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_12                         45.0 57.0                       102.0                         45 57                 102
1292930 1292930 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_9                         42.0 49.0                       91.0                         42 49                 91
1292931 1292931 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   pk_12_total 358.0   9.0 2.0   8.0         1.0   183.0 195.0     8.0             28.0   378.0 358   9 2   8         1   183 195     8       28   378
1292932 1292932 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_10                         95.0 85.0                       180.0                         95 85                 180
1292933 1292933 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_11                         70.0 76.0                       146.0                         70 76                 146
1292934 1292934 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_12                         94.0 88.0                       182.0                         94 88                 182
1292935 1292935 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_9                         85.0 98.0                       183.0                         85 98                 183
1292936 1292936 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   pk_12_total 571.0 6.0 88.0 8.0   6.0         12.0   344.0 347.0     3.0             62.0   691.0 571 6 88 8   6         12   344 347     3       62   691
1292937 1292937 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_5                         51.0 52.0                       103.0                         51 52                 103
1292938 1292938 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_6                         46.0 63.0                       109.0                         46 63                 109
1292939 1292939 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_7                         69.0 54.0                       123.0                         69 54                 123
1292940 1292940 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   grade_8                         61.0 69.0                       130.0                         61 69                 130
1292941 1292941 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2017   pk_12_total 380.0 9.0 57.0 1.0             18.0   227.0 238.0     4.0             79.0   465.0 380 9 57 1             18   227 238     4       79   465
1292942 1292942 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   grade_2                         60.0 62.0                       122.0                         60 62                 122
1292943 1292943 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   grade_3                         63.0 64.0                       127.0                         63 64                 127
1292944 1292944 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   grade_4                         50.0 61.0                       111.0                         50 61                 111
1292945 1292945 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No Elementary 02 04 2017   pk_12_total 290.0 10.0 39.0     3.0     2.0   16.0   173.0 187.0     2.0             70.0   360.0 290 10 39     3     2   16   173 187     2       70   360
1292946 1292946 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   grade_1                         66.0 49.0                       115.0                         66 49                 115
1292947 1292947 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   kindergarten                         63.0 62.0                       125.0                         63 62                 125
1292948 1292948 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   pk_12_total 230.0 9.0 38.0     1.0     1.0   14.0   156.0 137.0     1.0             49.0   293.0 230 9 38     1     1   14   156 137     1       49   293
1292949 1292949 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   pre_kindergarten                         27.0 26.0                       53.0                         27 26                 53
1292950 1292950 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2017   grade_6                         42.0 43.0                       85.0                         42 43                 85
1292951 1292951 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2017   grade_7                         59.0 53.0                       112.0                         59 53                 112
1292952 1292952 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2017   grade_8                         65.0 48.0                       113.0                         65 48                 113
1292953 1292953 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2017   pk_12_total 260.0 4.0 36.0 1.0   7.0         2.0   166.0 144.0     15.0             34.0   310.0 260 4 36 1   7         2   166 144     15       34   310
1292954 1292954 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_10                         37.0 42.0                       79.0                         37 42                 79
1292955 1292955 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_11                         41.0 50.0                       91.0                         41 50                 91
1292956 1292956 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_12                         51.0 47.0                       98.0                         51 47                 98
1292957 1292957 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_9                         57.0 44.0                       101.0                         57 44                 101
1292958 1292958 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   pk_12_total 310.0 2.0 43.0 3.0   6.0         5.0   186.0 183.0     10.0             36.0   369.0 310 2 43 3   6         5   186 183     10       36   369
1292959 1292959 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_1                         48.0 58.0                       106.0                         48 58                 106
1292960 1292960 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_2                         39.0 43.0                       82.0                         39 43                 82
1292961 1292961 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_3                         43.0 51.0                       94.0                         43 51                 94
1292962 1292962 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_4                         50.0 46.0                       96.0                         50 46                 96
1292963 1292963 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   grade_5                         42.0 49.0                       91.0                         42 49                 91
1292964 1292964 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         64.0 40.0                       104.0                         64 40                 104
1292965 1292965 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 521.0 3.0 74.0 2.0   6.0         13.0   313.0 306.0     63.0             125.0   619.0 521 3 74 2   6         13   313 306     63       125   619
1292966 1292966 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         27.0 19.0                       46.0                         27 19                 46
1292967 1292967 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_1                         33.0 22.0                       55.0                         33 22                 55
1292968 1292968 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_2                         47.0 38.0                       85.0                         47 38                 85
1292969 1292969 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_3                         39.0 50.0                       89.0                         39 50                 89
1292970 1292970 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_4                         60.0 47.0                       107.0                         60 47                 107
1292971 1292971 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_5                         53.0 45.0                       98.0                         53 45                 98
1292972 1292972 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         13.0 21.0                       34.0                         13 21                 34
1292973 1292973 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 376.0 8.0 20.0 1.0   38.0         25.0   245.0 223.0     1.0             16.0   468.0 376 8 20 1   38         25   245 223     1       16   468
1292974 1292974 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   grade_1                         42.0 39.0                       81.0                         42 39                 81
1292975 1292975 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   grade_2                         35.0 37.0                       72.0                         35 37                 72
1292976 1292976 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   grade_3                         50.0 34.0                       84.0                         50 34                 84
1292977 1292977 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   grade_4                         35.0 37.0                       72.0                         35 37                 72
1292978 1292978 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   grade_5                         26.0 42.0                       68.0                         26 42                 68
1292979 1292979 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   kindergarten                         43.0 38.0                       81.0                         43 38                 81
1292980 1292980 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   pk_12_total 339.0 39.0 34.0 2.0   35.0     2.0   34.0   250.0 235.0     17.0             50.0   485.0 339 39 34 2   35     2   34   250 235     17       50   485
1292981 1292981 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elementary Sch   Regular School No Elementary PK 05 2017   pre_kindergarten                         19.0 8.0                       27.0                         19 8                 27
1292982 1292982 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_10                         298.0 300.0                       598.0                         298 300                 598
1292983 1292983 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_11                         292.0 279.0                       571.0                         292 279                 571
1292984 1292984 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_12                         305.0 282.0                       587.0                         305 282                 587
1292985 1292985 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_9                         301.0 291.0                       592.0                         301 291                 592
1292986 1292986 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   pk_12_total 1911.0 134.0 117.0 5.0   94.0     2.0   85.0   1196.0 1152.0     5.0             201.0   2348.0 1911 134 117 5   94     2   85   1196 1152     5       201   2348
1292987 1292987 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_6                         114.0 114.0                       228.0                         114 114                 228
1292988 1292988 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_7                         125.0 123.0                       248.0                         125 123                 248
1292989 1292989 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_8                         122.0 108.0                       230.0                         122 108                 230
1292990 1292990 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   pk_12_total 584.0 21.0 44.0 4.0   21.0         32.0   361.0 345.0     2.0             66.0   706.0 584 21 44 4   21         32   361 345     2       66   706
1292991 1292991 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_1                         61.0 48.0                       109.0                         61 48                 109
1292992 1292992 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_2                         40.0 44.0                       84.0                         40 44                 84
1292993 1292993 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_3                         50.0 42.0                       92.0                         50 42                 92
1292994 1292994 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_4                         54.0 39.0                       93.0                         54 39                 93
1292995 1292995 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   grade_5                         42.0 52.0                       94.0                         42 52                 94
1292996 1292996 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   kindergarten                         43.0 43.0                       86.0                         43 43                 86
1292997 1292997 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No Elementary KG 05 2017   pk_12_total 493.0 18.0 20.0 2.0   7.0         18.0   290.0 268.0     1.0             36.0   558.0 493 18 20 2   7         18   290 268     1       36   558
1292998 1292998 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_6                         172.0 152.0                       324.0                         172 152                 324
1292999 1292999 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_7                         183.0 186.0                       369.0                         183 186                 369
1293000 1293000 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   grade_8                         171.0 169.0                       340.0                         171 169                 340
1293001 1293001 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000005 67 Woodside Middle School   Regular School No Middle 06 08 2017   pk_12_total 813.0 55.0 51.0 3.0   60.0     3.0   48.0   526.0 507.0     5.0             73.0   1033.0 813 55 51 3   60     3   48   526 507     5       73   1033
1293002 1293002 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_1                         33.0 40.0                       73.0                         33 40                 73
1293003 1293003 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_2                         43.0 29.0                       72.0                         43 29                 72
1293004 1293004 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_3                         24.0 28.0                       52.0                         24 28                 52
1293005 1293005 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_4                         26.0 25.0                       51.0                         26 25                 51
1293006 1293006 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   grade_5                         37.0 34.0                       71.0                         37 34                 71
1293007 1293007 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         39.0 33.0                       72.0                         39 33                 72
1293008 1293008 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 342.0 10.0 17.0 1.0   5.0         16.0   202.0 189.0     1.0             37.0   391.0 342 10 17 1   5         16   202 189     1       37   391
1293009 1293009 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_1                         35.0 30.0                       65.0                         35 30                 65
1293010 1293010 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_2                         35.0 40.0                       75.0                         35 40                 75
1293011 1293011 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_3                         27.0 31.0                       58.0                         27 31                 58
1293012 1293012 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_4                         38.0 42.0                       80.0                         38 42                 80
1293013 1293013 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No Elementary KG 05 2017   grade_5                         42.0 28.0                       70.0                         42 28                 70

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