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)
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 |
---|---|---|---|---|---|---|---|
2499614 | 2499614 | 2022-05-13 | Lawrence | Alabama | 1079 | 7682 | 160 |
2499723 | 2499723 | 2022-05-13 | Lawrence | Arkansas | 5075 | 5324 | 78 |
2500227 | 2500227 | 2022-05-13 | Lawrence | Illinois | 17101 | 5489 | 52 |
2500326 | 2500326 | 2022-05-13 | Lawrence | Indiana | 18093 | 12021 | 261 |
2500642 | 2500642 | 2022-05-13 | Lawrence | Kentucky | 21127 | 4503 | 69 |
2501031 | 2501031 | 2022-05-13 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2501132 | 2501132 | 2022-05-13 | Lawrence | Missouri | 29109 | 7798 | 164 |
2501687 | 2501687 | 2022-05-13 | Lawrence | Ohio | 39087 | 18071 | 256 |
2501883 | 2501883 | 2022-05-13 | Lawrence | Pennsylvania | 42073 | 19109 | 418 |
2502084 | 2502084 | 2022-05-13 | Lawrence | South Dakota | 46081 | 6605 | 83 |
2502160 | 2502160 | 2022-05-13 | Lawrence | Tennessee | 47099 | 14329 | 203 |
2496356 | 2496356 | 2022-05-12 | Lawrence | Alabama | 1079 | 7681 | 160 |
2496465 | 2496465 | 2022-05-12 | Lawrence | Arkansas | 5075 | 5319 | 78 |
2496969 | 2496969 | 2022-05-12 | Lawrence | Illinois | 17101 | 5487 | 52 |
2497068 | 2497068 | 2022-05-12 | Lawrence | Indiana | 18093 | 12000 | 261 |
2497384 | 2497384 | 2022-05-12 | Lawrence | Kentucky | 21127 | 4503 | 69 |
2497773 | 2497773 | 2022-05-12 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2497874 | 2497874 | 2022-05-12 | Lawrence | Missouri | 29109 | 7789 | 164 |
2498429 | 2498429 | 2022-05-12 | Lawrence | Ohio | 39087 | 18071 | 256 |
2498625 | 2498625 | 2022-05-12 | Lawrence | Pennsylvania | 42073 | 19109 | 418 |
2498826 | 2498826 | 2022-05-12 | Lawrence | South Dakota | 46081 | 6605 | 83 |
2498902 | 2498902 | 2022-05-12 | Lawrence | Tennessee | 47099 | 14329 | 203 |
2493098 | 2493098 | 2022-05-11 | Lawrence | Alabama | 1079 | 7680 | 159 |
2493207 | 2493207 | 2022-05-11 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2493711 | 2493711 | 2022-05-11 | Lawrence | Illinois | 17101 | 5487 | 52 |
2493810 | 2493810 | 2022-05-11 | Lawrence | Indiana | 18093 | 12000 | 261 |
2494126 | 2494126 | 2022-05-11 | Lawrence | Kentucky | 21127 | 4503 | 69 |
2494515 | 2494515 | 2022-05-11 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2494616 | 2494616 | 2022-05-11 | Lawrence | Missouri | 29109 | 7789 | 164 |
2495171 | 2495171 | 2022-05-11 | Lawrence | Ohio | 39087 | 17998 | 253 |
2495367 | 2495367 | 2022-05-11 | Lawrence | Pennsylvania | 42073 | 19109 | 418 |
2495568 | 2495568 | 2022-05-11 | Lawrence | South Dakota | 46081 | 6605 | 83 |
2495644 | 2495644 | 2022-05-11 | Lawrence | Tennessee | 47099 | 14329 | 203 |
2489840 | 2489840 | 2022-05-10 | Lawrence | Alabama | 1079 | 7680 | 159 |
2489949 | 2489949 | 2022-05-10 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2490453 | 2490453 | 2022-05-10 | Lawrence | Illinois | 17101 | 5487 | 52 |
2490552 | 2490552 | 2022-05-10 | Lawrence | Indiana | 18093 | 11993 | 261 |
2490868 | 2490868 | 2022-05-10 | Lawrence | Kentucky | 21127 | 4503 | 69 |
2491257 | 2491257 | 2022-05-10 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2491358 | 2491358 | 2022-05-10 | Lawrence | Missouri | 29109 | 7789 | 164 |
2491913 | 2491913 | 2022-05-10 | Lawrence | Ohio | 39087 | 17998 | 253 |
2492109 | 2492109 | 2022-05-10 | Lawrence | Pennsylvania | 42073 | 19030 | 416 |
2492310 | 2492310 | 2022-05-10 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2492386 | 2492386 | 2022-05-10 | Lawrence | Tennessee | 47099 | 14322 | 203 |
2486583 | 2486583 | 2022-05-09 | Lawrence | Alabama | 1079 | 7679 | 159 |
2486692 | 2486692 | 2022-05-09 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2487196 | 2487196 | 2022-05-09 | Lawrence | Illinois | 17101 | 5494 | 52 |
2487295 | 2487295 | 2022-05-09 | Lawrence | Indiana | 18093 | 11993 | 261 |
2487611 | 2487611 | 2022-05-09 | Lawrence | Kentucky | 21127 | 4503 | 69 |
2488000 | 2488000 | 2022-05-09 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2488100 | 2488100 | 2022-05-09 | Lawrence | Missouri | 29109 | 7789 | 164 |
2488655 | 2488655 | 2022-05-09 | Lawrence | Ohio | 39087 | 17998 | 253 |
2488851 | 2488851 | 2022-05-09 | Lawrence | Pennsylvania | 42073 | 19030 | 416 |
2489052 | 2489052 | 2022-05-09 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2489128 | 2489128 | 2022-05-09 | Lawrence | Tennessee | 47099 | 14322 | 203 |
2483325 | 2483325 | 2022-05-08 | Lawrence | Alabama | 1079 | 7678 | 159 |
2483434 | 2483434 | 2022-05-08 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2483938 | 2483938 | 2022-05-08 | Lawrence | Illinois | 17101 | 5493 | 52 |
2484037 | 2484037 | 2022-05-08 | Lawrence | Indiana | 18093 | 11950 | 260 |
2484353 | 2484353 | 2022-05-08 | Lawrence | Kentucky | 21127 | 4508 | 69 |
2484742 | 2484742 | 2022-05-08 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2484843 | 2484843 | 2022-05-08 | Lawrence | Missouri | 29109 | 7789 | 164 |
2485398 | 2485398 | 2022-05-08 | Lawrence | Ohio | 39087 | 17998 | 253 |
2485594 | 2485594 | 2022-05-08 | Lawrence | Pennsylvania | 42073 | 19030 | 416 |
2485795 | 2485795 | 2022-05-08 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2485871 | 2485871 | 2022-05-08 | Lawrence | Tennessee | 47099 | 14322 | 203 |
2480067 | 2480067 | 2022-05-07 | Lawrence | Alabama | 1079 | 7678 | 159 |
2480176 | 2480176 | 2022-05-07 | Lawrence | Arkansas | 5075 | 5317 | 78 |
2480680 | 2480680 | 2022-05-07 | Lawrence | Illinois | 17101 | 5493 | 52 |
2480779 | 2480779 | 2022-05-07 | Lawrence | Indiana | 18093 | 11950 | 260 |
2481095 | 2481095 | 2022-05-07 | Lawrence | Kentucky | 21127 | 4508 | 69 |
2481484 | 2481484 | 2022-05-07 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2481585 | 2481585 | 2022-05-07 | Lawrence | Missouri | 29109 | 7789 | 164 |
2482140 | 2482140 | 2022-05-07 | Lawrence | Ohio | 39087 | 17998 | 253 |
2482336 | 2482336 | 2022-05-07 | Lawrence | Pennsylvania | 42073 | 19030 | 416 |
2482537 | 2482537 | 2022-05-07 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2482613 | 2482613 | 2022-05-07 | Lawrence | Tennessee | 47099 | 14322 | 203 |
2476809 | 2476809 | 2022-05-06 | Lawrence | Alabama | 1079 | 7678 | 159 |
2476918 | 2476918 | 2022-05-06 | Lawrence | Arkansas | 5075 | 5314 | 78 |
2477422 | 2477422 | 2022-05-06 | Lawrence | Illinois | 17101 | 5493 | 52 |
2477521 | 2477521 | 2022-05-06 | Lawrence | Indiana | 18093 | 11950 | 260 |
2477837 | 2477837 | 2022-05-06 | Lawrence | Kentucky | 21127 | 4508 | 69 |
2478226 | 2478226 | 2022-05-06 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2478327 | 2478327 | 2022-05-06 | Lawrence | Missouri | 29109 | 7789 | 164 |
2478882 | 2478882 | 2022-05-06 | Lawrence | Ohio | 39087 | 17998 | 253 |
2479078 | 2479078 | 2022-05-06 | Lawrence | Pennsylvania | 42073 | 19030 | 416 |
2479279 | 2479279 | 2022-05-06 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2479355 | 2479355 | 2022-05-06 | Lawrence | Tennessee | 47099 | 14322 | 203 |
2473551 | 2473551 | 2022-05-05 | Lawrence | Alabama | 1079 | 7677 | 158 |
2473660 | 2473660 | 2022-05-05 | Lawrence | Arkansas | 5075 | 5311 | 78 |
2474164 | 2474164 | 2022-05-05 | Lawrence | Illinois | 17101 | 5492 | 52 |
2474263 | 2474263 | 2022-05-05 | Lawrence | Indiana | 18093 | 11950 | 260 |
2474579 | 2474579 | 2022-05-05 | Lawrence | Kentucky | 21127 | 4508 | 69 |
2474968 | 2474968 | 2022-05-05 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2475069 | 2475069 | 2022-05-05 | Lawrence | Missouri | 29109 | 7786 | 164 |
2475624 | 2475624 | 2022-05-05 | Lawrence | Ohio | 39087 | 17998 | 253 |
2475820 | 2475820 | 2022-05-05 | Lawrence | Pennsylvania | 42073 | 19030 | 416 |
2476021 | 2476021 | 2022-05-05 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2476097 | 2476097 | 2022-05-05 | Lawrence | Tennessee | 47099 | 14322 | 203 |
2470294 | 2470294 | 2022-05-04 | Lawrence | Alabama | 1079 | 7673 | 158 |
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);