ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where county = "Lawrence" and deaths = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Arkansas 76
- Pennsylvania 35
- Tennessee 11
- Illinois 5
- Mississippi 5
- South Dakota 3
county 1
- Lawrence · 135 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
758822 | 758822 | 2020-11-23 | Lawrence | Illinois | 17101 | 873 | 9 |
755575 | 755575 | 2020-11-22 | Lawrence | Illinois | 17101 | 855 | 9 |
752329 | 752329 | 2020-11-21 | Lawrence | Illinois | 17101 | 821 | 9 |
749083 | 749083 | 2020-11-20 | Lawrence | Illinois | 17101 | 788 | 9 |
745837 | 745837 | 2020-11-19 | Lawrence | Illinois | 17101 | 712 | 9 |
741193 | 741193 | 2020-11-17 | Lawrence | South Dakota | 46081 | 1690 | 9 |
737947 | 737947 | 2020-11-16 | Lawrence | South Dakota | 46081 | 1668 | 9 |
734703 | 734703 | 2020-11-15 | Lawrence | South Dakota | 46081 | 1644 | 9 |
501407 | 501407 | 2020-09-04 | Lawrence | Tennessee | 47099 | 768 | 9 |
498173 | 498173 | 2020-09-03 | Lawrence | Tennessee | 47099 | 765 | 9 |
494940 | 494940 | 2020-09-02 | Lawrence | Tennessee | 47099 | 776 | 9 |
491706 | 491706 | 2020-09-01 | Lawrence | Tennessee | 47099 | 768 | 9 |
488473 | 488473 | 2020-08-31 | Lawrence | Tennessee | 47099 | 762 | 9 |
485240 | 485240 | 2020-08-30 | Lawrence | Tennessee | 47099 | 759 | 9 |
482005 | 482005 | 2020-08-29 | Lawrence | Tennessee | 47099 | 751 | 9 |
478771 | 478771 | 2020-08-28 | Lawrence | Tennessee | 47099 | 740 | 9 |
475538 | 475538 | 2020-08-27 | Lawrence | Tennessee | 47099 | 725 | 9 |
472305 | 472305 | 2020-08-26 | Lawrence | Tennessee | 47099 | 721 | 9 |
469073 | 469073 | 2020-08-25 | Lawrence | Tennessee | 47099 | 717 | 9 |
464732 | 464732 | 2020-08-24 | Lawrence | Mississippi | 28077 | 377 | 9 |
461501 | 461501 | 2020-08-23 | Lawrence | Mississippi | 28077 | 377 | 9 |
458274 | 458274 | 2020-08-22 | Lawrence | Mississippi | 28077 | 373 | 9 |
453746 | 453746 | 2020-08-21 | Lawrence | Arkansas | 5075 | 239 | 9 |
455046 | 455046 | 2020-08-21 | Lawrence | Mississippi | 28077 | 372 | 9 |
450518 | 450518 | 2020-08-20 | Lawrence | Arkansas | 5075 | 238 | 9 |
451818 | 451818 | 2020-08-20 | Lawrence | Mississippi | 28077 | 369 | 9 |
447290 | 447290 | 2020-08-19 | Lawrence | Arkansas | 5075 | 234 | 9 |
444063 | 444063 | 2020-08-18 | Lawrence | Arkansas | 5075 | 232 | 9 |
440837 | 440837 | 2020-08-17 | Lawrence | Arkansas | 5075 | 231 | 9 |
437611 | 437611 | 2020-08-16 | Lawrence | Arkansas | 5075 | 230 | 9 |
434385 | 434385 | 2020-08-15 | Lawrence | Arkansas | 5075 | 229 | 9 |
431160 | 431160 | 2020-08-14 | Lawrence | Arkansas | 5075 | 226 | 9 |
427932 | 427932 | 2020-08-13 | Lawrence | Arkansas | 5075 | 223 | 9 |
424708 | 424708 | 2020-08-12 | Lawrence | Arkansas | 5075 | 221 | 9 |
421487 | 421487 | 2020-08-11 | Lawrence | Arkansas | 5075 | 217 | 9 |
418266 | 418266 | 2020-08-10 | Lawrence | Arkansas | 5075 | 214 | 9 |
415045 | 415045 | 2020-08-09 | Lawrence | Arkansas | 5075 | 212 | 9 |
411825 | 411825 | 2020-08-08 | Lawrence | Arkansas | 5075 | 209 | 9 |
408606 | 408606 | 2020-08-07 | Lawrence | Arkansas | 5075 | 206 | 9 |
405386 | 405386 | 2020-08-06 | Lawrence | Arkansas | 5075 | 205 | 9 |
402168 | 402168 | 2020-08-05 | Lawrence | Arkansas | 5075 | 191 | 9 |
389303 | 389303 | 2020-08-01 | Lawrence | Arkansas | 5075 | 182 | 9 |
386086 | 386086 | 2020-07-31 | Lawrence | Arkansas | 5075 | 179 | 9 |
382868 | 382868 | 2020-07-30 | Lawrence | Arkansas | 5075 | 173 | 9 |
379651 | 379651 | 2020-07-29 | Lawrence | Arkansas | 5075 | 169 | 9 |
376435 | 376435 | 2020-07-28 | Lawrence | Arkansas | 5075 | 162 | 9 |
373221 | 373221 | 2020-07-27 | Lawrence | Arkansas | 5075 | 158 | 9 |
370009 | 370009 | 2020-07-26 | Lawrence | Arkansas | 5075 | 157 | 9 |
366799 | 366799 | 2020-07-25 | Lawrence | Arkansas | 5075 | 155 | 9 |
363592 | 363592 | 2020-07-24 | Lawrence | Arkansas | 5075 | 152 | 9 |
360385 | 360385 | 2020-07-23 | Lawrence | Arkansas | 5075 | 150 | 9 |
362505 | 362505 | 2020-07-23 | Lawrence | Pennsylvania | 42073 | 261 | 9 |
357180 | 357180 | 2020-07-22 | Lawrence | Arkansas | 5075 | 148 | 9 |
359299 | 359299 | 2020-07-22 | Lawrence | Pennsylvania | 42073 | 257 | 9 |
353977 | 353977 | 2020-07-21 | Lawrence | Arkansas | 5075 | 144 | 9 |
356095 | 356095 | 2020-07-21 | Lawrence | Pennsylvania | 42073 | 243 | 9 |
350775 | 350775 | 2020-07-20 | Lawrence | Arkansas | 5075 | 142 | 9 |
352892 | 352892 | 2020-07-20 | Lawrence | Pennsylvania | 42073 | 235 | 9 |
347574 | 347574 | 2020-07-19 | Lawrence | Arkansas | 5075 | 135 | 9 |
349689 | 349689 | 2020-07-19 | Lawrence | Pennsylvania | 42073 | 226 | 9 |
344374 | 344374 | 2020-07-18 | Lawrence | Arkansas | 5075 | 133 | 9 |
346489 | 346489 | 2020-07-18 | Lawrence | Pennsylvania | 42073 | 225 | 9 |
341175 | 341175 | 2020-07-17 | Lawrence | Arkansas | 5075 | 129 | 9 |
343289 | 343289 | 2020-07-17 | Lawrence | Pennsylvania | 42073 | 221 | 9 |
337979 | 337979 | 2020-07-16 | Lawrence | Arkansas | 5075 | 123 | 9 |
340091 | 340091 | 2020-07-16 | Lawrence | Pennsylvania | 42073 | 209 | 9 |
334784 | 334784 | 2020-07-15 | Lawrence | Arkansas | 5075 | 121 | 9 |
336894 | 336894 | 2020-07-15 | Lawrence | Pennsylvania | 42073 | 207 | 9 |
331591 | 331591 | 2020-07-14 | Lawrence | Arkansas | 5075 | 123 | 9 |
333700 | 333700 | 2020-07-14 | Lawrence | Pennsylvania | 42073 | 200 | 9 |
328405 | 328405 | 2020-07-13 | Lawrence | Arkansas | 5075 | 115 | 9 |
330508 | 330508 | 2020-07-13 | Lawrence | Pennsylvania | 42073 | 197 | 9 |
325219 | 325219 | 2020-07-12 | Lawrence | Arkansas | 5075 | 115 | 9 |
327322 | 327322 | 2020-07-12 | Lawrence | Pennsylvania | 42073 | 174 | 9 |
322038 | 322038 | 2020-07-11 | Lawrence | Arkansas | 5075 | 115 | 9 |
324137 | 324137 | 2020-07-11 | Lawrence | Pennsylvania | 42073 | 171 | 9 |
318859 | 318859 | 2020-07-10 | Lawrence | Arkansas | 5075 | 112 | 9 |
320957 | 320957 | 2020-07-10 | Lawrence | Pennsylvania | 42073 | 159 | 9 |
315686 | 315686 | 2020-07-09 | Lawrence | Arkansas | 5075 | 111 | 9 |
317779 | 317779 | 2020-07-09 | Lawrence | Pennsylvania | 42073 | 146 | 9 |
312511 | 312511 | 2020-07-08 | Lawrence | Arkansas | 5075 | 107 | 9 |
314606 | 314606 | 2020-07-08 | Lawrence | Pennsylvania | 42073 | 141 | 9 |
309341 | 309341 | 2020-07-07 | Lawrence | Arkansas | 5075 | 103 | 9 |
311434 | 311434 | 2020-07-07 | Lawrence | Pennsylvania | 42073 | 129 | 9 |
306173 | 306173 | 2020-07-06 | Lawrence | Arkansas | 5075 | 103 | 9 |
308265 | 308265 | 2020-07-06 | Lawrence | Pennsylvania | 42073 | 124 | 9 |
303009 | 303009 | 2020-07-05 | Lawrence | Arkansas | 5075 | 103 | 9 |
305098 | 305098 | 2020-07-05 | Lawrence | Pennsylvania | 42073 | 119 | 9 |
299845 | 299845 | 2020-07-04 | Lawrence | Arkansas | 5075 | 102 | 9 |
301935 | 301935 | 2020-07-04 | Lawrence | Pennsylvania | 42073 | 114 | 9 |
296683 | 296683 | 2020-07-03 | Lawrence | Arkansas | 5075 | 102 | 9 |
298771 | 298771 | 2020-07-03 | Lawrence | Pennsylvania | 42073 | 110 | 9 |
293527 | 293527 | 2020-07-02 | Lawrence | Arkansas | 5075 | 102 | 9 |
295612 | 295612 | 2020-07-02 | Lawrence | Pennsylvania | 42073 | 107 | 9 |
290373 | 290373 | 2020-07-01 | Lawrence | Arkansas | 5075 | 100 | 9 |
292456 | 292456 | 2020-07-01 | Lawrence | Pennsylvania | 42073 | 103 | 9 |
287222 | 287222 | 2020-06-30 | Lawrence | Arkansas | 5075 | 99 | 9 |
289304 | 289304 | 2020-06-30 | Lawrence | Pennsylvania | 42073 | 102 | 9 |
284076 | 284076 | 2020-06-29 | Lawrence | Arkansas | 5075 | 99 | 9 |
286153 | 286153 | 2020-06-29 | Lawrence | Pennsylvania | 42073 | 101 | 9 |
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);