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 134
- Arkansas 130
- Indiana 130
- Ohio 129
- Pennsylvania 129
- Alabama 128
- South Dakota 127
- Tennessee 124
- Kentucky 123
- Illinois 116
- Missouri 90
fips 11
county 1
- Lawrence · 1,360 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386086 | 386086 | 2020-07-31 | Lawrence | Arkansas | 5075 | 179 | 9 |
386585 | 386585 | 2020-07-31 | Lawrence | Illinois | 17101 | 40 | 0 |
386684 | 386684 | 2020-07-31 | Lawrence | Indiana | 18093 | 318 | 28 |
386996 | 386996 | 2020-07-31 | Lawrence | Kentucky | 21127 | 32 | 0 |
387385 | 387385 | 2020-07-31 | Lawrence | Mississippi | 28077 | 300 | 5 |
387485 | 387485 | 2020-07-31 | Lawrence | Missouri | 29109 | 182 | 2 |
388020 | 388020 | 2020-07-31 | Lawrence | Ohio | 39087 | 206 | 0 |
388213 | 388213 | 2020-07-31 | Lawrence | Pennsylvania | 42073 | 338 | 11 |
388413 | 388413 | 2020-07-31 | Lawrence | South Dakota | 46081 | 26 | 0 |
388489 | 388489 | 2020-07-31 | Lawrence | Tennessee | 47099 | 444 | 6 |
382761 | 382761 | 2020-07-30 | Lawrence | Alabama | 1079 | 286 | 0 |
382868 | 382868 | 2020-07-30 | Lawrence | Arkansas | 5075 | 173 | 9 |
383367 | 383367 | 2020-07-30 | Lawrence | Illinois | 17101 | 41 | 0 |
383466 | 383466 | 2020-07-30 | Lawrence | Indiana | 18093 | 312 | 28 |
383778 | 383778 | 2020-07-30 | Lawrence | Kentucky | 21127 | 32 | 0 |
384167 | 384167 | 2020-07-30 | Lawrence | Mississippi | 28077 | 297 | 4 |
384267 | 384267 | 2020-07-30 | Lawrence | Missouri | 29109 | 172 | 2 |
384803 | 384803 | 2020-07-30 | Lawrence | Ohio | 39087 | 199 | 0 |
384996 | 384996 | 2020-07-30 | Lawrence | Pennsylvania | 42073 | 324 | 11 |
385196 | 385196 | 2020-07-30 | Lawrence | South Dakota | 46081 | 26 | 0 |
385272 | 385272 | 2020-07-30 | Lawrence | Tennessee | 47099 | 421 | 6 |
379544 | 379544 | 2020-07-29 | Lawrence | Alabama | 1079 | 272 | 0 |
379651 | 379651 | 2020-07-29 | Lawrence | Arkansas | 5075 | 169 | 9 |
380150 | 380150 | 2020-07-29 | Lawrence | Illinois | 17101 | 39 | 0 |
380249 | 380249 | 2020-07-29 | Lawrence | Indiana | 18093 | 308 | 28 |
380561 | 380561 | 2020-07-29 | Lawrence | Kentucky | 21127 | 32 | 0 |
380950 | 380950 | 2020-07-29 | Lawrence | Mississippi | 28077 | 284 | 3 |
381051 | 381051 | 2020-07-29 | Lawrence | Missouri | 29109 | 159 | 2 |
381585 | 381585 | 2020-07-29 | Lawrence | Ohio | 39087 | 198 | 0 |
381778 | 381778 | 2020-07-29 | Lawrence | Pennsylvania | 42073 | 319 | 11 |
381978 | 381978 | 2020-07-29 | Lawrence | South Dakota | 46081 | 26 | 0 |
382054 | 382054 | 2020-07-29 | Lawrence | Tennessee | 47099 | 408 | 6 |
376328 | 376328 | 2020-07-28 | Lawrence | Alabama | 1079 | 265 | 0 |
376435 | 376435 | 2020-07-28 | Lawrence | Arkansas | 5075 | 162 | 9 |
376933 | 376933 | 2020-07-28 | Lawrence | Illinois | 17101 | 38 | 0 |
377032 | 377032 | 2020-07-28 | Lawrence | Indiana | 18093 | 301 | 28 |
377344 | 377344 | 2020-07-28 | Lawrence | Kentucky | 21127 | 31 | 0 |
377733 | 377733 | 2020-07-28 | Lawrence | Mississippi | 28077 | 276 | 3 |
377834 | 377834 | 2020-07-28 | Lawrence | Missouri | 29109 | 152 | 2 |
378368 | 378368 | 2020-07-28 | Lawrence | Ohio | 39087 | 191 | 0 |
378561 | 378561 | 2020-07-28 | Lawrence | Pennsylvania | 42073 | 308 | 11 |
378761 | 378761 | 2020-07-28 | Lawrence | South Dakota | 46081 | 26 | 0 |
378837 | 378837 | 2020-07-28 | Lawrence | Tennessee | 47099 | 404 | 6 |
373114 | 373114 | 2020-07-27 | Lawrence | Alabama | 1079 | 258 | 0 |
373221 | 373221 | 2020-07-27 | Lawrence | Arkansas | 5075 | 158 | 9 |
373718 | 373718 | 2020-07-27 | Lawrence | Illinois | 17101 | 37 | 0 |
373817 | 373817 | 2020-07-27 | Lawrence | Indiana | 18093 | 298 | 28 |
374129 | 374129 | 2020-07-27 | Lawrence | Kentucky | 21127 | 27 | 0 |
374518 | 374518 | 2020-07-27 | Lawrence | Mississippi | 28077 | 273 | 3 |
374619 | 374619 | 2020-07-27 | Lawrence | Missouri | 29109 | 142 | 2 |
375151 | 375151 | 2020-07-27 | Lawrence | Ohio | 39087 | 186 | 0 |
375345 | 375345 | 2020-07-27 | Lawrence | Pennsylvania | 42073 | 291 | 11 |
375545 | 375545 | 2020-07-27 | Lawrence | South Dakota | 46081 | 26 | 0 |
375621 | 375621 | 2020-07-27 | Lawrence | Tennessee | 47099 | 388 | 6 |
369902 | 369902 | 2020-07-26 | Lawrence | Alabama | 1079 | 248 | 0 |
370009 | 370009 | 2020-07-26 | Lawrence | Arkansas | 5075 | 157 | 9 |
370506 | 370506 | 2020-07-26 | Lawrence | Illinois | 17101 | 35 | 0 |
370605 | 370605 | 2020-07-26 | Lawrence | Indiana | 18093 | 297 | 28 |
370917 | 370917 | 2020-07-26 | Lawrence | Kentucky | 21127 | 27 | 0 |
371306 | 371306 | 2020-07-26 | Lawrence | Mississippi | 28077 | 271 | 3 |
371407 | 371407 | 2020-07-26 | Lawrence | Missouri | 29109 | 136 | 2 |
371939 | 371939 | 2020-07-26 | Lawrence | Ohio | 39087 | 182 | 0 |
372132 | 372132 | 2020-07-26 | Lawrence | Pennsylvania | 42073 | 288 | 11 |
372332 | 372332 | 2020-07-26 | Lawrence | South Dakota | 46081 | 25 | 0 |
372408 | 372408 | 2020-07-26 | Lawrence | Tennessee | 47099 | 375 | 6 |
366692 | 366692 | 2020-07-25 | Lawrence | Alabama | 1079 | 244 | 0 |
366799 | 366799 | 2020-07-25 | Lawrence | Arkansas | 5075 | 155 | 9 |
367296 | 367296 | 2020-07-25 | Lawrence | Illinois | 17101 | 34 | 0 |
367395 | 367395 | 2020-07-25 | Lawrence | Indiana | 18093 | 294 | 28 |
367707 | 367707 | 2020-07-25 | Lawrence | Kentucky | 21127 | 25 | 0 |
368096 | 368096 | 2020-07-25 | Lawrence | Mississippi | 28077 | 269 | 3 |
368196 | 368196 | 2020-07-25 | Lawrence | Missouri | 29109 | 134 | 2 |
368727 | 368727 | 2020-07-25 | Lawrence | Ohio | 39087 | 175 | 0 |
368920 | 368920 | 2020-07-25 | Lawrence | Pennsylvania | 42073 | 280 | 11 |
369120 | 369120 | 2020-07-25 | Lawrence | South Dakota | 46081 | 25 | 0 |
369196 | 369196 | 2020-07-25 | Lawrence | Tennessee | 47099 | 353 | 6 |
363485 | 363485 | 2020-07-24 | Lawrence | Alabama | 1079 | 231 | 0 |
363592 | 363592 | 2020-07-24 | Lawrence | Arkansas | 5075 | 152 | 9 |
364089 | 364089 | 2020-07-24 | Lawrence | Illinois | 17101 | 32 | 0 |
364188 | 364188 | 2020-07-24 | Lawrence | Indiana | 18093 | 292 | 28 |
364500 | 364500 | 2020-07-24 | Lawrence | Kentucky | 21127 | 22 | 0 |
364888 | 364888 | 2020-07-24 | Lawrence | Mississippi | 28077 | 246 | 3 |
364988 | 364988 | 2020-07-24 | Lawrence | Missouri | 29109 | 125 | 2 |
365518 | 365518 | 2020-07-24 | Lawrence | Ohio | 39087 | 170 | 0 |
365711 | 365711 | 2020-07-24 | Lawrence | Pennsylvania | 42073 | 272 | 11 |
365911 | 365911 | 2020-07-24 | Lawrence | South Dakota | 46081 | 25 | 0 |
365987 | 365987 | 2020-07-24 | Lawrence | Tennessee | 47099 | 342 | 6 |
360279 | 360279 | 2020-07-23 | Lawrence | Alabama | 1079 | 220 | 0 |
360385 | 360385 | 2020-07-23 | Lawrence | Arkansas | 5075 | 150 | 9 |
360882 | 360882 | 2020-07-23 | Lawrence | Illinois | 17101 | 32 | 0 |
360981 | 360981 | 2020-07-23 | Lawrence | Indiana | 18093 | 288 | 28 |
361293 | 361293 | 2020-07-23 | Lawrence | Kentucky | 21127 | 22 | 0 |
361681 | 361681 | 2020-07-23 | Lawrence | Mississippi | 28077 | 235 | 3 |
361781 | 361781 | 2020-07-23 | Lawrence | Missouri | 29109 | 122 | 2 |
362312 | 362312 | 2020-07-23 | Lawrence | Ohio | 39087 | 164 | 0 |
362505 | 362505 | 2020-07-23 | Lawrence | Pennsylvania | 42073 | 261 | 9 |
362705 | 362705 | 2020-07-23 | Lawrence | South Dakota | 46081 | 26 | 0 |
362781 | 362781 | 2020-07-23 | Lawrence | Tennessee | 47099 | 332 | 6 |
357074 | 357074 | 2020-07-22 | Lawrence | Alabama | 1079 | 214 | 0 |
357180 | 357180 | 2020-07-22 | Lawrence | Arkansas | 5075 | 148 | 9 |
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);