enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2016 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
932543 932543 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_6 149 1 7 0   0     0   4   86 75                       161 149 1 7 0   0     0   4   86 75                 161
932622 932622 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   grade_6 29 2 6 0   11     0   0   23 25                       48 29 2 6 0   11     0   0   23 25                 48
932629 932629 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_6 35 5 11 0   7     1   2   28 33                       61 35 5 11 0   7     1   2   28 33                 61
932636 932636 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_6 40 6 10 0   4     0   3   30 33                       63 40 6 10 0   4     0   3   30 33                 63
932817 932817 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2016   grade_6 43 10 2 0   3     0   5   37 26                       63 43 10 2 0   3     0   5   37 26                 63
932870 932870 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2016   grade_6 173 2 5 0   2     1   4   96 91                       187 173 2 5 0   2     1   4   96 91                 187
933241 933241 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 06 2016   grade_6 25 35 32 0   6     1   8   49 58                       107 25 35 32 0   6     1   8   49 58                 107
933855 933855 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_6 100 1 1 0   5     0   2   55 54                       109 100 1 1 0   5     0   2   55 54                 109
933925 933925 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   0     0   0   17 22                       39 39 0 0 0   0     0   0   17 22                 39
934044 934044 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 44 0 1 0   0     0   2   25 22                       47 44 0 1 0   0     0   2   25 22                 47
934528 934528 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_6 26 0 0 0   0     0   0   17 9                       26 26 0 0 0   0     0   0   17 9                 26
934630 934630 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2016   grade_6 57 1 0 0   0     0   1   27 32                       59 57 1 0 0   0     0   1   27 32                 59
934706 934706 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2016   grade_6 185 2 1 1   0     0   1   87 103                       190 185 2 1 1   0     0   1   87 103                 190
934800 934800 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_6 19 0 1 0   0     0   1   8 13                       21 19 0 1 0   0     0   1   8 13                 21
935004 935004 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2016   grade_6 239 13 16 3   6     0   19   160 136                       296 239 13 16 3   6     0   19   160 136                 296
935231 935231 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
935278 935278 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_6 * * * *   *     *   *   * *                       1                                             1
935289 935289 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_6 94 2 3 0   11     0   4   57 57                       114 94 2 3 0   11     0   4   57 57                 114
935294 935294 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_6 123 0 6 0   23     0   4   73 83                       156 123 0 6 0   23     0   4   73 83                 156
935303 935303 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No 2 04 06 2016   grade_6 72 0 4 0   1     0   0   40 37                       77 72 0 4 0   1     0   0   40 37                 77
935349 935349 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_6 36 2 2 1   0     1   3   26 19                       45 36 2 2 1   0     1   3   26 19                 45
935362 935362 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2016   grade_6 62 0 0 0   1     0   1   38 26                       64 62 0 0 0   1     0   1   38 26                 64
935369 935369 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 2                       4                         2 2                 4
935411 935411 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   1     0   2   17 25                       42 39 0 0 0   1     0   2   17 25                 42
935522 935522 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2016   grade_6 77 23 9 0   4     0   10   62 61                       123 77 23 9 0   4     0   10   62 61                 123
935536 935536 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   grade_6 26 0 1 0   0     0   0   13 14                       27 26 0 1 0   0     0   0   13 14                 27
935637 935637 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_6 90 2 5 0   0     0   1   47 51                       98 90 2 5 0   0     0   1   47 51                 98
935727 935727 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2016   grade_6 163 5 2 0   2     0   1   98 75                       173 163 5 2 0   2     0   1   98 75                 173
935735 935735 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   grade_6 29 0 0 0   0     0   0   12 17                       29 29 0 0 0   0     0   0   12 17                 29
935882 935882 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   grade_6 37 0 4 0   1     0   2   24 20                       44 37 0 4 0   1     0   2   24 20                 44
935965 935965 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_6 11 0 0 0   0     0   4   6 9                       15 11 0 0 0   0     0   4   6 9                 15
936331 936331 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_6 5 2 3 0   0     0   0   9 1                       10 5 2 3 0   0     0   0   9 1                 10
936480 936480 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No 2 04 06 2016   grade_6 207 5 13 0   2     0   5   116 116                       232 207 5 13 0   2     0   5   116 116                 232
936500 936500 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2016   grade_6 71 3 3 0   0     0   1   43 35                       78 71 3 3 0   0     0   1   43 35                 78
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
936586 936586 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No 2 04 06 2016   grade_6 76 1 2 0   2     0   3   40 44                       84 76 1 2 0   2     0   3   40 44                 84
936786 936786 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2016   grade_6 90 0 5 0   3     0   3   45 56                       101 90 0 5 0   3     0   3   45 56                 101
936814 936814 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No 2 04 06 2016   grade_6 114 3 11 0   5     0   5   67 71                       138 114 3 11 0   5     0   5   67 71                 138
936892 936892 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2016   grade_6 22 0 1 0   1     0   0   9 15                       24 22 0 1 0   1     0   0   9 15                 24
936978 936978 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No 2 06 06 2016   grade_6 360 11 13 2   39     0   26   218 233                       451 360 11 13 2   39     0   26   218 233                 451
937257 937257 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2016   grade_6 125 0 3 0   2     0   2   64 68                       132 125 0 3 0   2     0   2   64 68                 132
937451 937451 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 47 0 6 0   0     0   1   25 29                       54 47 0 6 0   0     0   1   25 29                 54
937570 937570 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2016   grade_6 79 2 4 0   1     0   7   37 56                       93 79 2 4 0   1     0   7   37 56                 93
937681 937681 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2016   grade_6 9 0 2 0   1     0   1   7 6                       13 9 0 2 0   1     0   1   7 6                 13
937688 937688 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2016   grade_6 82 0 0 0   1     0   1   39 45                       84 82 0 0 0   1     0   1   39 45                 84
937695 937695 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2016   grade_6 69 0 0 0   2     0   0   32 39                       71 69 0 0 0   2     0   0   32 39                 71
937703 937703 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2016   grade_6 93 0 3 0   1     0   2   48 51                       99 93 0 3 0   1     0   2   48 51                 99
937717 937717 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2016   grade_6 13 0 2 0   0     0   2   8 9                       17 13 0 2 0   0     0   2   8 9                 17
937786 937786 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_6 87 3 7 0   5     0   4   62 44                       106 87 3 7 0   5     0   4   62 44                 106
937863 937863 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2016   grade_6 41 0 0 0   0     0   0   19 22                       41 41 0 0 0   0     0   0   19 22                 41
938112 938112 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2016   grade_6 70 3 0 0   0     0   4   41 36                       77 70 3 0 0   0     0   4   41 36                 77
938155 938155 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2016   grade_6 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
938217 938217 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 03 06 2016   grade_6 212 3 2 2   5     0   1   122 103                       225 212 3 2 2   5     0   1   122 103                 225
938269 938269 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No 1 KG 06 2016   grade_6 65 1 0 0   3     0   2   33 38                       71 65 1 0 0   3     0   2   33 38                 71
938276 938276 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No 1 KG 06 2016   grade_6 51 1 0 0   0     0   1   27 26                       53 51 1 0 0   0     0   1   27 26                 53
938283 938283 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No 1 KG 06 2016   grade_6 80 5 0 0   2     0   0   42 45                       87 80 5 0 0   2     0   0   42 45                 87
938291 938291 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2016   grade_6 60 3 0 0   1     0   0   29 35                       64 60 3 0 0   1     0   0   29 35                 64
938376 938376 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2016   grade_6 302 8 43 2   129     0   16   254 246                       500 302 8 43 2   129     0   16   254 246                 500
938387 938387 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2016   grade_6 18 0 3 0   0     0   1   15 7                       22 18 0 3 0   0     0   1   15 7                 22
938418 938418 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2016   grade_6 19 0 7 0   4     0   2   15 17                       32 19 0 7 0   4     0   2   15 17                 32
938497 938497 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No 1 PK 06 2016   grade_6 69 1 3 0   1     0   4   34 44                       78 69 1 3 0   1     0   4   34 44                 78
938917 938917 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2016   grade_6 119 1 10 0   5     0   10   77 68                       145 119 1 10 0   5     0   10   77 68                 145
938953 938953 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2016   grade_6 18 1 3 0   2     1   1   13 13                       26 18 1 3 0   2     1   1   13 13                 26
939077 939077 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No 2 05 06 2016   grade_6 286 5 8 0   11     0   2   136 176                       312 286 5 8 0   11     0   2   136 176                 312
939098 939098 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No 2 04 06 2016   grade_6 94 1 5 0   0     0   0   47 53                       100 94 1 5 0   0     0   0   47 53                 100
939111 939111 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_6 8 1 0 0   0     0   0   6 3                       9 8 1 0 0   0     0   0   6 3                 9
939177 939177 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2016   grade_6 18 0 0 0   1     0   0   5 14                       19 18 0 0 0   1     0   0   5 14                 19
939269 939269 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2016   grade_6 91 2 5 1   0     0   2   56 45                       101 91 2 5 1   0     0   2   56 45                 101
939441 939441 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2016   grade_6 177 3 22 0   86     0   20   155 153                       308 177 3 22 0   86     0   20   155 153                 308
939469 939469 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2016   grade_6 98 2 4 0   1     0   0   59 46                       105 98 2 4 0   1     0   0   59 46                 105
939571 939571 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2016   grade_6 21 0 1 0   0     0   1   8 15                       23 21 0 1 0   0     0   1   8 15                 23
939598 939598 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 03 06 2016   grade_6 116 0 4 0   2     0   5   70 57                       127 116 0 4 0   2     0   5   70 57                 127
939726 939726 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_6 389 30 33 0   22     1   23   267 231                       498 389 30 33 0   22     1   23   267 231                 498
939738 939738 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2016   grade_6 16 0 1 0   0     0   0   9 8                       17 16 0 1 0   0     0   0   9 8                 17
939746 939746 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   grade_6 20 0 1 0   0     0   0   6 15                       21 20 0 1 0   0     0   0   6 15                 21
939754 939754 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2016   grade_6 45 1 1 0   3     0   5   30 25                       55 45 1 1 0   3     0   5   30 25                 55
939916 939916 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_6 2 9 24 0   4     0   0   19 20                       39 2 9 24 0   4     0   0   19 20                 39
939923 939923 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2016   grade_6 6 5 11 0   0     0   3   14 11                       25 6 5 11 0   0     0   3   14 11                 25
939931 939931 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   grade_6 6 6 48 0   7     0   0   31 36                       67 6 6 48 0   7     0   0   31 36                 67
939938 939938 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   grade_6 3 1 18 0   1     0   1   13 11                       24 3 1 18 0   1     0   1   13 11                 24
939946 939946 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   grade_6 7 6 18 0   15     0   2   17 31                       48 7 6 18 0   15     0   2   17 31                 48
939953 939953 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2016   grade_6 3 10 36 0   1     0   0   25 25                       50 3 10 36 0   1     0   0   25 25                 50
939961 939961 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   grade_6 5 0 68 0   3     0   0   37 39                       76 5 0 68 0   3     0   0   37 39                 76
939969 939969 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_6 11 8 36 0   1     0   5   35 26                       61 11 8 36 0   1     0   5   35 26                 61
939977 939977 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2016   grade_6 3 4 14 0   1     0   3   13 12                       25 3 4 14 0   1     0   3   13 12                 25
939985 939985 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2016   grade_6 5 3 26 0   3     0   5   21 21                       42 5 3 26 0   3     0   5   21 21                 42
939992 939992 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2016   grade_6 40 2 12 0   7     0   1   33 29                       62 40 2 12 0   7     0   1   33 29                 62
940000 940000 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2016   grade_6 8 4 27 0   3     0   3   32 13                       45 8 4 27 0   3     0   3   32 13                 45
940008 940008 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2016   grade_6 3 3 34 0   7     0   2   25 24                       49 3 3 34 0   7     0   2   25 24                 49
940016 940016 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2016   grade_6 31 10 32 0   19     0   6   65 33                       98 31 10 32 0   19     0   6   65 33                 98
940024 940024 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   grade_6 11 6 8 0   2     0   0   11 16                       27 11 6 8 0   2     0   0   11 16                 27
940031 940031 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2016   grade_6 20 3 9 0   4     0   2   26 12                       38 20 3 9 0   4     0   2   26 12                 38
940039 940039 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2016   grade_6 5 7 19 0   0     0   6   16 21                       37 5 7 19 0   0     0   6   16 21                 37
940046 940046 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2016   grade_6 16 2 7 0   0     0   0   12 13                       25 16 2 7 0   0     0   0   12 13                 25
940054 940054 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2016   grade_6 6 2 15 0   2     0   1   16 10                       26 6 2 15 0   2     0   1   16 10                 26
940061 940061 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2016   grade_6 19 5 12 0   5     0   3   29 15                       44 19 5 12 0   5     0   3   29 15                 44
940069 940069 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_6 9 7 11 0   2     0   1   19 11                       30 9 7 11 0   2     0   1   19 11                 30
940076 940076 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2016   grade_6 18 0 4 0   1     0   2   14 11                       25 18 0 4 0   1     0   2   14 11                 25
940083 940083 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   grade_6 54 6 6 0   6     0   3   39 36                       75 54 6 6 0   6     0   3   39 36                 75
940091 940091 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2016   grade_6 39 8 25 0   1     0   3   43 33                       76 39 8 25 0   1     0   3   43 33                 76

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