ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 5245 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Georgia 9
- Indiana 7
- Ohio 6
- Missouri 5
- Texas 5
- Illinois 4
- Mississippi 4
- New Mexico 4
- North Carolina 4
- New York 3
- Puerto Rico 3
- Alabama 2
- Arkansas 2
- Tennessee 2
- Virginia 2
- Florida 1
- Kentucky 1
- Louisiana 1
- Minnesota 1
- Oregon 1
- Pennsylvania 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492833 | 2492833 | 2022-05-10 | Powhatan | Virginia | 51145 | 5245 | 59 |
2444699 | 2444699 | 2022-04-26 | Mitchell | Georgia | 13205 | 5245 | 117 |
2441443 | 2441443 | 2022-04-25 | Mitchell | Georgia | 13205 | 5245 | 117 |
2438187 | 2438187 | 2022-04-24 | Mitchell | Georgia | 13205 | 5245 | 117 |
2434931 | 2434931 | 2022-04-23 | Mitchell | Georgia | 13205 | 5245 | 117 |
2431675 | 2431675 | 2022-04-22 | Mitchell | Georgia | 13205 | 5245 | 117 |
2428419 | 2428419 | 2022-04-21 | Mitchell | Georgia | 13205 | 5245 | 117 |
2425163 | 2425163 | 2022-04-20 | Mitchell | Georgia | 13205 | 5245 | 117 |
2387985 | 2387985 | 2022-04-08 | Las Piedras | Puerto Rico | 72085 | 5245 | |
2339205 | 2339205 | 2022-03-24 | San Lorenzo | Puerto Rico | 72129 | 5245 | |
2286835 | 2286835 | 2022-03-08 | Carroll | Ohio | 39019 | 5245 | 122 |
2283583 | 2283583 | 2022-03-07 | Carroll | Ohio | 39019 | 5245 | 122 |
2263104 | 2263104 | 2022-03-01 | Spencer | Kentucky | 21215 | 5245 | 50 |
2249115 | 2249115 | 2022-02-25 | Columbia | Arkansas | 5027 | 5245 | 83 |
2243270 | 2243270 | 2022-02-23 | Sullivan | Indiana | 18153 | 5245 | 72 |
2057836 | 2057836 | 2021-12-28 | Fayette | Indiana | 18041 | 5245 | 115 |
2004530 | 2004530 | 2021-12-11 | Cooke | Texas | 48097 | 5245 | 105 |
1943122 | 1943122 | 2021-11-22 | Prince George | Virginia | 51149 | 5245 | 51 |
1938822 | 1938822 | 2021-11-21 | Person | North Carolina | 37145 | 5245 | 88 |
1935572 | 1935572 | 2021-11-20 | Person | North Carolina | 37145 | 5245 | 88 |
1932322 | 1932322 | 2021-11-19 | Person | North Carolina | 37145 | 5245 | 88 |
1928702 | 1928702 | 2021-11-18 | Warren | Missouri | 29219 | 5245 | 71 |
1923171 | 1923171 | 2021-11-16 | Lauderdale | Tennessee | 47097 | 5245 | 69 |
1919422 | 1919422 | 2021-11-15 | Coshocton | Ohio | 39031 | 5245 | 97 |
1894619 | 1894619 | 2021-11-08 | Dallas | Alabama | 1047 | 5245 | 207 |
1873951 | 1873951 | 2021-11-01 | Jackson | Ohio | 39079 | 5245 | 78 |
1864228 | 1864228 | 2021-10-29 | Perry | Ohio | 39127 | 5245 | 70 |
1830278 | 1830278 | 2021-10-19 | Monroe | Illinois | 17133 | 5245 | 103 |
1831162 | 1831162 | 2021-10-19 | Laclede | Missouri | 29105 | 5245 | 127 |
1812017 | 1812017 | 2021-10-13 | Warren | New York | 36113 | 5245 | 81 |
1812347 | 1812347 | 2021-10-13 | Benton | Oregon | 41003 | 5245 | 30 |
1722331 | 1722331 | 2021-09-15 | Marinette | Wisconsin | 55075 | 5245 | 77 |
1717764 | 1717764 | 2021-09-14 | Madison | New York | 36053 | 5245 | 94 |
1701126 | 1701126 | 2021-09-09 | Pike | Mississippi | 28113 | 5245 | 128 |
1660814 | 1660814 | 2021-08-28 | Independence | Arkansas | 5063 | 5245 | 141 |
1652839 | 1652839 | 2021-08-25 | Beaufort | North Carolina | 37013 | 5245 | 105 |
1637439 | 1637439 | 2021-08-20 | Kerr | Texas | 48265 | 5245 | 97 |
1609337 | 1609337 | 2021-08-12 | Henry | Illinois | 17073 | 5245 | 99 |
1601740 | 1601740 | 2021-08-09 | Medina | Texas | 48325 | 5245 | 110 |
1596444 | 1596444 | 2021-08-08 | Jackson | Indiana | 18071 | 5245 | 78 |
1598492 | 1598492 | 2021-08-08 | Medina | Texas | 48325 | 5245 | 110 |
1593195 | 1593195 | 2021-08-07 | Jackson | Indiana | 18071 | 5245 | 78 |
1595243 | 1595243 | 2021-08-07 | Medina | Texas | 48325 | 5245 | 109 |
1589946 | 1589946 | 2021-08-06 | Jackson | Indiana | 18071 | 5245 | 78 |
1583859 | 1583859 | 2021-08-04 | Lincoln | Louisiana | 22061 | 5245 | 96 |
1487120 | 1487120 | 2021-07-05 | Otero | New Mexico | 35035 | 5245 | 81 |
1483874 | 1483874 | 2021-07-04 | Otero | New Mexico | 35035 | 5245 | 81 |
1480628 | 1480628 | 2021-07-03 | Otero | New Mexico | 35035 | 5245 | 81 |
1477381 | 1477381 | 2021-07-02 | Otero | New Mexico | 35035 | 5245 | 81 |
1451651 | 1451651 | 2021-06-24 | Athens | Ohio | 39009 | 5245 | 60 |
1341590 | 1341590 | 2021-05-21 | Guaynabo | Puerto Rico | 72061 | 5245 | |
1266126 | 1266126 | 2021-04-28 | Newton | Missouri | 29145 | 5245 | 75 |
1220425 | 1220425 | 2021-04-14 | Benton | Minnesota | 27009 | 5245 | 97 |
1178442 | 1178442 | 2021-04-01 | Newton | Missouri | 29145 | 5245 | 74 |
1171136 | 1171136 | 2021-03-30 | Noble | Indiana | 18113 | 5245 | 83 |
1156413 | 1156413 | 2021-03-25 | Carbon | Pennsylvania | 42025 | 5245 | 157 |
1123160 | 1123160 | 2021-03-15 | Washington | Mississippi | 28151 | 5245 | 131 |
1119913 | 1119913 | 2021-03-14 | Washington | Mississippi | 28151 | 5245 | 131 |
1116666 | 1116666 | 2021-03-13 | Washington | Mississippi | 28151 | 5245 | 131 |
1106070 | 1106070 | 2021-03-10 | Grundy | Illinois | 17063 | 5245 | 67 |
1078786 | 1078786 | 2021-03-01 | Hawkins | Tennessee | 47073 | 5245 | 94 |
1072994 | 1072994 | 2021-02-28 | Coffee | Alabama | 1031 | 5245 | 102 |
1034743 | 1034743 | 2021-02-16 | Cass | Indiana | 18017 | 5245 | 96 |
950158 | 950158 | 2021-01-21 | Rockdale | Georgia | 13247 | 5245 | 95 |
901355 | 901355 | 2021-01-06 | Walton | Florida | 12131 | 5245 | 51 |
634542 | 634542 | 2020-10-15 | Weber | Utah | 49057 | 5245 | 32 |
626695 | 626695 | 2020-10-13 | Jefferson | Missouri | 29099 | 5245 | 69 |
617280 | 617280 | 2020-10-10 | Dutchess | New York | 36027 | 5245 | 161 |
424980 | 424980 | 2020-08-12 | Clayton | Georgia | 13063 | 5245 | 114 |
130857 | 130857 | 2020-05-10 | Lake | Illinois | 17097 | 5245 | 173 |
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);