ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
425 rows where cases = 1292 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 46
- Texas 28
- Vermont 28
- Virginia 23
- Kentucky 21
- North Dakota 18
- Mississippi 16
- Georgia 15
- Nebraska 15
- Puerto Rico 15
- South Dakota 15
- Tennessee 12
- West Virginia 12
- Arkansas 11
- Idaho 11
- Wisconsin 11
- Kansas 10
- Minnesota 10
- Ohio 10
- Alabama 9
- Indiana 8
- North Carolina 8
- Illinois 7
- Missouri 7
- Montana 7
- Oregon 7
- Washington 5
- California 4
- Oklahoma 4
- Alaska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495980 | 2495980 | 2022-05-11 | Essex | Vermont | 50009 | 1292 | 3 |
2492288 | 2492288 | 2022-05-10 | Day | South Dakota | 46037 | 1292 | 35 |
2489030 | 2489030 | 2022-05-09 | Day | South Dakota | 46037 | 1292 | 35 |
2485029 | 2485029 | 2022-05-08 | Pierce | Nebraska | 31139 | 1292 | 21 |
2485667 | 2485667 | 2022-05-08 | Las Marias | Puerto Rico | 72083 | 1292 | |
2485773 | 2485773 | 2022-05-08 | Day | South Dakota | 46037 | 1292 | 35 |
2486249 | 2486249 | 2022-05-08 | Covington city | Virginia | 51580 | 1292 | 26 |
2481771 | 2481771 | 2022-05-07 | Pierce | Nebraska | 31139 | 1292 | 21 |
2482515 | 2482515 | 2022-05-07 | Day | South Dakota | 46037 | 1292 | 35 |
2482991 | 2482991 | 2022-05-07 | Covington city | Virginia | 51580 | 1292 | 26 |
2478513 | 2478513 | 2022-05-06 | Pierce | Nebraska | 31139 | 1292 | 21 |
2479257 | 2479257 | 2022-05-06 | Day | South Dakota | 46037 | 1292 | 35 |
2479733 | 2479733 | 2022-05-06 | Covington city | Virginia | 51580 | 1292 | 26 |
2475255 | 2475255 | 2022-05-05 | Pierce | Nebraska | 31139 | 1292 | 21 |
2475999 | 2475999 | 2022-05-05 | Day | South Dakota | 46037 | 1292 | 35 |
2472742 | 2472742 | 2022-05-04 | Day | South Dakota | 46037 | 1292 | 35 |
2465486 | 2465486 | 2022-05-02 | Pierce | Nebraska | 31139 | 1292 | 21 |
2462231 | 2462231 | 2022-05-01 | Pierce | Nebraska | 31139 | 1292 | 21 |
2458975 | 2458975 | 2022-04-30 | Pierce | Nebraska | 31139 | 1292 | 21 |
2455719 | 2455719 | 2022-04-29 | Pierce | Nebraska | 31139 | 1292 | 21 |
2452463 | 2452463 | 2022-04-28 | Pierce | Nebraska | 31139 | 1292 | 21 |
2449207 | 2449207 | 2022-04-27 | Pierce | Nebraska | 31139 | 1292 | 21 |
2445950 | 2445950 | 2022-04-26 | Pierce | Nebraska | 31139 | 1292 | 21 |
2385313 | 2385313 | 2022-04-07 | Cumberland | Virginia | 51049 | 1292 | 26 |
2273782 | 2273782 | 2022-03-04 | McHenry | North Dakota | 38049 | 1292 | 30 |
2270529 | 2270529 | 2022-03-03 | McHenry | North Dakota | 38049 | 1292 | 30 |
2267277 | 2267277 | 2022-03-02 | McHenry | North Dakota | 38049 | 1292 | 30 |
2264025 | 2264025 | 2022-03-01 | McHenry | North Dakota | 38049 | 1292 | 30 |
2215732 | 2215732 | 2022-02-14 | Kingsbury | South Dakota | 46077 | 1292 | 20 |
2189252 | 2189252 | 2022-02-06 | Sioux | North Dakota | 38085 | 1292 | 19 |
2185999 | 2185999 | 2022-02-05 | Sioux | North Dakota | 38085 | 1292 | 19 |
2182747 | 2182747 | 2022-02-04 | Sioux | North Dakota | 38085 | 1292 | 19 |
2172635 | 2172635 | 2022-02-01 | Dawes | Nebraska | 31045 | 1292 | 21 |
2173456 | 2173456 | 2022-02-01 | Moody | South Dakota | 46101 | 1292 | 27 |
2169382 | 2169382 | 2022-01-31 | Dawes | Nebraska | 31045 | 1292 | 21 |
2157825 | 2157825 | 2022-01-27 | Wirt | West Virginia | 54105 | 1292 | 19 |
2153925 | 2153925 | 2022-01-26 | McCook | South Dakota | 46087 | 1292 | 30 |
2145675 | 2145675 | 2022-01-24 | Ohio | Indiana | 18115 | 1292 | 16 |
2142254 | 2142254 | 2022-01-23 | Power | Idaho | 16077 | 1292 | 17 |
2138999 | 2138999 | 2022-01-22 | Power | Idaho | 16077 | 1292 | 17 |
2135743 | 2135743 | 2022-01-21 | Power | Idaho | 16077 | 1292 | 17 |
2134365 | 2134365 | 2022-01-20 | Brule | South Dakota | 46015 | 1292 | 18 |
2124786 | 2124786 | 2022-01-17 | Brooks | Texas | 48047 | 1292 | 48 |
2099231 | 2099231 | 2022-01-09 | Calhoun | West Virginia | 54013 | 1292 | 9 |
2080024 | 2080024 | 2022-01-04 | Monroe | Arkansas | 5095 | 1292 | 26 |
2074298 | 2074298 | 2022-01-02 | Harper | Kansas | 20077 | 1292 | 25 |
2071047 | 2071047 | 2022-01-01 | Harper | Kansas | 20077 | 1292 | 25 |
2067796 | 2067796 | 2021-12-31 | Harper | Kansas | 20077 | 1292 | 25 |
2064545 | 2064545 | 2021-12-30 | Harper | Kansas | 20077 | 1292 | 25 |
2061295 | 2061295 | 2021-12-29 | Harper | Kansas | 20077 | 1292 | 25 |
2035258 | 2035258 | 2021-12-21 | Worth | Iowa | 19195 | 1292 | 10 |
2036283 | 2036283 | 2021-12-21 | Camden | North Carolina | 37029 | 1292 | 9 |
2032008 | 2032008 | 2021-12-20 | Worth | Iowa | 19195 | 1292 | 10 |
2028757 | 2028757 | 2021-12-19 | Worth | Iowa | 19195 | 1292 | 10 |
2030878 | 2030878 | 2021-12-19 | Northumberland | Virginia | 51133 | 1292 | 37 |
2025506 | 2025506 | 2021-12-18 | Worth | Iowa | 19195 | 1292 | 10 |
2027627 | 2027627 | 2021-12-18 | Northumberland | Virginia | 51133 | 1292 | 37 |
2022255 | 2022255 | 2021-12-17 | Worth | Iowa | 19195 | 1292 | 10 |
2024376 | 2024376 | 2021-12-17 | Northumberland | Virginia | 51133 | 1292 | 37 |
2019004 | 2019004 | 2021-12-16 | Worth | Iowa | 19195 | 1292 | 10 |
2019007 | 2019007 | 2021-12-16 | Anderson | Kansas | 20003 | 1292 | 23 |
2019473 | 2019473 | 2021-12-16 | Lac qui Parle | Minnesota | 27073 | 1292 | 26 |
2015754 | 2015754 | 2021-12-15 | Worth | Iowa | 19195 | 1292 | 10 |
2015757 | 2015757 | 2021-12-15 | Anderson | Kansas | 20003 | 1292 | 23 |
2017699 | 2017699 | 2021-12-15 | Stephens | Texas | 48429 | 1292 | 37 |
2011769 | 2011769 | 2021-12-14 | Newton | Arkansas | 5101 | 1292 | 41 |
2014449 | 2014449 | 2021-12-14 | Stephens | Texas | 48429 | 1292 | 37 |
2011495 | 2011495 | 2021-12-13 | Pocahontas | West Virginia | 54075 | 1292 | 21 |
1982521 | 1982521 | 2021-12-05 | Prairie | Arkansas | 5117 | 1292 | 29 |
1984970 | 1984970 | 2021-12-05 | Van Buren | Tennessee | 47175 | 1292 | 32 |
1984993 | 1984993 | 2021-12-05 | Blanco | Texas | 48031 | 1292 | 28 |
1981720 | 1981720 | 2021-12-04 | Van Buren | Tennessee | 47175 | 1292 | 32 |
1978470 | 1978470 | 2021-12-03 | Van Buren | Tennessee | 47175 | 1292 | 32 |
1978728 | 1978728 | 2021-12-03 | Yoakum | Texas | 48501 | 1292 | 35 |
1951212 | 1951212 | 2021-11-25 | Lake | Minnesota | 27075 | 1292 | 24 |
1953049 | 1953049 | 2021-11-25 | Pepin | Wisconsin | 55091 | 1292 | 10 |
1947961 | 1947961 | 2021-11-24 | Lake | Minnesota | 27075 | 1292 | 24 |
1940642 | 1940642 | 2021-11-22 | Wilcox | Georgia | 13315 | 1292 | 60 |
1937392 | 1937392 | 2021-11-21 | Wilcox | Georgia | 13315 | 1292 | 60 |
1934142 | 1934142 | 2021-11-20 | Wilcox | Georgia | 13315 | 1292 | 60 |
1930890 | 1930890 | 2021-11-19 | Wilcox | Georgia | 13315 | 1292 | 60 |
1927640 | 1927640 | 2021-11-18 | Wilcox | Georgia | 13315 | 1292 | 60 |
1924366 | 1924366 | 2021-11-17 | Taylor | Georgia | 13269 | 1292 | 37 |
1924390 | 1924390 | 2021-11-17 | Wilcox | Georgia | 13315 | 1292 | 59 |
1924956 | 1924956 | 2021-11-17 | Trimble | Kentucky | 21223 | 1292 | 19 |
1921141 | 1921141 | 2021-11-16 | Wilcox | Georgia | 13315 | 1292 | 59 |
1917891 | 1917891 | 2021-11-15 | Wilcox | Georgia | 13315 | 1292 | 59 |
1912442 | 1912442 | 2021-11-13 | St. Clair | Missouri | 29185 | 1292 | 14 |
1906106 | 1906106 | 2021-11-11 | Wayne | Nebraska | 31179 | 1292 | 8 |
1837550 | 1837550 | 2021-10-21 | Humphreys | Mississippi | 28053 | 1292 | 38 |
1834301 | 1834301 | 2021-10-20 | Humphreys | Mississippi | 28053 | 1292 | 38 |
1825833 | 1825833 | 2021-10-17 | Hamilton | Texas | 48193 | 1292 | 29 |
1822584 | 1822584 | 2021-10-16 | Hamilton | Texas | 48193 | 1292 | 29 |
1812074 | 1812074 | 2021-10-13 | Jones | North Carolina | 37103 | 1292 | 29 |
1808825 | 1808825 | 2021-10-12 | Jones | North Carolina | 37103 | 1292 | 29 |
1809977 | 1809977 | 2021-10-12 | Gilmer | West Virginia | 54021 | 1292 | 8 |
1810111 | 1810111 | 2021-10-12 | Sublette | Wyoming | 56035 | 1292 | 13 |
1805560 | 1805560 | 2021-10-11 | Graham | North Carolina | 37075 | 1292 | 27 |
1801794 | 1801794 | 2021-10-10 | Claiborne | Mississippi | 28021 | 1292 | 36 |
1798545 | 1798545 | 2021-10-09 | Claiborne | Mississippi | 28021 | 1292 | 36 |
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);