ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 7591 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- North Carolina 7
- Georgia 6
- Texas 5
- Illinois 4
- Missouri 4
- California 3
- Pennsylvania 3
- South Carolina 3
- West Virginia 3
- Minnesota 2
- North Dakota 2
- Ohio 2
- Wisconsin 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Florida 1
- Massachusetts 1
- New Hampshire 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2362743 | 2362743 | 2022-03-31 | Clark | Wisconsin | 55019 | 7591 | 121 |
2333741 | 2333741 | 2022-03-23 | Calaveras | California | 6009 | 7591 | 120 |
2330487 | 2330487 | 2022-03-22 | Calaveras | California | 6009 | 7591 | 119 |
2271664 | 2271664 | 2022-03-03 | Clark | Wisconsin | 55019 | 7591 | 117 |
2182786 | 2182786 | 2022-02-04 | Fayette | Ohio | 39047 | 7591 | 100 |
2183024 | 2183024 | 2022-02-04 | Tioga | Pennsylvania | 42117 | 7591 | 186 |
2180203 | 2180203 | 2022-02-03 | Kendall | Texas | 48259 | 7591 | 107 |
2169251 | 2169251 | 2022-01-31 | Marion | Missouri | 29127 | 7591 | 110 |
2150461 | 2150461 | 2022-01-25 | Greene | Pennsylvania | 42059 | 7591 | 92 |
2084700 | 2084700 | 2022-01-05 | Platte | Missouri | 29165 | 7591 | 78 |
2029845 | 2029845 | 2021-12-19 | Richmond | North Carolina | 37153 | 7591 | 150 |
2026594 | 2026594 | 2021-12-18 | Richmond | North Carolina | 37153 | 7591 | 150 |
2023343 | 2023343 | 2021-12-17 | Richmond | North Carolina | 37153 | 7591 | 150 |
2009734 | 2009734 | 2021-12-13 | Mower | Minnesota | 27099 | 7591 | 50 |
1991754 | 1991754 | 2021-12-07 | Summit | Utah | 49043 | 7591 | 19 |
1970010 | 1970010 | 2021-12-01 | Macoupin | Illinois | 17117 | 7591 | 145 |
1899357 | 1899357 | 2021-11-09 | Callaway | Missouri | 29027 | 7591 | 72 |
1833284 | 1833284 | 2021-10-20 | Colquitt | Georgia | 13071 | 7591 | 177 |
1812183 | 1812183 | 2021-10-13 | Athens | Ohio | 39009 | 7591 | 71 |
1781142 | 1781142 | 2021-10-04 | Fremont | Colorado | 8043 | 7591 | 77 |
1765153 | 1765153 | 2021-09-29 | Thomas | Georgia | 13275 | 7591 | 167 |
1744511 | 1744511 | 2021-09-22 | Anderson | Texas | 48001 | 7591 | 162 |
1711374 | 1711374 | 2021-09-12 | Pender | North Carolina | 37141 | 7591 | 81 |
1708127 | 1708127 | 2021-09-11 | Pender | North Carolina | 37141 | 7591 | 81 |
1704880 | 1704880 | 2021-09-10 | Pender | North Carolina | 37141 | 7591 | 81 |
1697635 | 1697635 | 2021-09-08 | Berkshire | Massachusetts | 25003 | 7591 | 304 |
1641197 | 1641197 | 2021-08-22 | Coffee | Alabama | 1031 | 7591 | 143 |
1643620 | 1643620 | 2021-08-22 | Georgetown | South Carolina | 45043 | 7591 | 147 |
1640370 | 1640370 | 2021-08-21 | Georgetown | South Carolina | 45043 | 7591 | 147 |
1637120 | 1637120 | 2021-08-20 | Georgetown | South Carolina | 45043 | 7591 | 147 |
1553602 | 1553602 | 2021-07-26 | Crawford | Arkansas | 5033 | 7591 | 125 |
1355994 | 1355994 | 2021-05-26 | Troup | Georgia | 13285 | 7591 | 230 |
1304052 | 1304052 | 2021-05-10 | Walker | Georgia | 13295 | 7591 | 87 |
1274808 | 1274808 | 2021-05-01 | Rockdale | Georgia | 13247 | 7591 | 171 |
1244977 | 1244977 | 2021-04-21 | Wood | West Virginia | 54107 | 7591 | 168 |
1238101 | 1238101 | 2021-04-19 | Liberty | Texas | 48291 | 7591 | 178 |
1084314 | 1084314 | 2021-03-03 | St. Francois | Missouri | 29187 | 7591 | 107 |
1050592 | 1050592 | 2021-02-21 | Columbia | Florida | 12023 | 7591 | 155 |
1040377 | 1040377 | 2021-02-17 | Cabell | West Virginia | 54011 | 7591 | 158 |
1029506 | 1029506 | 2021-02-14 | Moore | North Carolina | 37125 | 7591 | 160 |
1030666 | 1030666 | 2021-02-14 | Monongalia | West Virginia | 54061 | 7591 | 68 |
963228 | 963228 | 2021-01-25 | Adams | Illinois | 17001 | 7591 | 129 |
947092 | 947092 | 2021-01-20 | Vermilion | Illinois | 17183 | 7591 | 115 |
876398 | 876398 | 2020-12-29 | Sherburne | Minnesota | 27141 | 7591 | 57 |
867535 | 867535 | 2020-12-26 | Blair | Pennsylvania | 42013 | 7591 | 163 |
833462 | 833462 | 2020-12-16 | Kendall | Illinois | 17093 | 7591 | 67 |
794364 | 794364 | 2020-12-04 | Muscogee | Georgia | 13215 | 7591 | 196 |
779697 | 779697 | 2020-11-29 | Ward | North Dakota | 38101 | 7591 | 129 |
750217 | 750217 | 2020-11-20 | Hillsborough | New Hampshire | 33011 | 7591 | 331 |
692049 | 692049 | 2020-11-02 | Burleigh | North Dakota | 38015 | 7591 | 80 |
677298 | 677298 | 2020-10-29 | Solano | California | 6095 | 7591 | 76 |
427183 | 427183 | 2020-08-12 | Brazoria | Texas | 48039 | 7591 | 100 |
423959 | 423959 | 2020-08-11 | Brazoria | Texas | 48039 | 7591 | 96 |
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);