ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Pierce" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716395 | 1716395 | 2021-09-14 | Pierce | Georgia | 13229 | 4037 | 77 |
1713149 | 1713149 | 2021-09-13 | Pierce | Georgia | 13229 | 4023 | 79 |
1709902 | 1709902 | 2021-09-12 | Pierce | Georgia | 13229 | 3973 | 77 |
1706655 | 1706655 | 2021-09-11 | Pierce | Georgia | 13229 | 3973 | 77 |
1703407 | 1703407 | 2021-09-10 | Pierce | Georgia | 13229 | 3973 | 77 |
1700157 | 1700157 | 2021-09-09 | Pierce | Georgia | 13229 | 3949 | 74 |
1696908 | 1696908 | 2021-09-08 | Pierce | Georgia | 13229 | 3922 | 74 |
1693660 | 1693660 | 2021-09-07 | Pierce | Georgia | 13229 | 3892 | 73 |
1690411 | 1690411 | 2021-09-06 | Pierce | Georgia | 13229 | 3809 | 72 |
1687161 | 1687161 | 2021-09-05 | Pierce | Georgia | 13229 | 3809 | 72 |
1683911 | 1683911 | 2021-09-04 | Pierce | Georgia | 13229 | 3809 | 72 |
1680660 | 1680660 | 2021-09-03 | Pierce | Georgia | 13229 | 3809 | 72 |
1677412 | 1677412 | 2021-09-02 | Pierce | Georgia | 13229 | 3773 | 72 |
1674165 | 1674165 | 2021-09-01 | Pierce | Georgia | 13229 | 3746 | 72 |
1670917 | 1670917 | 2021-08-31 | Pierce | Georgia | 13229 | 3719 | 72 |
1667670 | 1667670 | 2021-08-30 | Pierce | Georgia | 13229 | 3672 | 72 |
1664423 | 1664423 | 2021-08-29 | Pierce | Georgia | 13229 | 3592 | 71 |
1661175 | 1661175 | 2021-08-28 | Pierce | Georgia | 13229 | 3592 | 71 |
1657927 | 1657927 | 2021-08-27 | Pierce | Georgia | 13229 | 3592 | 71 |
1654679 | 1654679 | 2021-08-26 | Pierce | Georgia | 13229 | 3533 | 70 |
1651432 | 1651432 | 2021-08-25 | Pierce | Georgia | 13229 | 3442 | 67 |
1648183 | 1648183 | 2021-08-24 | Pierce | Georgia | 13229 | 3420 | 66 |
1644935 | 1644935 | 2021-08-23 | Pierce | Georgia | 13229 | 3361 | 65 |
1641685 | 1641685 | 2021-08-22 | Pierce | Georgia | 13229 | 3253 | 65 |
1638435 | 1638435 | 2021-08-21 | Pierce | Georgia | 13229 | 3253 | 65 |
1635185 | 1635185 | 2021-08-20 | Pierce | Georgia | 13229 | 3253 | 65 |
1631936 | 1631936 | 2021-08-19 | Pierce | Georgia | 13229 | 3200 | 65 |
1628689 | 1628689 | 2021-08-18 | Pierce | Georgia | 13229 | 3142 | 64 |
1625442 | 1625442 | 2021-08-17 | Pierce | Georgia | 13229 | 3096 | 63 |
1622195 | 1622195 | 2021-08-16 | Pierce | Georgia | 13229 | 3061 | 63 |
1618948 | 1618948 | 2021-08-15 | Pierce | Georgia | 13229 | 2998 | 63 |
1615700 | 1615700 | 2021-08-14 | Pierce | Georgia | 13229 | 2998 | 63 |
1612451 | 1612451 | 2021-08-13 | Pierce | Georgia | 13229 | 2998 | 63 |
1609203 | 1609203 | 2021-08-12 | Pierce | Georgia | 13229 | 2977 | 63 |
1605954 | 1605954 | 2021-08-11 | Pierce | Georgia | 13229 | 2945 | 63 |
1602705 | 1602705 | 2021-08-10 | Pierce | Georgia | 13229 | 2923 | 63 |
1599456 | 1599456 | 2021-08-09 | Pierce | Georgia | 13229 | 2898 | 63 |
1596207 | 1596207 | 2021-08-08 | Pierce | Georgia | 13229 | 2868 | 63 |
1592958 | 1592958 | 2021-08-07 | Pierce | Georgia | 13229 | 2868 | 63 |
1589709 | 1589709 | 2021-08-06 | Pierce | Georgia | 13229 | 2868 | 63 |
1586460 | 1586460 | 2021-08-05 | Pierce | Georgia | 13229 | 2843 | 62 |
1583210 | 1583210 | 2021-08-04 | Pierce | Georgia | 13229 | 2798 | 62 |
1579960 | 1579960 | 2021-08-03 | Pierce | Georgia | 13229 | 2774 | 62 |
1576712 | 1576712 | 2021-08-02 | Pierce | Georgia | 13229 | 2739 | 62 |
1573464 | 1573464 | 2021-08-01 | Pierce | Georgia | 13229 | 2716 | 62 |
1570216 | 1570216 | 2021-07-31 | Pierce | Georgia | 13229 | 2716 | 62 |
1566968 | 1566968 | 2021-07-30 | Pierce | Georgia | 13229 | 2716 | 62 |
1563720 | 1563720 | 2021-07-29 | Pierce | Georgia | 13229 | 2706 | 62 |
1560472 | 1560472 | 2021-07-28 | Pierce | Georgia | 13229 | 2686 | 62 |
1557225 | 1557225 | 2021-07-27 | Pierce | Georgia | 13229 | 2670 | 62 |
1553978 | 1553978 | 2021-07-26 | Pierce | Georgia | 13229 | 2650 | 62 |
1550731 | 1550731 | 2021-07-25 | Pierce | Georgia | 13229 | 2616 | 62 |
1547484 | 1547484 | 2021-07-24 | Pierce | Georgia | 13229 | 2616 | 62 |
1544237 | 1544237 | 2021-07-23 | Pierce | Georgia | 13229 | 2616 | 62 |
1540989 | 1540989 | 2021-07-22 | Pierce | Georgia | 13229 | 2603 | 62 |
1537742 | 1537742 | 2021-07-21 | Pierce | Georgia | 13229 | 2595 | 62 |
1534494 | 1534494 | 2021-07-20 | Pierce | Georgia | 13229 | 2583 | 62 |
1531247 | 1531247 | 2021-07-19 | Pierce | Georgia | 13229 | 2567 | 62 |
1528000 | 1528000 | 2021-07-18 | Pierce | Georgia | 13229 | 2560 | 62 |
1524753 | 1524753 | 2021-07-17 | Pierce | Georgia | 13229 | 2560 | 62 |
1521505 | 1521505 | 2021-07-16 | Pierce | Georgia | 13229 | 2560 | 62 |
1518257 | 1518257 | 2021-07-15 | Pierce | Georgia | 13229 | 2558 | 62 |
1515010 | 1515010 | 2021-07-14 | Pierce | Georgia | 13229 | 2553 | 62 |
1511764 | 1511764 | 2021-07-13 | Pierce | Georgia | 13229 | 2551 | 62 |
1508517 | 1508517 | 2021-07-12 | Pierce | Georgia | 13229 | 2544 | 62 |
1505271 | 1505271 | 2021-07-11 | Pierce | Georgia | 13229 | 2542 | 62 |
1502025 | 1502025 | 2021-07-10 | Pierce | Georgia | 13229 | 2542 | 62 |
1498779 | 1498779 | 2021-07-09 | Pierce | Georgia | 13229 | 2542 | 62 |
1495532 | 1495532 | 2021-07-08 | Pierce | Georgia | 13229 | 2541 | 62 |
1492286 | 1492286 | 2021-07-07 | Pierce | Georgia | 13229 | 2540 | 62 |
1489039 | 1489039 | 2021-07-06 | Pierce | Georgia | 13229 | 2538 | 62 |
1485792 | 1485792 | 2021-07-05 | Pierce | Georgia | 13229 | 2533 | 62 |
1482546 | 1482546 | 2021-07-04 | Pierce | Georgia | 13229 | 2533 | 62 |
1479299 | 1479299 | 2021-07-03 | Pierce | Georgia | 13229 | 2533 | 62 |
1476053 | 1476053 | 2021-07-02 | Pierce | Georgia | 13229 | 2533 | 62 |
1472807 | 1472807 | 2021-07-01 | Pierce | Georgia | 13229 | 2530 | 61 |
1469561 | 1469561 | 2021-06-30 | Pierce | Georgia | 13229 | 2528 | 61 |
1466316 | 1466316 | 2021-06-29 | Pierce | Georgia | 13229 | 2519 | 61 |
1463071 | 1463071 | 2021-06-28 | Pierce | Georgia | 13229 | 2519 | 61 |
1459826 | 1459826 | 2021-06-27 | Pierce | Georgia | 13229 | 2519 | 61 |
1456581 | 1456581 | 2021-06-26 | Pierce | Georgia | 13229 | 2516 | 61 |
1453336 | 1453336 | 2021-06-25 | Pierce | Georgia | 13229 | 2514 | 61 |
1450090 | 1450090 | 2021-06-24 | Pierce | Georgia | 13229 | 2513 | 61 |
1446845 | 1446845 | 2021-06-23 | Pierce | Georgia | 13229 | 2512 | 61 |
1443600 | 1443600 | 2021-06-22 | Pierce | Georgia | 13229 | 2509 | 61 |
1440355 | 1440355 | 2021-06-21 | Pierce | Georgia | 13229 | 2508 | 61 |
1437108 | 1437108 | 2021-06-20 | Pierce | Georgia | 13229 | 2508 | 61 |
1433861 | 1433861 | 2021-06-19 | Pierce | Georgia | 13229 | 2506 | 61 |
1430615 | 1430615 | 2021-06-18 | Pierce | Georgia | 13229 | 2503 | 61 |
1427370 | 1427370 | 2021-06-17 | Pierce | Georgia | 13229 | 2502 | 61 |
1424125 | 1424125 | 2021-06-16 | Pierce | Georgia | 13229 | 2502 | 61 |
1420877 | 1420877 | 2021-06-15 | Pierce | Georgia | 13229 | 2502 | 58 |
1417632 | 1417632 | 2021-06-14 | Pierce | Georgia | 13229 | 2505 | 58 |
1414386 | 1414386 | 2021-06-13 | Pierce | Georgia | 13229 | 2505 | 58 |
1411141 | 1411141 | 2021-06-12 | Pierce | Georgia | 13229 | 2505 | 58 |
1407896 | 1407896 | 2021-06-11 | Pierce | Georgia | 13229 | 2506 | 58 |
1404650 | 1404650 | 2021-06-10 | Pierce | Georgia | 13229 | 2507 | 57 |
1401405 | 1401405 | 2021-06-09 | Pierce | Georgia | 13229 | 2505 | 57 |
1398160 | 1398160 | 2021-06-08 | Pierce | Georgia | 13229 | 2504 | 57 |
1394913 | 1394913 | 2021-06-07 | Pierce | Georgia | 13229 | 2500 | 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);