ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22,919 rows where state = "Utah" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 30
county 30
- Tooele 784
- Utah 784
- Wasatch 784
- Washington 784
- Weber 784
- Box Elder 783
- Cache 783
- Davis 783
- Salt Lake 783
- Summit 783
- Iron 782
- Morgan 779
- Uintah 778
- Garfield 777
- San Juan 777
- Unknown 775
- Kane 772
- Carbon 771
- Duchesne 771
- Emery 771
- Grand 771
- Juab 771
- Millard 771
- Sevier 759
- Sanpete 756
- Piute 737
- Rich 701
- Beaver 698
- Wayne 656
- Daggett 611
state 1
- Utah · 22,819 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6998 | 6998 | 2020-03-21 | Tooele | Utah | 49045 | 2 | 0 |
6999 | 6999 | 2020-03-21 | Utah | Utah | 49049 | 7 | 0 |
7000 | 7000 | 2020-03-21 | Wasatch | Utah | 49051 | 7 | 0 |
7001 | 7001 | 2020-03-21 | Washington | Utah | 49053 | 2 | 0 |
7002 | 7002 | 2020-03-21 | Weber | Utah | 49057 | 6 | 0 |
8123 | 8123 | 2020-03-22 | Box Elder | Utah | 49003 | 1 | 0 |
8124 | 8124 | 2020-03-22 | Cache | Utah | 49005 | 2 | 0 |
8125 | 8125 | 2020-03-22 | Davis | Utah | 49011 | 19 | 1 |
8126 | 8126 | 2020-03-22 | Salt Lake | Utah | 49035 | 84 | 0 |
8127 | 8127 | 2020-03-22 | Summit | Utah | 49043 | 50 | 0 |
8128 | 8128 | 2020-03-22 | Tooele | Utah | 49045 | 3 | 0 |
8129 | 8129 | 2020-03-22 | Utah | Utah | 49049 | 7 | 0 |
8130 | 8130 | 2020-03-22 | Wasatch | Utah | 49051 | 8 | 0 |
8131 | 8131 | 2020-03-22 | Washington | Utah | 49053 | 2 | 0 |
8132 | 8132 | 2020-03-22 | Weber | Utah | 49057 | 6 | 0 |
9342 | 9342 | 2020-03-23 | Box Elder | Utah | 49003 | 1 | 0 |
9343 | 9343 | 2020-03-23 | Cache | Utah | 49005 | 3 | 0 |
9344 | 9344 | 2020-03-23 | Davis | Utah | 49011 | 29 | 1 |
9345 | 9345 | 2020-03-23 | Iron | Utah | 49021 | 1 | 0 |
9346 | 9346 | 2020-03-23 | Salt Lake | Utah | 49035 | 112 | 0 |
9347 | 9347 | 2020-03-23 | Summit | Utah | 49043 | 73 | 0 |
9348 | 9348 | 2020-03-23 | Tooele | Utah | 49045 | 3 | 0 |
9349 | 9349 | 2020-03-23 | Utah | Utah | 49049 | 12 | 0 |
9350 | 9350 | 2020-03-23 | Wasatch | Utah | 49051 | 11 | 0 |
9351 | 9351 | 2020-03-23 | Washington | Utah | 49053 | 4 | 0 |
9352 | 9352 | 2020-03-23 | Weber | Utah | 49057 | 8 | 0 |
10686 | 10686 | 2020-03-24 | Box Elder | Utah | 49003 | 1 | 0 |
10687 | 10687 | 2020-03-24 | Cache | Utah | 49005 | 3 | 0 |
10688 | 10688 | 2020-03-24 | Davis | Utah | 49011 | 31 | 1 |
10689 | 10689 | 2020-03-24 | Iron | Utah | 49021 | 1 | 0 |
10690 | 10690 | 2020-03-24 | Salt Lake | Utah | 49035 | 127 | 0 |
10691 | 10691 | 2020-03-24 | Summit | Utah | 49043 | 90 | 0 |
10692 | 10692 | 2020-03-24 | Tooele | Utah | 49045 | 3 | 0 |
10693 | 10693 | 2020-03-24 | Utah | Utah | 49049 | 14 | 0 |
10694 | 10694 | 2020-03-24 | Wasatch | Utah | 49051 | 16 | 0 |
10695 | 10695 | 2020-03-24 | Washington | Utah | 49053 | 4 | 0 |
10696 | 10696 | 2020-03-24 | Weber | Utah | 49057 | 9 | 0 |
12196 | 12196 | 2020-03-25 | Box Elder | Utah | 49003 | 2 | 0 |
12197 | 12197 | 2020-03-25 | Cache | Utah | 49005 | 4 | 0 |
12198 | 12198 | 2020-03-25 | Davis | Utah | 49011 | 35 | 1 |
12199 | 12199 | 2020-03-25 | Iron | Utah | 49021 | 1 | 0 |
12200 | 12200 | 2020-03-25 | Salt Lake | Utah | 49035 | 151 | 0 |
12201 | 12201 | 2020-03-25 | Summit | Utah | 49043 | 90 | 0 |
12202 | 12202 | 2020-03-25 | Tooele | Utah | 49045 | 3 | 0 |
12203 | 12203 | 2020-03-25 | Unknown | Utah | 10 | 0 | |
12204 | 12204 | 2020-03-25 | Utah | Utah | 49049 | 18 | 0 |
12205 | 12205 | 2020-03-25 | Wasatch | Utah | 49051 | 16 | 0 |
12206 | 12206 | 2020-03-25 | Washington | Utah | 49053 | 6 | 0 |
12207 | 12207 | 2020-03-25 | Weber | Utah | 49057 | 10 | 0 |
13831 | 13831 | 2020-03-26 | Box Elder | Utah | 49003 | 2 | 0 |
13832 | 13832 | 2020-03-26 | Cache | Utah | 49005 | 4 | 0 |
13833 | 13833 | 2020-03-26 | Davis | Utah | 49011 | 39 | 1 |
13834 | 13834 | 2020-03-26 | Iron | Utah | 49021 | 2 | 0 |
13835 | 13835 | 2020-03-26 | Morgan | Utah | 49029 | 2 | 0 |
13836 | 13836 | 2020-03-26 | Salt Lake | Utah | 49035 | 181 | 0 |
13837 | 13837 | 2020-03-26 | Summit | Utah | 49043 | 103 | 0 |
13838 | 13838 | 2020-03-26 | Tooele | Utah | 49045 | 4 | 0 |
13839 | 13839 | 2020-03-26 | Unknown | Utah | 5 | 0 | |
13840 | 13840 | 2020-03-26 | Utah | Utah | 49049 | 25 | 0 |
13841 | 13841 | 2020-03-26 | Wasatch | Utah | 49051 | 21 | 0 |
13842 | 13842 | 2020-03-26 | Washington | Utah | 49053 | 6 | 0 |
13843 | 13843 | 2020-03-26 | Weber | Utah | 49057 | 8 | 0 |
15596 | 15596 | 2020-03-27 | Box Elder | Utah | 49003 | 2 | 0 |
15597 | 15597 | 2020-03-27 | Cache | Utah | 49005 | 5 | 0 |
15598 | 15598 | 2020-03-27 | Davis | Utah | 49011 | 50 | 1 |
15599 | 15599 | 2020-03-27 | Iron | Utah | 49021 | 2 | 0 |
15600 | 15600 | 2020-03-27 | Morgan | Utah | 49029 | 2 | 0 |
15601 | 15601 | 2020-03-27 | Salt Lake | Utah | 49035 | 212 | 0 |
15602 | 15602 | 2020-03-27 | Summit | Utah | 49043 | 110 | 0 |
15603 | 15603 | 2020-03-27 | Tooele | Utah | 49045 | 5 | 0 |
15604 | 15604 | 2020-03-27 | Uintah | Utah | 49047 | 1 | 0 |
15605 | 15605 | 2020-03-27 | Unknown | Utah | 17 | 1 | |
15606 | 15606 | 2020-03-27 | Utah | Utah | 49049 | 27 | 0 |
15607 | 15607 | 2020-03-27 | Wasatch | Utah | 49051 | 29 | 0 |
15608 | 15608 | 2020-03-27 | Washington | Utah | 49053 | 6 | 0 |
15609 | 15609 | 2020-03-27 | Weber | Utah | 49057 | 12 | 0 |
17468 | 17468 | 2020-03-28 | Box Elder | Utah | 49003 | 4 | 0 |
17469 | 17469 | 2020-03-28 | Cache | Utah | 49005 | 5 | 0 |
17470 | 17470 | 2020-03-28 | Davis | Utah | 49011 | 59 | 1 |
17471 | 17471 | 2020-03-28 | Garfield | Utah | 49017 | 1 | 0 |
17472 | 17472 | 2020-03-28 | Iron | Utah | 49021 | 4 | 0 |
17473 | 17473 | 2020-03-28 | Morgan | Utah | 49029 | 2 | 0 |
17474 | 17474 | 2020-03-28 | Salt Lake | Utah | 49035 | 276 | 0 |
17475 | 17475 | 2020-03-28 | San Juan | Utah | 49037 | 1 | 0 |
17476 | 17476 | 2020-03-28 | Summit | Utah | 49043 | 127 | 0 |
17477 | 17477 | 2020-03-28 | Tooele | Utah | 49045 | 8 | 0 |
17478 | 17478 | 2020-03-28 | Uintah | Utah | 49047 | 1 | 0 |
17479 | 17479 | 2020-03-28 | Unknown | Utah | 17 | 1 | |
17480 | 17480 | 2020-03-28 | Utah | Utah | 49049 | 30 | 0 |
17481 | 17481 | 2020-03-28 | Wasatch | Utah | 49051 | 36 | 0 |
17482 | 17482 | 2020-03-28 | Washington | Utah | 49053 | 8 | 0 |
17483 | 17483 | 2020-03-28 | Weber | Utah | 49057 | 29 | 0 |
19427 | 19427 | 2020-03-29 | Box Elder | Utah | 49003 | 4 | 0 |
19428 | 19428 | 2020-03-29 | Cache | Utah | 49005 | 5 | 0 |
19429 | 19429 | 2020-03-29 | Davis | Utah | 49011 | 69 | 1 |
19430 | 19430 | 2020-03-29 | Garfield | Utah | 49017 | 1 | 0 |
19431 | 19431 | 2020-03-29 | Iron | Utah | 49021 | 4 | 0 |
19432 | 19432 | 2020-03-29 | Morgan | Utah | 49029 | 2 | 0 |
19433 | 19433 | 2020-03-29 | Salt Lake | Utah | 49035 | 324 | 0 |
19434 | 19434 | 2020-03-29 | San Juan | Utah | 49037 | 4 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);