ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Madera" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053711 | 1053711 | 2021-02-22 | Madera | California | 6039 | 15298 | 201 |
1050464 | 1050464 | 2021-02-21 | Madera | California | 6039 | 15274 | 201 |
1047217 | 1047217 | 2021-02-20 | Madera | California | 6039 | 15222 | 201 |
1043972 | 1043972 | 2021-02-19 | Madera | California | 6039 | 15175 | 201 |
1040727 | 1040727 | 2021-02-18 | Madera | California | 6039 | 15135 | 201 |
1037482 | 1037482 | 2021-02-17 | Madera | California | 6039 | 15120 | 201 |
1034237 | 1034237 | 2021-02-16 | Madera | California | 6039 | 15108 | 201 |
1030991 | 1030991 | 2021-02-15 | Madera | California | 6039 | 15089 | 189 |
1027744 | 1027744 | 2021-02-14 | Madera | California | 6039 | 15053 | 189 |
1024499 | 1024499 | 2021-02-13 | Madera | California | 6039 | 15022 | 189 |
1021254 | 1021254 | 2021-02-12 | Madera | California | 6039 | 14984 | 189 |
1018009 | 1018009 | 2021-02-11 | Madera | California | 6039 | 14925 | 189 |
1014764 | 1014764 | 2021-02-10 | Madera | California | 6039 | 14912 | 189 |
1011519 | 1011519 | 2021-02-09 | Madera | California | 6039 | 14887 | 189 |
1008273 | 1008273 | 2021-02-08 | Madera | California | 6039 | 14850 | 184 |
1005027 | 1005027 | 2021-02-07 | Madera | California | 6039 | 14807 | 184 |
1001781 | 1001781 | 2021-02-06 | Madera | California | 6039 | 14752 | 184 |
998535 | 998535 | 2021-02-05 | Madera | California | 6039 | 14706 | 184 |
995289 | 995289 | 2021-02-04 | Madera | California | 6039 | 14605 | 184 |
992043 | 992043 | 2021-02-03 | Madera | California | 6039 | 14595 | 184 |
988797 | 988797 | 2021-02-02 | Madera | California | 6039 | 14572 | 184 |
985550 | 985550 | 2021-02-01 | Madera | California | 6039 | 14496 | 175 |
982303 | 982303 | 2021-01-31 | Madera | California | 6039 | 14443 | 175 |
979057 | 979057 | 2021-01-30 | Madera | California | 6039 | 14377 | 175 |
975812 | 975812 | 2021-01-29 | Madera | California | 6039 | 14301 | 175 |
972567 | 972567 | 2021-01-28 | Madera | California | 6039 | 14194 | 175 |
969322 | 969322 | 2021-01-27 | Madera | California | 6039 | 14130 | 175 |
966078 | 966078 | 2021-01-26 | Madera | California | 6039 | 14068 | 175 |
962833 | 962833 | 2021-01-25 | Madera | California | 6039 | 14000 | 151 |
959588 | 959588 | 2021-01-24 | Madera | California | 6039 | 13858 | 151 |
956342 | 956342 | 2021-01-23 | Madera | California | 6039 | 13781 | 151 |
953097 | 953097 | 2021-01-22 | Madera | California | 6039 | 13664 | 151 |
949852 | 949852 | 2021-01-21 | Madera | California | 6039 | 13585 | 151 |
946606 | 946606 | 2021-01-20 | Madera | California | 6039 | 13528 | 151 |
943359 | 943359 | 2021-01-19 | Madera | California | 6039 | 13443 | 151 |
940114 | 940114 | 2021-01-18 | Madera | California | 6039 | 13328 | 130 |
936869 | 936869 | 2021-01-17 | Madera | California | 6039 | 13193 | 130 |
933624 | 933624 | 2021-01-16 | Madera | California | 6039 | 12883 | 130 |
930379 | 930379 | 2021-01-15 | Madera | California | 6039 | 12778 | 130 |
927134 | 927134 | 2021-01-14 | Madera | California | 6039 | 12570 | 130 |
923888 | 923888 | 2021-01-13 | Madera | California | 6039 | 12485 | 130 |
920643 | 920643 | 2021-01-12 | Madera | California | 6039 | 12389 | 130 |
917398 | 917398 | 2021-01-11 | Madera | California | 6039 | 12270 | 126 |
914153 | 914153 | 2021-01-10 | Madera | California | 6039 | 12063 | 126 |
910908 | 910908 | 2021-01-09 | Madera | California | 6039 | 11846 | 126 |
907663 | 907663 | 2021-01-08 | Madera | California | 6039 | 11645 | 126 |
904417 | 904417 | 2021-01-07 | Madera | California | 6039 | 11532 | 126 |
901172 | 901172 | 2021-01-06 | Madera | California | 6039 | 11359 | 126 |
897927 | 897927 | 2021-01-05 | Madera | California | 6039 | 11280 | 126 |
894682 | 894682 | 2021-01-04 | Madera | California | 6039 | 11151 | 117 |
891435 | 891435 | 2021-01-03 | Madera | California | 6039 | 11039 | 117 |
888188 | 888188 | 2021-01-02 | Madera | California | 6039 | 10752 | 117 |
884943 | 884943 | 2021-01-01 | Madera | California | 6039 | 10609 | 117 |
881698 | 881698 | 2020-12-31 | Madera | California | 6039 | 10491 | 117 |
878453 | 878453 | 2020-12-30 | Madera | California | 6039 | 10273 | 117 |
875208 | 875208 | 2020-12-29 | Madera | California | 6039 | 10172 | 116 |
871963 | 871963 | 2020-12-28 | Madera | California | 6039 | 10015 | 116 |
868718 | 868718 | 2020-12-27 | Madera | California | 6039 | 9908 | 116 |
865473 | 865473 | 2020-12-26 | Madera | California | 6039 | 9770 | 116 |
862228 | 862228 | 2020-12-25 | Madera | California | 6039 | 9547 | 116 |
858983 | 858983 | 2020-12-24 | Madera | California | 6039 | 9371 | 116 |
855738 | 855738 | 2020-12-23 | Madera | California | 6039 | 9305 | 116 |
852493 | 852493 | 2020-12-22 | Madera | California | 6039 | 9150 | 111 |
849248 | 849248 | 2020-12-21 | Madera | California | 6039 | 8995 | 111 |
846003 | 846003 | 2020-12-20 | Madera | California | 6039 | 8717 | 111 |
842757 | 842757 | 2020-12-19 | Madera | California | 6039 | 8609 | 111 |
839512 | 839512 | 2020-12-18 | Madera | California | 6039 | 8574 | 111 |
836267 | 836267 | 2020-12-17 | Madera | California | 6039 | 8441 | 111 |
833021 | 833021 | 2020-12-16 | Madera | California | 6039 | 8269 | 111 |
829774 | 829774 | 2020-12-15 | Madera | California | 6039 | 8120 | 107 |
826528 | 826528 | 2020-12-14 | Madera | California | 6039 | 8019 | 107 |
823281 | 823281 | 2020-12-13 | Madera | California | 6039 | 7765 | 107 |
820035 | 820035 | 2020-12-12 | Madera | California | 6039 | 7648 | 107 |
816789 | 816789 | 2020-12-11 | Madera | California | 6039 | 7612 | 107 |
813543 | 813543 | 2020-12-10 | Madera | California | 6039 | 7468 | 107 |
810299 | 810299 | 2020-12-09 | Madera | California | 6039 | 7251 | 107 |
807054 | 807054 | 2020-12-08 | Madera | California | 6039 | 7115 | 107 |
803809 | 803809 | 2020-12-07 | Madera | California | 6039 | 6940 | 90 |
800564 | 800564 | 2020-12-06 | Madera | California | 6039 | 6619 | 90 |
797319 | 797319 | 2020-12-05 | Madera | California | 6039 | 6537 | 90 |
794074 | 794074 | 2020-12-04 | Madera | California | 6039 | 6537 | 90 |
790829 | 790829 | 2020-12-03 | Madera | California | 6039 | 6482 | 90 |
787584 | 787584 | 2020-12-02 | Madera | California | 6039 | 6427 | 86 |
784340 | 784340 | 2020-12-01 | Madera | California | 6039 | 6346 | 86 |
781095 | 781095 | 2020-11-30 | Madera | California | 6039 | 6290 | 85 |
777849 | 777849 | 2020-11-29 | Madera | California | 6039 | 6119 | 85 |
774604 | 774604 | 2020-11-28 | Madera | California | 6039 | 6050 | 85 |
771359 | 771359 | 2020-11-27 | Madera | California | 6039 | 6047 | 85 |
768114 | 768114 | 2020-11-26 | Madera | California | 6039 | 6047 | 85 |
764868 | 764868 | 2020-11-25 | Madera | California | 6039 | 6047 | 85 |
761623 | 761623 | 2020-11-24 | Madera | California | 6039 | 5938 | 83 |
758378 | 758378 | 2020-11-23 | Madera | California | 6039 | 5885 | 80 |
755131 | 755131 | 2020-11-22 | Madera | California | 6039 | 5714 | 80 |
751885 | 751885 | 2020-11-21 | Madera | California | 6039 | 5714 | 80 |
748639 | 748639 | 2020-11-20 | Madera | California | 6039 | 5714 | 80 |
745393 | 745393 | 2020-11-19 | Madera | California | 6039 | 5624 | 79 |
742146 | 742146 | 2020-11-18 | Madera | California | 6039 | 5602 | 79 |
738899 | 738899 | 2020-11-17 | Madera | California | 6039 | 5561 | 76 |
735655 | 735655 | 2020-11-16 | Madera | California | 6039 | 5514 | 76 |
732409 | 732409 | 2020-11-15 | Madera | California | 6039 | 5426 | 76 |
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);