ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 5707 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Texas 11
- Kentucky 6
- Georgia 5
- Virginia 5
- Missouri 4
- Minnesota 3
- Mississippi 3
- West Virginia 3
- Illinois 2
- Indiana 2
- Louisiana 2
- New York 2
- North Carolina 2
- Ohio 2
- Oregon 2
- Puerto Rico 2
- Wisconsin 2
- Arkansas 1
- California 1
- Colorado 1
- Florida 1
- Oklahoma 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493348 | 2493348 | 2022-05-11 | Morgan | Colorado | 8087 | 5707 | 138 |
2456636 | 2456636 | 2022-04-29 | Calhoun | Texas | 48057 | 5707 | 48 |
2313820 | 2313820 | 2022-03-16 | Scott | Virginia | 51169 | 5707 | 102 |
2246823 | 2246823 | 2022-02-24 | Meade | Kentucky | 21163 | 5707 | 64 |
2242944 | 2242944 | 2022-02-23 | Grady | Georgia | 13131 | 5707 | 104 |
2243572 | 2243572 | 2022-02-23 | Meade | Kentucky | 21163 | 5707 | 64 |
2242352 | 2242352 | 2022-02-22 | Hampshire | West Virginia | 54027 | 5707 | 64 |
2224151 | 2224151 | 2022-02-17 | St. James | Louisiana | 22093 | 5707 | 75 |
2224465 | 2224465 | 2022-02-17 | Sunflower | Mississippi | 28133 | 5707 | 116 |
2178452 | 2178452 | 2022-02-03 | Anderson | Kentucky | 21005 | 5707 | 60 |
2178498 | 2178498 | 2022-02-03 | Harrison | Kentucky | 21097 | 5707 | 58 |
2132329 | 2132329 | 2022-01-20 | Decatur | Georgia | 13087 | 5707 | 112 |
2127486 | 2127486 | 2022-01-18 | Henry | Ohio | 39069 | 5707 | 93 |
2114740 | 2114740 | 2022-01-14 | Dorado | Puerto Rico | 72051 | 5707 | |
2081323 | 2081323 | 2022-01-04 | Leflore | Mississippi | 28083 | 5707 | 144 |
2040182 | 2040182 | 2021-12-22 | Henry | Tennessee | 47079 | 5707 | 98 |
2035946 | 2035946 | 2021-12-21 | Polk | Missouri | 29167 | 5707 | 81 |
2024502 | 2024502 | 2021-12-17 | Randolph | West Virginia | 54083 | 5707 | 60 |
1996366 | 1996366 | 2021-12-09 | Boyle | Kentucky | 21021 | 5707 | 107 |
1949795 | 1949795 | 2021-11-24 | Oneida | Wisconsin | 55085 | 5707 | 95 |
1926233 | 1926233 | 2021-11-17 | Ponce | Puerto Rico | 72113 | 5707 | |
1876189 | 1876189 | 2021-11-02 | Muhlenberg | Kentucky | 21177 | 5707 | 92 |
1850650 | 1850650 | 2021-10-25 | Howell | Missouri | 29091 | 5707 | 74 |
1845456 | 1845456 | 2021-10-23 | Titus | Texas | 48449 | 5707 | 101 |
1842206 | 1842206 | 2021-10-22 | Titus | Texas | 48449 | 5707 | 101 |
1808009 | 1808009 | 2021-10-12 | Evangeline | Louisiana | 22039 | 5707 | 139 |
1803106 | 1803106 | 2021-10-10 | Howard | Texas | 48227 | 5707 | 127 |
1772707 | 1772707 | 2021-10-01 | Platte | Missouri | 29165 | 5707 | 59 |
1767667 | 1767667 | 2021-09-29 | Shenandoah | Virginia | 51171 | 5707 | 145 |
1757840 | 1757840 | 2021-09-26 | Danville city | Virginia | 51590 | 5707 | 167 |
1754592 | 1754592 | 2021-09-25 | Danville city | Virginia | 51590 | 5707 | 167 |
1751344 | 1751344 | 2021-09-24 | Danville city | Virginia | 51590 | 5707 | 167 |
1719009 | 1719009 | 2021-09-14 | Jefferson | West Virginia | 54037 | 5707 | 68 |
1690023 | 1690023 | 2021-09-06 | Boone | Arkansas | 5009 | 5707 | 103 |
1630449 | 1630449 | 2021-08-18 | Yamhill | Oregon | 41071 | 5707 | 85 |
1582539 | 1582539 | 2021-08-03 | Lewis | Washington | 53041 | 5707 | 83 |
1537887 | 1537887 | 2021-07-21 | Knox | Illinois | 17095 | 5707 | 188 |
1489013 | 1489013 | 2021-07-06 | Laurens | Georgia | 13175 | 5707 | 173 |
1461570 | 1461570 | 2021-06-27 | Linn | Oregon | 41043 | 5707 | 81 |
1380032 | 1380032 | 2021-06-02 | Cattaraugus | New York | 36009 | 5707 | 89 |
1339843 | 1339843 | 2021-05-21 | Coles | Illinois | 17029 | 5707 | 101 |
1298402 | 1298402 | 2021-05-08 | Otter Tail | Minnesota | 27111 | 5707 | 78 |
1285904 | 1285904 | 2021-05-04 | Jefferson | New York | 36045 | 5707 | 66 |
1269141 | 1269141 | 2021-04-29 | Chisago | Minnesota | 27025 | 5707 | 51 |
1247703 | 1247703 | 2021-04-22 | Atascosa | Texas | 48013 | 5707 | 150 |
1229555 | 1229555 | 2021-04-17 | Dearborn | Indiana | 18029 | 5707 | 79 |
1217804 | 1217804 | 2021-04-13 | Lenoir | North Carolina | 37107 | 5707 | 109 |
1189341 | 1189341 | 2021-04-04 | Henderson | Texas | 48213 | 5707 | 180 |
1186094 | 1186094 | 2021-04-03 | Henderson | Texas | 48213 | 5707 | 180 |
1182847 | 1182847 | 2021-04-02 | Henderson | Texas | 48213 | 5707 | 179 |
1179600 | 1179600 | 2021-04-01 | Henderson | Texas | 48213 | 5707 | 179 |
1078158 | 1078158 | 2021-03-01 | Duplin | North Carolina | 37061 | 5707 | 127 |
1064692 | 1064692 | 2021-02-25 | Lafayette | Mississippi | 28071 | 5707 | 113 |
1029694 | 1029694 | 2021-02-14 | Bryan | Oklahoma | 40013 | 5707 | 52 |
1025626 | 1025626 | 2021-02-13 | Blue Earth | Minnesota | 27013 | 5707 | 34 |
1016690 | 1016690 | 2021-02-10 | Scioto | Ohio | 39145 | 5707 | 74 |
924128 | 924128 | 2021-01-13 | Fayette | Georgia | 13113 | 5707 | 86 |
901695 | 901695 | 2021-01-06 | Grant | Indiana | 18053 | 5707 | 108 |
877858 | 877858 | 2020-12-29 | Victoria | Texas | 48469 | 5707 | 118 |
832780 | 832780 | 2020-12-15 | St. Croix | Wisconsin | 55109 | 5707 | 22 |
741558 | 741558 | 2020-11-17 | Wichita | Texas | 48485 | 5707 | 90 |
729384 | 729384 | 2020-11-14 | Columbia | Georgia | 13073 | 5707 | 73 |
493915 | 493915 | 2020-09-02 | Jackson | Missouri | 29095 | 5707 | 78 |
431219 | 431219 | 2020-08-14 | Marin | California | 6041 | 5707 | 82 |
405600 | 405600 | 2020-08-06 | Marion | Florida | 12083 | 5707 | 83 |
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);