ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 5423 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Kentucky 12
- Florida 8
- Indiana 7
- Tennessee 6
- Pennsylvania 4
- South Carolina 4
- Virginia 4
- Alaska 3
- Arkansas 3
- Georgia 3
- Michigan 3
- Illinois 2
- Iowa 2
- Mississippi 2
- Missouri 2
- New York 2
- Ohio 2
- Puerto Rico 2
- California 1
- Colorado 1
- Minnesota 1
- New Jersey 1
- North Carolina 1
- North Dakota 1
- Oregon 1
- Texas 1
- Utah 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484339 | 2484339 | 2022-05-08 | Hart | Kentucky | 21099 | 5423 | 100 |
2486267 | 2486267 | 2022-05-08 | Fredericksburg city | Virginia | 51630 | 5423 | 42 |
2481081 | 2481081 | 2022-05-07 | Hart | Kentucky | 21099 | 5423 | 100 |
2483009 | 2483009 | 2022-05-07 | Fredericksburg city | Virginia | 51630 | 5423 | 42 |
2477823 | 2477823 | 2022-05-06 | Hart | Kentucky | 21099 | 5423 | 100 |
2479751 | 2479751 | 2022-05-06 | Fredericksburg city | Virginia | 51630 | 5423 | 42 |
2474565 | 2474565 | 2022-05-05 | Hart | Kentucky | 21099 | 5423 | 100 |
2471308 | 2471308 | 2022-05-04 | Hart | Kentucky | 21099 | 5423 | 100 |
2468052 | 2468052 | 2022-05-03 | Hart | Kentucky | 21099 | 5423 | 100 |
2464797 | 2464797 | 2022-05-02 | Hart | Kentucky | 21099 | 5423 | 100 |
2431308 | 2431308 | 2022-04-22 | Columbia | Arkansas | 5027 | 5423 | 94 |
2428052 | 2428052 | 2022-04-21 | Columbia | Arkansas | 5027 | 5423 | 94 |
2427054 | 2427054 | 2022-04-20 | Las Piedras | Puerto Rico | 72085 | 5423 | |
2415631 | 2415631 | 2022-04-17 | Fountain | Indiana | 18045 | 5423 | 102 |
2417308 | 2417308 | 2022-04-17 | San Lorenzo | Puerto Rico | 72129 | 5423 | |
2412375 | 2412375 | 2022-04-16 | Fountain | Indiana | 18045 | 5423 | 102 |
2409119 | 2409119 | 2022-04-15 | Fountain | Indiana | 18045 | 5423 | 102 |
2405863 | 2405863 | 2022-04-14 | Fountain | Indiana | 18045 | 5423 | 102 |
2402608 | 2402608 | 2022-04-13 | Fountain | Indiana | 18045 | 5423 | 102 |
2330757 | 2330757 | 2022-03-22 | Haralson | Georgia | 13143 | 5423 | 164 |
2307649 | 2307649 | 2022-03-15 | Conway | Arkansas | 5029 | 5423 | 62 |
2308028 | 2308028 | 2022-03-15 | Pike | Georgia | 13231 | 5423 | 89 |
2310427 | 2310427 | 2022-03-15 | Sevier | Utah | 49041 | 5423 | 30 |
2211086 | 2211086 | 2022-02-13 | Simpson | Kentucky | 21213 | 5423 | 79 |
2207833 | 2207833 | 2022-02-12 | Simpson | Kentucky | 21213 | 5423 | 79 |
2204580 | 2204580 | 2022-02-11 | Simpson | Kentucky | 21213 | 5423 | 79 |
2169063 | 2169063 | 2022-01-31 | Meeker | Minnesota | 27093 | 5423 | 72 |
2132092 | 2132092 | 2022-01-20 | Glenn | California | 6021 | 5423 | 55 |
2133191 | 2133191 | 2022-01-20 | Mason | Michigan | 26105 | 5423 | 76 |
2129938 | 2129938 | 2022-01-19 | Mason | Michigan | 26105 | 5423 | 76 |
2100820 | 2100820 | 2022-01-10 | Itawamba | Mississippi | 28057 | 5423 | 114 |
2062924 | 2062924 | 2021-12-29 | Hardeman | Tennessee | 47069 | 5423 | 96 |
2037001 | 2037001 | 2021-12-21 | Bee | Texas | 48025 | 5423 | 136 |
2004968 | 2004968 | 2021-12-11 | Greenbrier | West Virginia | 54025 | 5423 | 112 |
1993122 | 1993122 | 2021-12-08 | Calloway | Kentucky | 21035 | 5423 | 64 |
1972907 | 1972907 | 2021-12-02 | Summit | Colorado | 8117 | 5423 | 12 |
1935156 | 1935156 | 2021-11-20 | Marion | Missouri | 29127 | 5423 | 99 |
1923544 | 1923544 | 2021-11-16 | Charlottesville city | Virginia | 51540 | 5423 | 60 |
1919319 | 1919319 | 2021-11-15 | Pasquotank | North Carolina | 37139 | 5423 | 105 |
1848306 | 1848306 | 2021-10-24 | Marion | South Carolina | 45067 | 5423 | 137 |
1845056 | 1845056 | 2021-10-23 | Marion | South Carolina | 45067 | 5423 | 137 |
1841806 | 1841806 | 2021-10-22 | Marion | South Carolina | 45067 | 5423 | 137 |
1815933 | 1815933 | 2021-10-14 | Henry | Tennessee | 47079 | 5423 | 84 |
1809119 | 1809119 | 2021-10-12 | Malheur | Oregon | 41045 | 5423 | 74 |
1723435 | 1723435 | 2021-09-16 | Greenup | Kentucky | 21089 | 5423 | 68 |
1724658 | 1724658 | 2021-09-16 | Bedford | Pennsylvania | 42009 | 5423 | 146 |
1700373 | 1700373 | 2021-09-09 | DeKalb | Indiana | 18033 | 5423 | 94 |
1697163 | 1697163 | 2021-09-08 | Montgomery | Indiana | 18107 | 5423 | 101 |
1675720 | 1675720 | 2021-09-01 | Williams | North Dakota | 38105 | 5423 | 42 |
1652390 | 1652390 | 2021-08-25 | Monroe | Mississippi | 28095 | 5423 | 144 |
1628844 | 1628844 | 2021-08-18 | Marion | Illinois | 17121 | 5423 | 132 |
1595782 | 1595782 | 2021-08-08 | Kenai Peninsula Borough | Alaska | 2122 | 5423 | 20 |
1592533 | 1592533 | 2021-08-07 | Kenai Peninsula Borough | Alaska | 2122 | 5423 | 20 |
1589284 | 1589284 | 2021-08-06 | Kenai Peninsula Borough | Alaska | 2122 | 5423 | 20 |
1535501 | 1535501 | 2021-07-20 | Callaway | Missouri | 29027 | 5423 | 51 |
1472687 | 1472687 | 2021-07-01 | Suwannee | Florida | 12121 | 5423 | 140 |
1469441 | 1469441 | 2021-06-30 | Suwannee | Florida | 12121 | 5423 | 140 |
1466196 | 1466196 | 2021-06-29 | Suwannee | Florida | 12121 | 5423 | 140 |
1462951 | 1462951 | 2021-06-28 | Suwannee | Florida | 12121 | 5423 | 140 |
1459706 | 1459706 | 2021-06-27 | Suwannee | Florida | 12121 | 5423 | 140 |
1456461 | 1456461 | 2021-06-26 | Suwannee | Florida | 12121 | 5423 | 140 |
1458155 | 1458155 | 2021-06-26 | Darke | Ohio | 39037 | 5423 | 129 |
1453216 | 1453216 | 2021-06-25 | Suwannee | Florida | 12121 | 5423 | 140 |
1416189 | 1416189 | 2021-06-13 | Mifflin | Pennsylvania | 42087 | 5423 | 179 |
1376801 | 1376801 | 2021-06-01 | Genesee | New York | 36037 | 5423 | 124 |
1293078 | 1293078 | 2021-05-06 | Dyer | Tennessee | 47045 | 5423 | 106 |
1249138 | 1249138 | 2021-04-23 | Clinton | Iowa | 19045 | 5423 | 91 |
1175763 | 1175763 | 2021-03-31 | Union | Ohio | 39159 | 5423 | 47 |
1170991 | 1170991 | 2021-03-30 | Coles | Illinois | 17029 | 5423 | 96 |
991176 | 991176 | 2021-02-02 | McMinn | Tennessee | 47107 | 5423 | 79 |
963928 | 963928 | 2021-01-25 | Montcalm | Michigan | 26117 | 5423 | 87 |
877557 | 877557 | 2020-12-29 | Greene | Tennessee | 47059 | 5423 | 91 |
826277 | 826277 | 2020-12-13 | Portage | Wisconsin | 55097 | 5423 | 46 |
812359 | 812359 | 2020-12-09 | Blair | Pennsylvania | 42013 | 5423 | 94 |
799401 | 799401 | 2020-12-05 | Franklin | Pennsylvania | 42055 | 5423 | 133 |
737900 | 737900 | 2020-11-16 | Pickens | South Carolina | 45077 | 5423 | 74 |
700216 | 700216 | 2020-11-05 | Forsyth | Georgia | 13117 | 5423 | 55 |
661698 | 661698 | 2020-10-24 | Linn | Iowa | 19113 | 5423 | 129 |
586626 | 586626 | 2020-10-01 | St. Johns | Florida | 12109 | 5423 | 70 |
585622 | 585622 | 2020-09-30 | Williamson | Tennessee | 47187 | 5423 | 36 |
481301 | 481301 | 2020-08-29 | Monroe | New York | 36055 | 5423 | 256 |
330010 | 330010 | 2020-07-13 | Burlington | New Jersey | 34005 | 5423 | 449 |
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);