enrollments

Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2016 sorted by multiracial_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 392 ✖

grade ✖

  • grade_9 · 392 ✖
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
933714 933714 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
934033 934033 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   3 2                       5                         3 2                 5
936655 936655 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   1 *                       1                         1                   1
938833 938833 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   3 2                       5                         3 2                 5
938837 938837 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2016   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
939063 939063 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2016   grade_9 * * * *   *     *   *   4 1                       5                         4 1                 5
939288 939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
939787 939787 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_9 * * * *   *     *   *   1 4                       5                         1 4                 5
933107 933107 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 4 06 12 2016   grade_9 1 1 1 0   3     0   0   3 3                       6 1 1 1 0   3     0   0   3 3                 6
933547 933547 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_9 5 19 14 0   0     0   0   29 9                       38 5 19 14 0   0     0   0   29 9                 38
933675 933675 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2016   grade_9 0 7 0 0   0     0   0   5 2                       7 0 7 0 0   0     0   0   5 2                 7
933702 933702 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2016   grade_9 7 27 62 0   4     1   0   49 52                       101 7 27 62 0   4     1   0   49 52                 101
933710 933710 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2016   grade_9 1 48 29 0   2     0   0   33 47                       80 1 48 29 0   2     0   0   33 47                 80
933730 933730 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No 3 09 12 2016   grade_9 1 4 80 0   0     0   0   39 46                       85 1 4 80 0   0     0   0   39 46                 85
933768 933768 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2016   grade_9 2 24 5 0   0     0   0   13 18                       31 2 24 5 0   0     0   0   13 18                 31
933819 933819 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_9 0 3 3 0   1     0   0   2 5                       7 0 3 3 0   1     0   0   2 5                 7
933825 933825 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_9 1 9 6 1   0     0   0   8 9                       17 1 9 6 1   0     0   0   8 9                 17
933993 933993 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 4 06 12 2016   grade_9 3 9 0 0   0     0   0   9 3                       12 3 9 0 0   0     0   0   9 3                 12
934003 934003 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_9 5 1 2 0   0     0   0   5 3                       8 5 1 2 0   0     0   0   5 3                 8
934480 934480 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2016   grade_9 74 3 28 0   5     0   0   53 57                       110 74 3 28 0   5     0   0   53 57                 110
934494 934494 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_9 112 4 1 0   2     0   0   60 59                       119 112 4 1 0   2     0   0   60 59                 119
934837 934837 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 KG 12 2016   grade_9 2 3 5 0   0     0   0   7 3                       10 2 3 5 0   0     0   0   7 3                 10
935053 935053 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No 3 09 12 2016   grade_9 4 1 3 0   0     0   0   4 4                       8 4 1 3 0   0     0   0   4 4                 8
935234 935234 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2016   grade_9 88 0 1 0   1     0   0   40 50                       90 88 0 1 0   1     0   0   40 50                 90
935385 935385 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No 3 09 12 2016   grade_9 208 2 1 0   4     0   0   123 92                       215 208 2 1 0   4     0   0   123 92                 215
935414 935414 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_9 27 0 1 0   2     0   0   13 17                       30 27 0 1 0   2     0   0   13 17                 30
935434 935434 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2016   grade_9 6 2 2 0   0     0   0   9 1                       10 6 2 2 0   0     0   0   9 1                 10
935625 935625 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 3 5 104 0   1     0   0   56 57                       113 3 5 104 0   1     0   0   56 57                 113
935828 935828 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2016   grade_9 1 0 14 0   0     0   0   14 1                       15 1 0 14 0   0     0   0   14 1                 15
935832 935832 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2016   grade_9 0 2 32 0   1     0   0   21 14                       35 0 2 32 0   1     0   0   21 14                 35
935836 935836 MA Essex   school 2506660 149   Lawrence 250666002633 1490532 Humanities & Leadership Development High School   Regular School No 3 09 12 2016   grade_9 0 1 26 0   1     0   0   23 5                       28 0 1 26 0   1     0   0   23 5                 28
935841 935841 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2016   grade_9 1 0 28 0   0     0   0   22 7                       29 1 0 28 0   0     0   0   22 7                 29
935845 935845 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2016   grade_9 1 1 22 0   0     0   0   20 4                       24 1 1 22 0   0     0   0   20 4                 24
935849 935849 MA Essex   school 2506660 149   Lawrence 250666002616 1490535 Performing & Fine Arts High School   Regular School No 3 09 12 2016   grade_9 0 0 8 0   0     0   0   4 4                       8 0 0 8 0   0     0   0   4 4                 8
935854 935854 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2016   grade_9 0 0 8 0   0     0   0   7 1                       8 0 0 8 0   0     0   0   7 1                 8
935866 935866 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_9 2 0 19 0   0     0   0   17 4                       21 2 0 19 0   0     0   0   17 4                 21
935871 935871 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2016   grade_9 1 2 42 0   1     0   0   25 21                       46 1 2 42 0   1     0   0   25 21                 46
935899 935899 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2016   grade_9 95 6 4 1   2     1   0   54 55                       109 95 6 4 1   2     1   0   54 55                 109
936187 936187 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2016   grade_9 0 0 5 0   1     0   0   4 2                       6 0 0 5 0   1     0   0   4 2                 6
936237 936237 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2016   grade_9 101 1 5 1   8     1   0   58 59                       117 101 1 5 1   8     1   0   58 59                 117
936832 936832 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No 3 09 12 2016   grade_9 82 2 2 1   1     0   0   34 54                       88 82 2 2 1   1     0   0   34 54                 88
937123 937123 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2016   grade_9 8 5 15 1   0     0   0   22 7                       29 8 5 15 1   0     0   0   22 7                 29
937588 937588 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_9 5 1 2 0   0     0   0   6 *                       8 5 1 2 0   0     0   0   6                   8
938220 938220 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2016   grade_9 167 1 0 1   2     0   0   88 83                       171 167 1 0 1   2     0   0   88 83                 171
938252 938252 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2016   grade_9 148 7 16 1   8     1   0   84 97                       181 148 7 16 1   8     1   0   84 97                 181
938524 938524 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2016   grade_9 81 1 79 0   1     0   0   96 66                       162 81 1 79 0   1     0   0   96 66                 162
938538 938538 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley High   Regular School No 3 09 12 2016   grade_9 115 3 4 0   3     0   0   63 62                       125 115 3 4 0   3     0   0   63 62                 125
938821 938821 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No 3 09 12 2016   grade_9 2 6 22 0   0     0   0   18 12                       30 2 6 22 0   0     0   0   18 12                 30
940239 940239 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_9 12 18 79 2   4     0   0   56 59                       115 12 18 79 2   4     0   0   56 59                 115
940369 940369 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_9 0 38 13 0   0     1   0   26 26                       52 0 38 13 0   0     1   0   26 26                 52
940552 940552 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_9 5 0 1 0   0     0   0   3 3                       6 5 0 1 0   0     0   0   3 3                 6
940641 940641 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_9 68 1 2 0   5     0   0   41 35                       76 68 1 2 0   5     0   0   41 35                 76
940653 940653 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_9 31 5 28 0   3     0   0   29 38                       67 31 5 28 0   3     0   0   29 38                 67
940713 940713 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2016   grade_9 4 10 66 0   1     0   0   45 36                       81 4 10 66 0   1     0   0   45 36                 81
940719 940719 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes 3 07 12 2016   grade_9 20 29 11 1   8     0   0   28 41                       69 20 29 11 1   8     0   0   28 41                 69
940820 940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
941880 941880 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 67 6 322 0   2     0   0   201 196                       397 67 6 322 0   2     0   0   201 196                 397
941962 941962 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes 3 09 12 2016   grade_9 12 7 102 0   0     0   0   54 67                       121 12 7 102 0   0     0   0   54 67                 121
941976 941976 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes 4 09 11 2016   grade_9 2 103 21 0   2     0   0   61 67                       128 2 103 21 0   2     0   0   61 67                 128
932820 932820 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_9 23 21 4 0   2     0   1   29 22                       51 23 21 4 0   2     0   1   29 22                 51
932895 932895 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 08 12 2016   grade_9 127 1 3 0   4     0   1   76 60                       136 127 1 3 0   4     0   1   76 60                 136
932900 932900 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_9 5 0 1 0   0     0   1   4 3                       7 5 0 1 0   0     0   1   4 3                 7
933150 933150 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 11 2016   grade_9 0 32 11 0   0     0   1   24 20                       44 0 32 11 0   0     0   1   24 20                 44
933647 933647 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_9 8 32 22 1   7     0   1   46 25                       71 8 32 22 1   7     0   1   46 25                 71
933666 933666 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2016   grade_9 3 49 102 0   3     2   1   91 69                       160 3 49 102 0   3     2   1   91 69                 160
933706 933706 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2016   grade_9 8 16 25 0   4     0   1   31 23                       54 8 16 25 0   4     0   1   31 23                 54
933747 933747 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2016   grade_9 1 14 11 0   32     0   1   35 24                       59 1 14 11 0   32     0   1   35 24                 59
933772 933772 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2016   grade_9 11 4 12 0   2     0   1   16 14                       30 11 4 12 0   2     0   1   16 14                 30
933797 933797 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No 3 09 12 2016   grade_9 8 47 79 0   9     2   1   77 69                       146 8 47 79 0   9     2   1   77 69                 146
934410 934410 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2016   grade_9 11 0 9 0   0     0   1   14 7                       21 11 0 9 0   0     0   1   14 7                 21
934641 934641 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2016   grade_9 104 0 2 0   0     0   1   56 51                       107 104 0 2 0   0     0   1   56 51                 107
934709 934709 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_9 140 4 0 0   0     0   1   67 78                       145 140 4 0 0   0     0   1   67 78                 145
934758 934758 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2016   grade_9 175 11 9 1   7     1   1   101 104                       205 175 11 9 1   7     1   1   101 104                 205
935086 935086 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No 3 09 12 2016   grade_9 183 8 3 0   8     0   1   112 91                       203 183 8 3 0   8     0   1   112 91                 203
935220 935220 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_9 11 0 0 0   0     0   1   2 10                       12 11 0 0 0   0     0   1   2 10                 12
935311 935311 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_9 47 0 1 0   2     0   1   31 20                       51 47 0 1 0   2     0   1   31 20                 51
935352 935352 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2016   grade_9 35 3 6 0   1     1   1   21 26                       47 35 3 6 0   1     1   1   21 26                 47
935400 935400 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_9 84 4 4 0   12     0   1   55 50                       105 84 4 4 0   12     0   1   55 50                 105
935525 935525 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_9 29 13 12 1   2     0   1   31 27                       58 29 13 12 1   2     0   1   31 27                 58
935695 935695 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2016   grade_9 78 0 3 0   0     0   1   42 40                       82 78 0 3 0   0     0   1   42 40                 82
935954 935954 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No 3 09 12 2016   grade_9 4 1 1 0   0     0   1   3 4                       7 4 1 1 0   0     0   1   3 4                 7
937706 937706 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2016   grade_9 237 4 1 0   1     0   1   124 120                       244 237 4 1 0   1     0   1   124 120                 244
938035 938035 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2016   grade_9 299 8 5 0   15     0   1   165 163                       328 299 8 5 0   15     0   1   165 163                 328
938145 938145 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No 3 09 12 2016   grade_9 75 0 1 0   1     0   1   41 37                       78 75 0 1 0   1     0   1   41 37                 78
938757 938757 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_9 25 27 43 0   2     0   1   49 49                       98 25 27 43 0   2     0   1   49 49                 98
938765 938765 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 4 06 10 2016   grade_9 9 14 30 0   0     0   1   43 11                       54 9 14 30 0   0     0   1   43 11                 54
938799 938799 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No 4 06 10 2016   grade_9 12 13 28 0   0     0   1   11 43                       54 12 13 28 0   0     0   1   11 43                 54
938829 938829 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield High School   Regular School No 3 09 12 2016   grade_9 9 11 38 0   0     0   1   44 15                       59 9 11 38 0   0     0   1   44 15                 59
938841 938841 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_9 38 57 255 0   7     1   1   162 197                       359 38 57 255 0   7     1   1   162 197                 359
939008 939008 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No 3 09 12 2016   grade_9 126 4 3 0   2     0   1   70 66                       136 126 4 3 0   2     0   1   70 66                 136
939082 939082 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No 3 09 12 2016   grade_9 222 6 4 0   9     0   1   126 116                       242 222 6 4 0   9     0   1   126 116                 242
939272 939272 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_9 78 1 6 0   1     0   1   41 46                       87 78 1 6 0   1     0   1   41 46                 87
939677 939677 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2016   grade_9 231 8 6 0   14     0   1   134 126                       260 231 8 6 0   14     0   1   134 126                 260
940242 940242 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2016   grade_9 5 44 21 0   1     0   1   35 37                       72 5 44 21 0   1     0   1   35 37                 72
940271 940271 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_9 3 57 14 0   1     0   1   41 35                       76 3 57 14 0   1     0   1   41 35                 76
940464 940464 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_9 47 18 14 0   3     0   1   31 52                       83 47 18 14 0   3     0   1   31 52                 83
940705 940705 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_9 49 2 8 0   3     0   1   29 34                       63 49 2 8 0   3     0   1   29 34                 63
940727 940727 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_9 25 8 14 1   1     0   1   24 26                       50 25 8 14 1   1     0   1   24 26                 50
941143 941143 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No 3 09 12 2016   grade_9 63 0 5 1   0     0   1   39 31                       70 63 0 5 1   0     0   1   39 31                 70
941510 941510 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2016   grade_9 150 1 6 0   1     0   1   74 85                       159 150 1 6 0   1     0   1   74 85                 159

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