ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lancaster", fips = 31109 and state = "Nebraska" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5663 | 5663 | 2020-03-20 | Lancaster | Nebraska | 31109 | 1 | 0 |
6655 | 6655 | 2020-03-21 | Lancaster | Nebraska | 31109 | 2 | 0 |
7745 | 7745 | 2020-03-22 | Lancaster | Nebraska | 31109 | 2 | 0 |
8938 | 8938 | 2020-03-23 | Lancaster | Nebraska | 31109 | 2 | 0 |
10241 | 10241 | 2020-03-24 | Lancaster | Nebraska | 31109 | 3 | 0 |
11672 | 11672 | 2020-03-25 | Lancaster | Nebraska | 31109 | 3 | 0 |
13275 | 13275 | 2020-03-26 | Lancaster | Nebraska | 31109 | 3 | 0 |
15007 | 15007 | 2020-03-27 | Lancaster | Nebraska | 31109 | 4 | 0 |
16834 | 16834 | 2020-03-28 | Lancaster | Nebraska | 31109 | 4 | 0 |
18757 | 18757 | 2020-03-29 | Lancaster | Nebraska | 31109 | 6 | 0 |
20793 | 20793 | 2020-03-30 | Lancaster | Nebraska | 31109 | 8 | 0 |
22917 | 22917 | 2020-03-31 | Lancaster | Nebraska | 31109 | 8 | 0 |
25107 | 25107 | 2020-04-01 | Lancaster | Nebraska | 31109 | 9 | 0 |
27366 | 27366 | 2020-04-02 | Lancaster | Nebraska | 31109 | 12 | 0 |
29689 | 29689 | 2020-04-03 | Lancaster | Nebraska | 31109 | 14 | 0 |
32072 | 32072 | 2020-04-04 | Lancaster | Nebraska | 31109 | 18 | 0 |
34501 | 34501 | 2020-04-05 | Lancaster | Nebraska | 31109 | 18 | 0 |
36970 | 36970 | 2020-04-06 | Lancaster | Nebraska | 31109 | 31 | 0 |
39486 | 39486 | 2020-04-07 | Lancaster | Nebraska | 31109 | 34 | 0 |
42042 | 42042 | 2020-04-08 | Lancaster | Nebraska | 31109 | 39 | 1 |
44623 | 44623 | 2020-04-09 | Lancaster | Nebraska | 31109 | 44 | 1 |
47235 | 47235 | 2020-04-10 | Lancaster | Nebraska | 31109 | 49 | 1 |
49885 | 49885 | 2020-04-11 | Lancaster | Nebraska | 31109 | 50 | 1 |
52559 | 52559 | 2020-04-12 | Lancaster | Nebraska | 31109 | 54 | 1 |
55240 | 55240 | 2020-04-13 | Lancaster | Nebraska | 31109 | 57 | 1 |
57939 | 57939 | 2020-04-14 | Lancaster | Nebraska | 31109 | 57 | 1 |
60653 | 60653 | 2020-04-15 | Lancaster | Nebraska | 31109 | 59 | 1 |
63377 | 63377 | 2020-04-16 | Lancaster | Nebraska | 31109 | 62 | 1 |
66118 | 66118 | 2020-04-17 | Lancaster | Nebraska | 31109 | 63 | 1 |
68873 | 68873 | 2020-04-18 | Lancaster | Nebraska | 31109 | 73 | 1 |
71640 | 71640 | 2020-04-19 | Lancaster | Nebraska | 31109 | 81 | 1 |
74414 | 74414 | 2020-04-20 | Lancaster | Nebraska | 31109 | 87 | 1 |
77194 | 77194 | 2020-04-21 | Lancaster | Nebraska | 31109 | 92 | 1 |
79983 | 79983 | 2020-04-22 | Lancaster | Nebraska | 31109 | 97 | 1 |
82780 | 82780 | 2020-04-23 | Lancaster | Nebraska | 31109 | 106 | 1 |
85585 | 85585 | 2020-04-24 | Lancaster | Nebraska | 31109 | 114 | 1 |
88395 | 88395 | 2020-04-25 | Lancaster | Nebraska | 31109 | 120 | 1 |
91211 | 91211 | 2020-04-26 | Lancaster | Nebraska | 31109 | 140 | 1 |
94033 | 94033 | 2020-04-27 | Lancaster | Nebraska | 31109 | 157 | 1 |
96869 | 96869 | 2020-04-28 | Lancaster | Nebraska | 31109 | 158 | 1 |
99716 | 99716 | 2020-04-29 | Lancaster | Nebraska | 31109 | 204 | 1 |
102569 | 102569 | 2020-04-30 | Lancaster | Nebraska | 31109 | 240 | 1 |
105430 | 105430 | 2020-05-01 | Lancaster | Nebraska | 31109 | 281 | 1 |
108297 | 108297 | 2020-05-02 | Lancaster | Nebraska | 31109 | 299 | 1 |
111170 | 111170 | 2020-05-03 | Lancaster | Nebraska | 31109 | 330 | 1 |
114050 | 114050 | 2020-05-04 | Lancaster | Nebraska | 31109 | 394 | 1 |
116932 | 116932 | 2020-05-05 | Lancaster | Nebraska | 31109 | 441 | 1 |
119892 | 119892 | 2020-05-06 | Lancaster | Nebraska | 31109 | 462 | 1 |
122866 | 122866 | 2020-05-07 | Lancaster | Nebraska | 31109 | 509 | 2 |
125848 | 125848 | 2020-05-08 | Lancaster | Nebraska | 31109 | 547 | 2 |
128837 | 128837 | 2020-05-09 | Lancaster | Nebraska | 31109 | 606 | 2 |
131827 | 131827 | 2020-05-10 | Lancaster | Nebraska | 31109 | 607 | 2 |
134818 | 134818 | 2020-05-11 | Lancaster | Nebraska | 31109 | 647 | 2 |
137808 | 137808 | 2020-05-12 | Lancaster | Nebraska | 31109 | 665 | 3 |
140802 | 140802 | 2020-05-13 | Lancaster | Nebraska | 31109 | 687 | 3 |
143797 | 143797 | 2020-05-14 | Lancaster | Nebraska | 31109 | 701 | 5 |
146798 | 146798 | 2020-05-15 | Lancaster | Nebraska | 31109 | 735 | 5 |
149804 | 149804 | 2020-05-16 | Lancaster | Nebraska | 31109 | 791 | 5 |
152815 | 152815 | 2020-05-17 | Lancaster | Nebraska | 31109 | 800 | 5 |
155829 | 155829 | 2020-05-18 | Lancaster | Nebraska | 31109 | 892 | 6 |
158847 | 158847 | 2020-05-19 | Lancaster | Nebraska | 31109 | 912 | 7 |
161873 | 161873 | 2020-05-20 | Lancaster | Nebraska | 31109 | 934 | 7 |
164902 | 164902 | 2020-05-21 | Lancaster | Nebraska | 31109 | 995 | 7 |
167938 | 167938 | 2020-05-22 | Lancaster | Nebraska | 31109 | 1005 | 8 |
170977 | 170977 | 2020-05-23 | Lancaster | Nebraska | 31109 | 1033 | 8 |
174020 | 174020 | 2020-05-24 | Lancaster | Nebraska | 31109 | 1056 | 8 |
177063 | 177063 | 2020-05-25 | Lancaster | Nebraska | 31109 | 1090 | 8 |
180107 | 180107 | 2020-05-26 | Lancaster | Nebraska | 31109 | 1098 | 9 |
183155 | 183155 | 2020-05-27 | Lancaster | Nebraska | 31109 | 1120 | 9 |
186211 | 186211 | 2020-05-28 | Lancaster | Nebraska | 31109 | 1140 | 9 |
189270 | 189270 | 2020-05-29 | Lancaster | Nebraska | 31109 | 1176 | 9 |
192334 | 192334 | 2020-05-30 | Lancaster | Nebraska | 31109 | 1195 | 9 |
195404 | 195404 | 2020-05-31 | Lancaster | Nebraska | 31109 | 1212 | 9 |
198477 | 198477 | 2020-06-01 | Lancaster | Nebraska | 31109 | 1228 | 9 |
201551 | 201551 | 2020-06-02 | Lancaster | Nebraska | 31109 | 1245 | 9 |
204628 | 204628 | 2020-06-03 | Lancaster | Nebraska | 31109 | 1263 | 9 |
207709 | 207709 | 2020-06-04 | Lancaster | Nebraska | 31109 | 1278 | 10 |
210791 | 210791 | 2020-06-05 | Lancaster | Nebraska | 31109 | 1310 | 10 |
213875 | 213875 | 2020-06-06 | Lancaster | Nebraska | 31109 | 1340 | 10 |
216964 | 216964 | 2020-06-07 | Lancaster | Nebraska | 31109 | 1356 | 10 |
220056 | 220056 | 2020-06-08 | Lancaster | Nebraska | 31109 | 1372 | 10 |
223152 | 223152 | 2020-06-09 | Lancaster | Nebraska | 31109 | 1376 | 10 |
226251 | 226251 | 2020-06-10 | Lancaster | Nebraska | 31109 | 1397 | 10 |
229354 | 229354 | 2020-06-11 | Lancaster | Nebraska | 31109 | 1429 | 10 |
232459 | 232459 | 2020-06-12 | Lancaster | Nebraska | 31109 | 1445 | 10 |
235565 | 235565 | 2020-06-13 | Lancaster | Nebraska | 31109 | 1464 | 10 |
238672 | 238672 | 2020-06-14 | Lancaster | Nebraska | 31109 | 1472 | 10 |
241782 | 241782 | 2020-06-15 | Lancaster | Nebraska | 31109 | 1487 | 10 |
244893 | 244893 | 2020-06-16 | Lancaster | Nebraska | 31109 | 1521 | 10 |
248006 | 248006 | 2020-06-17 | Lancaster | Nebraska | 31109 | 1545 | 10 |
251121 | 251121 | 2020-06-18 | Lancaster | Nebraska | 31109 | 1569 | 10 |
254236 | 254236 | 2020-06-19 | Lancaster | Nebraska | 31109 | 1588 | 10 |
257359 | 257359 | 2020-06-20 | Lancaster | Nebraska | 31109 | 1603 | 10 |
260485 | 260485 | 2020-06-21 | Lancaster | Nebraska | 31109 | 1611 | 10 |
263614 | 263614 | 2020-06-22 | Lancaster | Nebraska | 31109 | 1623 | 10 |
266741 | 266741 | 2020-06-23 | Lancaster | Nebraska | 31109 | 1634 | 11 |
269875 | 269875 | 2020-06-24 | Lancaster | Nebraska | 31109 | 1649 | 11 |
273014 | 273014 | 2020-06-25 | Lancaster | Nebraska | 31109 | 1660 | 12 |
276157 | 276157 | 2020-06-26 | Lancaster | Nebraska | 31109 | 1670 | 12 |
279305 | 279305 | 2020-06-27 | Lancaster | Nebraska | 31109 | 1688 | 12 |
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);