ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 9918 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Wyoming 4
- Virginia 3
- Alabama 2
- Louisiana 2
- Mississippi 2
- South Carolina 2
- Arkansas 1
- California 1
- Delaware 1
- Florida 1
- Georgia 1
- Idaho 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- Oregon 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375836 | 2375836 | 2022-04-04 | Teton | Wyoming | 56039 | 9918 | 16 |
2372584 | 2372584 | 2022-04-03 | Teton | Wyoming | 56039 | 9918 | 16 |
2369331 | 2369331 | 2022-04-02 | Teton | Wyoming | 56039 | 9918 | 16 |
2366078 | 2366078 | 2022-04-01 | Teton | Wyoming | 56039 | 9918 | 16 |
2350996 | 2350996 | 2022-03-28 | Vernon | Louisiana | 22115 | 9918 | 188 |
2266995 | 2266995 | 2022-03-02 | Scotts Bluff | Nebraska | 31157 | 9918 | 102 |
2244069 | 2244069 | 2022-02-23 | Phelps | Missouri | 29161 | 9918 | 228 |
2229511 | 2229511 | 2022-02-19 | Escambia | Alabama | 1053 | 9918 | 155 |
2201709 | 2201709 | 2022-02-10 | Warren | Mississippi | 28149 | 9918 | 191 |
2174337 | 2174337 | 2022-02-02 | Independence | Arkansas | 5063 | 9918 | 184 |
2172405 | 2172405 | 2022-02-01 | Monroe | Mississippi | 28095 | 9918 | 191 |
2149208 | 2149208 | 2022-01-25 | Graves | Kentucky | 21083 | 9918 | 142 |
2099093 | 2099093 | 2022-01-09 | Fauquier | Virginia | 51061 | 9918 | 95 |
2095842 | 2095842 | 2022-01-08 | Fauquier | Virginia | 51061 | 9918 | 95 |
2092590 | 2092590 | 2022-01-07 | Fauquier | Virginia | 51061 | 9918 | 95 |
1543773 | 1543773 | 2021-07-23 | Lauderdale | Alabama | 1077 | 9918 | 253 |
1516960 | 1516960 | 2021-07-14 | Orangeburg | South Carolina | 45075 | 9918 | 255 |
1511859 | 1511859 | 2021-07-13 | Twin Falls | Idaho | 16083 | 9918 | 132 |
1412872 | 1412872 | 2021-06-12 | Deschutes | Oregon | 41017 | 9918 | 80 |
1398807 | 1398807 | 2021-06-08 | Lafourche | Louisiana | 22057 | 9918 | 205 |
1379971 | 1379971 | 2021-06-02 | Strafford | New Hampshire | 33017 | 9918 | 94 |
1301005 | 1301005 | 2021-05-09 | Howard | Indiana | 18067 | 9918 | 220 |
1281187 | 1281187 | 2021-05-03 | Barrow | Georgia | 13013 | 9918 | 136 |
1137100 | 1137100 | 2021-03-19 | Lancaster | South Carolina | 45057 | 9918 | 152 |
1017338 | 1017338 | 2021-02-10 | Maverick | Texas | 48323 | 9918 | 260 |
837277 | 837277 | 2020-12-17 | Howard | Maryland | 24027 | 9918 | 166 |
764982 | 764982 | 2020-11-25 | Sussex | Delaware | 10005 | 9918 | 258 |
505532 | 505532 | 2020-09-06 | San Francisco | California | 6075 | 9918 | 86 |
281128 | 281128 | 2020-06-28 | Hillsborough | Florida | 12057 | 9918 | 132 |
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);