ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 31079 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279252 | 1279252 | 2021-05-02 | Hall | Nebraska | 31079 | 7744 | 117 |
1276005 | 1276005 | 2021-05-01 | Hall | Nebraska | 31079 | 7744 | 117 |
1272758 | 1272758 | 2021-04-30 | Hall | Nebraska | 31079 | 7744 | 117 |
1269511 | 1269511 | 2021-04-29 | Hall | Nebraska | 31079 | 7744 | 117 |
1266264 | 1266264 | 2021-04-28 | Hall | Nebraska | 31079 | 7731 | 117 |
1263017 | 1263017 | 2021-04-27 | Hall | Nebraska | 31079 | 7731 | 117 |
1259770 | 1259770 | 2021-04-26 | Hall | Nebraska | 31079 | 7731 | 117 |
1256523 | 1256523 | 2021-04-25 | Hall | Nebraska | 31079 | 7711 | 117 |
1253276 | 1253276 | 2021-04-24 | Hall | Nebraska | 31079 | 7711 | 117 |
1250029 | 1250029 | 2021-04-23 | Hall | Nebraska | 31079 | 7704 | 117 |
1246782 | 1246782 | 2021-04-22 | Hall | Nebraska | 31079 | 7704 | 116 |
1243535 | 1243535 | 2021-04-21 | Hall | Nebraska | 31079 | 7704 | 116 |
1240288 | 1240288 | 2021-04-20 | Hall | Nebraska | 31079 | 7697 | 116 |
1237041 | 1237041 | 2021-04-19 | Hall | Nebraska | 31079 | 7697 | 116 |
1233794 | 1233794 | 2021-04-18 | Hall | Nebraska | 31079 | 7687 | 115 |
1230546 | 1230546 | 2021-04-17 | Hall | Nebraska | 31079 | 7687 | 115 |
1227298 | 1227298 | 2021-04-16 | Hall | Nebraska | 31079 | 7687 | 115 |
1224050 | 1224050 | 2021-04-15 | Hall | Nebraska | 31079 | 7679 | 115 |
1220803 | 1220803 | 2021-04-14 | Hall | Nebraska | 31079 | 7679 | 115 |
1217555 | 1217555 | 2021-04-13 | Hall | Nebraska | 31079 | 7668 | 115 |
1214308 | 1214308 | 2021-04-12 | Hall | Nebraska | 31079 | 7668 | 115 |
1211060 | 1211060 | 2021-04-11 | Hall | Nebraska | 31079 | 7660 | 115 |
1207811 | 1207811 | 2021-04-10 | Hall | Nebraska | 31079 | 7660 | 115 |
1204563 | 1204563 | 2021-04-09 | Hall | Nebraska | 31079 | 7645 | 115 |
1201315 | 1201315 | 2021-04-08 | Hall | Nebraska | 31079 | 7645 | 115 |
1198066 | 1198066 | 2021-04-07 | Hall | Nebraska | 31079 | 7645 | 112 |
1194817 | 1194817 | 2021-04-06 | Hall | Nebraska | 31079 | 7639 | 112 |
1191568 | 1191568 | 2021-04-05 | Hall | Nebraska | 31079 | 7639 | 112 |
1188320 | 1188320 | 2021-04-04 | Hall | Nebraska | 31079 | 7628 | 112 |
1185073 | 1185073 | 2021-04-03 | Hall | Nebraska | 31079 | 7628 | 112 |
1181827 | 1181827 | 2021-04-02 | Hall | Nebraska | 31079 | 7628 | 112 |
1178580 | 1178580 | 2021-04-01 | Hall | Nebraska | 31079 | 7612 | 112 |
1175333 | 1175333 | 2021-03-31 | Hall | Nebraska | 31079 | 7612 | 112 |
1172086 | 1172086 | 2021-03-30 | Hall | Nebraska | 31079 | 7573 | 112 |
1168838 | 1168838 | 2021-03-29 | Hall | Nebraska | 31079 | 7573 | 112 |
1165590 | 1165590 | 2021-03-28 | Hall | Nebraska | 31079 | 7558 | 112 |
1162342 | 1162342 | 2021-03-27 | Hall | Nebraska | 31079 | 7558 | 112 |
1159094 | 1159094 | 2021-03-26 | Hall | Nebraska | 31079 | 7558 | 112 |
1155847 | 1155847 | 2021-03-25 | Hall | Nebraska | 31079 | 7540 | 112 |
1152600 | 1152600 | 2021-03-24 | Hall | Nebraska | 31079 | 7540 | 112 |
1149353 | 1149353 | 2021-03-23 | Hall | Nebraska | 31079 | 7539 | 112 |
1146106 | 1146106 | 2021-03-22 | Hall | Nebraska | 31079 | 7539 | 112 |
1142859 | 1142859 | 2021-03-21 | Hall | Nebraska | 31079 | 7498 | 112 |
1139612 | 1139612 | 2021-03-20 | Hall | Nebraska | 31079 | 7498 | 112 |
1136366 | 1136366 | 2021-03-19 | Hall | Nebraska | 31079 | 7498 | 112 |
1133120 | 1133120 | 2021-03-18 | Hall | Nebraska | 31079 | 7479 | 112 |
1129872 | 1129872 | 2021-03-17 | Hall | Nebraska | 31079 | 7479 | 112 |
1126625 | 1126625 | 2021-03-16 | Hall | Nebraska | 31079 | 7438 | 112 |
1123379 | 1123379 | 2021-03-15 | Hall | Nebraska | 31079 | 7438 | 112 |
1120132 | 1120132 | 2021-03-14 | Hall | Nebraska | 31079 | 7408 | 112 |
1116885 | 1116885 | 2021-03-13 | Hall | Nebraska | 31079 | 7408 | 112 |
1113639 | 1113639 | 2021-03-12 | Hall | Nebraska | 31079 | 7408 | 112 |
1110393 | 1110393 | 2021-03-11 | Hall | Nebraska | 31079 | 7355 | 112 |
1107147 | 1107147 | 2021-03-10 | Hall | Nebraska | 31079 | 7355 | 112 |
1103901 | 1103901 | 2021-03-09 | Hall | Nebraska | 31079 | 7303 | 111 |
1100655 | 1100655 | 2021-03-08 | Hall | Nebraska | 31079 | 7280 | 111 |
1097408 | 1097408 | 2021-03-07 | Hall | Nebraska | 31079 | 7280 | 111 |
1094161 | 1094161 | 2021-03-06 | Hall | Nebraska | 31079 | 7280 | 111 |
1090915 | 1090915 | 2021-03-05 | Hall | Nebraska | 31079 | 7280 | 111 |
1087670 | 1087670 | 2021-03-04 | Hall | Nebraska | 31079 | 7224 | 111 |
1084425 | 1084425 | 2021-03-03 | Hall | Nebraska | 31079 | 7224 | 111 |
1081179 | 1081179 | 2021-03-02 | Hall | Nebraska | 31079 | 7175 | 110 |
1077933 | 1077933 | 2021-03-01 | Hall | Nebraska | 31079 | 7175 | 110 |
1074687 | 1074687 | 2021-02-28 | Hall | Nebraska | 31079 | 7117 | 110 |
1071441 | 1071441 | 2021-02-27 | Hall | Nebraska | 31079 | 7117 | 110 |
1068196 | 1068196 | 2021-02-26 | Hall | Nebraska | 31079 | 7117 | 110 |
1064951 | 1064951 | 2021-02-25 | Hall | Nebraska | 31079 | 7085 | 110 |
1061707 | 1061707 | 2021-02-24 | Hall | Nebraska | 31079 | 7031 | 110 |
1058461 | 1058461 | 2021-02-23 | Hall | Nebraska | 31079 | 7031 | 110 |
1055215 | 1055215 | 2021-02-22 | Hall | Nebraska | 31079 | 7031 | 110 |
1051968 | 1051968 | 2021-02-21 | Hall | Nebraska | 31079 | 7012 | 110 |
1048721 | 1048721 | 2021-02-20 | Hall | Nebraska | 31079 | 7012 | 110 |
1045475 | 1045475 | 2021-02-19 | Hall | Nebraska | 31079 | 7012 | 110 |
1042230 | 1042230 | 2021-02-18 | Hall | Nebraska | 31079 | 6981 | 108 |
1038985 | 1038985 | 2021-02-17 | Hall | Nebraska | 31079 | 6944 | 108 |
1035740 | 1035740 | 2021-02-16 | Hall | Nebraska | 31079 | 6944 | 108 |
1032495 | 1032495 | 2021-02-15 | Hall | Nebraska | 31079 | 6944 | 108 |
1029248 | 1029248 | 2021-02-14 | Hall | Nebraska | 31079 | 6913 | 108 |
1026002 | 1026002 | 2021-02-13 | Hall | Nebraska | 31079 | 6913 | 108 |
1022757 | 1022757 | 2021-02-12 | Hall | Nebraska | 31079 | 6913 | 108 |
1019512 | 1019512 | 2021-02-11 | Hall | Nebraska | 31079 | 6880 | 108 |
1016267 | 1016267 | 2021-02-10 | Hall | Nebraska | 31079 | 6880 | 108 |
1013022 | 1013022 | 2021-02-09 | Hall | Nebraska | 31079 | 6831 | 108 |
1009777 | 1009777 | 2021-02-08 | Hall | Nebraska | 31079 | 6831 | 108 |
1006530 | 1006530 | 2021-02-07 | Hall | Nebraska | 31079 | 6788 | 107 |
1003284 | 1003284 | 2021-02-06 | Hall | Nebraska | 31079 | 6774 | 107 |
1000039 | 1000039 | 2021-02-05 | Hall | Nebraska | 31079 | 6757 | 107 |
996793 | 996793 | 2021-02-04 | Hall | Nebraska | 31079 | 6734 | 107 |
993547 | 993547 | 2021-02-03 | Hall | Nebraska | 31079 | 6697 | 105 |
990301 | 990301 | 2021-02-02 | Hall | Nebraska | 31079 | 6690 | 105 |
987054 | 987054 | 2021-02-01 | Hall | Nebraska | 31079 | 6690 | 105 |
983807 | 983807 | 2021-01-31 | Hall | Nebraska | 31079 | 6638 | 105 |
980561 | 980561 | 2021-01-30 | Hall | Nebraska | 31079 | 6624 | 105 |
977315 | 977315 | 2021-01-29 | Hall | Nebraska | 31079 | 6595 | 105 |
974070 | 974070 | 2021-01-28 | Hall | Nebraska | 31079 | 6595 | 105 |
970825 | 970825 | 2021-01-27 | Hall | Nebraska | 31079 | 6581 | 105 |
967580 | 967580 | 2021-01-26 | Hall | Nebraska | 31079 | 6546 | 105 |
964336 | 964336 | 2021-01-25 | Hall | Nebraska | 31079 | 6546 | 105 |
961091 | 961091 | 2021-01-24 | Hall | Nebraska | 31079 | 6505 | 104 |
957845 | 957845 | 2021-01-23 | Hall | Nebraska | 31079 | 6505 | 104 |
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);