ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "San Benito" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946621 | 946621 | 2021-01-20 | San Benito | California | 6069 | 5003 | 46 |
943374 | 943374 | 2021-01-19 | San Benito | California | 6069 | 4963 | 43 |
940129 | 940129 | 2021-01-18 | San Benito | California | 6069 | 4941 | 43 |
936884 | 936884 | 2021-01-17 | San Benito | California | 6069 | 4882 | 43 |
933639 | 933639 | 2021-01-16 | San Benito | California | 6069 | 4850 | 43 |
930394 | 930394 | 2021-01-15 | San Benito | California | 6069 | 4778 | 43 |
927149 | 927149 | 2021-01-14 | San Benito | California | 6069 | 4698 | 41 |
923903 | 923903 | 2021-01-13 | San Benito | California | 6069 | 4596 | 41 |
920658 | 920658 | 2021-01-12 | San Benito | California | 6069 | 4508 | 39 |
917413 | 917413 | 2021-01-11 | San Benito | California | 6069 | 4451 | 39 |
914168 | 914168 | 2021-01-10 | San Benito | California | 6069 | 4403 | 36 |
910923 | 910923 | 2021-01-09 | San Benito | California | 6069 | 4363 | 36 |
907678 | 907678 | 2021-01-08 | San Benito | California | 6069 | 4266 | 36 |
904432 | 904432 | 2021-01-07 | San Benito | California | 6069 | 4127 | 35 |
901187 | 901187 | 2021-01-06 | San Benito | California | 6069 | 4035 | 34 |
897942 | 897942 | 2021-01-05 | San Benito | California | 6069 | 3952 | 34 |
894697 | 894697 | 2021-01-04 | San Benito | California | 6069 | 3882 | 34 |
891450 | 891450 | 2021-01-03 | San Benito | California | 6069 | 3853 | 29 |
888203 | 888203 | 2021-01-02 | San Benito | California | 6069 | 3802 | 29 |
884958 | 884958 | 2021-01-01 | San Benito | California | 6069 | 3739 | 29 |
881713 | 881713 | 2020-12-31 | San Benito | California | 6069 | 3673 | 29 |
878468 | 878468 | 2020-12-30 | San Benito | California | 6069 | 3538 | 28 |
875223 | 875223 | 2020-12-29 | San Benito | California | 6069 | 3489 | 28 |
871978 | 871978 | 2020-12-28 | San Benito | California | 6069 | 3431 | 28 |
868733 | 868733 | 2020-12-27 | San Benito | California | 6069 | 3394 | 26 |
865488 | 865488 | 2020-12-26 | San Benito | California | 6069 | 3365 | 26 |
862243 | 862243 | 2020-12-25 | San Benito | California | 6069 | 3288 | 26 |
858998 | 858998 | 2020-12-24 | San Benito | California | 6069 | 3231 | 26 |
855753 | 855753 | 2020-12-23 | San Benito | California | 6069 | 3171 | 26 |
852508 | 852508 | 2020-12-22 | San Benito | California | 6069 | 3074 | 24 |
849263 | 849263 | 2020-12-21 | San Benito | California | 6069 | 2964 | 23 |
846018 | 846018 | 2020-12-20 | San Benito | California | 6069 | 2907 | 23 |
842772 | 842772 | 2020-12-19 | San Benito | California | 6069 | 2854 | 23 |
839527 | 839527 | 2020-12-18 | San Benito | California | 6069 | 2760 | 23 |
836282 | 836282 | 2020-12-17 | San Benito | California | 6069 | 2687 | 23 |
833036 | 833036 | 2020-12-16 | San Benito | California | 6069 | 2642 | 22 |
829789 | 829789 | 2020-12-15 | San Benito | California | 6069 | 2538 | 22 |
826543 | 826543 | 2020-12-14 | San Benito | California | 6069 | 2477 | 21 |
823296 | 823296 | 2020-12-13 | San Benito | California | 6069 | 2447 | 19 |
820050 | 820050 | 2020-12-12 | San Benito | California | 6069 | 2401 | 19 |
816804 | 816804 | 2020-12-11 | San Benito | California | 6069 | 2348 | 19 |
813558 | 813558 | 2020-12-10 | San Benito | California | 6069 | 2314 | 19 |
810314 | 810314 | 2020-12-09 | San Benito | California | 6069 | 2264 | 19 |
807069 | 807069 | 2020-12-08 | San Benito | California | 6069 | 2214 | 19 |
803824 | 803824 | 2020-12-07 | San Benito | California | 6069 | 2177 | 19 |
800579 | 800579 | 2020-12-06 | San Benito | California | 6069 | 2159 | 18 |
797334 | 797334 | 2020-12-05 | San Benito | California | 6069 | 2124 | 18 |
794089 | 794089 | 2020-12-04 | San Benito | California | 6069 | 2051 | 18 |
790844 | 790844 | 2020-12-03 | San Benito | California | 6069 | 2007 | 17 |
787599 | 787599 | 2020-12-02 | San Benito | California | 6069 | 1968 | 17 |
784355 | 784355 | 2020-12-01 | San Benito | California | 6069 | 1929 | 17 |
781110 | 781110 | 2020-11-30 | San Benito | California | 6069 | 1893 | 16 |
777864 | 777864 | 2020-11-29 | San Benito | California | 6069 | 1880 | 16 |
774619 | 774619 | 2020-11-28 | San Benito | California | 6069 | 1865 | 16 |
771374 | 771374 | 2020-11-27 | San Benito | California | 6069 | 1837 | 16 |
768129 | 768129 | 2020-11-26 | San Benito | California | 6069 | 1813 | 16 |
764883 | 764883 | 2020-11-25 | San Benito | California | 6069 | 1784 | 16 |
761638 | 761638 | 2020-11-24 | San Benito | California | 6069 | 1767 | 16 |
758393 | 758393 | 2020-11-23 | San Benito | California | 6069 | 1746 | 15 |
755146 | 755146 | 2020-11-22 | San Benito | California | 6069 | 1741 | 15 |
751900 | 751900 | 2020-11-21 | San Benito | California | 6069 | 1711 | 15 |
748654 | 748654 | 2020-11-20 | San Benito | California | 6069 | 1694 | 15 |
745408 | 745408 | 2020-11-19 | San Benito | California | 6069 | 1676 | 15 |
742161 | 742161 | 2020-11-18 | San Benito | California | 6069 | 1652 | 15 |
738914 | 738914 | 2020-11-17 | San Benito | California | 6069 | 1643 | 15 |
735670 | 735670 | 2020-11-16 | San Benito | California | 6069 | 1620 | 15 |
732424 | 732424 | 2020-11-15 | San Benito | California | 6069 | 1614 | 15 |
729179 | 729179 | 2020-11-14 | San Benito | California | 6069 | 1593 | 15 |
725936 | 725936 | 2020-11-13 | San Benito | California | 6069 | 1581 | 15 |
722693 | 722693 | 2020-11-12 | San Benito | California | 6069 | 1563 | 15 |
719450 | 719450 | 2020-11-11 | San Benito | California | 6069 | 1540 | 15 |
716207 | 716207 | 2020-11-10 | San Benito | California | 6069 | 1525 | 15 |
712963 | 712963 | 2020-11-09 | San Benito | California | 6069 | 1517 | 15 |
709719 | 709719 | 2020-11-08 | San Benito | California | 6069 | 1517 | 15 |
706475 | 706475 | 2020-11-07 | San Benito | California | 6069 | 1509 | 15 |
703232 | 703232 | 2020-11-06 | San Benito | California | 6069 | 1499 | 15 |
699989 | 699989 | 2020-11-05 | San Benito | California | 6069 | 1491 | 15 |
696745 | 696745 | 2020-11-04 | San Benito | California | 6069 | 1483 | 15 |
693503 | 693503 | 2020-11-03 | San Benito | California | 6069 | 1478 | 15 |
690260 | 690260 | 2020-11-02 | San Benito | California | 6069 | 1477 | 15 |
687015 | 687015 | 2020-11-01 | San Benito | California | 6069 | 1473 | 15 |
683771 | 683771 | 2020-10-31 | San Benito | California | 6069 | 1464 | 15 |
680528 | 680528 | 2020-10-30 | San Benito | California | 6069 | 1461 | 15 |
677285 | 677285 | 2020-10-29 | San Benito | California | 6069 | 1449 | 15 |
674042 | 674042 | 2020-10-28 | San Benito | California | 6069 | 1444 | 15 |
670800 | 670800 | 2020-10-27 | San Benito | California | 6069 | 1442 | 15 |
667557 | 667557 | 2020-10-26 | San Benito | California | 6069 | 1442 | 15 |
664312 | 664312 | 2020-10-25 | San Benito | California | 6069 | 1437 | 15 |
661068 | 661068 | 2020-10-24 | San Benito | California | 6069 | 1436 | 15 |
657824 | 657824 | 2020-10-23 | San Benito | California | 6069 | 1432 | 15 |
654579 | 654579 | 2020-10-22 | San Benito | California | 6069 | 1419 | 15 |
651334 | 651334 | 2020-10-21 | San Benito | California | 6069 | 1411 | 14 |
648090 | 648090 | 2020-10-20 | San Benito | California | 6069 | 1407 | 14 |
644845 | 644845 | 2020-10-19 | San Benito | California | 6069 | 1403 | 14 |
641597 | 641597 | 2020-10-18 | San Benito | California | 6069 | 1401 | 14 |
638350 | 638350 | 2020-10-17 | San Benito | California | 6069 | 1401 | 14 |
635105 | 635105 | 2020-10-16 | San Benito | California | 6069 | 1396 | 14 |
631859 | 631859 | 2020-10-15 | San Benito | California | 6069 | 1392 | 13 |
628615 | 628615 | 2020-10-14 | San Benito | California | 6069 | 1390 | 13 |
625372 | 625372 | 2020-10-13 | San Benito | California | 6069 | 1388 | 13 |
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);