ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 6091 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448675 | 2448675 | 2022-04-27 | Caroline | Maryland | 24011 | 6091 | 80 |
2417917 | 2417917 | 2022-04-17 | Mecklenburg | Virginia | 51117 | 6091 | 119 |
2414661 | 2414661 | 2022-04-16 | Mecklenburg | Virginia | 51117 | 6091 | 119 |
2411405 | 2411405 | 2022-04-15 | Mecklenburg | Virginia | 51117 | 6091 | 119 |
2368491 | 2368491 | 2022-04-02 | Vega Alta | Puerto Rico | 72143 | 6091 | |
2365238 | 2365238 | 2022-04-01 | Vega Alta | Puerto Rico | 72143 | 6091 | |
2335771 | 2335771 | 2022-03-23 | Seminole | Oklahoma | 40133 | 6091 | 129 |
2332517 | 2332517 | 2022-03-22 | Seminole | Oklahoma | 40133 | 6091 | 129 |
2333288 | 2333288 | 2022-03-22 | Hopewell city | Virginia | 51670 | 6091 | 118 |
2327162 | 2327162 | 2022-03-21 | Carroll | Arkansas | 5015 | 6091 | 99 |
2329264 | 2329264 | 2022-03-21 | Seminole | Oklahoma | 40133 | 6091 | 129 |
2330035 | 2330035 | 2022-03-21 | Hopewell city | Virginia | 51670 | 6091 | 118 |
2326012 | 2326012 | 2022-03-20 | Seminole | Oklahoma | 40133 | 6091 | 129 |
2322759 | 2322759 | 2022-03-19 | Seminole | Oklahoma | 40133 | 6091 | 129 |
2319505 | 2319505 | 2022-03-18 | Seminole | Oklahoma | 40133 | 6091 | 129 |
2316251 | 2316251 | 2022-03-17 | Seminole | Oklahoma | 40133 | 6091 | 129 |
2287478 | 2287478 | 2022-03-08 | Gray | Texas | 48179 | 6091 | 122 |
2269000 | 2269000 | 2022-03-03 | Peach | Georgia | 13225 | 6091 | 120 |
2233035 | 2233035 | 2022-02-20 | Routt | Colorado | 8107 | 6091 | 24 |
2229784 | 2229784 | 2022-02-19 | Routt | Colorado | 8107 | 6091 | 24 |
2226533 | 2226533 | 2022-02-18 | Routt | Colorado | 8107 | 6091 | 24 |
2187721 | 2187721 | 2022-02-06 | Stephens | Georgia | 13257 | 6091 | 132 |
2184468 | 2184468 | 2022-02-05 | Stephens | Georgia | 13257 | 6091 | 132 |
2181216 | 2181216 | 2022-02-04 | Stephens | Georgia | 13257 | 6091 | 132 |
2157433 | 2157433 | 2022-01-27 | Kleberg | Texas | 48273 | 6091 | 134 |
2104181 | 2104181 | 2022-01-11 | Lawrence | Missouri | 29109 | 6091 | 141 |
2028043 | 2028043 | 2021-12-19 | Unknown | Arkansas | 6091 | 0 | |
2012460 | 2012460 | 2021-12-14 | Lee | Iowa | 19111 | 6091 | 107 |
2009209 | 2009209 | 2021-12-13 | Lee | Iowa | 19111 | 6091 | 107 |
2005958 | 2005958 | 2021-12-12 | Lee | Iowa | 19111 | 6091 | 107 |
2002707 | 2002707 | 2021-12-11 | Lee | Iowa | 19111 | 6091 | 107 |
1999457 | 1999457 | 2021-12-10 | Lee | Iowa | 19111 | 6091 | 107 |
1996206 | 1996206 | 2021-12-09 | Lee | Iowa | 19111 | 6091 | 107 |
1992955 | 1992955 | 2021-12-08 | Lee | Iowa | 19111 | 6091 | 107 |
1870708 | 1870708 | 2021-10-31 | Logan | Ohio | 39091 | 6091 | 101 |
1802989 | 1802989 | 2021-10-10 | Weakley | Tennessee | 47183 | 6091 | 85 |
1799740 | 1799740 | 2021-10-09 | Weakley | Tennessee | 47183 | 6091 | 85 |
1796491 | 1796491 | 2021-10-08 | Weakley | Tennessee | 47183 | 6091 | 85 |
1789773 | 1789773 | 2021-10-06 | Toa Baja | Puerto Rico | 72137 | 6091 | |
1699457 | 1699457 | 2021-09-08 | Washington | Virginia | 51191 | 6091 | 118 |
1551003 | 1551003 | 2021-07-25 | Shelby | Indiana | 18145 | 6091 | 108 |
1547756 | 1547756 | 2021-07-24 | Shelby | Indiana | 18145 | 6091 | 108 |
1544509 | 1544509 | 2021-07-23 | Shelby | Indiana | 18145 | 6091 | 108 |
1522224 | 1522224 | 2021-07-16 | St. Mary's | Maryland | 24037 | 6091 | 132 |
1458964 | 1458964 | 2021-06-26 | Iron | Utah | 49021 | 6091 | 34 |
1409199 | 1409199 | 2021-06-11 | Salem | New Jersey | 34033 | 6091 | 185 |
1400769 | 1400769 | 2021-06-08 | Harrison | West Virginia | 54033 | 6091 | 79 |
1376493 | 1376493 | 2021-06-01 | Lincoln | Missouri | 29113 | 6091 | 50 |
1373247 | 1373247 | 2021-05-31 | Lincoln | Missouri | 29113 | 6091 | 50 |
1337528 | 1337528 | 2021-05-20 | Joplin | Missouri | 6091 | 108 | |
1300229 | 1300229 | 2021-05-08 | Sauk | Wisconsin | 55111 | 6091 | 54 |
1286195 | 1286195 | 2021-05-04 | Carter | Oklahoma | 40019 | 6091 | 108 |
1282949 | 1282949 | 2021-05-03 | Carter | Oklahoma | 40019 | 6091 | 108 |
1279702 | 1279702 | 2021-05-02 | Carter | Oklahoma | 40019 | 6091 | 108 |
1276455 | 1276455 | 2021-05-01 | Carter | Oklahoma | 40019 | 6091 | 108 |
1273208 | 1273208 | 2021-04-30 | Carter | Oklahoma | 40019 | 6091 | 108 |
1269961 | 1269961 | 2021-04-29 | Carter | Oklahoma | 40019 | 6091 | 108 |
1266714 | 1266714 | 2021-04-28 | Carter | Oklahoma | 40019 | 6091 | 108 |
1196732 | 1196732 | 2021-04-07 | Putnam | Florida | 12107 | 6091 | 136 |
1177971 | 1177971 | 2021-04-01 | Pulaski | Kentucky | 21199 | 6091 | 93 |
1088994 | 1088994 | 2021-03-04 | Rockingham | Virginia | 51165 | 6091 | 94 |
1070490 | 1070490 | 2021-02-27 | Morgan | Indiana | 18109 | 6091 | 130 |
1021637 | 1021637 | 2021-02-12 | Madison | Idaho | 16065 | 6091 | 21 |
1012951 | 1012951 | 2021-02-09 | Lewis and Clark | Montana | 30049 | 6091 | 63 |
978476 | 978476 | 2021-01-29 | Wise | Texas | 48497 | 6091 | 96 |
765447 | 765447 | 2020-11-25 | Vigo | Indiana | 18167 | 6091 | 86 |
697740 | 697740 | 2020-11-04 | Howard | Maryland | 24027 | 6091 | 129 |
672124 | 672124 | 2020-10-27 | Jefferson | Missouri | 29099 | 6091 | 84 |
664701 | 664701 | 2020-10-25 | Champaign | Illinois | 17019 | 6091 | 29 |
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);