ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 13510 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- California 5
- Pennsylvania 4
- Wisconsin 4
- Texas 3
- Arkansas 2
- Georgia 2
- New Mexico 2
- Iowa 1
- Minnesota 1
- North Dakota 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463965 | 2463965 | 2022-05-02 | San Benito | California | 6069 | 13510 | 98 |
2460709 | 2460709 | 2022-05-01 | San Benito | California | 6069 | 13510 | 98 |
2457453 | 2457453 | 2022-04-30 | San Benito | California | 6069 | 13510 | 98 |
2454197 | 2454197 | 2022-04-29 | San Benito | California | 6069 | 13510 | 98 |
2258717 | 2258717 | 2022-02-27 | Waupaca | Wisconsin | 55135 | 13510 | 246 |
2255466 | 2255466 | 2022-02-26 | Waupaca | Wisconsin | 55135 | 13510 | 246 |
2252215 | 2252215 | 2022-02-25 | Waupaca | Wisconsin | 55135 | 13510 | 246 |
2131007 | 2131007 | 2022-01-19 | Guaynabo | Puerto Rico | 72061 | 13510 | |
2010660 | 2010660 | 2021-12-13 | Lawrence | Pennsylvania | 42073 | 13510 | 318 |
1912867 | 1912867 | 2021-11-13 | Grand Forks | North Dakota | 38035 | 13510 | 93 |
1907779 | 1907779 | 2021-11-12 | White | Arkansas | 5145 | 13510 | 202 |
1851414 | 1851414 | 2021-10-25 | Mercer | Pennsylvania | 42085 | 13510 | 322 |
1738023 | 1738023 | 2021-09-20 | Bastrop | Texas | 48021 | 13510 | 140 |
1734773 | 1734773 | 2021-09-19 | Bastrop | Texas | 48021 | 13510 | 140 |
1731523 | 1731523 | 2021-09-18 | Bastrop | Texas | 48021 | 13510 | 140 |
1437431 | 1437431 | 2021-06-20 | Dubuque | Iowa | 19061 | 13510 | 211 |
1425890 | 1425890 | 2021-06-16 | Blair | Pennsylvania | 42013 | 13510 | 340 |
1422643 | 1422643 | 2021-06-15 | Blair | Pennsylvania | 42013 | 13510 | 340 |
1326366 | 1326366 | 2021-05-17 | Craighead | Arkansas | 5031 | 13510 | 181 |
1216088 | 1216088 | 2021-04-13 | Yolo | California | 6113 | 13510 | 199 |
1112328 | 1112328 | 2021-03-12 | Bartow | Georgia | 13015 | 13510 | 202 |
1071568 | 1071568 | 2021-02-27 | San Juan | New Mexico | 35045 | 13510 | 433 |
1068323 | 1068323 | 2021-02-26 | San Juan | New Mexico | 35045 | 13510 | 431 |
1056715 | 1056715 | 2021-02-22 | Sheboygan | Wisconsin | 55117 | 13510 | 134 |
1013734 | 1013734 | 2021-02-09 | Berkeley | South Carolina | 45015 | 13510 | 155 |
959808 | 959808 | 2021-01-24 | Columbia | Georgia | 13073 | 13510 | 133 |
708811 | 708811 | 2020-11-07 | Hamilton | Tennessee | 47065 | 13510 | 117 |
652501 | 652501 | 2020-10-21 | Ramsey | Minnesota | 27123 | 13510 | 352 |
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);