TARIFF_PHASE | DATE | NUMBERS | |
|---|---|---|---|
1 | US: 25% automobiles | 2025-04-01 | 4.2 |
2 | US: 25% (Canadian & Mexican goods) & Canada: 25% US goods | 2025-03-01 | 4.2 |
3 | US: 145% all Chinese goods & China: 15% coals and gas | 2025-02-01 | 4.1 |
4 | No tariff | 2025-01-01 | 4 |
5 | No tariff | 2024-12-01 | 4.1 |
6 | No tariff | 2024-11-01 | 4.2 |
7 | No tariff | 2024-10-01 | 4.1 |
8 | No tariff | 2024-09-01 | 4.1 |
9 | No tariff | 2024-08-01 | 4.2 |
10 | No tariff | 2024-07-01 | 4.2 |
11 | No tariff | 2024-06-01 | 4.1 |
12 | No tariff | 2024-05-01 | 4 |
13 | No tariff | 2024-04-01 | 3.9 |
14 | No tariff | 2024-03-01 | 3.9 |
15 | No tariff | 2024-02-01 | 3.9 |
16 | No tariff | 2024-01-01 | 3.7 |
17 | No tariff | 2023-12-01 | 3.8 |
18 | No tariff | 2023-11-01 | 3.7 |
19 | No tariff | 2023-10-01 | 3.9 |
20 | No tariff | 2023-09-01 | 3.8 |
LordkingUnemployment Rate (UNRATE)
Updated 2025-05-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
base AS (
SELECT
fred.get_series({
'series_id': 'UNRATE',
'file_type': 'json',
'observation_start': '{{From_date}}',
'units': 'lin',
-- 'frequency': 'd',
'sort_order': 'desc'
}) AS response
)
,fred as (
SELECT
value:date AS date,
value:value::float AS numbers
FROM base,
LATERAL FLATTEN(input => response:data:observations)
WHERE value:value != '.'
)
select
CASE
WHEN date >= '2025-02-01' AND date <= '2025-02-04' THEN 'US: 145% all Chinese goods & China: 15% coals and gas'
WHEN date >= '2025-04-02' AND date <= '2025-04-05' THEN 'US: 10% universal duty'
WHEN date >= '2025-04-04' AND date <= '2025-04-11' THEN 'China: 125% US goods'
WHEN date >= '2025-02-01' AND date <= '2025-03-04' THEN 'US: 25% (Canadian & Mexican goods) & Canada: 25% US goods'
WHEN date >= '2025-03-26' AND date <= '2025-04-03' THEN 'US: 25% automobiles'
WHEN date >= '2025-03-26' AND date <= '2025-05-03' THEN 'US: 25% auto parts'
Last run: 21 days ago
64
2KB
25s