ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 3686 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 19
- Georgia 13
- Texas 12
- Indiana 7
- Ohio 6
- South Carolina 6
- Alabama 5
- Mississippi 4
- Missouri 4
- Puerto Rico 4
- Tennessee 4
- Louisiana 3
- North Carolina 3
- Pennsylvania 3
- Wisconsin 3
- Arkansas 2
- California 2
- Illinois 2
- Minnesota 2
- Virgin Islands 2
- West Virginia 2
- Iowa 1
- Kentucky 1
- Maine 1
- Michigan 1
- Montana 1
- Nebraska 1
- New Mexico 1
- New York 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483795 | 2483795 | 2022-05-08 | Rabun | Georgia | 13241 | 3686 | 98 |
2480537 | 2480537 | 2022-05-07 | Rabun | Georgia | 13241 | 3686 | 98 |
2477279 | 2477279 | 2022-05-06 | Rabun | Georgia | 13241 | 3686 | 98 |
2474021 | 2474021 | 2022-05-05 | Rabun | Georgia | 13241 | 3686 | 98 |
2470764 | 2470764 | 2022-05-04 | Rabun | Georgia | 13241 | 3686 | 98 |
2453913 | 2453913 | 2022-04-28 | Lafayette | Wisconsin | 55065 | 3686 | 24 |
2430812 | 2430812 | 2022-04-21 | Zapata | Texas | 48505 | 3686 | 55 |
2395114 | 2395114 | 2022-04-10 | King William | Virginia | 51101 | 3686 | 39 |
2391858 | 2391858 | 2022-04-09 | King William | Virginia | 51101 | 3686 | 39 |
2388602 | 2388602 | 2022-04-08 | King William | Virginia | 51101 | 3686 | 39 |
2294270 | 2294270 | 2022-03-10 | Manassas Park city | Virginia | 51685 | 3686 | 25 |
2290785 | 2290785 | 2022-03-09 | Leon | Texas | 48289 | 3686 | 90 |
2287697 | 2287697 | 2022-03-08 | Appomattox | Virginia | 51011 | 3686 | 51 |
2274532 | 2274532 | 2022-03-04 | Madison | Texas | 48313 | 3686 | 53 |
2233503 | 2233503 | 2022-02-20 | Pike | Indiana | 18125 | 3686 | 48 |
2230252 | 2230252 | 2022-02-19 | Pike | Indiana | 18125 | 3686 | 48 |
2227001 | 2227001 | 2022-02-18 | Pike | Indiana | 18125 | 3686 | 48 |
2222431 | 2222431 | 2022-02-16 | Falls | Texas | 48145 | 3686 | 59 |
2163809 | 2163809 | 2022-01-29 | Andrews | Texas | 48003 | 3686 | 69 |
2152061 | 2152061 | 2022-01-26 | Jo Daviess | Illinois | 17085 | 3686 | 35 |
2132995 | 2132995 | 2022-01-20 | Powell | Kentucky | 21197 | 3686 | 30 |
2114766 | 2114766 | 2022-01-14 | Morovis | Puerto Rico | 72101 | 3686 | |
2105278 | 2105278 | 2022-01-11 | Burleson | Texas | 48051 | 3686 | 61 |
2084564 | 2084564 | 2022-01-05 | Jasper | Mississippi | 28061 | 3686 | 66 |
2055691 | 2055691 | 2021-12-27 | Lincoln | New Mexico | 35027 | 3686 | 44 |
2046470 | 2046470 | 2021-12-24 | Dorado | Puerto Rico | 72051 | 3686 | |
2043220 | 2043220 | 2021-12-23 | Dorado | Puerto Rico | 72051 | 3686 | |
2036111 | 2036111 | 2021-12-21 | Saunders | Nebraska | 31155 | 3686 | 23 |
2037063 | 2037063 | 2021-12-21 | Fayette | Texas | 48149 | 3686 | 95 |
2030870 | 2030870 | 2021-12-19 | Mecklenburg | Virginia | 51117 | 3686 | 93 |
2027619 | 2027619 | 2021-12-18 | Mecklenburg | Virginia | 51117 | 3686 | 93 |
2024368 | 2024368 | 2021-12-17 | Mecklenburg | Virginia | 51117 | 3686 | 93 |
1988374 | 1988374 | 2021-12-06 | Limestone | Texas | 48293 | 3686 | 111 |
1985124 | 1985124 | 2021-12-05 | Limestone | Texas | 48293 | 3686 | 111 |
1972280 | 1972280 | 2021-12-01 | St. Thomas | Virgin Islands | 78030 | 3686 | 46 |
1969030 | 1969030 | 2021-11-30 | St. Thomas | Virgin Islands | 78030 | 3686 | 46 |
1928218 | 1928218 | 2021-11-18 | Assumption | Louisiana | 22007 | 3686 | 57 |
1930082 | 1930082 | 2021-11-18 | Hopewell city | Virginia | 51670 | 3686 | 88 |
1924968 | 1924968 | 2021-11-17 | Assumption | Louisiana | 22007 | 3686 | 57 |
1923508 | 1923508 | 2021-11-16 | Franklin | Vermont | 50011 | 3686 | 52 |
1906308 | 1906308 | 2021-11-11 | Martin | North Carolina | 37117 | 3686 | 74 |
1903059 | 1903059 | 2021-11-10 | Martin | North Carolina | 37117 | 3686 | 74 |
1894335 | 1894335 | 2021-11-07 | Hopewell city | Virginia | 51670 | 3686 | 89 |
1891085 | 1891085 | 2021-11-06 | Hopewell city | Virginia | 51670 | 3686 | 89 |
1887835 | 1887835 | 2021-11-05 | Hopewell city | Virginia | 51670 | 3686 | 89 |
1884150 | 1884150 | 2021-11-04 | Fentress | Tennessee | 47049 | 3686 | 67 |
1879834 | 1879834 | 2021-11-03 | Tishomingo | Mississippi | 28141 | 3686 | 93 |
1881449 | 1881449 | 2021-11-03 | Boone | West Virginia | 54005 | 3686 | 59 |
1860953 | 1860953 | 2021-10-28 | Holmes | Ohio | 39075 | 3686 | 125 |
1855412 | 1855412 | 2021-10-26 | Winchester city | Virginia | 51840 | 3686 | 53 |
1823574 | 1823574 | 2021-10-17 | Harris | Georgia | 13145 | 3686 | 83 |
1820325 | 1820325 | 2021-10-16 | Harris | Georgia | 13145 | 3686 | 83 |
1817076 | 1817076 | 2021-10-15 | Harris | Georgia | 13145 | 3686 | 83 |
1806565 | 1806565 | 2021-10-11 | Carroll | Virginia | 51035 | 3686 | 86 |
1803315 | 1803315 | 2021-10-10 | Carroll | Virginia | 51035 | 3686 | 86 |
1800066 | 1800066 | 2021-10-09 | Carroll | Virginia | 51035 | 3686 | 86 |
1796817 | 1796817 | 2021-10-08 | Carroll | Virginia | 51035 | 3686 | 86 |
1791067 | 1791067 | 2021-10-07 | Fannin | Georgia | 13111 | 3686 | 100 |
1793038 | 1793038 | 2021-10-07 | Abbeville | South Carolina | 45001 | 3686 | 47 |
1793768 | 1793768 | 2021-10-07 | Upshur | West Virginia | 54097 | 3686 | 56 |
1787100 | 1787100 | 2021-10-05 | Gloucester | Virginia | 51073 | 3686 | 62 |
1768052 | 1768052 | 2021-09-30 | Sevier | Arkansas | 5133 | 3686 | 34 |
1727248 | 1727248 | 2021-09-17 | Washington | Missouri | 29221 | 3686 | 57 |
1656078 | 1656078 | 2021-08-26 | Wyoming | New York | 36121 | 3686 | 53 |
1600135 | 1600135 | 2021-08-09 | West Baton Rouge | Louisiana | 22121 | 3686 | 66 |
1566478 | 1566478 | 2021-07-30 | Clarke | Alabama | 1025 | 3686 | 63 |
1563230 | 1563230 | 2021-07-29 | Clarke | Alabama | 1025 | 3686 | 63 |
1566393 | 1566393 | 2021-07-29 | Green | Wisconsin | 55045 | 3686 | 26 |
1562533 | 1562533 | 2021-07-28 | Hardin | Tennessee | 47071 | 3686 | 69 |
1539192 | 1539192 | 2021-07-21 | Jackson | North Carolina | 37099 | 3686 | 56 |
1490118 | 1490118 | 2021-07-06 | Pulaski | Missouri | 29169 | 3686 | 55 |
1487606 | 1487606 | 2021-07-05 | Snyder | Pennsylvania | 42109 | 3686 | 86 |
1487689 | 1487689 | 2021-07-05 | Trujillo Alto | Puerto Rico | 72139 | 3686 | |
1480357 | 1480357 | 2021-07-03 | Marion | Missouri | 29127 | 3686 | 53 |
1439035 | 1439035 | 2021-06-20 | Colleton | South Carolina | 45029 | 3686 | 130 |
1435788 | 1435788 | 2021-06-19 | Colleton | South Carolina | 45029 | 3686 | 130 |
1432541 | 1432541 | 2021-06-18 | Colleton | South Carolina | 45029 | 3686 | 130 |
1413066 | 1413066 | 2021-06-12 | Colleton | South Carolina | 45029 | 3686 | 129 |
1409821 | 1409821 | 2021-06-11 | Colleton | South Carolina | 45029 | 3686 | 129 |
1386954 | 1386954 | 2021-06-04 | Clinton | Pennsylvania | 42035 | 3686 | 66 |
1378373 | 1378373 | 2021-06-02 | Amador | California | 6005 | 3686 | 47 |
1375127 | 1375127 | 2021-06-01 | Amador | California | 6005 | 3686 | 47 |
1326851 | 1326851 | 2021-05-17 | Christian | Illinois | 17021 | 3686 | 91 |
1325115 | 1325115 | 2021-05-16 | Ottawa | Ohio | 39123 | 3686 | 81 |
1313994 | 1313994 | 2021-05-13 | Jasper | Indiana | 18073 | 3686 | 50 |
1246336 | 1246336 | 2021-04-22 | Delta | Michigan | 26041 | 3686 | 87 |
1239430 | 1239430 | 2021-04-20 | Lee | Iowa | 19111 | 3686 | 55 |
1174378 | 1174378 | 2021-03-31 | Miami | Indiana | 18103 | 3686 | 66 |
1130239 | 1130239 | 2021-03-17 | Crawford | Ohio | 39033 | 3686 | 99 |
1130411 | 1130411 | 2021-03-17 | Linn | Oregon | 41043 | 3686 | 58 |
1131022 | 1131022 | 2021-03-17 | Waller | Texas | 48473 | 3686 | 43 |
1112045 | 1112045 | 2021-03-12 | Boone | Arkansas | 5009 | 3686 | 77 |
1087153 | 1087153 | 2021-03-04 | Kennebec | Maine | 23011 | 3686 | 51 |
1066319 | 1066319 | 2021-02-25 | Lewis | Washington | 53041 | 3686 | 50 |
1056747 | 1056747 | 2021-02-22 | Sweetwater | Wyoming | 56037 | 3686 | 34 |
1049566 | 1049566 | 2021-02-20 | Giles | Tennessee | 47055 | 3686 | 95 |
1029602 | 1029602 | 2021-02-14 | Ashland | Ohio | 39005 | 3686 | 86 |
1022559 | 1022559 | 2021-02-12 | Camden | Missouri | 29029 | 3686 | 79 |
1008824 | 1008824 | 2021-02-08 | Montgomery | Indiana | 18107 | 3686 | 81 |
981852 | 981852 | 2021-01-30 | Manassas city | Virginia | 51683 | 3686 | 33 |
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);