ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
162 rows where cases = 3066 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Indiana 13
- Arkansas 9
- Minnesota 9
- Mississippi 9
- Ohio 9
- Alabama 8
- Iowa 7
- Missouri 6
- Idaho 5
- Kansas 5
- Michigan 5
- Puerto Rico 5
- Texas 5
- Virginia 5
- California 4
- North Carolina 4
- West Virginia 4
- Louisiana 3
- South Dakota 3
- Tennessee 3
- Florida 2
- Illinois 2
- Kentucky 2
- Maryland 2
- New York 2
- Oklahoma 2
- Oregon 2
- Pennsylvania 2
- Washington 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475918 | 2475918 | 2022-05-05 | Santa Isabel | Puerto Rico | 72133 | 3066 | |
2450928 | 2450928 | 2022-04-28 | Mariposa | California | 6043 | 3066 | 34 |
2442172 | 2442172 | 2022-04-25 | Kent | Maryland | 24029 | 3066 | 66 |
2370105 | 2370105 | 2022-04-03 | Pulaski | Indiana | 18131 | 3066 | 86 |
2366852 | 2366852 | 2022-04-02 | Pulaski | Indiana | 18131 | 3066 | 86 |
2363599 | 2363599 | 2022-04-01 | Pulaski | Indiana | 18131 | 3066 | 86 |
2360099 | 2360099 | 2022-03-31 | Telfair | Georgia | 13271 | 3066 | 82 |
2360345 | 2360345 | 2022-03-31 | Pulaski | Indiana | 18131 | 3066 | 86 |
2356845 | 2356845 | 2022-03-30 | Telfair | Georgia | 13271 | 3066 | 82 |
2357091 | 2357091 | 2022-03-30 | Pulaski | Indiana | 18131 | 3066 | 86 |
2347087 | 2347087 | 2022-03-27 | Telfair | Georgia | 13271 | 3066 | 82 |
2343834 | 2343834 | 2022-03-26 | Telfair | Georgia | 13271 | 3066 | 82 |
2340581 | 2340581 | 2022-03-25 | Telfair | Georgia | 13271 | 3066 | 82 |
2337328 | 2337328 | 2022-03-24 | Telfair | Georgia | 13271 | 3066 | 82 |
2334074 | 2334074 | 2022-03-23 | Telfair | Georgia | 13271 | 3066 | 82 |
2330820 | 2330820 | 2022-03-22 | Telfair | Georgia | 13271 | 3066 | 81 |
2327568 | 2327568 | 2022-03-21 | Telfair | Georgia | 13271 | 3066 | 81 |
2328383 | 2328383 | 2022-03-21 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2325130 | 2325130 | 2022-03-20 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2321876 | 2321876 | 2022-03-19 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2318622 | 2318622 | 2022-03-18 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2315369 | 2315369 | 2022-03-17 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2312116 | 2312116 | 2022-03-16 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2307742 | 2307742 | 2022-03-15 | Plumas | California | 6063 | 3066 | 13 |
2304491 | 2304491 | 2022-03-14 | Plumas | California | 6063 | 3066 | 13 |
2209045 | 2209045 | 2022-02-12 | Potter | Pennsylvania | 42105 | 3066 | 89 |
2209068 | 2209068 | 2022-02-12 | Barceloneta | Puerto Rico | 72017 | 3066 | |
2196945 | 2196945 | 2022-02-08 | Converse | Wyoming | 56009 | 3066 | 50 |
2175770 | 2175770 | 2022-02-02 | Osage | Missouri | 29151 | 3066 | 39 |
2130406 | 2130406 | 2022-01-19 | York | Nebraska | 31185 | 3066 | 19 |
2122901 | 2122901 | 2022-01-17 | Parke | Indiana | 18121 | 3066 | 40 |
2123694 | 2123694 | 2022-01-17 | Livingston | Missouri | 29117 | 3066 | 83 |
2120442 | 2120442 | 2022-01-16 | Livingston | Missouri | 29117 | 3066 | 83 |
2117190 | 2117190 | 2022-01-15 | Livingston | Missouri | 29117 | 3066 | 83 |
2080748 | 2080748 | 2022-01-04 | Tama | Iowa | 19171 | 3066 | 80 |
2080765 | 2080765 | 2022-01-04 | Atchison | Kansas | 20005 | 3066 | 30 |
2077496 | 2077496 | 2022-01-03 | Tama | Iowa | 19171 | 3066 | 80 |
2077513 | 2077513 | 2022-01-03 | Atchison | Kansas | 20005 | 3066 | 30 |
2074245 | 2074245 | 2022-01-02 | Tama | Iowa | 19171 | 3066 | 80 |
2070994 | 2070994 | 2022-01-01 | Tama | Iowa | 19171 | 3066 | 80 |
2067743 | 2067743 | 2021-12-31 | Tama | Iowa | 19171 | 3066 | 80 |
2064492 | 2064492 | 2021-12-30 | Tama | Iowa | 19171 | 3066 | 80 |
2061242 | 2061242 | 2021-12-29 | Tama | Iowa | 19171 | 3066 | 80 |
2014579 | 2014579 | 2021-12-14 | Fluvanna | Virginia | 51065 | 3066 | 29 |
2011328 | 2011328 | 2021-12-13 | Fluvanna | Virginia | 51065 | 3066 | 29 |
2007873 | 2007873 | 2021-12-12 | Lamb | Texas | 48279 | 3066 | 97 |
2004622 | 2004622 | 2021-12-11 | Lamb | Texas | 48279 | 3066 | 97 |
1992232 | 1992232 | 2021-12-08 | Cross | Arkansas | 5037 | 3066 | 69 |
1992242 | 1992242 | 2021-12-08 | Hempstead | Arkansas | 5057 | 3066 | 44 |
1974441 | 1974441 | 2021-12-02 | San Miguel | New Mexico | 35047 | 3066 | 30 |
1930219 | 1930219 | 2021-11-18 | McDowell | West Virginia | 54047 | 3066 | 51 |
1918086 | 1918086 | 2021-11-15 | Jay | Indiana | 18075 | 3066 | 52 |
1915518 | 1915518 | 2021-11-14 | Chickasaw | Mississippi | 28017 | 3066 | 67 |
1912268 | 1912268 | 2021-11-13 | Chickasaw | Mississippi | 28017 | 3066 | 67 |
1909018 | 1909018 | 2021-11-12 | Chickasaw | Mississippi | 28017 | 3066 | 67 |
1883964 | 1883964 | 2021-11-04 | Humacao | Puerto Rico | 72069 | 3066 | |
1878912 | 1878912 | 2021-11-03 | Blaine | Idaho | 16013 | 3066 | 27 |
1862112 | 1862112 | 2021-10-29 | Cherokee | Alabama | 1019 | 3066 | 61 |
1847153 | 1847153 | 2021-10-24 | Mason | Michigan | 26105 | 3066 | 47 |
1843903 | 1843903 | 2021-10-23 | Mason | Michigan | 26105 | 3066 | 47 |
1840653 | 1840653 | 2021-10-22 | Mason | Michigan | 26105 | 3066 | 47 |
1832225 | 1832225 | 2021-10-19 | Union | Tennessee | 47173 | 3066 | 45 |
1809214 | 1809214 | 2021-10-12 | Canovanas | Puerto Rico | 72029 | 3066 | |
1805964 | 1805964 | 2021-10-11 | Canovanas | Puerto Rico | 72029 | 3066 | |
1758185 | 1758185 | 2021-09-27 | Randolph | Alabama | 1111 | 3066 | 56 |
1758242 | 1758242 | 2021-09-27 | Ashley | Arkansas | 5003 | 3066 | 42 |
1749607 | 1749607 | 2021-09-24 | Somerset | Maryland | 24039 | 3066 | 46 |
1742508 | 1742508 | 2021-09-22 | Douglas | Illinois | 17041 | 3066 | 42 |
1743022 | 1743022 | 2021-09-22 | Concordia | Louisiana | 22029 | 3066 | 74 |
1745010 | 1745010 | 2021-09-22 | Mason | West Virginia | 54053 | 3066 | 45 |
1738785 | 1738785 | 2021-09-21 | Lawrence | Arkansas | 5075 | 3066 | 50 |
1735552 | 1735552 | 2021-09-20 | Phillips | Arkansas | 5107 | 3066 | 65 |
1738572 | 1738572 | 2021-09-20 | Kewaunee | Wisconsin | 55061 | 3066 | 40 |
1711862 | 1711862 | 2021-09-12 | Beadle | South Dakota | 46005 | 3066 | 43 |
1708615 | 1708615 | 2021-09-11 | Beadle | South Dakota | 46005 | 3066 | 43 |
1705368 | 1705368 | 2021-09-10 | Beadle | South Dakota | 46005 | 3066 | 43 |
1678986 | 1678986 | 2021-09-02 | Coshocton | Ohio | 39031 | 3066 | 63 |
1679003 | 1679003 | 2021-09-02 | Hardin | Ohio | 39065 | 3066 | 66 |
1651970 | 1651970 | 2021-08-25 | Grant | Kentucky | 21081 | 3066 | 25 |
1653915 | 1653915 | 2021-08-25 | Hopewell city | Virginia | 51670 | 3066 | 79 |
1619169 | 1619169 | 2021-08-15 | Fayette | Indiana | 18041 | 3066 | 67 |
1615921 | 1615921 | 2021-08-14 | Fayette | Indiana | 18041 | 3066 | 67 |
1612672 | 1612672 | 2021-08-13 | Fayette | Indiana | 18041 | 3066 | 67 |
1614073 | 1614073 | 2021-08-13 | Perry | Ohio | 39127 | 3066 | 50 |
1606911 | 1606911 | 2021-08-11 | Marion | Mississippi | 28091 | 3066 | 83 |
1602933 | 1602933 | 2021-08-10 | Greene | Indiana | 18055 | 3066 | 89 |
1583185 | 1583185 | 2021-08-04 | Lee | Georgia | 13177 | 3066 | 59 |
1582264 | 1582264 | 2021-08-03 | Palo Pinto | Texas | 48363 | 3066 | 79 |
1541068 | 1541068 | 2021-07-22 | Jefferson | Idaho | 16051 | 3066 | 33 |
1542252 | 1542252 | 2021-07-22 | Douglas | Nevada | 32005 | 3066 | 37 |
1532171 | 1532171 | 2021-07-19 | Coahoma | Mississippi | 28027 | 3066 | 84 |
1514990 | 1514990 | 2021-07-14 | Lumpkin | Georgia | 13187 | 3066 | 82 |
1515949 | 1515949 | 2021-07-14 | Itawamba | Mississippi | 28057 | 3066 | 80 |
1515984 | 1515984 | 2021-07-14 | Simpson | Mississippi | 28127 | 3066 | 89 |
1417580 | 1417580 | 2021-06-14 | Gilmer | Georgia | 13123 | 3066 | 89 |
1340561 | 1340561 | 2021-05-21 | Brown | Minnesota | 27015 | 3066 | 40 |
1318053 | 1318053 | 2021-05-14 | Lafayette | Missouri | 29107 | 3066 | 57 |
1264963 | 1264963 | 2021-04-28 | Butts | Georgia | 13035 | 3066 | 82 |
1255399 | 1255399 | 2021-04-25 | Latah | Idaho | 16057 | 3066 | 10 |
1252152 | 1252152 | 2021-04-24 | Latah | Idaho | 16057 | 3066 | 10 |
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);