Jump to content

Module:Medical cases data/doc: Difference between revisions

Add links
From Wikipedia, the free encyclopedia
Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
m change source to syntaxhighlight
 
Line 20: Line 20:


== Configuration ==
== Configuration ==
[https://w.wiki/Z7E Run this Wikidata Query Service query] to obtain a list of localized outbreaks to add to the <code>regions</code> property in the table.

<syntaxhighlight lang="Lua">
<syntaxhighlight lang="Lua">
return {
return {
Line 27: Line 29:
regionNamePattern = "(.+) County", -- Naming pattern for regions, applied to each region's item's label to display a short name in first column; see [[mw:Extension:Scribunto/Lua reference manual#Patterns]]
regionNamePattern = "(.+) County", -- Naming pattern for regions, applied to each region's item's label to display a short name in first column; see [[mw:Extension:Scribunto/Lua reference manual#Patterns]]
populationDate = "2020-01-01", -- Date of the population figures used to calculate per-capita infection rates
populationDate = "2020-01-01", -- Date of the population figures used to calculate per-capita infection rates
columnsByRegion = {
regions = {
-- Set each region's QID or each region's outbreak's QID to a table that specifies the relevant column names of the tabular data for each region.
-- Add a table for each region's outbreak
Q107146 = {
{
-- QID of the outbreak
cases = "CumulativeConfirmedCases", -- "totalConfirmedCases" by default
entity = "Q94259368",
cases2 = "UndatedCases", -- (Optional) A second column to add to the case count
-- If there is tabular data for the outbreak, specify any column names that differ from the defaults
recoveries = "CumulativeRecoveredPatients", -- (Optional)
deaths = "CumulativeDeaths", -- "deaths" by default
columns = {cases = "AC_CumulCases", deaths = "AC_CumulDeaths"},
-- Optional footnote for the region as wikitext
⚫
note = "Including cases in the City of Berkeley, which are reported by the Berkeley Public Health Division.",
},
},
},
notesByRegion = {
-- Set each region's QID or each region's outbreak's QID to an optional footnote as wikitext
⚫
Q107146 = "Including cases in the City of Berkeley.",
},
},
columnNotes = {
columnNotes = {

Latest revision as of 18:24, 9 August 2020

This module inserts charts and maps of medical cases related to a pandemic, broken down by subregions.

caseTable

[edit]

Inserts a table of cases and deaths by region.

Usage: {{#invoke:Medical cases data|caseTable|config=Configuration}} 

{{#invoke:Medical cases data|caseTable
|config=San Francisco Bay Area
}}
COVID-19 pandemic medical cases in the San Francisco Bay Area by county
CountiesCases[a]Recov.[b]DeathsPop. (2019)C/1MRef.
91,940,40411,2747,739,378250,718
Santa Clara530,920?3,2261,927,852275,395d c[1]
Alameda[c]400,532?2,5191,671,329239,649d c[2]
Contra Costa302,824300,6661,6011,153,526262,520d c[3]
San Francisco203,788?1,392881,549231,170d c[4]
San Mateo184,001?946766,573240,031d c[5]
Sonoma119,749118,903668494,336242,242d c[6]
Solano118,904118,073441447,643265,622d c[7]
Marin44,6507,030274258,826172,510d c[8]
Napa35,03627,672207137,744254,356d c[9]
  1. ^ Cumulative cases reported by each county's health department. Cases reported are those of county residents, including those who tested positive elsewhere in California.
  2. ^ Counties differ in what they consider to be a recovery.
  3. ^ Including cases in the City of Berkeley, which are reported by the Berkeley Public Health Division.

map

[edit]

Inserts an interactive map of cases and deaths by region.

Usage: {{#invoke:Medical cases data|map|config=Configuration|frameWidth=Frame width in pixels|frameHeight=Frame height in pixels|caption=Caption as wikitext}} 

{{#invoke:Medical cases data|map
|config=San Francisco Bay Area
|frameHeight=300
}}
Map
COVID-19 pandemic medical cases in the San Francisco Bay Area by county

Configuration

[edit]

Run this Wikidata Query Service query to obtain a list of localized outbreaks to add to the regions property in the table. 

return {
	caption = "Cases by county", -- Table or map caption as wikitext
	outbreakItem = "Q94050008", -- QID of the Wikidata item representing the 
	regionTerm = "Counties", -- Term for each region, used as the first column's header
	regionNamePattern = "(.+) County", -- Naming pattern for regions, applied to each region's item's label to display a short name in first column; see [[mw:Extension:Scribunto/Lua reference manual#Patterns]]
	populationDate = "2020-01-01", -- Date of the population figures used to calculate per-capita infection rates
	regions = {
		-- Add a table for each region's outbreak
		{
			-- QID of the outbreak
			entity = "Q94259368",
			-- If there is tabular data for the outbreak, specify any column names that differ from the defaults
			columns = {cases = "AC_CumulCases", deaths = "AC_CumulDeaths"},
			-- Optional footnote for the region as wikitext
			note = "Including cases in the City of Berkeley, which are reported by the Berkeley Public Health Division.",
		},
	},
	columnNotes = {
		cases = "Cumulative cases reported by each county's health department.", -- (Optional) Footnote for the "Cases" column as wikitext
		recoveries = "Counties differ in what they consider to be a recovery.", -- (Optional) Footnote for the "Recoveries" column as wikitext
		deaths = "Includes suspected cases.", -- (Optional) Footnote for the "Deaths" column as wikitext
	}
}

Available configurations

[edit]


  1. ^ “Respiratory virus data”, “COVID cases and deaths dashboard”, “COVID-19 hospitalizations by date”, “COVID-19 Hospitalizations Dashboard”, “Count of deaths with COVID-19 by date”, “Deaths with COVID-19 by age group”, Santa Clara County Public Health. May 15, 2025.
  2. ^ Alameda County Data Sharing Initiative, Alameda County Public Health Department. May 24, 2025.
  3. ^ Contra Costa Health Services. May 22, 2023.
  4. ^ “ARCHIVED: COVID-19 Cases by Geography Over Time”, “COVID-19 Deaths Over Time”, “COVID-19 Hospitalizations”, DataSF, San Francisco Department of Public Health. May 20, 2025.
  5. ^ San Mateo County Health. April 27, 2023.
  6. ^ Case and Testing Data, Hospitalizations and Deaths, County of Sonoma. May 29, 2025.
  7. ^ Solano County Public Health. March 2, 2023.
  8. ^ “COVID-19 Case Disposition”, “COVID-19 Cumulative Demographics”, “Total Cases and Recovered by Date Reported among Marin County Community Residents”, “Total Hospitalizations and Deaths by Event Date among Marin County Community Residents”, Marin Health & Human Services. February 14, 2023.
  9. ^ “COVID-19 in Napa County”, “Landing Page”, “Situation Update Archive”, Napa County Health & Human Services Agency. May 14, 2023.
Retrieved from "https://en.wikipedia.org/w/index.php?title=Module:Medical_cases_data/doc&oldid=972020196"