ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 40101 and state = "Oklahoma" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
7939 | 7939 | 2020-03-22 | Muskogee | Oklahoma | 40101 | 1 | 0 |
9147 | 9147 | 2020-03-23 | Muskogee | Oklahoma | 40101 | 1 | 0 |
10464 | 10464 | 2020-03-24 | Muskogee | Oklahoma | 40101 | 1 | 0 |
11922 | 11922 | 2020-03-25 | Muskogee | Oklahoma | 40101 | 1 | 0 |
13535 | 13535 | 2020-03-26 | Muskogee | Oklahoma | 40101 | 4 | 0 |
15278 | 15278 | 2020-03-27 | Muskogee | Oklahoma | 40101 | 5 | 0 |
17124 | 17124 | 2020-03-28 | Muskogee | Oklahoma | 40101 | 7 | 0 |
19059 | 19059 | 2020-03-29 | Muskogee | Oklahoma | 40101 | 7 | 0 |
21109 | 21109 | 2020-03-30 | Muskogee | Oklahoma | 40101 | 7 | 0 |
23242 | 23242 | 2020-03-31 | Muskogee | Oklahoma | 40101 | 8 | 1 |
25439 | 25439 | 2020-04-01 | Muskogee | Oklahoma | 40101 | 13 | 1 |
27711 | 27711 | 2020-04-02 | Muskogee | Oklahoma | 40101 | 15 | 2 |
30043 | 30043 | 2020-04-03 | Muskogee | Oklahoma | 40101 | 16 | 2 |
32432 | 32432 | 2020-04-04 | Muskogee | Oklahoma | 40101 | 17 | 2 |
34866 | 34866 | 2020-04-05 | Muskogee | Oklahoma | 40101 | 20 | 2 |
37340 | 37340 | 2020-04-06 | Muskogee | Oklahoma | 40101 | 20 | 2 |
39861 | 39861 | 2020-04-07 | Muskogee | Oklahoma | 40101 | 21 | 2 |
42421 | 42421 | 2020-04-08 | Muskogee | Oklahoma | 40101 | 21 | 2 |
45007 | 45007 | 2020-04-09 | Muskogee | Oklahoma | 40101 | 21 | 2 |
47623 | 47623 | 2020-04-10 | Muskogee | Oklahoma | 40101 | 21 | 2 |
50279 | 50279 | 2020-04-11 | Muskogee | Oklahoma | 40101 | 21 | 2 |
52952 | 52952 | 2020-04-12 | Muskogee | Oklahoma | 40101 | 21 | 2 |
55637 | 55637 | 2020-04-13 | Muskogee | Oklahoma | 40101 | 22 | 2 |
58339 | 58339 | 2020-04-14 | Muskogee | Oklahoma | 40101 | 25 | 2 |
61054 | 61054 | 2020-04-15 | Muskogee | Oklahoma | 40101 | 26 | 2 |
63780 | 63780 | 2020-04-16 | Muskogee | Oklahoma | 40101 | 25 | 3 |
66525 | 66525 | 2020-04-17 | Muskogee | Oklahoma | 40101 | 25 | 3 |
69283 | 69283 | 2020-04-18 | Muskogee | Oklahoma | 40101 | 26 | 3 |
72050 | 72050 | 2020-04-19 | Muskogee | Oklahoma | 40101 | 26 | 3 |
74825 | 74825 | 2020-04-20 | Muskogee | Oklahoma | 40101 | 26 | 3 |
77607 | 77607 | 2020-04-21 | Muskogee | Oklahoma | 40101 | 26 | 3 |
80397 | 80397 | 2020-04-22 | Muskogee | Oklahoma | 40101 | 26 | 3 |
83196 | 83196 | 2020-04-23 | Muskogee | Oklahoma | 40101 | 26 | 4 |
86000 | 86000 | 2020-04-24 | Muskogee | Oklahoma | 40101 | 26 | 4 |
88814 | 88814 | 2020-04-25 | Muskogee | Oklahoma | 40101 | 26 | 4 |
91630 | 91630 | 2020-04-26 | Muskogee | Oklahoma | 40101 | 26 | 4 |
94456 | 94456 | 2020-04-27 | Muskogee | Oklahoma | 40101 | 26 | 4 |
97294 | 97294 | 2020-04-28 | Muskogee | Oklahoma | 40101 | 26 | 4 |
100143 | 100143 | 2020-04-29 | Muskogee | Oklahoma | 40101 | 26 | 5 |
102996 | 102996 | 2020-04-30 | Muskogee | Oklahoma | 40101 | 27 | 5 |
105859 | 105859 | 2020-05-01 | Muskogee | Oklahoma | 40101 | 27 | 5 |
108726 | 108726 | 2020-05-02 | Muskogee | Oklahoma | 40101 | 27 | 6 |
111600 | 111600 | 2020-05-03 | Muskogee | Oklahoma | 40101 | 27 | 6 |
114482 | 114482 | 2020-05-04 | Muskogee | Oklahoma | 40101 | 27 | 6 |
117363 | 117363 | 2020-05-05 | Muskogee | Oklahoma | 40101 | 27 | 6 |
120324 | 120324 | 2020-05-06 | Muskogee | Oklahoma | 40101 | 27 | 6 |
123301 | 123301 | 2020-05-07 | Muskogee | Oklahoma | 40101 | 28 | 6 |
126284 | 126284 | 2020-05-08 | Muskogee | Oklahoma | 40101 | 28 | 6 |
129273 | 129273 | 2020-05-09 | Muskogee | Oklahoma | 40101 | 29 | 6 |
132262 | 132262 | 2020-05-10 | Muskogee | Oklahoma | 40101 | 29 | 6 |
135253 | 135253 | 2020-05-11 | Muskogee | Oklahoma | 40101 | 29 | 6 |
138243 | 138243 | 2020-05-12 | Muskogee | Oklahoma | 40101 | 29 | 6 |
141239 | 141239 | 2020-05-13 | Muskogee | Oklahoma | 40101 | 29 | 6 |
144234 | 144234 | 2020-05-14 | Muskogee | Oklahoma | 40101 | 30 | 6 |
147235 | 147235 | 2020-05-15 | Muskogee | Oklahoma | 40101 | 29 | 6 |
150242 | 150242 | 2020-05-16 | Muskogee | Oklahoma | 40101 | 29 | 6 |
153253 | 153253 | 2020-05-17 | Muskogee | Oklahoma | 40101 | 30 | 6 |
156270 | 156270 | 2020-05-18 | Muskogee | Oklahoma | 40101 | 30 | 6 |
159291 | 159291 | 2020-05-19 | Muskogee | Oklahoma | 40101 | 30 | 6 |
162318 | 162318 | 2020-05-20 | Muskogee | Oklahoma | 40101 | 30 | 6 |
165347 | 165347 | 2020-05-21 | Muskogee | Oklahoma | 40101 | 32 | 6 |
168383 | 168383 | 2020-05-22 | Muskogee | Oklahoma | 40101 | 34 | 6 |
171422 | 171422 | 2020-05-23 | Muskogee | Oklahoma | 40101 | 35 | 6 |
174464 | 174464 | 2020-05-24 | Muskogee | Oklahoma | 40101 | 35 | 6 |
177508 | 177508 | 2020-05-25 | Muskogee | Oklahoma | 40101 | 35 | 6 |
180551 | 180551 | 2020-05-26 | Muskogee | Oklahoma | 40101 | 36 | 6 |
183600 | 183600 | 2020-05-27 | Muskogee | Oklahoma | 40101 | 39 | 6 |
186657 | 186657 | 2020-05-28 | Muskogee | Oklahoma | 40101 | 43 | 6 |
189718 | 189718 | 2020-05-29 | Muskogee | Oklahoma | 40101 | 46 | 6 |
192783 | 192783 | 2020-05-30 | Muskogee | Oklahoma | 40101 | 48 | 6 |
195852 | 195852 | 2020-05-31 | Muskogee | Oklahoma | 40101 | 48 | 6 |
198925 | 198925 | 2020-06-01 | Muskogee | Oklahoma | 40101 | 48 | 6 |
202000 | 202000 | 2020-06-02 | Muskogee | Oklahoma | 40101 | 49 | 6 |
205077 | 205077 | 2020-06-03 | Muskogee | Oklahoma | 40101 | 60 | 6 |
208158 | 208158 | 2020-06-04 | Muskogee | Oklahoma | 40101 | 60 | 6 |
211240 | 211240 | 2020-06-05 | Muskogee | Oklahoma | 40101 | 61 | 6 |
214326 | 214326 | 2020-06-06 | Muskogee | Oklahoma | 40101 | 61 | 6 |
217416 | 217416 | 2020-06-07 | Muskogee | Oklahoma | 40101 | 62 | 6 |
220508 | 220508 | 2020-06-08 | Muskogee | Oklahoma | 40101 | 64 | 6 |
223603 | 223603 | 2020-06-09 | Muskogee | Oklahoma | 40101 | 67 | 7 |
226703 | 226703 | 2020-06-10 | Muskogee | Oklahoma | 40101 | 67 | 7 |
229807 | 229807 | 2020-06-11 | Muskogee | Oklahoma | 40101 | 69 | 7 |
232912 | 232912 | 2020-06-12 | Muskogee | Oklahoma | 40101 | 70 | 8 |
236017 | 236017 | 2020-06-13 | Muskogee | Oklahoma | 40101 | 74 | 8 |
239125 | 239125 | 2020-06-14 | Muskogee | Oklahoma | 40101 | 77 | 8 |
242234 | 242234 | 2020-06-15 | Muskogee | Oklahoma | 40101 | 79 | 8 |
245346 | 245346 | 2020-06-16 | Muskogee | Oklahoma | 40101 | 77 | 8 |
248459 | 248459 | 2020-06-17 | Muskogee | Oklahoma | 40101 | 77 | 8 |
251574 | 251574 | 2020-06-18 | Muskogee | Oklahoma | 40101 | 80 | 8 |
254689 | 254689 | 2020-06-19 | Muskogee | Oklahoma | 40101 | 88 | 9 |
257815 | 257815 | 2020-06-20 | Muskogee | Oklahoma | 40101 | 92 | 9 |
260942 | 260942 | 2020-06-21 | Muskogee | Oklahoma | 40101 | 94 | 9 |
264070 | 264070 | 2020-06-22 | Muskogee | Oklahoma | 40101 | 97 | 9 |
267198 | 267198 | 2020-06-23 | Muskogee | Oklahoma | 40101 | 100 | 9 |
270332 | 270332 | 2020-06-24 | Muskogee | Oklahoma | 40101 | 102 | 9 |
273471 | 273471 | 2020-06-25 | Muskogee | Oklahoma | 40101 | 102 | 9 |
276618 | 276618 | 2020-06-26 | Muskogee | Oklahoma | 40101 | 103 | 9 |
279766 | 279766 | 2020-06-27 | Muskogee | Oklahoma | 40101 | 105 | 11 |
282912 | 282912 | 2020-06-28 | Muskogee | Oklahoma | 40101 | 106 | 11 |
286057 | 286057 | 2020-06-29 | Muskogee | Oklahoma | 40101 | 106 | 11 |
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);