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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 30
date (date) >30 ✖
- 2020-09-10 30
- 2020-09-11 30
- 2020-09-12 30
- 2020-09-13 30
- 2020-09-14 30
- 2020-09-15 30
- 2020-09-16 30
- 2020-09-17 30
- 2020-09-18 30
- 2020-09-19 30
- 2020-09-20 30
- 2020-09-21 30
- 2020-09-22 30
- 2020-09-23 30
- 2020-09-24 30
- 2020-09-25 30
- 2020-09-26 30
- 2020-09-27 30
- 2020-09-28 30
- 2020-09-29 30
- 2020-09-30 30
- 2020-10-01 30
- 2020-10-02 30
- 2020-10-03 30
- 2020-10-04 30
- 2020-10-05 30
- 2020-10-06 30
- 2020-10-07 30
- 2020-10-08 30
- 2020-10-09 30
- …
county 30
- Salt Lake 809
- Davis 799
- Washington 799
- Weber 795
- Summit 791
- Utah 790
- Tooele 789
- Wasatch 789
- Box Elder 787
- Cache 787
- 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,919 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
311 | 311 | 2020-02-25 | Salt Lake | Utah | 49035 | 1 | 0 |
331 | 331 | 2020-02-26 | Salt Lake | Utah | 49035 | 1 | 0 |
351 | 351 | 2020-02-27 | Salt Lake | Utah | 49035 | 1 | 0 |
372 | 372 | 2020-02-28 | Salt Lake | Utah | 49035 | 1 | 0 |
394 | 394 | 2020-02-29 | Salt Lake | Utah | 49035 | 1 | 0 |
421 | 421 | 2020-03-01 | Salt Lake | Utah | 49035 | 1 | 0 |
453 | 453 | 2020-03-02 | Salt Lake | Utah | 49035 | 1 | 0 |
488 | 488 | 2020-03-03 | Salt Lake | Utah | 49035 | 1 | 0 |
526 | 526 | 2020-03-04 | Salt Lake | Utah | 49035 | 1 | 0 |
575 | 575 | 2020-03-05 | Salt Lake | Utah | 49035 | 1 | 0 |
644 | 644 | 2020-03-06 | Davis | Utah | 49011 | 1 | 0 |
645 | 645 | 2020-03-06 | Salt Lake | Utah | 49035 | 1 | 0 |
646 | 646 | 2020-03-06 | Washington | Utah | 49053 | 1 | 0 |
736 | 736 | 2020-03-07 | Davis | Utah | 49011 | 1 | 0 |
737 | 737 | 2020-03-07 | Salt Lake | Utah | 49035 | 1 | 0 |
738 | 738 | 2020-03-07 | Washington | Utah | 49053 | 1 | 0 |
848 | 848 | 2020-03-08 | Davis | Utah | 49011 | 1 | 0 |
849 | 849 | 2020-03-08 | Salt Lake | Utah | 49035 | 1 | 0 |
850 | 850 | 2020-03-08 | Washington | Utah | 49053 | 1 | 0 |
978 | 978 | 2020-03-09 | Davis | Utah | 49011 | 1 | 0 |
979 | 979 | 2020-03-09 | Salt Lake | Utah | 49035 | 1 | 0 |
980 | 980 | 2020-03-09 | Washington | Utah | 49053 | 1 | 0 |
1139 | 1139 | 2020-03-10 | Davis | Utah | 49011 | 1 | 0 |
1140 | 1140 | 2020-03-10 | Salt Lake | Utah | 49035 | 1 | 0 |
1141 | 1141 | 2020-03-10 | Washington | Utah | 49053 | 1 | 0 |
1142 | 1142 | 2020-03-10 | Weber | Utah | 49057 | 1 | 0 |
1336 | 1336 | 2020-03-11 | Davis | Utah | 49011 | 1 | 0 |
1337 | 1337 | 2020-03-11 | Salt Lake | Utah | 49035 | 2 | 0 |
1338 | 1338 | 2020-03-11 | Washington | Utah | 49053 | 1 | 0 |
1339 | 1339 | 2020-03-11 | Weber | Utah | 49057 | 1 | 0 |
1583 | 1583 | 2020-03-12 | Davis | Utah | 49011 | 1 | 0 |
1584 | 1584 | 2020-03-12 | Salt Lake | Utah | 49035 | 4 | 0 |
1585 | 1585 | 2020-03-12 | Washington | Utah | 49053 | 1 | 0 |
1586 | 1586 | 2020-03-12 | Weber | Utah | 49057 | 1 | 0 |
1892 | 1892 | 2020-03-13 | Davis | Utah | 49011 | 1 | 0 |
1893 | 1893 | 2020-03-13 | Salt Lake | Utah | 49035 | 4 | 0 |
1894 | 1894 | 2020-03-13 | Washington | Utah | 49053 | 1 | 0 |
1895 | 1895 | 2020-03-13 | Weber | Utah | 49057 | 1 | 0 |
2259 | 2259 | 2020-03-14 | Davis | Utah | 49011 | 2 | 0 |
2260 | 2260 | 2020-03-14 | Salt Lake | Utah | 49035 | 15 | 0 |
2261 | 2261 | 2020-03-14 | Summit | Utah | 49043 | 2 | 0 |
2262 | 2262 | 2020-03-14 | Washington | Utah | 49053 | 1 | 0 |
2263 | 2263 | 2020-03-14 | Weber | Utah | 49057 | 1 | 0 |
2685 | 2685 | 2020-03-15 | Davis | Utah | 49011 | 3 | 0 |
2686 | 2686 | 2020-03-15 | Salt Lake | Utah | 49035 | 15 | 0 |
2687 | 2687 | 2020-03-15 | Summit | Utah | 49043 | 8 | 0 |
2688 | 2688 | 2020-03-15 | Utah | Utah | 49049 | 1 | 0 |
2689 | 2689 | 2020-03-15 | Washington | Utah | 49053 | 1 | 0 |
2690 | 2690 | 2020-03-15 | Weber | Utah | 49057 | 1 | 0 |
3154 | 3154 | 2020-03-16 | Davis | Utah | 49011 | 4 | 0 |
3155 | 3155 | 2020-03-16 | Salt Lake | Utah | 49035 | 20 | 0 |
3156 | 3156 | 2020-03-16 | Summit | Utah | 49043 | 11 | 0 |
3157 | 3157 | 2020-03-16 | Tooele | Utah | 49045 | 1 | 0 |
3158 | 3158 | 2020-03-16 | Utah | Utah | 49049 | 1 | 0 |
3159 | 3159 | 2020-03-16 | Wasatch | Utah | 49051 | 1 | 0 |
3160 | 3160 | 2020-03-16 | Washington | Utah | 49053 | 1 | 0 |
3161 | 3161 | 2020-03-16 | Weber | Utah | 49057 | 1 | 0 |
3690 | 3690 | 2020-03-17 | Davis | Utah | 49011 | 4 | 0 |
3691 | 3691 | 2020-03-17 | Salt Lake | Utah | 49035 | 23 | 0 |
3692 | 3692 | 2020-03-17 | Summit | Utah | 49043 | 15 | 0 |
3693 | 3693 | 2020-03-17 | Tooele | Utah | 49045 | 1 | 0 |
3694 | 3694 | 2020-03-17 | Utah | Utah | 49049 | 1 | 0 |
3695 | 3695 | 2020-03-17 | Wasatch | Utah | 49051 | 2 | 0 |
3696 | 3696 | 2020-03-17 | Washington | Utah | 49053 | 1 | 0 |
3697 | 3697 | 2020-03-17 | Weber | Utah | 49057 | 4 | 0 |
4320 | 4320 | 2020-03-18 | Box Elder | Utah | 49003 | 1 | 0 |
4321 | 4321 | 2020-03-18 | Cache | Utah | 49005 | 2 | 0 |
4322 | 4322 | 2020-03-18 | Davis | Utah | 49011 | 6 | 0 |
4323 | 4323 | 2020-03-18 | Salt Lake | Utah | 49035 | 24 | 0 |
4324 | 4324 | 2020-03-18 | Summit | Utah | 49043 | 22 | 0 |
4325 | 4325 | 2020-03-18 | Tooele | Utah | 49045 | 1 | 0 |
4326 | 4326 | 2020-03-18 | Utah | Utah | 49049 | 2 | 0 |
4327 | 4327 | 2020-03-18 | Wasatch | Utah | 49051 | 2 | 0 |
4328 | 4328 | 2020-03-18 | Washington | Utah | 49053 | 1 | 0 |
4329 | 4329 | 2020-03-18 | Weber | Utah | 49057 | 4 | 0 |
5076 | 5076 | 2020-03-19 | Box Elder | Utah | 49003 | 1 | 0 |
5077 | 5077 | 2020-03-19 | Cache | Utah | 49005 | 2 | 0 |
5078 | 5078 | 2020-03-19 | Davis | Utah | 49011 | 8 | 0 |
5079 | 5079 | 2020-03-19 | Salt Lake | Utah | 49035 | 31 | 0 |
5080 | 5080 | 2020-03-19 | Summit | Utah | 49043 | 26 | 0 |
5081 | 5081 | 2020-03-19 | Tooele | Utah | 49045 | 1 | 0 |
5082 | 5082 | 2020-03-19 | Utah | Utah | 49049 | 3 | 0 |
5083 | 5083 | 2020-03-19 | Wasatch | Utah | 49051 | 3 | 0 |
5084 | 5084 | 2020-03-19 | Washington | Utah | 49053 | 1 | 0 |
5085 | 5085 | 2020-03-19 | Weber | Utah | 49057 | 4 | 0 |
5970 | 5970 | 2020-03-20 | Box Elder | Utah | 49003 | 1 | 0 |
5971 | 5971 | 2020-03-20 | Cache | Utah | 49005 | 2 | 0 |
5972 | 5972 | 2020-03-20 | Davis | Utah | 49011 | 12 | 0 |
5973 | 5973 | 2020-03-20 | Salt Lake | Utah | 49035 | 46 | 0 |
5974 | 5974 | 2020-03-20 | Summit | Utah | 49043 | 35 | 0 |
5975 | 5975 | 2020-03-20 | Tooele | Utah | 49045 | 2 | 0 |
5976 | 5976 | 2020-03-20 | Utah | Utah | 49049 | 3 | 0 |
5977 | 5977 | 2020-03-20 | Wasatch | Utah | 49051 | 4 | 0 |
5978 | 5978 | 2020-03-20 | Washington | Utah | 49053 | 1 | 0 |
5979 | 5979 | 2020-03-20 | Weber | Utah | 49057 | 6 | 0 |
6993 | 6993 | 2020-03-21 | Box Elder | Utah | 49003 | 1 | 0 |
6994 | 6994 | 2020-03-21 | Cache | Utah | 49005 | 2 | 0 |
6995 | 6995 | 2020-03-21 | Davis | Utah | 49011 | 16 | 0 |
6996 | 6996 | 2020-03-21 | Salt Lake | Utah | 49035 | 60 | 0 |
6997 | 6997 | 2020-03-21 | Summit | Utah | 49043 | 35 | 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);