Data source: Big Local News · About: Big Local

975 rows where grade = "grade_3", state = "MA" and year = 2015 sorted by asian_int

View and edit SQL

year

  • 2015 · 975

grade

  • grade_3 · 975
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
736954 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_3 * * * *   *     *   *   2 1                       3                         2 1                 3
738076 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_3 * * * *   *     *   *   1 *                       2                         1                   2
738517 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_3 * * * *   *     *   *   2 2                       4                         2 2                 4
741454 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2015   grade_3 * * * *   *     *   *   1 3                       4                         1 3                 4
744284 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No 1 03 05 2015   grade_3 * * * *   *     *   *   1 1                       2                         1 1                 2
744703 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2015   grade_3 * * * *   *     *   *   2 1                       3                         2 1                 3
735677 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_3 103 1 1 0   0     0   0   58 47                       105 103 1 1 0   0     0   0   58 47                 105
735718 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   grade_3 76 2 6 0   0     0   2   35 51                       86 76 2 6 0   0     0   2   35 51                 86
735894 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No 1 KG 04 2015   grade_3 63 4 13 1   0     0   4   42 43                       85 63 4 13 1   0     0   4   42 43                 85
736068 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   grade_3 76 1 2 0   0     0   0   39 40                       79 76 1 2 0   0     0   0   39 40                 79
736084 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No 1 KG 05 2015   grade_3 34 3 9 0   0     0   2   30 18                       48 34 3 9 0   0     0   2   30 18                 48
736237 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No 1 PK 03 2015   grade_3 1 4 3 0   0     0   0   7 1                       8 1 4 3 0   0     0   0   7 1                 8
736254 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2015   grade_3 1 72 19 0   0     0   2   47 47                       94 1 72 19 0   0     0   2   47 47                 94
736261 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No 1 PK 05 2015   grade_3 6 0 42 0   0     0   0   33 15                       48 6 0 42 0   0     0   0   33 15                 48
736268 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 04 2015   grade_3 0 0 9 0   0     0   0   6 3                       9 0 0 9 0   0     0   0   6 3                 9
736274 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2015   grade_3 0 26 42 0   0     0   0   40 28                       68 0 26 42 0   0     0   0   40 28                 68
736294 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2015   grade_3 6 4 75 0   0     0   0   46 39                       85 6 4 75 0   0     0   0   46 39                 85
736327 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   grade_3 6 13 13 0   0     0   2   15 19                       34 6 13 13 0   0     0   2   15 19                 34
736357 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2015   grade_3 1 35 14 0   0     0   3   27 26                       53 1 35 14 0   0     0   3   27 26                 53
736385 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2015   grade_3 1 29 13 0   0     0   1   26 18                       44 1 29 13 0   0     0   1   26 18                 44
736392 MA Suffolk   school 2502790 35   Boston 250279000257 350156 James Otis   Regular School No 1 PK 05 2015   grade_3 3 1 55 0   0     0   0   31 28                       59 3 1 55 0   0     0   0   31 28                 59
736399 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No 1 PK 05 2015   grade_3 0 14 47 0   0     0   2   35 28                       63 0 14 47 0   0     0   2   35 28                 63
736413 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_3 4 6 13 0   0     0   2   10 15                       25 4 6 13 0   0     0   2   10 15                 25
736437 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_3 6 0 27 0   0     0   2   17 18                       35 6 0 27 0   0     0   2   17 18                 35
736457 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2015   grade_3 10 3 9 0   0     0   3   13 12                       25 10 3 9 0   0     0   3   13 12                 25
736488 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2015   grade_3 0 62 15 1   0     0   4   40 42                       82 0 62 15 1   0     0   4   40 42                 82
736535 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_3 1 27 19 1   0     0   0   24 24                       48 1 27 19 1   0     0   0   24 24                 48
736552 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_3 1 39 47 1   0     0   2   45 45                       90 1 39 47 1   0     0   2   45 45                 90
736568 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_3 26 4 29 0   0     0   2   34 27                       61 26 4 29 0   0     0   2   34 27                 61
736619 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No 1 PK 05 2015   grade_3 11 2 27 0   0     0   0   22 18                       40 11 2 27 0   0     0   0   22 18                 40
736626 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2015   grade_3 0 21 13 0   0     1   5   20 20                       40 0 21 13 0   0     1   5   20 20                 40
736633 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_3 1 14 36 0   0     0   0   29 22                       51 1 14 36 0   0     0   0   29 22                 51
736670 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_3 2 29 20 0   0     0   1   24 28                       52 2 29 20 0   0     0   1   24 28                 52
736675 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_3 1 5 6 0   0     0   0   10 2                       12 1 5 6 0   0     0   0   10 2                 12
736696 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_3 2 27 21 0   0     0   3   23 30                       53 2 27 21 0   0     0   3   23 30                 53
736731 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_3 0 44 22 0   0     0   3   36 33                       69 0 44 22 0   0     0   3   36 33                 69
736747 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_3 1 28 28 0   0     0   1   29 29                       58 1 28 28 0   0     0   1   29 29                 58
736757 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_3 1 8 16 0   0     0   1   13 13                       26 1 8 16 0   0     0   1   13 13                 26
736770 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2015   grade_3 3 22 72 0   0     0   1   43 55                       98 3 22 72 0   0     0   1   43 55                 98
736916 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_3 2 4 63 0   0     0   0   30 39                       69 2 4 63 0   0     0   0   30 39                 69
736944 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2015   grade_3 1 2 46 0   0     0   0   23 26                       49 1 2 46 0   0     0   0   23 26                 49
736968 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_3 66 0 3 1   0     0   2   40 32                       72 66 0 3 1   0     0   2   40 32                 72
737074 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_3 23 66 67 0   0     0   4   69 91                       160 23 66 67 0   0     0   4   69 91                 160
737110 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2015   grade_3 7 74 12 1   0     0   3   54 43                       97 7 74 12 1   0     0   3   54 43                 97
737181 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_3 39 0 1 0   0     0   1   24 17                       41 39 0 1 0   0     0   1   24 17                 41
737344 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_3 23 8 8 0   0     0   7   24 22                       46 23 8 8 0   0     0   7   24 22                 46
737446 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2015   grade_3 122 1 1 0   0     0   2   79 47                       126 122 1 1 0   0     0   2   79 47                 126
737498 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_3 7 5 98 1   0     0   0   62 49                       111 7 5 98 1   0     0   0   62 49                 111
737529 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_3 47 1 25 1   0     0   4   44 34                       78 47 1 25 1   0     0   4   44 34                 78
737539 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   grade_3 28 3 29 0   0     0   1   33 28                       61 28 3 29 0   0     0   1   33 28                 61
737545 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_3 38 2 16 0   0     0   4   29 31                       60 38 2 16 0   0     0   4   29 31                 60
737581 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_3 11 4 43 0   0     0   3   32 29                       61 11 4 43 0   0     0   3   32 29                 61
737603 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_3 16 0 0 0   0     0   0   8 8                       16 16 0 0 0   0     0   0   8 8                 16
737679 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No 1 KG 05 2015   grade_3 46 2 3 0   0     0   2   24 29                       53 46 2 3 0   0     0   2   24 29                 53
737686 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No 1 PK 05 2015   grade_3 30 2 1 0   0     0   1   14 20                       34 30 2 1 0   0     0   1   14 20                 34
737880 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2015   grade_3 19 0 2 0   0     0   1   8 14                       22 19 0 2 0   0     0   1   8 14                 22
737935 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_3 33 3 5 0   0     0   0   19 22                       41 33 3 5 0   0     0   0   19 22                 41
737945 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_3 18 0 1 0   0     0   2   12 9                       21 18 0 1 0   0     0   2   12 9                 21
738096 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2015   grade_3 40 1 5 0   0     0   4   24 26                       50 40 1 5 0   0     0   4   24 26                 50
738131 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_3 43 2 0 1   0     0   1   27 20                       47 43 2 0 1   0     0   1   27 20                 47
738137 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_3 51 3 6 1   0     0   4   36 29                       65 51 3 6 1   0     0   4   36 29                 65
738147 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_3 55 4 3 1   0     0   5   31 37                       68 55 4 3 1   0     0   5   31 37                 68
738207 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_3 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
738260 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_3 24 1 87 0   0     0   1   52 61                       113 24 1 87 0   0     0   1   52 61                 113
738396 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_3 42 1 1 0   0     0   1   20 25                       45 42 1 1 0   0     0   1   20 25                 45
738403 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_3 33 0 1 0   0     0   0   17 17                       34 33 0 1 0   0     0   0   17 17                 34
738409 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_3 43 1 1 0   0     0   0   21 24                       45 43 1 1 0   0     0   0   21 24                 45
738415 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_3 55 3 4 0   0     0   0   33 29                       62 55 3 4 0   0     0   0   33 29                 62
738472 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 03 2015   grade_3 55 0 4 0   0     0   0   34 25                       59 55 0 4 0   0     0   0   34 25                 59
738558 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_3 30 0 0 0   0     0   0   15 15                       30 30 0 0 0   0     0   0   15 15                 30
738625 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_3 23 2 27 0   0     0   0   27 25                       52 23 2 27 0   0     0   0   27 25                 52
738640 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_3 84 0 1 0   0     0   5   48 42                       90 84 0 1 0   0     0   5   48 42                 90
738658 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   grade_3 74 2 3 0   0     0   2   43 38                       81 74 2 3 0   0     0   2   43 38                 81
738688 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   grade_3 28 2 0 0   0     0   1   18 13                       31 28 2 0 0   0     0   1   18 13                 31
738712 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_3 24 0 25 0   0     0   0   25 24                       49 24 0 25 0   0     0   0   25 24                 49
738722 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_3 0 0 44 0   0     0   1   22 23                       45 0 0 44 0   0     0   1   22 23                 45
738736 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_3 3 1 74 0   0     0   0   41 37                       78 3 1 74 0   0     0   0   41 37                 78
738745 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_3 6 1 40 0   0     0   0   27 20                       47 6 1 40 0   0     0   0   27 20                 47
738754 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_3 11 6 46 0   0     0   1   31 33                       64 11 6 46 0   0     0   1   31 33                 64
738819 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   grade_3 65 1 4 0   0     0   3   33 40                       73 65 1 4 0   0     0   3   33 40                 73
738840 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   grade_3 62 0 0 0   0     1   0   32 31                       63 62 0 0 0   0     1   0   32 31                 63
738883 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_3 31 0 1 0   0     0   0   12 20                       32 31 0 1 0   0     0   0   12 20                 32
738900 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_3 3 1 117 0   0     0   0   62 59                       121 3 1 117 0   0     0   0   62 59                 121
738939 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_3 2 1 65 0   0     0   0   35 33                       68 2 1 65 0   0     0   0   35 33                 68
738944 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_3 6 0 101 0   0     0   0   62 45                       107 6 0 101 0   0     0   0   62 45                 107
738953 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2015   grade_3 10 0 108 0   0     0   2   55 65                       120 10 0 108 0   0     0   2   55 65                 120
738957 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_3 1 0 71 0   0     0   0   34 38                       72 1 0 71 0   0     0   0   34 38                 72
739011 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_3 1 0 9 0   0     0   0   8 2                       10 1 0 9 0   0     0   0   8 2                 10
739074 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_3 63 9 41 0   0     0   3   63 53                       116 63 9 41 0   0     0   3   63 53                 116
739116 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_3 14 0 2 0   0     0   2   12 6                       18 14 0 2 0   0     0   2   12 6                 18
739369 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No 1 02 03 2015   grade_3 146 2 13 0   0     0   4   88 77                       165 146 2 13 0   0     0   4   88 77                 165
739384 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2015   grade_3 116 1 8 1   0     0   2   67 61                       128 116 1 8 1   0     0   2   67 61                 128
739408 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   grade_3 18 6 23 0   0     0   4   27 24                       51 18 6 23 0   0     0   4   27 24                 51
739480 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_3 4 1 3 0   0     0   1   8 1                       9 4 1 3 0   0     0   1   8 1                 9
739550 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Summer Street   Regular School No 1 KG 04 2015   grade_3 79 0 5 0   0     0   1   40 45                       85 79 0 5 0   0     0   1   40 45                 85
739628 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No 1 KG 03 2015   grade_3 65 6 7 1   0     0   4   44 39                       83 65 6 7 1   0     0   4   44 39                 83
739685 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   grade_3 46 0 1 0   0     0   0   24 23                       47 46 0 1 0   0     0   0   24 23                 47
739691 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2015   grade_3 54 0 0 0   0     0   2   29 27                       56 54 0 0 0   0     0   2   29 27                 56
739698 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2015   grade_3 41 0 1 0   0     0   1   20 23                       43 41 0 1 0   0     0   1   20 23                 43
739704 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2015   grade_3 62 0 0 0   0     0   2   29 35                       64 62 0 0 0   0     0   2   29 35                 64

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