ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where cases = 3019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 10
- Indiana 9
- Florida 8
- Mississippi 8
- Colorado 7
- Georgia 6
- Idaho 6
- Pennsylvania 5
- Alabama 4
- Arkansas 4
- California 4
- Illinois 4
- Maryland 4
- Minnesota 4
- Nevada 4
- Ohio 4
- West Virginia 4
- Missouri 3
- Montana 3
- Tennessee 3
- Washington 3
- Kentucky 2
- Louisiana 2
- Michigan 2
- New Mexico 2
- Oregon 2
- Puerto Rico 2
- South Carolina 2
- Virginia 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418446 | 2418446 | 2022-04-18 | Moffat | Colorado | 8081 | 3019 | 51 |
2415190 | 2415190 | 2022-04-17 | Moffat | Colorado | 8081 | 3019 | 51 |
2411934 | 2411934 | 2022-04-16 | Moffat | Colorado | 8081 | 3019 | 51 |
2408678 | 2408678 | 2022-04-15 | Moffat | Colorado | 8081 | 3019 | 51 |
2405422 | 2405422 | 2022-04-14 | Moffat | Colorado | 8081 | 3019 | 51 |
2328432 | 2328432 | 2022-03-21 | Pope | Minnesota | 27121 | 3019 | 17 |
2263618 | 2263618 | 2022-03-01 | Custer | Montana | 30017 | 3019 | 46 |
2250209 | 2250209 | 2022-02-25 | Kent | Maryland | 24029 | 3019 | 64 |
2221577 | 2221577 | 2022-02-16 | Torrance | New Mexico | 35057 | 3019 | 49 |
2222535 | 2222535 | 2022-02-16 | Nolan | Texas | 48353 | 3019 | 92 |
2187416 | 2187416 | 2022-02-06 | Mono | California | 6051 | 3019 | 5 |
2184163 | 2184163 | 2022-02-05 | Mono | California | 6051 | 3019 | 5 |
2180911 | 2180911 | 2022-02-04 | Mono | California | 6051 | 3019 | 5 |
2148436 | 2148436 | 2022-01-25 | Gunnison | Colorado | 8051 | 3019 | 13 |
2062746 | 2062746 | 2021-12-29 | Naranjito | Puerto Rico | 72105 | 3019 | |
2041192 | 2041192 | 2021-12-23 | Calhoun | Florida | 12013 | 3019 | 85 |
2037942 | 2037942 | 2021-12-22 | Calhoun | Florida | 12013 | 3019 | 85 |
2034692 | 2034692 | 2021-12-21 | Calhoun | Florida | 12013 | 3019 | 85 |
2031442 | 2031442 | 2021-12-20 | Calhoun | Florida | 12013 | 3019 | 85 |
2028191 | 2028191 | 2021-12-19 | Calhoun | Florida | 12013 | 3019 | 85 |
2024940 | 2024940 | 2021-12-18 | Calhoun | Florida | 12013 | 3019 | 85 |
2021689 | 2021689 | 2021-12-17 | Calhoun | Florida | 12013 | 3019 | 85 |
1995521 | 1995521 | 2021-12-09 | Polk | Arkansas | 5113 | 3019 | 112 |
1986314 | 1986314 | 2021-12-06 | Carroll | Indiana | 18015 | 3019 | 42 |
1987029 | 1987029 | 2021-12-06 | Clarke | Mississippi | 28023 | 3019 | 95 |
1964690 | 1964690 | 2021-11-29 | San Miguel | New Mexico | 35047 | 3019 | 29 |
1942860 | 1942860 | 2021-11-22 | Lamb | Texas | 48279 | 3019 | 91 |
1939610 | 1939610 | 2021-11-21 | Lamb | Texas | 48279 | 3019 | 91 |
1936360 | 1936360 | 2021-11-20 | Lamb | Texas | 48279 | 3019 | 91 |
1933110 | 1933110 | 2021-11-19 | Lamb | Texas | 48279 | 3019 | 91 |
1920723 | 1920723 | 2021-11-16 | Cross | Arkansas | 5037 | 3019 | 65 |
1906644 | 1906644 | 2021-11-11 | Juniata | Pennsylvania | 42067 | 3019 | 120 |
1897515 | 1897515 | 2021-11-08 | Orleans | Vermont | 50019 | 3019 | 19 |
1886453 | 1886453 | 2021-11-05 | Texas | Missouri | 29215 | 3019 | 43 |
1884482 | 1884482 | 2021-11-04 | Duchesne | Utah | 49013 | 3019 | 16 |
1842460 | 1842460 | 2021-10-22 | Brooke | West Virginia | 54009 | 3019 | 71 |
1801577 | 1801577 | 2021-10-10 | Caroline | Maryland | 24011 | 3019 | 41 |
1791386 | 1791386 | 2021-10-07 | Owen | Indiana | 18119 | 3019 | 69 |
1788152 | 1788152 | 2021-10-06 | Starke | Indiana | 18149 | 3019 | 69 |
1785552 | 1785552 | 2021-10-05 | Clay | Mississippi | 28025 | 3019 | 74 |
1785765 | 1785765 | 2021-10-05 | Lincoln | Montana | 30053 | 3019 | 46 |
1767978 | 1767978 | 2021-09-30 | La Paz | Arizona | 4012 | 3019 | 89 |
1757245 | 1757245 | 2021-09-26 | Gurabo | Puerto Rico | 72063 | 3019 | |
1745787 | 1745787 | 2021-09-23 | Lawrence | Illinois | 17101 | 3019 | 40 |
1740132 | 1740132 | 2021-09-21 | Winston | Mississippi | 28159 | 3019 | 91 |
1735830 | 1735830 | 2021-09-20 | Elbert | Georgia | 13105 | 3019 | 80 |
1718524 | 1718524 | 2021-09-14 | Austin | Texas | 48015 | 3019 | 45 |
1695027 | 1695027 | 2021-09-07 | Lewis | New York | 36049 | 3019 | 36 |
1676078 | 1676078 | 2021-09-01 | Abbeville | South Carolina | 45001 | 3019 | 42 |
1669454 | 1669454 | 2021-08-30 | Elk | Pennsylvania | 42047 | 3019 | 42 |
1645473 | 1645473 | 2021-08-23 | Grant | Kentucky | 21081 | 3019 | 25 |
1646665 | 1646665 | 2021-08-23 | Coos | Oregon | 41011 | 3019 | 46 |
1647560 | 1647560 | 2021-08-23 | Mingo | West Virginia | 54059 | 3019 | 46 |
1631840 | 1631840 | 2021-08-19 | Burke | Georgia | 13033 | 3019 | 67 |
1625388 | 1625388 | 2021-08-17 | Franklin | Georgia | 13119 | 3019 | 59 |
1586682 | 1586682 | 2021-08-05 | Fayette | Indiana | 18041 | 3019 | 66 |
1582774 | 1582774 | 2021-08-04 | Winston | Alabama | 1133 | 3019 | 73 |
1556556 | 1556556 | 2021-07-26 | Mason | Washington | 53045 | 3019 | 38 |
1543418 | 1543418 | 2021-07-22 | Amherst | Virginia | 51009 | 3019 | 40 |
1535211 | 1535211 | 2021-07-20 | Queen Anne's | Maryland | 24035 | 3019 | 52 |
1487054 | 1487054 | 2021-07-05 | Douglas | Nevada | 32005 | 3019 | 37 |
1483808 | 1483808 | 2021-07-04 | Douglas | Nevada | 32005 | 3019 | 37 |
1480562 | 1480562 | 2021-07-03 | Douglas | Nevada | 32005 | 3019 | 37 |
1477315 | 1477315 | 2021-07-02 | Douglas | Nevada | 32005 | 3019 | 37 |
1473781 | 1473781 | 2021-07-01 | Simpson | Mississippi | 28127 | 3019 | 89 |
1401484 | 1401484 | 2021-06-09 | Jefferson | Idaho | 16051 | 3019 | 32 |
1398239 | 1398239 | 2021-06-08 | Jefferson | Idaho | 16051 | 3019 | 32 |
1398374 | 1398374 | 2021-06-08 | Daviess | Indiana | 18027 | 3019 | 101 |
1394992 | 1394992 | 2021-06-07 | Jefferson | Idaho | 16051 | 3019 | 32 |
1368899 | 1368899 | 2021-05-30 | Gilmer | Georgia | 13123 | 3019 | 87 |
1365653 | 1365653 | 2021-05-29 | Gilmer | Georgia | 13123 | 3019 | 87 |
1354538 | 1354538 | 2021-05-25 | Tioga | Pennsylvania | 42117 | 3019 | 108 |
1351838 | 1351838 | 2021-05-24 | Willacy | Texas | 48489 | 3019 | 88 |
1348592 | 1348592 | 2021-05-23 | Willacy | Texas | 48489 | 3019 | 88 |
1307087 | 1307087 | 2021-05-11 | Bradford | Florida | 12007 | 3019 | 56 |
1288578 | 1288578 | 2021-05-05 | Mecosta | Michigan | 26107 | 3019 | 30 |
1274169 | 1274169 | 2021-04-30 | Logan | West Virginia | 54045 | 3019 | 92 |
1259613 | 1259613 | 2021-04-26 | Lafayette | Missouri | 29107 | 3019 | 56 |
1257093 | 1257093 | 2021-04-25 | Clarion | Pennsylvania | 42031 | 3019 | 90 |
1239995 | 1239995 | 2021-04-20 | Alcorn | Mississippi | 28003 | 3019 | 66 |
1232670 | 1232670 | 2021-04-18 | Latah | Idaho | 16057 | 3019 | 10 |
1229421 | 1229421 | 2021-04-17 | Latah | Idaho | 16057 | 3019 | 10 |
1226173 | 1226173 | 2021-04-16 | Latah | Idaho | 16057 | 3019 | 10 |
1191960 | 1191960 | 2021-04-05 | Jackson | Ohio | 39079 | 3019 | 51 |
1174750 | 1174750 | 2021-03-31 | Beauregard | Louisiana | 22011 | 3019 | 72 |
1176358 | 1176358 | 2021-03-31 | Hopkins | Texas | 48223 | 3019 | 107 |
1173111 | 1173111 | 2021-03-30 | Hopkins | Texas | 48223 | 3019 | 107 |
1151684 | 1151684 | 2021-03-24 | White | Indiana | 18181 | 3019 | 55 |
1152241 | 1152241 | 2021-03-24 | Freeborn | Minnesota | 27047 | 3019 | 26 |
1148437 | 1148437 | 2021-03-23 | White | Indiana | 18181 | 3019 | 55 |
1146467 | 1146467 | 2021-03-22 | Champaign | Ohio | 39021 | 3019 | 51 |
1137134 | 1137134 | 2021-03-19 | Davison | South Dakota | 46035 | 3019 | 66 |
1132887 | 1132887 | 2021-03-18 | Scott | Mississippi | 28123 | 3019 | 71 |
1090677 | 1090677 | 2021-03-05 | Pike | Mississippi | 28113 | 3019 | 96 |
1070036 | 1070036 | 2021-02-27 | Summit | Colorado | 8117 | 3019 | 7 |
1001515 | 1001515 | 2021-02-05 | Lincoln | Wisconsin | 55069 | 3019 | 73 |
997309 | 997309 | 2021-02-04 | Woodward | Oklahoma | 40153 | 3019 | 14 |
984032 | 984032 | 2021-01-31 | Davie | North Carolina | 37059 | 3019 | 20 |
973130 | 973130 | 2021-01-28 | Putnam | Indiana | 18133 | 3019 | 52 |
973588 | 973588 | 2021-01-28 | Worcester | Maryland | 24047 | 3019 | 78 |
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);