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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
- Mississippi 780
- Alabama 779
- Indiana 778
- Pennsylvania 778
- South Dakota 776
- Arkansas 773
- Ohio 771
- Tennessee 771
- Illinois 749
- Missouri 737
- Kentucky 730
fips 11
county 1
- Lawrence · 8,422 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
122745 | 122745 | 2020-05-07 | Lawrence | Missouri | 29109 | 2 | 0 |
143207 | 143207 | 2020-05-14 | Lawrence | Kentucky | 21127 | 2 | 0 |
146207 | 146207 | 2020-05-15 | Lawrence | Kentucky | 21127 | 2 | 0 |
149211 | 149211 | 2020-05-16 | Lawrence | Kentucky | 21127 | 2 | 0 |
152222 | 152222 | 2020-05-17 | Lawrence | Kentucky | 21127 | 2 | 0 |
155236 | 155236 | 2020-05-18 | Lawrence | Kentucky | 21127 | 2 | 0 |
158253 | 158253 | 2020-05-19 | Lawrence | Kentucky | 21127 | 2 | 0 |
161279 | 161279 | 2020-05-20 | Lawrence | Kentucky | 21127 | 2 | 0 |
164308 | 164308 | 2020-05-21 | Lawrence | Kentucky | 21127 | 2 | 0 |
167344 | 167344 | 2020-05-22 | Lawrence | Kentucky | 21127 | 2 | 0 |
170382 | 170382 | 2020-05-23 | Lawrence | Kentucky | 21127 | 2 | 0 |
173423 | 173423 | 2020-05-24 | Lawrence | Kentucky | 21127 | 2 | 0 |
176467 | 176467 | 2020-05-25 | Lawrence | Kentucky | 21127 | 2 | 0 |
179511 | 179511 | 2020-05-26 | Lawrence | Kentucky | 21127 | 2 | 0 |
182556 | 182556 | 2020-05-27 | Lawrence | Kentucky | 21127 | 2 | 0 |
185610 | 185610 | 2020-05-28 | Lawrence | Kentucky | 21127 | 2 | 0 |
188668 | 188668 | 2020-05-29 | Lawrence | Kentucky | 21127 | 2 | 0 |
191732 | 191732 | 2020-05-30 | Lawrence | Kentucky | 21127 | 2 | 0 |
194800 | 194800 | 2020-05-31 | Lawrence | Kentucky | 21127 | 2 | 0 |
11576 | 11576 | 2020-03-25 | Lawrence | Mississippi | 28077 | 3 | 0 |
12394 | 12394 | 2020-03-26 | Lawrence | Alabama | 1079 | 3 | 0 |
14055 | 14055 | 2020-03-27 | Lawrence | Alabama | 1079 | 3 | 0 |
14123 | 14123 | 2020-03-27 | Lawrence | Arkansas | 5075 | 3 | 0 |
15833 | 15833 | 2020-03-28 | Lawrence | Alabama | 1079 | 3 | 0 |
17716 | 17716 | 2020-03-29 | Lawrence | Alabama | 1079 | 3 | 0 |
19224 | 19224 | 2020-03-29 | Lawrence | South Dakota | 46081 | 3 | 0 |
19688 | 19688 | 2020-03-30 | Lawrence | Alabama | 1079 | 3 | 0 |
21760 | 21760 | 2020-03-31 | Lawrence | Alabama | 1079 | 3 | 0 |
23916 | 23916 | 2020-04-01 | Lawrence | Alabama | 1079 | 3 | 0 |
26138 | 26138 | 2020-04-02 | Lawrence | Alabama | 1079 | 3 | 0 |
26218 | 26218 | 2020-04-02 | Lawrence | Arkansas | 5075 | 3 | 0 |
28516 | 28516 | 2020-04-03 | Lawrence | Arkansas | 5075 | 3 | 0 |
30282 | 30282 | 2020-04-03 | Lawrence | Tennessee | 47099 | 3 | 0 |
30874 | 30874 | 2020-04-04 | Lawrence | Arkansas | 5075 | 3 | 1 |
32673 | 32673 | 2020-04-04 | Lawrence | Tennessee | 47099 | 3 | 0 |
33278 | 33278 | 2020-04-05 | Lawrence | Arkansas | 5075 | 3 | 1 |
35110 | 35110 | 2020-04-05 | Lawrence | Tennessee | 47099 | 3 | 0 |
35721 | 35721 | 2020-04-06 | Lawrence | Arkansas | 5075 | 3 | 1 |
87460 | 87460 | 2020-04-25 | Lawrence | Illinois | 17101 | 3 | 0 |
90276 | 90276 | 2020-04-26 | Lawrence | Illinois | 17101 | 3 | 0 |
93095 | 93095 | 2020-04-27 | Lawrence | Illinois | 17101 | 3 | 0 |
95927 | 95927 | 2020-04-28 | Lawrence | Illinois | 17101 | 3 | 0 |
98771 | 98771 | 2020-04-29 | Lawrence | Illinois | 17101 | 3 | 0 |
101622 | 101622 | 2020-04-30 | Lawrence | Illinois | 17101 | 3 | 0 |
104478 | 104478 | 2020-05-01 | Lawrence | Illinois | 17101 | 3 | 0 |
107343 | 107343 | 2020-05-02 | Lawrence | Illinois | 17101 | 3 | 0 |
115971 | 115971 | 2020-05-05 | Lawrence | Illinois | 17101 | 3 | 0 |
118931 | 118931 | 2020-05-06 | Lawrence | Illinois | 17101 | 3 | 0 |
121901 | 121901 | 2020-05-07 | Lawrence | Illinois | 17101 | 3 | 0 |
124880 | 124880 | 2020-05-08 | Lawrence | Illinois | 17101 | 3 | 0 |
136838 | 136838 | 2020-05-12 | Lawrence | Illinois | 17101 | 3 | 0 |
197871 | 197871 | 2020-06-01 | Lawrence | Kentucky | 21127 | 3 | 0 |
15345 | 15345 | 2020-03-27 | Lawrence | Pennsylvania | 42073 | 4 | 0 |
16297 | 16297 | 2020-03-28 | Lawrence | Indiana | 18093 | 4 | 0 |
28435 | 28435 | 2020-04-03 | Lawrence | Alabama | 1079 | 4 | 0 |
29972 | 29972 | 2020-04-03 | Lawrence | Ohio | 39087 | 4 | 0 |
30792 | 30792 | 2020-04-04 | Lawrence | Alabama | 1079 | 4 | 0 |
31911 | 31911 | 2020-04-04 | Lawrence | Mississippi | 28077 | 4 | 0 |
34338 | 34338 | 2020-04-05 | Lawrence | Mississippi | 28077 | 4 | 0 |
37586 | 37586 | 2020-04-06 | Lawrence | Tennessee | 47099 | 4 | 0 |
38210 | 38210 | 2020-04-07 | Lawrence | Arkansas | 5075 | 4 | 1 |
110213 | 110213 | 2020-05-03 | Lawrence | Illinois | 17101 | 4 | 0 |
113088 | 113088 | 2020-05-04 | Lawrence | Illinois | 17101 | 4 | 0 |
127867 | 127867 | 2020-05-09 | Lawrence | Illinois | 17101 | 4 | 0 |
130858 | 130858 | 2020-05-10 | Lawrence | Illinois | 17101 | 4 | 0 |
133849 | 133849 | 2020-05-11 | Lawrence | Illinois | 17101 | 4 | 0 |
139830 | 139830 | 2020-05-13 | Lawrence | Illinois | 17101 | 4 | 0 |
142826 | 142826 | 2020-05-14 | Lawrence | Illinois | 17101 | 4 | 0 |
145826 | 145826 | 2020-05-15 | Lawrence | Illinois | 17101 | 4 | 0 |
148829 | 148829 | 2020-05-16 | Lawrence | Illinois | 17101 | 4 | 0 |
151838 | 151838 | 2020-05-17 | Lawrence | Illinois | 17101 | 4 | 0 |
154850 | 154850 | 2020-05-18 | Lawrence | Illinois | 17101 | 4 | 0 |
157866 | 157866 | 2020-05-19 | Lawrence | Illinois | 17101 | 4 | 0 |
160892 | 160892 | 2020-05-20 | Lawrence | Illinois | 17101 | 4 | 0 |
163920 | 163920 | 2020-05-21 | Lawrence | Illinois | 17101 | 4 | 0 |
166953 | 166953 | 2020-05-22 | Lawrence | Illinois | 17101 | 4 | 0 |
169990 | 169990 | 2020-05-23 | Lawrence | Illinois | 17101 | 4 | 0 |
173031 | 173031 | 2020-05-24 | Lawrence | Illinois | 17101 | 4 | 0 |
176075 | 176075 | 2020-05-25 | Lawrence | Illinois | 17101 | 4 | 0 |
179119 | 179119 | 2020-05-26 | Lawrence | Illinois | 17101 | 4 | 0 |
182163 | 182163 | 2020-05-27 | Lawrence | Illinois | 17101 | 4 | 0 |
185217 | 185217 | 2020-05-28 | Lawrence | Illinois | 17101 | 4 | 0 |
188275 | 188275 | 2020-05-29 | Lawrence | Illinois | 17101 | 4 | 0 |
191340 | 191340 | 2020-05-30 | Lawrence | Illinois | 17101 | 4 | 0 |
194407 | 194407 | 2020-05-31 | Lawrence | Illinois | 17101 | 4 | 0 |
197477 | 197477 | 2020-06-01 | Lawrence | Illinois | 17101 | 4 | 0 |
200550 | 200550 | 2020-06-02 | Lawrence | Illinois | 17101 | 4 | 0 |
200943 | 200943 | 2020-06-02 | Lawrence | Kentucky | 21127 | 4 | 0 |
203626 | 203626 | 2020-06-03 | Lawrence | Illinois | 17101 | 4 | 0 |
204020 | 204020 | 2020-06-03 | Lawrence | Kentucky | 21127 | 4 | 0 |
206706 | 206706 | 2020-06-04 | Lawrence | Illinois | 17101 | 4 | 0 |
207101 | 207101 | 2020-06-04 | Lawrence | Kentucky | 21127 | 4 | 0 |
209787 | 209787 | 2020-06-05 | Lawrence | Illinois | 17101 | 4 | 0 |
212872 | 212872 | 2020-06-06 | Lawrence | Illinois | 17101 | 4 | 0 |
215959 | 215959 | 2020-06-07 | Lawrence | Illinois | 17101 | 4 | 0 |
219050 | 219050 | 2020-06-08 | Lawrence | Illinois | 17101 | 4 | 0 |
222145 | 222145 | 2020-06-09 | Lawrence | Illinois | 17101 | 4 | 0 |
225240 | 225240 | 2020-06-10 | Lawrence | Illinois | 17101 | 4 | 0 |
228342 | 228342 | 2020-06-11 | Lawrence | Illinois | 17101 | 4 | 0 |
231445 | 231445 | 2020-06-12 | Lawrence | Illinois | 17101 | 4 | 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);