ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 12328 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Louisiana 8
- Pennsylvania 7
- North Carolina 4
- Illinois 3
- New York 2
- Ohio 2
- South Carolina 2
- California 1
- Indiana 1
- New Hampshire 1
- Oklahoma 1
- Puerto Rico 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492116 | 2492116 | 2022-05-10 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2488858 | 2488858 | 2022-05-09 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2485601 | 2485601 | 2022-05-08 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2482343 | 2482343 | 2022-05-07 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2479085 | 2479085 | 2022-05-06 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2475827 | 2475827 | 2022-05-05 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2472570 | 2472570 | 2022-05-04 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2401834 | 2401834 | 2022-04-12 | Polk | Wisconsin | 55095 | 12328 | 122 |
2371338 | 2371338 | 2022-04-03 | Watauga | North Carolina | 37189 | 12328 | 58 |
2368085 | 2368085 | 2022-04-02 | Watauga | North Carolina | 37189 | 12328 | 58 |
2364832 | 2364832 | 2022-04-01 | Watauga | North Carolina | 37189 | 12328 | 58 |
2353822 | 2353822 | 2022-03-29 | Marshall | Indiana | 18099 | 12328 | 195 |
2209129 | 2209129 | 2022-02-12 | Toa Baja | Puerto Rico | 72137 | 12328 | |
2166572 | 2166572 | 2022-01-30 | Seneca | Ohio | 39147 | 12328 | 210 |
2156454 | 2156454 | 2022-01-27 | Cheshire | New Hampshire | 33005 | 12328 | 91 |
1914796 | 1914796 | 2021-11-14 | Williamson | Illinois | 17199 | 12328 | 193 |
1911546 | 1911546 | 2021-11-13 | Williamson | Illinois | 17199 | 12328 | 193 |
1908297 | 1908297 | 2021-11-12 | Williamson | Illinois | 17199 | 12328 | 193 |
1812002 | 1812002 | 2021-10-13 | Putnam | New York | 36079 | 12328 | 96 |
1777146 | 1777146 | 2021-10-02 | Liberty | Texas | 48291 | 12328 | 316 |
1656089 | 1656089 | 2021-08-26 | Brunswick | North Carolina | 37019 | 12328 | 176 |
1333894 | 1333894 | 2021-05-19 | Rapides | Louisiana | 22079 | 12328 | 317 |
1324117 | 1324117 | 2021-05-16 | Ascension | Louisiana | 22005 | 12328 | 164 |
1320871 | 1320871 | 2021-05-15 | Ascension | Louisiana | 22005 | 12328 | 164 |
1317624 | 1317624 | 2021-05-14 | Ascension | Louisiana | 22005 | 12328 | 164 |
1187785 | 1187785 | 2021-04-04 | Tangipahoa | Louisiana | 22105 | 12328 | 286 |
1184538 | 1184538 | 2021-04-03 | Tangipahoa | Louisiana | 22105 | 12328 | 286 |
1181291 | 1181291 | 2021-04-02 | Tangipahoa | Louisiana | 22105 | 12328 | 286 |
1178044 | 1178044 | 2021-04-01 | Tangipahoa | Louisiana | 22105 | 12328 | 286 |
922889 | 922889 | 2021-01-12 | Pickens | South Carolina | 45077 | 12328 | 175 |
692154 | 692154 | 2020-11-02 | Montgomery | Ohio | 39113 | 12328 | 190 |
550850 | 550850 | 2020-09-20 | Ventura | California | 6111 | 12328 | 143 |
498034 | 498034 | 2020-09-03 | Greenville | South Carolina | 45045 | 12328 | 266 |
455787 | 455787 | 2020-08-21 | Oklahoma | Oklahoma | 40109 | 12328 | 139 |
32196 | 32196 | 2020-04-04 | Suffolk | New York | 36103 | 12328 | 175 |
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);