ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 5926 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Arkansas 21
- Florida 10
- Indiana 8
- Minnesota 8
- Tennessee 8
- Illinois 7
- Missouri 7
- Oklahoma 7
- Texas 7
- Kansas 5
- Wisconsin 5
- North Carolina 4
- California 3
- Georgia 3
- New York 3
- New Jersey 2
- Puerto Rico 2
- Virginia 2
- Alabama 1
- Alaska 1
- Kentucky 1
- Michigan 1
- Montana 1
- Nebraska 1
- New Mexico 1
- Ohio 1
- Pennsylvania 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501418 | 2501418 | 2022-05-13 | San Miguel | New Mexico | 35047 | 5926 | 63 |
2455843 | 2455843 | 2022-04-29 | Essex | New York | 36031 | 5926 | 59 |
2402057 | 2402057 | 2022-04-13 | Sevier | Arkansas | 5133 | 5926 | 75 |
2398802 | 2398802 | 2022-04-12 | Sevier | Arkansas | 5133 | 5926 | 75 |
2395547 | 2395547 | 2022-04-11 | Sevier | Arkansas | 5133 | 5926 | 75 |
2396746 | 2396746 | 2022-04-11 | Meeker | Minnesota | 27093 | 5926 | 75 |
2392291 | 2392291 | 2022-04-10 | Sevier | Arkansas | 5133 | 5926 | 75 |
2389035 | 2389035 | 2022-04-09 | Sevier | Arkansas | 5133 | 5926 | 75 |
2385780 | 2385780 | 2022-04-08 | Sevier | Arkansas | 5133 | 5926 | 75 |
2382525 | 2382525 | 2022-04-07 | Sevier | Arkansas | 5133 | 5926 | 75 |
2379270 | 2379270 | 2022-04-06 | Sevier | Arkansas | 5133 | 5926 | 74 |
2376016 | 2376016 | 2022-04-05 | Sevier | Arkansas | 5133 | 5926 | 74 |
2372764 | 2372764 | 2022-04-04 | Sevier | Arkansas | 5133 | 5926 | 74 |
2369511 | 2369511 | 2022-04-03 | Sevier | Arkansas | 5133 | 5926 | 74 |
2366258 | 2366258 | 2022-04-02 | Sevier | Arkansas | 5133 | 5926 | 74 |
2363005 | 2363005 | 2022-04-01 | Sevier | Arkansas | 5133 | 5926 | 74 |
2359751 | 2359751 | 2022-03-31 | Sevier | Arkansas | 5133 | 5926 | 74 |
2356497 | 2356497 | 2022-03-30 | Sevier | Arkansas | 5133 | 5926 | 74 |
2353244 | 2353244 | 2022-03-29 | Sevier | Arkansas | 5133 | 5926 | 74 |
2349992 | 2349992 | 2022-03-28 | Sevier | Arkansas | 5133 | 5926 | 74 |
2346739 | 2346739 | 2022-03-27 | Sevier | Arkansas | 5133 | 5926 | 74 |
2343486 | 2343486 | 2022-03-26 | Sevier | Arkansas | 5133 | 5926 | 74 |
2292876 | 2292876 | 2022-03-10 | Washington | Missouri | 29221 | 5926 | 133 |
2281476 | 2281476 | 2022-03-06 | Vernon | Wisconsin | 55123 | 5926 | 90 |
2278223 | 2278223 | 2022-03-05 | Vernon | Wisconsin | 55123 | 5926 | 90 |
2274970 | 2274970 | 2022-03-04 | Vernon | Wisconsin | 55123 | 5926 | 90 |
2231858 | 2231858 | 2022-02-19 | Juncos | Puerto Rico | 72077 | 5926 | |
2165077 | 2165077 | 2022-01-30 | Jersey | Illinois | 17083 | 5926 | 78 |
2161822 | 2161822 | 2022-01-29 | Jersey | Illinois | 17083 | 5926 | 78 |
2158567 | 2158567 | 2022-01-28 | Jersey | Illinois | 17083 | 5926 | 78 |
2127080 | 2127080 | 2022-01-18 | Dakota | Nebraska | 31043 | 5926 | 82 |
2124098 | 2124098 | 2022-01-17 | Macon | North Carolina | 37113 | 5926 | 88 |
2120846 | 2120846 | 2022-01-16 | Macon | North Carolina | 37113 | 5926 | 88 |
2117594 | 2117594 | 2022-01-15 | Macon | North Carolina | 37113 | 5926 | 88 |
2114343 | 2114343 | 2022-01-14 | Macon | North Carolina | 37113 | 5926 | 88 |
2103402 | 2103402 | 2022-01-11 | Scott | Indiana | 18143 | 5926 | 88 |
2097500 | 2097500 | 2022-01-09 | Mille Lacs | Minnesota | 27095 | 5926 | 97 |
2094248 | 2094248 | 2022-01-08 | Mille Lacs | Minnesota | 27095 | 5926 | 97 |
2090996 | 2090996 | 2022-01-07 | Mille Lacs | Minnesota | 27095 | 5926 | 97 |
2080473 | 2080473 | 2022-01-04 | Bureau | Illinois | 17011 | 5926 | 122 |
2078167 | 2078167 | 2022-01-03 | Lafayette | Missouri | 29107 | 5926 | 91 |
2078197 | 2078197 | 2022-01-03 | Polk | Missouri | 29167 | 5926 | 82 |
2054532 | 2054532 | 2021-12-27 | Morgan | Illinois | 17137 | 5926 | 125 |
2041052 | 2041052 | 2021-12-23 | Amador | California | 6005 | 5926 | 70 |
2030468 | 2030468 | 2021-12-19 | Scott | Tennessee | 47151 | 5926 | 70 |
2027217 | 2027217 | 2021-12-18 | Scott | Tennessee | 47151 | 5926 | 70 |
2023966 | 2023966 | 2021-12-17 | Scott | Tennessee | 47151 | 5926 | 70 |
2016983 | 2016983 | 2021-12-15 | Ottawa | Ohio | 39123 | 5926 | 104 |
2005604 | 2005604 | 2021-12-12 | Oconee | Georgia | 13219 | 5926 | 82 |
2002353 | 2002353 | 2021-12-11 | Oconee | Georgia | 13219 | 5926 | 82 |
1999103 | 1999103 | 2021-12-10 | Oconee | Georgia | 13219 | 5926 | 82 |
1991391 | 1991391 | 2021-12-07 | Carroll | Tennessee | 47017 | 5926 | 113 |
1960341 | 1960341 | 2021-11-28 | Jasper | Indiana | 18073 | 5926 | 96 |
1957090 | 1957090 | 2021-11-27 | Jasper | Indiana | 18073 | 5926 | 96 |
1953839 | 1953839 | 2021-11-26 | Jasper | Indiana | 18073 | 5926 | 96 |
1950588 | 1950588 | 2021-11-25 | Jasper | Indiana | 18073 | 5926 | 96 |
1947337 | 1947337 | 2021-11-24 | Jasper | Indiana | 18073 | 5926 | 96 |
1931956 | 1931956 | 2021-11-19 | Webster | Missouri | 29225 | 5926 | 114 |
1921508 | 1921508 | 2021-11-16 | Cowley | Kansas | 20035 | 5926 | 127 |
1918258 | 1918258 | 2021-11-15 | Cowley | Kansas | 20035 | 5926 | 127 |
1861665 | 1861665 | 2021-10-28 | Polk | Texas | 48373 | 5926 | 200 |
1858416 | 1858416 | 2021-10-27 | Polk | Texas | 48373 | 5926 | 200 |
1835829 | 1835829 | 2021-10-20 | Franklin | Virginia | 51067 | 5926 | 98 |
1813395 | 1813395 | 2021-10-14 | Franklin | Alabama | 1059 | 5926 | 105 |
1790946 | 1790946 | 2021-10-07 | Baker | Florida | 12003 | 5926 | 112 |
1787697 | 1787697 | 2021-10-06 | Baker | Florida | 12003 | 5926 | 112 |
1784448 | 1784448 | 2021-10-05 | Baker | Florida | 12003 | 5926 | 112 |
1781199 | 1781199 | 2021-10-04 | Baker | Florida | 12003 | 5926 | 112 |
1777949 | 1777949 | 2021-10-03 | Baker | Florida | 12003 | 5926 | 112 |
1774699 | 1774699 | 2021-10-02 | Baker | Florida | 12003 | 5926 | 104 |
1771449 | 1771449 | 2021-10-01 | Baker | Florida | 12003 | 5926 | 104 |
1761520 | 1761520 | 2021-09-28 | Independence | Arkansas | 5063 | 5926 | 152 |
1740535 | 1740535 | 2021-09-21 | Tompkins | New York | 36109 | 5926 | 59 |
1722592 | 1722592 | 2021-09-16 | Lake | California | 6033 | 5926 | 85 |
1720652 | 1720652 | 2021-09-15 | Camden | Missouri | 29029 | 5926 | 115 |
1716954 | 1716954 | 2021-09-14 | Knox | Kentucky | 21121 | 5926 | 49 |
1718110 | 1718110 | 2021-09-14 | Sequoyah | Oklahoma | 40135 | 5926 | 69 |
1714862 | 1714862 | 2021-09-13 | Sequoyah | Oklahoma | 40135 | 5926 | 69 |
1711616 | 1711616 | 2021-09-12 | Sequoyah | Oklahoma | 40135 | 5926 | 69 |
1708369 | 1708369 | 2021-09-11 | Sequoyah | Oklahoma | 40135 | 5926 | 69 |
1705122 | 1705122 | 2021-09-10 | Sequoyah | Oklahoma | 40135 | 5926 | 69 |
1701872 | 1701872 | 2021-09-09 | Sequoyah | Oklahoma | 40135 | 5926 | 69 |
1698623 | 1698623 | 2021-09-08 | Sequoyah | Oklahoma | 40135 | 5926 | 69 |
1674321 | 1674321 | 2021-09-01 | Marion | Illinois | 17121 | 5926 | 137 |
1634608 | 1634608 | 2021-08-19 | Grant | Wisconsin | 55043 | 5926 | 96 |
1625017 | 1625017 | 2021-08-17 | Kenai Peninsula Borough | Alaska | 2122 | 5926 | 20 |
1574343 | 1574343 | 2021-08-01 | Otter Tail | Minnesota | 27111 | 5926 | 87 |
1571095 | 1571095 | 2021-07-31 | Otter Tail | Minnesota | 27111 | 5926 | 87 |
1567847 | 1567847 | 2021-07-30 | Otter Tail | Minnesota | 27111 | 5926 | 87 |
1562252 | 1562252 | 2021-07-28 | Columbia | Pennsylvania | 42037 | 5926 | 136 |
1465729 | 1465729 | 2021-06-28 | Columbia | Wisconsin | 55021 | 5926 | 71 |
1380771 | 1380771 | 2021-06-02 | Monroe | Tennessee | 47123 | 5926 | 97 |
1376188 | 1376188 | 2021-06-01 | Barry | Michigan | 26015 | 5926 | 67 |
1377526 | 1377526 | 2021-06-01 | Monroe | Tennessee | 47123 | 5926 | 97 |
1330262 | 1330262 | 2021-05-18 | Shelby | Indiana | 18145 | 5926 | 106 |
1328969 | 1328969 | 2021-05-17 | Henderson | Texas | 48213 | 5926 | 189 |
1325723 | 1325723 | 2021-05-16 | Henderson | Texas | 48213 | 5926 | 189 |
1322477 | 1322477 | 2021-05-15 | Henderson | Texas | 48213 | 5926 | 189 |
1318056 | 1318056 | 2021-05-14 | Lincoln | Missouri | 29113 | 5926 | 42 |
1319231 | 1319231 | 2021-05-14 | Henderson | Texas | 48213 | 5926 | 189 |
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);