Skip to content

Instantly share code, notes, and snippets.

@charrismatic

charrismatic/README.md

Last active March 6, 2020 08:35
Show Gist options
  • Save charrismatic/39095a81da353b90ccaecfb5ea7f233b to your computer and use it in GitHub Desktop.
Save charrismatic/39095a81da353b90ccaecfb5ea7f233b to your computer and use it in GitHub Desktop.
Download ZIP
Coronavirus tracking by search engine trends 2020-03-06
Raw
README.md

"coronavirus" first appeared on the search engine trends on Jan 17, 2020. It seemed to have peaked on Jan 31 and global interest has in decline until Feb. 22, 2020 after reports from new cases in Italy, South Korea, and the Japan Cruise Ship.

7 days later search engine interest in the term is tripled (Feb 22 - 15% to Feb 29 - 77%). The headlines from that day were the Trump press conference, stock market tanking 1200 pts and new cases in United States & Europe, Saudi Arabia suspends entry for pilgrims visiting holy sites.

Search engine interest hits 100% trending on Mar 2.

Nationally the top 5 most concerned metropolitan areas are:

  1. Seattle-Tacoma WA 100%
  2. San Francisco-Oakland-San Jose CA 100%
  3. Honolulu HI 98%
  4. Juneau AK 82%
  5. Lafayette IN 80% (BOILER UP)

5 Year trend analysis of the term 'influenza' shows that in each year interest in the similar term peaks between the last week of Feb through the first week of Mar, which is where we are today. Based on this I predict that we're at peak-virus and over the next month we should be hearing less and less about this and more about spring break and summer diet tips :/

Two weeks from now we can come back and look to see if search engine interest has declined significantly. If it hasn't then we might still be able to learn something new using this data.

Google News Search Feb.22-27: http://bit.ly/2vI6JZl Google Trends Data Dec.6-Mar.6 2020: https://gist.github.com/charrismatic/39095a81da353b90ccaecfb5ea7f233b Google Trends 'Coronavirus': http://bit.ly/2Il8pLb Google Trends 5yr 'influenza' : http://bit.ly/2THoYGh

