ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
185 rows where cases = 2957 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 15
- Texas 15
- Georgia 14
- Kentucky 12
- Mississippi 12
- North Carolina 11
- Iowa 10
- Puerto Rico 8
- Illinois 7
- Missouri 7
- Virginia 7
- Oklahoma 5
- Tennessee 5
- Washington 5
- Oregon 4
- South Dakota 4
- Alabama 3
- Arkansas 3
- Colorado 3
- Minnesota 3
- Montana 3
- New York 3
- Ohio 3
- Wisconsin 3
- California 2
- Idaho 2
- Louisiana 2
- North Dakota 2
- Pennsylvania 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468912 | 2468912 | 2022-05-03 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2465656 | 2465656 | 2022-05-02 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2462401 | 2462401 | 2022-05-01 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2459145 | 2459145 | 2022-04-30 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2455889 | 2455889 | 2022-04-29 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2452633 | 2452633 | 2022-04-28 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2449377 | 2449377 | 2022-04-27 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2423676 | 2423676 | 2022-04-19 | Morrow | Oregon | 41049 | 2957 | 34 |
2416370 | 2416370 | 2022-04-17 | Montgomery | Mississippi | 28097 | 2957 | 77 |
2413114 | 2413114 | 2022-04-16 | Montgomery | Mississippi | 28097 | 2957 | 77 |
2409858 | 2409858 | 2022-04-15 | Montgomery | Mississippi | 28097 | 2957 | 77 |
2406602 | 2406602 | 2022-04-14 | Montgomery | Mississippi | 28097 | 2957 | 77 |
2403346 | 2403346 | 2022-04-13 | Montgomery | Mississippi | 28097 | 2957 | 77 |
2400092 | 2400092 | 2022-04-12 | Montgomery | Mississippi | 28097 | 2957 | 77 |
2381508 | 2381508 | 2022-04-06 | Villalba | Puerto Rico | 72149 | 2957 | |
2375858 | 2375858 | 2022-04-05 | Coosa | Alabama | 1037 | 2957 | 58 |
2372606 | 2372606 | 2022-04-04 | Coosa | Alabama | 1037 | 2957 | 58 |
2287286 | 2287286 | 2022-03-08 | Todd | South Dakota | 46121 | 2957 | 50 |
2270076 | 2270076 | 2022-03-03 | Pemiscot | Missouri | 29155 | 2957 | 73 |
2266823 | 2266823 | 2022-03-02 | Pemiscot | Missouri | 29155 | 2957 | 73 |
2257492 | 2257492 | 2022-02-27 | Washington | North Carolina | 37187 | 2957 | 48 |
2254241 | 2254241 | 2022-02-26 | Washington | North Carolina | 37187 | 2957 | 48 |
2250990 | 2250990 | 2022-02-25 | Washington | North Carolina | 37187 | 2957 | 48 |
2246154 | 2246154 | 2022-02-24 | Charlton | Georgia | 13049 | 2957 | 61 |
2246321 | 2246321 | 2022-02-24 | Gooding | Idaho | 16047 | 2957 | 52 |
2196515 | 2196515 | 2022-02-08 | Nolan | Texas | 48353 | 2957 | 90 |
2152529 | 2152529 | 2022-01-26 | Trigg | Kentucky | 21221 | 2957 | 35 |
2147832 | 2147832 | 2022-01-24 | Lamoille | Vermont | 50015 | 2957 | 12 |
2131805 | 2131805 | 2022-01-19 | Buffalo | Wisconsin | 55011 | 2957 | 10 |
2122798 | 2122798 | 2022-01-17 | Massac | Illinois | 17127 | 2957 | 64 |
2119546 | 2119546 | 2022-01-16 | Massac | Illinois | 17127 | 2957 | 64 |
2116294 | 2116294 | 2022-01-15 | Massac | Illinois | 17127 | 2957 | 64 |
2113043 | 2113043 | 2022-01-14 | Massac | Illinois | 17127 | 2957 | 64 |
2105568 | 2105568 | 2022-01-11 | Bristol city | Virginia | 51520 | 2957 | 58 |
2101890 | 2101890 | 2022-01-10 | Oglala Lakota | South Dakota | 46102 | 2957 | 55 |
2056398 | 2056398 | 2021-12-27 | Cannon | Tennessee | 47015 | 2957 | 50 |
2038217 | 2038217 | 2021-12-22 | Bond | Illinois | 17005 | 2957 | 34 |
2033157 | 2033157 | 2021-12-20 | Richland | North Dakota | 38077 | 2957 | 21 |
2021053 | 2021053 | 2021-12-16 | Buchanan | Virginia | 51027 | 2957 | 83 |
2004262 | 2004262 | 2021-12-11 | Vega Alta | Puerto Rico | 72143 | 2957 | |
2001011 | 2001011 | 2021-12-10 | Vega Alta | Puerto Rico | 72143 | 2957 | |
1983376 | 1983376 | 2021-12-05 | Casey | Kentucky | 21045 | 2957 | 59 |
1980126 | 1980126 | 2021-12-04 | Casey | Kentucky | 21045 | 2957 | 59 |
1972323 | 1972323 | 2021-12-01 | Fluvanna | Virginia | 51065 | 2957 | 28 |
1966920 | 1966920 | 2021-11-30 | Clay | Iowa | 19041 | 2957 | 36 |
1963668 | 1963668 | 2021-11-29 | Clay | Iowa | 19041 | 2957 | 36 |
1960417 | 1960417 | 2021-11-28 | Clay | Iowa | 19041 | 2957 | 36 |
1962435 | 1962435 | 2021-11-28 | Shelby | Texas | 48419 | 2957 | 111 |
1957166 | 1957166 | 2021-11-27 | Clay | Iowa | 19041 | 2957 | 36 |
1959184 | 1959184 | 2021-11-27 | Shelby | Texas | 48419 | 2957 | 111 |
1953915 | 1953915 | 2021-11-26 | Clay | Iowa | 19041 | 2957 | 36 |
1955933 | 1955933 | 2021-11-26 | Shelby | Texas | 48419 | 2957 | 111 |
1950664 | 1950664 | 2021-11-25 | Clay | Iowa | 19041 | 2957 | 36 |
1952682 | 1952682 | 2021-11-25 | Shelby | Texas | 48419 | 2957 | 111 |
1947413 | 1947413 | 2021-11-24 | Clay | Iowa | 19041 | 2957 | 36 |
1949431 | 1949431 | 2021-11-24 | Shelby | Texas | 48419 | 2957 | 111 |
1943611 | 1943611 | 2021-11-23 | Elbert | Colorado | 8039 | 2957 | 26 |
1894169 | 1894169 | 2021-11-07 | Robertson | Texas | 48395 | 2957 | 64 |
1890919 | 1890919 | 2021-11-06 | Robertson | Texas | 48395 | 2957 | 64 |
1882067 | 1882067 | 2021-11-04 | Jeff Davis | Georgia | 13161 | 2957 | 59 |
1857193 | 1857193 | 2021-10-27 | Ray | Missouri | 29177 | 2957 | 50 |
1853963 | 1853963 | 2021-10-26 | Texas | Missouri | 29215 | 2957 | 42 |
1836597 | 1836597 | 2021-10-21 | Meriwether | Georgia | 13199 | 2957 | 109 |
1833348 | 1833348 | 2021-10-20 | Meriwether | Georgia | 13199 | 2957 | 109 |
1826925 | 1826925 | 2021-10-18 | Blaine | Idaho | 16013 | 2957 | 23 |
1814981 | 1814981 | 2021-10-14 | Big Horn | Montana | 30003 | 2957 | 81 |
1811733 | 1811733 | 2021-10-13 | Big Horn | Montana | 30003 | 2957 | 81 |
1803051 | 1803051 | 2021-10-10 | DeWitt | Texas | 48123 | 2957 | 79 |
1799802 | 1799802 | 2021-10-09 | DeWitt | Texas | 48123 | 2957 | 79 |
1796553 | 1796553 | 2021-10-08 | DeWitt | Texas | 48123 | 2957 | 79 |
1769624 | 1769624 | 2021-09-30 | Saunders | Nebraska | 31155 | 2957 | 20 |
1765677 | 1765677 | 2021-09-29 | Harrison | Kentucky | 21097 | 2957 | 29 |
1746544 | 1746544 | 2021-09-23 | Waseca | Minnesota | 27161 | 2957 | 25 |
1724248 | 1724248 | 2021-09-16 | Delaware | New York | 36025 | 2957 | 40 |
1722146 | 1722146 | 2021-09-15 | Mecklenburg | Virginia | 51117 | 2957 | 73 |
1709547 | 1709547 | 2021-09-12 | Lawrence | Arkansas | 5075 | 2957 | 47 |
1710467 | 1710467 | 2021-09-12 | Letcher | Kentucky | 21133 | 2957 | 52 |
1711732 | 1711732 | 2021-09-12 | Aguadilla | Puerto Rico | 72005 | 2957 | |
1707220 | 1707220 | 2021-09-11 | Letcher | Kentucky | 21133 | 2957 | 52 |
1703972 | 1703972 | 2021-09-10 | Letcher | Kentucky | 21133 | 2957 | 52 |
1664320 | 1664320 | 2021-08-29 | Berrien | Georgia | 13019 | 2957 | 52 |
1660796 | 1660796 | 2021-08-28 | Columbia | Arkansas | 5027 | 2957 | 61 |
1661072 | 1661072 | 2021-08-28 | Berrien | Georgia | 13019 | 2957 | 52 |
1657824 | 1657824 | 2021-08-27 | Berrien | Georgia | 13019 | 2957 | 52 |
1656566 | 1656566 | 2021-08-26 | Rio Grande | Puerto Rico | 72119 | 2957 | |
1657267 | 1657267 | 2021-08-26 | Stevens | Washington | 53065 | 2957 | 34 |
1643416 | 1643416 | 2021-08-22 | Coos | Oregon | 41011 | 2957 | 46 |
1638054 | 1638054 | 2021-08-21 | Cleburne | Arkansas | 5023 | 2957 | 77 |
1640166 | 1640166 | 2021-08-21 | Coos | Oregon | 41011 | 2957 | 46 |
1636916 | 1636916 | 2021-08-20 | Coos | Oregon | 41011 | 2957 | 46 |
1634601 | 1634601 | 2021-08-19 | Door | Wisconsin | 55029 | 2957 | 37 |
1627728 | 1627728 | 2021-08-17 | Milam | Texas | 48331 | 2957 | 55 |
1617553 | 1617553 | 2021-08-14 | Dorado | Puerto Rico | 72051 | 2957 | |
1614033 | 1614033 | 2021-08-13 | Fayette | Ohio | 39047 | 2957 | 50 |
1599727 | 1599727 | 2021-08-09 | Scott | Indiana | 18143 | 2957 | 60 |
1596917 | 1596917 | 2021-08-08 | Dorchester | Maryland | 24019 | 2957 | 65 |
1571322 | 1571322 | 2021-07-31 | Washington | Missouri | 29221 | 2957 | 53 |
1517190 | 1517190 | 2021-07-14 | Deaf Smith | Texas | 48117 | 2957 | 68 |
1513943 | 1513943 | 2021-07-13 | Deaf Smith | Texas | 48117 | 2957 | 68 |
1492854 | 1492854 | 2021-07-07 | Logan | Kentucky | 21141 | 2957 | 73 |
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);