ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and fips = 39047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055589 | 1055589 | 2021-02-22 | Fayette | Ohio | 39047 | 2647 | 42 |
1052343 | 1052343 | 2021-02-21 | Fayette | Ohio | 39047 | 2645 | 40 |
1049096 | 1049096 | 2021-02-20 | Fayette | Ohio | 39047 | 2640 | 40 |
1045849 | 1045849 | 2021-02-19 | Fayette | Ohio | 39047 | 2634 | 40 |
1042604 | 1042604 | 2021-02-18 | Fayette | Ohio | 39047 | 2631 | 39 |
1039359 | 1039359 | 2021-02-17 | Fayette | Ohio | 39047 | 2624 | 39 |
1036114 | 1036114 | 2021-02-16 | Fayette | Ohio | 39047 | 2611 | 39 |
1032869 | 1032869 | 2021-02-15 | Fayette | Ohio | 39047 | 2608 | 38 |
1029623 | 1029623 | 2021-02-14 | Fayette | Ohio | 39047 | 2600 | 38 |
1026376 | 1026376 | 2021-02-13 | Fayette | Ohio | 39047 | 2595 | 38 |
1023131 | 1023131 | 2021-02-12 | Fayette | Ohio | 39047 | 2589 | 37 |
1019886 | 1019886 | 2021-02-11 | Fayette | Ohio | 39047 | 2583 | 33 |
1016641 | 1016641 | 2021-02-10 | Fayette | Ohio | 39047 | 2575 | 33 |
1013396 | 1013396 | 2021-02-09 | Fayette | Ohio | 39047 | 2568 | 33 |
1010151 | 1010151 | 2021-02-08 | Fayette | Ohio | 39047 | 2545 | 33 |
1006905 | 1006905 | 2021-02-07 | Fayette | Ohio | 39047 | 2541 | 30 |
1003659 | 1003659 | 2021-02-06 | Fayette | Ohio | 39047 | 2537 | 30 |
1000413 | 1000413 | 2021-02-05 | Fayette | Ohio | 39047 | 2521 | 30 |
997167 | 997167 | 2021-02-04 | Fayette | Ohio | 39047 | 2514 | 30 |
993921 | 993921 | 2021-02-03 | Fayette | Ohio | 39047 | 2493 | 30 |
990675 | 990675 | 2021-02-02 | Fayette | Ohio | 39047 | 2478 | 30 |
987429 | 987429 | 2021-02-01 | Fayette | Ohio | 39047 | 2470 | 30 |
984182 | 984182 | 2021-01-31 | Fayette | Ohio | 39047 | 2467 | 30 |
980935 | 980935 | 2021-01-30 | Fayette | Ohio | 39047 | 2462 | 30 |
977689 | 977689 | 2021-01-29 | Fayette | Ohio | 39047 | 2454 | 30 |
974444 | 974444 | 2021-01-28 | Fayette | Ohio | 39047 | 2443 | 30 |
971199 | 971199 | 2021-01-27 | Fayette | Ohio | 39047 | 2421 | 30 |
967954 | 967954 | 2021-01-26 | Fayette | Ohio | 39047 | 2410 | 30 |
964710 | 964710 | 2021-01-25 | Fayette | Ohio | 39047 | 2395 | 30 |
961465 | 961465 | 2021-01-24 | Fayette | Ohio | 39047 | 2373 | 30 |
958220 | 958220 | 2021-01-23 | Fayette | Ohio | 39047 | 2365 | 30 |
954974 | 954974 | 2021-01-22 | Fayette | Ohio | 39047 | 2351 | 30 |
951729 | 951729 | 2021-01-21 | Fayette | Ohio | 39047 | 2344 | 29 |
948484 | 948484 | 2021-01-20 | Fayette | Ohio | 39047 | 2322 | 29 |
945238 | 945238 | 2021-01-19 | Fayette | Ohio | 39047 | 2297 | 29 |
941991 | 941991 | 2021-01-18 | Fayette | Ohio | 39047 | 2280 | 29 |
938746 | 938746 | 2021-01-17 | Fayette | Ohio | 39047 | 2255 | 29 |
935501 | 935501 | 2021-01-16 | Fayette | Ohio | 39047 | 2245 | 29 |
932256 | 932256 | 2021-01-15 | Fayette | Ohio | 39047 | 2222 | 29 |
929011 | 929011 | 2021-01-14 | Fayette | Ohio | 39047 | 2189 | 29 |
925766 | 925766 | 2021-01-13 | Fayette | Ohio | 39047 | 2162 | 29 |
922520 | 922520 | 2021-01-12 | Fayette | Ohio | 39047 | 2134 | 29 |
919275 | 919275 | 2021-01-11 | Fayette | Ohio | 39047 | 2101 | 29 |
916030 | 916030 | 2021-01-10 | Fayette | Ohio | 39047 | 2075 | 29 |
912785 | 912785 | 2021-01-09 | Fayette | Ohio | 39047 | 2067 | 29 |
909540 | 909540 | 2021-01-08 | Fayette | Ohio | 39047 | 2035 | 29 |
906295 | 906295 | 2021-01-07 | Fayette | Ohio | 39047 | 2008 | 29 |
903049 | 903049 | 2021-01-06 | Fayette | Ohio | 39047 | 1973 | 29 |
899804 | 899804 | 2021-01-05 | Fayette | Ohio | 39047 | 1946 | 29 |
896559 | 896559 | 2021-01-04 | Fayette | Ohio | 39047 | 1914 | 29 |
893313 | 893313 | 2021-01-03 | Fayette | Ohio | 39047 | 1895 | 29 |
890067 | 890067 | 2021-01-02 | Fayette | Ohio | 39047 | 1873 | 29 |
886820 | 886820 | 2021-01-01 | Fayette | Ohio | 39047 | 1806 | 29 |
883575 | 883575 | 2020-12-31 | Fayette | Ohio | 39047 | 1806 | 29 |
880330 | 880330 | 2020-12-30 | Fayette | Ohio | 39047 | 1769 | 29 |
877085 | 877085 | 2020-12-29 | Fayette | Ohio | 39047 | 1740 | 28 |
873840 | 873840 | 2020-12-28 | Fayette | Ohio | 39047 | 1694 | 28 |
870595 | 870595 | 2020-12-27 | Fayette | Ohio | 39047 | 1681 | 28 |
867350 | 867350 | 2020-12-26 | Fayette | Ohio | 39047 | 1672 | 28 |
864105 | 864105 | 2020-12-25 | Fayette | Ohio | 39047 | 1649 | 28 |
860860 | 860860 | 2020-12-24 | Fayette | Ohio | 39047 | 1649 | 28 |
857615 | 857615 | 2020-12-23 | Fayette | Ohio | 39047 | 1629 | 28 |
854370 | 854370 | 2020-12-22 | Fayette | Ohio | 39047 | 1604 | 26 |
851125 | 851125 | 2020-12-21 | Fayette | Ohio | 39047 | 1579 | 26 |
847880 | 847880 | 2020-12-20 | Fayette | Ohio | 39047 | 1554 | 26 |
844635 | 844635 | 2020-12-19 | Fayette | Ohio | 39047 | 1544 | 26 |
841389 | 841389 | 2020-12-18 | Fayette | Ohio | 39047 | 1516 | 26 |
838144 | 838144 | 2020-12-17 | Fayette | Ohio | 39047 | 1483 | 25 |
834898 | 834898 | 2020-12-16 | Fayette | Ohio | 39047 | 1446 | 25 |
831652 | 831652 | 2020-12-15 | Fayette | Ohio | 39047 | 1411 | 25 |
828405 | 828405 | 2020-12-14 | Fayette | Ohio | 39047 | 1384 | 22 |
825159 | 825159 | 2020-12-13 | Fayette | Ohio | 39047 | 1353 | 22 |
821912 | 821912 | 2020-12-12 | Fayette | Ohio | 39047 | 1332 | 22 |
818666 | 818666 | 2020-12-11 | Fayette | Ohio | 39047 | 1304 | 22 |
815420 | 815420 | 2020-12-10 | Fayette | Ohio | 39047 | 1278 | 22 |
812174 | 812174 | 2020-12-09 | Fayette | Ohio | 39047 | 1250 | 22 |
808930 | 808930 | 2020-12-08 | Fayette | Ohio | 39047 | 1224 | 22 |
805685 | 805685 | 2020-12-07 | Fayette | Ohio | 39047 | 1166 | 22 |
802440 | 802440 | 2020-12-06 | Fayette | Ohio | 39047 | 1139 | 22 |
799195 | 799195 | 2020-12-05 | Fayette | Ohio | 39047 | 1122 | 20 |
795950 | 795950 | 2020-12-04 | Fayette | Ohio | 39047 | 1099 | 17 |
792705 | 792705 | 2020-12-03 | Fayette | Ohio | 39047 | 1081 | 17 |
789460 | 789460 | 2020-12-02 | Fayette | Ohio | 39047 | 1062 | 17 |
786215 | 786215 | 2020-12-01 | Fayette | Ohio | 39047 | 1037 | 17 |
782971 | 782971 | 2020-11-30 | Fayette | Ohio | 39047 | 1018 | 17 |
779725 | 779725 | 2020-11-29 | Fayette | Ohio | 39047 | 1007 | 17 |
776480 | 776480 | 2020-11-28 | Fayette | Ohio | 39047 | 992 | 17 |
773235 | 773235 | 2020-11-27 | Fayette | Ohio | 39047 | 973 | 17 |
769990 | 769990 | 2020-11-26 | Fayette | Ohio | 39047 | 927 | 17 |
766744 | 766744 | 2020-11-25 | Fayette | Ohio | 39047 | 927 | 17 |
763499 | 763499 | 2020-11-24 | Fayette | Ohio | 39047 | 903 | 17 |
760254 | 760254 | 2020-11-23 | Fayette | Ohio | 39047 | 892 | 17 |
757009 | 757009 | 2020-11-22 | Fayette | Ohio | 39047 | 866 | 17 |
753762 | 753762 | 2020-11-21 | Fayette | Ohio | 39047 | 857 | 17 |
750516 | 750516 | 2020-11-20 | Fayette | Ohio | 39047 | 840 | 17 |
747270 | 747270 | 2020-11-19 | Fayette | Ohio | 39047 | 811 | 17 |
744024 | 744024 | 2020-11-18 | Fayette | Ohio | 39047 | 801 | 16 |
740777 | 740777 | 2020-11-17 | Fayette | Ohio | 39047 | 774 | 16 |
737531 | 737531 | 2020-11-16 | Fayette | Ohio | 39047 | 754 | 16 |
734287 | 734287 | 2020-11-15 | Fayette | Ohio | 39047 | 725 | 16 |
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);