ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5600 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Tennessee 11
- Virginia 9
- Texas 7
- Louisiana 6
- Georgia 5
- Mississippi 5
- Ohio 4
- Minnesota 3
- North Carolina 3
- Pennsylvania 3
- South Carolina 3
- Arkansas 2
- Iowa 2
- Kentucky 2
- Missouri 2
- New York 2
- Alabama 1
- California 1
- Colorado 1
- Florida 1
- Michigan 1
- Nebraska 1
- New Jersey 1
- Oregon 1
- Puerto Rico 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450266 | 2450266 | 2022-04-27 | Moore | Texas | 48341 | 5600 | 111 |
2447009 | 2447009 | 2022-04-26 | Moore | Texas | 48341 | 5600 | 111 |
2443754 | 2443754 | 2022-04-25 | Moore | Texas | 48341 | 5600 | 111 |
2440498 | 2440498 | 2022-04-24 | Moore | Texas | 48341 | 5600 | 111 |
2437242 | 2437242 | 2022-04-23 | Moore | Texas | 48341 | 5600 | 111 |
2359864 | 2359864 | 2022-03-31 | Morgan | Colorado | 8087 | 5600 | 135 |
2326840 | 2326840 | 2022-03-20 | Staunton city | Virginia | 51790 | 5600 | 109 |
2323587 | 2323587 | 2022-03-19 | Staunton city | Virginia | 51790 | 5600 | 109 |
2320333 | 2320333 | 2022-03-18 | Staunton city | Virginia | 51790 | 5600 | 109 |
2304062 | 2304062 | 2022-03-13 | Salem city | Virginia | 51775 | 5600 | 96 |
2300810 | 2300810 | 2022-03-12 | Salem city | Virginia | 51775 | 5600 | 96 |
2297558 | 2297558 | 2022-03-11 | Salem city | Virginia | 51775 | 5600 | 96 |
2226345 | 2226345 | 2022-02-18 | Arkansas | Arkansas | 5001 | 5600 | 73 |
2188347 | 2188347 | 2022-02-06 | Grant | Louisiana | 22043 | 5600 | 84 |
2185094 | 2185094 | 2022-02-05 | Grant | Louisiana | 22043 | 5600 | 84 |
2181842 | 2181842 | 2022-02-04 | Grant | Louisiana | 22043 | 5600 | 84 |
2179357 | 2179357 | 2022-02-03 | Ashe | North Carolina | 37009 | 5600 | 67 |
2171992 | 2171992 | 2022-02-01 | Harrison | Kentucky | 21097 | 5600 | 58 |
2150736 | 2150736 | 2022-01-25 | Hickman | Tennessee | 47081 | 5600 | 93 |
2147248 | 2147248 | 2022-01-24 | Aguada | Puerto Rico | 72003 | 5600 | |
2147484 | 2147484 | 2022-01-24 | Hickman | Tennessee | 47081 | 5600 | 93 |
2144230 | 2144230 | 2022-01-23 | Hickman | Tennessee | 47081 | 5600 | 93 |
2140975 | 2140975 | 2022-01-22 | Hickman | Tennessee | 47081 | 5600 | 93 |
2137719 | 2137719 | 2022-01-21 | Hickman | Tennessee | 47081 | 5600 | 93 |
2134465 | 2134465 | 2022-01-20 | Hickman | Tennessee | 47081 | 5600 | 93 |
2131213 | 2131213 | 2022-01-19 | Hickman | Tennessee | 47081 | 5600 | 93 |
2123552 | 2123552 | 2022-01-17 | Adams | Mississippi | 28001 | 5600 | 125 |
2120300 | 2120300 | 2022-01-16 | Adams | Mississippi | 28001 | 5600 | 125 |
2117048 | 2117048 | 2022-01-15 | Adams | Mississippi | 28001 | 5600 | 125 |
2118504 | 2118504 | 2022-01-15 | Willacy | Texas | 48489 | 5600 | 116 |
2113797 | 2113797 | 2022-01-14 | Adams | Mississippi | 28001 | 5600 | 125 |
2096608 | 2096608 | 2022-01-09 | Lumpkin | Georgia | 13187 | 5600 | 111 |
2093356 | 2093356 | 2022-01-08 | Lumpkin | Georgia | 13187 | 5600 | 111 |
2090104 | 2090104 | 2022-01-07 | Lumpkin | Georgia | 13187 | 5600 | 111 |
2086853 | 2086853 | 2022-01-06 | Lumpkin | Georgia | 13187 | 5600 | 111 |
2083601 | 2083601 | 2022-01-05 | Lumpkin | Georgia | 13187 | 5600 | 111 |
2069188 | 2069188 | 2021-12-31 | Warren | Pennsylvania | 42123 | 5600 | 180 |
2054934 | 2054934 | 2021-12-27 | Logan | Kentucky | 21141 | 5600 | 98 |
2019567 | 2019567 | 2021-12-16 | Lincoln | Mississippi | 28085 | 5600 | 136 |
2003464 | 2003464 | 2021-12-11 | Warren | Missouri | 29219 | 5600 | 75 |
1991804 | 1991804 | 2021-12-07 | Charlottesville city | Virginia | 51540 | 5600 | 62 |
1984935 | 1984935 | 2021-12-05 | Macon | Tennessee | 47111 | 5600 | 99 |
1981685 | 1981685 | 2021-12-04 | Macon | Tennessee | 47111 | 5600 | 99 |
1978435 | 1978435 | 2021-12-03 | Macon | Tennessee | 47111 | 5600 | 99 |
1965087 | 1965087 | 2021-11-29 | Coos | Oregon | 41011 | 5600 | 106 |
1951704 | 1951704 | 2021-11-25 | Columbia | New York | 36021 | 5600 | 113 |
1923653 | 1923653 | 2021-11-16 | York | Virginia | 51199 | 5600 | 83 |
1913142 | 1913142 | 2021-11-13 | Jefferson | Pennsylvania | 42065 | 5600 | 130 |
1832041 | 1832041 | 2021-10-19 | Colleton | South Carolina | 45029 | 5600 | 188 |
1827718 | 1827718 | 2021-10-18 | Isanti | Minnesota | 27059 | 5600 | 73 |
1788984 | 1788984 | 2021-10-06 | Webster | Missouri | 29225 | 5600 | 86 |
1735501 | 1735501 | 2021-09-20 | Baxter | Arkansas | 5005 | 5600 | 165 |
1722418 | 1722418 | 2021-09-16 | Franklin | Alabama | 1059 | 5600 | 93 |
1624143 | 1624143 | 2021-08-16 | Newberry | South Carolina | 45071 | 5600 | 110 |
1604756 | 1604756 | 2021-08-10 | Franklin | Tennessee | 47051 | 5600 | 92 |
1523102 | 1523102 | 2021-07-16 | Huron | Ohio | 39077 | 5600 | 122 |
1519854 | 1519854 | 2021-07-15 | Huron | Ohio | 39077 | 5600 | 122 |
1516606 | 1516606 | 2021-07-14 | Huron | Ohio | 39077 | 5600 | 122 |
1379002 | 1379002 | 2021-06-02 | Clinton | Iowa | 19045 | 5600 | 93 |
1375756 | 1375756 | 2021-06-01 | Clinton | Iowa | 19045 | 5600 | 93 |
1338081 | 1338081 | 2021-05-20 | Jefferson | Ohio | 39081 | 5600 | 153 |
1321597 | 1321597 | 2021-05-15 | Cattaraugus | New York | 36009 | 5600 | 87 |
1178194 | 1178194 | 2021-04-01 | Van Buren | Michigan | 26159 | 5600 | 100 |
1133836 | 1133836 | 2021-03-18 | Cherokee | South Carolina | 45021 | 5600 | 144 |
1048947 | 1048947 | 2021-02-20 | Duplin | North Carolina | 37061 | 5600 | 124 |
1034397 | 1034397 | 2021-02-16 | Monroe | Florida | 12087 | 5600 | 44 |
1033720 | 1033720 | 2021-02-15 | Bedford | Virginia | 51019 | 5600 | 42 |
999663 | 999663 | 2021-02-05 | Blue Earth | Minnesota | 27013 | 5600 | 34 |
944274 | 944274 | 2021-01-19 | Acadia | Louisiana | 22001 | 5600 | 173 |
906020 | 906020 | 2021-01-07 | Sussex | New Jersey | 34037 | 5600 | 224 |
900822 | 900822 | 2021-01-05 | Cabell | West Virginia | 54011 | 5600 | 107 |
892621 | 892621 | 2021-01-03 | Rice | Minnesota | 27131 | 5600 | 57 |
893178 | 893178 | 2021-01-03 | Henderson | North Carolina | 37089 | 5600 | 92 |
870814 | 870814 | 2020-12-27 | Lycoming | Pennsylvania | 42081 | 5600 | 110 |
705855 | 705855 | 2020-11-06 | Tom Green | Texas | 48451 | 5600 | 86 |
441857 | 441857 | 2020-08-17 | St. Tammany | Louisiana | 22103 | 5600 | 221 |
309417 | 309417 | 2020-07-07 | San Joaquin | California | 6077 | 5600 | 58 |
232438 | 232438 | 2020-06-12 | Douglas | Nebraska | 31055 | 5600 | 60 |
52102 | 52102 | 2020-04-12 | Orleans | Louisiana | 22071 | 5600 | 235 |
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);