ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 6377 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Kansas 7
- Kentucky 7
- Tennessee 7
- Louisiana 6
- North Carolina 6
- Colorado 5
- Michigan 4
- South Carolina 4
- Texas 4
- Virginia 4
- Arkansas 2
- Ohio 2
- Pennsylvania 2
- Alaska 1
- Idaho 1
- Illinois 1
- Indiana 1
- Mississippi 1
- Missouri 1
- Nevada 1
- New York 1
- Oregon 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369634 | 2369634 | 2022-04-03 | Routt | Colorado | 8107 | 6377 | 25 |
2366381 | 2366381 | 2022-04-02 | Routt | Colorado | 8107 | 6377 | 25 |
2363128 | 2363128 | 2022-04-01 | Routt | Colorado | 8107 | 6377 | 25 |
2356615 | 2356615 | 2022-03-30 | Pitkin | Colorado | 8097 | 6377 | 6 |
2347639 | 2347639 | 2022-03-27 | Marion | Kentucky | 21155 | 6377 | 80 |
2344386 | 2344386 | 2022-03-26 | Marion | Kentucky | 21155 | 6377 | 80 |
2341133 | 2341133 | 2022-03-25 | Marion | Kentucky | 21155 | 6377 | 80 |
2337880 | 2337880 | 2022-03-24 | Marion | Kentucky | 21155 | 6377 | 80 |
2334626 | 2334626 | 2022-03-23 | Marion | Kentucky | 21155 | 6377 | 80 |
2331372 | 2331372 | 2022-03-22 | Marion | Kentucky | 21155 | 6377 | 80 |
2328120 | 2328120 | 2022-03-21 | Marion | Kentucky | 21155 | 6377 | 80 |
2268621 | 2268621 | 2022-03-03 | Cleburne | Arkansas | 5023 | 6377 | 121 |
2266405 | 2266405 | 2022-03-02 | Plaquemines | Louisiana | 22075 | 6377 | 44 |
2210879 | 2210879 | 2022-02-13 | Barton | Kansas | 20009 | 6377 | 85 |
2207626 | 2207626 | 2022-02-12 | Barton | Kansas | 20009 | 6377 | 85 |
2204373 | 2204373 | 2022-02-11 | Barton | Kansas | 20009 | 6377 | 85 |
2201120 | 2201120 | 2022-02-10 | Barton | Kansas | 20009 | 6377 | 85 |
2197866 | 2197866 | 2022-02-09 | Barton | Kansas | 20009 | 6377 | 85 |
2199066 | 2199066 | 2022-02-09 | Hocking | Ohio | 39073 | 6377 | 111 |
2183442 | 2183442 | 2022-02-04 | Hutchinson | Texas | 48233 | 6377 | 124 |
2173926 | 2173926 | 2022-02-01 | Halifax | Virginia | 51083 | 6377 | 129 |
2167972 | 2167972 | 2022-01-31 | Logan | Colorado | 8075 | 6377 | 104 |
2166360 | 2166360 | 2022-01-30 | Cherokee | North Carolina | 37039 | 6377 | 91 |
2163105 | 2163105 | 2022-01-29 | Cherokee | North Carolina | 37039 | 6377 | 91 |
2159850 | 2159850 | 2022-01-28 | Cherokee | North Carolina | 37039 | 6377 | 91 |
2142841 | 2142841 | 2022-01-23 | West Baton Rouge | Louisiana | 22121 | 6377 | 80 |
2139586 | 2139586 | 2022-01-22 | West Baton Rouge | Louisiana | 22121 | 6377 | 80 |
2136330 | 2136330 | 2022-01-21 | West Baton Rouge | Louisiana | 22121 | 6377 | 80 |
2132073 | 2132073 | 2022-01-20 | St. Francis | Arkansas | 5123 | 6377 | 74 |
2077269 | 2077269 | 2022-01-03 | Logan | Illinois | 17107 | 6377 | 91 |
1966695 | 1966695 | 2021-11-30 | Nez Perce | Idaho | 16069 | 6377 | 105 |
1944125 | 1944125 | 2021-11-23 | Steuben | Indiana | 18151 | 6377 | 88 |
1922691 | 1922691 | 2021-11-16 | Highland | Ohio | 39071 | 6377 | 111 |
1889608 | 1889608 | 2021-11-06 | Camden | Missouri | 29029 | 6377 | 125 |
1887543 | 1887543 | 2021-11-05 | Erath | Texas | 48143 | 6377 | 102 |
1871034 | 1871034 | 2021-10-31 | Dillon | South Carolina | 45033 | 6377 | 114 |
1867785 | 1867785 | 2021-10-30 | Dillon | South Carolina | 45033 | 6377 | 114 |
1864536 | 1864536 | 2021-10-29 | Dillon | South Carolina | 45033 | 6377 | 114 |
1835816 | 1835816 | 2021-10-20 | Culpeper | Virginia | 51047 | 6377 | 82 |
1830915 | 1830915 | 2021-10-19 | Newaygo | Michigan | 26123 | 6377 | 80 |
1827666 | 1827666 | 2021-10-18 | Newaygo | Michigan | 26123 | 6377 | 80 |
1815140 | 1815140 | 2021-10-14 | Lyon | Nevada | 32019 | 6377 | 99 |
1767207 | 1767207 | 2021-09-29 | Lincoln | Tennessee | 47103 | 6377 | 79 |
1759286 | 1759286 | 2021-09-27 | Natchitoches | Louisiana | 22069 | 6377 | 126 |
1723854 | 1723854 | 2021-09-16 | Neshoba | Mississippi | 28099 | 6377 | 201 |
1682483 | 1682483 | 2021-09-03 | Union | Pennsylvania | 42119 | 6377 | 90 |
1629366 | 1629366 | 2021-08-18 | Washington | Louisiana | 22117 | 6377 | 159 |
1591838 | 1591838 | 2021-08-06 | Atascosa | Texas | 48013 | 6377 | 154 |
1578459 | 1578459 | 2021-08-02 | Linn | Oregon | 41043 | 6377 | 82 |
1535842 | 1535842 | 2021-07-20 | Cayuga | New York | 36011 | 6377 | 92 |
1536731 | 1536731 | 2021-07-20 | Hunt | Texas | 48231 | 6377 | 180 |
1448940 | 1448940 | 2021-06-23 | Roane | Tennessee | 47145 | 6377 | 107 |
1439205 | 1439205 | 2021-06-20 | Roane | Tennessee | 47145 | 6377 | 107 |
1435958 | 1435958 | 2021-06-19 | Roane | Tennessee | 47145 | 6377 | 107 |
1432711 | 1432711 | 2021-06-18 | Roane | Tennessee | 47145 | 6377 | 107 |
1403176 | 1403176 | 2021-06-09 | Carbon | Pennsylvania | 42025 | 6377 | 173 |
1356780 | 1356780 | 2021-05-26 | Shiawassee | Michigan | 26155 | 6377 | 103 |
1241562 | 1241562 | 2021-04-20 | Harrisonburg city | Virginia | 51660 | 6377 | 94 |
1127352 | 1127352 | 2021-03-16 | Georgetown | South Carolina | 45043 | 6377 | 136 |
1121745 | 1121745 | 2021-03-15 | Fairbanks North Star Borough | Alaska | 2090 | 6377 | 29 |
974274 | 974274 | 2021-01-28 | Brunswick | North Carolina | 37019 | 6377 | 93 |
969020 | 969020 | 2021-01-26 | Wood | West Virginia | 54107 | 6377 | 101 |
837033 | 837033 | 2020-12-17 | Reno | Kansas | 20155 | 6377 | 81 |
833787 | 833787 | 2020-12-16 | Reno | Kansas | 20155 | 6377 | 81 |
818562 | 818562 | 2020-12-11 | Randolph | North Carolina | 37151 | 6377 | 101 |
802887 | 802887 | 2020-12-06 | Blount | Tennessee | 47009 | 6377 | 65 |
741315 | 741315 | 2020-11-17 | Wilson | Tennessee | 47189 | 6377 | 69 |
714022 | 714022 | 2020-11-09 | Kalamazoo | Michigan | 26077 | 6377 | 131 |
524462 | 524462 | 2020-09-11 | Loudoun | Virginia | 51107 | 6377 | 118 |
461985 | 461985 | 2020-08-23 | Guilford | North Carolina | 37081 | 6377 | 163 |
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);