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_high_grade 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
941477 941477 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No 4 UG UG 2016   sped_beyond_grade_12 10 0 0 0   0     0   0   * *                       10 10 0 0 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
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
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 * * * *   *     *   *                             *                                              
1122085 1122085 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122153 1122153 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122185 1122185 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122210 1122210 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122298 1122298 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122369 1122369 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122451 1122451 MA Essex   school 2502640 30   Beverly 250264002854 300002 McKeown School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123723 1123723 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline Early Education Program at Beacon   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123725 1123725 MA Suffolk   school 2503150 46   Brookline 250315002793 460002 Brookline Early Education Program at Putterham   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123810 1123810 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 The Lynch Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123976 1123976 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Rodman Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124035 1124035 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124120 1124120 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Szetela Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124617 1124617 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124959 1124959 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125038 1125038 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125122 1125122 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125154 1125154 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester PreSchool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125246 1125246 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125410 1125410 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125629 1125629 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Park Street School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125646 1125646 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton Pre-School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125947 1125947 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Bennett   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125949 1125949 MA Worcester   school 2506780 153   Leominster 250678001947 1530005 Lincoln School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126013 1126013 MA Middlesex   school 2506840 155   Lexington 250684002829 1550001 Lexington Children's Place   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126518 1126518 MA Essex   school 2507140 164   Lynnfield 250714002617 1640005 Lynnfield Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126582 1126582 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126599 1126599 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Roland Green School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126656 1126656 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126869 1126869 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127006 1127006 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Shining Star Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127496 1127496 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127708 1127708 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128188 1128188 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128283 1128283 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128431 1128431 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 RISE PreSchool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128621 1128621 MA Essex   school 2510380 258   Salem 251038000127 2580001 Salem Early Childhood   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128709 1128709 MA Essex   school 2510500 262   Saugus 251050002700 2620001 Ballard School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128889 1128889 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129088 1129088 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Early Childhood Education Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129482 1129482 MA Norfolk   school 2511250 285   Stoughton 251125001860 2850012 Edwin A Jones Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129646 1129646 MA Bristol   school 2511520 293   Taunton 251152000133 2930005 Edward F. Leddy Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129808 1129808 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129852 1129852 MA Norfolk   school 2511970 307   Walpole 251197002620 3070002 Daniel Feeney Preschool Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130203 1130203 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Fort Meadow Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130280 1130280 MA Middlesex   school 2512660 326   Westford 251266001572 3260013 Millennium Elementary   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130361 1130361 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 Cowing Early Childhood   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130443 1130443 MA Norfolk   school 2512810 335   Westwood 251281002115 3350050 Westwood Integrated Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130454 1130454 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Johnson Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130573 1130573 MA Worcester   school 2513080 343   Winchendon 251308002648 3430010 Winchendon PreSchool Program   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130732 1130732 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131685 1131685 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132151 1132151 MA Middlesex   school 2505500 673   Groton-Dunstable 250550002611 6730001 Boutwell School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132502 1132502 MA Middlesex   school 2508790 735   North Middlesex 250879002686 7350002 Squannacook Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132836 1132836 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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

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