ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 6601 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Kentucky 7
- Minnesota 6
- Mississippi 6
- Texas 5
- Georgia 4
- Kansas 4
- North Carolina 4
- Indiana 3
- Louisiana 3
- Missouri 2
- New Mexico 2
- New York 2
- Alabama 1
- Arkansas 1
- Florida 1
- Montana 1
- New Jersey 1
- Ohio 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Virginia 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500580 | 2500580 | 2022-05-13 | Allen | Kentucky | 21003 | 6601 | 107 |
2497322 | 2497322 | 2022-05-12 | Allen | Kentucky | 21003 | 6601 | 107 |
2494064 | 2494064 | 2022-05-11 | Allen | Kentucky | 21003 | 6601 | 107 |
2494396 | 2494396 | 2022-05-11 | Brown | Minnesota | 27015 | 6601 | 81 |
2490806 | 2490806 | 2022-05-10 | Allen | Kentucky | 21003 | 6601 | 107 |
2487549 | 2487549 | 2022-05-09 | Allen | Kentucky | 21003 | 6601 | 107 |
2449105 | 2449105 | 2022-04-27 | Lake | Montana | 30047 | 6601 | 100 |
2362578 | 2362578 | 2022-03-31 | Louisa | Virginia | 51109 | 6601 | 80 |
2305775 | 2305775 | 2022-03-14 | Barry | Missouri | 29009 | 6601 | 125 |
2306097 | 2306097 | 2022-03-14 | Grant | New Mexico | 35017 | 6601 | 78 |
2244926 | 2244926 | 2022-02-23 | Edgefield | South Carolina | 45037 | 6601 | 65 |
2038793 | 2038793 | 2021-12-22 | Vernon | Louisiana | 22115 | 6601 | 167 |
2029350 | 2029350 | 2021-12-19 | Union | Mississippi | 28145 | 6601 | 99 |
2026099 | 2026099 | 2021-12-18 | Union | Mississippi | 28145 | 6601 | 99 |
2022848 | 2022848 | 2021-12-17 | Union | Mississippi | 28145 | 6601 | 99 |
2012522 | 2012522 | 2021-12-14 | Cowley | Kansas | 20035 | 6601 | 132 |
2009271 | 2009271 | 2021-12-13 | Cowley | Kansas | 20035 | 6601 | 132 |
1997359 | 1997359 | 2021-12-09 | Yadkin | North Carolina | 37197 | 6601 | 76 |
1942969 | 1942969 | 2021-11-22 | Wood | Texas | 48499 | 6601 | 230 |
1938201 | 1938201 | 2021-11-21 | Isanti | Minnesota | 27059 | 6601 | 81 |
1939719 | 1939719 | 2021-11-21 | Wood | Texas | 48499 | 6601 | 230 |
1934951 | 1934951 | 2021-11-20 | Isanti | Minnesota | 27059 | 6601 | 81 |
1936469 | 1936469 | 2021-11-20 | Wood | Texas | 48499 | 6601 | 230 |
1930499 | 1930499 | 2021-11-19 | Miller | Arkansas | 5091 | 6601 | 141 |
1931701 | 1931701 | 2021-11-19 | Isanti | Minnesota | 27059 | 6601 | 81 |
1922501 | 1922501 | 2021-11-16 | Alexander | North Carolina | 37003 | 6601 | 118 |
1807263 | 1807263 | 2021-10-12 | Baldwin | Georgia | 13009 | 6601 | 178 |
1779088 | 1779088 | 2021-10-03 | Monroe | Mississippi | 28095 | 6601 | 172 |
1775838 | 1775838 | 2021-10-02 | Monroe | Mississippi | 28095 | 6601 | 172 |
1772588 | 1772588 | 2021-10-01 | Monroe | Mississippi | 28095 | 6601 | 172 |
1718255 | 1718255 | 2021-09-14 | Guaynabo | Puerto Rico | 72061 | 6601 | |
1641936 | 1641936 | 2021-08-22 | Marshall | Indiana | 18099 | 6601 | 119 |
1638686 | 1638686 | 2021-08-21 | Marshall | Indiana | 18099 | 6601 | 119 |
1635436 | 1635436 | 2021-08-20 | Marshall | Indiana | 18099 | 6601 | 119 |
1610995 | 1610995 | 2021-08-12 | Indiana | Pennsylvania | 42063 | 6601 | 179 |
1539166 | 1539166 | 2021-07-21 | Columbus | North Carolina | 37047 | 6601 | 153 |
1467360 | 1467360 | 2021-06-29 | Joplin | Missouri | 6601 | 112 | |
1398757 | 1398757 | 2021-06-08 | Pulaski | Kentucky | 21199 | 6601 | 117 |
1350865 | 1350865 | 2021-05-24 | Sullivan | New York | 36105 | 6601 | 72 |
1347084 | 1347084 | 2021-05-23 | Kandiyohi | Minnesota | 27067 | 6601 | 84 |
1337102 | 1337102 | 2021-05-20 | Acadia | Louisiana | 22001 | 6601 | 194 |
1323370 | 1323370 | 2021-05-16 | Putnam | Florida | 12107 | 6601 | 153 |
1277434 | 1277434 | 2021-05-01 | Raleigh | West Virginia | 54081 | 6601 | 82 |
1133232 | 1133232 | 2021-03-18 | Eddy | New Mexico | 35015 | 6601 | 120 |
1095762 | 1095762 | 2021-03-07 | Walker | Alabama | 1127 | 6601 | 260 |
1038668 | 1038668 | 2021-02-17 | Rice | Minnesota | 27131 | 6601 | 87 |
1034978 | 1034978 | 2021-02-16 | Leavenworth | Kansas | 20103 | 6601 | 48 |
1031732 | 1031732 | 2021-02-15 | Leavenworth | Kansas | 20103 | 6601 | 48 |
1004666 | 1004666 | 2021-02-06 | Thurston | Washington | 53067 | 6601 | 69 |
995614 | 995614 | 2021-02-04 | Troup | Georgia | 13285 | 6601 | 173 |
960401 | 960401 | 2021-01-24 | Campbell | Kentucky | 21037 | 6601 | 40 |
928929 | 928929 | 2021-01-14 | Wilson | North Carolina | 37195 | 6601 | 122 |
898896 | 898896 | 2021-01-05 | Terrebonne | Louisiana | 22109 | 6601 | 154 |
873867 | 873867 | 2020-12-28 | Marion | Ohio | 39101 | 6601 | 102 |
831417 | 831417 | 2020-12-15 | Broome | New York | 36007 | 6601 | 178 |
826750 | 826750 | 2020-12-14 | Coweta | Georgia | 13077 | 6601 | 77 |
741536 | 741536 | 2020-11-17 | Taylor | Texas | 48441 | 6601 | 89 |
687290 | 687290 | 2020-11-01 | Muscogee | Georgia | 13215 | 6601 | 175 |
546766 | 546766 | 2020-09-18 | Brazos | Texas | 48041 | 6601 | 61 |
229425 | 229425 | 2020-06-11 | Morris | New Jersey | 34027 | 6601 | 631 |
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);