ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where county = "Lawrence" and deaths = 6 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-06-03 1
- 2020-07-03 1
- 2020-07-04 1
- 2020-07-05 1
- 2020-07-06 1
- 2020-07-07 1
- 2020-07-08 1
- 2020-07-09 1
- 2020-07-10 1
- 2020-07-11 1
- 2020-07-12 1
- 2020-07-13 1
- …
state 7
- Tennessee 39
- Pennsylvania 14
- Illinois 13
- South Dakota 12
- Ohio 6
- Indiana 4
- Arkansas 1
county 1
- Lawrence · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
692537 | 692537 | 2020-11-02 | Lawrence | South Dakota | 46081 | 1070 | 6 |
689293 | 689293 | 2020-11-01 | Lawrence | South Dakota | 46081 | 1061 | 6 |
686048 | 686048 | 2020-10-31 | Lawrence | South Dakota | 46081 | 1021 | 6 |
682805 | 682805 | 2020-10-30 | Lawrence | South Dakota | 46081 | 982 | 6 |
679562 | 679562 | 2020-10-29 | Lawrence | South Dakota | 46081 | 925 | 6 |
676319 | 676319 | 2020-10-28 | Lawrence | South Dakota | 46081 | 896 | 6 |
673076 | 673076 | 2020-10-27 | Lawrence | South Dakota | 46081 | 849 | 6 |
669834 | 669834 | 2020-10-26 | Lawrence | South Dakota | 46081 | 848 | 6 |
666590 | 666590 | 2020-10-25 | Lawrence | South Dakota | 46081 | 836 | 6 |
663345 | 663345 | 2020-10-24 | Lawrence | South Dakota | 46081 | 814 | 6 |
660101 | 660101 | 2020-10-23 | Lawrence | South Dakota | 46081 | 772 | 6 |
656857 | 656857 | 2020-10-22 | Lawrence | South Dakota | 46081 | 746 | 6 |
629044 | 629044 | 2020-10-14 | Lawrence | Illinois | 17101 | 293 | 6 |
625801 | 625801 | 2020-10-13 | Lawrence | Illinois | 17101 | 288 | 6 |
622559 | 622559 | 2020-10-12 | Lawrence | Illinois | 17101 | 288 | 6 |
619315 | 619315 | 2020-10-11 | Lawrence | Illinois | 17101 | 288 | 6 |
616073 | 616073 | 2020-10-10 | Lawrence | Illinois | 17101 | 286 | 6 |
612832 | 612832 | 2020-10-09 | Lawrence | Illinois | 17101 | 282 | 6 |
609590 | 609590 | 2020-10-08 | Lawrence | Illinois | 17101 | 279 | 6 |
606347 | 606347 | 2020-10-07 | Lawrence | Illinois | 17101 | 277 | 6 |
603105 | 603105 | 2020-10-06 | Lawrence | Illinois | 17101 | 275 | 6 |
599862 | 599862 | 2020-10-05 | Lawrence | Illinois | 17101 | 275 | 6 |
596620 | 596620 | 2020-10-04 | Lawrence | Illinois | 17101 | 270 | 6 |
593378 | 593378 | 2020-10-03 | Lawrence | Illinois | 17101 | 269 | 6 |
590137 | 590137 | 2020-10-02 | Lawrence | Illinois | 17101 | 268 | 6 |
465373 | 465373 | 2020-08-24 | Lawrence | Ohio | 39087 | 395 | 6 |
462144 | 462144 | 2020-08-23 | Lawrence | Ohio | 39087 | 394 | 6 |
458916 | 458916 | 2020-08-22 | Lawrence | Ohio | 39087 | 390 | 6 |
455688 | 455688 | 2020-08-21 | Lawrence | Ohio | 39087 | 387 | 6 |
452460 | 452460 | 2020-08-20 | Lawrence | Ohio | 39087 | 380 | 6 |
449232 | 449232 | 2020-08-19 | Lawrence | Ohio | 39087 | 367 | 6 |
420673 | 420673 | 2020-08-10 | Lawrence | Tennessee | 47099 | 575 | 6 |
417452 | 417452 | 2020-08-09 | Lawrence | Tennessee | 47099 | 562 | 6 |
414231 | 414231 | 2020-08-08 | Lawrence | Tennessee | 47099 | 550 | 6 |
411011 | 411011 | 2020-08-07 | Lawrence | Tennessee | 47099 | 534 | 6 |
407792 | 407792 | 2020-08-06 | Lawrence | Tennessee | 47099 | 527 | 6 |
404572 | 404572 | 2020-08-05 | Lawrence | Tennessee | 47099 | 497 | 6 |
401354 | 401354 | 2020-08-04 | Lawrence | Tennessee | 47099 | 491 | 6 |
398139 | 398139 | 2020-08-03 | Lawrence | Tennessee | 47099 | 478 | 6 |
394922 | 394922 | 2020-08-02 | Lawrence | Tennessee | 47099 | 474 | 6 |
391706 | 391706 | 2020-08-01 | Lawrence | Tennessee | 47099 | 458 | 6 |
388489 | 388489 | 2020-07-31 | Lawrence | Tennessee | 47099 | 444 | 6 |
385272 | 385272 | 2020-07-30 | Lawrence | Tennessee | 47099 | 421 | 6 |
382054 | 382054 | 2020-07-29 | Lawrence | Tennessee | 47099 | 408 | 6 |
378837 | 378837 | 2020-07-28 | Lawrence | Tennessee | 47099 | 404 | 6 |
375621 | 375621 | 2020-07-27 | Lawrence | Tennessee | 47099 | 388 | 6 |
372408 | 372408 | 2020-07-26 | Lawrence | Tennessee | 47099 | 375 | 6 |
369196 | 369196 | 2020-07-25 | Lawrence | Tennessee | 47099 | 353 | 6 |
365987 | 365987 | 2020-07-24 | Lawrence | Tennessee | 47099 | 342 | 6 |
362781 | 362781 | 2020-07-23 | Lawrence | Tennessee | 47099 | 332 | 6 |
359574 | 359574 | 2020-07-22 | Lawrence | Tennessee | 47099 | 324 | 6 |
356370 | 356370 | 2020-07-21 | Lawrence | Tennessee | 47099 | 321 | 6 |
353167 | 353167 | 2020-07-20 | Lawrence | Tennessee | 47099 | 302 | 6 |
349964 | 349964 | 2020-07-19 | Lawrence | Tennessee | 47099 | 296 | 6 |
346764 | 346764 | 2020-07-18 | Lawrence | Tennessee | 47099 | 288 | 6 |
343564 | 343564 | 2020-07-17 | Lawrence | Tennessee | 47099 | 280 | 6 |
340366 | 340366 | 2020-07-16 | Lawrence | Tennessee | 47099 | 272 | 6 |
337169 | 337169 | 2020-07-15 | Lawrence | Tennessee | 47099 | 262 | 6 |
333975 | 333975 | 2020-07-14 | Lawrence | Tennessee | 47099 | 259 | 6 |
330783 | 330783 | 2020-07-13 | Lawrence | Tennessee | 47099 | 250 | 6 |
327597 | 327597 | 2020-07-12 | Lawrence | Tennessee | 47099 | 239 | 6 |
324412 | 324412 | 2020-07-11 | Lawrence | Tennessee | 47099 | 232 | 6 |
321231 | 321231 | 2020-07-10 | Lawrence | Tennessee | 47099 | 227 | 6 |
318053 | 318053 | 2020-07-09 | Lawrence | Tennessee | 47099 | 202 | 6 |
314880 | 314880 | 2020-07-08 | Lawrence | Tennessee | 47099 | 192 | 6 |
311706 | 311706 | 2020-07-07 | Lawrence | Tennessee | 47099 | 172 | 6 |
308537 | 308537 | 2020-07-06 | Lawrence | Tennessee | 47099 | 164 | 6 |
305369 | 305369 | 2020-07-05 | Lawrence | Tennessee | 47099 | 163 | 6 |
302206 | 302206 | 2020-07-04 | Lawrence | Tennessee | 47099 | 157 | 6 |
299042 | 299042 | 2020-07-03 | Lawrence | Tennessee | 47099 | 152 | 6 |
203138 | 203138 | 2020-06-03 | Lawrence | Arkansas | 5075 | 85 | 6 |
114575 | 114575 | 2020-05-04 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
111693 | 111693 | 2020-05-03 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
108819 | 108819 | 2020-05-02 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
105952 | 105952 | 2020-05-01 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
103089 | 103089 | 2020-04-30 | Lawrence | Pennsylvania | 42073 | 65 | 6 |
100236 | 100236 | 2020-04-29 | Lawrence | Pennsylvania | 42073 | 64 | 6 |
97387 | 97387 | 2020-04-28 | Lawrence | Pennsylvania | 42073 | 63 | 6 |
94548 | 94548 | 2020-04-27 | Lawrence | Pennsylvania | 42073 | 63 | 6 |
91721 | 91721 | 2020-04-26 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
88905 | 88905 | 2020-04-25 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
86091 | 86091 | 2020-04-24 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
83287 | 83287 | 2020-04-23 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
80488 | 80488 | 2020-04-22 | Lawrence | Pennsylvania | 42073 | 61 | 6 |
77698 | 77698 | 2020-04-21 | Lawrence | Pennsylvania | 42073 | 60 | 6 |
38750 | 38750 | 2020-04-07 | Lawrence | Indiana | 18093 | 45 | 6 |
36252 | 36252 | 2020-04-06 | Lawrence | Indiana | 18093 | 40 | 6 |
33799 | 33799 | 2020-04-05 | Lawrence | Indiana | 18093 | 40 | 6 |
31388 | 31388 | 2020-04-04 | Lawrence | Indiana | 18093 | 37 | 6 |
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);