ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 40095 and state = "Oklahoma" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
39857 | 39857 | 2020-04-07 | Marshall | Oklahoma | 40095 | 1 | 0 |
42417 | 42417 | 2020-04-08 | Marshall | Oklahoma | 40095 | 1 | 0 |
45003 | 45003 | 2020-04-09 | Marshall | Oklahoma | 40095 | 1 | 0 |
47618 | 47618 | 2020-04-10 | Marshall | Oklahoma | 40095 | 1 | 0 |
50274 | 50274 | 2020-04-11 | Marshall | Oklahoma | 40095 | 1 | 0 |
52947 | 52947 | 2020-04-12 | Marshall | Oklahoma | 40095 | 1 | 0 |
55632 | 55632 | 2020-04-13 | Marshall | Oklahoma | 40095 | 1 | 0 |
58334 | 58334 | 2020-04-14 | Marshall | Oklahoma | 40095 | 1 | 0 |
61049 | 61049 | 2020-04-15 | Marshall | Oklahoma | 40095 | 1 | 0 |
63775 | 63775 | 2020-04-16 | Marshall | Oklahoma | 40095 | 1 | 0 |
66519 | 66519 | 2020-04-17 | Marshall | Oklahoma | 40095 | 1 | 0 |
69277 | 69277 | 2020-04-18 | Marshall | Oklahoma | 40095 | 2 | 0 |
72044 | 72044 | 2020-04-19 | Marshall | Oklahoma | 40095 | 2 | 0 |
74819 | 74819 | 2020-04-20 | Marshall | Oklahoma | 40095 | 2 | 0 |
77601 | 77601 | 2020-04-21 | Marshall | Oklahoma | 40095 | 2 | 0 |
80391 | 80391 | 2020-04-22 | Marshall | Oklahoma | 40095 | 2 | 0 |
83190 | 83190 | 2020-04-23 | Marshall | Oklahoma | 40095 | 2 | 0 |
85994 | 85994 | 2020-04-24 | Marshall | Oklahoma | 40095 | 2 | 0 |
88808 | 88808 | 2020-04-25 | Marshall | Oklahoma | 40095 | 2 | 0 |
91624 | 91624 | 2020-04-26 | Marshall | Oklahoma | 40095 | 2 | 0 |
94450 | 94450 | 2020-04-27 | Marshall | Oklahoma | 40095 | 2 | 0 |
97288 | 97288 | 2020-04-28 | Marshall | Oklahoma | 40095 | 2 | 0 |
100137 | 100137 | 2020-04-29 | Marshall | Oklahoma | 40095 | 2 | 0 |
102990 | 102990 | 2020-04-30 | Marshall | Oklahoma | 40095 | 2 | 0 |
105853 | 105853 | 2020-05-01 | Marshall | Oklahoma | 40095 | 2 | 0 |
108720 | 108720 | 2020-05-02 | Marshall | Oklahoma | 40095 | 2 | 0 |
111594 | 111594 | 2020-05-03 | Marshall | Oklahoma | 40095 | 2 | 0 |
114476 | 114476 | 2020-05-04 | Marshall | Oklahoma | 40095 | 2 | 0 |
117357 | 117357 | 2020-05-05 | Marshall | Oklahoma | 40095 | 2 | 0 |
120318 | 120318 | 2020-05-06 | Marshall | Oklahoma | 40095 | 2 | 0 |
123295 | 123295 | 2020-05-07 | Marshall | Oklahoma | 40095 | 2 | 0 |
126278 | 126278 | 2020-05-08 | Marshall | Oklahoma | 40095 | 2 | 0 |
129267 | 129267 | 2020-05-09 | Marshall | Oklahoma | 40095 | 2 | 0 |
132256 | 132256 | 2020-05-10 | Marshall | Oklahoma | 40095 | 2 | 0 |
135247 | 135247 | 2020-05-11 | Marshall | Oklahoma | 40095 | 2 | 0 |
138237 | 138237 | 2020-05-12 | Marshall | Oklahoma | 40095 | 2 | 0 |
141233 | 141233 | 2020-05-13 | Marshall | Oklahoma | 40095 | 2 | 0 |
144228 | 144228 | 2020-05-14 | Marshall | Oklahoma | 40095 | 2 | 0 |
147229 | 147229 | 2020-05-15 | Marshall | Oklahoma | 40095 | 4 | 0 |
150236 | 150236 | 2020-05-16 | Marshall | Oklahoma | 40095 | 4 | 0 |
153247 | 153247 | 2020-05-17 | Marshall | Oklahoma | 40095 | 4 | 0 |
156264 | 156264 | 2020-05-18 | Marshall | Oklahoma | 40095 | 6 | 0 |
159285 | 159285 | 2020-05-19 | Marshall | Oklahoma | 40095 | 6 | 0 |
162312 | 162312 | 2020-05-20 | Marshall | Oklahoma | 40095 | 6 | 0 |
165341 | 165341 | 2020-05-21 | Marshall | Oklahoma | 40095 | 7 | 0 |
168377 | 168377 | 2020-05-22 | Marshall | Oklahoma | 40095 | 7 | 0 |
171416 | 171416 | 2020-05-23 | Marshall | Oklahoma | 40095 | 7 | 0 |
174458 | 174458 | 2020-05-24 | Marshall | Oklahoma | 40095 | 7 | 0 |
177502 | 177502 | 2020-05-25 | Marshall | Oklahoma | 40095 | 8 | 0 |
180545 | 180545 | 2020-05-26 | Marshall | Oklahoma | 40095 | 8 | 0 |
183594 | 183594 | 2020-05-27 | Marshall | Oklahoma | 40095 | 8 | 0 |
186651 | 186651 | 2020-05-28 | Marshall | Oklahoma | 40095 | 8 | 0 |
189712 | 189712 | 2020-05-29 | Marshall | Oklahoma | 40095 | 8 | 0 |
192777 | 192777 | 2020-05-30 | Marshall | Oklahoma | 40095 | 8 | 0 |
195846 | 195846 | 2020-05-31 | Marshall | Oklahoma | 40095 | 8 | 0 |
198919 | 198919 | 2020-06-01 | Marshall | Oklahoma | 40095 | 8 | 0 |
201994 | 201994 | 2020-06-02 | Marshall | Oklahoma | 40095 | 8 | 0 |
205071 | 205071 | 2020-06-03 | Marshall | Oklahoma | 40095 | 8 | 0 |
208152 | 208152 | 2020-06-04 | Marshall | Oklahoma | 40095 | 10 | 0 |
211234 | 211234 | 2020-06-05 | Marshall | Oklahoma | 40095 | 9 | 0 |
214320 | 214320 | 2020-06-06 | Marshall | Oklahoma | 40095 | 9 | 0 |
217410 | 217410 | 2020-06-07 | Marshall | Oklahoma | 40095 | 11 | 0 |
220502 | 220502 | 2020-06-08 | Marshall | Oklahoma | 40095 | 11 | 0 |
223597 | 223597 | 2020-06-09 | Marshall | Oklahoma | 40095 | 11 | 0 |
226697 | 226697 | 2020-06-10 | Marshall | Oklahoma | 40095 | 12 | 0 |
229801 | 229801 | 2020-06-11 | Marshall | Oklahoma | 40095 | 13 | 0 |
232906 | 232906 | 2020-06-12 | Marshall | Oklahoma | 40095 | 13 | 0 |
236011 | 236011 | 2020-06-13 | Marshall | Oklahoma | 40095 | 15 | 0 |
239119 | 239119 | 2020-06-14 | Marshall | Oklahoma | 40095 | 15 | 0 |
242228 | 242228 | 2020-06-15 | Marshall | Oklahoma | 40095 | 16 | 0 |
245340 | 245340 | 2020-06-16 | Marshall | Oklahoma | 40095 | 20 | 0 |
248453 | 248453 | 2020-06-17 | Marshall | Oklahoma | 40095 | 20 | 0 |
251568 | 251568 | 2020-06-18 | Marshall | Oklahoma | 40095 | 21 | 0 |
254683 | 254683 | 2020-06-19 | Marshall | Oklahoma | 40095 | 21 | 0 |
257809 | 257809 | 2020-06-20 | Marshall | Oklahoma | 40095 | 22 | 0 |
260936 | 260936 | 2020-06-21 | Marshall | Oklahoma | 40095 | 22 | 0 |
264064 | 264064 | 2020-06-22 | Marshall | Oklahoma | 40095 | 23 | 0 |
267192 | 267192 | 2020-06-23 | Marshall | Oklahoma | 40095 | 25 | 0 |
270326 | 270326 | 2020-06-24 | Marshall | Oklahoma | 40095 | 25 | 0 |
273465 | 273465 | 2020-06-25 | Marshall | Oklahoma | 40095 | 25 | 0 |
276612 | 276612 | 2020-06-26 | Marshall | Oklahoma | 40095 | 25 | 0 |
279760 | 279760 | 2020-06-27 | Marshall | Oklahoma | 40095 | 25 | 0 |
282906 | 282906 | 2020-06-28 | Marshall | Oklahoma | 40095 | 25 | 0 |
286051 | 286051 | 2020-06-29 | Marshall | Oklahoma | 40095 | 26 | 0 |
289201 | 289201 | 2020-06-30 | Marshall | Oklahoma | 40095 | 32 | 0 |
292354 | 292354 | 2020-07-01 | Marshall | Oklahoma | 40095 | 32 | 0 |
295510 | 295510 | 2020-07-02 | Marshall | Oklahoma | 40095 | 33 | 0 |
298669 | 298669 | 2020-07-03 | Marshall | Oklahoma | 40095 | 33 | 0 |
301832 | 301832 | 2020-07-04 | Marshall | Oklahoma | 40095 | 36 | 0 |
304995 | 304995 | 2020-07-05 | Marshall | Oklahoma | 40095 | 37 | 0 |
308162 | 308162 | 2020-07-06 | Marshall | Oklahoma | 40095 | 37 | 0 |
311331 | 311331 | 2020-07-07 | Marshall | Oklahoma | 40095 | 41 | 0 |
314503 | 314503 | 2020-07-08 | Marshall | Oklahoma | 40095 | 43 | 0 |
317676 | 317676 | 2020-07-09 | Marshall | Oklahoma | 40095 | 43 | 0 |
320853 | 320853 | 2020-07-10 | Marshall | Oklahoma | 40095 | 43 | 0 |
324033 | 324033 | 2020-07-11 | Marshall | Oklahoma | 40095 | 43 | 0 |
327218 | 327218 | 2020-07-12 | Marshall | Oklahoma | 40095 | 43 | 0 |
330405 | 330405 | 2020-07-13 | Marshall | Oklahoma | 40095 | 43 | 0 |
333597 | 333597 | 2020-07-14 | Marshall | Oklahoma | 40095 | 47 | 0 |
336791 | 336791 | 2020-07-15 | Marshall | Oklahoma | 40095 | 49 | 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);