ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where cases = 5816 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Louisiana 11
- South Carolina 8
- Virginia 8
- Ohio 6
- Texas 6
- Georgia 5
- Colorado 4
- Wisconsin 4
- California 3
- Missouri 3
- New York 3
- Pennsylvania 3
- Illinois 2
- Indiana 2
- Kansas 2
- Minnesota 2
- North Carolina 2
- Florida 1
- Idaho 1
- Iowa 1
- Kentucky 1
- Maryland 1
- Michigan 1
- South Dakota 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399129 | 2399129 | 2022-04-12 | Pierce | Georgia | 13229 | 5816 | 133 |
2395874 | 2395874 | 2022-04-11 | Pierce | Georgia | 13229 | 5816 | 133 |
2375013 | 2375013 | 2022-04-04 | Barnwell | South Carolina | 45011 | 5816 | 102 |
2371761 | 2371761 | 2022-04-03 | Barnwell | South Carolina | 45011 | 5816 | 102 |
2368508 | 2368508 | 2022-04-02 | Barnwell | South Carolina | 45011 | 5816 | 102 |
2365255 | 2365255 | 2022-04-01 | Barnwell | South Carolina | 45011 | 5816 | 102 |
2362002 | 2362002 | 2022-03-31 | Barnwell | South Carolina | 45011 | 5816 | 102 |
2358748 | 2358748 | 2022-03-30 | Barnwell | South Carolina | 45011 | 5816 | 102 |
2355494 | 2355494 | 2022-03-29 | Barnwell | South Carolina | 45011 | 5816 | 102 |
2308288 | 2308288 | 2022-03-15 | Owen | Indiana | 18119 | 5816 | 114 |
2286136 | 2286136 | 2022-03-08 | Meeker | Minnesota | 27093 | 5816 | 74 |
2284696 | 2284696 | 2022-03-07 | Kewaunee | Wisconsin | 55061 | 5816 | 55 |
2263138 | 2263138 | 2022-03-01 | Grant | Louisiana | 22043 | 5816 | 86 |
2259887 | 2259887 | 2022-02-28 | Grant | Louisiana | 22043 | 5816 | 86 |
2256636 | 2256636 | 2022-02-27 | Grant | Louisiana | 22043 | 5816 | 86 |
2253385 | 2253385 | 2022-02-26 | Grant | Louisiana | 22043 | 5816 | 86 |
2250134 | 2250134 | 2022-02-25 | Grant | Louisiana | 22043 | 5816 | 86 |
2241719 | 2241719 | 2022-02-22 | Davison | South Dakota | 46035 | 5816 | 78 |
2235744 | 2235744 | 2022-02-20 | Mecklenburg | Virginia | 51117 | 5816 | 107 |
2232493 | 2232493 | 2022-02-19 | Mecklenburg | Virginia | 51117 | 5816 | 107 |
2229242 | 2229242 | 2022-02-18 | Mecklenburg | Virginia | 51117 | 5816 | 107 |
2217690 | 2217690 | 2022-02-15 | Caroline | Maryland | 24011 | 5816 | 77 |
2213978 | 2213978 | 2022-02-14 | LaGrange | Indiana | 18087 | 5816 | 99 |
2215675 | 2215675 | 2022-02-14 | Jasper | South Carolina | 45053 | 5816 | 90 |
2210265 | 2210265 | 2022-02-13 | Montezuma | Colorado | 8083 | 5816 | 64 |
2207012 | 2207012 | 2022-02-12 | Montezuma | Colorado | 8083 | 5816 | 64 |
2203759 | 2203759 | 2022-02-11 | Montezuma | Colorado | 8083 | 5816 | 64 |
2178031 | 2178031 | 2022-02-03 | Jefferson | Idaho | 16051 | 5816 | 57 |
2059089 | 2059089 | 2021-12-28 | Person | North Carolina | 37145 | 5816 | 93 |
2014825 | 2014825 | 2021-12-14 | Trempealeau | Wisconsin | 55121 | 5816 | 52 |
1996290 | 1996290 | 2021-12-09 | Harvey | Kansas | 20079 | 5816 | 94 |
1993039 | 1993039 | 2021-12-08 | Harvey | Kansas | 20079 | 5816 | 94 |
1988452 | 1988452 | 2021-12-06 | Titus | Texas | 48449 | 5816 | 104 |
1984647 | 1984647 | 2021-12-05 | Greene | Pennsylvania | 42059 | 5816 | 69 |
1985202 | 1985202 | 2021-12-05 | Titus | Texas | 48449 | 5816 | 104 |
1952162 | 1952162 | 2021-11-25 | Perry | Pennsylvania | 42099 | 5816 | 132 |
1925974 | 1925974 | 2021-11-17 | Putnam | Ohio | 39137 | 5816 | 116 |
1922582 | 1922582 | 2021-11-16 | Scotland | North Carolina | 37165 | 5816 | 109 |
1909206 | 1909206 | 2021-11-12 | Webster | Missouri | 29225 | 5816 | 94 |
1894080 | 1894080 | 2021-11-07 | Hill | Texas | 48217 | 5816 | 163 |
1890830 | 1890830 | 2021-11-06 | Hill | Texas | 48217 | 5816 | 163 |
1787915 | 1787915 | 2021-10-06 | Wayne | Georgia | 13305 | 5816 | 159 |
1779704 | 1779704 | 2021-10-03 | Crawford | Ohio | 39033 | 5816 | 125 |
1683649 | 1683649 | 2021-09-04 | Tuolumne | California | 6109 | 5816 | 94 |
1680398 | 1680398 | 2021-09-03 | Tuolumne | California | 6109 | 5816 | 94 |
1671582 | 1671582 | 2021-08-31 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1668335 | 1668335 | 2021-08-30 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1665088 | 1665088 | 2021-08-29 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1661840 | 1661840 | 2021-08-28 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1658592 | 1658592 | 2021-08-27 | St. John the Baptist | Louisiana | 22095 | 5816 | 153 |
1591057 | 1591057 | 2021-08-06 | Cattaraugus | New York | 36009 | 5816 | 93 |
1577787 | 1577787 | 2021-08-02 | Pettis | Missouri | 29159 | 5816 | 79 |
1534468 | 1534468 | 2021-07-20 | Laurens | Georgia | 13175 | 5816 | 173 |
1515121 | 1515121 | 2021-07-14 | Clinton | Illinois | 17027 | 5816 | 101 |
1463666 | 1463666 | 2021-06-28 | Pike | Kentucky | 21195 | 5816 | 106 |
1446022 | 1446022 | 2021-06-22 | Albemarle | Virginia | 51003 | 5816 | 85 |
1442777 | 1442777 | 2021-06-21 | Albemarle | Virginia | 51003 | 5816 | 85 |
1439532 | 1439532 | 2021-06-20 | Albemarle | Virginia | 51003 | 5816 | 85 |
1385562 | 1385562 | 2021-06-04 | Warren | Iowa | 19181 | 5816 | 90 |
1360090 | 1360090 | 2021-05-27 | Otter Tail | Minnesota | 27111 | 5816 | 79 |
1361338 | 1361338 | 2021-05-27 | Atascosa | Texas | 48013 | 5816 | 150 |
1316051 | 1316051 | 2021-05-13 | Navarro | Texas | 48349 | 5816 | 154 |
1300536 | 1300536 | 2021-05-09 | Garfield | Colorado | 8045 | 5816 | 38 |
1300184 | 1300184 | 2021-05-08 | Columbia | Wisconsin | 55021 | 5816 | 69 |
1292794 | 1292794 | 2021-05-06 | Armstrong | Pennsylvania | 42005 | 5816 | 133 |
1282857 | 1282857 | 2021-05-03 | Belmont | Ohio | 39013 | 5816 | 163 |
1145698 | 1145698 | 2021-03-22 | Montcalm | Michigan | 26117 | 5816 | 96 |
1112151 | 1112151 | 2021-03-12 | San Benito | California | 6069 | 5816 | 61 |
1088488 | 1088488 | 2021-03-04 | Bedford | Tennessee | 47003 | 5816 | 120 |
1088895 | 1088895 | 2021-03-04 | Bedford | Virginia | 51019 | 5816 | 73 |
1042653 | 1042653 | 2021-02-18 | Scioto | Ohio | 39145 | 5816 | 101 |
1032873 | 1032873 | 2021-02-15 | Geauga | Ohio | 39055 | 5816 | 125 |
1015162 | 1015162 | 2021-02-10 | Boone | Illinois | 17007 | 5816 | 86 |
960525 | 960525 | 2021-01-24 | Iberia | Louisiana | 22045 | 5816 | 132 |
886634 | 886634 | 2021-01-01 | Ulster | New York | 36111 | 5816 | 143 |
874957 | 874957 | 2020-12-28 | Portage | Wisconsin | 55097 | 5816 | 51 |
868846 | 868846 | 2020-12-27 | Columbia | Florida | 12023 | 5816 | 116 |
825202 | 825202 | 2020-12-13 | Portage | Ohio | 39133 | 5816 | 88 |
791070 | 791070 | 2020-12-03 | Floyd | Georgia | 13115 | 5816 | 88 |
782734 | 782734 | 2020-11-30 | Albany | New York | 36001 | 5816 | 146 |
725478 | 725478 | 2020-11-12 | Norfolk city | Virginia | 51710 | 5816 | 86 |
702824 | 702824 | 2020-11-05 | Benton | Washington | 53005 | 5816 | 140 |
455193 | 455193 | 2020-08-21 | St. Louis city | Missouri | 29510 | 5816 | 182 |
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);