ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and fips = 48477 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195970 | 1195970 | 2021-04-06 | Washington | Texas | 48477 | 3872 | 89 |
1192722 | 1192722 | 2021-04-05 | Washington | Texas | 48477 | 3868 | 89 |
1189473 | 1189473 | 2021-04-04 | Washington | Texas | 48477 | 3860 | 89 |
1186226 | 1186226 | 2021-04-03 | Washington | Texas | 48477 | 3860 | 89 |
1182979 | 1182979 | 2021-04-02 | Washington | Texas | 48477 | 3854 | 88 |
1179732 | 1179732 | 2021-04-01 | Washington | Texas | 48477 | 3844 | 87 |
1176485 | 1176485 | 2021-03-31 | Washington | Texas | 48477 | 3839 | 86 |
1173238 | 1173238 | 2021-03-30 | Washington | Texas | 48477 | 3834 | 86 |
1169991 | 1169991 | 2021-03-29 | Washington | Texas | 48477 | 3826 | 86 |
1166743 | 1166743 | 2021-03-28 | Washington | Texas | 48477 | 3810 | 86 |
1163495 | 1163495 | 2021-03-27 | Washington | Texas | 48477 | 3810 | 86 |
1160246 | 1160246 | 2021-03-26 | Washington | Texas | 48477 | 3805 | 86 |
1156999 | 1156999 | 2021-03-25 | Washington | Texas | 48477 | 3800 | 86 |
1153752 | 1153752 | 2021-03-24 | Washington | Texas | 48477 | 3794 | 86 |
1150505 | 1150505 | 2021-03-23 | Washington | Texas | 48477 | 3787 | 86 |
1147258 | 1147258 | 2021-03-22 | Washington | Texas | 48477 | 3787 | 86 |
1144011 | 1144011 | 2021-03-21 | Washington | Texas | 48477 | 3773 | 86 |
1140764 | 1140764 | 2021-03-20 | Washington | Texas | 48477 | 3773 | 86 |
1137518 | 1137518 | 2021-03-19 | Washington | Texas | 48477 | 3767 | 86 |
1134272 | 1134272 | 2021-03-18 | Washington | Texas | 48477 | 3769 | 85 |
1131024 | 1131024 | 2021-03-17 | Washington | Texas | 48477 | 3767 | 84 |
1127777 | 1127777 | 2021-03-16 | Washington | Texas | 48477 | 3754 | 84 |
1124531 | 1124531 | 2021-03-15 | Washington | Texas | 48477 | 3754 | 84 |
1121285 | 1121285 | 2021-03-14 | Washington | Texas | 48477 | 3739 | 84 |
1118038 | 1118038 | 2021-03-13 | Washington | Texas | 48477 | 3739 | 84 |
1114791 | 1114791 | 2021-03-12 | Washington | Texas | 48477 | 3730 | 84 |
1111545 | 1111545 | 2021-03-11 | Washington | Texas | 48477 | 3718 | 84 |
1108299 | 1108299 | 2021-03-10 | Washington | Texas | 48477 | 3708 | 84 |
1105053 | 1105053 | 2021-03-09 | Washington | Texas | 48477 | 3708 | 84 |
1101807 | 1101807 | 2021-03-08 | Washington | Texas | 48477 | 3702 | 84 |
1098561 | 1098561 | 2021-03-07 | Washington | Texas | 48477 | 3688 | 84 |
1095313 | 1095313 | 2021-03-06 | Washington | Texas | 48477 | 3688 | 84 |
1092067 | 1092067 | 2021-03-05 | Washington | Texas | 48477 | 3684 | 84 |
1088821 | 1088821 | 2021-03-04 | Washington | Texas | 48477 | 3681 | 84 |
1085576 | 1085576 | 2021-03-03 | Washington | Texas | 48477 | 3677 | 84 |
1082330 | 1082330 | 2021-03-02 | Washington | Texas | 48477 | 3676 | 84 |
1079084 | 1079084 | 2021-03-01 | Washington | Texas | 48477 | 3668 | 83 |
1075839 | 1075839 | 2021-02-28 | Washington | Texas | 48477 | 3650 | 83 |
1072593 | 1072593 | 2021-02-27 | Washington | Texas | 48477 | 3650 | 83 |
1069347 | 1069347 | 2021-02-26 | Washington | Texas | 48477 | 3644 | 82 |
1066102 | 1066102 | 2021-02-25 | Washington | Texas | 48477 | 3634 | 81 |
1062857 | 1062857 | 2021-02-24 | Washington | Texas | 48477 | 3627 | 81 |
1059612 | 1059612 | 2021-02-23 | Washington | Texas | 48477 | 3616 | 81 |
1056366 | 1056366 | 2021-02-22 | Washington | Texas | 48477 | 3610 | 80 |
1053120 | 1053120 | 2021-02-21 | Washington | Texas | 48477 | 3605 | 80 |
1049873 | 1049873 | 2021-02-20 | Washington | Texas | 48477 | 3605 | 80 |
1046626 | 1046626 | 2021-02-19 | Washington | Texas | 48477 | 3603 | 80 |
1043381 | 1043381 | 2021-02-18 | Washington | Texas | 48477 | 3600 | 80 |
1040136 | 1040136 | 2021-02-17 | Washington | Texas | 48477 | 3599 | 80 |
1036891 | 1036891 | 2021-02-16 | Washington | Texas | 48477 | 3595 | 80 |
1033646 | 1033646 | 2021-02-15 | Washington | Texas | 48477 | 3569 | 80 |
1030400 | 1030400 | 2021-02-14 | Washington | Texas | 48477 | 3569 | 80 |
1027153 | 1027153 | 2021-02-13 | Washington | Texas | 48477 | 3570 | 80 |
1023908 | 1023908 | 2021-02-12 | Washington | Texas | 48477 | 3561 | 80 |
1020663 | 1020663 | 2021-02-11 | Washington | Texas | 48477 | 3540 | 80 |
1017418 | 1017418 | 2021-02-10 | Washington | Texas | 48477 | 3524 | 80 |
1014173 | 1014173 | 2021-02-09 | Washington | Texas | 48477 | 3522 | 79 |
1010928 | 1010928 | 2021-02-08 | Washington | Texas | 48477 | 3489 | 79 |
1007682 | 1007682 | 2021-02-07 | Washington | Texas | 48477 | 3465 | 79 |
1004436 | 1004436 | 2021-02-06 | Washington | Texas | 48477 | 3465 | 79 |
1001190 | 1001190 | 2021-02-05 | Washington | Texas | 48477 | 3450 | 79 |
997944 | 997944 | 2021-02-04 | Washington | Texas | 48477 | 3424 | 78 |
994698 | 994698 | 2021-02-03 | Washington | Texas | 48477 | 3417 | 77 |
991452 | 991452 | 2021-02-02 | Washington | Texas | 48477 | 3395 | 76 |
988206 | 988206 | 2021-02-01 | Washington | Texas | 48477 | 3305 | 73 |
984959 | 984959 | 2021-01-31 | Washington | Texas | 48477 | 1770 | 73 |
981712 | 981712 | 2021-01-30 | Washington | Texas | 48477 | 1768 | 73 |
978466 | 978466 | 2021-01-29 | Washington | Texas | 48477 | 1757 | 73 |
975221 | 975221 | 2021-01-28 | Washington | Texas | 48477 | 1738 | 73 |
971976 | 971976 | 2021-01-27 | Washington | Texas | 48477 | 1735 | 73 |
968731 | 968731 | 2021-01-26 | Washington | Texas | 48477 | 1735 | 73 |
965487 | 965487 | 2021-01-25 | Washington | Texas | 48477 | 1724 | 73 |
962242 | 962242 | 2021-01-24 | Washington | Texas | 48477 | 1722 | 73 |
958997 | 958997 | 2021-01-23 | Washington | Texas | 48477 | 1722 | 72 |
955751 | 955751 | 2021-01-22 | Washington | Texas | 48477 | 1698 | 72 |
952506 | 952506 | 2021-01-21 | Washington | Texas | 48477 | 1680 | 72 |
949261 | 949261 | 2021-01-20 | Washington | Texas | 48477 | 1677 | 71 |
946015 | 946015 | 2021-01-19 | Washington | Texas | 48477 | 1668 | 69 |
942768 | 942768 | 2021-01-18 | Washington | Texas | 48477 | 1665 | 69 |
939523 | 939523 | 2021-01-17 | Washington | Texas | 48477 | 1665 | 69 |
936278 | 936278 | 2021-01-16 | Washington | Texas | 48477 | 1665 | 69 |
933033 | 933033 | 2021-01-15 | Washington | Texas | 48477 | 1641 | 69 |
929788 | 929788 | 2021-01-14 | Washington | Texas | 48477 | 1631 | 69 |
926543 | 926543 | 2021-01-13 | Washington | Texas | 48477 | 1626 | 69 |
923297 | 923297 | 2021-01-12 | Washington | Texas | 48477 | 1624 | 66 |
920052 | 920052 | 2021-01-11 | Washington | Texas | 48477 | 1624 | 64 |
916807 | 916807 | 2021-01-10 | Washington | Texas | 48477 | 1624 | 64 |
913562 | 913562 | 2021-01-09 | Washington | Texas | 48477 | 1624 | 64 |
910317 | 910317 | 2021-01-08 | Washington | Texas | 48477 | 1614 | 61 |
907072 | 907072 | 2021-01-07 | Washington | Texas | 48477 | 1588 | 61 |
903826 | 903826 | 2021-01-06 | Washington | Texas | 48477 | 1567 | 61 |
900581 | 900581 | 2021-01-05 | Washington | Texas | 48477 | 1532 | 61 |
897336 | 897336 | 2021-01-04 | Washington | Texas | 48477 | 1516 | 60 |
894090 | 894090 | 2021-01-03 | Washington | Texas | 48477 | 1516 | 60 |
890844 | 890844 | 2021-01-02 | Washington | Texas | 48477 | 1513 | 60 |
887597 | 887597 | 2021-01-01 | Washington | Texas | 48477 | 1513 | 60 |
884352 | 884352 | 2020-12-31 | Washington | Texas | 48477 | 1481 | 60 |
881107 | 881107 | 2020-12-30 | Washington | Texas | 48477 | 1416 | 59 |
877862 | 877862 | 2020-12-29 | Washington | Texas | 48477 | 1407 | 59 |
874617 | 874617 | 2020-12-28 | Washington | Texas | 48477 | 1386 | 59 |
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);