Data source: Big Local News · About: Big Local

956 rows where grade = "grade_4", state = "MA" and year = 2021 sorted by disability

View and edit SQL

year

  • 2021 · 856

grade

  • grade_4 · 856
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
1672958 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_4 6 1 21 1   0     0   0   16 13 *                     29.0 6 1 21 1   0     0   0   16 13                 29
1672966 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston - Samuel W Mason   Regular School No Elementary PK 05 2021   grade_4 2 17 13 0   0     0   3   19 16 *                     35.0 2 17 13 0   0     0   3   19 16                 35
1672973 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_4 0 6 31 0   0     0   1   17 21 *                     38.0 0 6 31 0   0     0   1   17 21                 38
1672983 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_4 4 3 31 0   1     0   1   16 23 *                     40.0 4 3 31 0   1     0   1   16 23                 40
1672993 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston - Thomas J Kenny   Regular School No Elementary PK 06 2021   grade_4 7 19 14 0   5     0   3   30 18 *                     48.0 7 19 14 0   5     0   3   30 18                 48
1673001 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_4 28 7 11 0   0     0   6   26 26 *                     52.0 28 7 11 0   0     0   6   26 26                 52
1673011 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_4 1 15 7 0   0     0   1   13 11 *                     24.0 1 15 7 0   0     0   1   13 11                 24
1673016 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_4 3 4 5 0   1     0   0   12 1 *                     13.0 3 4 5 0   1     0   0   12 1                 13
1673030 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston - William E Russell   Regular School No Elementary PK 05 2021   grade_4 0 12 30 0   1     1   2   26 20 *                     46.0 0 12 30 0   1     1   2   26 20                 46
1673037 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_4 0 26 14 0   0     1   1   17 25 *                     42.0 0 26 14 0   0     1   1   17 25                 42
1673047 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston - Winship Elementary   Regular School No Elementary PK 05 2021   grade_4 3 3 12 0   0     0   0   9 9 *                     18.0 3 3 12 0   0     0   0   9 9                 18
1673054 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_4 3 10 35 0   11     0   1   30 30 *                     60.0 3 10 35 0   11     0   1   30 30                 60
1673064 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_4 0 32 12 1   1     0   1   21 26 *                     47.0 0 32 12 1   1     0   1   21 26                 47
1673070 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_4 0 11 20 0   0     0   2   19 14 *                     33.0 0 11 20 0   0     0   2   19 14                 33
1673080 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_4 3 54 28 1   0     0   5   48 43 *                     91.0 3 54 28 1   0     0   5   48 43                 91
1673090 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_4 0 33 39 1   0     0   1   39 35 *                     74.0 0 33 39 1   0     0   1   39 35                 74
1673100 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_4 14 9 11 0   0     1   0   16 19 *                     35.0 14 9 11 0   0     1   0   16 19                 35
1673113 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Boston - Blackstone   Regular School No Elementary PK 05 2021   grade_4 3 17 64 0   2     0   1   49 38 *                     87.0 3 17 64 0   2     0   1   49 38                 87
1673117 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_4 12 27 15 1   9     0   4   38 30 *                     68.0 12 27 15 1   9     0   4   38 30                 68
1673252 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_4 5 0 55 0   1     0   1   34 28 *                     62.0 5 0 55 0   1     0   1   34 28                 62
1673273 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_4 5 0 42 0   0     0   0   15 32 *                     47.0 5 0 42 0   0     0   0   15 32                 47
1673281 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_4 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673298 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_4 115 3 4 1   2     0   3   59 69 *                     128.0 115 3 4 1   2     0   3   59 69                 128
1673313 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_4 83 0 2 0   5     0   9   51 48 *                     99.0 83 0 2 0   5     0   9   51 48                 99
1673320 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Braintree - Hollis   Regular School No Elementary KG 05 2021   grade_4 51 0 4 0   21     0   2   37 41 *                     78.0 51 0 4 0   21     0   2   37 41                 78
1673326 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Braintree - Highlands   Regular School No Elementary KG 05 2021   grade_4 58 0 2 0   18     0   1   34 45 *                     79.0 58 0 2 0   18     0   1   34 45                 79
1673332 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Braintree - Mary E Flaherty School   Regular School No Elementary KG 05 2021   grade_4 40 2 3 0   17     0   1   29 34 *                     63.0 40 2 3 0   17     0   1   29 34                 63
1673336 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_4 47 2 3 0   18     0   2   37 35 *                     72.0 47 2 3 0   18     0   2   37 35                 72
1673342 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Braintree - Archie T Morrison   Regular School No Elementary KG 05 2021   grade_4 39 8 2 1   16     0   2   39 29 *                     68.0 39 8 2 1   16     0   2   39 29                 68
1673347 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree - Donald Ross   Regular School No Elementary KG 05 2021   grade_4 29 5 3 0   15     0   1   32 21 *                     53.0 29 5 3 0   15     0   1   32 21                 53
1673365 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_4 68 4 4 0   0     0   4   38 42 *                     80.0 68 4 4 0   0     0   4   38 42                 80
1673372 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_4 36 1 1 0   2     0   0   18 22 *                     40.0 36 1 1 0   2     0   0   18 22                 40
1673380 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   grade_4 14 82 20 1   0     0   10   75 52 *                     127.0 14 82 20 1   0     0   10   75 52                 127
1673386 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton - Mary E. Baker School   Regular School No Elementary KG 05 2021   grade_4 27 46 19 0   0     0   3   53 42 *                     95.0 27 46 19 0   0     0   3   53 42                 95
1673392 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton - Manthala George Jr. School   Regular School No Elementary KG 05 2021   grade_4 13 60 76 1   2     0   3   77 78 *                     155.0 13 60 76 1   2     0   3   77 78                 155
1673400 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton - Brookfield   Regular School No Elementary KG 05 2021   grade_4 16 54 10 0   2     0   5   42 45 *                     87.0 16 54 10 0   2     0   5   42 45                 87
1673406 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_4 19 47 10 0   4     0   7   45 42 *                     87.0 19 47 10 0   4     0   7   45 42                 87
1673412 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_4 10 86 17 0   0     0   6   60 59 *                     119.0 10 86 17 0   0     0   6   60 59                 119
1673421 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton - Hancock   Regular School No Elementary KG 05 2021   grade_4 23 46 13 0   0     0   7   43 46 *                     89.0 23 46 13 0   0     0   7   43 46                 89
1673427 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton - Gilmore Elementary School   Regular School No Elementary KG 05 2021   grade_4 2 72 11 1   0     0   4   45 45 *                     90.0 2 72 11 1   0     0   4   45 45                 90
1673433 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_4 53 98 27 1   7     0   4   96 94 *                     190.0 53 98 27 1   7     0   4   96 94                 190
1673439 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_4 6 124 15 0   3     0   4   81 71 *                     152.0 6 124 15 0   3     0   4   81 71                 152
1673448 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_4 17 58 17 1   1     1   8   60 43 *                     103.0 17 58 17 1   1     1   8   60 43                 103
1673450 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_4 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1673493 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_4 31 0 2 0   0     0   2   20 15 *                     35.0 31 0 2 0   0     0   2   20 15                 35
1673503 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_4 21 4 11 0   28     0   8   37 35 *                     72.0 21 4 11 0   28     0   8   37 35                 72
1673513 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_4 52 2 10 0   18     0   9   43 48 *                     91.0 52 2 10 0   18     0   9   43 48                 91
1673522 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_4 35 3 3 0   5     0   9   27 28 *                     55.0 35 3 3 0   5     0   9   27 28                 55
1673532 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_4 19 8 1 0   10     0   4   23 19 *                     42.0 19 8 1 0   10     0   4   23 19                 42
1673541 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_4 25 3 5 0   24     0   2   33 26 *                     59.0 25 3 5 0   24     0   2   33 26                 59
1673550 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_4 23 9 3 0   11     0   7   29 24 *                     53.0 23 9 3 0   11     0   7   29 24                 53
1673559 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_4 34 4 12 0   11     0   11   36 36 *                     72.0 34 4 12 0   11     0   11   36 36                 72
1673569 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_4 22 3 3 0   15     0   8   30 21 *                     51.0 22 3 3 0   15     0   8   30 21                 51
1673584 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington - Fox Hill   Regular School No Elementary KG 05 2021   grade_4 50 10 4 0   12     0   1   41 36 *                     77.0 50 10 4 0   12     0   1   41 36                 77
1673590 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Burlington - Memorial   Regular School No Elementary KG 05 2021   grade_4 40 5 7 0   24     0   1   38 39 *                     77.0 40 5 7 0   24     0   1   38 39                 77
1673596 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Burlington - Pine Glen Elementary   Regular School No Elementary KG 05 2021   grade_4 32 3 7 0   15     0   9   36 30 *                     66.0 32 3 7 0   15     0   9   36 30                 66
1673602 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington - Francis Wyman Elementary   Regular School No Elementary KG 05 2021   grade_4 55 7 7 0   5     0   3   41 36 *                     77.0 55 7 7 0   5     0   3   41 36                 77
1673617 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge - Maria L. Baldwin   Regular School No Elementary PK 05 2021   grade_4 32 6 4 0   4     0   2   23 25 *                     48.0 32 6 4 0   4     0   2   23 25                 48
1673624 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_4 18 4 18 0   0     0   3   19 24 *                     43.0 18 4 18 0   0     0   3   19 24                 43
1673634 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge - Cambridgeport   Regular School No Elementary PK 05 2021   grade_4 16 9 5 0   3     0   6   24 15 *                     39.0 16 9 5 0   3     0   6   24 15                 39
1673641 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Cambridge - Haggerty   Regular School No Elementary PK 05 2021   grade_4 18 7 1 0   3     0   6   18 17 *                     35.0 18 7 1 0   3     0   6   18 17                 35
1673648 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Cambridge - Martin Luther King Jr.   Regular School No Elementary PK 05 2021   grade_4 10 14 3 0   7     0   7   24 17 *                     41.0 10 14 3 0   7     0   7   24 17                 41
1673655 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 Cambridge - King Open   Alternative School No Elementary PK 05 2021   grade_4 14 12 5 0   5     0   6   19 23 *                     42.0 14 12 5 0   5     0   6   19 23                 42
1673662 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge - Kennedy-Longfellow   Regular School No Elementary PK 05 2021   grade_4 10 8 5 0   1     0   4   18 10 *                     28.0 10 8 5 0   1     0   4   18 10                 28
1673669 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Cambridge - Morse   Regular School No Elementary PK 05 2021   grade_4 16 10 3 0   7     0   2   23 15 *                     38.0 16 10 3 0   7     0   2   23 15                 38
1673676 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Cambridge - Peabody   Regular School No Elementary PK 05 2021   grade_4 26 10 0 0   5     0   3   27 17 *                     44.0 26 10 0 0   5     0   3   27 17                 44
1673683 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge - John M Tobin   Regular School No Elementary PK 05 2021   grade_4 14 3 2 0   10     0   4   22 11 *                     33.0 14 3 2 0   10     0   4   22 11                 33
1673690 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Cambridge - Graham and Parks   Alternative School No Elementary PK 05 2021   grade_4 26 11 4 0   9     0   5   30 25 *                     55.0 26 11 4 0   9     0   5   30 25                 55
1673697 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge - Fletcher/Maynard Academy   Regular School No Elementary PK 05 2021   grade_4 7 19 4 0   2     0   3   12 23 *                     35.0 7 19 4 0   2     0   3   12 23                 35
1673721 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Canton - Lt Peter M Hansen   Regular School No Elementary KG 05 2021   grade_4 46 17 8 0   8     0   7   41 45 *                     86.0 46 17 8 0   8     0   7   41 45                 86
1673727 MA Norfolk   school 2503300 50   Canton 250330000454 500017 Canton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_4 54 7 3 0   8     0   5   41 36 *                     77.0 54 7 3 0   8     0   5   41 36                 77
1673733 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton - Dean S Luce   Regular School No Elementary KG 05 2021   grade_4 63 10 5 0   11     0   4   48 45 *                     93.0 63 10 5 0   11     0   4   48 45                 93
1673748 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_4 47 0 7 0   9     0   5   39 29 *                     68.0 47 0 7 0   9     0   5   39 29                 68
1673758 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   grade_4 133 3 1 0   0     0   2   66 73 *                     139.0 133 3 1 0   0     0   2   66 73                 139
1673772 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford - Center Elementary School   Regular School No Elementary KG 04 2021   grade_4 67 3 8 0   15     0   3   50 46 *                     96.0 67 3 8 0   15     0   3   50 46                 96
1673777 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford - South Row   Regular School No Elementary KG 04 2021   grade_4 54 2 4 1   12     0   4   45 32 *                     77.0 54 2 4 1   12     0   4   45 32                 77
1673782 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_4 67 7 12 0   18     0   4   56 52 *                     108.0 67 7 12 0   18     0   4   56 52                 108
1673787 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford - Byam School   Regular School No Elementary KG 04 2021   grade_4 69 6 6 0   9     0   2   43 49 *                     92.0 69 6 6 0   9     0   2   43 49                 92
1673806 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_4 6 8 112 0   0     0   0   69 57 *                     126.0 6 8 112 0   0     0   0   69 57                 126
1673810 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_4 16 7 117 2   0     0   0   71 71 *                     142.0 16 7 117 2   0     0   0   71 71                 142
1673814 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_4 2 6 90 0   0     0   0   47 51 *                     98.0 2 6 90 0   0     0   0   47 51                 98
1673820 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_4 6 4 126 0   0     0   1   81 56 *                     137.0 6 4 126 0   0     0   1   81 56                 137
1673846 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Chicopee - Barry   Regular School No Elementary KG 05 2021   grade_4 42 4 24 0   0     0   1   45 26 *                     71.0 42 4 24 0   0     0   1   45 26                 71
1673855 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Chicopee - Bowe   Regular School No Elementary KG 05 2021   grade_4 30 2 48 0   2     0   4   39 47 *                     86.0 30 2 48 0   2     0   4   39 47                 86
1673861 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Chicopee - Bowie   Regular School No Elementary KG 05 2021   grade_4 38 3 12 0   0     0   0   26 27 *                     53.0 38 3 12 0   0     0   0   26 27                 53
1673870 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee - Litwin   Regular School No Elementary KG 05 2021   grade_4 58 12 48 0   1     0   2   57 64 *                     121.0 58 12 48 0   1     0   2   57 64                 121
1673876 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Chicopee - Lambert-Lavoie   Regular School No Elementary KG 05 2021   grade_4 33 2 10 0   1     0   3   31 18 *                     49.0 33 2 10 0   1     0   3   31 18                 49
1673882 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Chicopee - Fairview Elementary   Regular School No Elementary KG 05 2021   grade_4 22 1 35 0   1     0   1   37 23 *                     60.0 22 1 35 0   1     0   1   37 23                 60
1673888 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee - Streiber Memorial School   Regular School No Elementary KG 05 2021   grade_4 31 1 10 0   2     1   4   18 31 *                     49.0 31 1 10 0   2     1   4   18 31                 49
1673894 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Chicopee - Gen John J Stefanik   Regular School No Elementary KG 05 2021   grade_4 20 8 34 0   0     0   1   34 29 *                     63.0 20 8 34 0   0     0   1   34 29                 63
1673914 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_4 13 0 0 0   0     0   0   6 7 *                     13.0 13 0 0 0   0     0   0   6 7                 13
1673924 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton - Clinton Elementary   Regular School No Elementary PK 04 2021   grade_4 92 3 46 0   1     0   7   76 73 *                     149.0 92 3 46 0   1     0   7   76 73                 149
1673935 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Cohasset - Deer Hill   Regular School No Elementary 03 05 2021   grade_4 105 2 1 0   2     0   4   60 54 *                     114.0 105 2 1 0   2     0   4   60 54                 114
1673953 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Concord - Alcott   Regular School No Elementary PK 05 2021   grade_4 44 4 5 0   9     0   3   35 30 *                     65.0 44 4 5 0   9     0   3   35 30                 65
1673960 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Concord - Thoreau   Regular School No Elementary PK 05 2021   grade_4 58 0 6 0   4     0   5   37 36 *                     73.0 58 0 6 0   4     0   5   37 36                 73
1673967 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Concord - Willard   Regular School No Elementary PK 05 2021   grade_4 57 1 2 0   7     0   4   37 34 *                     71.0 57 1 2 0   7     0   4   37 34                 71
1673977 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_4 17 0 2 0   0     0   0   13 6 *                     19.0 17 0 2 0   0     0   0   13 6                 19
1673984 MA Essex   school 2503990 71   Danvers 250399000532 710010 Danvers - Highlands   Regular School No Elementary KG 05 2021   grade_4 46 3 4 0   3     0   3   27 32 *                     59.0 46 3 4 0   3     0   3   27 32                 59
1673990 MA Essex   school 2503990 71   Danvers 250399000531 710015 Danvers - Great Oak   Regular School No Elementary KG 05 2021   grade_4 49 3 3 0   1     0   3   28 31 *                     59.0 49 3 3 0   1     0   3   28 31                 59
1673997 MA Essex   school 2503990 71   Danvers 250399000536 710030 Danvers - Riverside   Regular School No Elementary PK 05 2021   grade_4 30 0 6 1   2     0   1   21 19 *                     40.0 30 0 6 1   2     0   1   21 19                 40

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