ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 8389 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- South Dakota 5
- Minnesota 3
- North Carolina 3
- Louisiana 2
- Missouri 2
- New York 2
- Ohio 2
- Pennsylvania 2
- Texas 2
- West Virginia 2
- Alabama 1
- Georgia 1
- Indiana 1
- Maine 1
- Mississippi 1
- New Jersey 1
- Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471398 | 2471398 | 2022-05-04 | Evangeline | Louisiana | 22039 | 8389 | 159 |
2468142 | 2468142 | 2022-05-03 | Evangeline | Louisiana | 22039 | 8389 | 159 |
2332776 | 2332776 | 2022-03-22 | Codington | South Dakota | 46029 | 8389 | 99 |
2329523 | 2329523 | 2022-03-21 | Codington | South Dakota | 46029 | 8389 | 99 |
2326271 | 2326271 | 2022-03-20 | Codington | South Dakota | 46029 | 8389 | 99 |
2323018 | 2323018 | 2022-03-19 | Codington | South Dakota | 46029 | 8389 | 99 |
2319764 | 2319764 | 2022-03-18 | Codington | South Dakota | 46029 | 8389 | 99 |
2225115 | 2225115 | 2022-02-17 | Putnam | Ohio | 39137 | 8389 | 147 |
2172293 | 2172293 | 2022-02-01 | Freeborn | Minnesota | 27047 | 8389 | 63 |
2168187 | 2168187 | 2022-01-31 | Oconee | Georgia | 13219 | 8389 | 92 |
2113961 | 2113961 | 2022-01-14 | Phelps | Missouri | 29161 | 8389 | 208 |
2055220 | 2055220 | 2021-12-27 | Itasca | Minnesota | 27061 | 8389 | 113 |
2021322 | 2021322 | 2021-12-16 | Shawano | Wisconsin | 55115 | 8389 | 102 |
1819740 | 1819740 | 2021-10-15 | Mercer | West Virginia | 54055 | 8389 | 174 |
1805581 | 1805581 | 2021-10-11 | McDowell | North Carolina | 37111 | 8389 | 114 |
1739347 | 1739347 | 2021-09-21 | Boone | Indiana | 18011 | 8389 | 116 |
1732004 | 1732004 | 2021-09-18 | Harrison | West Virginia | 54033 | 8389 | 101 |
1700988 | 1700988 | 2021-09-09 | Blue Earth | Minnesota | 27013 | 8389 | 47 |
1666220 | 1666220 | 2021-08-29 | Lawrence | Pennsylvania | 42073 | 8389 | 229 |
1429897 | 1429897 | 2021-06-17 | Roanoke | Virginia | 51161 | 8389 | 147 |
1330934 | 1330934 | 2021-05-18 | Jones | Mississippi | 28067 | 8389 | 164 |
1309040 | 1309040 | 2021-05-11 | Clearfield | Pennsylvania | 42033 | 8389 | 143 |
1240718 | 1240718 | 2021-04-20 | Tuscarawas | Ohio | 39157 | 8389 | 240 |
1124904 | 1124904 | 2021-03-15 | Laramie | Wyoming | 56021 | 8389 | 110 |
1081353 | 1081353 | 2021-03-02 | Putnam | New York | 36079 | 8389 | 86 |
1074980 | 1074980 | 2021-02-28 | Wilson | North Carolina | 37195 | 8389 | 147 |
1071734 | 1071734 | 2021-02-27 | Wilson | North Carolina | 37195 | 8389 | 147 |
990114 | 990114 | 2021-02-02 | Cole | Missouri | 29051 | 8389 | 107 |
980054 | 980054 | 2021-01-30 | York | Maine | 23031 | 8389 | 100 |
849090 | 849090 | 2020-12-21 | Marshall | Alabama | 1095 | 8389 | 71 |
761018 | 761018 | 2020-11-23 | Tom Green | Texas | 48451 | 8389 | 101 |
738280 | 738280 | 2020-11-16 | Smith | Texas | 48423 | 8389 | 189 |
390928 | 390928 | 2020-08-01 | Camden | New Jersey | 34007 | 8389 | 573 |
97004 | 97004 | 2020-04-28 | Orange | New York | 36071 | 8389 | 223 |
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);