enrollments

Data source: Big Local News · About: Big Local

7,371 rows where grade = "grade_2" and state = "IN" sorted by ccd_school_high_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,371 ✖
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
1164356 1164356 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_2                         6.0 1.0                       7.0                         6 1                 7
1166813 1166813 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_2                         4.0 0.0                       4.0                         4 0                 4
1167780 1167780 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_2                         12.0 10.0                       22.0                         12 10                 22
1169095 1169095 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_2                         0.0 1.0                       1.0                         0 1                 1
1169729 1169729 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_2                         1.0 2.0                       3.0                         1 2                 3
1170512 1170512 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_2                         5.0 0.0                       5.0                         5 0                 5
1170777 1170777 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes 4.0 KG 12 2015   grade_2                         29.0 20.0                       49.0                         29 20                 49
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
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
1170899 1170899 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_2                         14.0 39.0                       53.0                         14 39                 53
1170944 1170944 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         50.0 56.0                       106.0                         50 56                 106
1170994 1170994 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1171008 1171008 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2015   grade_2                         28.0 30.0                       58.0                         28 30                 58
1171032 1171032 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_2                         35.0 36.0                       71.0                         35 36                 71
1171056 1171056 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_2                         2.0 0.0                       2.0                         2 0                 2
1171071 1171071 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_2                         10.0 11.0                       21.0                         10 11                 21
1171097 1171097 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No 4.0 KG 12 2015   grade_2                         21.0 23.0                       44.0                         21 23                 44
1171272 1171272 IN     school 1800115 9765   Indiana Cyber Charter Sch Inc 180011502537 4421 Indiana Cyber Charter School   Regular School Yes 4.0 KG 12 2015   grade_2                         21.0 15.0                       36.0                         21 15                 36
1171301 1171301 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         43.0 33.0                       76.0                         43 33                 76
1171323 1171323 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_2                         7.0 14.0                       21.0                         7 14                 21
1171373 1171373 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   grade_2                         103.0 96.0                       199.0                         103 96                 199
1171397 1171397 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         24.0 15.0                       39.0                         24 15                 39
1171433 1171433 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_2                         34.0 35.0                       69.0                         34 35                 69
1171447 1171447 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         36.0 39.0                       75.0                         36 39                 75
1171467 1171467 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         6.0 0.0                       6.0                         6 0                 6
1283095 1283095 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No 4.0 01 12 2016   grade_2                         3.0 1.0                       4.0                         3 1                 4
1289179 1289179 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2016   grade_2                         4.0 8.0                       12.0                         4 8                 12
1290479 1290479 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   grade_2                         1.0 1.0                       2.0                         1 1                 2
1291119 1291119 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_2                         4.0 2.0                       6.0                         4 2                 6
1291899 1291899 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_2                         4.0 0.0                       4.0                         4 0                 4
1292173 1292173 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_2                         17.0 20.0                       37.0                         17 20                 37
1292192 1292192 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   grade_2                         38.0 37.0                       75.0                         38 37                 75
1292266 1292266 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2016   grade_2                         35.0 19.0                       54.0                         35 19                 54
1292319 1292319 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         54.0 41.0                       95.0                         54 41                 95
1292371 1292371 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_2                         54.0 47.0                       101.0                         54 47                 101
1292385 1292385 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_2                         28.0 39.0                       67.0                         28 39                 67
1292409 1292409 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_2                         35.0 36.0                       71.0                         35 36                 71
1292433 1292433 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   grade_2                         2.0 1.0                       3.0                         2 1                 3
1292448 1292448 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   grade_2                         3.0 9.0                       12.0                         3 9                 12
1292473 1292473 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No 4.0 KG 12 2016   grade_2                         22.0 23.0                       45.0                         22 23                 45
1292628 1292628 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_2                         2.0 0.0                       2.0                         2 0                 2
1292661 1292661 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         47.0 26.0                       73.0                         47 26                 73
1292683 1292683 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_2                         6.0 3.0                       9.0                         6 3                 9
1292740 1292740 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2016   grade_2                         83.0 78.0                       161.0                         83 78                 161
1292764 1292764 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         12.0 18.0                       30.0                         12 18                 30
1292797 1292797 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2016   grade_2                         30.0 36.0                       66.0                         30 36                 66
1292813 1292813 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         57.0 53.0                       110.0                         57 53                 110
1292840 1292840 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         8.0 1.0                       9.0                         8 1                 9
1292885 1292885 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   grade_2                         3.0 5.0                       8.0                         3 5                 8
1294810 1294810 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_2                         1.0 0.0                       1.0                         1 0                 1
1295133 1295133 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_2                         3.0 0.0                       3.0                         3 0                 3
1301208 1301208 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_2                         10.0 10.0                       20.0                         10 10                 20
1303148 1303148 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_2                         3.0 3.0                       6.0                         3 3                 6
1303924 1303924 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_2                         2.0 1.0                       3.0                         2 1                 3
1304207 1304207 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_2                         30.0 17.0                       47.0                         30 17                 47
1304226 1304226 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_2                         35.0 40.0                       75.0                         35 40                 75
1304298 1304298 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_2                         28.0 26.0                       54.0                         28 26                 54
1304352 1304352 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_2                         47.0 36.0                       83.0                         47 36                 83
1304404 1304404 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_2                         49.0 58.0                       107.0                         49 58                 107
1304418 1304418 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_2                         42.0 31.0                       73.0                         42 31                 73
1304442 1304442 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_2                         37.0 25.0                       62.0                         37 25                 62
1304466 1304466 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_2                         4.0 3.0                       7.0                         4 3                 7
1304481 1304481 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_2                         6.0 4.0                       10.0                         6 4                 10
1304506 1304506 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2017   grade_2                         22.0 22.0                       44.0                         22 22                 44
1304701 1304701 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_2                         43.0 31.0                       74.0                         43 31                 74
1304723 1304723 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   grade_2                         10.0 5.0                       15.0                         10 5                 15
1304766 1304766 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_2                         93.0 98.0                       191.0                         93 98                 191
1304790 1304790 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2017   grade_2                         21.0 25.0                       46.0                         21 25                 46
1304823 1304823 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2017   grade_2                         23.0 23.0                       46.0                         23 23                 46
1304841 1304841 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2017   grade_2                         52.0 56.0                       108.0                         52 56                 108
1304867 1304867 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_2                         4.0 3.0                       7.0                         4 3                 7
1304914 1304914 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_2                         7.0 7.0                       14.0                         7 7                 14
1753738 1753738 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 02 12 2019   grade_2                         1.0 2.0                       3.0                         1 2                 3
1759701 1759701 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   grade_2                         10.0 10.0                       20.0                         10 10                 20
1761007 1761007 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_2                         2.0 0.0                       2.0                         2 0                 2
1761659 1761659 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1762462 1762462 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   grade_2                         4.0 1.0                       5.0                         4 1                 5
1762846 1762846 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   grade_2                         20.0 23.0                       43.0                         20 23                 43
1762866 1762866 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2019   grade_2                         25.0 43.0                       68.0                         25 43                 68
1762910 1762910 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2019   grade_2                         25.0 30.0                       55.0                         25 30                 55
1762966 1762966 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2019   grade_2                         41.0 29.0                       70.0                         41 29                 70
1763015 1763015 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_2                         51.0 47.0                       98.0                         51 47                 98
1763029 1763029 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_2                         32.0 41.0                       73.0                         32 41                 73
1763053 1763053 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_2                         37.0 30.0                       67.0                         37 30                 67
1763078 1763078 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_2                         7.0 0.0                       7.0                         7 0                 7
1763093 1763093 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_2                         14.0 7.0                       21.0                         14 7                 21
1763118 1763118 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2019   grade_2                         22.0 24.0                       46.0                         22 24                 46
1763283 1763283 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_2                         27.0 28.0                       55.0                         27 28                 55
1763305 1763305 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2019   grade_2                         5.0 3.0                       8.0                         5 3                 8
1763345 1763345 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2019   grade_2                         20.0 13.0                       33.0                         20 13                 33
1763378 1763378 IN     school 1800094 9895   IN Math & Science Academy - North 180009402487 5444 IN Math & Science Academy - North   Regular School Yes Other KG 12 2019   grade_2                         26.0 14.0                       40.0                         26 14                 40
1763395 1763395 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes Other KG 12 2019   grade_2                         65.0 77.0                       142.0                         65 77                 142
1763421 1763421 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   grade_2                         4.0 0.0                       4.0                         4 0                 4
1763464 1763464 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2019   grade_2                         25.0 11.0                       36.0                         25 11                 36
1789478 1789478 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_2                         1.0 2.0                       3.0                         1 2                 3
1795525 1795525 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2018   grade_2                         4.0 11.0                       15.0                         4 11                 15
1796820 1796820 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_2                         1.0 0.0                       1.0                         1 0                 1
1797464 1797464 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_2                         4.0 2.0                       6.0                         4 2                 6
1798246 1798246 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_2                         4.0 0.0                       4.0                         4 0                 4
1798572 1798572 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_2                         18.0 20.0                       38.0                         18 20                 38

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