ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6041 and state = "California" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-02-26 1
- 2020-02-27 1
- 2020-02-28 1
- 2020-02-29 1
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- …
state 1
- California · 808 ✖
fips 1
- 6041 · 808 ✖
county 1
- Marin 808
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
318 | 318 | 2020-02-26 | Marin | California | 6041 | 1 | 0 |
338 | 338 | 2020-02-27 | Marin | California | 6041 | 1 | 0 |
358 | 358 | 2020-02-28 | Marin | California | 6041 | 1 | 0 |
380 | 380 | 2020-02-29 | Marin | California | 6041 | 1 | 0 |
403 | 403 | 2020-03-01 | Marin | California | 6041 | 1 | 0 |
430 | 430 | 2020-03-02 | Marin | California | 6041 | 1 | 0 |
464 | 464 | 2020-03-03 | Marin | California | 6041 | 1 | 0 |
499 | 499 | 2020-03-04 | Marin | California | 6041 | 1 | 0 |
538 | 538 | 2020-03-05 | Marin | California | 6041 | 1 | 0 |
588 | 588 | 2020-03-06 | Marin | California | 6041 | 1 | 0 |
664 | 664 | 2020-03-07 | Marin | California | 6041 | 1 | 0 |
759 | 759 | 2020-03-08 | Marin | California | 6041 | 1 | 0 |
873 | 873 | 2020-03-09 | Marin | California | 6041 | 2 | 0 |
1005 | 1005 | 2020-03-10 | Marin | California | 6041 | 2 | 0 |
1171 | 1171 | 2020-03-11 | Marin | California | 6041 | 4 | 0 |
1377 | 1377 | 2020-03-12 | Marin | California | 6041 | 4 | 0 |
1637 | 1637 | 2020-03-13 | Marin | California | 6041 | 4 | 0 |
1954 | 1954 | 2020-03-14 | Marin | California | 6041 | 4 | 0 |
2333 | 2333 | 2020-03-15 | Marin | California | 6041 | 4 | 0 |
2767 | 2767 | 2020-03-16 | Marin | California | 6041 | 4 | 0 |
3248 | 3248 | 2020-03-17 | Marin | California | 6041 | 4 | 0 |
3801 | 3801 | 2020-03-18 | Marin | California | 6041 | 16 | 0 |
4461 | 4461 | 2020-03-19 | Marin | California | 6041 | 25 | 0 |
5236 | 5236 | 2020-03-20 | Marin | California | 6041 | 38 | 0 |
6157 | 6157 | 2020-03-21 | Marin | California | 6041 | 38 | 0 |
7191 | 7191 | 2020-03-22 | Marin | California | 6041 | 38 | 0 |
8334 | 8334 | 2020-03-23 | Marin | California | 6041 | 47 | 0 |
9575 | 9575 | 2020-03-24 | Marin | California | 6041 | 53 | 0 |
10947 | 10947 | 2020-03-25 | Marin | California | 6041 | 53 | 0 |
12492 | 12492 | 2020-03-26 | Marin | California | 6041 | 65 | 0 |
14158 | 14158 | 2020-03-27 | Marin | California | 6041 | 69 | 1 |
15940 | 15940 | 2020-03-28 | Marin | California | 6041 | 74 | 1 |
17829 | 17829 | 2020-03-29 | Marin | California | 6041 | 93 | 1 |
19806 | 19806 | 2020-03-30 | Marin | California | 6041 | 99 | 1 |
21880 | 21880 | 2020-03-31 | Marin | California | 6041 | 102 | 4 |
24038 | 24038 | 2020-04-01 | Marin | California | 6041 | 108 | 4 |
26267 | 26267 | 2020-04-02 | Marin | California | 6041 | 118 | 6 |
28566 | 28566 | 2020-04-03 | Marin | California | 6041 | 131 | 6 |
30924 | 30924 | 2020-04-04 | Marin | California | 6041 | 137 | 7 |
33330 | 33330 | 2020-04-05 | Marin | California | 6041 | 141 | 7 |
35775 | 35775 | 2020-04-06 | Marin | California | 6041 | 143 | 9 |
38264 | 38264 | 2020-04-07 | Marin | California | 6041 | 148 | 10 |
40808 | 40808 | 2020-04-08 | Marin | California | 6041 | 149 | 10 |
43380 | 43380 | 2020-04-09 | Marin | California | 6041 | 154 | 10 |
45980 | 45980 | 2020-04-10 | Marin | California | 6041 | 154 | 10 |
48610 | 48610 | 2020-04-11 | Marin | California | 6041 | 153 | 10 |
51272 | 51272 | 2020-04-12 | Marin | California | 6041 | 164 | 10 |
53951 | 53951 | 2020-04-13 | Marin | California | 6041 | 170 | 10 |
56643 | 56643 | 2020-04-14 | Marin | California | 6041 | 171 | 10 |
59351 | 59351 | 2020-04-15 | Marin | California | 6041 | 184 | 10 |
62070 | 62070 | 2020-04-16 | Marin | California | 6041 | 187 | 10 |
64803 | 64803 | 2020-04-17 | Marin | California | 6041 | 187 | 10 |
67551 | 67551 | 2020-04-18 | Marin | California | 6041 | 189 | 10 |
70313 | 70313 | 2020-04-19 | Marin | California | 6041 | 195 | 10 |
73082 | 73082 | 2020-04-20 | Marin | California | 6041 | 199 | 10 |
75858 | 75858 | 2020-04-21 | Marin | California | 6041 | 200 | 10 |
78642 | 78642 | 2020-04-22 | Marin | California | 6041 | 203 | 11 |
81436 | 81436 | 2020-04-23 | Marin | California | 6041 | 209 | 11 |
84236 | 84236 | 2020-04-24 | Marin | California | 6041 | 212 | 12 |
87044 | 87044 | 2020-04-25 | Marin | California | 6041 | 223 | 12 |
89861 | 89861 | 2020-04-26 | Marin | California | 6041 | 224 | 12 |
92679 | 92679 | 2020-04-27 | Marin | California | 6041 | 225 | 12 |
95510 | 95510 | 2020-04-28 | Marin | California | 6041 | 227 | 12 |
98355 | 98355 | 2020-04-29 | Marin | California | 6041 | 235 | 13 |
101205 | 101205 | 2020-04-30 | Marin | California | 6041 | 237 | 13 |
104060 | 104060 | 2020-05-01 | Marin | California | 6041 | 240 | 13 |
106925 | 106925 | 2020-05-02 | Marin | California | 6041 | 242 | 13 |
109794 | 109794 | 2020-05-03 | Marin | California | 6041 | 243 | 13 |
112669 | 112669 | 2020-05-04 | Marin | California | 6041 | 243 | 13 |
115552 | 115552 | 2020-05-05 | Marin | California | 6041 | 244 | 13 |
118511 | 118511 | 2020-05-06 | Marin | California | 6041 | 244 | 14 |
121478 | 121478 | 2020-05-07 | Marin | California | 6041 | 244 | 14 |
124458 | 124458 | 2020-05-08 | Marin | California | 6041 | 252 | 14 |
127443 | 127443 | 2020-05-09 | Marin | California | 6041 | 257 | 14 |
130433 | 130433 | 2020-05-10 | Marin | California | 6041 | 261 | 14 |
133423 | 133423 | 2020-05-11 | Marin | California | 6041 | 267 | 14 |
136413 | 136413 | 2020-05-12 | Marin | California | 6041 | 271 | 14 |
139404 | 139404 | 2020-05-13 | Marin | California | 6041 | 274 | 14 |
142400 | 142400 | 2020-05-14 | Marin | California | 6041 | 278 | 14 |
145399 | 145399 | 2020-05-15 | Marin | California | 6041 | 283 | 14 |
148403 | 148403 | 2020-05-16 | Marin | California | 6041 | 299 | 14 |
151412 | 151412 | 2020-05-17 | Marin | California | 6041 | 317 | 14 |
154424 | 154424 | 2020-05-18 | Marin | California | 6041 | 329 | 14 |
157440 | 157440 | 2020-05-19 | Marin | California | 6041 | 336 | 14 |
160466 | 160466 | 2020-05-20 | Marin | California | 6041 | 343 | 14 |
163494 | 163494 | 2020-05-21 | Marin | California | 6041 | 352 | 14 |
166526 | 166526 | 2020-05-22 | Marin | California | 6041 | 369 | 14 |
169563 | 169563 | 2020-05-23 | Marin | California | 6041 | 388 | 14 |
172604 | 172604 | 2020-05-24 | Marin | California | 6041 | 403 | 14 |
175648 | 175648 | 2020-05-25 | Marin | California | 6041 | 417 | 14 |
178692 | 178692 | 2020-05-26 | Marin | California | 6041 | 420 | 14 |
181736 | 181736 | 2020-05-27 | Marin | California | 6041 | 430 | 14 |
184790 | 184790 | 2020-05-28 | Marin | California | 6041 | 439 | 14 |
187846 | 187846 | 2020-05-29 | Marin | California | 6041 | 450 | 14 |
190911 | 190911 | 2020-05-30 | Marin | California | 6041 | 466 | 14 |
193978 | 193978 | 2020-05-31 | Marin | California | 6041 | 483 | 14 |
197048 | 197048 | 2020-06-01 | Marin | California | 6041 | 501 | 15 |
200121 | 200121 | 2020-06-02 | Marin | California | 6041 | 506 | 17 |
203197 | 203197 | 2020-06-03 | Marin | California | 6041 | 525 | 17 |
206277 | 206277 | 2020-06-04 | Marin | California | 6041 | 530 | 17 |
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);