ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where cases = 4879 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Virginia 9
- Idaho 8
- Oklahoma 8
- Illinois 6
- Indiana 4
- Alabama 3
- Iowa 3
- Minnesota 3
- Nebraska 3
- New York 3
- Ohio 3
- Puerto Rico 3
- Vermont 3
- Arkansas 2
- Michigan 2
- North Dakota 2
- South Dakota 2
- Tennessee 2
- Texas 2
- Kentucky 1
- Maryland 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- New Mexico 1
- North Carolina 1
- South Carolina 1
- Washington 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496282 | 2496282 | 2022-05-11 | Taylor | Wisconsin | 55119 | 4879 | 72 |
2474864 | 2474864 | 2022-05-05 | Fillmore | Minnesota | 27045 | 4879 | 24 |
2453085 | 2453085 | 2022-04-28 | Fajardo | Puerto Rico | 72053 | 4879 | |
2440645 | 2440645 | 2022-04-24 | Buchanan | Virginia | 51027 | 4879 | 119 |
2437389 | 2437389 | 2022-04-23 | Buchanan | Virginia | 51027 | 4879 | 119 |
2434133 | 2434133 | 2022-04-22 | Buchanan | Virginia | 51027 | 4879 | 119 |
2430877 | 2430877 | 2022-04-21 | Buchanan | Virginia | 51027 | 4879 | 118 |
2427621 | 2427621 | 2022-04-20 | Buchanan | Virginia | 51027 | 4879 | 118 |
2395834 | 2395834 | 2022-04-11 | Hart | Georgia | 13147 | 4879 | 93 |
2395039 | 2395039 | 2022-04-10 | Orange | Vermont | 50017 | 4879 | 14 |
2391783 | 2391783 | 2022-04-09 | Orange | Vermont | 50017 | 4879 | 14 |
2388527 | 2388527 | 2022-04-08 | Orange | Vermont | 50017 | 4879 | 14 |
2330759 | 2330759 | 2022-03-22 | Hart | Georgia | 13147 | 4879 | 89 |
2327507 | 2327507 | 2022-03-21 | Hart | Georgia | 13147 | 4879 | 89 |
2291692 | 2291692 | 2022-03-10 | Cook | Georgia | 13075 | 4879 | 70 |
2288440 | 2288440 | 2022-03-09 | Cook | Georgia | 13075 | 4879 | 70 |
2290215 | 2290215 | 2022-03-09 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2291040 | 2291040 | 2022-03-09 | Powhatan | Virginia | 51145 | 4879 | 55 |
2285189 | 2285189 | 2022-03-08 | Cook | Georgia | 13075 | 4879 | 70 |
2285335 | 2285335 | 2022-03-08 | Cassia | Idaho | 16031 | 4879 | 52 |
2286963 | 2286963 | 2022-03-08 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2283711 | 2283711 | 2022-03-07 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2280459 | 2280459 | 2022-03-06 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2277206 | 2277206 | 2022-03-05 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2273953 | 2273953 | 2022-03-04 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2270700 | 2270700 | 2022-03-03 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2267448 | 2267448 | 2022-03-02 | McIntosh | Oklahoma | 40091 | 4879 | 118 |
2245460 | 2245460 | 2022-02-23 | Fluvanna | Virginia | 51065 | 4879 | 39 |
2194233 | 2194233 | 2022-02-08 | Tattnall | Georgia | 13267 | 4879 | 123 |
2192065 | 2192065 | 2022-02-07 | Vernon | Missouri | 29217 | 4879 | 95 |
2175417 | 2175417 | 2022-02-02 | Somerset | Maryland | 24039 | 4879 | 67 |
2149175 | 2149175 | 2022-01-25 | Bourbon | Kentucky | 21017 | 4879 | 45 |
2151221 | 2151221 | 2022-01-25 | Waynesboro city | Virginia | 51820 | 4879 | 55 |
2132356 | 2132356 | 2022-01-20 | Haralson | Georgia | 13143 | 4879 | 141 |
2108406 | 2108406 | 2022-01-12 | Yankton | South Dakota | 46135 | 4879 | 46 |
2084549 | 2084549 | 2022-01-05 | Covington | Mississippi | 28031 | 4879 | 97 |
2078285 | 2078285 | 2022-01-03 | Adams | Nebraska | 31001 | 4879 | 56 |
2063756 | 2063756 | 2021-12-30 | Johnson | Arkansas | 5071 | 4879 | 63 |
2038021 | 2038021 | 2021-12-22 | Butts | Georgia | 13035 | 4879 | 124 |
1975063 | 1975063 | 2021-12-02 | Union | South Carolina | 45087 | 4879 | 112 |
1924561 | 1924561 | 2021-11-17 | Daviess | Indiana | 18027 | 4879 | 118 |
1921969 | 1921969 | 2021-11-16 | Mille Lacs | Minnesota | 27095 | 4879 | 70 |
1899730 | 1899730 | 2021-11-09 | Otsego | New York | 36077 | 4879 | 57 |
1883452 | 1883452 | 2021-11-04 | Chenango | New York | 36017 | 4879 | 92 |
1742516 | 1742516 | 2021-09-22 | Fulton | Illinois | 17057 | 4879 | 78 |
1728747 | 1728747 | 2021-09-17 | Fayette | West Virginia | 54019 | 4879 | 97 |
1682029 | 1682029 | 2021-09-03 | Livingston | New York | 36051 | 4879 | 61 |
1650536 | 1650536 | 2021-08-24 | Uvalde | Texas | 48463 | 4879 | 79 |
1647213 | 1647213 | 2021-08-23 | Matagorda | Texas | 48321 | 4879 | 117 |
1641901 | 1641901 | 2021-08-22 | DeKalb | Indiana | 18033 | 4879 | 91 |
1638651 | 1638651 | 2021-08-21 | DeKalb | Indiana | 18033 | 4879 | 91 |
1635401 | 1635401 | 2021-08-20 | DeKalb | Indiana | 18033 | 4879 | 91 |
1615258 | 1615258 | 2021-08-14 | Tallapoosa | Alabama | 1123 | 4879 | 157 |
1612009 | 1612009 | 2021-08-13 | Tallapoosa | Alabama | 1123 | 4879 | 157 |
1540927 | 1540927 | 2021-07-22 | Effingham | Georgia | 13103 | 4879 | 74 |
1505330 | 1505330 | 2021-07-11 | Bingham | Idaho | 16011 | 4879 | 77 |
1505471 | 1505471 | 2021-07-11 | Woodford | Illinois | 17203 | 4879 | 96 |
1502084 | 1502084 | 2021-07-10 | Bingham | Idaho | 16011 | 4879 | 77 |
1502225 | 1502225 | 2021-07-10 | Woodford | Illinois | 17203 | 4879 | 96 |
1498838 | 1498838 | 2021-07-09 | Bingham | Idaho | 16011 | 4879 | 77 |
1498979 | 1498979 | 2021-07-09 | Woodford | Illinois | 17203 | 4879 | 96 |
1495591 | 1495591 | 2021-07-08 | Bingham | Idaho | 16011 | 4879 | 77 |
1492345 | 1492345 | 2021-07-07 | Bingham | Idaho | 16011 | 4879 | 77 |
1489098 | 1489098 | 2021-07-06 | Bingham | Idaho | 16011 | 4879 | 77 |
1469620 | 1469620 | 2021-06-30 | Bingham | Idaho | 16011 | 4879 | 76 |
1461435 | 1461435 | 2021-06-27 | Mercer | Ohio | 39107 | 4879 | 85 |
1458190 | 1458190 | 2021-06-26 | Mercer | Ohio | 39107 | 4879 | 85 |
1454945 | 1454945 | 2021-06-25 | Mercer | Ohio | 39107 | 4879 | 85 |
1450446 | 1450446 | 2021-06-24 | Marshall | Iowa | 19127 | 4879 | 76 |
1451986 | 1451986 | 2021-06-24 | Toa Baja | Puerto Rico | 72137 | 4879 | |
1445495 | 1445495 | 2021-06-22 | Toa Baja | Puerto Rico | 72137 | 4879 | |
1430977 | 1430977 | 2021-06-18 | Muscatine | Iowa | 19139 | 4879 | 106 |
1408696 | 1408696 | 2021-06-11 | Newaygo | Michigan | 26123 | 4879 | 69 |
1354265 | 1354265 | 2021-05-25 | Stark | North Dakota | 38089 | 4879 | 51 |
1300072 | 1300072 | 2021-05-08 | Washington | Virginia | 51191 | 4879 | 107 |
1294314 | 1294314 | 2021-05-07 | Ware | Georgia | 13299 | 4879 | 179 |
1284674 | 1284674 | 2021-05-04 | Henry | Illinois | 17073 | 4879 | 92 |
1274823 | 1274823 | 2021-05-01 | Tift | Georgia | 13277 | 4879 | 125 |
1227285 | 1227285 | 2021-04-16 | Dodge | Nebraska | 31053 | 4879 | 58 |
1196203 | 1196203 | 2021-04-06 | Walla Walla | Washington | 53071 | 4879 | 64 |
1123644 | 1123644 | 2021-03-15 | Pender | North Carolina | 37141 | 4879 | 65 |
1019836 | 1019836 | 2021-02-11 | Morton | North Dakota | 38059 | 4879 | 94 |
1008879 | 1008879 | 2021-02-08 | Cerro Gordo | Iowa | 19033 | 4879 | 76 |
971581 | 971581 | 2021-01-27 | Brown | South Dakota | 46013 | 4879 | 77 |
928214 | 928214 | 2021-01-14 | Lapeer | Michigan | 26087 | 4879 | 114 |
913948 | 913948 | 2021-01-10 | Autauga | Alabama | 1001 | 4879 | 54 |
856865 | 856865 | 2020-12-23 | Blue Earth | Minnesota | 27013 | 4879 | 27 |
825675 | 825675 | 2020-12-13 | Robertson | Tennessee | 47147 | 4879 | 64 |
766457 | 766457 | 2020-11-25 | Cumberland | New Jersey | 34011 | 4879 | 171 |
586855 | 586855 | 2020-10-01 | Champaign | Illinois | 17019 | 4879 | 22 |
537035 | 537035 | 2020-09-15 | Williamson | Tennessee | 47187 | 4879 | 35 |
431126 | 431126 | 2020-08-14 | Benton | Arkansas | 5007 | 4879 | 43 |
425055 | 425055 | 2020-08-12 | Muscogee | Georgia | 13215 | 4879 | 104 |
408878 | 408878 | 2020-08-07 | Clayton | Georgia | 13063 | 4879 | 105 |
397381 | 397381 | 2020-08-03 | Bernalillo | New Mexico | 35001 | 4879 | 123 |
207689 | 207689 | 2020-06-04 | Douglas | Nebraska | 31055 | 4879 | 45 |
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);