ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

97 rows where county = "Jackson" and deaths = 34 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips 12

county 1

  • Jackson · 97 ✖
Link rowid date ▲ county state fips cases deaths
1972534 1972534 2021-12-01 Jackson Wisconsin 55053 3821 34
1969284 1969284 2021-11-30 Jackson Wisconsin 55053 3807 34
1966034 1966034 2021-11-29 Jackson Wisconsin 55053 3794 34
1962782 1962782 2021-11-28 Jackson Wisconsin 55053 3762 34
1959531 1959531 2021-11-27 Jackson Wisconsin 55053 3762 34
1956280 1956280 2021-11-26 Jackson Wisconsin 55053 3762 34
1953029 1953029 2021-11-25 Jackson Wisconsin 55053 3762 34
1949778 1949778 2021-11-24 Jackson Wisconsin 55053 3738 34
1946527 1946527 2021-11-23 Jackson Wisconsin 55053 3715 34
1943276 1943276 2021-11-22 Jackson Wisconsin 55053 3700 34
1940026 1940026 2021-11-21 Jackson Wisconsin 55053 3665 34
1936776 1936776 2021-11-20 Jackson Wisconsin 55053 3665 34
1933526 1933526 2021-11-19 Jackson Wisconsin 55053 3665 34
1930274 1930274 2021-11-18 Jackson Wisconsin 55053 3653 34
1927024 1927024 2021-11-17 Jackson Wisconsin 55053 3639 34
1923774 1923774 2021-11-16 Jackson Wisconsin 55053 3619 34
1920525 1920525 2021-11-15 Jackson Wisconsin 55053 3607 34
1917275 1917275 2021-11-14 Jackson Wisconsin 55053 3584 34
1914025 1914025 2021-11-13 Jackson Wisconsin 55053 3584 34
1910775 1910775 2021-11-12 Jackson Wisconsin 55053 3584 34
1907526 1907526 2021-11-11 Jackson Wisconsin 55053 3571 34
1904277 1904277 2021-11-10 Jackson Wisconsin 55053 3550 34
1901027 1901027 2021-11-09 Jackson Wisconsin 55053 3529 34
1897777 1897777 2021-11-08 Jackson Wisconsin 55053 3520 34
1894527 1894527 2021-11-07 Jackson Wisconsin 55053 3503 34
1891277 1891277 2021-11-06 Jackson Wisconsin 55053 3503 34
1888027 1888027 2021-11-05 Jackson Wisconsin 55053 3503 34
1133981 1133981 2021-03-18 Jackson Tennessee 47087 1267 34
1130733 1130733 2021-03-17 Jackson Tennessee 47087 1267 34
1127486 1127486 2021-03-16 Jackson Tennessee 47087 1266 34
1124240 1124240 2021-03-15 Jackson Tennessee 47087 1264 34
1120994 1120994 2021-03-14 Jackson Tennessee 47087 1260 34
1117747 1117747 2021-03-13 Jackson Tennessee 47087 1260 34
1114500 1114500 2021-03-12 Jackson Tennessee 47087 1260 34
1111254 1111254 2021-03-11 Jackson Tennessee 47087 1259 34
1108008 1108008 2021-03-10 Jackson Tennessee 47087 1259 34
1101516 1101516 2021-03-08 Jackson Tennessee 47087 1257 34
1098270 1098270 2021-03-07 Jackson Tennessee 47087 1257 34
1092596 1092596 2021-03-06 Jackson Arkansas 5067 3180 34
1095022 1095022 2021-03-06 Jackson Tennessee 47087 1257 34
1089350 1089350 2021-03-05 Jackson Arkansas 5067 3180 34
1091776 1091776 2021-03-05 Jackson Tennessee 47087 1257 34
1088530 1088530 2021-03-04 Jackson Tennessee 47087 1256 34
1085285 1085285 2021-03-03 Jackson Tennessee 47087 1253 34
1082039 1082039 2021-03-02 Jackson Tennessee 47087 1252 34
1078793 1078793 2021-03-01 Jackson Tennessee 47087 1251 34
1075548 1075548 2021-02-28 Jackson Tennessee 47087 1250 34
1072302 1072302 2021-02-27 Jackson Tennessee 47087 1250 34
1069056 1069056 2021-02-26 Jackson Tennessee 47087 1251 34
1065811 1065811 2021-02-25 Jackson Tennessee 47087 1250 34
1062566 1062566 2021-02-24 Jackson Tennessee 47087 1248 34
979695 979695 2021-01-30 Jackson Iowa 19097 1992 34
917228 917228 2021-01-11 Jackson Alabama 1071 5631 34
913983 913983 2021-01-10 Jackson Alabama 1071 5611 34
910738 910738 2021-01-09 Jackson Alabama 1071 5567 34
907493 907493 2021-01-08 Jackson Alabama 1071 5495 34
904247 904247 2021-01-07 Jackson Alabama 1071 5466 34
901002 901002 2021-01-06 Jackson Alabama 1071 5420 34
897757 897757 2021-01-05 Jackson Alabama 1071 5324 34
899820 899820 2021-01-05 Jackson Ohio 39079 2249 34
894511 894511 2021-01-04 Jackson Alabama 1071 5265 34
896575 896575 2021-01-04 Jackson Ohio 39079 2235 34
891265 891265 2021-01-03 Jackson Alabama 1071 5254 34
893329 893329 2021-01-03 Jackson Ohio 39079 2202 34
888018 888018 2021-01-02 Jackson Alabama 1071 5217 34
890083 890083 2021-01-02 Jackson Ohio 39079 2183 34
884773 884773 2021-01-01 Jackson Alabama 1071 5183 34
881528 881528 2020-12-31 Jackson Alabama 1071 5097 34
878283 878283 2020-12-30 Jackson Alabama 1071 5028 34
875038 875038 2020-12-29 Jackson Alabama 1071 4959 34
871793 871793 2020-12-28 Jackson Alabama 1071 4915 34
868548 868548 2020-12-27 Jackson Alabama 1071 4897 34
865303 865303 2020-12-26 Jackson Alabama 1071 4884 34
862058 862058 2020-12-25 Jackson Alabama 1071 4872 34
858813 858813 2020-12-24 Jackson Alabama 1071 4834 34
855568 855568 2020-12-23 Jackson Alabama 1071 4787 34
830713 830713 2020-12-15 Jackson Louisiana 22049 1273 34
827467 827467 2020-12-14 Jackson Louisiana 22049 1260 34
824220 824220 2020-12-13 Jackson Louisiana 22049 1263 34
820974 820974 2020-12-12 Jackson Louisiana 22049 1251 34
817728 817728 2020-12-11 Jackson Louisiana 22049 1251 34
814482 814482 2020-12-10 Jackson Louisiana 22049 1244 34
792802 792802 2020-12-03 Jackson Oklahoma 40065 1946 34
762055 762055 2020-11-24 Jackson Illinois 17077 2503 34
762154 762154 2020-11-24 Jackson Indiana 18071 2130 34
758810 758810 2020-11-23 Jackson Illinois 17077 2472 34
758909 758909 2020-11-23 Jackson Indiana 18071 2067 34
755563 755563 2020-11-22 Jackson Illinois 17077 2440 34
755662 755662 2020-11-22 Jackson Indiana 18071 2005 34
752416 752416 2020-11-21 Jackson Indiana 18071 1957 34
596437 596437 2020-10-04 Jackson Georgia 13157 2066 34
593195 593195 2020-10-03 Jackson Georgia 13157 2061 34
397026 397026 2020-08-03 Jackson Mississippi 28059 1994 34
393810 393810 2020-08-02 Jackson Mississippi 28059 1929 34
390593 390593 2020-08-01 Jackson Mississippi 28059 1874 34
387376 387376 2020-07-31 Jackson Mississippi 28059 1837 34
384158 384158 2020-07-30 Jackson Mississippi 28059 1820 34

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);