enrollments

Data source: Big Local News · About: Big Local

4,267 rows where grade = "sped_beyond_grade_12" and state = "MA" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • sped_beyond_grade_12 · 4,267 ✖
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
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
1368470 1368470 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   * * *                     6.0 6 0 0 0   0     0   0                       6
1371080 1371080 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield Vocational Academy   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 10 22 70 0   4     0   1   65 42 *                     107.0 10 22 70 0   4     0   1   65 42                 107
1374320 1374320 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   sped_beyond_grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1675711 1675711 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   sped_beyond_grade_12 * * * *   *     *   *   * * *                     4.0                                             4
1678338 1678338 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield - Springfield Vocational Academy   Special Education School No Ungraded UG UG 2021   sped_beyond_grade_12 13 27 82 0   5     0   0   86 41 *                     127.0 13 27 82 0   5     0   0   86 41                 127
2043539 2043539 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2019   sped_beyond_grade_12 7 0 0 0   0     0   1                             8.0 7 0 0 0   0     0   1                       8
2046156 2046156 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield Vocational Academy   Special Education School No Ungraded UG UG 2019   sped_beyond_grade_12 9 18 65 0   4     0   1                             97.0 9 18 65 0   4     0   1                       97
2233170 2233170 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg: Advanced Community Experience Program   Special Education School No Ungraded UG UG 2018   sped_beyond_grade_12 8 0 0 0   0     0   1                             9.0 8 0 0 0   0     0   1                       9
2236260 2236260 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield: Springfield Vocational Academy   Special Education School No Ungraded UG UG 2018   sped_beyond_grade_12 12 15 63 0   2     0   0                             92.0 12 15 63 0   2     0   0                       92
2239361 2239361 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 North Middlesex: Peter Fitzpatrick School   Regular School No Ungraded UG UG 2018   sped_beyond_grade_12 17 0 0 0   0     0   1                             18.0 17 0 0 0   0     0   1                       18
2230473 2230473 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239938 2239938 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228755 2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228786 2228786 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228891 2228891 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover: Shawsheen School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228959 2228959 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228991 2228991 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland: William Pittaway Elementary   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229016 2229016 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro: Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229104 2229104 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229175 2229175 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham: Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229259 2229259 MA Essex   school 2502640 30   Beverly 250264002854 300002 Beverly: McKeown School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230417 2230417 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Brockton: Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230537 2230537 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline: Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230539 2230539 MA Norfolk   school 2503150 46   Brookline 250315002793 460002 Brookline: Brookline Early Education Program at Putterham   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230624 2230624 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 Brookline: The Lynch Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230791 2230791 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Canton: Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230850 2230850 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Chelmsford: Community Education Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230935 2230935 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Chicopee: Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231434 2231434 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Everett: Adams School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231787 2231787 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham: Juniper Hill School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231867 2231867 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231951 2231951 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Georgetown: Perley Elementary   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231983 2231983 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester: Gloucester PreSchool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232075 2232075 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 Greenfield: The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232226 2232226 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Haverhill: Moody   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232446 2232446 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Hopedale: Park Street School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232463 2232463 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton: Hopkinton Pre-School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232763 2232763 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Leominster: Bennett   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232765 2232765 MA Worcester   school 2506780 153   Leominster 250678001947 1530005 Leominster: Lincoln School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232829 2232829 MA Middlesex   school 2506840 155   Lexington 250684002829 1550001 Lexington: Lexington Children's Place   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233339 2233339 MA Essex   school 2507140 164   Lynnfield 250714002617 1640005 Lynnfield: Lynnfield Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233403 2233403 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden: Malden Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233420 2233420 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Mansfield: Roland Green School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233477 2233477 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233686 2233686 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Melrose: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233823 2233823 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Milford: Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234318 2234318 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton: Newton Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234530 2234530 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough: North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235010 2235010 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth: Plymouth Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235104 2235104 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Quincy: Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235252 2235252 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 Reading: RISE PreSchool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235444 2235444 MA Essex   school 2510380 258   Salem 251038000127 2580001 Salem: Salem Early Childhood   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235641 2235641 MA Norfolk   school 2510620 266   Sharon 251062002872 2660001 Sharon: Sharon Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235710 2235710 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Shrewsbury: Parker Road Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235907 2235907 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Springfield: Early Childhood Education Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2236299 2236299 MA Norfolk   school 2511250 285   Stoughton 251125001860 2850012 Stoughton: Edwin A Jones Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2236463 2236463 MA Bristol   school 2511520 293   Taunton 251152000133 2930005 Taunton: Edward F. Leddy Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2236622 2236622 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Wakefield: Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2236666 2236666 MA Norfolk   school 2511970 307   Walpole 251197002620 3070002 Walpole: Daniel Feeney Preschool Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237018 2237018 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Westfield: Fort Meadow Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237095 2237095 MA Middlesex   school 2512660 326   Westford 251266001572 3260013 Westford: Millennium Elementary   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237176 2237176 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 West Springfield: Cowing Early Childhood   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237271 2237271 MA Norfolk   school 2512810 335   Westwood 251281002115 3350050 Westwood: Westwood Integrated Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237282 2237282 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Weymouth: Johnson Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237401 2237401 MA Worcester   school 2513080 343   Winchendon 251308002648 3430010 Winchendon: Winchendon PreSchool Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237560 2237560 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester: Head Start   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238522 2238522 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Acton-Boxborough: Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238982 2238982 MA Middlesex   school 2505500 673   Groton-Dunstable 250550002611 6730001 Groton-Dunstable: Boutwell School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239327 2239327 MA Middlesex   school 2508790 735   North Middlesex 250879002686 7350002 North Middlesex: Squannacook Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239651 2239651 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Wachusett: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1122692 1122692 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1123257 1123257 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1123420 1123420 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123454 1123454 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123674 1123674 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1124153 1124153 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124251 1124251 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124663 1124663 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125361 1125361 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
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
1125945 1125945 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1127393 1127393 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127399 1127399 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127953 1127953 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1129344 1129344 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No Other 06 11 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129391 1129391 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130183 1130183 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130590 1130590 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131116 1131116 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131124 1131124 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131133 1131133 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131148 1131148 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131156 1131156 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 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]);