ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where cases = 5864 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Tennessee 8
- Minnesota 6
- Texas 6
- Georgia 5
- Arizona 4
- Pennsylvania 4
- Arkansas 3
- Missouri 3
- Ohio 3
- South Carolina 3
- Virginia 3
- Wyoming 3
- Alabama 2
- Mississippi 2
- New York 2
- North Carolina 2
- West Virginia 2
- Florida 1
- Indiana 1
- Louisiana 1
- Michigan 1
- Puerto Rico 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2437153 | 2437153 | 2022-04-23 | Frio | Texas | 48163 | 5864 | 93 |
2265689 | 2265689 | 2022-03-02 | Emanuel | Georgia | 13107 | 5864 | 151 |
2262438 | 2262438 | 2022-03-01 | Emanuel | Georgia | 13107 | 5864 | 151 |
2259187 | 2259187 | 2022-02-28 | Emanuel | Georgia | 13107 | 5864 | 151 |
2261189 | 2261189 | 2022-02-28 | Jasper | South Carolina | 45053 | 5864 | 92 |
2182264 | 2182264 | 2022-02-04 | Miller | Missouri | 29131 | 5864 | 105 |
2157827 | 2157827 | 2022-01-27 | Wyoming | West Virginia | 54109 | 5864 | 81 |
2133372 | 2133372 | 2022-01-20 | Scott | Mississippi | 28123 | 5864 | 101 |
2133992 | 2133992 | 2022-01-20 | Henry | Ohio | 39069 | 5864 | 93 |
2125252 | 2125252 | 2022-01-17 | Hancock | West Virginia | 54029 | 5864 | 127 |
2106310 | 2106310 | 2022-01-12 | Dawson | Georgia | 13085 | 5864 | 82 |
2107263 | 2107263 | 2022-01-12 | Pine | Minnesota | 27115 | 5864 | 55 |
2087749 | 2087749 | 2022-01-06 | Nicollet | Minnesota | 27103 | 5864 | 62 |
2027870 | 2027870 | 2021-12-19 | Chambers | Alabama | 1017 | 5864 | 145 |
2010482 | 2010482 | 2021-12-13 | Ottawa | Ohio | 39123 | 5864 | 104 |
1994968 | 1994968 | 2021-12-08 | Washington | Texas | 48477 | 5864 | 133 |
1985595 | 1985595 | 2021-12-05 | Sheridan | Wyoming | 56033 | 5864 | 57 |
1982345 | 1982345 | 2021-12-04 | Sheridan | Wyoming | 56033 | 5864 | 57 |
1979095 | 1979095 | 2021-12-03 | Sheridan | Wyoming | 56033 | 5864 | 57 |
1971341 | 1971341 | 2021-12-01 | Scotland | North Carolina | 37165 | 5864 | 109 |
1962138 | 1962138 | 2021-11-28 | Carroll | Tennessee | 47017 | 5864 | 111 |
1958887 | 1958887 | 2021-11-27 | Carroll | Tennessee | 47017 | 5864 | 111 |
1955636 | 1955636 | 2021-11-26 | Carroll | Tennessee | 47017 | 5864 | 111 |
1952385 | 1952385 | 2021-11-25 | Carroll | Tennessee | 47017 | 5864 | 111 |
1949134 | 1949134 | 2021-11-24 | Carroll | Tennessee | 47017 | 5864 | 111 |
1945883 | 1945883 | 2021-11-23 | Carroll | Tennessee | 47017 | 5864 | 110 |
1917524 | 1917524 | 2021-11-15 | Union | Arkansas | 5139 | 5864 | 141 |
1898987 | 1898987 | 2021-11-09 | Evangeline | Louisiana | 22039 | 5864 | 141 |
1829530 | 1829530 | 2021-10-18 | Douglas | Wisconsin | 55031 | 5864 | 66 |
1785612 | 1785612 | 2021-10-05 | Union | Mississippi | 28145 | 5864 | 93 |
1780585 | 1780585 | 2021-10-03 | Danville city | Virginia | 51590 | 5864 | 168 |
1777335 | 1777335 | 2021-10-02 | Danville city | Virginia | 51590 | 5864 | 168 |
1774085 | 1774085 | 2021-10-01 | Danville city | Virginia | 51590 | 5864 | 168 |
1760911 | 1760911 | 2021-09-27 | Matagorda | Texas | 48321 | 5864 | 144 |
1740217 | 1740217 | 2021-09-21 | Phelps | Missouri | 29161 | 5864 | 171 |
1683428 | 1683428 | 2021-09-04 | Covington | Alabama | 1039 | 5864 | 150 |
1646564 | 1646564 | 2021-08-23 | Sandusky | Ohio | 39143 | 5864 | 131 |
1628286 | 1628286 | 2021-08-18 | Graham | Arizona | 4009 | 5864 | 89 |
1605102 | 1605102 | 2021-08-10 | Summit | Utah | 49043 | 5864 | 15 |
1581036 | 1581036 | 2021-08-03 | Pettis | Missouri | 29159 | 5864 | 80 |
1574862 | 1574862 | 2021-08-01 | Wayne | New York | 36117 | 5864 | 73 |
1454214 | 1454214 | 2021-06-25 | Otter Tail | Minnesota | 27111 | 5864 | 84 |
1450969 | 1450969 | 2021-06-24 | Otter Tail | Minnesota | 27111 | 5864 | 84 |
1447723 | 1447723 | 2021-06-23 | Otter Tail | Minnesota | 27111 | 5864 | 84 |
1396692 | 1396692 | 2021-06-07 | Columbia | Pennsylvania | 42037 | 5864 | 133 |
1393445 | 1393445 | 2021-06-06 | Columbia | Pennsylvania | 42037 | 5864 | 133 |
1390200 | 1390200 | 2021-06-05 | Columbia | Pennsylvania | 42037 | 5864 | 133 |
1319905 | 1319905 | 2021-05-15 | Mississippi | Arkansas | 5093 | 5864 | 108 |
1316658 | 1316658 | 2021-05-14 | Mississippi | Arkansas | 5093 | 5864 | 108 |
1293258 | 1293258 | 2021-05-06 | Henderson | Texas | 48213 | 5864 | 185 |
1290012 | 1290012 | 2021-05-05 | Henderson | Texas | 48213 | 5864 | 184 |
1286766 | 1286766 | 2021-05-04 | Henderson | Texas | 48213 | 5864 | 184 |
1204749 | 1204749 | 2021-04-09 | Sullivan | New York | 36105 | 5864 | 68 |
1194406 | 1194406 | 2021-04-06 | Midland | Michigan | 26111 | 5864 | 71 |
1153470 | 1153470 | 2021-03-24 | Loudon | Tennessee | 47105 | 5864 | 68 |
981404 | 981404 | 2021-01-30 | Gibson | Tennessee | 47053 | 5864 | 122 |
937012 | 937012 | 2021-01-17 | Highlands | Florida | 12055 | 5864 | 232 |
932490 | 932490 | 2021-01-15 | Somerset | Pennsylvania | 42111 | 5864 | 132 |
908186 | 908186 | 2021-01-08 | Grant | Indiana | 18053 | 5864 | 111 |
834155 | 834155 | 2020-12-16 | Clay | Minnesota | 27027 | 5864 | 69 |
835159 | 835159 | 2020-12-16 | Carolina | Puerto Rico | 72031 | 5864 | |
803699 | 803699 | 2020-12-07 | Apache | Arizona | 4001 | 5864 | 200 |
800454 | 800454 | 2020-12-06 | Apache | Arizona | 4001 | 5864 | 200 |
734120 | 734120 | 2020-11-15 | Cabarrus | North Carolina | 37025 | 5864 | 101 |
712840 | 712840 | 2020-11-09 | Coconino | Arizona | 4005 | 5864 | 151 |
650289 | 650289 | 2020-10-20 | Berkeley | South Carolina | 45015 | 5864 | 93 |
551103 | 551103 | 2020-09-20 | Muscogee | Georgia | 13215 | 5864 | 163 |
305236 | 305236 | 2020-07-05 | Greenville | South Carolina | 45045 | 5864 | 87 |
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);