BLN_Mobility_Report_nonUS_2020_06_07

Google’s Community Mobility Reports are aggregated location data showing the change in visits to places like grocery stores, parks, workplaces, etc. Big Local News takes a snap shot of this data whenever it is updated, which is typically once a week. The CSV files with "BLN" were processed by Big Local News with additional columns of data added such as rolling averages. All files are provided as one zipped file for easier downloading. The date in the file name represents the most recent data available from Google. Please read the README file for complete documentation.

Data source: Big Local News · About: big-local-datasette

211,162 rows

View and edit SQL

Suggested facets: date (date)

Link rowid ▼ country_region_code country_region sub_region_1 sub_region_2 iso_3166_2_code census_fips_code date retail_and_recreation_percent_change_from_baseline grocery_and_pharmacy_percent_change_from_baseline parks_percent_change_from_baseline transit_stations_percent_change_from_baseline workplaces_percent_change_from_baseline residential_percent_change_from_baseline retail_rolling_bln grocery_rolling_bln parks_rolling_bln transit_rolling_bln workplaces_rolling_bln residential_rolling_bln
1 AE United Arab Emirates         2020-02-15 0 4 5 0 2 1            
2 AE United Arab Emirates         2020-02-16 1 4 4 1 2 1            
3 AE United Arab Emirates         2020-02-17 -1 1 5 1 2 1            
4 AE United Arab Emirates         2020-02-18 -2 1 5 0 2 1            
5 AE United Arab Emirates         2020-02-19 -2 0 4 -1 2 1            
6 AE United Arab Emirates         2020-02-20 -2 1 6 1 1 1            
7 AE United Arab Emirates         2020-02-21 -3 2 6 0 -1 1 -1 2 5 0 1 1
8 AE United Arab Emirates         2020-02-22 -2 2 4 -2 3 1 -2 2 5 0 2 1
9 AE United Arab Emirates         2020-02-23 -1 3 3 -1 4 1 -2 1 5 0 2 1
10 AE United Arab Emirates         2020-02-24 -3 0 5 -1 3 1 -2 1 5 -1 2 1
11 AE United Arab Emirates         2020-02-25 -3 2 3 -2 3 1 -2 1 4 -1 2 1
12 AE United Arab Emirates         2020-02-26 -2 1 -3 -2 3 1 -2 2 3 -1 2 1
13 AE United Arab Emirates         2020-02-27 1 5 -1 -1 3 1 -2 2 2 -1 3 1
14 AE United Arab Emirates         2020-02-28 1 5 -1 -1 1 1 -1 3 1 -1 3 1
15 AE United Arab Emirates         2020-02-29 2 7 -1 -1 5 0 -1 3 1 -1 3 1
16 AE United Arab Emirates         2020-03-01 3 10 2 -1 4 1 0 4 1 -1 3 1
17 AE United Arab Emirates         2020-03-02 0 7 1 -2 4 1 0 5 0 -1 3 1
18 AE United Arab Emirates         2020-03-03 0 6 0 -5 4 1 1 6 0 -2 3 1
19 AE United Arab Emirates         2020-03-04 -1 7 -2 -5 3 2 1 7 0 -2 3 1
20 AE United Arab Emirates         2020-03-05 -3 6 -2 -5 3 2 0 7 0 -3 3 1
21 AE United Arab Emirates         2020-03-06 -7 5 -8 -9 0 3 -1 7 -1 -4 3 1
22 AE United Arab Emirates         2020-03-07 -3 6 1 -8 4 2 -2 7 -1 -5 3 2
23 AE United Arab Emirates         2020-03-08 1 8 6 -9 -1 3 -2 6 -1 -6 2 2
24 AE United Arab Emirates         2020-03-09 -3 4 4 -10 -1 4 -2 6 0 -7 2 2
25 AE United Arab Emirates         2020-03-10 -4 6 3 -11 -2 4 -3 6 0 -8 1 3
26 AE United Arab Emirates         2020-03-11 -4 5 0 -12 -2 4 -3 6 1 -9 0 3
27 AE United Arab Emirates         2020-03-12 -8 6 -6 -15 -3 5 -4 6 0 -11 -1 4
28 AE United Arab Emirates         2020-03-13 -16 3 -15 -20 -2 5 -5 5 -1 -12 -1 4
29 AE United Arab Emirates         2020-03-14 -12 4 -12 -17 2 4 -7 5 -3 -13 -1 4
30 AE United Arab Emirates         2020-03-15 -6 11 -11 -15 -4 5 -8 6 -5 -14 -2 4
31 AE United Arab Emirates         2020-03-16 -11 8 -14 -17 -6 6 -9 6 -8 -15 -2 5
32 AE United Arab Emirates         2020-03-17 -16 5 -18 -22 -9 7 -10 6 -11 -17 -3 5
33 AE United Arab Emirates         2020-03-18 -19 2 -19 -25 -11 9 -13 6 -14 -19 -5 6
34 AE United Arab Emirates         2020-03-19 -24 -1 -26 -31 -12 11 -15 5 -16 -21 -6 7
35 AE United Arab Emirates         2020-03-20 -37 -11 -45 -44 -12 11 -18 3 -21 -24 -7 8
36 AE United Arab Emirates         2020-03-21 -32 -12 -37 -42 -8 10 -21 0 -24 -28 -9 8
37 AE United Arab Emirates         2020-03-22 -30 -13 -36 -45 -17 13 -24 -3 -28 -32 -11 10
38 AE United Arab Emirates         2020-03-23 -27 14 -38 -46 -20 14 -26 -2 -31 -36 -13 11
39 AE United Arab Emirates         2020-03-24 -39 -6 -43 -53 -28 17 -30 -4 -35 -41 -15 12
40 AE United Arab Emirates         2020-03-25 -50 -18 -47 -60 -35 21 -34 -7 -39 -46 -19 14
41 AE United Arab Emirates         2020-03-26 -55 -13 -54 -67 -40 25 -39 -8 -43 -51 -23 16
42 AE United Arab Emirates         2020-03-27 -80 -60 -80 -84 -52 25 -45 -15 -48 -57 -29 18
43 AE United Arab Emirates         2020-03-28 -72 -47 -68 -80 -56 28 -50 -20 -52 -62 -35 20
44 AE United Arab Emirates         2020-03-29 -55 -26 -53 -69 -45 26 -54 -22 -55 -66 -39 22
45 AE United Arab Emirates         2020-03-30 -57 -27 -53 -69 -46 25 -58 -28 -57 -69 -43 24
46 AE United Arab Emirates         2020-03-31 -56 -26 -53 -69 -46 25 -61 -31 -58 -71 -46 25
47 AE United Arab Emirates         2020-04-01 -56 -24 -53 -70 -46 25 -62 -32 -59 -73 -47 26
48 AE United Arab Emirates         2020-04-02 -58 -25 -56 -71 -47 28 -62 -34 -59 -73 -48 26
49 AE United Arab Emirates         2020-04-03 -69 -39 -75 -79 -44 22 -60 -31 -59 -72 -47 26
50 AE United Arab Emirates         2020-04-04 -58 -27 -58 -72 -37 21 -58 -28 -57 -71 -44 25
51 AE United Arab Emirates         2020-04-05 -61 -30 -58 -79 -57 31 -59 -28 -58 -73 -46 25
52 AE United Arab Emirates         2020-04-06 -63 -32 -58 -78 -56 30 -60 -29 -59 -74 -48 26
53 AE United Arab Emirates         2020-04-07 -63 -30 -73 -78 -55 30 -61 -30 -62 -75 -49 27
54 AE United Arab Emirates         2020-04-08 -63 -30 -74 -78 -55 30 -62 -30 -65 -76 -50 27
55 AE United Arab Emirates         2020-04-09 -64 -31 -76 -79 -55 33 -63 -31 -67 -78 -51 28
56 AE United Arab Emirates         2020-04-10 -74 -46 -86 -84 -49 23 -64 -32 -69 -78 -52 28
57 AE United Arab Emirates         2020-04-11 -64 -32 -77 -79 -45 24 -65 -33 -72 -79 -53 29
58 AE United Arab Emirates         2020-04-12 -60 -28 -74 -79 -55 30 -64 -33 -74 -79 -53 29
59 AE United Arab Emirates         2020-04-13 -62 -30 -73 -78 -55 30 -64 -32 -76 -79 -53 29
60 AE United Arab Emirates         2020-04-14 -62 -31 -74 -78 -55 30 -64 -33 -76 -79 -53 29
61 AE United Arab Emirates         2020-04-15 -63 -32 -74 -78 -56 31 -64 -33 -76 -79 -53 29
62 AE United Arab Emirates         2020-04-16 -63 -32 -74 -79 -55 34 -64 -33 -76 -79 -53 29
63 AE United Arab Emirates         2020-04-17 -73 -45 -85 -84 -48 23 -64 -33 -76 -79 -53 29
64 AE United Arab Emirates         2020-04-18 -66 -39 -78 -78 -45 24 -64 -34 -76 -79 -53 29
65 AE United Arab Emirates         2020-04-19 -62 -35 -74 -78 -54 30 -64 -35 -76 -79 -53 29
66 AE United Arab Emirates         2020-04-20 -63 -37 -74 -78 -55 30 -65 -36 -76 -79 -53 29
67 AE United Arab Emirates         2020-04-21 -63 -35 -74 -78 -55 30 -65 -36 -76 -79 -53 29
68 AE United Arab Emirates         2020-04-22 -62 -33 -75 -77 -55 30 -65 -37 -76 -79 -52 29
69 AE United Arab Emirates         2020-04-23 -62 -29 -76 -77 -55 32 -64 -36 -77 -79 -52 28
70 AE United Arab Emirates         2020-04-24 -72 -40 -86 -80 -47 24 -64 -35 -77 -78 -52 29
71 AE United Arab Emirates         2020-04-25 -62 -32 -77 -74 -41 25 -64 -34 -77 -77 -52 29
72 AE United Arab Emirates         2020-04-26 -56 -26 -73 -69 -49 30 -63 -33 -76 -76 -51 29
73 AE United Arab Emirates         2020-04-27 -57 -28 -73 -68 -48 30 -62 -32 -76 -75 -50 29
74 AE United Arab Emirates         2020-04-28 -56 -26 -72 -67 -48 28 -61 -31 -76 -73 -49 28
75 AE United Arab Emirates         2020-04-29 -55 -24 -72 -67 -47 29 -60 -29 -76 -72 -48 28
76 AE United Arab Emirates         2020-04-30 -57 -26 -71 -66 -47 31 -59 -29 -75 -70 -47 28
77 AE United Arab Emirates         2020-05-01 -66 -36 -83 -73 -41 22 -58 -28 -74 -69 -46 28
78 AE United Arab Emirates         2020-05-02 -56 -26 -72 -66 -34 22 -58 -27 -74 -68 -45 27
79 AE United Arab Emirates         2020-05-03 -51 -22 -68 -65 -45 27 -57 -27 -73 -67 -44 27
80 AE United Arab Emirates         2020-05-04 -52 -24 -68 -65 -45 28 -56 -26 -72 -67 -44 27
81 AE United Arab Emirates         2020-05-05 -53 -23 -68 -64 -45 27 -56 -26 -72 -67 -43 27
82 AE United Arab Emirates         2020-05-06 -51 -20 -67 -62 -44 28 -55 -25 -71 -66 -43 26
83 AE United Arab Emirates         2020-05-07 -53 -23 -68 -63 -44 30 -55 -25 -71 -65 -43 26
84 AE United Arab Emirates         2020-05-08 -63 -35 -81 -72 -38 21 -54 -25 -70 -65 -42 26
85 AE United Arab Emirates         2020-05-09 -53 -25 -70 -63 -31 22 -54 -25 -70 -65 -42 26
86 AE United Arab Emirates         2020-05-10 -48 -19 -66 -61 -42 27 -53 -24 -70 -64 -41 26
87 AE United Arab Emirates         2020-05-11 -51 -22 -66 -61 -43 28 -53 -24 -69 -64 -41 26
88 AE United Arab Emirates         2020-05-12 -50 -20 -66 -61 -43 28 -53 -23 -69 -63 -41 26
89 AE United Arab Emirates         2020-05-13 -51 -21 -66 -61 -43 28 -53 -24 -69 -63 -41 26
90 AE United Arab Emirates         2020-05-14 -53 -20 -67 -61 -43 29 -53 -23 -69 -63 -40 26
91 AE United Arab Emirates         2020-05-15 -62 -32 -80 -70 -35 21 -53 -23 -69 -63 -40 26
92 AE United Arab Emirates         2020-05-16 -51 -21 -68 -61 -29 21 -52 -22 -68 -62 -40 26
93 AE United Arab Emirates         2020-05-17 -47 -16 -64 -60 -41 27 -52 -22 -68 -62 -40 26
94 AE United Arab Emirates         2020-05-18 -48 -18 -64 -59 -42 27 -52 -21 -68 -62 -39 26
95 AE United Arab Emirates         2020-05-19 -49 -19 -65 -60 -42 27 -52 -21 -68 -62 -39 26
96 AE United Arab Emirates         2020-05-20 -53 -22 -67 -61 -44 28 -52 -21 -68 -62 -39 26
97 AE United Arab Emirates         2020-05-21 -53 -20 -69 -61 -43 30 -52 -21 -68 -62 -39 26
98 AE United Arab Emirates         2020-05-22 -59 -27 -81 -69 -33 21 -51 -20 -68 -62 -39 26
99 AE United Arab Emirates         2020-05-23 -52 -17 -73 -66 -47 25 -52 -20 -69 -62 -42 26
100 AE United Arab Emirates         2020-05-24 -56 -31 -68 -72 -77 36 -53 -22 -70 -64 -47 28

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [BLN_Mobility_Report_nonUS_2020_06_07] (
   [country_region_code] TEXT,
   [country_region] TEXT,
   [sub_region_1] TEXT,
   [sub_region_2] TEXT,
   [iso_3166_2_code] TEXT,
   [census_fips_code] TEXT,
   [date] TEXT,
   [retail_and_recreation_percent_change_from_baseline] TEXT,
   [grocery_and_pharmacy_percent_change_from_baseline] TEXT,
   [parks_percent_change_from_baseline] TEXT,
   [transit_stations_percent_change_from_baseline] TEXT,
   [workplaces_percent_change_from_baseline] TEXT,
   [residential_percent_change_from_baseline] INTEGER,
   [retail_rolling_bln] TEXT,
   [grocery_rolling_bln] TEXT,
   [parks_rolling_bln] TEXT,
   [transit_rolling_bln] TEXT,
   [workplaces_rolling_bln] TEXT,
   [residential_rolling_bln] TEXT
);
Powered by Datasette · Query took 1947.714ms · Data source: Big Local News · About: big-local-datasette