ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where cases = 4683 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 8
- Nebraska 8
- Oklahoma 8
- South Dakota 7
- Virginia 7
- California 6
- Georgia 6
- Missouri 6
- Ohio 5
- Texas 5
- Arkansas 4
- Indiana 3
- Michigan 3
- Minnesota 3
- New York 3
- Puerto Rico 3
- West Virginia 3
- Wisconsin 3
- Colorado 2
- Idaho 2
- Illinois 2
- Kentucky 2
- Louisiana 2
- Oregon 2
- South Carolina 2
- Tennessee 2
- Wyoming 2
- Florida 1
- Maryland 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495456 | 2495456 | 2022-05-11 | Quebradillas | Puerto Rico | 72115 | 4683 | |
2476530 | 2476530 | 2022-05-05 | New Kent | Virginia | 51127 | 4683 | 31 |
2470387 | 2470387 | 2022-05-04 | Drew | Arkansas | 5043 | 4683 | 70 |
2467131 | 2467131 | 2022-05-03 | Drew | Arkansas | 5043 | 4683 | 70 |
2463876 | 2463876 | 2022-05-02 | Drew | Arkansas | 5043 | 4683 | 70 |
2456776 | 2456776 | 2022-04-29 | Montague | Texas | 48337 | 4683 | 128 |
2423776 | 2423776 | 2022-04-19 | Coamo | Puerto Rico | 72043 | 4683 | |
2325399 | 2325399 | 2022-03-20 | Texas | Missouri | 29215 | 4683 | 96 |
2322145 | 2322145 | 2022-03-19 | Texas | Missouri | 29215 | 4683 | 96 |
2318891 | 2318891 | 2022-03-18 | Texas | Missouri | 29215 | 4683 | 96 |
2312949 | 2312949 | 2022-03-16 | Craig | Oklahoma | 40035 | 4683 | 52 |
2307790 | 2307790 | 2022-03-15 | Elbert | Colorado | 8039 | 4683 | 37 |
2309696 | 2309696 | 2022-03-15 | Craig | Oklahoma | 40035 | 4683 | 52 |
2306443 | 2306443 | 2022-03-14 | Craig | Oklahoma | 40035 | 4683 | 52 |
2303192 | 2303192 | 2022-03-13 | Craig | Oklahoma | 40035 | 4683 | 52 |
2299940 | 2299940 | 2022-03-12 | Craig | Oklahoma | 40035 | 4683 | 52 |
2296688 | 2296688 | 2022-03-11 | Craig | Oklahoma | 40035 | 4683 | 52 |
2292907 | 2292907 | 2022-03-10 | Lincoln | Montana | 30053 | 4683 | 86 |
2293436 | 2293436 | 2022-03-10 | Craig | Oklahoma | 40035 | 4683 | 52 |
2290729 | 2290729 | 2022-03-09 | Gonzales | Texas | 48177 | 4683 | 95 |
2263494 | 2263494 | 2022-03-01 | Andrew | Missouri | 29003 | 4683 | 54 |
2220123 | 2220123 | 2022-02-16 | Appling | Georgia | 13001 | 4683 | 115 |
2198411 | 2198411 | 2022-02-09 | Jasper | Mississippi | 28061 | 4683 | 69 |
2176459 | 2176459 | 2022-02-02 | Wasco | Oregon | 41065 | 4683 | 53 |
2148652 | 2148652 | 2022-01-25 | McDuffie | Georgia | 13189 | 4683 | 83 |
2135731 | 2135731 | 2022-01-21 | Jerome | Idaho | 16053 | 4683 | 58 |
2120108 | 2120108 | 2022-01-16 | Talbot | Maryland | 24041 | 4683 | 70 |
2083701 | 2083701 | 2022-01-05 | Jefferson | Idaho | 16051 | 4683 | 53 |
2034507 | 2034507 | 2021-12-21 | Jackson | Arkansas | 5067 | 4683 | 47 |
2008617 | 2008617 | 2021-12-13 | Delta | Colorado | 8029 | 4683 | 111 |
1986969 | 1986969 | 2021-12-06 | Le Sueur | Minnesota | 27079 | 4683 | 36 |
1926182 | 1926182 | 2021-11-17 | Arecibo | Puerto Rico | 72013 | 4683 | |
1902471 | 1902471 | 2021-11-10 | Mille Lacs | Minnesota | 27095 | 4683 | 68 |
1897725 | 1897725 | 2021-11-08 | Mingo | West Virginia | 54059 | 4683 | 83 |
1894475 | 1894475 | 2021-11-07 | Mingo | West Virginia | 54059 | 4683 | 82 |
1883041 | 1883041 | 2021-11-04 | Itawamba | Mississippi | 28057 | 4683 | 106 |
1870058 | 1870058 | 2021-10-31 | Leflore | Mississippi | 28083 | 4683 | 144 |
1866809 | 1866809 | 2021-10-30 | Leflore | Mississippi | 28083 | 4683 | 144 |
1863560 | 1863560 | 2021-10-29 | Leflore | Mississippi | 28083 | 4683 | 144 |
1856056 | 1856056 | 2021-10-27 | Gilmer | Georgia | 13123 | 4683 | 134 |
1834344 | 1834344 | 2021-10-20 | Tippah | Mississippi | 28139 | 4683 | 81 |
1821940 | 1821940 | 2021-10-16 | Coshocton | Ohio | 39031 | 4683 | 82 |
1804754 | 1804754 | 2021-10-11 | De Soto | Louisiana | 22031 | 4683 | 107 |
1791938 | 1791938 | 2021-10-07 | Sanilac | Michigan | 26151 | 4683 | 131 |
1788689 | 1788689 | 2021-10-06 | Sanilac | Michigan | 26151 | 4683 | 131 |
1784777 | 1784777 | 2021-10-05 | Lee | Illinois | 17103 | 4683 | 99 |
1746744 | 1746744 | 2021-09-23 | Warren | Missouri | 29219 | 4683 | 40 |
1736764 | 1736764 | 2021-09-20 | Morrison | Minnesota | 27097 | 4683 | 63 |
1690097 | 1690097 | 2021-09-06 | Amador | California | 6005 | 4683 | 53 |
1675730 | 1675730 | 2021-09-01 | Brown | Ohio | 39015 | 4683 | 65 |
1658985 | 1658985 | 2021-08-27 | Marion | Missouri | 29127 | 4683 | 58 |
1659510 | 1659510 | 2021-08-27 | Fulton | Ohio | 39051 | 4683 | 79 |
1652108 | 1652108 | 2021-08-25 | Vernon | Louisiana | 22115 | 4683 | 129 |
1623755 | 1623755 | 2021-08-16 | Ashland | Ohio | 39005 | 4683 | 99 |
1602405 | 1602405 | 2021-08-10 | Lake | California | 6033 | 4683 | 66 |
1604678 | 1604678 | 2021-08-10 | Codington | South Dakota | 46029 | 4683 | 82 |
1601429 | 1601429 | 2021-08-09 | Codington | South Dakota | 46029 | 4683 | 82 |
1598181 | 1598181 | 2021-08-08 | Codington | South Dakota | 46029 | 4683 | 82 |
1594932 | 1594932 | 2021-08-07 | Codington | South Dakota | 46029 | 4683 | 82 |
1591683 | 1591683 | 2021-08-06 | Codington | South Dakota | 46029 | 4683 | 82 |
1588434 | 1588434 | 2021-08-05 | Codington | South Dakota | 46029 | 4683 | 82 |
1585184 | 1585184 | 2021-08-04 | Codington | South Dakota | 46029 | 4683 | 82 |
1576450 | 1576450 | 2021-08-02 | Tuolumne | California | 6109 | 4683 | 73 |
1566674 | 1566674 | 2021-07-30 | Mendocino | California | 6045 | 4683 | 51 |
1563426 | 1563426 | 2021-07-29 | Mendocino | California | 6045 | 4683 | 51 |
1512728 | 1512728 | 2021-07-13 | Panola | Mississippi | 28107 | 4683 | 112 |
1509481 | 1509481 | 2021-07-12 | Panola | Mississippi | 28107 | 4683 | 112 |
1507752 | 1507752 | 2021-07-11 | Henry | Virginia | 51089 | 4683 | 124 |
1504506 | 1504506 | 2021-07-10 | Henry | Virginia | 51089 | 4683 | 124 |
1501260 | 1501260 | 2021-07-09 | Henry | Virginia | 51089 | 4683 | 124 |
1487036 | 1487036 | 2021-07-05 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1483790 | 1483790 | 2021-07-04 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1480544 | 1480544 | 2021-07-03 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1477297 | 1477297 | 2021-07-02 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1474051 | 1474051 | 2021-07-01 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1470805 | 1470805 | 2021-06-30 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1467560 | 1467560 | 2021-06-29 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1464315 | 1464315 | 2021-06-28 | Scotts Bluff | Nebraska | 31157 | 4683 | 96 |
1447396 | 1447396 | 2021-06-23 | Hopkins | Kentucky | 21107 | 4683 | 149 |
1385116 | 1385116 | 2021-06-04 | Effingham | Georgia | 13103 | 4683 | 69 |
1384332 | 1384332 | 2021-06-03 | Wasatch | Utah | 49051 | 4683 | 22 |
1381138 | 1381138 | 2021-06-02 | Culpeper | Virginia | 51047 | 4683 | 65 |
1372443 | 1372443 | 2021-05-31 | Lawrence | Indiana | 18093 | 4683 | 124 |
1369198 | 1369198 | 2021-05-30 | Lawrence | Indiana | 18093 | 4683 | 124 |
1361664 | 1361664 | 2021-05-27 | Culpeper | Virginia | 51047 | 4683 | 64 |
1316454 | 1316454 | 2021-05-13 | Polk | Wisconsin | 55095 | 4683 | 60 |
1271474 | 1271474 | 2021-04-30 | Colquitt | Georgia | 13071 | 4683 | 118 |
1272904 | 1272904 | 2021-04-30 | Clinton | New York | 36019 | 4683 | 33 |
1239204 | 1239204 | 2021-04-20 | Effingham | Illinois | 17049 | 4683 | 82 |
1198423 | 1198423 | 2021-04-07 | Auglaize | Ohio | 39011 | 4683 | 84 |
1182568 | 1182568 | 2021-04-02 | Newberry | South Carolina | 45071 | 4683 | 97 |
1152740 | 1152740 | 2021-03-24 | Cattaraugus | New York | 36009 | 4683 | 79 |
1150812 | 1150812 | 2021-03-23 | Dunn | Wisconsin | 55033 | 4683 | 30 |
1147565 | 1147565 | 2021-03-22 | Dunn | Wisconsin | 55033 | 4683 | 30 |
1139803 | 1139803 | 2021-03-20 | Wayne | New York | 36117 | 4683 | 65 |
1134895 | 1134895 | 2021-03-19 | Tehama | California | 6103 | 4683 | 35 |
1106449 | 1106449 | 2021-03-10 | Boyd | Kentucky | 21019 | 4683 | 47 |
1088510 | 1088510 | 2021-03-04 | Fayette | Tennessee | 47047 | 4683 | 72 |
1084932 | 1084932 | 2021-03-03 | Stephens | Oklahoma | 40137 | 4683 | 68 |
1034015 | 1034015 | 2021-02-15 | Fremont | Wyoming | 56013 | 4683 | 80 |
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);