ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where cases = 3311 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 18
- Florida 8
- Iowa 8
- Kentucky 8
- Mississippi 8
- Texas 8
- Georgia 7
- Alabama 6
- Arkansas 6
- California 5
- Kansas 5
- Minnesota 5
- Idaho 4
- Missouri 4
- New York 4
- Ohio 4
- Tennessee 4
- Illinois 3
- Oregon 3
- Pennsylvania 3
- Puerto Rico 3
- Washington 3
- West Virginia 3
- Arizona 2
- Indiana 2
- Michigan 2
- New Mexico 2
- North Carolina 2
- South Carolina 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485679 | 2485679 | 2022-05-08 | Orocovis | Puerto Rico | 72107 | 3311 | |
2482421 | 2482421 | 2022-05-07 | Orocovis | Puerto Rico | 72107 | 3311 | |
2463962 | 2463962 | 2022-05-02 | Plumas | California | 6063 | 3311 | 13 |
2460706 | 2460706 | 2022-05-01 | Plumas | California | 6063 | 3311 | 13 |
2457450 | 2457450 | 2022-04-30 | Plumas | California | 6063 | 3311 | 13 |
2454194 | 2454194 | 2022-04-29 | Plumas | California | 6063 | 3311 | 13 |
2424580 | 2424580 | 2022-04-19 | Bayfield | Wisconsin | 55007 | 3311 | 40 |
2395082 | 2395082 | 2022-04-10 | Dickenson | Virginia | 51051 | 3311 | 47 |
2391826 | 2391826 | 2022-04-09 | Dickenson | Virginia | 51051 | 3311 | 47 |
2388570 | 2388570 | 2022-04-08 | Dickenson | Virginia | 51051 | 3311 | 47 |
2385315 | 2385315 | 2022-04-07 | Dickenson | Virginia | 51051 | 3311 | 47 |
2382060 | 2382060 | 2022-04-06 | Dickenson | Virginia | 51051 | 3311 | 47 |
2378805 | 2378805 | 2022-04-05 | Dickenson | Virginia | 51051 | 3311 | 47 |
2362560 | 2362560 | 2022-03-31 | Greensville | Virginia | 51081 | 3311 | 37 |
2354883 | 2354883 | 2022-03-29 | Unknown | New Jersey | 3311 | 0 | |
2333280 | 2333280 | 2022-03-22 | Greensville | Virginia | 51081 | 3311 | 37 |
2330027 | 2330027 | 2022-03-21 | Greensville | Virginia | 51081 | 3311 | 37 |
2303260 | 2303260 | 2022-03-13 | Curry | Oregon | 41015 | 3311 | 45 |
2303984 | 2303984 | 2022-03-13 | Dickenson | Virginia | 51051 | 3311 | 45 |
2300008 | 2300008 | 2022-03-12 | Curry | Oregon | 41015 | 3311 | 45 |
2300732 | 2300732 | 2022-03-12 | Dickenson | Virginia | 51051 | 3311 | 45 |
2296756 | 2296756 | 2022-03-11 | Curry | Oregon | 41015 | 3311 | 45 |
2297480 | 2297480 | 2022-03-11 | Dickenson | Virginia | 51051 | 3311 | 45 |
2287454 | 2287454 | 2022-03-08 | Duval | Texas | 48131 | 3311 | 68 |
2283076 | 2283076 | 2022-03-07 | Mississippi | Missouri | 29133 | 3311 | 56 |
2279210 | 2279210 | 2022-03-06 | Marion | Kansas | 20115 | 3311 | 39 |
2275957 | 2275957 | 2022-03-05 | Marion | Kansas | 20115 | 3311 | 39 |
2272704 | 2272704 | 2022-03-04 | Marion | Kansas | 20115 | 3311 | 39 |
2269452 | 2269452 | 2022-03-03 | Marion | Kansas | 20115 | 3311 | 39 |
2266199 | 2266199 | 2022-03-02 | Marion | Kansas | 20115 | 3311 | 39 |
2246768 | 2246768 | 2022-02-24 | Clinton | Kentucky | 21053 | 3311 | 42 |
2243517 | 2243517 | 2022-02-23 | Clinton | Kentucky | 21053 | 3311 | 42 |
2208617 | 2208617 | 2022-02-12 | Schuyler | New York | 36097 | 3311 | 23 |
2194808 | 2194808 | 2022-02-08 | Pendleton | Kentucky | 21191 | 3311 | 33 |
2191479 | 2191479 | 2022-02-07 | Carroll | Kentucky | 21041 | 3311 | 40 |
2190059 | 2190059 | 2022-02-06 | Tyler | Texas | 48457 | 3311 | 76 |
2175427 | 2175427 | 2022-02-02 | Dukes | Massachusetts | 25007 | 3311 | 0 |
2175684 | 2175684 | 2022-02-02 | Walthall | Mississippi | 28147 | 3311 | 72 |
2160797 | 2160797 | 2022-01-28 | Wilbarger | Texas | 48487 | 3311 | 79 |
2145697 | 2145697 | 2022-01-24 | Tipton | Indiana | 18159 | 3311 | 79 |
2126270 | 2126270 | 2022-01-18 | Tama | Iowa | 19171 | 3311 | 81 |
2123018 | 2123018 | 2022-01-17 | Tama | Iowa | 19171 | 3311 | 81 |
2119766 | 2119766 | 2022-01-16 | Tama | Iowa | 19171 | 3311 | 81 |
2116514 | 2116514 | 2022-01-15 | Tama | Iowa | 19171 | 3311 | 81 |
2113263 | 2113263 | 2022-01-14 | Tama | Iowa | 19171 | 3311 | 81 |
2110011 | 2110011 | 2022-01-13 | Tama | Iowa | 19171 | 3311 | 81 |
2106760 | 2106760 | 2022-01-12 | Tama | Iowa | 19171 | 3311 | 81 |
2072424 | 2072424 | 2022-01-01 | Montour | Pennsylvania | 42093 | 3311 | 81 |
2057120 | 2057120 | 2021-12-28 | Cherokee | Alabama | 1019 | 3311 | 65 |
2034527 | 2034527 | 2021-12-21 | Phillips | Arkansas | 5107 | 3311 | 79 |
2014208 | 2014208 | 2021-12-14 | Polk | Tennessee | 47139 | 3311 | 35 |
2008233 | 2008233 | 2021-12-12 | McDowell | West Virginia | 54047 | 3311 | 56 |
1992610 | 1992610 | 2021-12-08 | Putnam | Georgia | 13237 | 3311 | 88 |
1988977 | 1988977 | 2021-12-07 | Conway | Arkansas | 5029 | 3311 | 46 |
1974494 | 1974494 | 2021-12-02 | Seneca | New York | 36099 | 3311 | 68 |
1969647 | 1969647 | 2021-12-01 | Pitkin | Colorado | 8097 | 3311 | 6 |
1924951 | 1924951 | 2021-11-17 | Simpson | Kentucky | 21213 | 3311 | 61 |
1858909 | 1858909 | 2021-10-28 | Randolph | Alabama | 1111 | 3311 | 64 |
1856227 | 1856227 | 2021-10-27 | Douglas | Illinois | 17041 | 3311 | 43 |
1836279 | 1836279 | 2021-10-21 | Randolph | Arkansas | 5121 | 3311 | 55 |
1816410 | 1816410 | 2021-10-14 | Staunton city | Virginia | 51790 | 3311 | 81 |
1806163 | 1806163 | 2021-10-11 | Crockett | Tennessee | 47033 | 3311 | 61 |
1797164 | 1797164 | 2021-10-09 | Marengo | Alabama | 1091 | 3311 | 89 |
1789231 | 1789231 | 2021-10-06 | Delaware | New York | 36025 | 3311 | 42 |
1784248 | 1784248 | 2021-10-05 | Columbia | Arkansas | 5027 | 3311 | 66 |
1784615 | 1784615 | 2021-10-05 | Mitchell | Georgia | 13205 | 3311 | 97 |
1784028 | 1784028 | 2021-10-04 | Wyoming | West Virginia | 54109 | 3311 | 51 |
1760843 | 1760843 | 2021-09-27 | Gray | Texas | 48179 | 3311 | 66 |
1757595 | 1757595 | 2021-09-26 | Gray | Texas | 48179 | 3311 | 66 |
1754347 | 1754347 | 2021-09-25 | Gray | Texas | 48179 | 3311 | 66 |
1735550 | 1735550 | 2021-09-20 | Ouachita | Arkansas | 5103 | 3311 | 74 |
1735983 | 1735983 | 2021-09-20 | Payette | Idaho | 16075 | 3311 | 45 |
1723392 | 1723392 | 2021-09-16 | Allen | Kentucky | 21003 | 3311 | 58 |
1719540 | 1719540 | 2021-09-15 | Berrien | Georgia | 13019 | 3311 | 54 |
1701021 | 1701021 | 2021-09-09 | Le Sueur | Minnesota | 27079 | 3311 | 29 |
1691129 | 1691129 | 2021-09-06 | Queen Anne's | Maryland | 24035 | 3311 | 58 |
1671506 | 1671506 | 2021-08-31 | Ohio | Kentucky | 21183 | 3311 | 59 |
1645094 | 1645094 | 2021-08-23 | McDonough | Illinois | 17109 | 3311 | 64 |
1626392 | 1626392 | 2021-08-17 | Leake | Mississippi | 28079 | 3311 | 77 |
1627644 | 1627644 | 2021-08-17 | Frio | Texas | 48163 | 3311 | 57 |
1605883 | 1605883 | 2021-08-11 | Dawson | Georgia | 13085 | 3311 | 49 |
1606894 | 1606894 | 2021-08-11 | Itawamba | Mississippi | 28057 | 3311 | 82 |
1603766 | 1603766 | 2021-08-10 | Miller | Missouri | 29131 | 3311 | 64 |
1599387 | 1599387 | 2021-08-09 | Decatur | Georgia | 13087 | 3311 | 77 |
1596290 | 1596290 | 2021-08-08 | Latah | Idaho | 16057 | 3311 | 13 |
1593041 | 1593041 | 2021-08-07 | Latah | Idaho | 16057 | 3311 | 13 |
1589792 | 1589792 | 2021-08-06 | Latah | Idaho | 16057 | 3311 | 13 |
1585698 | 1585698 | 2021-08-04 | Isle of Wight | Virginia | 51093 | 3311 | 70 |
1556872 | 1556872 | 2021-07-27 | Lincoln | Arkansas | 5079 | 3311 | 49 |
1558375 | 1558375 | 2021-07-27 | Ravalli | Montana | 30081 | 3311 | 51 |
1551723 | 1551723 | 2021-07-25 | Yazoo | Mississippi | 28163 | 3311 | 73 |
1553284 | 1553284 | 2021-07-25 | Wise | Virginia | 51195 | 3311 | 105 |
1548476 | 1548476 | 2021-07-24 | Yazoo | Mississippi | 28163 | 3311 | 73 |
1550037 | 1550037 | 2021-07-24 | Wise | Virginia | 51195 | 3311 | 105 |
1545229 | 1545229 | 2021-07-23 | Yazoo | Mississippi | 28163 | 3311 | 73 |
1546790 | 1546790 | 2021-07-23 | Wise | Virginia | 51195 | 3311 | 105 |
1537048 | 1537048 | 2021-07-20 | Wise | Virginia | 51195 | 3311 | 105 |
1531891 | 1531891 | 2021-07-19 | Jefferson Davis | Louisiana | 22053 | 3311 | 99 |
1511308 | 1511308 | 2021-07-13 | Marion | Alabama | 1093 | 3311 | 106 |
1508061 | 1508061 | 2021-07-12 | Marion | Alabama | 1093 | 3311 | 106 |
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);