enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1124814 1124814 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1124922 1124922 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_2 * * * *   *     *   *   2 3                       *                         2 3                  
1125188 1125188 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125262 1125262 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125317 1125317 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_2 * * * *   *     *   *   2 1                       *                         2 1                  
1125422 1125422 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_2 * * * *   *     *   *   4 1                       *                         4 1                  
1126247 1126247 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126349 1126349 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_2 * * * *   *     *   *   1 1                       *                         1 1                  
1121981 1121981 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   grade_2 53 0 11 0   1     0   1   39 27                       66 53 0 11 0   1     0   1   39 27                 66
1122095 1122095 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2017   grade_2 50 0 2 0   16     0   0   41 27                       68 50 0 2 0   16     0   0   41 27                 68
1122170 1122170 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_2 44 0 4 0   8     0   2   31 27                       58 44 0 4 0   8     0   2   31 27                 58
1122372 1122372 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No Elementary KG 03 2017   grade_2 89 0 2 0   2     0   1   47 47                       94 89 0 2 0   2     0   1   47 47                 94
1122397 1122397 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2017   grade_2 64 0 3 0   24     0   5   51 45                       96 64 0 3 0   24     0   5   51 45                 96
1122433 1122433 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2017   grade_2 86 0 1 0   0     0   3   48 42                       90 86 0 1 0   0     0   3   48 42                 90
1122445 1122445 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_2 20 0 0 0   0     0   0   14 6                       20 20 0 0 0   0     0   0   14 6                 20
1122512 1122512 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No Elementary KG 05 2017   grade_2 45 0 2 0   1     0   3   25 26                       51 45 0 2 0   1     0   3   25 26                 51
1122663 1122663 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_2 11 0 41 0   1     0   0   27 26                       53 11 0 41 0   1     0   0   27 26                 53
1122671 1122671 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_2 5 0 9 0   0     0   2   9 7                       16 5 0 9 0   0     0   2   9 7                 16
1122780 1122780 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No Elementary PK 05 2017   grade_2 1 0 39 0   1     0   1   20 22                       42 1 0 39 0   1     0   1   20 22                 42
1122917 1122917 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2017   grade_2 15 0 19 0   4     0   1   18 21                       39 15 0 19 0   4     0   1   18 21                 39
1123405 1123405 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_2 3 0 65 0   1     0   0   30 39                       69 3 0 65 0   1     0   0   30 39                 69
1123487 1123487 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2017   grade_2 78 0 1 0   6     0   3   52 36                       88 78 0 1 0   6     0   3   52 36                 88
1123497 1123497 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_2 32 0 1 0   2     0   1   12 24                       36 32 0 1 0   2     0   1   12 24                 36
1123504 1123504 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2017   grade_2 64 0 1 0   10     0   1   40 36                       76 64 0 1 0   10     0   1   40 36                 76
1123520 1123520 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2017   grade_2 38 0 2 0   17     0   0   26 31                       57 38 0 2 0   17     0   0   26 31                 57
1123526 1123526 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_2 57 0 4 0   27     0   2   43 47                       90 57 0 4 0   27     0   2   43 47                 90
1123716 1123716 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 37 0 0 0   0     0   2   19 20                       39 37 0 0 0   0     0   2   19 20                 39
1124010 1124010 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_2 38 0 2 0   7     0   7   32 22                       54 38 0 2 0   7     0   7   32 22                 54
1124044 1124044 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2017   grade_2 50 0 3 0   15     0   5   47 26                       73 50 0 3 0   15     0   5   47 26                 73
1124056 1124056 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2017   grade_2 77 0 6 1   6     0   6   52 44                       96 77 0 6 1   6     0   6   52 44                 96
1124156 1124156 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_2 21 0 7 0   0     0   2   16 14                       30 21 0 7 0   0     0   2   16 14                 30
1124209 1124209 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_2 18 0 1 0   0     0   0   11 8                       19 18 0 1 0   0     0   0   11 8                 19
1124263 1124263 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No Elementary PK 05 2017   grade_2 56 0 2 0   5     0   7   39 31                       70 56 0 2 0   5     0   7   39 31                 70
1124270 1124270 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No Elementary PK 05 2017   grade_2 59 0 3 0   3     0   6   38 33                       71 59 0 3 0   3     0   6   38 33                 71
1124282 1124282 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_2 14 0 1 0   0     0   0   10 5                       15 14 0 1 0   0     0   0   10 5                 15
1124312 1124312 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No Elementary KG 05 2017   grade_2 33 0 8 0   2     0   1   23 21                       44 33 0 8 0   2     0   1   23 21                 44
1124404 1124404 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_2 44 0 4 0   0     0   4   27 25                       52 44 0 4 0   0     0   4   27 25                 52
1124414 1124414 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_2 82 0 0 0   0     0   1   45 38                       83 82 0 0 0   0     0   1   45 38                 83
1124481 1124481 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2017   grade_2 156 0 2 0   2     0   16   94 82                       176 156 0 2 0   2     0   16   94 82                 176
1124512 1124512 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_2 23 0 0 1   0     0   1   9 16                       25 23 0 0 1   0     0   1   9 16                 25
1124610 1124610 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_2 8 0 0 0   0     0   3   3 8                       11 8 0 0 0   0     0   3   3 8                 11
1124782 1124782 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No Elementary KG 05 2017   grade_2 41 0 1 0   1     0   8   29 22                       51 41 0 1 0   1     0   8   29 22                 51
1124852 1124852 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   grade_2 65 0 3 0   2     0   4   35 39                       74 65 0 3 0   2     0   4   35 39                 74
1125048 1125048 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2017   grade_2 47 0 0 0   3     0   1   24 27                       51 47 0 0 0   3     0   1   24 27                 51
1125055 1125055 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2017   grade_2 46 0 3 0   4     0   2   26 29                       55 46 0 3 0   4     0   2   26 29                 55
1125069 1125069 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   grade_2 54 0 2 0   4     1   0   33 28                       61 54 0 2 0   4     1   0   33 28                 61
1125076 1125076 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   grade_2 40 0 0 0   0     0   0   22 18                       40 40 0 0 0   0     0   0   22 18                 40
1125141 1125141 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2017   grade_2 47 0 9 1   2     0   1   36 24                       60 47 0 9 1   2     0   1   36 24                 60
1125148 1125148 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2017   grade_2 33 0 4 0   0     0   2   26 13                       39 33 0 4 0   0     0   2   26 13                 39
1125157 1125157 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_2 34 0 0 0   0     0   0   17 17                       34 34 0 0 0   0     0   0   17 17                 34
1125164 1125164 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_2 24 0 4 0   0     0   0   12 16                       28 24 0 4 0   0     0   0   12 16                 28
1125171 1125171 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2017   grade_2 49 0 6 0   2     0   0   29 28                       57 49 0 6 0   2     0   0   29 28                 57
1125208 1125208 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_2 112 0 8 0   9     0   6   68 67                       135 112 0 8 0   9     0   6   68 67                 135
1125235 1125235 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No Elementary PK 03 2017   grade_2 40 0 1 1   0     0   2   15 29                       44 40 0 1 1   0     0   2   15 29                 44
1125255 1125255 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2017   grade_2 39 0 6 0   0     0   0   18 27                       45 39 0 6 0   0     0   0   18 27                 45
1125331 1125331 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2017   grade_2 114 0 1 0   2     0   2   60 59                       119 114 0 1 0   2     0   2   60 59                 119
1125365 1125365 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_2 30 0 3 0   0     0   0   19 14                       33 30 0 3 0   0     0   0   19 14                 33
1125436 1125436 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2017   grade_2 38 0 7 0   1     0   1   30 17                       47 38 0 7 0   1     0   1   30 17                 47
1125515 1125515 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_2 26 0 3 0   0     0   0   16 13                       29 26 0 3 0   0     0   0   16 13                 29
1125547 1125547 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_2 17 0 32 0   2     0   1   25 27                       52 17 0 32 0   2     0   1   25 27                 52
1125616 1125616 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2017   grade_2 6 0 60 0   1     1   1   41 28                       69 6 0 60 0   1     1   1   41 28                 69
1125681 1125681 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2017   grade_2 64 0 8 0   3     0   0   40 35                       75 64 0 8 0   3     0   0   40 35                 75
1125715 1125715 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2017   grade_2 53 0 2 0   4     0   0   32 27                       59 53 0 2 0   4     0   0   32 27                 59
1125771 1125771 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   grade_2 1 0 118 0   0     0   0   57 62                       119 1 0 118 0   0     0   0   57 62                 119
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1125840 1125840 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_2 1 0 75 0   0     0   0   45 31                       76 1 0 75 0   0     0   0   45 31                 76
1125847 1125847 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_2 4 0 62 0   1     0   0   27 40                       67 4 0 62 0   1     0   0   27 40                 67
1125879 1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1125899 1125899 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_2 37 0 8 0   2     0   0   32 15                       47 37 0 8 0   2     0   0   32 15                 47
1125933 1125933 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   grade_2 35 0 3 0   3     0   0   25 16                       41 35 0 3 0   3     0   0   25 16                 41
1126044 1126044 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No Elementary KG 05 2017   grade_2 37 0 2 0   21     0   5   33 32                       65 37 0 2 0   21     0   5   33 32                 65
1126119 1126119 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No Elementary KG 05 2017   grade_2 52 0 2 0   3     0   1   37 21                       58 52 0 2 0   3     0   1   37 21                 58
1126332 1126332 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2017   grade_2 100 0 8 0   0     1   7   57 59                       116 100 0 8 0   0     1   7   57 59                 116
1126447 1126447 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_2 3 0 6 0   0     0   0   9 *                       9 3 0 6 0   0     0   0   9                   9
1126521 1126521 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No Elementary KG 04 2017   grade_2 64 0 9 0   6     0   2   37 44                       81 64 0 9 0   6     0   2   37 44                 81
1126635 1126635 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2017   grade_2 78 0 2 0   0     0   1   46 35                       81 78 0 2 0   0     0   1   46 35                 81
1126687 1126687 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2017   grade_2 41 0 0 0   0     0   1   26 16                       42 41 0 0 0   0     0   1   26 16                 42
1126694 1126694 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2017   grade_2 61 0 1 0   1     0   3   28 38                       66 61 0 1 0   1     0   3   28 38                 66
1126702 1126702 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No Elementary PK 05 2017   grade_2 42 0 4 0   0     0   1   25 22                       47 42 0 4 0   0     0   1   25 22                 47
1126709 1126709 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No Elementary KG 05 2017   grade_2 49 0 3 0   0     0   1   34 19                       53 49 0 3 0   0     0   1   34 19                 53
1126717 1126717 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No Elementary PK 05 2017   grade_2 59 0 6 0   1     0   2   33 35                       68 59 0 6 0   1     0   2   33 35                 68
1126752 1126752 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2017   grade_2 46 0 3 0   2     0   1   25 27                       52 46 0 3 0   2     0   1   25 27                 52
1126854 1126854 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2017   grade_2 145 0 4 0   1     0   6   77 79                       156 145 0 4 0   1     0   6   77 79                 156
1126886 1126886 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No Elementary KG 05 2017   grade_2 42 0 1 0   1     0   2   19 27                       46 42 0 1 0   1     0   2   19 27                 46
1126917 1126917 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_2 81 0 37 0   4     0   3   75 50                       125 81 0 37 0   4     0   3   75 50                 125
1126928 1126928 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_2 51 0 51 0   4     0   6   48 64                       112 51 0 51 0   4     0   6   48 64                 112
1126939 1126939 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_2 52 0 60 0   3     0   9   67 57                       124 52 0 60 0   3     0   9   67 57                 124
1126989 1126989 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2017   grade_2 73 0 0 0   5     0   0   36 42                       78 73 0 0 0   5     0   0   36 42                 78
1127097 1127097 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No Elementary PK 04 2017   grade_2 60 0 0 1   0     1   1   32 31                       63 60 0 0 1   0     1   1   32 31                 63
1127114 1127114 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_2 18 0 0 0   0     0   0   8 10                       18 18 0 0 0   0     0   0   8 10                 18
1127145 1127145 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2017   grade_2 64 0 6 1   19     0   6   50 46                       96 64 0 6 1   19     0   6   50 46                 96
1127163 1127163 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2017   grade_2 88 0 4 0   1     0   5   54 44                       98 88 0 4 0   1     0   5   54 44                 98
1127185 1127185 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No Elementary KG 05 2017   grade_2 71 0 3 0   6     0   4   36 48                       84 71 0 3 0   6     0   4   36 48                 84
1127346 1127346 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_2 20 0 15 0   0     0   3   24 14                       38 20 0 15 0   0     0   3   24 14                 38
1127490 1127490 MA Middlesex   school 2508610 207   Newton 250861001373 2070105 Memorial Spaulding   Regular School No Elementary KG 05 2017   grade_2 58 0 5 0   18     0   4   42 43                       85 58 0 5 0   18     0   4   42 43                 85
1127559 1127559 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2017   grade_2 97 0 6 0   2     0   1   63 43                       106 97 0 6 0   2     0   1   63 43                 106
1127613 1127613 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No Elementary PK 05 2017   grade_2 44 0 8 0   0     0   3   37 18                       55 44 0 8 0   0     0   3   37 18                 55
1127620 1127620 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No Elementary KG 05 2017   grade_2 24 0 7 0   2     0   2   20 15                       35 24 0 7 0   2     0   2   20 15                 35
1127702 1127702 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2017   grade_2 32 0 2 0   2     0   2   20 18                       38 32 0 2 0   2     0   2   20 18                 38
1127734 1127734 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No Elementary KG 05 2017   grade_2 26 0 8 0   11     0   1   24 22                       46 26 0 8 0   11     0   1   24 22                 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]);