ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
270 rows where deaths = 503 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 22
- Georgia 20
- Ohio 18
- Michigan 17
- New Mexico 16
- Texas 13
- Arkansas 11
- New York 11
- Tennessee 11
- Illinois 10
- Alabama 9
- Colorado 9
- Florida 9
- North Carolina 9
- Arizona 8
- Oregon 8
- Maryland 7
- Minnesota 7
- Missouri 6
- New Jersey 6
- South Carolina 6
- Virginia 6
- Wisconsin 5
- South Dakota 4
- California 3
- Hawaii 3
- Indiana 3
- Washington 3
- New Hampshire 2
- Delaware 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496597 | 2496597 | 2022-05-12 | Larimer | Colorado | 8069 | 81056 | 503 |
2493339 | 2493339 | 2022-05-11 | Larimer | Colorado | 8069 | 80284 | 503 |
2490081 | 2490081 | 2022-05-10 | Larimer | Colorado | 8069 | 80142 | 503 |
2417943 | 2417943 | 2022-04-17 | Richmond city | Virginia | 51760 | 44891 | 503 |
2414687 | 2414687 | 2022-04-16 | Richmond city | Virginia | 51760 | 44891 | 503 |
2411431 | 2411431 | 2022-04-15 | Richmond city | Virginia | 51760 | 44891 | 503 |
2404702 | 2404702 | 2022-04-13 | Randall | Texas | 48381 | 38152 | 503 |
2398660 | 2398660 | 2022-04-12 | Houston | Alabama | 1069 | 25672 | 503 |
2398906 | 2398906 | 2022-04-12 | Larimer | Colorado | 8069 | 77505 | 503 |
2381231 | 2381231 | 2022-04-06 | Richland | Ohio | 39139 | 31493 | 503 |
2377976 | 2377976 | 2022-04-05 | Richland | Ohio | 39139 | 31493 | 503 |
2374722 | 2374722 | 2022-04-04 | Richland | Ohio | 39139 | 31493 | 503 |
2375757 | 2375757 | 2022-04-04 | Dane | Wisconsin | 55025 | 124691 | 503 |
2371470 | 2371470 | 2022-04-03 | Richland | Ohio | 39139 | 31493 | 503 |
2372505 | 2372505 | 2022-04-03 | Dane | Wisconsin | 55025 | 124422 | 503 |
2366218 | 2366218 | 2022-04-02 | Garland | Arkansas | 5051 | 23263 | 503 |
2368217 | 2368217 | 2022-04-02 | Richland | Ohio | 39139 | 31493 | 503 |
2369252 | 2369252 | 2022-04-02 | Dane | Wisconsin | 55025 | 124422 | 503 |
2362965 | 2362965 | 2022-04-01 | Garland | Arkansas | 5051 | 23263 | 503 |
2364964 | 2364964 | 2022-04-01 | Richland | Ohio | 39139 | 31493 | 503 |
2365999 | 2365999 | 2022-04-01 | Dane | Wisconsin | 55025 | 124422 | 503 |
2359711 | 2359711 | 2022-03-31 | Garland | Arkansas | 5051 | 23261 | 503 |
2361711 | 2361711 | 2022-03-31 | Richland | Ohio | 39139 | 31493 | 503 |
2356457 | 2356457 | 2022-03-30 | Garland | Arkansas | 5051 | 23254 | 503 |
2353204 | 2353204 | 2022-03-29 | Garland | Arkansas | 5051 | 23249 | 503 |
2349952 | 2349952 | 2022-03-28 | Garland | Arkansas | 5051 | 23243 | 503 |
2350480 | 2350480 | 2022-03-28 | McHenry | Illinois | 17111 | 75672 | 503 |
2346699 | 2346699 | 2022-03-27 | Garland | Arkansas | 5051 | 23243 | 503 |
2347227 | 2347227 | 2022-03-27 | McHenry | Illinois | 17111 | 75612 | 503 |
2343446 | 2343446 | 2022-03-26 | Garland | Arkansas | 5051 | 23241 | 503 |
2343974 | 2343974 | 2022-03-26 | McHenry | Illinois | 17111 | 75612 | 503 |
2340193 | 2340193 | 2022-03-25 | Garland | Arkansas | 5051 | 23241 | 503 |
2340721 | 2340721 | 2022-03-25 | McHenry | Illinois | 17111 | 75612 | 503 |
2337468 | 2337468 | 2022-03-24 | McHenry | Illinois | 17111 | 75584 | 503 |
2335644 | 2335644 | 2022-03-23 | Greene | Ohio | 39057 | 37417 | 503 |
2330432 | 2330432 | 2022-03-22 | Garland | Arkansas | 5051 | 23232 | 503 |
2332390 | 2332390 | 2022-03-22 | Greene | Ohio | 39057 | 37417 | 503 |
2327095 | 2327095 | 2022-03-21 | Morgan | Alabama | 1103 | 35958 | 503 |
2329137 | 2329137 | 2022-03-21 | Greene | Ohio | 39057 | 37417 | 503 |
2329290 | 2329290 | 2022-03-21 | Jackson | Oregon | 41029 | 42487 | 503 |
2325885 | 2325885 | 2022-03-20 | Greene | Ohio | 39057 | 37417 | 503 |
2326038 | 2326038 | 2022-03-20 | Jackson | Oregon | 41029 | 42462 | 503 |
2322632 | 2322632 | 2022-03-19 | Greene | Ohio | 39057 | 37417 | 503 |
2322785 | 2322785 | 2022-03-19 | Jackson | Oregon | 41029 | 42462 | 503 |
2319378 | 2319378 | 2022-03-18 | Greene | Ohio | 39057 | 37417 | 503 |
2319531 | 2319531 | 2022-03-18 | Jackson | Oregon | 41029 | 42462 | 503 |
2316124 | 2316124 | 2022-03-17 | Greene | Ohio | 39057 | 37417 | 503 |
2310686 | 2310686 | 2022-03-15 | Brown | Wisconsin | 55009 | 83647 | 503 |
2304720 | 2304720 | 2022-03-14 | Floyd | Georgia | 13115 | 27127 | 503 |
2301468 | 2301468 | 2022-03-13 | Floyd | Georgia | 13115 | 27108 | 503 |
2298216 | 2298216 | 2022-03-12 | Floyd | Georgia | 13115 | 27108 | 503 |
2294964 | 2294964 | 2022-03-11 | Floyd | Georgia | 13115 | 27108 | 503 |
2286610 | 2286610 | 2022-03-08 | Albany | New York | 36001 | 58162 | 503 |
2283358 | 2283358 | 2022-03-07 | Albany | New York | 36001 | 58143 | 503 |
2284023 | 2284023 | 2022-03-07 | Minnehaha | South Dakota | 46099 | 56862 | 503 |
2280771 | 2280771 | 2022-03-06 | Minnehaha | South Dakota | 46099 | 56844 | 503 |
2277518 | 2277518 | 2022-03-05 | Minnehaha | South Dakota | 46099 | 56844 | 503 |
2274265 | 2274265 | 2022-03-04 | Minnehaha | South Dakota | 46099 | 56844 | 503 |
2270803 | 2270803 | 2022-03-03 | Lebanon | Pennsylvania | 42075 | 36346 | 503 |
2264301 | 2264301 | 2022-03-01 | Lycoming | Pennsylvania | 42081 | 28219 | 503 |
2259958 | 2259958 | 2022-02-28 | Frederick | Maryland | 24021 | 45062 | 503 |
2260533 | 2260533 | 2022-02-28 | Rockingham | New Hampshire | 33015 | 65602 | 503 |
2256707 | 2256707 | 2022-02-27 | Frederick | Maryland | 24021 | 45050 | 503 |
2257757 | 2257757 | 2022-02-27 | Washington | Oregon | 41067 | 83858 | 503 |
2253456 | 2253456 | 2022-02-26 | Frederick | Maryland | 24021 | 45017 | 503 |
2254506 | 2254506 | 2022-02-26 | Washington | Oregon | 41067 | 83858 | 503 |
2250205 | 2250205 | 2022-02-25 | Frederick | Maryland | 24021 | 44974 | 503 |
2251255 | 2251255 | 2022-02-25 | Washington | Oregon | 41067 | 83858 | 503 |
2246422 | 2246422 | 2022-02-24 | Rock Island | Illinois | 17161 | 32737 | 503 |
2247590 | 2247590 | 2022-02-24 | Broome | New York | 36007 | 44204 | 503 |
2244339 | 2244339 | 2022-02-23 | Broome | New York | 36007 | 44152 | 503 |
2244800 | 2244800 | 2022-02-23 | Monroe | Pennsylvania | 42089 | 36563 | 503 |
2241088 | 2241088 | 2022-02-22 | Broome | New York | 36007 | 44095 | 503 |
2241549 | 2241549 | 2022-02-22 | Monroe | Pennsylvania | 42089 | 36558 | 503 |
2238298 | 2238298 | 2022-02-21 | Monroe | Pennsylvania | 42089 | 36531 | 503 |
2235047 | 2235047 | 2022-02-20 | Monroe | Pennsylvania | 42089 | 36531 | 503 |
2218464 | 2218464 | 2022-02-15 | Robeson | North Carolina | 37155 | 39468 | 503 |
2214629 | 2214629 | 2022-02-14 | St. Louis | Minnesota | 27137 | 44526 | 503 |
2215213 | 2215213 | 2022-02-14 | Robeson | North Carolina | 37155 | 39395 | 503 |
2211962 | 2211962 | 2022-02-13 | Robeson | North Carolina | 37155 | 39253 | 503 |
2208709 | 2208709 | 2022-02-12 | Robeson | North Carolina | 37155 | 39253 | 503 |
2205456 | 2205456 | 2022-02-11 | Robeson | North Carolina | 37155 | 39253 | 503 |
2202203 | 2202203 | 2022-02-10 | Robeson | North Carolina | 37155 | 39177 | 503 |
2202453 | 2202453 | 2022-02-10 | Clackamas | Oregon | 41005 | 57359 | 503 |
2198397 | 2198397 | 2022-02-09 | DeSoto | Mississippi | 28033 | 48746 | 503 |
2196305 | 2196305 | 2022-02-08 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2192127 | 2192127 | 2022-02-07 | Yellowstone | Montana | 30111 | 40134 | 503 |
2193051 | 2193051 | 2022-02-07 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2187488 | 2187488 | 2022-02-06 | Mesa | Colorado | 8077 | 39302 | 503 |
2189797 | 2189797 | 2022-02-06 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2184235 | 2184235 | 2022-02-05 | Mesa | Colorado | 8077 | 39302 | 503 |
2186544 | 2186544 | 2022-02-05 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2180983 | 2180983 | 2022-02-04 | Mesa | Colorado | 8077 | 39302 | 503 |
2183292 | 2183292 | 2022-02-04 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2177732 | 2177732 | 2022-02-03 | Mesa | Colorado | 8077 | 39100 | 503 |
2180040 | 2180040 | 2022-02-03 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2174479 | 2174479 | 2022-02-02 | Mesa | Colorado | 8077 | 38805 | 503 |
2176789 | 2176789 | 2022-02-02 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2169837 | 2169837 | 2022-01-31 | Warren | Ohio | 39165 | 55320 | 503 |
2166582 | 2166582 | 2022-01-30 | Warren | Ohio | 39165 | 55226 | 503 |
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);