ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Jay" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054246 | 1054246 | 2021-02-22 | Jay | Indiana | 18075 | 1782 | 30 |
1050999 | 1050999 | 2021-02-21 | Jay | Indiana | 18075 | 1780 | 30 |
1047752 | 1047752 | 2021-02-20 | Jay | Indiana | 18075 | 1778 | 30 |
1044507 | 1044507 | 2021-02-19 | Jay | Indiana | 18075 | 1777 | 30 |
1041262 | 1041262 | 2021-02-18 | Jay | Indiana | 18075 | 1777 | 30 |
1038017 | 1038017 | 2021-02-17 | Jay | Indiana | 18075 | 1777 | 30 |
1034772 | 1034772 | 2021-02-16 | Jay | Indiana | 18075 | 1776 | 30 |
1031526 | 1031526 | 2021-02-15 | Jay | Indiana | 18075 | 1775 | 30 |
1028279 | 1028279 | 2021-02-14 | Jay | Indiana | 18075 | 1774 | 30 |
1025034 | 1025034 | 2021-02-13 | Jay | Indiana | 18075 | 1773 | 30 |
1021789 | 1021789 | 2021-02-12 | Jay | Indiana | 18075 | 1770 | 30 |
1018544 | 1018544 | 2021-02-11 | Jay | Indiana | 18075 | 1770 | 29 |
1015299 | 1015299 | 2021-02-10 | Jay | Indiana | 18075 | 1769 | 29 |
1012054 | 1012054 | 2021-02-09 | Jay | Indiana | 18075 | 1766 | 29 |
1008808 | 1008808 | 2021-02-08 | Jay | Indiana | 18075 | 1762 | 28 |
1005562 | 1005562 | 2021-02-07 | Jay | Indiana | 18075 | 1762 | 28 |
1002316 | 1002316 | 2021-02-06 | Jay | Indiana | 18075 | 1759 | 28 |
999070 | 999070 | 2021-02-05 | Jay | Indiana | 18075 | 1756 | 28 |
995824 | 995824 | 2021-02-04 | Jay | Indiana | 18075 | 1754 | 28 |
992578 | 992578 | 2021-02-03 | Jay | Indiana | 18075 | 1747 | 25 |
989332 | 989332 | 2021-02-02 | Jay | Indiana | 18075 | 1741 | 25 |
986085 | 986085 | 2021-02-01 | Jay | Indiana | 18075 | 1733 | 25 |
982838 | 982838 | 2021-01-31 | Jay | Indiana | 18075 | 1730 | 25 |
979592 | 979592 | 2021-01-30 | Jay | Indiana | 18075 | 1723 | 25 |
976346 | 976346 | 2021-01-29 | Jay | Indiana | 18075 | 1716 | 25 |
973101 | 973101 | 2021-01-28 | Jay | Indiana | 18075 | 1710 | 25 |
969856 | 969856 | 2021-01-27 | Jay | Indiana | 18075 | 1703 | 25 |
966612 | 966612 | 2021-01-26 | Jay | Indiana | 18075 | 1696 | 25 |
963367 | 963367 | 2021-01-25 | Jay | Indiana | 18075 | 1695 | 25 |
960122 | 960122 | 2021-01-24 | Jay | Indiana | 18075 | 1691 | 25 |
956876 | 956876 | 2021-01-23 | Jay | Indiana | 18075 | 1685 | 25 |
953631 | 953631 | 2021-01-22 | Jay | Indiana | 18075 | 1679 | 24 |
950386 | 950386 | 2021-01-21 | Jay | Indiana | 18075 | 1672 | 24 |
947140 | 947140 | 2021-01-20 | Jay | Indiana | 18075 | 1657 | 24 |
943893 | 943893 | 2021-01-19 | Jay | Indiana | 18075 | 1648 | 24 |
940648 | 940648 | 2021-01-18 | Jay | Indiana | 18075 | 1640 | 24 |
937403 | 937403 | 2021-01-17 | Jay | Indiana | 18075 | 1637 | 23 |
934158 | 934158 | 2021-01-16 | Jay | Indiana | 18075 | 1629 | 23 |
930913 | 930913 | 2021-01-15 | Jay | Indiana | 18075 | 1620 | 23 |
927668 | 927668 | 2021-01-14 | Jay | Indiana | 18075 | 1614 | 23 |
924422 | 924422 | 2021-01-13 | Jay | Indiana | 18075 | 1608 | 23 |
921177 | 921177 | 2021-01-12 | Jay | Indiana | 18075 | 1605 | 23 |
917932 | 917932 | 2021-01-11 | Jay | Indiana | 18075 | 1600 | 23 |
914687 | 914687 | 2021-01-10 | Jay | Indiana | 18075 | 1591 | 23 |
911442 | 911442 | 2021-01-09 | Jay | Indiana | 18075 | 1585 | 23 |
908197 | 908197 | 2021-01-08 | Jay | Indiana | 18075 | 1572 | 23 |
904951 | 904951 | 2021-01-07 | Jay | Indiana | 18075 | 1558 | 23 |
901706 | 901706 | 2021-01-06 | Jay | Indiana | 18075 | 1553 | 23 |
898461 | 898461 | 2021-01-05 | Jay | Indiana | 18075 | 1543 | 23 |
895216 | 895216 | 2021-01-04 | Jay | Indiana | 18075 | 1541 | 23 |
891969 | 891969 | 2021-01-03 | Jay | Indiana | 18075 | 1532 | 23 |
888723 | 888723 | 2021-01-02 | Jay | Indiana | 18075 | 1529 | 23 |
885477 | 885477 | 2021-01-01 | Jay | Indiana | 18075 | 1520 | 23 |
882232 | 882232 | 2020-12-31 | Jay | Indiana | 18075 | 1510 | 22 |
878987 | 878987 | 2020-12-30 | Jay | Indiana | 18075 | 1502 | 22 |
875742 | 875742 | 2020-12-29 | Jay | Indiana | 18075 | 1496 | 22 |
872497 | 872497 | 2020-12-28 | Jay | Indiana | 18075 | 1487 | 22 |
869252 | 869252 | 2020-12-27 | Jay | Indiana | 18075 | 1485 | 22 |
866007 | 866007 | 2020-12-26 | Jay | Indiana | 18075 | 1482 | 22 |
862762 | 862762 | 2020-12-25 | Jay | Indiana | 18075 | 1477 | 22 |
859517 | 859517 | 2020-12-24 | Jay | Indiana | 18075 | 1468 | 22 |
856272 | 856272 | 2020-12-23 | Jay | Indiana | 18075 | 1465 | 22 |
853027 | 853027 | 2020-12-22 | Jay | Indiana | 18075 | 1456 | 22 |
849782 | 849782 | 2020-12-21 | Jay | Indiana | 18075 | 1447 | 22 |
846537 | 846537 | 2020-12-20 | Jay | Indiana | 18075 | 1442 | 22 |
843291 | 843291 | 2020-12-19 | Jay | Indiana | 18075 | 1435 | 22 |
840046 | 840046 | 2020-12-18 | Jay | Indiana | 18075 | 1423 | 22 |
836801 | 836801 | 2020-12-17 | Jay | Indiana | 18075 | 1416 | 22 |
833555 | 833555 | 2020-12-16 | Jay | Indiana | 18075 | 1402 | 22 |
830308 | 830308 | 2020-12-15 | Jay | Indiana | 18075 | 1393 | 22 |
827062 | 827062 | 2020-12-14 | Jay | Indiana | 18075 | 1372 | 22 |
823815 | 823815 | 2020-12-13 | Jay | Indiana | 18075 | 1361 | 22 |
820569 | 820569 | 2020-12-12 | Jay | Indiana | 18075 | 1354 | 22 |
817323 | 817323 | 2020-12-11 | Jay | Indiana | 18075 | 1327 | 21 |
814077 | 814077 | 2020-12-10 | Jay | Indiana | 18075 | 1306 | 21 |
810832 | 810832 | 2020-12-09 | Jay | Indiana | 18075 | 1291 | 21 |
807587 | 807587 | 2020-12-08 | Jay | Indiana | 18075 | 1266 | 21 |
804342 | 804342 | 2020-12-07 | Jay | Indiana | 18075 | 1254 | 20 |
801097 | 801097 | 2020-12-06 | Jay | Indiana | 18075 | 1230 | 20 |
797852 | 797852 | 2020-12-05 | Jay | Indiana | 18075 | 1222 | 20 |
794607 | 794607 | 2020-12-04 | Jay | Indiana | 18075 | 1197 | 19 |
791362 | 791362 | 2020-12-03 | Jay | Indiana | 18075 | 1164 | 18 |
788117 | 788117 | 2020-12-02 | Jay | Indiana | 18075 | 1142 | 17 |
784873 | 784873 | 2020-12-01 | Jay | Indiana | 18075 | 1114 | 17 |
781628 | 781628 | 2020-11-30 | Jay | Indiana | 18075 | 1074 | 16 |
778382 | 778382 | 2020-11-29 | Jay | Indiana | 18075 | 1054 | 16 |
775137 | 775137 | 2020-11-28 | Jay | Indiana | 18075 | 1043 | 16 |
771892 | 771892 | 2020-11-27 | Jay | Indiana | 18075 | 1029 | 15 |
768647 | 768647 | 2020-11-26 | Jay | Indiana | 18075 | 1017 | 15 |
765401 | 765401 | 2020-11-25 | Jay | Indiana | 18075 | 1000 | 15 |
762156 | 762156 | 2020-11-24 | Jay | Indiana | 18075 | 974 | 15 |
758911 | 758911 | 2020-11-23 | Jay | Indiana | 18075 | 960 | 14 |
755664 | 755664 | 2020-11-22 | Jay | Indiana | 18075 | 940 | 14 |
752418 | 752418 | 2020-11-21 | Jay | Indiana | 18075 | 928 | 13 |
749172 | 749172 | 2020-11-20 | Jay | Indiana | 18075 | 884 | 12 |
745926 | 745926 | 2020-11-19 | Jay | Indiana | 18075 | 851 | 12 |
742679 | 742679 | 2020-11-18 | Jay | Indiana | 18075 | 812 | 11 |
739432 | 739432 | 2020-11-17 | Jay | Indiana | 18075 | 782 | 11 |
736188 | 736188 | 2020-11-16 | Jay | Indiana | 18075 | 758 | 10 |
732942 | 732942 | 2020-11-15 | Jay | Indiana | 18075 | 727 | 10 |
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);