ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 7182 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- North Carolina 6
- Texas 5
- Wisconsin 5
- Georgia 3
- Indiana 3
- Puerto Rico 2
- Virginia 2
- Alabama 1
- Arkansas 1
- Florida 1
- Idaho 1
- Illinois 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492057 | 2492057 | 2022-05-10 | Lincoln | Oregon | 41041 | 7182 | 85 |
2396034 | 2396034 | 2022-04-11 | McDonough | Illinois | 17109 | 7182 | 103 |
2360152 | 2360152 | 2022-03-31 | Elmore | Idaho | 16039 | 7182 | 70 |
2352751 | 2352751 | 2022-03-28 | Amherst | Virginia | 51009 | 7182 | 85 |
2308007 | 2308007 | 2022-03-15 | Lumpkin | Georgia | 13187 | 7182 | 129 |
2294004 | 2294004 | 2022-03-10 | Hopkins | Texas | 48223 | 7182 | 177 |
2263480 | 2263480 | 2022-03-01 | Tippah | Mississippi | 28139 | 7182 | 106 |
2221665 | 2221665 | 2022-02-16 | Dare | North Carolina | 37055 | 7182 | 21 |
2218875 | 2218875 | 2022-02-15 | Rio Grande | Puerto Rico | 72119 | 7182 | |
2123877 | 2123877 | 2022-01-17 | Platte | Nebraska | 31141 | 7182 | 69 |
1973975 | 1973975 | 2021-12-02 | McLeod | Minnesota | 27085 | 7182 | 84 |
1975432 | 1975432 | 2021-12-02 | San Patricio | Texas | 48409 | 7182 | 298 |
1907313 | 1907313 | 2021-11-11 | Fauquier | Virginia | 51061 | 7182 | 86 |
1870195 | 1870195 | 2021-10-31 | Scott | Missouri | 29201 | 7182 | 114 |
1806170 | 1806170 | 2021-10-11 | Fayette | Tennessee | 47047 | 7182 | 100 |
1758103 | 1758103 | 2021-09-26 | Waupaca | Wisconsin | 55135 | 7182 | 178 |
1754855 | 1754855 | 2021-09-25 | Waupaca | Wisconsin | 55135 | 7182 | 178 |
1751607 | 1751607 | 2021-09-24 | Waupaca | Wisconsin | 55135 | 7182 | 178 |
1742599 | 1742599 | 2021-09-22 | Cass | Indiana | 18017 | 7182 | 119 |
1605864 | 1605864 | 2021-08-11 | Catoosa | Georgia | 13047 | 7182 | 77 |
1546986 | 1546986 | 2021-07-24 | Blount | Alabama | 1009 | 7182 | 139 |
1228791 | 1228791 | 2021-04-16 | Portage | Wisconsin | 55097 | 7182 | 70 |
1182989 | 1182989 | 2021-04-02 | Wise | Texas | 48497 | 7182 | 116 |
1152878 | 1152878 | 2021-03-24 | Stanly | North Carolina | 37167 | 7182 | 112 |
935335 | 935335 | 2021-01-16 | Caldwell | North Carolina | 37027 | 7182 | 31 |
867266 | 867266 | 2020-12-26 | Wayne | North Carolina | 37191 | 7182 | 145 |
841238 | 841238 | 2020-12-18 | Davidson | North Carolina | 37057 | 7182 | 67 |
836773 | 836773 | 2020-12-17 | Clark | Indiana | 18019 | 7182 | 107 |
818865 | 818865 | 2020-12-11 | Cumberland | Pennsylvania | 42041 | 7182 | 207 |
802791 | 802791 | 2020-12-06 | Florence | South Carolina | 45041 | 7182 | 222 |
696989 | 696989 | 2020-11-04 | Henry | Georgia | 13151 | 7182 | 122 |
691708 | 691708 | 2020-11-02 | Yellowstone | Montana | 30111 | 7182 | 96 |
588181 | 588181 | 2020-10-01 | Forsyth | North Carolina | 37067 | 7182 | 104 |
569189 | 569189 | 2020-09-25 | San Juan | Puerto Rico | 72127 | 7182 | |
556583 | 556583 | 2020-09-21 | Jefferson | Texas | 48245 | 7182 | 128 |
553346 | 553346 | 2020-09-20 | Jefferson | Texas | 48245 | 7182 | 128 |
492543 | 492543 | 2020-09-02 | Pulaski | Arkansas | 5119 | 7182 | 112 |
479764 | 479764 | 2020-08-29 | Brevard | Florida | 12009 | 7182 | 209 |
399549 | 399549 | 2020-08-04 | Lake | Indiana | 18089 | 7182 | 289 |
187596 | 187596 | 2020-05-28 | Milwaukee | Wisconsin | 55079 | 7182 | 285 |
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);