Data source: Big Local News · About: Big Local

6,787 rows where grade = "grade_3" and state = "MA" sorted by total descending

View and edit SQL

year

grade

  • grade_3 · 6,787
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
1365335 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_3 35 16 42 0   0     0   6   46 53 *                     99.0 35 16 42 0   0     0   6   46 53                 99
1366795 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_3 79 3 6 0   1     0   10   57 42 *                     99.0 79 3 6 0   1     0   10   57 42                 99
1366976 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No Elementary 03 05 2020   grade_3 80 0 7 0   5     0   7   53 46 *                     99.0 80 0 7 0   5     0   7   53 46                 99
1368817 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2020   grade_3 75 1 15 0   0     0   8   58 41 *                     99.0 75 1 15 0   0     0   8   58 41                 99
1369067 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No Elementary PK 05 2020   grade_3 75 6 5 0   8     0   5   50 49 *                     99.0 75 6 5 0   8     0   5   50 49                 99
1369373 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_3 68 2 6 0   16     0   7   55 44 *                     99.0 68 2 6 0   16     0   7   55 44                 99
1370420 MA Essex   school 2510380 258   Salem 251038001668 2580070 Witchcraft Heights   Regular School No Elementary KG 05 2020   grade_3 34 11 43 0   4     0   7   47 52 *                     99.0 34 11 43 0   4     0   7   47 52                 99
1373635 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Elementary School   Regular School No Elementary PK 05 2020   grade_3 90 1 3 0   1     0   4   51 48 *                     99.0 90 1 3 0   1     0   4   51 48                 99
1673583 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington - Fox Hill   Regular School No Elementary KG 05 2021   grade_3 49 5 5 0   33     0   7   50 49 *                     99.0 49 5 5 0   33     0   7   50 49                 99
1674700 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_3 91 1 2 0   2     0   3   52 47 *                     99.0 91 1 2 0   2     0   3   52 47                 99
1674841 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_3 84 2 9 0   0     0   4   50 49 *                     99.0 84 2 9 0   0     0   4   50 49                 99
1675888 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_3 26 12 30 0   28     0   3   57 42 *                     99.0 26 12 30 0   28     0   3   57 42                 99
1675991 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_3 39 5 46 0   9     0   0   53 46 *                     99.0 39 5 46 0   9     0   0   53 46                 99
1676295 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Millis - Clyde F Brown   Regular School No Elementary PK 05 2021   grade_3 79 0 15 1   2     0   2   53 46 *                     99.0 79 0 15 1   2     0   2   53 46                 99
1677057 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford - Clara Barton   Regular School No Elementary 02 04 2021   grade_3 82 2 12 0   0     0   3   50 49 *                     99.0 82 2 12 0   0     0   3   50 49                 99
1677554 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Revere - Garfield Elementary School   Regular School No Elementary PK 05 2021   grade_3 21 4 69 0   3     0   2   46 53 *                     99.0 21 4 69 0   3     0   2   46 53                 99
2043423 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 05 2019   grade_3 47 1 38 0   8     0   5   51 48                       99.0 47 1 38 0   8     0   5   51 48                 99
2044366 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2019   grade_3 70 4 17 0   1     0   7   59 40                       99.0 70 4 17 0   1     0   7   59 40                 99
2046394 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Louise Davy Trahan   Regular School No Elementary 03 04 2019   grade_3 92 0 1 0   2     0   4   43 56                       99.0 92 0 1 0   2     0   4   43 56                 99
2048399 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2019   grade_3 92 3 3 0   1     0   0   51 48                       99.0 92 3 3 0   1     0   0   51 48                 99
2229803 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_3 2 55 40 0   1     0   1   49 50                       99.0 2 55 40 0   1     0   1   49 50                 99
2231845 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham: Woodrow Wilson   Regular School No Elementary KG 05 2018   grade_3 70 9 18 0   0     0   2   53 46                       99.0 70 9 18 0   0     0   2   53 46                 99
2232854 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Lexington: Fiske   Regular School No Elementary KG 05 2018   grade_3 53 6 4 0   30     0   6   54 45                       99.0 53 6 4 0   30     0   6   54 45                 99
2233230 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn: E J Harrington   Regular School No Elementary PK 05 2018   grade_3 9 10 69 0   9     0   2   45 54                       99.0 9 10 69 0   9     0   2   45 54                 99
2233620 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 Medford: John J McGlynn Elementary School   Regular School No Elementary PK 05 2018   grade_3 46 19 7 1   14     0   12   57 42                       99.0 46 19 7 1   14     0   12   57 42                 99
2235706 MA Worcester   school 2510770 271   Shrewsbury 251077001718 2710035 Shrewsbury: Spring Street   Regular School No Elementary KG 04 2018   grade_3 57 1 11 0   25     0   5   50 49                       99.0 57 1 11 0   25     0   5   50 49                 99
2239256 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Narragansett: Baldwinville Elementary   Regular School No Elementary 02 04 2018   grade_3 86 1 5 0   0     0   7   49 50                       99.0 86 1 5 0   0     0   7   49 50                 99
736987 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_3 93 0 2 0   3     0   1   43 56                       99 93 0 2 0   3     0   1   43 56                 99
739124 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_3 45 6 4 0   37     0   7   53 46                       99 45 6 4 0   37     0   7   53 46                 99
936846 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No 1 KG 05 2016   grade_3 80 9 5 0   3     0   2   60 39                       99 80 9 5 0   3     0   2   60 39                 99
938992 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No 1 03 05 2016   grade_3 95 1 2 0   1     0   0   57 42                       99 95 1 2 0   1     0   0   57 42                 99
1122934 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2017   grade_3 9 38 22 1   25     0   4   53 46                       99 9 38 22 1   25     0   4   53 46                 99
1122998 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_3 3 39 51 1   1     1   3   53 46                       99 3 39 51 1   1     1   3   53 46                 99
1123217 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_3 2 60 35 0   0     0   2   46 53                       99 2 60 35 0   0     0   2   46 53                 99
1124352 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_3 90 0 1 0   2     0   6   39 60                       99 90 0 1 0   2     0   6   39 60                 99
1124871 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_3 34 4 52 0   4     0   5   52 47                       99 34 4 52 0   4     0   5   52 47                 99
1127058 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary PK 05 2017   grade_3 79 5 2 0   7     1   5   52 47                       99 79 5 2 0   7     1   5   52 47                 99
1129577 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2017   grade_3 84 0 2 0   4     0   9   51 48                       99 84 0 2 0   4     0   9   51 48                 99
1131505 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes Elementary KG 05 2017   grade_3 68 4 22 0   3     0   2   56 43                       99 68 4 22 0   3     0   2   56 43                 99
1132161 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2017   grade_3 87 1 2 0   5     0   4   48 51                       99 87 1 2 0   5     0   4   48 51                 99
1132858 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Houghton Elementary   Regular School No Elementary KG 04 2017   grade_3 88 1 6 0   0     0   4   57 42                       99 88 1 6 0   0     0   4   57 42                 99
1366186 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2020   grade_3 37 42 12 0   0     0   7   51 47 *                     98.0 37 42 12 0   0     0   7   51 47                 98
1366213 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_3 16 53 17 1   1     1   9   60 38 *                     98.0 16 53 17 1   1     1   9   60 38                 98
1368513 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2020   grade_3 7 5 78 0   6     0   2   41 57 *                     98.0 7 5 78 0   6     0   2   41 57                 98
1368520 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2020   grade_3 9 8 75 0   5     0   1   52 46 *                     98.0 9 8 75 0   5     0   1   52 46                 98
1371555 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2020   grade_3 52 3 24 0   8     0   11   56 42 *                     98.0 52 3 24 0   8     0   11   56 42                 98
1371576 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2020   grade_3 75 5 1 0   10     1   6   48 50 *                     98.0 75 5 1 0   10     1   6   48 50                 98
1373263 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton Elementary   Regular School No Elementary PK 04 2020   grade_3 79 2 6 0   2     0   9   50 48 *                     98.0 79 2 6 0   2     0   9   50 48                 98
1672231 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_3 61 3 21 0   4     0   9   48 50 *                     98.0 61 3 21 0   4     0   9   48 50                 98
1675879 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_3 26 12 15 0   40     0   5   48 50 *                     98.0 26 12 15 0   40     0   5   48 50                 98
1676986 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 Norwell - William G Vinal   Regular School No Elementary PK 05 2021   grade_3 89 1 2 0   0     0   6   53 45 *                     98.0 89 1 2 0   0     0   6   53 45                 98
1678239 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 Springfield - German Gerena Community School   Regular School No Elementary PK 05 2021   grade_3 5 16 77 0   0     0   0   45 53 *                     98.0 5 16 77 0   0     0   0   45 53                 98
1680798 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Mendon-Upton - Memorial School   Regular School No Elementary PK 04 2021   grade_3 81 2 6 0   6     0   3   56 42 *                     98.0 81 2 6 0   6     0   3   56 42                 98
2039940 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_3 69 1 7 0   20     0   1   46 52                       98.0 69 1 7 0   20     0   1   46 52                 98
2043094 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_3 4 1 93 0   0     0   0   51 47                       98.0 4 1 93 0   0     0   0   51 47                 98
2231363 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 East Longmeadow: Mapleshade   Regular School No Elementary 03 05 2018   grade_3 71 6 13 0   5     0   3   60 38                       98.0 71 6 13 0   5     0   3   60 38                 98
2232840 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Lexington: Bowman   Regular School No Elementary KG 05 2018   grade_3 41 4 2 0   37     0   14   50 48                       98.0 41 4 2 0   37     0   14   50 48                 98
2233020 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Lowell: Charles W Morey   Regular School No Elementary PK 04 2018   grade_3 23 5 9 0   58     0   3   47 51                       98.0 23 5 9 0   58     0   3   47 51                 98
2233222 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Lynn: Wm P Connery   Regular School No Elementary PK 05 2018   grade_3 7 7 65 1   17     0   1   53 45                       98.0 7 7 65 1   17     0   1   53 45                 98
2233365 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_3 30 20 11 0   32     0   5   52 46                       98.0 30 20 11 0   32     0   5   52 46                 98
2233584 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard: Green Meadow   Regular School No Elementary PK 03 2018   grade_3 72 3 11 0   3     0   9   50 48                       98.0 72 3 11 0   3     0   9   50 48                 98
2233982 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Natick: Memorial   Regular School No Elementary KG 04 2018   grade_3 86 0 5 0   2     0   5   55 43                       98.0 86 0 5 0   2     0   5   55 43                 98
2234033 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham: Newman Elementary   Regular School No Elementary PK 05 2018   grade_3 73 8 2 0   11     1   3   48 50                       98.0 73 8 2 0   11     1   3   48 50                 98
2238338 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter (District): Silver Hill Horace Mann Charter School   Regular School Yes Elementary KG 05 2018   grade_3 76 3 17 0   0     0   2   51 47                       98.0 76 3 17 0   0     0   2   51 47                 98
2238633 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol-Royalston: Athol Community Elementary School   Regular School No Elementary PK 04 2018   grade_3 78 1 10 0   3     0   6   58 40                       98.0 78 1 10 0   3     0   6   58 40                 98
735884 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2015   grade_3 61 7 15 0   9     0   6   50 48                       98 61 7 15 0   9     0   6   50 48                 98
735915 MA Worcester   school 2502220 17   Auburn 250222000102 170005 Julia Bancroft   Regular School No 1 03 05 2015   grade_3 77 3 8 0   6     0   4   52 46                       98 77 3 8 0   6     0   4   52 46                 98
736495 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2015   grade_3 5 44 19 0   24     1   5   47 51                       98 5 44 19 0   24     1   5   47 51                 98
736770 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_3 3 22 72 0   0     0   1   43 55                       98 3 22 72 0   0     0   1   43 55                 98
737476 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_3 77 0 4 0   15     0   2   43 55                       98 77 0 4 0   15     0   2   43 55                 98
739130 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_3 45 5 4 0   36     0   8   48 50                       98 45 5 4 0   36     0   8   48 50                 98
740233 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2015   grade_3 78 8 4 0   2     0   6   58 40                       98 78 8 4 0   2     0   6   58 40                 98
741433 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No 1 KG 05 2015   grade_3 68 3 21 0   6     0   0   52 46                       98 68 3 21 0   6     0   0   52 46                 98
932749 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   grade_3 68 3 25 0   1     0   1   55 43                       98 68 3 25 0   1     0   1   55 43                 98
932885 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 03 2016   grade_3 88 0 3 0   7     0   0   44 54                       98 88 0 3 0   7     0   0   44 54                 98
937044 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2016   grade_3 25 14 49 2   0     0   8   55 43                       98 25 14 49 2   0     0   8   55 43                 98
938639 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2016   grade_3 17 19 57 0   4     0   1   50 48                       98 17 19 57 0   4     0   1   50 48                 98
938751 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2016   grade_3 0 11 87 0   0     0   0   41 57                       98 0 11 87 0   0     0   0   41 57                 98
939332 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No 1 KG 05 2016   grade_3 75 7 1 0   10     0   5   41 57                       98 75 7 1 0   10     0   5   41 57                 98
940602 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 2016   grade_3 65 8 19 0   6     0   0   51 47                       98 65 8 19 0   6     0   0   51 47                 98
941412 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No 1 PK 05 2016   grade_3 81 0 5 0   11     0   1   54 44                       98 81 0 5 0   11     0   1   54 44                 98
941983 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 07 2016   grade_3 2 51 42 0   0     0   3   50 48                       98 2 51 42 0   0     0   3   50 48                 98
1124461 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 George H. Englesby Elementary School   Regular School No Elementary KG 05 2017   grade_3 69 7 12 0   6     0   4   50 48                       98 69 7 12 0   6     0   4   50 48                 98
1124546 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2017   grade_3 78 4 3 0   11     0   2   42 56                       98 78 4 3 0   11     0   2   42 56                 98
1128301 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2017   grade_3 41 13 11 0   27     0   6   59 39                       98 41 13 11 0   27     0   6   59 39                 98
1129757 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2017   grade_3 88 1 2 0   2     0   5   45 53                       98 88 1 2 0   2     0   5   45 53                 98
1132099 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2017   grade_3 98 0 0 0   0     0   0   46 52                       98 98 0 0 0   0     0   0   46 52                 98
1132955 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary 03 05 2017   grade_3 95 0 1 0   0     0   2   49 49                       98 95 0 1 0   0     0   2   49 49                 98
1368638 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_3 31 12 14 0   34     0   6   45 52 *                     97.0 31 12 14 0   34     0   6   45 52                 97
1368647 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_3 21 18 33 0   21     0   4   45 52 *                     97.0 21 18 33 0   21     0   4   45 52                 97
1369073 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2020   grade_3 76 6 3 0   4     0   8   50 47 *                     97.0 76 6 3 0   4     0   8   50 47                 97
1369195 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2020   grade_3 77 1 2 0   9     0   8   52 45 *                     97.0 77 1 2 0   9     0   8   52 45                 97
1369246 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2020   grade_3 9 18 67 0   2     0   1   47 50 *                     97.0 9 18 67 0   2     0   1   47 50                 97
1369267 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2020   grade_3 23 12 55 1   1     0   5   54 43 *                     97.0 23 12 55 1   1     0   5   54 43                 97
1369717 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2020   grade_3 82 1 5 0   0     0   9   43 54 *                     97.0 82 1 5 0   0     0   9   43 54                 97
1370019 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2020   grade_3 82 4 4 0   2     0   5   55 42 *                     97.0 82 4 4 0   2     0   5   55 42                 97
1370782 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2020   grade_3 12 8 75 0   2     0   0   57 40 *                     97.0 12 8 75 0   2     0   0   57 40                 97
1672111 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover - Bancroft Elementary   Regular School No Elementary KG 05 2021   grade_3 83 2 3 0   6     0   3   49 48 *                     97.0 83 2 3 0   6     0   3   49 48                 97
1673781 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_3 54 7 11 0   24     1   0   48 49 *                     97.0 54 7 11 0   24     1   0   48 49                 97
1674276 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_3 17 16 55 0   5     0   4   52 45 *                     97.0 17 16 55 0   5     0   4   52 45                 97

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