Data source: Big Local News · About: Big Local

174 rows where grade = "sped_beyond_grade_12", state = "MA" and year = 2019 sorted by rowid descending

View and edit SQL

year

  • 2019 · 174

grade

  • sped_beyond_grade_12 · 174
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
2049192 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 2019   sped_beyond_grade_12 12 3 2 1   4     0   0                             22.0 12 3 2 1   4     0   0                       22
2049179 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2049166 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2049145 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2049093 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 12 1 0 0   1     0   1                             15.0 12 1 0 0   1     0   1                       15
2048980 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 0 0   0     0   0                             6.0 6 0 0 0   0     0   0                       6
2048973 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048951 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2048915 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2048898 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048891 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048790 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 5 0 0 0   0     0   1                             6.0 5 0 0 0   0     0   1                       6
2048783 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No High 09 12 2019   sped_beyond_grade_12 19 0 0 0   0     0   1                             20.0 19 0 0 0   0     0   1                       20
2048754 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 7 0 0 0   3     0   0                             10.0 7 0 0 0   3     0   0                       10
2048741 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 1 0   0     0   0                             7.0 6 0 1 0   0     0   0                       7
2048706 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048686 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2048655 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2048632 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048611 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048561 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2048554 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 0 0   0     0   0                             6.0 6 0 0 0   0     0   0                       6
2048541 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048534 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048462 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2048442 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2048420 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2019   sped_beyond_grade_12 7 0 0 0   0     0   0                             7.0 7 0 0 0   0     0   0                       7
2048386 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048378 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048346 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2019   sped_beyond_grade_12 12 0 0 0   0     0   0                             12.0 12 0 0 0   0     0   0                       12
2048293 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048258 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2019   sped_beyond_grade_12 10 0 0 0   1     0   0                             11.0 10 0 0 0   1     0   0                       11
2048230 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2048202 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2048166 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048144 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2019   sped_beyond_grade_12 16 0 2 0   0     0   0                             18.0 16 0 2 0   0     0   0                       18
2048123 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 4 0 2 0   0     0   1                             7.0 4 0 2 0   0     0   1                       7
2048116 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2048101 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2047540 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 High 06 12 2019   sped_beyond_grade_12 0 6 4 0   0     0   0                             10.0 0 6 4 0   0     0   0                       10
2047485 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2019   sped_beyond_grade_12 8 2 6 0   2     0   0                             18.0 8 2 6 0   2     0   0                       18
2047480 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2019   sped_beyond_grade_12 5 4 5 0   1     0   1                             16.0 5 4 5 0   1     0   1                       16
2047475 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 7 0   0     0   0                             13.0 6 0 7 0   0     0   0                       13
2047470 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2019   sped_beyond_grade_12 2 2 7 0   2     0   1                             14.0 2 2 7 0   2     0   1                       14
2047033 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2046945 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No High 09 12 2019   sped_beyond_grade_12 11 0 3 0   2     0   0                             16.0 11 0 3 0   2     0   0                       16
2046867 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2046833 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2019   sped_beyond_grade_12 19 0 4 0   1     0   0                             24.0 19 0 4 0   1     0   0                       24
2046736 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No High 09 12 2019   sped_beyond_grade_12 4 0 1 0   1     0   0                             6.0 4 0 1 0   1     0   0                       6
2046685 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2046645 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2019   sped_beyond_grade_12 5 1 0 0   1     0   0                             7.0 5 1 0 0   1     0   0                       7
2046616 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 08 12 2019   sped_beyond_grade_12 6 1 0 0   0     0   1                             8.0 6 1 0 0   0     0   1                       8
2046598 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2046583 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2046531 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2019   sped_beyond_grade_12 8 0 0 0   0     0   0                             8.0 8 0 0 0   0     0   0                       8
2046456 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No High 08 12 2019   sped_beyond_grade_12 6 0 0 0   0     0   0                             6.0 6 0 0 0   0     0   0                       6
2046402 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2019   sped_beyond_grade_12 7 0 0 0   0     0   0                             7.0 7 0 0 0   0     0   0                       7
2046379 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   sped_beyond_grade_12 7 3 0 0   1     0   0                             11.0 7 3 0 0   1     0   0                       11
2046327 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2046306 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2046223 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
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
2046132 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2019   sped_beyond_grade_12 2 3 10 0   1     0   0                             16.0 2 3 10 0   1     0   0                       16
2046127 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2045847 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 0 0   0     0   0                             6.0 6 0 0 0   0     0   0                       6
2045792 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2045787 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No High 09 12 2019   sped_beyond_grade_12 3 1 4 0   0     0   0                             8.0 3 1 4 0   0     0   0                       8
2045684 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2045599 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2045560 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2019   sped_beyond_grade_12 2 1 2 0   2     0   0                             7.0 2 1 2 0   2     0   0                       7
2045503 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2019   sped_beyond_grade_12 2 0 3 0   0     0   1                             6.0 2 0 3 0   0     0   1                       6
2045439 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No High 09 12 2019   sped_beyond_grade_12 7 0 0 0   0     0   0                             7.0 7 0 0 0   0     0   0                       7
2045392 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   sped_beyond_grade_12 1 0 5 0   1     0   0                             7.0 1 0 5 0   1     0   0                       7
2045266 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2019   sped_beyond_grade_12 3 0 0 0   4     0   0                             7.0 3 0 0 0   4     0   0                       7
2045081 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   sped_beyond_grade_12 11 3 1 0   0     0   0                             15.0 11 3 1 0   0     0   0                       15
2045011 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2019   sped_beyond_grade_12 10 0 0 0   0     0   0                             10.0 10 0 0 0   0     0   0                       10
2044975 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No High 09 12 2019   sped_beyond_grade_12 10 0 1 0   0     0   0                             11.0 10 0 1 0   0     0   0                       11
2044915 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2044900 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2019   sped_beyond_grade_12 6 0 2 0   0     0   0                             8.0 6 0 2 0   0     0   0                       8
2044857 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2019   sped_beyond_grade_12 7 0 0 0   0     0   0                             7.0 7 0 0 0   0     0   0                       7
2044801 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 0 0   0     0   0                             6.0 6 0 0 0   0     0   0                       6
2044782 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2044741 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2044627 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2044593 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2044550 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   sped_beyond_grade_12 12 1 0 0   6     0   0                             19.0 12 1 0 0   6     0   0                       19
2044442 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2044276 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2044177 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2044114 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2044099 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   sped_beyond_grade_12 10 0 1 0   0     0   0                             11.0 10 0 1 0   0     0   0                       11
2044073 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2044053 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2044008 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 0 0   0     0   0                             6.0 6 0 0 0   0     0   0                       6
2043951 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2043821 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 1 1 0   0     0   0                             8.0 6 1 1 0   0     0   0                       8
2043788 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2043766 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2019   sped_beyond_grade_12 13 0 0 0   0     1   0                             14.0 13 0 0 0   0     1   0                       14
2043751 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 4 1 0   2     0   0                             13.0 6 4 1 0   2     0   0                       13
2043681 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   sped_beyond_grade_12 7 1 10 0   0     0   2                             20.0 7 1 10 0   0     0   2                       20

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