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 340
- Arkansas 336
- Indiana 336
- Ohio 335
- Pennsylvania 335
- Alabama 334
- South Dakota 333
- Tennessee 330
- Kentucky 329
- Illinois 322
- Missouri 296
fips 11
county 1
- Lawrence · 3,626 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1037424 | 1037424 | 2021-02-17 | Lawrence | Arkansas | 5075 | 1987 | 41 |
1037927 | 1037927 | 2021-02-17 | Lawrence | Illinois | 17101 | 2260 | 33 |
1038026 | 1038026 | 2021-02-17 | Lawrence | Indiana | 18093 | 4131 | 114 |
1038341 | 1038341 | 2021-02-17 | Lawrence | Kentucky | 21127 | 1193 | 17 |
1038729 | 1038729 | 2021-02-17 | Lawrence | Mississippi | 28077 | 1176 | 20 |
1038829 | 1038829 | 2021-02-17 | Lawrence | Missouri | 29109 | 2736 | 68 |
1039379 | 1039379 | 2021-02-17 | Lawrence | Ohio | 39087 | 5105 | 71 |
1039574 | 1039574 | 2021-02-17 | Lawrence | Pennsylvania | 42073 | 5849 | 178 |
1039775 | 1039775 | 2021-02-17 | Lawrence | South Dakota | 46081 | 2793 | 44 |
1039851 | 1039851 | 2021-02-17 | Lawrence | Tennessee | 47099 | 5524 | 79 |
1034071 | 1034071 | 2021-02-16 | Lawrence | Alabama | 1079 | 2781 | 84 |
1034179 | 1034179 | 2021-02-16 | Lawrence | Arkansas | 5075 | 1986 | 41 |
1034682 | 1034682 | 2021-02-16 | Lawrence | Illinois | 17101 | 2260 | 33 |
1034781 | 1034781 | 2021-02-16 | Lawrence | Indiana | 18093 | 4131 | 114 |
1035096 | 1035096 | 2021-02-16 | Lawrence | Kentucky | 21127 | 1187 | 17 |
1035484 | 1035484 | 2021-02-16 | Lawrence | Mississippi | 28077 | 1176 | 20 |
1035584 | 1035584 | 2021-02-16 | Lawrence | Missouri | 29109 | 2734 | 68 |
1036134 | 1036134 | 2021-02-16 | Lawrence | Ohio | 39087 | 5102 | 70 |
1036329 | 1036329 | 2021-02-16 | Lawrence | Pennsylvania | 42073 | 5831 | 177 |
1036530 | 1036530 | 2021-02-16 | Lawrence | South Dakota | 46081 | 2792 | 44 |
1036606 | 1036606 | 2021-02-16 | Lawrence | Tennessee | 47099 | 5524 | 79 |
1030825 | 1030825 | 2021-02-15 | Lawrence | Alabama | 1079 | 2780 | 84 |
1030933 | 1030933 | 2021-02-15 | Lawrence | Arkansas | 5075 | 1985 | 41 |
1031436 | 1031436 | 2021-02-15 | Lawrence | Illinois | 17101 | 2259 | 33 |
1031535 | 1031535 | 2021-02-15 | Lawrence | Indiana | 18093 | 4124 | 114 |
1031850 | 1031850 | 2021-02-15 | Lawrence | Kentucky | 21127 | 1184 | 17 |
1032239 | 1032239 | 2021-02-15 | Lawrence | Mississippi | 28077 | 1172 | 19 |
1032339 | 1032339 | 2021-02-15 | Lawrence | Missouri | 29109 | 2731 | 68 |
1032889 | 1032889 | 2021-02-15 | Lawrence | Ohio | 39087 | 5095 | 70 |
1033084 | 1033084 | 2021-02-15 | Lawrence | Pennsylvania | 42073 | 5814 | 177 |
1033285 | 1033285 | 2021-02-15 | Lawrence | South Dakota | 46081 | 2790 | 44 |
1033361 | 1033361 | 2021-02-15 | Lawrence | Tennessee | 47099 | 5510 | 79 |
1027578 | 1027578 | 2021-02-14 | Lawrence | Alabama | 1079 | 2777 | 84 |
1027686 | 1027686 | 2021-02-14 | Lawrence | Arkansas | 5075 | 1985 | 41 |
1028189 | 1028189 | 2021-02-14 | Lawrence | Illinois | 17101 | 2259 | 33 |
1028288 | 1028288 | 2021-02-14 | Lawrence | Indiana | 18093 | 4119 | 114 |
1028603 | 1028603 | 2021-02-14 | Lawrence | Kentucky | 21127 | 1184 | 17 |
1028992 | 1028992 | 2021-02-14 | Lawrence | Mississippi | 28077 | 1171 | 19 |
1029092 | 1029092 | 2021-02-14 | Lawrence | Missouri | 29109 | 2729 | 68 |
1029643 | 1029643 | 2021-02-14 | Lawrence | Ohio | 39087 | 5082 | 70 |
1029838 | 1029838 | 2021-02-14 | Lawrence | Pennsylvania | 42073 | 5800 | 177 |
1030039 | 1030039 | 2021-02-14 | Lawrence | South Dakota | 46081 | 2789 | 44 |
1030115 | 1030115 | 2021-02-14 | Lawrence | Tennessee | 47099 | 5502 | 79 |
1024333 | 1024333 | 2021-02-13 | Lawrence | Alabama | 1079 | 2771 | 84 |
1024441 | 1024441 | 2021-02-13 | Lawrence | Arkansas | 5075 | 1985 | 41 |
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);