sources
Data license: CC-BY
1 row where datasetId = 5085 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
17815 | Google COVID-19 Community Mobility Trends – Last updated 21 October 2022 | { "link": "https://www.google.com/covid19/mobility/", "additionalInfo": "Google provide an overview of what its mobility trends represent and how it's measured here: https://support.google.com/covid19-mobility/answer/9824897?hl=en&ref_topic=9822927\n\nAs it describes:\n\"The data shows how visitors to (or time spent in) categorized places change compared to our baseline days. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5\u2011week period Jan 3 \u2013 Feb 6, 2020.\n\nFor each region-category, the baseline isn\u2019t a single value\u2014it\u2019s 7 individual values. The same number of visitors on 2 different days of the week, result in different percentage changes. So, we recommend the following:\n\n\u2013 Don\u2019t infer that larger changes mean more visitors or smaller changes mean less visitors.\n\u2013 Avoid comparing day-to-day changes. Especially weekends with weekdays.\"\n\nMobility trends are measured across six broad categories:\n(1) Residential: places of residence.\n(2) Grocery & Pharmacy stores: places like grocery markets, food warehouses, farmers markets, specialty food shops, drug stores, and pharmacies.\n(3) Workplaces: places of work.\n(4) Parks: places like local parks, national parks, public beaches, marinas, dog parks, plazas, and public gardens.\n(5) Transit stations: places like public transport hubs such as subway, bus, and train stations.\n(6) Retail & Recreation: places like restaurants, cafes, shopping centers, theme parks, museums, libraries, and movie theaters.\n\nThe 'Residential' category shows a change in duration\u2014the other categories measure a change in total visitors.\n\nThis index is smoothed to the rolling 7-day average.", "dataPublishedBy": "Google LLC \"Google COVID-19 Community Mobility Reports\"." } |
2020-05-31 14:09:00 | 2020-05-31 14:09:00 | Google Mobility Trends (2020) 5085 | Google provide an overview of what its mobility trends represent and how it's measured here: https://support.google.com/covid19-mobility/answer/9824897?hl=en&ref_topic=9822927 As it describes: "The data shows how visitors to (or time spent in) categorized places change compared to our baseline days. A baseline day represents a normal value for that day of the week. The baseline day is the median value from the 5‑week period Jan 3 – Feb 6, 2020. For each region-category, the baseline isn’t a single value—it’s 7 individual values. The same number of visitors on 2 different days of the week, result in different percentage changes. So, we recommend the following: – Don’t infer that larger changes mean more visitors or smaller changes mean less visitors. – Avoid comparing day-to-day changes. Especially weekends with weekdays." Mobility trends are measured across six broad categories: (1) Residential: places of residence. (2) Grocery & Pharmacy stores: places like grocery markets, food warehouses, farmers markets, specialty food shops, drug stores, and pharmacies. (3) Workplaces: places of work. (4) Parks: places like local parks, national parks, public beaches, marinas, dog parks, plazas, and public gardens. (5) Transit stations: places like public transport hubs such as subway, bus, and train stations. (6) Retail & Recreation: places like restaurants, cafes, shopping centers, theme parks, museums, libraries, and movie theaters. The 'Residential' category shows a change in duration—the other categories measure a change in total visitors. This index is smoothed to the rolling 7-day average. | https://www.google.com/covid19/mobility/ | Google LLC "Google COVID-19 Community Mobility Reports". |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");