enrollments

Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by native_american_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,880 ✖
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
936567 936567 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_1 72 1 8 9   1     0   9   47 53                       100 72 1 8 9   1     0   9   47 53                 100
739723 739723 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_1 98 3 5 8   1     0   7   62 60                       122 98 3 5 8   1     0   7   62 60                 122
1126733 1126733 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_1 80 6 10 8   3     0   9   60 56                       116 80 6 10 8   3     0   9   60 56                 116
2233554 2233554 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_1 68 5 6 8   2     1   11   47 54                       101.0 68 5 6 8   2     1   11   47 54                 101
739944 739944 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   grade_1 94 6 41 6   4     0   5   92 64                       156 94 6 41 6   4     0   5   92 64                 156
742471 742471 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   grade_1 169 20 8 6   2     0   23   101 127                       228 169 20 8 6   2     0   23   101 127                 228
2043864 2043864 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_1 85 2 4 6   3     0   14   66 48                       114.0 85 2 4 6   3     0   14   66 48                 114
737072 737072 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_1 24 62 78 5   1     0   10   94 86                       180 24 62 78 5   1     0   10   94 86                 180
738135 738135 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_1 35 2 1 5   1     0   4   26 22                       48 35 2 1 5   1     0   4   26 22                 48
744193 744193 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   grade_1 89 7 6 5   2     0   9   59 59                       118 89 7 6 5   2     0   9   59 59                 118
1373949 1373949 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_1 25 0 4 5   0     0   3   23 14 *                     37.0 25 0 4 5   0     0   3   23 14                 37
2238823 2238823 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth: Station Avenue Elementary   Regular School No Elementary KG 03 2018   grade_1 70 10 6 5   2     1   6   61 39                       100.0 70 10 6 5   2     1   6   61 39                 100
735858 735858 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   grade_1 149 3 19 4   23     0   8   108 98                       206 149 3 19 4   23     0   8   108 98                 206
932734 932734 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   grade_1 160 5 9 4   29     0   5   99 113                       212 160 5 9 4   29     0   5   99 113                 212
936788 936788 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2016   grade_1 86 5 47 4   4     1   11   85 73                       158 86 5 47 4   4     1   11   85 73                 158
941015 941015 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No 1 PK 03 2016   grade_1 27 2 13 4   0     0   6   30 22                       52 27 2 13 4   0     0   6   30 22                 52
1126670 1126670 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No Elementary KG 04 2017   grade_1 84 8 61 4   20     0   6   101 82                       183 84 8 61 4   20     0   6   101 82                 183
1132826 1132826 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_1 33 0 1 4   0     0   1   23 16                       39 33 0 1 4   0     0   1   23 16                 39
2045661 2045661 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_1 29 5 10 4   59     0   4   54 57                       111.0 29 5 10 4   59     0   4   54 57                 111
738140 738140 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_1 76 0 7 3   4     0   4   45 49                       94 76 0 7 3   4     0   4   45 49                 94
739947 739947 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   grade_1 110 4 41 3   5     0   11   82 92                       174 110 4 41 3   5     0   11   82 92                 174
744189 744189 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No 1 PK 03 2015   grade_1 38 5 13 3   1     0   4   31 33                       64 38 5 13 3   1     0   4   31 33                 64
934785 934785 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_1 30 1 6 3   0     0   4   20 24                       44 30 1 6 3   0     0   4   20 24                 44
936603 936603 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2016   grade_1 140 1 11 3   6     0   1   92 70                       162 140 1 11 3   6     0   1   92 70                 162
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
939893 939893 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No 1 KG 05 2016   grade_1 17 3 8 3   12     0   0   25 18                       43 17 3 8 3   12     0   0   25 18                 43
940229 940229 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   grade_1 10 2 22 3   0     0   3   21 19                       40 10 2 22 3   0     0   3   21 19                 40
1123578 1123578 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_1 23 89 15 3   0     0   10   81 59                       140 23 89 15 3   0     0   10   81 59                 140
1126797 1126797 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No Elementary PK 05 2017   grade_1 53 10 11 3   10     0   3   39 51                       90 53 10 11 3   10     0   3   39 51                 90
1131987 1131987 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   grade_1 36 5 9 3   1     0   9   35 28                       63 36 5 9 3   1     0   9   35 28                 63
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1368793 1368793 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_1 60 3 13 3   1     0   15   48 47 *                     95.0 60 3 13 3   1     0   15   48 47                 95
1368864 1368864 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2020   grade_1 55 10 10 3   8     0   4   43 47 *                     90.0 55 10 10 3   8     0   4   43 47                 90
1372660 1372660 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_1 18 61 31 3   2     0   5   54 66 *                     120.0 18 61 31 3   2     0   5   54 66                 120
1672305 1672305 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_1 25 9 24 3   4     0   3   38 30 *                     68.0 25 9 24 3   4     0   3   38 30                 68
1675814 1675814 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Lynn - Edward A Sisson   Regular School No Elementary PK 05 2021   grade_1 19 2 31 3   7     0   8   34 36 *                     70.0 19 2 31 3   7     0   8   34 36                 70
1678779 1678779 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham - John William Decas   Regular School No Elementary PK 02 2021   grade_1 124 7 18 3   1     0   31   91 93 *                     184.0 124 7 18 3   1     0   31   91 93                 184
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2046601 2046601 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   grade_1 136 17 21 3   1     0   21   107 92                       199.0 136 17 21 3   1     0   21   107 92                 199
2231659 2231659 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth: East Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_1 36 2 3 3   0     0   4   28 20                       48.0 36 2 3 3   0     0   4   28 20                 48
2238818 2238818 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   grade_1 31 5 7 3   0     1   5   35 17                       52.0 31 5 7 3   0     1   5   35 17                 52
735938 735938 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_1 31 10 1 2   4     0   5   27 26                       53 31 10 1 2   4     0   5   27 26                 53
736252 736252 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2015   grade_1 0 69 12 2   1     0   4   36 52                       88 0 69 12 2   1     0   4   36 52                 88
736971 736971 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   grade_1 74 1 2 2   2     0   3   42 42                       84 74 1 2 2   2     0   3   42 42                 84
737114 737114 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_1 23 71 16 2   9     0   7   59 69                       128 23 71 16 2   9     0   7   59 69                 128
737135 737135 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2015   grade_1 31 58 24 2   2     0   6   74 49                       123 31 58 24 2   2     0   6   74 49                 123
737288 737288 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No 1 KG 05 2015   grade_1 53 7 5 2   18     0   0   42 43                       85 53 7 5 2   18     0   0   42 43                 85
737474 737474 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_1 80 1 2 2   11     0   4   58 42                       100 80 1 2 2   11     0   4   58 42                 100
741100 741100 MA Norfolk   school 2509870 243   Quincy 250987001583 2430095 Squantum   Regular School No 1 KG 05 2015   grade_1 33 3 1 2   21     0   1   30 31                       61 33 3 1 2   21     0   1   30 31                 61
742378 742378 MA Norfolk   school 2511970 307   Walpole 251197002563 3070010 Boyden   Regular School No 1 KG 05 2015   grade_1 47 4 3 2   1     0   2   34 25                       59 47 4 3 2   1     0   2   34 25                 59
742384 742384 MA Norfolk   school 2511970 307   Walpole 251197001960 3070015 Fisher   Regular School No 1 KG 05 2015   grade_1 59 2 3 2   12     0   2   45 35                       80 59 2 3 2   12     0   2   45 35                 80
742439 742439 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Henry Whittemore Elementary School   Regular School No 1 KG 05 2015   grade_1 11 1 64 2   2     1   1   44 38                       82 11 1 64 2   2     1   1   44 38                 82
743486 743486 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_1 52 4 9 2   0     0   1   33 35                       68 52 4 9 2   0     0   1   33 35                 68
745008 745008 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2015   grade_1 75 2 3 2   0     0   5   36 51                       87 75 2 3 2   0     0   5   36 51                 87
933927 933927 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_1 17 98 30 2   0     0   15   90 72                       162 17 98 30 2   0     0   15   90 72                 162
933981 933981 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_1 21 92 14 2   8     0   7   79 65                       144 21 92 14 2   8     0   7   79 65                 144
934555 934555 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No 1 KG 05 2016   grade_1 45 0 6 2   1     0   1   25 30                       55 45 0 6 2   1     0   1   25 30                 55
934994 934994 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_1 86 4 5 2   4     0   3   55 49                       104 86 4 5 2   4     0   3   55 49                 104
935073 935073 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No 1 KG 04 2016   grade_1 65 4 6 2   7     0   4   47 41                       88 65 4 6 2   7     0   4   47 41                 88
935894 935894 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2016   grade_1 81 3 5 2   2     0   1   46 48                       94 81 3 5 2   2     0   1   46 48                 94
936248 936248 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Washington Elementary School   Regular School No 1 KG 05 2016   grade_1 7 6 54 2   11     0   4   37 47                       84 7 6 54 2   11     0   4   37 47                 84
936791 936791 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 06 2016   grade_1 112 6 40 2   1     0   8   91 78                       169 112 6 40 2   1     0   8   91 78                 169
937559 937559 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2016   grade_1 33 1 11 2   0     0   4   20 31                       51 33 1 11 2   0     0   4   20 31                 51
937765 937765 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No 1 PK 05 2016   grade_1 27 13 18 2   0     0   11   40 31                       71 27 13 18 2   0     0   11   40 31                 71
938859 938859 MA Middlesex   school 2511220 284   Stoneham 251122001856 2840030 South   Regular School No 1 KG 04 2016   grade_1 48 1 7 2   2     0   1   35 26                       61 48 1 7 2   2     0   1   35 26                 61
938912 938912 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2016   grade_1 97 0 2 2   1     0   5   61 46                       107 97 0 2 2   1     0   5   61 46                 107
939431 939431 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No 1 KG 03 2016   grade_1 52 2 4 2   21     0   3   49 35                       84 52 2 4 2   21     0   3   49 35                 84
940407 940407 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_1 8 36 15 2   1     0   0   29 33                       62 8 36 15 2   1     0   0   29 33                 62
940771 940771 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2016   grade_1 43 2 7 2   9     0   2   37 28                       65 43 2 7 2   9     0   2   37 28                 65
941019 941019 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2016   grade_1 82 5 2 2   1     0   12   52 52                       104 82 5 2 2   1     0   12   52 52                 104
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
1122260 1122260 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_1 77 1 14 2   1     0   3   53 45                       98 77 1 14 2   1     0   3   53 45                 98
1122408 1122408 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No Elementary KG 04 2017   grade_1 37 3 2 2   19     0   5   35 33                       68 37 3 2 2   19     0   5   35 33                 68
1122518 1122518 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2017   grade_1 64 7 7 2   11     0   5   53 43                       96 64 7 7 2   11     0   5   53 43                 96
1122587 1122587 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2017   grade_1 0 37 25 2   3     0   1   39 29                       68 0 37 25 2   3     0   1   39 29                 68
1123070 1123070 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2017   grade_1 10 1 39 2   0     0   1   23 30                       53 10 1 39 2   0     0   1   23 30                 53
1124869 1124869 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_1 40 7 66 2   3     0   4   65 57                       122 40 7 66 2   3     0   4   65 57                 122
1124943 1124943 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2017   grade_1 32 2 0 2   2     0   0   25 13                       38 32 2 0 2   2     0   0   25 13                 38
1126469 1126469 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Edward A Sisson   Regular School No Elementary KG 05 2017   grade_1 24 5 36 2   8     0   4   40 39                       79 24 5 36 2   8     0   4   40 39                 79
1126821 1126821 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2017   grade_1 50 7 9 2   9     0   5   40 42                       82 50 7 9 2   9     0   5   40 42                 82
1129971 1129971 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_1 156 10 15 2   2     0   30   115 100                       215 156 10 15 2   2     0   30   115 100                 215
1365296 1365296 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2020   grade_1 2 38 25 2   4     0   2   33 40 *                     73.0 2 38 25 2   4     0   2   33 40                 73
1365328 1365328 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 03 2020   grade_1 4 54 30 2   1     0   1   57 35 *                     92.0 4 54 30 2   1     0   1   57 35                 92
1365656 1365656 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_1 4 40 32 2   1     0   3   36 46 *                     82.0 4 40 32 2   1     0   3   36 46                 82
1368843 1368843 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No Elementary PK 05 2020   grade_1 30 9 15 2   9     0   1   29 37 *                     66.0 30 9 15 2   9     0   1   29 37                 66
1370114 1370114 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2020   grade_1 36 7 8 2   42     0   7   56 46 *                     102.0 36 7 8 2   42     0   7   56 46                 102
1370213 1370213 MA Norfolk   school 2509930 244   Randolph 250993001593 2440040 Martin E Young Elementary   Regular School No Elementary KG 05 2020   grade_1 4 10 13 2   2     0   4   21 14 *                     35.0 4 10 13 2   2     0   4   21 14                 35
1370454 1370454 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Lynnhurst   Regular School No Elementary KG 05 2020   grade_1 30 2 3 2   5     0   0   23 19 *                     42.0 30 2 3 2   5     0   0   23 19                 42
1370580 1370580 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2020   grade_1 6 6 1 2   45     0   6   33 33 *                     66.0 6 6 1 2   45     0   6   33 33                 66
1370586 1370586 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_1 56 3 8 2   48     0   4   61 60 *                     121.0 56 3 8 2   48     0   4   61 60                 121
1370840 1370840 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2020   grade_1 4 38 72 2   0     0   3   58 61 *                     119.0 4 38 72 2   0     0   3   58 61                 119
1371527 1371527 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   grade_1 109 11 14 2   2     0   23   84 77 *                     161.0 109 11 14 2   2     0   23   84 77                 161
1372089 1372089 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Clyde Reeves   Regular School No Elementary PK 05 2020   grade_1 49 7 2 2   6     0   4   33 37 *                     70.0 49 7 2 2   6     0   4   33 37                 70
1373243 1373243 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   grade_1 44 6 10 2   3     0   2   33 34 *                     67.0 44 6 10 2   3     0   2   33 34                 67
1673779 1673779 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_1 56 3 8 2   22     0   2   46 47 *                     93.0 56 3 8 2   22     0   2   46 47                 93
1674155 1674155 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 East Bridgewater - Central   Regular School No Elementary PK 02 2021   grade_1 124 6 4 2   2     0   5   69 74 *                     143.0 124 6 4 2   2     0   5   69 74                 143
1676043 1676043 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_1 62 6 8 2   1     0   13   52 40 *                     92.0 62 6 8 2   1     0   13   52 40                 92
1676236 1676236 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_1 100 2 3 2   0     0   5   62 50 *                     112.0 100 2 3 2   0     0   5   62 50                 112
1676491 1676491 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 New Bedford - Alfred J Gomes   Regular School No Elementary KG 05 2021   grade_1 11 10 58 2   0     0   2   35 48 *                     83.0 11 10 58 2   0     0   2   35 48                 83
1677362 1677362 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_1 37 8 18 2   44     0   6   61 54 *                     115.0 37 8 18 2   44     0   6   61 54                 115

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