ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 8747 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Indiana 10
- Kentucky 7
- Tennessee 7
- Illinois 4
- Arkansas 3
- Michigan 3
- Missouri 3
- Texas 3
- Alabama 2
- Pennsylvania 2
- California 1
- Connecticut 1
- Maryland 1
- Minnesota 1
- North Dakota 1
- Ohio 1
- South Carolina 1
- Utah 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375953 | 2375953 | 2022-04-05 | Baxter | Arkansas | 5005 | 8747 | 247 |
2372701 | 2372701 | 2022-04-04 | Baxter | Arkansas | 5005 | 8747 | 247 |
2142438 | 2142438 | 2022-01-23 | Steuben | Indiana | 18151 | 8747 | 108 |
2139183 | 2139183 | 2022-01-22 | Steuben | Indiana | 18151 | 8747 | 108 |
2135927 | 2135927 | 2022-01-21 | Steuben | Indiana | 18151 | 8747 | 108 |
2127933 | 2127933 | 2022-01-18 | Cocke | Tennessee | 47029 | 8747 | 171 |
2124681 | 2124681 | 2022-01-17 | Cocke | Tennessee | 47029 | 8747 | 171 |
2119642 | 2119642 | 2022-01-16 | Montgomery | Indiana | 18107 | 8747 | 142 |
2121429 | 2121429 | 2022-01-16 | Cocke | Tennessee | 47029 | 8747 | 171 |
2116390 | 2116390 | 2022-01-15 | Montgomery | Indiana | 18107 | 8747 | 142 |
2118177 | 2118177 | 2022-01-15 | Cocke | Tennessee | 47029 | 8747 | 171 |
2113139 | 2113139 | 2022-01-14 | Montgomery | Indiana | 18107 | 8747 | 142 |
2114926 | 2114926 | 2022-01-14 | Cocke | Tennessee | 47029 | 8747 | 171 |
2111674 | 2111674 | 2022-01-13 | Cocke | Tennessee | 47029 | 8747 | 171 |
2108422 | 2108422 | 2022-01-12 | Cocke | Tennessee | 47029 | 8747 | 171 |
2060307 | 2060307 | 2021-12-28 | Oconto | Wisconsin | 55083 | 8747 | 88 |
2028914 | 2028914 | 2021-12-19 | Henderson | Kentucky | 21101 | 8747 | 129 |
2025663 | 2025663 | 2021-12-18 | Henderson | Kentucky | 21101 | 8747 | 129 |
2022412 | 2022412 | 2021-12-17 | Henderson | Kentucky | 21101 | 8747 | 129 |
1989061 | 1989061 | 2021-12-07 | Mendocino | California | 6045 | 8747 | 99 |
1975234 | 1975234 | 2021-12-02 | Atascosa | Texas | 48013 | 8747 | 207 |
1971985 | 1971985 | 2021-12-01 | Atascosa | Texas | 48013 | 8747 | 206 |
1937606 | 1937606 | 2021-11-21 | Noble | Indiana | 18113 | 8747 | 122 |
1934356 | 1934356 | 2021-11-20 | Noble | Indiana | 18113 | 8747 | 122 |
1931105 | 1931105 | 2021-11-19 | Noble | Indiana | 18113 | 8747 | 122 |
1855494 | 1855494 | 2021-10-26 | Putnam | West Virginia | 54079 | 8747 | 123 |
1847068 | 1847068 | 2021-10-24 | Cecil | Maryland | 24015 | 8747 | 175 |
1762640 | 1762640 | 2021-09-28 | Clinton | Michigan | 26037 | 8747 | 102 |
1759391 | 1759391 | 2021-09-27 | Clinton | Michigan | 26037 | 8747 | 102 |
1721424 | 1721424 | 2021-09-15 | Crawford | Pennsylvania | 42039 | 8747 | 166 |
1459924 | 1459924 | 2021-06-27 | Adams | Illinois | 17001 | 8747 | 156 |
1456679 | 1456679 | 2021-06-26 | Adams | Illinois | 17001 | 8747 | 156 |
1453434 | 1453434 | 2021-06-25 | Adams | Illinois | 17001 | 8747 | 156 |
1301287 | 1301287 | 2021-05-09 | Campbell | Kentucky | 21037 | 8747 | 83 |
1298040 | 1298040 | 2021-05-08 | Campbell | Kentucky | 21037 | 8747 | 83 |
1294794 | 1294794 | 2021-05-07 | Campbell | Kentucky | 21037 | 8747 | 83 |
1212623 | 1212623 | 2021-04-12 | DeKalb | Alabama | 1049 | 8747 | 181 |
1210869 | 1210869 | 2021-04-11 | Christian | Missouri | 29043 | 8747 | 88 |
1211657 | 1211657 | 2021-04-11 | Mercer | Pennsylvania | 42085 | 8747 | 250 |
1207620 | 1207620 | 2021-04-10 | Christian | Missouri | 29043 | 8747 | 88 |
1204372 | 1204372 | 2021-04-09 | Christian | Missouri | 29043 | 8747 | 88 |
1190173 | 1190173 | 2021-04-05 | Tolland | Connecticut | 9013 | 8747 | 177 |
1143601 | 1143601 | 2021-03-21 | Oconee | South Carolina | 45073 | 8747 | 131 |
1125609 | 1125609 | 2021-03-16 | Vermilion | Illinois | 17183 | 8747 | 136 |
1056810 | 1056810 | 2021-02-23 | St. Clair | Alabama | 1115 | 8747 | 214 |
1020470 | 1020470 | 2021-02-11 | Comal | Texas | 48091 | 8747 | 269 |
938718 | 938718 | 2021-01-17 | Ward | North Dakota | 38101 | 8747 | 184 |
905219 | 905219 | 2021-01-07 | Boone | Kentucky | 21015 | 8747 | 45 |
856318 | 856318 | 2020-12-23 | Vigo | Indiana | 18167 | 8747 | 142 |
851130 | 851130 | 2020-12-21 | Greene | Ohio | 39057 | 8747 | 103 |
779040 | 779040 | 2020-11-29 | St. Louis | Minnesota | 27137 | 8747 | 112 |
746510 | 746510 | 2020-11-19 | Washtenaw | Michigan | 26161 | 8747 | 137 |
718888 | 718888 | 2020-11-10 | Weber | Utah | 49057 | 8747 | 37 |
693396 | 693396 | 2020-11-03 | Benton | Arkansas | 5007 | 8747 | 127 |
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);