enrollments

Data source: Big Local News · About: Big Local

12,044 rows where state = "IN" and year = 2015 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 12,044 ✖
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
1170753 1170753 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   adult                         22.0 0.0                       22.0                         22 0                 22
1170754 1170754 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_10                         40.0 0.0                       40.0                         40 0                 40
1170755 1170755 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_11                         11.0 0.0                       11.0                         11 0                 11
1170756 1170756 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_12                         7.0 0.0                       7.0                         7 0                 7
1170757 1170757 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_8                         2.0 0.0                       2.0                         2 0                 2
1170758 1170758 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_9                         71.0 0.0                       71.0                         71 0                 71
1170759 1170759 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   pk_12_total 73.0 59.0 11.0 1.0             9.0   153.0 0.0                       153.0 73 59 11 1             9   153 0                 153
1170760 1170760 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1170761 1170761 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_10                         0.0 10.0                       10.0                         0 10                 10
1170762 1170762 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_11                         0.0 7.0                       7.0                         0 7                 7
1170763 1170763 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_12                         0.0 2.0                       2.0                         0 2                 2
1170764 1170764 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_8                         0.0 2.0                       2.0                         0 2                 2
1170765 1170765 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_9                         0.0 25.0                       25.0                         0 25                 25
1170766 1170766 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   pk_12_total 24.0 15.0 2.0     1.0         5.0   0.0 47.0                       47.0 24 15 2     1         5   0 47                 47
1170740 1170740 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   adult                         48.0 0.0                       48.0                         48 0                 48
1170741 1170741 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_10                         17.0 0.0                       17.0                         17 0                 17
1170742 1170742 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_11                         3.0 0.0                       3.0                         3 0                 3
1170743 1170743 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1170744 1170744 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1170745 1170745 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_8                         3.0 0.0                       3.0                         3 0                 3
1170746 1170746 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_9                         49.0 0.0                       49.0                         49 0                 49
1170747 1170747 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   pk_12_total 71.0 28.0 10.0               13.0   122.0 0.0                       122.0 71 28 10               13   122 0                 122
1170748 1170748 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   grade_10                         25.0 0.0                       25.0                         25 0                 25
1170749 1170749 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   grade_11                         23.0 0.0                       23.0                         23 0                 23
1170750 1170750 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   grade_12                         13.0 0.0                       13.0                         13 0                 13
1170751 1170751 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   grade_9                         11.0 0.0                       11.0                         11 0                 11
1170752 1170752 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   pk_12_total 31.0 28.0 7.0           1.0   5.0   72.0 0.0                       72.0 31 28 7           1   5   72 0                 72
1162375 1162375 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         23.0 8.0                       31.0                         23 8                 31
1162376 1162376 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         8.0 16.0                       24.0                         8 16                 24
1162377 1162377 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         19.0 12.0                       31.0                         19 12                 31
1162378 1162378 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         14.0 11.0                       25.0                         14 11                 25
1162379 1162379 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         21.0 14.0                       35.0                         21 14                 35
1162380 1162380 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         25.0 17.0                       42.0                         25 17                 42
1162381 1162381 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         20.0 17.0                       37.0                         20 17                 37
1162382 1162382 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 241.0 1.0 5.0               4.0   148.0 103.0     0.0             51.0   251.0 241 1 5               4   148 103     0       51   251
1162383 1162383 IN     school 1800008 2980   White River Valley Sch Dist 180000802090 2460 Worthington Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         18.0 8.0                       26.0                         18 8                 26
1162359 1162359 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1162360 1162360 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_10                         18.0 28.0                       46.0                         18 28                 46
1162361 1162361 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         35.0 35.0                       70.0                         35 35                 70
1162362 1162362 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_12                         29.0 26.0                       55.0                         29 26                 55
1162363 1162363 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         35.0 31.0                       66.0                         35 31                 66
1162364 1162364 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         27.0 39.0                       66.0                         27 39                 66
1162365 1162365 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_9                         39.0 30.0                       69.0                         39 30                 69
1162366 1162366 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   pk_12_total 363.0 1.0 5.0     3.0         2.0   183.0 191.0     0.0             34.0   374.0 363 1 5     3         2   183 191     0       34   374
1162367 1162367 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         14.0 13.0                       27.0                         14 13                 27
1162368 1162368 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 17.0                       27.0                         10 17                 27
1162369 1162369 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         12.0 9.0                       21.0                         12 9                 21
1162370 1162370 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         11.0 11.0                       22.0                         11 11                 22
1162371 1162371 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         13.0 9.0                       22.0                         13 9                 22
1162372 1162372 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         8.0 15.0                       23.0                         8 15                 23
1162373 1162373 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         17.0 10.0                       27.0                         17 10                 27
1162374 1162374 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   pk_12_total 154.0   8.0     2.0         5.0   85.0 84.0     0.0             24.0   169.0 154   8     2         5   85 84     0       24   169
1170792 1170792 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_1                         19.0 19.0                       38.0                         19 19                 38
1170793 1170793 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_10                         28.0 20.0                       48.0                         28 20                 48
1170794 1170794 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_11                         23.0 15.0                       38.0                         23 15                 38
1170795 1170795 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_12                         16.0 16.0                       32.0                         16 16                 32
1170796 1170796 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_2                         19.0 23.0                       42.0                         19 23                 42
1170797 1170797 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_3                         23.0 28.0                       51.0                         23 28                 51
1170798 1170798 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_4                         18.0 20.0                       38.0                         18 20                 38
1170799 1170799 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_5                         21.0 25.0                       46.0                         21 25                 46
1170800 1170800 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_6                         20.0 19.0                       39.0                         20 19                 39
1170801 1170801 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_7                         21.0 20.0                       41.0                         21 20                 41
1170802 1170802 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_8                         23.0 16.0                       39.0                         23 16                 39
1170803 1170803 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_9                         20.0 19.0                       39.0                         20 19                 39
1170804 1170804 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   kindergarten                         35.0 19.0                       54.0                         35 19                 54
1170805 1170805 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   pk_12_total 475.0 7.0 19.0     9.0     1.0   34.0   286.0 259.0                       545.0 475 7 19     9     1   34   286 259                 545
1170831 1170831 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_1                         22.0 16.0                       38.0                         22 16                 38
1170832 1170832 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_2                         21.0 14.0                       35.0                         21 14                 35
1170833 1170833 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_3                         17.0 7.0                       24.0                         17 7                 24
1170834 1170834 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_4                         16.0 16.0                       32.0                         16 16                 32
1170835 1170835 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_5                         13.0 13.0                       26.0                         13 13                 26
1170836 1170836 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_6                         12.0 7.0                       19.0                         12 7                 19
1170837 1170837 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_7                         14.0 6.0                       20.0                         14 6                 20
1170838 1170838 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   grade_8                         6.0 3.0                       9.0                         6 3                 9
1170839 1170839 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   kindergarten                         26.0 16.0                       42.0                         26 16                 42
1170840 1170840 IN     school 1800012 9340   New Community School 180001201757 1538 New Community School   Regular School Yes 1.0 KG 08 2015   pk_12_total 195.0 10.0 22.0 1.0         1.0   16.0   147.0 98.0                       245.0 195 10 22 1         1   16   147 98                 245
1170847 1170847 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_1                         19.0 21.0                       40.0                         19 21                 40
1170848 1170848 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_2                         26.0 22.0                       48.0                         26 22                 48
1170849 1170849 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_3                         16.0 21.0                       37.0                         16 21                 37
1170850 1170850 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_4                         18.0 8.0                       26.0                         18 8                 26
1170851 1170851 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_5                         11.0 12.0                       23.0                         11 12                 23
1170852 1170852 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   grade_6                         12.0 7.0                       19.0                         12 7                 19
1170853 1170853 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   kindergarten                         30.0 18.0                       48.0                         30 18                 48
1170854 1170854 IN     school 1800013 9350   Timothy L Johnson Academy 180001301774 1539 Timothy L Johnson Academy   Regular School Yes 1.0 KG 06 2015   pk_12_total 2.0 211.0 15.0     1.0     1.0   11.0   132.0 109.0                       241.0 2 211 15     1     1   11   132 109                 241
1170811 1170811 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_1                         37.0 35.0                       72.0                         37 35                 72
1170812 1170812 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_10                         44.0 53.0                       97.0                         44 53                 97
1170813 1170813 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_11                         36.0 26.0                       62.0                         36 26                 62
1170814 1170814 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_12                         40.0 47.0                       87.0                         40 47                 87
1170815 1170815 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_2                         32.0 41.0                       73.0                         32 41                 73
1170816 1170816 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_3                         45.0 32.0                       77.0                         45 32                 77
1170817 1170817 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_4                         33.0 40.0                       73.0                         33 40                 73
1170818 1170818 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_5                         41.0 34.0                       75.0                         41 34                 75
1170819 1170819 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_6                         44.0 32.0                       76.0                         44 32                 76
1170820 1170820 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_7                         42.0 38.0                       80.0                         42 38                 80
1170821 1170821 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_8                         39.0 39.0                       78.0                         39 39                 78
1170822 1170822 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_9                         50.0 52.0                       102.0                         50 52                 102
1170823 1170823 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   kindergarten                         33.0 37.0                       70.0                         33 37                 70
1170824 1170824 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   pk_12_total 734.0 113.0 81.0 1.0   4.0         89.0   516.0 506.0                       1022.0 734 113 81 1   4         89   516 506                 1022
1170861 1170861 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_1                         6.0 8.0                       14.0                         6 8                 14
1170862 1170862 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         8.0 4.0                       12.0                         8 4                 12

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