Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by total

View and edit SQL

year

  • 2021 · 9,536
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
1674749 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1674750 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1674751 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1674753 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1674754 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1674756 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1674760 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1674761 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1674762 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1674763 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   sped_beyond_grade_12 * * * *   *     *   *   * * *                     0.0                                             0
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
1675698 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1675699 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1675700 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1675701 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1675702 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1675703 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1675704 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1675705 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1675707 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1675708 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1675709 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1675710 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1674752 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_2 * * * *   *     *   *   * * *                     1.0                                             1
1674755 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_5 * * * *   *     *   *   * * *                     1.0                                             1
1675613 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1678325 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Springfield - Liberty Preparatory Academy   Regular School No High 09 12 2021   grade_12 * * * *   *     *   *   1 * *                     1.0                         1                   1
1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
1680455 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_12 * * * *   *     *   *   1 * *                     1.0                         1                   1
1672487 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica - Billerica Memorial High School   Regular School No High 08 12 2021   sped_beyond_grade_12 7 0 2 0   0     0   1   6 4 *                     10.0 7 0 2 0   0     0   1   6 4                 10
1672599 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_4 5 0 5 0   0     0   0   4 6 *                     10.0 5 0 5 0   0     0   0   4 6                 10
1672637 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston - Edward Everett   Regular School No Elementary PK 06 2021   pre_kindergarten 2 4 3 0   1     0   0   9 1 *                     10.0 2 4 3 0   1     0   0   9 1                 10
1672952 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_6 1 5 4 0   0     0   0   5 5 *                     10.0 1 5 4 0   0     0   0   5 5                 10
1673368 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1673454 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_9 3 4 2 0   0     0   1   8 2 *                     10.0 3 4 2 0   0     0   1   8 2                 10
1673528 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   pre_kindergarten 8 0 1 0   0     0   1   6 4 *                     10.0 8 0 1 0   0     0   1   6 4                 10
1674224 MA Bristol   school 2504620 88   Easton 250462002381 880020 Easton - Moreau Hall   Regular School No Elementary PK 02 2021   pre_kindergarten 7 1 0 0   1     0   1   4 6 *                     10.0 7 1 0 0   1     0   1   4 6                 10
1674295 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_7 4 2 3 0   0     0   1   9 1 *                     10.0 4 2 3 0   0     0   1   9 1                 10
1674432 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_8 4 2 3 0   0     0   1   8 2 *                     10.0 4 2 3 0   0     0   1   8 2                 10
1674434 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_10 7 1 2 0   0     0   0   7 3 *                     10.0 7 1 2 0   0     0   0   7 3                 10
1674917 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_9 2 0 8 0   0     0   0   9 1 *                     10.0 2 0 8 0   0     0   0   9 1                 10
1675395 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster - Leominster Center for Excellence   Regular School No High 09 12 2021   grade_9 6 1 3 0   0     0   0   6 4 *                     10.0 6 1 3 0   0     0   0   6 4                 10
1675615 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_8 4 0 6 0   0     0   0   9 * *                     10.0 4 0 6 0   0     0   0   9                   10
1675636 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Lowell - Leblanc Therapeutic Day School   Regular School No High 08 12 2021   grade_11 2 0 7 0   0     0   1   4 6 *                     10.0 2 0 7 0   0     0   1   4 6                 10
1675842 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_7 3 0 7 0   0     0   0   8 2 *                     10.0 3 0 7 0   0     0   0   8 2                 10
1675843 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_8 3 0 4 1   0     0   2   8 2 *                     10.0 3 0 4 1   0     0   2   8 2                 10
1676593 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_8 2 2 5 0   0     0   1   6 4 *                     10.0 2 2 5 0   0     0   1   6 4                 10
1676597 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_12 4 3 2 0   0     0   1   3 7 *                     10.0 4 3 2 0   0     0   1   3 7                 10
1677146 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham - Pelham Elementary   Regular School No Elementary KG 06 2021   grade_1 8 0 0 0   2     0   0   8 2 *                     10.0 8 0 0 0   2     0   0   8 2                 10
1677184 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham - Petersham Center   Regular School No Elementary KG 06 2021   grade_3 7 0 3 0   0     0   0   8 2 *                     10.0 7 0 3 0   0     0   0   8 2                 10
1677341 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_2 3 6 0 0   0     0   1   3 7 *                     10.0 3 6 0 0   0     0   1   3 7                 10
1677342 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_3 7 2 1 0   0     0   0   4 6 *                     10.0 7 2 1 0   0     0   0   4 6                 10
1677347 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_8 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1677473 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   sped_beyond_grade_12 0 9 0 0   1     0   0   8 2 *                     10.0 0 9 0 0   1     0   0   8 2                 10
1677634 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_6 9 0 0 0   0     0   1   5 5 *                     10.0 9 0 0 0   0     0   1   5 5                 10
1677689 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem - Salem Prep High School   Regular School No High 09 12 2021   grade_12 6 0 2 0   1     0   1   6 4 *                     10.0 6 0 2 0   1     0   1   6 4                 10
1677861 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury - Shutesbury Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 6 0 3 0   0     0   1   3 7 *                     10.0 6 0 3 0   0     0   1   3 7                 10
1678285 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield - Balliet Middle School   Regular School No Middle 06 08 2021   grade_8 0 4 6 0   0     0   0   8 * *                     10.0 0 4 6 0   0     0   0   8                   10
1678332 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Springfield - Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2021   grade_11 6 1 3 0   0     0   0   1 9 *                     10.0 6 1 3 0   0     0   0   1 9                 10
1678339 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield - Springfield International Academy at Sci-Tech   Regular School No Secondary 09 11 2021   grade_9 1 0 9 0   0     0   0   6 4 *                     10.0 1 0 9 0   0     0   0   6 4                 10
1678789 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham - Wareham Cooperative Alternative School   Regular School No High 09 12 2021   grade_12 5 3 1 0   0     0   1   7 3 *                     10.0 5 3 1 0   0     0   1   7 3                 10
1679315 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 Winthrop - William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2021   pre_kindergarten 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1679680 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington - R. H. Conwell   Regular School No Elementary PK 06 2021   kindergarten 9 0 1 0   0     0   0   7 3 *                     10.0 9 0 1 0   0     0   0   7 3                 10
1680525 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton-Rehoboth - Dighton Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 8 1 0 0   1     0   0   6 4 *                     10.0 8 1 0 0   1     0   0   6 4                 10
1680592 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_2 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680595 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680596 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_6 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1680623 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Gateway - Chester Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 10 0 0 0   0     0   0   5 5 *                     10.0 10 0 0 0   0     0   0   5 5                 10
1680872 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   kindergarten 10 0 0 0   0     0   0   3 7 *                     10.0 10 0 0 0   0     0   0   3 7                 10
1680878 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680948 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Northboro-Southboro - Algonquin Regional High   Regular School No High 09 12 2021   sped_beyond_grade_12 8 0 0 0   2     0   0   5 5 *                     10.0 8 0 0 0   2     0   0   5 5                 10
1681191 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional - Chilmark Elementary   Regular School No Elementary KG 05 2021   grade_2 10 0 0 0   0     0   0   6 4 *                     10.0 10 0 0 0   0     0   0   6 4                 10
1681192 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional - Chilmark Elementary   Regular School No Elementary KG 05 2021   grade_3 8 0 0 1   0     0   1   5 5 *                     10.0 8 0 0 1   0     0   1   5 5                 10
1672031 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_7 95 1 2 1   1     0   0   55 45 *                     100.0 95 1 2 1   1     0   0   55 45                 100
1672634 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_7 7 1 89 0   1     0   2   51 49 *                     100.0 7 1 89 0   1     0   2   51 49                 100
1673169 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston - The English High   Regular School No High 09 12 2021   grade_9 5 44 43 1   1     0   6   54 46 *                     100.0 5 44 43 1   1     0   6   54 46                 100
1673205 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston - Boston Arts Academy   Alternative School No High 09 12 2021   grade_12 11 43 35 2   2     1   6   32 68 *                     100.0 11 43 35 2   2     1   6   32 68                 100
1673408 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   kindergarten 9 72 12 0   0     0   7   46 54 *                     100.0 9 72 12 0   0     0   7   46 54                 100
1673429 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   kindergarten 17 42 31 0   2     0   8   57 43 *                     100.0 17 42 31 0   2     0   8   57 43                 100
1673447 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_3 17 59 17 1   1     0   5   62 38 *                     100.0 17 59 17 1   1     0   5   62 38                 100
1673708 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_6 36 23 12 0   19     0   10   51 49 *                     100.0 36 23 12 0   19     0   10   51 49                 100
1673807 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_1 6 8 84 1   0     0   1   63 37 *                     100.0 6 8 84 1   0     0   1   63 37                 100
1673813 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_3 6 5 89 0   0     0   0   43 57 *                     100.0 6 5 89 0   0     0   0   43 57                 100
1673829 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_5 8 6 83 0   0     0   3   51 49 *                     100.0 8 6 83 0   0     0   3   51 49                 100
1673937 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   kindergarten 95 0 2 1   0     0   2   54 46 *                     100.0 95 0 2 1   0     0   2   54 46                 100
1674348 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_2 52 12 22 0   1     0   13   46 54 *                     100.0 52 12 22 0   1     0   13   46 54                 100
1674352 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River - Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2021   kindergarten 44 5 32 0   4     0   15   50 50 *                     100.0 44 5 32 0   4     0   15   50 50                 100
1674482 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_3 26 6 54 0   4     0   10   51 49 *                     100.0 26 6 54 0   4     0   10   51 49                 100
1674767 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 Grafton - North Grafton Elementary   Regular School No Elementary PK 01 2021   kindergarten 77 4 6 0   13     0   0   57 43 *                     100.0 77 4 6 0   13     0   0   57 43                 100
1674842 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_4 91 2 5 1   0     0   1   50 50 *                     100.0 91 2 5 1   0     0   1   50 50                 100
1675101 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_6 3 5 90 0   1     0   1   61 39 *                     100.0 3 5 90 0   1     0   1   61 39                 100
1675264 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_7 0 0 100 0   0     0   0   49 50 *                     100.0 0 0 100 0   0     0   0   49 50                 100
1675755 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Lynn - Wm P Connery   Regular School No Elementary PK 05 2021   grade_3 8 6 73 0   12     0   1   45 55 *                     100.0 8 6 73 0   12     0   1   45 55                 100
1675780 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   grade_3 8 6 71 1   11     0   3   55 45 *                     100.0 8 6 71 1   11     0   3   55 45                 100
1675883 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_7 28 19 18 0   33     0   2   45 55 *                     100.0 28 19 18 0   33     0   2   45 55                 100
1675909 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_6 37 18 23 0   18     0   4   52 48 *                     100.0 37 18 23 0   18     0   4   52 48                 100
1676065 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard - Green Meadow   Regular School No Elementary PK 03 2021   grade_1 79 1 12 0   4     0   4   55 45 *                     100.0 79 1 12 0   4     0   4   55 45                 100

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