ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Columbia" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716016 | 1716016 | 2021-09-14 | Columbia | Arkansas | 5027 | 3183 | 65 |
1712770 | 1712770 | 2021-09-13 | Columbia | Arkansas | 5027 | 3169 | 64 |
1709523 | 1709523 | 2021-09-12 | Columbia | Arkansas | 5027 | 3165 | 63 |
1706276 | 1706276 | 2021-09-11 | Columbia | Arkansas | 5027 | 3163 | 61 |
1703028 | 1703028 | 2021-09-10 | Columbia | Arkansas | 5027 | 3157 | 61 |
1699778 | 1699778 | 2021-09-09 | Columbia | Arkansas | 5027 | 3144 | 61 |
1696529 | 1696529 | 2021-09-08 | Columbia | Arkansas | 5027 | 3124 | 61 |
1693281 | 1693281 | 2021-09-07 | Columbia | Arkansas | 5027 | 3089 | 61 |
1690032 | 1690032 | 2021-09-06 | Columbia | Arkansas | 5027 | 3089 | 61 |
1686782 | 1686782 | 2021-09-05 | Columbia | Arkansas | 5027 | 3078 | 61 |
1683532 | 1683532 | 2021-09-04 | Columbia | Arkansas | 5027 | 3069 | 61 |
1680281 | 1680281 | 2021-09-03 | Columbia | Arkansas | 5027 | 3055 | 61 |
1677033 | 1677033 | 2021-09-02 | Columbia | Arkansas | 5027 | 3035 | 61 |
1673786 | 1673786 | 2021-09-01 | Columbia | Arkansas | 5027 | 3024 | 61 |
1670538 | 1670538 | 2021-08-31 | Columbia | Arkansas | 5027 | 2994 | 61 |
1667291 | 1667291 | 2021-08-30 | Columbia | Arkansas | 5027 | 2967 | 61 |
1664044 | 1664044 | 2021-08-29 | Columbia | Arkansas | 5027 | 2963 | 61 |
1660796 | 1660796 | 2021-08-28 | Columbia | Arkansas | 5027 | 2957 | 61 |
1657548 | 1657548 | 2021-08-27 | Columbia | Arkansas | 5027 | 2947 | 61 |
1654300 | 1654300 | 2021-08-26 | Columbia | Arkansas | 5027 | 2930 | 61 |
1651053 | 1651053 | 2021-08-25 | Columbia | Arkansas | 5027 | 2906 | 60 |
1647804 | 1647804 | 2021-08-24 | Columbia | Arkansas | 5027 | 2883 | 60 |
1644556 | 1644556 | 2021-08-23 | Columbia | Arkansas | 5027 | 2860 | 60 |
1641306 | 1641306 | 2021-08-22 | Columbia | Arkansas | 5027 | 2855 | 60 |
1638056 | 1638056 | 2021-08-21 | Columbia | Arkansas | 5027 | 2847 | 60 |
1634806 | 1634806 | 2021-08-20 | Columbia | Arkansas | 5027 | 2829 | 60 |
1631557 | 1631557 | 2021-08-19 | Columbia | Arkansas | 5027 | 2805 | 60 |
1628310 | 1628310 | 2021-08-18 | Columbia | Arkansas | 5027 | 2772 | 60 |
1625063 | 1625063 | 2021-08-17 | Columbia | Arkansas | 5027 | 2757 | 60 |
1621816 | 1621816 | 2021-08-16 | Columbia | Arkansas | 5027 | 2752 | 60 |
1618569 | 1618569 | 2021-08-15 | Columbia | Arkansas | 5027 | 2746 | 60 |
1615321 | 1615321 | 2021-08-14 | Columbia | Arkansas | 5027 | 2743 | 60 |
1612072 | 1612072 | 2021-08-13 | Columbia | Arkansas | 5027 | 2726 | 60 |
1608824 | 1608824 | 2021-08-12 | Columbia | Arkansas | 5027 | 2708 | 60 |
1605575 | 1605575 | 2021-08-11 | Columbia | Arkansas | 5027 | 2704 | 60 |
1602326 | 1602326 | 2021-08-10 | Columbia | Arkansas | 5027 | 2691 | 60 |
1599077 | 1599077 | 2021-08-09 | Columbia | Arkansas | 5027 | 2678 | 59 |
1595828 | 1595828 | 2021-08-08 | Columbia | Arkansas | 5027 | 2670 | 59 |
1592579 | 1592579 | 2021-08-07 | Columbia | Arkansas | 5027 | 2664 | 59 |
1589330 | 1589330 | 2021-08-06 | Columbia | Arkansas | 5027 | 2635 | 59 |
1586081 | 1586081 | 2021-08-05 | Columbia | Arkansas | 5027 | 2626 | 59 |
1582831 | 1582831 | 2021-08-04 | Columbia | Arkansas | 5027 | 2618 | 59 |
1579581 | 1579581 | 2021-08-03 | Columbia | Arkansas | 5027 | 2603 | 59 |
1576333 | 1576333 | 2021-08-02 | Columbia | Arkansas | 5027 | 2594 | 59 |
1573085 | 1573085 | 2021-08-01 | Columbia | Arkansas | 5027 | 2593 | 59 |
1569837 | 1569837 | 2021-07-31 | Columbia | Arkansas | 5027 | 2587 | 59 |
1566589 | 1566589 | 2021-07-30 | Columbia | Arkansas | 5027 | 2579 | 58 |
1563341 | 1563341 | 2021-07-29 | Columbia | Arkansas | 5027 | 2564 | 58 |
1560093 | 1560093 | 2021-07-28 | Columbia | Arkansas | 5027 | 2553 | 58 |
1556846 | 1556846 | 2021-07-27 | Columbia | Arkansas | 5027 | 2534 | 58 |
1553599 | 1553599 | 2021-07-26 | Columbia | Arkansas | 5027 | 2524 | 58 |
1550352 | 1550352 | 2021-07-25 | Columbia | Arkansas | 5027 | 2527 | 58 |
1547105 | 1547105 | 2021-07-24 | Columbia | Arkansas | 5027 | 2524 | 58 |
1543858 | 1543858 | 2021-07-23 | Columbia | Arkansas | 5027 | 2515 | 58 |
1540610 | 1540610 | 2021-07-22 | Columbia | Arkansas | 5027 | 2511 | 58 |
1537363 | 1537363 | 2021-07-21 | Columbia | Arkansas | 5027 | 2504 | 58 |
1534115 | 1534115 | 2021-07-20 | Columbia | Arkansas | 5027 | 2497 | 58 |
1530868 | 1530868 | 2021-07-19 | Columbia | Arkansas | 5027 | 2486 | 58 |
1527621 | 1527621 | 2021-07-18 | Columbia | Arkansas | 5027 | 2476 | 58 |
1524374 | 1524374 | 2021-07-17 | Columbia | Arkansas | 5027 | 2476 | 58 |
1521126 | 1521126 | 2021-07-16 | Columbia | Arkansas | 5027 | 2476 | 58 |
1517878 | 1517878 | 2021-07-15 | Columbia | Arkansas | 5027 | 2470 | 58 |
1514631 | 1514631 | 2021-07-14 | Columbia | Arkansas | 5027 | 2468 | 58 |
1511385 | 1511385 | 2021-07-13 | Columbia | Arkansas | 5027 | 2466 | 58 |
1508138 | 1508138 | 2021-07-12 | Columbia | Arkansas | 5027 | 2459 | 58 |
1504892 | 1504892 | 2021-07-11 | Columbia | Arkansas | 5027 | 2444 | 57 |
1501646 | 1501646 | 2021-07-10 | Columbia | Arkansas | 5027 | 2444 | 57 |
1498400 | 1498400 | 2021-07-09 | Columbia | Arkansas | 5027 | 2444 | 57 |
1495153 | 1495153 | 2021-07-08 | Columbia | Arkansas | 5027 | 2439 | 57 |
1491906 | 1491906 | 2021-07-07 | Columbia | Arkansas | 5027 | 2433 | 57 |
1488659 | 1488659 | 2021-07-06 | Columbia | Arkansas | 5027 | 2428 | 57 |
1485412 | 1485412 | 2021-07-05 | Columbia | Arkansas | 5027 | 2426 | 57 |
1482166 | 1482166 | 2021-07-04 | Columbia | Arkansas | 5027 | 2413 | 57 |
1478919 | 1478919 | 2021-07-03 | Columbia | Arkansas | 5027 | 2413 | 57 |
1475673 | 1475673 | 2021-07-02 | Columbia | Arkansas | 5027 | 2413 | 57 |
1472427 | 1472427 | 2021-07-01 | Columbia | Arkansas | 5027 | 2411 | 57 |
1469182 | 1469182 | 2021-06-30 | Columbia | Arkansas | 5027 | 2407 | 57 |
1465937 | 1465937 | 2021-06-29 | Columbia | Arkansas | 5027 | 2406 | 57 |
1462692 | 1462692 | 2021-06-28 | Columbia | Arkansas | 5027 | 2405 | 57 |
1459447 | 1459447 | 2021-06-27 | Columbia | Arkansas | 5027 | 2400 | 56 |
1456202 | 1456202 | 2021-06-26 | Columbia | Arkansas | 5027 | 2400 | 56 |
1452957 | 1452957 | 2021-06-25 | Columbia | Arkansas | 5027 | 2400 | 56 |
1449711 | 1449711 | 2021-06-24 | Columbia | Arkansas | 5027 | 2399 | 56 |
1446466 | 1446466 | 2021-06-23 | Columbia | Arkansas | 5027 | 2398 | 56 |
1443221 | 1443221 | 2021-06-22 | Columbia | Arkansas | 5027 | 2389 | 56 |
1439976 | 1439976 | 2021-06-21 | Columbia | Arkansas | 5027 | 2386 | 56 |
1436729 | 1436729 | 2021-06-20 | Columbia | Arkansas | 5027 | 2386 | 56 |
1433482 | 1433482 | 2021-06-19 | Columbia | Arkansas | 5027 | 2385 | 56 |
1430236 | 1430236 | 2021-06-18 | Columbia | Arkansas | 5027 | 2384 | 56 |
1426991 | 1426991 | 2021-06-17 | Columbia | Arkansas | 5027 | 2382 | 56 |
1423746 | 1423746 | 2021-06-16 | Columbia | Arkansas | 5027 | 2382 | 56 |
1420498 | 1420498 | 2021-06-15 | Columbia | Arkansas | 5027 | 2377 | 56 |
1417253 | 1417253 | 2021-06-14 | Columbia | Arkansas | 5027 | 2375 | 56 |
1414007 | 1414007 | 2021-06-13 | Columbia | Arkansas | 5027 | 2375 | 56 |
1410762 | 1410762 | 2021-06-12 | Columbia | Arkansas | 5027 | 2375 | 56 |
1407517 | 1407517 | 2021-06-11 | Columbia | Arkansas | 5027 | 2372 | 56 |
1404271 | 1404271 | 2021-06-10 | Columbia | Arkansas | 5027 | 2371 | 56 |
1401026 | 1401026 | 2021-06-09 | Columbia | Arkansas | 5027 | 2371 | 56 |
1397781 | 1397781 | 2021-06-08 | Columbia | Arkansas | 5027 | 2371 | 56 |
1394534 | 1394534 | 2021-06-07 | Columbia | Arkansas | 5027 | 2368 | 56 |
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);