ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where cases = 5585 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Michigan 11
- Tennessee 9
- Texas 9
- Mississippi 7
- Illinois 6
- Wisconsin 6
- Washington 5
- Georgia 4
- Minnesota 4
- Virginia 4
- New York 3
- Puerto Rico 3
- Indiana 2
- Kentucky 2
- Maine 2
- Pennsylvania 2
- Utah 2
- Alabama 1
- California 1
- Colorado 1
- Florida 1
- North Carolina 1
- Ohio 1
- Oregon 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497728 | 2497728 | 2022-05-12 | Waseca | Minnesota | 27161 | 5585 | 39 |
2381895 | 2381895 | 2022-04-06 | Moore | Texas | 48341 | 5585 | 111 |
2377087 | 2377087 | 2022-04-05 | Alpena | Michigan | 26007 | 5585 | 136 |
2377212 | 2377212 | 2022-04-05 | Martin | Minnesota | 27091 | 5585 | 64 |
2378640 | 2378640 | 2022-04-05 | Moore | Texas | 48341 | 5585 | 110 |
2373835 | 2373835 | 2022-04-04 | Alpena | Michigan | 26007 | 5585 | 136 |
2375386 | 2375386 | 2022-04-04 | Moore | Texas | 48341 | 5585 | 110 |
2370582 | 2370582 | 2022-04-03 | Alpena | Michigan | 26007 | 5585 | 136 |
2370759 | 2370759 | 2022-04-03 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2367329 | 2367329 | 2022-04-02 | Alpena | Michigan | 26007 | 5585 | 136 |
2367506 | 2367506 | 2022-04-02 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2364076 | 2364076 | 2022-04-01 | Alpena | Michigan | 26007 | 5585 | 136 |
2364253 | 2364253 | 2022-04-01 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2360999 | 2360999 | 2022-03-31 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2357745 | 2357745 | 2022-03-30 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2354492 | 2354492 | 2022-03-29 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2351240 | 2351240 | 2022-03-28 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2292455 | 2292455 | 2022-03-10 | Franklin | Maine | 23007 | 5585 | 56 |
2246933 | 2246933 | 2022-02-24 | Knox | Maine | 23013 | 5585 | 25 |
2213162 | 2213162 | 2022-02-13 | Jackson | Wisconsin | 55053 | 5585 | 41 |
2209909 | 2209909 | 2022-02-12 | Jackson | Wisconsin | 55053 | 5585 | 41 |
2206656 | 2206656 | 2022-02-11 | Jackson | Wisconsin | 55053 | 5585 | 41 |
2127623 | 2127623 | 2022-01-18 | Columbia | Oregon | 41009 | 5585 | 66 |
2122655 | 2122655 | 2022-01-17 | Sumter | Georgia | 13261 | 5585 | 145 |
2105205 | 2105205 | 2022-01-11 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2101954 | 2101954 | 2022-01-10 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2098703 | 2098703 | 2022-01-09 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2095451 | 2095451 | 2022-01-08 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2092199 | 2092199 | 2022-01-07 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2088947 | 2088947 | 2022-01-06 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2085696 | 2085696 | 2022-01-05 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2082444 | 2082444 | 2022-01-04 | Lauderdale | Tennessee | 47097 | 5585 | 79 |
2062687 | 2062687 | 2021-12-29 | Warren | Pennsylvania | 42123 | 5585 | 179 |
2053705 | 2053705 | 2021-12-26 | Stevens | Washington | 53065 | 5585 | 109 |
2050455 | 2050455 | 2021-12-25 | Stevens | Washington | 53065 | 5585 | 109 |
2047205 | 2047205 | 2021-12-24 | Stevens | Washington | 53065 | 5585 | 109 |
2043955 | 2043955 | 2021-12-23 | Stevens | Washington | 53065 | 5585 | 109 |
1998258 | 1998258 | 2021-12-09 | Uintah | Utah | 49047 | 5585 | 54 |
1930291 | 1930291 | 2021-11-18 | Oneida | Wisconsin | 55085 | 5585 | 94 |
1924892 | 1924892 | 2021-11-17 | Harlan | Kentucky | 21095 | 5585 | 133 |
1917956 | 1917956 | 2021-11-15 | Christian | Illinois | 17021 | 5585 | 101 |
1913159 | 1913159 | 2021-11-13 | Perry | Pennsylvania | 42099 | 5585 | 130 |
1869281 | 1869281 | 2021-10-31 | Randolph | Illinois | 17157 | 5585 | 108 |
1866032 | 1866032 | 2021-10-30 | Randolph | Illinois | 17157 | 5585 | 108 |
1862783 | 1862783 | 2021-10-29 | Randolph | Illinois | 17157 | 5585 | 108 |
1837198 | 1837198 | 2021-10-21 | Muhlenberg | Kentucky | 21177 | 5585 | 88 |
1825501 | 1825501 | 2021-10-17 | Ponce | Puerto Rico | 72113 | 5585 | |
1781646 | 1781646 | 2021-10-04 | Putnam | Indiana | 18133 | 5585 | 73 |
1783724 | 1783724 | 2021-10-04 | Titus | Texas | 48449 | 5585 | 98 |
1783983 | 1783983 | 2021-10-04 | Fayette | West Virginia | 54019 | 5585 | 105 |
1780475 | 1780475 | 2021-10-03 | Titus | Texas | 48449 | 5585 | 98 |
1777225 | 1777225 | 2021-10-02 | Titus | Texas | 48449 | 5585 | 98 |
1764446 | 1764446 | 2021-09-28 | Douglas | Washington | 53017 | 5585 | 31 |
1758834 | 1758834 | 2021-09-27 | Woodford | Illinois | 17203 | 5585 | 104 |
1733994 | 1733994 | 2021-09-19 | Clinton | New York | 36019 | 5585 | 34 |
1690111 | 1690111 | 2021-09-06 | Lake | California | 6033 | 5585 | 78 |
1677314 | 1677314 | 2021-09-02 | Bryan | Georgia | 13029 | 5585 | 43 |
1656717 | 1656717 | 2021-08-26 | Cocke | Tennessee | 47029 | 5585 | 103 |
1643046 | 1643046 | 2021-08-22 | Genesee | New York | 36037 | 5585 | 124 |
1403799 | 1403799 | 2021-06-09 | Summit | Utah | 49043 | 5585 | 13 |
1393565 | 1393565 | 2021-06-06 | Unknown | Puerto Rico | 5585 | 2518 | |
1394183 | 1394183 | 2021-06-06 | Pittsylvania | Virginia | 51143 | 5585 | 82 |
1390320 | 1390320 | 2021-06-05 | Unknown | Puerto Rico | 5585 | 2516 | |
1390938 | 1390938 | 2021-06-05 | Pittsylvania | Virginia | 51143 | 5585 | 82 |
1356721 | 1356721 | 2021-05-26 | Chippewa | Michigan | 26033 | 5585 | 49 |
1353475 | 1353475 | 2021-05-25 | Chippewa | Michigan | 26033 | 5585 | 49 |
1333382 | 1333382 | 2021-05-19 | Knox | Illinois | 17095 | 5585 | 181 |
1327493 | 1327493 | 2021-05-17 | Branch | Michigan | 26023 | 5585 | 120 |
1324314 | 1324314 | 2021-05-16 | Tuscola | Michigan | 26157 | 5585 | 168 |
1321068 | 1321068 | 2021-05-15 | Tuscola | Michigan | 26157 | 5585 | 168 |
1284514 | 1284514 | 2021-05-04 | Laurens | Georgia | 13175 | 5585 | 167 |
1281267 | 1281267 | 2021-05-03 | Laurens | Georgia | 13175 | 5585 | 167 |
1241302 | 1241302 | 2021-04-20 | Hardin | Texas | 48199 | 5585 | 109 |
1161385 | 1161385 | 2021-03-27 | Marshall | Indiana | 18099 | 5585 | 108 |
1151154 | 1151154 | 2021-03-24 | Eagle | Colorado | 8037 | 5585 | 22 |
1077510 | 1077510 | 2021-03-01 | Lapeer | Michigan | 26087 | 5585 | 129 |
1045829 | 1045829 | 2021-02-19 | Ashtabula | Ohio | 39007 | 5585 | 137 |
1037012 | 1037012 | 2021-02-16 | Harrisonburg city | Virginia | 51660 | 5585 | 68 |
1037250 | 1037250 | 2021-02-16 | Waupaca | Wisconsin | 55135 | 5585 | 155 |
991625 | 991625 | 2021-02-02 | Rockingham | Virginia | 51165 | 5585 | 74 |
975093 | 975093 | 2021-01-28 | Hood | Texas | 48221 | 5585 | 96 |
889942 | 889942 | 2021-01-02 | Lincoln | North Carolina | 37109 | 5585 | 20 |
806315 | 806315 | 2020-12-07 | Gregg | Texas | 48183 | 5585 | 117 |
691896 | 691896 | 2020-11-02 | Dutchess | New York | 36027 | 5585 | 166 |
625528 | 625528 | 2020-10-13 | Santa Rosa | Florida | 12113 | 5585 | 82 |
589444 | 589444 | 2020-10-01 | Racine | Wisconsin | 55101 | 5585 | 98 |
474315 | 474315 | 2020-08-27 | Dakota | Minnesota | 27037 | 5585 | 110 |
421385 | 421385 | 2020-08-11 | Madison | Alabama | 1089 | 5585 | 39 |
345605 | 345605 | 2020-07-18 | Ramsey | Minnesota | 27123 | 5585 | 247 |
324278 | 324278 | 2020-07-11 | Horry | South Carolina | 45051 | 5585 | 72 |
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);