enrollments

Data source: Big Local News · About: Big Local

973 rows where grade = "grade_2", state = "MA" and year = 2016 sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 973 ✖

grade ✖

  • grade_2 · 973 ✖
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
935366 935366 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 4                       5                         1 4                 5
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
938152 938152 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   2 2                       4                         2 2                 4
938260 938260 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2016   grade_2 * * * *   *     *   *   3 1                       4                         3 1                 4
941364 941364 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 1                       2                         1 1                 2
941525 941525 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   1 4                       5                         1 4                 5
941540 941540 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_2 * * * *   *     *   *   2 2                       4                         2 2                 4
932554 932554 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_2 108 0 0 0   0     0   0   62 46                       108 108 0 0 0   0     0   0   62 46                 108
932595 932595 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2016   grade_2 68 1 6 0   0     0   3   43 35                       78 68 1 6 0   0     0   3   43 35                 78
932709 932709 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_2 36 2 6 0   0     0   0   29 15                       44 36 2 6 0   0     0   0   29 15                 44
932936 932936 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2016   grade_2 103 0 0 0   0     0   4   53 54                       107 103 0 0 0   0     0   4   53 54                 107
933092 933092 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2016   grade_2 0 20 27 0   0     0   2   32 17                       49 0 20 27 0   0     0   2   32 17                 49
933136 933136 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 05 2016   grade_2 7 0 5 0   0     0   0   5 7                       12 7 0 5 0   0     0   0   5 7                 12
933143 933143 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2016   grade_2 2 24 39 0   0     0   0   28 37                       65 2 24 39 0   0     0   0   28 37                 65
933165 933165 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_2 5 6 75 0   0     0   0   47 39                       86 5 6 75 0   0     0   0   47 39                 86
933199 933199 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   grade_2 10 16 15 0   0     0   1   19 23                       42 10 16 15 0   0     0   1   19 23                 42
933223 933223 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2016   grade_2 3 36 19 0   0     1   3   28 34                       62 3 36 19 0   0     1   3   28 34                 62
933253 933253 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2016   grade_2 0 38 10 0   0     0   1   26 23                       49 0 38 10 0   0     0   1   26 23                 49
933267 933267 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No 1 PK 05 2016   grade_2 1 13 46 0   0     0   3   32 31                       63 1 13 46 0   0     0   3   32 31                 63
933281 933281 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2016   grade_2 11 6 3 0   0     0   1   12 9                       21 11 6 3 0   0     0   1   12 9                 21
933305 933305 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2016   grade_2 11 2 30 0   0     0   3   26 20                       46 11 2 30 0   0     0   3   26 20                 46
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
933386 933386 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   grade_2 10 6 6 0   0     0   2   9 15                       24 10 6 6 0   0     0   2   9 15                 24
933410 933410 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_2 12 4 4 0   0     0   0   14 6                       20 12 4 4 0   0     0   0   14 6                 20
933479 933479 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2016   grade_2 4 4 12 0   0     0   0   5 15                       20 4 4 12 0   0     0   0   5 15                 20
933486 933486 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No 1 PK 05 2016   grade_2 4 4 32 0   0     0   2   22 20                       42 4 4 32 0   0     0   2   22 20                 42
933500 933500 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_2 0 14 38 0   0     0   0   27 25                       52 0 14 38 0   0     0   0   27 25                 52
933537 933537 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2016   grade_2 1 25 15 0   0     0   3   24 20                       44 1 25 15 0   0     0   3   24 20                 44
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
933562 933562 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_2 4 57 25 0   0     0   3   44 45                       89 4 57 25 0   0     0   3   44 45                 89
933588 933588 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_2 0 41 24 0   0     0   2   38 29                       67 0 41 24 0   0     0   2   38 29                 67
933597 933597 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_2 1 36 19 0   0     1   2   24 35                       59 1 36 19 0   0     1   2   24 35                 59
933615 933615 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_2 2 65 45 0   0     0   3   53 62                       115 2 65 45 0   0     0   3   53 62                 115
933625 933625 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_2 10 3 9 0   0     0   2   20 4                       24 10 3 9 0   0     0   2   20 4                 24
933638 933638 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_2 3 36 64 0   0     1   0   54 50                       104 3 36 64 0   0     1   0   54 50                 104
933778 933778 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_2 5 1 61 0   0     0   2   40 29                       69 5 1 61 0   0     0   2   40 29                 69
933804 933804 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_2 4 1 43 0   0     0   2   23 27                       50 4 1 43 0   0     0   2   23 27                 50
933976 933976 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_2 12 59 9 0   0     0   7   42 45                       87 12 59 9 0   0     0   7   42 45                 87
934040 934040 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_2 32 0 2 0   0     0   2   15 21                       36 32 0 2 0   0     0   2   15 21                 36
934245 934245 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2016   grade_2 9 17 7 0   0     0   2   19 16                       35 9 17 7 0   0     0   2   19 16                 35
934305 934305 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2016   grade_2 112 2 2 0   0     0   2   54 64                       118 112 2 2 0   0     0   2   54 64                 118
934394 934394 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2016   grade_2 56 8 26 0   0     0   1   51 40                       91 56 8 26 0   0     0   1   51 40                 91
934398 934398 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2016   grade_2 29 1 43 0   0     0   3   40 36                       76 29 1 43 0   0     0   3   40 36                 76
934416 934416 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2016   grade_2 15 1 8 0   0     0   0   16 8                       24 15 1 8 0   0     0   0   16 8                 24
934422 934422 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2016   grade_2 34 3 11 0   0     0   1   28 21                       49 34 3 11 0   0     0   1   28 21                 49
934440 934440 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2016   grade_2 11 2 58 0   0     0   1   45 27                       72 11 2 58 0   0     0   1   45 27                 72
934462 934462 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_2 28 0 0 0   0     0   1   14 15                       29 28 0 0 0   0     0   1   14 15                 29
934524 934524 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_2 17 0 1 0   0     0   0   12 6                       18 17 0 1 0   0     0   0   12 6                 18
934537 934537 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No 1 KG 05 2016   grade_2 47 1 6 0   0     0   4   33 25                       58 47 1 6 0   0     0   4   33 25                 58
934571 934571 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2016   grade_2 65 1 5 0   0     0   1   37 35                       72 65 1 5 0   0     0   1   37 35                 72
934577 934577 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2016   grade_2 60 0 1 0   0     0   4   30 35                       65 60 0 1 0   0     0   4   30 35                 65
934786 934786 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_2 28 1 9 1   0     0   4   18 25                       43 28 1 9 1   0     0   4   18 25                 43
934796 934796 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_2 13 0 0 0   0     0   3   11 5                       16 13 0 0 0   0     0   3   11 5                 16
934945 934945 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2016   grade_2 50 1 8 0   0     0   1   29 31                       60 50 1 8 0   0     0   1   29 31                 60
934984 934984 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   grade_2 54 1 1 2   0     0   5   38 25                       63 54 1 1 2   0     0   5   38 25                 63
935000 935000 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   grade_2 57 1 7 0   0     0   3   32 36                       68 57 1 7 0   0     0   3   32 36                 68
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
935187 935187 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2016   grade_2 34 2 1 0   0     0   0   19 18                       37 34 2 1 0   0     0   0   19 18                 37
935246 935246 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2016   grade_2 34 1 3 0   0     0   3   22 19                       41 34 1 3 0   0     0   3   22 19                 41
935253 935253 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_2 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
935259 935259 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   grade_2 34 0 5 0   0     1   1   21 20                       41 34 0 5 0   0     1   1   21 20                 41
935318 935318 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 04 2016   grade_2 40 0 8 0   0     0   4   24 28                       52 40 0 8 0   0     0   4   24 28                 52
935323 935323 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 04 2016   grade_2 51 1 3 0   0     0   0   22 33                       55 51 1 3 0   0     0   0   22 33                 55
935329 935329 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 04 2016   grade_2 27 0 9 0   0     0   9   23 22                       45 27 0 9 0   0     0   9   23 22                 45
935358 935358 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2016   grade_2 77 1 1 1   0     1   1   42 40                       82 77 1 1 1   0     1   1   42 40                 82
935378 935378 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2016   grade_2 103 0 2 0   0     0   0   52 53                       105 103 0 2 0   0     0   0   52 53                 105
935407 935407 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_2 33 0 3 0   0     0   0   17 19                       36 33 0 3 0   0     0   0   17 19                 36
935421 935421 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2016   grade_2 44 3 14 0   0     0   0   30 31                       61 44 3 14 0   0     0   0   30 31                 61
935464 935464 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2016   grade_2 32 0 11 0   0     0   2   12 33                       45 32 0 11 0   0     0   2   12 33                 45
935567 935567 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_2 0 4 43 0   0     0   1   29 19                       48 0 4 43 0   0     0   1   29 19                 48
935591 935591 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_2 6 3 42 0   0     0   0   27 24                       51 6 3 42 0   0     0   0   27 24                 51
935600 935600 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2016   grade_2 11 2 57 0   0     0   1   45 26                       71 11 2 57 0   0     0   1   45 26                 71
935619 935619 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2016   grade_2 7 2 55 0   0     0   3   39 28                       67 7 2 55 0   0     0   3   39 28                 67
935633 935633 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_2 79 0 4 0   0     1   1   49 36                       85 79 0 4 0   0     1   1   49 36                 85
935688 935688 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2016   grade_2 70 1 0 0   0     0   0   46 25                       71 70 1 0 0   0     0   0   46 25                 71
935702 935702 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2016   grade_2 60 1 1 0   0     0   4   38 28                       66 60 1 1 0   0     0   4   38 28                 66
935748 935748 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   grade_2 3 0 124 0   0     0   0   64 63                       127 3 0 124 0   0     0   0   64 63                 127
935786 935786 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_2 3 1 91 0   0     0   0   46 49                       95 3 1 91 0   0     0   0   46 49                 95
935800 935800 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2016   grade_2 9 1 116 1   0     0   2   70 59                       129 9 1 116 1   0     0   2   70 59                 129
935804 935804 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_2 3 0 70 0   0     0   0   34 39                       73 3 0 70 0   0     0   0   34 39                 73
935859 935859 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_2 0 0 7 0   0     0   0   6 1                       7 0 0 7 0   0     0   0   6 1                 7
935961 935961 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_2 13 0 2 0   0     0   0   9 6                       15 13 0 2 0   0     0   0   9 6                 15
936215 936215 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No 1 02 03 2016   grade_2 158 2 25 0   0     0   6   94 97                       191 158 2 25 0   0     0   6   94 97                 191
936322 936322 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2016   grade_2 16 0 2 1   0     0   1   10 10                       20 16 0 2 1   0     0   1   10 10                 20
936528 936528 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2016   grade_2 34 0 0 0   0     0   1   25 10                       35 34 0 0 0   0     0   1   25 10                 35
936534 936534 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2016   grade_2 50 0 3 0   0     0   2   31 24                       55 50 0 3 0   0     0   2   31 24                 55
936761 936761 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2016   grade_2 102 1 4 0   0     0   14   56 65                       121 102 1 4 0   0     0   14   56 65                 121
936985 936985 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No 1 KG 05 2016   grade_2 37 2 11 0   0     0   0   26 24                       50 37 2 11 0   0     0   0   26 24                 50
936992 936992 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No 1 PK 05 2016   grade_2 25 9 11 0   0     1   2   31 17                       48 25 9 11 0   0     1   2   31 17                 48
937018 937018 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No 1 KG 05 2016   grade_2 25 9 32 0   0     0   0   32 34                       66 25 9 32 0   0     0   0   32 34                 66
937025 937025 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2016   grade_2 19 4 49 0   0     0   2   42 32                       74 19 4 49 0   0     0   2   42 32                 74
937030 937030 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2016   grade_2 15 5 25 0   0     0   8   22 31                       53 15 5 25 0   0     0   8   22 31                 53
937043 937043 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2016   grade_2 41 14 53 1   0     0   6   64 51                       115 41 14 53 1   0     0   6   64 51                 115
937063 937063 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2016   grade_2 13 3 24 2   0     0   3   24 21                       45 13 3 24 2   0     0   3   24 21                 45
937077 937077 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No 1 PK 04 2016   grade_2 7 12 15 0   0     0   1   16 19                       35 7 12 15 0   0     0   1   16 19                 35
937094 937094 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No 1 KG 05 2016   grade_2 20 2 7 0   0     0   4   20 13                       33 20 2 7 0   0     0   4   20 13                 33
937261 937261 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2016   grade_2 127 1 3 0   0     0   4   73 62                       135 127 1 3 0   0     0   4   73 62                 135
937264 937264 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No 1 KG 07 2016   grade_2 34 4 1 0   0     0   2   18 23                       41 34 4 1 0   0     0   2   18 23                 41
937272 937272 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2016   grade_2 32 0 2 0   0     1   3   22 16                       38 32 0 2 0   0     1   3   22 16                 38
937281 937281 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2016   grade_2 28 1 1 0   0     0   4   17 17                       34 28 1 1 0   0     0   4   17 17                 34

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