ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 32003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175962 | 2175962 | 2022-02-02 | Clark | Nevada | 32003 | 497012 | 6973 |
2172709 | 2172709 | 2022-02-01 | Clark | Nevada | 32003 | 495884 | 6945 |
2169456 | 2169456 | 2022-01-31 | Clark | Nevada | 32003 | 494743 | 6893 |
2166201 | 2166201 | 2022-01-30 | Clark | Nevada | 32003 | 488299 | 6866 |
2162946 | 2162946 | 2022-01-29 | Clark | Nevada | 32003 | 488299 | 6866 |
2159691 | 2159691 | 2022-01-28 | Clark | Nevada | 32003 | 488299 | 6866 |
2156437 | 2156437 | 2022-01-27 | Clark | Nevada | 32003 | 485655 | 6833 |
2153184 | 2153184 | 2022-01-26 | Clark | Nevada | 32003 | 482680 | 6802 |
2149932 | 2149932 | 2022-01-25 | Clark | Nevada | 32003 | 480210 | 6767 |
2146680 | 2146680 | 2022-01-24 | Clark | Nevada | 32003 | 476972 | 6733 |
2143425 | 2143425 | 2022-01-23 | Clark | Nevada | 32003 | 465458 | 6715 |
2140170 | 2140170 | 2022-01-22 | Clark | Nevada | 32003 | 465458 | 6715 |
2136914 | 2136914 | 2022-01-21 | Clark | Nevada | 32003 | 465458 | 6715 |
2133662 | 2133662 | 2022-01-20 | Clark | Nevada | 32003 | 461535 | 6694 |
2130409 | 2130409 | 2022-01-19 | Clark | Nevada | 32003 | 457621 | 6675 |
2127155 | 2127155 | 2022-01-18 | Clark | Nevada | 32003 | 454773 | 6646 |
2123903 | 2123903 | 2022-01-17 | Clark | Nevada | 32003 | 436128 | 6625 |
2120651 | 2120651 | 2022-01-16 | Clark | Nevada | 32003 | 436128 | 6625 |
2117399 | 2117399 | 2022-01-15 | Clark | Nevada | 32003 | 436128 | 6625 |
2114148 | 2114148 | 2022-01-14 | Clark | Nevada | 32003 | 436128 | 6625 |
2110896 | 2110896 | 2022-01-13 | Clark | Nevada | 32003 | 431211 | 6608 |
2107645 | 2107645 | 2022-01-12 | Clark | Nevada | 32003 | 425188 | 6588 |
2104394 | 2104394 | 2022-01-11 | Clark | Nevada | 32003 | 420039 | 6571 |
2101143 | 2101143 | 2022-01-10 | Clark | Nevada | 32003 | 416544 | 6544 |
2097892 | 2097892 | 2022-01-09 | Clark | Nevada | 32003 | 401096 | 6529 |
2094640 | 2094640 | 2022-01-08 | Clark | Nevada | 32003 | 401096 | 6529 |
2091388 | 2091388 | 2022-01-07 | Clark | Nevada | 32003 | 401096 | 6529 |
2088137 | 2088137 | 2022-01-06 | Clark | Nevada | 32003 | 397247 | 6527 |
2084885 | 2084885 | 2022-01-05 | Clark | Nevada | 32003 | 395432 | 6512 |
2081633 | 2081633 | 2022-01-04 | Clark | Nevada | 32003 | 392388 | 6499 |
2078381 | 2078381 | 2022-01-03 | Clark | Nevada | 32003 | 390142 | 6461 |
2075130 | 2075130 | 2022-01-02 | Clark | Nevada | 32003 | 378138 | 6461 |
2071879 | 2071879 | 2022-01-01 | Clark | Nevada | 32003 | 378138 | 6461 |
2068628 | 2068628 | 2021-12-31 | Clark | Nevada | 32003 | 378138 | 6461 |
2065377 | 2065377 | 2021-12-30 | Clark | Nevada | 32003 | 378138 | 6461 |
2062127 | 2062127 | 2021-12-29 | Clark | Nevada | 32003 | 375560 | 6451 |
2058878 | 2058878 | 2021-12-28 | Clark | Nevada | 32003 | 373129 | 6436 |
2055629 | 2055629 | 2021-12-27 | Clark | Nevada | 32003 | 371690 | 6415 |
2052379 | 2052379 | 2021-12-26 | Clark | Nevada | 32003 | 368020 | 6415 |
2049129 | 2049129 | 2021-12-25 | Clark | Nevada | 32003 | 368020 | 6415 |
2045879 | 2045879 | 2021-12-24 | Clark | Nevada | 32003 | 368020 | 6415 |
2042629 | 2042629 | 2021-12-23 | Clark | Nevada | 32003 | 368020 | 6415 |
2039380 | 2039380 | 2021-12-22 | Clark | Nevada | 32003 | 366773 | 6413 |
2036130 | 2036130 | 2021-12-21 | Clark | Nevada | 32003 | 365790 | 6404 |
2032880 | 2032880 | 2021-12-20 | Clark | Nevada | 32003 | 364728 | 6389 |
2029629 | 2029629 | 2021-12-19 | Clark | Nevada | 32003 | 362894 | 6367 |
2026378 | 2026378 | 2021-12-18 | Clark | Nevada | 32003 | 362894 | 6367 |
2023127 | 2023127 | 2021-12-17 | Clark | Nevada | 32003 | 362894 | 6367 |
2019876 | 2019876 | 2021-12-16 | Clark | Nevada | 32003 | 361895 | 6358 |
2016626 | 2016626 | 2021-12-15 | Clark | Nevada | 32003 | 361235 | 6346 |
2013375 | 2013375 | 2021-12-14 | Clark | Nevada | 32003 | 360675 | 6334 |
2010124 | 2010124 | 2021-12-13 | Clark | Nevada | 32003 | 360035 | 6319 |
2006873 | 2006873 | 2021-12-12 | Clark | Nevada | 32003 | 358791 | 6308 |
2003622 | 2003622 | 2021-12-11 | Clark | Nevada | 32003 | 358791 | 6308 |
2000372 | 2000372 | 2021-12-10 | Clark | Nevada | 32003 | 358791 | 6308 |
1997121 | 1997121 | 2021-12-09 | Clark | Nevada | 32003 | 358267 | 6282 |
1993870 | 1993870 | 2021-12-08 | Clark | Nevada | 32003 | 357282 | 6279 |
1990619 | 1990619 | 2021-12-07 | Clark | Nevada | 32003 | 356733 | 6269 |
1987369 | 1987369 | 2021-12-06 | Clark | Nevada | 32003 | 356182 | 6259 |
1984119 | 1984119 | 2021-12-05 | Clark | Nevada | 32003 | 354924 | 6227 |
1980869 | 1980869 | 2021-12-04 | Clark | Nevada | 32003 | 354924 | 6227 |
1977619 | 1977619 | 2021-12-03 | Clark | Nevada | 32003 | 354924 | 6227 |
1974369 | 1974369 | 2021-12-02 | Clark | Nevada | 32003 | 354432 | 6213 |
1971120 | 1971120 | 2021-12-01 | Clark | Nevada | 32003 | 353721 | 6202 |
1967870 | 1967870 | 2021-11-30 | Clark | Nevada | 32003 | 353136 | 6190 |
1964618 | 1964618 | 2021-11-29 | Clark | Nevada | 32003 | 352555 | 6169 |
1961367 | 1961367 | 2021-11-28 | Clark | Nevada | 32003 | 351155 | 6161 |
1958116 | 1958116 | 2021-11-27 | Clark | Nevada | 32003 | 351155 | 6161 |
1954865 | 1954865 | 2021-11-26 | Clark | Nevada | 32003 | 351155 | 6161 |
1951614 | 1951614 | 2021-11-25 | Clark | Nevada | 32003 | 351155 | 6161 |
1948363 | 1948363 | 2021-11-24 | Clark | Nevada | 32003 | 351155 | 6161 |
1945112 | 1945112 | 2021-11-23 | Clark | Nevada | 32003 | 350613 | 6145 |
1941861 | 1941861 | 2021-11-22 | Clark | Nevada | 32003 | 350174 | 6130 |
1938611 | 1938611 | 2021-11-21 | Clark | Nevada | 32003 | 348819 | 6121 |
1935361 | 1935361 | 2021-11-20 | Clark | Nevada | 32003 | 348819 | 6121 |
1932111 | 1932111 | 2021-11-19 | Clark | Nevada | 32003 | 348819 | 6121 |
1928860 | 1928860 | 2021-11-18 | Clark | Nevada | 32003 | 348395 | 6108 |
1925610 | 1925610 | 2021-11-17 | Clark | Nevada | 32003 | 347908 | 6096 |
1922361 | 1922361 | 2021-11-16 | Clark | Nevada | 32003 | 347437 | 6086 |
1919111 | 1919111 | 2021-11-15 | Clark | Nevada | 32003 | 346868 | 6073 |
1915861 | 1915861 | 2021-11-14 | Clark | Nevada | 32003 | 345658 | 6049 |
1912611 | 1912611 | 2021-11-13 | Clark | Nevada | 32003 | 345658 | 6049 |
1909361 | 1909361 | 2021-11-12 | Clark | Nevada | 32003 | 345658 | 6049 |
1906112 | 1906112 | 2021-11-11 | Clark | Nevada | 32003 | 344785 | 6044 |
1902863 | 1902863 | 2021-11-10 | Clark | Nevada | 32003 | 344785 | 6044 |
1899613 | 1899613 | 2021-11-09 | Clark | Nevada | 32003 | 344394 | 6036 |
1896363 | 1896363 | 2021-11-08 | Clark | Nevada | 32003 | 343896 | 6029 |
1893113 | 1893113 | 2021-11-07 | Clark | Nevada | 32003 | 342841 | 6014 |
1889863 | 1889863 | 2021-11-06 | Clark | Nevada | 32003 | 342841 | 6014 |
1886613 | 1886613 | 2021-11-05 | Clark | Nevada | 32003 | 342841 | 6014 |
1883364 | 1883364 | 2021-11-04 | Clark | Nevada | 32003 | 342291 | 6001 |
1880115 | 1880115 | 2021-11-03 | Clark | Nevada | 32003 | 341823 | 5992 |
1876866 | 1876866 | 2021-11-02 | Clark | Nevada | 32003 | 341356 | 5983 |
1873617 | 1873617 | 2021-11-01 | Clark | Nevada | 32003 | 340929 | 5977 |
1870368 | 1870368 | 2021-10-31 | Clark | Nevada | 32003 | 339255 | 5963 |
1867119 | 1867119 | 2021-10-30 | Clark | Nevada | 32003 | 339255 | 5963 |
1863870 | 1863870 | 2021-10-29 | Clark | Nevada | 32003 | 339255 | 5963 |
1860621 | 1860621 | 2021-10-28 | Clark | Nevada | 32003 | 339255 | 5963 |
1857372 | 1857372 | 2021-10-27 | Clark | Nevada | 32003 | 338853 | 5947 |
1854123 | 1854123 | 2021-10-26 | Clark | Nevada | 32003 | 338328 | 5935 |
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);