ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 9973 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Tennessee 14
- Alaska 5
- North Carolina 4
- Alabama 3
- Georgia 3
- Virginia 3
- Pennsylvania 2
- Colorado 1
- Florida 1
- Indiana 1
- Kentucky 1
- Michigan 1
- Montana 1
- New Hampshire 1
- New York 1
- North Dakota 1
- Ohio 1
- Puerto Rico 1
- South Carolina 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375910 | 2375910 | 2022-04-05 | Bethel Census Area | Alaska | 2050 | 9973 | 41 |
2372658 | 2372658 | 2022-04-04 | Bethel Census Area | Alaska | 2050 | 9973 | 41 |
2369405 | 2369405 | 2022-04-03 | Bethel Census Area | Alaska | 2050 | 9973 | 41 |
2366152 | 2366152 | 2022-04-02 | Bethel Census Area | Alaska | 2050 | 9973 | 41 |
2362899 | 2362899 | 2022-04-01 | Bethel Census Area | Alaska | 2050 | 9973 | 41 |
2355652 | 2355652 | 2022-03-29 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2352399 | 2352399 | 2022-03-28 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2349147 | 2349147 | 2022-03-27 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2345894 | 2345894 | 2022-03-26 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2342641 | 2342641 | 2022-03-25 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2339388 | 2339388 | 2022-03-24 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2336134 | 2336134 | 2022-03-23 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2304299 | 2304299 | 2022-03-14 | Escambia | Alabama | 1053 | 9973 | 165 |
2245796 | 2245796 | 2022-02-24 | Russell | Alabama | 1113 | 9973 | 78 |
2192866 | 2192866 | 2022-02-07 | Vega Baja | Puerto Rico | 72145 | 9973 | |
2150785 | 2150785 | 2022-01-25 | Warren | Tennessee | 47177 | 9973 | 154 |
2147533 | 2147533 | 2022-01-24 | Warren | Tennessee | 47177 | 9973 | 154 |
2142153 | 2142153 | 2022-01-23 | Murray | Georgia | 13213 | 9973 | 153 |
2144279 | 2144279 | 2022-01-23 | Warren | Tennessee | 47177 | 9973 | 154 |
2138898 | 2138898 | 2022-01-22 | Murray | Georgia | 13213 | 9973 | 153 |
2141024 | 2141024 | 2022-01-22 | Warren | Tennessee | 47177 | 9973 | 154 |
2135642 | 2135642 | 2022-01-21 | Murray | Georgia | 13213 | 9973 | 153 |
2137768 | 2137768 | 2022-01-21 | Warren | Tennessee | 47177 | 9973 | 154 |
2134514 | 2134514 | 2022-01-20 | Warren | Tennessee | 47177 | 9973 | 154 |
2131262 | 2131262 | 2022-01-19 | Warren | Tennessee | 47177 | 9973 | 154 |
1827455 | 1827455 | 2021-10-18 | Oldham | Kentucky | 21185 | 9973 | 91 |
1734124 | 1734124 | 2021-09-19 | Rutherford | North Carolina | 37161 | 9973 | 275 |
1730874 | 1730874 | 2021-09-18 | Rutherford | North Carolina | 37161 | 9973 | 275 |
1727624 | 1727624 | 2021-09-17 | Rutherford | North Carolina | 37161 | 9973 | 275 |
1695597 | 1695597 | 2021-09-07 | Greenwood | South Carolina | 45047 | 9973 | 177 |
1666927 | 1666927 | 2021-08-29 | Montgomery | Virginia | 51121 | 9973 | 83 |
1663679 | 1663679 | 2021-08-28 | Montgomery | Virginia | 51121 | 9973 | 83 |
1660431 | 1660431 | 2021-08-27 | Montgomery | Virginia | 51121 | 9973 | 83 |
1585922 | 1585922 | 2021-08-04 | St. Croix | Wisconsin | 55109 | 9973 | 72 |
1484097 | 1484097 | 2021-07-04 | Ward | North Dakota | 38101 | 9973 | 200 |
1423609 | 1423609 | 2021-06-15 | Laramie | Wyoming | 56021 | 9973 | 119 |
1405935 | 1405935 | 2021-06-10 | Strafford | New Hampshire | 33017 | 9973 | 95 |
1332792 | 1332792 | 2021-05-19 | St. Clair | Alabama | 1115 | 9973 | 245 |
1172261 | 1172261 | 2021-03-30 | Rensselaer | New York | 36083 | 9973 | 133 |
1112261 | 1112261 | 2021-03-12 | Citrus | Florida | 12017 | 9973 | 416 |
1106693 | 1106693 | 2021-03-10 | Calhoun | Michigan | 26025 | 9973 | 237 |
990718 | 990718 | 2021-02-02 | Portage | Ohio | 39133 | 9973 | 115 |
927640 | 927640 | 2021-01-14 | Clark | Indiana | 18019 | 9973 | 136 |
925958 | 925958 | 2021-01-13 | Centre | Pennsylvania | 42027 | 9973 | 162 |
870794 | 870794 | 2020-12-27 | Cumberland | Pennsylvania | 42041 | 9973 | 282 |
854203 | 854203 | 2020-12-22 | Cabarrus | North Carolina | 37025 | 9973 | 125 |
755176 | 755176 | 2020-11-22 | Boulder | Colorado | 8013 | 9973 | 115 |
753347 | 753347 | 2020-11-21 | Yellowstone | Montana | 30111 | 9973 | 112 |
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);