ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where cases = 6027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 10
- Florida 9
- Missouri 7
- Washington 6
- North Carolina 4
- Virginia 4
- Arkansas 3
- Kentucky 3
- Maryland 3
- Pennsylvania 3
- Utah 3
- Georgia 2
- Kansas 2
- Mississippi 2
- New York 2
- Oregon 2
- Puerto Rico 2
- Texas 2
- Wisconsin 2
- Alabama 1
- Alaska 1
- California 1
- Colorado 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Michigan 1
- New Jersey 1
- Ohio 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2400201 | 2400201 | 2022-04-12 | Nodaway | Missouri | 29147 | 6027 | 44 |
2396946 | 2396946 | 2022-04-11 | Nodaway | Missouri | 29147 | 6027 | 44 |
2393691 | 2393691 | 2022-04-10 | Nodaway | Missouri | 29147 | 6027 | 44 |
2390435 | 2390435 | 2022-04-09 | Nodaway | Missouri | 29147 | 6027 | 44 |
2387179 | 2387179 | 2022-04-08 | Nodaway | Missouri | 29147 | 6027 | 44 |
2335909 | 2335909 | 2022-03-23 | Corozal | Puerto Rico | 72047 | 6027 | |
2318492 | 2318492 | 2022-03-18 | Caroline | Maryland | 24011 | 6027 | 80 |
2315239 | 2315239 | 2022-03-17 | Caroline | Maryland | 24011 | 6027 | 80 |
2316269 | 2316269 | 2022-03-17 | Crook | Oregon | 41013 | 6027 | 77 |
2284880 | 2284880 | 2022-03-08 | Carroll | Arkansas | 5015 | 6027 | 97 |
2280658 | 2280658 | 2022-03-06 | San Sebastian | Puerto Rico | 72131 | 6027 | |
2262578 | 2262578 | 2022-03-01 | Jefferson | Idaho | 16051 | 6027 | 62 |
2216982 | 2216982 | 2022-02-15 | Peach | Georgia | 13225 | 6027 | 119 |
2214716 | 2214716 | 2022-02-14 | Tishomingo | Mississippi | 28141 | 6027 | 117 |
2142751 | 2142751 | 2022-01-23 | Ohio | Kentucky | 21183 | 6027 | 91 |
2139496 | 2139496 | 2022-01-22 | Ohio | Kentucky | 21183 | 6027 | 91 |
2136240 | 2136240 | 2022-01-21 | Ohio | Kentucky | 21183 | 6027 | 91 |
2059844 | 2059844 | 2021-12-28 | Hill | Texas | 48217 | 6027 | 174 |
2041187 | 2041187 | 2021-12-23 | Baker | Florida | 12003 | 6027 | 122 |
2037937 | 2037937 | 2021-12-22 | Baker | Florida | 12003 | 6027 | 122 |
2034687 | 2034687 | 2021-12-21 | Baker | Florida | 12003 | 6027 | 122 |
2036687 | 2036687 | 2021-12-21 | Tioga | Pennsylvania | 42117 | 6027 | 166 |
2031437 | 2031437 | 2021-12-20 | Baker | Florida | 12003 | 6027 | 122 |
2028186 | 2028186 | 2021-12-19 | Baker | Florida | 12003 | 6027 | 122 |
2024935 | 2024935 | 2021-12-18 | Baker | Florida | 12003 | 6027 | 122 |
2021684 | 2021684 | 2021-12-17 | Baker | Florida | 12003 | 6027 | 122 |
1978133 | 1978133 | 2021-12-03 | Clarion | Pennsylvania | 42031 | 6027 | 148 |
1973810 | 1973810 | 2021-12-02 | Calvert | Maryland | 24009 | 6027 | 102 |
1965169 | 1965169 | 2021-11-29 | Pike | Pennsylvania | 42103 | 6027 | 69 |
1923956 | 1923956 | 2021-11-17 | Baxter | Arkansas | 5005 | 6027 | 186 |
1894429 | 1894429 | 2021-11-07 | Mason | Washington | 53045 | 6027 | 73 |
1891179 | 1891179 | 2021-11-06 | Mason | Washington | 53045 | 6027 | 73 |
1886428 | 1886428 | 2021-11-05 | Platte | Missouri | 29165 | 6027 | 61 |
1887929 | 1887929 | 2021-11-05 | Mason | Washington | 53045 | 6027 | 73 |
1878418 | 1878418 | 2021-11-03 | Bethel Census Area | Alaska | 2050 | 6027 | 27 |
1875377 | 1875377 | 2021-11-02 | La Plata | Colorado | 8067 | 6027 | 55 |
1851663 | 1851663 | 2021-10-25 | Giles | Tennessee | 47055 | 6027 | 117 |
1848413 | 1848413 | 2021-10-24 | Giles | Tennessee | 47055 | 6027 | 117 |
1845163 | 1845163 | 2021-10-23 | Giles | Tennessee | 47055 | 6027 | 117 |
1841913 | 1841913 | 2021-10-22 | Giles | Tennessee | 47055 | 6027 | 117 |
1838664 | 1838664 | 2021-10-21 | Giles | Tennessee | 47055 | 6027 | 117 |
1787110 | 1787110 | 2021-10-05 | Henry | Virginia | 51089 | 6027 | 143 |
1783496 | 1783496 | 2021-10-04 | Weakley | Tennessee | 47183 | 6027 | 81 |
1698329 | 1698329 | 2021-09-08 | Chatham | North Carolina | 37037 | 6027 | 91 |
1670623 | 1670623 | 2021-08-31 | Mendocino | California | 6045 | 6027 | 64 |
1650331 | 1650331 | 2021-08-24 | Burnet | Texas | 48053 | 6027 | 80 |
1598585 | 1598585 | 2021-08-08 | Box Elder | Utah | 49003 | 6027 | 59 |
1598633 | 1598633 | 2021-08-08 | Albemarle | Virginia | 51003 | 6027 | 85 |
1595336 | 1595336 | 2021-08-07 | Box Elder | Utah | 49003 | 6027 | 59 |
1595384 | 1595384 | 2021-08-07 | Albemarle | Virginia | 51003 | 6027 | 85 |
1592087 | 1592087 | 2021-08-06 | Box Elder | Utah | 49003 | 6027 | 59 |
1592135 | 1592135 | 2021-08-06 | Albemarle | Virginia | 51003 | 6027 | 85 |
1532686 | 1532686 | 2021-07-19 | Granville | North Carolina | 37077 | 6027 | 83 |
1378051 | 1378051 | 2021-06-01 | Harrison | West Virginia | 54033 | 6027 | 77 |
1378092 | 1378092 | 2021-06-01 | Barron | Wisconsin | 55005 | 6027 | 83 |
1374268 | 1374268 | 2021-05-31 | Lawrence | Tennessee | 47099 | 6027 | 92 |
1371023 | 1371023 | 2021-05-30 | Lawrence | Tennessee | 47099 | 6027 | 92 |
1367777 | 1367777 | 2021-05-29 | Lawrence | Tennessee | 47099 | 6027 | 92 |
1364531 | 1364531 | 2021-05-28 | Lawrence | Tennessee | 47099 | 6027 | 92 |
1347592 | 1347592 | 2021-05-23 | Jefferson | New York | 36045 | 6027 | 68 |
1348790 | 1348790 | 2021-05-23 | Cowlitz | Washington | 53015 | 6027 | 91 |
1345542 | 1345542 | 2021-05-22 | Cowlitz | Washington | 53015 | 6027 | 91 |
1342294 | 1342294 | 2021-05-21 | Cowlitz | Washington | 53015 | 6027 | 91 |
1295053 | 1295053 | 2021-05-07 | Isabella | Michigan | 26073 | 6027 | 88 |
1216768 | 1216768 | 2021-04-13 | Finney | Kansas | 20055 | 6027 | 49 |
1213521 | 1213521 | 2021-04-12 | Finney | Kansas | 20055 | 6027 | 49 |
1210801 | 1210801 | 2021-04-11 | Lafayette | Mississippi | 28071 | 6027 | 117 |
1193246 | 1193246 | 2021-04-06 | Greene | Arkansas | 5055 | 6027 | 75 |
1170752 | 1170752 | 2021-03-30 | Putnam | Florida | 12107 | 6027 | 135 |
1171098 | 1171098 | 2021-03-30 | Dubois | Indiana | 18037 | 6027 | 116 |
1144749 | 1144749 | 2021-03-22 | Jackson | Florida | 12063 | 6027 | 154 |
1138507 | 1138507 | 2021-03-20 | Boone | Illinois | 17007 | 6027 | 83 |
1111947 | 1111947 | 2021-03-12 | Colbert | Alabama | 1033 | 6027 | 125 |
1110747 | 1110747 | 2021-03-11 | Ashtabula | Ohio | 39007 | 6027 | 156 |
1094687 | 1094687 | 2021-03-06 | Deschutes | Oregon | 41017 | 6027 | 65 |
1082628 | 1082628 | 2021-03-02 | Calumet | Wisconsin | 55015 | 6027 | 47 |
915756 | 915756 | 2021-01-10 | Sussex | New Jersey | 34037 | 6027 | 228 |
907854 | 907854 | 2021-01-08 | Barrow | Georgia | 13013 | 6027 | 72 |
799026 | 799026 | 2020-12-05 | Buncombe | North Carolina | 37021 | 6027 | 143 |
758990 | 758990 | 2020-11-23 | Dallas | Iowa | 19049 | 6027 | 56 |
685542 | 685542 | 2020-10-31 | Union | North Carolina | 37179 | 6027 | 65 |
575153 | 575153 | 2020-09-27 | Monroe | New York | 36055 | 6027 | 259 |
397131 | 397131 | 2020-08-03 | Kansas City | Missouri | 6027 | 69 |
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);