ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Pawnee" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333611 | 333611 | 2020-07-14 | Pawnee | Oklahoma | 40117 | 73 | 3 |
330419 | 330419 | 2020-07-13 | Pawnee | Oklahoma | 40117 | 71 | 3 |
327232 | 327232 | 2020-07-12 | Pawnee | Oklahoma | 40117 | 70 | 3 |
324047 | 324047 | 2020-07-11 | Pawnee | Oklahoma | 40117 | 68 | 3 |
320867 | 320867 | 2020-07-10 | Pawnee | Oklahoma | 40117 | 68 | 3 |
317690 | 317690 | 2020-07-09 | Pawnee | Oklahoma | 40117 | 65 | 3 |
314517 | 314517 | 2020-07-08 | Pawnee | Oklahoma | 40117 | 61 | 2 |
311345 | 311345 | 2020-07-07 | Pawnee | Oklahoma | 40117 | 60 | 2 |
308176 | 308176 | 2020-07-06 | Pawnee | Oklahoma | 40117 | 58 | 2 |
305009 | 305009 | 2020-07-05 | Pawnee | Oklahoma | 40117 | 58 | 2 |
301846 | 301846 | 2020-07-04 | Pawnee | Oklahoma | 40117 | 58 | 2 |
298683 | 298683 | 2020-07-03 | Pawnee | Oklahoma | 40117 | 57 | 2 |
295524 | 295524 | 2020-07-02 | Pawnee | Oklahoma | 40117 | 57 | 2 |
292368 | 292368 | 2020-07-01 | Pawnee | Oklahoma | 40117 | 57 | 2 |
289215 | 289215 | 2020-06-30 | Pawnee | Oklahoma | 40117 | 56 | 2 |
286065 | 286065 | 2020-06-29 | Pawnee | Oklahoma | 40117 | 54 | 2 |
282920 | 282920 | 2020-06-28 | Pawnee | Oklahoma | 40117 | 53 | 2 |
279774 | 279774 | 2020-06-27 | Pawnee | Oklahoma | 40117 | 51 | 2 |
276626 | 276626 | 2020-06-26 | Pawnee | Oklahoma | 40117 | 51 | 2 |
273479 | 273479 | 2020-06-25 | Pawnee | Oklahoma | 40117 | 51 | 2 |
270340 | 270340 | 2020-06-24 | Pawnee | Oklahoma | 40117 | 51 | 2 |
267206 | 267206 | 2020-06-23 | Pawnee | Oklahoma | 40117 | 51 | 2 |
264078 | 264078 | 2020-06-22 | Pawnee | Oklahoma | 40117 | 50 | 2 |
260950 | 260950 | 2020-06-21 | Pawnee | Oklahoma | 40117 | 48 | 2 |
257823 | 257823 | 2020-06-20 | Pawnee | Oklahoma | 40117 | 47 | 2 |
254697 | 254697 | 2020-06-19 | Pawnee | Oklahoma | 40117 | 46 | 2 |
251582 | 251582 | 2020-06-18 | Pawnee | Oklahoma | 40117 | 41 | 2 |
248467 | 248467 | 2020-06-17 | Pawnee | Oklahoma | 40117 | 41 | 2 |
245354 | 245354 | 2020-06-16 | Pawnee | Oklahoma | 40117 | 41 | 2 |
242242 | 242242 | 2020-06-15 | Pawnee | Oklahoma | 40117 | 41 | 2 |
239133 | 239133 | 2020-06-14 | Pawnee | Oklahoma | 40117 | 41 | 2 |
236025 | 236025 | 2020-06-13 | Pawnee | Oklahoma | 40117 | 41 | 2 |
232920 | 232920 | 2020-06-12 | Pawnee | Oklahoma | 40117 | 36 | 2 |
229815 | 229815 | 2020-06-11 | Pawnee | Oklahoma | 40117 | 35 | 2 |
226711 | 226711 | 2020-06-10 | Pawnee | Oklahoma | 40117 | 35 | 2 |
223611 | 223611 | 2020-06-09 | Pawnee | Oklahoma | 40117 | 34 | 2 |
220516 | 220516 | 2020-06-08 | Pawnee | Oklahoma | 40117 | 34 | 2 |
217424 | 217424 | 2020-06-07 | Pawnee | Oklahoma | 40117 | 34 | 2 |
214334 | 214334 | 2020-06-06 | Pawnee | Oklahoma | 40117 | 33 | 2 |
211248 | 211248 | 2020-06-05 | Pawnee | Oklahoma | 40117 | 32 | 2 |
208166 | 208166 | 2020-06-04 | Pawnee | Oklahoma | 40117 | 32 | 2 |
205085 | 205085 | 2020-06-03 | Pawnee | Oklahoma | 40117 | 31 | 2 |
202008 | 202008 | 2020-06-02 | Pawnee | Oklahoma | 40117 | 31 | 2 |
198933 | 198933 | 2020-06-01 | Pawnee | Oklahoma | 40117 | 31 | 2 |
195860 | 195860 | 2020-05-31 | Pawnee | Oklahoma | 40117 | 31 | 2 |
192791 | 192791 | 2020-05-30 | Pawnee | Oklahoma | 40117 | 31 | 2 |
189726 | 189726 | 2020-05-29 | Pawnee | Oklahoma | 40117 | 30 | 2 |
186665 | 186665 | 2020-05-28 | Pawnee | Oklahoma | 40117 | 30 | 2 |
183608 | 183608 | 2020-05-27 | Pawnee | Oklahoma | 40117 | 30 | 2 |
180559 | 180559 | 2020-05-26 | Pawnee | Oklahoma | 40117 | 29 | 2 |
177516 | 177516 | 2020-05-25 | Pawnee | Oklahoma | 40117 | 29 | 2 |
174472 | 174472 | 2020-05-24 | Pawnee | Oklahoma | 40117 | 29 | 2 |
171430 | 171430 | 2020-05-23 | Pawnee | Oklahoma | 40117 | 29 | 2 |
168391 | 168391 | 2020-05-22 | Pawnee | Oklahoma | 40117 | 29 | 2 |
165355 | 165355 | 2020-05-21 | Pawnee | Oklahoma | 40117 | 29 | 2 |
162326 | 162326 | 2020-05-20 | Pawnee | Oklahoma | 40117 | 29 | 2 |
159299 | 159299 | 2020-05-19 | Pawnee | Oklahoma | 40117 | 29 | 2 |
156278 | 156278 | 2020-05-18 | Pawnee | Oklahoma | 40117 | 29 | 2 |
153261 | 153261 | 2020-05-17 | Pawnee | Oklahoma | 40117 | 29 | 2 |
150250 | 150250 | 2020-05-16 | Pawnee | Oklahoma | 40117 | 29 | 2 |
147243 | 147243 | 2020-05-15 | Pawnee | Oklahoma | 40117 | 29 | 2 |
144242 | 144242 | 2020-05-14 | Pawnee | Oklahoma | 40117 | 29 | 2 |
141247 | 141247 | 2020-05-13 | Pawnee | Oklahoma | 40117 | 29 | 2 |
138251 | 138251 | 2020-05-12 | Pawnee | Oklahoma | 40117 | 29 | 2 |
135261 | 135261 | 2020-05-11 | Pawnee | Oklahoma | 40117 | 29 | 2 |
132270 | 132270 | 2020-05-10 | Pawnee | Oklahoma | 40117 | 29 | 2 |
129281 | 129281 | 2020-05-09 | Pawnee | Oklahoma | 40117 | 29 | 2 |
126292 | 126292 | 2020-05-08 | Pawnee | Oklahoma | 40117 | 29 | 2 |
123309 | 123309 | 2020-05-07 | Pawnee | Oklahoma | 40117 | 29 | 2 |
120332 | 120332 | 2020-05-06 | Pawnee | Oklahoma | 40117 | 29 | 2 |
117371 | 117371 | 2020-05-05 | Pawnee | Oklahoma | 40117 | 29 | 2 |
114490 | 114490 | 2020-05-04 | Pawnee | Oklahoma | 40117 | 29 | 2 |
111608 | 111608 | 2020-05-03 | Pawnee | Oklahoma | 40117 | 29 | 2 |
108734 | 108734 | 2020-05-02 | Pawnee | Oklahoma | 40117 | 29 | 2 |
105867 | 105867 | 2020-05-01 | Pawnee | Oklahoma | 40117 | 29 | 2 |
103004 | 103004 | 2020-04-30 | Pawnee | Oklahoma | 40117 | 29 | 2 |
100151 | 100151 | 2020-04-29 | Pawnee | Oklahoma | 40117 | 29 | 2 |
97302 | 97302 | 2020-04-28 | Pawnee | Oklahoma | 40117 | 29 | 2 |
94464 | 94464 | 2020-04-27 | Pawnee | Oklahoma | 40117 | 29 | 2 |
91638 | 91638 | 2020-04-26 | Pawnee | Oklahoma | 40117 | 29 | 2 |
88822 | 88822 | 2020-04-25 | Pawnee | Oklahoma | 40117 | 28 | 2 |
86008 | 86008 | 2020-04-24 | Pawnee | Oklahoma | 40117 | 28 | 2 |
83204 | 83204 | 2020-04-23 | Pawnee | Oklahoma | 40117 | 28 | 2 |
80405 | 80405 | 2020-04-22 | Pawnee | Oklahoma | 40117 | 28 | 2 |
77615 | 77615 | 2020-04-21 | Pawnee | Oklahoma | 40117 | 28 | 2 |
74833 | 74833 | 2020-04-20 | Pawnee | Oklahoma | 40117 | 28 | 2 |
72058 | 72058 | 2020-04-19 | Pawnee | Oklahoma | 40117 | 28 | 2 |
69291 | 69291 | 2020-04-18 | Pawnee | Oklahoma | 40117 | 28 | 2 |
66533 | 66533 | 2020-04-17 | Pawnee | Oklahoma | 40117 | 28 | 2 |
63788 | 63788 | 2020-04-16 | Pawnee | Oklahoma | 40117 | 28 | 2 |
61062 | 61062 | 2020-04-15 | Pawnee | Oklahoma | 40117 | 27 | 2 |
58347 | 58347 | 2020-04-14 | Pawnee | Oklahoma | 40117 | 27 | 2 |
55645 | 55645 | 2020-04-13 | Pawnee | Oklahoma | 40117 | 27 | 2 |
52960 | 52960 | 2020-04-12 | Pawnee | Oklahoma | 40117 | 26 | 2 |
50287 | 50287 | 2020-04-11 | Pawnee | Oklahoma | 40117 | 26 | 2 |
47631 | 47631 | 2020-04-10 | Pawnee | Oklahoma | 40117 | 26 | 2 |
45014 | 45014 | 2020-04-09 | Pawnee | Oklahoma | 40117 | 24 | 1 |
42428 | 42428 | 2020-04-08 | Pawnee | Oklahoma | 40117 | 23 | 1 |
39868 | 39868 | 2020-04-07 | Pawnee | Oklahoma | 40117 | 23 | 1 |
37347 | 37347 | 2020-04-06 | Pawnee | Oklahoma | 40117 | 22 | 1 |
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);