ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where cases = 2185 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 19
- Virginia 19
- Arkansas 17
- Texas 13
- Illinois 11
- Missouri 11
- West Virginia 11
- Indiana 10
- North Carolina 9
- Tennessee 9
- Florida 8
- Georgia 8
- North Dakota 8
- Oklahoma 8
- Iowa 7
- Maryland 7
- Kentucky 6
- Michigan 6
- Alabama 5
- Idaho 5
- Louisiana 5
- Pennsylvania 5
- Kansas 4
- Minnesota 4
- Ohio 4
- South Carolina 4
- Wyoming 4
- California 3
- Washington 3
- Wisconsin 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490083 | 2490083 | 2022-05-10 | Lincoln | Colorado | 8073 | 2185 | 9 |
2492775 | 2492775 | 2022-05-10 | Falls Church city | Virginia | 51610 | 2185 | 17 |
2476930 | 2476930 | 2022-05-06 | Nevada | Arkansas | 5099 | 2185 | 46 |
2473672 | 2473672 | 2022-05-05 | Nevada | Arkansas | 5099 | 2185 | 46 |
2470415 | 2470415 | 2022-05-04 | Nevada | Arkansas | 5099 | 2185 | 46 |
2467159 | 2467159 | 2022-05-03 | Nevada | Arkansas | 5099 | 2185 | 46 |
2463904 | 2463904 | 2022-05-02 | Nevada | Arkansas | 5099 | 2185 | 46 |
2460648 | 2460648 | 2022-05-01 | Nevada | Arkansas | 5099 | 2185 | 46 |
2457392 | 2457392 | 2022-04-30 | Nevada | Arkansas | 5099 | 2185 | 46 |
2454136 | 2454136 | 2022-04-29 | Nevada | Arkansas | 5099 | 2185 | 46 |
2450880 | 2450880 | 2022-04-28 | Nevada | Arkansas | 5099 | 2185 | 46 |
2447624 | 2447624 | 2022-04-27 | Nevada | Arkansas | 5099 | 2185 | 46 |
2444368 | 2444368 | 2022-04-26 | Nevada | Arkansas | 5099 | 2185 | 45 |
2441112 | 2441112 | 2022-04-25 | Nevada | Arkansas | 5099 | 2185 | 45 |
2437856 | 2437856 | 2022-04-24 | Nevada | Arkansas | 5099 | 2185 | 45 |
2338860 | 2338860 | 2022-03-24 | Traill | North Dakota | 38097 | 2185 | 26 |
2335606 | 2335606 | 2022-03-23 | Traill | North Dakota | 38097 | 2185 | 26 |
2332352 | 2332352 | 2022-03-22 | Traill | North Dakota | 38097 | 2185 | 26 |
2329099 | 2329099 | 2022-03-21 | Traill | North Dakota | 38097 | 2185 | 26 |
2325847 | 2325847 | 2022-03-20 | Traill | North Dakota | 38097 | 2185 | 26 |
2322594 | 2322594 | 2022-03-19 | Traill | North Dakota | 38097 | 2185 | 26 |
2319340 | 2319340 | 2022-03-18 | Traill | North Dakota | 38097 | 2185 | 26 |
2309580 | 2309580 | 2022-03-15 | Traill | North Dakota | 38097 | 2185 | 26 |
2294349 | 2294349 | 2022-03-10 | Lincoln | Washington | 53043 | 2185 | 27 |
2291097 | 2291097 | 2022-03-09 | Lincoln | Washington | 53043 | 2185 | 27 |
2274557 | 2274557 | 2022-03-04 | Ochiltree | Texas | 48357 | 2185 | 48 |
2246315 | 2246315 | 2022-02-24 | Clearwater | Idaho | 16035 | 2185 | 31 |
2243064 | 2243064 | 2022-02-23 | Clearwater | Idaho | 16035 | 2185 | 31 |
2222497 | 2222497 | 2022-02-16 | La Salle | Texas | 48283 | 2185 | 42 |
2217392 | 2217392 | 2022-02-15 | Cloud | Kansas | 20029 | 2185 | 36 |
2219246 | 2219246 | 2022-02-15 | La Salle | Texas | 48283 | 2185 | 42 |
2214141 | 2214141 | 2022-02-14 | Cloud | Kansas | 20029 | 2185 | 36 |
2211717 | 2211717 | 2022-02-13 | Phelps | Nebraska | 31137 | 2185 | 12 |
2208464 | 2208464 | 2022-02-12 | Phelps | Nebraska | 31137 | 2185 | 12 |
2205211 | 2205211 | 2022-02-11 | Phelps | Nebraska | 31137 | 2185 | 12 |
2178026 | 2178026 | 2022-02-03 | Franklin | Idaho | 16041 | 2185 | 27 |
2153028 | 2153028 | 2022-01-26 | Wayne | Missouri | 29223 | 2185 | 42 |
2150684 | 2150684 | 2022-01-25 | Roberts | South Dakota | 46109 | 2185 | 45 |
2128363 | 2128363 | 2022-01-18 | Franklin city | Virginia | 51620 | 2185 | 43 |
2119595 | 2119595 | 2022-01-16 | Brown | Indiana | 18013 | 2185 | 56 |
2121918 | 2121918 | 2022-01-16 | Richmond | Virginia | 51159 | 2185 | 17 |
2116343 | 2116343 | 2022-01-15 | Brown | Indiana | 18013 | 2185 | 56 |
2118666 | 2118666 | 2022-01-15 | Richmond | Virginia | 51159 | 2185 | 17 |
2113092 | 2113092 | 2022-01-14 | Brown | Indiana | 18013 | 2185 | 56 |
2115414 | 2115414 | 2022-01-14 | Richmond | Virginia | 51159 | 2185 | 17 |
2076591 | 2076591 | 2022-01-02 | Big Horn | Wyoming | 56003 | 2185 | 58 |
2073340 | 2073340 | 2022-01-01 | Big Horn | Wyoming | 56003 | 2185 | 58 |
2070089 | 2070089 | 2021-12-31 | Big Horn | Wyoming | 56003 | 2185 | 58 |
2066838 | 2066838 | 2021-12-30 | Big Horn | Wyoming | 56003 | 2185 | 58 |
2006290 | 2006290 | 2021-12-12 | West Carroll | Louisiana | 22123 | 2185 | 52 |
2003039 | 2003039 | 2021-12-11 | West Carroll | Louisiana | 22123 | 2185 | 52 |
1999789 | 1999789 | 2021-12-10 | West Carroll | Louisiana | 22123 | 2185 | 52 |
1988024 | 1988024 | 2021-12-06 | Bamberg | South Carolina | 45009 | 2185 | 64 |
1981222 | 1981222 | 2021-12-04 | Morgan | Ohio | 39115 | 2185 | 39 |
1963000 | 1963000 | 2021-11-29 | Lee | Arkansas | 5077 | 2185 | 52 |
1929452 | 1929452 | 2021-11-18 | Fajardo | Puerto Rico | 72053 | 2185 | |
1923724 | 1923724 | 2021-11-16 | Monroe | West Virginia | 54063 | 2185 | 26 |
1920364 | 1920364 | 2021-11-15 | Patrick | Virginia | 51141 | 2185 | 58 |
1910726 | 1910726 | 2021-11-12 | Morgan | West Virginia | 54065 | 2185 | 47 |
1903788 | 1903788 | 2021-11-10 | Eastland | Texas | 48133 | 2185 | 78 |
1900538 | 1900538 | 2021-11-09 | Eastland | Texas | 48133 | 2185 | 78 |
1882179 | 1882179 | 2021-11-04 | Idaho | Idaho | 16049 | 2185 | 36 |
1878779 | 1878779 | 2021-11-03 | Dade | Georgia | 13083 | 2185 | 21 |
1872545 | 1872545 | 2021-11-01 | Wabash | Illinois | 17185 | 2185 | 22 |
1847423 | 1847423 | 2021-10-24 | Mississippi | Missouri | 29133 | 2185 | 39 |
1844173 | 1844173 | 2021-10-23 | Mississippi | Missouri | 29133 | 2185 | 39 |
1839316 | 1839316 | 2021-10-21 | Rusk | Wisconsin | 55107 | 2185 | 33 |
1835838 | 1835838 | 2021-10-20 | Greene | Virginia | 51079 | 2185 | 34 |
1830644 | 1830644 | 2021-10-19 | Estill | Kentucky | 21065 | 2185 | 12 |
1830959 | 1830959 | 2021-10-19 | Faribault | Minnesota | 27043 | 2185 | 30 |
1832532 | 1832532 | 2021-10-19 | Windham | Vermont | 50025 | 2185 | 24 |
1786014 | 1786014 | 2021-10-05 | Schoharie | New York | 36095 | 2185 | 21 |
1781659 | 1781659 | 2021-10-04 | Tipton | Indiana | 18159 | 2185 | 59 |
1762423 | 1762423 | 2021-09-28 | Green | Kentucky | 21087 | 2185 | 29 |
1763582 | 1763582 | 2021-09-28 | Okfuskee | Oklahoma | 40107 | 2185 | 33 |
1759175 | 1759175 | 2021-09-27 | Green | Kentucky | 21087 | 2185 | 29 |
1759656 | 1759656 | 2021-09-27 | Dallas | Missouri | 29059 | 2185 | 40 |
1760333 | 1760333 | 2021-09-27 | Okfuskee | Oklahoma | 40107 | 2185 | 33 |
1756408 | 1756408 | 2021-09-26 | Dallas | Missouri | 29059 | 2185 | 40 |
1757085 | 1757085 | 2021-09-26 | Okfuskee | Oklahoma | 40107 | 2185 | 33 |
1753837 | 1753837 | 2021-09-25 | Okfuskee | Oklahoma | 40107 | 2185 | 33 |
1749912 | 1749912 | 2021-09-24 | Dallas | Missouri | 29059 | 2185 | 40 |
1750589 | 1750589 | 2021-09-24 | Okfuskee | Oklahoma | 40107 | 2185 | 33 |
1747339 | 1747339 | 2021-09-23 | Okfuskee | Oklahoma | 40107 | 2185 | 33 |
1744090 | 1744090 | 2021-09-22 | Okfuskee | Oklahoma | 40107 | 2185 | 33 |
1740401 | 1740401 | 2021-09-21 | York | Nebraska | 31185 | 2185 | 16 |
1740635 | 1740635 | 2021-09-21 | Warren | North Carolina | 37185 | 2185 | 24 |
1730448 | 1730448 | 2021-09-18 | Madison | Missouri | 29123 | 2185 | 19 |
1700008 | 1700008 | 2021-09-09 | Jefferson | Florida | 12065 | 2185 | 28 |
1696759 | 1696759 | 2021-09-08 | Jefferson | Florida | 12065 | 2185 | 28 |
1693511 | 1693511 | 2021-09-07 | Jefferson | Florida | 12065 | 2185 | 28 |
1690262 | 1690262 | 2021-09-06 | Jefferson | Florida | 12065 | 2185 | 28 |
1692239 | 1692239 | 2021-09-06 | Wyoming | Pennsylvania | 42131 | 2185 | 54 |
1687012 | 1687012 | 2021-09-05 | Jefferson | Florida | 12065 | 2185 | 28 |
1683762 | 1683762 | 2021-09-04 | Jefferson | Florida | 12065 | 2185 | 28 |
1680511 | 1680511 | 2021-09-03 | Jefferson | Florida | 12065 | 2185 | 28 |
1672306 | 1672306 | 2021-08-31 | Seneca | New York | 36099 | 2185 | 57 |
1648561 | 1648561 | 2021-08-24 | Tama | Iowa | 19171 | 2185 | 72 |
1645143 | 1645143 | 2021-08-23 | Carroll | Indiana | 18015 | 2185 | 26 |
1645313 | 1645313 | 2021-08-23 | Tama | Iowa | 19171 | 2185 | 72 |
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);