ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Lincoln" and state = "Oklahoma" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13531 | 13531 | 2020-03-26 | Lincoln | Oklahoma | 40081 | 1 | 0 |
15274 | 15274 | 2020-03-27 | Lincoln | Oklahoma | 40081 | 3 | 0 |
17120 | 17120 | 2020-03-28 | Lincoln | Oklahoma | 40081 | 3 | 0 |
19055 | 19055 | 2020-03-29 | Lincoln | Oklahoma | 40081 | 3 | 0 |
21104 | 21104 | 2020-03-30 | Lincoln | Oklahoma | 40081 | 4 | 0 |
23237 | 23237 | 2020-03-31 | Lincoln | Oklahoma | 40081 | 5 | 0 |
25434 | 25434 | 2020-04-01 | Lincoln | Oklahoma | 40081 | 5 | 0 |
27706 | 27706 | 2020-04-02 | Lincoln | Oklahoma | 40081 | 6 | 0 |
30036 | 30036 | 2020-04-03 | Lincoln | Oklahoma | 40081 | 7 | 0 |
32425 | 32425 | 2020-04-04 | Lincoln | Oklahoma | 40081 | 7 | 0 |
34859 | 34859 | 2020-04-05 | Lincoln | Oklahoma | 40081 | 7 | 0 |
37333 | 37333 | 2020-04-06 | Lincoln | Oklahoma | 40081 | 9 | 0 |
39853 | 39853 | 2020-04-07 | Lincoln | Oklahoma | 40081 | 10 | 0 |
42413 | 42413 | 2020-04-08 | Lincoln | Oklahoma | 40081 | 10 | 0 |
44999 | 44999 | 2020-04-09 | Lincoln | Oklahoma | 40081 | 10 | 0 |
47614 | 47614 | 2020-04-10 | Lincoln | Oklahoma | 40081 | 11 | 0 |
50270 | 50270 | 2020-04-11 | Lincoln | Oklahoma | 40081 | 11 | 0 |
52943 | 52943 | 2020-04-12 | Lincoln | Oklahoma | 40081 | 11 | 0 |
55628 | 55628 | 2020-04-13 | Lincoln | Oklahoma | 40081 | 10 | 0 |
58330 | 58330 | 2020-04-14 | Lincoln | Oklahoma | 40081 | 10 | 0 |
61045 | 61045 | 2020-04-15 | Lincoln | Oklahoma | 40081 | 10 | 0 |
63771 | 63771 | 2020-04-16 | Lincoln | Oklahoma | 40081 | 11 | 0 |
66515 | 66515 | 2020-04-17 | Lincoln | Oklahoma | 40081 | 11 | 0 |
69273 | 69273 | 2020-04-18 | Lincoln | Oklahoma | 40081 | 10 | 0 |
72040 | 72040 | 2020-04-19 | Lincoln | Oklahoma | 40081 | 10 | 0 |
74815 | 74815 | 2020-04-20 | Lincoln | Oklahoma | 40081 | 10 | 0 |
77597 | 77597 | 2020-04-21 | Lincoln | Oklahoma | 40081 | 10 | 0 |
80387 | 80387 | 2020-04-22 | Lincoln | Oklahoma | 40081 | 10 | 0 |
83186 | 83186 | 2020-04-23 | Lincoln | Oklahoma | 40081 | 10 | 0 |
85990 | 85990 | 2020-04-24 | Lincoln | Oklahoma | 40081 | 10 | 0 |
88804 | 88804 | 2020-04-25 | Lincoln | Oklahoma | 40081 | 10 | 0 |
91620 | 91620 | 2020-04-26 | Lincoln | Oklahoma | 40081 | 10 | 0 |
94446 | 94446 | 2020-04-27 | Lincoln | Oklahoma | 40081 | 11 | 0 |
97284 | 97284 | 2020-04-28 | Lincoln | Oklahoma | 40081 | 11 | 0 |
100133 | 100133 | 2020-04-29 | Lincoln | Oklahoma | 40081 | 12 | 0 |
102986 | 102986 | 2020-04-30 | Lincoln | Oklahoma | 40081 | 13 | 0 |
105849 | 105849 | 2020-05-01 | Lincoln | Oklahoma | 40081 | 12 | 0 |
108716 | 108716 | 2020-05-02 | Lincoln | Oklahoma | 40081 | 14 | 1 |
111590 | 111590 | 2020-05-03 | Lincoln | Oklahoma | 40081 | 14 | 1 |
114472 | 114472 | 2020-05-04 | Lincoln | Oklahoma | 40081 | 14 | 1 |
117353 | 117353 | 2020-05-05 | Lincoln | Oklahoma | 40081 | 16 | 2 |
120314 | 120314 | 2020-05-06 | Lincoln | Oklahoma | 40081 | 16 | 2 |
123291 | 123291 | 2020-05-07 | Lincoln | Oklahoma | 40081 | 16 | 2 |
126274 | 126274 | 2020-05-08 | Lincoln | Oklahoma | 40081 | 17 | 2 |
129263 | 129263 | 2020-05-09 | Lincoln | Oklahoma | 40081 | 17 | 2 |
132252 | 132252 | 2020-05-10 | Lincoln | Oklahoma | 40081 | 17 | 2 |
135243 | 135243 | 2020-05-11 | Lincoln | Oklahoma | 40081 | 17 | 2 |
138233 | 138233 | 2020-05-12 | Lincoln | Oklahoma | 40081 | 17 | 2 |
141229 | 141229 | 2020-05-13 | Lincoln | Oklahoma | 40081 | 17 | 2 |
144224 | 144224 | 2020-05-14 | Lincoln | Oklahoma | 40081 | 17 | 2 |
147225 | 147225 | 2020-05-15 | Lincoln | Oklahoma | 40081 | 17 | 2 |
150232 | 150232 | 2020-05-16 | Lincoln | Oklahoma | 40081 | 18 | 2 |
153243 | 153243 | 2020-05-17 | Lincoln | Oklahoma | 40081 | 18 | 2 |
156260 | 156260 | 2020-05-18 | Lincoln | Oklahoma | 40081 | 19 | 2 |
159281 | 159281 | 2020-05-19 | Lincoln | Oklahoma | 40081 | 19 | 2 |
162308 | 162308 | 2020-05-20 | Lincoln | Oklahoma | 40081 | 19 | 2 |
165337 | 165337 | 2020-05-21 | Lincoln | Oklahoma | 40081 | 21 | 2 |
168373 | 168373 | 2020-05-22 | Lincoln | Oklahoma | 40081 | 21 | 2 |
171412 | 171412 | 2020-05-23 | Lincoln | Oklahoma | 40081 | 21 | 2 |
174454 | 174454 | 2020-05-24 | Lincoln | Oklahoma | 40081 | 21 | 2 |
177498 | 177498 | 2020-05-25 | Lincoln | Oklahoma | 40081 | 21 | 2 |
180541 | 180541 | 2020-05-26 | Lincoln | Oklahoma | 40081 | 22 | 2 |
183590 | 183590 | 2020-05-27 | Lincoln | Oklahoma | 40081 | 22 | 2 |
186647 | 186647 | 2020-05-28 | Lincoln | Oklahoma | 40081 | 22 | 2 |
189708 | 189708 | 2020-05-29 | Lincoln | Oklahoma | 40081 | 22 | 2 |
192773 | 192773 | 2020-05-30 | Lincoln | Oklahoma | 40081 | 22 | 2 |
195842 | 195842 | 2020-05-31 | Lincoln | Oklahoma | 40081 | 22 | 2 |
198915 | 198915 | 2020-06-01 | Lincoln | Oklahoma | 40081 | 22 | 2 |
201990 | 201990 | 2020-06-02 | Lincoln | Oklahoma | 40081 | 22 | 2 |
205067 | 205067 | 2020-06-03 | Lincoln | Oklahoma | 40081 | 22 | 2 |
208148 | 208148 | 2020-06-04 | Lincoln | Oklahoma | 40081 | 22 | 2 |
211230 | 211230 | 2020-06-05 | Lincoln | Oklahoma | 40081 | 22 | 2 |
214316 | 214316 | 2020-06-06 | Lincoln | Oklahoma | 40081 | 22 | 2 |
217406 | 217406 | 2020-06-07 | Lincoln | Oklahoma | 40081 | 22 | 2 |
220498 | 220498 | 2020-06-08 | Lincoln | Oklahoma | 40081 | 23 | 2 |
223593 | 223593 | 2020-06-09 | Lincoln | Oklahoma | 40081 | 22 | 2 |
226693 | 226693 | 2020-06-10 | Lincoln | Oklahoma | 40081 | 22 | 2 |
229797 | 229797 | 2020-06-11 | Lincoln | Oklahoma | 40081 | 22 | 2 |
232902 | 232902 | 2020-06-12 | Lincoln | Oklahoma | 40081 | 22 | 2 |
236007 | 236007 | 2020-06-13 | Lincoln | Oklahoma | 40081 | 22 | 2 |
239115 | 239115 | 2020-06-14 | Lincoln | Oklahoma | 40081 | 24 | 2 |
242224 | 242224 | 2020-06-15 | Lincoln | Oklahoma | 40081 | 24 | 2 |
245336 | 245336 | 2020-06-16 | Lincoln | Oklahoma | 40081 | 27 | 2 |
248449 | 248449 | 2020-06-17 | Lincoln | Oklahoma | 40081 | 24 | 2 |
251564 | 251564 | 2020-06-18 | Lincoln | Oklahoma | 40081 | 26 | 2 |
254679 | 254679 | 2020-06-19 | Lincoln | Oklahoma | 40081 | 25 | 2 |
257805 | 257805 | 2020-06-20 | Lincoln | Oklahoma | 40081 | 25 | 2 |
260932 | 260932 | 2020-06-21 | Lincoln | Oklahoma | 40081 | 26 | 2 |
264060 | 264060 | 2020-06-22 | Lincoln | Oklahoma | 40081 | 27 | 2 |
267188 | 267188 | 2020-06-23 | Lincoln | Oklahoma | 40081 | 28 | 2 |
270322 | 270322 | 2020-06-24 | Lincoln | Oklahoma | 40081 | 28 | 2 |
273461 | 273461 | 2020-06-25 | Lincoln | Oklahoma | 40081 | 29 | 2 |
276608 | 276608 | 2020-06-26 | Lincoln | Oklahoma | 40081 | 28 | 2 |
279756 | 279756 | 2020-06-27 | Lincoln | Oklahoma | 40081 | 28 | 2 |
282902 | 282902 | 2020-06-28 | Lincoln | Oklahoma | 40081 | 29 | 2 |
286047 | 286047 | 2020-06-29 | Lincoln | Oklahoma | 40081 | 29 | 2 |
289197 | 289197 | 2020-06-30 | Lincoln | Oklahoma | 40081 | 29 | 2 |
292350 | 292350 | 2020-07-01 | Lincoln | Oklahoma | 40081 | 30 | 2 |
295506 | 295506 | 2020-07-02 | Lincoln | Oklahoma | 40081 | 30 | 2 |
298665 | 298665 | 2020-07-03 | Lincoln | Oklahoma | 40081 | 32 | 2 |
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);