ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Dallas" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923115 | 923115 | 2021-01-12 | Dallas | Texas | 48113 | 222635 | 2268 |
919870 | 919870 | 2021-01-11 | Dallas | Texas | 48113 | 219086 | 2242 |
916625 | 916625 | 2021-01-10 | Dallas | Texas | 48113 | 217219 | 2239 |
913380 | 913380 | 2021-01-09 | Dallas | Texas | 48113 | 214973 | 2220 |
910135 | 910135 | 2021-01-08 | Dallas | Texas | 48113 | 211779 | 2188 |
906890 | 906890 | 2021-01-07 | Dallas | Texas | 48113 | 209392 | 2151 |
903644 | 903644 | 2021-01-06 | Dallas | Texas | 48113 | 206802 | 2117 |
900399 | 900399 | 2021-01-05 | Dallas | Texas | 48113 | 204374 | 2087 |
897154 | 897154 | 2021-01-04 | Dallas | Texas | 48113 | 201581 | 2058 |
893908 | 893908 | 2021-01-03 | Dallas | Texas | 48113 | 200011 | 2049 |
890662 | 890662 | 2021-01-02 | Dallas | Texas | 48113 | 196160 | 2042 |
887415 | 887415 | 2021-01-01 | Dallas | Texas | 48113 | 193318 | 2033 |
884170 | 884170 | 2020-12-31 | Dallas | Texas | 48113 | 193318 | 2007 |
880925 | 880925 | 2020-12-30 | Dallas | Texas | 48113 | 191544 | 1971 |
877680 | 877680 | 2020-12-29 | Dallas | Texas | 48113 | 189252 | 1955 |
874435 | 874435 | 2020-12-28 | Dallas | Texas | 48113 | 188123 | 1936 |
871190 | 871190 | 2020-12-27 | Dallas | Texas | 48113 | 186880 | 1931 |
867945 | 867945 | 2020-12-26 | Dallas | Texas | 48113 | 180806 | 1925 |
864700 | 864700 | 2020-12-25 | Dallas | Texas | 48113 | 179418 | 1921 |
861455 | 861455 | 2020-12-24 | Dallas | Texas | 48113 | 179418 | 1904 |
858210 | 858210 | 2020-12-23 | Dallas | Texas | 48113 | 179418 | 1871 |
854965 | 854965 | 2020-12-22 | Dallas | Texas | 48113 | 176906 | 1853 |
851720 | 851720 | 2020-12-21 | Dallas | Texas | 48113 | 174540 | 1841 |
848475 | 848475 | 2020-12-20 | Dallas | Texas | 48113 | 171583 | 1831 |
845230 | 845230 | 2020-12-19 | Dallas | Texas | 48113 | 171583 | 1823 |
841984 | 841984 | 2020-12-18 | Dallas | Texas | 48113 | 169860 | 1810 |
838739 | 838739 | 2020-12-17 | Dallas | Texas | 48113 | 166230 | 1788 |
835493 | 835493 | 2020-12-16 | Dallas | Texas | 48113 | 163792 | 1765 |
832247 | 832247 | 2020-12-15 | Dallas | Texas | 48113 | 161845 | 1740 |
829000 | 829000 | 2020-12-14 | Dallas | Texas | 48113 | 160146 | 1728 |
825754 | 825754 | 2020-12-13 | Dallas | Texas | 48113 | 157336 | 1728 |
822507 | 822507 | 2020-12-12 | Dallas | Texas | 48113 | 157336 | 1715 |
819261 | 819261 | 2020-12-11 | Dallas | Texas | 48113 | 156225 | 1699 |
816015 | 816015 | 2020-12-10 | Dallas | Texas | 48113 | 154376 | 1694 |
812769 | 812769 | 2020-12-09 | Dallas | Texas | 48113 | 152288 | 1671 |
809525 | 809525 | 2020-12-08 | Dallas | Texas | 48113 | 150940 | 1650 |
806280 | 806280 | 2020-12-07 | Dallas | Texas | 48113 | 149835 | 1631 |
803035 | 803035 | 2020-12-06 | Dallas | Texas | 48113 | 148172 | 1628 |
799790 | 799790 | 2020-12-05 | Dallas | Texas | 48113 | 146320 | 1620 |
796545 | 796545 | 2020-12-04 | Dallas | Texas | 48113 | 144645 | 1604 |
793300 | 793300 | 2020-12-03 | Dallas | Texas | 48113 | 143739 | 1585 |
790055 | 790055 | 2020-12-02 | Dallas | Texas | 48113 | 141617 | 1565 |
786810 | 786810 | 2020-12-01 | Dallas | Texas | 48113 | 139977 | 1549 |
783566 | 783566 | 2020-11-30 | Dallas | Texas | 48113 | 138798 | 1539 |
780321 | 780321 | 2020-11-29 | Dallas | Texas | 48113 | 138096 | 1536 |
777075 | 777075 | 2020-11-28 | Dallas | Texas | 48113 | 134793 | 1528 |
773830 | 773830 | 2020-11-27 | Dallas | Texas | 48113 | 133811 | 1523 |
770585 | 770585 | 2020-11-26 | Dallas | Texas | 48113 | 133811 | 1515 |
767339 | 767339 | 2020-11-25 | Dallas | Texas | 48113 | 133811 | 1497 |
764094 | 764094 | 2020-11-24 | Dallas | Texas | 48113 | 132443 | 1479 |
760849 | 760849 | 2020-11-23 | Dallas | Texas | 48113 | 130727 | 1468 |
757604 | 757604 | 2020-11-22 | Dallas | Texas | 48113 | 130186 | 1466 |
754357 | 754357 | 2020-11-21 | Dallas | Texas | 48113 | 128324 | 1463 |
751111 | 751111 | 2020-11-20 | Dallas | Texas | 48113 | 126141 | 1450 |
747865 | 747865 | 2020-11-19 | Dallas | Texas | 48113 | 124167 | 1429 |
744619 | 744619 | 2020-11-18 | Dallas | Texas | 48113 | 122307 | 1410 |
741372 | 741372 | 2020-11-17 | Dallas | Texas | 48113 | 121360 | 1391 |
738126 | 738126 | 2020-11-16 | Dallas | Texas | 48113 | 120715 | 1383 |
734882 | 734882 | 2020-11-15 | Dallas | Texas | 48113 | 118884 | 1379 |
731636 | 731636 | 2020-11-14 | Dallas | Texas | 48113 | 117426 | 1373 |
728391 | 728391 | 2020-11-13 | Dallas | Texas | 48113 | 115883 | 1361 |
725148 | 725148 | 2020-11-12 | Dallas | Texas | 48113 | 115116 | 1350 |
721905 | 721905 | 2020-11-11 | Dallas | Texas | 48113 | 114308 | 1341 |
718662 | 718662 | 2020-11-10 | Dallas | Texas | 48113 | 113004 | 1331 |
715419 | 715419 | 2020-11-09 | Dallas | Texas | 48113 | 111603 | 1321 |
712175 | 712175 | 2020-11-08 | Dallas | Texas | 48113 | 110355 | 1319 |
708931 | 708931 | 2020-11-07 | Dallas | Texas | 48113 | 108631 | 1318 |
705687 | 705687 | 2020-11-06 | Dallas | Texas | 48113 | 108631 | 1307 |
702444 | 702444 | 2020-11-05 | Dallas | Texas | 48113 | 106494 | 1293 |
699201 | 699201 | 2020-11-04 | Dallas | Texas | 48113 | 106494 | 1280 |
695957 | 695957 | 2020-11-03 | Dallas | Texas | 48113 | 105628 | 1277 |
692715 | 692715 | 2020-11-02 | Dallas | Texas | 48113 | 104909 | 1269 |
689471 | 689471 | 2020-11-01 | Dallas | Texas | 48113 | 103392 | 1268 |
686226 | 686226 | 2020-10-31 | Dallas | Texas | 48113 | 102642 | 1267 |
682983 | 682983 | 2020-10-30 | Dallas | Texas | 48113 | 101051 | 1254 |
679740 | 679740 | 2020-10-29 | Dallas | Texas | 48113 | 101051 | 1243 |
676497 | 676497 | 2020-10-28 | Dallas | Texas | 48113 | 100395 | 1235 |
673254 | 673254 | 2020-10-27 | Dallas | Texas | 48113 | 99771 | 1229 |
670012 | 670012 | 2020-10-26 | Dallas | Texas | 48113 | 99174 | 1222 |
666769 | 666769 | 2020-10-25 | Dallas | Texas | 48113 | 98676 | 1220 |
663524 | 663524 | 2020-10-24 | Dallas | Texas | 48113 | 97873 | 1217 |
660280 | 660280 | 2020-10-23 | Dallas | Texas | 48113 | 97095 | 1211 |
657036 | 657036 | 2020-10-22 | Dallas | Texas | 48113 | 96483 | 1205 |
653791 | 653791 | 2020-10-21 | Dallas | Texas | 48113 | 96048 | 1205 |
650546 | 650546 | 2020-10-20 | Dallas | Texas | 48113 | 95459 | 1201 |
647302 | 647302 | 2020-10-19 | Dallas | Texas | 48113 | 94949 | 1194 |
644056 | 644056 | 2020-10-18 | Dallas | Texas | 48113 | 94567 | 1194 |
640808 | 640808 | 2020-10-17 | Dallas | Texas | 48113 | 93975 | 1190 |
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 |
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);