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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
- Mississippi 290
- Indiana 286
- Arkansas 285
- Ohio 285
- Pennsylvania 285
- Alabama 284
- South Dakota 283
- Tennessee 280
- Kentucky 279
- Illinois 271
- Missouri 246
fips 11
county 1
- Lawrence · 3,074 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
891978 | 891978 | 2021-01-03 | Lawrence | Indiana | 18093 | 3397 | 67 |
892293 | 892293 | 2021-01-03 | Lawrence | Kentucky | 21127 | 837 | 5 |
892682 | 892682 | 2021-01-03 | Lawrence | Mississippi | 28077 | 924 | 16 |
892782 | 892782 | 2021-01-03 | Lawrence | Missouri | 29109 | 2370 | 52 |
893333 | 893333 | 2021-01-03 | Lawrence | Ohio | 39087 | 3642 | 47 |
893528 | 893528 | 2021-01-03 | Lawrence | Pennsylvania | 42073 | 4390 | 129 |
893729 | 893729 | 2021-01-03 | Lawrence | South Dakota | 46081 | 2594 | 28 |
893805 | 893805 | 2021-01-03 | Lawrence | Tennessee | 47099 | 4551 | 59 |
888022 | 888022 | 2021-01-02 | Lawrence | Alabama | 1079 | 2102 | 43 |
888130 | 888130 | 2021-01-02 | Lawrence | Arkansas | 5075 | 1600 | 36 |
888633 | 888633 | 2021-01-02 | Lawrence | Illinois | 17101 | 1990 | 27 |
888732 | 888732 | 2021-01-02 | Lawrence | Indiana | 18093 | 3368 | 67 |
889047 | 889047 | 2021-01-02 | Lawrence | Kentucky | 21127 | 825 | 5 |
889436 | 889436 | 2021-01-02 | Lawrence | Mississippi | 28077 | 920 | 16 |
889536 | 889536 | 2021-01-02 | Lawrence | Missouri | 29109 | 2355 | 52 |
890087 | 890087 | 2021-01-02 | Lawrence | Ohio | 39087 | 3609 | 47 |
890282 | 890282 | 2021-01-02 | Lawrence | Pennsylvania | 42073 | 4361 | 129 |
890483 | 890483 | 2021-01-02 | Lawrence | South Dakota | 46081 | 2577 | 28 |
890559 | 890559 | 2021-01-02 | Lawrence | Tennessee | 47099 | 4519 | 59 |
884777 | 884777 | 2021-01-01 | Lawrence | Alabama | 1079 | 2082 | 43 |
884885 | 884885 | 2021-01-01 | Lawrence | Arkansas | 5075 | 1587 | 35 |
885388 | 885388 | 2021-01-01 | Lawrence | Illinois | 17101 | 1985 | 27 |
885486 | 885486 | 2021-01-01 | Lawrence | Indiana | 18093 | 3340 | 65 |
885801 | 885801 | 2021-01-01 | Lawrence | Kentucky | 21127 | 758 | 5 |
886190 | 886190 | 2021-01-01 | Lawrence | Mississippi | 28077 | 919 | 16 |
886290 | 886290 | 2021-01-01 | Lawrence | Missouri | 29109 | 2346 | 52 |
886840 | 886840 | 2021-01-01 | Lawrence | Ohio | 39087 | 3517 | 47 |
887035 | 887035 | 2021-01-01 | Lawrence | Pennsylvania | 42073 | 4286 | 129 |
887236 | 887236 | 2021-01-01 | Lawrence | South Dakota | 46081 | 2555 | 28 |
887312 | 887312 | 2021-01-01 | Lawrence | Tennessee | 47099 | 4416 | 58 |
881532 | 881532 | 2020-12-31 | Lawrence | Alabama | 1079 | 2044 | 42 |
881640 | 881640 | 2020-12-31 | Lawrence | Arkansas | 5075 | 1574 | 35 |
882143 | 882143 | 2020-12-31 | Lawrence | Illinois | 17101 | 1985 | 27 |
882241 | 882241 | 2020-12-31 | Lawrence | Indiana | 18093 | 3299 | 65 |
882556 | 882556 | 2020-12-31 | Lawrence | Kentucky | 21127 | 758 | 5 |
882945 | 882945 | 2020-12-31 | Lawrence | Mississippi | 28077 | 918 | 16 |
883045 | 883045 | 2020-12-31 | Lawrence | Missouri | 29109 | 2293 | 52 |
883595 | 883595 | 2020-12-31 | Lawrence | Ohio | 39087 | 3517 | 47 |
883790 | 883790 | 2020-12-31 | Lawrence | Pennsylvania | 42073 | 4245 | 126 |
883991 | 883991 | 2020-12-31 | Lawrence | South Dakota | 46081 | 2555 | 28 |
884067 | 884067 | 2020-12-31 | Lawrence | Tennessee | 47099 | 4416 | 58 |
878287 | 878287 | 2020-12-30 | Lawrence | Alabama | 1079 | 2005 | 42 |
878395 | 878395 | 2020-12-30 | Lawrence | Arkansas | 5075 | 1568 | 35 |
878898 | 878898 | 2020-12-30 | Lawrence | Illinois | 17101 | 1935 | 27 |
878996 | 878996 | 2020-12-30 | Lawrence | Indiana | 18093 | 3240 | 65 |
879311 | 879311 | 2020-12-30 | Lawrence | Kentucky | 21127 | 758 | 5 |
879700 | 879700 | 2020-12-30 | Lawrence | Mississippi | 28077 | 916 | 16 |
879800 | 879800 | 2020-12-30 | Lawrence | Missouri | 29109 | 2277 | 47 |
880350 | 880350 | 2020-12-30 | Lawrence | Ohio | 39087 | 3446 | 47 |
880545 | 880545 | 2020-12-30 | Lawrence | Pennsylvania | 42073 | 4209 | 126 |
880746 | 880746 | 2020-12-30 | Lawrence | South Dakota | 46081 | 2541 | 28 |
880822 | 880822 | 2020-12-30 | Lawrence | Tennessee | 47099 | 4369 | 57 |
875042 | 875042 | 2020-12-29 | Lawrence | Alabama | 1079 | 1978 | 42 |
875150 | 875150 | 2020-12-29 | Lawrence | Arkansas | 5075 | 1543 | 35 |
875653 | 875653 | 2020-12-29 | Lawrence | Illinois | 17101 | 1869 | 27 |
875751 | 875751 | 2020-12-29 | Lawrence | Indiana | 18093 | 3194 | 65 |
876066 | 876066 | 2020-12-29 | Lawrence | Kentucky | 21127 | 731 | 4 |
876455 | 876455 | 2020-12-29 | Lawrence | Mississippi | 28077 | 914 | 16 |
876555 | 876555 | 2020-12-29 | Lawrence | Missouri | 29109 | 2265 | 47 |
877105 | 877105 | 2020-12-29 | Lawrence | Ohio | 39087 | 3393 | 47 |
877300 | 877300 | 2020-12-29 | Lawrence | Pennsylvania | 42073 | 4162 | 121 |
877501 | 877501 | 2020-12-29 | Lawrence | South Dakota | 46081 | 2532 | 28 |
877577 | 877577 | 2020-12-29 | Lawrence | Tennessee | 47099 | 4310 | 57 |
871797 | 871797 | 2020-12-28 | Lawrence | Alabama | 1079 | 1958 | 42 |
871905 | 871905 | 2020-12-28 | Lawrence | Arkansas | 5075 | 1526 | 34 |
872408 | 872408 | 2020-12-28 | Lawrence | Illinois | 17101 | 1863 | 27 |
872506 | 872506 | 2020-12-28 | Lawrence | Indiana | 18093 | 3147 | 64 |
872821 | 872821 | 2020-12-28 | Lawrence | Kentucky | 21127 | 690 | 4 |
873210 | 873210 | 2020-12-28 | Lawrence | Mississippi | 28077 | 910 | 16 |
873310 | 873310 | 2020-12-28 | Lawrence | Missouri | 29109 | 2261 | 47 |
873860 | 873860 | 2020-12-28 | Lawrence | Ohio | 39087 | 3347 | 47 |
874055 | 874055 | 2020-12-28 | Lawrence | Pennsylvania | 42073 | 4081 | 121 |
874256 | 874256 | 2020-12-28 | Lawrence | South Dakota | 46081 | 2505 | 28 |
874332 | 874332 | 2020-12-28 | Lawrence | Tennessee | 47099 | 4294 | 57 |
868552 | 868552 | 2020-12-27 | Lawrence | Alabama | 1079 | 1939 | 42 |
868660 | 868660 | 2020-12-27 | Lawrence | Arkansas | 5075 | 1509 | 34 |
869163 | 869163 | 2020-12-27 | Lawrence | Illinois | 17101 | 1859 | 26 |
869261 | 869261 | 2020-12-27 | Lawrence | Indiana | 18093 | 3144 | 64 |
869576 | 869576 | 2020-12-27 | Lawrence | Kentucky | 21127 | 690 | 4 |
869965 | 869965 | 2020-12-27 | Lawrence | Mississippi | 28077 | 906 | 16 |
870065 | 870065 | 2020-12-27 | Lawrence | Missouri | 29109 | 2257 | 47 |
870615 | 870615 | 2020-12-27 | Lawrence | Ohio | 39087 | 3329 | 47 |
870810 | 870810 | 2020-12-27 | Lawrence | Pennsylvania | 42073 | 4062 | 121 |
871011 | 871011 | 2020-12-27 | Lawrence | South Dakota | 46081 | 2493 | 28 |
871087 | 871087 | 2020-12-27 | Lawrence | Tennessee | 47099 | 4266 | 57 |
865307 | 865307 | 2020-12-26 | Lawrence | Alabama | 1079 | 1924 | 42 |
865415 | 865415 | 2020-12-26 | Lawrence | Arkansas | 5075 | 1502 | 34 |
865918 | 865918 | 2020-12-26 | Lawrence | Illinois | 17101 | 1859 | 25 |
866016 | 866016 | 2020-12-26 | Lawrence | Indiana | 18093 | 3117 | 63 |
866331 | 866331 | 2020-12-26 | Lawrence | Kentucky | 21127 | 679 | 4 |
866720 | 866720 | 2020-12-26 | Lawrence | Mississippi | 28077 | 902 | 16 |
866820 | 866820 | 2020-12-26 | Lawrence | Missouri | 29109 | 2251 | 47 |
867370 | 867370 | 2020-12-26 | Lawrence | Ohio | 39087 | 3314 | 47 |
867565 | 867565 | 2020-12-26 | Lawrence | Pennsylvania | 42073 | 4051 | 120 |
867766 | 867766 | 2020-12-26 | Lawrence | South Dakota | 46081 | 2477 | 28 |
867842 | 867842 | 2020-12-26 | Lawrence | Tennessee | 47099 | 4243 | 55 |
862062 | 862062 | 2020-12-25 | Lawrence | Alabama | 1079 | 1921 | 42 |
862170 | 862170 | 2020-12-25 | Lawrence | Arkansas | 5075 | 1495 | 34 |
862673 | 862673 | 2020-12-25 | Lawrence | Illinois | 17101 | 1853 | 25 |
862771 | 862771 | 2020-12-25 | Lawrence | Indiana | 18093 | 3074 | 63 |
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);