ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
188 rows where cases = 2749 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 20
- Tennessee 19
- Texas 14
- Indiana 11
- Kansas 10
- Iowa 9
- Missouri 9
- Ohio 9
- Georgia 8
- Kentucky 8
- Virginia 7
- Arkansas 6
- Puerto Rico 6
- Michigan 5
- New Mexico 5
- Illinois 4
- Louisiana 4
- Minnesota 4
- Mississippi 4
- Wisconsin 4
- South Carolina 3
- Idaho 2
- Oklahoma 2
- Pennsylvania 2
- South Dakota 2
- Vermont 2
- West Virginia 2
- Alabama 1
- Arizona 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502158 | 2502158 | 2022-05-13 | Lake | Tennessee | 47095 | 2749 | 43 |
2502392 | 2502392 | 2022-05-13 | Pecos | Texas | 48371 | 2749 | 71 |
2498900 | 2498900 | 2022-05-12 | Lake | Tennessee | 47095 | 2749 | 43 |
2499134 | 2499134 | 2022-05-12 | Pecos | Texas | 48371 | 2749 | 71 |
2495642 | 2495642 | 2022-05-11 | Lake | Tennessee | 47095 | 2749 | 43 |
2492384 | 2492384 | 2022-05-10 | Lake | Tennessee | 47095 | 2749 | 43 |
2489126 | 2489126 | 2022-05-09 | Lake | Tennessee | 47095 | 2749 | 43 |
2485869 | 2485869 | 2022-05-08 | Lake | Tennessee | 47095 | 2749 | 43 |
2482611 | 2482611 | 2022-05-07 | Lake | Tennessee | 47095 | 2749 | 43 |
2479170 | 2479170 | 2022-05-06 | Sabana Grande | Puerto Rico | 72121 | 2749 | |
2479353 | 2479353 | 2022-05-06 | Lake | Tennessee | 47095 | 2749 | 43 |
2476095 | 2476095 | 2022-05-05 | Lake | Tennessee | 47095 | 2749 | 43 |
2472838 | 2472838 | 2022-05-04 | Lake | Tennessee | 47095 | 2749 | 43 |
2311437 | 2311437 | 2022-03-16 | Marshall | Illinois | 17123 | 2749 | 33 |
2284881 | 2284881 | 2022-03-08 | Chicot | Arkansas | 5017 | 2749 | 56 |
2268392 | 2268392 | 2022-03-02 | Summers | West Virginia | 54089 | 2749 | 48 |
2196100 | 2196100 | 2022-02-08 | Orocovis | Puerto Rico | 72107 | 2749 | |
2192846 | 2192846 | 2022-02-07 | Orocovis | Puerto Rico | 72107 | 2749 | |
2151566 | 2151566 | 2022-01-26 | Lee | Arkansas | 5077 | 2749 | 54 |
2150575 | 2150575 | 2022-01-25 | Villalba | Puerto Rico | 72149 | 2749 | |
2144821 | 2144821 | 2022-01-23 | Bayfield | Wisconsin | 55007 | 2749 | 35 |
2141566 | 2141566 | 2022-01-22 | Bayfield | Wisconsin | 55007 | 2749 | 35 |
2138310 | 2138310 | 2022-01-21 | Bayfield | Wisconsin | 55007 | 2749 | 35 |
2126350 | 2126350 | 2022-01-18 | Nemaha | Kansas | 20131 | 2749 | 60 |
2126954 | 2126954 | 2022-01-18 | Mississippi | Missouri | 29133 | 2749 | 51 |
2123098 | 2123098 | 2022-01-17 | Nemaha | Kansas | 20131 | 2749 | 60 |
2119846 | 2119846 | 2022-01-16 | Nemaha | Kansas | 20131 | 2749 | 60 |
2116594 | 2116594 | 2022-01-15 | Nemaha | Kansas | 20131 | 2749 | 60 |
2113343 | 2113343 | 2022-01-14 | Nemaha | Kansas | 20131 | 2749 | 60 |
2110165 | 2110165 | 2022-01-13 | Fleming | Kentucky | 21069 | 2749 | 44 |
2103466 | 2103466 | 2022-01-11 | Harrison | Iowa | 19085 | 2749 | 84 |
2103915 | 2103915 | 2022-01-11 | Leelanau | Michigan | 26089 | 2749 | 42 |
2104470 | 2104470 | 2022-01-11 | Socorro | New Mexico | 35053 | 2749 | 71 |
2100215 | 2100215 | 2022-01-10 | Harrison | Iowa | 19085 | 2749 | 84 |
2100664 | 2100664 | 2022-01-10 | Leelanau | Michigan | 26089 | 2749 | 42 |
2096964 | 2096964 | 2022-01-09 | Harrison | Iowa | 19085 | 2749 | 84 |
2093712 | 2093712 | 2022-01-08 | Harrison | Iowa | 19085 | 2749 | 84 |
2090460 | 2090460 | 2022-01-07 | Harrison | Iowa | 19085 | 2749 | 84 |
2092264 | 2092264 | 2022-01-07 | Bosque | Texas | 48035 | 2749 | 59 |
2087209 | 2087209 | 2022-01-06 | Harrison | Iowa | 19085 | 2749 | 84 |
2087488 | 2087488 | 2022-01-06 | Webster | Kentucky | 21233 | 2749 | 46 |
2088402 | 2088402 | 2022-01-06 | McKenzie | North Dakota | 38053 | 2749 | 23 |
2083957 | 2083957 | 2022-01-05 | Harrison | Iowa | 19085 | 2749 | 84 |
2077632 | 2077632 | 2022-01-03 | Caldwell | Kentucky | 21033 | 2749 | 54 |
2032859 | 2032859 | 2021-12-20 | Saline | Nebraska | 31151 | 2749 | 6 |
1943801 | 1943801 | 2021-11-23 | Greene | Georgia | 13133 | 2749 | 73 |
1946289 | 1946289 | 2021-11-23 | Buchanan | Virginia | 51027 | 2749 | 74 |
1917968 | 1917968 | 2021-11-15 | Edgar | Illinois | 17045 | 2749 | 70 |
1884696 | 1884696 | 2021-11-04 | Barbour | West Virginia | 54001 | 2749 | 45 |
1877213 | 1877213 | 2021-11-02 | Meigs | Ohio | 39105 | 2749 | 55 |
1861772 | 1861772 | 2021-10-28 | Orleans | Vermont | 50019 | 2749 | 13 |
1840856 | 1840856 | 2021-10-22 | Andrew | Missouri | 29003 | 2749 | 24 |
1827507 | 1827507 | 2021-10-18 | Jackson | Louisiana | 22049 | 2749 | 63 |
1807785 | 1807785 | 2021-10-12 | Dickinson | Kansas | 20041 | 2749 | 60 |
1804534 | 1804534 | 2021-10-11 | Dickinson | Kansas | 20041 | 2749 | 60 |
1805446 | 1805446 | 2021-10-11 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1802197 | 1802197 | 2021-10-10 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1798948 | 1798948 | 2021-10-09 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1795699 | 1795699 | 2021-10-08 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1773863 | 1773863 | 2021-10-01 | Houston | Texas | 48225 | 2749 | 77 |
1713648 | 1713648 | 2021-09-13 | Adair | Kentucky | 21001 | 2749 | 62 |
1715682 | 1715682 | 2021-09-13 | Salem city | Virginia | 51775 | 2749 | 53 |
1710401 | 1710401 | 2021-09-12 | Adair | Kentucky | 21001 | 2749 | 62 |
1707154 | 1707154 | 2021-09-11 | Adair | Kentucky | 21001 | 2749 | 62 |
1698013 | 1698013 | 2021-09-08 | Vernon | Missouri | 29217 | 2749 | 56 |
1676656 | 1676656 | 2021-09-01 | Lee | Virginia | 51105 | 2749 | 48 |
1669798 | 1669798 | 2021-08-30 | Austin | Texas | 48015 | 2749 | 41 |
1658962 | 1658962 | 2021-08-27 | Henry | Missouri | 29083 | 2749 | 42 |
1653668 | 1653668 | 2021-08-25 | Hutchinson | Texas | 48233 | 2749 | 73 |
1641974 | 1641974 | 2021-08-22 | Washington | Indiana | 18175 | 2749 | 40 |
1638724 | 1638724 | 2021-08-21 | Washington | Indiana | 18175 | 2749 | 40 |
1640303 | 1640303 | 2021-08-21 | Juncos | Puerto Rico | 72077 | 2749 | |
1635474 | 1635474 | 2021-08-20 | Washington | Indiana | 18175 | 2749 | 40 |
1631896 | 1631896 | 2021-08-19 | Hart | Georgia | 13147 | 2749 | 57 |
1605938 | 1605938 | 2021-08-11 | McDuffie | Georgia | 13189 | 2749 | 52 |
1608044 | 1608044 | 2021-08-11 | Morgan | Tennessee | 47129 | 2749 | 39 |
1585893 | 1585893 | 2021-08-04 | Kewaunee | Wisconsin | 55061 | 2749 | 37 |
1560431 | 1560431 | 2021-07-28 | Harris | Georgia | 13145 | 2749 | 65 |
1560683 | 1560683 | 2021-07-28 | Clay | Indiana | 18021 | 2749 | 49 |
1559709 | 1559709 | 2021-07-27 | Hopewell city | Virginia | 51670 | 2749 | 79 |
1536679 | 1536679 | 2021-07-20 | Dimmit | Texas | 48127 | 2749 | 37 |
1537049 | 1537049 | 2021-07-20 | Wythe | Virginia | 51197 | 2749 | 81 |
1531205 | 1531205 | 2021-07-19 | Haralson | Georgia | 13143 | 2749 | 91 |
1532267 | 1532267 | 2021-07-19 | Crawford | Missouri | 29055 | 2749 | 40 |
1512846 | 1512846 | 2021-07-13 | Randolph | Missouri | 29175 | 2749 | 31 |
1509467 | 1509467 | 2021-07-12 | Leake | Mississippi | 28079 | 2749 | 74 |
1493877 | 1493877 | 2021-07-07 | Henry | Ohio | 39069 | 2749 | 67 |
1486891 | 1486891 | 2021-07-05 | Stone | Missouri | 29209 | 2749 | 49 |
1469826 | 1469826 | 2021-06-30 | Posey | Indiana | 18129 | 2749 | 35 |
1428958 | 1428958 | 2021-06-17 | Hardin | Ohio | 39065 | 2749 | 65 |
1425713 | 1425713 | 2021-06-16 | Hardin | Ohio | 39065 | 2749 | 65 |
1421637 | 1421637 | 2021-06-15 | Dickinson | Michigan | 26043 | 2749 | 74 |
1422466 | 1422466 | 2021-06-15 | Hardin | Ohio | 39065 | 2749 | 65 |
1423071 | 1423071 | 2021-06-15 | Fayette | Texas | 48149 | 2749 | 67 |
1404531 | 1404531 | 2021-06-10 | Taylor | Florida | 12123 | 2749 | 48 |
1401286 | 1401286 | 2021-06-09 | Taylor | Florida | 12123 | 2749 | 48 |
1398041 | 1398041 | 2021-06-08 | Taylor | Florida | 12123 | 2749 | 48 |
1394794 | 1394794 | 2021-06-07 | Taylor | Florida | 12123 | 2749 | 48 |
1391549 | 1391549 | 2021-06-06 | Taylor | Florida | 12123 | 2749 | 48 |
1388304 | 1388304 | 2021-06-05 | Taylor | Florida | 12123 | 2749 | 48 |
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);