ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 5403 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Arkansas 7
- Illinois 5
- Wisconsin 5
- Georgia 4
- Michigan 4
- Ohio 4
- Pennsylvania 4
- Virginia 4
- North Carolina 3
- South Carolina 3
- Alabama 2
- California 2
- Colorado 2
- Idaho 2
- Indiana 2
- Iowa 2
- Kentucky 2
- Mississippi 2
- New York 2
- Oregon 2
- West Virginia 2
- Florida 1
- Maine 1
- Minnesota 1
- Missouri 1
- Nebraska 1
- New Jersey 1
- South Dakota 1
- Tennessee 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2402330 | 2402330 | 2022-04-13 | Franklin | Georgia | 13119 | 5403 | 101 |
2330420 | 2330420 | 2022-03-22 | Columbia | Arkansas | 5027 | 5403 | 91 |
2262120 | 2262120 | 2022-03-01 | Conway | Arkansas | 5029 | 5403 | 58 |
2258869 | 2258869 | 2022-02-28 | Conway | Arkansas | 5029 | 5403 | 58 |
2243084 | 2243084 | 2022-02-23 | Payette | Idaho | 16075 | 5403 | 82 |
2237177 | 2237177 | 2022-02-21 | Franklin | Maine | 23007 | 5403 | 52 |
2222366 | 2222366 | 2022-02-16 | Austin | Texas | 48015 | 5403 | 68 |
2210481 | 2210481 | 2022-02-13 | Pierce | Georgia | 13229 | 5403 | 116 |
2207228 | 2207228 | 2022-02-12 | Pierce | Georgia | 13229 | 5403 | 116 |
2203975 | 2203975 | 2022-02-11 | Pierce | Georgia | 13229 | 5403 | 116 |
2172481 | 2172481 | 2022-02-01 | Henry | Missouri | 29083 | 5403 | 74 |
2164610 | 2164610 | 2022-01-30 | Sevier | Arkansas | 5133 | 5403 | 63 |
2161355 | 2161355 | 2022-01-29 | Sevier | Arkansas | 5133 | 5403 | 63 |
2158099 | 2158099 | 2022-01-28 | Sevier | Arkansas | 5133 | 5403 | 63 |
2108806 | 2108806 | 2022-01-12 | Accomack | Virginia | 51001 | 5403 | 84 |
2100780 | 2100780 | 2022-01-10 | Todd | Minnesota | 27153 | 5403 | 53 |
2062455 | 2062455 | 2021-12-29 | Hardin | Ohio | 39065 | 5403 | 118 |
2053885 | 2053885 | 2021-12-27 | Dallas | Alabama | 1047 | 5403 | 212 |
1974506 | 1974506 | 2021-12-02 | Wyoming | New York | 36121 | 5403 | 67 |
1959646 | 1959646 | 2021-11-28 | Marion | Alabama | 1093 | 5403 | 130 |
1942218 | 1942218 | 2021-11-22 | Ottawa | Ohio | 39123 | 5403 | 98 |
1929388 | 1929388 | 2021-11-18 | Greene | Pennsylvania | 42059 | 5403 | 65 |
1904976 | 1904976 | 2021-11-11 | Fulton | Illinois | 17057 | 5403 | 92 |
1901726 | 1901726 | 2021-11-10 | Fulton | Illinois | 17057 | 5403 | 92 |
1900970 | 1900970 | 2021-11-09 | Marshall | West Virginia | 54051 | 5403 | 116 |
1900984 | 1900984 | 2021-11-09 | Preston | West Virginia | 54077 | 5403 | 90 |
1828810 | 1828810 | 2021-10-18 | Marion | South Carolina | 45067 | 5403 | 136 |
1828837 | 1828837 | 2021-10-18 | Codington | South Dakota | 46029 | 5403 | 84 |
1744317 | 1744317 | 2021-09-22 | Colleton | South Carolina | 45029 | 5403 | 175 |
1696968 | 1696968 | 2021-09-08 | Bingham | Idaho | 16011 | 5403 | 80 |
1652396 | 1652396 | 2021-08-25 | Panola | Mississippi | 28107 | 5403 | 112 |
1644673 | 1644673 | 2021-08-23 | Tuolumne | California | 6109 | 5403 | 83 |
1632089 | 1632089 | 2021-08-19 | Macoupin | Illinois | 17117 | 5403 | 121 |
1634378 | 1634378 | 2021-08-19 | Campbell | Virginia | 51031 | 5403 | 109 |
1576172 | 1576172 | 2021-08-01 | Shawano | Wisconsin | 55115 | 5403 | 85 |
1572924 | 1572924 | 2021-07-31 | Shawano | Wisconsin | 55115 | 5403 | 85 |
1569676 | 1569676 | 2021-07-30 | Shawano | Wisconsin | 55115 | 5403 | 85 |
1386980 | 1386980 | 2021-06-04 | Mifflin | Pennsylvania | 42087 | 5403 | 178 |
1383735 | 1383735 | 2021-06-03 | Mifflin | Pennsylvania | 42087 | 5403 | 178 |
1317313 | 1317313 | 2021-05-14 | Cerro Gordo | Iowa | 19033 | 5403 | 89 |
1278864 | 1278864 | 2021-05-02 | Tuscola | Michigan | 26157 | 5403 | 163 |
1279642 | 1279642 | 2021-05-02 | Huron | Ohio | 39077 | 5403 | 118 |
1275617 | 1275617 | 2021-05-01 | Tuscola | Michigan | 26157 | 5403 | 163 |
1258709 | 1258709 | 2021-04-26 | Knox | Illinois | 17095 | 5403 | 169 |
1227268 | 1227268 | 2021-04-16 | Buffalo | Nebraska | 31019 | 5403 | 57 |
1186298 | 1186298 | 2021-04-03 | Augusta | Virginia | 51015 | 5403 | 68 |
1166204 | 1166204 | 2021-03-28 | Union | Pennsylvania | 42119 | 5403 | 85 |
1161247 | 1161247 | 2021-03-27 | Coles | Illinois | 17029 | 5403 | 95 |
1134584 | 1134584 | 2021-03-18 | Grant | Wisconsin | 55043 | 5403 | 88 |
1050525 | 1050525 | 2021-02-21 | Fremont | Colorado | 8043 | 5403 | 48 |
1005922 | 1005922 | 2021-02-07 | Pulaski | Kentucky | 21199 | 5403 | 77 |
1002676 | 1002676 | 2021-02-06 | Pulaski | Kentucky | 21199 | 5403 | 77 |
984333 | 984333 | 2021-01-31 | Deschutes | Oregon | 41017 | 5403 | 45 |
981086 | 981086 | 2021-01-30 | Deschutes | Oregon | 41017 | 5403 | 45 |
969090 | 969090 | 2021-01-26 | Waupaca | Wisconsin | 55135 | 5403 | 146 |
955418 | 955418 | 2021-01-22 | Bedford | Tennessee | 47003 | 5403 | 91 |
950947 | 950947 | 2021-01-21 | Montcalm | Michigan | 26117 | 5403 | 84 |
928910 | 928910 | 2021-01-14 | Rockingham | North Carolina | 37157 | 5403 | 31 |
899649 | 899649 | 2021-01-05 | Craven | North Carolina | 37049 | 5403 | 87 |
894858 | 894858 | 2021-01-04 | Sumter | Florida | 12119 | 5403 | 122 |
878415 | 878415 | 2020-12-30 | Pope | Arkansas | 5115 | 5403 | 55 |
862813 | 862813 | 2020-12-25 | Wayne | Indiana | 18177 | 5403 | 133 |
827058 | 827058 | 2020-12-14 | Howard | Indiana | 18067 | 5403 | 91 |
788832 | 788832 | 2020-12-02 | Lee | Mississippi | 28081 | 5403 | 96 |
782188 | 782188 | 2020-11-30 | Monroe | Michigan | 26115 | 5403 | 81 |
760251 | 760251 | 2020-11-23 | Delaware | Ohio | 39041 | 5403 | 35 |
753677 | 753677 | 2020-11-21 | Wayne | North Carolina | 37191 | 5403 | 110 |
726593 | 726593 | 2020-11-13 | Story | Iowa | 19169 | 5403 | 18 |
661098 | 661098 | 2020-10-24 | Boulder | Colorado | 8013 | 5403 | 85 |
659460 | 659460 | 2020-10-23 | Dutchess | New York | 36027 | 5403 | 165 |
549784 | 549784 | 2020-09-19 | Beaufort | South Carolina | 45013 | 5403 | 81 |
448937 | 448937 | 2020-08-19 | Somerset | New Jersey | 34035 | 5403 | 565 |
430760 | 430760 | 2020-08-13 | Loudoun | Virginia | 51107 | 5403 | 115 |
271534 | 271534 | 2020-06-25 | Alameda | California | 6001 | 5403 | 128 |
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);