ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where cases = 4225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 13
- Mississippi 12
- Tennessee 11
- Texas 11
- Kentucky 10
- Indiana 9
- Minnesota 6
- Virginia 5
- West Virginia 5
- Georgia 4
- Kansas 4
- Puerto Rico 4
- Alabama 3
- Idaho 3
- Louisiana 3
- Michigan 3
- North Carolina 3
- Ohio 3
- California 2
- Colorado 2
- Florida 2
- Iowa 2
- Missouri 2
- Nevada 2
- New York 2
- Pennsylvania 2
- South Carolina 2
- Vermont 2
- Alaska 1
- Arkansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492413 | 2492413 | 2022-05-10 | Sequatchie | Tennessee | 47153 | 4225 | 68 |
2489155 | 2489155 | 2022-05-09 | Sequatchie | Tennessee | 47153 | 4225 | 68 |
2485898 | 2485898 | 2022-05-08 | Sequatchie | Tennessee | 47153 | 4225 | 68 |
2482640 | 2482640 | 2022-05-07 | Sequatchie | Tennessee | 47153 | 4225 | 68 |
2479382 | 2479382 | 2022-05-06 | Sequatchie | Tennessee | 47153 | 4225 | 68 |
2476124 | 2476124 | 2022-05-05 | Sequatchie | Tennessee | 47153 | 4225 | 68 |
2471906 | 2471906 | 2022-05-04 | Park | Montana | 30067 | 4225 | 35 |
2472657 | 2472657 | 2022-05-04 | San German | Puerto Rico | 72125 | 4225 | |
2472867 | 2472867 | 2022-05-04 | Sequatchie | Tennessee | 47153 | 4225 | 68 |
2461551 | 2461551 | 2022-05-01 | Knott | Kentucky | 21119 | 4225 | 63 |
2458295 | 2458295 | 2022-04-30 | Knott | Kentucky | 21119 | 4225 | 63 |
2455039 | 2455039 | 2022-04-29 | Knott | Kentucky | 21119 | 4225 | 63 |
2451783 | 2451783 | 2022-04-28 | Knott | Kentucky | 21119 | 4225 | 63 |
2448527 | 2448527 | 2022-04-27 | Knott | Kentucky | 21119 | 4225 | 63 |
2445271 | 2445271 | 2022-04-26 | Knott | Kentucky | 21119 | 4225 | 63 |
2442015 | 2442015 | 2022-04-25 | Knott | Kentucky | 21119 | 4225 | 63 |
2439106 | 2439106 | 2022-04-24 | Wadena | Minnesota | 27159 | 4225 | 55 |
2435850 | 2435850 | 2022-04-23 | Wadena | Minnesota | 27159 | 4225 | 55 |
2432594 | 2432594 | 2022-04-22 | Wadena | Minnesota | 27159 | 4225 | 55 |
2422128 | 2422128 | 2022-04-19 | Carroll | Indiana | 18015 | 4225 | 68 |
2418872 | 2418872 | 2022-04-18 | Carroll | Indiana | 18015 | 4225 | 68 |
2373737 | 2373737 | 2022-04-04 | LaSalle | Louisiana | 22059 | 4225 | 56 |
2370762 | 2370762 | 2022-04-03 | Clarke | Mississippi | 28023 | 4225 | 108 |
2367509 | 2367509 | 2022-04-02 | Clarke | Mississippi | 28023 | 4225 | 108 |
2364256 | 2364256 | 2022-04-01 | Clarke | Mississippi | 28023 | 4225 | 108 |
2361002 | 2361002 | 2022-03-31 | Clarke | Mississippi | 28023 | 4225 | 108 |
2357748 | 2357748 | 2022-03-30 | Clarke | Mississippi | 28023 | 4225 | 108 |
2354495 | 2354495 | 2022-03-29 | Clarke | Mississippi | 28023 | 4225 | 108 |
2351243 | 2351243 | 2022-03-28 | Clarke | Mississippi | 28023 | 4225 | 108 |
2336686 | 2336686 | 2022-03-23 | Morgan | West Virginia | 54065 | 4225 | 68 |
2330887 | 2330887 | 2022-03-22 | Minidoka | Idaho | 16067 | 4225 | 62 |
2333432 | 2333432 | 2022-03-22 | Morgan | West Virginia | 54065 | 4225 | 68 |
2316443 | 2316443 | 2022-03-17 | Yabucoa | Puerto Rico | 72151 | 4225 | |
2307043 | 2307043 | 2022-03-14 | Lee | Texas | 48287 | 4225 | 60 |
2303792 | 2303792 | 2022-03-13 | Lee | Texas | 48287 | 4225 | 60 |
2300540 | 2300540 | 2022-03-12 | Lee | Texas | 48287 | 4225 | 60 |
2291874 | 2291874 | 2022-03-10 | Carroll | Illinois | 17015 | 4225 | 48 |
2288622 | 2288622 | 2022-03-09 | Carroll | Illinois | 17015 | 4225 | 48 |
2235882 | 2235882 | 2022-02-20 | Taylor | West Virginia | 54091 | 4225 | 62 |
2232631 | 2232631 | 2022-02-19 | Taylor | West Virginia | 54091 | 4225 | 62 |
2229380 | 2229380 | 2022-02-18 | Taylor | West Virginia | 54091 | 4225 | 62 |
2183508 | 2183508 | 2022-02-04 | Panola | Texas | 48365 | 4225 | 117 |
2171119 | 2171119 | 2022-02-01 | Sharp | Arkansas | 5135 | 4225 | 85 |
2167889 | 2167889 | 2022-01-31 | Inyo | California | 6027 | 4225 | 50 |
2157055 | 2157055 | 2022-01-27 | Morovis | Puerto Rico | 72101 | 4225 | |
2148738 | 2148738 | 2022-01-25 | Cassia | Idaho | 16031 | 4225 | 48 |
2126086 | 2126086 | 2022-01-18 | Wayne | Illinois | 17191 | 4225 | 71 |
2118553 | 2118553 | 2022-01-15 | Orleans | Vermont | 50019 | 4225 | 31 |
2111075 | 2111075 | 2022-01-13 | Greene | North Carolina | 37079 | 4225 | 56 |
2106986 | 2106986 | 2022-01-12 | Simpson | Kentucky | 21213 | 4225 | 74 |
2063897 | 2063897 | 2021-12-30 | Montezuma | Colorado | 8083 | 4225 | 54 |
2054397 | 2054397 | 2021-12-27 | Unknown | Georgia | 4225 | 7 | |
1978605 | 1978605 | 2021-12-03 | Karnes | Texas | 48255 | 4225 | 58 |
1974847 | 1974847 | 2021-12-02 | Jefferson | Oregon | 41031 | 4225 | 66 |
1964617 | 1964617 | 2021-11-29 | Churchill | Nevada | 32001 | 4225 | 81 |
1945204 | 1945204 | 2021-11-23 | Delaware | New York | 36025 | 4225 | 51 |
1938435 | 1938435 | 2021-11-21 | Saline | Missouri | 29195 | 4225 | 81 |
1898037 | 1898037 | 2021-11-09 | Calaveras | California | 6009 | 4225 | 82 |
1897516 | 1897516 | 2021-11-08 | Rutland | Vermont | 50021 | 4225 | 30 |
1897625 | 1897625 | 2021-11-08 | Pulaski | Virginia | 51155 | 4225 | 90 |
1880896 | 1880896 | 2021-11-03 | DeKalb | Tennessee | 47041 | 4225 | 75 |
1849691 | 1849691 | 2021-10-25 | Jerome | Idaho | 16053 | 4225 | 49 |
1846496 | 1846496 | 2021-10-24 | Iroquois | Illinois | 17075 | 4225 | 79 |
1843246 | 1843246 | 2021-10-23 | Iroquois | Illinois | 17075 | 4225 | 79 |
1839996 | 1839996 | 2021-10-22 | Iroquois | Illinois | 17075 | 4225 | 79 |
1837569 | 1837569 | 2021-10-21 | Marion | Mississippi | 28091 | 4225 | 108 |
1834320 | 1834320 | 2021-10-20 | Marion | Mississippi | 28091 | 4225 | 107 |
1800407 | 1800407 | 2021-10-10 | Lawrence | Alabama | 1079 | 4225 | 111 |
1776673 | 1776673 | 2021-10-02 | Jefferson | Pennsylvania | 42065 | 4225 | 106 |
1764554 | 1764554 | 2021-09-28 | Green | Wisconsin | 55045 | 4225 | 26 |
1750667 | 1750667 | 2021-09-24 | Clinton | Pennsylvania | 42035 | 4225 | 71 |
1717964 | 1717964 | 2021-09-14 | Champaign | Ohio | 39021 | 4225 | 63 |
1713801 | 1713801 | 2021-09-13 | Morehouse | Louisiana | 22067 | 4225 | 103 |
1708242 | 1708242 | 2021-09-11 | Guernsey | Ohio | 39059 | 4225 | 55 |
1690613 | 1690613 | 2021-09-06 | Adams | Indiana | 18001 | 4225 | 64 |
1687363 | 1687363 | 2021-09-05 | Adams | Indiana | 18001 | 4225 | 64 |
1684113 | 1684113 | 2021-09-04 | Adams | Indiana | 18001 | 4225 | 64 |
1680862 | 1680862 | 2021-09-03 | Adams | Indiana | 18001 | 4225 | 64 |
1648954 | 1648954 | 2021-08-24 | Huron | Michigan | 26063 | 4225 | 84 |
1644502 | 1644502 | 2021-08-23 | Bethel Census Area | Alaska | 2050 | 4225 | 22 |
1645705 | 1645705 | 2021-08-23 | Huron | Michigan | 26063 | 4225 | 84 |
1615205 | 1615205 | 2021-08-14 | Chambers | Alabama | 1017 | 4225 | 125 |
1611956 | 1611956 | 2021-08-13 | Chambers | Alabama | 1017 | 4225 | 125 |
1583503 | 1583503 | 2021-08-04 | Whitley | Indiana | 18183 | 4225 | 45 |
1550880 | 1550880 | 2021-07-25 | Lee | Illinois | 17103 | 4225 | 93 |
1552616 | 1552616 | 2021-07-25 | Ponce | Puerto Rico | 72113 | 4225 | |
1547633 | 1547633 | 2021-07-24 | Lee | Illinois | 17103 | 4225 | 93 |
1544386 | 1544386 | 2021-07-23 | Lee | Illinois | 17103 | 4225 | 93 |
1512425 | 1512425 | 2021-07-13 | St. Bernard | Louisiana | 22087 | 4225 | 54 |
1432973 | 1432973 | 2021-06-18 | Washington | Texas | 48477 | 4225 | 94 |
1429727 | 1429727 | 2021-06-17 | Washington | Texas | 48477 | 4225 | 94 |
1403595 | 1403595 | 2021-06-09 | Erath | Texas | 48143 | 4225 | 70 |
1403764 | 1403764 | 2021-06-09 | Wharton | Texas | 48481 | 4225 | 116 |
1363330 | 1363330 | 2021-05-28 | Morrison | Minnesota | 27097 | 4225 | 60 |
1353688 | 1353688 | 2021-05-25 | Pontotoc | Mississippi | 28115 | 4225 | 73 |
1338407 | 1338407 | 2021-05-20 | Chester | South Carolina | 45023 | 4225 | 76 |
1314625 | 1314625 | 2021-05-13 | McLeod | Minnesota | 27085 | 4225 | 59 |
1278300 | 1278300 | 2021-05-02 | Montgomery | Indiana | 18107 | 4225 | 90 |
1271027 | 1271027 | 2021-04-29 | Albany | Wyoming | 56001 | 4225 | 11 |
1216796 | 1216796 | 2021-04-13 | Lyon | Kansas | 20111 | 4225 | 85 |
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);