ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 5846 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Indiana 10
- Texas 10
- Ohio 6
- South Dakota 4
- Georgia 3
- Minnesota 3
- Mississippi 3
- Oklahoma 3
- West Virginia 3
- Arkansas 2
- Illinois 2
- Missouri 2
- North Dakota 2
- Tennessee 2
- Virginia 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- New York 1
- North Carolina 1
- Pennsylvania 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499364 | 2499364 | 2022-05-12 | Scott | Virginia | 51169 | 5846 | 111 |
2444956 | 2444956 | 2022-04-26 | LaGrange | Indiana | 18087 | 5846 | 102 |
2441700 | 2441700 | 2022-04-25 | LaGrange | Indiana | 18087 | 5846 | 102 |
2440815 | 2440815 | 2022-04-24 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2437559 | 2437559 | 2022-04-23 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2434303 | 2434303 | 2022-04-22 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2431119 | 2431119 | 2022-04-21 | Kewaunee | Wisconsin | 55061 | 5846 | 59 |
2422180 | 2422180 | 2022-04-19 | Owen | Indiana | 18119 | 5846 | 121 |
2418924 | 2418924 | 2022-04-18 | Owen | Indiana | 18119 | 5846 | 121 |
2311525 | 2311525 | 2022-03-16 | LaGrange | Indiana | 18087 | 5846 | 102 |
2308272 | 2308272 | 2022-03-15 | LaGrange | Indiana | 18087 | 5846 | 102 |
2305021 | 2305021 | 2022-03-14 | LaGrange | Indiana | 18087 | 5846 | 102 |
2305416 | 2305416 | 2022-03-14 | Grant | Louisiana | 22043 | 5846 | 90 |
2296898 | 2296898 | 2022-03-11 | Manati | Puerto Rico | 72091 | 5846 | |
2290495 | 2290495 | 2022-03-09 | Davison | South Dakota | 46035 | 5846 | 78 |
2287243 | 2287243 | 2022-03-08 | Davison | South Dakota | 46035 | 5846 | 78 |
2270980 | 2270980 | 2022-03-03 | Davison | South Dakota | 46035 | 5846 | 78 |
2260789 | 2260789 | 2022-02-28 | Rolette | North Dakota | 38079 | 5846 | 41 |
2206869 | 2206869 | 2022-02-12 | Jackson | Arkansas | 5067 | 5846 | 53 |
2171443 | 2171443 | 2022-02-01 | Peach | Georgia | 13225 | 5846 | 118 |
2148139 | 2148139 | 2022-01-24 | Waushara | Wisconsin | 55137 | 5846 | 76 |
2125085 | 2125085 | 2022-01-17 | Caroline | Virginia | 51033 | 5846 | 59 |
2100418 | 2100418 | 2022-01-10 | Grant | Kentucky | 21081 | 5846 | 46 |
2022912 | 2022912 | 2021-12-17 | Laclede | Missouri | 29105 | 5846 | 151 |
2017482 | 2017482 | 2021-12-15 | White | Tennessee | 47185 | 5846 | 103 |
2011616 | 2011616 | 2021-12-14 | Chambers | Alabama | 1017 | 5846 | 143 |
1963393 | 1963393 | 2021-11-29 | Wayne | Georgia | 13305 | 5846 | 173 |
1965591 | 1965591 | 2021-11-29 | Howard | Texas | 48227 | 5846 | 143 |
1965716 | 1965716 | 2021-11-29 | Washington | Texas | 48477 | 5846 | 132 |
1926320 | 1926320 | 2021-11-17 | Codington | South Dakota | 46029 | 5846 | 85 |
1923178 | 1923178 | 2021-11-16 | Marion | Tennessee | 47115 | 5846 | 56 |
1886976 | 1886976 | 2021-11-05 | Preble | Ohio | 39135 | 5846 | 132 |
1858967 | 1858967 | 2021-10-28 | Baxter | Arkansas | 5005 | 5846 | 179 |
1766696 | 1766696 | 2021-09-29 | Brown | Ohio | 39015 | 5846 | 72 |
1740696 | 1740696 | 2021-09-21 | Williams | North Dakota | 38105 | 5846 | 43 |
1736968 | 1736968 | 2021-09-20 | Phelps | Missouri | 29161 | 5846 | 171 |
1725250 | 1725250 | 2021-09-16 | Waller | Texas | 48473 | 5846 | 62 |
1717760 | 1717760 | 2021-09-14 | Herkimer | New York | 36043 | 5846 | 115 |
1619934 | 1619934 | 2021-08-15 | Washington | Mississippi | 28151 | 5846 | 141 |
1616686 | 1616686 | 2021-08-14 | Washington | Mississippi | 28151 | 5846 | 141 |
1613438 | 1613438 | 2021-08-13 | Washington | Mississippi | 28151 | 5846 | 141 |
1575184 | 1575184 | 2021-08-01 | Unknown | Oklahoma | 5846 | 0 | |
1571936 | 1571936 | 2021-07-31 | Unknown | Oklahoma | 5846 | 0 | |
1568688 | 1568688 | 2021-07-30 | Unknown | Oklahoma | 5846 | 0 | |
1532074 | 1532074 | 2021-07-19 | Benton | Minnesota | 27009 | 5846 | 98 |
1500905 | 1500905 | 2021-07-09 | Atascosa | Texas | 48013 | 5846 | 151 |
1441990 | 1441990 | 2021-06-21 | Union | Ohio | 39159 | 5846 | 49 |
1438745 | 1438745 | 2021-06-20 | Union | Ohio | 39159 | 5846 | 49 |
1432251 | 1432251 | 2021-06-18 | Union | Ohio | 39159 | 5846 | 49 |
1392546 | 1392546 | 2021-06-06 | Otter Tail | Minnesota | 27111 | 5846 | 82 |
1389301 | 1389301 | 2021-06-05 | Otter Tail | Minnesota | 27111 | 5846 | 82 |
1348487 | 1348487 | 2021-05-23 | Lamar | Texas | 48277 | 5846 | 156 |
1345239 | 1345239 | 2021-05-22 | Lamar | Texas | 48277 | 5846 | 156 |
1341991 | 1341991 | 2021-05-21 | Lamar | Texas | 48277 | 5846 | 156 |
1338743 | 1338743 | 2021-05-20 | Lamar | Texas | 48277 | 5846 | 156 |
1333453 | 1333453 | 2021-05-19 | Dearborn | Indiana | 18029 | 5846 | 81 |
1329127 | 1329127 | 2021-05-17 | Iron | Utah | 49021 | 5846 | 32 |
1297653 | 1297653 | 2021-05-08 | Grundy | Illinois | 17063 | 5846 | 78 |
1288474 | 1288474 | 2021-05-05 | Kennebec | Maine | 23011 | 5846 | 69 |
1278318 | 1278318 | 2021-05-02 | Shelby | Indiana | 18145 | 5846 | 106 |
1138419 | 1138419 | 2021-03-20 | Spalding | Georgia | 13255 | 5846 | 174 |
1052392 | 1052392 | 2021-02-21 | Scioto | Ohio | 39145 | 5846 | 103 |
974642 | 974642 | 2021-01-28 | Crawford | Pennsylvania | 42039 | 5846 | 127 |
951635 | 951635 | 2021-01-21 | Surry | North Carolina | 37171 | 5846 | 101 |
911911 | 911911 | 2021-01-09 | Carroll | Maryland | 24013 | 5846 | 177 |
868124 | 868124 | 2020-12-26 | Walker | Texas | 48471 | 5846 | 82 |
832284 | 832284 | 2020-12-15 | Guadalupe | Texas | 48187 | 5846 | 92 |
709596 | 709596 | 2020-11-08 | Coconino | Arizona | 4005 | 5846 | 151 |
538433 | 538433 | 2020-09-16 | St. Joseph | Indiana | 18141 | 5846 | 102 |
176069 | 176069 | 2020-05-25 | Kane | Illinois | 17089 | 5846 | 152 |
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);