enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1124814 1124814 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1124922 1124922 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_2 * * * *   *     *   *   2 3                       *                         2 3                  
1125188 1125188 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125262 1125262 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125317 1125317 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_2 * * * *   *     *   *   2 1                       *                         2 1                  
1125422 1125422 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_2 * * * *   *     *   *   4 1                       *                         4 1                  
1126247 1126247 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126349 1126349 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_2 * * * *   *     *   *   1 1                       *                         1 1                  
1122619 1122619 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2017   grade_2 0 23 24 0   0     1   2   25 25                       50 0 23 24 0   0     1   2   25 25                 50
1122655 1122655 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2017   grade_2 0 77 14 1   1     1   3   50 47                       97 0 77 14 1   1     1   3   50 47                 97
1122718 1122718 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2017   grade_2 0 18 13 0   8     0   1   21 19                       40 0 18 13 0   8     0   1   21 19                 40
1122852 1122852 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2017   grade_2 0 23 22 0   1     1   2   22 27                       49 0 23 22 0   1     1   2   22 27                 49
1123148 1123148 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2017   grade_2 0 16 39 0   7     0   2   31 33                       64 0 16 39 0   7     0   2   31 33                 64
1123186 1123186 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_2 0 47 20 0   2     0   4   40 33                       73 0 47 20 0   2     0   4   40 33                 73
1123216 1123216 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_2 0 29 31 0   0     0   3   31 32                       63 0 29 31 0   0     0   3   31 32                 63
1123445 1123445 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_2 0 5 3 0   0     0   1   7 2                       9 0 5 3 0   0     0   1   7 2                 9
1129126 1129126 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary KG 05 2017   grade_2 0 14 46 0   0     0   0   33 27                       60 0 14 46 0   0     0   0   33 27                 60
1129229 1129229 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No Elementary KG 05 2017   grade_2 0 11 31 0   3     0   0   16 29                       45 0 11 31 0   3     0   0   16 29                 45
1131096 1131096 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_2 0 32 11 0   0     0   1   17 27                       44 0 32 11 0   0     0   1   17 27                 44
1131160 1131160 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_2 0 23 14 0   0     0   3   21 19                       40 0 23 14 0   0     0   3   21 19                 40
1131176 1131176 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_2 0 38 8 1   0     0   0   24 23                       47 0 38 8 1   0     0   0   24 23                 47
1131190 1131190 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   grade_2 0 1 40 0   1     0   0   21 21                       42 0 1 40 0   1     0   0   21 21                 42
1131267 1131267 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_2 0 19 1 0   0     0   1   11 10                       21 0 19 1 0   0     0   1   11 10                 21
1131293 1131293 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   grade_2 0 0 47 0   0     0   0   28 19                       47 0 0 47 0   0     0   0   28 19                 47
1131401 1131401 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_2 0 1 83 0   0     0   0   45 39                       84 0 1 83 0   0     0   0   45 39                 84
1131437 1131437 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2017   grade_2 0 57 18 0   0     0   1   46 30                       76 0 57 18 0   0     0   1   46 30                 76
1122555 1122555 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 02 2017   grade_2 1 34 11 1   1     0   5   29 24                       53 1 34 11 1   1     0   5   29 24                 53
1122578 1122578 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2017   grade_2 1 17 16 0   0     0   1   22 13                       35 1 17 16 0   0     0   1   22 13                 35
1122780 1122780 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2017   grade_2 1 0 39 0   1     0   1   20 22                       42 1 0 39 0   1     0   1   20 22                 42
1122808 1122808 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2017   grade_2 1 24 12 0   1     0   4   24 18                       42 1 24 12 0   1     0   4   24 18                 42
1122978 1122978 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   grade_2 1 10 8 0   1     0   2   9 13                       22 1 10 8 0   1     0   2   9 13                 22
1123039 1123039 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2017   grade_2 1 14 35 0   7     0   2   25 34                       59 1 14 35 0   7     0   2   25 34                 59
1123087 1123087 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_2 1 10 42 0   0     1   0   26 28                       54 1 10 42 0   0     1   0   26 28                 54
1123133 1123133 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_2 1 5 0 0   0     0   0   4 2                       6 1 5 0 0   0     0   0   4 2                 6
1123195 1123195 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_2 1 31 20 1   2     0   1   29 27                       56 1 31 20 1   2     0   1   29 27                 56
1123206 1123206 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_2 1 32 11 1   0     0   1   16 30                       46 1 32 11 1   0     0   1   16 30                 46
1125558 1125558 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_2 1 2 38 0   1     0   0   26 16                       42 1 2 38 0   1     0   0   26 16                 42
1125771 1125771 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   grade_2 1 0 118 0   0     0   0   57 62                       119 1 0 118 0   0     0   0   57 62                 119
1125840 1125840 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_2 1 0 75 0   0     0   0   45 31                       76 1 0 75 0   0     0   0   45 31                 76
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1129089 1129089 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary KG 05 2017   grade_2 1 1 4 0   0     0   0   5 1                       6 1 1 4 0   0     0   0   5 1                 6
1129119 1129119 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2017   grade_2 1 15 76 0   0     0   0   46 46                       92 1 15 76 0   0     0   0   46 46                 92
1129134 1129134 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No Elementary PK 05 2017   grade_2 1 9 37 0   0     0   0   26 21                       47 1 9 37 0   0     0   0   26 21                 47
1129148 1129148 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No Elementary KG 05 2017   grade_2 1 8 33 0   0     0   0   20 22                       42 1 8 33 0   0     0   0   20 22                 42
1131530 1131530 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_2 1 83 31 0   0     0   4   61 58                       119 1 83 31 0   0     0   4   61 58                 119
1131628 1131628 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence   Regular School Yes Elementary KG 05 2017   grade_2 1 25 31 0   0     0   2   31 28                       59 1 25 31 0   0     0   2   31 28                 59
1133139 1133139 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_2 1 42 24 0   2     0   1   36 34                       70 1 42 24 0   2     0   1   36 34                 70
1122840 1122840 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_2 10 16 15 0   0     0   2   24 19                       43 10 16 15 0   0     0   2   24 19                 43
1122909 1122909 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2017   grade_2 10 19 24 1   20     0   3   44 33                       77 10 19 24 1   20     0   3   44 33                 77
1124095 1124095 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_2 10 16 93 0   4     0   4   63 64                       127 10 16 93 0   4     0   4   63 64                 127
1125542 1125542 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 02 2017   grade_2 10 1 22 0   0     0   0   13 20                       33 10 1 22 0   0     0   0   13 20                 33
1129251 1129251 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2017   grade_2 10 10 33 0   5     1   2   29 32                       61 10 10 33 0   5     1   2   29 32                 61
1130770 1130770 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_2 10 9 22 1   6     0   1   29 20                       49 10 9 22 1   6     0   1   29 20                 49
1131451 1131451 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_2 10 0 1 0   0     0   5   8 8                       16 10 0 1 0   0     0   5   8 8                 16
1132608 1132608 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_2 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
1126332 1126332 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2017   grade_2 100 0 8 0   0     1   7   57 59                       116 100 0 8 0   0     1   7   57 59                 116
1128233 1128233 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 04 2017   grade_2 100 4 2 0   0     0   5   60 51                       111 100 4 2 0   0     0   5   60 51                 111
1124220 1124220 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   grade_2 102 5 37 0   1     0   2   75 72                       147 102 5 37 0   1     0   2   75 72                 147
1126970 1126970 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_2 103 3 2 1   0     0   1   44 66                       110 103 3 2 1   0     0   1   44 66                 110
1130059 1130059 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2017   grade_2 107 6 41 1   1     1   11   89 79                       168 107 6 41 1   1     1   11   89 79                 168
1130346 1130346 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   grade_2 108 0 3 1   1     0   7   58 62                       120 108 0 3 1   1     0   7   58 62                 120
1122592 1122592 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_2 11 4 9 0   0     0   0   11 13                       24 11 4 9 0   0     0   0   11 13                 24
1122663 1122663 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_2 11 0 41 0   1     0   0   27 26                       53 11 0 41 0   1     0   0   27 26                 53
1123071 1123071 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2017   grade_2 11 2 40 0   0     0   0   27 26                       53 11 2 40 0   0     0   0   27 26                 53
1123175 1123175 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_2 11 13 36 1   19     0   5   44 41                       85 11 13 36 1   19     0   5   44 41                 85
1126375 1126375 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_2 11 10 35 0   7     0   4   38 29                       67 11 10 35 0   7     0   4   38 29                 67
1128333 1128333 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No Elementary KG 05 2017   grade_2 11 2 2 0   42     1   1   36 23                       59 11 2 2 0   42     1   1   36 23                 59
1129000 1129000 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_2 11 6 28 0   2     0   2   28 21                       49 11 6 28 0   2     0   2   28 21                 49
1129222 1129222 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2017   grade_2 11 18 73 0   2     0   4   56 52                       108 11 18 73 0   2     0   4   56 52                 108
1130744 1130744 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_2 11 0 8 0   2     0   1   11 11                       22 11 0 8 0   2     0   1   11 11                 22
1130787 1130787 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_2 11 2 47 0   0     0   2   27 35                       62 11 2 47 0   0     0   2   27 35                 62
1130839 1130839 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2017   grade_2 11 8 30 1   4     0   3   35 22                       57 11 8 30 1   4     0   3   35 22                 57
1131728 1131728 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_2 11 2 1 0   30     0   1   24 21                       45 11 2 1 0   30     0   1   24 21                 45
1122316 1122316 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_2 110 3 4 1   0     0   4   58 64                       122 110 3 4 1   0     0   4   58 64                 122
1124242 1124242 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2017   grade_2 110 5 1 0   5     0   6   64 63                       127 110 5 1 0   5     0   6   64 63                 127
1127003 1127003 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2017   grade_2 110 6 45 2   1     0   8   89 83                       172 110 6 45 2   1     0   8   89 83                 172
1127057 1127057 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary PK 05 2017   grade_2 110 1 1 0   5     0   3   64 56                       120 110 1 1 0   5     0   3   64 56                 120
1132046 1132046 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2017   grade_2 110 3 13 0   0     0   3   81 48                       129 110 3 13 0   0     0   3   81 48                 129
1127941 1127941 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2017   grade_2 111 4 10 0   0     0   8   66 67                       133 111 4 10 0   0     0   8   66 67                 133
1125208 1125208 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_2 112 0 8 0   9     0   6   68 67                       135 112 0 8 0   9     0   6   68 67                 135
1126095 1126095 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2017   grade_2 113 2 3 1   11     0   1   74 57                       131 113 2 3 1   11     0   1   74 57                 131
1124021 1124021 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   grade_2 114 4 1 0   0     0   0   48 71                       119 114 4 1 0   0     0   0   48 71                 119
1125331 1125331 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2017   grade_2 114 0 1 0   2     0   2   60 59                       119 114 0 1 0   2     0   2   60 59                 119
1127023 1127023 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2017   grade_2 115 7 6 0   6     0   9   75 68                       143 115 7 6 0   6     0   9   75 68                 143
1129073 1129073 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2017   grade_2 115 2 25 1   2     0   3   74 74                       148 115 2 25 1   2     0   3   74 74                 148
1131081 1131081 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   grade_2 115 0 4 1   4     0   5   62 67                       129 115 0 4 1   4     0   5   62 67                 129
1132245 1132245 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2017   grade_2 118 2 11 0   6     0   7   75 69                       144 118 2 11 0   6     0   7   75 69                 144
1122860 1122860 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   grade_2 12 15 10 0   3     0   5   27 18                       45 12 15 10 0   3     0   5   27 18                 45
1122959 1122959 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_2 12 4 2 0   3     0   1   11 11                       22 12 4 2 0   3     0   1   11 11                 22
1122967 1122967 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_2 12 16 22 1   32     0   4   42 45                       87 12 16 22 1   32     0   4   42 45                 87
1123047 1123047 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2017   grade_2 12 8 14 0   5     0   1   23 17                       40 12 8 14 0   5     0   1   23 17                 40
1123593 1123593 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_2 12 50 79 1   0     0   2   75 69                       144 12 50 79 1   0     0   2   75 69                 144
1123650 1123650 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2017   grade_2 12 117 13 0   0     0   7   75 74                       149 12 117 13 0   0     0   7   75 74                 149
1123662 1123662 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_2 12 62 17 0   1     2   9   57 46                       103 12 62 17 0   1     2   9   57 46                 103
1125835 1125835 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2017   grade_2 12 2 112 0   2     0   0   59 69                       128 12 2 112 0   2     0   0   59 69                 128
1127285 1127285 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No Elementary PK 05 2017   grade_2 12 6 32 1   0     0   2   27 26                       53 12 6 32 1   0     0   2   27 26                 53
1127292 1127292 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary KG 05 2017   grade_2 12 7 32 0   0     0   2   26 27                       53 12 7 32 0   0     0   2   26 27                 53
1129141 1129141 MA Hampden   school 2511130 281   Springfield 251113001799 2810035 Daniel B Brunton   Regular School No Elementary KG 05 2017   grade_2 12 21 45 0   1     1   3   45 38                       83 12 21 45 0   1     1   3   45 38                 83
1129280 1129280 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Sumner Avenue   Regular School No Elementary PK 05 2017   grade_2 12 19 52 0   2     0   1   48 38                       86 12 19 52 0   2     0   1   48 38                 86
1129566 1129566 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2017   grade_2 12 2 4 0   1     0   3   9 13                       22 12 2 4 0   1     0   3   9 13                 22

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