ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where cases = 3916 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 12
- Georgia 7
- North Carolina 7
- South Carolina 7
- South Dakota 7
- Indiana 6
- Texas 6
- Minnesota 5
- Wisconsin 5
- Colorado 4
- Ohio 4
- Virginia 4
- Alaska 3
- Arkansas 3
- Illinois 3
- Mississippi 3
- West Virginia 3
- Kansas 2
- Missouri 2
- New York 2
- Oregon 2
- Tennessee 2
- Utah 2
- Washington 2
- Wyoming 2
- Florida 1
- Iowa 1
- Kentucky 1
- Maine 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479551 | 2479551 | 2022-05-06 | Llano | Texas | 48299 | 3916 | 97 |
2444869 | 2444869 | 2022-04-26 | Mason | Illinois | 17125 | 3916 | 61 |
2441613 | 2441613 | 2022-04-25 | Mason | Illinois | 17125 | 3916 | 61 |
2355585 | 2355585 | 2022-03-29 | Oglala Lakota | South Dakota | 46102 | 3916 | 62 |
2352332 | 2352332 | 2022-03-28 | Oglala Lakota | South Dakota | 46102 | 3916 | 62 |
2347019 | 2347019 | 2022-03-27 | Greene | Georgia | 13133 | 3916 | 83 |
2349080 | 2349080 | 2022-03-27 | Oglala Lakota | South Dakota | 46102 | 3916 | 62 |
2343766 | 2343766 | 2022-03-26 | Greene | Georgia | 13133 | 3916 | 83 |
2345827 | 2345827 | 2022-03-26 | Oglala Lakota | South Dakota | 46102 | 3916 | 62 |
2340513 | 2340513 | 2022-03-25 | Greene | Georgia | 13133 | 3916 | 83 |
2342574 | 2342574 | 2022-03-25 | Oglala Lakota | South Dakota | 46102 | 3916 | 62 |
2339321 | 2339321 | 2022-03-24 | Oglala Lakota | South Dakota | 46102 | 3916 | 62 |
2336067 | 2336067 | 2022-03-23 | Oglala Lakota | South Dakota | 46102 | 3916 | 62 |
2314184 | 2314184 | 2022-03-17 | Madison | Arkansas | 5087 | 3916 | 60 |
2280717 | 2280717 | 2022-03-06 | Saluda | South Carolina | 45081 | 3916 | 72 |
2277464 | 2277464 | 2022-03-05 | Saluda | South Carolina | 45081 | 3916 | 72 |
2274211 | 2274211 | 2022-03-04 | Saluda | South Carolina | 45081 | 3916 | 72 |
2270958 | 2270958 | 2022-03-03 | Saluda | South Carolina | 45081 | 3916 | 72 |
2264453 | 2264453 | 2022-03-01 | Saluda | South Carolina | 45081 | 3916 | 72 |
2261203 | 2261203 | 2022-02-28 | Saluda | South Carolina | 45081 | 3916 | 72 |
2258655 | 2258655 | 2022-02-27 | Burnett | Wisconsin | 55013 | 3916 | 41 |
2255404 | 2255404 | 2022-02-26 | Burnett | Wisconsin | 55013 | 3916 | 41 |
2252153 | 2252153 | 2022-02-25 | Burnett | Wisconsin | 55013 | 3916 | 41 |
2242137 | 2242137 | 2022-02-22 | San Juan | Utah | 49037 | 3916 | 47 |
2242256 | 2242256 | 2022-02-22 | Nottoway | Virginia | 51135 | 3916 | 80 |
2166346 | 2166346 | 2022-01-30 | Avery | North Carolina | 37011 | 3916 | 39 |
2163091 | 2163091 | 2022-01-29 | Avery | North Carolina | 37011 | 3916 | 39 |
2159836 | 2159836 | 2022-01-28 | Avery | North Carolina | 37011 | 3916 | 39 |
2128517 | 2128517 | 2022-01-18 | McDowell | West Virginia | 54047 | 3916 | 57 |
2119150 | 2119150 | 2022-01-16 | Elbert | Colorado | 8039 | 3916 | 31 |
2115898 | 2115898 | 2022-01-15 | Elbert | Colorado | 8039 | 3916 | 31 |
2112647 | 2112647 | 2022-01-14 | Elbert | Colorado | 8039 | 3916 | 31 |
2115134 | 2115134 | 2022-01-14 | Jones | Texas | 48253 | 3916 | 82 |
2110575 | 2110575 | 2022-01-13 | Jasper | Mississippi | 28061 | 3916 | 66 |
2101612 | 2101612 | 2022-01-10 | Crook | Oregon | 41013 | 3916 | 61 |
2098892 | 2098892 | 2022-01-09 | Lampasas | Texas | 48281 | 3916 | 72 |
2095645 | 2095645 | 2022-01-08 | Limestone | Texas | 48293 | 3916 | 112 |
2092726 | 2092726 | 2022-01-07 | Brooke | West Virginia | 54009 | 3916 | 87 |
2089410 | 2089410 | 2022-01-06 | Scott | Virginia | 51169 | 3916 | 92 |
2039152 | 2039152 | 2021-12-22 | Henry | Missouri | 29083 | 3916 | 66 |
2034825 | 2034825 | 2021-12-21 | Harris | Georgia | 13145 | 3916 | 96 |
1946245 | 1946245 | 2021-11-23 | Sevier | Utah | 49041 | 3916 | 19 |
1943197 | 1943197 | 2021-11-22 | Boone | West Virginia | 54005 | 3916 | 61 |
1887228 | 1887228 | 2021-11-05 | Mayaguez | Puerto Rico | 72097 | 3916 | |
1844933 | 1844933 | 2021-10-23 | Warren | Pennsylvania | 42123 | 3916 | 123 |
1808203 | 1808203 | 2021-10-12 | Brown | Minnesota | 27015 | 3916 | 45 |
1725782 | 1725782 | 2021-09-17 | Jackson | Arkansas | 5067 | 3916 | 41 |
1725629 | 1725629 | 2021-09-16 | Park | Wyoming | 56029 | 3916 | 42 |
1716915 | 1716915 | 2021-09-14 | Carter | Kentucky | 21043 | 3916 | 47 |
1707683 | 1707683 | 2021-09-11 | Dunklin | Missouri | 29069 | 3916 | 55 |
1694299 | 1694299 | 2021-09-07 | Franklin | Louisiana | 22041 | 3916 | 126 |
1676743 | 1676743 | 2021-09-01 | Mason | Washington | 53045 | 3916 | 44 |
1676837 | 1676837 | 2021-09-01 | Green | Wisconsin | 55045 | 3916 | 26 |
1670897 | 1670897 | 2021-08-31 | Lumpkin | Georgia | 13187 | 3916 | 86 |
1671843 | 1671843 | 2021-08-31 | Copiah | Mississippi | 28029 | 3916 | 77 |
1653377 | 1653377 | 2021-08-25 | Marlboro | South Carolina | 45069 | 3916 | 61 |
1587287 | 1587287 | 2021-08-05 | Becker | Minnesota | 27005 | 3916 | 58 |
1580844 | 1580844 | 2021-08-03 | Polk | Minnesota | 27119 | 3916 | 73 |
1555581 | 1555581 | 2021-07-26 | Logan | Ohio | 39091 | 3916 | 79 |
1552334 | 1552334 | 2021-07-25 | Logan | Ohio | 39091 | 3916 | 79 |
1526378 | 1526378 | 2021-07-17 | Preble | Ohio | 39135 | 3916 | 106 |
1513042 | 1513042 | 2021-07-13 | Cheshire | New Hampshire | 33005 | 3916 | 35 |
1492951 | 1492951 | 2021-07-07 | St. John the Baptist | Louisiana | 22095 | 3916 | 141 |
1473044 | 1473044 | 2021-07-01 | Jasper | Indiana | 18073 | 3916 | 57 |
1465884 | 1465884 | 2021-06-29 | Bethel Census Area | Alaska | 2050 | 3916 | 22 |
1462639 | 1462639 | 2021-06-28 | Bethel Census Area | Alaska | 2050 | 3916 | 22 |
1451823 | 1451823 | 2021-06-24 | Douglas | Oregon | 41019 | 3916 | 83 |
1437749 | 1437749 | 2021-06-20 | Iberville | Louisiana | 22047 | 3916 | 100 |
1434502 | 1434502 | 2021-06-19 | Iberville | Louisiana | 22047 | 3916 | 100 |
1431256 | 1431256 | 2021-06-18 | Iberville | Louisiana | 22047 | 3916 | 100 |
1407508 | 1407508 | 2021-06-11 | Boone | Arkansas | 5009 | 3916 | 80 |
1406003 | 1406003 | 2021-06-10 | Cortland | New York | 36023 | 3916 | 62 |
1334133 | 1334133 | 2021-05-19 | Steele | Minnesota | 27147 | 3916 | 15 |
1327019 | 1327019 | 2021-05-17 | Steuben | Indiana | 18151 | 3916 | 59 |
1323773 | 1323773 | 2021-05-16 | Steuben | Indiana | 18151 | 3916 | 59 |
1304253 | 1304253 | 2021-05-10 | Huntington | Indiana | 18069 | 3916 | 82 |
1242195 | 1242195 | 2021-04-21 | Okeechobee | Florida | 12093 | 3916 | 88 |
1239492 | 1239492 | 2021-04-20 | Cowley | Kansas | 20035 | 3916 | 107 |
1236245 | 1236245 | 2021-04-19 | Cowley | Kansas | 20035 | 3916 | 107 |
1211221 | 1211221 | 2021-04-11 | Livingston | New York | 36051 | 3916 | 58 |
1176487 | 1176487 | 2021-03-31 | Wharton | Texas | 48481 | 3916 | 111 |
1165045 | 1165045 | 2021-03-28 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1161797 | 1161797 | 2021-03-27 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1158549 | 1158549 | 2021-03-26 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1155302 | 1155302 | 2021-03-25 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1148346 | 1148346 | 2021-03-23 | Woodford | Illinois | 17203 | 3916 | 73 |
1112775 | 1112775 | 2021-03-12 | Jasper | Iowa | 19099 | 3916 | 68 |
1107385 | 1107385 | 2021-03-10 | Haywood | North Carolina | 37087 | 3916 | 88 |
1095440 | 1095440 | 2021-03-06 | James City | Virginia | 51095 | 3916 | 64 |
1081685 | 1081685 | 2021-03-02 | Sequoyah | Oklahoma | 40135 | 3916 | 31 |
1068485 | 1068485 | 2021-02-26 | Watauga | North Carolina | 37189 | 3916 | 29 |
1050212 | 1050212 | 2021-02-20 | Polk | Wisconsin | 55095 | 3916 | 45 |
1017881 | 1017881 | 2021-02-11 | Kenai Peninsula Borough | Alaska | 2122 | 3916 | 19 |
1019931 | 1019931 | 2021-02-11 | Putnam | Ohio | 39137 | 3916 | 83 |
1015934 | 1015934 | 2021-02-10 | Mower | Minnesota | 27099 | 3916 | 30 |
995812 | 995812 | 2021-02-04 | Gibson | Indiana | 18051 | 3916 | 80 |
993327 | 993327 | 2021-02-03 | Warren | Mississippi | 28149 | 3916 | 110 |
950832 | 950832 | 2021-01-21 | Androscoggin | Maine | 23001 | 3916 | 51 |
885005 | 885005 | 2021-01-01 | Garfield | Colorado | 8045 | 3916 | 29 |
871741 | 871741 | 2020-12-27 | Fremont | Wyoming | 56013 | 3916 | 57 |
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);