ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Sarpy" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3508 | 3508 | 2020-03-17 | Sarpy | Nebraska | 31153 | 1 | 0 |
4101 | 4101 | 2020-03-18 | Sarpy | Nebraska | 31153 | 1 | 0 |
4825 | 4825 | 2020-03-19 | Sarpy | Nebraska | 31153 | 2 | 0 |
5666 | 5666 | 2020-03-20 | Sarpy | Nebraska | 31153 | 3 | 0 |
6658 | 6658 | 2020-03-21 | Sarpy | Nebraska | 31153 | 3 | 0 |
7748 | 7748 | 2020-03-22 | Sarpy | Nebraska | 31153 | 3 | 0 |
8942 | 8942 | 2020-03-23 | Sarpy | Nebraska | 31153 | 6 | 0 |
10245 | 10245 | 2020-03-24 | Sarpy | Nebraska | 31153 | 6 | 0 |
11676 | 11676 | 2020-03-25 | Sarpy | Nebraska | 31153 | 6 | 0 |
13279 | 13279 | 2020-03-26 | Sarpy | Nebraska | 31153 | 7 | 0 |
15011 | 15011 | 2020-03-27 | Sarpy | Nebraska | 31153 | 11 | 0 |
16839 | 16839 | 2020-03-28 | Sarpy | Nebraska | 31153 | 11 | 0 |
18762 | 18762 | 2020-03-29 | Sarpy | Nebraska | 31153 | 11 | 0 |
20798 | 20798 | 2020-03-30 | Sarpy | Nebraska | 31153 | 13 | 0 |
22922 | 22922 | 2020-03-31 | Sarpy | Nebraska | 31153 | 16 | 0 |
25112 | 25112 | 2020-04-01 | Sarpy | Nebraska | 31153 | 17 | 0 |
27372 | 27372 | 2020-04-02 | Sarpy | Nebraska | 31153 | 23 | 0 |
29696 | 29696 | 2020-04-03 | Sarpy | Nebraska | 31153 | 26 | 0 |
32079 | 32079 | 2020-04-04 | Sarpy | Nebraska | 31153 | 28 | 0 |
34509 | 34509 | 2020-04-05 | Sarpy | Nebraska | 31153 | 28 | 0 |
36978 | 36978 | 2020-04-06 | Sarpy | Nebraska | 31153 | 33 | 0 |
39494 | 39494 | 2020-04-07 | Sarpy | Nebraska | 31153 | 36 | 0 |
42050 | 42050 | 2020-04-08 | Sarpy | Nebraska | 31153 | 37 | 0 |
44632 | 44632 | 2020-04-09 | Sarpy | Nebraska | 31153 | 38 | 0 |
47244 | 47244 | 2020-04-10 | Sarpy | Nebraska | 31153 | 39 | 0 |
49895 | 49895 | 2020-04-11 | Sarpy | Nebraska | 31153 | 41 | 0 |
52569 | 52569 | 2020-04-12 | Sarpy | Nebraska | 31153 | 41 | 0 |
55250 | 55250 | 2020-04-13 | Sarpy | Nebraska | 31153 | 45 | 0 |
57950 | 57950 | 2020-04-14 | Sarpy | Nebraska | 31153 | 46 | 0 |
60665 | 60665 | 2020-04-15 | Sarpy | Nebraska | 31153 | 46 | 0 |
63390 | 63390 | 2020-04-16 | Sarpy | Nebraska | 31153 | 47 | 0 |
66132 | 66132 | 2020-04-17 | Sarpy | Nebraska | 31153 | 48 | 0 |
68887 | 68887 | 2020-04-18 | Sarpy | Nebraska | 31153 | 52 | 0 |
71654 | 71654 | 2020-04-19 | Sarpy | Nebraska | 31153 | 53 | 0 |
74428 | 74428 | 2020-04-20 | Sarpy | Nebraska | 31153 | 55 | 0 |
77208 | 77208 | 2020-04-21 | Sarpy | Nebraska | 31153 | 55 | 0 |
79997 | 79997 | 2020-04-22 | Sarpy | Nebraska | 31153 | 57 | 0 |
82794 | 82794 | 2020-04-23 | Sarpy | Nebraska | 31153 | 64 | 0 |
85599 | 85599 | 2020-04-24 | Sarpy | Nebraska | 31153 | 73 | 0 |
88409 | 88409 | 2020-04-25 | Sarpy | Nebraska | 31153 | 77 | 0 |
91225 | 91225 | 2020-04-26 | Sarpy | Nebraska | 31153 | 87 | 0 |
94047 | 94047 | 2020-04-27 | Sarpy | Nebraska | 31153 | 95 | 0 |
96883 | 96883 | 2020-04-28 | Sarpy | Nebraska | 31153 | 97 | 0 |
99730 | 99730 | 2020-04-29 | Sarpy | Nebraska | 31153 | 113 | 0 |
102583 | 102583 | 2020-04-30 | Sarpy | Nebraska | 31153 | 123 | 1 |
105444 | 105444 | 2020-05-01 | Sarpy | Nebraska | 31153 | 133 | 1 |
108311 | 108311 | 2020-05-02 | Sarpy | Nebraska | 31153 | 137 | 1 |
111184 | 111184 | 2020-05-03 | Sarpy | Nebraska | 31153 | 142 | 1 |
114064 | 114064 | 2020-05-04 | Sarpy | Nebraska | 31153 | 158 | 1 |
116946 | 116946 | 2020-05-05 | Sarpy | Nebraska | 31153 | 168 | 1 |
119906 | 119906 | 2020-05-06 | Sarpy | Nebraska | 31153 | 180 | 1 |
122880 | 122880 | 2020-05-07 | Sarpy | Nebraska | 31153 | 198 | 1 |
125862 | 125862 | 2020-05-08 | Sarpy | Nebraska | 31153 | 218 | 1 |
128851 | 128851 | 2020-05-09 | Sarpy | Nebraska | 31153 | 234 | 1 |
131841 | 131841 | 2020-05-10 | Sarpy | Nebraska | 31153 | 236 | 1 |
134832 | 134832 | 2020-05-11 | Sarpy | Nebraska | 31153 | 248 | 1 |
137822 | 137822 | 2020-05-12 | Sarpy | Nebraska | 31153 | 257 | 1 |
140817 | 140817 | 2020-05-13 | Sarpy | Nebraska | 31153 | 272 | 1 |
143812 | 143812 | 2020-05-14 | Sarpy | Nebraska | 31153 | 291 | 1 |
146813 | 146813 | 2020-05-15 | Sarpy | Nebraska | 31153 | 309 | 1 |
149820 | 149820 | 2020-05-16 | Sarpy | Nebraska | 31153 | 331 | 2 |
152831 | 152831 | 2020-05-17 | Sarpy | Nebraska | 31153 | 342 | 2 |
155845 | 155845 | 2020-05-18 | Sarpy | Nebraska | 31153 | 349 | 2 |
158863 | 158863 | 2020-05-19 | Sarpy | Nebraska | 31153 | 366 | 2 |
161889 | 161889 | 2020-05-20 | Sarpy | Nebraska | 31153 | 382 | 2 |
164918 | 164918 | 2020-05-21 | Sarpy | Nebraska | 31153 | 404 | 2 |
167954 | 167954 | 2020-05-22 | Sarpy | Nebraska | 31153 | 419 | 2 |
170993 | 170993 | 2020-05-23 | Sarpy | Nebraska | 31153 | 434 | 2 |
174036 | 174036 | 2020-05-24 | Sarpy | Nebraska | 31153 | 448 | 3 |
177079 | 177079 | 2020-05-25 | Sarpy | Nebraska | 31153 | 463 | 3 |
180123 | 180123 | 2020-05-26 | Sarpy | Nebraska | 31153 | 476 | 3 |
183171 | 183171 | 2020-05-27 | Sarpy | Nebraska | 31153 | 503 | 3 |
186227 | 186227 | 2020-05-28 | Sarpy | Nebraska | 31153 | 531 | 3 |
189286 | 189286 | 2020-05-29 | Sarpy | Nebraska | 31153 | 578 | 3 |
192350 | 192350 | 2020-05-30 | Sarpy | Nebraska | 31153 | 596 | 3 |
195420 | 195420 | 2020-05-31 | Sarpy | Nebraska | 31153 | 620 | 4 |
198493 | 198493 | 2020-06-01 | Sarpy | Nebraska | 31153 | 650 | 4 |
201567 | 201567 | 2020-06-02 | Sarpy | Nebraska | 31153 | 680 | 4 |
204644 | 204644 | 2020-06-03 | Sarpy | Nebraska | 31153 | 703 | 4 |
207725 | 207725 | 2020-06-04 | Sarpy | Nebraska | 31153 | 736 | 4 |
210807 | 210807 | 2020-06-05 | Sarpy | Nebraska | 31153 | 753 | 4 |
213891 | 213891 | 2020-06-06 | Sarpy | Nebraska | 31153 | 765 | 4 |
216980 | 216980 | 2020-06-07 | Sarpy | Nebraska | 31153 | 773 | 4 |
220072 | 220072 | 2020-06-08 | Sarpy | Nebraska | 31153 | 787 | 4 |
223168 | 223168 | 2020-06-09 | Sarpy | Nebraska | 31153 | 796 | 4 |
226267 | 226267 | 2020-06-10 | Sarpy | Nebraska | 31153 | 809 | 5 |
229370 | 229370 | 2020-06-11 | Sarpy | Nebraska | 31153 | 842 | 5 |
232475 | 232475 | 2020-06-12 | Sarpy | Nebraska | 31153 | 868 | 5 |
235581 | 235581 | 2020-06-13 | Sarpy | Nebraska | 31153 | 882 | 5 |
238688 | 238688 | 2020-06-14 | Sarpy | Nebraska | 31153 | 898 | 5 |
241798 | 241798 | 2020-06-15 | Sarpy | Nebraska | 31153 | 907 | 7 |
244909 | 244909 | 2020-06-16 | Sarpy | Nebraska | 31153 | 920 | 7 |
248022 | 248022 | 2020-06-17 | Sarpy | Nebraska | 31153 | 948 | 8 |
251137 | 251137 | 2020-06-18 | Sarpy | Nebraska | 31153 | 967 | 8 |
254252 | 254252 | 2020-06-19 | Sarpy | Nebraska | 31153 | 982 | 8 |
257375 | 257375 | 2020-06-20 | Sarpy | Nebraska | 31153 | 998 | 8 |
260501 | 260501 | 2020-06-21 | Sarpy | Nebraska | 31153 | 1018 | 8 |
263630 | 263630 | 2020-06-22 | Sarpy | Nebraska | 31153 | 1038 | 8 |
266757 | 266757 | 2020-06-23 | Sarpy | Nebraska | 31153 | 1049 | 8 |
269892 | 269892 | 2020-06-24 | Sarpy | Nebraska | 31153 | 1060 | 8 |
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);