ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 5739 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Oklahoma 16
- Wisconsin 10
- North Carolina 9
- Illinois 6
- Missouri 5
- New York 4
- Puerto Rico 4
- Tennessee 4
- Georgia 3
- Louisiana 3
- Maine 3
- Ohio 3
- Texas 3
- Washington 3
- Virginia 2
- Arkansas 1
- Colorado 1
- Florida 1
- Indiana 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Nebraska 1
- North Dakota 1
- Oregon 1
- South Carolina 1
- South Dakota 1
- Utah 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2335924 | 2335924 | 2022-03-23 | Juana Diaz | Puerto Rico | 72075 | 5739 | |
2332670 | 2332670 | 2022-03-22 | Juana Diaz | Puerto Rico | 72075 | 5739 | |
2319976 | 2319976 | 2022-03-18 | Dimmit | Texas | 48127 | 5739 | 51 |
2316722 | 2316722 | 2022-03-17 | Dimmit | Texas | 48127 | 5739 | 51 |
2281965 | 2281965 | 2022-03-07 | Grady | Georgia | 13131 | 5739 | 108 |
2282703 | 2282703 | 2022-03-07 | Knox | Maine | 23013 | 5739 | 31 |
2279450 | 2279450 | 2022-03-06 | Knox | Maine | 23013 | 5739 | 31 |
2279861 | 2279861 | 2022-03-06 | Stone | Missouri | 29209 | 5739 | 114 |
2276197 | 2276197 | 2022-03-05 | Knox | Maine | 23013 | 5739 | 31 |
2276608 | 2276608 | 2022-03-05 | Stone | Missouri | 29209 | 5739 | 114 |
2273355 | 2273355 | 2022-03-04 | Stone | Missouri | 29209 | 5739 | 114 |
2254134 | 2254134 | 2022-02-26 | Seneca | New York | 36099 | 5739 | 89 |
2225028 | 2225028 | 2022-02-17 | Rolette | North Dakota | 38079 | 5739 | 41 |
2217245 | 2217245 | 2022-02-15 | Owen | Indiana | 18119 | 5739 | 111 |
2192939 | 2192939 | 2022-02-07 | Davison | South Dakota | 46035 | 5739 | 79 |
2086198 | 2086198 | 2022-01-05 | Kittitas | Washington | 53037 | 5739 | 56 |
2059231 | 2059231 | 2021-12-28 | Morrow | Ohio | 39117 | 5739 | 70 |
2055840 | 2055840 | 2021-12-27 | Person | North Carolina | 37145 | 5739 | 91 |
2052590 | 2052590 | 2021-12-26 | Person | North Carolina | 37145 | 5739 | 91 |
2049340 | 2049340 | 2021-12-25 | Person | North Carolina | 37145 | 5739 | 91 |
2046090 | 2046090 | 2021-12-24 | Person | North Carolina | 37145 | 5739 | 91 |
2042840 | 2042840 | 2021-12-23 | Person | North Carolina | 37145 | 5739 | 91 |
2039591 | 2039591 | 2021-12-22 | Person | North Carolina | 37145 | 5739 | 91 |
2018778 | 2018778 | 2021-12-16 | Montgomery | Illinois | 17135 | 5739 | 91 |
2008284 | 2008284 | 2021-12-12 | Green | Wisconsin | 55045 | 5739 | 38 |
2005033 | 2005033 | 2021-12-11 | Green | Wisconsin | 55045 | 5739 | 38 |
2001782 | 2001782 | 2021-12-10 | Green | Wisconsin | 55045 | 5739 | 38 |
1948986 | 1948986 | 2021-11-24 | Ponce | Puerto Rico | 72113 | 5739 | |
1946484 | 1946484 | 2021-11-23 | Preston | West Virginia | 54077 | 5739 | 98 |
1942484 | 1942484 | 2021-11-22 | Ponce | Puerto Rico | 72113 | 5739 | |
1906887 | 1906887 | 2021-11-11 | Claiborne | Tennessee | 47025 | 5739 | 114 |
1903638 | 1903638 | 2021-11-10 | Claiborne | Tennessee | 47025 | 5739 | 114 |
1883014 | 1883014 | 2021-11-04 | Alcorn | Mississippi | 28003 | 5739 | 103 |
1873393 | 1873393 | 2021-11-01 | Howell | Missouri | 29091 | 5739 | 77 |
1787192 | 1787192 | 2021-10-05 | Douglas | Washington | 53017 | 5739 | 33 |
1766617 | 1766617 | 2021-09-29 | Stokes | North Carolina | 37169 | 5739 | 96 |
1764569 | 1764569 | 2021-09-28 | Marinette | Wisconsin | 55075 | 5739 | 77 |
1764604 | 1764604 | 2021-09-28 | Albany | Wyoming | 56001 | 5739 | 28 |
1746512 | 1746512 | 2021-09-23 | Mower | Minnesota | 27099 | 5739 | 38 |
1690160 | 1690160 | 2021-09-06 | Broomfield | Colorado | 8014 | 5739 | 77 |
1649661 | 1649661 | 2021-08-24 | Richmond | North Carolina | 37153 | 5739 | 114 |
1540138 | 1540138 | 2021-07-21 | Summit | Utah | 49043 | 5739 | 15 |
1536181 | 1536181 | 2021-07-20 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1532933 | 1532933 | 2021-07-19 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1529686 | 1529686 | 2021-07-18 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1526439 | 1526439 | 2021-07-17 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1523192 | 1523192 | 2021-07-16 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1519944 | 1519944 | 2021-07-15 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1516696 | 1516696 | 2021-07-14 | Le Flore | Oklahoma | 40079 | 5739 | 67 |
1511108 | 1511108 | 2021-07-12 | Walla Walla | Washington | 53071 | 5739 | 69 |
1445199 | 1445199 | 2021-06-22 | Lawrence | Ohio | 39087 | 5739 | 102 |
1437783 | 1437783 | 2021-06-20 | Vermilion | Louisiana | 22113 | 5739 | 125 |
1434536 | 1434536 | 2021-06-19 | Vermilion | Louisiana | 22113 | 5739 | 125 |
1431290 | 1431290 | 2021-06-18 | Vermilion | Louisiana | 22113 | 5739 | 125 |
1391670 | 1391670 | 2021-06-06 | Polk | Georgia | 13233 | 5739 | 97 |
1394337 | 1394337 | 2021-06-06 | Grant | Wisconsin | 55043 | 5739 | 93 |
1391092 | 1391092 | 2021-06-05 | Grant | Wisconsin | 55043 | 5739 | 93 |
1387847 | 1387847 | 2021-06-04 | Grant | Wisconsin | 55043 | 5739 | 93 |
1384602 | 1384602 | 2021-06-03 | Grant | Wisconsin | 55043 | 5739 | 93 |
1378799 | 1378799 | 2021-06-02 | Coles | Illinois | 17029 | 5739 | 101 |
1367101 | 1367101 | 2021-05-29 | Wayne | New York | 36117 | 5739 | 68 |
1290209 | 1290209 | 2021-05-05 | Albemarle | Virginia | 51003 | 5739 | 83 |
1281404 | 1281404 | 2021-05-03 | Clinton | Illinois | 17027 | 5739 | 99 |
1269096 | 1269096 | 2021-04-29 | Marquette | Michigan | 26103 | 5739 | 59 |
1226259 | 1226259 | 2021-04-16 | Ogle | Illinois | 17141 | 5739 | 86 |
1170337 | 1170337 | 2021-03-29 | Sauk | Wisconsin | 55111 | 5739 | 50 |
1149818 | 1149818 | 2021-03-23 | Grady | Oklahoma | 40051 | 5739 | 81 |
1146571 | 1146571 | 2021-03-22 | Grady | Oklahoma | 40051 | 5739 | 81 |
1143324 | 1143324 | 2021-03-21 | Grady | Oklahoma | 40051 | 5739 | 81 |
1140077 | 1140077 | 2021-03-20 | Grady | Oklahoma | 40051 | 5739 | 81 |
1136831 | 1136831 | 2021-03-19 | Grady | Oklahoma | 40051 | 5739 | 81 |
1133585 | 1133585 | 2021-03-18 | Grady | Oklahoma | 40051 | 5739 | 81 |
1130101 | 1130101 | 2021-03-17 | Franklin | North Carolina | 37069 | 5739 | 46 |
1130337 | 1130337 | 2021-03-17 | Grady | Oklahoma | 40051 | 5739 | 81 |
1127090 | 1127090 | 2021-03-16 | Grady | Oklahoma | 40051 | 5739 | 81 |
1123844 | 1123844 | 2021-03-15 | Grady | Oklahoma | 40051 | 5739 | 80 |
1004119 | 1004119 | 2021-02-06 | Cumberland | Tennessee | 47035 | 5739 | 103 |
989195 | 989195 | 2021-02-02 | Boone | Illinois | 17007 | 5739 | 83 |
990722 | 990722 | 2021-02-02 | Ross | Ohio | 39141 | 5739 | 104 |
958689 | 958689 | 2021-01-23 | Gibson | Tennessee | 47053 | 5739 | 116 |
954743 | 954743 | 2021-01-22 | Chemung | New York | 36015 | 5739 | 109 |
924213 | 924213 | 2021-01-13 | Troup | Georgia | 13285 | 5739 | 139 |
909908 | 909908 | 2021-01-08 | Orangeburg | South Carolina | 45075 | 5739 | 156 |
878383 | 878383 | 2020-12-30 | Garland | Arkansas | 5051 | 5739 | 152 |
852201 | 852201 | 2020-12-21 | Chippewa | Wisconsin | 55017 | 5739 | 67 |
758818 | 758818 | 2020-11-23 | Kendall | Illinois | 17093 | 5739 | 41 |
708111 | 708111 | 2020-11-07 | Dutchess | New York | 36027 | 5739 | 168 |
672324 | 672324 | 2020-10-27 | Sarpy | Nebraska | 31153 | 5739 | 37 |
666350 | 666350 | 2020-10-25 | Washington | Oregon | 41067 | 5739 | 75 |
652619 | 652619 | 2020-10-21 | Boone | Missouri | 29019 | 5739 | 16 |
648246 | 648246 | 2020-10-20 | Santa Rosa | Florida | 12113 | 5739 | 86 |
466312 | 466312 | 2020-08-24 | Virginia Beach city | Virginia | 51810 | 5739 | 64 |
311858 | 311858 | 2020-07-07 | Hidalgo | Texas | 48215 | 5739 | 90 |
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);