ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 9614 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Oklahoma 14
- Indiana 11
- Missouri 8
- Tennessee 7
- Kentucky 4
- New Hampshire 4
- Texas 4
- Virginia 4
- Idaho 3
- North Carolina 3
- Ohio 3
- California 2
- Louisiana 2
- Michigan 2
- West Virginia 2
- Arkansas 1
- Connecticut 1
- Florida 1
- Maryland 1
- Nebraska 1
- Oregon 1
- Puerto Rico 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485081 | 2485081 | 2022-05-08 | Sullivan | New Hampshire | 33019 | 9614 | 68 |
2481823 | 2481823 | 2022-05-07 | Sullivan | New Hampshire | 33019 | 9614 | 68 |
2478565 | 2478565 | 2022-05-06 | Sullivan | New Hampshire | 33019 | 9614 | 68 |
2476632 | 2476632 | 2022-05-05 | Greenbrier | West Virginia | 54025 | 9614 | 159 |
2444080 | 2444080 | 2022-04-25 | Logan | West Virginia | 54045 | 9614 | 183 |
2370115 | 2370115 | 2022-04-03 | Steuben | Indiana | 18151 | 9614 | 120 |
2366862 | 2366862 | 2022-04-02 | Steuben | Indiana | 18151 | 9614 | 120 |
2363609 | 2363609 | 2022-04-01 | Steuben | Indiana | 18151 | 9614 | 120 |
2360355 | 2360355 | 2022-03-31 | Steuben | Indiana | 18151 | 9614 | 120 |
2357101 | 2357101 | 2022-03-30 | Steuben | Indiana | 18151 | 9614 | 120 |
2270611 | 2270611 | 2022-03-03 | Madison | Ohio | 39097 | 9614 | 125 |
2267359 | 2267359 | 2022-03-02 | Madison | Ohio | 39097 | 9614 | 125 |
2256289 | 2256289 | 2022-02-27 | Whitley | Indiana | 18183 | 9614 | 82 |
2253038 | 2253038 | 2022-02-26 | Whitley | Indiana | 18183 | 9614 | 82 |
2249787 | 2249787 | 2022-02-25 | Whitley | Indiana | 18183 | 9614 | 82 |
2240935 | 2240935 | 2022-02-22 | Dodge | Nebraska | 31053 | 9614 | 90 |
2231889 | 2231889 | 2022-02-19 | Trujillo Alto | Puerto Rico | 72139 | 9614 | |
2176432 | 2176432 | 2022-02-02 | Coos | Oregon | 41011 | 9614 | 132 |
2173151 | 2173151 | 2022-02-01 | Osage | Oklahoma | 40113 | 9614 | 144 |
2173538 | 2173538 | 2022-02-01 | Obion | Tennessee | 47131 | 9614 | 154 |
2169899 | 2169899 | 2022-01-31 | Osage | Oklahoma | 40113 | 9614 | 144 |
2170286 | 2170286 | 2022-01-31 | Obion | Tennessee | 47131 | 9614 | 154 |
2166644 | 2166644 | 2022-01-30 | Osage | Oklahoma | 40113 | 9614 | 144 |
2167032 | 2167032 | 2022-01-30 | Obion | Tennessee | 47131 | 9614 | 154 |
2163389 | 2163389 | 2022-01-29 | Osage | Oklahoma | 40113 | 9614 | 144 |
2163777 | 2163777 | 2022-01-29 | Obion | Tennessee | 47131 | 9614 | 154 |
2160134 | 2160134 | 2022-01-28 | Osage | Oklahoma | 40113 | 9614 | 144 |
2160522 | 2160522 | 2022-01-28 | Obion | Tennessee | 47131 | 9614 | 154 |
2156674 | 2156674 | 2022-01-27 | Yadkin | North Carolina | 37197 | 9614 | 98 |
2156879 | 2156879 | 2022-01-27 | Osage | Oklahoma | 40113 | 9614 | 144 |
2157266 | 2157266 | 2022-01-27 | Obion | Tennessee | 47131 | 9614 | 154 |
2153626 | 2153626 | 2022-01-26 | Osage | Oklahoma | 40113 | 9614 | 144 |
2154013 | 2154013 | 2022-01-26 | Obion | Tennessee | 47131 | 9614 | 154 |
2123243 | 2123243 | 2022-01-17 | Shelby | Kentucky | 21211 | 9614 | 132 |
2119623 | 2119623 | 2022-01-16 | Huntington | Indiana | 18069 | 9614 | 142 |
2119991 | 2119991 | 2022-01-16 | Shelby | Kentucky | 21211 | 9614 | 132 |
2116371 | 2116371 | 2022-01-15 | Huntington | Indiana | 18069 | 9614 | 142 |
2116739 | 2116739 | 2022-01-15 | Shelby | Kentucky | 21211 | 9614 | 132 |
2113120 | 2113120 | 2022-01-14 | Huntington | Indiana | 18069 | 9614 | 142 |
2113488 | 2113488 | 2022-01-14 | Shelby | Kentucky | 21211 | 9614 | 132 |
1816096 | 1816096 | 2021-10-14 | Henderson | Texas | 48213 | 9614 | 321 |
1812848 | 1812848 | 2021-10-13 | Henderson | Texas | 48213 | 9614 | 321 |
1809599 | 1809599 | 2021-10-12 | Henderson | Texas | 48213 | 9614 | 319 |
1718026 | 1718026 | 2021-09-14 | Scioto | Ohio | 39145 | 9614 | 124 |
1689693 | 1689693 | 2021-09-05 | Roanoke | Virginia | 51161 | 9614 | 151 |
1686443 | 1686443 | 2021-09-04 | Roanoke | Virginia | 51161 | 9614 | 151 |
1683192 | 1683192 | 2021-09-03 | Roanoke | Virginia | 51161 | 9614 | 151 |
1656165 | 1656165 | 2021-08-26 | Surry | North Carolina | 37171 | 9614 | 183 |
1637542 | 1637542 | 2021-08-20 | Walker | Texas | 48471 | 9614 | 138 |
1621860 | 1621860 | 2021-08-16 | Pope | Arkansas | 5115 | 9614 | 121 |
1561178 | 1561178 | 2021-07-28 | Carroll | Maryland | 24013 | 9614 | 256 |
1558922 | 1558922 | 2021-07-27 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1555675 | 1555675 | 2021-07-26 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1552428 | 1552428 | 2021-07-25 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1549181 | 1549181 | 2021-07-24 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1545934 | 1545934 | 2021-07-23 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1542687 | 1542687 | 2021-07-22 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1539439 | 1539439 | 2021-07-21 | Muskogee | Oklahoma | 40101 | 9614 | 178 |
1509535 | 1509535 | 2021-07-12 | Cole | Missouri | 29051 | 9614 | 130 |
1473821 | 1473821 | 2021-07-01 | Christian | Missouri | 29043 | 9614 | 97 |
1470575 | 1470575 | 2021-06-30 | Christian | Missouri | 29043 | 9614 | 96 |
1467330 | 1467330 | 2021-06-29 | Christian | Missouri | 29043 | 9614 | 96 |
1464085 | 1464085 | 2021-06-28 | Christian | Missouri | 29043 | 9614 | 93 |
1460840 | 1460840 | 2021-06-27 | Christian | Missouri | 29043 | 9614 | 93 |
1457595 | 1457595 | 2021-06-26 | Christian | Missouri | 29043 | 9614 | 93 |
1454350 | 1454350 | 2021-06-25 | Christian | Missouri | 29043 | 9614 | 93 |
1420611 | 1420611 | 2021-06-15 | Sutter | California | 6101 | 9614 | 112 |
1417366 | 1417366 | 2021-06-14 | Sutter | California | 6101 | 9614 | 112 |
1401217 | 1401217 | 2021-06-09 | Tolland | Connecticut | 9013 | 9614 | 187 |
1376724 | 1376724 | 2021-06-01 | Merrimack | New Hampshire | 33013 | 9614 | 116 |
1346322 | 1346322 | 2021-05-23 | Twin Falls | Idaho | 16083 | 9614 | 128 |
1343074 | 1343074 | 2021-05-22 | Twin Falls | Idaho | 16083 | 9614 | 128 |
1339826 | 1339826 | 2021-05-21 | Twin Falls | Idaho | 16083 | 9614 | 128 |
1304665 | 1304665 | 2021-05-10 | Lafourche | Louisiana | 22057 | 9614 | 204 |
1051559 | 1051559 | 2021-02-21 | Monroe | Michigan | 26115 | 9614 | 198 |
1048312 | 1048312 | 2021-02-20 | Monroe | Michigan | 26115 | 9614 | 198 |
975936 | 975936 | 2021-01-29 | Charlotte | Florida | 12015 | 9614 | 291 |
918344 | 918344 | 2021-01-11 | Livingston | Louisiana | 22063 | 9614 | 136 |
748234 | 748234 | 2020-11-19 | Virginia Beach city | Virginia | 51810 | 9614 | 112 |
273243 | 273243 | 2020-06-25 | Mecklenburg | North Carolina | 37119 | 9614 | 147 |
274320 | 274320 | 2020-06-25 | King | Washington | 53033 | 9614 | 608 |
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);