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