This is a revision of https://github.com/tonyxu-io/react-bigquery-app by Tony XU [email protected]

Map code is from https://www.react-simple-maps.io/examples/usa-with-state-labels by Richard Zimerman

This app is based on the Google BigQuery app tutorial Create A Simple Application With the API and using Google Cloud Public Dataset - Stack Overflow

Supported queries:

• Natality correlation: Ave_Age_of_Mother to Maternal_Morbidity_YN

SELECT
  CORR(a.area_deprivation_index_percent,
    b.Ave_Age_of_Mother) corr,
    a.year,
    a.state
FROM
  `bigquery-public-data.broadstreet_adi.area_deprivation_index_by_county` a
JOIN
  `bigquery-public-data.sdoh_cdc_wonder_natality.county_natality_by_maternal_morbidity` b
ON
  b.County_of_Residence_FIPS = a.county_fips_code
WHERE
  b.Maternal_Morbidity_YN = 1
group by
  a.year, a.state

• Others? TBD

• Clone this repository
• cd into root directory
• npm install

Follow instructions on Google Cloud Platform to get application credential application default credentials

You can also create a .env file and set as below:

GOOGLE_APPLICATION_CREDENTIALS = 'PATH/To/Your/JSON/Key/File'

root directory:

npm start

cd ./client:

npm start