ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 5822 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Indiana 9
- Wisconsin 8
- Texas 6
- California 5
- Tennessee 5
- Virginia 5
- Kansas 4
- Missouri 4
- Arkansas 3
- Louisiana 3
- Puerto Rico 3
- West Virginia 3
- Illinois 2
- Michigan 2
- Florida 1
- Georgia 1
- Iowa 1
- Kentucky 1
- Maine 1
- Minnesota 1
- Mississippi 1
- North Dakota 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- South Dakota 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395234 | 2395234 | 2022-04-10 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2391978 | 2391978 | 2022-04-09 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2387980 | 2387980 | 2022-04-08 | Juana Diaz | Puerto Rico | 72075 | 5822 | |
2388722 | 2388722 | 2022-04-08 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2314794 | 2314794 | 2022-03-17 | Owen | Indiana | 18119 | 5822 | 116 |
2304208 | 2304208 | 2022-03-13 | Kewaunee | Wisconsin | 55061 | 5822 | 56 |
2300956 | 2300956 | 2022-03-12 | Kewaunee | Wisconsin | 55061 | 5822 | 56 |
2297704 | 2297704 | 2022-03-11 | Kewaunee | Wisconsin | 55061 | 5822 | 56 |
2291441 | 2291441 | 2022-03-10 | Sevier | Arkansas | 5133 | 5822 | 70 |
2264374 | 2264374 | 2022-03-01 | Manati | Puerto Rico | 72091 | 5822 | |
2261124 | 2261124 | 2022-02-28 | Manati | Puerto Rico | 72091 | 5822 | |
2258679 | 2258679 | 2022-02-27 | Kewaunee | Wisconsin | 55061 | 5822 | 55 |
2255428 | 2255428 | 2022-02-26 | Kewaunee | Wisconsin | 55061 | 5822 | 55 |
2252177 | 2252177 | 2022-02-25 | Kewaunee | Wisconsin | 55061 | 5822 | 55 |
2244970 | 2244970 | 2022-02-23 | Davison | South Dakota | 46035 | 5822 | 78 |
2223731 | 2223731 | 2022-02-17 | LaGrange | Indiana | 18087 | 5822 | 100 |
2197757 | 2197757 | 2022-02-09 | Washington | Indiana | 18175 | 5822 | 75 |
2194503 | 2194503 | 2022-02-08 | Washington | Indiana | 18175 | 5822 | 75 |
2177566 | 2177566 | 2022-02-03 | Carroll | Arkansas | 5015 | 5822 | 87 |
2178355 | 2178355 | 2022-02-03 | Cherokee | Kansas | 20021 | 5822 | 82 |
2175102 | 2175102 | 2022-02-02 | Cherokee | Kansas | 20021 | 5822 | 82 |
2151539 | 2151539 | 2022-01-26 | Cleburne | Arkansas | 5023 | 5822 | 107 |
2052196 | 2052196 | 2021-12-26 | Pulaski | Missouri | 29169 | 5822 | 99 |
2048946 | 2048946 | 2021-12-25 | Pulaski | Missouri | 29169 | 5822 | 99 |
2045696 | 2045696 | 2021-12-24 | Pulaski | Missouri | 29169 | 5822 | 99 |
1962659 | 1962659 | 2021-11-28 | Wise | Virginia | 51195 | 5822 | 130 |
1959408 | 1959408 | 2021-11-27 | Wise | Virginia | 51195 | 5822 | 130 |
1956157 | 1956157 | 2021-11-26 | Wise | Virginia | 51195 | 5822 | 130 |
1906883 | 1906883 | 2021-11-11 | Carroll | Tennessee | 47017 | 5822 | 106 |
1906930 | 1906930 | 2021-11-11 | Marion | Tennessee | 47115 | 5822 | 55 |
1903634 | 1903634 | 2021-11-10 | Carroll | Tennessee | 47017 | 5822 | 106 |
1903681 | 1903681 | 2021-11-10 | Marion | Tennessee | 47115 | 5822 | 55 |
1903830 | 1903830 | 2021-11-10 | Hill | Texas | 48217 | 5822 | 164 |
1900580 | 1900580 | 2021-11-09 | Hill | Texas | 48217 | 5822 | 164 |
1864957 | 1864957 | 2021-10-29 | Upshur | Texas | 48459 | 5822 | 140 |
1830300 | 1830300 | 2021-10-19 | Stephenson | Illinois | 17177 | 5822 | 111 |
1816335 | 1816335 | 2021-10-14 | Franklin | Virginia | 51067 | 5822 | 98 |
1751167 | 1751167 | 2021-09-24 | Matagorda | Texas | 48321 | 5822 | 144 |
1704413 | 1704413 | 2021-09-10 | Butler | Missouri | 29023 | 5822 | 61 |
1700059 | 1700059 | 2021-09-09 | Bryan | Georgia | 13029 | 5822 | 45 |
1698440 | 1698440 | 2021-09-08 | Morton | North Dakota | 38059 | 5822 | 102 |
1652392 | 1652392 | 2021-08-25 | Neshoba | Mississippi | 28099 | 5822 | 187 |
1642334 | 1642334 | 2021-08-22 | Lincoln | Louisiana | 22061 | 5822 | 100 |
1639084 | 1639084 | 2021-08-21 | Lincoln | Louisiana | 22061 | 5822 | 100 |
1635834 | 1635834 | 2021-08-20 | Lincoln | Louisiana | 22061 | 5822 | 100 |
1626259 | 1626259 | 2021-08-17 | Tuscola | Michigan | 26157 | 5822 | 176 |
1623012 | 1623012 | 2021-08-16 | Tuscola | Michigan | 26157 | 5822 | 176 |
1534606 | 1534606 | 2021-07-20 | Coles | Illinois | 17029 | 5822 | 103 |
1534915 | 1534915 | 2021-07-20 | Ford | Kansas | 20057 | 5822 | 77 |
1531668 | 1531668 | 2021-07-19 | Ford | Kansas | 20057 | 5822 | 77 |
1488739 | 1488739 | 2021-07-06 | Lassen | California | 6035 | 5822 | 26 |
1485492 | 1485492 | 2021-07-05 | Lassen | California | 6035 | 5822 | 26 |
1482246 | 1482246 | 2021-07-04 | Lassen | California | 6035 | 5822 | 26 |
1478999 | 1478999 | 2021-07-03 | Lassen | California | 6035 | 5822 | 26 |
1475753 | 1475753 | 2021-07-02 | Lassen | California | 6035 | 5822 | 26 |
1455461 | 1455461 | 2021-06-25 | Atascosa | Texas | 48013 | 5822 | 151 |
1450347 | 1450347 | 2021-06-24 | Noble | Indiana | 18113 | 5822 | 91 |
1392052 | 1392052 | 2021-06-06 | Warren | Iowa | 19181 | 5822 | 90 |
1319389 | 1319389 | 2021-05-14 | Iron | Utah | 49021 | 5822 | 32 |
1307480 | 1307480 | 2021-05-11 | Dearborn | Indiana | 18029 | 5822 | 81 |
1286799 | 1286799 | 2021-05-04 | Lamar | Texas | 48277 | 5822 | 155 |
1245826 | 1245826 | 2021-04-22 | Marshall | Indiana | 18099 | 5822 | 110 |
1248228 | 1248228 | 2021-04-22 | Barron | Wisconsin | 55005 | 5822 | 77 |
1207288 | 1207288 | 2021-04-10 | Androscoggin | Maine | 23001 | 5822 | 59 |
1163854 | 1163854 | 2021-03-27 | Waupaca | Wisconsin | 55135 | 5822 | 161 |
1105174 | 1105174 | 2021-03-09 | Harrisonburg city | Virginia | 51660 | 5822 | 94 |
1097059 | 1097059 | 2021-03-07 | Kandiyohi | Minnesota | 27067 | 5822 | 74 |
1093553 | 1093553 | 2021-03-06 | Pulaski | Kentucky | 21199 | 5822 | 88 |
1070098 | 1070098 | 2021-02-27 | Monroe | Florida | 12087 | 5822 | 46 |
1049597 | 1049597 | 2021-02-20 | McMinn | Tennessee | 47107 | 5822 | 89 |
1046000 | 1046000 | 2021-02-19 | Deschutes | Oregon | 41017 | 5822 | 58 |
1036118 | 1036118 | 2021-02-16 | Geauga | Ohio | 39055 | 5822 | 126 |
917916 | 917916 | 2021-01-11 | Floyd | Indiana | 18043 | 5822 | 109 |
535197 | 535197 | 2020-09-15 | St. Joseph | Indiana | 18141 | 5822 | 102 |
410734 | 410734 | 2020-08-07 | Lancaster | Pennsylvania | 42071 | 5822 | 410 |
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);