ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 14909 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Mississippi 7
- Missouri 3
- Texas 3
- Georgia 2
- North Carolina 2
- Florida 1
- Louisiana 1
- Minnesota 1
- Pennsylvania 1
- Puerto Rico 1
- Utah 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2219411 | 2219411 | 2022-02-15 | Albemarle | Virginia | 51003 | 14909 | 131 |
2123589 | 2123589 | 2022-01-17 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2120337 | 2120337 | 2022-01-16 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2117085 | 2117085 | 2022-01-15 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2113834 | 2113834 | 2022-01-14 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2016789 | 2016789 | 2021-12-15 | Craven | North Carolina | 37049 | 14909 | 162 |
1788880 | 1788880 | 2021-10-06 | Buchanan | Missouri | 29021 | 14909 | 217 |
1785632 | 1785632 | 2021-10-05 | Buchanan | Missouri | 29021 | 14909 | 217 |
1782383 | 1782383 | 2021-10-04 | Buchanan | Missouri | 29021 | 14909 | 217 |
1756337 | 1756337 | 2021-09-26 | Lee | Mississippi | 28081 | 14909 | 220 |
1753089 | 1753089 | 2021-09-25 | Lee | Mississippi | 28081 | 14909 | 220 |
1749841 | 1749841 | 2021-09-24 | Lee | Mississippi | 28081 | 14909 | 220 |
1556686 | 1556686 | 2021-07-26 | Sheboygan | Wisconsin | 55117 | 14909 | 169 |
1529805 | 1529805 | 2021-07-18 | Monroe | Pennsylvania | 42089 | 14909 | 322 |
1248758 | 1248758 | 2021-04-23 | Douglas | Georgia | 13097 | 14909 | 210 |
1239992 | 1239992 | 2021-04-20 | Wright | Minnesota | 27171 | 14909 | 127 |
1241445 | 1241445 | 2021-04-20 | Wichita | Texas | 48485 | 14909 | 374 |
1238198 | 1238198 | 2021-04-19 | Wichita | Texas | 48485 | 14909 | 374 |
1073379 | 1073379 | 2021-02-28 | Bibb | Georgia | 13021 | 14909 | 379 |
971093 | 971093 | 2021-01-27 | Pitt | North Carolina | 37147 | 14909 | 70 |
867660 | 867660 | 2020-12-26 | San Juan | Puerto Rico | 72127 | 14909 | |
812996 | 812996 | 2020-12-09 | Weber | Utah | 49057 | 14909 | 67 |
696857 | 696857 | 2020-11-04 | Collier | Florida | 12021 | 14909 | 256 |
650728 | 650728 | 2020-10-20 | Webb | Texas | 48479 | 14909 | 345 |
554982 | 554982 | 2020-09-21 | East Baton Rouge | Louisiana | 22033 | 14909 | 437 |
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);