enrollments

Data source: Big Local News · About: Big Local

988 rows where grade = "grade_1", state = "MA" and year = 2016 sorted by free_and_reduced_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 888 ✖

grade ✖

  • grade_1 · 888 ✖
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
933355 933355 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2016   grade_1 4 79 30 0   0     0   2   58 57                       115 4 79 30 0   0     0   2   58 57                 115
933362 933362 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2016   grade_1 6 25 12 0   37     0   9   45 44                       89 6 25 12 0   37     0   9   45 44                 89
933369 933369 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_1 3 35 41 0   2     0   3   47 37                       84 3 35 41 0   2     0   3   47 37                 84
933378 933378 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   grade_1 4 17 15 0   1     0   2   17 22                       39 4 17 15 0   1     0   2   17 22                 39
933385 933385 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   grade_1 13 3 3 0   3     0   1   12 11                       23 13 3 3 0   3     0   1   12 11                 23
933392 933392 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_1 9 12 17 1   25     0   3   35 32                       67 9 12 17 1   25     0   3   35 32                 67
933402 933402 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2016   grade_1 1 10 8 0   1     0   2   6 16                       22 1 10 8 0   1     0   2   6 16                 22
933409 933409 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_1 11 6 5 0   1     0   1   17 7                       24 11 6 5 0   1     0   1   17 7                 24
933419 933419 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_1 2 36 40 0   1     0   0   34 45                       79 2 36 40 0   1     0   0   34 45                 79
933435 933435 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_1 27 1 14 0   2     0   0   24 20                       44 27 1 14 0   2     0   0   24 20                 44
933445 933445 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2016   grade_1 1 3 42 0   1     0   0   21 26                       47 1 3 42 0   1     0   0   21 26                 47
933452 933452 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 03 2016   grade_1 15 11 16 0   5     0   0   22 25                       47 15 11 16 0   5     0   0   22 25                 47
933457 933457 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2016   grade_1 3 20 41 0   7     0   3   29 45                       74 3 20 41 0   7     0   3   29 45                 74
933464 933464 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2016   grade_1 10 9 14 0   5     0   1   23 16                       39 10 9 14 0   5     0   1   23 16                 39
933471 933471 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No 1 PK 05 2016   grade_1 16 24 13 0   67     0   2   54 68                       122 16 24 13 0   67     0   2   54 68                 122
933478 933478 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2016   grade_1 15 14 2 1   3     0   2   21 16                       37 15 14 2 1   3     0   2   21 16                 37
933485 933485 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No 1 PK 05 2016   grade_1 9 1 43 0   0     0   0   25 28                       53 9 1 43 0   0     0   0   25 28                 53
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
933509 933509 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   grade_1 2 3 30 0   2     0   1   18 20                       38 2 3 30 0   2     0   1   18 20                 38
933519 933519 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2016   grade_1 11 13 8 0   12     0   2   19 27                       46 11 13 8 0   12     0   2   19 27                 46
933526 933526 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_1 38 9 14 0   3     0   4   34 34                       68 38 9 14 0   3     0   4   34 34                 68
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
933554 933554 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2016   grade_1 1 16 41 1   6     0   1   33 33                       66 1 16 41 1   6     0   1   33 33                 66
933561 933561 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_1 6 40 20 0   0     0   3   37 32                       69 6 40 20 0   0     0   3   37 32                 69
933570 933570 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2016   grade_1 14 7 13 0   4     0   4   18 24                       42 14 7 13 0   4     0   4   18 24                 42
933577 933577 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   grade_1 10 10 24 1   19     0   2   38 28                       66 10 10 24 1   19     0   2   38 28                 66
933587 933587 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_1 0 50 18 0   2     0   4   42 32                       74 0 50 18 0   2     0   4   42 32                 74
933596 933596 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_1 1 33 19 1   2     0   1   32 25                       57 1 33 19 1   2     0   1   32 25                 57
933606 933606 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_1 1 33 8 0   0     0   1   15 28                       43 1 33 8 0   0     0   1   15 28                 43
933614 933614 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_1 0 22 26 0   0     0   3   31 20                       51 0 22 26 0   0     0   3   31 20                 51
933624 933624 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_1 9 8 5 0   0     0   2   11 13                       24 9 8 5 0   0     0   2   11 13                 24
933637 933637 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_1 1 17 60 0   0     0   1   40 39                       79 1 17 60 0   0     0   1   40 39                 79
933777 933777 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_1 4 2 62 0   1     0   0   28 41                       69 4 2 62 0   1     0   0   28 41                 69
933803 933803 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_1 2 4 43 0   0     0   1   24 26                       50 2 4 43 0   0     0   1   24 26                 50
933813 933813 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_1 1 6 3 0   0     0   0   8 2                       10 1 6 3 0   0     0   0   8 2                 10
933831 933831 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_1 72 2 7 1   0     0   2   52 32                       84 72 2 7 1   0     0   2   52 32                 84
933836 933836 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   grade_1 55 1 1 1   2     0   1   28 33                       61 55 1 1 1   2     0   1   28 33                 61
933850 933850 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2016   grade_1 72 0 1 0   6     0   3   49 33                       82 72 0 1 0   6     0   3   49 33                 82
933858 933858 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2016   grade_1 30 0 1 0   2     0   1   12 22                       34 30 0 1 0   2     0   1   12 22                 34
933864 933864 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No 1 KG 05 2016   grade_1 67 0 2 0   12     0   0   39 42                       81 67 0 2 0   12     0   0   39 42                 81
933871 933871 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No 1 KG 05 2016   grade_1 61 1 5 1   10     0   2   43 37                       80 61 1 5 1   10     0   2   43 37                 80
933877 933877 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No 1 KG 05 2016   grade_1 41 1 1 0   14     0   0   24 33                       57 41 1 1 0   14     0   0   24 33                 57
933882 933882 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2016   grade_1 58 0 4 0   19     0   2   45 38                       83 58 0 4 0   19     0   2   45 38                 83
933888 933888 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2016   grade_1 48 5 6 1   5     0   0   32 33                       65 48 5 6 1   5     0   0   32 33                 65
933894 933894 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 KG 05 2016   grade_1 34 5 7 1   7     0   2   28 28                       56 34 5 7 1   7     0   2   28 28                 56
933913 933913 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   grade_1 66 2 7 0   1     0   2   35 43                       78 66 2 7 0   1     0   2   35 43                 78
933920 933920 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_1 35 2 0 0   0     0   0   19 18                       37 35 2 0 0   0     0   0   19 18                 37
933927 933927 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_1 17 98 30 2   0     0   15   90 72                       162 17 98 30 2   0     0   15   90 72                 162
933933 933933 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2016   grade_1 38 63 17 1   1     0   6   69 57                       126 38 63 17 1   1     0   6   69 57                 126
933939 933939 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2016   grade_1 12 50 78 1   0     0   4   78 67                       145 12 50 78 1   0     0   4   78 67                 145
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
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
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
933975 933975 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_1 10 63 13 0   0     0   7   54 39                       93 10 63 13 0   0     0   7   54 39                 93
933981 933981 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_1 21 92 14 2   8     0   7   79 65                       144 21 92 14 2   8     0   7   79 65                 144
933987 933987 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 05 2016   grade_1 13 105 14 0   0     0   5   65 72                       137 13 105 14 0   0     0   5   65 72                 137
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
934039 934039 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_1 38 0 2 0   0     0   2   21 21                       42 38 0 2 0   0     0   2   21 21                 42
934048 934048 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_1 54 6 7 0   39     0   5   50 61                       111 54 6 7 0   39     0   5   50 61                 111
934057 934057 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_1 74 5 8 0   10     0   13   54 56                       110 74 5 8 0   10     0   13   54 56                 110
934067 934067 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_1 45 2 3 0   6     0   14   37 33                       70 45 2 3 0   6     0   14   37 33                 70
934077 934077 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2016   grade_1 43 2 4 0   11     0   11   33 38                       71 43 2 4 0   11     0   11   33 38                 71
934086 934086 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_1 41 2 7 0   37     0   6   42 51                       93 41 2 7 0   37     0   6   42 51                 93
934095 934095 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_1 30 8 6 0   17     0   6   31 36                       67 30 8 6 0   17     0   6   31 36                 67
934104 934104 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2016   grade_1 54 1 10 0   34     0   9   55 53                       108 54 1 10 0   34     0   9   55 53                 108
934114 934114 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_1 40 5 9 0   9     0   3   37 29                       66 40 5 9 0   9     0   3   37 29                 66
934130 934130 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No 1 KG 05 2016   grade_1 35 1 4 0   20     0   4   38 26                       64 35 1 4 0   20     0   4   38 26                 64
934136 934136 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No 1 KG 05 2016   grade_1 35 4 4 0   18     0   3   35 29                       64 35 4 4 0   18     0   3   35 29                 64
934142 934142 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No 1 KG 05 2016   grade_1 27 1 3 0   5     0   2   18 20                       38 27 1 3 0   5     0   2   18 20                 38
934148 934148 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No 1 KG 05 2016   grade_1 56 5 5 0   19     0   3   42 46                       88 56 5 5 0   19     0   3   42 46                 88
934164 934164 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2016   grade_1 34 9 7 0   5     0   5   34 26                       60 34 9 7 0   5     0   5   34 26                 60
934171 934171 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   grade_1 18 2 23 0   1     0   4   26 22                       48 18 2 23 0   1     0   4   26 22                 48
934181 934181 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2016   grade_1 31 5 4 0   3     0   2   25 20                       45 31 5 4 0   3     0   2   25 20                 45
934188 934188 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2016   grade_1 19 12 1 0   10     0   4   20 26                       46 19 12 1 0   10     0   4   20 26                 46
934195 934195 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2016   grade_1 16 12 0 0   13     0   11   27 25                       52 16 12 0 0   13     0   11   27 25                 52
934202 934202 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   grade_1 28 15 7 0   3     0   8   33 28                       61 28 15 7 0   3     0   8   33 28                 61
934209 934209 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No 1 PK 05 2016   grade_1 19 10 11 0   5     0   5   19 31                       50 19 10 11 0   5     0   5   19 31                 50
934216 934216 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2016   grade_1 16 8 6 0   7     0   4   21 20                       41 16 8 6 0   7     0   4   21 20                 41
934223 934223 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No 1 PK 05 2016   grade_1 18 16 1 0   7     0   2   23 21                       44 18 16 1 0   7     0   2   23 21                 44
934230 934230 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No 1 PK 05 2016   grade_1 7 10 6 0   10     0   5   18 20                       38 7 10 6 0   10     0   5   18 20                 38
934237 934237 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2016   grade_1 22 13 5 0   13     0   1   29 25                       54 22 13 5 0   13     0   1   29 25                 54
934244 934244 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2016   grade_1 12 12 8 0   6     0   2   22 18                       40 12 12 8 0   6     0   2   22 18                 40
934268 934268 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No 1 KG 05 2016   grade_1 51 12 7 0   6     0   1   36 41                       77 51 12 7 0   6     0   1   36 41                 77
934274 934274 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No 1 KG 05 2016   grade_1 62 3 3 0   8     0   3   36 43                       79 62 3 3 0   8     0   3   36 43                 79
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
934294 934294 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_1 36 0 2 0   7     0   7   30 22                       52 36 0 2 0   7     0   7   30 22                 52
934304 934304 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2016   grade_1 114 1 1 0   0     0   0   48 68                       116 114 1 1 0   0     0   0   48 68                 116
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
934324 934324 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No 1 KG 04 2016   grade_1 48 0 6 0   17     0   4   47 28                       75 48 0 6 0   17     0   4   47 28                 75
934329 934329 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No 1 KG 04 2016   grade_1 76 4 7 0   18     0   1   57 49                       106 76 4 7 0   18     0   1   57 49                 106
934334 934334 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2016   grade_1 72 0 6 1   6     0   4   46 43                       89 72 0 6 1   6     0   4   46 43                 89
934352 934352 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_1 25 6 110 0   2     0   2   86 59                       145 25 6 110 0   2     0   2   86 59                 145
934356 934356 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_1 18 16 159 0   1     0   4   103 95                       198 18 16 159 0   1     0   4   103 95                 198
934360 934360 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2016   grade_1 7 2 158 0   1     0   1   91 78                       169 7 2 158 0   1     0   1   91 78                 169
934364 934364 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2016   grade_1 13 14 96 0   2     0   4   57 72                       129 13 14 96 0   2     0   4   57 72                 129
934387 934387 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2016   grade_1 48 3 15 0   4     0   4   38 36                       74 48 3 15 0   4     0   4   38 36                 74
934393 934393 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2016   grade_1 49 6 39 0   0     0   0   52 42                       94 49 6 39 0   0     0   0   52 42                 94
934397 934397 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2016   grade_1 19 3 44 0   0     0   3   34 35                       69 19 3 44 0   0     0   3   34 35                 69

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