ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 4102 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 15
- Virginia 10
- Missouri 9
- Pennsylvania 9
- Tennessee 9
- Texas 9
- Georgia 7
- Illinois 5
- North Carolina 5
- Indiana 4
- West Virginia 4
- Alabama 3
- Arkansas 3
- Louisiana 3
- Ohio 3
- Puerto Rico 3
- South Carolina 3
- Washington 3
- Kentucky 2
- Michigan 2
- Minnesota 2
- South Dakota 2
- California 1
- Idaho 1
- Maryland 1
- Mississippi 1
- Montana 1
- Nebraska 1
- New Hampshire 1
- New York 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479113 | 2479113 | 2022-05-06 | Aibonito | Puerto Rico | 72009 | 4102 | |
2420795 | 2420795 | 2022-04-18 | Aransas | Texas | 48007 | 4102 | 84 |
2382470 | 2382470 | 2022-04-07 | Clay | Arkansas | 5021 | 4102 | 93 |
2384703 | 2384703 | 2022-04-07 | Catano | Puerto Rico | 72033 | 4102 | |
2379215 | 2379215 | 2022-04-06 | Clay | Arkansas | 5021 | 4102 | 93 |
2375961 | 2375961 | 2022-04-05 | Clay | Arkansas | 5021 | 4102 | 93 |
2369738 | 2369738 | 2022-04-03 | Brantley | Georgia | 13025 | 4102 | 107 |
2366485 | 2366485 | 2022-04-02 | Brantley | Georgia | 13025 | 4102 | 107 |
2363232 | 2363232 | 2022-04-01 | Brantley | Georgia | 13025 | 4102 | 107 |
2306568 | 2306568 | 2022-03-14 | Fulton | Pennsylvania | 42057 | 4102 | 65 |
2211559 | 2211559 | 2022-02-13 | Pike | Missouri | 29163 | 4102 | 56 |
2208306 | 2208306 | 2022-02-12 | Pike | Missouri | 29163 | 4102 | 56 |
2205053 | 2205053 | 2022-02-11 | Pike | Missouri | 29163 | 4102 | 56 |
2206626 | 2206626 | 2022-02-11 | Wetzel | West Virginia | 54103 | 4102 | 74 |
2201800 | 2201800 | 2022-02-10 | Pike | Missouri | 29163 | 4102 | 56 |
2200100 | 2200100 | 2022-02-09 | Morgan | West Virginia | 54065 | 4102 | 60 |
2171134 | 2171134 | 2022-02-01 | Colusa | California | 6011 | 4102 | 21 |
2150782 | 2150782 | 2022-01-25 | Union | Tennessee | 47173 | 4102 | 67 |
2147530 | 2147530 | 2022-01-24 | Union | Tennessee | 47173 | 4102 | 67 |
2144276 | 2144276 | 2022-01-23 | Union | Tennessee | 47173 | 4102 | 67 |
2141021 | 2141021 | 2022-01-22 | Union | Tennessee | 47173 | 4102 | 67 |
2137765 | 2137765 | 2022-01-21 | Union | Tennessee | 47173 | 4102 | 67 |
2134511 | 2134511 | 2022-01-20 | Union | Tennessee | 47173 | 4102 | 67 |
2134609 | 2134609 | 2022-01-20 | Gonzales | Texas | 48177 | 4102 | 92 |
2131259 | 2131259 | 2022-01-19 | Union | Tennessee | 47173 | 4102 | 67 |
2099949 | 2099949 | 2022-01-10 | Cassia | Idaho | 16031 | 4102 | 47 |
2061520 | 2061520 | 2021-12-29 | Pointe Coupee | Louisiana | 22077 | 4102 | 85 |
2026994 | 2026994 | 2021-12-18 | Mayaguez | Puerto Rico | 72097 | 4102 | |
1970916 | 1970916 | 2021-12-01 | McDonald | Missouri | 29119 | 4102 | 63 |
1967666 | 1967666 | 2021-11-30 | McDonald | Missouri | 29119 | 4102 | 63 |
1935204 | 1935204 | 2021-11-20 | Washington | Missouri | 29221 | 4102 | 94 |
1882098 | 1882098 | 2021-11-04 | Peach | Georgia | 13225 | 4102 | 103 |
1881275 | 1881275 | 2021-11-03 | Accomack | Virginia | 51001 | 4102 | 79 |
1873305 | 1873305 | 2021-11-01 | Leake | Mississippi | 28079 | 4102 | 89 |
1804412 | 1804412 | 2021-10-11 | White | Indiana | 18181 | 4102 | 61 |
1758133 | 1758133 | 2021-09-27 | Bibb | Alabama | 1007 | 4102 | 81 |
1731649 | 1731649 | 2021-09-18 | Kleberg | Texas | 48273 | 4102 | 120 |
1718198 | 1718198 | 2021-09-14 | McKean | Pennsylvania | 42083 | 4102 | 76 |
1675558 | 1675558 | 2021-09-01 | Tioga | New York | 36107 | 4102 | 65 |
1575911 | 1575911 | 2021-08-01 | Charlottesville city | Virginia | 51540 | 4102 | 58 |
1572663 | 1572663 | 2021-07-31 | Charlottesville city | Virginia | 51540 | 4102 | 58 |
1569415 | 1569415 | 2021-07-30 | Charlottesville city | Virginia | 51540 | 4102 | 58 |
1554804 | 1554804 | 2021-07-26 | Beltrami | Minnesota | 27007 | 4102 | 63 |
1550726 | 1550726 | 2021-07-25 | Oconee | Georgia | 13219 | 4102 | 73 |
1547479 | 1547479 | 2021-07-24 | Oconee | Georgia | 13219 | 4102 | 73 |
1544232 | 1544232 | 2021-07-23 | Oconee | Georgia | 13219 | 4102 | 73 |
1510268 | 1510268 | 2021-07-12 | Polk | Oregon | 41053 | 4102 | 56 |
1481119 | 1481119 | 2021-07-03 | Venango | Pennsylvania | 42121 | 4102 | 102 |
1477872 | 1477872 | 2021-07-02 | Venango | Pennsylvania | 42121 | 4102 | 102 |
1474626 | 1474626 | 2021-07-01 | Venango | Pennsylvania | 42121 | 4102 | 102 |
1468018 | 1468018 | 2021-06-29 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1464773 | 1464773 | 2021-06-28 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1461528 | 1461528 | 2021-06-27 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1458283 | 1458283 | 2021-06-26 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1455038 | 1455038 | 2021-06-25 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1451793 | 1451793 | 2021-06-24 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1448547 | 1448547 | 2021-06-23 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1446064 | 1446064 | 2021-06-22 | Franklin | Virginia | 51067 | 4102 | 80 |
1442819 | 1442819 | 2021-06-21 | Franklin | Virginia | 51067 | 4102 | 80 |
1439574 | 1439574 | 2021-06-20 | Franklin | Virginia | 51067 | 4102 | 80 |
1436327 | 1436327 | 2021-06-19 | Franklin | Virginia | 51067 | 4102 | 80 |
1377397 | 1377397 | 2021-06-01 | Williamsburg | South Carolina | 45089 | 4102 | 100 |
1374151 | 1374151 | 2021-05-31 | Williamsburg | South Carolina | 45089 | 4102 | 100 |
1362993 | 1362993 | 2021-05-28 | Franklin | Kentucky | 21073 | 4102 | 48 |
1363735 | 1363735 | 2021-05-28 | Belknap | New Hampshire | 33001 | 4102 | 100 |
1364281 | 1364281 | 2021-05-28 | Wayne | Pennsylvania | 42127 | 4102 | 80 |
1340888 | 1340888 | 2021-05-21 | Silver Bow | Montana | 30093 | 4102 | 86 |
1331475 | 1331475 | 2021-05-18 | Stokes | North Carolina | 37169 | 4102 | 80 |
1262889 | 1262889 | 2021-04-27 | Platte | Missouri | 29165 | 4102 | 47 |
1256554 | 1256554 | 2021-04-25 | Platte | Nebraska | 31141 | 4102 | 48 |
1257241 | 1257241 | 2021-04-25 | Chester | South Carolina | 45023 | 4102 | 75 |
1237798 | 1237798 | 2021-04-19 | Brookings | South Dakota | 46011 | 4102 | 37 |
1223384 | 1223384 | 2021-04-15 | Graves | Kentucky | 21083 | 4102 | 90 |
1225462 | 1225462 | 2021-04-15 | Marion | West Virginia | 54049 | 4102 | 49 |
1197071 | 1197071 | 2021-04-07 | Clinton | Indiana | 18023 | 4102 | 58 |
1192520 | 1192520 | 2021-04-05 | Cherokee | Texas | 48073 | 4102 | 136 |
1189271 | 1189271 | 2021-04-04 | Cherokee | Texas | 48073 | 4102 | 136 |
1186024 | 1186024 | 2021-04-03 | Cherokee | Texas | 48073 | 4102 | 135 |
1182777 | 1182777 | 2021-04-02 | Cherokee | Texas | 48073 | 4102 | 135 |
1178999 | 1178999 | 2021-04-01 | Putnam | Ohio | 39137 | 4102 | 98 |
1179530 | 1179530 | 2021-04-01 | Cherokee | Texas | 48073 | 4102 | 135 |
1172571 | 1172571 | 2021-03-30 | Mayes | Oklahoma | 40097 | 4102 | 40 |
1169324 | 1169324 | 2021-03-29 | Mayes | Oklahoma | 40097 | 4102 | 40 |
1166076 | 1166076 | 2021-03-28 | Mayes | Oklahoma | 40097 | 4102 | 40 |
1162828 | 1162828 | 2021-03-27 | Mayes | Oklahoma | 40097 | 4102 | 40 |
1158732 | 1158732 | 2021-03-26 | Douglas | Minnesota | 27041 | 4102 | 70 |
1159579 | 1159579 | 2021-03-26 | Mayes | Oklahoma | 40097 | 4102 | 40 |
1156332 | 1156332 | 2021-03-25 | Mayes | Oklahoma | 40097 | 4102 | 40 |
1153085 | 1153085 | 2021-03-24 | Mayes | Oklahoma | 40097 | 4102 | 40 |
1130264 | 1130264 | 2021-03-17 | Knox | Ohio | 39083 | 4102 | 107 |
1127390 | 1127390 | 2021-03-16 | Codington | South Dakota | 46029 | 4102 | 77 |
1113209 | 1113209 | 2021-03-12 | Isabella | Michigan | 26073 | 4102 | 73 |
1105495 | 1105495 | 2021-03-10 | Russell | Alabama | 1113 | 4102 | 34 |
1086650 | 1086650 | 2021-03-04 | Stephenson | Illinois | 17177 | 4102 | 95 |
1080650 | 1080650 | 2021-03-02 | Washington | Louisiana | 22117 | 4102 | 121 |
1079019 | 1079019 | 2021-03-01 | Nacogdoches | Texas | 48347 | 4102 | 149 |
1055486 | 1055486 | 2021-02-22 | Richmond | North Carolina | 37153 | 4102 | 87 |
1052857 | 1052857 | 2021-02-21 | Rhea | Tennessee | 47143 | 4102 | 72 |
1039186 | 1039186 | 2021-02-17 | Beaufort | North Carolina | 37013 | 4102 | 79 |
1013582 | 1013582 | 2021-02-09 | Bradford | Pennsylvania | 42015 | 4102 | 73 |
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);