ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "St. Charles", fips = 22089 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535585 | 535585 | 2020-09-15 | St. Charles | Louisiana | 22089 | 1740 | 58 |
532350 | 532350 | 2020-09-14 | St. Charles | Louisiana | 22089 | 1735 | 58 |
529113 | 529113 | 2020-09-13 | St. Charles | Louisiana | 22089 | 1731 | 58 |
525877 | 525877 | 2020-09-12 | St. Charles | Louisiana | 22089 | 1720 | 58 |
522641 | 522641 | 2020-09-11 | St. Charles | Louisiana | 22089 | 1720 | 58 |
519404 | 519404 | 2020-09-10 | St. Charles | Louisiana | 22089 | 1721 | 58 |
516169 | 516169 | 2020-09-09 | St. Charles | Louisiana | 22089 | 1709 | 57 |
512936 | 512936 | 2020-09-08 | St. Charles | Louisiana | 22089 | 1702 | 57 |
509704 | 509704 | 2020-09-07 | St. Charles | Louisiana | 22089 | 1695 | 57 |
506471 | 506471 | 2020-09-06 | St. Charles | Louisiana | 22089 | 1691 | 57 |
503237 | 503237 | 2020-09-05 | St. Charles | Louisiana | 22089 | 1669 | 57 |
500004 | 500004 | 2020-09-04 | St. Charles | Louisiana | 22089 | 1669 | 57 |
496770 | 496770 | 2020-09-03 | St. Charles | Louisiana | 22089 | 1662 | 56 |
493537 | 493537 | 2020-09-02 | St. Charles | Louisiana | 22089 | 1660 | 56 |
490303 | 490303 | 2020-09-01 | St. Charles | Louisiana | 22089 | 1660 | 56 |
487070 | 487070 | 2020-08-31 | St. Charles | Louisiana | 22089 | 1648 | 55 |
483835 | 483835 | 2020-08-30 | St. Charles | Louisiana | 22089 | 1643 | 55 |
480601 | 480601 | 2020-08-29 | St. Charles | Louisiana | 22089 | 1628 | 55 |
477368 | 477368 | 2020-08-28 | St. Charles | Louisiana | 22089 | 1628 | 55 |
474135 | 474135 | 2020-08-27 | St. Charles | Louisiana | 22089 | 1621 | 55 |
470903 | 470903 | 2020-08-26 | St. Charles | Louisiana | 22089 | 1614 | 54 |
467674 | 467674 | 2020-08-25 | St. Charles | Louisiana | 22089 | 1611 | 54 |
464445 | 464445 | 2020-08-24 | St. Charles | Louisiana | 22089 | 1587 | 54 |
461214 | 461214 | 2020-08-23 | St. Charles | Louisiana | 22089 | 1580 | 54 |
457987 | 457987 | 2020-08-22 | St. Charles | Louisiana | 22089 | 1568 | 54 |
454759 | 454759 | 2020-08-21 | St. Charles | Louisiana | 22089 | 1568 | 54 |
451531 | 451531 | 2020-08-20 | St. Charles | Louisiana | 22089 | 1559 | 54 |
448303 | 448303 | 2020-08-19 | St. Charles | Louisiana | 22089 | 1559 | 54 |
445076 | 445076 | 2020-08-18 | St. Charles | Louisiana | 22089 | 1549 | 54 |
441850 | 441850 | 2020-08-17 | St. Charles | Louisiana | 22089 | 1545 | 54 |
438623 | 438623 | 2020-08-16 | St. Charles | Louisiana | 22089 | 1542 | 54 |
435398 | 435398 | 2020-08-15 | St. Charles | Louisiana | 22089 | 1526 | 54 |
432173 | 432173 | 2020-08-14 | St. Charles | Louisiana | 22089 | 1526 | 54 |
428945 | 428945 | 2020-08-13 | St. Charles | Louisiana | 22089 | 1515 | 55 |
425721 | 425721 | 2020-08-12 | St. Charles | Louisiana | 22089 | 1500 | 55 |
422500 | 422500 | 2020-08-11 | St. Charles | Louisiana | 22089 | 1492 | 52 |
419278 | 419278 | 2020-08-10 | St. Charles | Louisiana | 22089 | 1484 | 52 |
416057 | 416057 | 2020-08-09 | St. Charles | Louisiana | 22089 | 1474 | 52 |
412837 | 412837 | 2020-08-08 | St. Charles | Louisiana | 22089 | 1442 | 51 |
409617 | 409617 | 2020-08-07 | St. Charles | Louisiana | 22089 | 1442 | 51 |
406397 | 406397 | 2020-08-06 | St. Charles | Louisiana | 22089 | 1424 | 51 |
403179 | 403179 | 2020-08-05 | St. Charles | Louisiana | 22089 | 1419 | 50 |
399962 | 399962 | 2020-08-04 | St. Charles | Louisiana | 22089 | 1397 | 50 |
396747 | 396747 | 2020-08-03 | St. Charles | Louisiana | 22089 | 1375 | 50 |
393531 | 393531 | 2020-08-02 | St. Charles | Louisiana | 22089 | 1367 | 50 |
390314 | 390314 | 2020-08-01 | St. Charles | Louisiana | 22089 | 1340 | 50 |
387097 | 387097 | 2020-07-31 | St. Charles | Louisiana | 22089 | 1340 | 50 |
383879 | 383879 | 2020-07-30 | St. Charles | Louisiana | 22089 | 1320 | 50 |
380662 | 380662 | 2020-07-29 | St. Charles | Louisiana | 22089 | 1298 | 50 |
377445 | 377445 | 2020-07-28 | St. Charles | Louisiana | 22089 | 1276 | 50 |
374230 | 374230 | 2020-07-27 | St. Charles | Louisiana | 22089 | 1261 | 50 |
371018 | 371018 | 2020-07-26 | St. Charles | Louisiana | 22089 | 1229 | 50 |
367808 | 367808 | 2020-07-25 | St. Charles | Louisiana | 22089 | 1174 | 50 |
364601 | 364601 | 2020-07-24 | St. Charles | Louisiana | 22089 | 1174 | 50 |
361394 | 361394 | 2020-07-23 | St. Charles | Louisiana | 22089 | 1139 | 50 |
358189 | 358189 | 2020-07-22 | St. Charles | Louisiana | 22089 | 1088 | 50 |
354986 | 354986 | 2020-07-21 | St. Charles | Louisiana | 22089 | 1068 | 50 |
351784 | 351784 | 2020-07-20 | St. Charles | Louisiana | 22089 | 1032 | 50 |
348584 | 348584 | 2020-07-19 | St. Charles | Louisiana | 22089 | 1012 | 50 |
345383 | 345383 | 2020-07-18 | St. Charles | Louisiana | 22089 | 969 | 50 |
342183 | 342183 | 2020-07-17 | St. Charles | Louisiana | 22089 | 969 | 50 |
338987 | 338987 | 2020-07-16 | St. Charles | Louisiana | 22089 | 929 | 50 |
335791 | 335791 | 2020-07-15 | St. Charles | Louisiana | 22089 | 913 | 49 |
332598 | 332598 | 2020-07-14 | St. Charles | Louisiana | 22089 | 903 | 49 |
329411 | 329411 | 2020-07-13 | St. Charles | Louisiana | 22089 | 882 | 49 |
326225 | 326225 | 2020-07-12 | St. Charles | Louisiana | 22089 | 871 | 49 |
323042 | 323042 | 2020-07-11 | St. Charles | Louisiana | 22089 | 866 | 49 |
319863 | 319863 | 2020-07-10 | St. Charles | Louisiana | 22089 | 854 | 49 |
316688 | 316688 | 2020-07-09 | St. Charles | Louisiana | 22089 | 834 | 49 |
313514 | 313514 | 2020-07-08 | St. Charles | Louisiana | 22089 | 828 | 49 |
310344 | 310344 | 2020-07-07 | St. Charles | Louisiana | 22089 | 816 | 49 |
307176 | 307176 | 2020-07-06 | St. Charles | Louisiana | 22089 | 802 | 49 |
304009 | 304009 | 2020-07-05 | St. Charles | Louisiana | 22089 | 796 | 49 |
300845 | 300845 | 2020-07-04 | St. Charles | Louisiana | 22089 | 789 | 49 |
297683 | 297683 | 2020-07-03 | St. Charles | Louisiana | 22089 | 789 | 49 |
294525 | 294525 | 2020-07-02 | St. Charles | Louisiana | 22089 | 780 | 49 |
291371 | 291371 | 2020-07-01 | St. Charles | Louisiana | 22089 | 778 | 49 |
288220 | 288220 | 2020-06-30 | St. Charles | Louisiana | 22089 | 759 | 49 |
285071 | 285071 | 2020-06-29 | St. Charles | Louisiana | 22089 | 741 | 49 |
281925 | 281925 | 2020-06-28 | St. Charles | Louisiana | 22089 | 736 | 49 |
278777 | 278777 | 2020-06-27 | St. Charles | Louisiana | 22089 | 726 | 49 |
275629 | 275629 | 2020-06-26 | St. Charles | Louisiana | 22089 | 726 | 49 |
272486 | 272486 | 2020-06-25 | St. Charles | Louisiana | 22089 | 713 | 48 |
269350 | 269350 | 2020-06-24 | St. Charles | Louisiana | 22089 | 699 | 46 |
266217 | 266217 | 2020-06-23 | St. Charles | Louisiana | 22089 | 697 | 46 |
263090 | 263090 | 2020-06-22 | St. Charles | Louisiana | 22089 | 691 | 46 |
259961 | 259961 | 2020-06-21 | St. Charles | Louisiana | 22089 | 689 | 46 |
256835 | 256835 | 2020-06-20 | St. Charles | Louisiana | 22089 | 688 | 46 |
253715 | 253715 | 2020-06-19 | St. Charles | Louisiana | 22089 | 685 | 46 |
250600 | 250600 | 2020-06-18 | St. Charles | Louisiana | 22089 | 667 | 46 |
247488 | 247488 | 2020-06-17 | St. Charles | Louisiana | 22089 | 667 | 46 |
244375 | 244375 | 2020-06-16 | St. Charles | Louisiana | 22089 | 665 | 46 |
241264 | 241264 | 2020-06-15 | St. Charles | Louisiana | 22089 | 661 | 46 |
238155 | 238155 | 2020-06-14 | St. Charles | Louisiana | 22089 | 660 | 46 |
235048 | 235048 | 2020-06-13 | St. Charles | Louisiana | 22089 | 656 | 46 |
231943 | 231943 | 2020-06-12 | St. Charles | Louisiana | 22089 | 655 | 46 |
228839 | 228839 | 2020-06-11 | St. Charles | Louisiana | 22089 | 654 | 46 |
225737 | 225737 | 2020-06-10 | St. Charles | Louisiana | 22089 | 653 | 45 |
222641 | 222641 | 2020-06-09 | St. Charles | Louisiana | 22089 | 652 | 45 |
219546 | 219546 | 2020-06-08 | St. Charles | Louisiana | 22089 | 649 | 45 |
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);