ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where county = "Washington", deaths = 54 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1159284 | 1159284 | 2021-03-26 | Washington | New York | 36115 | 2590 | 54 |
1156037 | 1156037 | 2021-03-25 | Washington | New York | 36115 | 2582 | 54 |
1152790 | 1152790 | 2021-03-24 | Washington | New York | 36115 | 2569 | 54 |
1149543 | 1149543 | 2021-03-23 | Washington | New York | 36115 | 2557 | 54 |
1146296 | 1146296 | 2021-03-22 | Washington | New York | 36115 | 2538 | 54 |
1143049 | 1143049 | 2021-03-21 | Washington | New York | 36115 | 2531 | 54 |
1139802 | 1139802 | 2021-03-20 | Washington | New York | 36115 | 2515 | 54 |
1136556 | 1136556 | 2021-03-19 | Washington | New York | 36115 | 2507 | 54 |
1133310 | 1133310 | 2021-03-18 | Washington | New York | 36115 | 2501 | 54 |
1130062 | 1130062 | 2021-03-17 | Washington | New York | 36115 | 2493 | 54 |
1126815 | 1126815 | 2021-03-16 | Washington | New York | 36115 | 2482 | 54 |
1123569 | 1123569 | 2021-03-15 | Washington | New York | 36115 | 2471 | 54 |
1120323 | 1120323 | 2021-03-14 | Washington | New York | 36115 | 2464 | 54 |
1117076 | 1117076 | 2021-03-13 | Washington | New York | 36115 | 2460 | 54 |
1113829 | 1113829 | 2021-03-12 | Washington | New York | 36115 | 2448 | 54 |
1110583 | 1110583 | 2021-03-11 | Washington | New York | 36115 | 2435 | 54 |
1107337 | 1107337 | 2021-03-10 | Washington | New York | 36115 | 2426 | 54 |
1104091 | 1104091 | 2021-03-09 | Washington | New York | 36115 | 2418 | 54 |
1100845 | 1100845 | 2021-03-08 | Washington | New York | 36115 | 2412 | 54 |
1097599 | 1097599 | 2021-03-07 | Washington | New York | 36115 | 2406 | 54 |
1094351 | 1094351 | 2021-03-06 | Washington | New York | 36115 | 2397 | 54 |
1091105 | 1091105 | 2021-03-05 | Washington | New York | 36115 | 2380 | 54 |
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);