ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 7283 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Indiana 7
- Virginia 7
- Louisiana 6
- Alabama 4
- Mississippi 4
- Missouri 3
- New Mexico 3
- Ohio 3
- Wisconsin 3
- Idaho 2
- New York 2
- Pennsylvania 2
- Tennessee 2
- Arkansas 1
- Florida 1
- Iowa 1
- Kentucky 1
- Massachusetts 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- Texas 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475763 | 2475763 | 2022-05-05 | Jefferson | Oregon | 41031 | 7283 | 91 |
2476452 | 2476452 | 2022-05-05 | Amherst | Virginia | 51009 | 7283 | 88 |
2476548 | 2476548 | 2022-05-05 | Pulaski | Virginia | 51155 | 7283 | 138 |
2417900 | 2417900 | 2022-04-17 | Isle of Wight | Virginia | 51093 | 7283 | 115 |
2414644 | 2414644 | 2022-04-16 | Isle of Wight | Virginia | 51093 | 7283 | 115 |
2411388 | 2411388 | 2022-04-15 | Isle of Wight | Virginia | 51093 | 7283 | 115 |
2325324 | 2325324 | 2022-03-20 | Dunklin | Missouri | 29069 | 7283 | 117 |
2322070 | 2322070 | 2022-03-19 | Dunklin | Missouri | 29069 | 7283 | 117 |
2318816 | 2318816 | 2022-03-18 | Dunklin | Missouri | 29069 | 7283 | 117 |
2315213 | 2315213 | 2022-03-17 | West Baton Rouge | Louisiana | 22121 | 7283 | 86 |
2309854 | 2309854 | 2022-03-15 | Warren | Pennsylvania | 42123 | 7283 | 207 |
2282650 | 2282650 | 2022-03-07 | East Feliciana | Louisiana | 22037 | 7283 | 165 |
2279397 | 2279397 | 2022-03-06 | East Feliciana | Louisiana | 22037 | 7283 | 164 |
2276144 | 2276144 | 2022-03-05 | East Feliciana | Louisiana | 22037 | 7283 | 164 |
2272891 | 2272891 | 2022-03-04 | East Feliciana | Louisiana | 22037 | 7283 | 164 |
2256950 | 2256950 | 2022-02-27 | Leflore | Mississippi | 28083 | 7283 | 166 |
2253699 | 2253699 | 2022-02-26 | Leflore | Mississippi | 28083 | 7283 | 166 |
2250448 | 2250448 | 2022-02-25 | Leflore | Mississippi | 28083 | 7283 | 166 |
2247197 | 2247197 | 2022-02-24 | Leflore | Mississippi | 28083 | 7283 | 166 |
2237124 | 2237124 | 2022-02-21 | De Soto | Louisiana | 22031 | 7283 | 131 |
2142431 | 2142431 | 2022-01-23 | Ripley | Indiana | 18137 | 7283 | 119 |
2139176 | 2139176 | 2022-01-22 | Ripley | Indiana | 18137 | 7283 | 119 |
2135920 | 2135920 | 2022-01-21 | Ripley | Indiana | 18137 | 7283 | 119 |
2128412 | 2128412 | 2022-01-18 | Petersburg city | Virginia | 51730 | 7283 | 112 |
2101691 | 2101691 | 2022-01-10 | Perry | Pennsylvania | 42099 | 7283 | 158 |
2086202 | 2086202 | 2022-01-05 | Mason | Washington | 53045 | 7283 | 95 |
2057907 | 2057907 | 2021-12-28 | Whitley | Indiana | 18183 | 7283 | 68 |
2039729 | 2039729 | 2021-12-22 | Mercer | Ohio | 39107 | 7283 | 104 |
1975913 | 1975913 | 2021-12-03 | Tallapoosa | Alabama | 1123 | 7283 | 202 |
1972664 | 1972664 | 2021-12-02 | Tallapoosa | Alabama | 1123 | 7283 | 202 |
1943291 | 1943291 | 2021-11-22 | Monroe | Wisconsin | 55081 | 7283 | 56 |
1783008 | 1783008 | 2021-10-04 | Sandusky | Ohio | 39143 | 7283 | 137 |
1621708 | 1621708 | 2021-08-16 | Coffee | Alabama | 1031 | 7283 | 138 |
1529342 | 1529342 | 2021-07-18 | Valencia | New Mexico | 35061 | 7283 | 119 |
1526095 | 1526095 | 2021-07-17 | Valencia | New Mexico | 35061 | 7283 | 119 |
1522848 | 1522848 | 2021-07-16 | Valencia | New Mexico | 35061 | 7283 | 119 |
1358773 | 1358773 | 2021-05-27 | Walker | Alabama | 1127 | 7283 | 278 |
1357805 | 1357805 | 2021-05-26 | Caguas | Puerto Rico | 72025 | 7283 | |
1315132 | 1315132 | 2021-05-13 | Ontario | New York | 36069 | 7283 | 92 |
1289164 | 1289164 | 2021-05-05 | Oswego | New York | 36075 | 7283 | 90 |
1273494 | 1273494 | 2021-04-30 | Laurens | South Carolina | 45059 | 7283 | 170 |
1232877 | 1232877 | 2021-04-18 | Wayne | Indiana | 18177 | 7283 | 202 |
1164974 | 1164974 | 2021-03-28 | Oldham | Kentucky | 21185 | 7283 | 80 |
1137425 | 1137425 | 2021-03-19 | Liberty | Texas | 48291 | 7283 | 169 |
1102917 | 1102917 | 2021-03-09 | Floyd | Indiana | 18043 | 7283 | 178 |
1075534 | 1075534 | 2021-02-28 | Greene | Tennessee | 47059 | 7283 | 145 |
1069517 | 1069517 | 2021-02-26 | Roanoke | Virginia | 51161 | 7283 | 101 |
1018536 | 1018536 | 2021-02-11 | Hancock | Indiana | 18059 | 7283 | 130 |
977750 | 977750 | 2021-01-29 | Wayne | Ohio | 39169 | 7283 | 172 |
949611 | 949611 | 2021-01-20 | St. Croix | Wisconsin | 55109 | 7283 | 38 |
923827 | 923827 | 2021-01-13 | Jefferson | Arkansas | 5069 | 7283 | 136 |
913799 | 913799 | 2021-01-09 | Berkeley | West Virginia | 54003 | 7283 | 59 |
814216 | 814216 | 2020-12-10 | Story | Iowa | 19169 | 7283 | 21 |
768473 | 768473 | 2020-11-26 | Bonneville | Idaho | 16019 | 7283 | 59 |
765227 | 765227 | 2020-11-25 | Bonneville | Idaho | 16019 | 7283 | 59 |
557057 | 557057 | 2020-09-21 | Waukesha | Wisconsin | 55133 | 7283 | 85 |
501404 | 501404 | 2020-09-04 | Knox | Tennessee | 47093 | 7283 | 64 |
428156 | 428156 | 2020-08-13 | Pasco | Florida | 12101 | 7283 | 141 |
371087 | 371087 | 2020-07-26 | Hampden | Massachusetts | 25013 | 7283 | 687 |
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);