ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 15810 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Michigan 7
- Minnesota 5
- Ohio 4
- Arizona 1
- Indiana 1
- Maryland 1
- New York 1
- North Carolina 1
- Puerto Rico 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399923 | 2399923 | 2022-04-12 | Marquette | Michigan | 26103 | 15810 | 128 |
2396667 | 2396667 | 2022-04-11 | Marquette | Michigan | 26103 | 15810 | 128 |
2393412 | 2393412 | 2022-04-10 | Marquette | Michigan | 26103 | 15810 | 128 |
2390156 | 2390156 | 2022-04-09 | Marquette | Michigan | 26103 | 15810 | 128 |
2386900 | 2386900 | 2022-04-08 | Marquette | Michigan | 26103 | 15810 | 128 |
2383645 | 2383645 | 2022-04-07 | Marquette | Michigan | 26103 | 15810 | 128 |
2380390 | 2380390 | 2022-04-06 | Marquette | Michigan | 26103 | 15810 | 128 |
2291225 | 2291225 | 2022-03-09 | Sauk | Wisconsin | 55111 | 15810 | 116 |
2165768 | 2165768 | 2022-01-30 | Blue Earth | Minnesota | 27013 | 15810 | 86 |
2162513 | 2162513 | 2022-01-29 | Blue Earth | Minnesota | 27013 | 15810 | 86 |
2159258 | 2159258 | 2022-01-28 | Blue Earth | Minnesota | 27013 | 15810 | 86 |
2146254 | 2146254 | 2022-01-24 | Clay | Minnesota | 27027 | 15810 | 115 |
2081950 | 2081950 | 2022-01-04 | Erie | Ohio | 39043 | 15810 | 219 |
1922715 | 1922715 | 2021-11-16 | Muskingum | Ohio | 39119 | 15810 | 200 |
1877016 | 1877016 | 2021-11-02 | Burke | North Carolina | 37023 | 15810 | 239 |
1851449 | 1851449 | 2021-10-25 | Bayamon | Puerto Rico | 72021 | 15810 | |
1578096 | 1578096 | 2021-08-02 | Saratoga | New York | 36091 | 15810 | 168 |
1549093 | 1549093 | 2021-07-24 | Medina | Ohio | 39103 | 15810 | 276 |
1263446 | 1263446 | 2021-04-27 | Trumbull | Ohio | 39155 | 15810 | 462 |
1011411 | 1011411 | 2021-02-09 | Coconino | Arizona | 4005 | 15810 | 295 |
749154 | 749154 | 2020-11-20 | Elkhart | Indiana | 18039 | 15810 | 212 |
587452 | 587452 | 2020-10-01 | Baltimore city | Maryland | 24510 | 15810 | 486 |
364789 | 364789 | 2020-07-24 | Hennepin | Minnesota | 27053 | 15810 | 805 |
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);