ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Delaware" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955059 | 955059 | 2021-01-22 | Delaware | Oklahoma | 40041 | 3873 | 53 |
951814 | 951814 | 2021-01-21 | Delaware | Oklahoma | 40041 | 3842 | 52 |
948569 | 948569 | 2021-01-20 | Delaware | Oklahoma | 40041 | 3818 | 51 |
945323 | 945323 | 2021-01-19 | Delaware | Oklahoma | 40041 | 3814 | 50 |
942076 | 942076 | 2021-01-18 | Delaware | Oklahoma | 40041 | 3790 | 46 |
938831 | 938831 | 2021-01-17 | Delaware | Oklahoma | 40041 | 3770 | 46 |
935586 | 935586 | 2021-01-16 | Delaware | Oklahoma | 40041 | 3724 | 46 |
932341 | 932341 | 2021-01-15 | Delaware | Oklahoma | 40041 | 3684 | 46 |
929096 | 929096 | 2021-01-14 | Delaware | Oklahoma | 40041 | 3621 | 46 |
925851 | 925851 | 2021-01-13 | Delaware | Oklahoma | 40041 | 3585 | 46 |
922605 | 922605 | 2021-01-12 | Delaware | Oklahoma | 40041 | 3549 | 46 |
919360 | 919360 | 2021-01-11 | Delaware | Oklahoma | 40041 | 3491 | 46 |
916115 | 916115 | 2021-01-10 | Delaware | Oklahoma | 40041 | 3456 | 46 |
912870 | 912870 | 2021-01-09 | Delaware | Oklahoma | 40041 | 3407 | 45 |
909625 | 909625 | 2021-01-08 | Delaware | Oklahoma | 40041 | 3359 | 45 |
906380 | 906380 | 2021-01-07 | Delaware | Oklahoma | 40041 | 3243 | 45 |
903134 | 903134 | 2021-01-06 | Delaware | Oklahoma | 40041 | 3200 | 44 |
899889 | 899889 | 2021-01-05 | Delaware | Oklahoma | 40041 | 3159 | 44 |
896644 | 896644 | 2021-01-04 | Delaware | Oklahoma | 40041 | 3143 | 44 |
893398 | 893398 | 2021-01-03 | Delaware | Oklahoma | 40041 | 3080 | 44 |
890152 | 890152 | 2021-01-02 | Delaware | Oklahoma | 40041 | 2977 | 44 |
886905 | 886905 | 2021-01-01 | Delaware | Oklahoma | 40041 | 2915 | 44 |
883660 | 883660 | 2020-12-31 | Delaware | Oklahoma | 40041 | 2915 | 44 |
880415 | 880415 | 2020-12-30 | Delaware | Oklahoma | 40041 | 2873 | 44 |
877170 | 877170 | 2020-12-29 | Delaware | Oklahoma | 40041 | 2838 | 44 |
873925 | 873925 | 2020-12-28 | Delaware | Oklahoma | 40041 | 2815 | 44 |
870680 | 870680 | 2020-12-27 | Delaware | Oklahoma | 40041 | 2775 | 44 |
867435 | 867435 | 2020-12-26 | Delaware | Oklahoma | 40041 | 2762 | 44 |
864190 | 864190 | 2020-12-25 | Delaware | Oklahoma | 40041 | 2720 | 43 |
860945 | 860945 | 2020-12-24 | Delaware | Oklahoma | 40041 | 2720 | 43 |
857700 | 857700 | 2020-12-23 | Delaware | Oklahoma | 40041 | 2704 | 43 |
854455 | 854455 | 2020-12-22 | Delaware | Oklahoma | 40041 | 2679 | 43 |
851210 | 851210 | 2020-12-21 | Delaware | Oklahoma | 40041 | 2640 | 43 |
847965 | 847965 | 2020-12-20 | Delaware | Oklahoma | 40041 | 2595 | 43 |
844720 | 844720 | 2020-12-19 | Delaware | Oklahoma | 40041 | 2555 | 43 |
841474 | 841474 | 2020-12-18 | Delaware | Oklahoma | 40041 | 2508 | 42 |
838229 | 838229 | 2020-12-17 | Delaware | Oklahoma | 40041 | 2446 | 42 |
834983 | 834983 | 2020-12-16 | Delaware | Oklahoma | 40041 | 2432 | 42 |
831737 | 831737 | 2020-12-15 | Delaware | Oklahoma | 40041 | 2411 | 39 |
828490 | 828490 | 2020-12-14 | Delaware | Oklahoma | 40041 | 2382 | 39 |
825244 | 825244 | 2020-12-13 | Delaware | Oklahoma | 40041 | 2338 | 39 |
821997 | 821997 | 2020-12-12 | Delaware | Oklahoma | 40041 | 2298 | 39 |
818751 | 818751 | 2020-12-11 | Delaware | Oklahoma | 40041 | 2232 | 39 |
815505 | 815505 | 2020-12-10 | Delaware | Oklahoma | 40041 | 2202 | 39 |
812259 | 812259 | 2020-12-09 | Delaware | Oklahoma | 40041 | 2169 | 39 |
809015 | 809015 | 2020-12-08 | Delaware | Oklahoma | 40041 | 2153 | 39 |
805770 | 805770 | 2020-12-07 | Delaware | Oklahoma | 40041 | 2130 | 39 |
802525 | 802525 | 2020-12-06 | Delaware | Oklahoma | 40041 | 2115 | 39 |
799280 | 799280 | 2020-12-05 | Delaware | Oklahoma | 40041 | 2083 | 39 |
796035 | 796035 | 2020-12-04 | Delaware | Oklahoma | 40041 | 2030 | 39 |
792790 | 792790 | 2020-12-03 | Delaware | Oklahoma | 40041 | 1993 | 39 |
789545 | 789545 | 2020-12-02 | Delaware | Oklahoma | 40041 | 1966 | 39 |
786300 | 786300 | 2020-12-01 | Delaware | Oklahoma | 40041 | 1963 | 39 |
783056 | 783056 | 2020-11-30 | Delaware | Oklahoma | 40041 | 1953 | 39 |
779810 | 779810 | 2020-11-29 | Delaware | Oklahoma | 40041 | 1935 | 39 |
776565 | 776565 | 2020-11-28 | Delaware | Oklahoma | 40041 | 1932 | 39 |
773320 | 773320 | 2020-11-27 | Delaware | Oklahoma | 40041 | 1884 | 39 |
770075 | 770075 | 2020-11-26 | Delaware | Oklahoma | 40041 | 1856 | 38 |
766829 | 766829 | 2020-11-25 | Delaware | Oklahoma | 40041 | 1856 | 38 |
763584 | 763584 | 2020-11-24 | Delaware | Oklahoma | 40041 | 1810 | 38 |
760339 | 760339 | 2020-11-23 | Delaware | Oklahoma | 40041 | 1800 | 38 |
757094 | 757094 | 2020-11-22 | Delaware | Oklahoma | 40041 | 1775 | 38 |
753847 | 753847 | 2020-11-21 | Delaware | Oklahoma | 40041 | 1740 | 38 |
750601 | 750601 | 2020-11-20 | Delaware | Oklahoma | 40041 | 1719 | 38 |
747355 | 747355 | 2020-11-19 | Delaware | Oklahoma | 40041 | 1676 | 38 |
744109 | 744109 | 2020-11-18 | Delaware | Oklahoma | 40041 | 1664 | 38 |
740862 | 740862 | 2020-11-17 | Delaware | Oklahoma | 40041 | 1644 | 37 |
737616 | 737616 | 2020-11-16 | Delaware | Oklahoma | 40041 | 1638 | 36 |
734372 | 734372 | 2020-11-15 | Delaware | Oklahoma | 40041 | 1621 | 35 |
731126 | 731126 | 2020-11-14 | Delaware | Oklahoma | 40041 | 1595 | 31 |
727882 | 727882 | 2020-11-13 | Delaware | Oklahoma | 40041 | 1565 | 31 |
724638 | 724638 | 2020-11-12 | Delaware | Oklahoma | 40041 | 1529 | 31 |
721395 | 721395 | 2020-11-11 | Delaware | Oklahoma | 40041 | 1507 | 31 |
718152 | 718152 | 2020-11-10 | Delaware | Oklahoma | 40041 | 1481 | 30 |
714909 | 714909 | 2020-11-09 | Delaware | Oklahoma | 40041 | 1465 | 30 |
711665 | 711665 | 2020-11-08 | Delaware | Oklahoma | 40041 | 1446 | 30 |
708421 | 708421 | 2020-11-07 | Delaware | Oklahoma | 40041 | 1446 | 30 |
705178 | 705178 | 2020-11-06 | Delaware | Oklahoma | 40041 | 1403 | 30 |
701935 | 701935 | 2020-11-05 | Delaware | Oklahoma | 40041 | 1381 | 30 |
698691 | 698691 | 2020-11-04 | Delaware | Oklahoma | 40041 | 1354 | 30 |
695448 | 695448 | 2020-11-03 | Delaware | Oklahoma | 40041 | 1346 | 29 |
692206 | 692206 | 2020-11-02 | Delaware | Oklahoma | 40041 | 1327 | 28 |
688962 | 688962 | 2020-11-01 | Delaware | Oklahoma | 40041 | 1319 | 28 |
685717 | 685717 | 2020-10-31 | Delaware | Oklahoma | 40041 | 1310 | 28 |
682474 | 682474 | 2020-10-30 | Delaware | Oklahoma | 40041 | 1291 | 28 |
679231 | 679231 | 2020-10-29 | Delaware | Oklahoma | 40041 | 1267 | 28 |
675988 | 675988 | 2020-10-28 | Delaware | Oklahoma | 40041 | 1260 | 28 |
672745 | 672745 | 2020-10-27 | Delaware | Oklahoma | 40041 | 1250 | 28 |
669503 | 669503 | 2020-10-26 | Delaware | Oklahoma | 40041 | 1248 | 27 |
666259 | 666259 | 2020-10-25 | Delaware | Oklahoma | 40041 | 1240 | 27 |
663014 | 663014 | 2020-10-24 | Delaware | Oklahoma | 40041 | 1225 | 27 |
659770 | 659770 | 2020-10-23 | Delaware | Oklahoma | 40041 | 1214 | 27 |
656526 | 656526 | 2020-10-22 | Delaware | Oklahoma | 40041 | 1190 | 27 |
653281 | 653281 | 2020-10-21 | Delaware | Oklahoma | 40041 | 1170 | 27 |
650036 | 650036 | 2020-10-20 | Delaware | Oklahoma | 40041 | 1146 | 27 |
646792 | 646792 | 2020-10-19 | Delaware | Oklahoma | 40041 | 1138 | 27 |
643546 | 643546 | 2020-10-18 | Delaware | Oklahoma | 40041 | 1134 | 27 |
640298 | 640298 | 2020-10-17 | Delaware | Oklahoma | 40041 | 1127 | 27 |
637052 | 637052 | 2020-10-16 | Delaware | Oklahoma | 40041 | 1114 | 27 |
633806 | 633806 | 2020-10-15 | Delaware | Oklahoma | 40041 | 1085 | 27 |
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);