ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
809 rows where fips = 49035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
761064 | 761064 | 2020-11-23 | Salt Lake | Utah | 49035 | 74269 | 382 |
757819 | 757819 | 2020-11-22 | Salt Lake | Utah | 49035 | 73469 | 380 |
754572 | 754572 | 2020-11-21 | Salt Lake | Utah | 49035 | 72206 | 378 |
751326 | 751326 | 2020-11-20 | Salt Lake | Utah | 49035 | 71088 | 371 |
748080 | 748080 | 2020-11-19 | Salt Lake | Utah | 49035 | 69503 | 364 |
744834 | 744834 | 2020-11-18 | Salt Lake | Utah | 49035 | 67942 | 360 |
741587 | 741587 | 2020-11-17 | Salt Lake | Utah | 49035 | 66727 | 356 |
738340 | 738340 | 2020-11-16 | Salt Lake | Utah | 49035 | 65681 | 353 |
735096 | 735096 | 2020-11-15 | Salt Lake | Utah | 49035 | 64794 | 351 |
731850 | 731850 | 2020-11-14 | Salt Lake | Utah | 49035 | 63768 | 350 |
728605 | 728605 | 2020-11-13 | Salt Lake | Utah | 49035 | 61673 | 348 |
725362 | 725362 | 2020-11-12 | Salt Lake | Utah | 49035 | 60859 | 342 |
722119 | 722119 | 2020-11-11 | Salt Lake | Utah | 49035 | 59493 | 339 |
718876 | 718876 | 2020-11-10 | Salt Lake | Utah | 49035 | 58495 | 334 |
715633 | 715633 | 2020-11-09 | Salt Lake | Utah | 49035 | 57531 | 331 |
712389 | 712389 | 2020-11-08 | Salt Lake | Utah | 49035 | 56567 | 330 |
709145 | 709145 | 2020-11-07 | Salt Lake | Utah | 49035 | 55566 | 330 |
705901 | 705901 | 2020-11-06 | Salt Lake | Utah | 49035 | 54332 | 326 |
702658 | 702658 | 2020-11-05 | Salt Lake | Utah | 49035 | 53149 | 321 |
699415 | 699415 | 2020-11-04 | Salt Lake | Utah | 49035 | 51985 | 318 |
696171 | 696171 | 2020-11-03 | Salt Lake | Utah | 49035 | 51124 | 317 |
692929 | 692929 | 2020-11-02 | Salt Lake | Utah | 49035 | 50461 | 314 |
689685 | 689685 | 2020-11-01 | Salt Lake | Utah | 49035 | 49887 | 314 |
686440 | 686440 | 2020-10-31 | Salt Lake | Utah | 49035 | 49087 | 309 |
683197 | 683197 | 2020-10-30 | Salt Lake | Utah | 49035 | 48330 | 309 |
679954 | 679954 | 2020-10-29 | Salt Lake | Utah | 49035 | 47429 | 308 |
676711 | 676711 | 2020-10-28 | Salt Lake | Utah | 49035 | 46672 | 304 |
673468 | 673468 | 2020-10-27 | Salt Lake | Utah | 49035 | 45969 | 299 |
670226 | 670226 | 2020-10-26 | Salt Lake | Utah | 49035 | 45508 | 299 |
666983 | 666983 | 2020-10-25 | Salt Lake | Utah | 49035 | 45042 | 299 |
663738 | 663738 | 2020-10-24 | Salt Lake | Utah | 49035 | 44305 | 299 |
660494 | 660494 | 2020-10-23 | Salt Lake | Utah | 49035 | 43647 | 298 |
657250 | 657250 | 2020-10-22 | Salt Lake | Utah | 49035 | 42902 | 297 |
654005 | 654005 | 2020-10-21 | Salt Lake | Utah | 49035 | 42276 | 295 |
650760 | 650760 | 2020-10-20 | Salt Lake | Utah | 49035 | 41665 | 292 |
647516 | 647516 | 2020-10-19 | Salt Lake | Utah | 49035 | 41213 | 290 |
644270 | 644270 | 2020-10-18 | Salt Lake | Utah | 49035 | 40713 | 289 |
641022 | 641022 | 2020-10-17 | Salt Lake | Utah | 49035 | 40227 | 287 |
637775 | 637775 | 2020-10-16 | Salt Lake | Utah | 49035 | 39645 | 286 |
634530 | 634530 | 2020-10-15 | Salt Lake | Utah | 49035 | 38949 | 285 |
631285 | 631285 | 2020-10-14 | Salt Lake | Utah | 49035 | 38369 | 283 |
628041 | 628041 | 2020-10-13 | Salt Lake | Utah | 49035 | 37821 | 281 |
624798 | 624798 | 2020-10-12 | Salt Lake | Utah | 49035 | 37479 | 281 |
621555 | 621555 | 2020-10-11 | Salt Lake | Utah | 49035 | 37088 | 280 |
618312 | 618312 | 2020-10-10 | Salt Lake | Utah | 49035 | 36554 | 277 |
615070 | 615070 | 2020-10-09 | Salt Lake | Utah | 49035 | 35952 | 275 |
611829 | 611829 | 2020-10-08 | Salt Lake | Utah | 49035 | 35436 | 272 |
608587 | 608587 | 2020-10-07 | Salt Lake | Utah | 49035 | 34884 | 269 |
605344 | 605344 | 2020-10-06 | Salt Lake | Utah | 49035 | 34396 | 265 |
602102 | 602102 | 2020-10-05 | Salt Lake | Utah | 49035 | 34071 | 260 |
598859 | 598859 | 2020-10-04 | Salt Lake | Utah | 49035 | 33599 | 259 |
595616 | 595616 | 2020-10-03 | Salt Lake | Utah | 49035 | 32947 | 259 |
592374 | 592374 | 2020-10-02 | Salt Lake | Utah | 49035 | 32476 | 259 |
589134 | 589134 | 2020-10-01 | Salt Lake | Utah | 49035 | 32019 | 254 |
585893 | 585893 | 2020-09-30 | Salt Lake | Utah | 49035 | 31700 | 254 |
582653 | 582653 | 2020-09-29 | Salt Lake | Utah | 49035 | 31345 | 254 |
579414 | 579414 | 2020-09-28 | Salt Lake | Utah | 49035 | 31079 | 252 |
576173 | 576173 | 2020-09-27 | Salt Lake | Utah | 49035 | 30784 | 252 |
572929 | 572929 | 2020-09-26 | Salt Lake | Utah | 49035 | 30357 | 250 |
569687 | 569687 | 2020-09-25 | Salt Lake | Utah | 49035 | 29977 | 250 |
566446 | 566446 | 2020-09-24 | Salt Lake | Utah | 49035 | 29392 | 249 |
563205 | 563205 | 2020-09-23 | Salt Lake | Utah | 49035 | 28996 | 249 |
559966 | 559966 | 2020-09-22 | Salt Lake | Utah | 49035 | 28676 | 248 |
556730 | 556730 | 2020-09-21 | Salt Lake | Utah | 49035 | 28453 | 247 |
553493 | 553493 | 2020-09-20 | Salt Lake | Utah | 49035 | 28178 | 246 |
550254 | 550254 | 2020-09-19 | Salt Lake | Utah | 49035 | 27842 | 246 |
547015 | 547015 | 2020-09-18 | Salt Lake | Utah | 49035 | 27454 | 245 |
543778 | 543778 | 2020-09-17 | Salt Lake | Utah | 49035 | 27061 | 245 |
540542 | 540542 | 2020-09-16 | Salt Lake | Utah | 49035 | 26723 | 245 |
537305 | 537305 | 2020-09-15 | Salt Lake | Utah | 49035 | 26451 | 244 |
534069 | 534069 | 2020-09-14 | Salt Lake | Utah | 49035 | 26255 | 244 |
530834 | 530834 | 2020-09-13 | Salt Lake | Utah | 49035 | 26014 | 243 |
527597 | 527597 | 2020-09-12 | Salt Lake | Utah | 49035 | 25822 | 243 |
524361 | 524361 | 2020-09-11 | Salt Lake | Utah | 49035 | 25696 | 243 |
521125 | 521125 | 2020-09-10 | Salt Lake | Utah | 49035 | 25486 | 241 |
517888 | 517888 | 2020-09-09 | Salt Lake | Utah | 49035 | 25290 | 240 |
514653 | 514653 | 2020-09-08 | Salt Lake | Utah | 49035 | 25224 | 239 |
511420 | 511420 | 2020-09-07 | Salt Lake | Utah | 49035 | 25058 | 237 |
508187 | 508187 | 2020-09-06 | Salt Lake | Utah | 49035 | 24934 | 236 |
504955 | 504955 | 2020-09-05 | Salt Lake | Utah | 49035 | 24867 | 236 |
501721 | 501721 | 2020-09-04 | Salt Lake | Utah | 49035 | 24706 | 236 |
498487 | 498487 | 2020-09-03 | Salt Lake | Utah | 49035 | 24495 | 236 |
495254 | 495254 | 2020-09-02 | Salt Lake | Utah | 49035 | 24345 | 235 |
492020 | 492020 | 2020-09-01 | Salt Lake | Utah | 49035 | 24203 | 232 |
488787 | 488787 | 2020-08-31 | Salt Lake | Utah | 49035 | 24039 | 232 |
485554 | 485554 | 2020-08-30 | Salt Lake | Utah | 49035 | 23862 | 231 |
482319 | 482319 | 2020-08-29 | Salt Lake | Utah | 49035 | 23775 | 231 |
479085 | 479085 | 2020-08-28 | Salt Lake | Utah | 49035 | 23632 | 231 |
475852 | 475852 | 2020-08-27 | Salt Lake | Utah | 49035 | 23451 | 230 |
472619 | 472619 | 2020-08-26 | Salt Lake | Utah | 49035 | 23290 | 230 |
469387 | 469387 | 2020-08-25 | Salt Lake | Utah | 49035 | 23122 | 227 |
466158 | 466158 | 2020-08-24 | Salt Lake | Utah | 49035 | 22958 | 225 |
462929 | 462929 | 2020-08-23 | Salt Lake | Utah | 49035 | 22760 | 225 |
459700 | 459700 | 2020-08-22 | Salt Lake | Utah | 49035 | 22686 | 225 |
456473 | 456473 | 2020-08-21 | Salt Lake | Utah | 49035 | 22579 | 223 |
453245 | 453245 | 2020-08-20 | Salt Lake | Utah | 49035 | 22403 | 222 |
450017 | 450017 | 2020-08-19 | Salt Lake | Utah | 49035 | 22204 | 218 |
446789 | 446789 | 2020-08-18 | Salt Lake | Utah | 49035 | 22062 | 217 |
443562 | 443562 | 2020-08-17 | Salt Lake | Utah | 49035 | 21911 | 213 |
440336 | 440336 | 2020-08-16 | Salt Lake | Utah | 49035 | 21771 | 212 |
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);