Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 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
2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2228858 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_6 29 5 17 0   5     0   9   29 36                       65.0 29 5 17 0   5     0   9   29 36                 65
2228866 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_6 25 9 13 0   0     0   3   24 26                       50.0 25 9 13 0   0     0   3   24 26                 50
2228874 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_6 27 11 12 1   4     0   4   29 30                       59.0 27 11 12 1   4     0   4   29 30                 59
2229094 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_6 32 17 4 1   2     0   3   33 26                       59.0 32 17 4 1   2     0   3   33 26                 59
2229160 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown: Chestnut Hill Community School   Regular School No Middle 04 06 2018   grade_6 164 3 12 0   3     1   4   75 112                       187.0 164 3 12 0   3     1   4   75 112                 187
2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
2230393 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_6 43 0 0 0   1     0   0   20 24                       44.0 43 0 0 0   1     0   0   20 24                 44
2230534 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2231102 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_6 22 0 0 0   0     0   1   14 9                       23.0 22 0 0 0   0     0   1   14 9                 23
2231225 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield: Deerfield Elementary   Regular School No Elementary PK 06 2018   grade_6 47 0 3 0   1     0   5   31 25                       56.0 47 0 3 0   1     0   5   31 25                 56
2231317 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater: Gordon W Mitchell   Regular School No Elementary 03 06 2018   grade_6 159 4 7 1   1     0   5   99 78                       177.0 159 4 7 1   1     0   5   99 78                 177
2231431 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   2   11 8                       19.0 16 0 1 0   0     0   2   11 8                 19
2231684 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth: Morse Pond School   Regular School No Middle 05 06 2018   grade_6 221 20 17 2   2     1   15   139 139                       278.0 221 20 17 2   2     1   15   139 139                 278
2231958 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_6 95 2 2 0   0     0   0   53 46                       99.0 95 2 2 0   0     0   0   53 46                 99
2232041 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 89 1 6 2   7     2   3   63 47                       110.0 89 1 6 2   7     2   3   63 47                 110
2232047 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 93 3 8 0   22     0   3   67 62                       129.0 93 3 8 0   22     0   3   67 62                 129
2232059 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby: East Meadow   Regular School No Middle 04 06 2018   grade_6 52 0 3 0   1     0   1   28 29                       57.0 52 0 3 0   1     0   1   28 29                 57
2232111 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_6 40 1 3 0   1     3   3   27 24                       51.0 40 1 3 0   1     3   3   27 24                 51
2232126 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax: Halifax Elementary   Regular School No Elementary KG 06 2018   grade_6 68 2 2 0   2     1   2   45 32                       77.0 68 2 2 0   2     1   2   45 32                 77
2232133 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   8 2                       10.0 10 0 0 0   0     0   0   8 2                 10
2232182 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_6 30 1 1 0   0     0   0   17 15                       32.0 30 1 1 0   0     0   0   17 15                 32
2232334 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland: Holland Elementary   Regular School No Elementary PK 06 2018   grade_6 34 2 0 0   0     0   0   17 19                       36.0 34 2 0 0   0     0   0   17 19                 36
2232453 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale: Memorial   Regular School No Elementary KG 06 2018   grade_6 80 2 5 1   2     0   0   51 39                       90.0 80 2 5 1   2     0   0   51 39                 90
2232561 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston: Kingston Intermediate   Regular School No Elementary 03 06 2018   grade_6 125 2 3 1   1     0   2   66 68                       134.0 125 2 3 1   1     0   2   66 68                 134
2232570 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_6 31 0 0 0   0     0   1   13 19                       32.0 31 0 0 0   0     0   1   13 19                 32
2232719 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   grade_6 44 1 3 0   2     0   1   28 23                       51.0 44 1 3 0   2     0   1   28 23                 51
2232826 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_6 12 0 2 0   0     0   3   10 7                       17.0 12 0 2 0   0     0   3   10 7                 17
2232975 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell: Rogers STEM Academy   Regular School No Elementary PK 06 2018   grade_6 22 2 16 0   12     0   1   35 18                       53.0 22 2 16 0   12     0   1   35 18                 53
2233451 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead: Village School   Regular School No Middle 04 06 2018   grade_6 177 10 17 2   2     0   7   110 105                       215.0 177 10 17 2   2     0   7   110 105                 215
2233474 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Marion: Sippican   Regular School No Elementary PK 06 2018   grade_6 52 1 5 0   1     0   2   28 33                       61.0 52 1 5 0   1     0   2   28 33                 61
2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2233578 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Mattapoisett: Old Hammondtown   Regular School No Middle 04 06 2018   grade_6 66 2 1 0   1     0   4   36 38                       74.0 66 2 1 0   1     0   4   36 38                 74
2233812 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton: Howe-Manning   Regular School No Elementary 03 06 2018   grade_6 92 1 2 0   6     0   5   55 51                       106.0 92 1 2 0   6     0   5   55 51                 106
2233845 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Millbury: Raymond E. Shaw Elementary   Regular School No Middle 04 06 2018   grade_6 115 3 14 0   6     0   6   72 72                       144.0 115 3 14 0   6     0   6   72 72                 144
2233935 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_6 18 0 0 0   1     0   0   10 9                       19.0 18 0 0 0   1     0   0   10 9                 19
2234040 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 Needham: High Rock School   Regular School No Middle 06 06 2018   grade_6 339 11 30 0   45     0   25   221 229                       450.0 339 11 30 0   45     0   25   221 229                 450
2234376 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk: Freeman-Kennedy School   Regular School No Elementary 03 06 2018   grade_6 110 2 3 0   0     0   6   70 51                       121.0 110 2 3 0   0     0   6   70 51                 121
2234390 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 North Adams: Colegrove Park Elementary   Regular School No Elementary PK 06 2018   grade_6 48 2 0 0   0     0   1   27 24                       51.0 48 2 0 0   0     0   1   27 24                 51
2234399 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams: Greylock   Regular School No Elementary PK 06 2018   grade_6 35 2 2 0   2     0   0   22 19                       41.0 35 2 2 0   2     0   0   22 19                 41
2234408 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams: Brayton   Regular School No Elementary PK 06 2018   grade_6 20 2 1 0   0     0   4   11 16                       27.0 20 2 1 0   0     0   4   11 16                 27
2234604 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield: North Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 51 0 2 0   0     0   2   28 27                       55.0 51 0 2 0   0     0   2   28 27                 55
2234749 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange: Dexter Park   Regular School No Elementary 03 06 2018   grade_6 66 0 5 0   1     0   1   44 29                       73.0 66 0 5 0   1     0   1   44 29                 73
2234878 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_6 14 0 1 0   1     0   0   7 9                       16.0 14 0 1 0   1     0   0   7 9                 16
2234886 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Pembroke: Bryantville Elementary   Regular School No Elementary KG 06 2018   grade_6 70 1 0 0   1     1   0   36 37                       73.0 70 1 0 0   1     1   0   36 37                 73
2234894 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Pembroke: Hobomock Elementary   Regular School No Elementary KG 06 2018   grade_6 61 0 0 0   0     0   0   40 21                       61.0 61 0 0 0   0     0   0   40 21                 61
2234903 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 Pembroke: North Pembroke Elementary   Regular School No Elementary PK 06 2018   grade_6 81 1 0 0   1     0   1   48 36                       84.0 81 1 0 0   1     0   1   48 36                 84
2234919 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham: Petersham Center   Regular School No Elementary KG 06 2018   grade_6 18 0 0 0   0     0   1   13 6                       19.0 18 0 0 0   0     0   1   13 6                 19
2235001 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Plainville: Beatrice H Wood Elementary   Regular School No Middle 04 06 2018   grade_6 91 2 9 1   5     0   0   51 57                       108.0 91 2 9 1   5     0   0   51 57                 108
2235090 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton: Dennett Elementary   Regular School No Elementary KG 06 2018   grade_6 30 0 0 1   1     0   0   16 16                       32.0 30 0 0 1   1     0   0   16 16                 32
2235386 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester: Rochester Memorial   Regular School No Elementary PK 06 2018   grade_6 59 1 1 0   0     0   5   35 31                       66.0 59 1 1 0   0     0   5   35 31                 66
2235441 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2235520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_6 216 0 4 0   2     0   1   102 121                       223.0 216 0 4 0   2     0   1   102 121                 223
2235712 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury: Sherwood Middle School   Regular School No Middle 05 06 2018   grade_6 291 15 35 1   143     0   18   263 240                       503.0 291 15 35 1   143     0   18   263 240                 503
2235726 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury: Shutesbury Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 0 0   0     0   1   6 12                       18.0 17 0 0 0   0     0   1   6 12                 18
2235849 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 Southampton: William E Norris   Regular School No Elementary PK 06 2018   grade_6 70 0 2 0   1     0   2   42 33                       75.0 70 0 2 0   1     0   2   42 33                 75
2236345 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge: Burgess Elementary   Regular School No Elementary PK 06 2018   grade_6 109 2 9 0   2     0   6   70 58                       128.0 109 2 9 0   2     0   6   70 58                 128
2236387 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland: Sunderland Elementary   Regular School No Elementary PK 06 2018   grade_6 19 2 1 0   4     0   2   23 5                       28.0 19 2 1 0   4     0   2   23 5                 28
2236541 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 Tewksbury: John F. Ryan   Regular School No Middle 05 06 2018   grade_6 238 6 8 0   9     1   2   141 123                       264.0 238 6 8 0   9     1   2   141 123                 264
2236567 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Topsfield: Proctor Elementary   Regular School No Middle 04 06 2018   grade_6 72 1 1 0   2     0   0   34 42                       76.0 72 1 1 0   2     0   0   34 42                 76
2236663 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales: Wales Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 3 0   0     0   1   14 7                       21.0 17 0 3 0   0     0   1   14 7                 21
2236776 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware: Ware Middle School   Regular School No Middle 04 06 2018   grade_6 99 3 6 0   0     1   6   51 64                       115.0 99 3 6 0   0     1   6   51 64                 115
2236973 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough: Mill Pond School   Regular School No Middle 04 06 2018   grade_6 182 4 21 0   91     1   10   154 155                       309.0 182 4 21 0   91     1   10   154 155                 309
2237008 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 West Bridgewater: Howard School   Regular School No Middle 04 06 2018   grade_6 76 6 4 1   1     0   5   45 48                       93.0 76 6 4 1   1     0   5   45 48                 93
2237132 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton: Westhampton Elementary School   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   1   9 8                       17.0 16 0 0 0   0     0   1   9 8                 17
2237166 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport: Westport Elementary   Regular School No Elementary 03 06 2018   grade_6 138 0 8 0   0     0   7   79 74                       153.0 138 0 8 0   0     0   7   79 74                 153
2237337 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth: Abigail Adams Middle School   Regular School No Middle 05 06 2018   grade_6 352 31 46 2   22     1   15   229 240                       469.0 352 31 46 2   22     1   15   229 240                 469
2237351 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   1   6 12                       18.0 16 0 1 0   0     0   1   6 12                 18
2237360 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_6 30 0 0 0   0     0   0   16 14                       30.0 30 0 0 0   0     0   0   16 14                 30
2237369 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown: Williamstown Elementary   Regular School No Elementary PK 06 2018   grade_6 61 1 4 0   0     0   7   25 48                       73.0 61 1 4 0   0     0   7   25 48                 73
2237568 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Worcester: Belmont Street Community   Regular School No Elementary PK 06 2018   grade_6 7 15 27 1   8     0   0   26 32                       58.0 7 15 27 1   8     0   0   26 32                 58
2237576 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_6 8 2 10 0   3     0   0   13 10                       23.0 8 2 10 0   3     0   0   13 10                 23
2237584 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Worcester: Woodland Academy   Regular School No Elementary KG 06 2018   grade_6 9 12 65 0   10     0   2   47 51                       98.0 9 12 65 0   10     0   2   47 51                 98
2237592 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester: Burncoat Street   Regular School No Elementary KG 06 2018   grade_6 9 6 20 0   1     0   3   21 18                       39.0 9 6 20 0   1     0   3   21 18                 39
2237601 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester: Canterbury   Regular School No Elementary PK 06 2018   grade_6 7 5 26 0   10     0   1   26 23                       49.0 7 5 26 0   10     0   1   26 23                 49
2237609 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Worcester: Chandler Elementary Community   Regular School No Elementary KG 06 2018   grade_6 5 6 35 0   11     0   0   37 20                       57.0 5 6 35 0   11     0   0   37 20                 57
2237618 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_6 4 1 35 0   4     0   0   24 20                       44.0 4 1 35 0   4     0   0   24 20                 44
2237627 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_6 14 14 29 0   1     0   4   28 34                       62.0 14 14 29 0   1     0   4   28 34                 62
2237636 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Worcester: Clark St Community   Regular School No Elementary PK 06 2018   grade_6 5 5 20 0   1     0   3   16 18                       34.0 5 5 20 0   1     0   3   16 18                 34
2237645 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Worcester: Columbus Park   Regular School No Elementary PK 06 2018   grade_6 9 6 29 0   9     0   2   30 25                       55.0 9 6 29 0   9     0   2   30 25                 55
2237653 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Worcester: Flagg Street   Regular School No Elementary KG 06 2018   grade_6 41 3 5 0   2     0   2   32 21                       53.0 41 3 5 0   2     0   2   32 21                 53
2237661 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Worcester: Elm Park Community   Regular School No Elementary KG 06 2018   grade_6 10 13 34 0   1     0   3   34 27                       61.0 10 13 34 0   1     0   3   34 27                 61
2237670 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Worcester: Goddard School/Science Technical   Regular School No Elementary PK 06 2018   grade_6 9 8 45 0   6     0   2   36 34                       70.0 9 8 45 0   6     0   2   36 34                 70
2237679 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Worcester: Gates Lane   Regular School No Elementary PK 06 2018   grade_6 26 18 36 0   10     0   1   58 33                       91.0 26 18 36 0   10     0   1   58 33                 91
2237687 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Worcester: Grafton Street   Regular School No Elementary KG 06 2018   grade_6 8 8 16 0   3     0   1   21 15                       36.0 8 8 16 0   3     0   1   21 15                 36
2237695 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester: Heard Street   Regular School No Elementary KG 06 2018   grade_6 16 6 7 0   6     0   2   16 21                       37.0 16 6 7 0   6     0   2   16 21                 37
2237704 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_6 7 10 18 0   0     0   1   17 19                       36.0 7 10 18 0   0     0   1   17 19                 36
2237712 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Worcester: Lake View   Regular School No Elementary KG 06 2018   grade_6 11 2 7 0   5     0   3   15 13                       28.0 11 2 7 0   5     0   3   15 13                 28
2237720 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   grade_6 6 7 22 0   1     0   1   20 17                       37.0 6 7 22 0   1     0   1   20 17                 37
2237728 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 Worcester: May Street   Regular School No Elementary KG 06 2018   grade_6 21 4 12 0   5     0   5   26 21                       47.0 21 4 12 0   5     0   5   26 21                 47
2237736 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   grade_6 8 5 14 1   0     0   0   15 13                       28.0 8 5 14 1   0     0   0   15 13                 28
2237744 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   grade_6 17 4 4 0   2     0   1   17 11                       28.0 17 4 4 0   2     0   1   17 11                 28
2237753 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Worcester: Nelson Place   Regular School No Elementary PK 06 2018   grade_6 52 8 12 0   3     0   2   37 40                       77.0 52 8 12 0   3     0   2   37 40                 77
2237762 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Worcester: Norrback Avenue   Regular School No Elementary PK 06 2018   grade_6 29 23 21 0   1     0   0   41 33                       74.0 29 23 21 0   1     0   0   41 33                 74
2237771 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester: Quinsigamond   Regular School No Elementary PK 06 2018   grade_6 24 20 34 0   7     0   4   40 49                       89.0 24 20 34 0   7     0   4   40 49                 89
2237779 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Worcester: Rice Square   Regular School No Elementary KG 06 2018   grade_6 12 8 14 0   5     0   3   20 22                       42.0 12 8 14 0   5     0   3   20 22                 42
2237788 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   grade_6 24 13 29 0   2     0   2   26 44                       70.0 24 13 29 0   2     0   2   26 44                 70
2237797 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester: Worcester Arts Magnet School   Regular School No Elementary PK 06 2018   grade_6 23 5 7 0   1     0   1   18 19                       37.0 23 5 7 0   1     0   1   18 19                 37
2237806 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   grade_6 15 12 10 0   3     0   1   15 26                       41.0 15 12 10 0   3     0   1   15 26                 41
2237814 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester: Thorndyke Road   Regular School No Elementary KG 06 2018   grade_6 23 6 11 0   1     0   2   17 26                       43.0 23 6 11 0   1     0   2   17 26                 43

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