ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 5513 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Texas 13
- Georgia 7
- North Carolina 6
- Illinois 5
- Michigan 5
- Tennessee 5
- Florida 4
- Mississippi 4
- New York 4
- Arkansas 3
- Maryland 3
- Virginia 3
- Alaska 2
- Idaho 2
- Indiana 2
- Kentucky 2
- Missouri 2
- Pennsylvania 2
- Arizona 1
- California 1
- Colorado 1
- Iowa 1
- Louisiana 1
- Minnesota 1
- Puerto Rico 1
- South Carolina 1
- Utah 1
- Vermont 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375419 | 2375419 | 2022-04-04 | San Jacinto | Texas | 48407 | 5513 | 100 |
2375500 | 2375500 | 2022-04-04 | Addison | Vermont | 50001 | 5513 | 15 |
2372167 | 2372167 | 2022-04-03 | San Jacinto | Texas | 48407 | 5513 | 100 |
2362346 | 2362346 | 2022-03-31 | Lampasas | Texas | 48281 | 5513 | 90 |
2359092 | 2359092 | 2022-03-30 | Lampasas | Texas | 48281 | 5513 | 90 |
2355838 | 2355838 | 2022-03-29 | Lampasas | Texas | 48281 | 5513 | 90 |
2352585 | 2352585 | 2022-03-28 | Lampasas | Texas | 48281 | 5513 | 90 |
2349333 | 2349333 | 2022-03-27 | Lampasas | Texas | 48281 | 5513 | 90 |
2346080 | 2346080 | 2022-03-26 | Lampasas | Texas | 48281 | 5513 | 90 |
2342827 | 2342827 | 2022-03-25 | Lampasas | Texas | 48281 | 5513 | 90 |
2339574 | 2339574 | 2022-03-24 | Lampasas | Texas | 48281 | 5513 | 90 |
2311066 | 2311066 | 2022-03-16 | Morgan | Colorado | 8087 | 5513 | 134 |
2302884 | 2302884 | 2022-03-13 | Essex | New York | 36031 | 5513 | 57 |
2294020 | 2294020 | 2022-03-10 | Karnes | Texas | 48255 | 5513 | 67 |
2284843 | 2284843 | 2022-03-08 | Nome Census Area | Alaska | 2180 | 5513 | 5 |
2281591 | 2281591 | 2022-03-07 | Nome Census Area | Alaska | 2180 | 5513 | 5 |
2282105 | 2282105 | 2022-03-07 | Payette | Idaho | 16075 | 5513 | 84 |
2245197 | 2245197 | 2022-02-23 | Frio | Texas | 48163 | 5513 | 89 |
2236373 | 2236373 | 2022-02-21 | Unknown | Florida | 5513 | 1330 | |
2233122 | 2233122 | 2022-02-20 | Unknown | Florida | 5513 | 1330 | |
2229871 | 2229871 | 2022-02-19 | Unknown | Florida | 5513 | 1330 | |
2193466 | 2193466 | 2022-02-07 | Mecklenburg | Virginia | 51117 | 5513 | 106 |
2187380 | 2187380 | 2022-02-06 | Sevier | Arkansas | 5133 | 5513 | 64 |
2142345 | 2142345 | 2022-01-23 | Shelby | Illinois | 17173 | 5513 | 66 |
2139090 | 2139090 | 2022-01-22 | Shelby | Illinois | 17173 | 5513 | 66 |
2135834 | 2135834 | 2022-01-21 | Shelby | Illinois | 17173 | 5513 | 66 |
2127807 | 2127807 | 2022-01-18 | Abbeville | South Carolina | 45001 | 5513 | 57 |
2032482 | 2032482 | 2021-12-20 | Lyon | Minnesota | 27083 | 5513 | 64 |
2005634 | 2005634 | 2021-12-12 | Toombs | Georgia | 13279 | 5513 | 177 |
2002383 | 2002383 | 2021-12-11 | Toombs | Georgia | 13279 | 5513 | 177 |
1999133 | 1999133 | 2021-12-10 | Toombs | Georgia | 13279 | 5513 | 177 |
1995882 | 1995882 | 2021-12-09 | Toombs | Georgia | 13279 | 5513 | 177 |
1928677 | 1928677 | 2021-11-18 | Pulaski | Missouri | 29169 | 5513 | 96 |
1806007 | 1806007 | 2021-10-11 | Ponce | Puerto Rico | 72113 | 5513 | |
1771305 | 1771305 | 2021-10-01 | Union | Arkansas | 5139 | 5513 | 128 |
1710886 | 1710886 | 2021-09-12 | Union | Mississippi | 28145 | 5513 | 85 |
1707639 | 1707639 | 2021-09-11 | Union | Mississippi | 28145 | 5513 | 85 |
1704392 | 1704392 | 2021-09-10 | Union | Mississippi | 28145 | 5513 | 85 |
1654291 | 1654291 | 2021-08-26 | Boone | Arkansas | 5009 | 5513 | 98 |
1651566 | 1651566 | 2021-08-25 | Henry | Illinois | 17073 | 5513 | 100 |
1617060 | 1617060 | 2021-08-14 | Genesee | New York | 36037 | 5513 | 124 |
1609158 | 1609158 | 2021-08-12 | Habersham | Georgia | 13137 | 5513 | 168 |
1519009 | 1519009 | 2021-07-15 | Cass | Michigan | 26027 | 5513 | 78 |
1515762 | 1515762 | 2021-07-14 | Cass | Michigan | 26027 | 5513 | 78 |
1512516 | 1512516 | 2021-07-13 | Cass | Michigan | 26027 | 5513 | 78 |
1405718 | 1405718 | 2021-06-10 | Newton | Missouri | 29145 | 5513 | 80 |
1359874 | 1359874 | 2021-05-27 | St. Charles | Louisiana | 22089 | 5513 | 97 |
1289183 | 1289183 | 2021-05-05 | Wayne | New York | 36117 | 5513 | 67 |
1246941 | 1246941 | 2021-04-22 | Jefferson | New York | 36045 | 5513 | 65 |
1237949 | 1237949 | 2021-04-19 | Warren | Tennessee | 47177 | 5513 | 81 |
1233379 | 1233379 | 2021-04-18 | Marquette | Michigan | 26103 | 5513 | 58 |
1230131 | 1230131 | 2021-04-17 | Marquette | Michigan | 26103 | 5513 | 58 |
1200816 | 1200816 | 2021-04-08 | Cecil | Maryland | 24015 | 5513 | 127 |
1166445 | 1166445 | 2021-03-28 | Hawkins | Tennessee | 47073 | 5513 | 103 |
1163197 | 1163197 | 2021-03-27 | Hawkins | Tennessee | 47073 | 5513 | 103 |
1159948 | 1159948 | 2021-03-26 | Hawkins | Tennessee | 47073 | 5513 | 103 |
1060772 | 1060772 | 2021-02-24 | Shelby | Indiana | 18145 | 5513 | 100 |
1018867 | 1018867 | 2021-02-11 | Laurel | Kentucky | 21125 | 5513 | 23 |
1020784 | 1020784 | 2021-02-11 | Harrisonburg city | Virginia | 51660 | 5513 | 68 |
1020877 | 1020877 | 2021-02-11 | Kitsap | Washington | 53035 | 5513 | 79 |
1015659 | 1015659 | 2021-02-10 | Pulaski | Kentucky | 21199 | 5513 | 79 |
1008311 | 1008311 | 2021-02-08 | Yuba | California | 6115 | 5513 | 36 |
959735 | 959735 | 2021-01-24 | Jackson | Florida | 12063 | 5513 | 129 |
953599 | 953599 | 2021-01-22 | Boone | Indiana | 18011 | 5513 | 71 |
939561 | 939561 | 2021-01-17 | Tooele | Utah | 49045 | 5513 | 17 |
934022 | 934022 | 2021-01-16 | Boone | Illinois | 17007 | 5513 | 77 |
929469 | 929469 | 2021-01-14 | Coffee | Tennessee | 47031 | 5513 | 81 |
902398 | 902398 | 2021-01-06 | Forrest | Mississippi | 28035 | 5513 | 106 |
892432 | 892432 | 2021-01-03 | Allegany | Maryland | 24001 | 5513 | 154 |
817142 | 817142 | 2020-12-11 | Bannock | Idaho | 16005 | 5513 | 44 |
815602 | 815602 | 2020-12-10 | Beaver | Pennsylvania | 42007 | 5513 | 183 |
796793 | 796793 | 2020-12-04 | Alexandria city | Virginia | 51510 | 5513 | 81 |
780830 | 780830 | 2020-11-29 | Manitowoc | Wisconsin | 55071 | 5513 | 41 |
761855 | 761855 | 2020-11-24 | Douglas | Georgia | 13097 | 5513 | 86 |
760170 | 760170 | 2020-11-23 | Wayne | North Carolina | 37191 | 5513 | 110 |
664943 | 664943 | 2020-10-25 | Linn | Iowa | 19113 | 5513 | 129 |
666045 | 666045 | 2020-10-25 | Johnston | North Carolina | 37101 | 5513 | 65 |
662800 | 662800 | 2020-10-24 | Johnston | North Carolina | 37101 | 5513 | 65 |
659556 | 659556 | 2020-10-23 | Johnston | North Carolina | 37101 | 5513 | 65 |
528367 | 528367 | 2020-09-13 | Cherokee | Georgia | 13057 | 5513 | 87 |
436160 | 436160 | 2020-08-15 | Forsyth | North Carolina | 37067 | 5513 | 56 |
410383 | 410383 | 2020-08-07 | Guilford | North Carolina | 37081 | 5513 | 154 |
321997 | 321997 | 2020-07-11 | Pinal | Arizona | 4021 | 5513 | 84 |
196458 | 196458 | 2020-05-31 | Tarrant | Texas | 48439 | 5513 | 165 |
179649 | 179649 | 2020-05-26 | Baltimore | Maryland | 24005 | 5513 | 312 |
141342 | 141342 | 2020-05-13 | Montgomery | Pennsylvania | 42091 | 5513 | 556 |
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);