ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Ventura" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635126 | 635126 | 2020-10-16 | Ventura | California | 6111 | 13750 | 160 |
631880 | 631880 | 2020-10-15 | Ventura | California | 6111 | 13697 | 159 |
628636 | 628636 | 2020-10-14 | Ventura | California | 6111 | 13645 | 158 |
625393 | 625393 | 2020-10-13 | Ventura | California | 6111 | 13617 | 158 |
622150 | 622150 | 2020-10-12 | Ventura | California | 6111 | 13604 | 158 |
618907 | 618907 | 2020-10-11 | Ventura | California | 6111 | 13520 | 158 |
615665 | 615665 | 2020-10-10 | Ventura | California | 6111 | 13469 | 158 |
612424 | 612424 | 2020-10-09 | Ventura | California | 6111 | 13399 | 158 |
609182 | 609182 | 2020-10-08 | Ventura | California | 6111 | 13333 | 157 |
605939 | 605939 | 2020-10-07 | Ventura | California | 6111 | 13242 | 157 |
602697 | 602697 | 2020-10-06 | Ventura | California | 6111 | 13224 | 154 |
599454 | 599454 | 2020-10-05 | Ventura | California | 6111 | 13197 | 154 |
596211 | 596211 | 2020-10-04 | Ventura | California | 6111 | 13150 | 153 |
592969 | 592969 | 2020-10-03 | Ventura | California | 6111 | 13120 | 153 |
589729 | 589729 | 2020-10-02 | Ventura | California | 6111 | 13057 | 153 |
586488 | 586488 | 2020-10-01 | Ventura | California | 6111 | 12968 | 152 |
583248 | 583248 | 2020-09-30 | Ventura | California | 6111 | 12875 | 152 |
580009 | 580009 | 2020-09-29 | Ventura | California | 6111 | 12812 | 150 |
576768 | 576768 | 2020-09-28 | Ventura | California | 6111 | 12775 | 150 |
573525 | 573525 | 2020-09-27 | Ventura | California | 6111 | 12729 | 150 |
570283 | 570283 | 2020-09-26 | Ventura | California | 6111 | 12664 | 150 |
567041 | 567041 | 2020-09-25 | Ventura | California | 6111 | 12617 | 150 |
563801 | 563801 | 2020-09-24 | Ventura | California | 6111 | 12591 | 147 |
560562 | 560562 | 2020-09-23 | Ventura | California | 6111 | 12507 | 146 |
557326 | 557326 | 2020-09-22 | Ventura | California | 6111 | 12477 | 146 |
554089 | 554089 | 2020-09-21 | Ventura | California | 6111 | 12406 | 146 |
550850 | 550850 | 2020-09-20 | Ventura | California | 6111 | 12328 | 143 |
547611 | 547611 | 2020-09-19 | Ventura | California | 6111 | 12236 | 143 |
544373 | 544373 | 2020-09-18 | Ventura | California | 6111 | 12167 | 143 |
541137 | 541137 | 2020-09-17 | Ventura | California | 6111 | 12073 | 142 |
537900 | 537900 | 2020-09-16 | Ventura | California | 6111 | 11932 | 141 |
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 |
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);