ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lubbock" and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
274027 | 274027 | 2020-06-25 | Lubbock | Texas | 48303 | 1795 | 51 |
277175 | 277175 | 2020-06-26 | Lubbock | Texas | 48303 | 1916 | 51 |
280323 | 280323 | 2020-06-27 | Lubbock | Texas | 48303 | 1984 | 51 |
283469 | 283469 | 2020-06-28 | Lubbock | Texas | 48303 | 2041 | 51 |
286615 | 286615 | 2020-06-29 | Lubbock | Texas | 48303 | 2095 | 51 |
289765 | 289765 | 2020-06-30 | Lubbock | Texas | 48303 | 2273 | 51 |
292918 | 292918 | 2020-07-01 | Lubbock | Texas | 48303 | 2457 | 52 |
296073 | 296073 | 2020-07-02 | Lubbock | Texas | 48303 | 2620 | 52 |
299234 | 299234 | 2020-07-03 | Lubbock | Texas | 48303 | 2620 | 52 |
302398 | 302398 | 2020-07-04 | Lubbock | Texas | 48303 | 2620 | 52 |
305562 | 305562 | 2020-07-05 | Lubbock | Texas | 48303 | 2620 | 52 |
308730 | 308730 | 2020-07-06 | Lubbock | Texas | 48303 | 2918 | 56 |
311899 | 311899 | 2020-07-07 | Lubbock | Texas | 48303 | 3051 | 56 |
315073 | 315073 | 2020-07-08 | Lubbock | Texas | 48303 | 3231 | 58 |
318246 | 318246 | 2020-07-09 | Lubbock | Texas | 48303 | 3376 | 59 |
321425 | 321425 | 2020-07-10 | Lubbock | Texas | 48303 | 3524 | 60 |
324606 | 324606 | 2020-07-11 | Lubbock | Texas | 48303 | 3668 | 60 |
327791 | 327791 | 2020-07-12 | Lubbock | Texas | 48303 | 3748 | 60 |
330977 | 330977 | 2020-07-13 | Lubbock | Texas | 48303 | 3823 | 63 |
334169 | 334169 | 2020-07-14 | Lubbock | Texas | 48303 | 3932 | 63 |
337364 | 337364 | 2020-07-15 | Lubbock | Texas | 48303 | 4063 | 64 |
340560 | 340560 | 2020-07-16 | Lubbock | Texas | 48303 | 4209 | 65 |
343759 | 343759 | 2020-07-17 | Lubbock | Texas | 48303 | 4309 | 65 |
346959 | 346959 | 2020-07-18 | Lubbock | Texas | 48303 | 4445 | 65 |
350159 | 350159 | 2020-07-19 | Lubbock | Texas | 48303 | 4482 | 65 |
353361 | 353361 | 2020-07-20 | Lubbock | Texas | 48303 | 4552 | 66 |
356564 | 356564 | 2020-07-21 | Lubbock | Texas | 48303 | 4656 | 67 |
359769 | 359769 | 2020-07-22 | Lubbock | Texas | 48303 | 4769 | 68 |
362976 | 362976 | 2020-07-23 | Lubbock | Texas | 48303 | 4880 | 68 |
366182 | 366182 | 2020-07-24 | Lubbock | Texas | 48303 | 4962 | 68 |
369391 | 369391 | 2020-07-25 | Lubbock | Texas | 48303 | 5014 | 68 |
372603 | 372603 | 2020-07-26 | Lubbock | Texas | 48303 | 5100 | 68 |
375816 | 375816 | 2020-07-27 | Lubbock | Texas | 48303 | 5150 | 72 |
379032 | 379032 | 2020-07-28 | Lubbock | Texas | 48303 | 5255 | 75 |
382249 | 382249 | 2020-07-29 | Lubbock | Texas | 48303 | 5328 | 75 |
385467 | 385467 | 2020-07-30 | Lubbock | Texas | 48303 | 5433 | 75 |
388684 | 388684 | 2020-07-31 | Lubbock | Texas | 48303 | 5512 | 78 |
391901 | 391901 | 2020-08-01 | Lubbock | Texas | 48303 | 5554 | 78 |
395117 | 395117 | 2020-08-02 | Lubbock | Texas | 48303 | 5593 | 78 |
398333 | 398333 | 2020-08-03 | Lubbock | Texas | 48303 | 5652 | 78 |
401549 | 401549 | 2020-08-04 | Lubbock | Texas | 48303 | 5751 | 79 |
404767 | 404767 | 2020-08-05 | Lubbock | Texas | 48303 | 5811 | 80 |
407987 | 407987 | 2020-08-06 | Lubbock | Texas | 48303 | 5959 | 80 |
411206 | 411206 | 2020-08-07 | Lubbock | Texas | 48303 | 6018 | 80 |
414426 | 414426 | 2020-08-08 | Lubbock | Texas | 48303 | 6059 | 80 |
417647 | 417647 | 2020-08-09 | Lubbock | Texas | 48303 | 6110 | 80 |
420868 | 420868 | 2020-08-10 | Lubbock | Texas | 48303 | 6222 | 81 |
424089 | 424089 | 2020-08-11 | Lubbock | Texas | 48303 | 6295 | 83 |
427313 | 427313 | 2020-08-12 | Lubbock | Texas | 48303 | 6365 | 84 |
430540 | 430540 | 2020-08-13 | Lubbock | Texas | 48303 | 6429 | 85 |
433765 | 433765 | 2020-08-14 | Lubbock | Texas | 48303 | 6495 | 87 |
436991 | 436991 | 2020-08-15 | Lubbock | Texas | 48303 | 6528 | 87 |
440217 | 440217 | 2020-08-16 | Lubbock | Texas | 48303 | 6542 | 87 |
443443 | 443443 | 2020-08-17 | Lubbock | Texas | 48303 | 6542 | 87 |
446670 | 446670 | 2020-08-18 | Lubbock | Texas | 48303 | 6656 | 89 |
449898 | 449898 | 2020-08-19 | Lubbock | Texas | 48303 | 6706 | 90 |
453126 | 453126 | 2020-08-20 | Lubbock | Texas | 48303 | 6750 | 92 |
456354 | 456354 | 2020-08-21 | Lubbock | Texas | 48303 | 6818 | 92 |
459581 | 459581 | 2020-08-22 | Lubbock | Texas | 48303 | 6852 | 93 |
462810 | 462810 | 2020-08-23 | Lubbock | Texas | 48303 | 6885 | 93 |
466039 | 466039 | 2020-08-24 | Lubbock | Texas | 48303 | 6918 | 94 |
469268 | 469268 | 2020-08-25 | Lubbock | Texas | 48303 | 6975 | 94 |
472500 | 472500 | 2020-08-26 | Lubbock | Texas | 48303 | 7035 | 95 |
475733 | 475733 | 2020-08-27 | Lubbock | Texas | 48303 | 7173 | 97 |
478966 | 478966 | 2020-08-28 | Lubbock | Texas | 48303 | 7242 | 98 |
482200 | 482200 | 2020-08-29 | Lubbock | Texas | 48303 | 7344 | 98 |
485435 | 485435 | 2020-08-30 | Lubbock | Texas | 48303 | 7397 | 98 |
488668 | 488668 | 2020-08-31 | Lubbock | Texas | 48303 | 7485 | 100 |
491901 | 491901 | 2020-09-01 | Lubbock | Texas | 48303 | 7754 | 101 |
495135 | 495135 | 2020-09-02 | Lubbock | Texas | 48303 | 8027 | 102 |
498368 | 498368 | 2020-09-03 | Lubbock | Texas | 48303 | 8331 | 102 |
501602 | 501602 | 2020-09-04 | Lubbock | Texas | 48303 | 8606 | 104 |
504836 | 504836 | 2020-09-05 | Lubbock | Texas | 48303 | 8867 | 104 |
508068 | 508068 | 2020-09-06 | Lubbock | Texas | 48303 | 8912 | 105 |
511301 | 511301 | 2020-09-07 | Lubbock | Texas | 48303 | 8983 | 105 |
514534 | 514534 | 2020-09-08 | Lubbock | Texas | 48303 | 9075 | 105 |
517769 | 517769 | 2020-09-09 | Lubbock | Texas | 48303 | 9277 | 105 |
521005 | 521005 | 2020-09-10 | Lubbock | Texas | 48303 | 9402 | 105 |
524241 | 524241 | 2020-09-11 | Lubbock | Texas | 48303 | 9500 | 107 |
527477 | 527477 | 2020-09-12 | Lubbock | Texas | 48303 | 9616 | 108 |
530714 | 530714 | 2020-09-13 | Lubbock | Texas | 48303 | 9649 | 108 |
533949 | 533949 | 2020-09-14 | Lubbock | Texas | 48303 | 9828 | 109 |
537185 | 537185 | 2020-09-15 | Lubbock | Texas | 48303 | 9936 | 113 |
540422 | 540422 | 2020-09-16 | Lubbock | Texas | 48303 | 10044 | 113 |
543658 | 543658 | 2020-09-17 | Lubbock | Texas | 48303 | 10119 | 116 |
546895 | 546895 | 2020-09-18 | Lubbock | Texas | 48303 | 10237 | 117 |
550134 | 550134 | 2020-09-19 | Lubbock | Texas | 48303 | 10312 | 117 |
553373 | 553373 | 2020-09-20 | Lubbock | Texas | 48303 | 10455 | 119 |
556610 | 556610 | 2020-09-21 | Lubbock | Texas | 48303 | 10515 | 119 |
559846 | 559846 | 2020-09-22 | Lubbock | Texas | 48303 | 10681 | 120 |
563085 | 563085 | 2020-09-23 | Lubbock | Texas | 48303 | 10855 | 121 |
566326 | 566326 | 2020-09-24 | Lubbock | Texas | 48303 | 11011 | 122 |
569567 | 569567 | 2020-09-25 | Lubbock | Texas | 48303 | 11241 | 124 |
572809 | 572809 | 2020-09-26 | Lubbock | Texas | 48303 | 11324 | 125 |
576053 | 576053 | 2020-09-27 | Lubbock | Texas | 48303 | 11422 | 125 |
579294 | 579294 | 2020-09-28 | Lubbock | Texas | 48303 | 11422 | 125 |
582533 | 582533 | 2020-09-29 | Lubbock | Texas | 48303 | 11952 | 129 |
585773 | 585773 | 2020-09-30 | Lubbock | Texas | 48303 | 12139 | 129 |
589014 | 589014 | 2020-10-01 | Lubbock | Texas | 48303 | 12242 | 129 |
592254 | 592254 | 2020-10-02 | Lubbock | Texas | 48303 | 12398 | 131 |
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);