ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
166 rows where cases = 3555 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 15
- Georgia 12
- Texas 10
- New York 9
- Florida 8
- Iowa 8
- Louisiana 7
- Wisconsin 7
- Minnesota 6
- Ohio 6
- Puerto Rico 6
- Arkansas 5
- Illinois 5
- Colorado 4
- Indiana 4
- Michigan 4
- Missouri 4
- North Carolina 4
- Tennessee 4
- Washington 4
- Wyoming 4
- Alabama 3
- Pennsylvania 3
- South Carolina 3
- West Virginia 3
- California 2
- Kansas 2
- Kentucky 2
- Maryland 2
- Oregon 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470085 | 2470085 | 2022-05-03 | Klickitat | Washington | 53039 | 3555 | 45 |
2466829 | 2466829 | 2022-05-02 | Klickitat | Washington | 53039 | 3555 | 45 |
2463654 | 2463654 | 2022-05-01 | Buffalo | Wisconsin | 55011 | 3555 | 12 |
2460398 | 2460398 | 2022-04-30 | Buffalo | Wisconsin | 55011 | 3555 | 12 |
2456359 | 2456359 | 2022-04-29 | Loiza | Puerto Rico | 72087 | 3555 | |
2457142 | 2457142 | 2022-04-29 | Buffalo | Wisconsin | 55011 | 3555 | 12 |
2410288 | 2410288 | 2022-04-15 | Schuyler | New York | 36097 | 3555 | 25 |
2374833 | 2374833 | 2022-04-04 | Hood River | Oregon | 41027 | 3555 | 42 |
2366363 | 2366363 | 2022-04-02 | Las Animas | Colorado | 8071 | 3555 | 41 |
2363110 | 2363110 | 2022-04-01 | Las Animas | Colorado | 8071 | 3555 | 41 |
2359856 | 2359856 | 2022-03-31 | Las Animas | Colorado | 8071 | 3555 | 41 |
2331584 | 2331584 | 2022-03-22 | Leelanau | Michigan | 26089 | 3555 | 52 |
2328332 | 2328332 | 2022-03-21 | Leelanau | Michigan | 26089 | 3555 | 52 |
2281190 | 2281190 | 2022-03-06 | Alleghany | Virginia | 51005 | 3555 | 94 |
2277937 | 2277937 | 2022-03-05 | Alleghany | Virginia | 51005 | 3555 | 94 |
2274684 | 2274684 | 2022-03-04 | Alleghany | Virginia | 51005 | 3555 | 94 |
2271431 | 2271431 | 2022-03-03 | Alleghany | Virginia | 51005 | 3555 | 94 |
2263107 | 2263107 | 2022-03-01 | Trigg | Kentucky | 21221 | 3555 | 41 |
2233920 | 2233920 | 2022-02-20 | West Carroll | Louisiana | 22123 | 3555 | 57 |
2230669 | 2230669 | 2022-02-19 | West Carroll | Louisiana | 22123 | 3555 | 57 |
2227418 | 2227418 | 2022-02-18 | West Carroll | Louisiana | 22123 | 3555 | 57 |
2217377 | 2217377 | 2022-02-15 | Wright | Iowa | 19197 | 3555 | 60 |
2214126 | 2214126 | 2022-02-14 | Wright | Iowa | 19197 | 3555 | 60 |
2210874 | 2210874 | 2022-02-13 | Wright | Iowa | 19197 | 3555 | 60 |
2207621 | 2207621 | 2022-02-12 | Wright | Iowa | 19197 | 3555 | 60 |
2209831 | 2209831 | 2022-02-12 | Braxton | West Virginia | 54007 | 3555 | 37 |
2204368 | 2204368 | 2022-02-11 | Wright | Iowa | 19197 | 3555 | 60 |
2201115 | 2201115 | 2022-02-10 | Wright | Iowa | 19197 | 3555 | 60 |
2197861 | 2197861 | 2022-02-09 | Wright | Iowa | 19197 | 3555 | 60 |
2180218 | 2180218 | 2022-02-03 | Leon | Texas | 48289 | 3555 | 80 |
2144901 | 2144901 | 2022-01-23 | Lincoln | Wyoming | 56023 | 3555 | 27 |
2141646 | 2141646 | 2022-01-22 | Lincoln | Wyoming | 56023 | 3555 | 27 |
2138390 | 2138390 | 2022-01-21 | Lincoln | Wyoming | 56023 | 3555 | 27 |
2129338 | 2129338 | 2022-01-19 | Warren | Illinois | 17187 | 3555 | 77 |
2096152 | 2096152 | 2022-01-09 | Fayette | Alabama | 1057 | 3555 | 86 |
2082252 | 2082252 | 2022-01-04 | Naranjito | Puerto Rico | 72105 | 3555 | |
2073488 | 2073488 | 2022-01-02 | Conway | Arkansas | 5029 | 3555 | 48 |
2033471 | 2033471 | 2021-12-20 | Dorado | Puerto Rico | 72051 | 3555 | |
2028253 | 2028253 | 2021-12-19 | Appling | Georgia | 13001 | 3555 | 108 |
2024713 | 2024713 | 2021-12-18 | La Paz | Arizona | 4012 | 3555 | 105 |
2024773 | 2024773 | 2021-12-18 | Ouachita | Arkansas | 5103 | 3555 | 88 |
2025002 | 2025002 | 2021-12-18 | Appling | Georgia | 13001 | 3555 | 108 |
2021751 | 2021751 | 2021-12-17 | Appling | Georgia | 13001 | 3555 | 108 |
1998395 | 1998395 | 2021-12-09 | Scott | Virginia | 51169 | 3555 | 86 |
1991538 | 1991538 | 2021-12-07 | Deaf Smith | Texas | 48117 | 3555 | 87 |
1985271 | 1985271 | 2021-12-05 | Orleans | Vermont | 50019 | 3555 | 25 |
1975601 | 1975601 | 2021-12-02 | Louisa | Virginia | 51109 | 3555 | 53 |
1970994 | 1970994 | 2021-12-01 | Lincoln | Montana | 30053 | 3555 | 68 |
1929860 | 1929860 | 2021-11-18 | Lampasas | Texas | 48281 | 3555 | 68 |
1924570 | 1924570 | 2021-11-17 | Fountain | Indiana | 18045 | 3555 | 64 |
1926610 | 1926610 | 2021-11-17 | Lampasas | Texas | 48281 | 3555 | 68 |
1917831 | 1917831 | 2021-11-15 | McDuffie | Georgia | 13189 | 3555 | 76 |
1895130 | 1895130 | 2021-11-08 | Union | Georgia | 13291 | 3555 | 127 |
1869064 | 1869064 | 2021-10-31 | Hart | Georgia | 13147 | 3555 | 68 |
1865815 | 1865815 | 2021-10-30 | Hart | Georgia | 13147 | 3555 | 68 |
1862566 | 1862566 | 2021-10-29 | Hart | Georgia | 13147 | 3555 | 68 |
1838206 | 1838206 | 2021-10-21 | Hocking | Ohio | 39073 | 3555 | 79 |
1825211 | 1825211 | 2021-10-17 | Holmes | Ohio | 39075 | 3555 | 122 |
1807020 | 1807020 | 2021-10-12 | Logan | Arkansas | 5083 | 3555 | 40 |
1807775 | 1807775 | 2021-10-12 | Cherokee | Kansas | 20021 | 3555 | 77 |
1804524 | 1804524 | 2021-10-11 | Cherokee | Kansas | 20021 | 3555 | 77 |
1806655 | 1806655 | 2021-10-11 | Russell | Virginia | 51167 | 3555 | 54 |
1803405 | 1803405 | 2021-10-10 | Russell | Virginia | 51167 | 3555 | 54 |
1800156 | 1800156 | 2021-10-09 | Russell | Virginia | 51167 | 3555 | 54 |
1796907 | 1796907 | 2021-10-08 | Russell | Virginia | 51167 | 3555 | 54 |
1778750 | 1778750 | 2021-10-03 | Assumption | Louisiana | 22007 | 3555 | 57 |
1775500 | 1775500 | 2021-10-02 | Assumption | Louisiana | 22007 | 3555 | 57 |
1772250 | 1772250 | 2021-10-01 | Assumption | Louisiana | 22007 | 3555 | 57 |
1768303 | 1768303 | 2021-09-30 | Cook | Georgia | 13075 | 3555 | 54 |
1770823 | 1770823 | 2021-09-30 | Carroll | Virginia | 51035 | 3555 | 85 |
1771023 | 1771023 | 2021-09-30 | Upshur | West Virginia | 54097 | 3555 | 56 |
1758321 | 1758321 | 2021-09-27 | Calaveras | California | 6009 | 3555 | 70 |
1759350 | 1759350 | 2021-09-27 | Queen Anne's | Maryland | 24035 | 3555 | 64 |
1756219 | 1756219 | 2021-09-26 | Cass | Minnesota | 27021 | 3555 | 36 |
1752971 | 1752971 | 2021-09-25 | Cass | Minnesota | 27021 | 3555 | 36 |
1749723 | 1749723 | 2021-09-24 | Cass | Minnesota | 27021 | 3555 | 36 |
1702097 | 1702097 | 2021-09-09 | Jasper | South Carolina | 45053 | 3555 | 60 |
1689848 | 1689848 | 2021-09-05 | Lincoln | Wisconsin | 55069 | 3555 | 102 |
1686598 | 1686598 | 2021-09-04 | Lincoln | Wisconsin | 55069 | 3555 | 102 |
1682847 | 1682847 | 2021-09-03 | Dimmit | Texas | 48127 | 3555 | 38 |
1683348 | 1683348 | 2021-09-03 | Lincoln | Wisconsin | 55069 | 3555 | 102 |
1671978 | 1671978 | 2021-08-31 | Miller | Missouri | 29131 | 3555 | 68 |
1653221 | 1653221 | 2021-08-25 | Greene | Pennsylvania | 42059 | 3555 | 42 |
1647333 | 1647333 | 2021-08-23 | Uintah | Utah | 49047 | 3555 | 30 |
1622365 | 1622365 | 2021-08-16 | Perry | Illinois | 17145 | 3555 | 72 |
1610665 | 1610665 | 2021-08-12 | Montgomery | North Carolina | 37123 | 3555 | 97 |
1592076 | 1592076 | 2021-08-06 | Willacy | Texas | 48489 | 3555 | 93 |
1589036 | 1589036 | 2021-08-05 | Kittitas | Washington | 53037 | 3555 | 37 |
1532078 | 1532078 | 2021-07-19 | Carlton | Minnesota | 27017 | 3555 | 57 |
1523053 | 1523053 | 2021-07-16 | Stutsman | North Dakota | 38093 | 3555 | 82 |
1515841 | 1515841 | 2021-07-14 | Carlton | Minnesota | 27017 | 3555 | 57 |
1512595 | 1512595 | 2021-07-13 | Carlton | Minnesota | 27017 | 3555 | 57 |
1513896 | 1513896 | 2021-07-13 | Bee | Texas | 48025 | 3555 | 75 |
1501128 | 1501128 | 2021-07-09 | Upshur | Texas | 48459 | 3555 | 77 |
1475409 | 1475409 | 2021-07-01 | Fayette | West Virginia | 54019 | 3555 | 80 |
1451923 | 1451923 | 2021-06-24 | Arecibo | Puerto Rico | 72013 | 3555 | |
1422221 | 1422221 | 2021-06-15 | Allegany | New York | 36003 | 3555 | 87 |
1422821 | 1422821 | 2021-06-15 | Marion | South Carolina | 45067 | 3555 | 108 |
1418975 | 1418975 | 2021-06-14 | Allegany | New York | 36003 | 3555 | 87 |
1415730 | 1415730 | 2021-06-13 | Allegany | New York | 36003 | 3555 | 87 |
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);