enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by total 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
1366549 1366549 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   grade_2 63 5 10 0   21     0   0   47 52 *                     99.0 63 5 10 0   21     0   0   47 52                 99
1366880 1366880 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2020   grade_2 81 3 9 0   2     0   4   55 44 *                     99.0 81 3 9 0   2     0   4   55 44                 99
1368637 1368637 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_2 29 11 16 0   39     0   4   51 48 *                     99.0 29 11 16 0   39     0   4   51 48                 99
1373960 1373960 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2020   grade_2 84 1 10 0   1     0   3   47 52 *                     99.0 84 1 10 0   1     0   3   47 52                 99
1675779 1675779 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   grade_2 6 5 83 0   4     0   1   48 51 *                     99.0 6 5 83 0   4     0   1   48 51                 99
1676307 1676307 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Milton - Collicot   Regular School No Elementary KG 05 2021   grade_2 79 1 3 0   11     0   5   48 51 *                     99.0 79 1 3 0   11     0   5   48 51                 99
1676441 1676441 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham - Newman Elementary   Regular School No Elementary PK 05 2021   grade_2 79 2 4 0   7     0   7   60 39 *                     99.0 79 2 4 0   7     0   7   60 39                 99
1676540 1676540 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 New Bedford - Casimir Pulaski   Regular School No Elementary PK 05 2021   grade_2 64 6 21 2   3     0   3   53 46 *                     99.0 64 6 21 2   3     0   3   53 46                 99
1677363 1677363 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_2 29 4 12 2   44     0   8   52 47 *                     99.0 29 4 12 2   44     0   8   52 47                 99
1678523 1678523 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 Taunton - East Taunton Elementary   Regular School No Elementary KG 04 2021   grade_2 70 17 5 0   0     0   7   44 55 *                     99.0 70 17 5 0   0     0   7   44 55                 99
1678926 1678926 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Westborough - Annie E Fales   Regular School No Elementary KG 03 2021   grade_2 47 1 2 0   48     1   0   49 50 *                     99.0 47 1 2 0   48     1   0   49 50                 99
1680053 1680053 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_2 2 58 39 0   0     0   0   45 54 *                     99.0 2 58 39 0   0     0   0   45 54                 99
1680557 1680557 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg - Dudley Elementary   Regular School No Elementary 02 04 2021   grade_2 78 2 12 1   1     0   5   59 40 *                     99.0 78 2 12 1   1     0   5   59 40                 99
2041237 2041237 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2019   grade_2 31 48 8 0   5     0   7   51 48                       99.0 31 48 8 0   5     0   7   51 48                 99
2041258 2041258 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2019   grade_2 5 78 11 1   0     0   4   49 50                       99.0 5 78 11 1   0     0   4   49 50                 99
2042592 2042592 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_2 81 1 5 1   7     0   4   44 55                       99.0 81 1 5 1   7     0   4   44 55                 99
2042665 2042665 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_2 92 2 4 0   0     0   1   50 49                       99.0 92 2 4 0   0     0   1   50 49                 99
2042761 2042761 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Silver Hill Elementary School   Regular School No Elementary KG 05 2019   grade_2 48 8 33 0   2     0   8   50 49                       99.0 48 8 33 0   2     0   8   50 49                 99
2043576 2043576 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2019   grade_2 4 4 83 0   5     0   3   45 54                       99.0 4 4 83 0   5     0   3   45 54                 99
2043607 2043607 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2019   grade_2 10 5 76 1   6     0   1   50 49                       99.0 10 5 76 1   6     0   1   50 49                 99
2044790 2044790 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2019   grade_2 83 1 7 0   0     0   8   45 54                       99.0 83 1 7 0   0     0   8   45 54                 99
2045818 2045818 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 02 05 2019   grade_2 32 1 66 0   0     0   0   53 46                       99.0 32 1 66 0   0     0   0   53 46                 99
2046336 2046336 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2019   grade_2 76 12 4 0   3     0   4   53 46                       99.0 76 12 4 0   3     0   4   53 46                 99
2047074 2047074 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2019   grade_2 85 1 7 0   0     0   6   59 40                       99.0 85 1 7 0   0     0   6   59 40                 99
2228776 2228776 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_2 89 0 4 0   0     0   6   53 46                       99.0 89 0 4 0   0     0   6   53 46                 99
2230444 2230444 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton: Hancock   Regular School No Elementary KG 05 2018   grade_2 38 43 8 0   2     0   8   43 56                       99.0 38 43 8 0   2     0   8   43 56                 99
2230871 2230871 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford: Byam School   Regular School No Elementary KG 04 2018   grade_2 76 3 10 0   7     0   3   54 45                       99.0 76 3 10 0   7     0   3   54 45                 99
2231168 2231168 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth: James M. Quinn School   Regular School No Elementary KG 05 2018   grade_2 83 1 5 0   3     0   7   57 42                       99.0 83 1 5 0   3     0   7   57 42                 99
2231809 2231809 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham: Hemenway   Regular School No Elementary KG 05 2018   grade_2 64 3 16 0   8     0   8   49 50                       99.0 64 3 16 0   8     0   8   49 50                 99
2232735 2232735 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester: Leicester Primary School   Regular School No Elementary PK 02 2018   grade_2 76 8 9 0   5     0   1   64 35                       99.0 76 8 9 0   5     0   1   64 35                 99
2232832 2232832 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Lexington: Bridge   Regular School No Elementary KG 05 2018   grade_2 41 6 4 1   43     0   4   48 51                       99.0 41 6 4 1   43     0   4   48 51                 99
2233364 2233364 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_2 38 14 8 0   32     0   7   60 39                       99.0 38 14 8 0   32     0   7   60 39                 99
2233874 2233874 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Milton: Collicot   Regular School No Elementary PK 05 2018   grade_2 82 4 3 0   6     0   4   60 39                       99.0 82 4 3 0   6     0   4   60 39                 99
2237181 2237181 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 West Springfield: Philip G Coburn   Regular School No Elementary KG 05 2018   grade_2 52 9 17 0   20     0   1   45 54                       99.0 52 9 17 0   20     0   1   45 54                 99
2238632 2238632 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol-Royalston: Athol Community Elementary School   Regular School No Elementary PK 04 2018   grade_2 80 2 13 0   1     0   3   47 52                       99.0 80 2 13 0   1     0   3   47 52                 99
735883 735883 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2015   grade_2 60 6 15 0   12     0   6   45 54                       99 60 6 15 0   12     0   6   45 54                 99
737109 737109 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2015   grade_2 7 77 12 1   1     0   1   54 45                       99 7 77 12 1   1     0   1   54 45                 99
740426 740426 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2015   grade_2 88 1 7 0   0     0   3   49 50                       99 88 1 7 0   0     0   3   49 50                 99
741236 741236 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 William McKinley   Regular School No 1 KG 05 2015   grade_2 30 6 56 1   1     0   5   45 54                       99 30 6 56 1   1     0   5   45 54                 99
742503 742503 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No 1 PK 05 2015   grade_2 76 4 5 2   9     0   3   56 43                       99 76 4 5 2   9     0   3   56 43                 99
743301 743301 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_2 37 16 33 0   6     0   7   51 48                       99 37 16 33 0   6     0   7   51 48                 99
934583 934583 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2016   grade_2 88 1 1 0   2     0   7   38 61                       99 88 1 1 0   2     0   7   38 61                 99
935491 935491 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2016   grade_2 85 1 2 0   6     0   5   51 48                       99 85 1 2 0   6     0   5   51 48                 99
936141 936141 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No 1 PK 04 2016   grade_2 29 1 38 0   27     0   4   50 49                       99 29 1 38 0   27     0   4   50 49                 99
937150 937150 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No 1 KG 05 2016   grade_2 57 7 3 0   30     0   2   54 45                       99 57 7 3 0   30     0   2   54 45                 99
938070 938070 MA Suffolk   school 2510050 248   Revere 251005001629 2480050 Paul Revere   Regular School No 1 KG 05 2016   grade_2 47 3 40 0   5     0   4   54 45                       99 47 3 40 0   5     0   4   54 45                 99
941105 941105 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No 1 PK 03 2016   grade_2 99 0 0 0   0     0   0   46 53                       99 99 0 0 0   0     0   0   46 53                 99
941109 941109 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No 1 KG 03 2016   grade_2 97 0 1 0   1     0   0   51 48                       99 97 0 1 0   1     0   0   51 48                 99
1126016 1126016 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2017   grade_2 47 7 3 0   42     0   0   54 45                       99 47 7 3 0   42     0   0   54 45                 99
1127476 1127476 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2017   grade_2 66 4 5 0   17     0   7   54 45                       99 66 4 5 0   17     0   7   54 45                 99
1365017 1365017 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 14 9 1   10     0   7   51 47 *                     98.0 57 14 9 1   10     0   7   51 47                 98
1366619 1366619 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   grade_2 41 10 43 0   1     0   3   52 46 *                     98.0 41 10 43 0   1     0   3   52 46                 98
1372788 1372788 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_2 1 53 40 0   1     1   2   48 50 *                     98.0 1 53 40 0   1     1   2   48 50                 98
1672135 1672135 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover - West Elementary   Regular School No Elementary KG 05 2021   grade_2 66 5 10 0   10     0   7   52 46 *                     98.0 66 5 10 0   10     0   7   52 46                 98
1673780 1673780 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_2 56 5 11 0   22     0   4   44 54 *                     98.0 56 5 11 0   22     0   4   44 54                 98
1674770 1674770 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_2 74 2 3 0   19     0   0   51 47 *                     98.0 74 2 3 0   19     0   0   51 47                 98
1676416 1676416 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Needham - Broadmeadow   Regular School No Elementary KG 05 2021   grade_2 65 3 5 0   15     0   10   48 50 *                     98.0 65 3 5 0   15     0   10   48 50                 98
1676513 1676513 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 New Bedford - Hayden/McFadden   Regular School No Elementary PK 05 2021   grade_2 25 14 55 0   0     1   3   49 49 *                     98.0 25 14 55 0   0     1   3   49 49                 98
2045875 2045875 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2019   grade_2 3 19 76 0   0     0   0   46 52                       98.0 3 19 76 0   0     0   0   46 52                 98
2046056 2046056 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   grade_2 2 11 83 0   1     0   1   53 45                       98.0 2 11 83 0   1     0   1   53 45                 98
2046648 2046648 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2019   grade_2 75 5 1 0   10     1   6   46 52                       98.0 75 5 1 0   10     1   6   46 52                 98
2046847 2046847 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2019   grade_2 70 0 3 0   22     0   3   47 51                       98.0 70 0 3 0   22     0   3   47 51                 98
2229802 2229802 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_2 1 58 32 1   2     0   4   46 52                       98.0 1 58 32 1   2     0   4   46 52                 98
2233342 2233342 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Lynnfield: Huckleberry Hill   Regular School No Elementary KG 04 2018   grade_2 77 2 8 0   6     0   5   42 56                       98.0 77 2 8 0   6     0   5   42 56                 98
2233394 2233394 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden: Linden   Regular School No Elementary KG 08 2018   grade_2 25 28 13 0   28     0   4   51 47                       98.0 25 28 13 0   28     0   4   51 47                 98
2236729 2236729 MA Middlesex   school 2512000 308   Waltham 251200001974 3080040 Waltham: Northeast Elementary School   Regular School No Elementary PK 05 2018   grade_2 42 14 33 0   6     0   3   53 45                       98.0 42 14 33 0   6     0   3   53 45                 98
2238991 2238991 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Groton-Dunstable: Florence Roche School   Regular School No Elementary KG 04 2018   grade_2 87 0 1 1   5     0   4   52 46                       98.0 87 0 1 1   5     0   4   52 46                 98
737475 737475 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_2 78 0 5 0   14     0   1   63 35                       98 78 0 5 0   14     0   1   63 35                 98
741060 741060 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_2 43 13 11 0   25     3   3   57 41                       98 43 13 11 0   25     3   3   57 41                 98
741515 741515 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No 1 KG 05 2015   grade_2 60 4 2 0   26     0   6   54 44                       98 60 4 2 0   26     0   6   54 44                 98
741838 741838 MA Hampden   school 2511130 281   Springfield 251113001808 2810085 Homer Street   Regular School No 1 KG 05 2015   grade_2 9 27 59 0   0     0   3   50 48                       98 9 27 59 0   0     0   3   50 48                 98
742409 742409 MA Middlesex   school 2512000 308   Waltham 251200001973 3080005 William F. Stanley Elementary School   Regular School No 1 PK 05 2015   grade_2 35 7 46 0   7     0   3   54 44                       98 35 7 46 0   7     0   3   54 44                 98
744811 744811 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   grade_2 92 1 2 0   0     0   3   50 48                       98 92 1 2 0   0     0   3   50 48                 98
932639 932639 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_2 74 1 8 0   8     0   7   45 53                       98 74 1 8 0   8     0   7   45 53                 98
934828 934828 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_2 34 13 46 1   1     0   3   57 41                       98 34 13 46 1   1     0   3   57 41                 98
935015 935015 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2016   grade_2 31 5 54 0   4     0   4   50 48                       98 31 5 54 0   4     0   4   50 48                 98
935137 935137 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_2 61 13 20 0   2     0   2   44 54                       98 61 13 20 0   2     0   2   44 54                 98
936079 936079 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2016   grade_2 33 4 20 0   34     0   7   49 49                       98 33 4 20 0   34     0   7   49 49                 98
936085 936085 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers Early Learning Center   Regular School No 1 PK 03 2016   grade_2 34 8 36 0   17     0   3   49 49                       98 34 8 36 0   17     0   3   49 49                 98
936124 936124 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2016   grade_2 24 2 13 0   56     0   3   62 36                       98 24 2 13 0   56     0   3   62 36                 98
936924 936924 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Lilja Elementary   Regular School No 1 KG 04 2016   grade_2 78 5 4 0   8     0   3   46 52                       98 78 5 4 0   8     0   3   46 52                 98
938118 938118 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2016   grade_2 67 6 19 0   2     0   4   49 49                       98 67 6 19 0   2     0   4   49 49                 98
938239 938239 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No 1 KG 05 2016   grade_2 65 6 19 1   4     0   3   44 54                       98 65 6 19 1   4     0   3   44 54                 98
939265 939265 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No 1 PK 03 2016   grade_2 87 1 6 0   0     0   4   60 38                       98 87 1 6 0   0     0   4   60 38                 98
939912 939912 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_2 26 20 45 0   5     0   2   62 36                       98 26 20 45 0   5     0   2   62 36                 98
941751 941751 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Houghton Elementary   Regular School No 1 KG 04 2016   grade_2 87 1 5 0   0     0   5   56 42                       98 87 1 5 0   0     0   5   56 42                 98
1122647 1122647 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2017   grade_2 16 20 56 0   2     0   4   61 37                       98 16 20 56 0   2     0   4   61 37                 98
1124666 1124666 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_2 29 19 43 0   5     0   2   50 48                       98 29 19 43 0   5     0   2   50 48                 98
1124846 1124846 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_2 81 6 5 1   2     0   3   52 46                       98 81 6 5 1   2     0   3   52 46                 98
1126148 1126148 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2017   grade_2 39 4 25 0   25     0   5   53 45                       98 39 4 25 0   25     0   5   53 45                 98
1126209 1126209 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No Elementary PK 04 2017   grade_2 34 5 27 0   27     0   5   52 46                       98 34 5 27 0   27     0   5   52 46                 98
1127163 1127163 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2017   grade_2 88 0 4 0   1     0   5   54 44                       98 88 0 4 0   1     0   5   54 44                 98
1127277 1127277 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   grade_2 20 10 65 1   0     0   2   53 45                       98 20 10 65 1   0     0   2   53 45                 98
1129325 1129325 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2017   grade_2 4 6 88 0   0     0   0   49 49                       98 4 6 88 0   0     0   0   49 49                 98
1130142 1130142 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2017   grade_2 47 3 4 0   44     0   0   44 54                       98 47 3 4 0   44     0   0   44 54                 98
1364887 1364887 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_2 84 2 2 0   7     0   2   51 46 *                     97.0 84 2 2 0   7     0   2   51 46                 97
1368174 1368174 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2020   grade_2 51 5 4 0   29     0   8   49 48 *                     97.0 51 5 4 0   29     0   8   49 48                 97
1368505 1368505 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2020   grade_2 4 4 84 0   4     0   1   55 42 *                     97.0 4 4 84 0   4     0   1   55 42                 97
1368624 1368624 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Summer Street   Regular School No Elementary KG 04 2020   grade_2 80 2 6 0   8     0   1   50 47 *                     97.0 80 2 6 0   8     0   1   50 47                 97
1370126 1370126 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2020   grade_2 22 16 11 0   48     0   0   41 56 *                     97.0 22 16 11 0   48     0   0   41 56                 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]);