ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where cases = 4729 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 11
- Texas 9
- Illinois 8
- Georgia 7
- Oklahoma 7
- Pennsylvania 5
- Virginia 5
- Michigan 4
- Ohio 4
- Wyoming 4
- Arkansas 3
- Minnesota 3
- Montana 3
- New Hampshire 3
- New York 3
- West Virginia 3
- Colorado 2
- Florida 2
- Mississippi 2
- Missouri 2
- North Carolina 2
- Puerto Rico 2
- Wisconsin 2
- Alabama 1
- Idaho 1
- Indiana 1
- Iowa 1
- Kentucky 1
- Maryland 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499335 | 2499335 | 2022-05-12 | New Kent | Virginia | 51127 | 4729 | 31 |
2479490 | 2479490 | 2022-05-06 | Gonzales | Texas | 48177 | 4729 | 99 |
2416548 | 2416548 | 2022-04-17 | Lincoln | Montana | 30053 | 4729 | 86 |
2413292 | 2413292 | 2022-04-16 | Lincoln | Montana | 30053 | 4729 | 86 |
2410036 | 2410036 | 2022-04-15 | Lincoln | Montana | 30053 | 4729 | 86 |
2401230 | 2401230 | 2022-04-12 | Polk | Tennessee | 47139 | 4729 | 71 |
2397975 | 2397975 | 2022-04-11 | Polk | Tennessee | 47139 | 4729 | 71 |
2394720 | 2394720 | 2022-04-10 | Polk | Tennessee | 47139 | 4729 | 71 |
2391464 | 2391464 | 2022-04-09 | Polk | Tennessee | 47139 | 4729 | 71 |
2388208 | 2388208 | 2022-04-08 | Polk | Tennessee | 47139 | 4729 | 71 |
2384953 | 2384953 | 2022-04-07 | Polk | Tennessee | 47139 | 4729 | 71 |
2381698 | 2381698 | 2022-04-06 | Polk | Tennessee | 47139 | 4729 | 71 |
2356587 | 2356587 | 2022-03-30 | Elbert | Colorado | 8039 | 4729 | 37 |
2285067 | 2285067 | 2022-03-08 | Teller | Colorado | 8119 | 4729 | 55 |
2271200 | 2271200 | 2022-03-03 | Fayette | Texas | 48149 | 4729 | 99 |
2267948 | 2267948 | 2022-03-02 | Fayette | Texas | 48149 | 4729 | 99 |
2258908 | 2258908 | 2022-02-28 | Phillips | Arkansas | 5107 | 4729 | 93 |
2255657 | 2255657 | 2022-02-27 | Phillips | Arkansas | 5107 | 4729 | 93 |
2226009 | 2226009 | 2022-02-17 | Powhatan | Virginia | 51145 | 4729 | 45 |
2193674 | 2193674 | 2022-02-07 | Taylor | Wisconsin | 55119 | 4729 | 65 |
2155346 | 2155346 | 2022-01-27 | Pike | Illinois | 17149 | 4729 | 65 |
2148610 | 2148610 | 2022-01-25 | Fannin | Georgia | 13111 | 4729 | 124 |
2130688 | 2130688 | 2022-01-19 | Rolette | North Dakota | 38079 | 4729 | 37 |
2125499 | 2125499 | 2022-01-18 | Arkansas | Arkansas | 5001 | 4729 | 67 |
2110630 | 2110630 | 2022-01-13 | Audrain | Missouri | 29007 | 4729 | 89 |
2034046 | 2034046 | 2021-12-20 | Amherst | Virginia | 51009 | 4729 | 62 |
2034246 | 2034246 | 2021-12-20 | Nicholas | West Virginia | 54067 | 4729 | 73 |
1993196 | 1993196 | 2021-12-08 | Ohio | Kentucky | 21183 | 4729 | 89 |
1990113 | 1990113 | 2021-12-07 | Clare | Michigan | 26035 | 4729 | 121 |
1986863 | 1986863 | 2021-12-06 | Clare | Michigan | 26035 | 4729 | 121 |
1964308 | 1964308 | 2021-11-29 | Leflore | Mississippi | 28083 | 4729 | 144 |
1913973 | 1913973 | 2021-11-13 | Mingo | West Virginia | 54059 | 4729 | 83 |
1873219 | 1873219 | 2021-11-01 | Lyon | Minnesota | 27083 | 4729 | 56 |
1860339 | 1860339 | 2021-10-28 | Tippah | Mississippi | 28139 | 4729 | 81 |
1854257 | 1854257 | 2021-10-26 | Washington | New York | 36115 | 4729 | 68 |
1837383 | 1837383 | 2021-10-21 | Huron | Michigan | 26063 | 4729 | 89 |
1839271 | 1839271 | 2021-10-21 | Clark | Wisconsin | 55019 | 4729 | 78 |
1834134 | 1834134 | 2021-10-20 | Huron | Michigan | 26063 | 4729 | 89 |
1812240 | 1812240 | 2021-10-13 | Ottawa | Ohio | 39123 | 4729 | 86 |
1786275 | 1786275 | 2021-10-05 | Adair | Oklahoma | 40001 | 4729 | 55 |
1781358 | 1781358 | 2021-10-04 | Lumpkin | Georgia | 13187 | 4729 | 92 |
1783026 | 1783026 | 2021-10-04 | Adair | Oklahoma | 40001 | 4729 | 55 |
1779777 | 1779777 | 2021-10-03 | Adair | Oklahoma | 40001 | 4729 | 55 |
1776527 | 1776527 | 2021-10-02 | Adair | Oklahoma | 40001 | 4729 | 55 |
1773277 | 1773277 | 2021-10-01 | Adair | Oklahoma | 40001 | 4729 | 55 |
1770027 | 1770027 | 2021-09-30 | Adair | Oklahoma | 40001 | 4729 | 55 |
1766778 | 1766778 | 2021-09-29 | Adair | Oklahoma | 40001 | 4729 | 55 |
1754754 | 1754754 | 2021-09-25 | Logan | West Virginia | 54045 | 4729 | 117 |
1745878 | 1745878 | 2021-09-23 | Jefferson | Indiana | 18077 | 4729 | 93 |
1711184 | 1711184 | 2021-09-12 | Grafton | New Hampshire | 33009 | 4729 | 30 |
1707937 | 1707937 | 2021-09-11 | Grafton | New Hampshire | 33009 | 4729 | 30 |
1704690 | 1704690 | 2021-09-10 | Grafton | New Hampshire | 33009 | 4729 | 30 |
1667758 | 1667758 | 2021-08-30 | Nez Perce | Idaho | 16069 | 4729 | 66 |
1657214 | 1657214 | 2021-08-26 | Shenandoah | Virginia | 51171 | 4729 | 137 |
1652798 | 1652798 | 2021-08-25 | Livingston | New York | 36051 | 4729 | 60 |
1626809 | 1626809 | 2021-08-17 | Madison | New York | 36053 | 4729 | 89 |
1576850 | 1576850 | 2021-08-02 | Jefferson | Illinois | 17081 | 4729 | 124 |
1490803 | 1490803 | 2021-07-06 | Bedford | Pennsylvania | 42009 | 4729 | 142 |
1487556 | 1487556 | 2021-07-05 | Bedford | Pennsylvania | 42009 | 4729 | 142 |
1484309 | 1484309 | 2021-07-04 | Bedford | Pennsylvania | 42009 | 4729 | 142 |
1481063 | 1481063 | 2021-07-03 | Bedford | Pennsylvania | 42009 | 4729 | 142 |
1481751 | 1481751 | 2021-07-03 | Culpeper | Virginia | 51047 | 4729 | 67 |
1462564 | 1462564 | 2021-06-27 | Sweetwater | Wyoming | 56037 | 4729 | 40 |
1456519 | 1456519 | 2021-06-26 | Effingham | Georgia | 13103 | 4729 | 73 |
1459319 | 1459319 | 2021-06-26 | Sweetwater | Wyoming | 56037 | 4729 | 40 |
1453274 | 1453274 | 2021-06-25 | Effingham | Georgia | 13103 | 4729 | 72 |
1456074 | 1456074 | 2021-06-25 | Sweetwater | Wyoming | 56037 | 4729 | 40 |
1403163 | 1403163 | 2021-06-09 | Yamhill | Oregon | 41071 | 4729 | 78 |
1373826 | 1373826 | 2021-05-31 | Shelby | Ohio | 39149 | 4729 | 94 |
1370581 | 1370581 | 2021-05-30 | Shelby | Ohio | 39149 | 4729 | 94 |
1356809 | 1356809 | 2021-05-26 | Douglas | Minnesota | 27041 | 4729 | 79 |
1348123 | 1348123 | 2021-05-23 | Toa Alta | Puerto Rico | 72135 | 4729 | |
1330143 | 1330143 | 2021-05-18 | Macoupin | Illinois | 17117 | 4729 | 113 |
1326865 | 1326865 | 2021-05-17 | Effingham | Illinois | 17049 | 4729 | 83 |
1323419 | 1323419 | 2021-05-16 | Colquitt | Georgia | 13071 | 4729 | 121 |
1323619 | 1323619 | 2021-05-16 | Effingham | Illinois | 17049 | 4729 | 83 |
1317126 | 1317126 | 2021-05-14 | Effingham | Illinois | 17049 | 4729 | 83 |
1313879 | 1313879 | 2021-05-13 | Effingham | Illinois | 17049 | 4729 | 83 |
1310632 | 1310632 | 2021-05-12 | Effingham | Illinois | 17049 | 4729 | 83 |
1284902 | 1284902 | 2021-05-04 | Muscatine | Iowa | 19139 | 4729 | 99 |
1215323 | 1215323 | 2021-04-12 | Harrison | Texas | 48203 | 4729 | 105 |
1212076 | 1212076 | 2021-04-11 | Harrison | Texas | 48203 | 4729 | 105 |
1157923 | 1157923 | 2021-03-26 | Ware | Georgia | 13299 | 4729 | 157 |
1156444 | 1156444 | 2021-03-25 | Mifflin | Pennsylvania | 42087 | 4729 | 175 |
1154117 | 1154117 | 2021-03-24 | Campbell | Wyoming | 56005 | 4729 | 59 |
1124220 | 1124220 | 2021-03-15 | Fayette | Tennessee | 47047 | 4729 | 75 |
1099473 | 1099473 | 2021-03-08 | Tift | Georgia | 13277 | 4729 | 120 |
1097636 | 1097636 | 2021-03-07 | Edgecombe | North Carolina | 37065 | 4729 | 100 |
1094388 | 1094388 | 2021-03-06 | Edgecombe | North Carolina | 37065 | 4729 | 100 |
1078775 | 1078775 | 2021-03-01 | Franklin | Tennessee | 47051 | 4729 | 85 |
1029087 | 1029087 | 2021-02-14 | Joplin | Missouri | 4729 | 100 | |
1025675 | 1025675 | 2021-02-13 | Otter Tail | Minnesota | 27111 | 4729 | 70 |
919770 | 919770 | 2021-01-11 | Loudon | Tennessee | 47105 | 4729 | 46 |
887987 | 887987 | 2021-01-02 | Blount | Alabama | 1009 | 4729 | 63 |
890075 | 890075 | 2021-01-02 | Hancock | Ohio | 39063 | 4729 | 81 |
737792 | 737792 | 2020-11-16 | Carolina | Puerto Rico | 72031 | 4729 | |
699119 | 699119 | 2020-11-04 | Putnam | Tennessee | 47141 | 4729 | 64 |
685379 | 685379 | 2020-10-31 | McKinley | New Mexico | 35031 | 4729 | 261 |
671791 | 671791 | 2020-10-27 | Frederick | Maryland | 24021 | 4729 | 139 |
663277 | 663277 | 2020-10-24 | Dorchester | South Carolina | 45035 | 4729 | 100 |
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);