ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 9838 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Kentucky 3
- West Virginia 3
- Florida 2
- Indiana 2
- Mississippi 2
- Missouri 2
- Ohio 2
- Wisconsin 2
- Arkansas 1
- Connecticut 1
- Hawaii 1
- Illinois 1
- Louisiana 1
- Massachusetts 1
- Nevada 1
- North Carolina 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Texas 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467668 | 2467668 | 2022-05-03 | Montgomery | Illinois | 17135 | 9838 | 111 |
2463643 | 2463643 | 2022-05-01 | Wayne | West Virginia | 54099 | 9838 | 123 |
2460387 | 2460387 | 2022-04-30 | Wayne | West Virginia | 54099 | 9838 | 123 |
2457131 | 2457131 | 2022-04-29 | Wayne | West Virginia | 54099 | 9838 | 123 |
2391268 | 2391268 | 2022-04-09 | Trujillo Alto | Puerto Rico | 72139 | 9838 | |
2240655 | 2240655 | 2022-02-22 | Alcorn | Mississippi | 28003 | 9838 | 144 |
2224163 | 2224163 | 2022-02-17 | Vernon | Louisiana | 22115 | 9838 | 181 |
2178916 | 2178916 | 2022-02-03 | Panola | Mississippi | 28107 | 9838 | 146 |
2101443 | 2101443 | 2022-01-10 | Athens | Ohio | 39009 | 9838 | 104 |
2078383 | 2078383 | 2022-01-03 | Elko | Nevada | 32007 | 9838 | 124 |
2040778 | 2040778 | 2021-12-22 | Columbia | Wisconsin | 55021 | 9838 | 100 |
2035117 | 2035117 | 2021-12-21 | Marshall | Indiana | 18099 | 9838 | 161 |
2014683 | 2014683 | 2021-12-14 | Grays Harbor | Washington | 53027 | 9838 | 149 |
1860947 | 1860947 | 2021-10-28 | Hancock | Ohio | 39063 | 9838 | 156 |
1849663 | 1849663 | 2021-10-25 | Maui | Hawaii | 15009 | 9838 | 94 |
1469023 | 1469023 | 2021-06-29 | St. Croix | Wisconsin | 55109 | 9838 | 69 |
1372740 | 1372740 | 2021-05-31 | Hardin | Kentucky | 21093 | 9838 | 160 |
1369495 | 1369495 | 2021-05-30 | Hardin | Kentucky | 21093 | 9838 | 160 |
1366249 | 1366249 | 2021-05-29 | Hardin | Kentucky | 21093 | 9838 | 160 |
1341681 | 1341681 | 2021-05-21 | Orangeburg | South Carolina | 45075 | 9838 | 251 |
1167445 | 1167445 | 2021-03-29 | Windham | Connecticut | 9015 | 9838 | 187 |
1149164 | 1149164 | 2021-03-23 | Clay | Missouri | 29047 | 9838 | 158 |
1145917 | 1145917 | 2021-03-22 | Clay | Missouri | 29047 | 9838 | 155 |
1100967 | 1100967 | 2021-03-08 | Grand Forks | North Dakota | 38035 | 9838 | 76 |
1067208 | 1067208 | 2021-02-26 | Delaware | Indiana | 18035 | 9838 | 185 |
1054734 | 1054734 | 2021-02-22 | Barnstable | Massachusetts | 25001 | 9838 | 391 |
1001939 | 1001939 | 2021-02-06 | Martin | Florida | 12085 | 9838 | 258 |
997371 | 997371 | 2021-02-04 | Fayette | Pennsylvania | 42051 | 9838 | 238 |
991304 | 991304 | 2021-02-02 | Grayson | Texas | 48181 | 9838 | 264 |
988354 | 988354 | 2021-02-01 | Newport News city | Virginia | 51700 | 9838 | 97 |
893182 | 893182 | 2021-01-03 | Iredell | North Carolina | 37097 | 9838 | 102 |
732584 | 732584 | 2020-11-15 | St. Lucie | Florida | 12111 | 9838 | 350 |
719343 | 719343 | 2020-11-11 | Benton | Arkansas | 5007 | 9838 | 133 |
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);