ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where cases = 5814 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- North Carolina 8
- South Carolina 7
- New York 5
- Florida 4
- Georgia 4
- Indiana 4
- Oregon 4
- Tennessee 4
- Wisconsin 4
- Alabama 3
- Arkansas 3
- Michigan 3
- Ohio 3
- Virginia 3
- California 2
- Illinois 2
- Kentucky 2
- Maryland 2
- Pennsylvania 2
- West Virginia 2
- Alaska 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491751 | 2491751 | 2022-05-10 | Greene | North Carolina | 37079 | 5814 | 67 |
2488493 | 2488493 | 2022-05-09 | Greene | North Carolina | 37079 | 5814 | 67 |
2485236 | 2485236 | 2022-05-08 | Greene | North Carolina | 37079 | 5814 | 67 |
2481978 | 2481978 | 2022-05-07 | Greene | North Carolina | 37079 | 5814 | 67 |
2478720 | 2478720 | 2022-05-06 | Greene | North Carolina | 37079 | 5814 | 67 |
2475462 | 2475462 | 2022-05-05 | Greene | North Carolina | 37079 | 5814 | 67 |
2472205 | 2472205 | 2022-05-04 | Greene | North Carolina | 37079 | 5814 | 67 |
2397799 | 2397799 | 2022-04-11 | Barnwell | South Carolina | 45011 | 5814 | 102 |
2394544 | 2394544 | 2022-04-10 | Barnwell | South Carolina | 45011 | 5814 | 102 |
2391288 | 2391288 | 2022-04-09 | Barnwell | South Carolina | 45011 | 5814 | 102 |
2388032 | 2388032 | 2022-04-08 | Barnwell | South Carolina | 45011 | 5814 | 102 |
2384777 | 2384777 | 2022-04-07 | Barnwell | South Carolina | 45011 | 5814 | 102 |
2381522 | 2381522 | 2022-04-06 | Barnwell | South Carolina | 45011 | 5814 | 102 |
2378267 | 2378267 | 2022-04-05 | Barnwell | South Carolina | 45011 | 5814 | 102 |
2378551 | 2378551 | 2022-04-05 | Frio | Texas | 48163 | 5814 | 93 |
2362692 | 2362692 | 2022-03-31 | Hampshire | West Virginia | 54027 | 5814 | 71 |
2356184 | 2356184 | 2022-03-29 | Hampshire | West Virginia | 54027 | 5814 | 71 |
2312671 | 2312671 | 2022-03-16 | Seneca | New York | 36099 | 5814 | 89 |
2251371 | 2251371 | 2022-02-25 | Manati | Puerto Rico | 72091 | 5814 | |
2239730 | 2239730 | 2022-02-22 | Monroe | Georgia | 13207 | 5814 | 165 |
2213673 | 2213673 | 2022-02-14 | Emanuel | Georgia | 13107 | 5814 | 149 |
2214439 | 2214439 | 2022-02-14 | Caroline | Maryland | 24011 | 5814 | 77 |
2194781 | 2194781 | 2022-02-08 | Lincoln | Kentucky | 21137 | 5814 | 116 |
2168190 | 2168190 | 2022-01-31 | Peach | Georgia | 13225 | 5814 | 117 |
2128833 | 2128833 | 2022-01-19 | Calaveras | California | 6009 | 5814 | 94 |
2131382 | 2131382 | 2022-01-19 | Howard | Texas | 48227 | 5814 | 156 |
2122681 | 2122681 | 2022-01-17 | White | Georgia | 13311 | 5814 | 136 |
2084575 | 2084575 | 2022-01-05 | Leflore | Mississippi | 28083 | 5814 | 144 |
2082584 | 2082584 | 2022-01-04 | Grimes | Texas | 48185 | 5814 | 110 |
1997218 | 1997218 | 2021-12-09 | Franklin | New York | 36033 | 5814 | 27 |
1997239 | 1997239 | 2021-12-09 | Otsego | New York | 36077 | 5814 | 68 |
1991476 | 1991476 | 2021-12-07 | White | Tennessee | 47185 | 5814 | 100 |
1978702 | 1978702 | 2021-12-03 | Titus | Texas | 48449 | 5814 | 104 |
1899176 | 1899176 | 2021-11-09 | Becker | Minnesota | 27005 | 5814 | 68 |
1893598 | 1893598 | 2021-11-07 | Malheur | Oregon | 41045 | 5814 | 82 |
1890348 | 1890348 | 2021-11-06 | Malheur | Oregon | 41045 | 5814 | 82 |
1887098 | 1887098 | 2021-11-05 | Malheur | Oregon | 41045 | 5814 | 82 |
1887580 | 1887580 | 2021-11-05 | Hill | Texas | 48217 | 5814 | 162 |
1884330 | 1884330 | 2021-11-04 | Hill | Texas | 48217 | 5814 | 160 |
1845970 | 1845970 | 2021-10-24 | Baxter | Arkansas | 5005 | 5814 | 176 |
1842720 | 1842720 | 2021-10-23 | Baxter | Arkansas | 5005 | 5814 | 176 |
1789453 | 1789453 | 2021-10-06 | Defiance | Ohio | 39039 | 5814 | 102 |
1755601 | 1755601 | 2021-09-26 | DeKalb | Indiana | 18033 | 5814 | 94 |
1752353 | 1752353 | 2021-09-25 | DeKalb | Indiana | 18033 | 5814 | 94 |
1749104 | 1749104 | 2021-09-24 | DeKalb | Indiana | 18033 | 5814 | 94 |
1722001 | 1722001 | 2021-09-15 | Waller | Texas | 48473 | 5814 | 60 |
1712568 | 1712568 | 2021-09-12 | Dunn | Wisconsin | 55033 | 5814 | 38 |
1709321 | 1709321 | 2021-09-11 | Dunn | Wisconsin | 55033 | 5814 | 38 |
1706074 | 1706074 | 2021-09-10 | Dunn | Wisconsin | 55033 | 5814 | 38 |
1676936 | 1676936 | 2021-09-02 | Escambia | Alabama | 1053 | 5814 | 93 |
1674844 | 1674844 | 2021-09-01 | Webster | Louisiana | 22119 | 5814 | 129 |
1668760 | 1668760 | 2021-08-30 | Scott | Missouri | 29201 | 5814 | 92 |
1651557 | 1651557 | 2021-08-25 | Franklin | Illinois | 17055 | 5814 | 95 |
1652879 | 1652879 | 2021-08-25 | Hoke | North Carolina | 37093 | 5814 | 59 |
1653798 | 1653798 | 2021-08-25 | Wilson | Texas | 48493 | 5814 | 79 |
1587808 | 1587808 | 2021-08-05 | Cattaraugus | New York | 36009 | 5814 | 93 |
1589038 | 1589038 | 2021-08-05 | Lewis | Washington | 53041 | 5814 | 83 |
1540724 | 1540724 | 2021-07-22 | Tehama | California | 6103 | 5814 | 65 |
1541739 | 1541739 | 2021-07-22 | Branch | Michigan | 26023 | 5814 | 121 |
1542387 | 1542387 | 2021-07-22 | Wayne | New York | 36117 | 5814 | 73 |
1538492 | 1538492 | 2021-07-21 | Branch | Michigan | 26023 | 5814 | 121 |
1535245 | 1535245 | 2021-07-20 | Branch | Michigan | 26023 | 5814 | 121 |
1508628 | 1508628 | 2021-07-12 | Clinton | Illinois | 17027 | 5814 | 100 |
1510118 | 1510118 | 2021-07-12 | Lawrence | Ohio | 39087 | 5814 | 103 |
1510665 | 1510665 | 2021-07-12 | Caldwell | Texas | 48055 | 5814 | 100 |
1494031 | 1494031 | 2021-07-07 | Linn | Oregon | 41043 | 5814 | 81 |
1429792 | 1429792 | 2021-06-17 | Albemarle | Virginia | 51003 | 5814 | 85 |
1367340 | 1367340 | 2021-05-29 | Union | Ohio | 39159 | 5814 | 49 |
1319435 | 1319435 | 2021-05-14 | Augusta | Virginia | 51015 | 5814 | 71 |
1304234 | 1304234 | 2021-05-10 | Dearborn | Indiana | 18029 | 5814 | 81 |
1283379 | 1283379 | 2021-05-03 | Monroe | Tennessee | 47123 | 5814 | 95 |
1264712 | 1264712 | 2021-04-28 | Mississippi | Arkansas | 5093 | 5814 | 107 |
1157358 | 1157358 | 2021-03-25 | Waupaca | Wisconsin | 55135 | 5814 | 161 |
1124241 | 1124241 | 2021-03-15 | Jefferson | Tennessee | 47089 | 5814 | 121 |
1058906 | 1058906 | 2021-02-23 | Bryan | Oklahoma | 40013 | 5814 | 54 |
1031138 | 1031138 | 2021-02-15 | Jackson | Florida | 12063 | 5814 | 140 |
1033084 | 1033084 | 2021-02-15 | Lawrence | Pennsylvania | 42073 | 5814 | 177 |
1027891 | 1027891 | 2021-02-14 | Jackson | Florida | 12063 | 5814 | 138 |
992862 | 992862 | 2021-02-03 | Christian | Kentucky | 21047 | 5814 | 75 |
978926 | 978926 | 2021-01-30 | Fairbanks North Star Borough | Alaska | 2090 | 5814 | 26 |
981832 | 981832 | 2021-01-30 | Hanover | Virginia | 51085 | 5814 | 101 |
974902 | 974902 | 2021-01-28 | Coffee | Tennessee | 47031 | 5814 | 97 |
965497 | 965497 | 2021-01-25 | Wise | Texas | 48497 | 5814 | 92 |
962252 | 962252 | 2021-01-24 | Wise | Texas | 48497 | 5814 | 92 |
959007 | 959007 | 2021-01-23 | Wise | Texas | 48497 | 5814 | 91 |
928131 | 928131 | 2021-01-14 | Allegany | Maryland | 24001 | 5814 | 164 |
849101 | 849101 | 2020-12-21 | St. Clair | Alabama | 1115 | 5814 | 63 |
798899 | 798899 | 2020-12-05 | Rockingham | New Hampshire | 33015 | 5814 | 114 |
798950 | 798950 | 2020-12-05 | Sandoval | New Mexico | 35043 | 5814 | 90 |
745195 | 745195 | 2020-11-19 | Calhoun | Alabama | 1015 | 5814 | 111 |
628774 | 628774 | 2020-10-14 | St. Johns | Florida | 12109 | 5814 | 77 |
565363 | 565363 | 2020-09-24 | Somerset | New Jersey | 34035 | 5814 | 573 |
462307 | 462307 | 2020-08-23 | Berks | Pennsylvania | 42011 | 5814 | 377 |
395965 | 395965 | 2020-08-03 | Sarasota | Florida | 12115 | 5814 | 121 |
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);