ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 6699 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Tennessee 6
- New York 5
- Ohio 5
- Idaho 4
- Minnesota 4
- Virginia 3
- Alabama 2
- Indiana 2
- New Jersey 2
- South Carolina 2
- Texas 2
- Arkansas 1
- Florida 1
- Georgia 1
- Illinois 1
- Kentucky 1
- Mississippi 1
- Nebraska 1
- North Carolina 1
- Pennsylvania 1
- South Dakota 1
- Vermont 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430933 | 2430933 | 2022-04-21 | Louisa | Virginia | 51109 | 6699 | 83 |
2402467 | 2402467 | 2022-04-13 | Latah | Idaho | 16057 | 6699 | 48 |
2404809 | 2404809 | 2022-04-13 | Windham | Vermont | 50025 | 6699 | 35 |
2399212 | 2399212 | 2022-04-12 | Latah | Idaho | 16057 | 6699 | 48 |
2333038 | 2333038 | 2022-03-22 | Howard | Texas | 48227 | 6699 | 182 |
2290159 | 2290159 | 2022-03-09 | Van Wert | Ohio | 39161 | 6699 | 140 |
2286907 | 2286907 | 2022-03-08 | Van Wert | Ohio | 39161 | 6699 | 140 |
2283655 | 2283655 | 2022-03-07 | Van Wert | Ohio | 39161 | 6699 | 140 |
2195096 | 2195096 | 2022-02-08 | Pine | Minnesota | 27115 | 6699 | 59 |
2117956 | 2117956 | 2022-01-15 | Susquehanna | Pennsylvania | 42115 | 6699 | 96 |
2101853 | 2101853 | 2022-01-10 | Codington | South Dakota | 46029 | 6699 | 91 |
2061781 | 2061781 | 2021-12-29 | Bolivar | Mississippi | 28011 | 6699 | 154 |
2017288 | 2017288 | 2021-12-15 | Chester | South Carolina | 45023 | 6699 | 123 |
1994001 | 1994001 | 2021-12-08 | Tioga | New York | 36107 | 6699 | 74 |
1964548 | 1964548 | 2021-11-29 | Dodge | Nebraska | 31053 | 6699 | 83 |
1921967 | 1921967 | 2021-11-16 | McLeod | Minnesota | 27085 | 6699 | 82 |
1876997 | 1876997 | 2021-11-02 | Tompkins | New York | 36109 | 6699 | 59 |
1873227 | 1873227 | 2021-11-01 | Mower | Minnesota | 27099 | 6699 | 42 |
1836127 | 1836127 | 2021-10-21 | Covington | Alabama | 1039 | 6699 | 183 |
1831606 | 1831606 | 2021-10-19 | Vance | North Carolina | 37181 | 6699 | 99 |
1809835 | 1809835 | 2021-10-12 | Fauquier | Virginia | 51061 | 6699 | 82 |
1770476 | 1770476 | 2021-09-30 | Rhea | Tennessee | 47143 | 6699 | 89 |
1667927 | 1667927 | 2021-08-30 | Noble | Indiana | 18113 | 6699 | 99 |
1627569 | 1627569 | 2021-08-17 | Atascosa | Texas | 48013 | 6699 | 155 |
1530083 | 1530083 | 2021-07-18 | McMinn | Tennessee | 47107 | 6699 | 104 |
1526836 | 1526836 | 2021-07-17 | McMinn | Tennessee | 47107 | 6699 | 104 |
1523589 | 1523589 | 2021-07-16 | McMinn | Tennessee | 47107 | 6699 | 104 |
1490429 | 1490429 | 2021-07-06 | Sullivan | New York | 36105 | 6699 | 76 |
1487182 | 1487182 | 2021-07-05 | Sullivan | New York | 36105 | 6699 | 76 |
1483936 | 1483936 | 2021-07-04 | Sullivan | New York | 36105 | 6699 | 76 |
1426149 | 1426149 | 2021-06-16 | Bedford | Tennessee | 47003 | 6699 | 131 |
1377474 | 1377474 | 2021-06-01 | Carter | Tennessee | 47019 | 6699 | 159 |
1337324 | 1337324 | 2021-05-20 | Crow Wing | Minnesota | 27035 | 6699 | 90 |
1313858 | 1313858 | 2021-05-13 | Boone | Illinois | 17007 | 6699 | 84 |
1314317 | 1314317 | 2021-05-13 | Laurel | Kentucky | 21125 | 6699 | 71 |
1230968 | 1230968 | 2021-04-17 | Ross | Ohio | 39141 | 6699 | 146 |
1219499 | 1219499 | 2021-04-14 | Bulloch | Georgia | 13031 | 6699 | 111 |
1141738 | 1141738 | 2021-03-21 | Madison | Idaho | 16065 | 6699 | 22 |
1138492 | 1138492 | 2021-03-20 | Madison | Idaho | 16065 | 6699 | 22 |
1134693 | 1134693 | 2021-03-19 | Jackson | Alabama | 1071 | 6699 | 105 |
1055306 | 1055306 | 2021-02-22 | Hunterdon | New Jersey | 34019 | 6699 | 156 |
1011702 | 1011702 | 2021-02-09 | Walton | Florida | 12131 | 6699 | 74 |
919266 | 919266 | 2021-01-11 | Columbiana | Ohio | 39029 | 6699 | 122 |
787080 | 787080 | 2020-12-01 | Chesapeake city | Virginia | 51550 | 6699 | 80 |
783955 | 783955 | 2020-11-30 | Franklin | Washington | 53021 | 6699 | 75 |
687578 | 687578 | 2020-11-01 | Vanderburgh | Indiana | 18163 | 6699 | 76 |
583120 | 583120 | 2020-09-30 | Benton | Arkansas | 5007 | 6699 | 93 |
317904 | 317904 | 2020-07-09 | Charleston | South Carolina | 45019 | 6699 | 51 |
260556 | 260556 | 2020-06-21 | Morris | New Jersey | 34027 | 6699 | 641 |
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);