ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Kay" and state = "Oklahoma" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2613 | 2613 | 2020-03-15 | Kay | Oklahoma | 40071 | 1 | 0 |
3077 | 3077 | 2020-03-16 | Kay | Oklahoma | 40071 | 1 | 0 |
3604 | 3604 | 2020-03-17 | Kay | Oklahoma | 40071 | 2 | 0 |
4219 | 4219 | 2020-03-18 | Kay | Oklahoma | 40071 | 2 | 0 |
4955 | 4955 | 2020-03-19 | Kay | Oklahoma | 40071 | 2 | 0 |
5822 | 5822 | 2020-03-20 | Kay | Oklahoma | 40071 | 3 | 0 |
6823 | 6823 | 2020-03-21 | Kay | Oklahoma | 40071 | 3 | 0 |
7936 | 7936 | 2020-03-22 | Kay | Oklahoma | 40071 | 4 | 0 |
9144 | 9144 | 2020-03-23 | Kay | Oklahoma | 40071 | 5 | 0 |
10460 | 10460 | 2020-03-24 | Kay | Oklahoma | 40071 | 5 | 0 |
11918 | 11918 | 2020-03-25 | Kay | Oklahoma | 40071 | 5 | 0 |
13530 | 13530 | 2020-03-26 | Kay | Oklahoma | 40071 | 11 | 0 |
15272 | 15272 | 2020-03-27 | Kay | Oklahoma | 40071 | 17 | 0 |
17117 | 17117 | 2020-03-28 | Kay | Oklahoma | 40071 | 18 | 0 |
19052 | 19052 | 2020-03-29 | Kay | Oklahoma | 40071 | 20 | 0 |
21101 | 21101 | 2020-03-30 | Kay | Oklahoma | 40071 | 20 | 0 |
23234 | 23234 | 2020-03-31 | Kay | Oklahoma | 40071 | 24 | 0 |
25431 | 25431 | 2020-04-01 | Kay | Oklahoma | 40071 | 24 | 1 |
27701 | 27701 | 2020-04-02 | Kay | Oklahoma | 40071 | 24 | 1 |
30031 | 30031 | 2020-04-03 | Kay | Oklahoma | 40071 | 25 | 1 |
32420 | 32420 | 2020-04-04 | Kay | Oklahoma | 40071 | 29 | 1 |
34854 | 34854 | 2020-04-05 | Kay | Oklahoma | 40071 | 30 | 1 |
37328 | 37328 | 2020-04-06 | Kay | Oklahoma | 40071 | 30 | 1 |
39848 | 39848 | 2020-04-07 | Kay | Oklahoma | 40071 | 33 | 2 |
42408 | 42408 | 2020-04-08 | Kay | Oklahoma | 40071 | 33 | 3 |
44994 | 44994 | 2020-04-09 | Kay | Oklahoma | 40071 | 36 | 3 |
47609 | 47609 | 2020-04-10 | Kay | Oklahoma | 40071 | 41 | 3 |
50265 | 50265 | 2020-04-11 | Kay | Oklahoma | 40071 | 42 | 3 |
52938 | 52938 | 2020-04-12 | Kay | Oklahoma | 40071 | 43 | 3 |
55623 | 55623 | 2020-04-13 | Kay | Oklahoma | 40071 | 45 | 3 |
58325 | 58325 | 2020-04-14 | Kay | Oklahoma | 40071 | 45 | 4 |
61040 | 61040 | 2020-04-15 | Kay | Oklahoma | 40071 | 45 | 4 |
63766 | 63766 | 2020-04-16 | Kay | Oklahoma | 40071 | 46 | 4 |
66510 | 66510 | 2020-04-17 | Kay | Oklahoma | 40071 | 46 | 4 |
69268 | 69268 | 2020-04-18 | Kay | Oklahoma | 40071 | 46 | 4 |
72035 | 72035 | 2020-04-19 | Kay | Oklahoma | 40071 | 46 | 4 |
74810 | 74810 | 2020-04-20 | Kay | Oklahoma | 40071 | 46 | 4 |
77592 | 77592 | 2020-04-21 | Kay | Oklahoma | 40071 | 46 | 6 |
80382 | 80382 | 2020-04-22 | Kay | Oklahoma | 40071 | 46 | 6 |
83181 | 83181 | 2020-04-23 | Kay | Oklahoma | 40071 | 47 | 6 |
85985 | 85985 | 2020-04-24 | Kay | Oklahoma | 40071 | 47 | 6 |
88799 | 88799 | 2020-04-25 | Kay | Oklahoma | 40071 | 47 | 6 |
91615 | 91615 | 2020-04-26 | Kay | Oklahoma | 40071 | 47 | 6 |
94441 | 94441 | 2020-04-27 | Kay | Oklahoma | 40071 | 47 | 6 |
97279 | 97279 | 2020-04-28 | Kay | Oklahoma | 40071 | 47 | 6 |
100128 | 100128 | 2020-04-29 | Kay | Oklahoma | 40071 | 47 | 7 |
102981 | 102981 | 2020-04-30 | Kay | Oklahoma | 40071 | 47 | 7 |
105844 | 105844 | 2020-05-01 | Kay | Oklahoma | 40071 | 47 | 7 |
108711 | 108711 | 2020-05-02 | Kay | Oklahoma | 40071 | 47 | 7 |
111585 | 111585 | 2020-05-03 | Kay | Oklahoma | 40071 | 47 | 7 |
114467 | 114467 | 2020-05-04 | Kay | Oklahoma | 40071 | 47 | 7 |
117348 | 117348 | 2020-05-05 | Kay | Oklahoma | 40071 | 48 | 7 |
120309 | 120309 | 2020-05-06 | Kay | Oklahoma | 40071 | 48 | 7 |
123286 | 123286 | 2020-05-07 | Kay | Oklahoma | 40071 | 48 | 7 |
126269 | 126269 | 2020-05-08 | Kay | Oklahoma | 40071 | 48 | 7 |
129258 | 129258 | 2020-05-09 | Kay | Oklahoma | 40071 | 48 | 7 |
132247 | 132247 | 2020-05-10 | Kay | Oklahoma | 40071 | 48 | 7 |
135238 | 135238 | 2020-05-11 | Kay | Oklahoma | 40071 | 48 | 7 |
138228 | 138228 | 2020-05-12 | Kay | Oklahoma | 40071 | 48 | 7 |
141224 | 141224 | 2020-05-13 | Kay | Oklahoma | 40071 | 49 | 7 |
144219 | 144219 | 2020-05-14 | Kay | Oklahoma | 40071 | 49 | 7 |
147220 | 147220 | 2020-05-15 | Kay | Oklahoma | 40071 | 49 | 7 |
150227 | 150227 | 2020-05-16 | Kay | Oklahoma | 40071 | 49 | 7 |
153238 | 153238 | 2020-05-17 | Kay | Oklahoma | 40071 | 49 | 7 |
156255 | 156255 | 2020-05-18 | Kay | Oklahoma | 40071 | 50 | 7 |
159276 | 159276 | 2020-05-19 | Kay | Oklahoma | 40071 | 50 | 7 |
162303 | 162303 | 2020-05-20 | Kay | Oklahoma | 40071 | 50 | 7 |
165332 | 165332 | 2020-05-21 | Kay | Oklahoma | 40071 | 51 | 7 |
168368 | 168368 | 2020-05-22 | Kay | Oklahoma | 40071 | 51 | 7 |
171407 | 171407 | 2020-05-23 | Kay | Oklahoma | 40071 | 52 | 7 |
174449 | 174449 | 2020-05-24 | Kay | Oklahoma | 40071 | 52 | 7 |
177493 | 177493 | 2020-05-25 | Kay | Oklahoma | 40071 | 52 | 7 |
180536 | 180536 | 2020-05-26 | Kay | Oklahoma | 40071 | 52 | 7 |
183585 | 183585 | 2020-05-27 | Kay | Oklahoma | 40071 | 52 | 7 |
186642 | 186642 | 2020-05-28 | Kay | Oklahoma | 40071 | 52 | 7 |
189703 | 189703 | 2020-05-29 | Kay | Oklahoma | 40071 | 52 | 7 |
192768 | 192768 | 2020-05-30 | Kay | Oklahoma | 40071 | 53 | 7 |
195837 | 195837 | 2020-05-31 | Kay | Oklahoma | 40071 | 53 | 7 |
198910 | 198910 | 2020-06-01 | Kay | Oklahoma | 40071 | 54 | 7 |
201985 | 201985 | 2020-06-02 | Kay | Oklahoma | 40071 | 56 | 7 |
205062 | 205062 | 2020-06-03 | Kay | Oklahoma | 40071 | 57 | 7 |
208143 | 208143 | 2020-06-04 | Kay | Oklahoma | 40071 | 57 | 7 |
211225 | 211225 | 2020-06-05 | Kay | Oklahoma | 40071 | 57 | 7 |
214311 | 214311 | 2020-06-06 | Kay | Oklahoma | 40071 | 59 | 7 |
217401 | 217401 | 2020-06-07 | Kay | Oklahoma | 40071 | 59 | 7 |
220493 | 220493 | 2020-06-08 | Kay | Oklahoma | 40071 | 59 | 7 |
223588 | 223588 | 2020-06-09 | Kay | Oklahoma | 40071 | 60 | 7 |
226688 | 226688 | 2020-06-10 | Kay | Oklahoma | 40071 | 60 | 7 |
229792 | 229792 | 2020-06-11 | Kay | Oklahoma | 40071 | 64 | 7 |
232897 | 232897 | 2020-06-12 | Kay | Oklahoma | 40071 | 65 | 7 |
236002 | 236002 | 2020-06-13 | Kay | Oklahoma | 40071 | 65 | 7 |
239110 | 239110 | 2020-06-14 | Kay | Oklahoma | 40071 | 65 | 7 |
242219 | 242219 | 2020-06-15 | Kay | Oklahoma | 40071 | 65 | 7 |
245331 | 245331 | 2020-06-16 | Kay | Oklahoma | 40071 | 69 | 7 |
248444 | 248444 | 2020-06-17 | Kay | Oklahoma | 40071 | 70 | 7 |
251559 | 251559 | 2020-06-18 | Kay | Oklahoma | 40071 | 72 | 7 |
254674 | 254674 | 2020-06-19 | Kay | Oklahoma | 40071 | 77 | 7 |
257800 | 257800 | 2020-06-20 | Kay | Oklahoma | 40071 | 79 | 7 |
260927 | 260927 | 2020-06-21 | Kay | Oklahoma | 40071 | 80 | 7 |
264055 | 264055 | 2020-06-22 | Kay | Oklahoma | 40071 | 80 | 7 |
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);