ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where cases = 5998 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Texas 9
- Mississippi 4
- Missouri 4
- Ohio 4
- Tennessee 4
- Indiana 3
- Kentucky 3
- Pennsylvania 3
- California 2
- Georgia 2
- Idaho 2
- New York 2
- North Carolina 2
- Puerto Rico 2
- Washington 2
- Alabama 1
- Florida 1
- Louisiana 1
- Michigan 1
- Minnesota 1
- New Jersey 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500951 | 2500951 | 2022-05-13 | Meeker | Minnesota | 27093 | 5998 | 75 |
2309112 | 2309112 | 2022-03-15 | Randolph | Missouri | 29175 | 5998 | 101 |
2283083 | 2283083 | 2022-03-07 | Nodaway | Missouri | 29147 | 5998 | 43 |
2267604 | 2267604 | 2022-03-02 | Corozal | Puerto Rico | 72047 | 5998 | |
2231885 | 2231885 | 2022-02-19 | San Sebastian | Puerto Rico | 72131 | 5998 | |
2223445 | 2223445 | 2022-02-17 | Harris | Georgia | 13145 | 5998 | 103 |
2222448 | 2222448 | 2022-02-16 | Gray | Texas | 48179 | 5998 | 116 |
2104954 | 2104954 | 2022-01-11 | Warren | Pennsylvania | 42123 | 5998 | 185 |
2019581 | 2019581 | 2021-12-16 | Pike | Mississippi | 28113 | 5998 | 157 |
2007209 | 2007209 | 2021-12-12 | Jackson | Ohio | 39079 | 5998 | 101 |
1993520 | 1993520 | 2021-12-08 | Alcorn | Mississippi | 28003 | 5998 | 108 |
1920442 | 1920442 | 2021-11-15 | Whitman | Washington | 53075 | 5998 | 81 |
1895367 | 1895367 | 2021-11-08 | Putnam | Indiana | 18133 | 5998 | 84 |
1873432 | 1873432 | 2021-11-01 | Platte | Missouri | 29165 | 5998 | 61 |
1798983 | 1798983 | 2021-10-09 | Fulton | New York | 36035 | 5998 | 100 |
1753928 | 1753928 | 2021-09-25 | Huntingdon | Pennsylvania | 42061 | 5998 | 144 |
1730400 | 1730400 | 2021-09-18 | Camden | Missouri | 29029 | 5998 | 115 |
1717361 | 1717361 | 2021-09-14 | Panola | Mississippi | 28107 | 5998 | 122 |
1698990 | 1698990 | 2021-09-08 | Marshall | Tennessee | 47117 | 5998 | 70 |
1673285 | 1673285 | 2021-08-31 | Wilson | Texas | 48493 | 5998 | 85 |
1628725 | 1628725 | 2021-08-18 | Ware | Georgia | 13299 | 5998 | 191 |
1609880 | 1609880 | 2021-08-12 | Washington | Louisiana | 22117 | 5998 | 147 |
1601094 | 1601094 | 2021-08-09 | Union | Ohio | 39159 | 5998 | 49 |
1528595 | 1528595 | 2021-07-18 | Pike | Kentucky | 21195 | 5998 | 110 |
1530260 | 1530260 | 2021-07-18 | Lamar | Texas | 48277 | 5998 | 158 |
1525348 | 1525348 | 2021-07-17 | Pike | Kentucky | 21195 | 5998 | 110 |
1527013 | 1527013 | 2021-07-17 | Lamar | Texas | 48277 | 5998 | 158 |
1522100 | 1522100 | 2021-07-16 | Pike | Kentucky | 21195 | 5998 | 110 |
1523766 | 1523766 | 2021-07-16 | Lamar | Texas | 48277 | 5998 | 158 |
1429952 | 1429952 | 2021-06-17 | Skagit | Washington | 53057 | 5998 | 74 |
1406876 | 1406876 | 2021-06-10 | Henderson | Texas | 48213 | 5998 | 194 |
1403630 | 1403630 | 2021-06-09 | Henderson | Texas | 48213 | 5998 | 194 |
1400385 | 1400385 | 2021-06-08 | Henderson | Texas | 48213 | 5998 | 194 |
1306253 | 1306253 | 2021-05-10 | Hunt | Texas | 48231 | 5998 | 168 |
1287257 | 1287257 | 2021-05-04 | Waupaca | Wisconsin | 55135 | 5998 | 162 |
1248541 | 1248541 | 2021-04-23 | San Benito | California | 6069 | 5998 | 63 |
1245294 | 1245294 | 2021-04-22 | San Benito | California | 6069 | 5998 | 63 |
1195043 | 1195043 | 2021-04-06 | Duplin | North Carolina | 37061 | 5998 | 128 |
1175562 | 1175562 | 2021-03-31 | Franklin | North Carolina | 37069 | 5998 | 47 |
1141871 | 1141871 | 2021-03-21 | Dubois | Indiana | 18037 | 5998 | 114 |
1124269 | 1124269 | 2021-03-15 | Roane | Tennessee | 47145 | 5998 | 96 |
1094515 | 1094515 | 2021-03-06 | Ashtabula | Ohio | 39007 | 5998 | 154 |
1094988 | 1094988 | 2021-03-06 | Carter | Tennessee | 47019 | 5998 | 155 |
1091269 | 1091269 | 2021-03-05 | Ashtabula | Ohio | 39007 | 5998 | 154 |
1082732 | 1082732 | 2021-03-03 | Colbert | Alabama | 1033 | 5998 | 120 |
1068785 | 1068785 | 2021-02-26 | Lawrence | Pennsylvania | 42073 | 5998 | 182 |
1061456 | 1061456 | 2021-02-24 | Lowndes | Mississippi | 28087 | 5998 | 137 |
1015823 | 1015823 | 2021-02-10 | Eaton | Michigan | 26045 | 5998 | 144 |
1005410 | 1005410 | 2021-02-07 | Madison | Idaho | 16065 | 5998 | 21 |
1002164 | 1002164 | 2021-02-06 | Madison | Idaho | 16065 | 5998 | 21 |
993638 | 993638 | 2021-02-03 | Hunterdon | New Jersey | 34019 | 5998 | 147 |
977458 | 977458 | 2021-01-29 | Chemung | New York | 36015 | 5998 | 115 |
914736 | 914736 | 2021-01-10 | Warrick | Indiana | 18173 | 5998 | 92 |
900247 | 900247 | 2021-01-05 | Anderson | Tennessee | 47001 | 5998 | 75 |
139520 | 139520 | 2020-05-13 | Broward | Florida | 12011 | 5998 | 267 |
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);