ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where county = "Lawrence" and deaths = 2 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 10
- Missouri 75
- Mississippi 16
- Illinois 13
- Pennsylvania 10
- Kentucky 9
- Tennessee 7
- South Dakota 3
- Alabama 2
- Arkansas 2
- Indiana 1
county 1
- Lawrence · 138 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
23319 | 23319 | 2020-03-31 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
25517 | 25517 | 2020-04-01 | Lawrence | Pennsylvania | 42073 | 13 | 2 |
26712 | 26712 | 2020-04-02 | Lawrence | Indiana | 18093 | 13 | 2 |
27790 | 27790 | 2020-04-02 | Lawrence | Pennsylvania | 42073 | 16 | 2 |
30124 | 30124 | 2020-04-03 | Lawrence | Pennsylvania | 42073 | 19 | 2 |
32514 | 32514 | 2020-04-04 | Lawrence | Pennsylvania | 42073 | 22 | 2 |
34950 | 34950 | 2020-04-05 | Lawrence | Pennsylvania | 42073 | 23 | 2 |
37425 | 37425 | 2020-04-06 | Lawrence | Pennsylvania | 42073 | 24 | 2 |
39948 | 39948 | 2020-04-07 | Lawrence | Pennsylvania | 42073 | 29 | 2 |
42508 | 42508 | 2020-04-08 | Lawrence | Pennsylvania | 42073 | 32 | 2 |
45094 | 45094 | 2020-04-09 | Lawrence | Pennsylvania | 42073 | 37 | 2 |
101148 | 101148 | 2020-04-30 | Lawrence | Arkansas | 5075 | 59 | 2 |
104003 | 104003 | 2020-05-01 | Lawrence | Arkansas | 5075 | 59 | 2 |
329798 | 329798 | 2020-07-13 | Lawrence | Missouri | 29109 | 60 | 2 |
332985 | 332985 | 2020-07-14 | Lawrence | Missouri | 29109 | 60 | 2 |
336178 | 336178 | 2020-07-15 | Lawrence | Missouri | 29109 | 65 | 2 |
245712 | 245712 | 2020-06-16 | Lawrence | Tennessee | 47099 | 70 | 2 |
248825 | 248825 | 2020-06-17 | Lawrence | Tennessee | 47099 | 72 | 2 |
251940 | 251940 | 2020-06-18 | Lawrence | Tennessee | 47099 | 76 | 2 |
255055 | 255055 | 2020-06-19 | Lawrence | Tennessee | 47099 | 78 | 2 |
258181 | 258181 | 2020-06-20 | Lawrence | Tennessee | 47099 | 81 | 2 |
261308 | 261308 | 2020-06-21 | Lawrence | Tennessee | 47099 | 81 | 2 |
264436 | 264436 | 2020-06-22 | Lawrence | Tennessee | 47099 | 81 | 2 |
339374 | 339374 | 2020-07-16 | Lawrence | Missouri | 29109 | 81 | 2 |
342570 | 342570 | 2020-07-17 | Lawrence | Missouri | 29109 | 86 | 2 |
345770 | 345770 | 2020-07-18 | Lawrence | Missouri | 29109 | 87 | 2 |
348971 | 348971 | 2020-07-19 | Lawrence | Missouri | 29109 | 94 | 2 |
352171 | 352171 | 2020-07-20 | Lawrence | Missouri | 29109 | 104 | 2 |
355373 | 355373 | 2020-07-21 | Lawrence | Missouri | 29109 | 106 | 2 |
358576 | 358576 | 2020-07-22 | Lawrence | Missouri | 29109 | 110 | 2 |
361781 | 361781 | 2020-07-23 | Lawrence | Missouri | 29109 | 122 | 2 |
364988 | 364988 | 2020-07-24 | Lawrence | Missouri | 29109 | 125 | 2 |
472228 | 472228 | 2020-08-26 | Lawrence | South Dakota | 46081 | 129 | 2 |
368196 | 368196 | 2020-07-25 | Lawrence | Missouri | 29109 | 134 | 2 |
371407 | 371407 | 2020-07-26 | Lawrence | Missouri | 29109 | 136 | 2 |
374619 | 374619 | 2020-07-27 | Lawrence | Missouri | 29109 | 142 | 2 |
377834 | 377834 | 2020-07-28 | Lawrence | Missouri | 29109 | 152 | 2 |
381051 | 381051 | 2020-07-29 | Lawrence | Missouri | 29109 | 159 | 2 |
475462 | 475462 | 2020-08-27 | Lawrence | South Dakota | 46081 | 171 | 2 |
384267 | 384267 | 2020-07-30 | Lawrence | Missouri | 29109 | 172 | 2 |
304296 | 304296 | 2020-07-05 | Lawrence | Mississippi | 28077 | 177 | 2 |
307463 | 307463 | 2020-07-06 | Lawrence | Mississippi | 28077 | 178 | 2 |
387485 | 387485 | 2020-07-31 | Lawrence | Missouri | 29109 | 182 | 2 |
390702 | 390702 | 2020-08-01 | Lawrence | Missouri | 29109 | 184 | 2 |
393919 | 393919 | 2020-08-02 | Lawrence | Missouri | 29109 | 186 | 2 |
310631 | 310631 | 2020-07-07 | Lawrence | Mississippi | 28077 | 187 | 2 |
313801 | 313801 | 2020-07-08 | Lawrence | Mississippi | 28077 | 189 | 2 |
478695 | 478695 | 2020-08-28 | Lawrence | South Dakota | 46081 | 190 | 2 |
397135 | 397135 | 2020-08-03 | Lawrence | Missouri | 29109 | 192 | 2 |
400349 | 400349 | 2020-08-04 | Lawrence | Missouri | 29109 | 195 | 2 |
316975 | 316975 | 2020-07-09 | Lawrence | Mississippi | 28077 | 199 | 2 |
320150 | 320150 | 2020-07-10 | Lawrence | Mississippi | 28077 | 202 | 2 |
403566 | 403566 | 2020-08-05 | Lawrence | Missouri | 29109 | 202 | 2 |
345670 | 345670 | 2020-07-18 | Lawrence | Mississippi | 28077 | 203 | 2 |
406784 | 406784 | 2020-08-06 | Lawrence | Missouri | 29109 | 205 | 2 |
348871 | 348871 | 2020-07-19 | Lawrence | Mississippi | 28077 | 207 | 2 |
352071 | 352071 | 2020-07-20 | Lawrence | Mississippi | 28077 | 208 | 2 |
323329 | 323329 | 2020-07-11 | Lawrence | Mississippi | 28077 | 209 | 2 |
410004 | 410004 | 2020-08-07 | Lawrence | Missouri | 29109 | 211 | 2 |
413224 | 413224 | 2020-08-08 | Lawrence | Missouri | 29109 | 211 | 2 |
326512 | 326512 | 2020-07-12 | Lawrence | Mississippi | 28077 | 213 | 2 |
329698 | 329698 | 2020-07-13 | Lawrence | Mississippi | 28077 | 216 | 2 |
332885 | 332885 | 2020-07-14 | Lawrence | Mississippi | 28077 | 218 | 2 |
336078 | 336078 | 2020-07-15 | Lawrence | Mississippi | 28077 | 222 | 2 |
342470 | 342470 | 2020-07-17 | Lawrence | Mississippi | 28077 | 225 | 2 |
339274 | 339274 | 2020-07-16 | Lawrence | Mississippi | 28077 | 226 | 2 |
416444 | 416444 | 2020-08-09 | Lawrence | Missouri | 29109 | 228 | 2 |
419665 | 419665 | 2020-08-10 | Lawrence | Missouri | 29109 | 230 | 2 |
422887 | 422887 | 2020-08-11 | Lawrence | Missouri | 29109 | 233 | 2 |
541544 | 541544 | 2020-09-17 | Lawrence | Illinois | 17101 | 239 | 2 |
426109 | 426109 | 2020-08-12 | Lawrence | Missouri | 29109 | 240 | 2 |
544780 | 544780 | 2020-09-18 | Lawrence | Illinois | 17101 | 242 | 2 |
548018 | 548018 | 2020-09-19 | Lawrence | Illinois | 17101 | 242 | 2 |
551257 | 551257 | 2020-09-20 | Lawrence | Illinois | 17101 | 245 | 2 |
429333 | 429333 | 2020-08-13 | Lawrence | Missouri | 29109 | 246 | 2 |
432560 | 432560 | 2020-08-14 | Lawrence | Missouri | 29109 | 247 | 2 |
554496 | 554496 | 2020-09-21 | Lawrence | Illinois | 17101 | 249 | 2 |
557733 | 557733 | 2020-09-22 | Lawrence | Illinois | 17101 | 250 | 2 |
560969 | 560969 | 2020-09-23 | Lawrence | Illinois | 17101 | 251 | 2 |
435786 | 435786 | 2020-08-15 | Lawrence | Missouri | 29109 | 252 | 2 |
564209 | 564209 | 2020-09-24 | Lawrence | Illinois | 17101 | 252 | 2 |
567449 | 567449 | 2020-09-25 | Lawrence | Illinois | 17101 | 252 | 2 |
570691 | 570691 | 2020-09-26 | Lawrence | Illinois | 17101 | 254 | 2 |
573934 | 573934 | 2020-09-27 | Lawrence | Illinois | 17101 | 256 | 2 |
577176 | 577176 | 2020-09-28 | Lawrence | Illinois | 17101 | 259 | 2 |
580417 | 580417 | 2020-09-29 | Lawrence | Illinois | 17101 | 259 | 2 |
439011 | 439011 | 2020-08-16 | Lawrence | Missouri | 29109 | 264 | 2 |
442238 | 442238 | 2020-08-17 | Lawrence | Missouri | 29109 | 271 | 2 |
445464 | 445464 | 2020-08-18 | Lawrence | Missouri | 29109 | 275 | 2 |
448690 | 448690 | 2020-08-19 | Lawrence | Missouri | 29109 | 288 | 2 |
451918 | 451918 | 2020-08-20 | Lawrence | Missouri | 29109 | 293 | 2 |
455146 | 455146 | 2020-08-21 | Lawrence | Missouri | 29109 | 296 | 2 |
458374 | 458374 | 2020-08-22 | Lawrence | Missouri | 29109 | 301 | 2 |
461601 | 461601 | 2020-08-23 | Lawrence | Missouri | 29109 | 310 | 2 |
464832 | 464832 | 2020-08-24 | Lawrence | Missouri | 29109 | 317 | 2 |
468061 | 468061 | 2020-08-25 | Lawrence | Missouri | 29109 | 319 | 2 |
471291 | 471291 | 2020-08-26 | Lawrence | Missouri | 29109 | 323 | 2 |
474523 | 474523 | 2020-08-27 | Lawrence | Missouri | 29109 | 335 | 2 |
477756 | 477756 | 2020-08-28 | Lawrence | Missouri | 29109 | 342 | 2 |
480988 | 480988 | 2020-08-29 | Lawrence | Missouri | 29109 | 351 | 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);