ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Ellis" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280237 | 1280237 | 2021-05-02 | Ellis | Texas | 48139 | 22677 | 310 |
1276990 | 1276990 | 2021-05-01 | Ellis | Texas | 48139 | 22677 | 310 |
1273743 | 1273743 | 2021-04-30 | Ellis | Texas | 48139 | 22657 | 311 |
1270496 | 1270496 | 2021-04-29 | Ellis | Texas | 48139 | 22635 | 311 |
1267249 | 1267249 | 2021-04-28 | Ellis | Texas | 48139 | 22611 | 311 |
1264002 | 1264002 | 2021-04-27 | Ellis | Texas | 48139 | 22511 | 311 |
1260755 | 1260755 | 2021-04-26 | Ellis | Texas | 48139 | 22468 | 311 |
1257508 | 1257508 | 2021-04-25 | Ellis | Texas | 48139 | 22468 | 311 |
1254261 | 1254261 | 2021-04-24 | Ellis | Texas | 48139 | 22468 | 310 |
1251014 | 1251014 | 2021-04-23 | Ellis | Texas | 48139 | 22462 | 310 |
1247767 | 1247767 | 2021-04-22 | Ellis | Texas | 48139 | 22454 | 310 |
1244520 | 1244520 | 2021-04-21 | Ellis | Texas | 48139 | 22429 | 310 |
1241273 | 1241273 | 2021-04-20 | Ellis | Texas | 48139 | 22412 | 309 |
1238026 | 1238026 | 2021-04-19 | Ellis | Texas | 48139 | 22368 | 309 |
1234779 | 1234779 | 2021-04-18 | Ellis | Texas | 48139 | 22368 | 309 |
1231531 | 1231531 | 2021-04-17 | Ellis | Texas | 48139 | 22368 | 309 |
1228283 | 1228283 | 2021-04-16 | Ellis | Texas | 48139 | 22359 | 309 |
1225035 | 1225035 | 2021-04-15 | Ellis | Texas | 48139 | 22349 | 309 |
1221788 | 1221788 | 2021-04-14 | Ellis | Texas | 48139 | 22334 | 309 |
1218540 | 1218540 | 2021-04-13 | Ellis | Texas | 48139 | 22314 | 309 |
1215292 | 1215292 | 2021-04-12 | Ellis | Texas | 48139 | 22252 | 309 |
1212045 | 1212045 | 2021-04-11 | Ellis | Texas | 48139 | 22252 | 309 |
1208796 | 1208796 | 2021-04-10 | Ellis | Texas | 48139 | 22252 | 309 |
1205548 | 1205548 | 2021-04-09 | Ellis | Texas | 48139 | 22237 | 309 |
1202300 | 1202300 | 2021-04-08 | Ellis | Texas | 48139 | 22223 | 309 |
1199051 | 1199051 | 2021-04-07 | Ellis | Texas | 48139 | 22203 | 309 |
1195802 | 1195802 | 2021-04-06 | Ellis | Texas | 48139 | 22183 | 309 |
1192554 | 1192554 | 2021-04-05 | Ellis | Texas | 48139 | 22164 | 308 |
1189305 | 1189305 | 2021-04-04 | Ellis | Texas | 48139 | 22164 | 308 |
1186058 | 1186058 | 2021-04-03 | Ellis | Texas | 48139 | 22164 | 308 |
1182811 | 1182811 | 2021-04-02 | Ellis | Texas | 48139 | 22201 | 308 |
1179564 | 1179564 | 2021-04-01 | Ellis | Texas | 48139 | 22172 | 308 |
1176317 | 1176317 | 2021-03-31 | Ellis | Texas | 48139 | 22139 | 307 |
1173070 | 1173070 | 2021-03-30 | Ellis | Texas | 48139 | 22094 | 306 |
1169823 | 1169823 | 2021-03-29 | Ellis | Texas | 48139 | 22043 | 306 |
1166575 | 1166575 | 2021-03-28 | Ellis | Texas | 48139 | 22043 | 306 |
1163327 | 1163327 | 2021-03-27 | Ellis | Texas | 48139 | 22043 | 303 |
1160078 | 1160078 | 2021-03-26 | Ellis | Texas | 48139 | 22033 | 302 |
1156831 | 1156831 | 2021-03-25 | Ellis | Texas | 48139 | 21729 | 302 |
1153584 | 1153584 | 2021-03-24 | Ellis | Texas | 48139 | 21721 | 302 |
1150337 | 1150337 | 2021-03-23 | Ellis | Texas | 48139 | 21691 | 300 |
1147090 | 1147090 | 2021-03-22 | Ellis | Texas | 48139 | 21650 | 300 |
1143843 | 1143843 | 2021-03-21 | Ellis | Texas | 48139 | 21650 | 300 |
1140596 | 1140596 | 2021-03-20 | Ellis | Texas | 48139 | 21650 | 300 |
1137350 | 1137350 | 2021-03-19 | Ellis | Texas | 48139 | 21626 | 300 |
1134104 | 1134104 | 2021-03-18 | Ellis | Texas | 48139 | 21610 | 300 |
1130856 | 1130856 | 2021-03-17 | Ellis | Texas | 48139 | 21602 | 299 |
1127609 | 1127609 | 2021-03-16 | Ellis | Texas | 48139 | 21587 | 296 |
1124363 | 1124363 | 2021-03-15 | Ellis | Texas | 48139 | 21541 | 296 |
1121117 | 1121117 | 2021-03-14 | Ellis | Texas | 48139 | 21541 | 296 |
1117870 | 1117870 | 2021-03-13 | Ellis | Texas | 48139 | 21541 | 296 |
1114623 | 1114623 | 2021-03-12 | Ellis | Texas | 48139 | 21523 | 294 |
1111377 | 1111377 | 2021-03-11 | Ellis | Texas | 48139 | 21471 | 292 |
1108131 | 1108131 | 2021-03-10 | Ellis | Texas | 48139 | 21437 | 292 |
1104885 | 1104885 | 2021-03-09 | Ellis | Texas | 48139 | 21407 | 288 |
1101639 | 1101639 | 2021-03-08 | Ellis | Texas | 48139 | 21380 | 288 |
1098393 | 1098393 | 2021-03-07 | Ellis | Texas | 48139 | 21380 | 288 |
1095145 | 1095145 | 2021-03-06 | Ellis | Texas | 48139 | 21380 | 288 |
1091899 | 1091899 | 2021-03-05 | Ellis | Texas | 48139 | 21338 | 284 |
1088653 | 1088653 | 2021-03-04 | Ellis | Texas | 48139 | 21317 | 283 |
1085408 | 1085408 | 2021-03-03 | Ellis | Texas | 48139 | 20936 | 280 |
1082162 | 1082162 | 2021-03-02 | Ellis | Texas | 48139 | 20833 | 280 |
1078916 | 1078916 | 2021-03-01 | Ellis | Texas | 48139 | 20714 | 276 |
1075671 | 1075671 | 2021-02-28 | Ellis | Texas | 48139 | 20714 | 276 |
1072425 | 1072425 | 2021-02-27 | Ellis | Texas | 48139 | 20714 | 274 |
1069179 | 1069179 | 2021-02-26 | Ellis | Texas | 48139 | 20659 | 273 |
1065934 | 1065934 | 2021-02-25 | Ellis | Texas | 48139 | 20589 | 272 |
1062689 | 1062689 | 2021-02-24 | Ellis | Texas | 48139 | 20516 | 270 |
1059444 | 1059444 | 2021-02-23 | Ellis | Texas | 48139 | 20473 | 270 |
1056198 | 1056198 | 2021-02-22 | Ellis | Texas | 48139 | 20406 | 268 |
1052952 | 1052952 | 2021-02-21 | Ellis | Texas | 48139 | 20406 | 268 |
1049705 | 1049705 | 2021-02-20 | Ellis | Texas | 48139 | 20406 | 267 |
1046458 | 1046458 | 2021-02-19 | Ellis | Texas | 48139 | 20331 | 267 |
1043213 | 1043213 | 2021-02-18 | Ellis | Texas | 48139 | 20331 | 267 |
1039968 | 1039968 | 2021-02-17 | Ellis | Texas | 48139 | 20331 | 266 |
1036723 | 1036723 | 2021-02-16 | Ellis | Texas | 48139 | 20066 | 266 |
1033478 | 1033478 | 2021-02-15 | Ellis | Texas | 48139 | 20066 | 266 |
1030232 | 1030232 | 2021-02-14 | Ellis | Texas | 48139 | 20066 | 266 |
1026985 | 1026985 | 2021-02-13 | Ellis | Texas | 48139 | 20066 | 266 |
1023740 | 1023740 | 2021-02-12 | Ellis | Texas | 48139 | 19981 | 264 |
1020495 | 1020495 | 2021-02-11 | Ellis | Texas | 48139 | 19900 | 263 |
1017250 | 1017250 | 2021-02-10 | Ellis | Texas | 48139 | 19813 | 258 |
1014005 | 1014005 | 2021-02-09 | Ellis | Texas | 48139 | 19695 | 256 |
1010760 | 1010760 | 2021-02-08 | Ellis | Texas | 48139 | 19505 | 251 |
1007514 | 1007514 | 2021-02-07 | Ellis | Texas | 48139 | 19505 | 250 |
1004268 | 1004268 | 2021-02-06 | Ellis | Texas | 48139 | 19505 | 249 |
1001022 | 1001022 | 2021-02-05 | Ellis | Texas | 48139 | 19356 | 247 |
997776 | 997776 | 2021-02-04 | Ellis | Texas | 48139 | 19234 | 244 |
994530 | 994530 | 2021-02-03 | Ellis | Texas | 48139 | 19104 | 242 |
991284 | 991284 | 2021-02-02 | Ellis | Texas | 48139 | 18984 | 237 |
988038 | 988038 | 2021-02-01 | Ellis | Texas | 48139 | 18561 | 233 |
984791 | 984791 | 2021-01-31 | Ellis | Texas | 48139 | 18561 | 232 |
981544 | 981544 | 2021-01-30 | Ellis | Texas | 48139 | 18561 | 232 |
978298 | 978298 | 2021-01-29 | Ellis | Texas | 48139 | 18450 | 231 |
975053 | 975053 | 2021-01-28 | Ellis | Texas | 48139 | 18313 | 229 |
971808 | 971808 | 2021-01-27 | Ellis | Texas | 48139 | 18139 | 228 |
968563 | 968563 | 2021-01-26 | Ellis | Texas | 48139 | 18046 | 223 |
965319 | 965319 | 2021-01-25 | Ellis | Texas | 48139 | 17597 | 219 |
962074 | 962074 | 2021-01-24 | Ellis | Texas | 48139 | 17597 | 219 |
958829 | 958829 | 2021-01-23 | Ellis | Texas | 48139 | 17597 | 217 |
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);