ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 10498 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Mississippi 11
- Kansas 3
- Indiana 2
- Maryland 2
- Michigan 2
- Ohio 2
- Texas 2
- Florida 1
- Georgia 1
- Hawaii 1
- Illinois 1
- Iowa 1
- Kentucky 1
- Louisiana 1
- New Jersey 1
- New York 1
- North Dakota 1
- South Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448144 | 2448144 | 2022-04-27 | Randolph | Illinois | 17157 | 10498 | 131 |
2396841 | 2396841 | 2022-04-11 | Panola | Mississippi | 28107 | 10498 | 169 |
2393586 | 2393586 | 2022-04-10 | Panola | Mississippi | 28107 | 10498 | 169 |
2390330 | 2390330 | 2022-04-09 | Panola | Mississippi | 28107 | 10498 | 169 |
2387074 | 2387074 | 2022-04-08 | Panola | Mississippi | 28107 | 10498 | 169 |
2383819 | 2383819 | 2022-04-07 | Panola | Mississippi | 28107 | 10498 | 169 |
2380564 | 2380564 | 2022-04-06 | Panola | Mississippi | 28107 | 10498 | 169 |
2377309 | 2377309 | 2022-04-05 | Panola | Mississippi | 28107 | 10498 | 169 |
2374057 | 2374057 | 2022-04-04 | Panola | Mississippi | 28107 | 10498 | 169 |
2350985 | 2350985 | 2022-03-28 | St. John the Baptist | Louisiana | 22095 | 10498 | 184 |
2245347 | 2245347 | 2022-02-23 | Uvalde | Texas | 48463 | 10498 | 133 |
2218580 | 2218580 | 2022-02-15 | Highland | Ohio | 39071 | 10498 | 168 |
2087131 | 2087131 | 2022-01-06 | Noble | Indiana | 18113 | 10498 | 141 |
2040230 | 2040230 | 2021-12-22 | Unknown | Tennessee | 10498 | 148 | |
1944616 | 1944616 | 2021-11-23 | Grand Traverse | Michigan | 26055 | 10498 | 124 |
1941120 | 1941120 | 2021-11-22 | Christian | Kentucky | 21047 | 10498 | 145 |
1941365 | 1941365 | 2021-11-22 | Grand Traverse | Michigan | 26055 | 10498 | 124 |
1892294 | 1892294 | 2021-11-07 | Leavenworth | Kansas | 20103 | 10498 | 133 |
1889044 | 1889044 | 2021-11-06 | Leavenworth | Kansas | 20103 | 10498 | 133 |
1885794 | 1885794 | 2021-11-05 | Leavenworth | Kansas | 20103 | 10498 | 133 |
1863997 | 1863997 | 2021-10-29 | Steuben | New York | 36101 | 10498 | 175 |
1807420 | 1807420 | 2021-10-12 | Hawaii | Hawaii | 15001 | 10498 | 105 |
1713854 | 1713854 | 2021-09-13 | Carroll | Maryland | 24013 | 10498 | 267 |
1682280 | 1682280 | 2021-09-03 | Muskingum | Ohio | 39119 | 10498 | 142 |
1649493 | 1649493 | 2021-08-24 | Warren | New Jersey | 34041 | 10498 | 243 |
1607905 | 1607905 | 2021-08-11 | Orangeburg | South Carolina | 45075 | 10498 | 258 |
1528955 | 1528955 | 2021-07-18 | Madison | Mississippi | 28089 | 10498 | 227 |
1525708 | 1525708 | 2021-07-17 | Madison | Mississippi | 28089 | 10498 | 227 |
1522461 | 1522461 | 2021-07-16 | Madison | Mississippi | 28089 | 10498 | 227 |
1511998 | 1511998 | 2021-07-13 | Howard | Indiana | 18067 | 10498 | 241 |
1269824 | 1269824 | 2021-04-29 | Grand Forks | North Dakota | 38035 | 10498 | 77 |
1203184 | 1203184 | 2021-04-09 | Citrus | Florida | 12017 | 10498 | 437 |
1197229 | 1197229 | 2021-04-07 | Pottawattamie | Iowa | 19155 | 10498 | 157 |
1063654 | 1063654 | 2021-02-25 | Carroll | Georgia | 13045 | 10498 | 210 |
937888 | 937888 | 2021-01-17 | Washington | Maryland | 24043 | 10498 | 181 |
851884 | 851884 | 2020-12-21 | Taylor | Texas | 48441 | 10498 | 175 |
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);