ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 6081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386165 | 386165 | 2020-07-31 | San Mateo | California | 6081 | 5469 | 119 |
382947 | 382947 | 2020-07-30 | San Mateo | California | 6081 | 5398 | 118 |
379730 | 379730 | 2020-07-29 | San Mateo | California | 6081 | 5306 | 118 |
376513 | 376513 | 2020-07-28 | San Mateo | California | 6081 | 5198 | 118 |
373299 | 373299 | 2020-07-27 | San Mateo | California | 6081 | 5124 | 117 |
370087 | 370087 | 2020-07-26 | San Mateo | California | 6081 | 5023 | 117 |
366877 | 366877 | 2020-07-25 | San Mateo | California | 6081 | 5022 | 117 |
363670 | 363670 | 2020-07-24 | San Mateo | California | 6081 | 4957 | 117 |
360463 | 360463 | 2020-07-23 | San Mateo | California | 6081 | 4885 | 114 |
357258 | 357258 | 2020-07-22 | San Mateo | California | 6081 | 4776 | 114 |
354055 | 354055 | 2020-07-21 | San Mateo | California | 6081 | 4674 | 114 |
350853 | 350853 | 2020-07-20 | San Mateo | California | 6081 | 4551 | 114 |
347652 | 347652 | 2020-07-19 | San Mateo | California | 6081 | 4488 | 114 |
344452 | 344452 | 2020-07-18 | San Mateo | California | 6081 | 4465 | 114 |
341253 | 341253 | 2020-07-17 | San Mateo | California | 6081 | 4403 | 114 |
338057 | 338057 | 2020-07-16 | San Mateo | California | 6081 | 4333 | 114 |
334862 | 334862 | 2020-07-15 | San Mateo | California | 6081 | 4254 | 114 |
331669 | 331669 | 2020-07-14 | San Mateo | California | 6081 | 4168 | 114 |
328483 | 328483 | 2020-07-13 | San Mateo | California | 6081 | 4045 | 112 |
325297 | 325297 | 2020-07-12 | San Mateo | California | 6081 | 3956 | 112 |
322116 | 322116 | 2020-07-11 | San Mateo | California | 6081 | 3949 | 112 |
318937 | 318937 | 2020-07-10 | San Mateo | California | 6081 | 3846 | 112 |
315764 | 315764 | 2020-07-09 | San Mateo | California | 6081 | 3787 | 111 |
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 |
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);