ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 6143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Illinois 6
- North Carolina 4
- Utah 4
- Mississippi 3
- Pennsylvania 3
- Alabama 2
- Arkansas 2
- California 2
- Florida 2
- Ohio 2
- Puerto Rico 2
- Texas 2
- Georgia 1
- Kentucky 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- Montana 1
- South Carolina 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2246427 | 2246427 | 2022-02-24 | Shelby | Illinois | 17173 | 6143 | 73 |
2236630 | 2236630 | 2022-02-21 | Jersey | Illinois | 17083 | 6143 | 85 |
2233379 | 2233379 | 2022-02-20 | Jersey | Illinois | 17083 | 6143 | 85 |
2230128 | 2230128 | 2022-02-19 | Jersey | Illinois | 17083 | 6143 | 85 |
2226877 | 2226877 | 2022-02-18 | Jersey | Illinois | 17083 | 6143 | 85 |
2166784 | 2166784 | 2022-01-30 | Canovanas | Puerto Rico | 72029 | 6143 | |
2133379 | 2133379 | 2022-01-20 | Tate | Mississippi | 28137 | 6143 | 125 |
2125873 | 2125873 | 2022-01-18 | Madison | Georgia | 13195 | 6143 | 85 |
2089482 | 2089482 | 2022-01-06 | Greenbrier | West Virginia | 54025 | 6143 | 122 |
2036465 | 2036465 | 2021-12-21 | Jackson | Ohio | 39079 | 6143 | 106 |
2033068 | 2033068 | 2021-12-20 | Jackson | North Carolina | 37099 | 6143 | 74 |
1966216 | 1966216 | 2021-11-30 | Baxter | Arkansas | 5005 | 6143 | 188 |
1796566 | 1796566 | 2021-10-08 | Erath | Texas | 48143 | 6143 | 95 |
1769388 | 1769388 | 2021-09-30 | Camden | Missouri | 29029 | 6143 | 120 |
1762799 | 1762799 | 2021-09-28 | Bolivar | Mississippi | 28011 | 6143 | 145 |
1747135 | 1747135 | 2021-09-23 | Watauga | North Carolina | 37189 | 6143 | 34 |
1692809 | 1692809 | 2021-09-06 | Summit | Utah | 49043 | 6143 | 16 |
1689560 | 1689560 | 2021-09-05 | Summit | Utah | 49043 | 6143 | 16 |
1686310 | 1686310 | 2021-09-04 | Summit | Utah | 49043 | 6143 | 16 |
1683059 | 1683059 | 2021-09-03 | Summit | Utah | 49043 | 6143 | 16 |
1669618 | 1669618 | 2021-08-30 | Newberry | South Carolina | 45071 | 6143 | 117 |
1649170 | 1649170 | 2021-08-24 | Washington | Mississippi | 28151 | 6143 | 142 |
1623958 | 1623958 | 2021-08-16 | Armstrong | Pennsylvania | 42005 | 6143 | 148 |
1584651 | 1584651 | 2021-08-04 | Granville | North Carolina | 37077 | 6143 | 83 |
1540460 | 1540460 | 2021-07-21 | Waupaca | Wisconsin | 55135 | 6143 | 167 |
1448297 | 1448297 | 2021-06-23 | Lee | North Carolina | 37105 | 6143 | 83 |
1409714 | 1409714 | 2021-06-11 | Union | Pennsylvania | 42119 | 6143 | 89 |
1402967 | 1402967 | 2021-06-09 | Belmont | Ohio | 39013 | 6143 | 174 |
1362084 | 1362084 | 2021-05-28 | Crittenden | Arkansas | 5035 | 6143 | 97 |
1346395 | 1346395 | 2021-05-23 | Ogle | Illinois | 17141 | 6143 | 91 |
1294984 | 1294984 | 2021-05-07 | Cecil | Maryland | 24015 | 6143 | 132 |
1292804 | 1292804 | 2021-05-06 | Carbon | Pennsylvania | 42025 | 6143 | 169 |
1255167 | 1255167 | 2021-04-25 | Jackson | Florida | 12063 | 6143 | 156 |
1251920 | 1251920 | 2021-04-24 | Jackson | Florida | 12063 | 6143 | 156 |
1168208 | 1168208 | 2021-03-29 | McCracken | Kentucky | 21145 | 6143 | 114 |
1150907 | 1150907 | 2021-03-24 | Colbert | Alabama | 1033 | 6143 | 125 |
1056752 | 1056752 | 2021-02-23 | Autauga | Alabama | 1001 | 6143 | 84 |
1019441 | 1019441 | 2021-02-11 | Lewis and Clark | Montana | 30049 | 6143 | 63 |
908685 | 908685 | 2021-01-08 | Barnstable | Massachusetts | 25001 | 6143 | 271 |
879587 | 879587 | 2020-12-30 | Clay | Minnesota | 27027 | 6143 | 78 |
829798 | 829798 | 2020-12-15 | Santa Cruz | California | 6087 | 6143 | 60 |
760510 | 760510 | 2020-11-23 | Bayamon | Puerto Rico | 72021 | 6143 | |
524112 | 524112 | 2020-09-11 | Brazos | Texas | 48041 | 6143 | 60 |
482879 | 482879 | 2020-08-30 | Marin | California | 6041 | 6143 | 95 |
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);