ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
326 rows where cases = 1415 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 28
- Puerto Rico 19
- Texas 18
- Georgia 16
- Tennessee 14
- Virginia 14
- Louisiana 13
- Alabama 12
- Illinois 12
- Kentucky 12
- Mississippi 11
- West Virginia 11
- Alaska 10
- Missouri 9
- Iowa 8
- Michigan 8
- Oklahoma 8
- Indiana 7
- Kansas 7
- Massachusetts 7
- Minnesota 7
- North Dakota 7
- Washington 7
- Colorado 6
- Nebraska 6
- North Carolina 6
- Wyoming 6
- Arkansas 5
- Maryland 4
- Ohio 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500206 | 2500206 | 2022-05-13 | Gallatin | Illinois | 17059 | 1415 | 18 |
2502051 | 2502051 | 2022-05-13 | Brule | South Dakota | 46015 | 1415 | 20 |
2496948 | 2496948 | 2022-05-12 | Gallatin | Illinois | 17059 | 1415 | 18 |
2498793 | 2498793 | 2022-05-12 | Brule | South Dakota | 46015 | 1415 | 20 |
2495535 | 2495535 | 2022-05-11 | Brule | South Dakota | 46015 | 1415 | 20 |
2469525 | 2469525 | 2022-05-03 | Spink | South Dakota | 46115 | 1415 | 36 |
2466269 | 2466269 | 2022-05-02 | Spink | South Dakota | 46115 | 1415 | 36 |
2463014 | 2463014 | 2022-05-01 | Spink | South Dakota | 46115 | 1415 | 36 |
2459758 | 2459758 | 2022-04-30 | Spink | South Dakota | 46115 | 1415 | 36 |
2456502 | 2456502 | 2022-04-29 | Spink | South Dakota | 46115 | 1415 | 36 |
2453246 | 2453246 | 2022-04-28 | Spink | South Dakota | 46115 | 1415 | 36 |
2453796 | 2453796 | 2022-04-28 | Ferry | Washington | 53019 | 1415 | 29 |
2449990 | 2449990 | 2022-04-27 | Spink | South Dakota | 46115 | 1415 | 36 |
2450540 | 2450540 | 2022-04-27 | Ferry | Washington | 53019 | 1415 | 29 |
2446733 | 2446733 | 2022-04-26 | Spink | South Dakota | 46115 | 1415 | 35 |
2443478 | 2443478 | 2022-04-25 | Spink | South Dakota | 46115 | 1415 | 35 |
2440222 | 2440222 | 2022-04-24 | Spink | South Dakota | 46115 | 1415 | 35 |
2436966 | 2436966 | 2022-04-23 | Spink | South Dakota | 46115 | 1415 | 35 |
2433710 | 2433710 | 2022-04-22 | Spink | South Dakota | 46115 | 1415 | 35 |
2430454 | 2430454 | 2022-04-21 | Spink | South Dakota | 46115 | 1415 | 35 |
2427198 | 2427198 | 2022-04-20 | Spink | South Dakota | 46115 | 1415 | 35 |
2423942 | 2423942 | 2022-04-19 | Spink | South Dakota | 46115 | 1415 | 35 |
2420686 | 2420686 | 2022-04-18 | Spink | South Dakota | 46115 | 1415 | 35 |
2417430 | 2417430 | 2022-04-17 | Spink | South Dakota | 46115 | 1415 | 35 |
2414174 | 2414174 | 2022-04-16 | Spink | South Dakota | 46115 | 1415 | 35 |
2410918 | 2410918 | 2022-04-15 | Spink | South Dakota | 46115 | 1415 | 35 |
2407662 | 2407662 | 2022-04-14 | Spink | South Dakota | 46115 | 1415 | 35 |
2404406 | 2404406 | 2022-04-13 | Spink | South Dakota | 46115 | 1415 | 35 |
2375926 | 2375926 | 2022-04-05 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1415 | 8 |
2372674 | 2372674 | 2022-04-04 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1415 | 8 |
2369421 | 2369421 | 2022-04-03 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1415 | 8 |
2366168 | 2366168 | 2022-04-02 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1415 | 8 |
2362915 | 2362915 | 2022-04-01 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1415 | 8 |
2281265 | 2281265 | 2022-03-06 | Mathews | Virginia | 51115 | 1415 | 28 |
2278012 | 2278012 | 2022-03-05 | Mathews | Virginia | 51115 | 1415 | 28 |
2274759 | 2274759 | 2022-03-04 | Mathews | Virginia | 51115 | 1415 | 28 |
2266772 | 2266772 | 2022-03-02 | Dade | Missouri | 29057 | 1415 | 40 |
2263521 | 2263521 | 2022-03-01 | Dade | Missouri | 29057 | 1415 | 40 |
2264356 | 2264356 | 2022-03-01 | Guanica | Puerto Rico | 72055 | 1415 | |
2260270 | 2260270 | 2022-02-28 | Dade | Missouri | 29057 | 1415 | 40 |
2261106 | 2261106 | 2022-02-28 | Guanica | Puerto Rico | 72055 | 1415 | |
2257855 | 2257855 | 2022-02-27 | Guanica | Puerto Rico | 72055 | 1415 | |
2224671 | 2224671 | 2022-02-17 | Clay | Nebraska | 31035 | 1415 | 21 |
2217792 | 2217792 | 2022-02-15 | Oscoda | Michigan | 26135 | 1415 | 53 |
2214541 | 2214541 | 2022-02-14 | Oscoda | Michigan | 26135 | 1415 | 53 |
2203312 | 2203312 | 2022-02-10 | Skamania | Washington | 53059 | 1415 | 10 |
2200058 | 2200058 | 2022-02-09 | Skamania | Washington | 53059 | 1415 | 10 |
2175879 | 2175879 | 2022-02-02 | Cedar | Nebraska | 31027 | 1415 | 11 |
2112511 | 2112511 | 2022-01-14 | Dallas | Arkansas | 5039 | 1415 | 21 |
2060844 | 2060844 | 2021-12-29 | Macon | Georgia | 13193 | 1415 | 46 |
2037672 | 2037672 | 2021-12-22 | Sumter | Alabama | 1119 | 1415 | 42 |
2029806 | 2029806 | 2021-12-19 | Graham | North Carolina | 37075 | 1415 | 28 |
2026555 | 2026555 | 2021-12-18 | Graham | North Carolina | 37075 | 1415 | 28 |
2023304 | 2023304 | 2021-12-17 | Graham | North Carolina | 37075 | 1415 | 28 |
2018391 | 2018391 | 2021-12-16 | Lincoln | Colorado | 8073 | 1415 | 8 |
2015141 | 2015141 | 2021-12-15 | Lincoln | Colorado | 8073 | 1415 | 8 |
1989885 | 1989885 | 2021-12-07 | Elliott | Kentucky | 21063 | 1415 | 12 |
1984391 | 1984391 | 2021-12-05 | Pembina | North Dakota | 38067 | 1415 | 14 |
1960762 | 1960762 | 2021-11-28 | Red River | Louisiana | 22081 | 1415 | 49 |
1962709 | 1962709 | 2021-11-28 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1957511 | 1957511 | 2021-11-27 | Red River | Louisiana | 22081 | 1415 | 49 |
1959458 | 1959458 | 2021-11-27 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1954260 | 1954260 | 2021-11-26 | Red River | Louisiana | 22081 | 1415 | 49 |
1956207 | 1956207 | 2021-11-26 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1951009 | 1951009 | 2021-11-25 | Red River | Louisiana | 22081 | 1415 | 49 |
1952956 | 1952956 | 2021-11-25 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1947758 | 1947758 | 2021-11-24 | Red River | Louisiana | 22081 | 1415 | 49 |
1948970 | 1948970 | 2021-11-24 | Lares | Puerto Rico | 72081 | 1415 | |
1949705 | 1949705 | 2021-11-24 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1944507 | 1944507 | 2021-11-23 | Red River | Louisiana | 22081 | 1415 | 49 |
1945719 | 1945719 | 2021-11-23 | Lares | Puerto Rico | 72081 | 1415 | |
1941257 | 1941257 | 2021-11-22 | Red River | Louisiana | 22081 | 1415 | 49 |
1942468 | 1942468 | 2021-11-22 | Lares | Puerto Rico | 72081 | 1415 | |
1939218 | 1939218 | 2021-11-21 | Lares | Puerto Rico | 72081 | 1415 | |
1935968 | 1935968 | 2021-11-20 | Lares | Puerto Rico | 72081 | 1415 | |
1932718 | 1932718 | 2021-11-19 | Lares | Puerto Rico | 72081 | 1415 | |
1927875 | 1927875 | 2021-11-18 | Switzerland | Indiana | 18155 | 1415 | 12 |
1907647 | 1907647 | 2021-11-12 | Perry | Alabama | 1105 | 1415 | 40 |
1904398 | 1904398 | 2021-11-11 | Perry | Alabama | 1105 | 1415 | 40 |
1897898 | 1897898 | 2021-11-09 | Perry | Alabama | 1105 | 1415 | 40 |
1899232 | 1899232 | 2021-11-09 | Pipestone | Minnesota | 27117 | 1415 | 27 |
1894648 | 1894648 | 2021-11-08 | Perry | Alabama | 1105 | 1415 | 40 |
1897706 | 1897706 | 2021-11-08 | Gilmer | West Virginia | 54021 | 1415 | 13 |
1891398 | 1891398 | 2021-11-07 | Perry | Alabama | 1105 | 1415 | 40 |
1892264 | 1892264 | 2021-11-07 | Doniphan | Kansas | 20043 | 1415 | 29 |
1889014 | 1889014 | 2021-11-06 | Doniphan | Kansas | 20043 | 1415 | 29 |
1885764 | 1885764 | 2021-11-05 | Doniphan | Kansas | 20043 | 1415 | 29 |
1881649 | 1881649 | 2021-11-04 | Perry | Alabama | 1105 | 1415 | 40 |
1878234 | 1878234 | 2021-11-02 | Pleasants | West Virginia | 54073 | 1415 | 30 |
1872605 | 1872605 | 2021-11-01 | Martin | Indiana | 18101 | 1415 | 20 |
1858493 | 1858493 | 2021-10-27 | Grand | Utah | 49019 | 1415 | 4 |
1853635 | 1853635 | 2021-10-26 | Iron | Michigan | 26071 | 1415 | 56 |
1850386 | 1850386 | 2021-10-25 | Iron | Michigan | 26071 | 1415 | 56 |
1845980 | 1845980 | 2021-10-24 | Cleveland | Arkansas | 5025 | 1415 | 32 |
1842730 | 1842730 | 2021-10-23 | Cleveland | Arkansas | 5025 | 1415 | 32 |
1840899 | 1840899 | 2021-10-22 | Howard | Missouri | 29089 | 1415 | 12 |
1841710 | 1841710 | 2021-10-22 | Coamo | Puerto Rico | 72043 | 1415 | |
1836768 | 1836768 | 2021-10-21 | Marshall | Illinois | 17123 | 1415 | 23 |
1807844 | 1807844 | 2021-10-12 | Rice | Kansas | 20159 | 1415 | 15 |
1804593 | 1804593 | 2021-10-11 | Rice | Kansas | 20159 | 1415 | 15 |
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);