enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by black 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
2238030 2238030 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_2 8 99 68 0   2     0   3   81 99                       180.0 8 99 68 0   2     0   3   81 99                 180
1123579 1123579 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_2 16 96 24 2   0     0   14   88 64                       152 16 96 24 2   0     0   14   88 64                 152
1131202 1131202 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_2 14 95 63 2   5     0   4   86 97                       183 14 95 63 2   5     0   4   86 97                 183
1372536 1372536 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_2 4 95 81 0   5     0   2   91 96 *                     187.0 4 95 81 0   5     0   2   91 96                 187
1123643 1123643 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2017   grade_2 16 93 14 1   8     1   5   71 67                       138 16 93 14 1   8     1   5   71 67                 138
2041243 2041243 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_2 16 91 20 0   1     0   7   68 67                       135.0 16 91 20 0   1     0   7   68 67                 135
736326 736326 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   grade_2 17 9 14 0   0     0   3   23 20                       43 17 9 14 0   0     0   3   23 20                 43
736534 736534 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_2 0 9 11 0   0     0   2   10 12                       22 0 9 11 0   0     0   2   10 12                 22
736584 736584 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_2 24 9 14 0   2     0   0   29 20                       49 24 9 14 0   2     0   0   29 20                 49
737236 737236 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_2 42 9 10 1   16     0   2   37 43                       80 42 9 10 1   16     0   2   37 43                 80
737497 737497 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_2 10 9 122 2   4     0   2   80 69                       149 10 9 122 2   4     0   2   80 69                 149
737952 737952 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_2 16 9 46 1   5     0   1   39 39                       78 16 9 46 1   5     0   1   39 39                 78
738041 738041 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_2 63 9 32 0   6     0   17   63 64                       127 63 9 32 0   6     0   17   63 64                 127
738277 738277 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_2 57 9 29 0   2     0   8   52 53                       105 57 9 29 0   2     0   8   52 53                 105
739175 739175 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_2 47 9 6 0   2     0   7   40 31                       71 47 9 6 0   2     0   7   40 31                 71
739249 739249 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No 1 PK 04 2015   grade_2 26 9 33 0   16     0   6   46 44                       90 26 9 33 0   16     0   6   46 44                 90
739407 739407 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_2 11 9 18 0   3     0   3   21 23                       44 11 9 18 0   3     0   3   21 23                 44
739462 739462 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No 1 KG 05 2015   grade_2 9 9 79 0   10     0   4   51 60                       111 9 9 79 0   10     0   4   51 60                 111
739493 739493 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No 1 PK 05 2015   grade_2 27 9 11 0   6     0   6   40 19                       59 27 9 11 0   6     0   6   40 19                 59
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
741924 741924 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No 1 PK 05 2015   grade_2 8 9 32 1   2     0   0   25 27                       52 8 9 32 1   2     0   0   25 27                 52
741944 741944 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2015   grade_2 2 9 89 0   0     0   0   44 56                       100 2 9 89 0   0     0   0   44 56                 100
742216 742216 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No 1 KG 04 2015   grade_2 100 9 10 1   2     0   1   64 59                       123 100 9 10 1   2     0   1   64 59                 123
742231 742231 MA Bristol   school 2511520 293   Taunton 251152001909 2930035 Hopewell   Regular School No 1 KG 04 2015   grade_2 50 9 6 0   1     0   3   34 35                       69 50 9 6 0   1     0   3   34 35                 69
742434 742434 MA Middlesex   school 2512000 308   Waltham 251200001970 3080060 James Fitzgerald Elementary School   Regular School No 1 KG 05 2015   grade_2 45 9 26 0   6     0   2   36 52                       88 45 9 26 0   6     0   2   36 52                 88
743203 743203 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_2 22 9 24 0   8     0   5   49 19                       68 22 9 24 0   8     0   5   49 19                 68
743241 743241 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2015   grade_2 8 9 20 1   1     0   4   20 23                       43 8 9 20 1   1     0   4   20 23                 43
743278 743278 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2015   grade_2 31 9 16 0   2     0   6   26 38                       64 31 9 16 0   2     0   6   26 38                 64
743412 743412 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   grade_2 6 9 21 1   0     0   1   14 24                       38 6 9 21 1   0     0   1   14 24                 38
743772 743772 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes 1 KG 05 2015   grade_2 66 9 20 0   5     0   0   52 48                       100 66 9 20 0   5     0   0   52 48                 100
934203 934203 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   grade_2 21 9 7 1   5     0   3   24 22                       46 21 9 7 1   5     0   3   24 22                 46
934217 934217 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2016   grade_2 15 9 5 0   7     0   6   20 22                       42 15 9 5 0   7     0   6   20 22                 42
934224 934224 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No 1 PK 05 2016   grade_2 24 9 8 0   3     0   3   21 26                       47 24 9 8 0   3     0   3   21 26                 47
934667 934667 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_2 56 9 5 0   4     0   0   39 35                       74 56 9 5 0   4     0   0   39 35                 74
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
935975 935975 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   grade_2 56 9 2 0   26     0   8   61 40                       101 56 9 2 0   26     0   8   61 40                 101
935981 935981 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2016   grade_2 38 9 2 0   38     0   7   47 47                       94 38 9 2 0   38     0   7   47 47                 94
936249 936249 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Washington Elementary School   Regular School No 1 KG 05 2016   grade_2 3 9 82 0   4     0   7   65 40                       105 3 9 82 0   4     0   7   65 40                 105
936255 936255 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2016   grade_2 21 9 18 1   2     0   4   27 28                       55 21 9 18 1   2     0   4   27 28                 55
936639 936639 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No 1 PK 05 2016   grade_2 72 9 9 1   12     0   7   63 47                       110 72 9 9 1   12     0   7   63 47                 110
936992 936992 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No 1 PK 05 2016   grade_2 25 9 11 0   0     1   2   31 17                       48 25 9 11 0   0     1   2   31 17                 48
937018 937018 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No 1 KG 05 2016   grade_2 25 9 32 0   0     0   0   32 34                       66 25 9 32 0   0     0   0   32 34                 66
937534 937534 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2016   grade_2 45 9 1 0   6     0   0   27 34                       61 45 9 1 0   6     0   0   27 34                 61
938631 938631 MA Hampden   school 2511130 281   Springfield 251113001803 2810075 Frank H Freedman   Regular School No 1 KG 05 2016   grade_2 9 9 28 0   0     0   1   24 23                       47 9 9 28 0   0     0   1   24 23                 47
938667 938667 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No 1 KG 05 2016   grade_2 2 9 45 0   5     0   3   36 28                       64 2 9 45 0   5     0   3   36 28                 64
938730 938730 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No 1 PK 05 2016   grade_2 7 9 42 0   2     0   1   30 31                       61 7 9 42 0   2     0   1   30 31                 61
939242 939242 MA Middlesex   school 2512000 308   Waltham 251200001970 3080060 James Fitzgerald Elementary School   Regular School No 1 KG 05 2016   grade_2 46 9 22 0   12     1   3   47 46                       93 46 9 22 0   12     1   3   47 46                 93
939934 939934 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   grade_2 12 9 13 0   0     0   1   16 19                       35 12 9 13 0   0     0   1   16 19                 35
940012 940012 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2016   grade_2 26 9 27 0   9     0   3   38 36                       74 26 9 27 0   9     0   3   38 36                 74
940042 940042 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2016   grade_2 27 9 4 0   6     0   2   24 24                       48 27 9 4 0   6     0   2   24 24                 48
940118 940118 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_2 36 9 11 0   1     0   4   32 29                       61 36 9 11 0   1     0   4   32 29                 61
1123117 1123117 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_2 38 9 14 0   3     0   4   35 33                       68 38 9 14 0   3     0   4   35 33                 68
1123780 1123780 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_2 31 9 7 0   19     0   5   31 40                       71 31 9 7 0   19     0   5   31 40                 71
1123858 1123858 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2017   grade_2 30 9 7 0   5     0   5   33 23                       56 30 9 7 0   5     0   5   33 23                 56
1123909 1123909 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2017   grade_2 20 9 11 0   7     0   4   23 28                       51 20 9 11 0   7     0   4   23 28                 51
1123917 1123917 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   grade_2 13 9 5 1   7     0   7   20 22                       42 13 9 5 1   7     0   7   20 22                 42
1123933 1123933 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   grade_2 7 9 7 0   11     0   6   18 22                       40 7 9 7 0   11     0   6   18 22                 40
1124581 1124581 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2017   grade_2 65 9 4 0   2     0   0   38 42                       80 65 9 4 0   2     0   0   38 42                 80
1124723 1124723 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   grade_2 61 9 32 0   7     0   15   71 53                       124 61 9 32 0   7     0   15   71 53                 124
1124888 1124888 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2017   grade_2 31 9 75 0   8     0   12   67 68                       135 31 9 75 0   8     0   12   67 68                 135
1125001 1125001 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2017   grade_2 30 9 11 0   2     0   3   27 28                       55 30 9 11 0   2     0   3   27 28                 55
1125015 1125015 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_2 72 9 21 0   0     0   1   52 51                       103 72 9 21 0   0     0   1   52 51                 103
1129134 1129134 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No Elementary PK 05 2017   grade_2 1 9 37 0   0     0   0   26 21                       47 1 9 37 0   0     0   0   26 21                 47
1129507 1129507 MA Norfolk   school 2511250 285   Stoughton 251125001861 2850025 Joseph H Gibbons   Regular School No Elementary KG 05 2017   grade_2 34 9 7 0   4     0   3   27 30                       57 34 9 7 0   4     0   3   27 30                 57
1130770 1130770 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_2 10 9 22 1   6     0   1   29 20                       49 10 9 22 1   6     0   1   29 20                 49
1130830 1130830 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary PK 06 2017   grade_2 16 9 36 0   2     0   4   33 34                       67 16 9 36 0   2     0   4   33 34                 67
1130857 1130857 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   grade_2 13 9 31 0   2     0   8   31 32                       63 13 9 31 0   2     0   8   31 32                 63
1130891 1130891 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_2 5 9 20 1   1     0   4   17 23                       40 5 9 20 1   1     0   4   17 23                 40
1364880 1364880 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_2 30 9 11 0   11     0   3   30 34 *                     64.0 30 9 11 0   11     0   3   30 34                 64
1365755 1365755 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2020   grade_2 13 9 7 0   5     0   6   22 18 *                     40.0 13 9 7 0   5     0   6   22 18                 40
1366456 1366456 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2020   grade_2 31 9 3 0   11     0   3   31 26 *                     57.0 31 9 3 0   11     0   3   31 26                 57
1367056 1367056 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_2 13 9 52 0   6     0   0   37 43 *                     80.0 13 9 52 0   6     0   0   37 43                 80
1367130 1367130 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   grade_2 28 9 49 1   2     1   16   58 48 *                     106.0 28 9 49 1   2     1   16   58 48                 106
1367263 1367263 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_2 32 9 58 0   5     0   3   55 52 *                     107.0 32 9 58 0   5     0   3   55 52                 107
1368473 1368473 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Washington Elementary School   Regular School No Elementary KG 05 2020   grade_2 4 9 56 0   6     0   0   44 31 *                     75.0 4 9 56 0   6     0   0   44 31                 75
1368524 1368524 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_2 3 9 80 0   9     0   4   51 54 *                     105.0 3 9 80 0   9     0   4   51 54                 105
1368574 1368574 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Edward A Sisson   Regular School No Elementary PK 05 2020   grade_2 27 9 33 2   10     0   3   41 43 *                     84.0 27 9 33 2   10     0   3   41 43                 84
1368844 1368844 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No Elementary PK 05 2020   grade_2 44 9 11 0   12     0   5   38 43 *                     81.0 44 9 11 0   12     0   5   38 43                 81
1368961 1368961 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2020   grade_2 43 9 81 0   6     0   1   76 64 *                     140.0 43 9 81 0   6     0   1   76 64                 140
1369118 1369118 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2020   grade_2 50 9 54 0   1     0   7   61 60 *                     121.0 50 9 54 0   1     0   7   61 60                 121
1369239 1369239 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No Elementary KG 05 2020   grade_2 22 9 34 0   0     0   2   32 35 *                     67.0 22 9 34 0   0     0   2   32 35                 67
1370880 1370880 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2020   grade_2 12 9 23 0   0     0   1   19 26 *                     45.0 12 9 23 0   0     0   1   19 26                 45
1370935 1370935 MA Hampden   school 2511130 281   Springfield 251113001829 2810155 Mary M Walsh   Regular School No Elementary KG 05 2020   grade_2 5 9 25 0   0     0   0   16 23 *                     39.0 5 9 25 0   0     0   0   16 23                 39
1371124 1371124 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No Elementary KG 05 2020   grade_2 17 9 2 0   3     0   4   19 16 *                     35.0 17 9 2 0   3     0   4   19 16                 35
1371260 1371260 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2020   grade_2 68 9 7 0   1     0   2   38 49 *                     87.0 68 9 7 0   1     0   2   38 49                 87
1371310 1371310 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2020   grade_2 98 9 4 0   7     0   1   59 60 *                     119.0 98 9 4 0   7     0   1   59 60                 119
1371601 1371601 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2020   grade_2 74 9 49 1   2     0   12   84 63 *                     147.0 74 9 49 1   2     0   12   84 63                 147
1372225 1372225 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2020   grade_2 25 9 23 0   11     0   3   39 32 *                     71.0 25 9 23 0   11     0   3   39 32                 71
1372290 1372290 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary PK 06 2020   grade_2 37 9 21 0   6     0   4   50 27 *                     77.0 37 9 21 0   6     0   4   50 27                 77
1373177 1373177 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2020   grade_2 148 9 1 0   3     0   6   88 79 *                     167.0 148 9 1 0   3     0   6   88 79                 167
1374242 1374242 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_2 3 9 41 0   2     0   0   22 33 *                     55.0 3 9 41 0   2     0   0   22 33                 55
1672657 1672657 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Boston - Ellis Mendell   Regular School No Elementary PK 05 2021   grade_2 13 9 11 0   5     0   4   21 21 *                     42.0 13 9 11 0   5     0   4   21 21                 42
1672873 1672873 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_2 2 9 7 0   4     0   0   8 14 *                     22.0 2 9 7 0   4     0   0   8 14                 22
1673615 1673615 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge - Maria L. Baldwin   Regular School No Elementary PK 05 2021   grade_2 34 9 5 0   5     0   3   32 24 *                     56.0 34 9 5 0   5     0   3   32 24                 56
1673808 1673808 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_2 15 9 105 0   0     0   2   57 74 *                     131.0 15 9 105 0   0     0   2   57 74                 131
1674361 1674361 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_2 29 9 45 0   3     0   7   42 51 *                     93.0 29 9 45 0   3     0   7   42 51                 93
1675380 1675380 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Leominster - Northwest   Regular School No Elementary KG 05 2021   grade_2 57 9 57 0   4     0   6   61 72 *                     133.0 57 9 57 0   4     0   6   61 72                 133
1675761 1675761 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn - E J Harrington   Regular School No Elementary PK 05 2021   grade_2 15 9 69 0   9     0   5   51 56 *                     107.0 15 9 69 0   9     0   5   51 56                 107
1675896 1675896 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden - Forestdale   Regular School No Elementary KG 08 2021   grade_2 22 9 9 0   9     0   7   29 27 *                     56.0 22 9 9 0   9     0   7   29 27                 56
1675930 1675930 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield - Everett W Robinson   Regular School No Elementary KG 02 2021   grade_2 172 9 16 0   12     0   14   115 108 *                     223.0 172 9 16 0   12     0   14   115 108                 223

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