Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2019 sorted by female_int

View and edit SQL

year

  • 2019 · 493

grade

  • grade_8 · 493
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
2041275 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_8 0 1 3 1   0     0   1   4 *                       6.0 0 1 3 1   0     0   1   4                   6
2042772 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_8 * * * *   *     *   *   2 *                       2.0                         2                   2
2043455 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2045782 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_8 3 1 4 0   0     0   0   5 *                       8.0 3 1 4 0   0     0   0   5                   8
2041289 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_8 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2042370 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2043676 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2045173 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_8 4 1 2 0   0     0   0   6 1                       7.0 4 1 2 0   0     0   0   6 1                 7
2045508 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_8 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2042138 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_8 3 2 3 0   0     0   0   6 2                       8.0 3 2 3 0   0     0   0   6 2                 8
2044423 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_8 3 5 4 0   1     0   3   14 2                       16.0 3 5 4 0   1     0   3   14 2                 16
2045829 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 08 12 2019   grade_8 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2046088 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_8 0 6 11 0   0     0   0   15 2                       17.0 0 6 11 0   0     0   0   15 2                 17
2048519 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   grade_8 13 0 2 0   0     0   0   13 2                       15.0 13 0 2 0   0     0   0   13 2                 15
2042271 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_8 4 0 2 0   0     0   0   3 3                       6.0 4 0 2 0   0     0   0   3 3                 6
2040175 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_8 6 0 0 0   0     0   0   1 4                       6.0 6 0 0 0   0     0   0   1 4                 6
2041101 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_8 0 3 3 0   0     0   0   2 4                       6.0 0 3 3 0   0     0   0   2 4                 6
2040325 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_8 3 2 5 0   3     0   1   8 6                       14.0 3 2 5 0   3     0   1   8 6                 14
2040825 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_8 3 14 11 1   0     0   0   23 6                       29.0 3 14 11 1   0     0   0   23 6                 29
2040911 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_8 3 2 7 1   0     0   0   7 6                       13.0 3 2 7 1   0     0   0   7 6                 13
2043669 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_8 1 1 9 1   0     0   1   7 6                       13.0 1 1 9 1   0     0   1   7 6                 13
2045406 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_8 11 0 0 0   0     0   1   6 6                       12.0 11 0 0 0   0     0   1   6 6                 12
2040696 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_8 9 2 1 0   0     0   0   4 8                       12.0 9 2 1 0   0     0   0   4 8                 12
2044417 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_8 9 3 7 0   0     0   1   12 8                       20.0 9 3 7 0   0     0   1   12 8                 20
2047680 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_8 0 17 1 0   0     0   0   10 8                       18.0 0 17 1 0   0     0   0   10 8                 18
2041703 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_8 4 0 11 0   0     0   1   7 9                       16.0 4 0 11 0   0     0   1   7 9                 16
2041760 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_8 15 0 0 0   0     0   0   6 9                       15.0 15 0 0 0   0     0   0   6 9                 15
2042279 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_8 13 2 4 0   0     0   2   12 9                       21.0 13 2 4 0   0     0   2   12 9                 21
2047704 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_8 1 0 18 0   1     0   0   11 9                       20.0 1 0 18 0   1     0   0   11 9                 20
2047850 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_8 12 2 3 0   0     0   2   10 9                       19.0 12 2 3 0   0     0   2   10 9                 19
2040597 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_8 0 0 16 0   0     0   0   6 10                       16.0 0 0 16 0   0     0   0   6 10                 16
2040874 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_8 0 16 10 0   0     0   0   16 10                       26.0 0 16 10 0   0     0   0   16 10                 26
2040901 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_8 0 22 11 0   0     0   0   23 10                       33.0 0 22 11 0   0     0   0   23 10                 33
2040811 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_8 6 5 13 0   2     0   1   16 11                       27.0 6 5 13 0   2     0   1   16 11                 27
2040847 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_8 2 15 7 0   0     0   1   14 11                       25.0 2 15 7 0   0     0   1   14 11                 25
2046096 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2019   grade_8 0 3 17 0   0     0   2   11 11                       22.0 0 3 17 0   0     0   2   11 11                 22
2040784 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_8 0 6 18 0   0     0   1   13 12                       25.0 0 6 18 0   0     0   1   13 12                 25
2040794 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_8 6 6 23 0   1     0   0   24 12                       36.0 6 6 23 0   1     0   0   24 12                 36
2040881 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_8 1 12 10 0   0     0   1   12 12                       24.0 1 12 10 0   0     0   1   12 12                 24
2046412 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_8 19 2 10 0   0     0   1   20 12                       32.0 19 2 10 0   0     0   1   20 12                 32
2047781 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 27 0 1 0   0     0   2   18 12                       30.0 27 0 1 0   0     0   2   18 12                 30
2041094 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_8 0 0 22 0   0     0   0   9 13                       22.0 0 0 22 0   0     0   0   9 13                 22
2040471 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_8 12 1 11 0   5     0   1   16 14                       30.0 12 1 11 0   5     0   1   16 14                 30
2040359 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2019   grade_8 1 14 18 0   3     0   1   22 15                       37.0 1 14 18 0   3     0   1   22 15                 37
2040655 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_8 0 6 20 0   0     0   0   11 15                       26.0 0 6 20 0   0     0   0   11 15                 26
2042932 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_8 5 1 33 0   0     0   0   24 15                       39.0 5 1 33 0   0     0   0   24 15                 39
2047694 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_8 1 12 8 0   0     0   1   7 15                       22.0 1 12 8 0   0     0   1   7 15                 22
2040349 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_8 2 9 16 0   1     0   0   12 16                       28.0 2 9 16 0   1     0   0   12 16                 28
2042090 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_8 23 0 6 0   0     0   3   16 16                       32.0 23 0 6 0   0     0   3   16 16                 32
2042718 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_8 28 0 3 0   0     0   0   15 16                       31.0 28 0 3 0   0     0   0   15 16                 31
2045751 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_8 21 2 16 0   4     0   0   27 16                       43.0 21 2 16 0   4     0   0   27 16                 43
2045961 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_8 7 7 12 0   0     0   3   13 16                       29.0 7 7 12 0   0     0   3   13 16                 29
2047813 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 18 1 7 0   0     0   1   11 16                       27.0 18 1 7 0   0     0   1   11 16                 27
2047841 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2019   grade_8 33 3 3 1   1     0   0   25 16                       41.0 33 3 3 1   1     0   0   25 16                 41
2040624 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_8 12 7 9 0   0     0   0   11 17                       28.0 12 7 9 0   0     0   0   11 17                 28
2045770 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2019   grade_8 17 4 8 0   3     0   2   17 17                       34.0 17 4 8 0   3     0   2   17 17                 34
2047921 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_8 24 1 1 0   0     0   2   11 17                       28.0 24 1 1 0   0     0   2   11 17                 28
2040488 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_8 6 16 16 1   0     0   0   21 18                       39.0 6 16 16 1   0     0   0   21 18                 39
2040722 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_8 9 7 18 0   0     0   0   16 18                       34.0 9 7 18 0   0     0   0   16 18                 34
2042886 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_8 10 1 22 0   0     0   1   16 18                       34.0 10 1 22 0   0     0   1   16 18                 34
2042906 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_8 2 1 38 0   0     0   0   23 18                       41.0 2 1 38 0   0     0   0   23 18                 41
2044751 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2019   grade_8 39 1 3 0   0     0   3   28 18                       46.0 39 1 3 0   0     0   3   28 18                 46
2047550 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2019   grade_8 34 0 3 0   0     0   1   20 18                       38.0 34 0 3 0   0     0   1   20 18                 38
2042618 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_8 53 0 5 0   1     0   0   40 19                       59.0 53 0 5 0   1     0   0   40 19                 59
2045741 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary KG 08 2019   grade_8 28 7 4 0   1     1   1   23 19                       42.0 28 7 4 0   1     1   1   23 19                 42
2045732 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_8 12 7 11 0   6     1   2   19 20                       39.0 12 7 11 0   6     1   2   19 20                 39
2047446 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2019   grade_8 4 6 21 0   10     0   3   23 21                       44.0 4 6 21 0   10     0   3   23 21                 44
2047764 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 25 2 3 0   15     0   1   25 21                       46.0 25 2 3 0   15     0   1   25 21                 46
2040444 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_8 3 11 27 0   1     0   1   21 22                       43.0 3 11 27 0   1     0   1   21 22                 43
2042657 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_8 37 1 3 0   0     4   1   24 22                       46.0 37 1 3 0   0     4   1   24 22                 46
2047524 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_8 10 9 20 0   0     0   1   18 22                       40.0 10 9 20 0   0     0   1   18 22                 40
2049075 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_8 38 2 2 0   0     0   1   21 22                       43.0 38 2 2 0   0     0   1   21 22                 43
2042109 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_8 5 7 25 3   3     0   2   22 23                       45.0 5 7 25 3   3     0   2   22 23                 45
2045489 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2019   grade_8 26 1 18 0   0     0   4   25 24                       49.0 26 1 18 0   0     0   4   25 24                 49
2047953 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_8 3 19 25 0   0     0   2   25 24                       49.0 3 19 25 0   0     0   2   25 24                 49
2048733 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2019   grade_8 57 2 6 0   4     0   1   46 24                       70.0 57 2 6 0   4     0   1   46 24                 70
2040864 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   grade_8 6 12 38 1   2     0   0   34 25                       59.0 6 12 38 1   2     0   0   34 25                 59
2041032 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_8 4 11 16 0   25     0   2   33 25                       58.0 4 11 16 0   25     0   2   33 25                 58
2042223 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_8 28 5 18 1   2     0   1   30 25                       55.0 28 5 18 1   2     0   1   30 25                 55
2042897 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_8 6 1 59 0   0     0   0   41 25                       66.0 6 1 59 0   0     0   0   41 25                 66
2043008 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_8 67 0 1 0   0     0   0   43 25                       68.0 67 0 1 0   0     0   0   43 25                 68
2040928 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_8 12 22 16 0   8     0   2   34 26                       60.0 12 22 16 0   8     0   2   34 26                 60
2041466 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_8 14 2 13 0   0     0   7   10 26                       36.0 14 2 13 0   0     0   7   10 26                 36
2043395 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   grade_8 25 1 19 0   7     0   2   28 26                       54.0 25 1 19 0   7     0   2   28 26                 54
2044867 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   grade_8 31 2 9 1   1     0   5   23 26                       49.0 31 2 9 1   1     0   5   23 26                 49
2048036 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2019   grade_8 26 1 2 0   5     0   8   16 26                       42.0 26 1 2 0   5     0   8   16 26                 42
2049066 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_8 57 1 3 0   1     0   1   37 26                       63.0 57 1 3 0   1     0   1   37 26                 63
2049339 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 09 2019   grade_8 25 7 19 0   1     0   1   27 26                       53.0 25 7 19 0   1     0   1   27 26                 53
2041363 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   grade_8 38 6 3 0   14     0   7   41 27                       68.0 38 6 3 0   14     0   7   41 27                 68
2043727 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2019   grade_8 21 10 19 0   7     0   0   30 27                       57.0 21 10 19 0   7     0   0   30 27                 57
2045780 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_8 8 10 32 0   5     0   0   28 27                       55.0 8 10 32 0   5     0   0   28 27                 55
2047535 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 High 06 12 2019   grade_8 4 27 29 0   0     0   1   34 27                       61.0 4 27 29 0   0     0   1   34 27                 61
2040712 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_8 12 20 40 0   2     0   1   47 28                       75.0 12 20 40 0   2     0   1   47 28                 75
2047583 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2019   grade_8 0 39 17 1   1     1   0   31 28                       59.0 0 39 17 1   1     1   0   31 28                 59
2040430 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_8 0 42 17 0   0     0   2   32 29                       61.0 0 42 17 0   0     0   2   32 29                 61
2040607 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_8 4 35 15 0   2     2   3   32 29                       61.0 4 35 15 0   2     2   3   32 29                 61
2041373 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   grade_8 36 5 4 0   12     0   1   29 29                       58.0 36 5 4 0   12     0   1   29 29                 58
2043315 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_8 33 5 9 1   1     0   4   24 29                       53.0 33 5 9 1   1     0   4   24 29                 53
2047804 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_8 0 0 49 0   0     0   0   20 29                       49.0 0 0 49 0   0     0   0   20 29                 49
2042233 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_8 19 3 21 0   1     0   3   17 30                       47.0 19 3 21 0   1     0   3   17 30                 47

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