Distribution of Household Wealth in the U.S. since 1989

 

Distribution of Household Wealth in the U.S. since 1989

Units
 

Wealth by wealth percentile group

Make Full Screen

DateTop 1%
(US$ Trillions)
90-99%
(US$ Trillions)
50-90%
(US$ Trillions)
Bottom 50%
(US$ Trillions)
1989:Q34.887.567.230.76
1989:Q45.037.687.300.80
1990:Q15.027.687.470.79
1990:Q25.097.807.480.81
1990:Q34.917.777.540.81
1990:Q45.157.837.660.82
1991:Q15.447.907.770.91
1991:Q25.397.927.800.94
1991:Q35.497.918.000.92
1991:Q45.778.068.120.98
1992:Q15.728.108.240.97
1992:Q25.698.168.320.95
1992:Q35.748.288.461.00
1992:Q46.068.378.690.95
1993:Q16.278.468.690.97
1993:Q26.388.468.830.97
1993:Q36.558.528.970.98
1993:Q46.778.599.070.99
1994:Q16.808.748.991.04
1994:Q26.838.839.031.03
1994:Q36.978.899.181.01
1994:Q47.098.979.240.94
1995:Q17.369.099.340.97
1995:Q27.629.169.461.04
1995:Q38.009.229.601.06
1995:Q48.179.539.711.13
1996:Q18.269.799.831.22
1996:Q28.329.9710.041.19
1996:Q38.3010.0910.231.17
1996:Q48.5610.3810.381.23
1997:Q18.5310.5110.471.26
1997:Q29.0810.9410.811.28
1997:Q39.4811.2711.091.31
1997:Q49.6011.4811.191.34
1998:Q110.2911.9811.601.36
1998:Q210.4712.2211.861.32
1998:Q39.9611.9512.031.26
1998:Q410.8512.6712.411.33
1999:Q110.8612.8912.551.37
1999:Q211.2313.3212.711.42
1999:Q310.9913.2812.831.43
1999:Q412.1814.0413.491.44
2000:Q112.5914.5613.861.45
2000:Q212.1914.5913.971.43
2000:Q312.3414.7714.321.41
2000:Q411.7914.7214.371.43
2001:Q111.3514.6914.671.41
2001:Q211.7115.1914.971.43
2001:Q311.0314.8615.051.32
2001:Q411.7315.3515.341.44
2002:Q111.9115.6115.581.40
2002:Q211.4715.6715.381.37
2002:Q310.7915.4015.251.40
2002:Q411.2815.7315.631.38
2003:Q111.2615.8915.681.36
2003:Q212.1716.4916.081.29
2003:Q312.5416.7516.471.17
2003:Q413.3317.4816.831.33
2004:Q114.3218.2917.481.25
2004:Q214.5518.4817.901.16
2004:Q314.8719.0118.081.30
2004:Q415.8319.7818.831.24
2005:Q115.9320.3818.891.35
2005:Q216.3621.0719.121.45
2005:Q316.9021.7019.561.46
2005:Q417.3622.2220.141.41
2006:Q118.2323.1620.031.45
2006:Q218.0823.3020.101.35
2006:Q318.4723.5920.401.29
2006:Q419.1124.0620.641.37
2007:Q119.4924.6820.501.40
2007:Q219.7924.9620.471.38
2007:Q320.0725.2120.611.26
2007:Q419.8324.9920.401.21
2008:Q118.9924.6019.731.17
2008:Q218.4624.2819.700.84
2008:Q317.5923.7619.090.65
2008:Q415.8822.9018.560.72
2009:Q114.9623.1417.790.94
2009:Q215.5723.2018.230.71
2009:Q316.5023.8418.480.54
2009:Q416.9323.4118.830.52
2010:Q117.2724.1418.930.40
2010:Q216.9923.9618.870.22
2010:Q317.9324.5619.150.35
2010:Q418.7924.8219.580.47
2011:Q119.2825.3319.780.29
2011:Q219.5325.4919.940.22
2011:Q318.3025.1619.650.27
2011:Q418.8925.3920.000.43
2012:Q119.8026.2320.270.39
2012:Q219.6326.3520.370.29
2012:Q320.4126.8920.780.44
2012:Q420.7527.1421.200.40
2013:Q121.8428.1421.600.64
2013:Q222.0528.6521.920.66
2013:Q323.0329.1922.800.67
2013:Q424.0829.7623.440.70
2014:Q124.6730.4523.640.72
2014:Q225.4330.9724.000.80
2014:Q325.4531.3024.030.81
2014:Q426.3631.7324.420.83
2015:Q127.0732.4724.670.91
2015:Q227.0932.7424.730.96
2015:Q326.3232.5624.680.92
2015:Q427.1032.7225.300.92
2016:Q127.2733.2925.431.00
2016:Q227.7033.9825.531.12
2016:Q328.5834.5726.011.13
2016:Q429.1834.5926.531.08
2017:Q129.9635.3127.141.07
2017:Q230.5135.8427.491.21
2017:Q331.3436.4428.051.23
2017:Q432.5137.0528.781.19
2018:Q132.4637.5228.971.28
2018:Q232.9938.1329.351.41
2018:Q333.8038.9329.821.46
2018:Q431.5437.7329.541.34
2019:Q133.8039.2930.601.43
2019:Q234.4739.9330.751.63
2019:Q334.5340.1230.901.67

