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 383
- Arkansas 379
- Indiana 379
- Alabama 378
- Ohio 378
- Pennsylvania 378
- South Dakota 376
- Tennessee 373
- Kentucky 372
- Illinois 365
- Missouri 339
fips 11
county 1
- Lawrence · 4,100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193148 | 1193148 | 2021-04-06 | Lawrence | Alabama | 1079 | 2938 | 94 |
1193256 | 1193256 | 2021-04-06 | Lawrence | Arkansas | 5075 | 2071 | 43 |
1193759 | 1193759 | 2021-04-06 | Lawrence | Illinois | 17101 | 2383 | 33 |
1193858 | 1193858 | 2021-04-06 | Lawrence | Indiana | 18093 | 4271 | 120 |
1194173 | 1194173 | 2021-04-06 | Lawrence | Kentucky | 21127 | 1351 | 20 |
1194561 | 1194561 | 2021-04-06 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1194661 | 1194661 | 2021-04-06 | Lawrence | Missouri | 29109 | 3412 | 78 |
1195212 | 1195212 | 2021-04-06 | Lawrence | Ohio | 39087 | 5417 | 98 |
1195408 | 1195408 | 2021-04-06 | Lawrence | Pennsylvania | 42073 | 6759 | 195 |
1195609 | 1195609 | 2021-04-06 | Lawrence | South Dakota | 46081 | 2902 | 45 |
1195685 | 1195685 | 2021-04-06 | Lawrence | Tennessee | 47099 | 5720 | 86 |
1189898 | 1189898 | 2021-04-05 | Lawrence | Alabama | 1079 | 2932 | 94 |
1190006 | 1190006 | 2021-04-05 | Lawrence | Arkansas | 5075 | 2069 | 43 |
1190509 | 1190509 | 2021-04-05 | Lawrence | Illinois | 17101 | 2378 | 33 |
1190608 | 1190608 | 2021-04-05 | Lawrence | Indiana | 18093 | 4266 | 120 |
1190923 | 1190923 | 2021-04-05 | Lawrence | Kentucky | 21127 | 1351 | 20 |
1191312 | 1191312 | 2021-04-05 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1191412 | 1191412 | 2021-04-05 | Lawrence | Missouri | 29109 | 3411 | 78 |
1191964 | 1191964 | 2021-04-05 | Lawrence | Ohio | 39087 | 5412 | 98 |
1192160 | 1192160 | 2021-04-05 | Lawrence | Pennsylvania | 42073 | 6731 | 195 |
1192361 | 1192361 | 2021-04-05 | Lawrence | South Dakota | 46081 | 2900 | 45 |
1192437 | 1192437 | 2021-04-05 | Lawrence | Tennessee | 47099 | 5717 | 86 |
1186651 | 1186651 | 2021-04-04 | Lawrence | Alabama | 1079 | 2932 | 94 |
1186759 | 1186759 | 2021-04-04 | Lawrence | Arkansas | 5075 | 2069 | 43 |
1187262 | 1187262 | 2021-04-04 | Lawrence | Illinois | 17101 | 2378 | 33 |
1187361 | 1187361 | 2021-04-04 | Lawrence | Indiana | 18093 | 4263 | 120 |
1187676 | 1187676 | 2021-04-04 | Lawrence | Kentucky | 21127 | 1350 | 20 |
1188064 | 1188064 | 2021-04-04 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1188164 | 1188164 | 2021-04-04 | Lawrence | Missouri | 29109 | 3411 | 78 |
1188715 | 1188715 | 2021-04-04 | Lawrence | Ohio | 39087 | 5404 | 98 |
1188911 | 1188911 | 2021-04-04 | Lawrence | Pennsylvania | 42073 | 6725 | 195 |
1189112 | 1189112 | 2021-04-04 | Lawrence | South Dakota | 46081 | 2897 | 45 |
1189188 | 1189188 | 2021-04-04 | Lawrence | Tennessee | 47099 | 5703 | 86 |
1183404 | 1183404 | 2021-04-03 | Lawrence | Alabama | 1079 | 2932 | 94 |
1183512 | 1183512 | 2021-04-03 | Lawrence | Arkansas | 5075 | 2069 | 43 |
1184015 | 1184015 | 2021-04-03 | Lawrence | Illinois | 17101 | 2379 | 33 |
1184114 | 1184114 | 2021-04-03 | Lawrence | Indiana | 18093 | 4262 | 120 |
1184429 | 1184429 | 2021-04-03 | Lawrence | Kentucky | 21127 | 1350 | 20 |
1184817 | 1184817 | 2021-04-03 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1184917 | 1184917 | 2021-04-03 | Lawrence | Missouri | 29109 | 3409 | 78 |
1185468 | 1185468 | 2021-04-03 | Lawrence | Ohio | 39087 | 5404 | 98 |
1185664 | 1185664 | 2021-04-03 | Lawrence | Pennsylvania | 42073 | 6708 | 195 |
1185865 | 1185865 | 2021-04-03 | Lawrence | South Dakota | 46081 | 2897 | 45 |
1185941 | 1185941 | 2021-04-03 | Lawrence | Tennessee | 47099 | 5703 | 86 |
1180157 | 1180157 | 2021-04-02 | Lawrence | Alabama | 1079 | 2931 | 94 |
1180265 | 1180265 | 2021-04-02 | Lawrence | Arkansas | 5075 | 2069 | 43 |
1180768 | 1180768 | 2021-04-02 | Lawrence | Illinois | 17101 | 2376 | 33 |
1180867 | 1180867 | 2021-04-02 | Lawrence | Indiana | 18093 | 4261 | 120 |
1181182 | 1181182 | 2021-04-02 | Lawrence | Kentucky | 21127 | 1348 | 20 |
1181571 | 1181571 | 2021-04-02 | Lawrence | Mississippi | 28077 | 1256 | 23 |
1181671 | 1181671 | 2021-04-02 | Lawrence | Missouri | 29109 | 3408 | 78 |
1182221 | 1182221 | 2021-04-02 | Lawrence | Ohio | 39087 | 5398 | 98 |
1182417 | 1182417 | 2021-04-02 | Lawrence | Pennsylvania | 42073 | 6664 | 195 |
1182618 | 1182618 | 2021-04-02 | Lawrence | South Dakota | 46081 | 2895 | 45 |
1182694 | 1182694 | 2021-04-02 | Lawrence | Tennessee | 47099 | 5703 | 86 |
1176910 | 1176910 | 2021-04-01 | Lawrence | Alabama | 1079 | 2928 | 94 |
1177018 | 1177018 | 2021-04-01 | Lawrence | Arkansas | 5075 | 2069 | 43 |
1177521 | 1177521 | 2021-04-01 | Lawrence | Illinois | 17101 | 2372 | 33 |
1177620 | 1177620 | 2021-04-01 | Lawrence | Indiana | 18093 | 4258 | 120 |
1177935 | 1177935 | 2021-04-01 | Lawrence | Kentucky | 21127 | 1345 | 20 |
1178324 | 1178324 | 2021-04-01 | Lawrence | Mississippi | 28077 | 1255 | 23 |
1178424 | 1178424 | 2021-04-01 | Lawrence | Missouri | 29109 | 3408 | 78 |
1178974 | 1178974 | 2021-04-01 | Lawrence | Ohio | 39087 | 5392 | 98 |
1179170 | 1179170 | 2021-04-01 | Lawrence | Pennsylvania | 42073 | 6633 | 194 |
1179371 | 1179371 | 2021-04-01 | Lawrence | South Dakota | 46081 | 2892 | 45 |
1179447 | 1179447 | 2021-04-01 | Lawrence | Tennessee | 47099 | 5703 | 86 |
1173663 | 1173663 | 2021-03-31 | Lawrence | Alabama | 1079 | 2926 | 94 |
1173771 | 1173771 | 2021-03-31 | Lawrence | Arkansas | 5075 | 2069 | 43 |
1174274 | 1174274 | 2021-03-31 | Lawrence | Illinois | 17101 | 2371 | 33 |
1174373 | 1174373 | 2021-03-31 | Lawrence | Indiana | 18093 | 4264 | 120 |
1174688 | 1174688 | 2021-03-31 | Lawrence | Kentucky | 21127 | 1342 | 20 |
1175077 | 1175077 | 2021-03-31 | Lawrence | Mississippi | 28077 | 1251 | 23 |
1175177 | 1175177 | 2021-03-31 | Lawrence | Missouri | 29109 | 3407 | 79 |
1175727 | 1175727 | 2021-03-31 | Lawrence | Ohio | 39087 | 5386 | 98 |
1175923 | 1175923 | 2021-03-31 | Lawrence | Pennsylvania | 42073 | 6612 | 194 |
1176124 | 1176124 | 2021-03-31 | Lawrence | South Dakota | 46081 | 2887 | 45 |
1176200 | 1176200 | 2021-03-31 | Lawrence | Tennessee | 47099 | 5695 | 86 |
1170416 | 1170416 | 2021-03-30 | Lawrence | Alabama | 1079 | 2926 | 94 |
1170524 | 1170524 | 2021-03-30 | Lawrence | Arkansas | 5075 | 2069 | 42 |
1171027 | 1171027 | 2021-03-30 | Lawrence | Illinois | 17101 | 2369 | 33 |
1171126 | 1171126 | 2021-03-30 | Lawrence | Indiana | 18093 | 4262 | 120 |
1171441 | 1171441 | 2021-03-30 | Lawrence | Kentucky | 21127 | 1336 | 20 |
1171830 | 1171830 | 2021-03-30 | Lawrence | Mississippi | 28077 | 1250 | 22 |
1171930 | 1171930 | 2021-03-30 | Lawrence | Missouri | 29109 | 3404 | 79 |
1172480 | 1172480 | 2021-03-30 | Lawrence | Ohio | 39087 | 5377 | 98 |
1172676 | 1172676 | 2021-03-30 | Lawrence | Pennsylvania | 42073 | 6583 | 194 |
1172877 | 1172877 | 2021-03-30 | Lawrence | South Dakota | 46081 | 2887 | 45 |
1172953 | 1172953 | 2021-03-30 | Lawrence | Tennessee | 47099 | 5690 | 86 |
1167168 | 1167168 | 2021-03-29 | Lawrence | Alabama | 1079 | 2922 | 94 |
1167276 | 1167276 | 2021-03-29 | Lawrence | Arkansas | 5075 | 2065 | 42 |
1167779 | 1167779 | 2021-03-29 | Lawrence | Illinois | 17101 | 2366 | 33 |
1167878 | 1167878 | 2021-03-29 | Lawrence | Indiana | 18093 | 4258 | 120 |
1168193 | 1168193 | 2021-03-29 | Lawrence | Kentucky | 21127 | 1329 | 20 |
1168582 | 1168582 | 2021-03-29 | Lawrence | Mississippi | 28077 | 1249 | 22 |
1168682 | 1168682 | 2021-03-29 | Lawrence | Missouri | 29109 | 3402 | 79 |
1169233 | 1169233 | 2021-03-29 | Lawrence | Ohio | 39087 | 5371 | 98 |
1169429 | 1169429 | 2021-03-29 | Lawrence | Pennsylvania | 42073 | 6563 | 194 |
1169630 | 1169630 | 2021-03-29 | Lawrence | South Dakota | 46081 | 2886 | 45 |
1169706 | 1169706 | 2021-03-29 | Lawrence | Tennessee | 47099 | 5685 | 86 |
1163920 | 1163920 | 2021-03-28 | Lawrence | Alabama | 1079 | 2918 | 94 |
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);