ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 6213 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Arkansas 7
- Oklahoma 7
- Texas 7
- Minnesota 6
- Illinois 5
- Virginia 5
- Alabama 4
- Indiana 4
- Maryland 3
- Michigan 3
- Colorado 2
- Mississippi 2
- Pennsylvania 2
- Puerto Rico 2
- Wisconsin 2
- Connecticut 1
- Delaware 1
- Florida 1
- Georgia 1
- Missouri 1
- North Carolina 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493346 | 2493346 | 2022-05-11 | Montezuma | Colorado | 8083 | 6213 | 81 |
2451338 | 2451338 | 2022-04-28 | Crawford | Illinois | 17033 | 6213 | 61 |
2440698 | 2440698 | 2022-04-24 | Lee | Virginia | 51105 | 6213 | 94 |
2437442 | 2437442 | 2022-04-23 | Lee | Virginia | 51105 | 6213 | 94 |
2434186 | 2434186 | 2022-04-22 | Lee | Virginia | 51105 | 6213 | 94 |
2417316 | 2417316 | 2022-04-17 | Vega Alta | Puerto Rico | 72143 | 6213 | |
2323821 | 2323821 | 2022-03-20 | Geneva | Alabama | 1061 | 6213 | 162 |
2320567 | 2320567 | 2022-03-19 | Geneva | Alabama | 1061 | 6213 | 162 |
2317313 | 2317313 | 2022-03-18 | Geneva | Alabama | 1061 | 6213 | 162 |
2164580 | 2164580 | 2022-01-30 | Johnson | Arkansas | 5071 | 6213 | 65 |
2161325 | 2161325 | 2022-01-29 | Johnson | Arkansas | 5071 | 6213 | 65 |
2158069 | 2158069 | 2022-01-28 | Johnson | Arkansas | 5071 | 6213 | 65 |
2157391 | 2157391 | 2022-01-27 | Hale | Texas | 48189 | 6213 | 220 |
2143064 | 2143064 | 2022-01-23 | Unknown | Minnesota | 6213 | 140 | |
2139809 | 2139809 | 2022-01-22 | Unknown | Minnesota | 6213 | 140 | |
2136553 | 2136553 | 2022-01-21 | Unknown | Minnesota | 6213 | 140 | |
2087706 | 2087706 | 2022-01-06 | Carlton | Minnesota | 27017 | 6213 | 81 |
1920315 | 1920315 | 2021-11-15 | Franklin | Virginia | 51067 | 6213 | 108 |
1813508 | 1813508 | 2021-10-14 | Independence | Arkansas | 5063 | 6213 | 154 |
1776671 | 1776671 | 2021-10-02 | Huntingdon | Pennsylvania | 42061 | 6213 | 146 |
1768281 | 1768281 | 2021-09-30 | Bryan | Georgia | 13029 | 6213 | 56 |
1770633 | 1770633 | 2021-09-30 | Kerr | Texas | 48265 | 6213 | 117 |
1740848 | 1740848 | 2021-09-21 | Pittsburg | Oklahoma | 40121 | 6213 | 87 |
1737599 | 1737599 | 2021-09-20 | Pittsburg | Oklahoma | 40121 | 6213 | 87 |
1734349 | 1734349 | 2021-09-19 | Pittsburg | Oklahoma | 40121 | 6213 | 87 |
1731099 | 1731099 | 2021-09-18 | Pittsburg | Oklahoma | 40121 | 6213 | 87 |
1727849 | 1727849 | 2021-09-17 | Pittsburg | Oklahoma | 40121 | 6213 | 87 |
1724600 | 1724600 | 2021-09-16 | Pittsburg | Oklahoma | 40121 | 6213 | 87 |
1721351 | 1721351 | 2021-09-15 | Pittsburg | Oklahoma | 40121 | 6213 | 87 |
1690557 | 1690557 | 2021-09-06 | Knox | Illinois | 17095 | 6213 | 190 |
1687307 | 1687307 | 2021-09-05 | Knox | Illinois | 17095 | 6213 | 190 |
1684057 | 1684057 | 2021-09-04 | Knox | Illinois | 17095 | 6213 | 190 |
1680806 | 1680806 | 2021-09-03 | Knox | Illinois | 17095 | 6213 | 190 |
1642432 | 1642432 | 2021-08-22 | Barry | Michigan | 26015 | 6213 | 72 |
1639182 | 1639182 | 2021-08-21 | Barry | Michigan | 26015 | 6213 | 72 |
1640199 | 1640199 | 2021-08-21 | Armstrong | Pennsylvania | 42005 | 6213 | 148 |
1635932 | 1635932 | 2021-08-20 | Barry | Michigan | 26015 | 6213 | 72 |
1616774 | 1616774 | 2021-08-14 | Pettis | Missouri | 29159 | 6213 | 82 |
1504896 | 1504896 | 2021-07-11 | Crittenden | Arkansas | 5035 | 6213 | 97 |
1501650 | 1501650 | 2021-07-10 | Crittenden | Arkansas | 5035 | 6213 | 97 |
1498404 | 1498404 | 2021-07-09 | Crittenden | Arkansas | 5035 | 6213 | 97 |
1479064 | 1479064 | 2021-07-03 | Garfield | Colorado | 8045 | 6213 | 50 |
1463906 | 1463906 | 2021-06-28 | Chisago | Minnesota | 27025 | 6213 | 52 |
1460661 | 1460661 | 2021-06-27 | Chisago | Minnesota | 27025 | 6213 | 52 |
1437358 | 1437358 | 2021-06-20 | Marshall | Indiana | 18099 | 6213 | 118 |
1434111 | 1434111 | 2021-06-19 | Marshall | Indiana | 18099 | 6213 | 118 |
1424344 | 1424344 | 2021-06-16 | Dubois | Indiana | 18037 | 6213 | 119 |
1334183 | 1334183 | 2021-05-19 | Lafayette | Mississippi | 28071 | 6213 | 119 |
1309384 | 1309384 | 2021-05-11 | Anderson | Texas | 48001 | 6213 | 122 |
1231773 | 1231773 | 2021-04-17 | Bedford | Virginia | 51019 | 6213 | 97 |
1176783 | 1176783 | 2021-03-31 | Calumet | Wisconsin | 55015 | 6213 | 50 |
1152349 | 1152349 | 2021-03-24 | Lowndes | Mississippi | 28087 | 6213 | 143 |
1125674 | 1125674 | 2021-03-16 | Morgan | Indiana | 18109 | 6213 | 135 |
1046307 | 1046307 | 2021-02-19 | Coffee | Tennessee | 47031 | 6213 | 112 |
989795 | 989795 | 2021-02-02 | Allegany | Maryland | 24001 | 6213 | 186 |
973587 | 973587 | 2021-01-28 | Wicomico | Maryland | 24045 | 6213 | 125 |
893147 | 893147 | 2021-01-03 | Caldwell | North Carolina | 37027 | 6213 | 31 |
857876 | 857876 | 2020-12-23 | Carolina | Puerto Rico | 72031 | 6213 | |
834040 | 834040 | 2020-12-16 | Washington | Maryland | 24043 | 6213 | 103 |
796614 | 796614 | 2020-12-04 | Johnson | Texas | 48251 | 6213 | 113 |
771201 | 771201 | 2020-11-27 | Marshall | Alabama | 1095 | 6213 | 55 |
764483 | 764483 | 2020-11-24 | Franklin | Washington | 53021 | 6213 | 73 |
722012 | 722012 | 2020-11-11 | Midland | Texas | 48329 | 6213 | 103 |
718769 | 718769 | 2020-11-10 | Midland | Texas | 48329 | 6213 | 103 |
709462 | 709462 | 2020-11-07 | Sheboygan | Wisconsin | 55117 | 6213 | 33 |
473327 | 473327 | 2020-08-27 | Lake | Florida | 12069 | 6213 | 99 |
447461 | 447461 | 2020-08-19 | Sussex | Delaware | 10005 | 6213 | 194 |
353242 | 353242 | 2020-07-20 | Cameron | Texas | 48061 | 6213 | 111 |
56734 | 56734 | 2020-04-14 | Fairfield | Connecticut | 9001 | 6213 | 287 |
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);