ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where deaths = 1082 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- California 16
- Florida 14
- Ohio 12
- Pennsylvania 9
- Georgia 6
- Tennessee 5
- Nebraska 4
- Illinois 3
- Indiana 3
- Kansas 3
- Louisiana 3
- New Jersey 3
- Texas 3
- Maryland 2
- Michigan 2
- Arizona 1
- Kentucky 1
- Massachusetts 1
- Minnesota 1
- New York 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403998 | 2403998 | 2022-04-13 | Mahoning | Ohio | 39099 | 53371 | 1082 |
2399005 | 2399005 | 2022-04-12 | Seminole | Florida | 12117 | 103586 | 1082 |
2400743 | 2400743 | 2022-04-12 | Mahoning | Ohio | 39099 | 53371 | 1082 |
2395750 | 2395750 | 2022-04-11 | Seminole | Florida | 12117 | 103586 | 1082 |
2397488 | 2397488 | 2022-04-11 | Mahoning | Ohio | 39099 | 53371 | 1082 |
2392494 | 2392494 | 2022-04-10 | Seminole | Florida | 12117 | 103586 | 1082 |
2394233 | 2394233 | 2022-04-10 | Mahoning | Ohio | 39099 | 53371 | 1082 |
2389238 | 2389238 | 2022-04-09 | Seminole | Florida | 12117 | 103586 | 1082 |
2390977 | 2390977 | 2022-04-09 | Mahoning | Ohio | 39099 | 53371 | 1082 |
2385983 | 2385983 | 2022-04-08 | Seminole | Florida | 12117 | 103586 | 1082 |
2387721 | 2387721 | 2022-04-08 | Mahoning | Ohio | 39099 | 53371 | 1082 |
2382728 | 2382728 | 2022-04-07 | Seminole | Florida | 12117 | 103188 | 1082 |
2384466 | 2384466 | 2022-04-07 | Mahoning | Ohio | 39099 | 53371 | 1082 |
2379473 | 2379473 | 2022-04-06 | Seminole | Florida | 12117 | 103188 | 1082 |
2365145 | 2365145 | 2022-04-01 | Northampton | Pennsylvania | 42095 | 79393 | 1082 |
2361892 | 2361892 | 2022-03-31 | Northampton | Pennsylvania | 42095 | 79364 | 1082 |
2358638 | 2358638 | 2022-03-30 | Northampton | Pennsylvania | 42095 | 79332 | 1082 |
2355384 | 2355384 | 2022-03-29 | Northampton | Pennsylvania | 42095 | 79314 | 1082 |
2352131 | 2352131 | 2022-03-28 | Northampton | Pennsylvania | 42095 | 79299 | 1082 |
2348879 | 2348879 | 2022-03-27 | Northampton | Pennsylvania | 42095 | 79291 | 1082 |
2345626 | 2345626 | 2022-03-26 | Northampton | Pennsylvania | 42095 | 79276 | 1082 |
2303585 | 2303585 | 2022-03-13 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2300333 | 2300333 | 2022-03-12 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2297081 | 2297081 | 2022-03-11 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2293829 | 2293829 | 2022-03-10 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2290577 | 2290577 | 2022-03-09 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2279955 | 2279955 | 2022-03-06 | Douglas | Nebraska | 31055 | 148387 | 1082 |
2276702 | 2276702 | 2022-03-05 | Douglas | Nebraska | 31055 | 148387 | 1082 |
2273449 | 2273449 | 2022-03-04 | Douglas | Nebraska | 31055 | 148387 | 1082 |
2270197 | 2270197 | 2022-03-03 | Douglas | Nebraska | 31055 | 148351 | 1082 |
2233866 | 2233866 | 2022-02-20 | Caddo | Louisiana | 22017 | 66686 | 1082 |
2230615 | 2230615 | 2022-02-19 | Caddo | Louisiana | 22017 | 66686 | 1082 |
2227364 | 2227364 | 2022-02-18 | Caddo | Louisiana | 22017 | 66686 | 1082 |
2165140 | 2165140 | 2022-01-30 | Allen | Indiana | 18003 | 99234 | 1082 |
2161885 | 2161885 | 2022-01-29 | Allen | Indiana | 18003 | 99234 | 1082 |
2158630 | 2158630 | 2022-01-28 | Allen | Indiana | 18003 | 99234 | 1082 |
2149107 | 2149107 | 2022-01-25 | Johnson | Kansas | 20091 | 129024 | 1082 |
2145855 | 2145855 | 2022-01-24 | Johnson | Kansas | 20091 | 129024 | 1082 |
2134984 | 2134984 | 2022-01-20 | Pierce | Washington | 53053 | 151420 | 1082 |
2119077 | 2119077 | 2022-01-16 | Contra Costa | California | 6013 | 142972 | 1082 |
2115825 | 2115825 | 2022-01-15 | Contra Costa | California | 6013 | 142972 | 1082 |
2112574 | 2112574 | 2022-01-14 | Contra Costa | California | 6013 | 142972 | 1082 |
2084921 | 2084921 | 2022-01-05 | Mercer | New Jersey | 34021 | 56241 | 1082 |
2033890 | 2033890 | 2021-12-20 | Lubbock | Texas | 48303 | 70082 | 1082 |
2030640 | 2030640 | 2021-12-19 | Lubbock | Texas | 48303 | 69873 | 1082 |
2027389 | 2027389 | 2021-12-18 | Lubbock | Texas | 48303 | 69873 | 1082 |
2012997 | 2012997 | 2021-12-14 | Ramsey | Minnesota | 27123 | 78738 | 1082 |
1967387 | 1967387 | 2021-11-30 | Kent | Michigan | 26081 | 109356 | 1082 |
1964135 | 1964135 | 2021-11-29 | Kent | Michigan | 26081 | 109356 | 1082 |
1959840 | 1959840 | 2021-11-28 | Tulare | California | 6107 | 85614 | 1082 |
1956589 | 1956589 | 2021-11-27 | Tulare | California | 6107 | 85614 | 1082 |
1953338 | 1953338 | 2021-11-26 | Tulare | California | 6107 | 85614 | 1082 |
1950087 | 1950087 | 2021-11-25 | Tulare | California | 6107 | 85614 | 1082 |
1946836 | 1946836 | 2021-11-24 | Tulare | California | 6107 | 85614 | 1082 |
1748763 | 1748763 | 2021-09-24 | Sarasota | Florida | 12115 | 53676 | 1082 |
1745513 | 1745513 | 2021-09-23 | Sarasota | Florida | 12115 | 52668 | 1082 |
1742264 | 1742264 | 2021-09-22 | Sarasota | Florida | 12115 | 52668 | 1082 |
1739015 | 1739015 | 2021-09-21 | Sarasota | Florida | 12115 | 52668 | 1082 |
1735766 | 1735766 | 2021-09-20 | Sarasota | Florida | 12115 | 52668 | 1082 |
1732516 | 1732516 | 2021-09-19 | Sarasota | Florida | 12115 | 52668 | 1082 |
1729266 | 1729266 | 2021-09-18 | Sarasota | Florida | 12115 | 52668 | 1082 |
1670656 | 1670656 | 2021-08-31 | Ventura | California | 6111 | 94210 | 1082 |
1667409 | 1667409 | 2021-08-30 | Ventura | California | 6111 | 94175 | 1082 |
1669284 | 1669284 | 2021-08-30 | Montgomery | Ohio | 39113 | 59231 | 1082 |
1666037 | 1666037 | 2021-08-29 | Montgomery | Ohio | 39113 | 59077 | 1082 |
1662789 | 1662789 | 2021-08-28 | Montgomery | Ohio | 39113 | 58864 | 1082 |
1659541 | 1659541 | 2021-08-27 | Montgomery | Ohio | 39113 | 58547 | 1082 |
1550661 | 1550661 | 2021-07-25 | DeKalb | Georgia | 13089 | 68964 | 1082 |
1547414 | 1547414 | 2021-07-24 | DeKalb | Georgia | 13089 | 68964 | 1082 |
1544167 | 1544167 | 2021-07-23 | DeKalb | Georgia | 13089 | 68964 | 1082 |
1540919 | 1540919 | 2021-07-22 | DeKalb | Georgia | 13089 | 68819 | 1082 |
1537672 | 1537672 | 2021-07-21 | DeKalb | Georgia | 13089 | 68718 | 1082 |
1534227 | 1534227 | 2021-07-20 | Stanislaus | California | 6099 | 64712 | 1082 |
1530980 | 1530980 | 2021-07-19 | Stanislaus | California | 6099 | 64634 | 1082 |
1527733 | 1527733 | 2021-07-18 | Stanislaus | California | 6099 | 64381 | 1082 |
1524486 | 1524486 | 2021-07-17 | Stanislaus | California | 6099 | 64381 | 1082 |
1521238 | 1521238 | 2021-07-16 | Stanislaus | California | 6099 | 64381 | 1082 |
1421024 | 1421024 | 2021-06-15 | Lake | Illinois | 17097 | 68324 | 1082 |
1417779 | 1417779 | 2021-06-14 | Lake | Illinois | 17097 | 68311 | 1082 |
1378607 | 1378607 | 2021-06-02 | Cobb | Georgia | 13067 | 79981 | 1082 |
1342191 | 1342191 | 2021-05-21 | Fairfax | Virginia | 51059 | 76795 | 1082 |
1334605 | 1334605 | 2021-05-19 | Monroe | New York | 36055 | 67231 | 1082 |
1320953 | 1320953 | 2021-05-15 | Baltimore city | Maryland | 24510 | 52279 | 1082 |
1195407 | 1195407 | 2021-04-06 | Lancaster | Pennsylvania | 42071 | 48920 | 1082 |
1161689 | 1161689 | 2021-03-27 | Jefferson | Kentucky | 21111 | 77455 | 1082 |
1090200 | 1090200 | 2021-03-05 | Unknown | Kansas | 0 | 1082 | |
1063467 | 1063467 | 2021-02-25 | San Joaquin | California | 6077 | 66569 | 1082 |
954968 | 954968 | 2021-01-22 | Cuyahoga | Ohio | 39035 | 84960 | 1082 |
950851 | 950851 | 2021-01-21 | Baltimore | Maryland | 24005 | 44975 | 1082 |
901588 | 901588 | 2021-01-06 | DuPage | Illinois | 17043 | 64259 | 1082 |
884843 | 884843 | 2021-01-01 | Pima | Arizona | 4019 | 70563 | 1082 |
857839 | 857839 | 2020-12-23 | Montgomery | Pennsylvania | 42091 | 32738 | 1082 |
724275 | 724275 | 2020-11-12 | Ocean | New Jersey | 34029 | 18146 | 1082 |
619902 | 619902 | 2020-10-11 | Norfolk | Massachusetts | 25021 | 10824 | 1082 |
158911 | 158911 | 2020-05-19 | Hudson | New Jersey | 34017 | 17621 | 1082 |
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);