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 565
- Indiana 561
- Arkansas 560
- Ohio 560
- Pennsylvania 560
- Alabama 559
- South Dakota 558
- Tennessee 555
- Kentucky 554
- Illinois 547
- Missouri 521
fips 11
county 1
- Lawrence · 6,100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1784776 | 1784776 | 2021-10-05 | Lawrence | Illinois | 17101 | 3174 | 41 |
1784875 | 1784875 | 2021-10-05 | Lawrence | Indiana | 18093 | 7249 | 169 |
1785189 | 1785189 | 2021-10-05 | Lawrence | Kentucky | 21127 | 2442 | 37 |
1785578 | 1785578 | 2021-10-05 | Lawrence | Mississippi | 28077 | 2087 | 37 |
1785678 | 1785678 | 2021-10-05 | Lawrence | Missouri | 29109 | 5060 | 104 |
1786229 | 1786229 | 2021-10-05 | Lawrence | Ohio | 39087 | 9333 | 136 |
1786425 | 1786425 | 2021-10-05 | Lawrence | Pennsylvania | 42073 | 9910 | 243 |
1786626 | 1786626 | 2021-10-05 | Lawrence | South Dakota | 46081 | 4120 | 54 |
1786702 | 1786702 | 2021-10-05 | Lawrence | Tennessee | 47099 | 9253 | 114 |
1780914 | 1780914 | 2021-10-04 | Lawrence | Alabama | 1079 | 4176 | 109 |
1781023 | 1781023 | 2021-10-04 | Lawrence | Arkansas | 5075 | 3160 | 53 |
1781527 | 1781527 | 2021-10-04 | Lawrence | Illinois | 17101 | 3159 | 41 |
1781626 | 1781626 | 2021-10-04 | Lawrence | Indiana | 18093 | 7224 | 168 |
1781940 | 1781940 | 2021-10-04 | Lawrence | Kentucky | 21127 | 2418 | 37 |
1782329 | 1782329 | 2021-10-04 | Lawrence | Mississippi | 28077 | 2085 | 36 |
1782429 | 1782429 | 2021-10-04 | Lawrence | Missouri | 29109 | 5061 | 104 |
1782980 | 1782980 | 2021-10-04 | Lawrence | Ohio | 39087 | 9307 | 126 |
1783176 | 1783176 | 2021-10-04 | Lawrence | Pennsylvania | 42073 | 9886 | 243 |
1783377 | 1783377 | 2021-10-04 | Lawrence | South Dakota | 46081 | 4097 | 55 |
1783453 | 1783453 | 2021-10-04 | Lawrence | Tennessee | 47099 | 9243 | 114 |
1777664 | 1777664 | 2021-10-03 | Lawrence | Alabama | 1079 | 4173 | 109 |
1777773 | 1777773 | 2021-10-03 | Lawrence | Arkansas | 5075 | 3160 | 53 |
1778277 | 1778277 | 2021-10-03 | Lawrence | Illinois | 17101 | 3149 | 41 |
1778376 | 1778376 | 2021-10-03 | Lawrence | Indiana | 18093 | 7176 | 167 |
1778690 | 1778690 | 2021-10-03 | Lawrence | Kentucky | 21127 | 2400 | 36 |
1779079 | 1779079 | 2021-10-03 | Lawrence | Mississippi | 28077 | 2080 | 36 |
1779179 | 1779179 | 2021-10-03 | Lawrence | Missouri | 29109 | 5053 | 104 |
1779731 | 1779731 | 2021-10-03 | Lawrence | Ohio | 39087 | 9294 | 126 |
1779927 | 1779927 | 2021-10-03 | Lawrence | Pennsylvania | 42073 | 9854 | 243 |
1780128 | 1780128 | 2021-10-03 | Lawrence | South Dakota | 46081 | 4083 | 54 |
1780204 | 1780204 | 2021-10-03 | Lawrence | Tennessee | 47099 | 9197 | 113 |
1774414 | 1774414 | 2021-10-02 | Lawrence | Alabama | 1079 | 4168 | 109 |
1774523 | 1774523 | 2021-10-02 | Lawrence | Arkansas | 5075 | 3154 | 53 |
1775027 | 1775027 | 2021-10-02 | Lawrence | Illinois | 17101 | 3149 | 41 |
1775126 | 1775126 | 2021-10-02 | Lawrence | Indiana | 18093 | 7176 | 167 |
1775440 | 1775440 | 2021-10-02 | Lawrence | Kentucky | 21127 | 2400 | 36 |
1775829 | 1775829 | 2021-10-02 | Lawrence | Mississippi | 28077 | 2080 | 36 |
1775929 | 1775929 | 2021-10-02 | Lawrence | Missouri | 29109 | 5048 | 104 |
1776481 | 1776481 | 2021-10-02 | Lawrence | Ohio | 39087 | 9270 | 126 |
1776677 | 1776677 | 2021-10-02 | Lawrence | Pennsylvania | 42073 | 9797 | 243 |
1776878 | 1776878 | 2021-10-02 | Lawrence | South Dakota | 46081 | 4083 | 54 |
1776954 | 1776954 | 2021-10-02 | Lawrence | Tennessee | 47099 | 9197 | 113 |
1771164 | 1771164 | 2021-10-01 | Lawrence | Alabama | 1079 | 4154 | 108 |
1771273 | 1771273 | 2021-10-01 | Lawrence | Arkansas | 5075 | 3145 | 53 |
1771777 | 1771777 | 2021-10-01 | Lawrence | Illinois | 17101 | 3149 | 41 |
1771876 | 1771876 | 2021-10-01 | Lawrence | Indiana | 18093 | 7176 | 167 |
1772190 | 1772190 | 2021-10-01 | Lawrence | Kentucky | 21127 | 2400 | 36 |
1772579 | 1772579 | 2021-10-01 | Lawrence | Mississippi | 28077 | 2080 | 36 |
1772679 | 1772679 | 2021-10-01 | Lawrence | Missouri | 29109 | 5046 | 104 |
1773231 | 1773231 | 2021-10-01 | Lawrence | Ohio | 39087 | 9239 | 126 |
1773427 | 1773427 | 2021-10-01 | Lawrence | Pennsylvania | 42073 | 9766 | 242 |
1773628 | 1773628 | 2021-10-01 | Lawrence | South Dakota | 46081 | 4083 | 54 |
1773704 | 1773704 | 2021-10-01 | Lawrence | Tennessee | 47099 | 9197 | 113 |
1767915 | 1767915 | 2021-09-30 | Lawrence | Alabama | 1079 | 4142 | 108 |
1768024 | 1768024 | 2021-09-30 | Lawrence | Arkansas | 5075 | 3135 | 52 |
1768528 | 1768528 | 2021-09-30 | Lawrence | Illinois | 17101 | 3137 | 41 |
1768627 | 1768627 | 2021-09-30 | Lawrence | Indiana | 18093 | 7161 | 164 |
1768941 | 1768941 | 2021-09-30 | Lawrence | Kentucky | 21127 | 2377 | 36 |
1769330 | 1769330 | 2021-09-30 | Lawrence | Mississippi | 28077 | 2079 | 36 |
1769430 | 1769430 | 2021-09-30 | Lawrence | Missouri | 29109 | 5035 | 104 |
1769981 | 1769981 | 2021-09-30 | Lawrence | Ohio | 39087 | 9171 | 126 |
1770177 | 1770177 | 2021-09-30 | Lawrence | Pennsylvania | 42073 | 9721 | 241 |
1770378 | 1770378 | 2021-09-30 | Lawrence | South Dakota | 46081 | 4070 | 54 |
1770454 | 1770454 | 2021-09-30 | Lawrence | Tennessee | 47099 | 9161 | 113 |
1764666 | 1764666 | 2021-09-29 | Lawrence | Alabama | 1079 | 4132 | 108 |
1764775 | 1764775 | 2021-09-29 | Lawrence | Arkansas | 5075 | 3128 | 52 |
1765279 | 1765279 | 2021-09-29 | Lawrence | Illinois | 17101 | 3114 | 41 |
1765378 | 1765378 | 2021-09-29 | Lawrence | Indiana | 18093 | 7136 | 164 |
1765692 | 1765692 | 2021-09-29 | Lawrence | Kentucky | 21127 | 2366 | 36 |
1766081 | 1766081 | 2021-09-29 | Lawrence | Mississippi | 28077 | 2076 | 36 |
1766181 | 1766181 | 2021-09-29 | Lawrence | Missouri | 29109 | 5026 | 104 |
1766732 | 1766732 | 2021-09-29 | Lawrence | Ohio | 39087 | 9136 | 126 |
1766928 | 1766928 | 2021-09-29 | Lawrence | Pennsylvania | 42073 | 9659 | 241 |
1767129 | 1767129 | 2021-09-29 | Lawrence | South Dakota | 46081 | 4049 | 53 |
1767205 | 1767205 | 2021-09-29 | Lawrence | Tennessee | 47099 | 9126 | 113 |
1761417 | 1761417 | 2021-09-28 | Lawrence | Alabama | 1079 | 4127 | 108 |
1761526 | 1761526 | 2021-09-28 | Lawrence | Arkansas | 5075 | 3117 | 50 |
1762030 | 1762030 | 2021-09-28 | Lawrence | Illinois | 17101 | 3079 | 41 |
1762129 | 1762129 | 2021-09-28 | Lawrence | Indiana | 18093 | 7109 | 161 |
1762443 | 1762443 | 2021-09-28 | Lawrence | Kentucky | 21127 | 2347 | 36 |
1762832 | 1762832 | 2021-09-28 | Lawrence | Mississippi | 28077 | 2074 | 35 |
1762932 | 1762932 | 2021-09-28 | Lawrence | Missouri | 29109 | 5017 | 104 |
1763483 | 1763483 | 2021-09-28 | Lawrence | Ohio | 39087 | 9079 | 126 |
1763679 | 1763679 | 2021-09-28 | Lawrence | Pennsylvania | 42073 | 9611 | 239 |
1763880 | 1763880 | 2021-09-28 | Lawrence | South Dakota | 46081 | 4012 | 53 |
1763956 | 1763956 | 2021-09-28 | Lawrence | Tennessee | 47099 | 9083 | 113 |
1758169 | 1758169 | 2021-09-27 | Lawrence | Alabama | 1079 | 4124 | 108 |
1758278 | 1758278 | 2021-09-27 | Lawrence | Arkansas | 5075 | 3115 | 50 |
1758782 | 1758782 | 2021-09-27 | Lawrence | Illinois | 17101 | 3054 | 41 |
1758881 | 1758881 | 2021-09-27 | Lawrence | Indiana | 18093 | 7083 | 157 |
1759195 | 1759195 | 2021-09-27 | Lawrence | Kentucky | 21127 | 2327 | 36 |
1759583 | 1759583 | 2021-09-27 | Lawrence | Mississippi | 28077 | 2070 | 34 |
1759683 | 1759683 | 2021-09-27 | Lawrence | Missouri | 29109 | 5011 | 102 |
1760234 | 1760234 | 2021-09-27 | Lawrence | Ohio | 39087 | 9005 | 125 |
1760430 | 1760430 | 2021-09-27 | Lawrence | Pennsylvania | 42073 | 9543 | 239 |
1760631 | 1760631 | 2021-09-27 | Lawrence | South Dakota | 46081 | 3988 | 53 |
1760707 | 1760707 | 2021-09-27 | Lawrence | Tennessee | 47099 | 9052 | 110 |
1754921 | 1754921 | 2021-09-26 | Lawrence | Alabama | 1079 | 4117 | 108 |
1755030 | 1755030 | 2021-09-26 | Lawrence | Arkansas | 5075 | 3107 | 50 |
1755534 | 1755534 | 2021-09-26 | Lawrence | Illinois | 17101 | 3034 | 40 |
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);