ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 9296 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- North Carolina 10
- West Virginia 5
- New York 4
- Texas 4
- Indiana 3
- Montana 3
- New Hampshire 3
- Ohio 3
- Massachusetts 2
- Virginia 2
- Arkansas 1
- California 1
- Hawaii 1
- Kentucky 1
- Michigan 1
- Minnesota 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444096 | 2444096 | 2022-04-25 | Preston | West Virginia | 54077 | 9296 | 135 |
2423399 | 2423399 | 2022-04-19 | Person | North Carolina | 37145 | 9296 | 104 |
2420142 | 2420142 | 2022-04-18 | Person | North Carolina | 37145 | 9296 | 104 |
2416699 | 2416699 | 2022-04-17 | Sullivan | New Hampshire | 33019 | 9296 | 68 |
2416887 | 2416887 | 2022-04-17 | Person | North Carolina | 37145 | 9296 | 104 |
2413443 | 2413443 | 2022-04-16 | Sullivan | New Hampshire | 33019 | 9296 | 68 |
2413631 | 2413631 | 2022-04-16 | Person | North Carolina | 37145 | 9296 | 104 |
2410187 | 2410187 | 2022-04-15 | Sullivan | New Hampshire | 33019 | 9296 | 68 |
2410375 | 2410375 | 2022-04-15 | Person | North Carolina | 37145 | 9296 | 104 |
2407119 | 2407119 | 2022-04-14 | Person | North Carolina | 37145 | 9296 | 104 |
2403863 | 2403863 | 2022-04-13 | Person | North Carolina | 37145 | 9296 | 104 |
2258859 | 2258859 | 2022-02-28 | Boone | Arkansas | 5009 | 9296 | 162 |
2235859 | 2235859 | 2022-02-20 | Logan | West Virginia | 54045 | 9296 | 165 |
2232608 | 2232608 | 2022-02-19 | Logan | West Virginia | 54045 | 9296 | 165 |
2229357 | 2229357 | 2022-02-18 | Logan | West Virginia | 54045 | 9296 | 165 |
2134645 | 2134645 | 2022-01-20 | Jim Wells | Texas | 48249 | 9296 | 185 |
2003721 | 2003721 | 2021-12-11 | Genesee | New York | 36037 | 9296 | 149 |
1831490 | 1831490 | 2021-10-19 | Ontario | New York | 36069 | 9296 | 110 |
1804376 | 1804376 | 2021-10-11 | Morgan | Indiana | 18109 | 9296 | 181 |
1769769 | 1769769 | 2021-09-30 | St. Lawrence | New York | 36089 | 9296 | 120 |
1739717 | 1739717 | 2021-09-21 | McCracken | Kentucky | 21145 | 9296 | 155 |
1726190 | 1726190 | 2021-09-17 | Hawaii | Hawaii | 15001 | 9296 | 74 |
1640575 | 1640575 | 2021-08-21 | Bowie | Texas | 48037 | 9296 | 234 |
1584784 | 1584784 | 2021-08-04 | Columbiana | Ohio | 39029 | 9296 | 236 |
1580693 | 1580693 | 2021-08-03 | Hampshire | Massachusetts | 25015 | 9296 | 300 |
1543509 | 1543509 | 2021-07-22 | Portsmouth city | Virginia | 51740 | 9296 | 205 |
1488146 | 1488146 | 2021-07-05 | Victoria | Texas | 48469 | 9296 | 227 |
1469009 | 1469009 | 2021-06-29 | Ozaukee | Wisconsin | 55089 | 9296 | 104 |
1415528 | 1415528 | 2021-06-13 | Missoula | Montana | 30063 | 9296 | 95 |
1412282 | 1412282 | 2021-06-12 | Missoula | Montana | 30063 | 9296 | 95 |
1409037 | 1409037 | 2021-06-11 | Missoula | Montana | 30063 | 9296 | 95 |
1352098 | 1352098 | 2021-05-24 | Monongalia | West Virginia | 54061 | 9296 | 86 |
1265301 | 1265301 | 2021-04-28 | Kosciusko | Indiana | 18085 | 9296 | 119 |
1234087 | 1234087 | 2021-04-18 | Wilson | North Carolina | 37195 | 9296 | 163 |
1230839 | 1230839 | 2021-04-17 | Wilson | North Carolina | 37195 | 9296 | 163 |
1227591 | 1227591 | 2021-04-16 | Wilson | North Carolina | 37195 | 9296 | 163 |
1225383 | 1225383 | 2021-04-15 | Spotsylvania | Virginia | 51177 | 9296 | 110 |
1200942 | 1200942 | 2021-04-08 | Carver | Minnesota | 27019 | 9296 | 42 |
1179707 | 1179707 | 2021-04-01 | Starr | Texas | 48427 | 9296 | 289 |
1104076 | 1104076 | 2021-03-09 | Rensselaer | New York | 36083 | 9296 | 132 |
1055948 | 1055948 | 2021-02-22 | Lancaster | South Carolina | 45057 | 9296 | 140 |
973081 | 973081 | 2021-01-28 | Delaware | Indiana | 18035 | 9296 | 140 |
958263 | 958263 | 2021-01-23 | Portage | Ohio | 39133 | 9296 | 109 |
795976 | 795976 | 2020-12-04 | Mahoning | Ohio | 39099 | 9296 | 305 |
745421 | 745421 | 2020-11-19 | Solano | California | 6095 | 9296 | 80 |
500068 | 500068 | 2020-09-04 | Bristol | Massachusetts | 25005 | 9296 | 661 |
377572 | 377572 | 2020-07-28 | Macomb | Michigan | 26099 | 9296 | 942 |
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);