enrollments

Data source: Big Local News · About: Big Local

966 rows where grade = "grade_3", state = "MA" and year = 2017 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 966 ✖

grade ✖

  • grade_3 · 966 ✖
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
1122636 1122636 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 03 2017   grade_3 * * * *   *     *   *   4 1                       *                         4 1                  
1124655 1124655 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_3 * * * *   *     *   *   4 1                       *                         4 1                  
1124815 1124815 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_3 * * * *   *     *   *   3 *                       *                         3                    
1125189 1125189 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_3 * * * *   *     *   *   * *                       *                                              
1125263 1125263 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_3 * * * *   *     *   *   * *                       *                                              
1125318 1125318 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_3 * * * *   *     *   *   1 3                       *                         1 3                  
1126248 1126248 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_3 * * * *   *     *   *   1 *                       *                         1                    
1128616 1128616 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   grade_3 * * * *   *     *   *   2 2                       *                         2 2                  
1132404 1132404 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   grade_3 * * * *   *     *   *   1 1                       *                         1 1                  
1132609 1132609 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_3 * * * *   *     *   *   1 2                       *                         1 2                  
1122579 1122579 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2017   grade_3 0 17 13 1   2     0   0   19 14                       33 0 17 13 1   2     0   0   19 14                 33
1123088 1123088 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_3 0 9 37 0   0     0   0   23 23                       46 0 9 37 0   0     0   0   23 23                 46
1123129 1123129 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2017   grade_3 0 20 10 0   0     0   1   15 16                       31 0 20 10 0   0     0   1   15 16                 31
1123187 1123187 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_3 0 47 19 0   0     1   1   36 32                       68 0 47 19 0   0     1   1   36 32                 68
1125559 1125559 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_3 0 3 42 0   0     0   0   24 21                       45 0 3 42 0   0     0   0   24 21                 45
1125575 1125575 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_3 0 1 87 0   2     0   1   45 46                       91 0 1 87 0   2     0   1   45 46                 91
1131097 1131097 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_3 0 27 16 1   0     0   0   20 24                       44 0 27 16 1   0     0   0   20 24                 44
1131161 1131161 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_3 0 25 14 0   1     0   0   19 21                       40 0 25 14 0   1     0   0   19 21                 40
1131177 1131177 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_3 0 38 9 0   1     0   0   25 23                       48 0 38 9 0   1     0   0   25 23                 48
1131268 1131268 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_3 0 15 6 0   0     0   0   13 8                       21 0 15 6 0   0     0   0   13 8                 21
1131294 1131294 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_3 0 0 48 0   0     0   0   23 25                       48 0 0 48 0   0     0   0   23 25                 48
1131629 1131629 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_3 0 31 25 0   0     0   5   29 32                       61 0 31 25 0   0     0   5   29 32                 61
1122656 1122656 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2017   grade_3 1 73 17 1   1     0   2   51 44                       95 1 73 17 1   1     0   2   51 44                 95
1122719 1122719 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2017   grade_3 1 23 12 0   11     0   3   20 30                       50 1 23 12 0   11     0   3   20 30                 50
1122765 1122765 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2017   grade_3 1 18 10 0   2     0   1   13 19                       32 1 18 10 0   2     0   1   13 19                 32
1122809 1122809 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2017   grade_3 1 32 7 0   0     0   2   21 21                       42 1 32 7 0   0     0   2   21 21                 42
1122825 1122825 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2017   grade_3 1 11 43 0   0     0   2   28 29                       57 1 11 43 0   0     0   2   28 29                 57
1122853 1122853 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2017   grade_3 1 32 13 0   0     0   1   26 21                       47 1 32 13 0   0     0   1   26 21                 47
1122926 1122926 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No Elementary PK 05 2017   grade_3 1 82 8 0   0     0   2   39 54                       93 1 82 8 0   0     0   2   39 54                 93
1122942 1122942 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_3 1 22 34 0   0     0   2   34 25                       59 1 22 34 0   0     0   2   34 25                 59
1122979 1122979 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   grade_3 1 15 5 0   1     0   2   12 12                       24 1 15 5 0   1     0   2   12 12                 24
1123080 1123080 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   grade_3 1 17 17 0   1     0   1   20 17                       37 1 17 17 0   1     0   1   20 17                 37
1123149 1123149 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2017   grade_3 1 24 37 0   10     0   1   37 36                       73 1 24 37 0   10     0   1   37 36                 73
1123157 1123157 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_3 1 51 19 0   0     0   3   34 40                       74 1 51 19 0   0     0   3   34 40                 74
1125841 1125841 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_3 1 0 79 0   0     0   0   38 42                       80 1 0 79 0   0     0   0   38 42                 80
1125880 1125880 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_3 1 0 7 0   0     0   0   7 1                       8 1 0 7 0   0     0   0   7 1                 8
1126448 1126448 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_3 1 1 8 0   1     0   0   9 *                       11 1 1 8 0   1     0   0   9                   11
1129120 1129120 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2017   grade_3 1 18 74 0   0     0   0   51 42                       93 1 18 74 0   0     0   0   51 42                 93
1129127 1129127 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary KG 05 2017   grade_3 1 5 51 0   0     0   0   28 29                       57 1 5 51 0   0     0   0   28 29                 57
1129149 1129149 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No Elementary KG 05 2017   grade_3 1 6 45 0   0     0   0   27 25                       52 1 6 45 0   0     0   0   27 25                 52
1131191 1131191 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_3 1 1 36 0   0     0   0   24 14                       38 1 1 36 0   0     0   0   24 14                 38
1131402 1131402 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_3 1 0 83 0   0     0   0   48 36                       84 1 0 83 0   0     0   0   48 36                 84
1133140 1133140 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_3 1 53 39 0   1     0   3   53 44                       97 1 53 39 0   1     0   3   53 44                 97
1122746 1122746 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_3 10 18 16 0   0     0   0   18 26                       44 10 18 16 0   0     0   0   18 26                 44
1122869 1122869 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_3 10 2 29 0   0     0   1   25 17                       42 10 2 29 0   0     0   1   25 17                 42
1122987 1122987 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_3 10 4 6 0   0     0   0   11 9                       20 10 4 6 0   0     0   0   11 9                 20
1126420 1126420 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Hood   Regular School No Elementary KG 05 2017   grade_3 10 8 44 0   8     0   1   30 41                       71 10 8 44 0   8     0   1   30 41                 71
1127248 1127248 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2017   grade_3 10 2 12 0   1     0   2   17 10                       27 10 2 12 0   1     0   2   17 10                 27
1128639 1128639 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No Elementary KG 08 2017   grade_3 10 3 33 0   2     0   2   28 22                       50 10 3 33 0   2     0   2   28 22                 50
1129182 1129182 MA Hampden   school 2511130 281   Springfield 251113001562 2810068 Glickman Elementary   Regular School No Elementary KG 05 2017   grade_3 10 18 33 0   3     0   2   32 34                       66 10 18 33 0   3     0   2   32 34                 66
1129288 1129288 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2017   grade_3 10 15 21 0   0     0   0   25 21                       46 10 15 21 0   0     0   0   25 21                 46
1129311 1129311 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Washington   Regular School No Elementary PK 05 2017   grade_3 10 13 41 0   7     1   2   46 28                       74 10 13 41 0   7     1   2   46 28                 74
1129763 1129763 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_3 10 1 2 0   0     0   1   7 7                       14 10 1 2 0   0     0   1   7 7                 14
1130788 1130788 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_3 10 3 54 0   1     0   3   35 36                       71 10 3 54 0   1     0   3   35 36                 71
1130805 1130805 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_3 10 5 11 0   1     0   1   19 9                       28 10 5 11 0   1     0   1   19 9                 28
1132129 1132129 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2017   grade_3 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
1126965 1126965 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_3 100 2 4 0   0     0   15   54 67                       121 100 2 4 0   0     0   15   54 67                 121
1129074 1129074 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2017   grade_3 100 3 16 0   3     0   1   69 54                       123 100 3 16 0   3     0   1   69 54                 123
1130555 1130555 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2017   grade_3 101 0 10 0   6     0   5   67 55                       122 101 0 10 0   6     0   5   67 55                 122
1132523 1132523 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2017   grade_3 102 1 3 0   1     0   9   59 57                       116 102 1 3 0   1     0   9   59 57                 116
1125333 1125333 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No Elementary 03 04 2017   grade_3 103 0 2 0   1     0   0   52 54                       106 103 0 2 0   1     0   0   52 54                 106
1128234 1128234 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 04 2017   grade_3 103 2 8 1   0     0   5   61 58                       119 103 2 8 1   0     0   5   61 58                 119
1126097 1126097 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2017   grade_3 104 3 3 0   20     0   3   65 68                       133 104 3 3 0   20     0   3   65 68                 133
1129772 1129772 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2017   grade_3 104 7 10 0   12     0   5   70 68                       138 104 7 10 0   12     0   5   70 68                 138
1127024 1127024 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2017   grade_3 105 1 20 0   3     0   10   70 69                       139 105 1 20 0   3     0   10   70 69                 139
1132047 1132047 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2017   grade_3 105 5 10 0   1     0   6   57 70                       127 105 5 10 0   1     0   6   57 70                 127
1125383 1125383 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 05 2017   grade_3 106 8 35 1   2     0   1   73 80                       153 106 8 35 1   2     0   1   73 80                 153
1121969 1121969 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_3 107 0 0 0   0     0   0   62 45                       107 107 0 0 0   0     0   0   62 45                 107
1122434 1122434 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2017   grade_3 107 0 1 0   0     0   4   55 57                       112 107 0 1 0   0     0   4   55 57                 112
1129656 1129656 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2017   grade_3 107 4 5 0   1     0   4   67 54                       121 107 4 5 0   1     0   4   67 54                 121
1122593 1122593 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_3 11 12 8 0   1     0   0   17 15                       32 11 12 8 0   1     0   0   17 15                 32
1122757 1122757 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2017   grade_3 11 19 19 0   2     0   2   28 25                       53 11 19 19 0   2     0   2   28 25                 53
1123056 1123056 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2017   grade_3 11 24 23 0   70     0   7   65 70                       135 11 24 23 0   70     0   7   65 70                 135
1123918 1123918 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   grade_3 11 7 8 0   6     0   6   18 20                       38 11 7 8 0   6     0   6   18 20                 38
1125596 1125596 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_3 11 2 64 0   1     0   3   48 33                       81 11 2 64 0   1     0   3   48 33                 81
1126384 1126384 MA Essex   school 2507110 163   Lynn 250711001077 1630030 Julia F Callahan   Regular School No Elementary PK 05 2017   grade_3 11 11 35 0   8     0   9   45 29                       74 11 11 35 0   8     0   9   45 29                 74
1127293 1127293 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary KG 05 2017   grade_3 11 1 40 0   1     0   5   25 33                       58 11 1 40 0   1     0   5   25 33                 58
1127347 1127347 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_3 11 3 13 0   2     0   1   17 13                       30 11 3 13 0   2     0   1   17 13                 30
1128403 1128403 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 J F Kennedy Elementary   Regular School No Elementary PK 05 2017   grade_3 11 44 8 0   7     1   2   39 34                       73 11 44 8 0   7     1   2   39 34                 73
1128551 1128551 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_3 11 0 3 0   0     0   1   3 12                       15 11 0 3 0   0     0   1   3 12                 15
1129936 1129936 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Henry Whittemore Elementary School   Regular School No Elementary KG 05 2017   grade_3 11 2 70 0   2     0   2   48 39                       87 11 2 70 0   2     0   2   48 39                 87
1125126 1125126 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_3 110 1 1 0   0     1   2   59 56                       115 110 1 1 0   0     1   2   59 56                 115
1126971 1126971 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2017   grade_3 112 3 4 0   1     0   5   69 56                       125 112 3 4 0   1     0   5   69 56                 125
1127140 1127140 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2017   grade_3 112 7 2 0   17     0   5   79 64                       143 112 7 2 0   17     0   5   79 64                 143
1127832 1127832 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary KG 03 2017   grade_3 112 1 4 0   2     0   3   61 61                       122 112 1 4 0   2     0   3   61 61                 122
1127942 1127942 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2017   grade_3 112 2 9 0   1     0   4   68 60                       128 112 2 9 0   1     0   4   68 60                 128
1129721 1129721 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 North Street   Regular School No Elementary 03 04 2017   grade_3 113 6 3 0   3     0   2   74 53                       127 113 6 3 0   3     0   2   74 53                 127
1126334 1126334 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2017   grade_3 114 1 7 1   3     2   6   68 66                       134 114 1 7 1   3     2   6   68 66                 134
1124022 1124022 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   grade_3 116 2 2 0   0     0   4   54 70                       124 116 2 2 0   0     0   4   54 70                 124
1132018 1132018 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary KG 04 2017   grade_3 116 2 5 1   2     0   2   63 65                       128 116 2 5 1   2     0   2   63 65                 128
1129794 1129794 MA Worcester   school 2511850 304   Uxbridge 251185002762 3040020 Whitin Elementary School   Regular School No Elementary 03 05 2017   grade_3 118 0 4 1   1     0   2   67 58                       126 118 0 4 1   1     0   2   67 58                 126
1122697 1122697 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_3 12 12 18 0   1     0   4   26 21                       47 12 12 18 0   1     0   4   26 21                 47
1123168 1123168 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_3 12 6 8 0   5     0   1   21 11                       32 12 6 8 0   5     0   1   21 11                 32
1123580 1123580 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_3 12 77 30 1   1     0   8   67 62                       129 12 77 30 1   1     0   8   67 62                 129
1126230 1126230 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No Elementary PK 04 2017   grade_3 12 1 11 0   21     0   6   31 20                       51 12 1 11 0   21     0   6   31 20                 51
1126376 1126376 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_3 12 6 37 0   7     0   2   33 31                       64 12 6 37 0   7     0   2   33 31                 64
1127115 1127115 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_3 12 0 0 0   0     0   0   6 6                       12 12 0 0 0   0     0   0   6 6                 12
1127316 1127316 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary PK 05 2017   grade_3 12 11 34 0   0     0   4   38 23                       61 12 11 34 0   0     0   4   38 23                 61
1127324 1127324 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2017   grade_3 12 5 21 0   0     0   3   24 17                       41 12 5 21 0   0     0   3   24 17                 41
1128334 1128334 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No Elementary KG 05 2017   grade_3 12 0 3 0   42     0   0   32 25                       57 12 0 3 0   42     0   0   32 25                 57

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