ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where county = "Lawrence", deaths = 0 and fips = 39087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
433100 | 433100 | 2020-08-14 | Lawrence | Ohio | 39087 | 334 | 0 |
429874 | 429874 | 2020-08-13 | Lawrence | Ohio | 39087 | 323 | 0 |
426649 | 426649 | 2020-08-12 | Lawrence | Ohio | 39087 | 318 | 0 |
423426 | 423426 | 2020-08-11 | Lawrence | Ohio | 39087 | 300 | 0 |
420203 | 420203 | 2020-08-10 | Lawrence | Ohio | 39087 | 288 | 0 |
416983 | 416983 | 2020-08-09 | Lawrence | Ohio | 39087 | 283 | 0 |
413762 | 413762 | 2020-08-08 | Lawrence | Ohio | 39087 | 279 | 0 |
410542 | 410542 | 2020-08-07 | Lawrence | Ohio | 39087 | 267 | 0 |
407322 | 407322 | 2020-08-06 | Lawrence | Ohio | 39087 | 242 | 0 |
404103 | 404103 | 2020-08-05 | Lawrence | Ohio | 39087 | 234 | 0 |
400885 | 400885 | 2020-08-04 | Lawrence | Ohio | 39087 | 225 | 0 |
397670 | 397670 | 2020-08-03 | Lawrence | Ohio | 39087 | 220 | 0 |
394453 | 394453 | 2020-08-02 | Lawrence | Ohio | 39087 | 216 | 0 |
391237 | 391237 | 2020-08-01 | Lawrence | Ohio | 39087 | 211 | 0 |
388020 | 388020 | 2020-07-31 | Lawrence | Ohio | 39087 | 206 | 0 |
384803 | 384803 | 2020-07-30 | Lawrence | Ohio | 39087 | 199 | 0 |
381585 | 381585 | 2020-07-29 | Lawrence | Ohio | 39087 | 198 | 0 |
378368 | 378368 | 2020-07-28 | Lawrence | Ohio | 39087 | 191 | 0 |
375151 | 375151 | 2020-07-27 | Lawrence | Ohio | 39087 | 186 | 0 |
371939 | 371939 | 2020-07-26 | Lawrence | Ohio | 39087 | 182 | 0 |
368727 | 368727 | 2020-07-25 | Lawrence | Ohio | 39087 | 175 | 0 |
365518 | 365518 | 2020-07-24 | Lawrence | Ohio | 39087 | 170 | 0 |
362312 | 362312 | 2020-07-23 | Lawrence | Ohio | 39087 | 164 | 0 |
359106 | 359106 | 2020-07-22 | Lawrence | Ohio | 39087 | 162 | 0 |
355902 | 355902 | 2020-07-21 | Lawrence | Ohio | 39087 | 152 | 0 |
352699 | 352699 | 2020-07-20 | Lawrence | Ohio | 39087 | 146 | 0 |
349496 | 349496 | 2020-07-19 | Lawrence | Ohio | 39087 | 138 | 0 |
346295 | 346295 | 2020-07-18 | Lawrence | Ohio | 39087 | 136 | 0 |
343096 | 343096 | 2020-07-17 | Lawrence | Ohio | 39087 | 115 | 0 |
339898 | 339898 | 2020-07-16 | Lawrence | Ohio | 39087 | 103 | 0 |
336702 | 336702 | 2020-07-15 | Lawrence | Ohio | 39087 | 97 | 0 |
333508 | 333508 | 2020-07-14 | Lawrence | Ohio | 39087 | 93 | 0 |
330316 | 330316 | 2020-07-13 | Lawrence | Ohio | 39087 | 92 | 0 |
327129 | 327129 | 2020-07-12 | Lawrence | Ohio | 39087 | 86 | 0 |
323944 | 323944 | 2020-07-11 | Lawrence | Ohio | 39087 | 83 | 0 |
320764 | 320764 | 2020-07-10 | Lawrence | Ohio | 39087 | 82 | 0 |
317587 | 317587 | 2020-07-09 | Lawrence | Ohio | 39087 | 79 | 0 |
314414 | 314414 | 2020-07-08 | Lawrence | Ohio | 39087 | 74 | 0 |
311242 | 311242 | 2020-07-07 | Lawrence | Ohio | 39087 | 72 | 0 |
308073 | 308073 | 2020-07-06 | Lawrence | Ohio | 39087 | 71 | 0 |
304906 | 304906 | 2020-07-05 | Lawrence | Ohio | 39087 | 70 | 0 |
301743 | 301743 | 2020-07-04 | Lawrence | Ohio | 39087 | 68 | 0 |
298580 | 298580 | 2020-07-03 | Lawrence | Ohio | 39087 | 67 | 0 |
295420 | 295420 | 2020-07-02 | Lawrence | Ohio | 39087 | 65 | 0 |
292265 | 292265 | 2020-07-01 | Lawrence | Ohio | 39087 | 65 | 0 |
289113 | 289113 | 2020-06-30 | Lawrence | Ohio | 39087 | 63 | 0 |
285963 | 285963 | 2020-06-29 | Lawrence | Ohio | 39087 | 60 | 0 |
282818 | 282818 | 2020-06-28 | Lawrence | Ohio | 39087 | 59 | 0 |
279672 | 279672 | 2020-06-27 | Lawrence | Ohio | 39087 | 57 | 0 |
276524 | 276524 | 2020-06-26 | Lawrence | Ohio | 39087 | 55 | 0 |
273377 | 273377 | 2020-06-25 | Lawrence | Ohio | 39087 | 55 | 0 |
270238 | 270238 | 2020-06-24 | Lawrence | Ohio | 39087 | 52 | 0 |
267104 | 267104 | 2020-06-23 | Lawrence | Ohio | 39087 | 48 | 0 |
263976 | 263976 | 2020-06-22 | Lawrence | Ohio | 39087 | 45 | 0 |
260848 | 260848 | 2020-06-21 | Lawrence | Ohio | 39087 | 44 | 0 |
257721 | 257721 | 2020-06-20 | Lawrence | Ohio | 39087 | 42 | 0 |
254596 | 254596 | 2020-06-19 | Lawrence | Ohio | 39087 | 42 | 0 |
251481 | 251481 | 2020-06-18 | Lawrence | Ohio | 39087 | 40 | 0 |
248366 | 248366 | 2020-06-17 | Lawrence | Ohio | 39087 | 37 | 0 |
245253 | 245253 | 2020-06-16 | Lawrence | Ohio | 39087 | 35 | 0 |
242141 | 242141 | 2020-06-15 | Lawrence | Ohio | 39087 | 34 | 0 |
239032 | 239032 | 2020-06-14 | Lawrence | Ohio | 39087 | 32 | 0 |
235924 | 235924 | 2020-06-13 | Lawrence | Ohio | 39087 | 32 | 0 |
232819 | 232819 | 2020-06-12 | Lawrence | Ohio | 39087 | 32 | 0 |
229714 | 229714 | 2020-06-11 | Lawrence | Ohio | 39087 | 32 | 0 |
226610 | 226610 | 2020-06-10 | Lawrence | Ohio | 39087 | 30 | 0 |
223510 | 223510 | 2020-06-09 | Lawrence | Ohio | 39087 | 30 | 0 |
220415 | 220415 | 2020-06-08 | Lawrence | Ohio | 39087 | 30 | 0 |
217323 | 217323 | 2020-06-07 | Lawrence | Ohio | 39087 | 30 | 0 |
214233 | 214233 | 2020-06-06 | Lawrence | Ohio | 39087 | 30 | 0 |
211147 | 211147 | 2020-06-05 | Lawrence | Ohio | 39087 | 30 | 0 |
204984 | 204984 | 2020-06-03 | Lawrence | Ohio | 39087 | 30 | 0 |
201907 | 201907 | 2020-06-02 | Lawrence | Ohio | 39087 | 30 | 0 |
198832 | 198832 | 2020-06-01 | Lawrence | Ohio | 39087 | 30 | 0 |
195759 | 195759 | 2020-05-31 | Lawrence | Ohio | 39087 | 30 | 0 |
192689 | 192689 | 2020-05-30 | Lawrence | Ohio | 39087 | 30 | 0 |
189625 | 189625 | 2020-05-29 | Lawrence | Ohio | 39087 | 30 | 0 |
186565 | 186565 | 2020-05-28 | Lawrence | Ohio | 39087 | 29 | 0 |
183508 | 183508 | 2020-05-27 | Lawrence | Ohio | 39087 | 28 | 0 |
180459 | 180459 | 2020-05-26 | Lawrence | Ohio | 39087 | 28 | 0 |
177416 | 177416 | 2020-05-25 | Lawrence | Ohio | 39087 | 28 | 0 |
174372 | 174372 | 2020-05-24 | Lawrence | Ohio | 39087 | 28 | 0 |
171330 | 171330 | 2020-05-23 | Lawrence | Ohio | 39087 | 28 | 0 |
168291 | 168291 | 2020-05-22 | Lawrence | Ohio | 39087 | 28 | 0 |
165255 | 165255 | 2020-05-21 | Lawrence | Ohio | 39087 | 27 | 0 |
159199 | 159199 | 2020-05-19 | Lawrence | Ohio | 39087 | 27 | 0 |
156179 | 156179 | 2020-05-18 | Lawrence | Ohio | 39087 | 27 | 0 |
153162 | 153162 | 2020-05-17 | Lawrence | Ohio | 39087 | 27 | 0 |
150151 | 150151 | 2020-05-16 | Lawrence | Ohio | 39087 | 27 | 0 |
147144 | 147144 | 2020-05-15 | Lawrence | Ohio | 39087 | 27 | 0 |
144143 | 144143 | 2020-05-14 | Lawrence | Ohio | 39087 | 27 | 0 |
141148 | 141148 | 2020-05-13 | Lawrence | Ohio | 39087 | 26 | 0 |
138152 | 138152 | 2020-05-12 | Lawrence | Ohio | 39087 | 25 | 0 |
135162 | 135162 | 2020-05-11 | Lawrence | Ohio | 39087 | 25 | 0 |
132171 | 132171 | 2020-05-10 | Lawrence | Ohio | 39087 | 25 | 0 |
129182 | 129182 | 2020-05-09 | Lawrence | Ohio | 39087 | 24 | 0 |
126193 | 126193 | 2020-05-08 | Lawrence | Ohio | 39087 | 24 | 0 |
123210 | 123210 | 2020-05-07 | Lawrence | Ohio | 39087 | 24 | 0 |
120233 | 120233 | 2020-05-06 | Lawrence | Ohio | 39087 | 24 | 0 |
117272 | 117272 | 2020-05-05 | Lawrence | Ohio | 39087 | 24 | 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);