ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
154 rows where cases = 3262 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 16
- Ohio 13
- Virginia 11
- Oklahoma 8
- Puerto Rico 8
- Arkansas 6
- Minnesota 6
- Missouri 5
- Texas 5
- West Virginia 5
- Alabama 4
- Georgia 4
- Indiana 4
- New Mexico 4
- New York 4
- Washington 4
- Wisconsin 4
- Illinois 3
- Louisiana 3
- Pennsylvania 3
- Tennessee 3
- Wyoming 3
- California 2
- Florida 2
- Michigan 2
- Mississippi 2
- Montana 2
- North Carolina 2
- Oregon 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494215 | 2494215 | 2022-05-11 | Madison | Louisiana | 22065 | 3262 | 59 |
2470210 | 2470210 | 2022-05-03 | Price | Wisconsin | 55099 | 3262 | 33 |
2452757 | 2452757 | 2022-04-28 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2453781 | 2453781 | 2022-04-28 | Westmoreland | Virginia | 51193 | 3262 | 51 |
2449501 | 2449501 | 2022-04-27 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2446244 | 2446244 | 2022-04-26 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2442989 | 2442989 | 2022-04-25 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2439733 | 2439733 | 2022-04-24 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2436477 | 2436477 | 2022-04-23 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2433221 | 2433221 | 2022-04-22 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2429965 | 2429965 | 2022-04-21 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2426709 | 2426709 | 2022-04-20 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2423453 | 2423453 | 2022-04-19 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2420196 | 2420196 | 2022-04-18 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2416941 | 2416941 | 2022-04-17 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2413685 | 2413685 | 2022-04-16 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2410429 | 2410429 | 2022-04-15 | McKenzie | North Dakota | 38053 | 3262 | 25 |
2336955 | 2336955 | 2022-03-24 | Little River | Arkansas | 5081 | 3262 | 93 |
2335673 | 2335673 | 2022-03-23 | Morgan | Ohio | 39115 | 3262 | 56 |
2335938 | 2335938 | 2022-03-23 | Naguabo | Puerto Rico | 72103 | 3262 | |
2332419 | 2332419 | 2022-03-22 | Morgan | Ohio | 39115 | 3262 | 56 |
2332684 | 2332684 | 2022-03-22 | Naguabo | Puerto Rico | 72103 | 3262 | |
2329166 | 2329166 | 2022-03-21 | Morgan | Ohio | 39115 | 3262 | 56 |
2329431 | 2329431 | 2022-03-21 | Naguabo | Puerto Rico | 72103 | 3262 | |
2329939 | 2329939 | 2022-03-21 | Millard | Utah | 49027 | 3262 | 35 |
2325914 | 2325914 | 2022-03-20 | Morgan | Ohio | 39115 | 3262 | 56 |
2326179 | 2326179 | 2022-03-20 | Naguabo | Puerto Rico | 72103 | 3262 | |
2322661 | 2322661 | 2022-03-19 | Morgan | Ohio | 39115 | 3262 | 56 |
2319407 | 2319407 | 2022-03-18 | Morgan | Ohio | 39115 | 3262 | 56 |
2316153 | 2316153 | 2022-03-17 | Morgan | Ohio | 39115 | 3262 | 56 |
2273564 | 2273564 | 2022-03-04 | Unknown | New Jersey | 3262 | 0 | |
2259015 | 2259015 | 2022-02-28 | Gunnison | Colorado | 8051 | 3262 | 14 |
2258537 | 2258537 | 2022-02-27 | Southampton | Virginia | 51175 | 3262 | 84 |
2255286 | 2255286 | 2022-02-26 | Southampton | Virginia | 51175 | 3262 | 84 |
2252035 | 2252035 | 2022-02-25 | Southampton | Virginia | 51175 | 3262 | 84 |
2245181 | 2245181 | 2022-02-23 | Duval | Texas | 48131 | 3262 | 67 |
2228139 | 2228139 | 2022-02-18 | Yates | New York | 36123 | 3262 | 39 |
2213066 | 2213066 | 2022-02-13 | Pacific | Washington | 53049 | 3262 | 47 |
2209813 | 2209813 | 2022-02-12 | Pacific | Washington | 53049 | 3262 | 47 |
2205529 | 2205529 | 2022-02-11 | Walsh | North Dakota | 38099 | 3262 | 34 |
2206560 | 2206560 | 2022-02-11 | Pacific | Washington | 53049 | 3262 | 47 |
2192854 | 2192854 | 2022-02-07 | Salinas | Puerto Rico | 72123 | 3262 | |
2175433 | 2175433 | 2022-02-02 | Nantucket | Massachusetts | 25019 | 3262 | 0 |
2169143 | 2169143 | 2022-01-31 | Lawrence | Mississippi | 28077 | 3262 | 45 |
2152083 | 2152083 | 2022-01-26 | Menard | Illinois | 17129 | 3262 | 22 |
2146617 | 2146617 | 2022-01-24 | Gage | Nebraska | 31067 | 3262 | 36 |
2144051 | 2144051 | 2022-01-23 | Quebradillas | Puerto Rico | 72115 | 3262 | |
2119018 | 2119018 | 2022-01-16 | Franklin | Arkansas | 5047 | 3262 | 61 |
2110323 | 2110323 | 2022-01-13 | Lincoln | Maine | 23015 | 3262 | 16 |
2112275 | 2112275 | 2022-01-13 | Taylor | West Virginia | 54091 | 3262 | 55 |
2104981 | 2104981 | 2022-01-11 | Coamo | Puerto Rico | 72043 | 3262 | |
2054292 | 2054292 | 2021-12-27 | Crisp | Georgia | 13081 | 3262 | 119 |
2040381 | 2040381 | 2021-12-22 | Lavaca | Texas | 48285 | 3262 | 100 |
1992267 | 1992267 | 2021-12-08 | Phillips | Arkansas | 5107 | 3262 | 78 |
1974933 | 1974933 | 2021-12-02 | Wyoming | Pennsylvania | 42131 | 3262 | 69 |
1927121 | 1927121 | 2021-11-18 | Fayette | Alabama | 1057 | 3262 | 85 |
1837480 | 1837480 | 2021-10-21 | Martin | Minnesota | 27091 | 3262 | 36 |
1838572 | 1838572 | 2021-10-21 | Beadle | South Dakota | 46005 | 3262 | 43 |
1835251 | 1835251 | 2021-10-20 | Rio Grande | Puerto Rico | 72119 | 3262 | |
1826983 | 1826983 | 2021-10-18 | Douglas | Illinois | 17041 | 3262 | 43 |
1810769 | 1810769 | 2021-10-13 | Lawrence | Illinois | 17101 | 3262 | 41 |
1797168 | 1797168 | 2021-10-09 | Monroe | Alabama | 1099 | 3262 | 60 |
1790417 | 1790417 | 2021-10-06 | Staunton city | Virginia | 51790 | 3262 | 79 |
1768653 | 1768653 | 2021-09-30 | Spencer | Indiana | 18147 | 3262 | 37 |
1770421 | 1770421 | 2021-09-30 | Crockett | Tennessee | 47033 | 3262 | 59 |
1771029 | 1771029 | 2021-09-30 | Wyoming | West Virginia | 54109 | 3262 | 49 |
1771060 | 1771060 | 2021-09-30 | Kewaunee | Wisconsin | 55061 | 3262 | 41 |
1754927 | 1754927 | 2021-09-26 | Marengo | Alabama | 1091 | 3262 | 85 |
1751679 | 1751679 | 2021-09-25 | Marengo | Alabama | 1091 | 3262 | 85 |
1745610 | 1745610 | 2021-09-23 | Lamar | Georgia | 13171 | 3262 | 78 |
1697930 | 1697930 | 2021-09-08 | Crawford | Missouri | 29055 | 3262 | 47 |
1670293 | 1670293 | 2021-08-30 | Mineral | West Virginia | 54057 | 3262 | 92 |
1649908 | 1649908 | 2021-08-24 | Woodward | Oklahoma | 40153 | 3262 | 38 |
1646659 | 1646659 | 2021-08-23 | Woodward | Oklahoma | 40153 | 3262 | 38 |
1643410 | 1643410 | 2021-08-22 | Woodward | Oklahoma | 40153 | 3262 | 38 |
1640160 | 1640160 | 2021-08-21 | Woodward | Oklahoma | 40153 | 3262 | 38 |
1636910 | 1636910 | 2021-08-20 | Woodward | Oklahoma | 40153 | 3262 | 38 |
1633660 | 1633660 | 2021-08-19 | Woodward | Oklahoma | 40153 | 3262 | 38 |
1630413 | 1630413 | 2021-08-18 | Woodward | Oklahoma | 40153 | 3262 | 38 |
1603969 | 1603969 | 2021-08-10 | Douglas | Nevada | 32005 | 3262 | 38 |
1597605 | 1597605 | 2021-08-08 | Washington | New York | 36115 | 3262 | 56 |
1579357 | 1579357 | 2021-08-02 | Wayne | West Virginia | 54099 | 3262 | 44 |
1575950 | 1575950 | 2021-08-01 | Isle of Wight | Virginia | 51093 | 3262 | 70 |
1572702 | 1572702 | 2021-07-31 | Isle of Wight | Virginia | 51093 | 3262 | 70 |
1569454 | 1569454 | 2021-07-30 | Isle of Wight | Virginia | 51093 | 3262 | 70 |
1535467 | 1535467 | 2021-07-20 | Scott | Mississippi | 28123 | 3262 | 74 |
1522503 | 1522503 | 2021-07-16 | Barry | Missouri | 29009 | 3262 | 48 |
1509565 | 1509565 | 2021-07-12 | Lafayette | Missouri | 29107 | 3262 | 57 |
1506319 | 1506319 | 2021-07-11 | Lafayette | Missouri | 29107 | 3262 | 57 |
1491948 | 1491948 | 2021-07-07 | Poinsett | Arkansas | 5111 | 3262 | 77 |
1477157 | 1477157 | 2021-07-02 | Warren | Missouri | 29219 | 3262 | 38 |
1477638 | 1477638 | 2021-07-02 | Guernsey | Ohio | 39059 | 3262 | 54 |
1473443 | 1473443 | 2021-07-01 | East Feliciana | Louisiana | 22037 | 3262 | 115 |
1474392 | 1474392 | 2021-07-01 | Guernsey | Ohio | 39059 | 3262 | 54 |
1469202 | 1469202 | 2021-06-30 | Jackson | Arkansas | 5067 | 3262 | 38 |
1470711 | 1470711 | 2021-06-30 | Ravalli | Montana | 30081 | 3262 | 50 |
1465957 | 1465957 | 2021-06-29 | Jackson | Arkansas | 5067 | 3262 | 38 |
1467466 | 1467466 | 2021-06-29 | Ravalli | Montana | 30081 | 3262 | 50 |
1452827 | 1452827 | 2021-06-24 | Sheridan | Wyoming | 56033 | 3262 | 31 |
1407202 | 1407202 | 2021-06-10 | Wise | Virginia | 51195 | 3262 | 102 |
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);