ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
163 rows where cases = 3194 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 13
- Arkansas 11
- North Carolina 11
- Kansas 9
- Indiana 8
- Missouri 8
- Oregon 8
- Tennessee 8
- Texas 8
- Kentucky 6
- Pennsylvania 6
- Illinois 5
- Louisiana 4
- Mississippi 4
- Puerto Rico 4
- South Carolina 4
- Wisconsin 4
- Alabama 3
- Florida 3
- Michigan 3
- Minnesota 3
- Ohio 3
- Arizona 2
- Colorado 2
- Idaho 2
- Maryland 2
- New Mexico 2
- New York 2
- North Dakota 2
- Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2400949 | 2400949 | 2022-04-12 | Potter | Pennsylvania | 42105 | 3194 | 92 |
2308023 | 2308023 | 2022-03-15 | Oglethorpe | Georgia | 13221 | 3194 | 51 |
2288512 | 2288512 | 2022-03-09 | Oglethorpe | Georgia | 13221 | 3194 | 50 |
2285261 | 2285261 | 2022-03-08 | Oglethorpe | Georgia | 13221 | 3194 | 50 |
2282009 | 2282009 | 2022-03-07 | Oglethorpe | Georgia | 13221 | 3194 | 50 |
2278756 | 2278756 | 2022-03-06 | Oglethorpe | Georgia | 13221 | 3194 | 50 |
2279832 | 2279832 | 2022-03-06 | Osage | Missouri | 29151 | 3194 | 40 |
2280489 | 2280489 | 2022-03-06 | Baker | Oregon | 41001 | 3194 | 46 |
2275503 | 2275503 | 2022-03-05 | Oglethorpe | Georgia | 13221 | 3194 | 50 |
2276579 | 2276579 | 2022-03-05 | Osage | Missouri | 29151 | 3194 | 40 |
2277236 | 2277236 | 2022-03-05 | Baker | Oregon | 41001 | 3194 | 46 |
2272250 | 2272250 | 2022-03-04 | Oglethorpe | Georgia | 13221 | 3194 | 50 |
2273326 | 2273326 | 2022-03-04 | Osage | Missouri | 29151 | 3194 | 40 |
2273983 | 2273983 | 2022-03-04 | Baker | Oregon | 41001 | 3194 | 46 |
2268998 | 2268998 | 2022-03-03 | Oglethorpe | Georgia | 13221 | 3194 | 49 |
2270730 | 2270730 | 2022-03-03 | Baker | Oregon | 41001 | 3194 | 46 |
2231891 | 2231891 | 2022-02-19 | Utuado | Puerto Rico | 72141 | 3194 | |
2224513 | 2224513 | 2022-02-17 | Dent | Missouri | 29065 | 3194 | 69 |
2209112 | 2209112 | 2022-02-12 | Naguabo | Puerto Rico | 72103 | 3194 | |
2191611 | 2191611 | 2022-02-07 | Madison | Louisiana | 22065 | 3194 | 57 |
2179503 | 2179503 | 2022-02-03 | Walsh | North Dakota | 38099 | 3194 | 34 |
2165456 | 2165456 | 2022-01-30 | Carroll | Kentucky | 21041 | 3194 | 39 |
2162201 | 2162201 | 2022-01-29 | Carroll | Kentucky | 21041 | 3194 | 39 |
2158946 | 2158946 | 2022-01-28 | Carroll | Kentucky | 21041 | 3194 | 39 |
2152601 | 2152601 | 2022-01-26 | West Carroll | Louisiana | 22123 | 3194 | 53 |
2147251 | 2147251 | 2022-01-24 | Aibonito | Puerto Rico | 72009 | 3194 | |
2118276 | 2118276 | 2022-01-15 | Bosque | Texas | 48035 | 3194 | 59 |
2107791 | 2107791 | 2022-01-12 | Bertie | North Carolina | 37015 | 3194 | 54 |
2101824 | 2101824 | 2022-01-10 | Lee | South Carolina | 45061 | 3194 | 82 |
2079677 | 2079677 | 2022-01-03 | Asotin | Washington | 53003 | 3194 | 52 |
2055794 | 2055794 | 2021-12-27 | Currituck | North Carolina | 37053 | 3194 | 27 |
2052544 | 2052544 | 2021-12-26 | Currituck | North Carolina | 37053 | 3194 | 27 |
2049294 | 2049294 | 2021-12-25 | Currituck | North Carolina | 37053 | 3194 | 27 |
2046044 | 2046044 | 2021-12-24 | Currituck | North Carolina | 37053 | 3194 | 27 |
2042794 | 2042794 | 2021-12-23 | Currituck | North Carolina | 37053 | 3194 | 27 |
2039545 | 2039545 | 2021-12-22 | Currituck | North Carolina | 37053 | 3194 | 27 |
2035091 | 2035091 | 2021-12-21 | Franklin | Indiana | 18047 | 3194 | 51 |
2015535 | 2015535 | 2021-12-15 | Pike | Illinois | 17149 | 3194 | 61 |
1989029 | 1989029 | 2021-12-07 | Sharp | Arkansas | 5135 | 3194 | 71 |
1982384 | 1982384 | 2021-12-05 | Hale | Alabama | 1065 | 3194 | 89 |
1969783 | 1969783 | 2021-12-01 | Crisp | Georgia | 13081 | 3194 | 116 |
1913948 | 1913948 | 2021-11-13 | Brooke | West Virginia | 54009 | 3194 | 74 |
1906390 | 1906390 | 2021-11-11 | Rolette | North Dakota | 38079 | 3194 | 35 |
1897814 | 1897814 | 2021-11-08 | Vilas | Wisconsin | 55125 | 3194 | 57 |
1884958 | 1884958 | 2021-11-05 | Ashley | Arkansas | 5003 | 3194 | 50 |
1877697 | 1877697 | 2021-11-02 | Polk | Tennessee | 47139 | 3194 | 31 |
1874764 | 1874764 | 2021-11-01 | Franklin | Vermont | 50011 | 3194 | 50 |
1862205 | 1862205 | 2021-10-29 | La Paz | Arizona | 4012 | 3194 | 98 |
1860776 | 1860776 | 2021-10-28 | Caswell | North Carolina | 37033 | 3194 | 37 |
1849886 | 1849886 | 2021-10-25 | Starke | Indiana | 18149 | 3194 | 73 |
1795092 | 1795092 | 2021-10-08 | Somerset | Maryland | 24039 | 3194 | 48 |
1780930 | 1780930 | 2021-10-04 | Randolph | Alabama | 1111 | 3194 | 58 |
1767952 | 1767952 | 2021-09-30 | Juneau City and Borough | Alaska | 2110 | 3194 | 7 |
1769322 | 1769322 | 2021-09-30 | Jasper | Mississippi | 28061 | 3194 | 62 |
1741632 | 1741632 | 2021-09-21 | Lee | Virginia | 51105 | 3194 | 51 |
1705192 | 1705192 | 2021-09-10 | Elk | Pennsylvania | 42047 | 3194 | 44 |
1690070 | 1690070 | 2021-09-06 | Ouachita | Arkansas | 5103 | 3194 | 68 |
1679890 | 1679890 | 2021-09-02 | Halifax | Virginia | 51083 | 3194 | 89 |
1680001 | 1680001 | 2021-09-02 | Stevens | Washington | 53065 | 3194 | 38 |
1671911 | 1671911 | 2021-08-31 | Adair | Missouri | 29001 | 3194 | 27 |
1650425 | 1650425 | 2021-08-24 | Jasper | Texas | 48241 | 3194 | 101 |
1631693 | 1631693 | 2021-08-19 | Delta | Colorado | 8029 | 3194 | 76 |
1633755 | 1633755 | 2021-08-19 | Tioga | Pennsylvania | 42117 | 3194 | 113 |
1609417 | 1609417 | 2021-08-12 | Daviess | Indiana | 18027 | 3194 | 103 |
1611294 | 1611294 | 2021-08-12 | Overton | Tennessee | 47133 | 3194 | 63 |
1601334 | 1601334 | 2021-08-09 | Mayaguez | Puerto Rico | 72097 | 3194 | |
1561869 | 1561869 | 2021-07-28 | Washington | New York | 36115 | 3194 | 55 |
1558681 | 1558681 | 2021-07-27 | Macon | North Carolina | 37113 | 3194 | 41 |
1536426 | 1536426 | 2021-07-20 | Edgefield | South Carolina | 45037 | 3194 | 43 |
1517809 | 1517809 | 2021-07-15 | Pike | Alabama | 1109 | 3194 | 78 |
1493882 | 1493882 | 2021-07-07 | Jackson | Ohio | 39079 | 3194 | 54 |
1395083 | 1395083 | 2021-06-07 | Perry | Illinois | 17145 | 3194 | 69 |
1391838 | 1391838 | 2021-06-06 | Perry | Illinois | 17145 | 3194 | 69 |
1388593 | 1388593 | 2021-06-05 | Perry | Illinois | 17145 | 3194 | 69 |
1373920 | 1373920 | 2021-05-31 | Benton | Oregon | 41003 | 3194 | 22 |
1370675 | 1370675 | 2021-05-30 | Benton | Oregon | 41003 | 3194 | 22 |
1362629 | 1362629 | 2021-05-28 | Perry | Illinois | 17145 | 3194 | 69 |
1359294 | 1359294 | 2021-05-27 | Latah | Idaho | 16057 | 3194 | 10 |
1360316 | 1360316 | 2021-05-27 | Warren | Missouri | 29219 | 3194 | 33 |
1354756 | 1354756 | 2021-05-25 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1355336 | 1355336 | 2021-05-25 | Logan | West Virginia | 54045 | 3194 | 94 |
1348264 | 1348264 | 2021-05-23 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1342589 | 1342589 | 2021-05-22 | Baxter | Arkansas | 5005 | 3194 | 104 |
1345016 | 1345016 | 2021-05-22 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1341768 | 1341768 | 2021-05-21 | Claiborne | Tennessee | 47025 | 3194 | 74 |
1337128 | 1337128 | 2021-05-20 | Jefferson Davis | Louisiana | 22053 | 3194 | 97 |
1316847 | 1316847 | 2021-05-14 | Hardee | Florida | 12049 | 3194 | 44 |
1274841 | 1274841 | 2021-05-01 | White | Georgia | 13311 | 3194 | 80 |
1266851 | 1266851 | 2021-04-28 | Jefferson | Pennsylvania | 42065 | 3194 | 95 |
1258803 | 1258803 | 2021-04-26 | Jefferson | Indiana | 18077 | 3194 | 81 |
1255349 | 1255349 | 2021-04-25 | Unknown | Georgia | 3194 | 13 | |
1255556 | 1255556 | 2021-04-25 | Jefferson | Indiana | 18077 | 3194 | 81 |
1244304 | 1244304 | 2021-04-21 | Davison | South Dakota | 46035 | 3194 | 67 |
1232235 | 1232235 | 2021-04-18 | Lincoln | Arkansas | 5079 | 3194 | 48 |
1228986 | 1228986 | 2021-04-17 | Lincoln | Arkansas | 5079 | 3194 | 48 |
1211254 | 1211254 | 2021-04-11 | Wyoming | New York | 36121 | 3194 | 51 |
1206460 | 1206460 | 2021-04-10 | Levy | Florida | 12075 | 3194 | 45 |
1207452 | 1207452 | 2021-04-10 | Freeborn | Minnesota | 27047 | 3194 | 29 |
1182432 | 1182432 | 2021-04-02 | Pike | Pennsylvania | 42103 | 3194 | 51 |
1175107 | 1175107 | 2021-03-31 | Tate | Mississippi | 28137 | 3194 | 80 |
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);