enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by native_hawaiian_pacific_islander 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
1128313 1128313 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2017   grade_2 38 12 12 0   49     8   4   65 58                       123 38 12 12 0   49     8   4   65 58                 123
1676882 1676882 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_2 21 1 5 0   5     7   4   24 19 *                     43.0 21 1 5 0   5     7   4   24 19                 43
2040164 2040164 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_2 71 2 5 0   0     4   2   47 37                       84.0 71 2 5 0   0     4   2   47 37                 84
741060 741060 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_2 43 13 11 0   25     3   3   57 41                       98 43 13 11 0   25     3   3   57 41                 98
742075 742075 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2015   grade_2 29 7 2 0   2     3   4   19 28                       47 29 7 2 0   2     3   4   19 28                 47
1132209 1132209 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2017   grade_2 37 0 0 0   0     3   1   19 22                       41 37 0 0 0   0     3   1   19 22                 41
1369771 1369771 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary KG 05 2020   grade_2 21 5 8 0   23     3   0   28 32 *                     60.0 21 5 8 0   23     3   0   28 32                 60
2042478 2042478 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_2 55 0 4 1   2     3   2   35 32                       67.0 55 0 4 1   2     3   2   35 32                 67
736422 736422 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   grade_2 0 30 19 0   4     2   3   24 34                       58 0 30 19 0   4     2   3   24 34                 58
736695 736695 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_2 3 52 29 0   0     2   2   40 48                       88 3 52 29 0   0     2   2   40 48                 88
740547 740547 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No 1 KG 05 2015   grade_2 105 1 2 0   7     2   3   55 65                       120 105 1 2 0   7     2   3   55 65                 120
742116 742116 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2015   grade_2 58 0 4 1   7     2   3   39 36                       75 58 0 4 1   7     2   3   39 36                 75
934281 934281 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2016   grade_2 65 6 2 0   12     2   4   45 46                       91 65 6 2 0   12     2   4   45 46                 91
935227 935227 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_2 197 2 3 0   3     2   2   105 104                       209 197 2 3 0   3     2   2   105 104                 209
936049 936049 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2016   grade_2 64 0 4 0   19     2   3   43 49                       92 64 0 4 0   19     2   3   43 49                 92
937900 937900 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2016   grade_2 42 11 7 0   64     2   6   82 50                       132 42 11 7 0   64     2   6   82 50                 132
938926 938926 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2016   grade_2 68 1 2 1   16     2   1   54 37                       91 68 1 2 1   16     2   1   54 37                 91
1123616 1123616 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_2 21 68 13 0   1     2   6   55 56                       111 21 68 13 0   1     2   6   55 56                 111
1123662 1123662 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_2 12 62 17 0   1     2   9   57 46                       103 12 62 17 0   1     2   9   57 46                 103
1123993 1123993 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2017   grade_2 43 4 7 0   15     2   2   39 34                       73 43 4 7 0   15     2   2   39 34                 73
1365134 1365134 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2020   grade_2 62 2 13 0   3     2   2   43 41 *                     84.0 62 2 13 0   3     2   2   43 41                 84
1365138 1365138 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2020   grade_2 58 1 3 0   1     2   4   38 31 *                     69.0 58 1 3 0   1     2   4   38 31                 69
1367496 1367496 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2020   grade_2 19 3 4 0   1     2   1   12 18 *                     30.0 19 3 4 0   1     2   1   12 18                 30
1373173 1373173 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   grade_2 224 8 9 0   5     2   8   143 113 *                     256.0 224 8 9 0   5     2   8   143 113                 256
1673035 1673035 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_2 0 24 17 0   1     2   3   22 25 *                     47.0 0 24 17 0   1     2   3   22 25                 47
1674641 1674641 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_2 48 0 2 0   2     2   0   28 26 *                     54.0 48 0 2 0   2     2   0   28 26                 54
1674659 1674659 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_2 38 0 2 0   2     2   0   21 23 *                     44.0 38 0 2 0   2     2   0   21 23                 44
1676997 1676997 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_2 23 5 19 0   6     2   0   28 27 *                     55.0 23 5 19 0   6     2   0   28 27                 55
1678688 1678688 MA Norfolk   school 2511970 307   Walpole 251197001960 3070015 Walpole - Fisher   Regular School No Elementary KG 05 2021   grade_2 52 2 5 0   14     2   3   43 35 *                     78.0 52 2 5 0   14     2   3   43 35                 78
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
1680727 1680727 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Hampden-Wilbraham - Stony Hill School   Regular School No Elementary 02 03 2021   grade_2 114 3 17 0   3     2   8   80 67 *                     147.0 114 3 17 0   3     2   8   80 67                 147
2040700 2040700 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_2 0 47 37 1   2     2   3   45 47                       92.0 0 47 37 1   2     2   3   45 47                 92
2045205 2045205 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No Elementary KG 05 2019   grade_2 31 6 1 1   16     2   0   33 24                       57.0 31 6 1 1   16     2   0   33 24                 57
2228932 2228932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_2 49 0 0 0   15     2   4   32 38                       70.0 49 0 0 0   15     2   4   32 38                 70
2237541 2237541 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Woburn: Mary D Altavesta   Regular School No Elementary KG 05 2018   grade_2 22 4 10 0   12     2   1   27 24                       51.0 22 4 10 0   12     2   1   27 24                 51
735686 735686 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   grade_2 61 0 0 0   1     1   1   29 35                       64 61 0 0 0   1     1   1   29 35                 64
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
735781 735781 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No 1 KG 05 2015   grade_2 57 1 3 0   17     1   0   41 38                       79 57 1 3 0   17     1   0   41 38                 79
735820 735820 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2015   grade_2 48 4 3 0   9     1   1   39 27                       66 48 4 3 0   9     1   1   39 27                 66
735839 735839 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   grade_2 55 3 6 1   12     1   4   45 37                       82 55 3 6 1   12     1   4   45 37                 82
735962 735962 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_2 54 17 14 1   1     1   6   42 52                       94 54 17 14 1   1     1   6   42 52                 94
735998 735998 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_2 158 5 3 0   4     1   1   98 74                       172 158 5 3 0   4     1   1   98 74                 172
736042 736042 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_2 48 1 6 0   12     1   2   36 34                       70 48 1 6 0   12     1   2   36 34                 70
736108 736108 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No 1 KG 05 2015   grade_2 64 2 12 0   5     1   0   45 39                       84 64 2 12 0   5     1   0   45 39                 84
736384 736384 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2015   grade_2 2 34 7 0   1     1   3   21 27                       48 2 34 7 0   1     1   3   21 27                 48
736473 736473 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No 1 PK 05 2015   grade_2 10 30 39 0   24     1   4   59 49                       108 10 30 39 0   24     1   4   59 49                 108
736524 736524 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_2 15 5 22 0   32     1   1   45 31                       76 15 5 22 0   32     1   1   45 31                 76
736590 736590 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   grade_2 3 12 64 0   6     1   4   53 37                       90 3 12 64 0   6     1   4   53 37                 90
736625 736625 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2015   grade_2 3 18 13 0   0     1   1   23 13                       36 3 18 13 0   0     1   1   23 13                 36
737080 737080 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2015   grade_2 37 64 10 1   4     1   2   68 51                       119 37 64 10 1   4     1   2   68 51                 119
737218 737218 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2015   grade_2 46 1 7 0   7     1   7   25 44                       69 46 1 7 0   7     1   7   25 44                 69
737357 737357 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2015   grade_2 19 17 1 0   6     1   1   20 25                       45 19 17 1 0   6     1   1   20 25                 45
737445 737445 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2015   grade_2 119 0 3 0   0     1   1   68 56                       124 119 0 3 0   0     1   1   68 56                 124
738035 738035 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2015   grade_2 71 12 20 0   4     1   14   65 57                       122 71 12 20 0   4     1   14   65 57                 122
738176 738176 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_2 44 4 55 0   9     1   8   58 63                       121 44 4 55 0   9     1   8   58 63                 121
738376 738376 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_2 89 1 1 0   2     1   0   44 50                       94 89 1 1 0   2     1   0   44 50                 94
738583 738583 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2015   grade_2 60 8 8 0   3     1   0   44 36                       80 60 8 8 0   3     1   0   44 36                 80
738599 738599 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No 1 KG 04 2015   grade_2 68 4 16 0   3     1   2   52 42                       94 68 4 16 0   3     1   2   52 42                 94
738617 738617 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2015   grade_2 51 0 3 0   1     1   0   29 27                       56 51 0 3 0   1     1   0   29 27                 56
739123 739123 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_2 49 4 3 0   39     1   1   51 46                       97 49 4 3 0   39     1   1   51 46                 97
739203 739203 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2015   grade_2 62 1 2 0   11     1   4   35 46                       81 62 1 2 0   11     1   4   35 46                 81
740168 740168 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   grade_2 44 30 36 0   0     1   16   66 61                       127 44 30 36 0   0     1   16   66 61                 127
740429 740429 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_2 41 0 2 0   0     1   2   20 26                       46 41 0 2 0   0     1   2   20 26                 46
740505 740505 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No 1 KG 05 2015   grade_2 38 3 4 0   3     1   0   27 22                       49 38 3 4 0   3     1   0   27 22                 49
740574 740574 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No 1 KG 05 2015   grade_2 40 2 0 1   5     1   0   26 23                       49 40 2 0 1   5     1   0   26 23                 49
740580 740580 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No 1 KG 05 2015   grade_2 29 1 5 0   7     1   1   24 20                       44 29 1 5 0   7     1   1   24 20                 44
740593 740593 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No 1 PK 05 2015   grade_2 25 0 4 0   4     1   1   19 16                       35 25 0 4 0   4     1   1   19 16                 35
740705 740705 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2015   grade_2 51 9 3 0   11     1   0   31 44                       75 51 9 3 0   11     1   0   31 44                 75
741082 741082 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No 1 KG 05 2015   grade_2 23 3 2 0   34     1   1   29 35                       64 23 3 2 0   34     1   1   29 35                 64
741690 741690 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No 1 PK 06 2015   grade_2 66 0 10 0   2     1   3   45 37                       82 66 0 10 0   2     1   3   45 37                 82
741931 741931 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Washington   Regular School No 1 PK 05 2015   grade_2 12 14 46 0   5     1   1   45 34                       79 12 14 46 0   5     1   1   45 34                 79
742062 742062 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No 1 KG 05 2015   grade_2 34 15 1 0   1     1   2   20 34                       54 34 15 1 0   1     1   2   20 34                 54
742336 742336 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Dolbeare   Regular School No 1 KG 04 2015   grade_2 68 0 6 0   2     1   6   41 42                       83 68 0 6 0   2     1   6   41 42                 83
742691 742691 MA Hampden   school 2512630 325   Westfield 251263002605 3250033 Munger Hill   Regular School No 1 KG 05 2015   grade_2 50 0 5 0   1     1   1   36 22                       58 50 0 5 0   1     1   1   36 22                 58
742809 742809 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No 1 KG 05 2015   grade_2 52 3 10 0   3     1   3   36 36                       72 52 3 10 0   3     1   3   36 36                 72
742975 742975 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2015   grade_2 92 3 7 0   5     1   1   59 50                       109 92 3 7 0   5     1   1   59 50                 109
743487 743487 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 2015   grade_2 57 7 4 0   5     1   1   31 44                       75 57 7 4 0   5     1   1   31 44                 75
743838 743838 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_2 13 45 18 2   8     1   1   45 43                       88 13 45 18 2   8     1   1   45 43                 88
744244 744244 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No 1 02 04 2015   grade_2 150 1 14 1   2     1   4   92 81                       173 150 1 14 1   2     1   4   92 81                 173
744564 744564 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No 1 02 04 2015   grade_2 58 0 2 0   0     1   2   37 26                       63 58 0 2 0   0     1   2   37 26                 63
932836 932836 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2016   grade_2 43 10 20 0   2     1   9   52 33                       85 43 10 20 0   2     1   9   52 33                 85
932840 932840 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   grade_2 91 2 8 1   2     1   6   49 62                       111 91 2 8 1   2     1   6   49 62                 111
933115 933115 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No 1 PK 05 2016   grade_2 9 26 72 0   2     1   2   60 52                       112 9 26 72 0   2     1   2   60 52                 112
933223 933223 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2016   grade_2 3 36 19 0   0     1   3   28 34                       62 3 36 19 0   0     1   3   28 34                 62
933237 933237 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 06 2016   grade_2 15 45 33 0   7     1   4   48 57                       105 15 45 33 0   7     1   4   48 57                 105
933332 933332 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2016   grade_2 35 7 12 0   6     1   2   38 25                       63 35 7 12 0   6     1   2   38 25                 63
933342 933342 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No 1 PK 05 2016   grade_2 8 26 37 0   40     1   2   62 52                       114 8 26 37 0   40     1   2   62 52                 114
933349 933349 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No 1 PK 05 2016   grade_2 17 1 24 0   1     1   3   23 24                       47 17 1 24 0   1     1   3   23 24                 47
933420 933420 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_2 2 37 51 1   2     1   3   51 46                       97 2 37 51 1   2     1   3   51 46                 97
933446 933446 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2016   grade_2 6 2 58 0   2     1   1   42 28                       70 6 2 58 0   2     1   1   42 28                 70
933597 933597 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_2 1 36 19 0   0     1   2   24 35                       59 1 36 19 0   0     1   2   24 35                 59
933638 933638 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_2 3 36 64 0   0     1   0   54 50                       104 3 36 64 0   0     1   0   54 50                 104
933883 933883 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2016   grade_2 55 2 5 0   21     1   1   38 47                       85 55 2 5 0   21     1   1   38 47                 85
934087 934087 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_2 38 6 5 0   27     1   5   46 36                       82 38 6 5 0   27     1   5   46 36                 82
934388 934388 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2016   grade_2 46 0 19 0   5     1   2   41 32                       73 46 0 19 0   5     1   2   41 32                 73
935020 935020 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2016   grade_2 52 9 48 0   4     1   9   65 58                       123 52 9 48 0   4     1   9   65 58                 123
935069 935069 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2016   grade_2 52 0 2 0   2     1   0   26 31                       57 52 0 2 0   2     1   0   26 31                 57
935157 935157 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2016   grade_2 48 1 0 0   10     1   0   30 30                       60 48 1 0 0   10     1   0   30 30                 60
935163 935163 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   grade_2 69 1 0 0   2     1   0   39 34                       73 69 1 0 0   2     1   0   39 34                 73
935205 935205 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 02 04 2016   grade_2 136 6 28 0   2     1   16   112 77                       189 136 6 28 0   2     1   16   112 77                 189

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