ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 2770 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 12
- Georgia 11
- Tennessee 11
- Illinois 10
- Missouri 9
- Texas 9
- Virginia 8
- Iowa 7
- Ohio 7
- Kansas 6
- Kentucky 6
- Louisiana 6
- New York 6
- North Carolina 6
- South Dakota 5
- Indiana 4
- Minnesota 4
- Wisconsin 4
- Alabama 3
- Idaho 3
- Mississippi 3
- Montana 3
- Puerto Rico 3
- Colorado 2
- Nebraska 2
- North Dakota 2
- Oklahoma 2
- Pennsylvania 2
- South Carolina 2
- Washington 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498712 | 2498712 | 2022-05-12 | Penuelas | Puerto Rico | 72111 | 2770 | |
2425332 | 2425332 | 2022-04-20 | Marshall | Illinois | 17123 | 2770 | 33 |
2372707 | 2372707 | 2022-04-04 | Chicot | Arkansas | 5017 | 2770 | 60 |
2369454 | 2369454 | 2022-04-03 | Chicot | Arkansas | 5017 | 2770 | 60 |
2366201 | 2366201 | 2022-04-02 | Chicot | Arkansas | 5017 | 2770 | 60 |
2362948 | 2362948 | 2022-04-01 | Chicot | Arkansas | 5017 | 2770 | 60 |
2359694 | 2359694 | 2022-03-31 | Chicot | Arkansas | 5017 | 2770 | 60 |
2356440 | 2356440 | 2022-03-30 | Chicot | Arkansas | 5017 | 2770 | 60 |
2353187 | 2353187 | 2022-03-29 | Chicot | Arkansas | 5017 | 2770 | 60 |
2349935 | 2349935 | 2022-03-28 | Chicot | Arkansas | 5017 | 2770 | 60 |
2346682 | 2346682 | 2022-03-27 | Chicot | Arkansas | 5017 | 2770 | 60 |
2343429 | 2343429 | 2022-03-26 | Chicot | Arkansas | 5017 | 2770 | 60 |
2334031 | 2334031 | 2022-03-23 | Long | Georgia | 13183 | 2770 | 34 |
2284203 | 2284203 | 2022-03-07 | Eastland | Texas | 48133 | 2770 | 110 |
2179205 | 2179205 | 2022-02-03 | Unknown | Nebraska | 2770 | 361 | |
2153827 | 2153827 | 2022-01-26 | Villalba | Puerto Rico | 72149 | 2770 | |
2134902 | 2134902 | 2022-01-20 | Martinsville city | Virginia | 51690 | 2770 | 100 |
2121817 | 2121817 | 2022-01-16 | Alleghany | Virginia | 51005 | 2770 | 90 |
2118565 | 2118565 | 2022-01-15 | Alleghany | Virginia | 51005 | 2770 | 90 |
2115313 | 2115313 | 2022-01-14 | Alleghany | Virginia | 51005 | 2770 | 90 |
2112335 | 2112335 | 2022-01-13 | Price | Wisconsin | 55099 | 2770 | 23 |
2099439 | 2099439 | 2022-01-10 | Washington | Alabama | 1129 | 2770 | 52 |
2080982 | 2080982 | 2022-01-04 | Washington | Kentucky | 21229 | 2770 | 52 |
2079718 | 2079718 | 2022-01-03 | Braxton | West Virginia | 54007 | 2770 | 31 |
2062710 | 2062710 | 2021-12-29 | Cayey | Puerto Rico | 72035 | 2770 | |
2058591 | 2058591 | 2021-12-28 | Smith | Mississippi | 28129 | 2770 | 52 |
2055260 | 2055260 | 2021-12-27 | Sibley | Minnesota | 27143 | 2770 | 20 |
2053387 | 2053387 | 2021-12-26 | Llano | Texas | 48299 | 2770 | 84 |
2050137 | 2050137 | 2021-12-25 | Llano | Texas | 48299 | 2770 | 84 |
2046887 | 2046887 | 2021-12-24 | Llano | Texas | 48299 | 2770 | 84 |
2043637 | 2043637 | 2021-12-23 | Llano | Texas | 48299 | 2770 | 84 |
2015530 | 2015530 | 2021-12-15 | Moultrie | Illinois | 17139 | 2770 | 44 |
2012507 | 2012507 | 2021-12-14 | Atchison | Kansas | 20005 | 2770 | 26 |
2009256 | 2009256 | 2021-12-13 | Atchison | Kansas | 20005 | 2770 | 26 |
1998521 | 1998521 | 2021-12-09 | Crawford | Wisconsin | 55023 | 2770 | 23 |
1989721 | 1989721 | 2021-12-07 | Page | Iowa | 19145 | 2770 | 33 |
1986058 | 1986058 | 2021-12-06 | Greene | Georgia | 13133 | 2770 | 73 |
1986471 | 1986471 | 2021-12-06 | Page | Iowa | 19145 | 2770 | 33 |
1983221 | 1983221 | 2021-12-05 | Page | Iowa | 19145 | 2770 | 33 |
1979971 | 1979971 | 2021-12-04 | Page | Iowa | 19145 | 2770 | 33 |
1976721 | 1976721 | 2021-12-03 | Page | Iowa | 19145 | 2770 | 33 |
1973472 | 1973472 | 2021-12-02 | Page | Iowa | 19145 | 2770 | 33 |
1970222 | 1970222 | 2021-12-01 | Page | Iowa | 19145 | 2770 | 33 |
1938888 | 1938888 | 2021-11-21 | Richland | North Dakota | 38077 | 2770 | 21 |
1935638 | 1935638 | 2021-11-20 | Richland | North Dakota | 38077 | 2770 | 21 |
1882612 | 1882612 | 2021-11-04 | Breckinridge | Kentucky | 21027 | 2770 | 36 |
1876623 | 1876623 | 2021-11-02 | Cooper | Missouri | 29053 | 2770 | 34 |
1869747 | 1869747 | 2021-10-31 | Jackson | Louisiana | 22049 | 2770 | 64 |
1866498 | 1866498 | 2021-10-30 | Jackson | Louisiana | 22049 | 2770 | 64 |
1863249 | 1863249 | 2021-10-29 | Jackson | Louisiana | 22049 | 2770 | 64 |
1854248 | 1854248 | 2021-10-26 | Seneca | New York | 36099 | 2770 | 63 |
1851638 | 1851638 | 2021-10-25 | Benton | Tennessee | 47005 | 2770 | 52 |
1848388 | 1848388 | 2021-10-24 | Benton | Tennessee | 47005 | 2770 | 52 |
1845138 | 1845138 | 2021-10-23 | Benton | Tennessee | 47005 | 2770 | 52 |
1841888 | 1841888 | 2021-10-22 | Benton | Tennessee | 47005 | 2770 | 52 |
1818912 | 1818912 | 2021-10-15 | Juniata | Pennsylvania | 42067 | 2770 | 114 |
1807610 | 1807610 | 2021-10-12 | Jay | Indiana | 18075 | 2770 | 49 |
1779697 | 1779697 | 2021-10-03 | Carroll | Ohio | 39019 | 2770 | 54 |
1756522 | 1756522 | 2021-09-26 | Lincoln | Montana | 30053 | 2770 | 44 |
1753274 | 1753274 | 2021-09-25 | Lincoln | Montana | 30053 | 2770 | 44 |
1750026 | 1750026 | 2021-09-24 | Lincoln | Montana | 30053 | 2770 | 44 |
1717470 | 1717470 | 2021-09-14 | Perry | Missouri | 29157 | 2770 | 32 |
1715704 | 1715704 | 2021-09-13 | Adams | Washington | 53001 | 2770 | 25 |
1696439 | 1696439 | 2021-09-08 | Henry | Alabama | 1067 | 2770 | 48 |
1691515 | 1691515 | 2021-09-06 | Texas | Missouri | 29215 | 2770 | 34 |
1664611 | 1664611 | 2021-08-29 | Union | Illinois | 17181 | 2770 | 46 |
1666472 | 1666472 | 2021-08-29 | Fentress | Tennessee | 47049 | 2770 | 50 |
1661363 | 1661363 | 2021-08-28 | Union | Illinois | 17181 | 2770 | 46 |
1663224 | 1663224 | 2021-08-28 | Fentress | Tennessee | 47049 | 2770 | 50 |
1658115 | 1658115 | 2021-08-27 | Union | Illinois | 17181 | 2770 | 46 |
1659976 | 1659976 | 2021-08-27 | Fentress | Tennessee | 47049 | 2770 | 50 |
1656719 | 1656719 | 2021-08-26 | Crockett | Tennessee | 47033 | 2770 | 54 |
1626620 | 1626620 | 2021-08-17 | Cass | Nebraska | 31025 | 2770 | 17 |
1624108 | 1624108 | 2021-08-16 | Abbeville | South Carolina | 45001 | 2770 | 42 |
1618932 | 1618932 | 2021-08-15 | McDuffie | Georgia | 13189 | 2770 | 52 |
1615684 | 1615684 | 2021-08-14 | McDuffie | Georgia | 13189 | 2770 | 52 |
1612435 | 1612435 | 2021-08-13 | McDuffie | Georgia | 13189 | 2770 | 52 |
1601030 | 1601030 | 2021-08-09 | Coshocton | Ohio | 39031 | 2770 | 61 |
1596288 | 1596288 | 2021-08-08 | Jerome | Idaho | 16053 | 2770 | 25 |
1596746 | 1596746 | 2021-08-08 | Grant | Kentucky | 21081 | 2770 | 25 |
1593039 | 1593039 | 2021-08-07 | Jerome | Idaho | 16053 | 2770 | 25 |
1593497 | 1593497 | 2021-08-07 | Grant | Kentucky | 21081 | 2770 | 25 |
1589790 | 1589790 | 2021-08-06 | Jerome | Idaho | 16053 | 2770 | 25 |
1590248 | 1590248 | 2021-08-06 | Grant | Kentucky | 21081 | 2770 | 25 |
1588515 | 1588515 | 2021-08-05 | Grainger | Tennessee | 47057 | 2770 | 51 |
1579976 | 1579976 | 2021-08-03 | Sumter | Georgia | 13261 | 2770 | 106 |
1576923 | 1576923 | 2021-08-02 | Clay | Indiana | 18021 | 2770 | 49 |
1566163 | 1566163 | 2021-07-29 | Caroline | Virginia | 51033 | 2770 | 40 |
1540978 | 1540978 | 2021-07-22 | Monroe | Georgia | 13207 | 2770 | 105 |
1512029 | 1512029 | 2021-07-13 | Posey | Indiana | 18129 | 2770 | 35 |
1490628 | 1490628 | 2021-07-06 | Hardin | Ohio | 39065 | 2770 | 65 |
1487381 | 1487381 | 2021-07-05 | Hardin | Ohio | 39065 | 2770 | 65 |
1484134 | 1484134 | 2021-07-04 | Hardin | Ohio | 39065 | 2770 | 65 |
1480888 | 1480888 | 2021-07-03 | Hardin | Ohio | 39065 | 2770 | 65 |
1462019 | 1462019 | 2021-06-27 | Fayette | Texas | 48149 | 2770 | 67 |
1458774 | 1458774 | 2021-06-26 | Fayette | Texas | 48149 | 2770 | 67 |
1455913 | 1455913 | 2021-06-25 | Okanogan | Washington | 53047 | 2770 | 43 |
1379792 | 1379792 | 2021-06-02 | Washington | Missouri | 29221 | 2770 | 52 |
1376547 | 1376547 | 2021-06-01 | Washington | Missouri | 29221 | 2770 | 52 |
1362216 | 1362216 | 2021-05-28 | Delta | Colorado | 8029 | 2770 | 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);