ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
178 rows where cases = 3374 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 17
- Mississippi 14
- Texas 14
- Illinois 12
- Florida 7
- Indiana 7
- New Mexico 7
- Virginia 7
- Arkansas 6
- Kentucky 6
- Nebraska 6
- Puerto Rico 6
- Alabama 5
- North Carolina 5
- West Virginia 5
- Massachusetts 4
- Oregon 4
- Pennsylvania 4
- Alaska 3
- Maryland 3
- Minnesota 3
- Missouri 3
- New York 3
- Ohio 3
- Oklahoma 3
- Tennessee 3
- Colorado 2
- Georgia 2
- Michigan 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501636 | 2501636 | 2022-05-13 | Walsh | North Dakota | 38099 | 3374 | 34 |
2483905 | 2483905 | 2022-05-08 | Cumberland | Illinois | 17035 | 3374 | 49 |
2480647 | 2480647 | 2022-05-07 | Cumberland | Illinois | 17035 | 3374 | 49 |
2477389 | 2477389 | 2022-05-06 | Cumberland | Illinois | 17035 | 3374 | 49 |
2474131 | 2474131 | 2022-05-05 | Cumberland | Illinois | 17035 | 3374 | 49 |
2470874 | 2470874 | 2022-05-04 | Cumberland | Illinois | 17035 | 3374 | 49 |
2467618 | 2467618 | 2022-05-03 | Cumberland | Illinois | 17035 | 3374 | 49 |
2465482 | 2465482 | 2022-05-02 | Otoe | Nebraska | 31131 | 3374 | 19 |
2462227 | 2462227 | 2022-05-01 | Otoe | Nebraska | 31131 | 3374 | 19 |
2458971 | 2458971 | 2022-04-30 | Otoe | Nebraska | 31131 | 3374 | 19 |
2455715 | 2455715 | 2022-04-29 | Otoe | Nebraska | 31131 | 3374 | 19 |
2452459 | 2452459 | 2022-04-28 | Otoe | Nebraska | 31131 | 3374 | 19 |
2449203 | 2449203 | 2022-04-27 | Otoe | Nebraska | 31131 | 3374 | 19 |
2440745 | 2440745 | 2022-04-24 | Southampton | Virginia | 51175 | 3374 | 91 |
2437489 | 2437489 | 2022-04-23 | Southampton | Virginia | 51175 | 3374 | 91 |
2434233 | 2434233 | 2022-04-22 | Southampton | Virginia | 51175 | 3374 | 91 |
2327199 | 2327199 | 2022-03-21 | Marion | Arkansas | 5089 | 3374 | 87 |
2323946 | 2323946 | 2022-03-20 | Marion | Arkansas | 5089 | 3374 | 87 |
2307128 | 2307128 | 2022-03-14 | Tyler | Texas | 48457 | 3374 | 83 |
2303877 | 2303877 | 2022-03-13 | Tyler | Texas | 48457 | 3374 | 83 |
2300625 | 2300625 | 2022-03-12 | Tyler | Texas | 48457 | 3374 | 83 |
2279750 | 2279750 | 2022-03-06 | Webster | Mississippi | 28155 | 3374 | 68 |
2276497 | 2276497 | 2022-03-05 | Webster | Mississippi | 28155 | 3374 | 68 |
2273244 | 2273244 | 2022-03-04 | Webster | Mississippi | 28155 | 3374 | 68 |
2269992 | 2269992 | 2022-03-03 | Webster | Mississippi | 28155 | 3374 | 68 |
2254133 | 2254133 | 2022-02-26 | Schuyler | New York | 36097 | 3374 | 24 |
2237219 | 2237219 | 2022-02-21 | Dukes | Massachusetts | 25007 | 3374 | 0 |
2233968 | 2233968 | 2022-02-20 | Dukes | Massachusetts | 25007 | 3374 | 0 |
2230717 | 2230717 | 2022-02-19 | Dukes | Massachusetts | 25007 | 3374 | 0 |
2227466 | 2227466 | 2022-02-18 | Dukes | Massachusetts | 25007 | 3374 | 0 |
2224080 | 2224080 | 2022-02-17 | Pendleton | Kentucky | 21191 | 3374 | 33 |
2225406 | 2225406 | 2022-02-17 | Bamberg | South Carolina | 45009 | 3374 | 71 |
2220429 | 2220429 | 2022-02-16 | Washington | Illinois | 17189 | 3374 | 40 |
2200401 | 2200401 | 2022-02-10 | Van Buren | Arkansas | 5141 | 3374 | 52 |
2199085 | 2199085 | 2022-02-09 | Monroe | Ohio | 39111 | 3374 | 69 |
2194586 | 2194586 | 2022-02-08 | Poweshiek | Iowa | 19157 | 3374 | 54 |
2191332 | 2191332 | 2022-02-07 | Poweshiek | Iowa | 19157 | 3374 | 54 |
2188079 | 2188079 | 2022-02-06 | Poweshiek | Iowa | 19157 | 3374 | 54 |
2189543 | 2189543 | 2022-02-06 | Anasco | Puerto Rico | 72011 | 3374 | |
2184826 | 2184826 | 2022-02-05 | Poweshiek | Iowa | 19157 | 3374 | 54 |
2181574 | 2181574 | 2022-02-04 | Poweshiek | Iowa | 19157 | 3374 | 54 |
2178323 | 2178323 | 2022-02-03 | Poweshiek | Iowa | 19157 | 3374 | 54 |
2175070 | 2175070 | 2022-02-02 | Poweshiek | Iowa | 19157 | 3374 | 54 |
2163573 | 2163573 | 2022-01-29 | Quebradillas | Puerto Rico | 72115 | 3374 | |
2157666 | 2157666 | 2022-01-27 | King William | Virginia | 51101 | 3374 | 27 |
2145545 | 2145545 | 2022-01-24 | Greene | Illinois | 17061 | 3374 | 55 |
2141741 | 2141741 | 2022-01-23 | North Slope Borough | Alaska | 2185 | 3374 | 10 |
2138485 | 2138485 | 2022-01-22 | North Slope Borough | Alaska | 2185 | 3374 | 10 |
2135230 | 2135230 | 2022-01-21 | North Slope Borough | Alaska | 2185 | 3374 | 10 |
2137847 | 2137847 | 2022-01-21 | Falls | Texas | 48145 | 3374 | 55 |
2127315 | 2127315 | 2022-01-18 | Chowan | North Carolina | 37041 | 3374 | 46 |
2114793 | 2114793 | 2022-01-14 | Yauco | Puerto Rico | 72153 | 3374 | |
2096891 | 2096891 | 2022-01-09 | Perry | Indiana | 18123 | 3374 | 59 |
2093639 | 2093639 | 2022-01-08 | Perry | Indiana | 18123 | 3374 | 59 |
2090387 | 2090387 | 2022-01-07 | Perry | Indiana | 18123 | 3374 | 59 |
2092533 | 2092533 | 2022-01-07 | Caledonia | Vermont | 50005 | 3374 | 21 |
2083731 | 2083731 | 2022-01-05 | Clark | Illinois | 17023 | 3374 | 54 |
2063802 | 2063802 | 2021-12-30 | Colusa | California | 6011 | 3374 | 21 |
2058903 | 2058903 | 2021-12-28 | Unknown | New Hampshire | 3374 | 20 | |
2054971 | 2054971 | 2021-12-27 | Spencer | Kentucky | 21215 | 3374 | 43 |
2031794 | 2031794 | 2021-12-20 | Richland | Illinois | 17159 | 3374 | 75 |
2021413 | 2021413 | 2021-12-17 | Pickens | Alabama | 1107 | 3374 | 91 |
2010795 | 2010795 | 2021-12-13 | Fairfield | South Carolina | 45039 | 3374 | 93 |
1991914 | 1991914 | 2021-12-07 | Adams | Washington | 53001 | 3374 | 34 |
1988663 | 1988663 | 2021-12-06 | Adams | Washington | 53001 | 3374 | 34 |
1983455 | 1983455 | 2021-12-05 | Rockcastle | Kentucky | 21203 | 3374 | 38 |
1980205 | 1980205 | 2021-12-04 | Rockcastle | Kentucky | 21203 | 3374 | 38 |
1976955 | 1976955 | 2021-12-03 | Rockcastle | Kentucky | 21203 | 3374 | 38 |
1969473 | 1969473 | 2021-12-01 | Clark | Arkansas | 5019 | 3374 | 61 |
1966152 | 1966152 | 2021-11-30 | Monroe | Alabama | 1099 | 3374 | 66 |
1944764 | 1944764 | 2021-11-23 | Attala | Mississippi | 28007 | 3374 | 90 |
1896846 | 1896846 | 2021-11-08 | Lincoln | Oregon | 41041 | 3374 | 46 |
1881603 | 1881603 | 2021-11-04 | Butler | Alabama | 1013 | 3374 | 99 |
1879570 | 1879570 | 2021-11-03 | Somerset | Maryland | 24039 | 3374 | 54 |
1879794 | 1879794 | 2021-11-03 | Jasper | Mississippi | 28061 | 3374 | 65 |
1876740 | 1876740 | 2021-11-02 | Lincoln | Montana | 30053 | 3374 | 56 |
1872137 | 1872137 | 2021-11-01 | Montezuma | Colorado | 8083 | 3374 | 37 |
1832904 | 1832904 | 2021-10-20 | Marengo | Alabama | 1091 | 3374 | 89 |
1835216 | 1835216 | 2021-10-20 | Dorado | Puerto Rico | 72051 | 3374 | |
1830430 | 1830430 | 2021-10-19 | Crawford | Iowa | 19047 | 3374 | 45 |
1827181 | 1827181 | 2021-10-18 | Crawford | Iowa | 19047 | 3374 | 45 |
1829399 | 1829399 | 2021-10-18 | Salem city | Virginia | 51775 | 3374 | 58 |
1823932 | 1823932 | 2021-10-17 | Crawford | Iowa | 19047 | 3374 | 45 |
1820683 | 1820683 | 2021-10-16 | Crawford | Iowa | 19047 | 3374 | 45 |
1817434 | 1817434 | 2021-10-15 | Crawford | Iowa | 19047 | 3374 | 45 |
1814186 | 1814186 | 2021-10-14 | Crawford | Iowa | 19047 | 3374 | 45 |
1816466 | 1816466 | 2021-10-14 | Boone | West Virginia | 54005 | 3374 | 47 |
1810592 | 1810592 | 2021-10-13 | Lamar | Georgia | 13171 | 3374 | 84 |
1810937 | 1810937 | 2021-10-13 | Crawford | Iowa | 19047 | 3374 | 45 |
1813249 | 1813249 | 2021-10-13 | Nicholas | West Virginia | 54067 | 3374 | 38 |
1793774 | 1793774 | 2021-10-07 | Wyoming | West Virginia | 54109 | 3374 | 52 |
1764088 | 1764088 | 2021-09-28 | Gillespie | Texas | 48171 | 3374 | 72 |
1734851 | 1734851 | 2021-09-19 | Gonzales | Texas | 48177 | 3374 | 73 |
1731601 | 1731601 | 2021-09-18 | Gonzales | Texas | 48177 | 3374 | 69 |
1728351 | 1728351 | 2021-09-17 | Gonzales | Texas | 48177 | 3374 | 68 |
1725102 | 1725102 | 2021-09-16 | Gonzales | Texas | 48177 | 3374 | 68 |
1717230 | 1717230 | 2021-09-14 | Cass | Minnesota | 27021 | 3374 | 35 |
1713865 | 1713865 | 2021-09-13 | Queen Anne's | Maryland | 24035 | 3374 | 59 |
1697842 | 1697842 | 2021-09-08 | Grenada | Mississippi | 28043 | 3374 | 97 |
1678519 | 1678519 | 2021-09-02 | Washington | Missouri | 29221 | 3374 | 56 |
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);