ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
149 rows where cases = 3616 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 31
- Texas 17
- Georgia 13
- Indiana 7
- Alabama 6
- Maine 6
- Michigan 5
- Minnesota 5
- Missouri 5
- Pennsylvania 5
- West Virginia 5
- Tennessee 4
- Arkansas 3
- California 3
- Colorado 3
- Illinois 3
- Ohio 3
- Oklahoma 3
- Puerto Rico 3
- Louisiana 2
- Maryland 2
- New York 2
- North Dakota 2
- Virginia 2
- Florida 1
- Iowa 1
- Massachusetts 1
- Mississippi 1
- New Jersey 1
- North Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483567 | 2483567 | 2022-05-08 | Las Animas | Colorado | 8071 | 3616 | 43 |
2480309 | 2480309 | 2022-05-07 | Las Animas | Colorado | 8071 | 3616 | 43 |
2477051 | 2477051 | 2022-05-06 | Las Animas | Colorado | 8071 | 3616 | 43 |
2462903 | 2462903 | 2022-05-01 | Villalba | Puerto Rico | 72149 | 3616 | |
2448096 | 2448096 | 2022-04-27 | Greene | Illinois | 17061 | 3616 | 58 |
2415993 | 2415993 | 2022-04-17 | Monroe | Kentucky | 21171 | 3616 | 76 |
2412737 | 2412737 | 2022-04-16 | Monroe | Kentucky | 21171 | 3616 | 76 |
2409481 | 2409481 | 2022-04-15 | Monroe | Kentucky | 21171 | 3616 | 76 |
2406225 | 2406225 | 2022-04-14 | Monroe | Kentucky | 21171 | 3616 | 76 |
2402969 | 2402969 | 2022-04-13 | Monroe | Kentucky | 21171 | 3616 | 76 |
2399715 | 2399715 | 2022-04-12 | Monroe | Kentucky | 21171 | 3616 | 76 |
2396459 | 2396459 | 2022-04-11 | Monroe | Kentucky | 21171 | 3616 | 76 |
2393204 | 2393204 | 2022-04-10 | Monroe | Kentucky | 21171 | 3616 | 76 |
2389948 | 2389948 | 2022-04-09 | Monroe | Kentucky | 21171 | 3616 | 76 |
2386692 | 2386692 | 2022-04-08 | Monroe | Kentucky | 21171 | 3616 | 76 |
2383437 | 2383437 | 2022-04-07 | Monroe | Kentucky | 21171 | 3616 | 76 |
2380182 | 2380182 | 2022-04-06 | Monroe | Kentucky | 21171 | 3616 | 76 |
2376927 | 2376927 | 2022-04-05 | Monroe | Kentucky | 21171 | 3616 | 76 |
2373675 | 2373675 | 2022-04-04 | Monroe | Kentucky | 21171 | 3616 | 76 |
2370422 | 2370422 | 2022-04-03 | Monroe | Kentucky | 21171 | 3616 | 76 |
2367169 | 2367169 | 2022-04-02 | Monroe | Kentucky | 21171 | 3616 | 76 |
2363916 | 2363916 | 2022-04-01 | Monroe | Kentucky | 21171 | 3616 | 76 |
2360662 | 2360662 | 2022-03-31 | Monroe | Kentucky | 21171 | 3616 | 76 |
2357408 | 2357408 | 2022-03-30 | Monroe | Kentucky | 21171 | 3616 | 76 |
2354155 | 2354155 | 2022-03-29 | Monroe | Kentucky | 21171 | 3616 | 76 |
2350903 | 2350903 | 2022-03-28 | Monroe | Kentucky | 21171 | 3616 | 76 |
2309084 | 2309084 | 2022-03-15 | Macon | Missouri | 29121 | 3616 | 52 |
2274127 | 2274127 | 2022-03-04 | Lares | Puerto Rico | 72081 | 3616 | |
2263387 | 2263387 | 2022-03-01 | Renville | Minnesota | 27129 | 3616 | 56 |
2256529 | 2256529 | 2022-02-27 | Fleming | Kentucky | 21069 | 3616 | 44 |
2253278 | 2253278 | 2022-02-26 | Fleming | Kentucky | 21069 | 3616 | 44 |
2250027 | 2250027 | 2022-02-25 | Fleming | Kentucky | 21069 | 3616 | 44 |
2240123 | 2240123 | 2022-02-22 | Unknown | Iowa | 3616 | 0 | |
2236458 | 2236458 | 2022-02-21 | Jefferson | Georgia | 13163 | 3616 | 105 |
2228905 | 2228905 | 2022-02-18 | Colorado | Texas | 48089 | 3616 | 58 |
2193238 | 2193238 | 2022-02-07 | Madison | Texas | 48313 | 3616 | 50 |
2187971 | 2187971 | 2022-02-06 | Pike | Indiana | 18125 | 3616 | 48 |
2184718 | 2184718 | 2022-02-05 | Pike | Indiana | 18125 | 3616 | 48 |
2181466 | 2181466 | 2022-02-04 | Pike | Indiana | 18125 | 3616 | 48 |
2172333 | 2172333 | 2022-02-01 | Redwood | Minnesota | 27127 | 3616 | 51 |
2140741 | 2140741 | 2022-01-22 | Aguas Buenas | Puerto Rico | 72007 | 3616 | |
2087051 | 2087051 | 2022-01-06 | Richland | Illinois | 17159 | 3616 | 76 |
2077815 | 2077815 | 2022-01-03 | Waldo | Maine | 23027 | 3616 | 38 |
2074564 | 2074564 | 2022-01-02 | Waldo | Maine | 23027 | 3616 | 38 |
2070166 | 2070166 | 2022-01-01 | Randolph | Alabama | 1111 | 3616 | 67 |
2071313 | 2071313 | 2022-01-01 | Waldo | Maine | 23027 | 3616 | 38 |
2066915 | 2066915 | 2021-12-31 | Randolph | Alabama | 1111 | 3616 | 67 |
2068062 | 2068062 | 2021-12-31 | Waldo | Maine | 23027 | 3616 | 38 |
2041337 | 2041337 | 2021-12-23 | Jones | Georgia | 13169 | 3616 | 99 |
2039191 | 2039191 | 2021-12-22 | Perry | Missouri | 29157 | 3616 | 40 |
2030548 | 2030548 | 2021-12-19 | Deaf Smith | Texas | 48117 | 3616 | 89 |
2030696 | 2030696 | 2021-12-19 | Scurry | Texas | 48415 | 3616 | 87 |
2027445 | 2027445 | 2021-12-18 | Scurry | Texas | 48415 | 3616 | 87 |
1990130 | 1990130 | 2021-12-07 | Iosco | Michigan | 26069 | 3616 | 105 |
1986880 | 1986880 | 2021-12-06 | Iosco | Michigan | 26069 | 3616 | 105 |
1962396 | 1962396 | 2021-11-28 | Moore | Texas | 48341 | 3616 | 88 |
1959145 | 1959145 | 2021-11-27 | Moore | Texas | 48341 | 3616 | 88 |
1955894 | 1955894 | 2021-11-26 | Moore | Texas | 48341 | 3616 | 88 |
1952643 | 1952643 | 2021-11-25 | Moore | Texas | 48341 | 3616 | 88 |
1949392 | 1949392 | 2021-11-24 | Moore | Texas | 48341 | 3616 | 88 |
1946141 | 1946141 | 2021-11-23 | Moore | Texas | 48341 | 3616 | 88 |
1920044 | 1920044 | 2021-11-15 | Fayette | Texas | 48149 | 3616 | 93 |
1916794 | 1916794 | 2021-11-14 | Fayette | Texas | 48149 | 3616 | 93 |
1898273 | 1898273 | 2021-11-09 | Cook | Georgia | 13075 | 3616 | 63 |
1881269 | 1881269 | 2021-11-03 | Washington | Vermont | 50023 | 3616 | 27 |
1856040 | 1856040 | 2021-10-27 | Dodge | Georgia | 13091 | 3616 | 126 |
1848989 | 1848989 | 2021-10-24 | Nicholas | West Virginia | 54067 | 3616 | 44 |
1785398 | 1785398 | 2021-10-05 | Houghton | Michigan | 26061 | 3616 | 52 |
1782149 | 1782149 | 2021-10-04 | Houghton | Michigan | 26061 | 3616 | 52 |
1784022 | 1784022 | 2021-10-04 | Upshur | West Virginia | 54097 | 3616 | 56 |
1771275 | 1771275 | 2021-10-01 | Lincoln | Arkansas | 5079 | 3616 | 55 |
1768026 | 1768026 | 2021-09-30 | Lincoln | Arkansas | 5079 | 3616 | 55 |
1768321 | 1768321 | 2021-09-30 | Fannin | Georgia | 13111 | 3616 | 98 |
1763466 | 1763466 | 2021-09-28 | Gallia | Ohio | 39053 | 3616 | 58 |
1760038 | 1760038 | 2021-09-27 | Anson | North Carolina | 37007 | 3616 | 71 |
1723855 | 1723855 | 2021-09-16 | Newton | Mississippi | 28101 | 3616 | 74 |
1719589 | 1719589 | 2021-09-15 | Franklin | Georgia | 13119 | 3616 | 64 |
1713168 | 1713168 | 2021-09-13 | Tattnall | Georgia | 13267 | 3616 | 90 |
1675046 | 1675046 | 2021-09-01 | Pine | Minnesota | 27115 | 3616 | 23 |
1671976 | 1671976 | 2021-08-31 | McDonald | Missouri | 29119 | 3616 | 50 |
1672708 | 1672708 | 2021-08-31 | Greene | Pennsylvania | 42059 | 3616 | 43 |
1636733 | 1636733 | 2021-08-20 | Stutsman | North Dakota | 38093 | 3616 | 82 |
1632504 | 1632504 | 2021-08-19 | Logan | Kentucky | 21141 | 3616 | 74 |
1633483 | 1633483 | 2021-08-19 | Stutsman | North Dakota | 38093 | 3616 | 82 |
1585158 | 1585158 | 2021-08-04 | Marlboro | South Carolina | 45069 | 3616 | 61 |
1585406 | 1585406 | 2021-08-04 | Fannin | Texas | 48147 | 3616 | 109 |
1562532 | 1562532 | 2021-07-28 | Hardeman | Tennessee | 47069 | 3616 | 64 |
1559829 | 1559829 | 2021-07-27 | Fayette | West Virginia | 54019 | 3616 | 82 |
1555377 | 1555377 | 2021-07-26 | Wyoming | New York | 36121 | 3616 | 53 |
1551264 | 1551264 | 2021-07-25 | Floyd | Kentucky | 21071 | 3616 | 74 |
1552130 | 1552130 | 2021-07-25 | Wyoming | New York | 36121 | 3616 | 53 |
1548017 | 1548017 | 2021-07-24 | Floyd | Kentucky | 21071 | 3616 | 74 |
1544770 | 1544770 | 2021-07-23 | Floyd | Kentucky | 21071 | 3616 | 74 |
1457619 | 1457619 | 2021-06-26 | Howell | Missouri | 29091 | 3616 | 45 |
1408587 | 1408587 | 2021-06-11 | Oxford | Maine | 23017 | 3616 | 66 |
1405341 | 1405341 | 2021-06-10 | Oxford | Maine | 23017 | 3616 | 66 |
1337207 | 1337207 | 2021-05-20 | Worcester | Maryland | 24047 | 3616 | 99 |
1332742 | 1332742 | 2021-05-19 | Chambers | Alabama | 1017 | 3616 | 123 |
1330854 | 1330854 | 2021-05-18 | Lyon | Minnesota | 27083 | 3616 | 51 |
1322065 | 1322065 | 2021-05-15 | Snyder | Pennsylvania | 42109 | 3616 | 84 |
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);