ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 6644 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- South Carolina 9
- Missouri 6
- Indiana 5
- Virginia 4
- Colorado 3
- Kentucky 3
- North Carolina 3
- Ohio 3
- Kansas 2
- New Mexico 2
- New York 2
- Pennsylvania 2
- Tennessee 2
- Alabama 1
- California 1
- Georgia 1
- Idaho 1
- Illinois 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- New Jersey 1
- Oklahoma 1
- Texas 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449888 | 2449888 | 2022-04-27 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2446631 | 2446631 | 2022-04-26 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2443376 | 2443376 | 2022-04-25 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2440120 | 2440120 | 2022-04-24 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2436864 | 2436864 | 2022-04-23 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2433608 | 2433608 | 2022-04-22 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2430352 | 2430352 | 2022-04-21 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2427096 | 2427096 | 2022-04-20 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2423840 | 2423840 | 2022-04-19 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2375538 | 2375538 | 2022-04-04 | Carroll | Virginia | 51035 | 6644 | 145 |
2284625 | 2284625 | 2022-03-07 | Hancock | West Virginia | 54029 | 6644 | 139 |
2246861 | 2246861 | 2022-02-24 | Woodford | Kentucky | 21239 | 6644 | 44 |
2243610 | 2243610 | 2022-02-23 | Woodford | Kentucky | 21239 | 6644 | 44 |
2222680 | 2222680 | 2022-02-16 | Caroline | Virginia | 51033 | 6644 | 72 |
2200670 | 2200670 | 2022-02-10 | Gilmer | Georgia | 13123 | 6644 | 156 |
2156603 | 2156603 | 2022-01-27 | Dare | North Carolina | 37055 | 6644 | 18 |
2142433 | 2142433 | 2022-01-23 | Scott | Indiana | 18143 | 6644 | 90 |
2139178 | 2139178 | 2022-01-22 | Scott | Indiana | 18143 | 6644 | 90 |
2135922 | 2135922 | 2022-01-21 | Scott | Indiana | 18143 | 6644 | 90 |
2132850 | 2132850 | 2022-01-20 | McPherson | Kansas | 20113 | 6644 | 112 |
2129597 | 2129597 | 2022-01-19 | McPherson | Kansas | 20113 | 6644 | 112 |
2036985 | 2036985 | 2021-12-21 | Weakley | Tennessee | 47183 | 6644 | 102 |
1990750 | 1990750 | 2021-12-07 | Tioga | New York | 36107 | 6644 | 74 |
1901831 | 1901831 | 2021-11-10 | Harrison | Indiana | 18061 | 6644 | 98 |
1876281 | 1876281 | 2021-11-02 | Webster | Louisiana | 22119 | 6644 | 147 |
1785161 | 1785161 | 2021-10-05 | Floyd | Kentucky | 21071 | 6644 | 100 |
1769788 | 1769788 | 2021-09-30 | Beaufort | North Carolina | 37013 | 6644 | 120 |
1714790 | 1714790 | 2021-09-13 | Washington | Ohio | 39167 | 6644 | 116 |
1641380 | 1641380 | 2021-08-22 | Humboldt | California | 6023 | 6644 | 61 |
1641450 | 1641450 | 2021-08-22 | Garfield | Colorado | 8045 | 6644 | 56 |
1638200 | 1638200 | 2021-08-21 | Garfield | Colorado | 8045 | 6644 | 56 |
1634950 | 1634950 | 2021-08-20 | Garfield | Colorado | 8045 | 6644 | 56 |
1636959 | 1636959 | 2021-08-20 | Carbon | Pennsylvania | 42025 | 6644 | 176 |
1630837 | 1630837 | 2021-08-18 | Caldwell | Texas | 48055 | 6644 | 109 |
1432003 | 1432003 | 2021-06-18 | St. Lawrence | New York | 36089 | 6644 | 97 |
1392524 | 1392524 | 2021-06-06 | Kandiyohi | Minnesota | 27067 | 6644 | 85 |
1305515 | 1305515 | 2021-05-10 | Wilkes | North Carolina | 37193 | 6644 | 112 |
1294379 | 1294379 | 2021-05-07 | Boone | Illinois | 17007 | 6644 | 84 |
1217049 | 1217049 | 2021-04-13 | Allegany | Maryland | 24001 | 6644 | 205 |
1217938 | 1217938 | 2021-04-13 | Hancock | Ohio | 39063 | 6644 | 123 |
1193109 | 1193109 | 2021-04-06 | Autauga | Alabama | 1001 | 6644 | 102 |
1155959 | 1155959 | 2021-03-25 | Eddy | New Mexico | 35015 | 6644 | 121 |
1020800 | 1020800 | 2021-02-11 | Lynchburg city | Virginia | 51680 | 6644 | 85 |
973152 | 973152 | 2021-01-28 | Wayne | Indiana | 18177 | 6644 | 167 |
964798 | 964798 | 2021-01-25 | Garfield | Oklahoma | 40047 | 6644 | 58 |
889581 | 889581 | 2021-01-02 | St. Francois | Missouri | 29187 | 6644 | 69 |
870032 | 870032 | 2020-12-27 | Clay | Missouri | 29047 | 6644 | 94 |
866787 | 866787 | 2020-12-26 | Clay | Missouri | 29047 | 6644 | 93 |
863542 | 863542 | 2020-12-25 | Clay | Missouri | 29047 | 6644 | 93 |
860297 | 860297 | 2020-12-24 | Clay | Missouri | 29047 | 6644 | 93 |
857052 | 857052 | 2020-12-23 | Clay | Missouri | 29047 | 6644 | 91 |
841102 | 841102 | 2020-12-18 | Cumberland | New Jersey | 34011 | 6644 | 201 |
838329 | 838329 | 2020-12-17 | Blair | Pennsylvania | 42013 | 6644 | 127 |
832149 | 832149 | 2020-12-15 | Madison | Tennessee | 47113 | 6644 | 130 |
824913 | 824913 | 2020-12-13 | Sandoval | New Mexico | 35043 | 6644 | 100 |
745752 | 745752 | 2020-11-19 | Bonneville | Idaho | 16019 | 6644 | 55 |
553647 | 553647 | 2020-09-20 | Virginia Beach city | Virginia | 51810 | 6644 | 79 |
510648 | 510648 | 2020-09-07 | Montgomery | Ohio | 39113 | 6644 | 134 |
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);