ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 13589 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Illinois 8
- Oklahoma 7
- Arkansas 3
- Indiana 2
- New York 2
- Louisiana 1
- Mississippi 1
- Pennsylvania 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463901 | 2463901 | 2022-05-02 | Mississippi | Arkansas | 5093 | 13589 | 210 |
2383125 | 2383125 | 2022-04-07 | Shelby | Indiana | 18145 | 13589 | 181 |
2379870 | 2379870 | 2022-04-06 | Shelby | Indiana | 18145 | 13589 | 181 |
2367985 | 2367985 | 2022-04-02 | Warren | New York | 36113 | 13589 | 125 |
2332163 | 2332163 | 2022-03-22 | Genesee | New York | 36037 | 13589 | 184 |
2213358 | 2213358 | 2022-02-14 | Crittenden | Arkansas | 5035 | 13589 | 207 |
1922795 | 1922795 | 2021-11-16 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1919546 | 1919546 | 2021-11-15 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1916296 | 1916296 | 2021-11-14 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1913046 | 1913046 | 2021-11-13 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1909796 | 1909796 | 2021-11-12 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1906547 | 1906547 | 2021-11-11 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1903298 | 1903298 | 2021-11-10 | Muskogee | Oklahoma | 40101 | 13589 | 262 |
1874917 | 1874917 | 2021-11-01 | Cowlitz | Washington | 53015 | 13589 | 243 |
1584979 | 1584979 | 2021-08-04 | Blair | Pennsylvania | 42013 | 13589 | 344 |
1333381 | 1333381 | 2021-05-19 | Kendall | Illinois | 17093 | 13589 | 103 |
1330134 | 1330134 | 2021-05-18 | Kendall | Illinois | 17093 | 13589 | 103 |
1326887 | 1326887 | 2021-05-17 | Kendall | Illinois | 17093 | 13589 | 103 |
1323641 | 1323641 | 2021-05-16 | Kendall | Illinois | 17093 | 13589 | 103 |
1320395 | 1320395 | 2021-05-15 | Kendall | Illinois | 17093 | 13589 | 103 |
1317148 | 1317148 | 2021-05-14 | Kendall | Illinois | 17093 | 13589 | 103 |
1313901 | 1313901 | 2021-05-13 | Kendall | Illinois | 17093 | 13589 | 102 |
1304989 | 1304989 | 2021-05-10 | Rankin | Mississippi | 28121 | 13589 | 278 |
985519 | 985519 | 2021-02-01 | Sebastian | Arkansas | 5131 | 13589 | 232 |
898404 | 898404 | 2021-01-05 | Sangamon | Illinois | 17167 | 13589 | 209 |
874569 | 874569 | 2020-12-28 | Randall | Texas | 48381 | 13589 | 179 |
691195 | 691195 | 2020-11-02 | Orleans | Louisiana | 22071 | 13589 | 595 |
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);