ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 6081 and state = "California" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-03-31 1
- …
state 1
- California · 803 ✖
fips 1
- 6081 · 803 ✖
county 1
- San Mateo 803
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
437 | 437 | 2020-03-02 | San Mateo | California | 6081 | 1 | 0 |
471 | 471 | 2020-03-03 | San Mateo | California | 6081 | 1 | 0 |
506 | 506 | 2020-03-04 | San Mateo | California | 6081 | 1 | 0 |
545 | 545 | 2020-03-05 | San Mateo | California | 6081 | 1 | 0 |
595 | 595 | 2020-03-06 | San Mateo | California | 6081 | 1 | 0 |
672 | 672 | 2020-03-07 | San Mateo | California | 6081 | 1 | 0 |
767 | 767 | 2020-03-08 | San Mateo | California | 6081 | 1 | 0 |
881 | 881 | 2020-03-09 | San Mateo | California | 6081 | 9 | 0 |
1014 | 1014 | 2020-03-10 | San Mateo | California | 6081 | 9 | 0 |
1180 | 1180 | 2020-03-11 | San Mateo | California | 6081 | 15 | 0 |
1386 | 1386 | 2020-03-12 | San Mateo | California | 6081 | 20 | 0 |
1647 | 1647 | 2020-03-13 | San Mateo | California | 6081 | 20 | 0 |
1965 | 1965 | 2020-03-14 | San Mateo | California | 6081 | 32 | 0 |
2345 | 2345 | 2020-03-15 | San Mateo | California | 6081 | 32 | 1 |
2780 | 2780 | 2020-03-16 | San Mateo | California | 6081 | 42 | 1 |
3262 | 3262 | 2020-03-17 | San Mateo | California | 6081 | 64 | 1 |
3816 | 3816 | 2020-03-18 | San Mateo | California | 6081 | 80 | 1 |
4476 | 4476 | 2020-03-19 | San Mateo | California | 6081 | 89 | 1 |
5251 | 5251 | 2020-03-20 | San Mateo | California | 6081 | 100 | 1 |
6172 | 6172 | 2020-03-21 | San Mateo | California | 6081 | 110 | 1 |
7206 | 7206 | 2020-03-22 | San Mateo | California | 6081 | 117 | 1 |
8349 | 8349 | 2020-03-23 | San Mateo | California | 6081 | 142 | 1 |
9592 | 9592 | 2020-03-24 | San Mateo | California | 6081 | 161 | 1 |
10964 | 10964 | 2020-03-25 | San Mateo | California | 6081 | 165 | 5 |
12509 | 12509 | 2020-03-26 | San Mateo | California | 6081 | 195 | 5 |
14175 | 14175 | 2020-03-27 | San Mateo | California | 6081 | 239 | 6 |
15957 | 15957 | 2020-03-28 | San Mateo | California | 6081 | 274 | 6 |
17846 | 17846 | 2020-03-29 | San Mateo | California | 6081 | 277 | 6 |
19823 | 19823 | 2020-03-30 | San Mateo | California | 6081 | 309 | 6 |
21898 | 21898 | 2020-03-31 | San Mateo | California | 6081 | 309 | 10 |
24056 | 24056 | 2020-04-01 | San Mateo | California | 6081 | 388 | 10 |
26285 | 26285 | 2020-04-02 | San Mateo | California | 6081 | 453 | 10 |
28584 | 28584 | 2020-04-03 | San Mateo | California | 6081 | 486 | 13 |
30942 | 30942 | 2020-04-04 | San Mateo | California | 6081 | 538 | 13 |
33348 | 33348 | 2020-04-05 | San Mateo | California | 6081 | 555 | 13 |
35793 | 35793 | 2020-04-06 | San Mateo | California | 6081 | 579 | 13 |
38282 | 38282 | 2020-04-07 | San Mateo | California | 6081 | 589 | 21 |
40826 | 40826 | 2020-04-08 | San Mateo | California | 6081 | 617 | 21 |
43398 | 43398 | 2020-04-09 | San Mateo | California | 6081 | 633 | 21 |
45998 | 45998 | 2020-04-10 | San Mateo | California | 6081 | 638 | 21 |
48628 | 48628 | 2020-04-11 | San Mateo | California | 6081 | 652 | 21 |
51290 | 51290 | 2020-04-12 | San Mateo | California | 6081 | 652 | 21 |
53969 | 53969 | 2020-04-13 | San Mateo | California | 6081 | 701 | 21 |
56661 | 56661 | 2020-04-14 | San Mateo | California | 6081 | 747 | 21 |
59369 | 59369 | 2020-04-15 | San Mateo | California | 6081 | 767 | 28 |
62088 | 62088 | 2020-04-16 | San Mateo | California | 6081 | 767 | 28 |
64821 | 64821 | 2020-04-17 | San Mateo | California | 6081 | 797 | 28 |
67569 | 67569 | 2020-04-18 | San Mateo | California | 6081 | 838 | 28 |
70331 | 70331 | 2020-04-19 | San Mateo | California | 6081 | 838 | 28 |
73100 | 73100 | 2020-04-20 | San Mateo | California | 6081 | 920 | 28 |
75876 | 75876 | 2020-04-21 | San Mateo | California | 6081 | 935 | 28 |
78660 | 78660 | 2020-04-22 | San Mateo | California | 6081 | 958 | 39 |
81454 | 81454 | 2020-04-23 | San Mateo | California | 6081 | 966 | 39 |
84254 | 84254 | 2020-04-24 | San Mateo | California | 6081 | 989 | 41 |
87062 | 87062 | 2020-04-25 | San Mateo | California | 6081 | 1019 | 41 |
89879 | 89879 | 2020-04-26 | San Mateo | California | 6081 | 1019 | 41 |
92697 | 92697 | 2020-04-27 | San Mateo | California | 6081 | 1080 | 46 |
95529 | 95529 | 2020-04-28 | San Mateo | California | 6081 | 1099 | 48 |
98374 | 98374 | 2020-04-29 | San Mateo | California | 6081 | 1136 | 48 |
101224 | 101224 | 2020-04-30 | San Mateo | California | 6081 | 1177 | 50 |
104079 | 104079 | 2020-05-01 | San Mateo | California | 6081 | 1197 | 52 |
106944 | 106944 | 2020-05-02 | San Mateo | California | 6081 | 1233 | 52 |
109813 | 109813 | 2020-05-03 | San Mateo | California | 6081 | 1272 | 52 |
112688 | 112688 | 2020-05-04 | San Mateo | California | 6081 | 1281 | 53 |
115571 | 115571 | 2020-05-05 | San Mateo | California | 6081 | 1315 | 53 |
118530 | 118530 | 2020-05-06 | San Mateo | California | 6081 | 1341 | 56 |
121497 | 121497 | 2020-05-07 | San Mateo | California | 6081 | 1377 | 56 |
124477 | 124477 | 2020-05-08 | San Mateo | California | 6081 | 1398 | 57 |
127462 | 127462 | 2020-05-09 | San Mateo | California | 6081 | 1425 | 62 |
130452 | 130452 | 2020-05-10 | San Mateo | California | 6081 | 1453 | 65 |
133442 | 133442 | 2020-05-11 | San Mateo | California | 6081 | 1464 | 65 |
136432 | 136432 | 2020-05-12 | San Mateo | California | 6081 | 1499 | 65 |
139423 | 139423 | 2020-05-13 | San Mateo | California | 6081 | 1533 | 66 |
142419 | 142419 | 2020-05-14 | San Mateo | California | 6081 | 1550 | 66 |
145418 | 145418 | 2020-05-15 | San Mateo | California | 6081 | 1588 | 66 |
148422 | 148422 | 2020-05-16 | San Mateo | California | 6081 | 1612 | 67 |
151431 | 151431 | 2020-05-17 | San Mateo | California | 6081 | 1652 | 68 |
154443 | 154443 | 2020-05-18 | San Mateo | California | 6081 | 1680 | 68 |
157459 | 157459 | 2020-05-19 | San Mateo | California | 6081 | 1701 | 68 |
160485 | 160485 | 2020-05-20 | San Mateo | California | 6081 | 1704 | 75 |
163513 | 163513 | 2020-05-21 | San Mateo | California | 6081 | 1739 | 75 |
166545 | 166545 | 2020-05-22 | San Mateo | California | 6081 | 1791 | 76 |
169582 | 169582 | 2020-05-23 | San Mateo | California | 6081 | 1847 | 76 |
172623 | 172623 | 2020-05-24 | San Mateo | California | 6081 | 1862 | 76 |
175667 | 175667 | 2020-05-25 | San Mateo | California | 6081 | 1925 | 76 |
178711 | 178711 | 2020-05-26 | San Mateo | California | 6081 | 1938 | 82 |
181755 | 181755 | 2020-05-27 | San Mateo | California | 6081 | 1967 | 82 |
184809 | 184809 | 2020-05-28 | San Mateo | California | 6081 | 2045 | 82 |
187865 | 187865 | 2020-05-29 | San Mateo | California | 6081 | 2070 | 84 |
190930 | 190930 | 2020-05-30 | San Mateo | California | 6081 | 2104 | 84 |
193997 | 193997 | 2020-05-31 | San Mateo | California | 6081 | 2129 | 84 |
197067 | 197067 | 2020-06-01 | San Mateo | California | 6081 | 2169 | 84 |
200140 | 200140 | 2020-06-02 | San Mateo | California | 6081 | 2190 | 84 |
203216 | 203216 | 2020-06-03 | San Mateo | California | 6081 | 2212 | 84 |
206296 | 206296 | 2020-06-04 | San Mateo | California | 6081 | 2244 | 84 |
209377 | 209377 | 2020-06-05 | San Mateo | California | 6081 | 2299 | 84 |
212462 | 212462 | 2020-06-06 | San Mateo | California | 6081 | 2331 | 88 |
215549 | 215549 | 2020-06-07 | San Mateo | California | 6081 | 2342 | 88 |
218640 | 218640 | 2020-06-08 | San Mateo | California | 6081 | 2399 | 88 |
221735 | 221735 | 2020-06-09 | San Mateo | California | 6081 | 2437 | 93 |
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);