ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 5414 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Iowa 9
- Kentucky 8
- Arkansas 7
- Texas 6
- Georgia 5
- Ohio 5
- North Carolina 4
- Tennessee 3
- Colorado 2
- Indiana 2
- Michigan 2
- Missouri 2
- New York 2
- Utah 2
- Virginia 2
- Wisconsin 2
- Maryland 1
- Minnesota 1
- Mississippi 1
- New Mexico 1
- North Dakota 1
- Oklahoma 1
- Pennsylvania 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500024 | 2500024 | 2022-05-13 | Franklin | Georgia | 13119 | 5414 | 104 |
2496766 | 2496766 | 2022-05-12 | Franklin | Georgia | 13119 | 5414 | 104 |
2493508 | 2493508 | 2022-05-11 | Franklin | Georgia | 13119 | 5414 | 104 |
2496028 | 2496028 | 2022-05-11 | Dinwiddie | Virginia | 51053 | 5414 | 93 |
2438749 | 2438749 | 2022-04-24 | Hart | Kentucky | 21099 | 5414 | 98 |
2435493 | 2435493 | 2022-04-23 | Hart | Kentucky | 21099 | 5414 | 98 |
2432237 | 2432237 | 2022-04-22 | Hart | Kentucky | 21099 | 5414 | 98 |
2428981 | 2428981 | 2022-04-21 | Hart | Kentucky | 21099 | 5414 | 98 |
2425725 | 2425725 | 2022-04-20 | Hart | Kentucky | 21099 | 5414 | 98 |
2422469 | 2422469 | 2022-04-19 | Hart | Kentucky | 21099 | 5414 | 98 |
2419213 | 2419213 | 2022-04-18 | Hart | Kentucky | 21099 | 5414 | 98 |
2353192 | 2353192 | 2022-03-29 | Columbia | Arkansas | 5027 | 5414 | 91 |
2349940 | 2349940 | 2022-03-28 | Columbia | Arkansas | 5027 | 5414 | 91 |
2346687 | 2346687 | 2022-03-27 | Columbia | Arkansas | 5027 | 5414 | 91 |
2343434 | 2343434 | 2022-03-26 | Columbia | Arkansas | 5027 | 5414 | 91 |
2340181 | 2340181 | 2022-03-25 | Columbia | Arkansas | 5027 | 5414 | 91 |
2291427 | 2291427 | 2022-03-10 | Ouachita | Arkansas | 5103 | 5414 | 95 |
2264895 | 2264895 | 2022-03-01 | Sevier | Utah | 49041 | 5414 | 26 |
2194600 | 2194600 | 2022-02-08 | Washington | Iowa | 19183 | 5414 | 73 |
2191346 | 2191346 | 2022-02-07 | Washington | Iowa | 19183 | 5414 | 73 |
2188093 | 2188093 | 2022-02-06 | Washington | Iowa | 19183 | 5414 | 73 |
2184840 | 2184840 | 2022-02-05 | Washington | Iowa | 19183 | 5414 | 73 |
2181588 | 2181588 | 2022-02-04 | Washington | Iowa | 19183 | 5414 | 73 |
2178337 | 2178337 | 2022-02-03 | Washington | Iowa | 19183 | 5414 | 73 |
2175084 | 2175084 | 2022-02-02 | Washington | Iowa | 19183 | 5414 | 73 |
2094962 | 2094962 | 2022-01-08 | Gallia | Ohio | 39053 | 5414 | 85 |
2023999 | 2023999 | 2021-12-17 | Bee | Texas | 48025 | 5414 | 136 |
2020748 | 2020748 | 2021-12-16 | Bee | Texas | 48025 | 5414 | 135 |
2017497 | 2017497 | 2021-12-15 | Bee | Texas | 48025 | 5414 | 135 |
1958231 | 1958231 | 2021-11-27 | Orleans | New York | 36073 | 5414 | 95 |
1953012 | 1953012 | 2021-11-25 | Clark | Wisconsin | 55019 | 5414 | 87 |
1922430 | 1922430 | 2021-11-16 | Rio Arriba | New Mexico | 35039 | 5414 | 86 |
1918087 | 1918087 | 2021-11-15 | Jefferson | Indiana | 18077 | 5414 | 105 |
1904220 | 1904220 | 2021-11-10 | Marshall | West Virginia | 54051 | 5414 | 116 |
1882609 | 1882609 | 2021-11-04 | Boyle | Kentucky | 21021 | 5414 | 81 |
1852892 | 1852892 | 2021-10-26 | Upson | Georgia | 13293 | 5414 | 172 |
1802323 | 1802323 | 2021-10-10 | Jackson | North Carolina | 37099 | 5414 | 69 |
1798327 | 1798327 | 2021-10-09 | Calvert | Maryland | 24009 | 5414 | 99 |
1799074 | 1799074 | 2021-10-09 | Jackson | North Carolina | 37099 | 5414 | 69 |
1795825 | 1795825 | 2021-10-08 | Jackson | North Carolina | 37099 | 5414 | 69 |
1785998 | 1785998 | 2021-10-05 | Montgomery | New York | 36057 | 5414 | 135 |
1713996 | 1713996 | 2021-09-13 | Goodhue | Minnesota | 27049 | 5414 | 79 |
1667323 | 1667323 | 2021-08-30 | Miller | Arkansas | 5091 | 5414 | 39 |
1584742 | 1584742 | 2021-08-04 | Morton | North Dakota | 38059 | 5414 | 102 |
1585506 | 1585506 | 2021-08-04 | Nacogdoches | Texas | 48347 | 5414 | 176 |
1575513 | 1575513 | 2021-08-01 | Fayette | Tennessee | 47047 | 5414 | 83 |
1572265 | 1572265 | 2021-07-31 | Fayette | Tennessee | 47047 | 5414 | 83 |
1569017 | 1569017 | 2021-07-30 | Fayette | Tennessee | 47047 | 5414 | 83 |
1422452 | 1422452 | 2021-06-15 | Darke | Ohio | 39037 | 5414 | 129 |
1412715 | 1412715 | 2021-06-12 | Darke | Ohio | 39037 | 5414 | 129 |
1327052 | 1327052 | 2021-05-17 | Cerro Gordo | Iowa | 19033 | 5414 | 89 |
1265805 | 1265805 | 2021-04-28 | Barry | Michigan | 26015 | 5414 | 61 |
1256915 | 1256915 | 2021-04-25 | Jefferson | Ohio | 39081 | 5414 | 150 |
1218745 | 1218745 | 2021-04-13 | Summit | Utah | 49043 | 5414 | 11 |
1199008 | 1199008 | 2021-04-07 | Caldwell | Texas | 48055 | 5414 | 94 |
1192795 | 1192795 | 2021-04-05 | Augusta | Virginia | 51015 | 5414 | 68 |
1184251 | 1184251 | 2021-04-03 | Warren | Iowa | 19181 | 5414 | 85 |
1173891 | 1173891 | 2021-03-31 | Garfield | Colorado | 8045 | 5414 | 38 |
1091835 | 1091835 | 2021-03-05 | Atascosa | Texas | 48013 | 5414 | 141 |
1071891 | 1071891 | 2021-02-27 | Cherokee | Oklahoma | 40021 | 5414 | 41 |
1057018 | 1057018 | 2021-02-23 | Fremont | Colorado | 8043 | 5414 | 48 |
1050774 | 1050774 | 2021-02-21 | Spalding | Georgia | 13255 | 5414 | 153 |
1045052 | 1045052 | 2021-02-19 | Lapeer | Michigan | 26087 | 5414 | 128 |
1043674 | 1043674 | 2021-02-18 | Barron | Wisconsin | 55005 | 5414 | 75 |
1013240 | 1013240 | 2021-02-09 | Columbus | North Carolina | 37047 | 5414 | 130 |
983548 | 983548 | 2021-01-31 | Lafayette | Mississippi | 28071 | 5414 | 104 |
769419 | 769419 | 2020-11-26 | Cape Girardeau | Missouri | 29031 | 5414 | 67 |
766173 | 766173 | 2020-11-25 | Cape Girardeau | Missouri | 29031 | 5414 | 67 |
612913 | 612913 | 2020-10-09 | Hamilton | Indiana | 18057 | 5414 | 119 |
381777 | 381777 | 2020-07-29 | Lancaster | Pennsylvania | 42071 | 5414 | 405 |
180440 | 180440 | 2020-05-26 | Franklin | Ohio | 39049 | 5414 | 239 |
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);