⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,671 rows where county = "Lawrence" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);