ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
164 rows where cases = 3642 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 19
- Texas 18
- Minnesota 13
- Virginia 11
- Tennessee 10
- Ohio 9
- Arkansas 8
- Illinois 6
- Oregon 6
- Georgia 5
- Louisiana 5
- North Carolina 5
- Wisconsin 5
- Kentucky 4
- Michigan 4
- Alabama 3
- Indiana 3
- Iowa 3
- Kansas 3
- Alaska 2
- Maryland 2
- Mississippi 2
- New York 2
- Pennsylvania 2
- Puerto Rico 2
- Arizona 1
- California 1
- Florida 1
- Idaho 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475761 | 2475761 | 2022-05-05 | Hood River | Oregon | 41027 | 3642 | 43 |
2361837 | 2361837 | 2022-03-31 | Tillamook | Oregon | 41057 | 3642 | 60 |
2358583 | 2358583 | 2022-03-30 | Tillamook | Oregon | 41057 | 3642 | 60 |
2316407 | 2316407 | 2022-03-17 | Lares | Puerto Rico | 72081 | 3642 | |
2292868 | 2292868 | 2022-03-10 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2289616 | 2289616 | 2022-03-09 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2279859 | 2279859 | 2022-03-06 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2276606 | 2276606 | 2022-03-05 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2273353 | 2273353 | 2022-03-04 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2270101 | 2270101 | 2022-03-03 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2265717 | 2265717 | 2022-03-02 | Jefferson | Georgia | 13163 | 3642 | 105 |
2266848 | 2266848 | 2022-03-02 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2262504 | 2262504 | 2022-03-01 | Rabun | Georgia | 13241 | 3642 | 92 |
2264929 | 2264929 | 2022-03-01 | Appomattox | Virginia | 51011 | 3642 | 50 |
2257095 | 2257095 | 2022-02-27 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2253844 | 2253844 | 2022-02-26 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2250593 | 2250593 | 2022-02-25 | Ste. Genevieve | Missouri | 29186 | 3642 | 39 |
2219796 | 2219796 | 2022-02-16 | Washington | Alabama | 1129 | 3642 | 53 |
2222503 | 2222503 | 2022-02-16 | Leon | Texas | 48289 | 3642 | 85 |
2211327 | 2211327 | 2022-02-13 | Faribault | Minnesota | 27043 | 3642 | 49 |
2208074 | 2208074 | 2022-02-12 | Faribault | Minnesota | 27043 | 3642 | 49 |
2204821 | 2204821 | 2022-02-11 | Faribault | Minnesota | 27043 | 3642 | 49 |
2193793 | 2193793 | 2022-02-08 | Northwest Arctic Borough | Alaska | 2188 | 3642 | 11 |
2190540 | 2190540 | 2022-02-07 | Northwest Arctic Borough | Alaska | 2188 | 3642 | 11 |
2154361 | 2154361 | 2022-01-26 | Bristol city | Virginia | 51520 | 3642 | 62 |
2128334 | 2128334 | 2022-01-18 | Buchanan | Virginia | 51027 | 3642 | 90 |
2104387 | 2104387 | 2022-01-11 | Washington | Nebraska | 31177 | 3642 | 30 |
2099990 | 2099990 | 2022-01-10 | Clay | Illinois | 17025 | 3642 | 64 |
2099117 | 2099117 | 2022-01-09 | King George | Virginia | 51099 | 3642 | 27 |
2095866 | 2095866 | 2022-01-08 | King George | Virginia | 51099 | 3642 | 27 |
2092614 | 2092614 | 2022-01-07 | King George | Virginia | 51099 | 3642 | 27 |
2054024 | 2054024 | 2021-12-27 | Ouachita | Arkansas | 5103 | 3642 | 89 |
2034153 | 2034153 | 2021-12-20 | Scott | Virginia | 51169 | 3642 | 87 |
2009367 | 2009367 | 2021-12-13 | Bourbon | Kentucky | 21017 | 3642 | 42 |
1965485 | 1965485 | 2021-11-29 | Austin | Texas | 48015 | 3642 | 56 |
1965648 | 1965648 | 2021-11-29 | Moore | Texas | 48341 | 3642 | 88 |
1951256 | 1951256 | 2021-11-25 | Waseca | Minnesota | 27161 | 3642 | 32 |
1951998 | 1951998 | 2021-11-25 | Wyandot | Ohio | 39175 | 3642 | 73 |
1948005 | 1948005 | 2021-11-24 | Waseca | Minnesota | 27161 | 3642 | 32 |
1948747 | 1948747 | 2021-11-24 | Wyandot | Ohio | 39175 | 3642 | 73 |
1917009 | 1917009 | 2021-11-14 | Franklin | Vermont | 50011 | 3642 | 51 |
1905826 | 1905826 | 2021-11-11 | Stone | Mississippi | 28131 | 3642 | 66 |
1902577 | 1902577 | 2021-11-10 | Stone | Mississippi | 28131 | 3642 | 66 |
1876624 | 1876624 | 2021-11-02 | Crawford | Missouri | 29055 | 3642 | 59 |
1872305 | 1872305 | 2021-11-01 | Grady | Georgia | 13131 | 3642 | 88 |
1861625 | 1861625 | 2021-10-28 | Limestone | Texas | 48293 | 3642 | 109 |
1858376 | 1858376 | 2021-10-27 | Limestone | Texas | 48293 | 3642 | 108 |
1844706 | 1844706 | 2021-10-23 | Holmes | Ohio | 39075 | 3642 | 125 |
1836258 | 1836258 | 2021-10-21 | Lincoln | Arkansas | 5079 | 3642 | 57 |
1793867 | 1793867 | 2021-10-07 | Uinta | Wyoming | 56041 | 3642 | 26 |
1790353 | 1790353 | 2021-10-06 | Halifax | Virginia | 51083 | 3642 | 99 |
1785345 | 1785345 | 2021-10-05 | Queen Anne's | Maryland | 24035 | 3642 | 65 |
1785389 | 1785389 | 2021-10-05 | Dickinson | Michigan | 26043 | 3642 | 75 |
1782140 | 1782140 | 2021-10-04 | Dickinson | Michigan | 26043 | 3642 | 75 |
1770666 | 1770666 | 2021-09-30 | Milam | Texas | 48331 | 3642 | 73 |
1767417 | 1767417 | 2021-09-29 | Milam | Texas | 48331 | 3642 | 72 |
1764168 | 1764168 | 2021-09-28 | Milam | Texas | 48331 | 3642 | 71 |
1748561 | 1748561 | 2021-09-24 | Sevier | Arkansas | 5133 | 3642 | 32 |
1744592 | 1744592 | 2021-09-22 | Frio | Texas | 48163 | 3642 | 65 |
1713739 | 1713739 | 2021-09-13 | Ohio | Kentucky | 21183 | 3642 | 62 |
1715736 | 1715736 | 2021-09-13 | Stevens | Washington | 53065 | 3642 | 47 |
1699013 | 1699013 | 2021-09-08 | Smith | Tennessee | 47159 | 3642 | 42 |
1671501 | 1671501 | 2021-08-31 | Montgomery | Kentucky | 21173 | 3642 | 35 |
1644576 | 1644576 | 2021-08-23 | Jackson | Arkansas | 5067 | 3642 | 41 |
1634828 | 1634828 | 2021-08-20 | Johnson | Arkansas | 5071 | 3642 | 43 |
1591905 | 1591905 | 2021-08-06 | Fannin | Texas | 48147 | 3642 | 110 |
1546994 | 1546994 | 2021-07-24 | Clarke | Alabama | 1025 | 3642 | 62 |
1539335 | 1539335 | 2021-07-21 | Highland | Ohio | 39071 | 3642 | 68 |
1493150 | 1493150 | 2021-07-07 | Lyon | Minnesota | 27083 | 3642 | 54 |
1489903 | 1489903 | 2021-07-06 | Lyon | Minnesota | 27083 | 3642 | 54 |
1486656 | 1486656 | 2021-07-05 | Lyon | Minnesota | 27083 | 3642 | 54 |
1483410 | 1483410 | 2021-07-04 | Lyon | Minnesota | 27083 | 3642 | 54 |
1480164 | 1480164 | 2021-07-03 | Lyon | Minnesota | 27083 | 3642 | 54 |
1476917 | 1476917 | 2021-07-02 | Lyon | Minnesota | 27083 | 3642 | 54 |
1473671 | 1473671 | 2021-07-01 | Lyon | Minnesota | 27083 | 3642 | 54 |
1458320 | 1458320 | 2021-06-26 | Josephine | Oregon | 41033 | 3642 | 72 |
1427409 | 1427409 | 2021-06-17 | Wayne | Georgia | 13305 | 3642 | 91 |
1426645 | 1426645 | 2021-06-16 | Prince George | Virginia | 51149 | 3642 | 32 |
1418689 | 1418689 | 2021-06-14 | Marion | Missouri | 29127 | 3642 | 53 |
1415444 | 1415444 | 2021-06-13 | Marion | Missouri | 29127 | 3642 | 53 |
1412198 | 1412198 | 2021-06-12 | Marion | Missouri | 29127 | 3642 | 53 |
1408953 | 1408953 | 2021-06-11 | Marion | Missouri | 29127 | 3642 | 53 |
1395971 | 1395971 | 2021-06-07 | Marion | Missouri | 29127 | 3642 | 52 |
1374272 | 1374272 | 2021-05-31 | Macon | Tennessee | 47111 | 3642 | 78 |
1371027 | 1371027 | 2021-05-30 | Macon | Tennessee | 47111 | 3642 | 78 |
1371621 | 1371621 | 2021-05-30 | Green | Wisconsin | 55045 | 3642 | 25 |
1367781 | 1367781 | 2021-05-29 | Macon | Tennessee | 47111 | 3642 | 78 |
1368375 | 1368375 | 2021-05-29 | Green | Wisconsin | 55045 | 3642 | 25 |
1364535 | 1364535 | 2021-05-28 | Macon | Tennessee | 47111 | 3642 | 78 |
1365129 | 1365129 | 2021-05-28 | Green | Wisconsin | 55045 | 3642 | 25 |
1361883 | 1361883 | 2021-05-27 | Green | Wisconsin | 55045 | 3642 | 25 |
1353075 | 1353075 | 2021-05-25 | Marion | Iowa | 19125 | 3642 | 76 |
1335269 | 1335269 | 2021-05-19 | Carroll | Tennessee | 47017 | 3642 | 83 |
1323764 | 1323764 | 2021-05-16 | Putnam | Indiana | 18133 | 3642 | 60 |
1294515 | 1294515 | 2021-05-07 | Jasper | Indiana | 18073 | 3642 | 49 |
1286290 | 1286290 | 2021-05-04 | Polk | Oregon | 41053 | 3642 | 52 |
1258250 | 1258250 | 2021-04-26 | Amador | California | 6005 | 3642 | 47 |
1235986 | 1235986 | 2021-04-19 | Logan | Illinois | 17107 | 3642 | 69 |
1236000 | 1236000 | 2021-04-19 | Montgomery | Illinois | 17135 | 3642 | 79 |
1237720 | 1237720 | 2021-04-19 | Ponce | Puerto Rico | 72113 | 3642 |
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);