Data source: Big Local News · About: Big Local

117,696 rows where state = "AR" sorted by school_state_id

View and edit SQL

grade

year

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
3355069 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201540 203020 NOBLE/ALLBRITTON ELEMENTARY SC   Regular School No 1 PK 05 2016   ungraded 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214912 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   ged 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214913 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 15.0 5.0 3.0               0.0                             23.0 15 5 3               0                       23
214914 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_10 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214915 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_11 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214916 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_12 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214917 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 12.0 5.0 4.0               1.0                             22.0 12 5 4               1                       22
214918 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_3 7.0 1.0 4.0               0.0                             12.0 7 1 4               0                       12
214919 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 17.0 5.0 3.0               0.0                             25.0 17 5 3               0                       25
214920 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_5 15.0 4.0 2.0               1.0                             22.0 15 4 2               1                       22
214921 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214922 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_7 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214923 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_8 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214924 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_9 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
214925 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   k_12_total 74.0 31.0 20.0               2.0   58.0 69.0                       127.0 74 31 20               2   58 69                 127
214926 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten 8.0 11.0 4.0               0.0                             23.0 8 11 4               0                       23
214927 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   ungraded 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386324 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   ged 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386325 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 8.0 11.0 5.0               0.0                             24.0 8 11 5               0                       24
386326 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_10 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386327 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_11 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386328 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_12 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386329 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 17.0 5.0 3.0               0.0                             25.0 17 5 3               0                       25
386330 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_3 15.0 5.0 3.0               1.0                             24.0 15 5 3               1                       24
386331 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 6.0 0.0 4.0               0.0                             10.0 6 0 4               0                       10
386332 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 10.0 4.0 3.0               0.0                             17.0 10 4 3               0                       17
386333 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386334 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386335 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_8 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386336 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
386337 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   k_12_total 65.0 29.0 23.0               3.0   56.0 64.0                       120.0 65 29 23               3   56 64                 120
386338 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten 9.0 4.0 5.0               2.0                             20.0 9 4 5               2                       20
386339 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   ungraded 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432478 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   ged 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432479 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_1 13.0 4.0 6.0               0.0                             23.0 13 4 6               0                       23
432480 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_10 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432481 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_11 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432482 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_12 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432483 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2 9.0 3.0 6.0               2.0                             20.0 9 3 6               2                       20
432484 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_3 4.0 12.0 5.0               0.0                             21.0 4 12 5               0                       21
432485 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_4 13.0 6.0 6.0               0.0                             25.0 13 6 6               0                       25
432486 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_5 14.0 6.0 2.0               1.0                             23.0 14 6 2               1                       23
432487 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_6 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432488 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432489 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_8 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432490 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_9 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
432491 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   k_12_total 60.0 36.0 29.0               4.0   67.0 62.0                       129.0 60 36 29               4   67 62                 129
432492 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   kindergarten 7.0 5.0 4.0               1.0                             17.0 7 5 4               1                       17
432493 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   ungraded 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498325 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   ged 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498326 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1 9.0 4.0 6.0               2.0                             21.0 9 4 6               2                       21
498327 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_10 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498328 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_11 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498329 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_12 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498330 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2 6.0 13.0 5.0               0.0                             24.0 6 13 5               0                       24
498331 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3 14.0 7.0 4.0               0.0                             25.0 14 7 4               0                       25
498332 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4 14.0 6.0 3.0               1.0                             24.0 14 6 3               1                       24
498333 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5 6.0 0.0 4.0               0.0                             10.0 6 0 4               0                       10
498334 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_6 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498335 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_7 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498336 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498337 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_9 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
498338 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   k_12_total 62.0 33.0 27.0               3.0   61.0 64.0                       125.0 62 33 27               3   61 64                 125
498339 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten 13.0 3.0 5.0               0.0                             21.0 13 3 5               0                       21
498340 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   ungraded 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972566 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   ged 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972567 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_1 16.0 0.0 3.0               1.0                             20.0 16 0 3               1                       20
2972568 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_10 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972569 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_11 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972570 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_12 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972571 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_2 19.0 4.0 4.0               1.0                             28.0 19 4 4               1                       28
2972572 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_3 14.0 2.0 2.0               0.0                             18.0 14 2 2               0                       18
2972573 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_4 12.0 3.0 1.0               0.0                             16.0 12 3 1               0                       16
2972574 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_5 17.0 2.0 3.0               0.0                             22.0 17 2 3               0                       22
2972575 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_6 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972576 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_7 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972577 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_8 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972578 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   grade_9 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2972579 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   k_12_total 93.0 13.0 17.0               2.0   49.0 76.0                       125.0 93 13 17               2   49 76                 125
2972580 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   kindergarten 15.0 2.0 4.0               0.0                             21.0 15 2 4               0                       21
2972581 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2015   ungraded 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989574 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   ged 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989575 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 13.0 6.0 4.0               0.0                             23.0 13 6 4               0                       23
2989576 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_10 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989577 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_11 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989578 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_12 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989579 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 10.0 1.0 4.0               0.0                             15.0 10 1 4               0                       15
2989580 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 19.0 4.0 4.0               0.0                             27.0 19 4 4               0                       27
2989581 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 15.0 5.0 4.0               1.0                             25.0 15 5 4               1                       25
2989582 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 16.0 4.0 2.0               0.0                             22.0 16 4 2               0                       22
2989583 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_6 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989584 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989585 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_8 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989586 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_9 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
2989587 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   k_12_total 89.0 26.0 21.0               1.0   60.0 77.0                       137.0 89 26 21               1   60 77                 137
2989588 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten 16.0 6.0 3.0               0.0                             25.0 16 6 3               0                       25
2989589 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   ungraded 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
3355070 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2016   ged 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0
3355071 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2016   grade_1 15.0 1.0 4.0               0.0                             20.0 15 1 4               0                       20
3355072 AR     school 500042 203000   HAMBURG SCHOOL DISTRICT 50004201282 203027 PORTLAND ELEMENTARY SCHOOL   Regular School No 1 PK 05 2016   grade_10 0.0 0.0 0.0               0.0                             0.0 0 0 0               0                       0

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