enrollments

Data source: Big Local News · About: Big Local

956 rows where grade = "grade_4", state = "MA" and year = 2021 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 956 ✖

grade ✖

  • grade_4 · 956 ✖
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
1672010 1672010 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington - Woodsdale Elementary School   Regular School No Elementary 03 04 2021   grade_4 129 7 20 2   2     1   1   83 79 *                     162.0 129 7 20 2   2     1   1   83 79                 162
1672028 1672028 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_4 70 1 4 1   0     0   4   43 37 *                     80.0 70 1 4 1   0     0   4   43 37                 80
1672038 1672038 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_4 57 2 4 0   0     1   1   30 35 *                     65.0 57 2 4 0   0     1   1   30 35                 65
1672043 1672043 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_4 74 0 5 0   1     0   2   32 50 *                     82.0 74 0 5 0   1     0   2   32 50                 82
1672048 1672048 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_4 61 3 6 0   2     0   3   37 38 *                     75.0 61 3 6 0   2     0   3   37 38                 75
1672053 1672053 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_4 43 2 6 0   2     0   3   36 20 *                     56.0 43 2 6 0   2     0   3   36 20                 56
1672067 1672067 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_4 57 6 7 0   2     0   3   50 25 *                     75.0 57 6 7 0   2     0   3   50 25                 75
1672073 1672073 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_4 56 0 9 0   0     0   2   33 34 *                     67.0 56 0 9 0   0     0   2   33 34                 67
1672221 1672221 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 Attleboro - A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2021   grade_4 51 5 14 0   1     0   4   35 40 *                     75.0 51 5 14 0   1     0   4   35 40                 75
1672227 1672227 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Attleboro - Thomas Willett Elementary School   Regular School No Elementary KG 04 2021   grade_4 42 4 17 0   2     0   5   35 35 *                     70.0 42 4 17 0   2     0   5   35 35                 70
1672232 1672232 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_4 53 5 14 0   4     0   10   45 41 *                     86.0 53 5 14 0   4     0   10   45 41                 86
1672237 1672237 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Attleboro - Hill-Roberts Elementary School   Regular School No Elementary KG 04 2021   grade_4 59 8 15 0   4     0   11   59 38 *                     97.0 59 8 15 0   4     0   11   59 38                 97
1672242 1672242 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro - Peter Thacher Elementary School   Regular School No Elementary KG 04 2021   grade_4 54 10 16 0   5     0   9   39 55 *                     94.0 54 10 16 0   5     0   9   39 55                 94
1672380 1672380 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont - Winn Brook   Regular School No Elementary KG 04 2021   grade_4 50 0 3 0   30     0   7   48 42 *                     90.0 50 0 3 0   30     0   7   48 42                 90
1672385 1672385 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Belmont - Mary Lee Burbank   Regular School No Elementary KG 04 2021   grade_4 50 4 0 0   17     1   12   47 37 *                     84.0 50 4 0 0   17     1   12   47 37                 84
1672390 1672390 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Belmont - Daniel Butler   Regular School No Elementary KG 04 2021   grade_4 47 4 4 0   19     0   7   46 35 *                     81.0 47 4 4 0   19     0   7   46 35                 81
1672396 1672396 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_4 78 1 0 0   23     0   15   62 55 *                     117.0 78 1 0 0   23     0   15   62 55                 117
1672410 1672410 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_4 95 0 2 0   1     0   3   57 44 *                     101.0 95 0 2 0   1     0   3   57 44                 101
1672420 1672420 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly - Centerville Elementary   Regular School No Elementary KG 04 2021   grade_4 88 8 27 0   2     0   11   64 72 *                     136.0 88 8 27 0   2     0   11   64 72                 136
1672425 1672425 MA Essex   school 2502640 30   Beverly 250264000168 300015 Beverly - Cove Elementary   Regular School No Elementary KG 04 2021   grade_4 37 3 10 0   1     0   3   22 32 *                     54.0 37 3 10 0   1     0   3   22 32                 54
1672430 1672430 MA Essex   school 2502640 30   Beverly 250264000169 300033 Beverly - Hannah Elementary   Regular School No Elementary KG 04 2021   grade_4 30 0 7 0   0     0   3   24 16 *                     40.0 30 0 7 0   0     0   3   24 16                 40
1672435 1672435 MA Essex   school 2502640 30   Beverly 250264000173 300040 Beverly - North Beverly Elementary   Regular School No Elementary KG 04 2021   grade_4 44 0 12 0   2     0   3   36 25 *                     61.0 44 0 12 0   2     0   3   36 25                 61
1672440 1672440 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly - Ayers/Ryal Side School   Regular School No Elementary KG 04 2021   grade_4 44 2 9 0   2     0   1   33 25 *                     58.0 44 2 9 0   2     0   1   33 25                 58
1672454 1672454 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica - Thomas Ditson   Regular School No Elementary KG 04 2021   grade_4 90 7 10 0   10     0   5   63 59 *                     122.0 90 7 10 0   10     0   5   63 59                 122
1672459 1672459 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica - Frederick J Dutile   Regular School No Elementary KG 04 2021   grade_4 31 1 4 0   2     0   1   17 22 *                     39.0 31 1 4 0   2     0   1   17 22                 39
1672464 1672464 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 Billerica - John F Kennedy   Regular School No Elementary KG 04 2021   grade_4 36 2 3 0   3     0   2   24 22 *                     46.0 36 2 3 0   3     0   2   24 22                 46
1672469 1672469 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Billerica - Parker   Regular School No Elementary KG 04 2021   grade_4 48 5 10 0   7     0   2   42 30 *                     72.0 48 5 10 0   7     0   2   42 30                 72
1672474 1672474 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Billerica - Hajjar Elementary   Regular School No Elementary KG 04 2021   grade_4 52 4 8 0   6     0   2   35 37 *                     72.0 52 4 8 0   6     0   2   35 37                 72
1672553 1672553 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Boston - Mattahunt Elementary School   Regular School No Elementary PK 04 2021   grade_4 0 29 8 0   1     0   2   21 19 *                     40.0 0 29 8 0   1     0   2   21 19                 40
1673772 1673772 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford - Center Elementary School   Regular School No Elementary KG 04 2021   grade_4 67 3 8 0   15     0   3   50 46 *                     96.0 67 3 8 0   15     0   3   50 46                 96
1673777 1673777 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford - South Row   Regular School No Elementary KG 04 2021   grade_4 54 2 4 1   12     0   4   45 32 *                     77.0 54 2 4 1   12     0   4   45 32                 77
1673782 1673782 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_4 67 7 12 0   18     0   4   56 52 *                     108.0 67 7 12 0   18     0   4   56 52                 108
1673787 1673787 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford - Byam School   Regular School No Elementary KG 04 2021   grade_4 69 6 6 0   9     0   2   43 49 *                     92.0 69 6 6 0   9     0   2   43 49                 92
1673806 1673806 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_4 6 8 112 0   0     0   0   69 57 *                     126.0 6 8 112 0   0     0   0   69 57                 126
1673810 1673810 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_4 16 7 117 2   0     0   0   71 71 *                     142.0 16 7 117 2   0     0   0   71 71                 142
1673820 1673820 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_4 6 4 126 0   0     0   1   81 56 *                     137.0 6 4 126 0   0     0   1   81 56                 137
1673924 1673924 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton - Clinton Elementary   Regular School No Elementary PK 04 2021   grade_4 92 3 46 0   1     0   7   76 73 *                     149.0 92 3 46 0   1     0   7   76 73                 149
1674178 1674178 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Easthampton - Center School   Regular School No Elementary KG 04 2021   grade_4 32 0 2 1   0     0   4   24 15 *                     39.0 32 0 2 1   0     0   4   24 15                 39
1674184 1674184 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Easthampton - Maple   Regular School No Elementary PK 04 2021   grade_4 28 0 2 0   1     0   4   20 15 *                     35.0 28 0 2 0   1     0   4   20 15                 35
1674189 1674189 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton - Neil A Pepin   Regular School No Elementary KG 04 2021   grade_4 29 0 8 0   0     0   2   17 22 *                     39.0 29 0 8 0   0     0   2   17 22                 39
1674452 1674452 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_4 32 1 3 2   0     0   2   22 18 *                     40.0 32 1 3 2   0     0   2   22 18                 40
1674458 1674458 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_4 33 8 4 1   0     0   5   25 26 *                     51.0 33 8 4 1   0     0   5   25 26                 51
1674463 1674463 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_4 55 2 8 2   0     0   12   45 34 *                     79.0 55 2 8 2   0     0   12   45 34                 79
1674468 1674468 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_4 51 1 2 0   2     0   2   34 24 *                     58.0 51 1 2 0   2     0   2   34 24                 58
1674483 1674483 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_4 36 1 69 0   3     0   14   71 52 *                     123.0 36 1 69 0   3     0   14   71 52                 123
1674489 1674489 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg - Reingold Elementary   Regular School No Elementary PK 04 2021   grade_4 36 5 71 0   5     0   12   76 53 *                     129.0 36 5 71 0   5     0   12   76 53                 129
1674499 1674499 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg - South Street Elementary   Regular School No Elementary PK 04 2021   grade_4 23 7 75 0   5     0   11   62 59 *                     121.0 23 7 75 0   5     0   11   62 59                 121
1674538 1674538 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Foxborough - Mabelle M Burrell   Regular School No Elementary PK 04 2021   grade_4 35 0 2 0   3     0   3   23 20 *                     43.0 35 0 2 0   3     0   3   23 20                 43
1674543 1674543 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Foxborough - Vincent M Igo Elementary   Regular School No Elementary KG 04 2021   grade_4 59 6 8 0   8     0   4   41 44 *                     85.0 59 6 8 0   8     0   4   41 44                 85
1674548 1674548 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Foxborough - Charles Taylor Elementary   Regular School No Elementary KG 04 2021   grade_4 49 4 2 0   0     1   3   30 29 *                     59.0 49 4 2 0   0     1   3   30 29                 59
1674679 1674679 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner - Elm Street School   Regular School No Elementary 02 04 2021   grade_4 93 1 33 0   3     0   10   63 77 *                     140.0 93 1 33 0   3     0   10   63 77                 140
1674805 1674805 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Greenfield - Federal Street School   Regular School No Elementary KG 04 2021   grade_4 39 2 9 0   0     0   2   26 26 *                     52.0 39 2 9 0   0     0   2   26 26                 52
1674810 1674810 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield - Discovery School at Four Corners   Regular School No Elementary KG 04 2021   grade_4 40 1 5 0   0     0   0   28 18 *                     46.0 40 1 5 0   0     0   0   28 18                 46
1674815 1674815 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Greenfield - Newton School   Regular School No Elementary KG 04 2021   grade_4 22 4 13 0   0     0   1   21 19 *                     40.0 22 4 13 0   0     0   1   21 19                 40
1674858 1674858 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover - Center Elementary   Regular School No Elementary 02 04 2021   grade_4 198 1 5 0   3     0   2   111 98 *                     209.0 198 1 5 0   3     0   2   111 98                 209
1674900 1674900 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Haverhill - Bradford Elementary   Regular School No Elementary KG 04 2021   grade_4 45 4 43 0   0     0   2   47 47 *                     94.0 45 4 43 0   0     0   2   47 47                 94
1674905 1674905 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Haverhill - Golden Hill   Regular School No Elementary KG 04 2021   grade_4 47 5 61 0   4     0   4   64 57 *                     121.0 47 5 61 0   4     0   4   64 57                 121
1674929 1674929 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Haverhill - Pentucket Lake Elementary   Regular School No Elementary KG 04 2021   grade_4 57 9 67 2   1     0   4   64 76 *                     140.0 57 9 67 2   1     0   4   64 76                 140
1675057 1675057 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke - Morgan Full Service Community School   Regular School No Elementary PK 04 2021   grade_4 2 0 40 0   0     0   0   15 27 *                     42.0 2 0 40 0   0     0   0   15 27                 42
1675144 1675144 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Hudson - Mulready Elementary   Regular School No Elementary PK 04 2021   grade_4 39 0 8 0   0     0   3   19 31 *                     50.0 39 0 8 0   0     0   3   19 31                 50
1675149 1675149 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Hudson - Forest Avenue Elementary   Regular School No Elementary KG 04 2021   grade_4 46 1 15 0   2     0   4   36 32 *                     68.0 46 1 15 0   2     0   4   36 32                 68
1675155 1675155 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 Hudson - C A Farley   Regular School No Elementary PK 04 2021   grade_4 61 0 16 0   1     0   1   36 43 *                     79.0 61 0 16 0   1     0   1   36 43                 79
1675219 1675219 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence - Community Day Arlington   Regular School No Elementary KG 04 2021   grade_4 1 2 127 0   0     0   1   63 68 *                     131.0 1 2 127 0   0     0   1   63 68                 131
1675236 1675236 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence - Robert Frost   Regular School No Elementary KG 04 2021   grade_4 9 6 106 0   1     0   0   52 70 *                     122.0 9 6 106 0   1     0   0   52 70                 122
1675244 1675244 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_4 1 1 117 0   1     0   1   60 61 *                     121.0 1 1 117 0   1     0   1   60 61                 121
1675270 1675270 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence - Edward F. Parthum   Regular School No Elementary KG 04 2021   grade_4 9 5 114 0   0     0   0   67 61 *                     128.0 9 5 114 0   0     0   0   67 61                 128
1675335 1675335 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester - Leicester Elementary   Regular School No Elementary KG 04 2021   grade_4 73 5 9 0   3     0   2   50 42 *                     92.0 73 5 9 0   3     0   2   50 42                 92
1675526 1675526 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Lowell - Dr Gertrude Bailey   Regular School No Elementary PK 04 2021   grade_4 20 3 31 0   32     0   4   44 46 *                     90.0 20 3 31 0   32     0   4   44 46                 90
1675541 1675541 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Lowell - Joseph McAvinnue   Regular School No Elementary PK 04 2021   grade_4 24 5 40 0   13     0   4   43 43 *                     86.0 24 5 40 0   13     0   4   43 43                 86
1675547 1675547 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Lowell - Greenhalge   Regular School No Elementary PK 04 2021   grade_4 27 6 45 0   7     0   3   41 47 *                     88.0 27 6 45 0   7     0   3   41 47                 88
1675563 1675563 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Lowell - Abraham Lincoln   Regular School No Elementary PK 04 2021   grade_4 8 2 28 0   50     0   2   47 43 *                     90.0 8 2 28 0   50     0   2   47 43                 90
1675568 1675568 MA Middlesex   school 2507020 160   Lowell 250702000068 1600027 Lowell - Moody Elementary   Regular School No Elementary KG 04 2021   grade_4 14 2 17 0   9     0   1   18 25 *                     43.0 14 2 17 0   9     0   1   18 25                 43
1675574 1675574 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Lowell - Charles W Morey   Regular School No Elementary PK 04 2021   grade_4 17 3 7 0   55     0   6   45 43 *                     88.0 17 3 7 0   55     0   6   45 43                 88
1675580 1675580 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Lowell - Pawtucketville Memorial   Regular School No Elementary PK 04 2021   grade_4 31 9 23 0   21     0   7   49 42 *                     91.0 31 9 23 0   21     0   7   49 42                 91
1675586 1675586 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Lowell - Peter W Reilly   Regular School No Elementary PK 04 2021   grade_4 40 2 34 0   9     1   3   39 50 *                     89.0 40 2 34 0   9     1   3   39 50                 89
1675592 1675592 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 Lowell - John J Shaughnessy   Regular School No Elementary PK 04 2021   grade_4 19 4 43 0   21     0   5   50 42 *                     92.0 19 4 43 0   21     0   5   50 42                 92
1675598 1675598 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Lowell - Washington   Regular School No Elementary PK 04 2021   grade_4 11 1 10 0   18     0   6   29 17 *                     46.0 11 1 10 0   18     0   6   29 17                 46
1675604 1675604 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 Lowell - S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2021   grade_4 24 7 47 0   11     0   2   38 53 *                     91.0 24 7 47 0   11     0   2   38 53                 91
1675610 1675610 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Lowell - Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2021   grade_4 10 4 32 0   38     0   3   43 44 *                     87.0 10 4 32 0   38     0   3   43 44                 87
1675862 1675862 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Lynnfield - Huckleberry Hill   Regular School No Elementary KG 04 2021   grade_4 65 2 8 0   10     0   3   43 45 *                     88.0 65 2 8 0   10     0   3   43 45                 88
1675867 1675867 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Lynnfield - Summer Street   Regular School No Elementary KG 04 2021   grade_4 59 1 3 0   4     0   2   37 32 *                     69.0 59 1 3 0   4     0   2   37 32                 69
1676138 1676138 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Medway - Burke/Memorial Elementary School   Regular School No Elementary 02 04 2021   grade_4 126 5 11 0   4     0   3   69 80 *                     149.0 126 5 11 0   4     0   3   69 80                 149
1676380 1676380 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Natick - Bennett-Hemenway   Regular School No Elementary KG 04 2021   grade_4 97 1 3 0   10     0   6   54 63 *                     117.0 97 1 3 0   10     0   6   54 63                 117
1676385 1676385 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Natick - Brown   Regular School No Elementary KG 04 2021   grade_4 64 0 12 0   22     0   5   53 50 *                     103.0 64 0 12 0   22     0   5   53 50                 103
1676390 1676390 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Natick - Johnson   Regular School No Elementary KG 04 2021   grade_4 34 0 3 0   2     0   3   26 16 *                     42.0 34 0 3 0   2     0   3   26 16                 42
1676395 1676395 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Natick - Lilja Elementary   Regular School No Elementary KG 04 2021   grade_4 44 2 8 0   6     0   4   31 33 *                     64.0 44 2 8 0   6     0   4   31 33                 64
1676400 1676400 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Natick - Memorial   Regular School No Elementary KG 04 2021   grade_4 76 1 3 0   4     0   4   52 36 *                     88.0 76 1 3 0   4     0   4   52 36                 88
1676903 1676903 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 Northbridge - W Edward Balmer   Regular School No Elementary 02 04 2021   grade_4 123 0 11 1   4     0   9   74 74 *                     148.0 123 0 11 1   4     0   9   74 74                 148
1677058 1677058 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford - Clara Barton   Regular School No Elementary 02 04 2021   grade_4 116 6 12 0   0     0   7   76 65 *                     141.0 116 6 12 0   0     0   7   76 65                 141
1677365 1677365 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_4 29 15 23 1   28     1   5   53 49 *                     102.0 29 15 23 1   28     1   5   53 49                 102
1677376 1677376 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   grade_4 32 19 15 0   34     0   1   44 57 *                     101.0 32 19 15 0   34     0   1   44 57                 101
1677594 1677594 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Rockland - Memorial Park   Regular School No Elementary KG 04 2021   grade_4 37 4 14 0   0     0   3   35 23 *                     58.0 37 4 14 0   0     0   3   35 23                 58
1677599 1677599 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 Rockland - R Stewart Esten   Regular School No Elementary KG 04 2021   grade_4 51 6 8 0   1     0   3   34 35 *                     69.0 51 6 8 0   1     0   3   34 35                 69
1677604 1677604 MA Plymouth   school 2510170 251   Rockland 251017001708 2510060 Rockland - Jefferson Elementary School   Regular School No Elementary KG 04 2021   grade_4 41 1 12 0   1     0   0   25 30 *                     55.0 41 1 12 0   1     0   0   25 30                 55
1677836 1677836 MA Worcester   school 2510770 271   Shrewsbury 251077001713 2710015 Shrewsbury - Calvin Coolidge   Regular School No Elementary KG 04 2021   grade_4 45 5 19 1   39     0   11   68 52 *                     120.0 45 5 19 1   39     0   11   68 52                 120
1677840 1677840 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_4 66 5 19 1   115     0   7   119 94 *                     213.0 66 5 19 1   115     0   7   119 94                 213
1677845 1677845 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Shrewsbury - Walter J Paton   Regular School No Elementary KG 04 2021   grade_4 44 3 4 0   18     0   4   34 39 *                     73.0 44 3 4 0   18     0   4   34 39                 73
1677852 1677852 MA Worcester   school 2510770 271   Shrewsbury 251077001718 2710035 Shrewsbury - Spring Street   Regular School No Elementary KG 04 2021   grade_4 48 0 8 1   20     0   1   40 38 *                     78.0 48 0 8 1   20     0   1   40 38                 78
1678017 1678017 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 South Hadley - Mosier   Regular School No Elementary 02 04 2021   grade_4 113 2 20 0   2     0   6   67 76 *                     143.0 113 2 20 0   2     0   6   67 76                 143
1678347 1678347 MA Middlesex   school 2511220 284   Stoneham 251122001851 2840005 Stoneham - Colonial Park   Regular School No Elementary PK 04 2021   grade_4 35 0 3 0   4     0   3   24 21 *                     45.0 35 0 3 0   4     0   3   24 21                 45

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