ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 7528 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Iowa 7
- Indiana 6
- Alabama 4
- Mississippi 4
- Michigan 3
- Pennsylvania 3
- Wisconsin 3
- Illinois 2
- Arkansas 1
- California 1
- Connecticut 1
- Georgia 1
- Idaho 1
- Missouri 1
- Montana 1
- New York 1
- North Carolina 1
- North Dakota 1
- Puerto Rico 1
- Texas 1
- Utah 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378212 | 2378212 | 2022-04-05 | Humacao | Puerto Rico | 72069 | 7528 | |
2353927 | 2353927 | 2022-03-29 | Marion | Iowa | 19125 | 7528 | 121 |
2350675 | 2350675 | 2022-03-28 | Marion | Iowa | 19125 | 7528 | 121 |
2347422 | 2347422 | 2022-03-27 | Marion | Iowa | 19125 | 7528 | 121 |
2344169 | 2344169 | 2022-03-26 | Marion | Iowa | 19125 | 7528 | 121 |
2340916 | 2340916 | 2022-03-25 | Marion | Iowa | 19125 | 7528 | 121 |
2337663 | 2337663 | 2022-03-24 | Marion | Iowa | 19125 | 7528 | 121 |
2334409 | 2334409 | 2022-03-23 | Marion | Iowa | 19125 | 7528 | 121 |
2258810 | 2258810 | 2022-02-28 | Winston | Alabama | 1133 | 7528 | 120 |
2255559 | 2255559 | 2022-02-27 | Winston | Alabama | 1133 | 7528 | 120 |
2242094 | 2242094 | 2022-02-22 | Upshur | Texas | 48459 | 7528 | 173 |
2213164 | 2213164 | 2022-02-13 | Juneau | Wisconsin | 55057 | 7528 | 61 |
2209911 | 2209911 | 2022-02-12 | Juneau | Wisconsin | 55057 | 7528 | 61 |
2206658 | 2206658 | 2022-02-11 | Juneau | Wisconsin | 55057 | 7528 | 61 |
2100006 | 2100006 | 2022-01-10 | Fulton | Illinois | 17057 | 7528 | 109 |
1987473 | 1987473 | 2021-12-06 | Livingston | New York | 36051 | 7528 | 79 |
1951906 | 1951906 | 2021-11-25 | Williams | North Dakota | 38105 | 7528 | 55 |
1905836 | 1905836 | 2021-11-11 | Washington | Mississippi | 28151 | 7528 | 167 |
1902587 | 1902587 | 2021-11-10 | Washington | Mississippi | 28151 | 7528 | 167 |
1882852 | 1882852 | 2021-11-04 | Branch | Michigan | 26023 | 7528 | 137 |
1879603 | 1879603 | 2021-11-03 | Branch | Michigan | 26023 | 7528 | 137 |
1820003 | 1820003 | 2021-10-16 | Hot Spring | Arkansas | 5059 | 7528 | 105 |
1778379 | 1778379 | 2021-10-03 | Marshall | Indiana | 18099 | 7528 | 133 |
1775129 | 1775129 | 2021-10-02 | Marshall | Indiana | 18099 | 7528 | 133 |
1771879 | 1771879 | 2021-10-01 | Marshall | Indiana | 18099 | 7528 | 133 |
1762139 | 1762139 | 2021-09-28 | Noble | Indiana | 18113 | 7528 | 104 |
1736164 | 1736164 | 2021-09-20 | Shelby | Indiana | 18145 | 7528 | 119 |
1725373 | 1725373 | 2021-09-16 | Harrisonburg city | Virginia | 51660 | 7528 | 96 |
1604203 | 1604203 | 2021-08-10 | Wilkes | North Carolina | 37193 | 7528 | 118 |
1541937 | 1541937 | 2021-07-22 | Lauderdale | Mississippi | 28075 | 7528 | 243 |
1425903 | 1425903 | 2021-06-16 | Crawford | Pennsylvania | 42039 | 7528 | 153 |
1422656 | 1422656 | 2021-06-15 | Crawford | Pennsylvania | 42039 | 7528 | 153 |
1410291 | 1410291 | 2021-06-11 | Tooele | Utah | 49045 | 7528 | 44 |
1398449 | 1398449 | 2021-06-08 | Wayne | Indiana | 18177 | 7528 | 205 |
1378885 | 1378885 | 2021-06-02 | Williamson | Illinois | 17199 | 7528 | 146 |
1379481 | 1379481 | 2021-06-02 | Midland | Michigan | 26111 | 7528 | 90 |
1348024 | 1348024 | 2021-05-23 | Lawrence | Pennsylvania | 42073 | 7528 | 210 |
1261820 | 1261820 | 2021-04-27 | Rockdale | Georgia | 13247 | 7528 | 171 |
1032406 | 1032406 | 2021-02-15 | Cascade | Montana | 30013 | 7528 | 149 |
933457 | 933457 | 2021-01-16 | Lauderdale | Alabama | 1077 | 7528 | 83 |
629832 | 629832 | 2020-10-14 | Hinds | Mississippi | 28049 | 7528 | 168 |
617022 | 617022 | 2020-10-10 | St. Louis city | Missouri | 29510 | 7528 | 217 |
580002 | 580002 | 2020-09-29 | Sonoma | California | 6097 | 7528 | 122 |
537499 | 537499 | 2020-09-15 | Snohomish | Washington | 53061 | 7528 | 219 |
512341 | 512341 | 2020-09-08 | Canyon | Idaho | 16027 | 7528 | 85 |
376337 | 376337 | 2020-07-28 | Mobile | Alabama | 1097 | 7528 | 182 |
136511 | 136511 | 2020-05-12 | Hartford | Connecticut | 9003 | 7528 | 931 |
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);