ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 5756 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 15
- Oklahoma 8
- Tennessee 7
- Minnesota 6
- New Mexico 5
- Puerto Rico 5
- Utah 5
- Florida 3
- Kansas 3
- Mississippi 3
- Ohio 3
- West Virginia 3
- Arizona 2
- Indiana 2
- Michigan 2
- South Carolina 2
- Virginia 2
- Arkansas 1
- Colorado 1
- Georgia 1
- Illinois 1
- Iowa 1
- Maryland 1
- Nevada 1
- New York 1
- North Carolina 1
- North Dakota 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476207 | 2476207 | 2022-05-05 | Dimmit | Texas | 48127 | 5756 | 51 |
2472950 | 2472950 | 2022-05-04 | Dimmit | Texas | 48127 | 5756 | 51 |
2469694 | 2469694 | 2022-05-03 | Dimmit | Texas | 48127 | 5756 | 51 |
2466438 | 2466438 | 2022-05-02 | Dimmit | Texas | 48127 | 5756 | 51 |
2463183 | 2463183 | 2022-05-01 | Dimmit | Texas | 48127 | 5756 | 51 |
2459927 | 2459927 | 2022-04-30 | Dimmit | Texas | 48127 | 5756 | 51 |
2456671 | 2456671 | 2022-04-29 | Dimmit | Texas | 48127 | 5756 | 51 |
2453359 | 2453359 | 2022-04-28 | Austin | Texas | 48015 | 5756 | 73 |
2387959 | 2387959 | 2022-04-08 | Cayey | Puerto Rico | 72035 | 5756 | |
2336260 | 2336260 | 2022-03-23 | Frio | Texas | 48163 | 5756 | 93 |
2312618 | 2312618 | 2022-03-16 | San Miguel | New Mexico | 35047 | 5756 | 52 |
2293211 | 2293211 | 2022-03-10 | Greene | North Carolina | 37079 | 5756 | 56 |
2265108 | 2265108 | 2022-03-01 | Hampshire | West Virginia | 54027 | 5756 | 67 |
2237361 | 2237361 | 2022-02-21 | Meeker | Minnesota | 27093 | 5756 | 74 |
2234110 | 2234110 | 2022-02-20 | Meeker | Minnesota | 27093 | 5756 | 74 |
2230859 | 2230859 | 2022-02-19 | Meeker | Minnesota | 27093 | 5756 | 74 |
2227608 | 2227608 | 2022-02-18 | Meeker | Minnesota | 27093 | 5756 | 74 |
2228279 | 2228279 | 2022-02-18 | Rolette | North Dakota | 38079 | 5756 | 41 |
2209106 | 2209106 | 2022-02-12 | Manati | Puerto Rico | 72091 | 5756 | |
2181908 | 2181908 | 2022-02-04 | Caroline | Maryland | 24011 | 5756 | 67 |
2154574 | 2154574 | 2022-01-26 | Wyoming | West Virginia | 54109 | 5756 | 80 |
2123954 | 2123954 | 2022-01-17 | Cibola | New Mexico | 35006 | 5756 | 162 |
2124484 | 2124484 | 2022-01-17 | Canovanas | Puerto Rico | 72029 | 5756 | |
2120702 | 2120702 | 2022-01-16 | Cibola | New Mexico | 35006 | 5756 | 162 |
2117450 | 2117450 | 2022-01-15 | Cibola | New Mexico | 35006 | 5756 | 162 |
2114199 | 2114199 | 2022-01-14 | Cibola | New Mexico | 35006 | 5756 | 162 |
2102050 | 2102050 | 2022-01-10 | Cooke | Texas | 48097 | 5756 | 114 |
2034254 | 2034254 | 2021-12-20 | Randolph | West Virginia | 54083 | 5756 | 61 |
2014071 | 2014071 | 2021-12-14 | Williamsburg | South Carolina | 45089 | 5756 | 129 |
1989788 | 1989788 | 2021-12-07 | Harvey | Kansas | 20079 | 5756 | 93 |
1986538 | 1986538 | 2021-12-06 | Harvey | Kansas | 20079 | 5756 | 93 |
1909743 | 1909743 | 2021-11-12 | Williams | Ohio | 39171 | 5756 | 93 |
1884646 | 1884646 | 2021-11-04 | Tazewell | Virginia | 51185 | 5756 | 107 |
1881211 | 1881211 | 2021-11-03 | Washington | Texas | 48477 | 5756 | 128 |
1877962 | 1877962 | 2021-11-02 | Washington | Texas | 48477 | 5756 | 128 |
1874417 | 1874417 | 2021-11-01 | Henderson | Tennessee | 47077 | 5756 | 102 |
1871168 | 1871168 | 2021-10-31 | Henderson | Tennessee | 47077 | 5756 | 102 |
1867919 | 1867919 | 2021-10-30 | Henderson | Tennessee | 47077 | 5756 | 102 |
1864670 | 1864670 | 2021-10-29 | Henderson | Tennessee | 47077 | 5756 | 102 |
1763586 | 1763586 | 2021-09-28 | Ottawa | Oklahoma | 40115 | 5756 | 86 |
1760337 | 1760337 | 2021-09-27 | Ottawa | Oklahoma | 40115 | 5756 | 86 |
1757089 | 1757089 | 2021-09-26 | Ottawa | Oklahoma | 40115 | 5756 | 86 |
1753841 | 1753841 | 2021-09-25 | Ottawa | Oklahoma | 40115 | 5756 | 86 |
1750593 | 1750593 | 2021-09-24 | Ottawa | Oklahoma | 40115 | 5756 | 86 |
1747343 | 1747343 | 2021-09-23 | Ottawa | Oklahoma | 40115 | 5756 | 86 |
1744094 | 1744094 | 2021-09-22 | Ottawa | Oklahoma | 40115 | 5756 | 86 |
1712155 | 1712155 | 2021-09-12 | Kerr | Texas | 48265 | 5756 | 107 |
1708908 | 1708908 | 2021-09-11 | Kerr | Texas | 48265 | 5756 | 107 |
1705661 | 1705661 | 2021-09-10 | Kerr | Texas | 48265 | 5756 | 107 |
1698999 | 1698999 | 2021-09-08 | Obion | Tennessee | 47131 | 5756 | 101 |
1688079 | 1688079 | 2021-09-05 | Bolivar | Mississippi | 28011 | 5756 | 140 |
1684829 | 1684829 | 2021-09-04 | Bolivar | Mississippi | 28011 | 5756 | 140 |
1681578 | 1681578 | 2021-09-03 | Bolivar | Mississippi | 28011 | 5756 | 140 |
1605551 | 1605551 | 2021-08-11 | Graham | Arizona | 4009 | 5756 | 89 |
1556374 | 1556374 | 2021-07-26 | Summit | Utah | 49043 | 5756 | 15 |
1535841 | 1535841 | 2021-07-20 | Cattaraugus | New York | 36009 | 5756 | 92 |
1523882 | 1523882 | 2021-07-16 | Box Elder | Utah | 49003 | 5756 | 56 |
1520634 | 1520634 | 2021-07-15 | Box Elder | Utah | 49003 | 5756 | 56 |
1517386 | 1517386 | 2021-07-14 | Box Elder | Utah | 49003 | 5756 | 56 |
1514139 | 1514139 | 2021-07-13 | Box Elder | Utah | 49003 | 5756 | 56 |
1489041 | 1489041 | 2021-07-06 | Polk | Georgia | 13233 | 5756 | 100 |
1477652 | 1477652 | 2021-07-02 | Lawrence | Ohio | 39087 | 5756 | 103 |
1474406 | 1474406 | 2021-07-01 | Lawrence | Ohio | 39087 | 5756 | 103 |
1401517 | 1401517 | 2021-06-09 | Coles | Illinois | 17029 | 5756 | 102 |
1304402 | 1304402 | 2021-05-10 | Warren | Iowa | 19181 | 5756 | 88 |
1296708 | 1296708 | 2021-05-07 | Augusta | Virginia | 51015 | 5756 | 71 |
1278837 | 1278837 | 2021-05-02 | Marquette | Michigan | 26103 | 5756 | 59 |
1275590 | 1275590 | 2021-05-01 | Marquette | Michigan | 26103 | 5756 | 59 |
1223094 | 1223094 | 2021-04-15 | Marshall | Indiana | 18099 | 5756 | 109 |
1183521 | 1183521 | 2021-04-03 | Mississippi | Arkansas | 5093 | 5756 | 106 |
1177134 | 1177134 | 2021-04-01 | Eagle | Colorado | 8037 | 5756 | 22 |
1107780 | 1107780 | 2021-03-10 | Caguas | Puerto Rico | 72025 | 5756 | |
1108009 | 1108009 | 2021-03-10 | Jefferson | Tennessee | 47089 | 5756 | 120 |
1104534 | 1104534 | 2021-03-09 | Caguas | Puerto Rico | 72025 | 5756 | |
1062524 | 1062524 | 2021-02-24 | Bedford | Tennessee | 47003 | 5756 | 117 |
1051619 | 1051619 | 2021-02-21 | Kandiyohi | Minnesota | 27067 | 5756 | 74 |
959481 | 959481 | 2021-01-24 | Gila | Arizona | 4007 | 5756 | 179 |
927850 | 927850 | 2021-01-14 | Finney | Kansas | 20055 | 5756 | 42 |
788127 | 788127 | 2020-12-02 | Madison | Indiana | 18095 | 5756 | 138 |
736846 | 736846 | 2020-11-16 | St. Louis | Minnesota | 27137 | 5756 | 84 |
651490 | 651490 | 2020-10-21 | Santa Rosa | Florida | 12113 | 5756 | 86 |
625531 | 625531 | 2020-10-13 | St. Johns | Florida | 12109 | 5756 | 77 |
447497 | 447497 | 2020-08-19 | Lake | Florida | 12069 | 5756 | 91 |
413438 | 413438 | 2020-08-08 | Washoe | Nevada | 32031 | 5756 | 118 |
407514 | 407514 | 2020-08-06 | Lancaster | Pennsylvania | 42071 | 5756 | 410 |
343444 | 343444 | 2020-07-17 | Richland | South Carolina | 45079 | 5756 | 105 |
339997 | 339997 | 2020-07-16 | Oklahoma | Oklahoma | 40109 | 5756 | 77 |
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);