enrollments

Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 6,747 ✖
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
738513 738513 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   kindergarten * * * *   *     *   *   2 3                       5                         2 3                 5
741323 741323 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2015   kindergarten * * * *   *     *   *   4 1                       5                         4 1                 5
933811 933811 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   kindergarten * * * *   *     *   *   1 3                       4                         1 3                 4
938149 938149 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2016   kindergarten * * * *   *     *   *   1 2                       3                         1 2                 3
941537 941537 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   kindergarten * * * *   *     *   *   2 2                       4                         2 2                 4
941717 941717 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   kindergarten * * * *   *     *   *   2 1                       3                         2 1                 3
1123194 1123194 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   kindergarten * * * *   *     *   *   1 1                       *                         1 1                  
1125185 1125185 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   kindergarten * * * *   *     *   *   * *                       *                                              
1125259 1125259 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   kindergarten * * * *   *     *   *   * *                       *                                              
1125389 1125389 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2017   kindergarten * * * *   *     *   *   1 3                       *                         1 3                  
1126445 1126445 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   kindergarten * * * *   *     *   *   1 *                       *                         1                    
1130371 1130371 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary KG 05 2017   kindergarten * * * *   *     *   *   1 1                       *                         1 1                  
1132401 1132401 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   kindergarten * * * *   *     *   *   2 3                       *                         2 3                  
1368419 1368419 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   kindergarten * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1368456 1368456 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1369769 1369769 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary KG 05 2020   kindergarten * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1373694 1373694 MA Middlesex   school 2508790 735   North Middlesex 250879002686 7350002 Squannacook Early Childhood Center   Regular School No Elementary 02 04 2020   kindergarten * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1373941 1373941 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2020   kindergarten * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1374306 1374306 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1674749 1674749 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1674845 1674845 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   kindergarten * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1675697 1675697 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1677016 1677016 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Norwood - Charles J Prescott   Regular School No Elementary KG 05 2021   kindergarten * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1677737 1677737 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy - Emma L Miller Elementary School   Regular School No Elementary PK 06 2021   kindergarten * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
2041095 2041095 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2042671 2042671 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   kindergarten * * * *   *     *   *   3 1                       4.0                         3 1                 4
2043504 2043504 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   kindergarten * * * *   *     *   *   3 2                       5.0                         3 2                 5
2045455 2045455 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   kindergarten * * * *   *     *   *   1 3                       4.0                         1 3                 4
2046932 2046932 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No Elementary KG 05 2019   kindergarten * * * *   *     *   *   2 2                       4.0                         2 2                 4
2048830 2048830 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 04 2019   kindergarten * * * *   *     *   *   2 3                       5.0                         2 3                 5
2230202 2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2231636 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
2231747 2231747 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   kindergarten * * * *   *     *   *   2 2                       4.0                         2 2                 4
2232014 2232014 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2232128 2232128 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   kindergarten * * * *   *     *   *   3 1                       4.0                         3 1                 4
2233064 2233064 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   kindergarten * * * *   *     *   *   1 *                       1.0                         1                   1
2234716 2234716 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Norwood: Charles J Prescott   Regular School No Elementary KG 05 2018   kindergarten * * * *   *     *   *   2 1                       3.0                         2 1                 3
2237204 2237204 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 West Springfield: Tatham   Regular School No Elementary KG 05 2018   kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2237220 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
735673 735673 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   kindergarten 92 0 4 0   0     0   0   45 51                       96 92 0 4 0   0     0   0   45 51                 96
735684 735684 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   kindergarten 44 0 7 0   2     0   1   32 22                       54 44 0 7 0   2     0   1   32 22                 54
735689 735689 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   kindergarten 75 0 0 0   1     0   0   48 28                       76 75 0 0 0   1     0   0   48 28                 76
735735 735735 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   kindergarten 18 0 12 0   7     0   3   19 21                       40 18 0 12 0   7     0   3   19 21                 40
735773 735773 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No 1 KG 05 2015   kindergarten 31 0 3 0   12     0   0   22 24                       46 31 0 3 0   12     0   0   22 24                 46
735831 735831 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   kindergarten 29 0 7 0   6     0   5   19 28                       47 29 0 7 0   6     0   5   19 28                 47
735870 735870 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   kindergarten 56 0 33 0   2     0   0   44 47                       91 56 0 33 0   2     0   0   44 47                 91
735924 735924 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   kindergarten 71 0 5 1   3     0   1   43 38                       81 71 0 5 1   3     0   1   43 38                 81
736007 736007 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   kindergarten 37 0 1 0   1     0   2   16 25                       41 37 0 1 0   1     0   2   16 25                 41
736040 736040 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   kindergarten 54 0 2 0   11     0   4   34 37                       71 54 0 2 0   11     0   4   34 37                 71
736064 736064 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   kindergarten 75 0 1 0   0     0   2   44 34                       78 75 0 1 0   0     0   2   44 34                 78
736074 736074 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   kindergarten 18 0 2 0   0     0   0   14 6                       20 18 0 2 0   0     0   0   14 6                 20
736081 736081 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   kindergarten 38 0 3 0   1     0   3   18 27                       45 38 0 3 0   1     0   3   18 27                 45
736132 736132 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No 1 KG 05 2015   kindergarten 43 0 3 0   1     0   2   24 25                       49 43 0 3 0   1     0   2   24 25                 49
736257 736257 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No 1 PK 05 2015   kindergarten 10 0 39 0   3     0   0   32 20                       52 10 0 39 0   3     0   0   32 20                 52
736264 736264 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 04 2015   kindergarten 4 0 7 0   0     0   3   8 6                       14 4 0 7 0   0     0   3   8 6                 14
736291 736291 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2015   kindergarten 3 0 61 0   0     0   0   33 31                       64 3 0 61 0   0     0   0   33 31                 64
736477 736477 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No 1 PK 05 2015   kindergarten 11 0 24 0   0     0   2   16 21                       37 11 0 24 0   0     0   2   16 21                 37
736970 736970 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   kindergarten 36 0 2 0   1     0   1   19 21                       40 36 0 2 0   1     0   1   19 21                 40
736983 736983 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2015   kindergarten 73 0 2 0   3     0   3   48 33                       81 73 0 2 0   3     0   3   48 33                 81
736998 736998 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No 1 KG 05 2015   kindergarten 22 0 3 0   2     0   0   13 14                       27 22 0 3 0   2     0   0   13 14                 27
737010 737010 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No 1 KG 05 2015   kindergarten 20 0 0 0   2     0   0   9 13                       22 20 0 0 0   2     0   0   9 13                 22
737021 737021 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2015   kindergarten 21 0 2 0   3     0   0   14 12                       26 21 0 2 0   3     0   0   14 12                 26
737044 737044 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   kindergarten 67 0 7 0   1     0   2   34 43                       77 67 0 7 0   1     0   2   34 43                 77
737177 737177 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   kindergarten 36 0 4 0   0     0   2   22 20                       42 36 0 4 0   0     0   2   22 20                 42
737269 737269 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No 1 KG 05 2015   kindergarten 35 0 1 0   9     0   2   26 21                       47 35 0 1 0   9     0   2   26 21                 47
737432 737432 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   kindergarten 38 0 2 0   6     0   6   31 21                       52 38 0 2 0   6     0   6   31 21                 52
737554 737554 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   kindergarten 18 0 6 0   1     0   1   12 14                       26 18 0 6 0   1     0   1   12 14                 26
737560 737560 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   kindergarten 41 0 14 0   1     0   2   25 33                       58 41 0 14 0   1     0   2   25 33                 58
737600 737600 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   kindergarten 15 0 1 0   0     0   0   8 8                       16 15 0 1 0   0     0   0   8 8                 16
737646 737646 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No 1 PK 05 2015   kindergarten 47 0 2 0   4     0   6   31 28                       59 47 0 2 0   4     0   6   31 28                 59
737662 737662 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   kindergarten 14 0 1 0   0     0   0   9 6                       15 14 0 1 0   0     0   0   9 6                 15
737689 737689 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No 1 KG 05 2015   kindergarten 29 0 5 0   3     0   1   20 18                       38 29 0 5 0   3     0   1   20 18                 38
737766 737766 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2015   kindergarten 43 0 3 0   1     0   3   27 23                       50 43 0 3 0   1     0   3   27 23                 50
737774 737774 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   kindergarten 84 0 0 0   2     0   1   46 41                       87 84 0 0 0   2     0   1   46 41                 87
737794 737794 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No 1 PK 05 2015   kindergarten 81 0 2 0   2     0   4   52 37                       89 81 0 2 0   2     0   4   52 37                 89
737834 737834 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2015   kindergarten 145 0 0 0   3     0   14   90 72                       162 145 0 0 0   3     0   14   90 72                 162
737866 737866 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No 1 KG 04 2015   kindergarten 14 0 2 1   2     0   3   13 9                       22 14 0 2 1   2     0   3   13 9                 22
737877 737877 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2015   kindergarten 36 0 11 0   1     0   1   25 24                       49 36 0 11 0   1     0   1   25 24                 49
737941 737941 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   kindergarten 6 0 0 0   0     0   4   4 6                       10 6 0 0 0   0     0   4   4 6                 10
738093 738093 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2015   kindergarten 39 0 2 0   1     0   7   23 26                       49 39 0 2 0   1     0   7   23 26                 49
738144 738144 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   kindergarten 65 0 7 0   2     0   4   42 36                       78 65 0 7 0   2     0   4   42 36                 78
738203 738203 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   kindergarten 6 0 0 0   0     0   1   3 4                       7 6 0 0 0   0     0   1   3 4                 7
738307 738307 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   kindergarten 42 0 0 0   2     0   0   19 25                       44 42 0 0 0   2     0   0   19 25                 44
738313 738313 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   kindergarten 44 0 2 0   3     0   2   23 28                       51 44 0 2 0   3     0   2   23 28                 51
738319 738319 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   kindergarten 54 0 4 0   1     0   0   30 29                       59 54 0 4 0   1     0   0   30 29                 59
738325 738325 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   kindergarten 56 0 1 0   5     1   0   36 27                       63 56 0 1 0   5     1   0   36 27                 63
738331 738331 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   kindergarten 43 0 0 0   1     0   0   23 21                       44 43 0 0 0   1     0   0   23 21                 44
738387 738387 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   kindergarten 46 0 9 1   2     0   1   35 24                       59 46 0 9 1   2     0   1   35 24                 59
738393 738393 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   kindergarten 37 0 4 0   0     0   1   26 16                       42 37 0 4 0   0     0   1   26 16                 42
738400 738400 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   kindergarten 33 0 0 0   1     1   0   15 20                       35 33 0 0 0   1     1   0   15 20                 35
738406 738406 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   kindergarten 27 0 5 0   0     0   0   12 20                       32 27 0 5 0   0     0   0   12 20                 32
738412 738412 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   kindergarten 49 0 6 0   1     0   1   33 24                       57 49 0 6 0   1     0   1   33 24                 57
738427 738427 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2015   kindergarten 93 0 6 0   24     0   2   68 57                       125 93 0 6 0   24     0   2   68 57                 125
738430 738430 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2015   kindergarten 101 0 6 0   8     0   6   60 61                       121 101 0 6 0   8     0   6   60 61                 121
738453 738453 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2015   kindergarten 46 0 1 1   0     0   1   19 30                       49 46 0 1 1   0     0   1   19 30                 49
738465 738465 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 03 2015   kindergarten 47 0 7 0   0     0   0   23 31                       54 47 0 7 0   0     0   0   23 31                 54
738469 738469 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 03 2015   kindergarten 40 0 6 0   0     0   0   14 32                       46 40 0 6 0   0     0   0   14 32                 46
738526 738526 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2015   kindergarten 107 0 1 0   2     0   2   60 52                       112 107 0 1 0   2     0   2   60 52                 112
738540 738540 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2015   kindergarten 43 0 2 0   6     0   0   32 19                       51 43 0 2 0   6     0   0   32 19                 51
738554 738554 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   kindergarten 28 0 3 0   0     0   0   20 11                       31 28 0 3 0   0     0   0   20 11                 31

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