ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where county = "San Mateo" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312589 | 312589 | 2020-07-08 | San Mateo | California | 6081 | 3743 | 111 |
309419 | 309419 | 2020-07-07 | San Mateo | California | 6081 | 3692 | 111 |
306251 | 306251 | 2020-07-06 | San Mateo | California | 6081 | 3599 | 108 |
303087 | 303087 | 2020-07-05 | San Mateo | California | 6081 | 3536 | 108 |
299923 | 299923 | 2020-07-04 | San Mateo | California | 6081 | 3536 | 108 |
296761 | 296761 | 2020-07-03 | San Mateo | California | 6081 | 3441 | 108 |
293605 | 293605 | 2020-07-02 | San Mateo | California | 6081 | 3376 | 108 |
290451 | 290451 | 2020-07-01 | San Mateo | California | 6081 | 3268 | 108 |
287300 | 287300 | 2020-06-30 | San Mateo | California | 6081 | 3170 | 108 |
284154 | 284154 | 2020-06-29 | San Mateo | California | 6081 | 3124 | 106 |
281008 | 281008 | 2020-06-28 | San Mateo | California | 6081 | 3083 | 106 |
277861 | 277861 | 2020-06-27 | San Mateo | California | 6081 | 3055 | 106 |
274713 | 274713 | 2020-06-26 | San Mateo | California | 6081 | 2996 | 106 |
271573 | 271573 | 2020-06-25 | San Mateo | California | 6081 | 2964 | 104 |
268438 | 268438 | 2020-06-24 | San Mateo | California | 6081 | 2907 | 104 |
265308 | 265308 | 2020-06-23 | San Mateo | California | 6081 | 2813 | 104 |
262180 | 262180 | 2020-06-22 | San Mateo | California | 6081 | 2781 | 103 |
259053 | 259053 | 2020-06-21 | San Mateo | California | 6081 | 2755 | 103 |
255926 | 255926 | 2020-06-20 | San Mateo | California | 6081 | 2713 | 103 |
252807 | 252807 | 2020-06-19 | San Mateo | California | 6081 | 2674 | 103 |
249692 | 249692 | 2020-06-18 | San Mateo | California | 6081 | 2649 | 99 |
246580 | 246580 | 2020-06-17 | San Mateo | California | 6081 | 2618 | 99 |
243467 | 243467 | 2020-06-16 | San Mateo | California | 6081 | 2591 | 99 |
240356 | 240356 | 2020-06-15 | San Mateo | California | 6081 | 2571 | 99 |
237248 | 237248 | 2020-06-14 | San Mateo | California | 6081 | 2553 | 99 |
234141 | 234141 | 2020-06-13 | San Mateo | California | 6081 | 2553 | 99 |
231035 | 231035 | 2020-06-12 | San Mateo | California | 6081 | 2533 | 99 |
227932 | 227932 | 2020-06-11 | San Mateo | California | 6081 | 2494 | 93 |
224830 | 224830 | 2020-06-10 | San Mateo | California | 6081 | 2475 | 93 |
221735 | 221735 | 2020-06-09 | San Mateo | California | 6081 | 2437 | 93 |
218640 | 218640 | 2020-06-08 | San Mateo | California | 6081 | 2399 | 88 |
215549 | 215549 | 2020-06-07 | San Mateo | California | 6081 | 2342 | 88 |
212462 | 212462 | 2020-06-06 | San Mateo | California | 6081 | 2331 | 88 |
209377 | 209377 | 2020-06-05 | San Mateo | California | 6081 | 2299 | 84 |
206296 | 206296 | 2020-06-04 | San Mateo | California | 6081 | 2244 | 84 |
203216 | 203216 | 2020-06-03 | San Mateo | California | 6081 | 2212 | 84 |
200140 | 200140 | 2020-06-02 | San Mateo | California | 6081 | 2190 | 84 |
197067 | 197067 | 2020-06-01 | San Mateo | California | 6081 | 2169 | 84 |
193997 | 193997 | 2020-05-31 | San Mateo | California | 6081 | 2129 | 84 |
190930 | 190930 | 2020-05-30 | San Mateo | California | 6081 | 2104 | 84 |
187865 | 187865 | 2020-05-29 | San Mateo | California | 6081 | 2070 | 84 |
184809 | 184809 | 2020-05-28 | San Mateo | California | 6081 | 2045 | 82 |
181755 | 181755 | 2020-05-27 | San Mateo | California | 6081 | 1967 | 82 |
178711 | 178711 | 2020-05-26 | San Mateo | California | 6081 | 1938 | 82 |
175667 | 175667 | 2020-05-25 | San Mateo | California | 6081 | 1925 | 76 |
172623 | 172623 | 2020-05-24 | San Mateo | California | 6081 | 1862 | 76 |
169582 | 169582 | 2020-05-23 | San Mateo | California | 6081 | 1847 | 76 |
166545 | 166545 | 2020-05-22 | San Mateo | California | 6081 | 1791 | 76 |
163513 | 163513 | 2020-05-21 | San Mateo | California | 6081 | 1739 | 75 |
160485 | 160485 | 2020-05-20 | San Mateo | California | 6081 | 1704 | 75 |
157459 | 157459 | 2020-05-19 | San Mateo | California | 6081 | 1701 | 68 |
154443 | 154443 | 2020-05-18 | San Mateo | California | 6081 | 1680 | 68 |
151431 | 151431 | 2020-05-17 | San Mateo | California | 6081 | 1652 | 68 |
148422 | 148422 | 2020-05-16 | San Mateo | California | 6081 | 1612 | 67 |
145418 | 145418 | 2020-05-15 | San Mateo | California | 6081 | 1588 | 66 |
142419 | 142419 | 2020-05-14 | San Mateo | California | 6081 | 1550 | 66 |
139423 | 139423 | 2020-05-13 | San Mateo | California | 6081 | 1533 | 66 |
136432 | 136432 | 2020-05-12 | San Mateo | California | 6081 | 1499 | 65 |
133442 | 133442 | 2020-05-11 | San Mateo | California | 6081 | 1464 | 65 |
130452 | 130452 | 2020-05-10 | San Mateo | California | 6081 | 1453 | 65 |
127462 | 127462 | 2020-05-09 | San Mateo | California | 6081 | 1425 | 62 |
124477 | 124477 | 2020-05-08 | San Mateo | California | 6081 | 1398 | 57 |
121497 | 121497 | 2020-05-07 | San Mateo | California | 6081 | 1377 | 56 |
118530 | 118530 | 2020-05-06 | San Mateo | California | 6081 | 1341 | 56 |
115571 | 115571 | 2020-05-05 | San Mateo | California | 6081 | 1315 | 53 |
112688 | 112688 | 2020-05-04 | San Mateo | California | 6081 | 1281 | 53 |
109813 | 109813 | 2020-05-03 | San Mateo | California | 6081 | 1272 | 52 |
106944 | 106944 | 2020-05-02 | San Mateo | California | 6081 | 1233 | 52 |
104079 | 104079 | 2020-05-01 | San Mateo | California | 6081 | 1197 | 52 |
101224 | 101224 | 2020-04-30 | San Mateo | California | 6081 | 1177 | 50 |
98374 | 98374 | 2020-04-29 | San Mateo | California | 6081 | 1136 | 48 |
95529 | 95529 | 2020-04-28 | San Mateo | California | 6081 | 1099 | 48 |
92697 | 92697 | 2020-04-27 | San Mateo | California | 6081 | 1080 | 46 |
89879 | 89879 | 2020-04-26 | San Mateo | California | 6081 | 1019 | 41 |
87062 | 87062 | 2020-04-25 | San Mateo | California | 6081 | 1019 | 41 |
84254 | 84254 | 2020-04-24 | San Mateo | California | 6081 | 989 | 41 |
81454 | 81454 | 2020-04-23 | San Mateo | California | 6081 | 966 | 39 |
78660 | 78660 | 2020-04-22 | San Mateo | California | 6081 | 958 | 39 |
75876 | 75876 | 2020-04-21 | San Mateo | California | 6081 | 935 | 28 |
73100 | 73100 | 2020-04-20 | San Mateo | California | 6081 | 920 | 28 |
70331 | 70331 | 2020-04-19 | San Mateo | California | 6081 | 838 | 28 |
67569 | 67569 | 2020-04-18 | San Mateo | California | 6081 | 838 | 28 |
64821 | 64821 | 2020-04-17 | San Mateo | California | 6081 | 797 | 28 |
62088 | 62088 | 2020-04-16 | San Mateo | California | 6081 | 767 | 28 |
59369 | 59369 | 2020-04-15 | San Mateo | California | 6081 | 767 | 28 |
56661 | 56661 | 2020-04-14 | San Mateo | California | 6081 | 747 | 21 |
53969 | 53969 | 2020-04-13 | San Mateo | California | 6081 | 701 | 21 |
51290 | 51290 | 2020-04-12 | San Mateo | California | 6081 | 652 | 21 |
48628 | 48628 | 2020-04-11 | San Mateo | California | 6081 | 652 | 21 |
45998 | 45998 | 2020-04-10 | San Mateo | California | 6081 | 638 | 21 |
43398 | 43398 | 2020-04-09 | San Mateo | California | 6081 | 633 | 21 |
40826 | 40826 | 2020-04-08 | San Mateo | California | 6081 | 617 | 21 |
38282 | 38282 | 2020-04-07 | San Mateo | California | 6081 | 589 | 21 |
35793 | 35793 | 2020-04-06 | San Mateo | California | 6081 | 579 | 13 |
33348 | 33348 | 2020-04-05 | San Mateo | California | 6081 | 555 | 13 |
30942 | 30942 | 2020-04-04 | San Mateo | California | 6081 | 538 | 13 |
28584 | 28584 | 2020-04-03 | San Mateo | California | 6081 | 486 | 13 |
26285 | 26285 | 2020-04-02 | San Mateo | California | 6081 | 453 | 10 |
24056 | 24056 | 2020-04-01 | San Mateo | California | 6081 | 388 | 10 |
21898 | 21898 | 2020-03-31 | San Mateo | California | 6081 | 309 | 10 |
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);