ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 6139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Oklahoma 7
- Kansas 5
- Illinois 4
- Kentucky 3
- Ohio 3
- Puerto Rico 3
- Wisconsin 3
- Florida 2
- Georgia 2
- Idaho 2
- Indiana 2
- Mississippi 2
- Missouri 2
- New Jersey 2
- Pennsylvania 2
- Tennessee 2
- Alabama 1
- Arkansas 1
- Iowa 1
- Louisiana 1
- Minnesota 1
- New York 1
- North Carolina 1
- South Carolina 1
- South Dakota 1
- Texas 1
- Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501181 | 2501181 | 2022-05-13 | Stoddard | Missouri | 29207 | 6139 | 130 |
2358659 | 2358659 | 2022-03-30 | Aguada | Puerto Rico | 72003 | 6139 | |
2353975 | 2353975 | 2022-03-29 | Cherokee | Kansas | 20021 | 6139 | 85 |
2350723 | 2350723 | 2022-03-28 | Cherokee | Kansas | 20021 | 6139 | 85 |
2324698 | 2324698 | 2022-03-20 | Cherokee | Kansas | 20021 | 6139 | 84 |
2321444 | 2321444 | 2022-03-19 | Cherokee | Kansas | 20021 | 6139 | 84 |
2318190 | 2318190 | 2022-03-18 | Cherokee | Kansas | 20021 | 6139 | 84 |
2259362 | 2259362 | 2022-02-28 | Crawford | Illinois | 17033 | 6139 | 58 |
2259748 | 2259748 | 2022-02-28 | Anderson | Kentucky | 21005 | 6139 | 62 |
2223626 | 2223626 | 2022-02-17 | Jersey | Illinois | 17083 | 6139 | 85 |
2193516 | 2193516 | 2022-02-07 | Winchester city | Virginia | 51840 | 6139 | 69 |
2165020 | 2165020 | 2022-01-30 | Latah | Idaho | 16057 | 6139 | 43 |
2161765 | 2161765 | 2022-01-29 | Latah | Idaho | 16057 | 6139 | 43 |
2144359 | 2144359 | 2022-01-23 | Fannin | Texas | 48147 | 6139 | 159 |
2134404 | 2134404 | 2022-01-20 | Meade | South Dakota | 46093 | 6139 | 56 |
2094456 | 2094456 | 2022-01-08 | Polk | Missouri | 29167 | 6139 | 83 |
2089613 | 2089613 | 2022-01-06 | Sheridan | Wyoming | 56033 | 6139 | 63 |
2035780 | 2035780 | 2021-12-21 | Alcorn | Mississippi | 28003 | 6139 | 110 |
2015908 | 2015908 | 2021-12-15 | Harlan | Kentucky | 21095 | 6139 | 148 |
1944061 | 1944061 | 2021-11-23 | Clinton | Indiana | 18023 | 6139 | 81 |
1883085 | 1883085 | 2021-11-04 | Union | Mississippi | 28145 | 6139 | 94 |
1854757 | 1854757 | 2021-10-26 | Toa Baja | Puerto Rico | 72137 | 6139 | |
1851508 | 1851508 | 2021-10-25 | Toa Baja | Puerto Rico | 72137 | 6139 | |
1700049 | 1700049 | 2021-09-09 | Baldwin | Georgia | 13009 | 6139 | 155 |
1653027 | 1653027 | 2021-08-25 | Huron | Ohio | 39077 | 6139 | 123 |
1645596 | 1645596 | 2021-08-23 | St. Bernard | Louisiana | 22087 | 6139 | 71 |
1609205 | 1609205 | 2021-08-12 | Polk | Georgia | 13233 | 6139 | 100 |
1520026 | 1520026 | 2021-07-15 | Bradford | Pennsylvania | 42015 | 6139 | 96 |
1516778 | 1516778 | 2021-07-14 | Bradford | Pennsylvania | 42015 | 6139 | 96 |
1445052 | 1445052 | 2021-06-22 | Lee | North Carolina | 37105 | 6139 | 83 |
1445251 | 1445251 | 2021-06-22 | Bryan | Oklahoma | 40013 | 6139 | 79 |
1442006 | 1442006 | 2021-06-21 | Bryan | Oklahoma | 40013 | 6139 | 79 |
1438761 | 1438761 | 2021-06-20 | Bryan | Oklahoma | 40013 | 6139 | 79 |
1435514 | 1435514 | 2021-06-19 | Bryan | Oklahoma | 40013 | 6139 | 79 |
1432267 | 1432267 | 2021-06-18 | Bryan | Oklahoma | 40013 | 6139 | 79 |
1429021 | 1429021 | 2021-06-17 | Bryan | Oklahoma | 40013 | 6139 | 79 |
1425488 | 1425488 | 2021-06-16 | Jefferson | New York | 36045 | 6139 | 68 |
1425776 | 1425776 | 2021-06-16 | Bryan | Oklahoma | 40013 | 6139 | 79 |
1367626 | 1367626 | 2021-05-29 | Cherokee | South Carolina | 45021 | 6139 | 156 |
1343147 | 1343147 | 2021-05-22 | Ogle | Illinois | 17141 | 6139 | 91 |
1326201 | 1326201 | 2021-05-16 | Sauk | Wisconsin | 55111 | 6139 | 54 |
1322955 | 1322955 | 2021-05-15 | Sauk | Wisconsin | 55111 | 6139 | 54 |
1267127 | 1267127 | 2021-04-28 | Jefferson | Tennessee | 47089 | 6139 | 124 |
1197457 | 1197457 | 2021-04-07 | Pulaski | Kentucky | 21199 | 6139 | 94 |
1183968 | 1183968 | 2021-04-03 | Boone | Illinois | 17007 | 6139 | 83 |
1125282 | 1125282 | 2021-03-16 | Monroe | Florida | 12087 | 6139 | 47 |
1104279 | 1104279 | 2021-03-09 | Geauga | Ohio | 39055 | 6139 | 142 |
1089915 | 1089915 | 2021-03-05 | Boone | Indiana | 18011 | 6139 | 96 |
1036583 | 1036583 | 2021-02-16 | Gibson | Tennessee | 47053 | 6139 | 138 |
951038 | 951038 | 2021-01-21 | Rice | Minnesota | 27131 | 6139 | 69 |
823247 | 823247 | 2020-12-13 | Saline | Arkansas | 5125 | 6139 | 76 |
821625 | 821625 | 2020-12-12 | Cumberland | New Jersey | 34011 | 6139 | 192 |
789465 | 789465 | 2020-12-02 | Greene | Ohio | 39057 | 6139 | 75 |
696483 | 696483 | 2020-11-03 | Rock | Wisconsin | 55105 | 6139 | 48 |
680639 | 680639 | 2020-10-30 | Clay | Florida | 12019 | 6139 | 127 |
385990 | 385990 | 2020-07-31 | Montgomery | Alabama | 1101 | 6139 | 144 |
291087 | 291087 | 2020-07-01 | Polk | Iowa | 19153 | 6139 | 178 |
161942 | 161942 | 2020-05-20 | Morris | New Jersey | 34027 | 6139 | 581 |
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);