ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where cases = 3257 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Virginia 17
- Georgia 12
- Louisiana 12
- Missouri 9
- North Carolina 9
- Mississippi 8
- Wisconsin 8
- North Dakota 7
- Tennessee 7
- Arkansas 6
- Indiana 6
- Kentucky 6
- Minnesota 6
- Ohio 6
- Michigan 5
- West Virginia 5
- Oregon 4
- Puerto Rico 4
- South Carolina 4
- Alabama 3
- Illinois 3
- Kansas 3
- Florida 2
- Maryland 2
- New York 2
- Oklahoma 2
- Pennsylvania 2
- Arizona 1
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497850 | 2497850 | 2022-05-12 | Dent | Missouri | 29065 | 3257 | 83 |
2494592 | 2494592 | 2022-05-11 | Dent | Missouri | 29065 | 3257 | 83 |
2491334 | 2491334 | 2022-05-10 | Dent | Missouri | 29065 | 3257 | 83 |
2488076 | 2488076 | 2022-05-09 | Dent | Missouri | 29065 | 3257 | 83 |
2489294 | 2489294 | 2022-05-09 | Jackson | Texas | 48239 | 3257 | 59 |
2484706 | 2484706 | 2022-05-08 | Amite | Mississippi | 28005 | 3257 | 69 |
2484819 | 2484819 | 2022-05-08 | Dent | Missouri | 29065 | 3257 | 83 |
2486037 | 2486037 | 2022-05-08 | Jackson | Texas | 48239 | 3257 | 59 |
2481448 | 2481448 | 2022-05-07 | Amite | Mississippi | 28005 | 3257 | 69 |
2481561 | 2481561 | 2022-05-07 | Dent | Missouri | 29065 | 3257 | 83 |
2482779 | 2482779 | 2022-05-07 | Jackson | Texas | 48239 | 3257 | 59 |
2478190 | 2478190 | 2022-05-06 | Amite | Mississippi | 28005 | 3257 | 69 |
2478303 | 2478303 | 2022-05-06 | Dent | Missouri | 29065 | 3257 | 83 |
2479521 | 2479521 | 2022-05-06 | Jackson | Texas | 48239 | 3257 | 59 |
2474932 | 2474932 | 2022-05-05 | Amite | Mississippi | 28005 | 3257 | 69 |
2476263 | 2476263 | 2022-05-05 | Jackson | Texas | 48239 | 3257 | 59 |
2471675 | 2471675 | 2022-05-04 | Amite | Mississippi | 28005 | 3257 | 69 |
2473006 | 2473006 | 2022-05-04 | Jackson | Texas | 48239 | 3257 | 59 |
2468419 | 2468419 | 2022-05-03 | Amite | Mississippi | 28005 | 3257 | 69 |
2469750 | 2469750 | 2022-05-03 | Jackson | Texas | 48239 | 3257 | 59 |
2465164 | 2465164 | 2022-05-02 | Amite | Mississippi | 28005 | 3257 | 69 |
2466494 | 2466494 | 2022-05-02 | Jackson | Texas | 48239 | 3257 | 59 |
2461644 | 2461644 | 2022-05-01 | Madison | Louisiana | 22065 | 3257 | 59 |
2463239 | 2463239 | 2022-05-01 | Jackson | Texas | 48239 | 3257 | 59 |
2458388 | 2458388 | 2022-04-30 | Madison | Louisiana | 22065 | 3257 | 59 |
2459983 | 2459983 | 2022-04-30 | Jackson | Texas | 48239 | 3257 | 59 |
2455132 | 2455132 | 2022-04-29 | Madison | Louisiana | 22065 | 3257 | 59 |
2456727 | 2456727 | 2022-04-29 | Jackson | Texas | 48239 | 3257 | 59 |
2451876 | 2451876 | 2022-04-28 | Madison | Louisiana | 22065 | 3257 | 59 |
2453471 | 2453471 | 2022-04-28 | Jackson | Texas | 48239 | 3257 | 59 |
2448620 | 2448620 | 2022-04-27 | Madison | Louisiana | 22065 | 3257 | 59 |
2450215 | 2450215 | 2022-04-27 | Jackson | Texas | 48239 | 3257 | 59 |
2450675 | 2450675 | 2022-04-27 | Price | Wisconsin | 55099 | 3257 | 33 |
2445364 | 2445364 | 2022-04-26 | Madison | Louisiana | 22065 | 3257 | 59 |
2446958 | 2446958 | 2022-04-26 | Jackson | Texas | 48239 | 3257 | 59 |
2442108 | 2442108 | 2022-04-25 | Madison | Louisiana | 22065 | 3257 | 59 |
2384385 | 2384385 | 2022-04-07 | McKenzie | North Dakota | 38053 | 3257 | 25 |
2381130 | 2381130 | 2022-04-06 | McKenzie | North Dakota | 38053 | 3257 | 25 |
2377875 | 2377875 | 2022-04-05 | McKenzie | North Dakota | 38053 | 3257 | 25 |
2374622 | 2374622 | 2022-04-04 | McKenzie | North Dakota | 38053 | 3257 | 25 |
2371370 | 2371370 | 2022-04-03 | McKenzie | North Dakota | 38053 | 3257 | 25 |
2372374 | 2372374 | 2022-04-03 | Rockbridge | Virginia | 51163 | 3257 | 77 |
2368117 | 2368117 | 2022-04-02 | McKenzie | North Dakota | 38053 | 3257 | 25 |
2369121 | 2369121 | 2022-04-02 | Rockbridge | Virginia | 51163 | 3257 | 77 |
2364864 | 2364864 | 2022-04-01 | McKenzie | North Dakota | 38053 | 3257 | 25 |
2365868 | 2365868 | 2022-04-01 | Rockbridge | Virginia | 51163 | 3257 | 77 |
2362615 | 2362615 | 2022-03-31 | Rockbridge | Virginia | 51163 | 3257 | 77 |
2349602 | 2349602 | 2022-03-27 | Rockbridge | Virginia | 51163 | 3257 | 75 |
2346349 | 2346349 | 2022-03-26 | Rockbridge | Virginia | 51163 | 3257 | 75 |
2343096 | 2343096 | 2022-03-25 | Rockbridge | Virginia | 51163 | 3257 | 75 |
2336712 | 2336712 | 2022-03-23 | Bayfield | Wisconsin | 55007 | 3257 | 39 |
2323942 | 2323942 | 2022-03-20 | Little River | Arkansas | 5081 | 3257 | 92 |
2320688 | 2320688 | 2022-03-19 | Little River | Arkansas | 5081 | 3257 | 92 |
2317189 | 2317189 | 2022-03-17 | Ashland | Wisconsin | 55003 | 3257 | 35 |
2286883 | 2286883 | 2022-03-08 | Morgan | Ohio | 39115 | 3257 | 55 |
2280224 | 2280224 | 2022-03-06 | Mitchell | North Carolina | 37121 | 3257 | 34 |
2276971 | 2276971 | 2022-03-05 | Mitchell | North Carolina | 37121 | 3257 | 34 |
2273718 | 2273718 | 2022-03-04 | Mitchell | North Carolina | 37121 | 3257 | 34 |
2241930 | 2241930 | 2022-02-22 | Duval | Texas | 48131 | 3257 | 67 |
2235718 | 2235718 | 2022-02-20 | Greensville | Virginia | 51081 | 3257 | 33 |
2232467 | 2232467 | 2022-02-19 | Greensville | Virginia | 51081 | 3257 | 33 |
2229216 | 2229216 | 2022-02-18 | Greensville | Virginia | 51081 | 3257 | 33 |
2196293 | 2196293 | 2022-02-08 | Lewis | Tennessee | 47101 | 3257 | 49 |
2193039 | 2193039 | 2022-02-07 | Lewis | Tennessee | 47101 | 3257 | 49 |
2189785 | 2189785 | 2022-02-06 | Lewis | Tennessee | 47101 | 3257 | 49 |
2186532 | 2186532 | 2022-02-05 | Lewis | Tennessee | 47101 | 3257 | 49 |
2183280 | 2183280 | 2022-02-04 | Lewis | Tennessee | 47101 | 3257 | 49 |
2180028 | 2180028 | 2022-02-03 | Lewis | Tennessee | 47101 | 3257 | 49 |
2176777 | 2176777 | 2022-02-02 | Lewis | Tennessee | 47101 | 3257 | 49 |
2169049 | 2169049 | 2022-01-31 | Kanabec | Minnesota | 27065 | 3257 | 53 |
2141511 | 2141511 | 2022-01-22 | Braxton | West Virginia | 54007 | 3257 | 33 |
2131413 | 2131413 | 2022-01-19 | Leon | Texas | 48289 | 3257 | 75 |
2087435 | 2087435 | 2022-01-06 | Lawrence | Kentucky | 21127 | 3257 | 48 |
2087470 | 2087470 | 2022-01-06 | Powell | Kentucky | 21197 | 3257 | 29 |
2076463 | 2076463 | 2022-01-02 | Barbour | West Virginia | 54001 | 3257 | 56 |
2073212 | 2073212 | 2022-01-01 | Barbour | West Virginia | 54001 | 3257 | 56 |
2069961 | 2069961 | 2021-12-31 | Barbour | West Virginia | 54001 | 3257 | 56 |
2066710 | 2066710 | 2021-12-30 | Barbour | West Virginia | 54001 | 3257 | 56 |
2039960 | 2039960 | 2021-12-22 | Canovanas | Puerto Rico | 72029 | 3257 | |
2033375 | 2033375 | 2021-12-20 | Wasco | Oregon | 41065 | 3257 | 48 |
2029170 | 2029170 | 2021-12-19 | Ogemaw | Michigan | 26129 | 3257 | 80 |
2025919 | 2025919 | 2021-12-18 | Ogemaw | Michigan | 26129 | 3257 | 80 |
2021924 | 2021924 | 2021-12-17 | Blaine | Idaho | 16013 | 3257 | 27 |
2022668 | 2022668 | 2021-12-17 | Ogemaw | Michigan | 26129 | 3257 | 80 |
2015400 | 2015400 | 2021-12-15 | Washington | Georgia | 13303 | 3257 | 124 |
2012149 | 2012149 | 2021-12-14 | Washington | Georgia | 13303 | 3257 | 124 |
1998717 | 1998717 | 2021-12-10 | Ashley | Arkansas | 5003 | 3257 | 51 |
1966801 | 1966801 | 2021-11-30 | Wayne | Illinois | 17191 | 3257 | 66 |
1931952 | 1931952 | 2021-11-19 | Vernon | Missouri | 29217 | 3257 | 78 |
1923871 | 1923871 | 2021-11-17 | Fayette | Alabama | 1057 | 3257 | 85 |
1921101 | 1921101 | 2021-11-16 | Putnam | Georgia | 13237 | 3257 | 84 |
1914601 | 1914601 | 2021-11-14 | Putnam | Georgia | 13237 | 3257 | 84 |
1911351 | 1911351 | 2021-11-13 | Putnam | Georgia | 13237 | 3257 | 84 |
1908102 | 1908102 | 2021-11-12 | Putnam | Georgia | 13237 | 3257 | 84 |
1882326 | 1882326 | 2021-11-04 | Fulton | Indiana | 18049 | 3257 | 69 |
1881346 | 1881346 | 2021-11-03 | Louisa | Virginia | 51109 | 3257 | 48 |
1848293 | 1848293 | 2021-10-24 | Fairfield | South Carolina | 45039 | 3257 | 93 |
1845043 | 1845043 | 2021-10-23 | Fairfield | South Carolina | 45039 | 3257 | 93 |
1841793 | 1841793 | 2021-10-22 | Fairfield | South Carolina | 45039 | 3257 | 93 |
1838758 | 1838758 | 2021-10-21 | Burleson | Texas | 48051 | 3257 | 59 |
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);