ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Delaware" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333573 | 333573 | 2020-07-14 | Delaware | Oklahoma | 40041 | 261 | 17 |
330381 | 330381 | 2020-07-13 | Delaware | Oklahoma | 40041 | 244 | 17 |
327194 | 327194 | 2020-07-12 | Delaware | Oklahoma | 40041 | 242 | 17 |
324009 | 324009 | 2020-07-11 | Delaware | Oklahoma | 40041 | 239 | 17 |
320829 | 320829 | 2020-07-10 | Delaware | Oklahoma | 40041 | 229 | 17 |
317652 | 317652 | 2020-07-09 | Delaware | Oklahoma | 40041 | 218 | 17 |
314479 | 314479 | 2020-07-08 | Delaware | Oklahoma | 40041 | 200 | 17 |
311307 | 311307 | 2020-07-07 | Delaware | Oklahoma | 40041 | 199 | 17 |
308138 | 308138 | 2020-07-06 | Delaware | Oklahoma | 40041 | 181 | 16 |
304971 | 304971 | 2020-07-05 | Delaware | Oklahoma | 40041 | 175 | 16 |
301808 | 301808 | 2020-07-04 | Delaware | Oklahoma | 40041 | 172 | 16 |
298645 | 298645 | 2020-07-03 | Delaware | Oklahoma | 40041 | 165 | 16 |
295486 | 295486 | 2020-07-02 | Delaware | Oklahoma | 40041 | 162 | 16 |
292330 | 292330 | 2020-07-01 | Delaware | Oklahoma | 40041 | 153 | 16 |
289178 | 289178 | 2020-06-30 | Delaware | Oklahoma | 40041 | 152 | 16 |
286028 | 286028 | 2020-06-29 | Delaware | Oklahoma | 40041 | 136 | 16 |
282883 | 282883 | 2020-06-28 | Delaware | Oklahoma | 40041 | 132 | 16 |
279737 | 279737 | 2020-06-27 | Delaware | Oklahoma | 40041 | 127 | 16 |
276589 | 276589 | 2020-06-26 | Delaware | Oklahoma | 40041 | 124 | 16 |
273442 | 273442 | 2020-06-25 | Delaware | Oklahoma | 40041 | 121 | 16 |
270303 | 270303 | 2020-06-24 | Delaware | Oklahoma | 40041 | 119 | 16 |
267169 | 267169 | 2020-06-23 | Delaware | Oklahoma | 40041 | 118 | 16 |
264041 | 264041 | 2020-06-22 | Delaware | Oklahoma | 40041 | 117 | 16 |
260913 | 260913 | 2020-06-21 | Delaware | Oklahoma | 40041 | 117 | 16 |
257787 | 257787 | 2020-06-20 | Delaware | Oklahoma | 40041 | 115 | 16 |
254661 | 254661 | 2020-06-19 | Delaware | Oklahoma | 40041 | 114 | 16 |
251546 | 251546 | 2020-06-18 | Delaware | Oklahoma | 40041 | 112 | 16 |
248431 | 248431 | 2020-06-17 | Delaware | Oklahoma | 40041 | 112 | 16 |
245318 | 245318 | 2020-06-16 | Delaware | Oklahoma | 40041 | 111 | 16 |
242206 | 242206 | 2020-06-15 | Delaware | Oklahoma | 40041 | 109 | 16 |
239097 | 239097 | 2020-06-14 | Delaware | Oklahoma | 40041 | 108 | 16 |
235989 | 235989 | 2020-06-13 | Delaware | Oklahoma | 40041 | 107 | 16 |
232884 | 232884 | 2020-06-12 | Delaware | Oklahoma | 40041 | 107 | 16 |
229779 | 229779 | 2020-06-11 | Delaware | Oklahoma | 40041 | 104 | 16 |
226675 | 226675 | 2020-06-10 | Delaware | Oklahoma | 40041 | 104 | 16 |
223575 | 223575 | 2020-06-09 | Delaware | Oklahoma | 40041 | 103 | 16 |
220480 | 220480 | 2020-06-08 | Delaware | Oklahoma | 40041 | 102 | 16 |
217388 | 217388 | 2020-06-07 | Delaware | Oklahoma | 40041 | 102 | 16 |
214298 | 214298 | 2020-06-06 | Delaware | Oklahoma | 40041 | 100 | 16 |
211212 | 211212 | 2020-06-05 | Delaware | Oklahoma | 40041 | 100 | 16 |
208130 | 208130 | 2020-06-04 | Delaware | Oklahoma | 40041 | 100 | 16 |
205049 | 205049 | 2020-06-03 | Delaware | Oklahoma | 40041 | 100 | 16 |
201972 | 201972 | 2020-06-02 | Delaware | Oklahoma | 40041 | 100 | 16 |
198897 | 198897 | 2020-06-01 | Delaware | Oklahoma | 40041 | 100 | 16 |
195824 | 195824 | 2020-05-31 | Delaware | Oklahoma | 40041 | 100 | 16 |
192755 | 192755 | 2020-05-30 | Delaware | Oklahoma | 40041 | 100 | 16 |
189690 | 189690 | 2020-05-29 | Delaware | Oklahoma | 40041 | 100 | 16 |
186630 | 186630 | 2020-05-28 | Delaware | Oklahoma | 40041 | 100 | 16 |
183573 | 183573 | 2020-05-27 | Delaware | Oklahoma | 40041 | 100 | 16 |
180524 | 180524 | 2020-05-26 | Delaware | Oklahoma | 40041 | 100 | 16 |
177481 | 177481 | 2020-05-25 | Delaware | Oklahoma | 40041 | 99 | 16 |
174437 | 174437 | 2020-05-24 | Delaware | Oklahoma | 40041 | 99 | 16 |
171395 | 171395 | 2020-05-23 | Delaware | Oklahoma | 40041 | 99 | 16 |
168356 | 168356 | 2020-05-22 | Delaware | Oklahoma | 40041 | 97 | 16 |
165320 | 165320 | 2020-05-21 | Delaware | Oklahoma | 40041 | 97 | 16 |
162291 | 162291 | 2020-05-20 | Delaware | Oklahoma | 40041 | 96 | 16 |
159264 | 159264 | 2020-05-19 | Delaware | Oklahoma | 40041 | 96 | 16 |
156243 | 156243 | 2020-05-18 | Delaware | Oklahoma | 40041 | 95 | 16 |
153226 | 153226 | 2020-05-17 | Delaware | Oklahoma | 40041 | 95 | 16 |
150215 | 150215 | 2020-05-16 | Delaware | Oklahoma | 40041 | 95 | 16 |
147208 | 147208 | 2020-05-15 | Delaware | Oklahoma | 40041 | 93 | 16 |
144207 | 144207 | 2020-05-14 | Delaware | Oklahoma | 40041 | 93 | 16 |
141212 | 141212 | 2020-05-13 | Delaware | Oklahoma | 40041 | 93 | 16 |
138216 | 138216 | 2020-05-12 | Delaware | Oklahoma | 40041 | 94 | 16 |
135226 | 135226 | 2020-05-11 | Delaware | Oklahoma | 40041 | 93 | 16 |
132235 | 132235 | 2020-05-10 | Delaware | Oklahoma | 40041 | 92 | 16 |
129246 | 129246 | 2020-05-09 | Delaware | Oklahoma | 40041 | 92 | 16 |
126257 | 126257 | 2020-05-08 | Delaware | Oklahoma | 40041 | 92 | 15 |
123274 | 123274 | 2020-05-07 | Delaware | Oklahoma | 40041 | 92 | 15 |
120297 | 120297 | 2020-05-06 | Delaware | Oklahoma | 40041 | 92 | 14 |
117336 | 117336 | 2020-05-05 | Delaware | Oklahoma | 40041 | 92 | 14 |
114455 | 114455 | 2020-05-04 | Delaware | Oklahoma | 40041 | 91 | 13 |
111573 | 111573 | 2020-05-03 | Delaware | Oklahoma | 40041 | 91 | 13 |
108699 | 108699 | 2020-05-02 | Delaware | Oklahoma | 40041 | 91 | 13 |
105832 | 105832 | 2020-05-01 | Delaware | Oklahoma | 40041 | 91 | 13 |
102969 | 102969 | 2020-04-30 | Delaware | Oklahoma | 40041 | 90 | 13 |
100116 | 100116 | 2020-04-29 | Delaware | Oklahoma | 40041 | 90 | 11 |
97267 | 97267 | 2020-04-28 | Delaware | Oklahoma | 40041 | 90 | 11 |
94429 | 94429 | 2020-04-27 | Delaware | Oklahoma | 40041 | 90 | 10 |
91603 | 91603 | 2020-04-26 | Delaware | Oklahoma | 40041 | 90 | 10 |
88787 | 88787 | 2020-04-25 | Delaware | Oklahoma | 40041 | 90 | 10 |
85973 | 85973 | 2020-04-24 | Delaware | Oklahoma | 40041 | 90 | 9 |
83169 | 83169 | 2020-04-23 | Delaware | Oklahoma | 40041 | 89 | 9 |
80370 | 80370 | 2020-04-22 | Delaware | Oklahoma | 40041 | 88 | 9 |
77580 | 77580 | 2020-04-21 | Delaware | Oklahoma | 40041 | 87 | 9 |
74798 | 74798 | 2020-04-20 | Delaware | Oklahoma | 40041 | 86 | 5 |
72023 | 72023 | 2020-04-19 | Delaware | Oklahoma | 40041 | 83 | 5 |
69256 | 69256 | 2020-04-18 | Delaware | Oklahoma | 40041 | 80 | 4 |
66499 | 66499 | 2020-04-17 | Delaware | Oklahoma | 40041 | 76 | 4 |
63756 | 63756 | 2020-04-16 | Delaware | Oklahoma | 40041 | 74 | 2 |
61030 | 61030 | 2020-04-15 | Delaware | Oklahoma | 40041 | 72 | 0 |
58315 | 58315 | 2020-04-14 | Delaware | Oklahoma | 40041 | 71 | 0 |
55614 | 55614 | 2020-04-13 | Delaware | Oklahoma | 40041 | 63 | 0 |
52929 | 52929 | 2020-04-12 | Delaware | Oklahoma | 40041 | 50 | 0 |
50256 | 50256 | 2020-04-11 | Delaware | Oklahoma | 40041 | 24 | 0 |
47600 | 47600 | 2020-04-10 | Delaware | Oklahoma | 40041 | 23 | 0 |
44985 | 44985 | 2020-04-09 | Delaware | Oklahoma | 40041 | 14 | 0 |
42399 | 42399 | 2020-04-08 | Delaware | Oklahoma | 40041 | 13 | 0 |
39839 | 39839 | 2020-04-07 | Delaware | Oklahoma | 40041 | 13 | 0 |
37320 | 37320 | 2020-04-06 | Delaware | Oklahoma | 40041 | 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);