home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

150 rows where Country/Location_Represented = "JAPAN" and State = "NY"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name >30

  • Association of Japanese Textile Imports, Inc. 15
  • Association Films, Inc. 9
  • Bossowick, Irving 9
  • Cosmo Public Relations 9
  • Wilbur F. Monroe Associates, Inc. 5
  • Hill and Knowlton Strategies, LLC 4
  • Forbes Research, Inc. 3
  • Kelly, Nason, Inc. 3
  • North American Precis Syndicate 3
  • Philip Van Slyck, Inc. 3
  • Daniel J. Edelman, Inc. 2
  • Geyer & Oswald, Inc. 2
  • Hill & Knowlton, Inc. 2
  • Marks, Matthew J. 2
  • Modern Education Services, Inc. 2
  • Murase, Jiro 2
  • NHK Cosmomedia America, Inc. 2
  • Quinn Gillespie & Associates, LLC 2
  • Sayers, Elliseva 2
  • APCO Worldwide LLC 1
  • Afridi, Angell & Pelletreau LLP 1
  • Alexander Strategy Group 1
  • Ansberry, Louise S. 1
  • Arter, Hadden & Hemmendinger 1
  • Barbara Burns & Associates, Inc. 1
  • Bell & Stanton, Inc. 1
  • Bozell & Jacobs Public Relations, Inc. 1
  • Burson-Marsteller 1
  • Caples Company 1
  • Coudert Brothers 1
  • …

Foreign_Principal >30

  • Japan Trade Center 13
  • JETRO, New York 6
  • Consulate General of Japan 5
  • Japan External Trade Organization (JETRO) 4
  • Consulate General of Japan in New York 3
  • Consulate General of Japan, New York 3
  • Government of Japan, Japan Trade Center 3
  • Hitachi America, Ltd. 3
  • Japan Tourist Association 3
  • Fujinon, Inc. 2
  • Japan External Trade Organization 2
  • Japan External Trade Organization (JETRO) New York 2
  • Japan Foundation 2
  • Japan Information Center 2
  • Japan National Tourist Organization 2
  • Japan Steel Information Center 2
  • Ajinomoto U.S.A., Inc. 1
  • Ambassador , Permanent Representative of Japan to the United Nations 1
  • Asahi Chemical Industry America, Inc. 1
  • Bank of Japan 1
  • Bank of Japan, New York Representative Office 1
  • Bank of Japan, New York Representative Office (as Agent of the Government of Japan) 1
  • C. Itoh & Company (America), Inc. 1
  • C. Itoh & Company (America), Inc. (Wholly Owned U.S. Subsidiary of C. Itoh & Company, Ltd.) 1
  • Camera Division, Japan Light Machinery Information Center 1
  • Capital Cities/ABC Video Enterprises, Inc. 1
  • Chugai Pharma U.S.A., Inc. 1
  • Consulat General of Japan 1
  • DCA Advertising, Inc. 1
  • Fuji Photo Film U.S.A., Inc. 1
  • …

City 2

  • - 140
  • New York 10

State 1

  • NY · 150 ✖

