Flourish Skills Assessment

Getting Started

  1. Open Flourish.studio* and set up a free account.
  2. Look at the examples at the bottom of this handout, then complete a couple of the exercises listed below. You will need to complete 2 exercises** for your Skills Assessment.

*Note: Canva bought Flourish in February 2022 but Google still uses/trains on the tool

**Your Skills Assessments must be two different types of visualizations. One from Options A-G and one from Options H-M

Additional Resources:

A Google News Initiative tools training module on Flourish: https://newsinitiative.withgoogle.com/training/lessons?tool=Flourish&image=flourish

Want to code? Check out the Flourish for Developers blog: https://flourish.studio/developers/

** Help and questions: newsrooms@flourish.studio

Pop-up panels new in Feb 2021: https://flourish.studio/2021/03/04/popup-panels/

** Connecting a live-CSV feature, where it pulls through the data from a publicly available CSV file living on the internet. https://flourish.studio/2020/07/21/live-data/

Training slides from Google: https://flo.uri.sh/visualisation/5404761/embed

OPTION A: Weather: Annual Snowfall Chart

You’re going to recreate this annual snowfall chart for New York, Boston, Chicago and Minneapolis. You can do this with your own city/region data by researching the NOAA site.
https://public.flourish.studio/visualisation/1127745/

1. Download this Excel spreadsheet to your desktop and look over the data: http://bit.ly/flourishsnow

full link: https://drive.google.com/file/d/1hWUZr0uDkytmwWcZL04BmF015_ZnJmUb/view?usp=sharing

2.In Flourish, click on the red “NEW” button.

3.Select the line chart in the first group of graphic options.

4.Make sure you select the “DATA” tab at the top of the interface.

5.Hit the “Import Data” button in the upper right, select the City Snowfalls spreadsheet. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.

6. Make sure all of the columns are highlighted in pink or purple.

7. Click on the Preview tab to see what the chart looks like.

8. In the right column, select the HEADER menu and for Title: type/paste in: Total Annual Snowfall

9. For the Text on the HEADER menu, type/paste in: Annual snowfall (in inches), in Boston, Chicago, New York and Minneapolis

10. Now go down to the FOOTER menu on the right side of the toolbar. Under source name, paste this: NOAA   For the source link, paste this in: https://www.noaa.gov/

11. In the Notes section of the photo, add Graphic: YOUR NAME

12. Hit the Export and Publish button in the upper right and follow the directions.

  • You also can add a second graphic with a searchable table by loading the same spreadsheet into the Table (default) template on Flourish: 

*Note – that if you have a large dataset, you can select the Tables/Searchable Database option and you can embed a database into your post.


——————

Option B: Chicago COVID-19 Cases by Ethnicity Line Chart

We’re going to create a line chart showing ethnic breakdown of positive COVID-19 cases in Chicago. Here’s what the chart will look like when finished:
https://public.flourish.studio/visualisation/3266486/

1. Download this Excel spreadsheet to your desktop and look over the data:

Full link: FLOURISH DATA – Google Drive

https://drive.google.com/drive/folders/1j1V1qJaxv3wExec-t4WG1U8Ln51QML8Q

2.In Flourish, click on the red “NEW” button.

3.Select the line chart in the first group of graphic options.

4.Make sure you select the “DATA” tab at the top of the interface.

5.Hit the “Import Data” button in the upper right, select the illcasesbyrace.csv sheet. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.

6. Make sure all of the columns are highlighted in pink or purple. (For instance, it should read B-G in the Categories column rather than default B-G)

7. Click on the Preview tab to see what the chart looks like

8. In the right column, select the HEADER menu and for Title: type/paste in: Chicago COVID-19 Cases by Ethnicity

9. For the Subtitle on the HEADER menu, type/paste in: March 6 through June 6, 2020

10. In the Text field on the HEADER menu, type/paste in: Chicago’s Latino community was hardest hit by COVID-19. Note that  several positive cases had no ethnicity marked in records.

