ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6039 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193314 | 1193314 | 2021-04-06 | Madera | California | 6039 | 16065 | 236 |
1190064 | 1190064 | 2021-04-05 | Madera | California | 6039 | 16052 | 234 |
1186817 | 1186817 | 2021-04-04 | Madera | California | 6039 | 16051 | 234 |
1183570 | 1183570 | 2021-04-03 | Madera | California | 6039 | 16036 | 234 |
1180323 | 1180323 | 2021-04-02 | Madera | California | 6039 | 16023 | 234 |
1177076 | 1177076 | 2021-04-01 | Madera | California | 6039 | 16015 | 234 |
1173829 | 1173829 | 2021-03-31 | Madera | California | 6039 | 16003 | 234 |
1170582 | 1170582 | 2021-03-30 | Madera | California | 6039 | 15987 | 234 |
1167334 | 1167334 | 2021-03-29 | Madera | California | 6039 | 15973 | 231 |
1164086 | 1164086 | 2021-03-28 | Madera | California | 6039 | 15968 | 231 |
1160838 | 1160838 | 2021-03-27 | Madera | California | 6039 | 15952 | 231 |
1157590 | 1157590 | 2021-03-26 | Madera | California | 6039 | 15937 | 231 |
1154343 | 1154343 | 2021-03-25 | Madera | California | 6039 | 15918 | 231 |
1151096 | 1151096 | 2021-03-24 | Madera | California | 6039 | 15908 | 231 |
1147849 | 1147849 | 2021-03-23 | Madera | California | 6039 | 15904 | 231 |
1144602 | 1144602 | 2021-03-22 | Madera | California | 6039 | 15895 | 226 |
1141355 | 1141355 | 2021-03-21 | Madera | California | 6039 | 15891 | 226 |
1138109 | 1138109 | 2021-03-20 | Madera | California | 6039 | 15877 | 226 |
1134863 | 1134863 | 2021-03-19 | Madera | California | 6039 | 15860 | 226 |
1131616 | 1131616 | 2021-03-18 | Madera | California | 6039 | 15835 | 226 |
1128368 | 1128368 | 2021-03-17 | Madera | California | 6039 | 15822 | 226 |
1125122 | 1125122 | 2021-03-16 | Madera | California | 6039 | 15806 | 226 |
1121876 | 1121876 | 2021-03-15 | Madera | California | 6039 | 15804 | 222 |
1118629 | 1118629 | 2021-03-14 | Madera | California | 6039 | 15780 | 222 |
1115382 | 1115382 | 2021-03-13 | Madera | California | 6039 | 15761 | 222 |
1112136 | 1112136 | 2021-03-12 | Madera | California | 6039 | 15725 | 222 |
1108890 | 1108890 | 2021-03-11 | Madera | California | 6039 | 15705 | 222 |
1105644 | 1105644 | 2021-03-10 | Madera | California | 6039 | 15701 | 222 |
1102398 | 1102398 | 2021-03-09 | Madera | California | 6039 | 15691 | 222 |
1099152 | 1099152 | 2021-03-08 | Madera | California | 6039 | 15675 | 214 |
1095904 | 1095904 | 2021-03-07 | Madera | California | 6039 | 15646 | 214 |
1092658 | 1092658 | 2021-03-06 | Madera | California | 6039 | 15624 | 214 |
1089412 | 1089412 | 2021-03-05 | Madera | California | 6039 | 15596 | 214 |
1086167 | 1086167 | 2021-03-04 | Madera | California | 6039 | 15553 | 214 |
1082921 | 1082921 | 2021-03-03 | Madera | California | 6039 | 15523 | 214 |
1079675 | 1079675 | 2021-03-02 | Madera | California | 6039 | 15505 | 214 |
1076430 | 1076430 | 2021-03-01 | Madera | California | 6039 | 15496 | 214 |
1073184 | 1073184 | 2021-02-28 | Madera | California | 6039 | 15467 | 209 |
1069938 | 1069938 | 2021-02-27 | Madera | California | 6039 | 15436 | 209 |
1066693 | 1066693 | 2021-02-26 | Madera | California | 6039 | 15414 | 209 |
1063448 | 1063448 | 2021-02-25 | Madera | California | 6039 | 15390 | 209 |
1060203 | 1060203 | 2021-02-24 | Madera | California | 6039 | 15352 | 209 |
1056957 | 1056957 | 2021-02-23 | Madera | California | 6039 | 15325 | 201 |
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 |
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);