ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22073 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
285063 | 285063 | 2020-06-29 | Ouachita | Louisiana | 22073 | 2331 | 73 |
288212 | 288212 | 2020-06-30 | Ouachita | Louisiana | 22073 | 2392 | 74 |
291363 | 291363 | 2020-07-01 | Ouachita | Louisiana | 22073 | 2474 | 75 |
294517 | 294517 | 2020-07-02 | Ouachita | Louisiana | 22073 | 2537 | 78 |
297675 | 297675 | 2020-07-03 | Ouachita | Louisiana | 22073 | 2591 | 80 |
300837 | 300837 | 2020-07-04 | Ouachita | Louisiana | 22073 | 2591 | 80 |
304001 | 304001 | 2020-07-05 | Ouachita | Louisiana | 22073 | 2667 | 80 |
307168 | 307168 | 2020-07-06 | Ouachita | Louisiana | 22073 | 2694 | 80 |
310336 | 310336 | 2020-07-07 | Ouachita | Louisiana | 22073 | 2730 | 80 |
313506 | 313506 | 2020-07-08 | Ouachita | Louisiana | 22073 | 2794 | 82 |
316680 | 316680 | 2020-07-09 | Ouachita | Louisiana | 22073 | 2849 | 84 |
319855 | 319855 | 2020-07-10 | Ouachita | Louisiana | 22073 | 2988 | 85 |
323034 | 323034 | 2020-07-11 | Ouachita | Louisiana | 22073 | 3079 | 86 |
326217 | 326217 | 2020-07-12 | Ouachita | Louisiana | 22073 | 3120 | 86 |
329403 | 329403 | 2020-07-13 | Ouachita | Louisiana | 22073 | 3175 | 86 |
332590 | 332590 | 2020-07-14 | Ouachita | Louisiana | 22073 | 3214 | 90 |
335783 | 335783 | 2020-07-15 | Ouachita | Louisiana | 22073 | 3296 | 92 |
338979 | 338979 | 2020-07-16 | Ouachita | Louisiana | 22073 | 3388 | 95 |
342175 | 342175 | 2020-07-17 | Ouachita | Louisiana | 22073 | 3475 | 95 |
345375 | 345375 | 2020-07-18 | Ouachita | Louisiana | 22073 | 3475 | 95 |
348576 | 348576 | 2020-07-19 | Ouachita | Louisiana | 22073 | 3569 | 96 |
351776 | 351776 | 2020-07-20 | Ouachita | Louisiana | 22073 | 3643 | 95 |
354978 | 354978 | 2020-07-21 | Ouachita | Louisiana | 22073 | 3669 | 98 |
358181 | 358181 | 2020-07-22 | Ouachita | Louisiana | 22073 | 3778 | 98 |
361386 | 361386 | 2020-07-23 | Ouachita | Louisiana | 22073 | 3845 | 97 |
364593 | 364593 | 2020-07-24 | Ouachita | Louisiana | 22073 | 3916 | 97 |
367800 | 367800 | 2020-07-25 | Ouachita | Louisiana | 22073 | 3916 | 97 |
371010 | 371010 | 2020-07-26 | Ouachita | Louisiana | 22073 | 4102 | 99 |
374222 | 374222 | 2020-07-27 | Ouachita | Louisiana | 22073 | 4144 | 99 |
377437 | 377437 | 2020-07-28 | Ouachita | Louisiana | 22073 | 4169 | 100 |
380654 | 380654 | 2020-07-29 | Ouachita | Louisiana | 22073 | 4246 | 103 |
383871 | 383871 | 2020-07-30 | Ouachita | Louisiana | 22073 | 4304 | 104 |
387089 | 387089 | 2020-07-31 | Ouachita | Louisiana | 22073 | 4372 | 105 |
390306 | 390306 | 2020-08-01 | Ouachita | Louisiana | 22073 | 4372 | 105 |
393523 | 393523 | 2020-08-02 | Ouachita | Louisiana | 22073 | 4474 | 105 |
396739 | 396739 | 2020-08-03 | Ouachita | Louisiana | 22073 | 4509 | 105 |
399954 | 399954 | 2020-08-04 | Ouachita | Louisiana | 22073 | 4592 | 107 |
403171 | 403171 | 2020-08-05 | Ouachita | Louisiana | 22073 | 4644 | 107 |
406389 | 406389 | 2020-08-06 | Ouachita | Louisiana | 22073 | 4709 | 109 |
409609 | 409609 | 2020-08-07 | Ouachita | Louisiana | 22073 | 4787 | 111 |
412829 | 412829 | 2020-08-08 | Ouachita | Louisiana | 22073 | 4787 | 111 |
416049 | 416049 | 2020-08-09 | Ouachita | Louisiana | 22073 | 4870 | 113 |
419270 | 419270 | 2020-08-10 | Ouachita | Louisiana | 22073 | 4896 | 113 |
422492 | 422492 | 2020-08-11 | Ouachita | Louisiana | 22073 | 4923 | 114 |
425713 | 425713 | 2020-08-12 | Ouachita | Louisiana | 22073 | 4967 | 114 |
428937 | 428937 | 2020-08-13 | Ouachita | Louisiana | 22073 | 5027 | 117 |
432165 | 432165 | 2020-08-14 | Ouachita | Louisiana | 22073 | 5067 | 117 |
435390 | 435390 | 2020-08-15 | Ouachita | Louisiana | 22073 | 5067 | 117 |
438615 | 438615 | 2020-08-16 | Ouachita | Louisiana | 22073 | 5144 | 117 |
441842 | 441842 | 2020-08-17 | Ouachita | Louisiana | 22073 | 5161 | 117 |
445068 | 445068 | 2020-08-18 | Ouachita | Louisiana | 22073 | 5187 | 117 |
448295 | 448295 | 2020-08-19 | Ouachita | Louisiana | 22073 | 5220 | 121 |
451523 | 451523 | 2020-08-20 | Ouachita | Louisiana | 22073 | 5259 | 121 |
454751 | 454751 | 2020-08-21 | Ouachita | Louisiana | 22073 | 5308 | 122 |
457979 | 457979 | 2020-08-22 | Ouachita | Louisiana | 22073 | 5308 | 122 |
467666 | 467666 | 2020-08-25 | Ouachita | Louisiana | 22073 | 5355 | 125 |
470895 | 470895 | 2020-08-26 | Ouachita | Louisiana | 22073 | 5369 | 125 |
461206 | 461206 | 2020-08-23 | Ouachita | Louisiana | 22073 | 5372 | 123 |
464437 | 464437 | 2020-08-24 | Ouachita | Louisiana | 22073 | 5389 | 124 |
474127 | 474127 | 2020-08-27 | Ouachita | Louisiana | 22073 | 5400 | 127 |
477360 | 477360 | 2020-08-28 | Ouachita | Louisiana | 22073 | 5441 | 128 |
480593 | 480593 | 2020-08-29 | Ouachita | Louisiana | 22073 | 5441 | 128 |
483827 | 483827 | 2020-08-30 | Ouachita | Louisiana | 22073 | 5468 | 128 |
487062 | 487062 | 2020-08-31 | Ouachita | Louisiana | 22073 | 5481 | 128 |
490295 | 490295 | 2020-09-01 | Ouachita | Louisiana | 22073 | 5509 | 129 |
493529 | 493529 | 2020-09-02 | Ouachita | Louisiana | 22073 | 5527 | 129 |
496762 | 496762 | 2020-09-03 | Ouachita | Louisiana | 22073 | 5559 | 129 |
499996 | 499996 | 2020-09-04 | Ouachita | Louisiana | 22073 | 5579 | 130 |
503229 | 503229 | 2020-09-05 | Ouachita | Louisiana | 22073 | 5579 | 130 |
506463 | 506463 | 2020-09-06 | Ouachita | Louisiana | 22073 | 5633 | 133 |
512928 | 512928 | 2020-09-08 | Ouachita | Louisiana | 22073 | 5668 | 133 |
509696 | 509696 | 2020-09-07 | Ouachita | Louisiana | 22073 | 5669 | 133 |
516161 | 516161 | 2020-09-09 | Ouachita | Louisiana | 22073 | 5741 | 133 |
519396 | 519396 | 2020-09-10 | Ouachita | Louisiana | 22073 | 5755 | 135 |
522633 | 522633 | 2020-09-11 | Ouachita | Louisiana | 22073 | 5782 | 137 |
525869 | 525869 | 2020-09-12 | Ouachita | Louisiana | 22073 | 5782 | 137 |
529105 | 529105 | 2020-09-13 | Ouachita | Louisiana | 22073 | 5852 | 138 |
532342 | 532342 | 2020-09-14 | Ouachita | Louisiana | 22073 | 5891 | 138 |
535577 | 535577 | 2020-09-15 | Ouachita | Louisiana | 22073 | 5896 | 138 |
538814 | 538814 | 2020-09-16 | Ouachita | Louisiana | 22073 | 5921 | 138 |
542050 | 542050 | 2020-09-17 | Ouachita | Louisiana | 22073 | 5952 | 138 |
545286 | 545286 | 2020-09-18 | Ouachita | Louisiana | 22073 | 6010 | 139 |
548524 | 548524 | 2020-09-19 | Ouachita | Louisiana | 22073 | 6010 | 139 |
551763 | 551763 | 2020-09-20 | Ouachita | Louisiana | 22073 | 6077 | 141 |
555002 | 555002 | 2020-09-21 | Ouachita | Louisiana | 22073 | 6092 | 141 |
558239 | 558239 | 2020-09-22 | Ouachita | Louisiana | 22073 | 6120 | 141 |
561475 | 561475 | 2020-09-23 | Ouachita | Louisiana | 22073 | 6122 | 141 |
564715 | 564715 | 2020-09-24 | Ouachita | Louisiana | 22073 | 6163 | 142 |
567955 | 567955 | 2020-09-25 | Ouachita | Louisiana | 22073 | 6193 | 142 |
571197 | 571197 | 2020-09-26 | Ouachita | Louisiana | 22073 | 6193 | 142 |
574440 | 574440 | 2020-09-27 | Ouachita | Louisiana | 22073 | 6249 | 143 |
577682 | 577682 | 2020-09-28 | Ouachita | Louisiana | 22073 | 6258 | 144 |
580923 | 580923 | 2020-09-29 | Ouachita | Louisiana | 22073 | 6276 | 144 |
584163 | 584163 | 2020-09-30 | Ouachita | Louisiana | 22073 | 6294 | 144 |
587403 | 587403 | 2020-10-01 | Ouachita | Louisiana | 22073 | 6320 | 146 |
590644 | 590644 | 2020-10-02 | Ouachita | Louisiana | 22073 | 6364 | 148 |
593885 | 593885 | 2020-10-03 | Ouachita | Louisiana | 22073 | 6364 | 148 |
597127 | 597127 | 2020-10-04 | Ouachita | Louisiana | 22073 | 6428 | 149 |
600369 | 600369 | 2020-10-05 | Ouachita | Louisiana | 22073 | 6437 | 149 |
603612 | 603612 | 2020-10-06 | Ouachita | Louisiana | 22073 | 6451 | 150 |
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);