enrollments

Data source: Big Local News · About: Big Local

973 rows where grade = "grade_1", state = "MA" and year = 2021 sorted by homeless_percent

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 873 ✖

grade ✖

  • grade_1 · 873 ✖
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
1672830 1672830 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Boston - Mather   Regular School No Elementary PK 05 2021   grade_1 5 32 11 1   21     0   5   40 35 *                     75.0 5 32 11 1   21     0   5   40 35                 75
1672837 1672837 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_1 2 9 21 0   0     0   2   16 18 *                     34.0 2 9 21 0   0     0   2   16 18                 34
1672847 1672847 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_1 3 9 5 0   3     0   1   8 13 *                     21.0 3 9 5 0   3     0   1   8 13                 21
1672855 1672855 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Boston - Mozart   Regular School No Elementary PK 05 2021   grade_1 9 7 3 0   0     0   4   12 11 *                     23.0 9 7 3 0   0     0   4   12 11                 23
1672862 1672862 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_1 5 12 4 0   42     0   3   26 40 *                     66.0 5 12 4 0   42     0   3   26 40                 66
1672872 1672872 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_1 1 13 8 0   0     0   0   12 10 *                     22.0 1 13 8 0   0     0   0   12 10                 22
1672880 1672880 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_1 19 1 5 0   0     0   0   13 12 *                     25.0 19 1 5 0   0     0   0   13 12                 25
1672889 1672889 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_1 1 46 32 1   1     0   1   46 36 *                     82.0 1 46 32 1   1     0   1   46 36                 82
1672905 1672905 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_1 41 4 7 0   7     0   6   32 33 *                     65.0 41 4 7 0   7     0   6   32 33                 65
1672915 1672915 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston - Patrick J Kennedy   Regular School No Elementary PK 06 2021   grade_1 5 1 31 0   0     0   0   20 17 *                     37.0 5 1 31 0   0     0   0   20 17                 37
1672923 1672923 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Boston - Dr. William Henderson Lower   Regular School No Elementary PK 01 2021   grade_1 28 16 12 0   8     1   1   27 38 *                     66.0 28 16 12 0   8     1   1   27 38                 66
1672926 1672926 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Boston - Paul A Dever   Regular School No Elementary PK 05 2021   grade_1 4 10 28 0   1     1   1   20 25 *                     45.0 4 10 28 0   1     1   1   20 25                 45
1672933 1672933 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston - Phineas Bates   Regular School No Elementary PK 05 2021   grade_1 18 9 6 1   1     0   3   19 19 *                     38.0 18 9 6 1   1     0   3   19 19                 38
1672940 1672940 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston - Josiah Quincy   Regular School No Elementary PK 05 2021   grade_1 11 13 11 0   68     0   10   54 59 *                     113.0 11 13 11 0   68     0   10   54 59                 113
1672947 1672947 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_1 4 4 8 0   1     0   0   8 9 *                     17.0 4 4 8 0   1     0   0   8 9                 17
1672955 1672955 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_1 4 2 30 0   1     0   2   14 25 *                     39.0 4 2 30 0   1     0   2   14 25                 39
1672963 1672963 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston - Samuel W Mason   Regular School No Elementary PK 05 2021   grade_1 1 17 9 1   3     0   4   20 15 *                     35.0 1 17 9 1   3     0   4   20 15                 35
1672970 1672970 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_1 2 8 35 0   0     0   0   19 26 *                     45.0 2 8 35 0   0     0   0   19 26                 45
1672980 1672980 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_1 4 2 25 0   4     0   1   14 22 *                     36.0 4 2 25 0   4     0   1   14 22                 36
1672990 1672990 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston - Thomas J Kenny   Regular School No Elementary PK 06 2021   grade_1 19 6 5 0   5     0   3   13 25 *                     38.0 19 6 5 0   5     0   3   13 25                 38
1672998 1672998 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_1 40 4 11 0   4     0   2   32 29 *                     61.0 40 4 11 0   4     0   2   32 29                 61
1673008 1673008 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_1 2 12 17 0   0     0   3   16 18 *                     34.0 2 12 17 0   0     0   3   16 18                 34
1673027 1673027 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston - William E Russell   Regular School No Elementary PK 05 2021   grade_1 3 14 28 0   6     0   2   26 27 *                     53.0 3 14 28 0   6     0   2   26 27                 53
1673034 1673034 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_1 1 23 15 0   0     1   2   19 23 *                     42.0 1 23 15 0   0     1   2   19 23                 42
1673044 1673044 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston - Winship Elementary   Regular School No Elementary PK 05 2021   grade_1 13 6 13 0   3     0   5   14 26 *                     40.0 13 6 13 0   3     0   5   14 26                 40
1673051 1673051 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_1 10 5 25 0   9     0   1   28 22 *                     50.0 10 5 25 0   9     0   1   28 22                 50
1673061 1673061 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_1 1 28 30 1   0     0   2   33 29 *                     62.0 1 28 30 1   0     0   2   33 29                 62
1673077 1673077 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_1 2 22 12 0   2     0   2   16 24 *                     40.0 2 22 12 0   2     0   2   16 24                 40
1673087 1673087 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_1 0 19 28 1   0     1   1   25 25 *                     50.0 0 19 28 1   0     1   1   25 25                 50
1673097 1673097 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_1 10 7 5 0   1     0   3   17 9 *                     26.0 10 7 5 0   1     0   3   17 9                 26
1673110 1673110 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Boston - Blackstone   Regular School No Elementary PK 05 2021   grade_1 3 17 41 1   1     0   0   31 32 *                     63.0 3 17 41 1   1     0   0   31 32                 63
1673249 1673249 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_1 5 1 46 1   0     0   2   23 32 *                     55.0 5 1 46 1   0     0   2   23 32                 55
1673270 1673270 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_1 8 2 36 0   0     0   3   22 27 *                     49.0 8 2 36 0   0     0   3   22 27                 49
1673295 1673295 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_1 88 2 12 1   3     0   9   62 53 *                     115.0 88 2 12 1   3     0   9   62 53                 115
1673310 1673310 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford - Harry Lee Cole   Regular School No Elementary PK 02 2021   grade_1 94 0 4 0   1     0   6   58 47 *                     105.0 94 0 4 0   1     0   6   58 47                 105
1673317 1673317 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Braintree - Hollis   Regular School No Elementary KG 05 2021   grade_1 41 2 2 0   25     0   2   42 30 *                     72.0 41 2 2 0   25     0   2   42 30                 72
1673323 1673323 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Braintree - Highlands   Regular School No Elementary KG 05 2021   grade_1 68 1 0 0   21     0   0   52 38 *                     90.0 68 1 0 0   21     0   0   52 38                 90
1673329 1673329 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Braintree - Mary E Flaherty School   Regular School No Elementary KG 05 2021   grade_1 36 1 3 0   15     0   2   31 26 *                     57.0 36 1 3 0   15     0   2   31 26                 57
1673333 1673333 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_1 37 2 3 0   17     0   3   34 28 *                     62.0 37 2 3 0   17     0   3   34 28                 62
1673339 1673339 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Braintree - Archie T Morrison   Regular School No Elementary KG 05 2021   grade_1 39 2 3 1   15     0   2   31 31 *                     62.0 39 2 3 1   15     0   2   31 31                 62
1673344 1673344 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree - Donald Ross   Regular School No Elementary KG 05 2021   grade_1 27 3 5 1   15     0   1   17 35 *                     52.0 27 3 5 1   15     0   1   17 35                 52
1673362 1673362 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   grade_1 49 0 8 0   0     0   7   35 29 *                     64.0 49 0 8 0   0     0   7   35 29                 64
1673369 1673369 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_1 36 0 6 1   0     0   0   19 24 *                     43.0 36 0 6 1   0     0   0   19 24                 43
1673377 1673377 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   grade_1 17 63 22 0   0     0   6   61 47 *                     108.0 17 63 22 0   0     0   6   61 47                 108
1673383 1673383 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton - Mary E. Baker School   Regular School No Elementary KG 05 2021   grade_1 29 45 16 0   2     1   2   51 44 *                     95.0 29 45 16 0   2     1   2   51 44                 95
1673389 1673389 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton - Manthala George Jr. School   Regular School No Elementary KG 05 2021   grade_1 12 75 59 1   0     0   2   77 72 *                     149.0 12 75 59 1   0     0   2   77 72                 149
1673397 1673397 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton - Brookfield   Regular School No Elementary KG 05 2021   grade_1 17 37 10 1   1     0   4   29 41 *                     70.0 17 37 10 1   1     0   4   29 41                 70
1673403 1673403 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_1 14 56 3 0   1     1   4   40 39 *                     79.0 14 56 3 0   1     1   4   40 39                 79
1673409 1673409 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_1 12 67 15 1   0     0   4   46 53 *                     99.0 12 67 15 1   0     0   4   46 53                 99
1673418 1673418 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton - Hancock   Regular School No Elementary KG 05 2021   grade_1 17 34 11 0   5     0   5   39 33 *                     72.0 17 34 11 0   5     0   5   39 33                 72
1673424 1673424 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton - Gilmore Elementary School   Regular School No Elementary KG 05 2021   grade_1 1 58 5 0   0     0   1   32 33 *                     65.0 1 58 5 0   0     0   1   32 33                 65
1673430 1673430 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_1 13 63 14 0   9     0   2   65 36 *                     101.0 13 63 14 0   9     0   2   65 36                 101
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
1673445 1673445 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_1 20 50 19 0   0     0   6   52 43 *                     95.0 20 50 19 0   0     0   6   52 43                 95
1673490 1673490 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_1 29 1 3 0   0     0   2   23 12 *                     35.0 29 1 3 0   0     0   2   23 12                 35
1673500 1673500 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_1 36 2 9 1   22     0   6   41 35 *                     76.0 36 2 9 1   22     0   6   41 35                 76
1673510 1673510 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_1 46 7 9 0   18     0   6   43 43 *                     86.0 46 7 9 0   18     0   6   43 43                 86
1673519 1673519 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_1 27 1 4 0   12     0   6   26 24 *                     50.0 27 1 4 0   12     0   6   26 24                 50
1673529 1673529 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_1 35 0 3 0   8     0   5   31 20 *                     51.0 35 0 3 0   8     0   5   31 20                 51
1673538 1673538 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_1 23 4 4 0   28     1   10   34 36 *                     70.0 23 4 4 0   28     1   10   34 36                 70
1673547 1673547 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_1 22 5 3 0   13     0   4   23 24 *                     47.0 22 5 3 0   13     0   4   23 24                 47
1673556 1673556 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_1 25 1 10 0   24     0   7   22 45 *                     67.0 25 1 10 0   24     0   7   22 45                 67
1673566 1673566 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_1 32 0 6 0   10     0   6   32 22 *                     54.0 32 0 6 0   10     0   6   32 22                 54
1673581 1673581 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington - Fox Hill   Regular School No Elementary KG 05 2021   grade_1 46 9 4 0   7     0   4   40 30 *                     70.0 46 9 4 0   7     0   4   40 30                 70
1673587 1673587 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Burlington - Memorial   Regular School No Elementary KG 05 2021   grade_1 36 4 5 0   13     0   3   23 38 *                     61.0 36 4 5 0   13     0   3   23 38                 61
1673593 1673593 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Burlington - Pine Glen Elementary   Regular School No Elementary KG 05 2021   grade_1 31 5 5 0   9     0   3   28 25 *                     53.0 31 5 5 0   9     0   3   28 25                 53
1673599 1673599 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington - Francis Wyman Elementary   Regular School No Elementary KG 05 2021   grade_1 51 6 7 0   19     0   2   46 38 *                     85.0 51 6 7 0   19     0   2   46 38                 85
1673614 1673614 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge - Maria L. Baldwin   Regular School No Elementary PK 05 2021   grade_1 34 4 3 0   7     0   2   24 26 *                     50.0 34 4 3 0   7     0   2   24 26                 50
1673621 1673621 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_1 21 3 15 0   2     0   5   20 26 *                     46.0 21 3 15 0   2     0   5   20 26                 46
1673631 1673631 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge - Cambridgeport   Regular School No Elementary PK 05 2021   grade_1 19 7 4 0   2     0   5   14 23 *                     37.0 19 7 4 0   2     0   5   14 23                 37
1673638 1673638 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Cambridge - Haggerty   Regular School No Elementary PK 05 2021   grade_1 18 4 1 0   8     0   1   20 12 *                     32.0 18 4 1 0   8     0   1   20 12                 32
1673645 1673645 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Cambridge - Martin Luther King Jr.   Regular School No Elementary PK 05 2021   grade_1 10 6 1 0   20     0   11   23 25 *                     48.0 10 6 1 0   20     0   11   23 25                 48
1673652 1673652 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 Cambridge - King Open   Alternative School No Elementary PK 05 2021   grade_1 22 17 5 0   6     0   7   25 32 *                     57.0 22 17 5 0   6     0   7   25 32                 57
1673659 1673659 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge - Kennedy-Longfellow   Regular School No Elementary PK 05 2021   grade_1 14 7 10 0   11     0   2   29 15 *                     44.0 14 7 10 0   11     0   2   29 15                 44
1673666 1673666 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Cambridge - Morse   Regular School No Elementary PK 05 2021   grade_1 14 6 6 0   7     0   2   19 16 *                     35.0 14 6 6 0   7     0   2   19 16                 35
1673673 1673673 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Cambridge - Peabody   Regular School No Elementary PK 05 2021   grade_1 31 6 1 0   5     0   2   21 24 *                     45.0 31 6 1 0   5     0   2   21 24                 45
1673680 1673680 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge - John M Tobin   Regular School No Elementary PK 05 2021   grade_1 16 11 2 0   9     0   2   25 15 *                     40.0 16 11 2 0   9     0   2   25 15                 40
1673687 1673687 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Cambridge - Graham and Parks   Alternative School No Elementary PK 05 2021   grade_1 29 7 4 0   9     0   2   23 28 *                     51.0 29 7 4 0   9     0   2   23 28                 51
1673694 1673694 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge - Fletcher/Maynard Academy   Regular School No Elementary PK 05 2021   grade_1 3 25 9 1   3     0   5   26 20 *                     46.0 3 25 9 1   3     0   5   26 20                 46
1673718 1673718 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Canton - Lt Peter M Hansen   Regular School No Elementary KG 05 2021   grade_1 64 4 4 0   5     0   10   45 42 *                     87.0 64 4 4 0   5     0   10   45 42                 87
1673724 1673724 MA Norfolk   school 2503300 50   Canton 250330000454 500017 Canton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_1 59 7 6 0   4     0   5   46 35 *                     81.0 59 7 6 0   4     0   5   46 35                 81
1673730 1673730 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton - Dean S Luce   Regular School No Elementary KG 05 2021   grade_1 45 6 4 0   10     0   8   30 43 *                     73.0 45 6 4 0   10     0   8   30 43                 73
1673745 1673745 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_1 39 1 4 0   6     0   1   16 35 *                     51.0 39 1 4 0   6     0   1   16 35                 51
1673755 1673755 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   grade_1 116 6 3 0   0     0   2   63 64 *                     127.0 116 6 3 0   0     0   2   63 64                 127
1673769 1673769 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford - Center Elementary School   Regular School No Elementary KG 04 2021   grade_1 59 1 6 0   13     0   5   42 42 *                     84.0 59 1 6 0   13     0   5   42 42                 84
1673774 1673774 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford - South Row   Regular School No Elementary KG 04 2021   grade_1 62 4 5 0   7     0   3   39 42 *                     81.0 62 4 5 0   7     0   3   39 42                 81
1673779 1673779 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_1 56 3 8 2   22     0   2   46 47 *                     93.0 56 3 8 2   22     0   2   46 47                 93
1673784 1673784 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford - Byam School   Regular School No Elementary KG 04 2021   grade_1 66 1 8 0   14     0   2   50 41 *                     91.0 66 1 8 0   14     0   2   50 41                 91
1673802 1673802 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   grade_1 4 1 96 0   0     0   2   53 50 *                     103.0 4 1 96 0   0     0   2   53 50                 103
1673803 1673803 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_1 3 7 83 0   0     0   1   41 53 *                     94.0 3 7 83 0   0     0   1   41 53                 94
1673807 1673807 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_1 6 8 84 1   0     0   1   63 37 *                     100.0 6 8 84 1   0     0   1   63 37                 100
1673811 1673811 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_1 3 1 90 0   0     0   0   46 48 *                     94.0 3 1 90 0   0     0   0   46 48                 94
1673817 1673817 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_1 11 4 84 0   0     0   0   45 54 *                     99.0 11 4 84 0   0     0   0   45 54                 99
1673843 1673843 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Chicopee - Barry   Regular School No Elementary KG 05 2021   grade_1 39 2 17 0   3     0   2   29 34 *                     63.0 39 2 17 0   3     0   2   29 34                 63
1673849 1673849 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee - Belcher   Regular School No Elementary KG 02 2021   grade_1 37 9 37 0   1     0   3   41 46 *                     87.0 37 9 37 0   1     0   3   41 46                 87
1673852 1673852 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Chicopee - Bowe   Regular School No Elementary KG 05 2021   grade_1 17 2 39 0   0     0   3   42 19 *                     61.0 17 2 39 0   0     0   3   42 19                 61
1673858 1673858 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Chicopee - Bowie   Regular School No Elementary KG 05 2021   grade_1 29 3 9 0   0     0   0   20 21 *                     41.0 29 3 9 0   0     0   0   20 21                 41
1673867 1673867 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee - Litwin   Regular School No Elementary KG 05 2021   grade_1 10 0 5 0   0     0   0   10 5 *                     15.0 10 0 5 0   0     0   0   10 5                 15
1673873 1673873 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Chicopee - Lambert-Lavoie   Regular School No Elementary KG 05 2021   grade_1 19 1 13 0   0     0   6   18 21 *                     39.0 19 1 13 0   0     0   6   18 21                 39
1673879 1673879 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Chicopee - Fairview Elementary   Regular School No Elementary KG 05 2021   grade_1 29 4 33 0   0     0   2   40 28 *                     68.0 29 4 33 0   0     0   2   40 28                 68

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