ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 4642 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- North Carolina 9
- Georgia 8
- Alabama 7
- Louisiana 5
- Minnesota 5
- South Carolina 5
- Puerto Rico 4
- Arkansas 3
- California 3
- Indiana 3
- Kentucky 3
- Oklahoma 3
- Tennessee 3
- Texas 3
- Maryland 2
- Mississippi 2
- Virginia 2
- Florida 1
- Illinois 1
- Missouri 1
- New Hampshire 1
- New York 1
- North Dakota 1
- South Dakota 1
- Vermont 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2348912 | 2348912 | 2022-03-27 | Camuy | Puerto Rico | 72027 | 4642 | |
2278807 | 2278807 | 2022-03-06 | Worth | Georgia | 13321 | 4642 | 109 |
2275554 | 2275554 | 2022-03-05 | Worth | Georgia | 13321 | 4642 | 109 |
2272301 | 2272301 | 2022-03-04 | Worth | Georgia | 13321 | 4642 | 109 |
2269049 | 2269049 | 2022-03-03 | Worth | Georgia | 13321 | 4642 | 109 |
2265796 | 2265796 | 2022-03-02 | Worth | Georgia | 13321 | 4642 | 109 |
2226266 | 2226266 | 2022-02-18 | Hale | Alabama | 1065 | 4642 | 97 |
2222447 | 2222447 | 2022-02-16 | Gonzales | Texas | 48177 | 4642 | 93 |
2216610 | 2216610 | 2022-02-15 | Cross | Arkansas | 5037 | 4642 | 75 |
2211095 | 2211095 | 2022-02-13 | Wayne | Kentucky | 21231 | 4642 | 85 |
2211911 | 2211911 | 2022-02-13 | Currituck | North Carolina | 37053 | 4642 | 32 |
2207842 | 2207842 | 2022-02-12 | Wayne | Kentucky | 21231 | 4642 | 85 |
2208658 | 2208658 | 2022-02-12 | Currituck | North Carolina | 37053 | 4642 | 32 |
2204589 | 2204589 | 2022-02-11 | Wayne | Kentucky | 21231 | 4642 | 85 |
2205405 | 2205405 | 2022-02-11 | Currituck | North Carolina | 37053 | 4642 | 32 |
2122863 | 2122863 | 2022-01-17 | Fountain | Indiana | 18045 | 4642 | 83 |
2098481 | 2098481 | 2022-01-09 | Corozal | Puerto Rico | 72047 | 4642 | |
2008029 | 2008029 | 2021-12-12 | Washington | Vermont | 50023 | 4642 | 30 |
2001999 | 2001999 | 2021-12-11 | Jackson | Arkansas | 5067 | 4642 | 47 |
1962881 | 1962881 | 2021-11-29 | Geneva | Alabama | 1061 | 4642 | 136 |
1959630 | 1959630 | 2021-11-28 | Geneva | Alabama | 1061 | 4642 | 136 |
1956379 | 1956379 | 2021-11-27 | Geneva | Alabama | 1061 | 4642 | 136 |
1945848 | 1945848 | 2021-11-23 | Lawrence | South Dakota | 46081 | 4642 | 65 |
1922646 | 1922646 | 2021-11-16 | Stutsman | North Dakota | 38093 | 4642 | 89 |
1900416 | 1900416 | 2021-11-09 | Hickman | Tennessee | 47081 | 4642 | 78 |
1884992 | 1884992 | 2021-11-05 | Johnson | Arkansas | 5071 | 4642 | 58 |
1877559 | 1877559 | 2021-11-02 | Union | South Carolina | 45087 | 4642 | 106 |
1874188 | 1874188 | 2021-11-01 | Arecibo | Puerto Rico | 72013 | 4642 | |
1836559 | 1836559 | 2021-10-21 | Gilmer | Georgia | 13123 | 4642 | 133 |
1826896 | 1826896 | 2021-10-18 | Unknown | Georgia | 4642 | 8 | |
1801505 | 1801505 | 2021-10-10 | De Soto | Louisiana | 22031 | 4642 | 107 |
1798256 | 1798256 | 2021-10-09 | De Soto | Louisiana | 22031 | 4642 | 107 |
1795007 | 1795007 | 2021-10-08 | De Soto | Louisiana | 22031 | 4642 | 107 |
1735411 | 1735411 | 2021-09-20 | Dallas | Alabama | 1047 | 4642 | 178 |
1737366 | 1737366 | 2021-09-20 | Person | North Carolina | 37145 | 4642 | 78 |
1663928 | 1663928 | 2021-08-29 | Chambers | Alabama | 1017 | 4642 | 127 |
1666350 | 1666350 | 2021-08-29 | Colleton | South Carolina | 45029 | 4642 | 144 |
1663102 | 1663102 | 2021-08-28 | Colleton | South Carolina | 45029 | 4642 | 144 |
1659854 | 1659854 | 2021-08-27 | Colleton | South Carolina | 45029 | 4642 | 144 |
1649137 | 1649137 | 2021-08-24 | Lincoln | Mississippi | 28085 | 4642 | 122 |
1650529 | 1650529 | 2021-08-24 | Titus | Texas | 48449 | 4642 | 88 |
1634530 | 1634530 | 2021-08-19 | Whitman | Washington | 53075 | 4642 | 54 |
1577566 | 1577566 | 2021-08-02 | Itasca | Minnesota | 27061 | 4642 | 68 |
1452707 | 1452707 | 2021-06-24 | Marion | West Virginia | 54049 | 4642 | 52 |
1381171 | 1381171 | 2021-06-02 | James City | Virginia | 51095 | 4642 | 72 |
1374680 | 1374680 | 2021-05-31 | James City | Virginia | 51095 | 4642 | 72 |
1346474 | 1346474 | 2021-05-23 | Lawrence | Indiana | 18093 | 4642 | 123 |
1337891 | 1337891 | 2021-05-20 | Beaufort | North Carolina | 37013 | 4642 | 95 |
1304861 | 1304861 | 2021-05-10 | Douglas | Minnesota | 27041 | 4642 | 74 |
1256669 | 1256669 | 2021-04-25 | Clinton | New York | 36019 | 4642 | 33 |
1252220 | 1252220 | 2021-04-24 | Livingston | Illinois | 17105 | 4642 | 95 |
1247723 | 1247723 | 2021-04-22 | Burnet | Texas | 48053 | 4642 | 63 |
1222766 | 1222766 | 2021-04-15 | Colquitt | Georgia | 13071 | 4642 | 114 |
1224769 | 1224769 | 2021-04-15 | Chesterfield | South Carolina | 45025 | 4642 | 102 |
1209302 | 1209302 | 2021-04-10 | Pierce | Wisconsin | 55093 | 4642 | 41 |
1156057 | 1156057 | 2021-03-25 | Carteret | North Carolina | 37031 | 4642 | 45 |
1076247 | 1076247 | 2021-03-01 | Dale | Alabama | 1045 | 4642 | 107 |
1062214 | 1062214 | 2021-02-24 | Stephens | Oklahoma | 40137 | 4642 | 66 |
993386 | 993386 | 2021-02-03 | Joplin | Missouri | 4642 | 96 | |
980794 | 980794 | 2021-01-30 | Granville | North Carolina | 37077 | 4642 | 72 |
977548 | 977548 | 2021-01-29 | Granville | North Carolina | 37077 | 4642 | 72 |
973700 | 973700 | 2021-01-28 | Chisago | Minnesota | 27025 | 4642 | 38 |
967081 | 967081 | 2021-01-26 | Cecil | Maryland | 24015 | 4642 | 107 |
964814 | 964814 | 2021-01-25 | Le Flore | Oklahoma | 40079 | 4642 | 37 |
960764 | 960764 | 2021-01-24 | Otter Tail | Minnesota | 27111 | 4642 | 68 |
925837 | 925837 | 2021-01-13 | Bryan | Oklahoma | 40013 | 4642 | 41 |
926231 | 926231 | 2021-01-13 | Dyer | Tennessee | 47045 | 4642 | 81 |
876145 | 876145 | 2020-12-29 | Iberia | Louisiana | 22045 | 4642 | 120 |
849766 | 849766 | 2020-12-21 | Floyd | Indiana | 18043 | 4642 | 91 |
837182 | 837182 | 2020-12-17 | Acadia | Louisiana | 22001 | 4642 | 131 |
837493 | 837493 | 2020-12-17 | Forrest | Mississippi | 28035 | 4642 | 93 |
808239 | 808239 | 2020-12-08 | Rice | Minnesota | 27131 | 4642 | 40 |
728058 | 728058 | 2020-11-13 | Carolina | Puerto Rico | 72031 | 4642 | |
679062 | 679062 | 2020-10-29 | Wayne | North Carolina | 37191 | 4642 | 81 |
596175 | 596175 | 2020-10-04 | Madera | California | 6039 | 4642 | 70 |
597753 | 597753 | 2020-10-04 | Hillsborough | New Hampshire | 33011 | 4642 | 292 |
592933 | 592933 | 2020-10-03 | Madera | California | 6039 | 4642 | 70 |
589693 | 589693 | 2020-10-02 | Madera | California | 6039 | 4642 | 70 |
411008 | 411008 | 2020-08-07 | Knox | Tennessee | 47093 | 4642 | 42 |
405595 | 405595 | 2020-08-06 | Leon | Florida | 12073 | 4642 | 23 |
152360 | 152360 | 2020-05-17 | Baltimore | Maryland | 24005 | 4642 | 250 |
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);