Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 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
1364870 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_6 29 3 20 0   6     0   3   34 27 *                     61.0 29 3 20 0   6     0   3   34 27                 61
1364877 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_6 26 6 11 0   5     0   2   18 32 *                     50.0 26 6 11 0   5     0   2   18 32                 50
1364884 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_6 32 6 8 0   5     0   6   29 28 *                     57.0 32 6 8 0   5     0   6   29 28                 57
1364973 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2020   grade_6 356 20 40 0   40     0   30   255 231 *                     486.0 356 20 40 0   40     0   30   255 231                 486
1365064 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_6 31 14 3 1   4     0   5   34 24 *                     58.0 31 14 3 1   4     0   5   34 24                 58
1365120 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2020   grade_6 158 2 6 1   2     0   3   82 90 *                     172.0 158 2 6 1   2     0   3   82 90                 172
1366079 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_6 90 1 3 0   6     0   7   56 51 *                     107.0 90 1 3 0   6     0   7   56 51                 107
1366141 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   grade_6 37 3 1 0   0     0   1   16 26 *                     42.0 37 3 1 0   0     0   1   16 26                 42
1366262 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 0 1 0   0     0   2   16 21 *                     37.0 34 0 1 0   0     0   2   16 21                 37
1366585 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_6 0 0 32 0   0     0   0   11 21 *                     32.0 0 0 32 0   0     0   0   11 21                 32
1366751 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2020   grade_6 14 1 1 0   0     0   0   10 6 *                     16.0 14 1 1 0   0     0   0   10 6                 16
1366855 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2020   grade_6 47 1 5 0   1     0   6   31 29 *                     60.0 47 1 5 0   1     0   6   31 29                 60
1366930 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2020   grade_6 154 7 6 1   2     0   7   104 73 *                     177.0 154 7 6 1   2     0   7   104 73                 177
1367026 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2020   grade_6 14 1 0 0   0     0   3   12 6 *                     18.0 14 1 0 0   0     0   3   12 6                 18
1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
1367468 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_6 112 1 1 0   0     1   1   59 57 *                     116.0 112 1 1 0   0     1   1   59 57                 116
1367524 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_6 83 2 8 1   6     0   4   65 39 *                     104.0 83 2 8 1   6     0   4   65 39                 104
1367529 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_6 108 2 10 0   20     0   1   68 73 *                     141.0 108 2 10 0   20     0   1   68 73                 141
1367543 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2020   grade_6 42 0 5 0   1     0   1   31 18 *                     49.0 42 0 5 0   1     0   1   31 18                 49
1367581 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2020   grade_6 35 1 7 0   2     1   2   20 28 *                     48.0 35 1 7 0   2     1   2   20 28                 48
1367594 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2020   grade_6 76 1 2 1   0     0   3   39 44 *                     83.0 76 1 2 1   0     0   3   39 44                 83
1367601 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1367637 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 1 3 0   0     0   0   17 21 *                     38.0 34 1 3 0   0     0   0   17 21                 38
1367710 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_6 6 2 19 0   0     0   0   15 12 *                     27.0 6 2 19 0   0     0   0   15 12                 27
1367774 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2020   grade_6 20 0 1 0   1     0   0   11 11 *                     22.0 20 0 1 0   1     0   0   11 11                 22
1367857 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 06 2020   grade_6 4 7 113 0   1     0   1   68 58 *                     126.0 4 7 113 0   1     0   1   68 58                 126
1367872 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2020   grade_6 71 1 10 0   1     1   2   45 41 *                     86.0 71 1 10 0   1     1   2   45 41                 86
1367959 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2020   grade_6 140 1 6 1   3     0   0   75 75 *                     151.0 140 1 6 1   3     0   0   75 75                 151
1368076 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2020   grade_6 29 0 5 0   3     0   1   15 22 *                     38.0 29 0 5 0   3     0   1   15 22                 38
1368164 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 2 0   0     0   0   9 6 *                     15.0 13 0 2 0   0     0   0   9 6                 15
1368706 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_6 167 4 15 0   3     0   8   95 102 *                     197.0 167 4 15 0   3     0   8   95 102                 197
1368726 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2020   grade_6 56 2 0 0   1     0   3   29 33 *                     62.0 56 2 0 0   1     0   3   29 33                 62
1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1368812 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No Middle 04 06 2020   grade_6 70 1 1 0   1     0   2   46 29 *                     75.0 70 1 1 0   1     0   2   46 29                 75
1369010 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   grade_6 84 1 10 0   5     0   8   51 57 *                     108.0 84 1 10 0   5     0   8   51 57                 108
1369036 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2020   grade_6 105 1 16 0   3     0   9   61 73 *                     134.0 105 1 16 0   3     0   9   61 73                 134
1369099 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_6 65 1 4 0   1     0   2   35 38 *                     73.0 65 1 4 0   1     0   2   35 38                 73
1369114 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2020   grade_6 15 0 0 0   0     0   0   6 9 *                     15.0 15 0 0 0   0     0   0   6 9                 15
1369200 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2020   grade_6 396 14 43 0   26     0   20   245 254 *                     499.0 396 14 43 0   26     0   20   245 254                 499
1369485 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2020   grade_6 124 1 3 0   1     0   3   73 59 *                     132.0 124 1 3 0   1     0   3   73 59                 132
1369497 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2020   grade_6 24 3 2 0   0     0   2   16 15 *                     31.0 24 3 2 0   0     0   2   16 15                 31
1369505 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2020   grade_6 24 1 2 0   0     1   4   17 15 *                     32.0 24 1 2 0   0     1   4   17 15                 32
1369513 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2020   grade_6 27 4 3 0   0     0   0   18 16 *                     34.0 27 4 3 0   0     0   0   18 16                 34
1369675 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 41 1 2 0   0     0   4   31 17 *                     48.0 41 1 2 0   0     0   4   31 17                 48
1369798 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2020   grade_6 87 2 9 0   1     0   0   49 50 *                     99.0 87 2 9 0   1     0   0   49 50                 99
1369908 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2020   grade_6 18 1 1 0   1     0   1   10 12 *                     22.0 18 1 1 0   1     0   1   10 12                 22
1369915 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2020   grade_6 68 0 0 0   0     0   2   27 43 *                     70.0 68 0 0 0   0     0   2   27 43                 70
1369922 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2020   grade_6 55 1 0 0   0     0   1   40 17 *                     57.0 55 1 0 0   0     0   1   40 17                 57
1369930 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2020   grade_6 70 0 1 0   1     0   1   33 40 *                     73.0 70 0 1 0   1     0   1   33 40                 73
1369944 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2020   grade_6 18 0 1 0   1     0   1   11 10 *                     21.0 18 0 1 0   1     0   1   11 10                 21
1370014 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2020   grade_6 90 2 15 1   4     0   3   55 60 *                     115.0 90 2 15 1   4     0   3   55 60                 115
1370089 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2020   grade_6 31 0 0 0   0     0   0   16 15 *                     31.0 31 0 0 0   0     0   0   16 15                 31
1370341 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No Elementary PK 06 2020   grade_6 60 0 1 0   0     0   7   36 32 *                     68.0 60 0 1 0   0     0   7   36 32                 68
1370387 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2020   grade_6 9 0 0 0   0     0   0   4 5 *                     9.0 9 0 0 0   0     0   0   4 5                 9
1370446 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_6 187 4 3 2   5     0   2   101 102 *                     203.0 187 4 3 2   5     0   2   101 102                 203
1370604 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2020   grade_6 257 10 43 2   171     0   21   253 251 *                     504.0 257 10 43 2   171     0   21   253 251                 504
1370616 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2020   grade_6 9 0 1 0   0     0   3   4 9 *                     13.0 9 0 1 0   0     0   3   4 9                 13
1370724 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No Elementary PK 06 2020   grade_6 68 0 2 1   1     0   1   36 37 *                     73.0 68 0 2 1   1     0   1   36 37                 73
1371155 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_6 119 2 8 1   2     0   3   81 54 *                     135.0 119 2 8 1   2     0   3   81 54                 135
1371191 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2020   grade_6 24 2 5 0   0     0   3   22 12 *                     34.0 24 2 5 0   0     0   3   22 12                 34
1371317 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2020   grade_6 234 8 9 1   4     0   3   131 128 *                     259.0 234 8 9 1   4     0   3   131 128                 259
1371339 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Middle 04 06 2020   grade_6 87 1 2 0   1     0   5   41 55 *                     96.0 87 1 2 0   1     0   5   41 55                 96
1371352 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1371421 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2020   grade_6 23 0 0 0   1     0   1   12 13 *                     25.0 23 0 0 0   1     0   1   12 13                 25
1371517 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2020   grade_6 88 2 8 0   0     0   3   55 46 *                     101.0 88 2 8 0   0     0   3   55 46                 101
1371685 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2020   grade_6 164 15 12 0   108     0   8   146 161 *                     307.0 164 15 12 0   108     0   8   146 161                 307
1371713 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2020   grade_6 85 7 2 1   1     1   11   50 58 *                     108.0 85 7 2 1   1     1   11   50 58                 108
1371752 MA Hampden   school 2512630 325   Westfield 251263002894 3250075 Westfield Intermediate School   Regular School No Middle 05 06 2020   grade_6 294 11 67 1   15     0   10   212 186 *                     398.0 294 11 67 1   15     0   10   212 186                 398
1371801 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2020   grade_6 16 0 0 0   0     0   0   6 10 *                     16.0 16 0 0 0   0     0   0   6 10                 16
1371828 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2020   grade_6 102 0 4 0   0     0   7   67 46 *                     113.0 102 0 4 0   0     0   7   67 46                 113
1371967 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2020   grade_6 16 0 1 0   0     0   0   9 8 *                     17.0 16 0 1 0   0     0   0   9 8                 17
1371975 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2020   grade_6 16 0 0 0   1     0   0   9 8 *                     17.0 16 0 0 0   1     0   0   9 8                 17
1372131 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_6 13 9 25 0   3     0   3   28 25 *                     53.0 13 9 25 0   3     0   3   28 25                 53
1372138 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_6 10 3 12 0   2     0   1   16 12 *                     28.0 10 3 12 0   2     0   1   16 12                 28
1372145 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_6 10 10 69 0   7     0   1   53 44 *                     97.0 10 10 69 0   7     0   1   53 44                 97
1372152 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_6 12 12 15 0   1     0   3   21 22 *                     43.0 12 12 15 0   1     0   3   21 22                 43
1372160 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_6 5 8 30 0   4     0   2   29 20 *                     49.0 5 8 30 0   4     0   2   29 20                 49
1372167 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_6 13 6 38 0   6     0   1   35 29 *                     64.0 13 6 38 0   6     0   1   35 29                 64
1372175 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_6 11 3 59 0   0     0   1   34 40 *                     74.0 11 3 59 0   0     0   1   34 40                 74
1372183 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_6 13 6 31 0   2     0   2   25 29 *                     54.0 13 6 31 0   2     0   2   25 29                 54
1372191 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_6 5 8 5 0   1     0   0   11 8 *                     19.0 5 8 5 0   1     0   0   11 8                 19
1372199 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_6 24 9 31 1   4     0   2   38 33 *                     71.0 24 9 31 1   4     0   2   38 33                 71
1372206 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_6 40 3 8 0   1     0   0   30 22 *                     52.0 40 3 8 0   1     0   0   30 22                 52
1372213 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary KG 06 2020   grade_6 11 12 28 0   1     0   2   29 25 *                     54.0 11 12 28 0   1     0   2   29 25                 54
1372221 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2020   grade_6 5 4 39 1   9     0   0   27 31 *                     58.0 5 4 39 1   9     0   0   27 31                 58
1372229 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2020   grade_6 19 14 29 0   10     0   4   39 37 *                     76.0 19 14 29 0   10     0   4   39 37                 76
1372236 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary KG 06 2020   grade_6 18 17 25 0   3     0   1   33 31 *                     64.0 18 17 25 0   3     0   1   33 31                 64
1372243 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2020   grade_6 18 3 8 0   2     0   2   19 14 *                     33.0 18 3 8 0   2     0   2   19 14                 33
1372251 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_6 7 13 17 0   0     0   1   20 18 *                     38.0 7 13 17 0   0     0   1   20 18                 38
1372258 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2020   grade_6 24 8 9 0   5     0   3   26 23 *                     49.0 24 8 9 0   5     0   3   26 23                 49
1372265 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary KG 06 2020   grade_6 3 3 9 0   2     0   0   3 14 *                     17.0 3 3 9 0   2     0   0   3 14                 17
1372272 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2020   grade_6 26 5 15 0   4     0   3   23 30 *                     53.0 26 5 15 0   4     0   3   23 30                 53
1372279 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary KG 06 2020   grade_6 13 1 12 0   0     0   1   11 16 *                     27.0 13 1 12 0   0     0   1   11 16                 27
1372286 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2020   grade_6 14 4 4 0   3     0   3   17 11 *                     28.0 14 4 4 0   3     0   3   17 11                 28
1372294 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary PK 06 2020   grade_6 40 8 9 0   4     0   4   35 30 *                     65.0 40 8 9 0   4     0   4   35 30                 65
1372302 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2020   grade_6 29 17 21 0   2     0   3   40 32 *                     72.0 29 17 21 0   2     0   3   40 32                 72
1372310 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2020   grade_6 37 20 42 0   8     0   4   57 54 *                     111.0 37 20 42 0   8     0   4   57 54                 111
1372317 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2020   grade_6 16 14 24 0   3     0   3   21 39 *                     60.0 16 14 24 0   3     0   3   21 39                 60
1372325 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2020   grade_6 43 17 23 0   2     0   5   51 39 *                     90.0 43 17 23 0   2     0   5   51 39                 90
1372333 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2020   grade_6 29 11 11 0   0     0   2   29 24 *                     53.0 29 11 11 0   0     0   2   29 24                 53

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