ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 31107 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 332 ✖
- 1159 63
- 2 39
- 1150 33
- 1678 25
- 1677 20
- 886 17
- 9 11
- 1 10
- 8 10
- 25 10
- 834 10
- 20 9
- 10 8
- 24 8
- 844 8
- 885 7
- 1158 7
- 6 6
- 27 6
- 854 6
- 1056 6
- 1151 6
- 1155 6
- 1693 6
- 15 5
- 887 5
- 1097 5
- 1185 5
- 1288 5
- 1623 5
- 1690 5
- 33 4
- 813 4
- 840 4
- 882 4
- 1016 4
- 1318 4
- 1675 4
- 1687 4
- 5 3
- 12 3
- 41 3
- 654 3
- 760 3
- 843 3
- 856 3
- 862 3
- 866 3
- 878 3
- 980 3
- 996 3
- 1033 3
- 1123 3
- 1156 3
- 1225 3
- 1249 3
- 1274 3
- 1349 3
- 1402 3
- 1464 3
- 1534 3
- 1567 3
- 1601 3
- 1621 3
- 1694 3
- 16 2
- 30 2
- 31 2
- 35 2
- 47 2
- 62 2
- 81 2
- 84 2
- 88 2
- 131 2
- 162 2
- 192 2
- 209 2
- 237 2
- 252 2
- 354 2
- 661 2
- 729 2
- 764 2
- 792 2
- 802 2
- 803 2
- 804 2
- 805 2
- 806 2
- 832 2
- 842 2
- 853 2
- 868 2
- 880 2
- 1076 2
- 1080 2
- 1093 2
- 1240 2
- 1544 2
- 1620 2
- 1666 2
- 1674 2
- 1676 2
- 4 1
- 7 1
- 11 1
- 21 1
- 26 1
- 28 1
- 29 1
- 32 1
- 34 1
- 38 1
- 40 1
- 42 1
- 43 1
- 44 1
- 48 1
- 49 1
- 56 1
- 57 1
- 59 1
- 61 1
- 65 1
- 68 1
- 69 1
- 76 1
- 77 1
- 78 1
- 85 1
- 89 1
- 95 1
- 98 1
- 104 1
- 123 1
- 128 1
- 139 1
- 145 1
- 151 1
- 156 1
- 160 1
- 171 1
- 175 1
- 180 1
- 183 1
- 187 1
- 197 1
- 200 1
- 203 1
- 220 1
- 221 1
- 225 1
- 228 1
- 233 1
- 235 1
- 236 1
- 239 1
- 243 1
- 245 1
- 248 1
- 251 1
- 256 1
- 259 1
- 263 1
- 274 1
- 278 1
- 283 1
- 284 1
- 295 1
- 300 1
- 306 1
- 312 1
- 321 1
- 324 1
- 325 1
- 328 1
- 335 1
- 338 1
- 347 1
- 349 1
- 362 1
- 368 1
- 373 1
- 382 1
- 391 1
- 394 1
- 395 1
- 405 1
- 407 1
- 416 1
- 422 1
- 431 1
- 435 1
- 436 1
- 443 1
- 451 1
- 458 1
- 465 1
- 469 1
- 477 1
- 479 1
- 486 1
- 503 1
- 512 1
- 545 1
- 585 1
- 588 1
- 589 1
- 594 1
- 609 1
- 617 1
- 621 1
- 628 1
- 632 1
- 636 1
- 641 1
- 646 1
- 651 1
- 655 1
- 668 1
- 673 1
- 676 1
- 677 1
- 684 1
- 691 1
- 697 1
- 703 1
- 714 1
- 726 1
- 739 1
- 743 1
- 752 1
- 759 1
- 776 1
- 778 1
- 791 1
- 801 1
- 824 1
- 833 1
- 835 1
- 836 1
- 837 1
- 841 1
- 846 1
- 850 1
- 851 1
- 857 1
- 859 1
- 861 1
- 863 1
- 867 1
- 869 1
- 870 1
- 871 1
- 872 1
- 874 1
- 881 1
- 883 1
- 884 1
- 963 1
- 969 1
- 976 1
- 978 1
- 987 1
- 991 1
- 993 1
- 995 1
- 1000 1
- 1007 1
- 1010 1
- 1012 1
- 1022 1
- 1026 1
- 1031 1
- 1043 1
- 1048 1
- 1055 1
- 1084 1
- 1107 1
- 1110 1
- 1115 1
- 1118 1
- 1129 1
- 1139 1
- 1143 1
- 1149 1
- 1163 1
- 1179 1
- 1193 1
- 1201 1
- 1212 1
- 1220 1
- 1231 1
- 1245 1
- 1252 1
- 1262 1
- 1266 1
- 1268 1
- 1278 1
- 1281 1
- 1282 1
- 1297 1
- 1313 1
- 1323 1
- 1329 1
- 1337 1
- 1343 1
- 1367 1
- 1374 1
- 1383 1
- 1390 1
- 1421 1
- 1439 1
- 1448 1
- 1455 1
- 1481 1
- 1495 1
- 1517 1
- 1524 1
- 1557 1
- 1561 1
- 1580 1
- 1590 1
- 1595 1
- 1599 1
- 1606 1
- 1617 1
- 1622 1
- 1624 1
- 1667 1
- 1689 1
state 1
- Nebraska 788
fips 1
- 31107 · 788 ✖
county 1
- Knox 788
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3507 | 3507 | 2020-03-17 | Knox | Nebraska | 31107 | 1 | 0 |
4099 | 4099 | 2020-03-18 | Knox | Nebraska | 31107 | 2 | 0 |
4822 | 4822 | 2020-03-19 | Knox | Nebraska | 31107 | 2 | 0 |
5662 | 5662 | 2020-03-20 | Knox | Nebraska | 31107 | 2 | 0 |
6654 | 6654 | 2020-03-21 | Knox | Nebraska | 31107 | 2 | 0 |
7744 | 7744 | 2020-03-22 | Knox | Nebraska | 31107 | 2 | 0 |
8937 | 8937 | 2020-03-23 | Knox | Nebraska | 31107 | 2 | 0 |
10240 | 10240 | 2020-03-24 | Knox | Nebraska | 31107 | 2 | 0 |
11671 | 11671 | 2020-03-25 | Knox | Nebraska | 31107 | 2 | 0 |
13274 | 13274 | 2020-03-26 | Knox | Nebraska | 31107 | 2 | 0 |
15006 | 15006 | 2020-03-27 | Knox | Nebraska | 31107 | 2 | 0 |
16833 | 16833 | 2020-03-28 | Knox | Nebraska | 31107 | 2 | 0 |
18756 | 18756 | 2020-03-29 | Knox | Nebraska | 31107 | 2 | 0 |
20792 | 20792 | 2020-03-30 | Knox | Nebraska | 31107 | 2 | 0 |
22916 | 22916 | 2020-03-31 | Knox | Nebraska | 31107 | 2 | 0 |
25106 | 25106 | 2020-04-01 | Knox | Nebraska | 31107 | 2 | 0 |
27365 | 27365 | 2020-04-02 | Knox | Nebraska | 31107 | 2 | 0 |
29688 | 29688 | 2020-04-03 | Knox | Nebraska | 31107 | 2 | 0 |
32071 | 32071 | 2020-04-04 | Knox | Nebraska | 31107 | 2 | 0 |
34500 | 34500 | 2020-04-05 | Knox | Nebraska | 31107 | 2 | 0 |
36969 | 36969 | 2020-04-06 | Knox | Nebraska | 31107 | 2 | 0 |
39485 | 39485 | 2020-04-07 | Knox | Nebraska | 31107 | 2 | 0 |
42041 | 42041 | 2020-04-08 | Knox | Nebraska | 31107 | 2 | 0 |
44622 | 44622 | 2020-04-09 | Knox | Nebraska | 31107 | 2 | 0 |
47234 | 47234 | 2020-04-10 | Knox | Nebraska | 31107 | 2 | 0 |
49884 | 49884 | 2020-04-11 | Knox | Nebraska | 31107 | 2 | 0 |
52558 | 52558 | 2020-04-12 | Knox | Nebraska | 31107 | 2 | 0 |
55239 | 55239 | 2020-04-13 | Knox | Nebraska | 31107 | 2 | 0 |
57938 | 57938 | 2020-04-14 | Knox | Nebraska | 31107 | 2 | 0 |
60652 | 60652 | 2020-04-15 | Knox | Nebraska | 31107 | 2 | 0 |
63376 | 63376 | 2020-04-16 | Knox | Nebraska | 31107 | 2 | 0 |
66117 | 66117 | 2020-04-17 | Knox | Nebraska | 31107 | 2 | 0 |
68872 | 68872 | 2020-04-18 | Knox | Nebraska | 31107 | 2 | 0 |
71639 | 71639 | 2020-04-19 | Knox | Nebraska | 31107 | 1 | 0 |
74413 | 74413 | 2020-04-20 | Knox | Nebraska | 31107 | 1 | 0 |
77193 | 77193 | 2020-04-21 | Knox | Nebraska | 31107 | 1 | 0 |
79982 | 79982 | 2020-04-22 | Knox | Nebraska | 31107 | 1 | 0 |
82779 | 82779 | 2020-04-23 | Knox | Nebraska | 31107 | 1 | 0 |
85584 | 85584 | 2020-04-24 | Knox | Nebraska | 31107 | 1 | 0 |
88394 | 88394 | 2020-04-25 | Knox | Nebraska | 31107 | 2 | 0 |
91210 | 91210 | 2020-04-26 | Knox | Nebraska | 31107 | 1 | 0 |
94032 | 94032 | 2020-04-27 | Knox | Nebraska | 31107 | 1 | 0 |
96868 | 96868 | 2020-04-28 | Knox | Nebraska | 31107 | 2 | 0 |
99715 | 99715 | 2020-04-29 | Knox | Nebraska | 31107 | 2 | 0 |
102568 | 102568 | 2020-04-30 | Knox | Nebraska | 31107 | 2 | 0 |
105429 | 105429 | 2020-05-01 | Knox | Nebraska | 31107 | 2 | 0 |
108296 | 108296 | 2020-05-02 | Knox | Nebraska | 31107 | 2 | 0 |
111169 | 111169 | 2020-05-03 | Knox | Nebraska | 31107 | 1 | 0 |
114049 | 114049 | 2020-05-04 | Knox | Nebraska | 31107 | 2 | 0 |
116931 | 116931 | 2020-05-05 | Knox | Nebraska | 31107 | 4 | 0 |
119891 | 119891 | 2020-05-06 | Knox | Nebraska | 31107 | 5 | 0 |
122865 | 122865 | 2020-05-07 | Knox | Nebraska | 31107 | 5 | 0 |
125847 | 125847 | 2020-05-08 | Knox | Nebraska | 31107 | 5 | 0 |
128836 | 128836 | 2020-05-09 | Knox | Nebraska | 31107 | 6 | 0 |
131826 | 131826 | 2020-05-10 | Knox | Nebraska | 31107 | 6 | 0 |
134817 | 134817 | 2020-05-11 | Knox | Nebraska | 31107 | 6 | 0 |
137807 | 137807 | 2020-05-12 | Knox | Nebraska | 31107 | 6 | 0 |
140801 | 140801 | 2020-05-13 | Knox | Nebraska | 31107 | 6 | 0 |
143796 | 143796 | 2020-05-14 | Knox | Nebraska | 31107 | 6 | 0 |
146797 | 146797 | 2020-05-15 | Knox | Nebraska | 31107 | 8 | 0 |
149803 | 149803 | 2020-05-16 | Knox | Nebraska | 31107 | 8 | 0 |
152814 | 152814 | 2020-05-17 | Knox | Nebraska | 31107 | 8 | 0 |
155828 | 155828 | 2020-05-18 | Knox | Nebraska | 31107 | 8 | 0 |
158846 | 158846 | 2020-05-19 | Knox | Nebraska | 31107 | 8 | 0 |
161872 | 161872 | 2020-05-20 | Knox | Nebraska | 31107 | 8 | 0 |
164901 | 164901 | 2020-05-21 | Knox | Nebraska | 31107 | 8 | 0 |
167937 | 167937 | 2020-05-22 | Knox | Nebraska | 31107 | 8 | 0 |
170976 | 170976 | 2020-05-23 | Knox | Nebraska | 31107 | 8 | 0 |
174019 | 174019 | 2020-05-24 | Knox | Nebraska | 31107 | 7 | 0 |
177062 | 177062 | 2020-05-25 | Knox | Nebraska | 31107 | 8 | 0 |
180106 | 180106 | 2020-05-26 | Knox | Nebraska | 31107 | 9 | 0 |
183154 | 183154 | 2020-05-27 | Knox | Nebraska | 31107 | 9 | 0 |
186210 | 186210 | 2020-05-28 | Knox | Nebraska | 31107 | 9 | 0 |
189269 | 189269 | 2020-05-29 | Knox | Nebraska | 31107 | 9 | 0 |
192333 | 192333 | 2020-05-30 | Knox | Nebraska | 31107 | 9 | 0 |
195403 | 195403 | 2020-05-31 | Knox | Nebraska | 31107 | 9 | 0 |
198476 | 198476 | 2020-06-01 | Knox | Nebraska | 31107 | 9 | 0 |
201550 | 201550 | 2020-06-02 | Knox | Nebraska | 31107 | 9 | 0 |
204627 | 204627 | 2020-06-03 | Knox | Nebraska | 31107 | 9 | 0 |
207708 | 207708 | 2020-06-04 | Knox | Nebraska | 31107 | 9 | 0 |
210790 | 210790 | 2020-06-05 | Knox | Nebraska | 31107 | 9 | 0 |
213874 | 213874 | 2020-06-06 | Knox | Nebraska | 31107 | 10 | 0 |
216963 | 216963 | 2020-06-07 | Knox | Nebraska | 31107 | 10 | 0 |
220055 | 220055 | 2020-06-08 | Knox | Nebraska | 31107 | 10 | 0 |
223151 | 223151 | 2020-06-09 | Knox | Nebraska | 31107 | 10 | 0 |
226250 | 226250 | 2020-06-10 | Knox | Nebraska | 31107 | 10 | 0 |
229353 | 229353 | 2020-06-11 | Knox | Nebraska | 31107 | 10 | 0 |
232458 | 232458 | 2020-06-12 | Knox | Nebraska | 31107 | 10 | 0 |
235564 | 235564 | 2020-06-13 | Knox | Nebraska | 31107 | 10 | 0 |
238671 | 238671 | 2020-06-14 | Knox | Nebraska | 31107 | 11 | 0 |
241781 | 241781 | 2020-06-15 | Knox | Nebraska | 31107 | 12 | 0 |
244892 | 244892 | 2020-06-16 | Knox | Nebraska | 31107 | 12 | 0 |
248005 | 248005 | 2020-06-17 | Knox | Nebraska | 31107 | 12 | 0 |
251120 | 251120 | 2020-06-18 | Knox | Nebraska | 31107 | 15 | 0 |
254235 | 254235 | 2020-06-19 | Knox | Nebraska | 31107 | 15 | 0 |
257358 | 257358 | 2020-06-20 | Knox | Nebraska | 31107 | 15 | 0 |
260484 | 260484 | 2020-06-21 | Knox | Nebraska | 31107 | 15 | 0 |
263613 | 263613 | 2020-06-22 | Knox | Nebraska | 31107 | 15 | 0 |
266740 | 266740 | 2020-06-23 | Knox | Nebraska | 31107 | 16 | 0 |
269874 | 269874 | 2020-06-24 | Knox | Nebraska | 31107 | 16 | 0 |
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);