Note: Distributions by generation are defined by birth year as follows: Silent and Earlier=born before 1946, Baby Boomer=born 1946-1964, Gen X=born 1965-1980, and Millennial=born 1981-1996.

 

How To Export Posts To CSV In WordPress

Add Custom Button On The Post Listing

To generate the CSV, we first need to give a button on the listing page of a post screen. On the click of this button, we will write a code for generating a CSV.

Open your functions.php file and place the below code in it.

1
2
3
4
5
6
7
8
9
10
add_action( 'manage_posts_extra_tablenav', 'admin_post_list_top_export_button', 20, 1 );
function admin_post_list_top_export_button( $which ) {
    global $typenow;
    if ( 'post' === $typenow && 'top' === $which ) {
        ?>
        <input type="submit" name="export_all_posts" id="export_all_posts" class="button button-primary" value="Export All Posts" />
        <?php
    }
}

Above code add the button ‘Export All Posts’ on the posts listing as shown in the screenshot. Here, we have used the hook manage_posts_extra_tablenav to place our custom button on post screen page.

Export Post Button

Actual Code Which Export Posts To CSV

At this stage, you are ready with your custom button which should generate our CSV. So, let’s add a code that generates the CSV on the click of a button and send it to the browser for download.

Add the below code in the functions.php file.

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
add_action( 'init', 'func_export_all_posts' );
function func_export_all_posts() {
    if(isset($_GET['export_all_posts'])) {
        $arg = array(
                'post_type' => 'post',
                'post_status' => 'publish',
                'posts_per_page' => -1,
            );
        global $post;
        $arr_post = get_posts($arg);
        if ($arr_post) {
            header('Content-type: text/csv');
            header('Content-Disposition: attachment; filename="wp.csv"');
            header('Pragma: no-cache');
            header('Expires: 0');
            $file = fopen('php://output', 'w');
            fputcsv($file, array('Post Title', 'URL'));
            foreach ($arr_post as $post) {
                setup_postdata($post);
                fputcsv($file, array(get_the_title(), get_the_permalink()));
            }
            exit();
        }
    }
}

Amazon Athena

Serverless, no ETL
Athena is serverless. You can quickly query your data without having to setup and manage any servers or data warehouses. Just point to your data in Amazon S3, define the schema, and start querying using the built-in query editor. Amazon Athena allows you to tap into all your data in S3 without the need to set up complex processes to extract, transform, and load the data (ETL).