enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by female_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2041274 2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2041275 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
2041276 2041276 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_9 * * * *   *     *   *   4 *                       4.0                         4                   4
2041277 2041277 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_10 * * * *   *     *   *   3 *                       4.0                         3                   4
2041278 2041278 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_11 * * * *   *     *   *   2 *                       3.0                         2                   3
2042765 2042765 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2042766 2042766 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_2 * * * *   *     *   *   2 *                       2.0                         2                   2
2042767 2042767 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   2 *                       2.0                         2                   2
2042768 2042768 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_4 1 0 4 1   0     0   0   5 *                       6.0 1 0 4 1   0     0   0   5                   6
2042769 2042769 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2042770 2042770 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_6 4 0 3 0   0     0   1   7 *                       8.0 4 0 3 0   0     0   1   7                   8
2042771 2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2042772 2042772 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_8 * * * *   *     *   *   2 *                       2.0                         2                   2
2042773 2042773 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_9 * * * *   *     *   *   2 *                       2.0                         2                   2
2042774 2042774 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_10 * * * *   *     *   *   4 *                       5.0                         4                   5
2042775 2042775 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_11 * * * *   *     *   *   1 *                       1.0                         1                   1
2042776 2042776 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_12 * * * *   *     *   *   1 *                       2.0                         1                   2
2043450 2043450 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 *                       1.0                         1                   1
2043451 2043451 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_3 * * * *   *     *   *   1 *                       1.0                         1                   1
2043452 2043452 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_5 * * * *   *     *   *   3 *                       3.0                         3                   3
2043453 2043453 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_6 3 0 3 0   0     0   0   6 *                       6.0 3 0 3 0   0     0   0   6                   6
2043454 2043454 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_7 * * * *   *     *   *   3 *                       4.0                         3                   4
2043455 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
2044888 2044888 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_9 * * * *   *     *   *   2 *                       2.0                         2                   2
2044889 2044889 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_10 * * * *   *     *   *   4 *                       4.0                         4                   4
2044890 2044890 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_11 * * * *   *     *   *   5 *                       5.0                         5                   5
2044891 2044891 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_12 6 0 2 0   0     0   0   7 *                       8.0 6 0 2 0   0     0   0   7                   8
2045781 2045781 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_7 0 2 4 0   0     0   0   6 *                       6.0 0 2 4 0   0     0   0   6                   6
2045782 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
2046137 2046137 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   2 *                       3.0                         2                   3
2046138 2046138 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2019   grade_10 * * * *   *     *   *   2 *                       2.0                         2                   2
2046139 2046139 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2019   grade_11 * * * *   *     *   *   3 *                       3.0                         3                   3
2040389 2040389 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_10 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040390 2040390 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_11 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040420 2040420 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2040819 2040819 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_2 3 1 3 0   0     0   1   7 1                       8.0 3 1 3 0   0     0   1   7 1                 8
2040820 2040820 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_3 0 3 6 1   0     0   0   9 1                       10.0 0 3 6 1   0     0   0   9 1                 10
2040875 2040875 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_2 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2041095 2041095 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2041097 2041097 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_2 3 1 2 0   0     0   0   5 1                       6.0 3 1 2 0   0     0   0   5 1                 6
2041286 2041286 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_5 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041287 2041287 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041289 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
2041291 2041291 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_10 2 1 4 0   0     0   1   7 1                       8.0 2 1 4 0   0     0   1   7 1                 8
2041679 2041679 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_12 0 0 6 0   0     0   0   5 1                       6.0 0 0 6 0   0     0   0   5 1                 6
2042135 2042135 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_5 2 1 3 0   0     0   0   5 1                       6.0 2 1 3 0   0     0   0   5 1                 6
2042136 2042136 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_6 2 5 3 0   0     0   1   10 1                       11.0 2 5 3 0   0     0   1   10 1                 11
2042139 2042139 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_9 2 0 4 0   0     0   1   6 1                       7.0 2 0 4 0   0     0   1   6 1                 7
2042268 2042268 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042269 2042269 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042270 2042270 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_7 3 1 0 0   0     0   5   8 1                       9.0 3 1 0 0   0     0   5   8 1                 9
2042370 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
2042671 2042671 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   kindergarten * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042672 2042672 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_3 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2042746 2042746 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2019   grade_9 4 0 4 0   0     0   0   7 1                       8.0 4 0 4 0   0     0   0   7 1                 8
2042748 2042748 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2019   grade_12 0 2 4 0   0     0   0   5 1                       6.0 0 2 4 0   0     0   0   5 1                 6
2043139 2043139 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2019   grade_9 0 0 7 0   0     0   0   6 1                       7.0 0 0 7 0   0     0   0   6 1                 7
2043143 2043143 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2043145 2043145 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_5 0 0 8 0   0     0   0   7 1                       8.0 0 0 8 0   0     0   0   7 1                 8
2043150 2043150 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_11 2 0 5 0   0     0   0   6 1                       7.0 2 0 5 0   0     0   0   6 1                 7
2043503 2043503 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   pre_kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2043505 2043505 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_1 1 2 3 0   0     0   0   5 1                       6.0 1 2 3 0   0     0   0   5 1                 6
2043506 2043506 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_2 4 0 2 0   2     0   0   7 1                       8.0 4 0 2 0   2     0   0   7 1                 8
2043507 2043507 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2043509 2043509 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2043623 2043623 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_2 0 1 5 0   0     0   0   5 1                       6.0 0 1 5 0   0     0   0   5 1                 6
2043624 2043624 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_3 2 1 7 0   1     0   1   11 1                       12.0 2 1 7 0   1     0   1   11 1                 12
2043625 2043625 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_4 2 0 8 0   0     0   0   9 1                       10.0 2 0 8 0   0     0   0   9 1                 10
2043633 2043633 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No Elementary PK 05 2019   pre_kindergarten * * * *   *     *   *   4 1                       5.0                         4 1                 5
2043668 2043668 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_7 2 0 4 0   1     0   1   7 1                       8.0 2 0 4 0   1     0   1   7 1                 8
2043675 2043675 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2043676 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
2043952 2043952 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2043953 2043953 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_11 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2044414 2044414 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_4 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2044422 2044422 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_7 3 2 4 0   0     0   0   8 1                       9.0 3 2 4 0   0     0   0   8 1                 9
2045173 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 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
2045509 2045509 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_9 3 0 3 0   0     0   0   5 1                       6.0 3 0 3 0   0     0   0   5 1                 6
2045831 2045831 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 08 12 2019   grade_11 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2045851 2045851 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2019   grade_5 2 4 10 0   0     0   0   15 1                       16.0 2 4 10 0   0     0   0   15 1                 16
2046136 2046136 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2019   grade_12 1 5 6 0   0     0   0   11 1                       12.0 1 5 6 0   0     0   0   11 1                 12
2046144 2046144 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   * 1                       1.0                           1                 1
2046157 2046157 MA Hampden   school 2511130 281   Springfield 251113002884 2810700 Springfield International Academy at Sci-Tech   Regular School No Secondary 09 10 2019   grade_9 1 0 16 0   2     0   0   18 1                       19.0 1 0 16 0   2     0   0   18 1                 19
2046380 2046380 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 10 12 2019   grade_10 5 1 0 0   0     0   0   5 1                       6.0 5 1 0 0   0     0   0   5 1                 6
2046403 2046403 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2046868 2046868 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten 8 0 0 0   0     0   0   7 1                       8.0 8 0 0 0   0     0   0   7 1                 8
2047594 2047594 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_11 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2048250 2048250 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_7 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2048251 2048251 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_9 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2048393 2048393 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_5 11 0 0 0   0     0   0   10 1                       11.0 11 0 0 0   0     0   0   10 1                 11
2048406 2048406 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No Middle 04 06 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2048842 2048842 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   pre_kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2048848 2048848 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   grade_5 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2040064 2040064 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 10 12 2019   grade_10 4 1 2 0   0     0   0   5 2                       7.0 4 1 2 0   0     0   0   5 2                 7
2040176 2040176 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_9 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2040387 2040387 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_7 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2040388 2040388 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_9 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2040960 2040960 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_12 1 4 2 0   0     0   0   5 2                       7.0 1 4 2 0   0     0   0   5 2                 7
2041099 2041099 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_4 0 4 4 0   0     0   0   6 2                       8.0 0 4 4 0   0     0   0   6 2                 8

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