enrollments

Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by native_hawaiian_pacific_islander descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,880 ✖
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
937899 937899 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2016   grade_1 37 11 11 0   51     8   3   60 61                       121 37 11 11 0   51     8   3   60 61                 121
1676881 1676881 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_1 26 0 5 0   1     5   4   22 19 *                     41.0 26 0 5 0   1     5   4   22 19                 41
2229182 2229182 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   grade_1 68 2 4 0   0     5   2   43 38                       81.0 68 2 4 0   0     5   2   43 38                 81
933996 933996 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2016   grade_1 21 65 14 1   1     3   13   65 53                       118 21 65 14 1   1     3   13   65 53                 118
941197 941197 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2016   grade_1 37 0 0 0   0     3   1   18 23                       41 37 0 0 0   0     3   1   18 23                 41
1369749 1369749 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_1 28 6 20 0   7     3   0   34 30 *                     64.0 28 6 20 0   7     3   0   34 30                 64
1675459 1675459 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   grade_1 32 2 19 0   1     3   11   34 34 *                     68.0 32 2 19 0   1     3   11   34 34                 68
2044843 2044843 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary 01 05 2019   grade_1 21 5 7 0   18     3   1   24 31                       55.0 21 5 7 0   18     3   1   24 31                 55
2231883 2231883 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_1 50 0 4 1   2     3   2   31 31                       62.0 50 0 4 1   2     3   2   31 31                 62
737420 737420 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   grade_1 68 6 1 0   12     2   5   48 46                       94 68 6 1 0   12     2   5   48 46                 94
739202 739202 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2015   grade_1 72 0 5 0   14     2   4   43 54                       97 72 0 5 0   14     2   4   43 54                 97
741070 741070 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2015   grade_1 41 11 7 0   68     2   6   88 47                       135 41 11 7 0   68     2   6   88 47                 135
742115 742115 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2015   grade_1 66 1 2 1   13     2   1   50 36                       86 66 1 2 1   13     2   1   50 36                 86
933958 933958 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_1 18 73 14 0   2     2   6   55 60                       115 18 73 14 0   2     2   6   55 60                 115
934280 934280 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2016   grade_1 41 3 5 0   11     2   1   33 30                       63 41 3 5 0   11     2   1   33 30                 63
940812 940812 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2016   grade_1 69 4 2 0   1     2   3   48 33                       81 69 4 2 0   1     2   3   48 33                 81
1122125 1122125 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_1 49 1 1 0   16     2   4   33 40                       73 49 1 1 0   16     2   4   33 40                 73
1130712 1130712 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No Elementary KG 05 2017   grade_1 25 4 9 0   10     2   1   28 23                       51 25 4 9 0   10     2   1   28 23                 51
1365797 1365797 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_1 0 32 19 0   1     2   2   25 31 *                     56.0 0 32 19 0   1     2   2   25 31                 56
1367406 1367406 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_1 49 1 1 0   1     2   0   31 23 *                     54.0 49 1 1 0   1     2   0   31 23                 54
1367424 1367424 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_1 43 2 3 0   3     2   0   23 30 *                     53.0 43 2 3 0   3     2   0   23 30                 53
1369456 1369456 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   grade_1 36 7 6 1   20     2   4   36 40 *                     76.0 36 7 6 1   20     2   4   36 40                 76
1372548 1372548 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_1 8 14 98 0   1     2   1   53 71 *                     124.0 8 14 98 0   1     2   1   53 71                 124
1373459 1373459 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2020   grade_1 119 3 16 0   4     2   8   79 73 *                     152.0 119 3 16 0   4     2   8   79 73                 152
1673436 1673436 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_1 8 90 11 0   0     2   2   67 46 *                     113.0 8 90 11 0   0     2   2   67 46                 113
1680052 1680052 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_1 1 47 41 1   0     2   3   51 44 *                     95.0 1 47 41 1   0     2   3   51 44                 95
2040159 2040159 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_1 67 2 6 0   2     2   2   39 42                       81.0 67 2 6 0   2     2   2   39 42                 81
2040163 2040163 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_1 71 1 4 0   1     2   3   46 36                       82.0 71 1 4 0   1     2   3   46 36                 82
2044823 2044823 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_1 31 7 22 0   5     2   2   38 31                       69.0 31 7 22 0   5     2   2   38 31                 69
2045188 2045188 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   grade_1 31 12 10 1   44     2   5   46 59                       105.0 31 12 10 1   44     2   5   46 59                 105
2234304 2234304 MA Middlesex   school 2508610 207   Newton 250861001377 2070100 Newton: Peirce   Regular School No Elementary KG 05 2018   grade_1 19 2 6 0   7     2   8   25 19                       44.0 19 2 6 0   7     2   8   25 19                 44
2235139 2235139 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Quincy: Merrymount   Regular School No Elementary KG 05 2018   grade_1 32 2 2 1   14     2   0   32 21                       53.0 32 2 2 1   14     2   0   32 21                 53
735961 735961 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_1 43 13 20 0   6     1   9   57 35                       92 43 13 20 0   6     1   9   57 35                 92
735965 735965 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_1 69 18 7 0   3     1   6   46 58                       104 69 18 7 0   3     1   6   46 58                 104
736355 736355 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2015   grade_1 2 35 18 0   1     1   2   24 35                       59 2 35 18 0   1     1   2   24 35                 59
736369 736369 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 05 2015   grade_1 23 45 43 0   8     1   5   66 59                       125 23 45 43 0   8     1   5   66 59                 125
736462 736462 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_1 38 7 14 0   7     1   2   41 28                       69 38 7 14 0   7     1   2   41 28                 69
736479 736479 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No 1 PK 05 2015   grade_1 18 1 26 1   1     1   3   28 23                       51 18 1 26 1   1     1   3   28 23                 51
736576 736576 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   grade_1 7 2 61 0   1     1   1   41 32                       73 7 2 61 0   1     1   1   41 32                 73
736729 736729 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_1 3 28 14 0   0     1   4   27 23                       50 3 28 14 0   0     1   4   27 23                 50
736768 736768 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_1 2 32 63 0   0     1   1   46 53                       99 2 32 63 0   0     1   1   46 53                 99
737100 737100 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2015   grade_1 52 54 10 0   7     1   10   77 57                       134 52 54 10 0   7     1   10   77 57                 134
737226 737226 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2015   grade_1 41 6 5 0   29     1   4   51 35                       86 41 6 5 0   29     1   4   51 35                 86
737527 737527 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_1 44 0 16 0   5     1   2   33 35                       68 44 0 16 0   5     1   2   33 35                 68
738165 738165 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_1 52 8 48 0   4     1   11   62 62                       124 52 8 48 0   4     1   11   62 62                 124
738215 738215 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2015   grade_1 53 0 1 0   3     1   0   26 32                       58 53 0 1 0   3     1   0   26 32                 58
738276 738276 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_1 64 12 23 0   2     1   6   60 48                       108 64 12 23 0   2     1   6   60 48                 108
738302 738302 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   grade_1 45 2 0 0   8     1   0   27 29                       56 45 2 0 0   8     1   0   27 29                 56
738308 738308 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_1 65 1 0 0   2     1   0   37 32                       69 65 1 0 0   2     1   0   37 32                 69
738354 738354 MA Worcester   school 2505130 103   Gardner 250513002470 1030015 Helen Mae Sauter Elementary   Regular School No 1 01 03 2015   grade_1 73 1 9 0   2     1   6   52 40                       92 73 1 9 0   2     1   6   52 40                 92
738375 738375 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   grade_1 113 0 2 0   0     1   2   64 54                       118 113 0 2 0   0     1   2   64 54                 118
738407 738407 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_1 33 0 4 0   0     1   1   17 22                       39 33 0 4 0   0     1   1   17 22                 39
738493 738493 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_1 37 0 3 0   1     1   1   20 23                       43 37 0 3 0   1     1   1   20 23                 43
738507 738507 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_1 76 1 1 1   0     1   0   41 39                       80 76 1 1 1   0     1   0   41 39                 80
738598 738598 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No 1 KG 04 2015   grade_1 44 7 30 0   5     1   1   49 39                       88 44 7 30 0   5     1   1   49 39                 88
738783 738783 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_1 82 0 4 0   0     1   0   52 35                       87 82 0 4 0   0     1   0   52 35                 87
738942 738942 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_1 2 4 85 0   1     1   0   40 53                       93 2 4 85 0   1     1   0   40 53                 93
739992 739992 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No 1 PK 05 2015   grade_1 79 5 4 0   6     1   4   49 50                       99 79 5 4 0   6     1   4   49 50                 99
740167 740167 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   grade_1 52 31 39 1   3     1   16   77 66                       143 52 31 39 1   3     1   16   77 66                 143
740217 740217 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2015   grade_1 10 9 39 0   0     1   3   34 28                       62 10 9 39 0   0     1   3   34 28                 62
740445 740445 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_1 46 1 3 0   0     1   5   31 25                       56 46 1 3 0   0     1   5   31 25                 56
740552 740552 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No 1 KG 05 2015   grade_1 46 1 2 0   1     1   0   24 27                       51 46 1 2 0   1     1   0   24 27                 51
740585 740585 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No 1 KG 05 2015   grade_1 19 0 2 0   6     1   2   19 11                       30 19 0 2 0   6     1   2   19 11                 30
740911 740911 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No 1 PK 05 2015   grade_1 43 10 9 1   2     1   9   33 42                       75 43 10 9 1   2     1   9   33 42                 75
741059 741059 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_1 44 14 12 0   35     1   7   67 46                       113 44 14 12 0   35     1   7   67 46                 113
741075 741075 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No 1 KG 05 2015   grade_1 33 2 1 0   17     1   0   27 27                       54 33 2 1 0   17     1   0   27 27                 54
741081 741081 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No 1 KG 05 2015   grade_1 20 3 3 0   40     1   3   39 31                       70 20 3 3 0   40     1   3   39 31                 70
741235 741235 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 William McKinley   Regular School No 1 KG 05 2015   grade_1 31 4 68 0   4     1   5   59 54                       113 31 4 68 0   4     1   5   59 54                 113
741425 741425 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No 1 KG 05 2015   grade_1 38 1 6 0   2     1   0   32 16                       48 38 1 6 0   2     1   0   32 16                 48
741784 741784 MA Hampden   school 2511130 281   Springfield 251113001799 2810035 Daniel B Brunton   Regular School No 1 KG 05 2015   grade_1 18 18 45 0   2     1   0   46 38                       84 18 18 45 0   2     1   0   46 38                 84
742068 742068 MA Norfolk   school 2511250 285   Stoughton 251125001862 2850014 Joseph R Dawe Jr Elementary   Regular School No 1 KG 05 2015   grade_1 37 13 3 0   7     1   3   32 32                       64 37 13 3 0   7     1   3   32 32                 64
742121 742121 MA Middlesex   school 2511340 288   Sudbury 251134000507 2880025 General John Nixon Elementary   Regular School No 1 KG 05 2015   grade_1 57 3 1 0   8     1   1   39 32                       71 57 3 1 0   8     1   1   39 32                 71
742439 742439 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Henry Whittemore Elementary School   Regular School No 1 KG 05 2015   grade_1 11 1 64 2   2     1   1   44 38                       82 11 1 64 2   2     1   1   44 38                 82
742528 742528 MA Middlesex   school 2512210 315   Wayland 251221002008 3150015 Happy Hollow School   Regular School No 1 KG 05 2015   grade_1 38 4 1 0   10     1   5   30 29                       59 38 4 1 0   10     1   5   30 29                 59
742534 742534 MA Middlesex   school 2512210 315   Wayland 251221000153 3150020 Loker School   Regular School No 1 KG 04 2015   grade_1 26 3 1 0   6     1   1   20 18                       38 26 3 1 0   6     1   1   20 18                 38
742656 742656 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No 1 01 03 2015   grade_1 80 3 1 0   1     1   6   44 48                       92 80 3 1 0   1     1   6   44 48                 92
743837 743837 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_1 10 52 16 0   6     1   3   41 47                       88 10 52 16 0   6     1   3   41 47                 88
743931 743931 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2015   grade_1 51 1 0 0   14     1   0   38 29                       67 51 1 0 0   14     1   0   38 29                 67
744309 744309 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Littleville Elementary School   Regular School No 1 PK 04 2015   grade_1 41 1 4 0   1     1   0   23 25                       48 41 1 4 0   1     1   0   23 25                 48
744351 744351 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No 1 PK 01 2015   grade_1 38 3 11 0   0     1   7   35 25                       60 38 3 11 0   0     1   7   35 25                 60
744749 744749 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_1 46 0 4 0   1     1   0   31 21                       52 46 0 4 0   1     1   0   31 21                 52
744875 744875 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2015   grade_1 54 0 1 0   3     1   1   36 24                       60 54 0 1 0   3     1   1   36 24                 60
932689 932689 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_1 65 1 9 0   8     1   9   46 47                       93 65 1 9 0   8     1   9   46 47                 93
932714 932714 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2016   grade_1 56 3 5 0   10     1   6   41 40                       81 56 3 5 0   10     1   6   41 40                 81
932853 932853 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2016   grade_1 138 12 11 0   29     1   7   100 98                       198 138 12 11 0   29     1   7   100 98                 198
933091 933091 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2016   grade_1 1 21 29 1   0     1   1   32 22                       54 1 21 29 1   0     1   1   32 22                 54
933155 933155 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   grade_1 14 16 10 0   0     1   1   22 20                       42 14 16 10 0   0     1   1   22 20                 42
933198 933198 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   grade_1 9 14 15 0   2     1   1   24 18                       42 9 14 15 0   2     1   1   24 18                 42
933215 933215 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No 1 PK 05 2016   grade_1 6 16 15 0   1     1   6   25 20                       45 6 16 15 0   1     1   6   25 20                 45
933222 933222 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2016   grade_1 3 36 11 0   2     1   1   25 29                       54 3 36 11 0   2     1   1   25 29                 54
933290 933290 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2016   grade_1 0 24 24 0   0     1   1   25 25                       50 0 24 24 0   0     1   1   25 25                 50
933324 933324 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2016   grade_1 13 5 3 0   0     1   1   15 8                       23 13 5 3 0   0     1   1   15 8                 23
933492 933492 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2016   grade_1 3 18 13 0   0     1   1   20 16                       36 3 18 13 0   0     1   1   20 16                 36
933499 933499 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_1 2 8 36 0   0     1   0   23 24                       47 2 8 36 0   0     1   0   23 24                 47
933536 933536 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2016   grade_1 3 22 13 1   0     1   4   21 23                       44 3 22 13 1   0     1   4   21 23                 44
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
933952 933952 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No 1 KG 05 2016   grade_1 34 57 8 0   6     1   12   63 55                       118 34 57 8 0   6     1   12   63 55                 118
933967 933967 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2016   grade_1 54 51 11 0   3     1   7   56 71                       127 54 51 11 0   3     1   7   56 71                 127
934319 934319 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No 1 KG 04 2016   grade_1 61 2 3 0   14     1   1   30 52                       82 61 2 3 0   14     1   1   30 52                 82
934647 934647 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No 1 PK 05 2016   grade_1 41 2 3 0   8     1   7   36 26                       62 41 2 3 0   8     1   7   36 26                 62

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