ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 5590 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Oklahoma 7
- Georgia 6
- Texas 6
- Ohio 5
- Louisiana 4
- Nebraska 4
- Virginia 4
- Idaho 3
- Missouri 3
- Nevada 3
- North Carolina 3
- Puerto Rico 3
- South Carolina 3
- Kansas 2
- Pennsylvania 2
- California 1
- Florida 1
- Illinois 1
- Kentucky 1
- Massachusetts 1
- Mississippi 1
- New Jersey 1
- Oregon 1
- Tennessee 1
- Utah 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456811 | 2456811 | 2022-04-29 | San Jacinto | Texas | 48407 | 5590 | 101 |
2453555 | 2453555 | 2022-04-28 | San Jacinto | Texas | 48407 | 5590 | 101 |
2278841 | 2278841 | 2022-03-06 | Jerome | Idaho | 16053 | 5590 | 64 |
2275588 | 2275588 | 2022-03-05 | Jerome | Idaho | 16053 | 5590 | 64 |
2272335 | 2272335 | 2022-03-04 | Jerome | Idaho | 16053 | 5590 | 64 |
2192061 | 2192061 | 2022-02-07 | Stone | Missouri | 29209 | 5590 | 106 |
2166816 | 2166816 | 2022-01-30 | Manati | Puerto Rico | 72091 | 5590 | |
2151205 | 2151205 | 2022-01-25 | Russell | Virginia | 51167 | 5590 | 81 |
2126473 | 2126473 | 2022-01-18 | Mercer | Kentucky | 21167 | 5590 | 95 |
1967687 | 1967687 | 2021-11-30 | Pulaski | Missouri | 29169 | 5590 | 97 |
1915835 | 1915835 | 2021-11-14 | Platte | Nebraska | 31141 | 5590 | 56 |
1912585 | 1912585 | 2021-11-13 | Platte | Nebraska | 31141 | 5590 | 56 |
1909335 | 1909335 | 2021-11-12 | Platte | Nebraska | 31141 | 5590 | 56 |
1869103 | 1869103 | 2021-10-31 | Pickens | Georgia | 13227 | 5590 | 115 |
1865854 | 1865854 | 2021-10-30 | Pickens | Georgia | 13227 | 5590 | 115 |
1862605 | 1862605 | 2021-10-29 | Pickens | Georgia | 13227 | 5590 | 115 |
1853270 | 1853270 | 2021-10-26 | Cowley | Kansas | 20035 | 5590 | 127 |
1850021 | 1850021 | 2021-10-25 | Cowley | Kansas | 20035 | 5590 | 127 |
1831339 | 1831339 | 2021-10-19 | Madison | Nebraska | 31119 | 5590 | 45 |
1825543 | 1825543 | 2021-10-17 | Colleton | South Carolina | 45029 | 5590 | 188 |
1822294 | 1822294 | 2021-10-16 | Colleton | South Carolina | 45029 | 5590 | 188 |
1819045 | 1819045 | 2021-10-15 | Colleton | South Carolina | 45029 | 5590 | 188 |
1746607 | 1746607 | 2021-09-23 | Pike | Mississippi | 28113 | 5590 | 136 |
1717956 | 1717956 | 2021-09-14 | Ashland | Ohio | 39005 | 5590 | 110 |
1650505 | 1650505 | 2021-08-24 | Rusk | Texas | 48401 | 5590 | 117 |
1647218 | 1647218 | 2021-08-23 | Medina | Texas | 48325 | 5590 | 121 |
1642950 | 1642950 | 2021-08-22 | Elko | Nevada | 32007 | 5590 | 69 |
1639700 | 1639700 | 2021-08-21 | Elko | Nevada | 32007 | 5590 | 69 |
1636450 | 1636450 | 2021-08-20 | Elko | Nevada | 32007 | 5590 | 69 |
1627809 | 1627809 | 2021-08-17 | Wilson | Texas | 48493 | 5590 | 75 |
1605341 | 1605341 | 2021-08-10 | Putnam | West Virginia | 54079 | 5590 | 96 |
1513234 | 1513234 | 2021-07-13 | Pender | North Carolina | 37141 | 5590 | 69 |
1486459 | 1486459 | 2021-07-05 | St. Martin | Louisiana | 22099 | 5590 | 118 |
1483213 | 1483213 | 2021-07-04 | St. Martin | Louisiana | 22099 | 5590 | 118 |
1479966 | 1479966 | 2021-07-03 | St. Martin | Louisiana | 22099 | 5590 | 118 |
1476720 | 1476720 | 2021-07-02 | St. Martin | Louisiana | 22099 | 5590 | 118 |
1442252 | 1442252 | 2021-06-21 | Unknown | Puerto Rico | 5590 | 2540 | |
1422775 | 1422775 | 2021-06-15 | Unknown | Puerto Rico | 5590 | 2536 | |
1420147 | 1420147 | 2021-06-14 | Pittsylvania | Virginia | 51143 | 5590 | 82 |
1416781 | 1416781 | 2021-06-13 | Summit | Utah | 49043 | 5590 | 13 |
1416902 | 1416902 | 2021-06-13 | Pittsylvania | Virginia | 51143 | 5590 | 82 |
1354405 | 1354405 | 2021-05-25 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1351159 | 1351159 | 2021-05-24 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1347913 | 1347913 | 2021-05-23 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1344665 | 1344665 | 2021-05-22 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1341417 | 1341417 | 2021-05-21 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1338169 | 1338169 | 2021-05-20 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1334922 | 1334922 | 2021-05-19 | Le Flore | Oklahoma | 40079 | 5590 | 64 |
1328343 | 1328343 | 2021-05-17 | Lawrence | Ohio | 39087 | 5590 | 102 |
1315199 | 1315199 | 2021-05-13 | Halifax | North Carolina | 37083 | 5590 | 112 |
1292810 | 1292810 | 2021-05-06 | Columbia | Pennsylvania | 42037 | 5590 | 133 |
1226093 | 1226093 | 2021-04-16 | Polk | Georgia | 13233 | 5590 | 90 |
998705 | 998705 | 2021-02-05 | Putnam | Florida | 12107 | 5590 | 104 |
973059 | 973059 | 2021-01-28 | Whiteside | Illinois | 17195 | 5590 | 177 |
968851 | 968851 | 2021-01-26 | Hanover | Virginia | 51085 | 5590 | 96 |
965174 | 965174 | 2021-01-25 | Dickson | Tennessee | 47043 | 5590 | 82 |
893349 | 893349 | 2021-01-03 | Muskingum | Ohio | 39119 | 5590 | 27 |
881687 | 881687 | 2020-12-31 | El Dorado | California | 6017 | 5590 | 22 |
837606 | 837606 | 2020-12-17 | Jasper | Missouri | 29097 | 5590 | 80 |
774845 | 774845 | 2020-11-28 | Floyd | Georgia | 13115 | 5590 | 82 |
718119 | 718119 | 2020-11-10 | Stark | Ohio | 39151 | 5590 | 190 |
711639 | 711639 | 2020-11-08 | Warren | Ohio | 39165 | 5590 | 70 |
653362 | 653362 | 2020-10-21 | Marion | Oregon | 41047 | 5590 | 106 |
588878 | 588878 | 2020-10-01 | Bell | Texas | 48027 | 5590 | 87 |
457336 | 457336 | 2020-08-22 | Richmond | Georgia | 13245 | 5590 | 114 |
391429 | 391429 | 2020-08-01 | Lancaster | Pennsylvania | 42071 | 5590 | 407 |
382561 | 382561 | 2020-07-29 | Snohomish | Washington | 53061 | 5590 | 198 |
295317 | 295317 | 2020-07-02 | Wake | North Carolina | 37183 | 5590 | 49 |
146369 | 146369 | 2020-05-15 | Bristol | Massachusetts | 25005 | 5590 | 303 |
52613 | 52613 | 2020-04-12 | Passaic | New Jersey | 34031 | 5590 | 131 |
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);