enrollments

Data source: Big Local News · About: Big Local

966 rows where grade = "grade_3", state = "MA" and year = 2017 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 966 ✖

grade ✖

  • grade_3 · 966 ✖
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
1122636 1122636 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 03 2017   grade_3 * * * *   *     *   *   4 1                       *                         4 1                  
1124655 1124655 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_3 * * * *   *     *   *   4 1                       *                         4 1                  
1124815 1124815 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_3 * * * *   *     *   *   3 *                       *                         3                    
1125189 1125189 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_3 * * * *   *     *   *   * *                       *                                              
1125263 1125263 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_3 * * * *   *     *   *   * *                       *                                              
1125318 1125318 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_3 * * * *   *     *   *   1 3                       *                         1 3                  
1126248 1126248 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_3 * * * *   *     *   *   1 *                       *                         1                    
1128616 1128616 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   grade_3 * * * *   *     *   *   2 2                       *                         2 2                  
1132404 1132404 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   grade_3 * * * *   *     *   *   1 1                       *                         1 1                  
1132609 1132609 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_3 * * * *   *     *   *   1 2                       *                         1 2                  
1121969 1121969 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_3 107 0 0 0   0     0   0   62 45                       107 107 0 0 0   0     0   0   62 45                 107
1121982 1121982 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_3 52 0 7 0   1     0   4   28 36                       64 52 0 7 0   1     0   4   28 36                 64
1121988 1121988 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   grade_3 71 0 7 0   4     0   4   43 43                       86 71 0 7 0   4     0   4   43 43                 86
1122089 1122089 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2017   grade_3 44 0 3 1   13     0   2   42 21                       63 44 0 3 1   13     0   2   42 21                 63
1122096 1122096 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_3 69 0 5 0   16     0   0   42 48                       90 69 0 5 0   16     0   0   42 48                 90
1122302 1122302 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_3 57 0 7 0   2     0   1   37 30                       67 57 0 7 0   2     0   1   37 30                 67
1122434 1122434 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2017   grade_3 107 0 1 0   0     0   4   55 57                       112 107 0 1 0   0     0   4   55 57                 112
1122446 1122446 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_3 23 0 2 0   1     0   0   16 10                       26 23 0 2 0   1     0   0   16 10                 26
1122469 1122469 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 05 2017   grade_3 53 0 4 0   0     0   2   36 23                       59 53 0 4 0   0     0   2   36 23                 59
1122513 1122513 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 05 2017   grade_3 50 0 1 0   2     0   0   29 24                       53 50 0 1 0   2     0   0   29 24                 53
1122534 1122534 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2017   grade_3 25 0 5 0   2     0   4   25 11                       36 25 0 5 0   2     0   4   25 11                 36
1122672 1122672 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_3 6 0 4 0   0     0   0   3 7                       10 6 0 4 0   0     0   0   3 7                 10
1122781 1122781 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2017   grade_3 4 0 37 0   2     0   1   25 19                       44 4 0 37 0   2     0   1   25 19                 44
1123435 1123435 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_3 4 0 45 0   0     0   1   21 29                       50 4 0 45 0   0     0   1   21 29                 50
1123465 1123465 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   grade_3 67 0 1 2   1     0   0   33 38                       71 67 0 1 2   1     0   0   33 38                 71
1123489 1123489 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_3 82 0 2 0   3     0   5   48 44                       92 82 0 2 0   3     0   5   48 44                 92
1123498 1123498 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_3 40 0 2 0   1     0   2   22 23                       45 40 0 2 0   1     0   2   22 23                 45
1123505 1123505 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2017   grade_3 57 0 5 0   10     0   2   41 33                       74 57 0 5 0   10     0   2   41 33                 74
1123717 1123717 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_3 33 0 3 0   0     0   2   16 22                       38 33 0 3 0   0     0   2   16 22                 38
1123834 1123834 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2017   grade_3 38 0 1 0   4     0   1   18 26                       44 38 0 1 0   4     0   1   18 26                 44
1124011 1124011 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_3 60 0 1 0   8     0   4   40 33                       73 60 0 1 0   8     0   4   40 33                 73
1124210 1124210 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_3 31 0 0 0   0     0   1   13 19                       32 31 0 0 0   0     0   1   13 19                 32
1124264 1124264 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No Elementary PK 05 2017   grade_3 62 0 7 0   4     0   8   48 33                       81 62 0 7 0   4     0   8   48 33                 81
1124283 1124283 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_3 15 0 1 0   0     0   0   11 5                       16 15 0 1 0   0     0   0   11 5                 16
1124352 1124352 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_3 90 0 1 0   2     0   6   39 60                       99 90 0 1 0   2     0   6   39 60                 99
1124405 1124405 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_3 41 0 5 0   1     0   5   25 27                       52 41 0 5 0   1     0   5   25 27                 52
1124415 1124415 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_3 76 0 0 0   1     0   3   42 38                       80 76 0 0 0   1     0   3   42 38                 80
1124520 1124520 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2017   grade_3 34 0 5 0   1     0   1   23 18                       41 34 0 5 0   1     0   1   23 18                 41
1124533 1124533 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No Elementary KG 04 2017   grade_3 19 0 0 0   1     0   0   14 6                       20 19 0 0 0   1     0   0   14 6                 20
1124611 1124611 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_3 14 0 0 0   0     0   3   11 6                       17 14 0 0 0   0     0   3   11 6                 17
1124693 1124693 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2017   grade_3 56 0 7 0   2     0   5   37 33                       70 56 0 7 0   2     0   5   37 33                 70
1124923 1124923 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_3 9 0 0 0   0     0   0   5 4                       9 9 0 0 0   0     0   0   5 4                 9
1124933 1124933 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2017   grade_3 48 0 3 0   1     1   0   25 28                       53 48 0 3 0   1     1   0   25 28                 53
1125149 1125149 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   grade_3 34 0 4 0   0     0   3   21 20                       41 34 0 4 0   0     0   3   21 20                 41
1125165 1125165 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_3 32 0 3 0   0     0   1   18 18                       36 32 0 3 0   0     0   1   18 18                 36
1125236 1125236 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No Elementary PK 03 2017   grade_3 38 0 5 0   1     0   2   29 17                       46 38 0 5 0   1     0   2   29 17                 46
1125295 1125295 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_3 37 0 4 0   1     1   2   22 23                       45 37 0 4 0   1     1   2   22 23                 45
1125333 1125333 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No Elementary 03 04 2017   grade_3 103 0 2 0   1     0   0   52 54                       106 103 0 2 0   1     0   0   52 54                 106
1125366 1125366 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_3 33 0 3 0   0     0   0   17 19                       36 33 0 3 0   0     0   0   17 19                 36
1125445 1125445 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_3 21 0 30 0   3     0   2   32 24                       56 21 0 30 0   3     0   2   32 24                 56
1125475 1125475 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No Elementary KG 05 2017   grade_3 81 0 4 0   1     0   3   42 47                       89 81 0 4 0   1     0   3   42 47                 89
1125548 1125548 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_3 15 0 24 0   1     0   3   25 18                       43 15 0 24 0   1     0   3   25 18                 43
1125633 1125633 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2017   grade_3 78 0 5 0   0     1   1   49 36                       85 78 0 5 0   0     1   1   49 36                 85
1125669 1125669 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2017   grade_3 42 0 3 0   1     0   2   26 22                       48 42 0 3 0   1     0   2   26 22                 48
1125682 1125682 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2017   grade_3 99 0 8 0   1     0   1   53 56                       109 99 0 8 0   1     0   1   53 56                 109
1125741 1125741 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2017   grade_3 136 0 4 1   1     0   0   72 70                       142 136 0 4 1   1     0   0   72 70                 142
1125772 1125772 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   grade_3 4 0 119 0   0     0   0   59 64                       123 4 0 119 0   0     0   0   59 64                 123
1125836 1125836 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2017   grade_3 8 0 123 1   0     0   2   65 69                       134 8 0 123 1   0     0   2   65 69                 134
1125841 1125841 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_3 1 0 79 0   0     0   0   38 42                       80 1 0 79 0   0     0   0   38 42                 80
1125880 1125880 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_3 1 0 7 0   0     0   0   7 1                       8 1 0 7 0   0     0   0   7 1                 8
1125900 1125900 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_3 29 0 5 0   2     0   1   15 22                       37 29 0 5 0   2     0   1   15 22                 37
1125934 1125934 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   grade_3 46 0 3 0   2     0   1   29 23                       52 46 0 3 0   2     0   1   29 23                 52
1126007 1126007 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_3 13 0 2 0   0     0   0   9 6                       15 13 0 2 0   0     0   0   9 6                 15
1126038 1126038 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2017   grade_3 51 0 2 0   27     0   10   43 47                       90 51 0 2 0   27     0   10   43 47                 90
1126113 1126113 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2017   grade_3 64 0 4 0   22     2   3   44 51                       95 64 0 4 0   22     2   3   44 51                 95
1126441 1126441 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2017   grade_3 16 0 3 1   0     0   3   11 12                       23 16 0 3 1   0     0   3   11 12                 23
1126623 1126623 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 02 03 2017   grade_3 77 0 7 0   2     0   2   44 44                       88 77 0 7 0   2     0   2   44 44                 88
1126650 1126650 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2017   grade_3 59 0 0 0   1     0   3   31 32                       63 59 0 0 0   1     0   3   31 32                 63
1126688 1126688 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2017   grade_3 36 0 0 0   0     0   1   26 11                       37 36 0 0 0   0     0   1   26 11                 37
1126695 1126695 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2017   grade_3 56 0 3 0   0     0   2   34 27                       61 56 0 3 0   0     0   2   34 27                 61
1126703 1126703 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No Elementary PK 05 2017   grade_3 43 0 0 0   1     1   0   21 24                       45 43 0 0 0   1     1   0   21 24                 45
1126710 1126710 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No Elementary KG 05 2017   grade_3 64 0 4 0   1     0   0   31 38                       69 64 0 4 0   1     0   0   31 38                 69
1126718 1126718 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No Elementary PK 05 2017   grade_3 60 0 2 1   4     0   0   34 33                       67 60 0 2 1   4     0   0   34 33                 67
1126753 1126753 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2017   grade_3 56 0 1 0   1     0   3   37 24                       61 56 0 1 0   1     0   3   37 24                 61
1126880 1126880 MA Middlesex   school 2507620 178   Melrose 250762001192 1780020 Lincoln   Regular School No Elementary KG 05 2017   grade_3 52 0 3 0   5     0   6   32 34                       66 52 0 3 0   5     0   6   32 34                 66
1126940 1126940 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_3 61 0 69 0   3     0   11   82 62                       144 61 0 69 0   3     0   11   82 62                 144
1127041 1127041 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 04 2017   grade_3 65 0 6 0   1     0   2   32 42                       74 65 0 6 0   1     0   2   32 42                 74
1127115 1127115 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_3 12 0 0 0   0     0   0   6 6                       12 12 0 0 0   0     0   0   6 6                 12
1127164 1127164 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2017   grade_3 68 0 3 0   6     0   0   35 42                       77 68 0 3 0   6     0   0   35 42                 77
1127207 1127207 MA Norfolk   school 2508370 199   Needham 250837001317 1990040 William Mitchell   Regular School No Elementary KG 05 2017   grade_3 68 0 3 0   6     0   3   40 40                       80 68 0 3 0   6     0   3   40 40                 80
1127477 1127477 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2017   grade_3 77 0 3 0   9     0   4   52 41                       93 77 0 3 0   9     0   4   52 41                 93
1127599 1127599 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No Elementary PK 05 2017   grade_3 21 0 7 0   1     0   3   22 10                       32 21 0 7 0   1     0   3   22 10                 32
1127614 1127614 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No Elementary PK 05 2017   grade_3 43 0 9 0   1     0   5   22 36                       58 43 0 9 0   1     0   5   22 36                 58
1127621 1127621 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No Elementary KG 05 2017   grade_3 25 0 6 0   2     0   3   19 17                       36 25 0 6 0   2     0   3   19 17                 36
1127703 1127703 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2017   grade_3 48 0 0 0   3     0   0   21 30                       51 48 0 0 0   3     0   0   21 30                 51
1127742 1127742 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No Elementary KG 05 2017   grade_3 20 0 2 0   7     0   2   21 10                       31 20 0 2 0   7     0   2   21 10                 31
1127759 1127759 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2017   grade_3 170 0 18 0   2     0   4   109 85                       194 170 0 18 0   2     0   4   109 85                 194
1127796 1127796 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No Elementary PK 05 2017   grade_3 41 0 3 0   5     0   2   22 29                       51 41 0 3 0   5     0   2   22 29                 51
1127810 1127810 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No Elementary PK 05 2017   grade_3 61 0 2 0   4     0   0   31 36                       67 61 0 2 0   4     0   0   31 36                 67
1127850 1127850 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No Elementary PK 05 2017   grade_3 68 0 0 1   0     0   2   39 32                       71 68 0 0 1   0     0   2   39 32                 71
1127858 1127858 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2017   grade_3 78 0 2 0   2     0   2   44 40                       84 78 0 2 0   2     0   2   44 40                 84
1127991 1127991 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2017   grade_3 51 0 2 0   1     0   2   28 28                       56 51 0 2 0   1     0   2   28 28                 56
1128013 1128013 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No Elementary PK 05 2017   grade_3 39 0 3 0   0     0   3   30 15                       45 39 0 3 0   0     0   3   30 15                 45
1128037 1128037 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2017   grade_3 31 0 1 0   0     0   0   15 17                       32 31 0 1 0   0     0   0   15 17                 32
1128053 1128053 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_3 19 0 0 0   1     0   0   8 12                       20 19 0 0 0   1     0   0   8 12                 20
1128061 1128061 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2017   grade_3 72 0 0 0   0     0   3   32 43                       75 72 0 0 0   0     0   3   32 43                 75
1128078 1128078 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2017   grade_3 74 0 1 0   1     0   2   34 44                       78 74 0 1 0   1     0   2   34 44                 78
1128094 1128094 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_3 14 0 0 0   1     0   1   7 9                       16 14 0 0 0   1     0   1   7 9                 16
1128117 1128117 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_3 26 0 2 0   0     0   5   16 17                       33 26 0 2 0   0     0   5   16 17                 33
1128192 1128192 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No Elementary KG 05 2017   grade_3 35 0 8 0   1     0   2   21 25                       46 35 0 8 0   1     0   2   21 25                 46

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