Following in the footsteps of our example from earlier this month in tracking protest sizes using the new Global Numeric Graph (GNG), how might we track MPH (miles per hour) and MPG (miles per gallon) statistics cited in the news?
Tracking miles per hour is as simple as:
SELECT distinct(context) FROM `gdelt-bq.gdeltv2.gng` WHERE DATE(date) = "2021-06-21" and LANG='ENGLISH' and REGEXP_CONTAINS(LOWER(context), r' (\d[\.\d]+)\s*mph') LIMIT 1000
| Row | context | |
|---|---|---|
| 1 |
afternoon. Winds could gust as high as 30 mph. Wednesday Night – Mostly clear,
|
|
| 2 |
RTX 3070 TiWindows Central20:59 16-Jun-21 Watch Tesla's Model S Plaid hit 60 mph
|
|
| 3 |
are generally moving east at about 40 mph. Storms may produce lightning, gusty
|
|
| 4 |
Tropical depression: Winds at least 38 mph Tropical storm: Winds at least 39
|
|
| 5 |
Highs in the lower 90s. East winds 5 to 10 mph. .TUESDAY NIGHT…Mostly
|
|
| 6 |
Prevailing southeast winds up to 15 mph. .WEDNESDAY NIGHT…Clear. Lows 55
|
|
| 7 |
25 mph. .TUESDAY…Sunny. Highs 83 to 92. South winds around 10 mph with
|
|
| 8 |
10 to 20 mph with gusts to around 30 mph. .TONIGHT…Clear. Near the bay,
|
|
| 9 |
to 30 mph. .WEDNESDAY…Sunny. Highs 66 to 81 higher elevations…76 to 88
|
|
| 10 |
Prevailing southeast winds up to 10 mph shifting to the southwest in the
|
|
| 11 |
in the lower 90s. Southwest winds 10 to 15 mph. Chance of precipitation 60
|
|
| 12 |
50s to lower 60s. Southwest wind 5 to 15 mph with gusts to around 30 mph.
|
|
| 13 |
5 to 10 mph. Chance of precipitation 70 percent. .TONIGHT…Mostly cloudy.
|
|
| 14 |
afternoon with southeast winds from 10 to 20 mph for most of the day. But this
|
|
| 15 |
Lows 72 to 82. Southwest wind 10 to 20 mph. .TUESDAY…Partly sunny in the
|
|
| 16 |
in the lower 70s. Southeast winds 10 to 15 mph, becoming north after
|
|
| 17 |
likely to see damaging wind gusts of 60 mph or greater and "isolated flooding in
|
|
| 18 |
in the lower 90s. Southeast winds 10 to 15 mph. Heat index readings 105 to
|
|
| 19 |
in the lower 90s. Southeast winds 10 to 15 mph. Heat index readings 104 to
|
|
| 20 |
winds 5 to 10 mph. Heat index readings 105 to 110. .WEDNESDAY NIGHT…Mostly clear.
|
|
| 21 |
in the lower 60s. Northwest winds 5 to 10 mph. .TUESDAY NIGHT…Partly
|
|
| 22 |
Highs in the lower 70s. West winds 5 to 10 mph. .WEDNESDAY NIGHT…Mostly
|
|
| 23 |
on a high-speed chase with speeds of 100 mph early Sunday in Dubuque County. A
|
|
| 24 |
jester is capable of going more than 350 mph, but, due to the rules, Wolfe won't
|
|
| 25 |
lows in the lower 60s. South winds 10 to 15 mph, becoming west around 5 mph
|
|
| 26 |
to 25 mph. High: 86; Low: 61 Tuesday: 10% chance of showers before 7 a.m. then
|
|
| 27 |
5 p.m. Mostly cloudy, with a high near 77. Northwest wind 7 to 10 mph. Chance of
|
|
| 28 |
Highs 80 to 90. Northeast winds 5 to 10 mph increasing to south 10 to 20 mph in
|
|
| 29 |
NIGHT…Mostly clear. Cooler. Lows 54 to 64. Northwest winds 5 to 15 mph.
|
|
| 30 |
in the upper 60s. Southeast winds 5 to 10 mph. .WEDNESDAY…Mostly sunny.
|
|
| 31 |
Lows in the lower 60s. Northeast winds 15 to 25 mph decreasing to 10 to 15 mph
|
|
| 32 |
Lows in the upper 50s. West winds 5 to 15 mph. .WEDNESDAY…Sunny. Highs
|
|
| 33 |
becoming mostly cloudy. Lows around 60. West winds 5 to 15 mph.
|
|
| 34 |
the mid 60s. Southeast winds around 10 mph. .WEDNESDAY…Mostly sunny. Warmer.
|
|
| 35 |
70s to mid 80s. Southwest wind to 10 mph. .TUESDAY NIGHT…Partly cloudy.
|
|
| 36 |
around 109. Areas of winds northwest 15 mph becoming southeast in the afternoon.
|
|
| 37 |
terrain. Light winds becoming west 15 mph in the afternoon.
|
|
| 38 |
to 20 mph. Gusts to 35 mph…becoming 25 mph overnight. .TUESDAY…Partly
|
|
| 39 |
58 mph. Some wind gusts can exceed 100 mph and produce tornado-like damage.
|
|
| 40 |
Lows 47 to 57. Northwest wind around 10 mph. .WEDNESDAY…Mostly cloudy. Slight
|
|
| 41 |
registration; no insurance; speeding 55 mph (1-19 miles over). • Tykeem Najawah
|
|
| 42 |
Lows in the lower 80s. Southeast winds 15 to 20 mph decreasing to 10 to 15 mph
|
|
| 43 |
10 to 15 mph. Heat index readings 112 to 117. .TONIGHT…Partly cloudy in the
|
|
| 44 |
Mostly cloudy, with a low around 56. West wind 6 to 11 mph, with gusts as
|
|
| 45 |
winds 15 to 25 mph with gusts up to 35 mph expected. * WHERE…Walker. *
|
|
| 46 |
Dalton reportedly drove more than 25 mph over the speed limit while trying to
|
|
| 47 |
28 mph with maximum sustained winds of 40 mph, according to the hurricane center.
|
|
| 48 |
and DuPage Counties. A wind gust to 60 mph was clocked at Aurora Airport and
|
|
| 49 |
60 mph: 4.3 sec 100 mph: 10.7 sec 1/4-Mile: 12.9 sec @ 109 mph 130 mph:
|
|
| 50 |
Hurricane Center. It has winds of 40 mph and is moving northeast at 28 mph.
|
|
| 51 |
Highs 99 to 104. Northwest winds up to 10 mph in the morning shifting to the
|
|
| 52 |
Highs 97 to 102. Southwest winds up to 10 mph. .MONDAY NIGHT…Clear. Lows 57 to
|
|
| 53 |
to 79 at 8000 feet. West winds around 25 mph with gusts to around 40 mph in the
|
|
| 54 |
to 59 at 8000 feet. Gusts up to 45 mph in the evening. .MONDAY…Sunny.
|
|
| 55 |
369 lb-ft (500 Nm) of torque straight-six lump, which will rocket it to 60 mph (96
|
|
| 56 |
could be major, with wind speeds of 111 mph or higher. The 2020 Atlantic
|
|
| 57 |
become hurricanes when winds reach 74 mph. Of the predicted hurricanes, three
|
|
| 58 |
the lower elevations. South winds 10 to 20 mph, becoming southwest with
|
|
| 59 |
winds 10 to 15 mph. Chance of rain 60 percent. .TUESDAY NIGHT…Becoming
|
|
| 60 |
in the upper 60s. Northwest winds 5 to 10 mph. Chance of rain 70 percent.
|
|
| 61 |
winds 10 to 15 mph, becoming north 5 to 10 mph after midnight. Chance of
|
|
| 62 |
the change in speed. His changeup is 11 MPH slower than his four-seam. See, the
|
|
| 63 |
mid to upper 50s. West winds around 15 mph shifting to the north after
|
|
| 64 |
remain relatively low, peaking around 30 mph. But Claudette is expected to
|
|
| 65 |
sustained winds have increased to 45 mph, with higher gusts, according to the
|
|
| 66 |
reports of damage. Winds as strong as 79 mph gusted at Long Lake National
|
|
| 67 |
as a tornado with wind speeds of 136 to 165 mph. The last EF-3 tornado
|
|
| 68 |
scooters have a maximum speed of 15 mph and can be used on roads and bike
|
|
| 69 |
down 2.8 mph, his splitter was down 2.4 mph and his slider was down 2.0 mph.
|
|
| 70 |
usually recommend not going over 50 mph when running with one of these. But
|
Tracking miles per gallon is as simple as:
SELECT distinct(context) FROM `gdelt-bq.gdeltv2.gng` WHERE DATE(date) = "2021-06-21" and LANG='ENGLISH' and REGEXP_CONTAINS(LOWER(context), r' (\d[\.\d]+)\s*mpg') LIMIT 1000
Yielding examples like:
| Row | context | |
|---|---|---|
| 1 |
also rated the mileage in the city at 13 mpg (18.1 L/100 km); and 18 mpg (13.1
|
|
| 2 |
for city-dwellers: expect between 55 and 65mpg from the mid-range 1.8. The
|
|
| 3 |
16 mpg city, 22 mpg highway, and 18 mpg combined. Of course, the people
|
|
| 4 |
every whim. With a mileage rating of 22 mpg city/31 mpg highway/25 mpg combined,
|
|
| 5 |
the Toyota Land Cruiser returns 13 mpg city and 17 highway. These are the
|
|
| 6 |
according to the official ratings of 13 (city), 19 (highway), and 15 mpg
|
|
| 7 |
though. That SUV gets an excellent 22 mpg combined and will save you $1,500
|
|
| 8 |
& insurance Average fuel consumption 52 mpg Annual road tax Annual service
|
|
| 9 |
numerous travels. That's down from the 30 MPGe we saw at our last update and less
|
|
| 10 |
drive at mid-range speeds I was seeing 50 mpg. Hyundai's decision to use a
|
|
| 11 |
2022 Jeep Grand Wagoneer is rated at 15 mpg combined, less than the Cadillac
|
|
| 12 |
abysmal 15 mpg combined (about 15.7 L/100 km) according to the U.S. EPA. The
|
|
| 13 |
rear-wheel drive. That model returns 13 mpg city, 19 mpg highway and 15 mpg
|
|
| 14 |
£56,685 Official consumption: 51.4mpg Our average consumption: 48.7mpg
|
|
| 15 |
and 26 mpg with all-wheel drive. This 2.5-liter engine couples to an 8-speed
|
|
| 16 |
QX80 returns a Grand Wagoneer-matching 15 mpg combined, but the Lexus is the worst
|
|
| 17 |
drive has EPA fuel economy ratings of 19 mpg city, 26 mpg highway and 22 mpg
|
|
| 18 |
as we'd like to, the S60 is averaging 30 MPGe, which is impressive for a heavy
|
|
| 19 |
at 14 mpg city, 19 mpg highway, and 16 mpg combined. The Lincoln Navigator with
|
|
| 20 |
16 mpg combined; 13 mpg city; and 19 mpg highway. FCA has never really been
|
|
| 21 |
GLS-class are EPA-rated at 21 mpg combined with their respective
|
|
| 22 |
13 mpg city, 19 mpg highway and 15 mpg combined. Neither the city nor
|
|
| 23 |
visual character.. Great Gas Mileage: 27 MPG Hwy. MORE ABOUT US At Shelor Motor
|
|
| 24 |
unleaded like free pints at the pub; one highway run returned 13 mpg at a 72-mph
|
|
| 25 |
as an everyday proposition. Porsche 718 Cayman 296bhp, 31.7mpg, £46,620 on the
|
|
| 26 |
released by the EPA reveal that the 2022 Grand Wagoneer returns 13 mpg city, 19 mpg
|
|
| 27 |
51.4mpg Our average consumption: 48.7mpg Mileage: 5,876 5th Report: A
|
|
| 28 |
our car is averaging a disappointing 28 MPGe, despite its numerous travels.
|
|
| 29 |
Navigator is rated at an EPA-estimated 16 mpg city; 20 mpg highway; and 17 mpg
|
|
| 30 |
the four-wheel-drive version gets just 18 mpg highway and only 13 mpg in the city
|
|
| 31 |
Fleet: 14 months Current Mileage: 25,778 miles Average Fuel Economy: 28 MPGe
|
|
| 32 |
in Fleet: 6 months Current Mileage: 11,693 miles Average Fuel Economy: 30 MPGe
|
|
| 33 |
of 29 mpg with front-wheel drive and 26 mpg with all-wheel drive. This 2.5-liter
|
|
| 34 |
highway, and 15 mpg combined with the 6.4-liter V8 and rear-wheel drive, while
|
|
| 35 |
25,778 miles Average Fuel Economy: 28 MPGe Fuel Tank Size: 15.9 gal Observed
|
|
| 36 |
EPA-estimated combined fuel economy of 29 mpg with front-wheel drive and 26 mpg
|
|
| 37 |
torque EPA fuel economy (combined): 23 mpg Length/Width/Height:
|
|
| 38 |
0.84 g C/D FUEL ECONOMY Observed: 28 MPGe Unscheduled oil additions: 0 qt
|
|
| 39 |
one highway run returned 13 mpg at a 72-mph average. An even less
|
|
| 40 |
6.2-liter V-8 engine are rated at 16 mpg combined, 13 mpg in the city and 19
|
|
| 41 |
with four-wheel drive and the standard 6.2-liter V-8 engine are rated at 16 mpg
|
|
| 42 |
estimated fuel economy is more than 70 MPGe. PHEV level-2 charging capability
|
|
| 43 |
for a 21 mpg combined rating. All 2022 MDX models come with a complete suite of
|
|
| 44 |
0-62mph in 5.2sec How economical? 37.7mpg (WLTP Combined) Engine/gearbox:
|
|
| 45 |
less at 25 mpg highway rating for a 21 mpg combined rating. All 2022 MDX
|
|
| 46 |
at 15 mpg city, 21 mpg highway and 17 mpg combined. The M5 packs a
|
|
| 47 |
You can boost that highway figure to 19 mpg if you forego four-wheel drive, but
|
|
| 48 |
Integration, Blind Spot Monitor. EPA 24 MPG Hwy/20 MPG City! XLT trim, Rapid Red
|
|
| 49 |
V6 is more fuel efficient and returns 16 mpg city, 22 mpg highway, and 18 mpg
|
|
| 50 |
warranty Value vs rivals5 out of 5 54.5mpg, can get more on long
|
|
| 51 |
11,693 miles Average Fuel Economy: 30 MPGe Fuel Tank Size: 15.9 gal
|
|
| 52 |
claimed impressive fuel consumption of 54.5mpg @ 75mph while service intervals
|
|
| 53 |
& insurance Average fuel consumption 37 mpg Annual road tax Annual service
|
|
| 54 |
though, as they're both rated for 21 mpg on the highway. The other end of the
|
|
| 55 |
of 19 mpg city, 26 mpg highway and 22 mpg combined. MDX with SH-AWD has the
|
|
| 56 |
22 hrs ago Very Nice. FUEL EFFICIENT 27 MPG Hwy/21 MPG City! Heated Seats,
|
|
| 57 |
of 13 mpg city, 21 mpg highway and 15 mpg combined when equipped with the
|
|
| 58 |
of 29 city, 36 highway, for an overall 32 mpg. Steering features
|
|
| 59 |
size 120/70 x 17 Rear tyre size 200/55 x 17 Mpg, costs & insurance Average
|
|
| 60 |
new Cadillac Escalade that's rated at 14 mpg city, 19 mpg highway, and 16 mpg
|
|
| 61 |
Top speed: 109mph Economy: 53.3mpg 140g/km On sale: October
|
|
| 62 |
Environmental Protection Agency, the four-wheel-drive version gets just 18 mpg
|
|
| 63 |
size 120/70 x 17 Rear tyre size 180/55 x 17 Mpg, costs & insurance Average
|
|
| 64 |
days on dealer lots. The Tucson has a 38 MPG Combined Estimate from the EPA. The
|
|
| 65 |
V6. The Escalade manages 16 mpg combined; 13 mpg city; and 19 mpg
|
|
| 66 |
but the Lexus is the worst of all at 14 mpg combined. For anything else you
|
|
| 67 |
drive, but the highway number drops by one to 18 mpg. Unfortunately for Jeep, these
|
|
| 68 |
California) as using the equivalent of 177 mpg, or about one fifth of what the
|
|
| 69 |
The rivals Alpine A110 Pure 249bhp, 42.2mpg, £49,005 on the road The A110's
|
|
| 70 |
3.5-liter twin-turbo V6 ups that by 1 additional mpg at 17 mpg combined. In
|