ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40083 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333594 | 333594 | 2020-07-14 | Logan | Oklahoma | 40083 | 101 | 1 |
330402 | 330402 | 2020-07-13 | Logan | Oklahoma | 40083 | 98 | 1 |
327215 | 327215 | 2020-07-12 | Logan | Oklahoma | 40083 | 98 | 1 |
324030 | 324030 | 2020-07-11 | Logan | Oklahoma | 40083 | 90 | 1 |
320850 | 320850 | 2020-07-10 | Logan | Oklahoma | 40083 | 85 | 1 |
317673 | 317673 | 2020-07-09 | Logan | Oklahoma | 40083 | 75 | 1 |
314500 | 314500 | 2020-07-08 | Logan | Oklahoma | 40083 | 70 | 1 |
311328 | 311328 | 2020-07-07 | Logan | Oklahoma | 40083 | 67 | 1 |
308159 | 308159 | 2020-07-06 | Logan | Oklahoma | 40083 | 62 | 1 |
304992 | 304992 | 2020-07-05 | Logan | Oklahoma | 40083 | 60 | 1 |
301829 | 301829 | 2020-07-04 | Logan | Oklahoma | 40083 | 55 | 1 |
298666 | 298666 | 2020-07-03 | Logan | Oklahoma | 40083 | 54 | 1 |
295507 | 295507 | 2020-07-02 | Logan | Oklahoma | 40083 | 52 | 1 |
292351 | 292351 | 2020-07-01 | Logan | Oklahoma | 40083 | 49 | 1 |
289198 | 289198 | 2020-06-30 | Logan | Oklahoma | 40083 | 49 | 1 |
286048 | 286048 | 2020-06-29 | Logan | Oklahoma | 40083 | 44 | 1 |
282903 | 282903 | 2020-06-28 | Logan | Oklahoma | 40083 | 43 | 1 |
279757 | 279757 | 2020-06-27 | Logan | Oklahoma | 40083 | 41 | 1 |
276609 | 276609 | 2020-06-26 | Logan | Oklahoma | 40083 | 39 | 1 |
273462 | 273462 | 2020-06-25 | Logan | Oklahoma | 40083 | 37 | 1 |
270323 | 270323 | 2020-06-24 | Logan | Oklahoma | 40083 | 35 | 1 |
267189 | 267189 | 2020-06-23 | Logan | Oklahoma | 40083 | 33 | 1 |
264061 | 264061 | 2020-06-22 | Logan | Oklahoma | 40083 | 30 | 1 |
260933 | 260933 | 2020-06-21 | Logan | Oklahoma | 40083 | 28 | 1 |
257806 | 257806 | 2020-06-20 | Logan | Oklahoma | 40083 | 26 | 1 |
254680 | 254680 | 2020-06-19 | Logan | Oklahoma | 40083 | 26 | 1 |
251565 | 251565 | 2020-06-18 | Logan | Oklahoma | 40083 | 25 | 1 |
248450 | 248450 | 2020-06-17 | Logan | Oklahoma | 40083 | 24 | 1 |
245337 | 245337 | 2020-06-16 | Logan | Oklahoma | 40083 | 24 | 1 |
242225 | 242225 | 2020-06-15 | Logan | Oklahoma | 40083 | 25 | 1 |
239116 | 239116 | 2020-06-14 | Logan | Oklahoma | 40083 | 23 | 1 |
236008 | 236008 | 2020-06-13 | Logan | Oklahoma | 40083 | 23 | 1 |
232903 | 232903 | 2020-06-12 | Logan | Oklahoma | 40083 | 22 | 1 |
229798 | 229798 | 2020-06-11 | Logan | Oklahoma | 40083 | 22 | 1 |
226694 | 226694 | 2020-06-10 | Logan | Oklahoma | 40083 | 21 | 1 |
223594 | 223594 | 2020-06-09 | Logan | Oklahoma | 40083 | 21 | 1 |
220499 | 220499 | 2020-06-08 | Logan | Oklahoma | 40083 | 21 | 1 |
217407 | 217407 | 2020-06-07 | Logan | Oklahoma | 40083 | 21 | 1 |
214317 | 214317 | 2020-06-06 | Logan | Oklahoma | 40083 | 19 | 1 |
211231 | 211231 | 2020-06-05 | Logan | Oklahoma | 40083 | 19 | 1 |
208149 | 208149 | 2020-06-04 | Logan | Oklahoma | 40083 | 19 | 1 |
205068 | 205068 | 2020-06-03 | Logan | Oklahoma | 40083 | 19 | 1 |
201991 | 201991 | 2020-06-02 | Logan | Oklahoma | 40083 | 19 | 1 |
198916 | 198916 | 2020-06-01 | Logan | Oklahoma | 40083 | 19 | 1 |
195843 | 195843 | 2020-05-31 | Logan | Oklahoma | 40083 | 19 | 1 |
192774 | 192774 | 2020-05-30 | Logan | Oklahoma | 40083 | 19 | 1 |
189709 | 189709 | 2020-05-29 | Logan | Oklahoma | 40083 | 19 | 1 |
186648 | 186648 | 2020-05-28 | Logan | Oklahoma | 40083 | 19 | 1 |
183591 | 183591 | 2020-05-27 | Logan | Oklahoma | 40083 | 19 | 1 |
180542 | 180542 | 2020-05-26 | Logan | Oklahoma | 40083 | 19 | 1 |
177499 | 177499 | 2020-05-25 | Logan | Oklahoma | 40083 | 19 | 1 |
174455 | 174455 | 2020-05-24 | Logan | Oklahoma | 40083 | 19 | 1 |
171413 | 171413 | 2020-05-23 | Logan | Oklahoma | 40083 | 18 | 1 |
168374 | 168374 | 2020-05-22 | Logan | Oklahoma | 40083 | 18 | 1 |
165338 | 165338 | 2020-05-21 | Logan | Oklahoma | 40083 | 18 | 1 |
162309 | 162309 | 2020-05-20 | Logan | Oklahoma | 40083 | 18 | 1 |
159282 | 159282 | 2020-05-19 | Logan | Oklahoma | 40083 | 18 | 1 |
156261 | 156261 | 2020-05-18 | Logan | Oklahoma | 40083 | 18 | 1 |
153244 | 153244 | 2020-05-17 | Logan | Oklahoma | 40083 | 18 | 1 |
150233 | 150233 | 2020-05-16 | Logan | Oklahoma | 40083 | 18 | 1 |
147226 | 147226 | 2020-05-15 | Logan | Oklahoma | 40083 | 18 | 1 |
144225 | 144225 | 2020-05-14 | Logan | Oklahoma | 40083 | 18 | 1 |
141230 | 141230 | 2020-05-13 | Logan | Oklahoma | 40083 | 18 | 1 |
138234 | 138234 | 2020-05-12 | Logan | Oklahoma | 40083 | 18 | 1 |
135244 | 135244 | 2020-05-11 | Logan | Oklahoma | 40083 | 18 | 1 |
132253 | 132253 | 2020-05-10 | Logan | Oklahoma | 40083 | 18 | 1 |
129264 | 129264 | 2020-05-09 | Logan | Oklahoma | 40083 | 18 | 1 |
126275 | 126275 | 2020-05-08 | Logan | Oklahoma | 40083 | 18 | 1 |
123292 | 123292 | 2020-05-07 | Logan | Oklahoma | 40083 | 18 | 1 |
120315 | 120315 | 2020-05-06 | Logan | Oklahoma | 40083 | 17 | 1 |
117354 | 117354 | 2020-05-05 | Logan | Oklahoma | 40083 | 17 | 1 |
114473 | 114473 | 2020-05-04 | Logan | Oklahoma | 40083 | 16 | 1 |
111591 | 111591 | 2020-05-03 | Logan | Oklahoma | 40083 | 16 | 1 |
108717 | 108717 | 2020-05-02 | Logan | Oklahoma | 40083 | 16 | 1 |
105850 | 105850 | 2020-05-01 | Logan | Oklahoma | 40083 | 16 | 1 |
102987 | 102987 | 2020-04-30 | Logan | Oklahoma | 40083 | 15 | 1 |
100134 | 100134 | 2020-04-29 | Logan | Oklahoma | 40083 | 14 | 1 |
97285 | 97285 | 2020-04-28 | Logan | Oklahoma | 40083 | 13 | 0 |
94447 | 94447 | 2020-04-27 | Logan | Oklahoma | 40083 | 13 | 0 |
91621 | 91621 | 2020-04-26 | Logan | Oklahoma | 40083 | 13 | 0 |
88805 | 88805 | 2020-04-25 | Logan | Oklahoma | 40083 | 12 | 0 |
85991 | 85991 | 2020-04-24 | Logan | Oklahoma | 40083 | 12 | 0 |
83187 | 83187 | 2020-04-23 | Logan | Oklahoma | 40083 | 11 | 0 |
80388 | 80388 | 2020-04-22 | Logan | Oklahoma | 40083 | 10 | 0 |
77598 | 77598 | 2020-04-21 | Logan | Oklahoma | 40083 | 10 | 0 |
74816 | 74816 | 2020-04-20 | Logan | Oklahoma | 40083 | 9 | 0 |
72041 | 72041 | 2020-04-19 | Logan | Oklahoma | 40083 | 9 | 0 |
69274 | 69274 | 2020-04-18 | Logan | Oklahoma | 40083 | 9 | 0 |
66516 | 66516 | 2020-04-17 | Logan | Oklahoma | 40083 | 9 | 0 |
63772 | 63772 | 2020-04-16 | Logan | Oklahoma | 40083 | 8 | 0 |
61046 | 61046 | 2020-04-15 | Logan | Oklahoma | 40083 | 7 | 0 |
58331 | 58331 | 2020-04-14 | Logan | Oklahoma | 40083 | 7 | 0 |
55629 | 55629 | 2020-04-13 | Logan | Oklahoma | 40083 | 7 | 0 |
52944 | 52944 | 2020-04-12 | Logan | Oklahoma | 40083 | 7 | 0 |
50271 | 50271 | 2020-04-11 | Logan | Oklahoma | 40083 | 7 | 0 |
47615 | 47615 | 2020-04-10 | Logan | Oklahoma | 40083 | 7 | 0 |
45000 | 45000 | 2020-04-09 | Logan | Oklahoma | 40083 | 7 | 0 |
42414 | 42414 | 2020-04-08 | Logan | Oklahoma | 40083 | 6 | 0 |
39854 | 39854 | 2020-04-07 | Logan | Oklahoma | 40083 | 6 | 0 |
37334 | 37334 | 2020-04-06 | Logan | Oklahoma | 40083 | 6 | 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);