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 180
- Indiana 176
- Arkansas 175
- Ohio 175
- Pennsylvania 175
- Alabama 174
- South Dakota 173
- Tennessee 170
- Kentucky 169
- Illinois 162
- Missouri 136
fips 11
county 1
- Lawrence · 1,865 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535071 | 535071 | 2020-09-15 | Lawrence | Illinois | 17101 | 235 | 0 |
535170 | 535170 | 2020-09-15 | Lawrence | Indiana | 18093 | 496 | 30 |
535484 | 535484 | 2020-09-15 | Lawrence | Kentucky | 21127 | 52 | 0 |
535872 | 535872 | 2020-09-15 | Lawrence | Mississippi | 28077 | 421 | 12 |
535972 | 535972 | 2020-09-15 | Lawrence | Missouri | 29109 | 454 | 2 |
536519 | 536519 | 2020-09-15 | Lawrence | Ohio | 39087 | 553 | 18 |
536713 | 536713 | 2020-09-15 | Lawrence | Pennsylvania | 42073 | 487 | 21 |
536914 | 536914 | 2020-09-15 | Lawrence | South Dakota | 46081 | 290 | 4 |
536990 | 536990 | 2020-09-15 | Lawrence | Tennessee | 47099 | 884 | 11 |
531228 | 531228 | 2020-09-14 | Lawrence | Alabama | 1079 | 556 | 12 |
531335 | 531335 | 2020-09-14 | Lawrence | Arkansas | 5075 | 313 | 11 |
531836 | 531836 | 2020-09-14 | Lawrence | Illinois | 17101 | 235 | 0 |
531935 | 531935 | 2020-09-14 | Lawrence | Indiana | 18093 | 495 | 30 |
532249 | 532249 | 2020-09-14 | Lawrence | Kentucky | 21127 | 53 | 0 |
532637 | 532637 | 2020-09-14 | Lawrence | Mississippi | 28077 | 421 | 12 |
532737 | 532737 | 2020-09-14 | Lawrence | Missouri | 29109 | 448 | 2 |
533283 | 533283 | 2020-09-14 | Lawrence | Ohio | 39087 | 544 | 18 |
533477 | 533477 | 2020-09-14 | Lawrence | Pennsylvania | 42073 | 487 | 21 |
533678 | 533678 | 2020-09-14 | Lawrence | South Dakota | 46081 | 290 | 4 |
533754 | 533754 | 2020-09-14 | Lawrence | Tennessee | 47099 | 876 | 11 |
527991 | 527991 | 2020-09-13 | Lawrence | Alabama | 1079 | 554 | 12 |
528098 | 528098 | 2020-09-13 | Lawrence | Arkansas | 5075 | 313 | 11 |
528599 | 528599 | 2020-09-13 | Lawrence | Illinois | 17101 | 233 | 0 |
528698 | 528698 | 2020-09-13 | Lawrence | Indiana | 18093 | 494 | 29 |
529012 | 529012 | 2020-09-13 | Lawrence | Kentucky | 21127 | 53 | 0 |
529401 | 529401 | 2020-09-13 | Lawrence | Mississippi | 28077 | 420 | 12 |
529501 | 529501 | 2020-09-13 | Lawrence | Missouri | 29109 | 441 | 2 |
530048 | 530048 | 2020-09-13 | Lawrence | Ohio | 39087 | 538 | 17 |
530242 | 530242 | 2020-09-13 | Lawrence | Pennsylvania | 42073 | 481 | 21 |
530443 | 530443 | 2020-09-13 | Lawrence | South Dakota | 46081 | 286 | 4 |
530519 | 530519 | 2020-09-13 | Lawrence | Tennessee | 47099 | 857 | 11 |
524755 | 524755 | 2020-09-12 | Lawrence | Alabama | 1079 | 551 | 12 |
524862 | 524862 | 2020-09-12 | Lawrence | Arkansas | 5075 | 309 | 11 |
525363 | 525363 | 2020-09-12 | Lawrence | Illinois | 17101 | 225 | 0 |
525462 | 525462 | 2020-09-12 | Lawrence | Indiana | 18093 | 492 | 29 |
525776 | 525776 | 2020-09-12 | Lawrence | Kentucky | 21127 | 53 | 0 |
526165 | 526165 | 2020-09-12 | Lawrence | Mississippi | 28077 | 420 | 12 |
526265 | 526265 | 2020-09-12 | Lawrence | Missouri | 29109 | 434 | 2 |
526811 | 526811 | 2020-09-12 | Lawrence | Ohio | 39087 | 527 | 17 |
527005 | 527005 | 2020-09-12 | Lawrence | Pennsylvania | 42073 | 481 | 21 |
527206 | 527206 | 2020-09-12 | Lawrence | South Dakota | 46081 | 283 | 4 |
527282 | 527282 | 2020-09-12 | Lawrence | Tennessee | 47099 | 848 | 11 |
521519 | 521519 | 2020-09-11 | Lawrence | Alabama | 1079 | 546 | 10 |
521626 | 521626 | 2020-09-11 | Lawrence | Arkansas | 5075 | 283 | 11 |
522127 | 522127 | 2020-09-11 | Lawrence | Illinois | 17101 | 210 | 0 |
522226 | 522226 | 2020-09-11 | Lawrence | Indiana | 18093 | 488 | 29 |
522540 | 522540 | 2020-09-11 | Lawrence | Kentucky | 21127 | 53 | 0 |
522929 | 522929 | 2020-09-11 | Lawrence | Mississippi | 28077 | 420 | 12 |
523029 | 523029 | 2020-09-11 | Lawrence | Missouri | 29109 | 422 | 2 |
523575 | 523575 | 2020-09-11 | Lawrence | Ohio | 39087 | 526 | 17 |
523769 | 523769 | 2020-09-11 | Lawrence | Pennsylvania | 42073 | 480 | 21 |
523970 | 523970 | 2020-09-11 | Lawrence | South Dakota | 46081 | 278 | 4 |
524046 | 524046 | 2020-09-11 | Lawrence | Tennessee | 47099 | 838 | 11 |
518282 | 518282 | 2020-09-10 | Lawrence | Alabama | 1079 | 534 | 10 |
518389 | 518389 | 2020-09-10 | Lawrence | Arkansas | 5075 | 276 | 11 |
518890 | 518890 | 2020-09-10 | Lawrence | Illinois | 17101 | 207 | 0 |
518989 | 518989 | 2020-09-10 | Lawrence | Indiana | 18093 | 485 | 29 |
519303 | 519303 | 2020-09-10 | Lawrence | Kentucky | 21127 | 51 | 0 |
519692 | 519692 | 2020-09-10 | Lawrence | Mississippi | 28077 | 417 | 11 |
519792 | 519792 | 2020-09-10 | Lawrence | Missouri | 29109 | 419 | 2 |
520339 | 520339 | 2020-09-10 | Lawrence | Ohio | 39087 | 508 | 17 |
520533 | 520533 | 2020-09-10 | Lawrence | Pennsylvania | 42073 | 480 | 21 |
520734 | 520734 | 2020-09-10 | Lawrence | South Dakota | 46081 | 277 | 4 |
520810 | 520810 | 2020-09-10 | Lawrence | Tennessee | 47099 | 831 | 11 |
515047 | 515047 | 2020-09-09 | Lawrence | Alabama | 1079 | 529 | 7 |
515154 | 515154 | 2020-09-09 | Lawrence | Arkansas | 5075 | 275 | 11 |
515655 | 515655 | 2020-09-09 | Lawrence | Illinois | 17101 | 206 | 0 |
515754 | 515754 | 2020-09-09 | Lawrence | Indiana | 18093 | 484 | 29 |
516068 | 516068 | 2020-09-09 | Lawrence | Kentucky | 21127 | 47 | 0 |
516457 | 516457 | 2020-09-09 | Lawrence | Mississippi | 28077 | 414 | 11 |
516557 | 516557 | 2020-09-09 | Lawrence | Missouri | 29109 | 408 | 2 |
517103 | 517103 | 2020-09-09 | Lawrence | Ohio | 39087 | 501 | 17 |
517297 | 517297 | 2020-09-09 | Lawrence | Pennsylvania | 42073 | 479 | 21 |
517498 | 517498 | 2020-09-09 | Lawrence | South Dakota | 46081 | 267 | 4 |
517574 | 517574 | 2020-09-09 | Lawrence | Tennessee | 47099 | 808 | 11 |
511814 | 511814 | 2020-09-08 | Lawrence | Alabama | 1079 | 524 | 5 |
511921 | 511921 | 2020-09-08 | Lawrence | Arkansas | 5075 | 271 | 11 |
512422 | 512422 | 2020-09-08 | Lawrence | Illinois | 17101 | 205 | 0 |
512521 | 512521 | 2020-09-08 | Lawrence | Indiana | 18093 | 483 | 29 |
512835 | 512835 | 2020-09-08 | Lawrence | Kentucky | 21127 | 47 | 0 |
513223 | 513223 | 2020-09-08 | Lawrence | Mississippi | 28077 | 414 | 11 |
513323 | 513323 | 2020-09-08 | Lawrence | Missouri | 29109 | 399 | 2 |
513868 | 513868 | 2020-09-08 | Lawrence | Ohio | 39087 | 494 | 16 |
514062 | 514062 | 2020-09-08 | Lawrence | Pennsylvania | 42073 | 474 | 21 |
514263 | 514263 | 2020-09-08 | Lawrence | South Dakota | 46081 | 264 | 4 |
514339 | 514339 | 2020-09-08 | Lawrence | Tennessee | 47099 | 804 | 11 |
508581 | 508581 | 2020-09-07 | Lawrence | Alabama | 1079 | 523 | 5 |
508688 | 508688 | 2020-09-07 | Lawrence | Arkansas | 5075 | 271 | 11 |
509189 | 509189 | 2020-09-07 | Lawrence | Illinois | 17101 | 199 | 0 |
509288 | 509288 | 2020-09-07 | Lawrence | Indiana | 18093 | 482 | 29 |
509603 | 509603 | 2020-09-07 | Lawrence | Kentucky | 21127 | 47 | 0 |
509991 | 509991 | 2020-09-07 | Lawrence | Mississippi | 28077 | 413 | 11 |
510091 | 510091 | 2020-09-07 | Lawrence | Missouri | 29109 | 393 | 2 |
510635 | 510635 | 2020-09-07 | Lawrence | Ohio | 39087 | 487 | 16 |
510829 | 510829 | 2020-09-07 | Lawrence | Pennsylvania | 42073 | 474 | 21 |
511030 | 511030 | 2020-09-07 | Lawrence | South Dakota | 46081 | 263 | 4 |
511106 | 511106 | 2020-09-07 | Lawrence | Tennessee | 47099 | 799 | 11 |
505349 | 505349 | 2020-09-06 | Lawrence | Alabama | 1079 | 520 | 5 |
505456 | 505456 | 2020-09-06 | Lawrence | Arkansas | 5075 | 268 | 11 |
505957 | 505957 | 2020-09-06 | Lawrence | Illinois | 17101 | 196 | 0 |
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);