ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and fips = 51191 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1186415 | 1186415 | 2021-04-03 | Washington | Virginia | 51191 | 4504 | 100 |
1183168 | 1183168 | 2021-04-02 | Washington | Virginia | 51191 | 4503 | 100 |
1179921 | 1179921 | 2021-04-01 | Washington | Virginia | 51191 | 4490 | 100 |
1176674 | 1176674 | 2021-03-31 | Washington | Virginia | 51191 | 4482 | 100 |
1173427 | 1173427 | 2021-03-30 | Washington | Virginia | 51191 | 4468 | 100 |
1170180 | 1170180 | 2021-03-29 | Washington | Virginia | 51191 | 4456 | 100 |
1166932 | 1166932 | 2021-03-28 | Washington | Virginia | 51191 | 4457 | 100 |
1163684 | 1163684 | 2021-03-27 | Washington | Virginia | 51191 | 4450 | 100 |
1160436 | 1160436 | 2021-03-26 | Washington | Virginia | 51191 | 4441 | 100 |
1157188 | 1157188 | 2021-03-25 | Washington | Virginia | 51191 | 4436 | 100 |
1153941 | 1153941 | 2021-03-24 | Washington | Virginia | 51191 | 4417 | 100 |
1150694 | 1150694 | 2021-03-23 | Washington | Virginia | 51191 | 4410 | 100 |
1147447 | 1147447 | 2021-03-22 | Washington | Virginia | 51191 | 4406 | 100 |
1144200 | 1144200 | 2021-03-21 | Washington | Virginia | 51191 | 4407 | 100 |
1140953 | 1140953 | 2021-03-20 | Washington | Virginia | 51191 | 4403 | 100 |
1137707 | 1137707 | 2021-03-19 | Washington | Virginia | 51191 | 4400 | 100 |
1134461 | 1134461 | 2021-03-18 | Washington | Virginia | 51191 | 4392 | 102 |
1131213 | 1131213 | 2021-03-17 | Washington | Virginia | 51191 | 4383 | 102 |
1127966 | 1127966 | 2021-03-16 | Washington | Virginia | 51191 | 4372 | 102 |
1124720 | 1124720 | 2021-03-15 | Washington | Virginia | 51191 | 4364 | 102 |
1121474 | 1121474 | 2021-03-14 | Washington | Virginia | 51191 | 4359 | 102 |
1118227 | 1118227 | 2021-03-13 | Washington | Virginia | 51191 | 4357 | 102 |
1114980 | 1114980 | 2021-03-12 | Washington | Virginia | 51191 | 4352 | 101 |
1111734 | 1111734 | 2021-03-11 | Washington | Virginia | 51191 | 4350 | 101 |
1108488 | 1108488 | 2021-03-10 | Washington | Virginia | 51191 | 4330 | 101 |
1105242 | 1105242 | 2021-03-09 | Washington | Virginia | 51191 | 4318 | 101 |
1101996 | 1101996 | 2021-03-08 | Washington | Virginia | 51191 | 4314 | 100 |
1098750 | 1098750 | 2021-03-07 | Washington | Virginia | 51191 | 4311 | 99 |
1095502 | 1095502 | 2021-03-06 | Washington | Virginia | 51191 | 4307 | 99 |
1092256 | 1092256 | 2021-03-05 | Washington | Virginia | 51191 | 4301 | 99 |
1089010 | 1089010 | 2021-03-04 | Washington | Virginia | 51191 | 4291 | 98 |
1085765 | 1085765 | 2021-03-03 | Washington | Virginia | 51191 | 4287 | 98 |
1082519 | 1082519 | 2021-03-02 | Washington | Virginia | 51191 | 4278 | 95 |
1079273 | 1079273 | 2021-03-01 | Washington | Virginia | 51191 | 4272 | 95 |
1076028 | 1076028 | 2021-02-28 | Washington | Virginia | 51191 | 4270 | 95 |
1072782 | 1072782 | 2021-02-27 | Washington | Virginia | 51191 | 4265 | 95 |
1069536 | 1069536 | 2021-02-26 | Washington | Virginia | 51191 | 4256 | 95 |
1066291 | 1066291 | 2021-02-25 | Washington | Virginia | 51191 | 4251 | 93 |
1063046 | 1063046 | 2021-02-24 | Washington | Virginia | 51191 | 4240 | 93 |
1059801 | 1059801 | 2021-02-23 | Washington | Virginia | 51191 | 4233 | 93 |
1056555 | 1056555 | 2021-02-22 | Washington | Virginia | 51191 | 4240 | 92 |
1053309 | 1053309 | 2021-02-21 | Washington | Virginia | 51191 | 4239 | 91 |
1050062 | 1050062 | 2021-02-20 | Washington | Virginia | 51191 | 4238 | 91 |
1046815 | 1046815 | 2021-02-19 | Washington | Virginia | 51191 | 4237 | 88 |
1043570 | 1043570 | 2021-02-18 | Washington | Virginia | 51191 | 4235 | 88 |
1040325 | 1040325 | 2021-02-17 | Washington | Virginia | 51191 | 4238 | 88 |
1037080 | 1037080 | 2021-02-16 | Washington | Virginia | 51191 | 4236 | 88 |
1033835 | 1033835 | 2021-02-15 | Washington | Virginia | 51191 | 4233 | 86 |
1030589 | 1030589 | 2021-02-14 | Washington | Virginia | 51191 | 4233 | 86 |
1027342 | 1027342 | 2021-02-13 | Washington | Virginia | 51191 | 4228 | 86 |
1024097 | 1024097 | 2021-02-12 | Washington | Virginia | 51191 | 4218 | 86 |
1020852 | 1020852 | 2021-02-11 | Washington | Virginia | 51191 | 4197 | 85 |
1017607 | 1017607 | 2021-02-10 | Washington | Virginia | 51191 | 4183 | 85 |
1014362 | 1014362 | 2021-02-09 | Washington | Virginia | 51191 | 4174 | 85 |
1011117 | 1011117 | 2021-02-08 | Washington | Virginia | 51191 | 4165 | 84 |
1007871 | 1007871 | 2021-02-07 | Washington | Virginia | 51191 | 4158 | 84 |
1004625 | 1004625 | 2021-02-06 | Washington | Virginia | 51191 | 4148 | 83 |
1001379 | 1001379 | 2021-02-05 | Washington | Virginia | 51191 | 4125 | 83 |
998133 | 998133 | 2021-02-04 | Washington | Virginia | 51191 | 4110 | 82 |
994887 | 994887 | 2021-02-03 | Washington | Virginia | 51191 | 4084 | 82 |
991641 | 991641 | 2021-02-02 | Washington | Virginia | 51191 | 4071 | 81 |
988395 | 988395 | 2021-02-01 | Washington | Virginia | 51191 | 4066 | 81 |
985148 | 985148 | 2021-01-31 | Washington | Virginia | 51191 | 4057 | 79 |
981901 | 981901 | 2021-01-30 | Washington | Virginia | 51191 | 4050 | 79 |
978655 | 978655 | 2021-01-29 | Washington | Virginia | 51191 | 4025 | 78 |
975410 | 975410 | 2021-01-28 | Washington | Virginia | 51191 | 4002 | 77 |
972165 | 972165 | 2021-01-27 | Washington | Virginia | 51191 | 3978 | 75 |
968920 | 968920 | 2021-01-26 | Washington | Virginia | 51191 | 3947 | 74 |
965676 | 965676 | 2021-01-25 | Washington | Virginia | 51191 | 3922 | 74 |
962431 | 962431 | 2021-01-24 | Washington | Virginia | 51191 | 3905 | 71 |
959186 | 959186 | 2021-01-23 | Washington | Virginia | 51191 | 3892 | 71 |
955940 | 955940 | 2021-01-22 | Washington | Virginia | 51191 | 3860 | 68 |
952695 | 952695 | 2021-01-21 | Washington | Virginia | 51191 | 3820 | 68 |
949450 | 949450 | 2021-01-20 | Washington | Virginia | 51191 | 3787 | 66 |
946204 | 946204 | 2021-01-19 | Washington | Virginia | 51191 | 3765 | 66 |
942957 | 942957 | 2021-01-18 | Washington | Virginia | 51191 | 3754 | 65 |
939712 | 939712 | 2021-01-17 | Washington | Virginia | 51191 | 3685 | 62 |
936467 | 936467 | 2021-01-16 | Washington | Virginia | 51191 | 3596 | 60 |
933222 | 933222 | 2021-01-15 | Washington | Virginia | 51191 | 3567 | 60 |
929977 | 929977 | 2021-01-14 | Washington | Virginia | 51191 | 3537 | 59 |
926732 | 926732 | 2021-01-13 | Washington | Virginia | 51191 | 3509 | 58 |
923486 | 923486 | 2021-01-12 | Washington | Virginia | 51191 | 3457 | 58 |
920241 | 920241 | 2021-01-11 | Washington | Virginia | 51191 | 3447 | 58 |
916996 | 916996 | 2021-01-10 | Washington | Virginia | 51191 | 3414 | 58 |
913751 | 913751 | 2021-01-09 | Washington | Virginia | 51191 | 3373 | 58 |
910506 | 910506 | 2021-01-08 | Washington | Virginia | 51191 | 3336 | 56 |
907261 | 907261 | 2021-01-07 | Washington | Virginia | 51191 | 3287 | 55 |
904015 | 904015 | 2021-01-06 | Washington | Virginia | 51191 | 3217 | 55 |
900770 | 900770 | 2021-01-05 | Washington | Virginia | 51191 | 3169 | 54 |
897525 | 897525 | 2021-01-04 | Washington | Virginia | 51191 | 3139 | 51 |
894279 | 894279 | 2021-01-03 | Washington | Virginia | 51191 | 3108 | 48 |
891033 | 891033 | 2021-01-02 | Washington | Virginia | 51191 | 3058 | 47 |
887786 | 887786 | 2021-01-01 | Washington | Virginia | 51191 | 3058 | 46 |
884541 | 884541 | 2020-12-31 | Washington | Virginia | 51191 | 2970 | 44 |
881296 | 881296 | 2020-12-30 | Washington | Virginia | 51191 | 2909 | 44 |
878051 | 878051 | 2020-12-29 | Washington | Virginia | 51191 | 2876 | 44 |
874806 | 874806 | 2020-12-28 | Washington | Virginia | 51191 | 2850 | 43 |
871561 | 871561 | 2020-12-27 | Washington | Virginia | 51191 | 2817 | 43 |
868316 | 868316 | 2020-12-26 | Washington | Virginia | 51191 | 2763 | 40 |
865071 | 865071 | 2020-12-25 | Washington | Virginia | 51191 | 2763 | 40 |
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);