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 |
---|---|---|---|---|---|---|---|
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 |
437110 | 437110 | 2020-08-15 | Salt Lake | Utah | 49035 | 21707 | 212 |
433884 | 433884 | 2020-08-14 | Salt Lake | Utah | 49035 | 21539 | 211 |
430659 | 430659 | 2020-08-13 | Salt Lake | Utah | 49035 | 21290 | 209 |
427431 | 427431 | 2020-08-12 | Salt Lake | Utah | 49035 | 21118 | 206 |
424207 | 424207 | 2020-08-11 | Salt Lake | Utah | 49035 | 20985 | 201 |
420986 | 420986 | 2020-08-10 | Salt Lake | Utah | 49035 | 20810 | 197 |
417765 | 417765 | 2020-08-09 | Salt Lake | Utah | 49035 | 20628 | 190 |
414544 | 414544 | 2020-08-08 | Salt Lake | Utah | 49035 | 20530 | 190 |
411324 | 411324 | 2020-08-07 | Salt Lake | Utah | 49035 | 20417 | 191 |
408105 | 408105 | 2020-08-06 | Salt Lake | Utah | 49035 | 20197 | 188 |
404885 | 404885 | 2020-08-05 | Salt Lake | Utah | 49035 | 20004 | 187 |
401667 | 401667 | 2020-08-04 | Salt Lake | Utah | 49035 | 19796 | 186 |
398451 | 398451 | 2020-08-03 | Salt Lake | Utah | 49035 | 19623 | 180 |
395235 | 395235 | 2020-08-02 | Salt Lake | Utah | 49035 | 19408 | 177 |
392019 | 392019 | 2020-08-01 | Salt Lake | Utah | 49035 | 19323 | 177 |
388802 | 388802 | 2020-07-31 | Salt Lake | Utah | 49035 | 19086 | 176 |
385585 | 385585 | 2020-07-30 | Salt Lake | Utah | 49035 | 18847 | 173 |
382367 | 382367 | 2020-07-29 | Salt Lake | Utah | 49035 | 18723 | 170 |
379150 | 379150 | 2020-07-28 | Salt Lake | Utah | 49035 | 18471 | 165 |
375934 | 375934 | 2020-07-27 | Salt Lake | Utah | 49035 | 18321 | 163 |
372721 | 372721 | 2020-07-26 | Salt Lake | Utah | 49035 | 18090 | 159 |
369509 | 369509 | 2020-07-25 | Salt Lake | Utah | 49035 | 18013 | 159 |
366300 | 366300 | 2020-07-24 | Salt Lake | Utah | 49035 | 17808 | 159 |
363094 | 363094 | 2020-07-23 | Salt Lake | Utah | 49035 | 17426 | 155 |
359887 | 359887 | 2020-07-22 | Salt Lake | Utah | 49035 | 17254 | 147 |
356682 | 356682 | 2020-07-21 | Salt Lake | Utah | 49035 | 17021 | 143 |
353479 | 353479 | 2020-07-20 | Salt Lake | Utah | 49035 | 16755 | 140 |
350277 | 350277 | 2020-07-19 | Salt Lake | Utah | 49035 | 16523 | 138 |
347077 | 347077 | 2020-07-18 | Salt Lake | Utah | 49035 | 16359 | 138 |
343876 | 343876 | 2020-07-17 | Salt Lake | Utah | 49035 | 15923 | 136 |
340677 | 340677 | 2020-07-16 | Salt Lake | Utah | 49035 | 15663 | 135 |
337481 | 337481 | 2020-07-15 | Salt Lake | Utah | 49035 | 15410 | 134 |
334286 | 334286 | 2020-07-14 | Salt Lake | Utah | 49035 | 15159 | 132 |
331093 | 331093 | 2020-07-13 | Salt Lake | Utah | 49035 | 14959 | 132 |
327907 | 327907 | 2020-07-12 | Salt Lake | Utah | 49035 | 14609 | 133 |
324722 | 324722 | 2020-07-11 | Salt Lake | Utah | 49035 | 14406 | 133 |
321541 | 321541 | 2020-07-10 | Salt Lake | Utah | 49035 | 14148 | 130 |
318362 | 318362 | 2020-07-09 | Salt Lake | Utah | 49035 | 13763 | 124 |
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);