ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 48113 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176879 | 2176879 | 2022-02-02 | Dallas | Texas | 48113 | 548328 | 6074 |
2173625 | 2173625 | 2022-02-01 | Dallas | Texas | 48113 | 546714 | 6052 |
2170373 | 2170373 | 2022-01-31 | Dallas | Texas | 48113 | 544412 | 6040 |
2167119 | 2167119 | 2022-01-30 | Dallas | Texas | 48113 | 542113 | 6039 |
2163864 | 2163864 | 2022-01-29 | Dallas | Texas | 48113 | 540704 | 6027 |
2160609 | 2160609 | 2022-01-28 | Dallas | Texas | 48113 | 537084 | 6007 |
2157353 | 2157353 | 2022-01-27 | Dallas | Texas | 48113 | 533154 | 5999 |
2154100 | 2154100 | 2022-01-26 | Dallas | Texas | 48113 | 530879 | 5976 |
2150848 | 2150848 | 2022-01-25 | Dallas | Texas | 48113 | 529249 | 5965 |
2147596 | 2147596 | 2022-01-24 | Dallas | Texas | 48113 | 526319 | 5949 |
2144342 | 2144342 | 2022-01-23 | Dallas | Texas | 48113 | 524095 | 5947 |
2141087 | 2141087 | 2022-01-22 | Dallas | Texas | 48113 | 519617 | 5940 |
2137831 | 2137831 | 2022-01-21 | Dallas | Texas | 48113 | 514880 | 5930 |
2134577 | 2134577 | 2022-01-20 | Dallas | Texas | 48113 | 511006 | 5913 |
2131325 | 2131325 | 2022-01-19 | Dallas | Texas | 48113 | 507067 | 5903 |
2128071 | 2128071 | 2022-01-18 | Dallas | Texas | 48113 | 502972 | 5883 |
2124819 | 2124819 | 2022-01-17 | Dallas | Texas | 48113 | 498291 | 5874 |
2121567 | 2121567 | 2022-01-16 | Dallas | Texas | 48113 | 492459 | 5874 |
2118315 | 2118315 | 2022-01-15 | Dallas | Texas | 48113 | 488927 | 5871 |
2115064 | 2115064 | 2022-01-14 | Dallas | Texas | 48113 | 483129 | 5862 |
2111812 | 2111812 | 2022-01-13 | Dallas | Texas | 48113 | 500937 | 5853 |
2108560 | 2108560 | 2022-01-12 | Dallas | Texas | 48113 | 493676 | 5845 |
2105309 | 2105309 | 2022-01-11 | Dallas | Texas | 48113 | 486776 | 5833 |
2102058 | 2102058 | 2022-01-10 | Dallas | Texas | 48113 | 481528 | 5817 |
2098807 | 2098807 | 2022-01-09 | Dallas | Texas | 48113 | 477343 | 5817 |
2095555 | 2095555 | 2022-01-08 | Dallas | Texas | 48113 | 473735 | 5815 |
2092303 | 2092303 | 2022-01-07 | Dallas | Texas | 48113 | 468826 | 5803 |
2089051 | 2089051 | 2022-01-06 | Dallas | Texas | 48113 | 465748 | 5799 |
2085800 | 2085800 | 2022-01-05 | Dallas | Texas | 48113 | 461225 | 5790 |
2082548 | 2082548 | 2022-01-04 | Dallas | Texas | 48113 | 457058 | 5785 |
2079296 | 2079296 | 2022-01-03 | Dallas | Texas | 48113 | 451602 | 5780 |
2076045 | 2076045 | 2022-01-02 | Dallas | Texas | 48113 | 436400 | 5765 |
2072794 | 2072794 | 2022-01-01 | Dallas | Texas | 48113 | 436400 | 5765 |
2069543 | 2069543 | 2021-12-31 | Dallas | Texas | 48113 | 436400 | 5765 |
2066292 | 2066292 | 2021-12-30 | Dallas | Texas | 48113 | 436400 | 5765 |
2063042 | 2063042 | 2021-12-29 | Dallas | Texas | 48113 | 434569 | 5759 |
2059792 | 2059792 | 2021-12-28 | Dallas | Texas | 48113 | 433707 | 5755 |
2056543 | 2056543 | 2021-12-27 | Dallas | Texas | 48113 | 432113 | 5749 |
2053294 | 2053294 | 2021-12-26 | Dallas | Texas | 48113 | 427406 | 5736 |
2050044 | 2050044 | 2021-12-25 | Dallas | Texas | 48113 | 427406 | 5736 |
2046794 | 2046794 | 2021-12-24 | Dallas | Texas | 48113 | 427406 | 5736 |
2043544 | 2043544 | 2021-12-23 | Dallas | Texas | 48113 | 427406 | 5736 |
2040295 | 2040295 | 2021-12-22 | Dallas | Texas | 48113 | 426624 | 5731 |
2037045 | 2037045 | 2021-12-21 | Dallas | Texas | 48113 | 426143 | 5725 |
2033795 | 2033795 | 2021-12-20 | Dallas | Texas | 48113 | 425385 | 5719 |
2030545 | 2030545 | 2021-12-19 | Dallas | Texas | 48113 | 424524 | 5719 |
2027294 | 2027294 | 2021-12-18 | Dallas | Texas | 48113 | 423924 | 5718 |
2024043 | 2024043 | 2021-12-17 | Dallas | Texas | 48113 | 423371 | 5712 |
2020792 | 2020792 | 2021-12-16 | Dallas | Texas | 48113 | 423082 | 5704 |
2017541 | 2017541 | 2021-12-15 | Dallas | Texas | 48113 | 422755 | 5692 |
2014291 | 2014291 | 2021-12-14 | Dallas | Texas | 48113 | 422461 | 5682 |
2011040 | 2011040 | 2021-12-13 | Dallas | Texas | 48113 | 422161 | 5675 |
2007789 | 2007789 | 2021-12-12 | Dallas | Texas | 48113 | 421838 | 5673 |
2004538 | 2004538 | 2021-12-11 | Dallas | Texas | 48113 | 421625 | 5670 |
2001287 | 2001287 | 2021-12-10 | Dallas | Texas | 48113 | 421330 | 5665 |
1998037 | 1998037 | 2021-12-09 | Dallas | Texas | 48113 | 414606 | 5651 |
1994786 | 1994786 | 2021-12-08 | Dallas | Texas | 48113 | 414472 | 5644 |
1991535 | 1991535 | 2021-12-07 | Dallas | Texas | 48113 | 414384 | 5638 |
1988284 | 1988284 | 2021-12-06 | Dallas | Texas | 48113 | 414089 | 5626 |
1985034 | 1985034 | 2021-12-05 | Dallas | Texas | 48113 | 413913 | 5626 |
1981784 | 1981784 | 2021-12-04 | Dallas | Texas | 48113 | 413776 | 5626 |
1978534 | 1978534 | 2021-12-03 | Dallas | Texas | 48113 | 413595 | 5621 |
1975284 | 1975284 | 2021-12-02 | Dallas | Texas | 48113 | 413398 | 5617 |
1972035 | 1972035 | 2021-12-01 | Dallas | Texas | 48113 | 413282 | 5610 |
1968785 | 1968785 | 2021-11-30 | Dallas | Texas | 48113 | 413171 | 5600 |
1965534 | 1965534 | 2021-11-29 | Dallas | Texas | 48113 | 412836 | 5595 |
1962282 | 1962282 | 2021-11-28 | Dallas | Texas | 48113 | 412507 | 5584 |
1959031 | 1959031 | 2021-11-27 | Dallas | Texas | 48113 | 412507 | 5584 |
1955780 | 1955780 | 2021-11-26 | Dallas | Texas | 48113 | 412507 | 5584 |
1952529 | 1952529 | 2021-11-25 | Dallas | Texas | 48113 | 412507 | 5584 |
1949278 | 1949278 | 2021-11-24 | Dallas | Texas | 48113 | 412507 | 5584 |
1946027 | 1946027 | 2021-11-23 | Dallas | Texas | 48113 | 411446 | 5582 |
1942776 | 1942776 | 2021-11-22 | Dallas | Texas | 48113 | 411446 | 5561 |
1939526 | 1939526 | 2021-11-21 | Dallas | Texas | 48113 | 411446 | 5560 |
1936276 | 1936276 | 2021-11-20 | Dallas | Texas | 48113 | 411446 | 5558 |
1933026 | 1933026 | 2021-11-19 | Dallas | Texas | 48113 | 411153 | 5552 |
1929775 | 1929775 | 2021-11-18 | Dallas | Texas | 48113 | 410582 | 5539 |
1926525 | 1926525 | 2021-11-17 | Dallas | Texas | 48113 | 409762 | 5534 |
1923275 | 1923275 | 2021-11-16 | Dallas | Texas | 48113 | 409762 | 5515 |
1920026 | 1920026 | 2021-11-15 | Dallas | Texas | 48113 | 409318 | 5510 |
1916776 | 1916776 | 2021-11-14 | Dallas | Texas | 48113 | 409318 | 5508 |
1913526 | 1913526 | 2021-11-13 | Dallas | Texas | 48113 | 409318 | 5504 |
1910276 | 1910276 | 2021-11-12 | Dallas | Texas | 48113 | 408920 | 5495 |
1907027 | 1907027 | 2021-11-11 | Dallas | Texas | 48113 | 408586 | 5469 |
1903778 | 1903778 | 2021-11-10 | Dallas | Texas | 48113 | 407391 | 5442 |
1900528 | 1900528 | 2021-11-09 | Dallas | Texas | 48113 | 407391 | 5442 |
1897278 | 1897278 | 2021-11-08 | Dallas | Texas | 48113 | 406991 | 5434 |
1894028 | 1894028 | 2021-11-07 | Dallas | Texas | 48113 | 406991 | 5433 |
1890778 | 1890778 | 2021-11-06 | Dallas | Texas | 48113 | 406656 | 5426 |
1887528 | 1887528 | 2021-11-05 | Dallas | Texas | 48113 | 406656 | 5415 |
1884278 | 1884278 | 2021-11-04 | Dallas | Texas | 48113 | 406345 | 5402 |
1881029 | 1881029 | 2021-11-03 | Dallas | Texas | 48113 | 406078 | 5389 |
1877780 | 1877780 | 2021-11-02 | Dallas | Texas | 48113 | 405166 | 5367 |
1874531 | 1874531 | 2021-11-01 | Dallas | Texas | 48113 | 404637 | 5357 |
1871282 | 1871282 | 2021-10-31 | Dallas | Texas | 48113 | 404637 | 5356 |
1868033 | 1868033 | 2021-10-30 | Dallas | Texas | 48113 | 404637 | 5348 |
1864784 | 1864784 | 2021-10-29 | Dallas | Texas | 48113 | 404096 | 5339 |
1861535 | 1861535 | 2021-10-28 | Dallas | Texas | 48113 | 403749 | 5319 |
1858286 | 1858286 | 2021-10-27 | Dallas | Texas | 48113 | 403180 | 5304 |
1855037 | 1855037 | 2021-10-26 | Dallas | Texas | 48113 | 402626 | 5288 |
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);