enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 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 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 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 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 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 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
736071 736071 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2015   grade_6 83 0 2 0   0     0   2   39 48                       87 83 0 2 0   0     0   2   39 48                 87
736440 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
737058 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 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
737606 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
737669 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
737773 737773 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2015   grade_6 64 0 1 1   0     0   2   35 33                       68 64 0 1 1   0     0   2   35 33                 68
737948 737948 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   1   6 8                       14 12 0 1 0   0     0   1   6 8                 14
738210 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
738380 738380 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_6 113 0 0 0   2     0   1   62 54                       116 113 0 0 0   2     0   1   62 54                 116
738418 738418 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_6 161 0 20 2   0     2   3   88 100                       188 161 0 20 2   0     2   3   88 100                 188
738498 738498 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_6 44 0 3 0   0     0   2   24 25                       49 44 0 3 0   0     0   2   24 25                 49
738519 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
738561 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
738715 738715 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_6 11 0 25 1   1     0   1   23 16                       39 11 0 25 1   1     0   1   23 16                 39
738730 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 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 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
738788 738788 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_6 84 0 1 1   4     0   1   46 45                       91 84 0 1 1   4     0   1   46 45                 91
738886 738886 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   1     0   2   14 23                       37 34 0 0 0   1     0   2   14 23                 37
738966 738966 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   grade_6 5 0 77 0   4     0   1   51 36                       87 5 0 77 0   4     0   1   51 36                 87
739014 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 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
739047 739047 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_6 99 0 10 0   2     0   1   62 50                       112 99 0 10 0   2     0   1   62 50                 112
739119 739119 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_6 15 0 0 0   0     0   2   7 10                       17 15 0 0 0   0     0   2   7 10                 17
739387 739387 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_6 111 0 4 2   0     0   1   71 47                       118 111 0 4 2   0     0   1   71 47                 118
739714 739714 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2015   grade_6 305 0 14 1   5     0   3   160 168                       328 305 0 14 1   5     0   3   160 168                 328
739764 739764 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2015   grade_6 184 0 3 0   8     0   7   104 98                       202 184 0 3 0   8     0   7   104 98                 202
739983 739983 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_6 104 0 2 0   6     1   4   78 39                       117 104 0 2 0   6     1   4   78 39                 117
740046 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
740298 740298 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No 2 06 08 2015   grade_6 173 0 3 0   4     0   5   94 91                       185 173 0 3 0   4     0   5   94 91                 185
740433 740433 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_6 27 0 0 0   0     0   4   17 14                       31 27 0 0 0   0     0   4   17 14                 31
740607 740607 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_6 172 0 10 0   3     1   7   104 89                       193 172 0 10 0   3     1   7   104 89                 193
740622 740622 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 31 0 3 0   0     0   5   19 20                       39 31 0 3 0   0     0   5   19 20                 39
740853 740853 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2015   grade_6 13 0 1 0   1     0   2   9 8                       17 13 0 1 0   1     0   2   9 8                 17
740867 740867 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2015   grade_6 61 0 0 0   1     0   1   36 27                       63 61 0 0 0   1     0   1   36 27                 63
740875 740875 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   grade_6 85 0 1 0   1     0   1   48 40                       88 85 0 1 0   1     0   1   48 40                 88
740889 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
741034 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
741042 741042 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_6 9 0 3 0   0     0   3   9 6                       15 9 0 3 0   0     0   3   9 6                 15
741329 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
741370 741370 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2015   grade_6 24 0 9 0   0     0   4   16 21                       37 24 0 9 0   0     0   4   16 21                 37
741410 741410 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_6 75 0 1 2   2     0   1   40 41                       81 75 0 1 2   2     0   1   40 41                 81
741463 741463 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No 1 KG 06 2015   grade_6 62 0 0 0   0     0   2   26 38                       64 62 0 0 0   0     0   2   26 38                 64
741584 741584 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 4 0   0     0   2   13 13                       26 20 0 4 0   0     0   2   13 13                 26
741702 741702 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2015   grade_6 122 0 5 0   21     1   4   81 72                       153 122 0 5 0   21     1   4   81 72                 153
741980 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
742107 742107 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_6 121 0 7 0   1     0   2   63 68                       131 121 0 7 0   1     0   2   63 68                 131
742143 742143 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_6 22 0 2 0   3     0   1   13 15                       28 22 0 2 0   3     0   1   13 15                 28
742290 742290 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No 2 04 06 2015   grade_6 79 0 3 0   3     0   1   40 46                       86 79 0 3 0   3     0   1   40 46                 86
742369 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 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 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 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
743017 743017 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2015   grade_6 303 0 11 0   51     0   8   182 191                       373 303 0 11 0   51     0   8   182 191                 373
743152 743152 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_6 3 0 50 0   5     0   1   32 27                       59 3 0 50 0   5     0   1   32 27                 59
743518 743518 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_6 72 0 5 0   1     0   2   30 50                       80 72 0 5 0   1     0   2   30 50                 80
743567 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
743634 743634 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 31 0 1 0   15     0   3   31 19                       50 31 0 1 0   15     0   3   31 19                 50
743651 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 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
743711 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
743805 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 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
744036 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 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
744252 744252 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_6 169 0 18 0   2     0   6   98 97                       195 169 0 18 0   2     0   6   98 97                 195
744287 744287 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2015   grade_6 242 0 4 0   2     0   4   133 119                       252 242 0 4 0   2     0   4   133 119                 252
744316 744316 MA Hampshire   school 2505160 672   Gateway 250516002666 6720410 Gateway Regional Middle School   Regular School No 2 05 06 2015   grade_6 74 0 6 0   0     0   1   45 36                       81 74 0 6 0   0     0   1   45 36                 81
744428 744428 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2015   grade_6 18 0 0 1   0     0   0   8 11                       19 18 0 0 1   0     0   0   8 11                 19
744454 744454 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2015   grade_6 127 0 1 0   3     0   1   57 75                       132 127 0 1 0   3     0   1   57 75                 132
744529 744529 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No 1 PK 06 2015   grade_6 12 0 0 0   0     0   2   9 5                       14 12 0 0 0   0     0   2   9 5                 14
744537 744537 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   14 7                       21 20 0 1 0   0     0   0   14 7                 21
744544 744544 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   0   8 5                       13 12 0 1 0   0     0   0   8 5                 13
744551 744551 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 KG 06 2015   grade_6 23 0 1 0   0     0   0   12 12                       24 23 0 1 0   0     0   0   12 12                 24
744604 744604 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2015   grade_6 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88
744619 744619 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No 1 PK 06 2015   grade_6 19 0 1 0   0     0   2   9 13                       22 19 0 1 0   0     0   2   9 13                 22
744699 744699 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 3 0   1     0   1   26 13                       39 34 0 3 0   1     0   1   26 13                 39
744713 744713 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 2 0   0     0   0   12 11                       23 21 0 2 0   0     0   0   12 11                 23
744719 744719 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2015   grade_6 10 0 0 0   0     0   0   2 8                       10 10 0 0 0   0     0   0   2 8                 10
744732 744732 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_6 29 0 0 0   0     0   1   22 8                       30 29 0 0 0   0     0   1   22 8                 30
744739 744739 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_6 58 0 3 0   0     0   0   27 34                       61 58 0 3 0   0     0   0   27 34                 61
744747 744747 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_6 46 0 1 0   0     0   0   21 26                       47 46 0 1 0   0     0   0   21 26                 47
744754 744754 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_6 54 0 0 0   1     0   1   21 35                       56 54 0 0 0   1     0   1   21 35                 56
744820 744820 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_6 12 0 1 0   0     1   1   7 8                       15 12 0 1 0   0     1   1   7 8                 15
744872 744872 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2015   grade_6 58 0 4 1   1     0   1   32 33                       65 58 0 4 1   1     0   1   32 33                 65
744880 744880 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2015   grade_6 66 0 3 1   1     0   0   40 31                       71 66 0 3 1   1     0   0   40 31                 71
744888 744888 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No 1 PK 06 2015   grade_6 72 0 2 0   0     0   0   39 35                       74 72 0 2 0   0     0   0   39 35                 74
744954 744954 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_6 48 0 2 0   2     0   1   28 25                       53 48 0 2 0   2     0   1   28 25                 53
744982 744982 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2015   grade_6 76 0 5 0   0     0   1   37 45                       82 76 0 5 0   0     0   1   37 45                 82
744990 744990 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 49 0 0 0   0     0   0   28 21                       49 49 0 0 0   0     0   0   28 21                 49
735680 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
735792 735792 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2015   grade_6 150 1 9 0   24     0   6   90 100                       190 150 1 9 0   24     0   6   90 100                 190
735927 735927 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_6 173 1 4 1   9     0   3   90 101                       191 173 1 4 1   9     0   3   90 101                 191

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