ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 6586 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Nevada 8
- Iowa 7
- Texas 6
- Virginia 6
- Kentucky 4
- Louisiana 4
- Mississippi 4
- Montana 4
- Georgia 3
- Minnesota 3
- Ohio 3
- South Carolina 3
- Indiana 2
- Massachusetts 2
- Michigan 2
- North Carolina 2
- Puerto Rico 2
- Tennessee 2
- Arkansas 1
- California 1
- Colorado 1
- Illinois 1
- Pennsylvania 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500944 | 2500944 | 2022-05-13 | Le Sueur | Minnesota | 27079 | 6586 | 51 |
2491570 | 2491570 | 2022-05-10 | Churchill | Nevada | 32001 | 6586 | 110 |
2488312 | 2488312 | 2022-05-09 | Churchill | Nevada | 32001 | 6586 | 110 |
2485055 | 2485055 | 2022-05-08 | Churchill | Nevada | 32001 | 6586 | 110 |
2481797 | 2481797 | 2022-05-07 | Churchill | Nevada | 32001 | 6586 | 110 |
2478539 | 2478539 | 2022-05-06 | Churchill | Nevada | 32001 | 6586 | 110 |
2475281 | 2475281 | 2022-05-05 | Churchill | Nevada | 32001 | 6586 | 110 |
2472024 | 2472024 | 2022-05-04 | Churchill | Nevada | 32001 | 6586 | 110 |
2453097 | 2453097 | 2022-04-28 | Juana Diaz | Puerto Rico | 72075 | 6586 | |
2416545 | 2416545 | 2022-04-17 | Lake | Montana | 30047 | 6586 | 98 |
2413289 | 2413289 | 2022-04-16 | Lake | Montana | 30047 | 6586 | 98 |
2410033 | 2410033 | 2022-04-15 | Lake | Montana | 30047 | 6586 | 98 |
2397011 | 2397011 | 2022-04-11 | Lake | Montana | 30047 | 6586 | 98 |
2339165 | 2339165 | 2022-03-24 | Dorado | Puerto Rico | 72051 | 6586 | |
2307941 | 2307941 | 2022-03-15 | Chattooga | Georgia | 13055 | 6586 | 129 |
2290963 | 2290963 | 2022-03-09 | Carroll | Virginia | 51035 | 6586 | 137 |
2244908 | 2244908 | 2022-02-23 | Abbeville | South Carolina | 45001 | 6586 | 65 |
2233857 | 2233857 | 2022-02-20 | Woodford | Kentucky | 21239 | 6586 | 42 |
2230606 | 2230606 | 2022-02-19 | Woodford | Kentucky | 21239 | 6586 | 42 |
2227355 | 2227355 | 2022-02-18 | Woodford | Kentucky | 21239 | 6586 | 42 |
2212914 | 2212914 | 2022-02-13 | Amherst | Virginia | 51009 | 6586 | 76 |
2209661 | 2209661 | 2022-02-12 | Amherst | Virginia | 51009 | 6586 | 76 |
2206408 | 2206408 | 2022-02-11 | Amherst | Virginia | 51009 | 6586 | 76 |
2178774 | 2178774 | 2022-02-03 | Wexford | Michigan | 26165 | 6586 | 96 |
2175522 | 2175522 | 2022-02-02 | Wexford | Michigan | 26165 | 6586 | 96 |
2165869 | 2165869 | 2022-01-30 | George | Mississippi | 28039 | 6586 | 81 |
2162614 | 2162614 | 2022-01-29 | George | Mississippi | 28039 | 6586 | 81 |
2159359 | 2159359 | 2022-01-28 | George | Mississippi | 28039 | 6586 | 81 |
2147241 | 2147241 | 2022-01-24 | Warren | Pennsylvania | 42123 | 6586 | 192 |
2035543 | 2035543 | 2021-12-21 | Vernon | Louisiana | 22115 | 6586 | 167 |
1989739 | 1989739 | 2021-12-07 | Wapello | Iowa | 19179 | 6586 | 145 |
1986489 | 1986489 | 2021-12-06 | Wapello | Iowa | 19179 | 6586 | 145 |
1983239 | 1983239 | 2021-12-05 | Wapello | Iowa | 19179 | 6586 | 145 |
1979989 | 1979989 | 2021-12-04 | Wapello | Iowa | 19179 | 6586 | 145 |
1976739 | 1976739 | 2021-12-03 | Wapello | Iowa | 19179 | 6586 | 145 |
1973490 | 1973490 | 2021-12-02 | Wapello | Iowa | 19179 | 6586 | 145 |
1970240 | 1970240 | 2021-12-01 | Wapello | Iowa | 19179 | 6586 | 145 |
1933219 | 1933219 | 2021-11-19 | Wood | Texas | 48499 | 6586 | 229 |
1929968 | 1929968 | 2021-11-18 | Wood | Texas | 48499 | 6586 | 229 |
1926718 | 1926718 | 2021-11-17 | Wood | Texas | 48499 | 6586 | 228 |
1920872 | 1920872 | 2021-11-16 | La Plata | Colorado | 8067 | 6586 | 57 |
1923468 | 1923468 | 2021-11-16 | Wood | Texas | 48499 | 6586 | 228 |
1918806 | 1918806 | 2021-11-15 | Marshall | Mississippi | 28093 | 6586 | 139 |
1920206 | 1920206 | 2021-11-15 | Waller | Texas | 48473 | 6586 | 83 |
1904137 | 1904137 | 2021-11-10 | Shenandoah | Virginia | 51171 | 6586 | 163 |
1882316 | 1882316 | 2021-11-04 | DeKalb | Indiana | 18033 | 6586 | 105 |
1884583 | 1884583 | 2021-11-04 | Henry | Virginia | 51089 | 6586 | 161 |
1879700 | 1879700 | 2021-11-03 | Goodhue | Minnesota | 27049 | 6586 | 88 |
1869757 | 1869757 | 2021-10-31 | Natchitoches | Louisiana | 22069 | 6586 | 135 |
1866508 | 1866508 | 2021-10-30 | Natchitoches | Louisiana | 22069 | 6586 | 135 |
1863259 | 1863259 | 2021-10-29 | Natchitoches | Louisiana | 22069 | 6586 | 135 |
1736037 | 1736037 | 2021-09-20 | Knox | Illinois | 17095 | 6586 | 195 |
1518982 | 1518982 | 2021-07-15 | Berkshire | Massachusetts | 25003 | 6586 | 288 |
1495273 | 1495273 | 2021-07-08 | Yuba | California | 6115 | 6586 | 51 |
1422136 | 1422136 | 2021-06-15 | Carson City | Nevada | 32510 | 6586 | 124 |
1304273 | 1304273 | 2021-05-10 | Morgan | Indiana | 18109 | 6586 | 144 |
1301612 | 1301612 | 2021-05-09 | Crow Wing | Minnesota | 27035 | 6586 | 88 |
1260000 | 1260000 | 2021-04-26 | Franklin | North Carolina | 37069 | 6586 | 49 |
1256902 | 1256902 | 2021-04-25 | Geauga | Ohio | 39055 | 6586 | 146 |
1244371 | 1244371 | 2021-04-21 | Cumberland | Tennessee | 47035 | 6586 | 128 |
1131816 | 1131816 | 2021-03-18 | Bulloch | Georgia | 13031 | 6586 | 99 |
1036015 | 1036015 | 2021-02-16 | Rutherford | North Carolina | 37161 | 6586 | 193 |
1022283 | 1022283 | 2021-02-12 | Hampshire | Massachusetts | 25015 | 6586 | 245 |
1017930 | 1017930 | 2021-02-11 | Crawford | Arkansas | 5033 | 6586 | 99 |
1001420 | 1001420 | 2021-02-05 | Thurston | Washington | 53067 | 6586 | 69 |
994987 | 994987 | 2021-02-03 | Wood | West Virginia | 54107 | 6586 | 112 |
833823 | 833823 | 2020-12-16 | Boone | Kentucky | 21015 | 6586 | 35 |
819014 | 819014 | 2020-12-11 | Dorchester | South Carolina | 45035 | 6586 | 117 |
792726 | 792726 | 2020-12-03 | Licking | Ohio | 39089 | 6586 | 77 |
776985 | 776985 | 2020-11-28 | Montgomery | Tennessee | 47125 | 6586 | 83 |
767877 | 767877 | 2020-11-25 | Walworth | Wisconsin | 55127 | 6586 | 50 |
734624 | 734624 | 2020-11-15 | Beaufort | South Carolina | 45013 | 6586 | 93 |
641777 | 641777 | 2020-10-18 | Bibb | Georgia | 13021 | 6586 | 188 |
475706 | 475706 | 2020-08-27 | Jefferson | Texas | 48245 | 6586 | 106 |
220396 | 220396 | 2020-06-08 | Franklin | Ohio | 39049 | 6586 | 300 |
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);