ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920827 | 920827 | 2021-01-12 | Washington | Florida | 12133 | 2179 | 30 |
917582 | 917582 | 2021-01-11 | Washington | Florida | 12133 | 2166 | 30 |
914337 | 914337 | 2021-01-10 | Washington | Florida | 12133 | 2161 | 30 |
911092 | 911092 | 2021-01-09 | Washington | Florida | 12133 | 2158 | 30 |
907847 | 907847 | 2021-01-08 | Washington | Florida | 12133 | 2138 | 30 |
904601 | 904601 | 2021-01-07 | Washington | Florida | 12133 | 2118 | 30 |
901356 | 901356 | 2021-01-06 | Washington | Florida | 12133 | 2086 | 30 |
898111 | 898111 | 2021-01-05 | Washington | Florida | 12133 | 2057 | 30 |
894866 | 894866 | 2021-01-04 | Washington | Florida | 12133 | 2048 | 30 |
891619 | 891619 | 2021-01-03 | Washington | Florida | 12133 | 2030 | 30 |
888372 | 888372 | 2021-01-02 | Washington | Florida | 12133 | 2017 | 30 |
885127 | 885127 | 2021-01-01 | Washington | Florida | 12133 | 1971 | 30 |
881882 | 881882 | 2020-12-31 | Washington | Florida | 12133 | 1971 | 30 |
878637 | 878637 | 2020-12-30 | Washington | Florida | 12133 | 1936 | 30 |
875392 | 875392 | 2020-12-29 | Washington | Florida | 12133 | 1919 | 30 |
872147 | 872147 | 2020-12-28 | Washington | Florida | 12133 | 1907 | 30 |
868902 | 868902 | 2020-12-27 | Washington | Florida | 12133 | 1907 | 30 |
865657 | 865657 | 2020-12-26 | Washington | Florida | 12133 | 1898 | 30 |
862412 | 862412 | 2020-12-25 | Washington | Florida | 12133 | 1868 | 30 |
859167 | 859167 | 2020-12-24 | Washington | Florida | 12133 | 1868 | 30 |
855922 | 855922 | 2020-12-23 | Washington | Florida | 12133 | 1830 | 30 |
852677 | 852677 | 2020-12-22 | Washington | Florida | 12133 | 1806 | 30 |
849432 | 849432 | 2020-12-21 | Washington | Florida | 12133 | 1798 | 31 |
846187 | 846187 | 2020-12-20 | Washington | Florida | 12133 | 1778 | 31 |
842941 | 842941 | 2020-12-19 | Washington | Florida | 12133 | 1773 | 31 |
839696 | 839696 | 2020-12-18 | Washington | Florida | 12133 | 1757 | 31 |
836451 | 836451 | 2020-12-17 | Washington | Florida | 12133 | 1744 | 29 |
833205 | 833205 | 2020-12-16 | Washington | Florida | 12133 | 1712 | 29 |
829958 | 829958 | 2020-12-15 | Washington | Florida | 12133 | 1678 | 29 |
826712 | 826712 | 2020-12-14 | Washington | Florida | 12133 | 1670 | 29 |
823465 | 823465 | 2020-12-13 | Washington | Florida | 12133 | 1660 | 29 |
820219 | 820219 | 2020-12-12 | Washington | Florida | 12133 | 1644 | 29 |
816973 | 816973 | 2020-12-11 | Washington | Florida | 12133 | 1635 | 27 |
813727 | 813727 | 2020-12-10 | Washington | Florida | 12133 | 1620 | 27 |
810483 | 810483 | 2020-12-09 | Washington | Florida | 12133 | 1610 | 27 |
807238 | 807238 | 2020-12-08 | Washington | Florida | 12133 | 1600 | 27 |
803993 | 803993 | 2020-12-07 | Washington | Florida | 12133 | 1591 | 27 |
800748 | 800748 | 2020-12-06 | Washington | Florida | 12133 | 1588 | 27 |
797503 | 797503 | 2020-12-05 | Washington | Florida | 12133 | 1578 | 27 |
794258 | 794258 | 2020-12-04 | Washington | Florida | 12133 | 1569 | 27 |
791013 | 791013 | 2020-12-03 | Washington | Florida | 12133 | 1565 | 27 |
787768 | 787768 | 2020-12-02 | Washington | Florida | 12133 | 1552 | 26 |
784524 | 784524 | 2020-12-01 | Washington | Florida | 12133 | 1536 | 26 |
781279 | 781279 | 2020-11-30 | Washington | Florida | 12133 | 1525 | 26 |
778033 | 778033 | 2020-11-29 | Washington | Florida | 12133 | 1518 | 25 |
774788 | 774788 | 2020-11-28 | Washington | Florida | 12133 | 1513 | 25 |
771543 | 771543 | 2020-11-27 | Washington | Florida | 12133 | 1508 | 24 |
768298 | 768298 | 2020-11-26 | Washington | Florida | 12133 | 1487 | 24 |
765052 | 765052 | 2020-11-25 | Washington | Florida | 12133 | 1487 | 24 |
761807 | 761807 | 2020-11-24 | Washington | Florida | 12133 | 1468 | 24 |
758562 | 758562 | 2020-11-23 | Washington | Florida | 12133 | 1461 | 24 |
755315 | 755315 | 2020-11-22 | Washington | Florida | 12133 | 1456 | 24 |
752069 | 752069 | 2020-11-21 | Washington | Florida | 12133 | 1450 | 24 |
748823 | 748823 | 2020-11-20 | Washington | Florida | 12133 | 1440 | 24 |
745577 | 745577 | 2020-11-19 | Washington | Florida | 12133 | 1428 | 24 |
742330 | 742330 | 2020-11-18 | Washington | Florida | 12133 | 1417 | 24 |
739083 | 739083 | 2020-11-17 | Washington | Florida | 12133 | 1410 | 24 |
735839 | 735839 | 2020-11-16 | Washington | Florida | 12133 | 1403 | 24 |
732593 | 732593 | 2020-11-15 | Washington | Florida | 12133 | 1383 | 24 |
729348 | 729348 | 2020-11-14 | Washington | Florida | 12133 | 1357 | 24 |
726105 | 726105 | 2020-11-13 | Washington | Florida | 12133 | 1343 | 24 |
722862 | 722862 | 2020-11-12 | Washington | Florida | 12133 | 1320 | 24 |
719619 | 719619 | 2020-11-11 | Washington | Florida | 12133 | 1318 | 24 |
716376 | 716376 | 2020-11-10 | Washington | Florida | 12133 | 1317 | 24 |
713132 | 713132 | 2020-11-09 | Washington | Florida | 12133 | 1309 | 24 |
709888 | 709888 | 2020-11-08 | Washington | Florida | 12133 | 1300 | 24 |
706644 | 706644 | 2020-11-07 | Washington | Florida | 12133 | 1296 | 24 |
703401 | 703401 | 2020-11-06 | Washington | Florida | 12133 | 1285 | 24 |
700158 | 700158 | 2020-11-05 | Washington | Florida | 12133 | 1280 | 24 |
696914 | 696914 | 2020-11-04 | Washington | Florida | 12133 | 1270 | 24 |
693672 | 693672 | 2020-11-03 | Washington | Florida | 12133 | 1261 | 24 |
690429 | 690429 | 2020-11-02 | Washington | Florida | 12133 | 1257 | 24 |
687184 | 687184 | 2020-11-01 | Washington | Florida | 12133 | 1255 | 24 |
683940 | 683940 | 2020-10-31 | Washington | Florida | 12133 | 1248 | 24 |
680697 | 680697 | 2020-10-30 | Washington | Florida | 12133 | 1244 | 24 |
677454 | 677454 | 2020-10-29 | Washington | Florida | 12133 | 1236 | 24 |
674211 | 674211 | 2020-10-28 | Washington | Florida | 12133 | 1232 | 24 |
670969 | 670969 | 2020-10-27 | Washington | Florida | 12133 | 1226 | 24 |
667726 | 667726 | 2020-10-26 | Washington | Florida | 12133 | 1222 | 24 |
664481 | 664481 | 2020-10-25 | Washington | Florida | 12133 | 1216 | 24 |
661237 | 661237 | 2020-10-24 | Washington | Florida | 12133 | 1209 | 24 |
657993 | 657993 | 2020-10-23 | Washington | Florida | 12133 | 1203 | 24 |
654748 | 654748 | 2020-10-22 | Washington | Florida | 12133 | 1196 | 24 |
651503 | 651503 | 2020-10-21 | Washington | Florida | 12133 | 1184 | 24 |
648259 | 648259 | 2020-10-20 | Washington | Florida | 12133 | 1181 | 24 |
645014 | 645014 | 2020-10-19 | Washington | Florida | 12133 | 1176 | 24 |
641766 | 641766 | 2020-10-18 | Washington | Florida | 12133 | 1171 | 24 |
638519 | 638519 | 2020-10-17 | Washington | Florida | 12133 | 1162 | 24 |
635274 | 635274 | 2020-10-16 | Washington | Florida | 12133 | 1151 | 24 |
632028 | 632028 | 2020-10-15 | Washington | Florida | 12133 | 1134 | 24 |
628784 | 628784 | 2020-10-14 | Washington | Florida | 12133 | 1124 | 24 |
625541 | 625541 | 2020-10-13 | Washington | Florida | 12133 | 1121 | 24 |
622298 | 622298 | 2020-10-12 | Washington | Florida | 12133 | 1119 | 24 |
619055 | 619055 | 2020-10-11 | Washington | Florida | 12133 | 1116 | 24 |
615813 | 615813 | 2020-10-10 | Washington | Florida | 12133 | 1107 | 24 |
612572 | 612572 | 2020-10-09 | Washington | Florida | 12133 | 1107 | 24 |
609330 | 609330 | 2020-10-08 | Washington | Florida | 12133 | 1104 | 24 |
606087 | 606087 | 2020-10-07 | Washington | Florida | 12133 | 1100 | 24 |
602845 | 602845 | 2020-10-06 | Washington | Florida | 12133 | 1093 | 24 |
599602 | 599602 | 2020-10-05 | Washington | Florida | 12133 | 1092 | 23 |
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);