ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 4277 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 13
- Mississippi 9
- Georgia 8
- Texas 8
- Minnesota 7
- Michigan 6
- Tennessee 6
- Kentucky 5
- Louisiana 5
- Missouri 4
- Virginia 4
- Indiana 3
- Ohio 3
- Wisconsin 3
- Alaska 2
- Illinois 2
- Kansas 2
- New York 2
- Pennsylvania 2
- West Virginia 2
- Florida 1
- Idaho 1
- Iowa 1
- Maryland 1
- Montana 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501493 | 2501493 | 2022-05-13 | Bertie | North Carolina | 37015 | 4277 | 68 |
2498235 | 2498235 | 2022-05-12 | Bertie | North Carolina | 37015 | 4277 | 68 |
2494977 | 2494977 | 2022-05-11 | Bertie | North Carolina | 37015 | 4277 | 68 |
2466667 | 2466667 | 2022-05-02 | Orange | Vermont | 50017 | 4277 | 13 |
2381509 | 2381509 | 2022-04-06 | Yabucoa | Puerto Rico | 72151 | 4277 | |
2289261 | 2289261 | 2022-03-09 | Antrim | Michigan | 26009 | 4277 | 61 |
2284845 | 2284845 | 2022-03-08 | Northwest Arctic Borough | Alaska | 2188 | 4277 | 12 |
2286010 | 2286010 | 2022-03-08 | Antrim | Michigan | 26009 | 4277 | 61 |
2281593 | 2281593 | 2022-03-07 | Northwest Arctic Borough | Alaska | 2188 | 4277 | 12 |
2263109 | 2263109 | 2022-03-01 | Union | Kentucky | 21225 | 4277 | 55 |
2220878 | 2220878 | 2022-02-16 | Jackson | Louisiana | 22049 | 4277 | 70 |
2202906 | 2202906 | 2022-02-10 | Deaf Smith | Texas | 48117 | 4277 | 105 |
2194613 | 2194613 | 2022-02-08 | Bourbon | Kansas | 20011 | 4277 | 46 |
2195106 | 2195106 | 2022-02-08 | Roseau | Minnesota | 27135 | 4277 | 42 |
2191359 | 2191359 | 2022-02-07 | Bourbon | Kansas | 20011 | 4277 | 46 |
2165551 | 2165551 | 2022-01-30 | Wayne | Kentucky | 21231 | 4277 | 78 |
2162296 | 2162296 | 2022-01-29 | Wayne | Kentucky | 21231 | 4277 | 78 |
2159041 | 2159041 | 2022-01-28 | Wayne | Kentucky | 21231 | 4277 | 78 |
2133473 | 2133473 | 2022-01-20 | Perry | Missouri | 29157 | 4277 | 42 |
2056986 | 2056986 | 2021-12-27 | Mason | West Virginia | 54053 | 4277 | 65 |
2035936 | 2035936 | 2021-12-21 | Nodaway | Missouri | 29147 | 4277 | 39 |
1995949 | 1995949 | 2021-12-09 | Payette | Idaho | 16075 | 4277 | 71 |
1964312 | 1964312 | 2021-11-29 | Marion | Mississippi | 28091 | 4277 | 112 |
1965800 | 1965800 | 2021-11-29 | Caroline | Virginia | 51033 | 4277 | 55 |
1921113 | 1921113 | 2021-11-16 | Sumter | Georgia | 13261 | 4277 | 137 |
1921807 | 1921807 | 2021-11-16 | Dorchester | Maryland | 24019 | 4277 | 84 |
1827524 | 1827524 | 2021-10-18 | Richland | Louisiana | 22083 | 4277 | 77 |
1815492 | 1815492 | 2021-10-14 | Pike | Ohio | 39131 | 4277 | 58 |
1790499 | 1790499 | 2021-10-06 | Mineral | West Virginia | 54057 | 4277 | 106 |
1786201 | 1786201 | 2021-10-05 | Coshocton | Ohio | 39031 | 4277 | 74 |
1739801 | 1739801 | 2021-09-21 | Sabine | Louisiana | 22085 | 4277 | 78 |
1741225 | 1741225 | 2021-09-21 | McNairy | Tennessee | 47109 | 4277 | 61 |
1737976 | 1737976 | 2021-09-20 | McNairy | Tennessee | 47109 | 4277 | 61 |
1738194 | 1738194 | 2021-09-20 | Palo Pinto | Texas | 48363 | 4277 | 97 |
1734944 | 1734944 | 2021-09-19 | Palo Pinto | Texas | 48363 | 4277 | 97 |
1731694 | 1731694 | 2021-09-18 | Palo Pinto | Texas | 48363 | 4277 | 97 |
1724512 | 1724512 | 2021-09-16 | Ottawa | Ohio | 39123 | 4277 | 83 |
1668546 | 1668546 | 2021-08-30 | Nobles | Minnesota | 27105 | 4277 | 50 |
1632478 | 1632478 | 2021-08-19 | Greenup | Kentucky | 21089 | 4277 | 63 |
1623351 | 1623351 | 2021-08-16 | Silver Bow | Montana | 30093 | 4277 | 87 |
1599451 | 1599451 | 2021-08-09 | Oconee | Georgia | 13219 | 4277 | 74 |
1597162 | 1597162 | 2021-08-08 | Lincoln | Mississippi | 28085 | 4277 | 116 |
1593913 | 1593913 | 2021-08-07 | Lincoln | Mississippi | 28085 | 4277 | 116 |
1590664 | 1590664 | 2021-08-06 | Lincoln | Mississippi | 28085 | 4277 | 116 |
1587274 | 1587274 | 2021-08-05 | Sanilac | Michigan | 26151 | 4277 | 126 |
1584023 | 1584023 | 2021-08-04 | Sanilac | Michigan | 26151 | 4277 | 126 |
1580774 | 1580774 | 2021-08-03 | Sanilac | Michigan | 26151 | 4277 | 126 |
1554936 | 1554936 | 2021-07-26 | Monroe | Mississippi | 28095 | 4277 | 137 |
1551602 | 1551602 | 2021-07-25 | Morrison | Minnesota | 27097 | 4277 | 62 |
1548355 | 1548355 | 2021-07-24 | Morrison | Minnesota | 27097 | 4277 | 62 |
1545108 | 1545108 | 2021-07-23 | Morrison | Minnesota | 27097 | 4277 | 62 |
1543107 | 1543107 | 2021-07-22 | Weakley | Tennessee | 47183 | 4277 | 69 |
1539227 | 1539227 | 2021-07-21 | Stokes | North Carolina | 37169 | 4277 | 81 |
1520615 | 1520615 | 2021-07-15 | Waller | Texas | 48473 | 4277 | 52 |
1464039 | 1464039 | 2021-06-28 | Pontotoc | Mississippi | 28115 | 4277 | 73 |
1451095 | 1451095 | 2021-06-24 | Butler | Missouri | 29023 | 4277 | 50 |
1431622 | 1431622 | 2021-06-18 | Camden | Missouri | 29029 | 4277 | 89 |
1375354 | 1375354 | 2021-06-01 | Chattahoochee | Georgia | 13053 | 4277 | 16 |
1372109 | 1372109 | 2021-05-31 | Chattahoochee | Georgia | 13053 | 4277 | 16 |
1368864 | 1368864 | 2021-05-30 | Chattahoochee | Georgia | 13053 | 4277 | 16 |
1365618 | 1365618 | 2021-05-29 | Chattahoochee | Georgia | 13053 | 4277 | 16 |
1349728 | 1349728 | 2021-05-24 | Montgomery | Indiana | 18107 | 4277 | 91 |
1298890 | 1298890 | 2021-05-08 | Livingston | New York | 36051 | 4277 | 58 |
1290321 | 1290321 | 2021-05-05 | Shenandoah | Virginia | 51171 | 4277 | 130 |
1273312 | 1273312 | 2021-04-30 | Yamhill | Oregon | 41071 | 4277 | 75 |
1227460 | 1227460 | 2021-04-16 | Madison | New York | 36053 | 4277 | 85 |
1219047 | 1219047 | 2021-04-13 | Polk | Wisconsin | 55095 | 4277 | 49 |
1207591 | 1207591 | 2021-04-10 | Warren | Mississippi | 28149 | 4277 | 118 |
1204343 | 1204343 | 2021-04-09 | Warren | Mississippi | 28149 | 4277 | 118 |
1202185 | 1202185 | 2021-04-08 | Lincoln | Tennessee | 47103 | 4277 | 63 |
1197106 | 1197106 | 2021-04-07 | Lawrence | Indiana | 18093 | 4277 | 120 |
1183992 | 1183992 | 2021-04-03 | Franklin | Illinois | 17055 | 4277 | 82 |
1174804 | 1174804 | 2021-03-31 | Washington | Louisiana | 22117 | 4277 | 127 |
1142526 | 1142526 | 2021-03-21 | Mower | Minnesota | 27099 | 4277 | 31 |
1143072 | 1143072 | 2021-03-21 | Chatham | North Carolina | 37037 | 4277 | 80 |
1143100 | 1143100 | 2021-03-21 | Hoke | North Carolina | 37093 | 4277 | 55 |
1139825 | 1139825 | 2021-03-20 | Chatham | North Carolina | 37037 | 4277 | 80 |
1139853 | 1139853 | 2021-03-20 | Hoke | North Carolina | 37093 | 4277 | 55 |
1130918 | 1130918 | 2021-03-17 | Kerr | Texas | 48265 | 4277 | 83 |
1127900 | 1127900 | 2021-03-16 | Henry | Virginia | 51089 | 4277 | 121 |
1113910 | 1113910 | 2021-03-12 | Richmond | North Carolina | 37153 | 4277 | 92 |
1087871 | 1087871 | 2021-03-04 | Beaufort | North Carolina | 37013 | 4277 | 82 |
1072689 | 1072689 | 2021-02-27 | Danville city | Virginia | 51590 | 4277 | 102 |
1066882 | 1066882 | 2021-02-26 | Baldwin | Georgia | 13009 | 4277 | 108 |
1027491 | 1027491 | 2021-02-13 | Pierce | Wisconsin | 55093 | 4277 | 39 |
1002070 | 1002070 | 2021-02-06 | Murray | Georgia | 13213 | 4277 | 57 |
968422 | 968422 | 2021-01-26 | Franklin | Tennessee | 47051 | 4277 | 68 |
962549 | 962549 | 2021-01-24 | Dunn | Wisconsin | 55033 | 4277 | 26 |
944011 | 944011 | 2021-01-19 | Marshall | Iowa | 19127 | 4277 | 61 |
926411 | 926411 | 2021-01-13 | Henderson | Texas | 48213 | 4277 | 94 |
923165 | 923165 | 2021-01-12 | Henderson | Texas | 48213 | 4277 | 92 |
871047 | 871047 | 2020-12-27 | Carter | Tennessee | 47019 | 4277 | 81 |
845642 | 845642 | 2020-12-19 | Thurston | Washington | 53067 | 4277 | 50 |
821277 | 821277 | 2020-12-12 | Jones | Mississippi | 28067 | 4277 | 91 |
805773 | 805773 | 2020-12-07 | Garfield | Oklahoma | 40047 | 4277 | 37 |
788769 | 788769 | 2020-12-02 | Rice | Minnesota | 27131 | 4277 | 38 |
772403 | 772403 | 2020-11-27 | Bay | Michigan | 26017 | 4277 | 89 |
679939 | 679939 | 2020-10-29 | Cache | Utah | 49005 | 4277 | 11 |
666012 | 666012 | 2020-10-25 | Catawba | North Carolina | 37035 | 4277 | 61 |
611239 | 611239 | 2020-10-08 | Luzerne | Pennsylvania | 42079 | 4277 | 190 |
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);