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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 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 |
---|---|---|---|---|---|---|---|
242883 | 242883 | 2020-06-15 | Beaver | Utah | 49001 | 1 | 0 |
245995 | 245995 | 2020-06-16 | Beaver | Utah | 49001 | 1 | 0 |
249108 | 249108 | 2020-06-17 | Beaver | Utah | 49001 | 1 | 0 |
252223 | 252223 | 2020-06-18 | Beaver | Utah | 49001 | 1 | 0 |
255340 | 255340 | 2020-06-19 | Beaver | Utah | 49001 | 1 | 0 |
258467 | 258467 | 2020-06-20 | Beaver | Utah | 49001 | 1 | 0 |
261594 | 261594 | 2020-06-21 | Beaver | Utah | 49001 | 1 | 0 |
264723 | 264723 | 2020-06-22 | Beaver | Utah | 49001 | 2 | 0 |
267852 | 267852 | 2020-06-23 | Beaver | Utah | 49001 | 2 | 0 |
270986 | 270986 | 2020-06-24 | Beaver | Utah | 49001 | 4 | 0 |
274126 | 274126 | 2020-06-25 | Beaver | Utah | 49001 | 7 | 0 |
277274 | 277274 | 2020-06-26 | Beaver | Utah | 49001 | 8 | 0 |
280422 | 280422 | 2020-06-27 | Beaver | Utah | 49001 | 8 | 0 |
283568 | 283568 | 2020-06-28 | Beaver | Utah | 49001 | 8 | 0 |
286714 | 286714 | 2020-06-29 | Beaver | Utah | 49001 | 8 | 0 |
289864 | 289864 | 2020-06-30 | Beaver | Utah | 49001 | 9 | 0 |
293017 | 293017 | 2020-07-01 | Beaver | Utah | 49001 | 9 | 0 |
296172 | 296172 | 2020-07-02 | Beaver | Utah | 49001 | 9 | 0 |
299334 | 299334 | 2020-07-03 | Beaver | Utah | 49001 | 9 | 0 |
302498 | 302498 | 2020-07-04 | Beaver | Utah | 49001 | 11 | 0 |
305662 | 305662 | 2020-07-05 | Beaver | Utah | 49001 | 11 | 0 |
308830 | 308830 | 2020-07-06 | Beaver | Utah | 49001 | 12 | 0 |
311999 | 311999 | 2020-07-07 | Beaver | Utah | 49001 | 12 | 0 |
315173 | 315173 | 2020-07-08 | Beaver | Utah | 49001 | 12 | 0 |
318346 | 318346 | 2020-07-09 | Beaver | Utah | 49001 | 12 | 0 |
321525 | 321525 | 2020-07-10 | Beaver | Utah | 49001 | 12 | 0 |
324706 | 324706 | 2020-07-11 | Beaver | Utah | 49001 | 12 | 0 |
327891 | 327891 | 2020-07-12 | Beaver | Utah | 49001 | 12 | 0 |
331077 | 331077 | 2020-07-13 | Beaver | Utah | 49001 | 12 | 0 |
334270 | 334270 | 2020-07-14 | Beaver | Utah | 49001 | 12 | 0 |
337465 | 337465 | 2020-07-15 | Beaver | Utah | 49001 | 12 | 0 |
340661 | 340661 | 2020-07-16 | Beaver | Utah | 49001 | 12 | 0 |
343860 | 343860 | 2020-07-17 | Beaver | Utah | 49001 | 13 | 0 |
347061 | 347061 | 2020-07-18 | Beaver | Utah | 49001 | 13 | 0 |
350261 | 350261 | 2020-07-19 | Beaver | Utah | 49001 | 13 | 0 |
353463 | 353463 | 2020-07-20 | Beaver | Utah | 49001 | 13 | 0 |
356666 | 356666 | 2020-07-21 | Beaver | Utah | 49001 | 16 | 0 |
359871 | 359871 | 2020-07-22 | Beaver | Utah | 49001 | 18 | 0 |
363078 | 363078 | 2020-07-23 | Beaver | Utah | 49001 | 20 | 0 |
366284 | 366284 | 2020-07-24 | Beaver | Utah | 49001 | 23 | 0 |
369493 | 369493 | 2020-07-25 | Beaver | Utah | 49001 | 23 | 0 |
372705 | 372705 | 2020-07-26 | Beaver | Utah | 49001 | 23 | 0 |
375918 | 375918 | 2020-07-27 | Beaver | Utah | 49001 | 25 | 0 |
379134 | 379134 | 2020-07-28 | Beaver | Utah | 49001 | 26 | 0 |
382351 | 382351 | 2020-07-29 | Beaver | Utah | 49001 | 26 | 0 |
385569 | 385569 | 2020-07-30 | Beaver | Utah | 49001 | 26 | 0 |
388786 | 388786 | 2020-07-31 | Beaver | Utah | 49001 | 27 | 0 |
392003 | 392003 | 2020-08-01 | Beaver | Utah | 49001 | 27 | 0 |
395219 | 395219 | 2020-08-02 | Beaver | Utah | 49001 | 27 | 0 |
398435 | 398435 | 2020-08-03 | Beaver | Utah | 49001 | 27 | 0 |
401651 | 401651 | 2020-08-04 | Beaver | Utah | 49001 | 27 | 0 |
404869 | 404869 | 2020-08-05 | Beaver | Utah | 49001 | 28 | 0 |
408089 | 408089 | 2020-08-06 | Beaver | Utah | 49001 | 28 | 0 |
411308 | 411308 | 2020-08-07 | Beaver | Utah | 49001 | 30 | 0 |
414528 | 414528 | 2020-08-08 | Beaver | Utah | 49001 | 30 | 0 |
417749 | 417749 | 2020-08-09 | Beaver | Utah | 49001 | 30 | 0 |
420970 | 420970 | 2020-08-10 | Beaver | Utah | 49001 | 31 | 0 |
424191 | 424191 | 2020-08-11 | Beaver | Utah | 49001 | 31 | 0 |
427415 | 427415 | 2020-08-12 | Beaver | Utah | 49001 | 31 | 0 |
430643 | 430643 | 2020-08-13 | Beaver | Utah | 49001 | 31 | 0 |
433868 | 433868 | 2020-08-14 | Beaver | Utah | 49001 | 31 | 0 |
437094 | 437094 | 2020-08-15 | Beaver | Utah | 49001 | 31 | 0 |
440320 | 440320 | 2020-08-16 | Beaver | Utah | 49001 | 31 | 0 |
443546 | 443546 | 2020-08-17 | Beaver | Utah | 49001 | 31 | 0 |
446773 | 446773 | 2020-08-18 | Beaver | Utah | 49001 | 31 | 0 |
450001 | 450001 | 2020-08-19 | Beaver | Utah | 49001 | 31 | 0 |
453229 | 453229 | 2020-08-20 | Beaver | Utah | 49001 | 31 | 0 |
456457 | 456457 | 2020-08-21 | Beaver | Utah | 49001 | 31 | 0 |
459684 | 459684 | 2020-08-22 | Beaver | Utah | 49001 | 31 | 0 |
462913 | 462913 | 2020-08-23 | Beaver | Utah | 49001 | 31 | 0 |
466142 | 466142 | 2020-08-24 | Beaver | Utah | 49001 | 31 | 0 |
469371 | 469371 | 2020-08-25 | Beaver | Utah | 49001 | 31 | 0 |
472603 | 472603 | 2020-08-26 | Beaver | Utah | 49001 | 31 | 0 |
475836 | 475836 | 2020-08-27 | Beaver | Utah | 49001 | 33 | 0 |
479069 | 479069 | 2020-08-28 | Beaver | Utah | 49001 | 33 | 0 |
482303 | 482303 | 2020-08-29 | Beaver | Utah | 49001 | 33 | 0 |
485538 | 485538 | 2020-08-30 | Beaver | Utah | 49001 | 33 | 0 |
488771 | 488771 | 2020-08-31 | Beaver | Utah | 49001 | 33 | 0 |
492004 | 492004 | 2020-09-01 | Beaver | Utah | 49001 | 33 | 0 |
495238 | 495238 | 2020-09-02 | Beaver | Utah | 49001 | 33 | 0 |
498471 | 498471 | 2020-09-03 | Beaver | Utah | 49001 | 33 | 0 |
501705 | 501705 | 2020-09-04 | Beaver | Utah | 49001 | 33 | 0 |
504939 | 504939 | 2020-09-05 | Beaver | Utah | 49001 | 33 | 0 |
508171 | 508171 | 2020-09-06 | Beaver | Utah | 49001 | 33 | 0 |
511404 | 511404 | 2020-09-07 | Beaver | Utah | 49001 | 33 | 0 |
514637 | 514637 | 2020-09-08 | Beaver | Utah | 49001 | 33 | 0 |
517872 | 517872 | 2020-09-09 | Beaver | Utah | 49001 | 33 | 0 |
521108 | 521108 | 2020-09-10 | Beaver | Utah | 49001 | 33 | 0 |
524344 | 524344 | 2020-09-11 | Beaver | Utah | 49001 | 33 | 0 |
527580 | 527580 | 2020-09-12 | Beaver | Utah | 49001 | 34 | 0 |
530817 | 530817 | 2020-09-13 | Beaver | Utah | 49001 | 34 | 0 |
534052 | 534052 | 2020-09-14 | Beaver | Utah | 49001 | 34 | 0 |
537288 | 537288 | 2020-09-15 | Beaver | Utah | 49001 | 34 | 0 |
540525 | 540525 | 2020-09-16 | Beaver | Utah | 49001 | 35 | 0 |
543761 | 543761 | 2020-09-17 | Beaver | Utah | 49001 | 35 | 0 |
546998 | 546998 | 2020-09-18 | Beaver | Utah | 49001 | 36 | 0 |
550237 | 550237 | 2020-09-19 | Beaver | Utah | 49001 | 36 | 0 |
553476 | 553476 | 2020-09-20 | Beaver | Utah | 49001 | 36 | 0 |
556713 | 556713 | 2020-09-21 | Beaver | Utah | 49001 | 37 | 0 |
559949 | 559949 | 2020-09-22 | Beaver | Utah | 49001 | 37 | 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);