ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where county = "Lawrence" and deaths = 8 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 7
- Illinois 34
- Pennsylvania 32
- Mississippi 11
- South Dakota 8
- Indiana 7
- Kentucky 7
- Tennessee 7
county 1
- Lawrence · 106 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635534 | 635534 | 2020-10-16 | Lawrence | Illinois | 17101 | 302 | 8 |
638780 | 638780 | 2020-10-17 | Lawrence | Illinois | 17101 | 304 | 8 |
642027 | 642027 | 2020-10-18 | Lawrence | Illinois | 17101 | 306 | 8 |
645274 | 645274 | 2020-10-19 | Lawrence | Illinois | 17101 | 306 | 8 |
648519 | 648519 | 2020-10-20 | Lawrence | Illinois | 17101 | 306 | 8 |
651763 | 651763 | 2020-10-21 | Lawrence | Illinois | 17101 | 317 | 8 |
655008 | 655008 | 2020-10-22 | Lawrence | Illinois | 17101 | 323 | 8 |
658253 | 658253 | 2020-10-23 | Lawrence | Illinois | 17101 | 324 | 8 |
661497 | 661497 | 2020-10-24 | Lawrence | Illinois | 17101 | 332 | 8 |
664742 | 664742 | 2020-10-25 | Lawrence | Illinois | 17101 | 333 | 8 |
667986 | 667986 | 2020-10-26 | Lawrence | Illinois | 17101 | 336 | 8 |
671229 | 671229 | 2020-10-27 | Lawrence | Illinois | 17101 | 338 | 8 |
674471 | 674471 | 2020-10-28 | Lawrence | Illinois | 17101 | 351 | 8 |
677714 | 677714 | 2020-10-29 | Lawrence | Illinois | 17101 | 355 | 8 |
680957 | 680957 | 2020-10-30 | Lawrence | Illinois | 17101 | 362 | 8 |
684200 | 684200 | 2020-10-31 | Lawrence | Illinois | 17101 | 362 | 8 |
687444 | 687444 | 2020-11-01 | Lawrence | Illinois | 17101 | 379 | 8 |
690689 | 690689 | 2020-11-02 | Lawrence | Illinois | 17101 | 381 | 8 |
693932 | 693932 | 2020-11-03 | Lawrence | Illinois | 17101 | 385 | 8 |
697174 | 697174 | 2020-11-04 | Lawrence | Illinois | 17101 | 393 | 8 |
700418 | 700418 | 2020-11-05 | Lawrence | Illinois | 17101 | 403 | 8 |
703661 | 703661 | 2020-11-06 | Lawrence | Illinois | 17101 | 418 | 8 |
706904 | 706904 | 2020-11-07 | Lawrence | Illinois | 17101 | 437 | 8 |
710148 | 710148 | 2020-11-08 | Lawrence | Illinois | 17101 | 454 | 8 |
713392 | 713392 | 2020-11-09 | Lawrence | Illinois | 17101 | 458 | 8 |
716636 | 716636 | 2020-11-10 | Lawrence | Illinois | 17101 | 501 | 8 |
719879 | 719879 | 2020-11-11 | Lawrence | Illinois | 17101 | 530 | 8 |
723122 | 723122 | 2020-11-12 | Lawrence | Illinois | 17101 | 534 | 8 |
726365 | 726365 | 2020-11-13 | Lawrence | Illinois | 17101 | 563 | 8 |
729608 | 729608 | 2020-11-14 | Lawrence | Illinois | 17101 | 577 | 8 |
732853 | 732853 | 2020-11-15 | Lawrence | Illinois | 17101 | 586 | 8 |
736099 | 736099 | 2020-11-16 | Lawrence | Illinois | 17101 | 608 | 8 |
739343 | 739343 | 2020-11-17 | Lawrence | Illinois | 17101 | 634 | 8 |
742590 | 742590 | 2020-11-18 | Lawrence | Illinois | 17101 | 665 | 8 |
41296 | 41296 | 2020-04-08 | Lawrence | Indiana | 18093 | 56 | 8 |
43872 | 43872 | 2020-04-09 | Lawrence | Indiana | 18093 | 57 | 8 |
46476 | 46476 | 2020-04-10 | Lawrence | Indiana | 18093 | 60 | 8 |
49110 | 49110 | 2020-04-11 | Lawrence | Indiana | 18093 | 64 | 8 |
51773 | 51773 | 2020-04-12 | Lawrence | Indiana | 18093 | 69 | 8 |
54454 | 54454 | 2020-04-13 | Lawrence | Indiana | 18093 | 72 | 8 |
57147 | 57147 | 2020-04-14 | Lawrence | Indiana | 18093 | 74 | 8 |
953955 | 953955 | 2021-01-22 | Lawrence | Kentucky | 21127 | 1024 | 8 |
957200 | 957200 | 2021-01-23 | Lawrence | Kentucky | 21127 | 1031 | 8 |
960446 | 960446 | 2021-01-24 | Lawrence | Kentucky | 21127 | 1038 | 8 |
963691 | 963691 | 2021-01-25 | Lawrence | Kentucky | 21127 | 1038 | 8 |
966936 | 966936 | 2021-01-26 | Lawrence | Kentucky | 21127 | 1045 | 8 |
970180 | 970180 | 2021-01-27 | Lawrence | Kentucky | 21127 | 1054 | 8 |
973425 | 973425 | 2021-01-28 | Lawrence | Kentucky | 21127 | 1059 | 8 |
416344 | 416344 | 2020-08-09 | Lawrence | Mississippi | 28077 | 323 | 8 |
419565 | 419565 | 2020-08-10 | Lawrence | Mississippi | 28077 | 322 | 8 |
422787 | 422787 | 2020-08-11 | Lawrence | Mississippi | 28077 | 323 | 8 |
426009 | 426009 | 2020-08-12 | Lawrence | Mississippi | 28077 | 329 | 8 |
429233 | 429233 | 2020-08-13 | Lawrence | Mississippi | 28077 | 332 | 8 |
432460 | 432460 | 2020-08-14 | Lawrence | Mississippi | 28077 | 340 | 8 |
435686 | 435686 | 2020-08-15 | Lawrence | Mississippi | 28077 | 341 | 8 |
438911 | 438911 | 2020-08-16 | Lawrence | Mississippi | 28077 | 342 | 8 |
442138 | 442138 | 2020-08-17 | Lawrence | Mississippi | 28077 | 342 | 8 |
445364 | 445364 | 2020-08-18 | Lawrence | Mississippi | 28077 | 347 | 8 |
448590 | 448590 | 2020-08-19 | Lawrence | Mississippi | 28077 | 367 | 8 |
156365 | 156365 | 2020-05-18 | Lawrence | Pennsylvania | 42073 | 72 | 8 |
159386 | 159386 | 2020-05-19 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
162413 | 162413 | 2020-05-20 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
165442 | 165442 | 2020-05-21 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
168478 | 168478 | 2020-05-22 | Lawrence | Pennsylvania | 42073 | 73 | 8 |
171517 | 171517 | 2020-05-23 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
174559 | 174559 | 2020-05-24 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
177603 | 177603 | 2020-05-25 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
180646 | 180646 | 2020-05-26 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
183696 | 183696 | 2020-05-27 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
186753 | 186753 | 2020-05-28 | Lawrence | Pennsylvania | 42073 | 74 | 8 |
189814 | 189814 | 2020-05-29 | Lawrence | Pennsylvania | 42073 | 76 | 8 |
192879 | 192879 | 2020-05-30 | Lawrence | Pennsylvania | 42073 | 79 | 8 |
195948 | 195948 | 2020-05-31 | Lawrence | Pennsylvania | 42073 | 80 | 8 |
199021 | 199021 | 2020-06-01 | Lawrence | Pennsylvania | 42073 | 80 | 8 |
202096 | 202096 | 2020-06-02 | Lawrence | Pennsylvania | 42073 | 81 | 8 |
205173 | 205173 | 2020-06-03 | Lawrence | Pennsylvania | 42073 | 83 | 8 |
208254 | 208254 | 2020-06-04 | Lawrence | Pennsylvania | 42073 | 82 | 8 |
211336 | 211336 | 2020-06-05 | Lawrence | Pennsylvania | 42073 | 82 | 8 |
214422 | 214422 | 2020-06-06 | Lawrence | Pennsylvania | 42073 | 84 | 8 |
217512 | 217512 | 2020-06-07 | Lawrence | Pennsylvania | 42073 | 85 | 8 |
220604 | 220604 | 2020-06-08 | Lawrence | Pennsylvania | 42073 | 85 | 8 |
223699 | 223699 | 2020-06-09 | Lawrence | Pennsylvania | 42073 | 85 | 8 |
226799 | 226799 | 2020-06-10 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
229903 | 229903 | 2020-06-11 | Lawrence | Pennsylvania | 42073 | 86 | 8 |
233008 | 233008 | 2020-06-12 | Lawrence | Pennsylvania | 42073 | 86 | 8 |
236113 | 236113 | 2020-06-13 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
239221 | 239221 | 2020-06-14 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
242330 | 242330 | 2020-06-15 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
245442 | 245442 | 2020-06-16 | Lawrence | Pennsylvania | 42073 | 87 | 8 |
248555 | 248555 | 2020-06-17 | Lawrence | Pennsylvania | 42073 | 88 | 8 |
251670 | 251670 | 2020-06-18 | Lawrence | Pennsylvania | 42073 | 89 | 8 |
708752 | 708752 | 2020-11-07 | Lawrence | South Dakota | 46081 | 1295 | 8 |
711996 | 711996 | 2020-11-08 | Lawrence | South Dakota | 46081 | 1349 | 8 |
715240 | 715240 | 2020-11-09 | Lawrence | South Dakota | 46081 | 1371 | 8 |
718483 | 718483 | 2020-11-10 | Lawrence | South Dakota | 46081 | 1392 | 8 |
721726 | 721726 | 2020-11-11 | Lawrence | South Dakota | 46081 | 1454 | 8 |
724969 | 724969 | 2020-11-12 | Lawrence | South Dakota | 46081 | 1514 | 8 |
728213 | 728213 | 2020-11-13 | Lawrence | South Dakota | 46081 | 1557 | 8 |
731457 | 731457 | 2020-11-14 | Lawrence | South Dakota | 46081 | 1607 | 8 |
446475 | 446475 | 2020-08-18 | Lawrence | Tennessee | 47099 | 655 | 8 |
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);