OPTIONAL: You can change the title color and center everything by turning on the “Change Title Styles” button, select a color and hit the three-line center button at the top.

11.Now go down to the FOOTER menu on the right side of the toolbar. Under source name, paste this: Chicago Department of Public Health   For the source link, paste this in: https://data.cityofchicago.org/Health-Human-Services/COVID-19-Daily-Cases-and-Deaths/naz8-j4nc

12. In the Notes section of the photo, add Graphic: YOUR NAME

13. Hit the Export and Publish button in the upper right and follow the directions.

  • You also can add a second graphic with a searchable table by loading the same spreadsheet into the Table (default) template on Flourish: 

Note: that if you have a large dataset, you can select the Tables/Searchable Database option and you can embed a database into your post.

——————

OPTION C: Chicago Homicides by Year Column Chart

1.Download the data from this folder: http://bit.ly/chihomicide
It’s labeled 1chihomicidesbyyear1990-2021.csv on the far left

2. Open the Column Chart template, hit the upload button in the upper right and upload the data. Click back on the preview tab to see what your data looks like. Note: The horizontal bar chart and line chart templates will work for this as well. 

3. In the upper left corner, type this into the Untitled Visualization field: Chicago Homicides by Year (1990-2021)

4. In the preview mode, click on the Header menu on the right side of the interface. 

5. Place this text in the Title field: Chicago Homicides by Year (1990-2021)

6. Place this text in the Text field: Chicago ended 2021 with 797 homicides, the most since 1996. It was 23 more than recorded in 2020 and 291 more than 2019. Chicago had 3,561 shooting incidents in 2021, just over 300 more than were recorded in 2020 and 1,415 more than in 2019.

7. Go to the Footer menu on the right side of the page. In the Source: field type: Chicago Police Department. In the Source Link: field paste this link: https://data.cityofchicago.org/browse?category=Public%20Safety

8. In the notes section underneath the Source fields, add your credit: Graphic/Your Name.

9. Hit the Export and Publish button in the upper right and follow the directions to embed.

  • You also can add a second graphic with a searchable table by loading the same spreadsheet into the Table (default) template on Flourish.

——————

OPTION D: COVID-19 vs. US Daily Average Cause of Death Bar Chart Race

1.Download the data here: http://bit.ly/covidcauses

2. Open the Bar Chart Race template in Flourish, click on the data tab and then on the black button to load the spreadsheet. Then click on the preview tab to see your chart, which will need some adjustments in the following steps …

3. In the preview mode, click on the Header menu on the right and enter the header menu text:

Title: COVID-19 vs. US Daily Average Cause of Death

Subhead: U.S. rates are compared to daily number of confirmed U.S. deaths from COVID-19

Text: Averages were determined over a one-year period from totals causes of death per category from 2018 CDC data, the most current available. COVID-19 daily total deaths were tracked from Johns Hopkins data.

4. Next: enter the footer text by clicking on the Footer menu and entering:

         Source: Centers for Disease Control Death and Mortality Rates

Link: https://www.cdc.gov/nchs/fastats/deaths.htm

5.Under the “Bars” menu, change the number of bars to 16.

6.Then go to the Labels menu and set the “Max Font Size” to 0.5 so the Y-axis labels fit

7.Go to the Timeline & Animation menu and scroll down to the “Time spent before looping” window and increase it to 7.1 seconds.

8.Under the Timeline & Animation menu, change the “Bar Rank Animation Duration” window to 2.05 seconds.

9.Under the Time Counter & Totalizer menu, adjust the Time Counter size to 7 and the Total to 3

10. Then publish your chart on the black button in the upper right corner of the interface.

——————

OPTION E: Dems Facebook Ad Spending 2020 Primary

We’re going to recreate this horizontal bar chart 

1. Download this Excel spreadsheet to your desktop and look over the data: https://drive.google.com/drive/folders/0B4AbFFVbzuMDbVlNNnhNMFJQaXM

2.In Flourish, click on the red “NEW” button.

3.Select the horizontal bar chart in the first group of graphic options.

