ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5206 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 13
- North Carolina 10
- Arizona 7
- South Dakota 4
- Georgia 3
- Illinois 3
- Kentucky 3
- Missouri 3
- New York 3
- Texas 3
- Kansas 2
- Michigan 2
- North Dakota 2
- Ohio 2
- Pennsylvania 2
- Wisconsin 2
- Alabama 1
- Hawaii 1
- Indiana 1
- Louisiana 1
- Maine 1
- Maryland 1
- Minnesota 1
- Nebraska 1
- New Jersey 1
- New Mexico 1
- Puerto Rico 1
- South Carolina 1
- Utah 1
- Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444310 | 2444310 | 2022-04-26 | La Paz | Arizona | 4012 | 5206 | 143 |
2441054 | 2441054 | 2022-04-25 | La Paz | Arizona | 4012 | 5206 | 143 |
2437798 | 2437798 | 2022-04-24 | La Paz | Arizona | 4012 | 5206 | 143 |
2434542 | 2434542 | 2022-04-23 | La Paz | Arizona | 4012 | 5206 | 143 |
2431286 | 2431286 | 2022-04-22 | La Paz | Arizona | 4012 | 5206 | 143 |
2428030 | 2428030 | 2022-04-21 | La Paz | Arizona | 4012 | 5206 | 143 |
2424774 | 2424774 | 2022-04-20 | La Paz | Arizona | 4012 | 5206 | 143 |
2427866 | 2427866 | 2022-04-20 | Langlade | Wisconsin | 55067 | 5206 | 90 |
2396594 | 2396594 | 2022-04-11 | Somerset | Maryland | 24039 | 5206 | 73 |
2339986 | 2339986 | 2022-03-24 | Iowa | Wisconsin | 55049 | 5206 | 26 |
2289936 | 2289936 | 2022-03-09 | Caswell | North Carolina | 37033 | 5206 | 44 |
2178639 | 2178639 | 2022-02-03 | Hancock | Maine | 23009 | 5206 | 71 |
2168192 | 2168192 | 2022-01-31 | Pierce | Georgia | 13229 | 5206 | 108 |
2169528 | 2169528 | 2022-01-31 | San Miguel | New Mexico | 35047 | 5206 | 46 |
2156715 | 2156715 | 2022-01-27 | Rolette | North Dakota | 38079 | 5206 | 39 |
2150075 | 2150075 | 2022-01-25 | Ashe | North Carolina | 37009 | 5206 | 66 |
2131171 | 2131171 | 2022-01-19 | Yankton | South Dakota | 46135 | 5206 | 47 |
2084810 | 2084810 | 2022-01-05 | Dakota | Nebraska | 31043 | 5206 | 82 |
2081131 | 2081131 | 2022-01-04 | Dickinson | Michigan | 26043 | 5206 | 93 |
2081918 | 2081918 | 2022-01-04 | Stutsman | North Dakota | 38093 | 5206 | 92 |
2077879 | 2077879 | 2022-01-03 | Dickinson | Michigan | 26043 | 5206 | 93 |
2040917 | 2040917 | 2021-12-23 | Pike | Alabama | 1109 | 5206 | 111 |
1906813 | 1906813 | 2021-11-11 | Brookings | South Dakota | 46011 | 5206 | 39 |
1903564 | 1903564 | 2021-11-10 | Brookings | South Dakota | 46011 | 5206 | 39 |
1896445 | 1896445 | 2021-11-08 | Allegany | New York | 36003 | 5206 | 106 |
1893247 | 1893247 | 2021-11-07 | Washington | New York | 36115 | 5206 | 71 |
1879902 | 1879902 | 2021-11-03 | Lawrence | Missouri | 29109 | 5206 | 106 |
1874427 | 1874427 | 2021-11-01 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1871178 | 1871178 | 2021-10-31 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1867929 | 1867929 | 2021-10-30 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1864680 | 1864680 | 2021-10-29 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1841671 | 1841671 | 2021-10-22 | Perry | Pennsylvania | 42099 | 5206 | 119 |
1795422 | 1795422 | 2021-10-08 | Laclede | Missouri | 29105 | 5206 | 126 |
1789913 | 1789913 | 2021-10-06 | Claiborne | Tennessee | 47025 | 5206 | 90 |
1786215 | 1786215 | 2021-10-05 | Guernsey | Ohio | 39059 | 5206 | 67 |
1711388 | 1711388 | 2021-09-12 | Stokes | North Carolina | 37169 | 5206 | 84 |
1708141 | 1708141 | 2021-09-11 | Stokes | North Carolina | 37169 | 5206 | 84 |
1708540 | 1708540 | 2021-09-11 | Ponce | Puerto Rico | 72113 | 5206 | |
1704894 | 1704894 | 2021-09-10 | Stokes | North Carolina | 37169 | 5206 | 84 |
1654879 | 1654879 | 2021-08-26 | Woodford | Illinois | 17203 | 5206 | 97 |
1653507 | 1653507 | 2021-08-25 | Lincoln | Tennessee | 47103 | 5206 | 71 |
1650260 | 1650260 | 2021-08-24 | Lincoln | Tennessee | 47103 | 5206 | 71 |
1606557 | 1606557 | 2021-08-11 | Shelby | Kentucky | 21211 | 5206 | 79 |
1574912 | 1574912 | 2021-08-01 | Hoke | North Carolina | 37093 | 5206 | 56 |
1571664 | 1571664 | 2021-07-31 | Hoke | North Carolina | 37093 | 5206 | 56 |
1568416 | 1568416 | 2021-07-30 | Hoke | North Carolina | 37093 | 5206 | 56 |
1563773 | 1563773 | 2021-07-29 | Maui | Hawaii | 15009 | 5206 | 60 |
1491332 | 1491332 | 2021-07-06 | Nacogdoches | Texas | 48347 | 5206 | 174 |
1488085 | 1488085 | 2021-07-05 | Nacogdoches | Texas | 48347 | 5206 | 174 |
1484838 | 1484838 | 2021-07-04 | Nacogdoches | Texas | 48347 | 5206 | 174 |
1470923 | 1470923 | 2021-06-30 | Herkimer | New York | 36043 | 5206 | 109 |
1471607 | 1471607 | 2021-06-30 | Fayette | Tennessee | 47047 | 5206 | 83 |
1452137 | 1452137 | 2021-06-24 | Fayette | Tennessee | 47047 | 5206 | 85 |
1439156 | 1439156 | 2021-06-20 | Fayette | Tennessee | 47047 | 5206 | 86 |
1435909 | 1435909 | 2021-06-19 | Fayette | Tennessee | 47047 | 5206 | 86 |
1432662 | 1432662 | 2021-06-18 | Fayette | Tennessee | 47047 | 5206 | 86 |
1401360 | 1401360 | 2021-06-09 | Habersham | Georgia | 13137 | 5206 | 161 |
1378031 | 1378031 | 2021-06-01 | Walla Walla | Washington | 53071 | 5206 | 66 |
1285999 | 1285999 | 2021-05-04 | McDowell | North Carolina | 37111 | 5206 | 63 |
1246678 | 1246678 | 2021-04-22 | Taney | Missouri | 29213 | 5206 | 92 |
1241458 | 1241458 | 2021-04-20 | Box Elder | Utah | 49003 | 5206 | 50 |
1223520 | 1223520 | 2021-04-15 | Vermilion | Louisiana | 22113 | 5206 | 116 |
1120890 | 1120890 | 2021-03-14 | Brown | South Dakota | 46013 | 5206 | 89 |
1096797 | 1096797 | 2021-03-07 | Pike | Kentucky | 21195 | 5206 | 60 |
1080814 | 1080814 | 2021-03-02 | Crow Wing | Minnesota | 27035 | 5206 | 81 |
1082402 | 1082402 | 2021-03-02 | Augusta | Virginia | 51015 | 5206 | 61 |
1046190 | 1046190 | 2021-02-19 | Cherokee | South Carolina | 45021 | 5206 | 129 |
979626 | 979626 | 2021-01-30 | Shelby | Indiana | 18145 | 5206 | 92 |
971116 | 971116 | 2021-01-27 | Wilkes | North Carolina | 37193 | 5206 | 90 |
922528 | 922528 | 2021-01-12 | Hancock | Ohio | 39063 | 5206 | 88 |
898325 | 898325 | 2021-01-05 | Boone | Illinois | 17007 | 5206 | 73 |
898644 | 898644 | 2021-01-05 | Ford | Kansas | 20057 | 5206 | 10 |
895399 | 895399 | 2021-01-04 | Ford | Kansas | 20057 | 5206 | 10 |
864577 | 864577 | 2020-12-25 | Greene | Tennessee | 47059 | 5206 | 88 |
848103 | 848103 | 2020-12-20 | Monroe | Pennsylvania | 42089 | 5206 | 186 |
837134 | 837134 | 2020-12-17 | Madison | Kentucky | 21151 | 5206 | 25 |
742629 | 742629 | 2020-11-18 | Tazewell | Illinois | 17179 | 5206 | 74 |
674303 | 674303 | 2020-10-28 | Lowndes | Georgia | 13185 | 5206 | 85 |
288810 | 288810 | 2020-06-30 | Burlington | New Jersey | 34005 | 5206 | 424 |
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);