Data source: Big Local News · About: Big Local

14,658 rows where state = "UT" and year = 2021 sorted by district_nces_id descending

View and edit SQL

grade

year

  • 2021 · 14,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
1350991 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2021   k_12_total 650.0 7.0 69.0 0.0   15.0       1.0 29.0   365.0 406.0     21.0   0.0   130.0     103.0   771 650 7 69 0   15       1 29   365 406     21 0 130   103   771
1350992 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2021   k_12_total 1033.0 31.0 262.0 4.0   5.0       17.0 47.0   687.0 712.0     66.0   5.0   434.0     176.0   1399 1033 31 262 4   5       17 47   687 712     66 5 434   176   1399
1350993 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2021   k_12_total 398.0 15.0 132.0 0.0   3.0       6.0 15.0   288.0 281.0     66.0   3.0   261.0     85.0   569 398 15 132 0   3       6 15   288 281     66 3 261   85   569
1350994 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
1350995 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2021   k_12_total 533.0 6.0 56.0 4.0   4.0       2.0 19.0   315.0 309.0     30.0   1.0   127.0     82.0   624 533 6 56 4   4       2 19   315 309     30 1 127   82   624
1350996 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2021   k_12_total 698.0 1.0 49.0 2.0   1.0       0.0 22.0   378.0 395.0     8.0   2.0   89.0     88.0   773 698 1 49 2   1       0 22   378 395     8 2 89   88   773
1350997 UT     school 4901200 35 District Weber District 490120000781 115 Freedom School   Regular School No Elementary KG 06 2021   k_12_total 613.0 4.0 155.0 3.0   7.0       8.0 30.0   394.0 426.0     36.0   8.0   191.0     104.0   820 613 4 155 3   7       8 30   394 426     36 8 191   104   820
1350998 UT     school 4901200 35 District Weber District 490120000221 706 Fremont High   Regular School No High 10 12 2021   k_12_total 1847.0 8.0 137.0 4.0   12.0       11.0 42.0   1076.0 985.0     18.0   3.0   246.0     220.0   2061 1847 8 137 4   12       11 42   1076 985     18 3 246   220   2061
1350999 UT     school 4901200 35 District Weber District 490120000616 111 Green Acres School   Regular School No Elementary KG 06 2021   k_12_total 440.0 2.0 47.0 0.0   4.0       2.0 8.0   276.0 227.0     16.0   0.0   142.0     85.0   503 440 2 47 0   4       2 8   276 227     16 0 142   85   503
1351000 UT     school 4901200 35 District Weber District 490120000617 110 H Guy Child School   Regular School No Elementary KG 06 2021   k_12_total 355.0 4.0 50.0 1.0   4.0       9.0 10.0   233.0 200.0     20.0   0.0   109.0     67.0   433 355 4 50 1   4       9 10   233 200     20 0 109   67   433
1351001 UT     school 4901200 35 District Weber District 490120000618 112 Hooper School   Regular School No Elementary KG 06 2021   k_12_total 643.0 0.0 33.0 2.0   0.0       1.0 8.0   360.0 327.0     3.0   8.0   98.0     89.0   687 643 0 33 2   0       1 8   360 327     3 8 98   89   687
1351002 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 06 12 2021   k_12_total 41.0 0.0 13.0 1.0   0.0       0.0 3.0   38.0 20.0     1.0   3.0   30.0     6.0   58 41 0 13 1   0       0 3   38 20     1 3 30   6   58
1351003 UT     school 4901200 35 District Weber District 490120000619 114 Kanesville School   Regular School No Elementary KG 06 2021   k_12_total 754.0 8.0 73.0 0.0   3.0       1.0 15.0   417.0 437.0     22.0   0.0   111.0     115.0   854 754 8 73 0   3       1 15   417 437     22 0 111   115   854
1351004 UT     school 4901200 35 District Weber District 490120000620 116 Lakeview School   Regular School No Elementary KG 06 2021   k_12_total 320.0 4.0 75.0 1.0   9.0       10.0 11.0   223.0 207.0     41.0   3.0   180.0     59.0   430 320 4 75 1   9       10 11   223 207     41 3 180   59   430
1351005 UT     school 4901200 35 District Weber District 490120000621 120 Lomond View School   Regular School No Elementary KG 06 2021   k_12_total 436.0 3.0 11.0 1.0   5.0       0.0 3.0   236.0 223.0     3.0   0.0   46.0     56.0   459 436 3 11 1   5       0 3   236 223     3 0 46   56   459
1351006 UT     school 4901200 35 District Weber District 490120000573 121 Majestic School   Regular School No Elementary KG 06 2021   k_12_total 597.0 7.0 115.0 1.0   8.0       2.0 22.0   393.0 359.0     44.0   1.0   182.0     72.0   752 597 7 115 1   8       2 22   393 359     44 1 182   72   752
1351007 UT     school 4901200 35 District Weber District 490120000818 123 Midland School   Regular School No Elementary PK 06 2021   k_12_total 356.0 9.0 71.0 0.0   5.0       6.0 15.0   248.0 214.0     26.0   0.0   136.0     72.0   462 356 9 71 0   5       6 15   248 214     26 0 136   72   462
1351008 UT     school 4901200 35 District Weber District 490120000624 124 Municipal School   Regular School No Elementary KG 06 2021   k_12_total 244.0 2.0 80.0 2.0   3.0       5.0 5.0   152.0 189.0     36.0   2.0   145.0     63.0   341 244 2 80 2   3       5 5   152 189     36 2 145   63   341
1351009 UT     school 4901200 35 District Weber District 490120000625 402 North Ogden Jr High   Regular School No Middle 07 09 2021   k_12_total 801.0 0.0 85.0 4.0   17.0       2.0 24.0   458.0 475.0     15.0   2.0   195.0     109.0   933 801 0 85 4   17       2 24   458 475     15 2 195   109   933
1351010 UT     school 4901200 35 District Weber District 490120000626 128 North Ogden School   Regular School No Elementary KG 06 2021   k_12_total 488.0 3.0 50.0 0.0   4.0       0.0 14.0   273.0 286.0     20.0   0.0   136.0     68.0   559 488 3 50 0   4       0 14   273 286     20 0 136   68   559
1351011 UT     school 4901200 35 District Weber District 490120000627 132 North Park School   Regular School No Elementary KG 06 2021   k_12_total 309.0 3.0 88.0 5.0   11.0       4.0 27.0   224.0 223.0     25.0   1.0   211.0     75.0   447 309 3 88 5   11       4 27   224 223     25 1 211   75   447
1351012 UT     school 4901200 35 District Weber District 490120001546 142 Orchard Springs   Regular School No Elementary KG 06 2021   k_12_total 343.0 7.0 71.0 3.0   14.0       1.0 11.0   226.0 224.0     34.0   0.0   125.0     47.0   450 343 7 71 3   14       1 11   226 224     34 0 125   47   450
1351013 UT     school 4901200 35 District Weber District 490120000967 405 Orion Jr High   Regular School No Middle 07 09 2021   k_12_total 888.0 8.0 126.0 2.0   17.0       2.0 27.0   540.0 530.0     24.0   4.0   218.0     117.0   1070 888 8 126 2   17       2 27   540 530     24 4 218   117   1070
1351014 UT     school 4901200 35 District Weber District 490120000630 138 Pioneer School   Regular School No Elementary KG 06 2021   k_12_total 366.0 2.0 37.0 1.0   3.0       5.0 13.0   233.0 194.0     9.0   2.0   107.0     99.0   427 366 2 37 1   3       5 13   233 194     9 2 107   99   427
1351015 UT     school 4901200 35 District Weber District 490120000631 140 Plain City School   Regular School No Elementary KG 06 2021   k_12_total 625.0 1.0 15.0 1.0   2.0       2.0 4.0   321.0 329.0     6.0   2.0   76.0     83.0   650 625 1 15 1   2       2 4   321 329     6 2 76   83   650
1351016 UT     school 4901200 35 District Weber District 490120000632 144 Riverdale School   Regular School No Elementary KG 06 2021   k_12_total 295.0 3.0 99.0 1.0   7.0       4.0 14.0   228.0 195.0     39.0   0.0   162.0     38.0   423 295 3 99 1   7       4 14   228 195     39 0 162   38   423
1351017 UT     school 4901200 35 District Weber District 490120000212 403 Rocky Mountain Jr High   Regular School No Middle 07 09 2021   k_12_total 981.0 12.0 87.0 3.0   10.0       4.0 33.0   556.0 574.0     20.0   1.0   175.0     157.0   1130 981 12 87 3   10       4 33   556 574     20 1 175   157   1130
1351018 UT     school 4901200 35 District Weber District 490120000633 148 Roosevelt School   Regular School No Elementary KG 06 2021   k_12_total 311.0 15.0 114.0 5.0   3.0       16.0 21.0   244.0 241.0     55.0   3.0   254.0     66.0   485 311 15 114 5   3       16 21   244 241     55 3 254   66   485
1351019 UT     school 4901200 35 District Weber District 490120000634 708 Roy High   Regular School No High 10 12 2021   k_12_total 1363.0 17.0 371.0 10.0   25.0       18.0 69.0   922.0 951.0     71.0   5.0   515.0     312.0   1873 1363 17 371 10   25       18 69   922 951     71 5 515   312   1873
1351020 UT     school 4901200 35 District Weber District 490120000635 404 Roy Jr High   Regular School No Middle 07 09 2021   k_12_total 698.0 11.0 204.0 9.0   10.0       13.0 36.0   502.0 479.0     40.0   4.0   357.0     138.0   981 698 11 204 9   10       13 36   502 479     40 4 357   138   981
1351021 UT     school 4901200 35 District Weber District 490120000636 152 Roy School   Regular School No Elementary KG 06 2021   k_12_total 332.0 5.0 132.0 2.0   3.0       12.0 19.0   266.0 239.0     35.0   1.0   260.0     60.0   505 332 5 132 2   3       12 19   266 239     35 1 260   60   505
1351022 UT     school 4901200 35 District Weber District 490120000637 406 Sand Ridge Jr High   Regular School No Middle 07 09 2021   k_12_total 611.0 12.0 196.0 7.0   13.0       7.0 30.0   440.0 436.0     41.0   9.0   302.0     147.0   876 611 12 196 7   13       7 30   440 436     41 9 302   147   876
1351023 UT     school 4901200 35 District Weber District 490120001552 141 Silver Ridge Elementary   Regular School No Elementary KG 06 2021   k_12_total 544.0 5.0 24.0 0.0   1.0       0.0 11.0   312.0 273.0     9.0   1.0   78.0     92.0   585 544 5 24 0   1       0 11   312 273     9 1 78   92   585
1351024 UT     school 4901200 35 District Weber District 490120000669 412 Snowcrest Jr High   Regular School No Middle 07 09 2021   k_12_total 276.0 4.0 8.0 2.0   1.0       0.0 5.0   167.0 129.0     0.0   0.0   23.0     22.0   296 276 4 8 2   1       0 5   167 129     0 0 23   22   296
1351025 UT     school 4901200 35 District Weber District 490120000638 408 South Ogden Jr High   Regular School No Middle 07 09 2021   k_12_total 687.0 10.0 150.0 6.0   13.0       10.0 35.0   451.0 460.0     42.0   0.0   253.0     97.0   911 687 10 150 6   13       10 35   451 460     42 0 253   97   911
1351026 UT     school 4901200 35 District Weber District 490120000639 410 T.H. Bell Jr High   Regular School No Middle 07 09 2021   k_12_total 441.0 12.0 165.0 2.0   8.0       10.0 24.0   363.0 299.0     60.0   7.0   283.0     110.0   662 441 12 165 2   8       10 24   363 299     60 7 283   110   662
1351027 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 07 12 2021   k_12_total 108.0 1.0 35.0 0.0   0.0       0.0 6.0   77.0 73.0     6.0   2.0   53.0     19.0   150 108 1 35 0   0       0 6   77 73     6 2 53   19   150
1351028 UT     school 4901200 35 District Weber District 490120000640 154 Uintah School   Regular School No Elementary KG 06 2021   k_12_total 587.0 5.0 64.0 0.0   11.0       5.0 20.0   335.0 357.0     25.0   7.0   169.0     83.0   692 587 5 64 0   11       5 20   335 357     25 7 169   83   692
1351029 UT     school 4901200 35 District Weber District 490120000641 156 Valley School   Regular School No Elementary KG 06 2021   k_12_total 544.0 2.0 15.0 1.0   0.0       1.0 10.0   288.0 285.0     0.0   2.0   53.0     67.0   573 544 2 15 1   0       1 10   288 285     0 2 53   67   573
1351030 UT     school 4901200 35 District Weber District 490120000642 158 Valley View School   Regular School No Elementary KG 06 2021   k_12_total 254.0 4.0 100.0 0.0   4.0       2.0 12.0   205.0 171.0     56.0   0.0   162.0     62.0   376 254 4 100 0   4       2 12   205 171     56 0 162   62   376
1351031 UT     school 4901200 35 District Weber District 490120000643 416 Wahlquist Jr High   Regular School No Middle 07 09 2021   k_12_total 1124.0 6.0 76.0 0.0   3.0       2.0 22.0   629.0 604.0     15.0   4.0   165.0     128.0   1233 1124 6 76 0   3       2 22   629 604     15 4 165   128   1233
1351032 UT     school 4901200 35 District Weber District 490120000644 160 Washington Terrace School   Regular School No Elementary KG 06 2021   k_12_total 355.0 5.0 126.0 6.0   5.0       4.0 16.0   269.0 248.0     72.0   3.0   238.0     88.0   517 355 5 126 6   5       4 16   269 248     72 3 238   88   517
1351033 UT     school 4901200 35 District Weber District 490120000645 704 Weber High   Regular School No High 10 12 2021   k_12_total 1803.0 8.0 204.0 6.0   18.0       8.0 54.0   1031.0 1070.0     25.0   3.0   336.0     232.0   2101 1803 8 204 6   18       8 54   1031 1070     25 3 336   232   2101
1351034 UT     school 4901200 35 District Weber District 490120001482 725 Weber Innovation High School   Regular School No High 09 12 2021   k_12_total 216.0 1.0 21.0 1.0   3.0       0.0 8.0   115.0 135.0     1.0   1.0   38.0     7.0   250 216 1 21 1   3       0 8   115 135     1 1 38   7   250
1351035 UT     school 4901200 35 District Weber District 490120001414 199 Weber Online K-6   Regular School No Elementary KG 06 2021   k_12_total 17.0 0.0 2.0 1.0   0.0       0.0 0.0   8.0 12.0     1.0   0.0   3.0     1.0   20 17 0 2 1   0       0 0   8 12     1 0 3   1   20
1351036 UT     school 4901200 35 District Weber District 490120001108 162 West Haven School   Regular School No Elementary KG 06 2021   k_12_total 384.0 11.0 87.0 0.0   7.0       6.0 30.0   262.0 263.0     36.0   12.0   186.0     82.0   525 384 11 87 0   7       6 30   262 263     36 12 186   82   525
1351037 UT     school 4901200 35 District Weber District 490120000646 164 West Weber School   Regular School No Elementary KG 06 2021   k_12_total 468.0 2.0 25.0 0.0   0.0       2.0 4.0   261.0 240.0     8.0   0.0   86.0     79.0   501 468 2 25 0   0       2 4   261 240     8 0 86   79   501
1352038 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2021   kindergarten                                                   92                                             92
1352039 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2021   kindergarten                                                   0                                             0
1352040 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2021   kindergarten                                                   82                                             82
1352041 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1352042 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2021   kindergarten                                                   74                                             74
1352043 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2021   kindergarten                                                   109                                             109
1352044 UT     school 4901200 35 District Weber District 490120000781 115 Freedom School   Regular School No Elementary KG 06 2021   kindergarten                                                   104                                             104
1352045 UT     school 4901200 35 District Weber District 490120000221 706 Fremont High   Regular School No High 10 12 2021   kindergarten                                                   0                                             0
1352046 UT     school 4901200 35 District Weber District 490120000616 111 Green Acres School   Regular School No Elementary KG 06 2021   kindergarten                                                   70                                             70
1352047 UT     school 4901200 35 District Weber District 490120000617 110 H Guy Child School   Regular School No Elementary KG 06 2021   kindergarten                                                   50                                             50
1352048 UT     school 4901200 35 District Weber District 490120000618 112 Hooper School   Regular School No Elementary KG 06 2021   kindergarten                                                   89                                             89
1352049 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 06 12 2021   kindergarten                                                   0                                             0
1352050 UT     school 4901200 35 District Weber District 490120000619 114 Kanesville School   Regular School No Elementary KG 06 2021   kindergarten                                                   102                                             102
1352051 UT     school 4901200 35 District Weber District 490120000620 116 Lakeview School   Regular School No Elementary KG 06 2021   kindergarten                                                   65                                             65
1352052 UT     school 4901200 35 District Weber District 490120000621 120 Lomond View School   Regular School No Elementary KG 06 2021   kindergarten                                                   59                                             59
1352053 UT     school 4901200 35 District Weber District 490120000573 121 Majestic School   Regular School No Elementary KG 06 2021   kindergarten                                                   89                                             89
1352054 UT     school 4901200 35 District Weber District 490120000818 123 Midland School   Regular School No Elementary PK 06 2021   kindergarten                                                   60                                             60
1352055 UT     school 4901200 35 District Weber District 490120000624 124 Municipal School   Regular School No Elementary KG 06 2021   kindergarten                                                   62                                             62
1352056 UT     school 4901200 35 District Weber District 490120000625 402 North Ogden Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352057 UT     school 4901200 35 District Weber District 490120000626 128 North Ogden School   Regular School No Elementary KG 06 2021   kindergarten                                                   85                                             85
1352058 UT     school 4901200 35 District Weber District 490120000627 132 North Park School   Regular School No Elementary KG 06 2021   kindergarten                                                   70                                             70
1352059 UT     school 4901200 35 District Weber District 490120001546 142 Orchard Springs   Regular School No Elementary KG 06 2021   kindergarten                                                   48                                             48
1352060 UT     school 4901200 35 District Weber District 490120000967 405 Orion Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352061 UT     school 4901200 35 District Weber District 490120000630 138 Pioneer School   Regular School No Elementary KG 06 2021   kindergarten                                                   57                                             57
1352062 UT     school 4901200 35 District Weber District 490120000631 140 Plain City School   Regular School No Elementary KG 06 2021   kindergarten                                                   86                                             86
1352063 UT     school 4901200 35 District Weber District 490120000632 144 Riverdale School   Regular School No Elementary KG 06 2021   kindergarten                                                   42                                             42
1352064 UT     school 4901200 35 District Weber District 490120000212 403 Rocky Mountain Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352065 UT     school 4901200 35 District Weber District 490120000633 148 Roosevelt School   Regular School No Elementary KG 06 2021   kindergarten                                                   69                                             69
1352066 UT     school 4901200 35 District Weber District 490120000634 708 Roy High   Regular School No High 10 12 2021   kindergarten                                                   0                                             0
1352067 UT     school 4901200 35 District Weber District 490120000635 404 Roy Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352068 UT     school 4901200 35 District Weber District 490120000636 152 Roy School   Regular School No Elementary KG 06 2021   kindergarten                                                   87                                             87
1352069 UT     school 4901200 35 District Weber District 490120000637 406 Sand Ridge Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352070 UT     school 4901200 35 District Weber District 490120001552 141 Silver Ridge Elementary   Regular School No Elementary KG 06 2021   kindergarten                                                   75                                             75
1352071 UT     school 4901200 35 District Weber District 490120000669 412 Snowcrest Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352072 UT     school 4901200 35 District Weber District 490120000638 408 South Ogden Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352073 UT     school 4901200 35 District Weber District 490120000639 410 T.H. Bell Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352074 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 07 12 2021   kindergarten                                                   0                                             0
1352075 UT     school 4901200 35 District Weber District 490120000640 154 Uintah School   Regular School No Elementary KG 06 2021   kindergarten                                                   78                                             78
1352076 UT     school 4901200 35 District Weber District 490120000641 156 Valley School   Regular School No Elementary KG 06 2021   kindergarten                                                   83                                             83
1352077 UT     school 4901200 35 District Weber District 490120000642 158 Valley View School   Regular School No Elementary KG 06 2021   kindergarten                                                   44                                             44
1352078 UT     school 4901200 35 District Weber District 490120000643 416 Wahlquist Jr High   Regular School No Middle 07 09 2021   kindergarten                                                   0                                             0
1352079 UT     school 4901200 35 District Weber District 490120000644 160 Washington Terrace School   Regular School No Elementary KG 06 2021   kindergarten                                                   57                                             57
1352080 UT     school 4901200 35 District Weber District 490120000645 704 Weber High   Regular School No High 10 12 2021   kindergarten                                                   0                                             0
1352081 UT     school 4901200 35 District Weber District 490120001482 725 Weber Innovation High School   Regular School No High 09 12 2021   kindergarten                                                   0                                             0
1352082 UT     school 4901200 35 District Weber District 490120001414 199 Weber Online K-6   Regular School No Elementary KG 06 2021   kindergarten                                                   1                                             1
1352083 UT     school 4901200 35 District Weber District 490120001108 162 West Haven School   Regular School No Elementary KG 06 2021   kindergarten                                                   68                                             68
1352084 UT     school 4901200 35 District Weber District 490120000646 164 West Weber School   Regular School No Elementary KG 06 2021   kindergarten                                                   55                                             55
1353085 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2021   grade_1                                                   90                                             90
1353086 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2021   grade_1                                                   0                                             0
1353087 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2021   grade_1                                                   84                                             84
1353088 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2021   grade_1                                                   0                                             0
1353089 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2021   grade_1                                                   83                                             83
1353090 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2021   grade_1                                                   98                                             98

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