ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 10317 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Louisiana 4
- North Carolina 3
- Puerto Rico 3
- Texas 3
- Georgia 2
- New York 2
- Alabama 1
- Arkansas 1
- Florida 1
- Illinois 1
- Indiana 1
- Minnesota 1
- Missouri 1
- New Mexico 1
- Ohio 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501158 | 2501158 | 2022-05-13 | Phelps | Missouri | 29161 | 10317 | 243 |
2439558 | 2439558 | 2022-04-24 | Columbia | New York | 36021 | 10317 | 140 |
2414061 | 2414061 | 2022-04-16 | Vega Baja | Puerto Rico | 72145 | 10317 | |
2410805 | 2410805 | 2022-04-15 | Vega Baja | Puerto Rico | 72145 | 10317 | |
2407549 | 2407549 | 2022-04-14 | Vega Baja | Puerto Rico | 72145 | 10317 | |
2133819 | 2133819 | 2022-01-20 | Chatham | North Carolina | 37037 | 10317 | 99 |
2011643 | 2011643 | 2021-12-14 | Jackson | Alabama | 1071 | 10317 | 199 |
1971282 | 1971282 | 2021-12-01 | Columbus | North Carolina | 37047 | 10317 | 230 |
1968043 | 1968043 | 2021-11-30 | Franklin | North Carolina | 37069 | 10317 | 64 |
1940233 | 1940233 | 2021-11-22 | Greene | Arkansas | 5055 | 10317 | 124 |
1942184 | 1942184 | 2021-11-22 | Geauga | Ohio | 39055 | 10317 | 171 |
1856121 | 1856121 | 2021-10-27 | Spalding | Georgia | 13255 | 10317 | 299 |
1801490 | 1801490 | 2021-10-10 | Acadia | Louisiana | 22001 | 10317 | 247 |
1798241 | 1798241 | 2021-10-09 | Acadia | Louisiana | 22001 | 10317 | 247 |
1794992 | 1794992 | 2021-10-08 | Acadia | Louisiana | 22001 | 10317 | 247 |
1769699 | 1769699 | 2021-09-30 | Eddy | New Mexico | 35015 | 10317 | 183 |
1643809 | 1643809 | 2021-08-22 | Angelina | Texas | 48005 | 10317 | 297 |
1640559 | 1640559 | 2021-08-21 | Angelina | Texas | 48005 | 10317 | 297 |
1637309 | 1637309 | 2021-08-20 | Angelina | Texas | 48005 | 10317 | 294 |
1213995 | 1213995 | 2021-04-12 | Sherburne | Minnesota | 27141 | 10317 | 79 |
1201491 | 1201491 | 2021-04-08 | Rensselaer | New York | 36083 | 10317 | 135 |
1070488 | 1070488 | 2021-02-27 | Monroe | Indiana | 18105 | 10317 | 165 |
963787 | 963787 | 2021-01-25 | Rapides | Louisiana | 22079 | 10317 | 244 |
888408 | 888408 | 2021-01-02 | Columbia | Georgia | 13073 | 10317 | 100 |
484949 | 484949 | 2020-08-30 | Delaware | Pennsylvania | 42045 | 10317 | 773 |
441026 | 441026 | 2020-08-17 | Escambia | Florida | 12033 | 10317 | 152 |
351244 | 351244 | 2020-07-20 | DuPage | Illinois | 17043 | 10317 | 498 |
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);