Data source: Big Local News · About: Big Local

890 rows where grade = "grade_5", state = "MA" and year = 2015 sorted by total

View and edit SQL

year

  • 2015 · 890

grade

  • grade_5 · 890
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
738426 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 04 05 2015   grade_5 * * * *   *     *   *   * *                       1                                             1
736379 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 06 2015   grade_5 3 25 69 0   3     0   0   47 53                       100 3 25 69 0   3     0   0   47 53                 100
737721 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2015   grade_5 87 2 5 0   1     0   5   43 57                       100 87 2 5 0   1     0   5   43 57                 100
738280 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_5 53 13 26 0   5     0   3   51 49                       100 53 13 26 0   5     0   3   51 49                 100
739941 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2015   grade_5 92 0 4 0   2     0   2   45 55                       100 92 0 4 0   2     0   2   45 55                 100
740184 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2015   grade_5 23 14 58 1   2     0   2   49 51                       100 23 14 58 1   2     0   2   49 51                 100
741000 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No 1 KG 05 2015   grade_5 95 1 1 0   2     0   1   50 50                       100 95 1 1 0   2     0   1   50 50                 100
743871 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_5 85 4 7 0   2     0   2   49 51                       100 85 4 7 0   2     0   2   49 51                 100
744073 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_5 88 0 8 1   1     0   2   38 62                       100 88 0 8 1   1     0   2   38 62                 100
741530 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No 1 KG 05 2015   grade_5 59 1 3 0   33     0   6   56 46                       102 59 1 3 0   33     0   6   56 46                 102
742662 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2015   grade_5 98 0 3 0   1     0   0   57 45                       102 98 0 3 0   1     0   0   57 45                 102
737424 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   grade_5 71 10 5 0   15     0   2   51 52                       103 71 10 5 0   15     0   2   51 52                 103
739076 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_5 62 10 29 0   0     0   2   49 54                       103 62 10 29 0   0     0   2   49 54                 103
739132 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_5 61 5 7 1   24     0   5   56 47                       103 61 5 7 1   24     0   5   56 47                 103
740030 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_5 96 1 1 0   0     2   3   50 53                       103 96 1 1 0   0     2   3   50 53                 103
740214 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_5 60 10 30 0   1     0   2   52 51                       103 60 10 30 0   1     0   2   52 51                 103
740988 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   grade_5 97 0 3 0   1     0   2   55 48                       103 97 0 3 0   1     0   2   55 48                 103
741435 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No 1 KG 05 2015   grade_5 82 7 10 0   4     0   0   52 51                       103 82 7 10 0   4     0   0   52 51                 103
743637 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_5 46 32 22 0   1     0   2   47 56                       103 46 32 22 0   1     0   2   47 56                 103
743775 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 2015   grade_5 73 5 22 0   2     0   1   45 58                       103 73 5 22 0   2     0   1   45 58                 103
736560 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_5 26 27 44 0   3     0   4   55 49                       104 26 27 44 0   3     0   4   55 49                 104
737793 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No 1 KG 05 2015   grade_5 87 1 4 0   8     0   4   52 52                       104 87 1 4 0   8     0   4   52 52                 104
741524 MA Norfolk   school 2510620 266   Sharon 251062001703 2660010 East Elementary   Regular School No 1 KG 05 2015   grade_5 72 1 2 0   25     0   4   49 55                       104 72 1 2 0   25     0   4   49 55                 104
738593 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_5 69 5 30 0   1     0   0   52 53                       105 69 5 30 0   1     0   0   52 53                 105
740686 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   grade_5 99 2 0 0   3     0   1   44 61                       105 99 2 0 0   3     0   1   44 61                 105
743521 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_5 87 4 2 0   11     0   1   51 54                       105 87 4 2 0   11     0   1   51 54                 105
735784 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No 1 KG 05 2015   grade_5 78 0 3 0   22     0   3   56 50                       106 78 0 3 0   22     0   3   56 50                 106
736125 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No 1 KG 05 2015   grade_5 80 1 1 0   16     0   8   61 45                       106 80 1 1 0   16     0   8   61 45                 106
739193 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2015   grade_5 92 2 4 0   4     3   1   55 51                       106 92 2 4 0   4     3   1   55 51                 106
740957 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2015   grade_5 87 3 7 0   6     0   3   62 44                       106 87 3 7 0   6     0   3   62 44                 106
742526 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No 1 KG 05 2015   grade_5 78 4 3 0   19     1   1   49 57                       106 78 4 3 0   19     1   1   49 57                 106
744823 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_5 100 3 1 0   1     0   1   52 54                       106 100 3 1 0   1     0   1   52 54                 106
737139 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2015   grade_5 22 58 20 0   2     0   5   52 55                       107 22 58 20 0   2     0   5   52 55                 107
739082 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Southeast School   Regular School No 1 KG 05 2015   grade_5 53 3 35 1   12     0   3   64 43                       107 53 3 35 1   12     0   3   64 43                 107
743620 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_5 52 30 6 0   13     0   6   47 60                       107 52 30 6 0   13     0   6   47 60                 107
739982 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_5 96 3 4 0   3     0   2   59 49                       108 96 3 4 0   3     0   2   59 49                 108
741749 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2015   grade_5 7 14 82 1   2     0   2   51 57                       108 7 14 82 1   2     0   2   51 57                 108
742132 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Peter Noyes   Regular School No 1 PK 05 2015   grade_5 87 3 3 0   10     0   5   59 49                       108 87 3 3 0   10     0   5   59 49                 108
740053 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No 1 PK 05 2015   grade_5 62 13 22 0   2     0   10   50 59                       109 62 13 22 0   2     0   10   50 59                 109
744101 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 2 04 05 2015   grade_5 99 1 5 0   1     0   3   49 60                       109 99 1 5 0   1     0   3   49 60                 109
738209 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_5 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
743719 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_5 9 1 1 0   0     0   0   5 6                       11 9 1 1 0   0     0   0   5 6                 11
744427 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2015   grade_5 10 0 0 0   0     0   1   8 3                       11 10 0 0 0   0     0   1   8 3                 11
735768 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No 1 KG 05 2015   grade_5 65 1 12 1   27     0   4   55 55                       110 65 1 12 1   27     0   4   55 55                 110
737104 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2015   grade_5 40 46 10 1   7     1   5   59 51                       110 40 46 10 1   7     1   5   59 51                 110
737727 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2015   grade_5 96 2 4 0   5     0   3   66 44                       110 96 2 4 0   5     0   3   66 44                 110
737448 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2015   grade_5 104 2 4 0   1     0   0   66 45                       111 104 2 4 0   1     0   0   66 45                 111
738038 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2015   grade_5 74 7 18 0   4     1   7   59 52                       111 74 7 18 0   4     1   7   59 52                 111
738642 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_5 104 0 1 0   2     0   4   50 61                       111 104 0 1 0   2     0   4   50 61                 111
737516 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_5 8 6 93 0   5     0   0   54 58                       112 8 6 93 0   5     0   0   54 58                 112
737559 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_5 64 4 42 0   1     0   1   65 47                       112 64 4 42 0   1     0   1   65 47                 112
738379 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_5 108 1 1 0   1     0   1   62 50                       112 108 1 1 0   1     0   1   62 50                 112
739126 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_5 62 7 3 0   37     0   3   66 46                       112 62 7 3 0   37     0   3   66 46                 112
738975 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2015   grade_5 16 5 89 0   3     0   0   61 52                       113 16 5 89 0   3     0   0   61 52                 113
740105 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No 1 KG 05 2015   grade_5 97 1 1 0   8     0   6   53 60                       113 97 1 1 0   8     0   6   53 60                 113
740130 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2015   grade_5 88 2 3 0   13     0   7   56 57                       113 88 2 3 0   13     0   7   56 57                 113
741216 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   grade_5 66 3 32 0   8     0   4   52 61                       113 66 3 32 0   8     0   4   52 61                 113
744590 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No 1 PK 05 2015   grade_5 107 0 4 0   2     0   0   47 66                       113 107 0 4 0   2     0   0   47 66                 113
736527 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_5 20 20 17 0   56     1   0   53 61                       114 20 20 17 0   56     1   0   53 61                 114
741013 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_5 103 2 1 0   0     1   7   56 58                       114 103 2 1 0   0     1   7   56 58                 114
738675 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2015   grade_5 77 16 10 0   4     0   8   58 57                       115 77 16 10 0   4     0   8   58 57                 115
738436 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_5 93 2 4 0   13     0   4   60 56                       116 93 2 4 0   13     0   4   60 56                 116
743751 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_5 73 18 5 0   13     0   7   56 60                       116 73 18 5 0   13     0   7   56 60                 116
738050 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   grade_5 65 8 25 0   8     0   11   67 50                       117 65 8 25 0   8     0   11   67 50                 117
740778 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No 2 05 07 2015   grade_5 108 3 5 0   1     0   0   63 54                       117 108 3 5 0   1     0   0   63 54                 117
737994 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_5 45 29 36 0   5     0   3   56 62                       118 45 29 36 0   5     0   3   56 62                 118
738085 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   grade_5 77 5 22 0   7     0   7   42 76                       118 77 5 22 0   7     0   7   42 76                 118
738911 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_5 4 3 111 0   0     0   0   60 58                       118 4 3 111 0   0     0   0   60 58                 118
742730 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2015   grade_5 90 3 1 1   21     0   2   59 59                       118 90 3 1 1   21     0   2   59 59                 118
742733 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No 1 03 05 2015   grade_5 67 1 3 0   41     0   6   62 56                       118 67 1 3 0   41     0   6   62 56                 118
744148 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No 1 PK 05 2015   grade_5 10 0 2 0   0     0   0   5 7                       12 10 0 2 0   0     0   0   5 7                 12
744901 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2015   grade_5 10 1 0 1   0     0   0   9 3                       12 10 1 0 1   0     0   0   9 3                 12
736989 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_5 112 1 1 0   4     0   2   65 55                       120 112 1 1 0   4     0   2   65 55                 120
739465 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No 1 KG 05 2015   grade_5 10 6 88 2   9     0   5   59 61                       120 10 6 88 2   9     0   5   59 61                 120
743498 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_5 12 33 69 0   1     0   5   62 58                       120 12 33 69 0   1     0   5   62 58                 120
744645 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2015   grade_5 110 0 6 0   0     0   4   59 61                       120 110 0 6 0   0     0   4   59 61                 120
736373 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 05 2015   grade_5 24 44 34 0   10     2   7   60 61                       121 24 44 34 0   10     2   7   60 61                 121
737615 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_5 86 3 25 0   3     0   4   64 57                       121 86 3 25 0   3     0   4   64 57                 121
743797 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_5 1 73 41 0   3     0   3   56 65                       121 1 73 41 0   3     0   3   56 65                 121
737070 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2015   grade_5 40 53 18 0   2     0   9   74 48                       122 40 53 18 0   2     0   9   74 48                 122
737893 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No 1 03 05 2015   grade_5 104 2 7 0   9     0   0   61 61                       122 104 2 7 0   9     0   0   61 61                 122
738179 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_5 44 4 52 0   7     0   15   71 51                       122 44 4 52 0   7     0   15   71 51                 122
737064 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   grade_5 17 69 25 0   0     1   11   65 58                       123 17 69 25 0   0     1   11   65 58                 123
739602 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2015   grade_5 26 35 38 1   18     0   6   67 57                       124 26 35 38 1   18     0   6   67 57                 124
741730 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2015   grade_5 97 5 14 1   3     0   4   60 64                       124 97 5 14 1   3     0   4   60 64                 124
737095 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_5 24 85 10 2   0     0   4   60 65                       125 24 85 10 2   0     0   4   60 65                 125
740550 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No 1 KG 05 2015   grade_5 113 1 2 0   9     0   0   68 57                       125 113 1 2 0   9     0   0   68 57                 125
740421 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2015   grade_5 120 0 2 0   2     0   2   62 64                       126 120 0 2 0   2     0   2   62 64                 126
738574 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   grade_5 98 6 21 0   1     1   0   56 71                       127 98 6 21 0   1     1   0   56 71                 127
742150 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No 1 03 05 2015   grade_5 120 0 1 0   1     0   5   63 64                       127 120 0 1 0   1     0   5   63 64                 127
743575 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_5 36 31 45 0   5     0   11   59 69                       128 36 31 45 0   5     0   11   59 69                 128
743607 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_5 29 65 27 0   7     0   0   61 67                       128 29 65 27 0   7     0   0   61 67                 128
744155 MA Berkshire   school 2503390 635   Central Berkshire 250339002545 6350010 Berkshire Trail Elementary   Regular School No 1 PK 05 2015   grade_5 12 0 0 0   0     0   1   4 9                       13 12 0 0 0   0     0   1   4 9                 13
737512 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_5 1 2 124 0   2     0   1   71 59                       130 1 2 124 0   2     0   1   71 59                 130
739749 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No 2 04 07 2015   grade_5 108 2 13 1   1     0   5   63 67                       130 108 2 13 1   1     0   5   63 67                 130
739876 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_5 96 1 28 0   3     0   2   68 62                       130 96 1 28 0   3     0   2   68 62                 130
735900 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_5 94 7 17 0   4     1   8   71 60                       131 94 7 17 0   4     1   8   71 60                 131
738618 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_5 94 5 28 0   3     1   0   71 60                       131 94 5 28 0   3     1   0   71 60                 131
739729 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_5 109 5 4 7   3     1   2   74 57                       131 109 5 4 7   3     1   2   74 57                 131
737124 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_5 9 99 14 0   3     1   6   65 67                       132 9 99 14 0   3     1   6   65 67                 132

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