enrollments

Data source: Big Local News · About: Big Local

988 rows where grade = "grade_1", state = "MA" and year = 2016 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 988 ✖

grade ✖

  • grade_1 · 988 ✖
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
935365 935365 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
935451 935451 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_1 * * * *   *     *   *   3 1                       4                         3 1                 4
936244 936244 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No 1 PK 05 2016   grade_1 * * * *   *     *   *   2 1                       3                         2 1                 3
938515 938515 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No 1 PK 02 2016   grade_1 * * * *   *     *   *   1 2                       3                         1 2                 3
932553 932553 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_1 97 0 4 0   0     0   0   43 58                       101 97 0 4 0   0     0   0   43 58                 101
932563 932563 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2016   grade_1 51 0 11 0   2     0   1   38 27                       65 51 0 11 0   2     0   1   38 27                 65
932657 932657 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No 1 KG 05 2016   grade_1 54 0 2 0   13     0   0   41 28                       69 54 0 2 0   13     0   0   41 28                 69
932747 932747 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   grade_1 58 0 27 0   3     0   3   44 47                       91 58 0 27 0   3     0   3   44 47                 91
932796 932796 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No 1 KG 02 2016   grade_1 72 0 8 1   3     0   1   45 40                       85 72 0 8 1   3     0   1   45 40                 85
932905 932905 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2016   grade_1 65 0 3 0   23     0   5   51 45                       96 65 0 3 0   23     0   5   51 45                 96
932910 932910 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2016   grade_1 54 0 2 0   12     0   4   33 39                       72 54 0 2 0   12     0   4   33 39                 72
932935 932935 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2016   grade_1 84 0 1 0   0     0   2   47 40                       87 84 0 1 0   0     0   2   47 40                 87
932945 932945 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2016   grade_1 21 0 2 0   0     0   0   17 6                       23 21 0 2 0   0     0   0   17 6                 23
933002 933002 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No 1 KG 05 2016   grade_1 44 0 2 0   1     0   3   25 25                       50 44 0 2 0   1     0   3   25 25                 50
933128 933128 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No 1 PK 05 2016   grade_1 10 0 38 0   2     0   0   28 22                       50 10 0 38 0   2     0   0   28 22                 50
933135 933135 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 05 2016   grade_1 4 0 10 0   0     0   2   8 8                       16 4 0 10 0   0     0   2   8 8                 16
933229 933229 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No 1 PK 05 2016   grade_1 3 0 42 0   0     0   2   23 24                       47 3 0 42 0   0     0   2   23 24                 47
933348 933348 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No 1 PK 05 2016   grade_1 16 0 24 0   4     0   1   21 24                       45 16 0 24 0   4     0   1   21 24                 45
933850 933850 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2016   grade_1 72 0 1 0   6     0   3   49 33                       82 72 0 1 0   6     0   3   49 33                 82
933858 933858 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2016   grade_1 30 0 1 0   2     0   1   12 22                       34 30 0 1 0   2     0   1   12 22                 34
933864 933864 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No 1 KG 05 2016   grade_1 67 0 2 0   12     0   0   39 42                       81 67 0 2 0   12     0   0   39 42                 81
933882 933882 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2016   grade_1 58 0 4 0   19     0   2   45 38                       83 58 0 4 0   19     0   2   45 38                 83
934039 934039 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_1 38 0 2 0   0     0   2   21 21                       42 38 0 2 0   0     0   2   21 21                 42
934294 934294 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_1 36 0 2 0   7     0   7   30 22                       52 36 0 2 0   7     0   7   30 22                 52
934324 934324 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No 1 KG 04 2016   grade_1 48 0 6 0   17     0   4   47 28                       75 48 0 6 0   17     0   4   47 28                 75
934334 934334 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2016   grade_1 72 0 6 1   6     0   4   46 43                       89 72 0 6 1   6     0   4   46 43                 89
934415 934415 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2016   grade_1 18 0 5 0   1     0   1   13 12                       25 18 0 5 0   1     0   1   13 12                 25
934421 934421 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2016   grade_1 41 0 13 0   1     0   2   23 34                       57 41 0 13 0   1     0   2   23 34                 57
934461 934461 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_1 16 0 1 0   0     0   0   10 7                       17 16 0 1 0   0     0   0   10 7                 17
934507 934507 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No 1 PK 05 2016   grade_1 53 0 3 0   4     0   7   38 29                       67 53 0 3 0   4     0   7   38 29                 67
934513 934513 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No 1 PK 05 2016   grade_1 56 0 5 0   3     0   4   37 31                       68 56 0 5 0   3     0   4   37 31                 68
934523 934523 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_1 14 0 1 0   0     0   0   10 5                       15 14 0 1 0   0     0   0   10 5                 15
934549 934549 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No 1 KG 05 2016   grade_1 32 0 7 0   2     0   1   22 20                       42 32 0 7 0   2     0   1   22 20                 42
934555 934555 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No 1 KG 05 2016   grade_1 45 0 6 2   1     0   1   25 30                       55 45 0 6 2   1     0   1   25 30                 55
934570 934570 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2016   grade_1 66 0 2 0   1     0   6   35 40                       75 66 0 2 0   1     0   6   35 40                 75
934625 934625 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2016   grade_1 44 0 4 0   0     0   4   26 26                       52 44 0 4 0   0     0   4   26 26                 52
934690 934690 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2016   grade_1 147 0 3 0   2     0   13   87 78                       165 147 0 3 0   2     0   13   87 78                 165
934715 934715 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_1 23 0 1 1   0     0   1   10 16                       26 23 0 1 1   0     0   1   10 16                 26
934732 934732 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2016   grade_1 26 0 8 0   1     0   1   20 16                       36 26 0 8 0   1     0   1   20 16                 36
934795 934795 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_1 5 0 0 0   0     0   3   3 5                       8 5 0 0 0   0     0   3   3 5                 8
934944 934944 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2016   grade_1 40 0 2 0   1     0   6   24 25                       49 40 0 2 0   1     0   6   24 25                 49
934999 934999 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   grade_1 63 0 4 0   2     0   4   38 35                       73 63 0 4 0   2     0   4   38 35                 73
935059 935059 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_1 7 0 0 0   0     0   0   2 5                       7 7 0 0 0   0     0   0   2 5                 7
935162 935162 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   grade_1 47 0 0 0   3     0   1   22 29                       51 47 0 0 0   3     0   1   22 29                 51
935168 935168 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2016   grade_1 44 0 2 0   4     0   2   24 28                       52 44 0 2 0   4     0   2   24 28                 52
935174 935174 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2016   grade_1 56 0 3 0   1     0   0   28 32                       60 56 0 3 0   1     0   0   28 32                 60
935180 935180 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2016   grade_1 55 0 1 0   3     1   0   34 26                       60 55 0 1 0   3     1   0   34 26                 60
935186 935186 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2016   grade_1 41 0 0 0   0     0   0   21 20                       41 41 0 0 0   0     0   0   21 20                 41
935239 935239 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2016   grade_1 47 0 8 1   3     0   2   40 21                       61 47 0 8 1   3     0   2   40 21                 61
935245 935245 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2016   grade_1 34 0 4 0   0     0   1   24 15                       39 34 0 4 0   0     0   1   24 15                 39
935252 935252 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_1 34 0 0 0   0     1   0   17 18                       35 34 0 0 0   0     1   0   17 18                 35
935258 935258 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   grade_1 26 0 4 0   0     0   0   12 18                       30 26 0 4 0   0     0   0   12 18                 30
935264 935264 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2016   grade_1 47 0 5 0   1     0   0   28 25                       53 47 0 5 0   1     0   0   28 25                 53
935306 935306 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2016   grade_1 44 0 1 1   0     0   2   16 32                       48 44 0 1 1   0     0   2   16 32                 48
935322 935322 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 04 2016   grade_1 39 0 4 0   0     0   0   16 27                       43 39 0 4 0   0     0   0   16 27                 43
935328 935328 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 04 2016   grade_1 30 0 11 0   0     0   1   21 21                       42 30 0 11 0   0     0   1   21 21                 42
935377 935377 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2016   grade_1 112 0 1 0   2     0   2   59 58                       117 112 0 1 0   2     0   2   59 58                 117
935392 935392 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2016   grade_1 48 0 3 0   6     0   0   34 23                       57 48 0 3 0   6     0   0   34 23                 57
935406 935406 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_1 29 0 2 0   0     0   0   17 14                       31 29 0 2 0   0     0   0   17 14                 31
935463 935463 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2016   grade_1 38 0 8 0   1     0   1   31 17                       48 38 0 8 0   1     0   1   31 17                 48
935484 935484 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2016   grade_1 70 0 1 0   0     0   2   40 33                       73 70 0 1 0   0     0   2   40 33                 73
935490 935490 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2016   grade_1 54 0 2 0   0     0   1   28 29                       57 54 0 2 0   0     0   1   28 29                 57
935556 935556 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2016   grade_1 16 0 31 0   1     0   1   23 26                       49 16 0 31 0   1     0   1   23 26                 49
935566 935566 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_1 1 0 39 0   0     0   0   23 17                       40 1 0 39 0   0     0   0   23 17                 40
935661 935661 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2016   grade_1 35 0 4 0   1     0   3   21 22                       43 35 0 4 0   1     0   3   21 22                 43
935701 935701 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2016   grade_1 52 0 2 0   5     0   1   32 28                       60 52 0 2 0   5     0   1   32 28                 60
935747 935747 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   grade_1 2 0 126 0   0     0   0   64 64                       128 2 0 126 0   0     0   0   64 64                 128
935785 935785 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_1 4 0 92 0   0     0   0   53 43                       96 4 0 92 0   0     0   0   53 43                 96
935790 935790 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_1 8 0 95 0   1     0   0   50 54                       104 8 0 95 0   1     0   0   50 54                 104
935809 935809 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_1 5 0 69 0   0     0   0   32 42                       74 5 0 69 0   0     0   0   32 42                 74
935858 935858 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_1 1 0 8 0   0     0   0   6 3                       9 1 0 8 0   0     0   0   6 3                 9
935877 935877 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   grade_1 36 0 8 0   1     0   1   27 19                       46 36 0 8 0   1     0   1   27 19                 46
935905 935905 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2016   grade_1 38 0 4 0   1     0   0   22 21                       43 38 0 4 0   1     0   0   22 21                 43
935960 935960 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_1 18 0 0 0   1     0   0   14 5                       19 18 0 0 0   1     0   0   14 5                 19
935992 935992 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No 1 KG 05 2016   grade_1 37 0 2 0   18     0   4   33 28                       61 37 0 2 0   18     0   4   33 28                 61
936054 936054 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No 1 KG 05 2016   grade_1 44 0 2 0   2     0   1   32 17                       49 44 0 2 0   2     0   1   32 17                 49
936229 936229 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2016   grade_1 96 0 10 0   0     1   8   53 62                       115 96 0 10 0   0     1   8   53 62                 115
936326 936326 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_1 2 0 3 0   0     0   1   5 1                       6 2 0 3 0   0     0   1   5 1                 6
936388 936388 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No 1 KG 04 2016   grade_1 60 0 9 0   6     0   2   33 44                       77 60 0 9 0   6     0   2   33 44                 77
936483 936483 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No 1 PK 03 2016   grade_1 74 0 3 0   0     0   2   47 32                       79 74 0 3 0   0     0   2   47 32                 79
936527 936527 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2016   grade_1 43 0 0 0   0     0   1   27 17                       44 43 0 0 0   0     0   1   27 17                 44
936533 936533 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2016   grade_1 60 0 1 0   1     0   2   27 37                       64 60 0 1 0   1     0   2   27 37                 64
936540 936540 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2016   grade_1 44 0 3 0   0     0   1   26 22                       48 44 0 3 0   0     0   1   26 22                 48
936546 936546 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2016   grade_1 47 0 3 0   0     0   1   34 17                       51 47 0 3 0   0     0   1   34 17                 51
936581 936581 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No 1 PK 03 2016   grade_1 49 0 2 0   2     0   0   27 26                       53 49 0 2 0   2     0   0   27 26                 53
936665 936665 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No 1 PK 01 2016   grade_1 141 0 4 0   1     0   4   74 76                       150 141 0 4 0   1     0   4   74 76                 150
936691 936691 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No 1 KG 05 2016   grade_1 41 0 1 0   0     0   2   19 25                       44 41 0 1 0   0     0   2   19 25                 44
936717 936717 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2016   grade_1 90 0 38 0   3     0   3   80 54                       134 90 0 38 0   3     0   3   80 54                 134
936780 936780 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No 1 KG 02 2016   grade_1 76 0 0 0   5     0   0   39 42                       81 76 0 0 0   5     0   0   39 42                 81
936824 936824 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2016   grade_1 95 0 2 0   1     0   5   51 52                       103 95 0 2 0   1     0   5   51 52                 103
936873 936873 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2016   grade_1 56 0 3 1   0     1   1   30 32                       62 56 0 3 1   0     1   1   30 32                 62
936887 936887 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2016   grade_1 22 0 0 0   1     0   0   11 12                       23 22 0 0 0   1     0   0   11 12                 23
936913 936913 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No 1 KG 04 2016   grade_1 72 0 6 0   24     0   5   56 51                       107 72 0 6 0   24     0   5   56 51                 107
936918 936918 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No 1 KG 04 2016   grade_1 39 0 1 0   1     0   2   29 14                       43 39 0 1 0   1     0   2   29 14                 43
936928 936928 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No 1 KG 04 2016   grade_1 86 0 2 0   1     0   5   51 43                       94 86 0 2 0   1     0   5   51 43                 94
936946 936946 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No 1 KG 05 2016   grade_1 70 0 3 0   6     0   4   36 47                       83 70 0 3 0   6     0   4   36 47                 83
937087 937087 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No 1 KG 05 2016   grade_1 39 0 4 0   0     0   3   23 23                       46 39 0 4 0   0     0   3   23 23                 46
937129 937129 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No 1 PK 03 2016   grade_1 126 0 4 0   1     0   1   65 67                       132 126 0 4 0   1     0   1   65 67                 132
937203 937203 MA Middlesex   school 2508610 207   Newton 250861001373 2070105 Memorial Spaulding   Regular School No 1 KG 05 2016   grade_1 57 0 6 0   15     0   3   40 41                       81 57 0 6 0   15     0   3   40 41                 81
937222 937222 MA Middlesex   school 2508610 207   Newton 250861001382 2070125 Williams   Regular School No 1 KG 05 2016   grade_1 18 0 5 1   14     0   3   22 19                       41 18 0 5 1   14     0   3   22 19                 41

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