ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5673 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kentucky 9
- Tennessee 9
- Virginia 7
- Alabama 4
- Arkansas 4
- Michigan 4
- Texas 4
- Wisconsin 4
- Indiana 3
- Kansas 3
- Missouri 3
- New Mexico 3
- North Carolina 3
- Colorado 2
- Louisiana 2
- Ohio 2
- Pennsylvania 2
- Puerto Rico 2
- California 1
- Delaware 1
- Georgia 1
- Idaho 1
- Maine 1
- Mississippi 1
- New Jersey 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447395 | 2447395 | 2022-04-26 | Jackson | Wisconsin | 55053 | 5673 | 43 |
2440741 | 2440741 | 2022-04-24 | Salem city | Virginia | 51775 | 5673 | 96 |
2437485 | 2437485 | 2022-04-23 | Salem city | Virginia | 51775 | 5673 | 96 |
2434229 | 2434229 | 2022-04-22 | Salem city | Virginia | 51775 | 5673 | 96 |
2380285 | 2380285 | 2022-04-06 | Franklin | Maine | 23007 | 5673 | 57 |
2330407 | 2330407 | 2022-03-22 | Arkansas | Arkansas | 5001 | 5673 | 78 |
2324793 | 2324793 | 2022-03-20 | Adair | Kentucky | 21001 | 5673 | 101 |
2321539 | 2321539 | 2022-03-19 | Adair | Kentucky | 21001 | 5673 | 101 |
2318285 | 2318285 | 2022-03-18 | Adair | Kentucky | 21001 | 5673 | 101 |
2315032 | 2315032 | 2022-03-17 | Adair | Kentucky | 21001 | 5673 | 101 |
2311779 | 2311779 | 2022-03-16 | Adair | Kentucky | 21001 | 5673 | 101 |
2308526 | 2308526 | 2022-03-15 | Adair | Kentucky | 21001 | 5673 | 101 |
2305275 | 2305275 | 2022-03-14 | Adair | Kentucky | 21001 | 5673 | 101 |
2306657 | 2306657 | 2022-03-14 | Moca | Puerto Rico | 72099 | 5673 | |
2303406 | 2303406 | 2022-03-13 | Moca | Puerto Rico | 72099 | 5673 | |
2297173 | 2297173 | 2022-03-11 | Calhoun | Texas | 48057 | 5673 | 48 |
2293921 | 2293921 | 2022-03-10 | Calhoun | Texas | 48057 | 5673 | 48 |
2256464 | 2256464 | 2022-02-27 | Pottawatomie | Kansas | 20149 | 5673 | 55 |
2253213 | 2253213 | 2022-02-26 | Pottawatomie | Kansas | 20149 | 5673 | 55 |
2249962 | 2249962 | 2022-02-25 | Pottawatomie | Kansas | 20149 | 5673 | 55 |
2198108 | 2198108 | 2022-02-09 | Grant | Louisiana | 22043 | 5673 | 84 |
2198447 | 2198447 | 2022-02-09 | Sunflower | Mississippi | 28133 | 5673 | 116 |
2199390 | 2199390 | 2022-02-09 | Barnwell | South Carolina | 45011 | 5673 | 91 |
2153241 | 2153241 | 2022-01-26 | Grant | New Mexico | 35017 | 5673 | 70 |
2129784 | 2129784 | 2022-01-19 | Franklin | Louisiana | 22041 | 5673 | 145 |
2131327 | 2131327 | 2022-01-19 | DeWitt | Texas | 48123 | 5673 | 86 |
2083893 | 2083893 | 2022-01-05 | Scott | Indiana | 18143 | 5673 | 85 |
2082193 | 2082193 | 2022-01-04 | Warren | Pennsylvania | 42123 | 5673 | 180 |
2076636 | 2076636 | 2022-01-03 | Dallas | Alabama | 1047 | 5673 | 212 |
1935901 | 1935901 | 2021-11-20 | McKean | Pennsylvania | 42083 | 5673 | 100 |
1905087 | 1905087 | 2021-11-11 | Jasper | Indiana | 18073 | 5673 | 92 |
1825679 | 1825679 | 2021-10-17 | Henderson | Tennessee | 47077 | 5673 | 99 |
1822430 | 1822430 | 2021-10-16 | Henderson | Tennessee | 47077 | 5673 | 99 |
1819181 | 1819181 | 2021-10-15 | Henderson | Tennessee | 47077 | 5673 | 99 |
1816228 | 1816228 | 2021-10-14 | Washington | Texas | 48477 | 5673 | 124 |
1782972 | 1782972 | 2021-10-04 | Highland | Ohio | 39071 | 5673 | 92 |
1765219 | 1765219 | 2021-09-29 | Nez Perce | Idaho | 16069 | 5673 | 85 |
1725346 | 1725346 | 2021-09-16 | Culpeper | Virginia | 51047 | 5673 | 70 |
1697985 | 1697985 | 2021-09-08 | Phelps | Missouri | 29161 | 5673 | 169 |
1691417 | 1691417 | 2021-09-06 | Butler | Missouri | 29023 | 5673 | 60 |
1678421 | 1678421 | 2021-09-02 | Camden | Missouri | 29029 | 5673 | 114 |
1611253 | 1611253 | 2021-08-12 | Franklin | Tennessee | 47051 | 5673 | 92 |
1607270 | 1607270 | 2021-08-11 | Curry | New Mexico | 35009 | 5673 | 87 |
1576232 | 1576232 | 2021-08-02 | Dale | Alabama | 1045 | 5673 | 117 |
1575579 | 1575579 | 2021-08-01 | Warren | Tennessee | 47177 | 5673 | 85 |
1572331 | 1572331 | 2021-07-31 | Warren | Tennessee | 47177 | 5673 | 85 |
1569083 | 1569083 | 2021-07-30 | Warren | Tennessee | 47177 | 5673 | 85 |
1564476 | 1564476 | 2021-07-29 | Chippewa | Michigan | 26033 | 5673 | 51 |
1561228 | 1561228 | 2021-07-28 | Chippewa | Michigan | 26033 | 5673 | 51 |
1557980 | 1557980 | 2021-07-27 | Chippewa | Michigan | 26033 | 5673 | 51 |
1537379 | 1537379 | 2021-07-21 | Hot Spring | Arkansas | 5059 | 5673 | 78 |
1472319 | 1472319 | 2021-07-01 | Coffee | Alabama | 1031 | 5673 | 128 |
1469074 | 1469074 | 2021-06-30 | Coffee | Alabama | 1031 | 5673 | 128 |
1385928 | 1385928 | 2021-06-04 | Branch | Michigan | 26023 | 5673 | 120 |
1264235 | 1264235 | 2021-04-27 | Albemarle | Virginia | 51003 | 5673 | 82 |
1238783 | 1238783 | 2021-04-20 | Lassen | California | 6035 | 5673 | 24 |
1238847 | 1238847 | 2021-04-20 | Garfield | Colorado | 8045 | 5673 | 38 |
1232000 | 1232000 | 2021-04-17 | Columbia | Wisconsin | 55021 | 5673 | 69 |
1198315 | 1198315 | 2021-04-07 | Lenoir | North Carolina | 37107 | 5673 | 109 |
1195066 | 1195066 | 2021-04-06 | Lenoir | North Carolina | 37107 | 5673 | 109 |
1186878 | 1186878 | 2021-04-04 | Fremont | Colorado | 8043 | 5673 | 53 |
1172333 | 1172333 | 2021-03-30 | Lee | North Carolina | 37105 | 5673 | 73 |
1150851 | 1150851 | 2021-03-23 | Sauk | Wisconsin | 55111 | 5673 | 50 |
1147604 | 1147604 | 2021-03-22 | Sauk | Wisconsin | 55111 | 5673 | 50 |
1076381 | 1076381 | 2021-03-01 | Mississippi | Arkansas | 5093 | 5673 | 105 |
1072311 | 1072311 | 2021-02-27 | Loudon | Tennessee | 47105 | 5673 | 65 |
979609 | 979609 | 2021-01-30 | Morgan | Indiana | 18109 | 5673 | 105 |
948942 | 948942 | 2021-01-20 | Coffee | Tennessee | 47031 | 5673 | 82 |
907910 | 907910 | 2021-01-08 | Glynn | Georgia | 13127 | 5673 | 136 |
876075 | 876075 | 2020-12-29 | Madison | Kentucky | 21151 | 5673 | 36 |
874765 | 874765 | 2020-12-28 | Newport News city | Virginia | 51700 | 5673 | 66 |
807020 | 807020 | 2020-12-08 | Saline | Arkansas | 5125 | 5673 | 68 |
805417 | 805417 | 2020-12-07 | Chaves | New Mexico | 35005 | 5673 | 50 |
781947 | 781947 | 2020-11-30 | Kenton | Kentucky | 21117 | 5673 | 64 |
754610 | 754610 | 2020-11-21 | Arlington | Virginia | 51013 | 5673 | 156 |
702668 | 702668 | 2020-11-05 | Washington | Utah | 49053 | 5673 | 47 |
436330 | 436330 | 2020-08-15 | Lucas | Ohio | 39095 | 5673 | 329 |
395907 | 395907 | 2020-08-03 | Sussex | Delaware | 10005 | 5673 | 191 |
146862 | 146862 | 2020-05-15 | Mercer | New Jersey | 34021 | 5673 | 386 |
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);