enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by ccd_school_low_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1368456 1368456 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1368457 1368457 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1368458 1368458 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1368459 1368459 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1368460 1368460 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1368461 1368461 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1368462 1368462 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1368463 1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1368464 1368464 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1368465 1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1368466 1368466 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1368467 1368467 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1368468 1368468 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1368469 1368469 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1368470 1368470 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   * * *                     6.0 6 0 0 0   0     0   0                       6
1371080 1371080 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield Vocational Academy   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 10 22 70 0   4     0   1   65 42 *                     107.0 10 22 70 0   4     0   1   65 42                 107
1374306 1374306 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374307 1374307 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374308 1374308 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1374309 1374309 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1374310 1374310 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1374311 1374311 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1374312 1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1374314 1374314 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1374315 1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1374316 1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1374317 1374317 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1374318 1374318 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1374319 1374319 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1374320 1374320 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   sped_beyond_grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1364784 1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1364799 1364799 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   kindergarten 79 1 5 0   1     0   3   51 38 *                     89.0 79 1 5 0   1     0   3   51 38                 89
1364800 1364800 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 39 1 4 0   0     0   2   28 18 *                     46.0 39 1 4 0   0     0   2   28 18                 46
1364801 1364801 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_1 118 1 2 0   2     0   4   62 65 *                     127.0 118 1 2 0   2     0   4   62 65                 127
1364802 1364802 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_2 96 4 5 0   1     0   3   56 53 *                     109.0 96 4 5 0   1     0   3   56 53                 109
1364803 1364803 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_3 74 1 4 1   0     0   5   44 41 *                     85.0 74 1 4 1   0     0   5   44 41                 85
1364804 1364804 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_4 99 0 4 0   1     0   7   56 55 *                     111.0 99 0 4 0   1     0   7   56 55                 111
1364809 1364809 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 6 18 0   15     0   7   93 67 *                     160.0 114 6 18 0   15     0   7   93 67                 160
1364838 1364838 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   kindergarten 60 1 1 0   0     0   1   33 30 *                     63.0 60 1 1 0   0     0   1   33 30                 63
1364839 1364839 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 32 0 1 0   0     0   0   18 15 *                     33.0 32 0 1 0   0     0   0   18 15                 33
1364840 1364840 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_1 48 1 0 0   0     0   2   24 27 *                     51.0 48 1 0 0   0     0   2   24 27                 51
1364841 1364841 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_2 58 0 9 0   0     0   4   42 29 *                     71.0 58 0 9 0   0     0   4   42 29                 71
1364842 1364842 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_3 51 2 5 0   1     0   3   43 19 *                     62.0 51 2 5 0   1     0   3   43 19                 62
1364843 1364843 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_4 59 1 2 1   0     0   3   29 37 *                     66.0 59 1 2 1   0     0   3   29 37                 66
1364844 1364844 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   kindergarten 52 2 15 0   0     0   2   32 39 *                     71.0 52 2 15 0   0     0   2   32 39                 71
1364845 1364845 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 23 0 3 0   0     0   0   16 10 *                     26.0 23 0 3 0   0     0   0   16 10                 26
1364846 1364846 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_1 52 0 7 0   1     1   3   36 28 *                     64.0 52 0 7 0   1     1   3   36 28                 64
1364847 1364847 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_2 61 2 10 0   1     0   2   41 35 *                     76.0 61 2 10 0   1     0   2   41 35                 76
1364848 1364848 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_3 64 4 11 0   1     0   2   41 41 *                     82.0 64 4 11 0   1     0   2   41 41                 82
1364849 1364849 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_4 78 2 12 0   2     0   3   57 40 *                     97.0 78 2 12 0   2     0   3   57 40                 97
1364863 1364863 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   kindergarten 20 4 3 0   4     0   1   14 17 *                     32.0 20 4 3 0   4     0   1   14 17                 32
1364864 1364864 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 26 4 15 0   5     0   3   37 15 *                     53.0 26 4 15 0   5     0   3   37 15                 53
1364865 1364865 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_1 28 4 13 0   4     0   6   25 30 *                     55.0 28 4 13 0   4     0   6   25 30                 55
1364866 1364866 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_2 20 3 9 2   4     0   6   24 19 *                     44.0 20 3 9 2   4     0   6   24 19                 44
1364867 1364867 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_3 22 5 6 0   5     0   7   25 20 *                     45.0 22 5 6 0   5     0   7   25 20                 45
1364868 1364868 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_4 27 7 11 0   10     0   1   30 26 *                     56.0 27 7 11 0   10     0   1   30 26                 56
1364869 1364869 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_5 26 2 16 0   7     0   3   28 26 *                     54.0 26 2 16 0   7     0   3   28 26                 54
1364870 1364870 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_6 29 3 20 0   6     0   3   34 27 *                     61.0 29 3 20 0   6     0   3   34 27                 61
1364897 1364897 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 44 0 10 0   20     0   7   59 22 *                     81.0 44 0 10 0   20     0   7   59 22                 81
1364954 1364954 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 51 4 3 0   20     0   11   56 33 *                     89.0 51 4 3 0   20     0   11   56 33                 89
1364980 1364980 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 61 5 5 0   22     0   0   58 35 *                     93.0 61 5 5 0   22     0   0   58 35                 93
1364999 1364999 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 132 8 31 0   8     0   5   105 79 *                     184.0 132 8 31 0   8     0   5   105 79                 184
1365042 1365042 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   kindergarten 72 0 8 0   2     0   2   38 46 *                     84.0 72 0 8 0   2     0   2   38 46                 84
1365043 1365043 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   pre_kindergarten 40 0 4 0   2     0   2   28 20 *                     48.0 40 0 4 0   2     0   2   28 20                 48
1365044 1365044 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_1 82 2 12 0   3     0   2   55 46 *                     101.0 82 2 12 0   3     0   2   55 46                 101
1365045 1365045 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_2 62 0 5 0   4     0   4   36 39 *                     75.0 62 0 5 0   4     0   4   36 39                 75
1365057 1365057 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   kindergarten 32 7 4 0   2     0   3   22 26 *                     48.0 32 7 4 0   2     0   3   22 26                 48
1365058 1365058 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   pre_kindergarten 6 9 3 0   1     0   3   11 11 *                     22.0 6 9 3 0   1     0   3   11 11                 22
1365059 1365059 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_1 28 11 6 0   1     0   7   25 28 *                     53.0 28 11 6 0   1     0   7   25 28                 53
1365060 1365060 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_2 30 13 7 0   3     0   4   34 23 *                     57.0 30 13 7 0   3     0   4   34 23                 57
1365061 1365061 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_3 29 15 8 0   4     0   3   29 30 *                     59.0 29 15 8 0   4     0   3   29 30                 59
1365062 1365062 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_4 36 16 5 0   4     0   3   34 30 *                     64.0 36 16 5 0   4     0   3   34 30                 64
1365063 1365063 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_5 30 17 7 0   1     0   0   27 28 *                     55.0 30 17 7 0   1     0   0   27 28                 55
1365064 1365064 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_6 31 14 3 1   4     0   5   34 24 *                     58.0 31 14 3 1   4     0   5   34 24                 58
1365071 1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1365102 1365102 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   kindergarten 113 11 10 0   37     0   12   107 76 *                     183.0 113 11 10 0   37     0   12   107 76                 183
1365103 1365103 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   pre_kindergarten 27 3 0 0   13     0   2   30 15 *                     45.0 27 3 0 0   13     0   2   30 15                 45
1365104 1365104 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_1 108 11 11 0   52     0   16   117 81 *                     198.0 108 11 11 0   52     0   16   117 81                 198
1365105 1365105 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_2 125 11 10 0   51     0   20   94 123 *                     217.0 125 11 10 0   51     0   20   94 123                 217
1365116 1365116 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No Elementary PK KG 2020   kindergarten 129 0 11 0   3     0   3   80 66 *                     146.0 129 0 11 0   3     0   3   80 66                 146
1365117 1365117 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No Elementary PK KG 2020   pre_kindergarten 36 2 4 0   0     0   1   27 16 *                     43.0 36 2 4 0   0     0   1   27 16                 43
1365131 1365131 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 82 3 3 0   10     0   0   52 46 *                     98.0 82 3 3 0   10     0   0   52 46                 98
1365169 1365169 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   kindergarten 76 3 0 0   21     0   10   54 56 *                     110.0 76 3 0 0   21     0   10   54 56                 110
1365170 1365170 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   pre_kindergarten 46 4 3 0   11     0   2   32 34 *                     66.0 46 4 3 0   11     0   2   32 34                 66
1365171 1365171 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_1 74 8 1 0   15     0   10   49 59 *                     108.0 74 8 1 0   15     0   10   49 59                 108
1365172 1365172 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_2 83 3 3 0   17     0   6   58 54 *                     112.0 83 3 3 0   17     0   6   58 54                 112
1365173 1365173 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_3 81 0 1 0   21     0   16   63 56 *                     119.0 81 0 1 0   21     0   16   63 56                 119
1365174 1365174 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_4 84 1 3 0   12     0   13   61 52 *                     113.0 84 1 3 0   12     0   13   61 52                 113
1365183 1365183 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   kindergarten 85 0 1 1   0     0   9   50 46 *                     96.0 85 0 1 1   0     0   9   50 46                 96
1365184 1365184 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   pre_kindergarten 59 1 0 0   0     0   1   39 22 *                     61.0 59 1 0 0   0     0   1   39 22                 61
1365185 1365185 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   grade_1 80 1 1 0   2     1   0   43 42 *                     85.0 80 1 1 0   2     1   0   43 42                 85
1365186 1365186 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   grade_2 74 1 1 0   0     0   4   40 40 *                     80.0 74 1 1 0   0     0   4   40 40                 80
1365187 1365187 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   grade_3 97 0 1 0   1     0   3   57 45 *                     102.0 97 0 1 0   1     0   3   57 45                 102
1365188 1365188 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   grade_4 90 0 3 0   0     0   5   38 60 *                     98.0 90 0 3 0   0     0   5   38 60                 98
1365193 1365193 MA Essex   school 2502640 30   Beverly 250264002854 300002 McKeown School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 84 8 9 1   3     0   3   63 45 *                     108.0 84 8 9 1   3     0   3   63 45                 108
1365266 1365266 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2020   kindergarten 1 20 9 0   4     0   1   12 23 *                     35.0 1 20 9 0   4     0   1   12 23                 35
1365267 1365267 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2020   pre_kindergarten 2 18 22 0   4     0   5   26 25 *                     51.0 2 18 22 0   4     0   5   26 25                 51
1365268 1365268 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2020   grade_1 1 19 8 0   2     0   4   20 14 *                     34.0 1 19 8 0   2     0   4   20 14                 34
1365269 1365269 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2020   grade_2 2 14 18 0   1     0   1   19 17 *                     36.0 2 14 18 0   1     0   1   19 17                 36

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