enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by non_binary_int

✎ View and edit SQL

This data as json, CSV (advanced)

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
1364884 1364884 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_6 32 6 8 0   5     0   6   29 28 *                     57.0 32 6 8 0   5     0   6   29 28                 57
1364885 1364885 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   kindergarten 64 2 5 0   7     0   3   43 38 *                     81.0 64 2 5 0   7     0   3   43 38                 81
1364886 1364886 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_1 64 0 11 0   6     0   12   47 46 *                     93.0 64 0 11 0   6     0   12   47 46                 93
1364887 1364887 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_2 84 2 2 0   7     0   2   51 46 *                     97.0 84 2 2 0   7     0   2   51 46                 97
1364888 1364888 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_3 67 1 6 0   9     0   7   54 36 *                     90.0 67 1 6 0   9     0   7   54 36                 90
1364889 1364889 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_4 79 2 7 0   8     0   6   58 44 *                     102.0 79 2 7 0   8     0   6   58 44                 102
1364890 1364890 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_5 76 3 7 0   12     0   5   53 50 *                     103.0 76 3 7 0   12     0   5   53 50                 103
1364891 1364891 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   kindergarten 39 3 5 0   16     1   5   38 31 *                     69.0 39 3 5 0   16     1   5   38 31                 69
1364892 1364892 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_1 49 5 10 0   36     0   6   56 50 *                     106.0 49 5 10 0   36     0   6   56 50                 106
1364893 1364893 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_2 40 4 7 0   30     0   3   57 27 *                     84.0 40 4 7 0   30     0   3   57 27                 84
1364894 1364894 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_3 49 4 4 0   22     0   6   39 46 *                     85.0 49 4 4 0   22     0   6   39 46                 85
1364895 1364895 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_4 47 5 4 0   28     0   3   48 39 *                     87.0 47 5 4 0   28     0   3   48 39                 87
1364896 1364896 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2020   grade_5 47 3 11 0   29     0   6   52 44 *                     96.0 47 3 11 0   29     0   6   52 44                 96
1364897 1364897 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 44 0 10 0   20     0   7   59 22 *                     81.0 44 0 10 0   20     0   7   59 22                 81
1364898 1364898 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   kindergarten 29 0 1 0   7     0   4   24 17 *                     41.0 29 0 1 0   7     0   4   24 17                 41
1364899 1364899 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_1 36 0 5 0   12     0   1   27 27 *                     54.0 36 0 5 0   12     0   1   27 27                 54
1364900 1364900 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_2 36 2 4 0   11     0   1   23 31 *                     54.0 36 2 4 0   11     0   1   23 31                 54
1364901 1364901 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_3 34 2 7 0   16     0   2   30 31 *                     61.0 34 2 7 0   16     0   2   30 31                 61
1364902 1364902 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_4 52 1 0 0   19     0   2   38 36 *                     74.0 52 1 0 0   19     0   2   38 36                 74
1364903 1364903 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No Elementary KG 05 2020   grade_5 46 4 5 0   18     0   1   38 36 *                     74.0 46 4 5 0   18     0   1   38 36                 74
1364904 1364904 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   kindergarten 50 1 3 0   8     0   4   39 27 *                     66.0 50 1 3 0   8     0   4   39 27                 66
1364905 1364905 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_1 60 1 4 0   18     0   5   43 45 *                     88.0 60 1 4 0   18     0   5   43 45                 88
1364906 1364906 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_2 55 1 2 0   17     0   3   40 38 *                     78.0 55 1 2 0   17     0   3   40 38                 78
1364907 1364907 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_3 70 0 2 0   9     0   0   43 38 *                     81.0 70 0 2 0   9     0   0   43 38                 81
1364908 1364908 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_4 67 1 6 1   16     0   2   40 53 *                     93.0 67 1 6 1   16     0   2   40 53                 93
1364909 1364909 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_5 50 1 4 0   18     0   0   41 32 *                     73.0 50 1 4 0   18     0   0   41 32                 73
1364910 1364910 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   kindergarten 56 4 5 0   13     0   5   53 30 *                     83.0 56 4 5 0   13     0   5   53 30                 83
1364911 1364911 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_1 69 5 11 0   12     0   5   51 51 *                     102.0 69 5 11 0   12     0   5   51 51                 102
1364912 1364912 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_2 61 2 5 0   18     0   0   44 42 *                     86.0 61 2 5 0   18     0   0   44 42                 86
1364913 1364913 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_3 80 2 7 0   15     0   1   52 53 *                     105.0 80 2 7 0   15     0   1   52 53                 105
1364914 1364914 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_4 70 2 8 0   21     0   1   49 53 *                     102.0 70 2 8 0   21     0   1   49 53                 102
1364915 1364915 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2020   grade_5 85 1 10 0   15     0   5   56 60 *                     116.0 85 1 10 0   15     0   5   56 60                 116
1364916 1364916 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_6 121 3 13 0   14     0   7   74 84 *                     158.0 121 3 13 0   14     0   7   74 84                 158
1364917 1364917 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_7 139 2 13 1   19     1   4   92 87 *                     179.0 139 2 13 1   19     1   4   92 87                 179
1364918 1364918 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_8 141 4 14 0   17     0   5   77 104 *                     181.0 141 4 14 0   17     0   5   77 104                 181
1364919 1364919 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_6 120 10 12 0   39     0   3   94 90 *                     184.0 120 10 12 0   39     0   3   94 90                 184
1364920 1364920 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_7 124 5 11 0   28     0   8   97 79 *                     176.0 124 5 11 0   28     0   8   97 79                 176
1364921 1364921 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_8 121 10 10 0   28     0   3   86 86 *                     172.0 121 10 10 0   28     0   3   86 86                 172
1364922 1364922 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_6 69 3 9 0   37     1   6   56 69 *                     125.0 69 3 9 0   37     1   6   56 69                 125
1364923 1364923 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_7 61 3 13 1   53     0   2   73 60 *                     133.0 61 3 13 1   53     0   2   73 60                 133
1364924 1364924 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_8 79 4 14 0   46     0   5   81 67 *                     148.0 79 4 14 0   46     0   5   81 67                 148
1364925 1364925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_9 321 8 27 3   84     0   12   208 247 *                     455.0 321 8 27 3   84     0   12   208 247                 455
1364926 1364926 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_10 291 10 33 2   84     0   7   203 224 *                     427.0 291 10 33 2   84     0   7   203 224                 427
1364927 1364927 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_11 313 8 25 0   99     0   10   202 252 *                     455.0 313 8 25 0   99     0   10   202 252                 455
1364928 1364928 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_12 314 10 23 0   67     0   10   210 214 *                     424.0 314 10 23 0   67     0   10   210 214                 424
1364929 1364929 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   sped_beyond_grade_12 27 1 5 0   1     0   0   25 9 *                     34.0 27 1 5 0   1     0   0   25 9                 34
1364930 1364930 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   kindergarten 44 3 3 0   8     0   13   35 36 *                     71.0 44 3 3 0   8     0   13   35 36                 71
1364931 1364931 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_1 61 1 7 0   14     0   10   50 43 *                     93.0 61 1 7 0   14     0   10   50 43                 93
1364932 1364932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_2 40 4 0 0   16     0   7   39 28 *                     67.0 40 4 0 0   16     0   7   39 28                 67
1364933 1364933 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_3 53 3 2 0   11     0   1   41 29 *                     70.0 53 3 2 0   11     0   1   41 29                 70
1364934 1364934 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_4 46 0 2 0   14     2   6   33 37 *                     70.0 46 0 2 0   14     2   6   33 37                 70
1364935 1364935 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_5 51 2 1 0   10     0   5   41 28 *                     69.0 51 2 1 0   10     0   5   41 28                 69
1364936 1364936 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   kindergarten 59 1 5 0   13     0   9   51 36 *                     87.0 59 1 5 0   13     0   9   51 36                 87
1364937 1364937 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_1 82 0 4 0   7     0   13   59 47 *                     106.0 82 0 4 0   7     0   13   59 47                 106
1364938 1364938 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_2 62 1 1 0   9     0   9   43 39 *                     82.0 62 1 1 0   9     0   9   43 39                 82
1364939 1364939 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_3 67 3 3 0   15     0   5   52 41 *                     93.0 67 3 3 0   15     0   5   52 41                 93
1364940 1364940 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_4 55 0 3 0   5     0   4   31 36 *                     67.0 55 0 3 0   5     0   4   31 36                 67
1364941 1364941 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_5 71 2 8 0   9     1   9   55 45 *                     100.0 71 2 8 0   9     1   9   55 45                 100
1364942 1364942 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   kindergarten 47 0 4 0   10     0   9   28 42 *                     70.0 47 0 4 0   10     0   9   28 42                 70
1364943 1364943 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_1 59 3 5 0   11     0   9   45 42 *                     87.0 59 3 5 0   11     0   9   45 42                 87
1364944 1364944 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_2 60 1 3 0   7     0   4   41 34 *                     75.0 60 1 3 0   7     0   4   41 34                 75
1364945 1364945 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_3 66 1 0 0   19     0   1   49 38 *                     87.0 66 1 0 0   19     0   1   49 38                 87
1364946 1364946 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_4 60 1 2 0   8     0   1   35 37 *                     72.0 60 1 2 0   8     0   1   35 37                 72
1364947 1364947 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2020   grade_5 60 1 4 0   10     0   6   42 39 *                     81.0 60 1 4 0   10     0   6   42 39                 81
1364948 1364948 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   kindergarten 47 0 4 0   11     0   6   34 34 *                     68.0 47 0 4 0   11     0   6   34 34                 68
1364949 1364949 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_1 54 2 2 0   11     0   6   41 34 *                     75.0 54 2 2 0   11     0   6   41 34                 75
1364950 1364950 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_2 49 3 5 0   12     0   10   33 46 *                     79.0 49 3 5 0   12     0   10   33 46                 79
1364951 1364951 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_3 59 0 6 0   13     0   0   41 37 *                     78.0 59 0 6 0   13     0   0   41 37                 78
1364952 1364952 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_4 51 4 4 0   11     0   5   44 31 *                     75.0 51 4 4 0   11     0   5   44 31                 75
1364953 1364953 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2020   grade_5 46 5 4 1   11     0   2   39 30 *                     69.0 46 5 4 1   11     0   2   39 30                 69
1364954 1364954 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 51 4 3 0   20     0   11   56 33 *                     89.0 51 4 3 0   20     0   11   56 33                 89
1364955 1364955 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   kindergarten 38 2 2 1   9     0   5   27 30 *                     57.0 38 2 2 1   9     0   5   27 30                 57
1364956 1364956 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_1 30 3 8 0   13     0   3   25 32 *                     57.0 30 3 8 0   13     0   3   25 32                 57
1364957 1364957 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_2 43 4 4 0   7     0   7   34 31 *                     65.0 43 4 4 0   7     0   7   34 31                 65
1364958 1364958 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_3 30 1 0 0   8     0   1   27 13 *                     40.0 30 1 0 0   8     0   1   27 13                 40
1364959 1364959 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_4 31 2 2 0   6     0   1   16 26 *                     42.0 31 2 2 0   6     0   1   16 26                 42
1364960 1364960 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2020   grade_5 27 5 5 0   5     0   4   20 26 *                     46.0 27 5 5 0   5     0   4   20 26                 46
1364961 1364961 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   kindergarten 54 2 4 0   16     0   11   39 48 *                     87.0 54 2 4 0   16     0   11   39 48                 87
1364962 1364962 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_1 55 4 9 0   12     0   12   51 41 *                     92.0 55 4 9 0   12     0   12   51 41                 92
1364963 1364963 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_2 50 1 8 0   9     0   4   32 39 *                     72.0 50 1 8 0   9     0   4   32 39                 72
1364964 1364964 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_3 58 5 14 1   14     0   1   40 53 *                     93.0 58 5 14 1   14     0   1   40 53                 93
1364965 1364965 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_4 60 6 6 0   12     0   6   48 42 *                     90.0 60 6 6 0   12     0   6   48 42                 90
1364966 1364966 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_5 48 4 5 1   16     0   6   41 39 *                     80.0 48 4 5 1   16     0   6   41 39                 80
1364967 1364967 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   kindergarten 41 4 9 0   16     0   14   39 45 *                     84.0 41 4 9 0   16     0   14   39 45                 84
1364968 1364968 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_1 48 2 4 0   22     0   8   47 37 *                     84.0 48 2 4 0   22     0   8   47 37                 84
1364969 1364969 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_2 57 1 3 0   7     0   9   36 41 *                     77.0 57 1 3 0   7     0   9   36 41                 77
1364970 1364970 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_3 42 2 3 0   24     0   1   42 30 *                     72.0 42 2 3 0   24     0   1   42 30                 72
1364971 1364971 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_4 47 4 5 0   9     0   6   32 39 *                     71.0 47 4 5 0   9     0   6   32 39                 71
1364972 1364972 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   grade_5 47 2 5 0   5     0   3   30 32 *                     62.0 47 2 5 0   5     0   3   30 32                 62
1364973 1364973 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2020   grade_6 356 20 40 0   40     0   30   255 231 *                     486.0 356 20 40 0   40     0   30   255 231                 486
1364974 1364974 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2020   grade_7 321 15 33 1   53     1   31   247 207 *                     455.0 321 15 33 1   53     1   31   247 207                 455
1364975 1364975 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2020   grade_8 328 12 31 0   51     1   21   203 240 *                     444.0 328 12 31 0   51     1   21   203 240                 444
1364976 1364976 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_9 272 17 20 0   36     0   23   162 205 *                     368.0 272 17 20 0   36     0   23   162 205                 368
1364977 1364977 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_10 269 16 19 0   38     0   22   172 192 *                     364.0 269 16 19 0   38     0   22   172 192                 364
1364978 1364978 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_11 252 11 23 0   41     0   15   169 172 *                     342.0 252 11 23 0   41     0   15   169 172                 342
1364979 1364979 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_12 260 13 22 0   33     1   8   182 153 *                     337.0 260 13 22 0   33     1   8   182 153                 337
1364980 1364980 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 61 5 5 0   22     0   0   58 35 *                     93.0 61 5 5 0   22     0   0   58 35                 93
1364981 1364981 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   kindergarten 115 6 14 0   48     0   5   107 81 *                     188.0 115 6 14 0   48     0   5   107 81                 188
1364982 1364982 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_1 131 6 29 1   44     0   11   126 96 *                     222.0 131 6 29 1   44     0   11   126 96                 222
1364983 1364983 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_2 118 7 27 0   43     0   9   103 101 *                     204.0 118 7 27 0   43     0   9   103 101                 204

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