ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
410 rows where cases = 1092 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31
- Missouri 24
- Idaho 23
- Georgia 22
- Puerto Rico 19
- Virginia 19
- Michigan 18
- Mississippi 17
- Illinois 15
- Montana 15
- Kentucky 14
- Minnesota 14
- Louisiana 13
- Indiana 12
- Kansas 12
- Ohio 12
- Arkansas 11
- Nebraska 10
- North Carolina 10
- Alabama 7
- Vermont 7
- Colorado 6
- Iowa 6
- Pennsylvania 6
- West Virginia 6
- Florida 5
- Tennessee 5
- Washington 5
- Wisconsin 5
- California 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501903 | 2501903 | 2022-05-13 | Sullivan | Pennsylvania | 42113 | 1092 | 36 |
2498645 | 2498645 | 2022-05-12 | Sullivan | Pennsylvania | 42113 | 1092 | 36 |
2495387 | 2495387 | 2022-05-11 | Sullivan | Pennsylvania | 42113 | 1092 | 36 |
2483851 | 2483851 | 2022-05-08 | Boise | Idaho | 16015 | 1092 | 14 |
2484694 | 2484694 | 2022-05-08 | Unknown | Minnesota | 1092 | 280 | |
2480593 | 2480593 | 2022-05-07 | Boise | Idaho | 16015 | 1092 | 14 |
2481436 | 2481436 | 2022-05-07 | Unknown | Minnesota | 1092 | 280 | |
2477335 | 2477335 | 2022-05-06 | Boise | Idaho | 16015 | 1092 | 14 |
2478178 | 2478178 | 2022-05-06 | Unknown | Minnesota | 1092 | 280 | |
2474077 | 2474077 | 2022-05-05 | Boise | Idaho | 16015 | 1092 | 14 |
2470820 | 2470820 | 2022-05-04 | Boise | Idaho | 16015 | 1092 | 14 |
2467564 | 2467564 | 2022-05-03 | Boise | Idaho | 16015 | 1092 | 14 |
2464309 | 2464309 | 2022-05-02 | Boise | Idaho | 16015 | 1092 | 14 |
2461053 | 2461053 | 2022-05-01 | Boise | Idaho | 16015 | 1092 | 14 |
2457797 | 2457797 | 2022-04-30 | Boise | Idaho | 16015 | 1092 | 14 |
2454541 | 2454541 | 2022-04-29 | Boise | Idaho | 16015 | 1092 | 14 |
2423064 | 2423064 | 2022-04-19 | Mineral | Montana | 30061 | 1092 | 17 |
2424470 | 2424470 | 2022-04-19 | Surry | Virginia | 51181 | 1092 | 19 |
2421214 | 2421214 | 2022-04-18 | Surry | Virginia | 51181 | 1092 | 19 |
2417831 | 2417831 | 2022-04-17 | Unknown | Vermont | 1092 | 1 | |
2417958 | 2417958 | 2022-04-17 | Surry | Virginia | 51181 | 1092 | 19 |
2414575 | 2414575 | 2022-04-16 | Unknown | Vermont | 1092 | 1 | |
2414702 | 2414702 | 2022-04-16 | Surry | Virginia | 51181 | 1092 | 19 |
2411319 | 2411319 | 2022-04-15 | Unknown | Vermont | 1092 | 1 | |
2411446 | 2411446 | 2022-04-15 | Surry | Virginia | 51181 | 1092 | 19 |
2393794 | 2393794 | 2022-04-10 | Boone | Nebraska | 31011 | 1092 | 4 |
2390538 | 2390538 | 2022-04-09 | Boone | Nebraska | 31011 | 1092 | 4 |
2391240 | 2391240 | 2022-04-09 | Las Marias | Puerto Rico | 72083 | 1092 | |
2387282 | 2387282 | 2022-04-08 | Boone | Nebraska | 31011 | 1092 | 4 |
2384027 | 2384027 | 2022-04-07 | Boone | Nebraska | 31011 | 1092 | 4 |
2380772 | 2380772 | 2022-04-06 | Boone | Nebraska | 31011 | 1092 | 4 |
2377517 | 2377517 | 2022-04-05 | Boone | Nebraska | 31011 | 1092 | 4 |
2307150 | 2307150 | 2022-03-14 | Yoakum | Texas | 48501 | 1092 | 41 |
2303899 | 2303899 | 2022-03-13 | Yoakum | Texas | 48501 | 1092 | 41 |
2222696 | 2222696 | 2022-02-16 | Emporia city | Virginia | 51595 | 1092 | 49 |
2197265 | 2197265 | 2022-02-09 | Saguache | Colorado | 8109 | 1092 | 12 |
2157632 | 2157632 | 2022-01-27 | Cumberland | Virginia | 51049 | 1092 | 19 |
2146578 | 2146578 | 2022-01-24 | Toole | Montana | 30101 | 1092 | 21 |
2147782 | 2147782 | 2022-01-24 | Wheeler | Texas | 48483 | 1092 | 15 |
2143276 | 2143276 | 2022-01-23 | Broadwater | Montana | 30007 | 1092 | 18 |
2140021 | 2140021 | 2022-01-22 | Broadwater | Montana | 30007 | 1092 | 18 |
2136765 | 2136765 | 2022-01-21 | Broadwater | Montana | 30007 | 1092 | 18 |
2109368 | 2109368 | 2022-01-13 | Trinity | California | 6105 | 1092 | 19 |
2110655 | 2110655 | 2022-01-13 | Dade | Missouri | 29057 | 1092 | 38 |
2055243 | 2055243 | 2021-12-27 | Norman | Minnesota | 27107 | 1092 | 10 |
2056261 | 2056261 | 2021-12-27 | Santa Isabel | Puerto Rico | 72133 | 1092 | |
2032709 | 2032709 | 2021-12-20 | Shelby | Missouri | 29205 | 1092 | 13 |
2023716 | 2023716 | 2021-12-17 | Comerio | Puerto Rico | 72045 | 1092 | |
2004535 | 2004535 | 2021-12-11 | Crosby | Texas | 48107 | 1092 | 39 |
1997875 | 1997875 | 2021-12-09 | Spink | South Dakota | 46115 | 1092 | 29 |
1994345 | 1994345 | 2021-12-08 | Grant | Oregon | 41023 | 1092 | 16 |
1991094 | 1991094 | 2021-12-07 | Grant | Oregon | 41023 | 1092 | 16 |
1983913 | 1983913 | 2021-12-05 | Maries | Missouri | 29125 | 1092 | 21 |
1984073 | 1984073 | 2021-12-05 | Keith | Nebraska | 31101 | 1092 | 11 |
1980823 | 1980823 | 2021-12-04 | Keith | Nebraska | 31101 | 1092 | 11 |
1977573 | 1977573 | 2021-12-03 | Keith | Nebraska | 31101 | 1092 | 11 |
1970031 | 1970031 | 2021-12-01 | Pulaski | Illinois | 17153 | 1092 | 12 |
1964446 | 1964446 | 2021-11-29 | Shannon | Missouri | 29203 | 1092 | 27 |
1937451 | 1937451 | 2021-11-21 | Brown | Illinois | 17009 | 1092 | 18 |
1934201 | 1934201 | 2021-11-20 | Brown | Illinois | 17009 | 1092 | 18 |
1930950 | 1930950 | 2021-11-19 | Brown | Illinois | 17009 | 1092 | 18 |
1932360 | 1932360 | 2021-11-19 | Dickey | North Dakota | 38021 | 1092 | 36 |
1927699 | 1927699 | 2021-11-18 | Brown | Illinois | 17009 | 1092 | 18 |
1928621 | 1928621 | 2021-11-18 | Daviess | Missouri | 29061 | 1092 | 16 |
1924449 | 1924449 | 2021-11-17 | Brown | Illinois | 17009 | 1092 | 18 |
1919101 | 1919101 | 2021-11-15 | Thurston | Nebraska | 31173 | 1092 | 15 |
1914690 | 1914690 | 2021-11-14 | Power | Idaho | 16077 | 1092 | 15 |
1911440 | 1911440 | 2021-11-13 | Power | Idaho | 16077 | 1092 | 15 |
1908191 | 1908191 | 2021-11-12 | Power | Idaho | 16077 | 1092 | 15 |
1906841 | 1906841 | 2021-11-11 | Hutchinson | South Dakota | 46067 | 1092 | 28 |
1903592 | 1903592 | 2021-11-10 | Hutchinson | South Dakota | 46067 | 1092 | 28 |
1842792 | 1842792 | 2021-10-23 | Woodruff | Arkansas | 5147 | 1092 | 24 |
1830508 | 1830508 | 2021-10-19 | Anderson | Kansas | 20003 | 1092 | 21 |
1827259 | 1827259 | 2021-10-18 | Anderson | Kansas | 20003 | 1092 | 21 |
1814151 | 1814151 | 2021-10-14 | Union | Indiana | 18161 | 1092 | 16 |
1804179 | 1804179 | 2021-10-11 | Benewah | Idaho | 16009 | 1092 | 17 |
1800930 | 1800930 | 2021-10-10 | Benewah | Idaho | 16009 | 1092 | 17 |
1801460 | 1801460 | 2021-10-10 | Nicholas | Kentucky | 21181 | 1092 | 15 |
1801944 | 1801944 | 2021-10-10 | Ozark | Missouri | 29153 | 1092 | 29 |
1797681 | 1797681 | 2021-10-09 | Benewah | Idaho | 16009 | 1092 | 17 |
1798211 | 1798211 | 2021-10-09 | Nicholas | Kentucky | 21181 | 1092 | 15 |
1798695 | 1798695 | 2021-10-09 | Ozark | Missouri | 29153 | 1092 | 29 |
1794962 | 1794962 | 2021-10-08 | Nicholas | Kentucky | 21181 | 1092 | 15 |
1790244 | 1790244 | 2021-10-06 | Winkler | Texas | 48495 | 1092 | 27 |
1785662 | 1785662 | 2021-10-05 | Harrison | Missouri | 29081 | 1092 | 17 |
1787179 | 1787179 | 2021-10-05 | Williamsburg city | Virginia | 51830 | 1092 | 14 |
1762498 | 1762498 | 2021-09-28 | Wolfe | Kentucky | 21237 | 1092 | 8 |
1756223 | 1756223 | 2021-09-26 | Clearwater | Minnesota | 27029 | 1092 | 18 |
1752975 | 1752975 | 2021-09-25 | Clearwater | Minnesota | 27029 | 1092 | 18 |
1749727 | 1749727 | 2021-09-24 | Clearwater | Minnesota | 27029 | 1092 | 18 |
1745294 | 1745294 | 2021-09-23 | Montgomery | Arkansas | 5097 | 1092 | 37 |
1743396 | 1743396 | 2021-09-22 | Caldwell | Missouri | 29025 | 1092 | 18 |
1731536 | 1731536 | 2021-09-18 | Brooks | Texas | 48047 | 1092 | 43 |
1712944 | 1712944 | 2021-09-13 | Rio Grande | Colorado | 8105 | 1092 | 20 |
1709529 | 1709529 | 2021-09-12 | Dallas | Arkansas | 5039 | 1092 | 18 |
1711341 | 1711341 | 2021-09-12 | Graham | North Carolina | 37075 | 1092 | 19 |
1706282 | 1706282 | 2021-09-11 | Dallas | Arkansas | 5039 | 1092 | 18 |
1708094 | 1708094 | 2021-09-11 | Graham | North Carolina | 37075 | 1092 | 19 |
1703034 | 1703034 | 2021-09-10 | Dallas | Arkansas | 5039 | 1092 | 18 |
1704847 | 1704847 | 2021-09-10 | Graham | North Carolina | 37075 | 1092 | 19 |
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);