ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 3353 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Tennessee 12
- Illinois 10
- Oregon 10
- Iowa 8
- Missouri 7
- New York 7
- Texas 7
- Florida 6
- North Carolina 6
- Ohio 6
- Virginia 6
- Colorado 5
- Kansas 5
- Alabama 4
- Minnesota 4
- Mississippi 4
- Alaska 3
- Arkansas 3
- Kentucky 3
- Louisiana 3
- Massachusetts 3
- Michigan 3
- California 2
- Hawaii 2
- Maryland 2
- Nebraska 2
- New Mexico 2
- Pennsylvania 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499977 | 2499977 | 2022-05-13 | Bleckley | Georgia | 13023 | 3353 | 100 |
2501314 | 2501314 | 2022-05-13 | Otoe | Nebraska | 31131 | 3353 | 19 |
2496719 | 2496719 | 2022-05-12 | Bleckley | Georgia | 13023 | 3353 | 100 |
2493461 | 2493461 | 2022-05-11 | Bleckley | Georgia | 13023 | 3353 | 100 |
2467430 | 2467430 | 2022-05-03 | Dade | Georgia | 13083 | 3353 | 28 |
2464175 | 2464175 | 2022-05-02 | Dade | Georgia | 13083 | 3353 | 28 |
2460919 | 2460919 | 2022-05-01 | Dade | Georgia | 13083 | 3353 | 28 |
2457663 | 2457663 | 2022-04-30 | Dade | Georgia | 13083 | 3353 | 28 |
2454407 | 2454407 | 2022-04-29 | Dade | Georgia | 13083 | 3353 | 28 |
2451151 | 2451151 | 2022-04-28 | Dade | Georgia | 13083 | 3353 | 28 |
2447895 | 2447895 | 2022-04-27 | Dade | Georgia | 13083 | 3353 | 28 |
2445070 | 2445070 | 2022-04-26 | Mills | Iowa | 19129 | 3353 | 41 |
2441814 | 2441814 | 2022-04-25 | Mills | Iowa | 19129 | 3353 | 41 |
2438558 | 2438558 | 2022-04-24 | Mills | Iowa | 19129 | 3353 | 41 |
2435302 | 2435302 | 2022-04-23 | Mills | Iowa | 19129 | 3353 | 41 |
2432046 | 2432046 | 2022-04-22 | Mills | Iowa | 19129 | 3353 | 41 |
2428790 | 2428790 | 2022-04-21 | Mills | Iowa | 19129 | 3353 | 41 |
2430171 | 2430171 | 2022-04-21 | Curry | Oregon | 41015 | 3353 | 54 |
2425534 | 2425534 | 2022-04-20 | Mills | Iowa | 19129 | 3353 | 41 |
2426915 | 2426915 | 2022-04-20 | Curry | Oregon | 41015 | 3353 | 54 |
2423659 | 2423659 | 2022-04-19 | Curry | Oregon | 41015 | 3353 | 54 |
2418779 | 2418779 | 2022-04-18 | Cumberland | Illinois | 17035 | 3353 | 49 |
2420402 | 2420402 | 2022-04-18 | Curry | Oregon | 41015 | 3353 | 54 |
2417147 | 2417147 | 2022-04-17 | Curry | Oregon | 41015 | 3353 | 54 |
2417915 | 2417915 | 2022-04-17 | Martinsville city | Virginia | 51690 | 3353 | 118 |
2413891 | 2413891 | 2022-04-16 | Curry | Oregon | 41015 | 3353 | 54 |
2414659 | 2414659 | 2022-04-16 | Martinsville city | Virginia | 51690 | 3353 | 118 |
2410635 | 2410635 | 2022-04-15 | Curry | Oregon | 41015 | 3353 | 54 |
2411403 | 2411403 | 2022-04-15 | Martinsville city | Virginia | 51690 | 3353 | 118 |
2407379 | 2407379 | 2022-04-14 | Curry | Oregon | 41015 | 3353 | 54 |
2404123 | 2404123 | 2022-04-13 | Curry | Oregon | 41015 | 3353 | 54 |
2379365 | 2379365 | 2022-04-06 | Gunnison | Colorado | 8051 | 3353 | 14 |
2378434 | 2378434 | 2022-04-05 | Meigs | Tennessee | 47121 | 3353 | 55 |
2375180 | 2375180 | 2022-04-04 | Meigs | Tennessee | 47121 | 3353 | 55 |
2371928 | 2371928 | 2022-04-03 | Meigs | Tennessee | 47121 | 3353 | 55 |
2368675 | 2368675 | 2022-04-02 | Meigs | Tennessee | 47121 | 3353 | 55 |
2365422 | 2365422 | 2022-04-01 | Meigs | Tennessee | 47121 | 3353 | 55 |
2362169 | 2362169 | 2022-03-31 | Meigs | Tennessee | 47121 | 3353 | 55 |
2358915 | 2358915 | 2022-03-30 | Meigs | Tennessee | 47121 | 3353 | 55 |
2341964 | 2341964 | 2022-03-25 | Yates | New York | 36123 | 3353 | 39 |
2279495 | 2279495 | 2022-03-06 | Nantucket | Massachusetts | 25019 | 3353 | 0 |
2276242 | 2276242 | 2022-03-05 | Nantucket | Massachusetts | 25019 | 3353 | 0 |
2272989 | 2272989 | 2022-03-04 | Nantucket | Massachusetts | 25019 | 3353 | 0 |
2254638 | 2254638 | 2022-02-26 | Salinas | Puerto Rico | 72123 | 3353 | |
2228125 | 2228125 | 2022-02-18 | Schuyler | New York | 36097 | 3353 | 24 |
2200489 | 2200489 | 2022-02-10 | Grand | Colorado | 8049 | 3353 | 23 |
2182818 | 2182818 | 2022-02-04 | Monroe | Ohio | 39111 | 3353 | 69 |
2157649 | 2157649 | 2022-01-27 | Giles | Virginia | 51071 | 3353 | 38 |
2131838 | 2131838 | 2022-01-19 | Marquette | Wisconsin | 55077 | 3353 | 43 |
2108562 | 2108562 | 2022-01-12 | DeWitt | Texas | 48123 | 3353 | 86 |
2102880 | 2102880 | 2022-01-11 | Chaffee | Colorado | 8015 | 3353 | 38 |
2062250 | 2062250 | 2021-12-29 | Schoharie | New York | 36095 | 3353 | 29 |
2040264 | 2040264 | 2021-12-22 | Burleson | Texas | 48051 | 3353 | 60 |
2028543 | 2028543 | 2021-12-19 | Richland | Illinois | 17159 | 3353 | 75 |
2025292 | 2025292 | 2021-12-18 | Richland | Illinois | 17159 | 3353 | 75 |
2022041 | 2022041 | 2021-12-17 | Richland | Illinois | 17159 | 3353 | 75 |
1987524 | 1987524 | 2021-12-06 | Caswell | North Carolina | 37033 | 3353 | 39 |
1970456 | 1970456 | 2021-12-01 | Rockcastle | Kentucky | 21203 | 3353 | 38 |
1972414 | 1972414 | 2021-12-01 | Adams | Washington | 53001 | 3353 | 34 |
1969164 | 1969164 | 2021-11-30 | Adams | Washington | 53001 | 3353 | 34 |
1943013 | 1943013 | 2021-11-22 | Orleans | Vermont | 50019 | 3353 | 24 |
1928302 | 1928302 | 2021-11-18 | Caroline | Maryland | 24011 | 3353 | 52 |
1923892 | 1923892 | 2021-11-17 | Monroe | Alabama | 1099 | 3353 | 66 |
1875270 | 1875270 | 2021-11-02 | Randolph | Arkansas | 5121 | 3353 | 60 |
1876518 | 1876518 | 2021-11-02 | Attala | Mississippi | 28007 | 3353 | 90 |
1871856 | 1871856 | 2021-11-01 | Butler | Alabama | 1013 | 3353 | 96 |
1873269 | 1873269 | 2021-11-01 | Attala | Mississippi | 28007 | 3353 | 90 |
1861399 | 1861399 | 2021-10-28 | Crockett | Tennessee | 47033 | 3353 | 62 |
1858150 | 1858150 | 2021-10-27 | Crockett | Tennessee | 47033 | 3353 | 62 |
1852974 | 1852974 | 2021-10-26 | Crawford | Illinois | 17033 | 3353 | 46 |
1830253 | 1830253 | 2021-10-19 | Jersey | Illinois | 17083 | 3353 | 72 |
1812801 | 1812801 | 2021-10-13 | Deaf Smith | Texas | 48117 | 3353 | 74 |
1800444 | 1800444 | 2021-10-10 | Juneau City and Borough | Alaska | 2110 | 3353 | 7 |
1797195 | 1797195 | 2021-10-09 | Juneau City and Borough | Alaska | 2110 | 3353 | 7 |
1793946 | 1793946 | 2021-10-08 | Juneau City and Borough | Alaska | 2110 | 3353 | 7 |
1791097 | 1791097 | 2021-10-07 | Lamar | Georgia | 13171 | 3353 | 83 |
1763918 | 1763918 | 2021-09-28 | Chester | Tennessee | 47023 | 3353 | 66 |
1739805 | 1739805 | 2021-09-21 | St. James | Louisiana | 22093 | 3353 | 64 |
1717479 | 1717479 | 2021-09-14 | Randolph | Missouri | 29175 | 3353 | 35 |
1710896 | 1710896 | 2021-09-12 | Adair | Missouri | 29001 | 3353 | 30 |
1707649 | 1707649 | 2021-09-11 | Adair | Missouri | 29001 | 3353 | 30 |
1704402 | 1704402 | 2021-09-10 | Adair | Missouri | 29001 | 3353 | 30 |
1679836 | 1679836 | 2021-09-02 | Accomack | Virginia | 51001 | 3353 | 53 |
1671370 | 1671370 | 2021-08-31 | Miami | Kansas | 20121 | 3353 | 48 |
1672893 | 1672893 | 2021-08-31 | Davison | South Dakota | 46035 | 3353 | 69 |
1668123 | 1668123 | 2021-08-30 | Miami | Kansas | 20121 | 3353 | 48 |
1633332 | 1633332 | 2021-08-19 | Washington | New York | 36115 | 3353 | 57 |
1622143 | 1622143 | 2021-08-16 | Gilmer | Georgia | 13123 | 3353 | 93 |
1611303 | 1611303 | 2021-08-12 | Scott | Tennessee | 47151 | 3353 | 48 |
1587612 | 1587612 | 2021-08-05 | Ravalli | Montana | 30081 | 3353 | 51 |
1576359 | 1576359 | 2021-08-02 | Lincoln | Arkansas | 5079 | 3353 | 49 |
1577587 | 1577587 | 2021-08-02 | Nicollet | Minnesota | 27103 | 3353 | 45 |
1559018 | 1559018 | 2021-07-27 | Jefferson | Pennsylvania | 42065 | 3353 | 99 |
1534157 | 1534157 | 2021-07-20 | Poinsett | Arkansas | 5111 | 3353 | 80 |
1516114 | 1516114 | 2021-07-14 | Warren | Missouri | 29219 | 3353 | 39 |
1508566 | 1508566 | 2021-07-12 | Hawaii | Hawaii | 15001 | 3353 | 55 |
1505320 | 1505320 | 2021-07-11 | Hawaii | Hawaii | 15001 | 3353 | 55 |
1493198 | 1493198 | 2021-07-07 | Alcorn | Mississippi | 28003 | 3353 | 74 |
1401856 | 1401856 | 2021-06-09 | McPherson | Kansas | 20113 | 3353 | 89 |
1398611 | 1398611 | 2021-06-08 | McPherson | Kansas | 20113 | 3353 | 89 |
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);