ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
249 rows where cases = 2527 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 32
- Georgia 21
- Texas 19
- Kentucky 18
- South Dakota 18
- Missouri 11
- Puerto Rico 11
- Mississippi 10
- Illinois 9
- Ohio 9
- North Carolina 8
- Michigan 7
- Minnesota 7
- Indiana 5
- West Virginia 5
- Wisconsin 5
- Louisiana 4
- Nebraska 4
- New Hampshire 4
- Arkansas 3
- California 3
- Florida 3
- Kansas 3
- Alabama 2
- Iowa 2
- Maryland 2
- Nevada 2
- New York 2
- Oklahoma 2
- Oregon 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499120 | 2499120 | 2022-05-12 | Morris | Texas | 48343 | 2527 | 73 |
2495457 | 2495457 | 2022-05-11 | Rincon | Puerto Rico | 72117 | 2527 | |
2496016 | 2496016 | 2022-05-11 | Charlotte | Virginia | 51037 | 2527 | 45 |
2438818 | 2438818 | 2022-04-24 | Wolfe | Kentucky | 21237 | 2527 | 25 |
2435562 | 2435562 | 2022-04-23 | Wolfe | Kentucky | 21237 | 2527 | 25 |
2432306 | 2432306 | 2022-04-22 | Wolfe | Kentucky | 21237 | 2527 | 25 |
2429050 | 2429050 | 2022-04-21 | Wolfe | Kentucky | 21237 | 2527 | 25 |
2425794 | 2425794 | 2022-04-20 | Wolfe | Kentucky | 21237 | 2527 | 25 |
2422538 | 2422538 | 2022-04-19 | Wolfe | Kentucky | 21237 | 2527 | 25 |
2419282 | 2419282 | 2022-04-18 | Wolfe | Kentucky | 21237 | 2527 | 25 |
2379344 | 2379344 | 2022-04-06 | Bent | Colorado | 8011 | 2527 | 47 |
2380510 | 2380510 | 2022-04-06 | Yellow Medicine | Minnesota | 27173 | 2527 | 29 |
2368485 | 2368485 | 2022-04-02 | Santa Isabel | Puerto Rico | 72133 | 2527 | |
2355712 | 2355712 | 2022-03-29 | Blanco | Texas | 48031 | 2527 | 34 |
2281228 | 2281228 | 2022-03-06 | Floyd | Virginia | 51063 | 2527 | 45 |
2277975 | 2277975 | 2022-03-05 | Floyd | Virginia | 51063 | 2527 | 45 |
2274722 | 2274722 | 2022-03-04 | Floyd | Virginia | 51063 | 2527 | 45 |
2257024 | 2257024 | 2022-02-27 | Douglas | Missouri | 29067 | 2527 | 75 |
2253773 | 2253773 | 2022-02-26 | Douglas | Missouri | 29067 | 2527 | 75 |
2250522 | 2250522 | 2022-02-25 | Douglas | Missouri | 29067 | 2527 | 75 |
2247774 | 2247774 | 2022-02-24 | Mercer | North Dakota | 38057 | 2527 | 24 |
2233496 | 2233496 | 2022-02-20 | Newton | Indiana | 18111 | 2527 | 68 |
2230245 | 2230245 | 2022-02-19 | Newton | Indiana | 18111 | 2527 | 68 |
2226994 | 2226994 | 2022-02-18 | Newton | Indiana | 18111 | 2527 | 68 |
2214653 | 2214653 | 2022-02-14 | Carroll | Mississippi | 28015 | 2527 | 49 |
2201301 | 2201301 | 2022-02-10 | McLean | Kentucky | 21149 | 2527 | 44 |
2143106 | 2143106 | 2022-01-23 | Jefferson Davis | Mississippi | 28065 | 2527 | 43 |
2139851 | 2139851 | 2022-01-22 | Jefferson Davis | Mississippi | 28065 | 2527 | 43 |
2139920 | 2139920 | 2022-01-22 | Cedar | Missouri | 29039 | 2527 | 43 |
2136595 | 2136595 | 2022-01-21 | Jefferson Davis | Mississippi | 28065 | 2527 | 43 |
2135040 | 2135040 | 2022-01-20 | Roane | West Virginia | 54087 | 2527 | 30 |
2120642 | 2120642 | 2022-01-16 | Unknown | Nebraska | 2527 | 331 | |
2117390 | 2117390 | 2022-01-15 | Unknown | Nebraska | 2527 | 331 | |
2114139 | 2114139 | 2022-01-14 | Unknown | Nebraska | 2527 | 331 | |
2087714 | 2087714 | 2022-01-06 | Cottonwood | Minnesota | 27033 | 2527 | 34 |
2085009 | 2085009 | 2022-01-05 | Schuyler | New York | 36097 | 2527 | 23 |
2085214 | 2085214 | 2022-01-05 | Harrison | Ohio | 39067 | 2527 | 60 |
2074646 | 2074646 | 2022-01-02 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2071395 | 2071395 | 2022-01-01 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2072478 | 2072478 | 2022-01-01 | Hatillo | Puerto Rico | 72065 | 2527 | |
2068144 | 2068144 | 2021-12-31 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2069227 | 2069227 | 2021-12-31 | Hatillo | Puerto Rico | 72065 | 2527 | |
2064893 | 2064893 | 2021-12-30 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2061643 | 2061643 | 2021-12-29 | Kalkaska | Michigan | 26079 | 2527 | 48 |
2059091 | 2059091 | 2021-12-28 | Polk | North Carolina | 37149 | 2527 | 49 |
2053466 | 2053466 | 2021-12-26 | Tyler | Texas | 48457 | 2527 | 72 |
2050216 | 2050216 | 2021-12-25 | Tyler | Texas | 48457 | 2527 | 72 |
2046488 | 2046488 | 2021-12-24 | Las Piedras | Puerto Rico | 72085 | 2527 | |
2046966 | 2046966 | 2021-12-24 | Tyler | Texas | 48457 | 2527 | 72 |
2043238 | 2043238 | 2021-12-23 | Las Piedras | Puerto Rico | 72085 | 2527 | |
2043716 | 2043716 | 2021-12-23 | Tyler | Texas | 48457 | 2527 | 72 |
2039996 | 2039996 | 2021-12-22 | Moca | Puerto Rico | 72099 | 2527 | |
2037342 | 2037342 | 2021-12-21 | Grayson | Virginia | 51077 | 2527 | 56 |
2012695 | 2012695 | 2021-12-14 | Monroe | Kentucky | 21171 | 2527 | 66 |
1975809 | 1975809 | 2021-12-02 | Richland | Wisconsin | 55103 | 2527 | 31 |
1967164 | 1967164 | 2021-11-30 | Knott | Kentucky | 21119 | 2527 | 43 |
1963869 | 1963869 | 2021-11-29 | Caldwell | Kentucky | 21033 | 2527 | 51 |
1963969 | 1963969 | 2021-11-29 | Webster | Kentucky | 21233 | 2527 | 42 |
1929006 | 1929006 | 2021-11-18 | Bertie | North Carolina | 37015 | 2527 | 53 |
1924514 | 1924514 | 2021-11-17 | Moultrie | Illinois | 17139 | 2527 | 41 |
1927009 | 1927009 | 2021-11-17 | Crawford | Wisconsin | 55023 | 2527 | 23 |
1919743 | 1919743 | 2021-11-15 | San Sebastian | Puerto Rico | 72131 | 2527 | |
1920223 | 1920223 | 2021-11-15 | Zavala | Texas | 48507 | 2527 | 55 |
1916493 | 1916493 | 2021-11-14 | San Sebastian | Puerto Rico | 72131 | 2527 | |
1916973 | 1916973 | 2021-11-14 | Zavala | Texas | 48507 | 2527 | 55 |
1913723 | 1913723 | 2021-11-13 | Zavala | Texas | 48507 | 2527 | 55 |
1910473 | 1910473 | 2021-11-12 | Zavala | Texas | 48507 | 2527 | 55 |
1905042 | 1905042 | 2021-11-11 | Warren | Illinois | 17187 | 2527 | 71 |
1901792 | 1901792 | 2021-11-10 | Warren | Illinois | 17187 | 2527 | 71 |
1873258 | 1873258 | 2021-11-01 | Wadena | Minnesota | 27159 | 2527 | 29 |
1866933 | 1866933 | 2021-10-30 | Pike | Missouri | 29163 | 2527 | 37 |
1838777 | 1838777 | 2021-10-21 | Colorado | Texas | 48089 | 2527 | 51 |
1807472 | 1807472 | 2021-10-12 | Bond | Illinois | 17005 | 2527 | 30 |
1806143 | 1806143 | 2021-10-11 | Union | South Dakota | 46127 | 2527 | 44 |
1806848 | 1806848 | 2021-10-11 | Carbon | Wyoming | 56007 | 2527 | 36 |
1802893 | 1802893 | 2021-10-10 | Union | South Dakota | 46127 | 2527 | 44 |
1799644 | 1799644 | 2021-10-09 | Union | South Dakota | 46127 | 2527 | 44 |
1795437 | 1795437 | 2021-10-08 | Moniteau | Missouri | 29135 | 2527 | 38 |
1796238 | 1796238 | 2021-10-08 | Isabela | Puerto Rico | 72071 | 2527 | |
1796395 | 1796395 | 2021-10-08 | Union | South Dakota | 46127 | 2527 | 44 |
1788085 | 1788085 | 2021-10-06 | Carroll | Indiana | 18015 | 2527 | 33 |
1762725 | 1762725 | 2021-09-28 | Dodge | Minnesota | 27039 | 2527 | 5 |
1763639 | 1763639 | 2021-09-28 | Wasco | Oregon | 41065 | 2527 | 39 |
1746159 | 1746159 | 2021-09-23 | Casey | Kentucky | 21045 | 2527 | 50 |
1747434 | 1747434 | 2021-09-23 | Juniata | Pennsylvania | 42067 | 2527 | 101 |
1742652 | 1742652 | 2021-09-22 | Perry | Indiana | 18123 | 2527 | 54 |
1722566 | 1722566 | 2021-09-16 | Sharp | Arkansas | 5135 | 2527 | 60 |
1713795 | 1713795 | 2021-09-13 | LaSalle | Louisiana | 22059 | 2527 | 41 |
1697777 | 1697777 | 2021-09-08 | Martin | Minnesota | 27091 | 2527 | 33 |
1699508 | 1699508 | 2021-09-08 | Brooke | West Virginia | 54009 | 2527 | 62 |
1688157 | 1688157 | 2021-09-05 | Andrew | Missouri | 29003 | 2527 | 23 |
1682309 | 1682309 | 2021-09-03 | Wyandot | Ohio | 39175 | 2527 | 57 |
1678675 | 1678675 | 2021-09-02 | Churchill | Nevada | 32001 | 2527 | 50 |
1680062 | 1680062 | 2021-09-02 | Wyoming | West Virginia | 54109 | 2527 | 41 |
1670204 | 1670204 | 2021-08-30 | Salem city | Virginia | 51775 | 2527 | 50 |
1634830 | 1634830 | 2021-08-20 | Lawrence | Arkansas | 5075 | 2527 | 43 |
1618952 | 1618952 | 2021-08-15 | Putnam | Georgia | 13237 | 2527 | 62 |
1615704 | 1615704 | 2021-08-14 | Putnam | Georgia | 13237 | 2527 | 62 |
1612455 | 1612455 | 2021-08-13 | Putnam | Georgia | 13237 | 2527 | 62 |
1606102 | 1606102 | 2021-08-11 | Lawrence | Illinois | 17101 | 2527 | 36 |
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);