ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Ascension" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535543 | 535543 | 2020-09-15 | Ascension | Louisiana | 22005 | 3610 | 96 |
532308 | 532308 | 2020-09-14 | Ascension | Louisiana | 22005 | 3588 | 95 |
529071 | 529071 | 2020-09-13 | Ascension | Louisiana | 22005 | 3571 | 95 |
525835 | 525835 | 2020-09-12 | Ascension | Louisiana | 22005 | 3538 | 94 |
522599 | 522599 | 2020-09-11 | Ascension | Louisiana | 22005 | 3538 | 94 |
519362 | 519362 | 2020-09-10 | Ascension | Louisiana | 22005 | 3512 | 94 |
516127 | 516127 | 2020-09-09 | Ascension | Louisiana | 22005 | 3497 | 93 |
512894 | 512894 | 2020-09-08 | Ascension | Louisiana | 22005 | 3474 | 93 |
509662 | 509662 | 2020-09-07 | Ascension | Louisiana | 22005 | 3465 | 92 |
506429 | 506429 | 2020-09-06 | Ascension | Louisiana | 22005 | 3457 | 92 |
503195 | 503195 | 2020-09-05 | Ascension | Louisiana | 22005 | 3429 | 92 |
499962 | 499962 | 2020-09-04 | Ascension | Louisiana | 22005 | 3429 | 92 |
496728 | 496728 | 2020-09-03 | Ascension | Louisiana | 22005 | 3418 | 92 |
493495 | 493495 | 2020-09-02 | Ascension | Louisiana | 22005 | 3395 | 92 |
490261 | 490261 | 2020-09-01 | Ascension | Louisiana | 22005 | 3377 | 92 |
487028 | 487028 | 2020-08-31 | Ascension | Louisiana | 22005 | 3344 | 92 |
483793 | 483793 | 2020-08-30 | Ascension | Louisiana | 22005 | 3324 | 92 |
480559 | 480559 | 2020-08-29 | Ascension | Louisiana | 22005 | 3291 | 92 |
477326 | 477326 | 2020-08-28 | Ascension | Louisiana | 22005 | 3291 | 92 |
474093 | 474093 | 2020-08-27 | Ascension | Louisiana | 22005 | 3267 | 90 |
470861 | 470861 | 2020-08-26 | Ascension | Louisiana | 22005 | 3257 | 90 |
467632 | 467632 | 2020-08-25 | Ascension | Louisiana | 22005 | 3245 | 90 |
464403 | 464403 | 2020-08-24 | Ascension | Louisiana | 22005 | 3226 | 87 |
461172 | 461172 | 2020-08-23 | Ascension | Louisiana | 22005 | 3218 | 87 |
457945 | 457945 | 2020-08-22 | Ascension | Louisiana | 22005 | 3175 | 85 |
454717 | 454717 | 2020-08-21 | Ascension | Louisiana | 22005 | 3175 | 85 |
451489 | 451489 | 2020-08-20 | Ascension | Louisiana | 22005 | 3140 | 83 |
448261 | 448261 | 2020-08-19 | Ascension | Louisiana | 22005 | 3118 | 81 |
445034 | 445034 | 2020-08-18 | Ascension | Louisiana | 22005 | 3108 | 81 |
441808 | 441808 | 2020-08-17 | Ascension | Louisiana | 22005 | 3084 | 81 |
438581 | 438581 | 2020-08-16 | Ascension | Louisiana | 22005 | 3064 | 81 |
435356 | 435356 | 2020-08-15 | Ascension | Louisiana | 22005 | 3016 | 79 |
432131 | 432131 | 2020-08-14 | Ascension | Louisiana | 22005 | 3016 | 79 |
428903 | 428903 | 2020-08-13 | Ascension | Louisiana | 22005 | 2970 | 79 |
425679 | 425679 | 2020-08-12 | Ascension | Louisiana | 22005 | 2941 | 78 |
422458 | 422458 | 2020-08-11 | Ascension | Louisiana | 22005 | 2930 | 77 |
419236 | 419236 | 2020-08-10 | Ascension | Louisiana | 22005 | 2890 | 74 |
416015 | 416015 | 2020-08-09 | Ascension | Louisiana | 22005 | 2871 | 74 |
412795 | 412795 | 2020-08-08 | Ascension | Louisiana | 22005 | 2798 | 71 |
409575 | 409575 | 2020-08-07 | Ascension | Louisiana | 22005 | 2798 | 71 |
406355 | 406355 | 2020-08-06 | Ascension | Louisiana | 22005 | 2768 | 71 |
403137 | 403137 | 2020-08-05 | Ascension | Louisiana | 22005 | 2725 | 71 |
399920 | 399920 | 2020-08-04 | Ascension | Louisiana | 22005 | 2681 | 71 |
396705 | 396705 | 2020-08-03 | Ascension | Louisiana | 22005 | 2643 | 71 |
393489 | 393489 | 2020-08-02 | Ascension | Louisiana | 22005 | 2609 | 68 |
390272 | 390272 | 2020-08-01 | Ascension | Louisiana | 22005 | 2458 | 68 |
387055 | 387055 | 2020-07-31 | Ascension | Louisiana | 22005 | 2458 | 68 |
383837 | 383837 | 2020-07-30 | Ascension | Louisiana | 22005 | 2444 | 67 |
380620 | 380620 | 2020-07-29 | Ascension | Louisiana | 22005 | 2383 | 66 |
377403 | 377403 | 2020-07-28 | Ascension | Louisiana | 22005 | 2357 | 65 |
374188 | 374188 | 2020-07-27 | Ascension | Louisiana | 22005 | 2335 | 65 |
370976 | 370976 | 2020-07-26 | Ascension | Louisiana | 22005 | 2249 | 65 |
367766 | 367766 | 2020-07-25 | Ascension | Louisiana | 22005 | 2175 | 65 |
364559 | 364559 | 2020-07-24 | Ascension | Louisiana | 22005 | 2175 | 65 |
361352 | 361352 | 2020-07-23 | Ascension | Louisiana | 22005 | 2132 | 65 |
358147 | 358147 | 2020-07-22 | Ascension | Louisiana | 22005 | 2077 | 65 |
354944 | 354944 | 2020-07-21 | Ascension | Louisiana | 22005 | 2022 | 65 |
351742 | 351742 | 2020-07-20 | Ascension | Louisiana | 22005 | 1976 | 65 |
348542 | 348542 | 2020-07-19 | Ascension | Louisiana | 22005 | 1896 | 64 |
345341 | 345341 | 2020-07-18 | Ascension | Louisiana | 22005 | 1826 | 64 |
342141 | 342141 | 2020-07-17 | Ascension | Louisiana | 22005 | 1826 | 64 |
338945 | 338945 | 2020-07-16 | Ascension | Louisiana | 22005 | 1755 | 64 |
335749 | 335749 | 2020-07-15 | Ascension | Louisiana | 22005 | 1710 | 64 |
332556 | 332556 | 2020-07-14 | Ascension | Louisiana | 22005 | 1655 | 64 |
329369 | 329369 | 2020-07-13 | Ascension | Louisiana | 22005 | 1622 | 64 |
326183 | 326183 | 2020-07-12 | Ascension | Louisiana | 22005 | 1597 | 63 |
323000 | 323000 | 2020-07-11 | Ascension | Louisiana | 22005 | 1564 | 63 |
319821 | 319821 | 2020-07-10 | Ascension | Louisiana | 22005 | 1532 | 63 |
316646 | 316646 | 2020-07-09 | Ascension | Louisiana | 22005 | 1480 | 60 |
313472 | 313472 | 2020-07-08 | Ascension | Louisiana | 22005 | 1441 | 60 |
310302 | 310302 | 2020-07-07 | Ascension | Louisiana | 22005 | 1412 | 59 |
307134 | 307134 | 2020-07-06 | Ascension | Louisiana | 22005 | 1358 | 58 |
303967 | 303967 | 2020-07-05 | Ascension | Louisiana | 22005 | 1331 | 58 |
300803 | 300803 | 2020-07-04 | Ascension | Louisiana | 22005 | 1278 | 58 |
297641 | 297641 | 2020-07-03 | Ascension | Louisiana | 22005 | 1278 | 58 |
294483 | 294483 | 2020-07-02 | Ascension | Louisiana | 22005 | 1246 | 58 |
291329 | 291329 | 2020-07-01 | Ascension | Louisiana | 22005 | 1213 | 58 |
288178 | 288178 | 2020-06-30 | Ascension | Louisiana | 22005 | 1171 | 58 |
285029 | 285029 | 2020-06-29 | Ascension | Louisiana | 22005 | 1157 | 58 |
281883 | 281883 | 2020-06-28 | Ascension | Louisiana | 22005 | 1146 | 58 |
278735 | 278735 | 2020-06-27 | Ascension | Louisiana | 22005 | 1115 | 58 |
275587 | 275587 | 2020-06-26 | Ascension | Louisiana | 22005 | 1115 | 58 |
272444 | 272444 | 2020-06-25 | Ascension | Louisiana | 22005 | 1094 | 58 |
269308 | 269308 | 2020-06-24 | Ascension | Louisiana | 22005 | 1070 | 58 |
266175 | 266175 | 2020-06-23 | Ascension | Louisiana | 22005 | 1044 | 58 |
263048 | 263048 | 2020-06-22 | Ascension | Louisiana | 22005 | 1008 | 58 |
259919 | 259919 | 2020-06-21 | Ascension | Louisiana | 22005 | 997 | 58 |
256793 | 256793 | 2020-06-20 | Ascension | Louisiana | 22005 | 989 | 58 |
253673 | 253673 | 2020-06-19 | Ascension | Louisiana | 22005 | 961 | 58 |
250558 | 250558 | 2020-06-18 | Ascension | Louisiana | 22005 | 962 | 58 |
247446 | 247446 | 2020-06-17 | Ascension | Louisiana | 22005 | 962 | 58 |
244333 | 244333 | 2020-06-16 | Ascension | Louisiana | 22005 | 957 | 58 |
241222 | 241222 | 2020-06-15 | Ascension | Louisiana | 22005 | 948 | 58 |
238113 | 238113 | 2020-06-14 | Ascension | Louisiana | 22005 | 935 | 58 |
235006 | 235006 | 2020-06-13 | Ascension | Louisiana | 22005 | 931 | 58 |
231901 | 231901 | 2020-06-12 | Ascension | Louisiana | 22005 | 918 | 58 |
228797 | 228797 | 2020-06-11 | Ascension | Louisiana | 22005 | 912 | 58 |
225695 | 225695 | 2020-06-10 | Ascension | Louisiana | 22005 | 906 | 58 |
222599 | 222599 | 2020-06-09 | Ascension | Louisiana | 22005 | 900 | 58 |
219504 | 219504 | 2020-06-08 | Ascension | Louisiana | 22005 | 889 | 58 |
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);