Data source: Big Local News · About: Big Local

3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by male

View and edit SQL

year

grade

  • pre_kindergarten · 3,569
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
2040855 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   pre_kindergarten 4 3 11 0   3     0   0   10 11                       21.0 4 3 11 0   3     0   0   10 11                 21
2042200 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 19 2 8 0   0     0   2   10 21                       31.0 19 2 8 0   0     0   2   10 21                 31
2043841 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No Elementary PK 05 2019   pre_kindergarten 25 0 1 0   0     0   0   10 16                       26.0 25 0 1 0   0     0   0   10 16                 26
2043926 MA Middlesex   school 2507560 176   Medford 250756002057 1760140 Christopher Columbus   Regular School No Elementary PK 05 2019   pre_kindergarten 5 4 0 1   1     0   1   10 2                       12.0 5 4 0 1   1     0   1   10 2                 12
2044355 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2019   pre_kindergarten 12 4 9 0   1     0   2   10 18                       28.0 12 4 9 0   1     0   2   10 18                 28
2045600 MA Bristol   school 2510590 265   Seekonk 251059001695 2650007 George R Martin   Regular School No Elementary PK 05 2019   pre_kindergarten 23 0 0 0   0     0   0   10 13                       23.0 23 0 0 0   0     0   0   10 13                 23
2045607 MA Bristol   school 2510590 265   Seekonk 251059001696 2650015 Mildred Aitken School   Regular School No Elementary PK 05 2019   pre_kindergarten 18 0 2 0   0     0   1   10 11                       21.0 18 0 2 0   0     0   1   10 11                 21
2045761 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2019   pre_kindergarten 12 3 1 0   0     0   2   10 8                       18.0 12 3 1 0   0     0   2   10 8                 18
2046268 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2019   pre_kindergarten 26 0 0 0   0     0   0   10 16                       26.0 26 0 0 0   0     0   0   10 16                 26
2046737 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 13 0 0 0   0     0   1   10 4                       14.0 13 0 0 0   0     0   1   10 4                 14
2047102 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 17 0 2 0   1     0   3   10 13                       23.0 17 0 2 0   1     0   3   10 13                 23
2047265 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2019   pre_kindergarten 6 4 1 0   2     0   0   10 3                       13.0 6 4 1 0   2     0   0   10 3                 13
2047490 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   pre_kindergarten 13 0 1 2   0     0   1   10 7                       17.0 13 0 1 2   0     0   1   10 7                 17
2048542 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2019   pre_kindergarten 27 0 1 0   0     0   1   10 19                       29.0 27 0 1 0   0     0   1   10 19                 29
2048612 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten 16 2 2 0   1     0   0   10 11                       21.0 16 2 2 0   1     0   0   10 11                 21
2229849 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston: Phineas Bates   Regular School No Elementary PK 05 2018   pre_kindergarten 6 5 8 0   0     0   1   10 10                       20.0 6 5 8 0   0     0   1   10 10                 20
2231044 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton: Clinton Senior High   Regular School No High 09 12 2018   pre_kindergarten 12 1 4 0   0     0   1   10 8                       18.0 12 1 4 0   0     0   1   10 8                 18
2231246 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Dover: Chickering   Regular School No Elementary PK 05 2018   pre_kindergarten 15 0 2 0   4     0   2   10 13                       23.0 15 0 2 0   4     0   2   10 13                 23
2231507 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 Fairhaven: East Fairhaven   Regular School No Elementary PK 05 2018   pre_kindergarten 19 0 2 0   0     0   0   10 11                       21.0 19 0 2 0   0     0   0   10 11                 21
2232062 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 Granby: West Street   Regular School No Elementary PK 03 2018   pre_kindergarten 21 0 5 0   0     0   4   10 20                       30.0 21 0 5 0   0     0   4   10 20                 30
2234944 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Pittsfield: Morningside Community School   Regular School No Elementary PK 05 2018   pre_kindergarten 10 2 4 0   0     0   2   10 8                       18.0 10 2 4 0   0     0   2   10 8                 18
2235093 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   pre_kindergarten 7 9 1 0   0     0   1   10 8                       18.0 7 9 1 0   0     0   1   10 8                 18
2235418 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport: Rockport Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 16 0 0 0   0     0   0   10 6                       16.0 16 0 0 0   0     0   0   10 6                 16
2236825 MA Middlesex   school 2512180 314   Watertown 251218002002 3140025 Watertown: James Russell Lowell   Regular School No Elementary PK 05 2018   pre_kindergarten 13 0 1 0   1     0   3   10 8                       18.0 13 0 1 0   1     0   3   10 8                 18
2237126 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton: Westhampton Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten 15 0 0 0   0     0   0   10 5                       15.0 15 0 0 0   0     0   0   10 5                 15
2237345 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 13 0 0 0   1     0   2   10 6                       16.0 13 0 0 0   1     0   2   10 6                 16
2239184 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Monomoy Regional School District: Chatham Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten 14 2 3 0   0     0   1   10 10                       20.0 14 2 3 0   0     0   1   10 10                 20
2239520 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 Southern Berkshire: New Marlborough Central   Regular School No Elementary PK 04 2018   pre_kindergarten 14 0 0 0   0     0   0   10 4                       14.0 14 0 0 0   0     0   0   10 4                 14
1368727 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 78 15 60 0   17     1   4   100 75 *                     175.0 78 15 60 0   17     1   4   100 75                 175
937874 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 62 15 7 0   55     0   9   101 47                       148 62 15 7 0   55     0   9   101 47                 148
1373171 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten 108 7 9 0   9     0   18   101 50 *                     151.0 108 7 9 0   9     0   18   101 50                 151
742670 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Fort Meadow Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 129 4 29 0   10     0   4   103 73                       176 129 4 29 0   10     0   4   103 73                 176
1367027 MA Middlesex   school 2504770 93   Everett 250477002900 930001 Webster Extension   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 40 37 108 0   23     0   3   103 108 *                     211.0 40 37 108 0   23     0   3   103 108                 211
1371308 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2020   pre_kindergarten 133 8 10 0   15     1   6   103 70 *                     173.0 133 8 10 0   15     1   6   103 70                 173
738592 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No 1 PK PK 2015   pre_kindergarten 110 4 55 1   3     0   7   104 76                       180 110 4 55 1   3     0   7   104 76                 180
1366536 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 95 8 15 1   39     0   8   104 62 *                     166.0 95 8 15 1   39     0   8   104 62                 166
735683 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 154 2 7 0   2     0   0   105 60                       165 154 2 7 0   2     0   0   105 60                 165
1364999 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 132 8 31 0   8     0   5   105 79 *                     184.0 132 8 31 0   8     0   5   105 79                 184
2045848 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Early Childhood Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 15 26 103 2   4     0   5   105 50                       155.0 15 26 103 2   4     0   5   105 50                 155
2046984 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Johnson Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 136 10 12 0   23     0   13   105 89                       194.0 136 10 12 0   23     0   13   105 89                 194
2236529 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 Tewksbury: L F Dewing   Regular School No Elementary PK 02 2018   pre_kindergarten 172 8 9 0   11     0   2   105 97                       202.0 172 8 9 0   11     0   2   105 97                 202
2040303 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   pre_kindergarten 130 15 10 0   19     0   8   106 76                       182.0 130 15 10 0   19     0   8   106 76                 182
736162 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2015   pre_kindergarten 126 7 7 0   17     0   2   107 52                       159 126 7 7 0   17     0   2   107 52                 159
939476 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Fort Meadow Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 139 1 30 0   4     0   4   107 71                       178 139 1 30 0   4     0   4   107 71                 178
2040026 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 133 9 19 0   7     0   11   107 72                       179.0 133 9 19 0   7     0   11   107 72                 179
2045174 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 15 11 3   88     1   8   107 70                       177.0 51 15 11 3   88     1   8   107 70                 177
2235103 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Quincy: Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 69 15 16 0   86     0   7   107 86                       193.0 69 15 16 0   86     0   7   107 86                 193
741744 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2015   pre_kindergarten 16 13 151 0   3     0   3   108 78                       186 16 13 151 0   3     0   3   108 78                 186
932751 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No 1 PK PK 2016   pre_kindergarten 133 2 20 0   12     0   16   108 75                       183 133 2 20 0   12     0   16   108 75                 183
1129094 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2017   pre_kindergarten 14 7 158 0   1     0   5   108 77                       185 14 7 158 0   1     0   5   108 77                 185
1369436 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 5 7 0   62     0   13   108 73 *                     181.0 94 5 7 0   62     0   13   108 73                 181
2233476 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 104 6 26 0   30     2   6   108 66                       174.0 104 6 26 0   30     2   6   108 66                 174
1370100 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 62 16 18 1   76     0   10   109 74 *                     183.0 62 16 18 1   76     0   10   109 74                 183
2041228 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 57 107 33 0   1     1   8   109 98                       207.0 57 107 33 0   1     1   8   109 98                 207
2237281 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Weymouth: Johnson Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 135 9 13 1   26     0   9   109 84                       193.0 135 9 13 1   26     0   9   109 84                 193
736301 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No 1 PK 05 2015   pre_kindergarten 3 7 4 0   4     0   0   11 7                       18 3 7 4 0   4     0   0   11 7                 18
737619 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   pre_kindergarten 16 1 9 0   0     0   1   11 16                       27 16 1 9 0   0     0   1   11 16                 27
737663 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   pre_kindergarten 13 0 0 0   0     0   1   11 3                       14 13 0 0 0   0     0   1   11 3                 14
737942 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 15 0 2 0   0     0   3   11 9                       20 15 0 2 0   0     0   3   11 9                 20
739027 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 15 0 2 0   0     0   1   11 7                       18 15 0 2 0   0     0   1   11 7                 18
739055 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   pre_kindergarten 15 1 2 0   1     0   2   11 10                       21 15 1 2 0   1     0   2   11 10                 21
739292 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No 1 PK 04 2015   pre_kindergarten 5 3 5 0   13     0   1   11 16                       27 5 3 5 0   13     0   1   11 16                 27
739491 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No 1 PK 05 2015   pre_kindergarten 2 1 8 0   1     0   3   11 4                       15 2 1 8 0   1     0   3   11 4                 15
740681 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   pre_kindergarten 18 0 0 0   1     0   0   11 8                       19 18 0 0 0   1     0   0   11 8                 19
740903 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   pre_kindergarten 15 1 1 0   0     0   1   11 7                       18 15 1 1 0   0     0   1   11 7                 18
741036 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   pre_kindergarten 13 1 3 0   0     0   2   11 8                       19 13 1 3 0   0     0   2   11 8                 19
741656 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2015   pre_kindergarten 11 2 4 0   0     0   1   11 7                       18 11 2 4 0   0     0   1   11 7                 18
743131 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   pre_kindergarten 3 3 11 0   4     0   1   11 11                       22 3 3 11 0   4     0   1   11 11                 22
744422 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2015   pre_kindergarten 19 0 4 0   0     0   2   11 14                       25 19 0 4 0   0     0   2   11 14                 25
933228 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No 1 PK 05 2016   pre_kindergarten 1 0 21 0   0     0   0   11 11                       22 1 0 21 0   0     0   0   11 11                 22
933444 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2016   pre_kindergarten 1 2 22 0   1     0   0   11 15                       26 1 2 22 0   1     0   0   11 15                 26
933463 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2016   pre_kindergarten 8 2 6 0   2     0   2   11 9                       20 8 2 6 0   2     0   2   11 9                 20
933491 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2016   pre_kindergarten 3 9 7 0   2     0   3   11 13                       24 3 9 7 0   2     0   3   11 13                 24
933576 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   pre_kindergarten 4 9 9 0   8     0   1   11 20                       31 4 9 9 0   8     0   1   11 20                 31
934201 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   pre_kindergarten 11 5 2 0   7     0   1   11 15                       26 11 5 2 0   7     0   1   11 15                 26
934988 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   pre_kindergarten 10 0 2 0   0     0   2   11 3                       14 10 0 2 0   0     0   2   11 3                 14
935876 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 19 0 1 0   0     0   0   11 9                       20 19 0 1 0   0     0   0   11 9                 20
937054 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2016   pre_kindergarten 8 5 7 0   0     0   1   11 10                       21 8 5 7 0   0     0   1   11 10                 21
937421 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No 1 PK 05 2016   pre_kindergarten 14 0 5 0   4     0   0   11 12                       23 14 0 5 0   4     0   0   11 12                 23
937647 MA Essex   school 2509360 229   Peabody 250936001506 2290027 William A Welch Sr   Regular School No 1 PK 05 2016   pre_kindergarten 23 0 4 0   0     0   0   11 16                       27 23 0 4 0   0     0   0   11 16                 27
937836 MA Plymouth   school 2509720 239   Plymouth 250972001548 2390047 West Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 18 1 2 0   0     0   0   11 10                       21 18 1 2 0   0     0   0   11 10                 21
938947 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 11 1 3 0   3     0   4   11 11                       22 11 1 3 0   3     0   4   11 11                 22
939955 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   pre_kindergarten 18 2 4 0   3     0   0   11 16                       27 18 2 4 0   3     0   0   11 16                 27
940969 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 18 1 0 1   0     0   0   11 9                       20 18 1 0 1   0     0   0   11 9                 20
941298 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Memorial School   Regular School No 1 PK 04 2016   pre_kindergarten 18 0 0 0   1     0   1   11 9                       20 18 0 0 0   1     0   1   11 9                 20
941612 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2016   pre_kindergarten 19 0 0 0   0     0   0   11 8                       19 19 0 0 0   0     0   0   11 8                 19
1122282 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2017   pre_kindergarten 12 1 3 0   1     0   0   11 6                       17 12 1 3 0   1     0   0   11 6                 17
1122590 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   pre_kindergarten 13 3 5 0   0     0   0   11 10                       21 13 3 5 0   0     0   0   11 10                 21
1122653 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2017   pre_kindergarten 0 17 2 1   1     0   0   11 10                       21 0 17 2 1   1     0   0   11 10                 21
1122716 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2017   pre_kindergarten 2 5 4 0   6     0   0   11 6                       17 2 5 4 0   6     0   0   11 6                 17
1122735 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   pre_kindergarten 11 8 4 0   0     0   1   11 13                       24 11 8 4 0   0     0   1   11 13                 24
1124755 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   pre_kindergarten 17 0 2 0   0     0   2   11 10                       21 17 0 2 0   0     0   2   11 10                 21
1124838 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   pre_kindergarten 12 3 2 0   0     0   2   11 8                       19 12 3 2 0   0     0   2   11 8                 19
1127777 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 23 0 0 0   0     0   0   11 12                       23 23 0 0 0   0     0   0   11 12                 23
1128122 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2017   pre_kindergarten 17 3 6 0   2     0   5   11 22                       33 17 3 6 0   2     0   5   11 22                 33
1130320 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2017   pre_kindergarten 14 1 3 0   2     0   1   11 10                       21 14 1 3 0   2     0   1   11 10                 21
1130889 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   pre_kindergarten 2 3 6 0   3     0   0   11 3                       14 2 3 6 0   3     0   0   11 3                 14
1131951 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary PK 05 2017   pre_kindergarten 20 0 0 0   1     0   1   11 11                       22 20 0 0 0   1     0   1   11 11                 22
1365058 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   pre_kindergarten 6 9 3 0   1     0   3   11 11 *                     22.0 6 9 3 0   1     0   3   11 11                 22
1365430 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2020   pre_kindergarten 15 2 6 0   0     0   3   11 15 *                     26.0 15 2 6 0   0     0   3   11 15                 26

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