ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 3901 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 21
- Louisiana 11
- North Carolina 11
- Arkansas 10
- Georgia 10
- Kansas 9
- Mississippi 8
- Oklahoma 8
- Texas 6
- Virginia 6
- Wyoming 6
- Wisconsin 5
- South Carolina 4
- West Virginia 4
- Alabama 3
- Alaska 3
- Indiana 3
- Minnesota 3
- Ohio 3
- Oregon 3
- Puerto Rico 3
- Arizona 2
- Florida 2
- Michigan 2
- Missouri 2
- New York 2
- Delaware 1
- Idaho 1
- Illinois 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470398 | 2470398 | 2022-05-04 | Izard | Arkansas | 5065 | 3901 | 70 |
2467142 | 2467142 | 2022-05-03 | Izard | Arkansas | 5065 | 3901 | 70 |
2468984 | 2468984 | 2022-05-03 | Polk | North Carolina | 37149 | 3901 | 57 |
2463887 | 2463887 | 2022-05-02 | Izard | Arkansas | 5065 | 3901 | 69 |
2465728 | 2465728 | 2022-05-02 | Polk | North Carolina | 37149 | 3901 | 57 |
2460631 | 2460631 | 2022-05-01 | Izard | Arkansas | 5065 | 3901 | 69 |
2462473 | 2462473 | 2022-05-01 | Polk | North Carolina | 37149 | 3901 | 57 |
2457375 | 2457375 | 2022-04-30 | Izard | Arkansas | 5065 | 3901 | 69 |
2459217 | 2459217 | 2022-04-30 | Polk | North Carolina | 37149 | 3901 | 57 |
2454119 | 2454119 | 2022-04-29 | Izard | Arkansas | 5065 | 3901 | 69 |
2455961 | 2455961 | 2022-04-29 | Polk | North Carolina | 37149 | 3901 | 57 |
2450863 | 2450863 | 2022-04-28 | Izard | Arkansas | 5065 | 3901 | 69 |
2452705 | 2452705 | 2022-04-28 | Polk | North Carolina | 37149 | 3901 | 57 |
2449449 | 2449449 | 2022-04-27 | Polk | North Carolina | 37149 | 3901 | 57 |
2449866 | 2449866 | 2022-04-27 | San German | Puerto Rico | 72125 | 3901 | |
2421269 | 2421269 | 2022-04-18 | Braxton | West Virginia | 54007 | 3901 | 42 |
2417685 | 2417685 | 2022-04-17 | Llano | Texas | 48299 | 3901 | 97 |
2414429 | 2414429 | 2022-04-16 | Llano | Texas | 48299 | 3901 | 97 |
2411173 | 2411173 | 2022-04-15 | Llano | Texas | 48299 | 3901 | 97 |
2406103 | 2406103 | 2022-04-14 | Osage | Kansas | 20139 | 3901 | 49 |
2407917 | 2407917 | 2022-04-14 | Llano | Texas | 48299 | 3901 | 97 |
2402847 | 2402847 | 2022-04-13 | Osage | Kansas | 20139 | 3901 | 49 |
2399593 | 2399593 | 2022-04-12 | Osage | Kansas | 20139 | 3901 | 49 |
2396337 | 2396337 | 2022-04-11 | Osage | Kansas | 20139 | 3901 | 49 |
2393082 | 2393082 | 2022-04-10 | Osage | Kansas | 20139 | 3901 | 49 |
2395224 | 2395224 | 2022-04-10 | Braxton | West Virginia | 54007 | 3901 | 42 |
2389826 | 2389826 | 2022-04-09 | Osage | Kansas | 20139 | 3901 | 49 |
2391968 | 2391968 | 2022-04-09 | Braxton | West Virginia | 54007 | 3901 | 42 |
2386570 | 2386570 | 2022-04-08 | Osage | Kansas | 20139 | 3901 | 49 |
2388712 | 2388712 | 2022-04-08 | Braxton | West Virginia | 54007 | 3901 | 42 |
2347679 | 2347679 | 2022-03-27 | Washington | Kentucky | 21229 | 3901 | 57 |
2344426 | 2344426 | 2022-03-26 | Washington | Kentucky | 21229 | 3901 | 57 |
2341173 | 2341173 | 2022-03-25 | Washington | Kentucky | 21229 | 3901 | 57 |
2337920 | 2337920 | 2022-03-24 | Washington | Kentucky | 21229 | 3901 | 57 |
2334666 | 2334666 | 2022-03-23 | Washington | Kentucky | 21229 | 3901 | 57 |
2331412 | 2331412 | 2022-03-22 | Washington | Kentucky | 21229 | 3901 | 57 |
2328160 | 2328160 | 2022-03-21 | Washington | Kentucky | 21229 | 3901 | 57 |
2301175 | 2301175 | 2022-03-13 | Madison | Arkansas | 5087 | 3901 | 60 |
2301477 | 2301477 | 2022-03-13 | Greene | Georgia | 13133 | 3901 | 81 |
2298225 | 2298225 | 2022-03-12 | Greene | Georgia | 13133 | 3901 | 81 |
2294973 | 2294973 | 2022-03-11 | Greene | Georgia | 13133 | 3901 | 81 |
2235754 | 2235754 | 2022-02-20 | Nottoway | Virginia | 51135 | 3901 | 79 |
2232503 | 2232503 | 2022-02-19 | Nottoway | Virginia | 51135 | 3901 | 79 |
2229252 | 2229252 | 2022-02-18 | Nottoway | Virginia | 51135 | 3901 | 79 |
2225882 | 2225882 | 2022-02-17 | San Juan | Utah | 49037 | 3901 | 47 |
2201347 | 2201347 | 2022-02-10 | Bienville | Louisiana | 22013 | 3901 | 103 |
2149064 | 2149064 | 2022-01-25 | Atchison | Kansas | 20005 | 3901 | 31 |
2145812 | 2145812 | 2022-01-24 | Atchison | Kansas | 20005 | 3901 | 31 |
2137503 | 2137503 | 2022-01-21 | Coamo | Puerto Rico | 72043 | 3901 | |
2133317 | 2133317 | 2022-01-20 | Calhoun | Mississippi | 28013 | 3901 | 52 |
2103027 | 2103027 | 2022-01-11 | Berrien | Georgia | 13019 | 3901 | 72 |
2091666 | 2091666 | 2022-01-07 | Rolette | North Dakota | 38079 | 3901 | 36 |
2086490 | 2086490 | 2022-01-06 | Clark | Arkansas | 5019 | 3901 | 67 |
2008818 | 2008818 | 2021-12-13 | Haralson | Georgia | 13143 | 3901 | 130 |
1982026 | 1982026 | 2021-12-04 | Windsor | Vermont | 50027 | 3901 | 33 |
1965849 | 1965849 | 2021-11-29 | Lee | Virginia | 51105 | 3901 | 62 |
1960659 | 1960659 | 2021-11-28 | Johnson | Kentucky | 21115 | 3901 | 62 |
1957408 | 1957408 | 2021-11-27 | Johnson | Kentucky | 21115 | 3901 | 62 |
1954157 | 1954157 | 2021-11-26 | Johnson | Kentucky | 21115 | 3901 | 62 |
1950906 | 1950906 | 2021-11-25 | Johnson | Kentucky | 21115 | 3901 | 62 |
1947655 | 1947655 | 2021-11-24 | Johnson | Kentucky | 21115 | 3901 | 62 |
1941098 | 1941098 | 2021-11-22 | Allen | Kentucky | 21003 | 3901 | 72 |
1894593 | 1894593 | 2021-11-07 | Uinta | Wyoming | 56041 | 3901 | 27 |
1891343 | 1891343 | 2021-11-06 | Uinta | Wyoming | 56041 | 3901 | 27 |
1888093 | 1888093 | 2021-11-05 | Uinta | Wyoming | 56041 | 3901 | 27 |
1882170 | 1882170 | 2021-11-04 | Cassia | Idaho | 16031 | 3901 | 37 |
1883506 | 1883506 | 2021-11-04 | Anson | North Carolina | 37007 | 3901 | 81 |
1873010 | 1873010 | 2021-11-01 | Pointe Coupee | Louisiana | 22077 | 3901 | 83 |
1866573 | 1866573 | 2021-10-30 | Queen Anne's | Maryland | 24035 | 3901 | 72 |
1859030 | 1859030 | 2021-10-28 | Sevier | Arkansas | 5133 | 3901 | 51 |
1853723 | 1853723 | 2021-10-26 | Le Sueur | Minnesota | 27079 | 3901 | 32 |
1834469 | 1834469 | 2021-10-20 | Washington | Missouri | 29221 | 3901 | 66 |
1759172 | 1759172 | 2021-09-27 | Grant | Kentucky | 21081 | 3901 | 29 |
1739722 | 1739722 | 2021-09-21 | Mercer | Kentucky | 21167 | 3901 | 60 |
1740541 | 1740541 | 2021-09-21 | Wyoming | New York | 36121 | 3901 | 54 |
1700071 | 1700071 | 2021-09-09 | Chattooga | Georgia | 13055 | 3901 | 78 |
1674826 | 1674826 | 2021-09-01 | Sabine | Louisiana | 22085 | 3901 | 67 |
1670244 | 1670244 | 2021-08-30 | Kittitas | Washington | 53037 | 3901 | 41 |
1650130 | 1650130 | 2021-08-24 | Marlboro | South Carolina | 45069 | 3901 | 61 |
1641925 | 1641925 | 2021-08-22 | Jefferson | Indiana | 18077 | 3901 | 91 |
1643433 | 1643433 | 2021-08-22 | Malheur | Oregon | 41045 | 3901 | 66 |
1644346 | 1644346 | 2021-08-22 | Clark | Wisconsin | 55019 | 3901 | 66 |
1638675 | 1638675 | 2021-08-21 | Jefferson | Indiana | 18077 | 3901 | 91 |
1640183 | 1640183 | 2021-08-21 | Malheur | Oregon | 41045 | 3901 | 66 |
1641096 | 1641096 | 2021-08-21 | Clark | Wisconsin | 55019 | 3901 | 66 |
1635425 | 1635425 | 2021-08-20 | Jefferson | Indiana | 18077 | 3901 | 91 |
1636933 | 1636933 | 2021-08-20 | Malheur | Oregon | 41045 | 3901 | 66 |
1637846 | 1637846 | 2021-08-20 | Clark | Wisconsin | 55019 | 3901 | 66 |
1596831 | 1596831 | 2021-08-08 | Beauregard | Louisiana | 22011 | 3901 | 81 |
1593582 | 1593582 | 2021-08-07 | Beauregard | Louisiana | 22011 | 3901 | 81 |
1590333 | 1590333 | 2021-08-06 | Beauregard | Louisiana | 22011 | 3901 | 81 |
1515568 | 1515568 | 2021-07-14 | Knox | Kentucky | 21121 | 3901 | 47 |
1516048 | 1516048 | 2021-07-14 | Howell | Missouri | 29091 | 3901 | 48 |
1513366 | 1513366 | 2021-07-13 | Logan | Ohio | 39091 | 3901 | 79 |
1486725 | 1486725 | 2021-07-05 | Hancock | Mississippi | 28045 | 3901 | 88 |
1483479 | 1483479 | 2021-07-04 | Hancock | Mississippi | 28045 | 3901 | 88 |
1480233 | 1480233 | 2021-07-03 | Hancock | Mississippi | 28045 | 3901 | 88 |
1476986 | 1476986 | 2021-07-02 | Hancock | Mississippi | 28045 | 3901 | 88 |
1415027 | 1415027 | 2021-06-13 | Iberville | Louisiana | 22047 | 3901 | 100 |
1411782 | 1411782 | 2021-06-12 | Iberville | Louisiana | 22047 | 3901 | 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);