ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Johnson" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194826 | 1194826 | 2021-04-06 | Johnson | Nebraska | 31097 | 634 | 9 |
1191577 | 1191577 | 2021-04-05 | Johnson | Nebraska | 31097 | 635 | 9 |
1188329 | 1188329 | 2021-04-04 | Johnson | Nebraska | 31097 | 635 | 9 |
1185082 | 1185082 | 2021-04-03 | Johnson | Nebraska | 31097 | 635 | 9 |
1181836 | 1181836 | 2021-04-02 | Johnson | Nebraska | 31097 | 638 | 9 |
1178589 | 1178589 | 2021-04-01 | Johnson | Nebraska | 31097 | 636 | 9 |
1175342 | 1175342 | 2021-03-31 | Johnson | Nebraska | 31097 | 637 | 9 |
1172095 | 1172095 | 2021-03-30 | Johnson | Nebraska | 31097 | 637 | 9 |
1168847 | 1168847 | 2021-03-29 | Johnson | Nebraska | 31097 | 637 | 9 |
1165599 | 1165599 | 2021-03-28 | Johnson | Nebraska | 31097 | 637 | 9 |
1162351 | 1162351 | 2021-03-27 | Johnson | Nebraska | 31097 | 637 | 9 |
1159103 | 1159103 | 2021-03-26 | Johnson | Nebraska | 31097 | 635 | 9 |
1155856 | 1155856 | 2021-03-25 | Johnson | Nebraska | 31097 | 635 | 9 |
1152609 | 1152609 | 2021-03-24 | Johnson | Nebraska | 31097 | 636 | 9 |
1149362 | 1149362 | 2021-03-23 | Johnson | Nebraska | 31097 | 635 | 8 |
1146115 | 1146115 | 2021-03-22 | Johnson | Nebraska | 31097 | 635 | 8 |
1142868 | 1142868 | 2021-03-21 | Johnson | Nebraska | 31097 | 635 | 8 |
1139621 | 1139621 | 2021-03-20 | Johnson | Nebraska | 31097 | 635 | 8 |
1136375 | 1136375 | 2021-03-19 | Johnson | Nebraska | 31097 | 634 | 8 |
1133129 | 1133129 | 2021-03-18 | Johnson | Nebraska | 31097 | 633 | 8 |
1129881 | 1129881 | 2021-03-17 | Johnson | Nebraska | 31097 | 633 | 8 |
1126634 | 1126634 | 2021-03-16 | Johnson | Nebraska | 31097 | 632 | 8 |
1123388 | 1123388 | 2021-03-15 | Johnson | Nebraska | 31097 | 629 | 8 |
1120141 | 1120141 | 2021-03-14 | Johnson | Nebraska | 31097 | 629 | 8 |
1116894 | 1116894 | 2021-03-13 | Johnson | Nebraska | 31097 | 629 | 8 |
1113648 | 1113648 | 2021-03-12 | Johnson | Nebraska | 31097 | 629 | 8 |
1110402 | 1110402 | 2021-03-11 | Johnson | Nebraska | 31097 | 630 | 8 |
1107156 | 1107156 | 2021-03-10 | Johnson | Nebraska | 31097 | 630 | 8 |
1103910 | 1103910 | 2021-03-09 | Johnson | Nebraska | 31097 | 630 | 8 |
1100664 | 1100664 | 2021-03-08 | Johnson | Nebraska | 31097 | 630 | 8 |
1097417 | 1097417 | 2021-03-07 | Johnson | Nebraska | 31097 | 630 | 8 |
1094170 | 1094170 | 2021-03-06 | Johnson | Nebraska | 31097 | 629 | 8 |
1090924 | 1090924 | 2021-03-05 | Johnson | Nebraska | 31097 | 628 | 8 |
1087679 | 1087679 | 2021-03-04 | Johnson | Nebraska | 31097 | 628 | 8 |
1084434 | 1084434 | 2021-03-03 | Johnson | Nebraska | 31097 | 629 | 8 |
1081188 | 1081188 | 2021-03-02 | Johnson | Nebraska | 31097 | 628 | 8 |
1077942 | 1077942 | 2021-03-01 | Johnson | Nebraska | 31097 | 628 | 8 |
1074696 | 1074696 | 2021-02-28 | Johnson | Nebraska | 31097 | 628 | 8 |
1071450 | 1071450 | 2021-02-27 | Johnson | Nebraska | 31097 | 628 | 8 |
1068205 | 1068205 | 2021-02-26 | Johnson | Nebraska | 31097 | 629 | 8 |
1064960 | 1064960 | 2021-02-25 | Johnson | Nebraska | 31097 | 628 | 8 |
1061716 | 1061716 | 2021-02-24 | Johnson | Nebraska | 31097 | 628 | 8 |
1058470 | 1058470 | 2021-02-23 | Johnson | Nebraska | 31097 | 627 | 8 |
1055224 | 1055224 | 2021-02-22 | Johnson | Nebraska | 31097 | 627 | 8 |
1051977 | 1051977 | 2021-02-21 | Johnson | Nebraska | 31097 | 626 | 8 |
1048730 | 1048730 | 2021-02-20 | Johnson | Nebraska | 31097 | 626 | 8 |
1045484 | 1045484 | 2021-02-19 | Johnson | Nebraska | 31097 | 625 | 8 |
1042239 | 1042239 | 2021-02-18 | Johnson | Nebraska | 31097 | 625 | 8 |
1038994 | 1038994 | 2021-02-17 | Johnson | Nebraska | 31097 | 625 | 8 |
1035749 | 1035749 | 2021-02-16 | Johnson | Nebraska | 31097 | 626 | 8 |
1032504 | 1032504 | 2021-02-15 | Johnson | Nebraska | 31097 | 626 | 8 |
1029257 | 1029257 | 2021-02-14 | Johnson | Nebraska | 31097 | 626 | 8 |
1026011 | 1026011 | 2021-02-13 | Johnson | Nebraska | 31097 | 626 | 8 |
1022766 | 1022766 | 2021-02-12 | Johnson | Nebraska | 31097 | 626 | 8 |
1019521 | 1019521 | 2021-02-11 | Johnson | Nebraska | 31097 | 617 | 8 |
1016276 | 1016276 | 2021-02-10 | Johnson | Nebraska | 31097 | 617 | 8 |
1013031 | 1013031 | 2021-02-09 | Johnson | Nebraska | 31097 | 617 | 7 |
1009786 | 1009786 | 2021-02-08 | Johnson | Nebraska | 31097 | 616 | 7 |
1006539 | 1006539 | 2021-02-07 | Johnson | Nebraska | 31097 | 615 | 7 |
1003293 | 1003293 | 2021-02-06 | Johnson | Nebraska | 31097 | 617 | 7 |
1000048 | 1000048 | 2021-02-05 | Johnson | Nebraska | 31097 | 617 | 7 |
996802 | 996802 | 2021-02-04 | Johnson | Nebraska | 31097 | 613 | 7 |
993556 | 993556 | 2021-02-03 | Johnson | Nebraska | 31097 | 613 | 7 |
990310 | 990310 | 2021-02-02 | Johnson | Nebraska | 31097 | 615 | 7 |
987063 | 987063 | 2021-02-01 | Johnson | Nebraska | 31097 | 614 | 7 |
983816 | 983816 | 2021-01-31 | Johnson | Nebraska | 31097 | 614 | 7 |
980570 | 980570 | 2021-01-30 | Johnson | Nebraska | 31097 | 614 | 7 |
977324 | 977324 | 2021-01-29 | Johnson | Nebraska | 31097 | 611 | 7 |
974079 | 974079 | 2021-01-28 | Johnson | Nebraska | 31097 | 611 | 7 |
970834 | 970834 | 2021-01-27 | Johnson | Nebraska | 31097 | 611 | 7 |
967589 | 967589 | 2021-01-26 | Johnson | Nebraska | 31097 | 608 | 7 |
964345 | 964345 | 2021-01-25 | Johnson | Nebraska | 31097 | 608 | 7 |
961100 | 961100 | 2021-01-24 | Johnson | Nebraska | 31097 | 607 | 7 |
957854 | 957854 | 2021-01-23 | Johnson | Nebraska | 31097 | 608 | 7 |
954609 | 954609 | 2021-01-22 | Johnson | Nebraska | 31097 | 607 | 7 |
951364 | 951364 | 2021-01-21 | Johnson | Nebraska | 31097 | 606 | 7 |
948118 | 948118 | 2021-01-20 | Johnson | Nebraska | 31097 | 603 | 7 |
944871 | 944871 | 2021-01-19 | Johnson | Nebraska | 31097 | 593 | 7 |
941626 | 941626 | 2021-01-18 | Johnson | Nebraska | 31097 | 593 | 7 |
938381 | 938381 | 2021-01-17 | Johnson | Nebraska | 31097 | 595 | 7 |
935136 | 935136 | 2021-01-16 | Johnson | Nebraska | 31097 | 594 | 7 |
931891 | 931891 | 2021-01-15 | Johnson | Nebraska | 31097 | 594 | 7 |
928646 | 928646 | 2021-01-14 | Johnson | Nebraska | 31097 | 595 | 7 |
925400 | 925400 | 2021-01-13 | Johnson | Nebraska | 31097 | 591 | 6 |
922155 | 922155 | 2021-01-12 | Johnson | Nebraska | 31097 | 583 | 6 |
918910 | 918910 | 2021-01-11 | Johnson | Nebraska | 31097 | 581 | 6 |
915665 | 915665 | 2021-01-10 | Johnson | Nebraska | 31097 | 578 | 5 |
912420 | 912420 | 2021-01-09 | Johnson | Nebraska | 31097 | 576 | 5 |
909175 | 909175 | 2021-01-08 | Johnson | Nebraska | 31097 | 565 | 5 |
905929 | 905929 | 2021-01-07 | Johnson | Nebraska | 31097 | 563 | 5 |
902684 | 902684 | 2021-01-06 | Johnson | Nebraska | 31097 | 557 | 5 |
899439 | 899439 | 2021-01-05 | Johnson | Nebraska | 31097 | 548 | 5 |
896194 | 896194 | 2021-01-04 | Johnson | Nebraska | 31097 | 546 | 5 |
892947 | 892947 | 2021-01-03 | Johnson | Nebraska | 31097 | 545 | 5 |
889701 | 889701 | 2021-01-02 | Johnson | Nebraska | 31097 | 545 | 5 |
886455 | 886455 | 2021-01-01 | Johnson | Nebraska | 31097 | 543 | 5 |
883210 | 883210 | 2020-12-31 | Johnson | Nebraska | 31097 | 540 | 5 |
879965 | 879965 | 2020-12-30 | Johnson | Nebraska | 31097 | 536 | 5 |
876720 | 876720 | 2020-12-29 | Johnson | Nebraska | 31097 | 536 | 5 |
873475 | 873475 | 2020-12-28 | Johnson | Nebraska | 31097 | 532 | 5 |
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);