ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26,475 rows where deaths = 13 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 1,871
- Nebraska 1,863
- Kansas 1,746
- Kentucky 1,286
- Virginia 1,169
- Georgia 1,133
- South Dakota 1,013
- Missouri 999
- North Carolina 921
- Colorado 891
- Oklahoma 823
- Minnesota 707
- Iowa 675
- Illinois 640
- North Dakota 621
- Mississippi 606
- Michigan 605
- Ohio 595
- Tennessee 586
- Indiana 581
- Wisconsin 547
- Montana 504
- West Virginia 453
- Arkansas 428
- New Mexico 398
- Idaho 383
- Utah 381
- Oregon 361
- California 337
- Alabama 322
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499659 | 2499659 | 2022-05-13 | Northwest Arctic Borough | Alaska | 2188 | 4837 | 13 |
2499793 | 2499793 | 2022-05-13 | Plumas | California | 6063 | 3379 | 13 |
2499824 | 2499824 | 2022-05-13 | Baca | Colorado | 8009 | 855 | 13 |
2499872 | 2499872 | 2022-05-13 | Rio Blanco | Colorado | 8103 | 1696 | 13 |
2500496 | 2500496 | 2022-05-13 | Edwards | Kansas | 20047 | 556 | 13 |
2500517 | 2500517 | 2022-05-13 | Jewell | Kansas | 20089 | 788 | 13 |
2500527 | 2500527 | 2022-05-13 | Logan | Kansas | 20109 | 844 | 13 |
2500822 | 2500822 | 2022-05-13 | Alger | Michigan | 26003 | 1880 | 13 |
2500967 | 2500967 | 2022-05-13 | Red Lake | Minnesota | 27125 | 953 | 13 |
2500979 | 2500979 | 2022-05-13 | Stevens | Minnesota | 27149 | 2675 | 13 |
2501241 | 2501241 | 2022-05-13 | Sweet Grass | Montana | 30097 | 785 | 13 |
2501278 | 2501278 | 2022-05-13 | Fillmore | Nebraska | 31059 | 1154 | 13 |
2501302 | 2501302 | 2022-05-13 | Knox | Nebraska | 31107 | 1667 | 13 |
2501313 | 2501313 | 2022-05-13 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2501533 | 2501533 | 2022-05-13 | Hyde | North Carolina | 37095 | 1340 | 13 |
2501607 | 2501607 | 2022-05-13 | Kidder | North Dakota | 38043 | 510 | 13 |
2502087 | 2502087 | 2022-05-13 | Marshall | South Dakota | 46091 | 796 | 13 |
2502092 | 2502092 | 2022-05-13 | Miner | South Dakota | 46097 | 457 | 13 |
2502379 | 2502379 | 2022-05-13 | Motley | Texas | 48345 | 286 | 13 |
2496401 | 2496401 | 2022-05-12 | Northwest Arctic Borough | Alaska | 2188 | 4837 | 13 |
2496535 | 2496535 | 2022-05-12 | Plumas | California | 6063 | 3362 | 13 |
2496566 | 2496566 | 2022-05-12 | Baca | Colorado | 8009 | 855 | 13 |
2496614 | 2496614 | 2022-05-12 | Rio Blanco | Colorado | 8103 | 1694 | 13 |
2497238 | 2497238 | 2022-05-12 | Edwards | Kansas | 20047 | 556 | 13 |
2497259 | 2497259 | 2022-05-12 | Jewell | Kansas | 20089 | 788 | 13 |
2497269 | 2497269 | 2022-05-12 | Logan | Kansas | 20109 | 844 | 13 |
2497564 | 2497564 | 2022-05-12 | Alger | Michigan | 26003 | 1880 | 13 |
2497709 | 2497709 | 2022-05-12 | Red Lake | Minnesota | 27125 | 951 | 13 |
2497721 | 2497721 | 2022-05-12 | Stevens | Minnesota | 27149 | 2671 | 13 |
2497983 | 2497983 | 2022-05-12 | Sweet Grass | Montana | 30097 | 783 | 13 |
2498020 | 2498020 | 2022-05-12 | Fillmore | Nebraska | 31059 | 1151 | 13 |
2498044 | 2498044 | 2022-05-12 | Knox | Nebraska | 31107 | 1666 | 13 |
2498055 | 2498055 | 2022-05-12 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2498275 | 2498275 | 2022-05-12 | Hyde | North Carolina | 37095 | 1340 | 13 |
2498349 | 2498349 | 2022-05-12 | Kidder | North Dakota | 38043 | 508 | 13 |
2498739 | 2498739 | 2022-05-12 | Unknown | Rhode Island | 30344 | 13 | |
2498829 | 2498829 | 2022-05-12 | Marshall | South Dakota | 46091 | 796 | 13 |
2498834 | 2498834 | 2022-05-12 | Miner | South Dakota | 46097 | 457 | 13 |
2499121 | 2499121 | 2022-05-12 | Motley | Texas | 48345 | 286 | 13 |
2499414 | 2499414 | 2022-05-12 | Skamania | Washington | 53059 | 1529 | 13 |
2493143 | 2493143 | 2022-05-11 | Northwest Arctic Borough | Alaska | 2188 | 4837 | 13 |
2493277 | 2493277 | 2022-05-11 | Plumas | California | 6063 | 3362 | 13 |
2493308 | 2493308 | 2022-05-11 | Baca | Colorado | 8009 | 852 | 13 |
2493356 | 2493356 | 2022-05-11 | Rio Blanco | Colorado | 8103 | 1685 | 13 |
2493980 | 2493980 | 2022-05-11 | Edwards | Kansas | 20047 | 556 | 13 |
2494001 | 2494001 | 2022-05-11 | Jewell | Kansas | 20089 | 788 | 13 |
2494011 | 2494011 | 2022-05-11 | Logan | Kansas | 20109 | 844 | 13 |
2494306 | 2494306 | 2022-05-11 | Alger | Michigan | 26003 | 1880 | 13 |
2494442 | 2494442 | 2022-05-11 | Norman | Minnesota | 27107 | 1531 | 13 |
2494451 | 2494451 | 2022-05-11 | Red Lake | Minnesota | 27125 | 950 | 13 |
2494463 | 2494463 | 2022-05-11 | Stevens | Minnesota | 27149 | 2665 | 13 |
2494725 | 2494725 | 2022-05-11 | Sweet Grass | Montana | 30097 | 783 | 13 |
2494762 | 2494762 | 2022-05-11 | Fillmore | Nebraska | 31059 | 1151 | 13 |
2494786 | 2494786 | 2022-05-11 | Knox | Nebraska | 31107 | 1666 | 13 |
2494797 | 2494797 | 2022-05-11 | Nuckolls | Nebraska | 31129 | 976 | 13 |
2495017 | 2495017 | 2022-05-11 | Hyde | North Carolina | 37095 | 1340 | 13 |
2495091 | 2495091 | 2022-05-11 | Kidder | North Dakota | 38043 | 508 | 13 |
2495481 | 2495481 | 2022-05-11 | Unknown | Rhode Island | 29374 | 13 | |
2495571 | 2495571 | 2022-05-11 | Marshall | South Dakota | 46091 | 796 | 13 |
2495576 | 2495576 | 2022-05-11 | Miner | South Dakota | 46097 | 457 | 13 |
2495863 | 2495863 | 2022-05-11 | Motley | Texas | 48345 | 286 | 13 |
2496156 | 2496156 | 2022-05-11 | Skamania | Washington | 53059 | 1529 | 13 |
2489885 | 2489885 | 2022-05-10 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2490019 | 2490019 | 2022-05-10 | Plumas | California | 6063 | 3362 | 13 |
2490050 | 2490050 | 2022-05-10 | Baca | Colorado | 8009 | 850 | 13 |
2490098 | 2490098 | 2022-05-10 | Rio Blanco | Colorado | 8103 | 1685 | 13 |
2490600 | 2490600 | 2022-05-10 | Adams | Iowa | 19003 | 819 | 13 |
2490722 | 2490722 | 2022-05-10 | Edwards | Kansas | 20047 | 556 | 13 |
2490743 | 2490743 | 2022-05-10 | Jewell | Kansas | 20089 | 788 | 13 |
2490753 | 2490753 | 2022-05-10 | Logan | Kansas | 20109 | 844 | 13 |
2491048 | 2491048 | 2022-05-10 | Alger | Michigan | 26003 | 1870 | 13 |
2491184 | 2491184 | 2022-05-10 | Norman | Minnesota | 27107 | 1531 | 13 |
2491193 | 2491193 | 2022-05-10 | Red Lake | Minnesota | 27125 | 948 | 13 |
2491205 | 2491205 | 2022-05-10 | Stevens | Minnesota | 27149 | 2665 | 13 |
2491467 | 2491467 | 2022-05-10 | Sweet Grass | Montana | 30097 | 783 | 13 |
2491504 | 2491504 | 2022-05-10 | Fillmore | Nebraska | 31059 | 1164 | 13 |
2491528 | 2491528 | 2022-05-10 | Knox | Nebraska | 31107 | 1694 | 13 |
2491539 | 2491539 | 2022-05-10 | Nuckolls | Nebraska | 31129 | 980 | 13 |
2491759 | 2491759 | 2022-05-10 | Hyde | North Carolina | 37095 | 1322 | 13 |
2491833 | 2491833 | 2022-05-10 | Kidder | North Dakota | 38043 | 508 | 13 |
2492313 | 2492313 | 2022-05-10 | Marshall | South Dakota | 46091 | 793 | 13 |
2492318 | 2492318 | 2022-05-10 | Miner | South Dakota | 46097 | 457 | 13 |
2492605 | 2492605 | 2022-05-10 | Motley | Texas | 48345 | 286 | 13 |
2492898 | 2492898 | 2022-05-10 | Skamania | Washington | 53059 | 1523 | 13 |
2486628 | 2486628 | 2022-05-09 | Northwest Arctic Borough | Alaska | 2188 | 4805 | 13 |
2486762 | 2486762 | 2022-05-09 | Plumas | California | 6063 | 3360 | 13 |
2486793 | 2486793 | 2022-05-09 | Baca | Colorado | 8009 | 850 | 13 |
2486841 | 2486841 | 2022-05-09 | Rio Blanco | Colorado | 8103 | 1685 | 13 |
2487343 | 2487343 | 2022-05-09 | Adams | Iowa | 19003 | 819 | 13 |
2487465 | 2487465 | 2022-05-09 | Edwards | Kansas | 20047 | 556 | 13 |
2487486 | 2487486 | 2022-05-09 | Jewell | Kansas | 20089 | 788 | 13 |
2487496 | 2487496 | 2022-05-09 | Logan | Kansas | 20109 | 844 | 13 |
2487791 | 2487791 | 2022-05-09 | Alger | Michigan | 26003 | 1870 | 13 |
2487927 | 2487927 | 2022-05-09 | Norman | Minnesota | 27107 | 1531 | 13 |
2487936 | 2487936 | 2022-05-09 | Red Lake | Minnesota | 27125 | 949 | 13 |
2487948 | 2487948 | 2022-05-09 | Stevens | Minnesota | 27149 | 2658 | 13 |
2488209 | 2488209 | 2022-05-09 | Sweet Grass | Montana | 30097 | 783 | 13 |
2488246 | 2488246 | 2022-05-09 | Fillmore | Nebraska | 31059 | 1164 | 13 |
2488270 | 2488270 | 2022-05-09 | Knox | Nebraska | 31107 | 1694 | 13 |
2488281 | 2488281 | 2022-05-09 | Nuckolls | Nebraska | 31129 | 980 | 13 |
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);