ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Johnson" and fips = 48251 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176948 | 2176948 | 2022-02-02 | Johnson | Texas | 48251 | 40219 | 647 |
2173694 | 2173694 | 2022-02-01 | Johnson | Texas | 48251 | 40063 | 643 |
2170442 | 2170442 | 2022-01-31 | Johnson | Texas | 48251 | 39902 | 643 |
2167188 | 2167188 | 2022-01-30 | Johnson | Texas | 48251 | 39760 | 643 |
2163933 | 2163933 | 2022-01-29 | Johnson | Texas | 48251 | 39608 | 641 |
2160678 | 2160678 | 2022-01-28 | Johnson | Texas | 48251 | 39334 | 639 |
2157422 | 2157422 | 2022-01-27 | Johnson | Texas | 48251 | 39165 | 636 |
2154169 | 2154169 | 2022-01-26 | Johnson | Texas | 48251 | 38905 | 632 |
2150917 | 2150917 | 2022-01-25 | Johnson | Texas | 48251 | 38773 | 629 |
2147665 | 2147665 | 2022-01-24 | Johnson | Texas | 48251 | 38475 | 628 |
2144411 | 2144411 | 2022-01-23 | Johnson | Texas | 48251 | 38249 | 628 |
2141156 | 2141156 | 2022-01-22 | Johnson | Texas | 48251 | 37913 | 627 |
2137900 | 2137900 | 2022-01-21 | Johnson | Texas | 48251 | 37540 | 626 |
2134646 | 2134646 | 2022-01-20 | Johnson | Texas | 48251 | 37212 | 626 |
2131394 | 2131394 | 2022-01-19 | Johnson | Texas | 48251 | 36976 | 623 |
2128140 | 2128140 | 2022-01-18 | Johnson | Texas | 48251 | 36618 | 622 |
2124888 | 2124888 | 2022-01-17 | Johnson | Texas | 48251 | 36294 | 620 |
2121636 | 2121636 | 2022-01-16 | Johnson | Texas | 48251 | 35798 | 620 |
2118384 | 2118384 | 2022-01-15 | Johnson | Texas | 48251 | 35532 | 619 |
2115133 | 2115133 | 2022-01-14 | Johnson | Texas | 48251 | 35051 | 616 |
2111881 | 2111881 | 2022-01-13 | Johnson | Texas | 48251 | 34571 | 611 |
2108629 | 2108629 | 2022-01-12 | Johnson | Texas | 48251 | 34158 | 609 |
2105378 | 2105378 | 2022-01-11 | Johnson | Texas | 48251 | 33570 | 605 |
2102127 | 2102127 | 2022-01-10 | Johnson | Texas | 48251 | 33174 | 604 |
2098876 | 2098876 | 2022-01-09 | Johnson | Texas | 48251 | 32933 | 604 |
2095624 | 2095624 | 2022-01-08 | Johnson | Texas | 48251 | 32746 | 604 |
2092372 | 2092372 | 2022-01-07 | Johnson | Texas | 48251 | 32434 | 604 |
2089120 | 2089120 | 2022-01-06 | Johnson | Texas | 48251 | 32269 | 602 |
2085869 | 2085869 | 2022-01-05 | Johnson | Texas | 48251 | 32026 | 599 |
2082617 | 2082617 | 2022-01-04 | Johnson | Texas | 48251 | 31800 | 598 |
2079365 | 2079365 | 2022-01-03 | Johnson | Texas | 48251 | 31468 | 598 |
2076114 | 2076114 | 2022-01-02 | Johnson | Texas | 48251 | 30603 | 592 |
2072863 | 2072863 | 2022-01-01 | Johnson | Texas | 48251 | 30603 | 592 |
2069612 | 2069612 | 2021-12-31 | Johnson | Texas | 48251 | 30603 | 592 |
2066361 | 2066361 | 2021-12-30 | Johnson | Texas | 48251 | 30603 | 592 |
2063111 | 2063111 | 2021-12-29 | Johnson | Texas | 48251 | 30529 | 590 |
2059861 | 2059861 | 2021-12-28 | Johnson | Texas | 48251 | 30462 | 589 |
2056612 | 2056612 | 2021-12-27 | Johnson | Texas | 48251 | 30366 | 588 |
2053363 | 2053363 | 2021-12-26 | Johnson | Texas | 48251 | 30179 | 587 |
2050113 | 2050113 | 2021-12-25 | Johnson | Texas | 48251 | 30179 | 587 |
2046863 | 2046863 | 2021-12-24 | Johnson | Texas | 48251 | 30179 | 587 |
2043613 | 2043613 | 2021-12-23 | Johnson | Texas | 48251 | 30179 | 587 |
2040364 | 2040364 | 2021-12-22 | Johnson | Texas | 48251 | 30139 | 587 |
2037114 | 2037114 | 2021-12-21 | Johnson | Texas | 48251 | 30109 | 587 |
2033864 | 2033864 | 2021-12-20 | Johnson | Texas | 48251 | 30038 | 585 |
2030614 | 2030614 | 2021-12-19 | Johnson | Texas | 48251 | 30010 | 585 |
2027363 | 2027363 | 2021-12-18 | Johnson | Texas | 48251 | 29995 | 585 |
2024112 | 2024112 | 2021-12-17 | Johnson | Texas | 48251 | 29948 | 582 |
2020861 | 2020861 | 2021-12-16 | Johnson | Texas | 48251 | 29900 | 582 |
2017610 | 2017610 | 2021-12-15 | Johnson | Texas | 48251 | 29846 | 581 |
2014360 | 2014360 | 2021-12-14 | Johnson | Texas | 48251 | 29800 | 581 |
2011109 | 2011109 | 2021-12-13 | Johnson | Texas | 48251 | 29752 | 578 |
2007858 | 2007858 | 2021-12-12 | Johnson | Texas | 48251 | 29731 | 578 |
2004607 | 2004607 | 2021-12-11 | Johnson | Texas | 48251 | 29721 | 578 |
2001356 | 2001356 | 2021-12-10 | Johnson | Texas | 48251 | 29678 | 578 |
1998106 | 1998106 | 2021-12-09 | Johnson | Texas | 48251 | 29508 | 578 |
1994855 | 1994855 | 2021-12-08 | Johnson | Texas | 48251 | 29491 | 577 |
1991604 | 1991604 | 2021-12-07 | Johnson | Texas | 48251 | 29468 | 577 |
1988353 | 1988353 | 2021-12-06 | Johnson | Texas | 48251 | 29431 | 576 |
1985103 | 1985103 | 2021-12-05 | Johnson | Texas | 48251 | 29419 | 576 |
1981853 | 1981853 | 2021-12-04 | Johnson | Texas | 48251 | 29406 | 576 |
1978603 | 1978603 | 2021-12-03 | Johnson | Texas | 48251 | 29383 | 576 |
1975353 | 1975353 | 2021-12-02 | Johnson | Texas | 48251 | 29348 | 576 |
1972104 | 1972104 | 2021-12-01 | Johnson | Texas | 48251 | 29328 | 575 |
1968854 | 1968854 | 2021-11-30 | Johnson | Texas | 48251 | 29315 | 575 |
1965603 | 1965603 | 2021-11-29 | Johnson | Texas | 48251 | 29266 | 574 |
1962351 | 1962351 | 2021-11-28 | Johnson | Texas | 48251 | 29246 | 569 |
1959100 | 1959100 | 2021-11-27 | Johnson | Texas | 48251 | 29246 | 569 |
1955849 | 1955849 | 2021-11-26 | Johnson | Texas | 48251 | 29246 | 569 |
1952598 | 1952598 | 2021-11-25 | Johnson | Texas | 48251 | 29246 | 569 |
1949347 | 1949347 | 2021-11-24 | Johnson | Texas | 48251 | 29246 | 569 |
1946096 | 1946096 | 2021-11-23 | Johnson | Texas | 48251 | 29212 | 568 |
1942845 | 1942845 | 2021-11-22 | Johnson | Texas | 48251 | 29184 | 567 |
1939595 | 1939595 | 2021-11-21 | Johnson | Texas | 48251 | 29184 | 567 |
1936345 | 1936345 | 2021-11-20 | Johnson | Texas | 48251 | 29184 | 567 |
1933095 | 1933095 | 2021-11-19 | Johnson | Texas | 48251 | 29176 | 564 |
1929844 | 1929844 | 2021-11-18 | Johnson | Texas | 48251 | 29165 | 564 |
1926594 | 1926594 | 2021-11-17 | Johnson | Texas | 48251 | 29160 | 563 |
1923344 | 1923344 | 2021-11-16 | Johnson | Texas | 48251 | 29141 | 560 |
1920095 | 1920095 | 2021-11-15 | Johnson | Texas | 48251 | 29111 | 559 |
1916845 | 1916845 | 2021-11-14 | Johnson | Texas | 48251 | 29111 | 559 |
1913595 | 1913595 | 2021-11-13 | Johnson | Texas | 48251 | 29111 | 558 |
1910345 | 1910345 | 2021-11-12 | Johnson | Texas | 48251 | 29061 | 558 |
1907096 | 1907096 | 2021-11-11 | Johnson | Texas | 48251 | 29061 | 553 |
1903847 | 1903847 | 2021-11-10 | Johnson | Texas | 48251 | 29009 | 550 |
1900597 | 1900597 | 2021-11-09 | Johnson | Texas | 48251 | 29009 | 550 |
1897347 | 1897347 | 2021-11-08 | Johnson | Texas | 48251 | 28941 | 549 |
1894097 | 1894097 | 2021-11-07 | Johnson | Texas | 48251 | 28941 | 549 |
1890847 | 1890847 | 2021-11-06 | Johnson | Texas | 48251 | 28941 | 549 |
1887597 | 1887597 | 2021-11-05 | Johnson | Texas | 48251 | 28920 | 547 |
1884347 | 1884347 | 2021-11-04 | Johnson | Texas | 48251 | 28909 | 547 |
1881098 | 1881098 | 2021-11-03 | Johnson | Texas | 48251 | 28868 | 546 |
1877849 | 1877849 | 2021-11-02 | Johnson | Texas | 48251 | 28849 | 542 |
1874600 | 1874600 | 2021-11-01 | Johnson | Texas | 48251 | 28547 | 540 |
1871351 | 1871351 | 2021-10-31 | Johnson | Texas | 48251 | 28547 | 540 |
1868102 | 1868102 | 2021-10-30 | Johnson | Texas | 48251 | 28547 | 540 |
1864853 | 1864853 | 2021-10-29 | Johnson | Texas | 48251 | 28488 | 540 |
1861604 | 1861604 | 2021-10-28 | Johnson | Texas | 48251 | 28452 | 538 |
1858355 | 1858355 | 2021-10-27 | Johnson | Texas | 48251 | 28373 | 537 |
1855106 | 1855106 | 2021-10-26 | Johnson | Texas | 48251 | 28335 | 534 |
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);