ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where fips = 48507 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280420 | 1280420 | 2021-05-02 | Zavala | Texas | 48507 | 1856 | 43 |
1277173 | 1277173 | 2021-05-01 | Zavala | Texas | 48507 | 1856 | 43 |
1273926 | 1273926 | 2021-04-30 | Zavala | Texas | 48507 | 1856 | 43 |
1270679 | 1270679 | 2021-04-29 | Zavala | Texas | 48507 | 1856 | 43 |
1267432 | 1267432 | 2021-04-28 | Zavala | Texas | 48507 | 1856 | 43 |
1264185 | 1264185 | 2021-04-27 | Zavala | Texas | 48507 | 1855 | 43 |
1260938 | 1260938 | 2021-04-26 | Zavala | Texas | 48507 | 1853 | 43 |
1257691 | 1257691 | 2021-04-25 | Zavala | Texas | 48507 | 1853 | 43 |
1254444 | 1254444 | 2021-04-24 | Zavala | Texas | 48507 | 1853 | 43 |
1251197 | 1251197 | 2021-04-23 | Zavala | Texas | 48507 | 1853 | 43 |
1247950 | 1247950 | 2021-04-22 | Zavala | Texas | 48507 | 1853 | 43 |
1244703 | 1244703 | 2021-04-21 | Zavala | Texas | 48507 | 1853 | 43 |
1241456 | 1241456 | 2021-04-20 | Zavala | Texas | 48507 | 1852 | 43 |
1238209 | 1238209 | 2021-04-19 | Zavala | Texas | 48507 | 1852 | 43 |
1234962 | 1234962 | 2021-04-18 | Zavala | Texas | 48507 | 1852 | 43 |
1231714 | 1231714 | 2021-04-17 | Zavala | Texas | 48507 | 1852 | 43 |
1228466 | 1228466 | 2021-04-16 | Zavala | Texas | 48507 | 1852 | 43 |
1225218 | 1225218 | 2021-04-15 | Zavala | Texas | 48507 | 1852 | 43 |
1221971 | 1221971 | 2021-04-14 | Zavala | Texas | 48507 | 1850 | 43 |
1218723 | 1218723 | 2021-04-13 | Zavala | Texas | 48507 | 1849 | 43 |
1215475 | 1215475 | 2021-04-12 | Zavala | Texas | 48507 | 1849 | 43 |
1212228 | 1212228 | 2021-04-11 | Zavala | Texas | 48507 | 1849 | 43 |
1208979 | 1208979 | 2021-04-10 | Zavala | Texas | 48507 | 1849 | 43 |
1205731 | 1205731 | 2021-04-09 | Zavala | Texas | 48507 | 1848 | 43 |
1202483 | 1202483 | 2021-04-08 | Zavala | Texas | 48507 | 1847 | 43 |
1199234 | 1199234 | 2021-04-07 | Zavala | Texas | 48507 | 1847 | 43 |
1195985 | 1195985 | 2021-04-06 | Zavala | Texas | 48507 | 1846 | 43 |
1192737 | 1192737 | 2021-04-05 | Zavala | Texas | 48507 | 1846 | 43 |
1189488 | 1189488 | 2021-04-04 | Zavala | Texas | 48507 | 1846 | 43 |
1186241 | 1186241 | 2021-04-03 | Zavala | Texas | 48507 | 1846 | 43 |
1182994 | 1182994 | 2021-04-02 | Zavala | Texas | 48507 | 1846 | 43 |
1179747 | 1179747 | 2021-04-01 | Zavala | Texas | 48507 | 1844 | 43 |
1176500 | 1176500 | 2021-03-31 | Zavala | Texas | 48507 | 1844 | 43 |
1173253 | 1173253 | 2021-03-30 | Zavala | Texas | 48507 | 1844 | 43 |
1170006 | 1170006 | 2021-03-29 | Zavala | Texas | 48507 | 1842 | 43 |
1166758 | 1166758 | 2021-03-28 | Zavala | Texas | 48507 | 1842 | 43 |
1163510 | 1163510 | 2021-03-27 | Zavala | Texas | 48507 | 1842 | 43 |
1160261 | 1160261 | 2021-03-26 | Zavala | Texas | 48507 | 1838 | 43 |
1157014 | 1157014 | 2021-03-25 | Zavala | Texas | 48507 | 1838 | 43 |
1153767 | 1153767 | 2021-03-24 | Zavala | Texas | 48507 | 1838 | 43 |
1150520 | 1150520 | 2021-03-23 | Zavala | Texas | 48507 | 1835 | 43 |
1147273 | 1147273 | 2021-03-22 | Zavala | Texas | 48507 | 1835 | 43 |
1144026 | 1144026 | 2021-03-21 | Zavala | Texas | 48507 | 1835 | 43 |
1140779 | 1140779 | 2021-03-20 | Zavala | Texas | 48507 | 1835 | 43 |
1137533 | 1137533 | 2021-03-19 | Zavala | Texas | 48507 | 1835 | 43 |
1134287 | 1134287 | 2021-03-18 | Zavala | Texas | 48507 | 1834 | 43 |
1131039 | 1131039 | 2021-03-17 | Zavala | Texas | 48507 | 1833 | 43 |
1127792 | 1127792 | 2021-03-16 | Zavala | Texas | 48507 | 1831 | 43 |
1124546 | 1124546 | 2021-03-15 | Zavala | Texas | 48507 | 1831 | 43 |
1121300 | 1121300 | 2021-03-14 | Zavala | Texas | 48507 | 1831 | 39 |
1118053 | 1118053 | 2021-03-13 | Zavala | Texas | 48507 | 1831 | 39 |
1114806 | 1114806 | 2021-03-12 | Zavala | Texas | 48507 | 1832 | 39 |
1111560 | 1111560 | 2021-03-11 | Zavala | Texas | 48507 | 1830 | 39 |
1108314 | 1108314 | 2021-03-10 | Zavala | Texas | 48507 | 1826 | 39 |
1105068 | 1105068 | 2021-03-09 | Zavala | Texas | 48507 | 1826 | 39 |
1101822 | 1101822 | 2021-03-08 | Zavala | Texas | 48507 | 1826 | 39 |
1098576 | 1098576 | 2021-03-07 | Zavala | Texas | 48507 | 1835 | 39 |
1095328 | 1095328 | 2021-03-06 | Zavala | Texas | 48507 | 1835 | 39 |
1092082 | 1092082 | 2021-03-05 | Zavala | Texas | 48507 | 1835 | 37 |
1088836 | 1088836 | 2021-03-04 | Zavala | Texas | 48507 | 1835 | 37 |
1085591 | 1085591 | 2021-03-03 | Zavala | Texas | 48507 | 1835 | 37 |
1082345 | 1082345 | 2021-03-02 | Zavala | Texas | 48507 | 1835 | 37 |
1079099 | 1079099 | 2021-03-01 | Zavala | Texas | 48507 | 1835 | 37 |
1075854 | 1075854 | 2021-02-28 | Zavala | Texas | 48507 | 1835 | 37 |
1072608 | 1072608 | 2021-02-27 | Zavala | Texas | 48507 | 1835 | 37 |
1069362 | 1069362 | 2021-02-26 | Zavala | Texas | 48507 | 1835 | 37 |
1066117 | 1066117 | 2021-02-25 | Zavala | Texas | 48507 | 1804 | 37 |
1062872 | 1062872 | 2021-02-24 | Zavala | Texas | 48507 | 1798 | 36 |
1059627 | 1059627 | 2021-02-23 | Zavala | Texas | 48507 | 1793 | 35 |
1056381 | 1056381 | 2021-02-22 | Zavala | Texas | 48507 | 1750 | 35 |
1053135 | 1053135 | 2021-02-21 | Zavala | Texas | 48507 | 1750 | 35 |
1049888 | 1049888 | 2021-02-20 | Zavala | Texas | 48507 | 1750 | 35 |
1046641 | 1046641 | 2021-02-19 | Zavala | Texas | 48507 | 1750 | 35 |
1043396 | 1043396 | 2021-02-18 | Zavala | Texas | 48507 | 1746 | 35 |
1040151 | 1040151 | 2021-02-17 | Zavala | Texas | 48507 | 1746 | 35 |
1036906 | 1036906 | 2021-02-16 | Zavala | Texas | 48507 | 1746 | 35 |
1033661 | 1033661 | 2021-02-15 | Zavala | Texas | 48507 | 1746 | 35 |
1030415 | 1030415 | 2021-02-14 | Zavala | Texas | 48507 | 1746 | 35 |
1027168 | 1027168 | 2021-02-13 | Zavala | Texas | 48507 | 1746 | 35 |
1023923 | 1023923 | 2021-02-12 | Zavala | Texas | 48507 | 1726 | 35 |
1020678 | 1020678 | 2021-02-11 | Zavala | Texas | 48507 | 1697 | 35 |
1017433 | 1017433 | 2021-02-10 | Zavala | Texas | 48507 | 1690 | 33 |
1014188 | 1014188 | 2021-02-09 | Zavala | Texas | 48507 | 1654 | 32 |
1010943 | 1010943 | 2021-02-08 | Zavala | Texas | 48507 | 1629 | 32 |
1007697 | 1007697 | 2021-02-07 | Zavala | Texas | 48507 | 1629 | 32 |
1004451 | 1004451 | 2021-02-06 | Zavala | Texas | 48507 | 1629 | 32 |
1001205 | 1001205 | 2021-02-05 | Zavala | Texas | 48507 | 1624 | 32 |
997959 | 997959 | 2021-02-04 | Zavala | Texas | 48507 | 1611 | 31 |
994713 | 994713 | 2021-02-03 | Zavala | Texas | 48507 | 1603 | 31 |
991467 | 991467 | 2021-02-02 | Zavala | Texas | 48507 | 1549 | 31 |
988221 | 988221 | 2021-02-01 | Zavala | Texas | 48507 | 1545 | 30 |
984974 | 984974 | 2021-01-31 | Zavala | Texas | 48507 | 1545 | 30 |
981727 | 981727 | 2021-01-30 | Zavala | Texas | 48507 | 1545 | 30 |
978481 | 978481 | 2021-01-29 | Zavala | Texas | 48507 | 1468 | 30 |
975236 | 975236 | 2021-01-28 | Zavala | Texas | 48507 | 1464 | 30 |
971991 | 971991 | 2021-01-27 | Zavala | Texas | 48507 | 1422 | 28 |
968746 | 968746 | 2021-01-26 | Zavala | Texas | 48507 | 1412 | 28 |
965502 | 965502 | 2021-01-25 | Zavala | Texas | 48507 | 1391 | 28 |
962257 | 962257 | 2021-01-24 | Zavala | Texas | 48507 | 1391 | 28 |
959012 | 959012 | 2021-01-23 | Zavala | Texas | 48507 | 1391 | 28 |
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);