ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where cases = 4663 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 11
- Iowa 11
- Virginia 11
- Georgia 10
- Indiana 8
- Colorado 7
- North Carolina 7
- Mississippi 6
- Nebraska 6
- Texas 6
- Ohio 5
- Wisconsin 5
- Arkansas 4
- California 4
- Louisiana 4
- Michigan 4
- Minnesota 4
- Missouri 4
- New Mexico 3
- Pennsylvania 3
- Kansas 2
- Kentucky 2
- Tennessee 2
- Washington 2
- Arizona 1
- Hawaii 1
- New York 1
- Oregon 1
- Puerto Rico 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441205 | 2441205 | 2022-04-25 | Chaffee | Colorado | 8015 | 4663 | 44 |
2404680 | 2404680 | 2022-04-13 | Montague | Texas | 48337 | 4663 | 127 |
2330726 | 2330726 | 2022-03-22 | Crisp | Georgia | 13081 | 4663 | 135 |
2327474 | 2327474 | 2022-03-21 | Crisp | Georgia | 13081 | 4663 | 135 |
2327810 | 2327810 | 2022-03-21 | Perry | Indiana | 18123 | 4663 | 68 |
2305880 | 2305880 | 2022-03-14 | Texas | Missouri | 29215 | 4663 | 94 |
2257444 | 2257444 | 2022-02-27 | Hertford | North Carolina | 37091 | 4663 | 81 |
2254193 | 2254193 | 2022-02-26 | Hertford | North Carolina | 37091 | 4663 | 81 |
2250942 | 2250942 | 2022-02-25 | Hertford | North Carolina | 37091 | 4663 | 81 |
2215235 | 2215235 | 2022-02-14 | Yancey | North Carolina | 37199 | 4663 | 50 |
2200998 | 2200998 | 2022-02-10 | Starke | Indiana | 18149 | 4663 | 92 |
2179025 | 2179025 | 2022-02-03 | Perry | Missouri | 29157 | 4663 | 44 |
2167228 | 2167228 | 2022-01-30 | Milam | Texas | 48331 | 4663 | 93 |
2131439 | 2131439 | 2022-01-19 | Moore | Texas | 48341 | 4663 | 100 |
2118995 | 2118995 | 2022-01-16 | Arkansas | Arkansas | 5001 | 4663 | 67 |
2107482 | 2107482 | 2022-01-12 | Stone | Missouri | 29209 | 4663 | 101 |
2102749 | 2102749 | 2022-01-11 | Cleburne | Arkansas | 5023 | 4663 | 104 |
2096897 | 2096897 | 2022-01-09 | Randolph | Indiana | 18135 | 4663 | 123 |
2093645 | 2093645 | 2022-01-08 | Randolph | Indiana | 18135 | 4663 | 123 |
2090393 | 2090393 | 2022-01-07 | Randolph | Indiana | 18135 | 4663 | 123 |
2058037 | 2058037 | 2021-12-28 | Franklin | Kansas | 20059 | 4663 | 67 |
2054053 | 2054053 | 2021-12-27 | Calaveras | California | 6009 | 4663 | 91 |
2054788 | 2054788 | 2021-12-27 | Franklin | Kansas | 20059 | 4663 | 67 |
2056809 | 2056809 | 2021-12-27 | Carroll | Virginia | 51035 | 4663 | 111 |
2050803 | 2050803 | 2021-12-26 | Calaveras | California | 6009 | 4663 | 91 |
2047553 | 2047553 | 2021-12-25 | Calaveras | California | 6009 | 4663 | 91 |
2044303 | 2044303 | 2021-12-24 | Calaveras | California | 6009 | 4663 | 91 |
2042732 | 2042732 | 2021-12-23 | Lewis | New York | 36049 | 4663 | 41 |
2021504 | 2021504 | 2021-12-17 | Jackson | Arkansas | 5067 | 4663 | 47 |
2009031 | 2009031 | 2021-12-13 | Perry | Illinois | 17145 | 4663 | 88 |
1995614 | 1995614 | 2021-12-09 | Delta | Colorado | 8029 | 4663 | 107 |
1993934 | 1993934 | 2021-12-08 | Luna | New Mexico | 35029 | 4663 | 98 |
1988592 | 1988592 | 2021-12-06 | Isle of Wight | Virginia | 51093 | 4663 | 92 |
1967706 | 1967706 | 2021-11-30 | Stoddard | Missouri | 29207 | 4663 | 106 |
1914701 | 1914701 | 2021-11-14 | Bureau | Illinois | 17011 | 4663 | 108 |
1911451 | 1911451 | 2021-11-13 | Bureau | Illinois | 17011 | 4663 | 108 |
1908202 | 1908202 | 2021-11-12 | Bureau | Illinois | 17011 | 4663 | 108 |
1890435 | 1890435 | 2021-11-06 | Arecibo | Puerto Rico | 72013 | 4663 | |
1854048 | 1854048 | 2021-10-26 | Dakota | Nebraska | 31043 | 4663 | 82 |
1850564 | 1850564 | 2021-10-25 | Leflore | Mississippi | 28083 | 4663 | 144 |
1850799 | 1850799 | 2021-10-25 | Dakota | Nebraska | 31043 | 4663 | 82 |
1846140 | 1846140 | 2021-10-24 | Logan | Colorado | 8075 | 4663 | 80 |
1847549 | 1847549 | 2021-10-24 | Dakota | Nebraska | 31043 | 4663 | 82 |
1842890 | 1842890 | 2021-10-23 | Logan | Colorado | 8075 | 4663 | 80 |
1844299 | 1844299 | 2021-10-23 | Dakota | Nebraska | 31043 | 4663 | 82 |
1839640 | 1839640 | 2021-10-22 | Logan | Colorado | 8075 | 4663 | 80 |
1841049 | 1841049 | 2021-10-22 | Dakota | Nebraska | 31043 | 4663 | 82 |
1837800 | 1837800 | 2021-10-21 | Dakota | Nebraska | 31043 | 4663 | 82 |
1838914 | 1838914 | 2021-10-21 | Palo Pinto | Texas | 48363 | 4663 | 113 |
1831084 | 1831084 | 2021-10-19 | Prentiss | Mississippi | 28117 | 4663 | 81 |
1823026 | 1823026 | 2021-10-16 | Clark | Wisconsin | 55019 | 4663 | 76 |
1818691 | 1818691 | 2021-10-15 | Coshocton | Ohio | 39031 | 4663 | 82 |
1819777 | 1819777 | 2021-10-15 | Clark | Wisconsin | 55019 | 4663 | 76 |
1816528 | 1816528 | 2021-10-14 | Clark | Wisconsin | 55019 | 4663 | 76 |
1808016 | 1808016 | 2021-10-12 | Jefferson Davis | Louisiana | 22053 | 4663 | 123 |
1791139 | 1791139 | 2021-10-07 | Stephens | Georgia | 13257 | 4663 | 98 |
1790274 | 1790274 | 2021-10-06 | Uintah | Utah | 49047 | 4663 | 40 |
1790455 | 1790455 | 2021-10-06 | Okanogan | Washington | 53047 | 4663 | 64 |
1780652 | 1780652 | 2021-10-03 | Prince George | Virginia | 51149 | 4663 | 35 |
1777402 | 1777402 | 2021-10-02 | Prince George | Virginia | 51149 | 4663 | 35 |
1774152 | 1774152 | 2021-10-01 | Prince George | Virginia | 51149 | 4663 | 35 |
1762708 | 1762708 | 2021-09-28 | Becker | Minnesota | 27005 | 4663 | 61 |
1758613 | 1758613 | 2021-09-27 | Lumpkin | Georgia | 13187 | 4663 | 90 |
1736131 | 1736131 | 2021-09-20 | Jefferson | Indiana | 18077 | 4663 | 92 |
1731204 | 1731204 | 2021-09-18 | Pike | Pennsylvania | 42103 | 4663 | 56 |
1716699 | 1716699 | 2021-09-14 | Buena Vista | Iowa | 19021 | 4663 | 42 |
1713453 | 1713453 | 2021-09-13 | Buena Vista | Iowa | 19021 | 4663 | 42 |
1710206 | 1710206 | 2021-09-12 | Buena Vista | Iowa | 19021 | 4663 | 42 |
1706959 | 1706959 | 2021-09-11 | Buena Vista | Iowa | 19021 | 4663 | 42 |
1703711 | 1703711 | 2021-09-10 | Buena Vista | Iowa | 19021 | 4663 | 42 |
1700461 | 1700461 | 2021-09-09 | Buena Vista | Iowa | 19021 | 4663 | 42 |
1697212 | 1697212 | 2021-09-08 | Buena Vista | Iowa | 19021 | 4663 | 42 |
1654454 | 1654454 | 2021-08-26 | La Plata | Colorado | 8067 | 4663 | 45 |
1648349 | 1648349 | 2021-08-24 | Morgan | Illinois | 17137 | 4663 | 117 |
1643292 | 1643292 | 2021-08-22 | Madison | Ohio | 39097 | 4663 | 65 |
1608051 | 1608051 | 2021-08-11 | Rhea | Tennessee | 47143 | 4663 | 83 |
1565950 | 1565950 | 2021-07-29 | Hill | Texas | 48217 | 4663 | 111 |
1559315 | 1559315 | 2021-07-27 | Obion | Tennessee | 47131 | 4663 | 98 |
1537897 | 1537897 | 2021-07-21 | Marion | Illinois | 17121 | 4663 | 123 |
1447808 | 1447808 | 2021-06-23 | Oktibbeha | Mississippi | 28105 | 4663 | 98 |
1444563 | 1444563 | 2021-06-22 | Oktibbeha | Mississippi | 28105 | 4663 | 98 |
1441318 | 1441318 | 2021-06-21 | Oktibbeha | Mississippi | 28105 | 4663 | 98 |
1436347 | 1436347 | 2021-06-19 | James City | Virginia | 51095 | 4663 | 72 |
1426609 | 1426609 | 2021-06-16 | James City | Virginia | 51095 | 4663 | 72 |
1423363 | 1423363 | 2021-06-15 | James City | Virginia | 51095 | 4663 | 72 |
1418596 | 1418596 | 2021-06-14 | Panola | Mississippi | 28107 | 4663 | 110 |
1391989 | 1391989 | 2021-06-06 | Des Moines | Iowa | 19057 | 4663 | 68 |
1385231 | 1385231 | 2021-06-04 | Maui | Hawaii | 15009 | 4663 | 55 |
1364199 | 1364199 | 2021-05-28 | Klamath | Oregon | 41035 | 4663 | 73 |
1351707 | 1351707 | 2021-05-24 | Howard | Texas | 48227 | 4663 | 101 |
1342917 | 1342917 | 2021-05-22 | Effingham | Georgia | 13103 | 4663 | 69 |
1314311 | 1314311 | 2021-05-13 | Jessamine | Kentucky | 21113 | 4663 | 64 |
1314600 | 1314600 | 2021-05-13 | Douglas | Minnesota | 27041 | 4663 | 75 |
1316219 | 1316219 | 2021-05-13 | Fauquier | Virginia | 51061 | 4663 | 68 |
1198471 | 1198471 | 2021-04-07 | Mercer | Ohio | 39107 | 4663 | 84 |
1157879 | 1157879 | 2021-03-26 | Murray | Georgia | 13213 | 4663 | 77 |
1146229 | 1146229 | 2021-03-22 | Otero | New Mexico | 35035 | 4663 | 71 |
1135296 | 1135296 | 2021-03-19 | Jackson | Illinois | 17077 | 4663 | 73 |
1132049 | 1132049 | 2021-03-18 | Jackson | Illinois | 17077 | 4663 | 73 |
1134579 | 1134579 | 2021-03-18 | Dunn | Wisconsin | 55033 | 4663 | 30 |
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);