ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where county = "Lawrence" and deaths = 45 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- South Dakota 50
- Illinois 12
- Mississippi 12
- Indiana 6
- Ohio 6
- Alabama 3
- Arkansas 3
- Kentucky 1
- Missouri 1
- Tennessee 1
county 1
- Lawrence · 95 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2169143 | 2169143 | 2022-01-31 | Lawrence | Mississippi | 28077 | 3262 | 45 |
2165888 | 2165888 | 2022-01-30 | Lawrence | Mississippi | 28077 | 3199 | 45 |
2162633 | 2162633 | 2022-01-29 | Lawrence | Mississippi | 28077 | 3199 | 45 |
2159378 | 2159378 | 2022-01-28 | Lawrence | Mississippi | 28077 | 3199 | 45 |
2156124 | 2156124 | 2022-01-27 | Lawrence | Mississippi | 28077 | 3176 | 45 |
2152871 | 2152871 | 2022-01-26 | Lawrence | Mississippi | 28077 | 3140 | 45 |
2149619 | 2149619 | 2022-01-25 | Lawrence | Mississippi | 28077 | 3096 | 45 |
2146367 | 2146367 | 2022-01-24 | Lawrence | Mississippi | 28077 | 3079 | 45 |
2143112 | 2143112 | 2022-01-23 | Lawrence | Mississippi | 28077 | 3014 | 45 |
2139857 | 2139857 | 2022-01-22 | Lawrence | Mississippi | 28077 | 3014 | 45 |
2136601 | 2136601 | 2022-01-21 | Lawrence | Mississippi | 28077 | 3014 | 45 |
2133349 | 2133349 | 2022-01-20 | Lawrence | Mississippi | 28077 | 2972 | 45 |
2009422 | 2009422 | 2021-12-13 | Lawrence | Kentucky | 21127 | 3037 | 45 |
1966755 | 1966755 | 2021-11-30 | Lawrence | Illinois | 17101 | 3492 | 45 |
1963503 | 1963503 | 2021-11-29 | Lawrence | Illinois | 17101 | 3472 | 45 |
1960252 | 1960252 | 2021-11-28 | Lawrence | Illinois | 17101 | 3465 | 45 |
1957001 | 1957001 | 2021-11-27 | Lawrence | Illinois | 17101 | 3465 | 45 |
1953750 | 1953750 | 2021-11-26 | Lawrence | Illinois | 17101 | 3465 | 45 |
1950499 | 1950499 | 2021-11-25 | Lawrence | Illinois | 17101 | 3465 | 45 |
1947248 | 1947248 | 2021-11-24 | Lawrence | Illinois | 17101 | 3465 | 45 |
1943997 | 1943997 | 2021-11-23 | Lawrence | Illinois | 17101 | 3462 | 45 |
1940747 | 1940747 | 2021-11-22 | Lawrence | Illinois | 17101 | 3444 | 45 |
1937497 | 1937497 | 2021-11-21 | Lawrence | Illinois | 17101 | 3435 | 45 |
1934247 | 1934247 | 2021-11-20 | Lawrence | Illinois | 17101 | 3435 | 45 |
1930996 | 1930996 | 2021-11-19 | Lawrence | Illinois | 17101 | 3435 | 45 |
1670562 | 1670562 | 2021-08-31 | Lawrence | Arkansas | 5075 | 2699 | 45 |
1667315 | 1667315 | 2021-08-30 | Lawrence | Arkansas | 5075 | 2669 | 45 |
1664068 | 1664068 | 2021-08-29 | Lawrence | Arkansas | 5075 | 2661 | 45 |
1224842 | 1224842 | 2021-04-15 | Lawrence | South Dakota | 46081 | 2921 | 45 |
1221595 | 1221595 | 2021-04-14 | Lawrence | South Dakota | 46081 | 2920 | 45 |
1218347 | 1218347 | 2021-04-13 | Lawrence | South Dakota | 46081 | 2918 | 45 |
1215099 | 1215099 | 2021-04-12 | Lawrence | South Dakota | 46081 | 2916 | 45 |
1211852 | 1211852 | 2021-04-11 | Lawrence | South Dakota | 46081 | 2915 | 45 |
1208603 | 1208603 | 2021-04-10 | Lawrence | South Dakota | 46081 | 2915 | 45 |
1205355 | 1205355 | 2021-04-09 | Lawrence | South Dakota | 46081 | 2915 | 45 |
1202107 | 1202107 | 2021-04-08 | Lawrence | South Dakota | 46081 | 2909 | 45 |
1198858 | 1198858 | 2021-04-07 | Lawrence | South Dakota | 46081 | 2905 | 45 |
1195609 | 1195609 | 2021-04-06 | Lawrence | South Dakota | 46081 | 2902 | 45 |
1192361 | 1192361 | 2021-04-05 | Lawrence | South Dakota | 46081 | 2900 | 45 |
1189112 | 1189112 | 2021-04-04 | Lawrence | South Dakota | 46081 | 2897 | 45 |
1185865 | 1185865 | 2021-04-03 | Lawrence | South Dakota | 46081 | 2897 | 45 |
1182618 | 1182618 | 2021-04-02 | Lawrence | South Dakota | 46081 | 2895 | 45 |
1179371 | 1179371 | 2021-04-01 | Lawrence | South Dakota | 46081 | 2892 | 45 |
1176124 | 1176124 | 2021-03-31 | Lawrence | South Dakota | 46081 | 2887 | 45 |
1172877 | 1172877 | 2021-03-30 | Lawrence | South Dakota | 46081 | 2887 | 45 |
1169630 | 1169630 | 2021-03-29 | Lawrence | South Dakota | 46081 | 2886 | 45 |
1166382 | 1166382 | 2021-03-28 | Lawrence | South Dakota | 46081 | 2886 | 45 |
1163134 | 1163134 | 2021-03-27 | Lawrence | South Dakota | 46081 | 2886 | 45 |
1159885 | 1159885 | 2021-03-26 | Lawrence | South Dakota | 46081 | 2885 | 45 |
1156638 | 1156638 | 2021-03-25 | Lawrence | South Dakota | 46081 | 2881 | 45 |
1153391 | 1153391 | 2021-03-24 | Lawrence | South Dakota | 46081 | 2882 | 45 |
1150144 | 1150144 | 2021-03-23 | Lawrence | South Dakota | 46081 | 2879 | 45 |
1146897 | 1146897 | 2021-03-22 | Lawrence | South Dakota | 46081 | 2878 | 45 |
1143650 | 1143650 | 2021-03-21 | Lawrence | South Dakota | 46081 | 2878 | 45 |
1140403 | 1140403 | 2021-03-20 | Lawrence | South Dakota | 46081 | 2879 | 45 |
1137157 | 1137157 | 2021-03-19 | Lawrence | South Dakota | 46081 | 2875 | 45 |
1133911 | 1133911 | 2021-03-18 | Lawrence | South Dakota | 46081 | 2843 | 45 |
1130663 | 1130663 | 2021-03-17 | Lawrence | South Dakota | 46081 | 2842 | 45 |
1127416 | 1127416 | 2021-03-16 | Lawrence | South Dakota | 46081 | 2841 | 45 |
1124170 | 1124170 | 2021-03-15 | Lawrence | South Dakota | 46081 | 2840 | 45 |
1120924 | 1120924 | 2021-03-14 | Lawrence | South Dakota | 46081 | 2840 | 45 |
1117677 | 1117677 | 2021-03-13 | Lawrence | South Dakota | 46081 | 2839 | 45 |
1114430 | 1114430 | 2021-03-12 | Lawrence | South Dakota | 46081 | 2839 | 45 |
1111184 | 1111184 | 2021-03-11 | Lawrence | South Dakota | 46081 | 2838 | 45 |
1107938 | 1107938 | 2021-03-10 | Lawrence | South Dakota | 46081 | 2838 | 45 |
1104692 | 1104692 | 2021-03-09 | Lawrence | South Dakota | 46081 | 2836 | 45 |
1101446 | 1101446 | 2021-03-08 | Lawrence | South Dakota | 46081 | 2834 | 45 |
1098200 | 1098200 | 2021-03-07 | Lawrence | South Dakota | 46081 | 2834 | 45 |
1094952 | 1094952 | 2021-03-06 | Lawrence | South Dakota | 46081 | 2833 | 45 |
1091706 | 1091706 | 2021-03-05 | Lawrence | South Dakota | 46081 | 2832 | 45 |
1088460 | 1088460 | 2021-03-04 | Lawrence | South Dakota | 46081 | 2831 | 45 |
1085215 | 1085215 | 2021-03-03 | Lawrence | South Dakota | 46081 | 2831 | 45 |
1081969 | 1081969 | 2021-03-02 | Lawrence | South Dakota | 46081 | 2828 | 45 |
1078723 | 1078723 | 2021-03-01 | Lawrence | South Dakota | 46081 | 2825 | 45 |
1075478 | 1075478 | 2021-02-28 | Lawrence | South Dakota | 46081 | 2823 | 45 |
1072232 | 1072232 | 2021-02-27 | Lawrence | South Dakota | 46081 | 2821 | 45 |
1068986 | 1068986 | 2021-02-26 | Lawrence | South Dakota | 46081 | 2819 | 45 |
1065741 | 1065741 | 2021-02-25 | Lawrence | South Dakota | 46081 | 2817 | 45 |
926968 | 926968 | 2021-01-14 | Lawrence | Alabama | 1079 | 2393 | 45 |
923722 | 923722 | 2021-01-13 | Lawrence | Alabama | 1079 | 2368 | 45 |
920477 | 920477 | 2021-01-12 | Lawrence | Alabama | 1079 | 2351 | 45 |
853840 | 853840 | 2020-12-22 | Lawrence | Missouri | 29109 | 2215 | 45 |
851145 | 851145 | 2020-12-21 | Lawrence | Ohio | 39087 | 3115 | 45 |
847900 | 847900 | 2020-12-20 | Lawrence | Ohio | 39087 | 3086 | 45 |
844655 | 844655 | 2020-12-19 | Lawrence | Ohio | 39087 | 3055 | 45 |
841409 | 841409 | 2020-12-18 | Lawrence | Ohio | 39087 | 3026 | 45 |
838164 | 838164 | 2020-12-17 | Lawrence | Ohio | 39087 | 2998 | 45 |
834918 | 834918 | 2020-12-16 | Lawrence | Ohio | 39087 | 2945 | 45 |
828897 | 828897 | 2020-12-14 | Lawrence | Tennessee | 47099 | 3480 | 45 |
742688 | 742688 | 2020-11-18 | Lawrence | Indiana | 18093 | 1585 | 45 |
739441 | 739441 | 2020-11-17 | Lawrence | Indiana | 18093 | 1549 | 45 |
736197 | 736197 | 2020-11-16 | Lawrence | Indiana | 18093 | 1519 | 45 |
732951 | 732951 | 2020-11-15 | Lawrence | Indiana | 18093 | 1502 | 45 |
729706 | 729706 | 2020-11-14 | Lawrence | Indiana | 18093 | 1479 | 45 |
726463 | 726463 | 2020-11-13 | Lawrence | Indiana | 18093 | 1419 | 45 |
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);