enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 6,831 ✖
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
1679812 1679812 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_2 9 14 97 0   1     2   1   54 70 *                     124.0 9 14 97 0   1     2   1   54 70                 124
2232609 2232609 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence: Robert Frost   Regular School No Elementary KG 04 2018   grade_2 11 3 97 0   2     0   1   59 55                       114.0 11 3 97 0   2     0   1   59 55                 114
1366581 1366581 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_2 4 5 96 0   0     0   0   47 58 *                     105.0 4 5 96 0   0     0   0   47 58                 105
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1367351 1367351 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_2 19 4 94 0   0     0   4   47 74 *                     121.0 19 4 94 0   0     0   4   47 74                 121
2232635 2232635 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_2 5 1 94 0   0     0   0   55 45                       100.0 5 1 94 0   0     0   0   55 45                 100
2233235 2233235 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn: Robert L Ford   Regular School No Elementary 01 05 2018   grade_2 7 6 94 1   9     0   2   61 58                       119.0 7 6 94 1   9     0   2   61 58                 119
1124095 1124095 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_2 10 16 93 0   4     0   4   63 64                       127 10 16 93 0   4     0   4   63 64                 127
1674585 1674585 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_2 18 4 93 0   0     0   6   54 67 *                     121.0 18 4 93 0   0     0   6   54 67                 121
738943 738943 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_2 2 1 92 0   1     0   1   58 39                       97 2 1 92 0   1     0   1   58 39                 97
935786 935786 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_2 3 1 91 0   0     0   0   46 49                       95 3 1 91 0   0     0   0   46 49                 95
935791 935791 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_2 1 4 91 0   1     0   0   42 55                       97 1 4 91 0   1     0   0   42 55                 97
2043093 2043093 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_2 4 0 91 0   0     0   0   42 53                       95.0 4 0 91 0   0     0   0   42 53                 95
1125818 1125818 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary KG 05 2017   grade_2 2 2 90 0   0     0   0   50 44                       94 2 2 90 0   0     0   0   50 44                 94
2045914 2045914 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   grade_2 6 22 90 0   0     0   2   60 60                       120.0 6 22 90 0   0     0   2   60 60                 120
735723 735723 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2015   grade_2 76 2 9 0   1     1   4   44 49                       93 76 2 9 0   1     1   4   44 49                 93
735926 735926 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   grade_2 79 0 9 0   5     0   3   45 51                       96 79 0 9 0   5     0   3   45 51                 96
735958 735958 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_2 72 2 9 0   0     0   5   44 44                       88 72 2 9 0   0     0   5   44 44                 88
736267 736267 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 04 2015   grade_2 3 0 9 0   0     0   0   4 8                       12 3 0 9 0   0     0   0   4 8                 12
737101 737101 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2015   grade_2 51 73 9 0   5     0   7   84 61                       145 51 73 9 0   5     0   7   84 61                 145
738479 738479 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 03 2015   grade_2 44 1 9 0   1     0   0   28 27                       55 44 1 9 0   1     0   0   28 27                 55
738672 738672 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No 1 PK 03 2015   grade_2 45 11 9 0   3     0   8   30 46                       76 45 11 9 0   3     0   8   30 46                 76
739795 739795 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No 1 PK 05 2015   grade_2 43 11 9 1   11     0   6   49 32                       81 43 11 9 1   11     0   6   49 32                 81
740326 740326 MA Middlesex   school 2508610 207   Newton 250861001360 2070025 Cabot   Regular School No 1 KG 05 2015   grade_2 56 5 9 0   7     0   2   28 51                       79 56 5 9 0   7     0   2   28 51                 79
740350 740350 MA Middlesex   school 2508610 207   Newton 250861001367 2070075 Horace Mann   Regular School No 1 KG 05 2015   grade_2 47 0 9 0   13     0   6   38 37                       75 47 0 9 0   13     0   6   38 37                 75
740493 740493 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No 1 PK 05 2015   grade_2 50 4 9 0   7     0   4   39 35                       74 50 4 9 0   7     0   4   39 35                 74
740499 740499 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No 1 KG 05 2015   grade_2 44 1 9 1   12     0   0   34 33                       67 44 1 9 1   12     0   0   34 33                 67
740746 740746 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No 1 PK 02 2015   grade_2 69 0 9 1   1     0   8   51 37                       88 69 0 9 1   1     0   8   51 37                 88
740789 740789 MA Essex   school 2509360 229   Peabody 250936001501 2290005 Captain Samuel Brown   Regular School No 1 KG 05 2015   grade_2 41 1 9 0   1     0   2   26 28                       54 41 1 9 0   1     0   2   26 28                 54
741432 741432 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No 1 KG 05 2015   grade_2 66 3 9 0   3     0   2   47 36                       83 66 3 9 0   3     0   2   47 36                 83
742069 742069 MA Norfolk   school 2511250 285   Stoughton 251125001862 2850014 Joseph R Dawe Jr Elementary   Regular School No 1 KG 05 2015   grade_2 27 15 9 0   2     0   1   32 22                       54 27 15 9 0   2     0   1   32 22                 54
742341 742341 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No 1 KG 04 2015   grade_2 70 0 9 0   3     0   2   44 40                       84 70 0 9 0   3     0   2   44 40                 84
742629 742629 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No 1 PK 03 2015   grade_2 50 2 9 0   28     0   6   34 61                       95 50 2 9 0   28     0   6   34 61                 95
742673 742673 MA Hampden   school 2512630 325   Westfield 251263002064 3250015 Franklin Ave   Regular School No 1 KG 05 2015   grade_2 23 0 9 0   3     0   1   21 15                       36 23 0 9 0   3     0   1   21 15                 36
742958 742958 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No 1 01 03 2015   grade_2 98 0 9 0   7     0   3   57 60                       117 98 0 9 0   7     0   3   57 60                 117
743067 743067 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No 1 PK 05 2015   grade_2 18 4 9 0   3     0   2   20 16                       36 18 4 9 0   3     0   2   20 16                 36
743073 743073 MA Middlesex   school 2513200 347   Woburn 251320002188 3470055 Malcolm White   Regular School No 1 KG 05 2015   grade_2 33 5 9 0   3     0   4   25 29                       54 33 5 9 0   3     0   4   25 29                 54
743179 743179 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2015   grade_2 36 3 9 0   3     0   1   25 27                       52 36 3 9 0   3     0   1   25 27                 52
743256 743256 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_2 9 12 9 0   1     0   2   18 15                       33 9 12 9 0   1     0   2   18 15                 33
743553 743553 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_2 9 25 9 0   2     0   2   27 20                       47 9 25 9 0   2     0   2   27 20                 47
744915 744915 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No 1 KG 02 2015   grade_2 109 2 9 0   5     0   4   64 65                       129 109 2 9 0   5     0   4   64 65                 129
744935 744935 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No 1 KG 05 2015   grade_2 65 1 9 0   5     0   3   43 40                       83 65 1 9 0   5     0   3   43 40                 83
932601 932601 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2016   grade_2 74 1 9 0   1     0   3   48 40                       88 74 1 9 0   1     0   3   48 40                 88
932715 932715 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2016   grade_2 48 2 9 0   11     0   3   37 36                       73 48 2 9 0   11     0   3   37 36                 73
932764 932764 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No 1 KG 04 2016   grade_2 71 5 9 1   4     0   6   51 45                       96 71 5 9 1   4     0   6   51 45                 96
932828 932828 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   grade_2 56 3 9 0   2     0   1   38 33                       71 56 3 9 0   2     0   1   38 33                 71
933625 933625 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_2 10 3 9 0   0     0   2   20 4                       24 10 3 9 0   0     0   2   20 4                 24
933976 933976 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_2 12 59 9 0   0     0   7   42 45                       87 12 59 9 0   0     0   7   42 45                 87
934115 934115 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_2 45 1 9 0   8     0   8   34 37                       71 45 1 9 0   8     0   8   34 37                 71
934210 934210 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No 1 PK 05 2016   grade_2 10 6 9 0   10     0   4   22 17                       39 10 6 9 0   10     0   4   22 17                 39
934691 934691 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2016   grade_2 206 0 9 0   2     0   5   114 108                       222 206 0 9 0   2     0   5   114 108                 222
934786 934786 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_2 28 1 9 1   0     0   4   18 25                       43 28 1 9 1   0     0   4   18 25                 43
935101 935101 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2016   grade_2 64 5 9 0   12     0   3   43 50                       93 64 5 9 0   12     0   3   43 50                 93
935240 935240 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2016   grade_2 42 1 9 1   1     0   1   28 27                       55 42 1 9 1   1     0   1   28 27                 55
935329 935329 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 04 2016   grade_2 27 0 9 0   0     0   9   23 22                       45 27 0 9 0   0     0   9   23 22                 45
935647 935647 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No 1 02 03 2016   grade_2 178 1 9 1   26     0   15   118 112                       230 178 1 9 1   26     0   15   118 112                 230
936407 936407 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_2 28 18 9 0   35     0   4   40 54                       94 28 18 9 0   35     0   4   40 54                 94
936639 936639 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No 1 PK 05 2016   grade_2 72 9 9 1   12     0   7   63 47                       110 72 9 9 1   12     0   7   63 47                 110
936858 936858 MA Norfolk   school 2507980 189   Milton 250798001263 1890020 Tucker   Regular School No 1 PK 05 2016   grade_2 25 22 9 0   5     0   8   43 26                       69 25 22 9 0   5     0   8   43 26                 69
936959 936959 MA Norfolk   school 2508370 199   Needham 250837001313 1990035 Hillside Elementary   Regular School No 1 KG 05 2016   grade_2 61 4 9 0   7     0   7   38 50                       88 61 4 9 0   7     0   7   38 50                 88
937604 937604 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No 1 PK 04 2016   grade_2 85 1 9 0   2     0   7   58 46                       104 85 1 9 0   2     0   7   58 46                 104
937832 937832 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No 1 PK 04 2016   grade_2 97 0 9 1   0     0   5   56 56                       112 97 0 9 1   0     0   5   56 56                 112
937975 937975 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 J F Kennedy Elementary   Regular School No 1 PK 05 2016   grade_2 11 49 9 0   8     1   2   43 37                       80 11 49 9 0   8     1   2   43 37                 80
938165 938165 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No 1 KG 05 2016   grade_2 26 3 9 0   1     0   0   12 27                       39 26 3 9 0   1     0   0   12 27                 39
938359 938359 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_2 94 4 9 1   86     0   8   100 102                       202 94 4 9 1   86     0   8   100 102                 202
938461 938461 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2016   grade_2 22 4 9 0   2     0   2   15 24                       39 22 4 9 0   2     0   2   15 24                 39
939030 939030 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No 1 KG 04 2016   grade_2 55 17 9 0   1     0   5   44 43                       87 55 17 9 0   1     0   5   44 43                 87
939223 939223 MA Middlesex   school 2512000 308   Waltham 251200001967 3080032 Douglas MacArthur Elementary School   Regular School No 1 KG 05 2016   grade_2 40 8 9 0   1     0   5   33 30                       63 40 8 9 0   1     0   5   33 30                 63
939318 939318 MA Middlesex   school 2512180 314   Watertown 251218002002 3140025 James Russell Lowell   Regular School No 1 PK 05 2016   grade_2 37 0 9 1   13     0   2   37 25                       62 37 0 9 1   13     0   2   37 25                 62
939609 939609 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No 1 KG 05 2016   grade_2 63 5 9 0   14     0   3   37 57                       94 63 5 9 0   14     0   3   37 57                 94
939876 939876 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No 1 PK 05 2016   grade_2 28 2 9 0   2     0   2   27 16                       43 28 2 9 0   2     0   2   27 16                 43
939894 939894 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No 1 KG 05 2016   grade_2 21 8 9 0   7     0   2   26 21                       47 21 8 9 0   7     0   2   26 21                 47
940057 940057 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2016   grade_2 23 4 9 0   5     0   3   17 27                       44 23 4 9 0   5     0   3   17 27                 44
940306 940306 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2016   grade_2 46 3 9 2   0     0   1   29 32                       61 46 3 9 2   0     0   1   29 32                 61
940577 940577 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_2 68 20 9 0   26     0   7   66 64                       130 68 20 9 0   26     0   7   66 64                 130
941062 941062 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No 1 02 04 2016   grade_2 97 6 9 0   1     0   6   55 64                       119 97 6 9 0   1     0   6   55 64                 119
941663 941663 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 KG 04 2016   grade_2 82 1 9 0   2     0   3   51 46                       97 82 1 9 0   2     0   3   51 46                 97
1122056 1122056 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_2 19 1 9 0   9     0   4   21 21                       42 19 1 9 0   9     0   4   21 21                 42
1122213 1122213 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2017   grade_2 62 4 9 0   4     0   11   47 43                       90 62 4 9 0   4     0   11   47 43                 90
1122409 1122409 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2017   grade_2 43 3 9 0   23     0   4   48 34                       82 43 3 9 0   23     0   4   48 34                 82
1122475 1122475 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No Elementary KG 05 2017   grade_2 49 3 9 1   0     0   0   32 30                       62 49 3 9 1   0     0   0   32 30                 62
1122592 1122592 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_2 11 4 9 0   0     0   0   11 13                       24 11 4 9 0   0     0   0   11 13                 24
1122671 1122671 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_2 5 0 9 0   0     0   2   9 7                       16 5 0 9 0   0     0   2   9 7                 16
1123770 1123770 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2017   grade_2 38 2 9 0   33     0   6   40 48                       88 38 2 9 0   33     0   6   40 48                 88
1123801 1123801 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2017   grade_2 45 5 9 0   8     0   3   38 32                       70 45 5 9 0   8     0   3   38 32                 70
1124387 1124387 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_2 18 3 9 0   1     0   0   15 16                       31 18 3 9 0   1     0   0   15 16                 31
1124973 1124973 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_2 46 4 9 0   13     0   0   30 42                       72 46 4 9 0   13     0   0   30 42                 72
1125141 1125141 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2017   grade_2 47 0 9 1   2     0   1   36 24                       60 47 0 9 1   2     0   1   36 24                 60
1125528 1125528 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   grade_2 174 3 9 0   24     0   9   106 113                       219 174 3 9 0   24     0   9   106 113                 219
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1126521 1126521 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No Elementary KG 04 2017   grade_2 64 0 9 0   6     0   2   37 44                       81 64 0 9 0   6     0   2   37 44                 81
1126619 1126619 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No Elementary KG 03 2017   grade_2 60 3 9 0   3     0   3   49 29                       78 60 3 9 0   3     0   3   49 29                 78
1126622 1126622 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 02 03 2017   grade_2 58 2 9 0   3     0   7   41 38                       79 58 2 9 0   3     0   7   41 38                 79
1127079 1127079 MA Norfolk   school 2507980 189   Milton 250798001263 1890020 Tucker   Regular School No Elementary PK 05 2017   grade_2 31 23 9 0   2     0   3   39 29                       68 31 23 9 0   2     0   3   39 29                 68
1127247 1127247 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2017   grade_2 29 3 9 0   0     0   5   15 31                       46 29 3 9 0   0     0   5   15 31                 46
1127360 1127360 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary KG 05 2017   grade_2 30 4 9 0   0     0   4   14 33                       47 30 4 9 0   0     0   4   14 33                 47
1127434 1127434 MA Middlesex   school 2508610 207   Newton 250861001359 2070020 C C Burr   Regular School No Elementary KG 05 2017   grade_2 45 2 9 1   14     0   3   40 34                       74 45 2 9 1   14     0   3   40 34                 74
1127665 1127665 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary KG 05 2017   grade_2 40 1 9 0   4     0   1   27 28                       55 40 1 9 0   4     0   1   27 28                 55
1128004 1128004 MA Essex   school 2509360 229   Peabody 250936001493 2290015 Center   Regular School No Elementary KG 05 2017   grade_2 47 5 9 0   2     0   1   29 35                       64 47 5 9 0   2     0   1   29 35                 64
1130104 1130104 MA Norfolk   school 2512270 317   Wellesley 251227002503 3170045 Schofield   Regular School No Elementary KG 05 2017   grade_2 38 3 9 0   9     0   4   31 32                       63 38 3 9 0   9     0   4   31 32                 63

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