ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where county = "Mendocino", deaths = 21 and fips = 6045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
712951 | 712951 | 2020-11-09 | Mendocino | California | 6045 | 1238 | 21 |
709707 | 709707 | 2020-11-08 | Mendocino | California | 6045 | 1231 | 21 |
706463 | 706463 | 2020-11-07 | Mendocino | California | 6045 | 1228 | 21 |
703220 | 703220 | 2020-11-06 | Mendocino | California | 6045 | 1216 | 21 |
699977 | 699977 | 2020-11-05 | Mendocino | California | 6045 | 1213 | 21 |
696733 | 696733 | 2020-11-04 | Mendocino | California | 6045 | 1193 | 21 |
693491 | 693491 | 2020-11-03 | Mendocino | California | 6045 | 1188 | 21 |
690248 | 690248 | 2020-11-02 | Mendocino | California | 6045 | 1179 | 21 |
687003 | 687003 | 2020-11-01 | Mendocino | California | 6045 | 1176 | 21 |
683759 | 683759 | 2020-10-31 | Mendocino | California | 6045 | 1165 | 21 |
680516 | 680516 | 2020-10-30 | Mendocino | California | 6045 | 1165 | 21 |
677273 | 677273 | 2020-10-29 | Mendocino | California | 6045 | 1156 | 21 |
674030 | 674030 | 2020-10-28 | Mendocino | California | 6045 | 1156 | 21 |
670788 | 670788 | 2020-10-27 | Mendocino | California | 6045 | 1142 | 21 |
667545 | 667545 | 2020-10-26 | Mendocino | California | 6045 | 1136 | 21 |
664300 | 664300 | 2020-10-25 | Mendocino | California | 6045 | 1129 | 21 |
661056 | 661056 | 2020-10-24 | Mendocino | California | 6045 | 1127 | 21 |
657812 | 657812 | 2020-10-23 | Mendocino | California | 6045 | 1124 | 21 |
654567 | 654567 | 2020-10-22 | Mendocino | California | 6045 | 1121 | 21 |
651322 | 651322 | 2020-10-21 | Mendocino | California | 6045 | 1118 | 21 |
648078 | 648078 | 2020-10-20 | Mendocino | California | 6045 | 1111 | 21 |
644833 | 644833 | 2020-10-19 | Mendocino | California | 6045 | 1104 | 21 |
641585 | 641585 | 2020-10-18 | Mendocino | California | 6045 | 1103 | 21 |
638338 | 638338 | 2020-10-17 | Mendocino | California | 6045 | 1089 | 21 |
635093 | 635093 | 2020-10-16 | Mendocino | California | 6045 | 1080 | 21 |
631847 | 631847 | 2020-10-15 | Mendocino | California | 6045 | 1077 | 21 |
628603 | 628603 | 2020-10-14 | Mendocino | California | 6045 | 1063 | 21 |
625360 | 625360 | 2020-10-13 | Mendocino | California | 6045 | 1055 | 21 |
622117 | 622117 | 2020-10-12 | Mendocino | California | 6045 | 1050 | 21 |
618874 | 618874 | 2020-10-11 | Mendocino | California | 6045 | 1045 | 21 |
615632 | 615632 | 2020-10-10 | Mendocino | California | 6045 | 1042 | 21 |
612391 | 612391 | 2020-10-09 | Mendocino | California | 6045 | 1035 | 21 |
609149 | 609149 | 2020-10-08 | Mendocino | California | 6045 | 1030 | 21 |
605906 | 605906 | 2020-10-07 | Mendocino | California | 6045 | 1025 | 21 |
602664 | 602664 | 2020-10-06 | Mendocino | California | 6045 | 1021 | 21 |
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);