ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
267 rows where cases = 2225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 26
- Georgia 24
- Texas 21
- Kentucky 16
- Oklahoma 14
- Indiana 13
- Mississippi 12
- Arkansas 11
- Missouri 11
- North Carolina 11
- Illinois 10
- Iowa 10
- South Dakota 8
- Florida 7
- Virginia 6
- Colorado 5
- New Mexico 5
- New York 5
- Ohio 5
- Pennsylvania 5
- Alabama 4
- Michigan 4
- Minnesota 4
- Montana 4
- South Carolina 4
- Wisconsin 4
- Nebraska 3
- Puerto Rico 3
- West Virginia 3
- Utah 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497834 | 2497834 | 2022-05-12 | Carroll | Missouri | 29033 | 2225 | 44 |
2494576 | 2494576 | 2022-05-11 | Carroll | Missouri | 29033 | 2225 | 44 |
2491318 | 2491318 | 2022-05-10 | Carroll | Missouri | 29033 | 2225 | 44 |
2491763 | 2491763 | 2022-05-10 | Jones | North Carolina | 37103 | 2225 | 39 |
2488060 | 2488060 | 2022-05-09 | Carroll | Missouri | 29033 | 2225 | 44 |
2488505 | 2488505 | 2022-05-09 | Jones | North Carolina | 37103 | 2225 | 39 |
2484803 | 2484803 | 2022-05-08 | Carroll | Missouri | 29033 | 2225 | 44 |
2485248 | 2485248 | 2022-05-08 | Jones | North Carolina | 37103 | 2225 | 39 |
2481545 | 2481545 | 2022-05-07 | Carroll | Missouri | 29033 | 2225 | 44 |
2481990 | 2481990 | 2022-05-07 | Jones | North Carolina | 37103 | 2225 | 39 |
2478287 | 2478287 | 2022-05-06 | Carroll | Missouri | 29033 | 2225 | 44 |
2478732 | 2478732 | 2022-05-06 | Jones | North Carolina | 37103 | 2225 | 39 |
2475474 | 2475474 | 2022-05-05 | Jones | North Carolina | 37103 | 2225 | 39 |
2472217 | 2472217 | 2022-05-04 | Jones | North Carolina | 37103 | 2225 | 39 |
2469710 | 2469710 | 2022-05-03 | Franklin | Texas | 48159 | 2225 | 42 |
2466454 | 2466454 | 2022-05-02 | Franklin | Texas | 48159 | 2225 | 42 |
2463199 | 2463199 | 2022-05-01 | Franklin | Texas | 48159 | 2225 | 42 |
2459943 | 2459943 | 2022-04-30 | Franklin | Texas | 48159 | 2225 | 42 |
2456687 | 2456687 | 2022-04-29 | Franklin | Texas | 48159 | 2225 | 42 |
2378387 | 2378387 | 2022-04-05 | Clay | Tennessee | 47027 | 2225 | 49 |
2375133 | 2375133 | 2022-04-04 | Clay | Tennessee | 47027 | 2225 | 49 |
2371881 | 2371881 | 2022-04-03 | Clay | Tennessee | 47027 | 2225 | 49 |
2368628 | 2368628 | 2022-04-02 | Clay | Tennessee | 47027 | 2225 | 49 |
2365375 | 2365375 | 2022-04-01 | Clay | Tennessee | 47027 | 2225 | 49 |
2362122 | 2362122 | 2022-03-31 | Clay | Tennessee | 47027 | 2225 | 49 |
2358868 | 2358868 | 2022-03-30 | Clay | Tennessee | 47027 | 2225 | 49 |
2288562 | 2288562 | 2022-03-09 | Wilkinson | Georgia | 13319 | 2225 | 54 |
2285064 | 2285064 | 2022-03-08 | San Miguel | Colorado | 8113 | 2225 | 8 |
2285311 | 2285311 | 2022-03-08 | Wilkinson | Georgia | 13319 | 2225 | 53 |
2287356 | 2287356 | 2022-03-08 | Moore | Tennessee | 47127 | 2225 | 37 |
2282059 | 2282059 | 2022-03-07 | Wilkinson | Georgia | 13319 | 2225 | 53 |
2284104 | 2284104 | 2022-03-07 | Moore | Tennessee | 47127 | 2225 | 37 |
2280852 | 2280852 | 2022-03-06 | Moore | Tennessee | 47127 | 2225 | 37 |
2277599 | 2277599 | 2022-03-05 | Moore | Tennessee | 47127 | 2225 | 37 |
2274346 | 2274346 | 2022-03-04 | Moore | Tennessee | 47127 | 2225 | 37 |
2271093 | 2271093 | 2022-03-03 | Moore | Tennessee | 47127 | 2225 | 37 |
2267841 | 2267841 | 2022-03-02 | Moore | Tennessee | 47127 | 2225 | 37 |
2240054 | 2240054 | 2022-02-22 | Clarke | Iowa | 19039 | 2225 | 34 |
2236803 | 2236803 | 2022-02-21 | Clarke | Iowa | 19039 | 2225 | 34 |
2233552 | 2233552 | 2022-02-20 | Clarke | Iowa | 19039 | 2225 | 34 |
2230301 | 2230301 | 2022-02-19 | Clarke | Iowa | 19039 | 2225 | 34 |
2227050 | 2227050 | 2022-02-18 | Clarke | Iowa | 19039 | 2225 | 34 |
2223531 | 2223531 | 2022-02-17 | Wilkes | Georgia | 13317 | 2225 | 46 |
2223799 | 2223799 | 2022-02-17 | Clarke | Iowa | 19039 | 2225 | 34 |
2220281 | 2220281 | 2022-02-16 | Wilkinson | Georgia | 13319 | 2225 | 52 |
2220548 | 2220548 | 2022-02-16 | Clarke | Iowa | 19039 | 2225 | 34 |
2218672 | 2218672 | 2022-02-15 | Latimer | Oklahoma | 40077 | 2225 | 31 |
2213403 | 2213403 | 2022-02-14 | Scott | Arkansas | 5127 | 2225 | 38 |
2213778 | 2213778 | 2022-02-14 | Wilkes | Georgia | 13317 | 2225 | 46 |
2215421 | 2215421 | 2022-02-14 | Latimer | Oklahoma | 40077 | 2225 | 31 |
2212170 | 2212170 | 2022-02-13 | Latimer | Oklahoma | 40077 | 2225 | 31 |
2208917 | 2208917 | 2022-02-12 | Latimer | Oklahoma | 40077 | 2225 | 31 |
2205664 | 2205664 | 2022-02-11 | Latimer | Oklahoma | 40077 | 2225 | 31 |
2202411 | 2202411 | 2022-02-10 | Latimer | Oklahoma | 40077 | 2225 | 31 |
2199157 | 2199157 | 2022-02-09 | Latimer | Oklahoma | 40077 | 2225 | 31 |
2190348 | 2190348 | 2022-02-06 | Ritchie | West Virginia | 54085 | 2225 | 27 |
2187095 | 2187095 | 2022-02-05 | Ritchie | West Virginia | 54085 | 2225 | 27 |
2164870 | 2164870 | 2022-01-30 | Dooly | Georgia | 13093 | 2225 | 63 |
2161615 | 2161615 | 2022-01-29 | Dooly | Georgia | 13093 | 2225 | 63 |
2158359 | 2158359 | 2022-01-28 | Dooly | Georgia | 13093 | 2225 | 63 |
2146276 | 2146276 | 2022-01-24 | Koochiching | Minnesota | 27071 | 2225 | 32 |
2146569 | 2146569 | 2022-01-24 | Richland | Montana | 30083 | 2225 | 30 |
2137501 | 2137501 | 2022-01-21 | Ciales | Puerto Rico | 72039 | 2225 | |
2126875 | 2126875 | 2022-01-18 | Tunica | Mississippi | 28143 | 2225 | 41 |
2062782 | 2062782 | 2021-12-29 | Bamberg | South Carolina | 45009 | 2225 | 64 |
2042094 | 2042094 | 2021-12-23 | Dukes | Massachusetts | 25007 | 2225 | 0 |
2035377 | 2035377 | 2021-12-21 | Breathitt | Kentucky | 21025 | 2225 | 46 |
2019497 | 2019497 | 2021-12-16 | Pope | Minnesota | 27121 | 2225 | 12 |
2016313 | 2016313 | 2021-12-15 | Lawrence | Mississippi | 28077 | 2225 | 43 |
2011894 | 2011894 | 2021-12-14 | Moffat | Colorado | 8081 | 2225 | 48 |
2013968 | 2013968 | 2021-12-14 | Fajardo | Puerto Rico | 72053 | 2225 | |
2007717 | 2007717 | 2021-12-12 | Stewart | Tennessee | 47161 | 2225 | 39 |
2004466 | 2004466 | 2021-12-11 | Stewart | Tennessee | 47161 | 2225 | 39 |
2001215 | 2001215 | 2021-12-10 | Stewart | Tennessee | 47161 | 2225 | 39 |
1996451 | 1996451 | 2021-12-09 | Pendleton | Kentucky | 21191 | 2225 | 26 |
1991731 | 1991731 | 2021-12-07 | Zapata | Texas | 48505 | 2225 | 46 |
1987832 | 1987832 | 2021-12-06 | Baker | Oregon | 41001 | 2225 | 33 |
1978544 | 1978544 | 2021-12-03 | Eastland | Texas | 48133 | 2225 | 82 |
1973312 | 1973312 | 2021-12-02 | Blackford | Indiana | 18009 | 2225 | 46 |
1927760 | 1927760 | 2021-11-18 | Mercer | Illinois | 17131 | 2225 | 37 |
1920749 | 1920749 | 2021-11-16 | Marion | Arkansas | 5089 | 2225 | 61 |
1892421 | 1892421 | 2021-11-07 | Magoffin | Kentucky | 21153 | 2225 | 23 |
1892969 | 1892969 | 2021-11-07 | Custer | Montana | 30017 | 2225 | 37 |
1889171 | 1889171 | 2021-11-06 | Magoffin | Kentucky | 21153 | 2225 | 23 |
1889719 | 1889719 | 2021-11-06 | Custer | Montana | 30017 | 2225 | 37 |
1885921 | 1885921 | 2021-11-05 | Magoffin | Kentucky | 21153 | 2225 | 23 |
1886469 | 1886469 | 2021-11-05 | Custer | Montana | 30017 | 2225 | 37 |
1881578 | 1881578 | 2021-11-03 | Converse | Wyoming | 56009 | 2225 | 38 |
1818646 | 1818646 | 2021-10-15 | McKenzie | North Dakota | 38053 | 2225 | 20 |
1795397 | 1795397 | 2021-10-08 | Dallas | Missouri | 29059 | 2225 | 40 |
1786104 | 1786104 | 2021-10-05 | Polk | North Carolina | 37149 | 2225 | 42 |
1779469 | 1779469 | 2021-10-03 | Taos | New Mexico | 35055 | 2225 | 61 |
1776219 | 1776219 | 2021-10-02 | Taos | New Mexico | 35055 | 2225 | 61 |
1772969 | 1772969 | 2021-10-01 | Taos | New Mexico | 35055 | 2225 | 61 |
1768992 | 1768992 | 2021-09-30 | Washington | Kentucky | 21229 | 2225 | 43 |
1756631 | 1756631 | 2021-09-26 | Seward | Nebraska | 31159 | 2225 | 34 |
1753383 | 1753383 | 2021-09-25 | Seward | Nebraska | 31159 | 2225 | 34 |
1750135 | 1750135 | 2021-09-24 | Seward | Nebraska | 31159 | 2225 | 34 |
1723683 | 1723683 | 2021-09-16 | Manistee | Michigan | 26101 | 2225 | 31 |
1724902 | 1724902 | 2021-09-16 | Oglala Lakota | South Dakota | 46102 | 2225 | 51 |
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);