enrollments

Data source: Big Local News · About: Big Local

878 rows where grade = "grade_5", state = "MA" and year = 2019 sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 878 ✖

grade ✖

  • grade_5 · 878 ✖
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
2047735 2047735 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 2019   grade_5 14 78 22 0   4     0   0   52 66                       118.0 14 78 22 0   4     0   0   52 66                 118
2039816 2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2047541 2047541 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_5 8 49 14 0   0     0   1   46 26                       72.0 8 49 14 0   0     0   1   46 26                 72
2048058 2048058 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_5 30 1 2 0   18     0   1   17 35                       52.0 30 1 2 0   18     0   1   17 35                 52
2048065 2048065 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_5 55 3 3 0   33     1   1   51 45                       96.0 55 3 3 0   33     1   1   51 45                 96
2048072 2048072 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_5 58 3 11 0   9     0   8   43 46                       89.0 58 3 11 0   9     0   8   43 46                 89
2048079 2048079 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_5 43 0 4 1   19     0   2   35 34                       69.0 43 0 4 1   19     0   2   35 34                 69
2048086 2048086 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_5 17 1 4 0   26     0   1   24 25                       49.0 17 1 4 0   26     0   1   24 25                 49
2048093 2048093 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_5 21 4 3 0   43     0   3   36 38                       74.0 21 4 3 0   43     0   3   36 38                 74
2039831 2039831 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_5 97 1 3 0   1     0   0   60 42                       102.0 97 1 3 0   1     0   0   60 42                 102
2048108 2048108 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_5 97 3 5 0   0     0   3   55 53                       108.0 97 3 5 0   0     0   3   55 53                 108
2039856 2039856 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 07 2019   grade_5 252 3 35 0   13     0   13   145 171                       316.0 252 3 35 0   13     0   13   145 171                 316
2047521 2047521 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_5 16 7 27 0   0     0   0   17 33                       50.0 16 7 27 0   0     0   0   17 33                 50
2039877 2039877 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_5 133 4 15 0   2     0   8   94 68                       162.0 133 4 15 0   2     0   8   94 68                 162
2039896 2039896 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_5 26 3 21 0   6     0   6   36 26                       62.0 26 3 21 0   6     0   6   36 26                 62
2039903 2039903 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_5 25 6 10 0   4     0   2   18 29                       47.0 25 6 10 0   4     0   2   18 29                 47
2039910 2039910 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_5 35 4 11 0   9     0   7   33 33                       66.0 35 4 11 0   9     0   7   33 33                 66
2039917 2039917 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_5 80 4 11 0   8     0   7   54 56                       110.0 80 4 11 0   8     0   7   54 56                 110
2039923 2039923 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_5 61 3 7 0   34     1   5   51 60                       111.0 61 3 7 0   34     1   5   51 60                 111
2039930 2039930 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2019   grade_5 48 2 2 0   13     0   2   47 20                       67.0 48 2 2 0   13     0   2   47 20                 67
2039936 2039936 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_5 69 0 1 0   17     0   0   37 50                       87.0 69 0 1 0   17     0   0   37 50                 87
2039942 2039942 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_5 66 7 11 0   19     0   1   43 61                       104.0 66 7 11 0   19     0   1   43 61                 104
2039962 2039962 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_5 54 3 3 0   7     0   4   35 36                       71.0 54 3 3 0   7     0   4   35 36                 71
2039968 2039968 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_5 63 2 4 0   5     0   7   42 39                       81.0 63 2 4 0   5     0   7   42 39                 81
2039974 2039974 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_5 67 4 7 0   6     0   4   43 45                       88.0 67 4 7 0   6     0   4   43 45                 88
2039980 2039980 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2019   grade_5 42 7 4 0   6     0   4   32 31                       63.0 42 7 4 0   6     0   4   32 31                 63
2039987 2039987 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2019   grade_5 42 1 5 0   1     0   0   31 18                       49.0 42 1 5 0   1     0   0   31 18                 49
2039993 2039993 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   grade_5 42 4 13 0   12     0   4   38 37                       75.0 42 4 13 0   12     0   4   38 37                 75
2039999 2039999 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_5 46 2 2 0   6     0   6   32 30                       62.0 46 2 2 0   6     0   6   32 30                 62
2048127 2048127 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2019   grade_5 86 4 12 0   0     0   5   58 49                       107.0 86 4 12 0   0     0   5   58 49                 107
2048136 2048136 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2019   grade_5 79 0 7 0   0     0   4   43 47                       90.0 79 0 7 0   0     0   4   43 47                 90
2040013 2040013 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_5 149 2 28 5   25     0   9   110 108                       218.0 149 2 28 5   25     0   9   110 108                 218
2048156 2048156 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2019   grade_5 15 1 2 0   0     0   0   11 7                       18.0 15 1 2 0   0     0   0   11 7                 18
2048158 2048158 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_5 89 0 10 0   0     0   2   61 40                       101.0 89 0 10 0   0     0   2   61 40                 101
2047989 2047989 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_5 93 2 13 0   2     0   0   49 61                       110.0 93 2 13 0   2     0   0   49 61                 110
2040047 2040047 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_5 111 16 14 2   11     0   14   87 81                       168.0 111 16 14 2   11     0   14   87 81                 168
2040051 2040051 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_5 92 5 18 0   8     0   14   64 73                       137.0 92 5 18 0   8     0   14   64 73                 137
2040055 2040055 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_5 107 6 28 0   7     0   6   84 70                       154.0 107 6 28 0   7     0   6   84 70                 154
2040076 2040076 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2019   grade_5 171 6 15 0   5     0   8   85 120                       205.0 171 6 15 0   5     0   8   85 120                 205
2040092 2040092 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   grade_5 31 16 3 1   4     0   5   33 27                       60.0 31 16 3 1   4     0   5   33 27                 60
2048173 2048173 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202731 6160001 Lura A. White Elementary School   Regular School No Elementary PK 05 2019   grade_5 42 2 8 0   0     0   2   28 26                       54.0 42 2 8 0   0     0   2   28 26                 54
2048180 2048180 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Page Hilltop Elementary School   Regular School No Elementary PK 05 2019   grade_5 67 4 13 0   4     0   2   47 43                       90.0 67 4 13 0   4     0   2   47 43                 90
2040119 2040119 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2019   grade_5 279 24 65 4   8     1   15   209 187                       396.0 279 24 65 4   8     1   15   209 187                 396
2040133 2040133 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2019   grade_5 145 11 4 0   37     0   8   104 101                       205.0 145 11 4 0   37     0   8   104 101                 205
2040145 2040145 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2019   grade_5 162 2 8 1   2     0   3   83 95                       178.0 162 2 8 1   2     0   3   83 95                 178
2040167 2040167 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2019   grade_5 161 5 14 0   3     0   7   81 109                       190.0 161 5 14 0   3     0   7   81 109                 190
2040201 2040201 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_5 210 12 24 1   90     1   28   189 177                       366.0 210 12 24 1   90     1   28   189 177                 366
2047590 2047590 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_5 0 38 3 0   0     0   0   22 19                       41.0 0 38 3 0   0     0   0   22 19                 41
2047761 2047761 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2019   grade_5 35 0 3 0   10     0   4   30 22                       52.0 35 0 3 0   10     0   4   30 22                 52
2049324 2049324 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_5 11 6 20 0   0     0   2   20 19                       39.0 11 6 20 0   0     0   2   20 19                 39
2040215 2040215 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_5 106 0 1 0   0     0   7   57 57                       114.0 106 0 1 0   0     0   7   57 57                 114
2048194 2048194 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2019   grade_5 59 0 9 0   2     0   4   39 35                       74.0 59 0 9 0   2     0   4   39 35                 74
2040225 2040225 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_5 26 0 2 0   1     0   0   18 11                       29.0 26 0 2 0   1     0   0   18 11                 29
2040252 2040252 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_5 301 10 57 0   7     0   17   207 185                       392.0 301 10 57 0   7     0   17   207 185                 392
2040266 2040266 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 05 2019   grade_5 68 3 6 0   8     0   4   46 43                       89.0 68 3 6 0   8     0   4   46 43                 89
2040272 2040272 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Frederick J Dutile   Regular School No Elementary KG 05 2019   grade_5 31 1 3 0   2     0   1   16 22                       38.0 31 1 3 0   2     0   1   16 22                 38
2040278 2040278 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 05 2019   grade_5 49 0 1 0   2     0   0   29 23                       52.0 49 0 1 0   2     0   0   29 23                 52
2040284 2040284 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2019   grade_5 67 4 1 0   7     0   2   40 41                       81.0 67 4 1 0   7     0   2   40 41                 81
2040290 2040290 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No Elementary KG 05 2019   grade_5 74 9 11 0   5     0   0   57 42                       99.0 74 9 11 0   5     0   0   57 42                 99
2040296 2040296 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2019   grade_5 14 0 1 0   3     0   4   14 8                       22.0 14 0 1 0   3     0   4   14 8                 22
2048219 2048219 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No Elementary PK 05 2019   grade_5 27 0 1 0   0     0   2   14 16                       30.0 27 0 1 0   0     0   2   14 16                 30
2048222 2048222 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_5 86 3 9 0   2     0   5   50 55                       105.0 86 3 9 0   2     0   5   50 55                 105
2040322 2040322 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_5 5 4 3 0   2     0   1   6 9                       15.0 5 4 3 0   2     0   1   6 9                 15
2040346 2040346 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_5 12 13 10 0   0     0   1   20 16                       36.0 12 13 10 0   0     0   1   20 16                 36
2040356 2040356 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2019   grade_5 14 18 31 0   9     0   0   39 33                       72.0 14 18 31 0   9     0   0   39 33                 72
2040379 2040379 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_5 18 24 54 0   4     0   4   65 39                       104.0 18 24 54 0   4     0   4   65 39                 104
2040399 2040399 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2019   grade_5 5 17 46 0   0     1   0   36 33                       69.0 5 17 46 0   0     1   0   36 33                 69
2040406 2040406 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_5 0 73 13 0   2     0   2   53 37                       90.0 0 73 13 0   2     0   2   53 37                 90
2040413 2040413 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2019   grade_5 11 0 30 0   0     0   0   17 24                       41.0 11 0 30 0   0     0   0   17 24                 41
2040427 2040427 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2019   grade_5 0 18 21 0   0     0   0   20 19                       39.0 0 18 21 0   0     0   0   20 19                 39
2040441 2040441 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_5 13 13 17 0   1     0   3   28 19                       47.0 13 13 17 0   1     0   3   28 19                 47
2040451 2040451 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_5 8 2 86 0   0     0   0   50 46                       96.0 8 2 86 0   0     0   0   50 46                 96
2040461 2040461 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2019   grade_5 1 20 15 0   6     0   4   17 29                       46.0 1 20 15 0   6     0   4   17 29                 46
2040468 2040468 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_5 37 6 14 0   3     0   3   36 27                       63.0 37 6 14 0   3     0   3   36 27                 63
2040478 2040478 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2019   grade_5 7 11 18 0   0     0   3   20 19                       39.0 7 11 18 0   0     0   3   20 19                 39
2040485 2040485 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_5 3 23 16 0   0     0   1   19 24                       43.0 3 23 16 0   0     0   1   19 24                 43
2040495 2040495 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2019   grade_5 7 21 12 0   2     0   2   23 21                       44.0 7 21 12 0   2     0   2   23 21                 44
2040502 2040502 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2019   grade_5 0 10 7 0   1     0   1   6 13                       19.0 0 10 7 0   1     0   1   6 13                 19
2040509 2040509 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   grade_5 2 27 16 0   0     0   2   21 26                       47.0 2 27 16 0   0     0   2   21 26                 47
2040516 2040516 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2019   grade_5 2 1 31 0   2     0   1   20 17                       37.0 2 1 31 0   2     0   1   20 17                 37
2040523 2040523 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_5 13 45 43 0   12     1   5   55 64                       119.0 13 45 43 0   12     1   5   55 64                 119
2040532 2040532 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_5 5 31 67 0   4     0   3   55 55                       110.0 5 31 67 0   4     0   3   55 55                 110
2040542 2040542 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2019   grade_5 0 20 8 0   0     0   3   17 14                       31.0 0 20 8 0   0     0   3   17 14                 31
2040549 2040549 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2019   grade_5 8 0 32 0   2     0   1   23 20                       43.0 8 0 32 0   2     0   1   23 20                 43
2040556 2040556 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2019   grade_5 0 5 36 0   0     0   2   24 19                       43.0 0 5 36 0   0     0   2   24 19                 43
2040563 2040563 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2019   grade_5 3 44 63 0   10     0   6   65 61                       126.0 3 44 63 0   10     0   6   65 61                 126
2040570 2040570 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2019   grade_5 3 11 6 0   0     0   0   13 7                       20.0 3 11 6 0   0     0   0   13 7                 20
2040580 2040580 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2019   grade_5 1 25 11 0   0     0   1   21 17                       38.0 1 25 11 0   0     0   1   21 17                 38
2040587 2040587 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2019   grade_5 6 12 8 0   3     0   0   15 14                       29.0 6 12 8 0   3     0   0   15 14                 29
2040594 2040594 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_5 9 2 22 0   0     0   1   18 16                       34.0 9 2 22 0   0     0   1   18 16                 34
2040604 2040604 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_5 5 30 26 0   5     0   11   30 47                       77.0 5 30 26 0   5     0   11   30 47                 77
2040614 2040614 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2019   grade_5 8 4 5 0   3     0   0   10 10                       20.0 8 4 5 0   3     0   0   10 10                 20
2040621 2040621 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_5 34 12 7 0   7     1   2   33 30                       63.0 34 12 7 0   7     1   2   33 30                 63
2040631 2040631 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2019   grade_5 5 21 33 0   29     1   2   46 45                       91.0 5 21 33 0   29     1   2   46 45                 91
2040638 2040638 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2019   grade_5 11 1 15 0   4     0   2   17 16                       33.0 11 1 15 0   4     0   2   17 16                 33
2040645 2040645 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2019   grade_5 1 42 15 1   22     0   3   46 38                       84.0 1 42 15 1   22     0   3   46 38                 84
2040652 2040652 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_5 1 15 23 0   0     0   1   23 17                       40.0 1 15 23 0   0     0   1   23 17                 40
2040662 2040662 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2019   grade_5 5 20 13 1   2     0   1   25 17                       42.0 5 20 13 1   2     0   1   25 17                 42
2040669 2040669 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2019   grade_5 4 9 10 0   0     0   0   11 12                       23.0 4 9 10 0   0     0   0   11 12                 23
2040676 2040676 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2019   grade_5 18 18 28 0   62     0   6   81 51                       132.0 18 18 28 0   62     0   6   81 51                 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]);