ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 6001 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- …
state 1
- California 804
fips 1
- 6001 · 804 ✖
county 1
- Alameda 804
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
400 | 400 | 2020-03-01 | Alameda | California | 6001 | 1 | 0 |
427 | 427 | 2020-03-02 | Alameda | California | 6001 | 1 | 0 |
460 | 460 | 2020-03-03 | Alameda | California | 6001 | 2 | 0 |
495 | 495 | 2020-03-04 | Alameda | California | 6001 | 2 | 0 |
534 | 534 | 2020-03-05 | Alameda | California | 6001 | 2 | 0 |
584 | 584 | 2020-03-06 | Alameda | California | 6001 | 3 | 0 |
658 | 658 | 2020-03-07 | Alameda | California | 6001 | 3 | 0 |
753 | 753 | 2020-03-08 | Alameda | California | 6001 | 3 | 0 |
867 | 867 | 2020-03-09 | Alameda | California | 6001 | 24 | 0 |
999 | 999 | 2020-03-10 | Alameda | California | 6001 | 25 | 0 |
1165 | 1165 | 2020-03-11 | Alameda | California | 6001 | 25 | 0 |
1371 | 1371 | 2020-03-12 | Alameda | California | 6001 | 29 | 0 |
1631 | 1631 | 2020-03-13 | Alameda | California | 6001 | 29 | 0 |
1948 | 1948 | 2020-03-14 | Alameda | California | 6001 | 29 | 0 |
2327 | 2327 | 2020-03-15 | Alameda | California | 6001 | 37 | 0 |
2761 | 2761 | 2020-03-16 | Alameda | California | 6001 | 40 | 0 |
3241 | 3241 | 2020-03-17 | Alameda | California | 6001 | 49 | 0 |
3794 | 3794 | 2020-03-18 | Alameda | California | 6001 | 53 | 0 |
4454 | 4454 | 2020-03-19 | Alameda | California | 6001 | 57 | 0 |
5227 | 5227 | 2020-03-20 | Alameda | California | 6001 | 67 | 0 |
6146 | 6146 | 2020-03-21 | Alameda | California | 6001 | 87 | 0 |
7180 | 7180 | 2020-03-22 | Alameda | California | 6001 | 127 | 0 |
8323 | 8323 | 2020-03-23 | Alameda | California | 6001 | 139 | 1 |
9563 | 9563 | 2020-03-24 | Alameda | California | 6001 | 151 | 2 |
10934 | 10934 | 2020-03-25 | Alameda | California | 6001 | 156 | 2 |
12479 | 12479 | 2020-03-26 | Alameda | California | 6001 | 199 | 4 |
14143 | 14143 | 2020-03-27 | Alameda | California | 6001 | 241 | 4 |
15924 | 15924 | 2020-03-28 | Alameda | California | 6001 | 277 | 6 |
17813 | 17813 | 2020-03-29 | Alameda | California | 6001 | 291 | 6 |
19789 | 19789 | 2020-03-30 | Alameda | California | 6001 | 304 | 7 |
21863 | 21863 | 2020-03-31 | Alameda | California | 6001 | 334 | 7 |
24021 | 24021 | 2020-04-01 | Alameda | California | 6001 | 380 | 8 |
26249 | 26249 | 2020-04-02 | Alameda | California | 6001 | 417 | 9 |
28548 | 28548 | 2020-04-03 | Alameda | California | 6001 | 464 | 12 |
30906 | 30906 | 2020-04-04 | Alameda | California | 6001 | 464 | 12 |
33312 | 33312 | 2020-04-05 | Alameda | California | 6001 | 587 | 12 |
35756 | 35756 | 2020-04-06 | Alameda | California | 6001 | 609 | 13 |
38245 | 38245 | 2020-04-07 | Alameda | California | 6001 | 655 | 15 |
40789 | 40789 | 2020-04-08 | Alameda | California | 6001 | 695 | 16 |
43361 | 43361 | 2020-04-09 | Alameda | California | 6001 | 734 | 17 |
45961 | 45961 | 2020-04-10 | Alameda | California | 6001 | 766 | 20 |
48591 | 48591 | 2020-04-11 | Alameda | California | 6001 | 827 | 21 |
51253 | 51253 | 2020-04-12 | Alameda | California | 6001 | 864 | 23 |
53932 | 53932 | 2020-04-13 | Alameda | California | 6001 | 907 | 23 |
56624 | 56624 | 2020-04-14 | Alameda | California | 6001 | 908 | 23 |
59332 | 59332 | 2020-04-15 | Alameda | California | 6001 | 983 | 36 |
62051 | 62051 | 2020-04-16 | Alameda | California | 6001 | 1069 | 40 |
64784 | 64784 | 2020-04-17 | Alameda | California | 6001 | 1084 | 40 |
67532 | 67532 | 2020-04-18 | Alameda | California | 6001 | 1135 | 41 |
70294 | 70294 | 2020-04-19 | Alameda | California | 6001 | 1185 | 42 |
73063 | 73063 | 2020-04-20 | Alameda | California | 6001 | 1212 | 42 |
75839 | 75839 | 2020-04-21 | Alameda | California | 6001 | 1260 | 43 |
78623 | 78623 | 2020-04-22 | Alameda | California | 6001 | 1260 | 43 |
81417 | 81417 | 2020-04-23 | Alameda | California | 6001 | 1350 | 48 |
84217 | 84217 | 2020-04-24 | Alameda | California | 6001 | 1422 | 48 |
87025 | 87025 | 2020-04-25 | Alameda | California | 6001 | 1458 | 52 |
89842 | 89842 | 2020-04-26 | Alameda | California | 6001 | 1489 | 52 |
92660 | 92660 | 2020-04-27 | Alameda | California | 6001 | 1519 | 56 |
95491 | 95491 | 2020-04-28 | Alameda | California | 6001 | 1554 | 59 |
98336 | 98336 | 2020-04-29 | Alameda | California | 6001 | 1589 | 59 |
101186 | 101186 | 2020-04-30 | Alameda | California | 6001 | 1624 | 63 |
104041 | 104041 | 2020-05-01 | Alameda | California | 6001 | 1657 | 63 |
106906 | 106906 | 2020-05-02 | Alameda | California | 6001 | 1726 | 63 |
109775 | 109775 | 2020-05-03 | Alameda | California | 6001 | 1770 | 63 |
112650 | 112650 | 2020-05-04 | Alameda | California | 6001 | 1797 | 65 |
115533 | 115533 | 2020-05-05 | Alameda | California | 6001 | 1830 | 66 |
118492 | 118492 | 2020-05-06 | Alameda | California | 6001 | 1884 | 69 |
121459 | 121459 | 2020-05-07 | Alameda | California | 6001 | 1938 | 69 |
124439 | 124439 | 2020-05-08 | Alameda | California | 6001 | 1982 | 70 |
127424 | 127424 | 2020-05-09 | Alameda | California | 6001 | 2044 | 72 |
130414 | 130414 | 2020-05-10 | Alameda | California | 6001 | 2085 | 75 |
133404 | 133404 | 2020-05-11 | Alameda | California | 6001 | 2122 | 75 |
136394 | 136394 | 2020-05-12 | Alameda | California | 6001 | 2154 | 75 |
139385 | 139385 | 2020-05-13 | Alameda | California | 6001 | 2199 | 80 |
142381 | 142381 | 2020-05-14 | Alameda | California | 6001 | 2202 | 80 |
145380 | 145380 | 2020-05-15 | Alameda | California | 6001 | 2321 | 84 |
148384 | 148384 | 2020-05-16 | Alameda | California | 6001 | 2372 | 85 |
151393 | 151393 | 2020-05-17 | Alameda | California | 6001 | 2413 | 85 |
154405 | 154405 | 2020-05-18 | Alameda | California | 6001 | 2478 | 85 |
157421 | 157421 | 2020-05-19 | Alameda | California | 6001 | 2543 | 88 |
160447 | 160447 | 2020-05-20 | Alameda | California | 6001 | 2581 | 88 |
163475 | 163475 | 2020-05-21 | Alameda | California | 6001 | 2630 | 90 |
166507 | 166507 | 2020-05-22 | Alameda | California | 6001 | 2729 | 90 |
169543 | 169543 | 2020-05-23 | Alameda | California | 6001 | 2788 | 92 |
172584 | 172584 | 2020-05-24 | Alameda | California | 6001 | 2868 | 93 |
175628 | 175628 | 2020-05-25 | Alameda | California | 6001 | 2895 | 93 |
178672 | 178672 | 2020-05-26 | Alameda | California | 6001 | 3007 | 93 |
181716 | 181716 | 2020-05-27 | Alameda | California | 6001 | 3070 | 97 |
184770 | 184770 | 2020-05-28 | Alameda | California | 6001 | 3118 | 97 |
187826 | 187826 | 2020-05-29 | Alameda | California | 6001 | 3216 | 102 |
190891 | 190891 | 2020-05-30 | Alameda | California | 6001 | 3310 | 103 |
193958 | 193958 | 2020-05-31 | Alameda | California | 6001 | 3411 | 103 |
197028 | 197028 | 2020-06-01 | Alameda | California | 6001 | 3491 | 104 |
200101 | 200101 | 2020-06-02 | Alameda | California | 6001 | 3536 | 104 |
203177 | 203177 | 2020-06-03 | Alameda | California | 6001 | 3569 | 104 |
206257 | 206257 | 2020-06-04 | Alameda | California | 6001 | 3662 | 104 |
209338 | 209338 | 2020-06-05 | Alameda | California | 6001 | 3746 | 104 |
212423 | 212423 | 2020-06-06 | Alameda | California | 6001 | 3826 | 104 |
215510 | 215510 | 2020-06-07 | Alameda | California | 6001 | 3895 | 104 |
218601 | 218601 | 2020-06-08 | Alameda | California | 6001 | 3966 | 104 |
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);