Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2019 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2019 · 572

grade

  • grade_6 · 572
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
2039897 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_6 13 6 7 0   4     0   2   17 15                       32.0 13 6 7 0   4     0   2   17 15                 32
2039904 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_6 35 3 14 0   9     0   6   43 24                       67.0 35 3 14 0   9     0   6   43 24                 67
2039911 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_6 30 3 10 0   13     0   11   39 28                       67.0 30 3 10 0   13     0   11   39 28                 67
2040000 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2019   grade_6 321 15 34 1   61     1   30   250 213                       463.0 321 15 34 1   61     1   30   250 213                 463
2040093 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   grade_6 33 15 6 0   4     0   6   28 36                       64.0 33 15 6 0   4     0   6   28 36                 64
2040146 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2019   grade_6 166 8 6 0   8     1   4   107 86                       193.0 166 8 6 0   8     1   4   107 86                 193
2040420 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041138 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_6 94 1 0 0   5     0   0   48 52                       100.0 94 1 0 0   5     0   0   48 52                 100
2041208 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 1 1 0   1     0   0   21 20                       41.0 38 1 1 0   1     0   0   21 20                 41
2041332 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 39 0 2 0   0     0   4   20 25                       45.0 39 0 2 0   0     0   4   20 25                 45
2041821 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_6 19 0 1 0   0     0   0   9 11                       20.0 19 0 1 0   0     0   0   9 11                 20
2041924 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2019   grade_6 52 0 2 0   0     0   2   33 23                       56.0 52 0 2 0   0     0   2   33 23                 56
2042001 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2019   grade_6 150 7 2 1   0     1   6   101 66                       167.0 150 7 2 1   0     1   6   101 66                 167
2042098 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_6 17 0 0 0   0     0   3   8 12                       20.0 17 0 0 0   0     0   3   8 12                 20
2042306 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2019   grade_6 210 16 15 2   10     0   16   136 133                       269.0 210 16 15 2   10     0   16   136 133                 269
2042540 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_6 89 1 1 0   2     1   0   40 54                       94.0 89 1 1 0   2     1   0   40 54                 94
2042596 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 94 1 7 0   14     0   4   69 51                       120.0 94 1 7 0   14     0   4   69 51                 120
2042601 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 116 4 9 0   12     0   6   81 66                       147.0 116 4 9 0   12     0   6   81 66                 147
2042616 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2019   grade_6 47 0 4 0   1     0   0   31 21                       52.0 47 0 4 0   1     0   0   31 21                 52
2042655 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_6 34 2 6 0   2     0   1   25 20                       45.0 34 2 6 0   2     0   1   25 20                 45
2042669 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_6 84 1 1 0   0     0   1   42 45                       87.0 84 1 1 0   0     0   1   42 45                 87
2042674 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2042716 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 0 1 0   0     0   1   22 18                       40.0 38 0 1 0   0     0   1   22 18                 40
2042855 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_6 30 0 2 0   0     0   0   16 16                       32.0 30 0 2 0   0     0   0   16 16                 32
2042952 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2019   grade_6 69 3 7 0   0     0   2   44 37                       81.0 69 3 7 0   0     0   2   44 37                 81
2043043 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2019   grade_6 140 3 9 1   0     0   2   79 76                       155.0 140 3 9 1   0     0   2   79 76                 155
2043160 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   grade_6 30 0 4 0   3     0   2   11 28                       39.0 30 0 4 0   3     0   2   11 28                 39
2043248 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_6 12 0 3 0   0     0   2   8 9                       17.0 12 0 3 0   0     0   2   8 9                 17
2043776 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Middle 04 06 2019   grade_6 196 5 13 0   3     0   7   121 103                       224.0 196 5 13 0   3     0   7   121 103                 224
2043796 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2019   grade_6 65 3 1 0   2     0   5   43 33                       76.0 65 3 1 0   2     0   5   43 33                 76
2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2043883 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No Middle 04 06 2019   grade_6 62 1 2 0   2     0   3   37 33                       70.0 62 1 2 0   2     0   3   37 33                 70
2044081 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   grade_6 75 0 2 0   5     0   2   51 33                       84.0 75 0 2 0   5     0   2   51 33                 84
2044107 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2019   grade_6 122 4 10 0   9     0   13   83 75                       158.0 122 4 10 0   9     0   13   83 75                 158
2044185 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_6 23 0 0 0   0     0   0   9 14                       23.0 23 0 0 0   0     0   0   9 14                 23
2044271 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2019   grade_6 359 9 28 0   30     0   24   224 226                       450.0 359 9 28 0   30     0   24   224 226                 450
2044558 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2019   grade_6 97 2 7 0   6     0   5   56 61                       117.0 97 2 7 0   6     0   5   56 61                 117
2044570 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2019   grade_6 42 1 1 0   1     0   1   22 24                       46.0 42 1 1 0   1     0   1   22 24                 46
2044578 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2019   grade_6 25 1 4 0   0     1   3   20 14                       34.0 25 1 4 0   0     1   3   20 14                 34
2044586 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_6 34 1 3 0   0     0   3   21 20                       41.0 34 1 3 0   0     0   3   21 20                 41
2044749 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 43 0 1 0   0     0   2   26 20                       46.0 43 0 1 0   0     0   2   26 20                 46
2044871 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2019   grade_6 70 1 8 0   1     0   7   52 35                       87.0 70 1 8 0   1     0   7   52 35                 87
2044982 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2019   grade_6 18 1 2 0   0     0   0   6 15                       21.0 18 1 2 0   0     0   0   6 15                 21
2044989 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2019   grade_6 79 0 0 0   1     0   0   47 33                       80.0 79 0 0 0   1     0   0   47 33                 80
2044996 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   grade_6 82 0 1 0   0     0   0   41 42                       83.0 82 0 1 0   0     0   0   41 42                 83
2045004 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2019   grade_6 63 0 2 0   1     0   2   38 30                       68.0 63 0 2 0   1     0   2   38 30                 68
2045018 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_6 12 0 2 0   0     0   0   6 8                       14.0 12 0 2 0   0     0   0   6 8                 14
2045088 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2019   grade_6 80 3 8 1   3     0   1   50 46                       96.0 80 3 8 1   3     0   1   50 46                 96
2045163 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   grade_6 18 0 2 0   0     0   0   10 10                       20.0 18 0 2 0   0     0   0   10 10                 20
2045414 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No Elementary PK 06 2019   grade_6 65 2 2 0   0     0   6   44 31                       75.0 65 2 2 0   0     0   6   44 31                 75
2045461 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2045520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2019   grade_6 194 4 3 1   2     0   4   107 101                       208.0 194 4 3 1   2     0   4   107 101                 208
2045679 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2019   grade_6 236 15 50 1   149     0   17   248 220                       468.0 236 15 50 1   149     0   17   248 220                 468
2045692 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_6 10 1 1 0   0     0   1   8 5                       13.0 10 1 1 0   0     0   1   8 5                 13
2045800 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No Elementary PK 06 2019   grade_6 62 0 10 0   0     0   2   39 35                       74.0 62 0 10 0   0     0   2   39 35                 74
2046231 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_6 108 3 5 1   0     1   4   73 49                       122.0 108 3 5 1   0     1   4   73 49                 122
2046267 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2019   grade_6 12 0 2 0   2     0   4   12 8                       20.0 12 0 2 0   2     0   4   12 8                 20
2046393 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2019   grade_6 219 12 10 0   12     0   1   128 126                       254.0 219 12 10 0   12     0   1   128 126                 254
2046415 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Middle 04 06 2019   grade_6 72 1 0 0   1     0   3   37 40                       77.0 72 1 0 0   1     0   3   37 40                 77
2046495 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   grade_6 18 0 1 0   0     0   1   14 6                       20.0 18 0 1 0   0     0   1   14 6                 20
2046591 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2019   grade_6 104 3 7 0   0     0   4   59 59                       118.0 104 3 7 0   0     0   4   59 59                 118
2046759 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2019   grade_6 175 2 17 0   120     0   7   152 169                       321.0 175 2 17 0   120     0   7   152 169                 321
2046787 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2019   grade_6 84 6 4 0   0     0   4   42 56                       98.0 84 6 4 0   0     0   4   42 56                 98
2046826 MA Hampden   school 2512630 325   Westfield 251263002894 3250075 Westfield Intermediate School   Regular School No Middle 05 06 2019   grade_6 293 7 67 1   11     0   9   184 204                       388.0 293 7 67 1   11     0   9   184 204                 388
2046875 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   grade_6 16 0 1 0   0     0   0   9 8                       17.0 16 0 1 0   0     0   0   9 8                 17
2046902 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2019   grade_6 104 0 4 0   1     0   9   72 46                       118.0 104 0 4 0   1     0   9   72 46                 118
2047028 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2019   grade_6 319 32 46 1   17     0   16   211 220                       431.0 319 32 46 1   17     0   16   211 220                 431
2047041 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   grade_6 19 0 2 0   0     0   0   9 12                       21.0 19 0 2 0   0     0   0   9 12                 21
2047049 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_6 16 1 0 0   0     0   0   8 9                       17.0 16 1 0 0   0     0   0   8 9                 17
2047204 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2019   grade_6 21 17 40 0   5     1   4   46 42                       88.0 21 17 40 0   5     1   4   46 42                 88
2047211 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2019   grade_6 11 5 6 0   0     0   0   11 11                       22.0 11 5 6 0   0     0   0   11 11                 22
2047218 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_6 8 8 63 1   8     0   2   48 42                       90.0 8 8 63 1   8     0   2   48 42                 90
2047225 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2019   grade_6 10 6 19 0   3     0   1   19 20                       39.0 10 6 19 0   3     0   1   19 20                 39
2047233 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2019   grade_6 3 7 27 0   11     0   3   28 23                       51.0 3 7 27 0   11     0   3   28 23                 51
2047240 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2019   grade_6 6 11 49 0   8     0   1   36 39                       75.0 6 11 49 0   8     0   1   36 39                 75
2047248 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2019   grade_6 2 2 38 0   0     0   1   27 16                       43.0 2 2 38 0   0     0   1   27 16                 43
2047256 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2019   grade_6 9 3 36 0   1     0   1   25 25                       50.0 9 3 36 0   1     0   1   25 25                 50
2047264 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2019   grade_6 3 3 16 0   0     0   2   15 9                       24.0 3 3 16 0   0     0   2   15 9                 24
2047272 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2019   grade_6 17 9 28 0   7     0   4   41 24                       65.0 17 9 28 0   7     0   4   41 24                 65
2047279 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2019   grade_6 30 5 6 0   2     0   3   23 23                       46.0 30 5 6 0   2     0   3   23 23                 46
2047286 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary KG 06 2019   grade_6 14 6 43 0   3     0   3   40 29                       69.0 14 6 43 0   3     0   3   40 29                 69
2047294 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2019   grade_6 16 3 31 1   7     0   3   32 29                       61.0 16 3 31 1   7     0   3   32 29                 61
2047302 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2019   grade_6 16 6 18 1   8     0   3   32 20                       52.0 16 6 18 1   8     0   3   32 20                 52
2047309 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary KG 06 2019   grade_6 11 3 23 0   3     0   0   21 19                       40.0 11 3 23 0   3     0   0   21 19                 40
2047316 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2019   grade_6 13 4 11 0   4     0   2   17 17                       34.0 13 4 11 0   4     0   2   17 17                 34
2047324 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2019   grade_6 7 3 22 0   5     0   3   16 24                       40.0 7 3 22 0   5     0   3   16 24                 40
2047331 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2019   grade_6 17 7 8 0   1     0   3   18 18                       36.0 17 7 8 0   1     0   3   18 18                 36
2047338 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary KG 06 2019   grade_6 2 8 23 0   1     0   2   12 24                       36.0 2 8 23 0   1     0   2   12 24                 36
2047345 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2019   grade_6 23 11 8 1   4     0   6   24 29                       53.0 23 11 8 1   4     0   6   24 29                 53
2047352 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary KG 06 2019   grade_6 5 8 6 0   1     0   3   13 10                       23.0 5 8 6 0   1     0   3   13 10                 23
2047359 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2019   grade_6 14 3 4 0   3     0   0   10 14                       24.0 14 3 4 0   3     0   0   10 14                 24
2047367 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary PK 06 2019   grade_6 36 5 13 0   7     0   2   35 28                       63.0 36 5 13 0   7     0   2   35 28                 63
2047375 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2019   grade_6 25 12 15 0   3     0   5   33 27                       60.0 25 12 15 0   3     0   5   33 27                 60
2047383 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2019   grade_6 29 26 38 0   9     0   1   51 52                       103.0 29 26 38 0   9     0   1   51 52                 103
2047390 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2019   grade_6 16 8 29 0   6     0   5   30 34                       64.0 16 8 29 0   6     0   5   30 34                 64
2047398 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2019   grade_6 29 13 19 0   2     0   3   37 29                       66.0 29 13 19 0   2     0   3   37 29                 66
2047406 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_6 19 9 8 0   3     0   4   24 19                       43.0 19 9 8 0   3     0   4   24 19                 43
2047414 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2019   grade_6 21 11 9 0   5     0   3   16 33                       49.0 21 11 9 0   5     0   3   16 33                 49
2047421 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2019   grade_6 25 8 17 0   0     0   1   29 22                       51.0 25 8 17 0   0     0   1   29 22                 51
2047428 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2019   grade_6 12 7 34 0   1     0   1   27 28                       55.0 12 7 34 0   1     0   1   27 28                 55

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