ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 48113 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637561 | 637561 | 2020-10-16 | Dallas | Texas | 48113 | 93328 | 1187 |
634316 | 634316 | 2020-10-15 | Dallas | Texas | 48113 | 92848 | 1184 |
631071 | 631071 | 2020-10-14 | Dallas | Texas | 48113 | 92259 | 1180 |
627827 | 627827 | 2020-10-13 | Dallas | Texas | 48113 | 91755 | 1173 |
624585 | 624585 | 2020-10-12 | Dallas | Texas | 48113 | 91117 | 1169 |
621342 | 621342 | 2020-10-11 | Dallas | Texas | 48113 | 90781 | 1169 |
618099 | 618099 | 2020-10-10 | Dallas | Texas | 48113 | 90348 | 1167 |
614857 | 614857 | 2020-10-09 | Dallas | Texas | 48113 | 89856 | 1165 |
611616 | 611616 | 2020-10-08 | Dallas | Texas | 48113 | 89444 | 1161 |
608374 | 608374 | 2020-10-07 | Dallas | Texas | 48113 | 89206 | 1159 |
605131 | 605131 | 2020-10-06 | Dallas | Texas | 48113 | 88863 | 1154 |
601889 | 601889 | 2020-10-05 | Dallas | Texas | 48113 | 88617 | 1149 |
598646 | 598646 | 2020-10-04 | Dallas | Texas | 48113 | 88167 | 1148 |
595403 | 595403 | 2020-10-03 | Dallas | Texas | 48113 | 87529 | 1144 |
592161 | 592161 | 2020-10-02 | Dallas | Texas | 48113 | 86500 | 1139 |
588921 | 588921 | 2020-10-01 | Dallas | Texas | 48113 | 86500 | 1137 |
585680 | 585680 | 2020-09-30 | Dallas | Texas | 48113 | 86500 | 1133 |
582440 | 582440 | 2020-09-29 | Dallas | Texas | 48113 | 86213 | 1126 |
579201 | 579201 | 2020-09-28 | Dallas | Texas | 48113 | 85410 | 1124 |
575960 | 575960 | 2020-09-27 | Dallas | Texas | 48113 | 85099 | 1124 |
572716 | 572716 | 2020-09-26 | Dallas | Texas | 48113 | 83304 | 1120 |
569474 | 569474 | 2020-09-25 | Dallas | Texas | 48113 | 83304 | 1115 |
566233 | 566233 | 2020-09-24 | Dallas | Texas | 48113 | 83304 | 1115 |
562992 | 562992 | 2020-09-23 | Dallas | Texas | 48113 | 82600 | 1106 |
559753 | 559753 | 2020-09-22 | Dallas | Texas | 48113 | 82212 | 1091 |
556517 | 556517 | 2020-09-21 | Dallas | Texas | 48113 | 82079 | 1085 |
553280 | 553280 | 2020-09-20 | Dallas | Texas | 48113 | 81752 | 1085 |
550041 | 550041 | 2020-09-19 | Dallas | Texas | 48113 | 80917 | 1083 |
546802 | 546802 | 2020-09-18 | Dallas | Texas | 48113 | 80736 | 1073 |
543565 | 543565 | 2020-09-17 | Dallas | Texas | 48113 | 80244 | 1059 |
540329 | 540329 | 2020-09-16 | Dallas | Texas | 48113 | 79786 | 1056 |
537092 | 537092 | 2020-09-15 | Dallas | Texas | 48113 | 79474 | 1050 |
533856 | 533856 | 2020-09-14 | Dallas | Texas | 48113 | 79263 | 1046 |
530621 | 530621 | 2020-09-13 | Dallas | Texas | 48113 | 78511 | 1045 |
527384 | 527384 | 2020-09-12 | Dallas | Texas | 48113 | 78511 | 1043 |
524148 | 524148 | 2020-09-11 | Dallas | Texas | 48113 | 78291 | 1037 |
520912 | 520912 | 2020-09-10 | Dallas | Texas | 48113 | 77948 | 1021 |
517676 | 517676 | 2020-09-09 | Dallas | Texas | 48113 | 77734 | 1021 |
514441 | 514441 | 2020-09-08 | Dallas | Texas | 48113 | 77326 | 1011 |
511208 | 511208 | 2020-09-07 | Dallas | Texas | 48113 | 76858 | 1010 |
507975 | 507975 | 2020-09-06 | Dallas | Texas | 48113 | 76858 | 1008 |
504743 | 504743 | 2020-09-05 | Dallas | Texas | 48113 | 76499 | 1002 |
501509 | 501509 | 2020-09-04 | Dallas | Texas | 48113 | 76081 | 991 |
498275 | 498275 | 2020-09-03 | Dallas | Texas | 48113 | 75635 | 984 |
495042 | 495042 | 2020-09-02 | Dallas | Texas | 48113 | 75635 | 973 |
491808 | 491808 | 2020-09-01 | Dallas | Texas | 48113 | 75268 | 959 |
488575 | 488575 | 2020-08-31 | Dallas | Texas | 48113 | 74576 | 947 |
485342 | 485342 | 2020-08-30 | Dallas | Texas | 48113 | 73685 | 947 |
482107 | 482107 | 2020-08-29 | Dallas | Texas | 48113 | 73685 | 943 |
478873 | 478873 | 2020-08-28 | Dallas | Texas | 48113 | 72884 | 938 |
475640 | 475640 | 2020-08-27 | Dallas | Texas | 48113 | 72627 | 926 |
472407 | 472407 | 2020-08-26 | Dallas | Texas | 48113 | 72627 | 912 |
469175 | 469175 | 2020-08-25 | Dallas | Texas | 48113 | 72043 | 899 |
465946 | 465946 | 2020-08-24 | Dallas | Texas | 48113 | 71662 | 883 |
462717 | 462717 | 2020-08-23 | Dallas | Texas | 48113 | 71478 | 881 |
459488 | 459488 | 2020-08-22 | Dallas | Texas | 48113 | 71148 | 878 |
456261 | 456261 | 2020-08-21 | Dallas | Texas | 48113 | 70060 | 868 |
453033 | 453033 | 2020-08-20 | Dallas | Texas | 48113 | 69343 | 854 |
449805 | 449805 | 2020-08-19 | Dallas | Texas | 48113 | 68994 | 851 |
446577 | 446577 | 2020-08-18 | Dallas | Texas | 48113 | 68591 | 846 |
443350 | 443350 | 2020-08-17 | Dallas | Texas | 48113 | 67797 | 836 |
440124 | 440124 | 2020-08-16 | Dallas | Texas | 48113 | 65943 | 832 |
436898 | 436898 | 2020-08-15 | Dallas | Texas | 48113 | 60582 | 830 |
433672 | 433672 | 2020-08-14 | Dallas | Texas | 48113 | 59818 | 823 |
430447 | 430447 | 2020-08-13 | Dallas | Texas | 48113 | 58897 | 808 |
427220 | 427220 | 2020-08-12 | Dallas | Texas | 48113 | 58147 | 801 |
423996 | 423996 | 2020-08-11 | Dallas | Texas | 48113 | 57825 | 792 |
420775 | 420775 | 2020-08-10 | Dallas | Texas | 48113 | 57497 | 762 |
417554 | 417554 | 2020-08-09 | Dallas | Texas | 48113 | 56876 | 761 |
414333 | 414333 | 2020-08-08 | Dallas | Texas | 48113 | 55903 | 757 |
411113 | 411113 | 2020-08-07 | Dallas | Texas | 48113 | 55320 | 751 |
407894 | 407894 | 2020-08-06 | Dallas | Texas | 48113 | 54731 | 739 |
404674 | 404674 | 2020-08-05 | Dallas | Texas | 48113 | 54317 | 729 |
401456 | 401456 | 2020-08-04 | Dallas | Texas | 48113 | 53809 | 725 |
398240 | 398240 | 2020-08-03 | Dallas | Texas | 48113 | 53024 | 693 |
395024 | 395024 | 2020-08-02 | Dallas | Texas | 48113 | 52576 | 690 |
391808 | 391808 | 2020-08-01 | Dallas | Texas | 48113 | 50590 | 681 |
388591 | 388591 | 2020-07-31 | Dallas | Texas | 48113 | 51299 | 673 |
385374 | 385374 | 2020-07-30 | Dallas | Texas | 48113 | 49269 | 664 |
382156 | 382156 | 2020-07-29 | Dallas | Texas | 48113 | 48732 | 658 |
378939 | 378939 | 2020-07-28 | Dallas | Texas | 48113 | 48028 | 622 |
375723 | 375723 | 2020-07-27 | Dallas | Texas | 48113 | 47239 | 607 |
372510 | 372510 | 2020-07-26 | Dallas | Texas | 48113 | 46813 | 605 |
369298 | 369298 | 2020-07-25 | Dallas | Texas | 48113 | 46013 | 604 |
366089 | 366089 | 2020-07-24 | Dallas | Texas | 48113 | 44746 | 586 |
362883 | 362883 | 2020-07-23 | Dallas | Texas | 48113 | 44087 | 579 |
359676 | 359676 | 2020-07-22 | Dallas | Texas | 48113 | 43439 | 567 |
356471 | 356471 | 2020-07-21 | Dallas | Texas | 48113 | 43026 | 537 |
353268 | 353268 | 2020-07-20 | Dallas | Texas | 48113 | 42292 | 526 |
350066 | 350066 | 2020-07-19 | Dallas | Texas | 48113 | 41266 | 525 |
346866 | 346866 | 2020-07-18 | Dallas | Texas | 48113 | 40222 | 523 |
343666 | 343666 | 2020-07-17 | Dallas | Texas | 48113 | 39191 | 514 |
340467 | 340467 | 2020-07-16 | Dallas | Texas | 48113 | 37996 | 501 |
337271 | 337271 | 2020-07-15 | Dallas | Texas | 48113 | 36969 | 485 |
334076 | 334076 | 2020-07-14 | Dallas | Texas | 48113 | 35914 | 477 |
330885 | 330885 | 2020-07-13 | Dallas | Texas | 48113 | 34914 | 457 |
327699 | 327699 | 2020-07-12 | Dallas | Texas | 48113 | 33800 | 451 |
324514 | 324514 | 2020-07-11 | Dallas | Texas | 48113 | 32626 | 449 |
321333 | 321333 | 2020-07-10 | Dallas | Texas | 48113 | 31525 | 445 |
318155 | 318155 | 2020-07-09 | Dallas | Texas | 48113 | 30361 | 436 |
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);