ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where cases = 3680 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Kentucky 14
- Texas 12
- Tennessee 9
- Virginia 8
- New York 7
- North Carolina 6
- Indiana 5
- Pennsylvania 5
- West Virginia 5
- Louisiana 4
- Minnesota 4
- Ohio 4
- Colorado 3
- Georgia 3
- Illinois 3
- Mississippi 3
- Missouri 3
- Puerto Rico 3
- South Carolina 3
- Alabama 2
- Arkansas 2
- Idaho 2
- Kansas 2
- Maryland 2
- Florida 1
- Michigan 1
- New Mexico 1
- Oklahoma 1
- Oregon 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496897 | 2496897 | 2022-05-12 | Gem | Idaho | 16045 | 3680 | 79 |
2493639 | 2493639 | 2022-05-11 | Gem | Idaho | 16045 | 3680 | 79 |
2372331 | 2372331 | 2022-04-03 | King William | Virginia | 51101 | 3680 | 38 |
2369078 | 2369078 | 2022-04-02 | King William | Virginia | 51101 | 3680 | 38 |
2365825 | 2365825 | 2022-04-01 | King William | Virginia | 51101 | 3680 | 38 |
2362572 | 2362572 | 2022-03-31 | King William | Virginia | 51101 | 3680 | 38 |
2359318 | 2359318 | 2022-03-30 | King William | Virginia | 51101 | 3680 | 38 |
2356064 | 2356064 | 2022-03-29 | King William | Virginia | 51101 | 3680 | 38 |
2324858 | 2324858 | 2022-03-20 | Leslie | Kentucky | 21131 | 3680 | 39 |
2321604 | 2321604 | 2022-03-19 | Leslie | Kentucky | 21131 | 3680 | 39 |
2318350 | 2318350 | 2022-03-18 | Leslie | Kentucky | 21131 | 3680 | 39 |
2315097 | 2315097 | 2022-03-17 | Leslie | Kentucky | 21131 | 3680 | 39 |
2311844 | 2311844 | 2022-03-16 | Leslie | Kentucky | 21131 | 3680 | 39 |
2308591 | 2308591 | 2022-03-15 | Leslie | Kentucky | 21131 | 3680 | 39 |
2305340 | 2305340 | 2022-03-14 | Leslie | Kentucky | 21131 | 3680 | 39 |
2281546 | 2281546 | 2022-03-07 | Lamar | Alabama | 1075 | 3680 | 62 |
2251662 | 2251662 | 2022-02-25 | Colorado | Texas | 48089 | 3680 | 60 |
2251771 | 2251771 | 2022-02-25 | Madison | Texas | 48313 | 3680 | 52 |
2222844 | 2222844 | 2022-02-16 | Grant | West Virginia | 54023 | 3680 | 53 |
2211094 | 2211094 | 2022-02-13 | Washington | Kentucky | 21229 | 3680 | 54 |
2207841 | 2207841 | 2022-02-12 | Washington | Kentucky | 21229 | 3680 | 54 |
2204588 | 2204588 | 2022-02-11 | Washington | Kentucky | 21229 | 3680 | 54 |
2191119 | 2191119 | 2022-02-07 | Massac | Illinois | 17127 | 3680 | 67 |
2187338 | 2187338 | 2022-02-06 | Franklin | Arkansas | 5047 | 3680 | 66 |
2188595 | 2188595 | 2022-02-06 | Redwood | Minnesota | 27127 | 3680 | 51 |
2185342 | 2185342 | 2022-02-05 | Redwood | Minnesota | 27127 | 3680 | 51 |
2182090 | 2182090 | 2022-02-04 | Redwood | Minnesota | 27127 | 3680 | 51 |
2109757 | 2109757 | 2022-01-13 | Ford | Illinois | 17053 | 3680 | 70 |
2066981 | 2066981 | 2021-12-31 | Clark | Arkansas | 5019 | 3680 | 66 |
2057585 | 2057585 | 2021-12-28 | Jones | Georgia | 13169 | 3680 | 99 |
2058699 | 2058699 | 2021-12-28 | Ray | Missouri | 29177 | 3680 | 64 |
2059877 | 2059877 | 2021-12-28 | Lampasas | Texas | 48281 | 3680 | 70 |
2056694 | 2056694 | 2021-12-27 | Scurry | Texas | 48415 | 3680 | 89 |
2031894 | 2031894 | 2021-12-20 | Sullivan | Indiana | 18153 | 3680 | 58 |
1991564 | 1991564 | 2021-12-07 | Gillespie | Texas | 48171 | 3680 | 82 |
1923413 | 1923413 | 2021-11-16 | Reeves | Texas | 48389 | 3680 | 57 |
1918469 | 1918469 | 2021-11-15 | Assumption | Louisiana | 22007 | 3680 | 57 |
1920164 | 1920164 | 2021-11-15 | Reeves | Texas | 48389 | 3680 | 57 |
1916914 | 1916914 | 2021-11-14 | Reeves | Texas | 48389 | 3680 | 57 |
1877652 | 1877652 | 2021-11-02 | Fentress | Tennessee | 47049 | 3680 | 67 |
1811554 | 1811554 | 2021-10-13 | Grenada | Mississippi | 28043 | 3680 | 108 |
1802961 | 1802961 | 2021-10-10 | Morgan | Tennessee | 47129 | 3680 | 46 |
1803484 | 1803484 | 2021-10-10 | Jackson | West Virginia | 54035 | 3680 | 74 |
1799712 | 1799712 | 2021-10-09 | Morgan | Tennessee | 47129 | 3680 | 46 |
1796463 | 1796463 | 2021-10-08 | Morgan | Tennessee | 47129 | 3680 | 46 |
1765371 | 1765371 | 2021-09-29 | Jennings | Indiana | 18079 | 3680 | 59 |
1741290 | 1741290 | 2021-09-21 | Calhoun | Texas | 48057 | 3680 | 32 |
1682540 | 1682540 | 2021-09-03 | Mayaguez | Puerto Rico | 72097 | 3680 | |
1677704 | 1677704 | 2021-09-02 | White | Indiana | 18181 | 3680 | 57 |
1677997 | 1677997 | 2021-09-02 | Montgomery | Kentucky | 21173 | 3680 | 35 |
1671462 | 1671462 | 2021-08-31 | Harlan | Kentucky | 21095 | 3680 | 97 |
1663792 | 1663792 | 2021-08-28 | Logan | West Virginia | 54045 | 3680 | 100 |
1660544 | 1660544 | 2021-08-27 | Logan | West Virginia | 54045 | 3680 | 100 |
1634736 | 1634736 | 2021-08-20 | Pike | Alabama | 1109 | 3680 | 81 |
1627515 | 1627515 | 2021-08-17 | Lauderdale | Tennessee | 47097 | 3680 | 50 |
1543222 | 1543222 | 2021-07-22 | Hopkins | Texas | 48223 | 3680 | 114 |
1530078 | 1530078 | 2021-07-18 | Macon | Tennessee | 47111 | 3680 | 78 |
1526831 | 1526831 | 2021-07-17 | Macon | Tennessee | 47111 | 3680 | 78 |
1523584 | 1523584 | 2021-07-16 | Macon | Tennessee | 47111 | 3680 | 78 |
1490433 | 1490433 | 2021-07-06 | Warren | New York | 36113 | 3680 | 58 |
1487186 | 1487186 | 2021-07-05 | Warren | New York | 36113 | 3680 | 57 |
1483940 | 1483940 | 2021-07-04 | Warren | New York | 36113 | 3680 | 57 |
1480694 | 1480694 | 2021-07-03 | Warren | New York | 36113 | 3680 | 57 |
1477866 | 1477866 | 2021-07-02 | Snyder | Pennsylvania | 42109 | 3680 | 86 |
1477949 | 1477949 | 2021-07-02 | Trujillo Alto | Puerto Rico | 72139 | 3680 | |
1474620 | 1474620 | 2021-07-01 | Snyder | Pennsylvania | 42109 | 3680 | 86 |
1471374 | 1471374 | 2021-06-30 | Snyder | Pennsylvania | 42109 | 3680 | 86 |
1427155 | 1427155 | 2021-06-17 | Montrose | Colorado | 8085 | 3680 | 63 |
1424848 | 1424848 | 2021-06-16 | Worcester | Maryland | 24047 | 3680 | 106 |
1421419 | 1421419 | 2021-06-15 | Greenup | Kentucky | 21089 | 3680 | 63 |
1421600 | 1421600 | 2021-06-15 | Worcester | Maryland | 24047 | 3680 | 106 |
1400085 | 1400085 | 2021-06-08 | Colleton | South Carolina | 45029 | 3680 | 129 |
1390348 | 1390348 | 2021-06-05 | Colleton | South Carolina | 45029 | 3680 | 129 |
1382364 | 1382364 | 2021-06-03 | Harvey | Kansas | 20079 | 3680 | 72 |
1379119 | 1379119 | 2021-06-02 | Harvey | Kansas | 20079 | 3680 | 72 |
1373972 | 1373972 | 2021-05-31 | Clinton | Pennsylvania | 42035 | 3680 | 66 |
1370727 | 1370727 | 2021-05-30 | Clinton | Pennsylvania | 42035 | 3680 | 66 |
1355264 | 1355264 | 2021-05-25 | Tazewell | Virginia | 51185 | 3680 | 70 |
1255982 | 1255982 | 2021-04-25 | St. John the Baptist | Louisiana | 22095 | 3680 | 137 |
1252735 | 1252735 | 2021-04-24 | St. John the Baptist | Louisiana | 22095 | 3680 | 137 |
1249488 | 1249488 | 2021-04-23 | St. John the Baptist | Louisiana | 22095 | 3680 | 137 |
1193903 | 1193903 | 2021-04-06 | Whitley | Indiana | 18183 | 3680 | 39 |
1156000 | 1156000 | 2021-03-25 | Fulton | New York | 36035 | 3680 | 85 |
1133307 | 1133307 | 2021-03-18 | Tompkins | New York | 36109 | 3680 | 47 |
1126992 | 1126992 | 2021-03-16 | Crawford | Ohio | 39033 | 3680 | 99 |
1127164 | 1127164 | 2021-03-16 | Linn | Oregon | 41043 | 3680 | 58 |
1106895 | 1106895 | 2021-03-10 | Lincoln | Mississippi | 28085 | 3680 | 104 |
1097702 | 1097702 | 2021-03-07 | Yadkin | North Carolina | 37197 | 3680 | 46 |
1094454 | 1094454 | 2021-03-06 | Yadkin | North Carolina | 37197 | 3680 | 46 |
1095583 | 1095583 | 2021-03-06 | Ohio | West Virginia | 54069 | 3680 | 67 |
1089704 | 1089704 | 2021-03-05 | Oconee | Georgia | 13219 | 3680 | 62 |
1072130 | 1072130 | 2021-02-27 | Toa Alta | Puerto Rico | 72135 | 3680 | |
1041771 | 1041771 | 2021-02-18 | Barry | Michigan | 26015 | 3680 | 42 |
1026355 | 1026355 | 2021-02-13 | Ashland | Ohio | 39005 | 3680 | 86 |
1018086 | 1018086 | 2021-02-11 | Logan | Colorado | 8075 | 3680 | 62 |
1005578 | 1005578 | 2021-02-07 | Montgomery | Indiana | 18107 | 3680 | 81 |
1004112 | 1004112 | 2021-02-06 | Cheatham | Tennessee | 47021 | 3680 | 38 |
993431 | 993431 | 2021-02-03 | Scott | Missouri | 29201 | 3680 | 71 |
986892 | 986892 | 2021-02-01 | Johnson | Missouri | 29101 | 3680 | 35 |
983140 | 983140 | 2021-01-31 | Graves | Kentucky | 21083 | 3680 | 63 |
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);