ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5748 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Texas 18
- California 6
- Pennsylvania 5
- Ohio 4
- South Carolina 4
- Michigan 3
- New Mexico 3
- New York 3
- Tennessee 3
- Utah 3
- Virginia 3
- Arizona 2
- Arkansas 2
- Georgia 2
- Illinois 2
- Puerto Rico 2
- Colorado 1
- Idaho 1
- Indiana 1
- Kentucky 1
- Louisiana 1
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Nebraska 1
- North Carolina 1
- Vermont 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430567 | 2430567 | 2022-04-21 | Austin | Texas | 48015 | 5748 | 73 |
2430846 | 2430846 | 2022-04-21 | Caledonia | Vermont | 50005 | 5748 | 24 |
2390726 | 2390726 | 2022-04-09 | Essex | New York | 36031 | 5748 | 59 |
2381788 | 2381788 | 2022-04-06 | Dimmit | Texas | 48127 | 5748 | 51 |
2378533 | 2378533 | 2022-04-05 | Dimmit | Texas | 48127 | 5748 | 51 |
2375279 | 2375279 | 2022-04-04 | Dimmit | Texas | 48127 | 5748 | 51 |
2302861 | 2302861 | 2022-03-13 | San Miguel | New Mexico | 35047 | 5748 | 51 |
2299609 | 2299609 | 2022-03-12 | San Miguel | New Mexico | 35047 | 5748 | 51 |
2296357 | 2296357 | 2022-03-11 | San Miguel | New Mexico | 35047 | 5748 | 51 |
2286707 | 2286707 | 2022-03-08 | Greene | North Carolina | 37079 | 5748 | 56 |
2252418 | 2252418 | 2022-02-26 | Sevier | Arkansas | 5133 | 5748 | 67 |
2178220 | 2178220 | 2022-02-03 | Randolph | Indiana | 18135 | 5748 | 138 |
2179130 | 2179130 | 2022-02-03 | Cass | Nebraska | 31025 | 5748 | 33 |
2148287 | 2148287 | 2022-01-25 | Cleburne | Arkansas | 5023 | 5748 | 107 |
2128109 | 2128109 | 2022-01-18 | Hale | Texas | 48189 | 5748 | 214 |
2095628 | 2095628 | 2022-01-08 | Kendall | Texas | 48259 | 5748 | 103 |
2088800 | 2088800 | 2022-01-06 | Clarendon | South Carolina | 45027 | 5748 | 138 |
2086021 | 2086021 | 2022-01-05 | Uintah | Utah | 49047 | 5748 | 54 |
2082769 | 2082769 | 2022-01-04 | Uintah | Utah | 49047 | 5748 | 54 |
2055416 | 2055416 | 2021-12-27 | Lawrence | Missouri | 29109 | 5748 | 138 |
2056945 | 2056945 | 2021-12-27 | Okanogan | Washington | 53047 | 5748 | 104 |
1989520 | 1989520 | 2021-12-07 | Monroe | Illinois | 17133 | 5748 | 105 |
1942409 | 1942409 | 2021-11-22 | Perry | Pennsylvania | 42099 | 5748 | 131 |
1910444 | 1910444 | 2021-11-12 | Titus | Texas | 48449 | 5748 | 104 |
1893747 | 1893747 | 2021-11-07 | Toa Alta | Puerto Rico | 72135 | 5748 | |
1887247 | 1887247 | 2021-11-05 | Toa Alta | Puerto Rico | 72135 | 5748 | |
1861421 | 1861421 | 2021-10-28 | Henderson | Tennessee | 47077 | 5748 | 101 |
1845345 | 1845345 | 2021-10-23 | Howard | Texas | 48227 | 5748 | 132 |
1795967 | 1795967 | 2021-10-08 | Highland | Ohio | 39071 | 5748 | 99 |
1779490 | 1779490 | 2021-10-03 | Fulton | New York | 36035 | 5748 | 99 |
1688763 | 1688763 | 2021-09-05 | Knox | Ohio | 39083 | 5748 | 120 |
1668209 | 1668209 | 2021-08-30 | Graves | Kentucky | 21083 | 5748 | 107 |
1628076 | 1628076 | 2021-08-17 | Putnam | West Virginia | 54079 | 5748 | 97 |
1510893 | 1510893 | 2021-07-12 | Box Elder | Utah | 49003 | 5748 | 56 |
1472809 | 1472809 | 2021-07-01 | Polk | Georgia | 13233 | 5748 | 100 |
1447595 | 1447595 | 2021-06-23 | Branch | Michigan | 26023 | 5748 | 120 |
1394614 | 1394614 | 2021-06-07 | Lassen | California | 6035 | 5748 | 24 |
1391369 | 1391369 | 2021-06-06 | Lassen | California | 6035 | 5748 | 24 |
1388124 | 1388124 | 2021-06-05 | Lassen | California | 6035 | 5748 | 24 |
1384879 | 1384879 | 2021-06-04 | Lassen | California | 6035 | 5748 | 24 |
1381633 | 1381633 | 2021-06-03 | Lassen | California | 6035 | 5748 | 24 |
1321887 | 1321887 | 2021-05-15 | Union | Ohio | 39159 | 5748 | 48 |
1294389 | 1294389 | 2021-05-07 | Clinton | Illinois | 17027 | 5748 | 99 |
1293462 | 1293462 | 2021-05-06 | Augusta | Virginia | 51015 | 5748 | 71 |
1272343 | 1272343 | 2021-04-30 | Marquette | Michigan | 26103 | 5748 | 59 |
1260859 | 1260859 | 2021-04-26 | Navarro | Texas | 48349 | 5748 | 154 |
1257612 | 1257612 | 2021-04-25 | Navarro | Texas | 48349 | 5748 | 154 |
1254365 | 1254365 | 2021-04-24 | Navarro | Texas | 48349 | 5748 | 154 |
1251118 | 1251118 | 2021-04-23 | Navarro | Texas | 48349 | 5748 | 154 |
1223611 | 1223611 | 2021-04-15 | Grand Traverse | Michigan | 26055 | 5748 | 81 |
1221824 | 1221824 | 2021-04-14 | Henderson | Texas | 48213 | 5748 | 184 |
1218576 | 1218576 | 2021-04-13 | Henderson | Texas | 48213 | 5748 | 183 |
1215175 | 1215175 | 2021-04-12 | Lawrence | Tennessee | 47099 | 5748 | 86 |
1215328 | 1215328 | 2021-04-12 | Henderson | Texas | 48213 | 5748 | 183 |
1176049 | 1176049 | 2021-03-31 | Cherokee | South Carolina | 45021 | 5748 | 147 |
1107329 | 1107329 | 2021-03-10 | St. Lawrence | New York | 36089 | 5748 | 91 |
1085697 | 1085697 | 2021-03-03 | Harrisonburg city | Virginia | 51660 | 5748 | 86 |
1062931 | 1062931 | 2021-02-24 | Bedford | Virginia | 51019 | 5748 | 56 |
1048372 | 1048372 | 2021-02-20 | Kandiyohi | Minnesota | 27067 | 5748 | 74 |
1013748 | 1013748 | 2021-02-09 | Georgetown | South Carolina | 45043 | 5748 | 130 |
1010611 | 1010611 | 2021-02-08 | Cumberland | Tennessee | 47035 | 5748 | 104 |
1000421 | 1000421 | 2021-02-05 | Hancock | Ohio | 39063 | 5748 | 94 |
1000608 | 1000608 | 2021-02-05 | Clearfield | Pennsylvania | 42033 | 5748 | 104 |
997525 | 997525 | 2021-02-04 | Kershaw | South Carolina | 45055 | 5748 | 101 |
865375 | 865375 | 2020-12-26 | Santa Cruz | Arizona | 4023 | 5748 | 93 |
816050 | 816050 | 2020-12-10 | Gregg | Texas | 48183 | 5748 | 125 |
805057 | 805057 | 2020-12-07 | Lee | Mississippi | 28081 | 5748 | 98 |
762568 | 762568 | 2020-11-24 | Livingston | Louisiana | 22063 | 5748 | 89 |
729555 | 729555 | 2020-11-14 | Twin Falls | Idaho | 16083 | 5748 | 68 |
698832 | 698832 | 2020-11-04 | Northampton | Pennsylvania | 42095 | 5748 | 315 |
550712 | 550712 | 2020-09-20 | Navajo | Arizona | 4017 | 5748 | 232 |
528350 | 528350 | 2020-09-13 | Bibb | Georgia | 13021 | 5748 | 151 |
497874 | 497874 | 2020-09-03 | Chester | Pennsylvania | 42029 | 5748 | 358 |
494641 | 494641 | 2020-09-02 | Chester | Pennsylvania | 42029 | 5748 | 358 |
453863 | 453863 | 2020-08-21 | El Paso | Colorado | 8041 | 5748 | 150 |
362869 | 362869 | 2020-07-23 | Collin | Texas | 48085 | 5748 | 72 |
359662 | 359662 | 2020-07-22 | Collin | Texas | 48085 | 5748 | 72 |
350868 | 350868 | 2020-07-20 | Ventura | California | 6111 | 5748 | 58 |
149374 | 149374 | 2020-05-16 | Bristol | Massachusetts | 25005 | 5748 | 313 |
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);