ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 5956 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Texas 7
- Indiana 5
- Georgia 4
- Utah 4
- Minnesota 3
- Virginia 3
- California 2
- Illinois 2
- Kentucky 2
- Maryland 2
- North Carolina 2
- Ohio 2
- Puerto Rico 2
- Tennessee 2
- Wisconsin 2
- Arkansas 1
- Louisiana 1
- Mississippi 1
- Missouri 1
- New Mexico 1
- New York 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472637 | 2472637 | 2022-05-04 | Las Piedras | Puerto Rico | 72085 | 5956 | |
2448840 | 2448840 | 2022-04-27 | Meeker | Minnesota | 27093 | 5956 | 75 |
2257828 | 2257828 | 2022-02-27 | Aguada | Puerto Rico | 72003 | 5956 | |
2218444 | 2218444 | 2022-02-15 | Martin | North Carolina | 37117 | 5956 | 85 |
2206189 | 2206189 | 2022-02-11 | Gray | Texas | 48179 | 5956 | 113 |
2168692 | 2168692 | 2022-01-31 | Allen | Kentucky | 21003 | 5956 | 90 |
2169056 | 2169056 | 2022-01-31 | Le Sueur | Minnesota | 27079 | 5956 | 47 |
2060009 | 2060009 | 2021-12-28 | Sanpete | Utah | 49039 | 5956 | 43 |
2038758 | 2038758 | 2021-12-22 | Iberville | Louisiana | 22047 | 5956 | 129 |
2017593 | 2017593 | 2021-12-15 | Hill | Texas | 48217 | 5956 | 170 |
2010346 | 2010346 | 2021-12-13 | Scotland | North Carolina | 37165 | 5956 | 109 |
2010943 | 2010943 | 2021-12-13 | Marion | Tennessee | 47115 | 5956 | 75 |
1851217 | 1851217 | 2021-10-25 | Madison | Ohio | 39097 | 5956 | 78 |
1848762 | 1848762 | 2021-10-24 | Wasatch | Utah | 49051 | 5956 | 28 |
1845512 | 1845512 | 2021-10-23 | Wasatch | Utah | 49051 | 5956 | 28 |
1842262 | 1842262 | 2021-10-22 | Wasatch | Utah | 49051 | 5956 | 28 |
1720649 | 1720649 | 2021-09-15 | Butler | Missouri | 29023 | 5956 | 61 |
1713284 | 1713284 | 2021-09-13 | Henry | Illinois | 17073 | 5956 | 101 |
1627040 | 1627040 | 2021-08-17 | Jefferson | Ohio | 39081 | 5956 | 163 |
1621465 | 1621465 | 2021-08-15 | Pittsylvania | Virginia | 51143 | 5956 | 86 |
1618217 | 1618217 | 2021-08-14 | Pittsylvania | Virginia | 51143 | 5956 | 86 |
1614969 | 1614969 | 2021-08-13 | Pittsylvania | Virginia | 51143 | 5956 | 86 |
1587340 | 1587340 | 2021-08-05 | Otter Tail | Minnesota | 27111 | 5956 | 87 |
1560446 | 1560446 | 2021-07-28 | Laurens | Georgia | 13175 | 5956 | 173 |
1541246 | 1541246 | 2021-07-22 | Noble | Indiana | 18113 | 5956 | 93 |
1518473 | 1518473 | 2021-07-15 | Dearborn | Indiana | 18029 | 5956 | 81 |
1508171 | 1508171 | 2021-07-12 | Mississippi | Arkansas | 5093 | 5956 | 110 |
1497827 | 1497827 | 2021-07-08 | Navarro | Texas | 48349 | 5956 | 154 |
1494580 | 1494580 | 2021-07-07 | Navarro | Texas | 48349 | 5956 | 154 |
1465329 | 1465329 | 2021-06-28 | Lamar | Texas | 48277 | 5956 | 157 |
1372405 | 1372405 | 2021-05-31 | Cass | Indiana | 18017 | 5956 | 109 |
1369160 | 1369160 | 2021-05-30 | Cass | Indiana | 18017 | 5956 | 109 |
1365914 | 1365914 | 2021-05-29 | Cass | Indiana | 18017 | 5956 | 109 |
1354482 | 1354482 | 2021-05-25 | Armstrong | Pennsylvania | 42005 | 5956 | 140 |
1256024 | 1256024 | 2021-04-25 | Cecil | Maryland | 24015 | 5956 | 128 |
1257240 | 1257240 | 2021-04-25 | Cherokee | South Carolina | 45021 | 5956 | 151 |
1241800 | 1241800 | 2021-04-20 | Waupaca | Wisconsin | 55135 | 5956 | 161 |
1109764 | 1109764 | 2021-03-11 | McCracken | Kentucky | 21145 | 5956 | 80 |
1106889 | 1106889 | 2021-03-10 | Lamar | Mississippi | 28073 | 5956 | 82 |
1102796 | 1102796 | 2021-03-09 | Boone | Illinois | 17007 | 5956 | 82 |
1078458 | 1078458 | 2021-03-01 | Deschutes | Oregon | 41017 | 5956 | 59 |
1065123 | 1065123 | 2021-02-25 | Oswego | New York | 36075 | 5956 | 89 |
1002087 | 1002087 | 2021-02-06 | Rockdale | Georgia | 13247 | 5956 | 117 |
991232 | 991232 | 2021-02-02 | Bowie | Texas | 48037 | 5956 | 157 |
944356 | 944356 | 2021-01-19 | Allegany | Maryland | 24001 | 5956 | 166 |
829558 | 829558 | 2020-12-14 | Natrona | Wyoming | 56025 | 5956 | 62 |
821644 | 821644 | 2020-12-12 | Chaves | New Mexico | 35005 | 5956 | 63 |
804031 | 804031 | 2020-12-07 | Coweta | Georgia | 13077 | 5956 | 76 |
768134 | 768134 | 2020-11-26 | San Luis Obispo | California | 6079 | 5956 | 35 |
764888 | 764888 | 2020-11-25 | San Luis Obispo | California | 6079 | 5956 | 35 |
751021 | 751021 | 2020-11-20 | Montgomery | Tennessee | 47125 | 5956 | 80 |
715587 | 715587 | 2020-11-09 | Tom Green | Texas | 48451 | 5956 | 87 |
706226 | 706226 | 2020-11-06 | Washington | Wisconsin | 55131 | 5956 | 53 |
700314 | 700314 | 2020-11-05 | Whitfield | Georgia | 13313 | 5956 | 66 |
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);