SELECT concat(year, '-', month) as date, index_nsa, geo_type, rank() OVER (PARTITION BY concat(year, '-', month) ORDER BY index_nsa) as r FROM real_estate.freddie_mac_house_price_index WHERE year >= 2023
Query Title

Select on real_estate.freddie_mac_house_price_index

Description None
Last Execution Results

Feb 9, 18:49 (UTC)

Download
# date index_nsa geo_type r
12023-1 149.8109418 CBSA 1
22023-1 149.82344888 CBSA 2
32023-1 150.60370619 CBSA 3
42023-1 151.14299909 CBSA 4
52023-1 151.46639135 CBSA 5
62023-1 152.31190653 CBSA 6
72023-1 155.11889926 CBSA 7
82023-1 155.45940936 CBSA 8
92023-1 156.36783826 CBSA 9
102023-1 159.48047351 CBSA 10
112023-1 159.96915951 CBSA 11
122023-1 162.84071639 CBSA 12
132023-1 163.98338749 CBSA 13
142023-1 164.36882433 CBSA 14
152023-1 165.95590552 CBSA 15
162023-1 166.79596902 CBSA 16
172023-1 167.35692903 CBSA 17
182023-1 167.37652593 CBSA 18
192023-1 168.22202503 CBSA 19
202023-1 168.69866053 CBSA 20
212023-1 169.4812448 CBSA 21
222023-1 170.95492817 CBSA 22
232023-1 171.63219245 State 23
242023-1 171.90215557 State 24
252023-1 171.95445618 CBSA 25
262023-1 172.03110517 CBSA 26
272023-1 172.82380359 CBSA 27
282023-1 172.97942853 CBSA 28
292023-1 174.49176084 CBSA 29
302023-1 175.52427915 CBSA 30
312023-1 176.73369622 CBSA 31
322023-1 176.9166553 CBSA 32
332023-1 177.3356835 CBSA 33
342023-1 178.86152446 CBSA 34
352023-1 179.12903032 CBSA 35
362023-1 180.20529191 CBSA 36
372023-1 180.31136723 CBSA 37
382023-1 180.48255607 CBSA 38
392023-1 180.50886403 CBSA 39
402023-1 181.7242261 CBSA 40
412023-1 182.67251497 CBSA 41
422023-1 182.9493891 CBSA 42
432023-1 183.17458267 CBSA 43
442023-1 183.25235456 CBSA 44
452023-1 184.14683399 CBSA 45
462023-1 184.26861112 CBSA 46
472023-1 184.74959041 CBSA 47
482023-1 185.39792486 CBSA 48
492023-1 185.51275954 State 49
502023-1 185.55056811 CBSA 50
512023-1 186.92392145 CBSA 51
522023-1 188.08372089 CBSA 52
532023-1 188.37116478 CBSA 53
542023-1 188.89196125 CBSA 54
552023-1 189.62646713 CBSA 55
562023-1 190.38768701 CBSA 56
572023-1 190.50158528 CBSA 57
582023-1 191.01387834 CBSA 58
592023-1 191.49408315 CBSA 59
602023-1 192.264563 CBSA 60
612023-1 192.3590656 CBSA 61
622023-1 192.48039417 CBSA 62
632023-1 192.55138045 CBSA 63
642023-1 192.55998566 CBSA 64
652023-1 192.56205133 CBSA 65
662023-1 192.775096 CBSA 66
672023-1 194.63843558 CBSA 67
682023-1 194.65774159 CBSA 68
692023-1 194.88454461 CBSA 69
702023-1 195.41761309 CBSA 70
712023-1 195.50820945 CBSA 71
722023-1 195.69116439 CBSA 72
732023-1 195.75851079 CBSA 73
742023-1 195.8870037 State 74
752023-1 196.30658159 CBSA 75
762023-1 196.43871167 CBSA 76
772023-1 196.86092316 State 77
782023-1 196.96155743 State 78
792023-1 198.21113095 CBSA 79
802023-1 200.23206759 State 80
812023-1 200.23251232 CBSA 81
822023-1 200.53955841 CBSA 82
832023-1 200.8526697 CBSA 83
842023-1 201.9685993 CBSA 84
852023-1 202.06281776 CBSA 85
862023-1 202.16925559 CBSA 86
872023-1 202.21125165 CBSA 87
882023-1 202.50144572 CBSA 88
892023-1 202.58372477 CBSA 89
902023-1 202.80688284 CBSA 90
912023-1 203.140362 CBSA 91
922023-1 203.54627457 CBSA 92
932023-1 203.63780996 CBSA 93
942023-1 204.28512701 CBSA 94
952023-1 204.68779041 CBSA 95
962023-1 204.73984281 CBSA 96
972023-1 204.75297676 CBSA 97
982023-1 205.01810958 CBSA 98
992023-1 205.05140095 CBSA 99
1002023-1 205.41564348 CBSA 100
1012023-1 205.75691212 CBSA 101
1022023-1 205.89296629 CBSA 102
1032023-1 205.97612318 CBSA 103
1042023-1 206.25901975 CBSA 104
1052023-1 206.30687965 CBSA 105
1062023-1 206.59670378 CBSA 106
1072023-1 207.12387805 State 107
1082023-1 207.29469959 CBSA 108
1092023-1 207.32382872 CBSA 109
1102023-1 207.7069819 CBSA 110
1112023-1 208.04900595 CBSA 111
1122023-1 208.26509389 CBSA 112
1132023-1 208.57688097 CBSA 113
1142023-1 208.72815186 CBSA 114
1152023-1 208.93047552 CBSA 115
1162023-1 209.1891258 CBSA 116
1172023-1 209.28496603 State 117
1182023-1 209.55291228 CBSA 118
1192023-1 209.67285316 State 119
1202023-1 209.82296747 CBSA 120
1212023-1 209.89638092 CBSA 121
1222023-1 210.0949423 CBSA 122
1232023-1 210.40901983 CBSA 123
1242023-1 210.50672635 CBSA 124
1252023-1 210.83715328 CBSA 125
1262023-1 211.16619811 CBSA 126
1272023-1 211.20498149 CBSA 127
1282023-1 211.4792944 CBSA 128
1292023-1 211.81507413 CBSA 129
1302023-1 212.33784328 CBSA 130
1312023-1 212.41129967 CBSA 131
1322023-1 212.64794508 CBSA 132
1332023-1 212.65349702 State 133
1342023-1 213.02175657 CBSA 134
1352023-1 213.13594 CBSA 135
1362023-1 213.18840942 CBSA 136
1372023-1 213.6722976 CBSA 137
1382023-1 214.08987338 CBSA 138
1392023-1 214.40512511 CBSA 139
1402023-1 214.44580243 CBSA 140
1412023-1 214.67084408 CBSA 141
1422023-1 214.91809355 CBSA 142
1432023-1 215.04204146 CBSA 143
1442023-1 215.15671294 CBSA 144
1452023-1 215.1742351 State 145
1462023-1 215.26549412 CBSA 146
1472023-1 215.44551806 CBSA 147
1482023-1 215.90657459 CBSA 148
1492023-1 216.01431248 CBSA 149
1502023-1 216.40471517 State 150
1512023-1 216.65030602 CBSA 151
1522023-1 217.15007571 CBSA 152
1532023-1 217.53437661 State 153
1542023-1 217.63511599 CBSA 154
1552023-1 218.00329621 CBSA 155
1562023-1 218.27527168 CBSA 156
1572023-1 218.65021051 CBSA 157
1582023-1 218.72719604 CBSA 158
1592023-1 219.42666322 CBSA 159
1602023-1 219.4994991 CBSA 160
1612023-1 219.93097395 CBSA 161
1622023-1 219.99144581 State 162
1632023-1 220.54472082 CBSA 163
1642023-1 221.20729471 CBSA 164
1652023-1 221.8586132 CBSA 165
1662023-1 222.0909168 CBSA 166
1672023-1 222.44272726 CBSA 167
1682023-1 222.81695864 CBSA 168
1692023-1 223.02673844 State 169
1702023-1 223.32902644 CBSA 170
1712023-1 223.83293824 CBSA 171
1722023-1 223.87729131 CBSA 172
1732023-1 224.03306511 CBSA 173
1742023-1 224.4455412 CBSA 174
1752023-1 224.64042226 State 175
1762023-1 225.43810717 CBSA 176
1772023-1 225.86322266 CBSA 177
1782023-1 225.92070453 CBSA 178
1792023-1 227.08019713 CBSA 179
1802023-1 227.2053723 CBSA 180
1812023-1 227.73758458 CBSA 181
1822023-1 227.76828294 CBSA 182
1832023-1 227.93474728 CBSA 183
1842023-1 228.04530763 CBSA 184
1852023-1 228.61689583 CBSA 185
1862023-1 228.66391693 CBSA 186
1872023-1 229.00755782 CBSA 187
1882023-1 229.42771227 CBSA 188
1892023-1 229.49956392 CBSA 189
1902023-1 229.5169663 CBSA 190
1912023-1 229.59597565 CBSA 191
1922023-1 229.63478162 CBSA 192
1932023-1 230.1111716 CBSA 193
1942023-1 230.117893 CBSA 194
1952023-1 230.12533111 State 195
1962023-1 230.27151172 State 196
1972023-1 230.98189893 CBSA 197
1982023-1 231.62534397 CBSA 198
1992023-1 231.68992616 CBSA 199
2002023-1 232.72897826 CBSA 200
All Tables
Database

Table

 Metadata
commodities oil_brent_daily
commodities oil_wti_daily
crypto fact_coin_price_history
real_estate freddie_mac_house_price_index
stocks company
stocks nasdaq_listed
stocks s_and_p_500
stocks stock_price
stocks stock_price_history_daily