enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
932568 932568 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2016   grade_1 72 1 0 0   1     0   0   54 20                       74 72 1 0 0   1     0   0   54 20                 74
932921 932921 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2016   grade_1 92 3 0 0   15     0   11   65 56                       121 92 3 0 0   15     0   11   65 56                 121
933920 933920 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_1 35 2 0 0   0     0   0   19 18                       37 35 2 0 0   0     0   0   19 18                 37
934195 934195 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2016   grade_1 16 12 0 0   13     0   11   27 25                       52 16 12 0 0   13     0   11   27 25                 52
934633 934633 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2016   grade_1 87 1 0 0   1     0   1   49 41                       90 87 1 0 0   1     0   1   49 41                 90
934764 934764 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No 1 PK 02 2016   grade_1 83 7 0 0   3     1   1   58 37                       95 83 7 0 0   3     1   1   58 37                 95
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
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
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
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
935502 935502 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2016   grade_1 79 1 0 0   2     0   2   32 52                       84 79 1 0 0   2     0   2   32 52                 84
935687 935687 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2016   grade_1 61 1 0 0   1     0   0   37 26                       63 61 1 0 0   1     0   0   37 26                 63
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
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
936624 936624 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2016   grade_1 64 5 0 0   5     0   4   34 44                       78 64 5 0 0   5     0   4   34 44                 78
936703 936703 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Winthrop   Regular School No 1 KG 05 2016   grade_1 53 2 0 0   4     0   2   29 32                       61 53 2 0 0   4     0   2   29 32                 61
936760 936760 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2016   grade_1 95 1 0 0   2     1   10   72 37                       109 95 1 0 0   2     1   10   72 37                 109
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
936838 936838 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No 1 PK 05 2016   grade_1 110 1 0 0   5     0   2   62 56                       118 110 1 0 0   5     0   2   62 56                 118
936850 936850 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No 1 KG 05 2016   grade_1 73 7 0 0   6     0   6   45 47                       92 73 7 0 0   6     0   6   45 47                 92
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
937511 937511 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2016   grade_1 78 0 0 0   0     0   3   44 37                       81 78 0 0 0   0     0   3   44 37                 81
937576 937576 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2016   grade_1 33 0 0 0   0     0   0   20 13                       33 33 0 0 0   0     0   0   20 13                 33
937683 937683 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2016   grade_1 71 1 0 0   0     0   3   39 36                       75 71 1 0 0   0     0   3   39 36                 75
937690 937690 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2016   grade_1 46 1 0 0   0     0   0   29 18                       47 46 1 0 0   0     0   0   29 18                 47
937698 937698 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2016   grade_1 73 0 0 0   1     0   3   40 37                       77 73 0 0 0   1     0   3   40 37                 77
937712 937712 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2016   grade_1 18 0 0 0   0     0   0   8 10                       18 18 0 0 0   0     0   0   8 10                 18
937812 937812 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2016   grade_1 76 2 0 0   0     0   2   38 42                       80 76 2 0 0   0     0   2   38 42                 80
937818 937818 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No 1 KG 05 2016   grade_1 50 0 0 1   0     0   1   26 26                       52 50 0 0 1   0     0   1   26 26                 52
937837 937837 MA Plymouth   school 2509720 239   Plymouth 250972001548 2390047 West Elementary   Regular School No 1 PK 05 2016   grade_1 44 3 0 0   1     0   2   31 19                       50 44 3 0 0   1     0   2   31 19                 50
937858 937858 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2016   grade_1 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
937866 937866 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_1 8 0 0 0   0     0   1   3 6                       9 8 0 0 0   0     0   1   3 6                 9
937876 937876 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No 1 KG 05 2016   grade_1 39 0 0 0   18     0   0   27 30                       57 39 0 0 0   18     0   0   27 30                 57
937904 937904 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No 1 KG 05 2016   grade_1 41 4 0 0   16     1   0   35 27                       62 41 4 0 0   16     1   0   35 27                 62
938006 938006 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2016   grade_1 59 1 0 0   1     0   4   34 31                       65 59 1 0 0   1     0   4   34 31                 65
938018 938018 MA Middlesex   school 2509990 246   Reading 250999001608 2460017 J Warren Killam   Regular School No 1 KG 05 2016   grade_1 54 3 0 0   5     0   4   34 32                       66 54 3 0 0   5     0   4   34 32                 66
938097 938097 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   grade_1 19 0 0 0   0     0   1   10 10                       20 19 0 0 0   0     0   1   10 10                 20
938107 938107 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2016   grade_1 50 2 0 0   0     0   4   33 23                       56 50 2 0 0   0     0   4   33 23                 56
938264 938264 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No 1 KG 06 2016   grade_1 48 3 0 1   0     0   1   31 22                       53 48 3 0 1   0     0   1   31 22                 53
938271 938271 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No 1 KG 06 2016   grade_1 38 0 0 0   1     0   2   22 19                       41 38 0 0 0   1     0   2   22 19                 41
938286 938286 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2016   grade_1 49 2 0 0   0     0   2   25 28                       53 49 2 0 0   0     0   2   25 28                 53
938919 938919 MA Middlesex   school 2511340 288   Sudbury 251134001876 2880010 Josiah Haynes   Regular School No 1 KG 05 2016   grade_1 52 0 0 0   8     0   7   42 25                       67 52 0 0 0   8     0   7   42 25                 67
939106 939106 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_1 9 0 0 0   0     0   2   9 2                       11 9 0 0 0   0     0   2   9 2                 11
939370 939370 MA Norfolk   school 2512270 317   Wellesley 251227002025 3170005 Katharine Lee Bates   Regular School No 1 KG 05 2016   grade_1 49 2 0 0   4     0   2   28 29                       57 49 2 0 0   4     0   2   28 29                 57
939407 939407 MA Norfolk   school 2512270 317   Wellesley 251227002021 3170050 Ernest F Upham   Regular School No 1 KG 05 2016   grade_1 38 1 0 0   4     0   2   24 21                       45 38 1 0 0   4     0   2   24 21                 45
939551 939551 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No 1 KG 02 2016   grade_1 66 2 0 0   48     0   6   66 56                       122 66 2 0 0   48     0   6   66 56                 122
939733 939733 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2016   grade_1 16 0 0 0   0     0   1   11 6                       17 16 0 0 0   0     0   1   11 6                 17
939855 939855 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Daniel P Hurld   Regular School No 1 KG 05 2016   grade_1 35 0 0 0   1     0   0   17 19                       36 35 0 0 0   1     0   0   17 19                 36
940204 940204 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No 1 PK 06 2016   grade_1 5 0 0 0   0     0   1   3 3                       6 5 0 0 0   0     0   1   3 3                 6
940452 940452 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 2016   grade_1 32 0 0 0   15     0   3   20 30                       50 32 0 0 0   15     0   3   20 30                 50
940629 940629 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2016   grade_1 30 0 0 0   3     0   1   18 16                       34 30 0 0 0   3     0   1   18 16                 34
940778 940778 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2016   grade_1 48 0 0 0   14     0   4   38 28                       66 48 0 0 0   14     0   4   38 28                 66
940785 940785 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2016   grade_1 27 2 0 1   37     0   1   31 37                       68 27 2 0 1   37     0   1   31 37                 68
940792 940792 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2016   grade_1 11 2 0 0   29     0   2   24 20                       44 11 2 0 0   29     0   2   24 20                 44
940806 940806 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2016   grade_1 30 5 0 0   0     0   0   16 19                       35 30 5 0 0   0     0   0   16 19                 35
940865 940865 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2016   grade_1 18 0 0 0   0     0   1   6 13                       19 18 0 0 0   0     0   1   6 13                 19
940978 940978 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No 1 PK 05 2016   grade_1 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
941096 941096 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2016   grade_1 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
941104 941104 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No 1 PK 03 2016   grade_1 87 1 0 0   0     0   1   44 45                       89 87 1 0 0   0     0   1   44 45                 89
941135 941135 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Littleville Elementary School   Regular School No 1 PK 04 2016   grade_1 46 1 0 0   0     0   2   27 22                       49 46 1 0 0   0     0   2   27 22                 49
941150 941150 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000806 6730005 Swallow/Union School   Regular School No 1 KG 04 2016   grade_1 63 0 0 0   0     0   0   37 26                       63 63 0 0 0   0     0   0   37 26                 63
941155 941155 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No 1 KG 04 2016   grade_1 91 0 0 0   0     0   0   45 46                       91 91 0 0 0   0     0   0   45 46                 91
941197 941197 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2016   grade_1 37 0 0 0   0     3   1   18 23                       41 37 0 0 0   0     3   1   18 23                 41
941249 941249 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2016   grade_1 12 0 0 0   0     0   1   7 6                       13 12 0 0 0   0     0   1   7 6                 13
941268 941268 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No 1 PK 05 2016   grade_1 47 0 0 0   0     0   0   32 15                       47 47 0 0 0   0     0   0   32 15                 47
941355 941355 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2016   grade_1 14 0 0 0   0     0   0   7 7                       14 14 0 0 0   0     0   0   7 7                 14
941363 941363 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2016   grade_1 10 0 0 0   0     0   0   8 2                       10 10 0 0 0   0     0   0   8 2                 10
941370 941370 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 PK 06 2016   grade_1 16 0 0 0   0     0   1   8 9                       17 16 0 0 0   0     0   1   8 9                 17
941417 941417 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_1 58 0 0 0   2     0   3   31 32                       63 58 0 0 0   2     0   3   31 32                 63
941438 941438 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No 1 PK 06 2016   grade_1 14 0 0 0   0     0   2   9 7                       16 14 0 0 0   0     0   2   9 7                 16
941498 941498 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No 1 PK 06 2016   grade_1 44 1 0 0   1     0   0   28 18                       46 44 1 0 0   1     0   0   28 18                 46
941516 941516 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2016   grade_1 19 0 0 0   0     0   1   8 12                       20 19 0 0 0   0     0   1   8 12                 20
941524 941524 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2016   grade_1 8 0 0 0   0     0   0   3 5                       8 8 0 0 0   0     0   0   3 5                 8
941539 941539 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_1 9 0 0 0   0     0   0   4 5                       9 9 0 0 0   0     0   0   4 5                 9
941567 941567 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2016   grade_1 34 0 0 0   0     0   0   12 22                       34 34 0 0 0   0     0   0   12 22                 34
941613 941613 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2016   grade_1 15 0 0 0   0     0   0   6 9                       15 15 0 0 0   0     0   0   6 9                 15
941618 941618 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No 1 KG 01 2016   grade_1 7 0 0 0   0     0   0   2 5                       7 7 0 0 0   0     0   0   2 5                 7
941696 941696 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2016   grade_1 52 1 0 0   1     0   0   30 24                       54 52 1 0 0   1     0   0   30 24                 54
941718 941718 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   grade_1 4 0 0 0   0     0   4   6 2                       8 4 0 0 0   0     0   4   6 2                 8
941744 941744 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Dawson   Regular School No 1 KG 05 2016   grade_1 69 3 0 0   4     0   1   42 35                       77 69 3 0 0   4     0   1   42 35                 77
932683 932683 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   grade_1 52 2 1 0   10     0   9   43 31                       74 52 2 1 0   10     0   9   43 31                 74
932883 932883 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 03 2016   grade_1 92 1 1 0   2     0   1   44 53                       97 92 1 1 0   2     0   1   44 53                 97
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
933008 933008 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No 1 KG 05 2016   grade_1 61 3 1 0   10     0   2   44 33                       77 61 3 1 0   10     0   2   44 33                 77
933836 933836 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   grade_1 55 1 1 1   2     0   1   28 33                       61 55 1 1 1   2     0   1   28 33                 61
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
933877 933877 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No 1 KG 05 2016   grade_1 41 1 1 0   14     0   0   24 33                       57 41 1 1 0   14     0   0   24 33                 57
934188 934188 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2016   grade_1 19 12 1 0   10     0   4   20 26                       46 19 12 1 0   10     0   4   20 26                 46
934223 934223 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No 1 PK 05 2016   grade_1 18 16 1 0   7     0   2   23 21                       44 18 16 1 0   7     0   2   23 21                 44
934304 934304 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2016   grade_1 114 1 1 0   0     0   0   48 68                       116 114 1 1 0   0     0   0   48 68                 116
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
934489 934489 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No 1 PK 02 2016   grade_1 110 6 1 0   3     0   4   62 62                       124 110 6 1 0   3     0   4   62 62                 124
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
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

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