ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
258 rows where cases = 2004 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 22
- Mississippi 16
- Michigan 15
- Tennessee 14
- Arkansas 12
- Kentucky 12
- Oklahoma 11
- Florida 9
- Georgia 9
- Illinois 9
- Louisiana 9
- New Mexico 8
- North Carolina 8
- Wisconsin 8
- Alabama 7
- Pennsylvania 7
- Indiana 6
- Iowa 6
- Missouri 6
- West Virginia 6
- Minnesota 5
- South Carolina 5
- Texas 5
- Nebraska 4
- New York 4
- Puerto Rico 4
- Wyoming 4
- Idaho 3
- Kansas 3
- Vermont 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488382 | 2488382 | 2022-05-09 | Quay | New Mexico | 35037 | 2004 | 54 |
2453692 | 2453692 | 2022-04-28 | Fairfax city | Virginia | 51600 | 2004 | 43 |
2449303 | 2449303 | 2022-04-27 | Quay | New Mexico | 35037 | 2004 | 51 |
2446046 | 2446046 | 2022-04-26 | Quay | New Mexico | 35037 | 2004 | 51 |
2442791 | 2442791 | 2022-04-25 | Quay | New Mexico | 35037 | 2004 | 51 |
2444104 | 2444104 | 2022-04-25 | Tucker | West Virginia | 54093 | 2004 | 37 |
2439535 | 2439535 | 2022-04-24 | Quay | New Mexico | 35037 | 2004 | 51 |
2436279 | 2436279 | 2022-04-23 | Quay | New Mexico | 35037 | 2004 | 51 |
2433023 | 2433023 | 2022-04-22 | Quay | New Mexico | 35037 | 2004 | 51 |
2376387 | 2376387 | 2022-04-05 | Wilcox | Georgia | 13315 | 2004 | 69 |
2326931 | 2326931 | 2022-03-20 | Pocahontas | West Virginia | 54075 | 2004 | 28 |
2323678 | 2323678 | 2022-03-19 | Pocahontas | West Virginia | 54075 | 2004 | 28 |
2320424 | 2320424 | 2022-03-18 | Pocahontas | West Virginia | 54075 | 2004 | 28 |
2317170 | 2317170 | 2022-03-17 | Pocahontas | West Virginia | 54075 | 2004 | 28 |
2260109 | 2260109 | 2022-02-28 | Lake | Minnesota | 27075 | 2004 | 28 |
2256935 | 2256935 | 2022-02-27 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2253684 | 2253684 | 2022-02-26 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2249002 | 2249002 | 2022-02-25 | Choctaw | Alabama | 1023 | 2004 | 34 |
2250433 | 2250433 | 2022-02-25 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2247182 | 2247182 | 2022-02-24 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2247359 | 2247359 | 2022-02-24 | Carbon | Montana | 30009 | 2004 | 28 |
2243931 | 2243931 | 2022-02-23 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2240680 | 2240680 | 2022-02-22 | Humphreys | Mississippi | 28053 | 2004 | 44 |
2217404 | 2217404 | 2022-02-15 | Ellsworth | Kansas | 20053 | 2004 | 31 |
2214153 | 2214153 | 2022-02-14 | Ellsworth | Kansas | 20053 | 2004 | 31 |
2214945 | 2214945 | 2022-02-14 | Holt | Nebraska | 31089 | 2004 | 18 |
2200270 | 2200270 | 2022-02-10 | Perry | Alabama | 1105 | 2004 | 41 |
2186616 | 2186616 | 2022-02-05 | Clay | Texas | 48077 | 2004 | 27 |
2177840 | 2177840 | 2022-02-03 | Atkinson | Georgia | 13003 | 2004 | 39 |
2154830 | 2154830 | 2022-01-27 | Nevada | Arkansas | 5099 | 2004 | 43 |
2151965 | 2151965 | 2022-01-26 | Wilkes | Georgia | 13317 | 2004 | 42 |
2132495 | 2132495 | 2022-01-20 | Valley | Idaho | 16085 | 2004 | 13 |
2121883 | 2121883 | 2022-01-16 | Lexington city | Virginia | 51678 | 2004 | 38 |
2118631 | 2118631 | 2022-01-15 | Lexington city | Virginia | 51678 | 2004 | 38 |
2115379 | 2115379 | 2022-01-14 | Lexington city | Virginia | 51678 | 2004 | 38 |
2087901 | 2087901 | 2022-01-06 | Douglas | Missouri | 29067 | 2004 | 67 |
2088795 | 2088795 | 2022-01-06 | Calhoun | South Carolina | 45017 | 2004 | 54 |
2050747 | 2050747 | 2021-12-26 | Fulton | Arkansas | 5049 | 2004 | 77 |
2034030 | 2034030 | 2021-12-20 | Lamoille | Vermont | 50015 | 2004 | 11 |
2022877 | 2022877 | 2021-12-17 | Cedar | Missouri | 29039 | 2004 | 42 |
1975465 | 1975465 | 2021-12-02 | Ward | Texas | 48475 | 2004 | 35 |
1971258 | 1971258 | 2021-12-01 | Yates | New York | 36123 | 2004 | 34 |
1963937 | 1963937 | 2021-11-29 | Metcalfe | Kentucky | 21169 | 2004 | 47 |
1938851 | 1938851 | 2021-11-21 | Barnes | North Dakota | 38003 | 2004 | 38 |
1935601 | 1935601 | 2021-11-20 | Barnes | North Dakota | 38003 | 2004 | 38 |
1920676 | 1920676 | 2021-11-16 | Nome Census Area | Alaska | 2180 | 2004 | 2 |
1879687 | 1879687 | 2021-11-03 | Chippewa | Minnesota | 27023 | 2004 | 40 |
1873210 | 1873210 | 2021-11-01 | Kanabec | Minnesota | 27065 | 2004 | 30 |
1850242 | 1850242 | 2021-10-25 | Claiborne | Louisiana | 22027 | 2004 | 63 |
1846992 | 1846992 | 2021-10-24 | Claiborne | Louisiana | 22027 | 2004 | 63 |
1843742 | 1843742 | 2021-10-23 | Claiborne | Louisiana | 22027 | 2004 | 63 |
1840492 | 1840492 | 2021-10-22 | Claiborne | Louisiana | 22027 | 2004 | 63 |
1834825 | 1834825 | 2021-10-20 | Mitchell | North Carolina | 37121 | 2004 | 18 |
1829761 | 1829761 | 2021-10-19 | Little River | Arkansas | 5081 | 2004 | 72 |
1825688 | 1825688 | 2021-10-17 | Lake | Tennessee | 47095 | 2004 | 31 |
1822439 | 1822439 | 2021-10-16 | Lake | Tennessee | 47095 | 2004 | 31 |
1819190 | 1819190 | 2021-10-15 | Lake | Tennessee | 47095 | 2004 | 31 |
1815941 | 1815941 | 2021-10-14 | Lake | Tennessee | 47095 | 2004 | 31 |
1810236 | 1810236 | 2021-10-13 | Chicot | Arkansas | 5017 | 2004 | 44 |
1812693 | 1812693 | 2021-10-13 | Lake | Tennessee | 47095 | 2004 | 31 |
1788865 | 1788865 | 2021-10-06 | Webster | Mississippi | 28155 | 2004 | 45 |
1769124 | 1769124 | 2021-09-30 | Antrim | Michigan | 26009 | 2004 | 34 |
1769260 | 1769260 | 2021-09-30 | Pennington | Minnesota | 27113 | 2004 | 22 |
1762406 | 1762406 | 2021-09-28 | Clinton | Kentucky | 21053 | 2004 | 33 |
1758167 | 1758167 | 2021-09-27 | Lamar | Alabama | 1075 | 2004 | 43 |
1758711 | 1758711 | 2021-09-27 | Gooding | Idaho | 16047 | 2004 | 30 |
1759158 | 1759158 | 2021-09-27 | Clinton | Kentucky | 21053 | 2004 | 33 |
1717247 | 1717247 | 2021-09-14 | Houston | Minnesota | 27055 | 2004 | 16 |
1713290 | 1713290 | 2021-09-13 | Jo Daviess | Illinois | 17085 | 2004 | 27 |
1712635 | 1712635 | 2021-09-12 | Lincoln | Wyoming | 56023 | 2004 | 14 |
1709388 | 1709388 | 2021-09-11 | Lincoln | Wyoming | 56023 | 2004 | 14 |
1706141 | 1706141 | 2021-09-10 | Lincoln | Wyoming | 56023 | 2004 | 14 |
1690949 | 1690949 | 2021-09-06 | Garrard | Kentucky | 21079 | 2004 | 37 |
1691907 | 1691907 | 2021-09-06 | Warren | North Carolina | 37185 | 2004 | 20 |
1687699 | 1687699 | 2021-09-05 | Garrard | Kentucky | 21079 | 2004 | 37 |
1688657 | 1688657 | 2021-09-05 | Warren | North Carolina | 37185 | 2004 | 20 |
1684449 | 1684449 | 2021-09-04 | Garrard | Kentucky | 21079 | 2004 | 37 |
1684983 | 1684983 | 2021-09-04 | Osage | Missouri | 29151 | 2004 | 19 |
1685407 | 1685407 | 2021-09-04 | Warren | North Carolina | 37185 | 2004 | 20 |
1681198 | 1681198 | 2021-09-03 | Garrard | Kentucky | 21079 | 2004 | 37 |
1682156 | 1682156 | 2021-09-03 | Warren | North Carolina | 37185 | 2004 | 20 |
1677264 | 1677264 | 2021-09-02 | Lafayette | Florida | 12067 | 2004 | 26 |
1674017 | 1674017 | 2021-09-01 | Lafayette | Florida | 12067 | 2004 | 26 |
1670769 | 1670769 | 2021-08-31 | Lafayette | Florida | 12067 | 2004 | 26 |
1667522 | 1667522 | 2021-08-30 | Lafayette | Florida | 12067 | 2004 | 26 |
1664275 | 1664275 | 2021-08-29 | Lafayette | Florida | 12067 | 2004 | 26 |
1661027 | 1661027 | 2021-08-28 | Lafayette | Florida | 12067 | 2004 | 26 |
1657779 | 1657779 | 2021-08-27 | Lafayette | Florida | 12067 | 2004 | 26 |
1654156 | 1654156 | 2021-08-25 | Carbon | Wyoming | 56007 | 2004 | 31 |
1644586 | 1644586 | 2021-08-23 | Madison | Arkansas | 5087 | 2004 | 32 |
1621413 | 1621413 | 2021-08-15 | Fluvanna | Virginia | 51065 | 2004 | 21 |
1618165 | 1618165 | 2021-08-14 | Fluvanna | Virginia | 51065 | 2004 | 21 |
1614917 | 1614917 | 2021-08-13 | Fluvanna | Virginia | 51065 | 2004 | 21 |
1606078 | 1606078 | 2021-08-11 | Ford | Illinois | 17053 | 2004 | 58 |
1602967 | 1602967 | 2021-08-10 | Perry | Indiana | 18123 | 2004 | 41 |
1604580 | 1604580 | 2021-08-10 | Manati | Puerto Rico | 72091 | 2004 | |
1601331 | 1601331 | 2021-08-09 | Manati | Puerto Rico | 72091 | 2004 | |
1583012 | 1583012 | 2021-08-04 | Teller | Colorado | 8119 | 2004 | 18 |
1583342 | 1583342 | 2021-08-04 | Hancock | Illinois | 17067 | 2004 | 42 |
1553269 | 1553269 | 2021-07-25 | Southampton | Virginia | 51175 | 2004 | 57 |
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);