4.Make sure you select the “DATA” tab at the top of the interface.

5.Hit the “Import Data” button in the upper right, select the demfacebookadbuy.csv spreadsheet. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.

6. Make sure all of the columns are highlighted in pink or purple.

7. Click on the Preview tab to see what the chart looks like

8. In the right column, select the HEADER menu and for Title: type/paste in: Facebook Ad Spending: Democratic Primary 

9. For the Subtitle on the HEADER menu, type/paste in: Nov. 19, 2019 to  Feb. 10, 2020

10.Now go down to the FOOTER menu on the right side of the toolbar. Under source name, paste this: Facebook Ad Library Report 

For the source link, paste this in: https://www.facebook.com/ads/library/report/

11. In the Notes section of the photo, add Graphic: YOUR NAME

12. Hit the Export and Publish button in the upper right and follow the directions.

  • You also can add a second graphic with a searchable table by loading the same spreadsheet into the Table (default) template on Flourish:  

Note: that if you have a large dataset, you can select the Tables/Searchable Database template and you can embed a database into your post.

———-

OPTION F: Democratic Presidential candidates searched in Google Trends Search 

  1. Download this Democratic Primary candidates search dataset that is pulled from the Google Trends Data Store: http://bit.ly/trenddems
  2. Note we have a column with a link to photos of each of the candidate (A) and name (B), then the weekly search results.
  3. Open flourish.studio and under visualizations, click on the red “new” button.
  4. Go to the Line Chart Race section and select the “simple” template. 
  5.  Make sure you select the “Data” tab at the top of the interface.
  6. Hit the “Import Data” button in the upper right, select the Democratic Candidates spreadsheet that you downloaded. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.
  7. On the column on the right, type in B in the name column and hit return
  8. In the image column, type in A and hit return
  9. In the column to the right, in the Values field, type in C-BJ and hit return. (It highlights the columns you want to highlight in the chart.)
  10.   Hit the preview button to see how your chart looks so far
  11.   In the right column, select the HEADER menu and for Title: Google Search: Democratic Primary Candidates
  12. For subtitle, type in December 2018-February 2020
  13.  Click on the FOOTER menu and in the source field add: Google Trends Data Store
  14.  In the link field, add: https://googletrends.github.io/data/
  15.  Then hit the publish button in the upper right and it will guide you through the publishing process.

—————–

Option G: Top tech company 2019 employment by gender (column chart)

1. Open the Top Tech Company Gender data file in this folder and download it to your desktop:

https://drive.google.com/drive/folders/0B4AbFFVbzuMDbVlNNnhNMFJQaXM

2.In Flourish, click on the red “NEW” button.

3.Select the Column chart in the first group of graphic options.

4.Make sure you select the “DATA” tab at the top of the interface.

5.Hit the “Import Data” button in the upper right, select the spreadsheet you downloaded. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.

6. Make sure all of the columns are highlighted in pink or purple.

7. Click on the Preview tab to see what the chart looks like

8. In the right column, select the HEADER menu and for Title: type/paste in: Gender breakdown of employees at top tech companies

9. Now go down to the FOOTER menu on the right side of the toolbar. Under source name, paste this: Compiled by company reports

11. In the Notes section of the photo, add Graphic: YOUR NAME. Data compiled by Evan F. Moore/Chicago Sun-Times

12. Hit the Export and Publish button in the upper right and follow the directions.

* Here’s what the graphic should look like when you’re finished (scroll down): 

https://chicago.suntimes.com/2020/2/17/21076129/shelton-banks-google-facebook-twitter-re-work-training-tech-diversity

———-

OPTION H: Top tech company 2019 employment by race (grouped bar chart)

1.Open the Top Tech Company Racial Breakdown data file in this folder and download it to your desktop:

https://drive.google.com/drive/folders/0B4AbFFVbzuMDbVlNNnhNMFJQaXM

2.In Flourish, click on the red “NEW” button.

3.Select the Column chart (grouped) in the first group of graphic options.

