covid_casesdeaths_reshaped_bln
Data source: Big Local News · About: big-local-datasette
1,191,735 rows sorted by County Name
This data as json, copyable, CSV (advanced)
Link | rowid | countyFIPS | County Name ▼ | State | stateFIPS | date | cases | deaths |
---|---|---|---|---|---|---|---|---|
321860 | 321860 | 45001 | Abbeville County | SC | 45 | 5/1/20 | 31 | 0 |
325055 | 325055 | 45001 | Abbeville County | SC | 45 | 5/2/20 | 31 | 0 |
328250 | 328250 | 45001 | Abbeville County | SC | 45 | 5/3/20 | 33 | 0 |
331445 | 331445 | 45001 | Abbeville County | SC | 45 | 5/4/20 | 33 | 0 |
334640 | 334640 | 45001 | Abbeville County | SC | 45 | 5/5/20 | 33 | 0 |
337835 | 337835 | 45001 | Abbeville County | SC | 45 | 5/6/20 | 33 | 0 |
341030 | 341030 | 45001 | Abbeville County | SC | 45 | 5/7/20 | 34 | 0 |
344225 | 344225 | 45001 | Abbeville County | SC | 45 | 5/8/20 | 34 | 0 |
347420 | 347420 | 45001 | Abbeville County | SC | 45 | 5/9/20 | 34 | 0 |
350615 | 350615 | 45001 | Abbeville County | SC | 45 | 5/10/20 | 34 | 0 |
353810 | 353810 | 45001 | Abbeville County | SC | 45 | 5/11/20 | 34 | 0 |
357005 | 357005 | 45001 | Abbeville County | SC | 45 | 5/12/20 | 34 | 0 |
360200 | 360200 | 45001 | Abbeville County | SC | 45 | 5/13/20 | 34 | 0 |
363395 | 363395 | 45001 | Abbeville County | SC | 45 | 5/14/20 | 34 | 0 |
366590 | 366590 | 45001 | Abbeville County | SC | 45 | 5/15/20 | 34 | 0 |
369785 | 369785 | 45001 | Abbeville County | SC | 45 | 5/16/20 | 34 | 0 |
372980 | 372980 | 45001 | Abbeville County | SC | 45 | 5/17/20 | 35 | 0 |
376175 | 376175 | 45001 | Abbeville County | SC | 45 | 5/18/20 | 35 | 0 |
379370 | 379370 | 45001 | Abbeville County | SC | 45 | 5/19/20 | 35 | 0 |
382565 | 382565 | 45001 | Abbeville County | SC | 45 | 5/20/20 | 35 | 0 |
385760 | 385760 | 45001 | Abbeville County | SC | 45 | 5/21/20 | 35 | 0 |
388955 | 388955 | 45001 | Abbeville County | SC | 45 | 5/22/20 | 35 | 0 |
392150 | 392150 | 45001 | Abbeville County | SC | 45 | 5/23/20 | 35 | 0 |
395345 | 395345 | 45001 | Abbeville County | SC | 45 | 5/24/20 | 35 | 0 |
398540 | 398540 | 45001 | Abbeville County | SC | 45 | 5/25/20 | 35 | 0 |
401735 | 401735 | 45001 | Abbeville County | SC | 45 | 5/26/20 | 35 | 0 |
404930 | 404930 | 45001 | Abbeville County | SC | 45 | 5/27/20 | 35 | 0 |
408125 | 408125 | 45001 | Abbeville County | SC | 45 | 5/28/20 | 37 | 0 |
411320 | 411320 | 45001 | Abbeville County | SC | 45 | 5/29/20 | 39 | 0 |
414515 | 414515 | 45001 | Abbeville County | SC | 45 | 5/30/20 | 42 | 0 |
417710 | 417710 | 45001 | Abbeville County | SC | 45 | 5/31/20 | 42 | 0 |
420905 | 420905 | 45001 | Abbeville County | SC | 45 | 6/1/20 | 44 | 0 |
424100 | 424100 | 45001 | Abbeville County | SC | 45 | 6/2/20 | 46 | 0 |
427295 | 427295 | 45001 | Abbeville County | SC | 45 | 6/3/20 | 46 | 0 |
430490 | 430490 | 45001 | Abbeville County | SC | 45 | 6/4/20 | 47 | 0 |
433685 | 433685 | 45001 | Abbeville County | SC | 45 | 6/5/20 | 47 | 0 |
436880 | 436880 | 45001 | Abbeville County | SC | 45 | 6/6/20 | 49 | 0 |
440075 | 440075 | 45001 | Abbeville County | SC | 45 | 6/7/20 | 51 | 0 |
443270 | 443270 | 45001 | Abbeville County | SC | 45 | 6/8/20 | 58 | 0 |
446465 | 446465 | 45001 | Abbeville County | SC | 45 | 6/9/20 | 60 | 0 |
449660 | 449660 | 45001 | Abbeville County | SC | 45 | 6/10/20 | 60 | 0 |
452855 | 452855 | 45001 | Abbeville County | SC | 45 | 6/11/20 | 62 | 0 |
456050 | 456050 | 45001 | Abbeville County | SC | 45 | 6/12/20 | 62 | 0 |
459245 | 459245 | 45001 | Abbeville County | SC | 45 | 6/13/20 | 63 | 0 |
462440 | 462440 | 45001 | Abbeville County | SC | 45 | 6/14/20 | 67 | 0 |
465635 | 465635 | 45001 | Abbeville County | SC | 45 | 6/15/20 | 70 | 0 |
468830 | 468830 | 45001 | Abbeville County | SC | 45 | 6/16/20 | 73 | 0 |
472025 | 472025 | 45001 | Abbeville County | SC | 45 | 6/17/20 | 73 | 0 |
475220 | 475220 | 45001 | Abbeville County | SC | 45 | 6/18/20 | 73 | 0 |
478415 | 478415 | 45001 | Abbeville County | SC | 45 | 6/19/20 | 73 | 0 |
481610 | 481610 | 45001 | Abbeville County | SC | 45 | 6/20/20 | 86 | 0 |
484805 | 484805 | 45001 | Abbeville County | SC | 45 | 6/21/20 | 86 | 0 |
488000 | 488000 | 45001 | Abbeville County | SC | 45 | 6/22/20 | 86 | 0 |
491195 | 491195 | 45001 | Abbeville County | SC | 45 | 6/23/20 | 86 | 0 |
494390 | 494390 | 45001 | Abbeville County | SC | 45 | 6/24/20 | 91 | 0 |
497585 | 497585 | 45001 | Abbeville County | SC | 45 | 6/25/20 | 99 | 0 |
500780 | 500780 | 45001 | Abbeville County | SC | 45 | 6/26/20 | 100 | 0 |
503975 | 503975 | 45001 | Abbeville County | SC | 45 | 6/27/20 | 103 | 0 |
507170 | 507170 | 45001 | Abbeville County | SC | 45 | 6/28/20 | 103 | 0 |
510365 | 510365 | 45001 | Abbeville County | SC | 45 | 6/29/20 | 106 | 0 |
513560 | 513560 | 45001 | Abbeville County | SC | 45 | 6/30/20 | 113 | 0 |
516755 | 516755 | 45001 | Abbeville County | SC | 45 | 7/1/20 | 113 | 0 |
519950 | 519950 | 45001 | Abbeville County | SC | 45 | 7/2/20 | 119 | 0 |
523145 | 523145 | 45001 | Abbeville County | SC | 45 | 7/3/20 | 118 | 0 |
526340 | 526340 | 45001 | Abbeville County | SC | 45 | 7/4/20 | 119 | 0 |
529535 | 529535 | 45001 | Abbeville County | SC | 45 | 7/5/20 | 124 | 0 |
532730 | 532730 | 45001 | Abbeville County | SC | 45 | 7/6/20 | 134 | 0 |
535925 | 535925 | 45001 | Abbeville County | SC | 45 | 7/7/20 | 134 | 1 |
539120 | 539120 | 45001 | Abbeville County | SC | 45 | 7/8/20 | 137 | 1 |
542315 | 542315 | 45001 | Abbeville County | SC | 45 | 7/9/20 | 138 | 1 |
545510 | 545510 | 45001 | Abbeville County | SC | 45 | 7/10/20 | 141 | 1 |
548705 | 548705 | 45001 | Abbeville County | SC | 45 | 7/11/20 | 150 | 1 |
551900 | 551900 | 45001 | Abbeville County | SC | 45 | 7/12/20 | 153 | 1 |
555095 | 555095 | 45001 | Abbeville County | SC | 45 | 7/13/20 | 157 | 1 |
558290 | 558290 | 45001 | Abbeville County | SC | 45 | 7/14/20 | 162 | 1 |
561485 | 561485 | 45001 | Abbeville County | SC | 45 | 7/15/20 | 165 | 1 |
564680 | 564680 | 45001 | Abbeville County | SC | 45 | 7/16/20 | 169 | 1 |
567875 | 567875 | 45001 | Abbeville County | SC | 45 | 7/17/20 | 175 | 1 |
571070 | 571070 | 45001 | Abbeville County | SC | 45 | 7/18/20 | 184 | 1 |
574265 | 574265 | 45001 | Abbeville County | SC | 45 | 7/19/20 | 189 | 1 |
577460 | 577460 | 45001 | Abbeville County | SC | 45 | 7/20/20 | 241 | 1 |
580655 | 580655 | 45001 | Abbeville County | SC | 45 | 7/21/20 | 245 | 1 |
583850 | 583850 | 45001 | Abbeville County | SC | 45 | 7/22/20 | 248 | 1 |
587045 | 587045 | 45001 | Abbeville County | SC | 45 | 7/23/20 | 254 | 1 |
590240 | 590240 | 45001 | Abbeville County | SC | 45 | 7/24/20 | 259 | 1 |
593435 | 593435 | 45001 | Abbeville County | SC | 45 | 7/25/20 | 263 | 3 |
596630 | 596630 | 45001 | Abbeville County | SC | 45 | 7/26/20 | 268 | 3 |
599825 | 599825 | 45001 | Abbeville County | SC | 45 | 7/27/20 | 268 | 3 |
603020 | 603020 | 45001 | Abbeville County | SC | 45 | 7/28/20 | 268 | 3 |
606215 | 606215 | 45001 | Abbeville County | SC | 45 | 7/29/20 | 278 | 5 |
609410 | 609410 | 45001 | Abbeville County | SC | 45 | 7/30/20 | 281 | 6 |
612605 | 612605 | 45001 | Abbeville County | SC | 45 | 7/31/20 | 281 | 6 |
615800 | 615800 | 45001 | Abbeville County | SC | 45 | 8/1/20 | 287 | 6 |
618995 | 618995 | 45001 | Abbeville County | SC | 45 | 8/2/20 | 289 | 6 |
622190 | 622190 | 45001 | Abbeville County | SC | 45 | 8/3/20 | 297 | 6 |
625385 | 625385 | 45001 | Abbeville County | SC | 45 | 8/4/20 | 300 | 7 |
628580 | 628580 | 45001 | Abbeville County | SC | 45 | 8/5/20 | 303 | 7 |
631775 | 631775 | 45001 | Abbeville County | SC | 45 | 8/6/20 | 312 | 7 |
634970 | 634970 | 45001 | Abbeville County | SC | 45 | 8/7/20 | 321 | 7 |
638165 | 638165 | 45001 | Abbeville County | SC | 45 | 8/8/20 | 324 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [covid_casesdeaths_reshaped_bln] ( [countyFIPS] INTEGER, [County Name] TEXT, [State] TEXT, [stateFIPS] INTEGER, [date] TEXT, [cases] INTEGER, [deaths] INTEGER );