ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 7534 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Ohio 8
- Georgia 4
- New York 3
- California 2
- Indiana 2
- Kansas 2
- Michigan 2
- North Carolina 2
- Texas 2
- Alabama 1
- Connecticut 1
- Florida 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- Nebraska 1
- Nevada 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495154 | 2495154 | 2022-05-11 | Gallia | Ohio | 39053 | 7534 | 126 |
2491896 | 2491896 | 2022-05-10 | Gallia | Ohio | 39053 | 7534 | 126 |
2488638 | 2488638 | 2022-05-09 | Gallia | Ohio | 39053 | 7534 | 126 |
2485381 | 2485381 | 2022-05-08 | Gallia | Ohio | 39053 | 7534 | 126 |
2482123 | 2482123 | 2022-05-07 | Gallia | Ohio | 39053 | 7534 | 126 |
2478865 | 2478865 | 2022-05-06 | Gallia | Ohio | 39053 | 7534 | 126 |
2475607 | 2475607 | 2022-05-05 | Gallia | Ohio | 39053 | 7534 | 126 |
2332533 | 2332533 | 2022-03-22 | Columbia | Oregon | 41009 | 7534 | 78 |
2247599 | 2247599 | 2022-02-24 | Delaware | New York | 36025 | 7534 | 68 |
2169025 | 2169025 | 2022-01-31 | Carlton | Minnesota | 27017 | 7534 | 84 |
2107733 | 2107733 | 2022-01-12 | Chenango | New York | 36017 | 7534 | 103 |
2062135 | 2062135 | 2021-12-29 | Lyon | Nevada | 32019 | 7534 | 137 |
2031843 | 2031843 | 2021-12-20 | Gibson | Indiana | 18051 | 7534 | 125 |
1872329 | 1872329 | 2021-11-01 | Liberty | Georgia | 13179 | 7534 | 114 |
1859312 | 1859312 | 2021-10-28 | Habersham | Georgia | 13137 | 7534 | 204 |
1759567 | 1759567 | 2021-09-27 | Hancock | Mississippi | 28045 | 7534 | 113 |
1667382 | 1667382 | 2021-08-30 | Nevada | California | 6057 | 7534 | 85 |
1649812 | 1649812 | 2021-08-24 | Ross | Ohio | 39141 | 7534 | 166 |
1581337 | 1581337 | 2021-08-03 | Ontario | New York | 36069 | 7534 | 93 |
1532728 | 1532728 | 2021-07-19 | Rutherford | North Carolina | 37161 | 7534 | 220 |
1471928 | 1471928 | 2021-06-30 | Wise | Texas | 48497 | 7534 | 125 |
1336711 | 1336711 | 2021-05-20 | Grant | Indiana | 18053 | 7534 | 181 |
1307664 | 1307664 | 2021-05-11 | Butler | Kansas | 20015 | 7534 | 86 |
1304418 | 1304418 | 2021-05-10 | Butler | Kansas | 20015 | 7534 | 86 |
1272350 | 1272350 | 2021-04-30 | Montcalm | Michigan | 26117 | 7534 | 106 |
1270878 | 1270878 | 2021-04-29 | Kitsap | Washington | 53035 | 7534 | 105 |
1171653 | 1171653 | 2021-03-30 | Ionia | Michigan | 26067 | 7534 | 79 |
1063695 | 1063695 | 2021-02-25 | Glynn | Georgia | 13127 | 7534 | 160 |
1040888 | 1040888 | 2021-02-18 | Nassau | Florida | 12089 | 7534 | 107 |
1020013 | 1020013 | 2021-02-11 | Pottawatomie | Oklahoma | 40125 | 7534 | 63 |
1001186 | 1001186 | 2021-02-05 | Victoria | Texas | 48469 | 7534 | 161 |
949963 | 949963 | 2021-01-21 | Windham | Connecticut | 9015 | 7534 | 116 |
946897 | 946897 | 2021-01-20 | Newton | Georgia | 13217 | 7534 | 149 |
935333 | 935333 | 2021-01-16 | Burke | North Carolina | 37023 | 7534 | 89 |
828852 | 828852 | 2020-12-14 | Blount | Tennessee | 47009 | 7534 | 70 |
813345 | 813345 | 2020-12-10 | Calhoun | Alabama | 1015 | 7534 | 129 |
645796 | 645796 | 2020-10-19 | St. Tammany | Louisiana | 22103 | 7534 | 269 |
633914 | 633914 | 2020-10-15 | Chester | Pennsylvania | 42029 | 7534 | 375 |
623631 | 623631 | 2020-10-12 | Lancaster | Nebraska | 31109 | 7534 | 32 |
617876 | 617876 | 2020-10-10 | Spartanburg | South Carolina | 45083 | 7534 | 211 |
554049 | 554049 | 2020-09-21 | Kings | California | 6031 | 7534 | 77 |
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);