4.Make sure you select the “DATA” tab at the top of the interface.

5.Hit the “Import Data” button in the upper right, select the spreadsheet you downloaded. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.

6. Make sure all of the columns are highlighted in pink or purple.

7. Click on the Preview tab to see what the chart looks like

8. In the right column, select the HEADER menu and for Title: type/paste in: Diversity breakdown of employees at top tech companies

9. Now go down to the FOOTER menu on the right side of the toolbar. Under source name, paste this: Compiled by company reports

11. In the Notes section of the photo, add Graphic: YOUR NAME. Groupon and Instagram figures are from May 2018 and reported in “Diversity in Tech,” by David McCandless • Other figures were taken from company reports in 2019 and compiled by Evan F. Moore/Sun-Times

12. Hit the Export and Publish button in the upper right and follow the directions.

* Here’s what the graphic should look like when you’re finished (scroll down): 

https://chicago.suntimes.com/2020/2/17/21076129/shelton-banks-google-facebook-twitter-re-work-training-tech-diversity

————-

OPTION I: Bonds-Sosa-McGwire Season Home Runs

We’re going to use a “bump chart” (also known as horserace chart) to visualize baseball home run data.

Here are the steps:

1.Download the Excel .csv spreadsheet here, open it and familiarize yourself with the data:

http://bit.ly/baseballflourish

Raw link: https://drive.google.com/file/d/1azn4kFqY9o5_fi6YzlyBsXbURhK_ijVN/view?usp=sharing

2. Note we have a column with a link to photos of each of the players.

3.  We’ll use the data for columns C through X. Their totals are in column Y, but if you include it, it skews the chart’s scale.

4. Open flourish.studio and under visualizations, click on the red “new” button.

5. Go to the Line Chart Race section and select the “simple” template. 

6. Make sure you select the “Data” tab at the top of the interface.

7. Hit the “Import Data” button in the upper right, select the BASEBALL-ANIMATEDLINECHART.csv spreadsheet that you downloaded. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.

8. In the column to the right, in the Values field, type in C-T as the columns you want to highlight in the chart.

9. Hit the preview button to see how your chart looks so far

10: In the right column, select the HEADER menu and for Title: Baseball’s Steroid Era and Home Runs

11. For the subhead, type: Sammy Sosa, Mark McGwire and Barry Bonds

12. For the text field, paste in: Baseball was plagued by the “steroid era” in the late 1990s to early 2000s, prompting several investigations. Baseball’s single-season home run record fell twice in that era, McGwire (1998) with 70 and Bonds with 73 in 2001.


13. Click on the FOOTER menu and in the Source field add: Baseball-Reference. 

14. In the link field, add: https://www.baseball-reference.com/

15. In the Notes field, add this: Graphic: YOUR NAME

16. Tip: If the Y-axis presents the numbers as percentages, simply go into the Y-axis menu on the right toolbar and delete “%” from the suffix box.

17. Then hit the publish button in the upper right and it will guide you through the publishing process.

——————

OPTION J: Avocado Imports Line Chart

We’re going to replicate this chart about avocado imports into the U.S. (hey, who doesn’t like guacamole?): https://public.flourish.studio/visualisation/181560/

The idea for this chart came from Arizona Republic reporter Lauren Saria.

Here are the steps:

  1. Download this Excel spreadsheet to your desktop and look over the data: http://bit.ly/flourishavocado
