ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 7697 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Kentucky 7
- Michigan 5
- Wisconsin 5
- Mississippi 4
- Indiana 3
- Ohio 3
- Pennsylvania 3
- Virginia 3
- Alabama 2
- Florida 2
- Nebraska 2
- North Carolina 2
- North Dakota 2
- South Carolina 2
- Georgia 1
- New Jersey 1
- New York 1
- Oregon 1
- Puerto Rico 1
- Tennessee 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446447 | 2446447 | 2022-04-26 | Columbia | Oregon | 41009 | 7697 | 93 |
2417278 | 2417278 | 2022-04-17 | Humacao | Puerto Rico | 72069 | 7697 | |
2355031 | 2355031 | 2022-03-29 | Macon | North Carolina | 37113 | 7697 | 113 |
2313103 | 2313103 | 2022-03-16 | Susquehanna | Pennsylvania | 42115 | 7697 | 107 |
2257615 | 2257615 | 2022-02-27 | Morrow | Ohio | 39117 | 7697 | 96 |
2175692 | 2175692 | 2022-02-02 | Yazoo | Mississippi | 28163 | 7697 | 97 |
2017511 | 2017511 | 2021-12-15 | Burnet | Texas | 48053 | 7697 | 132 |
2006168 | 2006168 | 2021-12-12 | Knox | Kentucky | 21121 | 7697 | 97 |
2002917 | 2002917 | 2021-12-11 | Knox | Kentucky | 21121 | 7697 | 97 |
1999667 | 1999667 | 2021-12-10 | Knox | Kentucky | 21121 | 7697 | 97 |
1989959 | 1989959 | 2021-12-07 | Shelby | Kentucky | 21211 | 7697 | 117 |
1970072 | 1970072 | 2021-12-01 | DeKalb | Indiana | 18033 | 7697 | 111 |
1942420 | 1942420 | 2021-11-22 | Venango | Pennsylvania | 42121 | 7697 | 160 |
1919653 | 1919653 | 2021-11-15 | Mifflin | Pennsylvania | 42087 | 7697 | 214 |
1905097 | 1905097 | 2021-11-11 | Lawrence | Indiana | 18093 | 7697 | 183 |
1899881 | 1899881 | 2021-11-09 | Morton | North Dakota | 38059 | 7697 | 120 |
1824550 | 1824550 | 2021-10-17 | Hancock | Mississippi | 28045 | 7697 | 126 |
1821301 | 1821301 | 2021-10-16 | Hancock | Mississippi | 28045 | 7697 | 126 |
1818052 | 1818052 | 2021-10-15 | Hancock | Mississippi | 28045 | 7697 | 126 |
1793549 | 1793549 | 2021-10-07 | Albemarle | Virginia | 51003 | 7697 | 96 |
1739360 | 1739360 | 2021-09-21 | Dubois | Indiana | 18037 | 7697 | 124 |
1680180 | 1680180 | 2021-09-03 | Dale | Alabama | 1045 | 7697 | 135 |
1665018 | 1665018 | 2021-08-29 | Pike | Kentucky | 21195 | 7697 | 125 |
1661770 | 1661770 | 2021-08-28 | Pike | Kentucky | 21195 | 7697 | 125 |
1658522 | 1658522 | 2021-08-27 | Pike | Kentucky | 21195 | 7697 | 125 |
1623619 | 1623619 | 2021-08-16 | Columbus | North Carolina | 37047 | 7697 | 162 |
1582459 | 1582459 | 2021-08-03 | Lynchburg city | Virginia | 51680 | 7697 | 149 |
1554735 | 1554735 | 2021-07-26 | Clinton | Michigan | 26037 | 7697 | 95 |
1551488 | 1551488 | 2021-07-25 | Clinton | Michigan | 26037 | 7697 | 95 |
1548241 | 1548241 | 2021-07-24 | Clinton | Michigan | 26037 | 7697 | 95 |
1544994 | 1544994 | 2021-07-23 | Clinton | Michigan | 26037 | 7697 | 95 |
1420288 | 1420288 | 2021-06-14 | Chippewa | Wisconsin | 55017 | 7697 | 96 |
1417106 | 1417106 | 2021-06-13 | Wood | Wisconsin | 55141 | 7697 | 103 |
1413860 | 1413860 | 2021-06-12 | Wood | Wisconsin | 55141 | 7697 | 103 |
1410615 | 1410615 | 2021-06-11 | Wood | Wisconsin | 55141 | 7697 | 103 |
1407370 | 1407370 | 2021-06-10 | Wood | Wisconsin | 55141 | 7697 | 101 |
1367053 | 1367053 | 2021-05-29 | Chemung | New York | 36015 | 7697 | 135 |
1250402 | 1250402 | 2021-04-23 | Erie | Ohio | 39043 | 7697 | 154 |
1240288 | 1240288 | 2021-04-20 | Hall | Nebraska | 31079 | 7697 | 116 |
1237041 | 1237041 | 2021-04-19 | Hall | Nebraska | 31079 | 7697 | 116 |
1122921 | 1122921 | 2021-03-15 | Bay | Michigan | 26017 | 7697 | 297 |
1108470 | 1108470 | 2021-03-10 | Roanoke city | Virginia | 51770 | 7697 | 173 |
1083049 | 1083049 | 2021-03-03 | Columbia | Florida | 12023 | 7697 | 157 |
978048 | 978048 | 2021-01-29 | Lancaster | South Carolina | 45057 | 7697 | 114 |
834886 | 834886 | 2020-12-16 | Clark | Ohio | 39023 | 7697 | 150 |
812511 | 812511 | 2020-12-09 | Beaufort | South Carolina | 45013 | 7697 | 94 |
789432 | 789432 | 2020-12-02 | Ward | North Dakota | 38101 | 7697 | 137 |
695899 | 695899 | 2020-11-03 | Williamson | Tennessee | 47187 | 7697 | 59 |
560160 | 560160 | 2020-09-22 | Snohomish | Washington | 53061 | 7697 | 224 |
521892 | 521892 | 2020-09-11 | Chatham | Georgia | 13051 | 7697 | 134 |
469792 | 469792 | 2020-08-26 | Montgomery | Alabama | 1101 | 7697 | 159 |
296905 | 296905 | 2020-07-03 | Pinellas | Florida | 12103 | 7697 | 183 |
288818 | 288818 | 2020-06-30 | Mercer | New Jersey | 34021 | 7697 | 577 |
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);