ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 7738 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419375 | 2419375 | 2022-04-18 | Dorchester | Maryland | 24019 | 7738 | 108 |
2378422 | 2378422 | 2022-04-05 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2375168 | 2375168 | 2022-04-04 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2371916 | 2371916 | 2022-04-03 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2368663 | 2368663 | 2022-04-02 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2365410 | 2365410 | 2022-04-01 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2362157 | 2362157 | 2022-03-31 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2358903 | 2358903 | 2022-03-30 | Lauderdale | Tennessee | 47097 | 7738 | 103 |
2353604 | 2353604 | 2022-03-29 | Upson | Georgia | 13293 | 7738 | 230 |
2350352 | 2350352 | 2022-03-28 | Upson | Georgia | 13293 | 7738 | 230 |
2304815 | 2304815 | 2022-03-14 | Wayne | Georgia | 13305 | 7738 | 202 |
2220507 | 2220507 | 2022-02-16 | Scott | Indiana | 18143 | 7738 | 99 |
2199722 | 2199722 | 2022-02-09 | Kendall | Texas | 48259 | 7738 | 110 |
2194834 | 2194834 | 2022-02-08 | Allen | Louisiana | 22003 | 7738 | 124 |
2167518 | 2167518 | 2022-01-30 | Kittitas | Washington | 53037 | 7738 | 58 |
2164263 | 2164263 | 2022-01-29 | Kittitas | Washington | 53037 | 7738 | 58 |
2161008 | 2161008 | 2022-01-28 | Kittitas | Washington | 53037 | 7738 | 58 |
2035736 | 2035736 | 2021-12-21 | McLeod | Minnesota | 27085 | 7738 | 88 |
1906210 | 1906210 | 2021-11-11 | Genesee | New York | 36037 | 7738 | 138 |
1808812 | 1808812 | 2021-10-12 | Granville | North Carolina | 37077 | 7738 | 99 |
1784729 | 1784729 | 2021-10-05 | Boone | Illinois | 17007 | 7738 | 95 |
1643316 | 1643316 | 2021-08-22 | Scioto | Ohio | 39145 | 7738 | 109 |
1356000 | 1356000 | 2021-05-26 | Walker | Georgia | 13295 | 7738 | 87 |
1329999 | 1329999 | 2021-05-18 | Rockdale | Georgia | 13247 | 7738 | 171 |
1263390 | 1263390 | 2021-04-27 | Erie | Ohio | 39043 | 7738 | 154 |
1220434 | 1220434 | 2021-04-14 | Clay | Minnesota | 27027 | 7738 | 89 |
1166913 | 1166913 | 2021-03-28 | Roanoke | Virginia | 51161 | 7738 | 125 |
1125250 | 1125250 | 2021-03-16 | Columbia | Florida | 12023 | 7738 | 160 |
1076392 | 1076392 | 2021-03-01 | Pope | Arkansas | 5115 | 7738 | 98 |
1042665 | 1042665 | 2021-02-18 | Wayne | Ohio | 39169 | 7738 | 207 |
1013437 | 1013437 | 2021-02-09 | Pickaway | Ohio | 39129 | 7738 | 51 |
869331 | 869331 | 2020-12-27 | Dallas | Iowa | 19049 | 7738 | 64 |
804099 | 804099 | 2020-12-07 | Muscogee | Georgia | 13215 | 7738 | 198 |
386275 | 386275 | 2020-07-31 | Escambia | Florida | 12033 | 7738 | 95 |
204101 | 204101 | 2020-06-03 | Jefferson | Louisiana | 22051 | 7738 | 454 |
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);