Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2015 sorted by multiracial_int

View and edit SQL

year

  • 2015 · 575

grade

  • grade_6 · 575
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int ▼ unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
736957 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
738475 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_6 * * * *   *     *   *   2 *                       3                         2                   3
738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
739319 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_6 * * * *   *     *   *   3 *                       3                         3                   3
740285 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
741675 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_6 * * * *   *     *   *   2 *                       2                         2                   2
735665 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_6 158 7 6 1   2     0   0   94 80                       174 158 7 6 1   2     0   0   94 80                 174
735680 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_6 113 1 1 0   1     0   0   55 61                       116 113 1 1 0   1     0   0   55 61                 116
736277 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_6 2 29 18 0   0     0   0   27 22                       49 2 29 18 0   0     0   0   27 22                 49
736297 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2015   grade_6 7 3 71 0   1     0   0   44 38                       82 7 3 71 0   1     0   0   44 38                 82
736337 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   grade_6 12 15 20 0   0     0   0   24 23                       47 12 15 20 0   0     0   0   24 23                 47
736380 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 06 2015   grade_6 7 22 60 1   1     1   0   49 43                       92 7 22 60 1   1     1   0   49 43                 92
736440 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_6 5 0 25 0   0     0   0   12 18                       30 5 0 25 0   0     0   0   12 18                 30
736505 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_6 0 7 34 0   1     0   0   24 18                       42 0 7 34 0   1     0   0   24 18                 42
736571 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_6 20 10 33 1   1     0   0   33 32                       65 20 10 33 1   1     0   0   33 32                 65
736636 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_6 0 12 30 0   0     0   0   21 21                       42 0 12 30 0   0     0   0   21 21                 42
736699 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_6 1 34 16 0   0     0   0   22 29                       51 1 34 16 0   0     0   0   22 29                 51
736734 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_6 0 15 9 0   2     0   0   13 13                       26 0 15 9 0   2     0   0   13 13                 26
736740 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_6 1 77 26 1   5     0   0   57 53                       110 1 77 26 1   5     0   0   57 53                 110
736760 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_6 4 4 10 0   0     0   0   13 5                       18 4 4 10 0   0     0   0   13 5                 18
736782 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2015   grade_6 15 13 86 0   7     0   0   69 52                       121 15 13 86 0   7     0   0   69 52                 121
736788 MA Suffolk   school 2502790 35   Boston 250279000345 350470 Wm B Rogers Middle   Regular School No 2 06 08 2015   grade_6 2 39 32 0   0     0   0   41 32                       73 2 39 32 0   0     0   0   41 32                 73
736947 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2015   grade_6 4 1 34 0   0     0   0   19 20                       39 4 1 34 0   0     0   0   19 20                 39
737058 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2015   grade_6 33 0 1 0   1     0   0   19 16                       35 33 0 1 0   1     0   0   19 16                 35
737449 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_6 158 0 0 0   0     1   0   81 78                       159 158 0 0 0   0     1   0   81 78                 159
737517 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_6 5 13 99 0   5     0   0   65 57                       122 5 13 99 0   5     0   0   65 57                 122
737606 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_6 17 0 1 0   0     0   0   7 11                       18 17 0 1 0   0     0   0   7 11                 18
737632 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_6 136 6 1 0   5     0   0   75 73                       148 136 6 1 0   5     0   0   75 73                 148
737669 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   grade_6 24 0 2 0   0     0   0   13 13                       26 24 0 2 0   0     0   0   13 13                 26
737938 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_6 34 1 2 2   0     0   0   17 22                       39 34 1 2 2   0     0   0   17 22                 39
738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738452 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No 2 04 06 2015   grade_6 52 1 5 0   3     0   0   35 26                       61 52 1 5 0   3     0   0   35 26                 61
738519 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
738532 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_6 218 1 5 0   7     0   0   119 112                       231 218 1 5 0   7     0   0   119 112                 231
738561 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   0     0   0   24 10                       34 34 0 0 0   0     0   0   24 10                 34
738589 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_6 110 6 20 0   3     0   0   71 68                       139 110 6 20 0   3     0   0   71 68                 139
738594 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_6 88 2 46 0   2     0   0   70 68                       138 88 2 46 0   2     0   0   70 68                 138
738619 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_6 97 1 29 0   1     0   0   74 54                       128 97 1 29 0   1     0   0   74 54                 128
738725 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_6 1 2 40 0   0     0   0   21 22                       43 1 2 40 0   0     0   0   21 22                 43
738730 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_6 4 0 67 0   0     0   0   36 35                       71 4 0 67 0   0     0   0   36 35                 71
738739 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_6 2 0 48 0   2     0   0   25 27                       52 2 0 48 0   2     0   0   25 27                 52
738748 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_6 7 0 34 0   0     0   0   16 25                       41 7 0 34 0   0     0   0   16 25                 41
738766 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_6 11 4 59 0   1     0   0   44 31                       75 11 4 59 0   1     0   0   44 31                 75
738878 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2015   grade_6 168 2 0 0   2     0   0   82 90                       172 168 2 0 0   2     0   0   82 90                 172
738907 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_6 1 1 88 0   3     0   0   53 40                       93 1 1 88 0   3     0   0   53 40                 93
738912 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_6 0 3 135 0   0     0   0   76 62                       138 0 3 135 0   0     0   0   76 62                 138
738947 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_6 1 1 102 0   1     0   0   52 53                       105 1 1 102 0   1     0   0   52 53                 105
738970 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No 2 05 07 2015   grade_6 12 1 133 0   6     0   0   64 88                       152 12 1 133 0   6     0   0   64 88                 152
738972 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2015   grade_6 0 1 99 0   0     0   0   55 45                       100 0 1 99 0   0     0   0   55 45                 100
739014 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_6 1 0 19 0   0     0   0   16 4                       20 1 0 19 0   0     0   0   16 4                 20
739033 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_6 54 0 3 0   1     0   0   25 33                       58 54 0 3 0   1     0   0   25 33                 58
739482 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_6 3 1 3 0   0     0   0   5 2                       7 3 1 3 0   0     0   0   5 2                 7
739897 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2015   grade_6 68 8 51 0   12     0   0   76 63                       139 68 8 51 0   12     0   0   76 63                 139
740031 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_6 101 1 0 0   0     0   0   48 54                       102 101 1 0 0   0     0   0   48 54                 102
740046 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_6 26 0 1 0   4     0   0   20 11                       31 26 0 1 0   4     0   0   20 11                 31
740779 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No 2 05 07 2015   grade_6 118 2 2 0   1     0   0   69 54                       123 118 2 2 0   1     0   0   69 54                 123
740860 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   grade_6 102 3 2 0   0     0   0   56 51                       107 102 3 2 0   0     0   0   56 51                 107
740889 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_6 15 0 0 0   0     0   0   7 8                       15 15 0 0 0   0     0   0   7 8                 15
740958 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2015   grade_6 78 2 3 0   2     0   0   47 38                       85 78 2 3 0   2     0   0   47 38                 85
741034 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   grade_6 36 0 0 0   0     0   0   22 14                       36 36 0 0 0   0     0   0   22 14                 36
741275 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_6 8 1 1 0   0     0   0   1 9                       10 8 1 1 0   0     0   0   1 9                 10
741329 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 0 0   0     0   0   4 10                       14 14 0 0 0   0     0   0   4 10                 14
741396 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   grade_6 62 1 0 0   5     0   0   39 29                       68 62 1 0 0   5     0   0   39 29                 68
741403 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_6 83 1 1 1   1     0   0   44 43                       87 83 1 1 1   1     0   0   44 43                 87
741470 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No 1 KG 06 2015   grade_6 51 2 1 0   0     0   0   35 19                       54 51 2 1 0   0     0   0   35 19                 54
741643 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   grade_6 22 3 18 0   3     0   0   23 23                       46 22 3 18 0   3     0   0   23 23                 46
741652 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   grade_6 14 5 40 0   3     0   0   37 25                       62 14 5 40 0   3     0   0   37 25                 62
741672 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2015   grade_6 16 5 27 0   5     0   0   29 24                       53 16 5 27 0   5     0   0   29 24                 53
741962 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_6 13 36 94 0   0     0   0   66 77                       143 13 36 94 0   0     0   0   66 77                 143
741971 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2015   grade_6 1 6 9 0   0     0   0   13 3                       16 1 6 9 0   0     0   0   13 3                 16
741980 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2015   grade_6 1 0 5 0   0     0   0   4 2                       6 1 0 5 0   0     0   0   4 2                 6
741986 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2015   grade_6 5 4 89 0   0     0   0   47 51                       98 5 4 89 0   0     0   0   47 51                 98
742369 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   5 16                       21 20 0 1 0   0     0   0   5 16                 21
742764 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2015   grade_6 23 0 0 0   0     0   0   9 14                       23 23 0 0 0   0     0   0   9 14                 23
742933 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 1 0   0     0   0   7 8                       15 14 0 1 0   0     0   0   7 8                 15
742941 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_6 25 0 3 1   1     0   0   14 16                       30 25 0 3 1   1     0   0   14 16                 30
743089 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_6 130 14 15 0   10     0   0   84 85                       169 130 14 15 0   10     0   0   84 85                 169
743122 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_6 3 6 43 0   6     0   0   38 20                       58 3 6 43 0   6     0   0   38 20                 58
743176 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_6 8 5 20 0   4     0   0   24 13                       37 8 5 20 0   4     0   0   24 13                 37
743183 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2015   grade_6 31 1 8 0   2     0   0   21 21                       42 31 1 8 0   2     0   0   21 21                 42
743245 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2015   grade_6 3 7 10 0   1     0   0   9 12                       21 3 7 10 0   1     0   0   9 12                 21
743420 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2015   grade_6 4 40 21 0   4     0   0   33 36                       69 4 40 21 0   4     0   0   33 36                 69
743475 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_6 0 29 9 0   0     0   0   16 22                       38 0 29 9 0   0     0   0   16 22                 38
743529 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_6 2 25 10 0   3     0   0   26 14                       40 2 25 10 0   3     0   0   26 14                 40
743545 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2015   grade_6 1 18 2 0   0     0   0   7 14                       21 1 18 2 0   0     0   0   7 14                 21
743567 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_6 2 0 46 0   0     0   0   26 22                       48 2 0 46 0   0     0   0   26 22                 48
743599 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2015   grade_6 7 20 12 0   3     0   0   25 17                       42 7 20 12 0   3     0   0   25 17                 42
743651 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 31 0 1 0   0     0   0   19 13                       32 31 0 1 0   0     0   0   19 13                 32
743673 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_6 1 0 55 0   0     0   0   26 30                       56 1 0 55 0   0     0   0   26 30                 56
743682 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 26 2 7 0   0     0   0   14 21                       35 26 2 7 0   0     0   0   14 21                 35
743699 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 07 2015   grade_6 8 11 24 1   1     0   0   21 24                       45 8 11 24 1   1     0   0   21 24                 45
743711 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2015   grade_6 45 0 2 0   1     0   0   23 25                       48 45 0 2 0   1     0   0   23 25                 48
743767 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_6 0 19 8 0   0     2   0   18 11                       29 0 19 8 0   0     2   0   18 11                 29
743805 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_6 27 0 2 0   2     0   0   18 13                       31 27 0 2 0   2     0   0   18 13                 31
743809 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_6 88 0 0 0   1     0   0   40 49                       89 88 0 0 0   1     0   0   40 49                 89
743820 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2015   grade_6 29 4 21 2   5     0   0   27 34                       61 29 4 21 2   5     0   0   27 34                 61
743984 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_6 90 5 0 0   1     0   0   56 40                       96 90 5 0 0   1     0   0   56 40                 96
744036 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_6 16 0 0 0   1     0   0   10 7                       17 16 0 0 0   1     0   0   10 7                 17
744141 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
744348 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No 1 KG 06 2015   grade_6 16 1 0 0   0     0   0   4 13                       17 16 1 0 0   0     0   0   4 13                 17

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