ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where cases = 3658 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31
- Georgia 20
- Florida 9
- Kentucky 9
- Oklahoma 9
- Virginia 8
- Missouri 7
- New York 7
- Arkansas 6
- Mississippi 6
- Tennessee 5
- North Carolina 4
- Oregon 4
- Wisconsin 4
- Alabama 3
- Illinois 3
- Michigan 3
- Minnesota 3
- Ohio 3
- Utah 3
- Washington 3
- Kansas 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Virgin Islands 2
- California 1
- Colorado 1
- Delaware 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493691 | 2493691 | 2022-05-11 | Greene | Illinois | 17061 | 3658 | 58 |
2421887 | 2421887 | 2022-04-19 | Jefferson | Georgia | 13163 | 3658 | 109 |
2418631 | 2418631 | 2022-04-18 | Jefferson | Georgia | 13163 | 3658 | 109 |
2415375 | 2415375 | 2022-04-17 | Jefferson | Georgia | 13163 | 3658 | 109 |
2412119 | 2412119 | 2022-04-16 | Jefferson | Georgia | 13163 | 3658 | 109 |
2408863 | 2408863 | 2022-04-15 | Jefferson | Georgia | 13163 | 3658 | 109 |
2405607 | 2405607 | 2022-04-14 | Jefferson | Georgia | 13163 | 3658 | 109 |
2402352 | 2402352 | 2022-04-13 | Jefferson | Georgia | 13163 | 3658 | 109 |
2399097 | 2399097 | 2022-04-12 | Jefferson | Georgia | 13163 | 3658 | 109 |
2395842 | 2395842 | 2022-04-11 | Jefferson | Georgia | 13163 | 3658 | 109 |
2392586 | 2392586 | 2022-04-10 | Jefferson | Georgia | 13163 | 3658 | 109 |
2389330 | 2389330 | 2022-04-09 | Jefferson | Georgia | 13163 | 3658 | 109 |
2386075 | 2386075 | 2022-04-08 | Jefferson | Georgia | 13163 | 3658 | 109 |
2382820 | 2382820 | 2022-04-07 | Jefferson | Georgia | 13163 | 3658 | 109 |
2379565 | 2379565 | 2022-04-06 | Jefferson | Georgia | 13163 | 3658 | 109 |
2290893 | 2290893 | 2022-03-09 | Zapata | Texas | 48505 | 3658 | 52 |
2279369 | 2279369 | 2022-03-06 | Trigg | Kentucky | 21221 | 3658 | 41 |
2276116 | 2276116 | 2022-03-05 | Trigg | Kentucky | 21221 | 3658 | 41 |
2272863 | 2272863 | 2022-03-04 | Trigg | Kentucky | 21221 | 3658 | 41 |
2213821 | 2213821 | 2022-02-14 | Minidoka | Idaho | 16067 | 3658 | 55 |
2203613 | 2203613 | 2022-02-11 | Howard | Arkansas | 5061 | 3658 | 45 |
2203166 | 2203166 | 2022-02-10 | Buckingham | Virginia | 51029 | 3658 | 45 |
2177784 | 2177784 | 2022-02-03 | Dixie | Florida | 12029 | 3658 | 52 |
2178566 | 2178566 | 2022-02-03 | Webster | Kentucky | 21233 | 3658 | 46 |
2174531 | 2174531 | 2022-02-02 | Dixie | Florida | 12029 | 3658 | 52 |
2171278 | 2171278 | 2022-02-01 | Dixie | Florida | 12029 | 3658 | 52 |
2168025 | 2168025 | 2022-01-31 | Dixie | Florida | 12029 | 3658 | 52 |
2164770 | 2164770 | 2022-01-30 | Dixie | Florida | 12029 | 3658 | 52 |
2161515 | 2161515 | 2022-01-29 | Dixie | Florida | 12029 | 3658 | 52 |
2158259 | 2158259 | 2022-01-28 | Dixie | Florida | 12029 | 3658 | 52 |
2148809 | 2148809 | 2022-01-25 | Jo Daviess | Illinois | 17085 | 3658 | 35 |
2131875 | 2131875 | 2022-01-19 | Carbon | Wyoming | 56007 | 3658 | 50 |
2081067 | 2081067 | 2022-01-04 | Waldo | Maine | 23027 | 3658 | 41 |
2076738 | 2076738 | 2022-01-03 | Columbia | Arkansas | 5027 | 3658 | 77 |
2060328 | 2060328 | 2021-12-28 | Vilas | Wisconsin | 55125 | 3658 | 70 |
2053297 | 2053297 | 2021-12-26 | Deaf Smith | Texas | 48117 | 3658 | 94 |
2050047 | 2050047 | 2021-12-25 | Deaf Smith | Texas | 48117 | 3658 | 94 |
2046797 | 2046797 | 2021-12-24 | Deaf Smith | Texas | 48117 | 3658 | 94 |
2043547 | 2043547 | 2021-12-23 | Deaf Smith | Texas | 48117 | 3658 | 94 |
2037130 | 2037130 | 2021-12-21 | Lampasas | Texas | 48281 | 3658 | 70 |
2033880 | 2033880 | 2021-12-20 | Lampasas | Texas | 48281 | 3658 | 70 |
2030630 | 2030630 | 2021-12-19 | Lampasas | Texas | 48281 | 3658 | 70 |
2027379 | 2027379 | 2021-12-18 | Lampasas | Texas | 48281 | 3658 | 70 |
2012143 | 2012143 | 2021-12-14 | Unknown | Georgia | 3658 | 6 | |
1995103 | 1995103 | 2021-12-08 | Louisa | Virginia | 51109 | 3658 | 53 |
1984602 | 1984602 | 2021-12-05 | Lincoln | Oregon | 41041 | 3658 | 52 |
1981352 | 1981352 | 2021-12-04 | Lincoln | Oregon | 41041 | 3658 | 52 |
1978102 | 1978102 | 2021-12-03 | Lincoln | Oregon | 41041 | 3658 | 52 |
1970834 | 1970834 | 2021-12-01 | Stone | Mississippi | 28131 | 3658 | 66 |
1964332 | 1964332 | 2021-11-29 | Stone | Mississippi | 28131 | 3658 | 66 |
1921890 | 1921890 | 2021-11-16 | Mason | Michigan | 26105 | 3658 | 50 |
1921966 | 1921966 | 2021-11-16 | Martin | Minnesota | 27091 | 3658 | 42 |
1918640 | 1918640 | 2021-11-15 | Mason | Michigan | 26105 | 3658 | 50 |
1920116 | 1920116 | 2021-11-15 | Limestone | Texas | 48293 | 3658 | 111 |
1916866 | 1916866 | 2021-11-14 | Limestone | Texas | 48293 | 3658 | 111 |
1917083 | 1917083 | 2021-11-14 | Hopewell city | Virginia | 51670 | 3658 | 88 |
1913616 | 1913616 | 2021-11-13 | Limestone | Texas | 48293 | 3658 | 111 |
1913833 | 1913833 | 2021-11-13 | Hopewell city | Virginia | 51670 | 3658 | 88 |
1910366 | 1910366 | 2021-11-12 | Limestone | Texas | 48293 | 3658 | 111 |
1910583 | 1910583 | 2021-11-12 | Hopewell city | Virginia | 51670 | 3658 | 88 |
1892933 | 1892933 | 2021-11-07 | Randolph | Missouri | 29175 | 3658 | 37 |
1886371 | 1886371 | 2021-11-05 | Crawford | Missouri | 29055 | 3658 | 59 |
1883382 | 1883382 | 2021-11-04 | Coos | New Hampshire | 33007 | 3658 | 63 |
1884523 | 1884523 | 2021-11-04 | St. Thomas | Virgin Islands | 78030 | 3658 | 46 |
1878498 | 1878498 | 2021-11-03 | Lincoln | Arkansas | 5079 | 3658 | 57 |
1879846 | 1879846 | 2021-11-03 | Adair | Missouri | 29001 | 3658 | 34 |
1881274 | 1881274 | 2021-11-03 | St. Thomas | Virgin Islands | 78030 | 3658 | 46 |
1832598 | 1832598 | 2021-10-19 | Hopewell city | Virginia | 51670 | 3658 | 85 |
1822782 | 1822782 | 2021-10-16 | Rutland | Vermont | 50021 | 3658 | 27 |
1793568 | 1793568 | 2021-10-07 | Carroll | Virginia | 51035 | 3658 | 85 |
1763049 | 1763049 | 2021-09-28 | Adams | Nebraska | 31001 | 3658 | 54 |
1758306 | 1758306 | 2021-09-27 | Sevier | Arkansas | 5133 | 3658 | 33 |
1737810 | 1737810 | 2021-09-20 | Barnwell | South Carolina | 45011 | 3658 | 74 |
1697790 | 1697790 | 2021-09-08 | Pine | Minnesota | 27115 | 3658 | 23 |
1694761 | 1694761 | 2021-09-07 | Stone | Missouri | 29209 | 3658 | 62 |
1690105 | 1690105 | 2021-09-06 | Glenn | California | 6021 | 3658 | 31 |
1678338 | 1678338 | 2021-09-02 | Coahoma | Mississippi | 28027 | 3658 | 92 |
1674079 | 1674079 | 2021-09-01 | Chattooga | Georgia | 13055 | 3658 | 77 |
1657296 | 1657296 | 2021-08-26 | Logan | West Virginia | 54045 | 3658 | 101 |
1647824 | 1647824 | 2021-08-24 | Jackson | Arkansas | 5067 | 3658 | 41 |
1642259 | 1642259 | 2021-08-22 | Marshall | Kentucky | 21157 | 3658 | 65 |
1639009 | 1639009 | 2021-08-21 | Marshall | Kentucky | 21157 | 3658 | 65 |
1635759 | 1635759 | 2021-08-20 | Marshall | Kentucky | 21157 | 3658 | 65 |
1624268 | 1624268 | 2021-08-16 | Lauderdale | Tennessee | 47097 | 3658 | 50 |
1601651 | 1601651 | 2021-08-09 | Fannin | Texas | 48147 | 3658 | 110 |
1598403 | 1598403 | 2021-08-08 | Fannin | Texas | 48147 | 3658 | 110 |
1595154 | 1595154 | 2021-08-07 | Fannin | Texas | 48147 | 3658 | 110 |
1580469 | 1580469 | 2021-08-03 | Boyle | Kentucky | 21021 | 3658 | 78 |
1561337 | 1561337 | 2021-07-28 | Lyon | Minnesota | 27083 | 3658 | 54 |
1559170 | 1559170 | 2021-07-27 | Marion | South Carolina | 45067 | 3658 | 108 |
1530768 | 1530768 | 2021-07-19 | Dallas | Alabama | 1047 | 3658 | 161 |
1527521 | 1527521 | 2021-07-18 | Dallas | Alabama | 1047 | 3658 | 161 |
1523738 | 1523738 | 2021-07-16 | Hopkins | Texas | 48223 | 3658 | 114 |
1513434 | 1513434 | 2021-07-13 | Garvin | Oklahoma | 40049 | 3658 | 79 |
1510188 | 1510188 | 2021-07-12 | Garvin | Oklahoma | 40049 | 3658 | 79 |
1506941 | 1506941 | 2021-07-11 | Garvin | Oklahoma | 40049 | 3658 | 79 |
1503695 | 1503695 | 2021-07-10 | Garvin | Oklahoma | 40049 | 3658 | 79 |
1500449 | 1500449 | 2021-07-09 | Garvin | Oklahoma | 40049 | 3658 | 79 |
1497203 | 1497203 | 2021-07-08 | Garvin | Oklahoma | 40049 | 3658 | 79 |
1492325 | 1492325 | 2021-07-07 | Wayne | Georgia | 13305 | 3658 | 91 |
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);