ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 5796 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Missouri 9
- North Carolina 7
- Georgia 6
- Illinois 5
- New York 5
- Tennessee 4
- Arkansas 3
- Connecticut 3
- Indiana 3
- Minnesota 3
- South Dakota 3
- Texas 3
- Virginia 3
- Wisconsin 3
- Kansas 2
- Nebraska 2
- Ohio 2
- Puerto Rico 2
- West Virginia 2
- Alabama 1
- California 1
- Louisiana 1
- Maine 1
- Massachusetts 1
- Mississippi 1
- Nevada 1
- Pennsylvania 1
- South Carolina 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2455542 | 2455542 | 2022-04-29 | McDonald | Missouri | 29119 | 5796 | 71 |
2452286 | 2452286 | 2022-04-28 | McDonald | Missouri | 29119 | 5796 | 71 |
2449030 | 2449030 | 2022-04-27 | McDonald | Missouri | 29119 | 5796 | 71 |
2445773 | 2445773 | 2022-04-26 | McDonald | Missouri | 29119 | 5796 | 71 |
2442518 | 2442518 | 2022-04-25 | McDonald | Missouri | 29119 | 5796 | 71 |
2439262 | 2439262 | 2022-04-24 | McDonald | Missouri | 29119 | 5796 | 71 |
2436006 | 2436006 | 2022-04-23 | McDonald | Missouri | 29119 | 5796 | 71 |
2432750 | 2432750 | 2022-04-22 | McDonald | Missouri | 29119 | 5796 | 71 |
2392618 | 2392618 | 2022-04-10 | Pierce | Georgia | 13229 | 5796 | 133 |
2389362 | 2389362 | 2022-04-09 | Pierce | Georgia | 13229 | 5796 | 133 |
2386107 | 2386107 | 2022-04-08 | Pierce | Georgia | 13229 | 5796 | 133 |
2311970 | 2311970 | 2022-03-16 | Knox | Maine | 23013 | 5796 | 32 |
2294380 | 2294380 | 2022-03-10 | Hampshire | West Virginia | 54027 | 5796 | 69 |
2212460 | 2212460 | 2022-02-13 | Davison | South Dakota | 46035 | 5796 | 79 |
2209207 | 2209207 | 2022-02-12 | Davison | South Dakota | 46035 | 5796 | 79 |
2205954 | 2205954 | 2022-02-11 | Davison | South Dakota | 46035 | 5796 | 79 |
2191249 | 2191249 | 2022-02-07 | Washington | Indiana | 18175 | 5796 | 75 |
2089412 | 2089412 | 2022-01-06 | Smyth | Virginia | 51173 | 5796 | 139 |
1996022 | 1996022 | 2021-12-09 | Monroe | Illinois | 17133 | 5796 | 105 |
1988207 | 1988207 | 2021-12-06 | Scott | Tennessee | 47151 | 5796 | 67 |
1988726 | 1988726 | 2021-12-06 | Marshall | West Virginia | 54051 | 5796 | 123 |
1955499 | 1955499 | 2021-11-26 | Toa Alta | Puerto Rico | 72135 | 5796 | |
1952248 | 1952248 | 2021-11-25 | Toa Alta | Puerto Rico | 72135 | 5796 | |
1948911 | 1948911 | 2021-11-24 | Perry | Pennsylvania | 42099 | 5796 | 132 |
1912702 | 1912702 | 2021-11-13 | Cortland | New York | 36023 | 5796 | 87 |
1906333 | 1906333 | 2021-11-11 | Scotland | North Carolina | 37165 | 5796 | 108 |
1903084 | 1903084 | 2021-11-10 | Scotland | North Carolina | 37165 | 5796 | 108 |
1876828 | 1876828 | 2021-11-02 | Madison | Nebraska | 31119 | 5796 | 47 |
1873579 | 1873579 | 2021-11-01 | Madison | Nebraska | 31119 | 5796 | 47 |
1865532 | 1865532 | 2021-10-30 | Union | Arkansas | 5139 | 5796 | 138 |
1855089 | 1855089 | 2021-10-26 | Hill | Texas | 48217 | 5796 | 158 |
1836650 | 1836650 | 2021-10-21 | Wayne | Georgia | 13305 | 5796 | 167 |
1837253 | 1837253 | 2021-10-21 | Iberville | Louisiana | 22047 | 5796 | 124 |
1808978 | 1808978 | 2021-10-12 | Madison | Ohio | 39097 | 5796 | 75 |
1804975 | 1804975 | 2021-10-11 | Itasca | Minnesota | 27061 | 5796 | 76 |
1789928 | 1789928 | 2021-10-06 | Giles | Tennessee | 47055 | 5796 | 114 |
1771102 | 1771102 | 2021-09-30 | Albany | Wyoming | 56001 | 5796 | 28 |
1750521 | 1750521 | 2021-09-24 | Shelby | Ohio | 39149 | 5796 | 104 |
1695022 | 1695022 | 2021-09-07 | Genesee | New York | 36037 | 5796 | 125 |
1695069 | 1695069 | 2021-09-07 | Beaufort | North Carolina | 37013 | 5796 | 108 |
1691329 | 1691329 | 2021-09-06 | Bolivar | Mississippi | 28011 | 5796 | 140 |
1672182 | 1672182 | 2021-08-31 | Elko | Nevada | 32007 | 5796 | 69 |
1669953 | 1669953 | 2021-08-30 | Medina | Texas | 48325 | 5796 | 128 |
1656156 | 1656156 | 2021-08-26 | Richmond | North Carolina | 37153 | 5796 | 114 |
1651138 | 1651138 | 2021-08-25 | Mendocino | California | 6045 | 5796 | 59 |
1601504 | 1601504 | 2021-08-09 | Dyer | Tennessee | 47045 | 5796 | 109 |
1511876 | 1511876 | 2021-07-13 | Coles | Illinois | 17029 | 5796 | 103 |
1495953 | 1495953 | 2021-07-08 | Ford | Kansas | 20057 | 5796 | 76 |
1492707 | 1492707 | 2021-07-07 | Ford | Kansas | 20057 | 5796 | 76 |
1474203 | 1474203 | 2021-07-01 | Wayne | New York | 36117 | 5796 | 71 |
1469672 | 1469672 | 2021-06-30 | Clinton | Illinois | 17027 | 5796 | 100 |
1470957 | 1470957 | 2021-06-30 | Wayne | New York | 36117 | 5796 | 71 |
1441456 | 1441456 | 2021-06-21 | Taney | Missouri | 29213 | 5796 | 97 |
1377864 | 1377864 | 2021-06-01 | Albemarle | Virginia | 51003 | 5796 | 83 |
1249095 | 1249095 | 2021-04-23 | Shelby | Indiana | 18145 | 5796 | 105 |
1247016 | 1247016 | 2021-04-22 | Granville | North Carolina | 37077 | 5796 | 80 |
1241983 | 1241983 | 2021-04-21 | Mississippi | Arkansas | 5093 | 5796 | 107 |
1143088 | 1143088 | 2021-03-21 | Franklin | North Carolina | 37069 | 5796 | 46 |
1139841 | 1139841 | 2021-03-20 | Franklin | North Carolina | 37069 | 5796 | 46 |
1141123 | 1141123 | 2021-03-20 | Waupaca | Wisconsin | 55135 | 5796 | 160 |
1105566 | 1105566 | 2021-03-10 | Crittenden | Arkansas | 5035 | 5796 | 91 |
1105851 | 1105851 | 2021-03-10 | Catoosa | Georgia | 13047 | 5796 | 67 |
1084076 | 1084076 | 2021-03-03 | Kandiyohi | Minnesota | 27067 | 5796 | 74 |
1045099 | 1045099 | 2021-02-19 | Blue Earth | Minnesota | 27013 | 5796 | 34 |
1018502 | 1018502 | 2021-02-11 | Whiteside | Illinois | 17195 | 5796 | 184 |
1015257 | 1015257 | 2021-02-10 | Whiteside | Illinois | 17195 | 5796 | 182 |
1015280 | 1015280 | 2021-02-10 | Dubois | Indiana | 18037 | 5796 | 103 |
1017591 | 1017591 | 2021-02-10 | Rockingham | Virginia | 51165 | 5796 | 76 |
914008 | 914008 | 2021-01-10 | Talladega | Alabama | 1121 | 5796 | 109 |
886623 | 886623 | 2021-01-01 | Saratoga | New York | 36091 | 5796 | 43 |
823386 | 823386 | 2020-12-13 | Litchfield | Connecticut | 9005 | 5796 | 186 |
820140 | 820140 | 2020-12-12 | Litchfield | Connecticut | 9005 | 5796 | 186 |
816894 | 816894 | 2020-12-11 | Litchfield | Connecticut | 9005 | 5796 | 186 |
802937 | 802937 | 2020-12-06 | Madison | Tennessee | 47113 | 5796 | 117 |
745157 | 745157 | 2020-11-18 | Walworth | Wisconsin | 55127 | 5796 | 46 |
735875 | 735875 | 2020-11-16 | Columbia | Georgia | 13073 | 5796 | 73 |
686752 | 686752 | 2020-10-31 | Rock | Wisconsin | 55105 | 5796 | 48 |
608116 | 608116 | 2020-10-07 | Beaufort | South Carolina | 45013 | 5796 | 86 |
466048 | 466048 | 2020-08-24 | McLennan | Texas | 48309 | 5796 | 80 |
179678 | 179678 | 2020-05-26 | Hampden | Massachusetts | 25013 | 5796 | 546 |
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);