https://docs.google.com/spreadsheets/d/1fbDM1FhxnBut7ODabChlNQNZjquHtKDBAIpmNcFWxQc/edit#gid=992967026
  1. We’ll use the data for columns B, C and D (California, Mexico and Chile).
  2. Open flourish.studio and under visualizations, click on the red “new” button.
  3. Select the line chart in the first group of graphic options
  4. Make sure you select the “Data” tab at the top of the interface.
  5. Hit the “Import Data” button in the upper right, select the avocados spreadsheet. If it asks you to make the data public or private, select “public.” You would select private if you were working on a sensitive topic that you could make public later when you’re ready to publish.
  6. In the column to the right, in the Values field, type in B-D (California, Mexico and Chile) as the columns you want to highlight.
  7. Hit the preview button to see your chart
  8. In the right column, select the HEADER menu and for Title: type/paste in: Avocados: U.S. Import Volume
  9. For the Subtitle on the HEADER menu, type/paste in: Oct. 14-Dec. 1, 2018
  10. Under the ANNOTATIONS menu, select Line Highlights on X-axis, then type/paste in this: Avocado shortage Nov 11 :: Nov-11   and hit return.
  11. Under the position tool in the ANNOTATIONS menu, hit the center button and it should move the vertical line to the area you need it. (You also can achieve this by hitting return after pasting in Avocado shortage Nov 11 :: Nov-11 in the field above.
  12. Now go down to the FOOTER menu on the right side of the toolbar. Under source name, paste this: Hass Avocado Board• Source information compiled by the Hass Avocado Board
  13. In the  Source URL field , you can put this link to the original dataset: http://www.hassavocadoboard.com/shipment-data/historical-shipment-volume/2018
  14. In the Note field, type: Graphic | Your Name
  15. Look over your graphic for typos and mistakes.
  16. Go to the button on the upper right corner and hit Export and Publish. Select your link, embed code or download the HTML, whichever you need.
  17. NOTE: Be sure to back up all datasets and I encourage exporting an image of a static graphic to keep on file. Backing up your work with third-party tools is a must.

——————

OPTION K: Countdown Ticker

World Cup

1.Select the simple countdown template under Countdown Ticker

2.Enter the start date: Nov. 20, 2022

3. In the header title: 2022 FIFA World Cup Countdown

  • You also can do this in the image countdown ticker and sub the World Cup logo for the default Olympic logo

OPTION L: Olympic Swimming Animation

Just before the Tokyo Olympics, Google added animated templates for swimming, track and cycling to Google Flourish. You can now recreate a race using lap times and finish times. It even awards medals to the top three at the end. Steps/how to:

  1. Download this spreadsheet that I built from times off Olympics.com: https://drive.google.com/file/d/1VMelihHpAkyqZj2t_Wp19nwoMnyGf_yP/view?usp=sharing
  2. Go to the Sports Race section in the Flourish templates and open Swimming
  3. Give it a title in the upper left corner (Swimming Graphic is fine)
  4. Click on the Data tab at the top and then hit the blue upload button in the upper right corner to upload your spreadsheet.
  5. Click on the Preview tab and you can see the icons swimmin’ away!
  6. Let’s customize it. On the right rail, click on the header pulldown menu and drop this in the Title field: Tokyo Olympics Men’s 100-Meter Freestyle Final
  7. In the Text field, add: Results are based on 50-meter time and finish. (You can add more detail about the winner, etc., if you like)
  8. Now open the Footer field and add Olympics.com in the Source field and this link in the Source Link field: https://olympics.com/tokyo-2020/olympic-games/en/results/swimming/results-men-s-100m-freestyle-fnl-000100-.htm
  9. Now go to the Track and Participants flyout menu. Here you can click the arrow next to the Color Panel, hit edit and drag the colors to each participant you want (Blue for USA swimmer, red for Australia, etc.)
  10.  Now go to the Timeline and Animation flyout menu and use the settings pictured below. I turned on the Playback Button option and turned off the loop option. I also set the duration time from the default 20 second to 47 seconds — the actual length of the race — to make it more authentic. 
  1.  Now hit the Export and Publish button in the upper right corner and embed/link to the graphic.
  2. Here’s how mine turned out: https://public.flourish.studio/visualisation/6884533/


OPTION M: Olympic Track Animation

Just before the Tokyo Olympics, Google added animated templates for swimming, track and cycling to Google Flourish. You can now recreate a race using lap times and finish times. It even awards medals to the top three at the end. Steps/how to:

  1. Download this spreadsheet that I built from times off Olympics.com: https://docs.google.com/spreadsheets/d/14YQHvJNl_muPQ94lbTdd1yADZXrZLkrOuFcj_VlPjf4/edit#gid=0
  2. Go to the Sports Race section in the Flourish templates and open Athletics
  3. Give it a title in the upper left corner (Track Graphic is fine)
  4. Click on the Data tab at the top and then hit the blue upload button in the upper right corner to upload your spreadsheet.
  5. Click on the Preview tab and you can see the icons runnin’!
  6. Let’s customize it. On the right rail, click on the header pulldown menu and drop this in the Title field: Tokyo Olympics Women’s 800-Meter Final
  7. In the Text field, add: Results are based on 400-meter lap time and finish time. (You can add more detail about the winner, etc., if you like)
  8. Now open the Footer field and add Olympics.com in the Source field and this link in the Source Link field: https://docs.google.com/spreadsheets/d/14YQHvJNl_muPQ94lbTdd1yADZXrZLkrOuFcj_VlPjf4/edit#gid=0
  1. Now go to the Track and Participants flyout menu. Here you can click the arrow next to the Color Panel, hit edit and drag the colors to each participant you want (Blue for USA runner, red for Great Britain, etc.)
  2.  Unlike the swimming template, it’s hard to adjust the time settings under Timeline and Animation to reflect the 1:57 finish time for the race. So it goes much faster than the actual race. 
  3.  Now hit the Export and Publish button in the upper right corner and embed/link to the graphic.

_______________________________________________________________________________________________

Flourish Examples: https://flourish.studio/examples/
Charlotte Observer: Why Panthers QB Kyle Allen Deserves a Raise

https://www.charlotteobserver.com/sports/nfl/carolina-panthers/panthers-tracks-news/article237372724.html

Charlotte Observer: Panther Player Database: BMI and COVID Risk

https://www.charlotteobserver.com/sports/nfl/carolina-panthers/article244898967.html

Charlotte Observer: NC High School Basketball Players Transferred to Academies

https://www.charlotteobserver.com/sports/high-school/article257922323.html

St. Louis Post-Dispatch: Albert Pujols pursuit of 700 home runs: https://www.stltoday.com/sports/baseball/professional/cardinal-beat/the-progression-of-baseballs-home-run-record-how-pujols-stands-with-the-greats/article_f36c1b7b-fe11-5498-b320-9abae79405ba.html#tncms-source=login

Detroit Free Press: Matthew Stafford

https://www.freep.com/in-depth/sports/nfl/lions/2019/10/20/matthew-stafford-40000-detroit-lions/3947053002/

Denver Post (APSE): Baseball’s whole new ballgame: Strikeouts, home runs and growing concerns
https://www.denverpost.com/2019/06/23/baseball-strikeouts-home-runs-growing-concerns/

Sean Tucker by the numbers: Where does he stand among the school’s great running backs?
https://www.syracuse.com/orangefootball/2022/08/sean-tucker-by-the-numbers-where-does-he-stand-among-the-schools-great-running-backs.html
Syracuse beat writer Emily Leiker visualizes the back’s career and puts it in perspective.

NOLA (APSE): Text Cards of Drew Brees’ WRs for TDs
https://www.nola.com/sports/saints/article_06f23a64-1f99-11ea-84d3-bb13e5046fa5.html

NOLA (APSE): For 12 Saints, hundreds in NFL camps: Small-school road makes for uphill climb: ‘Patience is key’
https://www.nola.com/sports/saints/article_2238bcb6-c30b-11e9-afd1-e33851d122f9.html

(tweet: https://twitter.com/Amie_Just/status/1163944606934999042)

Public account: https://app.flourish.studio/@amie.j.just

Loyola (Chicago) Phoenix: A Breakdown of Loyola’s Future Matchups with Belmont
http://loyolaphoenix.com/2021/10/somethings-a-bruin-in-the-valley-a-breakdown-of-loyolas-matchups-with-belmont/

UIC: Barry Bonds Career Home Runs
https://medium.com/@mdeva6/call-him-a-liar-and-a-cheat-but-barry-bonds-is-still-the-reigning-home-run-king-2504a403771d

UIC: Olympic Women’s 800 Meters
https://medium.com/@nawai2/tokyo-olympics-womens-800-meter-final-results-9777369a4341

Daily Nebraskan Athletic Department Budget
http://www.dailynebraskan.com/sports/nebraska-athletics-remains-financially-strong-through-pandemic/article_dab7393a-8ce9-11eb-a26c-d3205eacf123.html?fbclid=IwAR1WWUqk855wTZtMHifE8WrnnrPQa_DXFfhlmpzdZXgrVpKqJtS3l0e46TU

NOLA (APSE): NFL Free Agency by Amie Just
https://www.nola.com/sports/saints/article_6585c93c-663a-11ea-a821-37e58859444c.html

Toledo Blade: Urban Meyer’s coaching career: https://public.flourish.studio/story/22172/embed

Pensacola Boys Prep Soccer Stat Leaders (Google Flourish line chart): https://www.pnj.com/story/sports/high-school/2019/01/13/pnj-boys-soccer-leaderboard-catholic-duo-surge-area-scoring-lead/2566398002/

Scranton (PA) Times-Tribune: Prep Football Picks Flourish Chart
https://public.flourish.studio/story/130130/

Citizen’s Voice, Wilkes Barre, PA: High School Football Schedule Map
https://public.flourish.studio/story/57759/

West Virginia: Weekly Prep Boys Basketball Scoring Leaders
https://public.flourish.studio/visualisation/1057951/

West Virginia: Weekly Prep Girls Basketball Scoring Leaders
https://public.flourish.studio/visualisation/1057300/

Detroit Free Press COVID-19 Tracker
https://www.freep.com/in-depth/news/health/2021/02/19/michigan-covid-19-vaccine-coronavirus-shots-administered/6763027002/

Detroit Free Press Early Days of COVID (scroll down)
https://www.freep.com/in-depth/news/investigations/2020/12/18/covid-19-michigan-pandemic-march/6410200002/

Arizona Republic: Avocados: U.S. import Volume (line chart)
https://public.flourish.studio/visualisation/175911/?utm_source=showcase&utm_campaign=visualisation/17591

Toledo Blade: Big Changes Coming for GM (Google Flourish Story): https://public.flourish.studio/story/21557/embed

NBC 4-Columbus, Ohio: COVID-19 Cases Map
https://public.flourish.studio/visualisation/3116835/
Ben Orner of NBC 4 in Columbus built this map with a shape file, county data and the blank Google Flourish mapping tool. 

Monterey County Weekly: Road Traffic Line Chart
http://www.montereycountyweekly.com/news/local_news/raves-overdoses-and-helicopters-big-sur-is-being-overrun-and-here-s-data-that-proves/article_9e093710-dced-11ea-b312-cb3f5c22fe4c.html

Lee Enterprises: COVID Spread in PA
https://public.flourish.studio/story/774207/

Omaha.com: Paying the Price: Well-worn path to prison in North Omaha fuels racial incarceration disparities
https://omaha.com/news/state-and-regional/crime-and-courts/paying-the-price-well-worn-path-to-prison-in-north-omaha-fuels-racial-incarceration-disparities/article_172bbfa2-9bdb-11ec-a484-0b6d5d0b125b.html

Towson University Capstone Class: US Gas Prices by State (4/22/22)
https://public.flourish.studio/visualisation/9538333/

Daily Nebraskan Election http://www.dailynebraskan.com/how-nebraska-lancaster-election-results-compare-to-others/article_dffaf974-1ee7-11eb-beb5-cffa4a06d76f.html

Daily Nebraskan Congressional Seats
http://www.dailynebraskan.com/news/tracking-2020-congressional-seats-presidential-election/article_a3466d72-1e3a-11eb-bbc2-83b4bf369d4c.html

Daily Nebraskan Diversity Report
http://www.dailynebraskan.com/opinion/editorials/dn-s-first-annual-newsroom-diversity-report-shows-lack-of-racial-representation/article_11be328e-06c2-11eb-8e5c-8b3cd5522a7c.html

WKSU: Map of Coronavirus Cases and COVID-19 Deaths in Ohio
https://www.wksu.org/topic/coronavirus-4-1-1#stream/0

WCPO: Passengers Flying Through CVG from COVID-19 Hot Zones
https://www.wcpo.com/news/local-news/i-team/flight-risk-i-team-tracks-local-flights-from-covid-19-hot-zones

Cincinnati Enquirer: What Super Tuesday Could Tell Ohio About the Democratic Race
https://www.cincinnati.com/story/news/politics/elections/2020/03/01/super-tuesday-what-could-ohio-dems-learn-2020-race/4858441002/

Animated bar chart: https://public.flourish.studio/visualisation/1473193/?utm_source=showcase&utm_campaign=visualisation/1473193

Stacked bar chart: https://public.flourish.studio/visualisation/1484203/

Chicago Sun-Times: Diversity Breakdown at Tech Companies
https://chicago.suntimes.com/2020/2/17/21076129/shelton-banks-google-facebook-twitter-re-work-training-tech-diversity

Forward.com: Text Cards Quotes from People
https://forward.com/scribe/440759/anti-semitism-jewish-prideteenage-writers-sound-off/
Uses Flourish Cards to ID person-on-the-street quotes.

Asbury Park Press: NJ’s Biggest Employers (animated bar chart)
https://www.app.com/story/news/investigations/data/analysis/2019/07/29/nj-top-employers/1841950001/

Asbury Park Press: DWI arrests
https://public.flourish.studio/visualisation/598697/


Toledo Blade: Urban Meyer’s coaching career: https://public.flourish.studio/story/22172/embed

Toledo Blade: Homicides in 2018: https://public.flourish.studio/story/23573/embed

Toledo Blade: Homicide map: https://public.flourish.studio/visualisation/192286/embed

Forbes: Highest-paid Athletes (stacked bar chart)
https://public.flourish.studio/visualisation/132723/

Flourish map: Abortion providers by state by year https://public.flourish.studio/visualisation/138284/
Built by a U of Illinois investigative reporting student.

Tweet: Top Highest-Paid Athletes from Forbes
https://twitter.com/thekendallbaker/status/1204456119524937729?s=12

Election charts with Flourish
https://flourish.studio/2018/10/23/american-midterm-data-visualisation/


USA TODAY

Dinah Voyles Pulver, an investigative/environment reporter with USA Today, shares these graphics and maps she’s built with Flourish.

Surf zone fatalities: https://public.flourish.studio/story/96769/

Bottled Water and Soft Drink Consumption Horserace Chart: https://public.flourish.studio/visualisation/724666/

County Council contributions horserace: https://public.flourish.studio/visualisation/87269/

Septic tanks in Florida: https://public.flourish.studio/story/42594/

Sales tax projects: https://public.flourish.studio/story/35268/

Campaign contributions by occupation: https://public.flourish.studio/visualisation/124056/

Daytona 500 race day temperatures: https://public.flourish.studio/story/192468/

Homicides in Volusia and Flagler counties: https://public.flourish.studio/story/178174/

Hospital authority tax rates: https://public.flourish.studio/visualisation/931166/

August temperature anomalies: https://public.flourish.studio/visualisation/689298/

US lightning fatalities: https://public.flourish.studio/visualisation/541730/

1998 Wildfire Photo Sliders: https://public.flourish.studio/story/8875/

Shark attacks: https://public.flourish.studio/story/62123/

Right whale deaths: https://public.flourish.studio/visualisation/449790/

Massachusetts tornadoes: https://public.flourish.studio/story/67309/

Map: US Climate Summary/Average Temperatures: https://public.flourish.studio/visualisation/924184/

Chattanooga Times Free Press Flourish Examples

Percentage of Working Teens

Chemical Agent Incidents at Tennessee Prisons

Mother’s Day Spending

Occupancy Tax Charts

image_pdfimage_print