ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 40009 and state = "Oklahoma" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
21083 | 21083 | 2020-03-30 | Beckham | Oklahoma | 40009 | 1 | 0 |
23216 | 23216 | 2020-03-31 | Beckham | Oklahoma | 40009 | 1 | 0 |
25412 | 25412 | 2020-04-01 | Beckham | Oklahoma | 40009 | 1 | 0 |
27682 | 27682 | 2020-04-02 | Beckham | Oklahoma | 40009 | 1 | 0 |
30011 | 30011 | 2020-04-03 | Beckham | Oklahoma | 40009 | 1 | 0 |
32400 | 32400 | 2020-04-04 | Beckham | Oklahoma | 40009 | 1 | 0 |
34834 | 34834 | 2020-04-05 | Beckham | Oklahoma | 40009 | 1 | 0 |
37307 | 37307 | 2020-04-06 | Beckham | Oklahoma | 40009 | 1 | 0 |
39826 | 39826 | 2020-04-07 | Beckham | Oklahoma | 40009 | 1 | 0 |
42386 | 42386 | 2020-04-08 | Beckham | Oklahoma | 40009 | 1 | 0 |
44972 | 44972 | 2020-04-09 | Beckham | Oklahoma | 40009 | 1 | 0 |
47587 | 47587 | 2020-04-10 | Beckham | Oklahoma | 40009 | 1 | 0 |
50243 | 50243 | 2020-04-11 | Beckham | Oklahoma | 40009 | 1 | 0 |
52916 | 52916 | 2020-04-12 | Beckham | Oklahoma | 40009 | 1 | 0 |
55601 | 55601 | 2020-04-13 | Beckham | Oklahoma | 40009 | 1 | 0 |
58302 | 58302 | 2020-04-14 | Beckham | Oklahoma | 40009 | 1 | 0 |
61017 | 61017 | 2020-04-15 | Beckham | Oklahoma | 40009 | 2 | 0 |
63743 | 63743 | 2020-04-16 | Beckham | Oklahoma | 40009 | 2 | 0 |
66486 | 66486 | 2020-04-17 | Beckham | Oklahoma | 40009 | 2 | 0 |
69243 | 69243 | 2020-04-18 | Beckham | Oklahoma | 40009 | 2 | 0 |
72010 | 72010 | 2020-04-19 | Beckham | Oklahoma | 40009 | 2 | 0 |
74785 | 74785 | 2020-04-20 | Beckham | Oklahoma | 40009 | 2 | 0 |
77566 | 77566 | 2020-04-21 | Beckham | Oklahoma | 40009 | 2 | 0 |
80356 | 80356 | 2020-04-22 | Beckham | Oklahoma | 40009 | 2 | 0 |
83155 | 83155 | 2020-04-23 | Beckham | Oklahoma | 40009 | 2 | 0 |
85959 | 85959 | 2020-04-24 | Beckham | Oklahoma | 40009 | 2 | 0 |
88773 | 88773 | 2020-04-25 | Beckham | Oklahoma | 40009 | 3 | 0 |
91589 | 91589 | 2020-04-26 | Beckham | Oklahoma | 40009 | 5 | 0 |
94415 | 94415 | 2020-04-27 | Beckham | Oklahoma | 40009 | 5 | 0 |
97253 | 97253 | 2020-04-28 | Beckham | Oklahoma | 40009 | 5 | 0 |
100102 | 100102 | 2020-04-29 | Beckham | Oklahoma | 40009 | 5 | 0 |
102955 | 102955 | 2020-04-30 | Beckham | Oklahoma | 40009 | 5 | 0 |
105818 | 105818 | 2020-05-01 | Beckham | Oklahoma | 40009 | 5 | 0 |
108685 | 108685 | 2020-05-02 | Beckham | Oklahoma | 40009 | 5 | 0 |
111559 | 111559 | 2020-05-03 | Beckham | Oklahoma | 40009 | 5 | 0 |
114440 | 114440 | 2020-05-04 | Beckham | Oklahoma | 40009 | 6 | 0 |
117321 | 117321 | 2020-05-05 | Beckham | Oklahoma | 40009 | 6 | 0 |
120282 | 120282 | 2020-05-06 | Beckham | Oklahoma | 40009 | 6 | 0 |
123259 | 123259 | 2020-05-07 | Beckham | Oklahoma | 40009 | 6 | 0 |
126242 | 126242 | 2020-05-08 | Beckham | Oklahoma | 40009 | 6 | 0 |
129231 | 129231 | 2020-05-09 | Beckham | Oklahoma | 40009 | 6 | 0 |
132220 | 132220 | 2020-05-10 | Beckham | Oklahoma | 40009 | 6 | 0 |
135211 | 135211 | 2020-05-11 | Beckham | Oklahoma | 40009 | 6 | 0 |
138201 | 138201 | 2020-05-12 | Beckham | Oklahoma | 40009 | 6 | 0 |
141197 | 141197 | 2020-05-13 | Beckham | Oklahoma | 40009 | 6 | 0 |
144192 | 144192 | 2020-05-14 | Beckham | Oklahoma | 40009 | 6 | 0 |
147193 | 147193 | 2020-05-15 | Beckham | Oklahoma | 40009 | 6 | 0 |
150200 | 150200 | 2020-05-16 | Beckham | Oklahoma | 40009 | 6 | 0 |
153211 | 153211 | 2020-05-17 | Beckham | Oklahoma | 40009 | 6 | 0 |
156228 | 156228 | 2020-05-18 | Beckham | Oklahoma | 40009 | 6 | 0 |
159248 | 159248 | 2020-05-19 | Beckham | Oklahoma | 40009 | 6 | 0 |
162275 | 162275 | 2020-05-20 | Beckham | Oklahoma | 40009 | 6 | 0 |
165304 | 165304 | 2020-05-21 | Beckham | Oklahoma | 40009 | 6 | 0 |
168340 | 168340 | 2020-05-22 | Beckham | Oklahoma | 40009 | 6 | 0 |
171379 | 171379 | 2020-05-23 | Beckham | Oklahoma | 40009 | 6 | 0 |
174421 | 174421 | 2020-05-24 | Beckham | Oklahoma | 40009 | 6 | 0 |
177465 | 177465 | 2020-05-25 | Beckham | Oklahoma | 40009 | 6 | 0 |
180508 | 180508 | 2020-05-26 | Beckham | Oklahoma | 40009 | 6 | 0 |
183557 | 183557 | 2020-05-27 | Beckham | Oklahoma | 40009 | 6 | 0 |
186614 | 186614 | 2020-05-28 | Beckham | Oklahoma | 40009 | 6 | 0 |
189674 | 189674 | 2020-05-29 | Beckham | Oklahoma | 40009 | 6 | 0 |
192739 | 192739 | 2020-05-30 | Beckham | Oklahoma | 40009 | 6 | 0 |
195808 | 195808 | 2020-05-31 | Beckham | Oklahoma | 40009 | 9 | 0 |
198881 | 198881 | 2020-06-01 | Beckham | Oklahoma | 40009 | 10 | 0 |
201956 | 201956 | 2020-06-02 | Beckham | Oklahoma | 40009 | 10 | 0 |
205033 | 205033 | 2020-06-03 | Beckham | Oklahoma | 40009 | 7 | 0 |
208114 | 208114 | 2020-06-04 | Beckham | Oklahoma | 40009 | 7 | 0 |
211196 | 211196 | 2020-06-05 | Beckham | Oklahoma | 40009 | 7 | 0 |
214282 | 214282 | 2020-06-06 | Beckham | Oklahoma | 40009 | 7 | 0 |
217372 | 217372 | 2020-06-07 | Beckham | Oklahoma | 40009 | 7 | 0 |
220464 | 220464 | 2020-06-08 | Beckham | Oklahoma | 40009 | 7 | 0 |
223559 | 223559 | 2020-06-09 | Beckham | Oklahoma | 40009 | 7 | 0 |
226659 | 226659 | 2020-06-10 | Beckham | Oklahoma | 40009 | 7 | 0 |
229763 | 229763 | 2020-06-11 | Beckham | Oklahoma | 40009 | 7 | 0 |
232868 | 232868 | 2020-06-12 | Beckham | Oklahoma | 40009 | 7 | 0 |
235973 | 235973 | 2020-06-13 | Beckham | Oklahoma | 40009 | 7 | 0 |
239081 | 239081 | 2020-06-14 | Beckham | Oklahoma | 40009 | 8 | 0 |
242190 | 242190 | 2020-06-15 | Beckham | Oklahoma | 40009 | 8 | 0 |
245302 | 245302 | 2020-06-16 | Beckham | Oklahoma | 40009 | 8 | 0 |
248415 | 248415 | 2020-06-17 | Beckham | Oklahoma | 40009 | 8 | 0 |
251530 | 251530 | 2020-06-18 | Beckham | Oklahoma | 40009 | 8 | 0 |
254645 | 254645 | 2020-06-19 | Beckham | Oklahoma | 40009 | 8 | 0 |
257771 | 257771 | 2020-06-20 | Beckham | Oklahoma | 40009 | 8 | 0 |
260897 | 260897 | 2020-06-21 | Beckham | Oklahoma | 40009 | 8 | 0 |
264025 | 264025 | 2020-06-22 | Beckham | Oklahoma | 40009 | 9 | 0 |
267153 | 267153 | 2020-06-23 | Beckham | Oklahoma | 40009 | 9 | 0 |
270287 | 270287 | 2020-06-24 | Beckham | Oklahoma | 40009 | 11 | 0 |
273426 | 273426 | 2020-06-25 | Beckham | Oklahoma | 40009 | 12 | 0 |
276573 | 276573 | 2020-06-26 | Beckham | Oklahoma | 40009 | 11 | 0 |
279721 | 279721 | 2020-06-27 | Beckham | Oklahoma | 40009 | 11 | 0 |
282867 | 282867 | 2020-06-28 | Beckham | Oklahoma | 40009 | 11 | 0 |
286012 | 286012 | 2020-06-29 | Beckham | Oklahoma | 40009 | 11 | 0 |
289162 | 289162 | 2020-06-30 | Beckham | Oklahoma | 40009 | 11 | 0 |
292314 | 292314 | 2020-07-01 | Beckham | Oklahoma | 40009 | 11 | 0 |
295470 | 295470 | 2020-07-02 | Beckham | Oklahoma | 40009 | 11 | 0 |
298629 | 298629 | 2020-07-03 | Beckham | Oklahoma | 40009 | 11 | 0 |
301792 | 301792 | 2020-07-04 | Beckham | Oklahoma | 40009 | 11 | 0 |
304955 | 304955 | 2020-07-05 | Beckham | Oklahoma | 40009 | 11 | 0 |
308122 | 308122 | 2020-07-06 | Beckham | Oklahoma | 40009 | 11 | 0 |
311291 | 311291 | 2020-07-07 | Beckham | Oklahoma | 40009 | 13 | 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);