ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where cases = 4441 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 14
- Texas 10
- Kentucky 8
- Illinois 5
- Mississippi 5
- North Carolina 5
- South Carolina 5
- Puerto Rico 4
- Virginia 4
- West Virginia 4
- Georgia 3
- Idaho 3
- Ohio 3
- Oklahoma 3
- Alabama 2
- Indiana 2
- New Mexico 2
- New York 2
- Wisconsin 2
- Alaska 1
- Arkansas 1
- California 1
- Iowa 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Missouri 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482430 | 2482430 | 2022-05-07 | San German | Puerto Rico | 72125 | 4441 | |
2451908 | 2451908 | 2022-04-28 | Winn | Louisiana | 22127 | 4441 | 63 |
2448652 | 2448652 | 2022-04-27 | Winn | Louisiana | 22127 | 4441 | 63 |
2444836 | 2444836 | 2022-04-26 | Ford | Illinois | 17053 | 4441 | 74 |
2445396 | 2445396 | 2022-04-26 | Winn | Louisiana | 22127 | 4441 | 63 |
2442140 | 2442140 | 2022-04-25 | Winn | Louisiana | 22127 | 4441 | 63 |
2362414 | 2362414 | 2022-03-31 | Shelby | Texas | 48419 | 4441 | 132 |
2225343 | 2225343 | 2022-02-17 | Fajardo | Puerto Rico | 72053 | 4441 | |
2225896 | 2225896 | 2022-02-17 | Caledonia | Vermont | 50005 | 4441 | 24 |
2222095 | 2222095 | 2022-02-16 | Guayama | Puerto Rico | 72057 | 4441 | |
2211078 | 2211078 | 2022-02-13 | Powell | Kentucky | 21197 | 4441 | 32 |
2207825 | 2207825 | 2022-02-12 | Powell | Kentucky | 21197 | 4441 | 32 |
2204572 | 2204572 | 2022-02-11 | Powell | Kentucky | 21197 | 4441 | 32 |
2194284 | 2194284 | 2022-02-08 | Cassia | Idaho | 16031 | 4441 | 49 |
2177942 | 2177942 | 2022-02-03 | Morgan | Georgia | 13211 | 4441 | 53 |
2035630 | 2035630 | 2021-12-21 | Emmet | Michigan | 26047 | 4441 | 58 |
2028439 | 2028439 | 2021-12-19 | Elmore | Idaho | 16039 | 4441 | 52 |
2029025 | 2029025 | 2021-12-19 | Richland | Louisiana | 22083 | 4441 | 80 |
2025188 | 2025188 | 2021-12-18 | Elmore | Idaho | 16039 | 4441 | 52 |
2025774 | 2025774 | 2021-12-18 | Richland | Louisiana | 22083 | 4441 | 80 |
2022523 | 2022523 | 2021-12-17 | Richland | Louisiana | 22083 | 4441 | 80 |
2024478 | 2024478 | 2021-12-17 | Jackson | West Virginia | 54035 | 4441 | 103 |
1967286 | 1967286 | 2021-11-30 | West Baton Rouge | Louisiana | 22121 | 4441 | 78 |
1928163 | 1928163 | 2021-11-18 | Lincoln | Kentucky | 21137 | 4441 | 100 |
1918027 | 1918027 | 2021-11-15 | Saline | Illinois | 17165 | 4441 | 87 |
1893782 | 1893782 | 2021-11-07 | Edgefield | South Carolina | 45037 | 4441 | 57 |
1890532 | 1890532 | 2021-11-06 | Edgefield | South Carolina | 45037 | 4441 | 57 |
1887282 | 1887282 | 2021-11-05 | Edgefield | South Carolina | 45037 | 4441 | 57 |
1884032 | 1884032 | 2021-11-04 | Edgefield | South Carolina | 45037 | 4441 | 57 |
1879390 | 1879390 | 2021-11-03 | Grant | Kentucky | 21081 | 4441 | 40 |
1879951 | 1879951 | 2021-11-03 | Stoddard | Missouri | 29207 | 4441 | 71 |
1861843 | 1861843 | 2021-10-28 | Isle of Wight | Virginia | 51093 | 4441 | 87 |
1850195 | 1850195 | 2021-10-25 | Montgomery | Kentucky | 21173 | 4441 | 55 |
1847354 | 1847354 | 2021-10-24 | Yazoo | Mississippi | 28163 | 4441 | 87 |
1844104 | 1844104 | 2021-10-23 | Yazoo | Mississippi | 28163 | 4441 | 87 |
1840854 | 1840854 | 2021-10-22 | Yazoo | Mississippi | 28163 | 4441 | 87 |
1781292 | 1781292 | 2021-10-04 | Chattooga | Georgia | 13055 | 4441 | 92 |
1766111 | 1766111 | 2021-09-29 | Tate | Mississippi | 28137 | 4441 | 103 |
1760998 | 1760998 | 2021-09-27 | Willacy | Texas | 48489 | 4441 | 103 |
1757750 | 1757750 | 2021-09-26 | Willacy | Texas | 48489 | 4441 | 103 |
1693810 | 1693810 | 2021-09-07 | Lee | Illinois | 17103 | 4441 | 95 |
1598838 | 1598838 | 2021-08-08 | Ohio | West Virginia | 54069 | 4441 | 87 |
1595589 | 1595589 | 2021-08-07 | Ohio | West Virginia | 54069 | 4441 | 87 |
1592340 | 1592340 | 2021-08-06 | Ohio | West Virginia | 54069 | 4441 | 87 |
1584795 | 1584795 | 2021-08-04 | Fulton | Ohio | 39051 | 4441 | 75 |
1568362 | 1568362 | 2021-07-30 | Tompkins | New York | 36109 | 4441 | 52 |
1541667 | 1541667 | 2021-07-22 | Webster | Louisiana | 22119 | 4441 | 116 |
1524270 | 1524270 | 2021-07-17 | Covington | Alabama | 1039 | 4441 | 125 |
1510762 | 1510762 | 2021-07-12 | Jim Wells | Texas | 48249 | 4441 | 107 |
1507515 | 1507515 | 2021-07-11 | Jim Wells | Texas | 48249 | 4441 | 107 |
1497461 | 1497461 | 2021-07-08 | Dillon | South Carolina | 45033 | 4441 | 85 |
1488112 | 1488112 | 2021-07-05 | Rusk | Texas | 48401 | 4441 | 109 |
1484865 | 1484865 | 2021-07-04 | Rusk | Texas | 48401 | 4441 | 109 |
1481619 | 1481619 | 2021-07-03 | Rusk | Texas | 48401 | 4441 | 109 |
1461227 | 1461227 | 2021-06-27 | Alexander | North Carolina | 37003 | 4441 | 85 |
1457982 | 1457982 | 2021-06-26 | Alexander | North Carolina | 37003 | 4441 | 85 |
1454737 | 1454737 | 2021-06-25 | Alexander | North Carolina | 37003 | 4441 | 85 |
1451076 | 1451076 | 2021-06-24 | Warren | Mississippi | 28149 | 4441 | 121 |
1430268 | 1430268 | 2021-06-18 | Miller | Arkansas | 5091 | 4441 | 38 |
1424802 | 1424802 | 2021-06-16 | Washington | Louisiana | 22117 | 4441 | 134 |
1421554 | 1421554 | 2021-06-15 | Washington | Louisiana | 22117 | 4441 | 134 |
1418309 | 1418309 | 2021-06-14 | Washington | Louisiana | 22117 | 4441 | 134 |
1355174 | 1355174 | 2021-05-25 | Danville city | Virginia | 51590 | 4441 | 138 |
1352213 | 1352213 | 2021-05-24 | Sweetwater | Wyoming | 56037 | 4441 | 39 |
1294301 | 1294301 | 2021-05-07 | Thomas | Georgia | 13275 | 4441 | 123 |
1281448 | 1281448 | 2021-05-03 | Marion | Illinois | 17121 | 4441 | 121 |
1241121 | 1241121 | 2021-04-20 | Cocke | Tennessee | 47029 | 4441 | 98 |
1241311 | 1241311 | 2021-04-20 | Hill | Texas | 48217 | 4441 | 106 |
1233436 | 1233436 | 2021-04-18 | Goodhue | Minnesota | 27049 | 4441 | 72 |
1225297 | 1225297 | 2021-04-15 | Culpeper | Virginia | 51047 | 4441 | 58 |
1214453 | 1214453 | 2021-04-12 | Clinton | New York | 36019 | 4441 | 32 |
1214549 | 1214549 | 2021-04-12 | Hoke | North Carolina | 37093 | 4441 | 55 |
1160436 | 1160436 | 2021-03-26 | Washington | Virginia | 51191 | 4441 | 100 |
1142201 | 1142201 | 2021-03-21 | Henderson | Kentucky | 21101 | 4441 | 70 |
1133772 | 1133772 | 2021-03-18 | Guaynabo | Puerto Rico | 72061 | 4441 | |
1084548 | 1084548 | 2021-03-03 | Otero | New Mexico | 35035 | 4441 | 61 |
1058809 | 1058809 | 2021-02-23 | Williams | North Dakota | 38105 | 4441 | 36 |
995822 | 995822 | 2021-02-04 | Jackson | Indiana | 18071 | 4441 | 60 |
987479 | 987479 | 2021-02-01 | Seneca | Ohio | 39147 | 4441 | 66 |
980950 | 980950 | 2021-01-30 | Huron | Ohio | 39077 | 4441 | 41 |
976704 | 976704 | 2021-01-29 | Pike | Kentucky | 21195 | 4441 | 46 |
955085 | 955085 | 2021-01-22 | McClain | Oklahoma | 40087 | 4441 | 36 |
938850 | 938850 | 2021-01-17 | Le Flore | Oklahoma | 40079 | 4441 | 34 |
927646 | 927646 | 2021-01-14 | Dearborn | Indiana | 18029 | 4441 | 45 |
928746 | 928746 | 2021-01-14 | Curry | New Mexico | 35009 | 4441 | 52 |
862027 | 862027 | 2020-12-25 | Blount | Alabama | 1009 | 4441 | 58 |
861930 | 861930 | 2020-12-24 | Barron | Wisconsin | 55005 | 4441 | 55 |
844537 | 844537 | 2020-12-19 | Sampson | North Carolina | 37163 | 4441 | 57 |
825286 | 825286 | 2020-12-13 | Pottawatomie | Oklahoma | 40125 | 4441 | 25 |
817786 | 817786 | 2020-12-11 | Allegany | Maryland | 24001 | 4441 | 113 |
793427 | 793427 | 2020-12-03 | Parker | Texas | 48367 | 4441 | 73 |
786377 | 786377 | 2020-12-01 | Lane | Oregon | 41039 | 4441 | 43 |
717613 | 717613 | 2020-11-10 | Flathead | Montana | 30029 | 4441 | 27 |
632463 | 632463 | 2020-10-15 | Dubuque | Iowa | 19061 | 4441 | 52 |
620410 | 620410 | 2020-10-11 | Sarpy | Nebraska | 31153 | 4441 | 32 |
576597 | 576597 | 2020-09-28 | Anchorage | Alaska | 2020 | 4441 | 35 |
571213 | 571213 | 2020-09-26 | Tangipahoa | Louisiana | 22105 | 4441 | 118 |
567971 | 567971 | 2020-09-25 | Tangipahoa | Louisiana | 22105 | 4441 | 118 |
489097 | 489097 | 2020-08-31 | Racine | Wisconsin | 55101 | 4441 | 89 |
418801 | 418801 | 2020-08-10 | St. Clair | Illinois | 17163 | 4441 | 161 |
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);