ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48325 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280329 | 1280329 | 2021-05-02 | Medina | Texas | 48325 | 4972 | 103 |
1277082 | 1277082 | 2021-05-01 | Medina | Texas | 48325 | 4972 | 103 |
1273835 | 1273835 | 2021-04-30 | Medina | Texas | 48325 | 4966 | 103 |
1270588 | 1270588 | 2021-04-29 | Medina | Texas | 48325 | 4958 | 103 |
1267341 | 1267341 | 2021-04-28 | Medina | Texas | 48325 | 4947 | 103 |
1264094 | 1264094 | 2021-04-27 | Medina | Texas | 48325 | 4945 | 103 |
1260847 | 1260847 | 2021-04-26 | Medina | Texas | 48325 | 4935 | 103 |
1257600 | 1257600 | 2021-04-25 | Medina | Texas | 48325 | 4935 | 103 |
1254353 | 1254353 | 2021-04-24 | Medina | Texas | 48325 | 4935 | 103 |
1251106 | 1251106 | 2021-04-23 | Medina | Texas | 48325 | 4936 | 103 |
1247859 | 1247859 | 2021-04-22 | Medina | Texas | 48325 | 4936 | 103 |
1244612 | 1244612 | 2021-04-21 | Medina | Texas | 48325 | 4930 | 103 |
1241365 | 1241365 | 2021-04-20 | Medina | Texas | 48325 | 4900 | 103 |
1238118 | 1238118 | 2021-04-19 | Medina | Texas | 48325 | 4888 | 103 |
1234871 | 1234871 | 2021-04-18 | Medina | Texas | 48325 | 4888 | 103 |
1231623 | 1231623 | 2021-04-17 | Medina | Texas | 48325 | 4888 | 103 |
1228375 | 1228375 | 2021-04-16 | Medina | Texas | 48325 | 4888 | 103 |
1225127 | 1225127 | 2021-04-15 | Medina | Texas | 48325 | 4889 | 103 |
1221880 | 1221880 | 2021-04-14 | Medina | Texas | 48325 | 4877 | 103 |
1218632 | 1218632 | 2021-04-13 | Medina | Texas | 48325 | 4868 | 103 |
1215384 | 1215384 | 2021-04-12 | Medina | Texas | 48325 | 4866 | 103 |
1212137 | 1212137 | 2021-04-11 | Medina | Texas | 48325 | 4866 | 103 |
1208888 | 1208888 | 2021-04-10 | Medina | Texas | 48325 | 4866 | 103 |
1205640 | 1205640 | 2021-04-09 | Medina | Texas | 48325 | 4863 | 103 |
1202392 | 1202392 | 2021-04-08 | Medina | Texas | 48325 | 4861 | 103 |
1199143 | 1199143 | 2021-04-07 | Medina | Texas | 48325 | 4858 | 103 |
1195894 | 1195894 | 2021-04-06 | Medina | Texas | 48325 | 4832 | 103 |
1192646 | 1192646 | 2021-04-05 | Medina | Texas | 48325 | 4820 | 103 |
1189397 | 1189397 | 2021-04-04 | Medina | Texas | 48325 | 4820 | 103 |
1186150 | 1186150 | 2021-04-03 | Medina | Texas | 48325 | 4820 | 103 |
1182903 | 1182903 | 2021-04-02 | Medina | Texas | 48325 | 4822 | 103 |
1179656 | 1179656 | 2021-04-01 | Medina | Texas | 48325 | 4817 | 103 |
1176409 | 1176409 | 2021-03-31 | Medina | Texas | 48325 | 4817 | 103 |
1173162 | 1173162 | 2021-03-30 | Medina | Texas | 48325 | 4799 | 103 |
1169915 | 1169915 | 2021-03-29 | Medina | Texas | 48325 | 4797 | 103 |
1166667 | 1166667 | 2021-03-28 | Medina | Texas | 48325 | 4797 | 103 |
1163419 | 1163419 | 2021-03-27 | Medina | Texas | 48325 | 4797 | 103 |
1160170 | 1160170 | 2021-03-26 | Medina | Texas | 48325 | 4782 | 103 |
1156923 | 1156923 | 2021-03-25 | Medina | Texas | 48325 | 4772 | 103 |
1153676 | 1153676 | 2021-03-24 | Medina | Texas | 48325 | 4777 | 103 |
1150429 | 1150429 | 2021-03-23 | Medina | Texas | 48325 | 4766 | 103 |
1147182 | 1147182 | 2021-03-22 | Medina | Texas | 48325 | 4764 | 103 |
1143935 | 1143935 | 2021-03-21 | Medina | Texas | 48325 | 4764 | 103 |
1140688 | 1140688 | 2021-03-20 | Medina | Texas | 48325 | 4764 | 102 |
1137442 | 1137442 | 2021-03-19 | Medina | Texas | 48325 | 4761 | 102 |
1134196 | 1134196 | 2021-03-18 | Medina | Texas | 48325 | 4758 | 102 |
1130948 | 1130948 | 2021-03-17 | Medina | Texas | 48325 | 4747 | 101 |
1127701 | 1127701 | 2021-03-16 | Medina | Texas | 48325 | 4731 | 100 |
1124455 | 1124455 | 2021-03-15 | Medina | Texas | 48325 | 4736 | 100 |
1121209 | 1121209 | 2021-03-14 | Medina | Texas | 48325 | 4736 | 100 |
1117962 | 1117962 | 2021-03-13 | Medina | Texas | 48325 | 4736 | 100 |
1114715 | 1114715 | 2021-03-12 | Medina | Texas | 48325 | 4723 | 100 |
1111469 | 1111469 | 2021-03-11 | Medina | Texas | 48325 | 4709 | 99 |
1108223 | 1108223 | 2021-03-10 | Medina | Texas | 48325 | 4698 | 99 |
1104977 | 1104977 | 2021-03-09 | Medina | Texas | 48325 | 4697 | 98 |
1101731 | 1101731 | 2021-03-08 | Medina | Texas | 48325 | 4695 | 98 |
1098485 | 1098485 | 2021-03-07 | Medina | Texas | 48325 | 4693 | 97 |
1095237 | 1095237 | 2021-03-06 | Medina | Texas | 48325 | 4693 | 97 |
1091991 | 1091991 | 2021-03-05 | Medina | Texas | 48325 | 4668 | 97 |
1088745 | 1088745 | 2021-03-04 | Medina | Texas | 48325 | 4661 | 97 |
1085500 | 1085500 | 2021-03-03 | Medina | Texas | 48325 | 4628 | 97 |
1082254 | 1082254 | 2021-03-02 | Medina | Texas | 48325 | 4612 | 93 |
1079008 | 1079008 | 2021-03-01 | Medina | Texas | 48325 | 4604 | 93 |
1075763 | 1075763 | 2021-02-28 | Medina | Texas | 48325 | 4604 | 93 |
1072517 | 1072517 | 2021-02-27 | Medina | Texas | 48325 | 4584 | 93 |
1069271 | 1069271 | 2021-02-26 | Medina | Texas | 48325 | 4604 | 93 |
1066026 | 1066026 | 2021-02-25 | Medina | Texas | 48325 | 4604 | 93 |
1062781 | 1062781 | 2021-02-24 | Medina | Texas | 48325 | 4574 | 93 |
1059536 | 1059536 | 2021-02-23 | Medina | Texas | 48325 | 4574 | 91 |
1056290 | 1056290 | 2021-02-22 | Medina | Texas | 48325 | 4538 | 91 |
1053044 | 1053044 | 2021-02-21 | Medina | Texas | 48325 | 4538 | 91 |
1049797 | 1049797 | 2021-02-20 | Medina | Texas | 48325 | 4538 | 91 |
1046550 | 1046550 | 2021-02-19 | Medina | Texas | 48325 | 4538 | 91 |
1043305 | 1043305 | 2021-02-18 | Medina | Texas | 48325 | 4527 | 87 |
1040060 | 1040060 | 2021-02-17 | Medina | Texas | 48325 | 4527 | 87 |
1036815 | 1036815 | 2021-02-16 | Medina | Texas | 48325 | 4527 | 87 |
1033570 | 1033570 | 2021-02-15 | Medina | Texas | 48325 | 4527 | 87 |
1030324 | 1030324 | 2021-02-14 | Medina | Texas | 48325 | 4527 | 87 |
1027077 | 1027077 | 2021-02-13 | Medina | Texas | 48325 | 4527 | 85 |
1023832 | 1023832 | 2021-02-12 | Medina | Texas | 48325 | 4514 | 83 |
1020587 | 1020587 | 2021-02-11 | Medina | Texas | 48325 | 3848 | 83 |
1017342 | 1017342 | 2021-02-10 | Medina | Texas | 48325 | 3848 | 83 |
1014097 | 1014097 | 2021-02-09 | Medina | Texas | 48325 | 3848 | 81 |
1010852 | 1010852 | 2021-02-08 | Medina | Texas | 48325 | 3843 | 81 |
1007606 | 1007606 | 2021-02-07 | Medina | Texas | 48325 | 3843 | 79 |
1004360 | 1004360 | 2021-02-06 | Medina | Texas | 48325 | 3843 | 79 |
1001114 | 1001114 | 2021-02-05 | Medina | Texas | 48325 | 3843 | 78 |
997868 | 997868 | 2021-02-04 | Medina | Texas | 48325 | 3842 | 76 |
994622 | 994622 | 2021-02-03 | Medina | Texas | 48325 | 3841 | 75 |
991376 | 991376 | 2021-02-02 | Medina | Texas | 48325 | 3772 | 75 |
988130 | 988130 | 2021-02-01 | Medina | Texas | 48325 | 3727 | 74 |
984883 | 984883 | 2021-01-31 | Medina | Texas | 48325 | 3727 | 74 |
981636 | 981636 | 2021-01-30 | Medina | Texas | 48325 | 3727 | 74 |
978390 | 978390 | 2021-01-29 | Medina | Texas | 48325 | 3683 | 74 |
975145 | 975145 | 2021-01-28 | Medina | Texas | 48325 | 3609 | 72 |
971900 | 971900 | 2021-01-27 | Medina | Texas | 48325 | 3562 | 72 |
968655 | 968655 | 2021-01-26 | Medina | Texas | 48325 | 3506 | 70 |
965411 | 965411 | 2021-01-25 | Medina | Texas | 48325 | 3448 | 70 |
962166 | 962166 | 2021-01-24 | Medina | Texas | 48325 | 3464 | 70 |
958921 | 958921 | 2021-01-23 | Medina | Texas | 48325 | 3464 | 69 |
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);