enrollments

Data source: Big Local News · About: Big Local

11,284 rows where state = "MA" and year = 2018 sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 11,284 ✖
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
2233170 2233170 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg: Advanced Community Experience Program   Special Education School No Ungraded UG UG 2018   sped_beyond_grade_12 8 0 0 0   0     0   1                             9.0 8 0 0 0   0     0   1                       9
2236260 2236260 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield: Springfield Vocational Academy   Special Education School No Ungraded UG UG 2018   sped_beyond_grade_12 12 15 63 0   2     0   0                             92.0 12 15 63 0   2     0   0                       92
2239361 2239361 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 North Middlesex: Peter Fitzpatrick School   Regular School No Ungraded UG UG 2018   sped_beyond_grade_12 17 0 0 0   0     0   1                             18.0 17 0 0 0   0     0   1                       18
2230470 2230470 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230471 2230471 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_9 0 15 2 0   0     0   0   11 6                       17.0 0 15 2 0   0     0   0   11 6                 17
2230472 2230472 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_10 1 6 1 0   0     0   0   5 3                       8.0 1 6 1 0   0     0   0   5 3                 8
2230473 2230473 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2239932 2239932 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_6 4 18 54 0   1     1   2   37 43                       80.0 4 18 54 0   1     1   2   37 43                 80
2239933 2239933 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_7 6 18 55 0   0     0   1   48 32                       80.0 6 18 55 0   0     0   1   48 32                 80
2239934 2239934 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_8 5 25 49 0   1     0   0   41 39                       80.0 5 25 49 0   1     0   0   41 39                 80
2239935 2239935 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_9 3 16 54 0   1     0   1   35 40                       75.0 3 16 54 0   1     0   1   35 40                 75
2239936 2239936 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_10 4 23 44 0   1     0   1   38 35                       73.0 4 23 44 0   1     0   1   38 35                 73
2239937 2239937 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_11 1 15 41 0   0     0   0   27 30                       57.0 1 15 41 0   0     0   0   27 30                 57
2239938 2239938 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228754 2228754 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 70 9 1 0   4     0   0   45 39                       84.0 70 9 1 0   4     0   0   45 39                 84
2228755 2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228785 2228785 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 121 3 22 0   14     0   3   88 75                       163.0 121 3 22 0   14     0   3   88 75                 163
2228786 2228786 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228890 2228890 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover: Shawsheen School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 47 2 7 0   27     0   2   61 24                       85.0 47 2 7 0   27     0   2   61 24                 85
2228891 2228891 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover: Shawsheen School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228958 2228958 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 48 4 8 0   18     0   7   58 27                       85.0 48 4 8 0   18     0   7   58 27                 85
2228959 2228959 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228990 2228990 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland: William Pittaway Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 95 3 0 1   28     0   0   72 55                       127.0 95 3 0 1   28     0   0   72 55                 127
2228991 2228991 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland: William Pittaway Elementary   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229015 2229015 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro: Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 134 10 20 0   7     0   13   110 74                       184.0 134 10 20 0   7     0   13   110 74                 184
2229016 2229016 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro: Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229103 2229103 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 85 11 26 2   1     0   10   75 60                       135.0 85 11 26 2   1     0   10   75 60                 135
2229104 2229104 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229174 2229174 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham: Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 98 3 2 0   3     1   3   59 51                       110.0 98 3 2 0   3     1   3   59 51                 110
2229175 2229175 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham: Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229258 2229258 MA Essex   school 2502640 30   Beverly 250264002854 300002 Beverly: McKeown School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 82 4 15 0   6     0   7   70 44                       114.0 82 4 15 0   6     0   7   70 44                 114
2229259 2229259 MA Essex   school 2502640 30   Beverly 250264002854 300002 Beverly: McKeown School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230416 2230416 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Brockton: Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 66 131 23 0   2     0   15   143 94                       237.0 66 131 23 0   2     0   15   143 94                 237
2230417 2230417 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Brockton: Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230536 2230536 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline: Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 30 2 3 0   16     0   9   27 33                       60.0 30 2 3 0   16     0   9   27 33                 60
2230537 2230537 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline: Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230538 2230538 MA Norfolk   school 2503150 46   Brookline 250315002793 460002 Brookline: Brookline Early Education Program at Putterham   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 25 5 7 0   16     0   7   34 26                       60.0 25 5 7 0   16     0   7   34 26                 60
2230539 2230539 MA Norfolk   school 2503150 46   Brookline 250315002793 460002 Brookline: Brookline Early Education Program at Putterham   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230623 2230623 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 Brookline: The Lynch Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 16 7 11 0   11     0   13   31 27                       58.0 16 7 11 0   11     0   13   31 27                 58
2230624 2230624 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 Brookline: The Lynch Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230790 2230790 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Canton: Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 56 9 9 0   8     0   6   56 32                       88.0 56 9 9 0   8     0   6   56 32                 88
2230791 2230791 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Canton: Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230849 2230849 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Chelmsford: Community Education Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 84 4 9 1   31     0   3   80 52                       132.0 84 4 9 1   31     0   3   80 52                 132
2230850 2230850 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Chelmsford: Community Education Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230934 2230934 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Chicopee: Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 153 11 58 0   4     0   15   144 97                       241.0 153 11 58 0   4     0   15   144 97                 241
2230935 2230935 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Chicopee: Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231433 2231433 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Everett: Adams School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 65 40 78 0   11     0   7   120 81                       201.0 65 40 78 0   11     0   7   120 81                 201
2231434 2231434 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Everett: Adams School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231786 2231786 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham: Juniper Hill School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 136 19 70 0   30     1   17   143 130                       273.0 136 19 70 0   30     1   17   143 130                 273
2231787 2231787 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham: Juniper Hill School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231866 2231866 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 84 3 8 1   1     3   4   63 41                       104.0 84 3 8 1   1     3   4   63 41                 104
2231867 2231867 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231950 2231950 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Georgetown: Perley Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 118 0 0 1   1     0   1   58 63                       121.0 118 0 0 1   1     0   1   58 63                 121
2231951 2231951 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Georgetown: Perley Elementary   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231982 2231982 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester: Gloucester PreSchool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 86 4 8 0   2     0   7   62 45                       107.0 86 4 8 0   2     0   7   62 45                 107
2231983 2231983 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester: Gloucester PreSchool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232074 2232074 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 Greenfield: The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 96 2 14 0   2     0   3   61 56                       117.0 96 2 14 0   2     0   3   61 56                 117
2232075 2232075 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 Greenfield: The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232225 2232225 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Haverhill: Moody   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 138 14 63 0   4     1   1   141 80                       221.0 138 14 63 0   4     1   1   141 80                 221
2232226 2232226 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Haverhill: Moody   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232445 2232445 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Hopedale: Park Street School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 67 0 1 1   2     0   12   42 41                       83.0 67 0 1 1   2     0   12   42 41                 83
2232446 2232446 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Hopedale: Park Street School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232462 2232462 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton: Hopkinton Pre-School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 49 0 4 0   6     0   0   35 24                       59.0 49 0 4 0   6     0   0   35 24                 59
2232463 2232463 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton: Hopkinton Pre-School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232762 2232762 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Leominster: Bennett   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 47 8 26 0   4     0   1   58 28                       86.0 47 8 26 0   4     0   1   58 28                 86
2232763 2232763 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Leominster: Bennett   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232764 2232764 MA Worcester   school 2506780 153   Leominster 250678001947 1530005 Leominster: Lincoln School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 30 2 13 0   2     0   1   34 14                       48.0 30 2 13 0   2     0   1   34 14                 48
2232765 2232765 MA Worcester   school 2506780 153   Leominster 250678001947 1530005 Leominster: Lincoln School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232828 2232828 MA Middlesex   school 2506840 155   Lexington 250684002829 1550001 Lexington: Lexington Children's Place   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 27 4 5 0   30     0   5   41 30                       71.0 27 4 5 0   30     0   5   41 30                 71
2232829 2232829 MA Middlesex   school 2506840 155   Lexington 250684002829 1550001 Lexington: Lexington Children's Place   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233338 2233338 MA Essex   school 2507140 164   Lynnfield 250714002617 1640005 Lynnfield: Lynnfield Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 32 0 1 0   3     0   2   18 20                       38.0 32 0 1 0   3     0   2   18 20                 38
2233339 2233339 MA Essex   school 2507140 164   Lynnfield 250714002617 1640005 Lynnfield: Lynnfield Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233402 2233402 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden: Malden Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 110 47 21 0   119     0   17   187 127                       314.0 110 47 21 0   119     0   17   187 127                 314
2233403 2233403 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden: Malden Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233419 2233419 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Mansfield: Roland Green School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 77 3 6 0   7     0   4   53 44                       97.0 77 3 6 0   7     0   4   53 44                 97
2233420 2233420 MA Bristol   school 2507230 167   Mansfield 250723001004 1670003 Mansfield: Roland Green School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233476 2233476 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 104 6 26 0   30     2   6   108 66                       174.0 104 6 26 0   30     2   6   108 66                 174
2233477 2233477 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233685 2233685 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Melrose: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 261 6 13 0   14     0   24   165 153                       318.0 261 6 13 0   14     0   24   165 153                 318
2233686 2233686 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Melrose: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233822 2233822 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Milford: Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 107 1 27 1   7     0   1   79 65                       144.0 107 1 27 1   7     0   1   79 65                 144
2233823 2233823 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Milford: Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234317 2234317 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton: Newton Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 103 11 18 0   43     0   22   127 70                       197.0 103 11 18 0   43     0   22   127 70                 197
2234318 2234318 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton: Newton Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234529 2234529 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough: North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 95 3 7 1   15     1   4   79 47                       126.0 95 3 7 1   15     1   4   79 47                 126
2234530 2234530 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough: North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235009 2235009 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth: Plymouth Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 121 4 3 0   2     0   10   70 70                       140.0 121 4 3 0   2     0   10   70 70                 140
2235010 2235010 MA Plymouth   school 2509720 239   Plymouth 250972000318 2390003 Plymouth: Plymouth Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235103 2235103 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Quincy: Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 69 15 16 0   86     0   7   107 86                       193.0 69 15 16 0   86     0   7   107 86                 193
2235104 2235104 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Quincy: Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235251 2235251 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 Reading: RISE PreSchool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 76 2 7 0   7     0   2   59 35                       94.0 76 2 7 0   7     0   2   59 35                 94
2235252 2235252 MA Middlesex   school 2509990 246   Reading 250999002751 2460001 Reading: RISE PreSchool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235443 2235443 MA Essex   school 2510380 258   Salem 251038000127 2580001 Salem: Salem Early Childhood   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 49 13 21 0   3     0   7   53 40                       93.0 49 13 21 0   3     0   7   53 40                 93
2235444 2235444 MA Essex   school 2510380 258   Salem 251038000127 2580001 Salem: Salem Early Childhood   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235640 2235640 MA Norfolk   school 2510620 266   Sharon 251062002872 2660001 Sharon: Sharon Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 29 3 5 0   9     0   4   29 21                       50.0 29 3 5 0   9     0   4   29 21                 50
2235641 2235641 MA Norfolk   school 2510620 266   Sharon 251062002872 2660001 Sharon: Sharon Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235709 2235709 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Shrewsbury: Parker Road Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 101 8 19 2   95     0   10   118 117                       235.0 101 8 19 2   95     0   10   118 117                 235
2235710 2235710 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Shrewsbury: Parker Road Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235906 2235906 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Springfield: Early Childhood Education Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 15 34 117 1   0     0   3   110 60                       170.0 15 34 117 1   0     0   3   110 60                 170
2235907 2235907 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Springfield: Early Childhood Education Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0

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