enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 9,499 ✖
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
935277 935277 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_5 * * * *   *     *   *   * *                       1                                             1
935278 935278 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_6 * * * *   *     *   *   * *                       1                                             1
936162 936162 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_2 * * * *   *     *   *   1 *                       1                         1                   1
936164 936164 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_4 * * * *   *     *   *   1 *                       1                         1                   1
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
937587 937587 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_8 * * * *   *     *   *   1 *                       1                         1                   1
939287 939287 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_8 * * * *   *     *   *   * *                       1                                             1
939288 939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
939290 939290 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_11 * * * *   *     *   *   * *                       1                                             1
933368 933368 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   pre_kindergarten 1 3 5 0   0     1   0   5 5                       10 1 3 5 0   0     1   0   5 5                 10
933541 933541 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_2 1 5 4 0   0     0   0   6 4                       10 1 5 4 0   0     0   0   6 4                 10
933677 933677 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2016   grade_11 0 8 2 0   0     0   0   7 3                       10 0 8 2 0   0     0   0   7 3                 10
933812 933812 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   pre_kindergarten 3 5 2 0   0     0   0   8 2                       10 3 5 2 0   0     0   0   8 2                 10
933813 933813 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_1 1 6 3 0   0     0   0   8 2                       10 1 6 3 0   0     0   0   8 2                 10
934032 934032 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2016   grade_12 3 3 3 0   0     0   1   7 3                       10 3 3 3 0   0     0   1   7 3                 10
934714 934714 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   pre_kindergarten 8 1 1 0   0     0   0   8 2                       10 8 1 1 0   0     0   0   8 2                 10
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
934980 934980 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River Gateway to College @ BCC   Regular School No 3 09 12 2016   grade_12 5 0 3 0   0     0   2   3 7                       10 5 0 3 0   0     0   2   3 7                 10
935038 935038 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   pre_kindergarten 3 1 5 0   1     0   0   6 4                       10 3 1 5 0   1     0   0   6 4                 10
935060 935060 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_2 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
935391 935391 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2016   pre_kindergarten 4 3 0 0   3     0   0   7 3                       10 4 3 0 0   3     0   0   7 3                 10
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
936329 936329 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_4 3 1 5 0   0     0   1   9 1                       10 3 1 5 0   0     0   1   9 1                 10
936331 936331 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_6 5 2 3 0   0     0   0   9 1                       10 5 2 3 0   0     0   0   9 1                 10
936637 936637 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No 1 PK 05 2016   pre_kindergarten 8 0 1 0   1     0   0   4 6                       10 8 0 1 0   1     0   0   4 6                 10
936806 936806 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   sped_beyond_grade_12 8 1 1 0   0     0   0   7 3                       10 8 1 1 0   0     0   0   7 3                 10
937591 937591 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_12 9 0 1 0   0     0   0   9 *                       10 9 0 1 0   0     0   0   9                   10
937674 937674 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2016   sped_beyond_grade_12 8 0 2 0   0     0   0   7 3                       10 8 0 2 0   0     0   0   7 3                 10
938259 938259 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2016   grade_1 9 0 1 0   0     0   0   1 9                       10 9 0 1 0   0     0   0   1 9                 10
938489 938489 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2016   grade_12 3 5 2 0   0     0   0   8 2                       10 3 5 2 0   0     0   0   8 2                 10
938836 938836 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No 3 09 12 2016   grade_12 2 3 5 0   0     0   0   3 7                       10 2 3 5 0   0     0   0   3 7                 10
938838 938838 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_10 0 4 6 0   0     0   0   3 7                       10 0 4 6 0   0     0   0   3 7                 10
939294 939294 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Junior/Senior High School   Regular School No 3 07 12 2016   grade_11 7 1 1 0   0     0   1   7 3                       10 7 1 1 0   0     0   1   7 3                 10
939732 939732 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
940203 940203 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No 1 PK 06 2016   pre_kindergarten 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
940246 940246 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   sped_beyond_grade_12 1 8 1 0   0     0   0   8 2                       10 1 8 1 0   0     0   0   8 2                 10
940556 940556 MA Essex   school 2500532 467   New Liberty Charter School of Salem (District) 250053202712 4670505 New Liberty Charter School of Salem   Regular School Yes 3 09 12 2016   grade_10 4 1 5 0   0     0   0   5 5                       10 4 1 5 0   0     0   0   5 5                 10
941134 941134 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Littleville Elementary School   Regular School No 1 PK 04 2016   pre_kindergarten 8 0 0 0   0     0   2   7 3                       10 8 0 0 0   0     0   2   7 3                 10
941253 941253 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2016   grade_5 9 0 0 1   0     0   0   3 7                       10 9 0 0 1   0     0   0   3 7                 10
941363 941363 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2016   grade_1 10 0 0 0   0     0   0   8 2                       10 10 0 0 0   0     0   0   8 2                 10
941477 941477 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No 4 UG UG 2016   sped_beyond_grade_12 10 0 0 0   0     0   0   * *                       10 10 0 0 0   0     0   0                       10
941523 941523 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 9 0 1 0   0     0   0   4 6                       10 9 0 1 0   0     0   0   4 6                 10
941543 941543 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_5 10 0 0 0   0     0   0   2 8                       10 10 0 0 0   0     0   0   2 8                 10
941721 941721 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   grade_4 9 0 0 0   1     0   0   7 3                       10 9 0 0 0   1     0   0   7 3                 10
941795 941795 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2016   sped_beyond_grade_12 10 0 0 0   0     0   0   7 3                       10 10 0 0 0   0     0   0   7 3                 10
932757 932757 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2016   kindergarten 72 5 15 0   5     0   3   61 39                       100 72 5 15 0   5     0   3   61 39                 100
932761 932761 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2016   grade_4 61 5 17 0   8     0   9   51 49                       100 61 5 17 0   8     0   9   51 49                 100
932940 932940 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_6 94 1 1 0   2     0   2   50 50                       100 94 1 1 0   2     0   2   50 50                 100
932942 932942 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_8 93 2 4 0   0     0   1   49 51                       100 93 2 4 0   0     0   1   49 51                 100
933356 933356 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2016   grade_2 2 83 12 0   0     0   3   42 58                       100 2 83 12 0   0     0   3   42 58                 100
933759 933759 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2016   grade_10 11 45 40 0   0     0   4   58 42                       100 11 45 40 0   0     0   4   58 42                 100
933946 933946 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2016   grade_1 24 57 11 0   1     1   6   55 45                       100 24 57 11 0   1     1   6   55 45                 100
934315 934315 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_12 96 3 0 0   0     0   1   48 52                       100 96 3 0 0   0     0   1   48 52                 100
934736 934736 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2016   grade_5 81 3 13 0   3     0   0   56 44                       100 81 3 13 0   3     0   0   56 44                 100
934753 934753 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No 1 03 05 2016   grade_4 90 1 4 0   2     0   3   54 46                       100 90 1 4 0   2     0   3   54 46                 100
934817 934817 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2016   kindergarten 30 16 50 0   3     0   1   48 52                       100 30 16 50 0   3     0   1   48 52                 100
934832 934832 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_6 29 20 40 1   9     0   1   56 44                       100 29 20 40 1   9     0   1   56 44                 100
934842 934842 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_1 32 18 43 1   4     0   2   48 52                       100 32 18 43 1   4     0   2   48 52                 100
935166 935166 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2016   grade_5 94 0 1 0   4     0   1   60 40                       100 94 0 1 0   4     0   1   60 40                 100
935792 935792 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_3 2 0 97 0   0     0   1   57 43                       100 2 0 97 0   0     0   1   57 43                 100
936081 936081 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2016   grade_4 36 1 17 0   42     0   4   55 45                       100 36 1 17 0   42     0   4   55 45                 100
936082 936082 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers Early Learning Center   Regular School No 1 PK 03 2016   kindergarten 26 6 42 0   24     0   2   52 48                       100 26 6 42 0   24     0   2   52 48                 100
936294 936294 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No 1 PK 05 2016   grade_3 10 10 71 0   5     0   4   55 45                       100 10 10 71 0   5     0   4   55 45                 100
936419 936419 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_5 24 23 31 0   15     0   7   49 51                       100 24 23 31 0   15     0   7   49 51                 100
936437 936437 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2016   grade_5 43 13 16 1   24     0   3   47 53                       100 43 13 16 1   24     0   3   47 53                 100
936567 936567 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_1 72 1 8 9   1     0   9   47 53                       100 72 1 8 9   1     0   9   47 53                 100
936839 936839 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No 1 PK 05 2016   grade_2 80 5 4 0   6     1   4   50 50                       100 80 5 4 0   6     1   4   50 50                 100
936878 936878 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2016   grade_6 93 1 1 0   0     2   3   51 49                       100 93 1 1 0   0     2   3   51 49                 100
937024 937024 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2016   grade_1 19 14 65 0   0     0   2   54 46                       100 19 14 65 0   0     0   2   54 46                 100
937052 937052 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_5 55 9 22 1   1     0   12   50 50                       100 55 9 22 1   1     0   12   50 50                 100
937071 937071 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2016   grade_3 70 4 19 0   0     0   7   60 40                       100 70 4 19 0   0     0   7   60 40                 100
937434 937434 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 83 0 12 0   1     0   4   59 41                       100 83 0 12 0   1     0   4   59 41                 100
937614 937614 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2016   grade_12 90 1 4 0   3     1   1   48 52                       100 90 1 4 0   3     1   1   48 52                 100
937785 937785 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_5 88 1 4 0   3     0   4   56 44                       100 88 1 4 0   3     0   4   56 44                 100
937792 937792 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Mount Pleasant   Regular School No 1 PK PK 2016   pre_kindergarten 90 0 3 0   0     0   7   53 47                       100 90 0 3 0   0     0   7   53 47                 100
937953 937953 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2016   grade_5 37 13 8 0   39     0   3   57 43                       100 37 13 8 0   39     0   3   57 43                 100
938040 938040 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2016   grade_1 40 5 43 0   7     1   4   46 54                       100 40 5 43 0   7     1   4   46 54                 100
938058 938058 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2016   grade_2 43 6 47 0   3     0   1   44 56                       100 43 6 47 0   3     0   1   44 56                 100
938554 938554 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2016   grade_4 7 10 81 0   1     0   1   50 50                       100 7 10 81 0   1     0   1   50 50                 100
938637 938637 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No 1 PK 05 2016   grade_1 16 12 68 0   1     0   3   48 52                       100 16 12 68 0   1     0   3   48 52                 100
938966 938966 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2016   grade_11 93 0 2 0   1     0   4   58 42                       100 93 0 2 0   1     0   4   58 42                 100
939019 939019 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No 1 KG 04 2016   grade_1 79 8 7 1   2     0   3   48 52                       100 79 8 7 1   2     0   3   48 52                 100
939098 939098 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No 2 04 06 2016   grade_6 94 1 5 0   0     0   0   47 53                       100 94 1 5 0   0     0   0   47 53                 100
939614 939614 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No 1 KG 05 2016   grade_2 78 2 12 0   4     0   4   48 52                       100 78 2 12 0   4     0   4   48 52                 100
940094 940094 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2016   grade_1 38 21 27 0   8     0   6   51 49                       100 38 21 27 0   8     0   6   51 49                 100
940210 940210 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No 1 PK 03 2016   kindergarten 89 1 3 0   2     1   4   45 55                       100 89 1 3 0   2     1   4   45 55                 100
940324 940324 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_11 8 29 60 0   2     0   1   48 52                       100 8 29 60 0   2     0   1   48 52                 100
940343 940343 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_6 83 4 1 0   10     0   2   48 52                       100 83 4 1 0   10     0   2   48 52                 100
940344 940344 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_7 80 3 6 0   8     0   3   51 49                       100 80 3 6 0   8     0   3   51 49                 100
940345 940345 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_8 82 3 4 1   6     0   4   47 53                       100 82 3 4 1   6     0   4   47 53                 100
940393 940393 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   kindergarten 19 28 45 0   3     0   5   55 45                       100 19 28 45 0   3     0   5   55 45                 100
940460 940460 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_5 50 24 23 0   1     0   2   59 41                       100 50 24 23 0   1     0   2   59 41                 100
940461 940461 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_6 46 29 22 0   1     0   2   43 57                       100 46 29 22 0   1     0   2   43 57                 100
940699 940699 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_3 78 3 11 0   2     0   6   45 55                       100 78 3 11 0   2     0   6   45 55                 100
940701 940701 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_5 81 5 7 0   4     0   3   53 47                       100 81 5 7 0   4     0   3   53 47                 100
940702 940702 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_6 85 4 7 0   2     0   2   49 51                       100 85 4 7 0   2     0   2   49 51                 100
940703 940703 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_7 87 3 5 0   4     0   1   51 49                       100 87 3 5 0   4     0   1   51 49                 100
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
940908 940908 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_6 86 1 9 1   1     0   2   35 65                       100 86 1 9 1   1     0   2   35 65                 100
940909 940909 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_7 83 2 7 0   3     2   3   50 50                       100 83 2 7 0   3     2   3   50 50                 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]);