ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where cases = 6195 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502296 | 2502296 | 2022-05-13 | Gray | Texas | 48179 | 6195 | 125 |
2499038 | 2499038 | 2022-05-12 | Gray | Texas | 48179 | 6195 | 125 |
2493319 | 2493319 | 2022-05-11 | Delta | Colorado | 8029 | 6195 | 140 |
2490061 | 2490061 | 2022-05-10 | Delta | Colorado | 8029 | 6195 | 140 |
2485636 | 2485636 | 2022-05-08 | Cabo Rojo | Puerto Rico | 72023 | 6195 | |
2395989 | 2395989 | 2022-04-11 | Crawford | Illinois | 17033 | 6195 | 61 |
2310523 | 2310523 | 2022-03-15 | Lee | Virginia | 51105 | 6195 | 90 |
2307270 | 2307270 | 2022-03-14 | Lee | Virginia | 51105 | 6195 | 90 |
2278286 | 2278286 | 2022-03-06 | Geneva | Alabama | 1061 | 6195 | 155 |
2275033 | 2275033 | 2022-03-05 | Geneva | Alabama | 1061 | 6195 | 155 |
2271780 | 2271780 | 2022-03-04 | Geneva | Alabama | 1061 | 6195 | 155 |
2268528 | 2268528 | 2022-03-03 | Geneva | Alabama | 1061 | 6195 | 155 |
2266316 | 2266316 | 2022-03-02 | Lincoln | Kentucky | 21137 | 6195 | 121 |
2221323 | 2221323 | 2022-02-16 | Saline | Missouri | 29195 | 6195 | 97 |
2105345 | 2105345 | 2022-01-11 | Grimes | Texas | 48185 | 6195 | 111 |
2094426 | 2094426 | 2022-01-08 | Lafayette | Missouri | 29107 | 6195 | 97 |
2031001 | 2031001 | 2021-12-19 | Preston | West Virginia | 54077 | 6195 | 109 |
2027395 | 2027395 | 2021-12-18 | Matagorda | Texas | 48321 | 6195 | 162 |
1974900 | 1974900 | 2021-12-02 | Jefferson | Pennsylvania | 42065 | 6195 | 150 |
1963567 | 1963567 | 2021-11-29 | Clinton | Indiana | 18023 | 6195 | 81 |
1899595 | 1899595 | 2021-11-09 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1896345 | 1896345 | 2021-11-08 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1893095 | 1893095 | 2021-11-07 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1889845 | 1889845 | 2021-11-06 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1886595 | 1886595 | 2021-11-05 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1883346 | 1883346 | 2021-11-04 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1880097 | 1880097 | 2021-11-03 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1876848 | 1876848 | 2021-11-02 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1873599 | 1873599 | 2021-11-01 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1870350 | 1870350 | 2021-10-31 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1867101 | 1867101 | 2021-10-30 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1863852 | 1863852 | 2021-10-29 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1860603 | 1860603 | 2021-10-28 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1857018 | 1857018 | 2021-10-27 | Winona | Minnesota | 27169 | 6195 | 55 |
1857354 | 1857354 | 2021-10-27 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1854105 | 1854105 | 2021-10-26 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1855315 | 1855315 | 2021-10-26 | Danville city | Virginia | 51590 | 6195 | 189 |
1850856 | 1850856 | 2021-10-25 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1847606 | 1847606 | 2021-10-24 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1844356 | 1844356 | 2021-10-23 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1841106 | 1841106 | 2021-10-22 | Scotts Bluff | Nebraska | 31157 | 6195 | 101 |
1758756 | 1758756 | 2021-09-27 | Effingham | Illinois | 17049 | 6195 | 93 |
1756746 | 1756746 | 2021-09-26 | Genesee | New York | 36037 | 6195 | 131 |
1712573 | 1712573 | 2021-09-12 | Grant | Wisconsin | 55043 | 6195 | 101 |
1709326 | 1709326 | 2021-09-11 | Grant | Wisconsin | 55043 | 6195 | 101 |
1706079 | 1706079 | 2021-09-10 | Grant | Wisconsin | 55043 | 6195 | 101 |
1671468 | 1671468 | 2021-08-31 | Hopkins | Kentucky | 21107 | 6195 | 162 |
1656274 | 1656274 | 2021-08-26 | Huron | Ohio | 39077 | 6195 | 123 |
1602834 | 1602834 | 2021-08-10 | Grundy | Illinois | 17063 | 6195 | 83 |
1585360 | 1585360 | 2021-08-04 | Caldwell | Texas | 48055 | 6195 | 102 |
1582681 | 1582681 | 2021-08-03 | Waupaca | Wisconsin | 55135 | 6195 | 167 |
1575285 | 1575285 | 2021-08-01 | Union | Pennsylvania | 42119 | 6195 | 90 |
1506634 | 1506634 | 2021-07-11 | Jefferson | New York | 36045 | 6195 | 68 |
1421712 | 1421712 | 2021-06-15 | Chisago | Minnesota | 27025 | 6195 | 52 |
1404285 | 1404285 | 2021-06-10 | Greene | Arkansas | 5055 | 6195 | 77 |
1401573 | 1401573 | 2021-06-09 | Ogle | Illinois | 17141 | 6195 | 91 |
1392712 | 1392712 | 2021-06-06 | Joplin | Missouri | 6195 | 109 | |
1389467 | 1389467 | 2021-06-05 | Joplin | Missouri | 6195 | 109 | |
1382624 | 1382624 | 2021-06-03 | Penobscot | Maine | 23019 | 6195 | 94 |
1365924 | 1365924 | 2021-05-29 | Dubois | Indiana | 18037 | 6195 | 118 |
1332050 | 1332050 | 2021-05-18 | Hawkins | Tennessee | 47073 | 6195 | 108 |
1221022 | 1221022 | 2021-04-14 | Columbus | North Carolina | 37047 | 6195 | 149 |
1175756 | 1175756 | 2021-03-31 | Scioto | Ohio | 39145 | 6195 | 96 |
1167041 | 1167041 | 2021-03-28 | Calumet | Wisconsin | 55015 | 6195 | 50 |
1155201 | 1155201 | 2021-03-25 | Laurel | Kentucky | 21125 | 6195 | 50 |
1062275 | 1062275 | 2021-02-24 | Clearfield | Pennsylvania | 42033 | 6195 | 114 |
1058017 | 1058017 | 2021-02-23 | Eaton | Michigan | 26045 | 6195 | 150 |
1014293 | 1014293 | 2021-02-09 | Hanover | Virginia | 51085 | 6195 | 104 |
940632 | 940632 | 2021-01-18 | Floyd | Indiana | 18043 | 6195 | 110 |
886652 | 886652 | 2021-01-01 | Burke | North Carolina | 37023 | 6195 | 75 |
883407 | 883407 | 2020-12-31 | Burke | North Carolina | 37023 | 6195 | 75 |
782992 | 782992 | 2020-11-30 | Licking | Ohio | 39089 | 6195 | 77 |
722752 | 722752 | 2020-11-12 | Larimer | Colorado | 8069 | 6195 | 63 |
685296 | 685296 | 2020-10-31 | Sarpy | Nebraska | 31153 | 6195 | 39 |
585165 | 585165 | 2020-09-30 | Cleveland | Oklahoma | 40027 | 6195 | 71 |
527348 | 527348 | 2020-09-12 | Brazos | Texas | 48041 | 6195 | 60 |
354383 | 354383 | 2020-07-21 | Ada | Idaho | 16001 | 6195 | 36 |
346395 | 346395 | 2020-07-18 | Oklahoma | Oklahoma | 40109 | 6195 | 77 |
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);