ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 9223 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Louisiana 5
- Nebraska 4
- Ohio 4
- Texas 4
- Alabama 3
- Georgia 3
- Indiana 3
- South Carolina 2
- Virginia 2
- California 1
- Florida 1
- Illinois 1
- Iowa 1
- Kentucky 1
- Mississippi 1
- New Mexico 1
- New York 1
- Pennsylvania 1
- South Dakota 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473125 | 2473125 | 2022-05-04 | Washington | Texas | 48477 | 9223 | 148 |
2469869 | 2469869 | 2022-05-03 | Washington | Texas | 48477 | 9223 | 148 |
2466613 | 2466613 | 2022-05-02 | Washington | Texas | 48477 | 9223 | 148 |
2328900 | 2328900 | 2022-03-21 | Chenango | New York | 36017 | 9223 | 118 |
2266373 | 2266373 | 2022-03-02 | Beauregard | Louisiana | 22011 | 9223 | 138 |
2262751 | 2262751 | 2022-03-01 | Miami | Indiana | 18103 | 9223 | 158 |
2242508 | 2242508 | 2022-02-23 | Covington | Alabama | 1039 | 9223 | 216 |
2218210 | 2218210 | 2022-02-15 | Madison | Nebraska | 31119 | 9223 | 60 |
2211707 | 2211707 | 2022-02-13 | Madison | Nebraska | 31119 | 9223 | 60 |
2208454 | 2208454 | 2022-02-12 | Madison | Nebraska | 31119 | 9223 | 60 |
2205201 | 2205201 | 2022-02-11 | Madison | Nebraska | 31119 | 9223 | 60 |
2199097 | 2199097 | 2022-02-09 | Preble | Ohio | 39135 | 9223 | 179 |
2119379 | 2119379 | 2022-01-16 | Murray | Georgia | 13213 | 9223 | 153 |
2116127 | 2116127 | 2022-01-15 | Murray | Georgia | 13213 | 9223 | 153 |
2112876 | 2112876 | 2022-01-14 | Murray | Georgia | 13213 | 9223 | 153 |
2104706 | 2104706 | 2022-01-11 | Crawford | Ohio | 39033 | 9223 | 172 |
2038246 | 2038246 | 2021-12-22 | Grundy | Illinois | 17063 | 9223 | 100 |
1945487 | 1945487 | 2021-11-23 | Union | Ohio | 39159 | 9223 | 72 |
1900114 | 1900114 | 2021-11-09 | Armstrong | Pennsylvania | 42005 | 9223 | 206 |
1815212 | 1815212 | 2021-10-14 | Valencia | New Mexico | 35061 | 9223 | 138 |
1788132 | 1788132 | 2021-10-06 | Morgan | Indiana | 18109 | 9223 | 179 |
1695660 | 1695660 | 2021-09-07 | Lincoln | South Dakota | 46083 | 9223 | 78 |
1583727 | 1583727 | 2021-08-04 | Campbell | Kentucky | 21037 | 9223 | 84 |
1580906 | 1580906 | 2021-08-03 | Jones | Mississippi | 28067 | 9223 | 169 |
1556551 | 1556551 | 2021-07-26 | Kitsap | Washington | 53035 | 9223 | 123 |
1539385 | 1539385 | 2021-07-21 | Wayne | Ohio | 39169 | 9223 | 226 |
1486458 | 1486458 | 2021-07-05 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1488310 | 1488310 | 2021-07-05 | Portsmouth city | Virginia | 51740 | 9223 | 204 |
1483212 | 1483212 | 2021-07-04 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1485063 | 1485063 | 2021-07-04 | Portsmouth city | Virginia | 51740 | 9223 | 204 |
1479965 | 1479965 | 2021-07-03 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1476719 | 1476719 | 2021-07-02 | St. Landry | Louisiana | 22097 | 9223 | 262 |
1215884 | 1215884 | 2021-04-13 | Lauderdale | Alabama | 1077 | 9223 | 227 |
1153727 | 1153727 | 2021-03-24 | Starr | Texas | 48427 | 9223 | 284 |
1150096 | 1150096 | 2021-03-23 | Orangeburg | South Carolina | 45075 | 9223 | 231 |
1040563 | 1040563 | 2021-02-18 | Limestone | Alabama | 1083 | 9223 | 127 |
1018683 | 1018683 | 2021-02-11 | Story | Iowa | 19169 | 9223 | 43 |
870932 | 870932 | 2020-12-27 | Beaufort | South Carolina | 45013 | 9223 | 100 |
755708 | 755708 | 2020-11-22 | Vanderburgh | Indiana | 18163 | 9223 | 113 |
586474 | 586474 | 2020-10-01 | Santa Barbara | California | 6083 | 9223 | 115 |
479824 | 479824 | 2020-08-29 | Volusia | Florida | 12127 | 9223 | 189 |
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);