03-29-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,434 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/29/20 23:08 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/29/20 23:08 30.295064899999996 -92.41419698 9 1 0 0 Acadia, Louisiana, US 2020-05-13T05:15:34+00:00
3 51001.0 Accomack Virginia US 3/29/20 23:08 37.76707161 -75.63234615 3 0 0 0 Accomack, Virginia, US 2020-05-13T05:15:34+00:00
4 16001.0 Ada Idaho US 3/29/20 23:08 43.4526575 -116.24155159999998 92 1 0 0 Ada, Idaho, US 2020-05-13T05:15:34+00:00
5 19001.0 Adair Iowa US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 40.52449420000001 -98.50117804 2 0 0 0 Adams, Nebraska, US 2020-05-13T05:15:34+00:00
16 38001.0 Adams North Dakota US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 46.98299757 -118.56017340000001 5 0 0 0 Adams, Washington, US 2020-05-13T05:15:34+00:00
20 55001.0 Adams Wisconsin US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 29.67866525 -82.35928158 71 0 0 0 Alachua, Florida, US 2020-05-13T05:15:34+00:00
25 37001.0 Alamance North Carolina US 3/29/20 23:08 36.0434701 -79.39976137 6 0 0 0 Alamance, North Carolina, US 2020-05-13T05:15:34+00:00
26 6001.0 Alameda California US 3/29/20 23:08 37.64629437 -121.8929271 270 6 0 0 Alameda, California, US 2020-05-13T05:15:34+00:00
27 8003.0 Alamosa Colorado US 3/29/20 23:08 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/29/20 23:08 42.60060306 -73.97723916 205 1 0 0 Albany, New York, US 2020-05-13T05:15:34+00:00
29 56001.0 Albany Wyoming US 3/29/20 23:08 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/29/20 23:08 38.02080697 -78.55481085 17 0 0 0 Albemarle, Virginia, US 2020-05-13T05:15:34+00:00
31 26001.0 Alcona Michigan US 3/29/20 23:08 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/29/20 23:08 34.88084463 -88.57996173 1 0 0 0 Alcorn, Mississippi, US 2020-05-13T05:15:34+00:00
33 2013.0 Aleutians East Alaska US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 38.814003 -77.08183073 25 0 0 0 Alexandria, Virginia, US 2020-05-13T05:15:34+00:00
38 40003.0 Alfalfa Oklahoma US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 42.25748406 -78.02750466 6 0 0 0 Allegany, New York, US 2020-05-13T05:15:34+00:00
44 37005.0 Alleghany North Carolina US 3/29/20 23:08 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/29/20 23:08 37.78636074 -80.00222498 0 0 0 0 Alleghany, Virginia, US 2020-05-13T05:15:34+00:00
46 42003.0 Allegheny Pennsylvania US 3/29/20 23:08 40.46809875 -79.98167747 265 2 0 0 Allegheny, Pennsylvania, US 2020-05-13T05:15:34+00:00
47 18003.0 Allen Indiana US 3/29/20 23:08 41.09194313 -85.06800636 26 1 0 0 Allen, Indiana, US 2020-05-13T05:15:34+00:00
48 20001.0 Allen Kansas US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 30.65385745 -92.82442028 9 0 0 0 Allen, Louisiana, US 2020-05-13T05:15:34+00:00
51 39003.0 Allen Ohio US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 37.60308293 -79.14548696 2 0 0 0 Amherst, Virginia, US 2020-05-13T05:15:34+00:00
58 28005.0 Amite Mississippi US 3/29/20 23:08 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/29/20 23:08 61.14998174 -149.14269860000002 54 1 0 0 Anchorage,Alaska,US 2020-05-13T05:15:34+00:00
60 20003.0 Anderson Kansas US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 34.51828081 -82.63959517 29 0 0 0 Anderson, South Carolina, US 2020-05-13T05:15:34+00:00
63 47001.0 Anderson Tennessee US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 39.00670238 -76.60329337 99 0 0 0 Anne Arundel, Maryland, US 2020-05-13T05:15:34+00:00
70 27003.0 Anoka Minnesota US 3/29/20 23:08 45.27476015 -93.24604565 17 0 0 0 Anoka, Minnesota, US 2020-05-13T05:15:34+00:00
71 37007.0 Anson North Carolina US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 44.99690221 -85.15503082 0 0 0 0 Antrim, Michigan, US 2020-05-13T05:15:34+00:00
74 4001.0 Apache Arizona US 3/29/20 23:08 35.39465006 -109.4892383 13 0 0 0 Apache, Arizona, US 2020-05-13T05:15:34+00:00
75 19007.0 Appanoose Iowa US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 28.10556197 -96.9995047 0 0 0 0 Aransas, Texas, US 2020-05-13T05:15:34+00:00
79 8005.0 Arapahoe Colorado US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 34.29145151 -91.37277296 0 0 0 0 Arkansas, Arkansas, US 2020-05-13T05:15:34+00:00
84 51013.0 Arlington Virginia US 3/29/20 23:08 38.8767675 -77.10139853 84 2 0 0 Arlington, Virginia, US 2020-05-13T05:15:34+00:00
85 42005.0 Armstrong Pennsylvania US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 30.20406249 -90.91328409999998 139 2 0 0 Ascension, Louisiana, US 2020-05-13T05:15:34+00:00
90 37009.0 Ashe North Carolina US 3/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 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/29/20 23:08 29.89946234 -91.06461642 14 0 0 0 Assumption, Louisiana, US 2020-05-13T05:15:34+00:00
97 48013.0 Atascosa Texas US 3/29/20 23:08 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/29/20 23:08 39.53185661 -95.30870026 0 0 0 0 Atchison, Kansas, US 2020-05-13T05:15:34+00:00
99 29005.0 Atchison Missouri US 3/29/20 23:08 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/29/20 23:08 39.33425634 -82.04278644 3 0 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-29-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 115.474ms · Data source: Big Local News · About: README