ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40137 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 |
---|---|---|---|---|---|---|---|
11930 | 11930 | 2020-03-25 | Stephens | Oklahoma | 40137 | 1 | 0 |
13546 | 13546 | 2020-03-26 | Stephens | Oklahoma | 40137 | 1 | 0 |
15290 | 15290 | 2020-03-27 | Stephens | Oklahoma | 40137 | 1 | 0 |
17137 | 17137 | 2020-03-28 | Stephens | Oklahoma | 40137 | 2 | 0 |
19074 | 19074 | 2020-03-29 | Stephens | Oklahoma | 40137 | 2 | 0 |
21124 | 21124 | 2020-03-30 | Stephens | Oklahoma | 40137 | 2 | 0 |
23257 | 23257 | 2020-03-31 | Stephens | Oklahoma | 40137 | 5 | 0 |
25454 | 25454 | 2020-04-01 | Stephens | Oklahoma | 40137 | 6 | 0 |
27726 | 27726 | 2020-04-02 | Stephens | Oklahoma | 40137 | 7 | 1 |
30058 | 30058 | 2020-04-03 | Stephens | Oklahoma | 40137 | 8 | 1 |
32447 | 32447 | 2020-04-04 | Stephens | Oklahoma | 40137 | 9 | 1 |
34881 | 34881 | 2020-04-05 | Stephens | Oklahoma | 40137 | 9 | 1 |
37355 | 37355 | 2020-04-06 | Stephens | Oklahoma | 40137 | 11 | 1 |
39876 | 39876 | 2020-04-07 | Stephens | Oklahoma | 40137 | 11 | 1 |
42436 | 42436 | 2020-04-08 | Stephens | Oklahoma | 40137 | 11 | 1 |
45022 | 45022 | 2020-04-09 | Stephens | Oklahoma | 40137 | 13 | 1 |
47639 | 47639 | 2020-04-10 | Stephens | Oklahoma | 40137 | 13 | 1 |
50295 | 50295 | 2020-04-11 | Stephens | Oklahoma | 40137 | 13 | 1 |
52968 | 52968 | 2020-04-12 | Stephens | Oklahoma | 40137 | 14 | 1 |
55653 | 55653 | 2020-04-13 | Stephens | Oklahoma | 40137 | 15 | 1 |
58355 | 58355 | 2020-04-14 | Stephens | Oklahoma | 40137 | 15 | 1 |
61070 | 61070 | 2020-04-15 | Stephens | Oklahoma | 40137 | 15 | 1 |
63796 | 63796 | 2020-04-16 | Stephens | Oklahoma | 40137 | 15 | 1 |
66541 | 66541 | 2020-04-17 | Stephens | Oklahoma | 40137 | 15 | 1 |
69299 | 69299 | 2020-04-18 | Stephens | Oklahoma | 40137 | 15 | 1 |
72066 | 72066 | 2020-04-19 | Stephens | Oklahoma | 40137 | 15 | 1 |
74841 | 74841 | 2020-04-20 | Stephens | Oklahoma | 40137 | 19 | 1 |
77623 | 77623 | 2020-04-21 | Stephens | Oklahoma | 40137 | 19 | 1 |
80413 | 80413 | 2020-04-22 | Stephens | Oklahoma | 40137 | 19 | 1 |
83212 | 83212 | 2020-04-23 | Stephens | Oklahoma | 40137 | 19 | 1 |
86016 | 86016 | 2020-04-24 | Stephens | Oklahoma | 40137 | 19 | 1 |
88830 | 88830 | 2020-04-25 | Stephens | Oklahoma | 40137 | 20 | 1 |
91646 | 91646 | 2020-04-26 | Stephens | Oklahoma | 40137 | 20 | 1 |
94473 | 94473 | 2020-04-27 | Stephens | Oklahoma | 40137 | 20 | 1 |
97311 | 97311 | 2020-04-28 | Stephens | Oklahoma | 40137 | 22 | 1 |
100160 | 100160 | 2020-04-29 | Stephens | Oklahoma | 40137 | 22 | 1 |
103013 | 103013 | 2020-04-30 | Stephens | Oklahoma | 40137 | 22 | 1 |
105876 | 105876 | 2020-05-01 | Stephens | Oklahoma | 40137 | 22 | 1 |
108743 | 108743 | 2020-05-02 | Stephens | Oklahoma | 40137 | 22 | 1 |
111617 | 111617 | 2020-05-03 | Stephens | Oklahoma | 40137 | 22 | 1 |
114499 | 114499 | 2020-05-04 | Stephens | Oklahoma | 40137 | 22 | 1 |
117380 | 117380 | 2020-05-05 | Stephens | Oklahoma | 40137 | 22 | 1 |
120341 | 120341 | 2020-05-06 | Stephens | Oklahoma | 40137 | 22 | 1 |
123318 | 123318 | 2020-05-07 | Stephens | Oklahoma | 40137 | 22 | 1 |
126301 | 126301 | 2020-05-08 | Stephens | Oklahoma | 40137 | 22 | 1 |
129290 | 129290 | 2020-05-09 | Stephens | Oklahoma | 40137 | 22 | 1 |
132279 | 132279 | 2020-05-10 | Stephens | Oklahoma | 40137 | 22 | 1 |
135270 | 135270 | 2020-05-11 | Stephens | Oklahoma | 40137 | 22 | 1 |
138260 | 138260 | 2020-05-12 | Stephens | Oklahoma | 40137 | 22 | 1 |
141256 | 141256 | 2020-05-13 | Stephens | Oklahoma | 40137 | 22 | 1 |
144251 | 144251 | 2020-05-14 | Stephens | Oklahoma | 40137 | 22 | 1 |
147252 | 147252 | 2020-05-15 | Stephens | Oklahoma | 40137 | 23 | 1 |
150259 | 150259 | 2020-05-16 | Stephens | Oklahoma | 40137 | 24 | 1 |
153270 | 153270 | 2020-05-17 | Stephens | Oklahoma | 40137 | 24 | 1 |
156287 | 156287 | 2020-05-18 | Stephens | Oklahoma | 40137 | 26 | 1 |
159308 | 159308 | 2020-05-19 | Stephens | Oklahoma | 40137 | 25 | 1 |
162335 | 162335 | 2020-05-20 | Stephens | Oklahoma | 40137 | 25 | 1 |
165364 | 165364 | 2020-05-21 | Stephens | Oklahoma | 40137 | 36 | 1 |
168400 | 168400 | 2020-05-22 | Stephens | Oklahoma | 40137 | 37 | 1 |
171439 | 171439 | 2020-05-23 | Stephens | Oklahoma | 40137 | 37 | 1 |
174481 | 174481 | 2020-05-24 | Stephens | Oklahoma | 40137 | 37 | 1 |
177525 | 177525 | 2020-05-25 | Stephens | Oklahoma | 40137 | 37 | 1 |
180568 | 180568 | 2020-05-26 | Stephens | Oklahoma | 40137 | 37 | 1 |
183617 | 183617 | 2020-05-27 | Stephens | Oklahoma | 40137 | 37 | 1 |
186674 | 186674 | 2020-05-28 | Stephens | Oklahoma | 40137 | 37 | 1 |
189735 | 189735 | 2020-05-29 | Stephens | Oklahoma | 40137 | 37 | 1 |
192800 | 192800 | 2020-05-30 | Stephens | Oklahoma | 40137 | 38 | 1 |
195869 | 195869 | 2020-05-31 | Stephens | Oklahoma | 40137 | 38 | 1 |
198942 | 198942 | 2020-06-01 | Stephens | Oklahoma | 40137 | 38 | 1 |
202017 | 202017 | 2020-06-02 | Stephens | Oklahoma | 40137 | 38 | 1 |
205094 | 205094 | 2020-06-03 | Stephens | Oklahoma | 40137 | 40 | 1 |
208175 | 208175 | 2020-06-04 | Stephens | Oklahoma | 40137 | 41 | 1 |
211257 | 211257 | 2020-06-05 | Stephens | Oklahoma | 40137 | 41 | 1 |
214343 | 214343 | 2020-06-06 | Stephens | Oklahoma | 40137 | 41 | 1 |
217433 | 217433 | 2020-06-07 | Stephens | Oklahoma | 40137 | 44 | 1 |
220525 | 220525 | 2020-06-08 | Stephens | Oklahoma | 40137 | 44 | 1 |
223620 | 223620 | 2020-06-09 | Stephens | Oklahoma | 40137 | 43 | 1 |
226720 | 226720 | 2020-06-10 | Stephens | Oklahoma | 40137 | 43 | 1 |
229824 | 229824 | 2020-06-11 | Stephens | Oklahoma | 40137 | 44 | 1 |
232929 | 232929 | 2020-06-12 | Stephens | Oklahoma | 40137 | 44 | 1 |
236034 | 236034 | 2020-06-13 | Stephens | Oklahoma | 40137 | 44 | 1 |
239142 | 239142 | 2020-06-14 | Stephens | Oklahoma | 40137 | 45 | 1 |
242251 | 242251 | 2020-06-15 | Stephens | Oklahoma | 40137 | 45 | 1 |
245363 | 245363 | 2020-06-16 | Stephens | Oklahoma | 40137 | 47 | 1 |
248476 | 248476 | 2020-06-17 | Stephens | Oklahoma | 40137 | 48 | 1 |
251591 | 251591 | 2020-06-18 | Stephens | Oklahoma | 40137 | 48 | 1 |
254706 | 254706 | 2020-06-19 | Stephens | Oklahoma | 40137 | 48 | 1 |
257832 | 257832 | 2020-06-20 | Stephens | Oklahoma | 40137 | 49 | 1 |
260959 | 260959 | 2020-06-21 | Stephens | Oklahoma | 40137 | 49 | 1 |
264087 | 264087 | 2020-06-22 | Stephens | Oklahoma | 40137 | 49 | 1 |
267215 | 267215 | 2020-06-23 | Stephens | Oklahoma | 40137 | 49 | 1 |
270349 | 270349 | 2020-06-24 | Stephens | Oklahoma | 40137 | 50 | 1 |
273488 | 273488 | 2020-06-25 | Stephens | Oklahoma | 40137 | 52 | 1 |
276635 | 276635 | 2020-06-26 | Stephens | Oklahoma | 40137 | 55 | 1 |
279783 | 279783 | 2020-06-27 | Stephens | Oklahoma | 40137 | 55 | 1 |
282929 | 282929 | 2020-06-28 | Stephens | Oklahoma | 40137 | 55 | 1 |
286074 | 286074 | 2020-06-29 | Stephens | Oklahoma | 40137 | 55 | 1 |
289224 | 289224 | 2020-06-30 | Stephens | Oklahoma | 40137 | 63 | 1 |
292377 | 292377 | 2020-07-01 | Stephens | Oklahoma | 40137 | 63 | 1 |
295533 | 295533 | 2020-07-02 | Stephens | Oklahoma | 40137 | 62 | 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);