enrollments

Data source: Big Local News · About: Big Local

577 rows where grade = "grade_6", state = "MA" and year = 2017 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 577 ✖

grade ✖

  • grade_6 · 577 ✖
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
1125266 1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1121955 1121955 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_6 156 6 8 0   2     0   1   82 91                       173 156 6 8 0   2     0   1   82 91                 173
1122052 1122052 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_6 23 6 13 0   5     0   2   22 27                       49 23 6 13 0   5     0   2   22 27                 49
1122060 1122060 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_6 20 5 9 0   6     0   4   26 18                       44 20 5 9 0   6     0   4   26 18                 44
1122068 1122068 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_6 25 7 11 0   9     0   5   27 30                       57 25 7 11 0   9     0   5   27 30                 57
1122288 1122288 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2017   grade_6 32 15 6 0   1     0   5   26 33                       59 32 15 6 0   1     0   5   26 33                 59
1122354 1122354 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_6 183 2 6 0   6     1   7   109 96                       205 183 2 6 0   6     1   7   109 96                 205
1122675 1122675 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1123492 1123492 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_6 116 1 6 0   3     1   4   73 58                       131 116 1 6 0   3     1   4   73 58                 131
1123575 1123575 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_6 32 2 0 0   0     0   0   18 16                       34 32 2 0 0   0     0   0   18 16                 34
1123720 1123720 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 44 0 3 0   0     0   1   22 26                       48 44 0 3 0   0     0   1   22 26                 48
1124286 1124286 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_6 26 0 0 0   0     0   0   14 12                       26 26 0 0 0   0     0   0   14 12                 26
1124408 1124408 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_6 57 0 2 0   1     0   0   30 30                       60 57 0 2 0   1     0   0   30 30                 60
1124500 1124500 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No Elementary 03 06 2017   grade_6 170 6 3 1   3     0   4   90 96                       187 170 6 3 1   3     0   4   90 96                 187
1124614 1124614 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 1 0   0     0   0   6 6                       12 11 0 1 0   0     0   0   6 6                 12
1124857 1124857 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2017   grade_6 263 18 14 1   5     1   14   152 164                       316 263 18 14 1   5     1   14   152 164                 316
1125129 1125129 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_6 107 2 0 0   1     0   1   61 50                       111 107 2 0 0   1     0   1   61 50                 111
1125212 1125212 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_6 106 1 4 0   10     0   2   49 74                       123 106 1 4 0   10     0   2   49 74                 123
1125218 1125218 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_6 111 3 5 0   18     0   4   71 70                       141 111 3 5 0   18     0   4   71 70                 141
1125230 1125230 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary 04 06 2017   grade_6 51 0 5 0   0     0   1   36 21                       57 51 0 5 0   0     0   1   36 21                 57
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1125313 1125313 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2017   grade_6 82 0 3 0   1     0   0   51 35                       86 82 0 3 0   1     0   0   51 35                 86
1125369 1125369 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_6 27 0 4 0   0     0   0   17 14                       31 27 0 4 0   0     0   0   17 14                 31
1125503 1125503 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No Elementary 04 06 2017   grade_6 48 19 13 0   4     0   7   44 47                       91 48 19 13 0   4     0   7   44 47                 91
1125519 1125519 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_6 33 0 1 0   1     0   0   13 22                       35 33 0 1 0   1     0   0   13 22                 35
1125636 1125636 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2017   grade_6 69 0 2 0   7     1   4   48 35                       83 69 0 2 0   7     1   4   48 35                 83
1125744 1125744 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2017   grade_6 145 3 2 0   2     0   1   82 71                       153 145 3 2 0   2     0   1   82 71                 153
1125753 1125753 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_6 22 0 0 0   0     0   0   10 12                       22 22 0 0 0   0     0   0   10 12                 22
1125903 1125903 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_6 49 1 4 0   0     0   6   25 35                       60 49 1 4 0   0     0   6   25 35                 60
1126010 1126010 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   2     0   1   8 6                       14 11 0 0 0   2     0   1   8 6                 14
1126451 1126451 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_6 3 3 3 0   0     0   0   7 *                       9 3 3 3 0   0     0   0   7                   9
1126630 1126630 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 04 06 2017   grade_6 199 11 11 0   4     0   2   114 113                       227 199 11 11 0   4     0   2   114 113                 227
1126653 1126653 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2017   grade_6 60 1 0 0   2     0   5   31 37                       68 60 1 0 0   2     0   5   31 37                 68
1126742 1126742 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_6 106 5 2 13   5     0   6   60 77                       137 106 5 2 13   5     0   6   60 77                 137
1126757 1126757 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No Elementary 04 06 2017   grade_6 65 0 3 0   2     0   2   47 25                       72 65 0 3 0   2     0   2   47 25                 72
1126995 1126995 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2017   grade_6 93 1 7 0   5     0   3   57 52                       109 93 1 7 0   5     0   3   57 52                 109
1127028 1127028 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Elementary 04 06 2017   grade_6 121 2 10 0   2     0   2   58 79                       137 121 2 10 0   2     0   2   58 79                 137
1127118 1127118 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_6 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
1127222 1127222 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2017   grade_6 331 8 28 0   30     0   24   200 221                       421 331 8 28 0   30     0   24   200 221                 421
1127554 1127554 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2017   grade_6 109 3 5 0   1     0   1   64 55                       119 109 3 5 0   1     0   1   64 55                 119
1127783 1127783 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 39 1 2 0   0     0   3   31 14                       45 39 1 2 0   0     0   3   31 14                 45
1127927 1127927 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2017   grade_6 74 1 5 0   0     0   0   43 37                       80 74 1 5 0   0     0   0   43 37                 80
1128056 1128056 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_6 16 0 0 0   1     0   1   13 5                       18 16 0 0 0   1     0   1   13 5                 18
1128064 1128064 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2017   grade_6 87 3 0 0   0     0   0   47 43                       90 87 3 0 0   0     0   0   47 43                 90
1128072 1128072 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2017   grade_6 74 0 0 0   1     0   0   42 33                       75 74 0 0 0   1     0   0   42 33                 75
1128081 1128081 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2017   grade_6 79 1 1 0   2     0   0   44 39                       83 79 1 1 0   2     0   0   44 39                 83
1128097 1128097 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_6 16 0 0 0   0     0   1   9 8                       17 16 0 0 0   0     0   1   9 8                 17
1128179 1128179 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Elementary 04 06 2017   grade_6 83 2 4 0   3     0   5   55 42                       97 83 2 4 0   3     0   5   55 42                 97
1128269 1128269 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_6 32 0 0 0   0     0   0   11 21                       32 32 0 0 0   0     0   0   11 21                 32
1128565 1128565 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No Elementary PK 06 2017   grade_6 68 1 1 0   0     0   1   38 33                       71 68 1 1 0   0     0   1   38 33                 71
1128698 1128698 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_6 223 1 1 4   6     0   1   118 118                       236 223 1 1 4   6     0   1   118 118                 236
1128761 1128761 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No Elementary KG 06 2017   grade_6 45 2 2 0   0     0   0   24 25                       49 45 2 2 0   0     0   0   24 25                 49
1128769 1128769 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No Elementary KG 06 2017   grade_6 36 0 0 0   2     0   1   14 25                       39 36 0 0 0   2     0   1   14 25                 39
1128777 1128777 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No Elementary KG 06 2017   grade_6 92 0 1 0   2     0   0   43 52                       95 92 0 1 0   2     0   0   43 52                 95
1128786 1128786 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No Elementary PK 06 2017   grade_6 42 1 1 0   0     0   0   23 21                       44 42 1 1 0   0     0   0   23 21                 44
1128891 1128891 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2017   grade_6 300 11 35 1   130     0   13   240 250                       490 300 11 35 1   130     0   13   240 250                 490
1128905 1128905 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_6 10 0 1 0   0     0   2   6 7                       13 10 0 1 0   0     0   2   6 7                 13
1129029 1129029 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No Elementary PK 06 2017   grade_6 63 1 1 0   1     0   1   31 36                       67 63 1 1 0   1     0   1   31 36                 67
1129528 1129528 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_6 109 0 6 0   2     0   9   70 56                       126 109 0 6 0   2     0   9   70 56                 126
1129570 1129570 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2017   grade_6 29 2 3 0   1     0   5   21 19                       40 29 2 3 0   1     0   5   21 19                 40
1129725 1129725 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2017   grade_6 254 5 5 1   8     0   2   147 128                       275 254 5 5 1   8     0   2   147 128                 275
1129751 1129751 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Elementary 04 06 2017   grade_6 82 0 5 0   0     0   2   40 49                       89 82 0 5 0   0     0   2   40 49                 89
1129766 1129766 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_6 8 0 1 0   0     0   0   3 6                       9 8 0 1 0   0     0   0   3 6                 9
1129849 1129849 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   grade_6 18 0 0 1   0     0   1   8 12                       20 18 0 0 1   0     0   1   8 12                 20
1129961 1129961 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Elementary 04 06 2017   grade_6 79 1 12 0   2     0   5   48 51                       99 79 1 12 0   2     0   5   48 51                 99
1130158 1130158 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Elementary 04 06 2017   grade_6 161 1 16 0   88     0   13   151 128                       279 161 1 16 0   88     0   13   151 128                 279
1130193 1130193 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Elementary 04 06 2017   grade_6 85 2 6 0   0     0   0   55 38                       93 85 2 6 0   0     0   0   55 38                 93
1130317 1130317 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_6 16 0 1 0   0     0   0   6 11                       17 16 0 1 0   0     0   0   6 11                 17
1130351 1130351 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2017   grade_6 103 1 3 0   1     0   5   62 51                       113 103 1 3 0   1     0   5   62 51                 113
1130509 1130509 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   grade_6 365 24 33 2   20     1   13   241 217                       458 365 24 33 2   20     1   13   241 217                 458
1130523 1130523 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   14 6                       20 19 0 1 0   0     0   0   14 6                 20
1130532 1130532 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_6 25 0 0 0   0     0   0   16 9                       25 25 0 0 0   0     0   0   16 9                 25
1130541 1130541 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   grade_6 50 0 4 0   2     0   3   30 29                       59 50 0 4 0   2     0   3   30 29                 59
1130740 1130740 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_6 6 9 26 0   2     0   2   20 25                       45 6 9 26 0   2     0   2   20 25                 45
1130748 1130748 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_6 6 2 7 0   0     0   1   9 7                       16 6 2 7 0   0     0   1   9 7                 16
1130757 1130757 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_6 3 7 57 0   8     0   0   41 34                       75 3 7 57 0   8     0   0   41 34                 75
1130765 1130765 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_6 8 6 15 0   2     0   1   18 14                       32 8 6 15 0   2     0   1   18 14                 32
1130774 1130774 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_6 7 6 24 0   6     0   0   18 25                       43 7 6 24 0   6     0   0   18 25                 43
1130782 1130782 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_6 5 12 43 0   7     0   2   35 34                       69 5 12 43 0   7     0   2   35 34                 69
1130791 1130791 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_6 3 4 60 0   3     0   2   27 45                       72 3 4 60 0   3     0   2   27 45                 72
1130800 1130800 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_6 15 3 34 0   1     0   2   26 29                       55 15 3 34 0   1     0   2   26 29                 55
1130808 1130808 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_6 2 11 15 0   0     0   0   21 7                       28 2 11 15 0   0     0   0   21 7                 28
1130817 1130817 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   grade_6 6 6 23 0   4     0   3   23 19                       42 6 6 23 0   4     0   3   23 19                 42
1130825 1130825 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2017   grade_6 34 5 7 0   0     0   4   17 33                       50 34 5 7 0   0     0   4   17 33                 50
1130834 1130834 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary PK 06 2017   grade_6 14 7 31 1   2     0   2   22 35                       57 14 7 31 1   2     0   2   22 35                 57
1130843 1130843 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2017   grade_6 9 4 39 0   10     0   3   43 22                       65 9 4 39 0   10     0   3   43 22                 65
1130852 1130852 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2017   grade_6 25 15 26 0   11     0   1   46 32                       78 25 15 26 0   11     0   1   46 32                 78
1130861 1130861 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   grade_6 9 4 14 0   1     0   0   14 14                       28 9 4 14 0   1     0   0   14 14                 28
1130869 1130869 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   grade_6 21 3 5 0   5     0   0   15 19                       34 21 3 5 0   5     0   0   15 19                 34
1130878 1130878 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2017   grade_6 6 11 22 0   2     0   3   18 26                       44 6 11 22 0   2     0   3   18 26                 44
1130886 1130886 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   grade_6 16 4 6 0   2     0   1   17 12                       29 16 4 6 0   2     0   1   17 12                 29
1130895 1130895 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_6 2 5 16 0   2     0   1   11 15                       26 2 5 16 0   2     0   1   11 15                 26
1130903 1130903 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2017   grade_6 28 4 14 1   2     0   4   26 27                       53 28 4 14 1   2     0   4   26 27                 53
1130912 1130912 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   grade_6 13 9 16 0   1     0   5   19 25                       44 13 9 16 0   1     0   5   19 25                 44
1130920 1130920 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_6 15 0 5 0   6     0   4   16 14                       30 15 0 5 0   6     0   4   16 14                 30
1130928 1130928 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary KG 06 2017   grade_6 37 10 9 0   3     0   2   29 32                       61 37 10 9 0   3     0   2   29 32                 61
1130937 1130937 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2017   grade_6 24 15 17 0   4     0   1   29 32                       61 24 15 17 0   4     0   1   29 32                 61
1130946 1130946 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2017   grade_6 25 21 50 0   7     0   7   53 57                       110 25 21 50 0   7     0   7   53 57                 110
1130954 1130954 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2017   grade_6 20 10 20 0   3     0   4   35 22                       57 20 10 20 0   3     0   4   35 22                 57
1130963 1130963 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2017   grade_6 33 10 23 0   2     0   3   33 38                       71 33 10 23 0   2     0   3   33 38                 71

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