Data source: Big Local News · About: Big Local

4,725 rows where state = "ID" and year = 2017 sorted by school_state_id descending

View and edit SQL

grade

year

  • 2017 · 4,725
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
1726494 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_10 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1726495 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_12 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726496 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1726497 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   k_12_total 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1727661 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12.0 2017   grade_10 9 0 3   0 0     0   0   7 5             *         12 9 0 3   0 0     0   0   7 5                 12
1727662 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12.0 2017   grade_11 17 0 15   1 0     0   1   18 16             *         34 17 0 15   1 0     0   1   18 16                 34
1727663 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12.0 2017   grade_12 27 0 36   2 0     0   0   32 33             38         65 27 0 36   2 0     0   0   32 33         38       65
1727664 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12.0 2017   grade_9 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1727665 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000914 9017 VALLIVUE ACADEMY   Alternative School No High 09 12.0 2017   k_12_total 54 0 56   3 0     0   1   59 55             77         114 54 0 56   3 0     0   1   59 55         77       114
1728932 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_10 15 1 0   0 0     0   0   8 8             8         16 15 1 0   0 0     0   0   8 8         8       16
1728933 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_11 19 0 2   0 0     0   0   8 13             12         21 19 0 2   0 0     0   0   8 13         12       21
1728934 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_12 37 0 2   1 0     0   1   21 20             17         41 37 0 2   1 0     0   1   21 20         17       41
1728935 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_6 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1728936 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
1728937 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_8 6 0 0   1 0     0   0   4 3             *         7 6 0 0   1 0     0   0   4 3                 7
1728938 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_9 18 0 1   0 0     0   0   7 12             *         19 18 0 1   0 0     0   0   7 12                 19
1728939 ID     school 1601920 321   MADISON DISTRICT 160192000296 9015 CENTRAL HIGH SCHOOL   Alternative School No Other 06 12.0 2017   k_12_total 98 1 7   2 0     0   1   51 58             56         109 98 1 7   2 0     0   1   51 58         56       109
1728767 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_11 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728768 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_12 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1728769 ID     school 1602850 291   SALMON DISTRICT 160285000700 9014 SALMON ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   k_12_total 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1726649 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_10 9 1 4   4 0     0   1   11 8             9         19 9 1 4   4 0     0   1   11 8         9       19
1726650 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_11 13 0 12   8 0     1   0   18 16             *         34 13 0 12   8 0     1   0   18 16                 34
1726651 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_12 30 0 25   6 0     0   4   40 25             23         65 30 0 25   6 0     0   4   40 25         23       65
1726652 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_8 4 0 2   2 0     0   1   6 3             *         9 4 0 2   2 0     0   1   6 3                 9
1726653 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   grade_9 8 0 4   5 0     0   0   10 7             *         17 8 0 4   5 0     0   0   10 7                 17
1726654 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000689 9006 INDEPENDENCE ALTERNATIVE HIGH SCHOOL   Alternative School No High 07 12.0 2017   k_12_total 64 1 47   25 0     1   6   85 59             58         144 64 1 47   25 0     1   6   85 59         58       144
1725889 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_10 7 0 0   1 0     0   0   6 2             *         8 7 0 0   1 0     0   0   6 2                 8
1725890 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_11 4 0 1   0 0     0   0   5 0             *         5 4 0 1   0 0     0   0   5 0                 5
1725891 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_12 3 0 0   0 0     0   0   3 0             *         3 3 0 0   0 0     0   0   3 0                 3
1725892 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725893 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1725894 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_9 5 0 0   1 0     0   0   6 0             *         6 5 0 0   1 0     0   0   6 0                 6
1725895 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   k_12_total 21 0 1   2 0     0   0   22 2             *         24 21 0 1   2 0     0   0   22 2                 24
1728012 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000764 8844 FRANKLIN COUNTY HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_10 4 0 0   0 0     0   0   3 1             *         4 4 0 0   0 0     0   0   3 1                 4
1728013 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000764 8844 FRANKLIN COUNTY HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_11 15 0 1   0 0     0   0   12 4             *         16 15 0 1   0 0     0   0   12 4                 16
1728014 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000764 8844 FRANKLIN COUNTY HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_12 30 0 3   1 0     0   0   24 10             18         34 30 0 3   1 0     0   0   24 10         18       34
1728015 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000764 8844 FRANKLIN COUNTY HIGH SCHOOL   Alternative School No High 09 12.0 2017   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1728016 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000764 8844 FRANKLIN COUNTY HIGH SCHOOL   Alternative School No High 09 12.0 2017   k_12_total 50 0 4   1 0     0   0   40 15             25         55 50 0 4   1 0     0   0   40 15         25       55
1727422 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   grade_1 18 0 59   0 0     0   2   42 37             *         79 18 0 59   0 0     0   2   42 37                 79
1727423 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   grade_2 13 1 57   0 0     0   0   37 34             *         71 13 1 57   0 0     0   0   37 34                 71
1727424 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   grade_3 24 0 42   0 1     0   2   33 36             *         69 24 0 42   0 1     0   2   33 36                 69
1727425 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   grade_4 12 0 33   0 1     0   0   29 17             *         46 12 0 33   0 1     0   0   29 17                 46
1727426 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   grade_5 13 0 38   0 0     0   0   22 29             *         51 13 0 38   0 0     0   0   22 29                 51
1727427 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   k_12_total 100 2 300   0 3     0   5   206 204             *         410 100 2 300   0 3     0   5   206 204                 410
1727428 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000941 2889 NEW HORIZON MAGNET SCHOOL   Regular School No Elementary PK 5.0 2017   kindergarten 20 1 71   0 1     0   1   43 51             *         94 20 1 71   0 1     0   1   43 51                 94
1727879 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_1 13 0 0   1 0     0   1   8 7             *         15 13 0 0   1 0     0   1   8 7                 15
1727880 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_2 15 0 0   1 0     0   0   9 7             *         16 15 0 0   1 0     0   0   9 7                 16
1727881 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_3 19 1 1   0 0     0   1   10 12             *         22 19 1 1   0 0     0   1   10 12                 22
1727882 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_4 14 0 0   2 0     0   0   10 6             *         16 14 0 0   2 0     0   0   10 6                 16
1727883 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   grade_5 25 0 1   0 0     0   1   18 9             *         27 25 0 1   0 0     0   1   18 9                 27
1727884 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   k_12_total 107 1 2   4 0     0   3   67 50             84         117 107 1 2   4 0     0   3   67 50         84       117
1727885 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000983 2520 TIMBERLINE ELEMENTARY   Regular School No Elementary PK 5.0 2017   kindergarten 21 0 0   0 0     0   0   12 9             *         21 21 0 0   0 0     0   0   12 9                 21
1727219 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 93 0 15   0 0     0   3   51 60             54         111 93 0 15   0 0     0   3   51 60         54       111
1727220 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 104 0 16   1 0     0   1   70 52             53         122 104 0 16   1 0     0   1   70 52         53       122
1727221 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 78 1 14   0 0     0   3   46 50             48         96 78 1 14   0 0     0   3   46 50         48       96
1727222 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 83 0 15   0 0     0   2   53 47             49         100 83 0 15   0 0     0   2   53 47         49       100
1727223 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 72 1 13   0 0     0   0   48 38             36         86 72 1 13   0 0     0   0   48 38         36       86
1727224 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 49 1 14   0 1     0   3   33 35             30         68 49 1 14   0 1     0   3   33 35         30       68
1727225 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 566 3 105   1 1     0   15   355 336             301         691 566 3 105   1 1     0   15   355 336         301       691
1727226 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000971 2519 DISCOVERY ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 87 0 18   0 0     0   3   54 54             31         108 87 0 18   0 0     0   3   54 54         31       108
1727211 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_1 40 0 19   0 0     0   2   30 31             33         61 40 0 19   0 0     0   2   30 31         33       61
1727212 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_2 43 0 27   0 0     0   2   42 30             43         72 43 0 27   0 0     0   2   42 30         43       72
1727213 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_3 41 0 36   0 0     0   1   45 33             52         78 41 0 36   0 0     0   1   45 33         52       78
1727214 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_4 34 0 19   0 0     0   1   30 24             31         54 34 0 19   0 0     0   1   30 24         31       54
1727215 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_5 34 0 21   0 0     0   2   26 31             31         57 34 0 21   0 0     0   2   26 31         31       57
1727216 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   grade_6 36 0 22   0 1     0   1   32 28             33         60 36 0 22   0 1     0   1   32 28         33       60
1727217 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   k_12_total 274 0 171   0 1     0   11   239 218             244         457 274 0 171   0 1     0   11   239 218         244       457
1727218 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000975 2518 BRIDGEWATER ELEMENTARY SCHOOL   Regular School No Elementary PK 6.0 2017   kindergarten 46 0 27   0 0     0   2   34 41             21         75 46 0 27   0 0     0   2   34 41         21       75
1728622 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_1 72 0 2   0 0     0   3   39 38             40         77 72 0 2   0 0     0   3   39 38         40       77
1728623 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_2 63 2 8   1 1     0   8   43 40             34         83 63 2 8   1 1     0   8   43 40         34       83
1728624 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_3 69 0 3   0 2     0   4   40 38             36         78 69 0 3   0 2     0   4   40 38         36       78
1728625 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_4 87 2 6   0 1     0   2   47 51             52         98 87 2 6   0 1     0   2   47 51         52       98
1728626 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   grade_5 62 0 8   0 0     0   3   33 40             31         73 62 0 8   0 0     0   3   33 40         31       73
1728627 ID     school 1602670 273   POST FALLS DISTRICT 160267000970 2517 WEST RIDGE ELEMENTARY SCHOOL   Regular School No Elementary 01 5.0 2017   k_12_total 353 4 27   1 4     0   20   202 207             193         409 353 4 27   1 4     0   20   202 207         193       409
1728381 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 5.0 2017   grade_4 131 2 181   1 0     0   3   154 164             *         318 131 2 181   1 0     0   3   154 164                 318
1728382 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 5.0 2017   grade_5 167 1 161   2 0     1   2   184 150             *         334 167 1 161   2 0     1   2   184 150                 334
1728383 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 5.0 2017   k_12_total 298 3 342   3 0     1   5   338 314             456         652 298 3 342   3 0     1   5   338 314         456       652
1729907 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_1 57 0 8   0 1     0   2   40 28             23         68 57 0 8   0 1     0   2   40 28         23       68
1729908 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_2 40 0 6   0 1     0   2   19 30             16         49 40 0 6   0 1     0   2   19 30         16       49
1729909 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_3 44 0 7   0 0     0   0   26 25             21         51 44 0 7   0 0     0   0   26 25         21       51
1729910 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_4 44 0 4   0 1     0   3   33 19             14         52 44 0 4   0 1     0   3   33 19         14       52
1729911 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_5 45 0 5   0 0     0   2   25 27             19         52 45 0 5   0 0     0   2   25 27         19       52
1729912 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_6 42 0 5   0 0     0   2   20 29             16         49 42 0 5   0 0     0   2   20 29         16       49
1729913 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 24 0 2   0 1     0   3   19 11             9         30 24 0 2   0 1     0   3   19 11         9       30
1729914 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_8 19 1 7   0 0     0   3   17 13             9         30 19 1 7   0 0     0   3   17 13         9       30
1729915 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   k_12_total 370 1 50   0 6     0   18   233 212             152         445 370 1 50   0 6     0   18   233 212         152       445
1729916 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   kindergarten 55 0 6   0 2     0   1   34 30             25         64 55 0 6   0 2     0   1   34 30         25       64
1726235 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 361 1 34   1 13     1   20   199 232             59         431 361 1 34   1 13     1   20   199 232         59       431
1726236 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 352 5 46   1 8     3   12   223 204             62         427 352 5 46   1 8     3   12   223 204         62       427
1726237 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 346 5 38   1 11     1   14   229 187             61         416 346 5 38   1 11     1   14   229 187         61       416
1726238 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 1059 11 118   3 32     5   46   651 623             182         1274 1059 11 118   3 32     5   46   651 623         182       1274
1729879 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_1 51 0 5   0 0     0   0   27 29             22         56 51 0 5   0 0     0   0   27 29         22       56
1729880 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_10 33 0 4   0 0     0   1   11 27             7         38 33 0 4   0 0     0   1   11 27         7       38
1729881 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_11 34 0 6   0 2     0   1   17 26             9         43 34 0 6   0 2     0   1   17 26         9       43
1729882 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_12 19 1 5   0 1     0   1   11 16             6         27 19 1 5   0 1     0   1   11 16         6       27
1729883 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_2 46 0 7   0 2     0   1   29 27             18         56 46 0 7   0 2     0   1   29 27         18       56
1729884 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_3 49 0 4   0 3     0   0   26 30             18         56 49 0 4   0 3     0   0   26 30         18       56
1729885 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_4 60 0 5   0 0     0   1   29 37             21         66 60 0 5   0 0     0   1   29 37         21       66
1729886 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_5 61 1 3   0 0     0   0   35 30             19         65 61 1 3   0 0     0   0   35 30         19       65
1729887 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_6 54 0 5   1 4     0   1   24 41             20         65 54 0 5   1 4     0   1   24 41         20       65

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