ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 48139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176893 | 2176893 | 2022-02-02 | Ellis | Texas | 48139 | 46599 | 521 |
2173639 | 2173639 | 2022-02-01 | Ellis | Texas | 48139 | 46424 | 518 |
2170387 | 2170387 | 2022-01-31 | Ellis | Texas | 48139 | 46209 | 518 |
2167133 | 2167133 | 2022-01-30 | Ellis | Texas | 48139 | 46050 | 518 |
2163878 | 2163878 | 2022-01-29 | Ellis | Texas | 48139 | 45907 | 517 |
2160623 | 2160623 | 2022-01-28 | Ellis | Texas | 48139 | 45638 | 516 |
2157367 | 2157367 | 2022-01-27 | Ellis | Texas | 48139 | 45431 | 514 |
2154114 | 2154114 | 2022-01-26 | Ellis | Texas | 48139 | 45181 | 513 |
2150862 | 2150862 | 2022-01-25 | Ellis | Texas | 48139 | 45002 | 509 |
2147610 | 2147610 | 2022-01-24 | Ellis | Texas | 48139 | 44704 | 509 |
2144356 | 2144356 | 2022-01-23 | Ellis | Texas | 48139 | 44457 | 509 |
2141101 | 2141101 | 2022-01-22 | Ellis | Texas | 48139 | 43975 | 509 |
2137845 | 2137845 | 2022-01-21 | Ellis | Texas | 48139 | 43302 | 508 |
2134591 | 2134591 | 2022-01-20 | Ellis | Texas | 48139 | 42928 | 508 |
2131339 | 2131339 | 2022-01-19 | Ellis | Texas | 48139 | 42685 | 506 |
2128085 | 2128085 | 2022-01-18 | Ellis | Texas | 48139 | 42209 | 504 |
2124833 | 2124833 | 2022-01-17 | Ellis | Texas | 48139 | 41783 | 503 |
2121581 | 2121581 | 2022-01-16 | Ellis | Texas | 48139 | 41303 | 503 |
2118329 | 2118329 | 2022-01-15 | Ellis | Texas | 48139 | 40869 | 503 |
2115078 | 2115078 | 2022-01-14 | Ellis | Texas | 48139 | 40590 | 500 |
2111826 | 2111826 | 2022-01-13 | Ellis | Texas | 48139 | 40493 | 500 |
2108574 | 2108574 | 2022-01-12 | Ellis | Texas | 48139 | 40047 | 499 |
2105323 | 2105323 | 2022-01-11 | Ellis | Texas | 48139 | 39509 | 498 |
2102072 | 2102072 | 2022-01-10 | Ellis | Texas | 48139 | 39098 | 497 |
2098821 | 2098821 | 2022-01-09 | Ellis | Texas | 48139 | 38727 | 497 |
2095569 | 2095569 | 2022-01-08 | Ellis | Texas | 48139 | 38472 | 497 |
2092317 | 2092317 | 2022-01-07 | Ellis | Texas | 48139 | 38092 | 495 |
2089065 | 2089065 | 2022-01-06 | Ellis | Texas | 48139 | 37817 | 494 |
2085814 | 2085814 | 2022-01-05 | Ellis | Texas | 48139 | 37472 | 493 |
2082562 | 2082562 | 2022-01-04 | Ellis | Texas | 48139 | 37129 | 493 |
2079310 | 2079310 | 2022-01-03 | Ellis | Texas | 48139 | 36730 | 493 |
2076059 | 2076059 | 2022-01-02 | Ellis | Texas | 48139 | 35546 | 491 |
2072808 | 2072808 | 2022-01-01 | Ellis | Texas | 48139 | 35546 | 491 |
2069557 | 2069557 | 2021-12-31 | Ellis | Texas | 48139 | 35546 | 491 |
2066306 | 2066306 | 2021-12-30 | Ellis | Texas | 48139 | 35546 | 491 |
2063056 | 2063056 | 2021-12-29 | Ellis | Texas | 48139 | 35408 | 491 |
2059806 | 2059806 | 2021-12-28 | Ellis | Texas | 48139 | 35354 | 490 |
2056557 | 2056557 | 2021-12-27 | Ellis | Texas | 48139 | 35231 | 490 |
2053308 | 2053308 | 2021-12-26 | Ellis | Texas | 48139 | 34917 | 490 |
2050058 | 2050058 | 2021-12-25 | Ellis | Texas | 48139 | 34917 | 490 |
2046808 | 2046808 | 2021-12-24 | Ellis | Texas | 48139 | 34917 | 490 |
2043558 | 2043558 | 2021-12-23 | Ellis | Texas | 48139 | 34917 | 490 |
2040309 | 2040309 | 2021-12-22 | Ellis | Texas | 48139 | 34846 | 489 |
2037059 | 2037059 | 2021-12-21 | Ellis | Texas | 48139 | 34822 | 489 |
2033809 | 2033809 | 2021-12-20 | Ellis | Texas | 48139 | 34746 | 489 |
2030559 | 2030559 | 2021-12-19 | Ellis | Texas | 48139 | 34688 | 489 |
2027308 | 2027308 | 2021-12-18 | Ellis | Texas | 48139 | 34658 | 489 |
2024057 | 2024057 | 2021-12-17 | Ellis | Texas | 48139 | 34606 | 489 |
2020806 | 2020806 | 2021-12-16 | Ellis | Texas | 48139 | 34563 | 487 |
2017555 | 2017555 | 2021-12-15 | Ellis | Texas | 48139 | 34523 | 486 |
2014305 | 2014305 | 2021-12-14 | Ellis | Texas | 48139 | 34484 | 486 |
2011054 | 2011054 | 2021-12-13 | Ellis | Texas | 48139 | 34452 | 486 |
2007803 | 2007803 | 2021-12-12 | Ellis | Texas | 48139 | 34424 | 486 |
2004552 | 2004552 | 2021-12-11 | Ellis | Texas | 48139 | 34413 | 486 |
2001301 | 2001301 | 2021-12-10 | Ellis | Texas | 48139 | 34380 | 485 |
1998051 | 1998051 | 2021-12-09 | Ellis | Texas | 48139 | 34233 | 485 |
1994800 | 1994800 | 2021-12-08 | Ellis | Texas | 48139 | 34221 | 485 |
1991549 | 1991549 | 2021-12-07 | Ellis | Texas | 48139 | 34199 | 484 |
1988298 | 1988298 | 2021-12-06 | Ellis | Texas | 48139 | 34173 | 482 |
1985048 | 1985048 | 2021-12-05 | Ellis | Texas | 48139 | 34163 | 482 |
1981798 | 1981798 | 2021-12-04 | Ellis | Texas | 48139 | 34159 | 481 |
1978548 | 1978548 | 2021-12-03 | Ellis | Texas | 48139 | 34147 | 481 |
1975298 | 1975298 | 2021-12-02 | Ellis | Texas | 48139 | 34133 | 480 |
1972049 | 1972049 | 2021-12-01 | Ellis | Texas | 48139 | 34118 | 480 |
1968799 | 1968799 | 2021-11-30 | Ellis | Texas | 48139 | 34108 | 480 |
1965548 | 1965548 | 2021-11-29 | Ellis | Texas | 48139 | 34071 | 480 |
1962296 | 1962296 | 2021-11-28 | Ellis | Texas | 48139 | 34066 | 479 |
1959045 | 1959045 | 2021-11-27 | Ellis | Texas | 48139 | 34066 | 479 |
1955794 | 1955794 | 2021-11-26 | Ellis | Texas | 48139 | 34066 | 479 |
1952543 | 1952543 | 2021-11-25 | Ellis | Texas | 48139 | 34066 | 479 |
1949292 | 1949292 | 2021-11-24 | Ellis | Texas | 48139 | 34066 | 479 |
1946041 | 1946041 | 2021-11-23 | Ellis | Texas | 48139 | 34050 | 479 |
1942790 | 1942790 | 2021-11-22 | Ellis | Texas | 48139 | 34028 | 478 |
1939540 | 1939540 | 2021-11-21 | Ellis | Texas | 48139 | 34028 | 478 |
1936290 | 1936290 | 2021-11-20 | Ellis | Texas | 48139 | 34028 | 478 |
1933040 | 1933040 | 2021-11-19 | Ellis | Texas | 48139 | 34023 | 477 |
1929789 | 1929789 | 2021-11-18 | Ellis | Texas | 48139 | 34018 | 477 |
1926539 | 1926539 | 2021-11-17 | Ellis | Texas | 48139 | 34016 | 475 |
1923289 | 1923289 | 2021-11-16 | Ellis | Texas | 48139 | 34008 | 475 |
1920040 | 1920040 | 2021-11-15 | Ellis | Texas | 48139 | 33993 | 475 |
1916790 | 1916790 | 2021-11-14 | Ellis | Texas | 48139 | 33993 | 475 |
1913540 | 1913540 | 2021-11-13 | Ellis | Texas | 48139 | 33993 | 475 |
1910290 | 1910290 | 2021-11-12 | Ellis | Texas | 48139 | 33967 | 475 |
1907041 | 1907041 | 2021-11-11 | Ellis | Texas | 48139 | 33967 | 473 |
1903792 | 1903792 | 2021-11-10 | Ellis | Texas | 48139 | 33917 | 470 |
1900542 | 1900542 | 2021-11-09 | Ellis | Texas | 48139 | 33917 | 470 |
1897292 | 1897292 | 2021-11-08 | Ellis | Texas | 48139 | 33878 | 470 |
1894042 | 1894042 | 2021-11-07 | Ellis | Texas | 48139 | 33878 | 470 |
1890792 | 1890792 | 2021-11-06 | Ellis | Texas | 48139 | 33878 | 470 |
1887542 | 1887542 | 2021-11-05 | Ellis | Texas | 48139 | 33857 | 469 |
1884292 | 1884292 | 2021-11-04 | Ellis | Texas | 48139 | 33848 | 467 |
1881043 | 1881043 | 2021-11-03 | Ellis | Texas | 48139 | 33828 | 467 |
1877794 | 1877794 | 2021-11-02 | Ellis | Texas | 48139 | 33812 | 467 |
1874545 | 1874545 | 2021-11-01 | Ellis | Texas | 48139 | 33623 | 465 |
1871296 | 1871296 | 2021-10-31 | Ellis | Texas | 48139 | 33623 | 465 |
1868047 | 1868047 | 2021-10-30 | Ellis | Texas | 48139 | 33623 | 465 |
1864798 | 1864798 | 2021-10-29 | Ellis | Texas | 48139 | 33594 | 465 |
1861549 | 1861549 | 2021-10-28 | Ellis | Texas | 48139 | 33568 | 463 |
1858300 | 1858300 | 2021-10-27 | Ellis | Texas | 48139 | 33390 | 461 |
1855051 | 1855051 | 2021-10-26 | Ellis | Texas | 48139 | 33350 | 458 |
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);