enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 9,399 ✖
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
941395 941395 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_7 89 1 5 0   1     0   4   51 49                       100 89 1 5 0   1     0   4   51 49                 100
941398 941398 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2016   grade_10 88 0 6 0   0     0   6   46 54                       100 88 0 6 0   0     0   6   46 54                 100
941645 941645 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No 1 03 06 2016   grade_5 93 3 2 0   2     0   0   50 50                       100 93 3 2 0   2     0   0   50 50                 100
941788 941788 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_6 92 3 3 0   2     0   0   56 44                       100 92 3 3 0   2     0   0   56 44                 100
942000 942000 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_7 64 12 19 1   1     0   3   58 42                       100 64 12 19 1   1     0   3   58 42                 100
932553 932553 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_1 97 0 4 0   0     0   0   43 58                       101 97 0 4 0   0     0   0   43 58                 101
932648 932648 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No 1 KG 05 2016   grade_5 63 3 9 0   23     0   3   45 56                       101 63 3 9 0   23     0   3   45 56                 101
932664 932664 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No 1 KG 05 2016   grade_2 74 4 10 0   11     0   2   42 59                       101 74 4 10 0   11     0   2   42 59                 101
932750 932750 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   grade_4 59 1 29 1   4     0   7   51 50                       101 59 1 29 1   4     0   7   51 50                 101
933015 933015 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No 1 KG 05 2016   grade_2 82 5 5 0   9     0   0   53 48                       101 82 5 5 0   9     0   0   53 48                 101
933096 933096 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2016   grade_2 17 19 60 0   2     0   3   53 48                       101 17 19 60 0   2     0   3   53 48                 101
933236 933236 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 06 2016   grade_1 32 30 25 0   11     0   3   56 45                       101 32 30 25 0   11     0   3   56 45                 101
933702 933702 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2016   grade_9 7 27 62 0   4     1   0   49 52                       101 7 27 62 0   4     1   0   49 52                 101
933725 933725 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2016   grade_10 16 40 40 0   3     0   2   35 66                       101 16 40 40 0   3     0   2   35 66                 101
933785 933785 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_6 6 54 32 0   3     0   6   64 37                       101 6 54 32 0   3     0   6   64 37                 101
934058 934058 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_2 63 2 14 0   12     0   10   48 53                       101 63 2 14 0   12     0   10   48 53                 101
934834 934834 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_8 39 12 41 0   7     0   2   54 47                       101 39 12 41 0   7     0   2   54 47                 101
934856 934856 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_6 14 20 64 2   1     0   0   48 53                       101 14 20 64 2   1     0   0   48 53                 101
934940 934940 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No 1 PK 05 2016   grade_3 74 3 12 0   5     0   7   52 49                       101 74 3 12 0   5     0   7   52 49                 101
935014 935014 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2016   grade_1 34 3 52 0   1     1   10   55 46                       101 34 3 52 0   1     1   10   55 46                 101
935225 935225 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   kindergarten 95 0 2 0   4     0   0   56 45                       101 95 0 2 0   4     0   0   56 45                 101
935237 935237 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2016   grade_12 98 0 1 0   1     0   1   45 56                       101 98 0 1 0   1     0   1   45 56                 101
935461 935461 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 01 04 2016   grade_4 47 3 50 0   1     0   0   52 49                       101 47 3 50 0   1     0   0   52 49                 101
935970 935970 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_3 53 2 4 0   40     1   1   51 50                       101 53 2 4 0   40     1   1   51 50                 101
935975 935975 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   grade_2 56 9 2 0   26     0   8   61 40                       101 56 9 2 0   26     0   8   61 40                 101
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
936129 936129 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No 1 PK 04 2016   grade_1 38 7 25 0   26     0   5   49 52                       101 38 7 25 0   26     0   5   49 52                 101
936351 936351 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2016   grade_1 7 12 72 0   2     0   8   49 52                       101 7 12 72 0   2     0   8   49 52                 101
936421 936421 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_7 29 24 20 1   22     0   5   68 33                       101 29 24 20 1   22     0   5   68 33                 101
936422 936422 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_8 26 15 29 0   24     0   7   54 47                       101 26 15 29 0   24     0   7   54 47                 101
936628 936628 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2016   grade_5 73 10 9 0   6     0   3   52 49                       101 73 10 9 0   6     0   3   52 49                 101
936786 936786 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2016   grade_6 90 0 5 0   3     0   3   45 56                       101 90 0 5 0   3     0   3   45 56                 101
936901 936901 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2016   grade_7 62 15 18 0   2     1   3   56 45                       101 62 15 18 0   2     1   3   56 45                 101
937011 937011 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2016   grade_1 36 25 35 0   1     0   4   61 40                       101 36 25 35 0   1     0   4   61 40                 101
937040 937040 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2016   kindergarten 29 10 54 0   0     0   8   44 57                       101 29 10 54 0   0     0   8   44 57                 101
937336 937336 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No 1 KG 05 2016   grade_4 84 0 8 0   8     0   1   50 51                       101 84 0 8 0   8     0   1   50 51                 101
937490 937490 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No 1 KG 03 2016   grade_1 90 1 2 3   1     0   4   49 52                       101 90 1 2 3   1     0   4   49 52                 101
937515 937515 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2016   grade_5 98 0 0 0   2     0   1   46 55                       101 98 0 0 0   2     0   1   46 55                 101
938334 938334 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No 1 KG 05 2016   grade_4 67 1 3 1   24     0   5   60 41                       101 67 1 3 1   24     0   5   60 41                 101
938635 938635 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2016   kindergarten 16 17 63 0   4     0   1   46 55                       101 16 17 63 0   4     0   1   46 55                 101
938758 938758 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_10 40 18 39 0   2     0   2   50 51                       101 40 18 39 0   2     0   2   50 51                 101
938804 938804 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No 2 06 08 2016   grade_6 14 10 73 0   4     0   0   56 45                       101 14 10 73 0   4     0   0   56 45                 101
939269 939269 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2016   grade_6 91 2 5 1   0     0   2   56 45                       101 91 2 5 1   0     0   2   56 45                 101
939271 939271 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_8 86 2 8 0   2     0   3   45 56                       101 86 2 8 0   2     0   3   45 56                 101
939366 939366 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No 3 09 12 2016   grade_11 73 1 17 0   4     0   6   48 53                       101 73 1 17 0   4     0   6   48 53                 101
939470 939470 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_7 87 2 4 0   4     0   4   48 53                       101 87 2 4 0   4     0   4   48 53                 101
939474 939474 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_11 96 4 0 0   1     0   0   48 53                       101 96 4 0 0   1     0   0   48 53                 101
939777 939777 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2016   kindergarten 95 1 2 0   1     0   2   59 42                       101 95 1 2 0   1     0   2   59 42                 101
939784 939784 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_7 85 1 8 1   2     0   4   48 53                       101 85 1 8 1   2     0   4   48 53                 101
941326 941326 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2016   grade_1 79 2 8 2   0     0   10   47 54                       101 79 2 8 2   0     0   10   47 54                 101
941423 941423 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_7 97 1 1 0   2     0   0   48 53                       101 97 1 1 0   2     0   0   48 53                 101
941464 941464 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No 1 KG 04 2016   kindergarten 87 3 7 1   0     0   3   58 43                       101 87 3 7 1   0     0   3   58 43                 101
941833 941833 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2016   grade_5 86 4 2 2   1     1   5   59 42                       101 86 4 2 2   1     1   5   59 42                 101
932825 932825 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No 1 PK PK 2016   pre_kindergarten 77 7 11 0   1     0   6   68 34                       102 77 7 11 0   1     0   6   68 34                 102
933097 933097 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2016   grade_3 17 21 55 1   3     0   5   51 51                       102 17 21 55 1   3     0   5   51 51                 102
933609 933609 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_6 1 68 28 2   2     0   1   57 45                       102 1 68 28 2   2     0   1   57 45                 102
933729 933729 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2016   grade_12 4 63 28 0   2     2   3   59 43                       102 4 63 28 0   2     2   3   59 43                 102
933765 933765 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2016   grade_11 0 77 19 0   3     0   3   43 59                       102 0 77 19 0   3     0   3   43 59                 102
933845 933845 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_10 92 1 4 0   2     0   3   48 54                       102 92 1 4 0   2     0   3   48 54                 102
933853 933853 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_4 95 0 2 0   4     0   1   44 58                       102 95 0 2 0   4     0   1   44 58                 102
933977 933977 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_3 8 80 11 1   1     0   1   52 50                       102 8 80 11 1   1     0   1   52 50                 102
934275 934275 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No 1 KG 05 2016   grade_2 77 6 2 0   11     0   6   54 48                       102 77 6 2 0   11     0   6   54 48                 102
935134 935134 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_5 56 14 23 0   4     0   5   66 36                       102 56 14 23 0   4     0   5   66 36                 102
935541 935541 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2016   pre_kindergarten 86 0 4 0   7     0   5   61 41                       102 86 0 4 0   7     0   5   61 41                 102
935675 935675 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2016   grade_4 87 0 10 0   5     0   0   47 55                       102 87 0 10 0   5     0   0   47 55                 102
935925 935925 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No 1 KG 05 2016   kindergarten 37 11 45 0   4     0   5   55 47                       102 37 11 45 0   4     0   5   55 47                 102
936123 936123 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2016   grade_1 25 4 9 0   61     0   3   48 54                       102 25 4 9 0   61     0   3   48 54                 102
936280 936280 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No 1 KG 05 2016   grade_3 6 14 74 0   8     0   0   59 43                       102 6 14 74 0   8     0   0   59 43                 102
936436 936436 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2016   grade_4 38 20 14 1   27     0   2   58 44                       102 38 20 14 1   27     0   2   58 44                 102
936638 936638 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No 1 PK 05 2016   grade_1 68 12 8 0   10     0   4   56 46                       102 68 12 8 0   10     0   4   56 46                 102
936900 936900 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2016   grade_6 59 10 21 0   2     0   10   43 59                       102 59 10 21 0   2     0   10   43 59                 102
936971 936971 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2016   grade_1 73 9 3 0   11     1   5   53 49                       102 73 9 3 0   11     1   5   53 49                 102
937015 937015 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2016   grade_5 40 14 40 0   0     0   8   59 43                       102 40 14 40 0   0     0   8   59 43                 102
938062 938062 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No 1 KG 05 2016   kindergarten 31 8 59 1   2     0   1   50 52                       102 31 8 59 1   2     0   1   50 52                 102
938321 938321 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No 1 KG 05 2016   grade_3 61 4 3 0   29     0   5   56 46                       102 61 4 3 0   29     0   5   56 46                 102
938750 938750 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2016   grade_2 2 13 85 0   2     0   0   61 41                       102 2 13 85 0   2     0   0   61 41                 102
938956 938956 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No 1 PK 02 2016   grade_1 92 1 2 0   2     0   5   53 49                       102 92 1 2 0   2     0   5   53 49                 102
939533 939533 MA Hampden   school 2512630 325   Westfield 251263002074 3250605 Westfield Technical Academy   Vocational Education School No 3 09 12 2016   grade_12 99 1 1 0   1     0   0   55 47                       102 99 1 1 0   1     0   0   55 47                 102
940582 940582 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_7 60 13 3 0   23     0   3   52 50                       102 60 13 3 0   23     0   3   52 50                 102
940604 940604 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes 1 KG 05 2016   grade_5 81 1 18 0   0     0   2   50 52                       102 81 1 18 0   0     0   2   50 52                 102
940925 940925 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No 1 KG 02 2016   grade_2 87 3 6 0   2     0   4   49 53                       102 87 3 6 0   2     0   4   49 53                 102
941157 941157 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No 1 KG 04 2016   grade_3 86 3 4 0   6     0   3   46 56                       102 86 3 4 0   6     0   3   46 56                 102
941242 941242 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_9 99 0 1 0   0     0   2   54 48                       102 99 0 1 0   0     0   2   54 48                 102
941327 941327 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2016   grade_2 78 7 7 2   1     0   7   47 55                       102 78 7 7 2   1     0   7   47 55                 102
941820 941820 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2016   grade_2 95 2 4 0   1     0   0   54 48                       102 95 2 4 0   1     0   0   54 48                 102
941993 941993 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes 4 09 10 2016   grade_9 35 16 46 0   1     0   4   52 50                       102 35 16 46 0   1     0   4   52 50                 102
941999 941999 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_6 75 5 14 1   1     1   5   52 50                       102 75 5 14 1   1     1   5   52 50                 102
934025 934025 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_10 183 648 120 4   34     3   30   535 487                       1022 183 648 120 4   34     3   30   535 487                 1022
932640 932640 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_3 81 2 7 1   8     0   4   52 51                       103 81 2 7 1   8     0   4   52 51                 103
932647 932647 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No 1 KG 05 2016   grade_4 60 5 9 1   25     0   3   55 48                       103 60 5 9 1   25     0   3   55 48                 103
933100 933100 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2016   grade_6 15 18 62 0   3     1   4   52 51                       103 15 18 62 0   3     1   4   52 51                 103
933353 933353 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2016   kindergarten 5 68 28 0   0     0   2   62 41                       103 5 68 28 0   0     0   2   62 41                 103
933727 933727 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2016   grade_12 16 37 43 1   5     0   1   41 62                       103 16 37 43 1   5     0   1   41 62                 103
933794 933794 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No 3 09 12 2016   grade_11 10 45 46 0   2     0   0   62 41                       103 10 45 46 0   2     0   0   62 41                 103
934582 934582 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2016   grade_1 89 2 5 0   1     0   6   60 43                       103 89 2 5 0   1     0   6   60 43                 103
934637 934637 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2016   grade_5 91 0 7 0   4     0   1   52 51                       103 91 0 7 0   4     0   1   52 51                 103
934843 934843 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_2 31 19 46 1   5     0   1   46 57                       103 31 19 46 1   5     0   1   46 57                 103
934996 934996 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_3 80 3 9 0   3     0   8   55 48                       103 80 3 9 0   3     0   8   55 48                 103
935401 935401 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_10 83 1 2 0   14     0   3   57 46                       103 83 1 2 0   14     0   3   57 46                 103
935442 935442 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_5 58 3 36 0   4     0   2   55 48                       103 58 3 36 0   4     0   2   55 48                 103

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