enrollments

Data source: Big Local News · About: Big Local

15,758 rows where state = "WA" and year = 2017 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2017 · 15,658 ✖
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
626598 626598 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_2 4 2 92   0 0     0   1   48 51 0   69   1   95       0.0 99 4 2 92   0 0     0   1   48 51 0   69 1 95     0 99
626599 626599 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_3 4 1 69   0 0     0   1   28 47 0   57   2   74       1.0 75 4 1 69   0 0     0   1   28 47 0   57 2 74     1 75
626600 626600 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_4 8 2 70   0 0     0   1   41 40 0   53   2   77       1.0 81 8 2 70   0 0     0   1   41 40 0   53 2 77     1 81
626601 626601 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_5 4 1 74   0 0     0   2   38 43 0   55   1   76       0.0 81 4 1 74   0 0     0   2   38 43 0   55 1 76     0 81
626602 626602 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   grade_6 4 0 86   0 0     0   2   48 44 0   54   5   85       0.0 92 4 0 86   0 0     0   2   48 44 0   54 5 85     0 92
626603 626603 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   pk_12_total 40 7 557   0 1     0   12   307 310 0   415   14   574       2.0 617 40 7 557   0 1     0   12   307 310 0   415 14 574     2 617
626604 626604 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
626605 626605 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   kindergarten 3 1 72   0 0     0   0   43 33 0   65   1   71       0.0 76 3 1 72   0 0     0   0   43 33 0   65 1 71     0 76
626606 626606 WA Franklin   school 5306570 11001   Pasco School District 530657003552 5392 Captain Gray STEM Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 11 0 19   0 1     0   3   29 5 0   0   0   19       0.0 34 11 0 19   0 1     0   3   29 5 0   0 0 19     0 34
626607 626607 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2017   grade_10 211 11 446   0 15     1   15   366 333 0   117   16   437       18.0 699 211 11 446   0 15     1   15   366 333 0   117 16 437     18 699
626608 626608 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2017   grade_11 181 12 382   0 7     2   16   335 265 0   84   18   391       17.0 600 181 12 382   0 7     2   16   335 265 0   84 18 391     17 600
626609 626609 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2017   grade_12 171 10 371   1 13     5   9   307 273 0   65   10   371       7.0 580 171 10 371   1 13     5   9   307 273 0   65 10 371     7 580
626610 626610 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2017   grade_8 2 0 1   0 1     0   0   1 3 0   0   0   3       0.0 4 2 0 1   0 1     0   0   1 3 0   0 0 3     0 4
626611 626611 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2017   grade_9 199 9 438   1 8     1   25   345 336 0   7   16   462       21.0 681 199 9 438   1 8     1   25   345 336 0   7 16 462     21 681
626612 626612 WA Franklin   school 5306570 11001   Pasco School District 530657003292 5164 Chiawana Senior High School   Regular School No High 08 12 2017   pk_12_total 764 42 1638   2 44     9   65   1354 1210 0   273   60   1664       63.0 2564 764 42 1638   2 44     9   65   1354 1210 0   273 60 1664     63 2564
626613 626613 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_1 43 0 15   0 0     0   1   35 24 0   13   0   26       0.0 59 43 0 15   0 0     0   1   35 24 0   13 0 26     0 59
626614 626614 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_2 31 0 11   1 0     0   1   31 13 0   12   0   24       0.0 44 31 0 11   1 0     0   1   31 13 0   12 0 24     0 44
626615 626615 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_3 36 1 23   0 0     0   0   32 28 0   18   0   30       0.0 60 36 1 23   0 0     0   0   32 28 0   18 0 30     0 60
626616 626616 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_4 26 0 22   0 0     0   2   27 23 0   12   0   25       0.0 50 26 0 22   0 0     0   2   27 23 0   12 0 25     0 50
626617 626617 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_5 36 0 21   1 0     0   1   25 34 0   11   0   31       0.0 59 36 0 21   1 0     0   1   25 34 0   11 0 31     0 59
626618 626618 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   grade_6 38 0 23   0 0     0   0   29 32 0   8   0   30       1.0 61 38 0 23   0 0     0   0   29 32 0   8 0 30     1 61
626619 626619 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   pk_12_total 241 1 144   2 0     0   6   219 175 0   94   0   197       1.0 394 241 1 144   2 0     0   6   219 175 0   94 0 197     1 394
626620 626620 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
626621 626621 WA Franklin   school 5306570 11001   Pasco School District 530657000963 3425 Edwin Markham Elementary   Regular School No Elementary KG 06 2017   kindergarten 31 0 28   0 0     0   1   39 21 0   19   0   30       0.0 60 31 0 28   0 0     0   1   39 21 0   19 0 30     0 60
626622 626622 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2017   grade_7 6 2 318   0 1     0   5   153 179 0   6   6   325       3.0 332 6 2 318   0 1     0   5   153 179 0   6 6 325     3 332
626623 626623 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2017   grade_8 16 6 344   0 1     0   2   200 169 0   147   15   355       7.0 369 16 6 344   0 1     0   2   200 169 0   147 15 355     7 369
626624 626624 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2017   pk_12_total 22 8 662   0 2     0   7   353 348 0   153   21   680       10.0 701 22 8 662   0 2     0   7   353 348 0   153 21 680     10 701
626625 626625 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_1 6 2 87   0 0     0   0   51 44 0   65   10   94       1.0 95 6 2 87   0 0     0   0   51 44 0   65 10 94     1 95
626626 626626 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_2 6 0 106   0 0     0   1   59 54 0   65   9   105       0.0 113 6 0 106   0 0     0   1   59 54 0   65 9 105     0 113
626627 626627 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_3 1 1 98   0 0     0   1   42 59 0   57   8   97       2.0 101 1 1 98   0 0     0   1   42 59 0   57 8 97     2 101
626628 626628 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_4 7 0 79   0 0     0   0   48 38 0   41   4   83       1.0 86 7 0 79   0 0     0   0   48 38 0   41 4 83     1 86
626629 626629 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_5 6 0 71   0 0     0   1   46 32 0   47   4   74       1.0 78 6 0 71   0 0     0   1   46 32 0   47 4 74     1 78
626630 626630 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   grade_6 4 0 80   0 0     0   0   40 44 0   46   4   76       2.0 84 4 0 80   0 0     0   0   40 44 0   46 4 76     2 84
626631 626631 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   pk_12_total 40 5 602   0 0     1   4   329 323 0   389   40   614       8.0 652 40 5 602   0 0     1   4   329 323 0   389 40 614     8 652
626632 626632 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   kindergarten 10 2 80   0 0     1   1   43 51 0   68   1   85       1.0 94 10 2 80   0 0     1   1   43 51 0   68 1 85     1 94
626633 626633 WA Franklin   school 5306570 11001   Pasco School District 530657000964 2967 Emerson Elementary   Regular School No Elementary KG 06 2017   pre_kindergarten 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
626634 626634 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2017   grade_2 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
626635 626635 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2017   grade_8 1 0 3   0 0     0   0   3 1 0   0   0   2       0.0 4 1 0 3   0 0     0   0   3 1 0   0 0 2     0 4
626636 626636 WA Franklin   school 5306570 11001   Pasco School District 530657003547 5393 Internet Pasco Academy of Learning   Alternative School No Elementary KG 08 2017   pk_12_total 2 0 3   0 0     0   0   3 2 0   0   0   2       0.0 5 2 0 3   0 0     0   0   3 2 0   0 0 2     0 5
626637 626637 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_1 44 2 41   0 2     0   5   50 44 0   18   0   56       0.0 94 44 2 41   0 2     0   5   50 44 0   18 0 56     0 94
626638 626638 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_2 33 2 49   0 1     1   5   51 40 0   18   1   54       1.0 91 33 2 49   0 1     1   5   51 40 0   18 1 54     1 91
626639 626639 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_3 42 3 53   0 1     0   5   59 45 0   15   1   56       2.0 104 42 3 53   0 1     0   5   59 45 0   15 1 56     2 104
626640 626640 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_4 23 4 40   0 1     0   4   39 33 0   15   3   42       0.0 72 23 4 40   0 1     0   4   39 33 0   15 3 42     0 72
626641 626641 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_5 43 2 52   0 1     1   6   56 49 0   12   2   58       1.0 105 43 2 52   0 1     1   6   56 49 0   12 2 58     1 105
626642 626642 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   grade_6 33 4 45   0 2     0   1   49 36 0   9   2   47       1.0 85 33 4 45   0 2     0   1   49 36 0   9 2 47     1 85
626643 626643 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   pk_12_total 253 18 332   0 8     2   29   355 287 0   115   9   360       5.0 642 253 18 332   0 8     2   29   355 287 0   115 9 360     5 642
626644 626644 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   kindergarten_half_day 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
626645 626645 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   kindergarten 35 0 51   0 0     0   3   49 40 0   28   0   46       0.0 89 35 0 51   0 0     0   3   49 40 0   28 0 46     0 89
626646 626646 WA Franklin   school 5306570 11001   Pasco School District 530657001860 4155 James McGee Elementary   Regular School No Elementary KG 06 2017   pre_kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
626647 626647 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_1 1 0 53   0 0     0   0   30 24 0   39   0   51       1.0 54 1 0 53   0 0     0   0   30 24 0   39 0 51     1 54
626648 626648 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_2 3 0 62   0 0     0   1   41 25 0   47   3   66       0.0 66 3 0 62   0 0     0   1   41 25 0   47 3 66     0 66
626649 626649 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_3 2 0 67   0 0     0   0   35 34 0   48   2   67       0.0 69 2 0 67   0 0     0   0   35 34 0   48 2 67     0 69
626650 626650 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_4 1 0 69   0 0     0   0   33 37 0   50   3   68       0.0 70 1 0 69   0 0     0   0   33 37 0   50 3 68     0 70
626651 626651 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_5 1 1 60   0 0     0   0   36 26 0   41   5   60       0.0 62 1 1 60   0 0     0   0   36 26 0   41 5 60     0 62
626652 626652 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_6 1 0 54   0 0     0   0   24 31 0   34   1   54       1.0 55 1 0 54   0 0     0   0   24 31 0   34 1 54     1 55
626653 626653 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   pk_12_total 10 1 445   0 0     0   3   245 214 0   316   15   441       2.0 459 10 1 445   0 0     0   3   245 214 0   316 15 441     2 459
626654 626654 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   kindergarten_half_day 0 0 2   0 0     0   0   1 1 0   1   0   1       0.0 2 0 0 2   0 0     0   0   1 1 0   1 0 1     0 2
626655 626655 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   kindergarten 1 0 70   0 0     0   2   40 33 0   56   1   69       0.0 73 1 0 70   0 0     0   2   40 33 0   56 1 69     0 73
626656 626656 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 8   0 0     0   0   5 3 0   0   0   5       0.0 8 0 0 8   0 0     0   0   5 3 0   0 0 5     0 8
626657 626657 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   grade_3 4 0 180   0 0     0   0   93 91 0   3   2   182       1.0 184 4 0 180   0 0     0   0   93 91 0   3 2 182     1 184
626658 626658 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   grade_4 5 2 211   0 0     0   4   124 98 0   136   3   213       2.0 222 5 2 211   0 0     0   4   124 98 0   136 3 213     2 222
626659 626659 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   grade_5 13 3 185   0 1     0   3   93 112 0   131   8   198       2.0 205 13 3 185   0 1     0   3   93 112 0   131 8 198     2 205
626660 626660 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   grade_6 11 0 177   0 0     0   3   92 99 0   127   2   185       2.0 191 11 0 177   0 0     0   3   92 99 0   127 2 185     2 191
626661 626661 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   pk_12_total 33 5 753   0 1     0   10   402 400 0   397   15   778       7.0 802 33 5 753   0 1     0   10   402 400 0   397 15 778     7 802
626662 626662 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_1 40 1 63   0 1     0   3   46 62 0   44   1   71       1.0 108 40 1 63   0 1     0   3   46 62 0   44 1 71     1 108
626663 626663 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_2 22 0 79   0 0     1   6   56 52 0   47   0   84       0.0 108 22 0 79   0 0     1   6   56 52 0   47 0 84     0 108
626664 626664 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_3 26 1 80   0 0     0   10   58 59 0   48   1   84       0.0 117 26 1 80   0 0     0   10   58 59 0   48 1 84     0 117
626665 626665 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_4 33 1 74   1 0     0   3   56 56 0   33   1   79       1.0 112 33 1 74   1 0     0   3   56 56 0   33 1 79     1 112
626666 626666 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_5 59 3 56   0 0     0   4   65 57 0   39   0   86       1.0 122 59 3 56   0 0     0   4   65 57 0   39 0 86     1 122
626667 626667 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   grade_6 31 1 81   0 0     0   3   65 51 0   34   1   87       0.0 116 31 1 81   0 0     0   3   65 51 0   34 1 87     0 116
626668 626668 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   pk_12_total 234 11 502   1 1     1   31   388 393 0   282   4   554       3.0 781 234 11 502   1 1     1   31   388 393 0   282 4 554     3 781
626669 626669 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   kindergarten_half_day 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
626670 626670 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   kindergarten 19 4 68   0 0     0   2   41 52 0   37   0   63       0.0 93 19 4 68   0 0     0   2   41 52 0   37 0 63     0 93
626671 626671 WA Franklin   school 5306570 11001   Pasco School District 530657000966 3085 Mark Twain Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 3 0 1   0 0     0   0   1 3 0   0   0   0       0.0 4 3 0 1   0 0     0   0   1 3 0   0 0 0     0 4
626672 626672 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_1 51 2 58   0 0     1   8   61 59 0   35   4   56       2.0 120 51 2 58   0 0     1   8   61 59 0   35 4 56     2 120
626673 626673 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_2 43 2 70   0 7     1   6   74 55 0   36   3   67       1.0 129 43 2 70   0 7     1   6   74 55 0   36 3 67     1 129
626674 626674 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_3 61 2 68   0 3     0   6   71 69 0   35   3   69       2.0 140 61 2 68   0 3     0   6   71 69 0   35 3 69     2 140
626675 626675 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_4 51 1 61   0 2     0   10   58 67 0   23   0   63       1.0 125 51 1 61   0 2     0   10   58 67 0   23 0 63     1 125
626676 626676 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_5 53 1 72   0 4     1   3   63 71 0   20   2   76       5.0 134 53 1 72   0 4     1   3   63 71 0   20 2 76     5 134
626677 626677 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   grade_6 55 2 74   0 2     1   7   67 74 0   23   1   75       4.0 141 55 2 74   0 2     1   7   67 74 0   23 1 75     4 141
626678 626678 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   pk_12_total 366 10 457   0 21     4   45   452 451 0   205   14   450       15.0 903 366 10 457   0 21     4   45   452 451 0   205 14 450     15 903
626679 626679 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   kindergarten 47 0 53   0 3     0   5   56 52 0   33   1   44       0.0 108 47 0 53   0 3     0   5   56 52 0   33 1 44     0 108
626680 626680 WA Franklin   school 5306570 11001   Pasco School District 530657002950 4595 Maya Angelou Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 5 0 1   0 0     0   0   2 4 0   0   0   0       0.0 6 5 0 1   0 0     0   0   2 4 0   0 0 0     0 6
626681 626681 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2017   grade_7 257 12 287   1 13     4   35   291 318 0   5   4   311       13.0 609 257 12 287   1 13     4   35   291 318 0   5 4 311     13 609
626682 626682 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2017   grade_8 245 10 323   2 17     1   36   317 317 0   72   9   350       13.0 634 245 10 323   2 17     1   36   317 317 0   72 9 350     13 634
626683 626683 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2017   pk_12_total 502 22 610   3 30     5   71   608 635 0   77   13   661       26.0 1243 502 22 610   3 30     5   71   608 635 0   77 13 661     26 1243
626684 626684 WA Franklin   school 5306570 11001   Pasco School District 530657000968 3912 New Horizons High School   Alternative School No Other 06 12 2017   grade_10 3 0 14   0 0     0   0   6 11 0   1   1   15       0.0 17 3 0 14   0 0     0   0   6 11 0   1 1 15     0 17
626685 626685 WA Franklin   school 5306570 11001   Pasco School District 530657000968 3912 New Horizons High School   Alternative School No Other 06 12 2017   grade_11 9 0 43   0 1     1   2   31 25 0   7   5   43       3.0 56 9 0 43   0 1     1   2   31 25 0   7 5 43     3 56
626686 626686 WA Franklin   school 5306570 11001   Pasco School District 530657000968 3912 New Horizons High School   Alternative School No Other 06 12 2017   grade_12 20 5 166   1 0     1   3   116 80 0   40   12   159       3.0 196 20 5 166   1 0     1   3   116 80 0   40 12 159     3 196
626687 626687 WA Franklin   school 5306570 11001   Pasco School District 530657000968 3912 New Horizons High School   Alternative School No Other 06 12 2017   pk_12_total 32 5 223   1 1     2   5   153 116 0   48   18   217       6.0 269 32 5 223   1 1     2   5   153 116 0   48 18 217     6 269
626688 626688 WA Franklin   school 5306570 11001   Pasco School District 530657003143 1970 Pasco Early Childhood   Regular School No Elementary PK PK 2017   pk_12_total 54 3 79   0 1     0   1   90 48 0   0   1   73       0.0 138 54 3 79   0 1     0   1   90 48 0   0 1 73     0 138
626689 626689 WA Franklin   school 5306570 11001   Pasco School District 530657003143 1970 Pasco Early Childhood   Regular School No Elementary PK PK 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
626690 626690 WA Franklin   school 5306570 11001   Pasco School District 530657003143 1970 Pasco Early Childhood   Regular School No Elementary PK PK 2017   kindergarten 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
626691 626691 WA Franklin   school 5306570 11001   Pasco School District 530657003143 1970 Pasco Early Childhood   Regular School No Elementary PK PK 2017   pre_kindergarten 54 3 77   0 1     0   1   88 48 0   0   1   72       0.0 136 54 3 77   0 1     0   1   88 48 0   0 1 72     0 136
626692 626692 WA Franklin   school 5306570 11001   Pasco School District 530657000969 2917 Pasco Senior High School   Regular School No High 09 12 2017   grade_10 99 13 472   1 8     0   11   316 288 0   132   11   480       15.0 604 99 13 472   1 8     0   11   316 288 0   132 11 480     15 604
626693 626693 WA Franklin   school 5306570 11001   Pasco School District 530657000969 2917 Pasco Senior High School   Regular School No High 09 12 2017   grade_11 87 10 420   0 3     0   10   281 249 0   99   9   405       9.0 530 87 10 420   0 3     0   10   281 249 0   99 9 405     9 530
626694 626694 WA Franklin   school 5306570 11001   Pasco School District 530657000969 2917 Pasco Senior High School   Regular School No High 09 12 2017   grade_12 90 6 372   1 1     1   6   237 240 0   74   10   344       9.0 477 90 6 372   1 1     1   6   237 240 0   74 10 344     9 477
626695 626695 WA Franklin   school 5306570 11001   Pasco School District 530657000969 2917 Pasco Senior High School   Regular School No High 09 12 2017   grade_9 101 9 437   0 4     0   8   291 268 0   28   16   452       13.0 559 101 9 437   0 4     0   8   291 268 0   28 16 452     13 559
626696 626696 WA Franklin   school 5306570 11001   Pasco School District 530657000969 2917 Pasco Senior High School   Regular School No High 09 12 2017   pk_12_total 377 38 1701   2 16     1   35   1125 1045 0   333   46   1681       46.0 2170 377 38 1701   2 16     1   35   1125 1045 0   333 46 1681     46 2170
626697 626697 WA Franklin   school 5306570 11001   Pasco School District 530657000970 3515 Robert Frost Elementary   Regular School No Elementary PK 06 2017   grade_1 26 0 49   0 0     1   1   41 36 0   59   1   69       0.0 77 26 0 49   0 0     1   1   41 36 0   59 1 69     0 77

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