ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where county = "Del Norte", deaths = 6 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1209544 | 1209544 | 2021-04-11 | Del Norte | California | 6015 | 1245 | 6 |
1206295 | 1206295 | 2021-04-10 | Del Norte | California | 6015 | 1245 | 6 |
1203047 | 1203047 | 2021-04-09 | Del Norte | California | 6015 | 1245 | 6 |
1199799 | 1199799 | 2021-04-08 | Del Norte | California | 6015 | 1239 | 6 |
1196550 | 1196550 | 2021-04-07 | Del Norte | California | 6015 | 1232 | 6 |
1193302 | 1193302 | 2021-04-06 | Del Norte | California | 6015 | 1230 | 6 |
1190052 | 1190052 | 2021-04-05 | Del Norte | California | 6015 | 1229 | 6 |
1186805 | 1186805 | 2021-04-04 | Del Norte | California | 6015 | 1218 | 6 |
1183558 | 1183558 | 2021-04-03 | Del Norte | California | 6015 | 1218 | 6 |
1180311 | 1180311 | 2021-04-02 | Del Norte | California | 6015 | 1213 | 6 |
1177064 | 1177064 | 2021-04-01 | Del Norte | California | 6015 | 1197 | 6 |
1173817 | 1173817 | 2021-03-31 | Del Norte | California | 6015 | 1163 | 6 |
1170570 | 1170570 | 2021-03-30 | Del Norte | California | 6015 | 1149 | 6 |
1167322 | 1167322 | 2021-03-29 | Del Norte | California | 6015 | 1138 | 6 |
1164074 | 1164074 | 2021-03-28 | Del Norte | California | 6015 | 1125 | 6 |
1160826 | 1160826 | 2021-03-27 | Del Norte | California | 6015 | 1125 | 6 |
1157578 | 1157578 | 2021-03-26 | Del Norte | California | 6015 | 1125 | 6 |
1154331 | 1154331 | 2021-03-25 | Del Norte | California | 6015 | 1120 | 6 |
1151084 | 1151084 | 2021-03-24 | Del Norte | California | 6015 | 1113 | 6 |
1147837 | 1147837 | 2021-03-23 | Del Norte | California | 6015 | 1107 | 6 |
1144590 | 1144590 | 2021-03-22 | Del Norte | California | 6015 | 1103 | 6 |
1141343 | 1141343 | 2021-03-21 | Del Norte | California | 6015 | 1095 | 6 |
1138097 | 1138097 | 2021-03-20 | Del Norte | California | 6015 | 1095 | 6 |
1134851 | 1134851 | 2021-03-19 | Del Norte | California | 6015 | 1095 | 6 |
1131604 | 1131604 | 2021-03-18 | Del Norte | California | 6015 | 1090 | 6 |
1128356 | 1128356 | 2021-03-17 | Del Norte | California | 6015 | 1078 | 6 |
1125110 | 1125110 | 2021-03-16 | Del Norte | California | 6015 | 1069 | 6 |
1121864 | 1121864 | 2021-03-15 | Del Norte | California | 6015 | 1068 | 6 |
1118617 | 1118617 | 2021-03-14 | Del Norte | California | 6015 | 1056 | 6 |
1115370 | 1115370 | 2021-03-13 | Del Norte | California | 6015 | 1056 | 6 |
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);