ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Harris" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280267 | 1280267 | 2021-05-02 | Harris | Texas | 48201 | 392976 | 6217 |
1277020 | 1277020 | 2021-05-01 | Harris | Texas | 48201 | 392664 | 6212 |
1273773 | 1273773 | 2021-04-30 | Harris | Texas | 48201 | 392200 | 6207 |
1270526 | 1270526 | 2021-04-29 | Harris | Texas | 48201 | 391893 | 6192 |
1267279 | 1267279 | 2021-04-28 | Harris | Texas | 48201 | 391438 | 6179 |
1264032 | 1264032 | 2021-04-27 | Harris | Texas | 48201 | 391087 | 6167 |
1260785 | 1260785 | 2021-04-26 | Harris | Texas | 48201 | 390547 | 6151 |
1257538 | 1257538 | 2021-04-25 | Harris | Texas | 48201 | 390174 | 6150 |
1254291 | 1254291 | 2021-04-24 | Harris | Texas | 48201 | 389731 | 6144 |
1251044 | 1251044 | 2021-04-23 | Harris | Texas | 48201 | 388649 | 6133 |
1247797 | 1247797 | 2021-04-22 | Harris | Texas | 48201 | 388423 | 6122 |
1244550 | 1244550 | 2021-04-21 | Harris | Texas | 48201 | 387758 | 6102 |
1241303 | 1241303 | 2021-04-20 | Harris | Texas | 48201 | 387012 | 6089 |
1238056 | 1238056 | 2021-04-19 | Harris | Texas | 48201 | 386620 | 6076 |
1234809 | 1234809 | 2021-04-18 | Harris | Texas | 48201 | 386436 | 6072 |
1231561 | 1231561 | 2021-04-17 | Harris | Texas | 48201 | 385924 | 6059 |
1228313 | 1228313 | 2021-04-16 | Harris | Texas | 48201 | 385448 | 6047 |
1225065 | 1225065 | 2021-04-15 | Harris | Texas | 48201 | 384934 | 6024 |
1221818 | 1221818 | 2021-04-14 | Harris | Texas | 48201 | 384358 | 6004 |
1218570 | 1218570 | 2021-04-13 | Harris | Texas | 48201 | 383709 | 5990 |
1215322 | 1215322 | 2021-04-12 | Harris | Texas | 48201 | 383325 | 5976 |
1212075 | 1212075 | 2021-04-11 | Harris | Texas | 48201 | 382779 | 5975 |
1208826 | 1208826 | 2021-04-10 | Harris | Texas | 48201 | 382209 | 5973 |
1205578 | 1205578 | 2021-04-09 | Harris | Texas | 48201 | 381664 | 5955 |
1202330 | 1202330 | 2021-04-08 | Harris | Texas | 48201 | 381221 | 5930 |
1199081 | 1199081 | 2021-04-07 | Harris | Texas | 48201 | 380652 | 5908 |
1195832 | 1195832 | 2021-04-06 | Harris | Texas | 48201 | 380297 | 5888 |
1192584 | 1192584 | 2021-04-05 | Harris | Texas | 48201 | 379684 | 5880 |
1189335 | 1189335 | 2021-04-04 | Harris | Texas | 48201 | 379461 | 5880 |
1186088 | 1186088 | 2021-04-03 | Harris | Texas | 48201 | 379022 | 5877 |
1182841 | 1182841 | 2021-04-02 | Harris | Texas | 48201 | 378299 | 5857 |
1179594 | 1179594 | 2021-04-01 | Harris | Texas | 48201 | 377720 | 5826 |
1176347 | 1176347 | 2021-03-31 | Harris | Texas | 48201 | 377152 | 5803 |
1173100 | 1173100 | 2021-03-30 | Harris | Texas | 48201 | 376577 | 5778 |
1169853 | 1169853 | 2021-03-29 | Harris | Texas | 48201 | 375809 | 5759 |
1166605 | 1166605 | 2021-03-28 | Harris | Texas | 48201 | 374907 | 5758 |
1163357 | 1163357 | 2021-03-27 | Harris | Texas | 48201 | 374152 | 5747 |
1160108 | 1160108 | 2021-03-26 | Harris | Texas | 48201 | 372888 | 5727 |
1156861 | 1156861 | 2021-03-25 | Harris | Texas | 48201 | 372071 | 5701 |
1153614 | 1153614 | 2021-03-24 | Harris | Texas | 48201 | 371494 | 5677 |
1150367 | 1150367 | 2021-03-23 | Harris | Texas | 48201 | 371161 | 5645 |
1147120 | 1147120 | 2021-03-22 | Harris | Texas | 48201 | 370459 | 5625 |
1143873 | 1143873 | 2021-03-21 | Harris | Texas | 48201 | 370223 | 5610 |
1140626 | 1140626 | 2021-03-20 | Harris | Texas | 48201 | 369613 | 5601 |
1137380 | 1137380 | 2021-03-19 | Harris | Texas | 48201 | 368908 | 5585 |
1134134 | 1134134 | 2021-03-18 | Harris | Texas | 48201 | 368213 | 5562 |
1130886 | 1130886 | 2021-03-17 | Harris | Texas | 48201 | 367775 | 5532 |
1127639 | 1127639 | 2021-03-16 | Harris | Texas | 48201 | 366966 | 5505 |
1124393 | 1124393 | 2021-03-15 | Harris | Texas | 48201 | 365513 | 5490 |
1121147 | 1121147 | 2021-03-14 | Harris | Texas | 48201 | 365338 | 5487 |
1117900 | 1117900 | 2021-03-13 | Harris | Texas | 48201 | 364613 | 5468 |
1114653 | 1114653 | 2021-03-12 | Harris | Texas | 48201 | 363548 | 5440 |
1111407 | 1111407 | 2021-03-11 | Harris | Texas | 48201 | 362716 | 5401 |
1108161 | 1108161 | 2021-03-10 | Harris | Texas | 48201 | 360938 | 5370 |
1104915 | 1104915 | 2021-03-09 | Harris | Texas | 48201 | 360421 | 5331 |
1101669 | 1101669 | 2021-03-08 | Harris | Texas | 48201 | 359948 | 5304 |
1098423 | 1098423 | 2021-03-07 | Harris | Texas | 48201 | 359382 | 5301 |
1095175 | 1095175 | 2021-03-06 | Harris | Texas | 48201 | 358505 | 5296 |
1091929 | 1091929 | 2021-03-05 | Harris | Texas | 48201 | 357558 | 5267 |
1088683 | 1088683 | 2021-03-04 | Harris | Texas | 48201 | 356429 | 5212 |
1085438 | 1085438 | 2021-03-03 | Harris | Texas | 48201 | 355065 | 5155 |
1082192 | 1082192 | 2021-03-02 | Harris | Texas | 48201 | 353450 | 5110 |
1078946 | 1078946 | 2021-03-01 | Harris | Texas | 48201 | 351063 | 5082 |
1075701 | 1075701 | 2021-02-28 | Harris | Texas | 48201 | 350201 | 5075 |
1072455 | 1072455 | 2021-02-27 | Harris | Texas | 48201 | 348848 | 5041 |
1069209 | 1069209 | 2021-02-26 | Harris | Texas | 48201 | 348125 | 5019 |
1065964 | 1065964 | 2021-02-25 | Harris | Texas | 48201 | 344898 | 4980 |
1062719 | 1062719 | 2021-02-24 | Harris | Texas | 48201 | 344102 | 4933 |
1059474 | 1059474 | 2021-02-23 | Harris | Texas | 48201 | 343573 | 4884 |
1056228 | 1056228 | 2021-02-22 | Harris | Texas | 48201 | 343070 | 4858 |
1052982 | 1052982 | 2021-02-21 | Harris | Texas | 48201 | 342309 | 4851 |
1049735 | 1049735 | 2021-02-20 | Harris | Texas | 48201 | 340951 | 4829 |
1046488 | 1046488 | 2021-02-19 | Harris | Texas | 48201 | 340559 | 4790 |
1043243 | 1043243 | 2021-02-18 | Harris | Texas | 48201 | 339444 | 4771 |
1039998 | 1039998 | 2021-02-17 | Harris | Texas | 48201 | 339366 | 4766 |
1036753 | 1036753 | 2021-02-16 | Harris | Texas | 48201 | 338284 | 4760 |
1033508 | 1033508 | 2021-02-15 | Harris | Texas | 48201 | 338274 | 4760 |
1030262 | 1030262 | 2021-02-14 | Harris | Texas | 48201 | 337012 | 4753 |
1027015 | 1027015 | 2021-02-13 | Harris | Texas | 48201 | 335673 | 4735 |
1023770 | 1023770 | 2021-02-12 | Harris | Texas | 48201 | 333279 | 4702 |
1020525 | 1020525 | 2021-02-11 | Harris | Texas | 48201 | 331837 | 4664 |
1017280 | 1017280 | 2021-02-10 | Harris | Texas | 48201 | 330256 | 4607 |
1014035 | 1014035 | 2021-02-09 | Harris | Texas | 48201 | 329576 | 4569 |
1010790 | 1010790 | 2021-02-08 | Harris | Texas | 48201 | 329167 | 4520 |
1007544 | 1007544 | 2021-02-07 | Harris | Texas | 48201 | 328426 | 4506 |
1004298 | 1004298 | 2021-02-06 | Harris | Texas | 48201 | 327079 | 4488 |
1001052 | 1001052 | 2021-02-05 | Harris | Texas | 48201 | 326248 | 4441 |
997806 | 997806 | 2021-02-04 | Harris | Texas | 48201 | 325010 | 4410 |
994560 | 994560 | 2021-02-03 | Harris | Texas | 48201 | 323408 | 4356 |
991314 | 991314 | 2021-02-02 | Harris | Texas | 48201 | 320744 | 4314 |
988068 | 988068 | 2021-02-01 | Harris | Texas | 48201 | 319800 | 4264 |
984821 | 984821 | 2021-01-31 | Harris | Texas | 48201 | 317654 | 4257 |
981574 | 981574 | 2021-01-30 | Harris | Texas | 48201 | 314697 | 4242 |
978328 | 978328 | 2021-01-29 | Harris | Texas | 48201 | 311665 | 4196 |
975083 | 975083 | 2021-01-28 | Harris | Texas | 48201 | 308902 | 4152 |
971838 | 971838 | 2021-01-27 | Harris | Texas | 48201 | 306495 | 4111 |
968593 | 968593 | 2021-01-26 | Harris | Texas | 48201 | 304333 | 4060 |
965349 | 965349 | 2021-01-25 | Harris | Texas | 48201 | 301173 | 4024 |
962104 | 962104 | 2021-01-24 | Harris | Texas | 48201 | 297629 | 4013 |
958859 | 958859 | 2021-01-23 | Harris | Texas | 48201 | 296521 | 3978 |
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);