ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Rusk" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637704 | 637704 | 2020-10-16 | Rusk | Texas | 48401 | 953 | 20 |
634459 | 634459 | 2020-10-15 | Rusk | Texas | 48401 | 962 | 20 |
631214 | 631214 | 2020-10-14 | Rusk | Texas | 48401 | 961 | 20 |
627970 | 627970 | 2020-10-13 | Rusk | Texas | 48401 | 970 | 20 |
624727 | 624727 | 2020-10-12 | Rusk | Texas | 48401 | 961 | 19 |
621484 | 621484 | 2020-10-11 | Rusk | Texas | 48401 | 948 | 19 |
618241 | 618241 | 2020-10-10 | Rusk | Texas | 48401 | 948 | 19 |
614999 | 614999 | 2020-10-09 | Rusk | Texas | 48401 | 948 | 19 |
611758 | 611758 | 2020-10-08 | Rusk | Texas | 48401 | 950 | 19 |
608516 | 608516 | 2020-10-07 | Rusk | Texas | 48401 | 958 | 18 |
605273 | 605273 | 2020-10-06 | Rusk | Texas | 48401 | 965 | 17 |
602031 | 602031 | 2020-10-05 | Rusk | Texas | 48401 | 964 | 12 |
598788 | 598788 | 2020-10-04 | Rusk | Texas | 48401 | 965 | 12 |
595545 | 595545 | 2020-10-03 | Rusk | Texas | 48401 | 965 | 12 |
592303 | 592303 | 2020-10-02 | Rusk | Texas | 48401 | 965 | 11 |
589063 | 589063 | 2020-10-01 | Rusk | Texas | 48401 | 967 | 11 |
585822 | 585822 | 2020-09-30 | Rusk | Texas | 48401 | 972 | 11 |
582582 | 582582 | 2020-09-29 | Rusk | Texas | 48401 | 964 | 11 |
579343 | 579343 | 2020-09-28 | Rusk | Texas | 48401 | 962 | 11 |
576102 | 576102 | 2020-09-27 | Rusk | Texas | 48401 | 960 | 11 |
572858 | 572858 | 2020-09-26 | Rusk | Texas | 48401 | 960 | 11 |
569616 | 569616 | 2020-09-25 | Rusk | Texas | 48401 | 914 | 11 |
566375 | 566375 | 2020-09-24 | Rusk | Texas | 48401 | 914 | 11 |
563134 | 563134 | 2020-09-23 | Rusk | Texas | 48401 | 900 | 10 |
559895 | 559895 | 2020-09-22 | Rusk | Texas | 48401 | 894 | 9 |
556659 | 556659 | 2020-09-21 | Rusk | Texas | 48401 | 883 | 7 |
553422 | 553422 | 2020-09-20 | Rusk | Texas | 48401 | 878 | 7 |
550183 | 550183 | 2020-09-19 | Rusk | Texas | 48401 | 877 | 7 |
546944 | 546944 | 2020-09-18 | Rusk | Texas | 48401 | 867 | 6 |
543707 | 543707 | 2020-09-17 | Rusk | Texas | 48401 | 849 | 6 |
540471 | 540471 | 2020-09-16 | Rusk | Texas | 48401 | 846 | 6 |
537234 | 537234 | 2020-09-15 | Rusk | Texas | 48401 | 839 | 6 |
533998 | 533998 | 2020-09-14 | Rusk | Texas | 48401 | 831 | 6 |
530763 | 530763 | 2020-09-13 | Rusk | Texas | 48401 | 830 | 6 |
527526 | 527526 | 2020-09-12 | Rusk | Texas | 48401 | 793 | 6 |
524290 | 524290 | 2020-09-11 | Rusk | Texas | 48401 | 790 | 6 |
521054 | 521054 | 2020-09-10 | Rusk | Texas | 48401 | 762 | 6 |
517818 | 517818 | 2020-09-09 | Rusk | Texas | 48401 | 762 | 6 |
514583 | 514583 | 2020-09-08 | Rusk | Texas | 48401 | 744 | 5 |
511350 | 511350 | 2020-09-07 | Rusk | Texas | 48401 | 740 | 5 |
508117 | 508117 | 2020-09-06 | Rusk | Texas | 48401 | 739 | 5 |
504885 | 504885 | 2020-09-05 | Rusk | Texas | 48401 | 739 | 5 |
501651 | 501651 | 2020-09-04 | Rusk | Texas | 48401 | 732 | 5 |
498417 | 498417 | 2020-09-03 | Rusk | Texas | 48401 | 716 | 5 |
495184 | 495184 | 2020-09-02 | Rusk | Texas | 48401 | 714 | 5 |
491950 | 491950 | 2020-09-01 | Rusk | Texas | 48401 | 713 | 5 |
488717 | 488717 | 2020-08-31 | Rusk | Texas | 48401 | 705 | 4 |
485484 | 485484 | 2020-08-30 | Rusk | Texas | 48401 | 720 | 4 |
482249 | 482249 | 2020-08-29 | Rusk | Texas | 48401 | 719 | 4 |
479015 | 479015 | 2020-08-28 | Rusk | Texas | 48401 | 718 | 4 |
475782 | 475782 | 2020-08-27 | Rusk | Texas | 48401 | 709 | 4 |
472549 | 472549 | 2020-08-26 | Rusk | Texas | 48401 | 700 | 4 |
469317 | 469317 | 2020-08-25 | Rusk | Texas | 48401 | 556 | 4 |
466088 | 466088 | 2020-08-24 | Rusk | Texas | 48401 | 446 | 3 |
462859 | 462859 | 2020-08-23 | Rusk | Texas | 48401 | 444 | 3 |
459630 | 459630 | 2020-08-22 | Rusk | Texas | 48401 | 444 | 3 |
456403 | 456403 | 2020-08-21 | Rusk | Texas | 48401 | 440 | 3 |
453175 | 453175 | 2020-08-20 | Rusk | Texas | 48401 | 433 | 3 |
449947 | 449947 | 2020-08-19 | Rusk | Texas | 48401 | 420 | 3 |
446719 | 446719 | 2020-08-18 | Rusk | Texas | 48401 | 409 | 2 |
443492 | 443492 | 2020-08-17 | Rusk | Texas | 48401 | 398 | 2 |
440266 | 440266 | 2020-08-16 | Rusk | Texas | 48401 | 398 | 2 |
437040 | 437040 | 2020-08-15 | Rusk | Texas | 48401 | 398 | 2 |
433814 | 433814 | 2020-08-14 | Rusk | Texas | 48401 | 398 | 2 |
430589 | 430589 | 2020-08-13 | Rusk | Texas | 48401 | 396 | 2 |
427362 | 427362 | 2020-08-12 | Rusk | Texas | 48401 | 384 | 2 |
424138 | 424138 | 2020-08-11 | Rusk | Texas | 48401 | 377 | 2 |
420917 | 420917 | 2020-08-10 | Rusk | Texas | 48401 | 370 | 2 |
417696 | 417696 | 2020-08-09 | Rusk | Texas | 48401 | 369 | 2 |
414475 | 414475 | 2020-08-08 | Rusk | Texas | 48401 | 369 | 2 |
411255 | 411255 | 2020-08-07 | Rusk | Texas | 48401 | 366 | 2 |
408036 | 408036 | 2020-08-06 | Rusk | Texas | 48401 | 354 | 2 |
404816 | 404816 | 2020-08-05 | Rusk | Texas | 48401 | 341 | 2 |
401598 | 401598 | 2020-08-04 | Rusk | Texas | 48401 | 338 | 2 |
398382 | 398382 | 2020-08-03 | Rusk | Texas | 48401 | 334 | 2 |
395166 | 395166 | 2020-08-02 | Rusk | Texas | 48401 | 334 | 2 |
391950 | 391950 | 2020-08-01 | Rusk | Texas | 48401 | 332 | 2 |
388733 | 388733 | 2020-07-31 | Rusk | Texas | 48401 | 323 | 2 |
385516 | 385516 | 2020-07-30 | Rusk | Texas | 48401 | 328 | 2 |
382298 | 382298 | 2020-07-29 | Rusk | Texas | 48401 | 325 | 8 |
379081 | 379081 | 2020-07-28 | Rusk | Texas | 48401 | 320 | 8 |
375865 | 375865 | 2020-07-27 | Rusk | Texas | 48401 | 300 | 8 |
372652 | 372652 | 2020-07-26 | Rusk | Texas | 48401 | 295 | 3 |
369440 | 369440 | 2020-07-25 | Rusk | Texas | 48401 | 294 | 3 |
366231 | 366231 | 2020-07-24 | Rusk | Texas | 48401 | 288 | 3 |
363025 | 363025 | 2020-07-23 | Rusk | Texas | 48401 | 292 | 3 |
359818 | 359818 | 2020-07-22 | Rusk | Texas | 48401 | 280 | 3 |
356613 | 356613 | 2020-07-21 | Rusk | Texas | 48401 | 265 | 3 |
353410 | 353410 | 2020-07-20 | Rusk | Texas | 48401 | 260 | 3 |
350208 | 350208 | 2020-07-19 | Rusk | Texas | 48401 | 271 | 3 |
347008 | 347008 | 2020-07-18 | Rusk | Texas | 48401 | 270 | 3 |
343808 | 343808 | 2020-07-17 | Rusk | Texas | 48401 | 269 | 3 |
340609 | 340609 | 2020-07-16 | Rusk | Texas | 48401 | 250 | 3 |
337413 | 337413 | 2020-07-15 | Rusk | Texas | 48401 | 263 | 3 |
334218 | 334218 | 2020-07-14 | Rusk | Texas | 48401 | 264 | 3 |
331025 | 331025 | 2020-07-13 | Rusk | Texas | 48401 | 263 | 3 |
327839 | 327839 | 2020-07-12 | Rusk | Texas | 48401 | 253 | 3 |
324654 | 324654 | 2020-07-11 | Rusk | Texas | 48401 | 251 | 3 |
321473 | 321473 | 2020-07-10 | Rusk | Texas | 48401 | 249 | 3 |
318294 | 318294 | 2020-07-09 | Rusk | Texas | 48401 | 266 | 3 |
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);