ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and fips = 28151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194598 | 1194598 | 2021-04-06 | Washington | Mississippi | 28151 | 5270 | 132 |
1191349 | 1191349 | 2021-04-05 | Washington | Mississippi | 28151 | 5265 | 132 |
1188101 | 1188101 | 2021-04-04 | Washington | Mississippi | 28151 | 5264 | 132 |
1184854 | 1184854 | 2021-04-03 | Washington | Mississippi | 28151 | 5264 | 132 |
1181608 | 1181608 | 2021-04-02 | Washington | Mississippi | 28151 | 5264 | 132 |
1178361 | 1178361 | 2021-04-01 | Washington | Mississippi | 28151 | 5264 | 132 |
1175114 | 1175114 | 2021-03-31 | Washington | Mississippi | 28151 | 5264 | 132 |
1171867 | 1171867 | 2021-03-30 | Washington | Mississippi | 28151 | 5264 | 132 |
1168619 | 1168619 | 2021-03-29 | Washington | Mississippi | 28151 | 5263 | 132 |
1165371 | 1165371 | 2021-03-28 | Washington | Mississippi | 28151 | 5263 | 132 |
1162123 | 1162123 | 2021-03-27 | Washington | Mississippi | 28151 | 5263 | 132 |
1158875 | 1158875 | 2021-03-26 | Washington | Mississippi | 28151 | 5263 | 132 |
1155628 | 1155628 | 2021-03-25 | Washington | Mississippi | 28151 | 5262 | 132 |
1152381 | 1152381 | 2021-03-24 | Washington | Mississippi | 28151 | 5260 | 132 |
1149134 | 1149134 | 2021-03-23 | Washington | Mississippi | 28151 | 5257 | 132 |
1145887 | 1145887 | 2021-03-22 | Washington | Mississippi | 28151 | 5257 | 132 |
1142640 | 1142640 | 2021-03-21 | Washington | Mississippi | 28151 | 5257 | 132 |
1139393 | 1139393 | 2021-03-20 | Washington | Mississippi | 28151 | 5257 | 132 |
1136147 | 1136147 | 2021-03-19 | Washington | Mississippi | 28151 | 5259 | 132 |
1132901 | 1132901 | 2021-03-18 | Washington | Mississippi | 28151 | 5257 | 132 |
1129653 | 1129653 | 2021-03-17 | Washington | Mississippi | 28151 | 5255 | 132 |
1126406 | 1126406 | 2021-03-16 | Washington | Mississippi | 28151 | 5246 | 132 |
1123160 | 1123160 | 2021-03-15 | Washington | Mississippi | 28151 | 5245 | 131 |
1119913 | 1119913 | 2021-03-14 | Washington | Mississippi | 28151 | 5245 | 131 |
1116666 | 1116666 | 2021-03-13 | Washington | Mississippi | 28151 | 5245 | 131 |
1113420 | 1113420 | 2021-03-12 | Washington | Mississippi | 28151 | 5241 | 130 |
1110174 | 1110174 | 2021-03-11 | Washington | Mississippi | 28151 | 5239 | 130 |
1106928 | 1106928 | 2021-03-10 | Washington | Mississippi | 28151 | 5236 | 130 |
1103682 | 1103682 | 2021-03-09 | Washington | Mississippi | 28151 | 5236 | 130 |
1100436 | 1100436 | 2021-03-08 | Washington | Mississippi | 28151 | 5235 | 130 |
1097189 | 1097189 | 2021-03-07 | Washington | Mississippi | 28151 | 5235 | 130 |
1093942 | 1093942 | 2021-03-06 | Washington | Mississippi | 28151 | 5232 | 130 |
1090696 | 1090696 | 2021-03-05 | Washington | Mississippi | 28151 | 5229 | 130 |
1087451 | 1087451 | 2021-03-04 | Washington | Mississippi | 28151 | 5229 | 130 |
1084206 | 1084206 | 2021-03-03 | Washington | Mississippi | 28151 | 5220 | 130 |
1080960 | 1080960 | 2021-03-02 | Washington | Mississippi | 28151 | 5218 | 130 |
1077714 | 1077714 | 2021-03-01 | Washington | Mississippi | 28151 | 5218 | 130 |
1074468 | 1074468 | 2021-02-28 | Washington | Mississippi | 28151 | 5218 | 130 |
1071222 | 1071222 | 2021-02-27 | Washington | Mississippi | 28151 | 5205 | 130 |
1067977 | 1067977 | 2021-02-26 | Washington | Mississippi | 28151 | 5182 | 129 |
1064732 | 1064732 | 2021-02-25 | Washington | Mississippi | 28151 | 5159 | 128 |
1061488 | 1061488 | 2021-02-24 | Washington | Mississippi | 28151 | 5135 | 128 |
1058242 | 1058242 | 2021-02-23 | Washington | Mississippi | 28151 | 5124 | 128 |
1054996 | 1054996 | 2021-02-22 | Washington | Mississippi | 28151 | 5124 | 128 |
1051749 | 1051749 | 2021-02-21 | Washington | Mississippi | 28151 | 5123 | 128 |
1048502 | 1048502 | 2021-02-20 | Washington | Mississippi | 28151 | 5122 | 128 |
1045256 | 1045256 | 2021-02-19 | Washington | Mississippi | 28151 | 5122 | 128 |
1042011 | 1042011 | 2021-02-18 | Washington | Mississippi | 28151 | 5122 | 128 |
1038766 | 1038766 | 2021-02-17 | Washington | Mississippi | 28151 | 5122 | 128 |
1035521 | 1035521 | 2021-02-16 | Washington | Mississippi | 28151 | 5116 | 127 |
1032276 | 1032276 | 2021-02-15 | Washington | Mississippi | 28151 | 5115 | 126 |
1029029 | 1029029 | 2021-02-14 | Washington | Mississippi | 28151 | 5113 | 126 |
1025783 | 1025783 | 2021-02-13 | Washington | Mississippi | 28151 | 5090 | 126 |
1022538 | 1022538 | 2021-02-12 | Washington | Mississippi | 28151 | 5085 | 125 |
1019293 | 1019293 | 2021-02-11 | Washington | Mississippi | 28151 | 5079 | 125 |
1016048 | 1016048 | 2021-02-10 | Washington | Mississippi | 28151 | 5075 | 125 |
1012803 | 1012803 | 2021-02-09 | Washington | Mississippi | 28151 | 5075 | 125 |
1009558 | 1009558 | 2021-02-08 | Washington | Mississippi | 28151 | 5071 | 125 |
1006311 | 1006311 | 2021-02-07 | Washington | Mississippi | 28151 | 5068 | 125 |
1003065 | 1003065 | 2021-02-06 | Washington | Mississippi | 28151 | 5064 | 125 |
999820 | 999820 | 2021-02-05 | Washington | Mississippi | 28151 | 5055 | 125 |
996574 | 996574 | 2021-02-04 | Washington | Mississippi | 28151 | 5048 | 125 |
993328 | 993328 | 2021-02-03 | Washington | Mississippi | 28151 | 5042 | 125 |
990082 | 990082 | 2021-02-02 | Washington | Mississippi | 28151 | 5038 | 125 |
986835 | 986835 | 2021-02-01 | Washington | Mississippi | 28151 | 5033 | 125 |
983588 | 983588 | 2021-01-31 | Washington | Mississippi | 28151 | 5029 | 125 |
980342 | 980342 | 2021-01-30 | Washington | Mississippi | 28151 | 5024 | 125 |
977096 | 977096 | 2021-01-29 | Washington | Mississippi | 28151 | 5017 | 125 |
973851 | 973851 | 2021-01-28 | Washington | Mississippi | 28151 | 4995 | 125 |
970606 | 970606 | 2021-01-27 | Washington | Mississippi | 28151 | 4984 | 125 |
967361 | 967361 | 2021-01-26 | Washington | Mississippi | 28151 | 4965 | 125 |
964117 | 964117 | 2021-01-25 | Washington | Mississippi | 28151 | 4951 | 125 |
960872 | 960872 | 2021-01-24 | Washington | Mississippi | 28151 | 4933 | 125 |
957626 | 957626 | 2021-01-23 | Washington | Mississippi | 28151 | 4923 | 125 |
954381 | 954381 | 2021-01-22 | Washington | Mississippi | 28151 | 4904 | 125 |
951136 | 951136 | 2021-01-21 | Washington | Mississippi | 28151 | 4877 | 124 |
947890 | 947890 | 2021-01-20 | Washington | Mississippi | 28151 | 4826 | 124 |
944643 | 944643 | 2021-01-19 | Washington | Mississippi | 28151 | 4803 | 124 |
941398 | 941398 | 2021-01-18 | Washington | Mississippi | 28151 | 4800 | 123 |
938153 | 938153 | 2021-01-17 | Washington | Mississippi | 28151 | 4777 | 123 |
934908 | 934908 | 2021-01-16 | Washington | Mississippi | 28151 | 4770 | 123 |
931663 | 931663 | 2021-01-15 | Washington | Mississippi | 28151 | 4734 | 122 |
928418 | 928418 | 2021-01-14 | Washington | Mississippi | 28151 | 4700 | 122 |
925172 | 925172 | 2021-01-13 | Washington | Mississippi | 28151 | 4682 | 121 |
921927 | 921927 | 2021-01-12 | Washington | Mississippi | 28151 | 4665 | 121 |
918682 | 918682 | 2021-01-11 | Washington | Mississippi | 28151 | 4649 | 119 |
915437 | 915437 | 2021-01-10 | Washington | Mississippi | 28151 | 4639 | 119 |
912192 | 912192 | 2021-01-09 | Washington | Mississippi | 28151 | 4621 | 119 |
908947 | 908947 | 2021-01-08 | Washington | Mississippi | 28151 | 4587 | 119 |
905701 | 905701 | 2021-01-07 | Washington | Mississippi | 28151 | 4578 | 119 |
902456 | 902456 | 2021-01-06 | Washington | Mississippi | 28151 | 4526 | 119 |
899211 | 899211 | 2021-01-05 | Washington | Mississippi | 28151 | 4504 | 119 |
895966 | 895966 | 2021-01-04 | Washington | Mississippi | 28151 | 4487 | 117 |
892719 | 892719 | 2021-01-03 | Washington | Mississippi | 28151 | 4459 | 117 |
889473 | 889473 | 2021-01-02 | Washington | Mississippi | 28151 | 4375 | 116 |
886227 | 886227 | 2021-01-01 | Washington | Mississippi | 28151 | 4322 | 116 |
882982 | 882982 | 2020-12-31 | Washington | Mississippi | 28151 | 4259 | 116 |
879737 | 879737 | 2020-12-30 | Washington | Mississippi | 28151 | 4231 | 116 |
876492 | 876492 | 2020-12-29 | Washington | Mississippi | 28151 | 4196 | 116 |
873247 | 873247 | 2020-12-28 | Washington | Mississippi | 28151 | 4171 | 114 |
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);