ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "McLennan" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
277184 | 277184 | 2020-06-26 | McLennan | Texas | 48309 | 624 | 6 |
280332 | 280332 | 2020-06-27 | McLennan | Texas | 48309 | 697 | 6 |
283478 | 283478 | 2020-06-28 | McLennan | Texas | 48309 | 744 | 6 |
286624 | 286624 | 2020-06-29 | McLennan | Texas | 48309 | 795 | 8 |
289774 | 289774 | 2020-06-30 | McLennan | Texas | 48309 | 957 | 9 |
292927 | 292927 | 2020-07-01 | McLennan | Texas | 48309 | 1068 | 9 |
296082 | 296082 | 2020-07-02 | McLennan | Texas | 48309 | 1292 | 9 |
299243 | 299243 | 2020-07-03 | McLennan | Texas | 48309 | 1563 | 9 |
302407 | 302407 | 2020-07-04 | McLennan | Texas | 48309 | 1636 | 11 |
305571 | 305571 | 2020-07-05 | McLennan | Texas | 48309 | 1636 | 11 |
308739 | 308739 | 2020-07-06 | McLennan | Texas | 48309 | 1798 | 13 |
311908 | 311908 | 2020-07-07 | McLennan | Texas | 48309 | 2044 | 13 |
315082 | 315082 | 2020-07-08 | McLennan | Texas | 48309 | 2283 | 14 |
318255 | 318255 | 2020-07-09 | McLennan | Texas | 48309 | 2438 | 15 |
321434 | 321434 | 2020-07-10 | McLennan | Texas | 48309 | 2442 | 15 |
324615 | 324615 | 2020-07-11 | McLennan | Texas | 48309 | 2537 | 16 |
327800 | 327800 | 2020-07-12 | McLennan | Texas | 48309 | 2557 | 17 |
330986 | 330986 | 2020-07-13 | McLennan | Texas | 48309 | 2744 | 19 |
334178 | 334178 | 2020-07-14 | McLennan | Texas | 48309 | 2920 | 19 |
337373 | 337373 | 2020-07-15 | McLennan | Texas | 48309 | 3005 | 19 |
340569 | 340569 | 2020-07-16 | McLennan | Texas | 48309 | 3096 | 20 |
343768 | 343768 | 2020-07-17 | McLennan | Texas | 48309 | 3210 | 22 |
346968 | 346968 | 2020-07-18 | McLennan | Texas | 48309 | 3291 | 24 |
350168 | 350168 | 2020-07-19 | McLennan | Texas | 48309 | 3291 | 24 |
353370 | 353370 | 2020-07-20 | McLennan | Texas | 48309 | 3472 | 24 |
356573 | 356573 | 2020-07-21 | McLennan | Texas | 48309 | 3575 | 25 |
359778 | 359778 | 2020-07-22 | McLennan | Texas | 48309 | 3688 | 28 |
362985 | 362985 | 2020-07-23 | McLennan | Texas | 48309 | 3782 | 32 |
366191 | 366191 | 2020-07-24 | McLennan | Texas | 48309 | 3885 | 35 |
369400 | 369400 | 2020-07-25 | McLennan | Texas | 48309 | 3957 | 35 |
372612 | 372612 | 2020-07-26 | McLennan | Texas | 48309 | 3986 | 35 |
375825 | 375825 | 2020-07-27 | McLennan | Texas | 48309 | 4042 | 36 |
379041 | 379041 | 2020-07-28 | McLennan | Texas | 48309 | 4108 | 39 |
382258 | 382258 | 2020-07-29 | McLennan | Texas | 48309 | 4192 | 42 |
385476 | 385476 | 2020-07-30 | McLennan | Texas | 48309 | 4263 | 44 |
388693 | 388693 | 2020-07-31 | McLennan | Texas | 48309 | 4326 | 45 |
391910 | 391910 | 2020-08-01 | McLennan | Texas | 48309 | 4405 | 46 |
395126 | 395126 | 2020-08-02 | McLennan | Texas | 48309 | 4436 | 48 |
398342 | 398342 | 2020-08-03 | McLennan | Texas | 48309 | 4571 | 51 |
401558 | 401558 | 2020-08-04 | McLennan | Texas | 48309 | 4694 | 51 |
404776 | 404776 | 2020-08-05 | McLennan | Texas | 48309 | 4748 | 53 |
407996 | 407996 | 2020-08-06 | McLennan | Texas | 48309 | 4846 | 55 |
411215 | 411215 | 2020-08-07 | McLennan | Texas | 48309 | 4889 | 62 |
414435 | 414435 | 2020-08-08 | McLennan | Texas | 48309 | 4946 | 63 |
417656 | 417656 | 2020-08-09 | McLennan | Texas | 48309 | 4970 | 64 |
420877 | 420877 | 2020-08-10 | McLennan | Texas | 48309 | 5031 | 64 |
424098 | 424098 | 2020-08-11 | McLennan | Texas | 48309 | 5106 | 65 |
427322 | 427322 | 2020-08-12 | McLennan | Texas | 48309 | 5164 | 70 |
430549 | 430549 | 2020-08-13 | McLennan | Texas | 48309 | 5248 | 70 |
433774 | 433774 | 2020-08-14 | McLennan | Texas | 48309 | 5296 | 71 |
437000 | 437000 | 2020-08-15 | McLennan | Texas | 48309 | 5322 | 72 |
440226 | 440226 | 2020-08-16 | McLennan | Texas | 48309 | 5356 | 72 |
443452 | 443452 | 2020-08-17 | McLennan | Texas | 48309 | 5372 | 73 |
446679 | 446679 | 2020-08-18 | McLennan | Texas | 48309 | 5435 | 75 |
449907 | 449907 | 2020-08-19 | McLennan | Texas | 48309 | 5547 | 75 |
453135 | 453135 | 2020-08-20 | McLennan | Texas | 48309 | 5595 | 78 |
456363 | 456363 | 2020-08-21 | McLennan | Texas | 48309 | 5642 | 78 |
459590 | 459590 | 2020-08-22 | McLennan | Texas | 48309 | 5713 | 79 |
462819 | 462819 | 2020-08-23 | McLennan | Texas | 48309 | 5760 | 79 |
466048 | 466048 | 2020-08-24 | McLennan | Texas | 48309 | 5796 | 80 |
469277 | 469277 | 2020-08-25 | McLennan | Texas | 48309 | 5907 | 81 |
472509 | 472509 | 2020-08-26 | McLennan | Texas | 48309 | 6008 | 81 |
475742 | 475742 | 2020-08-27 | McLennan | Texas | 48309 | 6100 | 81 |
478975 | 478975 | 2020-08-28 | McLennan | Texas | 48309 | 6162 | 82 |
482209 | 482209 | 2020-08-29 | McLennan | Texas | 48309 | 6228 | 82 |
485444 | 485444 | 2020-08-30 | McLennan | Texas | 48309 | 6264 | 83 |
488677 | 488677 | 2020-08-31 | McLennan | Texas | 48309 | 6355 | 83 |
491910 | 491910 | 2020-09-01 | McLennan | Texas | 48309 | 6454 | 87 |
495144 | 495144 | 2020-09-02 | McLennan | Texas | 48309 | 6549 | 88 |
498377 | 498377 | 2020-09-03 | McLennan | Texas | 48309 | 6629 | 88 |
501611 | 501611 | 2020-09-04 | McLennan | Texas | 48309 | 6668 | 88 |
504845 | 504845 | 2020-09-05 | McLennan | Texas | 48309 | 6707 | 88 |
508077 | 508077 | 2020-09-06 | McLennan | Texas | 48309 | 6726 | 88 |
511310 | 511310 | 2020-09-07 | McLennan | Texas | 48309 | 6766 | 88 |
514543 | 514543 | 2020-09-08 | McLennan | Texas | 48309 | 6813 | 89 |
517778 | 517778 | 2020-09-09 | McLennan | Texas | 48309 | 6882 | 90 |
521014 | 521014 | 2020-09-10 | McLennan | Texas | 48309 | 6991 | 90 |
524250 | 524250 | 2020-09-11 | McLennan | Texas | 48309 | 7059 | 91 |
527486 | 527486 | 2020-09-12 | McLennan | Texas | 48309 | 7109 | 91 |
530723 | 530723 | 2020-09-13 | McLennan | Texas | 48309 | 7134 | 91 |
533958 | 533958 | 2020-09-14 | McLennan | Texas | 48309 | 7188 | 91 |
537194 | 537194 | 2020-09-15 | McLennan | Texas | 48309 | 7231 | 91 |
540431 | 540431 | 2020-09-16 | McLennan | Texas | 48309 | 7271 | 92 |
543667 | 543667 | 2020-09-17 | McLennan | Texas | 48309 | 7336 | 93 |
546904 | 546904 | 2020-09-18 | McLennan | Texas | 48309 | 7428 | 97 |
550143 | 550143 | 2020-09-19 | McLennan | Texas | 48309 | 7487 | 97 |
553382 | 553382 | 2020-09-20 | McLennan | Texas | 48309 | 7520 | 97 |
556619 | 556619 | 2020-09-21 | McLennan | Texas | 48309 | 7571 | 98 |
559855 | 559855 | 2020-09-22 | McLennan | Texas | 48309 | 7626 | 99 |
563094 | 563094 | 2020-09-23 | McLennan | Texas | 48309 | 7779 | 100 |
566335 | 566335 | 2020-09-24 | McLennan | Texas | 48309 | 7870 | 101 |
569576 | 569576 | 2020-09-25 | McLennan | Texas | 48309 | 7942 | 105 |
572818 | 572818 | 2020-09-26 | McLennan | Texas | 48309 | 7983 | 106 |
576062 | 576062 | 2020-09-27 | McLennan | Texas | 48309 | 8000 | 107 |
579303 | 579303 | 2020-09-28 | McLennan | Texas | 48309 | 8061 | 108 |
582542 | 582542 | 2020-09-29 | McLennan | Texas | 48309 | 8122 | 111 |
585782 | 585782 | 2020-09-30 | McLennan | Texas | 48309 | 8179 | 111 |
589023 | 589023 | 2020-10-01 | McLennan | Texas | 48309 | 8255 | 115 |
592263 | 592263 | 2020-10-02 | McLennan | Texas | 48309 | 8334 | 117 |
595505 | 595505 | 2020-10-03 | McLennan | Texas | 48309 | 8385 | 117 |
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);