ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where cases = 3313 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 19
- Texas 12
- Illinois 10
- Minnesota 9
- Georgia 8
- Iowa 8
- Indiana 7
- Colorado 6
- Kansas 6
- West Virginia 6
- Arkansas 5
- Kentucky 5
- Louisiana 5
- Alabama 4
- Idaho 4
- Mississippi 4
- Ohio 4
- Wisconsin 4
- Florida 3
- Missouri 3
- North Dakota 3
- Pennsylvania 3
- Maine 2
- Nebraska 2
- Puerto Rico 2
- South Carolina 2
- Tennessee 2
- Utah 2
- Michigan 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486254 | 2486254 | 2022-05-08 | Dickenson | Virginia | 51051 | 3313 | 49 |
2482996 | 2482996 | 2022-05-07 | Dickenson | Virginia | 51051 | 3313 | 49 |
2479738 | 2479738 | 2022-05-06 | Dickenson | Virginia | 51051 | 3313 | 49 |
2473222 | 2473222 | 2022-05-04 | Dickenson | Virginia | 51051 | 3313 | 49 |
2356052 | 2356052 | 2022-03-29 | Greensville | Virginia | 51081 | 3313 | 39 |
2352799 | 2352799 | 2022-03-28 | Greensville | Virginia | 51081 | 3313 | 39 |
2339788 | 2339788 | 2022-03-24 | Greensville | Virginia | 51081 | 3313 | 39 |
2317014 | 2317014 | 2022-03-17 | Greensville | Virginia | 51081 | 3313 | 37 |
2313761 | 2313761 | 2022-03-16 | Greensville | Virginia | 51081 | 3313 | 37 |
2310508 | 2310508 | 2022-03-15 | Greensville | Virginia | 51081 | 3313 | 37 |
2307255 | 2307255 | 2022-03-14 | Greensville | Virginia | 51081 | 3313 | 37 |
2285715 | 2285715 | 2022-03-08 | Marion | Kansas | 20115 | 3313 | 39 |
2282463 | 2282463 | 2022-03-07 | Marion | Kansas | 20115 | 3313 | 39 |
2268654 | 2268654 | 2022-03-03 | Marion | Arkansas | 5089 | 3313 | 85 |
2260800 | 2260800 | 2022-02-28 | Walsh | North Dakota | 38099 | 3313 | 34 |
2257549 | 2257549 | 2022-02-27 | Walsh | North Dakota | 38099 | 3313 | 34 |
2217100 | 2217100 | 2022-02-15 | Cumberland | Illinois | 17035 | 3313 | 49 |
2187608 | 2187608 | 2022-02-06 | Brooks | Georgia | 13027 | 3313 | 77 |
2184355 | 2184355 | 2022-02-05 | Brooks | Georgia | 13027 | 3313 | 77 |
2181103 | 2181103 | 2022-02-04 | Brooks | Georgia | 13027 | 3313 | 77 |
2178807 | 2178807 | 2022-02-03 | Kanabec | Minnesota | 27065 | 3313 | 53 |
2174465 | 2174465 | 2022-02-02 | Grand | Colorado | 8049 | 3313 | 23 |
2132527 | 2132527 | 2022-01-20 | Greene | Illinois | 17061 | 3313 | 54 |
2132792 | 2132792 | 2022-01-20 | Allen | Kansas | 20001 | 3313 | 30 |
2134538 | 2134538 | 2022-01-20 | Bosque | Texas | 48035 | 3313 | 59 |
2128684 | 2128684 | 2022-01-19 | Macon | Alabama | 1087 | 3313 | 69 |
2129539 | 2129539 | 2022-01-19 | Allen | Kansas | 20001 | 3313 | 30 |
2128269 | 2128269 | 2022-01-18 | Zavala | Texas | 48507 | 3313 | 56 |
2108232 | 2108232 | 2022-01-12 | Coamo | Puerto Rico | 72043 | 3313 | |
2103478 | 2103478 | 2022-01-11 | Kossuth | Iowa | 19109 | 3313 | 81 |
2100227 | 2100227 | 2022-01-10 | Kossuth | Iowa | 19109 | 3313 | 81 |
2096976 | 2096976 | 2022-01-09 | Kossuth | Iowa | 19109 | 3313 | 81 |
2093724 | 2093724 | 2022-01-08 | Kossuth | Iowa | 19109 | 3313 | 81 |
2090472 | 2090472 | 2022-01-07 | Kossuth | Iowa | 19109 | 3313 | 81 |
2087221 | 2087221 | 2022-01-06 | Kossuth | Iowa | 19109 | 3313 | 81 |
2089255 | 2089255 | 2022-01-06 | Duchesne | Utah | 49013 | 3313 | 21 |
2083969 | 2083969 | 2022-01-05 | Kossuth | Iowa | 19109 | 3313 | 81 |
2086074 | 2086074 | 2022-01-05 | Colonial Heights city | Virginia | 51570 | 3313 | 71 |
2073954 | 2073954 | 2022-01-02 | Minidoka | Idaho | 16067 | 3313 | 53 |
2070703 | 2070703 | 2022-01-01 | Minidoka | Idaho | 16067 | 3313 | 53 |
2067452 | 2067452 | 2021-12-31 | Minidoka | Idaho | 16067 | 3313 | 53 |
2064201 | 2064201 | 2021-12-30 | Minidoka | Idaho | 16067 | 3313 | 53 |
2034653 | 2034653 | 2021-12-21 | Otero | Colorado | 8089 | 3313 | 115 |
2031737 | 2031737 | 2021-12-20 | Edgar | Illinois | 17045 | 3313 | 71 |
2028998 | 2028998 | 2021-12-19 | Concordia | Louisiana | 22029 | 3313 | 80 |
2025747 | 2025747 | 2021-12-18 | Concordia | Louisiana | 22029 | 3313 | 80 |
2022496 | 2022496 | 2021-12-17 | Concordia | Louisiana | 22029 | 3313 | 80 |
2015874 | 2015874 | 2021-12-15 | Breckinridge | Kentucky | 21027 | 3313 | 48 |
1995861 | 1995861 | 2021-12-09 | Putnam | Georgia | 13237 | 3313 | 88 |
1983044 | 1983044 | 2021-12-05 | Union | Illinois | 17181 | 3313 | 54 |
1979794 | 1979794 | 2021-12-04 | Union | Illinois | 17181 | 3313 | 54 |
1976544 | 1976544 | 2021-12-03 | Union | Illinois | 17181 | 3313 | 54 |
1972631 | 1972631 | 2021-12-02 | Fayette | Alabama | 1057 | 3313 | 85 |
1965347 | 1965347 | 2021-11-29 | Hughes | South Dakota | 46065 | 3313 | 49 |
1942531 | 1942531 | 2021-11-22 | Fairfield | South Carolina | 45039 | 3313 | 93 |
1928922 | 1928922 | 2021-11-18 | Lincoln | New Mexico | 35027 | 3313 | 40 |
1926883 | 1926883 | 2021-11-17 | Scott | Virginia | 51169 | 3313 | 83 |
1887959 | 1887959 | 2021-11-05 | Hampshire | West Virginia | 54027 | 3313 | 49 |
1875154 | 1875154 | 2021-11-02 | Randolph | Alabama | 1111 | 3313 | 65 |
1874000 | 1874000 | 2021-11-01 | Wyandot | Ohio | 39175 | 3313 | 62 |
1832790 | 1832790 | 2021-10-19 | Jackson | Wisconsin | 55053 | 3313 | 31 |
1826979 | 1826979 | 2021-10-18 | Crawford | Illinois | 17033 | 3313 | 46 |
1800220 | 1800220 | 2021-10-09 | Boone | West Virginia | 54005 | 3313 | 45 |
1792943 | 1792943 | 2021-10-07 | Susquehanna | Pennsylvania | 42115 | 3313 | 64 |
1783559 | 1783559 | 2021-10-04 | Deaf Smith | Texas | 48117 | 3313 | 70 |
1780310 | 1780310 | 2021-10-03 | Deaf Smith | Texas | 48117 | 3313 | 70 |
1777060 | 1777060 | 2021-10-02 | Deaf Smith | Texas | 48117 | 3313 | 70 |
1767526 | 1767526 | 2021-09-29 | Sevier | Utah | 49041 | 3313 | 16 |
1748304 | 1748304 | 2021-09-23 | Door | Wisconsin | 55029 | 3313 | 38 |
1738154 | 1738154 | 2021-09-20 | Lampasas | Texas | 48281 | 3313 | 52 |
1734904 | 1734904 | 2021-09-19 | Lampasas | Texas | 48281 | 3313 | 52 |
1731654 | 1731654 | 2021-09-18 | Lampasas | Texas | 48281 | 3313 | 52 |
1719292 | 1719292 | 2021-09-15 | Logan | Arkansas | 5083 | 3313 | 34 |
1699433 | 1699433 | 2021-09-08 | Pulaski | Virginia | 51155 | 3313 | 73 |
1682279 | 1682279 | 2021-09-03 | Morrow | Ohio | 39117 | 3313 | 47 |
1669048 | 1669048 | 2021-08-30 | Orleans | New York | 36073 | 3313 | 83 |
1664634 | 1664634 | 2021-08-29 | Clay | Indiana | 18021 | 3313 | 51 |
1661386 | 1661386 | 2021-08-28 | Clay | Indiana | 18021 | 3313 | 51 |
1658138 | 1658138 | 2021-08-27 | Clay | Indiana | 18021 | 3313 | 51 |
1657215 | 1657215 | 2021-08-26 | Smyth | Virginia | 51173 | 3313 | 96 |
1584269 | 1584269 | 2021-08-04 | McDonald | Missouri | 29119 | 3313 | 42 |
1579397 | 1579397 | 2021-08-02 | Lincoln | Wisconsin | 55069 | 3313 | 97 |
1537112 | 1537112 | 2021-07-20 | Logan | West Virginia | 54045 | 3313 | 96 |
1529048 | 1529048 | 2021-07-18 | Lafayette | Missouri | 29107 | 3313 | 57 |
1530617 | 1530617 | 2021-07-18 | Logan | West Virginia | 54045 | 3313 | 96 |
1527370 | 1527370 | 2021-07-17 | Logan | West Virginia | 54045 | 3313 | 96 |
1524123 | 1524123 | 2021-07-16 | Logan | West Virginia | 54045 | 3313 | 96 |
1486704 | 1486704 | 2021-07-05 | Alcorn | Mississippi | 28003 | 3313 | 74 |
1483458 | 1483458 | 2021-07-04 | Alcorn | Mississippi | 28003 | 3313 | 74 |
1480212 | 1480212 | 2021-07-03 | Alcorn | Mississippi | 28003 | 3313 | 74 |
1476965 | 1476965 | 2021-07-02 | Alcorn | Mississippi | 28003 | 3313 | 74 |
1454210 | 1454210 | 2021-06-25 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1450965 | 1450965 | 2021-06-24 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1447719 | 1447719 | 2021-06-23 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1444474 | 1444474 | 2021-06-22 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1441229 | 1441229 | 2021-06-21 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1400508 | 1400508 | 2021-06-08 | Upshur | Texas | 48459 | 3313 | 75 |
1340611 | 1340611 | 2021-05-21 | Pine | Minnesota | 27115 | 3313 | 23 |
1324055 | 1324055 | 2021-05-16 | Knox | Kentucky | 21121 | 3313 | 37 |
1319254 | 1319254 | 2021-05-14 | Kendall | Texas | 48259 | 3313 | 72 |
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);