ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where cases = 4721 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- North Carolina 14
- Alabama 7
- Kentucky 7
- Tennessee 7
- Georgia 6
- Nevada 6
- Ohio 6
- Alaska 5
- Colorado 5
- Mississippi 5
- Illinois 3
- Louisiana 3
- Michigan 3
- Pennsylvania 3
- Arizona 2
- Arkansas 2
- Minnesota 2
- Montana 2
- South Carolina 2
- Virginia 2
- Indiana 1
- Missouri 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Dakota 1
- Oklahoma 1
- Puerto Rico 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2443672 | 2443672 | 2022-04-25 | Gonzales | Texas | 48177 | 4721 | 98 |
2440416 | 2440416 | 2022-04-24 | Gonzales | Texas | 48177 | 4721 | 98 |
2437160 | 2437160 | 2022-04-23 | Gonzales | Texas | 48177 | 4721 | 98 |
2433904 | 2433904 | 2022-04-22 | Gonzales | Texas | 48177 | 4721 | 98 |
2430648 | 2430648 | 2022-04-21 | Gonzales | Texas | 48177 | 4721 | 98 |
2427392 | 2427392 | 2022-04-20 | Gonzales | Texas | 48177 | 4721 | 98 |
2424136 | 2424136 | 2022-04-19 | Gonzales | Texas | 48177 | 4721 | 98 |
2420880 | 2420880 | 2022-04-18 | Gonzales | Texas | 48177 | 4721 | 98 |
2417624 | 2417624 | 2022-04-17 | Gonzales | Texas | 48177 | 4721 | 98 |
2414368 | 2414368 | 2022-04-16 | Gonzales | Texas | 48177 | 4721 | 98 |
2411112 | 2411112 | 2022-04-15 | Gonzales | Texas | 48177 | 4721 | 98 |
2407856 | 2407856 | 2022-04-14 | Gonzales | Texas | 48177 | 4721 | 98 |
2404600 | 2404600 | 2022-04-13 | Gonzales | Texas | 48177 | 4721 | 98 |
2401345 | 2401345 | 2022-04-12 | Gonzales | Texas | 48177 | 4721 | 98 |
2398090 | 2398090 | 2022-04-11 | Gonzales | Texas | 48177 | 4721 | 98 |
2387993 | 2387993 | 2022-04-08 | Morovis | Puerto Rico | 72101 | 4721 | |
2377482 | 2377482 | 2022-04-05 | Lincoln | Montana | 30053 | 4721 | 86 |
2374229 | 2374229 | 2022-04-04 | Lincoln | Montana | 30053 | 4721 | 86 |
2246793 | 2246793 | 2022-02-24 | Henry | Kentucky | 21103 | 4721 | 45 |
2243542 | 2243542 | 2022-02-23 | Henry | Kentucky | 21103 | 4721 | 45 |
2239317 | 2239317 | 2022-02-22 | Kodiak Island Borough | Alaska | 2150 | 4721 | 11 |
2240291 | 2240291 | 2022-02-22 | Henry | Kentucky | 21103 | 4721 | 45 |
2236066 | 2236066 | 2022-02-21 | Kodiak Island Borough | Alaska | 2150 | 4721 | 11 |
2232815 | 2232815 | 2022-02-20 | Kodiak Island Borough | Alaska | 2150 | 4721 | 11 |
2229564 | 2229564 | 2022-02-19 | Kodiak Island Borough | Alaska | 2150 | 4721 | 11 |
2226313 | 2226313 | 2022-02-18 | Kodiak Island Borough | Alaska | 2150 | 4721 | 11 |
2191876 | 2191876 | 2022-02-07 | Attala | Mississippi | 28007 | 4721 | 98 |
2183804 | 2183804 | 2022-02-04 | Brooke | West Virginia | 54009 | 4721 | 97 |
2165570 | 2165570 | 2022-01-30 | Concordia | Louisiana | 22029 | 4721 | 84 |
2162315 | 2162315 | 2022-01-29 | Concordia | Louisiana | 22029 | 4721 | 84 |
2157972 | 2157972 | 2022-01-28 | Monroe | Alabama | 1099 | 4721 | 67 |
2159060 | 2159060 | 2022-01-28 | Concordia | Louisiana | 22029 | 4721 | 84 |
2154719 | 2154719 | 2022-01-27 | Monroe | Alabama | 1099 | 4721 | 67 |
2151466 | 2151466 | 2022-01-26 | Monroe | Alabama | 1099 | 4721 | 67 |
2148214 | 2148214 | 2022-01-25 | Monroe | Alabama | 1099 | 4721 | 67 |
2144962 | 2144962 | 2022-01-24 | Monroe | Alabama | 1099 | 4721 | 67 |
2056520 | 2056520 | 2021-12-27 | Cass | Texas | 48067 | 4721 | 162 |
2003919 | 2003919 | 2021-12-11 | Adams | Ohio | 39001 | 4721 | 111 |
1993706 | 1993706 | 2021-12-08 | Stoddard | Missouri | 29207 | 4721 | 107 |
1990820 | 1990820 | 2021-12-07 | Montgomery | North Carolina | 37123 | 4721 | 110 |
1987569 | 1987569 | 2021-12-06 | Montgomery | North Carolina | 37123 | 4721 | 110 |
1983437 | 1983437 | 2021-12-05 | Mercer | Kentucky | 21167 | 4721 | 85 |
1980187 | 1980187 | 2021-12-04 | Mercer | Kentucky | 21167 | 4721 | 85 |
1976937 | 1976937 | 2021-12-03 | Mercer | Kentucky | 21167 | 4721 | 85 |
1944802 | 1944802 | 2021-11-23 | Leflore | Mississippi | 28083 | 4721 | 144 |
1928577 | 1928577 | 2021-11-18 | Tate | Mississippi | 28137 | 4721 | 113 |
1923182 | 1923182 | 2021-11-16 | McNairy | Tennessee | 47109 | 4721 | 71 |
1917383 | 1917383 | 2021-11-15 | Lawrence | Alabama | 1079 | 4721 | 126 |
1917530 | 1917530 | 2021-11-15 | Yell | Arkansas | 5149 | 4721 | 80 |
1906122 | 1906122 | 2021-11-11 | Nye | Nevada | 32023 | 4721 | 162 |
1902873 | 1902873 | 2021-11-10 | Nye | Nevada | 32023 | 4721 | 162 |
1878799 | 1878799 | 2021-11-03 | Gilmer | Georgia | 13123 | 4721 | 136 |
1880468 | 1880468 | 2021-11-03 | Morrow | Ohio | 39117 | 4721 | 59 |
1875550 | 1875550 | 2021-11-02 | Gilmer | Georgia | 13123 | 4721 | 136 |
1834336 | 1834336 | 2021-10-20 | Scott | Mississippi | 28123 | 4721 | 98 |
1834695 | 1834695 | 2021-10-20 | Rio Arriba | New Mexico | 35039 | 4721 | 83 |
1829914 | 1829914 | 2021-10-19 | Summit | Colorado | 8117 | 4721 | 11 |
1826415 | 1826415 | 2021-10-18 | Pike | Alabama | 1109 | 4721 | 105 |
1786085 | 1786085 | 2021-10-05 | Macon | North Carolina | 37113 | 4721 | 54 |
1777913 | 1777913 | 2021-10-03 | Montrose | Colorado | 8085 | 4721 | 77 |
1778170 | 1778170 | 2021-10-03 | White | Georgia | 13311 | 4721 | 116 |
1774663 | 1774663 | 2021-10-02 | Montrose | Colorado | 8085 | 4721 | 77 |
1774920 | 1774920 | 2021-10-02 | White | Georgia | 13311 | 4721 | 116 |
1771413 | 1771413 | 2021-10-01 | Montrose | Colorado | 8085 | 4721 | 77 |
1771670 | 1771670 | 2021-10-01 | White | Georgia | 13311 | 4721 | 116 |
1758799 | 1758799 | 2021-09-27 | Montgomery | Illinois | 17135 | 4721 | 82 |
1691683 | 1691683 | 2021-09-06 | Lyon | Nevada | 32019 | 4721 | 77 |
1688433 | 1688433 | 2021-09-05 | Lyon | Nevada | 32019 | 4721 | 77 |
1685183 | 1685183 | 2021-09-04 | Lyon | Nevada | 32019 | 4721 | 77 |
1681932 | 1681932 | 2021-09-03 | Lyon | Nevada | 32019 | 4721 | 77 |
1678266 | 1678266 | 2021-09-02 | Isanti | Minnesota | 27059 | 4721 | 69 |
1653037 | 1653037 | 2021-08-25 | Madison | Ohio | 39097 | 4721 | 65 |
1643171 | 1643171 | 2021-08-22 | Stokes | North Carolina | 37169 | 4721 | 83 |
1639921 | 1639921 | 2021-08-21 | Stokes | North Carolina | 37169 | 4721 | 83 |
1636671 | 1636671 | 2021-08-20 | Stokes | North Carolina | 37169 | 4721 | 83 |
1628865 | 1628865 | 2021-08-18 | Randolph | Illinois | 17157 | 4721 | 96 |
1611132 | 1611132 | 2021-08-12 | Dillon | South Carolina | 45033 | 4721 | 85 |
1580187 | 1580187 | 2021-08-03 | Gibson | Indiana | 18051 | 4721 | 100 |
1559707 | 1559707 | 2021-07-27 | Henry | Virginia | 51089 | 4721 | 124 |
1552766 | 1552766 | 2021-07-25 | Cheatham | Tennessee | 47021 | 4721 | 56 |
1549519 | 1549519 | 2021-07-24 | Cheatham | Tennessee | 47021 | 4721 | 56 |
1546272 | 1546272 | 2021-07-23 | Cheatham | Tennessee | 47021 | 4721 | 56 |
1526987 | 1526987 | 2021-07-17 | Howard | Texas | 48227 | 4721 | 102 |
1466867 | 1466867 | 2021-06-29 | Hopkins | Kentucky | 21107 | 4721 | 149 |
1399566 | 1399566 | 2021-06-08 | Beaufort | North Carolina | 37013 | 4721 | 97 |
1373672 | 1373672 | 2021-05-31 | Richmond | North Carolina | 37153 | 4721 | 97 |
1370427 | 1370427 | 2021-05-30 | Richmond | North Carolina | 37153 | 4721 | 97 |
1367181 | 1367181 | 2021-05-29 | Richmond | North Carolina | 37153 | 4721 | 97 |
1363935 | 1363935 | 2021-05-28 | Richmond | North Carolina | 37153 | 4721 | 97 |
1343823 | 1343823 | 2021-05-22 | Douglas | Minnesota | 27041 | 4721 | 78 |
1300893 | 1300893 | 2021-05-09 | Effingham | Illinois | 17049 | 4721 | 83 |
1273098 | 1273098 | 2021-04-30 | Stark | North Dakota | 38089 | 4721 | 51 |
1205305 | 1205305 | 2021-04-09 | Newberry | South Carolina | 45071 | 4721 | 99 |
1148182 | 1148182 | 2021-03-23 | Ware | Georgia | 13299 | 4721 | 157 |
1135911 | 1135911 | 2021-03-19 | Branch | Michigan | 26023 | 4721 | 111 |
1126980 | 1126980 | 2021-03-16 | Athens | Ohio | 39009 | 4721 | 50 |
1110965 | 1110965 | 2021-03-11 | Columbia | Pennsylvania | 42037 | 4721 | 125 |
1072284 | 1072284 | 2021-02-27 | Franklin | Tennessee | 47051 | 4721 | 85 |
1024557 | 1024557 | 2021-02-13 | Eagle | Colorado | 8037 | 4721 | 20 |
1013577 | 1013577 | 2021-02-09 | Armstrong | Pennsylvania | 42005 | 4721 | 114 |
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);