ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 5059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Kentucky 8
- Illinois 7
- Pennsylvania 7
- Virginia 6
- North Carolina 5
- Texas 5
- Alabama 4
- Louisiana 4
- Mississippi 4
- Puerto Rico 4
- New York 3
- North Dakota 3
- Tennessee 3
- Arkansas 2
- Georgia 2
- Missouri 2
- Ohio 2
- Wisconsin 2
- California 1
- Colorado 1
- Florida 1
- Indiana 1
- Iowa 1
- New Mexico 1
- Oregon 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500680 | 2500680 | 2022-05-13 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2501156 | 2501156 | 2022-05-13 | Perry | Missouri | 29157 | 5059 | 46 |
2497422 | 2497422 | 2022-05-12 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2494164 | 2494164 | 2022-05-11 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2490906 | 2490906 | 2022-05-10 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2487649 | 2487649 | 2022-05-09 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2424678 | 2424678 | 2022-04-20 | Butler | Alabama | 1013 | 5059 | 129 |
2421422 | 2421422 | 2022-04-19 | Butler | Alabama | 1013 | 5059 | 129 |
2356096 | 2356096 | 2022-03-29 | Powhatan | Virginia | 51145 | 5059 | 57 |
2348527 | 2348527 | 2022-03-27 | Madison | North Carolina | 37115 | 5059 | 79 |
2345274 | 2345274 | 2022-03-26 | Madison | North Carolina | 37115 | 5059 | 79 |
2342021 | 2342021 | 2022-03-25 | Madison | North Carolina | 37115 | 5059 | 79 |
2338768 | 2338768 | 2022-03-24 | Madison | North Carolina | 37115 | 5059 | 79 |
2264767 | 2264767 | 2022-03-01 | Limestone | Texas | 48293 | 5059 | 122 |
2254343 | 2254343 | 2022-02-26 | Holmes | Ohio | 39075 | 5059 | 180 |
2193677 | 2193677 | 2022-02-07 | Vilas | Wisconsin | 55125 | 5059 | 83 |
2189581 | 2189581 | 2022-02-06 | Las Piedras | Puerto Rico | 72085 | 5059 | |
2114716 | 2114716 | 2022-01-14 | Aguada | Puerto Rico | 72003 | 5059 | |
2106521 | 2106521 | 2022-01-12 | Jersey | Illinois | 17083 | 5059 | 77 |
2091986 | 2091986 | 2022-01-07 | Gurabo | Puerto Rico | 72063 | 5059 | |
2086052 | 2086052 | 2022-01-05 | Amherst | Virginia | 51009 | 5059 | 63 |
2082259 | 2082259 | 2022-01-04 | Rio Grande | Puerto Rico | 72119 | 5059 | |
2004179 | 2004179 | 2021-12-11 | Susquehanna | Pennsylvania | 42115 | 5059 | 79 |
1988730 | 1988730 | 2021-12-06 | Mineral | West Virginia | 54057 | 5059 | 127 |
1901150 | 1901150 | 2021-11-10 | Pike | Alabama | 1109 | 5059 | 108 |
1897900 | 1897900 | 2021-11-09 | Pike | Alabama | 1109 | 5059 | 108 |
1892781 | 1892781 | 2021-11-07 | George | Mississippi | 28039 | 5059 | 80 |
1889531 | 1889531 | 2021-11-06 | George | Mississippi | 28039 | 5059 | 80 |
1886281 | 1886281 | 2021-11-05 | George | Mississippi | 28039 | 5059 | 80 |
1852110 | 1852110 | 2021-10-25 | Manassas city | Virginia | 51683 | 5059 | 52 |
1811144 | 1811144 | 2021-10-13 | Clay | Kentucky | 21051 | 5059 | 56 |
1750710 | 1750710 | 2021-09-24 | Venango | Pennsylvania | 42121 | 5059 | 109 |
1717979 | 1717979 | 2021-09-14 | Fulton | Ohio | 39051 | 5059 | 81 |
1648369 | 1648369 | 2021-08-24 | Stephenson | Illinois | 17177 | 5059 | 106 |
1638135 | 1638135 | 2021-08-21 | Lake | California | 6033 | 5059 | 69 |
1624234 | 1624234 | 2021-08-16 | Cocke | Tennessee | 47029 | 5059 | 102 |
1601002 | 1601002 | 2021-08-09 | Stark | North Dakota | 38089 | 5059 | 52 |
1597754 | 1597754 | 2021-08-08 | Stark | North Dakota | 38089 | 5059 | 52 |
1518006 | 1518006 | 2021-07-15 | Broomfield | Colorado | 8014 | 5059 | 76 |
1520806 | 1520806 | 2021-07-15 | Washington | Virginia | 51191 | 5059 | 111 |
1516564 | 1516564 | 2021-07-14 | Williams | North Dakota | 38105 | 5059 | 40 |
1378821 | 1378821 | 2021-06-02 | Henry | Illinois | 17073 | 5059 | 98 |
1375575 | 1375575 | 2021-06-01 | Henry | Illinois | 17073 | 5059 | 98 |
1372330 | 1372330 | 2021-05-31 | Henry | Illinois | 17073 | 5059 | 98 |
1353322 | 1353322 | 2021-05-25 | Scott | Kentucky | 21209 | 5059 | 33 |
1353335 | 1353335 | 2021-05-25 | Whitley | Kentucky | 21235 | 5059 | 57 |
1348383 | 1348383 | 2021-05-23 | Chambers | Texas | 48071 | 5059 | 49 |
1345135 | 1345135 | 2021-05-22 | Chambers | Texas | 48071 | 5059 | 49 |
1341887 | 1341887 | 2021-05-21 | Chambers | Texas | 48071 | 5059 | 49 |
1298887 | 1298887 | 2021-05-08 | Herkimer | New York | 36043 | 5059 | 107 |
1210521 | 1210521 | 2021-04-11 | St. Martin | Louisiana | 22099 | 5059 | 115 |
1207272 | 1207272 | 2021-04-10 | St. Martin | Louisiana | 22099 | 5059 | 115 |
1204024 | 1204024 | 2021-04-09 | St. Martin | Louisiana | 22099 | 5059 | 115 |
1197246 | 1197246 | 2021-04-07 | Webster | Iowa | 19187 | 5059 | 90 |
1155716 | 1155716 | 2021-03-25 | Pettis | Missouri | 29159 | 5059 | 77 |
1146662 | 1146662 | 2021-03-22 | Armstrong | Pennsylvania | 42005 | 5059 | 118 |
1135305 | 1135305 | 2021-03-19 | Knox | Illinois | 17095 | 5059 | 164 |
1113875 | 1113875 | 2021-03-12 | Halifax | North Carolina | 37083 | 5059 | 102 |
1037659 | 1037659 | 2021-02-17 | Suwannee | Florida | 12121 | 5059 | 125 |
1036352 | 1036352 | 2021-02-16 | Union | Pennsylvania | 42119 | 5059 | 80 |
1027962 | 1027962 | 2021-02-14 | Coffee | Georgia | 13069 | 5059 | 138 |
1007370 | 1007370 | 2021-02-07 | Dyer | Tennessee | 47045 | 5059 | 92 |
962784 | 962784 | 2021-01-25 | Mississippi | Arkansas | 5093 | 5059 | 103 |
954772 | 954772 | 2021-01-22 | Oswego | New York | 36075 | 5059 | 74 |
942889 | 942889 | 2021-01-18 | Harrisonburg city | Virginia | 51660 | 5059 | 53 |
918650 | 918650 | 2021-01-11 | Lowndes | Mississippi | 28087 | 5059 | 100 |
906474 | 906474 | 2021-01-07 | Adams | Pennsylvania | 42001 | 5059 | 108 |
854589 | 854589 | 2020-12-22 | Lycoming | Pennsylvania | 42081 | 5059 | 98 |
796647 | 796647 | 2020-12-04 | Maverick | Texas | 48323 | 5059 | 174 |
742588 | 742588 | 2020-11-18 | LaSalle | Illinois | 17099 | 5059 | 107 |
733354 | 733354 | 2020-11-15 | Livingston | Louisiana | 22063 | 5059 | 87 |
731565 | 731565 | 2020-11-14 | Sullivan | Tennessee | 47163 | 5059 | 77 |
625935 | 625935 | 2020-10-13 | Vanderburgh | Indiana | 18163 | 5059 | 45 |
611188 | 611188 | 2020-10-08 | Marion | Oregon | 41047 | 5059 | 101 |
599189 | 599189 | 2020-10-04 | Winnebago | Wisconsin | 55139 | 5059 | 34 |
552461 | 552461 | 2020-09-20 | Dutchess | New York | 36027 | 5059 | 156 |
436522 | 436522 | 2020-08-15 | Lehigh | Pennsylvania | 42077 | 5059 | 341 |
418538 | 418538 | 2020-08-10 | Clayton | Georgia | 13063 | 5059 | 110 |
410253 | 410253 | 2020-08-07 | Bernalillo | New Mexico | 35001 | 5059 | 130 |
398552 | 398552 | 2020-08-03 | Loudoun | Virginia | 51107 | 5059 | 112 |
344409 | 344409 | 2020-07-18 | Washington | Arkansas | 5143 | 5059 | 37 |
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);