ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 7874 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Texas 15
- Louisiana 13
- Illinois 5
- Michigan 5
- Georgia 4
- Pennsylvania 3
- Alaska 2
- Nebraska 2
- New Jersey 2
- New York 2
- North Carolina 2
- Tennessee 2
- Virginia 2
- West Virginia 2
- Kentucky 1
- New Mexico 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464869 | 2464869 | 2022-05-02 | Allen | Louisiana | 22003 | 7874 | 139 |
2461613 | 2461613 | 2022-05-01 | Allen | Louisiana | 22003 | 7874 | 139 |
2458357 | 2458357 | 2022-04-30 | Allen | Louisiana | 22003 | 7874 | 139 |
2455101 | 2455101 | 2022-04-29 | Allen | Louisiana | 22003 | 7874 | 139 |
2451845 | 2451845 | 2022-04-28 | Allen | Louisiana | 22003 | 7874 | 139 |
2448589 | 2448589 | 2022-04-27 | Allen | Louisiana | 22003 | 7874 | 139 |
2445333 | 2445333 | 2022-04-26 | Allen | Louisiana | 22003 | 7874 | 139 |
2442077 | 2442077 | 2022-04-25 | Allen | Louisiana | 22003 | 7874 | 137 |
2438821 | 2438821 | 2022-04-24 | Allen | Louisiana | 22003 | 7874 | 137 |
2435565 | 2435565 | 2022-04-23 | Allen | Louisiana | 22003 | 7874 | 137 |
2432309 | 2432309 | 2022-04-22 | Allen | Louisiana | 22003 | 7874 | 137 |
2429053 | 2429053 | 2022-04-21 | Allen | Louisiana | 22003 | 7874 | 137 |
2425797 | 2425797 | 2022-04-20 | Allen | Louisiana | 22003 | 7874 | 137 |
2417765 | 2417765 | 2022-04-17 | Upshur | Texas | 48459 | 7874 | 182 |
2414509 | 2414509 | 2022-04-16 | Upshur | Texas | 48459 | 7874 | 182 |
2411253 | 2411253 | 2022-04-15 | Upshur | Texas | 48459 | 7874 | 182 |
2407997 | 2407997 | 2022-04-14 | Upshur | Texas | 48459 | 7874 | 182 |
2267572 | 2267572 | 2022-03-02 | Tioga | Pennsylvania | 42117 | 7874 | 189 |
2240257 | 2240257 | 2022-02-22 | Calloway | Kentucky | 21035 | 7874 | 81 |
2222395 | 2222395 | 2022-02-16 | Cherokee | Texas | 48073 | 7874 | 243 |
2154740 | 2154740 | 2022-01-27 | Bethel Census Area | Alaska | 2050 | 7874 | 37 |
2151487 | 2151487 | 2022-01-26 | Bethel Census Area | Alaska | 2050 | 7874 | 37 |
2148053 | 2148053 | 2022-01-24 | Preston | West Virginia | 54077 | 7874 | 114 |
2142063 | 2142063 | 2022-01-23 | Bryan | Georgia | 13029 | 7874 | 78 |
2138808 | 2138808 | 2022-01-22 | Bryan | Georgia | 13029 | 7874 | 78 |
2135552 | 2135552 | 2022-01-21 | Bryan | Georgia | 13029 | 7874 | 78 |
2012033 | 2012033 | 2021-12-14 | Colquitt | Georgia | 13071 | 7874 | 203 |
2011326 | 2011326 | 2021-12-13 | Fauquier | Virginia | 51061 | 7874 | 92 |
2000505 | 2000505 | 2021-12-10 | Warren | New York | 36113 | 7874 | 100 |
1960857 | 1960857 | 2021-11-28 | Cass | Michigan | 26027 | 7874 | 101 |
1957606 | 1957606 | 2021-11-27 | Cass | Michigan | 26027 | 7874 | 101 |
1954355 | 1954355 | 2021-11-26 | Cass | Michigan | 26027 | 7874 | 101 |
1951104 | 1951104 | 2021-11-25 | Cass | Michigan | 26027 | 7874 | 101 |
1947853 | 1947853 | 2021-11-24 | Cass | Michigan | 26027 | 7874 | 101 |
1937478 | 1937478 | 2021-11-21 | Grundy | Illinois | 17063 | 7874 | 94 |
1934228 | 1934228 | 2021-11-20 | Grundy | Illinois | 17063 | 7874 | 94 |
1930977 | 1930977 | 2021-11-19 | Grundy | Illinois | 17063 | 7874 | 94 |
1933143 | 1933143 | 2021-11-19 | Nacogdoches | Texas | 48347 | 7874 | 233 |
1929892 | 1929892 | 2021-11-18 | Nacogdoches | Texas | 48347 | 7874 | 233 |
1926642 | 1926642 | 2021-11-17 | Nacogdoches | Texas | 48347 | 7874 | 233 |
1923392 | 1923392 | 2021-11-16 | Nacogdoches | Texas | 48347 | 7874 | 233 |
1920143 | 1920143 | 2021-11-15 | Nacogdoches | Texas | 48347 | 7874 | 233 |
1916893 | 1916893 | 2021-11-14 | Nacogdoches | Texas | 48347 | 7874 | 233 |
1913643 | 1913643 | 2021-11-13 | Nacogdoches | Texas | 48347 | 7874 | 233 |
1877371 | 1877371 | 2021-11-02 | Bradford | Pennsylvania | 42015 | 7874 | 123 |
1828195 | 1828195 | 2021-10-18 | Otero | New Mexico | 35035 | 7874 | 97 |
1783700 | 1783700 | 2021-10-04 | Rusk | Texas | 48401 | 7874 | 155 |
1780451 | 1780451 | 2021-10-03 | Rusk | Texas | 48401 | 7874 | 155 |
1777201 | 1777201 | 2021-10-02 | Rusk | Texas | 48401 | 7874 | 155 |
1719840 | 1719840 | 2021-09-15 | Whiteside | Illinois | 17195 | 7874 | 218 |
1676226 | 1676226 | 2021-09-01 | Hawkins | Tennessee | 47073 | 7874 | 130 |
1654066 | 1654066 | 2021-08-25 | Raleigh | West Virginia | 54081 | 7874 | 108 |
1581759 | 1581759 | 2021-08-03 | Lawrence | Pennsylvania | 42073 | 7874 | 218 |
1451296 | 1451296 | 2021-06-24 | Hall | Nebraska | 31079 | 7874 | 120 |
1448050 | 1448050 | 2021-06-23 | Hall | Nebraska | 31079 | 7874 | 120 |
1289268 | 1289268 | 2021-05-05 | Sampson | North Carolina | 37163 | 7874 | 108 |
1214588 | 1214588 | 2021-04-12 | Surry | North Carolina | 37171 | 7874 | 156 |
1147429 | 1147429 | 2021-03-22 | Roanoke city | Virginia | 51770 | 7874 | 177 |
1059278 | 1059278 | 2021-02-23 | Anderson | Tennessee | 47001 | 7874 | 155 |
980736 | 980736 | 2021-01-30 | Rensselaer | New York | 36083 | 7874 | 116 |
969736 | 969736 | 2021-01-27 | DeKalb | Illinois | 17037 | 7874 | 99 |
511610 | 511610 | 2020-09-07 | Pierce | Washington | 53053 | 7874 | 193 |
345988 | 345988 | 2020-07-18 | Camden | New Jersey | 34007 | 7874 | 557 |
42078 | 42078 | 2020-04-08 | Bergen | New Jersey | 34003 | 7874 | 314 |
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);