enrollments

Data source: Big Local News · About: Big Local

577 rows where grade = "grade_6", state = "MA" and year = 2017 sorted by multiracial

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 577 ✖

grade ✖

  • grade_6 · 577 ✖
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
1122675 1122675 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1124818 1124818 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_6 * * * *   *     *   *   5 *                       *                         5                    
1124926 1124926 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1125192 1125192 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125266 1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
1126251 1126251 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_6 * * * *   *     *   *   4 *                       *                         4                    
1126511 1126511 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1129008 1129008 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1130462 1130462 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1131923 1131923 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1132002 1132002 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_6 * * * *   *     *   *   1 3                       *                         1 3                  
1122749 1122749 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_6 8 21 23 0   2     0   0   26 28                       54 8 21 23 0   2     0   0   26 28                 54
1122902 1122902 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_6 33 7 8 0   9     0   0   31 26                       57 33 7 8 0   9     0   0   31 26                 57
1122945 1122945 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_6 0 4 22 0   0     0   0   14 12                       26 0 4 22 0   0     0   0   14 12                 26
1122990 1122990 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_6 15 3 3 0   1     0   0   10 12                       22 15 3 3 0   1     0   0   10 12                 22
1123019 1123019 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_6 31 11 21 0   1     0   0   34 30                       64 31 11 21 0   1     0   0   34 30                 64
1123137 1123137 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_6 3 7 5 1   0     0   0   15 1                       16 3 7 5 1   0     0   0   15 1                 16
1123160 1123160 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_6 1 24 12 0   0     0   0   19 18                       37 1 24 12 0   0     0   0   19 18                 37
1123190 1123190 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_6 1 27 14 0   0     0   0   20 22                       42 1 27 14 0   0     0   0   20 22                 42
1123220 1123220 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_6 0 30 15 0   0     0   0   24 21                       45 0 30 15 0   0     0   0   24 21                 45
1123231 1123231 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_6 4 2 10 1   0     0   0   9 8                       17 4 2 10 1   0     0   0   9 8                 17
1123266 1123266 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2017   grade_6 1 27 66 0   5     0   0   41 58                       99 1 27 66 0   5     0   0   41 58                 99
1123438 1123438 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_6 0 0 31 0   0     0   0   9 22                       31 0 0 31 0   0     0   0   9 22                 31
1123447 1123447 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_6 0 3 3 0   0     0   0   2 4                       6 0 3 3 0   0     0   0   2 4                 6
1123575 1123575 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_6 32 2 0 0   0     0   0   18 16                       34 32 2 0 0   0     0   0   18 16                 34
1124026 1124026 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_6 137 1 2 0   1     0   0   62 79                       141 137 1 2 0   1     0   0   62 79                 141
1124110 1124110 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_6 9 6 125 0   2     0   0   69 73                       142 9 6 125 0   2     0   0   69 73                 142
1124213 1124213 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_6 16 0 0 0   0     0   0   7 9                       16 16 0 0 0   0     0   0   7 9                 16
1124225 1124225 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_6 93 5 24 0   1     0   0   74 49                       123 93 5 24 0   1     0   0   74 49                 123
1124286 1124286 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_6 26 0 0 0   0     0   0   14 12                       26 26 0 0 0   0     0   0   14 12                 26
1124408 1124408 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_6 57 0 2 0   1     0   0   30 30                       60 57 0 2 0   1     0   0   30 30                 60
1124614 1124614 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 1 0   0     0   0   6 6                       12 11 0 1 0   0     0   0   6 6                 12
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1125313 1125313 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2017   grade_6 82 0 3 0   1     0   0   51 35                       86 82 0 3 0   1     0   0   51 35                 86
1125337 1125337 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_6 172 1 2 0   5     0   0   91 89                       180 172 1 2 0   5     0   0   91 89                 180
1125354 1125354 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_6 58 3 2 0   9     0   0   41 31                       72 58 3 2 0   9     0   0   41 31                 72
1125369 1125369 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_6 27 0 4 0   0     0   0   17 14                       31 27 0 4 0   0     0   0   17 14                 31
1125439 1125439 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_6 79 4 33 0   2     0   0   53 65                       118 79 4 33 0   2     0   0   53 65                 118
1125519 1125519 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_6 33 0 1 0   1     0   0   13 22                       35 33 0 1 0   1     0   0   13 22                 35
1125551 1125551 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_6 13 1 23 0   0     0   0   19 18                       37 13 1 23 0   0     0   0   19 18                 37
1125562 1125562 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_6 0 2 38 0   0     0   0   21 19                       40 0 2 38 0   0     0   0   21 19                 40
1125568 1125568 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_6 6 2 72 0   0     0   0   44 36                       80 6 2 72 0   0     0   0   44 36                 80
1125578 1125578 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_6 2 0 39 0   0     0   0   22 19                       41 2 0 39 0   0     0   0   22 19                 41
1125703 1125703 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2017   grade_6 63 0 0 0   0     0   0   37 26                       63 63 0 0 0   0     0   0   37 26                 63
1125753 1125753 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_6 22 0 0 0   0     0   0   10 12                       22 22 0 0 0   0     0   0   10 12                 22
1125781 1125781 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_6 6 0 88 0   3     0   0   48 49                       97 6 0 88 0   3     0   0   48 49                 97
1125812 1125812 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_6 3 0 143 0   0     0   0   77 69                       146 3 0 143 0   0     0   0   77 69                 146
1125829 1125829 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_6 3 1 121 0   0     0   0   63 62                       125 3 1 121 0   0     0   0   63 62                 125
1125851 1125851 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_6 2 1 80 0   5     0   0   44 44                       88 2 1 80 0   5     0   0   44 44                 88
1125859 1125859 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_6 2 0 80 0   0     0   0   45 37                       82 2 0 80 0   0     0   0   45 37                 82
1125883 1125883 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_6 2 0 13 0   0     0   0   13 2                       15 2 0 13 0   0     0   0   13 2                 15
1126451 1126451 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_6 3 3 3 0   0     0   0   7 *                       9 3 3 3 0   0     0   0   7                   9
1126567 1126567 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   grade_6 20 14 22 0   8     0   0   34 30                       64 20 14 22 0   8     0   0   34 30                 64
1127102 1127102 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_6 54 0 1 1   0     0   0   28 28                       56 54 0 1 1   0     0   0   28 28                 56
1127118 1127118 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_6 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
1127927 1127927 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2017   grade_6 74 1 5 0   0     0   0   43 37                       80 74 1 5 0   0     0   0   43 37                 80
1128064 1128064 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2017   grade_6 87 3 0 0   0     0   0   47 43                       90 87 3 0 0   0     0   0   47 43                 90
1128072 1128072 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2017   grade_6 74 0 0 0   1     0   0   42 33                       75 74 0 0 0   1     0   0   42 33                 75
1128081 1128081 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2017   grade_6 79 1 1 0   2     0   0   44 39                       83 79 1 1 0   2     0   0   44 39                 83
1128269 1128269 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_6 32 0 0 0   0     0   0   11 21                       32 32 0 0 0   0     0   0   11 21                 32
1128761 1128761 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No Elementary KG 06 2017   grade_6 45 2 2 0   0     0   0   24 25                       49 45 2 2 0   0     0   0   24 25                 49
1128777 1128777 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No Elementary KG 06 2017   grade_6 92 0 1 0   2     0   0   43 52                       95 92 0 1 0   2     0   0   43 52                 95
1128786 1128786 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No Elementary PK 06 2017   grade_6 42 1 1 0   0     0   0   23 21                       44 42 1 1 0   0     0   0   23 21                 44
1128972 1128972 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_6 22 2 18 0   5     0   0   26 21                       47 22 2 18 0   5     0   0   26 21                 47
1129004 1129004 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_6 14 6 30 0   6     0   0   24 32                       56 14 6 30 0   6     0   0   24 32                 56
1129330 1129330 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_6 22 24 60 0   1     0   0   55 52                       107 22 24 60 0   1     0   0   55 52                 107
1129357 1129357 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2017   grade_6 1 7 9 0   0     0   0   16 1                       17 1 7 9 0   0     0   0   16 1                 17
1129361 1129361 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2017   grade_6 13 22 62 0   2     0   0   66 33                       99 13 22 62 0   2     0   0   66 33                 99
1129369 1129369 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_6 0 1 6 0   0     0   0   4 3                       7 0 1 6 0   0     0   0   4 3                 7
1129373 1129373 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_6 1 9 83 0   0     0   0   40 53                       93 1 9 83 0   0     0   0   40 53                 93
1129377 1129377 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_6 4 17 90 0   0     0   0   50 61                       111 4 17 90 0   0     0   0   50 61                 111
1129385 1129385 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   grade_6 3 18 36 0   0     0   0   10 47                       57 3 18 36 0   0     0   0   10 47                 57
1129745 1129745 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_6 20 0 9 0   0     0   0   19 10                       29 20 0 9 0   0     0   0   19 10                 29
1129766 1129766 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_6 8 0 1 0   0     0   0   3 6                       9 8 0 1 0   0     0   0   3 6                 9
1130193 1130193 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Elementary 04 06 2017   grade_6 85 2 6 0   0     0   0   55 38                       93 85 2 6 0   0     0   0   55 38                 93
1130317 1130317 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_6 16 0 1 0   0     0   0   6 11                       17 16 0 1 0   0     0   0   6 11                 17
1130523 1130523 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   14 6                       20 19 0 1 0   0     0   0   14 6                 20
1130532 1130532 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_6 25 0 0 0   0     0   0   16 9                       25 25 0 0 0   0     0   0   16 9                 25
1130757 1130757 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_6 3 7 57 0   8     0   0   41 34                       75 3 7 57 0   8     0   0   41 34                 75
1130774 1130774 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_6 7 6 24 0   6     0   0   18 25                       43 7 6 24 0   6     0   0   18 25                 43
1130808 1130808 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_6 2 11 15 0   0     0   0   21 7                       28 2 11 15 0   0     0   0   21 7                 28
1130861 1130861 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   grade_6 9 4 14 0   1     0   0   14 14                       28 9 4 14 0   1     0   0   14 14                 28
1130869 1130869 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   grade_6 21 3 5 0   5     0   0   15 19                       34 21 3 5 0   5     0   0   15 19                 34
1131076 1131076 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_6 8 0 0 0   0     0   0   3 5                       8 8 0 0 0   0     0   0   3 5                 8
1131111 1131111 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_6 26 16 120 5   2     2   0   79 92                       171 26 16 120 5   2     2   0   79 92                 171
1131169 1131169 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2017   grade_6 0 46 18 1   1     2   0   44 24                       68 0 46 18 1   1     2   0   44 24                 68
1131251 1131251 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes Other 06 12 2017   grade_6 2 21 7 1   2     0   0   12 21                       33 2 21 7 1   2     0   0   12 21                 33
1131271 1131271 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_6 0 17 3 0   0     0   0   11 9                       20 0 17 3 0   0     0   0   11 9                 20
1131297 1131297 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_6 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20
1131405 1131405 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_6 0 0 55 0   0     0   0   25 30                       55 0 0 55 0   0     0   0   25 30                 55
1131445 1131445 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_6 43 3 2 1   1     0   0   30 20                       50 43 3 2 1   1     0   0   30 20                 50
1131672 1131672 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2017   grade_6 7 24 57 0   1     0   0   39 50                       89 7 24 57 0   1     0   0   39 50                 89
1131692 1131692 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_6 43 2 2 0   23     0   0   37 33                       70 43 2 2 0   23     0   0   37 33                 70
1131811 1131811 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   grade_6 20 1 0 0   0     0   0   9 12                       21 20 1 0 0   0     0   0   9 12                 21
1131865 1131865 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No Other 06 12 2017   grade_6 79 1 5 0   3     0   0   51 37                       88 79 1 5 0   3     0   0   51 37                 88
1131940 1131940 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   11 9                       20 19 0 1 0   0     0   0   11 9                 20
1132093 1132093 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   0     0   0   3 8                       11 11 0 0 0   0     0   0   3 8                 11
1132276 1132276 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_6 7 0 0 1   0     0   0   3 5                       8 7 0 0 1   0     0   0   3 5                 8
1132390 1132390 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2017   grade_6 24 0 1 0   0     0   0   8 17                       25 24 0 1 0   0     0   0   8 17                 25

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