ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 9236 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Georgia 6
- North Carolina 6
- South Carolina 4
- Guam 3
- Kansas 3
- Missouri 3
- Tennessee 3
- Arkansas 2
- Illinois 2
- Michigan 2
- Minnesota 2
- Ohio 2
- Virginia 2
- California 1
- Florida 1
- Idaho 1
- Indiana 1
- Kentucky 1
- New Jersey 1
- New York 1
- North Dakota 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497655 | 2497655 | 2022-05-12 | Carlton | Minnesota | 27017 | 9236 | 97 |
2405316 | 2405316 | 2022-04-14 | Union | Arkansas | 5139 | 9236 | 175 |
2332276 | 2332276 | 2022-03-22 | Person | North Carolina | 37145 | 9236 | 104 |
2302977 | 2302977 | 2022-03-13 | Jackson | North Carolina | 37099 | 9236 | 86 |
2299725 | 2299725 | 2022-03-12 | Jackson | North Carolina | 37099 | 9236 | 86 |
2296473 | 2296473 | 2022-03-11 | Jackson | North Carolina | 37099 | 9236 | 86 |
2232851 | 2232851 | 2022-02-20 | Boone | Arkansas | 5009 | 9236 | 158 |
2217887 | 2217887 | 2022-02-15 | Unknown | Minnesota | 9236 | 160 | |
2124567 | 2124567 | 2022-01-17 | Chesterfield | South Carolina | 45025 | 9236 | 164 |
2121315 | 2121315 | 2022-01-16 | Chesterfield | South Carolina | 45025 | 9236 | 164 |
2118063 | 2118063 | 2022-01-15 | Chesterfield | South Carolina | 45025 | 9236 | 164 |
2114812 | 2114812 | 2022-01-14 | Chesterfield | South Carolina | 45025 | 9236 | 164 |
2012198 | 2012198 | 2021-12-14 | Madison | Idaho | 16065 | 9236 | 42 |
1995227 | 1995227 | 2021-12-08 | Marion | West Virginia | 54049 | 9236 | 134 |
1960077 | 1960077 | 2021-11-28 | Laurens | Georgia | 13175 | 9236 | 249 |
1956826 | 1956826 | 2021-11-27 | Laurens | Georgia | 13175 | 9236 | 249 |
1953575 | 1953575 | 2021-11-26 | Laurens | Georgia | 13175 | 9236 | 249 |
1950324 | 1950324 | 2021-11-25 | Laurens | Georgia | 13175 | 9236 | 249 |
1947073 | 1947073 | 2021-11-24 | Laurens | Georgia | 13175 | 9236 | 249 |
1943822 | 1943822 | 2021-11-23 | Laurens | Georgia | 13175 | 9236 | 247 |
1847413 | 1847413 | 2021-10-24 | Lincoln | Missouri | 29113 | 9236 | 68 |
1785423 | 1785423 | 2021-10-05 | Midland | Michigan | 26111 | 9236 | 120 |
1782174 | 1782174 | 2021-10-04 | Midland | Michigan | 26111 | 9236 | 120 |
1721023 | 1721023 | 2021-09-15 | Oswego | New York | 36075 | 9236 | 100 |
1598265 | 1598265 | 2021-08-08 | Hamblen | Tennessee | 47063 | 9236 | 176 |
1595016 | 1595016 | 2021-08-07 | Hamblen | Tennessee | 47063 | 9236 | 176 |
1591767 | 1591767 | 2021-08-06 | Hamblen | Tennessee | 47063 | 9236 | 176 |
1588079 | 1588079 | 2021-08-05 | Muskingum | Ohio | 39119 | 9236 | 137 |
1568063 | 1568063 | 2021-07-30 | St. Francois | Missouri | 29187 | 9236 | 118 |
1501297 | 1501297 | 2021-07-09 | Portsmouth city | Virginia | 51740 | 9236 | 205 |
1437156 | 1437156 | 2021-06-20 | Unknown | Guam | 9236 | 140 | |
1433909 | 1433909 | 2021-06-19 | Unknown | Guam | 9236 | 140 | |
1430663 | 1430663 | 2021-06-18 | Unknown | Guam | 9236 | 140 | |
1415405 | 1415405 | 2021-06-13 | Cole | Missouri | 29051 | 9236 | 129 |
1357376 | 1357376 | 2021-05-26 | Brunswick | North Carolina | 37019 | 9236 | 153 |
1301186 | 1301186 | 2021-05-09 | Douglas | Kansas | 20045 | 9236 | 87 |
1297939 | 1297939 | 2021-05-08 | Douglas | Kansas | 20045 | 9236 | 87 |
1294693 | 1294693 | 2021-05-07 | Douglas | Kansas | 20045 | 9236 | 87 |
1161680 | 1161680 | 2021-03-27 | Hardin | Kentucky | 21093 | 9236 | 137 |
1104247 | 1104247 | 2021-03-09 | Ward | North Dakota | 38101 | 9236 | 189 |
1081385 | 1081385 | 2021-03-02 | Burke | North Carolina | 37023 | 9236 | 138 |
969836 | 969836 | 2021-01-27 | Delaware | Indiana | 18035 | 9236 | 140 |
972042 | 972042 | 2021-01-27 | Alexandria city | Virginia | 51510 | 9236 | 102 |
964756 | 964756 | 2021-01-25 | Richland | Ohio | 39139 | 9236 | 118 |
803928 | 803928 | 2020-12-07 | Bay | Florida | 12005 | 9236 | 176 |
758854 | 758854 | 2020-11-23 | Sangamon | Illinois | 17167 | 9236 | 89 |
719431 | 719431 | 2020-11-11 | Kings | California | 6031 | 9236 | 87 |
675624 | 675624 | 2020-10-28 | Morris | New Jersey | 34027 | 9236 | 838 |
415593 | 415593 | 2020-08-09 | Will | Illinois | 17197 | 9236 | 344 |
261788 | 261788 | 2020-06-21 | King | Washington | 53033 | 9236 | 602 |
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);