ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 40117 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3606 | 3606 | 2020-03-17 | Pawnee | Oklahoma | 40117 | 1 | 0 |
4221 | 4221 | 2020-03-18 | Pawnee | Oklahoma | 40117 | 1 | 0 |
4959 | 4959 | 2020-03-19 | Pawnee | Oklahoma | 40117 | 1 | 0 |
5826 | 5826 | 2020-03-20 | Pawnee | Oklahoma | 40117 | 1 | 0 |
6827 | 6827 | 2020-03-21 | Pawnee | Oklahoma | 40117 | 2 | 0 |
7942 | 7942 | 2020-03-22 | Pawnee | Oklahoma | 40117 | 3 | 1 |
9150 | 9150 | 2020-03-23 | Pawnee | Oklahoma | 40117 | 3 | 1 |
10467 | 10467 | 2020-03-24 | Pawnee | Oklahoma | 40117 | 4 | 1 |
11926 | 11926 | 2020-03-25 | Pawnee | Oklahoma | 40117 | 7 | 1 |
13541 | 13541 | 2020-03-26 | Pawnee | Oklahoma | 40117 | 10 | 1 |
15284 | 15284 | 2020-03-27 | Pawnee | Oklahoma | 40117 | 14 | 1 |
17131 | 17131 | 2020-03-28 | Pawnee | Oklahoma | 40117 | 14 | 1 |
19066 | 19066 | 2020-03-29 | Pawnee | Oklahoma | 40117 | 15 | 1 |
21116 | 21116 | 2020-03-30 | Pawnee | Oklahoma | 40117 | 15 | 1 |
23249 | 23249 | 2020-03-31 | Pawnee | Oklahoma | 40117 | 15 | 1 |
25446 | 25446 | 2020-04-01 | Pawnee | Oklahoma | 40117 | 15 | 1 |
27718 | 27718 | 2020-04-02 | Pawnee | Oklahoma | 40117 | 15 | 1 |
30050 | 30050 | 2020-04-03 | Pawnee | Oklahoma | 40117 | 16 | 1 |
32439 | 32439 | 2020-04-04 | Pawnee | Oklahoma | 40117 | 16 | 1 |
34873 | 34873 | 2020-04-05 | Pawnee | Oklahoma | 40117 | 22 | 1 |
37347 | 37347 | 2020-04-06 | Pawnee | Oklahoma | 40117 | 22 | 1 |
39868 | 39868 | 2020-04-07 | Pawnee | Oklahoma | 40117 | 23 | 1 |
42428 | 42428 | 2020-04-08 | Pawnee | Oklahoma | 40117 | 23 | 1 |
45014 | 45014 | 2020-04-09 | Pawnee | Oklahoma | 40117 | 24 | 1 |
47631 | 47631 | 2020-04-10 | Pawnee | Oklahoma | 40117 | 26 | 2 |
50287 | 50287 | 2020-04-11 | Pawnee | Oklahoma | 40117 | 26 | 2 |
52960 | 52960 | 2020-04-12 | Pawnee | Oklahoma | 40117 | 26 | 2 |
55645 | 55645 | 2020-04-13 | Pawnee | Oklahoma | 40117 | 27 | 2 |
58347 | 58347 | 2020-04-14 | Pawnee | Oklahoma | 40117 | 27 | 2 |
61062 | 61062 | 2020-04-15 | Pawnee | Oklahoma | 40117 | 27 | 2 |
63788 | 63788 | 2020-04-16 | Pawnee | Oklahoma | 40117 | 28 | 2 |
66533 | 66533 | 2020-04-17 | Pawnee | Oklahoma | 40117 | 28 | 2 |
69291 | 69291 | 2020-04-18 | Pawnee | Oklahoma | 40117 | 28 | 2 |
72058 | 72058 | 2020-04-19 | Pawnee | Oklahoma | 40117 | 28 | 2 |
74833 | 74833 | 2020-04-20 | Pawnee | Oklahoma | 40117 | 28 | 2 |
77615 | 77615 | 2020-04-21 | Pawnee | Oklahoma | 40117 | 28 | 2 |
80405 | 80405 | 2020-04-22 | Pawnee | Oklahoma | 40117 | 28 | 2 |
83204 | 83204 | 2020-04-23 | Pawnee | Oklahoma | 40117 | 28 | 2 |
86008 | 86008 | 2020-04-24 | Pawnee | Oklahoma | 40117 | 28 | 2 |
88822 | 88822 | 2020-04-25 | Pawnee | Oklahoma | 40117 | 28 | 2 |
91638 | 91638 | 2020-04-26 | Pawnee | Oklahoma | 40117 | 29 | 2 |
94464 | 94464 | 2020-04-27 | Pawnee | Oklahoma | 40117 | 29 | 2 |
97302 | 97302 | 2020-04-28 | Pawnee | Oklahoma | 40117 | 29 | 2 |
100151 | 100151 | 2020-04-29 | Pawnee | Oklahoma | 40117 | 29 | 2 |
103004 | 103004 | 2020-04-30 | Pawnee | Oklahoma | 40117 | 29 | 2 |
105867 | 105867 | 2020-05-01 | Pawnee | Oklahoma | 40117 | 29 | 2 |
108734 | 108734 | 2020-05-02 | Pawnee | Oklahoma | 40117 | 29 | 2 |
111608 | 111608 | 2020-05-03 | Pawnee | Oklahoma | 40117 | 29 | 2 |
114490 | 114490 | 2020-05-04 | Pawnee | Oklahoma | 40117 | 29 | 2 |
117371 | 117371 | 2020-05-05 | Pawnee | Oklahoma | 40117 | 29 | 2 |
120332 | 120332 | 2020-05-06 | Pawnee | Oklahoma | 40117 | 29 | 2 |
123309 | 123309 | 2020-05-07 | Pawnee | Oklahoma | 40117 | 29 | 2 |
126292 | 126292 | 2020-05-08 | Pawnee | Oklahoma | 40117 | 29 | 2 |
129281 | 129281 | 2020-05-09 | Pawnee | Oklahoma | 40117 | 29 | 2 |
132270 | 132270 | 2020-05-10 | Pawnee | Oklahoma | 40117 | 29 | 2 |
135261 | 135261 | 2020-05-11 | Pawnee | Oklahoma | 40117 | 29 | 2 |
138251 | 138251 | 2020-05-12 | Pawnee | Oklahoma | 40117 | 29 | 2 |
141247 | 141247 | 2020-05-13 | Pawnee | Oklahoma | 40117 | 29 | 2 |
144242 | 144242 | 2020-05-14 | Pawnee | Oklahoma | 40117 | 29 | 2 |
147243 | 147243 | 2020-05-15 | Pawnee | Oklahoma | 40117 | 29 | 2 |
150250 | 150250 | 2020-05-16 | Pawnee | Oklahoma | 40117 | 29 | 2 |
153261 | 153261 | 2020-05-17 | Pawnee | Oklahoma | 40117 | 29 | 2 |
156278 | 156278 | 2020-05-18 | Pawnee | Oklahoma | 40117 | 29 | 2 |
159299 | 159299 | 2020-05-19 | Pawnee | Oklahoma | 40117 | 29 | 2 |
162326 | 162326 | 2020-05-20 | Pawnee | Oklahoma | 40117 | 29 | 2 |
165355 | 165355 | 2020-05-21 | Pawnee | Oklahoma | 40117 | 29 | 2 |
168391 | 168391 | 2020-05-22 | Pawnee | Oklahoma | 40117 | 29 | 2 |
171430 | 171430 | 2020-05-23 | Pawnee | Oklahoma | 40117 | 29 | 2 |
174472 | 174472 | 2020-05-24 | Pawnee | Oklahoma | 40117 | 29 | 2 |
177516 | 177516 | 2020-05-25 | Pawnee | Oklahoma | 40117 | 29 | 2 |
180559 | 180559 | 2020-05-26 | Pawnee | Oklahoma | 40117 | 29 | 2 |
183608 | 183608 | 2020-05-27 | Pawnee | Oklahoma | 40117 | 30 | 2 |
186665 | 186665 | 2020-05-28 | Pawnee | Oklahoma | 40117 | 30 | 2 |
189726 | 189726 | 2020-05-29 | Pawnee | Oklahoma | 40117 | 30 | 2 |
192791 | 192791 | 2020-05-30 | Pawnee | Oklahoma | 40117 | 31 | 2 |
195860 | 195860 | 2020-05-31 | Pawnee | Oklahoma | 40117 | 31 | 2 |
198933 | 198933 | 2020-06-01 | Pawnee | Oklahoma | 40117 | 31 | 2 |
202008 | 202008 | 2020-06-02 | Pawnee | Oklahoma | 40117 | 31 | 2 |
205085 | 205085 | 2020-06-03 | Pawnee | Oklahoma | 40117 | 31 | 2 |
208166 | 208166 | 2020-06-04 | Pawnee | Oklahoma | 40117 | 32 | 2 |
211248 | 211248 | 2020-06-05 | Pawnee | Oklahoma | 40117 | 32 | 2 |
214334 | 214334 | 2020-06-06 | Pawnee | Oklahoma | 40117 | 33 | 2 |
217424 | 217424 | 2020-06-07 | Pawnee | Oklahoma | 40117 | 34 | 2 |
220516 | 220516 | 2020-06-08 | Pawnee | Oklahoma | 40117 | 34 | 2 |
223611 | 223611 | 2020-06-09 | Pawnee | Oklahoma | 40117 | 34 | 2 |
226711 | 226711 | 2020-06-10 | Pawnee | Oklahoma | 40117 | 35 | 2 |
229815 | 229815 | 2020-06-11 | Pawnee | Oklahoma | 40117 | 35 | 2 |
232920 | 232920 | 2020-06-12 | Pawnee | Oklahoma | 40117 | 36 | 2 |
236025 | 236025 | 2020-06-13 | Pawnee | Oklahoma | 40117 | 41 | 2 |
239133 | 239133 | 2020-06-14 | Pawnee | Oklahoma | 40117 | 41 | 2 |
242242 | 242242 | 2020-06-15 | Pawnee | Oklahoma | 40117 | 41 | 2 |
245354 | 245354 | 2020-06-16 | Pawnee | Oklahoma | 40117 | 41 | 2 |
248467 | 248467 | 2020-06-17 | Pawnee | Oklahoma | 40117 | 41 | 2 |
251582 | 251582 | 2020-06-18 | Pawnee | Oklahoma | 40117 | 41 | 2 |
254697 | 254697 | 2020-06-19 | Pawnee | Oklahoma | 40117 | 46 | 2 |
257823 | 257823 | 2020-06-20 | Pawnee | Oklahoma | 40117 | 47 | 2 |
260950 | 260950 | 2020-06-21 | Pawnee | Oklahoma | 40117 | 48 | 2 |
264078 | 264078 | 2020-06-22 | Pawnee | Oklahoma | 40117 | 50 | 2 |
267206 | 267206 | 2020-06-23 | Pawnee | Oklahoma | 40117 | 51 | 2 |
270340 | 270340 | 2020-06-24 | Pawnee | Oklahoma | 40117 | 51 | 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);