Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by ccd_school_low_grade descending

View and edit SQL

year

grade

  • grade_6 · 4,038
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
1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1675704 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
735742 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_6 32 6 12 0   5     1   6   33 29                       62 32 6 12 0   5     1   6   33 29                 62
735943 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2015   grade_6 33 18 2 1   3     0   2   32 27                       59 33 18 2 1   3     0   2   32 27                 59
736204 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2015   grade_6 14 14 14 1   0     0   4   28 19                       47 14 14 14 1   0     0   4   28 19                 47
736214 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2015   grade_6 14 28 35 0   11     1   2   50 41                       91 14 28 35 0   11     1   2   50 41                 91
736230 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2015   grade_6 10 23 58 1   2     0   3   44 53                       97 10 23 58 1   2     0   3   44 53                 97
736289 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 07 2015   grade_6 12 12 17 0   0     0   3   24 20                       44 12 12 17 0   0     0   3   24 20                 44
736320 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_6 16 7 10 0   5     0   1   26 13                       39 16 7 10 0   5     0   1   26 13                 39
736337 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   grade_6 12 15 20 0   0     0   0   24 23                       47 12 15 20 0   0     0   0   24 23                 47
736440 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_6 5 0 25 0   0     0   0   12 18                       30 5 0 25 0   0     0   0   12 18                 30
736450 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2015   grade_6 4 45 33 1   8     0   1   55 37                       92 4 45 33 1   8     0   1   55 37                 92
736467 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_6 39 2 6 2   5     0   3   28 29                       57 39 2 6 2   5     0   3   28 29                 57
736505 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_6 0 7 34 0   1     0   0   24 18                       42 0 7 34 0   1     0   0   24 18                 42
736528 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_6 29 29 21 0   55     1   7   83 59                       142 29 29 21 0   55     1   7   83 59                 142
736545 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_6 16 1 4 0   1     1   2   19 6                       25 16 1 4 0   1     1   2   19 6                 25
736555 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_6 1 31 43 0   1     0   1   41 36                       77 1 31 43 0   1     0   1   41 36                 77
736571 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_6 20 10 33 1   1     0   0   33 32                       65 20 10 33 1   1     0   0   33 32                 65
736636 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_6 0 12 30 0   0     0   0   21 21                       42 0 12 30 0   0     0   0   21 21                 42
736646 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   grade_6 6 8 25 0   4     0   1   31 13                       44 6 8 25 0   4     0   1   31 13                 44
736663 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_6 28 11 13 1   2     0   1   35 21                       56 28 11 13 1   2     0   1   35 21                 56
736699 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_6 1 34 16 0   0     0   0   22 29                       51 1 34 16 0   0     0   0   22 29                 51
736714 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_6 21 20 38 1   26     0   3   56 53                       109 21 20 38 1   26     0   3   56 53                 109
736724 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_6 1 20 13 0   1     0   5   20 20                       40 1 20 13 0   1     0   5   20 20                 40
736734 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_6 0 15 9 0   2     0   0   13 13                       26 0 15 9 0   2     0   0   13 13                 26
736750 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_6 2 22 27 0   0     0   1   34 18                       52 2 22 27 0   0     0   1   34 18                 52
736760 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_6 4 4 10 0   0     0   0   13 5                       18 4 4 10 0   0     0   0   13 5                 18
736947 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2015   grade_6 4 1 34 0   0     0   0   19 20                       39 4 1 34 0   0     0   0   19 20                 39
736957 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
737058 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2015   grade_6 33 0 1 0   1     0   0   19 16                       35 33 0 1 0   1     0   0   19 16                 35
737184 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 39 1 2 0   0     0   1   18 25                       43 39 1 2 0   0     0   1   18 25                 43
737212 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   grade_6 36 2 3 0   10     0   6   27 30                       57 36 2 3 0   10     0   6   27 30                 57
737222 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2015   grade_6 40 1 4 0   9     0   1   23 32                       55 40 1 4 0   9     0   1   23 32                 55
737259 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2015   grade_6 30 2 6 0   11     0   6   27 28                       55 30 2 6 0   11     0   6   27 28                 55
737316 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   grade_6 10 2 9 0   0     0   4   7 18                       25 10 2 9 0   0     0   4   7 18                 25
737439 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_6 59 1 0 0   7     0   5   39 33                       72 59 1 0 0   7     0   5   39 33                 72
737669 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   grade_6 24 0 2 0   0     0   0   13 13                       26 24 0 2 0   0     0   0   13 13                 26
737773 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2015   grade_6 64 0 1 1   0     0   2   35 33                       68 64 0 1 1   0     0   2   35 33                 68
737938 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_6 34 1 2 2   0     0   0   17 22                       39 34 1 2 2   0     0   0   17 22                 39
737948 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   1   6 8                       14 12 0 1 0   0     0   1   6 8                 14
738065 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 06 2015   grade_6 40 7 16 0   6     0   5   31 43                       74 40 7 16 0   6     0   5   31 43                 74
738073 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_6 29 2 21 0   3     0   4   32 27                       59 29 2 21 0   3     0   4   32 27                 59
738190 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_6 38 6 41 0   3     0   6   43 51                       94 38 6 41 0   3     0   6   43 51                 94
738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738498 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_6 44 0 3 0   0     0   2   24 25                       49 44 0 3 0   0     0   2   24 25                 49
738519 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
738561 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   0     0   0   24 10                       34 34 0 0 0   0     0   0   24 10                 34
738691 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   grade_6 32 1 0 0   1     0   1   21 14                       35 32 1 0 0   1     0   1   21 14                 35
738725 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_6 1 2 40 0   0     0   0   21 22                       43 1 2 40 0   0     0   0   21 22                 43
738886 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   1     0   2   14 23                       37 34 0 0 0   1     0   2   14 23                 37
739033 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_6 54 0 3 0   1     0   0   25 33                       58 54 0 3 0   1     0   0   25 33                 58
739119 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_6 15 0 0 0   0     0   2   7 10                       17 15 0 0 0   0     0   2   7 10                 17
739179 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_6 41 6 7 0   8     0   4   26 40                       66 41 6 7 0   8     0   4   26 40                 66
739259 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2015   grade_6 35 10 10 0   10     0   2   29 38                       67 35 10 10 0   10     0   2   29 38                 67
739328 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2015   grade_6 13 5 21 0   15     0   4   37 21                       58 13 5 21 0   15     0   4   37 21                 58
739656 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2015   grade_6 57 4 0 0   2     0   2   24 41                       65 57 4 0 0   2     0   2   24 41                 65
739877 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_6 113 4 29 0   5     0   2   76 77                       153 113 4 29 0   5     0   2   76 77                 153
739887 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2015   grade_6 84 2 44 0   7     0   1   68 70                       138 84 2 44 0   7     0   1   68 70                 138
739897 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2015   grade_6 68 8 51 0   12     0   0   76 63                       139 68 8 51 0   12     0   0   76 63                 139
739907 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2015   grade_6 73 5 67 1   3     0   3   85 67                       152 73 5 67 1   3     0   3   85 67                 152
740046 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_6 26 0 1 0   4     0   0   20 11                       31 26 0 1 0   4     0   0   20 11                 31
740450 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_6 38 2 2 0   0     1   3   23 23                       46 38 2 2 0   0     1   3   23 23                 46
740622 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 31 0 3 0   0     0   5   19 20                       39 31 0 3 0   0     0   5   19 20                 39
740736 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_6 40 3 8 1   1     0   3   28 28                       56 40 3 8 1   1     0   3   28 28                 56
740875 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   grade_6 85 0 1 0   1     0   1   48 40                       88 85 0 1 0   1     0   1   48 40                 88
741042 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_6 9 0 3 0   0     0   3   9 6                       15 9 0 3 0   0     0   3   9 6                 15
741275 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_6 8 1 1 0   0     0   0   1 9                       10 8 1 1 0   0     0   0   1 9                 10
741285 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2015   grade_6 83 2 0 0   0     0   4   42 47                       89 83 2 0 0   0     0   4   42 47                 89
741329 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 0 0   0     0   0   4 10                       14 14 0 0 0   0     0   0   4 10                 14
741396 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   grade_6 62 1 0 0   5     0   0   39 29                       68 62 1 0 0   5     0   0   39 29                 68
741485 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2015   grade_6 64 1 0 0   0     0   1   36 30                       66 64 1 0 0   0     0   1   36 30                 66
741584 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 4 0   0     0   2   13 13                       26 20 0 4 0   0     0   2   13 13                 26
741623 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   grade_6 14 7 28 0   6     0   2   27 30                       57 14 7 28 0   6     0   2   27 30                 57
741633 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2015   grade_6 19 8 8 0   1     0   1   24 13                       37 19 8 8 0   1     0   1   24 13                 37
741643 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   grade_6 22 3 18 0   3     0   0   23 23                       46 22 3 18 0   3     0   0   23 23                 46
741662 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2015   grade_6 15 5 9 0   1     0   2   15 17                       32 15 5 9 0   1     0   2   15 17                 32
741672 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2015   grade_6 16 5 27 0   5     0   0   29 24                       53 16 5 27 0   5     0   0   29 24                 53
741694 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No 1 PK 06 2015   grade_6 69 2 3 0   1     0   1   37 39                       76 69 2 3 0   1     0   1   37 39                 76
741849 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_6 7 9 6 0   1     0   3   13 13                       26 7 9 6 0   1     0   3   13 13                 26
742107 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_6 121 0 7 0   1     0   2   63 68                       131 121 0 7 0   1     0   2   63 68                 131
742143 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_6 22 0 2 0   3     0   1   13 15                       28 22 0 2 0   3     0   1   13 15                 28
742285 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   grade_6 26 1 6 1   1     0   3   17 21                       38 26 1 6 1   1     0   3   17 21                 38
742369 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   5 16                       21 20 0 1 0   0     0   0   5 16                 21
742764 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2015   grade_6 23 0 0 0   0     0   0   9 14                       23 23 0 0 0   0     0   0   9 14                 23
742933 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 1 0   0     0   0   7 8                       15 14 0 1 0   0     0   0   7 8                 15
742941 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_6 25 0 3 1   1     0   0   14 16                       30 25 0 3 1   1     0   0   14 16                 30
742949 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2015   grade_6 48 1 6 0   3     0   7   37 28                       65 48 1 6 0   3     0   7   37 28                 65
743107 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_6 4 9 17 0   5     0   1   21 15                       36 4 9 17 0   5     0   1   21 15                 36
743122 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_6 3 6 43 0   6     0   0   38 20                       58 3 6 43 0   6     0   0   38 20                 58
743137 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   grade_6 10 8 22 0   5     0   1   27 19                       46 10 8 22 0   5     0   1   27 19                 46
743152 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_6 3 0 50 0   5     0   1   32 27                       59 3 0 50 0   5     0   1   32 27                 59
743160 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   grade_6 19 9 32 0   2     0   3   34 31                       65 19 9 32 0   2     0   3   34 31                 65
743168 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   grade_6 12 2 20 0   1     0   2   17 20                       37 12 2 20 0   1     0   2   17 20                 37
743176 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_6 8 5 20 0   4     0   0   24 13                       37 8 5 20 0   4     0   0   24 13                 37
743191 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2015   grade_6 22 8 30 0   4     0   4   40 28                       68 22 8 30 0   4     0   4   40 28                 68
743199 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   grade_6 7 9 47 0   10     0   3   42 34                       76 7 9 47 0   10     0   3   42 34                 76
743207 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_6 20 14 21 0   12     0   4   52 19                       71 20 14 21 0   12     0   4   52 19                 71
743215 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2015   grade_6 11 4 15 0   3     0   2   21 14                       35 11 4 15 0   3     0   2   21 14                 35
743230 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   grade_6 8 8 19 0   1     0   3   23 16                       39 8 8 19 0   1     0   3   23 16                 39

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