ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where cases = 5781 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Texas 15
- Oklahoma 8
- Kentucky 6
- Missouri 5
- Tennessee 5
- Virginia 5
- Arkansas 3
- Georgia 3
- Illinois 3
- Indiana 3
- New York 3
- North Carolina 3
- Pennsylvania 3
- South Carolina 3
- Wisconsin 3
- Arizona 2
- Kansas 2
- Washington 2
- Alabama 1
- California 1
- Florida 1
- Guam 1
- Idaho 1
- Mississippi 1
- Ohio 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496112 | 2496112 | 2022-05-11 | Staunton city | Virginia | 51790 | 5781 | 116 |
2440742 | 2440742 | 2022-04-24 | Scott | Virginia | 51169 | 5781 | 110 |
2437486 | 2437486 | 2022-04-23 | Scott | Virginia | 51169 | 5781 | 110 |
2434230 | 2434230 | 2022-04-22 | Scott | Virginia | 51169 | 5781 | 110 |
2400492 | 2400492 | 2022-04-12 | Essex | New York | 36031 | 5781 | 59 |
2377788 | 2377788 | 2022-04-05 | Greene | North Carolina | 37079 | 5781 | 61 |
2362286 | 2362286 | 2022-03-31 | Frio | Texas | 48163 | 5781 | 93 |
2357926 | 2357926 | 2022-03-30 | Stone | Missouri | 29209 | 5781 | 120 |
2315594 | 2315594 | 2022-03-17 | McDonald | Missouri | 29119 | 5781 | 66 |
2312341 | 2312341 | 2022-03-16 | McDonald | Missouri | 29119 | 5781 | 66 |
2309088 | 2309088 | 2022-03-15 | McDonald | Missouri | 29119 | 5781 | 66 |
2305836 | 2305836 | 2022-03-14 | McDonald | Missouri | 29119 | 5781 | 66 |
2236751 | 2236751 | 2022-02-21 | Owen | Indiana | 18119 | 5781 | 112 |
2150342 | 2150342 | 2022-01-25 | Garvin | Oklahoma | 40049 | 5781 | 115 |
2147090 | 2147090 | 2022-01-24 | Garvin | Oklahoma | 40049 | 5781 | 115 |
2143836 | 2143836 | 2022-01-23 | Garvin | Oklahoma | 40049 | 5781 | 115 |
2140581 | 2140581 | 2022-01-22 | Garvin | Oklahoma | 40049 | 5781 | 115 |
2137325 | 2137325 | 2022-01-21 | Garvin | Oklahoma | 40049 | 5781 | 115 |
2134071 | 2134071 | 2022-01-20 | Garvin | Oklahoma | 40049 | 5781 | 115 |
2130819 | 2130819 | 2022-01-19 | Garvin | Oklahoma | 40049 | 5781 | 115 |
2102805 | 2102805 | 2022-01-11 | St. Francis | Arkansas | 5123 | 5781 | 74 |
2098556 | 2098556 | 2022-01-09 | Clarendon | South Carolina | 45027 | 5781 | 138 |
2095304 | 2095304 | 2022-01-08 | Clarendon | South Carolina | 45027 | 5781 | 138 |
2092052 | 2092052 | 2022-01-07 | Clarendon | South Carolina | 45027 | 5781 | 138 |
2087447 | 2087447 | 2022-01-06 | Marshall | Kentucky | 21157 | 5781 | 88 |
1997759 | 1997759 | 2021-12-09 | Unknown | Puerto Rico | 5781 | 3274 | |
1986232 | 1986232 | 2021-12-06 | Fulton | Illinois | 17057 | 5781 | 96 |
1978147 | 1978147 | 2021-12-03 | Greene | Pennsylvania | 42059 | 5781 | 67 |
1919886 | 1919886 | 2021-11-15 | Claiborne | Tennessee | 47025 | 5781 | 114 |
1903960 | 1903960 | 2021-11-10 | Washington | Texas | 48477 | 5781 | 130 |
1900710 | 1900710 | 2021-11-09 | Washington | Texas | 48477 | 5781 | 130 |
1895706 | 1895706 | 2021-11-08 | Taylor | Kentucky | 21217 | 5781 | 85 |
1896584 | 1896584 | 2021-11-08 | Scotland | North Carolina | 37165 | 5781 | 107 |
1892456 | 1892456 | 2021-11-07 | Taylor | Kentucky | 21217 | 5781 | 85 |
1889206 | 1889206 | 2021-11-06 | Taylor | Kentucky | 21217 | 5781 | 85 |
1885956 | 1885956 | 2021-11-05 | Taylor | Kentucky | 21217 | 5781 | 85 |
1877837 | 1877837 | 2021-11-02 | Howard | Texas | 48227 | 5781 | 135 |
1874588 | 1874588 | 2021-11-01 | Howard | Texas | 48227 | 5781 | 135 |
1862111 | 1862111 | 2021-10-29 | Chambers | Alabama | 1017 | 5781 | 142 |
1836221 | 1836221 | 2021-10-21 | Baxter | Arkansas | 5005 | 5781 | 176 |
1823654 | 1823654 | 2021-10-17 | Wayne | Georgia | 13305 | 5781 | 166 |
1820405 | 1820405 | 2021-10-16 | Wayne | Georgia | 13305 | 5781 | 166 |
1817156 | 1817156 | 2021-10-15 | Wayne | Georgia | 13305 | 5781 | 166 |
1784716 | 1784716 | 2021-10-05 | Nez Perce | Idaho | 16069 | 5781 | 86 |
1768530 | 1768530 | 2021-09-30 | Livingston | Illinois | 17105 | 5781 | 108 |
1738084 | 1738084 | 2021-09-20 | Erath | Texas | 48143 | 5781 | 87 |
1734834 | 1734834 | 2021-09-19 | Erath | Texas | 48143 | 5781 | 87 |
1731584 | 1731584 | 2021-09-18 | Erath | Texas | 48143 | 5781 | 86 |
1608800 | 1608800 | 2021-08-12 | Graham | Arizona | 4009 | 5781 | 89 |
1568315 | 1568315 | 2021-07-30 | Cattaraugus | New York | 36009 | 5781 | 93 |
1553402 | 1553402 | 2021-07-25 | Grant | Wisconsin | 55043 | 5781 | 95 |
1550155 | 1550155 | 2021-07-24 | Grant | Wisconsin | 55043 | 5781 | 95 |
1546908 | 1546908 | 2021-07-23 | Grant | Wisconsin | 55043 | 5781 | 95 |
1539175 | 1539175 | 2021-07-21 | Edgecombe | North Carolina | 37065 | 5781 | 113 |
1444021 | 1444021 | 2021-06-22 | Ford | Kansas | 20057 | 5781 | 76 |
1440776 | 1440776 | 2021-06-21 | Ford | Kansas | 20057 | 5781 | 76 |
1415783 | 1415783 | 2021-06-13 | Wayne | New York | 36117 | 5781 | 70 |
1388534 | 1388534 | 2021-06-05 | Clinton | Illinois | 17027 | 5781 | 100 |
1341368 | 1341368 | 2021-05-21 | Union | Ohio | 39159 | 5781 | 49 |
1329166 | 1329166 | 2021-05-17 | Albemarle | Virginia | 51003 | 5781 | 83 |
1317237 | 1317237 | 2021-05-14 | Henry | Indiana | 18065 | 5781 | 106 |
1286834 | 1286834 | 2021-05-04 | Navarro | Texas | 48349 | 5781 | 154 |
1283588 | 1283588 | 2021-05-03 | Navarro | Texas | 48349 | 5781 | 154 |
1280341 | 1280341 | 2021-05-02 | Navarro | Texas | 48349 | 5781 | 154 |
1277094 | 1277094 | 2021-05-01 | Navarro | Texas | 48349 | 5781 | 154 |
1237896 | 1237896 | 2021-04-19 | Hawkins | Tennessee | 47073 | 5781 | 106 |
1110842 | 1110842 | 2021-03-11 | Carter | Oklahoma | 40019 | 5781 | 63 |
1108017 | 1108017 | 2021-03-10 | Loudon | Tennessee | 47105 | 5781 | 66 |
1089334 | 1089334 | 2021-03-05 | Crittenden | Arkansas | 5035 | 5781 | 91 |
1089427 | 1089427 | 2021-03-05 | San Benito | California | 6069 | 5781 | 61 |
1076053 | 1076053 | 2021-02-28 | Kitsap | Washington | 53035 | 5781 | 84 |
1072807 | 1072807 | 2021-02-27 | Kitsap | Washington | 53035 | 5781 | 84 |
1057815 | 1057815 | 2021-02-23 | Laurel | Kentucky | 21125 | 5781 | 25 |
1054957 | 1054957 | 2021-02-22 | Lamar | Mississippi | 28073 | 5781 | 79 |
1013856 | 1013856 | 2021-02-09 | Cumberland | Tennessee | 47035 | 5781 | 106 |
1008789 | 1008789 | 2021-02-08 | Dubois | Indiana | 18037 | 5781 | 102 |
961923 | 961923 | 2021-01-24 | Coffee | Tennessee | 47031 | 5781 | 82 |
930562 | 930562 | 2021-01-15 | Walton | Florida | 12131 | 5781 | 59 |
825789 | 825789 | 2020-12-13 | Gregg | Texas | 48183 | 5781 | 127 |
822542 | 822542 | 2020-12-12 | Gregg | Texas | 48183 | 5781 | 127 |
819296 | 819296 | 2020-12-11 | Gregg | Texas | 48183 | 5781 | 126 |
693833 | 693833 | 2020-11-03 | Unknown | Guam | 5781 | 81 | |
601511 | 601511 | 2020-10-05 | Lehigh | Pennsylvania | 42077 | 5781 | 355 |
566904 | 566904 | 2020-09-25 | Navajo | Arizona | 4017 | 5781 | 234 |
459079 | 459079 | 2020-08-22 | Berks | Pennsylvania | 42011 | 5781 | 377 |
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);