ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where deaths = 1103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- California 8
- Florida 8
- Tennessee 8
- New Jersey 6
- Pennsylvania 6
- Kansas 5
- Michigan 5
- Illinois 4
- Louisiana 4
- Ohio 3
- Virginia 3
- Georgia 2
- Massachusetts 2
- Texas 2
- Washington 2
- Arizona 1
- Colorado 1
- Minnesota 1
- New York 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324948 | 2324948 | 2022-03-20 | Orleans | Louisiana | 22071 | 87129 | 1103 |
2321694 | 2321694 | 2022-03-19 | Orleans | Louisiana | 22071 | 87129 | 1103 |
2318440 | 2318440 | 2022-03-18 | Orleans | Louisiana | 22071 | 87129 | 1103 |
2310089 | 2310089 | 2022-03-15 | Hamilton | Tennessee | 47065 | 99176 | 1103 |
2239619 | 2239619 | 2022-02-22 | St. Lucie | Florida | 12111 | 72628 | 1103 |
2236368 | 2236368 | 2022-02-21 | St. Lucie | Florida | 12111 | 72628 | 1103 |
2233117 | 2233117 | 2022-02-20 | St. Lucie | Florida | 12111 | 72628 | 1103 |
2229866 | 2229866 | 2022-02-19 | St. Lucie | Florida | 12111 | 72628 | 1103 |
2226615 | 2226615 | 2022-02-18 | St. Lucie | Florida | 12111 | 72628 | 1103 |
2223364 | 2223364 | 2022-02-17 | St. Lucie | Florida | 12111 | 72164 | 1103 |
2220113 | 2220113 | 2022-02-16 | St. Lucie | Florida | 12111 | 72164 | 1103 |
2200328 | 2200328 | 2022-02-10 | Yavapai | Arizona | 4025 | 46510 | 1103 |
2150742 | 2150742 | 2022-01-25 | Knox | Tennessee | 47093 | 100632 | 1103 |
2151254 | 2151254 | 2022-01-25 | Pierce | Washington | 53053 | 160394 | 1103 |
2147490 | 2147490 | 2022-01-24 | Knox | Tennessee | 47093 | 100632 | 1103 |
2148002 | 2148002 | 2022-01-24 | Pierce | Washington | 53053 | 160394 | 1103 |
2144236 | 2144236 | 2022-01-23 | Knox | Tennessee | 47093 | 100632 | 1103 |
2140981 | 2140981 | 2022-01-22 | Knox | Tennessee | 47093 | 100632 | 1103 |
2137725 | 2137725 | 2022-01-21 | Knox | Tennessee | 47093 | 100632 | 1103 |
2134471 | 2134471 | 2022-01-20 | Knox | Tennessee | 47093 | 100632 | 1103 |
2131219 | 2131219 | 2022-01-19 | Knox | Tennessee | 47093 | 100632 | 1103 |
2107681 | 2107681 | 2022-01-12 | Mercer | New Jersey | 34021 | 64033 | 1103 |
2105314 | 2105314 | 2022-01-11 | Denton | Texas | 48121 | 133641 | 1103 |
2083379 | 2083379 | 2022-01-05 | Denver | Colorado | 8031 | 124126 | 1103 |
2074346 | 2074346 | 2022-01-02 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2071095 | 2071095 | 2022-01-01 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2067844 | 2067844 | 2021-12-31 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2064593 | 2064593 | 2021-12-30 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2061343 | 2061343 | 2021-12-29 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2035752 | 2035752 | 2021-12-21 | Ramsey | Minnesota | 27123 | 80650 | 1103 |
2005346 | 2005346 | 2021-12-12 | Tulare | California | 6107 | 87521 | 1103 |
2002095 | 2002095 | 2021-12-11 | Tulare | California | 6107 | 87521 | 1103 |
1998845 | 1998845 | 2021-12-10 | Tulare | California | 6107 | 87521 | 1103 |
1992343 | 1992343 | 2021-12-08 | Tulare | California | 6107 | 87136 | 1103 |
1882865 | 1882865 | 2021-11-04 | Genesee | Michigan | 26049 | 53604 | 1103 |
1879616 | 1879616 | 2021-11-03 | Genesee | Michigan | 26049 | 53604 | 1103 |
1805888 | 1805888 | 2021-10-11 | Berks | Pennsylvania | 42011 | 56235 | 1103 |
1802638 | 1802638 | 2021-10-10 | Berks | Pennsylvania | 42011 | 56121 | 1103 |
1799389 | 1799389 | 2021-10-09 | Berks | Pennsylvania | 42011 | 55997 | 1103 |
1796140 | 1796140 | 2021-10-08 | Berks | Pennsylvania | 42011 | 55855 | 1103 |
1746282 | 1746282 | 2021-09-23 | Jefferson | Louisiana | 22051 | 68040 | 1103 |
1701772 | 1701772 | 2021-09-09 | Montgomery | Ohio | 39113 | 62503 | 1103 |
1698523 | 1698523 | 2021-09-08 | Montgomery | Ohio | 39113 | 62163 | 1103 |
1695275 | 1695275 | 2021-09-07 | Montgomery | Ohio | 39113 | 61830 | 1103 |
1645082 | 1645082 | 2021-08-23 | Lake | Illinois | 17097 | 72281 | 1103 |
1641833 | 1641833 | 2021-08-22 | Lake | Illinois | 17097 | 71889 | 1103 |
1638583 | 1638583 | 2021-08-21 | Lake | Illinois | 17097 | 71889 | 1103 |
1635333 | 1635333 | 2021-08-20 | Lake | Illinois | 17097 | 71889 | 1103 |
1443520 | 1443520 | 2021-06-22 | Cobb | Georgia | 13067 | 80445 | 1103 |
1386545 | 1386545 | 2021-06-04 | Monroe | New York | 36055 | 68626 | 1103 |
1387636 | 1387636 | 2021-06-04 | Fairfax | Virginia | 51059 | 77018 | 1103 |
1384391 | 1384391 | 2021-06-03 | Fairfax | Virginia | 51059 | 77011 | 1103 |
1381145 | 1381145 | 2021-06-02 | Fairfax | Virginia | 51059 | 77010 | 1103 |
1219550 | 1219550 | 2021-04-14 | Gwinnett | Georgia | 13135 | 98654 | 1103 |
1076594 | 1076594 | 2021-03-01 | Orange | Florida | 12095 | 114433 | 1103 |
1045570 | 1045570 | 2021-02-19 | Morris | New Jersey | 34027 | 36077 | 1103 |
1042325 | 1042325 | 2021-02-18 | Morris | New Jersey | 34027 | 35898 | 1103 |
961666 | 961666 | 2021-01-24 | Delaware | Pennsylvania | 42045 | 35855 | 1103 |
958421 | 958421 | 2021-01-23 | Delaware | Pennsylvania | 42045 | 35642 | 1103 |
936609 | 936609 | 2021-01-16 | Milwaukee | Wisconsin | 55079 | 99152 | 1103 |
915750 | 915750 | 2021-01-10 | Monmouth | New Jersey | 34025 | 39698 | 1103 |
810316 | 810316 | 2020-12-09 | San Diego | California | 6073 | 97612 | 1103 |
763221 | 763221 | 2020-11-24 | Ocean | New Jersey | 34029 | 20573 | 1103 |
741346 | 741346 | 2020-11-17 | Cameron | Texas | 48061 | 25234 | 1103 |
691331 | 691331 | 2020-11-02 | Macomb | Michigan | 26099 | 20625 | 1103 |
688086 | 688086 | 2020-11-01 | Macomb | Michigan | 26099 | 19975 | 1103 |
684842 | 684842 | 2020-10-31 | Macomb | Michigan | 26099 | 19975 | 1103 |
577766 | 577766 | 2020-09-28 | Worcester | Massachusetts | 25027 | 14375 | 1103 |
528169 | 528169 | 2020-09-13 | Riverside | California | 6065 | 55073 | 1103 |
524933 | 524933 | 2020-09-12 | Riverside | California | 6065 | 55073 | 1103 |
521697 | 521697 | 2020-09-11 | Riverside | California | 6065 | 55073 | 1103 |
226327 | 226327 | 2020-06-10 | Union | New Jersey | 34039 | 16317 | 1103 |
122446 | 122446 | 2020-05-07 | Middlesex | Massachusetts | 25017 | 16676 | 1103 |
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);