Errata

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: big-local-datasette

1,060 rows sorted by File

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid Update Date File ▼ Location Field Updated Old New Comments
344 344 7/15/2020 time_series_covid19_confirmed_US.csv Douglas, MO 5/30/2020-6/11/2020     Update via Douglas County Health Department data
349 349 7/16/2020 time_series_covid19_confirmed_US.csv Dallas, TX 4/21;4/27;4/29;5/12;5/20;5/30;6/28;7/10;7/15/2020     Update from Dallas County reporting
358 358 7/21/2020 time_series_covid19_confirmed_US.csv Philadelphia, PA 7/20/2020     Update from Philadelphia DOH
373 373 7/23/2020 time_series_covid19_confirmed_US.csv Unassigned, Oklahoma 7/22/2020 821 0 OK data correction
378 378 7/24/2020 time_series_covid19_confirmed_US.csv Lancaster, Pennsylvania 7/22-7/23/2020     PA data correction
385 385 7/26/2020 time_series_covid19_confirmed_US.csv Oregon 7/25/2020     Update from OR Health Authority
389 389 7/26/2020 time_series_covid19_confirmed_US.csv Idaho 7/25/2020     Update from ID DOH
397 397 7/28/2020 time_series_covid19_confirmed_US.csv District of Columbia 7/27/2020     Update DC from DC gov
406 406 7/29/2020 time_series_covid19_confirmed_US.csv Georgia 7/28/2020     Update from GDPH
416 416 7/31/2020 time_series_covid19_confirmed_US.csv Massachusetts 7/30/2020     Update from MA
432 432 8/4/2020 time_series_covid19_confirmed_US.csv Georgia 7/31-8/2/2020     Update from DC
466 466 8/13/2020 time_series_covid19_confirmed_US.csv Unassigned,Massachusetts 8/12/2020     Update from MA Dashboard & Weekly
472 472 8/15/2020 time_series_covid19_confirmed_US.csv Unassigned,Massachusetts 8/13-8/14/2020     Update from MA Dashboard Raw Data
508 508 9/25/2020 time_series_covid19_confirmed_US.csv Wisconsin 09/15/2020, 09/16/2020, 09/17/2020      
526 526 10/19/2020 time_series_covid19_confirmed_US.csv Alaska       Changed name from Lake and Peninsula to Bristol Bay plus Lake and Peninsula
541 541 10/27/2020 time_series_covid19_confirmed_US.csv Alaska 3/13-10/26/2020     Add Alaska non-resident cases adjusted by the collection date
574 574 11/09/2020 time_series_covid19_confirmed_US.csv Puerto Rico 3/16/2020 - 11/8/2020     Revised Municipal reporting based on new updates from PR DS
576 576 11/10/2020 time_series_covid19_confirmed_US.csv Hawaii 9/11/2020 - 11/9/2020     Revised reporting based on probable cases
578 578 11/10/2020 time_series_covid19_confirmed_US.csv Louisiana 8/26/2020 - 11/9/2020     Revised reporting based on probable cases
597 597 11/24/2020 time_series_covid19_confirmed_US.csv Bexar, Texas 11/23/2020 73882 74591 Daily update from county source
598 598 11/24/2020 time_series_covid19_confirmed_US.csv Dallas, Texas 11/23/2020 130186 130727 Daily update from county source
599 599 11/24/2020 time_series_covid19_confirmed_US.csv Galveston, Texas 11/23/2020 14126 14259 Daily update from county source
600 600 11/24/2020 time_series_covid19_confirmed_US.csv Midland, Texas 11/23/2020 6576 7027 Daily update from county source
601 601 11/24/2020 time_series_covid19_confirmed_US.csv Nueces, Texas 11/23/2020 23268 23388 Daily update from county source
602 602 11/24/2020 time_series_covid19_confirmed_US.csv Travis, Texas 11/23/2020 36436 36754 Daily update from county source
612 612 12/04/2020 time_series_covid19_confirmed_US.csv Alaska, US 12/02/2020-12/01/2020     Update based on AK total cases
631 631 12/18/2020 time_series_covid19_confirmed_US.csv Washington, US 12/17/2020     Update based on Washington source
638 638 12/26/2020 time_series_covid19_confirmed_US.csv Arizona, US 12/24/2020     Update from Arizona state dashboard
646 646 12/30/2020 time_series_covid19_confirmed_US.csv Maine, US 12/29/2020     Correct based on ME Dashboard
649 649 12/31/2020 time_series_covid19_confirmed_US.csv North Dakota, US 12/30/2020     Correct based on ND Dashboard
653 653 01/10/2021 time_series_covid19_confirmed_US.csv Texas, US 01/08/2021     Correct based on TX Dashboard
894 894 01/20/2021 time_series_covid19_confirmed_US.csv Baker, Oregon, US 01/19/2021 568 573 Correct stale confirmed data
895 895 01/20/2021 time_series_covid19_confirmed_US.csv Benton, Oregon, US 01/19/2021 1705 1720 Correct stale confirmed data
896 896 01/20/2021 time_series_covid19_confirmed_US.csv Clackamas, Oregon, US 01/19/2021 11698 11760 Correct stale confirmed data
897 897 01/20/2021 time_series_covid19_confirmed_US.csv Clatsop, Oregon, US 01/19/2021 686 687 Correct stale confirmed data
898 898 01/20/2021 time_series_covid19_confirmed_US.csv Columbia, Oregon, US 01/19/2021 1049 1054 Correct stale confirmed data
899 899 01/20/2021 time_series_covid19_confirmed_US.csv Coos, Oregon, US 01/19/2021 938 941 Correct stale confirmed data
900 900 01/20/2021 time_series_covid19_confirmed_US.csv Crook, Oregon, US 01/19/2021 621 623 Correct stale confirmed data
901 901 01/20/2021 time_series_covid19_confirmed_US.csv Deschutes, Oregon, US 01/19/2021 4999 5036 Correct stale confirmed data
902 902 01/20/2021 time_series_covid19_confirmed_US.csv Douglas, Oregon, US 01/19/2021 1687 1692 Correct stale confirmed data
903 903 01/20/2021 time_series_covid19_confirmed_US.csv Hood River, Oregon, US 01/19/2021 954 955 Correct stale confirmed data
904 904 01/20/2021 time_series_covid19_confirmed_US.csv Jackson, Oregon, US 01/19/2021 6930 6970 Correct stale confirmed data
905 905 01/20/2021 time_series_covid19_confirmed_US.csv Jefferson, Oregon, US 01/19/2021 1705 1707 Correct stale confirmed data
906 906 01/20/2021 time_series_covid19_confirmed_US.csv Josephine, Oregon, US 01/19/2021 1743 1770 Correct stale confirmed data
907 907 01/20/2021 time_series_covid19_confirmed_US.csv Klamath, Oregon, US 01/19/2021 2428 2453 Correct stale confirmed data
908 908 01/20/2021 time_series_covid19_confirmed_US.csv Lake, Oregon, US 01/19/2021 230 232 Correct stale confirmed data
909 909 01/20/2021 time_series_covid19_confirmed_US.csv Lane, Oregon, US 01/19/2021 8353 8418 Correct stale confirmed data
910 910 01/20/2021 time_series_covid19_confirmed_US.csv Lincoln, Oregon, US 01/19/2021 996 1001 Correct stale confirmed data
911 911 01/20/2021 time_series_covid19_confirmed_US.csv Linn, Oregon, US 01/19/2021 3116 3123 Correct stale confirmed data
912 912 01/20/2021 time_series_covid19_confirmed_US.csv Marion, Oregon, US 01/19/2021 16247 16312 Correct stale confirmed data
913 913 01/20/2021 time_series_covid19_confirmed_US.csv Morrow, Oregon, US 01/19/2021 938 942 Correct stale confirmed data
914 914 01/20/2021 time_series_covid19_confirmed_US.csv Multnomah, Oregon, US 01/19/2021 28467 28586 Correct stale confirmed data
915 915 01/20/2021 time_series_covid19_confirmed_US.csv Polk, Oregon, US 01/19/2021 2455 2469 Correct stale confirmed data
916 916 01/20/2021 time_series_covid19_confirmed_US.csv Tillamook, Oregon, US 01/19/2021 365 367 Correct stale confirmed data
917 917 01/20/2021 time_series_covid19_confirmed_US.csv Umatilla, Oregon, US 01/19/2021 6793 6803 Correct stale confirmed data
918 918 01/20/2021 time_series_covid19_confirmed_US.csv Union, Oregon, US 01/19/2021 1114 1118 Correct stale confirmed data
919 919 01/20/2021 time_series_covid19_confirmed_US.csv Wasco, Oregon, US 01/19/2021 1081 1085 Correct stale confirmed data
920 920 01/20/2021 time_series_covid19_confirmed_US.csv Washington, Oregon, US 01/19/2021 18734 18808 Correct stale confirmed data
921 921 01/20/2021 time_series_covid19_confirmed_US.csv Yamhill, Oregon, US 01/19/2021 3190 3202 Correct stale confirmed data
922 922 01/20/2021 time_series_covid19_confirmed_US.csv Adams, Washington, US 01/19/2021 1719 1721 Correct stale confirmed data
923 923 01/20/2021 time_series_covid19_confirmed_US.csv Asotin, Washington, US 01/19/2021 1143 1147 Correct stale confirmed data
924 924 01/20/2021 time_series_covid19_confirmed_US.csv Benton, Washington, US 01/19/2021 13465 13529 Correct stale confirmed data
925 925 01/20/2021 time_series_covid19_confirmed_US.csv Chelan, Washington, US 01/19/2021 5433 5467 Correct stale confirmed data
926 926 01/20/2021 time_series_covid19_confirmed_US.csv Clallam, Washington, US 01/19/2021 832 840 Correct stale confirmed data
927 927 01/20/2021 time_series_covid19_confirmed_US.csv Clark, Washington, US 01/19/2021 16125 16300 Correct stale confirmed data
928 928 01/20/2021 time_series_covid19_confirmed_US.csv Cowlitz, Washington, US 01/19/2021 3164 3203 Correct stale confirmed data
929 929 01/20/2021 time_series_covid19_confirmed_US.csv Douglas, Washington, US 01/19/2021 2893 2916 Correct stale confirmed data
930 930 01/20/2021 time_series_covid19_confirmed_US.csv Franklin, Washington, US 01/19/2021 9711 9753 Correct stale confirmed data
931 931 01/20/2021 time_series_covid19_confirmed_US.csv Grant, Washington, US 01/19/2021 6724 6773 Correct stale confirmed data
932 932 01/20/2021 time_series_covid19_confirmed_US.csv Grays Harbor, Washington, US 01/19/2021 2709 2737 Correct stale confirmed data
933 933 01/20/2021 time_series_covid19_confirmed_US.csv Island, Washington, US 01/19/2021 1087 1095 Correct stale confirmed data
934 934 01/20/2021 time_series_covid19_confirmed_US.csv King, Washington, US 01/19/2021 73015 73667 Correct stale confirmed data
935 935 01/20/2021 time_series_covid19_confirmed_US.csv Kitsap, Washington, US 01/19/2021 4701 4748 Correct stale confirmed data
936 936 01/20/2021 time_series_covid19_confirmed_US.csv Kittitas, Washington, US 01/19/2021 1953 1976 Correct stale confirmed data
937 937 01/20/2021 time_series_covid19_confirmed_US.csv Lewis, Washington, US 01/19/2021 2978 2996 Correct stale confirmed data
938 938 01/20/2021 time_series_covid19_confirmed_US.csv Lincoln, Washington, US 01/19/2021 294 293 Correct stale confirmed data
939 939 01/20/2021 time_series_covid19_confirmed_US.csv Mason, Washington, US 01/19/2021 1950 1969 Correct stale confirmed data
940 940 01/20/2021 time_series_covid19_confirmed_US.csv Okanogan, Washington, US 01/19/2021 1938 1939 Correct stale confirmed data
941 941 01/20/2021 time_series_covid19_confirmed_US.csv Pacific, Washington, US 01/19/2021 599 604 Correct stale confirmed data
942 942 01/20/2021 time_series_covid19_confirmed_US.csv Pend Oreille, Washington, US 01/19/2021 526 527 Correct stale confirmed data
943 943 01/20/2021 time_series_covid19_confirmed_US.csv Pierce, Washington, US 01/19/2021 30912 31164 Correct stale confirmed data
944 944 01/20/2021 time_series_covid19_confirmed_US.csv San Juan, Washington, US 01/19/2021 90 89 Correct stale confirmed data
945 945 01/20/2021 time_series_covid19_confirmed_US.csv Skagit, Washington, US 01/19/2021 3801 3812 Correct stale confirmed data
946 946 01/20/2021 time_series_covid19_confirmed_US.csv Skamania, Washington, US 01/19/2021 223 229 Correct stale confirmed data
947 947 01/20/2021 time_series_covid19_confirmed_US.csv Snohomish, Washington, US 01/19/2021 26267 26363 Correct stale confirmed data
948 948 01/20/2021 time_series_covid19_confirmed_US.csv Spokane, Washington, US 01/19/2021 30756 31031 Correct stale confirmed data
949 949 01/20/2021 time_series_covid19_confirmed_US.csv Stevens, Washington, US 01/19/2021 1364 1358 Correct stale confirmed data
950 950 01/20/2021 time_series_covid19_confirmed_US.csv Thurston, Washington, US 01/19/2021 5760 5805 Correct stale confirmed data
951 951 01/20/2021 time_series_covid19_confirmed_US.csv Unassigned, Washington, US 01/19/2021 1549 1459 Correct stale confirmed data
952 952 01/20/2021 time_series_covid19_confirmed_US.csv Wahkiakum, Washington, US 01/19/2021 62 63 Correct stale confirmed data
953 953 01/20/2021 time_series_covid19_confirmed_US.csv Walla Walla, Washington, US 01/19/2021 4102 4126 Correct stale confirmed data
954 954 01/20/2021 time_series_covid19_confirmed_US.csv Whatcom, Washington, US 01/19/2021 4885 4894 Correct stale confirmed data
955 955 01/20/2021 time_series_covid19_confirmed_US.csv Whitman, Washington, US 01/19/2021 2989 3019 Correct stale confirmed data
956 956 01/20/2021 time_series_covid19_confirmed_US.csv Yakima, Washington, US 01/19/2021 22988 23145 Correct stale confirmed data
1005 1005 02/16/2021 time_series_covid19_confirmed_US.csv Beadle, South Dakota, US 02/15/2021 2654 2655 Correct stale confirmed data
1006 1006 02/16/2021 time_series_covid19_confirmed_US.csv Brown, South Dakota, US 02/15/2021 5062 5066 Correct stale confirmed data
1007 1007 02/16/2021 time_series_covid19_confirmed_US.csv Charles Mix, South Dakota, US 02/15/2021 1248 1251 Correct stale confirmed data
1008 1008 02/16/2021 time_series_covid19_confirmed_US.csv Clay, South Dakota, US 02/15/2021 1773 1774 Correct stale confirmed data
1009 1009 02/16/2021 time_series_covid19_confirmed_US.csv Codington, South Dakota, US 02/15/2021 3872 3878 Correct stale confirmed data
1010 1010 02/16/2021 time_series_covid19_confirmed_US.csv Day, South Dakota, US 02/15/2021 640 641 Correct stale confirmed data

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [Errata] (
   [Update Date] TEXT,
   [File] TEXT,
   [Location] TEXT,
   [Field Updated] TEXT,
   [Old] INTEGER,
   [New] INTEGER,
   [Comments] TEXT
);