ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Assumption" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535544 | 535544 | 2020-09-15 | Assumption | Louisiana | 22007 | 734 | 24 |
532309 | 532309 | 2020-09-14 | Assumption | Louisiana | 22007 | 729 | 23 |
529072 | 529072 | 2020-09-13 | Assumption | Louisiana | 22007 | 721 | 23 |
525836 | 525836 | 2020-09-12 | Assumption | Louisiana | 22007 | 710 | 23 |
522600 | 522600 | 2020-09-11 | Assumption | Louisiana | 22007 | 710 | 23 |
519363 | 519363 | 2020-09-10 | Assumption | Louisiana | 22007 | 699 | 23 |
516128 | 516128 | 2020-09-09 | Assumption | Louisiana | 22007 | 699 | 23 |
512895 | 512895 | 2020-09-08 | Assumption | Louisiana | 22007 | 692 | 22 |
509663 | 509663 | 2020-09-07 | Assumption | Louisiana | 22007 | 683 | 22 |
506430 | 506430 | 2020-09-06 | Assumption | Louisiana | 22007 | 680 | 22 |
503196 | 503196 | 2020-09-05 | Assumption | Louisiana | 22007 | 675 | 22 |
499963 | 499963 | 2020-09-04 | Assumption | Louisiana | 22007 | 675 | 22 |
496729 | 496729 | 2020-09-03 | Assumption | Louisiana | 22007 | 669 | 22 |
493496 | 493496 | 2020-09-02 | Assumption | Louisiana | 22007 | 670 | 22 |
490262 | 490262 | 2020-09-01 | Assumption | Louisiana | 22007 | 669 | 22 |
487029 | 487029 | 2020-08-31 | Assumption | Louisiana | 22007 | 667 | 22 |
483794 | 483794 | 2020-08-30 | Assumption | Louisiana | 22007 | 664 | 22 |
480560 | 480560 | 2020-08-29 | Assumption | Louisiana | 22007 | 653 | 22 |
477327 | 477327 | 2020-08-28 | Assumption | Louisiana | 22007 | 653 | 22 |
474094 | 474094 | 2020-08-27 | Assumption | Louisiana | 22007 | 654 | 22 |
470862 | 470862 | 2020-08-26 | Assumption | Louisiana | 22007 | 649 | 22 |
467633 | 467633 | 2020-08-25 | Assumption | Louisiana | 22007 | 651 | 21 |
464404 | 464404 | 2020-08-24 | Assumption | Louisiana | 22007 | 631 | 21 |
461173 | 461173 | 2020-08-23 | Assumption | Louisiana | 22007 | 631 | 21 |
457946 | 457946 | 2020-08-22 | Assumption | Louisiana | 22007 | 628 | 20 |
454718 | 454718 | 2020-08-21 | Assumption | Louisiana | 22007 | 628 | 20 |
451490 | 451490 | 2020-08-20 | Assumption | Louisiana | 22007 | 626 | 20 |
448262 | 448262 | 2020-08-19 | Assumption | Louisiana | 22007 | 623 | 20 |
445035 | 445035 | 2020-08-18 | Assumption | Louisiana | 22007 | 617 | 20 |
441809 | 441809 | 2020-08-17 | Assumption | Louisiana | 22007 | 616 | 20 |
438582 | 438582 | 2020-08-16 | Assumption | Louisiana | 22007 | 613 | 20 |
435357 | 435357 | 2020-08-15 | Assumption | Louisiana | 22007 | 606 | 20 |
432132 | 432132 | 2020-08-14 | Assumption | Louisiana | 22007 | 606 | 20 |
428904 | 428904 | 2020-08-13 | Assumption | Louisiana | 22007 | 600 | 20 |
425680 | 425680 | 2020-08-12 | Assumption | Louisiana | 22007 | 598 | 20 |
422459 | 422459 | 2020-08-11 | Assumption | Louisiana | 22007 | 591 | 20 |
419237 | 419237 | 2020-08-10 | Assumption | Louisiana | 22007 | 588 | 20 |
416016 | 416016 | 2020-08-09 | Assumption | Louisiana | 22007 | 584 | 20 |
412796 | 412796 | 2020-08-08 | Assumption | Louisiana | 22007 | 577 | 20 |
409576 | 409576 | 2020-08-07 | Assumption | Louisiana | 22007 | 577 | 20 |
406356 | 406356 | 2020-08-06 | Assumption | Louisiana | 22007 | 569 | 20 |
403138 | 403138 | 2020-08-05 | Assumption | Louisiana | 22007 | 561 | 20 |
399921 | 399921 | 2020-08-04 | Assumption | Louisiana | 22007 | 557 | 20 |
396706 | 396706 | 2020-08-03 | Assumption | Louisiana | 22007 | 555 | 20 |
393490 | 393490 | 2020-08-02 | Assumption | Louisiana | 22007 | 552 | 19 |
390273 | 390273 | 2020-08-01 | Assumption | Louisiana | 22007 | 537 | 19 |
387056 | 387056 | 2020-07-31 | Assumption | Louisiana | 22007 | 537 | 19 |
383838 | 383838 | 2020-07-30 | Assumption | Louisiana | 22007 | 531 | 19 |
380621 | 380621 | 2020-07-29 | Assumption | Louisiana | 22007 | 521 | 19 |
377404 | 377404 | 2020-07-28 | Assumption | Louisiana | 22007 | 515 | 18 |
374189 | 374189 | 2020-07-27 | Assumption | Louisiana | 22007 | 509 | 18 |
370977 | 370977 | 2020-07-26 | Assumption | Louisiana | 22007 | 493 | 18 |
367767 | 367767 | 2020-07-25 | Assumption | Louisiana | 22007 | 484 | 18 |
364560 | 364560 | 2020-07-24 | Assumption | Louisiana | 22007 | 484 | 18 |
361353 | 361353 | 2020-07-23 | Assumption | Louisiana | 22007 | 477 | 18 |
358148 | 358148 | 2020-07-22 | Assumption | Louisiana | 22007 | 463 | 18 |
354945 | 354945 | 2020-07-21 | Assumption | Louisiana | 22007 | 462 | 17 |
351743 | 351743 | 2020-07-20 | Assumption | Louisiana | 22007 | 452 | 17 |
348543 | 348543 | 2020-07-19 | Assumption | Louisiana | 22007 | 449 | 17 |
345342 | 345342 | 2020-07-18 | Assumption | Louisiana | 22007 | 445 | 17 |
342142 | 342142 | 2020-07-17 | Assumption | Louisiana | 22007 | 445 | 17 |
338946 | 338946 | 2020-07-16 | Assumption | Louisiana | 22007 | 439 | 17 |
335750 | 335750 | 2020-07-15 | Assumption | Louisiana | 22007 | 435 | 17 |
332557 | 332557 | 2020-07-14 | Assumption | Louisiana | 22007 | 432 | 17 |
329370 | 329370 | 2020-07-13 | Assumption | Louisiana | 22007 | 430 | 16 |
326184 | 326184 | 2020-07-12 | Assumption | Louisiana | 22007 | 424 | 16 |
323001 | 323001 | 2020-07-11 | Assumption | Louisiana | 22007 | 415 | 16 |
319822 | 319822 | 2020-07-10 | Assumption | Louisiana | 22007 | 410 | 16 |
316647 | 316647 | 2020-07-09 | Assumption | Louisiana | 22007 | 404 | 16 |
313473 | 313473 | 2020-07-08 | Assumption | Louisiana | 22007 | 399 | 15 |
310303 | 310303 | 2020-07-07 | Assumption | Louisiana | 22007 | 390 | 15 |
307135 | 307135 | 2020-07-06 | Assumption | Louisiana | 22007 | 383 | 15 |
303968 | 303968 | 2020-07-05 | Assumption | Louisiana | 22007 | 381 | 15 |
300804 | 300804 | 2020-07-04 | Assumption | Louisiana | 22007 | 373 | 15 |
297642 | 297642 | 2020-07-03 | Assumption | Louisiana | 22007 | 373 | 15 |
294484 | 294484 | 2020-07-02 | Assumption | Louisiana | 22007 | 364 | 15 |
291330 | 291330 | 2020-07-01 | Assumption | Louisiana | 22007 | 357 | 15 |
288179 | 288179 | 2020-06-30 | Assumption | Louisiana | 22007 | 352 | 14 |
285030 | 285030 | 2020-06-29 | Assumption | Louisiana | 22007 | 351 | 14 |
281884 | 281884 | 2020-06-28 | Assumption | Louisiana | 22007 | 343 | 14 |
278736 | 278736 | 2020-06-27 | Assumption | Louisiana | 22007 | 338 | 14 |
275588 | 275588 | 2020-06-26 | Assumption | Louisiana | 22007 | 338 | 14 |
272445 | 272445 | 2020-06-25 | Assumption | Louisiana | 22007 | 334 | 14 |
269309 | 269309 | 2020-06-24 | Assumption | Louisiana | 22007 | 334 | 14 |
266176 | 266176 | 2020-06-23 | Assumption | Louisiana | 22007 | 334 | 14 |
263049 | 263049 | 2020-06-22 | Assumption | Louisiana | 22007 | 330 | 14 |
259920 | 259920 | 2020-06-21 | Assumption | Louisiana | 22007 | 327 | 14 |
256794 | 256794 | 2020-06-20 | Assumption | Louisiana | 22007 | 327 | 14 |
253674 | 253674 | 2020-06-19 | Assumption | Louisiana | 22007 | 324 | 14 |
250559 | 250559 | 2020-06-18 | Assumption | Louisiana | 22007 | 282 | 14 |
247447 | 247447 | 2020-06-17 | Assumption | Louisiana | 22007 | 282 | 14 |
244334 | 244334 | 2020-06-16 | Assumption | Louisiana | 22007 | 276 | 14 |
241223 | 241223 | 2020-06-15 | Assumption | Louisiana | 22007 | 274 | 14 |
238114 | 238114 | 2020-06-14 | Assumption | Louisiana | 22007 | 269 | 14 |
235007 | 235007 | 2020-06-13 | Assumption | Louisiana | 22007 | 263 | 14 |
231902 | 231902 | 2020-06-12 | Assumption | Louisiana | 22007 | 258 | 14 |
228798 | 228798 | 2020-06-11 | Assumption | Louisiana | 22007 | 258 | 14 |
225696 | 225696 | 2020-06-10 | Assumption | Louisiana | 22007 | 259 | 13 |
222600 | 222600 | 2020-06-09 | Assumption | Louisiana | 22007 | 258 | 13 |
219505 | 219505 | 2020-06-08 | Assumption | Louisiana | 22007 | 257 | 13 |
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);