ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where cases = 6147 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Tennessee 17
- Ohio 9
- Kentucky 6
- West Virginia 6
- Indiana 5
- Missouri 5
- North Carolina 4
- Arkansas 3
- Colorado 3
- Pennsylvania 3
- Texas 3
- Florida 2
- Georgia 2
- Maryland 1
- Minnesota 1
- Mississippi 1
- Nebraska 1
- New Jersey 1
- New York 1
- Oregon 1
- Puerto Rico 1
- Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497528 | 2497528 | 2022-05-12 | Caroline | Maryland | 24011 | 6147 | 80 |
2332866 | 2332866 | 2022-03-22 | Haywood | Tennessee | 47075 | 6147 | 99 |
2329613 | 2329613 | 2022-03-21 | Haywood | Tennessee | 47075 | 6147 | 99 |
2326361 | 2326361 | 2022-03-20 | Haywood | Tennessee | 47075 | 6147 | 99 |
2323108 | 2323108 | 2022-03-19 | Haywood | Tennessee | 47075 | 6147 | 99 |
2319854 | 2319854 | 2022-03-18 | Haywood | Tennessee | 47075 | 6147 | 99 |
2316600 | 2316600 | 2022-03-17 | Haywood | Tennessee | 47075 | 6147 | 99 |
2313347 | 2313347 | 2022-03-16 | Haywood | Tennessee | 47075 | 6147 | 99 |
2233030 | 2233030 | 2022-02-20 | Pitkin | Colorado | 8097 | 6147 | 6 |
2229779 | 2229779 | 2022-02-19 | Pitkin | Colorado | 8097 | 6147 | 6 |
2226528 | 2226528 | 2022-02-18 | Pitkin | Colorado | 8097 | 6147 | 6 |
2198636 | 2198636 | 2022-02-09 | Adams | Nebraska | 31001 | 6147 | 69 |
2190308 | 2190308 | 2022-02-06 | Boone | West Virginia | 54005 | 6147 | 64 |
2157413 | 2157413 | 2022-01-27 | Hutchinson | Texas | 48233 | 6147 | 120 |
2133984 | 2133984 | 2022-01-20 | Gallia | Ohio | 39053 | 6147 | 91 |
2130073 | 2130073 | 2022-01-19 | Covington | Mississippi | 28031 | 6147 | 98 |
2106897 | 2106897 | 2022-01-12 | Calloway | Kentucky | 21035 | 6147 | 70 |
2105232 | 2105232 | 2022-01-11 | Scott | Tennessee | 47151 | 6147 | 90 |
2101981 | 2101981 | 2022-01-10 | Scott | Tennessee | 47151 | 6147 | 90 |
2096291 | 2096291 | 2022-01-09 | Poinsett | Arkansas | 5111 | 6147 | 107 |
2097708 | 2097708 | 2022-01-09 | Polk | Missouri | 29167 | 6147 | 83 |
2098730 | 2098730 | 2022-01-09 | Scott | Tennessee | 47151 | 6147 | 90 |
2093039 | 2093039 | 2022-01-08 | Poinsett | Arkansas | 5111 | 6147 | 107 |
2095478 | 2095478 | 2022-01-08 | Scott | Tennessee | 47151 | 6147 | 90 |
2092226 | 2092226 | 2022-01-07 | Scott | Tennessee | 47151 | 6147 | 90 |
2088974 | 2088974 | 2022-01-06 | Scott | Tennessee | 47151 | 6147 | 90 |
2084670 | 2084670 | 2022-01-05 | Laclede | Missouri | 29105 | 6147 | 154 |
2085723 | 2085723 | 2022-01-05 | Scott | Tennessee | 47151 | 6147 | 90 |
2081844 | 2081844 | 2022-01-04 | Person | North Carolina | 37145 | 6147 | 94 |
2082471 | 2082471 | 2022-01-04 | Scott | Tennessee | 47151 | 6147 | 90 |
2009447 | 2009447 | 2021-12-13 | Muhlenberg | Kentucky | 21177 | 6147 | 98 |
1967646 | 1967646 | 2021-11-30 | Howell | Missouri | 29091 | 6147 | 168 |
1960316 | 1960316 | 2021-11-28 | Clinton | Indiana | 18023 | 6147 | 81 |
1957065 | 1957065 | 2021-11-27 | Clinton | Indiana | 18023 | 6147 | 81 |
1953814 | 1953814 | 2021-11-26 | Clinton | Indiana | 18023 | 6147 | 81 |
1955228 | 1955228 | 2021-11-26 | Preble | Ohio | 39135 | 6147 | 139 |
1950563 | 1950563 | 2021-11-25 | Clinton | Indiana | 18023 | 6147 | 81 |
1947312 | 1947312 | 2021-11-24 | Clinton | Indiana | 18023 | 6147 | 81 |
1922669 | 1922669 | 2021-11-16 | Clinton | Ohio | 39027 | 6147 | 105 |
1877196 | 1877196 | 2021-11-02 | Highland | Ohio | 39071 | 6147 | 107 |
1877206 | 1877206 | 2021-11-02 | Logan | Ohio | 39091 | 6147 | 101 |
1830962 | 1830962 | 2021-10-19 | Goodhue | Minnesota | 27049 | 6147 | 84 |
1831190 | 1831190 | 2021-10-19 | Phelps | Missouri | 29161 | 6147 | 179 |
1818692 | 1818692 | 2021-10-15 | Crawford | Ohio | 39033 | 6147 | 130 |
1813481 | 1813481 | 2021-10-14 | Boone | Arkansas | 5009 | 6147 | 126 |
1750250 | 1750250 | 2021-09-24 | Genesee | New York | 36037 | 6147 | 131 |
1691027 | 1691027 | 2021-09-06 | Whitley | Kentucky | 21235 | 6147 | 65 |
1687777 | 1687777 | 2021-09-05 | Whitley | Kentucky | 21235 | 6147 | 65 |
1684527 | 1684527 | 2021-09-04 | Whitley | Kentucky | 21235 | 6147 | 65 |
1681276 | 1681276 | 2021-09-03 | Whitley | Kentucky | 21235 | 6147 | 65 |
1617599 | 1617599 | 2021-08-14 | Unknown | Puerto Rico | 6147 | 2658 | |
1583184 | 1583184 | 2021-08-04 | Laurens | Georgia | 13175 | 6147 | 173 |
1582110 | 1582110 | 2021-08-03 | Caldwell | Texas | 48055 | 6147 | 101 |
1533015 | 1533015 | 2021-07-19 | Bradford | Pennsylvania | 42015 | 6147 | 96 |
1529768 | 1529768 | 2021-07-18 | Bradford | Pennsylvania | 42015 | 6147 | 96 |
1526521 | 1526521 | 2021-07-17 | Bradford | Pennsylvania | 42015 | 6147 | 96 |
1442964 | 1442964 | 2021-06-21 | Harrison | West Virginia | 54033 | 6147 | 80 |
1439719 | 1439719 | 2021-06-20 | Harrison | West Virginia | 54033 | 6147 | 80 |
1436472 | 1436472 | 2021-06-19 | Harrison | West Virginia | 54033 | 6147 | 80 |
1433225 | 1433225 | 2021-06-18 | Harrison | West Virginia | 54033 | 6147 | 80 |
1429979 | 1429979 | 2021-06-17 | Harrison | West Virginia | 54033 | 6147 | 80 |
1409458 | 1409458 | 2021-06-11 | Belmont | Ohio | 39013 | 6147 | 174 |
1357420 | 1357420 | 2021-05-26 | Lenoir | North Carolina | 37107 | 6147 | 117 |
1216258 | 1216258 | 2021-04-13 | Catoosa | Georgia | 13047 | 6147 | 66 |
1156666 | 1156666 | 2021-03-25 | Bedford | Tennessee | 47003 | 6147 | 124 |
1156723 | 1156723 | 2021-03-25 | McMinn | Tennessee | 47107 | 6147 | 94 |
1133646 | 1133646 | 2021-03-18 | Deschutes | Oregon | 41017 | 6147 | 70 |
1099285 | 1099285 | 2021-03-08 | Flagler | Florida | 12035 | 6147 | 94 |
1011048 | 1011048 | 2021-02-08 | Hanover | Virginia | 51085 | 6147 | 104 |
980836 | 980836 | 2021-01-30 | Rutherford | North Carolina | 37161 | 6147 | 168 |
977590 | 977590 | 2021-01-29 | Rutherford | North Carolina | 37161 | 6147 | 168 |
956485 | 956485 | 2021-01-23 | Highlands | Florida | 12055 | 6147 | 244 |
886811 | 886811 | 2021-01-01 | Columbiana | Ohio | 39029 | 6147 | 119 |
883566 | 883566 | 2020-12-31 | Columbiana | Ohio | 39029 | 6147 | 119 |
849032 | 849032 | 2020-12-20 | Natrona | Wyoming | 56025 | 6147 | 74 |
484270 | 484270 | 2020-08-30 | St. Louis city | Missouri | 29510 | 6147 | 188 |
432791 | 432791 | 2020-08-14 | Burlington | New Jersey | 34005 | 6147 | 477 |
378925 | 378925 | 2020-07-28 | Collin | Texas | 48085 | 6147 | 80 |
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);