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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 337 ✖
- 0 1,019
- 43 196
- 2 138
- 9 135
- 1 133
- 14 117
- 36 115
- 47 114
- 8 106
- 25 103
- 28 103
- 34 103
- 41 103
- 48 99
- 100 98
- 20 97
- 33 95
- 45 95
- 24 94
- 40 94
- 5 93
- 56 93
- 6 89
- 44 89
- 102 85
- 4 83
- 23 76
- 29 76
- 50 71
- 86 71
- 22 70
- 17 67
- 26 67
- 51 66
- 82 64
- 83 64
- 31 63
- 11 62
- 42 60
- 52 60
- 164 56
- 104 55
- 38 52
- 69 50
- 98 49
- 77 48
- 27 46
- 32 46
- 46 46
- 78 46
- 49 45
- 59 45
- 18 44
- 30 44
- 10 43
- 64 43
- 94 43
- 125 43
- 87 42
- 101 42
- 12 40
- 16 40
- 21 39
- 67 38
- 103 38
- 35 36
- 62 36
- 92 36
- 13 35
- 95 35
- 65 34
- 3 33
- 7 33
- 79 33
- 107 32
- 130 32
- 39 31
- 58 31
- 68 31
- 121 31
- 153 31
- 216 31
- 37 30
- 76 30
- 136 30
- 259 30
- 55 28
- 124 28
- 53 27
- 114 27
- 137 27
- 84 26
- 123 26
- 63 25
- 74 25
- 154 25
- 158 25
- 138 24
- 57 23
- 140 23
- 61 21
- 111 21
- 143 21
- 54 20
- 89 20
- 163 20
- 185 20
- 412 20
- 80 19
- 81 19
- 97 19
- 116 19
- 119 19
- 126 19
- 73 18
- 75 18
- 135 18
- 148 18
- 157 18
- 159 18
- 172 18
- 203 18
- 96 17
- 106 17
- 117 17
- 127 17
- 200 17
- 120 16
- 134 16
- 183 16
- 186 16
- 195 16
- 205 16
- 233 16
- 250 16
- 66 15
- 71 15
- 72 15
- 258 15
- 60 14
- 91 14
- 108 14
- 145 14
- 170 14
- 175 14
- 182 14
- 242 14
- 247 14
- 15 13
- 191 13
- 198 13
- 261 13
- 70 12
- 109 12
- 129 12
- 150 12
- 168 12
- 181 12
- 202 12
- 218 12
- 219 12
- 253 12
- 416 12
- 128 11
- 212 11
- 239 11
- 19 10
- 93 10
- 115 10
- 144 10
- 187 10
- 190 10
- 194 10
- 207 10
- 211 10
- 229 10
- 256 10
- 260 10
- 139 9
- 155 9
- 160 9
- 173 9
- 174 9
- 192 9
- 208 9
- 209 9
- 232 9
- 85 8
- 110 8
- 131 8
- 133 8
- 141 8
- 156 8
- 166 8
- 167 8
- 171 8
- 184 8
- 210 8
- 222 8
- 231 8
- 240 8
- 408 8
- 415 8
- 90 7
- 113 7
- 132 7
- 146 7
- 165 7
- 177 7
- 214 7
- 220 7
- 227 7
- 414 7
- 99 6
- 118 6
- 169 6
- 188 6
- 224 6
- 326 6
- 105 5
- 149 5
- 189 5
- 234 5
- 236 5
- 238 5
- 277 5
- 292 5
- 398 5
- 88 4
- 142 4
- 180 4
- 196 4
- 213 4
- 217 4
- 223 4
- 225 4
- 243 4
- 262 4
- 271 4
- 284 4
- 334 4
- 357 4
- 377 4
- 381 4
- 402 4
- 407 4
- 410 4
- 152 3
- 162 3
- 178 3
- 193 3
- 197 3
- 237 3
- 246 3
- 318 3
- 323 3
- 380 3
- 390 3
- 411 3
- 418 3
- 122 2
- 147 2
- 151 2
- 161 2
- 176 2
- 179 2
- 215 2
- 226 2
- 230 2
- 241 2
- 252 2
- 254 2
- 255 2
- 257 2
- 274 2
- 305 2
- 311 2
- 344 2
- 347 2
- 355 2
- 368 2
- 397 2
- 406 2
- 413 2
- 112 1
- 199 1
- 201 1
- 204 1
- 206 1
- 228 1
- 235 1
- 244 1
- 245 1
- 251 1
- 264 1
- 266 1
- 268 1
- 270 1
- 275 1
- 280 1
- 282 1
- 285 1
- 294 1
- 297 1
- 299 1
- 300 1
- 304 1
- 309 1
- 313 1
- 317 1
- 319 1
- 320 1
- 321 1
- 325 1
- 328 1
- 333 1
- 335 1
- 337 1
- 342 1
- 346 1
- 349 1
- 352 1
- 358 1
- 360 1
- 365 1
- 369 1
- 370 1
- 371 1
- 374 1
- 379 1
- 384 1
- 386 1
- 389 1
- 392 1
- 400 1
- 401 1
- 405 1
state 11
- Mississippi 785
- Arkansas 781
- Indiana 781
- Alabama 780
- Ohio 780
- Pennsylvania 780
- South Dakota 778
- Tennessee 775
- Kentucky 774
- Illinois 767
- Missouri 741
fips 11
county 1
- Lawrence · 8,522 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10857 | 10857 | 2020-03-25 | Lawrence | Alabama | 1079 | 1 | 0 |
12394 | 12394 | 2020-03-26 | Lawrence | Alabama | 1079 | 3 | 0 |
14055 | 14055 | 2020-03-27 | Lawrence | Alabama | 1079 | 3 | 0 |
15833 | 15833 | 2020-03-28 | Lawrence | Alabama | 1079 | 3 | 0 |
17716 | 17716 | 2020-03-29 | Lawrence | Alabama | 1079 | 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 |
28435 | 28435 | 2020-04-03 | Lawrence | Alabama | 1079 | 4 | 0 |
30792 | 30792 | 2020-04-04 | Lawrence | Alabama | 1079 | 4 | 0 |
33196 | 33196 | 2020-04-05 | Lawrence | Alabama | 1079 | 6 | 0 |
35635 | 35635 | 2020-04-06 | Lawrence | Alabama | 1079 | 8 | 0 |
38123 | 38123 | 2020-04-07 | Lawrence | Alabama | 1079 | 8 | 0 |
40665 | 40665 | 2020-04-08 | Lawrence | Alabama | 1079 | 8 | 0 |
43238 | 43238 | 2020-04-09 | Lawrence | Alabama | 1079 | 8 | 0 |
45836 | 45836 | 2020-04-10 | Lawrence | Alabama | 1079 | 8 | 0 |
48465 | 48465 | 2020-04-11 | Lawrence | Alabama | 1079 | 8 | 0 |
51127 | 51127 | 2020-04-12 | Lawrence | Alabama | 1079 | 8 | 0 |
53805 | 53805 | 2020-04-13 | Lawrence | Alabama | 1079 | 8 | 0 |
56497 | 56497 | 2020-04-14 | Lawrence | Alabama | 1079 | 8 | 0 |
59205 | 59205 | 2020-04-15 | Lawrence | Alabama | 1079 | 8 | 0 |
61923 | 61923 | 2020-04-16 | Lawrence | Alabama | 1079 | 8 | 0 |
64656 | 64656 | 2020-04-17 | Lawrence | Alabama | 1079 | 8 | 0 |
67404 | 67404 | 2020-04-18 | Lawrence | Alabama | 1079 | 9 | 0 |
70166 | 70166 | 2020-04-19 | Lawrence | Alabama | 1079 | 9 | 0 |
72935 | 72935 | 2020-04-20 | Lawrence | Alabama | 1079 | 10 | 0 |
75711 | 75711 | 2020-04-21 | Lawrence | Alabama | 1079 | 10 | 0 |
78494 | 78494 | 2020-04-22 | Lawrence | Alabama | 1079 | 12 | 0 |
81287 | 81287 | 2020-04-23 | Lawrence | Alabama | 1079 | 12 | 0 |
84088 | 84088 | 2020-04-24 | Lawrence | Alabama | 1079 | 12 | 0 |
86896 | 86896 | 2020-04-25 | Lawrence | Alabama | 1079 | 12 | 0 |
89712 | 89712 | 2020-04-26 | Lawrence | Alabama | 1079 | 12 | 0 |
92530 | 92530 | 2020-04-27 | Lawrence | Alabama | 1079 | 12 | 0 |
95360 | 95360 | 2020-04-28 | Lawrence | Alabama | 1079 | 12 | 0 |
98205 | 98205 | 2020-04-29 | Lawrence | Alabama | 1079 | 12 | 0 |
101055 | 101055 | 2020-04-30 | Lawrence | Alabama | 1079 | 12 | 0 |
103910 | 103910 | 2020-05-01 | Lawrence | Alabama | 1079 | 13 | 0 |
106775 | 106775 | 2020-05-02 | Lawrence | Alabama | 1079 | 13 | 0 |
109644 | 109644 | 2020-05-03 | Lawrence | Alabama | 1079 | 14 | 0 |
112519 | 112519 | 2020-05-04 | Lawrence | Alabama | 1079 | 14 | 0 |
115402 | 115402 | 2020-05-05 | Lawrence | Alabama | 1079 | 16 | 0 |
118361 | 118361 | 2020-05-06 | Lawrence | Alabama | 1079 | 17 | 0 |
121327 | 121327 | 2020-05-07 | Lawrence | Alabama | 1079 | 19 | 0 |
124307 | 124307 | 2020-05-08 | Lawrence | Alabama | 1079 | 21 | 0 |
127292 | 127292 | 2020-05-09 | Lawrence | Alabama | 1079 | 22 | 0 |
130282 | 130282 | 2020-05-10 | Lawrence | Alabama | 1079 | 25 | 0 |
133272 | 133272 | 2020-05-11 | Lawrence | Alabama | 1079 | 26 | 0 |
136262 | 136262 | 2020-05-12 | Lawrence | Alabama | 1079 | 26 | 0 |
139253 | 139253 | 2020-05-13 | Lawrence | Alabama | 1079 | 26 | 0 |
142249 | 142249 | 2020-05-14 | Lawrence | Alabama | 1079 | 28 | 0 |
145248 | 145248 | 2020-05-15 | Lawrence | Alabama | 1079 | 29 | 0 |
148251 | 148251 | 2020-05-16 | Lawrence | Alabama | 1079 | 29 | 0 |
151260 | 151260 | 2020-05-17 | Lawrence | Alabama | 1079 | 29 | 0 |
154272 | 154272 | 2020-05-18 | Lawrence | Alabama | 1079 | 33 | 0 |
157288 | 157288 | 2020-05-19 | Lawrence | Alabama | 1079 | 35 | 0 |
160312 | 160312 | 2020-05-20 | Lawrence | Alabama | 1079 | 35 | 0 |
163340 | 163340 | 2020-05-21 | Lawrence | Alabama | 1079 | 40 | 0 |
166372 | 166372 | 2020-05-22 | Lawrence | Alabama | 1079 | 40 | 0 |
169408 | 169408 | 2020-05-23 | Lawrence | Alabama | 1079 | 41 | 0 |
172449 | 172449 | 2020-05-24 | Lawrence | Alabama | 1079 | 42 | 0 |
175492 | 175492 | 2020-05-25 | Lawrence | Alabama | 1079 | 43 | 0 |
178537 | 178537 | 2020-05-26 | Lawrence | Alabama | 1079 | 45 | 0 |
181581 | 181581 | 2020-05-27 | Lawrence | Alabama | 1079 | 46 | 0 |
184633 | 184633 | 2020-05-28 | Lawrence | Alabama | 1079 | 46 | 0 |
187690 | 187690 | 2020-05-29 | Lawrence | Alabama | 1079 | 48 | 0 |
190754 | 190754 | 2020-05-30 | Lawrence | Alabama | 1079 | 48 | 0 |
193820 | 193820 | 2020-05-31 | Lawrence | Alabama | 1079 | 50 | 0 |
196890 | 196890 | 2020-06-01 | Lawrence | Alabama | 1079 | 51 | 0 |
199963 | 199963 | 2020-06-02 | Lawrence | Alabama | 1079 | 52 | 0 |
203039 | 203039 | 2020-06-03 | Lawrence | Alabama | 1079 | 52 | 0 |
206118 | 206118 | 2020-06-04 | Lawrence | Alabama | 1079 | 52 | 0 |
209200 | 209200 | 2020-06-05 | Lawrence | Alabama | 1079 | 52 | 0 |
212285 | 212285 | 2020-06-06 | Lawrence | Alabama | 1079 | 54 | 0 |
215372 | 215372 | 2020-06-07 | Lawrence | Alabama | 1079 | 56 | 0 |
218462 | 218462 | 2020-06-08 | Lawrence | Alabama | 1079 | 56 | 0 |
221554 | 221554 | 2020-06-09 | Lawrence | Alabama | 1079 | 57 | 0 |
224650 | 224650 | 2020-06-10 | Lawrence | Alabama | 1079 | 59 | 0 |
227751 | 227751 | 2020-06-11 | Lawrence | Alabama | 1079 | 61 | 0 |
230855 | 230855 | 2020-06-12 | Lawrence | Alabama | 1079 | 61 | 0 |
233960 | 233960 | 2020-06-13 | Lawrence | Alabama | 1079 | 64 | 0 |
237067 | 237067 | 2020-06-14 | Lawrence | Alabama | 1079 | 65 | 0 |
240175 | 240175 | 2020-06-15 | Lawrence | Alabama | 1079 | 66 | 0 |
243286 | 243286 | 2020-06-16 | Lawrence | Alabama | 1079 | 67 | 0 |
246399 | 246399 | 2020-06-17 | Lawrence | Alabama | 1079 | 68 | 0 |
249511 | 249511 | 2020-06-18 | Lawrence | Alabama | 1079 | 72 | 0 |
252626 | 252626 | 2020-06-19 | Lawrence | Alabama | 1079 | 74 | 0 |
255745 | 255745 | 2020-06-20 | Lawrence | Alabama | 1079 | 75 | 0 |
258872 | 258872 | 2020-06-21 | Lawrence | Alabama | 1079 | 78 | 0 |
261999 | 261999 | 2020-06-22 | Lawrence | Alabama | 1079 | 79 | 0 |
265128 | 265128 | 2020-06-23 | Lawrence | Alabama | 1079 | 80 | 0 |
268257 | 268257 | 2020-06-24 | Lawrence | Alabama | 1079 | 84 | 0 |
271391 | 271391 | 2020-06-25 | Lawrence | Alabama | 1079 | 87 | 0 |
274531 | 274531 | 2020-06-26 | Lawrence | Alabama | 1079 | 88 | 0 |
277679 | 277679 | 2020-06-27 | Lawrence | Alabama | 1079 | 93 | 0 |
280827 | 280827 | 2020-06-28 | Lawrence | Alabama | 1079 | 97 | 0 |
283973 | 283973 | 2020-06-29 | Lawrence | Alabama | 1079 | 100 | 0 |
287119 | 287119 | 2020-06-30 | Lawrence | Alabama | 1079 | 103 | 0 |
290269 | 290269 | 2020-07-01 | Lawrence | Alabama | 1079 | 104 | 0 |
293422 | 293422 | 2020-07-02 | Lawrence | Alabama | 1079 | 103 | 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);