Raw
interest-by-metro-region.csv
# DMA coronavirus: (12/6/19 - 3/6/20)
Seattle-Tacoma WA 100
San Francisco-Oakland-San Jose CA 100
Honolulu HI 98
Juneau AK 82
Lafayette IN 80
Portland OR 80
San Diego CA 77
Eureka CA 75
Eugene OR 74
Fairbanks AK 74
Anchorage AK 74
Los Angeles CA 74
New York NY 73
Spokane WA 73
Boston MA-Manchester NH 72
Yakima-Pasco-Richland-Kennewick WA 71
Sacramento-Stockton-Modesto CA 70
Monterey-Salinas CA 69
Butte-Bozeman MT 69
Waco-Temple-Bryan TX 68
Charlottesville VA 68
Miami-Ft. Lauderdale FL 67
Las Vegas NV 67
Washington DC (Hagerstown MD) 67
Austin TX 67
Denver CO 66
Bend OR 66
Glendive MT 66
Reno NV 66
Santa Barbara-Santa Maria-San Luis Obispo CA 66
Missoula MT 66
Chico-Redding CA 65
Providence RI-New Bedford MA 65
Boise ID 64
Salt Lake City UT 63
Medford-Klamath Falls OR 63
Madison WI 62
Houston TX 62
Chicago IL 62
West Palm Beach-Ft. Pierce FL 62
Phoenix AZ 61
Tucson (Sierra Vista) AZ 61
Burlington VT-Plattsburgh NY 60
Idaho Falls-Pocatello ID 60
Tampa-St. Petersburg (Sarasota) FL 60
Bangor ME 59
Hartford & New Haven CT 59
Gainesville FL 59
Colorado Springs-Pueblo CO 58
Palm Springs CA 58
Syracuse NY 58
Orlando-Daytona Beach-Melbourne FL 57
Springfield-Holyoke MA 57
Louisville KY 56
Portland-Auburn ME 56
Ft. Myers-Naples FL 56
Twin Falls ID 56
Dallas-Ft. Worth TX 56
Albuquerque-Santa Fe NM 56
Atlanta GA 56
Helena MT 56
Minneapolis-St. Paul MN 56
Albany-Schenectady-Troy NY 55
Rochester MN-Mason City IA-Austin MN 55
Marquette MI 55
Binghamton NY 55
Fresno-Visalia CA 55
Philadelphia PA 55
San Antonio TX 54
Grand Junction-Montrose CO 54
Duluth MN-Superior WI 54
Alpena MI 54
Detroit MI 54
Cheyenne WY-Scottsbluff NE 54
Raleigh-Durham (Fayetteville) NC 53
Ft. Smith-Fayetteville-Springdale-Rogers AR 53
Cedar Rapids-Waterloo-Iowa City & Dubuque IA 53
Buffalo NY 53
Panama City FL 53
Omaha NE 52
El Paso TX 52
Bakersfield CA 52
La Crosse-Eau Claire WI 52
Victoria TX 52
Minot-Bismarck-Dickinson(Williston) ND 52
Harlingen-Weslaco-Brownsville-McAllen TX 52
Rochester NY 52
Kansas City MO 52
Cleveland-Akron (Canton) OH 52
Baltimore MD 52
Champaign & Springfield-Decatur IL 52
Lansing MI 52
Wilmington NC 52
Pittsburgh PA 52
Johnstown-Altoona PA 51
Oklahoma City OK 51
Milwaukee WI 51
Watertown NY 51
Columbia-Jefferson City MO 51
Yuma AZ-El Centro CA 51
Des Moines-Ames IA 51
Billings, MT 51
Tallahassee FL-Thomasville GA 50
Utica NY 50
Ottumwa IA-Kirksville MO 50
Fargo-Valley City ND 50
Jacksonville FL 50
Traverse City-Cadillac MI 50
Harrisonburg VA 50
Columbus OH 50
Odessa-Midland TX 50
Topeka KS 50
Montgomery (Selma) AL 49
Laredo TX 49
Lincoln & Hastings-Kearney NE 49
Richmond-Petersburg VA 49
Indianapolis IN 49
St. Louis MO 49
Great Falls MT 49
Sioux Falls(Mitchell) SD 49
Cincinnati OH 49
North Platte NE 49
Mankato MN 49
Harrisburg-Lancaster-Lebanon-York PA 49
Corpus Christi TX 48
Knoxville TN 48
Casper-Riverton WY 48
Wilkes Barre-Scranton PA 48
Green Bay-Appleton WI 48
Presque Isle ME 48
South Bend-Elkhart IN 48
Chattanooga TN 48
Charleston SC 48
Rapid City SD 48
Wausau-Rhinelander WI 48
Elmira NY 48
Nashville TN 48
Joplin MO-Pittsburg KS 47
Grand Rapids-Kalamazoo-Battle Creek MI 47
Erie PA 47
Sioux City IA 47
San Angelo TX 47
Springfield MO 47
Roanoke-Lynchburg VA 47
Sherman TX-Ada OK 47
Columbus GA 46
Mobile AL-Pensacola (Ft. Walton Beach) FL 46
Wichita-Hutchinson KS 46
Tri-Cities TN-VA 46
Charlotte NC 46
Norfolk-Portsmouth-Newport News VA 46
Greenville-Spartanburg SC-Asheville NC-Anderson SC 46
Peoria-Bloomington IL 46
Dayton OH 46
Tulsa OK 46
Huntsville-Decatur (Florence) AL 45
Birmingham AL 45
Greensboro-High Point-Winston Salem NC 45
Davenport IA-Rock Island-Moline IL 45
Savannah GA 45
Greenville-New Bern-Washington NC 44
Lubbock TX 44
Tyler-Longview(Lufkin & Nacogdoches) TX 44
Ft. Wayne IN 44
Lexington KY 44
Rockford IL 44
Abilene-Sweetwater TX 43
Beaumont-Port Arthur TX 43
Bowling Green KY 43
Little Rock-Pine Bluff AR 43
Flint-Saginaw-Bay City MI 42
St. Joseph MO 42
Youngstown OH 42
Amarillo TX 42
Columbia SC 42
Paducah KY-Cape Girardeau MO-Harrisburg-Mount Vernon IL 42
Clarksburg-Weston WV 42
Toledo OH 41
Augusta GA 41
Bluefield-Beckley-Oak Hill WV 41
Evansville IN 41
Quincy IL-Hannibal MO-Keokuk IA 41
Parkersburg WV 41
Jonesboro AR 41
Wheeling WV-Steubenville OH 41
Wichita Falls TX & Lawton OK 41
New Orleans LA 40
Lake Charles LA 40
Salisbury MD 39
Baton Rouge LA 39
Dothan AL 38
Macon GA 38
Charleston-Huntington WV 37
Florence-Myrtle Beach SC 37
Biloxi-Gulfport MS 37
Zanesville OH 37
Memphis TN 36
Columbus-Tupelo-West Point MS 36
Terre Haute IN 36
Alexandria LA 36
Hattiesburg-Laurel MS 35
Lima OH 35
Shreveport LA 35
Meridian MS 34
Jackson TN 34
Lafayette LA 34
Jackson MS 34
Albany GA 33
Monroe LA-El Dorado AR 31
Greenwood-Greenville MS 23
Raw
interest-over-time.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 2 in line 1.
Category: All categories
Day,coronavirus: (United States)
2019-12-06,<1
2019-12-07,<1
2019-12-08,<1
2019-12-09,<1
2019-12-10,<1
2019-12-11,<1
2019-12-12,<1
2019-12-13,<1
2019-12-14,<1
2019-12-15,<1
2019-12-16,<1
2019-12-17,<1
2019-12-18,<1
2019-12-19,<1
2019-12-20,<1
2019-12-21,<1
2019-12-22,<1
2019-12-23,<1
2019-12-24,<1
2019-12-25,<1
2019-12-26,<1
2019-12-27,<1
2019-12-28,<1
2019-12-29,<1
2019-12-30,<1
2019-12-31,<1
2020-01-01,<1
2020-01-02,<1
2020-01-03,<1
2020-01-04,<1
2020-01-05,<1
2020-01-06,<1
2020-01-07,<1
2020-01-08,<1
2020-01-09,<1
2020-01-10,<1
2020-01-11,<1
2020-01-12,<1
2020-01-13,<1
2020-01-14,<1
2020-01-15,<1
2020-01-16,<1
2020-01-17,<1
2020-01-18,1
2020-01-19,<1
2020-01-20,2
2020-01-21,11
2020-01-22,13
2020-01-23,15
2020-01-24,32
2020-01-25,34
2020-01-26,40
2020-01-27,43
2020-01-28,46
2020-01-29,44
2020-01-30,46
2020-01-31,44
2020-02-01,36
2020-02-02,30
2020-02-03,27
2020-02-04,24
2020-02-05,22
2020-02-06,23
2020-02-07,25
2020-02-08,23
2020-02-09,20
2020-02-10,20
2020-02-11,20
2020-02-12,17
2020-02-13,21
2020-02-14,16
2020-02-15,15
2020-02-16,14
2020-02-17,15
2020-02-18,15
2020-02-19,13
2020-02-20,12
2020-02-21,13
2020-02-22,16
2020-02-23,18
2020-02-24,27
2020-02-25,42
2020-02-26,62
2020-02-27,75
2020-02-28,71
2020-02-29,78
2020-03-01,68
2020-03-02,100
2020-03-03,100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment