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 county
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 |
---|---|---|---|---|---|---|---|
5617 | 5617 | 2020-03-20 | Lawrence | Mississippi | 28077 | 1 | 0 |
6596 | 6596 | 2020-03-21 | Lawrence | Mississippi | 28077 | 1 | 0 |
7679 | 7679 | 2020-03-22 | Lawrence | Mississippi | 28077 | 2 | 0 |
8860 | 8860 | 2020-03-23 | Lawrence | Mississippi | 28077 | 2 | 0 |
9545 | 9545 | 2020-03-24 | Lawrence | Arkansas | 5075 | 1 | 0 |
9862 | 9862 | 2020-03-24 | Lawrence | Indiana | 18093 | 1 | 0 |
10156 | 10156 | 2020-03-24 | Lawrence | Mississippi | 28077 | 2 | 0 |
10857 | 10857 | 2020-03-25 | Lawrence | Alabama | 1079 | 1 | 0 |
10916 | 10916 | 2020-03-25 | Lawrence | Arkansas | 5075 | 1 | 0 |
11257 | 11257 | 2020-03-25 | Lawrence | Indiana | 18093 | 1 | 0 |
11576 | 11576 | 2020-03-25 | Lawrence | Mississippi | 28077 | 3 | 0 |
11881 | 11881 | 2020-03-25 | Lawrence | Ohio | 39087 | 1 | 0 |
11978 | 11978 | 2020-03-25 | Lawrence | Pennsylvania | 42073 | 1 | 0 |
12394 | 12394 | 2020-03-26 | Lawrence | Alabama | 1079 | 3 | 0 |
12459 | 12459 | 2020-03-26 | Lawrence | Arkansas | 5075 | 2 | 0 |
12814 | 12814 | 2020-03-26 | Lawrence | Indiana | 18093 | 2 | 0 |
13169 | 13169 | 2020-03-26 | Lawrence | Mississippi | 28077 | 5 | 0 |
13489 | 13489 | 2020-03-26 | Lawrence | Ohio | 39087 | 1 | 0 |
13599 | 13599 | 2020-03-26 | Lawrence | Pennsylvania | 42073 | 1 | 0 |
14055 | 14055 | 2020-03-27 | Lawrence | Alabama | 1079 | 3 | 0 |
14123 | 14123 | 2020-03-27 | Lawrence | Arkansas | 5075 | 3 | 0 |
14499 | 14499 | 2020-03-27 | Lawrence | Indiana | 18093 | 5 | 0 |
14887 | 14887 | 2020-03-27 | Lawrence | Mississippi | 28077 | 5 | 0 |
15227 | 15227 | 2020-03-27 | Lawrence | Ohio | 39087 | 1 | 0 |
15345 | 15345 | 2020-03-27 | Lawrence | Pennsylvania | 42073 | 4 | 0 |
15423 | 15423 | 2020-03-27 | Lawrence | South Dakota | 46081 | 2 | 0 |
15833 | 15833 | 2020-03-28 | Lawrence | Alabama | 1079 | 3 | 0 |
15904 | 15904 | 2020-03-28 | Lawrence | Arkansas | 5075 | 1 | 0 |
16297 | 16297 | 2020-03-28 | Lawrence | Indiana | 18093 | 4 | 0 |
16711 | 16711 | 2020-03-28 | Lawrence | Mississippi | 28077 | 5 | 0 |
17069 | 17069 | 2020-03-28 | Lawrence | Ohio | 39087 | 1 | 0 |
17195 | 17195 | 2020-03-28 | Lawrence | Pennsylvania | 42073 | 8 | 0 |
17281 | 17281 | 2020-03-28 | Lawrence | South Dakota | 46081 | 2 | 0 |
17716 | 17716 | 2020-03-29 | Lawrence | Alabama | 1079 | 3 | 0 |
17791 | 17791 | 2020-03-29 | Lawrence | Arkansas | 5075 | 1 | 0 |
18201 | 18201 | 2020-03-29 | Lawrence | Indiana | 18093 | 8 | 0 |
18633 | 18633 | 2020-03-29 | Lawrence | Mississippi | 28077 | 5 | 0 |
19003 | 19003 | 2020-03-29 | Lawrence | Ohio | 39087 | 1 | 0 |
19133 | 19133 | 2020-03-29 | Lawrence | Pennsylvania | 42073 | 8 | 1 |
19224 | 19224 | 2020-03-29 | Lawrence | South Dakota | 46081 | 3 | 0 |
19688 | 19688 | 2020-03-30 | Lawrence | Alabama | 1079 | 3 | 0 |
19765 | 19765 | 2020-03-30 | Lawrence | Arkansas | 5075 | 1 | 0 |
20207 | 20207 | 2020-03-30 | Lawrence | Indiana | 18093 | 9 | 0 |
20657 | 20657 | 2020-03-30 | Lawrence | Mississippi | 28077 | 5 | 0 |
21048 | 21048 | 2020-03-30 | Lawrence | Ohio | 39087 | 1 | 0 |
21183 | 21183 | 2020-03-30 | Lawrence | Pennsylvania | 42073 | 10 | 1 |
21276 | 21276 | 2020-03-30 | Lawrence | South Dakota | 46081 | 5 | 0 |
21327 | 21327 | 2020-03-30 | Lawrence | Tennessee | 47099 | 2 | 0 |
21760 | 21760 | 2020-03-31 | Lawrence | Alabama | 1079 | 3 | 0 |
21837 | 21837 | 2020-03-31 | Lawrence | Arkansas | 5075 | 1 | 0 |
22302 | 22302 | 2020-03-31 | Lawrence | Indiana | 18093 | 9 | 0 |
22476 | 22476 | 2020-03-31 | Lawrence | Kentucky | 21127 | 1 | 0 |
22774 | 22774 | 2020-03-31 | Lawrence | Mississippi | 28077 | 5 | 0 |
23180 | 23180 | 2020-03-31 | Lawrence | Ohio | 39087 | 1 | 0 |
23319 | 23319 | 2020-03-31 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
23414 | 23414 | 2020-03-31 | Lawrence | South Dakota | 46081 | 6 | 0 |
23466 | 23466 | 2020-03-31 | Lawrence | Tennessee | 47099 | 2 | 0 |
23916 | 23916 | 2020-04-01 | Lawrence | Alabama | 1079 | 3 | 0 |
23994 | 23994 | 2020-04-01 | Lawrence | Arkansas | 5075 | 2 | 0 |
24473 | 24473 | 2020-04-01 | Lawrence | Indiana | 18093 | 11 | 1 |
24652 | 24652 | 2020-04-01 | Lawrence | Kentucky | 21127 | 1 | 0 |
24958 | 24958 | 2020-04-01 | Lawrence | Mississippi | 28077 | 5 | 0 |
25375 | 25375 | 2020-04-01 | Lawrence | Ohio | 39087 | 1 | 0 |
25517 | 25517 | 2020-04-01 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
25612 | 25612 | 2020-04-01 | Lawrence | South Dakota | 46081 | 6 | 0 |
25668 | 25668 | 2020-04-01 | Lawrence | Tennessee | 47099 | 2 | 0 |
26138 | 26138 | 2020-04-02 | Lawrence | Alabama | 1079 | 3 | 0 |
26218 | 26218 | 2020-04-02 | Lawrence | Arkansas | 5075 | 3 | 0 |
26712 | 26712 | 2020-04-02 | Lawrence | Indiana | 18093 | 13 | 2 |
26899 | 26899 | 2020-04-02 | Lawrence | Kentucky | 21127 | 1 | 0 |
27212 | 27212 | 2020-04-02 | Lawrence | Mississippi | 28077 | 5 | 0 |
27643 | 27643 | 2020-04-02 | Lawrence | Ohio | 39087 | 2 | 0 |
27790 | 27790 | 2020-04-02 | Lawrence | Pennsylvania | 42073 | 16 | 2 |
27889 | 27889 | 2020-04-02 | Lawrence | South Dakota | 46081 | 9 | 0 |
27947 | 27947 | 2020-04-02 | Lawrence | Tennessee | 47099 | 2 | 0 |
28435 | 28435 | 2020-04-03 | Lawrence | Alabama | 1079 | 4 | 0 |
28516 | 28516 | 2020-04-03 | Lawrence | Arkansas | 5075 | 3 | 0 |
29022 | 29022 | 2020-04-03 | Lawrence | Indiana | 18093 | 23 | 5 |
29215 | 29215 | 2020-04-03 | Lawrence | Kentucky | 21127 | 1 | 0 |
29531 | 29531 | 2020-04-03 | Lawrence | Mississippi | 28077 | 5 | 0 |
29972 | 29972 | 2020-04-03 | Lawrence | Ohio | 39087 | 4 | 0 |
30124 | 30124 | 2020-04-03 | Lawrence | Pennsylvania | 42073 | 19 | 2 |
30224 | 30224 | 2020-04-03 | Lawrence | South Dakota | 46081 | 9 | 0 |
30282 | 30282 | 2020-04-03 | Lawrence | Tennessee | 47099 | 3 | 0 |
30792 | 30792 | 2020-04-04 | Lawrence | Alabama | 1079 | 4 | 0 |
30874 | 30874 | 2020-04-04 | Lawrence | Arkansas | 5075 | 3 | 1 |
31388 | 31388 | 2020-04-04 | Lawrence | Indiana | 18093 | 37 | 6 |
31591 | 31591 | 2020-04-04 | Lawrence | Kentucky | 21127 | 1 | 0 |
31911 | 31911 | 2020-04-04 | Lawrence | Mississippi | 28077 | 4 | 0 |
32361 | 32361 | 2020-04-04 | Lawrence | Ohio | 39087 | 7 | 0 |
32514 | 32514 | 2020-04-04 | Lawrence | Pennsylvania | 42073 | 22 | 2 |
32615 | 32615 | 2020-04-04 | Lawrence | South Dakota | 46081 | 9 | 0 |
32673 | 32673 | 2020-04-04 | Lawrence | Tennessee | 47099 | 3 | 0 |
33196 | 33196 | 2020-04-05 | Lawrence | Alabama | 1079 | 6 | 0 |
33278 | 33278 | 2020-04-05 | Lawrence | Arkansas | 5075 | 3 | 1 |
33799 | 33799 | 2020-04-05 | Lawrence | Indiana | 18093 | 40 | 6 |
34011 | 34011 | 2020-04-05 | Lawrence | Kentucky | 21127 | 1 | 0 |
34338 | 34338 | 2020-04-05 | Lawrence | Mississippi | 28077 | 4 | 0 |
34794 | 34794 | 2020-04-05 | Lawrence | Ohio | 39087 | 8 | 0 |
34950 | 34950 | 2020-04-05 | Lawrence | Pennsylvania | 42073 | 23 | 2 |
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);