03-30-2020

Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily 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: README

3,439 rows

View and edit SQL

Suggested facets: downloaded_by_bln (date)

Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key downloaded_by_bln
1 45001.0 Abbeville South Carolina US 3/30/20 22:52 34.22333378 -82.46170658 3 0 0 0 Abbeville, South Carolina, US 2020-05-13T05:15:34+00:00
2 22001.0 Acadia Louisiana US 3/30/20 22:52 30.295064899999996 -92.41419698 11 1 0 0 Acadia, Louisiana, US 2020-05-13T05:15:34+00:00
3 51001.0 Accomack Virginia US 3/30/20 22:52 37.76707161 -75.63234615 6 0 0 0 Accomack, Virginia, US 2020-05-13T05:15:34+00:00
4 16001.0 Ada Idaho US 3/30/20 22:52 43.4526575 -116.24155159999998 113 2 0 0 Ada, Idaho, US 2020-05-13T05:15:34+00:00
5 19001.0 Adair Iowa US 3/30/20 22:52 41.33075609 -94.47105874 1 0 0 0 Adair, Iowa, US 2020-05-13T05:15:34+00:00
6 21001.0 Adair Kentucky US 3/30/20 22:52 37.10459774 -85.28129668 0 0 0 0 Adair, Kentucky, US 2020-05-13T05:15:34+00:00
7 29001.0 Adair Missouri US 3/30/20 22:52 40.19058551 -92.60078167 1 0 0 0 Adair, Missouri, US 2020-05-13T05:15:34+00:00
8 40001.0 Adair Oklahoma US 3/30/20 22:52 35.88494195 -94.65859267 4 0 0 0 Adair, Oklahoma, US 2020-05-13T05:15:34+00:00
9 8001.0 Adams Colorado US 3/30/20 22:52 39.87432092 -104.3362578 110 0 0 0 Adams, Colorado, US 2020-05-13T05:15:34+00:00
10 16003.0 Adams Idaho US 3/30/20 22:52 44.89333571 -116.4545247 0 0 0 0 Adams, Idaho, US 2020-05-13T05:15:34+00:00
11 17001.0 Adams Illinois US 3/30/20 22:52 39.98815591 -91.18786813 2 0 0 0 Adams, Illinois, US 2020-05-13T05:15:34+00:00
12 18001.0 Adams Indiana US 3/30/20 22:52 40.7457653 -84.93671406 1 0 0 0 Adams, Indiana, US 2020-05-13T05:15:34+00:00
13 19003.0 Adams Iowa US 3/30/20 22:52 41.02903567 -94.69932645 0 0 0 0 Adams, Iowa, US 2020-05-13T05:15:34+00:00
14 28001.0 Adams Mississippi US 3/30/20 22:52 31.47669768 -91.35326037 7 0 0 0 Adams, Mississippi, US 2020-05-13T05:15:34+00:00
15 31001.0 Adams Nebraska US 3/30/20 22:52 40.52449420000001 -98.50117804 3 0 0 0 Adams, Nebraska, US 2020-05-13T05:15:34+00:00
16 38001.0 Adams North Dakota US 3/30/20 22:52 46.09686891 -102.5285397 0 0 0 0 Adams, North Dakota, US 2020-05-13T05:15:34+00:00
17 39001.0 Adams Ohio US 3/30/20 22:52 38.84541072 -83.4718964 0 0 0 0 Adams, Ohio, US 2020-05-13T05:15:34+00:00
18 42001.0 Adams Pennsylvania US 3/30/20 22:52 39.87140411 -77.21610347 8 0 0 0 Adams, Pennsylvania, US 2020-05-13T05:15:34+00:00
19 53001.0 Adams Washington US 3/30/20 22:52 46.98299757 -118.56017340000001 7 0 0 0 Adams, Washington, US 2020-05-13T05:15:34+00:00
20 55001.0 Adams Wisconsin US 3/30/20 22:52 43.96974651 -89.76782777 0 0 0 0 Adams, Wisconsin, US 2020-05-13T05:15:34+00:00
21 50001.0 Addison Vermont US 3/30/20 22:52 44.03217337 -73.14130877 17 0 0 0 Addison, Vermont, US 2020-05-13T05:15:34+00:00
22 45003.0 Aiken South Carolina US 3/30/20 22:52 33.54338026 -81.63645384 9 0 0 0 Aiken, South Carolina, US 2020-05-13T05:15:34+00:00
23 27001.0 Aitkin Minnesota US 3/30/20 22:52 46.60962049 -93.41168259999999 0 0 0 0 Aitkin, Minnesota, US 2020-05-13T05:15:34+00:00
24 12001.0 Alachua Florida US 3/30/20 22:52 29.67866525 -82.35928158 79 0 0 0 Alachua, Florida, US 2020-05-13T05:15:34+00:00
25 37001.0 Alamance North Carolina US 3/30/20 22:52 36.0434701 -79.39976137 7 0 0 0 Alamance, North Carolina, US 2020-05-13T05:15:34+00:00
26 6001.0 Alameda California US 3/30/20 22:52 37.64629437 -121.8929271 283 7 0 0 Alameda, California, US 2020-05-13T05:15:34+00:00
27 8003.0 Alamosa Colorado US 3/30/20 22:52 37.57250606 -105.7885451 1 0 0 0 Alamosa, Colorado, US 2020-05-13T05:15:34+00:00
28 36001.0 Albany New York US 3/30/20 22:52 42.60060306 -73.97723916 217 1 0 0 Albany, New York, US 2020-05-13T05:15:34+00:00
29 56001.0 Albany Wyoming US 3/30/20 22:52 41.65498705 -105.72354150000001 1 0 0 0 Albany, Wyoming, US 2020-05-13T05:15:34+00:00
30 51003.0 Albemarle Virginia US 3/30/20 22:52 38.02080697 -78.55481085 19 0 0 0 Albemarle, Virginia, US 2020-05-13T05:15:34+00:00
31 26001.0 Alcona Michigan US 3/30/20 22:52 44.6846864 -83.59507875 0 0 0 0 Alcona, Michigan, US 2020-05-13T05:15:34+00:00
32 28003.0 Alcorn Mississippi US 3/30/20 22:52 34.88084463 -88.57996173 0 0 0 0 Alcorn, Mississippi, US 2020-05-13T05:15:34+00:00
33 2013.0 Aleutians East Alaska US 3/30/20 22:52 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US 2020-05-13T05:15:34+00:00
34 2016.0 Aleutians West Alaska US 3/30/20 22:52 52.72541116 -110.4086433 0 0 0 0 Aleutians West, Alaska, US 2020-05-13T05:15:34+00:00
35 17003.0 Alexander Illinois US 3/30/20 22:52 37.18049267 -89.32910838 0 0 0 0 Alexander, Illinois, US 2020-05-13T05:15:34+00:00
36 37003.0 Alexander North Carolina US 3/30/20 22:52 35.922379600000006 -81.17751948 1 0 0 0 Alexander, North Carolina, US 2020-05-13T05:15:34+00:00
37 51510.0 Alexandria Virginia US 3/30/20 22:52 38.814003 -77.08183073 26 0 0 0 Alexandria, Virginia, US 2020-05-13T05:15:34+00:00
38 40003.0 Alfalfa Oklahoma US 3/30/20 22:52 36.73090616 -98.32408495 0 0 0 0 Alfalfa, Oklahoma, US 2020-05-13T05:15:34+00:00
39 26003.0 Alger Michigan US 3/30/20 22:52 46.41292944 -86.60260122 0 0 0 0 Alger, Michigan, US 2020-05-13T05:15:34+00:00
40 19005.0 Allamakee Iowa US 3/30/20 22:52 43.28383218 -91.37860922 7 1 0 0 Allamakee, Iowa, US 2020-05-13T05:15:34+00:00
41 26005.0 Allegan Michigan US 3/30/20 22:52 42.59147037 -85.89102866 2 0 0 0 Allegan, Michigan, US 2020-05-13T05:15:34+00:00
42 24001.0 Allegany Maryland US 3/30/20 22:52 39.62357628 -78.69280486 0 0 0 0 Allegany, Maryland, US 2020-05-13T05:15:34+00:00
43 36003.0 Allegany New York US 3/30/20 22:52 42.25748406 -78.02750466 7 0 0 0 Allegany, New York, US 2020-05-13T05:15:34+00:00
44 37005.0 Alleghany North Carolina US 3/30/20 22:52 36.49360862 -81.12857041 2 0 0 0 Alleghany, North Carolina, US 2020-05-13T05:15:34+00:00
45 51005.0 Alleghany Virginia US 3/30/20 22:52 37.78636074 -80.00222498 1 0 0 0 Alleghany, Virginia, US 2020-05-13T05:15:34+00:00
46 42003.0 Allegheny Pennsylvania US 3/30/20 22:52 40.46809875 -79.98167747 290 2 0 0 Allegheny, Pennsylvania, US 2020-05-13T05:15:34+00:00
47 18003.0 Allen Indiana US 3/30/20 22:52 41.09194313 -85.06800636 28 1 0 0 Allen, Indiana, US 2020-05-13T05:15:34+00:00
48 20001.0 Allen Kansas US 3/30/20 22:52 37.88582951 -95.30030847 0 0 0 0 Allen, Kansas, US 2020-05-13T05:15:34+00:00
49 21003.0 Allen Kentucky US 3/30/20 22:52 36.75197631 -86.19457544 1 0 0 0 Allen, Kentucky, US 2020-05-13T05:15:34+00:00
50 22003.0 Allen Louisiana US 3/30/20 22:52 30.65385745 -92.82442028 11 0 0 0 Allen, Louisiana, US 2020-05-13T05:15:34+00:00
51 39003.0 Allen Ohio US 3/30/20 22:52 40.77285242 -84.10802343 4 0 0 0 Allen, Ohio, US 2020-05-13T05:15:34+00:00
52 45005.0 Allendale South Carolina US 3/30/20 22:52 32.98837386 -81.35321066 0 0 0 0 Allendale, South Carolina, US 2020-05-13T05:15:34+00:00
53 26007.0 Alpena Michigan US 3/30/20 22:52 45.03477666 -83.62212411 0 0 0 0 Alpena, Michigan, US 2020-05-13T05:15:34+00:00
54 6003.0 Alpine California US 3/30/20 22:52 38.59678594 -119.82235940000001 0 0 0 0 Alpine, California, US 2020-05-13T05:15:34+00:00
55 6005.0 Amador California US 3/30/20 22:52 38.44583082 -120.65696000000001 2 0 0 0 Amador, California, US 2020-05-13T05:15:34+00:00
56 51007.0 Amelia Virginia US 3/30/20 22:52 37.34081025 -77.98584649 1 0 0 0 Amelia, Virginia, US 2020-05-13T05:15:34+00:00
57 51009.0 Amherst Virginia US 3/30/20 22:52 37.60308293 -79.14548696 3 0 0 0 Amherst, Virginia, US 2020-05-13T05:15:34+00:00
58 28005.0 Amite Mississippi US 3/30/20 22:52 31.17467303 -90.80501621 4 0 0 0 Amite, Mississippi, US 2020-05-13T05:15:34+00:00
59 2020.0 Anchorage Alaska US 3/30/20 22:52 61.14998174 -149.14269860000002 59 1 0 0 Anchorage,Alaska,US 2020-05-13T05:15:34+00:00
60 20003.0 Anderson Kansas US 3/30/20 22:52 38.21413251 -95.29272815 0 0 0 0 Anderson, Kansas, US 2020-05-13T05:15:34+00:00
61 21005.0 Anderson Kentucky US 3/30/20 22:52 38.00671029 -84.99171713 2 1 0 0 Anderson, Kentucky, US 2020-05-13T05:15:34+00:00
62 45007.0 Anderson South Carolina US 3/30/20 22:52 34.51828081 -82.63959517 31 1 0 0 Anderson, South Carolina, US 2020-05-13T05:15:34+00:00
63 47001.0 Anderson Tennessee US 3/30/20 22:52 36.12684348 -84.19965764 6 0 0 0 Anderson, Tennessee, US 2020-05-13T05:15:34+00:00
64 48001.0 Anderson Texas US 3/30/20 22:52 31.81534745 -95.65354823 0 0 0 0 Anderson, Texas, US 2020-05-13T05:15:34+00:00
65 29003.0 Andrew Missouri US 3/30/20 22:52 39.98492163 -94.80163024 0 0 0 0 Andrew, Missouri, US 2020-05-13T05:15:34+00:00
66 48003.0 Andrews Texas US 3/30/20 22:52 32.30468633 -102.63765479999999 0 0 0 0 Andrews, Texas, US 2020-05-13T05:15:34+00:00
67 23001.0 Androscoggin Maine US 3/30/20 22:52 44.1664747 -70.20380627 8 0 0 0 Androscoggin, Maine, US 2020-05-13T05:15:34+00:00
68 48005.0 Angelina Texas US 3/30/20 22:52 31.25457347 -94.60901487 3 0 0 0 Angelina, Texas, US 2020-05-13T05:15:34+00:00
69 24003.0 Anne Arundel Maryland US 3/30/20 22:52 39.00670238 -76.60329337 110 0 0 0 Anne Arundel, Maryland, US 2020-05-13T05:15:34+00:00
70 27003.0 Anoka Minnesota US 3/30/20 22:52 45.27476015 -93.24604565 22 0 0 0 Anoka, Minnesota, US 2020-05-13T05:15:34+00:00
71 37007.0 Anson North Carolina US 3/30/20 22:52 34.97403241 -80.09953279 0 0 0 0 Anson, North Carolina, US 2020-05-13T05:15:34+00:00
72 31003.0 Antelope Nebraska US 3/30/20 22:52 42.17695516 -98.06662829999999 0 0 0 0 Antelope, Nebraska, US 2020-05-13T05:15:34+00:00
73 26009.0 Antrim Michigan US 3/30/20 22:52 44.99690221 -85.15503082 2 0 0 0 Antrim, Michigan, US 2020-05-13T05:15:34+00:00
74 4001.0 Apache Arizona US 3/30/20 22:52 35.39465006 -109.4892383 17 0 0 0 Apache, Arizona, US 2020-05-13T05:15:34+00:00
75 19007.0 Appanoose Iowa US 3/30/20 22:52 40.74324454 -92.86865906 1 0 0 0 Appanoose, Iowa, US 2020-05-13T05:15:34+00:00
76 13001.0 Appling Georgia US 3/30/20 22:52 31.74847232 -82.28909114 0 0 0 0 Appling, Georgia, US 2020-05-13T05:15:34+00:00
77 51011.0 Appomattox Virginia US 3/30/20 22:52 37.37569884 -78.81340003 0 0 0 0 Appomattox, Virginia, US 2020-05-13T05:15:34+00:00
78 48007.0 Aransas Texas US 3/30/20 22:52 28.10556197 -96.9995047 2 0 0 0 Aransas, Texas, US 2020-05-13T05:15:34+00:00
79 8005.0 Arapahoe Colorado US 3/30/20 22:52 39.64977461 -104.3353617 241 3 0 0 Arapahoe, Colorado, US 2020-05-13T05:15:34+00:00
80 48009.0 Archer Texas US 3/30/20 22:52 33.61569967 -98.68754589 0 0 0 0 Archer, Texas, US 2020-05-13T05:15:34+00:00
81 8007.0 Archuleta Colorado US 3/30/20 22:52 37.19474156 -107.04768670000001 0 0 0 0 Archuleta, Colorado, US 2020-05-13T05:15:34+00:00
82 26011.0 Arenac Michigan US 3/30/20 22:52 44.0636262 -83.89277559 0 0 0 0 Arenac, Michigan, US 2020-05-13T05:15:34+00:00
83 5001.0 Arkansas Arkansas US 3/30/20 22:52 34.29145151 -91.37277296 1 0 0 0 Arkansas, Arkansas, US 2020-05-13T05:15:34+00:00
84 51013.0 Arlington Virginia US 3/30/20 22:52 38.8767675 -77.10139853 86 2 0 0 Arlington, Virginia, US 2020-05-13T05:15:34+00:00
85 42005.0 Armstrong Pennsylvania US 3/30/20 22:52 40.81665618 -79.46290811 3 0 0 0 Armstrong, Pennsylvania, US 2020-05-13T05:15:34+00:00
86 48011.0 Armstrong Texas US 3/30/20 22:52 34.96507426 -101.35748740000001 0 0 0 0 Armstrong, Texas, US 2020-05-13T05:15:34+00:00
87 23003.0 Aroostook Maine US 3/30/20 22:52 46.65926321 -68.59841248 0 0 0 0 Aroostook, Maine, US 2020-05-13T05:15:34+00:00
88 31005.0 Arthur Nebraska US 3/30/20 22:52 41.56896142 -101.6959559 0 0 0 0 Arthur, Nebraska, US 2020-05-13T05:15:34+00:00
89 22005.0 Ascension Louisiana US 3/30/20 22:52 30.20406249 -90.91328409999998 153 5 0 0 Ascension, Louisiana, US 2020-05-13T05:15:34+00:00
90 37009.0 Ashe North Carolina US 3/30/20 22:52 36.43296207 -81.49862729 0 0 0 0 Ashe, North Carolina, US 2020-05-13T05:15:34+00:00
91 39005.0 Ashland Ohio US 3/30/20 22:52 40.84772277 -82.27280781 2 0 0 0 Ashland, Ohio, US 2020-05-13T05:15:34+00:00
92 55003.0 Ashland Wisconsin US 3/30/20 22:52 46.31956891 -90.67837132 0 0 0 0 Ashland, Wisconsin, US 2020-05-13T05:15:34+00:00
93 5003.0 Ashley Arkansas US 3/30/20 22:52 33.19153461 -91.76984709999999 1 0 0 0 Ashley, Arkansas, US 2020-05-13T05:15:34+00:00
94 39007.0 Ashtabula Ohio US 3/30/20 22:52 41.70860332 -80.74830218 6 0 0 0 Ashtabula, Ohio, US 2020-05-13T05:15:34+00:00
95 53003.0 Asotin Washington US 3/30/20 22:52 46.18894415 -117.2022851 0 0 0 0 Asotin, Washington, US 2020-05-13T05:15:34+00:00
96 22007.0 Assumption Louisiana US 3/30/20 22:52 29.89946234 -91.06461642 17 0 0 0 Assumption, Louisiana, US 2020-05-13T05:15:34+00:00
97 48013.0 Atascosa Texas US 3/30/20 22:52 28.89333001 -98.52730485 2 0 0 0 Atascosa, Texas, US 2020-05-13T05:15:34+00:00
98 20005.0 Atchison Kansas US 3/30/20 22:52 39.53185661 -95.30870026 1 0 0 0 Atchison, Kansas, US 2020-05-13T05:15:34+00:00
99 29005.0 Atchison Missouri US 3/30/20 22:52 40.43238737 -95.42970639 1 0 0 0 Atchison, Missouri, US 2020-05-13T05:15:34+00:00
100 39009.0 Athens Ohio US 3/30/20 22:52 39.33425634 -82.04278644 3 1 0 0 Athens, Ohio, US 2020-05-13T05:15:34+00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [03-30-2020] (
   [FIPS] TEXT,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] TEXT,
   [Long_] TEXT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT,
   [downloaded_by_bln] TEXT
);
Powered by Datasette · Query took 101.17ms · Data source: Big Local News · About: README