ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 40047 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 ▼ |
---|---|---|---|---|---|---|---|
19048 | 19048 | 2020-03-29 | Garfield | Oklahoma | 40047 | 2 | 0 |
21097 | 21097 | 2020-03-30 | Garfield | Oklahoma | 40047 | 2 | 0 |
23230 | 23230 | 2020-03-31 | Garfield | Oklahoma | 40047 | 2 | 0 |
25426 | 25426 | 2020-04-01 | Garfield | Oklahoma | 40047 | 4 | 0 |
27696 | 27696 | 2020-04-02 | Garfield | Oklahoma | 40047 | 4 | 0 |
30025 | 30025 | 2020-04-03 | Garfield | Oklahoma | 40047 | 5 | 0 |
32414 | 32414 | 2020-04-04 | Garfield | Oklahoma | 40047 | 5 | 0 |
34848 | 34848 | 2020-04-05 | Garfield | Oklahoma | 40047 | 5 | 0 |
37321 | 37321 | 2020-04-06 | Garfield | Oklahoma | 40047 | 5 | 0 |
39841 | 39841 | 2020-04-07 | Garfield | Oklahoma | 40047 | 5 | 0 |
42401 | 42401 | 2020-04-08 | Garfield | Oklahoma | 40047 | 5 | 0 |
44987 | 44987 | 2020-04-09 | Garfield | Oklahoma | 40047 | 5 | 0 |
47602 | 47602 | 2020-04-10 | Garfield | Oklahoma | 40047 | 5 | 1 |
50258 | 50258 | 2020-04-11 | Garfield | Oklahoma | 40047 | 6 | 1 |
52931 | 52931 | 2020-04-12 | Garfield | Oklahoma | 40047 | 6 | 1 |
55616 | 55616 | 2020-04-13 | Garfield | Oklahoma | 40047 | 7 | 1 |
58317 | 58317 | 2020-04-14 | Garfield | Oklahoma | 40047 | 7 | 1 |
61032 | 61032 | 2020-04-15 | Garfield | Oklahoma | 40047 | 7 | 1 |
63758 | 63758 | 2020-04-16 | Garfield | Oklahoma | 40047 | 9 | 1 |
66501 | 66501 | 2020-04-17 | Garfield | Oklahoma | 40047 | 9 | 1 |
69258 | 69258 | 2020-04-18 | Garfield | Oklahoma | 40047 | 10 | 1 |
72025 | 72025 | 2020-04-19 | Garfield | Oklahoma | 40047 | 11 | 1 |
74800 | 74800 | 2020-04-20 | Garfield | Oklahoma | 40047 | 11 | 1 |
77582 | 77582 | 2020-04-21 | Garfield | Oklahoma | 40047 | 11 | 1 |
80372 | 80372 | 2020-04-22 | Garfield | Oklahoma | 40047 | 11 | 1 |
83171 | 83171 | 2020-04-23 | Garfield | Oklahoma | 40047 | 11 | 1 |
85975 | 85975 | 2020-04-24 | Garfield | Oklahoma | 40047 | 11 | 1 |
88789 | 88789 | 2020-04-25 | Garfield | Oklahoma | 40047 | 11 | 1 |
91605 | 91605 | 2020-04-26 | Garfield | Oklahoma | 40047 | 11 | 1 |
94431 | 94431 | 2020-04-27 | Garfield | Oklahoma | 40047 | 11 | 1 |
97269 | 97269 | 2020-04-28 | Garfield | Oklahoma | 40047 | 15 | 1 |
100118 | 100118 | 2020-04-29 | Garfield | Oklahoma | 40047 | 15 | 1 |
102971 | 102971 | 2020-04-30 | Garfield | Oklahoma | 40047 | 17 | 1 |
105834 | 105834 | 2020-05-01 | Garfield | Oklahoma | 40047 | 17 | 1 |
108701 | 108701 | 2020-05-02 | Garfield | Oklahoma | 40047 | 18 | 1 |
111575 | 111575 | 2020-05-03 | Garfield | Oklahoma | 40047 | 19 | 1 |
114457 | 114457 | 2020-05-04 | Garfield | Oklahoma | 40047 | 19 | 1 |
117338 | 117338 | 2020-05-05 | Garfield | Oklahoma | 40047 | 21 | 1 |
120299 | 120299 | 2020-05-06 | Garfield | Oklahoma | 40047 | 21 | 1 |
123276 | 123276 | 2020-05-07 | Garfield | Oklahoma | 40047 | 21 | 1 |
126259 | 126259 | 2020-05-08 | Garfield | Oklahoma | 40047 | 22 | 1 |
129248 | 129248 | 2020-05-09 | Garfield | Oklahoma | 40047 | 22 | 1 |
132237 | 132237 | 2020-05-10 | Garfield | Oklahoma | 40047 | 22 | 1 |
135228 | 135228 | 2020-05-11 | Garfield | Oklahoma | 40047 | 22 | 1 |
138218 | 138218 | 2020-05-12 | Garfield | Oklahoma | 40047 | 21 | 1 |
141214 | 141214 | 2020-05-13 | Garfield | Oklahoma | 40047 | 22 | 1 |
144209 | 144209 | 2020-05-14 | Garfield | Oklahoma | 40047 | 22 | 1 |
147210 | 147210 | 2020-05-15 | Garfield | Oklahoma | 40047 | 23 | 1 |
150217 | 150217 | 2020-05-16 | Garfield | Oklahoma | 40047 | 23 | 1 |
153228 | 153228 | 2020-05-17 | Garfield | Oklahoma | 40047 | 23 | 1 |
156245 | 156245 | 2020-05-18 | Garfield | Oklahoma | 40047 | 23 | 1 |
159266 | 159266 | 2020-05-19 | Garfield | Oklahoma | 40047 | 23 | 1 |
162293 | 162293 | 2020-05-20 | Garfield | Oklahoma | 40047 | 24 | 1 |
165322 | 165322 | 2020-05-21 | Garfield | Oklahoma | 40047 | 24 | 1 |
168358 | 168358 | 2020-05-22 | Garfield | Oklahoma | 40047 | 25 | 1 |
171397 | 171397 | 2020-05-23 | Garfield | Oklahoma | 40047 | 25 | 1 |
174439 | 174439 | 2020-05-24 | Garfield | Oklahoma | 40047 | 26 | 1 |
177483 | 177483 | 2020-05-25 | Garfield | Oklahoma | 40047 | 26 | 1 |
180526 | 180526 | 2020-05-26 | Garfield | Oklahoma | 40047 | 26 | 1 |
183575 | 183575 | 2020-05-27 | Garfield | Oklahoma | 40047 | 26 | 1 |
186632 | 186632 | 2020-05-28 | Garfield | Oklahoma | 40047 | 26 | 1 |
189692 | 189692 | 2020-05-29 | Garfield | Oklahoma | 40047 | 26 | 1 |
192757 | 192757 | 2020-05-30 | Garfield | Oklahoma | 40047 | 27 | 1 |
195826 | 195826 | 2020-05-31 | Garfield | Oklahoma | 40047 | 28 | 1 |
198899 | 198899 | 2020-06-01 | Garfield | Oklahoma | 40047 | 28 | 1 |
201974 | 201974 | 2020-06-02 | Garfield | Oklahoma | 40047 | 27 | 1 |
205051 | 205051 | 2020-06-03 | Garfield | Oklahoma | 40047 | 27 | 1 |
208132 | 208132 | 2020-06-04 | Garfield | Oklahoma | 40047 | 28 | 1 |
211214 | 211214 | 2020-06-05 | Garfield | Oklahoma | 40047 | 29 | 1 |
214300 | 214300 | 2020-06-06 | Garfield | Oklahoma | 40047 | 29 | 1 |
217390 | 217390 | 2020-06-07 | Garfield | Oklahoma | 40047 | 30 | 1 |
220482 | 220482 | 2020-06-08 | Garfield | Oklahoma | 40047 | 30 | 1 |
223577 | 223577 | 2020-06-09 | Garfield | Oklahoma | 40047 | 31 | 1 |
226677 | 226677 | 2020-06-10 | Garfield | Oklahoma | 40047 | 31 | 1 |
229781 | 229781 | 2020-06-11 | Garfield | Oklahoma | 40047 | 31 | 1 |
232886 | 232886 | 2020-06-12 | Garfield | Oklahoma | 40047 | 45 | 1 |
235991 | 235991 | 2020-06-13 | Garfield | Oklahoma | 40047 | 46 | 1 |
239099 | 239099 | 2020-06-14 | Garfield | Oklahoma | 40047 | 47 | 1 |
242208 | 242208 | 2020-06-15 | Garfield | Oklahoma | 40047 | 47 | 1 |
245320 | 245320 | 2020-06-16 | Garfield | Oklahoma | 40047 | 51 | 1 |
248433 | 248433 | 2020-06-17 | Garfield | Oklahoma | 40047 | 51 | 1 |
251548 | 251548 | 2020-06-18 | Garfield | Oklahoma | 40047 | 53 | 1 |
254663 | 254663 | 2020-06-19 | Garfield | Oklahoma | 40047 | 54 | 1 |
257789 | 257789 | 2020-06-20 | Garfield | Oklahoma | 40047 | 55 | 1 |
260916 | 260916 | 2020-06-21 | Garfield | Oklahoma | 40047 | 55 | 1 |
264044 | 264044 | 2020-06-22 | Garfield | Oklahoma | 40047 | 55 | 1 |
267172 | 267172 | 2020-06-23 | Garfield | Oklahoma | 40047 | 60 | 1 |
270306 | 270306 | 2020-06-24 | Garfield | Oklahoma | 40047 | 62 | 2 |
273445 | 273445 | 2020-06-25 | Garfield | Oklahoma | 40047 | 64 | 2 |
276592 | 276592 | 2020-06-26 | Garfield | Oklahoma | 40047 | 64 | 2 |
279740 | 279740 | 2020-06-27 | Garfield | Oklahoma | 40047 | 64 | 2 |
282886 | 282886 | 2020-06-28 | Garfield | Oklahoma | 40047 | 65 | 2 |
286031 | 286031 | 2020-06-29 | Garfield | Oklahoma | 40047 | 66 | 2 |
289181 | 289181 | 2020-06-30 | Garfield | Oklahoma | 40047 | 67 | 2 |
292333 | 292333 | 2020-07-01 | Garfield | Oklahoma | 40047 | 68 | 2 |
295489 | 295489 | 2020-07-02 | Garfield | Oklahoma | 40047 | 75 | 2 |
298648 | 298648 | 2020-07-03 | Garfield | Oklahoma | 40047 | 74 | 2 |
301811 | 301811 | 2020-07-04 | Garfield | Oklahoma | 40047 | 78 | 2 |
304974 | 304974 | 2020-07-05 | Garfield | Oklahoma | 40047 | 79 | 2 |
308141 | 308141 | 2020-07-06 | Garfield | Oklahoma | 40047 | 82 | 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);