ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
323 rows where cases = 1445 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 33
- Georgia 19
- Puerto Rico 19
- Virginia 18
- Mississippi 15
- Missouri 13
- Texas 13
- Arkansas 12
- Illinois 12
- Iowa 12
- Kansas 11
- Florida 10
- Minnesota 9
- Wisconsin 8
- Colorado 7
- South Carolina 7
- Alabama 6
- Indiana 6
- North Carolina 6
- South Dakota 6
- Tennessee 6
- West Virginia 6
- California 5
- Louisiana 5
- Maine 5
- Montana 5
- New York 5
- North Dakota 5
- Washington 5
- Alaska 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450993 | 2450993 | 2022-04-28 | Huerfano | Colorado | 8055 | 1445 | 33 |
2447737 | 2447737 | 2022-04-27 | Huerfano | Colorado | 8055 | 1445 | 33 |
2444481 | 2444481 | 2022-04-26 | Huerfano | Colorado | 8055 | 1445 | 33 |
2444970 | 2444970 | 2022-04-26 | Ohio | Indiana | 18115 | 1445 | 19 |
2441225 | 2441225 | 2022-04-25 | Huerfano | Colorado | 8055 | 1445 | 33 |
2441714 | 2441714 | 2022-04-25 | Ohio | Indiana | 18115 | 1445 | 19 |
2421172 | 2421172 | 2022-04-18 | Mathews | Virginia | 51115 | 1445 | 28 |
2335914 | 2335914 | 2022-03-23 | Guanica | Puerto Rico | 72055 | 1445 | |
2294045 | 2294045 | 2022-03-10 | Lynn | Texas | 48305 | 1445 | 37 |
2242329 | 2242329 | 2022-02-22 | Skamania | Washington | 53059 | 1445 | 10 |
2239078 | 2239078 | 2022-02-21 | Skamania | Washington | 53059 | 1445 | 10 |
2235827 | 2235827 | 2022-02-20 | Skamania | Washington | 53059 | 1445 | 10 |
2232576 | 2232576 | 2022-02-19 | Skamania | Washington | 53059 | 1445 | 10 |
2229325 | 2229325 | 2022-02-18 | Skamania | Washington | 53059 | 1445 | 10 |
2214611 | 2214611 | 2022-02-14 | Norman | Minnesota | 27107 | 1445 | 13 |
2200291 | 2200291 | 2022-02-10 | Dillingham Census Area | Alaska | 2070 | 1445 | 11 |
2197037 | 2197037 | 2022-02-09 | Dillingham Census Area | Alaska | 2070 | 1445 | 11 |
2199008 | 2199008 | 2022-02-09 | Ransom | North Dakota | 38073 | 1445 | 26 |
2199711 | 2199711 | 2022-02-09 | Jack | Texas | 48237 | 1445 | 25 |
2195432 | 2195432 | 2022-02-08 | Keith | Nebraska | 31101 | 1445 | 14 |
2171197 | 2171197 | 2022-02-01 | Clear Creek | Colorado | 8019 | 1445 | 10 |
2155203 | 2155203 | 2022-01-27 | Twiggs | Georgia | 13289 | 1445 | 62 |
2125817 | 2125817 | 2022-01-18 | Crawford | Georgia | 13079 | 1445 | 48 |
2124958 | 2124958 | 2022-01-17 | Refugio | Texas | 48391 | 1445 | 31 |
2058140 | 2058140 | 2021-12-28 | Crittenden | Kentucky | 21055 | 1445 | 37 |
2059054 | 2059054 | 2021-12-28 | Graham | North Carolina | 37075 | 1445 | 28 |
2035335 | 2035335 | 2021-12-21 | Pratt | Kansas | 20151 | 1445 | 29 |
2032085 | 2032085 | 2021-12-20 | Pratt | Kansas | 20151 | 1445 | 29 |
2032955 | 2032955 | 2021-12-20 | Sierra | New Mexico | 35051 | 1445 | 62 |
2029227 | 2029227 | 2021-12-19 | Lake | Minnesota | 27075 | 1445 | 26 |
2030315 | 2030315 | 2021-12-19 | McCormick | South Carolina | 45065 | 1445 | 30 |
2025976 | 2025976 | 2021-12-18 | Lake | Minnesota | 27075 | 1445 | 26 |
2027064 | 2027064 | 2021-12-18 | McCormick | South Carolina | 45065 | 1445 | 30 |
2022725 | 2022725 | 2021-12-17 | Lake | Minnesota | 27075 | 1445 | 26 |
2023813 | 2023813 | 2021-12-17 | McCormick | South Carolina | 45065 | 1445 | 30 |
2019142 | 2019142 | 2021-12-16 | Elliott | Kentucky | 21063 | 1445 | 13 |
1993133 | 1993133 | 2021-12-08 | Cumberland | Kentucky | 21057 | 1445 | 22 |
1989882 | 1989882 | 2021-12-07 | Cumberland | Kentucky | 21057 | 1445 | 22 |
1988547 | 1988547 | 2021-12-06 | Buena Vista city | Virginia | 51530 | 1445 | 28 |
1967033 | 1967033 | 2021-11-30 | Grant | Kansas | 20067 | 1445 | 30 |
1963781 | 1963781 | 2021-11-29 | Grant | Kansas | 20067 | 1445 | 30 |
1961954 | 1961954 | 2021-11-28 | Coamo | Puerto Rico | 72043 | 1445 | |
1962088 | 1962088 | 2021-11-28 | Grant | South Dakota | 46051 | 1445 | 46 |
1958703 | 1958703 | 2021-11-27 | Coamo | Puerto Rico | 72043 | 1445 | |
1958837 | 1958837 | 2021-11-27 | Grant | South Dakota | 46051 | 1445 | 46 |
1955452 | 1955452 | 2021-11-26 | Coamo | Puerto Rico | 72043 | 1445 | |
1955586 | 1955586 | 2021-11-26 | Grant | South Dakota | 46051 | 1445 | 46 |
1952335 | 1952335 | 2021-11-25 | Grant | South Dakota | 46051 | 1445 | 46 |
1949084 | 1949084 | 2021-11-24 | Grant | South Dakota | 46051 | 1445 | 46 |
1944795 | 1944795 | 2021-11-23 | Kemper | Mississippi | 28069 | 1445 | 41 |
1941190 | 1941190 | 2021-11-22 | Owen | Kentucky | 21187 | 1445 | 28 |
1941544 | 1941544 | 2021-11-22 | Kemper | Mississippi | 28069 | 1445 | 41 |
1936731 | 1936731 | 2021-11-20 | Pleasants | West Virginia | 54073 | 1445 | 30 |
1923186 | 1923186 | 2021-11-16 | Moore | Tennessee | 47127 | 1445 | 22 |
1919937 | 1919937 | 2021-11-15 | Moore | Tennessee | 47127 | 1445 | 22 |
1909989 | 1909989 | 2021-11-12 | Salinas | Puerto Rico | 72123 | 1445 | |
1905006 | 1905006 | 2021-11-11 | Marshall | Illinois | 17123 | 1445 | 25 |
1905339 | 1905339 | 2021-11-11 | Thomas | Kansas | 20193 | 1445 | 22 |
1901756 | 1901756 | 2021-11-10 | Marshall | Illinois | 17123 | 1445 | 25 |
1902089 | 1902089 | 2021-11-10 | Thomas | Kansas | 20193 | 1445 | 22 |
1896255 | 1896255 | 2021-11-08 | Sanders | Montana | 30089 | 1445 | 25 |
1881940 | 1881940 | 2021-11-04 | Glades | Florida | 12043 | 1445 | 28 |
1878556 | 1878556 | 2021-11-03 | Mariposa | California | 6043 | 1445 | 17 |
1878691 | 1878691 | 2021-11-03 | Glades | Florida | 12043 | 1445 | 28 |
1879890 | 1879890 | 2021-11-03 | Howard | Missouri | 29089 | 1445 | 13 |
1881279 | 1881279 | 2021-11-03 | Amelia | Virginia | 51007 | 1445 | 40 |
1875442 | 1875442 | 2021-11-02 | Glades | Florida | 12043 | 1445 | 28 |
1872193 | 1872193 | 2021-11-01 | Glades | Florida | 12043 | 1445 | 28 |
1868944 | 1868944 | 2021-10-31 | Glades | Florida | 12043 | 1445 | 28 |
1865695 | 1865695 | 2021-10-30 | Glades | Florida | 12043 | 1445 | 27 |
1862446 | 1862446 | 2021-10-29 | Glades | Florida | 12043 | 1445 | 27 |
1842266 | 1842266 | 2021-10-22 | Addison | Vermont | 50001 | 1445 | 8 |
1839249 | 1839249 | 2021-10-21 | Ritchie | West Virginia | 54085 | 1445 | 17 |
1826659 | 1826659 | 2021-10-18 | Rio Grande | Colorado | 8105 | 1445 | 21 |
1825522 | 1825522 | 2021-10-17 | Yauco | Puerto Rico | 72153 | 1445 | |
1787849 | 1787849 | 2021-10-06 | Lanier | Georgia | 13173 | 1445 | 15 |
1779045 | 1779045 | 2021-10-03 | Benton | Mississippi | 28009 | 1445 | 37 |
1780586 | 1780586 | 2021-10-03 | Dickenson | Virginia | 51051 | 1445 | 22 |
1775795 | 1775795 | 2021-10-02 | Benton | Mississippi | 28009 | 1445 | 37 |
1777336 | 1777336 | 2021-10-02 | Dickenson | Virginia | 51051 | 1445 | 22 |
1772545 | 1772545 | 2021-10-01 | Benton | Mississippi | 28009 | 1445 | 37 |
1774086 | 1774086 | 2021-10-01 | Dickenson | Virginia | 51051 | 1445 | 22 |
1769296 | 1769296 | 2021-09-30 | Benton | Mississippi | 28009 | 1445 | 37 |
1765049 | 1765049 | 2021-09-29 | Clinch | Georgia | 13065 | 1445 | 33 |
1755889 | 1755889 | 2021-09-26 | Bath | Kentucky | 21011 | 1445 | 24 |
1752641 | 1752641 | 2021-09-25 | Bath | Kentucky | 21011 | 1445 | 24 |
1749392 | 1749392 | 2021-09-24 | Bath | Kentucky | 21011 | 1445 | 24 |
1742646 | 1742646 | 2021-09-22 | Newton | Indiana | 18111 | 1445 | 47 |
1744882 | 1744882 | 2021-09-22 | Lexington city | Virginia | 51678 | 1445 | 33 |
1717515 | 1717515 | 2021-09-14 | Custer | Montana | 30017 | 1445 | 18 |
1710885 | 1710885 | 2021-09-12 | Tunica | Mississippi | 28143 | 1445 | 32 |
1707638 | 1707638 | 2021-09-11 | Tunica | Mississippi | 28143 | 1445 | 32 |
1709253 | 1709253 | 2021-09-11 | Braxton | West Virginia | 54007 | 1445 | 10 |
1704391 | 1704391 | 2021-09-10 | Tunica | Mississippi | 28143 | 1445 | 32 |
1696841 | 1696841 | 2021-09-08 | Dooly | Georgia | 13093 | 1445 | 49 |
1694296 | 1694296 | 2021-09-07 | East Carroll | Louisiana | 22035 | 1445 | 28 |
1696188 | 1696188 | 2021-09-07 | Richmond | Virginia | 51159 | 1445 | 12 |
1691680 | 1691680 | 2021-09-06 | Humboldt | Nevada | 32013 | 1445 | 16 |
1688430 | 1688430 | 2021-09-05 | Humboldt | Nevada | 32013 | 1445 | 16 |
1685180 | 1685180 | 2021-09-04 | Humboldt | Nevada | 32013 | 1445 | 16 |
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);