ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 5903 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- South Dakota 7
- Ohio 5
- Arkansas 4
- Indiana 4
- Louisiana 4
- California 3
- Mississippi 3
- Pennsylvania 3
- Alabama 2
- Colorado 2
- Maine 2
- Missouri 2
- New York 2
- Tennessee 2
- Virginia 2
- Georgia 1
- Kentucky 1
- Massachusetts 1
- Nebraska 1
- New Jersey 1
- North Carolina 1
- Puerto Rico 1
- South Carolina 1
- Texas 1
- Utah 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423950 | 2423950 | 2022-04-19 | Yankton | South Dakota | 46135 | 5903 | 59 |
2420694 | 2420694 | 2022-04-18 | Yankton | South Dakota | 46135 | 5903 | 59 |
2417438 | 2417438 | 2022-04-17 | Yankton | South Dakota | 46135 | 5903 | 59 |
2414182 | 2414182 | 2022-04-16 | Yankton | South Dakota | 46135 | 5903 | 59 |
2410926 | 2410926 | 2022-04-15 | Yankton | South Dakota | 46135 | 5903 | 59 |
2407670 | 2407670 | 2022-04-14 | Yankton | South Dakota | 46135 | 5903 | 59 |
2404414 | 2404414 | 2022-04-13 | Yankton | South Dakota | 46135 | 5903 | 59 |
2256265 | 2256265 | 2022-02-27 | Randolph | Indiana | 18135 | 5903 | 141 |
2253014 | 2253014 | 2022-02-26 | Randolph | Indiana | 18135 | 5903 | 141 |
2249763 | 2249763 | 2022-02-25 | Randolph | Indiana | 18135 | 5903 | 141 |
2226378 | 2226378 | 2022-02-18 | Jackson | Arkansas | 5067 | 5903 | 53 |
2217672 | 2217672 | 2022-02-15 | Hancock | Maine | 23009 | 5903 | 73 |
2212314 | 2212314 | 2022-02-13 | Aguada | Puerto Rico | 72003 | 5903 | |
2190919 | 2190919 | 2022-02-07 | Harris | Georgia | 13145 | 5903 | 100 |
2164733 | 2164733 | 2022-01-30 | Routt | Colorado | 8107 | 5903 | 25 |
2158222 | 2158222 | 2022-01-28 | Routt | Colorado | 8107 | 5903 | 25 |
2095200 | 2095200 | 2022-01-08 | Warren | Pennsylvania | 42123 | 5903 | 184 |
2072233 | 2072233 | 2022-01-01 | Morrow | Ohio | 39117 | 5903 | 72 |
2068982 | 2068982 | 2021-12-31 | Morrow | Ohio | 39117 | 5903 | 72 |
2026516 | 2026516 | 2021-12-18 | Wyoming | New York | 36121 | 5903 | 72 |
2014669 | 2014669 | 2021-12-14 | York | Virginia | 51199 | 5903 | 83 |
1997897 | 1997897 | 2021-12-09 | Claiborne | Tennessee | 47025 | 5903 | 120 |
1994646 | 1994646 | 2021-12-08 | Claiborne | Tennessee | 47025 | 5903 | 120 |
1989997 | 1989997 | 2021-12-07 | Iberville | Louisiana | 22047 | 5903 | 128 |
1967844 | 1967844 | 2021-11-30 | Platte | Nebraska | 31141 | 5903 | 60 |
1915566 | 1915566 | 2021-11-14 | Pike | Mississippi | 28113 | 5903 | 155 |
1912316 | 1912316 | 2021-11-13 | Pike | Mississippi | 28113 | 5903 | 155 |
1909066 | 1909066 | 2021-11-12 | Pike | Mississippi | 28113 | 5903 | 155 |
1834441 | 1834441 | 2021-10-20 | Platte | Missouri | 29165 | 5903 | 61 |
1792611 | 1792611 | 2021-10-07 | Stokes | North Carolina | 37169 | 5903 | 100 |
1729003 | 1729003 | 2021-09-18 | Boone | Arkansas | 5009 | 5903 | 108 |
1675727 | 1675727 | 2021-09-01 | Athens | Ohio | 39009 | 5903 | 60 |
1549121 | 1549121 | 2021-07-24 | Union | Ohio | 39159 | 5903 | 49 |
1528662 | 1528662 | 2021-07-18 | St. Charles | Louisiana | 22089 | 5903 | 98 |
1525415 | 1525415 | 2021-07-17 | St. Charles | Louisiana | 22089 | 5903 | 98 |
1522167 | 1522167 | 2021-07-16 | St. Charles | Louisiana | 22089 | 5903 | 98 |
1464848 | 1464848 | 2021-06-28 | Columbia | Pennsylvania | 42037 | 5903 | 136 |
1401638 | 1401638 | 2021-06-09 | Henry | Indiana | 18065 | 5903 | 109 |
1397814 | 1397814 | 2021-06-08 | Mississippi | Arkansas | 5093 | 5903 | 110 |
1377871 | 1377871 | 2021-06-01 | Augusta | Virginia | 51015 | 5903 | 73 |
1361431 | 1361431 | 2021-05-27 | Hardin | Texas | 48199 | 5903 | 113 |
1333929 | 1333929 | 2021-05-19 | Penobscot | Maine | 23019 | 5903 | 91 |
1322013 | 1322013 | 2021-05-15 | Armstrong | Pennsylvania | 42005 | 5903 | 136 |
1318369 | 1318369 | 2021-05-14 | Jefferson | New York | 36045 | 5903 | 66 |
1316319 | 1316319 | 2021-05-13 | Cowlitz | Washington | 53015 | 5903 | 88 |
1279351 | 1279351 | 2021-05-02 | Salem | New Jersey | 34033 | 5903 | 177 |
1221520 | 1221520 | 2021-04-14 | Cherokee | South Carolina | 45021 | 5903 | 149 |
1213828 | 1213828 | 2021-04-12 | Berkshire | Massachusetts | 25003 | 5903 | 281 |
1212572 | 1212572 | 2021-04-11 | Waupaca | Wisconsin | 55135 | 5903 | 161 |
1141393 | 1141393 | 2021-03-21 | Yuba | California | 6115 | 5903 | 42 |
1138147 | 1138147 | 2021-03-20 | Yuba | California | 6115 | 5903 | 42 |
1134901 | 1134901 | 2021-03-19 | Yuba | California | 6115 | 5903 | 42 |
1103272 | 1103272 | 2021-03-09 | McCracken | Kentucky | 21145 | 5903 | 77 |
1082853 | 1082853 | 2021-03-03 | Greene | Arkansas | 5055 | 5903 | 72 |
1019933 | 1019933 | 2021-02-11 | Ross | Ohio | 39141 | 5903 | 114 |
981750 | 981750 | 2021-01-30 | Tooele | Utah | 49045 | 5903 | 23 |
949682 | 949682 | 2021-01-21 | Jackson | Alabama | 1071 | 5903 | 41 |
939972 | 939972 | 2021-01-18 | Walker | Alabama | 1127 | 5903 | 174 |
493967 | 493967 | 2020-09-02 | St. Charles | Missouri | 29183 | 5903 | 112 |
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);