ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Washington" and state = "Oklahoma" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4962 | 4962 | 2020-03-19 | Washington | Oklahoma | 40147 | 1 | 0 |
5829 | 5829 | 2020-03-20 | Washington | Oklahoma | 40147 | 1 | 0 |
6830 | 6830 | 2020-03-21 | Washington | Oklahoma | 40147 | 1 | 0 |
7945 | 7945 | 2020-03-22 | Washington | Oklahoma | 40147 | 2 | 0 |
9154 | 9154 | 2020-03-23 | Washington | Oklahoma | 40147 | 2 | 0 |
10472 | 10472 | 2020-03-24 | Washington | Oklahoma | 40147 | 2 | 0 |
11933 | 11933 | 2020-03-25 | Washington | Oklahoma | 40147 | 3 | 0 |
13549 | 13549 | 2020-03-26 | Washington | Oklahoma | 40147 | 5 | 0 |
15293 | 15293 | 2020-03-27 | Washington | Oklahoma | 40147 | 9 | 0 |
17140 | 17140 | 2020-03-28 | Washington | Oklahoma | 40147 | 14 | 0 |
19078 | 19078 | 2020-03-29 | Washington | Oklahoma | 40147 | 18 | 0 |
21128 | 21128 | 2020-03-30 | Washington | Oklahoma | 40147 | 20 | 0 |
23261 | 23261 | 2020-03-31 | Washington | Oklahoma | 40147 | 21 | 0 |
25459 | 25459 | 2020-04-01 | Washington | Oklahoma | 40147 | 23 | 0 |
27730 | 27730 | 2020-04-02 | Washington | Oklahoma | 40147 | 24 | 0 |
30062 | 30062 | 2020-04-03 | Washington | Oklahoma | 40147 | 28 | 0 |
32452 | 32452 | 2020-04-04 | Washington | Oklahoma | 40147 | 33 | 1 |
34886 | 34886 | 2020-04-05 | Washington | Oklahoma | 40147 | 35 | 1 |
37360 | 37360 | 2020-04-06 | Washington | Oklahoma | 40147 | 39 | 1 |
39881 | 39881 | 2020-04-07 | Washington | Oklahoma | 40147 | 43 | 2 |
42441 | 42441 | 2020-04-08 | Washington | Oklahoma | 40147 | 45 | 2 |
45027 | 45027 | 2020-04-09 | Washington | Oklahoma | 40147 | 54 | 2 |
47644 | 47644 | 2020-04-10 | Washington | Oklahoma | 40147 | 57 | 2 |
50300 | 50300 | 2020-04-11 | Washington | Oklahoma | 40147 | 83 | 2 |
52973 | 52973 | 2020-04-12 | Washington | Oklahoma | 40147 | 104 | 2 |
55658 | 55658 | 2020-04-13 | Washington | Oklahoma | 40147 | 114 | 2 |
58360 | 58360 | 2020-04-14 | Washington | Oklahoma | 40147 | 118 | 3 |
61075 | 61075 | 2020-04-15 | Washington | Oklahoma | 40147 | 118 | 5 |
63801 | 63801 | 2020-04-16 | Washington | Oklahoma | 40147 | 124 | 6 |
66546 | 66546 | 2020-04-17 | Washington | Oklahoma | 40147 | 133 | 6 |
69304 | 69304 | 2020-04-18 | Washington | Oklahoma | 40147 | 138 | 6 |
72071 | 72071 | 2020-04-19 | Washington | Oklahoma | 40147 | 140 | 6 |
74846 | 74846 | 2020-04-20 | Washington | Oklahoma | 40147 | 148 | 6 |
77628 | 77628 | 2020-04-21 | Washington | Oklahoma | 40147 | 192 | 10 |
80418 | 80418 | 2020-04-22 | Washington | Oklahoma | 40147 | 201 | 11 |
83217 | 83217 | 2020-04-23 | Washington | Oklahoma | 40147 | 208 | 13 |
86021 | 86021 | 2020-04-24 | Washington | Oklahoma | 40147 | 216 | 13 |
88835 | 88835 | 2020-04-25 | Washington | Oklahoma | 40147 | 222 | 15 |
91651 | 91651 | 2020-04-26 | Washington | Oklahoma | 40147 | 229 | 15 |
94478 | 94478 | 2020-04-27 | Washington | Oklahoma | 40147 | 231 | 15 |
97316 | 97316 | 2020-04-28 | Washington | Oklahoma | 40147 | 244 | 18 |
100165 | 100165 | 2020-04-29 | Washington | Oklahoma | 40147 | 248 | 19 |
103018 | 103018 | 2020-04-30 | Washington | Oklahoma | 40147 | 256 | 19 |
105881 | 105881 | 2020-05-01 | Washington | Oklahoma | 40147 | 263 | 22 |
108748 | 108748 | 2020-05-02 | Washington | Oklahoma | 40147 | 268 | 23 |
111622 | 111622 | 2020-05-03 | Washington | Oklahoma | 40147 | 273 | 23 |
114504 | 114504 | 2020-05-04 | Washington | Oklahoma | 40147 | 276 | 23 |
117385 | 117385 | 2020-05-05 | Washington | Oklahoma | 40147 | 281 | 23 |
120346 | 120346 | 2020-05-06 | Washington | Oklahoma | 40147 | 283 | 23 |
123323 | 123323 | 2020-05-07 | Washington | Oklahoma | 40147 | 289 | 26 |
126306 | 126306 | 2020-05-08 | Washington | Oklahoma | 40147 | 291 | 27 |
129295 | 129295 | 2020-05-09 | Washington | Oklahoma | 40147 | 296 | 28 |
132284 | 132284 | 2020-05-10 | Washington | Oklahoma | 40147 | 296 | 29 |
135275 | 135275 | 2020-05-11 | Washington | Oklahoma | 40147 | 301 | 29 |
138265 | 138265 | 2020-05-12 | Washington | Oklahoma | 40147 | 300 | 28 |
141261 | 141261 | 2020-05-13 | Washington | Oklahoma | 40147 | 300 | 28 |
144256 | 144256 | 2020-05-14 | Washington | Oklahoma | 40147 | 301 | 29 |
147257 | 147257 | 2020-05-15 | Washington | Oklahoma | 40147 | 301 | 30 |
150264 | 150264 | 2020-05-16 | Washington | Oklahoma | 40147 | 302 | 30 |
153275 | 153275 | 2020-05-17 | Washington | Oklahoma | 40147 | 303 | 30 |
156292 | 156292 | 2020-05-18 | Washington | Oklahoma | 40147 | 303 | 30 |
159313 | 159313 | 2020-05-19 | Washington | Oklahoma | 40147 | 304 | 32 |
162340 | 162340 | 2020-05-20 | Washington | Oklahoma | 40147 | 304 | 32 |
165369 | 165369 | 2020-05-21 | Washington | Oklahoma | 40147 | 307 | 33 |
168405 | 168405 | 2020-05-22 | Washington | Oklahoma | 40147 | 309 | 33 |
171444 | 171444 | 2020-05-23 | Washington | Oklahoma | 40147 | 310 | 33 |
174486 | 174486 | 2020-05-24 | Washington | Oklahoma | 40147 | 310 | 33 |
177530 | 177530 | 2020-05-25 | Washington | Oklahoma | 40147 | 310 | 33 |
180573 | 180573 | 2020-05-26 | Washington | Oklahoma | 40147 | 312 | 33 |
183622 | 183622 | 2020-05-27 | Washington | Oklahoma | 40147 | 314 | 35 |
186679 | 186679 | 2020-05-28 | Washington | Oklahoma | 40147 | 314 | 35 |
189740 | 189740 | 2020-05-29 | Washington | Oklahoma | 40147 | 314 | 35 |
192805 | 192805 | 2020-05-30 | Washington | Oklahoma | 40147 | 316 | 35 |
195874 | 195874 | 2020-05-31 | Washington | Oklahoma | 40147 | 317 | 35 |
198947 | 198947 | 2020-06-01 | Washington | Oklahoma | 40147 | 325 | 35 |
202022 | 202022 | 2020-06-02 | Washington | Oklahoma | 40147 | 327 | 36 |
205099 | 205099 | 2020-06-03 | Washington | Oklahoma | 40147 | 334 | 36 |
208180 | 208180 | 2020-06-04 | Washington | Oklahoma | 40147 | 338 | 36 |
211262 | 211262 | 2020-06-05 | Washington | Oklahoma | 40147 | 339 | 37 |
214348 | 214348 | 2020-06-06 | Washington | Oklahoma | 40147 | 340 | 37 |
217438 | 217438 | 2020-06-07 | Washington | Oklahoma | 40147 | 340 | 37 |
220530 | 220530 | 2020-06-08 | Washington | Oklahoma | 40147 | 340 | 37 |
223625 | 223625 | 2020-06-09 | Washington | Oklahoma | 40147 | 343 | 37 |
226725 | 226725 | 2020-06-10 | Washington | Oklahoma | 40147 | 343 | 37 |
229829 | 229829 | 2020-06-11 | Washington | Oklahoma | 40147 | 344 | 37 |
232934 | 232934 | 2020-06-12 | Washington | Oklahoma | 40147 | 345 | 37 |
236039 | 236039 | 2020-06-13 | Washington | Oklahoma | 40147 | 348 | 37 |
239147 | 239147 | 2020-06-14 | Washington | Oklahoma | 40147 | 348 | 37 |
242256 | 242256 | 2020-06-15 | Washington | Oklahoma | 40147 | 350 | 37 |
245368 | 245368 | 2020-06-16 | Washington | Oklahoma | 40147 | 353 | 38 |
248481 | 248481 | 2020-06-17 | Washington | Oklahoma | 40147 | 357 | 38 |
251596 | 251596 | 2020-06-18 | Washington | Oklahoma | 40147 | 361 | 38 |
254711 | 254711 | 2020-06-19 | Washington | Oklahoma | 40147 | 365 | 38 |
257837 | 257837 | 2020-06-20 | Washington | Oklahoma | 40147 | 367 | 38 |
260964 | 260964 | 2020-06-21 | Washington | Oklahoma | 40147 | 375 | 38 |
264092 | 264092 | 2020-06-22 | Washington | Oklahoma | 40147 | 377 | 38 |
267220 | 267220 | 2020-06-23 | Washington | Oklahoma | 40147 | 381 | 38 |
270354 | 270354 | 2020-06-24 | Washington | Oklahoma | 40147 | 385 | 38 |
273493 | 273493 | 2020-06-25 | Washington | Oklahoma | 40147 | 388 | 38 |
276640 | 276640 | 2020-06-26 | Washington | Oklahoma | 40147 | 391 | 38 |
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);