Country/Location_Represented 1

  • JAPAN · 150 ✖
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
127 127   Consulate General of Japan in New York 2021-03-30 JAPAN APCO Worldwide LLC 6582 2018-08-22 APCO Worldwide LLC 299 Park Avenue, Suite 19   New York NY 10171
128 128   Consulate General of Japan 2018-07-11 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 299 Park Avenue, 19th Floor   New York NY 10171
285 285   Government of Japan - Japan External Trade Organization 2017-04-19 JAPAN Prism Strategy, Inc. 6419 2017-04-19 Prism Strategy, Inc. 565 Fifth Avenue 4th Floor New York NY 10017
788 788 1963-01-01 Japan General Merchandise Exporters' Association 1962-03-07 JAPAN Forbes Research, Inc. 1197 1959-02-03 Forbes Research, Inc. New York     NY  
845 845 1982-01-01 Consulate General of Japan, New York 1979-03-05 JAPAN Philip S. Goodman, Inc. 3003 1979-03-05 Philip S. Goodman, Inc.       NY  
891 891 1987-01-01 Japan Trade Center 1987-02-16 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
910 910 1988-01-01 New Japan Securities International, Inc. 1986-11-26 JAPAN Wilbur F. Monroe Associates, Inc. 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. New York     NY  
1280 1280 1972-01-14 Japan National Tourist Organization 1966-01-14 JAPAN United World Films, Inc. 1952 1966-01-14 United World Films, Inc. New York     NY  
1333 1333 1990-01-15 DCA Advertising, Inc. 1989-08-01 JAPAN Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe New York     NY  
1704 1704 1979-01-31 Mitsubishi Trust & Banking Corporation 1977-11-25 JAPAN Hendricks, Marshall L. 2848 1977-11-25 Hendricks, Marshall L.       NY  
1780 1780 1994-01-31 Mitsubishi Gas Chemical America, Inc. 1992-12-23 JAPAN Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt New York     NY  
1805 1805 1996-01-31 Toyota Motor Corporate Services of North America 1992-07-27 JAPAN Van Ness, Feldman, A Professional Corporation 4696 1992-07-27 Van Ness, Feldman, A Professional Corporation New York     NY  
1818 1818 1998-01-31 JETRO, New York 1996-07-31 JAPAN IBC New York, Inc. 5125 1996-07-31 IBC New York, Inc. New York     NY  
1858 1858 2006-01-31 Government of Japan (Japan External Trade Organization) 2005-03-17 JAPAN Alexander Strategy Group 5557 2003-04-23 Alexander Strategy Group 1221 Avenue of the Americas New York 10020-1079     NY  
1991 1991 1979-02-01 Japan Trade Center 1971-12-15 JAPAN Ansberry, Louise S. 2297 1971-12-15 Ansberry, Louise S. New York     NY  
2092 2092 1967-02-02 Japan Trade Center, Japan External Trade Organization 1964-01-03 JAPAN Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. New York     NY  
2108 2108 1987-02-02 NYK Line 1985-08-02 JAPAN Rivkin, Radler, Dunne & Bayh 3711 1985-08-02 Rivkin, Radler, Dunne & Bayh New York     NY  
2129 2129 1961-02-03 Japan Tourist Association 1958-08-04 JAPAN Caples Company 34 1943-03-03 Caples Company New York     NY  
2276 2276 1979-02-08 Government of Japan, Japan Trade Center 1978-08-09 JAPAN Malmgren, Inc. 2854 1978-01-04 Malmgren, Inc. New York     NY  
2331 2331 1993-02-09 Japan Information Center 1992-10-13 JAPAN Barbara Burns & Associates, Inc. 4600 1991-12-06 Barbara Burns & Associates, Inc. New York     NY  
3000 3000 1995-02-28 Japan Information Center - Consulate General of Japan in New York 1991-08-27 JAPAN Robin Cohn & Company 4553 1991-08-09 Robin Cohn & Company New York     NY  
3219 3219 1963-03-01 Gosho Trading Company, Ltd. 1963-11-18 JAPAN Forbes Research, Inc. 1197 1959-02-03 Forbes Research, Inc. New York     NY  
3327 3327 2002-03-01 Japan External Trade Organization (JETRO) 1995-03-24 JAPAN JWI, LLC 4990 1995-02-06 JWI, LLC New York     NY  
3567 3567 2021-03-09 Consulate General of Japan in New York 2015-04-16 JAPAN Marathon Strategies, LLC 6289 2015-04-16 Marathon Strategies, LLC 299 Park Avenue   New York NY 10171
3825 3825 2012-03-16 Japan External Trade Organization (JETRO) New York 2012-07-26 JAPAN Quinn Gillespie & Associates, LLC 5753 2006-06-01 Quinn Gillespie & Associates, LLC 1221 Avenue of the Americas   New York NY 10020-1079
4038 4038 1974-03-25 Japan Trade Center 1971-12-07 JAPAN Japan Eyeware Information Service 2294 1971-12-07 Japan Eyeware Information Service New York     NY  
4062 4062 1986-03-26 Japan Trade Center 1968-06-03 JAPAN Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter New York     NY  
4158 4158 1982-03-30 Japan Trade Center 1981-06-01 JAPAN Tele-Press Associates, Inc. 2832 1977-09-30 Tele-Press Associates, Inc. New York     NY  
4340 4340 1971-03-31 Japan Trade Center 1971-04-15 JAPAN Bell & Stanton, Inc. 2054 1967-10-06 Bell & Stanton, Inc. New York     NY  
4352 4352 1975-03-31 Japan Steel Information Center 1970-04-22 JAPAN Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
4362 4362 1977-03-31 Japanese Information Service 1975-10-28 JAPAN Roger W. Noyes Associates, Inc. 2623 1975-10-28 Roger W. Noyes Associates, Inc. New York     NY  
4365 4365 1978-03-31 Government of Japan, Japan Trade Center 1977-12-30 JAPAN Marks, Matthew J. 2853 1977-12-30 Marks, Matthew J. New York     NY  
4432 4432 1987-03-31 Consulate General of Japan 1977-08-03 JAPAN Mass Communications, Inc. 2819 1977-08-03 Mass Communications, Inc. New York     NY  
4474 4474 1990-03-31 Bank of Japan, New York Representative Office 1978-09-21 JAPAN Wilbur F. Monroe Associates, Inc. 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. New York     NY  
4480 4480 1990-03-31 Consulate General of Japan 1987-09-09 JAPAN Michael Klepper Associates, Inc. 3128 1980-08-04 Michael Klepper Associates, Inc. New York     NY  
4488 4488 1990-03-31 Industrial Bank of Japan, Ltd. 1979-09-28 JAPAN Wilbur F. Monroe Associates, Inc. 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. New York     NY  
4504 4504 1991-03-31 Government of Japan 1991-04-18 JAPAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
4507 4507 1991-03-31 Japan Foundation 1981-07-30 JAPAN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.       NY  
4566 4566 1998-03-31 Japan External Trade Organization (JETRO) 1997-12-05 JAPAN Smith McCabe, Ltd. 4687 1992-06-26 Smith McCabe, Ltd. New York     NY  
4634 4634 2004-03-31 JETRO, New York 1987-01-06 JAPAN Michael Solomon Associates 3923 1987-01-06 Michael Solomon Associates New York     NY  
4697 4697 2009-03-31 Office of the Japanese Consul General 1993-10-25 JAPAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
4712 4712 2011-03-31 Japan External Trade Organization (JETRO) New York 2011-03-01 JAPAN Quinn Gillespie & Associates, LLC 5753 2006-06-01 Quinn Gillespie & Associates, LLC 1221 Avenue of the Americas   New York NY 10020-1079
4734 4734 2013-03-31 JETRO, New York 1996-07-02 JAPAN KWR International, Inc. 5119 1996-07-02 KWR International, Inc.     New York NY  
4765 4765 2017-03-31 Government of Japan/Japan External Trade Organization 2006-03-24 JAPAN MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 1221 Avenue of the Americas   New York NY 10020-1079
4899 4899 1986-04-01 Fujinon, Inc. 1985-05-21 JAPAN Daniel J. Piliero, II, P.C. 3680 1985-05-21 Daniel J. Piliero, II, P.C. Scarsdale     NY  
5000 5000 1980-04-03 Camera Division, Japan Light Machinery Information Center 1979-08-29 JAPAN Bozell & Jacobs Public Relations, Inc. 3052 1979-08-29 Bozell & Jacobs Public Relations, Inc. New York     NY  
5073 5073 1971-04-07 Japanese National Railways, New York Representative's Office 1964-11-23 JAPAN Murase, Jiro 1818 1964-11-23 Murase, Jiro New York     NY  
5074 5074 1971-04-07 Consulate General of Japan, New York 1964-11-23 JAPAN Murase, Jiro 1818 1964-11-23 Murase, Jiro New York     NY  
5076 5076 1978-04-07 Japan External Trade Center (JETRO) 1978-05-04 JAPAN Philip Van Slyck, Inc. 1991 1967-11-06 Philip Van Slyck, Inc. New York     NY  
5329 5329 1993-04-16 Consulate General of Japan, New York 1966-09-29 JAPAN Philip Van Slyck, Inc. 1991 1967-11-06 Philip Van Slyck, Inc. New York     NY  
5397 5397 1962-04-19 Consulate General of Japan 1957-05-31 JAPAN Smith, Alan Dexter 869 1955-01-31 Smith, Alan Dexter New York     NY  
5467 5467 1995-04-21 JETRO, New York 1986-08-11 JAPAN Dentsu Burson-Marsteller, Inc. 3861 1986-07-23 Dentsu Burson-Marsteller, Inc. New York     NY  
5508 5508 1979-04-24 Japan Trade Center 1979-05-17 JAPAN Wilbur F. Monroe Associates, Inc. 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. New York     NY  
5637 5637 1964-04-28 Japanese Chamber of Commerce of New York, Inc. 1964-04-28 JAPAN Economic Associates, Inc. 1718 1964-04-28 Economic Associates, Inc. New York     NY  
5754 5754 1994-04-29 Kanematsu U.S.A., Inc. 1993-05-04 JAPAN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. New York     NY  
5781 5781 1964-04-30 Japan Travel Bureau 1961-08-01 JAPAN Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
5816 5816 1982-04-30 Japan Trade Center 1982-01-28 JAPAN Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. New York     NY  
6493 6493 1945-05-13 Morimura Brothers Employees' Benefit Fund 1942-11-13 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6494 6494 1945-05-13 Hango Sumii 1942-11-13 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6495 6495 1945-05-13 Itsuyo Nakayama 1943-05-21 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6496 6496 1945-05-13 J. Tomohiko Midzuno 1942-11-13 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6497 6497 1945-05-13 Kazue Sumii 1942-11-13 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6498 6498 1945-05-13 Kohji Katoh 1942-11-13 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6499 6499 1945-05-13 Morimura Brothers, Inc. 1942-11-13 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6500 6500 1945-05-13 Takeo Nakayama 1943-05-21 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6501 6501 1945-05-13 Yonosuke Maenami 1942-11-13 JAPAN Bossowick, Irving 157 1942-11-13 Bossowick, Irving New York     NY  
6561 6561 1987-05-15 Keizaikai Company, Ltd. 1987-02-09 JAPAN Burson-Marsteller 2469 1973-10-23 Burson-Marsteller New York     NY  
6604 6604 1986-05-16 Fujinon, Inc. 1985-05-16 JAPAN Marks, Murase & White 3419 1982-11-04 Marks, Murase & White Scarsdale     NY  
6666 6666 1986-05-20 Nomura Securities International, Inc. 1985-11-20 JAPAN Wilbur F. Monroe Associates, Inc. 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. New York     NY  
6880 6880 1956-05-28 Masato Yamamoto (Japan External Trade Recovery Organization, Japan Trade Center) 1956-05-28 JAPAN Sayers, Elliseva 953 1956-05-28 Sayers, Elliseva New York     NY  
6881 6881 1956-05-28 S. Tomioka (Central Raw Silk Association of Japan) 1956-05-28 JAPAN Sayers, Elliseva 953 1956-05-28 Sayers, Elliseva New York     NY  
6943 6943 1987-05-30 Japan External Trade Organization (JETRO) 1985-01-29 JAPAN Craig J. Spence & Associates 3646 1985-01-29 Craig J. Spence & Associates       NY  
6966 6966 1989-05-30 Japan Trade Center 1988-08-18 JAPAN Government Research Corporation 4170 1988-08-18 Government Research Corporation New York     NY  
7051 7051 1979-05-31 Japan Foundation 1980-01-24 JAPAN Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
7092 7092 1991-05-31 Asahi Chemical Industry America, Inc. 1990-12-07 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7095 7095 1991-05-31 Chugai Pharma U.S.A., Inc. 1990-11-13 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7110 7110 1991-05-31 Kyowa Hakko U.S.A., Inc. 1990-11-13 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7112 7112 1991-05-31 Meiji Seika (U.S.A.), Inc. 1990-11-29 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7115 7115 1991-05-31 Sankyo U.S.A. Corporation 1990-11-13 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7121 7121 1991-05-31 Takeda U.S.A., Inc. 1990-11-23 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations Orangeburg     NY  
7123 7123 1991-05-31 Teijin America, Inc. 1990-11-29 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7124 7124 1991-05-31 Toray Industries (America), Inc. 1990-12-17 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7131 7131 1991-05-31 Zeria U.S.A., Inc. 1990-12-17 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations New York     NY  
7652 7652 1991-06-07 Japan External Trade Relations Organization 1989-05-31 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
7989 7989 1991-06-21 Yendo Associates, Inc. 1991-03-26 JAPAN Prather, Seeger, Doolittle & Farmer 1815 1964-11-13 Prather, Seeger, Doolittle & Farmer New York     NY  
8033 8033 1992-06-23 Japan Information Center 1991-09-17 JAPAN Omega Group 4564 1991-09-17 Omega Group New York     NY  
8145 8145 2002-06-28 Japan External Trade Organization 1998-02-04 JAPAN Afridi, Angell & Pelletreau LLP 5231 1998-02-04 Afridi, Angell & Pelletreau LLP New York     NY  
8263 8263 1968-06-30 Consulate General of Japan 1962-01-17 JAPAN Murden & Company, Inc. 1510 1962-01-17 Murden & Company, Inc. New York     NY  
8368 8368 1983-06-30 Japan Trade Center 1968-06-03 JAPAN Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger New York     NY  
8442 8442 1989-06-30 Komatsu Electronic Metals 1988-12-31 JAPAN IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc New York     NY  
8737 8737 2016-06-30 JETRO, New York 1998-12-02 JAPAN Global Policy Group, Inc. 5290 1998-12-02 Global Policy Group, Inc. New York     NY  
8738 8738 2016-06-30 JETRO, New York 2010-12-28 JAPAN Washington Research & Analysis, LLC 6013 2010-12-28 Washington Research & Analysis, LLC 1221 Avenue of the Americas 42nd Floor New York NY 10020
8836 8836 1972-07-01 Bank of Japan, New York Representative Office (as Agent of the Government of Japan) 1965-01-11 JAPAN Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy New York     NY  
9057 9057 1965-07-07 Japan Tourist Association 1961-08-01 JAPAN Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
9134 9134 1982-07-09 Japan Whaling Association 1980-05-21 JAPAN North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
9426 9426 1988-07-22 Hitachi America, Ltd. 1985-06-21 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Tarrytown     NY  
9449 9449 1979-07-23 Government of Japan, Japan Trade Center 1978-08-02 JAPAN Marks, Matthew J. 2940 1978-08-02 Marks, Matthew J. New York     NY  
9679 9679 1964-07-31 Japan Tourist Association 1960-03-03 JAPAN Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9680 9680 1964-07-31 Japan Trade Center/Japan Camera Information & Service Center 1956-04-13 JAPAN Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9681 9681 1964-07-31 Japan Travel Information Office/Japan Travel Bureau 1953-09-18 JAPAN Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. New York     NY  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);
Powered by Datasette · Queries took 307.275ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows