ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 3030 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 18
- Texas 12
- Minnesota 11
- Georgia 10
- Louisiana 8
- Oklahoma 7
- Colorado 6
- Florida 5
- Illinois 5
- Indiana 5
- Maryland 5
- Ohio 5
- Puerto Rico 5
- Tennessee 5
- Wisconsin 5
- California 4
- Idaho 4
- Kentucky 4
- Virginia 4
- Mississippi 3
- Missouri 3
- New Jersey 3
- Vermont 3
- West Virginia 3
- Michigan 2
- Nebraska 2
- Pennsylvania 2
- Alabama 1
- Arizona 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499706 | 2499706 | 2022-05-13 | Desha | Arkansas | 5041 | 3030 | 41 |
2496448 | 2496448 | 2022-05-12 | Desha | Arkansas | 5041 | 3030 | 41 |
2498675 | 2498675 | 2022-05-12 | Ciales | Puerto Rico | 72039 | 3030 | |
2493190 | 2493190 | 2022-05-11 | Desha | Arkansas | 5041 | 3030 | 41 |
2476901 | 2476901 | 2022-05-06 | Desha | Arkansas | 5041 | 3030 | 41 |
2473643 | 2473643 | 2022-05-05 | Desha | Arkansas | 5041 | 3030 | 41 |
2470386 | 2470386 | 2022-05-04 | Desha | Arkansas | 5041 | 3030 | 41 |
2467130 | 2467130 | 2022-05-03 | Desha | Arkansas | 5041 | 3030 | 41 |
2463875 | 2463875 | 2022-05-02 | Desha | Arkansas | 5041 | 3030 | 41 |
2460619 | 2460619 | 2022-05-01 | Desha | Arkansas | 5041 | 3030 | 41 |
2457363 | 2457363 | 2022-04-30 | Desha | Arkansas | 5041 | 3030 | 41 |
2454107 | 2454107 | 2022-04-29 | Desha | Arkansas | 5041 | 3030 | 41 |
2450851 | 2450851 | 2022-04-28 | Desha | Arkansas | 5041 | 3030 | 41 |
2447595 | 2447595 | 2022-04-27 | Desha | Arkansas | 5041 | 3030 | 41 |
2444339 | 2444339 | 2022-04-26 | Desha | Arkansas | 5041 | 3030 | 41 |
2446600 | 2446600 | 2022-04-26 | Orocovis | Puerto Rico | 72107 | 3030 | |
2441238 | 2441238 | 2022-04-25 | Moffat | Colorado | 8081 | 3030 | 51 |
2393505 | 2393505 | 2022-04-10 | Pope | Minnesota | 27121 | 3030 | 17 |
2390249 | 2390249 | 2022-04-09 | Pope | Minnesota | 27121 | 3030 | 17 |
2386993 | 2386993 | 2022-04-08 | Pope | Minnesota | 27121 | 3030 | 17 |
2358511 | 2358511 | 2022-03-30 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2355257 | 2355257 | 2022-03-29 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2352004 | 2352004 | 2022-03-28 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2348752 | 2348752 | 2022-03-27 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2345499 | 2345499 | 2022-03-26 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2342246 | 2342246 | 2022-03-25 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2338993 | 2338993 | 2022-03-24 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2292483 | 2292483 | 2022-03-10 | Kent | Maryland | 24029 | 3030 | 66 |
2289231 | 2289231 | 2022-03-09 | Kent | Maryland | 24029 | 3030 | 66 |
2223507 | 2223507 | 2022-02-17 | Telfair | Georgia | 13271 | 3030 | 77 |
2200650 | 2200650 | 2022-02-10 | Dade | Georgia | 13083 | 3030 | 27 |
2180326 | 2180326 | 2022-02-03 | Zapata | Texas | 48505 | 3030 | 47 |
2175678 | 2175678 | 2022-02-02 | Tallahatchie | Mississippi | 28135 | 3030 | 54 |
2155805 | 2155805 | 2022-01-27 | Claiborne | Louisiana | 22027 | 3030 | 67 |
2156794 | 2156794 | 2022-01-27 | Noble | Ohio | 39121 | 3030 | 52 |
2154336 | 2154336 | 2022-01-26 | Lamoille | Vermont | 50015 | 3030 | 12 |
2107374 | 2107374 | 2022-01-12 | Yalobusha | Mississippi | 28161 | 3030 | 48 |
2105038 | 2105038 | 2022-01-11 | Yauco | Puerto Rico | 72153 | 3030 | |
2087564 | 2087564 | 2022-01-06 | Lincoln | Maine | 23015 | 3030 | 15 |
2088817 | 2088817 | 2022-01-06 | Lee | South Carolina | 45061 | 3030 | 82 |
2076524 | 2076524 | 2022-01-02 | Burnett | Wisconsin | 55013 | 3030 | 36 |
2073273 | 2073273 | 2022-01-01 | Burnett | Wisconsin | 55013 | 3030 | 36 |
2070022 | 2070022 | 2021-12-31 | Burnett | Wisconsin | 55013 | 3030 | 36 |
2053994 | 2053994 | 2021-12-27 | Drew | Arkansas | 5043 | 3030 | 56 |
2056696 | 2056696 | 2021-12-27 | Shelby | Texas | 48419 | 3030 | 114 |
2037047 | 2037047 | 2021-12-21 | DeWitt | Texas | 48123 | 3030 | 86 |
2033797 | 2033797 | 2021-12-20 | DeWitt | Texas | 48123 | 3030 | 86 |
2030547 | 2030547 | 2021-12-19 | DeWitt | Texas | 48123 | 3030 | 86 |
2027296 | 2027296 | 2021-12-18 | DeWitt | Texas | 48123 | 3030 | 86 |
2020918 | 2020918 | 2021-12-16 | Panola | Texas | 48365 | 3030 | 110 |
2015026 | 2015026 | 2021-12-15 | Polk | Arkansas | 5113 | 3030 | 115 |
2013921 | 2013921 | 2021-12-14 | Montour | Pennsylvania | 42093 | 3030 | 78 |
1986215 | 1986215 | 2021-12-06 | Clark | Illinois | 17023 | 3030 | 52 |
1971358 | 1971358 | 2021-12-01 | Yancey | North Carolina | 37199 | 3030 | 35 |
1967942 | 1967942 | 2021-11-30 | San Miguel | New Mexico | 35047 | 3030 | 29 |
1905088 | 1905088 | 2021-11-11 | Jay | Indiana | 18075 | 3030 | 52 |
1907269 | 1907269 | 2021-11-11 | Windsor | Vermont | 50027 | 3030 | 32 |
1900765 | 1900765 | 2021-11-09 | Orleans | Vermont | 50019 | 3030 | 19 |
1900967 | 1900967 | 2021-11-09 | Lincoln | West Virginia | 54043 | 3030 | 45 |
1892953 | 1892953 | 2021-11-07 | Texas | Missouri | 29215 | 3030 | 43 |
1865222 | 1865222 | 2021-10-29 | Lewis | West Virginia | 54041 | 3030 | 54 |
1829802 | 1829802 | 2021-10-19 | Colusa | California | 6011 | 3030 | 18 |
1830308 | 1830308 | 2021-10-19 | Wayne | Illinois | 17191 | 3030 | 63 |
1808616 | 1808616 | 2021-10-12 | Saunders | Nebraska | 31155 | 3030 | 20 |
1796204 | 1796204 | 2021-10-08 | Aguadilla | Puerto Rico | 72005 | 3030 | |
1781879 | 1781879 | 2021-10-04 | Anderson | Kentucky | 21005 | 3030 | 39 |
1771227 | 1771227 | 2021-10-01 | La Paz | Arizona | 4012 | 3030 | 90 |
1767665 | 1767665 | 2021-09-29 | Salem city | Virginia | 51775 | 3030 | 56 |
1743381 | 1743381 | 2021-09-22 | Winston | Mississippi | 28159 | 3030 | 91 |
1739079 | 1739079 | 2021-09-21 | Elbert | Georgia | 13105 | 3030 | 80 |
1716181 | 1716181 | 2021-09-14 | Morgan | Colorado | 8087 | 3030 | 97 |
1713373 | 1713373 | 2021-09-13 | Fountain | Indiana | 18045 | 3030 | 55 |
1702186 | 1702186 | 2021-09-09 | Bledsoe | Tennessee | 47007 | 3030 | 13 |
1699119 | 1699119 | 2021-09-08 | Gray | Texas | 48179 | 3030 | 63 |
1695702 | 1695702 | 2021-09-07 | Crockett | Tennessee | 47033 | 3030 | 54 |
1649017 | 1649017 | 2021-08-24 | Cass | Minnesota | 27021 | 3030 | 34 |
1608508 | 1608508 | 2021-08-11 | Winchester city | Virginia | 51840 | 3030 | 49 |
1603364 | 1603364 | 2021-08-10 | Richland | Louisiana | 22083 | 3030 | 58 |
1586530 | 1586530 | 2021-08-05 | Cassia | Idaho | 16031 | 3030 | 28 |
1583866 | 1583866 | 2021-08-04 | Plaquemines | Louisiana | 22075 | 3030 | 27 |
1557798 | 1557798 | 2021-07-27 | Marshall | Kentucky | 21157 | 3030 | 63 |
1554694 | 1554694 | 2021-07-26 | Queen Anne's | Maryland | 24035 | 3030 | 52 |
1551447 | 1551447 | 2021-07-25 | Queen Anne's | Maryland | 24035 | 3030 | 52 |
1548200 | 1548200 | 2021-07-24 | Queen Anne's | Maryland | 24035 | 3030 | 52 |
1541557 | 1541557 | 2021-07-22 | Logan | Kentucky | 21141 | 3030 | 74 |
1538393 | 1538393 | 2021-07-21 | Morehouse | Louisiana | 22067 | 3030 | 79 |
1514653 | 1514653 | 2021-07-14 | Johnson | Arkansas | 5071 | 3030 | 38 |
1511695 | 1511695 | 2021-07-13 | Decatur | Georgia | 13087 | 3030 | 73 |
1509779 | 1509779 | 2021-07-12 | Douglas | Nevada | 32005 | 3030 | 37 |
1496211 | 1496211 | 2021-07-08 | West Baton Rouge | Louisiana | 22121 | 3030 | 63 |
1469640 | 1469640 | 2021-06-30 | Jefferson | Idaho | 16051 | 3030 | 33 |
1466395 | 1466395 | 2021-06-29 | Jefferson | Idaho | 16051 | 3030 | 33 |
1463150 | 1463150 | 2021-06-28 | Jefferson | Idaho | 16051 | 3030 | 33 |
1414600 | 1414600 | 2021-06-13 | Daviess | Indiana | 18027 | 3030 | 102 |
1411355 | 1411355 | 2021-06-12 | Daviess | Indiana | 18027 | 3030 | 102 |
1362439 | 1362439 | 2021-05-28 | Lumpkin | Georgia | 13187 | 3030 | 76 |
1359192 | 1359192 | 2021-05-27 | Lumpkin | Georgia | 13187 | 3030 | 76 |
1358330 | 1358330 | 2021-05-26 | Willacy | Texas | 48489 | 3030 | 88 |
1351564 | 1351564 | 2021-05-24 | Overton | Tennessee | 47133 | 3030 | 61 |
1345526 | 1345526 | 2021-05-22 | Warren | Virginia | 51187 | 3030 | 58 |
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);