ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 6164 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Tennessee 9
- Texas 6
- South Carolina 5
- Arkansas 4
- Illinois 4
- North Carolina 4
- Indiana 3
- Kentucky 3
- New Mexico 3
- Ohio 3
- Alabama 2
- Florida 2
- Minnesota 2
- Mississippi 2
- New York 2
- Pennsylvania 2
- Wisconsin 2
- California 1
- Georgia 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- North Dakota 1
- Puerto Rico 1
- South Dakota 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333014 | 2333014 | 2022-03-22 | Gray | Texas | 48179 | 6164 | 124 |
2329761 | 2329761 | 2022-03-21 | Gray | Texas | 48179 | 6164 | 124 |
2326509 | 2326509 | 2022-03-20 | Gray | Texas | 48179 | 6164 | 124 |
2323256 | 2323256 | 2022-03-19 | Gray | Texas | 48179 | 6164 | 125 |
2245770 | 2245770 | 2022-02-24 | Geneva | Alabama | 1061 | 6164 | 151 |
2193407 | 2193407 | 2022-02-07 | Carroll | Virginia | 51035 | 6164 | 127 |
2154157 | 2154157 | 2022-01-26 | Howard | Texas | 48227 | 6164 | 157 |
2114709 | 2114709 | 2022-01-14 | Warren | Pennsylvania | 42123 | 6164 | 188 |
2096830 | 2096830 | 2022-01-09 | Adams | Indiana | 18001 | 6164 | 97 |
2093578 | 2093578 | 2022-01-08 | Adams | Indiana | 18001 | 6164 | 97 |
2090326 | 2090326 | 2022-01-07 | Adams | Indiana | 18001 | 6164 | 97 |
2088831 | 2088831 | 2022-01-06 | Williamsburg | South Carolina | 45089 | 6164 | 132 |
2012698 | 2012698 | 2021-12-14 | Muhlenberg | Kentucky | 21177 | 6164 | 98 |
2011141 | 2011141 | 2021-12-13 | Matagorda | Texas | 48321 | 6164 | 161 |
1996741 | 1996741 | 2021-12-09 | Polk | Minnesota | 27119 | 6164 | 89 |
1991330 | 1991330 | 2021-12-07 | Codington | South Dakota | 46029 | 6164 | 89 |
1977710 | 1977710 | 2021-12-03 | Cortland | New York | 36023 | 6164 | 89 |
1892036 | 1892036 | 2021-11-07 | Stephenson | Illinois | 17177 | 6164 | 115 |
1888786 | 1888786 | 2021-11-06 | Stephenson | Illinois | 17177 | 6164 | 115 |
1885536 | 1885536 | 2021-11-05 | Stephenson | Illinois | 17177 | 6164 | 115 |
1872948 | 1872948 | 2021-11-01 | Perry | Kentucky | 21193 | 6164 | 88 |
1844722 | 1844722 | 2021-10-23 | Mercer | Ohio | 39107 | 6164 | 93 |
1834731 | 1834731 | 2021-10-20 | Madison | New York | 36053 | 6164 | 102 |
1823227 | 1823227 | 2021-10-17 | Boone | Arkansas | 5009 | 6164 | 126 |
1811297 | 1811297 | 2021-10-13 | Vernon | Louisiana | 22115 | 6164 | 159 |
1764783 | 1764783 | 2021-09-29 | Miller | Arkansas | 5091 | 6164 | 41 |
1756881 | 1756881 | 2021-09-26 | Watauga | North Carolina | 37189 | 6164 | 34 |
1753633 | 1753633 | 2021-09-25 | Watauga | North Carolina | 37189 | 6164 | 34 |
1750385 | 1750385 | 2021-09-24 | Watauga | North Carolina | 37189 | 6164 | 34 |
1748306 | 1748306 | 2021-09-23 | Dunn | Wisconsin | 55033 | 6164 | 40 |
1740672 | 1740672 | 2021-09-21 | Morton | North Dakota | 38059 | 6164 | 104 |
1665739 | 1665739 | 2021-08-29 | Curry | New Mexico | 35009 | 6164 | 89 |
1662491 | 1662491 | 2021-08-28 | Curry | New Mexico | 35009 | 6164 | 89 |
1659243 | 1659243 | 2021-08-27 | Curry | New Mexico | 35009 | 6164 | 89 |
1643733 | 1643733 | 2021-08-22 | Dyer | Tennessee | 47045 | 6164 | 112 |
1640483 | 1640483 | 2021-08-21 | Dyer | Tennessee | 47045 | 6164 | 112 |
1637233 | 1637233 | 2021-08-20 | Dyer | Tennessee | 47045 | 6164 | 112 |
1611855 | 1611855 | 2021-08-12 | Barron | Wisconsin | 55005 | 6164 | 86 |
1494105 | 1494105 | 2021-07-07 | Union | Pennsylvania | 42119 | 6164 | 89 |
1416308 | 1416308 | 2021-06-13 | Cherokee | South Carolina | 45021 | 6164 | 157 |
1413062 | 1413062 | 2021-06-12 | Cherokee | South Carolina | 45021 | 6164 | 157 |
1409817 | 1409817 | 2021-06-11 | Cherokee | South Carolina | 45021 | 6164 | 157 |
1406572 | 1406572 | 2021-06-10 | Cherokee | South Carolina | 45021 | 6164 | 157 |
1362627 | 1362627 | 2021-05-28 | Ogle | Illinois | 17141 | 6164 | 91 |
1358847 | 1358847 | 2021-05-27 | Greene | Arkansas | 5055 | 6164 | 77 |
1325573 | 1325573 | 2021-05-16 | Loudon | Tennessee | 47105 | 6164 | 69 |
1322327 | 1322327 | 2021-05-15 | Loudon | Tennessee | 47105 | 6164 | 69 |
1319081 | 1319081 | 2021-05-14 | Loudon | Tennessee | 47105 | 6164 | 69 |
1288732 | 1288732 | 2021-05-05 | Lafayette | Mississippi | 28071 | 6164 | 118 |
1249549 | 1249549 | 2021-04-23 | Berkshire | Massachusetts | 25003 | 6164 | 282 |
1246524 | 1246524 | 2021-04-22 | Lamar | Mississippi | 28073 | 6164 | 85 |
1166418 | 1166418 | 2021-03-28 | Carter | Tennessee | 47019 | 6164 | 155 |
1163170 | 1163170 | 2021-03-27 | Carter | Tennessee | 47019 | 6164 | 155 |
1159517 | 1159517 | 2021-03-26 | Scioto | Ohio | 39145 | 6164 | 96 |
1159921 | 1159921 | 2021-03-26 | Carter | Tennessee | 47019 | 6164 | 155 |
1110771 | 1110771 | 2021-03-11 | Geauga | Ohio | 39055 | 6164 | 142 |
969505 | 969505 | 2021-01-27 | Walton | Florida | 12131 | 6164 | 66 |
842696 | 842696 | 2020-12-19 | Jefferson | Arkansas | 5069 | 6164 | 123 |
817591 | 817591 | 2020-12-11 | Boone | Kentucky | 21015 | 6164 | 33 |
812024 | 812024 | 2020-12-09 | Davidson | North Carolina | 37057 | 6164 | 58 |
785347 | 785347 | 2020-12-01 | Harford | Maryland | 24025 | 6164 | 103 |
763755 | 763755 | 2020-11-24 | Bayamon | Puerto Rico | 72021 | 6164 | |
619084 | 619084 | 2020-10-11 | Clarke | Georgia | 13059 | 6164 | 46 |
583065 | 583065 | 2020-09-30 | Shelby | Alabama | 1117 | 6164 | 50 |
486114 | 486114 | 2020-08-31 | Marin | California | 6041 | 6164 | 95 |
412054 | 412054 | 2020-08-08 | Sarasota | Florida | 12115 | 6164 | 138 |
368031 | 368031 | 2020-07-25 | Ramsey | Minnesota | 27123 | 6164 | 253 |
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);