ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where cases = 3227 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 17
- Ohio 13
- Texas 13
- Missouri 9
- Tennessee 8
- Alabama 6
- North Carolina 6
- Puerto Rico 6
- Illinois 5
- Indiana 5
- Kansas 5
- Louisiana 5
- Michigan 5
- Minnesota 5
- Arkansas 4
- Maryland 4
- Massachusetts 4
- Mississippi 4
- South Dakota 4
- California 3
- Colorado 3
- Oklahoma 3
- Pennsylvania 3
- Wisconsin 3
- Florida 2
- Idaho 2
- Kentucky 2
- Nevada 2
- New York 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2436855 | 2436855 | 2022-04-23 | Villalba | Puerto Rico | 72149 | 3227 | |
2421915 | 2421915 | 2022-04-19 | Oglethorpe | Georgia | 13221 | 3227 | 56 |
2418659 | 2418659 | 2022-04-18 | Oglethorpe | Georgia | 13221 | 3227 | 56 |
2415403 | 2415403 | 2022-04-17 | Oglethorpe | Georgia | 13221 | 3227 | 56 |
2412147 | 2412147 | 2022-04-16 | Oglethorpe | Georgia | 13221 | 3227 | 56 |
2408891 | 2408891 | 2022-04-15 | Oglethorpe | Georgia | 13221 | 3227 | 56 |
2403982 | 2403982 | 2022-04-13 | Harrison | Ohio | 39067 | 3227 | 74 |
2400727 | 2400727 | 2022-04-12 | Harrison | Ohio | 39067 | 3227 | 74 |
2397472 | 2397472 | 2022-04-11 | Harrison | Ohio | 39067 | 3227 | 74 |
2394217 | 2394217 | 2022-04-10 | Harrison | Ohio | 39067 | 3227 | 74 |
2390961 | 2390961 | 2022-04-09 | Harrison | Ohio | 39067 | 3227 | 74 |
2387705 | 2387705 | 2022-04-08 | Harrison | Ohio | 39067 | 3227 | 74 |
2384450 | 2384450 | 2022-04-07 | Harrison | Ohio | 39067 | 3227 | 74 |
2346994 | 2346994 | 2022-03-27 | Dade | Georgia | 13083 | 3227 | 28 |
2343741 | 2343741 | 2022-03-26 | Dade | Georgia | 13083 | 3227 | 28 |
2340488 | 2340488 | 2022-03-25 | Dade | Georgia | 13083 | 3227 | 28 |
2307019 | 2307019 | 2022-03-14 | Jackson | Texas | 48239 | 3227 | 59 |
2303768 | 2303768 | 2022-03-13 | Jackson | Texas | 48239 | 3227 | 59 |
2300516 | 2300516 | 2022-03-12 | Jackson | Texas | 48239 | 3227 | 59 |
2297264 | 2297264 | 2022-03-11 | Jackson | Texas | 48239 | 3227 | 59 |
2294012 | 2294012 | 2022-03-10 | Jackson | Texas | 48239 | 3227 | 59 |
2279219 | 2279219 | 2022-03-06 | Nemaha | Kansas | 20131 | 3227 | 60 |
2275966 | 2275966 | 2022-03-05 | Nemaha | Kansas | 20131 | 3227 | 60 |
2272713 | 2272713 | 2022-03-04 | Nemaha | Kansas | 20131 | 3227 | 60 |
2260274 | 2260274 | 2022-02-28 | Dent | Missouri | 29065 | 3227 | 73 |
2256763 | 2256763 | 2022-02-27 | Gogebic | Michigan | 26053 | 3227 | 67 |
2253512 | 2253512 | 2022-02-26 | Gogebic | Michigan | 26053 | 3227 | 67 |
2250261 | 2250261 | 2022-02-25 | Gogebic | Michigan | 26053 | 3227 | 67 |
2251023 | 2251023 | 2022-02-25 | McKenzie | North Dakota | 38053 | 3227 | 25 |
2251377 | 2251377 | 2022-02-25 | Naguabo | Puerto Rico | 72103 | 3227 | |
2247772 | 2247772 | 2022-02-24 | McKenzie | North Dakota | 38053 | 3227 | 25 |
2244727 | 2244727 | 2022-02-23 | Curry | Oregon | 41015 | 3227 | 44 |
2202212 | 2202212 | 2022-02-10 | Swain | North Carolina | 37173 | 3227 | 34 |
2176440 | 2176440 | 2022-02-02 | Hood River | Oregon | 41027 | 3227 | 41 |
2168725 | 2168725 | 2022-01-31 | Fleming | Kentucky | 21069 | 3227 | 44 |
2169581 | 2169581 | 2022-01-31 | Schuyler | New York | 36097 | 3227 | 23 |
2165672 | 2165672 | 2022-01-30 | Nantucket | Massachusetts | 25019 | 3227 | 0 |
2162417 | 2162417 | 2022-01-29 | Nantucket | Massachusetts | 25019 | 3227 | 0 |
2159162 | 2159162 | 2022-01-28 | Nantucket | Massachusetts | 25019 | 3227 | 0 |
2149397 | 2149397 | 2022-01-25 | Dukes | Massachusetts | 25007 | 3227 | 0 |
2140796 | 2140796 | 2022-01-22 | Quebradillas | Puerto Rico | 72115 | 3227 | |
2098474 | 2098474 | 2022-01-09 | Catano | Puerto Rico | 72033 | 3227 | |
2089135 | 2089135 | 2022-01-06 | Lamb | Texas | 48279 | 3227 | 99 |
2089204 | 2089204 | 2022-01-06 | Shelby | Texas | 48419 | 3227 | 114 |
2062802 | 2062802 | 2021-12-29 | Hampton | South Carolina | 45049 | 3227 | 75 |
2063460 | 2063460 | 2021-12-29 | Barbour | West Virginia | 54001 | 3227 | 56 |
2054128 | 2054128 | 2021-12-27 | Elbert | Colorado | 8039 | 3227 | 30 |
2019310 | 2019310 | 2021-12-16 | Waldo | Maine | 23027 | 3227 | 36 |
2013368 | 2013368 | 2021-12-14 | Washington | Nebraska | 31177 | 3227 | 30 |
2013380 | 2013380 | 2021-12-14 | Humboldt | Nevada | 32013 | 3227 | 39 |
1993212 | 1993212 | 2021-12-08 | Spencer | Kentucky | 21215 | 3227 | 40 |
1989416 | 1989416 | 2021-12-07 | Blaine | Idaho | 16013 | 3227 | 27 |
1989626 | 1989626 | 2021-12-07 | Rush | Indiana | 18139 | 3227 | 33 |
1972893 | 1972893 | 2021-12-02 | Otero | Colorado | 8089 | 3227 | 103 |
1920622 | 1920622 | 2021-11-16 | Fayette | Alabama | 1057 | 3227 | 85 |
1920758 | 1920758 | 2021-11-16 | Phillips | Arkansas | 5107 | 3227 | 77 |
1905623 | 1905623 | 2021-11-11 | Iosco | Michigan | 26069 | 3227 | 98 |
1902374 | 1902374 | 2021-11-10 | Iosco | Michigan | 26069 | 3227 | 98 |
1896518 | 1896518 | 2021-11-08 | Caswell | North Carolina | 37033 | 3227 | 37 |
1869108 | 1869108 | 2021-10-31 | Putnam | Georgia | 13237 | 3227 | 81 |
1865859 | 1865859 | 2021-10-30 | Putnam | Georgia | 13237 | 3227 | 81 |
1862610 | 1862610 | 2021-10-29 | Putnam | Georgia | 13237 | 3227 | 81 |
1859361 | 1859361 | 2021-10-28 | Putnam | Georgia | 13237 | 3227 | 81 |
1836550 | 1836550 | 2021-10-21 | Elbert | Georgia | 13105 | 3227 | 85 |
1810739 | 1810739 | 2021-10-13 | Douglas | Illinois | 17041 | 3227 | 43 |
1808090 | 1808090 | 2021-10-12 | Somerset | Maryland | 24039 | 3227 | 48 |
1793876 | 1793876 | 2021-10-08 | Butler | Alabama | 1013 | 3227 | 93 |
1734670 | 1734670 | 2021-09-19 | Bledsoe | Tennessee | 47007 | 3227 | 13 |
1731420 | 1731420 | 2021-09-18 | Bledsoe | Tennessee | 47007 | 3227 | 13 |
1728170 | 1728170 | 2021-09-17 | Bledsoe | Tennessee | 47007 | 3227 | 13 |
1667056 | 1667056 | 2021-08-29 | Preston | West Virginia | 54077 | 3227 | 48 |
1658644 | 1658644 | 2021-08-27 | Queen Anne's | Maryland | 24035 | 3227 | 57 |
1654436 | 1654436 | 2021-08-26 | Delta | Colorado | 8029 | 3227 | 76 |
1648586 | 1648586 | 2021-08-24 | Cherokee | Kansas | 20021 | 3227 | 66 |
1645338 | 1645338 | 2021-08-23 | Cherokee | Kansas | 20021 | 3227 | 66 |
1634365 | 1634365 | 2021-08-19 | Amherst | Virginia | 51009 | 3227 | 41 |
1574523 | 1574523 | 2021-08-01 | McDonald | Missouri | 29119 | 3227 | 40 |
1571275 | 1571275 | 2021-07-31 | McDonald | Missouri | 29119 | 3227 | 40 |
1568027 | 1568027 | 2021-07-30 | McDonald | Missouri | 29119 | 3227 | 40 |
1516007 | 1516007 | 2021-07-14 | Barry | Missouri | 29009 | 3227 | 48 |
1469684 | 1469684 | 2021-06-30 | Fayette | Illinois | 17051 | 3227 | 58 |
1466439 | 1466439 | 2021-06-29 | Fayette | Illinois | 17051 | 3227 | 58 |
1468351 | 1468351 | 2021-06-29 | Claiborne | Tennessee | 47025 | 3227 | 74 |
1463194 | 1463194 | 2021-06-28 | Fayette | Illinois | 17051 | 3227 | 58 |
1465106 | 1465106 | 2021-06-28 | Claiborne | Tennessee | 47025 | 3227 | 74 |
1427017 | 1427017 | 2021-06-17 | Lincoln | Arkansas | 5079 | 3227 | 48 |
1428474 | 1428474 | 2021-06-17 | Warren | Missouri | 29219 | 3227 | 33 |
1425229 | 1425229 | 2021-06-16 | Warren | Missouri | 29219 | 3227 | 33 |
1405563 | 1405563 | 2021-06-10 | Alcorn | Mississippi | 28003 | 3227 | 72 |
1395557 | 1395557 | 2021-06-07 | Jefferson Davis | Louisiana | 22053 | 3227 | 97 |
1393253 | 1393253 | 2021-06-06 | Guernsey | Ohio | 39059 | 3227 | 53 |
1390008 | 1390008 | 2021-06-05 | Guernsey | Ohio | 39059 | 3227 | 53 |
1384669 | 1384669 | 2021-06-03 | Sheridan | Wyoming | 56033 | 3227 | 31 |
1376060 | 1376060 | 2021-06-01 | Allen | Louisiana | 22003 | 3227 | 92 |
1359503 | 1359503 | 2021-05-27 | White | Indiana | 18181 | 3227 | 54 |
1336327 | 1336327 | 2021-05-20 | Hardee | Florida | 12049 | 3227 | 45 |
1305992 | 1305992 | 2021-05-10 | Davison | South Dakota | 46035 | 3227 | 67 |
1301646 | 1301646 | 2021-05-09 | Nicollet | Minnesota | 27103 | 3227 | 43 |
1302746 | 1302746 | 2021-05-09 | Davison | South Dakota | 46035 | 3227 | 67 |
1299499 | 1299499 | 2021-05-08 | Davison | South Dakota | 46035 | 3227 | 67 |
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);