ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where cases = 3362 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 15
- Mississippi 15
- Texas 14
- Indiana 10
- Iowa 9
- Georgia 8
- Missouri 8
- North Dakota 8
- Nebraska 7
- Wisconsin 6
- Florida 5
- Kentucky 5
- North Carolina 5
- South Carolina 5
- Virginia 5
- Alabama 4
- Arkansas 4
- California 4
- Oklahoma 4
- New Mexico 3
- New York 3
- Pennsylvania 3
- Puerto Rico 3
- Minnesota 2
- Oregon 2
- Tennessee 2
- Washington 2
- West Virginia 2
- Colorado 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496535 | 2496535 | 2022-05-12 | Plumas | California | 6063 | 3362 | 13 |
2493277 | 2493277 | 2022-05-11 | Plumas | California | 6063 | 3362 | 13 |
2490019 | 2490019 | 2022-05-10 | Plumas | California | 6063 | 3362 | 13 |
2492739 | 2492739 | 2022-05-10 | Alleghany | Virginia | 51005 | 3362 | 98 |
2475573 | 2475573 | 2022-05-05 | Walsh | North Dakota | 38099 | 3362 | 34 |
2472316 | 2472316 | 2022-05-04 | Walsh | North Dakota | 38099 | 3362 | 34 |
2469060 | 2469060 | 2022-05-03 | Walsh | North Dakota | 38099 | 3362 | 34 |
2465804 | 2465804 | 2022-05-02 | Walsh | North Dakota | 38099 | 3362 | 34 |
2462549 | 2462549 | 2022-05-01 | Walsh | North Dakota | 38099 | 3362 | 34 |
2459293 | 2459293 | 2022-04-30 | Walsh | North Dakota | 38099 | 3362 | 34 |
2456037 | 2456037 | 2022-04-29 | Walsh | North Dakota | 38099 | 3362 | 34 |
2449707 | 2449707 | 2022-04-27 | Curry | Oregon | 41015 | 3362 | 54 |
2354975 | 2354975 | 2022-03-29 | Yates | New York | 36123 | 3362 | 39 |
2335518 | 2335518 | 2022-03-23 | Mitchell | North Carolina | 37121 | 3362 | 34 |
2332264 | 2332264 | 2022-03-22 | Mitchell | North Carolina | 37121 | 3362 | 34 |
2319034 | 2319034 | 2022-03-18 | Seward | Nebraska | 31159 | 3362 | 41 |
2315781 | 2315781 | 2022-03-17 | Seward | Nebraska | 31159 | 3362 | 41 |
2283260 | 2283260 | 2022-03-07 | Seward | Nebraska | 31159 | 3362 | 41 |
2237878 | 2237878 | 2022-02-21 | Schuyler | New York | 36097 | 3362 | 24 |
2237979 | 2237979 | 2022-02-21 | Swain | North Carolina | 37173 | 3362 | 34 |
2217320 | 2217320 | 2022-02-15 | Harrison | Iowa | 19085 | 3362 | 90 |
2214069 | 2214069 | 2022-02-14 | Harrison | Iowa | 19085 | 3362 | 90 |
2214327 | 2214327 | 2022-02-14 | Pendleton | Kentucky | 21191 | 3362 | 33 |
2210817 | 2210817 | 2022-02-13 | Harrison | Iowa | 19085 | 3362 | 90 |
2207564 | 2207564 | 2022-02-12 | Harrison | Iowa | 19085 | 3362 | 90 |
2204311 | 2204311 | 2022-02-11 | Harrison | Iowa | 19085 | 3362 | 90 |
2201058 | 2201058 | 2022-02-10 | Harrison | Iowa | 19085 | 3362 | 90 |
2203431 | 2203431 | 2022-02-10 | Rusk | Wisconsin | 55107 | 3362 | 47 |
2197804 | 2197804 | 2022-02-09 | Harrison | Iowa | 19085 | 3362 | 90 |
2188693 | 2188693 | 2022-02-06 | Walthall | Mississippi | 28147 | 3362 | 72 |
2185440 | 2185440 | 2022-02-05 | Walthall | Mississippi | 28147 | 3362 | 72 |
2182188 | 2182188 | 2022-02-04 | Walthall | Mississippi | 28147 | 3362 | 72 |
2165994 | 2165994 | 2022-01-30 | Madison | Missouri | 29123 | 3362 | 46 |
2159483 | 2159483 | 2022-01-28 | Macon | Missouri | 29121 | 3362 | 40 |
2154323 | 2154323 | 2022-01-26 | Unknown | Utah | 3362 | 59 | |
2144642 | 2144642 | 2022-01-23 | Greene | Virginia | 51079 | 3362 | 47 |
2141387 | 2141387 | 2022-01-22 | Greene | Virginia | 51079 | 3362 | 47 |
2138131 | 2138131 | 2022-01-21 | Greene | Virginia | 51079 | 3362 | 47 |
2123706 | 2123706 | 2022-01-17 | Morgan | Missouri | 29141 | 3362 | 79 |
2119287 | 2119287 | 2022-01-16 | Brantley | Georgia | 13025 | 3362 | 92 |
2120454 | 2120454 | 2022-01-16 | Morgan | Missouri | 29141 | 3362 | 79 |
2116035 | 2116035 | 2022-01-15 | Brantley | Georgia | 13025 | 3362 | 92 |
2117202 | 2117202 | 2022-01-15 | Morgan | Missouri | 29141 | 3362 | 79 |
2112784 | 2112784 | 2022-01-14 | Brantley | Georgia | 13025 | 3362 | 92 |
2112262 | 2112262 | 2022-01-13 | Morgan | West Virginia | 54065 | 3362 | 57 |
2108227 | 2108227 | 2022-01-12 | Catano | Puerto Rico | 72033 | 3362 | |
2086509 | 2086509 | 2022-01-06 | Hempstead | Arkansas | 5057 | 3362 | 49 |
2076646 | 2076646 | 2022-01-03 | Henry | Alabama | 1067 | 3362 | 66 |
2062120 | 2062120 | 2021-12-29 | Washington | Nebraska | 31177 | 3362 | 30 |
2035713 | 2035713 | 2021-12-21 | Fillmore | Minnesota | 27045 | 3362 | 15 |
2024639 | 2024639 | 2021-12-18 | Fayette | Alabama | 1057 | 3362 | 86 |
2011733 | 2011733 | 2021-12-14 | Conway | Arkansas | 5029 | 3362 | 47 |
1994541 | 1994541 | 2021-12-08 | Fairfield | South Carolina | 45039 | 3362 | 93 |
1991184 | 1991184 | 2021-12-07 | Wyoming | Pennsylvania | 42131 | 3362 | 69 |
1991290 | 1991290 | 2021-12-07 | Fairfield | South Carolina | 45039 | 3362 | 93 |
1949967 | 1949967 | 2021-11-25 | Clark | Arkansas | 5019 | 3362 | 61 |
1940144 | 1940144 | 2021-11-22 | Monroe | Alabama | 1099 | 3362 | 66 |
1930133 | 1930133 | 2021-11-18 | Scott | Virginia | 51169 | 3362 | 83 |
1915513 | 1915513 | 2021-11-14 | Attala | Mississippi | 28007 | 3362 | 90 |
1912263 | 1912263 | 2021-11-13 | Attala | Mississippi | 28007 | 3362 | 90 |
1909013 | 1909013 | 2021-11-12 | Attala | Mississippi | 28007 | 3362 | 90 |
1901877 | 1901877 | 2021-11-10 | Sullivan | Indiana | 18153 | 3362 | 55 |
1872236 | 1872236 | 2021-11-01 | Unknown | Florida | 3362 | 22 | |
1869219 | 1869219 | 2021-10-31 | Crawford | Illinois | 17033 | 3362 | 46 |
1865970 | 1865970 | 2021-10-30 | Crawford | Illinois | 17033 | 3362 | 46 |
1862721 | 1862721 | 2021-10-29 | Crawford | Illinois | 17033 | 3362 | 46 |
1846584 | 1846584 | 2021-10-24 | Fountain | Indiana | 18045 | 3362 | 62 |
1843334 | 1843334 | 2021-10-23 | Fountain | Indiana | 18045 | 3362 | 62 |
1840084 | 1840084 | 2021-10-22 | Fountain | Indiana | 18045 | 3362 | 62 |
1836751 | 1836751 | 2021-10-21 | Jersey | Illinois | 17083 | 3362 | 72 |
1826485 | 1826485 | 2021-10-18 | Columbia | Arkansas | 5027 | 3362 | 72 |
1783232 | 1783232 | 2021-10-04 | Dorado | Puerto Rico | 72051 | 3362 | |
1767341 | 1767341 | 2021-09-29 | Gray | Texas | 48179 | 3362 | 68 |
1756367 | 1756367 | 2021-09-26 | Tishomingo | Mississippi | 28141 | 3362 | 89 |
1756575 | 1756575 | 2021-09-26 | Dawson | Nebraska | 31047 | 3362 | 31 |
1753119 | 1753119 | 2021-09-25 | Tishomingo | Mississippi | 28141 | 3362 | 89 |
1753327 | 1753327 | 2021-09-25 | Dawson | Nebraska | 31047 | 3362 | 31 |
1749871 | 1749871 | 2021-09-24 | Tishomingo | Mississippi | 28141 | 3362 | 89 |
1750079 | 1750079 | 2021-09-24 | Dawson | Nebraska | 31047 | 3362 | 31 |
1735922 | 1735922 | 2021-09-20 | Union | Georgia | 13291 | 3362 | 100 |
1713390 | 1713390 | 2021-09-13 | Jennings | Indiana | 18079 | 3362 | 54 |
1701135 | 1701135 | 2021-09-09 | Stone | Mississippi | 28131 | 3362 | 50 |
1698532 | 1698532 | 2021-09-08 | Pike | Ohio | 39131 | 3362 | 38 |
1695909 | 1695909 | 2021-09-07 | Karnes | Texas | 48255 | 3362 | 41 |
1692661 | 1692661 | 2021-09-06 | Karnes | Texas | 48255 | 3362 | 41 |
1689412 | 1689412 | 2021-09-05 | Karnes | Texas | 48255 | 3362 | 41 |
1686162 | 1686162 | 2021-09-04 | Karnes | Texas | 48255 | 3362 | 41 |
1686547 | 1686547 | 2021-09-04 | Preston | West Virginia | 54077 | 3362 | 50 |
1632892 | 1632892 | 2021-08-19 | Marion | Mississippi | 28091 | 3362 | 85 |
1596814 | 1596814 | 2021-08-08 | Taylor | Kentucky | 21217 | 3362 | 55 |
1593565 | 1593565 | 2021-08-07 | Taylor | Kentucky | 21217 | 3362 | 55 |
1590316 | 1590316 | 2021-08-06 | Taylor | Kentucky | 21217 | 3362 | 55 |
1585005 | 1585005 | 2021-08-04 | Jefferson | Pennsylvania | 42065 | 3362 | 99 |
1536221 | 1536221 | 2021-07-20 | Benton | Oregon | 41003 | 3362 | 22 |
1537173 | 1537173 | 2021-07-20 | Juneau | Wisconsin | 55057 | 3362 | 31 |
1519361 | 1519361 | 2021-07-15 | Warren | Missouri | 29219 | 3362 | 39 |
1515890 | 1515890 | 2021-07-14 | Pine | Minnesota | 27115 | 3362 | 23 |
1494535 | 1494535 | 2021-07-07 | Kendall | Texas | 48259 | 3362 | 72 |
1491612 | 1491612 | 2021-07-06 | Kittitas | Washington | 53037 | 3362 | 36 |
1474076 | 1474076 | 2021-07-01 | Lyon | Nevada | 32019 | 3362 | 65 |
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);