ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where county = "Marion" and date = "2020-06-10" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
224657 | 224657 | 2020-06-10 | Marion | Alabama | 1093 | 130 | 12 |
224759 | 224759 | 2020-06-10 | Marion | Arkansas | 5089 | 2 | 0 |
224962 | 224962 | 2020-06-10 | Marion | Florida | 12083 | 286 | 8 |
225085 | 225085 | 2020-06-10 | Marion | Georgia | 13197 | 59 | 2 |
225247 | 225247 | 2020-06-10 | Marion | Illinois | 17121 | 55 | 0 |
225340 | 225340 | 2020-06-10 | Marion | Indiana | 18097 | 10581 | 680 |
225446 | 225446 | 2020-06-10 | Marion | Iowa | 19125 | 38 | 0 |
225532 | 225532 | 2020-06-10 | Marion | Kansas | 20115 | 7 | 1 |
225648 | 225648 | 2020-06-10 | Marion | Kentucky | 21155 | 38 | 0 |
226028 | 226028 | 2020-06-10 | Marion | Mississippi | 28091 | 132 | 9 |
226125 | 226125 | 2020-06-10 | Marion | Missouri | 29127 | 6 | 0 |
226617 | 226617 | 2020-06-10 | Marion | Ohio | 39101 | 2697 | 33 |
226751 | 226751 | 2020-06-10 | Marion | Oregon | 41047 | 1071 | 30 |
226947 | 226947 | 2020-06-10 | Marion | South Carolina | 45067 | 83 | 5 |
227073 | 227073 | 2020-06-10 | Marion | Tennessee | 47115 | 46 | 1 |
227259 | 227259 | 2020-06-10 | Marion | Texas | 48315 | 18 | 1 |
227585 | 227585 | 2020-06-10 | Marion | West Virginia | 54049 | 53 | 2 |
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);