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 295
- Arkansas 291
- Indiana 291
- Ohio 290
- Pennsylvania 290
- Alabama 289
- South Dakota 288
- Tennessee 285
- Kentucky 284
- Illinois 277
- Missouri 251
fips 11
county 1
- Lawrence · 3,131 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
907605 | 907605 | 2021-01-08 | Lawrence | Arkansas | 5075 | 1703 | 37 |
908108 | 908108 | 2021-01-08 | Lawrence | Illinois | 17101 | 2070 | 29 |
908206 | 908206 | 2021-01-08 | Lawrence | Indiana | 18093 | 3575 | 69 |
908521 | 908521 | 2021-01-08 | Lawrence | Kentucky | 21127 | 911 | 5 |
908910 | 908910 | 2021-01-08 | Lawrence | Mississippi | 28077 | 957 | 17 |
909010 | 909010 | 2021-01-08 | Lawrence | Missouri | 29109 | 2470 | 57 |
909560 | 909560 | 2021-01-08 | Lawrence | Ohio | 39087 | 3934 | 48 |
909755 | 909755 | 2021-01-08 | Lawrence | Pennsylvania | 42073 | 4663 | 136 |
909956 | 909956 | 2021-01-08 | Lawrence | South Dakota | 46081 | 2634 | 29 |
910032 | 910032 | 2021-01-08 | Lawrence | Tennessee | 47099 | 4801 | 66 |
904251 | 904251 | 2021-01-07 | Lawrence | Alabama | 1079 | 2217 | 44 |
904359 | 904359 | 2021-01-07 | Lawrence | Arkansas | 5075 | 1683 | 36 |
904862 | 904862 | 2021-01-07 | Lawrence | Illinois | 17101 | 2039 | 29 |
904960 | 904960 | 2021-01-07 | Lawrence | Indiana | 18093 | 3547 | 68 |
905275 | 905275 | 2021-01-07 | Lawrence | Kentucky | 21127 | 906 | 5 |
905664 | 905664 | 2021-01-07 | Lawrence | Mississippi | 28077 | 953 | 17 |
905764 | 905764 | 2021-01-07 | Lawrence | Missouri | 29109 | 2434 | 57 |
906315 | 906315 | 2021-01-07 | Lawrence | Ohio | 39087 | 3857 | 48 |
906510 | 906510 | 2021-01-07 | Lawrence | Pennsylvania | 42073 | 4579 | 135 |
906711 | 906711 | 2021-01-07 | Lawrence | South Dakota | 46081 | 2625 | 28 |
906787 | 906787 | 2021-01-07 | Lawrence | Tennessee | 47099 | 4767 | 64 |
901006 | 901006 | 2021-01-06 | Lawrence | Alabama | 1079 | 2181 | 44 |
901114 | 901114 | 2021-01-06 | Lawrence | Arkansas | 5075 | 1667 | 36 |
901617 | 901617 | 2021-01-06 | Lawrence | Illinois | 17101 | 2029 | 29 |
901715 | 901715 | 2021-01-06 | Lawrence | Indiana | 18093 | 3505 | 68 |
902030 | 902030 | 2021-01-06 | Lawrence | Kentucky | 21127 | 894 | 5 |
902419 | 902419 | 2021-01-06 | Lawrence | Mississippi | 28077 | 945 | 17 |
902519 | 902519 | 2021-01-06 | Lawrence | Missouri | 29109 | 2418 | 57 |
903069 | 903069 | 2021-01-06 | Lawrence | Ohio | 39087 | 3818 | 48 |
903264 | 903264 | 2021-01-06 | Lawrence | Pennsylvania | 42073 | 4526 | 134 |
903465 | 903465 | 2021-01-06 | Lawrence | South Dakota | 46081 | 2619 | 28 |
903541 | 903541 | 2021-01-06 | Lawrence | Tennessee | 47099 | 4676 | 64 |
897761 | 897761 | 2021-01-05 | Lawrence | Alabama | 1079 | 2149 | 43 |
897869 | 897869 | 2021-01-05 | Lawrence | Arkansas | 5075 | 1651 | 36 |
898372 | 898372 | 2021-01-05 | Lawrence | Illinois | 17101 | 2016 | 27 |
898470 | 898470 | 2021-01-05 | Lawrence | Indiana | 18093 | 3463 | 68 |
898785 | 898785 | 2021-01-05 | Lawrence | Kentucky | 21127 | 876 | 5 |
899174 | 899174 | 2021-01-05 | Lawrence | Mississippi | 28077 | 936 | 16 |
899274 | 899274 | 2021-01-05 | Lawrence | Missouri | 29109 | 2407 | 57 |
899824 | 899824 | 2021-01-05 | Lawrence | Ohio | 39087 | 3772 | 48 |
900019 | 900019 | 2021-01-05 | Lawrence | Pennsylvania | 42073 | 4471 | 131 |
900220 | 900220 | 2021-01-05 | Lawrence | South Dakota | 46081 | 2608 | 28 |
900296 | 900296 | 2021-01-05 | Lawrence | Tennessee | 47099 | 4630 | 63 |
894515 | 894515 | 2021-01-04 | Lawrence | Alabama | 1079 | 2128 | 43 |
894624 | 894624 | 2021-01-04 | Lawrence | Arkansas | 5075 | 1626 | 36 |
895127 | 895127 | 2021-01-04 | Lawrence | Illinois | 17101 | 2001 | 27 |
895225 | 895225 | 2021-01-04 | Lawrence | Indiana | 18093 | 3419 | 67 |
895540 | 895540 | 2021-01-04 | Lawrence | Kentucky | 21127 | 846 | 5 |
895929 | 895929 | 2021-01-04 | Lawrence | Mississippi | 28077 | 927 | 16 |
896029 | 896029 | 2021-01-04 | Lawrence | Missouri | 29109 | 2370 | 52 |
896579 | 896579 | 2021-01-04 | Lawrence | Ohio | 39087 | 3695 | 48 |
896774 | 896774 | 2021-01-04 | Lawrence | Pennsylvania | 42073 | 4431 | 130 |
896975 | 896975 | 2021-01-04 | Lawrence | South Dakota | 46081 | 2595 | 28 |
897051 | 897051 | 2021-01-04 | Lawrence | Tennessee | 47099 | 4600 | 62 |
891269 | 891269 | 2021-01-03 | Lawrence | Alabama | 1079 | 2115 | 43 |
891377 | 891377 | 2021-01-03 | Lawrence | Arkansas | 5075 | 1621 | 36 |
891880 | 891880 | 2021-01-03 | Lawrence | Illinois | 17101 | 1992 | 27 |
891978 | 891978 | 2021-01-03 | Lawrence | Indiana | 18093 | 3397 | 67 |
892293 | 892293 | 2021-01-03 | Lawrence | Kentucky | 21127 | 837 | 5 |
892682 | 892682 | 2021-01-03 | Lawrence | Mississippi | 28077 | 924 | 16 |
892782 | 892782 | 2021-01-03 | Lawrence | Missouri | 29109 | 2370 | 52 |
893333 | 893333 | 2021-01-03 | Lawrence | Ohio | 39087 | 3642 | 47 |
893528 | 893528 | 2021-01-03 | Lawrence | Pennsylvania | 42073 | 4390 | 129 |
893729 | 893729 | 2021-01-03 | Lawrence | South Dakota | 46081 | 2594 | 28 |
893805 | 893805 | 2021-01-03 | Lawrence | Tennessee | 47099 | 4551 | 59 |
888022 | 888022 | 2021-01-02 | Lawrence | Alabama | 1079 | 2102 | 43 |
888130 | 888130 | 2021-01-02 | Lawrence | Arkansas | 5075 | 1600 | 36 |
888633 | 888633 | 2021-01-02 | Lawrence | Illinois | 17101 | 1990 | 27 |
888732 | 888732 | 2021-01-02 | Lawrence | Indiana | 18093 | 3368 | 67 |
889047 | 889047 | 2021-01-02 | Lawrence | Kentucky | 21127 | 825 | 5 |
889436 | 889436 | 2021-01-02 | Lawrence | Mississippi | 28077 | 920 | 16 |
889536 | 889536 | 2021-01-02 | Lawrence | Missouri | 29109 | 2355 | 52 |
890087 | 890087 | 2021-01-02 | Lawrence | Ohio | 39087 | 3609 | 47 |
890282 | 890282 | 2021-01-02 | Lawrence | Pennsylvania | 42073 | 4361 | 129 |
890483 | 890483 | 2021-01-02 | Lawrence | South Dakota | 46081 | 2577 | 28 |
890559 | 890559 | 2021-01-02 | Lawrence | Tennessee | 47099 | 4519 | 59 |
884777 | 884777 | 2021-01-01 | Lawrence | Alabama | 1079 | 2082 | 43 |
884885 | 884885 | 2021-01-01 | Lawrence | Arkansas | 5075 | 1587 | 35 |
885388 | 885388 | 2021-01-01 | Lawrence | Illinois | 17101 | 1985 | 27 |
885486 | 885486 | 2021-01-01 | Lawrence | Indiana | 18093 | 3340 | 65 |
885801 | 885801 | 2021-01-01 | Lawrence | Kentucky | 21127 | 758 | 5 |
886190 | 886190 | 2021-01-01 | Lawrence | Mississippi | 28077 | 919 | 16 |
886290 | 886290 | 2021-01-01 | Lawrence | Missouri | 29109 | 2346 | 52 |
886840 | 886840 | 2021-01-01 | Lawrence | Ohio | 39087 | 3517 | 47 |
887035 | 887035 | 2021-01-01 | Lawrence | Pennsylvania | 42073 | 4286 | 129 |
887236 | 887236 | 2021-01-01 | Lawrence | South Dakota | 46081 | 2555 | 28 |
887312 | 887312 | 2021-01-01 | Lawrence | Tennessee | 47099 | 4416 | 58 |
881532 | 881532 | 2020-12-31 | Lawrence | Alabama | 1079 | 2044 | 42 |
881640 | 881640 | 2020-12-31 | Lawrence | Arkansas | 5075 | 1574 | 35 |
882143 | 882143 | 2020-12-31 | Lawrence | Illinois | 17101 | 1985 | 27 |
882241 | 882241 | 2020-12-31 | Lawrence | Indiana | 18093 | 3299 | 65 |
882556 | 882556 | 2020-12-31 | Lawrence | Kentucky | 21127 | 758 | 5 |
882945 | 882945 | 2020-12-31 | Lawrence | Mississippi | 28077 | 918 | 16 |
883045 | 883045 | 2020-12-31 | Lawrence | Missouri | 29109 | 2293 | 52 |
883595 | 883595 | 2020-12-31 | Lawrence | Ohio | 39087 | 3517 | 47 |
883790 | 883790 | 2020-12-31 | Lawrence | Pennsylvania | 42073 | 4245 | 126 |
883991 | 883991 | 2020-12-31 | Lawrence | South Dakota | 46081 | 2555 | 28 |
884067 | 884067 | 2020-12-31 | Lawrence | Tennessee | 47099 | 4416 | 58 |
878287 | 878287 | 2020-12-30 | Lawrence | Alabama | 1079 | 2005 | 42 |
878395 | 878395 | 2020-12-30 | Lawrence | Arkansas | 5075 | 1568 | 35 |
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);