ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Lawrence" and fips = 29109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535972 | 535972 | 2020-09-15 | Lawrence | Missouri | 29109 | 454 | 2 |
532737 | 532737 | 2020-09-14 | Lawrence | Missouri | 29109 | 448 | 2 |
529501 | 529501 | 2020-09-13 | Lawrence | Missouri | 29109 | 441 | 2 |
526265 | 526265 | 2020-09-12 | Lawrence | Missouri | 29109 | 434 | 2 |
523029 | 523029 | 2020-09-11 | Lawrence | Missouri | 29109 | 422 | 2 |
519792 | 519792 | 2020-09-10 | Lawrence | Missouri | 29109 | 419 | 2 |
516557 | 516557 | 2020-09-09 | Lawrence | Missouri | 29109 | 408 | 2 |
513323 | 513323 | 2020-09-08 | Lawrence | Missouri | 29109 | 399 | 2 |
510091 | 510091 | 2020-09-07 | Lawrence | Missouri | 29109 | 393 | 2 |
506858 | 506858 | 2020-09-06 | Lawrence | Missouri | 29109 | 393 | 2 |
503625 | 503625 | 2020-09-05 | Lawrence | Missouri | 29109 | 389 | 2 |
500391 | 500391 | 2020-09-04 | Lawrence | Missouri | 29109 | 378 | 2 |
497157 | 497157 | 2020-09-03 | Lawrence | Missouri | 29109 | 370 | 2 |
493924 | 493924 | 2020-09-02 | Lawrence | Missouri | 29109 | 363 | 2 |
490690 | 490690 | 2020-09-01 | Lawrence | Missouri | 29109 | 356 | 2 |
487457 | 487457 | 2020-08-31 | Lawrence | Missouri | 29109 | 354 | 2 |
484223 | 484223 | 2020-08-30 | Lawrence | Missouri | 29109 | 352 | 2 |
480988 | 480988 | 2020-08-29 | Lawrence | Missouri | 29109 | 351 | 2 |
477756 | 477756 | 2020-08-28 | Lawrence | Missouri | 29109 | 342 | 2 |
474523 | 474523 | 2020-08-27 | Lawrence | Missouri | 29109 | 335 | 2 |
471291 | 471291 | 2020-08-26 | Lawrence | Missouri | 29109 | 323 | 2 |
468061 | 468061 | 2020-08-25 | Lawrence | Missouri | 29109 | 319 | 2 |
464832 | 464832 | 2020-08-24 | Lawrence | Missouri | 29109 | 317 | 2 |
461601 | 461601 | 2020-08-23 | Lawrence | Missouri | 29109 | 310 | 2 |
458374 | 458374 | 2020-08-22 | Lawrence | Missouri | 29109 | 301 | 2 |
455146 | 455146 | 2020-08-21 | Lawrence | Missouri | 29109 | 296 | 2 |
451918 | 451918 | 2020-08-20 | Lawrence | Missouri | 29109 | 293 | 2 |
448690 | 448690 | 2020-08-19 | Lawrence | Missouri | 29109 | 288 | 2 |
445464 | 445464 | 2020-08-18 | Lawrence | Missouri | 29109 | 275 | 2 |
442238 | 442238 | 2020-08-17 | Lawrence | Missouri | 29109 | 271 | 2 |
439011 | 439011 | 2020-08-16 | Lawrence | Missouri | 29109 | 264 | 2 |
435786 | 435786 | 2020-08-15 | Lawrence | Missouri | 29109 | 252 | 2 |
432560 | 432560 | 2020-08-14 | Lawrence | Missouri | 29109 | 247 | 2 |
429333 | 429333 | 2020-08-13 | Lawrence | Missouri | 29109 | 246 | 2 |
426109 | 426109 | 2020-08-12 | Lawrence | Missouri | 29109 | 240 | 2 |
422887 | 422887 | 2020-08-11 | Lawrence | Missouri | 29109 | 233 | 2 |
419665 | 419665 | 2020-08-10 | Lawrence | Missouri | 29109 | 230 | 2 |
416444 | 416444 | 2020-08-09 | Lawrence | Missouri | 29109 | 228 | 2 |
413224 | 413224 | 2020-08-08 | Lawrence | Missouri | 29109 | 211 | 2 |
410004 | 410004 | 2020-08-07 | Lawrence | Missouri | 29109 | 211 | 2 |
406784 | 406784 | 2020-08-06 | Lawrence | Missouri | 29109 | 205 | 2 |
403566 | 403566 | 2020-08-05 | Lawrence | Missouri | 29109 | 202 | 2 |
400349 | 400349 | 2020-08-04 | Lawrence | Missouri | 29109 | 195 | 2 |
397135 | 397135 | 2020-08-03 | Lawrence | Missouri | 29109 | 192 | 2 |
393919 | 393919 | 2020-08-02 | Lawrence | Missouri | 29109 | 186 | 2 |
390702 | 390702 | 2020-08-01 | Lawrence | Missouri | 29109 | 184 | 2 |
387485 | 387485 | 2020-07-31 | Lawrence | Missouri | 29109 | 182 | 2 |
384267 | 384267 | 2020-07-30 | Lawrence | Missouri | 29109 | 172 | 2 |
381051 | 381051 | 2020-07-29 | Lawrence | Missouri | 29109 | 159 | 2 |
377834 | 377834 | 2020-07-28 | Lawrence | Missouri | 29109 | 152 | 2 |
374619 | 374619 | 2020-07-27 | Lawrence | Missouri | 29109 | 142 | 2 |
371407 | 371407 | 2020-07-26 | Lawrence | Missouri | 29109 | 136 | 2 |
368196 | 368196 | 2020-07-25 | Lawrence | Missouri | 29109 | 134 | 2 |
364988 | 364988 | 2020-07-24 | Lawrence | Missouri | 29109 | 125 | 2 |
361781 | 361781 | 2020-07-23 | Lawrence | Missouri | 29109 | 122 | 2 |
358576 | 358576 | 2020-07-22 | Lawrence | Missouri | 29109 | 110 | 2 |
355373 | 355373 | 2020-07-21 | Lawrence | Missouri | 29109 | 106 | 2 |
352171 | 352171 | 2020-07-20 | Lawrence | Missouri | 29109 | 104 | 2 |
348971 | 348971 | 2020-07-19 | Lawrence | Missouri | 29109 | 94 | 2 |
345770 | 345770 | 2020-07-18 | Lawrence | Missouri | 29109 | 87 | 2 |
342570 | 342570 | 2020-07-17 | Lawrence | Missouri | 29109 | 86 | 2 |
339374 | 339374 | 2020-07-16 | Lawrence | Missouri | 29109 | 81 | 2 |
336178 | 336178 | 2020-07-15 | Lawrence | Missouri | 29109 | 65 | 2 |
332985 | 332985 | 2020-07-14 | Lawrence | Missouri | 29109 | 60 | 2 |
329798 | 329798 | 2020-07-13 | Lawrence | Missouri | 29109 | 60 | 2 |
326612 | 326612 | 2020-07-12 | Lawrence | Missouri | 29109 | 59 | 1 |
323429 | 323429 | 2020-07-11 | Lawrence | Missouri | 29109 | 58 | 1 |
320250 | 320250 | 2020-07-10 | Lawrence | Missouri | 29109 | 54 | 1 |
317075 | 317075 | 2020-07-09 | Lawrence | Missouri | 29109 | 53 | 1 |
313901 | 313901 | 2020-07-08 | Lawrence | Missouri | 29109 | 52 | 1 |
310730 | 310730 | 2020-07-07 | Lawrence | Missouri | 29109 | 48 | 1 |
307562 | 307562 | 2020-07-06 | Lawrence | Missouri | 29109 | 46 | 1 |
304395 | 304395 | 2020-07-05 | Lawrence | Missouri | 29109 | 45 | 1 |
301231 | 301231 | 2020-07-04 | Lawrence | Missouri | 29109 | 41 | 1 |
298068 | 298068 | 2020-07-03 | Lawrence | Missouri | 29109 | 41 | 1 |
294910 | 294910 | 2020-07-02 | Lawrence | Missouri | 29109 | 37 | 1 |
291756 | 291756 | 2020-07-01 | Lawrence | Missouri | 29109 | 37 | 1 |
288605 | 288605 | 2020-06-30 | Lawrence | Missouri | 29109 | 34 | 1 |
285455 | 285455 | 2020-06-29 | Lawrence | Missouri | 29109 | 32 | 1 |
282310 | 282310 | 2020-06-28 | Lawrence | Missouri | 29109 | 31 | 1 |
279162 | 279162 | 2020-06-27 | Lawrence | Missouri | 29109 | 30 | 0 |
276014 | 276014 | 2020-06-26 | Lawrence | Missouri | 29109 | 28 | 0 |
272871 | 272871 | 2020-06-25 | Lawrence | Missouri | 29109 | 20 | 0 |
269732 | 269732 | 2020-06-24 | Lawrence | Missouri | 29109 | 20 | 0 |
266599 | 266599 | 2020-06-23 | Lawrence | Missouri | 29109 | 19 | 0 |
263473 | 263473 | 2020-06-22 | Lawrence | Missouri | 29109 | 13 | 0 |
260345 | 260345 | 2020-06-21 | Lawrence | Missouri | 29109 | 13 | 0 |
257219 | 257219 | 2020-06-20 | Lawrence | Missouri | 29109 | 11 | 0 |
254099 | 254099 | 2020-06-19 | Lawrence | Missouri | 29109 | 11 | 0 |
250984 | 250984 | 2020-06-18 | Lawrence | Missouri | 29109 | 10 | 0 |
247871 | 247871 | 2020-06-17 | Lawrence | Missouri | 29109 | 8 | 0 |
244758 | 244758 | 2020-06-16 | Lawrence | Missouri | 29109 | 8 | 0 |
241647 | 241647 | 2020-06-15 | Lawrence | Missouri | 29109 | 7 | 0 |
238537 | 238537 | 2020-06-14 | Lawrence | Missouri | 29109 | 7 | 0 |
235430 | 235430 | 2020-06-13 | Lawrence | Missouri | 29109 | 7 | 0 |
232324 | 232324 | 2020-06-12 | Lawrence | Missouri | 29109 | 7 | 0 |
229220 | 229220 | 2020-06-11 | Lawrence | Missouri | 29109 | 7 | 0 |
226117 | 226117 | 2020-06-10 | Lawrence | Missouri | 29109 | 7 | 0 |
223018 | 223018 | 2020-06-09 | Lawrence | Missouri | 29109 | 7 | 0 |
219923 | 219923 | 2020-06-08 | Lawrence | Missouri | 29109 | 7 | 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);