enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,679 ✖
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
1372538 1372538 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_4 10 99 66 0   2     0   4   85 96 *                     181.0 10 99 66 0   2     0   4   85 96                 181
1673433 1673433 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_4 53 98 27 1   7     0   4   96 94 *                     190.0 53 98 27 1   7     0   4   96 94                 190
2230460 2230460 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton: Louis F Angelo Elementary   Regular School No Elementary KG 05 2018   grade_4 58 98 29 2   15     0   10   101 111                       212.0 58 98 29 2   15     0   10   101 111                 212
1123581 1123581 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_4 16 96 27 1   0     0   5   74 71                       145 16 96 27 1   0     0   5   74 71                 145
1366199 1366199 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_4 49 96 32 1   10     0   11   105 94 *                     199.0 49 96 32 1   10     0   11   105 94                 199
1131204 1131204 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_4 13 95 73 2   4     0   4   102 89                       191 13 95 73 2   4     0   4   102 89                 191
2047613 2047613 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_4 14 93 67 1   4     0   4   85 98                       183.0 14 93 67 1   4     0   4   85 98                 183
2230467 2230467 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton: Oscar F Raymond   Regular School No Elementary KG 05 2018   grade_4 17 93 11 0   2     0   10   66 67                       133.0 17 93 11 0   2     0   10   66 67                 133
737123 737123 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_4 9 91 17 1   4     0   6   69 59                       128 9 91 17 1   4     0   6   69 59                 128
933930 933930 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_4 12 91 30 1   1     0   7   69 73                       142 12 91 30 1   1     0   7   69 73                 142
2040405 2040405 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_4 1 91 11 1   2     0   3   60 49                       109.0 1 91 11 1   2     0   3   60 49                 109
736345 736345 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2015   grade_4 2 9 7 0   2     0   2   12 10                       22 2 9 7 0   2     0   2   12 10                 22
736414 736414 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_4 5 9 7 1   0     0   1   15 8                       23 5 9 7 1   0     0   1   15 8                 23
736586 736586 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_4 7 9 5 0   2     0   0   14 9                       23 7 9 5 0   2     0   0   14 9                 23
736644 736644 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   grade_4 8 9 24 0   3     1   1   25 21                       46 8 9 24 0   3     1   1   25 21                 46
736690 736690 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_4 2 9 25 0   3     0   1   19 21                       40 2 9 25 0   3     0   1   19 21                 40
737030 737030 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 01 05 2015   grade_4 39 9 6 1   4     0   0   28 31                       59 39 9 6 1   4     0   0   28 31                 59
737191 737191 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_4 37 9 2 0   19     0   8   40 35                       75 37 9 2 0   19     0   8   40 35                 75
737324 737324 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2015   grade_4 20 9 4 0   4     0   1   17 21                       38 20 9 4 0   4     0   1   17 21                 38
737387 737387 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2015   grade_4 7 9 9 0   3     1   1   15 15                       30 7 9 9 0   3     1   1   15 15                 30
737411 737411 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No 1 KG 05 2015   grade_4 59 9 1 0   7     0   2   34 44                       78 59 9 1 0   7     0   2   34 44                 78
737499 737499 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_4 8 9 88 2   3     0   3   57 56                       113 8 9 88 2   3     0   3   57 56                 113
737742 737742 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2015   grade_4 39 9 12 0   1     0   5   30 36                       66 39 9 12 0   1     0   5   30 36                 66
737811 737811 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2015   grade_4 53 9 9 0   6     0   0   45 32                       77 53 9 9 0   6     0   0   45 32                 77
740900 740900 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No 1 KG 05 2015   grade_4 62 9 12 0   1     0   8   47 45                       92 62 9 12 0   1     0   8   47 45                 92
741882 741882 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No 1 PK 05 2015   grade_4 11 9 24 0   6     0   1   24 27                       51 11 9 24 0   6     0   1   24 27                 51
742077 742077 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2015   grade_4 25 9 2 0   4     0   3   24 19                       43 25 9 2 0   4     0   3   24 19                 43
742213 742213 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No 1 KG 04 2015   grade_4 77 9 6 1   0     0   5   53 45                       98 77 9 6 1   0     0   5   53 45                 98
743258 743258 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_4 7 9 15 0   1     0   3   21 14                       35 7 9 15 0   1     0   3   21 14                 35
932627 932627 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_4 25 9 16 0   4     0   4   28 30                       58 25 9 16 0   4     0   4   28 30                 58
933283 933283 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2016   grade_4 1 9 13 0   0     0   0   7 16                       23 1 9 13 0   0     0   0   7 16                 23
934098 934098 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_4 29 9 12 1   13     0   3   32 35                       67 29 9 12 1   13     0   3   32 35                 67
934240 934240 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2016   grade_4 20 9 7 0   8     0   4   24 24                       48 20 9 7 0   8     0   4   24 24                 48
934355 934355 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_4 21 9 116 0   1     0   2   76 73                       149 21 9 116 0   1     0   2   76 73                 149
934806 934806 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_4 17 9 44 2   3     0   1   34 42                       76 17 9 44 2   3     0   1   34 42                 76
934915 934915 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_4 19 9 12 0   3     0   4   30 17                       47 19 9 12 0   3     0   4   30 17                 47
935097 935097 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   grade_4 29 9 52 0   2     0   4   53 43                       96 29 9 52 0   2     0   4   53 43                 96
935139 935139 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_4 57 9 10 0   2     0   3   44 37                       81 57 9 10 0   2     0   3   44 37                 81
936288 936288 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No 1 PK 05 2016   grade_4 6 9 87 0   6     0   3   55 56                       111 6 9 87 0   6     0   3   55 56                 111
936306 936306 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Hood   Regular School No 1 KG 05 2016   grade_4 18 9 52 0   7     0   2   43 45                       88 18 9 52 0   7     0   2   43 45                 88
936740 936740 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2016   grade_4 62 9 66 0   4     0   3   77 67                       144 62 9 66 0   4     0   3   77 67                 144
937728 937728 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No 1 KG 05 2016   grade_4 75 9 4 0   3     0   3   48 46                       94 75 9 4 0   3     0   3   48 46                 94
938463 938463 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2016   grade_4 16 9 5 0   1     0   1   15 17                       32 16 9 5 0   1     0   1   15 17                 32
938580 938580 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_4 0 9 51 0   0     0   1   31 30                       61 0 9 51 0   0     0   1   31 30                 61
938646 938646 MA Hampden   school 2511130 281   Springfield 251113001808 2810085 Homer Street   Regular School No 1 KG 05 2016   grade_4 2 9 44 0   0     0   0   23 32                       55 2 9 44 0   0     0   0   23 32                 55
938745 938745 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 White Street   Regular School No 1 KG 05 2016   grade_4 3 9 35 0   8     0   0   29 26                       55 3 9 35 0   8     0   0   29 26                 55
939022 939022 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No 1 KG 04 2016   grade_4 87 9 11 0   1     1   3   47 65                       112 87 9 11 0   1     1   3   47 65                 112
939333 939333 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No 1 KG 05 2016   grade_4 68 9 1 0   13     0   5   47 49                       96 68 9 1 0   13     0   5   47 49                 96
940141 940141 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   grade_4 7 9 59 0   7     0   3   47 38                       85 7 9 59 0   7     0   3   47 38                 85
941329 941329 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2016   grade_4 87 9 7 1   1     1   5   55 56                       111 87 9 7 1   1     1   5   55 56                 111
941974 941974 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Lowell Collegiate Charter School   Regular School Yes 1 KG 05 2016   grade_4 17 9 25 0   10     0   4   39 26                       65 17 9 25 0   10     0   4   39 26                 65
1122336 1122336 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2017   grade_4 137 9 9 0   27     0   0   100 82                       182 137 9 9 0   27     0   0   100 82                 182
1122352 1122352 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_4 161 9 4 0   6     1   1   102 80                       182 161 9 4 0   6     1   1   102 80                 182
1123065 1123065 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_4 4 9 8 0   2     0   0   8 15                       23 4 9 8 0   2     0   0   8 15                 23
1123169 1123169 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_4 10 9 15 0   2     1   1   20 18                       38 10 9 15 0   2     1   1   20 18                 38
1124082 1124082 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_4 11 9 113 0   1     0   2   69 67                       136 11 9 113 0   1     0   2   69 67                 136
1124455 1124455 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2017   grade_4 63 9 8 0   4     0   1   46 39                       85 63 9 8 0   4     0   1   46 39                 85
1124740 1124740 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2017   grade_4 43 9 38 0   2     0   4   43 53                       96 43 9 38 0   2     0   4   43 53                 96
1125975 1125975 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2017   grade_4 57 9 44 0   2     0   3   54 61                       115 57 9 44 0   2     0   3   54 61                 115
1126080 1126080 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_4 38 9 6 0   0     0   6   29 30                       59 38 9 6 0   0     0   6   29 30                 59
1126245 1126245 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2017   grade_4 6 9 26 0   44     0   8   50 43                       93 6 9 26 0   44     0   8   50 43                 93
1126472 1126472 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Edward A Sisson   Regular School No Elementary KG 05 2017   grade_4 28 9 29 1   7     0   3   36 41                       77 28 9 29 1   7     0   3   36 41                 77
1127073 1127073 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2017   grade_4 78 9 0 0   5     0   2   45 49                       94 78 9 0 0   5     0   2   45 49                 94
1127256 1127256 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2017   grade_4 25 9 35 0   0     0   2   30 41                       71 25 9 35 0   0     0   2   30 41                 71
1127317 1127317 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary PK 05 2017   grade_4 23 9 41 0   0     0   1   35 39                       74 23 9 41 0   0     0   1   35 39                 74
1129267 1129267 MA Hampden   school 2511130 281   Springfield 251113001819 2810145 Mary O Pottenger   Regular School No Elementary KG 05 2017   grade_4 12 9 46 0   2     0   0   38 31                       69 12 9 46 0   2     0   0   38 31                 69
1129289 1129289 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2017   grade_4 2 9 23 0   3     0   1   13 25                       38 2 9 23 0   3     0   1   13 25                 38
1129319 1129319 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 White Street   Regular School No Elementary KG 05 2017   grade_4 5 9 56 0   2     0   0   38 34                       72 5 9 56 0   2     0   0   38 34                 72
1129722 1129722 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 North Street   Regular School No Elementary 03 04 2017   grade_4 112 9 2 0   5     0   2   74 56                       130 112 9 2 0   5     0   2   74 56                 130
1129930 1129930 MA Middlesex   school 2512000 308   Waltham 251200001970 3080060 James Fitzgerald Elementary School   Regular School No Elementary KG 05 2017   grade_4 43 9 30 0   5     0   3   41 49                       90 43 9 30 0   5     0   3   41 49                 90
1130876 1130876 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2017   grade_4 8 9 28 0   6     0   4   29 26                       55 8 9 28 0   6     0   4   29 26                 55
1130893 1130893 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_4 7 9 25 0   1     0   3   20 25                       45 7 9 25 0   1     0   3   20 25                 45
1130935 1130935 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2017   grade_4 30 9 18 0   4     0   6   34 33                       67 30 9 18 0   4     0   6   34 33                 67
1130979 1130979 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2017   grade_4 23 9 9 0   5     0   3   16 33                       49 23 9 9 0   5     0   3   16 33                 49
1131105 1131105 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_4 10 9 19 0   0     0   4   18 24                       42 10 9 19 0   0     0   4   18 24                 42
1365019 1365019 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_4 41 9 11 0   8     0   14   40 43 *                     83.0 41 9 11 0   8     0   14   40 43                 83
1365163 1365163 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2020   grade_4 42 9 4 0   20     0   12   43 44 *                     87.0 42 9 4 0   20     0   12   43 44                 87
1365434 1365434 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2020   grade_4 19 9 12 0   0     0   4   27 16 *                     44.0 19 9 12 0   0     0   4   27 16                 44
1365458 1365458 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2020   grade_4 3 9 18 0   0     0   0   13 17 *                     30.0 3 9 18 0   0     0   0   13 17                 30
1365625 1365625 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2020   grade_4 10 9 4 1   2     0   1   17 10 *                     27.0 10 9 4 1   2     0   1   17 10                 27
1365764 1365764 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_4 31 9 13 0   4     0   3   21 39 *                     60.0 31 9 13 0   4     0   3   21 39                 60
1366402 1366402 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   grade_4 29 9 1 0   1     0   2   21 21 *                     42.0 29 9 1 0   1     0   2   21 21                 42
1367377 1367377 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_4 49 9 37 0   0     0   4   42 57 *                     99.0 49 9 37 0   0     0   4   42 57                 99
1368302 1368302 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No Elementary PK 04 2020   grade_4 25 9 42 0   9     0   3   42 46 *                     88.0 25 9 42 0   9     0   3   42 46                 88
1368657 1368657 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2020   grade_4 22 9 13 0   8     0   6   30 28 *                     58.0 22 9 13 0   8     0   6   30 28                 58
1369261 1369261 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary PK 05 2020   grade_4 9 9 24 0   1     1   3   26 21 *                     47.0 9 9 24 0   1     1   3   26 21                 47
1369280 1369280 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary KG 05 2020   grade_4 19 9 34 1   1     0   2   36 30 *                     66.0 19 9 34 1   1     0   2   36 30                 66
1369752 1369752 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_4 24 9 19 0   1     1   1   23 32 *                     55.0 24 9 19 0   1     1   1   23 32                 55
1369969 1369969 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2020   grade_4 27 9 16 0   0     0   8   26 34 *                     60.0 27 9 16 0   0     0   8   26 34                 60
1369995 1369995 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2020   grade_4 13 9 8 0   0     0   7   21 16 *                     37.0 13 9 8 0   0     0   7   21 16                 37
1370589 1370589 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_4 76 9 16 0   111     0   6   112 106 *                     218.0 76 9 16 0   111     0   6   112 106                 218
1370690 1370690 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2020   grade_4 25 9 9 0   0     0   3   29 17 *                     46.0 25 9 9 0   0     0   3   29 17                 46
1370796 1370796 MA Hampden   school 2511130 281   Springfield 251113001826 2810020 Samuel Bowles   Regular School No Elementary KG 05 2020   grade_4 7 9 32 0   0     0   0   23 25 *                     48.0 7 9 32 0   0     0   0   23 25                 48
1370810 1370810 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2020   grade_4 3 9 42 0   0     0   1   27 28 *                     55.0 3 9 42 0   0     0   1   27 28                 55
1370937 1370937 MA Hampden   school 2511130 281   Springfield 251113001829 2810155 Mary M Walsh   Regular School No Elementary KG 05 2020   grade_4 7 9 37 1   0     0   1   26 29 *                     55.0 7 9 37 1   0     0   1   26 29                 55
1371139 1371139 MA Norfolk   school 2511250 285   Stoughton 251125001861 2850025 Joseph H Gibbons   Regular School No Elementary KG 05 2020   grade_4 37 9 7 0   3     0   5   36 25 *                     61.0 37 9 7 0   3     0   5   36 25                 61
1371358 1371358 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2020   grade_4 93 9 7 0   7     0   6   55 67 *                     122.0 93 9 7 0   7     0   6   55 67                 122
1371603 1371603 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2020   grade_4 80 9 55 0   2     0   9   90 65 *                     155.0 80 9 55 0   2     0   9   90 65                 155
1372150 1372150 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_4 11 9 27 0   0     0   3   26 24 *                     50.0 11 9 27 0   0     0   3   26 24                 50
1372270 1372270 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2020   grade_4 14 9 6 0   5     0   4   21 17 *                     38.0 14 9 6 0   5     0   4   21 17                 38

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