ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where cases = 3814 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 41
- Texas 13
- Maine 8
- Minnesota 8
- Pennsylvania 8
- Louisiana 7
- Virginia 7
- Georgia 6
- Kansas 6
- Michigan 5
- North Carolina 5
- West Virginia 5
- Wisconsin 5
- Kentucky 4
- Mississippi 4
- Nebraska 4
- Oregon 4
- South Carolina 4
- Arkansas 3
- California 3
- Illinois 3
- New York 3
- Tennessee 3
- Utah 3
- Alabama 2
- Colorado 2
- Indiana 2
- Iowa 2
- Oklahoma 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470389 | 2470389 | 2022-05-04 | Franklin | Arkansas | 5047 | 3814 | 73 |
2471825 | 2471825 | 2022-05-04 | Moniteau | Missouri | 29135 | 3814 | 56 |
2468569 | 2468569 | 2022-05-03 | Moniteau | Missouri | 29135 | 3814 | 56 |
2465313 | 2465313 | 2022-05-02 | Moniteau | Missouri | 29135 | 3814 | 56 |
2462058 | 2462058 | 2022-05-01 | Moniteau | Missouri | 29135 | 3814 | 56 |
2458802 | 2458802 | 2022-04-30 | Moniteau | Missouri | 29135 | 3814 | 56 |
2455546 | 2455546 | 2022-04-29 | Moniteau | Missouri | 29135 | 3814 | 56 |
2452290 | 2452290 | 2022-04-28 | Moniteau | Missouri | 29135 | 3814 | 56 |
2449034 | 2449034 | 2022-04-27 | Moniteau | Missouri | 29135 | 3814 | 56 |
2445777 | 2445777 | 2022-04-26 | Moniteau | Missouri | 29135 | 3814 | 56 |
2446550 | 2446550 | 2022-04-26 | Aibonito | Puerto Rico | 72009 | 3814 | |
2442522 | 2442522 | 2022-04-25 | Moniteau | Missouri | 29135 | 3814 | 56 |
2439266 | 2439266 | 2022-04-24 | Moniteau | Missouri | 29135 | 3814 | 56 |
2436010 | 2436010 | 2022-04-23 | Moniteau | Missouri | 29135 | 3814 | 56 |
2432754 | 2432754 | 2022-04-22 | Moniteau | Missouri | 29135 | 3814 | 56 |
2429498 | 2429498 | 2022-04-21 | Moniteau | Missouri | 29135 | 3814 | 56 |
2426242 | 2426242 | 2022-04-20 | Moniteau | Missouri | 29135 | 3814 | 56 |
2427871 | 2427871 | 2022-04-20 | Marquette | Wisconsin | 55077 | 3814 | 61 |
2422986 | 2422986 | 2022-04-19 | Moniteau | Missouri | 29135 | 3814 | 56 |
2419729 | 2419729 | 2022-04-18 | Moniteau | Missouri | 29135 | 3814 | 56 |
2416474 | 2416474 | 2022-04-17 | Moniteau | Missouri | 29135 | 3814 | 56 |
2413218 | 2413218 | 2022-04-16 | Moniteau | Missouri | 29135 | 3814 | 56 |
2409962 | 2409962 | 2022-04-15 | Moniteau | Missouri | 29135 | 3814 | 56 |
2406706 | 2406706 | 2022-04-14 | Moniteau | Missouri | 29135 | 3814 | 56 |
2403450 | 2403450 | 2022-04-13 | Moniteau | Missouri | 29135 | 3814 | 56 |
2400195 | 2400195 | 2022-04-12 | Moniteau | Missouri | 29135 | 3814 | 56 |
2396940 | 2396940 | 2022-04-11 | Moniteau | Missouri | 29135 | 3814 | 56 |
2393685 | 2393685 | 2022-04-10 | Moniteau | Missouri | 29135 | 3814 | 56 |
2390429 | 2390429 | 2022-04-09 | Moniteau | Missouri | 29135 | 3814 | 56 |
2387173 | 2387173 | 2022-04-08 | Moniteau | Missouri | 29135 | 3814 | 56 |
2383918 | 2383918 | 2022-04-07 | Moniteau | Missouri | 29135 | 3814 | 56 |
2380663 | 2380663 | 2022-04-06 | Moniteau | Missouri | 29135 | 3814 | 56 |
2377408 | 2377408 | 2022-04-05 | Moniteau | Missouri | 29135 | 3814 | 56 |
2374155 | 2374155 | 2022-04-04 | Moniteau | Missouri | 29135 | 3814 | 56 |
2370903 | 2370903 | 2022-04-03 | Moniteau | Missouri | 29135 | 3814 | 56 |
2367650 | 2367650 | 2022-04-02 | Moniteau | Missouri | 29135 | 3814 | 56 |
2364397 | 2364397 | 2022-04-01 | Moniteau | Missouri | 29135 | 3814 | 56 |
2361143 | 2361143 | 2022-03-31 | Moniteau | Missouri | 29135 | 3814 | 56 |
2357889 | 2357889 | 2022-03-30 | Moniteau | Missouri | 29135 | 3814 | 56 |
2354636 | 2354636 | 2022-03-29 | Moniteau | Missouri | 29135 | 3814 | 56 |
2351383 | 2351383 | 2022-03-28 | Moniteau | Missouri | 29135 | 3814 | 55 |
2310734 | 2310734 | 2022-03-15 | Richland | Wisconsin | 55103 | 3814 | 45 |
2283124 | 2283124 | 2022-03-07 | Wright | Missouri | 29229 | 3814 | 77 |
2242217 | 2242217 | 2022-02-22 | Goochland | Virginia | 51075 | 3814 | 42 |
2238694 | 2238694 | 2022-02-21 | Freestone | Texas | 48161 | 3814 | 82 |
2235443 | 2235443 | 2022-02-20 | Freestone | Texas | 48161 | 3814 | 82 |
2232192 | 2232192 | 2022-02-19 | Freestone | Texas | 48161 | 3814 | 82 |
2228941 | 2228941 | 2022-02-18 | Freestone | Texas | 48161 | 3814 | 82 |
2223026 | 2223026 | 2022-02-17 | Macon | Alabama | 1087 | 3814 | 72 |
2213373 | 2213373 | 2022-02-14 | Izard | Arkansas | 5065 | 3814 | 63 |
2193357 | 2193357 | 2022-02-07 | San Juan | Utah | 49037 | 3814 | 47 |
2193369 | 2193369 | 2022-02-07 | Addison | Vermont | 50001 | 3814 | 13 |
2171638 | 2171638 | 2022-02-01 | Warren | Illinois | 17187 | 3814 | 81 |
2169259 | 2169259 | 2022-01-31 | Morgan | Missouri | 29141 | 3814 | 85 |
2145159 | 2145159 | 2022-01-24 | Alamosa | Colorado | 8003 | 3814 | 58 |
2142557 | 2142557 | 2022-01-23 | Atchison | Kansas | 20005 | 3814 | 31 |
2139302 | 2139302 | 2022-01-22 | Atchison | Kansas | 20005 | 3814 | 31 |
2136046 | 2136046 | 2022-01-21 | Atchison | Kansas | 20005 | 3814 | 31 |
2111625 | 2111625 | 2022-01-13 | Hughes | South Dakota | 46065 | 3814 | 58 |
2086001 | 2086001 | 2022-01-05 | Carbon | Utah | 49007 | 3814 | 41 |
2078095 | 2078095 | 2022-01-03 | Stone | Mississippi | 28131 | 3814 | 67 |
2010268 | 2010268 | 2021-12-13 | Ashe | North Carolina | 37009 | 3814 | 56 |
1995217 | 1995217 | 2021-12-08 | Hampshire | West Virginia | 54027 | 3814 | 53 |
1983761 | 1983761 | 2021-12-05 | Waseca | Minnesota | 27161 | 3814 | 33 |
1980511 | 1980511 | 2021-12-04 | Waseca | Minnesota | 27161 | 3814 | 33 |
1977261 | 1977261 | 2021-12-03 | Waseca | Minnesota | 27161 | 3814 | 33 |
1972410 | 1972410 | 2021-12-01 | Winchester city | Virginia | 51840 | 3814 | 57 |
1968792 | 1968792 | 2021-11-30 | Dimmit | Texas | 48127 | 3814 | 46 |
1959899 | 1959899 | 2021-11-28 | Routt | Colorado | 8107 | 3814 | 23 |
1938091 | 1938091 | 2021-11-21 | Alpena | Michigan | 26007 | 3814 | 81 |
1934841 | 1934841 | 2021-11-20 | Alpena | Michigan | 26007 | 3814 | 81 |
1931591 | 1931591 | 2021-11-19 | Alpena | Michigan | 26007 | 3814 | 81 |
1923747 | 1923747 | 2021-11-16 | Wyoming | West Virginia | 54109 | 3814 | 67 |
1920498 | 1920498 | 2021-11-15 | Wyoming | West Virginia | 54109 | 3814 | 66 |
1917248 | 1917248 | 2021-11-14 | Wyoming | West Virginia | 54109 | 3814 | 66 |
1856066 | 1856066 | 2021-10-27 | Haralson | Georgia | 13143 | 3814 | 117 |
1858851 | 1858851 | 2021-10-27 | Uinta | Wyoming | 56041 | 3814 | 26 |
1852817 | 1852817 | 2021-10-26 | Haralson | Georgia | 13143 | 3814 | 117 |
1847000 | 1847000 | 2021-10-24 | Grant | Louisiana | 22043 | 3814 | 77 |
1843750 | 1843750 | 2021-10-23 | Grant | Louisiana | 22043 | 3814 | 77 |
1840500 | 1840500 | 2021-10-22 | Grant | Louisiana | 22043 | 3814 | 77 |
1811193 | 1811193 | 2021-10-13 | Marion | Kentucky | 21155 | 3814 | 43 |
1808067 | 1808067 | 2021-10-12 | Somerset | Maine | 23025 | 3814 | 41 |
1808861 | 1808861 | 2021-10-12 | Transylvania | North Carolina | 37175 | 3814 | 47 |
1804816 | 1804816 | 2021-10-11 | Somerset | Maine | 23025 | 3814 | 41 |
1801567 | 1801567 | 2021-10-10 | Somerset | Maine | 23025 | 3814 | 41 |
1798318 | 1798318 | 2021-10-09 | Somerset | Maine | 23025 | 3814 | 41 |
1763821 | 1763821 | 2021-09-28 | Jasper | South Carolina | 45053 | 3814 | 69 |
1724290 | 1724290 | 2021-09-16 | Washington | New York | 36115 | 3814 | 61 |
1713147 | 1713147 | 2021-09-13 | Peach | Georgia | 13225 | 3814 | 77 |
1711302 | 1711302 | 2021-09-12 | Wyoming | New York | 36121 | 3814 | 54 |
1690052 | 1690052 | 2021-09-06 | Jackson | Arkansas | 5067 | 3814 | 41 |
1691277 | 1691277 | 2021-09-06 | Lyon | Minnesota | 27083 | 3814 | 54 |
1692960 | 1692960 | 2021-09-06 | Warren | Virginia | 51187 | 3814 | 65 |
1688027 | 1688027 | 2021-09-05 | Lyon | Minnesota | 27083 | 3814 | 54 |
1684777 | 1684777 | 2021-09-04 | Lyon | Minnesota | 27083 | 3814 | 54 |
1681526 | 1681526 | 2021-09-03 | Lyon | Minnesota | 27083 | 3814 | 54 |
1679715 | 1679715 | 2021-09-02 | Palo Pinto | Texas | 48363 | 3814 | 90 |
1667840 | 1667840 | 2021-08-30 | Perry | Illinois | 17145 | 3814 | 76 |
1645626 | 1645626 | 2021-08-23 | Oxford | Maine | 23017 | 3814 | 71 |
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);