enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by ccd_school_type descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
112015 112015 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 39.0   17.0                   53.0 3.0             27     16   56 39   17                   53 3         27   16   56
112016 112016 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_10                                                   14                                             14
112017 112017 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_11                                                   17                                             17
112018 112018 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_12                                                   17                                             17
112019 112019 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_9                                                   8                                             8
113430 113430 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 4.0   1.0     1.0             3.0 3.0             *     *   6 4   1     1             3 3                 6
113431 113431 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Vocational Education School Yes 3.0 09 12 2015   grade_10                                                   1                                             1
113432 113432 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Vocational Education School Yes 3.0 09 12 2015   grade_11                                                   2                                             2
113433 113433 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Vocational Education School Yes 3.0 09 12 2015   grade_12                                                   3                                             3
113869 113869 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   pk_12_total 40.0   2.0                   26.0 16.0             15     5   42 40   2                   26 16         15   5   42
113870 113870 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_10                                                   5                                             5
113871 113871 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_11                                                   1                                             1
113872 113872 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_12                                                   2                                             2
113873 113873 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_7                                                   9                                             9
113874 113874 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_8                                                   14                                             14
113875 113875 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2015   grade_9                                                   11                                             11
116754 116754 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2015   pk_12_total 339.0 18.0 49.0 2.0   16.0         8.0   302.0 130.0             101     31   432 339 18 49 2   16         8   302 130         101   31   432
116755 116755 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2015   grade_10                                                   107                                             107
116756 116756 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2015   grade_11                                                   114                                             114
116757 116757 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2015   grade_12                                                   94                                             94
116758 116758 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2015   grade_9                                                   117                                             117
117305 117305 WI Rusk   school 5507590 2856 Public school Ladysmith 550759002753 410 Health Care Academy of Ladysmith-Hawkins School District charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 18.0         2.0         1.0   2.0 19.0             8         21 18         2         1   2 19         8       21
117306 117306 WI Rusk   school 5507590 2856 Public school Ladysmith 550759002753 410 Health Care Academy of Ladysmith-Hawkins School District charter Vocational Education School Yes 3.0 09 12 2015   grade_11                                                   7                                             7
117307 117307 WI Rusk   school 5507590 2856 Public school Ladysmith 550759002753 410 Health Care Academy of Ladysmith-Hawkins School District charter Vocational Education School Yes 3.0 09 12 2015   grade_12                                                   14                                             14
119897 119897 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 5.0 93.0 1.0                   41.0 58.0             74     25   99 5 93 1                   41 58         74   25   99
119898 119898 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2015   grade_10                                                   34                                             34
119899 119899 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2015   grade_11                                                   16                                             16
119900 119900 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2015   grade_12                                                   3                                             3
119901 119901 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2015   grade_9                                                   46                                             46
281990 281990 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2016   pk_12_total 52.0 2.0 14.0 1.0   4.0             70.0 3.0             31     17   73 52 2 14 1   4             70 3         31   17   73
281991 281991 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2016   grade_10                                                   22                                             22
281992 281992 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2016   grade_11                                                   12                                             12
281993 281993 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2016   grade_12                                                   17                                             17
281994 281994 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2016   grade_9                                                   22                                             22
283846 283846 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2016   pk_12_total 36.0   1.0                   28.0 9.0             11     4   37 36   1                   28 9         11   4   37
283847 283847 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2016   grade_10                                                   10                                             10
283848 283848 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2016   grade_11                                                   3                                             3
283849 283849 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2016   grade_12                                                   1                                             1
283850 283850 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2016   grade_7                                                   12                                             12
283851 283851 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2016   grade_8                                                   5                                             5
283852 283852 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Vocational Education School Yes 3.0 07 12 2016   grade_9                                                   6                                             6
286761 286761 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2016   pk_12_total 345.0 13.0 50.0 2.0   18.0         10.0   318.0 120.0             83     28   438 345 13 50 2   18         10   318 120         83   28   438
286762 286762 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2016   grade_10                                                   110                                             110
286763 286763 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2016   grade_11                                                   103                                             103
286764 286764 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2016   grade_12                                                   110                                             110
286765 286765 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Vocational Education School No 3.0 09 12 2016   grade_9                                                   115                                             115
287297 287297 WI Rusk   school 5507590 2856 Public school Ladysmith 550759002753 410 Health Care Academy of Ladysmith-Hawkins School District charter Vocational Education School Yes 3.0 09 12 2016   pk_12_total 24.0   1.0               1.0   3.0 23.0             11     1   26 24   1               1   3 23         11   1   26
287298 287298 WI Rusk   school 5507590 2856 Public school Ladysmith 550759002753 410 Health Care Academy of Ladysmith-Hawkins School District charter Vocational Education School Yes 3.0 09 12 2016   grade_11                                                   15                                             15
287299 287299 WI Rusk   school 5507590 2856 Public school Ladysmith 550759002753 410 Health Care Academy of Ladysmith-Hawkins School District charter Vocational Education School Yes 3.0 09 12 2016   grade_12                                                   11                                             11
289866 289866 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2016   pk_12_total 6.0 89.0 4.0                   38.0 61.0             34     16   99 6 89 4                   38 61         34   16   99
289867 289867 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2016   grade_10                                                   26                                             26
289868 289868 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2016   grade_11                                                   30                                             30
289869 289869 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2016   grade_12                                                   10                                             10
289870 289870 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003010 474 NOVA Tech charter Vocational Education School Yes 3.0 09 12 2016   grade_9                                                   33                                             33
460159 460159 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3.0 09 12 2015   grade_10 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
460160 460160 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3.0 09 12 2015   grade_11 28 7 10   0 0     0   0   35 10 0   0   0   0       0.0 45 28 7 10   0 0     0   0   35 10 0   0 0 0     0 45
460161 460161 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3.0 09 12 2015   grade_12 134 25 27   7 8     4   11   163 53 0   0   0   0       0.0 216 134 25 27   7 8     4   11   163 53 0   0 0 0     0 216
460162 460162 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3.0 09 12 2015   pk_12_total 162 32 38   7 8     4   11   199 63 0   0   0   0       0.0 262 162 32 38   7 8     4   11   199 63 0   0 0 0     0 262
461611 461611 WA Spokane   school 5301110 32356   Central Valley School District 530111003387 5278 Spokane Valley Tech Skills Center   Vocational Education School No 3.0 09 12 2015   grade_12 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
461612 461612 WA Spokane   school 5301110 32356   Central Valley School District 530111003387 5278 Spokane Valley Tech Skills Center   Vocational Education School No 3.0 09 12 2015   pk_12_total 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
463604 463604 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002097 4203 Cascadia Technical Academy Skills Center   Vocational Education School No 3.0 09 12 2015   grade_12 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
463605 463605 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002097 4203 Cascadia Technical Academy Skills Center   Vocational Education School No 3.0 09 12 2015   pk_12_total 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
467346 467346 WA Grant   school 5305220 13161   Moses Lake School District 530522003392 5273 Columbia Basin Technical Skills Center   Vocational Education School No 3.0 10 12 2015   grade_11 1 0 3   0 0     0   0   0 4 0   0   0   2       0.0 4 1 0 3   0 0     0   0   0 4 0   0 0 2     0 4
467347 467347 WA Grant   school 5305220 13161   Moses Lake School District 530522003392 5273 Columbia Basin Technical Skills Center   Vocational Education School No 3.0 10 12 2015   grade_12 1 0 3   0 0     0   0   4 0 0   0   0   3       0.0 4 1 0 3   0 0     0   0   4 0 0   0 0 3     0 4
467348 467348 WA Grant   school 5305220 13161   Moses Lake School District 530522003392 5273 Columbia Basin Technical Skills Center   Vocational Education School No 3.0 10 12 2015   pk_12_total 2 0 6   0 0     0   0   4 4 0   0   0   5       0.0 8 2 0 6   0 0     0   0   4 4 0   0 0 5     0 8
473998 473998 WA Thurston   school 5309100 34033   Tumwater School District 530910002186 4225 New Market Skills Center   Vocational Education School No 3.0 11 12 2015   grade_12 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
473999 473999 WA Thurston   school 5309100 34033   Tumwater School District 530910002186 4225 New Market Skills Center   Vocational Education School No 3.0 11 12 2015   pk_12_total 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
519748 519748 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003334 5208 Twin Harbors, A Branch of New Market Skills Center   Vocational Education School No 3 09 12 2016   grade_10 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
519749 519749 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003334 5208 Twin Harbors, A Branch of New Market Skills Center   Vocational Education School No 3 09 12 2016   pk_12_total 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
520138 520138 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3 09 12 2016   grade_10 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
520139 520139 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3 09 12 2016   grade_11 32 3 3   1 0     2   2   33 10 0   0   0   0       0.0 43 32 3 3   1 0     2   2   33 10 0   0 0 0     0 43
520140 520140 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3 09 12 2016   grade_12 165 29 31   3 7     6   12   198 55 0   0   0   0       0.0 253 165 29 31   3 7     6   12   198 55 0   0 0 0     0 253
520141 520141 WA Pierce   school 5300014 27931   Bates Technical College 530001403082 5950 Bates Technical High School   Vocational Education School No 3 09 12 2016   pk_12_total 198 32 34   4 7     8   14   232 65 0   0   0   0       0.0 297 198 32 34   4 7     8   14   232 65 0   0 0 0     0 297
521592 521592 WA Spokane   school 5301110 32356   Central Valley School District 530111003387 5278 Spokane Valley Tech Skills Center   Vocational Education School No 3 09 12 2016   grade_12 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
521593 521593 WA Spokane   school 5301110 32356   Central Valley School District 530111003387 5278 Spokane Valley Tech Skills Center   Vocational Education School No 3 09 12 2016   grade_9 2 0 0   0 0     0   0   0 2 0   0   0   1       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 1     0 2
521594 521594 WA Spokane   school 5301110 32356   Central Valley School District 530111003387 5278 Spokane Valley Tech Skills Center   Vocational Education School No 3 09 12 2016   pk_12_total 3 0 0   0 0     0   0   0 3 0   0   0   1       0.0 3 3 0 0   0 0     0   0   0 3 0   0 0 1     0 3
522134 522134 WA Pierce   school 5300017 27932   Clover Park Technical College 530001703209 5951 Northwest Career and Technical High School   Vocational Education School No 3 09 12 2016   grade_11 13 4 6   1 1     1   4   13 17 0   0   0   0       0.0 30 13 4 6   1 1     1   4   13 17 0   0 0 0     0 30
522135 522135 WA Pierce   school 5300017 27932   Clover Park Technical College 530001703209 5951 Northwest Career and Technical High School   Vocational Education School No 3 09 12 2016   grade_12 85 22 43   2 6     5   26   94 95 0   0   0   0       0.0 189 85 22 43   2 6     5   26   94 95 0   0 0 0     0 189
522136 522136 WA Pierce   school 5300017 27932   Clover Park Technical College 530001703209 5951 Northwest Career and Technical High School   Vocational Education School No 3 09 12 2016   pk_12_total 98 26 49   3 7     6   30   107 112 0   0   0   0       0.0 219 98 26 49   3 7     6   30   107 112 0   0 0 0     0 219
526315 526315 WA King   school 5304230 17414   Lake Washington School District 530423003289 5958 Washington Network for Innovative Careers Skill Center   Vocational Education School No 3 09 12 2016   grade_11 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
526316 526316 WA King   school 5304230 17414   Lake Washington School District 530423003289 5958 Washington Network for Innovative Careers Skill Center   Vocational Education School No 3 09 12 2016   grade_12 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
526317 526317 WA King   school 5304230 17414   Lake Washington School District 530423003289 5958 Washington Network for Innovative Careers Skill Center   Vocational Education School No 3 09 12 2016   pk_12_total 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
527270 527270 WA Grant   school 5305220 13161   Moses Lake School District 530522003392 5273 Columbia Basin Technical Skills Center   Vocational Education School No 3 10 12 2016   grade_11 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
527271 527271 WA Grant   school 5305220 13161   Moses Lake School District 530522003392 5273 Columbia Basin Technical Skills Center   Vocational Education School No 3 10 12 2016   pk_12_total 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
736832 736832 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_9 6 54 94 0   2     0   2   92 66                       158 6 54 94 0   2     0   2   92 66                 158
736833 736833 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_10 16 108 140 4   0     1   8   158 119                       277 16 108 140 4   0     1   8   158 119                 277
736834 736834 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_11 11 108 116 1   2     0   2   146 94                       240 11 108 116 1   2     0   2   146 94                 240
736835 736835 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_12 9 100 104 0   5     0   6   128 96                       224 9 100 104 0   5     0   6   128 96                 224
736836 736836 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   SP 3 12 5 0   2     0   0                             22 3 12 5 0   2     0   0                       22
738777 738777 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 5 0 116 0   1     0   0   66 56                       122 5 0 116 0   1     0   0   66 56                 122
738778 738778 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_10 5 2 86 0   0     0   0   52 41                       93 5 2 86 0   0     0   0   52 41                 93
738779 738779 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_11 7 2 83 0   0     0   0   47 45                       92 7 2 83 0   0     0   0   47 45                 92
738780 738780 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_12 5 3 88 0   0     0   0   54 42                       96 5 3 88 0   0     0   0   54 42                 96
739108 739108 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_9 187 26 121 1   19     1   6   208 153                       361 187 26 121 1   19     1   6   208 153                 361
739109 739109 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_10 76 10 42 0   5     0   3   89 47                       136 76 10 42 0   5     0   3   89 47                 136
739110 739110 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_11 88 7 26 0   5     0   6   85 47                       132 88 7 26 0   5     0   6   85 47                 132
739111 739111 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_12 81 9 24 0   5     0   3   73 49                       122 81 9 24 0   5     0   3   73 49                 122
739533 739533 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   pre_kindergarten 12 4 19 2   5     0   1   24 19                       43 12 4 19 2   5     0   1   24 19                 43
739534 739534 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_7 * * * *   *     *   *   1 3                       4                         1 3                 4
739535 739535 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_8 * * * *   *     *   *   1 1                       2                         1 1                 2

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