ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
329 rows where deaths = 495 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 60
- Pennsylvania 28
- Illinois 23
- Indiana 20
- South Carolina 15
- Georgia 14
- Florida 13
- Alabama 12
- Ohio 12
- Louisiana 11
- Michigan 11
- Virginia 11
- New York 9
- Arizona 8
- New Jersey 8
- Oklahoma 8
- California 6
- New Mexico 6
- Wisconsin 6
- New Hampshire 5
- Connecticut 4
- Maryland 4
- Massachusetts 4
- Minnesota 4
- North Carolina 4
- Washington 4
- Colorado 3
- Idaho 3
- Oregon 3
- Tennessee 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492242 | 2492242 | 2022-05-10 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2488984 | 2488984 | 2022-05-09 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2485727 | 2485727 | 2022-05-08 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2482469 | 2482469 | 2022-05-07 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2479211 | 2479211 | 2022-05-06 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2475953 | 2475953 | 2022-05-05 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2472696 | 2472696 | 2022-05-04 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2473051 | 2473051 | 2022-05-04 | Midland | Texas | 48329 | 40859 | 495 |
2469440 | 2469440 | 2022-05-03 | Dorchester | South Carolina | 45035 | 56163 | 495 |
2469795 | 2469795 | 2022-05-03 | Midland | Texas | 48329 | 40846 | 495 |
2466539 | 2466539 | 2022-05-02 | Midland | Texas | 48329 | 40843 | 495 |
2463284 | 2463284 | 2022-05-01 | Midland | Texas | 48329 | 40842 | 495 |
2460028 | 2460028 | 2022-04-30 | Midland | Texas | 48329 | 40841 | 495 |
2456772 | 2456772 | 2022-04-29 | Midland | Texas | 48329 | 40839 | 495 |
2453516 | 2453516 | 2022-04-28 | Midland | Texas | 48329 | 40836 | 495 |
2450260 | 2450260 | 2022-04-27 | Midland | Texas | 48329 | 40819 | 495 |
2447003 | 2447003 | 2022-04-26 | Midland | Texas | 48329 | 40799 | 495 |
2443748 | 2443748 | 2022-04-25 | Midland | Texas | 48329 | 40783 | 495 |
2443910 | 2443910 | 2022-04-25 | Chesapeake city | Virginia | 51550 | 50266 | 495 |
2440492 | 2440492 | 2022-04-24 | Midland | Texas | 48329 | 40783 | 495 |
2440654 | 2440654 | 2022-04-24 | Chesapeake city | Virginia | 51550 | 50206 | 495 |
2437236 | 2437236 | 2022-04-23 | Midland | Texas | 48329 | 40781 | 495 |
2437398 | 2437398 | 2022-04-23 | Chesapeake city | Virginia | 51550 | 50206 | 495 |
2433980 | 2433980 | 2022-04-22 | Midland | Texas | 48329 | 40747 | 495 |
2434142 | 2434142 | 2022-04-22 | Chesapeake city | Virginia | 51550 | 50206 | 495 |
2430724 | 2430724 | 2022-04-21 | Midland | Texas | 48329 | 40724 | 495 |
2430886 | 2430886 | 2022-04-21 | Chesapeake city | Virginia | 51550 | 50182 | 495 |
2427468 | 2427468 | 2022-04-20 | Midland | Texas | 48329 | 40699 | 495 |
2424212 | 2424212 | 2022-04-19 | Midland | Texas | 48329 | 40668 | 495 |
2420956 | 2420956 | 2022-04-18 | Midland | Texas | 48329 | 40627 | 495 |
2417700 | 2417700 | 2022-04-17 | Midland | Texas | 48329 | 40552 | 495 |
2414444 | 2414444 | 2022-04-16 | Midland | Texas | 48329 | 40552 | 495 |
2411188 | 2411188 | 2022-04-15 | Midland | Texas | 48329 | 40552 | 495 |
2407932 | 2407932 | 2022-04-14 | Midland | Texas | 48329 | 40552 | 495 |
2404676 | 2404676 | 2022-04-13 | Midland | Texas | 48329 | 40503 | 495 |
2401421 | 2401421 | 2022-04-12 | Midland | Texas | 48329 | 40430 | 495 |
2398166 | 2398166 | 2022-04-11 | Midland | Texas | 48329 | 40366 | 495 |
2394911 | 2394911 | 2022-04-10 | Midland | Texas | 48329 | 40366 | 495 |
2391655 | 2391655 | 2022-04-09 | Midland | Texas | 48329 | 40366 | 495 |
2388399 | 2388399 | 2022-04-08 | Midland | Texas | 48329 | 40321 | 495 |
2385144 | 2385144 | 2022-04-07 | Midland | Texas | 48329 | 40257 | 495 |
2379785 | 2379785 | 2022-04-06 | Tazewell | Illinois | 17179 | 36602 | 495 |
2376531 | 2376531 | 2022-04-05 | Tazewell | Illinois | 17179 | 36593 | 495 |
2375406 | 2375406 | 2022-04-04 | Randall | Texas | 48381 | 38126 | 495 |
2360266 | 2360266 | 2022-03-31 | Tazewell | Illinois | 17179 | 36555 | 495 |
2362369 | 2362369 | 2022-03-31 | Midland | Texas | 48329 | 39748 | 495 |
2357012 | 2357012 | 2022-03-30 | Tazewell | Illinois | 17179 | 36541 | 495 |
2357471 | 2357471 | 2022-03-30 | Lafayette | Louisiana | 22055 | 62283 | 495 |
2359115 | 2359115 | 2022-03-30 | Midland | Texas | 48329 | 39653 | 495 |
2353759 | 2353759 | 2022-03-29 | Tazewell | Illinois | 17179 | 36531 | 495 |
2355861 | 2355861 | 2022-03-29 | Midland | Texas | 48329 | 39566 | 495 |
2350507 | 2350507 | 2022-03-28 | Tazewell | Illinois | 17179 | 36523 | 495 |
2352608 | 2352608 | 2022-03-28 | Midland | Texas | 48329 | 39526 | 495 |
2347254 | 2347254 | 2022-03-27 | Tazewell | Illinois | 17179 | 36509 | 495 |
2349356 | 2349356 | 2022-03-27 | Midland | Texas | 48329 | 39526 | 495 |
2344001 | 2344001 | 2022-03-26 | Tazewell | Illinois | 17179 | 36509 | 495 |
2346103 | 2346103 | 2022-03-26 | Midland | Texas | 48329 | 39526 | 495 |
2340748 | 2340748 | 2022-03-25 | Tazewell | Illinois | 17179 | 36509 | 495 |
2342850 | 2342850 | 2022-03-25 | Midland | Texas | 48329 | 39408 | 495 |
2336838 | 2336838 | 2022-03-24 | Houston | Alabama | 1069 | 25009 | 495 |
2337495 | 2337495 | 2022-03-24 | Tazewell | Illinois | 17179 | 36500 | 495 |
2339597 | 2339597 | 2022-03-24 | Midland | Texas | 48329 | 39274 | 495 |
2333584 | 2333584 | 2022-03-23 | Houston | Alabama | 1069 | 25003 | 495 |
2334241 | 2334241 | 2022-03-23 | Tazewell | Illinois | 17179 | 36486 | 495 |
2335802 | 2335802 | 2022-03-23 | Lane | Oregon | 41039 | 56995 | 495 |
2335861 | 2335861 | 2022-03-23 | Mercer | Pennsylvania | 42085 | 23265 | 495 |
2336343 | 2336343 | 2022-03-23 | Midland | Texas | 48329 | 39187 | 495 |
2330987 | 2330987 | 2022-03-22 | Tazewell | Illinois | 17179 | 36478 | 495 |
2332607 | 2332607 | 2022-03-22 | Mercer | Pennsylvania | 42085 | 23262 | 495 |
2327735 | 2327735 | 2022-03-21 | Tazewell | Illinois | 17179 | 36465 | 495 |
2329354 | 2329354 | 2022-03-21 | Mercer | Pennsylvania | 42085 | 23262 | 495 |
2324482 | 2324482 | 2022-03-20 | Tazewell | Illinois | 17179 | 36444 | 495 |
2326102 | 2326102 | 2022-03-20 | Mercer | Pennsylvania | 42085 | 23259 | 495 |
2326524 | 2326524 | 2022-03-20 | Hays | Texas | 48209 | 59804 | 495 |
2321228 | 2321228 | 2022-03-19 | Tazewell | Illinois | 17179 | 36444 | 495 |
2322849 | 2322849 | 2022-03-19 | Mercer | Pennsylvania | 42085 | 23259 | 495 |
2323271 | 2323271 | 2022-03-19 | Hays | Texas | 48209 | 59804 | 495 |
2317974 | 2317974 | 2022-03-18 | Tazewell | Illinois | 17179 | 36444 | 495 |
2319595 | 2319595 | 2022-03-18 | Mercer | Pennsylvania | 42085 | 23257 | 495 |
2320017 | 2320017 | 2022-03-18 | Hays | Texas | 48209 | 59804 | 495 |
2314721 | 2314721 | 2022-03-17 | Tazewell | Illinois | 17179 | 36437 | 495 |
2316341 | 2316341 | 2022-03-17 | Mercer | Pennsylvania | 42085 | 23249 | 495 |
2311468 | 2311468 | 2022-03-16 | Tazewell | Illinois | 17179 | 36425 | 495 |
2313947 | 2313947 | 2022-03-16 | Dane | Wisconsin | 55025 | 123089 | 495 |
2294426 | 2294426 | 2022-03-10 | Brown | Wisconsin | 55009 | 83600 | 495 |
2290259 | 2290259 | 2022-03-09 | Jackson | Oregon | 41029 | 42310 | 495 |
2291174 | 2291174 | 2022-03-09 | Brown | Wisconsin | 55009 | 83585 | 495 |
2283643 | 2283643 | 2022-03-07 | Richland | Ohio | 39139 | 31378 | 495 |
2280391 | 2280391 | 2022-03-06 | Richland | Ohio | 39139 | 31374 | 495 |
2277138 | 2277138 | 2022-03-05 | Richland | Ohio | 39139 | 31366 | 495 |
2273885 | 2273885 | 2022-03-04 | Richland | Ohio | 39139 | 31305 | 495 |
2268946 | 2268946 | 2022-03-03 | Floyd | Georgia | 13115 | 27032 | 495 |
2265693 | 2265693 | 2022-03-02 | Floyd | Georgia | 13115 | 27017 | 495 |
2262442 | 2262442 | 2022-03-01 | Floyd | Georgia | 13115 | 26983 | 495 |
2241027 | 2241027 | 2022-02-22 | Rockingham | New Hampshire | 33015 | 64794 | 495 |
2237776 | 2237776 | 2022-02-21 | Rockingham | New Hampshire | 33015 | 64794 | 495 |
2234525 | 2234525 | 2022-02-20 | Rockingham | New Hampshire | 33015 | 64794 | 495 |
2231274 | 2231274 | 2022-02-19 | Rockingham | New Hampshire | 33015 | 64794 | 495 |
2228023 | 2228023 | 2022-02-18 | Rockingham | New Hampshire | 33015 | 64794 | 495 |
2215541 | 2215541 | 2022-02-14 | Monroe | Pennsylvania | 42089 | 36368 | 495 |
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);