ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 5326 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 7
- Ohio 5
- Tennessee 5
- Virginia 4
- West Virginia 4
- Alabama 3
- Indiana 3
- Puerto Rico 3
- Texas 3
- Arkansas 2
- Kentucky 2
- Louisiana 2
- Minnesota 2
- New Mexico 2
- North Dakota 2
- Pennsylvania 2
- Arizona 1
- California 1
- Florida 1
- Illinois 1
- Kansas 1
- Maryland 1
- Michigan 1
- Mississippi 1
- Missouri 1
- New Hampshire 1
- New Jersey 1
- New York 1
- North Carolina 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470184 | 2470184 | 2022-05-03 | Iowa | Wisconsin | 55049 | 5326 | 28 |
2453112 | 2453112 | 2022-04-28 | Naranjito | Puerto Rico | 72105 | 5326 | |
2453846 | 2453846 | 2022-04-28 | Lewis | West Virginia | 54041 | 5326 | 86 |
2408196 | 2408196 | 2022-04-14 | Waynesboro city | Virginia | 51820 | 5326 | 60 |
2403728 | 2403728 | 2022-04-13 | Taos | New Mexico | 35055 | 5326 | 89 |
2404940 | 2404940 | 2022-04-13 | Waynesboro city | Virginia | 51820 | 5326 | 60 |
2397218 | 2397218 | 2022-04-11 | Taos | New Mexico | 35055 | 5326 | 89 |
2232898 | 2232898 | 2022-02-20 | Ouachita | Arkansas | 5103 | 5326 | 94 |
2203121 | 2203121 | 2022-02-10 | Sevier | Utah | 49041 | 5326 | 24 |
2170805 | 2170805 | 2022-01-31 | Hampshire | West Virginia | 54027 | 5326 | 63 |
2132387 | 2132387 | 2022-01-20 | Monroe | Georgia | 13207 | 5326 | 154 |
2081351 | 2081351 | 2022-01-04 | Tippah | Mississippi | 28139 | 5326 | 87 |
2012685 | 2012685 | 2021-12-14 | Marshall | Kentucky | 21157 | 5326 | 85 |
2001878 | 2001878 | 2021-12-11 | Dallas | Alabama | 1047 | 5326 | 211 |
1931898 | 1931898 | 2021-11-19 | Lawrence | Missouri | 29109 | 5326 | 137 |
1891392 | 1891392 | 2021-11-07 | Marion | Alabama | 1093 | 5326 | 128 |
1890198 | 1890198 | 2021-11-06 | Jackson | Ohio | 39079 | 5326 | 83 |
1861975 | 1861975 | 2021-10-28 | Logan | West Virginia | 54045 | 5326 | 136 |
1855306 | 1855306 | 2021-10-26 | Charlottesville city | Virginia | 51540 | 5326 | 60 |
1830222 | 1830222 | 2021-10-19 | Christian | Illinois | 17021 | 5326 | 100 |
1815906 | 1815906 | 2021-10-14 | Claiborne | Tennessee | 47025 | 5326 | 99 |
1789158 | 1789158 | 2021-10-06 | Grafton | New Hampshire | 33009 | 5326 | 30 |
1778161 | 1778161 | 2021-10-03 | Upson | Georgia | 13293 | 5326 | 157 |
1774911 | 1774911 | 2021-10-02 | Upson | Georgia | 13293 | 5326 | 157 |
1771661 | 1771661 | 2021-10-01 | Upson | Georgia | 13293 | 5326 | 157 |
1773451 | 1773451 | 2021-10-01 | Venango | Pennsylvania | 42121 | 5326 | 114 |
1767249 | 1767249 | 2021-09-29 | White | Tennessee | 47185 | 5326 | 87 |
1747703 | 1747703 | 2021-09-23 | Henderson | Tennessee | 47077 | 5326 | 88 |
1732894 | 1732894 | 2021-09-19 | Miami | Indiana | 18103 | 5326 | 85 |
1729644 | 1729644 | 2021-09-18 | Miami | Indiana | 18103 | 5326 | 85 |
1726394 | 1726394 | 2021-09-17 | Miami | Indiana | 18103 | 5326 | 85 |
1645474 | 1645474 | 2021-08-23 | Graves | Kentucky | 21083 | 5326 | 104 |
1597572 | 1597572 | 2021-08-08 | Herkimer | New York | 36043 | 5326 | 110 |
1550251 | 1550251 | 2021-07-25 | Dale | Alabama | 1045 | 5326 | 117 |
1494144 | 1494144 | 2021-07-07 | Guaynabo | Puerto Rico | 72061 | 5326 | |
1490897 | 1490897 | 2021-07-06 | Guaynabo | Puerto Rico | 72061 | 5326 | |
1465703 | 1465703 | 2021-06-28 | Putnam | West Virginia | 54079 | 5326 | 93 |
1458221 | 1458221 | 2021-06-26 | Washington | Ohio | 39167 | 5326 | 110 |
1399689 | 1399689 | 2021-06-08 | Morton | North Dakota | 38059 | 5326 | 101 |
1396444 | 1396444 | 2021-06-07 | Morton | North Dakota | 38059 | 5326 | 101 |
1354350 | 1354350 | 2021-05-25 | Seneca | Ohio | 39147 | 5326 | 123 |
1326664 | 1326664 | 2021-05-17 | Coffee | Georgia | 13069 | 5326 | 169 |
1327410 | 1327410 | 2021-05-17 | St. Martin | Louisiana | 22099 | 5326 | 115 |
1310431 | 1310431 | 2021-05-12 | Coffee | Georgia | 13069 | 5326 | 170 |
1307185 | 1307185 | 2021-05-11 | Coffee | Georgia | 13069 | 5326 | 170 |
1281173 | 1281173 | 2021-05-03 | Suwannee | Florida | 12121 | 5326 | 138 |
1259311 | 1259311 | 2021-04-26 | Barry | Michigan | 26015 | 5326 | 60 |
1240678 | 1240678 | 2021-04-20 | Huron | Ohio | 39077 | 5326 | 114 |
1223507 | 1223507 | 2021-04-15 | St. Charles | Louisiana | 22089 | 5326 | 90 |
1132755 | 1132755 | 2021-03-18 | Crow Wing | Minnesota | 27035 | 5326 | 85 |
1108784 | 1108784 | 2021-03-11 | Graham | Arizona | 4009 | 5326 | 77 |
991994 | 991994 | 2021-02-03 | Mississippi | Arkansas | 5093 | 5326 | 109 |
978181 | 978181 | 2021-01-29 | Lawrence | Tennessee | 47099 | 5326 | 73 |
964925 | 964925 | 2021-01-25 | Lawrence | Pennsylvania | 42073 | 5326 | 159 |
965660 | 965660 | 2021-01-25 | Rockingham | Virginia | 51165 | 5326 | 68 |
935230 | 935230 | 2021-01-16 | Warren | New Jersey | 34041 | 5326 | 189 |
935965 | 935965 | 2021-01-16 | Dickson | Tennessee | 47043 | 5326 | 77 |
932264 | 932264 | 2021-01-15 | Hancock | Ohio | 39063 | 5326 | 90 |
925015 | 925015 | 2021-01-13 | Blue Earth | Minnesota | 27013 | 5326 | 33 |
899692 | 899692 | 2021-01-05 | Orange | North Carolina | 37135 | 5326 | 66 |
893681 | 893681 | 2021-01-03 | Orangeburg | South Carolina | 45075 | 5326 | 154 |
828989 | 828989 | 2020-12-14 | Comal | Texas | 48091 | 5326 | 136 |
825743 | 825743 | 2020-12-13 | Comal | Texas | 48091 | 5326 | 136 |
822496 | 822496 | 2020-12-12 | Comal | Texas | 48091 | 5326 | 136 |
807764 | 807764 | 2020-12-08 | Douglas | Kansas | 20045 | 5326 | 29 |
720441 | 720441 | 2020-11-11 | Frederick | Maryland | 24021 | 5326 | 140 |
411884 | 411884 | 2020-08-08 | Marin | California | 6041 | 5326 | 78 |
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);