ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
456 rows where cases = 1059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 41
- North Dakota 40
- Nebraska 39
- Missouri 33
- Georgia 31
- Mississippi 29
- Kentucky 21
- Michigan 18
- Montana 14
- Oklahoma 13
- South Dakota 12
- Kansas 11
- Minnesota 11
- Puerto Rico 10
- Alaska 9
- Florida 9
- Virginia 9
- Illinois 8
- Wisconsin 8
- Arkansas 7
- Iowa 7
- West Virginia 7
- North Carolina 6
- Washington 6
- Alabama 5
- Indiana 5
- Tennessee 5
- Utah 5
- Louisiana 4
- Ohio 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500211 | 2500211 | 2022-05-13 | Hardin | Illinois | 17069 | 1059 | 20 |
2496953 | 2496953 | 2022-05-12 | Hardin | Illinois | 17069 | 1059 | 20 |
2493695 | 2493695 | 2022-05-11 | Hardin | Illinois | 17069 | 1059 | 20 |
2490437 | 2490437 | 2022-05-10 | Hardin | Illinois | 17069 | 1059 | 20 |
2429973 | 2429973 | 2022-04-21 | Pierce | North Dakota | 38069 | 1059 | 32 |
2426717 | 2426717 | 2022-04-20 | Pierce | North Dakota | 38069 | 1059 | 32 |
2423461 | 2423461 | 2022-04-19 | Pierce | North Dakota | 38069 | 1059 | 32 |
2420204 | 2420204 | 2022-04-18 | Pierce | North Dakota | 38069 | 1059 | 32 |
2416949 | 2416949 | 2022-04-17 | Pierce | North Dakota | 38069 | 1059 | 32 |
2413693 | 2413693 | 2022-04-16 | Pierce | North Dakota | 38069 | 1059 | 32 |
2410437 | 2410437 | 2022-04-15 | Pierce | North Dakota | 38069 | 1059 | 32 |
2407181 | 2407181 | 2022-04-14 | Pierce | North Dakota | 38069 | 1059 | 32 |
2403925 | 2403925 | 2022-04-13 | Pierce | North Dakota | 38069 | 1059 | 32 |
2400670 | 2400670 | 2022-04-12 | Pierce | North Dakota | 38069 | 1059 | 32 |
2401309 | 2401309 | 2022-04-12 | Crockett | Texas | 48105 | 1059 | 19 |
2397415 | 2397415 | 2022-04-11 | Pierce | North Dakota | 38069 | 1059 | 32 |
2394160 | 2394160 | 2022-04-10 | Pierce | North Dakota | 38069 | 1059 | 32 |
2390904 | 2390904 | 2022-04-09 | Pierce | North Dakota | 38069 | 1059 | 32 |
2387648 | 2387648 | 2022-04-08 | Pierce | North Dakota | 38069 | 1059 | 32 |
2376380 | 2376380 | 2022-04-05 | Warren | Georgia | 13301 | 1059 | 30 |
2373128 | 2373128 | 2022-04-04 | Warren | Georgia | 13301 | 1059 | 30 |
2369875 | 2369875 | 2022-04-03 | Warren | Georgia | 13301 | 1059 | 29 |
2366622 | 2366622 | 2022-04-02 | Warren | Georgia | 13301 | 1059 | 29 |
2363369 | 2363369 | 2022-04-01 | Warren | Georgia | 13301 | 1059 | 29 |
2360115 | 2360115 | 2022-03-31 | Warren | Georgia | 13301 | 1059 | 29 |
2361618 | 2361618 | 2022-03-31 | Pierce | North Dakota | 38069 | 1059 | 32 |
2356861 | 2356861 | 2022-03-30 | Warren | Georgia | 13301 | 1059 | 29 |
2358364 | 2358364 | 2022-03-30 | Pierce | North Dakota | 38069 | 1059 | 32 |
2355110 | 2355110 | 2022-03-29 | Pierce | North Dakota | 38069 | 1059 | 32 |
2351857 | 2351857 | 2022-03-28 | Pierce | North Dakota | 38069 | 1059 | 32 |
2348605 | 2348605 | 2022-03-27 | Pierce | North Dakota | 38069 | 1059 | 32 |
2345352 | 2345352 | 2022-03-26 | Pierce | North Dakota | 38069 | 1059 | 32 |
2342099 | 2342099 | 2022-03-25 | Pierce | North Dakota | 38069 | 1059 | 32 |
2338846 | 2338846 | 2022-03-24 | Pierce | North Dakota | 38069 | 1059 | 32 |
2335592 | 2335592 | 2022-03-23 | Pierce | North Dakota | 38069 | 1059 | 32 |
2331947 | 2331947 | 2022-03-22 | Phillips | Montana | 30071 | 1059 | 28 |
2332338 | 2332338 | 2022-03-22 | Pierce | North Dakota | 38069 | 1059 | 32 |
2328694 | 2328694 | 2022-03-21 | Phillips | Montana | 30071 | 1059 | 28 |
2329085 | 2329085 | 2022-03-21 | Pierce | North Dakota | 38069 | 1059 | 32 |
2325442 | 2325442 | 2022-03-20 | Phillips | Montana | 30071 | 1059 | 28 |
2325833 | 2325833 | 2022-03-20 | Pierce | North Dakota | 38069 | 1059 | 32 |
2322188 | 2322188 | 2022-03-19 | Phillips | Montana | 30071 | 1059 | 28 |
2322580 | 2322580 | 2022-03-19 | Pierce | North Dakota | 38069 | 1059 | 32 |
2318934 | 2318934 | 2022-03-18 | Phillips | Montana | 30071 | 1059 | 28 |
2319326 | 2319326 | 2022-03-18 | Pierce | North Dakota | 38069 | 1059 | 32 |
2315681 | 2315681 | 2022-03-17 | Phillips | Montana | 30071 | 1059 | 28 |
2316072 | 2316072 | 2022-03-17 | Pierce | North Dakota | 38069 | 1059 | 32 |
2312819 | 2312819 | 2022-03-16 | Pierce | North Dakota | 38069 | 1059 | 32 |
2309566 | 2309566 | 2022-03-15 | Pierce | North Dakota | 38069 | 1059 | 32 |
2306313 | 2306313 | 2022-03-14 | Pierce | North Dakota | 38069 | 1059 | 32 |
2303062 | 2303062 | 2022-03-13 | Pierce | North Dakota | 38069 | 1059 | 32 |
2299810 | 2299810 | 2022-03-12 | Pierce | North Dakota | 38069 | 1059 | 32 |
2296558 | 2296558 | 2022-03-11 | Pierce | North Dakota | 38069 | 1059 | 32 |
2293306 | 2293306 | 2022-03-10 | Pierce | North Dakota | 38069 | 1059 | 32 |
2280737 | 2280737 | 2022-03-06 | Corson | South Dakota | 46031 | 1059 | 17 |
2277484 | 2277484 | 2022-03-05 | Corson | South Dakota | 46031 | 1059 | 17 |
2274231 | 2274231 | 2022-03-04 | Corson | South Dakota | 46031 | 1059 | 17 |
2270875 | 2270875 | 2022-03-03 | Las Marias | Puerto Rico | 72083 | 1059 | |
2270978 | 2270978 | 2022-03-03 | Corson | South Dakota | 46031 | 1059 | 17 |
2264473 | 2264473 | 2022-03-01 | Corson | South Dakota | 46031 | 1059 | 17 |
2261223 | 2261223 | 2022-02-28 | Corson | South Dakota | 46031 | 1059 | 17 |
2177111 | 2177111 | 2022-02-02 | Essex | Vermont | 50009 | 1059 | 3 |
2151930 | 2151930 | 2022-01-26 | Schley | Georgia | 13249 | 1059 | 8 |
2152096 | 2152096 | 2022-01-26 | Putnam | Illinois | 17155 | 1059 | 8 |
2146645 | 2146645 | 2022-01-24 | Morrill | Nebraska | 31123 | 1059 | 17 |
2134967 | 2134967 | 2022-01-20 | Ferry | Washington | 53019 | 1059 | 19 |
2130142 | 2130142 | 2022-01-19 | Atchison | Missouri | 29005 | 1059 | 19 |
2120565 | 2120565 | 2022-01-16 | Burt | Nebraska | 31021 | 1059 | 14 |
2117313 | 2117313 | 2022-01-15 | Burt | Nebraska | 31021 | 1059 | 14 |
2114062 | 2114062 | 2022-01-14 | Burt | Nebraska | 31021 | 1059 | 14 |
2115213 | 2115213 | 2022-01-14 | San Saba | Texas | 48411 | 1059 | 29 |
2108705 | 2108705 | 2022-01-12 | Sabine | Texas | 48403 | 1059 | 79 |
2102694 | 2102694 | 2022-01-11 | Aleutians West Census Area | Alaska | 2016 | 1059 | 1 |
2099443 | 2099443 | 2022-01-10 | Aleutians West Census Area | Alaska | 2016 | 1059 | 1 |
2102608 | 2102608 | 2022-01-10 | Crook | Wyoming | 56011 | 1059 | 22 |
2097651 | 2097651 | 2022-01-09 | Dade | Missouri | 29057 | 1059 | 38 |
2094399 | 2094399 | 2022-01-08 | Dade | Missouri | 29057 | 1059 | 38 |
2092414 | 2092414 | 2022-01-07 | Mitchell | Texas | 48335 | 1059 | 44 |
2089162 | 2089162 | 2022-01-06 | Mitchell | Texas | 48335 | 1059 | 44 |
2074459 | 2074459 | 2022-01-02 | Owsley | Kentucky | 21189 | 1059 | 23 |
2071208 | 2071208 | 2022-01-01 | Owsley | Kentucky | 21189 | 1059 | 23 |
2067957 | 2067957 | 2021-12-31 | Owsley | Kentucky | 21189 | 1059 | 23 |
2064706 | 2064706 | 2021-12-30 | Owsley | Kentucky | 21189 | 1059 | 23 |
2061456 | 2061456 | 2021-12-29 | Owsley | Kentucky | 21189 | 1059 | 23 |
1984036 | 1984036 | 2021-12-05 | Cedar | Nebraska | 31027 | 1059 | 11 |
1980786 | 1980786 | 2021-12-04 | Cedar | Nebraska | 31027 | 1059 | 11 |
1977536 | 1977536 | 2021-12-03 | Cedar | Nebraska | 31027 | 1059 | 11 |
1972032 | 1972032 | 2021-12-01 | Crosby | Texas | 48107 | 1059 | 37 |
1967473 | 1967473 | 2021-11-30 | Mahnomen | Minnesota | 27087 | 1059 | 14 |
1964345 | 1964345 | 2021-11-29 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1961094 | 1961094 | 2021-11-28 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1957843 | 1957843 | 2021-11-27 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1954592 | 1954592 | 2021-11-26 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1951341 | 1951341 | 2021-11-25 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1948090 | 1948090 | 2021-11-24 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1948933 | 1948933 | 2021-11-24 | Aibonito | Puerto Rico | 72009 | 1059 | |
1944839 | 1944839 | 2021-11-23 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1941588 | 1941588 | 2021-11-22 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1938338 | 1938338 | 2021-11-21 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
1935088 | 1935088 | 2021-11-20 | Wilkinson | Mississippi | 28157 | 1059 | 39 |
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);