ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where deaths = 788 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 16
- Mississippi 14
- Utah 14
- Michigan 12
- Washington 12
- Ohio 11
- New Jersey 10
- Pennsylvania 9
- Minnesota 8
- New York 8
- Illinois 7
- California 6
- Georgia 5
- Kansas 5
- Alabama 4
- Florida 4
- Arkansas 3
- South Carolina 3
- Indiana 2
- Maryland 2
- Missouri 2
- North Carolina 2
- Tennessee 2
- Arizona 1
- Colorado 1
- Delaware 1
- District of Columbia 1
- Kentucky 1
- Louisiana 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499976 | 2499976 | 2022-05-13 | Bibb | Georgia | 13021 | 37615 | 788 |
2496718 | 2496718 | 2022-05-12 | Bibb | Georgia | 13021 | 37615 | 788 |
2493460 | 2493460 | 2022-05-11 | Bibb | Georgia | 13021 | 37615 | 788 |
2470104 | 2470104 | 2022-05-03 | Yakima | Washington | 53077 | 73660 | 788 |
2466848 | 2466848 | 2022-05-02 | Yakima | Washington | 53077 | 73660 | 788 |
2463593 | 2463593 | 2022-05-01 | Yakima | Washington | 53077 | 73617 | 788 |
2460337 | 2460337 | 2022-04-30 | Yakima | Washington | 53077 | 73617 | 788 |
2457081 | 2457081 | 2022-04-29 | Yakima | Washington | 53077 | 73617 | 788 |
2453825 | 2453825 | 2022-04-28 | Yakima | Washington | 53077 | 73593 | 788 |
2450569 | 2450569 | 2022-04-27 | Yakima | Washington | 53077 | 73573 | 788 |
2445523 | 2445523 | 2022-04-26 | Ottawa | Michigan | 26139 | 75061 | 788 |
2442267 | 2442267 | 2022-04-25 | Ottawa | Michigan | 26139 | 75061 | 788 |
2442835 | 2442835 | 2022-04-25 | Oneida | New York | 36065 | 56000 | 788 |
2439011 | 2439011 | 2022-04-24 | Ottawa | Michigan | 26139 | 75061 | 788 |
2439579 | 2439579 | 2022-04-24 | Oneida | New York | 36065 | 55904 | 788 |
2435755 | 2435755 | 2022-04-23 | Ottawa | Michigan | 26139 | 75061 | 788 |
2436323 | 2436323 | 2022-04-23 | Oneida | New York | 36065 | 55771 | 788 |
2432499 | 2432499 | 2022-04-22 | Ottawa | Michigan | 26139 | 75061 | 788 |
2433067 | 2433067 | 2022-04-22 | Oneida | New York | 36065 | 55604 | 788 |
2429243 | 2429243 | 2022-04-21 | Ottawa | Michigan | 26139 | 75061 | 788 |
2425987 | 2425987 | 2022-04-20 | Ottawa | Michigan | 26139 | 75061 | 788 |
2427583 | 2427583 | 2022-04-20 | Utah | Utah | 49049 | 201713 | 788 |
2424327 | 2424327 | 2022-04-19 | Utah | Utah | 49049 | 201713 | 788 |
2421071 | 2421071 | 2022-04-18 | Utah | Utah | 49049 | 201713 | 788 |
2416346 | 2416346 | 2022-04-17 | Hinds | Mississippi | 28049 | 52230 | 788 |
2417815 | 2417815 | 2022-04-17 | Utah | Utah | 49049 | 201713 | 788 |
2413090 | 2413090 | 2022-04-16 | Hinds | Mississippi | 28049 | 52230 | 788 |
2414559 | 2414559 | 2022-04-16 | Utah | Utah | 49049 | 201713 | 788 |
2409834 | 2409834 | 2022-04-15 | Hinds | Mississippi | 28049 | 52230 | 788 |
2411303 | 2411303 | 2022-04-15 | Utah | Utah | 49049 | 201713 | 788 |
2406578 | 2406578 | 2022-04-14 | Hinds | Mississippi | 28049 | 52230 | 788 |
2408047 | 2408047 | 2022-04-14 | Utah | Utah | 49049 | 201713 | 788 |
2403322 | 2403322 | 2022-04-13 | Hinds | Mississippi | 28049 | 52230 | 788 |
2404791 | 2404791 | 2022-04-13 | Utah | Utah | 49049 | 201585 | 788 |
2400068 | 2400068 | 2022-04-12 | Hinds | Mississippi | 28049 | 52230 | 788 |
2401536 | 2401536 | 2022-04-12 | Utah | Utah | 49049 | 201585 | 788 |
2396812 | 2396812 | 2022-04-11 | Hinds | Mississippi | 28049 | 52152 | 788 |
2398281 | 2398281 | 2022-04-11 | Utah | Utah | 49049 | 201585 | 788 |
2393557 | 2393557 | 2022-04-10 | Hinds | Mississippi | 28049 | 52152 | 788 |
2395026 | 2395026 | 2022-04-10 | Utah | Utah | 49049 | 201585 | 788 |
2390301 | 2390301 | 2022-04-09 | Hinds | Mississippi | 28049 | 52152 | 788 |
2391770 | 2391770 | 2022-04-09 | Utah | Utah | 49049 | 201585 | 788 |
2387045 | 2387045 | 2022-04-08 | Hinds | Mississippi | 28049 | 52152 | 788 |
2388514 | 2388514 | 2022-04-08 | Utah | Utah | 49049 | 201585 | 788 |
2383790 | 2383790 | 2022-04-07 | Hinds | Mississippi | 28049 | 52152 | 788 |
2385259 | 2385259 | 2022-04-07 | Utah | Utah | 49049 | 201585 | 788 |
2380535 | 2380535 | 2022-04-06 | Hinds | Mississippi | 28049 | 52152 | 788 |
2377280 | 2377280 | 2022-04-05 | Hinds | Mississippi | 28049 | 52152 | 788 |
2374028 | 2374028 | 2022-04-04 | Hinds | Mississippi | 28049 | 52152 | 788 |
2335491 | 2335491 | 2022-03-23 | Forsyth | North Carolina | 37067 | 91925 | 788 |
2328373 | 2328373 | 2022-03-21 | Anoka | Minnesota | 27003 | 98008 | 788 |
2325120 | 2325120 | 2022-03-20 | Anoka | Minnesota | 27003 | 97987 | 788 |
2321866 | 2321866 | 2022-03-19 | Anoka | Minnesota | 27003 | 97987 | 788 |
2318612 | 2318612 | 2022-03-18 | Anoka | Minnesota | 27003 | 97987 | 788 |
2315359 | 2315359 | 2022-03-17 | Anoka | Minnesota | 27003 | 97960 | 788 |
2315973 | 2315973 | 2022-03-17 | Gaston | North Carolina | 37071 | 64902 | 788 |
2312106 | 2312106 | 2022-03-16 | Anoka | Minnesota | 27003 | 97950 | 788 |
2308853 | 2308853 | 2022-03-15 | Anoka | Minnesota | 27003 | 97895 | 788 |
2271865 | 2271865 | 2022-03-04 | Benton | Arkansas | 5007 | 65933 | 788 |
2268613 | 2268613 | 2022-03-03 | Benton | Arkansas | 5007 | 65900 | 788 |
2246199 | 2246199 | 2022-02-24 | Hall | Georgia | 13139 | 53232 | 788 |
2230805 | 2230805 | 2022-02-19 | St. Clair | Michigan | 26147 | 39773 | 788 |
2227554 | 2227554 | 2022-02-18 | St. Clair | Michigan | 26147 | 39773 | 788 |
2224303 | 2224303 | 2022-02-17 | St. Clair | Michigan | 26147 | 39737 | 788 |
2174706 | 2174706 | 2022-02-02 | Richmond | Georgia | 13245 | 47910 | 788 |
2176906 | 2176906 | 2022-02-02 | Galveston | Texas | 48167 | 91079 | 788 |
2165092 | 2165092 | 2022-01-30 | Madison | Illinois | 17119 | 66606 | 788 |
2161837 | 2161837 | 2022-01-29 | Madison | Illinois | 17119 | 66606 | 788 |
2158582 | 2158582 | 2022-01-28 | Madison | Illinois | 17119 | 66606 | 788 |
2148943 | 2148943 | 2022-01-25 | St. Joseph | Indiana | 18141 | 66799 | 788 |
2058427 | 2058427 | 2021-12-28 | Saginaw | Michigan | 26145 | 36748 | 788 |
2055178 | 2055178 | 2021-12-27 | Saginaw | Michigan | 26145 | 36748 | 788 |
2026499 | 2026499 | 2021-12-18 | Rockland | New York | 36087 | 58012 | 788 |
2023248 | 2023248 | 2021-12-17 | Rockland | New York | 36087 | 57706 | 788 |
2018308 | 2018308 | 2021-12-16 | Imperial | California | 6025 | 40210 | 788 |
2015058 | 2015058 | 2021-12-15 | Imperial | California | 6025 | 39876 | 788 |
2011658 | 2011658 | 2021-12-14 | Montgomery | Alabama | 1101 | 34806 | 788 |
2008407 | 2008407 | 2021-12-13 | Montgomery | Alabama | 1101 | 34691 | 788 |
2005156 | 2005156 | 2021-12-12 | Montgomery | Alabama | 1101 | 34683 | 788 |
2001905 | 2001905 | 2021-12-11 | Montgomery | Alabama | 1101 | 34669 | 788 |
1987714 | 1987714 | 2021-12-06 | Mahoning | Ohio | 39099 | 36168 | 788 |
1984464 | 1984464 | 2021-12-05 | Mahoning | Ohio | 39099 | 36035 | 788 |
1981214 | 1981214 | 2021-12-04 | Mahoning | Ohio | 39099 | 35952 | 788 |
1977964 | 1977964 | 2021-12-03 | Mahoning | Ohio | 39099 | 35798 | 788 |
1962021 | 1962021 | 2021-11-28 | Anderson | South Carolina | 45007 | 37451 | 788 |
1962692 | 1962692 | 2021-11-28 | Snohomish | Washington | 53061 | 71256 | 788 |
1958770 | 1958770 | 2021-11-27 | Anderson | South Carolina | 45007 | 37451 | 788 |
1959441 | 1959441 | 2021-11-27 | Snohomish | Washington | 53061 | 71256 | 788 |
1955519 | 1955519 | 2021-11-26 | Anderson | South Carolina | 45007 | 37451 | 788 |
1956190 | 1956190 | 2021-11-26 | Snohomish | Washington | 53061 | 71256 | 788 |
1952939 | 1952939 | 2021-11-25 | Snohomish | Washington | 53061 | 71256 | 788 |
1949688 | 1949688 | 2021-11-24 | Snohomish | Washington | 53061 | 71256 | 788 |
1944550 | 1944550 | 2021-11-23 | Anne Arundel | Maryland | 24003 | 54890 | 788 |
1932137 | 1932137 | 2021-11-19 | Atlantic | New Jersey | 34001 | 40606 | 788 |
1928886 | 1928886 | 2021-11-18 | Atlantic | New Jersey | 34001 | 40558 | 788 |
1925636 | 1925636 | 2021-11-17 | Atlantic | New Jersey | 34001 | 40476 | 788 |
1922387 | 1922387 | 2021-11-16 | Atlantic | New Jersey | 34001 | 40426 | 788 |
1922475 | 1922475 | 2021-11-16 | Orange | New York | 36071 | 60071 | 788 |
1919225 | 1919225 | 2021-11-15 | Orange | New York | 36071 | 59966 | 788 |
1836801 | 1836801 | 2021-10-21 | Unknown | Illinois | 0 | 788 |
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);