ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where cases = 3221 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Michigan 11
- Arkansas 9
- Iowa 8
- Wisconsin 6
- Idaho 5
- Mississippi 5
- Texas 5
- Vermont 5
- Virginia 5
- Illinois 4
- Kentucky 4
- Maryland 4
- Minnesota 4
- Missouri 4
- Puerto Rico 4
- Virgin Islands 4
- New York 3
- South Dakota 3
- West Virginia 3
- Alabama 2
- Colorado 2
- North Carolina 2
- North Dakota 2
- Oregon 2
- Pennsylvania 2
- Arizona 1
- California 1
- Florida 1
- Indiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485103 | 2485103 | 2022-05-08 | Unknown | New Jersey | 3221 | 0 | |
2401573 | 2401573 | 2022-04-12 | Brunswick | Virginia | 51025 | 3221 | 47 |
2392614 | 2392614 | 2022-04-10 | Oglethorpe | Georgia | 13221 | 3221 | 55 |
2389358 | 2389358 | 2022-04-09 | Oglethorpe | Georgia | 13221 | 3221 | 55 |
2386103 | 2386103 | 2022-04-08 | Oglethorpe | Georgia | 13221 | 3221 | 55 |
2296924 | 2296924 | 2022-03-11 | Utuado | Puerto Rico | 72141 | 3221 | |
2287818 | 2287818 | 2022-03-08 | Westmoreland | Virginia | 51193 | 3221 | 49 |
2247476 | 2247476 | 2022-02-24 | Otoe | Nebraska | 31131 | 3221 | 17 |
2244875 | 2244875 | 2022-02-23 | Naguabo | Puerto Rico | 72103 | 3221 | |
2241270 | 2241270 | 2022-02-22 | McKenzie | North Dakota | 38053 | 3221 | 25 |
2241624 | 2241624 | 2022-02-22 | Naguabo | Puerto Rico | 72103 | 3221 | |
2242444 | 2242444 | 2022-02-22 | Price | Wisconsin | 55099 | 3221 | 29 |
2238019 | 2238019 | 2022-02-21 | McKenzie | North Dakota | 38053 | 3221 | 25 |
2238373 | 2238373 | 2022-02-21 | Naguabo | Puerto Rico | 72103 | 3221 | |
2194558 | 2194558 | 2022-02-08 | Jefferson | Iowa | 19101 | 3221 | 50 |
2191304 | 2191304 | 2022-02-07 | Jefferson | Iowa | 19101 | 3221 | 50 |
2188051 | 2188051 | 2022-02-06 | Jefferson | Iowa | 19101 | 3221 | 50 |
2184798 | 2184798 | 2022-02-05 | Jefferson | Iowa | 19101 | 3221 | 50 |
2181546 | 2181546 | 2022-02-04 | Jefferson | Iowa | 19101 | 3221 | 50 |
2178295 | 2178295 | 2022-02-03 | Jefferson | Iowa | 19101 | 3221 | 50 |
2175042 | 2175042 | 2022-02-02 | Jefferson | Iowa | 19101 | 3221 | 50 |
2138255 | 2138255 | 2022-01-21 | Braxton | West Virginia | 54007 | 3221 | 33 |
2125118 | 2125118 | 2022-01-17 | Greene | Virginia | 51079 | 3221 | 47 |
2109023 | 2109023 | 2022-01-12 | Taylor | West Virginia | 54091 | 3221 | 55 |
2105788 | 2105788 | 2022-01-11 | Burnett | Wisconsin | 55013 | 3221 | 36 |
2098651 | 2098651 | 2022-01-09 | Union | South Dakota | 46127 | 3221 | 47 |
2095399 | 2095399 | 2022-01-08 | Union | South Dakota | 46127 | 3221 | 47 |
2092147 | 2092147 | 2022-01-07 | Union | South Dakota | 46127 | 3221 | 47 |
2084218 | 2084218 | 2022-01-05 | Powell | Kentucky | 21197 | 3221 | 28 |
2085412 | 2085412 | 2022-01-05 | Fulton | Pennsylvania | 42057 | 3221 | 51 |
2080955 | 2080955 | 2022-01-04 | Morgan | Kentucky | 21175 | 3221 | 17 |
2076275 | 2076275 | 2022-01-02 | Caledonia | Vermont | 50005 | 3221 | 21 |
2073024 | 2073024 | 2022-01-01 | Caledonia | Vermont | 50005 | 3221 | 21 |
2069773 | 2069773 | 2021-12-31 | Caledonia | Vermont | 50005 | 3221 | 21 |
2066522 | 2066522 | 2021-12-30 | Caledonia | Vermont | 50005 | 3221 | 21 |
2036253 | 2036253 | 2021-12-21 | Schoharie | New York | 36095 | 3221 | 29 |
2015289 | 2015289 | 2021-12-15 | Crisp | Georgia | 13081 | 3221 | 118 |
2002032 | 2002032 | 2021-12-11 | Sharp | Arkansas | 5135 | 3221 | 73 |
1997617 | 1997617 | 2021-12-09 | Wasco | Oregon | 41065 | 3221 | 47 |
1956461 | 1956461 | 2021-11-27 | Ashley | Arkansas | 5003 | 3221 | 49 |
1953210 | 1953210 | 2021-11-26 | Ashley | Arkansas | 5003 | 3221 | 49 |
1949959 | 1949959 | 2021-11-25 | Ashley | Arkansas | 5003 | 3221 | 49 |
1923512 | 1923512 | 2021-11-16 | Orleans | Vermont | 50019 | 3221 | 20 |
1899156 | 1899156 | 2021-11-09 | Osceola | Michigan | 26133 | 3221 | 43 |
1895906 | 1895906 | 2021-11-08 | Osceola | Michigan | 26133 | 3221 | 43 |
1874774 | 1874774 | 2021-11-01 | St. Croix | Virgin Islands | 78010 | 3221 | 32 |
1875037 | 1875037 | 2021-11-01 | Langlade | Wisconsin | 55067 | 3221 | 56 |
1871525 | 1871525 | 2021-10-31 | St. Croix | Virgin Islands | 78010 | 3221 | 32 |
1866561 | 1866561 | 2021-10-30 | Caroline | Maryland | 24011 | 3221 | 51 |
1868276 | 1868276 | 2021-10-30 | St. Croix | Virgin Islands | 78010 | 3221 | 32 |
1863318 | 1863318 | 2021-10-29 | Garrett | Maryland | 24023 | 3221 | 79 |
1865027 | 1865027 | 2021-10-29 | St. Croix | Virgin Islands | 78010 | 3221 | 32 |
1865215 | 1865215 | 2021-10-29 | Hampshire | West Virginia | 54027 | 3221 | 49 |
1852863 | 1852863 | 2021-10-26 | Putnam | Georgia | 13237 | 3221 | 81 |
1849614 | 1849614 | 2021-10-25 | Putnam | Georgia | 13237 | 3221 | 80 |
1846256 | 1846256 | 2021-10-24 | Ben Hill | Georgia | 13017 | 3221 | 101 |
1843006 | 1843006 | 2021-10-23 | Ben Hill | Georgia | 13017 | 3221 | 101 |
1839756 | 1839756 | 2021-10-22 | Ben Hill | Georgia | 13017 | 3221 | 101 |
1790627 | 1790627 | 2021-10-07 | Butler | Alabama | 1013 | 3221 | 93 |
1762065 | 1762065 | 2021-09-28 | Shelby | Illinois | 17173 | 3221 | 46 |
1699816 | 1699816 | 2021-09-09 | Ouachita | Arkansas | 5103 | 3221 | 68 |
1680279 | 1680279 | 2021-09-03 | Cleburne | Arkansas | 5023 | 3221 | 82 |
1681682 | 1681682 | 2021-09-03 | Crawford | Missouri | 29055 | 3221 | 45 |
1667629 | 1667629 | 2021-08-30 | Harris | Georgia | 13145 | 3221 | 67 |
1655395 | 1655395 | 2021-08-26 | Queen Anne's | Maryland | 24035 | 3221 | 57 |
1651189 | 1651189 | 2021-08-25 | Delta | Colorado | 8029 | 3221 | 76 |
1626211 | 1626211 | 2021-08-17 | Houghton | Michigan | 26061 | 3221 | 43 |
1626819 | 1626819 | 2021-08-17 | Orleans | New York | 36073 | 3221 | 83 |
1622964 | 1622964 | 2021-08-16 | Houghton | Michigan | 26061 | 3221 | 43 |
1564779 | 1564779 | 2021-07-29 | McDonald | Missouri | 29119 | 3221 | 40 |
1511846 | 1511846 | 2021-07-13 | Latah | Idaho | 16057 | 3221 | 12 |
1511934 | 1511934 | 2021-07-13 | Perry | Illinois | 17145 | 3221 | 69 |
1508599 | 1508599 | 2021-07-12 | Latah | Idaho | 16057 | 3221 | 12 |
1509309 | 1509309 | 2021-07-12 | Mecosta | Michigan | 26107 | 3221 | 37 |
1506063 | 1506063 | 2021-07-11 | Mecosta | Michigan | 26107 | 3221 | 37 |
1502817 | 1502817 | 2021-07-10 | Mecosta | Michigan | 26107 | 3221 | 37 |
1499571 | 1499571 | 2021-07-09 | Mecosta | Michigan | 26107 | 3221 | 37 |
1473855 | 1473855 | 2021-07-01 | Lafayette | Missouri | 29107 | 3221 | 57 |
1421000 | 1421000 | 2021-06-15 | Fayette | Illinois | 17051 | 3221 | 58 |
1412245 | 1412245 | 2021-06-12 | Warren | Missouri | 29219 | 3221 | 33 |
1402011 | 1402011 | 2021-06-09 | Taylor | Kentucky | 21217 | 3221 | 52 |
1402555 | 1402555 | 2021-06-09 | Ravalli | Montana | 30081 | 3221 | 46 |
1399884 | 1399884 | 2021-06-08 | Benton | Oregon | 41003 | 3221 | 22 |
1382576 | 1382576 | 2021-06-03 | Jefferson Davis | Louisiana | 22053 | 3221 | 97 |
1349516 | 1349516 | 2021-05-24 | White | Georgia | 13311 | 3221 | 80 |
1338547 | 1338547 | 2021-05-20 | Henry | Tennessee | 47079 | 3221 | 76 |
1339036 | 1339036 | 2021-05-20 | Wise | Virginia | 51195 | 3221 | 99 |
1287427 | 1287427 | 2021-05-05 | Jackson | Arkansas | 5067 | 3221 | 38 |
1278108 | 1278108 | 2021-05-02 | Bonner | Idaho | 16017 | 3221 | 43 |
1274861 | 1274861 | 2021-05-01 | Bonner | Idaho | 16017 | 3221 | 43 |
1271614 | 1271614 | 2021-04-30 | Bonner | Idaho | 16017 | 3221 | 43 |
1251073 | 1251073 | 2021-04-23 | Kendall | Texas | 48259 | 3221 | 72 |
1243709 | 1243709 | 2021-04-21 | Otsego | New York | 36077 | 3221 | 47 |
1207437 | 1207437 | 2021-04-10 | Carlton | Minnesota | 27017 | 3221 | 52 |
1204337 | 1204337 | 2021-04-09 | Tate | Mississippi | 28137 | 3221 | 81 |
1179183 | 1179183 | 2021-04-01 | Perry | Pennsylvania | 42099 | 3221 | 89 |
1159214 | 1159214 | 2021-03-26 | Luna | New Mexico | 35029 | 3221 | 84 |
1145726 | 1145726 | 2021-03-22 | Becker | Minnesota | 27005 | 3221 | 47 |
1142413 | 1142413 | 2021-03-21 | Delta | Michigan | 26041 | 3221 | 85 |
1139166 | 1139166 | 2021-03-20 | Delta | Michigan | 26041 | 3221 | 85 |
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);