ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "St. Bernard" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387096 | 387096 | 2020-07-31 | St. Bernard | Louisiana | 22087 | 1001 | 23 |
383878 | 383878 | 2020-07-30 | St. Bernard | Louisiana | 22087 | 998 | 23 |
380661 | 380661 | 2020-07-29 | St. Bernard | Louisiana | 22087 | 990 | 23 |
377444 | 377444 | 2020-07-28 | St. Bernard | Louisiana | 22087 | 981 | 23 |
374229 | 374229 | 2020-07-27 | St. Bernard | Louisiana | 22087 | 976 | 23 |
371017 | 371017 | 2020-07-26 | St. Bernard | Louisiana | 22087 | 957 | 23 |
367807 | 367807 | 2020-07-25 | St. Bernard | Louisiana | 22087 | 909 | 23 |
364600 | 364600 | 2020-07-24 | St. Bernard | Louisiana | 22087 | 909 | 23 |
361393 | 361393 | 2020-07-23 | St. Bernard | Louisiana | 22087 | 891 | 24 |
358188 | 358188 | 2020-07-22 | St. Bernard | Louisiana | 22087 | 874 | 24 |
354985 | 354985 | 2020-07-21 | St. Bernard | Louisiana | 22087 | 839 | 24 |
351783 | 351783 | 2020-07-20 | St. Bernard | Louisiana | 22087 | 830 | 24 |
348583 | 348583 | 2020-07-19 | St. Bernard | Louisiana | 22087 | 816 | 24 |
345382 | 345382 | 2020-07-18 | St. Bernard | Louisiana | 22087 | 792 | 24 |
342182 | 342182 | 2020-07-17 | St. Bernard | Louisiana | 22087 | 792 | 24 |
338986 | 338986 | 2020-07-16 | St. Bernard | Louisiana | 22087 | 774 | 24 |
335790 | 335790 | 2020-07-15 | St. Bernard | Louisiana | 22087 | 754 | 24 |
332597 | 332597 | 2020-07-14 | St. Bernard | Louisiana | 22087 | 738 | 24 |
329410 | 329410 | 2020-07-13 | St. Bernard | Louisiana | 22087 | 721 | 24 |
326224 | 326224 | 2020-07-12 | St. Bernard | Louisiana | 22087 | 706 | 24 |
323041 | 323041 | 2020-07-11 | St. Bernard | Louisiana | 22087 | 702 | 24 |
319862 | 319862 | 2020-07-10 | St. Bernard | Louisiana | 22087 | 689 | 23 |
316687 | 316687 | 2020-07-09 | St. Bernard | Louisiana | 22087 | 678 | 23 |
313513 | 313513 | 2020-07-08 | St. Bernard | Louisiana | 22087 | 668 | 23 |
310343 | 310343 | 2020-07-07 | St. Bernard | Louisiana | 22087 | 659 | 23 |
307175 | 307175 | 2020-07-06 | St. Bernard | Louisiana | 22087 | 650 | 23 |
304008 | 304008 | 2020-07-05 | St. Bernard | Louisiana | 22087 | 646 | 23 |
300844 | 300844 | 2020-07-04 | St. Bernard | Louisiana | 22087 | 641 | 23 |
297682 | 297682 | 2020-07-03 | St. Bernard | Louisiana | 22087 | 641 | 23 |
294524 | 294524 | 2020-07-02 | St. Bernard | Louisiana | 22087 | 629 | 23 |
291370 | 291370 | 2020-07-01 | St. Bernard | Louisiana | 22087 | 621 | 23 |
288219 | 288219 | 2020-06-30 | St. Bernard | Louisiana | 22087 | 617 | 23 |
285070 | 285070 | 2020-06-29 | St. Bernard | Louisiana | 22087 | 611 | 23 |
281924 | 281924 | 2020-06-28 | St. Bernard | Louisiana | 22087 | 607 | 23 |
278776 | 278776 | 2020-06-27 | St. Bernard | Louisiana | 22087 | 605 | 23 |
275628 | 275628 | 2020-06-26 | St. Bernard | Louisiana | 22087 | 605 | 23 |
272485 | 272485 | 2020-06-25 | St. Bernard | Louisiana | 22087 | 602 | 23 |
269349 | 269349 | 2020-06-24 | St. Bernard | Louisiana | 22087 | 601 | 23 |
266216 | 266216 | 2020-06-23 | St. Bernard | Louisiana | 22087 | 599 | 23 |
263089 | 263089 | 2020-06-22 | St. Bernard | Louisiana | 22087 | 601 | 23 |
259960 | 259960 | 2020-06-21 | St. Bernard | Louisiana | 22087 | 601 | 23 |
256834 | 256834 | 2020-06-20 | St. Bernard | Louisiana | 22087 | 598 | 23 |
253714 | 253714 | 2020-06-19 | St. Bernard | Louisiana | 22087 | 598 | 23 |
250599 | 250599 | 2020-06-18 | St. Bernard | Louisiana | 22087 | 580 | 23 |
247487 | 247487 | 2020-06-17 | St. Bernard | Louisiana | 22087 | 580 | 23 |
244374 | 244374 | 2020-06-16 | St. Bernard | Louisiana | 22087 | 575 | 23 |
241263 | 241263 | 2020-06-15 | St. Bernard | Louisiana | 22087 | 571 | 23 |
238154 | 238154 | 2020-06-14 | St. Bernard | Louisiana | 22087 | 569 | 23 |
235047 | 235047 | 2020-06-13 | St. Bernard | Louisiana | 22087 | 568 | 23 |
231942 | 231942 | 2020-06-12 | St. Bernard | Louisiana | 22087 | 562 | 23 |
228838 | 228838 | 2020-06-11 | St. Bernard | Louisiana | 22087 | 559 | 23 |
225736 | 225736 | 2020-06-10 | St. Bernard | Louisiana | 22087 | 558 | 23 |
222640 | 222640 | 2020-06-09 | St. Bernard | Louisiana | 22087 | 555 | 23 |
219545 | 219545 | 2020-06-08 | St. Bernard | Louisiana | 22087 | 555 | 23 |
216453 | 216453 | 2020-06-07 | St. Bernard | Louisiana | 22087 | 552 | 23 |
213366 | 213366 | 2020-06-06 | St. Bernard | Louisiana | 22087 | 549 | 23 |
210281 | 210281 | 2020-06-05 | St. Bernard | Louisiana | 22087 | 548 | 22 |
207200 | 207200 | 2020-06-04 | St. Bernard | Louisiana | 22087 | 546 | 22 |
204119 | 204119 | 2020-06-03 | St. Bernard | Louisiana | 22087 | 545 | 22 |
201042 | 201042 | 2020-06-02 | St. Bernard | Louisiana | 22087 | 544 | 22 |
197970 | 197970 | 2020-06-01 | St. Bernard | Louisiana | 22087 | 539 | 22 |
194899 | 194899 | 2020-05-31 | St. Bernard | Louisiana | 22087 | 536 | 22 |
191831 | 191831 | 2020-05-30 | St. Bernard | Louisiana | 22087 | 536 | 22 |
188767 | 188767 | 2020-05-29 | St. Bernard | Louisiana | 22087 | 534 | 22 |
185709 | 185709 | 2020-05-28 | St. Bernard | Louisiana | 22087 | 534 | 22 |
182654 | 182654 | 2020-05-27 | St. Bernard | Louisiana | 22087 | 531 | 22 |
179609 | 179609 | 2020-05-26 | St. Bernard | Louisiana | 22087 | 529 | 22 |
176565 | 176565 | 2020-05-25 | St. Bernard | Louisiana | 22087 | 529 | 21 |
173521 | 173521 | 2020-05-24 | St. Bernard | Louisiana | 22087 | 521 | 21 |
170480 | 170480 | 2020-05-23 | St. Bernard | Louisiana | 22087 | 521 | 21 |
167442 | 167442 | 2020-05-22 | St. Bernard | Louisiana | 22087 | 521 | 21 |
164406 | 164406 | 2020-05-21 | St. Bernard | Louisiana | 22087 | 521 | 21 |
161377 | 161377 | 2020-05-20 | St. Bernard | Louisiana | 22087 | 518 | 21 |
158351 | 158351 | 2020-05-19 | St. Bernard | Louisiana | 22087 | 516 | 20 |
155333 | 155333 | 2020-05-18 | St. Bernard | Louisiana | 22087 | 513 | 19 |
152319 | 152319 | 2020-05-17 | St. Bernard | Louisiana | 22087 | 512 | 18 |
149308 | 149308 | 2020-05-16 | St. Bernard | Louisiana | 22087 | 511 | 18 |
146303 | 146303 | 2020-05-15 | St. Bernard | Louisiana | 22087 | 517 | 18 |
143303 | 143303 | 2020-05-14 | St. Bernard | Louisiana | 22087 | 516 | 18 |
140308 | 140308 | 2020-05-13 | St. Bernard | Louisiana | 22087 | 515 | 18 |
137314 | 137314 | 2020-05-12 | St. Bernard | Louisiana | 22087 | 515 | 19 |
134324 | 134324 | 2020-05-11 | St. Bernard | Louisiana | 22087 | 514 | 20 |
131333 | 131333 | 2020-05-10 | St. Bernard | Louisiana | 22087 | 513 | 20 |
128343 | 128343 | 2020-05-09 | St. Bernard | Louisiana | 22087 | 512 | 20 |
125356 | 125356 | 2020-05-08 | St. Bernard | Louisiana | 22087 | 508 | 20 |
122374 | 122374 | 2020-05-07 | St. Bernard | Louisiana | 22087 | 508 | 20 |
119403 | 119403 | 2020-05-06 | St. Bernard | Louisiana | 22087 | 505 | 20 |
116442 | 116442 | 2020-05-05 | St. Bernard | Louisiana | 22087 | 502 | 20 |
113560 | 113560 | 2020-05-04 | St. Bernard | Louisiana | 22087 | 480 | 20 |
110683 | 110683 | 2020-05-03 | St. Bernard | Louisiana | 22087 | 475 | 20 |
107811 | 107811 | 2020-05-02 | St. Bernard | Louisiana | 22087 | 474 | 20 |
104947 | 104947 | 2020-05-01 | St. Bernard | Louisiana | 22087 | 469 | 20 |
102086 | 102086 | 2020-04-30 | St. Bernard | Louisiana | 22087 | 464 | 20 |
99234 | 99234 | 2020-04-29 | St. Bernard | Louisiana | 22087 | 461 | 19 |
96388 | 96388 | 2020-04-28 | St. Bernard | Louisiana | 22087 | 452 | 18 |
93553 | 93553 | 2020-04-27 | St. Bernard | Louisiana | 22087 | 449 | 15 |
90732 | 90732 | 2020-04-26 | St. Bernard | Louisiana | 22087 | 446 | 15 |
87916 | 87916 | 2020-04-25 | St. Bernard | Louisiana | 22087 | 443 | 15 |
85107 | 85107 | 2020-04-24 | St. Bernard | Louisiana | 22087 | 440 | 15 |
82303 | 82303 | 2020-04-23 | St. Bernard | Louisiana | 22087 | 435 | 15 |
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);