ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
208 rows where cases = 2516 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497889 | 2497889 | 2022-05-12 | Montgomery | Missouri | 29139 | 2516 | 57 |
2494631 | 2494631 | 2022-05-11 | Montgomery | Missouri | 29139 | 2516 | 57 |
2491373 | 2491373 | 2022-05-10 | Montgomery | Missouri | 29139 | 2516 | 57 |
2488115 | 2488115 | 2022-05-09 | Montgomery | Missouri | 29139 | 2516 | 57 |
2484858 | 2484858 | 2022-05-08 | Montgomery | Missouri | 29139 | 2516 | 57 |
2481600 | 2481600 | 2022-05-07 | Montgomery | Missouri | 29139 | 2516 | 57 |
2478342 | 2478342 | 2022-05-06 | Montgomery | Missouri | 29139 | 2516 | 57 |
2473675 | 2473675 | 2022-05-05 | Perry | Arkansas | 5105 | 2516 | 37 |
2470418 | 2470418 | 2022-05-04 | Perry | Arkansas | 5105 | 2516 | 37 |
2467162 | 2467162 | 2022-05-03 | Perry | Arkansas | 5105 | 2516 | 37 |
2463907 | 2463907 | 2022-05-02 | Perry | Arkansas | 5105 | 2516 | 37 |
2466699 | 2466699 | 2022-05-02 | Charlotte | Virginia | 51037 | 2516 | 46 |
2460651 | 2460651 | 2022-05-01 | Perry | Arkansas | 5105 | 2516 | 37 |
2457395 | 2457395 | 2022-04-30 | Perry | Arkansas | 5105 | 2516 | 37 |
2454139 | 2454139 | 2022-04-29 | Perry | Arkansas | 5105 | 2516 | 37 |
2450883 | 2450883 | 2022-04-28 | Perry | Arkansas | 5105 | 2516 | 37 |
2453676 | 2453676 | 2022-04-28 | Charlotte | Virginia | 51037 | 2516 | 46 |
2447627 | 2447627 | 2022-04-27 | Perry | Arkansas | 5105 | 2516 | 37 |
2358725 | 2358725 | 2022-03-30 | Santa Isabel | Puerto Rico | 72133 | 2516 | |
2353318 | 2353318 | 2022-03-29 | Bent | Colorado | 8011 | 2516 | 47 |
2240072 | 2240072 | 2022-02-22 | Grundy | Iowa | 19075 | 2516 | 40 |
2236152 | 2236152 | 2022-02-21 | Pike | Arkansas | 5109 | 2516 | 39 |
2236821 | 2236821 | 2022-02-21 | Grundy | Iowa | 19075 | 2516 | 40 |
2237623 | 2237623 | 2022-02-21 | Jefferson | Montana | 30043 | 2516 | 23 |
2233268 | 2233268 | 2022-02-20 | Turner | Georgia | 13287 | 2516 | 53 |
2233570 | 2233570 | 2022-02-20 | Grundy | Iowa | 19075 | 2516 | 40 |
2234372 | 2234372 | 2022-02-20 | Jefferson | Montana | 30043 | 2516 | 23 |
2230017 | 2230017 | 2022-02-19 | Turner | Georgia | 13287 | 2516 | 53 |
2230319 | 2230319 | 2022-02-19 | Grundy | Iowa | 19075 | 2516 | 40 |
2231121 | 2231121 | 2022-02-19 | Jefferson | Montana | 30043 | 2516 | 23 |
2226766 | 2226766 | 2022-02-18 | Turner | Georgia | 13287 | 2516 | 53 |
2227068 | 2227068 | 2022-02-18 | Grundy | Iowa | 19075 | 2516 | 40 |
2227870 | 2227870 | 2022-02-18 | Jefferson | Montana | 30043 | 2516 | 23 |
2223515 | 2223515 | 2022-02-17 | Turner | Georgia | 13287 | 2516 | 53 |
2223817 | 2223817 | 2022-02-17 | Grundy | Iowa | 19075 | 2516 | 40 |
2220566 | 2220566 | 2022-02-16 | Grundy | Iowa | 19075 | 2516 | 40 |
2203450 | 2203450 | 2022-02-10 | Big Horn | Wyoming | 56003 | 2516 | 60 |
2183844 | 2183844 | 2022-02-04 | Summers | West Virginia | 54089 | 2516 | 44 |
2167731 | 2167731 | 2022-01-31 | Lowndes | Alabama | 1085 | 2516 | 68 |
2156137 | 2156137 | 2022-01-27 | Noxubee | Mississippi | 28103 | 2516 | 46 |
2131730 | 2131730 | 2022-01-19 | Pacific | Washington | 53049 | 2516 | 43 |
2123464 | 2123464 | 2022-01-17 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2120212 | 2120212 | 2022-01-16 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2116960 | 2116960 | 2022-01-15 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2113709 | 2113709 | 2022-01-14 | Aitkin | Minnesota | 27001 | 2516 | 56 |
2103058 | 2103058 | 2022-01-11 | Dade | Georgia | 13083 | 2516 | 23 |
2100906 | 2100906 | 2022-01-10 | Dent | Missouri | 29065 | 2516 | 64 |
2088489 | 2088489 | 2022-01-06 | Morgan | Ohio | 39115 | 2516 | 47 |
2088627 | 2088627 | 2022-01-06 | Tillamook | Oregon | 41057 | 2516 | 51 |
2066588 | 2066588 | 2021-12-30 | Goochland | Virginia | 51075 | 2516 | 35 |
2031775 | 2031775 | 2021-12-20 | Massac | Illinois | 17127 | 2516 | 59 |
2020964 | 2020964 | 2021-12-16 | Tyler | Texas | 48457 | 2516 | 72 |
2017713 | 2017713 | 2021-12-15 | Tyler | Texas | 48457 | 2516 | 72 |
2011128 | 2011128 | 2021-12-13 | Leon | Texas | 48289 | 2516 | 71 |
1997711 | 1997711 | 2021-12-09 | Corozal | Puerto Rico | 72047 | 2516 | |
1991964 | 1991964 | 2021-12-07 | Grant | West Virginia | 54023 | 2516 | 41 |
1983117 | 1983117 | 2021-12-05 | Parke | Indiana | 18121 | 2516 | 31 |
1979867 | 1979867 | 2021-12-04 | Parke | Indiana | 18121 | 2516 | 31 |
1976617 | 1976617 | 2021-12-03 | Parke | Indiana | 18121 | 2516 | 31 |
1977884 | 1977884 | 2021-12-03 | McKenzie | North Dakota | 38053 | 2516 | 22 |
1972616 | 1972616 | 2021-12-02 | Clay | Alabama | 1027 | 2516 | 69 |
1967231 | 1967231 | 2021-11-30 | Bienville | Louisiana | 22013 | 2516 | 99 |
1963979 | 1963979 | 2021-11-29 | Bienville | Louisiana | 22013 | 2516 | 99 |
1964453 | 1964453 | 2021-11-29 | Ste. Genevieve | Missouri | 29186 | 2516 | 33 |
1960728 | 1960728 | 2021-11-28 | Bienville | Louisiana | 22013 | 2516 | 99 |
1957477 | 1957477 | 2021-11-27 | Bienville | Louisiana | 22013 | 2516 | 99 |
1954226 | 1954226 | 2021-11-26 | Bienville | Louisiana | 22013 | 2516 | 99 |
1950975 | 1950975 | 2021-11-25 | Bienville | Louisiana | 22013 | 2516 | 99 |
1947724 | 1947724 | 2021-11-24 | Bienville | Louisiana | 22013 | 2516 | 99 |
1944473 | 1944473 | 2021-11-23 | Bienville | Louisiana | 22013 | 2516 | 99 |
1915208 | 1915208 | 2021-11-14 | Union | Kentucky | 21225 | 2516 | 36 |
1911958 | 1911958 | 2021-11-13 | Union | Kentucky | 21225 | 2516 | 36 |
1908709 | 1908709 | 2021-11-12 | Union | Kentucky | 21225 | 2516 | 36 |
1902141 | 1902141 | 2021-11-10 | Green | Kentucky | 21087 | 2516 | 36 |
1858483 | 1858483 | 2021-10-27 | Zavala | Texas | 48507 | 2516 | 54 |
1852420 | 1852420 | 2021-10-26 | Washington | Alabama | 1129 | 2516 | 51 |
1855234 | 1855234 | 2021-10-26 | Zavala | Texas | 48507 | 2516 | 54 |
1849170 | 1849170 | 2021-10-25 | Washington | Alabama | 1129 | 2516 | 51 |
1851985 | 1851985 | 2021-10-25 | Zavala | Texas | 48507 | 2516 | 53 |
1845920 | 1845920 | 2021-10-24 | Washington | Alabama | 1129 | 2516 | 51 |
1846250 | 1846250 | 2021-10-24 | Bacon | Georgia | 13005 | 2516 | 58 |
1843000 | 1843000 | 2021-10-23 | Bacon | Georgia | 13005 | 2516 | 58 |
1839750 | 1839750 | 2021-10-22 | Bacon | Georgia | 13005 | 2516 | 58 |
1836251 | 1836251 | 2021-10-21 | Izard | Arkansas | 5065 | 2516 | 55 |
1834563 | 1834563 | 2021-10-20 | Gage | Nebraska | 31067 | 2516 | 27 |
1835777 | 1835777 | 2021-10-20 | Orleans | Vermont | 50019 | 2516 | 13 |
1804010 | 1804010 | 2021-10-11 | Bacon | Georgia | 13005 | 2516 | 54 |
1800634 | 1800634 | 2021-10-10 | Elbert | Colorado | 8039 | 2516 | 21 |
1800761 | 1800761 | 2021-10-10 | Bacon | Georgia | 13005 | 2516 | 54 |
1797385 | 1797385 | 2021-10-09 | Elbert | Colorado | 8039 | 2516 | 21 |
1797512 | 1797512 | 2021-10-09 | Bacon | Georgia | 13005 | 2516 | 54 |
1794136 | 1794136 | 2021-10-08 | Elbert | Colorado | 8039 | 2516 | 21 |
1794263 | 1794263 | 2021-10-08 | Bacon | Georgia | 13005 | 2516 | 54 |
1795484 | 1795484 | 2021-10-08 | Wright | Missouri | 29229 | 2516 | 46 |
1790146 | 1790146 | 2021-10-06 | Llano | Texas | 48299 | 2516 | 68 |
1774008 | 1774008 | 2021-10-01 | Carbon | Utah | 49007 | 2516 | 23 |
1757905 | 1757905 | 2021-09-26 | Powhatan | Virginia | 51145 | 2516 | 21 |
1754657 | 1754657 | 2021-09-25 | Powhatan | Virginia | 51145 | 2516 | 21 |
1751409 | 1751409 | 2021-09-24 | Powhatan | Virginia | 51145 | 2516 | 21 |
1723575 | 1723575 | 2021-09-16 | Winn | Louisiana | 22127 | 2516 | 57 |
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);