ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Santa Barbara" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
78661 | 78661 | 2020-04-22 | Santa Barbara | California | 6083 | 440 | 5 |
75877 | 75877 | 2020-04-21 | Santa Barbara | California | 6083 | 429 | 5 |
73101 | 73101 | 2020-04-20 | Santa Barbara | California | 6083 | 416 | 4 |
70332 | 70332 | 2020-04-19 | Santa Barbara | California | 6083 | 394 | 4 |
67570 | 67570 | 2020-04-18 | Santa Barbara | California | 6083 | 385 | 4 |
64822 | 64822 | 2020-04-17 | Santa Barbara | California | 6083 | 373 | 3 |
62089 | 62089 | 2020-04-16 | Santa Barbara | California | 6083 | 354 | 3 |
59370 | 59370 | 2020-04-15 | Santa Barbara | California | 6083 | 334 | 2 |
56662 | 56662 | 2020-04-14 | Santa Barbara | California | 6083 | 313 | 2 |
53970 | 53970 | 2020-04-13 | Santa Barbara | California | 6083 | 284 | 2 |
51291 | 51291 | 2020-04-12 | Santa Barbara | California | 6083 | 267 | 2 |
48629 | 48629 | 2020-04-11 | Santa Barbara | California | 6083 | 264 | 2 |
45999 | 45999 | 2020-04-10 | Santa Barbara | California | 6083 | 260 | 2 |
43399 | 43399 | 2020-04-09 | Santa Barbara | California | 6083 | 243 | 2 |
40827 | 40827 | 2020-04-08 | Santa Barbara | California | 6083 | 228 | 2 |
38283 | 38283 | 2020-04-07 | Santa Barbara | California | 6083 | 218 | 2 |
35794 | 35794 | 2020-04-06 | Santa Barbara | California | 6083 | 192 | 2 |
33349 | 33349 | 2020-04-05 | Santa Barbara | California | 6083 | 174 | 2 |
30943 | 30943 | 2020-04-04 | Santa Barbara | California | 6083 | 168 | 1 |
28585 | 28585 | 2020-04-03 | Santa Barbara | California | 6083 | 152 | 1 |
26286 | 26286 | 2020-04-02 | Santa Barbara | California | 6083 | 139 | 1 |
24057 | 24057 | 2020-04-01 | Santa Barbara | California | 6083 | 111 | 0 |
21899 | 21899 | 2020-03-31 | Santa Barbara | California | 6083 | 99 | 0 |
19824 | 19824 | 2020-03-30 | Santa Barbara | California | 6083 | 88 | 0 |
17847 | 17847 | 2020-03-29 | Santa Barbara | California | 6083 | 68 | 0 |
15958 | 15958 | 2020-03-28 | Santa Barbara | California | 6083 | 64 | 0 |
14176 | 14176 | 2020-03-27 | Santa Barbara | California | 6083 | 47 | 0 |
12510 | 12510 | 2020-03-26 | Santa Barbara | California | 6083 | 32 | 0 |
10965 | 10965 | 2020-03-25 | Santa Barbara | California | 6083 | 26 | 0 |
9593 | 9593 | 2020-03-24 | Santa Barbara | California | 6083 | 24 | 0 |
8350 | 8350 | 2020-03-23 | Santa Barbara | California | 6083 | 18 | 0 |
7207 | 7207 | 2020-03-22 | Santa Barbara | California | 6083 | 18 | 0 |
6173 | 6173 | 2020-03-21 | Santa Barbara | California | 6083 | 17 | 0 |
5252 | 5252 | 2020-03-20 | Santa Barbara | California | 6083 | 9 | 0 |
4477 | 4477 | 2020-03-19 | Santa Barbara | California | 6083 | 8 | 0 |
3817 | 3817 | 2020-03-18 | Santa Barbara | California | 6083 | 2 | 0 |
3263 | 3263 | 2020-03-17 | Santa Barbara | California | 6083 | 2 | 0 |
2781 | 2781 | 2020-03-16 | Santa Barbara | California | 6083 | 1 | 0 |
2346 | 2346 | 2020-03-15 | Santa Barbara | California | 6083 | 1 | 0 |
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);