ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 3716 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Illinois 11
- Missouri 8
- Ohio 7
- North Carolina 6
- Alabama 5
- Indiana 5
- Pennsylvania 5
- Virginia 5
- Georgia 4
- Louisiana 4
- Florida 3
- Kentucky 3
- Nebraska 3
- Oregon 3
- Kansas 2
- Maryland 2
- New York 2
- Arkansas 1
- California 1
- Colorado 1
- Iowa 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Montana 1
- Nevada 1
- Oklahoma 1
- Puerto Rico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451415 | 2451415 | 2022-04-28 | Wabash | Illinois | 17185 | 3716 | 31 |
2448159 | 2448159 | 2022-04-27 | Wabash | Illinois | 17185 | 3716 | 31 |
2444903 | 2444903 | 2022-04-26 | Wabash | Illinois | 17185 | 3716 | 31 |
2446471 | 2446471 | 2022-04-26 | Tillamook | Oregon | 41057 | 3716 | 64 |
2441647 | 2441647 | 2022-04-25 | Wabash | Illinois | 17185 | 3716 | 31 |
2433528 | 2433528 | 2022-04-22 | Anasco | Puerto Rico | 72011 | 3716 | |
2381869 | 2381869 | 2022-04-06 | Leon | Texas | 48289 | 3716 | 93 |
2378614 | 2378614 | 2022-04-05 | Leon | Texas | 48289 | 3716 | 93 |
2375360 | 2375360 | 2022-04-04 | Leon | Texas | 48289 | 3716 | 93 |
2372108 | 2372108 | 2022-04-03 | Leon | Texas | 48289 | 3716 | 93 |
2347258 | 2347258 | 2022-03-27 | Wabash | Illinois | 17185 | 3716 | 30 |
2344005 | 2344005 | 2022-03-26 | Wabash | Illinois | 17185 | 3716 | 30 |
2340752 | 2340752 | 2022-03-25 | Wabash | Illinois | 17185 | 3716 | 30 |
2310461 | 2310461 | 2022-03-15 | Appomattox | Virginia | 51011 | 3716 | 51 |
2256997 | 2256997 | 2022-02-27 | Bates | Missouri | 29013 | 3716 | 82 |
2253746 | 2253746 | 2022-02-26 | Bates | Missouri | 29013 | 3716 | 82 |
2250495 | 2250495 | 2022-02-25 | Bates | Missouri | 29013 | 3716 | 82 |
2213925 | 2213925 | 2022-02-14 | Wabash | Illinois | 17185 | 3716 | 26 |
2188771 | 2188771 | 2022-02-06 | Moniteau | Missouri | 29135 | 3716 | 49 |
2171908 | 2171908 | 2022-02-01 | Osage | Kansas | 20139 | 3716 | 42 |
2173649 | 2173649 | 2022-02-01 | Freestone | Texas | 48161 | 3716 | 80 |
2168655 | 2168655 | 2022-01-31 | Osage | Kansas | 20139 | 3716 | 42 |
2152482 | 2152482 | 2022-01-26 | Lawrence | Kentucky | 21127 | 3716 | 52 |
2143954 | 2143954 | 2022-01-23 | Fulton | Pennsylvania | 42057 | 3716 | 56 |
2126008 | 2126008 | 2022-01-18 | De Witt | Illinois | 17039 | 3716 | 40 |
2128402 | 2128402 | 2022-01-18 | New Kent | Virginia | 51127 | 3716 | 28 |
2103057 | 2103057 | 2022-01-11 | Crisp | Georgia | 13081 | 3716 | 121 |
2087892 | 2087892 | 2022-01-06 | Clinton | Missouri | 29049 | 3716 | 100 |
2084759 | 2084759 | 2022-01-05 | Lincoln | Montana | 30053 | 3716 | 73 |
2079990 | 2079990 | 2022-01-04 | Columbia | Arkansas | 5027 | 3716 | 77 |
2079735 | 2079735 | 2022-01-03 | Lewis | West Virginia | 54041 | 3716 | 66 |
2043161 | 2043161 | 2021-12-23 | Juniata | Pennsylvania | 42067 | 3716 | 143 |
2040620 | 2040620 | 2021-12-22 | Mecklenburg | Virginia | 51117 | 3716 | 94 |
2028317 | 2028317 | 2021-12-19 | Grady | Georgia | 13131 | 3716 | 91 |
2025066 | 2025066 | 2021-12-18 | Grady | Georgia | 13131 | 3716 | 91 |
2021815 | 2021815 | 2021-12-17 | Grady | Georgia | 13131 | 3716 | 91 |
2021298 | 2021298 | 2021-12-16 | Langlade | Wisconsin | 55067 | 3716 | 62 |
2008359 | 2008359 | 2021-12-13 | Barbour | Alabama | 1005 | 3716 | 81 |
2005108 | 2005108 | 2021-12-12 | Barbour | Alabama | 1005 | 3716 | 81 |
2001857 | 2001857 | 2021-12-11 | Barbour | Alabama | 1005 | 3716 | 81 |
1992832 | 1992832 | 2021-12-08 | Fulton | Indiana | 18049 | 3716 | 74 |
1966746 | 1966746 | 2021-11-30 | Jersey | Illinois | 17083 | 3716 | 74 |
1968923 | 1968923 | 2021-11-30 | Reeves | Texas | 48389 | 3716 | 58 |
1929056 | 1929056 | 2021-11-18 | Martin | North Carolina | 37117 | 3716 | 74 |
1918116 | 1918116 | 2021-11-15 | Randolph | Indiana | 18135 | 3716 | 106 |
1915681 | 1915681 | 2021-11-14 | Randolph | Missouri | 29175 | 3716 | 37 |
1878155 | 1878155 | 2021-11-02 | Winchester city | Virginia | 51840 | 3716 | 55 |
1779296 | 1779296 | 2021-10-03 | Adams | Nebraska | 31001 | 3716 | 54 |
1776046 | 1776046 | 2021-10-02 | Adams | Nebraska | 31001 | 3716 | 54 |
1772796 | 1772796 | 2021-10-01 | Adams | Nebraska | 31001 | 3716 | 54 |
1764084 | 1764084 | 2021-09-28 | Frio | Texas | 48163 | 3716 | 65 |
1714209 | 1714209 | 2021-09-13 | Miller | Missouri | 29131 | 3716 | 69 |
1643156 | 1643156 | 2021-08-22 | Pasquotank | North Carolina | 37139 | 3716 | 88 |
1639906 | 1639906 | 2021-08-21 | Pasquotank | North Carolina | 37139 | 3716 | 88 |
1636656 | 1636656 | 2021-08-20 | Pasquotank | North Carolina | 37139 | 3716 | 88 |
1632205 | 1632205 | 2021-08-19 | Ripley | Indiana | 18137 | 3716 | 72 |
1610067 | 1610067 | 2021-08-12 | Lyon | Minnesota | 27083 | 3716 | 54 |
1576222 | 1576222 | 2021-08-02 | Clarke | Alabama | 1025 | 3716 | 63 |
1539520 | 1539520 | 2021-07-21 | Clinton | Pennsylvania | 42035 | 3716 | 68 |
1536273 | 1536273 | 2021-07-20 | Clinton | Pennsylvania | 42035 | 3716 | 68 |
1522229 | 1522229 | 2021-07-16 | Worcester | Maryland | 24047 | 3716 | 106 |
1518980 | 1518980 | 2021-07-15 | Worcester | Maryland | 24047 | 3716 | 106 |
1490077 | 1490077 | 2021-07-06 | Howell | Missouri | 29091 | 3716 | 46 |
1487718 | 1487718 | 2021-07-05 | Colleton | South Carolina | 45029 | 3716 | 132 |
1404156 | 1404156 | 2021-06-10 | Chambers | Alabama | 1017 | 3716 | 124 |
1403137 | 1403137 | 2021-06-09 | Douglas | Oregon | 41019 | 3716 | 80 |
1395180 | 1395180 | 2021-06-07 | Putnam | Indiana | 18133 | 3716 | 60 |
1373813 | 1373813 | 2021-05-31 | Ottawa | Ohio | 39123 | 3716 | 81 |
1370568 | 1370568 | 2021-05-30 | Ottawa | Ohio | 39123 | 3716 | 81 |
1367322 | 1367322 | 2021-05-29 | Ottawa | Ohio | 39123 | 3716 | 81 |
1364076 | 1364076 | 2021-05-28 | Ottawa | Ohio | 39123 | 3716 | 81 |
1333038 | 1333038 | 2021-05-19 | Summit | Colorado | 8117 | 3716 | 8 |
1313860 | 1313860 | 2021-05-13 | Bureau | Illinois | 17011 | 3716 | 95 |
1311864 | 1311864 | 2021-05-12 | Cortland | New York | 36023 | 3716 | 60 |
1306362 | 1306362 | 2021-05-10 | Titus | Texas | 48449 | 3716 | 83 |
1303116 | 1303116 | 2021-05-09 | Titus | Texas | 48449 | 3716 | 83 |
1291697 | 1291697 | 2021-05-06 | St. John the Baptist | Louisiana | 22095 | 3716 | 138 |
1288451 | 1288451 | 2021-05-05 | St. John the Baptist | Louisiana | 22095 | 3716 | 138 |
1269789 | 1269789 | 2021-04-29 | Scotland | North Carolina | 37165 | 3716 | 84 |
1240707 | 1240707 | 2021-04-20 | Preble | Ohio | 39135 | 3716 | 98 |
1143226 | 1143226 | 2021-03-21 | Crawford | Ohio | 39033 | 3716 | 100 |
1090244 | 1090244 | 2021-03-05 | Franklin | Kentucky | 21073 | 3716 | 30 |
1079301 | 1079301 | 2021-03-01 | Lewis | Washington | 53041 | 3716 | 50 |
1049274 | 1049274 | 2021-02-20 | Yamhill | Oregon | 41071 | 3716 | 62 |
987447 | 987447 | 2021-02-01 | Knox | Ohio | 39083 | 3716 | 23 |
967360 | 967360 | 2021-01-26 | Warren | Mississippi | 28149 | 3716 | 103 |
947451 | 947451 | 2021-01-20 | Henderson | Kentucky | 21101 | 3716 | 52 |
938867 | 938867 | 2021-01-17 | Osage | Oklahoma | 40113 | 3716 | 34 |
895796 | 895796 | 2021-01-04 | St. Joseph | Michigan | 26149 | 3716 | 58 |
834701 | 834701 | 2020-12-16 | Saratoga | New York | 36091 | 3716 | 26 |
800740 | 800740 | 2020-12-06 | Sumter | Florida | 12119 | 3716 | 101 |
788266 | 788266 | 2020-12-02 | Webster | Iowa | 19187 | 3716 | 39 |
758525 | 758525 | 2020-11-23 | Jackson | Florida | 12063 | 3716 | 89 |
718283 | 718283 | 2020-11-10 | Lebanon | Pennsylvania | 42075 | 3716 | 75 |
700523 | 700523 | 2020-11-05 | Monroe | Indiana | 18105 | 3716 | 45 |
616597 | 616597 | 2020-10-10 | Terrebonne | Louisiana | 22109 | 3716 | 119 |
613356 | 613356 | 2020-10-09 | Terrebonne | Louisiana | 22109 | 3716 | 119 |
556763 | 556763 | 2020-09-21 | Alexandria city | Virginia | 51510 | 3716 | 68 |
452296 | 452296 | 2020-08-20 | Gaston | North Carolina | 37071 | 3716 | 59 |
430458 | 430458 | 2020-08-13 | Ector | Texas | 48135 | 3716 | 57 |
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);