ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6819 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Virginia 8
- Kentucky 7
- Arkansas 6
- Louisiana 6
- Michigan 5
- Indiana 4
- Tennessee 4
- Alabama 2
- California 2
- Missouri 2
- New York 2
- Ohio 2
- Oklahoma 2
- West Virginia 2
- Georgia 1
- Guam 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- New Hampshire 1
- North Carolina 1
- South Carolina 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483432 | 2483432 | 2022-05-08 | Johnson | Arkansas | 5071 | 6819 | 87 |
2480174 | 2480174 | 2022-05-07 | Johnson | Arkansas | 5071 | 6819 | 87 |
2476916 | 2476916 | 2022-05-06 | Johnson | Arkansas | 5071 | 6819 | 87 |
2473658 | 2473658 | 2022-05-05 | Johnson | Arkansas | 5071 | 6819 | 87 |
2470401 | 2470401 | 2022-05-04 | Johnson | Arkansas | 5071 | 6819 | 87 |
2467145 | 2467145 | 2022-05-03 | Johnson | Arkansas | 5071 | 6819 | 87 |
2395068 | 2395068 | 2022-04-10 | Caroline | Virginia | 51033 | 6819 | 80 |
2391812 | 2391812 | 2022-04-09 | Caroline | Virginia | 51033 | 6819 | 80 |
2388556 | 2388556 | 2022-04-08 | Caroline | Virginia | 51033 | 6819 | 80 |
2378882 | 2378882 | 2022-04-05 | Russell | Virginia | 51167 | 6819 | 110 |
2375537 | 2375537 | 2022-04-04 | Caroline | Virginia | 51033 | 6819 | 80 |
2362526 | 2362526 | 2022-03-31 | Caroline | Virginia | 51033 | 6819 | 81 |
2356018 | 2356018 | 2022-03-29 | Caroline | Virginia | 51033 | 6819 | 81 |
2304988 | 2304988 | 2022-03-14 | Clay | Indiana | 18021 | 6819 | 87 |
2236712 | 2236712 | 2022-02-21 | Fayette | Indiana | 18041 | 6819 | 142 |
2222392 | 2222392 | 2022-02-16 | Cass | Texas | 48067 | 6819 | 181 |
2218545 | 2218545 | 2022-02-15 | Adams | Ohio | 39001 | 6819 | 136 |
2200963 | 2200963 | 2022-02-10 | Jennings | Indiana | 18079 | 6819 | 99 |
2167568 | 2167568 | 2022-01-30 | Mingo | West Virginia | 54059 | 6819 | 103 |
2128831 | 2128831 | 2022-01-19 | Amador | California | 6005 | 6819 | 73 |
2074680 | 2074680 | 2022-01-02 | Sanilac | Michigan | 26151 | 6819 | 167 |
2071429 | 2071429 | 2022-01-01 | Sanilac | Michigan | 26151 | 6819 | 167 |
2068178 | 2068178 | 2021-12-31 | Sanilac | Michigan | 26151 | 6819 | 167 |
2064927 | 2064927 | 2021-12-30 | Sanilac | Michigan | 26151 | 6819 | 167 |
2061677 | 2061677 | 2021-12-29 | Sanilac | Michigan | 26151 | 6819 | 167 |
1935465 | 1935465 | 2021-11-20 | Livingston | New York | 36051 | 6819 | 74 |
1922380 | 1922380 | 2021-11-16 | Grafton | New Hampshire | 33009 | 6819 | 36 |
1918834 | 1918834 | 2021-11-15 | Warren | Mississippi | 28149 | 6819 | 177 |
1881607 | 1881607 | 2021-11-04 | Chilton | Alabama | 1021 | 6819 | 165 |
1793160 | 1793160 | 2021-10-07 | Cheatham | Tennessee | 47021 | 6819 | 66 |
1769028 | 1769028 | 2021-09-30 | Lincoln | Louisiana | 22061 | 6819 | 114 |
1767749 | 1767749 | 2021-09-29 | Marion | West Virginia | 54049 | 6819 | 72 |
1732347 | 1732347 | 2021-09-19 | Mendocino | California | 6045 | 6819 | 71 |
1701795 | 1701795 | 2021-09-09 | Union | Ohio | 39159 | 6819 | 49 |
1677670 | 1677670 | 2021-09-02 | Noble | Indiana | 18113 | 6819 | 101 |
1551328 | 1551328 | 2021-07-25 | Pulaski | Kentucky | 21199 | 6819 | 124 |
1548081 | 1548081 | 2021-07-24 | Pulaski | Kentucky | 21199 | 6819 | 124 |
1544834 | 1544834 | 2021-07-23 | Pulaski | Kentucky | 21199 | 6819 | 124 |
1486410 | 1486410 | 2021-07-05 | Acadia | Louisiana | 22001 | 6819 | 197 |
1483164 | 1483164 | 2021-07-04 | Acadia | Louisiana | 22001 | 6819 | 197 |
1479917 | 1479917 | 2021-07-03 | Acadia | Louisiana | 22001 | 6819 | 197 |
1476671 | 1476671 | 2021-07-02 | Acadia | Louisiana | 22001 | 6819 | 197 |
1447685 | 1447685 | 2021-06-23 | Crow Wing | Minnesota | 27035 | 6819 | 95 |
1372756 | 1372756 | 2021-05-31 | Laurel | Kentucky | 21125 | 6819 | 74 |
1369511 | 1369511 | 2021-05-30 | Laurel | Kentucky | 21125 | 6819 | 74 |
1366265 | 1366265 | 2021-05-29 | Laurel | Kentucky | 21125 | 6819 | 74 |
1280092 | 1280092 | 2021-05-02 | Dickson | Tennessee | 47043 | 6819 | 110 |
1276845 | 1276845 | 2021-05-01 | Dickson | Tennessee | 47043 | 6819 | 110 |
1273598 | 1273598 | 2021-04-30 | Dickson | Tennessee | 47043 | 6819 | 110 |
1245074 | 1245074 | 2021-04-22 | Autauga | Alabama | 1001 | 6819 | 107 |
1043518 | 1043518 | 2021-02-18 | Lynchburg city | Virginia | 51680 | 6819 | 90 |
1006673 | 1006673 | 2021-02-07 | Chautauqua | New York | 36013 | 6819 | 111 |
977827 | 977827 | 2021-01-29 | Wagoner | Oklahoma | 40145 | 6819 | 67 |
937736 | 937736 | 2021-01-17 | Madison | Kentucky | 21151 | 6819 | 45 |
921648 | 921648 | 2021-01-12 | Charles | Maryland | 24017 | 6819 | 132 |
896008 | 896008 | 2021-01-04 | Franklin | Missouri | 29071 | 6819 | 113 |
892761 | 892761 | 2021-01-03 | Franklin | Missouri | 29071 | 6819 | 113 |
831501 | 831501 | 2020-12-15 | Davidson | North Carolina | 37057 | 6819 | 61 |
723023 | 723023 | 2020-11-12 | Unknown | Guam | 6819 | 92 | |
682765 | 682765 | 2020-10-30 | York | South Carolina | 45091 | 6819 | 104 |
649025 | 649025 | 2020-10-20 | Ouachita | Louisiana | 22073 | 6819 | 160 |
614341 | 614341 | 2020-10-09 | Cleveland | Oklahoma | 40027 | 6819 | 81 |
525134 | 525134 | 2020-09-12 | Clayton | Georgia | 13063 | 6819 | 153 |
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);