ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,522 rows where county = "Lawrence" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
deaths >30 ✖
state 11
- Mississippi 785
- Arkansas 781
- Indiana 781
- Ohio 780
- Pennsylvania 780
- South Dakota 778
- Tennessee 775
- Kentucky 774
- Illinois 767
- Missouri 741
- Alabama 680
fips 11
county 1
- Lawrence · 8,422 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
296577 | 296577 | 2020-07-03 | Lawrence | Alabama | 1079 | 108 | 0 |
299739 | 299739 | 2020-07-04 | Lawrence | Alabama | 1079 | 110 | 0 |
302903 | 302903 | 2020-07-05 | Lawrence | Alabama | 1079 | 111 | 0 |
306067 | 306067 | 2020-07-06 | Lawrence | Alabama | 1079 | 113 | 0 |
309236 | 309236 | 2020-07-07 | Lawrence | Alabama | 1079 | 112 | 0 |
312405 | 312405 | 2020-07-08 | Lawrence | Alabama | 1079 | 116 | 0 |
315580 | 315580 | 2020-07-09 | Lawrence | Alabama | 1079 | 120 | 0 |
318753 | 318753 | 2020-07-10 | Lawrence | Alabama | 1079 | 124 | 0 |
321932 | 321932 | 2020-07-11 | Lawrence | Alabama | 1079 | 128 | 0 |
325113 | 325113 | 2020-07-12 | Lawrence | Alabama | 1079 | 139 | 0 |
328299 | 328299 | 2020-07-13 | Lawrence | Alabama | 1079 | 149 | 0 |
331485 | 331485 | 2020-07-14 | Lawrence | Alabama | 1079 | 154 | 0 |
334678 | 334678 | 2020-07-15 | Lawrence | Alabama | 1079 | 162 | 0 |
337873 | 337873 | 2020-07-16 | Lawrence | Alabama | 1079 | 165 | 0 |
341069 | 341069 | 2020-07-17 | Lawrence | Alabama | 1079 | 176 | 0 |
344268 | 344268 | 2020-07-18 | Lawrence | Alabama | 1079 | 186 | 0 |
347468 | 347468 | 2020-07-19 | Lawrence | Alabama | 1079 | 187 | 0 |
350669 | 350669 | 2020-07-20 | Lawrence | Alabama | 1079 | 188 | 0 |
353871 | 353871 | 2020-07-21 | Lawrence | Alabama | 1079 | 209 | 0 |
357074 | 357074 | 2020-07-22 | Lawrence | Alabama | 1079 | 214 | 0 |
360279 | 360279 | 2020-07-23 | Lawrence | Alabama | 1079 | 220 | 0 |
363485 | 363485 | 2020-07-24 | Lawrence | Alabama | 1079 | 231 | 0 |
366692 | 366692 | 2020-07-25 | Lawrence | Alabama | 1079 | 244 | 0 |
369902 | 369902 | 2020-07-26 | Lawrence | Alabama | 1079 | 248 | 0 |
373114 | 373114 | 2020-07-27 | Lawrence | Alabama | 1079 | 258 | 0 |
376328 | 376328 | 2020-07-28 | Lawrence | Alabama | 1079 | 265 | 0 |
379544 | 379544 | 2020-07-29 | Lawrence | Alabama | 1079 | 272 | 0 |
382761 | 382761 | 2020-07-30 | Lawrence | Alabama | 1079 | 286 | 0 |
385979 | 385979 | 2020-07-31 | Lawrence | Alabama | 1079 | 300 | 0 |
389196 | 389196 | 2020-08-01 | Lawrence | Alabama | 1079 | 303 | 0 |
392413 | 392413 | 2020-08-02 | Lawrence | Alabama | 1079 | 311 | 0 |
395629 | 395629 | 2020-08-03 | Lawrence | Alabama | 1079 | 316 | 0 |
398845 | 398845 | 2020-08-04 | Lawrence | Alabama | 1079 | 331 | 0 |
402061 | 402061 | 2020-08-05 | Lawrence | Alabama | 1079 | 332 | 1 |
405279 | 405279 | 2020-08-06 | Lawrence | Alabama | 1079 | 340 | 1 |
408499 | 408499 | 2020-08-07 | Lawrence | Alabama | 1079 | 352 | 1 |
411718 | 411718 | 2020-08-08 | Lawrence | Alabama | 1079 | 358 | 1 |
414938 | 414938 | 2020-08-09 | Lawrence | Alabama | 1079 | 359 | 1 |
418159 | 418159 | 2020-08-10 | Lawrence | Alabama | 1079 | 361 | 2 |
421380 | 421380 | 2020-08-11 | Lawrence | Alabama | 1079 | 364 | 2 |
424601 | 424601 | 2020-08-12 | Lawrence | Alabama | 1079 | 366 | 3 |
427825 | 427825 | 2020-08-13 | Lawrence | Alabama | 1079 | 370 | 3 |
431053 | 431053 | 2020-08-14 | Lawrence | Alabama | 1079 | 376 | 3 |
434278 | 434278 | 2020-08-15 | Lawrence | Alabama | 1079 | 380 | 3 |
437504 | 437504 | 2020-08-16 | Lawrence | Alabama | 1079 | 383 | 3 |
440730 | 440730 | 2020-08-17 | Lawrence | Alabama | 1079 | 383 | 3 |
443956 | 443956 | 2020-08-18 | Lawrence | Alabama | 1079 | 390 | 3 |
447183 | 447183 | 2020-08-19 | Lawrence | Alabama | 1079 | 392 | 3 |
450411 | 450411 | 2020-08-20 | Lawrence | Alabama | 1079 | 396 | 4 |
453639 | 453639 | 2020-08-21 | Lawrence | Alabama | 1079 | 402 | 4 |
456867 | 456867 | 2020-08-22 | Lawrence | Alabama | 1079 | 409 | 4 |
460094 | 460094 | 2020-08-23 | Lawrence | Alabama | 1079 | 415 | 5 |
463323 | 463323 | 2020-08-24 | Lawrence | Alabama | 1079 | 425 | 5 |
466552 | 466552 | 2020-08-25 | Lawrence | Alabama | 1079 | 433 | 5 |
469781 | 469781 | 2020-08-26 | Lawrence | Alabama | 1079 | 442 | 5 |
473013 | 473013 | 2020-08-27 | Lawrence | Alabama | 1079 | 447 | 5 |
476246 | 476246 | 2020-08-28 | Lawrence | Alabama | 1079 | 448 | 5 |
479479 | 479479 | 2020-08-29 | Lawrence | Alabama | 1079 | 455 | 5 |
482713 | 482713 | 2020-08-30 | Lawrence | Alabama | 1079 | 472 | 5 |
485948 | 485948 | 2020-08-31 | Lawrence | Alabama | 1079 | 476 | 5 |
489181 | 489181 | 2020-09-01 | Lawrence | Alabama | 1079 | 480 | 5 |
492414 | 492414 | 2020-09-02 | Lawrence | Alabama | 1079 | 483 | 5 |
495648 | 495648 | 2020-09-03 | Lawrence | Alabama | 1079 | 503 | 5 |
498881 | 498881 | 2020-09-04 | Lawrence | Alabama | 1079 | 505 | 5 |
502115 | 502115 | 2020-09-05 | Lawrence | Alabama | 1079 | 518 | 5 |
505349 | 505349 | 2020-09-06 | Lawrence | Alabama | 1079 | 520 | 5 |
508581 | 508581 | 2020-09-07 | Lawrence | Alabama | 1079 | 523 | 5 |
511814 | 511814 | 2020-09-08 | Lawrence | Alabama | 1079 | 524 | 5 |
515047 | 515047 | 2020-09-09 | Lawrence | Alabama | 1079 | 529 | 7 |
518282 | 518282 | 2020-09-10 | Lawrence | Alabama | 1079 | 534 | 10 |
521519 | 521519 | 2020-09-11 | Lawrence | Alabama | 1079 | 546 | 10 |
524755 | 524755 | 2020-09-12 | Lawrence | Alabama | 1079 | 551 | 12 |
527991 | 527991 | 2020-09-13 | Lawrence | Alabama | 1079 | 554 | 12 |
531228 | 531228 | 2020-09-14 | Lawrence | Alabama | 1079 | 556 | 12 |
534463 | 534463 | 2020-09-15 | Lawrence | Alabama | 1079 | 568 | 20 |
537699 | 537699 | 2020-09-16 | Lawrence | Alabama | 1079 | 573 | 20 |
540936 | 540936 | 2020-09-17 | Lawrence | Alabama | 1079 | 576 | 20 |
544172 | 544172 | 2020-09-18 | Lawrence | Alabama | 1079 | 578 | 20 |
547409 | 547409 | 2020-09-19 | Lawrence | Alabama | 1079 | 582 | 20 |
550648 | 550648 | 2020-09-20 | Lawrence | Alabama | 1079 | 585 | 20 |
553887 | 553887 | 2020-09-21 | Lawrence | Alabama | 1079 | 592 | 20 |
557124 | 557124 | 2020-09-22 | Lawrence | Alabama | 1079 | 603 | 20 |
560360 | 560360 | 2020-09-23 | Lawrence | Alabama | 1079 | 605 | 22 |
563599 | 563599 | 2020-09-24 | Lawrence | Alabama | 1079 | 609 | 22 |
566840 | 566840 | 2020-09-25 | Lawrence | Alabama | 1079 | 616 | 23 |
570081 | 570081 | 2020-09-26 | Lawrence | Alabama | 1079 | 620 | 23 |
573323 | 573323 | 2020-09-27 | Lawrence | Alabama | 1079 | 621 | 23 |
576567 | 576567 | 2020-09-28 | Lawrence | Alabama | 1079 | 628 | 23 |
579808 | 579808 | 2020-09-29 | Lawrence | Alabama | 1079 | 634 | 25 |
583047 | 583047 | 2020-09-30 | Lawrence | Alabama | 1079 | 636 | 25 |
586287 | 586287 | 2020-10-01 | Lawrence | Alabama | 1079 | 644 | 25 |
589528 | 589528 | 2020-10-02 | Lawrence | Alabama | 1079 | 647 | 26 |
592768 | 592768 | 2020-10-03 | Lawrence | Alabama | 1079 | 652 | 26 |
596010 | 596010 | 2020-10-04 | Lawrence | Alabama | 1079 | 652 | 26 |
599253 | 599253 | 2020-10-05 | Lawrence | Alabama | 1079 | 662 | 26 |
602496 | 602496 | 2020-10-06 | Lawrence | Alabama | 1079 | 676 | 26 |
605738 | 605738 | 2020-10-07 | Lawrence | Alabama | 1079 | 685 | 26 |
608981 | 608981 | 2020-10-08 | Lawrence | Alabama | 1079 | 689 | 26 |
612223 | 612223 | 2020-10-09 | Lawrence | Alabama | 1079 | 699 | 26 |
615464 | 615464 | 2020-10-10 | Lawrence | Alabama | 1079 | 711 | 28 |
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);