ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 3278 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 12
- Virginia 11
- Iowa 9
- Kentucky 9
- Louisiana 8
- Alabama 7
- Arkansas 7
- Georgia 6
- Kansas 6
- Mississippi 6
- Texas 6
- Wyoming 6
- Colorado 5
- Ohio 5
- Puerto Rico 5
- Tennessee 5
- New York 4
- North Dakota 4
- California 3
- Minnesota 3
- New Jersey 3
- Wisconsin 3
- Florida 2
- Illinois 2
- Missouri 2
- Montana 2
- North Carolina 2
- Oklahoma 2
- Oregon 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501701 | 2501701 | 2022-05-13 | Morgan | Ohio | 39115 | 3278 | 60 |
2498443 | 2498443 | 2022-05-12 | Morgan | Ohio | 39115 | 3278 | 60 |
2499379 | 2499379 | 2022-05-12 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2491073 | 2491073 | 2022-05-10 | Gogebic | Michigan | 26053 | 3278 | 69 |
2492863 | 2492863 | 2022-05-10 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2487816 | 2487816 | 2022-05-09 | Gogebic | Michigan | 26053 | 3278 | 69 |
2489605 | 2489605 | 2022-05-09 | Westmoreland | Virginia | 51193 | 3278 | 52 |
2484558 | 2484558 | 2022-05-08 | Gogebic | Michigan | 26053 | 3278 | 69 |
2481300 | 2481300 | 2022-05-07 | Gogebic | Michigan | 26053 | 3278 | 69 |
2478042 | 2478042 | 2022-05-06 | Gogebic | Michigan | 26053 | 3278 | 69 |
2474784 | 2474784 | 2022-05-05 | Gogebic | Michigan | 26053 | 3278 | 69 |
2471527 | 2471527 | 2022-05-04 | Gogebic | Michigan | 26053 | 3278 | 69 |
2468659 | 2468659 | 2022-05-03 | Roosevelt | Montana | 30085 | 3278 | 74 |
2450871 | 2450871 | 2022-04-28 | Little River | Arkansas | 5081 | 3278 | 104 |
2447615 | 2447615 | 2022-04-27 | Little River | Arkansas | 5081 | 3278 | 104 |
2430970 | 2430970 | 2022-04-21 | Rockbridge | Virginia | 51163 | 3278 | 80 |
2425809 | 2425809 | 2022-04-20 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2422553 | 2422553 | 2022-04-19 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2419297 | 2419297 | 2022-04-18 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2416041 | 2416041 | 2022-04-17 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2412785 | 2412785 | 2022-04-16 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2413995 | 2413995 | 2022-04-16 | Barceloneta | Puerto Rico | 72017 | 3278 | |
2409529 | 2409529 | 2022-04-15 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2410739 | 2410739 | 2022-04-15 | Barceloneta | Puerto Rico | 72017 | 3278 | |
2406273 | 2406273 | 2022-04-14 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2407483 | 2407483 | 2022-04-14 | Barceloneta | Puerto Rico | 72017 | 3278 | |
2403017 | 2403017 | 2022-04-13 | Claiborne | Louisiana | 22027 | 3278 | 76 |
2378229 | 2378229 | 2022-04-05 | Naguabo | Puerto Rico | 72103 | 3278 | |
2374975 | 2374975 | 2022-04-04 | Naguabo | Puerto Rico | 72103 | 3278 | |
2309339 | 2309339 | 2022-03-15 | Unknown | New Jersey | 3278 | 0 | |
2296331 | 2296331 | 2022-03-11 | Unknown | New Jersey | 3278 | 0 | |
2268209 | 2268209 | 2022-03-02 | Dickenson | Virginia | 51051 | 3278 | 45 |
2233764 | 2233764 | 2022-02-20 | Clinton | Kentucky | 21053 | 3278 | 42 |
2230513 | 2230513 | 2022-02-19 | Clinton | Kentucky | 21053 | 3278 | 42 |
2227262 | 2227262 | 2022-02-18 | Clinton | Kentucky | 21053 | 3278 | 42 |
2221788 | 2221788 | 2022-02-16 | Walsh | North Dakota | 38099 | 3278 | 34 |
2195603 | 2195603 | 2022-02-08 | Schuyler | New York | 36097 | 3278 | 23 |
2188457 | 2188457 | 2022-02-06 | Benzie | Michigan | 26019 | 3278 | 60 |
2185204 | 2185204 | 2022-02-05 | Benzie | Michigan | 26019 | 3278 | 60 |
2181952 | 2181952 | 2022-02-04 | Benzie | Michigan | 26019 | 3278 | 60 |
2155958 | 2155958 | 2022-01-27 | Leelanau | Michigan | 26089 | 3278 | 44 |
2152705 | 2152705 | 2022-01-26 | Leelanau | Michigan | 26089 | 3278 | 44 |
2104054 | 2104054 | 2022-01-11 | Clarke | Mississippi | 28023 | 3278 | 96 |
2074858 | 2074858 | 2022-01-02 | Winston | Mississippi | 28159 | 3278 | 93 |
2071607 | 2071607 | 2022-01-01 | Winston | Mississippi | 28159 | 3278 | 93 |
2068356 | 2068356 | 2021-12-31 | Winston | Mississippi | 28159 | 3278 | 93 |
2065105 | 2065105 | 2021-12-30 | Winston | Mississippi | 28159 | 3278 | 93 |
2065542 | 2065542 | 2021-12-30 | Currituck | North Carolina | 37053 | 3278 | 27 |
2036123 | 2036123 | 2021-12-21 | Washington | Nebraska | 31177 | 3278 | 30 |
2030477 | 2030477 | 2021-12-19 | Trousdale | Tennessee | 47169 | 3278 | 28 |
2027226 | 2027226 | 2021-12-18 | Trousdale | Tennessee | 47169 | 3278 | 28 |
2023975 | 2023975 | 2021-12-17 | Trousdale | Tennessee | 47169 | 3278 | 28 |
1999795 | 1999795 | 2021-12-10 | Franklin | Maine | 23007 | 3278 | 35 |
1989697 | 1989697 | 2021-12-07 | Jackson | Iowa | 19097 | 3278 | 47 |
1986447 | 1986447 | 2021-12-06 | Jackson | Iowa | 19097 | 3278 | 47 |
1983197 | 1983197 | 2021-12-05 | Jackson | Iowa | 19097 | 3278 | 47 |
1979947 | 1979947 | 2021-12-04 | Jackson | Iowa | 19097 | 3278 | 47 |
1976697 | 1976697 | 2021-12-03 | Jackson | Iowa | 19097 | 3278 | 47 |
1972795 | 1972795 | 2021-12-02 | Colusa | California | 6011 | 3278 | 20 |
1973301 | 1973301 | 2021-12-02 | Wayne | Illinois | 17191 | 3278 | 66 |
1973448 | 1973448 | 2021-12-02 | Jackson | Iowa | 19097 | 3278 | 47 |
1970198 | 1970198 | 2021-12-01 | Jackson | Iowa | 19097 | 3278 | 47 |
1942330 | 1942330 | 2021-11-22 | Crook | Oregon | 41013 | 3278 | 55 |
1936873 | 1936873 | 2021-11-21 | Fayette | Alabama | 1057 | 3278 | 85 |
1935639 | 1935639 | 2021-11-20 | Rolette | North Dakota | 38079 | 3278 | 36 |
1923811 | 1923811 | 2021-11-16 | Vilas | Wisconsin | 55125 | 3278 | 60 |
1882589 | 1882589 | 2021-11-04 | Sumner | Kansas | 20191 | 3278 | 61 |
1879340 | 1879340 | 2021-11-03 | Sumner | Kansas | 20191 | 3278 | 61 |
1880784 | 1880784 | 2021-11-03 | Fairfield | South Carolina | 45039 | 3278 | 93 |
1880998 | 1880998 | 2021-11-03 | Burleson | Texas | 48051 | 3278 | 59 |
1766770 | 1766770 | 2021-09-29 | Van Wert | Ohio | 39161 | 3278 | 72 |
1758878 | 1758878 | 2021-09-27 | LaGrange | Indiana | 18087 | 3278 | 77 |
1744681 | 1744681 | 2021-09-22 | Moore | Texas | 48341 | 3278 | 79 |
1725155 | 1725155 | 2021-09-16 | Lampasas | Texas | 48281 | 3278 | 50 |
1693417 | 1693417 | 2021-09-07 | Delta | Colorado | 8029 | 3278 | 76 |
1688245 | 1688245 | 2021-09-05 | Randolph | Missouri | 29175 | 3278 | 34 |
1666977 | 1666977 | 2021-08-29 | Wythe | Virginia | 51197 | 3278 | 85 |
1663729 | 1663729 | 2021-08-28 | Wythe | Virginia | 51197 | 3278 | 85 |
1660481 | 1660481 | 2021-08-27 | Wythe | Virginia | 51197 | 3278 | 85 |
1645805 | 1645805 | 2021-08-23 | Mille Lacs | Minnesota | 27095 | 3278 | 58 |
1624279 | 1624279 | 2021-08-16 | McNairy | Tennessee | 47109 | 3278 | 57 |
1607218 | 1607218 | 2021-08-11 | Douglas | Nevada | 32005 | 3278 | 38 |
1602685 | 1602685 | 2021-08-10 | Lumpkin | Georgia | 13187 | 3278 | 83 |
1599385 | 1599385 | 2021-08-09 | Dawson | Georgia | 13085 | 3278 | 49 |
1585312 | 1585312 | 2021-08-04 | Scott | Tennessee | 47151 | 3278 | 48 |
1573968 | 1573968 | 2021-08-01 | Bell | Kentucky | 21013 | 3278 | 58 |
1570720 | 1570720 | 2021-07-31 | Bell | Kentucky | 21013 | 3278 | 58 |
1567472 | 1567472 | 2021-07-30 | Bell | Kentucky | 21013 | 3278 | 58 |
1560024 | 1560024 | 2021-07-28 | Pike | Alabama | 1109 | 3278 | 79 |
1550409 | 1550409 | 2021-07-25 | Unknown | Arkansas | 3278 | 0 | |
1516597 | 1516597 | 2021-07-14 | Guernsey | Ohio | 39059 | 3278 | 54 |
1513350 | 1513350 | 2021-07-13 | Guernsey | Ohio | 39059 | 3278 | 54 |
1509667 | 1509667 | 2021-07-12 | Ravalli | Montana | 30081 | 3278 | 51 |
1504912 | 1504912 | 2021-07-11 | Jackson | Arkansas | 5067 | 3278 | 38 |
1508008 | 1508008 | 2021-07-11 | Sheridan | Wyoming | 56033 | 3278 | 31 |
1501666 | 1501666 | 2021-07-10 | Jackson | Arkansas | 5067 | 3278 | 38 |
1504762 | 1504762 | 2021-07-10 | Sheridan | Wyoming | 56033 | 3278 | 31 |
1498420 | 1498420 | 2021-07-09 | Jackson | Arkansas | 5067 | 3278 | 38 |
1501516 | 1501516 | 2021-07-09 | Sheridan | Wyoming | 56033 | 3278 | 31 |
1498270 | 1498270 | 2021-07-08 | Sheridan | Wyoming | 56033 | 3278 | 31 |
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);