ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where cases = 4624 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Tennessee 18
- Kentucky 10
- Arkansas 9
- Georgia 8
- Wyoming 8
- Minnesota 7
- Oklahoma 7
- Virginia 7
- Wisconsin 7
- Illinois 6
- Michigan 6
- North Dakota 6
- Oregon 6
- Indiana 5
- Texas 5
- Alabama 4
- Nebraska 4
- Ohio 4
- Florida 2
- Louisiana 2
- Mississippi 2
- North Carolina 2
- Pennsylvania 2
- Colorado 1
- Idaho 1
- Missouri 1
- Montana 1
- New Mexico 1
- New York 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489781 | 2489781 | 2022-05-09 | Carbon | Wyoming | 56007 | 4624 | 52 |
2486524 | 2486524 | 2022-05-08 | Carbon | Wyoming | 56007 | 4624 | 52 |
2483266 | 2483266 | 2022-05-07 | Carbon | Wyoming | 56007 | 4624 | 52 |
2480008 | 2480008 | 2022-05-06 | Carbon | Wyoming | 56007 | 4624 | 52 |
2476750 | 2476750 | 2022-05-05 | Carbon | Wyoming | 56007 | 4624 | 52 |
2473492 | 2473492 | 2022-05-04 | Carbon | Wyoming | 56007 | 4624 | 52 |
2470235 | 2470235 | 2022-05-03 | Carbon | Wyoming | 56007 | 4624 | 52 |
2464354 | 2464354 | 2022-05-02 | Cass | Illinois | 17017 | 4624 | 44 |
2466569 | 2466569 | 2022-05-02 | Reeves | Texas | 48389 | 4624 | 74 |
2463314 | 2463314 | 2022-05-01 | Reeves | Texas | 48389 | 4624 | 74 |
2460058 | 2460058 | 2022-04-30 | Reeves | Texas | 48389 | 4624 | 74 |
2453137 | 2453137 | 2022-04-28 | Yauco | Puerto Rico | 72153 | 4624 | |
2420398 | 2420398 | 2022-04-18 | Clatsop | Oregon | 41007 | 4624 | 49 |
2417143 | 2417143 | 2022-04-17 | Clatsop | Oregon | 41007 | 4624 | 49 |
2413887 | 2413887 | 2022-04-16 | Clatsop | Oregon | 41007 | 4624 | 49 |
2410631 | 2410631 | 2022-04-15 | Clatsop | Oregon | 41007 | 4624 | 49 |
2401642 | 2401642 | 2022-04-12 | New Kent | Virginia | 51127 | 4624 | 32 |
2398387 | 2398387 | 2022-04-11 | New Kent | Virginia | 51127 | 4624 | 32 |
2349721 | 2349721 | 2022-03-27 | Adams | Wisconsin | 55001 | 4624 | 60 |
2346468 | 2346468 | 2022-03-26 | Adams | Wisconsin | 55001 | 4624 | 60 |
2343215 | 2343215 | 2022-03-25 | Adams | Wisconsin | 55001 | 4624 | 60 |
2339962 | 2339962 | 2022-03-24 | Adams | Wisconsin | 55001 | 4624 | 59 |
2333727 | 2333727 | 2022-03-23 | Sharp | Arkansas | 5135 | 4624 | 104 |
2324870 | 2324870 | 2022-03-20 | Mason | Kentucky | 21161 | 4624 | 100 |
2321616 | 2321616 | 2022-03-19 | Mason | Kentucky | 21161 | 4624 | 100 |
2318362 | 2318362 | 2022-03-18 | Mason | Kentucky | 21161 | 4624 | 100 |
2315109 | 2315109 | 2022-03-17 | Mason | Kentucky | 21161 | 4624 | 100 |
2311856 | 2311856 | 2022-03-16 | Mason | Kentucky | 21161 | 4624 | 100 |
2308603 | 2308603 | 2022-03-15 | Mason | Kentucky | 21161 | 4624 | 100 |
2305352 | 2305352 | 2022-03-14 | Mason | Kentucky | 21161 | 4624 | 100 |
2282004 | 2282004 | 2022-03-07 | Morgan | Georgia | 13211 | 4624 | 59 |
2264594 | 2264594 | 2022-03-01 | Polk | Tennessee | 47139 | 4624 | 56 |
2261344 | 2261344 | 2022-02-28 | Polk | Tennessee | 47139 | 4624 | 56 |
2258093 | 2258093 | 2022-02-27 | Polk | Tennessee | 47139 | 4624 | 56 |
2254842 | 2254842 | 2022-02-26 | Polk | Tennessee | 47139 | 4624 | 56 |
2251591 | 2251591 | 2022-02-25 | Polk | Tennessee | 47139 | 4624 | 56 |
2248340 | 2248340 | 2022-02-24 | Polk | Tennessee | 47139 | 4624 | 56 |
2245089 | 2245089 | 2022-02-23 | Polk | Tennessee | 47139 | 4624 | 56 |
2223011 | 2223011 | 2022-02-17 | Fayette | Alabama | 1057 | 4624 | 90 |
2206854 | 2206854 | 2022-02-12 | Cross | Arkansas | 5037 | 4624 | 75 |
2201497 | 2201497 | 2022-02-10 | Iosco | Michigan | 26069 | 4624 | 129 |
2198243 | 2198243 | 2022-02-09 | Iosco | Michigan | 26069 | 4624 | 129 |
2196669 | 2196669 | 2022-02-08 | Colonial Heights city | Virginia | 51570 | 4624 | 80 |
2188560 | 2188560 | 2022-02-06 | Hubbard | Minnesota | 27057 | 4624 | 56 |
2185307 | 2185307 | 2022-02-05 | Hubbard | Minnesota | 27057 | 4624 | 56 |
2182055 | 2182055 | 2022-02-04 | Hubbard | Minnesota | 27057 | 4624 | 56 |
2177612 | 2177612 | 2022-02-03 | Phillips | Arkansas | 5107 | 4624 | 84 |
2171684 | 2171684 | 2022-02-01 | Jay | Indiana | 18075 | 4624 | 74 |
2164909 | 2164909 | 2022-01-30 | Lamar | Georgia | 13171 | 4624 | 105 |
2161654 | 2161654 | 2022-01-29 | Lamar | Georgia | 13171 | 4624 | 105 |
2158398 | 2158398 | 2022-01-28 | Lamar | Georgia | 13171 | 4624 | 105 |
2155433 | 2155433 | 2022-01-27 | Orange | Indiana | 18117 | 4624 | 89 |
2148315 | 2148315 | 2022-01-25 | Lincoln | Arkansas | 5079 | 4624 | 60 |
2120578 | 2120578 | 2022-01-16 | Dawson | Nebraska | 31047 | 4624 | 38 |
2117326 | 2117326 | 2022-01-15 | Dawson | Nebraska | 31047 | 4624 | 38 |
2114075 | 2114075 | 2022-01-14 | Dawson | Nebraska | 31047 | 4624 | 38 |
2106054 | 2106054 | 2022-01-12 | Sevier | Arkansas | 5133 | 4624 | 63 |
2104848 | 2104848 | 2022-01-11 | Texas | Oklahoma | 40139 | 4624 | 44 |
2101597 | 2101597 | 2022-01-10 | Texas | Oklahoma | 40139 | 4624 | 44 |
2098346 | 2098346 | 2022-01-09 | Texas | Oklahoma | 40139 | 4624 | 44 |
2095094 | 2095094 | 2022-01-08 | Texas | Oklahoma | 40139 | 4624 | 44 |
2091842 | 2091842 | 2022-01-07 | Texas | Oklahoma | 40139 | 4624 | 44 |
2088590 | 2088590 | 2022-01-06 | Texas | Oklahoma | 40139 | 4624 | 44 |
2085339 | 2085339 | 2022-01-05 | Texas | Oklahoma | 40139 | 4624 | 44 |
2080934 | 2080934 | 2022-01-04 | Letcher | Kentucky | 21133 | 4624 | 86 |
2029960 | 2029960 | 2021-12-19 | Henry | Ohio | 39069 | 4624 | 83 |
1992247 | 1992247 | 2021-12-08 | Jackson | Arkansas | 5067 | 4624 | 47 |
1973328 | 1973328 | 2021-12-02 | Fayette | Indiana | 18041 | 4624 | 100 |
1967741 | 1967741 | 2021-11-30 | Lake | Montana | 30047 | 4624 | 82 |
1969093 | 1969093 | 2021-11-30 | Isle of Wight | Virginia | 51093 | 4624 | 92 |
1944948 | 1944948 | 2021-11-23 | Stoddard | Missouri | 29207 | 4624 | 106 |
1932439 | 1932439 | 2021-11-19 | Hardin | Ohio | 39065 | 4624 | 98 |
1922412 | 1922412 | 2021-11-16 | Cibola | New Mexico | 35006 | 4624 | 147 |
1813158 | 1813158 | 2021-10-13 | Smyth | Virginia | 51173 | 4624 | 109 |
1781998 | 1781998 | 2021-10-04 | Allen | Louisiana | 22003 | 4624 | 108 |
1755060 | 1755060 | 2021-09-26 | St. Francis | Arkansas | 5123 | 4624 | 57 |
1702674 | 1702674 | 2021-09-09 | Petersburg city | Virginia | 51730 | 4624 | 93 |
1691309 | 1691309 | 2021-09-06 | Steele | Minnesota | 27147 | 4624 | 21 |
1688059 | 1688059 | 2021-09-05 | Steele | Minnesota | 27147 | 4624 | 21 |
1684809 | 1684809 | 2021-09-04 | Steele | Minnesota | 27147 | 4624 | 21 |
1681558 | 1681558 | 2021-09-03 | Steele | Minnesota | 27147 | 4624 | 21 |
1628366 | 1628366 | 2021-08-18 | Union | Arkansas | 5139 | 4624 | 117 |
1601538 | 1601538 | 2021-08-09 | Marshall | Tennessee | 47117 | 4624 | 65 |
1553590 | 1553590 | 2021-07-26 | Boone | Arkansas | 5009 | 4624 | 82 |
1518412 | 1518412 | 2021-07-15 | Marion | Illinois | 17121 | 4624 | 123 |
1497622 | 1497622 | 2021-07-08 | Obion | Tennessee | 47131 | 4624 | 97 |
1487881 | 1487881 | 2021-07-05 | Obion | Tennessee | 47131 | 4624 | 97 |
1484634 | 1484634 | 2021-07-04 | Obion | Tennessee | 47131 | 4624 | 97 |
1481388 | 1481388 | 2021-07-03 | Obion | Tennessee | 47131 | 4624 | 97 |
1478141 | 1478141 | 2021-07-02 | Obion | Tennessee | 47131 | 4624 | 97 |
1449126 | 1449126 | 2021-06-23 | Medina | Texas | 48325 | 4624 | 107 |
1422966 | 1422966 | 2021-06-15 | Obion | Tennessee | 47131 | 4624 | 96 |
1364217 | 1364217 | 2021-05-28 | Yamhill | Oregon | 41071 | 4624 | 78 |
1336731 | 1336731 | 2021-05-20 | Lawrence | Indiana | 18093 | 4624 | 123 |
1309716 | 1309716 | 2021-05-11 | Culpeper | Virginia | 51047 | 4624 | 62 |
1287230 | 1287230 | 2021-05-04 | Monroe | Wisconsin | 55081 | 4624 | 38 |
1258717 | 1258717 | 2021-04-26 | Macoupin | Illinois | 17117 | 4624 | 110 |
1255470 | 1255470 | 2021-04-25 | Macoupin | Illinois | 17117 | 4624 | 110 |
1248667 | 1248667 | 2021-04-23 | Hendry | Florida | 12051 | 4624 | 80 |
1241229 | 1241229 | 2021-04-20 | Burnet | Texas | 48053 | 4624 | 63 |
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);