enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1367601 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
1367686 1367686 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1368368 1368368 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_6 * * * *   *     *   *   5 * *                     5.0                         5                   5
1368463 1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1370705 1370705 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1371352 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
1373782 1373782 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_6 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1366218 1366218 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_6 1 4 0 0   0     0   1   4 2 *                     6.0 1 4 0 0   0     0   1   4 2                 6
1366688 1366688 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_6 33 0 0 0   0     0   1   14 20 *                     34.0 33 0 0 0   0     0   1   14 20                 34
1367026 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
1367296 1367296 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_6 14 0 0 0   0     0   0   9 5 *                     14.0 14 0 0 0   0     0   0   9 5                 14
1367926 1367926 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2020   grade_6 60 0 0 0   0     0   1   36 25 *                     61.0 60 0 0 0   0     0   1   36 25                 61
1368726 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
1369114 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
1369362 1369362 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2020   grade_6 158 3 0 0   4     0   2   87 80 *                     167.0 158 3 0 0   4     0   2   87 80                 167
1369915 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 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
1370089 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
1370257 1370257 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_6 128 2 0 0   2     0   3   75 60 *                     135.0 128 2 0 0   2     0   3   75 60                 135
1370374 1370374 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2020   grade_6 68 0 0 0   2     0   0   43 27 *                     70.0 68 0 0 0   2     0   0   43 27                 70
1370387 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
1371421 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
1371801 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
1371975 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
1372423 1372423 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_6 10 0 0 0   0     0   1   5 6 *                     11.0 10 0 0 0   0     0   1   5 6                 11
1372708 1372708 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2020   grade_6 26 0 0 0   2     0   4   15 17 *                     32.0 26 0 0 0   2     0   4   15 17                 32
1373331 1373331 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 0 0   0     0   0   11 2 *                     13.0 13 0 0 0   0     0   0   11 2                 13
1373343 1373343 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_6 223 4 0 0   2     0   3   121 111 *                     232.0 223 4 0 0   2     0   3   121 111                 232
1373405 1373405 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2020   grade_6 26 0 0 0   0     0   1   15 12 *                     27.0 26 0 0 0   0     0   1   15 12                 27
1373486 1373486 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2020   grade_6 7 0 0 0   0     0   1   4 4 *                     8.0 7 0 0 0   0     0   1   4 4                 8
1373578 1373578 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2020   grade_6 23 1 0 0   0     0   0   15 9 *                     24.0 23 1 0 0   0     0   0   15 9                 24
1373768 1373768 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2020   grade_6 18 0 0 0   0     0   0   8 10 *                     18.0 18 0 0 0   0     0   0   8 10                 18
1373776 1373776 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   grade_6 22 0 0 0   0     0   0   12 10 *                     22.0 22 0 0 0   0     0   0   12 10                 22
1373934 1373934 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2020   grade_6 52 1 0 0   2     0   0   25 30 *                     55.0 52 1 0 0   2     0   0   25 30                 55
1373999 1373999 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_6 39 1 0 0   1     0   3   26 18 *                     44.0 39 1 0 0   1     0   3   26 18                 44
1365190 1365190 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_6 107 0 1 0   0     0   6   59 55 *                     114.0 107 0 1 0   0     0   6   59 55                 114
1366141 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 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
1366291 1366291 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary KG 08 2020   grade_6 42 2 1 0   15     0   4   36 28 *                     64.0 42 2 1 0   15     0   4   36 28                 64
1366713 1366713 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_6 128 4 1 0   1     0   0   67 67 *                     134.0 128 4 1 0   1     0   0   67 67                 134
1366751 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
1367468 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
1367774 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
1368812 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
1369742 1369742 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2020   grade_6 158 0 1 1   2     0   4   87 79 *                     166.0 158 0 1 1   2     0   4   87 79                 166
1369908 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
1369930 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 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
1370341 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
1370616 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
1371967 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
1372588 1372588 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2020   grade_6 2 21 1 0   2     0   2   11 17 *                     28.0 2 21 1 0   2     0   2   11 17                 28
1373184 1373184 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_6 145 15 1 0   5     0   5   92 79 *                     171.0 145 15 1 0   5     0   5   92 79                 171
1373512 1373512 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_6 117 0 1 0   0     0   0   61 57 *                     118.0 117 0 1 0   0     0   0   61 57                 118
1373601 1373601 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2020   grade_6 31 0 1 0   0     0   1   16 17 *                     33.0 31 0 1 0   0     0   1   16 17                 33
1373617 1373617 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2020   grade_6 11 0 1 0   0     0   1   5 8 *                     13.0 11 0 1 0   0     0   1   5 8                 13
1373886 1373886 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 25 0 1 0   0     0   2   13 15 *                     28.0 25 0 1 0   0     0   2   13 15                 28
1373926 1373926 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2020   grade_6 49 0 1 0   2     1   1   34 20 *                     54.0 49 0 1 0   2     1   1   34 20                 54
1374035 1374035 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 40 0 1 0   0     0   0   24 17 *                     41.0 40 0 1 0   0     0   0   24 17                 41
1366473 1366473 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2020   grade_6 41 16 10 1   11     0   8   35 52 *                     87.0 41 16 10 1   11     0   8   35 52                 87
1366503 1366503 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_6 205 29 10 1   24     2   20   145 146 *                     291.0 205 29 10 1   24     2   20   145 146                 291
1366979 1366979 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2020   grade_6 165 6 10 0   19     0   9   99 110 *                     209.0 165 6 10 0   19     0   9   99 110                 209
1367529 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
1367872 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
1367946 1367946 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_6 106 2 10 0   2     0   5   67 58 *                     125.0 106 2 10 0   2     0   5   67 58                 125
1369010 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
1369470 1369470 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2020   grade_6 137 18 10 0   65     0   10   126 114 *                     240.0 137 18 10 0   65     0   10   126 114                 240
1370069 1370069 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2020   grade_6 195 1 10 1   0     0   5   112 100 *                     212.0 195 1 10 1   0     0   5   112 100                 212
1370732 1370732 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2020   grade_6 84 2 10 0   24     0   8   65 63 *                     128.0 84 2 10 0   24     0   8   65 63                 128
1372047 1372047 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2020   grade_6 285 5 10 0   75     0   29   218 186 *                     404.0 285 5 10 0   75     0   29   218 186                 404
1372390 1372390 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_6 24 6 10 0   4     0   6   21 29 *                     50.0 24 6 10 0   4     0   6   21 29                 50
1372560 1372560 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_6 77 4 10 0   6     0   7   48 56 *                     104.0 77 4 10 0   6     0   7   48 56                 104
1372581 1372581 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_6 75 3 10 1   7     0   4   45 55 *                     100.0 75 3 10 1   7     0   4   45 55                 100
1372620 1372620 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_6 0 28 10 0   1     0   1   19 21 *                     40.0 0 28 10 0   1     0   1   19 21                 40
1373001 1373001 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2020   grade_6 61 3 10 0   9     0   8   47 44 *                     91.0 61 3 10 0   9     0   8   47 44                 91
1373121 1373121 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_6 62 0 10 0   3     0   4   42 37 *                     79.0 62 0 10 0   3     0   4   42 37                 79
1374286 1374286 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_6 35 5 10 0   3     0   6   31 28 *                     59.0 35 5 10 0   3     0   6   31 28                 59
1369021 1369021 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_6 197 12 100 8   8     0   12   181 156 *                     337.0 197 12 100 8   8     0   12   181 156                 337
1370995 1370995 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2020   grade_6 19 44 100 1   4     0   0   98 70 *                     168.0 19 44 100 1   4     0   0   98 70                 168
1372859 1372859 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_6 2 140 105 1   0     3   0   136 115 *                     251.0 2 140 105 1   0     3   0   136 115                 251
1368589 1368589 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_6 76 12 106 3   19     0   9   113 112 *                     225.0 76 12 106 3   19     0   9   113 112                 225
1367705 1367705 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_6 83 4 108 0   7     0   4   116 90 *                     206.0 83 4 108 0   7     0   4   116 90                 206
1370280 1370280 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2020   grade_6 87 9 109 0   10     0   6   133 88 *                     221.0 87 9 109 0   10     0   6   133 88                 221
1370309 1370309 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2020   grade_6 72 8 109 0   10     0   1   114 86 *                     200.0 72 8 109 0   10     0   1   114 86                 200
1364877 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
1365142 1365142 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_6 158 6 11 0   3     0   7   78 107 *                     185.0 158 6 11 0   3     0   7   78 107                 185
1366328 1366328 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_6 58 3 11 0   19     0   12   47 56 *                     103.0 58 3 11 0   19     0   12   47 56                 103
1366338 1366338 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_6 41 1 11 0   9     0   8   30 40 *                     70.0 41 1 11 0   9     0   8   30 40                 70
1368229 1368229 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_6 36 4 11 0   1     0   5   27 30 *                     57.0 36 4 11 0   1     0   5   27 30                 57
1368891 1368891 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2020   grade_6 157 4 11 0   7     1   6   74 112 *                     186.0 157 4 11 0   7     1   6   74 112                 186
1369461 1369461 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2020   grade_6 110 6 11 0   27     0   8   72 89 *                     162.0 110 6 11 0   27     0   8   72 89                 162
1369464 1369464 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2020   grade_6 181 3 11 1   58     0   9   138 125 *                     263.0 181 3 11 1   58     0   9   138 125                 263
1369651 1369651 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_6 117 4 11 0   21     1   5   78 81 *                     159.0 117 4 11 0   21     1   5   78 81                 159
1369835 1369835 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2020   grade_6 93 1 11 0   2     0   6   67 46 *                     113.0 93 1 11 0   2     0   6   67 46                 113
1370176 1370176 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 South West Middle School   Regular School No Middle 05 08 2020   grade_6 44 18 11 0   22     0   10   63 42 *                     105.0 44 18 11 0   22     0   10   63 42                 105
1370539 1370539 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2020   grade_6 111 4 11 0   13     0   5   72 72 *                     144.0 111 4 11 0   13     0   5   72 72                 144
1370663 1370663 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2020   grade_6 37 0 11 0   4     0   4   32 24 *                     56.0 37 0 11 0   4     0   4   32 24                 56
1371532 1371532 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_6 128 15 11 3   2     0   31   87 103 *                     190.0 128 15 11 3   2     0   31   87 103                 190
1372333 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]);