ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 7260 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kentucky 11
- Michigan 4
- Missouri 4
- Indiana 3
- Colorado 2
- Georgia 2
- Illinois 2
- Louisiana 2
- New York 2
- North Carolina 2
- Ohio 2
- Texas 2
- West Virginia 2
- Alabama 1
- California 1
- Florida 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- Montana 1
- New Jersey 1
- New Mexico 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501931 | 2501931 | 2022-05-13 | Cayey | Puerto Rico | 72035 | 7260 | |
2502240 | 2502240 | 2022-05-13 | Cass | Texas | 48067 | 7260 | 197 |
2492544 | 2492544 | 2022-05-10 | Hopkins | Texas | 48223 | 7260 | 178 |
2487183 | 2487183 | 2022-05-09 | Iroquois | Illinois | 17075 | 7260 | 118 |
2467662 | 2467662 | 2022-05-03 | McDonough | Illinois | 17109 | 7260 | 104 |
2361545 | 2361545 | 2022-03-31 | Montgomery | North Carolina | 37123 | 7260 | 126 |
2307407 | 2307407 | 2022-03-14 | Nicholas | West Virginia | 54067 | 7260 | 92 |
2302114 | 2302114 | 2022-03-13 | Ohio | Kentucky | 21183 | 7260 | 95 |
2298862 | 2298862 | 2022-03-12 | Ohio | Kentucky | 21183 | 7260 | 95 |
2295610 | 2295610 | 2022-03-11 | Ohio | Kentucky | 21183 | 7260 | 95 |
2292358 | 2292358 | 2022-03-10 | Ohio | Kentucky | 21183 | 7260 | 95 |
2289106 | 2289106 | 2022-03-09 | Ohio | Kentucky | 21183 | 7260 | 95 |
2285855 | 2285855 | 2022-03-08 | Ohio | Kentucky | 21183 | 7260 | 95 |
2282603 | 2282603 | 2022-03-07 | Ohio | Kentucky | 21183 | 7260 | 95 |
2266331 | 2266331 | 2022-03-02 | Mercer | Kentucky | 21167 | 7260 | 99 |
2245973 | 2245973 | 2022-02-24 | Siskiyou | California | 6093 | 7260 | 97 |
2247673 | 2247673 | 2022-02-24 | Dare | North Carolina | 37055 | 7260 | 22 |
2240378 | 2240378 | 2022-02-22 | East Feliciana | Louisiana | 22037 | 7260 | 162 |
2221967 | 2221967 | 2022-02-16 | Columbia | Oregon | 41009 | 7260 | 74 |
2178166 | 2178166 | 2022-02-03 | Daviess | Indiana | 18027 | 7260 | 135 |
2087882 | 2087882 | 2022-01-06 | Camden | Missouri | 29029 | 7260 | 152 |
1870149 | 1870149 | 2021-10-31 | Johnson | Missouri | 29101 | 7260 | 73 |
1838432 | 1838432 | 2021-10-21 | Union | Pennsylvania | 42119 | 7260 | 98 |
1827940 | 1827940 | 2021-10-18 | Pettis | Missouri | 29159 | 7260 | 102 |
1824691 | 1824691 | 2021-10-17 | Pettis | Missouri | 29159 | 7260 | 102 |
1769778 | 1769778 | 2021-09-30 | Wayne | New York | 36117 | 7260 | 79 |
1762091 | 1762091 | 2021-09-28 | Cass | Indiana | 18017 | 7260 | 120 |
1761351 | 1761351 | 2021-09-27 | Waupaca | Wisconsin | 55135 | 7260 | 178 |
1742153 | 1742153 | 2021-09-22 | Fremont | Colorado | 8043 | 7260 | 72 |
1673926 | 1673926 | 2021-09-01 | Eagle | Colorado | 8037 | 7260 | 29 |
1652821 | 1652821 | 2021-08-25 | Steuben | New York | 36101 | 7260 | 148 |
1633525 | 1633525 | 2021-08-19 | Hancock | Ohio | 39063 | 7260 | 138 |
1634469 | 1634469 | 2021-08-19 | Rockingham | Virginia | 51165 | 7260 | 115 |
1610833 | 1610833 | 2021-08-12 | Scioto | Ohio | 39145 | 7260 | 109 |
1605967 | 1605967 | 2021-08-11 | Spalding | Georgia | 13255 | 7260 | 207 |
1577532 | 1577532 | 2021-08-02 | Van Buren | Michigan | 26159 | 7260 | 135 |
1574284 | 1574284 | 2021-08-01 | Van Buren | Michigan | 26159 | 7260 | 135 |
1571036 | 1571036 | 2021-07-31 | Van Buren | Michigan | 26159 | 7260 | 135 |
1567788 | 1567788 | 2021-07-30 | Van Buren | Michigan | 26159 | 7260 | 135 |
1564241 | 1564241 | 2021-07-29 | Christian | Kentucky | 21047 | 7260 | 108 |
1428318 | 1428318 | 2021-06-17 | Lauderdale | Mississippi | 28075 | 7260 | 242 |
1359852 | 1359852 | 2021-05-27 | Iberia | Louisiana | 22045 | 7260 | 156 |
1319812 | 1319812 | 2021-05-15 | Walker | Alabama | 1127 | 7260 | 278 |
1167565 | 1167565 | 2021-03-29 | Dougherty | Georgia | 13095 | 7260 | 290 |
1158478 | 1158478 | 2021-03-26 | Oldham | Kentucky | 21185 | 7260 | 80 |
1124820 | 1124820 | 2021-03-15 | Wood | West Virginia | 54107 | 7260 | 155 |
1015291 | 1015291 | 2021-02-10 | Hancock | Indiana | 18059 | 7260 | 130 |
1002911 | 1002911 | 2021-02-06 | Carver | Minnesota | 27019 | 7260 | 40 |
940955 | 940955 | 2021-01-18 | Hardin | Kentucky | 21093 | 7260 | 55 |
891581 | 891581 | 2021-01-03 | Indian River | Florida | 12061 | 7260 | 162 |
870351 | 870351 | 2020-12-27 | Santa Fe | New Mexico | 35049 | 7260 | 70 |
827537 | 827537 | 2020-12-14 | Harford | Maryland | 24025 | 7260 | 119 |
694950 | 694950 | 2020-11-03 | Yellowstone | Montana | 30111 | 7260 | 96 |
384505 | 384505 | 2020-07-30 | Morris | New Jersey | 34027 | 7260 | 828 |
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);