enrollments

Data source: Big Local News · About: Big Local

973 rows where grade = "grade_2", state = "MA" and year = 2016 sorted by multiracial_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 973 ✖

grade ✖

  • grade_2 · 973 ✖
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
935366 935366 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 4                       5                         1 4                 5
936162 936162 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_2 * * * *   *     *   *   1 *                       1                         1                   1
938152 938152 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   2 2                       4                         2 2                 4
938260 938260 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2016   grade_2 * * * *   *     *   *   3 1                       4                         3 1                 4
941364 941364 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 1                       2                         1 1                 2
941525 941525 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 4                       5                         1 4                 5
941540 941540 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   2 2                       4                         2 2                 4
932554 932554 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_2 108 0 0 0   0     0   0   62 46                       108 108 0 0 0   0     0   0   62 46                 108
932658 932658 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No 1 KG 05 2016   grade_2 67 1 4 0   13     0   0   37 48                       85 67 1 4 0   13     0   0   37 48                 85
932709 932709 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_2 36 2 6 0   0     0   0   29 15                       44 36 2 6 0   0     0   0   29 15                 44
932832 932832 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 KG 03 2016   grade_2 70 1 8 1   2     0   0   46 36                       82 70 1 8 1   2     0   0   46 36                 82
932946 932946 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2016   grade_2 23 0 2 0   1     0   0   16 10                       26 23 0 2 0   1     0   0   16 10                 26
933003 933003 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No 1 KG 05 2016   grade_2 52 0 1 0   2     0   0   31 24                       55 52 0 1 0   2     0   0   31 24                 55
933009 933009 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No 1 KG 05 2016   grade_2 72 3 4 0   9     0   0   44 44                       88 72 3 4 0   9     0   0   44 44                 88
933015 933015 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No 1 KG 05 2016   grade_2 82 5 5 0   9     0   0   53 48                       101 82 5 5 0   9     0   0   53 48                 101
933058 933058 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No 1 PK 03 2016   grade_2 0 19 14 1   2     0   0   22 14                       36 0 19 14 1   2     0   0   22 14                 36
933069 933069 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_2 13 7 8 0   1     0   0   15 14                       29 13 7 8 0   1     0   0   15 14                 29
933079 933079 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_2 9 26 41 0   13     0   0   49 40                       89 9 26 41 0   13     0   0   49 40                 89
933129 933129 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No 1 PK 05 2016   grade_2 20 0 42 0   1     0   0   29 34                       63 20 0 42 0   1     0   0   29 34                 63
933136 933136 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 05 2016   grade_2 7 0 5 0   0     0   0   5 7                       12 7 0 5 0   0     0   0   5 7                 12
933143 933143 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2016   grade_2 2 24 39 0   0     0   0   28 37                       65 2 24 39 0   0     0   0   28 37                 65
933165 933165 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_2 5 6 75 0   0     0   0   47 39                       86 5 6 75 0   0     0   0   47 39                 86
933216 933216 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No 1 PK 05 2016   grade_2 2 22 17 0   2     0   0   18 25                       43 2 22 17 0   2     0   0   18 25                 43
933379 933379 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   grade_2 5 18 19 1   1     0   0   23 21                       44 5 18 19 1   1     0   0   23 21                 44
933410 933410 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_2 12 4 4 0   0     0   0   14 6                       20 12 4 4 0   0     0   0   14 6                 20
933436 933436 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_2 43 4 33 0   1     0   0   49 32                       81 43 4 33 0   1     0   0   49 32                 81
933479 933479 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2016   grade_2 4 4 12 0   0     0   0   5 15                       20 4 4 12 0   0     0   0   5 15                 20
933500 933500 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_2 0 14 38 0   0     0   0   27 25                       52 0 14 38 0   0     0   0   27 25                 52
933541 933541 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_2 1 5 4 0   0     0   0   6 4                       10 1 5 4 0   0     0   0   6 4                 10
933638 933638 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_2 3 36 64 0   0     1   0   54 50                       104 3 36 64 0   0     1   0   54 50                 104
933832 933832 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_2 65 0 0 1   1     0   0   33 34                       67 65 0 0 1   1     0   0   33 34                 67
933872 933872 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No 1 KG 05 2016   grade_2 67 1 1 1   11     0   0   32 49                       81 67 1 1 1   11     0   0   32 49                 81
933895 933895 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 KG 05 2016   grade_2 40 1 4 1   9     0   0   25 30                       55 40 1 4 1   9     0   0   25 30                 55
933921 933921 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_2 37 3 0 0   1     0   0   21 20                       41 37 3 0 0   1     0   0   21 20                 41
934149 934149 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No 1 KG 05 2016   grade_2 57 8 5 0   16     0   0   45 41                       86 57 8 5 0   16     0   0   45 41                 86
934416 934416 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2016   grade_2 15 1 8 0   0     0   0   16 8                       24 15 1 8 0   0     0   0   16 8                 24
934490 934490 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No 1 PK 02 2016   grade_2 130 3 1 0   1     0   0   72 63                       135 130 3 1 0   1     0   0   72 63                 135
934524 934524 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_2 17 0 1 0   0     0   0   12 6                       18 17 0 1 0   0     0   0   12 6                 18
934550 934550 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No 1 KG 05 2016   grade_2 43 1 2 0   3     0   0   25 24                       49 43 1 2 0   3     0   0   25 24                 49
934667 934667 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_2 56 9 5 0   4     0   0   39 35                       74 56 9 5 0   4     0   0   39 35                 74
934728 934728 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2016   grade_2 34 0 4 0   2     0   0   25 15                       40 34 0 4 0   2     0   0   25 15                 40
934765 934765 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No 1 PK 02 2016   grade_2 80 3 0 0   5     0   0   44 44                       88 80 3 0 0   5     0   0   44 44                 88
934814 934814 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No 1 PK 04 2016   grade_2 13 5 28 0   3     0   0   26 23                       49 13 5 28 0   3     0   0   26 23                 49
934873 934873 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No 1 KG 05 2016   grade_2 66 1 8 1   2     0   0   31 47                       78 66 1 8 1   2     0   0   31 47                 78
935060 935060 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_2 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
935069 935069 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2016   grade_2 52 0 2 0   2     1   0   26 31                       57 52 0 2 0   2     1   0   26 31                 57
935157 935157 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2016   grade_2 48 1 0 0   10     1   0   30 30                       60 48 1 0 0   10     1   0   30 30                 60
935163 935163 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   grade_2 69 1 0 0   2     1   0   39 34                       73 69 1 0 0   2     1   0   39 34                 73
935181 935181 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2016   grade_2 46 0 3 1   3     0   0   31 22                       53 46 0 3 1   3     0   0   31 22                 53
935187 935187 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2016   grade_2 34 2 1 0   0     0   0   19 18                       37 34 2 1 0   0     0   0   19 18                 37
935253 935253 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_2 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
935290 935290 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_2 94 1 8 0   28     0   0   63 68                       131 94 1 8 0   28     0   0   63 68                 131
935323 935323 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 04 2016   grade_2 51 1 3 0   0     0   0   22 33                       55 51 1 3 0   0     0   0   22 33                 55
935373 935373 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No 1 PK 04 2016   grade_2 60 1 2 0   2     0   0   42 23                       65 60 1 2 0   2     0   0   42 23                 65
935378 935378 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2016   grade_2 103 0 2 0   0     0   0   52 53                       105 103 0 2 0   0     0   0   52 53                 105
935407 935407 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_2 33 0 3 0   0     0   0   17 19                       36 33 0 3 0   0     0   0   17 19                 36
935421 935421 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2016   grade_2 44 3 14 0   0     0   0   30 31                       61 44 3 14 0   0     0   0   30 31                 61
935432 935432 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2016   grade_2 58 4 19 1   2     0   0   42 42                       84 58 4 19 1   2     0   0   42 42                 84
935532 935532 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   grade_2 18 0 0 0   1     0   0   10 9                       19 18 0 0 0   1     0   0   10 9                 19
935591 935591 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_2 6 3 42 0   0     0   0   27 24                       51 6 3 42 0   0     0   0   27 24                 51
935610 935610 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 PK 08 2016   grade_2 10 3 38 0   1     0   0   31 21                       52 10 3 38 0   1     0   0   31 21                 52
935688 935688 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2016   grade_2 70 1 0 0   0     0   0   46 25                       71 70 1 0 0   0     0   0   46 25                 71
935742 935742 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 KG 05 2016   grade_2 9 3 126 0   5     0   0   74 69                       143 9 3 126 0   5     0   0   74 69                 143
935748 935748 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   grade_2 3 0 124 0   0     0   0   64 63                       127 3 0 124 0   0     0   0   64 63                 127
935771 935771 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2016   grade_2 2 3 88 0   1     0   0   50 44                       94 2 3 88 0   1     0   0   50 44                 94
935786 935786 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_2 3 1 91 0   0     0   0   46 49                       95 3 1 91 0   0     0   0   46 49                 95
935791 935791 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_2 1 4 91 0   1     0   0   42 55                       97 1 4 91 0   1     0   0   42 55                 97
935804 935804 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_2 3 0 70 0   0     0   0   34 39                       73 3 0 70 0   0     0   0   34 39                 73
935810 935810 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_2 3 0 79 0   1     0   0   40 43                       83 3 0 79 0   1     0   0   40 43                 83
935859 935859 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_2 0 0 7 0   0     0   0   6 1                       7 0 0 7 0   0     0   0   6 1                 7
935895 935895 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2016   grade_2 104 11 3 1   1     0   0   66 54                       120 104 11 3 1   1     0   0   66 54                 120
935961 935961 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_2 13 0 2 0   0     0   0   9 6                       15 13 0 2 0   0     0   0   9 6                 15
936327 936327 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_2 1 2 7 0   1     0   0   10 1                       11 1 2 7 0   1     0   0   10 1                 11
936334 936334 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No 1 KG 05 2016   grade_2 16 3 25 0   3     0   0   22 25                       47 16 3 25 0   3     0   0   22 25                 47
936472 936472 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No 1 KG 03 2016   grade_2 60 3 4 0   2     0   0   34 35                       69 60 3 4 0   2     0   0   34 35                 69
936541 936541 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2016   grade_2 44 0 0 0   1     0   0   23 22                       45 44 0 0 0   1     0   0   23 22                 45
936547 936547 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2016   grade_2 62 0 4 0   1     0   0   32 35                       67 62 0 4 0   1     0   0   32 35                 67
936554 936554 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No 1 PK 05 2016   grade_2 59 1 3 1   4     0   0   35 33                       68 59 1 3 1   4     0   0   35 33                 68
936704 936704 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Winthrop   Regular School No 1 KG 05 2016   grade_2 50 6 3 0   3     0   0   33 29                       62 50 6 3 0   3     0   0   33 29                 62
936888 936888 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2016   grade_2 11 0 0 0   1     0   0   6 6                       12 11 0 0 0   1     0   0   6 6                 12
936985 936985 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No 1 KG 05 2016   grade_2 37 2 11 0   0     0   0   26 24                       50 37 2 11 0   0     0   0   26 24                 50
937018 937018 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No 1 KG 05 2016   grade_2 25 9 32 0   0     0   0   32 34                       66 25 9 32 0   0     0   0   32 34                 66
937130 937130 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No 1 PK 03 2016   grade_2 163 3 3 1   1     0   0   85 86                       171 163 3 3 1   1     0   0   85 86                 171
937198 937198 MA Middlesex   school 2508610 207   Newton 250861001377 2070100 Peirce   Regular School No 1 KG 05 2016   grade_2 32 2 6 0   4     0   0   24 20                       44 32 2 6 0   4     0   0   24 20                 44
937211 937211 MA Middlesex   school 2508610 207   Newton 250861001379 2070115 Underwood   Regular School No 1 KG 05 2016   grade_2 30 2 6 0   13     0   0   21 30                       51 30 2 6 0   13     0   0   21 30                 51
937365 937365 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No 1 KG 05 2016   grade_2 50 2 7 2   1     0   0   26 36                       62 50 2 7 2   1     0   0   26 36                 62
937371 937371 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 Falls   Regular School No 1 KG 05 2016   grade_2 40 1 0 0   2     0   0   32 11                       43 40 1 0 0   2     0   0   32 11                 43
937383 937383 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No 1 KG 05 2016   grade_2 47 1 0 0   3     0   0   22 29                       51 47 1 0 0   3     0   0   22 29                 51
937473 937473 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No 1 PK 05 2016   grade_2 58 0 0 0   4     0   0   29 33                       62 58 0 0 0   4     0   0   29 33                 62
937534 937534 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2016   grade_2 45 9 1 0   6     0   0   27 34                       61 45 9 1 0   6     0   0   27 34                 61
937544 937544 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No 1 KG 05 2016   grade_2 32 4 2 0   10     0   0   27 21                       48 32 4 2 0   10     0   0   27 21                 48
937577 937577 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2016   grade_2 41 0 1 0   3     0   0   27 18                       45 41 0 1 0   3     0   0   27 18                 45
937635 937635 MA Essex   school 2509360 229   Peabody 250936001493 2290015 Center   Regular School No 1 KG 05 2016   grade_2 52 5 4 0   3     0   0   34 30                       64 52 5 4 0   3     0   0   34 30                 64
937663 937663 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No 1 PK 05 2016   grade_2 33 0 2 0   0     0   0   20 15                       35 33 0 2 0   0     0   0   20 15                 35
937677 937677 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2016   grade_2 19 0 0 0   1     0   0   8 12                       20 19 0 0 0   1     0   0   8 12                 20
937691 937691 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2016   grade_2 48 1 0 0   0     0   0   34 15                       49 48 1 0 0   0     0   0   34 15                 49
937838 937838 MA Plymouth   school 2509720 239   Plymouth 250972001548 2390047 West Elementary   Regular School No 1 PK 05 2016   grade_2 60 0 3 0   1     0   0   28 36                       64 60 0 3 0   1     0   0   28 36                 64
937905 937905 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No 1 KG 05 2016   grade_2 31 4 3 0   14     0   0   26 26                       52 31 4 3 0   14     0   0   26 26                 52
937917 937917 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No 1 KG 05 2016   grade_2 12 0 4 0   38     0   0   28 26                       54 12 0 4 0   38     0   0   28 26                 54
937930 937930 MA Norfolk   school 2509870 243   Quincy 250987001583 2430095 Squantum   Regular School No 1 KG 05 2016   grade_2 34 4 4 1   14     0   0   25 32                       57 34 4 4 1   14     0   0   25 32                 57

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