ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where cases = 4873 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 11
- Ohio 10
- Michigan 8
- Indiana 6
- Louisiana 6
- Arkansas 5
- Vermont 5
- Nevada 4
- Illinois 3
- Mississippi 3
- Texas 3
- Virginia 3
- Florida 2
- Idaho 2
- Missouri 2
- New York 2
- North Carolina 2
- Pennsylvania 2
- South Carolina 2
- Tennessee 2
- Wisconsin 2
- Alabama 1
- California 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421950 | 2421950 | 2022-04-19 | Union | Georgia | 13291 | 4873 | 155 |
2418694 | 2418694 | 2022-04-18 | Union | Georgia | 13291 | 4873 | 155 |
2405670 | 2405670 | 2022-04-14 | Union | Georgia | 13291 | 4873 | 155 |
2372256 | 2372256 | 2022-04-03 | Orange | Vermont | 50017 | 4873 | 14 |
2369003 | 2369003 | 2022-04-02 | Orange | Vermont | 50017 | 4873 | 14 |
2365750 | 2365750 | 2022-04-01 | Orange | Vermont | 50017 | 4873 | 14 |
2352761 | 2352761 | 2022-03-28 | Buchanan | Virginia | 51027 | 4873 | 110 |
2333217 | 2333217 | 2022-03-22 | Orange | Vermont | 50017 | 4873 | 14 |
2307987 | 2307987 | 2022-03-15 | Hart | Georgia | 13147 | 4873 | 89 |
2268926 | 2268926 | 2022-03-03 | Cook | Georgia | 13075 | 4873 | 70 |
2265975 | 2265975 | 2022-03-02 | Fulton | Indiana | 18049 | 4873 | 101 |
2259171 | 2259171 | 2022-02-28 | Cook | Georgia | 13075 | 4873 | 69 |
2260002 | 2260002 | 2022-02-28 | Charlevoix | Michigan | 26029 | 4873 | 58 |
2223133 | 2223133 | 2022-02-17 | Lincoln | Arkansas | 5079 | 4873 | 62 |
2172164 | 2172164 | 2022-02-01 | Somerset | Maryland | 24039 | 4873 | 67 |
2143760 | 2143760 | 2022-01-23 | Holmes | Ohio | 39075 | 4873 | 167 |
2112129 | 2112129 | 2022-01-13 | Louisa | Virginia | 51109 | 4873 | 53 |
2051919 | 2051919 | 2021-12-26 | Oceana | Michigan | 26127 | 4873 | 84 |
2048669 | 2048669 | 2021-12-25 | Oceana | Michigan | 26127 | 4873 | 84 |
2045419 | 2045419 | 2021-12-24 | Oceana | Michigan | 26127 | 4873 | 84 |
2042169 | 2042169 | 2021-12-23 | Oceana | Michigan | 26127 | 4873 | 84 |
2038920 | 2038920 | 2021-12-22 | Oceana | Michigan | 26127 | 4873 | 84 |
2036288 | 2036288 | 2021-12-21 | Cherokee | North Carolina | 37039 | 4873 | 87 |
2032347 | 2032347 | 2021-12-20 | Franklin | Massachusetts | 25011 | 4873 | 128 |
1986053 | 1986053 | 2021-12-06 | Gilmer | Georgia | 13123 | 4873 | 138 |
1940273 | 1940273 | 2021-11-22 | St. Francis | Arkansas | 5123 | 4873 | 69 |
1940612 | 1940612 | 2021-11-22 | Stephens | Georgia | 13257 | 4873 | 119 |
1937023 | 1937023 | 2021-11-21 | St. Francis | Arkansas | 5123 | 4873 | 69 |
1938329 | 1938329 | 2021-11-21 | Tippah | Mississippi | 28139 | 4873 | 82 |
1938621 | 1938621 | 2021-11-21 | Nye | Nevada | 32023 | 4873 | 166 |
1935079 | 1935079 | 2021-11-20 | Tippah | Mississippi | 28139 | 4873 | 82 |
1935371 | 1935371 | 2021-11-20 | Nye | Nevada | 32023 | 4873 | 166 |
1931829 | 1931829 | 2021-11-19 | Tippah | Mississippi | 28139 | 4873 | 82 |
1932121 | 1932121 | 2021-11-19 | Nye | Nevada | 32023 | 4873 | 166 |
1896364 | 1896364 | 2021-11-08 | Douglas | Nevada | 32005 | 4873 | 64 |
1851404 | 1851404 | 2021-10-25 | Jefferson | Pennsylvania | 42065 | 4873 | 118 |
1813200 | 1813200 | 2021-10-13 | Okanogan | Washington | 53047 | 4873 | 70 |
1795479 | 1795479 | 2021-10-08 | Warren | Missouri | 29219 | 4873 | 43 |
1791188 | 1791188 | 2021-10-07 | Bonner | Idaho | 16017 | 4873 | 74 |
1777671 | 1777671 | 2021-10-03 | Marion | Alabama | 1093 | 4873 | 125 |
1741535 | 1741535 | 2021-09-21 | Sanpete | Utah | 49039 | 4873 | 30 |
1727767 | 1727767 | 2021-09-17 | Preble | Ohio | 39135 | 4873 | 110 |
1700324 | 1700324 | 2021-09-09 | Morgan | Illinois | 17137 | 4873 | 117 |
1697988 | 1697988 | 2021-09-08 | Polk | Missouri | 29167 | 4873 | 52 |
1690679 | 1690679 | 2021-09-06 | Putnam | Indiana | 18133 | 4873 | 68 |
1687429 | 1687429 | 2021-09-05 | Putnam | Indiana | 18133 | 4873 | 68 |
1684179 | 1684179 | 2021-09-04 | Putnam | Indiana | 18133 | 4873 | 68 |
1680928 | 1680928 | 2021-09-03 | Putnam | Indiana | 18133 | 4873 | 68 |
1670594 | 1670594 | 2021-08-31 | Union | Arkansas | 5139 | 4873 | 118 |
1643964 | 1643964 | 2021-08-22 | Matagorda | Texas | 48321 | 4873 | 117 |
1633865 | 1633865 | 2021-08-19 | Dillon | South Carolina | 45033 | 4873 | 87 |
1602148 | 1602148 | 2021-08-09 | Monroe | Wisconsin | 55081 | 4873 | 51 |
1561824 | 1561824 | 2021-07-28 | Clinton | New York | 36019 | 4873 | 33 |
1441964 | 1441964 | 2021-06-21 | Mercer | Ohio | 39107 | 4873 | 85 |
1438719 | 1438719 | 2021-06-20 | Mercer | Ohio | 39107 | 4873 | 85 |
1435472 | 1435472 | 2021-06-19 | Mercer | Ohio | 39107 | 4873 | 85 |
1432225 | 1432225 | 2021-06-18 | Mercer | Ohio | 39107 | 4873 | 85 |
1428979 | 1428979 | 2021-06-17 | Mercer | Ohio | 39107 | 4873 | 85 |
1425734 | 1425734 | 2021-06-16 | Mercer | Ohio | 39107 | 4873 | 85 |
1415996 | 1415996 | 2021-06-13 | Mercer | Ohio | 39107 | 4873 | 85 |
1410853 | 1410853 | 2021-06-12 | Nevada | California | 6057 | 4873 | 75 |
1412750 | 1412750 | 2021-06-12 | Mercer | Ohio | 39107 | 4873 | 85 |
1398960 | 1398960 | 2021-06-08 | Newaygo | Michigan | 26123 | 4873 | 68 |
1381776 | 1381776 | 2021-06-03 | Hendry | Florida | 12051 | 4873 | 87 |
1378746 | 1378746 | 2021-06-02 | Bingham | Idaho | 16011 | 4873 | 76 |
1315978 | 1315978 | 2021-05-13 | Harrison | Texas | 48203 | 4873 | 109 |
1309009 | 1309009 | 2021-05-11 | Linn | Oregon | 41043 | 4873 | 67 |
1296825 | 1296825 | 2021-05-07 | Washington | Virginia | 51191 | 4873 | 107 |
1278180 | 1278180 | 2021-05-02 | Henry | Illinois | 17073 | 4873 | 92 |
1268329 | 1268329 | 2021-04-29 | Tift | Georgia | 13277 | 4873 | 125 |
1270096 | 1270096 | 2021-04-29 | Huntingdon | Pennsylvania | 42061 | 4873 | 128 |
1231199 | 1231199 | 2021-04-17 | Guaynabo | Puerto Rico | 72061 | 4873 | |
1110004 | 1110004 | 2021-03-11 | St. Joseph | Michigan | 26149 | 4873 | 87 |
1100328 | 1100328 | 2021-03-08 | Otter Tail | Minnesota | 27111 | 4873 | 71 |
1096869 | 1096869 | 2021-03-07 | St. Martin | Louisiana | 22099 | 4873 | 112 |
1093623 | 1093623 | 2021-03-06 | St. Martin | Louisiana | 22099 | 4873 | 112 |
1090377 | 1090377 | 2021-03-05 | St. Martin | Louisiana | 22099 | 4873 | 112 |
1086101 | 1086101 | 2021-03-04 | Hot Spring | Arkansas | 5059 | 4873 | 66 |
1077403 | 1077403 | 2021-03-01 | Vermilion | Louisiana | 22113 | 4873 | 107 |
1075888 | 1075888 | 2021-02-28 | Chittenden | Vermont | 50007 | 4873 | 88 |
1016591 | 1016591 | 2021-02-10 | Morton | North Dakota | 38059 | 4873 | 94 |
1000287 | 1000287 | 2021-02-05 | Lenoir | North Carolina | 37107 | 4873 | 96 |
985757 | 985757 | 2021-02-01 | Catoosa | Georgia | 13047 | 4873 | 53 |
971008 | 971008 | 2021-01-27 | Steuben | New York | 36101 | 4873 | 133 |
966388 | 966388 | 2021-01-26 | Spalding | Georgia | 13255 | 4873 | 125 |
963345 | 963345 | 2021-01-25 | Dearborn | Indiana | 18029 | 4873 | 47 |
923590 | 923590 | 2021-01-12 | Barron | Wisconsin | 55005 | 4873 | 58 |
919776 | 919776 | 2021-01-11 | McMinn | Tennessee | 47107 | 4873 | 72 |
859381 | 859381 | 2020-12-24 | Boone | Illinois | 17007 | 4873 | 63 |
838618 | 838618 | 2020-12-17 | Hamblen | Tennessee | 47063 | 4873 | 70 |
771501 | 771501 | 2020-11-27 | Hernando | Florida | 12053 | 4873 | 207 |
707413 | 707413 | 2020-11-07 | Rapides | Louisiana | 22079 | 4873 | 163 |
704170 | 704170 | 2020-11-06 | Rapides | Louisiana | 22079 | 4873 | 163 |
582451 | 582451 | 2020-09-29 | Ector | Texas | 48135 | 4873 | 99 |
565989 | 565989 | 2020-09-24 | Florence | South Carolina | 45041 | 4873 | 187 |
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);