enrollments

Data source: Big Local News · About: Big Local

519 rows where grade = "pre_kindergarten", state = "MA" and year = 2017 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 519 ✖

grade ✖

  • pre_kindergarten · 519 ✖
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
1124597 1124597 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten * * * *   *     *   *   3 2                       *                         3 2                  
1125186 1125186 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   pre_kindergarten * * * *   *     *   *   * *                       *                                              
1125260 1125260 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   pre_kindergarten * * * *   *     *   *   * *                       *                                              
1125315 1125315 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten * * * *   *     *   *   4 1                       *                         4 1                  
1128955 1128955 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2017   pre_kindergarten * * * *   *     *   *   1 3                       *                         1 3                  
1129739 1129739 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten * * * *   *     *   *   2 3                       *                         2 3                  
1132591 1132591 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten * * * *   *     *   *   1 3                       *                         1 3                  
1122576 1122576 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2017   pre_kindergarten 0 26 16 1   0     0   1   22 22                       44 0 26 16 1   0     0   1   22 22                 44
1122612 1122612 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten 0 34 15 0   2     0   0   29 22                       51 0 34 15 0   2     0   0   29 22                 51
1122653 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
1122830 1122830 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2017   pre_kindergarten 0 33 22 0   2     1   3   37 24                       61 0 33 22 0   2     1   3   37 24                 61
1122850 1122850 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2017   pre_kindergarten 0 16 12 1   2     0   2   21 12                       33 0 16 12 1   2     0   2   21 12                 33
1123085 1123085 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   pre_kindergarten 0 4 27 0   0     0   1   20 12                       32 0 4 27 0   0     0   1   20 12                 32
1123204 1123204 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   pre_kindergarten 0 28 12 2   0     0   2   24 20                       44 0 28 12 2   0     0   2   24 20                 44
1123214 1123214 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   pre_kindergarten 0 28 23 1   0     0   0   24 28                       52 0 28 23 1   0     0   0   24 28                 52
1130751 1130751 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 10 0   1     0   2   8 5                       13 0 0 10 0   1     0   2   8 5                 13
1131265 1131265 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   pre_kindergarten 0 18 2 0   0     0   0   9 11                       20 0 18 2 0   0     0   0   9 11                 20
1131467 1131467 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   pre_kindergarten 0 27 25 0   2     0   0   25 29                       54 0 27 25 0   2     0   0   25 29                 54
1122617 1122617 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2017   pre_kindergarten 1 8 18 0   0     0   1   18 10                       28 1 8 18 0   0     0   1   18 10                 28
1122678 1122678 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2017   pre_kindergarten 1 14 28 0   0     0   0   19 24                       43 1 14 28 0   0     0   0   19 24                 43
1122705 1122705 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   pre_kindergarten 1 0 18 0   0     0   0   9 10                       19 1 0 18 0   0     0   0   9 10                 19
1122762 1122762 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2017   pre_kindergarten 1 7 11 0   0     0   1   13 7                       20 1 7 11 0   0     0   1   13 7                 20
1122770 1122770 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2017   pre_kindergarten 1 15 5 0   2     0   1   9 15                       24 1 15 5 0   2     0   1   9 15                 24
1122838 1122838 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   pre_kindergarten 1 5 6 0   1     0   0   7 6                       13 1 5 6 0   1     0   0   7 6                 13
1122976 1122976 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   pre_kindergarten 1 14 5 0   0     0   0   10 10                       20 1 14 5 0   0     0   0   10 10                 20
1122995 1122995 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   pre_kindergarten 1 23 21 0   0     0   1   36 10                       46 1 23 21 0   0     0   1   36 10                 46
1123037 1123037 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2017   pre_kindergarten 1 8 22 0   2     0   2   21 14                       35 1 8 22 0   2     0   2   21 14                 35
1123077 1123077 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   pre_kindergarten 1 11 11 0   1     0   2   12 14                       26 1 11 11 0   1     0   2   12 14                 26
1123184 1123184 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   pre_kindergarten 1 35 17 0   0     0   3   34 22                       56 1 35 17 0   0     0   3   34 22                 56
1123443 1123443 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   pre_kindergarten 1 3 1 0   1     0   0   3 3                       6 1 3 1 0   1     0   0   3 3                 6
1125556 1125556 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   pre_kindergarten 1 1 36 0   0     0   0   21 17                       38 1 1 36 0   0     0   0   21 17                 38
1126396 1126396 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2017   pre_kindergarten 1 1 22 0   3     0   2   13 16                       29 1 1 22 0   3     0   2   13 16                 29
1130768 1130768 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   pre_kindergarten 1 4 17 0   4     0   0   14 12                       26 1 4 17 0   4     0   0   14 12                 26
1131158 1131158 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   pre_kindergarten 1 23 12 2   1     0   0   17 22                       39 1 23 12 2   1     0   0   17 22                 39
1131174 1131174 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   pre_kindergarten 1 18 1 0   1     0   2   13 10                       23 1 18 1 0   1     0   2   13 10                 23
1131291 1131291 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   pre_kindergarten 1 0 42 0   0     0   0   21 22                       43 1 0 42 0   0     0   0   21 22                 43
1131420 1131420 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2017   pre_kindergarten 1 12 15 0   10     0   2   20 20                       40 1 12 15 0   10     0   2   20 20                 40
1122915 1122915 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2017   pre_kindergarten 10 1 18 0   6     0   1   18 18                       36 10 1 18 0   6     0   1   18 18                 36
1123899 1123899 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   pre_kindergarten 10 7 5 0   5     0   3   14 16                       30 10 7 5 0   5     0   3   14 16                 30
1124920 1124920 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   pre_kindergarten 10 1 0 0   0     0   0   6 5                       11 10 1 0 0   0     0   0   6 5                 11
1125545 1125545 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten 10 0 8 0   1     0   1   13 7                       20 10 0 8 0   1     0   1   13 7                 20
1125797 1125797 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2017   pre_kindergarten 10 0 82 0   2     0   0   62 32                       94 10 0 82 0   2     0   0   62 32                 94
1125931 1125931 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   pre_kindergarten 10 0 1 0   0     0   1   6 6                       12 10 0 1 0   0     0   1   6 6                 12
1126796 1126796 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 10 2 2 0   6     0   2   9 13                       22 10 2 2 0   6     0   2   9 13                 22
1127088 1127088 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2017   pre_kindergarten 10 0 2 0   0     0   0   8 4                       12 10 0 2 0   0     0   0   8 4                 12
1128987 1128987 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   pre_kindergarten 10 1 4 0   0     0   3   8 10                       18 10 1 4 0   0     0   3   8 10                 18
1129278 1129278 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Sumner Avenue   Regular School No Elementary PK 05 2017   pre_kindergarten 10 8 47 0   3     0   3   39 32                       71 10 8 47 0   3     0   3   39 32                 71
1130785 1130785 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   pre_kindergarten 10 1 11 0   1     0   0   15 8                       23 10 1 11 0   1     0   0   15 8                 23
1131849 1131849 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten 10 1 1 0   1     0   1   8 6                       14 10 1 1 0   1     0   1   8 6                 14
1122546 1122546 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2017   pre_kindergarten 100 5 14 0   21     0   4   90 54                       144 100 5 14 0   21     0   4   90 54                 144
1128187 1128187 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 100 3 4 0   1     0   8   71 45                       116 100 3 4 0   1     0   8   71 45                 116
1124493 1124493 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2017   pre_kindergarten 103 1 4 0   0     0   5   51 62                       113 103 1 4 0   0     0   5   51 62                 113
1125245 1125245 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No Elementary PK PK 2017   pre_kindergarten 105 1 13 0   2     0   1   67 55                       122 105 1 13 0   2     0   1   67 55                 122
1128934 1128934 MA Middlesex   school 2510890 274   Somerville 251089002561 2740005 Capuano Early Childhood Center   Regular School No Elementary PK KG 2017   pre_kindergarten 105 14 78 0   25     0   9   142 89                       231 105 14 78 0   25     0   9   142 89                 231
1125037 1125037 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Elementary PK PK 2017   pre_kindergarten 106 2 7 0   6     8   2   82 49                       131 106 2 7 0   6     8   2   82 49                 131
1125121 1125121 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No Elementary PK PK 2017   pre_kindergarten 106 0 1 0   1     0   0   56 52                       108 106 0 1 0   1     0   0   56 52                 108
1126581 1126581 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 107 42 22 0   112     0   16   166 133                       299 107 42 22 0   112     0   16   166 133                 299
1127005 1127005 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Shining Star Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 107 0 24 0   3     0   2   87 49                       136 107 0 24 0   3     0   2   87 49                 136
1121977 1121977 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 108 7 19 0   13     0   4   87 64                       151 108 7 19 0   13     0   4   87 64                 151
1128888 1128888 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 109 5 22 4   83     0   9   122 110                       232 109 5 22 4   83     0   9   122 110                 232
1122735 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
1123053 1123053 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2017   pre_kindergarten 11 13 5 0   52     0   3   47 37                       84 11 13 5 0   52     0   3   47 37                 84
1124008 1124008 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   pre_kindergarten 11 0 1 0   0     0   2   8 6                       14 11 0 1 0   0     0   2   8 6                 14
1124429 1124429 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No Elementary PK 05 2017   pre_kindergarten 11 0 0 0   0     0   1   9 3                       12 11 0 0 0   0     0   1   9 3                 12
1125897 1125897 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 11 0 2 0   1     0   1   5 10                       15 11 0 2 0   1     0   1   5 10                 15
1126220 1126220 MA Middlesex   school 2507020 160   Lowell 250702001048 1600050 John J Shaughnessy   Regular School No Elementary PK 04 2017   pre_kindergarten 11 2 8 0   11     0   0   18 14                       32 11 2 8 0   11     0   0   18 14                 32
1126348 1126348 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   pre_kindergarten 11 8 38 1   5     0   3   39 27                       66 11 8 38 1   5     0   3   39 27                 66
1128272 1128272 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   pre_kindergarten 11 6 2 0   0     0   1   9 11                       20 11 6 2 0   0     0   1   9 11                 20
1128748 1128748 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 11 1 1 0   0     0   0   6 7                       13 11 1 1 0   0     0   0   6 7                 13
1130526 1130526 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   pre_kindergarten 11 0 0 0   0     0   0   8 3                       11 11 0 0 0   0     0   0   8 3                 11
1132292 1132292 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
1131899 1131899 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   pre_kindergarten 111 9 1 0   2     1   3   73 54                       127 111 9 1 0   2     1   3   73 54                 127
1129807 1129807 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No Elementary PK PK 2017   pre_kindergarten 113 2 4 0   5     2   3   66 63                       129 113 2 4 0   5     2   3   66 63                 129
1122282 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
1122743 1122743 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   pre_kindergarten 12 11 17 0   0     0   1   24 17                       41 12 11 17 0   0     0   1   24 17                 41
1123069 1123069 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2017   pre_kindergarten 12 2 31 0   1     0   0   29 17                       46 12 2 31 0   1     0   0   29 17                 46
1123165 1123165 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 12 8 14 0   6     0   3   25 18                       43 12 8 14 0   6     0   3   25 18                 43
1123891 1123891 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2017   pre_kindergarten 12 6 0 0   16     0   13   25 22                       47 12 6 0 0   16     0   13   25 22                 47
1124744 1124744 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   pre_kindergarten 12 0 7 0   0     0   1   14 6                       20 12 0 7 0   0     0   1   14 6                 20
1124838 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
1125583 1125583 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten 12 3 28 0   0     0   0   29 14                       43 12 3 28 0   0     0   0   29 14                 43
1125679 1125679 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2017   pre_kindergarten 12 0 1 0   0     0   0   4 9                       13 12 0 1 0   0     0   0   4 9                 13
1127237 1127237 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   pre_kindergarten 12 0 16 0   1     0   0   7 22                       29 12 0 16 0   1     0   0   7 22                 29
1127298 1127298 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2017   pre_kindergarten 12 2 29 0   1     0   1   27 18                       45 12 2 29 0   1     0   1   27 18                 45
1128548 1128548 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   pre_kindergarten 12 0 0 0   0     0   0   8 4                       12 12 0 0 0   0     0   0   8 4                 12
1128966 1128966 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   pre_kindergarten 12 0 3 0   2     0   0   4 13                       17 12 0 3 0   2     0   0   4 13                 17
1129760 1129760 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   pre_kindergarten 12 2 2 0   0     0   5   9 12                       21 12 2 2 0   0     0   5   9 12                 21
1130133 1130133 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 12 0 0 0   0     0   0   9 3                       12 12 0 0 0   0     0   0   9 3                 12
1130517 1130517 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
1130654 1130654 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop High School   Regular School No High 09 12 2017   pre_kindergarten 12 0 1 0   0     0   0   5 8                       13 12 0 1 0   0     0   0   5 8                 13
1130966 1130966 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   pre_kindergarten 12 4 7 0   4     0   0   14 13                       27 12 4 7 0   4     0   0   14 13                 27
1132393 1132393 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   pre_kindergarten 12 0 0 0   0     0   0   6 6                       12 12 0 0 0   0     0   0   6 6                 12
1130202 1130202 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Fort Meadow Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 120 0 39 0   12     0   4   99 76                       175 120 0 39 0   12     0   4   99 76                 175
1129713 1129713 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2017   pre_kindergarten 122 5 5 0   6     0   0   74 64                       138 122 5 5 0   6     0   0   74 64                 138
1132835 1132835 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 126 2 10 1   7     1   3   83 67                       150 126 2 10 1   7     1   3   83 67                 150
1122343 1122343 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   pre_kindergarten 13 5 0 0   11     0   1   21 9                       30 13 5 0 0   11     0   1   21 9                 30
1122590 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
1122814 1122814 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No Elementary PK 05 2017   pre_kindergarten 13 7 27 0   1     0   1   23 26                       49 13 7 27 0   1     0   1   23 26                 49
1122984 1122984 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   pre_kindergarten 13 1 1 0   0     0   1   9 7                       16 13 1 1 0   0     0   1   9 7                 16
1124579 1124579 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2017   pre_kindergarten 13 0 1 0   0     0   0   9 5                       14 13 0 1 0   0     0   0   9 5                 14

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