ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,231 rows where county = "Lawrence" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
state
- Mississippi 304
- Arkansas 300
- Indiana 300
- Alabama 299
- Ohio 299
- Pennsylvania 299
- South Dakota 297
- Tennessee 294
- Kentucky 293
- Illinois 286
- Missouri 260
fips
county
- Lawrence · 3,231 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936783 | 936783 | 2021-01-17 | Lawrence | Alabama | 1079 | 2436 | 47 |
936891 | 936891 | 2021-01-17 | Lawrence | Arkansas | 5075 | 1806 | 40 |
937394 | 937394 | 2021-01-17 | Lawrence | Illinois | 17101 | 2167 | 30 |
937492 | 937492 | 2021-01-17 | Lawrence | Indiana | 18093 | 3808 | 78 |
937807 | 937807 | 2021-01-17 | Lawrence | Kentucky | 21127 | 997 | 5 |
938196 | 938196 | 2021-01-17 | Lawrence | Mississippi | 28077 | 1024 | 17 |
938296 | 938296 | 2021-01-17 | Lawrence | Missouri | 29109 | 2542 | 60 |
938846 | 938846 | 2021-01-17 | Lawrence | Ohio | 39087 | 4326 | 51 |
939041 | 939041 | 2021-01-17 | Lawrence | Pennsylvania | 42073 | 5065 | 149 |
939242 | 939242 | 2021-01-17 | Lawrence | South Dakota | 46081 | 2704 | 35 |
939318 | 939318 | 2021-01-17 | Lawrence | Tennessee | 47099 | 5075 | 69 |
933538 | 933538 | 2021-01-16 | Lawrence | Alabama | 1079 | 2425 | 47 |
933646 | 933646 | 2021-01-16 | Lawrence | Arkansas | 5075 | 1801 | 40 |
934149 | 934149 | 2021-01-16 | Lawrence | Illinois | 17101 | 2167 | 30 |
934247 | 934247 | 2021-01-16 | Lawrence | Indiana | 18093 | 3797 | 78 |
934562 | 934562 | 2021-01-16 | Lawrence | Kentucky | 21127 | 993 | 5 |
934951 | 934951 | 2021-01-16 | Lawrence | Mississippi | 28077 | 1021 | 17 |
935051 | 935051 | 2021-01-16 | Lawrence | Missouri | 29109 | 2534 | 60 |
935601 | 935601 | 2021-01-16 | Lawrence | Ohio | 39087 | 4289 | 51 |
935796 | 935796 | 2021-01-16 | Lawrence | Pennsylvania | 42073 | 5032 | 147 |
935997 | 935997 | 2021-01-16 | Lawrence | South Dakota | 46081 | 2695 | 33 |
936073 | 936073 | 2021-01-16 | Lawrence | Tennessee | 47099 | 5063 | 69 |
930293 | 930293 | 2021-01-15 | Lawrence | Alabama | 1079 | 2404 | 47 |
930401 | 930401 | 2021-01-15 | Lawrence | Arkansas | 5075 | 1788 | 40 |
930904 | 930904 | 2021-01-15 | Lawrence | Illinois | 17101 | 2151 | 30 |
931002 | 931002 | 2021-01-15 | Lawrence | Indiana | 18093 | 3781 | 78 |
931317 | 931317 | 2021-01-15 | Lawrence | Kentucky | 21127 | 987 | 5 |
931706 | 931706 | 2021-01-15 | Lawrence | Mississippi | 28077 | 1012 | 17 |
931806 | 931806 | 2021-01-15 | Lawrence | Missouri | 29109 | 2515 | 59 |
932356 | 932356 | 2021-01-15 | Lawrence | Ohio | 39087 | 4224 | 51 |
932551 | 932551 | 2021-01-15 | Lawrence | Pennsylvania | 42073 | 4992 | 144 |
932752 | 932752 | 2021-01-15 | Lawrence | South Dakota | 46081 | 2692 | 33 |
932828 | 932828 | 2021-01-15 | Lawrence | Tennessee | 47099 | 5028 | 69 |
927048 | 927048 | 2021-01-14 | Lawrence | Alabama | 1079 | 2393 | 45 |
927156 | 927156 | 2021-01-14 | Lawrence | Arkansas | 5075 | 1772 | 40 |
927659 | 927659 | 2021-01-14 | Lawrence | Illinois | 17101 | 2138 | 29 |
927757 | 927757 | 2021-01-14 | Lawrence | Indiana | 18093 | 3744 | 75 |
928072 | 928072 | 2021-01-14 | Lawrence | Kentucky | 21127 | 977 | 5 |
928461 | 928461 | 2021-01-14 | Lawrence | Mississippi | 28077 | 998 | 17 |
928561 | 928561 | 2021-01-14 | Lawrence | Missouri | 29109 | 2546 | 60 |
929111 | 929111 | 2021-01-14 | Lawrence | Ohio | 39087 | 4170 | 51 |
929306 | 929306 | 2021-01-14 | Lawrence | Pennsylvania | 42073 | 4967 | 143 |
929507 | 929507 | 2021-01-14 | Lawrence | South Dakota | 46081 | 2675 | 33 |
929583 | 929583 | 2021-01-14 | Lawrence | Tennessee | 47099 | 5001 | 69 |
923802 | 923802 | 2021-01-13 | Lawrence | Alabama | 1079 | 2368 | 45 |
923910 | 923910 | 2021-01-13 | Lawrence | Arkansas | 5075 | 1762 | 40 |
924413 | 924413 | 2021-01-13 | Lawrence | Illinois | 17101 | 2131 | 29 |
924511 | 924511 | 2021-01-13 | Lawrence | Indiana | 18093 | 3719 | 74 |
924826 | 924826 | 2021-01-13 | Lawrence | Kentucky | 21127 | 964 | 5 |
925215 | 925215 | 2021-01-13 | Lawrence | Mississippi | 28077 | 991 | 17 |
925315 | 925315 | 2021-01-13 | Lawrence | Missouri | 29109 | 2539 | 60 |
925866 | 925866 | 2021-01-13 | Lawrence | Ohio | 39087 | 4139 | 49 |
926061 | 926061 | 2021-01-13 | Lawrence | Pennsylvania | 42073 | 4934 | 143 |
926262 | 926262 | 2021-01-13 | Lawrence | South Dakota | 46081 | 2672 | 33 |
926338 | 926338 | 2021-01-13 | Lawrence | Tennessee | 47099 | 4956 | 69 |
920557 | 920557 | 2021-01-12 | Lawrence | Alabama | 1079 | 2351 | 45 |
920665 | 920665 | 2021-01-12 | Lawrence | Arkansas | 5075 | 1753 | 39 |
921168 | 921168 | 2021-01-12 | Lawrence | Illinois | 17101 | 2121 | 29 |
921266 | 921266 | 2021-01-12 | Lawrence | Indiana | 18093 | 3699 | 74 |
921581 | 921581 | 2021-01-12 | Lawrence | Kentucky | 21127 | 947 | 5 |
921970 | 921970 | 2021-01-12 | Lawrence | Mississippi | 28077 | 979 | 17 |
922070 | 922070 | 2021-01-12 | Lawrence | Missouri | 29109 | 2532 | 60 |
922620 | 922620 | 2021-01-12 | Lawrence | Ohio | 39087 | 4089 | 49 |
922815 | 922815 | 2021-01-12 | Lawrence | Pennsylvania | 42073 | 4871 | 140 |
923016 | 923016 | 2021-01-12 | Lawrence | South Dakota | 46081 | 2657 | 31 |
923092 | 923092 | 2021-01-12 | Lawrence | Tennessee | 47099 | 4938 | 68 |
917312 | 917312 | 2021-01-11 | Lawrence | Alabama | 1079 | 2340 | 44 |
917420 | 917420 | 2021-01-11 | Lawrence | Arkansas | 5075 | 1729 | 39 |
917923 | 917923 | 2021-01-11 | Lawrence | Illinois | 17101 | 2107 | 29 |
918021 | 918021 | 2021-01-11 | Lawrence | Indiana | 18093 | 3663 | 72 |
918336 | 918336 | 2021-01-11 | Lawrence | Kentucky | 21127 | 932 | 5 |
918725 | 918725 | 2021-01-11 | Lawrence | Mississippi | 28077 | 976 | 17 |
918825 | 918825 | 2021-01-11 | Lawrence | Missouri | 29109 | 2521 | 57 |
919375 | 919375 | 2021-01-11 | Lawrence | Ohio | 39087 | 4038 | 49 |
919570 | 919570 | 2021-01-11 | Lawrence | Pennsylvania | 42073 | 4826 | 140 |
919771 | 919771 | 2021-01-11 | Lawrence | South Dakota | 46081 | 2655 | 31 |
919847 | 919847 | 2021-01-11 | Lawrence | Tennessee | 47099 | 4916 | 67 |
914067 | 914067 | 2021-01-10 | Lawrence | Alabama | 1079 | 2324 | 44 |
914175 | 914175 | 2021-01-10 | Lawrence | Arkansas | 5075 | 1723 | 38 |
914678 | 914678 | 2021-01-10 | Lawrence | Illinois | 17101 | 2079 | 29 |
914776 | 914776 | 2021-01-10 | Lawrence | Indiana | 18093 | 3646 | 70 |
915091 | 915091 | 2021-01-10 | Lawrence | Kentucky | 21127 | 932 | 5 |
915480 | 915480 | 2021-01-10 | Lawrence | Mississippi | 28077 | 973 | 17 |
915580 | 915580 | 2021-01-10 | Lawrence | Missouri | 29109 | 2515 | 57 |
916130 | 916130 | 2021-01-10 | Lawrence | Ohio | 39087 | 4005 | 48 |
916325 | 916325 | 2021-01-10 | Lawrence | Pennsylvania | 42073 | 4790 | 139 |
916526 | 916526 | 2021-01-10 | Lawrence | South Dakota | 46081 | 2652 | 31 |
916602 | 916602 | 2021-01-10 | Lawrence | Tennessee | 47099 | 4885 | 66 |
910822 | 910822 | 2021-01-09 | Lawrence | Alabama | 1079 | 2315 | 44 |
910930 | 910930 | 2021-01-09 | Lawrence | Arkansas | 5075 | 1717 | 37 |
911433 | 911433 | 2021-01-09 | Lawrence | Illinois | 17101 | 2077 | 29 |
911531 | 911531 | 2021-01-09 | Lawrence | Indiana | 18093 | 3621 | 70 |
911846 | 911846 | 2021-01-09 | Lawrence | Kentucky | 21127 | 925 | 5 |
912235 | 912235 | 2021-01-09 | Lawrence | Mississippi | 28077 | 971 | 17 |
912335 | 912335 | 2021-01-09 | Lawrence | Missouri | 29109 | 2490 | 57 |
912885 | 912885 | 2021-01-09 | Lawrence | Ohio | 39087 | 3985 | 48 |
913080 | 913080 | 2021-01-09 | Lawrence | Pennsylvania | 42073 | 4734 | 139 |
913281 | 913281 | 2021-01-09 | Lawrence | South Dakota | 46081 | 2645 | 31 |
913357 | 913357 | 2021-01-09 | Lawrence | Tennessee | 47099 | 4822 | 66 |
907577 | 907577 | 2021-01-08 | Lawrence | Alabama | 1079 | 2263 | 44 |
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]);