ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
165 rows where cases = 3447 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Iowa 14
- Georgia 9
- Indiana 8
- North Carolina 8
- Puerto Rico 7
- Wisconsin 7
- Idaho 6
- Kentucky 6
- Ohio 6
- Virginia 6
- Arkansas 5
- Minnesota 5
- Mississippi 5
- Alabama 4
- Michigan 4
- Missouri 4
- New Mexico 4
- Washington 4
- Florida 3
- Illinois 3
- Louisiana 3
- Nebraska 3
- New York 3
- Tennessee 3
- California 2
- Maryland 2
- Oklahoma 2
- Pennsylvania 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471495 | 2471495 | 2022-05-04 | Nantucket | Massachusetts | 25019 | 3447 | 0 |
2445076 | 2445076 | 2022-04-26 | O'Brien | Iowa | 19141 | 3447 | 71 |
2441820 | 2441820 | 2022-04-25 | O'Brien | Iowa | 19141 | 3447 | 71 |
2438564 | 2438564 | 2022-04-24 | O'Brien | Iowa | 19141 | 3447 | 71 |
2435308 | 2435308 | 2022-04-23 | O'Brien | Iowa | 19141 | 3447 | 71 |
2436787 | 2436787 | 2022-04-23 | Barceloneta | Puerto Rico | 72017 | 3447 | |
2432052 | 2432052 | 2022-04-22 | O'Brien | Iowa | 19141 | 3447 | 71 |
2428796 | 2428796 | 2022-04-21 | O'Brien | Iowa | 19141 | 3447 | 71 |
2425540 | 2425540 | 2022-04-20 | O'Brien | Iowa | 19141 | 3447 | 71 |
2422284 | 2422284 | 2022-04-19 | O'Brien | Iowa | 19141 | 3447 | 71 |
2419028 | 2419028 | 2022-04-18 | O'Brien | Iowa | 19141 | 3447 | 71 |
2415772 | 2415772 | 2022-04-17 | O'Brien | Iowa | 19141 | 3447 | 71 |
2412516 | 2412516 | 2022-04-16 | O'Brien | Iowa | 19141 | 3447 | 71 |
2409260 | 2409260 | 2022-04-15 | O'Brien | Iowa | 19141 | 3447 | 71 |
2406004 | 2406004 | 2022-04-14 | O'Brien | Iowa | 19141 | 3447 | 71 |
2402748 | 2402748 | 2022-04-13 | O'Brien | Iowa | 19141 | 3447 | 71 |
2384749 | 2384749 | 2022-04-07 | Salinas | Puerto Rico | 72123 | 3447 | |
2354961 | 2354961 | 2022-03-29 | Schuyler | New York | 36097 | 3447 | 25 |
2355940 | 2355940 | 2022-03-29 | Wilbarger | Texas | 48487 | 3447 | 86 |
2352687 | 2352687 | 2022-03-28 | Wilbarger | Texas | 48487 | 3447 | 86 |
2349435 | 2349435 | 2022-03-27 | Wilbarger | Texas | 48487 | 3447 | 86 |
2346182 | 2346182 | 2022-03-26 | Wilbarger | Texas | 48487 | 3447 | 86 |
2319683 | 2319683 | 2022-03-18 | San German | Puerto Rico | 72125 | 3447 | |
2304455 | 2304455 | 2022-03-14 | Van Buren | Arkansas | 5141 | 3447 | 61 |
2301203 | 2301203 | 2022-03-13 | Van Buren | Arkansas | 5141 | 3447 | 61 |
2303014 | 2303014 | 2022-03-13 | Swain | North Carolina | 37173 | 3447 | 38 |
2304103 | 2304103 | 2022-03-13 | Klickitat | Washington | 53039 | 3447 | 43 |
2299762 | 2299762 | 2022-03-12 | Swain | North Carolina | 37173 | 3447 | 38 |
2300851 | 2300851 | 2022-03-12 | Klickitat | Washington | 53039 | 3447 | 43 |
2296510 | 2296510 | 2022-03-11 | Swain | North Carolina | 37173 | 3447 | 38 |
2297599 | 2297599 | 2022-03-11 | Klickitat | Washington | 53039 | 3447 | 43 |
2293385 | 2293385 | 2022-03-10 | Monroe | Ohio | 39111 | 3447 | 79 |
2267586 | 2267586 | 2022-03-02 | Anasco | Puerto Rico | 72011 | 3447 | |
2167753 | 2167753 | 2022-01-31 | Washington | Alabama | 1129 | 3447 | 53 |
2166198 | 2166198 | 2022-01-30 | York | Nebraska | 31185 | 3447 | 19 |
2162943 | 2162943 | 2022-01-29 | York | Nebraska | 31185 | 3447 | 19 |
2159688 | 2159688 | 2022-01-28 | York | Nebraska | 31185 | 3447 | 19 |
2160301 | 2160301 | 2022-01-28 | Lares | Puerto Rico | 72081 | 3447 | |
2142249 | 2142249 | 2022-01-23 | Minidoka | Idaho | 16067 | 3447 | 55 |
2138994 | 2138994 | 2022-01-22 | Minidoka | Idaho | 16067 | 3447 | 55 |
2086562 | 2086562 | 2022-01-06 | Colusa | California | 6011 | 3447 | 21 |
2044157 | 2044157 | 2021-12-24 | Marengo | Alabama | 1091 | 3447 | 93 |
2040185 | 2040185 | 2021-12-22 | Humphreys | Tennessee | 47085 | 3447 | 52 |
2036285 | 2036285 | 2021-12-21 | Caswell | North Carolina | 37033 | 3447 | 39 |
2008848 | 2008848 | 2021-12-13 | Mitchell | Georgia | 13205 | 3447 | 101 |
2005597 | 2005597 | 2021-12-12 | Mitchell | Georgia | 13205 | 3447 | 101 |
2002346 | 2002346 | 2021-12-11 | Mitchell | Georgia | 13205 | 3447 | 101 |
2003901 | 2003901 | 2021-12-11 | Rolette | North Dakota | 38079 | 3447 | 36 |
1999096 | 1999096 | 2021-12-10 | Mitchell | Georgia | 13205 | 3447 | 101 |
1992031 | 1992031 | 2021-12-07 | Green Lake | Wisconsin | 55047 | 3447 | 36 |
1988780 | 1988780 | 2021-12-06 | Green Lake | Wisconsin | 55047 | 3447 | 36 |
1985530 | 1985530 | 2021-12-05 | Green Lake | Wisconsin | 55047 | 3447 | 36 |
1982280 | 1982280 | 2021-12-04 | Green Lake | Wisconsin | 55047 | 3447 | 36 |
1979030 | 1979030 | 2021-12-03 | Green Lake | Wisconsin | 55047 | 3447 | 36 |
1931922 | 1931922 | 2021-11-19 | Perry | Missouri | 29157 | 3447 | 40 |
1910279 | 1910279 | 2021-11-12 | Deaf Smith | Texas | 48117 | 3447 | 84 |
1907030 | 1907030 | 2021-11-11 | Deaf Smith | Texas | 48117 | 3447 | 82 |
1900757 | 1900757 | 2021-11-09 | Bennington | Vermont | 50003 | 3447 | 28 |
1892658 | 1892658 | 2021-11-07 | Otsego | Michigan | 26137 | 3447 | 60 |
1889408 | 1889408 | 2021-11-06 | Otsego | Michigan | 26137 | 3447 | 60 |
1886158 | 1886158 | 2021-11-05 | Otsego | Michigan | 26137 | 3447 | 60 |
1826472 | 1826472 | 2021-10-18 | Arkansas | Arkansas | 5001 | 3447 | 59 |
1823223 | 1823223 | 2021-10-17 | Arkansas | Arkansas | 5001 | 3447 | 59 |
1824163 | 1824163 | 2021-10-17 | Hart | Kentucky | 21099 | 3447 | 61 |
1820914 | 1820914 | 2021-10-16 | Hart | Kentucky | 21099 | 3447 | 61 |
1817665 | 1817665 | 2021-10-15 | Hart | Kentucky | 21099 | 3447 | 61 |
1802238 | 1802238 | 2021-10-10 | Lewis | New York | 36049 | 3447 | 38 |
1791414 | 1791414 | 2021-10-07 | Washington | Indiana | 18175 | 3447 | 47 |
1785890 | 1785890 | 2021-10-05 | Churchill | Nevada | 32001 | 3447 | 58 |
1757594 | 1757594 | 2021-09-26 | Gonzales | Texas | 48177 | 3447 | 73 |
1754346 | 1754346 | 2021-09-25 | Gonzales | Texas | 48177 | 3447 | 73 |
1751098 | 1751098 | 2021-09-24 | Gonzales | Texas | 48177 | 3447 | 73 |
1747849 | 1747849 | 2021-09-23 | Gonzales | Texas | 48177 | 3447 | 73 |
1739210 | 1739210 | 2021-09-21 | Cassia | Idaho | 16031 | 3447 | 29 |
1740004 | 1740004 | 2021-09-21 | Le Sueur | Minnesota | 27079 | 3447 | 29 |
1740725 | 1740725 | 2021-09-21 | Gallia | Ohio | 39053 | 3447 | 56 |
1741613 | 1741613 | 2021-09-21 | Gloucester | Virginia | 51073 | 3447 | 56 |
1723133 | 1723133 | 2021-09-16 | Jennings | Indiana | 18079 | 3447 | 58 |
1723724 | 1723724 | 2021-09-16 | Brown | Minnesota | 27015 | 3447 | 43 |
1700061 | 1700061 | 2021-09-09 | Burke | Georgia | 13033 | 3447 | 68 |
1696284 | 1696284 | 2021-09-07 | Mineral | West Virginia | 54057 | 3447 | 92 |
1651646 | 1651646 | 2021-08-25 | Daviess | Indiana | 18027 | 3447 | 104 |
1649108 | 1649108 | 2021-08-24 | Coahoma | Mississippi | 28027 | 3447 | 89 |
1637063 | 1637063 | 2021-08-20 | Mayaguez | Puerto Rico | 72097 | 3447 | |
1610083 | 1610083 | 2021-08-12 | Pine | Minnesota | 27115 | 3447 | 23 |
1584537 | 1584537 | 2021-08-04 | Luna | New Mexico | 35029 | 3447 | 92 |
1574927 | 1574927 | 2021-08-01 | Montgomery | North Carolina | 37123 | 3447 | 97 |
1571679 | 1571679 | 2021-07-31 | Montgomery | North Carolina | 37123 | 3447 | 97 |
1568431 | 1568431 | 2021-07-30 | Montgomery | North Carolina | 37123 | 3447 | 97 |
1435429 | 1435429 | 2021-06-19 | Champaign | Ohio | 39021 | 3447 | 59 |
1373574 | 1373574 | 2021-05-31 | Otsego | New York | 36077 | 3447 | 47 |
1366754 | 1366754 | 2021-05-29 | Lawrence | Missouri | 29109 | 3447 | 86 |
1362142 | 1362142 | 2021-05-28 | Yell | Arkansas | 5149 | 3447 | 65 |
1356812 | 1356812 | 2021-05-26 | Freeborn | Minnesota | 27047 | 3447 | 30 |
1357706 | 1357706 | 2021-05-26 | Josephine | Oregon | 41033 | 3447 | 71 |
1351117 | 1351117 | 2021-05-24 | Williams | Ohio | 39171 | 3447 | 77 |
1343512 | 1343512 | 2021-05-22 | Floyd | Kentucky | 21071 | 3447 | 69 |
1338853 | 1338853 | 2021-05-20 | Wood | Texas | 48499 | 3447 | 128 |
1335606 | 1335606 | 2021-05-19 | Wood | Texas | 48499 | 3447 | 128 |
1332359 | 1332359 | 2021-05-18 | Wood | Texas | 48499 | 3447 | 128 |
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);