ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lee" and fips = 48287 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637648 | 637648 | 2020-10-16 | Lee | Texas | 48287 | 235 | 14 |
634403 | 634403 | 2020-10-15 | Lee | Texas | 48287 | 235 | 14 |
631158 | 631158 | 2020-10-14 | Lee | Texas | 48287 | 234 | 14 |
627914 | 627914 | 2020-10-13 | Lee | Texas | 48287 | 234 | 14 |
624671 | 624671 | 2020-10-12 | Lee | Texas | 48287 | 234 | 14 |
621428 | 621428 | 2020-10-11 | Lee | Texas | 48287 | 234 | 14 |
618185 | 618185 | 2020-10-10 | Lee | Texas | 48287 | 234 | 14 |
614943 | 614943 | 2020-10-09 | Lee | Texas | 48287 | 233 | 14 |
611702 | 611702 | 2020-10-08 | Lee | Texas | 48287 | 233 | 14 |
608460 | 608460 | 2020-10-07 | Lee | Texas | 48287 | 232 | 14 |
605217 | 605217 | 2020-10-06 | Lee | Texas | 48287 | 231 | 14 |
601975 | 601975 | 2020-10-05 | Lee | Texas | 48287 | 230 | 14 |
598732 | 598732 | 2020-10-04 | Lee | Texas | 48287 | 230 | 14 |
595489 | 595489 | 2020-10-03 | Lee | Texas | 48287 | 230 | 14 |
592247 | 592247 | 2020-10-02 | Lee | Texas | 48287 | 231 | 14 |
589007 | 589007 | 2020-10-01 | Lee | Texas | 48287 | 231 | 14 |
585766 | 585766 | 2020-09-30 | Lee | Texas | 48287 | 228 | 14 |
582526 | 582526 | 2020-09-29 | Lee | Texas | 48287 | 226 | 14 |
579287 | 579287 | 2020-09-28 | Lee | Texas | 48287 | 221 | 14 |
576046 | 576046 | 2020-09-27 | Lee | Texas | 48287 | 221 | 14 |
572802 | 572802 | 2020-09-26 | Lee | Texas | 48287 | 221 | 14 |
569560 | 569560 | 2020-09-25 | Lee | Texas | 48287 | 219 | 14 |
566319 | 566319 | 2020-09-24 | Lee | Texas | 48287 | 219 | 14 |
563078 | 563078 | 2020-09-23 | Lee | Texas | 48287 | 219 | 14 |
559839 | 559839 | 2020-09-22 | Lee | Texas | 48287 | 218 | 14 |
556603 | 556603 | 2020-09-21 | Lee | Texas | 48287 | 217 | 14 |
553366 | 553366 | 2020-09-20 | Lee | Texas | 48287 | 217 | 14 |
550127 | 550127 | 2020-09-19 | Lee | Texas | 48287 | 217 | 14 |
546888 | 546888 | 2020-09-18 | Lee | Texas | 48287 | 217 | 14 |
543651 | 543651 | 2020-09-17 | Lee | Texas | 48287 | 213 | 14 |
540415 | 540415 | 2020-09-16 | Lee | Texas | 48287 | 211 | 14 |
537178 | 537178 | 2020-09-15 | Lee | Texas | 48287 | 211 | 14 |
533942 | 533942 | 2020-09-14 | Lee | Texas | 48287 | 208 | 14 |
530707 | 530707 | 2020-09-13 | Lee | Texas | 48287 | 208 | 14 |
527470 | 527470 | 2020-09-12 | Lee | Texas | 48287 | 208 | 14 |
524234 | 524234 | 2020-09-11 | Lee | Texas | 48287 | 208 | 14 |
520998 | 520998 | 2020-09-10 | Lee | Texas | 48287 | 208 | 14 |
517762 | 517762 | 2020-09-09 | Lee | Texas | 48287 | 208 | 14 |
514527 | 514527 | 2020-09-08 | Lee | Texas | 48287 | 202 | 14 |
511294 | 511294 | 2020-09-07 | Lee | Texas | 48287 | 202 | 14 |
508061 | 508061 | 2020-09-06 | Lee | Texas | 48287 | 202 | 14 |
504829 | 504829 | 2020-09-05 | Lee | Texas | 48287 | 202 | 14 |
501595 | 501595 | 2020-09-04 | Lee | Texas | 48287 | 197 | 14 |
498361 | 498361 | 2020-09-03 | Lee | Texas | 48287 | 197 | 14 |
495128 | 495128 | 2020-09-02 | Lee | Texas | 48287 | 196 | 14 |
491894 | 491894 | 2020-09-01 | Lee | Texas | 48287 | 196 | 14 |
488661 | 488661 | 2020-08-31 | Lee | Texas | 48287 | 196 | 14 |
485428 | 485428 | 2020-08-30 | Lee | Texas | 48287 | 197 | 14 |
482193 | 482193 | 2020-08-29 | Lee | Texas | 48287 | 196 | 14 |
478959 | 478959 | 2020-08-28 | Lee | Texas | 48287 | 194 | 14 |
475726 | 475726 | 2020-08-27 | Lee | Texas | 48287 | 193 | 13 |
472493 | 472493 | 2020-08-26 | Lee | Texas | 48287 | 191 | 13 |
469261 | 469261 | 2020-08-25 | Lee | Texas | 48287 | 191 | 13 |
466032 | 466032 | 2020-08-24 | Lee | Texas | 48287 | 188 | 13 |
462803 | 462803 | 2020-08-23 | Lee | Texas | 48287 | 188 | 13 |
459574 | 459574 | 2020-08-22 | Lee | Texas | 48287 | 188 | 13 |
456347 | 456347 | 2020-08-21 | Lee | Texas | 48287 | 187 | 13 |
453119 | 453119 | 2020-08-20 | Lee | Texas | 48287 | 187 | 13 |
449891 | 449891 | 2020-08-19 | Lee | Texas | 48287 | 186 | 12 |
446663 | 446663 | 2020-08-18 | Lee | Texas | 48287 | 183 | 12 |
443436 | 443436 | 2020-08-17 | Lee | Texas | 48287 | 181 | 12 |
440210 | 440210 | 2020-08-16 | Lee | Texas | 48287 | 180 | 12 |
436984 | 436984 | 2020-08-15 | Lee | Texas | 48287 | 178 | 12 |
433758 | 433758 | 2020-08-14 | Lee | Texas | 48287 | 177 | 11 |
430533 | 430533 | 2020-08-13 | Lee | Texas | 48287 | 177 | 11 |
427306 | 427306 | 2020-08-12 | Lee | Texas | 48287 | 177 | 11 |
424082 | 424082 | 2020-08-11 | Lee | Texas | 48287 | 177 | 10 |
420861 | 420861 | 2020-08-10 | Lee | Texas | 48287 | 173 | 10 |
417640 | 417640 | 2020-08-09 | Lee | Texas | 48287 | 173 | 10 |
414419 | 414419 | 2020-08-08 | Lee | Texas | 48287 | 172 | 10 |
411199 | 411199 | 2020-08-07 | Lee | Texas | 48287 | 171 | 9 |
407980 | 407980 | 2020-08-06 | Lee | Texas | 48287 | 163 | 9 |
404760 | 404760 | 2020-08-05 | Lee | Texas | 48287 | 163 | 9 |
401542 | 401542 | 2020-08-04 | Lee | Texas | 48287 | 154 | 8 |
398326 | 398326 | 2020-08-03 | Lee | Texas | 48287 | 153 | 8 |
395110 | 395110 | 2020-08-02 | Lee | Texas | 48287 | 153 | 8 |
391894 | 391894 | 2020-08-01 | Lee | Texas | 48287 | 152 | 8 |
388677 | 388677 | 2020-07-31 | Lee | Texas | 48287 | 151 | 8 |
385460 | 385460 | 2020-07-30 | Lee | Texas | 48287 | 148 | 8 |
382242 | 382242 | 2020-07-29 | Lee | Texas | 48287 | 146 | 10 |
379025 | 379025 | 2020-07-28 | Lee | Texas | 48287 | 144 | 10 |
375809 | 375809 | 2020-07-27 | Lee | Texas | 48287 | 143 | 10 |
372596 | 372596 | 2020-07-26 | Lee | Texas | 48287 | 143 | 3 |
369384 | 369384 | 2020-07-25 | Lee | Texas | 48287 | 143 | 3 |
366175 | 366175 | 2020-07-24 | Lee | Texas | 48287 | 134 | 3 |
362969 | 362969 | 2020-07-23 | Lee | Texas | 48287 | 128 | 3 |
359762 | 359762 | 2020-07-22 | Lee | Texas | 48287 | 125 | 3 |
356557 | 356557 | 2020-07-21 | Lee | Texas | 48287 | 121 | 3 |
353354 | 353354 | 2020-07-20 | Lee | Texas | 48287 | 118 | 3 |
350152 | 350152 | 2020-07-19 | Lee | Texas | 48287 | 119 | 3 |
346952 | 346952 | 2020-07-18 | Lee | Texas | 48287 | 117 | 3 |
343752 | 343752 | 2020-07-17 | Lee | Texas | 48287 | 117 | 3 |
340553 | 340553 | 2020-07-16 | Lee | Texas | 48287 | 108 | 3 |
337357 | 337357 | 2020-07-15 | Lee | Texas | 48287 | 103 | 3 |
334162 | 334162 | 2020-07-14 | Lee | Texas | 48287 | 98 | 3 |
330970 | 330970 | 2020-07-13 | Lee | Texas | 48287 | 98 | 3 |
327784 | 327784 | 2020-07-12 | Lee | Texas | 48287 | 98 | 3 |
324599 | 324599 | 2020-07-11 | Lee | Texas | 48287 | 92 | 3 |
321418 | 321418 | 2020-07-10 | Lee | Texas | 48287 | 89 | 3 |
318239 | 318239 | 2020-07-09 | Lee | Texas | 48287 | 92 | 3 |
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);