ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,231 rows where county = "Lawrence" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

  • Lawrence · 3,231 ✖
Link rowid date ▲ county state fips cases deaths
936783 936783 2021-01-17 Lawrence Alabama 1079 2436 47
936891 936891 2021-01-17 Lawrence Arkansas 5075 1806 40
937394 937394 2021-01-17 Lawrence Illinois 17101 2167 30
937492 937492 2021-01-17 Lawrence Indiana 18093 3808 78
937807 937807 2021-01-17 Lawrence Kentucky 21127 997 5
938196 938196 2021-01-17 Lawrence Mississippi 28077 1024 17
938296 938296 2021-01-17 Lawrence Missouri 29109 2542 60
938846 938846 2021-01-17 Lawrence Ohio 39087 4326 51
939041 939041 2021-01-17 Lawrence Pennsylvania 42073 5065 149
939242 939242 2021-01-17 Lawrence South Dakota 46081 2704 35
939318 939318 2021-01-17 Lawrence Tennessee 47099 5075 69
933538 933538 2021-01-16 Lawrence Alabama 1079 2425 47
933646 933646 2021-01-16 Lawrence Arkansas 5075 1801 40
934149 934149 2021-01-16 Lawrence Illinois 17101 2167 30
934247 934247 2021-01-16 Lawrence Indiana 18093 3797 78
934562 934562 2021-01-16 Lawrence Kentucky 21127 993 5
934951 934951 2021-01-16 Lawrence Mississippi 28077 1021 17
935051 935051 2021-01-16 Lawrence Missouri 29109 2534 60
935601 935601 2021-01-16 Lawrence Ohio 39087 4289 51
935796 935796 2021-01-16 Lawrence Pennsylvania 42073 5032 147
935997 935997 2021-01-16 Lawrence South Dakota 46081 2695 33
936073 936073 2021-01-16 Lawrence Tennessee 47099 5063 69
930293 930293 2021-01-15 Lawrence Alabama 1079 2404 47
930401 930401 2021-01-15 Lawrence Arkansas 5075 1788 40
930904 930904 2021-01-15 Lawrence Illinois 17101 2151 30
931002 931002 2021-01-15 Lawrence Indiana 18093 3781 78
931317 931317 2021-01-15 Lawrence Kentucky 21127 987 5
931706 931706 2021-01-15 Lawrence Mississippi 28077 1012 17
931806 931806 2021-01-15 Lawrence Missouri 29109 2515 59
932356 932356 2021-01-15 Lawrence Ohio 39087 4224 51
932551 932551 2021-01-15 Lawrence Pennsylvania 42073 4992 144
932752 932752 2021-01-15 Lawrence South Dakota 46081 2692 33
932828 932828 2021-01-15 Lawrence Tennessee 47099 5028 69
927048 927048 2021-01-14 Lawrence Alabama 1079 2393 45
927156 927156 2021-01-14 Lawrence Arkansas 5075 1772 40
927659 927659 2021-01-14 Lawrence Illinois 17101 2138 29
927757 927757 2021-01-14 Lawrence Indiana 18093 3744 75
928072 928072 2021-01-14 Lawrence Kentucky 21127 977 5
928461 928461 2021-01-14 Lawrence Mississippi 28077 998 17
928561 928561 2021-01-14 Lawrence Missouri 29109 2546 60
929111 929111 2021-01-14 Lawrence Ohio 39087 4170 51
929306 929306 2021-01-14 Lawrence Pennsylvania 42073 4967 143
929507 929507 2021-01-14 Lawrence South Dakota 46081 2675 33
929583 929583 2021-01-14 Lawrence Tennessee 47099 5001 69
923802 923802 2021-01-13 Lawrence Alabama 1079 2368 45
923910 923910 2021-01-13 Lawrence Arkansas 5075 1762 40
924413 924413 2021-01-13 Lawrence Illinois 17101 2131 29
924511 924511 2021-01-13 Lawrence Indiana 18093 3719 74
924826 924826 2021-01-13 Lawrence Kentucky 21127 964 5
925215 925215 2021-01-13 Lawrence Mississippi 28077 991 17
925315 925315 2021-01-13 Lawrence Missouri 29109 2539 60
925866 925866 2021-01-13 Lawrence Ohio 39087 4139 49
926061 926061 2021-01-13 Lawrence Pennsylvania 42073 4934 143
926262 926262 2021-01-13 Lawrence South Dakota 46081 2672 33
926338 926338 2021-01-13 Lawrence Tennessee 47099 4956 69
920557 920557 2021-01-12 Lawrence Alabama 1079 2351 45
920665 920665 2021-01-12 Lawrence Arkansas 5075 1753 39
921168 921168 2021-01-12 Lawrence Illinois 17101 2121 29
921266 921266 2021-01-12 Lawrence Indiana 18093 3699 74
921581 921581 2021-01-12 Lawrence Kentucky 21127 947 5
921970 921970 2021-01-12 Lawrence Mississippi 28077 979 17
922070 922070 2021-01-12 Lawrence Missouri 29109 2532 60
922620 922620 2021-01-12 Lawrence Ohio 39087 4089 49
922815 922815 2021-01-12 Lawrence Pennsylvania 42073 4871 140
923016 923016 2021-01-12 Lawrence South Dakota 46081 2657 31
923092 923092 2021-01-12 Lawrence Tennessee 47099 4938 68
917312 917312 2021-01-11 Lawrence Alabama 1079 2340 44
917420 917420 2021-01-11 Lawrence Arkansas 5075 1729 39
917923 917923 2021-01-11 Lawrence Illinois 17101 2107 29
918021 918021 2021-01-11 Lawrence Indiana 18093 3663 72
918336 918336 2021-01-11 Lawrence Kentucky 21127 932 5
918725 918725 2021-01-11 Lawrence Mississippi 28077 976 17
918825 918825 2021-01-11 Lawrence Missouri 29109 2521 57
919375 919375 2021-01-11 Lawrence Ohio 39087 4038 49
919570 919570 2021-01-11 Lawrence Pennsylvania 42073 4826 140
919771 919771 2021-01-11 Lawrence South Dakota 46081 2655 31
919847 919847 2021-01-11 Lawrence Tennessee 47099 4916 67
914067 914067 2021-01-10 Lawrence Alabama 1079 2324 44
914175 914175 2021-01-10 Lawrence Arkansas 5075 1723 38
914678 914678 2021-01-10 Lawrence Illinois 17101 2079 29
914776 914776 2021-01-10 Lawrence Indiana 18093 3646 70
915091 915091 2021-01-10 Lawrence Kentucky 21127 932 5
915480 915480 2021-01-10 Lawrence Mississippi 28077 973 17
915580 915580 2021-01-10 Lawrence Missouri 29109 2515 57
916130 916130 2021-01-10 Lawrence Ohio 39087 4005 48
916325 916325 2021-01-10 Lawrence Pennsylvania 42073 4790 139
916526 916526 2021-01-10 Lawrence South Dakota 46081 2652 31
916602 916602 2021-01-10 Lawrence Tennessee 47099 4885 66
910822 910822 2021-01-09 Lawrence Alabama 1079 2315 44
910930 910930 2021-01-09 Lawrence Arkansas 5075 1717 37
911433 911433 2021-01-09 Lawrence Illinois 17101 2077 29
911531 911531 2021-01-09 Lawrence Indiana 18093 3621 70
911846 911846 2021-01-09 Lawrence Kentucky 21127 925 5
912235 912235 2021-01-09 Lawrence Mississippi 28077 971 17
912335 912335 2021-01-09 Lawrence Missouri 29109 2490 57
912885 912885 2021-01-09 Lawrence Ohio 39087 3985 48
913080 913080 2021-01-09 Lawrence Pennsylvania 42073 4734 139
913281 913281 2021-01-09 Lawrence South Dakota 46081 2645 31
913357 913357 2021-01-09 Lawrence Tennessee 47099 4822 66
907577 907577 2021-01-08 Lawrence Alabama 1079 2263 44

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);