ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 40021 and state = "Oklahoma" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15261 | 15261 | 2020-03-27 | Cherokee | Oklahoma | 40021 | 1 | 0 |
17106 | 17106 | 2020-03-28 | Cherokee | Oklahoma | 40021 | 1 | 0 |
19040 | 19040 | 2020-03-29 | Cherokee | Oklahoma | 40021 | 1 | 0 |
21088 | 21088 | 2020-03-30 | Cherokee | Oklahoma | 40021 | 1 | 0 |
23221 | 23221 | 2020-03-31 | Cherokee | Oklahoma | 40021 | 4 | 0 |
25417 | 25417 | 2020-04-01 | Cherokee | Oklahoma | 40021 | 7 | 0 |
27687 | 27687 | 2020-04-02 | Cherokee | Oklahoma | 40021 | 7 | 0 |
30016 | 30016 | 2020-04-03 | Cherokee | Oklahoma | 40021 | 7 | 0 |
32405 | 32405 | 2020-04-04 | Cherokee | Oklahoma | 40021 | 10 | 0 |
34839 | 34839 | 2020-04-05 | Cherokee | Oklahoma | 40021 | 12 | 0 |
37312 | 37312 | 2020-04-06 | Cherokee | Oklahoma | 40021 | 14 | 0 |
39831 | 39831 | 2020-04-07 | Cherokee | Oklahoma | 40021 | 16 | 1 |
42391 | 42391 | 2020-04-08 | Cherokee | Oklahoma | 40021 | 16 | 1 |
44977 | 44977 | 2020-04-09 | Cherokee | Oklahoma | 40021 | 17 | 1 |
47592 | 47592 | 2020-04-10 | Cherokee | Oklahoma | 40021 | 18 | 1 |
50248 | 50248 | 2020-04-11 | Cherokee | Oklahoma | 40021 | 18 | 1 |
52921 | 52921 | 2020-04-12 | Cherokee | Oklahoma | 40021 | 18 | 1 |
55606 | 55606 | 2020-04-13 | Cherokee | Oklahoma | 40021 | 20 | 1 |
58307 | 58307 | 2020-04-14 | Cherokee | Oklahoma | 40021 | 20 | 1 |
61022 | 61022 | 2020-04-15 | Cherokee | Oklahoma | 40021 | 21 | 1 |
63748 | 63748 | 2020-04-16 | Cherokee | Oklahoma | 40021 | 22 | 1 |
66491 | 66491 | 2020-04-17 | Cherokee | Oklahoma | 40021 | 24 | 1 |
69248 | 69248 | 2020-04-18 | Cherokee | Oklahoma | 40021 | 24 | 1 |
72015 | 72015 | 2020-04-19 | Cherokee | Oklahoma | 40021 | 24 | 1 |
74790 | 74790 | 2020-04-20 | Cherokee | Oklahoma | 40021 | 24 | 1 |
77571 | 77571 | 2020-04-21 | Cherokee | Oklahoma | 40021 | 24 | 1 |
80361 | 80361 | 2020-04-22 | Cherokee | Oklahoma | 40021 | 25 | 1 |
83160 | 83160 | 2020-04-23 | Cherokee | Oklahoma | 40021 | 25 | 1 |
85964 | 85964 | 2020-04-24 | Cherokee | Oklahoma | 40021 | 26 | 1 |
88778 | 88778 | 2020-04-25 | Cherokee | Oklahoma | 40021 | 26 | 1 |
91594 | 91594 | 2020-04-26 | Cherokee | Oklahoma | 40021 | 26 | 1 |
94420 | 94420 | 2020-04-27 | Cherokee | Oklahoma | 40021 | 26 | 1 |
97258 | 97258 | 2020-04-28 | Cherokee | Oklahoma | 40021 | 26 | 1 |
100107 | 100107 | 2020-04-29 | Cherokee | Oklahoma | 40021 | 27 | 1 |
102960 | 102960 | 2020-04-30 | Cherokee | Oklahoma | 40021 | 27 | 1 |
105823 | 105823 | 2020-05-01 | Cherokee | Oklahoma | 40021 | 27 | 1 |
108690 | 108690 | 2020-05-02 | Cherokee | Oklahoma | 40021 | 27 | 1 |
111564 | 111564 | 2020-05-03 | Cherokee | Oklahoma | 40021 | 27 | 1 |
114446 | 114446 | 2020-05-04 | Cherokee | Oklahoma | 40021 | 27 | 1 |
117327 | 117327 | 2020-05-05 | Cherokee | Oklahoma | 40021 | 29 | 1 |
120288 | 120288 | 2020-05-06 | Cherokee | Oklahoma | 40021 | 29 | 1 |
123265 | 123265 | 2020-05-07 | Cherokee | Oklahoma | 40021 | 29 | 1 |
126248 | 126248 | 2020-05-08 | Cherokee | Oklahoma | 40021 | 30 | 1 |
129237 | 129237 | 2020-05-09 | Cherokee | Oklahoma | 40021 | 30 | 1 |
132226 | 132226 | 2020-05-10 | Cherokee | Oklahoma | 40021 | 30 | 1 |
135217 | 135217 | 2020-05-11 | Cherokee | Oklahoma | 40021 | 30 | 1 |
138207 | 138207 | 2020-05-12 | Cherokee | Oklahoma | 40021 | 30 | 1 |
141203 | 141203 | 2020-05-13 | Cherokee | Oklahoma | 40021 | 29 | 1 |
144198 | 144198 | 2020-05-14 | Cherokee | Oklahoma | 40021 | 29 | 1 |
147199 | 147199 | 2020-05-15 | Cherokee | Oklahoma | 40021 | 29 | 1 |
150206 | 150206 | 2020-05-16 | Cherokee | Oklahoma | 40021 | 29 | 1 |
153217 | 153217 | 2020-05-17 | Cherokee | Oklahoma | 40021 | 29 | 1 |
156234 | 156234 | 2020-05-18 | Cherokee | Oklahoma | 40021 | 29 | 1 |
159254 | 159254 | 2020-05-19 | Cherokee | Oklahoma | 40021 | 29 | 1 |
162281 | 162281 | 2020-05-20 | Cherokee | Oklahoma | 40021 | 29 | 1 |
165310 | 165310 | 2020-05-21 | Cherokee | Oklahoma | 40021 | 28 | 1 |
168346 | 168346 | 2020-05-22 | Cherokee | Oklahoma | 40021 | 28 | 1 |
171385 | 171385 | 2020-05-23 | Cherokee | Oklahoma | 40021 | 28 | 1 |
174427 | 174427 | 2020-05-24 | Cherokee | Oklahoma | 40021 | 28 | 1 |
177471 | 177471 | 2020-05-25 | Cherokee | Oklahoma | 40021 | 28 | 1 |
180514 | 180514 | 2020-05-26 | Cherokee | Oklahoma | 40021 | 29 | 1 |
183563 | 183563 | 2020-05-27 | Cherokee | Oklahoma | 40021 | 29 | 1 |
186620 | 186620 | 2020-05-28 | Cherokee | Oklahoma | 40021 | 28 | 1 |
189680 | 189680 | 2020-05-29 | Cherokee | Oklahoma | 40021 | 28 | 1 |
192745 | 192745 | 2020-05-30 | Cherokee | Oklahoma | 40021 | 29 | 1 |
195814 | 195814 | 2020-05-31 | Cherokee | Oklahoma | 40021 | 29 | 1 |
198887 | 198887 | 2020-06-01 | Cherokee | Oklahoma | 40021 | 29 | 1 |
201962 | 201962 | 2020-06-02 | Cherokee | Oklahoma | 40021 | 30 | 1 |
205039 | 205039 | 2020-06-03 | Cherokee | Oklahoma | 40021 | 31 | 1 |
208120 | 208120 | 2020-06-04 | Cherokee | Oklahoma | 40021 | 31 | 1 |
211202 | 211202 | 2020-06-05 | Cherokee | Oklahoma | 40021 | 31 | 1 |
214288 | 214288 | 2020-06-06 | Cherokee | Oklahoma | 40021 | 31 | 1 |
217378 | 217378 | 2020-06-07 | Cherokee | Oklahoma | 40021 | 33 | 1 |
220470 | 220470 | 2020-06-08 | Cherokee | Oklahoma | 40021 | 33 | 1 |
223565 | 223565 | 2020-06-09 | Cherokee | Oklahoma | 40021 | 37 | 1 |
226665 | 226665 | 2020-06-10 | Cherokee | Oklahoma | 40021 | 37 | 1 |
229769 | 229769 | 2020-06-11 | Cherokee | Oklahoma | 40021 | 39 | 1 |
232874 | 232874 | 2020-06-12 | Cherokee | Oklahoma | 40021 | 41 | 1 |
235979 | 235979 | 2020-06-13 | Cherokee | Oklahoma | 40021 | 43 | 1 |
239087 | 239087 | 2020-06-14 | Cherokee | Oklahoma | 40021 | 48 | 1 |
242196 | 242196 | 2020-06-15 | Cherokee | Oklahoma | 40021 | 48 | 1 |
245308 | 245308 | 2020-06-16 | Cherokee | Oklahoma | 40021 | 50 | 1 |
248421 | 248421 | 2020-06-17 | Cherokee | Oklahoma | 40021 | 52 | 1 |
251536 | 251536 | 2020-06-18 | Cherokee | Oklahoma | 40021 | 58 | 1 |
254651 | 254651 | 2020-06-19 | Cherokee | Oklahoma | 40021 | 60 | 1 |
257777 | 257777 | 2020-06-20 | Cherokee | Oklahoma | 40021 | 65 | 1 |
260903 | 260903 | 2020-06-21 | Cherokee | Oklahoma | 40021 | 66 | 1 |
264031 | 264031 | 2020-06-22 | Cherokee | Oklahoma | 40021 | 66 | 1 |
267159 | 267159 | 2020-06-23 | Cherokee | Oklahoma | 40021 | 66 | 1 |
270293 | 270293 | 2020-06-24 | Cherokee | Oklahoma | 40021 | 68 | 1 |
273432 | 273432 | 2020-06-25 | Cherokee | Oklahoma | 40021 | 70 | 1 |
276579 | 276579 | 2020-06-26 | Cherokee | Oklahoma | 40021 | 73 | 1 |
279727 | 279727 | 2020-06-27 | Cherokee | Oklahoma | 40021 | 74 | 1 |
282873 | 282873 | 2020-06-28 | Cherokee | Oklahoma | 40021 | 74 | 1 |
286018 | 286018 | 2020-06-29 | Cherokee | Oklahoma | 40021 | 73 | 1 |
289168 | 289168 | 2020-06-30 | Cherokee | Oklahoma | 40021 | 77 | 1 |
292320 | 292320 | 2020-07-01 | Cherokee | Oklahoma | 40021 | 79 | 1 |
295476 | 295476 | 2020-07-02 | Cherokee | Oklahoma | 40021 | 83 | 1 |
298635 | 298635 | 2020-07-03 | Cherokee | Oklahoma | 40021 | 87 | 1 |
301798 | 301798 | 2020-07-04 | Cherokee | Oklahoma | 40021 | 90 | 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);