ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where cases = 4965 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kentucky 12
- Texas 10
- Mississippi 8
- Michigan 7
- North Carolina 6
- Georgia 5
- Indiana 4
- New York 4
- Ohio 4
- Arkansas 3
- Louisiana 3
- Minnesota 3
- Pennsylvania 3
- South Carolina 3
- Virginia 3
- Iowa 2
- Maryland 2
- Missouri 2
- Nevada 2
- North Dakota 2
- Tennessee 2
- Wisconsin 2
- Idaho 1
- Illinois 1
- New Mexico 1
- Oklahoma 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473291 | 2473291 | 2022-05-04 | Radford city | Virginia | 51750 | 4965 | 53 |
2461918 | 2461918 | 2022-05-01 | Clay | Mississippi | 28025 | 4965 | 98 |
2458662 | 2458662 | 2022-04-30 | Clay | Mississippi | 28025 | 4965 | 98 |
2455406 | 2455406 | 2022-04-29 | Clay | Mississippi | 28025 | 4965 | 98 |
2452150 | 2452150 | 2022-04-28 | Clay | Mississippi | 28025 | 4965 | 98 |
2448894 | 2448894 | 2022-04-27 | Clay | Mississippi | 28025 | 4965 | 98 |
2445638 | 2445638 | 2022-04-26 | Clay | Mississippi | 28025 | 4965 | 98 |
2283347 | 2283347 | 2022-03-07 | Roosevelt | New Mexico | 35041 | 4965 | 92 |
2256596 | 2256596 | 2022-02-27 | Rockcastle | Kentucky | 21203 | 4965 | 55 |
2257455 | 2257455 | 2022-02-27 | Madison | North Carolina | 37115 | 4965 | 78 |
2253345 | 2253345 | 2022-02-26 | Rockcastle | Kentucky | 21203 | 4965 | 55 |
2254204 | 2254204 | 2022-02-26 | Madison | North Carolina | 37115 | 4965 | 78 |
2250094 | 2250094 | 2022-02-25 | Rockcastle | Kentucky | 21203 | 4965 | 55 |
2250953 | 2250953 | 2022-02-25 | Madison | North Carolina | 37115 | 4965 | 78 |
2248392 | 2248392 | 2022-02-24 | Burleson | Texas | 48051 | 4965 | 65 |
2228566 | 2228566 | 2022-02-18 | Wyoming | Pennsylvania | 42131 | 4965 | 98 |
2213342 | 2213342 | 2022-02-14 | Ashley | Arkansas | 5003 | 4965 | 57 |
2210090 | 2210090 | 2022-02-13 | Ashley | Arkansas | 5003 | 4965 | 57 |
2194275 | 2194275 | 2022-02-08 | Blaine | Idaho | 16013 | 4965 | 29 |
2190902 | 2190902 | 2022-02-07 | Fannin | Georgia | 13111 | 4965 | 129 |
2163281 | 2163281 | 2022-01-29 | Holmes | Ohio | 39075 | 4965 | 167 |
2146081 | 2146081 | 2022-01-24 | St. James | Louisiana | 22093 | 4965 | 73 |
2136362 | 2136362 | 2022-01-21 | Garrett | Maryland | 24023 | 4965 | 103 |
2130408 | 2130408 | 2022-01-19 | Churchill | Nevada | 32001 | 4965 | 92 |
2123212 | 2123212 | 2022-01-17 | Marion | Kentucky | 21155 | 4965 | 64 |
2119960 | 2119960 | 2022-01-16 | Marion | Kentucky | 21155 | 4965 | 64 |
2116708 | 2116708 | 2022-01-15 | Marion | Kentucky | 21155 | 4965 | 64 |
2113457 | 2113457 | 2022-01-14 | Marion | Kentucky | 21155 | 4965 | 64 |
2089388 | 2089388 | 2022-01-06 | Orange | Virginia | 51137 | 4965 | 69 |
2051700 | 2051700 | 2021-12-26 | Montgomery | Kentucky | 21173 | 4965 | 71 |
2048450 | 2048450 | 2021-12-25 | Montgomery | Kentucky | 21173 | 4965 | 71 |
2045200 | 2045200 | 2021-12-24 | Montgomery | Kentucky | 21173 | 4965 | 71 |
2041951 | 2041951 | 2021-12-23 | Montgomery | Kentucky | 21173 | 4965 | 71 |
2038701 | 2038701 | 2021-12-22 | Montgomery | Kentucky | 21173 | 4965 | 71 |
2038948 | 2038948 | 2021-12-22 | Brown | Minnesota | 27015 | 4965 | 66 |
2031564 | 2031564 | 2021-12-20 | Gilmer | Georgia | 13123 | 4965 | 140 |
2017729 | 2017729 | 2021-12-15 | Willacy | Texas | 48489 | 4965 | 114 |
2014479 | 2014479 | 2021-12-14 | Willacy | Texas | 48489 | 4965 | 114 |
2009082 | 2009082 | 2021-12-13 | Fayette | Indiana | 18041 | 4965 | 105 |
2010809 | 2010809 | 2021-12-13 | Marlboro | South Carolina | 45069 | 4965 | 84 |
1944730 | 1944730 | 2021-11-23 | Pine | Minnesota | 27115 | 4965 | 41 |
1942215 | 1942215 | 2021-11-22 | Morrow | Ohio | 39117 | 4965 | 63 |
1888262 | 1888262 | 2021-11-06 | Poinsett | Arkansas | 5111 | 4965 | 101 |
1882872 | 1882872 | 2021-11-04 | Huron | Michigan | 26063 | 4965 | 97 |
1879623 | 1879623 | 2021-11-03 | Huron | Michigan | 26063 | 4965 | 97 |
1851805 | 1851805 | 2021-10-25 | Fannin | Texas | 48147 | 4965 | 149 |
1848555 | 1848555 | 2021-10-24 | Fannin | Texas | 48147 | 4965 | 149 |
1845305 | 1845305 | 2021-10-23 | Fannin | Texas | 48147 | 4965 | 149 |
1834294 | 1834294 | 2021-10-20 | George | Mississippi | 28039 | 4965 | 79 |
1808255 | 1808255 | 2021-10-12 | Polk | Minnesota | 27119 | 4965 | 75 |
1799433 | 1799433 | 2021-10-09 | Perry | Pennsylvania | 42099 | 4965 | 111 |
1783998 | 1783998 | 2021-10-04 | Marshall | West Virginia | 54051 | 4965 | 99 |
1715212 | 1715212 | 2021-09-13 | Henry | Tennessee | 47079 | 4965 | 76 |
1664635 | 1664635 | 2021-08-29 | Clinton | Indiana | 18023 | 4965 | 64 |
1661387 | 1661387 | 2021-08-28 | Clinton | Indiana | 18023 | 4965 | 64 |
1658139 | 1658139 | 2021-08-27 | Clinton | Indiana | 18023 | 4965 | 64 |
1597009 | 1597009 | 2021-08-08 | Newaygo | Michigan | 26123 | 4965 | 69 |
1593760 | 1593760 | 2021-08-07 | Newaygo | Michigan | 26123 | 4965 | 69 |
1590511 | 1590511 | 2021-08-06 | Newaygo | Michigan | 26123 | 4965 | 69 |
1388459 | 1388459 | 2021-06-05 | Ware | Georgia | 13299 | 4965 | 177 |
1383486 | 1383486 | 2021-06-03 | Williams | North Dakota | 38105 | 4965 | 40 |
1380240 | 1380240 | 2021-06-02 | Williams | North Dakota | 38105 | 4965 | 40 |
1347719 | 1347719 | 2021-05-23 | Vance | North Carolina | 37181 | 4965 | 87 |
1344471 | 1344471 | 2021-05-22 | Vance | North Carolina | 37181 | 4965 | 87 |
1341223 | 1341223 | 2021-05-21 | Vance | North Carolina | 37181 | 4965 | 87 |
1332686 | 1332686 | 2021-05-18 | Pierce | Wisconsin | 55093 | 4965 | 43 |
1307256 | 1307256 | 2021-05-11 | Murray | Georgia | 13213 | 4965 | 86 |
1305024 | 1305024 | 2021-05-10 | Callaway | Missouri | 29027 | 4965 | 49 |
1301778 | 1301778 | 2021-05-09 | Callaway | Missouri | 29027 | 4965 | 49 |
1293187 | 1293187 | 2021-05-06 | Chambers | Texas | 48071 | 4965 | 49 |
1286487 | 1286487 | 2021-05-04 | Newberry | South Carolina | 45071 | 4965 | 101 |
1259928 | 1259928 | 2021-04-26 | Herkimer | New York | 36043 | 4965 | 107 |
1207966 | 1207966 | 2021-04-10 | Genesee | New York | 36037 | 4965 | 121 |
1148814 | 1148814 | 2021-03-23 | St. Martin | Louisiana | 22099 | 4965 | 115 |
1113824 | 1113824 | 2021-03-12 | Sullivan | New York | 36105 | 4965 | 60 |
1110551 | 1110551 | 2021-03-11 | Jefferson | New York | 36045 | 4965 | 63 |
1034918 | 1034918 | 2021-02-16 | Warren | Iowa | 19181 | 4965 | 69 |
1031243 | 1031243 | 2021-02-15 | Habersham | Georgia | 13137 | 4965 | 135 |
1032864 | 1032864 | 2021-02-15 | Darke | Ohio | 39037 | 4965 | 118 |
981400 | 981400 | 2021-01-30 | Dyer | Tennessee | 47045 | 4965 | 87 |
967361 | 967361 | 2021-01-26 | Washington | Mississippi | 28151 | 4965 | 125 |
806825 | 806825 | 2020-12-07 | Wood | Wisconsin | 55141 | 4965 | 39 |
773263 | 773263 | 2020-11-27 | Medina | Ohio | 39103 | 4965 | 57 |
733482 | 733482 | 2020-11-15 | Jackson | Michigan | 26075 | 4965 | 106 |
730237 | 730237 | 2020-11-14 | Jackson | Michigan | 26075 | 4965 | 106 |
625952 | 625952 | 2020-10-13 | Black Hawk | Iowa | 19013 | 4965 | 96 |
598657 | 598657 | 2020-10-04 | Ector | Texas | 48135 | 4965 | 100 |
595414 | 595414 | 2020-10-03 | Ector | Texas | 48135 | 4965 | 100 |
592172 | 592172 | 2020-10-02 | Ector | Texas | 48135 | 4965 | 100 |
531842 | 531842 | 2020-09-14 | Madison | Illinois | 17119 | 4965 | 121 |
530106 | 530106 | 2020-09-13 | Cleveland | Oklahoma | 40027 | 4965 | 68 |
514185 | 514185 | 2020-09-08 | Berkeley | South Carolina | 45015 | 4965 | 84 |
397841 | 397841 | 2020-08-03 | Chester | Pennsylvania | 42029 | 4965 | 348 |
381262 | 381262 | 2020-07-29 | Washoe | Nevada | 32031 | 4965 | 111 |
382468 | 382468 | 2020-07-29 | Loudoun | Virginia | 51107 | 4965 | 109 |
348548 | 348548 | 2020-07-19 | Caddo | Louisiana | 22017 | 4965 | 257 |
269388 | 269388 | 2020-06-24 | Anne Arundel | Maryland | 24003 | 4965 | 202 |
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);