ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 5453 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Virginia 10
- New York 6
- Missouri 5
- Georgia 4
- Ohio 4
- Tennessee 4
- Arkansas 3
- Illinois 3
- New Jersey 3
- Alabama 2
- Idaho 2
- Indiana 2
- Kentucky 2
- Maryland 2
- North Carolina 2
- North Dakota 2
- Colorado 1
- Florida 1
- Iowa 1
- Kansas 1
- Minnesota 1
- Nebraska 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- South Dakota 1
- Texas 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405640 | 2405640 | 2022-04-14 | Pike | Georgia | 13231 | 5453 | 96 |
2330458 | 2330458 | 2022-03-22 | Ouachita | Arkansas | 5103 | 5453 | 102 |
2327206 | 2327206 | 2022-03-21 | Ouachita | Arkansas | 5103 | 5453 | 102 |
2226003 | 2226003 | 2022-02-17 | Page | Virginia | 51139 | 5453 | 108 |
2220956 | 2220956 | 2022-02-16 | Talbot | Maryland | 24041 | 5453 | 80 |
2185452 | 2185452 | 2022-02-05 | Audrain | Missouri | 29007 | 5453 | 96 |
2182744 | 2182744 | 2022-02-04 | Rolette | North Dakota | 38079 | 5453 | 39 |
2171229 | 2171229 | 2022-02-01 | Montezuma | Colorado | 8083 | 5453 | 60 |
2057829 | 2057829 | 2021-12-28 | Daviess | Indiana | 18027 | 5453 | 125 |
2023688 | 2023688 | 2021-12-17 | Warren | Pennsylvania | 42123 | 5453 | 171 |
1990435 | 1990435 | 2021-12-07 | Polk | Missouri | 29167 | 5453 | 80 |
1983906 | 1983906 | 2021-12-05 | Lawrence | Missouri | 29109 | 5453 | 136 |
1939796 | 1939796 | 2021-11-21 | Charlottesville city | Virginia | 51540 | 5453 | 60 |
1936546 | 1936546 | 2021-11-20 | Charlottesville city | Virginia | 51540 | 5453 | 60 |
1933296 | 1933296 | 2021-11-19 | Charlottesville city | Virginia | 51540 | 5453 | 60 |
1925427 | 1925427 | 2021-11-17 | Pulaski | Missouri | 29169 | 5453 | 82 |
1919417 | 1919417 | 2021-11-15 | Champaign | Ohio | 39021 | 5453 | 81 |
1872462 | 1872462 | 2021-11-01 | Christian | Illinois | 17021 | 5453 | 100 |
1859382 | 1859382 | 2021-10-28 | Toombs | Georgia | 13279 | 5453 | 169 |
1846423 | 1846423 | 2021-10-24 | Bonner | Idaho | 16017 | 5453 | 94 |
1805572 | 1805572 | 2021-10-11 | Jackson | North Carolina | 37099 | 5453 | 69 |
1806667 | 1806667 | 2021-10-11 | Tazewell | Virginia | 51185 | 5453 | 94 |
1803417 | 1803417 | 2021-10-10 | Tazewell | Virginia | 51185 | 5453 | 94 |
1800168 | 1800168 | 2021-10-09 | Tazewell | Virginia | 51185 | 5453 | 94 |
1796919 | 1796919 | 2021-10-08 | Tazewell | Virginia | 51185 | 5453 | 94 |
1791124 | 1791124 | 2021-10-07 | Pickens | Georgia | 13227 | 5453 | 108 |
1788053 | 1788053 | 2021-10-06 | Randolph | Illinois | 17157 | 5453 | 104 |
1719093 | 1719093 | 2021-09-14 | Pierce | Wisconsin | 55093 | 5453 | 44 |
1700196 | 1700196 | 2021-09-09 | Wayne | Georgia | 13305 | 5453 | 117 |
1691807 | 1691807 | 2021-09-06 | Tompkins | New York | 36109 | 5453 | 56 |
1652047 | 1652047 | 2021-08-25 | Whitley | Kentucky | 21235 | 5453 | 65 |
1607903 | 1607903 | 2021-08-11 | Newberry | South Carolina | 45071 | 5453 | 109 |
1604236 | 1604236 | 2021-08-10 | Morton | North Dakota | 38059 | 5453 | 102 |
1592005 | 1592005 | 2021-08-06 | Nacogdoches | Texas | 48347 | 5453 | 176 |
1559992 | 1559992 | 2021-07-28 | Dale | Alabama | 1045 | 5453 | 117 |
1561833 | 1561833 | 2021-07-28 | Genesee | New York | 36037 | 5453 | 124 |
1558585 | 1558585 | 2021-07-27 | Genesee | New York | 36037 | 5453 | 124 |
1555338 | 1555338 | 2021-07-26 | Genesee | New York | 36037 | 5453 | 124 |
1555837 | 1555837 | 2021-07-26 | Guaynabo | Puerto Rico | 72061 | 5453 | |
1552091 | 1552091 | 2021-07-25 | Genesee | New York | 36037 | 5453 | 124 |
1533823 | 1533823 | 2021-07-19 | Lewis | Washington | 53041 | 5453 | 80 |
1490667 | 1490667 | 2021-07-06 | Sandusky | Ohio | 39143 | 5453 | 129 |
1348274 | 1348274 | 2021-05-23 | Dyer | Tennessee | 47045 | 5453 | 106 |
1345026 | 1345026 | 2021-05-22 | Dyer | Tennessee | 47045 | 5453 | 106 |
1340040 | 1340040 | 2021-05-21 | Cerro Gordo | Iowa | 19033 | 5453 | 89 |
1341778 | 1341778 | 2021-05-21 | Dyer | Tennessee | 47045 | 5453 | 106 |
1318600 | 1318600 | 2021-05-14 | Huron | Ohio | 39077 | 5453 | 120 |
1254830 | 1254830 | 2021-04-25 | Coffee | Alabama | 1031 | 5453 | 115 |
1253246 | 1253246 | 2021-04-24 | Buffalo | Nebraska | 31019 | 5453 | 58 |
1211159 | 1211159 | 2021-04-11 | Salem | New Jersey | 34033 | 5453 | 171 |
1181340 | 1181340 | 2021-04-02 | St. Mary's | Maryland | 24037 | 5453 | 123 |
1067206 | 1067206 | 2021-02-26 | Dearborn | Indiana | 18029 | 5453 | 69 |
968003 | 968003 | 2021-01-26 | Scioto | Ohio | 39145 | 5453 | 65 |
919744 | 919744 | 2021-01-11 | Gibson | Tennessee | 47053 | 5453 | 104 |
840353 | 840353 | 2020-12-18 | Hardin | Kentucky | 21093 | 5453 | 39 |
808445 | 808445 | 2020-12-08 | St. Francois | Missouri | 29187 | 5453 | 51 |
801697 | 801697 | 2020-12-06 | Clay | Minnesota | 27027 | 5453 | 64 |
786632 | 786632 | 2020-12-01 | Lincoln | South Dakota | 46083 | 5453 | 51 |
728660 | 728660 | 2020-11-13 | Chesapeake city | Virginia | 51550 | 5453 | 80 |
617399 | 617399 | 2020-10-10 | Pitt | North Carolina | 37147 | 5453 | 33 |
576262 | 576262 | 2020-09-27 | Henrico | Virginia | 51087 | 5453 | 211 |
492487 | 492487 | 2020-09-02 | Benton | Arkansas | 5007 | 5453 | 57 |
487769 | 487769 | 2020-08-31 | Monroe | New York | 36055 | 5453 | 257 |
478006 | 478006 | 2020-08-28 | Somerset | New Jersey | 34035 | 5453 | 567 |
444911 | 444911 | 2020-08-18 | Wyandotte | Kansas | 20209 | 5453 | 108 |
405805 | 405805 | 2020-08-06 | Canyon | Idaho | 16027 | 5453 | 46 |
333200 | 333200 | 2020-07-14 | Burlington | New Jersey | 34005 | 5453 | 451 |
181896 | 181896 | 2020-05-27 | Palm Beach | Florida | 12099 | 5453 | 320 |
142798 | 142798 | 2020-05-14 | DuPage | Illinois | 17043 | 5453 | 279 |
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);