ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 3059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 12
- Tennessee 10
- Arkansas 8
- Mississippi 8
- Iowa 7
- Missouri 7
- Virginia 7
- Illinois 6
- Texas 6
- Florida 5
- North Carolina 5
- Kentucky 4
- Minnesota 4
- Ohio 4
- Pennsylvania 4
- Puerto Rico 4
- Alabama 3
- Louisiana 3
- West Virginia 3
- California 2
- Colorado 2
- Indiana 2
- Michigan 2
- New Mexico 2
- North Dakota 2
- South Carolina 2
- Delaware 1
- Maine 1
- Maryland 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474711 | 2474711 | 2022-05-05 | Piscataquis | Maine | 23021 | 3059 | 31 |
2471645 | 2471645 | 2022-05-04 | Pope | Minnesota | 27121 | 3059 | 17 |
2449857 | 2449857 | 2022-04-27 | Orocovis | Puerto Rico | 72107 | 3059 | |
2429148 | 2429148 | 2022-04-21 | Kent | Maryland | 24029 | 3059 | 66 |
2399040 | 2399040 | 2022-04-12 | Charlton | Georgia | 13049 | 3059 | 62 |
2381901 | 2381901 | 2022-04-06 | Nolan | Texas | 48353 | 3059 | 99 |
2337218 | 2337218 | 2022-03-24 | Charlton | Georgia | 13049 | 3059 | 62 |
2285286 | 2285286 | 2022-03-08 | Telfair | Georgia | 13271 | 3059 | 80 |
2241083 | 2241083 | 2022-02-22 | Torrance | New Mexico | 35057 | 3059 | 50 |
2217338 | 2217338 | 2022-02-15 | Madison | Iowa | 19121 | 3059 | 32 |
2214087 | 2214087 | 2022-02-14 | Madison | Iowa | 19121 | 3059 | 32 |
2210835 | 2210835 | 2022-02-13 | Madison | Iowa | 19121 | 3059 | 32 |
2207582 | 2207582 | 2022-02-12 | Madison | Iowa | 19121 | 3059 | 32 |
2204329 | 2204329 | 2022-02-11 | Madison | Iowa | 19121 | 3059 | 32 |
2201076 | 2201076 | 2022-02-10 | Madison | Iowa | 19121 | 3059 | 32 |
2197822 | 2197822 | 2022-02-09 | Madison | Iowa | 19121 | 3059 | 32 |
2160049 | 2160049 | 2022-01-28 | Noble | Ohio | 39121 | 3059 | 53 |
2126504 | 2126504 | 2022-01-18 | Washington | Kentucky | 21229 | 3059 | 53 |
2080475 | 2080475 | 2022-01-04 | Carroll | Illinois | 17015 | 3059 | 42 |
2079352 | 2079352 | 2022-01-03 | Houston | Texas | 48225 | 3059 | 90 |
2079781 | 2079781 | 2022-01-03 | Crawford | Wisconsin | 55023 | 3059 | 25 |
2061787 | 2061787 | 2021-12-29 | Clarke | Mississippi | 28023 | 3059 | 96 |
2020987 | 2020987 | 2021-12-16 | Young | Texas | 48503 | 3059 | 74 |
2011384 | 2011384 | 2021-12-13 | Prince Edward | Virginia | 51147 | 3059 | 53 |
2005595 | 2005595 | 2021-12-12 | Meriwether | Georgia | 13199 | 3059 | 120 |
2002344 | 2002344 | 2021-12-11 | Meriwether | Georgia | 13199 | 3059 | 120 |
1999094 | 1999094 | 2021-12-10 | Meriwether | Georgia | 13199 | 3059 | 120 |
1985731 | 1985731 | 2021-12-06 | Cross | Arkansas | 5037 | 3059 | 69 |
1985741 | 1985741 | 2021-12-06 | Hempstead | Arkansas | 5057 | 3059 | 44 |
1977967 | 1977967 | 2021-12-03 | Meigs | Ohio | 39105 | 3059 | 61 |
1966083 | 1966083 | 2021-11-29 | Carbon | Wyoming | 56007 | 3059 | 43 |
1887181 | 1887181 | 2021-11-05 | Aguadilla | Puerto Rico | 72005 | 3059 | |
1848221 | 1848221 | 2021-10-24 | Gurabo | Puerto Rico | 72063 | 3059 | |
1845517 | 1845517 | 2021-10-23 | Bennington | Vermont | 50003 | 3059 | 26 |
1836395 | 1836395 | 2021-10-21 | Montezuma | Colorado | 8083 | 3059 | 36 |
1826911 | 1826911 | 2021-10-18 | Worth | Georgia | 13321 | 3059 | 87 |
1821441 | 1821441 | 2021-10-16 | Perry | Missouri | 29157 | 3059 | 33 |
1793235 | 1793235 | 2021-10-07 | Unicoi | Tennessee | 47171 | 3059 | 61 |
1762873 | 1762873 | 2021-09-28 | Winston | Mississippi | 28159 | 3059 | 91 |
1754937 | 1754937 | 2021-09-26 | Randolph | Alabama | 1111 | 3059 | 56 |
1757887 | 1757887 | 2021-09-26 | Mecklenburg | Virginia | 51117 | 3059 | 74 |
1751759 | 1751759 | 2021-09-25 | Conway | Arkansas | 5029 | 3059 | 42 |
1754639 | 1754639 | 2021-09-25 | Mecklenburg | Virginia | 51117 | 3059 | 74 |
1751391 | 1751391 | 2021-09-24 | Mecklenburg | Virginia | 51117 | 3059 | 74 |
1729052 | 1729052 | 2021-09-18 | Phillips | Arkansas | 5107 | 3059 | 65 |
1731210 | 1731210 | 2021-09-18 | Susquehanna | Pennsylvania | 42115 | 3059 | 62 |
1723440 | 1723440 | 2021-09-16 | Hart | Kentucky | 21099 | 3059 | 58 |
1670279 | 1670279 | 2021-08-30 | Hancock | West Virginia | 54029 | 3059 | 91 |
1656596 | 1656596 | 2021-08-26 | Barnwell | South Carolina | 45011 | 3059 | 62 |
1640289 | 1640289 | 2021-08-21 | Dorado | Puerto Rico | 72051 | 3059 | |
1636206 | 1636206 | 2021-08-20 | Crawford | Missouri | 29055 | 3059 | 42 |
1634414 | 1634414 | 2021-08-19 | Halifax | Virginia | 51083 | 3059 | 80 |
1626063 | 1626063 | 2021-08-17 | Assumption | Louisiana | 22007 | 3059 | 41 |
1602922 | 1602922 | 2021-08-10 | Decatur | Indiana | 18031 | 3059 | 97 |
1587431 | 1587431 | 2021-08-05 | Prentiss | Mississippi | 28117 | 3059 | 63 |
1582078 | 1582078 | 2021-08-03 | Wayne | Tennessee | 47181 | 3059 | 36 |
1534425 | 1534425 | 2021-07-20 | Decatur | Georgia | 13087 | 3059 | 73 |
1517935 | 1517935 | 2021-07-15 | Unknown | Arkansas | 3059 | 0 | |
1518014 | 1518014 | 2021-07-15 | Delta | Colorado | 8029 | 3059 | 70 |
1495512 | 1495512 | 2021-07-08 | Lumpkin | Georgia | 13187 | 3059 | 79 |
1470558 | 1470558 | 2021-06-30 | Barry | Missouri | 29009 | 3059 | 47 |
1433893 | 1433893 | 2021-06-19 | Unknown | Georgia | 3059 | 4 | |
1430647 | 1430647 | 2021-06-18 | Unknown | Georgia | 3059 | 4 | |
1419721 | 1419721 | 2021-06-14 | Overton | Tennessee | 47133 | 3059 | 61 |
1416476 | 1416476 | 2021-06-13 | Overton | Tennessee | 47133 | 3059 | 61 |
1413230 | 1413230 | 2021-06-12 | Overton | Tennessee | 47133 | 3059 | 61 |
1409985 | 1409985 | 2021-06-11 | Overton | Tennessee | 47133 | 3059 | 61 |
1405236 | 1405236 | 2021-06-10 | Muhlenberg | Kentucky | 21177 | 3059 | 67 |
1380504 | 1380504 | 2021-06-02 | Tioga | Pennsylvania | 42117 | 3059 | 108 |
1352855 | 1352855 | 2021-05-25 | Iroquois | Illinois | 17075 | 3059 | 68 |
1346110 | 1346110 | 2021-05-23 | Unknown | Florida | 3059 | 0 | |
1342515 | 1342515 | 2021-05-22 | Lawrence | Alabama | 1079 | 3059 | 99 |
1285146 | 1285146 | 2021-05-04 | Taylor | Kentucky | 21217 | 3059 | 47 |
1259477 | 1259477 | 2021-04-26 | Alcorn | Mississippi | 28003 | 3059 | 67 |
1254302 | 1254302 | 2021-04-24 | Hopkins | Texas | 48223 | 3059 | 109 |
1251055 | 1251055 | 2021-04-23 | Hopkins | Texas | 48223 | 3059 | 109 |
1247808 | 1247808 | 2021-04-22 | Hopkins | Texas | 48223 | 3059 | 109 |
1240187 | 1240187 | 2021-04-20 | Warren | Missouri | 29219 | 3059 | 31 |
1219148 | 1219148 | 2021-04-14 | Pike | Alabama | 1109 | 3059 | 76 |
1201214 | 1201214 | 2021-04-08 | Warren | Missouri | 29219 | 3059 | 30 |
1181434 | 1181434 | 2021-04-02 | Sanilac | Michigan | 26151 | 3059 | 86 |
1160745 | 1160745 | 2021-03-27 | Baxter | Arkansas | 5005 | 3059 | 99 |
1154654 | 1154654 | 2021-03-25 | Stephens | Georgia | 13257 | 3059 | 76 |
1156615 | 1156615 | 2021-03-25 | Davison | South Dakota | 46035 | 3059 | 67 |
1150210 | 1150210 | 2021-03-23 | Henry | Tennessee | 47079 | 3059 | 75 |
1146963 | 1146963 | 2021-03-22 | Henry | Tennessee | 47079 | 3059 | 76 |
1127062 | 1127062 | 2021-03-16 | Williams | Ohio | 39171 | 3059 | 69 |
1113401 | 1113401 | 2021-03-12 | Pike | Mississippi | 28113 | 3059 | 100 |
1098821 | 1098821 | 2021-03-07 | Marshall | West Virginia | 54051 | 3059 | 66 |
1089017 | 1089017 | 2021-03-04 | York | Virginia | 51199 | 3059 | 38 |
1074952 | 1074952 | 2021-02-28 | Pasquotank | North Carolina | 37139 | 3059 | 77 |
1071706 | 1071706 | 2021-02-27 | Pasquotank | North Carolina | 37139 | 3059 | 77 |
1060163 | 1060163 | 2021-02-24 | Poinsett | Arkansas | 5111 | 3059 | 75 |
1054131 | 1054131 | 2021-02-22 | Fayette | Illinois | 17051 | 3059 | 55 |
1050884 | 1050884 | 2021-02-21 | Fayette | Illinois | 17051 | 3059 | 55 |
1048841 | 1048841 | 2021-02-20 | Luna | New Mexico | 35029 | 3059 | 73 |
1045638 | 1045638 | 2021-02-19 | Montgomery | New York | 36057 | 3059 | 102 |
1003056 | 1003056 | 2021-02-06 | Sunflower | Mississippi | 28133 | 3059 | 81 |
963233 | 963233 | 2021-01-25 | Bureau | Illinois | 17011 | 3059 | 85 |
964209 | 964209 | 2021-01-25 | Polk | Missouri | 29167 | 3059 | 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);