ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 5397 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 9
- Ohio 8
- Georgia 6
- New York 5
- North Carolina 5
- Texas 4
- Alabama 3
- Indiana 3
- Iowa 3
- Louisiana 3
- Maine 3
- Puerto Rico 3
- South Dakota 3
- Colorado 2
- Illinois 2
- Maryland 2
- Minnesota 2
- Oklahoma 2
- Pennsylvania 2
- Tennessee 2
- Utah 2
- Virginia 2
- Wisconsin 2
- California 1
- Florida 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- South Carolina 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476481 | 2476481 | 2022-05-05 | Dinwiddie | Virginia | 51053 | 5397 | 93 |
2461684 | 2461684 | 2022-05-01 | Lincoln | Maine | 23015 | 5397 | 35 |
2458428 | 2458428 | 2022-04-30 | Lincoln | Maine | 23015 | 5397 | 35 |
2450181 | 2450181 | 2022-04-27 | Gillespie | Texas | 48171 | 5397 | 109 |
2420542 | 2420542 | 2022-04-18 | Las Piedras | Puerto Rico | 72085 | 5397 | |
2396853 | 2396853 | 2022-04-11 | Stone | Mississippi | 28131 | 5397 | 71 |
2392564 | 2392564 | 2022-04-10 | Franklin | Georgia | 13119 | 5397 | 99 |
2393598 | 2393598 | 2022-04-10 | Stone | Mississippi | 28131 | 5397 | 71 |
2389308 | 2389308 | 2022-04-09 | Franklin | Georgia | 13119 | 5397 | 99 |
2390342 | 2390342 | 2022-04-09 | Stone | Mississippi | 28131 | 5397 | 71 |
2386053 | 2386053 | 2022-04-08 | Franklin | Georgia | 13119 | 5397 | 99 |
2387086 | 2387086 | 2022-04-08 | Stone | Mississippi | 28131 | 5397 | 71 |
2383831 | 2383831 | 2022-04-07 | Stone | Mississippi | 28131 | 5397 | 71 |
2380576 | 2380576 | 2022-04-06 | Stone | Mississippi | 28131 | 5397 | 71 |
2377321 | 2377321 | 2022-04-05 | Stone | Mississippi | 28131 | 5397 | 71 |
2374069 | 2374069 | 2022-04-04 | Stone | Mississippi | 28131 | 5397 | 71 |
2247149 | 2247149 | 2022-02-24 | Waseca | Minnesota | 27161 | 5397 | 39 |
2245390 | 2245390 | 2022-02-23 | Sevier | Utah | 49041 | 5397 | 26 |
2199734 | 2199734 | 2022-02-09 | Lampasas | Texas | 48281 | 5397 | 79 |
2142821 | 2142821 | 2022-01-23 | Richland | Louisiana | 22083 | 5397 | 81 |
2144140 | 2144140 | 2022-01-23 | Davison | South Dakota | 46035 | 5397 | 77 |
2139566 | 2139566 | 2022-01-22 | Richland | Louisiana | 22083 | 5397 | 81 |
2140885 | 2140885 | 2022-01-22 | Davison | South Dakota | 46035 | 5397 | 77 |
2141510 | 2141510 | 2022-01-22 | Boone | West Virginia | 54005 | 5397 | 63 |
2136310 | 2136310 | 2022-01-21 | Richland | Louisiana | 22083 | 5397 | 81 |
2137629 | 2137629 | 2022-01-21 | Davison | South Dakota | 46035 | 5397 | 77 |
2109792 | 2109792 | 2022-01-13 | McDonough | Illinois | 17109 | 5397 | 86 |
2083653 | 2083653 | 2022-01-05 | Unknown | Georgia | 5397 | 8 | |
2076897 | 2076897 | 2022-01-03 | Logan | Colorado | 8075 | 5397 | 97 |
2050635 | 2050635 | 2021-12-26 | Dallas | Alabama | 1047 | 5397 | 212 |
2014636 | 2014636 | 2021-12-14 | Prince George | Virginia | 51149 | 5397 | 52 |
1997137 | 1997137 | 2021-12-09 | Carroll | New Hampshire | 33003 | 5397 | 23 |
1943336 | 1943336 | 2021-11-22 | Park | Wyoming | 56029 | 5397 | 98 |
1876996 | 1876996 | 2021-11-02 | Tioga | New York | 36107 | 5397 | 72 |
1870327 | 1870327 | 2021-10-31 | Lincoln | Nebraska | 31111 | 5397 | 80 |
1760117 | 1760117 | 2021-09-27 | Scotland | North Carolina | 37165 | 5397 | 100 |
1757270 | 1757270 | 2021-09-26 | Ponce | Puerto Rico | 72113 | 5397 | |
1739393 | 1739393 | 2021-09-21 | Miami | Indiana | 18103 | 5397 | 89 |
1740715 | 1740715 | 2021-09-21 | Crawford | Ohio | 39033 | 5397 | 114 |
1717364 | 1717364 | 2021-09-14 | Pike | Mississippi | 28113 | 5397 | 133 |
1699310 | 1699310 | 2021-09-08 | Wasatch | Utah | 49051 | 5397 | 25 |
1574924 | 1574924 | 2021-08-01 | McDowell | North Carolina | 37111 | 5397 | 63 |
1571676 | 1571676 | 2021-07-31 | McDowell | North Carolina | 37111 | 5397 | 63 |
1568428 | 1568428 | 2021-07-30 | McDowell | North Carolina | 37111 | 5397 | 63 |
1563180 | 1563180 | 2021-07-28 | Shawano | Wisconsin | 55115 | 5397 | 85 |
1516084 | 1516084 | 2021-07-14 | Pettis | Missouri | 29159 | 5397 | 77 |
1380489 | 1380489 | 2021-06-02 | Mifflin | Pennsylvania | 42087 | 5397 | 178 |
1377016 | 1377016 | 2021-06-01 | Darke | Ohio | 39037 | 5397 | 128 |
1373770 | 1373770 | 2021-05-31 | Darke | Ohio | 39037 | 5397 | 128 |
1370525 | 1370525 | 2021-05-30 | Darke | Ohio | 39037 | 5397 | 128 |
1364033 | 1364033 | 2021-05-28 | Darke | Ohio | 39037 | 5397 | 128 |
1360787 | 1360787 | 2021-05-27 | Darke | Ohio | 39037 | 5397 | 126 |
1314066 | 1314066 | 2021-05-13 | Cerro Gordo | Iowa | 19033 | 5397 | 89 |
1276395 | 1276395 | 2021-05-01 | Huron | Ohio | 39077 | 5397 | 118 |
1273451 | 1273451 | 2021-04-30 | Unknown | Puerto Rico | 5397 | 2303 | |
1263209 | 1263209 | 2021-04-27 | Wayne | New York | 36117 | 5397 | 67 |
1255462 | 1255462 | 2021-04-25 | Knox | Illinois | 17095 | 5397 | 169 |
1249511 | 1249511 | 2021-04-23 | Kennebec | Maine | 23011 | 5397 | 65 |
1226348 | 1226348 | 2021-04-16 | Noble | Indiana | 18113 | 5397 | 86 |
1206117 | 1206117 | 2021-04-10 | Coffee | Alabama | 1031 | 5397 | 112 |
1189262 | 1189262 | 2021-04-04 | Caldwell | Texas | 48055 | 5397 | 93 |
1186015 | 1186015 | 2021-04-03 | Caldwell | Texas | 48055 | 5397 | 93 |
1147013 | 1147013 | 2021-03-22 | Warren | Tennessee | 47177 | 5397 | 80 |
1131336 | 1131336 | 2021-03-17 | Grant | Wisconsin | 55043 | 5397 | 87 |
1075403 | 1075403 | 2021-02-28 | Cherokee | South Carolina | 45021 | 5397 | 133 |
1050994 | 1050994 | 2021-02-21 | Henry | Indiana | 18065 | 5397 | 92 |
1047278 | 1047278 | 2021-02-20 | Fremont | Colorado | 8043 | 5397 | 48 |
1013191 | 1013191 | 2021-02-09 | Ontario | New York | 36069 | 5397 | 88 |
980733 | 980733 | 2021-01-30 | Oswego | New York | 36075 | 5397 | 83 |
922718 | 922718 | 2021-01-12 | Crawford | Pennsylvania | 42039 | 5397 | 104 |
909538 | 909538 | 2021-01-08 | Erie | Ohio | 39043 | 5397 | 111 |
895685 | 895685 | 2021-01-04 | Carroll | Maryland | 24013 | 5397 | 171 |
877212 | 877212 | 2020-12-29 | Pottawatomie | Oklahoma | 40125 | 5397 | 33 |
861334 | 861334 | 2020-12-24 | Hamblen | Tennessee | 47063 | 5397 | 77 |
752117 | 752117 | 2020-11-21 | Douglas | Georgia | 13097 | 5397 | 86 |
735666 | 735666 | 2020-11-16 | Placer | California | 6061 | 5397 | 64 |
716412 | 716412 | 2020-11-10 | Columbia | Georgia | 13073 | 5397 | 71 |
674646 | 674646 | 2020-10-28 | Dubuque | Iowa | 19061 | 5397 | 58 |
655159 | 655159 | 2020-10-22 | Black Hawk | Iowa | 19013 | 5397 | 98 |
616638 | 616638 | 2020-10-10 | Howard | Maryland | 24027 | 5397 | 123 |
589864 | 589864 | 2020-10-02 | Santa Rosa | Florida | 12113 | 5397 | 78 |
591424 | 591424 | 2020-10-02 | Gaston | North Carolina | 37071 | 5397 | 86 |
546287 | 546287 | 2020-09-18 | Cleveland | Oklahoma | 40027 | 5397 | 68 |
357085 | 357085 | 2020-07-22 | Montgomery | Alabama | 1101 | 5397 | 130 |
336013 | 336013 | 2020-07-15 | Ramsey | Minnesota | 27123 | 5397 | 238 |
168060 | 168060 | 2020-05-22 | Erie | New York | 36029 | 5397 | 473 |
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);