ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 6743 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2438421 | 2438421 | 2022-04-24 | Fayette | Indiana | 18041 | 6743 | 146 |
2435165 | 2435165 | 2022-04-23 | Fayette | Indiana | 18041 | 6743 | 146 |
2431909 | 2431909 | 2022-04-22 | Fayette | Indiana | 18041 | 6743 | 146 |
2427420 | 2427420 | 2022-04-20 | Hutchinson | Texas | 48233 | 6743 | 135 |
2359064 | 2359064 | 2022-03-30 | Howard | Texas | 48227 | 6743 | 183 |
2340048 | 2340048 | 2022-03-24 | Park | Wyoming | 56029 | 6743 | 142 |
2336795 | 2336795 | 2022-03-23 | Park | Wyoming | 56029 | 6743 | 142 |
2333541 | 2333541 | 2022-03-22 | Park | Wyoming | 56029 | 6743 | 142 |
2214385 | 2214385 | 2022-02-14 | Morehouse | Louisiana | 22067 | 6743 | 129 |
2195889 | 2195889 | 2022-02-08 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2191936 | 2191936 | 2022-02-07 | Simpson | Mississippi | 28127 | 6743 | 134 |
2192635 | 2192635 | 2022-02-07 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2189381 | 2189381 | 2022-02-06 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2186128 | 2186128 | 2022-02-05 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2182876 | 2182876 | 2022-02-04 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2178111 | 2178111 | 2022-02-03 | McDonough | Illinois | 17109 | 6743 | 92 |
2179624 | 2179624 | 2022-02-03 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2174858 | 2174858 | 2022-02-02 | McDonough | Illinois | 17109 | 6743 | 92 |
2176373 | 2176373 | 2022-02-02 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2174113 | 2174113 | 2022-02-01 | Door | Wisconsin | 55029 | 6743 | 54 |
2164446 | 2164446 | 2022-01-30 | Clarke | Alabama | 1025 | 6743 | 89 |
2160664 | 2160664 | 2022-01-28 | Hopkins | Texas | 48223 | 6743 | 159 |
2156998 | 2156998 | 2022-01-27 | Warren | Pennsylvania | 42123 | 6743 | 195 |
2108310 | 2108310 | 2022-01-12 | Colleton | South Carolina | 45029 | 6743 | 195 |
2091902 | 2091902 | 2022-01-07 | Clarion | Pennsylvania | 42031 | 6743 | 178 |
2087982 | 2087982 | 2022-01-06 | Webster | Missouri | 29225 | 6743 | 120 |
2074784 | 2074784 | 2022-01-02 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2071533 | 2071533 | 2022-01-01 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2068282 | 2068282 | 2021-12-31 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2065031 | 2065031 | 2021-12-30 | Bolivar | Mississippi | 28011 | 6743 | 154 |
2014484 | 2014484 | 2021-12-14 | Wood | Texas | 48499 | 6743 | 233 |
1951939 | 1951939 | 2021-11-25 | Guernsey | Ohio | 39059 | 6743 | 83 |
1948688 | 1948688 | 2021-11-24 | Guernsey | Ohio | 39059 | 6743 | 83 |
1895948 | 1895948 | 2021-11-08 | Goodhue | Minnesota | 27049 | 6743 | 89 |
1896596 | 1896596 | 2021-11-08 | Watauga | North Carolina | 37189 | 6743 | 39 |
1883733 | 1883733 | 2021-11-04 | Shelby | Ohio | 39149 | 6743 | 125 |
1858873 | 1858873 | 2021-10-28 | Covington | Alabama | 1039 | 6743 | 183 |
1857874 | 1857874 | 2021-10-27 | Bedford | Pennsylvania | 42009 | 6743 | 170 |
1823138 | 1823138 | 2021-10-17 | Escambia | Alabama | 1053 | 6743 | 127 |
1816332 | 1816332 | 2021-10-14 | Fauquier | Virginia | 51061 | 6743 | 83 |
1692734 | 1692734 | 2021-09-06 | Rusk | Texas | 48401 | 6743 | 126 |
1552814 | 1552814 | 2021-07-25 | McMinn | Tennessee | 47107 | 6743 | 105 |
1549567 | 1549567 | 2021-07-24 | McMinn | Tennessee | 47107 | 6743 | 105 |
1546320 | 1546320 | 2021-07-23 | McMinn | Tennessee | 47107 | 6743 | 105 |
1429402 | 1429402 | 2021-06-17 | Carter | Tennessee | 47019 | 6743 | 158 |
1426157 | 1426157 | 2021-06-16 | Carter | Tennessee | 47019 | 6743 | 158 |
1417535 | 1417535 | 2021-06-14 | Bulloch | Georgia | 13031 | 6743 | 122 |
1414289 | 1414289 | 2021-06-13 | Bulloch | Georgia | 13031 | 6743 | 122 |
1411044 | 1411044 | 2021-06-12 | Bulloch | Georgia | 13031 | 6743 | 122 |
1343080 | 1343080 | 2021-05-22 | Boone | Illinois | 17007 | 6743 | 87 |
1196392 | 1196392 | 2021-04-07 | Jackson | Alabama | 1071 | 6743 | 108 |
931246 | 931246 | 2021-01-15 | Madison | Kentucky | 21151 | 6743 | 43 |
791408 | 791408 | 2020-12-03 | Vigo | Indiana | 18167 | 6743 | 108 |
673823 | 673823 | 2020-10-28 | Baldwin | Alabama | 1003 | 6743 | 69 |
670980 | 670980 | 2020-10-27 | Bibb | Georgia | 13021 | 6743 | 196 |
546377 | 546377 | 2020-09-18 | Multnomah | Oregon | 41051 | 6743 | 132 |
517116 | 517116 | 2020-09-09 | Montgomery | Ohio | 39113 | 6743 | 138 |
383038 | 383038 | 2020-07-30 | New Castle | Delaware | 10003 | 6743 | 285 |
217498 | 217498 | 2020-06-07 | Delaware | Pennsylvania | 42045 | 6743 | 651 |
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);