ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,671 rows where county = "Lawrence" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state
- Mississippi 344
- Arkansas 340
- Indiana 340
- Alabama 339
- Ohio 339
- Pennsylvania 339
- South Dakota 337
- Tennessee 334
- Kentucky 333
- Illinois 326
- Missouri 300
fips
county
- Lawrence · 3,671 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1066527 | 1066527 | 2021-02-26 | Lawrence | Alabama | 1079 | 2822 | 84 |
1066635 | 1066635 | 2021-02-26 | Lawrence | Arkansas | 5075 | 2009 | 41 |
1067138 | 1067138 | 2021-02-26 | Lawrence | Illinois | 17101 | 2295 | 33 |
1067237 | 1067237 | 2021-02-26 | Lawrence | Indiana | 18093 | 4177 | 114 |
1067552 | 1067552 | 2021-02-26 | Lawrence | Kentucky | 21127 | 1251 | 20 |
1067940 | 1067940 | 2021-02-26 | Lawrence | Mississippi | 28077 | 1195 | 21 |
1068040 | 1068040 | 2021-02-26 | Lawrence | Missouri | 29109 | 2755 | 71 |
1068590 | 1068590 | 2021-02-26 | Lawrence | Ohio | 39087 | 5218 | 74 |
1068785 | 1068785 | 2021-02-26 | Lawrence | Pennsylvania | 42073 | 5998 | 182 |
1068986 | 1068986 | 2021-02-26 | Lawrence | South Dakota | 46081 | 2819 | 45 |
1069062 | 1069062 | 2021-02-26 | Lawrence | Tennessee | 47099 | 5556 | 82 |
1063282 | 1063282 | 2021-02-25 | Lawrence | Alabama | 1079 | 2813 | 84 |
1063390 | 1063390 | 2021-02-25 | Lawrence | Arkansas | 5075 | 2008 | 41 |
1063893 | 1063893 | 2021-02-25 | Lawrence | Illinois | 17101 | 2288 | 33 |
1063992 | 1063992 | 2021-02-25 | Lawrence | Indiana | 18093 | 4168 | 114 |
1064307 | 1064307 | 2021-02-25 | Lawrence | Kentucky | 21127 | 1240 | 20 |
1064695 | 1064695 | 2021-02-25 | Lawrence | Mississippi | 28077 | 1193 | 21 |
1064795 | 1064795 | 2021-02-25 | Lawrence | Missouri | 29109 | 2752 | 71 |
1065345 | 1065345 | 2021-02-25 | Lawrence | Ohio | 39087 | 5214 | 74 |
1065540 | 1065540 | 2021-02-25 | Lawrence | Pennsylvania | 42073 | 5969 | 181 |
1065741 | 1065741 | 2021-02-25 | Lawrence | South Dakota | 46081 | 2817 | 45 |
1065817 | 1065817 | 2021-02-25 | Lawrence | Tennessee | 47099 | 5551 | 81 |
1060037 | 1060037 | 2021-02-24 | Lawrence | Alabama | 1079 | 2812 | 84 |
1060145 | 1060145 | 2021-02-24 | Lawrence | Arkansas | 5075 | 2001 | 41 |
1060648 | 1060648 | 2021-02-24 | Lawrence | Illinois | 17101 | 2286 | 33 |
1060747 | 1060747 | 2021-02-24 | Lawrence | Indiana | 18093 | 4164 | 114 |
1061062 | 1061062 | 2021-02-24 | Lawrence | Kentucky | 21127 | 1232 | 19 |
1061451 | 1061451 | 2021-02-24 | Lawrence | Mississippi | 28077 | 1190 | 21 |
1061551 | 1061551 | 2021-02-24 | Lawrence | Missouri | 29109 | 2744 | 71 |
1062101 | 1062101 | 2021-02-24 | Lawrence | Ohio | 39087 | 5203 | 74 |
1062295 | 1062295 | 2021-02-24 | Lawrence | Pennsylvania | 42073 | 5961 | 181 |
1062496 | 1062496 | 2021-02-24 | Lawrence | South Dakota | 46081 | 2813 | 44 |
1062572 | 1062572 | 2021-02-24 | Lawrence | Tennessee | 47099 | 5546 | 81 |
1056791 | 1056791 | 2021-02-23 | Lawrence | Alabama | 1079 | 2806 | 85 |
1056899 | 1056899 | 2021-02-23 | Lawrence | Arkansas | 5075 | 1998 | 41 |
1057402 | 1057402 | 2021-02-23 | Lawrence | Illinois | 17101 | 2285 | 33 |
1057501 | 1057501 | 2021-02-23 | Lawrence | Indiana | 18093 | 4157 | 114 |
1057816 | 1057816 | 2021-02-23 | Lawrence | Kentucky | 21127 | 1220 | 18 |
1058205 | 1058205 | 2021-02-23 | Lawrence | Mississippi | 28077 | 1184 | 20 |
1058305 | 1058305 | 2021-02-23 | Lawrence | Missouri | 29109 | 2745 | 72 |
1058855 | 1058855 | 2021-02-23 | Lawrence | Ohio | 39087 | 5190 | 74 |
1059050 | 1059050 | 2021-02-23 | Lawrence | Pennsylvania | 42073 | 5944 | 181 |
1059251 | 1059251 | 2021-02-23 | Lawrence | South Dakota | 46081 | 2810 | 44 |
1059327 | 1059327 | 2021-02-23 | Lawrence | Tennessee | 47099 | 5540 | 80 |
1053545 | 1053545 | 2021-02-22 | Lawrence | Alabama | 1079 | 2798 | 85 |
1053653 | 1053653 | 2021-02-22 | Lawrence | Arkansas | 5075 | 1995 | 41 |
1054156 | 1054156 | 2021-02-22 | Lawrence | Illinois | 17101 | 2285 | 33 |
1054255 | 1054255 | 2021-02-22 | Lawrence | Indiana | 18093 | 4152 | 114 |
1054570 | 1054570 | 2021-02-22 | Lawrence | Kentucky | 21127 | 1202 | 18 |
1054959 | 1054959 | 2021-02-22 | Lawrence | Mississippi | 28077 | 1181 | 20 |
1055059 | 1055059 | 2021-02-22 | Lawrence | Missouri | 29109 | 2744 | 71 |
1055609 | 1055609 | 2021-02-22 | Lawrence | Ohio | 39087 | 5177 | 74 |
1055804 | 1055804 | 2021-02-22 | Lawrence | Pennsylvania | 42073 | 5929 | 180 |
1056005 | 1056005 | 2021-02-22 | Lawrence | South Dakota | 46081 | 2806 | 44 |
1056081 | 1056081 | 2021-02-22 | Lawrence | Tennessee | 47099 | 5536 | 80 |
1050298 | 1050298 | 2021-02-21 | Lawrence | Alabama | 1079 | 2795 | 85 |
1050406 | 1050406 | 2021-02-21 | Lawrence | Arkansas | 5075 | 1994 | 41 |
1050909 | 1050909 | 2021-02-21 | Lawrence | Illinois | 17101 | 2277 | 33 |
1051008 | 1051008 | 2021-02-21 | Lawrence | Indiana | 18093 | 4150 | 114 |
1051323 | 1051323 | 2021-02-21 | Lawrence | Kentucky | 21127 | 1201 | 18 |
1051712 | 1051712 | 2021-02-21 | Lawrence | Mississippi | 28077 | 1179 | 20 |
1051812 | 1051812 | 2021-02-21 | Lawrence | Missouri | 29109 | 2742 | 71 |
1052363 | 1052363 | 2021-02-21 | Lawrence | Ohio | 39087 | 5169 | 74 |
1052558 | 1052558 | 2021-02-21 | Lawrence | Pennsylvania | 42073 | 5925 | 180 |
1052759 | 1052759 | 2021-02-21 | Lawrence | South Dakota | 46081 | 2804 | 44 |
1052835 | 1052835 | 2021-02-21 | Lawrence | Tennessee | 47099 | 5531 | 80 |
1047051 | 1047051 | 2021-02-20 | Lawrence | Alabama | 1079 | 2794 | 85 |
1047159 | 1047159 | 2021-02-20 | Lawrence | Arkansas | 5075 | 1994 | 41 |
1047662 | 1047662 | 2021-02-20 | Lawrence | Illinois | 17101 | 2278 | 33 |
1047761 | 1047761 | 2021-02-20 | Lawrence | Indiana | 18093 | 4144 | 114 |
1048076 | 1048076 | 2021-02-20 | Lawrence | Kentucky | 21127 | 1198 | 17 |
1048465 | 1048465 | 2021-02-20 | Lawrence | Mississippi | 28077 | 1180 | 20 |
1048565 | 1048565 | 2021-02-20 | Lawrence | Missouri | 29109 | 2741 | 71 |
1049116 | 1049116 | 2021-02-20 | Lawrence | Ohio | 39087 | 5151 | 74 |
1049311 | 1049311 | 2021-02-20 | Lawrence | Pennsylvania | 42073 | 5915 | 180 |
1049512 | 1049512 | 2021-02-20 | Lawrence | South Dakota | 46081 | 2801 | 44 |
1049588 | 1049588 | 2021-02-20 | Lawrence | Tennessee | 47099 | 5531 | 80 |
1043806 | 1043806 | 2021-02-19 | Lawrence | Alabama | 1079 | 2790 | 85 |
1043914 | 1043914 | 2021-02-19 | Lawrence | Arkansas | 5075 | 1991 | 41 |
1044417 | 1044417 | 2021-02-19 | Lawrence | Illinois | 17101 | 2276 | 33 |
1044516 | 1044516 | 2021-02-19 | Lawrence | Indiana | 18093 | 4135 | 114 |
1044831 | 1044831 | 2021-02-19 | Lawrence | Kentucky | 21127 | 1195 | 17 |
1045219 | 1045219 | 2021-02-19 | Lawrence | Mississippi | 28077 | 1178 | 20 |
1045319 | 1045319 | 2021-02-19 | Lawrence | Missouri | 29109 | 2740 | 71 |
1045869 | 1045869 | 2021-02-19 | Lawrence | Ohio | 39087 | 5130 | 74 |
1046064 | 1046064 | 2021-02-19 | Lawrence | Pennsylvania | 42073 | 5895 | 179 |
1046265 | 1046265 | 2021-02-19 | Lawrence | South Dakota | 46081 | 2799 | 44 |
1046341 | 1046341 | 2021-02-19 | Lawrence | Tennessee | 47099 | 5528 | 79 |
1040561 | 1040561 | 2021-02-18 | Lawrence | Alabama | 1079 | 2787 | 85 |
1040669 | 1040669 | 2021-02-18 | Lawrence | Arkansas | 5075 | 1989 | 41 |
1041172 | 1041172 | 2021-02-18 | Lawrence | Illinois | 17101 | 2265 | 33 |
1041271 | 1041271 | 2021-02-18 | Lawrence | Indiana | 18093 | 4134 | 114 |
1041586 | 1041586 | 2021-02-18 | Lawrence | Kentucky | 21127 | 1193 | 17 |
1041974 | 1041974 | 2021-02-18 | Lawrence | Mississippi | 28077 | 1177 | 20 |
1042074 | 1042074 | 2021-02-18 | Lawrence | Missouri | 29109 | 2737 | 71 |
1042624 | 1042624 | 2021-02-18 | Lawrence | Ohio | 39087 | 5117 | 73 |
1042819 | 1042819 | 2021-02-18 | Lawrence | Pennsylvania | 42073 | 5869 | 178 |
1043020 | 1043020 | 2021-02-18 | Lawrence | South Dakota | 46081 | 2795 | 44 |
1043096 | 1043096 | 2021-02-18 | Lawrence | Tennessee | 47099 | 5527 | 79 |
1037316 | 1037316 | 2021-02-17 | Lawrence | Alabama | 1079 | 2781 | 85 |
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]);