ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
175 rows where cases = 3205 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 17
- Ohio 16
- Georgia 12
- Mississippi 9
- North Carolina 9
- Alabama 7
- Arkansas 7
- Iowa 7
- Michigan 7
- Oklahoma 7
- Virginia 7
- Puerto Rico 6
- Texas 6
- Minnesota 5
- Pennsylvania 5
- Colorado 4
- Oregon 4
- Washington 4
- Wisconsin 4
- Idaho 3
- Illinois 3
- Louisiana 3
- Montana 3
- New York 3
- Indiana 2
- Kentucky 2
- South Carolina 2
- California 1
- Delaware 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485647 | 2485647 | 2022-05-08 | Comerio | Puerto Rico | 72045 | 3205 | |
2482389 | 2482389 | 2022-05-07 | Comerio | Puerto Rico | 72045 | 3205 | |
2469578 | 2469578 | 2022-05-03 | Jackson | Tennessee | 47087 | 3205 | 63 |
2466322 | 2466322 | 2022-05-02 | Jackson | Tennessee | 47087 | 3205 | 63 |
2463067 | 2463067 | 2022-05-01 | Jackson | Tennessee | 47087 | 3205 | 63 |
2459811 | 2459811 | 2022-04-30 | Jackson | Tennessee | 47087 | 3205 | 63 |
2456555 | 2456555 | 2022-04-29 | Jackson | Tennessee | 47087 | 3205 | 63 |
2453299 | 2453299 | 2022-04-28 | Jackson | Tennessee | 47087 | 3205 | 63 |
2450043 | 2450043 | 2022-04-27 | Jackson | Tennessee | 47087 | 3205 | 63 |
2446786 | 2446786 | 2022-04-26 | Jackson | Tennessee | 47087 | 3205 | 63 |
2443531 | 2443531 | 2022-04-25 | Jackson | Tennessee | 47087 | 3205 | 63 |
2440275 | 2440275 | 2022-04-24 | Jackson | Tennessee | 47087 | 3205 | 63 |
2437019 | 2437019 | 2022-04-23 | Jackson | Tennessee | 47087 | 3205 | 63 |
2433763 | 2433763 | 2022-04-22 | Jackson | Tennessee | 47087 | 3205 | 63 |
2430507 | 2430507 | 2022-04-21 | Jackson | Tennessee | 47087 | 3205 | 63 |
2427251 | 2427251 | 2022-04-20 | Jackson | Tennessee | 47087 | 3205 | 63 |
2404009 | 2404009 | 2022-04-13 | Noble | Ohio | 39121 | 3205 | 57 |
2400754 | 2400754 | 2022-04-12 | Noble | Ohio | 39121 | 3205 | 57 |
2397499 | 2397499 | 2022-04-11 | Noble | Ohio | 39121 | 3205 | 57 |
2394244 | 2394244 | 2022-04-10 | Noble | Ohio | 39121 | 3205 | 57 |
2390988 | 2390988 | 2022-04-09 | Noble | Ohio | 39121 | 3205 | 57 |
2387732 | 2387732 | 2022-04-08 | Noble | Ohio | 39121 | 3205 | 57 |
2384477 | 2384477 | 2022-04-07 | Noble | Ohio | 39121 | 3205 | 57 |
2375532 | 2375532 | 2022-04-04 | Brunswick | Virginia | 51025 | 3205 | 46 |
2371679 | 2371679 | 2022-04-03 | Barceloneta | Puerto Rico | 72017 | 3205 | |
2307955 | 2307955 | 2022-03-15 | Dade | Georgia | 13083 | 3205 | 28 |
2293363 | 2293363 | 2022-03-10 | Harrison | Ohio | 39067 | 3205 | 73 |
2283607 | 2283607 | 2022-03-07 | Harrison | Ohio | 39067 | 3205 | 72 |
2280355 | 2280355 | 2022-03-06 | Harrison | Ohio | 39067 | 3205 | 72 |
2277102 | 2277102 | 2022-03-05 | Harrison | Ohio | 39067 | 3205 | 72 |
2273849 | 2273849 | 2022-03-04 | Harrison | Ohio | 39067 | 3205 | 72 |
2257150 | 2257150 | 2022-02-27 | Roosevelt | Montana | 30085 | 3205 | 70 |
2257899 | 2257899 | 2022-02-27 | Utuado | Puerto Rico | 72141 | 3205 | |
2253899 | 2253899 | 2022-02-26 | Roosevelt | Montana | 30085 | 3205 | 70 |
2250648 | 2250648 | 2022-02-25 | Roosevelt | Montana | 30085 | 3205 | 70 |
2248796 | 2248796 | 2022-02-24 | Westmoreland | Virginia | 51193 | 3205 | 46 |
2239389 | 2239389 | 2022-02-22 | Little River | Arkansas | 5081 | 3205 | 87 |
2240656 | 2240656 | 2022-02-22 | Amite | Mississippi | 28005 | 3205 | 65 |
2238733 | 2238733 | 2022-02-21 | Jackson | Texas | 48239 | 3205 | 56 |
2239144 | 2239144 | 2022-02-21 | Ashland | Wisconsin | 55003 | 3205 | 33 |
2163071 | 2163071 | 2022-01-29 | Schuyler | New York | 36097 | 3205 | 23 |
2154629 | 2154629 | 2022-01-26 | Rusk | Wisconsin | 55107 | 3205 | 45 |
2150320 | 2150320 | 2022-01-25 | Atoka | Oklahoma | 40005 | 3205 | 41 |
2150503 | 2150503 | 2022-01-25 | Aibonito | Puerto Rico | 72009 | 3205 | |
2145579 | 2145579 | 2022-01-24 | Menard | Illinois | 17129 | 3205 | 22 |
2147068 | 2147068 | 2022-01-24 | Atoka | Oklahoma | 40005 | 3205 | 41 |
2143814 | 2143814 | 2022-01-23 | Atoka | Oklahoma | 40005 | 3205 | 41 |
2140559 | 2140559 | 2022-01-22 | Atoka | Oklahoma | 40005 | 3205 | 41 |
2137303 | 2137303 | 2022-01-21 | Atoka | Oklahoma | 40005 | 3205 | 41 |
2134049 | 2134049 | 2022-01-20 | Atoka | Oklahoma | 40005 | 3205 | 41 |
2130797 | 2130797 | 2022-01-19 | Atoka | Oklahoma | 40005 | 3205 | 41 |
2087449 | 2087449 | 2022-01-06 | Mason | Kentucky | 21161 | 3205 | 83 |
2078525 | 2078525 | 2022-01-03 | Avery | North Carolina | 37011 | 3205 | 39 |
2063749 | 2063749 | 2021-12-30 | Hempstead | Arkansas | 5057 | 3205 | 49 |
2060210 | 2060210 | 2021-12-28 | Barbour | West Virginia | 54001 | 3205 | 55 |
2050878 | 2050878 | 2021-12-26 | Elbert | Colorado | 8039 | 3205 | 30 |
2047628 | 2047628 | 2021-12-25 | Elbert | Colorado | 8039 | 3205 | 30 |
2044378 | 2044378 | 2021-12-24 | Elbert | Colorado | 8039 | 3205 | 30 |
2035187 | 2035187 | 2021-12-21 | Delaware | Iowa | 19055 | 3205 | 56 |
2031937 | 2031937 | 2021-12-20 | Delaware | Iowa | 19055 | 3205 | 56 |
2028686 | 2028686 | 2021-12-19 | Delaware | Iowa | 19055 | 3205 | 56 |
2025435 | 2025435 | 2021-12-18 | Delaware | Iowa | 19055 | 3205 | 56 |
2022184 | 2022184 | 2021-12-17 | Delaware | Iowa | 19055 | 3205 | 56 |
2018933 | 2018933 | 2021-12-16 | Delaware | Iowa | 19055 | 3205 | 56 |
2015683 | 2015683 | 2021-12-15 | Delaware | Iowa | 19055 | 3205 | 56 |
2014403 | 2014403 | 2021-12-14 | Montague | Texas | 48337 | 3205 | 98 |
2006364 | 2006364 | 2021-12-12 | Charlevoix | Michigan | 26029 | 3205 | 45 |
2003113 | 2003113 | 2021-12-11 | Charlevoix | Michigan | 26029 | 3205 | 45 |
1999863 | 1999863 | 2021-12-10 | Charlevoix | Michigan | 26029 | 3205 | 45 |
1995531 | 1995531 | 2021-12-09 | Sharp | Arkansas | 5135 | 3205 | 72 |
1989282 | 1989282 | 2021-12-07 | Crisp | Georgia | 13081 | 3205 | 116 |
1985611 | 1985611 | 2021-12-06 | Cherokee | Alabama | 1019 | 3205 | 64 |
1982361 | 1982361 | 2021-12-05 | Cherokee | Alabama | 1019 | 3205 | 64 |
1983747 | 1983747 | 2021-12-05 | Roseau | Minnesota | 27135 | 3205 | 32 |
1980497 | 1980497 | 2021-12-04 | Roseau | Minnesota | 27135 | 3205 | 32 |
1977247 | 1977247 | 2021-12-03 | Roseau | Minnesota | 27135 | 3205 | 32 |
1968228 | 1968228 | 2021-11-30 | Paulding | Ohio | 39125 | 3205 | 51 |
1953131 | 1953131 | 2021-11-26 | Henry | Alabama | 1067 | 3205 | 66 |
1949880 | 1949880 | 2021-11-25 | Henry | Alabama | 1067 | 3205 | 66 |
1946629 | 1946629 | 2021-11-24 | Henry | Alabama | 1067 | 3205 | 66 |
1922829 | 1922829 | 2021-11-16 | Crook | Oregon | 41013 | 3205 | 54 |
1923088 | 1923088 | 2021-11-16 | Hughes | South Dakota | 46065 | 3205 | 48 |
1919958 | 1919958 | 2021-11-15 | Trousdale | Tennessee | 47169 | 3205 | 26 |
1858665 | 1858665 | 2021-10-27 | Adams | Washington | 53001 | 3205 | 31 |
1855416 | 1855416 | 2021-10-26 | Adams | Washington | 53001 | 3205 | 31 |
1833366 | 1833366 | 2021-10-20 | Putnam | Georgia | 13237 | 3205 | 80 |
1830117 | 1830117 | 2021-10-19 | Putnam | Georgia | 13237 | 3205 | 80 |
1789808 | 1789808 | 2021-10-06 | Fairfield | South Carolina | 45039 | 3205 | 93 |
1761427 | 1761427 | 2021-09-28 | Monroe | Alabama | 1099 | 3205 | 55 |
1759363 | 1759363 | 2021-09-27 | Franklin | Massachusetts | 25011 | 3205 | 118 |
1715410 | 1715410 | 2021-09-13 | Lampasas | Texas | 48281 | 3205 | 50 |
1705699 | 1705699 | 2021-09-10 | Moore | Texas | 48341 | 3205 | 78 |
1679937 | 1679937 | 2021-09-02 | Pulaski | Virginia | 51155 | 3205 | 72 |
1670841 | 1670841 | 2021-08-31 | Cook | Georgia | 13075 | 3205 | 47 |
1652148 | 1652148 | 2021-08-25 | Queen Anne's | Maryland | 24035 | 3205 | 57 |
1584271 | 1584271 | 2021-08-04 | Miller | Missouri | 29131 | 3205 | 63 |
1573393 | 1573393 | 2021-08-01 | Dawson | Georgia | 13085 | 3205 | 49 |
1570145 | 1570145 | 2021-07-31 | Dawson | Georgia | 13085 | 3205 | 49 |
1566897 | 1566897 | 2021-07-30 | Dawson | Georgia | 13085 | 3205 | 49 |
1558497 | 1558497 | 2021-07-27 | Nye | Nevada | 32023 | 3205 | 109 |
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);