ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where deaths = 613 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 27
- California 19
- Missouri 12
- Ohio 12
- Florida 11
- Louisiana 9
- Washington 9
- New Jersey 7
- Pennsylvania 6
- New York 5
- Texas 5
- Arizona 4
- Illinois 4
- Kansas 4
- South Carolina 4
- Colorado 3
- Delaware 3
- Georgia 3
- Idaho 3
- Iowa 3
- Maryland 3
- Tennessee 3
- Wisconsin 3
- Alabama 2
- Michigan 2
- Minnesota 2
- New Hampshire 2
- New Mexico 2
- Arkansas 1
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451465 | 2451465 | 2022-04-28 | Johnson | Indiana | 18081 | 42505 | 613 |
2448209 | 2448209 | 2022-04-27 | Johnson | Indiana | 18081 | 42505 | 613 |
2444953 | 2444953 | 2022-04-26 | Johnson | Indiana | 18081 | 42472 | 613 |
2441697 | 2441697 | 2022-04-25 | Johnson | Indiana | 18081 | 42472 | 613 |
2438441 | 2438441 | 2022-04-24 | Johnson | Indiana | 18081 | 42326 | 613 |
2435185 | 2435185 | 2022-04-23 | Johnson | Indiana | 18081 | 42326 | 613 |
2431929 | 2431929 | 2022-04-22 | Johnson | Indiana | 18081 | 42326 | 613 |
2428673 | 2428673 | 2022-04-21 | Johnson | Indiana | 18081 | 42306 | 613 |
2425417 | 2425417 | 2022-04-20 | Johnson | Indiana | 18081 | 42306 | 613 |
2426950 | 2426950 | 2022-04-20 | Blair | Pennsylvania | 42013 | 29720 | 613 |
2422161 | 2422161 | 2022-04-19 | Johnson | Indiana | 18081 | 42296 | 613 |
2423694 | 2423694 | 2022-04-19 | Blair | Pennsylvania | 42013 | 29712 | 613 |
2418905 | 2418905 | 2022-04-18 | Johnson | Indiana | 18081 | 42296 | 613 |
2415649 | 2415649 | 2022-04-17 | Johnson | Indiana | 18081 | 42266 | 613 |
2412393 | 2412393 | 2022-04-16 | Johnson | Indiana | 18081 | 42266 | 613 |
2409137 | 2409137 | 2022-04-15 | Johnson | Indiana | 18081 | 42266 | 613 |
2405881 | 2405881 | 2022-04-14 | Johnson | Indiana | 18081 | 42266 | 613 |
2402626 | 2402626 | 2022-04-13 | Johnson | Indiana | 18081 | 42266 | 613 |
2399371 | 2399371 | 2022-04-12 | Johnson | Indiana | 18081 | 42258 | 613 |
2396116 | 2396116 | 2022-04-11 | Johnson | Indiana | 18081 | 42258 | 613 |
2392860 | 2392860 | 2022-04-10 | Johnson | Indiana | 18081 | 42253 | 613 |
2389604 | 2389604 | 2022-04-09 | Johnson | Indiana | 18081 | 42253 | 613 |
2386349 | 2386349 | 2022-04-08 | Johnson | Indiana | 18081 | 42253 | 613 |
2383094 | 2383094 | 2022-04-07 | Johnson | Indiana | 18081 | 42241 | 613 |
2379839 | 2379839 | 2022-04-06 | Johnson | Indiana | 18081 | 42241 | 613 |
2376217 | 2376217 | 2022-04-05 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2372965 | 2372965 | 2022-04-04 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2369712 | 2369712 | 2022-04-03 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2366459 | 2366459 | 2022-04-02 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2363206 | 2363206 | 2022-04-01 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2359952 | 2359952 | 2022-03-31 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2356698 | 2356698 | 2022-03-30 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2353285 | 2353285 | 2022-03-29 | Placer | California | 6061 | 70034 | 613 |
2350033 | 2350033 | 2022-03-28 | Placer | California | 6061 | 70027 | 613 |
2346780 | 2346780 | 2022-03-27 | Placer | California | 6061 | 69981 | 613 |
2343527 | 2343527 | 2022-03-26 | Placer | California | 6061 | 69981 | 613 |
2340274 | 2340274 | 2022-03-25 | Placer | California | 6061 | 69981 | 613 |
2337021 | 2337021 | 2022-03-24 | Placer | California | 6061 | 69969 | 613 |
2270938 | 2270938 | 2022-03-03 | Florence | South Carolina | 45041 | 41584 | 613 |
2271684 | 2271684 | 2022-03-03 | Kenosha | Wisconsin | 55059 | 43656 | 613 |
2267686 | 2267686 | 2022-03-02 | Florence | South Carolina | 45041 | 41576 | 613 |
2268432 | 2268432 | 2022-03-02 | Kenosha | Wisconsin | 55059 | 43640 | 613 |
2225312 | 2225312 | 2022-02-17 | Washington | Pennsylvania | 42125 | 49867 | 613 |
2216795 | 2216795 | 2022-02-15 | New London | Connecticut | 9011 | 52748 | 613 |
2200971 | 2200971 | 2022-02-10 | Madison | Indiana | 18095 | 32121 | 613 |
2197430 | 2197430 | 2022-02-09 | Henry | Georgia | 13151 | 56496 | 613 |
2193665 | 2193665 | 2022-02-07 | Racine | Wisconsin | 55101 | 55082 | 613 |
2178729 | 2178729 | 2022-02-03 | Kalamazoo | Michigan | 26077 | 55750 | 613 |
2175477 | 2175477 | 2022-02-02 | Kalamazoo | Michigan | 26077 | 55750 | 613 |
2153737 | 2153737 | 2022-01-26 | Schuylkill | Pennsylvania | 42107 | 32132 | 613 |
2147868 | 2147868 | 2022-01-24 | Chesterfield | Virginia | 51041 | 63806 | 613 |
2125695 | 2125695 | 2022-01-18 | Weld | Colorado | 8123 | 69934 | 613 |
2122443 | 2122443 | 2022-01-17 | Weld | Colorado | 8123 | 69009 | 613 |
2109700 | 2109700 | 2022-01-13 | Canyon | Idaho | 16027 | 47151 | 613 |
2106449 | 2106449 | 2022-01-12 | Canyon | Idaho | 16027 | 46830 | 613 |
2103198 | 2103198 | 2022-01-11 | Canyon | Idaho | 16027 | 46506 | 613 |
2103785 | 2103785 | 2022-01-11 | Ouachita | Louisiana | 22073 | 37857 | 613 |
2088192 | 2088192 | 2022-01-06 | Doña Ana | New Mexico | 35013 | 42566 | 613 |
2062635 | 2062635 | 2021-12-29 | Butler | Pennsylvania | 42019 | 32326 | 613 |
2059050 | 2059050 | 2021-12-28 | Forsyth | North Carolina | 37067 | 58208 | 613 |
2039903 | 2039903 | 2021-12-22 | Erie | Pennsylvania | 42049 | 39678 | 613 |
2017463 | 2017463 | 2021-12-15 | Rutherford | Tennessee | 47149 | 65124 | 613 |
1988507 | 1988507 | 2021-12-06 | Utah | Utah | 49049 | 138344 | 613 |
1937058 | 1937058 | 2021-11-21 | Monterey | California | 6053 | 52200 | 613 |
1933808 | 1933808 | 2021-11-20 | Monterey | California | 6053 | 52200 | 613 |
1930556 | 1930556 | 2021-11-19 | Monterey | California | 6053 | 52200 | 613 |
1927306 | 1927306 | 2021-11-18 | Monterey | California | 6053 | 52161 | 613 |
1928694 | 1928694 | 2021-11-18 | St. Louis city | Missouri | 29510 | 33706 | 613 |
1924056 | 1924056 | 2021-11-17 | Monterey | California | 6053 | 51999 | 613 |
1925444 | 1925444 | 2021-11-17 | St. Louis city | Missouri | 29510 | 33331 | 613 |
1920807 | 1920807 | 2021-11-16 | Monterey | California | 6053 | 51958 | 613 |
1922195 | 1922195 | 2021-11-16 | St. Louis city | Missouri | 29510 | 33272 | 613 |
1917557 | 1917557 | 2021-11-15 | Monterey | California | 6053 | 51939 | 613 |
1918945 | 1918945 | 2021-11-15 | St. Louis city | Missouri | 29510 | 33228 | 613 |
1919222 | 1919222 | 2021-11-15 | Oneida | New York | 36065 | 31043 | 613 |
1914307 | 1914307 | 2021-11-14 | Monterey | California | 6053 | 51891 | 613 |
1915695 | 1915695 | 2021-11-14 | St. Louis city | Missouri | 29510 | 33196 | 613 |
1911057 | 1911057 | 2021-11-13 | Monterey | California | 6053 | 51891 | 613 |
1912445 | 1912445 | 2021-11-13 | St. Louis city | Missouri | 29510 | 33147 | 613 |
1907808 | 1907808 | 2021-11-12 | Monterey | California | 6053 | 51812 | 613 |
1909195 | 1909195 | 2021-11-12 | St. Louis city | Missouri | 29510 | 33071 | 613 |
1904559 | 1904559 | 2021-11-11 | Monterey | California | 6053 | 51812 | 613 |
1905946 | 1905946 | 2021-11-11 | St. Louis city | Missouri | 29510 | 32972 | 613 |
1901309 | 1901309 | 2021-11-10 | Monterey | California | 6053 | 51627 | 613 |
1902697 | 1902697 | 2021-11-10 | St. Louis city | Missouri | 29510 | 32972 | 613 |
1898059 | 1898059 | 2021-11-09 | Monterey | California | 6053 | 51594 | 613 |
1899447 | 1899447 | 2021-11-09 | St. Louis city | Missouri | 29510 | 32938 | 613 |
1879479 | 1879479 | 2021-11-03 | Calcasieu | Louisiana | 22019 | 34520 | 613 |
1876230 | 1876230 | 2021-11-02 | Calcasieu | Louisiana | 22019 | 34507 | 613 |
1872981 | 1872981 | 2021-11-01 | Calcasieu | Louisiana | 22019 | 34494 | 613 |
1869732 | 1869732 | 2021-10-31 | Calcasieu | Louisiana | 22019 | 34467 | 613 |
1866483 | 1866483 | 2021-10-30 | Calcasieu | Louisiana | 22019 | 34467 | 613 |
1863234 | 1863234 | 2021-10-29 | Calcasieu | Louisiana | 22019 | 34467 | 613 |
1855667 | 1855667 | 2021-10-27 | Tuscaloosa | Alabama | 1125 | 35191 | 613 |
1852418 | 1852418 | 2021-10-26 | Tuscaloosa | Alabama | 1125 | 35147 | 613 |
1826681 | 1826681 | 2021-10-18 | Sussex | Delaware | 10005 | 34627 | 613 |
1823432 | 1823432 | 2021-10-17 | Sussex | Delaware | 10005 | 34475 | 613 |
1820183 | 1820183 | 2021-10-16 | Sussex | Delaware | 10005 | 34475 | 613 |
1778403 | 1778403 | 2021-10-03 | St. Joseph | Indiana | 18141 | 42808 | 613 |
1775153 | 1775153 | 2021-10-02 | St. Joseph | Indiana | 18141 | 42808 | 613 |
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);