gistfile1.txt

mysql> select channel, sum(committed) as committed_sum, sum(pledged) as pledged_sum from donations group by channel order by committed_sum desc; 
+-------------------------------------------------+---------------+-------------+
| channel                                         | committed_sum | pledged_sum |
+-------------------------------------------------+---------------+-------------+
| WFP                                             |      27137476 |      555000 |
| USFEMA                                          |      23500000 |           0 |
| Bilateral (to affected government)              |      18543380 |   231946788 |
| UN Agencies                                     |      15000000 |    21947001 |
| USDHHS                                          |      13000000 |           0 |
| UN Agencies, NGOs and Red Cross                 |      12711406 |   100055988 |
| UNICEF                                          |       7674990 |     1000000 |
| American RC                                     |       5385000 |     4541666 |
| UN Agencies and NGOs (details not yet provided) |       5200000 |    15052208 |
| IFRC                                            |       4470914 |           0 |
| NGOs                                            |       2613423 |     1000000 |
| ERF (OCHA)                                      |       2487305 |     8933495 |
| MSB                                             |       2431897 |           0 |
| WHO                                             |       2408000 |           0 |
| Various                                         |       1850000 |    12900000 |
| NCA                                             |       1733102 |           0 |
| PIH                                             |       1375000 |      525000 |
| Norway RC                                       |       1213172 |           0 |
| DEMA                                            |       1163476 |           0 |
| ICRC                                            |       1150505 |           0 |
| Direktoratet for samfunnssikkerhet og beredskap |       1126516 |           0 |
| MSF                                             |       1125000 |     1166667 |
| Finland RC                                      |       1082251 |           0 |
| IOM                                             |       1000000 |           0 |
| CRS                                             |       1000000 |     6000000 |
| CDERA                                           |        899281 |           0 |
| NRC                                             |        866551 |           0 |
| RC/Canada                                       |        828035 |           0 |
| ADRA-Haiti                                      |        809281 |           0 |
| Finnchurchaid                                   |        721501 |           0 |
| GTZ                                             |        721501 |           0 |
| RC/Sweden                                       |        687202 |           0 |
| Haiti Relief and Development Fund               |        500000 |           0 |
| BA                                              |        480000 |           0 |
| DRI                                             |        420000 |           0 |
| Oxfam America                                   |        400000 |           0 |
| CARITAS                                         |        374675 |           0 |
| GOAL                                            |        360750 |           0 |
| Danchurchaid                                    |        339609 |           0 |
| OCHA                                            |        291262 |           0 |
| FAO                                             |        250000 |           0 |
| HI                                              |        217657 |           0 |
| Ireland RC                                      |        180375 |           0 |
| Danish RC                                       |        145434 |           0 |
| CARE International                              |        144300 |       25000 |
| SC                                              |        139300 |      166667 |
| Muslim Aid                                      |        120000 |           0 |
| UNFPA                                           |        100000 |           0 |
| Plan                                            |        100000 |           0 |
| MCC                                             |        100000 |           0 |
| USAID                                           |         99572 |           0 |
| SC - Denmark                                    |         96957 |           0 |
| CHASE OT                                        |         96476 |           0 |
| ERB                                             |         92352 |           0 |
| OTM                                             |         72150 |           0 |
| Red Cross                                       |         72150 |      250000 |
| TSF                                             |         50000 |       25000 |
| Food for the Poor                               |         50000 |           0 |
| WV                                              |         50000 |           0 |
| NC/USA                                          |         50000 |           0 |
| BRCS                                            |         40000 |      163150 |
| Turkey RC                                       |             0 |           0 |
| RC/Iran                                         |             0 |           0 |
| NGOs; Red Cross                                 |             0 |     1650000 |
| Americares                                      |             0 |     5000000 |
| RCSC                                            |             0 |     1000000 |
| Spanish RC                                      |             0 |           0 |
| RC/Haiti                                        |             0 |           0 |
| LWF                                             |             0 |      150000 |
| Mercy Corps                                     |             0 |           0 |
| US Fund for UNICEF                              |             0 |      500000 |
| UN Agencies and Red Cross                       |             0 |      719942 |
| channel                                         |             0 |           0 |
| MCIC                                            |             0 |       96339 |
| PADF                                            |             0 |           0 |
| Plan UK                                         |             0 |     1600000 |
| Church of Sweden                                |             0 |      278940 |
+-------------------------------------------------+---------------+-------------+