ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 3780 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 8
- Georgia 7
- Texas 7
- Illinois 6
- Ohio 6
- Virginia 6
- Kansas 5
- Pennsylvania 5
- Wisconsin 5
- Arkansas 4
- Kentucky 4
- Missouri 4
- South Carolina 4
- Tennessee 4
- Alaska 3
- Indiana 3
- Mississippi 3
- Nebraska 3
- New Mexico 3
- North Carolina 3
- Vermont 3
- Arizona 2
- Colorado 2
- Iowa 2
- Minnesota 2
- New Jersey 2
- Puerto Rico 2
- Wyoming 2
- Alabama 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475776 | 2475776 | 2022-05-05 | Tillamook | Oregon | 41057 | 3780 | 64 |
2419511 | 2419511 | 2022-04-18 | Faribault | Minnesota | 27043 | 3780 | 51 |
2408076 | 2408076 | 2022-04-14 | Appomattox | Virginia | 51011 | 3780 | 52 |
2326711 | 2326711 | 2022-03-20 | Lamoille | Vermont | 50015 | 3780 | 17 |
2323458 | 2323458 | 2022-03-19 | Lamoille | Vermont | 50015 | 3780 | 17 |
2320204 | 2320204 | 2022-03-18 | Lamoille | Vermont | 50015 | 3780 | 17 |
2304216 | 2304216 | 2022-03-13 | Marquette | Wisconsin | 55077 | 3780 | 56 |
2300964 | 2300964 | 2022-03-12 | Marquette | Wisconsin | 55077 | 3780 | 56 |
2297712 | 2297712 | 2022-03-11 | Marquette | Wisconsin | 55077 | 3780 | 56 |
2293109 | 2293109 | 2022-03-10 | Socorro | New Mexico | 35053 | 3780 | 86 |
2294460 | 2294460 | 2022-03-10 | Marquette | Wisconsin | 55077 | 3780 | 55 |
2289541 | 2289541 | 2022-03-09 | Dallas | Missouri | 29059 | 3780 | 70 |
2289857 | 2289857 | 2022-03-09 | Socorro | New Mexico | 35053 | 3780 | 86 |
2284839 | 2284839 | 2022-03-08 | Ketchikan Gateway Borough | Alaska | 2130 | 3780 | 17 |
2286289 | 2286289 | 2022-03-08 | Dallas | Missouri | 29059 | 3780 | 70 |
2286605 | 2286605 | 2022-03-08 | Socorro | New Mexico | 35053 | 3780 | 85 |
2281587 | 2281587 | 2022-03-07 | Ketchikan Gateway Borough | Alaska | 2130 | 3780 | 17 |
2246085 | 2246085 | 2022-02-24 | Hamilton | Florida | 12047 | 3780 | 52 |
2242834 | 2242834 | 2022-02-23 | Hamilton | Florida | 12047 | 3780 | 52 |
2244121 | 2244121 | 2022-02-23 | Glacier | Montana | 30035 | 3780 | 67 |
2239583 | 2239583 | 2022-02-22 | Hamilton | Florida | 12047 | 3780 | 51 |
2236332 | 2236332 | 2022-02-21 | Hamilton | Florida | 12047 | 3780 | 51 |
2236649 | 2236649 | 2022-02-21 | Massac | Illinois | 17127 | 3780 | 67 |
2233081 | 2233081 | 2022-02-20 | Hamilton | Florida | 12047 | 3780 | 51 |
2233398 | 2233398 | 2022-02-20 | Massac | Illinois | 17127 | 3780 | 67 |
2229830 | 2229830 | 2022-02-19 | Hamilton | Florida | 12047 | 3780 | 51 |
2230147 | 2230147 | 2022-02-19 | Massac | Illinois | 17127 | 3780 | 67 |
2226579 | 2226579 | 2022-02-18 | Hamilton | Florida | 12047 | 3780 | 51 |
2226896 | 2226896 | 2022-02-18 | Massac | Illinois | 17127 | 3780 | 67 |
2225611 | 2225611 | 2022-02-17 | Andrews | Texas | 48003 | 3780 | 70 |
2222711 | 2222711 | 2022-02-16 | Goochland | Virginia | 51075 | 3780 | 42 |
2209502 | 2209502 | 2022-02-12 | Llano | Texas | 48299 | 3780 | 91 |
2129354 | 2129354 | 2022-01-19 | Carroll | Indiana | 18015 | 3780 | 53 |
2102893 | 2102893 | 2022-01-11 | Elbert | Colorado | 8039 | 3780 | 31 |
2083682 | 2083682 | 2022-01-05 | Blaine | Idaho | 16013 | 3780 | 27 |
2085885 | 2085885 | 2022-01-05 | Lampasas | Texas | 48281 | 3780 | 71 |
2082551 | 2082551 | 2022-01-04 | Deaf Smith | Texas | 48117 | 3780 | 100 |
1996404 | 1996404 | 2021-12-09 | Harrison | Kentucky | 21097 | 3780 | 52 |
1937752 | 1937752 | 2021-11-21 | Cherokee | Kansas | 20021 | 3780 | 78 |
1934502 | 1934502 | 2021-11-20 | Cherokee | Kansas | 20021 | 3780 | 78 |
1931251 | 1931251 | 2021-11-19 | Cherokee | Kansas | 20021 | 3780 | 78 |
1875544 | 1875544 | 2021-11-02 | Fannin | Georgia | 13111 | 3780 | 106 |
1872295 | 1872295 | 2021-11-01 | Fannin | Georgia | 13111 | 3780 | 106 |
1859316 | 1859316 | 2021-10-28 | Harris | Georgia | 13145 | 3780 | 86 |
1826822 | 1826822 | 2021-10-18 | Haralson | Georgia | 13143 | 3780 | 113 |
1803793 | 1803793 | 2021-10-11 | Sevier | Arkansas | 5133 | 3780 | 50 |
1767379 | 1767379 | 2021-09-29 | Karnes | Texas | 48255 | 3780 | 51 |
1736953 | 1736953 | 2021-09-20 | Miller | Missouri | 29131 | 3780 | 70 |
1721521 | 1721521 | 2021-09-15 | Mayaguez | Puerto Rico | 72097 | 3780 | |
1645915 | 1645915 | 2021-08-23 | Tippah | Mississippi | 28139 | 3780 | 74 |
1612134 | 1612134 | 2021-08-13 | Yell | Arkansas | 5149 | 3780 | 66 |
1604540 | 1604540 | 2021-08-10 | Arecibo | Puerto Rico | 72013 | 3780 | |
1580637 | 1580637 | 2021-08-03 | Vernon | Louisiana | 22115 | 3780 | 111 |
1578332 | 1578332 | 2021-08-02 | Ottawa | Ohio | 39123 | 3780 | 81 |
1512031 | 1512031 | 2021-07-13 | Putnam | Indiana | 18133 | 3780 | 62 |
1409465 | 1409465 | 2021-06-11 | Clinton | Ohio | 39027 | 3780 | 66 |
1406220 | 1406220 | 2021-06-10 | Clinton | Ohio | 39027 | 3780 | 66 |
1397468 | 1397468 | 2021-06-07 | York | Virginia | 51199 | 3780 | 55 |
1394221 | 1394221 | 2021-06-06 | York | Virginia | 51199 | 3780 | 55 |
1385343 | 1385343 | 2021-06-04 | Montgomery | Illinois | 17135 | 3780 | 80 |
1358134 | 1358134 | 2021-05-26 | Cooke | Texas | 48097 | 3780 | 72 |
1354888 | 1354888 | 2021-05-25 | Cooke | Texas | 48097 | 3780 | 72 |
1355460 | 1355460 | 2021-05-25 | Teton | Wyoming | 56039 | 3780 | 9 |
1352214 | 1352214 | 2021-05-24 | Teton | Wyoming | 56039 | 3780 | 9 |
1346575 | 1346575 | 2021-05-23 | Lee | Iowa | 19111 | 3780 | 55 |
1336123 | 1336123 | 2021-05-20 | Independence | Arkansas | 5063 | 3780 | 124 |
1256144 | 1256144 | 2021-04-25 | Beltrami | Minnesota | 27007 | 3780 | 57 |
1203332 | 1203332 | 2021-04-09 | Liberty | Georgia | 13179 | 3780 | 60 |
1187167 | 1187167 | 2021-04-04 | Maui | Hawaii | 15009 | 3780 | 41 |
1176941 | 1176941 | 2021-04-01 | Bethel Census Area | Alaska | 2050 | 3780 | 20 |
1168999 | 1168999 | 2021-03-29 | Livingston | New York | 36051 | 3780 | 58 |
1134940 | 1134940 | 2021-03-19 | Logan | Colorado | 8075 | 3780 | 65 |
1123737 | 1123737 | 2021-03-15 | Brown | Ohio | 39015 | 3780 | 52 |
1120978 | 1120978 | 2021-03-14 | Giles | Tennessee | 47055 | 3780 | 97 |
1117731 | 1117731 | 2021-03-13 | Giles | Tennessee | 47055 | 3780 | 97 |
1114484 | 1114484 | 2021-03-12 | Giles | Tennessee | 47055 | 3780 | 97 |
1068945 | 1068945 | 2021-02-26 | Williamsburg | South Carolina | 45089 | 3780 | 88 |
1055772 | 1055772 | 2021-02-22 | Bedford | Pennsylvania | 42009 | 3780 | 128 |
1003062 | 1003062 | 2021-02-06 | Union | Mississippi | 28145 | 3780 | 70 |
1000280 | 1000280 | 2021-02-05 | Hoke | North Carolina | 37093 | 3780 | 51 |
996824 | 996824 | 2021-02-04 | Platte | Nebraska | 31141 | 3780 | 46 |
987265 | 987265 | 2021-02-01 | Carteret | North Carolina | 37031 | 3780 | 19 |
974052 | 974052 | 2021-01-28 | Dakota | Nebraska | 31043 | 3780 | 67 |
970807 | 970807 | 2021-01-27 | Dakota | Nebraska | 31043 | 3780 | 67 |
964755 | 964755 | 2021-01-25 | Putnam | Ohio | 39137 | 3780 | 75 |
953942 | 953942 | 2021-01-22 | Henderson | Kentucky | 21101 | 3780 | 53 |
906346 | 906346 | 2021-01-07 | Shelby | Ohio | 39149 | 3780 | 20 |
902922 | 902922 | 2021-01-06 | Lee | North Carolina | 37105 | 3780 | 44 |
896663 | 896663 | 2021-01-04 | Le Flore | Oklahoma | 40079 | 3780 | 30 |
878965 | 878965 | 2020-12-30 | Dearborn | Indiana | 18029 | 3780 | 42 |
874192 | 874192 | 2020-12-28 | Georgetown | South Carolina | 45043 | 3780 | 78 |
849043 | 849043 | 2020-12-21 | Autauga | Alabama | 1001 | 3780 | 44 |
849713 | 849713 | 2020-12-21 | Ogle | Illinois | 17141 | 3780 | 61 |
843566 | 843566 | 2020-12-19 | Bullitt | Kentucky | 21029 | 3780 | 27 |
844989 | 844989 | 2020-12-19 | Greenwood | South Carolina | 45047 | 3780 | 91 |
841623 | 841623 | 2020-12-18 | Somerset | Pennsylvania | 42111 | 3780 | 51 |
819986 | 819986 | 2020-12-12 | Mississippi | Arkansas | 5093 | 3780 | 87 |
791597 | 791597 | 2020-12-03 | Riley | Kansas | 20161 | 3780 | 16 |
788352 | 788352 | 2020-12-02 | Riley | Kansas | 20161 | 3780 | 16 |
784540 | 784540 | 2020-12-01 | Bulloch | Georgia | 13031 | 3780 | 55 |
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);