ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 11297 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Oklahoma 7
- Ohio 5
- Texas 3
- Wisconsin 3
- Georgia 2
- Iowa 2
- Arizona 1
- Connecticut 1
- Delaware 1
- Idaho 1
- Montana 1
- New York 1
- North Carolina 1
- Pennsylvania 1
- Virginia 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496201 | 2496201 | 2022-05-11 | Ohio | West Virginia | 54069 | 11297 | 167 |
2456308 | 2456308 | 2022-04-29 | Venango | Pennsylvania | 42121 | 11297 | 238 |
2440452 | 2440452 | 2022-04-24 | Jim Wells | Texas | 48249 | 11297 | 207 |
2437196 | 2437196 | 2022-04-23 | Jim Wells | Texas | 48249 | 11297 | 207 |
2235934 | 2235934 | 2022-02-20 | Oconto | Wisconsin | 55083 | 11297 | 104 |
2232683 | 2232683 | 2022-02-19 | Oconto | Wisconsin | 55083 | 11297 | 104 |
2229432 | 2229432 | 2022-02-18 | Oconto | Wisconsin | 55083 | 11297 | 104 |
2218680 | 2218680 | 2022-02-15 | McClain | Oklahoma | 40087 | 11297 | 117 |
2215429 | 2215429 | 2022-02-14 | McClain | Oklahoma | 40087 | 11297 | 117 |
2212178 | 2212178 | 2022-02-13 | McClain | Oklahoma | 40087 | 11297 | 117 |
2208925 | 2208925 | 2022-02-12 | McClain | Oklahoma | 40087 | 11297 | 117 |
2205672 | 2205672 | 2022-02-11 | McClain | Oklahoma | 40087 | 11297 | 117 |
2202419 | 2202419 | 2022-02-10 | McClain | Oklahoma | 40087 | 11297 | 117 |
2199165 | 2199165 | 2022-02-09 | McClain | Oklahoma | 40087 | 11297 | 117 |
2131613 | 2131613 | 2022-01-19 | Fauquier | Virginia | 51061 | 11297 | 99 |
1836423 | 1836423 | 2021-10-21 | Tolland | Connecticut | 9013 | 11297 | 198 |
1826873 | 1826873 | 2021-10-18 | Rockdale | Georgia | 13247 | 11297 | 227 |
1815499 | 1815499 | 2021-10-14 | Scioto | Ohio | 39145 | 11297 | 149 |
1782987 | 1782987 | 2021-10-04 | Marion | Ohio | 39101 | 11297 | 153 |
1760269 | 1760269 | 2021-09-27 | Tuscarawas | Ohio | 39157 | 11297 | 271 |
1738248 | 1738248 | 2021-09-20 | Walker | Texas | 48471 | 11297 | 155 |
1694803 | 1694803 | 2021-09-07 | Missoula | Montana | 30063 | 11297 | 111 |
1514352 | 1514352 | 2021-07-13 | Thurston | Washington | 53067 | 11297 | 115 |
1456898 | 1456898 | 2021-06-26 | Dallas | Iowa | 19049 | 11297 | 99 |
1453653 | 1453653 | 2021-06-25 | Dallas | Iowa | 19049 | 11297 | 99 |
1269729 | 1269729 | 2021-04-29 | Cleveland | North Carolina | 37045 | 11297 | 224 |
1254910 | 1254910 | 2021-04-25 | Apache | Arizona | 4001 | 11297 | 426 |
977677 | 977677 | 2021-01-29 | Clark | Ohio | 39023 | 11297 | 288 |
818692 | 818692 | 2020-12-11 | Mahoning | Ohio | 39099 | 11297 | 311 |
703470 | 703470 | 2020-11-06 | Hall | Georgia | 13139 | 11297 | 190 |
609259 | 609259 | 2020-10-08 | New Castle | Delaware | 10003 | 11297 | 323 |
489695 | 489695 | 2020-09-01 | Ada | Idaho | 16001 | 11297 | 127 |
449008 | 449008 | 2020-08-19 | Orange | New York | 36071 | 11297 | 408 |
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);