ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where deaths = 1191 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Louisiana 10
- Illinois 8
- New Jersey 8
- Oregon 5
- Texas 5
- California 3
- Massachusetts 3
- Pennsylvania 3
- Florida 2
- South Carolina 2
- Washington 2
- Colorado 1
- District of Columbia 1
- Maryland 1
- Michigan 1
- New York 1
- Ohio 1
- Puerto Rico 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423677 | 2423677 | 2022-04-19 | Multnomah | Oregon | 41051 | 115725 | 1191 |
2420420 | 2420420 | 2022-04-18 | Multnomah | Oregon | 41051 | 114945 | 1191 |
2417165 | 2417165 | 2022-04-17 | Multnomah | Oregon | 41051 | 114945 | 1191 |
2413909 | 2413909 | 2022-04-16 | Multnomah | Oregon | 41051 | 114945 | 1191 |
2410653 | 2410653 | 2022-04-15 | Multnomah | Oregon | 41051 | 114945 | 1191 |
2328840 | 2328840 | 2022-03-21 | Burlington | New Jersey | 34005 | 101489 | 1191 |
2280963 | 2280963 | 2022-03-06 | Fort Bend | Texas | 48157 | 177589 | 1191 |
2277710 | 2277710 | 2022-03-05 | Fort Bend | Texas | 48157 | 177561 | 1191 |
2274457 | 2274457 | 2022-03-04 | Fort Bend | Texas | 48157 | 177233 | 1191 |
2271204 | 2271204 | 2022-03-03 | Fort Bend | Texas | 48157 | 177025 | 1191 |
2179250 | 2179250 | 2022-02-03 | Mercer | New Jersey | 34021 | 72830 | 1191 |
2151692 | 2151692 | 2022-01-26 | Jefferson | Colorado | 8059 | 110315 | 1191 |
2151259 | 2151259 | 2022-01-25 | Spokane | Washington | 53063 | 103644 | 1191 |
2148007 | 2148007 | 2022-01-24 | Spokane | Washington | 53063 | 102835 | 1191 |
2123274 | 2123274 | 2022-01-17 | East Baton Rouge | Louisiana | 22033 | 90180 | 1191 |
2120022 | 2120022 | 2022-01-16 | East Baton Rouge | Louisiana | 22033 | 90180 | 1191 |
2116770 | 2116770 | 2022-01-15 | East Baton Rouge | Louisiana | 22033 | 90180 | 1191 |
2113519 | 2113519 | 2022-01-14 | East Baton Rouge | Louisiana | 22033 | 90180 | 1191 |
2055009 | 2055009 | 2021-12-27 | Jefferson | Louisiana | 22051 | 74885 | 1191 |
2051759 | 2051759 | 2021-12-26 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2048509 | 2048509 | 2021-12-25 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2045259 | 2045259 | 2021-12-24 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2042010 | 2042010 | 2021-12-23 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2038760 | 2038760 | 2021-12-22 | Jefferson | Louisiana | 22051 | 72302 | 1191 |
1972845 | 1972845 | 2021-12-02 | Ventura | California | 6111 | 104238 | 1191 |
1969595 | 1969595 | 2021-12-01 | Ventura | California | 6111 | 104084 | 1191 |
1942642 | 1942642 | 2021-11-22 | Davidson | Tennessee | 47037 | 135017 | 1191 |
1877557 | 1877557 | 2021-11-02 | Spartanburg | South Carolina | 45083 | 61999 | 1191 |
1872172 | 1872172 | 2021-11-01 | District of Columbia | District of Columbia | 11001 | 64470 | 1191 |
1874308 | 1874308 | 2021-11-01 | Spartanburg | South Carolina | 45083 | 61961 | 1191 |
1857478 | 1857478 | 2021-10-27 | Monroe | New York | 36055 | 85442 | 1191 |
1823813 | 1823813 | 2021-10-17 | Will | Illinois | 17197 | 90698 | 1191 |
1820564 | 1820564 | 2021-10-16 | Will | Illinois | 17197 | 90698 | 1191 |
1817315 | 1817315 | 2021-10-15 | Will | Illinois | 17197 | 90698 | 1191 |
1814067 | 1814067 | 2021-10-14 | Will | Illinois | 17197 | 90560 | 1191 |
1810818 | 1810818 | 2021-10-13 | Will | Illinois | 17197 | 90407 | 1191 |
1675961 | 1675961 | 2021-09-01 | Lancaster | Pennsylvania | 42071 | 59642 | 1191 |
1672714 | 1672714 | 2021-08-31 | Lancaster | Pennsylvania | 42071 | 59497 | 1191 |
1220899 | 1220899 | 2021-04-14 | Morris | New Jersey | 34027 | 47741 | 1191 |
1217651 | 1217651 | 2021-04-13 | Morris | New Jersey | 34027 | 47599 | 1191 |
1214403 | 1214403 | 2021-04-12 | Morris | New Jersey | 34027 | 47358 | 1191 |
1211156 | 1211156 | 2021-04-11 | Morris | New Jersey | 34027 | 47243 | 1191 |
1205126 | 1205126 | 2021-04-09 | Bucks | Pennsylvania | 42017 | 53486 | 1191 |
1151091 | 1151091 | 2021-03-24 | Kern | California | 6029 | 105810 | 1191 |
1112305 | 1112305 | 2021-03-12 | Polk | Florida | 12105 | 58691 | 1191 |
1109059 | 1109059 | 2021-03-11 | Polk | Florida | 12105 | 58567 | 1191 |
1107232 | 1107232 | 2021-03-10 | Camden | New Jersey | 34007 | 45363 | 1191 |
1058836 | 1058836 | 2021-02-23 | Franklin | Ohio | 39049 | 110938 | 1191 |
982719 | 982719 | 2021-01-31 | DuPage | Illinois | 17043 | 72454 | 1191 |
979473 | 979473 | 2021-01-30 | DuPage | Illinois | 17043 | 72279 | 1191 |
976228 | 976228 | 2021-01-29 | DuPage | Illinois | 17043 | 72068 | 1191 |
947619 | 947619 | 2021-01-20 | Prince George's | Maryland | 24033 | 64053 | 1191 |
815142 | 815142 | 2020-12-10 | Ocean | New Jersey | 34029 | 25218 | 1191 |
802757 | 802757 | 2020-12-06 | Unknown | Puerto Rico | 3028 | 1191 | |
791860 | 791860 | 2020-12-03 | Norfolk | Massachusetts | 25021 | 17069 | 1191 |
704250 | 704250 | 2020-11-06 | Suffolk | Massachusetts | 25025 | 30062 | 1191 |
545434 | 545434 | 2020-09-18 | Oakland | Michigan | 26125 | 19828 | 1191 |
524107 | 524107 | 2020-09-11 | Bexar | Texas | 48029 | 48086 | 1191 |
409683 | 409683 | 2020-08-07 | Essex | Massachusetts | 25009 | 17699 | 1191 |
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);