ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 8651 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Oklahoma 7
- Indiana 4
- Texas 4
- Kentucky 3
- Georgia 2
- New York 2
- North Carolina 2
- Ohio 2
- Pennsylvania 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Idaho 1
- Illinois 1
- Louisiana 1
- Minnesota 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- New Jersey 1
- North Dakota 1
- Tennessee 1
- Virginia 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476368 | 2476368 | 2022-05-05 | Titus | Texas | 48449 | 8651 | 128 |
2403767 | 2403767 | 2022-04-13 | Orleans | New York | 36073 | 8651 | 113 |
2384219 | 2384219 | 2022-04-07 | Greene | New York | 36039 | 8651 | 125 |
2332996 | 2332996 | 2022-03-22 | Erath | Texas | 48143 | 8651 | 123 |
2304839 | 2304839 | 2022-03-14 | Bonner | Idaho | 16017 | 8651 | 177 |
2260470 | 2260470 | 2022-02-28 | Lincoln | Nebraska | 31111 | 8651 | 107 |
2256603 | 2256603 | 2022-02-27 | Taylor | Kentucky | 21217 | 8651 | 113 |
2253352 | 2253352 | 2022-02-26 | Taylor | Kentucky | 21217 | 8651 | 113 |
2250101 | 2250101 | 2022-02-25 | Taylor | Kentucky | 21217 | 8651 | 113 |
2092420 | 2092420 | 2022-01-07 | Nacogdoches | Texas | 48347 | 8651 | 240 |
2085977 | 2085977 | 2022-01-05 | Van Zandt | Texas | 48467 | 8651 | 236 |
2013935 | 2013935 | 2021-12-14 | Venango | Pennsylvania | 42121 | 8651 | 184 |
1955148 | 1955148 | 2021-11-26 | Stark | North Dakota | 38089 | 8651 | 73 |
1884215 | 1884215 | 2021-11-04 | Warren | Tennessee | 47177 | 8651 | 122 |
1854513 | 1854513 | 2021-10-26 | Bryan | Oklahoma | 40013 | 8651 | 106 |
1851264 | 1851264 | 2021-10-25 | Bryan | Oklahoma | 40013 | 8651 | 106 |
1848014 | 1848014 | 2021-10-24 | Bryan | Oklahoma | 40013 | 8651 | 106 |
1844764 | 1844764 | 2021-10-23 | Bryan | Oklahoma | 40013 | 8651 | 106 |
1845745 | 1845745 | 2021-10-23 | Putnam | West Virginia | 54079 | 8651 | 121 |
1841514 | 1841514 | 2021-10-22 | Bryan | Oklahoma | 40013 | 8651 | 106 |
1838265 | 1838265 | 2021-10-21 | Bryan | Oklahoma | 40013 | 8651 | 106 |
1835016 | 1835016 | 2021-10-20 | Bryan | Oklahoma | 40013 | 8651 | 106 |
1812093 | 1812093 | 2021-10-13 | Pender | North Carolina | 37141 | 8651 | 95 |
1743052 | 1743052 | 2021-09-22 | St. Charles | Louisiana | 22089 | 8651 | 120 |
1652320 | 1652320 | 2021-08-25 | Rice | Minnesota | 27131 | 8651 | 113 |
1489269 | 1489269 | 2021-07-06 | Hancock | Indiana | 18059 | 8651 | 150 |
1481075 | 1481075 | 2021-07-03 | Clearfield | Pennsylvania | 42033 | 8651 | 156 |
1441989 | 1441989 | 2021-06-21 | Tuscarawas | Ohio | 39157 | 8651 | 250 |
1211140 | 1211140 | 2021-04-11 | Strafford | New Hampshire | 33017 | 8651 | 76 |
1112676 | 1112676 | 2021-03-12 | Kosciusko | Indiana | 18085 | 8651 | 116 |
1105477 | 1105477 | 2021-03-10 | Lauderdale | Alabama | 1077 | 8651 | 215 |
1099639 | 1099639 | 2021-03-08 | Vermilion | Illinois | 17183 | 8651 | 136 |
1075958 | 1075958 | 2021-02-28 | Hampton city | Virginia | 51650 | 8651 | 111 |
1061946 | 1061946 | 2021-02-24 | Henderson | North Carolina | 37089 | 8651 | 135 |
1020981 | 1020981 | 2021-02-11 | Jefferson | Wisconsin | 55055 | 8651 | 83 |
1015026 | 1015026 | 2021-02-10 | Jackson | Georgia | 13157 | 8651 | 116 |
989328 | 989328 | 2021-02-02 | Howard | Indiana | 18067 | 8651 | 156 |
951158 | 951158 | 2021-01-21 | Cape Girardeau | Missouri | 29031 | 8651 | 131 |
870583 | 870583 | 2020-12-27 | Clark | Ohio | 39023 | 8651 | 179 |
849828 | 849828 | 2020-12-21 | Vigo | Indiana | 18167 | 8651 | 142 |
813756 | 813756 | 2020-12-10 | Clarke | Georgia | 13059 | 8651 | 57 |
755205 | 755205 | 2020-11-22 | Larimer | Colorado | 8069 | 8651 | 66 |
690153 | 690153 | 2020-11-02 | Benton | Arkansas | 5007 | 8651 | 127 |
568597 | 568597 | 2020-09-25 | Mercer | New Jersey | 34021 | 8651 | 635 |
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);