ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where cases = 3170 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 28
- Virginia 12
- Georgia 10
- Kentucky 10
- Louisiana 9
- South Carolina 9
- Tennessee 9
- Texas 9
- Arkansas 8
- Iowa 8
- New York 8
- West Virginia 8
- North Carolina 6
- Indiana 5
- Kansas 5
- Mississippi 5
- Missouri 5
- Ohio 5
- Wisconsin 5
- Maryland 4
- Michigan 4
- Oregon 4
- Alabama 3
- New Mexico 3
- Pennsylvania 3
- Puerto Rico 2
- California 1
- Florida 1
- Idaho 1
- Illinois 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466892 | 2466892 | 2022-05-02 | Roane | West Virginia | 54087 | 3170 | 36 |
2256929 | 2256929 | 2022-02-27 | Greene | Mississippi | 28041 | 3170 | 56 |
2258499 | 2258499 | 2022-02-27 | Martinsville city | Virginia | 51690 | 3170 | 110 |
2253678 | 2253678 | 2022-02-26 | Greene | Mississippi | 28041 | 3170 | 56 |
2255248 | 2255248 | 2022-02-26 | Martinsville city | Virginia | 51690 | 3170 | 110 |
2250427 | 2250427 | 2022-02-25 | Greene | Mississippi | 28041 | 3170 | 56 |
2251997 | 2251997 | 2022-02-25 | Martinsville city | Virginia | 51690 | 3170 | 110 |
2247176 | 2247176 | 2022-02-24 | Greene | Mississippi | 28041 | 3170 | 56 |
2244720 | 2244720 | 2022-02-23 | Baker | Oregon | 41001 | 3170 | 46 |
2228980 | 2228980 | 2022-02-18 | Jackson | Texas | 48239 | 3170 | 56 |
2218047 | 2218047 | 2022-02-15 | Mississippi | Missouri | 29133 | 3170 | 55 |
2216148 | 2216148 | 2022-02-14 | Lamoille | Vermont | 50015 | 3170 | 15 |
2190612 | 2190612 | 2022-02-07 | Marion | Arkansas | 5089 | 3170 | 76 |
2179352 | 2179352 | 2022-02-03 | Yates | New York | 36123 | 3170 | 37 |
2172999 | 2172999 | 2022-02-01 | Walsh | North Dakota | 38099 | 3170 | 34 |
2145610 | 2145610 | 2022-01-24 | Washington | Illinois | 17189 | 3170 | 38 |
2144514 | 2144514 | 2022-01-23 | Tyler | Texas | 48457 | 3170 | 73 |
2128578 | 2128578 | 2022-01-18 | Lafayette | Wisconsin | 55065 | 3170 | 18 |
2109270 | 2109270 | 2022-01-13 | Howard | Arkansas | 5061 | 3170 | 39 |
2109071 | 2109071 | 2022-01-12 | Marquette | Wisconsin | 55077 | 3170 | 41 |
2104540 | 2104540 | 2022-01-11 | Bertie | North Carolina | 37015 | 3170 | 54 |
2105644 | 2105644 | 2022-01-11 | Nottoway | Virginia | 51135 | 3170 | 72 |
2077714 | 2077714 | 2022-01-03 | Powell | Kentucky | 21197 | 3170 | 28 |
2075657 | 2075657 | 2022-01-02 | Fulton | Pennsylvania | 42057 | 3170 | 49 |
2054903 | 2054903 | 2021-12-27 | Garrard | Kentucky | 21079 | 3170 | 59 |
2010726 | 2010726 | 2021-12-13 | Humacao | Puerto Rico | 72069 | 3170 | |
2007475 | 2007475 | 2021-12-12 | Humacao | Puerto Rico | 72069 | 3170 | |
1983461 | 1983461 | 2021-12-05 | Spencer | Kentucky | 21215 | 3170 | 40 |
1980211 | 1980211 | 2021-12-04 | Spencer | Kentucky | 21215 | 3170 | 40 |
1976961 | 1976961 | 2021-12-03 | Spencer | Kentucky | 21215 | 3170 | 40 |
1971615 | 1971615 | 2021-12-01 | Wasco | Oregon | 41065 | 3170 | 46 |
1955223 | 1955223 | 2021-11-26 | Paulding | Ohio | 39125 | 3170 | 49 |
1940127 | 1940127 | 2021-11-22 | Hale | Alabama | 1065 | 3170 | 89 |
1937275 | 1937275 | 2021-11-21 | Crisp | Georgia | 13081 | 3170 | 114 |
1934025 | 1934025 | 2021-11-20 | Crisp | Georgia | 13081 | 3170 | 114 |
1935201 | 1935201 | 2021-11-20 | Texas | Missouri | 29215 | 3170 | 63 |
1936716 | 1936716 | 2021-11-20 | Lincoln | West Virginia | 54043 | 3170 | 49 |
1930773 | 1930773 | 2021-11-19 | Crisp | Georgia | 13081 | 3170 | 114 |
1878473 | 1878473 | 2021-11-03 | Conway | Arkansas | 5029 | 3170 | 44 |
1880961 | 1880961 | 2021-11-03 | Trousdale | Tennessee | 47169 | 3170 | 26 |
1850316 | 1850316 | 2021-10-25 | Caroline | Maryland | 24011 | 3170 | 47 |
1850865 | 1850865 | 2021-10-25 | Unknown | Nebraska | 3170 | 136 | |
1848855 | 1848855 | 2021-10-24 | Louisa | Virginia | 51109 | 3170 | 44 |
1845605 | 1845605 | 2021-10-23 | Louisa | Virginia | 51109 | 3170 | 44 |
1842355 | 1842355 | 2021-10-22 | Louisa | Virginia | 51109 | 3170 | 44 |
1833967 | 1833967 | 2021-10-20 | Simpson | Kentucky | 21213 | 3170 | 53 |
1795409 | 1795409 | 2021-10-08 | Henry | Missouri | 29083 | 3170 | 49 |
1770312 | 1770312 | 2021-09-30 | Fairfield | South Carolina | 45039 | 3170 | 93 |
1758005 | 1758005 | 2021-09-26 | Mason | West Virginia | 54053 | 3170 | 47 |
1742613 | 1742613 | 2021-09-22 | Fountain | Indiana | 18045 | 3170 | 57 |
1739447 | 1739447 | 2021-09-21 | Carroll | Iowa | 19027 | 3170 | 53 |
1736198 | 1736198 | 2021-09-20 | Carroll | Iowa | 19027 | 3170 | 53 |
1732948 | 1732948 | 2021-09-19 | Carroll | Iowa | 19027 | 3170 | 53 |
1729698 | 1729698 | 2021-09-18 | Carroll | Iowa | 19027 | 3170 | 53 |
1726448 | 1726448 | 2021-09-17 | Carroll | Iowa | 19027 | 3170 | 53 |
1723199 | 1723199 | 2021-09-16 | Carroll | Iowa | 19027 | 3170 | 53 |
1719950 | 1719950 | 2021-09-15 | Carroll | Iowa | 19027 | 3170 | 53 |
1713705 | 1713705 | 2021-09-13 | Johnson | Kentucky | 21115 | 3170 | 40 |
1696104 | 1696104 | 2021-09-07 | Carroll | Virginia | 51035 | 3170 | 81 |
1683570 | 1683570 | 2021-09-04 | Ouachita | Arkansas | 5103 | 3170 | 68 |
1670294 | 1670294 | 2021-08-30 | Mingo | West Virginia | 54059 | 3170 | 46 |
1628190 | 1628190 | 2021-08-18 | Bibb | Alabama | 1007 | 3170 | 68 |
1625895 | 1625895 | 2021-08-17 | Miami | Kansas | 20121 | 3170 | 45 |
1628178 | 1628178 | 2021-08-17 | Park | Wyoming | 56029 | 3170 | 35 |
1622648 | 1622648 | 2021-08-16 | Miami | Kansas | 20121 | 3170 | 45 |
1600834 | 1600834 | 2021-08-09 | Orleans | New York | 36073 | 3170 | 83 |
1594046 | 1594046 | 2021-08-07 | Saline | Missouri | 29195 | 3170 | 40 |
1537279 | 1537279 | 2021-07-21 | Lawrence | Alabama | 1079 | 3170 | 101 |
1537042 | 1537042 | 2021-07-20 | Warren | Virginia | 51187 | 3170 | 61 |
1519284 | 1519284 | 2021-07-15 | Dunklin | Missouri | 29069 | 3170 | 50 |
1513159 | 1513159 | 2021-07-13 | Washington | New York | 36115 | 3170 | 55 |
1509913 | 1509913 | 2021-07-12 | Washington | New York | 36115 | 3170 | 55 |
1506666 | 1506666 | 2021-07-11 | Washington | New York | 36115 | 3170 | 55 |
1503420 | 1503420 | 2021-07-10 | Washington | New York | 36115 | 3170 | 55 |
1500174 | 1500174 | 2021-07-09 | Washington | New York | 36115 | 3170 | 55 |
1450594 | 1450594 | 2021-06-24 | Bell | Kentucky | 21013 | 3170 | 58 |
1445322 | 1445322 | 2021-06-22 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1442077 | 1442077 | 2021-06-21 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1438832 | 1438832 | 2021-06-20 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1435585 | 1435585 | 2021-06-19 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1432338 | 1432338 | 2021-06-18 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1429092 | 1429092 | 2021-06-17 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1429299 | 1429299 | 2021-06-17 | Edgefield | South Carolina | 45037 | 3170 | 43 |
1425847 | 1425847 | 2021-06-16 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1426054 | 1426054 | 2021-06-16 | Edgefield | South Carolina | 45037 | 3170 | 43 |
1422600 | 1422600 | 2021-06-15 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1423362 | 1423362 | 2021-06-15 | Isle of Wight | Virginia | 51093 | 3170 | 70 |
1419354 | 1419354 | 2021-06-14 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1416109 | 1416109 | 2021-06-13 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1416341 | 1416341 | 2021-06-13 | Union | South Carolina | 45087 | 3170 | 83 |
1412863 | 1412863 | 2021-06-12 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1413070 | 1413070 | 2021-06-12 | Edgefield | South Carolina | 45037 | 3170 | 43 |
1413095 | 1413095 | 2021-06-12 | Union | South Carolina | 45087 | 3170 | 83 |
1409618 | 1409618 | 2021-06-11 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1409825 | 1409825 | 2021-06-11 | Edgefield | South Carolina | 45037 | 3170 | 43 |
1409850 | 1409850 | 2021-06-11 | Union | South Carolina | 45087 | 3170 | 83 |
1406373 | 1406373 | 2021-06-10 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1403127 | 1403127 | 2021-06-09 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1399882 | 1399882 | 2021-06-08 | Woodward | Oklahoma | 40153 | 3170 | 36 |
1396637 | 1396637 | 2021-06-07 | Woodward | Oklahoma | 40153 | 3170 | 36 |
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);