ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

114 rows where cases = 4253 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2502319 2502319 2022-05-13 Houston Texas 48225 4253 111
2456318 2456318 2022-04-29 Aguas Buenas Puerto Rico 72007 4253  
2448615 2448615 2022-04-27 LaSalle Louisiana 22059 4253 60
2449918 2449918 2022-04-27 Lee South Carolina 45061 4253 95
2445359 2445359 2022-04-26 LaSalle Louisiana 22059 4253 60
2446661 2446661 2022-04-26 Lee South Carolina 45061 4253 95
2443406 2443406 2022-04-25 Lee South Carolina 45061 4253 95
2440150 2440150 2022-04-24 Lee South Carolina 45061 4253 95
2436894 2436894 2022-04-23 Lee South Carolina 45061 4253 95
2433638 2433638 2022-04-22 Lee South Carolina 45061 4253 95
2430382 2430382 2022-04-21 Lee South Carolina 45061 4253 95
2427126 2427126 2022-04-20 Lee South Carolina 45061 4253 95
2423870 2423870 2022-04-19 Lee South Carolina 45061 4253 95
2421298 2421298 2022-04-18 Morgan West Virginia 54065 4253 69
2268399 2268399 2022-03-02 Wetzel West Virginia 54103 4253 79
2256741 2256741 2022-02-27 Antrim Michigan 26009 4253 58
2253490 2253490 2022-02-26 Antrim Michigan 26009 4253 58
2250239 2250239 2022-02-25 Antrim Michigan 26009 4253 58
2216066 2216066 2022-02-14 Shelby Texas 48419 4253 124
2171081 2171081 2022-02-01 Hempstead Arkansas 5057 4253 52
2164095 2164095 2022-01-29 Caledonia Vermont 50005 4253 22
2119319 2119319 2022-01-16 Dodge Georgia 13091 4253 137
2116067 2116067 2022-01-15 Dodge Georgia 13091 4253 137
2112816 2112816 2022-01-14 Dodge Georgia 13091 4253 137
2073652 2073652 2022-01-02 Morgan Colorado 8087 4253 125
2070401 2070401 2022-01-01 Morgan Colorado 8087 4253 125
2067150 2067150 2021-12-31 Morgan Colorado 8087 4253 125
2039307 2039307 2021-12-22 Dawson Nebraska 31047 4253 37
2032218 2032218 2021-12-20 Russell Kentucky 21207 4253 65
2028808 2028808 2021-12-19 Labette Kansas 20099 4253 65
2025557 2025557 2021-12-18 Labette Kansas 20099 4253 65
2022306 2022306 2021-12-17 Labette Kansas 20099 4253 65
2015628 2015628 2021-12-15 Posey Indiana 18129 4253 45
1982017 1982017 2021-12-04 Franklin Vermont 50011 4253 53
1870083 1870083 2021-10-31 Sunflower Mississippi 28133 4253 105
1871714 1871714 2021-10-31 Hancock West Virginia 54029 4253 115
1866834 1866834 2021-10-30 Sunflower Mississippi 28133 4253 105
1863585 1863585 2021-10-29 Sunflower Mississippi 28133 4253 105
1859357 1859357 2021-10-28 Pierce Georgia 13229 4253 103
1849109 1849109 2021-10-25 Bibb Alabama 1007 4253 86
1836840 1836840 2021-10-21 Greene Indiana 18055 4253 100
1811210 1811210 2021-10-13 Ohio Kentucky 21183 4253 77
1802234 1802234 2021-10-10 Greene New York 36039 4253 85
1755115 1755115 2021-09-26 Siskiyou California 6093 4253 51
1755325 1755325 2021-09-26 Emanuel Georgia 13107 4253 99
1756536 1756536 2021-09-26 Ravalli Montana 30081 4253 56
1751867 1751867 2021-09-25 Siskiyou California 6093 4253 51
1752077 1752077 2021-09-25 Emanuel Georgia 13107 4253 99
1753288 1753288 2021-09-25 Ravalli Montana 30081 4253 56
1748618 1748618 2021-09-24 Siskiyou California 6093 4253 51
1748828 1748828 2021-09-24 Emanuel Georgia 13107 4253 99
1750040 1750040 2021-09-24 Ravalli Montana 30081 4253 56
1743987 1743987 2021-09-22 Jackson Ohio 39079 4253 62
1744120 1744120 2021-09-22 Coos Oregon 41011 4253 72
1739244 1739244 2021-09-21 Bureau Illinois 17011 4253 101
1735217 1735217 2021-09-19 Kittitas Washington 53037 4253 43
1731967 1731967 2021-09-18 Kittitas Washington 53037 4253 43
1728717 1728717 2021-09-17 Kittitas Washington 53037 4253 43
1696883 1696883 2021-09-08 Lee Georgia 13177 4253 71
1655449 1655449 2021-08-26 Huron Michigan 26063 4253 84
1652202 1652202 2021-08-25 Huron Michigan 26063 4253 84
1637007 1637007 2021-08-20 Venango Pennsylvania 42121 4253 105
1632832 1632832 2021-08-19 Steele Minnesota 27147 4253 19
1620104 1620104 2021-08-15 Silver Bow Montana 30093 4253 87
1616856 1616856 2021-08-14 Silver Bow Montana 30093 4253 87
1613608 1613608 2021-08-13 Silver Bow Montana 30093 4253 87
1565606 1565606 2021-07-29 Ponce Puerto Rico 72113 4253  
1551714 1551714 2021-07-25 Union Mississippi 28145 4253 79
1548467 1548467 2021-07-24 Union Mississippi 28145 4253 79
1545220 1545220 2021-07-23 Union Mississippi 28145 4253 79
1540087 1540087 2021-07-21 Titus Texas 48449 4253 84
1525456 1525456 2021-07-17 Calvert Maryland 24009 4253 86
1471751 1471751 2021-06-30 Erath Texas 48143 4253 70
1442631 1442631 2021-06-21 Matagorda Texas 48321 4253 114
1428338 1428338 2021-06-17 Pontotoc Mississippi 28115 4253 73
1395726 1395726 2021-06-07 Sanilac Michigan 26151 4253 121
1361135 1361135 2021-05-27 Chester South Carolina 45023 4253 76
1358122 1358122 2021-05-26 Cherokee Texas 48073 4253 142
1352415 1352415 2021-05-25 Humboldt California 6023 4253 43
1350096 1350096 2021-05-24 Avoyelles Louisiana 22009 4253 123
1331566 1331566 2021-05-18 Defiance Ohio 39039 4253 97
1327595 1327595 2021-05-17 Isanti Minnesota 27059 4253 64
1314011 1314011 2021-05-13 Montgomery Indiana 18107 4253 91
1271764 1271764 2021-04-30 Clinton Indiana 18023 4253 58
1229722 1229722 2021-04-17 Wapello Iowa 19179 4253 120
1203582 1203582 2021-04-09 Gibson Indiana 18051 4253 91
1197708 1197708 2021-04-07 Goodhue Minnesota 27049 4253 70
1189210 1189210 2021-04-04 Rhea Tennessee 47143 4253 75
1185963 1185963 2021-04-03 Rhea Tennessee 47143 4253 75
1182716 1182716 2021-04-02 Rhea Tennessee 47143 4253 75
1179469 1179469 2021-04-01 Rhea Tennessee 47143 4253 75
1121381 1121381 2021-03-14 Danville city Virginia 51590 4253 117
1109836 1109836 2021-03-11 Lincoln Louisiana 22061 4253 89
1103298 1103298 2021-03-09 Scott Kentucky 21209 4253 26
1098824 1098824 2021-03-07 Mercer West Virginia 54055 4253 112
1092342 1092342 2021-03-05 Putnam West Virginia 54079 4253 74
1078881 1078881 2021-03-01 Chambers Texas 48071 4253 42
1060655 1060655 2021-02-24 Marion Illinois 17121 4253 117
1057409 1057409 2021-02-23 Marion Illinois 17121 4253 117
1049282 1049282 2021-02-20 Bradford Pennsylvania 42015 4253 74

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);