How alyrraza/covid-data-exploration-sql works
Project type and purpose
• This is a data‐exploration/ETL project centered on COVID-19 data.
• It ingests raw CSVs, builds relational tables via SQL DDL scripts, runs analytical SQL queries, and exports results to CSV for further inspection.
File structure
• Top-level files:
• CovidVacinations.csv & CovidDeaths.csv – raw input data
• Table Creation.sql – DDL statements to create tables and load the CSVs
• Data Exploration.sql – collection of analytical queries (Query 1 through Query 6)
• Query 7 output.csv – sample of a more complex query’s output
• README.md – documentation of queries and intent
• .vscode – IDE/editor configuration
• There is no frontend or backend service—this is purely a data‐processing pipeline.
README for additional insights
• The README describes each query’s goal, tables involved, and a window‐function example for cumulative sums.
• No external services or microservices are referenced.
Essential details to capture
• Exact file/script names and their roles
• The join and window‐function logic in Query 7 as a sub-component of the analytics stage
• The fact that all artifacts live locally in VSCode/GitHub rather than in a cloud service
• Potential extensibility: e.g., adding a scheduler or a BI tool on top of the output CSVs