search

ISG-ICS / cloudberry

Big Data Visualization
http://cloudberry.ics.uci.edu
91 stars 82 forks source link

Show tweet-count trend and case-count trend in a popup window. #739

Closed baiqiushi closed 4 years ago

baiqiushi commented 4 years ago

Show both Tweets count and Cases count line chart in pop-up window on Coropleth-map.

T1 Collect and ingest cases data into database.

Data source: https://coronavirus.1point3acres.com/.

T1.1 What is data format of data source?

Use csv for now, will transfer to database if later transfer to PostgreSQL. The current Asterix_db is not easy to maintain (ingest and query from it)

T1.2 Design our database schema.

Two csv files, representing States and Counties respectively.

T2 Show 2 line charts in one pop-up window of a polygon on Coropleth-map.

Yicong-Huang commented 4 years ago

@JosephZheng1998 Can you please update the Issue description to match the new schema for csv files (states and cities)?

JosephZheng1998 commented 4 years ago

Updated description

Data source: COVID-19/Coronavirus Live Updates With Credible Sources in US and Canada

T1.2 Design our database schema.

Two csv files, representing States and Counties respectively.

States: state_id, last_update, confirmed, new_confirmed, deaths, new_deaths, fatality_rate

Counties: county_id, last_update, confirmed, new_confirmed, deaths, new_deaths, fatality_rate