ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 7792 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Indiana 16
- Michigan 8
- Georgia 6
- Kentucky 4
- Texas 4
- South Carolina 2
- Washington 2
- California 1
- Illinois 1
- Maryland 1
- Mississippi 1
- Montana 1
- New Jersey 1
- New York 1
- Ohio 1
- Pennsylvania 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381422 | 2381422 | 2022-04-06 | Susquehanna | Pennsylvania | 42115 | 7792 | 108 |
2377114 | 2377114 | 2022-04-05 | Houghton | Michigan | 26061 | 7792 | 90 |
2373862 | 2373862 | 2022-04-04 | Houghton | Michigan | 26061 | 7792 | 90 |
2370609 | 2370609 | 2022-04-03 | Houghton | Michigan | 26061 | 7792 | 90 |
2367356 | 2367356 | 2022-04-02 | Houghton | Michigan | 26061 | 7792 | 90 |
2364103 | 2364103 | 2022-04-01 | Houghton | Michigan | 26061 | 7792 | 90 |
2347105 | 2347105 | 2022-03-27 | Wayne | Georgia | 13305 | 7792 | 205 |
2343852 | 2343852 | 2022-03-26 | Wayne | Georgia | 13305 | 7792 | 205 |
2340599 | 2340599 | 2022-03-25 | Wayne | Georgia | 13305 | 7792 | 205 |
2313592 | 2313592 | 2022-03-16 | Polk | Texas | 48373 | 7792 | 247 |
2310339 | 2310339 | 2022-03-15 | Polk | Texas | 48373 | 7792 | 247 |
2307086 | 2307086 | 2022-03-14 | Polk | Texas | 48373 | 7792 | 247 |
2303835 | 2303835 | 2022-03-13 | Polk | Texas | 48373 | 7792 | 247 |
2201242 | 2201242 | 2022-02-10 | Carter | Kentucky | 21043 | 7792 | 94 |
2119600 | 2119600 | 2022-01-16 | Clinton | Indiana | 18023 | 7792 | 100 |
2116348 | 2116348 | 2022-01-15 | Clinton | Indiana | 18023 | 7792 | 100 |
2113097 | 2113097 | 2022-01-14 | Clinton | Indiana | 18023 | 7792 | 100 |
2005564 | 2005564 | 2021-12-12 | Habersham | Georgia | 13137 | 7792 | 213 |
2002313 | 2002313 | 2021-12-11 | Habersham | Georgia | 13137 | 7792 | 213 |
1999063 | 1999063 | 2021-12-10 | Habersham | Georgia | 13137 | 7792 | 213 |
1937596 | 1937596 | 2021-11-21 | Lawrence | Indiana | 18093 | 7792 | 185 |
1934346 | 1934346 | 2021-11-20 | Lawrence | Indiana | 18093 | 7792 | 185 |
1931095 | 1931095 | 2021-11-19 | Lawrence | Indiana | 18093 | 7792 | 185 |
1847923 | 1847923 | 2021-10-24 | Athens | Ohio | 39009 | 7792 | 79 |
1823866 | 1823866 | 2021-10-17 | Marshall | Indiana | 18099 | 7792 | 138 |
1820617 | 1820617 | 2021-10-16 | Marshall | Indiana | 18099 | 7792 | 138 |
1817368 | 1817368 | 2021-10-15 | Marshall | Indiana | 18099 | 7792 | 138 |
1801426 | 1801426 | 2021-10-10 | Jessamine | Kentucky | 21113 | 7792 | 87 |
1798177 | 1798177 | 2021-10-09 | Jessamine | Kentucky | 21113 | 7792 | 87 |
1794928 | 1794928 | 2021-10-08 | Jessamine | Kentucky | 21113 | 7792 | 87 |
1778944 | 1778944 | 2021-10-03 | Shiawassee | Michigan | 26155 | 7792 | 120 |
1775694 | 1775694 | 2021-10-02 | Shiawassee | Michigan | 26155 | 7792 | 120 |
1772444 | 1772444 | 2021-10-01 | Shiawassee | Michigan | 26155 | 7792 | 120 |
1755605 | 1755605 | 2021-09-26 | Dubois | Indiana | 18037 | 7792 | 124 |
1752357 | 1752357 | 2021-09-25 | Dubois | Indiana | 18037 | 7792 | 124 |
1749108 | 1749108 | 2021-09-24 | Dubois | Indiana | 18037 | 7792 | 124 |
1609492 | 1609492 | 2021-08-12 | Wayne | Indiana | 18177 | 7792 | 206 |
1610157 | 1610157 | 2021-08-12 | Lowndes | Mississippi | 28087 | 7792 | 153 |
1601399 | 1601399 | 2021-08-09 | Laurens | South Carolina | 45059 | 7792 | 172 |
1314044 | 1314044 | 2021-05-13 | Warrick | Indiana | 18173 | 7792 | 158 |
1293604 | 1293604 | 2021-05-06 | Kitsap | Washington | 53035 | 7792 | 107 |
1155989 | 1155989 | 2021-03-25 | Chautauqua | New York | 36013 | 7792 | 130 |
1113550 | 1113550 | 2021-03-12 | Cascade | Montana | 30013 | 7792 | 150 |
1042865 | 1042865 | 2021-02-18 | Carolina | Puerto Rico | 72031 | 7792 | |
927673 | 927673 | 2021-01-14 | Kosciusko | Indiana | 18085 | 7792 | 78 |
871988 | 871988 | 2020-12-28 | Shasta | California | 6089 | 7792 | 70 |
826143 | 826143 | 2020-12-13 | Franklin | Washington | 53021 | 7792 | 76 |
723255 | 723255 | 2020-11-12 | Vanderburgh | Indiana | 18163 | 7792 | 96 |
532983 | 532983 | 2020-09-14 | Morris | New Jersey | 34027 | 7792 | 831 |
448341 | 448341 | 2020-08-19 | Anne Arundel | Maryland | 24003 | 7792 | 229 |
381919 | 381919 | 2020-07-29 | Horry | South Carolina | 45051 | 7792 | 121 |
290861 | 290861 | 2020-07-01 | Kane | Illinois | 17089 | 7792 | 272 |
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);