ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 5862 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Mississippi 9
- Tennessee 9
- Texas 9
- Arkansas 5
- Georgia 5
- Michigan 5
- Ohio 5
- New Hampshire 4
- Idaho 3
- Indiana 3
- Minnesota 3
- New York 3
- North Carolina 3
- California 2
- Florida 2
- Iowa 2
- Kansas 2
- Virginia 2
- West Virginia 2
- Alaska 1
- Kentucky 1
- Louisiana 1
- Nebraska 1
- Puerto Rico 1
- South Carolina 1
- South Dakota 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492153 | 2492153 | 2022-05-10 | Camuy | Puerto Rico | 72027 | 5862 | |
2456735 | 2456735 | 2022-04-29 | Karnes | Texas | 48255 | 5862 | 70 |
2453479 | 2453479 | 2022-04-28 | Karnes | Texas | 48255 | 5862 | 70 |
2433897 | 2433897 | 2022-04-22 | Frio | Texas | 48163 | 5862 | 93 |
2429724 | 2429724 | 2022-04-21 | Unknown | New Hampshire | 5862 | 2 | |
2193828 | 2193828 | 2022-02-08 | Carroll | Arkansas | 5015 | 5862 | 87 |
2169560 | 2169560 | 2022-01-31 | Lewis | New York | 36049 | 5862 | 45 |
2126768 | 2126768 | 2022-01-18 | Nobles | Minnesota | 27105 | 5862 | 56 |
2057002 | 2057002 | 2021-12-27 | Randolph | West Virginia | 54083 | 5862 | 63 |
2005648 | 2005648 | 2021-12-12 | Wayne | Georgia | 13305 | 5862 | 176 |
2002397 | 2002397 | 2021-12-11 | Wayne | Georgia | 13305 | 5862 | 176 |
1999147 | 1999147 | 2021-12-10 | Wayne | Georgia | 13305 | 5862 | 176 |
1991717 | 1991717 | 2021-12-07 | Washington | Texas | 48477 | 5862 | 133 |
1983649 | 1983649 | 2021-12-05 | Mecosta | Michigan | 26107 | 5862 | 71 |
1980399 | 1980399 | 2021-12-04 | Mecosta | Michigan | 26107 | 5862 | 71 |
1977149 | 1977149 | 2021-12-03 | Mecosta | Michigan | 26107 | 5862 | 71 |
1968091 | 1968091 | 2021-11-30 | Scotland | North Carolina | 37165 | 5862 | 109 |
1961017 | 1961017 | 2021-11-28 | Alcorn | Mississippi | 28003 | 5862 | 107 |
1957766 | 1957766 | 2021-11-27 | Alcorn | Mississippi | 28003 | 5862 | 107 |
1954515 | 1954515 | 2021-11-26 | Alcorn | Mississippi | 28003 | 5862 | 107 |
1951264 | 1951264 | 2021-11-25 | Alcorn | Mississippi | 28003 | 5862 | 107 |
1948013 | 1948013 | 2021-11-24 | Alcorn | Mississippi | 28003 | 5862 | 107 |
1929570 | 1929570 | 2021-11-18 | Codington | South Dakota | 46029 | 5862 | 85 |
1895604 | 1895604 | 2021-11-08 | Bell | Kentucky | 21013 | 5862 | 97 |
1895737 | 1895737 | 2021-11-08 | Evangeline | Louisiana | 22039 | 5862 | 140 |
1875815 | 1875815 | 2021-11-02 | Clinton | Indiana | 18023 | 5862 | 78 |
1860326 | 1860326 | 2021-10-28 | Pike | Mississippi | 28113 | 5862 | 154 |
1854431 | 1854431 | 2021-10-26 | Clinton | Ohio | 39027 | 5862 | 94 |
1849176 | 1849176 | 2021-10-25 | Bethel Census Area | Alaska | 2050 | 5862 | 27 |
1847643 | 1847643 | 2021-10-24 | Grafton | New Hampshire | 33009 | 5862 | 30 |
1844393 | 1844393 | 2021-10-23 | Grafton | New Hampshire | 33009 | 5862 | 30 |
1841143 | 1841143 | 2021-10-22 | Grafton | New Hampshire | 33009 | 5862 | 30 |
1798991 | 1798991 | 2021-10-09 | Madison | New York | 36053 | 5862 | 98 |
1719255 | 1719255 | 2021-09-15 | Boone | Arkansas | 5009 | 5862 | 106 |
1710819 | 1710819 | 2021-09-12 | Bolivar | Mississippi | 28011 | 5862 | 143 |
1707572 | 1707572 | 2021-09-11 | Bolivar | Mississippi | 28011 | 5862 | 143 |
1704325 | 1704325 | 2021-09-10 | Bolivar | Mississippi | 28011 | 5862 | 143 |
1702644 | 1702644 | 2021-09-09 | James City | Virginia | 51095 | 5862 | 81 |
1695818 | 1695818 | 2021-09-07 | Cherokee | Texas | 48073 | 5862 | 160 |
1692570 | 1692570 | 2021-09-06 | Cherokee | Texas | 48073 | 5862 | 159 |
1689321 | 1689321 | 2021-09-05 | Cherokee | Texas | 48073 | 5862 | 157 |
1686071 | 1686071 | 2021-09-04 | Cherokee | Texas | 48073 | 5862 | 157 |
1621062 | 1621062 | 2021-08-15 | Warren | Tennessee | 47177 | 5862 | 86 |
1617814 | 1617814 | 2021-08-14 | Warren | Tennessee | 47177 | 5862 | 86 |
1614566 | 1614566 | 2021-08-13 | Warren | Tennessee | 47177 | 5862 | 86 |
1564141 | 1564141 | 2021-07-29 | Ford | Kansas | 20057 | 5862 | 80 |
1560893 | 1560893 | 2021-07-28 | Ford | Kansas | 20057 | 5862 | 80 |
1493922 | 1493922 | 2021-07-07 | Union | Ohio | 39159 | 5862 | 49 |
1444478 | 1444478 | 2021-06-22 | Otter Tail | Minnesota | 27111 | 5862 | 84 |
1441233 | 1441233 | 2021-06-21 | Otter Tail | Minnesota | 27111 | 5862 | 84 |
1361506 | 1361506 | 2021-05-27 | Navarro | Texas | 48349 | 5862 | 154 |
1352936 | 1352936 | 2021-05-25 | Dearborn | Indiana | 18029 | 5862 | 81 |
1313411 | 1313411 | 2021-05-13 | Mississippi | Arkansas | 5093 | 5862 | 107 |
1311875 | 1311875 | 2021-05-12 | Jefferson | New York | 36045 | 5862 | 66 |
1212559 | 1212559 | 2021-04-11 | Sauk | Wisconsin | 55111 | 5862 | 51 |
1200929 | 1200929 | 2021-04-08 | Van Buren | Michigan | 26159 | 5862 | 103 |
1167349 | 1167349 | 2021-03-29 | San Benito | California | 6069 | 5862 | 61 |
1164101 | 1164101 | 2021-03-28 | San Benito | California | 6069 | 5862 | 61 |
1062581 | 1062581 | 2021-02-24 | McMinn | Tennessee | 47107 | 5862 | 89 |
1039367 | 1039367 | 2021-02-17 | Hancock | Ohio | 39063 | 5862 | 109 |
1039811 | 1039811 | 2021-02-17 | Carter | Tennessee | 47019 | 5862 | 147 |
982686 | 982686 | 2021-01-31 | Madison | Idaho | 16065 | 5862 | 21 |
979440 | 979440 | 2021-01-30 | Madison | Idaho | 16065 | 5862 | 21 |
953018 | 953018 | 2021-01-22 | Crawford | Arkansas | 5033 | 5862 | 82 |
954876 | 954876 | 2021-01-22 | Sampson | North Carolina | 37163 | 5862 | 76 |
946854 | 946854 | 2021-01-20 | Gordon | Georgia | 13129 | 5862 | 78 |
948314 | 948314 | 2021-01-20 | Brunswick | North Carolina | 37019 | 5862 | 82 |
929959 | 929959 | 2021-01-14 | Roanoke city | Virginia | 51770 | 5862 | 110 |
921161 | 921161 | 2021-01-12 | Floyd | Indiana | 18043 | 5862 | 110 |
913311 | 913311 | 2021-01-09 | Tipton | Tennessee | 47167 | 5862 | 57 |
887294 | 887294 | 2021-01-01 | Hamblen | Tennessee | 47063 | 5862 | 86 |
884049 | 884049 | 2020-12-31 | Hamblen | Tennessee | 47063 | 5862 | 86 |
839865 | 839865 | 2020-12-18 | Bannock | Idaho | 16005 | 5862 | 51 |
821939 | 821939 | 2020-12-12 | Marion | Ohio | 39101 | 5862 | 79 |
812694 | 812694 | 2020-12-09 | Sevier | Tennessee | 47155 | 5862 | 41 |
790493 | 790493 | 2020-12-02 | Kanawha | West Virginia | 54039 | 5862 | 148 |
756177 | 756177 | 2020-11-22 | Berrien | Michigan | 26021 | 5862 | 106 |
745551 | 745551 | 2020-11-19 | Martin | Florida | 12085 | 5862 | 170 |
697070 | 697070 | 2020-11-04 | Whitfield | Georgia | 13313 | 5862 | 64 |
668182 | 668182 | 2020-10-26 | Johnson | Iowa | 19103 | 5862 | 30 |
632018 | 632018 | 2020-10-15 | St. Johns | Florida | 12109 | 5862 | 78 |
617841 | 617841 | 2020-10-10 | Beaufort | South Carolina | 45013 | 5862 | 88 |
590379 | 590379 | 2020-10-02 | Woodbury | Iowa | 19193 | 5862 | 69 |
531301 | 531301 | 2020-09-14 | Benton | Arkansas | 5007 | 5862 | 62 |
241761 | 241761 | 2020-06-15 | Douglas | Nebraska | 31055 | 5862 | 61 |
195740 | 195740 | 2020-05-31 | Franklin | Ohio | 39049 | 5862 | 262 |
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);