ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
176 rows where cases = 2769 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 16
- Michigan 16
- Texas 16
- Ohio 10
- Georgia 9
- Virginia 9
- Missouri 8
- Illinois 7
- Indiana 7
- Colorado 6
- Louisiana 6
- Minnesota 6
- West Virginia 6
- Arkansas 5
- California 4
- Alabama 3
- Iowa 3
- New York 3
- North Carolina 3
- Pennsylvania 3
- Puerto Rico 3
- Kansas 2
- Kentucky 2
- Nevada 2
- South Carolina 2
- South Dakota 2
- Tennessee 2
- Wisconsin 2
- Wyoming 2
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422076 | 2422076 | 2022-04-19 | Marshall | Illinois | 17123 | 2769 | 33 |
2418820 | 2418820 | 2022-04-18 | Marshall | Illinois | 17123 | 2769 | 33 |
2354827 | 2354827 | 2022-03-29 | Unknown | Nebraska | 2769 | 502 | |
2337159 | 2337159 | 2022-03-24 | Lafayette | Florida | 12067 | 2769 | 58 |
2333905 | 2333905 | 2022-03-23 | Lafayette | Florida | 12067 | 2769 | 57 |
2330415 | 2330415 | 2022-03-22 | Chicot | Arkansas | 5017 | 2769 | 57 |
2330651 | 2330651 | 2022-03-22 | Lafayette | Florida | 12067 | 2769 | 57 |
2327399 | 2327399 | 2022-03-21 | Lafayette | Florida | 12067 | 2769 | 57 |
2327525 | 2327525 | 2022-03-21 | Long | Georgia | 13183 | 2769 | 34 |
2324146 | 2324146 | 2022-03-20 | Lafayette | Florida | 12067 | 2769 | 57 |
2320892 | 2320892 | 2022-03-19 | Lafayette | Florida | 12067 | 2769 | 57 |
2317638 | 2317638 | 2022-03-18 | Lafayette | Florida | 12067 | 2769 | 57 |
2314385 | 2314385 | 2022-03-17 | Lafayette | Florida | 12067 | 2769 | 57 |
2311132 | 2311132 | 2022-03-16 | Lafayette | Florida | 12067 | 2769 | 57 |
2307879 | 2307879 | 2022-03-15 | Lafayette | Florida | 12067 | 2769 | 56 |
2304628 | 2304628 | 2022-03-14 | Lafayette | Florida | 12067 | 2769 | 56 |
2301376 | 2301376 | 2022-03-13 | Lafayette | Florida | 12067 | 2769 | 56 |
2298124 | 2298124 | 2022-03-12 | Lafayette | Florida | 12067 | 2769 | 56 |
2294872 | 2294872 | 2022-03-11 | Lafayette | Florida | 12067 | 2769 | 56 |
2290441 | 2290441 | 2022-03-09 | Calhoun | South Carolina | 45017 | 2769 | 60 |
2287907 | 2287907 | 2022-03-08 | Summers | West Virginia | 54089 | 2769 | 49 |
2280914 | 2280914 | 2022-03-06 | Callahan | Texas | 48059 | 2769 | 72 |
2280951 | 2280951 | 2022-03-06 | Eastland | Texas | 48133 | 2769 | 110 |
2277661 | 2277661 | 2022-03-05 | Callahan | Texas | 48059 | 2769 | 72 |
2277698 | 2277698 | 2022-03-05 | Eastland | Texas | 48133 | 2769 | 110 |
2235734 | 2235734 | 2022-02-20 | Lexington city | Virginia | 51678 | 2769 | 39 |
2232483 | 2232483 | 2022-02-19 | Lexington city | Virginia | 51678 | 2769 | 39 |
2229098 | 2229098 | 2022-02-18 | Ward | Texas | 48475 | 2769 | 42 |
2229232 | 2229232 | 2022-02-18 | Lexington city | Virginia | 51678 | 2769 | 39 |
2187452 | 2187452 | 2022-02-06 | Archuleta | Colorado | 8007 | 2769 | 9 |
2184199 | 2184199 | 2022-02-05 | Archuleta | Colorado | 8007 | 2769 | 9 |
2180947 | 2180947 | 2022-02-04 | Archuleta | Colorado | 8007 | 2769 | 9 |
2114773 | 2114773 | 2022-01-14 | Quebradillas | Puerto Rico | 72115 | 2769 | |
2089348 | 2089348 | 2022-01-06 | Goochland | Virginia | 51075 | 2769 | 35 |
2038973 | 2038973 | 2021-12-22 | Kanabec | Minnesota | 27065 | 2769 | 43 |
2018362 | 2018362 | 2021-12-16 | Chaffee | Colorado | 8015 | 2769 | 38 |
2019757 | 2019757 | 2021-12-16 | Park | Montana | 30067 | 2769 | 30 |
2012510 | 2012510 | 2021-12-14 | Bourbon | Kansas | 20011 | 2769 | 44 |
2009259 | 2009259 | 2021-12-13 | Bourbon | Kansas | 20011 | 2769 | 44 |
1998299 | 1998299 | 2021-12-09 | Buckingham | Virginia | 51029 | 2769 | 40 |
1987216 | 1987216 | 2021-12-06 | Wright | Missouri | 29229 | 2769 | 64 |
1973207 | 1973207 | 2021-12-02 | Bond | Illinois | 17005 | 2769 | 34 |
1969963 | 1969963 | 2021-12-01 | Cass | Illinois | 17017 | 2769 | 40 |
1967673 | 1967673 | 2021-11-30 | Morgan | Missouri | 29141 | 2769 | 73 |
1966004 | 1966004 | 2021-11-29 | Wetzel | West Virginia | 54103 | 2769 | 61 |
1891196 | 1891196 | 2021-11-06 | Barbour | West Virginia | 54001 | 2769 | 45 |
1879363 | 1879363 | 2021-11-03 | Breckinridge | Kentucky | 21027 | 2769 | 36 |
1873782 | 1873782 | 2021-11-01 | Currituck | North Carolina | 37053 | 2769 | 27 |
1860000 | 1860000 | 2021-10-28 | Jackson | Louisiana | 22049 | 2769 | 64 |
1856751 | 1856751 | 2021-10-27 | Jackson | Louisiana | 22049 | 2769 | 64 |
1853855 | 1853855 | 2021-10-26 | Andrew | Missouri | 29003 | 2769 | 24 |
1852227 | 1852227 | 2021-10-25 | Lincoln | West Virginia | 54043 | 2769 | 42 |
1828366 | 1828366 | 2021-10-18 | Yancey | North Carolina | 37199 | 2769 | 29 |
1821087 | 1821087 | 2021-10-16 | Talbot | Maryland | 24041 | 2769 | 51 |
1821908 | 1821908 | 2021-10-16 | Rolette | North Dakota | 38079 | 2769 | 31 |
1811946 | 1811946 | 2021-10-13 | Lincoln | New Mexico | 35027 | 2769 | 29 |
1797296 | 1797296 | 2021-10-09 | Sharp | Arkansas | 5135 | 2769 | 63 |
1787034 | 1787034 | 2021-10-05 | Bennington | Vermont | 50003 | 2769 | 22 |
1769123 | 1769123 | 2021-09-30 | Alpena | Michigan | 26007 | 2769 | 69 |
1765874 | 1765874 | 2021-09-29 | Alpena | Michigan | 26007 | 2769 | 69 |
1744654 | 1744654 | 2021-09-22 | Lee | Texas | 48287 | 2769 | 45 |
1744989 | 1744989 | 2021-09-22 | Brooke | West Virginia | 54009 | 2769 | 64 |
1736167 | 1736167 | 2021-09-20 | Starke | Indiana | 18149 | 2769 | 64 |
1676426 | 1676426 | 2021-09-01 | Lamb | Texas | 48279 | 2769 | 86 |
1656137 | 1656137 | 2021-08-26 | Martin | North Carolina | 37117 | 2769 | 50 |
1652064 | 1652064 | 2021-08-25 | Concordia | Louisiana | 22029 | 2769 | 66 |
1653273 | 1653273 | 2021-08-25 | Canovanas | Puerto Rico | 72029 | 2769 | |
1642555 | 1642555 | 2021-08-22 | Meeker | Minnesota | 27093 | 2769 | 46 |
1639305 | 1639305 | 2021-08-21 | Meeker | Minnesota | 27093 | 2769 | 46 |
1636055 | 1636055 | 2021-08-20 | Meeker | Minnesota | 27093 | 2769 | 46 |
1637449 | 1637449 | 2021-08-20 | Lavaca | Texas | 48285 | 2769 | 77 |
1624349 | 1624349 | 2021-08-16 | Cass | Texas | 48067 | 2769 | 91 |
1621102 | 1621102 | 2021-08-15 | Cass | Texas | 48067 | 2769 | 91 |
1602133 | 1602133 | 2021-08-09 | Jackson | Wisconsin | 55053 | 2769 | 29 |
1555570 | 1555570 | 2021-07-26 | Henry | Ohio | 39069 | 2769 | 67 |
1550729 | 1550729 | 2021-07-25 | Peach | Georgia | 13225 | 2769 | 70 |
1552323 | 1552323 | 2021-07-25 | Henry | Ohio | 39069 | 2769 | 67 |
1547482 | 1547482 | 2021-07-24 | Peach | Georgia | 13225 | 2769 | 70 |
1549076 | 1549076 | 2021-07-24 | Henry | Ohio | 39069 | 2769 | 67 |
1544235 | 1544235 | 2021-07-23 | Peach | Georgia | 13225 | 2769 | 70 |
1545829 | 1545829 | 2021-07-23 | Henry | Ohio | 39069 | 2769 | 67 |
1537528 | 1537528 | 2021-07-21 | Morgan | Colorado | 8087 | 2769 | 96 |
1495478 | 1495478 | 2021-07-08 | Franklin | Georgia | 13119 | 2769 | 56 |
1486594 | 1486594 | 2021-07-05 | Oceana | Michigan | 26127 | 2769 | 60 |
1483348 | 1483348 | 2021-07-04 | Oceana | Michigan | 26127 | 2769 | 60 |
1480102 | 1480102 | 2021-07-03 | Oceana | Michigan | 26127 | 2769 | 60 |
1476855 | 1476855 | 2021-07-02 | Oceana | Michigan | 26127 | 2769 | 60 |
1477641 | 1477641 | 2021-07-02 | Hardin | Ohio | 39065 | 2769 | 65 |
1473609 | 1473609 | 2021-07-01 | Oceana | Michigan | 26127 | 2769 | 60 |
1474395 | 1474395 | 2021-07-01 | Hardin | Ohio | 39065 | 2769 | 65 |
1470363 | 1470363 | 2021-06-30 | Oceana | Michigan | 26127 | 2769 | 60 |
1467118 | 1467118 | 2021-06-29 | Oceana | Michigan | 26127 | 2769 | 60 |
1463873 | 1463873 | 2021-06-28 | Oceana | Michigan | 26127 | 2769 | 60 |
1460628 | 1460628 | 2021-06-27 | Oceana | Michigan | 26127 | 2769 | 60 |
1457383 | 1457383 | 2021-06-26 | Oceana | Michigan | 26127 | 2769 | 60 |
1454138 | 1454138 | 2021-06-25 | Oceana | Michigan | 26127 | 2769 | 60 |
1450893 | 1450893 | 2021-06-24 | Oceana | Michigan | 26127 | 2769 | 60 |
1432823 | 1432823 | 2021-06-18 | Gonzales | Texas | 48177 | 2769 | 57 |
1429577 | 1429577 | 2021-06-17 | Gonzales | Texas | 48177 | 2769 | 57 |
1426332 | 1426332 | 2021-06-16 | Gonzales | Texas | 48177 | 2769 | 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);