ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "St. Charles" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
216454 | 216454 | 2020-06-07 | St. Charles | Louisiana | 22089 | 649 | 45 |
213367 | 213367 | 2020-06-06 | St. Charles | Louisiana | 22089 | 649 | 45 |
210282 | 210282 | 2020-06-05 | St. Charles | Louisiana | 22089 | 647 | 45 |
207201 | 207201 | 2020-06-04 | St. Charles | Louisiana | 22089 | 647 | 45 |
204120 | 204120 | 2020-06-03 | St. Charles | Louisiana | 22089 | 647 | 45 |
201043 | 201043 | 2020-06-02 | St. Charles | Louisiana | 22089 | 645 | 45 |
197971 | 197971 | 2020-06-01 | St. Charles | Louisiana | 22089 | 642 | 44 |
194900 | 194900 | 2020-05-31 | St. Charles | Louisiana | 22089 | 638 | 44 |
191832 | 191832 | 2020-05-30 | St. Charles | Louisiana | 22089 | 637 | 44 |
188768 | 188768 | 2020-05-29 | St. Charles | Louisiana | 22089 | 633 | 44 |
185710 | 185710 | 2020-05-28 | St. Charles | Louisiana | 22089 | 633 | 44 |
182655 | 182655 | 2020-05-27 | St. Charles | Louisiana | 22089 | 631 | 44 |
179610 | 179610 | 2020-05-26 | St. Charles | Louisiana | 22089 | 625 | 44 |
176566 | 176566 | 2020-05-25 | St. Charles | Louisiana | 22089 | 625 | 43 |
173522 | 173522 | 2020-05-24 | St. Charles | Louisiana | 22089 | 623 | 43 |
170481 | 170481 | 2020-05-23 | St. Charles | Louisiana | 22089 | 622 | 43 |
167443 | 167443 | 2020-05-22 | St. Charles | Louisiana | 22089 | 622 | 43 |
164407 | 164407 | 2020-05-21 | St. Charles | Louisiana | 22089 | 618 | 43 |
161378 | 161378 | 2020-05-20 | St. Charles | Louisiana | 22089 | 615 | 42 |
158352 | 158352 | 2020-05-19 | St. Charles | Louisiana | 22089 | 615 | 42 |
155334 | 155334 | 2020-05-18 | St. Charles | Louisiana | 22089 | 615 | 42 |
152320 | 152320 | 2020-05-17 | St. Charles | Louisiana | 22089 | 613 | 42 |
149309 | 149309 | 2020-05-16 | St. Charles | Louisiana | 22089 | 613 | 41 |
146304 | 146304 | 2020-05-15 | St. Charles | Louisiana | 22089 | 606 | 41 |
143304 | 143304 | 2020-05-14 | St. Charles | Louisiana | 22089 | 602 | 42 |
140309 | 140309 | 2020-05-13 | St. Charles | Louisiana | 22089 | 600 | 43 |
137315 | 137315 | 2020-05-12 | St. Charles | Louisiana | 22089 | 596 | 43 |
134325 | 134325 | 2020-05-11 | St. Charles | Louisiana | 22089 | 595 | 43 |
131334 | 131334 | 2020-05-10 | St. Charles | Louisiana | 22089 | 594 | 43 |
128344 | 128344 | 2020-05-09 | St. Charles | Louisiana | 22089 | 593 | 43 |
125357 | 125357 | 2020-05-08 | St. Charles | Louisiana | 22089 | 593 | 43 |
122375 | 122375 | 2020-05-07 | St. Charles | Louisiana | 22089 | 594 | 43 |
119404 | 119404 | 2020-05-06 | St. Charles | Louisiana | 22089 | 590 | 43 |
116443 | 116443 | 2020-05-05 | St. Charles | Louisiana | 22089 | 589 | 41 |
113561 | 113561 | 2020-05-04 | St. Charles | Louisiana | 22089 | 584 | 41 |
110684 | 110684 | 2020-05-03 | St. Charles | Louisiana | 22089 | 582 | 40 |
107812 | 107812 | 2020-05-02 | St. Charles | Louisiana | 22089 | 577 | 39 |
104948 | 104948 | 2020-05-01 | St. Charles | Louisiana | 22089 | 573 | 38 |
102087 | 102087 | 2020-04-30 | St. Charles | Louisiana | 22089 | 570 | 38 |
99235 | 99235 | 2020-04-29 | St. Charles | Louisiana | 22089 | 563 | 37 |
96389 | 96389 | 2020-04-28 | St. Charles | Louisiana | 22089 | 554 | 37 |
93554 | 93554 | 2020-04-27 | St. Charles | Louisiana | 22089 | 549 | 36 |
90733 | 90733 | 2020-04-26 | St. Charles | Louisiana | 22089 | 542 | 36 |
87917 | 87917 | 2020-04-25 | St. Charles | Louisiana | 22089 | 540 | 35 |
85108 | 85108 | 2020-04-24 | St. Charles | Louisiana | 22089 | 536 | 34 |
82304 | 82304 | 2020-04-23 | St. Charles | Louisiana | 22089 | 529 | 33 |
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);