ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 6111 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534664 | 534664 | 2020-09-15 | Ventura | California | 6111 | 11903 | 138 |
531429 | 531429 | 2020-09-14 | Ventura | California | 6111 | 11855 | 135 |
528192 | 528192 | 2020-09-13 | Ventura | California | 6111 | 11759 | 129 |
524956 | 524956 | 2020-09-12 | Ventura | California | 6111 | 11700 | 129 |
521720 | 521720 | 2020-09-11 | Ventura | California | 6111 | 11600 | 129 |
518483 | 518483 | 2020-09-10 | Ventura | California | 6111 | 11497 | 129 |
515248 | 515248 | 2020-09-09 | Ventura | California | 6111 | 11475 | 126 |
512015 | 512015 | 2020-09-08 | Ventura | California | 6111 | 11463 | 123 |
508782 | 508782 | 2020-09-07 | Ventura | California | 6111 | 11315 | 118 |
505550 | 505550 | 2020-09-06 | Ventura | California | 6111 | 11254 | 118 |
502316 | 502316 | 2020-09-05 | Ventura | California | 6111 | 11171 | 118 |
499082 | 499082 | 2020-09-04 | Ventura | California | 6111 | 11109 | 118 |
495849 | 495849 | 2020-09-03 | Ventura | California | 6111 | 11031 | 116 |
492615 | 492615 | 2020-09-02 | Ventura | California | 6111 | 10899 | 116 |
489382 | 489382 | 2020-09-01 | Ventura | California | 6111 | 10866 | 116 |
486149 | 486149 | 2020-08-31 | Ventura | California | 6111 | 10775 | 116 |
482914 | 482914 | 2020-08-30 | Ventura | California | 6111 | 10705 | 115 |
479680 | 479680 | 2020-08-29 | Ventura | California | 6111 | 10606 | 115 |
476447 | 476447 | 2020-08-28 | Ventura | California | 6111 | 10483 | 115 |
473214 | 473214 | 2020-08-27 | Ventura | California | 6111 | 10412 | 110 |
469982 | 469982 | 2020-08-26 | Ventura | California | 6111 | 10313 | 107 |
466753 | 466753 | 2020-08-25 | Ventura | California | 6111 | 10261 | 105 |
463524 | 463524 | 2020-08-24 | Ventura | California | 6111 | 10126 | 103 |
460295 | 460295 | 2020-08-23 | Ventura | California | 6111 | 9959 | 102 |
457068 | 457068 | 2020-08-22 | Ventura | California | 6111 | 9865 | 102 |
453840 | 453840 | 2020-08-21 | Ventura | California | 6111 | 9744 | 102 |
450612 | 450612 | 2020-08-20 | Ventura | California | 6111 | 9587 | 101 |
447384 | 447384 | 2020-08-19 | Ventura | California | 6111 | 9490 | 98 |
444157 | 444157 | 2020-08-18 | Ventura | California | 6111 | 9490 | 97 |
440931 | 440931 | 2020-08-17 | Ventura | California | 6111 | 9408 | 96 |
437705 | 437705 | 2020-08-16 | Ventura | California | 6111 | 9379 | 95 |
434479 | 434479 | 2020-08-15 | Ventura | California | 6111 | 9313 | 95 |
431254 | 431254 | 2020-08-14 | Ventura | California | 6111 | 9114 | 95 |
428026 | 428026 | 2020-08-13 | Ventura | California | 6111 | 9005 | 94 |
424802 | 424802 | 2020-08-12 | Ventura | California | 6111 | 8953 | 93 |
421581 | 421581 | 2020-08-11 | Ventura | California | 6111 | 8851 | 93 |
418360 | 418360 | 2020-08-10 | Ventura | California | 6111 | 8634 | 92 |
415139 | 415139 | 2020-08-09 | Ventura | California | 6111 | 8462 | 89 |
411919 | 411919 | 2020-08-08 | Ventura | California | 6111 | 8356 | 89 |
408700 | 408700 | 2020-08-07 | Ventura | California | 6111 | 8162 | 89 |
405480 | 405480 | 2020-08-06 | Ventura | California | 6111 | 8162 | 82 |
402262 | 402262 | 2020-08-05 | Ventura | California | 6111 | 8134 | 79 |
399046 | 399046 | 2020-08-04 | Ventura | California | 6111 | 8084 | 77 |
395830 | 395830 | 2020-08-03 | Ventura | California | 6111 | 8014 | 76 |
392614 | 392614 | 2020-08-02 | Ventura | California | 6111 | 7819 | 76 |
389397 | 389397 | 2020-08-01 | Ventura | California | 6111 | 7521 | 76 |
386180 | 386180 | 2020-07-31 | Ventura | California | 6111 | 7344 | 76 |
382962 | 382962 | 2020-07-30 | Ventura | California | 6111 | 7161 | 74 |
379745 | 379745 | 2020-07-29 | Ventura | California | 6111 | 7045 | 73 |
376528 | 376528 | 2020-07-28 | Ventura | California | 6111 | 6998 | 71 |
373314 | 373314 | 2020-07-27 | Ventura | California | 6111 | 6844 | 70 |
370102 | 370102 | 2020-07-26 | Ventura | California | 6111 | 6662 | 67 |
366892 | 366892 | 2020-07-25 | Ventura | California | 6111 | 6553 | 67 |
363685 | 363685 | 2020-07-24 | Ventura | California | 6111 | 6392 | 67 |
360478 | 360478 | 2020-07-23 | Ventura | California | 6111 | 6223 | 63 |
357273 | 357273 | 2020-07-22 | Ventura | California | 6111 | 6131 | 63 |
354070 | 354070 | 2020-07-21 | Ventura | California | 6111 | 5955 | 62 |
350868 | 350868 | 2020-07-20 | Ventura | California | 6111 | 5748 | 58 |
347667 | 347667 | 2020-07-19 | Ventura | California | 6111 | 5630 | 57 |
344467 | 344467 | 2020-07-18 | Ventura | California | 6111 | 5451 | 57 |
341268 | 341268 | 2020-07-17 | Ventura | California | 6111 | 5231 | 57 |
338072 | 338072 | 2020-07-16 | Ventura | California | 6111 | 5087 | 56 |
334877 | 334877 | 2020-07-15 | Ventura | California | 6111 | 4950 | 56 |
331684 | 331684 | 2020-07-14 | Ventura | California | 6111 | 4800 | 53 |
328498 | 328498 | 2020-07-13 | Ventura | California | 6111 | 4724 | 53 |
325312 | 325312 | 2020-07-12 | Ventura | California | 6111 | 4545 | 53 |
322131 | 322131 | 2020-07-11 | Ventura | California | 6111 | 4416 | 53 |
318952 | 318952 | 2020-07-10 | Ventura | California | 6111 | 4278 | 53 |
315779 | 315779 | 2020-07-09 | Ventura | California | 6111 | 4139 | 53 |
312604 | 312604 | 2020-07-08 | Ventura | California | 6111 | 3992 | 50 |
309434 | 309434 | 2020-07-07 | Ventura | California | 6111 | 3912 | 50 |
306266 | 306266 | 2020-07-06 | Ventura | California | 6111 | 3866 | 50 |
303102 | 303102 | 2020-07-05 | Ventura | California | 6111 | 3687 | 47 |
299938 | 299938 | 2020-07-04 | Ventura | California | 6111 | 3536 | 47 |
296776 | 296776 | 2020-07-03 | Ventura | California | 6111 | 3394 | 47 |
293620 | 293620 | 2020-07-02 | Ventura | California | 6111 | 3240 | 47 |
290466 | 290466 | 2020-07-01 | Ventura | California | 6111 | 3096 | 46 |
287315 | 287315 | 2020-06-30 | Ventura | California | 6111 | 2926 | 46 |
284169 | 284169 | 2020-06-29 | Ventura | California | 6111 | 2740 | 45 |
281023 | 281023 | 2020-06-28 | Ventura | California | 6111 | 2527 | 44 |
277876 | 277876 | 2020-06-27 | Ventura | California | 6111 | 2444 | 44 |
274728 | 274728 | 2020-06-26 | Ventura | California | 6111 | 2346 | 44 |
271588 | 271588 | 2020-06-25 | Ventura | California | 6111 | 2314 | 44 |
268453 | 268453 | 2020-06-24 | Ventura | California | 6111 | 2260 | 44 |
265323 | 265323 | 2020-06-23 | Ventura | California | 6111 | 2161 | 43 |
262195 | 262195 | 2020-06-22 | Ventura | California | 6111 | 2030 | 43 |
259068 | 259068 | 2020-06-21 | Ventura | California | 6111 | 1946 | 42 |
255941 | 255941 | 2020-06-20 | Ventura | California | 6111 | 1865 | 42 |
252822 | 252822 | 2020-06-19 | Ventura | California | 6111 | 1781 | 42 |
249707 | 249707 | 2020-06-18 | Ventura | California | 6111 | 1753 | 42 |
246595 | 246595 | 2020-06-17 | Ventura | California | 6111 | 1706 | 41 |
243482 | 243482 | 2020-06-16 | Ventura | California | 6111 | 1656 | 41 |
240371 | 240371 | 2020-06-15 | Ventura | California | 6111 | 1633 | 41 |
237263 | 237263 | 2020-06-14 | Ventura | California | 6111 | 1567 | 40 |
234156 | 234156 | 2020-06-13 | Ventura | California | 6111 | 1534 | 40 |
231050 | 231050 | 2020-06-12 | Ventura | California | 6111 | 1518 | 40 |
227947 | 227947 | 2020-06-11 | Ventura | California | 6111 | 1466 | 38 |
224845 | 224845 | 2020-06-10 | Ventura | California | 6111 | 1407 | 38 |
221750 | 221750 | 2020-06-09 | Ventura | California | 6111 | 1382 | 35 |
218655 | 218655 | 2020-06-08 | Ventura | California | 6111 | 1341 | 35 |
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);