enrollments

Data source: Big Local News · About: Big Local

8,839 rows where grade = "grade_5" and state = "WA" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 8,739 ✖
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
2466823 2466823 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2018   grade_5 31 0 24   0 0     0   2   32 25 0   13   1   27       0.0 57 31 0 24   0 0     0   2   32 25 0   13 1 27     0 57
2466835 2466835 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2018   grade_5 5 0 92   0 0     0   1   54 44 0   47   1   86       2.0 98 5 0 92   0 0     0   1   54 44 0   47 1 86     2 98
2466843 2466843 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2018   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2466852 2466852 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2018   grade_5 23 3 50   0 1     0   6   40 43 0   19   3   53       0.0 83 23 3 50   0 1     0   6   40 43 0   19 3 53     0 83
2466862 2466862 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2018   grade_5 4 0 77   0 0     0   0   38 43 0   58   1   79       0.0 81 4 0 77   0 0     0   0   38 43 0   58 1 79     0 81
2466870 2466870 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2018   grade_5 6 3 219   0 0     0   5   131 102 0   160   4   226       3.0 233 6 3 219   0 0     0   5   131 102 0   160 4 226     3 233
2466877 2466877 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2018   grade_5 34 1 74   0 0     0   2   59 52 0   36   4   78       2.0 111 34 1 74   0 0     0   2   59 52 0   36 4 78     2 111
2466886 2466886 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2018   grade_5 46 1 61   0 2     0   10   52 68 0   24   2   67       1.0 120 46 1 61   0 2     0   10   52 68 0   24 2 67     1 120
2466914 2466914 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2018   grade_5 17 0 76   0 0     0   1   46 48 0   60   1   87       0.0 94 17 0 76   0 0     0   1   46 48 0   60 1 87     0 94
2466922 2466922 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2018   grade_5 53 2 65   0 0     0   6   60 66 0   25   2   69       3.0 126 53 2 65   0 0     0   6   60 66 0   25 2 69     3 126
2466932 2466932 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 06 2018   grade_5 2 0 73   0 0     0   1   36 40 0   53   4   72       1.0 76 2 0 73   0 0     0   1   36 40 0   53 4 72     1 76
2466942 2466942 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2018   grade_5 75 4 44   0 2     1   7   73 60 0   11   0   63       2.0 133 75 4 44   0 2     1   7   73 60 0   11 0 63     2 133
2466955 2466955 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary KG 06 2018   grade_5 2 3 117   0 0     0   0   58 64 0   91   1   119       0.0 122 2 3 117   0 0     0   0   58 64 0   91 1 119     0 122
2579668 2579668 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No Elementary PK 06 2020   grade_5 35 0 44   0 0     0   4   41 42 0   9   0   46       3.0 83 35 0 44   0 0     0   4   41 42 0   9 0 46     3 83
2579677 2579677 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2020   grade_5 0 1 108   0 0     0   0   54 55 0   77   4   105       0.0 109 0 1 108   0 0     0   0   54 55 0   77 4 105     0 109
2579692 2579692 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2020   grade_5 34 0 19   0 2     0   2   36 21 0   4   0   23       1.0 57 34 0 19   0 2     0   2   36 21 0   4 0 23     1 57
2579705 2579705 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2020   grade_5 5 0 83   0 0     0   0   45 43 0   47   0   80       0.0 88 5 0 83   0 0     0   0   45 43 0   47 0 80     0 88
2579712 2579712 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2020   grade_5 2 0 1   0 0     0   0   1 2 0   0   0   0       0.0 3 2 0 1   0 0     0   0   1 2 0   0 0 0     0 3
2579722 2579722 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2020   grade_5 30 0 55   0 1     0   4   49 41 0   10   0   47       1.0 90 30 0 55   0 1     0   4   49 41 0   10 0 47     1 90
2579731 2579731 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2020   grade_5 7 0 60   0 0     0   0   39 28 0   37   0   63       1.0 67 7 0 60   0 0     0   0   39 28 0   37 0 63     1 67
2579737 2579737 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2020   grade_5 8 0 214   0 3     0   3   102 126 0   153   1   215       1.0 228 8 0 214   0 3     0   3   102 126 0   153 1 215     1 228
2579744 2579744 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2020   grade_5 19 0 71   0 1     0   3   53 41 0   20   1   72       3.0 94 19 0 71   0 1     0   3   53 41 0   20 1 72     3 94
2579753 2579753 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2020   grade_5 51 3 77   0 8     1   4   78 66 0   29   0   85       3.0 144 51 3 77   0 8     1   4   78 66 0   29 0 85     3 144
2579783 2579783 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2020   grade_5 5 0 62   0 2     1   0   31 39 0   27   2   64       1.0 70 5 0 62   0 2     1   0   31 39 0   27 2 64     1 70
2579791 2579791 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 06 2020   grade_5 39 1 86   0 1     1   7   77 58 0   30   1   90       4.0 135 39 1 86   0 1     1   7   77 58 0   30 1 90     4 135
2579800 2579800 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 06 2020   grade_5 1 0 72   0 0     0   1   40 34 0   35   0   70       0.0 74 1 0 72   0 0     0   1   40 34 0   35 0 70     0 74
2579809 2579809 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 06 2020   grade_5 58 1 29   0 4     0   8   48 52 0   3   0   42       4.0 100 58 1 29   0 4     0   8   48 52 0   3 0 42     4 100
2579821 2579821 WA Franklin   school 5306570 11001   Pasco School District 530657003686 5556 Three Rivers Elementary   Regular School No Elementary KG 06 2020   grade_5 37 0 40   0 1     2   3   43 40 0   29   0   67       0.0 83 37 0 40   0 1     2   3   43 40 0   29 0 67     0 83
2579829 2579829 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary KG 06 2020   grade_5 2 0 106   0 0     0   0   58 50 0   65   0   99       0.0 108 2 0 106   0 0     0   0   58 50 0   65 0 99     0 108
2940628 2940628 WA Franklin   school 5306570 11001   Pasco School District 530657003520 5391 Barbara McClintock STEM Elementary   Regular School No Elementary PK 05 2021   grade_5 51 3 82   0 1     0   5   65 77 0   25   1   78       4.0 142 51 3 82   0 1     0   5   65 77 0   25 1 78     4 142
2940636 2940636 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 05 2021   grade_5 3 0 76   0 0     0   0   40 39 0   55   2   77       1.0 79 3 0 76   0 0     0   0   40 39 0   55 2 77     1 79
2940650 2940650 WA Franklin   school 5306570 11001   Pasco School District 530657003734 5623 Columbia River Elementary   Regular School No Elementary PK 05 2021   grade_5 29 1 25   1 0     2   7   37 28 0   6   2   31       1.0 65 29 1 25   1 0     2   7   37 28 0   6 2 31     1 65
2940657 2940657 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary PK 05 2021   grade_5 24 0 16   0 0     0   0   27 13 0   6   0   20       1.0 40 24 0 16   0 0     0   0   27 13 0   6 0 20     1 40
2940669 2940669 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary PK 05 2021   grade_5 3 0 64   0 0     0   1   32 36 0   29   4   56       1.0 68 3 0 64   0 0     0   1   32 36 0   29 4 56     1 68
2940677 2940677 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2021   grade_5 11 1 5   0 0     0   1   9 9 0   2   0   6       0.0 18 11 1 5   0 0     0   1   9 9 0   2 0 6     0 18
2940687 2940687 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary PK 05 2021   grade_5 31 1 41   0 2     0   2   38 39 0   7   1   39       2.0 77 31 1 41   0 2     0   2   38 39 0   7 1 39     2 77
2940695 2940695 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 05 2021   grade_5 5 0 64   0 0     0   1   36 34 0   35   3   66       2.0 70 5 0 64   0 0     0   1   36 34 0   35 3 66     2 70
2940701 2940701 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 05 2021   grade_5 5 0 141   0 4     0   2   69 83 0   75   1   128       1.0 152 5 0 141   0 4     0   2   69 83 0   75 1 128     1 152
2940707 2940707 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 05 2021   grade_5 21 1 66   0 1     0   4   44 49 0   18   0   67       0.0 93 21 1 66   0 1     0   4   44 49 0   18 0 67     0 93
2940714 2940714 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 05 2021   grade_5 38 3 61   0 1     0   3   52 54 0   21   3   55       1.0 106 38 3 61   0 1     0   3   52 54 0   21 3 55     1 106
2940745 2940745 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 05 2021   grade_5 6 3 89   0 0     1   0   49 50 0   44   1   92       1.0 99 6 3 89   0 0     1   0   49 50 0   44 1 92     1 99
2940752 2940752 WA Franklin   school 5306570 11001   Pasco School District 530657003499 5345 Rosalind Franklin STEM Elementary   Regular School No Elementary PK 05 2021   grade_5 35 1 61   0 1     0   2   45 55 0   14   1   47       2.0 100 35 1 61   0 1     0   2   45 55 0   14 1 47     2 100
2940760 2940760 WA Franklin   school 5306570 11001   Pasco School District 530657002785 4555 Rowena Chess Elementary   Regular School No Elementary PK 05 2021   grade_5 6 1 75   0 1     0   0   41 42 0   38   2   77       1.0 83 6 1 75   0 1     0   0   41 42 0   38 2 77     1 83
2940767 2940767 WA Franklin   school 5306570 11001   Pasco School District 530657000971 4041 Ruth Livingston Elementary   Regular School No Elementary PK 05 2021   grade_5 52 0 22   0 2     0   3   33 46 0   0   0   27       0.0 79 52 0 22   0 2     0   3   33 46 0   0 0 27     0 79
2940779 2940779 WA Franklin   school 5306570 11001   Pasco School District 530657003686 5556 Three Rivers Elementary   Regular School No Elementary PK 05 2021   grade_5 33 2 44   0 0     1   7   43 44 0   16   0   62       0.0 87 33 2 44   0 0     1   7   43 44 0   16 0 62     0 87
2940787 2940787 WA Franklin   school 5306570 11001   Pasco School District 530657002951 5020 Virgie Robinson Elementary   Regular School No Elementary PK 05 2021   grade_5 2 0 98   0 2     0   0   60 42 0   64   4   87       0.0 102 2 0 98   0 2     0   0   60 42 0   64 4 87     0 102
467975 467975 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No 1.0 KG 06 2015   grade_5 7 0 58   0 1     0   0   34 32 0   44   0   63       0.0 66 7 0 58   0 1     0   0   34 32 0   44 0 63     0 66
467990 467990 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No 1.0 KG 06 2015   grade_5 16 0 55   0 0     0   0   35 36 0   23   0   53       1.0 71 16 0 55   0 0     0   0   35 36 0   23 0 53     1 71
468007 468007 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No 1.0 KG 06 2015   grade_5 13 0 12   0 0     0   0   17 8 0   6   0   15       1.0 25 13 0 12   0 0     0   0   17 8 0   6 0 15     1 25
468015 468015 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative Education School No 4.0 KG 12 2015   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
527882 527882 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No 1 KG 06 2016   grade_5 8 0 53   0 0     0   0   36 25 0   35   0   58       1.0 61 8 0 53   0 0     0   0   36 25 0   35 0 58     1 61
527892 527892 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No 1 PK 06 2016   grade_5 16 0 58   0 4     1   1   45 35 0   23   1   62       6.0 80 16 0 58   0 4     1   1   45 35 0   23 1 62     6 80
527909 527909 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No 1 PK 06 2016   grade_5 11 2 16   0 0     0   0   16 13 0   6   0   22       0.0 29 11 2 16   0 0     0   0   16 13 0   6 0 22     0 29
527918 527918 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative Education School No 4 KG 12 2016   grade_5 1 0 1   0 0     0   0   0 2 0   0   0   0       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 0     0 2
625310 625310 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No Elementary KG 06 2017   grade_5 5 0 49   0 1     0   0   30 25 0   34   1   51       0.0 55 5 0 49   0 1     0   0   30 25 0   34 1 51     0 55
625318 625318 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No Elementary KG 06 2017   grade_5 19 0 49   0 0     0   1   36 33 0   25   0   54       0.0 69 19 0 49   0 0     0   1   36 33 0   25 0 54     0 69
625334 625334 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No Elementary KG 06 2017   grade_5 11 0 15   0 0     0   0   17 9 0   5   0   15       2.0 26 11 0 15   0 0     0   0   17 9 0   5 0 15     2 26
625342 625342 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative School No Elementary KG 06 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2421110 2421110 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No Elementary KG 06 2019   grade_5 7 0 44   0 0     0   1   26 26 0   28   0   47       0.0 52 7 0 44   0 0     0   1   26 26 0   28 0 47     0 52
2421119 2421119 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No Elementary KG 06 2019   grade_5 15 0 65   0 2     0   1   41 42 0   26   0   67       4.0 83 15 0 65   0 2     0   1   41 42 0   26 0 67     4 83
2421140 2421140 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No Elementary PK 06 2019   grade_5 10 0 10   0 0     0   0   9 11 0   4   0   11       0.0 20 10 0 10   0 0     0   0   9 11 0   4 0 11     0 20
2421148 2421148 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative School No Elementary KG 06 2019   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2465584 2465584 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No Elementary KG 06 2018   grade_5 10 0 55   0 0     0   0   38 27 0   29   0   59       0.0 65 10 0 55   0 0     0   0   38 27 0   29 0 59     0 65
2465592 2465592 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No Elementary KG 06 2018   grade_5 20 0 57   0 1     0   3   42 39 0   29   0   63       2.0 81 20 0 57   0 1     0   3   42 39 0   29 0 63     2 81
2465611 2465611 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No Elementary KG 06 2018   grade_5 4 0 18   0 0     0   0   11 11 0   9   0   18       0.0 22 4 0 18   0 0     0   0   11 11 0   9 0 18     0 22
2465618 2465618 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative School No Elementary KG 06 2018   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2578455 2578455 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No Elementary KG 06 2020   grade_5 15 0 47   0 0     0   0   25 37 0   32   0   50       0.0 62 15 0 47   0 0     0   0   25 37 0   32 0 50     0 62
2578464 2578464 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No Elementary KG 06 2020   grade_5 16 0 57   0 1     0   2   41 35 0   27   1   69       1.0 76 16 0 57   0 1     0   2   41 35 0   27 1 69     1 76
2578483 2578483 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No Elementary PK 06 2020   grade_5 8 0 18   0 0     0   0   17 9 0   9   1   19       0.0 26 8 0 18   0 0     0   0   17 9 0   9 1 19     0 26
2578491 2578491 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative School No Elementary KG 06 2020   grade_5 1 0 0   0 0     0   1   1 1 0   0   0   0       0.0 2 1 0 0   0 0     0   1   1 1 0   0 0 0     0 2
2939326 2939326 WA Franklin   school 5305730 11051   North Franklin School District 530573000846 3325 Basin City Elem   Regular School No Elementary KG 06 2021   grade_5 6 0 26   0 0     0   0   11 21 0   18   0   26       0.0 32 6 0 26   0 0     0   0   11 21 0   18 0 26     0 32
2939335 2939335 WA Franklin   school 5305730 11051   North Franklin School District 530573000847 2918 Connell Elem   Regular School No Elementary KG 06 2021   grade_5 14 0 57   0 2     0   0   38 35 0   31   0   56       1.0 73 14 0 57   0 2     0   0   38 35 0   31 0 56     1 73
2939355 2939355 WA Franklin   school 5305730 11051   North Franklin School District 530573000849 3086 Mesa Elem   Regular School No Elementary KG 06 2021   grade_5 15 0 17   0 0     0   1   17 16 0   10   0   24       1.0 33 15 0 17   0 0     0   1   17 16 0   10 0 24     1 33
2939367 2939367 WA Franklin   school 5305730 11051   North Franklin School District 530573003736 5653 North Franklin Virtual Academy   Alternative School No Other KG 12 2021   grade_5 8 0 3   0 0     0   0   7 4 0   0   0   5       0.0 11 8 0 3   0 0     0   0   7 4 0   0 0 5     0 11
472916 472916 WA Franklin   school 5308370 11054   Star School District No. 054 530837001426 2007 Star Elem School   Regular School No 1.0 01 05 2015   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
532930 532930 WA Franklin   school 5308370 11054   Star School District No. 054 530837001426 2007 Star Elem School   Regular School No 1 02 05 2016   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2470473 2470473 WA Franklin   school 5308370 11054   Star School District No. 054 530837001426 2007 Star Elem School   Regular School No Elementary KG 06 2018   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2944351 2944351 WA Franklin   school 5308370 11054   Star School District No. 054 530837001426 2007 Star Elem School   Regular School No Elementary KG 06 2021   grade_5 1 0 1   0 0     0   0   2 0 0   0   0   0       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 0     0 2
465117 465117 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No 4.0 PK 12 2015   grade_5 2 0 2   0 0     0   0   3 1 0   0   0   4       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 4     0 4
525075 525075 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No 4 PK 12 2016   grade_5 4 0 1   0 0     0   0   3 2 0   0   0   5       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 5     0 5
622441 622441 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2017   grade_5 5 0 1   0 0     0   0   0 6 0   0   0   3       0.0 6 5 0 1   0 0     0   0   0 6 0   0 0 3     0 6
2462811 2462811 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2018   grade_5 3 0 1   0 0     0   0   2 2 0   0   0   2       0.0 4 3 0 1   0 0     0   0   2 2 0   0 0 2     0 4
2575666 2575666 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2020   grade_5 0 0 2   0 0     0   0   2 0 0   0   0   2       0.0 2 0 0 2   0 0     0   0   2 0 0   0 0 2     0 2
2936537 2936537 WA Franklin   school 5303780 11056   Kahlotus School District 530378000583 3214 Kahlotus Elem & High   Regular School No Other PK 12 2021   grade_5 2 0 1   0 0     0   2   3 2 0   0   2   0       0.0 5 2 0 1   0 0     0   2   3 2 0   0 2 0     0 5
474724 474724 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4.0 KG 12 2015   grade_5 6 0 0   0 0     0   0   4 2 0   0   0   2       0.0 6 6 0 0   0 0     0   0   4 2 0   0 0 2     0 6
534679 534679 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4 PK 12 2016   grade_5 3 0 1   0 0     0   0   3 1 0   0   0   1       0.0 4 3 0 1   0 0     0   0   3 1 0   0 0 1     0 4
632014 632014 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_5 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
2427703 2427703 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2472218 2472218 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2018   grade_5 4 0 0   0 0     0   0   2 2 0   0   0   2       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 2     0 4
2585132 2585132 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2020   grade_5 8 0 0   0 0     0   1   4 5 0   0   0   9       0.0 9 8 0 0   0 0     0   1   4 5 0   0 0 9     0 9
2946176 2946176 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2021   grade_5 4 0 1   0 0     0   0   3 2 0   0   0   4       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 4     0 5
460665 460665 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No 1.0 KG 06 2015   grade_5 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
520648 520648 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No 1 KG 06 2016   grade_5 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
618014 618014 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2017   grade_5 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
2413966 2413966 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2019   grade_5 4 0 0   0 0     0   0   2 2 0   0   0   1       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 1     0 4
2571288 2571288 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2020   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2932172 2932172 WA Adams   school 5300450 1122   Benge School District 530045000118 3142 Benge Elementary   Regular School No Elementary KG 06 2021   grade_5 2 0 1   0 0     0   0   1 2 0   0   0   0       0.0 3 2 0 1   0 0     0   0   1 2 0   0 0 0     0 3
469201 469201 WA Adams   school 5306480 1147   Othello School District 530648000954 2961 Hiawatha Elementary School   Regular School No 1.0 KG 06 2015   grade_5 11 0 65   0 0     0   0   34 42 0   25   5   68       3.0 76 11 0 65   0 0     0   0   34 42 0   25 5 68     3 76
469208 469208 WA Adams   school 5306480 1147   Othello School District 530648000955 2902 Lutacaga Elementary   Regular School No 1.0 KG 06 2015   grade_5 7 0 69   0 0     0   0   37 39 0   36   3   62       1.0 76 7 0 69   0 0     0   0   37 39 0   36 3 62     1 76
469227 469227 WA Adams   school 5306480 1147   Othello School District 530648000958 3730 Scootney Springs Elementary   Regular School No 1.0 PK 06 2015   grade_5 6 0 70   0 0     0   0   40 36 0   28   1   66       1.0 76 6 0 70   0 0     0   0   40 36 0   28 1 66     1 76

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