ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38,292 rows where deaths = 6 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 4,236
- Virginia 1,851
- Kansas 1,835
- Georgia 1,617
- Colorado 1,547
- Oklahoma 1,508
- Nebraska 1,481
- Montana 1,415
- South Dakota 1,201
- Missouri 1,174
- North Carolina 1,164
- Kentucky 1,155
- North Dakota 1,012
- Mississippi 898
- Michigan 889
- Minnesota 882
- Idaho 853
- New York 838
- Illinois 767
- West Virginia 717
- Pennsylvania 711
- Alabama 665
- Indiana 665
- Oregon 661
- Iowa 657
- Tennessee 625
- California 599
- Arkansas 563
- New Mexico 556
- Wisconsin 544
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499787 | 2499787 | 2022-05-13 | Mono | California | 6051 | 3144 | 6 |
2499851 | 2499851 | 2022-05-13 | Kiowa | Colorado | 8061 | 336 | 6 |
2499866 | 2499866 | 2022-05-13 | Ouray | Colorado | 8091 | 884 | 6 |
2499995 | 2499995 | 2022-05-13 | Clay | Georgia | 13061 | 533 | 6 |
2500110 | 2500110 | 2022-05-13 | Unknown | Georgia | 10941 | 6 | |
2500943 | 2500943 | 2022-05-13 | Lake of the Woods | Minnesota | 27077 | 779 | 6 |
2500945 | 2500945 | 2022-05-13 | Lincoln | Minnesota | 27081 | 1220 | 6 |
2501277 | 2501277 | 2022-05-13 | Dundy | Nebraska | 31057 | 335 | 6 |
2501337 | 2501337 | 2022-05-13 | Valley | Nebraska | 31175 | 731 | 6 |
2501400 | 2501400 | 2022-05-13 | De Baca | New Mexico | 35011 | 589 | 6 |
2501599 | 2501599 | 2022-05-13 | Eddy | North Dakota | 38027 | 761 | 6 |
2501838 | 2501838 | 2022-05-13 | Sherman | Oregon | 41055 | 321 | 6 |
2502074 | 2502074 | 2022-05-13 | Hanson | South Dakota | 46061 | 655 | 6 |
2502100 | 2502100 | 2022-05-13 | Sanborn | South Dakota | 46111 | 575 | 6 |
2502386 | 2502386 | 2022-05-13 | Oldham | Texas | 48359 | 565 | 6 |
2502423 | 2502423 | 2022-05-13 | Sterling | Texas | 48431 | 245 | 6 |
2502471 | 2502471 | 2022-05-13 | Grand | Utah | 49019 | 2351 | 6 |
2496529 | 2496529 | 2022-05-12 | Mono | California | 6051 | 3127 | 6 |
2496593 | 2496593 | 2022-05-12 | Kiowa | Colorado | 8061 | 336 | 6 |
2496608 | 2496608 | 2022-05-12 | Ouray | Colorado | 8091 | 882 | 6 |
2496737 | 2496737 | 2022-05-12 | Clay | Georgia | 13061 | 533 | 6 |
2496852 | 2496852 | 2022-05-12 | Unknown | Georgia | 10941 | 6 | |
2497685 | 2497685 | 2022-05-12 | Lake of the Woods | Minnesota | 27077 | 777 | 6 |
2497687 | 2497687 | 2022-05-12 | Lincoln | Minnesota | 27081 | 1219 | 6 |
2498019 | 2498019 | 2022-05-12 | Dundy | Nebraska | 31057 | 335 | 6 |
2498079 | 2498079 | 2022-05-12 | Valley | Nebraska | 31175 | 730 | 6 |
2498142 | 2498142 | 2022-05-12 | De Baca | New Mexico | 35011 | 588 | 6 |
2498341 | 2498341 | 2022-05-12 | Eddy | North Dakota | 38027 | 760 | 6 |
2498580 | 2498580 | 2022-05-12 | Sherman | Oregon | 41055 | 321 | 6 |
2498816 | 2498816 | 2022-05-12 | Hanson | South Dakota | 46061 | 655 | 6 |
2498842 | 2498842 | 2022-05-12 | Sanborn | South Dakota | 46111 | 575 | 6 |
2499128 | 2499128 | 2022-05-12 | Oldham | Texas | 48359 | 565 | 6 |
2499165 | 2499165 | 2022-05-12 | Sterling | Texas | 48431 | 245 | 6 |
2499213 | 2499213 | 2022-05-12 | Grand | Utah | 49019 | 2351 | 6 |
2493271 | 2493271 | 2022-05-11 | Mono | California | 6051 | 3127 | 6 |
2493335 | 2493335 | 2022-05-11 | Kiowa | Colorado | 8061 | 336 | 6 |
2493350 | 2493350 | 2022-05-11 | Ouray | Colorado | 8091 | 875 | 6 |
2493479 | 2493479 | 2022-05-11 | Clay | Georgia | 13061 | 533 | 6 |
2493594 | 2493594 | 2022-05-11 | Unknown | Georgia | 10941 | 6 | |
2494427 | 2494427 | 2022-05-11 | Lake of the Woods | Minnesota | 27077 | 777 | 6 |
2494429 | 2494429 | 2022-05-11 | Lincoln | Minnesota | 27081 | 1219 | 6 |
2494761 | 2494761 | 2022-05-11 | Dundy | Nebraska | 31057 | 335 | 6 |
2494821 | 2494821 | 2022-05-11 | Valley | Nebraska | 31175 | 730 | 6 |
2494884 | 2494884 | 2022-05-11 | De Baca | New Mexico | 35011 | 588 | 6 |
2495083 | 2495083 | 2022-05-11 | Eddy | North Dakota | 38027 | 760 | 6 |
2495322 | 2495322 | 2022-05-11 | Sherman | Oregon | 41055 | 321 | 6 |
2495558 | 2495558 | 2022-05-11 | Hanson | South Dakota | 46061 | 655 | 6 |
2495584 | 2495584 | 2022-05-11 | Sanborn | South Dakota | 46111 | 575 | 6 |
2495870 | 2495870 | 2022-05-11 | Oldham | Texas | 48359 | 565 | 6 |
2495907 | 2495907 | 2022-05-11 | Sterling | Texas | 48431 | 245 | 6 |
2495955 | 2495955 | 2022-05-11 | Grand | Utah | 49019 | 2346 | 6 |
2490013 | 2490013 | 2022-05-10 | Mono | California | 6051 | 3127 | 6 |
2490077 | 2490077 | 2022-05-10 | Kiowa | Colorado | 8061 | 336 | 6 |
2490092 | 2490092 | 2022-05-10 | Ouray | Colorado | 8091 | 875 | 6 |
2490221 | 2490221 | 2022-05-10 | Clay | Georgia | 13061 | 533 | 6 |
2490336 | 2490336 | 2022-05-10 | Unknown | Georgia | 10770 | 6 | |
2491169 | 2491169 | 2022-05-10 | Lake of the Woods | Minnesota | 27077 | 779 | 6 |
2491171 | 2491171 | 2022-05-10 | Lincoln | Minnesota | 27081 | 1219 | 6 |
2491503 | 2491503 | 2022-05-10 | Dundy | Nebraska | 31057 | 344 | 6 |
2491563 | 2491563 | 2022-05-10 | Valley | Nebraska | 31175 | 753 | 6 |
2491626 | 2491626 | 2022-05-10 | De Baca | New Mexico | 35011 | 586 | 6 |
2491825 | 2491825 | 2022-05-10 | Eddy | North Dakota | 38027 | 760 | 6 |
2492064 | 2492064 | 2022-05-10 | Sherman | Oregon | 41055 | 321 | 6 |
2492300 | 2492300 | 2022-05-10 | Hanson | South Dakota | 46061 | 655 | 6 |
2492326 | 2492326 | 2022-05-10 | Sanborn | South Dakota | 46111 | 572 | 6 |
2492612 | 2492612 | 2022-05-10 | Oldham | Texas | 48359 | 565 | 6 |
2492649 | 2492649 | 2022-05-10 | Sterling | Texas | 48431 | 245 | 6 |
2492697 | 2492697 | 2022-05-10 | Grand | Utah | 49019 | 2340 | 6 |
2486756 | 2486756 | 2022-05-09 | Mono | California | 6051 | 3125 | 6 |
2486820 | 2486820 | 2022-05-09 | Kiowa | Colorado | 8061 | 336 | 6 |
2486835 | 2486835 | 2022-05-09 | Ouray | Colorado | 8091 | 874 | 6 |
2486964 | 2486964 | 2022-05-09 | Clay | Georgia | 13061 | 533 | 6 |
2487079 | 2487079 | 2022-05-09 | Unknown | Georgia | 10770 | 6 | |
2487912 | 2487912 | 2022-05-09 | Lake of the Woods | Minnesota | 27077 | 778 | 6 |
2487914 | 2487914 | 2022-05-09 | Lincoln | Minnesota | 27081 | 1218 | 6 |
2488245 | 2488245 | 2022-05-09 | Dundy | Nebraska | 31057 | 344 | 6 |
2488305 | 2488305 | 2022-05-09 | Valley | Nebraska | 31175 | 753 | 6 |
2488368 | 2488368 | 2022-05-09 | De Baca | New Mexico | 35011 | 582 | 6 |
2488567 | 2488567 | 2022-05-09 | Eddy | North Dakota | 38027 | 760 | 6 |
2488806 | 2488806 | 2022-05-09 | Sherman | Oregon | 41055 | 321 | 6 |
2489042 | 2489042 | 2022-05-09 | Hanson | South Dakota | 46061 | 655 | 6 |
2489068 | 2489068 | 2022-05-09 | Sanborn | South Dakota | 46111 | 572 | 6 |
2489354 | 2489354 | 2022-05-09 | Oldham | Texas | 48359 | 565 | 6 |
2489391 | 2489391 | 2022-05-09 | Sterling | Texas | 48431 | 245 | 6 |
2489439 | 2489439 | 2022-05-09 | Grand | Utah | 49019 | 2337 | 6 |
2483498 | 2483498 | 2022-05-08 | Mono | California | 6051 | 3125 | 6 |
2483562 | 2483562 | 2022-05-08 | Kiowa | Colorado | 8061 | 336 | 6 |
2483577 | 2483577 | 2022-05-08 | Ouray | Colorado | 8091 | 872 | 6 |
2483706 | 2483706 | 2022-05-08 | Clay | Georgia | 13061 | 533 | 6 |
2483821 | 2483821 | 2022-05-08 | Unknown | Georgia | 10770 | 6 | |
2484654 | 2484654 | 2022-05-08 | Lake of the Woods | Minnesota | 27077 | 778 | 6 |
2484656 | 2484656 | 2022-05-08 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2484988 | 2484988 | 2022-05-08 | Dundy | Nebraska | 31057 | 344 | 6 |
2485048 | 2485048 | 2022-05-08 | Valley | Nebraska | 31175 | 753 | 6 |
2485111 | 2485111 | 2022-05-08 | De Baca | New Mexico | 35011 | 581 | 6 |
2485310 | 2485310 | 2022-05-08 | Eddy | North Dakota | 38027 | 760 | 6 |
2485549 | 2485549 | 2022-05-08 | Sherman | Oregon | 41055 | 321 | 6 |
2485785 | 2485785 | 2022-05-08 | Hanson | South Dakota | 46061 | 655 | 6 |
2485811 | 2485811 | 2022-05-08 | Sanborn | South Dakota | 46111 | 572 | 6 |
2486097 | 2486097 | 2022-05-08 | Oldham | Texas | 48359 | 565 | 6 |
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);