ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

22,919 rows where state = "Utah" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 30

county 30

state 1

  • Utah · 22,919 ✖
Link rowid date ▲ county state fips cases deaths
2502462 2502462 2022-05-13 Beaver Utah 49001 1609 16
2502463 2502463 2022-05-13 Box Elder Utah 49003 14144 124
2502464 2502464 2022-05-13 Cache Utah 49005 37265 109
2502465 2502465 2022-05-13 Carbon Utah 49007 5264 46
2502466 2502466 2022-05-13 Daggett Utah 49009 153 0
2502467 2502467 2022-05-13 Davis Utah 49011 101261 404
2502468 2502468 2022-05-13 Duchesne Utah 49013 4397 27
2502469 2502469 2022-05-13 Emery Utah 49015 2486 28
2502470 2502470 2022-05-13 Garfield Utah 49017 929 16
2502471 2502471 2022-05-13 Grand Utah 49019 2351 6
2502472 2502472 2022-05-13 Iron Utah 49021 14774 92
2502473 2502473 2022-05-13 Juab Utah 49023 2899 25
2502474 2502474 2022-05-13 Kane Utah 49025 1355 15
2502475 2502475 2022-05-13 Millard Utah 49027 3274 35
2502476 2502476 2022-05-13 Morgan Utah 49029 2903 15
2502477 2502477 2022-05-13 Piute Utah 49031 304 7
2502478 2502478 2022-05-13 Rich Utah 49033 343 0
2502479 2502479 2022-05-13 Salt Lake Utah 49035 346815 1637
2502480 2502480 2022-05-13 San Juan Utah 49037 4004 49
2502481 2502481 2022-05-13 Sanpete Utah 49039 8374 56
2502482 2502482 2022-05-13 Sevier Utah 49041 5448 30
2502483 2502483 2022-05-13 Summit Utah 49043 13832 26
2502484 2502484 2022-05-13 Tooele Utah 49045 21561 102
2502485 2502485 2022-05-13 Uintah Utah 49047 8071 72
2502486 2502486 2022-05-13 Unknown Utah   4044 92
2502487 2502487 2022-05-13 Utah Utah 49049 203286 791
2502488 2502488 2022-05-13 Wasatch Utah 49051 10804 35
2502489 2502489 2022-05-13 Washington Utah 49053 45053 463
2502490 2502490 2022-05-13 Wayne Utah 49055 444 0
2502491 2502491 2022-05-13 Weber Utah 49057 71645 443
2499204 2499204 2022-05-12 Beaver Utah 49001 1609 16
2499205 2499205 2022-05-12 Box Elder Utah 49003 14144 124
2499206 2499206 2022-05-12 Cache Utah 49005 37265 109
2499207 2499207 2022-05-12 Carbon Utah 49007 5264 46
2499208 2499208 2022-05-12 Daggett Utah 49009 153 0
2499209 2499209 2022-05-12 Davis Utah 49011 101261 404
2499210 2499210 2022-05-12 Duchesne Utah 49013 4397 27
2499211 2499211 2022-05-12 Emery Utah 49015 2486 28
2499212 2499212 2022-05-12 Garfield Utah 49017 929 16
2499213 2499213 2022-05-12 Grand Utah 49019 2351 6
2499214 2499214 2022-05-12 Iron Utah 49021 14774 92
2499215 2499215 2022-05-12 Juab Utah 49023 2899 25
2499216 2499216 2022-05-12 Kane Utah 49025 1355 15
2499217 2499217 2022-05-12 Millard Utah 49027 3274 35
2499218 2499218 2022-05-12 Morgan Utah 49029 2903 15
2499219 2499219 2022-05-12 Piute Utah 49031 304 7
2499220 2499220 2022-05-12 Rich Utah 49033 343 0
2499221 2499221 2022-05-12 Salt Lake Utah 49035 346815 1637
2499222 2499222 2022-05-12 San Juan Utah 49037 4004 49
2499223 2499223 2022-05-12 Sanpete Utah 49039 8374 56
2499224 2499224 2022-05-12 Sevier Utah 49041 5448 30
2499225 2499225 2022-05-12 Summit Utah 49043 13832 26
2499226 2499226 2022-05-12 Tooele Utah 49045 21561 102
2499227 2499227 2022-05-12 Uintah Utah 49047 8071 72
2499228 2499228 2022-05-12 Unknown Utah   4044 92
2499229 2499229 2022-05-12 Utah Utah 49049 203286 791
2499230 2499230 2022-05-12 Wasatch Utah 49051 10804 35
2499231 2499231 2022-05-12 Washington Utah 49053 45053 463
2499232 2499232 2022-05-12 Wayne Utah 49055 444 0
2499233 2499233 2022-05-12 Weber Utah 49057 71645 443
2495946 2495946 2022-05-11 Beaver Utah 49001 1609 16
2495947 2495947 2022-05-11 Box Elder Utah 49003 14134 124
2495948 2495948 2022-05-11 Cache Utah 49005 37254 109
2495949 2495949 2022-05-11 Carbon Utah 49007 5263 46
2495950 2495950 2022-05-11 Daggett Utah 49009 153 0
2495951 2495951 2022-05-11 Davis Utah 49011 101167 404
2495952 2495952 2022-05-11 Duchesne Utah 49013 4393 27
2495953 2495953 2022-05-11 Emery Utah 49015 2486 28
2495954 2495954 2022-05-11 Garfield Utah 49017 929 16
2495955 2495955 2022-05-11 Grand Utah 49019 2346 6
2495956 2495956 2022-05-11 Iron Utah 49021 14771 92
2495957 2495957 2022-05-11 Juab Utah 49023 2896 25
2495958 2495958 2022-05-11 Kane Utah 49025 1355 15
2495959 2495959 2022-05-11 Millard Utah 49027 3274 35
2495960 2495960 2022-05-11 Morgan Utah 49029 2903 15
2495961 2495961 2022-05-11 Piute Utah 49031 304 7
2495962 2495962 2022-05-11 Rich Utah 49033 342 0
2495963 2495963 2022-05-11 Salt Lake Utah 49035 346386 1638
2495964 2495964 2022-05-11 San Juan Utah 49037 3989 49
2495965 2495965 2022-05-11 Sanpete Utah 49039 8374 56
2495966 2495966 2022-05-11 Sevier Utah 49041 5447 30
2495967 2495967 2022-05-11 Summit Utah 49043 13775 26
2495968 2495968 2022-05-11 Tooele Utah 49045 21503 102
2495969 2495969 2022-05-11 Uintah Utah 49047 8068 72
2495970 2495970 2022-05-11 Unknown Utah   1988 90
2495971 2495971 2022-05-11 Utah Utah 49049 202690 791
2495972 2495972 2022-05-11 Wasatch Utah 49051 10788 35
2495973 2495973 2022-05-11 Washington Utah 49053 45032 463
2495974 2495974 2022-05-11 Wayne Utah 49055 444 0
2495975 2495975 2022-05-11 Weber Utah 49057 71645 443
2492688 2492688 2022-05-10 Beaver Utah 49001 1609 16
2492689 2492689 2022-05-10 Box Elder Utah 49003 14127 124
2492690 2492690 2022-05-10 Cache Utah 49005 37241 109
2492691 2492691 2022-05-10 Carbon Utah 49007 5258 46
2492692 2492692 2022-05-10 Daggett Utah 49009 153 0
2492693 2492693 2022-05-10 Davis Utah 49011 101080 404
2492694 2492694 2022-05-10 Duchesne Utah 49013 4391 27
2492695 2492695 2022-05-10 Emery Utah 49015 2485 28
2492696 2492696 2022-05-10 Garfield Utah 49017 929 16
2492697 2492697 2022-05-10 Grand Utah 49019 2340 6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);