ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
197 rows where cases = 2366 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 21
- Georgia 20
- Texas 17
- Iowa 9
- Minnesota 9
- Puerto Rico 9
- Alabama 8
- Virginia 8
- Colorado 7
- Illinois 7
- Missouri 7
- Louisiana 6
- Mississippi 6
- Florida 5
- Idaho 5
- Indiana 5
- Ohio 5
- New York 4
- Pennsylvania 4
- Wisconsin 4
- Arkansas 3
- California 3
- Nevada 3
- Oregon 3
- Utah 3
- Michigan 2
- Montana 2
- Nebraska 2
- North Dakota 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466772 | 2466772 | 2022-05-02 | Poquoson city | Virginia | 51735 | 2366 | 30 |
2461585 | 2461585 | 2022-05-01 | Owen | Kentucky | 21187 | 2366 | 33 |
2458329 | 2458329 | 2022-04-30 | Owen | Kentucky | 21187 | 2366 | 33 |
2455073 | 2455073 | 2022-04-29 | Owen | Kentucky | 21187 | 2366 | 33 |
2451817 | 2451817 | 2022-04-28 | Owen | Kentucky | 21187 | 2366 | 33 |
2452466 | 2452466 | 2022-04-28 | Red Willow | Nebraska | 31145 | 2366 | 20 |
2448561 | 2448561 | 2022-04-27 | Owen | Kentucky | 21187 | 2366 | 33 |
2445305 | 2445305 | 2022-04-26 | Owen | Kentucky | 21187 | 2366 | 33 |
2442049 | 2442049 | 2022-04-25 | Owen | Kentucky | 21187 | 2366 | 33 |
2438793 | 2438793 | 2022-04-24 | Owen | Kentucky | 21187 | 2366 | 33 |
2435537 | 2435537 | 2022-04-23 | Owen | Kentucky | 21187 | 2366 | 33 |
2432281 | 2432281 | 2022-04-22 | Owen | Kentucky | 21187 | 2366 | 33 |
2429025 | 2429025 | 2022-04-21 | Owen | Kentucky | 21187 | 2366 | 33 |
2425769 | 2425769 | 2022-04-20 | Owen | Kentucky | 21187 | 2366 | 33 |
2422513 | 2422513 | 2022-04-19 | Owen | Kentucky | 21187 | 2366 | 33 |
2419257 | 2419257 | 2022-04-18 | Owen | Kentucky | 21187 | 2366 | 33 |
2327645 | 2327645 | 2022-03-21 | Washington | Idaho | 16087 | 2366 | 56 |
2324392 | 2324392 | 2022-03-20 | Washington | Idaho | 16087 | 2366 | 56 |
2321138 | 2321138 | 2022-03-19 | Washington | Idaho | 16087 | 2366 | 56 |
2317884 | 2317884 | 2022-03-18 | Washington | Idaho | 16087 | 2366 | 56 |
2269028 | 2269028 | 2022-03-03 | Towns | Georgia | 13281 | 2366 | 102 |
2206784 | 2206784 | 2022-02-12 | Sumter | Alabama | 1119 | 2366 | 44 |
2197215 | 2197215 | 2022-02-09 | Bent | Colorado | 8011 | 2366 | 47 |
2183553 | 2183553 | 2022-02-04 | Trinity | Texas | 48455 | 2366 | 67 |
2176575 | 2176575 | 2022-02-02 | Luquillo | Puerto Rico | 72089 | 2366 | |
2162710 | 2162710 | 2022-01-29 | Douglas | Missouri | 29067 | 2366 | 68 |
2163534 | 2163534 | 2022-01-29 | Ciales | Puerto Rico | 72039 | 2366 | |
2155677 | 2155677 | 2022-01-27 | Bath | Kentucky | 21011 | 2366 | 34 |
2127422 | 2127422 | 2022-01-18 | McLean | North Dakota | 38055 | 2366 | 47 |
2087806 | 2087806 | 2022-01-06 | Greene | Mississippi | 28041 | 2366 | 50 |
2057542 | 2057542 | 2021-12-28 | Dade | Georgia | 13083 | 2366 | 22 |
2057948 | 2057948 | 2021-12-28 | Hancock | Iowa | 19081 | 2366 | 41 |
2059230 | 2059230 | 2021-12-28 | Morgan | Ohio | 39115 | 2366 | 43 |
2054699 | 2054699 | 2021-12-27 | Hancock | Iowa | 19081 | 2366 | 41 |
2051449 | 2051449 | 2021-12-26 | Hancock | Iowa | 19081 | 2366 | 41 |
2048199 | 2048199 | 2021-12-25 | Hancock | Iowa | 19081 | 2366 | 41 |
2044949 | 2044949 | 2021-12-24 | Hancock | Iowa | 19081 | 2366 | 41 |
2041700 | 2041700 | 2021-12-23 | Hancock | Iowa | 19081 | 2366 | 41 |
2038450 | 2038450 | 2021-12-22 | Hancock | Iowa | 19081 | 2366 | 41 |
2028264 | 2028264 | 2021-12-19 | Bleckley | Georgia | 13023 | 2366 | 84 |
2025013 | 2025013 | 2021-12-18 | Bleckley | Georgia | 13023 | 2366 | 84 |
2026988 | 2026988 | 2021-12-18 | Las Piedras | Puerto Rico | 72085 | 2366 | |
2021762 | 2021762 | 2021-12-17 | Bleckley | Georgia | 13023 | 2366 | 84 |
2012010 | 2012010 | 2021-12-14 | Bleckley | Georgia | 13023 | 2366 | 84 |
2014540 | 2014540 | 2021-12-14 | Alleghany | Virginia | 51005 | 2366 | 85 |
2008759 | 2008759 | 2021-12-13 | Bleckley | Georgia | 13023 | 2366 | 85 |
2003430 | 2003430 | 2021-12-11 | Osage | Missouri | 29151 | 2366 | 35 |
1989513 | 1989513 | 2021-12-07 | Mason | Illinois | 17125 | 2366 | 54 |
1931871 | 1931871 | 2021-11-19 | Dallas | Missouri | 29059 | 2366 | 57 |
1889656 | 1889656 | 2021-11-06 | Madison | Missouri | 29123 | 2366 | 27 |
1848754 | 1848754 | 2021-10-24 | San Juan | Utah | 49037 | 2366 | 41 |
1845504 | 1845504 | 2021-10-23 | San Juan | Utah | 49037 | 2366 | 41 |
1842254 | 1842254 | 2021-10-22 | San Juan | Utah | 49037 | 2366 | 41 |
1837516 | 1837516 | 2021-10-21 | Wadena | Minnesota | 27159 | 2366 | 29 |
1834267 | 1834267 | 2021-10-20 | Wadena | Minnesota | 27159 | 2366 | 29 |
1829856 | 1829856 | 2021-10-19 | Alamosa | Colorado | 8003 | 2366 | 44 |
1831212 | 1831212 | 2021-10-19 | Ste. Genevieve | Missouri | 29186 | 2366 | 29 |
1827424 | 1827424 | 2021-10-18 | Larue | Kentucky | 21123 | 2366 | 45 |
1809179 | 1809179 | 2021-10-12 | Montour | Pennsylvania | 42093 | 2366 | 70 |
1803758 | 1803758 | 2021-10-11 | Howard | Arkansas | 5061 | 2366 | 35 |
1781165 | 1781165 | 2021-10-04 | Otero | Colorado | 8089 | 2366 | 75 |
1765692 | 1765692 | 2021-09-29 | Lawrence | Kentucky | 21127 | 2366 | 36 |
1758534 | 1758534 | 2021-09-27 | Brooks | Georgia | 13027 | 2366 | 61 |
1757734 | 1757734 | 2021-09-26 | Tyler | Texas | 48457 | 2366 | 62 |
1754486 | 1754486 | 2021-09-25 | Tyler | Texas | 48457 | 2366 | 62 |
1750782 | 1750782 | 2021-09-24 | San Lorenzo | Puerto Rico | 72129 | 2366 | |
1751238 | 1751238 | 2021-09-24 | Tyler | Texas | 48457 | 2366 | 61 |
1747989 | 1747989 | 2021-09-23 | Tyler | Texas | 48457 | 2366 | 61 |
1737835 | 1737835 | 2021-09-20 | Lee | South Carolina | 45061 | 2366 | 68 |
1720925 | 1720925 | 2021-09-15 | Coos | New Hampshire | 33007 | 2366 | 46 |
1721185 | 1721185 | 2021-09-15 | Rolette | North Dakota | 38079 | 2366 | 28 |
1715418 | 1715418 | 2021-09-13 | Llano | Texas | 48299 | 2366 | 61 |
1708533 | 1708533 | 2021-09-11 | Moca | Puerto Rico | 72099 | 2366 | |
1705286 | 1705286 | 2021-09-10 | Moca | Puerto Rico | 72099 | 2366 | |
1702678 | 1702678 | 2021-09-09 | Powhatan | Virginia | 51145 | 2366 | 19 |
1698930 | 1698930 | 2021-09-08 | Union | South Dakota | 46127 | 2366 | 43 |
1671835 | 1671835 | 2021-08-31 | Calhoun | Mississippi | 28013 | 2366 | 36 |
1645857 | 1645857 | 2021-08-23 | Clarke | Mississippi | 28023 | 2366 | 81 |
1636780 | 1636780 | 2021-08-20 | Hocking | Ohio | 39073 | 2366 | 63 |
1618557 | 1618557 | 2021-08-15 | Ashley | Arkansas | 5003 | 2366 | 38 |
1585530 | 1585530 | 2021-08-04 | Robertson | Texas | 48395 | 2366 | 48 |
1579648 | 1579648 | 2021-08-03 | Calaveras | California | 6009 | 2366 | 57 |
1579899 | 1579899 | 2021-08-03 | Elbert | Georgia | 13105 | 2366 | 74 |
1576401 | 1576401 | 2021-08-02 | Colusa | California | 6011 | 2366 | 18 |
1538609 | 1538609 | 2021-07-21 | Martin | Minnesota | 27091 | 2366 | 33 |
1534767 | 1534767 | 2021-07-20 | Spencer | Indiana | 18147 | 2366 | 31 |
1535362 | 1535362 | 2021-07-20 | Martin | Minnesota | 27091 | 2366 | 33 |
1531487 | 1531487 | 2021-07-19 | Jennings | Indiana | 18079 | 2366 | 51 |
1527796 | 1527796 | 2021-07-18 | Routt | Colorado | 8107 | 2366 | 21 |
1524549 | 1524549 | 2021-07-17 | Routt | Colorado | 8107 | 2366 | 21 |
1521301 | 1521301 | 2021-07-16 | Routt | Colorado | 8107 | 2366 | 21 |
1509138 | 1509138 | 2021-07-12 | Assumption | Louisiana | 22007 | 2366 | 36 |
1459827 | 1459827 | 2021-06-27 | Pike | Georgia | 13231 | 2366 | 43 |
1460345 | 1460345 | 2021-06-27 | Carter | Kentucky | 21043 | 2366 | 35 |
1456582 | 1456582 | 2021-06-26 | Pike | Georgia | 13231 | 2366 | 43 |
1457100 | 1457100 | 2021-06-26 | Carter | Kentucky | 21043 | 2366 | 35 |
1453855 | 1453855 | 2021-06-25 | Carter | Kentucky | 21043 | 2366 | 35 |
1420428 | 1420428 | 2021-06-15 | Pickens | Alabama | 1107 | 2366 | 62 |
1417183 | 1417183 | 2021-06-14 | Pickens | Alabama | 1107 | 2366 | 62 |
1403587 | 1403587 | 2021-06-09 | Dimmit | Texas | 48127 | 2366 | 36 |
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);