ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Johnston" and fips = 40069 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
58324 | 58324 | 2020-04-14 | Johnston | Oklahoma | 40069 | 2 | 0 |
61039 | 61039 | 2020-04-15 | Johnston | Oklahoma | 40069 | 2 | 0 |
63765 | 63765 | 2020-04-16 | Johnston | Oklahoma | 40069 | 2 | 0 |
66509 | 66509 | 2020-04-17 | Johnston | Oklahoma | 40069 | 3 | 0 |
69267 | 69267 | 2020-04-18 | Johnston | Oklahoma | 40069 | 3 | 0 |
72034 | 72034 | 2020-04-19 | Johnston | Oklahoma | 40069 | 3 | 0 |
74809 | 74809 | 2020-04-20 | Johnston | Oklahoma | 40069 | 3 | 0 |
77591 | 77591 | 2020-04-21 | Johnston | Oklahoma | 40069 | 3 | 0 |
80381 | 80381 | 2020-04-22 | Johnston | Oklahoma | 40069 | 3 | 0 |
83180 | 83180 | 2020-04-23 | Johnston | Oklahoma | 40069 | 3 | 0 |
85984 | 85984 | 2020-04-24 | Johnston | Oklahoma | 40069 | 3 | 0 |
88798 | 88798 | 2020-04-25 | Johnston | Oklahoma | 40069 | 4 | 0 |
91614 | 91614 | 2020-04-26 | Johnston | Oklahoma | 40069 | 3 | 0 |
94440 | 94440 | 2020-04-27 | Johnston | Oklahoma | 40069 | 3 | 0 |
97278 | 97278 | 2020-04-28 | Johnston | Oklahoma | 40069 | 3 | 0 |
100127 | 100127 | 2020-04-29 | Johnston | Oklahoma | 40069 | 3 | 0 |
102980 | 102980 | 2020-04-30 | Johnston | Oklahoma | 40069 | 3 | 0 |
105843 | 105843 | 2020-05-01 | Johnston | Oklahoma | 40069 | 3 | 0 |
108710 | 108710 | 2020-05-02 | Johnston | Oklahoma | 40069 | 3 | 0 |
111584 | 111584 | 2020-05-03 | Johnston | Oklahoma | 40069 | 3 | 0 |
114466 | 114466 | 2020-05-04 | Johnston | Oklahoma | 40069 | 3 | 0 |
117347 | 117347 | 2020-05-05 | Johnston | Oklahoma | 40069 | 3 | 0 |
120308 | 120308 | 2020-05-06 | Johnston | Oklahoma | 40069 | 3 | 0 |
123285 | 123285 | 2020-05-07 | Johnston | Oklahoma | 40069 | 3 | 0 |
126268 | 126268 | 2020-05-08 | Johnston | Oklahoma | 40069 | 3 | 0 |
129257 | 129257 | 2020-05-09 | Johnston | Oklahoma | 40069 | 3 | 0 |
132246 | 132246 | 2020-05-10 | Johnston | Oklahoma | 40069 | 3 | 0 |
135237 | 135237 | 2020-05-11 | Johnston | Oklahoma | 40069 | 3 | 0 |
138227 | 138227 | 2020-05-12 | Johnston | Oklahoma | 40069 | 3 | 0 |
141223 | 141223 | 2020-05-13 | Johnston | Oklahoma | 40069 | 3 | 0 |
144218 | 144218 | 2020-05-14 | Johnston | Oklahoma | 40069 | 3 | 0 |
147219 | 147219 | 2020-05-15 | Johnston | Oklahoma | 40069 | 3 | 0 |
150226 | 150226 | 2020-05-16 | Johnston | Oklahoma | 40069 | 3 | 0 |
153237 | 153237 | 2020-05-17 | Johnston | Oklahoma | 40069 | 3 | 0 |
156254 | 156254 | 2020-05-18 | Johnston | Oklahoma | 40069 | 3 | 0 |
159275 | 159275 | 2020-05-19 | Johnston | Oklahoma | 40069 | 3 | 0 |
162302 | 162302 | 2020-05-20 | Johnston | Oklahoma | 40069 | 3 | 0 |
165331 | 165331 | 2020-05-21 | Johnston | Oklahoma | 40069 | 3 | 0 |
168367 | 168367 | 2020-05-22 | Johnston | Oklahoma | 40069 | 3 | 0 |
171406 | 171406 | 2020-05-23 | Johnston | Oklahoma | 40069 | 3 | 0 |
174448 | 174448 | 2020-05-24 | Johnston | Oklahoma | 40069 | 3 | 0 |
177492 | 177492 | 2020-05-25 | Johnston | Oklahoma | 40069 | 3 | 0 |
180535 | 180535 | 2020-05-26 | Johnston | Oklahoma | 40069 | 3 | 0 |
183584 | 183584 | 2020-05-27 | Johnston | Oklahoma | 40069 | 3 | 0 |
186641 | 186641 | 2020-05-28 | Johnston | Oklahoma | 40069 | 3 | 0 |
189702 | 189702 | 2020-05-29 | Johnston | Oklahoma | 40069 | 3 | 0 |
192767 | 192767 | 2020-05-30 | Johnston | Oklahoma | 40069 | 3 | 0 |
195836 | 195836 | 2020-05-31 | Johnston | Oklahoma | 40069 | 3 | 0 |
198909 | 198909 | 2020-06-01 | Johnston | Oklahoma | 40069 | 3 | 0 |
201984 | 201984 | 2020-06-02 | Johnston | Oklahoma | 40069 | 3 | 0 |
205061 | 205061 | 2020-06-03 | Johnston | Oklahoma | 40069 | 3 | 0 |
208142 | 208142 | 2020-06-04 | Johnston | Oklahoma | 40069 | 3 | 0 |
211224 | 211224 | 2020-06-05 | Johnston | Oklahoma | 40069 | 3 | 0 |
214310 | 214310 | 2020-06-06 | Johnston | Oklahoma | 40069 | 3 | 0 |
217400 | 217400 | 2020-06-07 | Johnston | Oklahoma | 40069 | 3 | 0 |
220492 | 220492 | 2020-06-08 | Johnston | Oklahoma | 40069 | 3 | 0 |
223587 | 223587 | 2020-06-09 | Johnston | Oklahoma | 40069 | 3 | 0 |
226687 | 226687 | 2020-06-10 | Johnston | Oklahoma | 40069 | 3 | 0 |
229791 | 229791 | 2020-06-11 | Johnston | Oklahoma | 40069 | 4 | 0 |
232896 | 232896 | 2020-06-12 | Johnston | Oklahoma | 40069 | 4 | 0 |
236001 | 236001 | 2020-06-13 | Johnston | Oklahoma | 40069 | 4 | 0 |
239109 | 239109 | 2020-06-14 | Johnston | Oklahoma | 40069 | 5 | 0 |
242218 | 242218 | 2020-06-15 | Johnston | Oklahoma | 40069 | 5 | 0 |
245330 | 245330 | 2020-06-16 | Johnston | Oklahoma | 40069 | 5 | 0 |
248443 | 248443 | 2020-06-17 | Johnston | Oklahoma | 40069 | 6 | 0 |
251558 | 251558 | 2020-06-18 | Johnston | Oklahoma | 40069 | 8 | 0 |
254673 | 254673 | 2020-06-19 | Johnston | Oklahoma | 40069 | 8 | 0 |
257799 | 257799 | 2020-06-20 | Johnston | Oklahoma | 40069 | 8 | 0 |
260926 | 260926 | 2020-06-21 | Johnston | Oklahoma | 40069 | 8 | 0 |
264054 | 264054 | 2020-06-22 | Johnston | Oklahoma | 40069 | 9 | 0 |
267182 | 267182 | 2020-06-23 | Johnston | Oklahoma | 40069 | 10 | 0 |
270316 | 270316 | 2020-06-24 | Johnston | Oklahoma | 40069 | 10 | 0 |
273455 | 273455 | 2020-06-25 | Johnston | Oklahoma | 40069 | 10 | 0 |
276602 | 276602 | 2020-06-26 | Johnston | Oklahoma | 40069 | 10 | 0 |
279750 | 279750 | 2020-06-27 | Johnston | Oklahoma | 40069 | 10 | 0 |
282896 | 282896 | 2020-06-28 | Johnston | Oklahoma | 40069 | 10 | 0 |
286041 | 286041 | 2020-06-29 | Johnston | Oklahoma | 40069 | 12 | 0 |
289191 | 289191 | 2020-06-30 | Johnston | Oklahoma | 40069 | 12 | 0 |
292344 | 292344 | 2020-07-01 | Johnston | Oklahoma | 40069 | 13 | 0 |
295500 | 295500 | 2020-07-02 | Johnston | Oklahoma | 40069 | 13 | 0 |
298659 | 298659 | 2020-07-03 | Johnston | Oklahoma | 40069 | 13 | 0 |
301822 | 301822 | 2020-07-04 | Johnston | Oklahoma | 40069 | 13 | 0 |
304985 | 304985 | 2020-07-05 | Johnston | Oklahoma | 40069 | 13 | 0 |
308152 | 308152 | 2020-07-06 | Johnston | Oklahoma | 40069 | 13 | 0 |
311321 | 311321 | 2020-07-07 | Johnston | Oklahoma | 40069 | 13 | 0 |
314493 | 314493 | 2020-07-08 | Johnston | Oklahoma | 40069 | 15 | 0 |
317666 | 317666 | 2020-07-09 | Johnston | Oklahoma | 40069 | 15 | 0 |
320843 | 320843 | 2020-07-10 | Johnston | Oklahoma | 40069 | 15 | 0 |
324023 | 324023 | 2020-07-11 | Johnston | Oklahoma | 40069 | 16 | 0 |
327208 | 327208 | 2020-07-12 | Johnston | Oklahoma | 40069 | 16 | 0 |
330395 | 330395 | 2020-07-13 | Johnston | Oklahoma | 40069 | 17 | 0 |
333587 | 333587 | 2020-07-14 | Johnston | Oklahoma | 40069 | 18 | 0 |
336781 | 336781 | 2020-07-15 | Johnston | Oklahoma | 40069 | 21 | 0 |
339977 | 339977 | 2020-07-16 | Johnston | Oklahoma | 40069 | 23 | 0 |
343175 | 343175 | 2020-07-17 | Johnston | Oklahoma | 40069 | 23 | 0 |
346375 | 346375 | 2020-07-18 | Johnston | Oklahoma | 40069 | 23 | 0 |
349575 | 349575 | 2020-07-19 | Johnston | Oklahoma | 40069 | 23 | 0 |
352778 | 352778 | 2020-07-20 | Johnston | Oklahoma | 40069 | 23 | 0 |
355981 | 355981 | 2020-07-21 | Johnston | Oklahoma | 40069 | 23 | 0 |
359185 | 359185 | 2020-07-22 | Johnston | Oklahoma | 40069 | 25 | 0 |
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);