ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 26 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502483 | 2502483 | 2022-05-13 | Summit | Utah | 49043 | 13832 | 26 |
2499225 | 2499225 | 2022-05-12 | Summit | Utah | 49043 | 13832 | 26 |
2495967 | 2495967 | 2022-05-11 | Summit | Utah | 49043 | 13775 | 26 |
2492709 | 2492709 | 2022-05-10 | Summit | Utah | 49043 | 13754 | 26 |
2489451 | 2489451 | 2022-05-09 | Summit | Utah | 49043 | 13744 | 26 |
2486193 | 2486193 | 2022-05-08 | Summit | Utah | 49043 | 13737 | 26 |
2482935 | 2482935 | 2022-05-07 | Summit | Utah | 49043 | 13737 | 26 |
2479677 | 2479677 | 2022-05-06 | Summit | Utah | 49043 | 13737 | 26 |
2476419 | 2476419 | 2022-05-05 | Summit | Utah | 49043 | 13737 | 26 |
2450356 | 2450356 | 2022-04-27 | Duchesne | Utah | 49013 | 4361 | 26 |
2447099 | 2447099 | 2022-04-26 | Duchesne | Utah | 49013 | 4361 | 26 |
2443844 | 2443844 | 2022-04-25 | Duchesne | Utah | 49013 | 4361 | 26 |
2440588 | 2440588 | 2022-04-24 | Duchesne | Utah | 49013 | 4358 | 26 |
2437332 | 2437332 | 2022-04-23 | Duchesne | Utah | 49013 | 4358 | 26 |
2434076 | 2434076 | 2022-04-22 | Duchesne | Utah | 49013 | 4358 | 26 |
2430820 | 2430820 | 2022-04-21 | Duchesne | Utah | 49013 | 4357 | 26 |
2427564 | 2427564 | 2022-04-20 | Duchesne | Utah | 49013 | 4356 | 26 |
2424308 | 2424308 | 2022-04-19 | Duchesne | Utah | 49013 | 4356 | 26 |
2421052 | 2421052 | 2022-04-18 | Duchesne | Utah | 49013 | 4349 | 26 |
2417796 | 2417796 | 2022-04-17 | Duchesne | Utah | 49013 | 4349 | 26 |
2414540 | 2414540 | 2022-04-16 | Duchesne | Utah | 49013 | 4349 | 26 |
2411284 | 2411284 | 2022-04-15 | Duchesne | Utah | 49013 | 4349 | 26 |
2408028 | 2408028 | 2022-04-14 | Duchesne | Utah | 49013 | 4349 | 26 |
2404772 | 2404772 | 2022-04-13 | Duchesne | Utah | 49013 | 4337 | 26 |
2401517 | 2401517 | 2022-04-12 | Duchesne | Utah | 49013 | 4337 | 26 |
2398262 | 2398262 | 2022-04-11 | Duchesne | Utah | 49013 | 4337 | 26 |
2395007 | 2395007 | 2022-04-10 | Duchesne | Utah | 49013 | 4337 | 26 |
2391751 | 2391751 | 2022-04-09 | Duchesne | Utah | 49013 | 4337 | 26 |
2388495 | 2388495 | 2022-04-08 | Duchesne | Utah | 49013 | 4337 | 26 |
2385240 | 2385240 | 2022-04-07 | Duchesne | Utah | 49013 | 4337 | 26 |
2381985 | 2381985 | 2022-04-06 | Duchesne | Utah | 49013 | 4334 | 26 |
2378730 | 2378730 | 2022-04-05 | Duchesne | Utah | 49013 | 4334 | 26 |
2375476 | 2375476 | 2022-04-04 | Duchesne | Utah | 49013 | 4334 | 26 |
2372224 | 2372224 | 2022-04-03 | Duchesne | Utah | 49013 | 4334 | 26 |
2368971 | 2368971 | 2022-04-02 | Duchesne | Utah | 49013 | 4334 | 26 |
2365718 | 2365718 | 2022-04-01 | Duchesne | Utah | 49013 | 4334 | 26 |
2362465 | 2362465 | 2022-03-31 | Duchesne | Utah | 49013 | 4334 | 26 |
2359211 | 2359211 | 2022-03-30 | Duchesne | Utah | 49013 | 4334 | 26 |
2355957 | 2355957 | 2022-03-29 | Duchesne | Utah | 49013 | 4334 | 26 |
2352704 | 2352704 | 2022-03-28 | Duchesne | Utah | 49013 | 4333 | 26 |
2349452 | 2349452 | 2022-03-27 | Duchesne | Utah | 49013 | 4331 | 26 |
2346199 | 2346199 | 2022-03-26 | Duchesne | Utah | 49013 | 4331 | 26 |
2342946 | 2342946 | 2022-03-25 | Duchesne | Utah | 49013 | 4331 | 26 |
2339693 | 2339693 | 2022-03-24 | Duchesne | Utah | 49013 | 4331 | 26 |
2336439 | 2336439 | 2022-03-23 | Duchesne | Utah | 49013 | 4331 | 26 |
2264895 | 2264895 | 2022-03-01 | Sevier | Utah | 49041 | 5414 | 26 |
2261645 | 2261645 | 2022-02-28 | Sevier | Utah | 49041 | 5413 | 26 |
2258394 | 2258394 | 2022-02-27 | Sevier | Utah | 49041 | 5402 | 26 |
2255143 | 2255143 | 2022-02-26 | Sevier | Utah | 49041 | 5402 | 26 |
2251892 | 2251892 | 2022-02-25 | Sevier | Utah | 49041 | 5402 | 26 |
2248641 | 2248641 | 2022-02-24 | Sevier | Utah | 49041 | 5400 | 26 |
2245390 | 2245390 | 2022-02-23 | Sevier | Utah | 49041 | 5397 | 26 |
1725294 | 1725294 | 2021-09-16 | Wasatch | Utah | 49051 | 5546 | 26 |
1722045 | 1722045 | 2021-09-15 | Wasatch | Utah | 49051 | 5526 | 26 |
1718797 | 1718797 | 2021-09-14 | Wasatch | Utah | 49051 | 5506 | 26 |
1715549 | 1715549 | 2021-09-13 | Wasatch | Utah | 49051 | 5486 | 26 |
1712303 | 1712303 | 2021-09-12 | Wasatch | Utah | 49051 | 5429 | 26 |
1709056 | 1709056 | 2021-09-11 | Wasatch | Utah | 49051 | 5429 | 26 |
1705809 | 1705809 | 2021-09-10 | Wasatch | Utah | 49051 | 5429 | 26 |
1702552 | 1702552 | 2021-09-09 | Sanpete | Utah | 49039 | 4640 | 26 |
1699303 | 1699303 | 2021-09-08 | Sanpete | Utah | 49039 | 4588 | 26 |
1696055 | 1696055 | 2021-09-07 | Sanpete | Utah | 49039 | 4563 | 26 |
1647334 | 1647334 | 2021-08-23 | Unknown | Utah | 1373 | 26 | |
1556376 | 1556376 | 2021-07-26 | Uintah | Utah | 49047 | 3280 | 26 |
1553129 | 1553129 | 2021-07-25 | Uintah | Utah | 49047 | 3238 | 26 |
1549882 | 1549882 | 2021-07-24 | Uintah | Utah | 49047 | 3238 | 26 |
1546635 | 1546635 | 2021-07-23 | Uintah | Utah | 49047 | 3238 | 26 |
1543388 | 1543388 | 2021-07-22 | Uintah | Utah | 49047 | 3238 | 26 |
1540140 | 1540140 | 2021-07-21 | Uintah | Utah | 49047 | 3233 | 26 |
1462223 | 1462223 | 2021-06-27 | Unknown | Utah | 1284 | 26 | |
1338882 | 1338882 | 2021-05-20 | Unknown | Utah | 1317 | 26 | |
1020689 | 1020689 | 2021-02-11 | Iron | Utah | 49021 | 4750 | 26 |
1017444 | 1017444 | 2021-02-10 | Iron | Utah | 49021 | 4750 | 26 |
1017456 | 1017456 | 2021-02-10 | Tooele | Utah | 49045 | 6160 | 26 |
1014199 | 1014199 | 2021-02-09 | Iron | Utah | 49021 | 4721 | 26 |
988224 | 988224 | 2021-02-01 | Cache | Utah | 49005 | 13824 | 26 |
984977 | 984977 | 2021-01-31 | Cache | Utah | 49005 | 13804 | 26 |
981730 | 981730 | 2021-01-30 | Cache | Utah | 49005 | 13765 | 26 |
887614 | 887614 | 2021-01-01 | Box Elder | Utah | 49003 | 3571 | 26 |
884369 | 884369 | 2020-12-31 | Box Elder | Utah | 49003 | 3571 | 26 |
881124 | 881124 | 2020-12-30 | Box Elder | Utah | 49003 | 3519 | 26 |
877879 | 877879 | 2020-12-29 | Box Elder | Utah | 49003 | 3464 | 26 |
579424 | 579424 | 2020-09-28 | Washington | Utah | 49053 | 3319 | 26 |
576183 | 576183 | 2020-09-27 | Washington | Utah | 49053 | 3292 | 26 |
572939 | 572939 | 2020-09-26 | Washington | Utah | 49053 | 3292 | 26 |
569697 | 569697 | 2020-09-25 | Washington | Utah | 49053 | 3269 | 26 |
517876 | 517876 | 2020-09-09 | Davis | Utah | 49011 | 4206 | 26 |
514641 | 514641 | 2020-09-08 | Davis | Utah | 49011 | 4182 | 26 |
511408 | 511408 | 2020-09-07 | Davis | Utah | 49011 | 4158 | 26 |
508175 | 508175 | 2020-09-06 | Davis | Utah | 49011 | 4136 | 26 |
446790 | 446790 | 2020-08-18 | San Juan | Utah | 49037 | 656 | 26 |
446801 | 446801 | 2020-08-18 | Weber | Utah | 49057 | 2983 | 26 |
443563 | 443563 | 2020-08-17 | San Juan | Utah | 49037 | 653 | 26 |
440337 | 440337 | 2020-08-16 | San Juan | Utah | 49037 | 653 | 26 |
437111 | 437111 | 2020-08-15 | San Juan | Utah | 49037 | 653 | 26 |
433885 | 433885 | 2020-08-14 | San Juan | Utah | 49037 | 655 | 26 |
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);