enrollments

Data source: Big Local News · About: Big Local

1,850 rows where grade = "sped_beyond_grade_12", state = "MA" and year = 2017 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 1,850 ✖

grade ✖

  • sped_beyond_grade_12 · 1,850 ✖
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
1122495 1122495 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 1 0 0   0     0   0                             9 8 1 0 0   0     0   0                       9
1123425 1123425 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 09 12 2017   sped_beyond_grade_12 1 5 2 0   1     0   0                             9 1 5 2 0   1     0   0                       9
1123558 1123558 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 2 1 0   0     0   0                             9 6 2 1 0   0     0   0                       9
1126684 1126684 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2017   sped_beyond_grade_12 5 1 1 0   2     0   0                             9 5 1 1 0   2     0   0                       9
1129992 1129992 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 0 2 0   0     0   0                             9 7 0 2 0   0     0   0                       9
1131797 1131797 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2017   sped_beyond_grade_12 9 0 0 0   0     0   0                             9 9 0 0 0   0     0   0                       9
1131933 1131933 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2017   sped_beyond_grade_12 8 0 0 0   1     0   0                             9 8 0 0 0   1     0   0                       9
1132375 1132375 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   sped_beyond_grade_12 7 1 0 0   0     0   1                             9 7 1 0 0   0     0   1                       9
1132500 1132500 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 0 0 0   1     0   0                             9 8 0 0 0   1     0   0                       9
1122551 1122551 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2017   sped_beyond_grade_12 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
1123374 1123374 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   sped_beyond_grade_12 1 2 3 0   1     0   1                             8 1 2 3 0   1     0   1                       8
1124033 1124033 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   sped_beyond_grade_12 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
1126616 1126616 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 0 0 0   0     1   0                             8 7 0 0 0   0     1   0                       8
1127417 1127417 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 0 1 0   0     0   0                             8 7 0 1 0   0     0   0                       8
1129086 1129086 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
1129443 1129443 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 3 1 4 0   0     0   0                             8 3 1 4 0   0     0   0                       8
1129841 1129841 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
1126497 1126497 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2017   sped_beyond_grade_12 1 3 3 0   0     0   0                             7 1 3 3 0   0     0   0                       7
1127594 1127594 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   sped_beyond_grade_12 7 0 0 0   0     0   0                             7 7 0 0 0   0     0   0                       7
1128541 1128541 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 1 3 0   1     0   0                             7 2 1 3 0   1     0   0                       7
1128678 1128678 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2017   sped_beyond_grade_12 3 1 3 0   0     0   0                             7 3 1 3 0   0     0   0                       7
1129893 1129893 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 0 0 0   0     0   0                             7 7 0 0 0   0     0   0                       7
1131772 1131772 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 4 0 2 0   0     0   1                             7 4 0 2 0   0     0   1                       7
1132282 1132282 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 0 0 0   0     0   0                             7 7 0 0 0   0     0   0                       7
1122015 1122015 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1122643 1122643 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   sped_beyond_grade_12 0 2 2 0   2     0   0                             6 0 2 2 0   2     0   0                       6
1124201 1124201 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   sped_beyond_grade_12 5 0 1 0   0     0   0                             6 5 0 1 0   0     0   0                       6
1125736 1125736 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1126346 1126346 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2017   sped_beyond_grade_12 5 1 0 0   0     0   0                             6 5 1 0 0   0     0   0                       6
1126645 1126645 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1128090 1128090 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1128391 1128391 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   sped_beyond_grade_12 3 0 0 0   2     0   1                             6 3 0 0 0   2     0   1                       6
1128746 1128746 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2017   sped_beyond_grade_12 4 0 2 0   0     0   0                             6 4 0 2 0   0     0   0                       6
1129737 1129737 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1130515 1130515 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2017   sped_beyond_grade_12 5 1 0 0   0     0   0                             6 5 1 0 0   0     0   0                       6
1132268 1132268 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1132776 1132776 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1123284 1123284 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 22 8 0   5     0   0                             43 8 22 8 0   5     0   0                       43
1126304 1126304 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   sped_beyond_grade_12 15 4 13 0   6     0   0                             38 15 4 13 0   6     0   0                       38
1130265 1130265 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2017   sped_beyond_grade_12 28 3 2 0   1     0   1                             35 28 3 2 0   1     0   1                       35
1129414 1129414 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2017   sped_beyond_grade_12 1 7 26 0   0     0   0                             34 1 7 26 0   0     0   0                       34
1127545 1127545 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   sped_beyond_grade_12 26 0 1 0   3     0   0                             30 26 0 1 0   3     0   0                       30
1126516 1126516 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   sped_beyond_grade_12 9 4 10 0   4     0   2                             29 9 4 10 0   4     0   2                       29
1125456 1125456 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2017   sped_beyond_grade_12 21 0 6 0   0     0   1                             28 21 0 6 0   0     0   1                       28
1131064 1131064 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2017   sped_beyond_grade_12 10 4 9 0   2     0   0                             25 10 4 9 0   2     0   0                       25
1133026 1133026 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 15 2 5 0   3     0   0                             25 15 2 5 0   3     0   0                       25
1129404 1129404 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 4 13 0   0     0   0                             24 7 4 13 0   0     0   0                       24
1123314 1123314 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 1 12 7 0   2     0   1                             23 1 12 7 0   2     0   1                       23
1123391 1123391 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2017   sped_beyond_grade_12 1 15 3 0   3     0   1                             23 1 15 3 0   3     0   1                       23
1126962 1126962 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   sped_beyond_grade_12 15 0 6 0   0     0   2                             23 15 0 6 0   0     0   2                       23
1123703 1123703 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   sped_beyond_grade_12 5 15 1 0   1     0   0                             22 5 15 1 0   1     0   0                       22
1129409 1129409 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2017   sped_beyond_grade_12 3 2 17 0   0     0   0                             22 3 2 17 0   0     0   0                       22
1124206 1124206 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2017   sped_beyond_grade_12 14 1 5 0   0     0   1                             21 14 1 5 0   0     0   1                       21
1123708 1123708 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No High 09 12 2017   sped_beyond_grade_12 6 9 3 0   0     0   1                             19 6 9 3 0   0     0   1                       19
1125890 1125890 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   sped_beyond_grade_12 3 1 15 0   0     0   0                             19 3 1 15 0   0     0   0                       19
1131059 1131059 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 2 8 0   1     0   1                             19 7 2 8 0   1     0   1                       19
1122123 1122123 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   sped_beyond_grade_12 16 1 0 0   1     0   0                             18 16 1 0 0   1     0   0                       18
1123144 1123144 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   sped_beyond_grade_12 2 10 5 0   0     0   0                             17 2 10 5 0   0     0   0                       17
1123304 1123304 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 3 11 0   0     0   0                             16 2 3 11 0   0     0   0                       16
1123309 1123309 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2017   sped_beyond_grade_12 0 9 5 0   2     0   0                             16 0 9 5 0   2     0   0                       16
1123816 1123816 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   sped_beyond_grade_12 10 1 3 0   1     0   1                             16 10 1 3 0   1     0   1                       16
1129706 1129706 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   sped_beyond_grade_12 12 2 0 0   1     0   1                             16 12 2 0 0   1     0   1                       16
1125867 1125867 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   sped_beyond_grade_12 0 0 14 0   1     0   0                             15 0 0 14 0   1     0   0                       15
1130404 1130404 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No High 09 12 2017   sped_beyond_grade_12 12 0 2 0   0     0   1                             15 12 0 2 0   0     0   1                       15
1123274 1123274 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 7 4 0   1     0   0                             14 2 7 4 0   1     0   0                       14
1124918 1124918 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2017   sped_beyond_grade_12 5 2 7 0   0     0   0                             14 5 2 7 0   0     0   0                       14
1125428 1125428 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   sped_beyond_grade_12 10 0 3 0   1     0   0                             14 10 0 3 0   1     0   0                       14
1129337 1129337 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   sped_beyond_grade_12 1 3 10 0   0     0   0                             14 1 3 10 0   0     0   0                       14
1131049 1131049 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 2 8 0   1     0   1                             14 2 2 8 0   1     0   1                       14
1132909 1132909 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 11 1 0 0   1     0   1                             14 11 1 0 0   1     0   1                       14
1125227 1125227 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2017   sped_beyond_grade_12 11 0 0 0   1     0   1                             13 11 0 0 0   1     0   1                       13
1131054 1131054 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2017   sped_beyond_grade_12 5 0 7 0   0     0   1                             13 5 0 7 0   0     0   1                       13
1132486 1132486 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2017   sped_beyond_grade_12 10 0 2 0   1     0   0                             13 10 0 2 0   1     0   0                       13
1132971 1132971 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2017   sped_beyond_grade_12 10 0 1 0   1     0   0                             12 10 0 1 0   1     0   0                       12
1124957 1124957 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2017   sped_beyond_grade_12 11 0 0 0   0     0   0                             11 11 0 0 0   0     0   0                       11
1127019 1127019 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2017   sped_beyond_grade_12 10 1 0 0   0     0   0                             11 10 1 0 0   0     0   0                       11
1127963 1127963 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2017   sped_beyond_grade_12 10 0 1 0   0     0   0                             11 10 0 1 0   0     0   0                       11
1131864 1131864 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 9 2 0 0   0     0   0                             11 9 2 0 0   0     0   0                       11
1122254 1122254 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   sped_beyond_grade_12 9 0 1 0   0     0   0                             10 9 0 1 0   0     0   0                       10
1122330 1122330 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   sped_beyond_grade_12 9 0 0 0   0     0   1                             10 9 0 0 0   0     0   1                       10
1127724 1127724 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2017   sped_beyond_grade_12 9 0 1 0   0     0   0                             10 9 0 1 0   0     0   0                       10
1128049 1128049 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 0 2 0   0     0   0                             10 8 0 2 0   0     0   0                       10
1131822 1131822 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2017   sped_beyond_grade_12 10 0 0 0   0     0   0                             10 10 0 0 0   0     0   0                       10
1132351 1132351 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 9 0 1 0   0     0   0                             10 9 0 1 0   0     0   0                       10
1132536 1132536 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No Ungraded UG UG 2017   sped_beyond_grade_12 10 0 0 0   0     0   0                             10 10 0 0 0   0     0   0                       10
1121948 1121948 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121953 1121953 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121956 1121956 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121959 1121959 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121964 1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121971 1121971 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121976 1121976 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121978 1121978 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121984 1121984 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121990 1121990 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121996 1121996 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122002 1122002 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122007 1122007 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122010 1122010 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122022 1122022 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_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]);