ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 4675 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 18
- Georgia 13
- Texas 11
- Oklahoma 8
- Kentucky 6
- Minnesota 6
- Arkansas 5
- Illinois 5
- Colorado 4
- Indiana 4
- Mississippi 3
- Missouri 3
- North Carolina 3
- Ohio 3
- Puerto Rico 3
- Wisconsin 3
- Florida 2
- Maryland 2
- New Mexico 2
- Pennsylvania 2
- Utah 2
- West Virginia 2
- Alabama 1
- Louisiana 1
- Massachusetts 1
- Michigan 1
- New York 1
- Oregon 1
- South Carolina 1
- Vermont 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500341 | 2500341 | 2022-05-13 | Perry | Indiana | 18123 | 4675 | 69 |
2473417 | 2473417 | 2022-05-04 | Adams | Wisconsin | 55001 | 4675 | 61 |
2467429 | 2467429 | 2022-05-03 | Crisp | Georgia | 13081 | 4675 | 136 |
2464174 | 2464174 | 2022-05-02 | Crisp | Georgia | 13081 | 4675 | 136 |
2460918 | 2460918 | 2022-05-01 | Crisp | Georgia | 13081 | 4675 | 136 |
2457662 | 2457662 | 2022-04-30 | Crisp | Georgia | 13081 | 4675 | 136 |
2454406 | 2454406 | 2022-04-29 | Crisp | Georgia | 13081 | 4675 | 136 |
2451150 | 2451150 | 2022-04-28 | Crisp | Georgia | 13081 | 4675 | 136 |
2452959 | 2452959 | 2022-04-28 | Clatsop | Oregon | 41007 | 4675 | 49 |
2447894 | 2447894 | 2022-04-27 | Crisp | Georgia | 13081 | 4675 | 136 |
2327176 | 2327176 | 2022-03-21 | Drew | Arkansas | 5043 | 4675 | 69 |
2315638 | 2315638 | 2022-03-17 | Texas | Missouri | 29215 | 4675 | 96 |
2312385 | 2312385 | 2022-03-16 | Texas | Missouri | 29215 | 4675 | 96 |
2197578 | 2197578 | 2022-02-09 | Clark | Illinois | 17023 | 4675 | 55 |
2194814 | 2194814 | 2022-02-08 | Rockcastle | Kentucky | 21203 | 4675 | 51 |
2164546 | 2164546 | 2022-01-30 | Ashley | Arkansas | 5003 | 4675 | 56 |
2161291 | 2161291 | 2022-01-29 | Ashley | Arkansas | 5003 | 4675 | 56 |
2158035 | 2158035 | 2022-01-28 | Ashley | Arkansas | 5003 | 4675 | 56 |
2139625 | 2139625 | 2022-01-22 | Somerset | Maryland | 24039 | 4675 | 64 |
2126192 | 2126192 | 2022-01-18 | Boone | Iowa | 19015 | 4675 | 46 |
2122247 | 2122247 | 2022-01-17 | Arkansas | Arkansas | 5001 | 4675 | 67 |
2122940 | 2122940 | 2022-01-17 | Boone | Iowa | 19015 | 4675 | 46 |
2119173 | 2119173 | 2022-01-16 | Morgan | Colorado | 8087 | 4675 | 128 |
2119688 | 2119688 | 2022-01-16 | Boone | Iowa | 19015 | 4675 | 46 |
2115921 | 2115921 | 2022-01-15 | Morgan | Colorado | 8087 | 4675 | 128 |
2116436 | 2116436 | 2022-01-15 | Boone | Iowa | 19015 | 4675 | 46 |
2117986 | 2117986 | 2022-01-15 | Cidra | Puerto Rico | 72041 | 4675 | |
2112670 | 2112670 | 2022-01-14 | Morgan | Colorado | 8087 | 4675 | 128 |
2113185 | 2113185 | 2022-01-14 | Boone | Iowa | 19015 | 4675 | 46 |
2109933 | 2109933 | 2022-01-13 | Boone | Iowa | 19015 | 4675 | 46 |
2106682 | 2106682 | 2022-01-12 | Boone | Iowa | 19015 | 4675 | 46 |
2061108 | 2061108 | 2021-12-29 | LaGrange | Indiana | 18087 | 4675 | 95 |
2062796 | 2062796 | 2021-12-29 | Edgefield | South Carolina | 45037 | 4675 | 60 |
2054932 | 2054932 | 2021-12-27 | Lincoln | Kentucky | 21137 | 4675 | 106 |
2024494 | 2024494 | 2021-12-17 | Nicholas | West Virginia | 54067 | 4675 | 71 |
2011280 | 2011280 | 2021-12-13 | Washington | Vermont | 50023 | 4675 | 30 |
2005136 | 2005136 | 2021-12-12 | Geneva | Alabama | 1061 | 4675 | 137 |
1987104 | 1987104 | 2021-12-06 | Barry | Missouri | 29009 | 4675 | 91 |
1918760 | 1918760 | 2021-11-15 | Adams | Mississippi | 28001 | 4675 | 125 |
1906684 | 1906684 | 2021-11-11 | Arecibo | Puerto Rico | 72013 | 4675 | |
1880671 | 1880671 | 2021-11-03 | Tioga | Pennsylvania | 42117 | 4675 | 133 |
1875970 | 1875970 | 2021-11-02 | Plymouth | Iowa | 19149 | 4675 | 88 |
1872721 | 1872721 | 2021-11-01 | Plymouth | Iowa | 19149 | 4675 | 88 |
1869472 | 1869472 | 2021-10-31 | Plymouth | Iowa | 19149 | 4675 | 88 |
1866223 | 1866223 | 2021-10-30 | Plymouth | Iowa | 19149 | 4675 | 88 |
1862974 | 1862974 | 2021-10-29 | Plymouth | Iowa | 19149 | 4675 | 88 |
1859725 | 1859725 | 2021-10-28 | Plymouth | Iowa | 19149 | 4675 | 88 |
1856476 | 1856476 | 2021-10-27 | Plymouth | Iowa | 19149 | 4675 | 88 |
1755908 | 1755908 | 2021-09-26 | Clark | Kentucky | 21049 | 4675 | 32 |
1752660 | 1752660 | 2021-09-25 | Clark | Kentucky | 21049 | 4675 | 32 |
1749411 | 1749411 | 2021-09-24 | Clark | Kentucky | 21049 | 4675 | 32 |
1733514 | 1733514 | 2021-09-19 | Morrison | Minnesota | 27097 | 4675 | 63 |
1734454 | 1734454 | 2021-09-19 | Pike | Pennsylvania | 42103 | 4675 | 56 |
1730264 | 1730264 | 2021-09-18 | Morrison | Minnesota | 27097 | 4675 | 63 |
1727014 | 1727014 | 2021-09-17 | Morrison | Minnesota | 27097 | 4675 | 63 |
1713673 | 1713673 | 2021-09-13 | Clay | Kentucky | 21051 | 4675 | 51 |
1695264 | 1695264 | 2021-09-07 | Logan | Ohio | 39091 | 4675 | 80 |
1619112 | 1619112 | 2021-08-15 | Monroe | Illinois | 17133 | 4675 | 96 |
1620508 | 1620508 | 2021-08-15 | Ashland | Ohio | 39005 | 4675 | 99 |
1615864 | 1615864 | 2021-08-14 | Monroe | Illinois | 17133 | 4675 | 96 |
1612615 | 1612615 | 2021-08-13 | Monroe | Illinois | 17133 | 4675 | 96 |
1599687 | 1599687 | 2021-08-09 | Harrison | Indiana | 18061 | 4675 | 79 |
1597062 | 1597062 | 2021-08-08 | Itasca | Minnesota | 27061 | 4675 | 68 |
1593813 | 1593813 | 2021-08-07 | Itasca | Minnesota | 27061 | 4675 | 68 |
1590564 | 1590564 | 2021-08-06 | Itasca | Minnesota | 27061 | 4675 | 68 |
1533500 | 1533500 | 2021-07-19 | Kerr | Texas | 48265 | 4675 | 93 |
1530253 | 1530253 | 2021-07-18 | Kerr | Texas | 48265 | 4675 | 93 |
1527006 | 1527006 | 2021-07-17 | Kerr | Texas | 48265 | 4675 | 93 |
1478533 | 1478533 | 2021-07-02 | Henry | Virginia | 51089 | 4675 | 124 |
1473770 | 1473770 | 2021-07-01 | Oktibbeha | Mississippi | 28105 | 4675 | 98 |
1470524 | 1470524 | 2021-06-30 | Oktibbeha | Mississippi | 28105 | 4675 | 98 |
1440676 | 1440676 | 2021-06-21 | Des Moines | Iowa | 19057 | 4675 | 72 |
1437429 | 1437429 | 2021-06-20 | Des Moines | Iowa | 19057 | 4675 | 72 |
1434182 | 1434182 | 2021-06-19 | Des Moines | Iowa | 19057 | 4675 | 72 |
1399825 | 1399825 | 2021-06-08 | Delaware | Oklahoma | 40041 | 4675 | 94 |
1396580 | 1396580 | 2021-06-07 | Delaware | Oklahoma | 40041 | 4675 | 94 |
1393333 | 1393333 | 2021-06-06 | Delaware | Oklahoma | 40041 | 4675 | 94 |
1390088 | 1390088 | 2021-06-05 | Delaware | Oklahoma | 40041 | 4675 | 94 |
1386843 | 1386843 | 2021-06-04 | Delaware | Oklahoma | 40041 | 4675 | 94 |
1383598 | 1383598 | 2021-06-03 | Delaware | Oklahoma | 40041 | 4675 | 94 |
1380352 | 1380352 | 2021-06-02 | Delaware | Oklahoma | 40041 | 4675 | 94 |
1381086 | 1381086 | 2021-06-02 | Wasatch | Utah | 49051 | 4675 | 22 |
1377674 | 1377674 | 2021-06-01 | Howard | Texas | 48227 | 4675 | 101 |
1377841 | 1377841 | 2021-06-01 | Wasatch | Utah | 49051 | 4675 | 22 |
1374428 | 1374428 | 2021-05-31 | Howard | Texas | 48227 | 4675 | 101 |
1371183 | 1371183 | 2021-05-30 | Howard | Texas | 48227 | 4675 | 101 |
1365643 | 1365643 | 2021-05-29 | Effingham | Georgia | 13103 | 4675 | 69 |
1354127 | 1354127 | 2021-05-25 | Beaufort | North Carolina | 37013 | 4675 | 95 |
1342418 | 1342418 | 2021-05-21 | Marinette | Wisconsin | 55075 | 4675 | 69 |
1300924 | 1300924 | 2021-05-09 | Macoupin | Illinois | 17117 | 4675 | 110 |
1285208 | 1285208 | 2021-05-04 | St. Mary | Louisiana | 22101 | 4675 | 136 |
1269657 | 1269657 | 2021-04-29 | Clinton | New York | 36019 | 4675 | 33 |
1202743 | 1202743 | 2021-04-08 | Putnam | West Virginia | 54079 | 4675 | 98 |
1189013 | 1189013 | 2021-04-04 | Unknown | Puerto Rico | 4675 | 2126 | |
1164375 | 1164375 | 2021-03-28 | Murray | Georgia | 13213 | 4675 | 78 |
1155970 | 1155970 | 2021-03-25 | Otero | New Mexico | 35035 | 4675 | 71 |
1152723 | 1152723 | 2021-03-24 | Otero | New Mexico | 35035 | 4675 | 71 |
1112669 | 1112669 | 2021-03-12 | Jackson | Indiana | 18071 | 4675 | 68 |
1109543 | 1109543 | 2021-03-11 | Marshall | Iowa | 19127 | 4675 | 73 |
1089745 | 1089745 | 2021-03-05 | Ware | Georgia | 13299 | 4675 | 150 |
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);