ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 4919 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Iowa 15
- Georgia 14
- Kentucky 8
- Texas 6
- Virginia 6
- Alaska 5
- Indiana 5
- Ohio 5
- Washington 5
- New York 4
- Puerto Rico 4
- Arkansas 3
- California 3
- North Carolina 3
- Wisconsin 3
- Idaho 2
- Oklahoma 2
- South Dakota 2
- West Virginia 2
- Colorado 1
- Florida 1
- Hawaii 1
- Maine 1
- Maryland 1
- Minnesota 1
- Missouri 1
- New Hampshire 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496467 | 2496467 | 2022-05-12 | Lincoln | Arkansas | 5079 | 4919 | 68 |
2493209 | 2493209 | 2022-05-11 | Lincoln | Arkansas | 5079 | 4919 | 68 |
2489951 | 2489951 | 2022-05-10 | Lincoln | Arkansas | 5079 | 4919 | 68 |
2470066 | 2470066 | 2022-05-03 | Adams | Washington | 53001 | 4919 | 38 |
2466810 | 2466810 | 2022-05-02 | Adams | Washington | 53001 | 4919 | 38 |
2463555 | 2463555 | 2022-05-01 | Adams | Washington | 53001 | 4919 | 38 |
2460299 | 2460299 | 2022-04-30 | Adams | Washington | 53001 | 4919 | 38 |
2457043 | 2457043 | 2022-04-29 | Adams | Washington | 53001 | 4919 | 38 |
2414000 | 2414000 | 2022-04-16 | Camuy | Puerto Rico | 72027 | 4919 | |
2410744 | 2410744 | 2022-04-15 | Camuy | Puerto Rico | 72027 | 4919 | |
2407488 | 2407488 | 2022-04-14 | Camuy | Puerto Rico | 72027 | 4919 | |
2381890 | 2381890 | 2022-04-06 | Milam | Texas | 48331 | 4919 | 101 |
2375919 | 2375919 | 2022-04-05 | Kodiak Island Borough | Alaska | 2150 | 4919 | 12 |
2376650 | 2376650 | 2022-04-05 | Carroll | Iowa | 19027 | 4919 | 65 |
2378635 | 2378635 | 2022-04-05 | Milam | Texas | 48331 | 4919 | 101 |
2372667 | 2372667 | 2022-04-04 | Kodiak Island Borough | Alaska | 2150 | 4919 | 12 |
2373398 | 2373398 | 2022-04-04 | Carroll | Iowa | 19027 | 4919 | 65 |
2375381 | 2375381 | 2022-04-04 | Milam | Texas | 48331 | 4919 | 101 |
2369414 | 2369414 | 2022-04-03 | Kodiak Island Borough | Alaska | 2150 | 4919 | 12 |
2370145 | 2370145 | 2022-04-03 | Carroll | Iowa | 19027 | 4919 | 65 |
2372129 | 2372129 | 2022-04-03 | Milam | Texas | 48331 | 4919 | 101 |
2366161 | 2366161 | 2022-04-02 | Kodiak Island Borough | Alaska | 2150 | 4919 | 12 |
2366892 | 2366892 | 2022-04-02 | Carroll | Iowa | 19027 | 4919 | 65 |
2362908 | 2362908 | 2022-04-01 | Kodiak Island Borough | Alaska | 2150 | 4919 | 12 |
2363639 | 2363639 | 2022-04-01 | Carroll | Iowa | 19027 | 4919 | 65 |
2360385 | 2360385 | 2022-03-31 | Carroll | Iowa | 19027 | 4919 | 65 |
2357131 | 2357131 | 2022-03-30 | Carroll | Iowa | 19027 | 4919 | 65 |
2290985 | 2290985 | 2022-03-09 | Fluvanna | Virginia | 51065 | 4919 | 42 |
2286652 | 2286652 | 2022-03-08 | Schoharie | New York | 36095 | 4919 | 34 |
2283400 | 2283400 | 2022-03-07 | Schoharie | New York | 36095 | 4919 | 34 |
2257880 | 2257880 | 2022-02-27 | Naranjito | Puerto Rico | 72105 | 4919 | |
2250185 | 2250185 | 2022-02-25 | Lincoln | Maine | 23015 | 4919 | 29 |
2232137 | 2232137 | 2022-02-19 | Burleson | Texas | 48051 | 4919 | 65 |
2212813 | 2212813 | 2022-02-13 | Scurry | Texas | 48415 | 4919 | 100 |
2179369 | 2179369 | 2022-02-03 | Caswell | North Carolina | 37033 | 4919 | 39 |
2174790 | 2174790 | 2022-02-02 | Payette | Idaho | 16075 | 4919 | 78 |
2157861 | 2157861 | 2022-01-27 | Langlade | Wisconsin | 55067 | 4919 | 69 |
2151163 | 2151163 | 2022-01-25 | Lee | Virginia | 51105 | 4919 | 72 |
2099573 | 2099573 | 2022-01-10 | Glenn | California | 6021 | 4919 | 55 |
2085051 | 2085051 | 2022-01-05 | Dare | North Carolina | 37055 | 4919 | 15 |
2059613 | 2059613 | 2021-12-28 | Lawrence | South Dakota | 46081 | 4919 | 74 |
2051705 | 2051705 | 2021-12-26 | Ohio | Kentucky | 21183 | 4919 | 89 |
2048455 | 2048455 | 2021-12-25 | Ohio | Kentucky | 21183 | 4919 | 89 |
2045205 | 2045205 | 2021-12-24 | Ohio | Kentucky | 21183 | 4919 | 89 |
2041956 | 2041956 | 2021-12-23 | Ohio | Kentucky | 21183 | 4919 | 89 |
2038706 | 2038706 | 2021-12-22 | Ohio | Kentucky | 21183 | 4919 | 89 |
2019197 | 2019197 | 2021-12-16 | Montgomery | Kentucky | 21173 | 4919 | 69 |
2020254 | 2020254 | 2021-12-16 | Van Wert | Ohio | 39161 | 4919 | 100 |
1986396 | 1986396 | 2021-12-06 | Wells | Indiana | 18179 | 4919 | 108 |
1960145 | 1960145 | 2021-11-28 | White | Georgia | 13311 | 4919 | 132 |
1956894 | 1956894 | 2021-11-27 | White | Georgia | 13311 | 4919 | 132 |
1953643 | 1953643 | 2021-11-26 | White | Georgia | 13311 | 4919 | 132 |
1950392 | 1950392 | 2021-11-25 | White | Georgia | 13311 | 4919 | 132 |
1947141 | 1947141 | 2021-11-24 | White | Georgia | 13311 | 4919 | 132 |
1906229 | 1906229 | 2021-11-11 | Otsego | New York | 36077 | 4919 | 57 |
1853061 | 1853061 | 2021-10-26 | Adams | Indiana | 18001 | 4919 | 77 |
1853163 | 1853163 | 2021-10-26 | Buena Vista | Iowa | 19021 | 4919 | 46 |
1849914 | 1849914 | 2021-10-25 | Buena Vista | Iowa | 19021 | 4919 | 46 |
1846664 | 1846664 | 2021-10-24 | Buena Vista | Iowa | 19021 | 4919 | 46 |
1848883 | 1848883 | 2021-10-24 | Prince George | Virginia | 51149 | 4919 | 41 |
1843414 | 1843414 | 2021-10-23 | Buena Vista | Iowa | 19021 | 4919 | 46 |
1845633 | 1845633 | 2021-10-23 | Prince George | Virginia | 51149 | 4919 | 41 |
1840164 | 1840164 | 2021-10-22 | Buena Vista | Iowa | 19021 | 4919 | 46 |
1842383 | 1842383 | 2021-10-22 | Prince George | Virginia | 51149 | 4919 | 41 |
1836915 | 1836915 | 2021-10-21 | Buena Vista | Iowa | 19021 | 4919 | 46 |
1833666 | 1833666 | 2021-10-20 | Buena Vista | Iowa | 19021 | 4919 | 46 |
1814139 | 1814139 | 2021-10-14 | Ripley | Indiana | 18137 | 4919 | 85 |
1767094 | 1767094 | 2021-09-29 | Brookings | South Dakota | 46011 | 4919 | 37 |
1759987 | 1759987 | 2021-09-27 | Cortland | New York | 36023 | 4919 | 71 |
1747386 | 1747386 | 2021-09-23 | Malheur | Oregon | 41045 | 4919 | 67 |
1704979 | 1704979 | 2021-09-10 | Clinton | Ohio | 39027 | 4919 | 74 |
1618840 | 1618840 | 2021-08-15 | Baldwin | Georgia | 13009 | 4919 | 137 |
1615592 | 1615592 | 2021-08-14 | Baldwin | Georgia | 13009 | 4919 | 137 |
1612343 | 1612343 | 2021-08-13 | Baldwin | Georgia | 13009 | 4919 | 137 |
1595945 | 1595945 | 2021-08-08 | Tuolumne | California | 6109 | 4919 | 73 |
1586373 | 1586373 | 2021-08-05 | Chattahoochee | Georgia | 13053 | 4919 | 17 |
1495585 | 1495585 | 2021-07-08 | Maui | Hawaii | 15009 | 4919 | 57 |
1440067 | 1440067 | 2021-06-21 | Nevada | California | 6057 | 4919 | 75 |
1402899 | 1402899 | 2021-06-09 | Watauga | North Carolina | 37189 | 4919 | 31 |
1332611 | 1332611 | 2021-05-18 | Mercer | West Virginia | 54055 | 4919 | 116 |
1311097 | 1311097 | 2021-05-12 | Nelson | Kentucky | 21179 | 4919 | 55 |
1307879 | 1307879 | 2021-05-11 | Whitley | Kentucky | 21235 | 4919 | 56 |
1308826 | 1308826 | 2021-05-11 | Auglaize | Ohio | 39011 | 4919 | 84 |
1261803 | 1261803 | 2021-04-27 | Murray | Georgia | 13213 | 4919 | 84 |
1258556 | 1258556 | 2021-04-26 | Murray | Georgia | 13213 | 4919 | 84 |
1228758 | 1228758 | 2021-04-16 | Dunn | Wisconsin | 55033 | 4919 | 32 |
1171924 | 1171924 | 2021-03-30 | Johnson | Missouri | 29101 | 4919 | 49 |
1114028 | 1114028 | 2021-03-12 | Huron | Ohio | 39077 | 4919 | 109 |
1105305 | 1105305 | 2021-03-09 | Harrison | West Virginia | 54033 | 4919 | 70 |
1021860 | 1021860 | 2021-02-12 | Cerro Gordo | Iowa | 19033 | 4919 | 79 |
1023187 | 1023187 | 2021-02-12 | Union | Ohio | 39159 | 4919 | 43 |
1002335 | 1002335 | 2021-02-06 | Noble | Indiana | 18113 | 4919 | 73 |
984286 | 984286 | 2021-01-31 | Le Flore | Oklahoma | 40079 | 4919 | 39 |
966349 | 966349 | 2021-01-26 | Laurens | Georgia | 13175 | 4919 | 134 |
939098 | 939098 | 2021-01-17 | Georgetown | South Carolina | 45043 | 4919 | 103 |
920704 | 920704 | 2021-01-12 | Fremont | Colorado | 8043 | 4919 | 28 |
904185 | 904185 | 2021-01-06 | Waupaca | Wisconsin | 55135 | 4919 | 137 |
869236 | 869236 | 2020-12-27 | Floyd | Indiana | 18043 | 4919 | 97 |
837264 | 837264 | 2020-12-17 | Allegany | Maryland | 24001 | 4919 | 128 |
826911 | 826911 | 2020-12-14 | Madison | Idaho | 16065 | 4919 | 10 |
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);