enrollments

Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,880 ✖
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
1368356 1368356 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2020   grade_1 40 5 42 0   9     0   3   42 57 *                     99.0 40 5 42 0   9     0   3   42 57                 99
1370058 1370058 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2020   grade_1 82 4 4 1   1     0   7   46 53 *                     99.0 82 4 4 1   1     0   7   46 53                 99
1370560 1370560 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No Elementary KG 05 2020   grade_1 55 3 5 0   30     0   6   52 47 *                     99.0 55 3 5 0   30     0   6   52 47                 99
1371150 1371150 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_1 88 1 4 0   2     0   4   49 50 *                     99.0 88 1 4 0   2     0   4   49 50                 99
1673409 1673409 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_1 12 67 15 1   0     0   4   46 53 *                     99.0 12 67 15 1   0     0   4   46 53                 99
1673817 1673817 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_1 11 4 84 0   0     0   0   45 54 *                     99.0 11 4 84 0   0     0   0   45 54                 99
1675361 1675361 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_1 54 8 28 0   5     0   4   57 42 *                     99.0 54 8 28 0   5     0   4   57 42                 99
1675760 1675760 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn - E J Harrington   Regular School No Elementary PK 05 2021   grade_1 13 11 67 0   7     0   1   59 40 *                     99.0 13 11 67 0   7     0   1   59 40                 99
1678122 1678122 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Springfield - Frederick Harris   Regular School No Elementary PK 05 2021   grade_1 16 15 59 1   1     0   7   51 48 *                     99.0 16 15 59 1   1     0   7   51 48                 99
1678237 1678237 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 Springfield - German Gerena Community School   Regular School No Elementary PK 05 2021   grade_1 5 16 71 0   2     0   5   52 47 *                     99.0 5 16 71 0   2     0   5   52 47                 99
2042209 2042209 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2019   grade_1 49 6 28 0   1     0   15   54 45                       99.0 49 6 28 0   1     0   15   54 45                 99
2043078 2043078 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   grade_1 1 2 95 0   1     0   0   55 44                       99.0 1 2 95 0   1     0   0   55 44                 99
2043263 2043263 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2019   grade_1 36 4 3 0   41     0   15   58 41                       99.0 36 4 3 0   41     0   15   58 41                 99
2043589 2043589 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2019   grade_1 7 10 71 0   7     0   4   48 51                       99.0 7 10 71 0   7     0   4   48 51                 99
2046912 2046912 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No Elementary KG 05 2019   grade_1 58 2 16 0   22     0   1   53 46                       99.0 58 2 16 0   22     0   1   53 46                 99
2048309 2048309 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2019   grade_1 75 6 8 1   5     1   3   46 53                       99.0 75 6 8 1   5     1   3   46 53                 99
2048593 2048593 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Memorial School   Regular School No Elementary PK 04 2019   grade_1 84 1 6 0   5     0   3   53 46                       99.0 84 1 6 0   5     0   3   53 46                 99
2229024 2229024 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro: Hyman Fine Elementary School   Regular School No Elementary KG 04 2018   grade_1 62 4 18 0   5     0   10   45 54                       99.0 62 4 18 0   5     0   10   45 54                 99
2230475 2230475 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton: Downey   Regular School No Elementary KG 05 2018   grade_1 16 54 18 1   2     1   7   62 37                       99.0 16 54 18 1   2     1   7   62 37                 99
2231540 2231540 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River: Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2018   grade_1 46 3 39 0   1     0   10   58 41                       99.0 46 3 39 0   1     0   10   58 41                 99
2232640 2232640 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_1 2 1 95 0   1     0   0   50 49                       99.0 2 1 95 0   1     0   0   50 49                 99
2233025 2233025 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Lowell: Pawtucketville Memorial   Regular School No Elementary PK 04 2018   grade_1 34 9 27 0   23     0   6   55 44                       99.0 34 9 27 0   23     0   6   55 44                 99
2233363 2233363 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_1 32 11 9 0   38     0   9   49 50                       99.0 32 11 9 0   38     0   9   49 50                 99
2235120 2235120 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy: Lincoln-Hancock Community School   Regular School No Elementary KG 04 2018   grade_1 38 8 10 1   36     1   5   50 49                       99.0 38 8 10 1   36     1   5   50 49                 99
2236014 2236014 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Springfield: Frederick Harris   Regular School No Elementary PK 05 2018   grade_1 22 20 49 0   1     0   7   50 49                       99.0 22 20 49 0   1     0   7   50 49                 99
2238883 2238883 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Dudley-Charlton Reg: Mason Road School   Regular School No Elementary PK 01 2018   grade_1 87 2 8 0   0     0   2   53 46                       99.0 87 2 8 0   0     0   2   53 46                 99
736768 736768 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_1 2 32 63 0   0     1   1   46 53                       99 2 32 63 0   0     1   1   46 53                 99
739232 739232 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2015   grade_1 35 5 16 0   35     0   8   45 54                       99 35 5 16 0   35     0   8   45 54                 99
739242 739242 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2015   grade_1 24 7 51 0   10     0   7   51 48                       99 24 7 51 0   10     0   7   51 48                 99
739276 739276 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2015   grade_1 23 2 12 0   60     0   2   63 36                       99 23 2 12 0   60     0   2   63 36                 99
739992 739992 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No 1 PK 05 2015   grade_1 79 5 4 0   6     1   4   49 50                       99 79 5 4 0   6     1   4   49 50                 99
740984 740984 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   grade_1 96 0 2 0   0     0   1   45 54                       99 96 0 2 0   0     0   1   45 54                 99
742808 742808 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No 1 KG 05 2015   grade_1 77 2 13 0   5     0   2   48 51                       99 77 2 13 0   5     0   2   48 51                 99
744998 744998 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2015   grade_1 92 2 4 0   1     0   0   54 45                       99 92 2 4 0   1     0   0   54 45                 99
934851 934851 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_1 24 18 54 0   0     1   2   49 50                       99 24 18 54 0   0     1   2   49 50                 99
936089 936089 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2016   grade_1 25 5 50 0   18     0   1   51 48                       99 25 5 50 0   18     0   1   51 48                 99
936158 936158 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No 1 PK 04 2016   grade_1 10 4 27 0   53     0   5   58 41                       99 10 4 27 0   53     0   5   58 41                 99
1121967 1121967 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_1 88 0 4 0   0     0   7   55 44                       99 88 0 4 0   0     0   7   55 44                 99
1122101 1122101 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_1 75 1 7 0   16     0   0   49 50                       99 75 1 7 0   16     0   0   49 50                 99
1124055 1124055 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2017   grade_1 73 3 9 0   11     0   3   56 43                       99 73 3 9 0   11     0   3   56 43                 99
1124412 1124412 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   grade_1 91 0 6 0   1     0   1   51 48                       99 91 0 6 0   1     0   1   51 48                 99
1124575 1124575 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2017   grade_1 82 3 5 0   1     0   8   56 43                       99 82 3 5 0   1     0   8   56 43                 99
1127056 1127056 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary PK 05 2017   grade_1 83 3 3 0   6     0   4   60 39                       99 83 3 3 0   6     0   4   60 39                 99
1132097 1132097 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2017   grade_1 92 3 3 0   1     0   0   50 49                       99 92 3 3 0   1     0   0   50 49                 99
1366992 1366992 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   grade_1 83 5 5 0   1     0   4   47 51 *                     98.0 83 5 5 0   1     0   4   47 51                 98
1368645 1368645 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_1 25 19 26 0   24     0   4   50 48 *                     98.0 25 19 26 0   24     0   4   50 48                 98
1372787 1372787 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_1 1 58 39 0   0     0   0   44 54 *                     98.0 1 58 39 0   0     0   0   44 54                 98
1374056 1374056 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_1 88 1 5 0   2     0   2   44 54 *                     98.0 88 1 5 0   2     0   2   44 54                 98
1672229 1672229 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_1 66 9 17 0   1     0   5   47 51 *                     98.0 66 9 17 0   1     0   5   47 51                 98
1678096 1678096 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield - Rebecca M Johnson   Regular School No Elementary PK 05 2021   grade_1 7 19 70 0   0     0   2   51 47 *                     98.0 7 19 70 0   0     0   2   51 47                 98
1680562 1680562 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Dudley-Charlton Reg - Mason Road School   Regular School No Elementary PK 01 2021   grade_1 81 3 13 0   0     0   1   47 51 *                     98.0 81 3 13 0   0     0   1   47 51                 98
1680651 1680651 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Groton-Dunstable - Florence Roche School   Regular School No Elementary KG 04 2021   grade_1 78 0 3 1   7     0   9   50 48 *                     98.0 78 0 3 1   7     0   9   50 48                 98
2041948 2041948 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2019   grade_1 83 1 8 0   2     0   4   52 46                       98.0 83 1 8 0   2     0   4   52 46                 98
2042835 2042835 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2019   grade_1 54 21 9 0   6     0   8   52 46                       98.0 54 21 9 0   6     0   8   52 46                 98
2044364 2044364 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2019   grade_1 72 7 13 0   0     0   6   55 43                       98.0 72 7 13 0   0     0   6   55 43                 98
2049129 2049129 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2019   grade_1 89 2 4 0   1     0   2   53 45                       98.0 89 2 4 0   1     0   2   53 45                 98
2229030 2229030 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Attleboro: Hill-Roberts Elementary School   Regular School No Elementary KG 04 2018   grade_1 56 8 16 0   6     0   12   55 43                       98.0 56 8 16 0   6     0   12   55 43                 98
2231492 2231492 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_1 13 14 65 0   6     0   0   42 56                       98.0 13 14 65 0   6     0   0   42 56                 98
2236441 2236441 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Swansea: Gardner   Regular School No Elementary KG 02 2018   grade_1 97 0 0 0   1     0   0   54 44                       98.0 97 0 0 0   1     0   0   54 44                 98
2236471 2236471 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Taunton: Joseph C Chamberlain   Regular School No Elementary KG 04 2018   grade_1 77 11 2 0   3     0   5   52 46                       98.0 77 11 2 0   3     0   5   52 46                 98
737999 737999 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_1 26 14 53 0   2     0   3   45 53                       98 26 14 53 0   2     0   3   45 53                 98
738734 738734 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_1 2 1 92 0   2     0   1   50 48                       98 2 1 92 0   2     0   1   50 48                 98
740068 740068 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No 1 KG 04 2015   grade_1 58 1 4 0   31     0   4   49 49                       98 58 1 4 0   31     0   4   49 49                 98
932958 932958 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 KG 05 2016   grade_1 81 4 7 0   1     0   5   51 47                       98 81 4 7 0   1     0   5   51 47                 98
934905 934905 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2016   grade_1 45 5 37 1   1     0   9   51 47                       98 45 5 37 1   1     0   9   51 47                 98
939310 939310 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No 1 PK 05 2016   grade_1 64 3 14 0   8     0   9   43 55                       98 64 3 14 0   8     0   9   43 55                 98
941010 941010 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No 1 PK 03 2016   grade_1 77 7 4 1   1     0   8   50 48                       98 77 7 4 1   1     0   8   50 48                 98
1122260 1122260 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_1 77 1 14 2   1     0   3   53 45                       98 77 1 14 2   1     0   3   53 45                 98
1124979 1124979 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_1 65 2 16 0   8     0   7   50 48                       98 65 2 16 0   8     0   7   50 48                 98
1125014 1125014 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_1 65 7 24 0   0     0   2   48 50                       98 65 7 24 0   0     0   2   48 50                 98
1128232 1128232 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 04 2017   grade_1 84 0 9 0   1     0   4   47 51                       98 84 0 9 0   1     0   4   47 51                 98
1367344 1367344 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_1 59 4 12 0   10     0   12   52 45 *                     97.0 59 4 12 0   10     0   12   52 45                 97
1368344 1368344 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No Elementary PK 04 2020   grade_1 22 6 38 0   28     0   3   42 55 *                     97.0 22 6 38 0   28     0   3   42 55                 97
1368523 1368523 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_1 8 8 72 0   6     0   3   51 46 *                     97.0 8 8 72 0   6     0   3   51 46                 97
1368536 1368536 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2020   grade_1 7 5 80 0   4     0   1   49 48 *                     97.0 7 5 80 0   4     0   1   49 48                 97
1370941 1370941 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Sumner Avenue   Regular School No Elementary PK 05 2020   grade_1 13 22 57 0   1     0   4   54 43 *                     97.0 13 22 57 0   1     0   4   54 43                 97
1372745 1372745 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2020   grade_1 11 19 53 0   13     0   1   55 42 *                     97.0 11 19 53 0   13     0   1   55 42                 97
1672239 1672239 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro - Peter Thacher Elementary School   Regular School No Elementary KG 04 2021   grade_1 61 12 18 0   3     0   3   51 46 *                     97.0 61 12 18 0   3     0   3   51 46                 97
1674360 1674360 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_1 35 9 46 0   3     0   4   55 42 *                     97.0 35 9 46 0   3     0   4   55 42                 97
1675332 1675332 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester - Leicester Elementary   Regular School No Elementary KG 04 2021   grade_1 70 7 12 0   5     0   3   52 45 *                     97.0 70 7 12 0   5     0   3   52 45                 97
1676377 1676377 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Natick - Bennett-Hemenway   Regular School No Elementary KG 04 2021   grade_1 68 0 7 0   17     0   5   54 43 *                     97.0 68 0 7 0   17     0   5   54 43                 97
1677811 1677811 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Sharon - Heights Elementary   Regular School No Elementary KG 05 2021   grade_1 55 9 7 0   19     0   7   46 51 *                     97.0 55 9 7 0   19     0   7   46 51                 97
1678493 1678493 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Swansea - Gardner   Regular School No Elementary KG 02 2021   grade_1 93 1 1 1   0     0   1   53 44 *                     97.0 93 1 1 1   0     0   1   53 44                 97
1678533 1678533 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Taunton - Elizabeth Pole   Regular School No Elementary KG 04 2021   grade_1 51 22 11 1   4     0   8   49 48 *                     97.0 51 22 11 1   4     0   8   49 48                 97
2040699 2040699 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_1 0 56 38 1   0     0   2   60 37                       97.0 0 56 38 1   0     0   2   60 37                 97
2041688 2041688 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2019   grade_1 47 9 38 0   1     0   2   52 45                       97.0 47 9 38 0   1     0   2   52 45                 97
2042118 2042118 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_1 20 11 59 0   2     0   5   54 43                       97.0 20 11 59 0   2     0   5   54 43                 97
2045358 2045358 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   grade_1 28 1 63 0   4     0   1   45 52                       97.0 28 1 63 0   4     0   1   45 52                 97
2047859 2047859 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_1 1 52 40 0   1     1   2   49 48                       97.0 1 52 40 0   1     1   2   49 48                 97
2229070 2229070 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   grade_1 78 4 5 0   5     0   5   49 48                       97.0 78 4 5 0   5     0   5   49 48                 97
2235322 2235322 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Revere: Abraham Lincoln   Regular School No Elementary PK 05 2018   grade_1 38 3 52 0   2     0   2   49 48                       97.0 38 3 52 0   2     0   2   49 48                 97
2239192 2239192 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Monomoy Regional School District: Harwich Elementary School   Regular School No Elementary PK 04 2018   grade_1 80 6 6 0   0     0   5   44 53                       97.0 80 6 6 0   0     0   5   44 53                 97
738246 738246 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_1 64 5 12 0   13     0   3   44 53                       97 64 5 12 0   13     0   3   44 53                 97
739202 739202 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2015   grade_1 72 0 5 0   14     2   4   43 54                       97 72 0 5 0   14     2   4   43 54                 97
932638 932638 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No 1 KG 05 2016   grade_1 74 7 5 1   4     0   6   47 50                       97 74 7 5 1   4     0   6   47 50                 97
932883 932883 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 03 2016   grade_1 92 1 1 0   2     0   1   44 53                       97 92 1 1 0   2     0   1   44 53                 97
934803 934803 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_1 19 13 58 0   6     0   1   48 49                       97 19 13 58 0   6     0   1   48 49                 97
934827 934827 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_1 24 14 53 1   2     0   3   43 54                       97 24 14 53 1   2     0   3   43 54                 97
935770 935770 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2016   grade_1 3 1 91 0   2     0   0   50 47                       97 3 1 91 0   2     0   0   50 47                 97
935968 935968 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_1 48 6 3 1   39     0   0   52 45                       97 48 6 3 1   39     0   0   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]);