ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 6254 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Michigan 6
- Virginia 5
- Louisiana 4
- Mississippi 4
- Nevada 4
- North Carolina 4
- Ohio 4
- Tennessee 4
- Arkansas 3
- Kentucky 3
- Missouri 3
- Wisconsin 3
- Alabama 2
- Florida 2
- Georgia 2
- Nebraska 2
- New York 2
- California 1
- Indiana 1
- Maryland 1
- Massachusetts 1
- New Mexico 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2455873 | 2455873 | 2022-04-29 | Seneca | New York | 36099 | 6254 | 91 |
2302613 | 2302613 | 2022-03-13 | Saline | Missouri | 29195 | 6254 | 100 |
2299361 | 2299361 | 2022-03-12 | Saline | Missouri | 29195 | 6254 | 100 |
2296109 | 2296109 | 2022-03-11 | Saline | Missouri | 29195 | 6254 | 100 |
2294324 | 2294324 | 2022-03-10 | Winchester city | Virginia | 51840 | 6254 | 76 |
2279564 | 2279564 | 2022-03-06 | Oceana | Michigan | 26127 | 6254 | 89 |
2276311 | 2276311 | 2022-03-05 | Oceana | Michigan | 26127 | 6254 | 89 |
2273058 | 2273058 | 2022-03-04 | Oceana | Michigan | 26127 | 6254 | 89 |
2211142 | 2211142 | 2022-02-13 | Sabine | Louisiana | 22085 | 6254 | 108 |
2211744 | 2211744 | 2022-02-13 | Churchill | Nevada | 32001 | 6254 | 98 |
2207889 | 2207889 | 2022-02-12 | Sabine | Louisiana | 22085 | 6254 | 108 |
2208491 | 2208491 | 2022-02-12 | Churchill | Nevada | 32001 | 6254 | 98 |
2204636 | 2204636 | 2022-02-11 | Sabine | Louisiana | 22085 | 6254 | 108 |
2205238 | 2205238 | 2022-02-11 | Churchill | Nevada | 32001 | 6254 | 98 |
2197162 | 2197162 | 2022-02-09 | Glenn | California | 6021 | 6254 | 58 |
2195621 | 2195621 | 2022-02-08 | Anson | North Carolina | 37007 | 6254 | 88 |
2196752 | 2196752 | 2022-02-08 | Russell | Virginia | 51167 | 6254 | 91 |
2168097 | 2168097 | 2022-01-31 | Butts | Georgia | 13035 | 6254 | 136 |
2152444 | 2152444 | 2022-01-26 | Clay | Kentucky | 21051 | 6254 | 70 |
2134874 | 2134874 | 2022-01-20 | Gloucester | Virginia | 51073 | 6254 | 84 |
2095607 | 2095607 | 2022-01-08 | Hill | Texas | 48217 | 6254 | 178 |
2068765 | 2068765 | 2021-12-31 | Wyoming | New York | 36121 | 6254 | 74 |
1900915 | 1900915 | 2021-11-09 | Douglas | Washington | 53017 | 6254 | 39 |
1878058 | 1878058 | 2021-11-02 | Danville city | Virginia | 51590 | 6254 | 193 |
1826307 | 1826307 | 2021-10-17 | Monroe | Wisconsin | 55081 | 6254 | 54 |
1784280 | 1784280 | 2021-10-05 | Miller | Arkansas | 5091 | 6254 | 47 |
1732148 | 1732148 | 2021-09-19 | Chilton | Alabama | 1021 | 6254 | 133 |
1734273 | 1734273 | 2021-09-19 | Seneca | Ohio | 39147 | 6254 | 137 |
1720909 | 1720909 | 2021-09-15 | Elko | Nevada | 32007 | 6254 | 74 |
1672966 | 1672966 | 2021-08-31 | Fayette | Tennessee | 47047 | 6254 | 87 |
1655281 | 1655281 | 2021-08-26 | Scott | Kentucky | 21209 | 6254 | 37 |
1650702 | 1650702 | 2021-08-24 | Pittsylvania | Virginia | 51143 | 6254 | 87 |
1604145 | 1604145 | 2021-08-10 | Granville | North Carolina | 37077 | 6254 | 84 |
1592595 | 1592595 | 2021-08-07 | Hot Spring | Arkansas | 5059 | 6254 | 87 |
1539195 | 1539195 | 2021-07-21 | Lee | North Carolina | 37105 | 6254 | 83 |
1469811 | 1469811 | 2021-06-30 | Marshall | Indiana | 18099 | 6254 | 118 |
1472264 | 1472264 | 2021-06-30 | Sauk | Wisconsin | 55111 | 6254 | 57 |
1462706 | 1462706 | 2021-06-28 | Greene | Arkansas | 5055 | 6254 | 78 |
1460642 | 1460642 | 2021-06-27 | St. Joseph | Michigan | 26149 | 6254 | 100 |
1457397 | 1457397 | 2021-06-26 | St. Joseph | Michigan | 26149 | 6254 | 100 |
1454152 | 1454152 | 2021-06-25 | St. Joseph | Michigan | 26149 | 6254 | 100 |
1369897 | 1369897 | 2021-05-30 | Lafayette | Mississippi | 28071 | 6254 | 119 |
1366651 | 1366651 | 2021-05-29 | Lafayette | Mississippi | 28071 | 6254 | 119 |
1363405 | 1363405 | 2021-05-28 | Lafayette | Mississippi | 28071 | 6254 | 119 |
1337190 | 1337190 | 2021-05-20 | Cecil | Maryland | 24015 | 6254 | 138 |
1333087 | 1333087 | 2021-05-19 | Jackson | Florida | 12063 | 6254 | 157 |
1238992 | 1238992 | 2021-04-20 | Catoosa | Georgia | 13047 | 6254 | 68 |
1188675 | 1188675 | 2021-04-04 | Ashtabula | Ohio | 39007 | 6254 | 158 |
1185428 | 1185428 | 2021-04-03 | Ashtabula | Ohio | 39007 | 6254 | 158 |
1152891 | 1152891 | 2021-03-24 | Wilkes | North Carolina | 37193 | 6254 | 104 |
1150197 | 1150197 | 2021-03-23 | Gibson | Tennessee | 47053 | 6254 | 141 |
1096723 | 1096723 | 2021-03-07 | Christian | Kentucky | 21047 | 6254 | 79 |
1059293 | 1059293 | 2021-02-23 | Coffee | Tennessee | 47031 | 6254 | 114 |
1042342 | 1042342 | 2021-02-18 | Eddy | New Mexico | 35015 | 6254 | 111 |
1012457 | 1012457 | 2021-02-09 | Iberia | Louisiana | 22045 | 6254 | 141 |
988627 | 988627 | 2021-02-02 | Jackson | Alabama | 1071 | 6254 | 73 |
973813 | 973813 | 2021-01-28 | Lauderdale | Mississippi | 28075 | 6254 | 199 |
910679 | 910679 | 2021-01-08 | Wood | Wisconsin | 55141 | 6254 | 64 |
757028 | 757028 | 2020-11-22 | Lake | Ohio | 39085 | 6254 | 66 |
437843 | 437843 | 2020-08-16 | St. Lucie | Florida | 12111 | 6254 | 197 |
404597 | 404597 | 2020-08-05 | Rutherford | Tennessee | 47149 | 6254 | 53 |
257338 | 257338 | 2020-06-20 | Douglas | Nebraska | 31055 | 6254 | 77 |
254215 | 254215 | 2020-06-19 | Douglas | Nebraska | 31055 | 6254 | 77 |
57559 | 57559 | 2020-04-14 | Middlesex | Massachusetts | 25017 | 6254 | 188 |
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);