ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Allen" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278248 | 1278248 | 2021-05-02 | Allen | Indiana | 18003 | 40166 | 696 |
1275001 | 1275001 | 2021-05-01 | Allen | Indiana | 18003 | 40066 | 696 |
1271754 | 1271754 | 2021-04-30 | Allen | Indiana | 18003 | 39995 | 696 |
1268507 | 1268507 | 2021-04-29 | Allen | Indiana | 18003 | 39913 | 696 |
1265260 | 1265260 | 2021-04-28 | Allen | Indiana | 18003 | 39845 | 694 |
1262013 | 1262013 | 2021-04-27 | Allen | Indiana | 18003 | 39770 | 693 |
1258766 | 1258766 | 2021-04-26 | Allen | Indiana | 18003 | 39706 | 693 |
1255519 | 1255519 | 2021-04-25 | Allen | Indiana | 18003 | 39653 | 693 |
1252272 | 1252272 | 2021-04-24 | Allen | Indiana | 18003 | 39608 | 693 |
1249025 | 1249025 | 2021-04-23 | Allen | Indiana | 18003 | 39547 | 693 |
1245778 | 1245778 | 2021-04-22 | Allen | Indiana | 18003 | 39469 | 693 |
1242531 | 1242531 | 2021-04-21 | Allen | Indiana | 18003 | 39392 | 693 |
1239284 | 1239284 | 2021-04-20 | Allen | Indiana | 18003 | 39334 | 694 |
1236037 | 1236037 | 2021-04-19 | Allen | Indiana | 18003 | 39279 | 693 |
1232790 | 1232790 | 2021-04-18 | Allen | Indiana | 18003 | 39240 | 693 |
1229541 | 1229541 | 2021-04-17 | Allen | Indiana | 18003 | 39161 | 692 |
1226293 | 1226293 | 2021-04-16 | Allen | Indiana | 18003 | 39095 | 691 |
1223046 | 1223046 | 2021-04-15 | Allen | Indiana | 18003 | 38981 | 691 |
1219798 | 1219798 | 2021-04-14 | Allen | Indiana | 18003 | 38922 | 691 |
1216550 | 1216550 | 2021-04-13 | Allen | Indiana | 18003 | 38836 | 691 |
1213303 | 1213303 | 2021-04-12 | Allen | Indiana | 18003 | 38741 | 691 |
1210055 | 1210055 | 2021-04-11 | Allen | Indiana | 18003 | 38662 | 691 |
1206806 | 1206806 | 2021-04-10 | Allen | Indiana | 18003 | 38566 | 690 |
1203558 | 1203558 | 2021-04-09 | Allen | Indiana | 18003 | 38496 | 689 |
1200310 | 1200310 | 2021-04-08 | Allen | Indiana | 18003 | 38399 | 687 |
1197061 | 1197061 | 2021-04-07 | Allen | Indiana | 18003 | 38310 | 687 |
1193813 | 1193813 | 2021-04-06 | Allen | Indiana | 18003 | 38233 | 687 |
1190563 | 1190563 | 2021-04-05 | Allen | Indiana | 18003 | 38192 | 686 |
1187316 | 1187316 | 2021-04-04 | Allen | Indiana | 18003 | 38140 | 685 |
1184069 | 1184069 | 2021-04-03 | Allen | Indiana | 18003 | 38077 | 685 |
1180822 | 1180822 | 2021-04-02 | Allen | Indiana | 18003 | 38005 | 685 |
1177575 | 1177575 | 2021-04-01 | Allen | Indiana | 18003 | 37910 | 684 |
1174328 | 1174328 | 2021-03-31 | Allen | Indiana | 18003 | 37837 | 684 |
1171081 | 1171081 | 2021-03-30 | Allen | Indiana | 18003 | 37769 | 684 |
1167833 | 1167833 | 2021-03-29 | Allen | Indiana | 18003 | 37699 | 684 |
1164585 | 1164585 | 2021-03-28 | Allen | Indiana | 18003 | 37634 | 683 |
1161337 | 1161337 | 2021-03-27 | Allen | Indiana | 18003 | 37569 | 682 |
1158089 | 1158089 | 2021-03-26 | Allen | Indiana | 18003 | 37492 | 681 |
1154842 | 1154842 | 2021-03-25 | Allen | Indiana | 18003 | 37391 | 680 |
1151595 | 1151595 | 2021-03-24 | Allen | Indiana | 18003 | 37302 | 679 |
1148348 | 1148348 | 2021-03-23 | Allen | Indiana | 18003 | 37202 | 679 |
1145101 | 1145101 | 2021-03-22 | Allen | Indiana | 18003 | 37152 | 679 |
1141854 | 1141854 | 2021-03-21 | Allen | Indiana | 18003 | 37126 | 679 |
1138608 | 1138608 | 2021-03-20 | Allen | Indiana | 18003 | 37049 | 679 |
1135362 | 1135362 | 2021-03-19 | Allen | Indiana | 18003 | 36972 | 679 |
1132115 | 1132115 | 2021-03-18 | Allen | Indiana | 18003 | 36907 | 679 |
1128867 | 1128867 | 2021-03-17 | Allen | Indiana | 18003 | 36837 | 678 |
1125621 | 1125621 | 2021-03-16 | Allen | Indiana | 18003 | 36761 | 676 |
1122375 | 1122375 | 2021-03-15 | Allen | Indiana | 18003 | 36708 | 676 |
1119128 | 1119128 | 2021-03-14 | Allen | Indiana | 18003 | 36670 | 676 |
1115881 | 1115881 | 2021-03-13 | Allen | Indiana | 18003 | 36621 | 676 |
1112635 | 1112635 | 2021-03-12 | Allen | Indiana | 18003 | 36533 | 675 |
1109389 | 1109389 | 2021-03-11 | Allen | Indiana | 18003 | 36432 | 673 |
1106143 | 1106143 | 2021-03-10 | Allen | Indiana | 18003 | 36376 | 671 |
1102897 | 1102897 | 2021-03-09 | Allen | Indiana | 18003 | 36305 | 670 |
1099651 | 1099651 | 2021-03-08 | Allen | Indiana | 18003 | 36264 | 671 |
1096403 | 1096403 | 2021-03-07 | Allen | Indiana | 18003 | 36228 | 671 |
1093157 | 1093157 | 2021-03-06 | Allen | Indiana | 18003 | 36155 | 669 |
1089911 | 1089911 | 2021-03-05 | Allen | Indiana | 18003 | 36103 | 666 |
1086666 | 1086666 | 2021-03-04 | Allen | Indiana | 18003 | 36056 | 665 |
1083420 | 1083420 | 2021-03-03 | Allen | Indiana | 18003 | 36003 | 663 |
1080174 | 1080174 | 2021-03-02 | Allen | Indiana | 18003 | 35949 | 663 |
1076929 | 1076929 | 2021-03-01 | Allen | Indiana | 18003 | 35913 | 661 |
1073683 | 1073683 | 2021-02-28 | Allen | Indiana | 18003 | 35858 | 660 |
1070437 | 1070437 | 2021-02-27 | Allen | Indiana | 18003 | 35814 | 660 |
1067192 | 1067192 | 2021-02-26 | Allen | Indiana | 18003 | 35772 | 658 |
1063947 | 1063947 | 2021-02-25 | Allen | Indiana | 18003 | 35715 | 657 |
1060702 | 1060702 | 2021-02-24 | Allen | Indiana | 18003 | 35666 | 657 |
1057456 | 1057456 | 2021-02-23 | Allen | Indiana | 18003 | 35603 | 656 |
1054210 | 1054210 | 2021-02-22 | Allen | Indiana | 18003 | 35545 | 655 |
1050963 | 1050963 | 2021-02-21 | Allen | Indiana | 18003 | 35490 | 654 |
1047716 | 1047716 | 2021-02-20 | Allen | Indiana | 18003 | 35434 | 655 |
1044471 | 1044471 | 2021-02-19 | Allen | Indiana | 18003 | 35355 | 655 |
1041226 | 1041226 | 2021-02-18 | Allen | Indiana | 18003 | 35298 | 654 |
1037981 | 1037981 | 2021-02-17 | Allen | Indiana | 18003 | 35256 | 651 |
1034736 | 1034736 | 2021-02-16 | Allen | Indiana | 18003 | 35181 | 649 |
1031490 | 1031490 | 2021-02-15 | Allen | Indiana | 18003 | 35106 | 647 |
1028243 | 1028243 | 2021-02-14 | Allen | Indiana | 18003 | 35063 | 647 |
1024998 | 1024998 | 2021-02-13 | Allen | Indiana | 18003 | 34978 | 644 |
1021753 | 1021753 | 2021-02-12 | Allen | Indiana | 18003 | 34906 | 644 |
1018508 | 1018508 | 2021-02-11 | Allen | Indiana | 18003 | 34815 | 643 |
1015263 | 1015263 | 2021-02-10 | Allen | Indiana | 18003 | 34724 | 642 |
1012018 | 1012018 | 2021-02-09 | Allen | Indiana | 18003 | 34622 | 639 |
1008772 | 1008772 | 2021-02-08 | Allen | Indiana | 18003 | 34537 | 636 |
1005526 | 1005526 | 2021-02-07 | Allen | Indiana | 18003 | 34473 | 636 |
1002280 | 1002280 | 2021-02-06 | Allen | Indiana | 18003 | 34365 | 633 |
999034 | 999034 | 2021-02-05 | Allen | Indiana | 18003 | 34199 | 631 |
995788 | 995788 | 2021-02-04 | Allen | Indiana | 18003 | 34130 | 626 |
992542 | 992542 | 2021-02-03 | Allen | Indiana | 18003 | 33995 | 590 |
989296 | 989296 | 2021-02-02 | Allen | Indiana | 18003 | 33917 | 590 |
986049 | 986049 | 2021-02-01 | Allen | Indiana | 18003 | 33824 | 588 |
982802 | 982802 | 2021-01-31 | Allen | Indiana | 18003 | 33740 | 588 |
979556 | 979556 | 2021-01-30 | Allen | Indiana | 18003 | 33664 | 588 |
976310 | 976310 | 2021-01-29 | Allen | Indiana | 18003 | 33530 | 586 |
973065 | 973065 | 2021-01-28 | Allen | Indiana | 18003 | 33417 | 586 |
969820 | 969820 | 2021-01-27 | Allen | Indiana | 18003 | 33286 | 584 |
966576 | 966576 | 2021-01-26 | Allen | Indiana | 18003 | 33151 | 582 |
963331 | 963331 | 2021-01-25 | Allen | Indiana | 18003 | 33029 | 575 |
960086 | 960086 | 2021-01-24 | Allen | Indiana | 18003 | 32940 | 575 |
956840 | 956840 | 2021-01-23 | Allen | Indiana | 18003 | 32852 | 571 |
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);