ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
352 rows where cases = 1583 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 61
- Virginia 37
- Kentucky 16
- Tennessee 15
- Wisconsin 15
- Georgia 14
- Missouri 13
- Illinois 12
- Texas 11
- Alabama 10
- Arkansas 10
- West Virginia 10
- Minnesota 9
- Mississippi 9
- Michigan 7
- North Dakota 7
- Florida 6
- Indiana 6
- Louisiana 6
- Ohio 6
- Puerto Rico 6
- Idaho 5
- New York 5
- Oklahoma 5
- Utah 5
- Alaska 4
- Colorado 4
- North Carolina 4
- Oregon 4
- Wyoming 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445006 | 2445006 | 2022-04-26 | Adair | Iowa | 19001 | 1583 | 50 |
2441750 | 2441750 | 2022-04-25 | Adair | Iowa | 19001 | 1583 | 50 |
2438494 | 2438494 | 2022-04-24 | Adair | Iowa | 19001 | 1583 | 50 |
2435238 | 2435238 | 2022-04-23 | Adair | Iowa | 19001 | 1583 | 50 |
2431982 | 2431982 | 2022-04-22 | Adair | Iowa | 19001 | 1583 | 50 |
2428726 | 2428726 | 2022-04-21 | Adair | Iowa | 19001 | 1583 | 50 |
2425470 | 2425470 | 2022-04-20 | Adair | Iowa | 19001 | 1583 | 50 |
2422214 | 2422214 | 2022-04-19 | Adair | Iowa | 19001 | 1583 | 50 |
2418958 | 2418958 | 2022-04-18 | Adair | Iowa | 19001 | 1583 | 50 |
2415702 | 2415702 | 2022-04-17 | Adair | Iowa | 19001 | 1583 | 50 |
2412446 | 2412446 | 2022-04-16 | Adair | Iowa | 19001 | 1583 | 50 |
2409190 | 2409190 | 2022-04-15 | Adair | Iowa | 19001 | 1583 | 50 |
2405934 | 2405934 | 2022-04-14 | Adair | Iowa | 19001 | 1583 | 50 |
2402678 | 2402678 | 2022-04-13 | Adair | Iowa | 19001 | 1583 | 50 |
2399424 | 2399424 | 2022-04-12 | Adair | Iowa | 19001 | 1583 | 50 |
2396168 | 2396168 | 2022-04-11 | Adair | Iowa | 19001 | 1583 | 50 |
2392913 | 2392913 | 2022-04-10 | Adair | Iowa | 19001 | 1583 | 50 |
2389657 | 2389657 | 2022-04-09 | Adair | Iowa | 19001 | 1583 | 50 |
2386401 | 2386401 | 2022-04-08 | Adair | Iowa | 19001 | 1583 | 50 |
2383147 | 2383147 | 2022-04-07 | Adair | Iowa | 19001 | 1583 | 50 |
2379892 | 2379892 | 2022-04-06 | Adair | Iowa | 19001 | 1583 | 50 |
2376637 | 2376637 | 2022-04-05 | Adair | Iowa | 19001 | 1583 | 51 |
2373385 | 2373385 | 2022-04-04 | Adair | Iowa | 19001 | 1583 | 51 |
2370132 | 2370132 | 2022-04-03 | Adair | Iowa | 19001 | 1583 | 51 |
2366879 | 2366879 | 2022-04-02 | Adair | Iowa | 19001 | 1583 | 51 |
2363626 | 2363626 | 2022-04-01 | Adair | Iowa | 19001 | 1583 | 51 |
2360372 | 2360372 | 2022-03-31 | Adair | Iowa | 19001 | 1583 | 51 |
2357118 | 2357118 | 2022-03-30 | Adair | Iowa | 19001 | 1583 | 51 |
2353865 | 2353865 | 2022-03-29 | Adair | Iowa | 19001 | 1583 | 51 |
2350613 | 2350613 | 2022-03-28 | Adair | Iowa | 19001 | 1583 | 51 |
2347360 | 2347360 | 2022-03-27 | Adair | Iowa | 19001 | 1583 | 51 |
2344107 | 2344107 | 2022-03-26 | Adair | Iowa | 19001 | 1583 | 51 |
2340854 | 2340854 | 2022-03-25 | Adair | Iowa | 19001 | 1583 | 51 |
2337601 | 2337601 | 2022-03-24 | Adair | Iowa | 19001 | 1583 | 51 |
2340056 | 2340056 | 2022-03-24 | Weston | Wyoming | 56045 | 1583 | 18 |
2334347 | 2334347 | 2022-03-23 | Adair | Iowa | 19001 | 1583 | 51 |
2335071 | 2335071 | 2022-03-23 | Clark | Missouri | 29045 | 1583 | 32 |
2336803 | 2336803 | 2022-03-23 | Weston | Wyoming | 56045 | 1583 | 18 |
2331093 | 2331093 | 2022-03-22 | Adair | Iowa | 19001 | 1583 | 50 |
2333549 | 2333549 | 2022-03-22 | Weston | Wyoming | 56045 | 1583 | 18 |
2327841 | 2327841 | 2022-03-21 | Adair | Iowa | 19001 | 1583 | 50 |
2324588 | 2324588 | 2022-03-20 | Adair | Iowa | 19001 | 1583 | 50 |
2321334 | 2321334 | 2022-03-19 | Adair | Iowa | 19001 | 1583 | 50 |
2318080 | 2318080 | 2022-03-18 | Adair | Iowa | 19001 | 1583 | 50 |
2314827 | 2314827 | 2022-03-17 | Adair | Iowa | 19001 | 1583 | 50 |
2316042 | 2316042 | 2022-03-17 | Bottineau | North Dakota | 38009 | 1583 | 26 |
2311574 | 2311574 | 2022-03-16 | Adair | Iowa | 19001 | 1583 | 50 |
2312789 | 2312789 | 2022-03-16 | Bottineau | North Dakota | 38009 | 1583 | 26 |
2309536 | 2309536 | 2022-03-15 | Bottineau | North Dakota | 38009 | 1583 | 26 |
2306283 | 2306283 | 2022-03-14 | Bottineau | North Dakota | 38009 | 1583 | 25 |
2303032 | 2303032 | 2022-03-13 | Bottineau | North Dakota | 38009 | 1583 | 25 |
2299780 | 2299780 | 2022-03-12 | Bottineau | North Dakota | 38009 | 1583 | 25 |
2285039 | 2285039 | 2022-03-08 | Kit Carson | Colorado | 8063 | 1583 | 30 |
2211506 | 2211506 | 2022-02-13 | Daviess | Missouri | 29061 | 1583 | 26 |
2208253 | 2208253 | 2022-02-12 | Daviess | Missouri | 29061 | 1583 | 26 |
2205000 | 2205000 | 2022-02-11 | Daviess | Missouri | 29061 | 1583 | 26 |
2201747 | 2201747 | 2022-02-10 | Daviess | Missouri | 29061 | 1583 | 26 |
2177077 | 2177077 | 2022-02-02 | Beaver | Utah | 49001 | 1583 | 14 |
2149008 | 2149008 | 2022-01-25 | Ida | Iowa | 19093 | 1583 | 44 |
2145756 | 2145756 | 2022-01-24 | Ida | Iowa | 19093 | 1583 | 44 |
2142501 | 2142501 | 2022-01-23 | Ida | Iowa | 19093 | 1583 | 44 |
2139246 | 2139246 | 2022-01-22 | Ida | Iowa | 19093 | 1583 | 44 |
2135990 | 2135990 | 2022-01-21 | Ida | Iowa | 19093 | 1583 | 44 |
2132738 | 2132738 | 2022-01-20 | Ida | Iowa | 19093 | 1583 | 44 |
2129485 | 2129485 | 2022-01-19 | Ida | Iowa | 19093 | 1583 | 44 |
2123561 | 2123561 | 2022-01-17 | Choctaw | Mississippi | 28019 | 1583 | 27 |
2119192 | 2119192 | 2022-01-16 | Yuma | Colorado | 8125 | 1583 | 22 |
2120309 | 2120309 | 2022-01-16 | Choctaw | Mississippi | 28019 | 1583 | 27 |
2115940 | 2115940 | 2022-01-15 | Yuma | Colorado | 8125 | 1583 | 22 |
2117057 | 2117057 | 2022-01-15 | Choctaw | Mississippi | 28019 | 1583 | 27 |
2112689 | 2112689 | 2022-01-14 | Yuma | Colorado | 8125 | 1583 | 22 |
2113806 | 2113806 | 2022-01-14 | Choctaw | Mississippi | 28019 | 1583 | 27 |
2101333 | 2101333 | 2022-01-10 | Jones | North Carolina | 37103 | 1583 | 38 |
2095711 | 2095711 | 2022-01-08 | Somervell | Texas | 48425 | 1583 | 26 |
2089478 | 2089478 | 2022-01-06 | Doddridge | West Virginia | 54017 | 1583 | 15 |
2083752 | 2083752 | 2022-01-05 | Hamilton | Illinois | 17065 | 1583 | 28 |
2066015 | 2066015 | 2021-12-30 | Utuado | Puerto Rico | 72141 | 1583 | |
2039967 | 2039967 | 2021-12-22 | Coamo | Puerto Rico | 72043 | 1583 | |
2029248 | 2029248 | 2021-12-19 | Pipestone | Minnesota | 27117 | 1583 | 30 |
2025997 | 2025997 | 2021-12-18 | Pipestone | Minnesota | 27117 | 1583 | 30 |
2022746 | 2022746 | 2021-12-17 | Pipestone | Minnesota | 27117 | 1583 | 30 |
2019487 | 2019487 | 2021-12-16 | Murray | Minnesota | 27101 | 1583 | 12 |
2019651 | 2019651 | 2021-12-16 | Howard | Missouri | 29089 | 1583 | 19 |
2015930 | 2015930 | 2021-12-15 | Livingston | Kentucky | 21139 | 1583 | 47 |
1966266 | 1966266 | 2021-11-30 | Perry | Arkansas | 5105 | 1583 | 22 |
1917923 | 1917923 | 2021-11-15 | Fremont | Idaho | 16043 | 1583 | 16 |
1920519 | 1920519 | 2021-11-15 | Forest | Wisconsin | 55041 | 1583 | 33 |
1917069 | 1917069 | 2021-11-14 | Galax city | Virginia | 51640 | 1583 | 64 |
1913819 | 1913819 | 2021-11-13 | Galax city | Virginia | 51640 | 1583 | 64 |
1910569 | 1910569 | 2021-11-12 | Galax city | Virginia | 51640 | 1583 | 64 |
1878095 | 1878095 | 2021-11-02 | Lexington city | Virginia | 51678 | 1583 | 36 |
1872242 | 1872242 | 2021-11-01 | Atkinson | Georgia | 13003 | 1583 | 37 |
1853893 | 1853893 | 2021-10-26 | Grundy | Missouri | 29079 | 1583 | 48 |
1854647 | 1854647 | 2021-10-26 | Forest | Pennsylvania | 42053 | 1583 | 24 |
1845459 | 1845459 | 2021-10-23 | Trinity | Texas | 48455 | 1583 | 59 |
1840968 | 1840968 | 2021-10-22 | Wayne | Missouri | 29223 | 1583 | 18 |
1842209 | 1842209 | 2021-10-22 | Trinity | Texas | 48455 | 1583 | 59 |
1832570 | 1832570 | 2021-10-19 | Dickenson | Virginia | 51051 | 1583 | 26 |
1826439 | 1826439 | 2021-10-18 | Ketchikan Gateway Borough | Alaska | 2130 | 1583 | 7 |
1823190 | 1823190 | 2021-10-17 | Ketchikan Gateway Borough | Alaska | 2130 | 1583 | 7 |
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);