ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Shasta" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193339 | 1193339 | 2021-04-06 | Shasta | California | 6089 | 11463 | 208 |
1190089 | 1190089 | 2021-04-05 | Shasta | California | 6089 | 11433 | 208 |
1186842 | 1186842 | 2021-04-04 | Shasta | California | 6089 | 11418 | 207 |
1183595 | 1183595 | 2021-04-03 | Shasta | California | 6089 | 11381 | 207 |
1180348 | 1180348 | 2021-04-02 | Shasta | California | 6089 | 11381 | 207 |
1177101 | 1177101 | 2021-04-01 | Shasta | California | 6089 | 11353 | 207 |
1173854 | 1173854 | 2021-03-31 | Shasta | California | 6089 | 11353 | 207 |
1170607 | 1170607 | 2021-03-30 | Shasta | California | 6089 | 11389 | 204 |
1167359 | 1167359 | 2021-03-29 | Shasta | California | 6089 | 11319 | 200 |
1164111 | 1164111 | 2021-03-28 | Shasta | California | 6089 | 11319 | 200 |
1160863 | 1160863 | 2021-03-27 | Shasta | California | 6089 | 11319 | 200 |
1157615 | 1157615 | 2021-03-26 | Shasta | California | 6089 | 11319 | 200 |
1154368 | 1154368 | 2021-03-25 | Shasta | California | 6089 | 11319 | 200 |
1151121 | 1151121 | 2021-03-24 | Shasta | California | 6089 | 11307 | 200 |
1147874 | 1147874 | 2021-03-23 | Shasta | California | 6089 | 11218 | 200 |
1144627 | 1144627 | 2021-03-22 | Shasta | California | 6089 | 11215 | 199 |
1141380 | 1141380 | 2021-03-21 | Shasta | California | 6089 | 11211 | 195 |
1138134 | 1138134 | 2021-03-20 | Shasta | California | 6089 | 11113 | 195 |
1134888 | 1134888 | 2021-03-19 | Shasta | California | 6089 | 11113 | 195 |
1131641 | 1131641 | 2021-03-18 | Shasta | California | 6089 | 11113 | 195 |
1128393 | 1128393 | 2021-03-17 | Shasta | California | 6089 | 11084 | 194 |
1125147 | 1125147 | 2021-03-16 | Shasta | California | 6089 | 11192 | 192 |
1121901 | 1121901 | 2021-03-15 | Shasta | California | 6089 | 11192 | 192 |
1118654 | 1118654 | 2021-03-14 | Shasta | California | 6089 | 11163 | 188 |
1115407 | 1115407 | 2021-03-13 | Shasta | California | 6089 | 11163 | 188 |
1112161 | 1112161 | 2021-03-12 | Shasta | California | 6089 | 11163 | 188 |
1108915 | 1108915 | 2021-03-11 | Shasta | California | 6089 | 11149 | 182 |
1105669 | 1105669 | 2021-03-10 | Shasta | California | 6089 | 11149 | 182 |
1102423 | 1102423 | 2021-03-09 | Shasta | California | 6089 | 11137 | 179 |
1099177 | 1099177 | 2021-03-08 | Shasta | California | 6089 | 11102 | 179 |
1095929 | 1095929 | 2021-03-07 | Shasta | California | 6089 | 11086 | 179 |
1092683 | 1092683 | 2021-03-06 | Shasta | California | 6089 | 11086 | 179 |
1089437 | 1089437 | 2021-03-05 | Shasta | California | 6089 | 11086 | 179 |
1086192 | 1086192 | 2021-03-04 | Shasta | California | 6089 | 11086 | 179 |
1082946 | 1082946 | 2021-03-03 | Shasta | California | 6089 | 11054 | 179 |
1079700 | 1079700 | 2021-03-02 | Shasta | California | 6089 | 11017 | 174 |
1076455 | 1076455 | 2021-03-01 | Shasta | California | 6089 | 11017 | 174 |
1073209 | 1073209 | 2021-02-28 | Shasta | California | 6089 | 10985 | 174 |
1069963 | 1069963 | 2021-02-27 | Shasta | California | 6089 | 10972 | 174 |
1066718 | 1066718 | 2021-02-26 | Shasta | California | 6089 | 10969 | 174 |
1063473 | 1063473 | 2021-02-25 | Shasta | California | 6089 | 10944 | 174 |
1060228 | 1060228 | 2021-02-24 | Shasta | California | 6089 | 10950 | 172 |
1056982 | 1056982 | 2021-02-23 | Shasta | California | 6089 | 10909 | 172 |
1053736 | 1053736 | 2021-02-22 | Shasta | California | 6089 | 10868 | 172 |
1050489 | 1050489 | 2021-02-21 | Shasta | California | 6089 | 10868 | 172 |
1047242 | 1047242 | 2021-02-20 | Shasta | California | 6089 | 10868 | 172 |
1043997 | 1043997 | 2021-02-19 | Shasta | California | 6089 | 10868 | 172 |
1040752 | 1040752 | 2021-02-18 | Shasta | California | 6089 | 10834 | 171 |
1037507 | 1037507 | 2021-02-17 | Shasta | California | 6089 | 10810 | 171 |
1034262 | 1034262 | 2021-02-16 | Shasta | California | 6089 | 10810 | 171 |
1031016 | 1031016 | 2021-02-15 | Shasta | California | 6089 | 10720 | 170 |
1027769 | 1027769 | 2021-02-14 | Shasta | California | 6089 | 10718 | 170 |
1024524 | 1024524 | 2021-02-13 | Shasta | California | 6089 | 10718 | 170 |
1021279 | 1021279 | 2021-02-12 | Shasta | California | 6089 | 10718 | 170 |
1018034 | 1018034 | 2021-02-11 | Shasta | California | 6089 | 10718 | 170 |
1014789 | 1014789 | 2021-02-10 | Shasta | California | 6089 | 10753 | 164 |
1011544 | 1011544 | 2021-02-09 | Shasta | California | 6089 | 10700 | 161 |
1008298 | 1008298 | 2021-02-08 | Shasta | California | 6089 | 10632 | 161 |
1005052 | 1005052 | 2021-02-07 | Shasta | California | 6089 | 10632 | 161 |
1001806 | 1001806 | 2021-02-06 | Shasta | California | 6089 | 10632 | 161 |
998560 | 998560 | 2021-02-05 | Shasta | California | 6089 | 10632 | 161 |
995314 | 995314 | 2021-02-04 | Shasta | California | 6089 | 10573 | 157 |
992068 | 992068 | 2021-02-03 | Shasta | California | 6089 | 10524 | 153 |
988822 | 988822 | 2021-02-02 | Shasta | California | 6089 | 10534 | 150 |
985575 | 985575 | 2021-02-01 | Shasta | California | 6089 | 10438 | 145 |
982328 | 982328 | 2021-01-31 | Shasta | California | 6089 | 10333 | 142 |
979082 | 979082 | 2021-01-30 | Shasta | California | 6089 | 10333 | 142 |
975837 | 975837 | 2021-01-29 | Shasta | California | 6089 | 10333 | 142 |
972592 | 972592 | 2021-01-28 | Shasta | California | 6089 | 10281 | 138 |
969347 | 969347 | 2021-01-27 | Shasta | California | 6089 | 10212 | 138 |
966103 | 966103 | 2021-01-26 | Shasta | California | 6089 | 10144 | 132 |
962858 | 962858 | 2021-01-25 | Shasta | California | 6089 | 10054 | 129 |
959613 | 959613 | 2021-01-24 | Shasta | California | 6089 | 9951 | 129 |
956367 | 956367 | 2021-01-23 | Shasta | California | 6089 | 9920 | 129 |
953122 | 953122 | 2021-01-22 | Shasta | California | 6089 | 9920 | 129 |
949877 | 949877 | 2021-01-21 | Shasta | California | 6089 | 9750 | 123 |
946631 | 946631 | 2021-01-20 | Shasta | California | 6089 | 9750 | 123 |
943384 | 943384 | 2021-01-19 | Shasta | California | 6089 | 9600 | 117 |
940139 | 940139 | 2021-01-18 | Shasta | California | 6089 | 9594 | 117 |
936894 | 936894 | 2021-01-17 | Shasta | California | 6089 | 9594 | 117 |
933649 | 933649 | 2021-01-16 | Shasta | California | 6089 | 9594 | 117 |
930404 | 930404 | 2021-01-15 | Shasta | California | 6089 | 9594 | 117 |
927159 | 927159 | 2021-01-14 | Shasta | California | 6089 | 9450 | 111 |
923913 | 923913 | 2021-01-13 | Shasta | California | 6089 | 9315 | 103 |
920668 | 920668 | 2021-01-12 | Shasta | California | 6089 | 9315 | 103 |
917423 | 917423 | 2021-01-11 | Shasta | California | 6089 | 8936 | 99 |
914178 | 914178 | 2021-01-10 | Shasta | California | 6089 | 8917 | 99 |
910933 | 910933 | 2021-01-09 | Shasta | California | 6089 | 8917 | 99 |
907688 | 907688 | 2021-01-08 | Shasta | California | 6089 | 8917 | 99 |
904442 | 904442 | 2021-01-07 | Shasta | California | 6089 | 8741 | 95 |
901197 | 901197 | 2021-01-06 | Shasta | California | 6089 | 8574 | 89 |
897952 | 897952 | 2021-01-05 | Shasta | California | 6089 | 8463 | 79 |
894707 | 894707 | 2021-01-04 | Shasta | California | 6089 | 8268 | 78 |
891460 | 891460 | 2021-01-03 | Shasta | California | 6089 | 8154 | 78 |
888213 | 888213 | 2021-01-02 | Shasta | California | 6089 | 8102 | 78 |
884968 | 884968 | 2021-01-01 | Shasta | California | 6089 | 8060 | 78 |
881723 | 881723 | 2020-12-31 | Shasta | California | 6089 | 8060 | 78 |
878478 | 878478 | 2020-12-30 | Shasta | California | 6089 | 7782 | 73 |
875233 | 875233 | 2020-12-29 | Shasta | California | 6089 | 7918 | 73 |
871988 | 871988 | 2020-12-28 | Shasta | California | 6089 | 7792 | 70 |
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);