ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where cases = 4900 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Arkansas 10
- Georgia 9
- Texas 9
- Illinois 8
- Virginia 7
- Missouri 4
- Indiana 3
- Kentucky 3
- Michigan 3
- Pennsylvania 3
- Vermont 3
- Alaska 2
- Connecticut 2
- Mississippi 2
- North Carolina 2
- North Dakota 2
- Ohio 2
- Tennessee 2
- West Virginia 2
- Alabama 1
- Idaho 1
- Maryland 1
- Minnesota 1
- New Mexico 1
- Puerto Rico 1
- South Carolina 1
- Utah 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496009 | 2496009 | 2022-05-11 | Buchanan | Virginia | 51027 | 4900 | 122 |
2492751 | 2492751 | 2022-05-10 | Buchanan | Virginia | 51027 | 4900 | 122 |
2467426 | 2467426 | 2022-05-03 | Cook | Georgia | 13075 | 4900 | 75 |
2464171 | 2464171 | 2022-05-02 | Cook | Georgia | 13075 | 4900 | 75 |
2460915 | 2460915 | 2022-05-01 | Cook | Georgia | 13075 | 4900 | 75 |
2457659 | 2457659 | 2022-04-30 | Cook | Georgia | 13075 | 4900 | 75 |
2454403 | 2454403 | 2022-04-29 | Cook | Georgia | 13075 | 4900 | 75 |
2451147 | 2451147 | 2022-04-28 | Cook | Georgia | 13075 | 4900 | 75 |
2447891 | 2447891 | 2022-04-27 | Cook | Georgia | 13075 | 4900 | 75 |
2417828 | 2417828 | 2022-04-17 | Orange | Vermont | 50017 | 4900 | 14 |
2414572 | 2414572 | 2022-04-16 | Orange | Vermont | 50017 | 4900 | 14 |
2411316 | 2411316 | 2022-04-15 | Orange | Vermont | 50017 | 4900 | 14 |
2405563 | 2405563 | 2022-04-14 | Cook | Georgia | 13075 | 4900 | 74 |
2382125 | 2382125 | 2022-04-06 | Prince Edward | Virginia | 51147 | 4900 | 69 |
2310927 | 2310927 | 2022-03-16 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2311551 | 2311551 | 2022-03-16 | Rush | Indiana | 18139 | 4900 | 58 |
2307674 | 2307674 | 2022-03-15 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2308298 | 2308298 | 2022-03-15 | Rush | Indiana | 18139 | 4900 | 59 |
2304423 | 2304423 | 2022-03-14 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2301171 | 2301171 | 2022-03-13 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2297919 | 2297919 | 2022-03-12 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2294667 | 2294667 | 2022-03-11 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2291415 | 2291415 | 2022-03-10 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2292844 | 2292844 | 2022-03-10 | Perry | Missouri | 29157 | 4900 | 44 |
2288163 | 2288163 | 2022-03-09 | Lincoln | Arkansas | 5079 | 4900 | 66 |
2271291 | 2271291 | 2022-03-03 | Milam | Texas | 48331 | 4900 | 99 |
2239638 | 2239638 | 2022-02-22 | Berrien | Georgia | 13019 | 4900 | 75 |
2225976 | 2225976 | 2022-02-17 | King George | Virginia | 51099 | 4900 | 33 |
2172771 | 2172771 | 2022-02-01 | Lincoln | New Mexico | 35027 | 4900 | 56 |
2107333 | 2107333 | 2022-01-12 | Leake | Mississippi | 28079 | 4900 | 92 |
2087973 | 2087973 | 2022-01-06 | Stoddard | Missouri | 29207 | 4900 | 110 |
2085853 | 2085853 | 2022-01-05 | Hockley | Texas | 48219 | 4900 | 141 |
2065577 | 2065577 | 2021-12-30 | Montgomery | North Carolina | 37123 | 4900 | 110 |
2018148 | 2018148 | 2021-12-16 | Lawrence | Alabama | 1079 | 4900 | 133 |
2009089 | 2009089 | 2021-12-13 | Greene | Indiana | 18055 | 4900 | 107 |
1969960 | 1969960 | 2021-12-01 | Bureau | Illinois | 17011 | 4900 | 111 |
1943223 | 1943223 | 2021-11-22 | Mineral | West Virginia | 54057 | 4900 | 119 |
1899320 | 1899320 | 2021-11-09 | Prentiss | Mississippi | 28117 | 4900 | 83 |
1900166 | 1900166 | 2021-11-09 | Snyder | Pennsylvania | 42109 | 4900 | 106 |
1835885 | 1835885 | 2021-10-20 | Prince George | Virginia | 51149 | 4900 | 40 |
1815466 | 1815466 | 2021-10-14 | Jackson | Ohio | 39079 | 4900 | 69 |
1797685 | 1797685 | 2021-10-09 | Bonner | Idaho | 16017 | 4900 | 78 |
1785196 | 1785196 | 2021-10-05 | Logan | Kentucky | 21141 | 4900 | 77 |
1781901 | 1781901 | 2021-10-04 | Clark | Kentucky | 21049 | 4900 | 32 |
1758029 | 1758029 | 2021-09-26 | Wayne | West Virginia | 54099 | 4900 | 57 |
1753763 | 1753763 | 2021-09-25 | Putnam | Ohio | 39137 | 4900 | 107 |
1741696 | 1741696 | 2021-09-21 | York | Virginia | 51199 | 4900 | 64 |
1717446 | 1717446 | 2021-09-14 | Lawrence | Missouri | 29109 | 4900 | 101 |
1714227 | 1714227 | 2021-09-13 | Polk | Missouri | 29167 | 4900 | 52 |
1690576 | 1690576 | 2021-09-06 | Monroe | Illinois | 17133 | 4900 | 96 |
1687326 | 1687326 | 2021-09-05 | Monroe | Illinois | 17133 | 4900 | 96 |
1684076 | 1684076 | 2021-09-04 | Monroe | Illinois | 17133 | 4900 | 96 |
1680825 | 1680825 | 2021-09-03 | Monroe | Illinois | 17133 | 4900 | 96 |
1553098 | 1553098 | 2021-07-25 | Wilson | Texas | 48493 | 4900 | 72 |
1549851 | 1549851 | 2021-07-24 | Wilson | Texas | 48493 | 4900 | 72 |
1531447 | 1531447 | 2021-07-19 | Woodford | Illinois | 17203 | 4900 | 96 |
1516907 | 1516907 | 2021-07-14 | Toa Baja | Puerto Rico | 72137 | 4900 | |
1473607 | 1473607 | 2021-07-01 | Newaygo | Michigan | 26123 | 4900 | 68 |
1467762 | 1467762 | 2021-06-29 | Hoke | North Carolina | 37093 | 4900 | 56 |
1443750 | 1443750 | 2021-06-22 | Livingston | Illinois | 17105 | 4900 | 103 |
1393591 | 1393591 | 2021-06-06 | Chesterfield | South Carolina | 45025 | 4900 | 106 |
1370495 | 1370495 | 2021-05-30 | Stark | North Dakota | 38089 | 4900 | 51 |
1348449 | 1348449 | 2021-05-23 | Harrison | Texas | 48203 | 4900 | 109 |
1341286 | 1341286 | 2021-05-21 | Williams | North Dakota | 38105 | 4900 | 39 |
1291619 | 1291619 | 2021-05-06 | Nelson | Kentucky | 21179 | 4900 | 55 |
1287236 | 1287236 | 2021-05-04 | Pierce | Wisconsin | 55093 | 4900 | 43 |
1241365 | 1241365 | 2021-04-20 | Medina | Texas | 48325 | 4900 | 103 |
1185635 | 1185635 | 2021-04-03 | Bradford | Pennsylvania | 42015 | 4900 | 84 |
1113189 | 1113189 | 2021-03-12 | Chippewa | Michigan | 26033 | 4900 | 43 |
1108316 | 1108316 | 2021-03-10 | Box Elder | Utah | 49003 | 4900 | 46 |
1048351 | 1048351 | 2021-02-20 | Chisago | Minnesota | 27025 | 4900 | 44 |
1035354 | 1035354 | 2021-02-16 | Van Buren | Michigan | 26159 | 4900 | 95 |
1028761 | 1028761 | 2021-02-14 | St. Mary's | Maryland | 24037 | 4900 | 110 |
1013606 | 1013606 | 2021-02-09 | Indiana | Pennsylvania | 42063 | 4900 | 151 |
985959 | 985959 | 2021-02-01 | Coles | Illinois | 17029 | 4900 | 88 |
940065 | 940065 | 2021-01-18 | Mississippi | Arkansas | 5093 | 4900 | 101 |
884812 | 884812 | 2021-01-01 | Fairbanks North Star Borough | Alaska | 2090 | 4900 | 19 |
885052 | 885052 | 2021-01-01 | Tolland | Connecticut | 9013 | 4900 | 109 |
881567 | 881567 | 2020-12-31 | Fairbanks North Star Borough | Alaska | 2090 | 4900 | 19 |
881807 | 881807 | 2020-12-31 | Tolland | Connecticut | 9013 | 4900 | 109 |
786882 | 786882 | 2020-12-01 | Kaufman | Texas | 48257 | 4900 | 83 |
783638 | 783638 | 2020-11-30 | Kaufman | Texas | 48257 | 4900 | 80 |
780393 | 780393 | 2020-11-29 | Kaufman | Texas | 48257 | 4900 | 80 |
750963 | 750963 | 2020-11-20 | Blount | Tennessee | 47009 | 4900 | 55 |
605510 | 605510 | 2020-10-06 | Benton | Washington | 53005 | 4900 | 135 |
592490 | 592490 | 2020-10-02 | Norfolk city | Virginia | 51710 | 4900 | 78 |
434351 | 434351 | 2020-08-15 | Benton | Arkansas | 5007 | 4900 | 43 |
369179 | 369179 | 2020-07-25 | Hamilton | Tennessee | 47065 | 4900 | 44 |
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);