ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where county = "Lawrence" and deaths = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 10
- Missouri 75
- Mississippi 16
- Illinois 13
- Pennsylvania 10
- Kentucky 9
- Tennessee 7
- South Dakota 3
- Alabama 2
- Arkansas 2
- Indiana 1
county 1
- Lawrence · 138 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
820893 | 820893 | 2020-12-12 | Lawrence | Kentucky | 21127 | 549 | 2 |
817647 | 817647 | 2020-12-11 | Lawrence | Kentucky | 21127 | 541 | 2 |
814401 | 814401 | 2020-12-10 | Lawrence | Kentucky | 21127 | 530 | 2 |
811156 | 811156 | 2020-12-09 | Lawrence | Kentucky | 21127 | 515 | 2 |
807911 | 807911 | 2020-12-08 | Lawrence | Kentucky | 21127 | 511 | 2 |
804666 | 804666 | 2020-12-07 | Lawrence | Kentucky | 21127 | 499 | 2 |
801421 | 801421 | 2020-12-06 | Lawrence | Kentucky | 21127 | 495 | 2 |
798176 | 798176 | 2020-12-05 | Lawrence | Kentucky | 21127 | 478 | 2 |
794931 | 794931 | 2020-12-04 | Lawrence | Kentucky | 21127 | 464 | 2 |
580417 | 580417 | 2020-09-29 | Lawrence | Illinois | 17101 | 259 | 2 |
577176 | 577176 | 2020-09-28 | Lawrence | Illinois | 17101 | 259 | 2 |
573934 | 573934 | 2020-09-27 | Lawrence | Illinois | 17101 | 256 | 2 |
570691 | 570691 | 2020-09-26 | Lawrence | Illinois | 17101 | 254 | 2 |
567449 | 567449 | 2020-09-25 | Lawrence | Illinois | 17101 | 252 | 2 |
568351 | 568351 | 2020-09-25 | Lawrence | Missouri | 29109 | 611 | 2 |
564209 | 564209 | 2020-09-24 | Lawrence | Illinois | 17101 | 252 | 2 |
565111 | 565111 | 2020-09-24 | Lawrence | Missouri | 29109 | 584 | 2 |
560969 | 560969 | 2020-09-23 | Lawrence | Illinois | 17101 | 251 | 2 |
561871 | 561871 | 2020-09-23 | Lawrence | Missouri | 29109 | 571 | 2 |
557733 | 557733 | 2020-09-22 | Lawrence | Illinois | 17101 | 250 | 2 |
558634 | 558634 | 2020-09-22 | Lawrence | Missouri | 29109 | 555 | 2 |
554496 | 554496 | 2020-09-21 | Lawrence | Illinois | 17101 | 249 | 2 |
555397 | 555397 | 2020-09-21 | Lawrence | Missouri | 29109 | 532 | 2 |
551257 | 551257 | 2020-09-20 | Lawrence | Illinois | 17101 | 245 | 2 |
552159 | 552159 | 2020-09-20 | Lawrence | Missouri | 29109 | 524 | 2 |
548018 | 548018 | 2020-09-19 | Lawrence | Illinois | 17101 | 242 | 2 |
548920 | 548920 | 2020-09-19 | Lawrence | Missouri | 29109 | 507 | 2 |
544780 | 544780 | 2020-09-18 | Lawrence | Illinois | 17101 | 242 | 2 |
545682 | 545682 | 2020-09-18 | Lawrence | Missouri | 29109 | 494 | 2 |
541544 | 541544 | 2020-09-17 | Lawrence | Illinois | 17101 | 239 | 2 |
542445 | 542445 | 2020-09-17 | Lawrence | Missouri | 29109 | 475 | 2 |
539209 | 539209 | 2020-09-16 | Lawrence | Missouri | 29109 | 462 | 2 |
535972 | 535972 | 2020-09-15 | Lawrence | Missouri | 29109 | 454 | 2 |
532737 | 532737 | 2020-09-14 | Lawrence | Missouri | 29109 | 448 | 2 |
529501 | 529501 | 2020-09-13 | Lawrence | Missouri | 29109 | 441 | 2 |
526265 | 526265 | 2020-09-12 | Lawrence | Missouri | 29109 | 434 | 2 |
523029 | 523029 | 2020-09-11 | Lawrence | Missouri | 29109 | 422 | 2 |
519792 | 519792 | 2020-09-10 | Lawrence | Missouri | 29109 | 419 | 2 |
516557 | 516557 | 2020-09-09 | Lawrence | Missouri | 29109 | 408 | 2 |
513323 | 513323 | 2020-09-08 | Lawrence | Missouri | 29109 | 399 | 2 |
510091 | 510091 | 2020-09-07 | Lawrence | Missouri | 29109 | 393 | 2 |
506858 | 506858 | 2020-09-06 | Lawrence | Missouri | 29109 | 393 | 2 |
503625 | 503625 | 2020-09-05 | Lawrence | Missouri | 29109 | 389 | 2 |
500391 | 500391 | 2020-09-04 | Lawrence | Missouri | 29109 | 378 | 2 |
497157 | 497157 | 2020-09-03 | Lawrence | Missouri | 29109 | 370 | 2 |
493924 | 493924 | 2020-09-02 | Lawrence | Missouri | 29109 | 363 | 2 |
490690 | 490690 | 2020-09-01 | Lawrence | Missouri | 29109 | 356 | 2 |
487457 | 487457 | 2020-08-31 | Lawrence | Missouri | 29109 | 354 | 2 |
484223 | 484223 | 2020-08-30 | Lawrence | Missouri | 29109 | 352 | 2 |
480988 | 480988 | 2020-08-29 | Lawrence | Missouri | 29109 | 351 | 2 |
477756 | 477756 | 2020-08-28 | Lawrence | Missouri | 29109 | 342 | 2 |
478695 | 478695 | 2020-08-28 | Lawrence | South Dakota | 46081 | 190 | 2 |
474523 | 474523 | 2020-08-27 | Lawrence | Missouri | 29109 | 335 | 2 |
475462 | 475462 | 2020-08-27 | Lawrence | South Dakota | 46081 | 171 | 2 |
471291 | 471291 | 2020-08-26 | Lawrence | Missouri | 29109 | 323 | 2 |
472228 | 472228 | 2020-08-26 | Lawrence | South Dakota | 46081 | 129 | 2 |
468061 | 468061 | 2020-08-25 | Lawrence | Missouri | 29109 | 319 | 2 |
464832 | 464832 | 2020-08-24 | Lawrence | Missouri | 29109 | 317 | 2 |
461601 | 461601 | 2020-08-23 | Lawrence | Missouri | 29109 | 310 | 2 |
458374 | 458374 | 2020-08-22 | Lawrence | Missouri | 29109 | 301 | 2 |
455146 | 455146 | 2020-08-21 | Lawrence | Missouri | 29109 | 296 | 2 |
451918 | 451918 | 2020-08-20 | Lawrence | Missouri | 29109 | 293 | 2 |
448690 | 448690 | 2020-08-19 | Lawrence | Missouri | 29109 | 288 | 2 |
445464 | 445464 | 2020-08-18 | Lawrence | Missouri | 29109 | 275 | 2 |
442238 | 442238 | 2020-08-17 | Lawrence | Missouri | 29109 | 271 | 2 |
439011 | 439011 | 2020-08-16 | Lawrence | Missouri | 29109 | 264 | 2 |
435786 | 435786 | 2020-08-15 | Lawrence | Missouri | 29109 | 252 | 2 |
432560 | 432560 | 2020-08-14 | Lawrence | Missouri | 29109 | 247 | 2 |
429333 | 429333 | 2020-08-13 | Lawrence | Missouri | 29109 | 246 | 2 |
426109 | 426109 | 2020-08-12 | Lawrence | Missouri | 29109 | 240 | 2 |
421380 | 421380 | 2020-08-11 | Lawrence | Alabama | 1079 | 364 | 2 |
422887 | 422887 | 2020-08-11 | Lawrence | Missouri | 29109 | 233 | 2 |
418159 | 418159 | 2020-08-10 | Lawrence | Alabama | 1079 | 361 | 2 |
419665 | 419665 | 2020-08-10 | Lawrence | Missouri | 29109 | 230 | 2 |
416444 | 416444 | 2020-08-09 | Lawrence | Missouri | 29109 | 228 | 2 |
413224 | 413224 | 2020-08-08 | Lawrence | Missouri | 29109 | 211 | 2 |
410004 | 410004 | 2020-08-07 | Lawrence | Missouri | 29109 | 211 | 2 |
406784 | 406784 | 2020-08-06 | Lawrence | Missouri | 29109 | 205 | 2 |
403566 | 403566 | 2020-08-05 | Lawrence | Missouri | 29109 | 202 | 2 |
400349 | 400349 | 2020-08-04 | Lawrence | Missouri | 29109 | 195 | 2 |
397135 | 397135 | 2020-08-03 | Lawrence | Missouri | 29109 | 192 | 2 |
393919 | 393919 | 2020-08-02 | Lawrence | Missouri | 29109 | 186 | 2 |
390702 | 390702 | 2020-08-01 | Lawrence | Missouri | 29109 | 184 | 2 |
387485 | 387485 | 2020-07-31 | Lawrence | Missouri | 29109 | 182 | 2 |
384267 | 384267 | 2020-07-30 | Lawrence | Missouri | 29109 | 172 | 2 |
381051 | 381051 | 2020-07-29 | Lawrence | Missouri | 29109 | 159 | 2 |
377834 | 377834 | 2020-07-28 | Lawrence | Missouri | 29109 | 152 | 2 |
374619 | 374619 | 2020-07-27 | Lawrence | Missouri | 29109 | 142 | 2 |
371407 | 371407 | 2020-07-26 | Lawrence | Missouri | 29109 | 136 | 2 |
368196 | 368196 | 2020-07-25 | Lawrence | Missouri | 29109 | 134 | 2 |
364988 | 364988 | 2020-07-24 | Lawrence | Missouri | 29109 | 125 | 2 |
361781 | 361781 | 2020-07-23 | Lawrence | Missouri | 29109 | 122 | 2 |
358576 | 358576 | 2020-07-22 | Lawrence | Missouri | 29109 | 110 | 2 |
355373 | 355373 | 2020-07-21 | Lawrence | Missouri | 29109 | 106 | 2 |
352071 | 352071 | 2020-07-20 | Lawrence | Mississippi | 28077 | 208 | 2 |
352171 | 352171 | 2020-07-20 | Lawrence | Missouri | 29109 | 104 | 2 |
348871 | 348871 | 2020-07-19 | Lawrence | Mississippi | 28077 | 207 | 2 |
348971 | 348971 | 2020-07-19 | Lawrence | Missouri | 29109 | 94 | 2 |
345670 | 345670 | 2020-07-18 | Lawrence | Mississippi | 28077 | 203 | 2 |
345770 | 345770 | 2020-07-18 | Lawrence | Missouri | 29109 | 87 | 2 |
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);