Data source: Big Local News · About: Big Local

971 rows where grade = "kindergarten", state = "MA" and year = 2018 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2018 · 971

grade

  • kindergarten · 971
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
2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2232014 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230663 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   kindergarten 9 0 0 0   0     0   0   8 1                       9.0 9 0 0 0   0     0   0   8 1                 9
2231636 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2237220 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2228759 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   kindergarten 113 6 13 2   3     0   0   67 70                       137.0 113 6 13 2   3     0   0   67 70                 137
2228787 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam: Clifford M Granger   Regular School No Elementary KG 04 2018   kindergarten 27 1 7 0   0     0   1   15 21                       36.0 27 1 7 0   0     0   1   15 21                 36
2228793 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam: Benjamin J Phelps   Regular School No Elementary KG 04 2018   kindergarten 54 1 6 0   3     0   4   41 27                       68.0 54 1 6 0   3     0   4   41 27                 68
2228799 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam: Robinson Park   Regular School No Elementary KG 04 2018   kindergarten 53 3 10 0   3     0   3   37 35                       72.0 53 3 10 0   3     0   3   37 35                 72
2228805 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam: James Clark School   Regular School No Elementary KG 04 2018   kindergarten 46 2 6 0   1     0   2   26 31                       57.0 46 2 6 0   1     0   2   26 31                 57
2228860 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   kindergarten 14 2 8 0   7     0   2   12 21                       33.0 14 2 8 0   7     0   2   12 21                 33
2228868 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   kindergarten 27 4 10 0   7     0   4   25 27                       52.0 27 4 10 0   7     0   4   25 27                 52
2228876 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover: Bancroft Elementary   Regular School No Elementary KG 05 2018   kindergarten 78 2 2 0   8     0   1   49 42                       91.0 78 2 2 0   8     0   1   49 42                 91
2228883 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover: High Plain Elementary   Regular School No Elementary KG 05 2018   kindergarten 38 2 4 0   13     0   2   36 23                       59.0 38 2 4 0   13     0   2   36 23                 59
2228892 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover: Henry C Sanborn Elementary   Regular School No Elementary KG 05 2018   kindergarten 32 0 7 0   10     0   2   23 28                       51.0 32 0 7 0   10     0   2   23 28                 51
2228899 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover: South Elementary   Regular School No Elementary KG 05 2018   kindergarten 62 1 1 0   11     0   2   39 38                       77.0 62 1 1 0   11     0   2   39 38                 77
2228906 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover: West Elementary   Regular School No Elementary KG 05 2018   kindergarten 62 0 5 1   17     0   0   45 40                       85.0 62 0 5 1   17     0   0   45 40                 85
2228930 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   kindergarten 42 3 1 0   11     0   7   37 27                       64.0 42 3 1 0   11     0   7   37 27                 64
2228937 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   kindergarten 60 0 1 0   9     0   8   41 37                       78.0 60 0 1 0   9     0   8   41 37                 78
2228944 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   kindergarten 57 0 3 0   8     0   5   40 33                       73.0 57 0 3 0   8     0   5   40 33                 73
2228951 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   kindergarten 57 2 10 0   11     0   10   41 48                       90.0 57 2 10 0   11     0   10   41 48                 90
2228960 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   kindergarten 41 2 9 0   7     0   8   36 31                       67.0 41 2 9 0   7     0   8   36 31                 67
2228967 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   kindergarten 49 3 8 0   14     0   4   40 38                       78.0 49 3 8 0   14     0   4   40 38                 78
2228974 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   kindergarten 56 1 2 0   4     0   9   34 38                       72.0 56 1 2 0   4     0   9   34 38                 72
2228992 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland: Henry E Warren Elementary   Regular School No Elementary KG 02 2018   kindergarten 122 9 24 0   37     0   10   100 102                       202.0 122 9 24 0   37     0   10   100 102                 202
2229009 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 Attleboro: A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2018   kindergarten 47 4 10 0   2     0   3   35 31                       66.0 47 4 10 0   2     0   3   35 31                 66
2229017 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Attleboro: Thomas Willett Elementary School   Regular School No Elementary KG 04 2018   kindergarten 53 6 16 0   6     0   8   51 38                       89.0 53 6 16 0   6     0   8   51 38                 89
2229023 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro: Hyman Fine Elementary School   Regular School No Elementary KG 04 2018   kindergarten 64 4 11 0   6     0   9   44 50                       94.0 64 4 11 0   6     0   9   44 50                 94
2229029 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Attleboro: Hill-Roberts Elementary School   Regular School No Elementary KG 04 2018   kindergarten 56 4 7 1   7     0   6   37 44                       81.0 56 4 7 1   7     0   6   37 44                 81
2229035 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro: Peter Thacher Elementary School   Regular School No Elementary KG 04 2018   kindergarten 68 8 6 1   6     0   6   49 46                       95.0 68 8 6 1   6     0   6   49 46                 95
2229064 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Auburn: Bryn Mawr   Regular School No Elementary KG 02 2018   kindergarten 79 1 11 0   3     0   2   51 45                       96.0 79 1 11 0   3     0   2   51 45                 96
2229105 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   kindergarten 51 3 4 0   0     0   4   34 28                       62.0 51 3 4 0   0     0   4   34 28                 62
2229110 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   kindergarten 50 4 2 0   1     0   8   34 31                       65.0 50 4 2 0   1     0   8   34 31                 65
2229115 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   kindergarten 30 9 24 0   3     0   13   49 30                       79.0 30 9 24 0   3     0   13   49 30                 79
2229120 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   kindergarten 87 3 9 0   0     0   9   55 53                       108.0 87 3 9 0   0     0   9   55 53                 108
2229137 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   kindergarten 116 12 9 0   42     0   18   88 109                       197.0 116 12 9 0   42     0   18   88 109                 197
2229176 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham: South Elementary   Regular School No Elementary KG 03 2018   kindergarten 60 3 6 0   1     2   3   36 39                       75.0 60 3 6 0   1     2   3   36 39                 75
2229181 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   kindergarten 71 2 3 0   1     2   2   45 36                       81.0 71 2 3 0   1     2   2   45 36                 81
2229203 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont: Winn Brook   Regular School No Elementary KG 04 2018   kindergarten 58 4 4 0   18     0   5   51 38                       89.0 58 4 4 0   18     0   5   51 38                 89
2229209 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Belmont: Mary Lee Burbank   Regular School No Elementary KG 04 2018   kindergarten 46 5 4 0   12     0   7   43 31                       74.0 46 5 4 0   12     0   7   43 31                 74
2229215 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Belmont: Daniel Butler   Regular School No Elementary KG 04 2018   kindergarten 36 0 2 0   19     0   9   38 28                       66.0 36 0 2 0   19     0   9   38 28                 66
2229260 MA Essex   school 2502640 30   Beverly 250264000167 300010 Beverly: Centerville Elementary   Regular School No Elementary KG 05 2018   kindergarten 34 1 6 0   1     0   4   23 23                       46.0 34 1 6 0   1     0   4   23 23                 46
2229267 MA Essex   school 2502640 30   Beverly 250264000168 300015 Beverly: Cove Elementary   Regular School No Elementary KG 05 2018   kindergarten 86 2 12 0   0     0   5   59 46                       105.0 86 2 12 0   0     0   5   59 46                 105
2229274 MA Essex   school 2502640 30   Beverly 250264000169 300033 Beverly: Hannah Elementary   Regular School No Elementary KG 05 2018   kindergarten 49 3 9 0   1     0   1   45 18                       63.0 49 3 9 0   1     0   1   45 18                 63
2229281 MA Essex   school 2502640 30   Beverly 250264000173 300040 Beverly: North Beverly Elementary   Regular School No Elementary KG 05 2018   kindergarten 48 3 9 0   3     0   2   35 30                       65.0 48 3 9 0   3     0   2   35 30                 65
2229288 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly: Ayers/Ryal Side School   Regular School No Elementary KG 05 2018   kindergarten 69 2 8 0   3     0   3   45 40                       85.0 69 2 8 0   3     0   3   45 40                 85
2229304 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica: Thomas Ditson   Regular School No Elementary KG 05 2018   kindergarten 58 3 2 0   7     0   4   41 33                       74.0 58 3 2 0   7     0   4   41 33                 74
2229311 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica: Frederick J Dutile   Regular School No Elementary KG 05 2018   kindergarten 34 5 2 0   3     0   0   23 21                       44.0 34 5 2 0   3     0   0   23 21                 44
2229318 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 Billerica: John F Kennedy   Regular School No Elementary KG 05 2018   kindergarten 39 1 4 0   3     0   2   19 30                       49.0 39 1 4 0   3     0   2   19 30                 49
2229325 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Billerica: Parker   Regular School No Elementary KG 05 2018   kindergarten 52 4 4 0   13     0   4   37 40                       77.0 52 4 4 0   13     0   4   37 40                 77
2229332 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Billerica: Hajjar Elementary   Regular School No Elementary KG 05 2018   kindergarten 52 2 7 0   9     0   4   32 42                       74.0 52 2 7 0   9     0   4   32 42                 74
2229339 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Billerica: Eugene C Vining   Regular School No Elementary KG 05 2018   kindergarten 27 0 4 0   2     0   2   22 13                       35.0 27 0 4 0   2     0   2   22 13                 35
2229370 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   kindergarten 4 2 3 0   1     0   1   7 4                       11.0 4 2 3 0   1     0   1   7 4                 11
2229609 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   kindergarten 6 11 20 0   3     0   2   18 24                       42.0 6 11 20 0   3     0   2   18 24                 42
2229755 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston: Michael J Perkins   Regular School No Elementary KG 05 2018   kindergarten 3 10 13 0   0     0   2   10 18                       28.0 3 10 13 0   0     0   2   10 18                 28
2230286 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Bourne: Peebles Elementary School   Regular School No Elementary KG 04 2018   kindergarten 32 0 3 0   1     0   4   16 24                       40.0 32 0 3 0   1     0   4   16 24                 40
2230320 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Braintree: Hollis   Regular School No Elementary KG 05 2018   kindergarten 18 0 0 0   5     0   1   15 9                       24.0 18 0 0 0   5     0   1   15 9                 24
2230327 MA Norfolk   school 2502940 40   Braintree 250294002789 400009 Braintree: Monatiquot Kindergarten Center   Regular School No Elementary KG KG 2018   kindergarten 175 11 13 0   46     1   4   149 101                       250.0 175 11 13 0   46     1   4   149 101                 250
2230329 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Braintree: Highlands   Regular School No Elementary KG 05 2018   kindergarten 17 0 0 0   4     0   0   11 10                       21.0 17 0 0 0   4     0   0   11 10                 21
2230336 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Braintree: Mary E Flaherty School   Regular School No Elementary KG 05 2018   kindergarten 14 0 0 0   5     0   3   9 13                       22.0 14 0 0 0   5     0   3   9 13                 22
2230349 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Braintree: Archie T Morrison   Regular School No Elementary KG 05 2018   kindergarten 14 2 0 0   4     0   0   9 11                       20.0 14 2 0 0   4     0   0   9 11                 20
2230356 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree: Donald Ross   Regular School No Elementary KG 05 2018   kindergarten 12 1 0 0   6     0   0   7 12                       19.0 12 1 0 0   6     0   0   7 12                 19
2230395 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton: Dr W Arnone Community School   Regular School No Elementary KG 05 2018   kindergarten 11 78 25 0   0     0   5   67 52                       119.0 11 78 25 0   0     0   5   67 52                 119
2230402 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton: Mary E. Baker School   Regular School No Elementary KG 05 2018   kindergarten 39 78 13 0   3     0   12   75 70                       145.0 39 78 13 0   3     0   12   75 70                 145
2230409 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton: Manthala George Jr. School   Regular School No Elementary KG 05 2018   kindergarten 28 54 60 0   0     0   6   75 73                       148.0 28 54 60 0   0     0   6   75 73                 148
2230418 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton: Brookfield   Regular School No Elementary KG 05 2018   kindergarten 24 45 9 0   1     0   5   50 34                       84.0 24 45 9 0   1     0   5   50 34                 84
2230425 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton: John F Kennedy   Regular School No Elementary KG 05 2018   kindergarten 23 52 13 0   1     0   4   47 46                       93.0 23 52 13 0   1     0   4   47 46                 93
2230432 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   kindergarten 20 68 15 2   0     0   6   61 50                       111.0 20 68 15 2   0     0   6   61 50                 111
2230442 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton: Hancock   Regular School No Elementary KG 05 2018   kindergarten 32 66 5 0   5     1   5   48 66                       114.0 32 66 5 0   5     1   5   48 66                 114
2230449 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton: Gilmore Elementary School   Regular School No Elementary KG 05 2018   kindergarten 3 69 7 1   1     0   1   44 38                       82.0 3 69 7 1   1     0   1   44 38                 82
2230456 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton: Louis F Angelo Elementary   Regular School No Elementary KG 05 2018   kindergarten 15 64 10 0   11     0   5   64 41                       105.0 15 64 10 0   11     0   5   64 41                 105
2230463 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton: Oscar F Raymond   Regular School No Elementary KG 05 2018   kindergarten 15 127 15 0   2     0   7   76 90                       166.0 15 127 15 0   2     0   7   76 90                 166
2230474 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton: Downey   Regular School No Elementary KG 05 2018   kindergarten 24 51 12 1   1     0   5   58 36                       94.0 24 51 12 1   1     0   5   58 36                 94
2230540 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   kindergarten 35 5 3 0   25     0   10   49 29                       78.0 35 5 3 0   25     0   10   49 29                 78
2230550 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   kindergarten 58 5 8 0   12     0   9   50 42                       92.0 58 5 8 0   12     0   9   50 42                 92
2230582 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline: Lawrence   Regular School No Elementary KG 08 2018   kindergarten 38 5 6 0   29     0   10   42 46                       88.0 38 5 6 0   29     0   10   42 46                 88
2230592 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   kindergarten 27 7 7 1   20     0   3   31 34                       65.0 27 7 7 1   20     0   3   31 34                 65
2230602 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   kindergarten 47 4 8 0   35     0   14   63 45                       108.0 47 4 8 0   35     0   14   63 45                 108
2230631 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington: Fox Hill   Regular School No Elementary KG 05 2018   kindergarten 38 2 3 0   23     0   6   34 38                       72.0 38 2 3 0   23     0   6   34 38                 72
2230638 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Burlington: Memorial   Regular School No Elementary KG 05 2018   kindergarten 44 3 11 0   17     0   3   40 38                       78.0 44 3 11 0   17     0   3   40 38                 78
2230645 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Burlington: Pine Glen Elementary   Regular School No Elementary KG 05 2018   kindergarten 38 1 0 0   11     0   4   32 22                       54.0 38 1 0 0   11     0   4   32 22                 54
2230652 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington: Francis Wyman Elementary   Regular School No Elementary KG 05 2018   kindergarten 51 9 5 0   18     0   3   49 37                       86.0 51 9 5 0   18     0   3   49 37                 86
2230792 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Canton: Lt Peter M Hansen   Regular School No Elementary KG 05 2018   kindergarten 43 4 8 0   9     0   5   35 34                       69.0 43 4 8 0   9     0   5   35 34                 69
2230799 MA Norfolk   school 2503300 50   Canton 250330000454 500017 Canton: John F Kennedy   Regular School No Elementary KG 05 2018   kindergarten 58 7 8 0   8     0   6   45 42                       87.0 58 7 8 0   8     0   6   45 42                 87
2230806 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton: Dean S Luce   Regular School No Elementary KG 05 2018   kindergarten 49 7 3 0   4     0   2   35 30                       65.0 49 7 3 0   4     0   2   35 30                 65
2230851 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford: Center Elementary School   Regular School No Elementary KG 04 2018   kindergarten 66 1 3 0   14     0   6   46 44                       90.0 66 1 3 0   14     0   6   46 44                 90
2230857 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford: South Row   Regular School No Elementary KG 04 2018   kindergarten 58 5 2 0   14     0   3   41 41                       82.0 58 5 2 0   14     0   3   41 41                 82
2230863 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford: Charles D Harrington   Regular School No Elementary KG 04 2018   kindergarten 53 2 12 0   25     0   1   45 48                       93.0 53 2 12 0   25     0   1   45 48                 93
2230869 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford: Byam School   Regular School No Elementary KG 04 2018   kindergarten 71 1 6 1   19     0   5   47 56                       103.0 71 1 6 1   19     0   5   47 56                 103
2230936 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Chicopee: Barry   Regular School No Elementary KG 05 2018   kindergarten 42 1 14 0   1     0   1   31 28                       59.0 42 1 14 0   1     0   1   31 28                 59
2230943 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee: Belcher   Regular School No Elementary KG 02 2018   kindergarten 49 8 40 0   2     0   2   56 45                       101.0 49 8 40 0   2     0   2   56 45                 101
2230955 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Chicopee: Bowie   Regular School No Elementary KG 05 2018   kindergarten 30 0 9 0   1     0   3   21 22                       43.0 30 0 9 0   1     0   3   21 22                 43
2230969 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee: Litwin   Regular School No Elementary KG 05 2018   kindergarten 18 1 3 0   1     0   0   14 9                       23.0 18 1 3 0   1     0   0   14 9                 23
2230976 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Chicopee: Lambert-Lavoie   Regular School No Elementary KG 05 2018   kindergarten 30 2 16 0   1     0   1   28 22                       50.0 30 2 16 0   1     0   1   28 22                 50
2230983 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Chicopee: Fairview Elementary   Regular School No Elementary KG 05 2018   kindergarten 34 1 31 0   3     0   2   40 31                       71.0 34 1 31 0   3     0   2   40 31                 71
2230990 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee: Streiber Memorial School   Regular School No Elementary KG 05 2018   kindergarten 21 1 16 0   4     0   2   22 22                       44.0 21 1 16 0   4     0   2   22 22                 44
2230997 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Chicopee: Gen John J Stefanik   Regular School No Elementary KG 05 2018   kindergarten 14 2 41 0   1     0   3   33 28                       61.0 14 2 41 0   1     0   3   33 28                 61
2231022 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   kindergarten 29 0 0 0   0     0   2   17 14                       31.0 29 0 0 0   0     0   2   17 14                 31
2231104 MA Essex   school 2503990 71   Danvers 250399000532 710010 Danvers: Highlands   Regular School No Elementary KG 05 2018   kindergarten 48 1 7 0   1     0   4   34 27                       61.0 48 1 7 0   1     0   4   34 27                 61
2231111 MA Essex   school 2503990 71   Danvers 250399000531 710015 Danvers: Great Oak   Regular School No Elementary KG 05 2018   kindergarten 47 4 3 0   4     0   3   32 29                       61.0 47 4 3 0   4     0   3   32 29                 61

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