ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Mecklenburg" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718898 | 1718898 | 2021-09-14 | Mecklenburg | Virginia | 51117 | 2936 | 73 |
1715650 | 1715650 | 2021-09-13 | Mecklenburg | Virginia | 51117 | 2923 | 73 |
1712404 | 1712404 | 2021-09-12 | Mecklenburg | Virginia | 51117 | 2895 | 71 |
1709157 | 1709157 | 2021-09-11 | Mecklenburg | Virginia | 51117 | 2895 | 71 |
1705910 | 1705910 | 2021-09-10 | Mecklenburg | Virginia | 51117 | 2895 | 71 |
1702660 | 1702660 | 2021-09-09 | Mecklenburg | Virginia | 51117 | 2880 | 71 |
1699411 | 1699411 | 2021-09-08 | Mecklenburg | Virginia | 51117 | 2851 | 71 |
1696163 | 1696163 | 2021-09-07 | Mecklenburg | Virginia | 51117 | 2816 | 71 |
1692915 | 1692915 | 2021-09-06 | Mecklenburg | Virginia | 51117 | 2808 | 71 |
1689666 | 1689666 | 2021-09-05 | Mecklenburg | Virginia | 51117 | 2791 | 71 |
1686416 | 1686416 | 2021-09-04 | Mecklenburg | Virginia | 51117 | 2791 | 71 |
1683165 | 1683165 | 2021-09-03 | Mecklenburg | Virginia | 51117 | 2791 | 71 |
1679915 | 1679915 | 2021-09-02 | Mecklenburg | Virginia | 51117 | 2780 | 71 |
1676667 | 1676667 | 2021-09-01 | Mecklenburg | Virginia | 51117 | 2758 | 70 |
1673420 | 1673420 | 2021-08-31 | Mecklenburg | Virginia | 51117 | 2736 | 70 |
1670172 | 1670172 | 2021-08-30 | Mecklenburg | Virginia | 51117 | 2722 | 70 |
1666925 | 1666925 | 2021-08-29 | Mecklenburg | Virginia | 51117 | 2697 | 69 |
1663677 | 1663677 | 2021-08-28 | Mecklenburg | Virginia | 51117 | 2697 | 69 |
1660429 | 1660429 | 2021-08-27 | Mecklenburg | Virginia | 51117 | 2697 | 69 |
1657180 | 1657180 | 2021-08-26 | Mecklenburg | Virginia | 51117 | 2674 | 69 |
1653933 | 1653933 | 2021-08-25 | Mecklenburg | Virginia | 51117 | 2648 | 69 |
1650687 | 1650687 | 2021-08-24 | Mecklenburg | Virginia | 51117 | 2630 | 69 |
1647438 | 1647438 | 2021-08-23 | Mecklenburg | Virginia | 51117 | 2620 | 68 |
1644189 | 1644189 | 2021-08-22 | Mecklenburg | Virginia | 51117 | 2608 | 68 |
1640939 | 1640939 | 2021-08-21 | Mecklenburg | Virginia | 51117 | 2608 | 68 |
1637689 | 1637689 | 2021-08-20 | Mecklenburg | Virginia | 51117 | 2608 | 68 |
1634439 | 1634439 | 2021-08-19 | Mecklenburg | Virginia | 51117 | 2604 | 68 |
1631191 | 1631191 | 2021-08-18 | Mecklenburg | Virginia | 51117 | 2598 | 68 |
1627944 | 1627944 | 2021-08-17 | Mecklenburg | Virginia | 51117 | 2587 | 68 |
1624697 | 1624697 | 2021-08-16 | Mecklenburg | Virginia | 51117 | 2566 | 68 |
1621450 | 1621450 | 2021-08-15 | Mecklenburg | Virginia | 51117 | 2540 | 68 |
1618202 | 1618202 | 2021-08-14 | Mecklenburg | Virginia | 51117 | 2540 | 68 |
1614954 | 1614954 | 2021-08-13 | Mecklenburg | Virginia | 51117 | 2540 | 68 |
1611705 | 1611705 | 2021-08-12 | Mecklenburg | Virginia | 51117 | 2537 | 68 |
1608458 | 1608458 | 2021-08-11 | Mecklenburg | Virginia | 51117 | 2531 | 68 |
1605209 | 1605209 | 2021-08-10 | Mecklenburg | Virginia | 51117 | 2526 | 68 |
1601959 | 1601959 | 2021-08-09 | Mecklenburg | Virginia | 51117 | 2505 | 68 |
1598711 | 1598711 | 2021-08-08 | Mecklenburg | Virginia | 51117 | 2495 | 68 |
1595462 | 1595462 | 2021-08-07 | Mecklenburg | Virginia | 51117 | 2495 | 68 |
1592213 | 1592213 | 2021-08-06 | Mecklenburg | Virginia | 51117 | 2495 | 68 |
1588964 | 1588964 | 2021-08-05 | Mecklenburg | Virginia | 51117 | 2487 | 68 |
1585715 | 1585715 | 2021-08-04 | Mecklenburg | Virginia | 51117 | 2478 | 68 |
1582465 | 1582465 | 2021-08-03 | Mecklenburg | Virginia | 51117 | 2466 | 68 |
1579215 | 1579215 | 2021-08-02 | Mecklenburg | Virginia | 51117 | 2449 | 68 |
1575967 | 1575967 | 2021-08-01 | Mecklenburg | Virginia | 51117 | 2437 | 69 |
1572719 | 1572719 | 2021-07-31 | Mecklenburg | Virginia | 51117 | 2437 | 69 |
1569471 | 1569471 | 2021-07-30 | Mecklenburg | Virginia | 51117 | 2437 | 69 |
1566223 | 1566223 | 2021-07-29 | Mecklenburg | Virginia | 51117 | 2425 | 68 |
1562975 | 1562975 | 2021-07-28 | Mecklenburg | Virginia | 51117 | 2423 | 68 |
1559727 | 1559727 | 2021-07-27 | Mecklenburg | Virginia | 51117 | 2412 | 68 |
1556480 | 1556480 | 2021-07-26 | Mecklenburg | Virginia | 51117 | 2396 | 68 |
1553233 | 1553233 | 2021-07-25 | Mecklenburg | Virginia | 51117 | 2395 | 68 |
1549986 | 1549986 | 2021-07-24 | Mecklenburg | Virginia | 51117 | 2395 | 68 |
1546739 | 1546739 | 2021-07-23 | Mecklenburg | Virginia | 51117 | 2395 | 68 |
1543492 | 1543492 | 2021-07-22 | Mecklenburg | Virginia | 51117 | 2392 | 68 |
1540244 | 1540244 | 2021-07-21 | Mecklenburg | Virginia | 51117 | 2383 | 68 |
1536997 | 1536997 | 2021-07-20 | Mecklenburg | Virginia | 51117 | 2378 | 68 |
1533749 | 1533749 | 2021-07-19 | Mecklenburg | Virginia | 51117 | 2374 | 68 |
1530502 | 1530502 | 2021-07-18 | Mecklenburg | Virginia | 51117 | 2372 | 68 |
1527255 | 1527255 | 2021-07-17 | Mecklenburg | Virginia | 51117 | 2372 | 68 |
1524008 | 1524008 | 2021-07-16 | Mecklenburg | Virginia | 51117 | 2372 | 68 |
1520760 | 1520760 | 2021-07-15 | Mecklenburg | Virginia | 51117 | 2369 | 68 |
1517512 | 1517512 | 2021-07-14 | Mecklenburg | Virginia | 51117 | 2368 | 68 |
1514265 | 1514265 | 2021-07-13 | Mecklenburg | Virginia | 51117 | 2367 | 68 |
1511019 | 1511019 | 2021-07-12 | Mecklenburg | Virginia | 51117 | 2365 | 68 |
1507772 | 1507772 | 2021-07-11 | Mecklenburg | Virginia | 51117 | 2365 | 68 |
1504526 | 1504526 | 2021-07-10 | Mecklenburg | Virginia | 51117 | 2365 | 68 |
1501280 | 1501280 | 2021-07-09 | Mecklenburg | Virginia | 51117 | 2363 | 68 |
1498034 | 1498034 | 2021-07-08 | Mecklenburg | Virginia | 51117 | 2362 | 68 |
1494787 | 1494787 | 2021-07-07 | Mecklenburg | Virginia | 51117 | 2362 | 68 |
1491540 | 1491540 | 2021-07-06 | Mecklenburg | Virginia | 51117 | 2362 | 68 |
1488293 | 1488293 | 2021-07-05 | Mecklenburg | Virginia | 51117 | 2362 | 68 |
1485046 | 1485046 | 2021-07-04 | Mecklenburg | Virginia | 51117 | 2362 | 66 |
1481800 | 1481800 | 2021-07-03 | Mecklenburg | Virginia | 51117 | 2362 | 66 |
1478553 | 1478553 | 2021-07-02 | Mecklenburg | Virginia | 51117 | 2356 | 66 |
1475307 | 1475307 | 2021-07-01 | Mecklenburg | Virginia | 51117 | 2356 | 66 |
1472061 | 1472061 | 2021-06-30 | Mecklenburg | Virginia | 51117 | 2355 | 66 |
1468816 | 1468816 | 2021-06-29 | Mecklenburg | Virginia | 51117 | 2354 | 66 |
1465571 | 1465571 | 2021-06-28 | Mecklenburg | Virginia | 51117 | 2351 | 66 |
1462326 | 1462326 | 2021-06-27 | Mecklenburg | Virginia | 51117 | 2351 | 66 |
1459081 | 1459081 | 2021-06-26 | Mecklenburg | Virginia | 51117 | 2351 | 66 |
1455836 | 1455836 | 2021-06-25 | Mecklenburg | Virginia | 51117 | 2351 | 66 |
1452591 | 1452591 | 2021-06-24 | Mecklenburg | Virginia | 51117 | 2352 | 67 |
1449345 | 1449345 | 2021-06-23 | Mecklenburg | Virginia | 51117 | 2351 | 67 |
1446100 | 1446100 | 2021-06-22 | Mecklenburg | Virginia | 51117 | 2351 | 67 |
1442855 | 1442855 | 2021-06-21 | Mecklenburg | Virginia | 51117 | 2350 | 67 |
1439610 | 1439610 | 2021-06-20 | Mecklenburg | Virginia | 51117 | 2349 | 67 |
1436363 | 1436363 | 2021-06-19 | Mecklenburg | Virginia | 51117 | 2347 | 67 |
1433116 | 1433116 | 2021-06-18 | Mecklenburg | Virginia | 51117 | 2351 | 67 |
1429870 | 1429870 | 2021-06-17 | Mecklenburg | Virginia | 51117 | 2351 | 67 |
1426625 | 1426625 | 2021-06-16 | Mecklenburg | Virginia | 51117 | 2350 | 67 |
1423379 | 1423379 | 2021-06-15 | Mecklenburg | Virginia | 51117 | 2349 | 67 |
1420132 | 1420132 | 2021-06-14 | Mecklenburg | Virginia | 51117 | 2348 | 67 |
1416887 | 1416887 | 2021-06-13 | Mecklenburg | Virginia | 51117 | 2348 | 67 |
1413641 | 1413641 | 2021-06-12 | Mecklenburg | Virginia | 51117 | 2347 | 67 |
1410396 | 1410396 | 2021-06-11 | Mecklenburg | Virginia | 51117 | 2346 | 67 |
1407151 | 1407151 | 2021-06-10 | Mecklenburg | Virginia | 51117 | 2343 | 67 |
1403905 | 1403905 | 2021-06-09 | Mecklenburg | Virginia | 51117 | 2341 | 67 |
1400660 | 1400660 | 2021-06-08 | Mecklenburg | Virginia | 51117 | 2335 | 67 |
1397415 | 1397415 | 2021-06-07 | Mecklenburg | Virginia | 51117 | 2335 | 67 |
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);