ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where cases = 3087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 18
- Georgia 12
- Florida 10
- California 8
- Colorado 8
- Louisiana 7
- Michigan 7
- Kentucky 6
- Mississippi 6
- Alabama 5
- Missouri 5
- Ohio 5
- Texas 5
- Wisconsin 5
- Arkansas 4
- Illinois 4
- Minnesota 4
- Wyoming 4
- North Carolina 3
- Puerto Rico 3
- Vermont 3
- Virginia 3
- Indiana 2
- Kansas 2
- New Jersey 2
- South Dakota 2
- Hawaii 1
- Idaho 1
- Montana 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499915 | 2499915 | 2022-05-13 | Franklin | Florida | 12037 | 3087 | 52 |
2496657 | 2496657 | 2022-05-12 | Franklin | Florida | 12037 | 3087 | 52 |
2493399 | 2493399 | 2022-05-11 | Franklin | Florida | 12037 | 3087 | 52 |
2490141 | 2490141 | 2022-05-10 | Franklin | Florida | 12037 | 3087 | 52 |
2486884 | 2486884 | 2022-05-09 | Franklin | Florida | 12037 | 3087 | 52 |
2483626 | 2483626 | 2022-05-08 | Franklin | Florida | 12037 | 3087 | 52 |
2480368 | 2480368 | 2022-05-07 | Franklin | Florida | 12037 | 3087 | 52 |
2477110 | 2477110 | 2022-05-06 | Franklin | Florida | 12037 | 3087 | 52 |
2381293 | 2381293 | 2022-04-06 | Love | Oklahoma | 40085 | 3087 | 38 |
2378038 | 2378038 | 2022-04-05 | Love | Oklahoma | 40085 | 3087 | 38 |
2374784 | 2374784 | 2022-04-04 | Love | Oklahoma | 40085 | 3087 | 38 |
2371532 | 2371532 | 2022-04-03 | Love | Oklahoma | 40085 | 3087 | 38 |
2368279 | 2368279 | 2022-04-02 | Love | Oklahoma | 40085 | 3087 | 38 |
2365026 | 2365026 | 2022-04-01 | Love | Oklahoma | 40085 | 3087 | 38 |
2361773 | 2361773 | 2022-03-31 | Love | Oklahoma | 40085 | 3087 | 38 |
2356533 | 2356533 | 2022-03-30 | Mono | California | 6051 | 3087 | 5 |
2353280 | 2353280 | 2022-03-29 | Mono | California | 6051 | 3087 | 5 |
2350028 | 2350028 | 2022-03-28 | Mono | California | 6051 | 3087 | 5 |
2346775 | 2346775 | 2022-03-27 | Mono | California | 6051 | 3087 | 5 |
2343522 | 2343522 | 2022-03-26 | Mono | California | 6051 | 3087 | 5 |
2340269 | 2340269 | 2022-03-25 | Mono | California | 6051 | 3087 | 5 |
2337016 | 2337016 | 2022-03-24 | Mono | California | 6051 | 3087 | 5 |
2236696 | 2236696 | 2022-02-21 | Blackford | Indiana | 18009 | 3087 | 68 |
2233167 | 2233167 | 2022-02-20 | Dade | Georgia | 13083 | 3087 | 28 |
2229916 | 2229916 | 2022-02-19 | Dade | Georgia | 13083 | 3087 | 28 |
2226665 | 2226665 | 2022-02-18 | Dade | Georgia | 13083 | 3087 | 28 |
2223452 | 2223452 | 2022-02-17 | Jasper | Georgia | 13159 | 3087 | 68 |
2201468 | 2201468 | 2022-02-10 | Arenac | Michigan | 26011 | 3087 | 62 |
2198214 | 2198214 | 2022-02-09 | Arenac | Michigan | 26011 | 3087 | 62 |
2196385 | 2196385 | 2022-02-08 | Comanche | Texas | 48093 | 3087 | 75 |
2192494 | 2192494 | 2022-02-07 | Mountrail | North Dakota | 38061 | 3087 | 33 |
2190124 | 2190124 | 2022-02-06 | Orange | Vermont | 50017 | 3087 | 11 |
2186871 | 2186871 | 2022-02-05 | Orange | Vermont | 50017 | 3087 | 11 |
2183618 | 2183618 | 2022-02-04 | Orange | Vermont | 50017 | 3087 | 11 |
2166532 | 2166532 | 2022-01-30 | Harrison | Ohio | 39067 | 3087 | 65 |
2161460 | 2161460 | 2022-01-29 | Las Animas | Colorado | 8071 | 3087 | 37 |
2154951 | 2154951 | 2022-01-27 | Las Animas | Colorado | 8071 | 3087 | 37 |
2129758 | 2129758 | 2022-01-19 | Washington | Kentucky | 21229 | 3087 | 53 |
2110278 | 2110278 | 2022-01-13 | LaSalle | Louisiana | 22059 | 3087 | 46 |
2107027 | 2107027 | 2022-01-12 | LaSalle | Louisiana | 22059 | 3087 | 46 |
2103776 | 2103776 | 2022-01-11 | LaSalle | Louisiana | 22059 | 3087 | 46 |
2080890 | 2080890 | 2022-01-04 | Casey | Kentucky | 21045 | 3087 | 65 |
2077638 | 2077638 | 2022-01-03 | Casey | Kentucky | 21045 | 3087 | 65 |
2076601 | 2076601 | 2022-01-02 | Lincoln | Wyoming | 56023 | 3087 | 27 |
2073350 | 2073350 | 2022-01-01 | Lincoln | Wyoming | 56023 | 3087 | 27 |
2070099 | 2070099 | 2021-12-31 | Lincoln | Wyoming | 56023 | 3087 | 27 |
2063856 | 2063856 | 2021-12-30 | Alamosa | Colorado | 8003 | 3087 | 56 |
2066848 | 2066848 | 2021-12-30 | Lincoln | Wyoming | 56023 | 3087 | 27 |
1963406 | 1963406 | 2021-11-29 | Kauai | Hawaii | 15007 | 3087 | 13 |
1932469 | 1932469 | 2021-11-19 | Paulding | Ohio | 39125 | 3087 | 47 |
1896964 | 1896964 | 2021-11-08 | Humacao | Puerto Rico | 72069 | 3087 | |
1877540 | 1877540 | 2021-11-02 | Hampton | South Carolina | 45049 | 3087 | 74 |
1869299 | 1869299 | 2021-10-31 | Wayne | Illinois | 17191 | 3087 | 64 |
1866050 | 1866050 | 2021-10-30 | Wayne | Illinois | 17191 | 3087 | 64 |
1862801 | 1862801 | 2021-10-29 | Wayne | Illinois | 17191 | 3087 | 64 |
1826655 | 1826655 | 2021-10-18 | Pitkin | Colorado | 8097 | 3087 | 5 |
1816646 | 1816646 | 2021-10-15 | Hale | Alabama | 1065 | 3087 | 87 |
1807271 | 1807271 | 2021-10-12 | Brantley | Georgia | 13025 | 3087 | 80 |
1774500 | 1774500 | 2021-10-02 | Conway | Arkansas | 5029 | 3087 | 42 |
1768175 | 1768175 | 2021-09-30 | Routt | Colorado | 8107 | 3087 | 22 |
1768279 | 1768279 | 2021-09-30 | Brantley | Georgia | 13025 | 3087 | 75 |
1755002 | 1755002 | 2021-09-26 | Clark | Arkansas | 5019 | 3087 | 51 |
1751805 | 1751805 | 2021-09-25 | Randolph | Arkansas | 5121 | 3087 | 51 |
1742175 | 1742175 | 2021-09-22 | Morgan | Colorado | 8087 | 3087 | 98 |
1741469 | 1741469 | 2021-09-21 | Scurry | Texas | 48415 | 3087 | 73 |
1741817 | 1741817 | 2021-09-21 | Jackson | Wisconsin | 55053 | 3087 | 29 |
1718047 | 1718047 | 2021-09-14 | Beckham | Oklahoma | 40009 | 3087 | 58 |
1714799 | 1714799 | 2021-09-13 | Beckham | Oklahoma | 40009 | 3087 | 58 |
1711553 | 1711553 | 2021-09-12 | Beckham | Oklahoma | 40009 | 3087 | 58 |
1708306 | 1708306 | 2021-09-11 | Beckham | Oklahoma | 40009 | 3087 | 58 |
1705059 | 1705059 | 2021-09-10 | Beckham | Oklahoma | 40009 | 3087 | 58 |
1700129 | 1700129 | 2021-09-09 | Lamar | Georgia | 13171 | 3087 | 70 |
1701809 | 1701809 | 2021-09-09 | Beckham | Oklahoma | 40009 | 3087 | 58 |
1698560 | 1698560 | 2021-09-08 | Beckham | Oklahoma | 40009 | 3087 | 58 |
1682253 | 1682253 | 2021-09-03 | Hardin | Ohio | 39065 | 3087 | 66 |
1676608 | 1676608 | 2021-09-01 | Carroll | Virginia | 51035 | 3087 | 81 |
1671986 | 1671986 | 2021-08-31 | Nodaway | Missouri | 29147 | 3087 | 31 |
1632005 | 1632005 | 2021-08-19 | Cassia | Idaho | 16031 | 3087 | 28 |
1626524 | 1626524 | 2021-08-17 | Randolph | Missouri | 29175 | 3087 | 33 |
1611201 | 1611201 | 2021-08-12 | Lawrence | South Dakota | 46081 | 3087 | 49 |
1603158 | 1603158 | 2021-08-10 | Miami | Kansas | 20121 | 3087 | 43 |
1599909 | 1599909 | 2021-08-09 | Miami | Kansas | 20121 | 3087 | 43 |
1553909 | 1553909 | 2021-07-26 | Decatur | Georgia | 13087 | 3087 | 74 |
1551391 | 1551391 | 2021-07-25 | Sabine | Louisiana | 22085 | 3087 | 64 |
1551655 | 1551655 | 2021-07-25 | Coahoma | Mississippi | 28027 | 3087 | 85 |
1548144 | 1548144 | 2021-07-24 | Sabine | Louisiana | 22085 | 3087 | 64 |
1548408 | 1548408 | 2021-07-24 | Coahoma | Mississippi | 28027 | 3087 | 85 |
1544897 | 1544897 | 2021-07-23 | Sabine | Louisiana | 22085 | 3087 | 64 |
1545161 | 1545161 | 2021-07-23 | Coahoma | Mississippi | 28027 | 3087 | 85 |
1545336 | 1545336 | 2021-07-23 | Stone | Missouri | 29209 | 3087 | 54 |
1537357 | 1537357 | 2021-07-21 | Carroll | Arkansas | 5015 | 3087 | 47 |
1537499 | 1537499 | 2021-07-21 | Delta | Colorado | 8029 | 3087 | 70 |
1537722 | 1537722 | 2021-07-21 | Lumpkin | Georgia | 13187 | 3087 | 82 |
1463982 | 1463982 | 2021-06-28 | Adams | Mississippi | 28001 | 3087 | 86 |
1334285 | 1334285 | 2021-05-19 | Lafayette | Missouri | 29107 | 3087 | 57 |
1318155 | 1318155 | 2021-05-14 | Ravalli | Montana | 30081 | 3087 | 44 |
1308033 | 1308033 | 2021-05-11 | Houghton | Michigan | 26061 | 3087 | 40 |
1309286 | 1309286 | 2021-05-11 | Yankton | South Dakota | 46135 | 3087 | 31 |
1304694 | 1304694 | 2021-05-10 | Vernon | Louisiana | 22115 | 3087 | 102 |
1291536 | 1291536 | 2021-05-06 | Bell | Kentucky | 21013 | 3087 | 54 |
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);