ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where cases = 5552 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Louisiana 9
- Virginia 8
- North Carolina 6
- Ohio 6
- Alabama 5
- Idaho 5
- Minnesota 5
- Kansas 4
- Texas 4
- Indiana 3
- Oklahoma 3
- Pennsylvania 3
- Arkansas 2
- California 2
- Colorado 2
- Kentucky 2
- Michigan 2
- New York 2
- Tennessee 2
- Arizona 1
- Mississippi 1
- Missouri 1
- New Mexico 1
- Puerto Rico 1
- South Carolina 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495449 | 2495449 | 2022-05-11 | Morovis | Puerto Rico | 72101 | 5552 | |
2438291 | 2438291 | 2022-04-24 | Payette | Idaho | 16075 | 5552 | 86 |
2435035 | 2435035 | 2022-04-23 | Payette | Idaho | 16075 | 5552 | 86 |
2431779 | 2431779 | 2022-04-22 | Payette | Idaho | 16075 | 5552 | 86 |
2347688 | 2347688 | 2022-03-27 | Assumption | Louisiana | 22007 | 5552 | 69 |
2347970 | 2347970 | 2022-03-27 | Wabasha | Minnesota | 27157 | 5552 | 16 |
2344435 | 2344435 | 2022-03-26 | Assumption | Louisiana | 22007 | 5552 | 69 |
2344717 | 2344717 | 2022-03-26 | Wabasha | Minnesota | 27157 | 5552 | 16 |
2341182 | 2341182 | 2022-03-25 | Assumption | Louisiana | 22007 | 5552 | 69 |
2341464 | 2341464 | 2022-03-25 | Wabasha | Minnesota | 27157 | 5552 | 16 |
2337093 | 2337093 | 2022-03-24 | Morgan | Colorado | 8087 | 5552 | 135 |
2337929 | 2337929 | 2022-03-24 | Assumption | Louisiana | 22007 | 5552 | 69 |
2334675 | 2334675 | 2022-03-23 | Assumption | Louisiana | 22007 | 5552 | 69 |
2331421 | 2331421 | 2022-03-22 | Assumption | Louisiana | 22007 | 5552 | 69 |
2328169 | 2328169 | 2022-03-21 | Assumption | Louisiana | 22007 | 5552 | 69 |
2292534 | 2292534 | 2022-03-10 | Gladwin | Michigan | 26051 | 5552 | 110 |
2289282 | 2289282 | 2022-03-09 | Gladwin | Michigan | 26051 | 5552 | 110 |
2267881 | 2267881 | 2022-03-02 | Austin | Texas | 48015 | 5552 | 71 |
2243836 | 2243836 | 2022-02-23 | Dodge | Minnesota | 27039 | 5552 | 20 |
2215920 | 2215920 | 2022-02-14 | Dimmit | Texas | 48127 | 5552 | 50 |
2206836 | 2206836 | 2022-02-12 | Arkansas | Arkansas | 5001 | 5552 | 72 |
2196895 | 2196895 | 2022-02-08 | Jackson | Wisconsin | 55053 | 5552 | 41 |
2157953 | 2157953 | 2022-01-28 | Geneva | Alabama | 1061 | 5552 | 141 |
2154700 | 2154700 | 2022-01-27 | Geneva | Alabama | 1061 | 5552 | 141 |
2154814 | 2154814 | 2022-01-27 | Jackson | Arkansas | 5067 | 5552 | 49 |
2151447 | 2151447 | 2022-01-26 | Geneva | Alabama | 1061 | 5552 | 141 |
2153410 | 2153410 | 2022-01-26 | Transylvania | North Carolina | 37175 | 5552 | 57 |
2148195 | 2148195 | 2022-01-25 | Geneva | Alabama | 1061 | 5552 | 141 |
2144943 | 2144943 | 2022-01-24 | Geneva | Alabama | 1061 | 5552 | 141 |
2128448 | 2128448 | 2022-01-18 | Winchester city | Virginia | 51840 | 5552 | 59 |
2009940 | 2009940 | 2021-12-13 | Polk | Missouri | 29167 | 5552 | 80 |
2004593 | 2004593 | 2021-12-11 | Hopkins | Texas | 48223 | 5552 | 148 |
1986307 | 1986307 | 2021-12-06 | Adams | Indiana | 18001 | 5552 | 82 |
1985303 | 1985303 | 2021-12-05 | Charlottesville city | Virginia | 51540 | 5552 | 62 |
1982053 | 1982053 | 2021-12-04 | Charlottesville city | Virginia | 51540 | 5552 | 62 |
1978803 | 1978803 | 2021-12-03 | Charlottesville city | Virginia | 51540 | 5552 | 62 |
1964930 | 1964930 | 2021-11-29 | Coshocton | Ohio | 39031 | 5552 | 103 |
1893477 | 1893477 | 2021-11-07 | Putnam | Ohio | 39137 | 5552 | 112 |
1837022 | 1837022 | 2021-10-21 | Cowley | Kansas | 20035 | 5552 | 124 |
1833773 | 1833773 | 2021-10-20 | Cowley | Kansas | 20035 | 5552 | 124 |
1835187 | 1835187 | 2021-10-20 | Wayne | Pennsylvania | 42127 | 5552 | 104 |
1813644 | 1813644 | 2021-10-14 | La Plata | Colorado | 8067 | 5552 | 52 |
1780734 | 1780734 | 2021-10-03 | Fayette | West Virginia | 54019 | 5552 | 104 |
1763488 | 1763488 | 2021-09-28 | Madison | Ohio | 39097 | 5552 | 71 |
1757921 | 1757921 | 2021-09-26 | Shenandoah | Virginia | 51171 | 5552 | 144 |
1754673 | 1754673 | 2021-09-25 | Shenandoah | Virginia | 51171 | 5552 | 144 |
1751425 | 1751425 | 2021-09-24 | Shenandoah | Virginia | 51171 | 5552 | 144 |
1677648 | 1677648 | 2021-09-02 | Huntington | Indiana | 18069 | 5552 | 89 |
1675123 | 1675123 | 2021-09-01 | Marshall | Mississippi | 28093 | 5552 | 114 |
1646739 | 1646739 | 2021-08-23 | Mifflin | Pennsylvania | 42087 | 5552 | 183 |
1610779 | 1610779 | 2021-08-12 | Darke | Ohio | 39037 | 5552 | 131 |
1566297 | 1566297 | 2021-07-29 | Lewis | Washington | 53041 | 5552 | 83 |
1557827 | 1557827 | 2021-07-27 | Scott | Kentucky | 21209 | 5552 | 36 |
1533294 | 1533294 | 2021-07-19 | Dyer | Tennessee | 47045 | 5552 | 108 |
1445070 | 1445070 | 2021-06-22 | Pender | North Carolina | 37141 | 5552 | 67 |
1379349 | 1379349 | 2021-06-02 | St. Charles | Louisiana | 22089 | 5552 | 97 |
1354833 | 1354833 | 2021-05-25 | Warren | Tennessee | 47177 | 5552 | 82 |
1312108 | 1312108 | 2021-05-12 | Jefferson | Ohio | 39081 | 5552 | 151 |
1298119 | 1298119 | 2021-05-08 | Pike | Kentucky | 21195 | 5552 | 96 |
1292474 | 1292474 | 2021-05-06 | Halifax | North Carolina | 37083 | 5552 | 110 |
1280890 | 1280890 | 2021-05-03 | Graham | Arizona | 4009 | 5552 | 78 |
1259443 | 1259443 | 2021-04-26 | Otter Tail | Minnesota | 27111 | 5552 | 73 |
1156767 | 1156767 | 2021-03-25 | Atascosa | Texas | 48013 | 5552 | 145 |
1132129 | 1132129 | 2021-03-18 | Dearborn | Indiana | 18029 | 5552 | 75 |
1123626 | 1123626 | 2021-03-15 | Lee | North Carolina | 37105 | 5552 | 73 |
1100884 | 1100884 | 2021-03-08 | Franklin | North Carolina | 37069 | 5552 | 45 |
1057675 | 1057675 | 2021-02-23 | Ford | Kansas | 20057 | 5552 | 10 |
1054429 | 1054429 | 2021-02-22 | Ford | Kansas | 20057 | 5552 | 10 |
1013467 | 1013467 | 2021-02-09 | Bryan | Oklahoma | 40013 | 5552 | 51 |
964718 | 964718 | 2021-01-25 | Hancock | Ohio | 39063 | 5552 | 92 |
915792 | 915792 | 2021-01-10 | Valencia | New Mexico | 35061 | 5552 | 70 |
886947 | 886947 | 2021-01-01 | Pottawatomie | Oklahoma | 40125 | 5552 | 37 |
883702 | 883702 | 2020-12-31 | Pottawatomie | Oklahoma | 40125 | 5552 | 37 |
861083 | 861083 | 2020-12-24 | Monroe | Pennsylvania | 42089 | 5552 | 189 |
823634 | 823634 | 2020-12-13 | Bannock | Idaho | 16005 | 5552 | 45 |
820388 | 820388 | 2020-12-12 | Bannock | Idaho | 16005 | 5552 | 45 |
669769 | 669769 | 2020-10-26 | Florence | South Carolina | 45041 | 5552 | 201 |
503937 | 503937 | 2020-09-05 | Monroe | New York | 36055 | 5552 | 258 |
489374 | 489374 | 2020-09-01 | Solano | California | 6095 | 5552 | 47 |
446890 | 446890 | 2020-08-18 | Loudoun | Virginia | 51107 | 5552 | 115 |
438630 | 438630 | 2020-08-16 | St. Tammany | Louisiana | 22103 | 5552 | 220 |
439385 | 439385 | 2020-08-16 | Forsyth | North Carolina | 37067 | 5552 | 56 |
312591 | 312591 | 2020-07-08 | Santa Clara | California | 6085 | 5552 | 166 |
171099 | 171099 | 2020-05-23 | Erie | New York | 36029 | 5552 | 479 |
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);